Current File : /home/giriqfky/public_html/Barga/application/modules/dashboard/models//Dashboard_model.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Dashboard_model extends CI_Model
{
var $table_app_users = TABLE_APP_USERS;
var $table_job_posts = TABLE_JOB_POSTS;
var $table_notifications = TABLE_NOTIFICATIONS;
var $table_app_registrations = TABLE_APP_REGISTRATIONS;
var $table_membership_packages = TABLE_MEMBERSHIP_PACKAGES;
var $table_app_user_addresses = TABLE_APP_USER_ADDRESSES;
public function __construct()
{
parent::__construct();
}
/** Dashboard start**/
public function getTotalActiveJobs()
{
$this->db->select('COUNT(*) AS tot_job');
$this->db->where(array('job_post_status'=>1));
$count_data = $this->db->get($this->table_job_posts)->row();
return $count_data->tot_job;
}
public function getTotalCustomer()
{
$this->db->select('COUNT(*) AS tot_member');
$this->db->where(array('app_user_type'=>1));
$count_data = $this->db->get($this->table_app_users)->row();
return $count_data->tot_member;
}
public function getTotalServiceProvider()
{
$this->db->select('COUNT(*) AS tot_member');
$this->db->where(array('app_user_type'=>2));
$count_data = $this->db->get($this->table_app_users)->row();
return $count_data->tot_member;
}
public function getTotalActivePackages()
{
$this->db->select('COUNT(*) AS tot_package');
$this->db->where(array('status'=>1));
$count_data = $this->db->get($this->table_membership_packages)->row();
return $count_data->tot_package;
}
public function getTotalRegisteredDevices()
{
$this->db->select('COUNT(*) AS tot_device');
$count_data = $this->db->get($this->table_app_registrations)->row();
return $count_data->tot_device;
}
public function getJobList($params = array()){
$this->db->select('p.*,
c.user_profile_name,c.user_mobile,s.user_profile_name,s.user_mobile,ad.*');
$this->db->from($this->table_job_posts.' p');
$this->db->join($this->table_app_users.' c','c.app_user_id = p.customer_id','LEFT');
$this->db->join($this->table_app_users.' s','s.app_user_id = p.service_provider_id','LEFT');
$this->db->join($this->table_app_user_addresses.' ad','ad.app_address_id = p.app_address_id','LEFT');
// if(!empty($params['search']['customer'])){
// $this->db->like('c.user_profile_name',$params['search']['customer']);
// $this->db->or_like('c.user_mobile',$params['search']['customer']);
// }
// if(!empty($params['search']['service_provider'])){
// $this->db->like('s.user_profile_name',$params['search']['service_provider']);
// $this->db->or_like('s.user_mobile',$params['search']['service_provider']);
// }
if(!empty($params['search']['service_id'])){
$this->db->where('p.service_id',$params['search']['service_id']);
}
// if(!empty($params['search']['job_post_date_from'])){
// $job_post_date_from = getDateFromDatepicker($params['search']['job_post_date_from']);
// $this->db->where("p.doc >= '".date($job_post_date_from)."'");
// }
// if(!empty($params['search']['job_post_date_to'])){
// $job_post_date_to = getDateFromDatepicker($params['search']['job_post_date_to']);
// $this->db->where("p.doc <= '".date($job_post_date_to)."23:59:59'");
// }
// if(!empty($params['search']['job_expiring_date_from'])){
// $job_expiring_date_from = getDateFromDatepicker($params['search']['job_expiring_date_from']);
// $this->db->where("p.job_expiry_date >= '".date($job_expiring_date_from)."'");
// }
// if(!empty($params['search']['job_expiring_date_to'])){
// $job_expiring_date_to = getDateFromDatepicker($params['search']['job_expiring_date_to']);
// $this->db->where("p.job_expiry_date <= '".date($job_expiring_date_to)."'");
// }
// if(!empty($params['search']['area_locality'])){
// $this->db->like('ad.building_no',$params['search']['area_locality']);
// $this->db->or_like('ad.street_name',$params['search']['area_locality']);
// $this->db->or_like('ad.locality',$params['search']['area_locality']);
// $this->db->or_like('ad.landmark',$params['search']['area_locality']);
// $this->db->or_like('ad.pin_code',$params['search']['area_locality']);
// $this->db->or_like('ad.city',$params['search']['area_locality']);
// $this->db->or_like('ad.state',$params['search']['area_locality']);
// }
// if(!empty($params['search']['job_post_code'])){
// $this->db->where('p.job_post_code',$params['search']['job_post_code']);
// }
$this->db->where("p.doc >='".date('Y-m-d')." 00:00:00'");
$this->db->where("p.doc <= '".date('Y-m-d')." 23:59:59'");
$this->db->order_by('p.doc','DESC');
//set start and limit
if(array_key_exists("start",$params) && array_key_exists("limit",$params)) {
$this->db->limit($params['limit'],$params['start']);
} elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params)) {
$this->db->limit($params['limit']);
}
return $this->db->get()->result();
}
/** Dashboard End **/
}