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/Common_model.php |
<?php
class Common_model extends CI_Model {
function save($data, $tbl="", $pKey="id"){
$id=$this->db->escape_str($data[$pKey]);
unset($data[$pKey]);
if($id){
$data['updated']=currentDT();
$data['updated_by']=USER_ID;
$this->dba->update($tbl, $data, "$pKey='$id'");
if(!$this->db->affected_rows()){
return;
}
}else{
$data['created']=$data['updated']=currentDT();
$data['created_by']=USER_ID;
$data['updated_by']=USER_ID;
$id=$this->dba->insert($tbl, $data);
}
return $id;
}
function getCounter($type){
$c=(int)$this->db->get_where("master_data", array('datakey'=>$type))->row()->datavalue;
$this->db->update("master_data", array('datavalue'=>$c+1, 'updated'=>currentDT()), array('datakey'=>$type));
return $c;
}
function allStates($active=FALSE){
if($active){
$this->db->where(array('status'=>1));
}
return $this->db->select("S.id, S.title, S.code, COUNT(C.id) AS noOfCities")->from("master_states AS S")->join("master_cities AS C", "C.state_id=S.id", "LEFT")->group_by("S.id")->order_by("S.title")->get()->result_array();
}
function programs($active=FALSE){
if($active){
$this->db->where(array('P.status'=>1));
}
return $this->db->select("P.id, P.title")->from("master_programs AS P")->order_by("P.title")->get()->result_array();
}
function allLandingPages($active=FALSE){
if($active){
$this->db->where(array('P.status'=>1));
}
return $this->db->select("P.id, P.title, COUNT(DISTINCT PP.id) AS noOfProg, COUNT(DISTINCT PF.id) AS noOfFaq", FALSE)
->from("landing_pages AS P")
->join("landing_page_programs AS PP", "PP.lpage_id=P.id", "LEFT")
->join("landing_page_faqs AS PF", "PF.lpage_id=P.id", "LEFT")
->group_by("P.id")->order_by("P.title")->get()->result_array();
}
function getGACode(){
$gacode_head=$this->db->get_where("master_data", array('datakey'=>'gacode_head'))->row()->datavalue;
$gacode_body=$this->db->get_where("master_data", array('datakey'=>'gacode_body'))->row()->datavalue;
$gacode_key=$this->db->get_where("master_data", array('datakey'=>'gacode_key'))->row()->datavalue;
return array('head'=>$gacode_head, 'body'=>$gacode_body, 'key'=>$gacode_key);
}
function utmGroups($active=FALSE){
if($active){
$this->db->where('status', 1);
}
$rs=$this->db->select("DISTINCT grp", false)->order_by("grp")->get_where("master_utm_sources", ['grp !='=>''])->result_array();
return $rs;
}
function allUtmSources($active=FALSE, $camp_med=FALSE){
if($active){
$this->db->where('status', 1);
}
$rs=$this->db->select("id, title")->from("master_utm_sources")->order_by("title")->get()->result_array();
if($camp_med){
foreach($rs as &$r){
$camps=$this->db->select("DISTINCT utm_campaign", false)->get_where("applicants", array('utm_source_id'=>$r['id']))->result_array();
$meds=$this->db->select("DISTINCT utm_medium", false)->get_where("applicants", array('utm_source_id'=>$r['id']))->result_array();
$r['campaigns']=[];
$r['mediums']=[];
foreach($camps as $c){
$r['campaigns'][]=$c['utm_campaign'];
}
foreach($meds as $c){
$r['mediums'][]=$c['utm_medium'];
}
}
}
return $rs;
}
function faqCats($active=FALSE){
$qs=trim_array($this->input->get());
if($active){
$this->db->where("status", 1);
}
if($qs['k']){
$this->db->like("title", $qs['k']);
}
return $this->db->order_by("title")->get("master_faq_cats")->result_array();
}
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 lead_detail($id){
$dtl=$this->db->select("A.*, P.title program, P.image progImage, P.brochure progBrochure")
->from("applicants A")
->join("master_programs AS P", "PP.program_id=P.id")
->where(array('A.id'=>$id))
->get()->row_array();
$dtl['progImageUrl']=$dtl['progImage']?UP_URLF.'programs_images/'.$dtl['progImage']:'';
$dtl['progBrochureUrl']=$dtl['progBrochure']?UP_URLF.'brochure/'.$dtl['progBrochure']:'';
$dtl['progBrochureDwnUrl']=$dtl['progBrochure']?(URL.'common/downloadFile/'.encode(UP_PATHF.'brochure/'.$dtl['progBrochure'])):'';
$dtl['state']=$this->db->select("title")->get_where("master_states", array('id'=>$dtl['state_id']))->row()->title;
$dtl['lpage']=rtrim($this->db->select("title")->get_where("landing_pages", array('id'=>$dtl['lpage_id']))->row()->title, "/");
$dtl['utmSource']=$this->db->select("title")->get_where("master_utm_sources", array('id'=>$dtl['utm_source_id']))->row()->title;
//$dtl['loginUrl']=generate_login_url($dtl['lpage'], $dtl['mob']);
return $dtl;
}
function sendSystemIdGenMsg($appId){
$dtl=$this->applicationNdUsrInfo($appId);
$usrName=strtoupper($dtl['usr']['name']);
$systemId=$dtl['application_no'];
if(strtolower($dtl['programType'])=='suat'){
$sms="Dear $usrName, Thank you for applying at Sharda University. Your System ID is - $systemId. Login at {$dtl['loginUrl']} to complete your SUAT-2019 application. Call us at 0120-4570011 for any queries.";
}else{
$sms="Dear $usrName, Thank you for applying at Sharda University. Your System ID is - $systemId. Login at {$dtl['loginUrl']} to complete your application. Call us at 0120-4570011 for any queries.";
}
$emailSub="Dear $usrName, Your System ID $systemId is Generated !!!";
$emailMsg=$this->load->view("email/system_id_gen", $dtl, TRUE);
send_sms($dtl['usr']['mob'], $sms);
send_email($dtl['usr']['email'], $emailSub, $emailMsg);
}
function sendIssueCommentToApplicant($id, $comment){
$rs=$this->db->select("applicant_id, cat, issue")->get_where("issues_reported", array('id'=>$id))->row_array();
$email=$this->db->select("email")->get_where("applicants", array('id'=>$rs['applicant_id']))->row()->email;
if($email){
$msg="Issue: [{$rs['cat']}] {$rs['issue']} <br><br> Comment: <br><br>".$comment;
$sub="Reply: ".$rs['cat'];
send_email($email, $sub, $msg);
}
}
function send_campaign_email($data){
ignore_user_abort(1);
if(ENVIRONMENT=='development'){
//return TRUE;
}
$smtpdtl=array(
'host'=>'smtp.pepipost.com',
'user'=>'shardapepi',
'pass'=>'SUsocial@2019',
'port'=>'25',
);
$fromname="Sharda University";
$fromemail="info@shardauniversity.com";
$this->load->library('email');
foreach($data as $d){
$this->email->clear();
$config['charset'] = 'utf-8';
$config['wordwrap'] = TRUE;
$config['mailtype'] = 'html';
$config['protocol'] = "smtp";
$config['smtp_host'] = $smtpdtl['host'];
$config['smtp_user'] = $smtpdtl['user'];
$config['smtp_pass'] = $smtpdtl['pass'];
$config['smtp_port'] = $smtpdtl['port'];
$config['_auth_smtp'] = TRUE;
$config['newline'] = "\r\n";
$config['crlf'] = "\r\n";
//$config['smtp_crypto'] = 'tls';
$config['smtp_keepalive']=true;
$this->email->initialize($config);
$this->email->from($fromemail, $fromname);
$this->email->reply_to('noreply@shardauniversity', $fromname);
$this->email->to($d['email']);
$this->email->subject($d['subject']);
$this->email->message($d['msg']);
//pr($this->email->print_debugger());
$res=$this->email->send();
}
return $res;
}
function send_campaign_sms($data){
ignore_user_abort(1);
if(ENVIRONMENT=='development'){
//return TRUE;
}
foreach($data as $d){
if(!$d['mob']){
continue;
}
send_sms($d['mob'], $d['msg']);
}
return $res;
}
function master_data_for_leads(){
$states=$this->db->select("id,code,title")->get("master_states")->result_array();
$md['states']=key_val_array($states, 'id', 'title');
$md['state_codes']=key_val_array($states, 'id', 'code');
$md['lpages']=key_val_array($this->db->select("id,title")->get("landing_pages")->result_array(), 'id', 'title');
return $md;
}
}
//End of file
Kontol Shell Bypass