ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/lms/lms/api/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/lms/lms/api/application/models/User_model.php |
<?php
class User_model extends CI_Model {
function lists($myUsersOnly=false){
$qs=trim_array($this->input->get());
if($myUsersOnly){
$this->db->where("U.parent_id", USER_ID);
}
if($qs['type']){
$this->db->where("U.type", $qs['type']);
}else{
$this->db->where_in("U.type", ['USER', 'CALLER_MANAGER', 'REGIONAL_OFFICER']);
}
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.username', $qs['k'])
->or_like('U.email', $qs['k'])
->group_end();
}
$f="U.id, U.username, U.name, U.email, U.type, U.reporting_type, U.status, U.created, U.data_set_id, U.whatsapp_instance, P.name parent, U1.name usr";
//DS.title data_set, GROUP_CONCAT(DS1.title SEPARATOR ' ~ ') split_ds_names, GROUP_CONCAT(SD.no_of_leads SEPARATOR ' ~ ') split_ds_no_of_leads";
$this->db->select($f)
->from("users U")
->join("users P", "U.parent_id=P.id", "LEFT")
->join("users U1", "U.created_by=U1.id", "LEFT")
//->join("leads_data_sets DS", "U.data_set_id=DS.id", "LEFT")
//->join("data_set_split_dtl SD", "SD.user_id=U.id", "LEFT")
//->join("leads_data_sets DS1", "DS1.id=SD.data_set_id", "LEFT")
//->group_by("U.id")
->order_by("U.name");
$rs=$this->dba->pagedRows($qs['p'], 50, 5);
if($rs['result']){
$r['created']=get_date($r['created']);
foreach($rs['result'] as &$r){
//$r['data_sets']=$this->user_data_sets($r);
}
}
return $rs;
}
function active_users($child=false, $type=''){
if($child){
$this->db->group_start()
->where("parent_id", USER_ID)->or_where("id", USER_ID)
->group_end();
}
if($type){
$this->db->where("type", $type);
}
return $this->db->select("id, name, type")->from("users")->where("status", 1)->order_by("name")->get()->result_array();
}
function all_users(){
return $this->db->select("id,name,type,status")->from("users")->order_by("name")->get()->result_array();
}
function regional_officers(){
if(USER_TYPE == 'REGIONAL_OFFICER'){
$this->db->where("id", USER_ID);
}
$this->db->where(array('type'=>'REGIONAL_OFFICER', 'status'=>1));
$rs=$this->db->select("id, name")->get("users")->result_array();
return $rs;
}
function all_managers(){
$f="id, name, type";
$rs=$this->db->select($f)->where(['status'=>1])->where_in("type", ['CONSULTANT_MANAGER', 'RO_MANAGER', 'CAMPUS_MANAGER', 'CALLER_MANAGER'])->get("users")->result_array();
if($ds){
foreach($rs as &$r){
//$r['data_sets']=$this->user_data_sets($r);
}
}
return $rs;
}
function detail($id, $f="*"){
$rs=$this->db->select($f)->get_where("users", array('id'=>$id))->row_array();
if($rs){
$rs['parent_id']=$rs['parent_id']?$rs['parent_id']:'';
$modulesNames=$this->db->from("system_modules")->where_in("id", explode(",", $rs['modules']))->order_by("grp")->order_by("module")->get()->result_array();
$rs['module_names']=$modulesNames?$modulesNames:[];
$lastLoginTime=$this->db->select()->order_by("id", "desc")->limit(1)->get_where("user_login_history", ['user_id'=>$rs['id']])->row("login_time");
$rs['last_login_time']=get_date($lastLoginTime, true);
unset($rs['password']);
}
return $rs;
}
function user_data_sets($udtl, $user_id=0, $from_date='', $to_date=''){
if($user_id){
$udtl=$this->db->select("*")->get_where("users", array('id'=>$user_id))->row_array();
}
$data_sets=[];
foreach(['', 2, 3, 4, 5] as $n){
if($udtl['data_set_id'.$n]){
$lc=$this->common->data_set_leads_count($udtl['data_set_id'.$n], false, $from_date, $to_date);
$dsname=$this->db->select("title")->get_where("leads_data_sets", ['id'=>$udtl['data_set_id'.$n]])->row()->title;
$data_sets[]=[
'id'=>$udtl['data_set_id'.$n],
'title'=>$dsname?$dsname:'[No Name]',
'leads_count'=>$lc['n'],
'filters_used'=>$lc['filters'],
];
}
}
return $data_sets;
}
function delete($id){
$this->db->db_debug=FALSE;
return $this->db->delete("users", array('id'=>$id));
}
/* function system_modules($grp=[]){
if($grp){
$this->db->where_in('grp', $grp);
}
return $this->db->get("system_modules")->result_array();
} */
function data_set_users(){
return $this->db->select("data_set_id, name, type")->order_by("name")->get_where("users", ['data_set_id >'=>0, 'type!='=>'PUBLISHER'])->result_array();
}
function system_modules_groups(){
$rs=$this->db->select("distinct grp", false)->where('grp!=', '')->order_by("grp")->get("system_modules")->result_array();
$rs[]=['grp'=>'Others'];
return $rs;
}
function system_modules($grp=[]){
if($grp){
$this->db->where_in('grp', $grp);
}
return $this->db->select("*, IF(grp='', 'Others', grp) grp", false)->get("system_modules")->result_array();
}
}
//End of file
Kontol Shell Bypass