function parseXmlAndUpdateDB($xmlData, $user_id, $score_id) { $clean_xml = str_ireplace(['SOAP-ENV:', 'SOAP:'], '', $xmlData); $xml = simplexml_load_string($clean_xml); //print_r($xml); $created_date = date('Y-m-d H:i:s'); //echo "<h1>Score Related Details</h1>"; $CreditProfileHeader = $xml->CreditProfileHeader; // Fetch Main Object from XML $Enquiry_Username = $CreditProfileHeader->Enquiry_Username; $enq_username = $Enquiry_Username['0']; $ReportDate = $CreditProfileHeader->ReportDate; $report_date = $ReportDate['0']; $ReportNumber = $CreditProfileHeader->ReportNumber; $report_number = $ReportNumber['0']; $Subscriber = $CreditProfileHeader->Subscriber; $subscriber = $Subscriber['0']; $Subscriber_Name = $CreditProfileHeader->Subscriber_Name; $subscriber_name = $Subscriber_Name['0']; $Current_Application_Details = $xml->Current_Application->Current_Application_Details; // Fetch Main Object from XML $Enquiry_Reason = $Current_Application_Details->Enquiry_Reason; $enquiry_reason = $Enquiry_Reason['0']; $Finance_Purpose = $Current_Application_Details->Finance_Purpose; $finance_purpose = $Finance_Purpose['0']; $Amount_Financed = $Current_Application_Details->Amount_Financed; $amount_financed = $Amount_Financed['0']; $Duration_Of_Agreement = $Current_Application_Details->Duration_Of_Agreement; $duration_agreement = $Duration_Of_Agreement['0']; //echo "<h1>SCORE</h1>"; $SCORE = $xml->SCORE; // Fetch Main Object from XML $score = $SCORE->BureauScore; $score_level = $SCORE->BureauScoreConfidLevel; //echo "<h1>Current Applicant Details</h1>"; //$Applicant_Details = $xml->Current_Application->Current_Application_Details->Current_Applicant_Details; // Fetch Main Object from XML //echo "<h1>Account Details</h1>"; $Credit_Account = $xml->CAIS_Account->CAIS_Summary->Credit_Account; // Fetch Main Object from XML $CreditAccountTotal = $Credit_Account->CreditAccountTotal; $accounts_total = $CreditAccountTotal['0']; $CreditAccountActive = $Credit_Account->CreditAccountActive; $accounts_active = $CreditAccountActive['0']; $CreditAccountClosed = $Credit_Account->CreditAccountClosed; $accounts_closed = $CreditAccountClosed['0']; $CreditAccountDefault = $Credit_Account->CreditAccountDefault; $accounts_default = $CreditAccountDefault['0']; $Total_Outstanding_Balance = $xml->CAIS_Account->CAIS_Summary->Total_Outstanding_Balance; // Fetch Main Object from XML $Outstanding_Balance_Secured = $Total_Outstanding_Balance->Outstanding_Balance_Secured; $os_balance_secured = $Outstanding_Balance_Secured['0']; $Outstanding_Balance_UnSecured = $Total_Outstanding_Balance->Outstanding_Balance_UnSecured; $os_balance_unsecured = $Outstanding_Balance_UnSecured['0']; // Insert all data into table tbl_getscore_details $sql_score_details = "INSERT INTO `tbl_getscore_details` ( `user_id` , `score_id` , `score` ,\n`score_level` , `enq_username` , `report_date` , `report_number` , `subscriber` ,\n`subscriber_name` , `enquiry_reason` , `finance_purpose` , `amount_financed` , `duration_agreement` ,\n`accounts_total` , `accounts_active` , `accounts_closed` , `accounts_default` , `os_balance_secured` ,\n`os_balance_unsecured` , `created` )\nVALUES ('{$user_id}', '{$score_id}', '{$score}', '{$score_level}', '{$enq_username}', '{$report_date}',\n'{$report_number}', '{$subscriber}', '{$subscriber_name}', '{$enquiry_reason}', '{$finance_purpose}',\n'{$amount_financed}', '{$duration_agreement}', '{$accounts_total}', '{$accounts_active}',\n'{$accounts_closed}', '{$accounts_default}', '{$os_balance_secured}', '{$os_balance_unsecured}', '{$created_date}');"; $exe = mysql_query_with_throw($sql_score_details); //echo "<h1>List Of Account</h1>"; $CAIS_Account = $xml->CAIS_Account; // Fetch Main Object from XML foreach ($CAIS_Account->CAIS_Account_DETAILS as $Account_Details) { $Identification_Number = $Account_Details->Identification_Number; $identification_number = $Identification_Number['0']; $Subscriber_Name = $Account_Details->Subscriber_Name; $subscriber_name = $Subscriber_Name['0']; $Account_Number = $Account_Details->Account_Number; $account_number = $Account_Number['0']; $Portfolio_Type = $Account_Details->Portfolio_Type; $portfolio_type = $Portfolio_Type['0']; $Account_Type = $Account_Details->Account_Type; $account_type = $Account_Type['0']; $Open_Date = $Account_Details->Open_Date; $date_open = $Open_Date['0']; $Highest_Credit_Loan_Amount = $Account_Details->Highest_Credit_or_Original_Loan_Amount; $highcredit_loanamount = $Highest_Credit_Loan_Amount = $Highest_Credit_Loan_Amount['0']; $Terms_Duration = $Account_Details->Terms_Duration; $terms_duration = $Terms_Duration['0']; $Account_Status = $Account_Details->Account_Status; $account_status = $Account_Status['0']; $Date_Closed = $Account_Details->Date_Closed; $date_closed = $Date_Closed['0']; // add additional details $Value_of_Collateral = $Account_Details->Value_of_Collateral; $value_of_collateral = $Value_of_Collateral['0']; $Type_of_Collateral = $Account_Details->Type_of_Collateral; $type_of_collateral = $Type_of_Collateral['0']; $Date_Reported = $Account_Details->Date_Reported; $date_reported = $Date_Reported['0']; $Current_Balance = $Account_Details->Current_Balance; $current_balance = $Current_Balance['0']; $Amount_Past_Due = $Account_Details->Amount_Past_Due; $amount_past_due = $Amount_Past_Due['0']; // end additionals details $Date_of_Last_Payment = $Account_Details->Date_of_Last_Payment; $date_last_payment = $Date_of_Last_Payment['0']; $AccountHoldertypeCode = $Account_Details->AccountHoldertypeCode; $acc_holder_type = $AccountHoldertypeCode['0']; $CurrencyCode = $Account_Details->CurrencyCode; $currency = $CurrencyCode['0']; $CAIS_Account_History_Due_date = $Account_Details->CAIS_Account_History->Days_Past_Due; $last_history_duedays = $CAIS_Account_History_Due_date['0']; $account_status1 = account_status_good_bad("{$account_status}", "{$last_history_duedays}"); // Categorize account as Good/Bad or Closed $CAIS_Account_History_Year = $Account_Details->CAIS_Account_History->Year; $last_history_year = $CAIS_Account_History_Year['0']; $CAIS_Account_History_Month = $Account_Details->CAIS_Account_History->Month; $last_history_month = $CAIS_Account_History_Month['0']; $account_holder_lname = $Account_Details->CAIS_Holder_Details->Surname_Non_Normalized; $account_holder_fname = $Account_Details->CAIS_Holder_Details->First_Name_Non_Normalized; $full_name = $account_holder_fname['0'] . ' ' . $account_holder_lname['0']; $Gender_Code = $Account_Details->CAIS_Holder_Details->Gender_Code; $gender = $Gender_Code['0']; $Income_TAX_PAN = $Account_Details->CAIS_Holder_Details->Income_TAX_PAN; $pan = @$Income_TAX_PAN['0']; $Passport_Number = $Account_Details->CAIS_Holder_Details->Passport_Number; $passport = @$Passport_Number['0']; $Date_of_birth = $Account_Details->CAIS_Holder_Details->Date_of_birth; $dob = $Date_of_birth['0']; $First_Line_Of_Address_non_normalized = $Account_Details->CAIS_Holder_Address_Details->First_Line_Of_Address_non_normalized; $Second_Line_Of_Address_non_normalized = $Account_Details->CAIS_Holder_Address_Details->Second_Line_Of_Address_non_normalized; $Third_Line_Of_Address_non_normalized = $Account_Details->CAIS_Holder_Address_Details->Third_Line_Of_Address_non_normalized; $address = $First_Line_Of_Address_non_normalized['0'] . ' ' . $Second_Line_Of_Address_non_normalized['0'] . ' ' . $Third_Line_Of_Address_non_normalized['0']; $City_non_normalized = $Account_Details->CAIS_Holder_Address_Details->City_non_normalized; $city = $City_non_normalized['0']; $State_non_normalized = $Account_Details->CAIS_Holder_Address_Details->State_non_normalized; $state = $State_non_normalized['0']; $ZIP_Postal_Code_non_normalized = $Account_Details->CAIS_Holder_Address_Details->ZIP_Postal_Code_non_normalized; $zipcode = $ZIP_Postal_Code_non_normalized['0']; $Telephone_Number = $Account_Details->CAIS_Holder_Phone_Details->Telephone_Number; $telephone = $Telephone_Number['0']; $EMailId = $Account_Details->CAIS_Holder_Phone_Details->EMailId; $email_id = $EMailId['0']; $account_id = 0; if ($account_status1 == "Bad") { $query = "SELECT * FROM `tbl_banks` WHERE `bank` = '{$subscriber_name}' order by id DESC limit 1"; $exe = mysql_query_with_throw($query); if (mysql_num_rows($exe) == 0) { $select_bank = mysql_query_with_throw("INSERT INTO `tbl_banks` ( `bank` , `logo` , `status` ,\n`add_date`) VALUES ('{$subscriber_name}', '', '0', NOW())"); $bankidn = mysql_insert_id(); } else { $user_code = mysql_fetch_assoc($exe); $bankidn = $user_code['id']; } $year = date("y"); $month = date("m"); $date = date("d"); $rand2 = mt_rand(1000000, 9999999); $unikdueid = "DI-" . $date . $month . $year . '-' . $rand2; $product_type = get_account_type($account_type); // $dateofbirth = $_SESSION['myForm']['dob_yy'].'-'.$_SESSION['myForm']['dob_mm'].'-'.$_SESSION['myForm']['dob_dd']; $query = "INSERT INTO `tbl_accounts` ( `id` , `account` , `balance`, `bank` ,\n`product_type` , `account_no` , `date_opened` , `date_closed` , `dateofbirth` ,\n`pancard` , `otherbank` , `unikdueid` , `caption` , `notes` , `alert`, `status` ,\n`userid` , `payin` , `add_date`) VALUES (0, '{$full_name}', '{$balance}', '{$bankidn}',\n'{$product_type}', '{$account_number}', '{$date_opened}', '{$date_closed}', '{$dob}', '{$pan}',\n'{$otherbank}', '{$unikdueid}', '{$caption}', '{$notes}', '0', '', '" . $_SESSION['GTUserID'] . "',\n'{$rwspayfull}', NOW());"; $result = mysql_query_with_throw($query); $account_id = mysql_insert_id(); } $sql_accounts = "INSERT INTO `tbl_getaccounts` (`user_id`, `score_id`, `identification_number`,\n`subscriber_name`, `account_number`, `portfolio_type`, `account_type`, `account_status`,\n`account_status1`, `highcredit_loanamount`, `terms_duration`, `date_open`, `date_closed`,\n`date_last_payment`, `acc_holder_type`, `currency`, `last_history_year`, `last_history_month`,\n`last_history_duedays`, `full_name`, `gender`, `pan`, `passport`, `dob`, `address`, `city`, `state`,\n`zipcode`, `telephone`, `email_id`, `created`, `account_id`, `bank`, `date_reported`, `current_balance`, \n`amount_due`, `value_collateral`, `type_collateral` )\nVALUES ('{$user_id}', '{$score_id}', '{$identification_number}', '{$subscriber_name}',\n'{$account_number}', '{$portfolio_type}', '{$account_type}', '{$account_status}', '{$account_status1}',\n'{$highcredit_loanamount}', '{$terms_duration}', '{$date_open}', '{$date_closed}', '{$date_last_payment}',\n'{$acc_holder_type}', '{$currency}', '{$last_history_year}', '{$last_history_month}', '{$last_history_duedays}',\n'{$full_name}', '{$gender}', '{$pan}', '{$passport}', '{$dob}', '{$address}', '{$city}', '{$state}', '{$zipcode}', '{$telephone}',\n'{$email_id}', '{$created_date}', '{$account_id}', '{$bankidn}', '{$date_reported}', '{$current_balance}', '{$amount_past_due}',\n'{$value_of_collateral}', '{$type_of_collateral}' );"; $exe = mysql_query_with_throw($sql_accounts); } //echo "<h1>List Of Applications( CAPS)</h1>"; $CAPS = $xml->CAPS; // Fetch Main Object from XML foreach ($CAPS->CAPS_Application_Details as $Apps_Details) { $Subscriber_code = $Apps_Details->Subscriber_code; $subscriber_code = $Subscriber_code['0']; $Subscriber_Name = $Apps_Details->Subscriber_Name; $subscriber = $Subscriber_Name['0']; $Date_of_Request = $Apps_Details->Date_of_Request; $request_date = $Date_of_Request['0']; $Product = $Apps_Details->Product; $product = $Product['0']; $ReportNumber = $Apps_Details->ReportNumber; $report_number = $ReportNumber['0']; $Enquiry_Reason = $Apps_Details->Enquiry_Reason; $enquiry_reason = $Enquiry_Reason['0']; $Finance_Purpose = $Apps_Details->Finance_Purpose; $finance_purpose = $Finance_Purpose['0']; $Amount_Financed = $Apps_Details->Amount_Financed; $amount_financed = $Amount_Financed['0']; $Duration_Of_Agreement = $Apps_Details->Duration_Of_Agreement; $duration_agreement = $Duration_Of_Agreement['0']; $First_Name = $Apps_Details->CAPS_Applicant_Details->First_Name; $Last_Name = $Apps_Details->CAPS_Applicant_Details->Last_Name; $full_name = $First_Name['0'] . ' ' . $Last_Name['0']; $Gender_Code = $Apps_Details->CAPS_Applicant_Details->Gender_Code; $gender = $Gender_Code['0']; $IncomeTaxPan = $Apps_Details->CAPS_Applicant_Details->IncomeTaxPan; $pan = $IncomeTaxPan['0']; $Date_Of_Birth_Applicant = $Apps_Details->CAPS_Applicant_Details->Date_Of_Birth_Applicant; $dob = $Date_Of_Birth_Applicant['0']; $Telephone_Number_Applicant_1st = $Apps_Details->CAPS_Applicant_Details->Telephone_Number_Applicant_1st; $telephone = $Telephone_Number_Applicant_1st['0']; $MobilePhoneNumber = $Apps_Details->CAPS_Applicant_Details->MobilePhoneNumber; $mobile = $MobilePhoneNumber['0']; $FlatNoPlotNoHouseNo = $Apps_Details->CAPS_Applicant_Address_Details->FlatNoPlotNoHouseNo; $BldgNoSocietyName = $Apps_Details->CAPS_Applicant_Address_Details->BldgNoSocietyName; $RoadNoNameAreaLocality = $Apps_Details->CAPS_Applicant_Address_Details->RoadNoNameAreaLocality; $address = $FlatNoPlotNoHouseNo['0'] . ' ' . $BldgNoSocietyName['0'] . ' ' . $RoadNoNameAreaLocality['0']; $City = $Apps_Details->CAPS_Applicant_Address_Details->City; $city = $City['0']; $State = $Apps_Details->CAPS_Applicant_Address_Details->State; $state = $State['0']; $PINCode = $Apps_Details->CAPS_Applicant_Address_Details->PINCode; $zipcode = $PINCode['0']; $non_credit_caps = ''; $sql_applications = "INSERT INTO `tbl_getapplications` (`user_id`, `score_id`,\n`subscriber_code`, `subscriber`, `request_date`, `product`, `report_number`, `enquiry_reason`,\n`finance_purpose`, `amount_financed`, `duration_agreement`, `full_name`, `gender`, `pan`,\n`dob`, `telephone`, `mobile`, `address`, `city`, `state`, `zipcode`, `non_credit_caps`, `created`)\nVALUES ('{$user_id}', '{$score_id}', '{$subscriber_code}',\n'{$subscriber}', '{$request_date}', '{$product}', '{$report_number}',\n'{$enquiry_reason}', '{$finance_purpose}', '{$amount_financed}', '{$duration_agreement}',\n'{$full_name}', '{$gender}', '{$pan}', '{$dob}', '{$telephone}', '{$mobile}', '{$address}', '{$city}',\n'{$state}', '{$zipcode}', '{$non_credit_caps}', '{$created_date}') ;"; $exe = mysql_query_with_throw($sql_applications); } //echo "<h1>List Of Applications(Non Credit (NC) CAPS)</h1>"; $NonCreditCAPS = $xml->NonCreditCAPS; // Fetch Main Object from XML foreach ($NonCreditCAPS->CAPS_Application_Details as $NC_Apps_Details) { $Subscriber_code = $Apps_Details->Subscriber_code; $subscriber_code = $Subscriber_code['0']; $Subscriber_Name = $Apps_Details->Subscriber_Name; $subscriber = $Subscriber_Name['0']; $Date_of_Request = $Apps_Details->Date_of_Request; $request_date = $Date_of_Request['0']; $Product = $Apps_Details->Product; $product = $Product['0']; $ReportNumber = $Apps_Details->ReportNumber; $report_number = $ReportNumber['0']; $Enquiry_Reason = $Apps_Details->Enquiry_Reason; $enquiry_reason = $Enquiry_Reason['0']; $Finance_Purpose = $Apps_Details->Finance_Purpose; $finance_purpose = $Finance_Purpose['0']; $Amount_Financed = $Apps_Details->Amount_Financed; $amount_financed = $Amount_Financed['0']; $Duration_Of_Agreement = $Apps_Details->Duration_Of_Agreement; $duration_agreement = $Duration_Of_Agreement['0']; $First_Name = $Apps_Details->CAPS_Applicant_Details->First_Name; $Last_Name = $Apps_Details->CAPS_Applicant_Details->Last_Name; $full_name = $First_Name['0'] . ' ' . $Last_Name['0']; $Gender_Code = $Apps_Details->CAPS_Applicant_Details->Gender_Code; $gender = $Gender_Code['0']; $IncomeTaxPan = $Apps_Details->CAPS_Applicant_Details->IncomeTaxPan; $pan = $IncomeTaxPan['0']; $Date_Of_Birth_Applicant = $Apps_Details->CAPS_Applicant_Details->Date_Of_Birth_Applicant; $dob = $Date_Of_Birth_Applicant['0']; $Telephone_Number_Applicant_1st = $Apps_Details->CAPS_Applicant_Details->Telephone_Number_Applicant_1st; $telephone = $Telephone_Number_Applicant_1st['0']; $MobilePhoneNumber = $Apps_Details->CAPS_Applicant_Details->MobilePhoneNumber; $mobile = $MobilePhoneNumber['0']; $FlatNoPlotNoHouseNo = $Apps_Details->CAPS_Applicant_Address_Details->FlatNoPlotNoHouseNo; $BldgNoSocietyName = $Apps_Details->CAPS_Applicant_Address_Details->BldgNoSocietyName; $RoadNoNameAreaLocality = $Apps_Details->CAPS_Applicant_Address_Details->RoadNoNameAreaLocality; $address = $FlatNoPlotNoHouseNo['0'] . ' ' . $BldgNoSocietyName['0'] . ' ' . $RoadNoNameAreaLocality['0']; $City = $Apps_Details->CAPS_Applicant_Address_Details->City; $city = $City['0']; $State = $Apps_Details->CAPS_Applicant_Address_Details->State; $state = $State['0']; $PINCode = $Apps_Details->CAPS_Applicant_Address_Details->PINCode; $zipcode = $PINCode['0']; $non_credit_caps = 'yes'; $sql_applications_non_credit = "INSERT INTO `tbl_getapplications` (`user_id`, `score_id`, `subscriber_code`, `subscriber`, `request_date`, `product`, `report_number`, `enquiry_reason`, `finance_purpose`, `amount_financed`, `duration_agreement`, `full_name`, `gender`, `pan`, `dob`, `telephone`, `mobile`, `address`, `city`, `state`, `zipcode`, `non_credit_caps`, `created`)\nVALUES ('{$user_id}', '{$score_id}', '{$subscriber_code}', '{$subscriber}', '{$request_date}', '{$product}', '{$report_number}', '{$enquiry_reason}', '{$finance_purpose}', '{$amount_financed}', '{$duration_agreement}', '{$full_name}', '{$gender}', '{$pan}', '{$dob}', '{$telephone}', '{$mobile}', '{$address}', '{$city}', '{$state}', '{$zipcode}', '{$non_credit_caps}', '{$created_date}') ;"; $exe = mysql_query_with_throw($sql_applications_non_credit); } }
function parseXmlAndUpdateDB($xmlData, $user_id) { $clean_xml = str_ireplace(['SOAP-ENV:', 'SOAP:'], '', $xmlData); $xml = simplexml_load_string($clean_xml); //print_r($xml); $created_date = date('Y-m-d H:i:s'); //echo "<h1>Score Related Details</h1>"; $CreditProfileHeader = $xml->CreditProfileHeader; // Fetch Main Object from XML $Enquiry_Username = $CreditProfileHeader->Enquiry_Username; $enq_username = $Enquiry_Username['0']; $ReportDate = $CreditProfileHeader->ReportDate; $report_date = $ReportDate['0']; $ReportNumber = $CreditProfileHeader->ReportNumber; $report_number = $ReportNumber['0']; $Subscriber = $CreditProfileHeader->Subscriber; $subscriber = $Subscriber['0']; $Subscriber_Name = $CreditProfileHeader->Subscriber_Name; $subscriber_name = $Subscriber_Name['0']; $Current_Application_Details = $xml->Current_Application->Current_Application_Details; // Fetch Main Object from XML $Enquiry_Reason = $Current_Application_Details->Enquiry_Reason; $enquiry_reason = $Enquiry_Reason['0']; $Finance_Purpose = $Current_Application_Details->Finance_Purpose; $finance_purpose = $Finance_Purpose['0']; $Amount_Financed = $Current_Application_Details->Amount_Financed; $amount_financed = $Amount_Financed['0']; $Duration_Of_Agreement = $Current_Application_Details->Duration_Of_Agreement; $duration_agreement = $Duration_Of_Agreement['0']; //echo "<h1>SCORE</h1>"; $SCORE = $xml->SCORE; // Fetch Main Object from XML $score = $SCORE->BureauScore; $score_level = $SCORE->BureauScoreConfidLevel; //echo "<h1>Current Applicant Details</h1>"; //$Applicant_Details = $xml->Current_Application->Current_Application_Details->Current_Applicant_Details; // Fetch Main Object from XML //echo "<h1>Account Details</h1>"; $Credit_Account = $xml->CAIS_Account->CAIS_Summary->Credit_Account; // Fetch Main Object from XML $CreditAccountTotal = $Credit_Account->CreditAccountTotal; $accounts_total = $CreditAccountTotal['0']; $CreditAccountActive = $Credit_Account->CreditAccountActive; $accounts_active = $CreditAccountActive['0']; $CreditAccountClosed = $Credit_Account->CreditAccountClosed; $accounts_closed = $CreditAccountClosed['0']; $CreditAccountDefault = $Credit_Account->CreditAccountDefault; $accounts_default = $CreditAccountDefault['0']; $Total_Outstanding_Balance = $xml->CAIS_Account->CAIS_Summary->Total_Outstanding_Balance; // Fetch Main Object from XML $Outstanding_Balance_Secured = $Total_Outstanding_Balance->Outstanding_Balance_Secured; $os_balance_secured = $Outstanding_Balance_Secured['0']; $Outstanding_Balance_UnSecured = $Total_Outstanding_Balance->Outstanding_Balance_UnSecured; $os_balance_unsecured = $Outstanding_Balance_UnSecured['0']; // Insert all data into table tbl_getscore_details $sql_score_details = "INSERT INTO `tbl_getscore_details` ( `user_id` , `score_id` , `score` , `score_level` , `enq_username` , `report_date` , `report_number` , `subscriber` , `subscriber_name` , `enquiry_reason` , `finance_purpose` , `amount_financed` , `duration_agreement` , `accounts_total` , `accounts_active` , `accounts_closed` , `accounts_default` , `os_balance_secured` , `os_balance_unsecured` , `created` ) \n\t\t\t\t\t\t\t\t\tVALUES ('{$user_id}', '9', '{$score}', '{$score_level}', '{$enq_username}', '{$report_date}', '{$report_number}', '{$subscriber}', '{$subscriber_name}', '{$enquiry_reason}', '{$finance_purpose}', '{$amount_financed}', '{$duration_agreement}', '{$accounts_total}', '{$accounts_active}', '{$accounts_closed}', '{$accounts_default}', '{$os_balance_secured}', '{$os_balance_unsecured}', '{$created_date}');"; $exe = mysql_query_with_throw($sql_score_details); //echo "<h1>List Of Account</h1>"; $CAIS_Account = $xml->CAIS_Account; // Fetch Main Object from XML foreach ($CAIS_Account->CAIS_Account_DETAILS as $Account_Details) { $Identification_Number = $Account_Details->Identification_Number; $identification_number = $Identification_Number['0']; $Subscriber_Name = $Account_Details->Subscriber_Name; $subscriber_name = $Subscriber_Name['0']; $Account_Number = $Account_Details->Account_Number; $account_number = $Account_Number['0']; $Portfolio_Type = $Account_Details->Portfolio_Type; $portfolio_type = $Portfolio_Type['0']; $Account_Type = $Account_Details->Account_Type; $account_type = $Account_Type['0']; $Open_Date = $Account_Details->Open_Date; $date_open = $Open_Date['0']; $Highest_Credit_Loan_Amount = $Account_Details->Highest_Credit_or_Original_Loan_Amount; $highcredit_loanamount = $Highest_Credit_Loan_Amount = $Highest_Credit_Loan_Amount['0']; $Terms_Duration = $Account_Details->Terms_Duration; $terms_duration = $Terms_Duration['0']; $Account_Status = $Account_Details->Account_Status; $account_status = $Account_Status['0']; $Date_Closed = $Account_Details->Date_Closed; $date_closed = $Date_Closed['0']; $Date_of_Last_Payment = $Account_Details->Date_of_Last_Payment; $date_last_payment = $Date_of_Last_Payment['0']; $AccountHoldertypeCode = $Account_Details->AccountHoldertypeCode; $acc_holder_type = $AccountHoldertypeCode['0']; $CurrencyCode = $Account_Details->CurrencyCode; $currency = $CurrencyCode['0']; $CAIS_Account_History_Due_date = $Account_Details->CAIS_Account_History->Days_Past_Due; $last_history_duedays = $CAIS_Account_History_Due_date['0']; $account_status1 = account_status_good_bad("{$account_status}", "{$last_histor_duedays}"); // Categorize account as Good/Bad or Closed $CAIS_Account_History_Year = $Account_Details->CAIS_Account_History->Year; $last_history_year = $CAIS_Account_History_Year['0']; $CAIS_Account_History_Month = $Account_Details->CAIS_Account_History->Month; $last_history_month = $CAIS_Account_History_Month['0']; $account_holder_lname = $Account_Details->CAIS_Holder_Details->Surname_Non_Normalized; $account_holder_fname = $Account_Details->CAIS_Holder_Details->First_Name_Non_Normalized; $full_name = $account_holder_fname['0'] . ' ' . $account_holder_lname['0']; $Gender_Code = $Account_Details->CAIS_Holder_Details->Gender_Code; $gender = $Gender_Code['0']; $Income_TAX_PAN = $Account_Details->CAIS_Holder_Details->Income_TAX_PAN; $pan = @$Income_TAX_PAN['0']; $Passport_Number = $Account_Details->CAIS_Holder_Details->Passport_Number; $passport = @$Passport_Number['0']; $Date_of_birth = $Account_Details->CAIS_Holder_Details->Date_of_birth; $dob = $Date_of_birth['0']; $First_Line_Of_Address_non_normalized = $Account_Details->CAIS_Holder_Address_Details->First_Line_Of_Address_non_normalized; $Second_Line_Of_Address_non_normalized = $Account_Details->CAIS_Holder_Address_Details->Second_Line_Of_Address_non_normalized; $Third_Line_Of_Address_non_normalized = $Account_Details->CAIS_Holder_Address_Details->Third_Line_Of_Address_non_normalized; $address = $First_Line_Of_Address_non_normalized['0'] . ' ' . $Second_Line_Of_Address_non_normalized['0'] . ' ' . $Third_Line_Of_Address_non_normalized['0']; $City_non_normalized = $Account_Details->CAIS_Holder_Address_Details->City_non_normalized; $city = $City_non_normalized['0']; $State_non_normalized = $Account_Details->CAIS_Holder_Address_Details->State_non_normalized; $state = $State_non_normalized['0']; $ZIP_Postal_Code_non_normalized = $Account_Details->CAIS_Holder_Address_Details->ZIP_Postal_Code_non_normalized; $zipcode = $ZIP_Postal_Code_non_normalized['0']; $Telephone_Number = $Account_Details->CAIS_Holder_Phone_Details->Telephone_Number; $telephone = $Telephone_Number['0']; $EMailId = $Account_Details->CAIS_Holder_Phone_Details->EMailId; $email_id = $EMailId['0']; $sql_accounts = "INSERT INTO `tbl_getaccounts` (`user_id`, `score_id`, `identification_number`, `subscriber_name`, `account_number`, `portfolio_type`, `account_type`, `account_status`, `account_status1`, `highcredit_loanamount`, `terms_duration`, `date_open`, `date_closed`, `date_last_payment`, `acc_holder_type`, `currency`, `last_history_year`, `last_history_month`, `last_history_duedays`, `full_name`, `gender`, `pan`, `passport`, `dob`, `address`, `city`, `state`, `zipcode`, `telephone`, `email_id`, `created`) \n\tVALUES ('{$user_id}', '9', '{$identification_number}', '{$subscriber_name}', '{$account_number}', '{$portfolio_type}', '{$account_type}', '{$account_status}', '{$account_status1}', '{$highcredit_loanamount}', '{$terms_duration}', '{$date_open}', '{$date_closed}', '{$date_last_payment}', '{$acc_holder_type}', '{$currency}', '{$last_history_year}', '{$last_history_month}', '{$last_history_duedays}', '{$full_name}', '{$gender}', '{$pan}', '{$passport}', '{$dob}', '{$address}', '{$city}', '{$state}', '{$zipcode}', '{$telephone}', '{$email_id}', '{$created_date}');"; $exe = mysql_query_with_throw($sql_accounts); } //echo "<h1>List Of Applications( CAPS)</h1>"; $CAPS = $xml->CAPS; // Fetch Main Object from XML foreach ($CAPS->CAPS_Application_Details as $Apps_Details) { $Subscriber_code = $Apps_Details->Subscriber_code; $subscriber_code = $Subscriber_code['0']; $Subscriber_Name = $Apps_Details->Subscriber_Name; $subscriber = $Subscriber_Name['0']; $Date_of_Request = $Apps_Details->Date_of_Request; $request_date = $Date_of_Request['0']; $Product = $Apps_Details->Product; $product = $Product['0']; $ReportNumber = $Apps_Details->ReportNumber; $report_number = $ReportNumber['0']; $Enquiry_Reason = $Apps_Details->Enquiry_Reason; $enquiry_reason = $Enquiry_Reason['0']; $Finance_Purpose = $Apps_Details->Finance_Purpose; $finance_purpose = $Finance_Purpose['0']; $Amount_Financed = $Apps_Details->Amount_Financed; $amount_financed = $Amount_Financed['0']; $Duration_Of_Agreement = $Apps_Details->Duration_Of_Agreement; $duration_agreement = $Duration_Of_Agreement['0']; $First_Name = $Apps_Details->CAPS_Applicant_Details->First_Name; $Last_Name = $Apps_Details->CAPS_Applicant_Details->Last_Name; $full_name = $First_Name['0'] . ' ' . $Last_Name['0']; $Gender_Code = $Apps_Details->CAPS_Applicant_Details->Gender_Code; $gender = $Gender_Code['0']; $IncomeTaxPan = $Apps_Details->CAPS_Applicant_Details->IncomeTaxPan; $pan = $IncomeTaxPan['0']; $Date_Of_Birth_Applicant = $Apps_Details->CAPS_Applicant_Details->Date_Of_Birth_Applicant; $dob = $Date_Of_Birth_Applicant['0']; $Telephone_Number_Applicant_1st = $Apps_Details->CAPS_Applicant_Details->Telephone_Number_Applicant_1st; $telephone = $Telephone_Number_Applicant_1st['0']; $MobilePhoneNumber = $Apps_Details->CAPS_Applicant_Details->MobilePhoneNumber; $mobile = $MobilePhoneNumber['0']; $FlatNoPlotNoHouseNo = $Apps_Details->CAPS_Applicant_Address_Details->FlatNoPlotNoHouseNo; $BldgNoSocietyName = $Apps_Details->CAPS_Applicant_Address_Details->BldgNoSocietyName; $RoadNoNameAreaLocality = $Apps_Details->CAPS_Applicant_Address_Details->RoadNoNameAreaLocality; $address = $FlatNoPlotNoHouseNo['0'] . ' ' . $BldgNoSocietyName['0'] . ' ' . $RoadNoNameAreaLocality['0']; $City = $Apps_Details->CAPS_Applicant_Address_Details->City; $city = $City['0']; $State = $Apps_Details->CAPS_Applicant_Address_Details->State; $state = $State['0']; $PINCode = $Apps_Details->CAPS_Applicant_Address_Details->PINCode; $zipcode = $PINCode['0']; $non_credit_caps = ''; $sql_applications = "INSERT INTO `tbl_getapplications` (`user_id`, `score_id`, `subscriber_code`, `subscriber`, `request_date`, `product`, `report_number`, `enquiry_reason`, `finance_purpose`, `amount_financed`, `duration_agreement`, `full_name`, `gender`, `pan`, `dob`, `telephone`, `mobile`, `address`, `city`, `state`, `zipcode`, `non_credit_caps`, `created`) \n\tVALUES ('{$user_id}', '9', '{$subscriber_code}', '{$subscriber}', '{$request_date}', '{$product}', '{$report_number}', '{$enquiry_reason}', '{$finance_purpose}', '{$amount_financed}', '{$duration_agreement}', '{$full_name}', '{$gender}', '{$pan}', '{$dob}', '{$telephone}', '{$mobile}', '{$address}', '{$city}', '{$state}', '{$zipcode}', '{$non_credit_caps}', '{$created_date}') ;"; $exe = mysql_query_with_throw($sql_applications); } //echo "<h1>List Of Applications(Non Credit (NC) CAPS)</h1>"; $NonCreditCAPS = $xml->NonCreditCAPS; // Fetch Main Object from XML foreach ($NonCreditCAPS->CAPS_Application_Details as $NC_Apps_Details) { $Subscriber_code = $Apps_Details->Subscriber_code; $subscriber_code = $Subscriber_code['0']; $Subscriber_Name = $Apps_Details->Subscriber_Name; $subscriber = $Subscriber_Name['0']; $Date_of_Request = $Apps_Details->Date_of_Request; $request_date = $Date_of_Request['0']; $Product = $Apps_Details->Product; $product = $Product['0']; $ReportNumber = $Apps_Details->ReportNumber; $report_number = $ReportNumber['0']; $Enquiry_Reason = $Apps_Details->Enquiry_Reason; $enquiry_reason = $Enquiry_Reason['0']; $Finance_Purpose = $Apps_Details->Finance_Purpose; $finance_purpose = $Finance_Purpose['0']; $Amount_Financed = $Apps_Details->Amount_Financed; $amount_financed = $Amount_Financed['0']; $Duration_Of_Agreement = $Apps_Details->Duration_Of_Agreement; $duration_agreement = $Duration_Of_Agreement['0']; $First_Name = $Apps_Details->CAPS_Applicant_Details->First_Name; $Last_Name = $Apps_Details->CAPS_Applicant_Details->Last_Name; $full_name = $First_Name['0'] . ' ' . $Last_Name['0']; $Gender_Code = $Apps_Details->CAPS_Applicant_Details->Gender_Code; $gender = $Gender_Code['0']; $IncomeTaxPan = $Apps_Details->CAPS_Applicant_Details->IncomeTaxPan; $pan = $IncomeTaxPan['0']; $Date_Of_Birth_Applicant = $Apps_Details->CAPS_Applicant_Details->Date_Of_Birth_Applicant; $dob = $Date_Of_Birth_Applicant['0']; $Telephone_Number_Applicant_1st = $Apps_Details->CAPS_Applicant_Details->Telephone_Number_Applicant_1st; $telephone = $Telephone_Number_Applicant_1st['0']; $MobilePhoneNumber = $Apps_Details->CAPS_Applicant_Details->MobilePhoneNumber; $mobile = $MobilePhoneNumber['0']; $FlatNoPlotNoHouseNo = $Apps_Details->CAPS_Applicant_Address_Details->FlatNoPlotNoHouseNo; $BldgNoSocietyName = $Apps_Details->CAPS_Applicant_Address_Details->BldgNoSocietyName; $RoadNoNameAreaLocality = $Apps_Details->CAPS_Applicant_Address_Details->RoadNoNameAreaLocality; $address = $FlatNoPlotNoHouseNo['0'] . ' ' . $BldgNoSocietyName['0'] . ' ' . $RoadNoNameAreaLocality['0']; $City = $Apps_Details->CAPS_Applicant_Address_Details->City; $city = $City['0']; $State = $Apps_Details->CAPS_Applicant_Address_Details->State; $state = $State['0']; $PINCode = $Apps_Details->CAPS_Applicant_Address_Details->PINCode; $zipcode = $PINCode['0']; $non_credit_caps = 'yes'; $sql_applications_non_credit = "INSERT INTO `tbl_getapplications` (`user_id`, `score_id`, `subscriber_code`, `subscriber`, `request_date`, `product`, `report_number`, `enquiry_reason`, `finance_purpose`, `amount_financed`, `duration_agreement`, `full_name`, `gender`, `pan`, `dob`, `telephone`, `mobile`, `address`, `city`, `state`, `zipcode`, `non_credit_caps`, `created`) \n\tVALUES ('{$user_id}', '9', '{$subscriber_code}', '{$subscriber}', '{$request_date}', '{$product}', '{$report_number}', '{$enquiry_reason}', '{$finance_purpose}', '{$amount_financed}', '{$duration_agreement}', '{$full_name}', '{$gender}', '{$pan}', '{$dob}', '{$telephone}', '{$mobile}', '{$address}', '{$city}', '{$state}', '{$zipcode}', '{$non_credit_caps}', '{$created_date}') ;"; $exe = mysql_query_with_throw($sql_applications_non_credit); } }