ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/student-panel/api/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/student-panel/api/application/models/Dashboard_model.php |
<?php
class Dashboard_model extends CI_Model {
function noOfinProgress(){
return (int)$this->db->select("COUNT(id) AS n")->get_where("applications", array('applicant_id'=>USER_ID, 'step_completed !='=>3))->row()->n;
}
function noOfCompleted(){
return (int)$this->db->select("COUNT(id) AS n")->get_where("applications", array('applicant_id'=>USER_ID, 'step_completed'=>3))->row()->n;
}
function noOfIssueRaised(){
return (int)$this->db->select("COUNT(id) AS n")->get_where("issues_reported", array('applicant_id'=>USER_ID))->row()->n;
}
function myApplications(){
$f="A.id, A.plan_id, A.application_no, A.step_completed, A.payment_status, A.fee, A.coupan_used, A.coupan_amt, A.created,
U.is_phd, PP.title AS plan, PP.fee AS planAppFee, P.fee AS prgAppFee, P.ac_id, PSS.status final_adm_status";
$rs=$this->db->select($f)
->from("applications AS A")
->join("applicants AS U", "A.applicant_id=U.id")
->join("master_program_plans AS PP", "A.plan_id=PP.id", "LEFT")
->join("master_programs AS P", "PP.program_id=P.id", "LEFT")
->join("ps_stu_status PSS", "PSS.EMPLID=A.application_no", "LEFT")
->where(array('A.applicant_id'=>USER_ID))
->order_by("A.id", "ASC")
->get()->result_array();
foreach($rs as &$r){
$r['is_phd']=(int)$r['is_phd'];
$r['step_completed']=(int)$r['step_completed'];
$r['payment_status']=(int)$r['payment_status'];
$r['fee']=(float)$r['fee'];
$r['coupan_amt']=(float)$r['coupan_amt'];
$r['feePaid']=0;
if($r['step_completed']==3){
$r['feePaid']=(float)($r['fee']-$r['coupan_amt']);
}else{
if((float)$r['planAppFee']){
$r['fee']=(float)$r['planAppFee'];
}else{
$r['fee']=(float)$r['prgAppFee'];
}
}
$r['created']=get_date($r['created']);
unset($r['planAppFee'], $r['prgAppFee']);
}
return $rs;
}
function suggestedPlans(){
$programId=$this->db->select("program_id")->order_by("id")->limit(1)->get_where("applications", array('applicant_id'=>USER_ID))->row()->program_id;
$rs=$this->db->select("PP.id AS plan_id, PP.program_id, PP.title AS plan, PP.fee AS planAppFee, P.fee AS prgAppFee, P.ac_id, P.title AS program")
->from("suggested_plans AS SPP")
->join("suggested_programs AS SP", "SPP.sug_program_id=SP.id")
->join("master_program_plans AS PP", "SPP.plan_id=PP.id")
->join("master_programs AS P", "PP.program_id=P.id")
->join("applications AS A", "A.plan_id=PP.id", "LEFT")
->where(array('SP.program_id'=>$programId, 'A.id'=>NULL))
->order_by("program", "ASC")
->order_by("plan", "ASC")
->get()->result_array();
foreach($rs as &$r){
if((float)$r['planAppFee']){
$r['fee']=(float)$r['planAppFee'];
}else{
$r['fee']=(float)$r['prgAppFee'];
}
unset($r['planAppFee'], $r['prgAppFee']);
$r['coupans']=$this->user->coupans($r['plan_id'], $r['program_id']);
}
return $rs;
}
function notifications(){
$step_completed=$this->db->select("step_completed")->order_by("id")->limit(1)->get_where("applications", array('applicant_id'=>USER_ID))->row()->step_completed;
$app_id=$this->db->select("id")->order_by("id")->limit(1)->get_where("applications", array('applicant_id'=>USER_ID))->row()->id;
$dtl=$this->common->applicationNdUsrInfo($app_id);
if(strtolower($dtl['programType'])=='suat'){
$this->db->where_in("type", ['BOTH', 'SUAT']);
}else{
$this->db->where_in("type", ['BOTH', 'NONSUAT']);
}
$rs=$this->db->select("msg")->from("notifications")->where("FIND_IN_SET($step_completed, steps) AND status=1", NULL, FALSE)->get()->result_array();
foreach($rs as &$r){
$r['msg']=encode_script(nl2br($r['msg']));
}
return $rs;
}
public function getSUSATExamDate()
{
$data = $this->db->select("*")->from('susat_exam_date')->where('status', '1')->limit(1)->get()->row();
return $data;
}
}
//End of file
Kontol Shell Bypass