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/Issues_model.php |
<?php
class Issues_model extends CI_Model {
function lists($onlyPeopleSoft=0){
$this->common->set_data_set_cond(false, false);
$qs=trim_array($this->input->get());
if($onlyPeopleSoft || $qs['is_peoplesoft']){
$this->db->where("I.is_peoplesoft", 1);
}
$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['applicant_id']){
$this->db->where("I.applicant_id", $qs['applicant_id']);
}
if($qs['step_completed']){
$this->db->where_in("A.step_completed", explode(",", $qs['step_completed']));
}
$f="I.id, I.cat, I.issue, I.file, I.description, I.is_peoplesoft, I.created, I.status, I.close_date, U.name, U.email, U.mob, U.state_id, A.id app_id,
A.application_no, A.step_completed, PP.title plan, P.title program, AC.title ac";
$this->db->select($f)
->from("applications A")
->join("applicants U", "U.id=A.applicant_id")
->join("issues_reported I", "I.applicant_id=U.id")
->join("master_program_plans PP", "PP.id=A.plan_id")
->join("master_programs P", "P.id=PP.program_id")
->join("master_academic_careers AC", "AC.id=P.ac_id")
->order_by("I.id", "DESC");
$rs=$this->dba->pagedRows($qs['p'], 100, 5);
$states=$this->db->select("id,code,title")->get("master_states")->result_array();
$md['states']=key_val_array($states, 'id', 'title');
foreach($rs['result'] as &$r){
$r['state']=$md['states'][$r['state_id']];
$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['is_peoplesoft']=(int)$r['is_peoplesoft'];
$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){
$f="I.id, I.cat, I.issue, I.file, I.description, I.created, I.status, I.close_date, U.name, U.email, U.mob, U.state_id, A.id app_id, A.application_no,
A.step_completed, PP.title plan, P.title program, AC.title ac";
$dtl=$this->db->select($f)
->from("issues_reported I")
->join("applicants U", "U.id=I.applicant_id")
->join("applications A", "U.id=A.applicant_id")
->join("master_program_plans PP", "PP.id=A.plan_id")
->join("master_programs P", "P.id=PP.program_id")
->join("master_academic_careers AC", "AC.id=P.ac_id")
->where("I.id", $id)
->get()->row_array();
if($dtl){
$states=$this->db->select("id,code,title")->get("master_states")->result_array();
$md['states']=key_val_array($states, 'id', 'title');
$dtl['state']=$md['states'][$dtl['state_id']];
$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]";
}
}
if($dtl['step_completed']==3){
$dtl['ps_app']=$this->leads->ps_stu_status($dtl['application_no']);
if(!$dtl['ps_app']){
$dtl['ps_app']=false;
}
}
}
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;
}
}
Kontol Shell Bypass