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/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);
}
$this->common->set_data_set_cond(false, false);
if($byyouonly){
$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('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['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'])));
}
if(strlen($qs['followup_count'])){
if($qs['followup_count']=='3+'){
$this->db->where("A.followup_count>", 3);
}else{
$this->db->where("A.followup_count", $qs['followup_count']);
}
}
if($qs['step_completed']){
$this->db->where_in("A.step_completed", explode(",", $qs['step_completed']));
}
if($qs['state_ids']){
$this->db->where_in("U.state_id", explode(",", $qs['state_ids']));
}
if($qs['med_phd']==1){
$this->db->where("U.is_medical", 1);
}elseif($qs['med_phd']==2){
$this->db->where("U.is_phd", 1);
}elseif($qs['med_phd']==3){
$this->db->where(["U.is_medical"=>0, "U.is_phd"=>0]);
}
/*
AR.id, AR.application_id, AR.created, AR.updated, LR.title remarks, AR.subremarks, AR.feedback, AR.comm_mode,
U1.name usr,
*/
$f="A.last_followup_id, AR.application_id,
U.name, U.email, U.mob, U.state_id, U.father_name, U.gender, U.dob, A.application_no, A.step_completed,
A.step_completed, A.followup_count_all, A.isdead, A.next_followup, 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("applications A", "A.id=AR.application_id AND AR.id=A.last_followup_id")
->join("applications_remarks AR", "A.id=AR.application_id")
->join("master_lead_remarks LR", "LR.id=AR.remarks_id")
->join("master_program_plans PP", "PP.id=A.plan_id", "LEFT")
->join("master_programs P", "P.id=PP.program_id", "LEFT")
->join("master_academic_careers AC", "AC.id=P.ac_id", "LEFT")
//->join("users U1", "AR.created_by=U1.id", "LEFT")
->group_by("A.id")
->order_by("AR.id", "DESC");
//echo $this->db->get_compiled_select(); die;
$ps=50;
if($export){
$ps=100000;
}
$rs=$this->dba->pagedRows($qs['p'], $ps, 5, $export?'0':'');
$md=$this->common->master_data_for_leads();
foreach($rs['result'] as &$r){
$r['state']=$md['states'][$r['state_id']];
$r['created']=get_date($r['created']);
$r['updated']=get_date($r['updated']);
$r['feedback']=encode_script(nl2br($r['feedback']));
$f="AR.id, AR.created, AR.updated, LR.title remarks, AR.subremarks, AR.feedback, AR.comm_mode, SU.name usr";
$r['remark']=$this->db->select($f)
->from("applications_remarks AR")
->join("master_lead_remarks LR", "LR.id=AR.remarks_id")
->join("users SU", "AR.created_by=SU.id")
->where("AR.id", $r['last_followup_id'])
->get()->row_array();
$r['remark']['created']=get_date($r['remark']['created']);
$r['remark']['updated']=get_date($r['remark']['updated']);
$r['remark']['feedback']=encode_script(nl2br($r['remark']['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.isfollowup, 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['isfollowup']=(int)$r['isfollowup'];
$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();
}
/** Sent Emails */
function lists_sent_emails($export=FALSE, $byyouonly=FALSE){
$qs=trim_array($this->input->get());
if($byyouonly){
$users=$this->user->active_users(true);
}
$this->common->set_data_set_cond(false, false);
if($byyouonly){
$ids=[];
foreach($users as $u){
$ids[]=$u['id'];
}
$this->db->where_in("SE.created_by", $ids);
}
if($qs['created_by']){
$this->db->where("SE.created_by", $qs['created_by']);
}
if($qs['k']){
$this->db->group_start()
->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['fromDate']){
$this->db->where("SE.created >=", date('Y-m-d', strtotime($qs['fromDate'])));
}
if($qs['toDate']){
$this->db->where("SE.created <=", date('Y-m-d 23:59:59', strtotime($qs['toDate'])));
}
if($qs['step_completed']){
$this->db->where_in("A.step_completed", explode(",", $qs['step_completed']));
}
if($qs['state_ids']){
$this->db->where_in("U.state_id", explode(",", $qs['state_ids']));
}
if($qs['is_letter']){
$this->db->where("SE.is_letter", 1);
}else{
$this->db->where("SE.is_letter", 0);
}
$this->db->select("A.id, A.created, U.name, U.email, U.mob, U.state_id, U.father_name, U.gender, U.dob, A.application_no, A.step_completed, A.ac_id, A.program_id, A.plan_id, A.followup_count_all, A.isdead")
->from("applications A")
->join("applicants U", "U.id=A.applicant_id")
->join("sent_emails SE", "SE.to_email=U.email")
->group_by("A.id")
->order_by("SE.created", "DESC");
$ps=50;
if($export){
$ps=100000;
}
$rs=$this->dba->pagedRows($qs['p'], $ps, 5, $export?'0':'');
if($rs['result']){
$md=$this->common->master_data_for_leads();
foreach($rs['result'] as &$r){
$r['state'] =$md['states'][$r['state_id']];
$r['lpage'] =$md['lpages'][$r['lpage_id']];
$r['ac'] =$md['acs'][$r['ac_id']];
$r['program'] =$md['programs'][$r['program_id']];
$r['plan'] =$md['plans'][$r['plan_id']];
$r['created'] =get_date($r['created']);
$r['sent_emails']=$this->leads->get_sent_emails($r['email'], false, $qs['is_letter']);
}
}
return $rs;
}
/** Sent SMS */
function lists_sent_sms($export=FALSE, $byyouonly=FALSE){
$qs=trim_array($this->input->get());
if($byyouonly){
$users=$this->user->active_users(true);
}
$this->common->set_data_set_cond(false, false);
if($byyouonly){
$ids=[];
foreach($users as $u){
$ids[]=$u['id'];
}
$this->db->where_in("SE.created_by", $ids);
}
if($qs['created_by']){
$this->db->where("SE.created_by", $qs['created_by']);
}
if($qs['k']){
$this->db->group_start()
->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['fromDate']){
$this->db->where("SE.created >=", date('Y-m-d', strtotime($qs['fromDate'])));
}
if($qs['toDate']){
$this->db->where("SE.created <=", date('Y-m-d 23:59:59', strtotime($qs['toDate'])));
}
if($qs['step_completed']){
$this->db->where_in("A.step_completed", explode(",", $qs['step_completed']));
}
if($qs['state_ids']){
$this->db->where_in("U.state_id", explode(",", $qs['state_ids']));
}
$this->db->select("A.id, A.created, U.name, U.email, U.mob, U.state_id, U.father_name, U.gender, U.dob, A.application_no, A.step_completed, A.ac_id, A.program_id, A.plan_id, A.followup_count_all, A.isdead")
->from("applications A")
->join("applicants U", "U.id=A.applicant_id")
->join("followup_sent_sms SE", "SE.application_id=A.id")
->group_by("A.id")
->order_by("SE.created", "DESC");
$ps=50;
if($export){
$ps=100000;
}
$rs=$this->dba->pagedRows($qs['p'], $ps, 5, $export?'0':'');
if($rs['result']){
$md=$this->common->master_data_for_leads();
foreach($rs['result'] as &$r){
$r['state'] =$md['states'][$r['state_id']];
$r['lpage'] =$md['lpages'][$r['lpage_id']];
$r['ac'] =$md['acs'][$r['ac_id']];
$r['program'] =$md['programs'][$r['program_id']];
$r['plan'] =$md['plans'][$r['plan_id']];
$r['created'] =get_date($r['created']);
$r['sent_sms']=$this->leads->get_sent_sms($r['id']);
}
}
return $rs;
}
/** Dead Leads */
function lists_dead_leads($export=FALSE, $byyouonly=FALSE){
$qs=trim_array($this->input->get());
if($byyouonly){
$users=$this->user->active_users(true);
}
$this->common->set_data_set_cond(false, false);
if($byyouonly){
$ids=[];
foreach($users as $u){
$ids[]=$u['id'];
}
$this->db->where_in("A.created_by", $ids);
}
if($qs['created_by']){
$this->db->where("A.created_by", $qs['created_by']);
}
if($qs['k']){
$this->db->group_start()
->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['fromDate']){
$this->db->where("A.created >=", date('Y-m-d', strtotime($qs['fromDate'])));
}
if($qs['toDate']){
$this->db->where("A.created <=", date('Y-m-d 23:59:59', strtotime($qs['toDate'])));
}
if($qs['step_completed']){
$this->db->where_in("A.step_completed", explode(",", $qs['step_completed']));
}
if($qs['state_ids']){
$this->db->where_in("U.state_id", explode(",", $qs['state_ids']));
}
$this->db->select("A.id, A.created, U.name, U.email, U.mob, U.state_id, U.father_name, U.gender, U.dob, A.application_no, A.step_completed, A.ac_id, A.program_id, A.plan_id, A.followup_count_all, A.isdead")
->from("applications A")
->join("applicants U", "U.id=A.applicant_id")
->where("A.isdead", "Y")
->order_by("A.id", "DESC");
$ps=50;
if($export){
$ps=100000;
}
$rs=$this->dba->pagedRows($qs['p'], $ps, 5, $export?'0':'');
if($rs['result']){
$md=$this->common->master_data_for_leads();
foreach($rs['result'] as &$r){
$r['state'] =$md['states'][$r['state_id']];
$r['lpage'] =$md['lpages'][$r['lpage_id']];
$r['ac'] =$md['acs'][$r['ac_id']];
$r['program'] =$md['programs'][$r['program_id']];
$r['plan'] =$md['plans'][$r['plan_id']];
$r['created'] =get_date($r['created']);
}
}
return $rs;
}
/** Webinar Participants */
function webinar_participants(){
$qs=trim_array($this->input->get());
$this->common->set_data_set_cond(false, false);
if($qs['k']){
$this->db->group_start()
->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['fromDate']){
$this->db->where("WB.web_date >=", date('Y-m-d', strtotime($qs['fromDate'])));
}
if($qs['toDate']){
$this->db->where("WB.web_date <=", date('Y-m-d 23:59:59', strtotime($qs['toDate'])));
}
if($qs['step_completed']){
$this->db->where_in("A.step_completed", explode(",", $qs['step_completed']));
}
if($qs['state_ids']){
$this->db->where_in("U.state_id", explode(",", $qs['state_ids']));
}
if($qs['webinar_id']){
$this->db->where_in("WL.webinar_id", explode(",", $qs['webinar_id']));
}
$this->db->select("A.id, A.created, U.name, U.email, U.mob, U.state_id, U.father_name, U.gender, U.dob, A.application_no, A.step_completed, A.ac_id, A.program_id, A.plan_id, A.followup_count_all, A.isdead, WL.accepted_on, WL.accepted_mod, WL.inv_email_sent, WB.title webinar, WB.web_date,WL.inv_sms_sent")
->from("applications A")
->join("applicants U", "U.id=A.applicant_id")
->join("webinar_leads WL", "WL.application_id=A.id")
->join("webinars WB", "WB.id=WL.webinar_id")
->where(['WL.accepted'=>1])
->order_by("WL.accepted_on", "DESC");
$ps=200;
if($export){
$ps=100000;
}
$rs=$this->dba->pagedRows($qs['p'], $ps, 5, $export?'0':'');
if($rs['result']){
$md=$this->common->master_data_for_leads();
foreach($rs['result'] as &$r){
$r['state'] =$md['states'][$r['state_id']];
$r['lpage'] =$md['lpages'][$r['lpage_id']];
$r['ac'] =$md['acs'][$r['ac_id']];
$r['program'] =$md['programs'][$r['program_id']];
$r['plan'] =$md['plans'][$r['plan_id']];
$r['created'] =get_date($r['created']);
$r['web_date']=get_date($r['web_date'], true);
$r['accepted_on']=get_date($r['accepted_on']);
$r['inv_email_sent']=(int)$r['inv_email_sent'];
}
}
return $rs;
}
function get_webinar_name_list(){
return $this->db->select("id,title")
->from("webinars")
->order_by("title")
->get()->result_array();
}
}
//End of file
Kontol Shell Bypass