ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/api/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/api/application/models/Admreport_model.php |
<?php
class Admreport_model extends CI_Model {
function __construct() {
parent::__construct();
}
function setAdmCounsellorReportCond($i, $c, $dsDtl){
$qs=trimArray($this->input->post());
$ydateStart=date('Y-m-d 00:00:00',strtotime('-1 day',time()));
$ydate=date('Y-m-d 23:59:59',strtotime('-1 day',time()));
if($dsDtl){
$this->common->set_data_set_cond($dsDtl, 0, 0);
}
if($i===1){
if($qs['from_date'] || $qs['to_date']){
if($qs['from_date']){
$dt=date('Y-m-d 00:00:00',strtotime($qs['from_date']));
$this->db->where("$c>=", $dt);
}
if($qs['to_date']){
$dt=date('Y-m-d 23:59:59',strtotime($qs['to_date']));
$this->db->where("$c<=", $dt);
}
}else{
$this->db->where("$c<=", $ydate);
}
}else{
$this->db->where("$c>=", $ydateStart)->where("$c<=", $ydate);
}
}
function admCounsellorReport($all=false){
$qs=trimArray($this->input->post());
$periodN=2;
$isUserWise=strpos($qs['type'], '_USER_WISE')!==FALSE;
$user_ids=$qs['user_ids']?$qs['user_ids']:[];
if($isUserWise){
$periodN=1;
$users=$this->db->select("id, name")->from("users")->where_in("id", $user_ids?$user_ids:[0])->order_by("name")->get()->result_array();
foreach($users as &$ru){
$ru['dsDtl']=$this->dataset->detail(0, $ru['id']);
}
}else{
$dsDtl=$this->dataset->combineUsersDatasets($user_ids);
$users=[['id'=>'0', 'name'=>'ALL', 'dsDtl'=>$dsDtl]];
}
$period='Till yesterday';
if($qs['from_date'] || $qs['to_date']){
if($qs['from_date'] && $qs['to_date']){
$period=$qs['from_date'].' to '.$qs['to_date'];
}else if($qs['from_date']){
$period=$qs['from_date'].' to TILL NOW';
}else if($qs['to_date']){
$period='BEGINING to '.$qs['to_date'];
}
}
//$this->db->cache_on();
//COUNT(IF(A.payment_status=1, 1, NULL)) paid,
$cf="COUNT(1) total,
COUNT(IF(PSS.status='ADM_OFFERED' OR PSS.status='ADM_FINAL', 1, NULL)) adm_offered,
COUNT(IF(PSS.status='ADM_WITHDRAW', 1, NULL)) adm_withdraw,
COUNT(IF(PSS.status='ADM_FINAL', 1, NULL)) adm_final,
COUNT(PSS_PAID.EMPLID) adm_confirmed,
COUNT(IF(A.followup_count_all>0, 1, NULL)) followup_leads_count,
SUM(A.followup_count_all) followup_count,
COUNT(IF(A.isdead='Y', 1, NULL)) dead_count,
COUNT(IF(A.last_followup_id='0', 1, NULL)) untouched_count
";
$records=[];
foreach($users as $u){
for($i=1; $i<=$periodN; $i++){
$rowData=[
'user'=>$u['name'],
'period'=>$period,
'total'=>0,
'paid'=>0,
'adm_offered'=>0,
'adm_withdraw'=>0,
'adm_final'=>0,
'adm_confirmed'=>0,
'followup_leads_count'=>0,
'followup_count'=>0,
'emails_count'=>0,
'sms_count'=>0,
'dead_count'=>0,
'untouched_count'=>0,
];
if($i==2){
$rowData['period']='Yesterday';
}
$this->setAdmCounsellorReportCond($i, 'A.created', $u['dsDtl']);
$record=$this->db->select($cf)
->from("applications_sm A FORCE INDEX(applicant_id_created)")
->join("applicants_sm U", "A.applicant_id=U.applicant_id")
->join("ps_stu_status PSS", "PSS.EMPLID=A.application_no", "LEFT")
->join("ps_paid_system_ids PSS_PAID", "PSS_PAID.EMPLID=A.application_no", "LEFT")
->get()
->row_array();
//echo $this->db->last_query(); die;
$this->setAdmCounsellorReportCond($i, 'A.payment_date', $u['dsDtl']);
$this->db->where("A.payment_status", 1);
$record['paid']=$this->db->select("count(1) n")->from("applications_sm A")->join("applicants_sm U", "A.applicant_id=U.applicant_id")->get()->row("n");
$this->setAdmCounsellorReportCond($i, 'A.created', $u['dsDtl']);
$this->db->join("sent_emails SE", "SE.application_id=A.application_id");
$record['emails_count']=$this->db->select("count(1) n")->from("applications_sm A")->join("applicants_sm U", "A.applicant_id=U.applicant_id")->get()->row("n");
$this->setAdmCounsellorReportCond($i, 'A.created', $u['dsDtl']);
$this->db->join("followup_sent_sms S", "S.application_id=A.application_id");
$record['sms_count']=$this->db->select("count(1) n")->from("applications_sm A")->join("applicants_sm U", "A.applicant_id=U.applicant_id")->get()->row("n");
foreach($record as $k=>$v){
$rowData[$k]=intval($v);
}
$records[]=$rowData;
}
}
return $records;
}
function admCounsellorReport1(){
$qs=trimArray($this->input->post());
}
}
//End of file
Kontol Shell Bypass