ikan Uploader :
Directory : /var/www/html/shardahospital.org/shardalms/student-panel/api/application/models_old/
Upload File : |
| Current File : /var/www/html/shardahospital.org/shardalms/student-panel/api/application/models_old/Pay_model.php |
<?php
class Pay_model extends CI_Model {
function trans_dtl($id, $f="*"){
$rs=$this->db->select($f)->get_where("pay_trans", array('id'=>$id))->row_array();
return $rs;
}
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);
}
}
}
}
//End of file
Kontol Shell Bypass