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/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.state_id, U.city_id, U.city, U.pincode, U.address, U.father_name,
A.program_id, A.plan_id, A.ac_id, P.discipline_id, D.title discipline,
E.status_10th, E.board_id_10th, E.board_10th, E.marking_scheme_id_10th, E.marks_10th, E.passing_year_10th,
E.status_12th, E.board_id_12th, E.board_12th, E.marking_scheme_id_12th, E.marks_12th, E.passing_year_12th,
E.status_dip, E.board_id_dip, E.board_dip, E.marking_scheme_id_dip, E.marks_dip, E.passing_year_dip,
E.status_ug, E.university_id_ug, E.university_ug, E.marking_scheme_id_ug, E.marks_ug, E.passing_year_ug,
E.status_pg, E.university_id_pg, E.university_pg, E.marking_scheme_id_pg, E.marks_pg, E.passing_year_pg";
$adtl=$this->db->select($f)
->from("applications A")
->join("applicants U", "A.applicant_id=U.id")
->join("master_programs P", "P.id=A.program_id", "LEFT")
->join("master_disciplines D", "D.id=P.discipline_id", "LEFT")
->join("applicants_edu_details E", "E.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';
$d=$this->db->from("adm_form")->where(['app_id'=>$app_id])->get()->row_array();
//pr($this->db->last_query());
//die;
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;
}
$d['discipline_id']=$adtl['discipline_id'];
$d['discipline']=$adtl['discipline'];
$d['ac_dtl']=$this->common->acDtl($adtl['ac_id']);
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'] 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']=URLF.'api/admform/admission_form/'.encode($d['app_id']).'/'.$d['application_no'];
$d['download_adm_form_url']=URLF.'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;
}
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['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 lists(){
$qs=trim_array($this->input->get());
$this->common->set_data_set_cond(false, false);
if($qs['k']){
$this->db->group_start()
->or_like('F.name', $qs['k'])
->or_like('F.email', $qs['k'])
->or_like('F.mob', $qs['k'])
->or_like('A.application_no', $qs['k'])
->group_end();
}
if($qs['fromDate']){
$this->db->where("F.created >=", date('Y-m-d', strtotime($qs['fromDate'])));
}
if($qs['toDate']){
$this->db->where("F.created <=", date('Y-m-d 23:59:59', strtotime($qs['toDate'])));
}
if($qs['step_completed']){
//$this->db->where_in("F.step_completed", explode(",", $qs['step_completed']));
if($qs['step_completed']=='Final'){
$this->db->where("F.final_submitted", 1);
}else if(is_numeric($qs['step_completed'])){
$this->db->where("F.step_completed", $qs['step_completed']);
}else{
$this->db->where("F.status", $qs['step_completed']);
}
}
if($qs['status']){
$this->db->where("F.status", $qs['status']);
}
if($qs['state_ids']){
$this->db->where_in("F.state_id", explode(",", $qs['state_ids']));
}
$this->db->select("F.id, F.app_id, F.created, F.name, F.email, F.mob, F.state_id, F.father_name, F.gender, F.dob, F.status, A.application_no, F.step_completed, F.final_submitted, F.ac_id, F.program_id, F.plan_id")
->from("adm_form F")
->join("applications A", "A.id=F.app_id")
->join("applicants U", "U.id=A.applicant_id")
->order_by("F.id", "DESC");
$ps=50;
if($export){
$ps=100000;
}
$rs=$this->dba->pagedRows($qs['p'], $ps, 5, $export?'0':'');
if($rs['result']){
$md=$this->common->master_data_for_leads();
foreach($rs['result'] as &$r){
$r['state'] =$md['states'][$r['state_id']];
$r['ac'] =$md['acs'][$r['ac_id']];
$r['program'] =$md['programs'][$r['program_id']];
$r['plan'] =$md['plans'][$r['plan_id']];
$r['created'] =get_date($r['created']);
$r['step_completed']=(int)$r['step_completed'];
$r['final_submitted']=(int)$r['final_submitted'];
$r['admission_card_url']=URLF.'api/admform/download_adm_form_pdf/'.encode($r['app_id']);
}
}
return $rs;
}
}
//End of file
Kontol Shell Bypass