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/Lf_model.php |
<?php
class Lf_model extends CI_Model {
function lists($export=FALSE, $byyouonly=FALSE){
$qs=trim_array($this->input->get());
if($byyouonly){
$users=$this->user->active_users(true);
$ids=[];
foreach($users as $u){
$ids[]=$u['id'];
}
$this->db->where_in("AR.created_by", $ids);
}
if($qs['created_by']){
$this->db->where("AR.created_by", $qs['created_by']);
}
if($qs['k']){
$this->db->group_start()
->like('LR.title', $qs['k'])
->or_like('A.name', $qs['k'])
->or_like('A.email', $qs['k'])
->or_like('A.mob', $qs['k'])
->or_like('A.application_no', $qs['k'])
->group_end();
}
if($qs['cat_id']){
$this->db->where_in("LR.cat_id", $qs['cat_id']);
}
if($qs['remarks_id']){
$this->db->where_in("AR.remarks_id", $qs['remarks_id']);
}
if($qs['fromDate']){
$this->db->where("AR.created >=", date('Y-m-d', strtotime($qs['fromDate'])));
}
if($qs['toDate']){
$this->db->where("AR.updated <=", date('Y-m-d 23:59:59', strtotime($qs['toDate'])));
}
$this->db->select("AR.id, AR.applicant_id, AR.created, AR.updated, LR.title remarks, AR.subremarks, AR.feedback, U.name usr, A.name, A.email, A.mob, A.application_no, P.title program")
->from("applicants_remarks AR")
->join("master_lead_remarks LR", "LR.id=AR.remarks_id")
->join("applicants A", "A.id=AR.applicant_id AND AR.id=A.last_followup_id")
->join("master_programs P", "P.id=A.program_id")
->join("users U", "AR.created_by=U.id")
->order_by("AR.id", "DESC");
$ps=50;
if($export){
$ps=100000;
}
$rs=$this->dba->pagedRows($qs['p'], $ps, 5, $export?'0':'');
foreach($rs['result'] as &$r){
$r['created']=get_date($r['created'], true);
$r['feedback']=encode_script(nl2br($r['feedback']));
}
return $rs;
}
function detail($id){
$rs=$this->db->select("LR.title remarks, AR.feedback")->from("applications_remarks AR")->join("master_lead_remarks LR", "LR.id=AR.remarks_id")->where("AR.id", $id)->get()->row_array();
return $rs;
}
function delete($id){
$this->db->db_debug=FALSE;
return $this->db->delete("applications_remarks", array('id'=>$id));
}
/** Remarks */
function remarks(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('R.title', $qs['k'])->or_like('C.title', $qs['k']);
}
if($qs['cat_id']){
$this->db->where('R.cat_id', $qs['cat_id']);
}
$rs=$this->db->select("R.id, R.cat_id, R.title, R.disp_odr, R.status, C.title cat")
->from("master_lead_remarks R")
->join('master_lead_remarks_cats C','R.cat_id=C.id','left')
->order_by("R.disp_odr")
->get()->result_array();
foreach($rs as &$r){
$r['subremarks']=$this->db->select("title")->order_by("disp_odr")->get_where("master_lead_subremarks", array('remarks_id'=>$r['id']))->result_array();
}
return $rs;
}
function remarkDetail($id){
$rs=$this->db->get_where("master_lead_remarks", array('id'=>$id))->row_array();
$rs['subremarks']=$this->db->order_by("disp_odr")->get_where("master_lead_subremarks", array('remarks_id'=>$id))->result_array();
return $rs;
}
function deleteRemark($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_lead_remarks", array('id'=>$id));
}
function remarks_cats(){
return $this->db->select('*')->from('master_lead_remarks_cats')->order_by('disp_odr')->get()->result_array();
}
function deleteRemarkCat($id){
$this->db->db_debug=FALSE;
$this->db->delete("master_lead_remarks_cats", array('id'=>$id));
return $this->db->affected_rows();
}
}
//End of file
Kontol Shell Bypass