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/Front_model.php |
<?php
class Front_model extends CI_Model {
function __construct() {
parent::__construct();
}
function states(){
return $this->db->select("id, title")->order_by("title")->get_where("master_states", array('status'=>1))->result_array();
}
function cities($state_id=0){
$cond=array('status'=>1);
if($state_id){
$cond['state_id']=$state_id;
}
return $this->db->select("id, state_id, title, pincode")->order_by("title")->get_where("master_cities", $cond)->result_array();
}
function programs($lpage=''){
$cond=array('P.status'=>1);
if($lpage){
$lpage_id=$this->db->get_where("landing_pages", array('trimed_title'=>$lpage))->row()->id;
if($lpage_id){
$cond['LP.lpage_id']=$lpage_id;
}
}
return $this->db->select("P.id, P.title")
->from("master_programs AS P")
->join("landing_page_programs AS LP", "LP.program_id=P.id", "LEFT")
->where($cond)
->group_by("P.id")->order_by("title")->get()->result_array();
}
function def_prg_id($lpage=''){
$lpage_id=$this->db->get_where("landing_pages", array('trimed_title'=>$lpage))->row()->id;
$def_prg_id=$this->db->select("def_prg_id")->get_where("landing_pages", ['id'=>$lpage_id])->row()->def_prg_id;
return $def_prg_id?$def_prg_id:'';
}
function sent_otp($mob, $email=''){
$otp=generate_otp();
$msg="Your OTP for appointment 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($mob, $msg);
$emailOtp='';
if($email){
$emailOtp=generate_otp();
$msg= "Your OTP for appointment request at Sharda hospital is $otp."; //"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 sent_intotp($email){
$emailOtp='';
$emailOtp=generate_otp();
$msg= "Your OTP for appointment request at Sharda hospital is $emailOtp.";
send_email($email, "Sharda University - One Time Password (OTP)", $msg);
return array('emailOtp'=>$emailOtp);
}
function tmp_international_register($post){
$this->db->where('mob', $post['mob'])->or_where('email', $post['email'])->delete("tmp_international_applicants");
return $this->dba->save("tmp_international_applicants", replace_null($post));
}
function tmp_register($post){
$this->db->where('mob', $post['mob'])->or_where('email', $post['email'])->delete("tmp_applicants");
return $this->dba->save("tmp_applicants", replace_null($post));
}
function register($post){
$err = FALSE;
$this->db->trans_strict(FALSE);
$this->db->trans_begin();
try{
if($post['utm_source']){
$post['utm_source_id']=$this->db->get_where("master_utm_sources", array('title'=>$post['utm_source']))->row()->id;
if(!$post['utm_source_id']){
$post['utm_source_id']=$this->dba->save("master_utm_sources", array('title'=>$post['utm_source'], 'status'=>1));
}
}
$id=$this->dba->save("applicants", 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("applicants", $d, ['id'=>$id]);
}
/** Delete from tmp_applicants if any */
$this->db->where('mob', $post['mob'])->or_where('email', $post['email'])->delete("tmp_applicants");
}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;
}
}
function internationalregister($post){
$err = FALSE;
$this->db->trans_strict(FALSE);
$this->db->trans_begin();
try{
if($post['utm_source']){
$post['utm_source_id']=$this->db->get_where("master_utm_sources", array('title'=>$post['utm_source']))->row()->id;
if(!$post['utm_source_id']){
$post['utm_source_id']=$this->dba->save("master_utm_sources", array('title'=>$post['utm_source'], 'status'=>1));
}
}
$id=$this->dba->save("international_applicants", replace_null($post));
if(!$post['id']){
$num=$this->common->getCounter('application_no_count');
$d=['application_no'=>'SHI'.date('Y').zero_format_no($num)];
$this->db->update("international_applicants", $d, ['id'=>$id]);
}
/** Delete from tmp_international_applicants if any */
$this->db->where('mob', $post['mob'])->or_where('email', $post['email'])->delete("tmp_international_applicants");
}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;
}
}
function sendSystemIdGenMsg($id){
$dtl=$this->db->select("A.*, P.title program, P.image progImage, P.brochure progBrochure")
->from("applicants A")
->join("master_programs P", "A.program_id=P.id")
->where(array('A.id'=>$id))
->get()->row_array();
$sms=$this->db->select("reg_sms")->get_where("master_programs", ['id'=>$dtl['program_id']])->row()->reg_sms;
if($sms){
$timeStamp = strtotime($dtl['appointment_datetime']);
$date = date('Y-m-d', $time);
$time = date('H:i', $timeStamp);
$sms = str_ireplace('%date%',$date, $sms);
$sms = str_ireplace('%time%',$time, $sms);
send_sms($dtl['mob'], $sms);
}
$emailMsg=$this->load->view("email/front_thank_you", $dtl, TRUE);
send_email($dtl['email'], "Appointment Request Submitted Successfully", $emailMsg);
}
//enquiry
}
//End of file
Kontol Shell Bypass