ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/api/application/models_old/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/api/application/models_old/Ps_model.php |
<?php
class Ps_model extends CI_Model {
function __construct() {
parent::__construct();
}
function addLeadToPS($app_id, $tooracle=true){
$dtl=$this->db->select("A.id, A.applicant_id, A.application_no, A.step_completed, A.updated AS leadUpdated, PP.title AS plan, P.title AS program,
AC.title AS ac, PT.title AS program_type, PP.ac_code, PP.program_code AS prgCode, PP.code AS planCode, U.name, U.email, U.mob, U.dob, U.gender, U.address,
U.city, U.pincode, S.title AS state, S.code AS stateCode, U.verified_by, U.father_name, U.utm_source, U.identity_proof, U.identity_proof_no, U.profile_pic,
ED.board_10th, B10.ps_code AS ps_code_b10, M10.title AS marking_scheme_10, M10.ps_code AS ps_code_m10, ED.marks_10th, ED.passing_year_10th,
ED.board_12th, B12.ps_code AS ps_code_b12, M12.title AS marking_scheme_12, M12.ps_code AS ps_code_m12, ED.marks_12th, ED.passing_year_12th,
ED.board_dip, DIP.ps_code AS ps_code_bdip, MDIP.title AS marking_scheme_dip, MDIP.ps_code AS ps_code_mdip, ED.marks_dip, ED.passing_year_dip,
ED.university_ug, UUG.ps_code AS ps_code_uug, MUG.title AS marking_scheme_ug, MUG.ps_code AS ps_code_mug, ED.marks_ug, passing_year_ug,
ED.university_pg, UPG.ps_code AS ps_code_upg, MPG.title AS marking_scheme_pg, MPG.ps_code AS ps_code_mpg, ED.marks_pg, passing_year_pg,
CT.title AS cat, CT.ps_code AS ps_code_cat, RL.title AS religion, RL.ps_code AS ps_code_religion,
LP.title AS lpage, A.payment_status, A.payment_mode, A.cash_order_id, CC.amount cash_amt, PTRANS.pay_order_id, PTRANS.txn_id, PTRANS.txn_status, PTRANS.txn_amt")
->from("applications AS A")
->join("applicants AS U", "U.id=A.applicant_id")
->join("master_states AS S", "S.id=U.state_id")
->join("landing_pages AS LP", "LP.id=U.lpage_id")
->join("master_program_plans AS PP", "PP.id=A.plan_id")
->join("master_programs AS P", "P.id=PP.program_id")
->join("master_academic_careers AS AC", "AC.id=P.ac_id")
->join("master_program_types AS PT", "PT.id=P.type_id")
->join("applicants_edu_details AS ED", "ED.applicant_id=U.id", "LEFT")
->join("master_edu_boards AS B10", "B10.id=ED.board_id_10th", "LEFT")
->join("master_marking_schemes AS M10", "M10.id=ED.marking_scheme_id_10th", "LEFT")
->join("master_edu_boards AS B12", "B12.id=ED.board_id_12th", "LEFT")
->join("master_marking_schemes AS M12", "M12.id=ED.marking_scheme_id_12th", "LEFT")
->join("master_edu_boards AS DIP", "DIP.id=ED.board_id_dip", "LEFT")
->join("master_marking_schemes AS MDIP", "MDIP.id=ED.marking_scheme_id_dip", "LEFT")
->join("master_universities AS UUG", "UUG.id=ED.university_id_ug", "LEFT")
->join("master_marking_schemes AS MUG", "MUG.id=ED.marking_scheme_id_ug", "LEFT")
->join("master_universities AS UPG", "UPG.id=ED.university_id_pg", "LEFT")
->join("master_marking_schemes AS MPG", "MPG.id=ED.marking_scheme_id_pg", "LEFT")
->join("master_applicat_cats AS CT", "CT.id=U.cat_id", "LEFT")
->join("master_applicat_religions AS RL", "RL.id=U.religion_id", "LEFT")
->join("pay_trans PTRANS", "PTRANS.id=A.pay_trans_id", "LEFT")
->join("cash_collections CC", "CC.application_id=A.id", "LEFT")
->where("A.id", $app_id)
->get()->row_array();
if(!$dtl){
return;
}
$name=explode(" ", $dtl['name']);
$lastname=".";
if(trim($name[1])){
$lastname=trim(trim($name[1])." ".trim($name[2]));
}
if($dtl['payment_mode']=='CASH'){
$dtl['txn_amt']=$dtl['cash_amt'];
}
$d=replace_null(array(
'EMPLID'=>$dtl['application_no'],
'REF1_DESCR'=>$dtl['payment_mode']=='CASH'?$dtl['cash_order_id']:$dtl['pay_order_id'],
'FIRST_NAME'=>$name[0],
'LAST_NAME'=>$lastname,
'BIRTHDATE'=>$dtl['dob'],
'PHONE'=>$dtl['mob'],
'EMAIL_ADDR'=>$dtl['email'],
'SEX'=>($dtl['gender']=='Male'?'M':($dtl['gender']=='Female'?'F':'U')),
'ACAD_CAREER'=>$dtl['ac_code'],
'ACAD_PROG'=>$dtl['prgCode'],
'ACAD_PLAN'=>$dtl['planCode'],
'SU_ADDRESS'=>$dtl['address'],
'CITY'=>$dtl['city'],
'STATE'=>$dtl['stateCode'],
'POSTAL'=>$dtl['pincode'],
'COUNTRY'=>'IND',
'S_AD_APPL_TYPE'=>'N',
'DATE1'=>$dtl['leadUpdated'],
'NATIONAL_ID_TYPE'=>' ',
'NATIONAL_ID'=>' ',
'NID_SPECIAL_CHAR'=>' ',
'S_CATEGORY_CD'=>$dtl['ps_code_cat'],
'S_NAMES'=>$dtl['father_name'],
'SU_RGN'=>$dtl['ps_code_religion'],
'S_10_BOARD'=>$dtl['ps_code_b10'],
'S_YEAR_OF_PASS_10'=>$dtl['passing_year_10th']?$dtl['passing_year_10th']:'',
'SU_10_MARK_SCHEME'=>$dtl['ps_code_m10'],
'SU_10_MARKS'=>$dtl['marks_10th'],
'S_12_BOARD'=>$dtl['ps_code_b12'],
'S_YEAR_OF_PASS_12'=>$dtl['passing_year_12th']?$dtl['passing_year_12th']:'',
'SU_12_MARK_SCHEME'=>$dtl['ps_code_m12'],
'SU_12_MARKS'=>$dtl['marks_12th'],
'S_DIP_BOARD'=>$dtl['ps_code_bdip'],
'S_YEAR_PASS_DIPLMA'=>$dtl['passing_year_dip']?$dtl['passing_year_dip']:'',
'SU_DIP_MARK_SCHEME'=>$dtl['ps_code_mdip'],
'SU_DIP_MARKS'=>$dtl['marks_dip'],
'S_GRAD_UNIVERSITY'=>$dtl['ps_code_uug'],
'S_YEAR_PASS_GRAD'=>$dtl['passing_year_ug']?$dtl['passing_year_ug']:'',
'SU_GR_MARK_SCHEME'=>$dtl['ps_code_mug'],
'SU_GR_MARKS'=>$dtl['marks_ug'],
'S_PGRAD_UNIVERSITY'=>$dtl['ps_code_upg'],
'S_YEAR_PASS_PGRAD'=>$dtl['passing_year_pg']?$dtl['passing_year_pg']:'',
'SU_PG_MARK_SCHEME'=>$dtl['ps_code_mpg'],
'SU_PG_MARKS'=>$dtl['marks_pg'],
'AMT'=>$dtl['txn_amt'],
'SU_PRCS_STATUS'=>'U',
'ENTERED_DATETIME'=>$dtl['leadUpdated'],
'LASTUPDOPRID'=>'LMS_USER',
'LASTUPDDTTM'=>$dtl['leadUpdated'],
));
foreach($d as $k=>$v){
if(strlen($d[$k])==0){
$d[$k]=' ';
}
}
if($this->db->select("EMPLID")->get_where("people_soft_tbl", array('EMPLID'=>$d['EMPLID']))->row()->EMPLID){
$this->db->update("people_soft_tbl", $d, array('EMPLID'=>$d['EMPLID']));
}else{
$this->db->insert("people_soft_tbl", $d);
}
if(ENVIRONMENT=='shardalive' && $tooracle){
$d['COMMENT1']=' ';
$d['BIRTHDATE']=strtoupper(date("d-M-y", strtotime($d['BIRTHDATE'])));
$d['DATE1']=strtoupper(date("d-M-y", strtotime($d['DATE1'])));
$d['ENTERED_DATETIME']=strtoupper(date("d-M-y h.i.s.000000000 A", strtotime($d['ENTERED_DATETIME'])));
$d['LASTUPDDTTM']=strtoupper(date("d-M-y h.i.s.000000000 A", strtotime($d['LASTUPDDTTM'])));
$this->oracle=$this->load->database("oracle", true);
$this->oracle->db_debug=FALSE;
if($this->oracle->select("EMPLID")->get_where("PS_SU_OLA_AT_STAG", array('EMPLID'=>$d['EMPLID']))->row()->EMPLID){
//$this->oracle->update("PS_SU_OLA_AT_STAG", $d, array('EMPLID'=>$d['EMPLID']));
}else{
$this->oracle->insert("PS_SU_OLA_AT_STAG", $d);
}
}
}
function deleteLeadFromPS($app_no){
$this->db->db_debug=FALSE;
$this->db->delete("people_soft_tbl", array('EMPLID'=>$app_no));
}
function lists($export=FALSE){
$qs=trim_array($this->input->get());
if($qs['k']){
$this->db->group_start()
->like('EMPLID', $qs['k'])
->or_like('REF1_DESCR', $qs['k'])
->or_like('PHONE', $qs['k'])
->or_like('EMAIL_ADDR', $qs['k'])
->group_end();
}
if($qs['fromDate']){
$this->db->where("DATE1 >=", date('Y-m-d', strtotime($qs['fromDate'])));
}
if($qs['toDate']){
$this->db->where("DATE1 <=", date('Y-m-d', strtotime($qs['toDate'])));
}
$this->db->select("*")->from("people_soft_tbl")->order_by("LASTUPDDTTM", "DESC");
$ps=50;
if($export){
$ps=100000;
}
$rs=$this->dba->pagedRows($qs['p'], $ps, 5, $export?'0':'');
return $rs;
}
function lists_oracle($export=FALSE){
$this->oracle=$this->load->database("oracle", true);
$qs=trim_array($this->input->get());
$total=0;
if(!$export){
$total=$this->count_oracle_records($qs);
}
if($qs['k']){
$this->oracle->group_start()
->like('EMPLID', $qs['k'])
->or_like('REF1_DESCR', $qs['k'])
->or_like('PHONE', $qs['k'])
->or_like('EMAIL_ADDR', $qs['k'])
->group_end();
}
if($qs['fromDate']){
$dt=strtoupper(date("d-M-y", strtotime($qs['fromDate'])));
$this->oracle->where("DATE1 >=", $dt);
}
if($qs['toDate']){
$dt=strtoupper(date("d-M-y", strtotime($qs['toDate'])));
$this->oracle->where("DATE1 <=", $dt);
}
$this->oracle->select("*")->from("PS_SU_OLA_AT_STAG")->order_by("LASTUPDDTTM", "DESC");
$ps=50;
if($export){
$ps=100000;
}
$rs=$this->oraclePagedRows($qs['p'], $ps, 5, $total);
$rs['total']=$total;
return $rs;
}
function count_oracle_records($qs){
if($qs['k']){
$this->oracle->group_start()
->like('EMPLID', $qs['k'])
->or_like('REF1_DESCR', $qs['k'])
->or_like('PHONE', $qs['k'])
->or_like('EMAIL_ADDR', $qs['k'])
->group_end();
}
if($qs['fromDate']){
$dt=strtoupper(date("d-M-y", strtotime($qs['fromDate'])));
$this->oracle->where("DATE1 >=", $dt);
}
if($qs['toDate']){
$dt=strtoupper(date("d-M-y", strtotime($qs['toDate'])));
$this->oracle->where("DATE1 <=", $dt);
}
$total=(int)$this->oracle->select("COUNT(1) N")->from("PS_SU_OLA_AT_STAG")->get()->row()->N;
//return $this->oracle->last_query();
return $total;
}
function add_to_oracle_db($data){
$res=['updated'=>0, 'added'=>0, 'msg'=>'DB Error!', 'success'=>false];
$this->oracle=$this->load->database("oracle", true);
$this->oracle->db_debug=FALSE;
foreach($data as $d){
foreach($d as $k=>$v){
if(strlen($d[$k])==0){
$d[$k]=' ';
}
}
$d['COMMENT1']=' ';
$d['BIRTHDATE']=strtoupper(date("d-M-y", strtotime($d['BIRTHDATE'])));
$d['DATE1']=strtoupper(date("d-M-y", strtotime($d['DATE1'])));
$d['ENTERED_DATETIME']=strtoupper(date("d-M-y h.i.s.000000000 A", strtotime($d['ENTERED_DATETIME'])));
$d['LASTUPDDTTM']=strtoupper(date("d-M-y h.i.s.000000000 A", strtotime($d['LASTUPDDTTM'])));
if($this->oracle->select("EMPLID")->get_where("PS_SU_OLA_AT_STAG", array('EMPLID'=>$d['EMPLID']))->row()->EMPLID){
//$this->oracle->update("PS_SU_OLA_AT_STAG", $d, array('EMPLID'=>$d['EMPLID']));
$res['updated']++;
}else{
$this->oracle->insert("PS_SU_OLA_AT_STAG", $d);
if($this->oracle->affected_rows()){
$res['added']++;
}
}
}
if($res['updated'] || $res['added']){
$res['success']=true;
$res['msg']=$res['added']." new records added. ".($res['updated']>0?$res['updated']." records was already added.":'');
}
return $res;
}
function delete($id){
if($qs['from_db']=='Oracle'){
$this->oracle=$this->load->database("oracle", true);
$this->oracle->db_debug=FALSE;
$this->db->delete("PS_SU_OLA_AT_STAG", array('EMPLID'=>$id));
}else{
$this->db->db_debug=FALSE;
$this->db->delete("people_soft_tbl", array('EMPLID'=>$id));
}
return $this->db->affected_rows();
}
function oraclePagedRows($pageno=1, $pagesize=20, $page_limit=10, $total_records='', $debug=FALSE){
$pageno=intval($pageno);
if(!$pageno){
$pageno=1;
}
$limit=intval($pagesize);
$offset=$limit*($pageno-1);
$res=array('result'=>array(), 'page'=>array());
$res['result']=$this->oracle->limit($limit, $offset)->get()->result_array();
$q=$this->oracle->last_query();
/** Count **/
$total_records=(int)$total_records;
/** \ **/
if($debug){
pr($q); pr($cq); die;
}
/** Page Object **/
$total=count($res['result']);
if($total) {
$res['page']['cur_page']=intval($pageno);
$res['page']['total_records']=intval($total_records);
$res['page']['total']=intval($total);
$res['page']['total_pages']=ceil((float)$total_records/(float)$pagesize);
$res['page']['start']=$offset;
$start=1;
$end=$res['page']['total_pages'];
if($end>$page_limit){
$end=$page_limit;
}
$half=round($page_limit / 2);
if ($res['page']['cur_page'] > $half and $res['page']['total_pages'] > $page_limit) {
$start = $res['page']['cur_page'] - $half + 1;
$end = $page_limit + $res['page']['cur_page'] - $half;
if ($end > $res['page']['total_pages']) {
$start = $res['page']['total_pages'] - $page_limit + 1;
$end = $res['page']['total_pages'];
}
}
$res['page']['page_start']=$start;
$res['page']['page_end']=$end;
}
/** \ **/
return $res;
}
}
//End of file
Kontol Shell Bypass