ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/api/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/api/application/models/Counselor_model.php |
<?php
class Counselor_model extends CI_Model {
function lists($all=false){
$qs=trim_array($this->input->get());
$this->db->where_in("U.type", array('CALLER'));
if(USER_TYPE == 'CALLER_MANAGER' || USER_TYPE == 'CALLER'){
$this->db->where("U.parent_id", USER_ID);
}
if($qs['parent_id']){
$this->db->where("U.parent_id", $qs['parent_id']);
}
if($qs['k']){
$this->db->group_start()
->like('U.name', $qs['k'])
->or_like('U.email', $qs['k'])
->group_end();
}
$this->db->select("U.id, U.username, U.name, U.email, U.data_set_id, U.status, DS.title data_set, SD.no_of_leads ds_no_of_leads, C_M.name caller_manager, U1.name usr")
->from("users U")
->join("leads_data_sets DS", "U.data_set_id=DS.id", "LEFT")
->join("users C_M", "U.parent_id=C_M.id", "LEFT")
->join("users U1", "U.created_by=U1.id")
->join("data_set_split_dtl SD", "SD.user_id=U.id", "LEFT")
->group_by("U.id")
->order_by("U.name");
if($all){
return $this->db->get()->result_array();
}
$rs=$this->dba->pagedRows($qs['p'], 100, 5);
return $rs;
}
function caller_managers(){
if(USER_TYPE == 'CALLER_MANAGER' || USER_TYPE == 'CALLER'){
$this->db->where("id", USER_ID);
}
$this->db->where(array('type'=>'CALLER_MANAGER', 'status'=>1));
$rs=$this->db->select("id, name")->get("users")->result_array();
return $rs;
}
function detail($id, $f="*"){
$rs=$this->db->select($f)->get_where("users", array('id'=>$id))->row_array();
if($rs){
if(!$rs['data_set_id']){
$rs['data_set_id']='';
}
$rs['splitDatasetHistory']=$this->dataset->splitDatasetHistory($rs['id']);
}
unset($rs['password']);
return $rs;
}
function delete($id){
$this->db->db_debug=FALSE;
return $this->db->delete("users", array('id'=>$id));
}
function system_modules($grp=[]){
$rs=[];
if(USER_TYPE == 'ADMIN' || USER_TYPE == 'USER'){
if($grp){
$this->db->where_in('grp', $grp);
}
$rs=$this->db->get("system_modules")->result_array();
}else{
$modules=$this->db->select("modules")->get_where("users", array('id'=>USER_ID))->row()->modules;
if($modules){
$modules=explode(",", $modules);
$rs=$this->db->where_in("id", $modules)->get("system_modules")->result_array();
}
}
return $rs;
}
}
//End of file
Kontol Shell Bypass