Untitled
unknown
plain_text
5 months ago
27 kB
5
Indexable
/*********** LiveEquifaxController1.php ****************/
public function equifax(Request $request){
$users = User::where('access_token', $request->token)->first();
$sql = DB::table('equifax_pdf_request')->insert([
'firstName' => $request->fname,
'lastName' => $request->lname,
'contactNo'=> $request->phone_number,
'idValue'=> $request->id_value,
'created_at'=>date('Y-m-d H:i:s')
]);
$record_id = DB::table('equifax_pdf_request')->orderBy('id', 'desc')->first();
// dd('testing now');
$statusCode = null;
$equifax = null;
// $equifax = null;
$aadhar_num = $request->aadhar_num ? $request->aadhar_num : null;
$pan_num = $request->pan_num ? $request->pan_num : null;
$voter_id = $request->voter_num ? $request->voter_num : null;
$passport = $request->passport_num ? $request->passport_num : null;
$driving_licence = $request->driving_num ? $request->driving_num : null;
$hit_limits_exceeded = 0;
$otp = mt_rand(100000,999999);
//$status = $this->sendOtp($request->phone_number,$otp);
$uname = $users->name;
$arr = explode(' ', trim($uname));
$user = '';
$substr = '';
foreach($arr as $array){
$substr = substr($array, 0, 1);
$user = $user.$substr;
}
$recordId = sprintf("%04d", $record_id->id);
$CustRefField = "DB-".strtoupper($user).Carbon::now()->format('y').Carbon::now()->format('m').$recordId;
$accessToken = $users->access_token;
$headers = [
'AccessToken' => $accessToken,
];
$body = [
'fname' => $request->fname,
'lname' => $request->lname,
'dob' => $request->dob,
'phone_number' => $request->phone_number,
'pan_num' => $request->pan_num
];
$client = new Client();
try{
$response = $client -> post($this->regtech_url,[
'headers' => $headers,'json' => $body
]);
$data = $request->all();
$equifaxdetails = json_decode($response -> getBody(),true);
// return $equifaxdetails;
if($equifaxdetails['statusCode'] != 102)
{
$equifax = $equifaxdetails['Equifax_Report'] ?? null;
if(!empty($equifax))
{
$myarray = array();
if($equifax['CCRResponse']['Status'] == "0")
return response()->json(['equifax'=>$equifax]);
foreach($equifax['CCRResponse']['CIRReportDataLst'] as $key => $value)
{
if(array_key_exists("Error",$value)){
$isFound = 0;
return response()->json(['equifax'=>$equifax,'isFound'=>$isFound]);
}
if(isset($value['InquiryResponseHeader']['ReportOrderNO']))
$orderNo = $value['InquiryResponseHeader']['ReportOrderNO'];
else
$orderNo = "";
if(isset($value['CIRReportData']['IDAndContactInfo']['PersonalInfo']
['Name']['FullName']))
$consumerName = $value['CIRReportData']['IDAndContactInfo']['PersonalInfo']
['Name']['FullName'];
else
$consumerName = "";
if(isset($value['CIRReportData']['IDAndContactInfo']['PersonalInfo']
['DateOfBirth']))
$DOB = $value['CIRReportData']['IDAndContactInfo']['PersonalInfo']
['DateOfBirth'];
else
$DOB = "";
if(isset($value['InquiryResponseHeader']['Date']))
$date = $value['InquiryResponseHeader']['Date'];
else
$date = "";
if(isset($value['InquiryResponseHeader']['Time']))
$time = $value['InquiryResponseHeader']['Time'];
else
$time = "";
if(isset($value['CIRReportData']['IDAndContactInfo']['PersonalInfo']
['Age']['Age']))
$age = $value['CIRReportData']['IDAndContactInfo']['PersonalInfo']
['Age']['Age'];
else
$age = "";
if($value['CIRReportData']['IDAndContactInfo']['PersonalInfo']['Gender'])
$gender = $value['CIRReportData']['IDAndContactInfo']['PersonalInfo']['Gender'];
else
$gender = "";
if(isset($value['CIRReportData']['IDAndContactInfo']['IdentityInfo']['PANId'])){
foreach($value['CIRReportData']['IDAndContactInfo']
['IdentityInfo']['PANId'] as $key1 => $value1)
if(isset($value1['IdNumber']))
$PAN = $value1['IdNumber'];
else
$PAN = "";
}else{
$PAN = "";
}
if(isset($value['CIRReportData']['IDAndContactInfo']['IdentityInfo']['NationalIDCard'])){
foreach($value['CIRReportData']['IDAndContactInfo']
['IdentityInfo']['NationalIDCard'] as $key1 => $value1)
if(isset($value1['IdNumber']))
$NationalIDCard = $value1['IdNumber'];
else
$NationalIDCard = "";
}else{
$NationalIDCard = "";
}
if(isset($value['CIRReportData']['IDAndContactInfo']['IdentityInfo']['VoterID'])){
foreach($value['CIRReportData']['IDAndContactInfo']
['IdentityInfo']['VoterID'] as $key1 => $value1)
if(isset($value1['IdNumber']))
$VoterID = $value1['IdNumber'];
else
$VoterID = "";
}else{
$VoterID = "";
}
// foreach($value['CIRReportData']['IDAndContactInfo']['IdentityInfo']['VoterID'] as $key1 => $value1)
// if(isset($value1['IdNumber']))
// $VoterID = $value1['IdNumber'];
// else
// $VoterID = "";
foreach($value['InquiryRequestInfo']['InquiryPhones'] as $key2 => $value2)
if(isset($value2['Number']))
$Number = $value2['Number'];
else
$Number = "";
if(isset($value['CIRReportData']['IDAndContactInfo']['AddressInfo']))
$consumer_address = $value['CIRReportData']['IDAndContactInfo']['AddressInfo'];
else
$consumer_address = "";
$score_array = $value['CIRReportData']['ScoreDetails'];
if(count($score_array) > 0){
// foreach($score_array as $scoredetails)
// {
$score_details = $score_array;
// if(isset($scoredetails['Value'])){
// $score = $scoredetails['Value'];
// $score_version = $scoredetails['Version'];
// }else{
// $score = "";
// $score_version = "";
// }
// if(isset($scoredetails['ScoringElements']))
// $scoringelements = $scoredetails['ScoringElements'];
// else
// $scoringelements = "";
// }
}else{
$score_details = [];
}
if(isset($value['CIRReportData']['RecentActivities']))
$enquiry_summary = $value['CIRReportData']['RecentActivities'];
else
$enquiry_summary = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']['NoOfAccounts']))
$numberofAccounts = $value['CIRReportData']['RetailAccountsSummary']['NoOfAccounts'];
else
$numberofAccounts = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['TotalBalanceAmount']))
$TotalBalanceAmount = $value['CIRReportData']['RetailAccountsSummary']
['TotalBalanceAmount'];
else
$TotalBalanceAmount = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['TotalPastDue']))
$TotalPastAmount = $value['CIRReportData']['RetailAccountsSummary']
['TotalPastDue'];
else
$TotalPastAmount = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['RecentAccount']))
$recent_account = $value['CIRReportData']['RetailAccountsSummary']
['RecentAccount'];
else
$recent_account = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['OldestAccount']))
$oldest_account = $value['CIRReportData']['RetailAccountsSummary']
['OldestAccount'];
else
$oldest_account = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['NoOfActiveAccounts']))
$numberOfOpenAccount = $value['CIRReportData']['RetailAccountsSummary']
['NoOfActiveAccounts'];
else
$numberOfOpenAccount = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['NoOfPastDueAccounts']))
$numberOfPastDueAccount = $value['CIRReportData']['RetailAccountsSummary']
['NoOfPastDueAccounts'];
else
$numberOfPastDueAccount = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['TotalHighCredit']))
$TotalHighCredit = $value['CIRReportData']['RetailAccountsSummary']
['TotalHighCredit'];
else
$TotalHighCredit = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['TotalCreditLimit']))
$TotalCreditLimit = $value['CIRReportData']['RetailAccountsSummary']
['TotalCreditLimit'];
else
$TotalCreditLimit = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['NoOfWriteOffs']))
$NoOfWriteOffs = $value['CIRReportData']['RetailAccountsSummary']
['NoOfWriteOffs'];
else
$NoOfWriteOffs = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['TotalSanctionAmount']))
$TotalSanctionAmount = $value['CIRReportData']['RetailAccountsSummary']
['TotalSanctionAmount'];
else
$TotalSanctionAmount = $value['CIRReportData']['RetailAccountsSummary']
['TotalSanctionAmount'];
if(isset($value['CIRReportData']['RetailAccountsSummary']
['SingleHighestCredit']))
$SingleHighestCredit = $value['CIRReportData']['RetailAccountsSummary']
['SingleHighestCredit'];
else
$SingleHighestCredit = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['NoOfZeroBalanceAccounts']))
$NoOfZeroBalanceAccounts = $value['CIRReportData']['RetailAccountsSummary']
['NoOfZeroBalanceAccounts'];
else
$NoOfZeroBalanceAccounts = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['TotalMonthlyPaymentAmount']))
$TotalMonthlyPaymentAmount = $value['CIRReportData']['RetailAccountsSummary']
['TotalMonthlyPaymentAmount'];
else
$TotalMonthlyPaymentAmount = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['NoOfZeroBalanceAccounts']))
$NoOfZeroBalanceAccounts = $value['CIRReportData']['RetailAccountsSummary']
['NoOfZeroBalanceAccounts'];
else
$NoOfZeroBalanceAccounts = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['SingleHighestBalance']))
$SingleHighestBalance = $value['CIRReportData']['RetailAccountsSummary']
['SingleHighestBalance'];
else
$SingleHighestBalance = "";
if(isset($value['CIRReportData']['RetailAccountsSummary']
['SingleHighestSanctionAmount']))
$SingleHighestSanctionAmount = $value['CIRReportData']['RetailAccountsSummary']
['SingleHighestSanctionAmount'];
else
$SingleHighestSanctionAmount = "";
//RETAIL ACCOUNT DETAILS
$RetailAccountDetails = $value['CIRReportData']['RetailAccountDetails'];
//Enquiries
if(isset($value['CIRReportData']['Enquiries'])){
$enquiries = $value['CIRReportData']['Enquiries'];
}else{
$enquiries = "";
}
//Enquiry Summary
if(isset($value['CIRReportData']['EnquirySummary']['Purpose']))
$Purpose = $value['CIRReportData']['EnquirySummary']['Purpose'];
else
$Purpose = "";
if(isset($value['CIRReportData']['EnquirySummary']['Total']))
$Total = $value['CIRReportData']['EnquirySummary']['Total'];
else
$Total = "";
if(isset($value['CIRReportData']['EnquirySummary']['Past30Days']))
$Past30Days = $value['CIRReportData']['EnquirySummary']['Past30Days'];
else
$Past30Days= "";
if(isset($value['CIRReportData']['EnquirySummary']['Past12Months']))
$Past12Months = $value['CIRReportData']['EnquirySummary']['Past12Months'];
else
$Past12Months = "";
if(isset($value['CIRReportData']['EnquirySummary']['Past24Months']))
$Past24Months = $value['CIRReportData']['EnquirySummary']['Past24Months'];
else
$Past24Months = "";
if(isset($value['CIRReportData']['EnquirySummary']['Recent']))
$Recent = $value['CIRReportData']['EnquirySummary']['Recent'];
else
$Recent = "";
// foreach($RetailAccountDetails as $RetailAccountDetail)
// {
// $AccountNumber = $RetailAccountDetail['AccountNumber'];
// $Balance = $RetailAccountDetail['Balance'];
// $Open = $RetailAccountDetail['Open'];
// $DateReported = $RetailAccountDetail['DateReported'];
// $Institution = $RetailAccountDetail['Institution'];
// $PastDueAmount = $RetailAccountDetail['PastDueAmount'];
// //$InterestRate = $RetailAccountDetail['AccountNumber']);
// $DateOpened = $RetailAccountDetail['DateOpened'];
// $Type = $RetailAccountDetail['AccountType'];
// $LastPaymentDate = $RetailAccountDetail['LastPaymentDate'];
// $LastPaymentDue = $RetailAccountDetail['LastPaymentDate'];
// //$DateClosed = $RetailAccountDetail['AccountNumber']);
// $OwnershipType = $RetailAccountDetail['source'];
// //$WriteOffAmount = $RetailAccountDetail['AccountNumber']);
// $SanctionAmount = $RetailAccountDetail['SanctionAmount'];
// }
//Personal Information
$myarray['CustRefField'] = $CustRefField;
$myarray['orderNo'] = $orderNo;
$myarray['consumerName'] = $consumerName;
$myarray['PAN'] = $PAN;
$myarray['VoterID'] = $VoterID;
$myarray['Number'] = $Number;
$myarray['DOB'] = $DOB;
$myarray['age'] = $age;
$myarray['gender'] = $gender;
$myarray['NationalIDCard'] = $NationalIDCard;
// $myarray['aadhar'] = $aadhar_num;
//Address
$myarray['consumer_address'] = $consumer_address;
//Score
// $myarray['score'] = $score;
// $myarray['score_version'] = $score_version;
// $myarray['scoringelements'] = $scoringelements;
$myarray['score_details'] = $score_details;
//date and time
$myarray['date'] = $date;
$myarray['time'] = $time;
$myarray['enquiries'] = $enquiries;
$myarray['enquiry_summary'] = $enquiry_summary;
//Summary
$myarray['numberofAccounts'] = $numberofAccounts;
$myarray['TotalBalanceAmount'] = $TotalBalanceAmount;
$myarray['TotalPastAmount'] = $TotalPastAmount;
$myarray['recentAccount'] = $recent_account;
$myarray['oldestAccount'] = $oldest_account;
$myarray['numberOfOpenAccount'] = $numberOfOpenAccount;
$myarray['numberOfPastDueAccount'] = $numberOfPastDueAccount;
$myarray['TotalHighCredit'] = $TotalHighCredit;
$myarray['TotalCreditLimit'] = $TotalCreditLimit;
$myarray['NoOfWriteOffs'] = $NoOfWriteOffs;
$myarray['TotalSanctionAmount'] = $TotalSanctionAmount;
$myarray['SingleHighestCredit'] = $SingleHighestCredit;
$myarray['NoOfZeroBalanceAccounts'] = $NoOfZeroBalanceAccounts;
$myarray['TotalMonthlyPaymentAmount'] = $TotalMonthlyPaymentAmount;
$myarray['NoOfZeroBalanceAccounts'] = $NoOfZeroBalanceAccounts;
$myarray['SingleHighestBalance'] = $SingleHighestBalance;
$myarray['SingleHighestSanctionAmount'] = $SingleHighestSanctionAmount
;
$myarray['RetailAccountDetails'] = $RetailAccountDetails;
//Enquiry Summary
$myarray['Purpose'] = $Purpose;
$myarray['Total'] = $Total;
$myarray['Past30Days'] = $Past30Days;
$myarray['Past24Months'] = $Past24Months;
$myarray['Recent'] = $Recent;
$myarray['Past12Months'] = $Past12Months;
}
// return $myarray;
// return view('kyc.equifaxreportpdf',compact('myarray','equifax'));
return response()->json(['myarray'=>$myarray,'equifax'=>$equifax],200);
}
}
$pan_num = $request->pan_num;
return response()->json(['equifaxdetails'=>$equifaxdetails,'pan_num'=>$pan_num],200);
// return response()->json(['statusCode'=>$statusCode,'equifax'=>$equifax]);
// $statusCode = 102;
// $errorMessage = 'Verification Failed. Please enter correct PAN Number.';
// return view('kyc.equifax',compact('statusCode','errorMessage'));
}catch(BadResponseException $e)
{
$statusCode = $e -> getResponse() -> getStatusCode();
}
// return $equifaxdetails;
return response()->json(['statusCode'=>$statusCode,'equifax'=>$equifax,'hit_limits_exceeded'=>$hit_limits_exceeded]);
}
/********* CrifController1 ************/
public function verifyotp(Request $request)
{
// $otpCode = OtpCheck::latest()->first();
$otpCode = OtpCheck::where('mobile_number', $request->phone)
->latest()
->first();
// Check if an OTP entry was found
if (!$otpCode) {
return response()->json(['error' => 'No OTP found for this mobile number.'], 404);
}
if ($request->otp_code == $otpCode->otp) {
return response()->json(['success' => 'OTP verified successfully']);
} else {
return response()->json(['fail' => 'OTP is not match']);
}
}
/*********** OtpCheck=> Model **************/
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class OtpCheck extends Model
{
use HasFactory;
protected $table = 'otp_check';
protected $fillable = ['otp', 'mobile_number'];
}
Editor is loading...
Leave a Comment