ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/lms/lms/api/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/lms/lms/api/application/models/Phdform_model.php |
<?php
class Phdform_model extends CI_Model {
function __construct() {
parent::__construct();
}
function detail($app_id=APP_ID){
$f="A.id app_id, A.application_no, U.lpage_id, U.name, U.email, U.mob, U.dob, U.gender, U.cat_id, U.religion_id, U.state_id, U.city_id, U.city, U.pincode, U.address, U.father_name,
A.program_id, A.plan_id, A.ac_id, U.utm_source, U.utm_campaign, U.utm_medium, U.utm_term, U.utm_content, U.utm_keyword, U.utm_placement";
$adtl=$this->db->select($f)
->from("applications A")
->join("applicants U", "A.applicant_id=U.id")
->where(["A.id"=>$app_id])
->get()->row_array();
$adtl['dob']=get_date($adtl['dob']);
//$adtl['lpage']=$this->db->select("title")->get_where("landing_pages", ['id'=>$adtl['lpage_id']])->row("title");
$adtl['utm_source']=$adtl['utm_source']?$adtl['utm_source']:'N/A';
$adtl['utm_campaign']=$adtl['utm_campaign']?$adtl['utm_campaign']:'N/A';
$adtl['utm_medium']=$adtl['utm_medium']?$adtl['utm_medium']:'N/A';
$adtl['utm_term']=$adtl['utm_term']?$adtl['utm_term']:'N/A';
$adtl['utm_content']=$adtl['utm_content']?$adtl['utm_content']:'N/A';
$adtl['utm_keyword']=$adtl['utm_keyword']?$adtl['utm_keyword']:'N/A';
$adtl['utm_placement']=$adtl['utm_placement']?$adtl['utm_placement']:'N/A';
$d=$this->db->from("phd_app_form")->where(['app_id'=>$app_id])->get()->row_array();
if($d){
$d['signature_url']=($d['signature']) ? UP_URLF.'admissions/signatures/'.$d['signature'] : '';
$d['profile_photo_url'] = ($d['profile_photo']) ? UP_URLF.'admissions/profiles/'.$d['profile_photo'] : '';
$d['id_proof_img_url'] = ($d['id_proof_img']) ? UP_URLF.'admissions/docs/'.$d['id_proof_img'] : '';
$d['exp_certificate_url'] = ($d['exp_certificate']) ? UP_URLF.'admissions/docs/'.$d['exp_certificate'] : '';
$d['pg_degree_url'] = ($d['pg_degree']) ? UP_URLF.'admissions/docs/'.$d['pg_degree'] : '';
$d['marksheet_10th_url'] = ($d['marksheet_10th']) ? UP_URLF.'admissions/docs/'.$d['marksheet_10th'] : '';
$d['marksheet_12th_url'] = ($d['marksheet_12th']) ? UP_URLF.'admissions/docs/'.$d['marksheet_12th'] : '';
$d['marksheet_mphil_url'] = ($d['marksheet_mphil']) ? UP_URLF.'admissions/docs/'.$d['marksheet_mphil'] : '';
$d['marksheet_other_url'] = ($d['marksheet_other']) ? UP_URLF.'admissions/docs/'.$d['marksheet_other'] : '';
if($d['marksheet_ug']){
$marksheet_ug = explode(",",$d['marksheet_ug']);
$d['marksheet_ug']=[];
foreach($marksheet_ug as $i=>$r){
$d['marksheet_ug'][$i]['url'] = UP_URLF.'admissions/docs/'.$r;
$d['marksheet_ug'][$i]['name'] = $r;
}
}
if($d['marksheet_pg']){
$marksheet_pg = explode(",",$d['marksheet_pg']);
$d['marksheet_pg']=[];
foreach($marksheet_pg as $i=>$r){
$d['marksheet_pg'][$i]['url'] = UP_URLF.'admissions/docs/'.$r;
$d['marksheet_pg'][$i]['name'] = $r;
}
}
//$d['application_no'] = $this->db->select("application_no")->from("applications")->where(['id'=>$d['app_id']])->get()->row_array()['application_no'];
$d['category'] = $this->db->select("ps_code")->from("master_applicat_cats")->where(['id'=>$adtl['cat_id']])->get()->row_array()['ps_code'];
$d['religion'] = $this->db->select("ps_code")->from("master_applicat_religions")->where(['id'=>$adtl['religion_id']])->get()->row_array()['ps_code'];
$d['program'] = $this->db->select("title")->from("master_programs")->where(['id'=>$adtl['program_id']])->get()->row_array()['title'];
$d['plan'] = $this->db->select("title")->from("master_program_plans")->where(['id'=>$adtl['plan_id']])->get()->row_array()['title'];
$d['state'] = $this->db->select("title")->from("master_states")->where(['id'=>$adtl['state_id']])->get()->row_array()['title'];
$d['city'] = $this->db->select("title")->from("master_cities")->where(['id'=>$adtl['city_id']])->get()->row_array()['title'];
$d['school_state_10th'] = $this->db->select("title")->from("master_states")->where(['id'=>$d['school_state_id_10th']])->get()->row_array()['title'];
$d['school_state_12th'] = $this->db->select("title")->from("master_states")->where(['id'=>$d['school_state_id_12th']])->get()->row_array()['title'];
$state = $this->db->select("title")->from("master_states")->where(['id'=>$d['school_state_id_ug']])->get()->row_array();
$d['school_state_ug'] = ($state) ? $state['title'] : '';
$state = $this->db->select("title")->from("master_states")->where(['id'=>$d['school_state_id_pg']])->get()->row_array();
$d['school_state_pg'] = ($state) ? $state['title'] : '';
$mschemes=key_val_array($this->db->select("id, title")->get("master_marking_schemes")->result_array(), 'id', 'title');
$d['marking_scheme_10th']=$mschemes[$d['marking_scheme_id_10th']];
$d['marking_scheme_12th']=$mschemes[$d['marking_scheme_id_12th']];
$d['marking_scheme_ug']=$mschemes[$d['marking_scheme_id_ug']];
$d['marking_scheme_pg']=$mschemes[$d['marking_scheme_id_pg']];
$d['ps_app_no']=$this->db->select("ADM_APPL_NBR")->get_where("ps_stu_status", ['EMPLID'=>$d['application_no']])->row()->ADM_APPL_NBR;
}else{
$d=[];
$d['physically_challenged']='N';
$d['house_income']='';
$d['id_proof']='';
$d['source_of_info']='';
}
foreach($adtl as $k=>$v){
$d[$k]=$v;
}
$d['school_state_id_10th']=$d['school_state_id_10th']?$d['school_state_id_10th']:'';
$cols=[
'state_id', 'city_id', 'cat_id', 'religion_id',
'board_id_10th', 'marking_scheme_id_10th', 'school_state_id_10th',
'board_id_12th', 'marking_scheme_id_12th', 'school_state_id_12th',
'board_id_dip', 'marking_scheme_id_dip', 'school_state_id_dip',
'university_id_ug', 'marking_scheme_id_ug', 'school_state_id_ug',
'university_id_othr', 'marking_scheme_id_othr', 'school_state_id_othr',
'university_id_pg', 'marking_scheme_id_pg', 'school_state_id_pg',
];
foreach($cols as $k){
$d[$k]=$d[$k]?$d[$k]:'';
}
if(!$d['step_completed'] || $d['step_completed']<2){
$d['status_10th']=$d['status_12th']=$d['status_dip']=$d['status_ug']=$d['status_pg']=$d['status_othr']='';
}
foreach($d as $k=>$v){
if(strpos($k, 'passing_year')!==FALSE){
if(!$d[$k]){
$d[$k]='';
}
}
}
$d['dob']=get_date($d['dob']);
$d['step_completed']=(int)$d['step_completed'];
$d['final_submitted']=(int)$d['final_submitted'];
//$d['admission_card_url']=URL.'admform/admission_form/'.encode($d['app_id']).'/'.$d['application_no'];
$d['admission_card_url']=URLF.'api/phdform/download_adm_form_pdf/'.encode($d['app_id']);
$d['admission_card_print_url']=$d['admission_card_url'].'?print=1';
return $d;
}
function acs(){
return $this->db->select("id, title")->order_by("disp_odr")->get_where("master_academic_careers", array('status'=>1))->result_array();
}
function disciplines(){
$rs=$this->db->select("id, title")
->from("master_disciplines")
->order_by("disp_odr")
->get()->result_array();
return $rs;
}
function programs(){
$rs=$this->db->select("P.id, P.title, P.ac_id")
->from("master_programs P")
//->where(['P.status'=>1])
->order_by("title")
->get()->result_array();
return $rs;
}
function plans(){
$rs=$this->db->select("PP.id, PP.program_id, PP.title, PP.code, P.discipline_id, P.ac_id")
->from("master_program_plans PP")
->join("master_programs P", "P.id=PP.program_id")
//->where(['PP.status'=>1])
->order_by("PP.title")->get()->result_array();
return $rs;
}
function states(){
return $this->db->select("id, title")->order_by("title")->get_where("master_states", array('status'=>1))->result_array();
}
function cities(){
$cond=array('status'=>1);
return $this->db->select("id, state_id, title, pincode")->order_by("title")->get_where("master_cities", $cond)->result_array();
}
function marking_schemes(){
$res=$this->db->select("id, title, allowed_data")->from("master_marking_schemes")->where("status", 1)->order_by("disp_odr")->get()->result_array();
/* foreach($res as $k=>$v){
$v['allowed_data']=trim($v['allowed_data']);
$res[$k]['allowed_values'] = explode(',',$v['allowed_data']);
} */
return $res;
}
function boards(){
return $this->db->select("id, title")->from("master_edu_boards")->where("status", 1)->order_by("title")->get()->result_array();
}
function universities(){
return $this->db->select("id, title")->from("master_universities")->where("status", 1)->order_by("title")->get()->result_array();
}
function religions(){
return $this->db->select("id, title")->from("master_applicat_religions")->where("status", 1)->order_by("disp_odr")->get()->result_array();
}
function applicant_cats(){
return $this->db->select("id, title")->from("master_applicat_cats")->where("status", 1)->order_by("disp_odr")->get()->result_array();
}
/** */
function save_step1($data, $data1, $data2){
$data['app_id'] = APP_ID;
$adm_form=$this->db->select("id")->get_where("phd_app_form", ['app_id'=>APP_ID])->row();
if($adm_form){
$data['id']=$adm_form->id;
}
$data1['id']=$this->db->select("applicant_id")->get_where("applications", ['id'=>APP_ID])->row("applicant_id");
$this->dba->save('applicants', $data1);
$data2['id']=APP_ID;
$this->dba->save('applications', $data2);
return $this->dba->save('phd_app_form', $data);
}
function save_step2($data){
$res=['success'=>false, 'msg'=>'Error!'];
$data['id']=(int)$this->db->select("id")->get_where("phd_app_form", ['app_id'=>APP_ID])->row()->id;
if(!$data['id']){
throw new \Exception("First Save Step 1");
}
if($this->dba->save("phd_app_form", $data)){
if($data['step_completed']=='2'){
$data2=['id'=>APP_ID, 'step_completed'=>2];
$this->dba->save('applications', $data2);
}
$res=['success'=>true, 'msg'=>'Educational Details completed successfully'];
}
return $res;
}
function get_step_completed(){
$rs=$this->db->select("step_completed, final_submitted")->get_where("phd_app_form", ['app_id'=>APP_ID])->row_array();
$rs['step_completed']=(int)$rs['step_completed'];
$rs['final_submitted']=(int)$rs['final_submitted'];
return $rs;
}
/** */
function coupans($plan_id, $program_id=0, $applicant_id=0){
$lpage=$this->db->select("lpage")->order_by("id", "DESC")->limit(1)->get_where("applicants_visit_history", ['applicant_id'=>$applicant_id])->row()->lpage;
$str=rtrim(trim($lpage), "/");
$str=str_replace(array("http://", "https://", "www."), array("", "", ""), $str);
$lpage_id=$this->db->select("id")->get_where("landing_pages", array('trimed_title'=>$str))->row()->id;
$state_id=$this->db->select("state_id")->get_where("applicants", ['id'=>$applicant_id])->row()->state_id;
$res=$this->db->select("coupan_id")->get_where("coupans_in_use", array('plan_id'=>$plan_id))->result_array();
if(!$res){
$res=$this->db->select("coupan_id")->get_where("coupans_in_use", array('program_id'=>$program_id))->result_array();
}
if(!$res){
$res=$this->db->select("coupan_id")->get_where("coupans_in_use", array('state_id'=>$state_id))->result_array();
}
if(!$res){
$res=$this->db->select("coupan_id")->get_where("coupans_in_use", array('lpage_id'=>$lpage_id))->result_array();
}
$rs=[];
if($res){
$cids=[];
foreach($res as $r){
$cids[]=$r['coupan_id'];
}
$this->db->where(array('status'=>1, 'expiry_date >='=>date('Y-m-d')))->where_in("id", $cids);
$rs=$this->db->select("id, title, amt, description, gender")->from("master_coupans")->order_by("disp_odr")->get()->result_array();
foreach($rs as &$r){
$r['amt']=(float)$r['amt'];
}
}
return $rs;
}
function applicationDtl($appId=0){
$r=$this->db->select("A.id, A.campus_id, A.applicant_id, A.application_no, A.step_completed, A.fee, A.coupan_used, A.coupan_amt, A.payment_status, A.created, P.type_id prg_type_id, P.ac_id, P.discipline_id, P.school_id, P.id AS program_id, A.plan_id, PP.title AS plan, PP.fee AS planAppFee, P.fee AS prgAppFee, P.title AS program, P.image AS progImage, S.brochure AS progBrochure")
->from("applications AS A")
->join("master_program_plans AS PP", "A.plan_id=PP.id")
->join("master_programs AS P", "PP.program_id=P.id")
->join("master_schools AS S", "S.id=P.school_id")
->where(array('A.id'=>$appId))
->get()->row_array();
if($r){
$r['progImageUrl']=$r['progImage']?UP_URLF.'programs_images/'.$r['progImage']:'';
$r['progBrochureUrl']=$r['progBrochure']?UP_URLF.'brochure/'.$r['progBrochure']:'';
$r['progBrochureDwnUrl']=$r['progBrochure']?(URL.'common/downloadFile/'.encode(UP_PATHF.'brochure/'.$r['progBrochure'])):'';
$r['receiptDownloadUrl']=URL.'common/downloadReceipt/'.$appId;
$r['SuatSlotBookUrl']=SUAT_SLOT_BOOK_URL;
$udtl=$this->db->select("U.mob, U.is_medical, U.is_phd, L.instant_fee, L.title lpage")->from("applicants U")->join("landing_pages L", "L.id=U.lpage_id")->where(['U.id'=>$r['applicant_id']])->get()->row_array();
$r['is_medical']=(int)$udtl['is_medical'];
$r['is_phd']=(int)$udtl['is_phd'];
$r['instant_fee']=(int)$udtl['instant_fee'];
$r['payment_status']=(int)$r['payment_status'];
$r['step_completed']=(int)$r['step_completed'];
if($r['step_completed']==3){
$r['fee']=(float)$r['fee'];
$r['coupan_amt']=(float)$r['coupan_amt'];
}else{
if((float)$r['planAppFee']){
$r['fee']=(float)$r['planAppFee'];
}else{
$r['fee']=(float)$r['prgAppFee'];
}
$r['coupan_used']='';
$r['coupan_amt']=0;
}
$r['netAmt']=($r['fee']-$r['coupan_amt']);
$r['created']=get_date($r['created']);
unset($r['prgAppFee'], $r['planAppFee']);
$r['coupans']=$this->coupans($r['plan_id'], $r['program_id'], $r['applicant_id']);
}
return $r;
}
}
//End of file
Kontol Shell Bypass