ikan Uploader :
Directory : /var/www/html/shardahospital_old.org/lms/api/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital_old.org/lms/api/application/models/Enquiry_model.php |
<?php
class Enquiry_model extends CI_Model {
function __construct() {
parent::__construct();
}
//enquiry
function tmp_enquiry($post){
// $this->db->where('mobile', $post['mobile'])->or_where('EnquiryEmail', $post['EnquiryEmail'])->delete("tmp_enquiries");
return $this->db->insert("tmp_enquiries", $post);
// return $this->dba->save("tmp_enquiries", replace_null($post));
}
function sentOtpEnquiry($mobile, $email=''){
$otp=generate_otp();
$msg="Your OTP for Enquiry request at Sharda hospital is $otp."; //"Your OTP is $otp. Please use this code to initiate your application for Sharda University. Call us at +91120-4570011 for any queries.";
send_sms($mobile, $msg);
$emailOtp='';
if($email){
$emailOtp=generate_otp();
$msg= "Your OTP for Enquiry request at Sharda hospital is $emailOtp."; //"Your OTP is $emailOtp. Please use this code to initiate your application for Sharda University. Call us at +91120-4570011 for any queries.";
send_email($email, "Sharda University - One Time Password (OTP)", $msg);
}
return array('otp'=>$otp, 'emailOtp'=>$emailOtp);
}
function enquiry($post){
$err = FALSE;
// $this->db->trans_strict(FALSE);
// $this->db->trans_begin();
try{
$this->dba->save("enquiries", replace_null($post));
// $id=$this->dba->save("enquiries", replace_null($post));
// if(!$post['id']){
// $num=$this->common->getCounter('application_no_count');
// $d=['application_no'=>date('Y').zero_format_no($num)];
// $this->db->update("enquiries", $d, ['id'=>$id]);
// }
/** Delete from tmp_applicants if any */
$this->db->where('mobile', $post['mobile'])->or_where('EnquiryEmail', $post['EnquiryEmail'])->delete("tmp_enquiries");
}catch(Exception $e) {
$err = TRUE;
$msg = $e->getMessage();
}
// if($this->db->trans_status() === FALSE) {
// $err = TRUE;
// }
// if ($err) {
// $this->db->trans_rollback();
// return FALSE;
// } else {
// $this->db->trans_commit();
// return $id;
// }
}
//international patient enquiry
function sent_otp_enquiry1($email){
$emailOtp=generate_otp();
$msg= "Your OTP for Enquiry request at Sharda hospital is $emailOtp."; //"Your OTP is $emailOtp. Please use this code to initiate your application for Sharda University. Call us at +91120-4570011 for any queries.";
send_email($email, "Sharda University - One Time Password (OTP)", $msg);
$otp='';
// if($mobile1){
// $otp1=generate_otp();
// $msg1="Your OTP for Enquiry request at Sharda hospital is $otp1."; //"Your OTP is $otp. Please use this code to initiate your application for Sharda University. Call us at +91120-4570011 for any queries.";
// send_sms($mobile, $msg);
// }
return array('emailOtp'=>$emailOtp , 'otp'=>$otp );
}
// function enquiry1($post){
// $err = FALSE;
// try{
// $this->dba->save("enquiries", replace_null($post));
// $this->db->where('mobile', $post['mobile'])->or_where('EnquiryEmail1', $post['EnquiryEmail1'])->delete("tmp_enquiries");
// }catch(Exception $e) {
// $err = TRUE;
// $msg = $e->getMessage();
// }
// }
function indianPatientEnquiry($post){
$name = $post['EnquiryName'];
$contact_no = $post['mobile'];
$email_address = $post['EnquiryEmail'];
$message = $post['EnquiryMessage'];
$email = array('helpdesk@shardahospital.org','shivangi.singh@sharda.ac.in') ;
$currentDateTime = date('Y-m-d H:i:s');
$msg="Here are the details of the patient: <br> Name: $name <br> Contact No: $contact_no <br>".
"Email: $email_address <br> Message: $message";
send_email($email, "New Patient Enquiry $currentDateTime", $msg);
return true ;
}
function internationalPatientEnquiry($post){
$name = $post['EnquiryName'];
$contact_no = $post['mobile'];
$email_address = $post['EnquiryEmail'];
$message = $post['EnquiryMessage'];
$email = array('queries@shardahospital.org','varun.aggarwal@sharda.ac.in') ;
$currentDateTime = date('Y-m-d H:i:s');
$msg="Here are the details of the patient: <br> Name: $name <br> Contact No: $contact_no <br>".
"Email: $email_address <br> Message: $message";
send_email($email, "New Patient Enquiry $currentDateTime", $msg);
return true ;
}
function getAllData(){
$this->db->select("*");
$this->db->from("enquiries");
$this->db->order_by("id", "desc");
$this->db->group_by('EnquiryName');
$query = $this->db->get();
return $query->result();
}
function delete($id){
$this->db->db_debug=FALSE;
return $this->db->delete("enquiries", array('id'=>$id));
}
function detail($id, $filter=true){
$rs=$this->db->select("id,EnquiryName,EnquiryEmail,mobile,EnquiryMessage,verified_by,created")
->from("enquiries")
->where(array('id'=>$id))
->get()->row_array();
$dtl=[];
if($rs){
$dtl=$rs;
}
return $dtl;
}
function get_follow_ups($id){
$rs=$this->db->select("ER.id, ER.enquiry_id, MR.title remarks, ER.subremarks, ER.feedback, ER.created")
->from("enquiry_remarks ER")
->join("master_enquiry_remarks MR", "ER.remarks_id=MR.id")
->where("ER.enquiry_id", $id)
->order_by("ER.id")
->get()->result_array();
if($rs){
foreach($rs as &$r){
$r['created']=get_date($r['created'], true);
}
}
return $rs;
}
// function get_follow_ups($id){
// $rs=$this->db->select("id, enquiry_id, subremarks, feedback, created")
// ->from("enquiry_remarks AR")
// ->where("enquiry_id", $id)
// ->order_by("id")
// ->get()->result_array();
// if($rs){
// foreach($rs as &$r){
// $r['created']=get_date($r['created'], true);
// }
// }
// return $rs;
// }
function remarks_cats(){
return $this->db->select('id,title')->from('master_enquiry_remarks_cats')->order_by('disp_odr')->get()->result_array();
}
function remarks(){
$rs=$this->db->select("id, cat_id, title")->from("master_enquiry_remarks")->where("status",1)->order_by("disp_odr")->get()->result_array();
foreach($rs as &$r){
$r['subremarks']=$this->db->select("title")->order_by("disp_odr")->get_where("master_enquiry_subremarks", array('remarks_id'=>$r['id']))->result_array();
}
return $rs;
}
function follow_up_detail($id=0){
$rs['dtl']=$this->db->select("ER.id, ER.enquiry_id, ER.remarks_id, ER.subremarks, ER.feedback")->from("enquiry_remarks ER")->where("ER.id", $id)->get()->row_array();
if($rs['dtl']){
$rs['dtl']['cat_id']=$this->db->select("cat_id")->get_where("master_enquiry_remarks", ['id'=>$rs['dtl']['remarks_id']])->row()->cat_id;
$rs['subremarks']=$this->db->select("title")->order_by("disp_odr")->get_where("master_enquiry_subremarks", array('remarks_id'=>$rs['dtl']['remarks_id']))->result_array();
}
return $rs;
}
function delete_follow_up($id){
$this->db->db_debug=FALSE;
return $this->db->delete("enquiry_remarks", array('id'=>$id));
}
}
//End of file
Kontol Shell Bypass