ikan Uploader :
Directory : /var/www/html/shardahospital.org/lms/api/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/lms/api/application/models/Master_model.php |
<?php
class Master_model extends CI_Model {
/** Admin Emalils */
function adminEmails(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('email', $qs['k']);
}
$this->db->select("id, email,send_payment_alert, send_appointment_alert, send_issue_alert")->from("master_admin_emails")->order_by("id");
$rs=$this->dba->pagedRows($qs['p'], 100, 5);
return $rs;
}
function adminEmailDetal($id,$f='*'){
$rs=$this->db->select($f)->get_where("master_admin_emails", array('id'=>$id))->row_array();
if($rs){
$rs['send_payment_alert'] =$rs['send_payment_alert']?true:false;
$rs['send_appointment_alert'] =$rs['send_appointment_alert']?true:false;
$rs['send_issue_alert'] =$rs['send_issue_alert']?true:false;
}
return $rs;
}
function deleteAdminEmail($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_admin_emails", array('id'=>$id));
}
/** \ */
/** UTM Source */
function utmSources($getmedium=false){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('medium', $qs['k']);
}
$rs=$this->db->select("id, title, grp, default_for_admin, status")->from("master_utm_sources")->order_by("title")->get()->result_array();
if($getmedium){
foreach($rs as &$r){
$mediums=$this->db->select("DISTINCT utm_medium", false)->get_where("applicants", array('utm_source_id'=>$r['id']))->result_array();
$meds=[];
foreach($mediums as $m){
if($m['utm_medium']){
$meds[]=$m['utm_medium'];
}
}
$r['medium']=implode(", ", $meds);
}
}
return $rs;
}
function utmSourceDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_utm_sources", array('id'=>$id))->row_array();
return $rs;
}
function deleteUtmSource($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_utm_sources", array('id'=>$id));
}
/** \ */
/** States */
function states(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('code', $qs['k']);
}
$rs=$this->db->select("id, title, code, status")->from("master_states")->order_by("title")->get()->result_array();
return $rs;
}
function stateDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_states", array('id'=>$id))->row_array();
return $rs;
}
function deleteState($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_states", array('id'=>$id));
}
function cities($stateId=''){
$this->db->where('state_id', $stateId);
$rs=$this->db->select("id, title, pincode, status")->from("master_cities")->order_by("title")->get()->result_array();
return $rs;
}
function cityDetail($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_cities", array('id'=>$id))->row_array();
return $rs;
}
function deleteCity($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_cities", array('id'=>$id));
}
/** \ */
/** Notifications */
function notifications(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('msg', $qs['k']);
}
$rs=$this->db->select("id, msg, status")->from("notifications")->order_by("id", "DESC")->get()->result_array();
foreach($rs as &$r){
$r['msg']=str_short($r['msg'], 250);
}
return $rs;
}
function notificationDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("notifications", array('id'=>$id))->row_array();
return $rs;
}
function deleteNotification($id){
$this->db->db_debug=FALSE;
return $this->db->delete("notifications", array('id'=>$id));
}
/** \ */
/** Faq */
function faqs(){
$qs=trim_array($this->input->get());
if($qs['cat_id']){
$catId=$this->db->escape_str($qs['cat_id']);
$this->db->where("FIND_IN_SET('$catId', F.cat_ids)", NULL, FALSE);
}
if($qs['k']){
$this->db->db_debug = FALSE;
$k=$this->db->escape_str(str_for_fulltext($qs['k'], TRUE, TRUE));
$fts_mode="IN BOOLEAN MODE";
$fulltext_cond="MATCH(F.question, F.ans) AGAINST('$k' $fts_mode)";
$this->db->where($fulltext_cond, NULL, FALSE)->or_like("F.question", $qs['k'])->or_like("F.ans", $qs['k']);
}
$rs=$this->db->select("F.id, F.question, F.ans, F.disp_odr, F.status, F.cat_ids")->from("master_faq AS F")->order_by("F.disp_odr")->get()->result_array();
foreach($rs as &$r){
$r['ans']=str_short($r['ans'], 250);
$r['cats']=$this->db->select("GROUP_CONCAT(title ORDER BY title SEPARATOR ', ') AS cats", FALSE)->from("master_faq_cats")->where_in("id", explode(",", $r['cat_ids']))->get()->row()->cats;
}
return $rs;
}
function faqDetail($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_faq", array('id'=>$id))->row_array();
return $rs;
}
function deleteFaq($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_faq", array('id'=>$id));
}
function faqCatDetail($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_faq_cats", array('id'=>$id))->row_array();
return $rs;
}
function deleteFaqCat($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_faq_cats", array('id'=>$id));
}
/** \ */
}
//End of file
Kontol Shell Bypass