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/Program_model.php |
<?php
class Program_model extends CI_Model {
function programUsedCoupanIds($program_id){
return $this->db->select("cu.coupan_id")
->from("coupans_in_use cu")
->join("master_coupans mc", "mc.id=cu.coupan_id")
->where(['cu.program_id'=>$program_id, 'mc.expiry_date>='=>date('Y-m-d')])
->get()->result_array();
}
function planUsedCoupanIds($plan_id){
return $this->db->select("cu.coupan_id")
->from("coupans_in_use cu")
->join("master_coupans mc", "mc.id=cu.coupan_id")
->where(['cu.plan_id'=>$plan_id, 'mc.expiry_date>='=>date('Y-m-d')])
->get()->result_array();
}
function lists(){
$qs=trim_array($this->input->get());
if($qs['type_id']){
$this->db->where("P.type_id", $qs['type_id']);
}
if($qs['ac_id']){
$this->db->where("P.ac_id", $qs['ac_id']);
}
if($qs['discipline_id']){
$this->db->where("P.discipline_id", $qs['discipline_id']);
}
if($qs['school_id']){
$this->db->where("P.school_id", $qs['school_id']);
}
if($qs['k']){
$this->db->group_start()
->like('P.title', $qs['k'])
->or_like('AC.title', $qs['k'])
->or_like('PT.title', $qs['k'])
->or_like('MD.title', $qs['k'])
->or_like('SCH.title', $qs['k'])
->group_end();
}
$this->db->select("P.id, P.title, P.fee, P.is_medical, P.is_phd, P.status, PT.title AS type, AC.title AS ac_name, P.brochure, MD.title AS discipline, SCH.title AS school, COUNT(SPP.id) AS noOfSPlans")
->from("master_programs AS P")
->join("master_program_types AS PT", "P.type_id=PT.id")
->join("master_academic_careers AS AC", "P.ac_id=AC.id")
->join("master_disciplines AS MD", "P.discipline_id=MD.id")
->join("master_schools AS SCH", "P.school_id=SCH.id")
->join("suggested_programs AS SP", "SP.program_id=P.id", "LEFT")
->join("suggested_plans AS SPP", "SPP.sug_program_id=SP.id", "LEFT")
->group_by("P.id")->order_by("P.title");
$rs=$this->dba->pagedRows($qs['p'], 100, 5);
if($rs['result']){
foreach($rs['result'] as &$r){
$r['coupan_added']=0;
if($this->programUsedCoupanIds($r['id'])){
$r['coupan_added']=1;
}
}
}
return $rs;
}
function detail($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_programs", array('id'=>$id))->row_array();
if($rs){
$rs['type_id']=$rs['type_id']?$rs['type_id']:'';
$rs['ac_id']=$rs['ac_id']?$rs['ac_id']:'';
$rs['discipline_id']=$rs['discipline_id']?$rs['discipline_id']:'';
$rs['school_id']=$rs['school_id']?$rs['school_id']:'';
$rs['image_url']=$rs['image']?UP_URLF.'programs_images/'.$rs['image']:'';
$rs['brochure_url']=$rs['brochure']?UP_URLF.'brochure/'.$rs['brochure']:'';
$rs['coupanIds']=$this->programUsedCoupanIds($rs['id']);
}
return $rs;
}
function delete($id){
$this->db->db_debug=FALSE;
$this->db->delete("coupans_in_use", array('program_id'=>$id));
return $this->db->delete("master_programs", array('id'=>$id));
}
/** Plans */
function plans($programId=0){
$rs=$this->db->select("PP.id, PP.title, PP.code, PP.program_code, PP.ac_code, PP.fee, PP.campus_ids, PP.fee_year_wise, PP.fee_semester_wise, PP.status, P.fee AS prgAppFee")
->from("master_program_plans AS PP")
->join("master_programs AS P", "P.id=PP.program_id")
->where(array('PP.program_id'=>$programId))
->order_by("PP.title")->get()->result_array();
foreach($rs as &$r){
$r['fee']=(float)$r['fee'];
$r['prgAppFee']=(float)$r['prgAppFee'];
$campus=$this->db->select("title")->from("master_campus")->where_in("id", explode(",", $r['campus_ids']))->get()->result_array();
$campusNames=[];
foreach($campus as $c){
$campusNames[]=$c['title'];
}
$r['campus']=implode(", ", $campusNames);
$r['coupan_added']=0;
if($this->planUsedCoupanIds($r['id'])){
$r['coupan_added']=1;
}
//$r['fee_year_wise']=explode(",", $r['fee_year_wise']);
//$r['fee_semester_wise']=explode(",", $r['fee_semester_wise']);
}
return $rs;
}
function planDetail($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_program_plans", array('id'=>$id))->row_array();
if($rs){
//$rs['coupanIds']=$this->db->select("coupan_id")->get_where("coupans_in_use", array('plan_id'=>$rs['id']))->result_array();
$rs['coupanIds']=$this->planUsedCoupanIds($rs['id']);
$rs['campus_ids']=explode(",", $rs['campus_ids']);
$rs['fee']=(float)$rs['fee'];
$rs['prgAppFee']=(float)$this->db->get_where("master_programs", array('id'=>$rs['program_id']))->row()->fee;
$rs['fee_year_wise']=explode(",", $rs['fee_year_wise']);
$rs['fee_semester_wise']=explode(",", $rs['fee_semester_wise']);
}
return $rs;
}
function deletePlan($id){
$this->db->db_debug=FALSE;
$this->db->delete("coupans_in_use", array('plan_id'=>$id));
return $this->db->delete("master_program_plans", array('id'=>$id));
}
/** Suggested Programs/Plans */
function suggestedPrograms($programId){
$rs=$this->db->select("SP.id, SP.sug_program_id, P.title AS program")
->from("suggested_programs AS SP")
->join("master_programs AS P", "SP.sug_program_id=P.id")
->where("SP.program_id", $programId)
->order_by("P.title")->get()->result_array();
foreach($rs as &$r){
$plans=$this->db->select("PP.id AS plan_id, PP.title AS plan, PP.code, SP.id AS isAdded")
->from("master_program_plans AS PP")
->join("suggested_plans AS SP", "SP.plan_id=PP.id AND SP.sug_program_id='{$r['id']}'", "LEFT")
->where(array('PP.program_id'=>$r['sug_program_id']))
->order_by("PP.title")->get()->result_array();
$r['plans']=$plans;
}
return $rs;
}
}
//End of file
Kontol Shell Bypass