ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/api/application/models_old/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/api/application/models_old/Program_model.php |
<?php
class Program_model extends CI_Model {
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.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);
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->db->select("coupan_id")->get_where("coupans_in_use", array('program_id'=>$rs['id']))->result_array();
}
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.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'];
}
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['fee']=(float)$rs['fee'];
$rs['prgAppFee']=(float)$this->db->get_where("master_programs", array('id'=>$rs['program_id']))->row()->fee;
}
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