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/Master_model.php |
<?php
class Master_model extends CI_Model {
/** Program Types */
function programTypes(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k']);
}
$rs=$this->db->select("id, title, disp_odr, status")->from("master_program_types")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function programTypeDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_program_types", array('id'=>$id))->row_array();
return $rs;
}
function deleteProgramType($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_program_types", array('id'=>$id));
}
/** \ */
/** Academic Careers */
function academicCareers(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k']);
}
$rs=$this->db->select("id, title, disp_odr, status")->from("master_academic_careers")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function academicCareerDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_academic_careers", array('id'=>$id))->row_array();
return $rs;
}
function deleteAcademicCareer($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_academic_careers", array('id'=>$id));
}
/** \ */
/** Discipline */
function disciplines(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k']);
}
$rs=$this->db->select("id, title, disp_odr, status")->from("master_disciplines")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function disciplineDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_disciplines", array('id'=>$id))->row_array();
return $rs;
}
function deleteDiscipline($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_disciplines", array('id'=>$id));
}
/** \ */
/** Schools */
function schools(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('a.title', $qs['k'])->or_like('a.ps_code', $qs['k']);
}
$rs=$this->db->select("a.id, a.title, a.ps_code, a.brochure, a.website, a.disp_odr, a.status")
->from("master_schools a")
->order_by("a.disp_odr")
->get()->result_array();
foreach($rs as &$r){
$r['brochure_url']=$r['brochure']?(UP_URLF.'brochure/'.$r['brochure']):'';
$r['accreditations_count']=(int)$this->db->select("COUNT(*) n")->get_where("school_accreditations", ['school_id'=>$r['id']])->row("n");
$r['dean_messages_count']=(int)$this->db->select("COUNT(*) n")->get_where("school_dean_messages", ['school_id'=>$r['id']])->row("n");
}
return $rs;
}
function schoolDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_schools", array('id'=>$id))->row_array();
if($rs){
$rs['brochure_url']=$rs['brochure']?(UP_URLF.'brochure/'.$rs['brochure']):'';
}
return $rs;
}
function deleteSchool($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_schools", array('id'=>$id));
}
function schoolAccreditations($school_id){
$rs=$this->db->get_where("school_accreditations", ['school_id'=>$school_id])->result_array();
if($rs){
foreach($rs as &$r){
$r['image_url']=$r['image']?(UP_URLF.'schools/'.$r['image']):'';
}
}else{
$rs=[];
}
return $rs;
}
function deleteSchoolAccreditation($id){
$this->db->db_debug=FALSE;
return $this->db->delete("school_accreditations", array('id'=>$id));
}
function schoolDeanMessages($school_id){
$rs=$this->db->get_where("school_dean_messages", ['school_id'=>$school_id])->result_array();
if($rs){
foreach($rs as &$r){
$r['image_url']=$r['image']?(UP_URLF.'schools/'.$r['image']):'';
}
}else{
$rs=[];
}
return $rs;
}
function deleteSchoolDeanMessage($id){
$this->db->db_debug=FALSE;
return $this->db->delete("school_dean_messages", array('id'=>$id));
}
/** \ */
/** Applicat Cats */
function applicantCats(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('ps_code', $qs['k']);
}
$rs=$this->db->select("id, title, ps_code, disp_odr, status")->from("master_applicat_cats")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function applicantCatDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_applicat_cats", array('id'=>$id))->row_array();
return $rs;
}
function deleteApplicantCat($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_applicat_cats", array('id'=>$id));
}
/** \ */
/** Applicat religions */
function applicantReligions(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('ps_code', $qs['k']);
}
$rs=$this->db->select("id, title, ps_code, disp_odr, status")->from("master_applicat_religions")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function applicantReligionDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_applicat_religions", array('id'=>$id))->row_array();
return $rs;
}
function deleteApplicantReligion($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_applicat_religions", array('id'=>$id));
}
/** \ */
/** Marking Schemes */
function markingSchemes(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('ps_code', $qs['k']);
}
$rs=$this->db->select("id, title, ps_code, disp_odr, status,allowed_data")->from("master_marking_schemes")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function markingSchemeDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_marking_schemes", array('id'=>$id))->row_array();
return $rs;
}
function deleteMarkingScheme($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_marking_schemes", array('id'=>$id));
}
/** \ */
/** Edu Boards */
function eduBoards(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('ps_code', $qs['k']);
}
$rs=$this->db->select("id, title, ps_code, status")->from("master_edu_boards")->order_by("title")->get()->result_array();
return $rs;
}
function eduBoardDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_edu_boards", array('id'=>$id))->row_array();
return $rs;
}
function deleteEduBoard($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_edu_boards", array('id'=>$id));
}
/** \ */
/** Universities */
function universities(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k'])->or_like('ps_code', $qs['k']);
}
$this->db->select("id, title, ps_code, status")->from("master_universities")->order_by("title");
$rs=$this->dba->pagedRows($qs['p'], 100, 5);
return $rs;
}
function universityDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_universities", array('id'=>$id))->row_array();
return $rs;
}
function deleteUniversity($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_universities", array('id'=>$id));
}
/** \ */
/** 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, student_cc, daily_report")->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;
$rs['student_cc'] =$rs['student_cc']?true:false;
$rs['daily_report'] =$rs['daily_report']?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, report_grp, default_for_admin, ispaid, 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));
}
/** \ */
/** Coupans */
function coupans(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('title', $qs['k']);
}
$rs=$this->db->select("id, title, amt, DATE_FORMAT(expiry_date, '%d %b %Y') AS expiry_date, gender, disp_odr, status")->from("master_coupans")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function coupanDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_coupans", array('id'=>$id))->row_array();
if($rs){
$rs['expiry_date']=get_date($rs['expiry_date']);
}
return $rs;
}
function deleteCoupan($id){
$this->db->db_debug=FALSE;
return $this->db->delete("master_coupans", 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, app_fee, offer_msg, status")->from("master_states")->order_by("title")->get()->result_array();
if($rs){
foreach($rs as &$r){
$r['coupan_added']=0;
if($this->stateUsedCoupanIds($r['id'])){
$r['coupan_added']=1;
}
}
}
return $rs;
}
function stateDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("master_states", array('id'=>$id))->row_array();
if($rs){
$rs['coupanIds']=$this->stateUsedCoupanIds($rs['id']);
}
return $rs;
}
function stateUsedCoupanIds($state_id){
return $this->db->select("cu.coupan_id")
->from("coupans_in_use cu")
->join("master_coupans mc", "mc.id=cu.coupan_id")
->where(['cu.state_id'=>$state_id, 'mc.expiry_date>='=>date('Y-m-d')])
->get()->result_array();
}
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, steps, type, 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));
}
/** \ */
/** Lead Sources */
function lead_sources(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('SC.name', $qs['k'])->or_like('SC.email', $qs['k'])->or_like('SC.mobile', $qs['k'])->or_like('SC.type', $qs['k'])->or_like('SC.organisation', $qs['k'])->or_like('C.title', $qs['k']);
}
$rs=$this->db->select("SC.*, C.title state")->from("lead_sources SC")->join("master_states C", "C.id=SC.state_id")->order_by("SC.id", "DESC")->get()->result_array();
return $rs;
}
function all_lead_sources(){
return $this->db->select("id, type, state_id, name")->order_by("name")->get_where("lead_sources", ['status'=>1])->result_array();
}
function lead_source_states(){
return $this->db->select("DISTINCT s.id, s.title", false)->from("master_states s")->join("lead_sources ls", "s.id=ls.state_id")->order_by("s.title")->get()->result_array();
}
function delete_lead_source($id){
$this->db->db_debug=FALSE;
$this->db->delete("lead_sources", array('id'=>$id));
return $this->db->affected_rows();
}
/** \ */
/** Webinars */
function send_webinar_email_url($wb_id, $msg_email=''){
//13.234.217.79
if(ENVIRONMENT=='development'){
return URL.'api/initiate_webinar_email/'.$wb_id.'/'.USER_ID.'/'.$msg_email;
}else{
return URL.'api/initiate_webinar_email/'.$wb_id.'/'.USER_ID.'/'.$msg_email;
}
}
function send_webinar_invitaion_email_url($wb_id){
if(ENVIRONMENT=='development'){
return URL.'api/initiate_invitaion_email/'.$wb_id.'/'.USER_ID;
}else{
return URL.'api/initiate_invitaion_email/'.$wb_id.'/'.USER_ID;
}
}
function webinars($all=false){
$qs=trim_array($this->input->get());
if(!$all){
$this->db->where("W.status", 1);
}
if($qs['k']){
$this->db->like('W.title', $qs['k']);
}
$rs=$this->db->select("W.*, DS.title data_set")
->from("webinars W")
->join("leads_data_sets DS", "DS.id=W.data_set_id", "LEFT")
->order_by("W.id", "DESC")
->get()->result_array();
foreach($rs as &$r){
$r['status']=(int)$r['status'];
$r['web_date_time'] = get_date($r['web_date'].' '.$r['start_time'], true);
$r['web_date'] = get_date($r['web_date']);
$r['web_time'] = date('H:i:s',strtotime($r['web_date']));
$r['email_initiated']=(int)$r['email_initiated'];
$r['email_initiated_dt']=get_date($r['email_initiated_dt'], true);
/* if(!$r['email_initiated']){
$r['leads_count']=$r['no_of_emails_sent']=$r['no_of_accepted']='...';
}else */{
$count=$this->db->select("COUNT(1) leads_count, COUNT(IF(email_sent=1, 1, NULL)) no_of_emails_sent, COUNT(IF(accepted=1, 1, NULL)) no_of_accepted, COUNT(IF(inv_email_sent=1, 1, NULL)) no_of_inv_emails_sent")->get_where("webinar_leads", ['webinar_id'=>$r['id']])->row_array();
$r['leads_count']=(int)$count['leads_count'];
$r['no_of_emails_sent']=(int)$count['no_of_emails_sent'];
$r['no_of_accepted']=(int)$count['no_of_accepted'];
$r['no_of_inv_emails_sent']=(int)$count['no_of_inv_emails_sent'];
}
$r['email_processing']=(int)$r['email_processing'];
$r['inv_email_processing']=(int)$r['inv_email_processing'];
$r['send_email_api']=$this->send_webinar_email_url($r['id']);
$r['download_link']=URL.'master/download_webinar_leads/'.$r['id'];
}
return $rs;
}
function webinar_detail($id){
$rs=$this->db->get_where("webinars", ['id'=>$id])->row_array();
if($rs){
$rs['school']=$this->db->select("title")->get_where("master_schools", ['id'=>$rs['school_id']])->row()->title;
$rs['web_date_time'] = get_date($rs['web_date'], true);
$rs['web_date'] = get_date($rs['web_date']);
$rs['web_time'] = date('H:i:s',strtotime($rs['web_date']));
if(!$rs['data_set_id']){
$rs['data_set_id']='';
}
$rs['sms_initiated']=(int)$rs['sms_initiated'];
$rs['email_initiated']=(int)$rs['email_initiated'];
$rs['email_initiated_dt']=get_date($rs['email_initiated_dt'], true);
if(!$rs['email_initiated'] && !$rs['sms_initiated']){
$rs['leads_count']=$rs['no_of_emails_sent']=$rs['pending_email']=$rs['no_of_accepted']=0;
}else{
$count=$this->db->select("COUNT(1) leads_count, COUNT(IF(email_sent=1, 1, NULL)) no_of_emails_sent, COUNT(IF(accepted=1, 1, NULL)) no_of_accepted, COUNT(IF(inv_email_sent=1, 1, NULL)) no_of_inv_emails_sent")->get_where("webinar_leads", ['webinar_id'=>$rs['id']])->row_array();
$rs['leads_count']=(int)$count['leads_count'];
$rs['no_of_emails_sent']=(int)$count['no_of_emails_sent'];
$rs['no_of_accepted']=(int)$count['no_of_accepted'];
$r['no_of_inv_emails_sent']=(int)$count['no_of_inv_emails_sent'];
}
$rs['email_processing']=(int)$rs['email_processing'];
$rs['inv_email_processing']=(int)$rs['inv_email_processing'];
$rs['send_email_api']=$this->send_webinar_email_url($rs['id']);
$rs['banner_url']=$rs['banner']?UP_URLF.'webinars/'.$rs['banner']:'';
$rs['banner_sm_url']=$rs['banner_sm']?UP_URLF.'webinars/'.$rs['banner_sm']:'';
$rs['speakers']=$this->webinar_speakers($id);
}
return $rs;
}
function webinar_speakers($wb_id){
$rs=$this->db->where("webinar_id", $wb_id)->get("webinar_speakers")->result_array();
foreach($rs as &$r){
$r['photo_url']=$r['photo']?UP_URLF.'webinars/'.$r['photo']:'';
}
return $rs;
}
function delete_webinar($id){
$this->db->db_debug=FALSE;
$this->db->delete("webinars", array('id'=>$id));
return $this->db->affected_rows();
}
function save_webinar_leads($wb_id){
$wb_dtl=$this->db->select("id, data_set_id")->get_where("webinars", ['id'=>$wb_id])->row_array();
$this->db->delete("webinar_leads", ['webinar_id'=>$wb_id]);
if($wb_dtl['data_set_id']){
$ds_dtl=$this->dataset->detail($wb_dtl['data_set_id']);
$this->common->set_data_set_cond($ds_dtl, true);
$rs=$this->db->select("A.id application_id, U.name, U.email, U.mob", false)
->from("applications A ")
->join("applicants U ", "A.applicant_id=U.id")
->join("ps_stu_status PSS", "PSS.EMPLID=A.application_no", "LEFT")
->get()->result_array();
$wdata=[];
foreach($rs as $r){
$accepturl=base64_encode(URL.'api/accept_webinar/'.$wb_id.'/'.$r['application_id']);
$webinar_url=WebinarUrl.'?url='.$accepturl.'&wb_id='.base64_encode($wb_id);
$wdata[]=['webinar_id'=>$wb_dtl['id'], 'application_id'=>$r['application_id'], 'name'=>$r['name'], 'email'=>$r['email'], 'mob'=>$r['mob'], 'webinar_url'=>$webinar_url, 'created'=>currentDT(), 'updated'=>currentDT()];
}
if($wdata){
$this->db->insert_batch("webinar_leads", $wdata);
}
}
}
function webinar_leads($wb_id){
$rs=$this->db->select("A.id, A.application_no, A.step_completed, A.created, A.ac_id, A.discipline_id, A.plan_id, P.type_id, P.title program, U.lpage_id, U.verified_by, U.state_id, U.name, U.email, U.mob, W.title webinar, WL.webinar_url", false)
->from("applications A")
->join("applicants U", "A.applicant_id=U.id")
->join("master_programs P", "P.id=A.program_id")
->join("webinar_leads WL", "WL.application_id=A.id")
->join("webinars W", "WL.webinar_id=W.id")
->where("WL.webinar_id", $wb_id)
->get()->result_array();
if($rs){
$md=$this->common->master_data_for_leads();
foreach($rs as &$r){
$r['state'] =$md['states'][$r['state_id']];
$r['lpage'] =$md['lpages'][$r['lpage_id']];
$r['plan'] =$md['plans'][$r['plan_id']];
$r['ac'] =$md['acs'][$r['ac_id']];
$r['program_type'] =$md['program_types'][$r['type_id']];
$r['discipline'] =$md['disciplines'][$r['discipline_id']];
$r['login_url']=generate_login_url($r['lpage'], $r['mob']);
unset($r['state_id'], $r['lpage_id'], $r['plan_id']);
}
}
return $rs;
}
function school_names(){
return $this->db->select("id,title")
->from("master_schools")
->where(['status'=>1])
->get()->result_array();
}
/** */
function getAboutSuat(){
return $this->db->select("datavalue")->get_where("master_data", ['datakey'=>'about_suat'])->row("datavalue");
}
//SUSAT Exam Date
function susatExamDate(){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->like('date', $qs['k']);
}
$rs=$this->db->select("*")->from("susat_exam_date")->order_by("disp_odr")->get()->result_array();
return $rs;
}
function examDateDtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("susat_exam_date", array('id'=>$id))->row_array();
return $rs;
}
function deleteExamDate($id){
$this->db->db_debug=FALSE;
return $this->db->delete("susat_exam_date", array('id'=>$id));
}
}
//End of file
Kontol Shell Bypass