<?php
checklogin();
$user_id = $_SESSION['GTUserID'];
$score_id = $_REQUEST['score_id'];
$check_exp_attempt = checkExperianAttempt($user_id);
$today = date('Y-m-d');
$verified = $_REQUEST['verified'];
$qsans = $_POST['qs-ans'];
creteLogs("experian-flow.php", __LINE__, "experian attemptUserId:" . $user_id . "Scoreid:" . $score_id);
$checkreportquery = mysql_query_with_throw("SELECT `user_id`, `error`, `id` FROM \n `tbl_getscore` WHERE `user_id`='{$user_id}' order by id desc limit 1");
$rowl = mysql_fetch_assoc($checkreportquery);
if ($rowl["error"]) {
$exp_error = $rowl['error'];
if ($exp_error == "inCorrectAnswersGiven") {
header("location:index.php?p=upload-kyc&msg=2&score_id=" . $score_id);
exit;
} elseif ($exp_error == "insufficientQuestion") {
header("location:index.php?p=upload-kyc&msg=2&score_id=" . $score_id);
exit;
} elseif ($exp_error == "creditReportEmpty") {
header("location:index.php?p=show-error-msg&msg=1");
exit;
} elseif ($exp_error == "error") {
header("location:index.php?p=show-error-msg&msg=1");
exit;
} elseif ($exp_error == "systemError") {
header("location:index.php?p=show-error-msg&msg=1");
exit;
} elseif ($exp_error == "Success") {
header("location:index.php?p=my-score&type=bad");
function user_state($id)
{
$check_exp_attempt = checkExperianAttempt($id);
$status_query = "select user_state from tbl_userdetails where id={$id};";
$status_query_set = mysql_query_with_throw($status_query);
$status_query_set = mysql_fetch_array($status_query_set);
$user_state = $status_query_set['user_state'];
if ($user_state == "get_my_score") {
// apply logic for get score
$get_score_data = "select id from tbl_getscore where user_id={$id} order by id desc limit 1;";
$get_score_data_set = mysql_query_with_throw($get_score_data);
$get_score_data_set = mysql_fetch_array($get_score_data_set);
if ($get_score_data_set['id']) {
// apply logic for form fill
header("location:index.php?p=get-my-score&score_id=" . $get_score_data_set['id']);
} else {
// for blank form
header("location:index.php?p=get-my-score");
}
} elseif ($user_state == "experian_flow") {
// apply logic for experian_flow
$exp_score_data = "select error,id from tbl_getscore where user_id={$id} order by id desc limit 1;";
$exp_score_data_set = mysql_query_with_throw($exp_score_data);
$exp_score_data_set = mysql_fetch_array($exp_score_data_set);
$exp_error = $exp_score_data_set['error'];
if ($exp_error == "voucherExpired") {
header("location:index.php?p=get-my-score&score_id=" . $exp_score_data_set['id']);
} elseif ($exp_error == "inCorrectAnswersGiven") {
header("location:index.php?p=upload-kyc&msg=2" . $exp_score_data_set['id']);
} elseif ($exp_error == "insufficientQuestion") {
header("location:index.php?p=upload-kyc&msg=2" . $exp_score_data_set['id']);
} elseif ($exp_error == "creditReportEmpty") {
header("location:index.php?p=show-error-msg&msg=1");
} elseif (strpos($exp_error, 'No record found.') !== FALSE) {
header("location:index.php?p=show-error-msg&msg=1&score_id=" . $exp_score_data_set['id']);
} elseif ($exp_error == "Success") {
header("location:index.php?p=my-score&type=bad");
} elseif ($exp_error == "error") {
header("location:index.php?p=show-error-msg&msg=1");
} elseif ($exp_error == "systemError") {
header("location:index.php?p=show-error-msg&msg=1");
} else {
header("location:index.php?p=get-my-score&score_id=" . $exp_score_data_set['id']);
}
} elseif ($user_state == "upload_kyc") {
// apply logic for upload_kyc
$exp_score_data = "select id from tbl_getscore where user_id={$id} order by id desc limit 1;";
$exp_score_data_set = mysql_query_with_throw($exp_score_data);
$exp_score_data_set = mysql_fetch_array($exp_score_data_set);
$sql1_count = "select status from tbl_uploadkyc where user_id={$id};";
$result1_set = mysql_query_with_throw($sql1_count);
$result2 = mysql_fetch_array($result1_set);
if ($result2['status'] == 1) {
$sql_count = "select count(user_id) from tbl_getaccounts where user_id={$id};";
$result_set = mysql_query_with_throw($sql_count);
$result = mysql_fetch_array($result_set);
if ($result['count(user_id)' != 0]) {
header("location:index.php?p=my-score&type=bad");
} else {
header("location:index.php?p=upload-kyc&msg=3");
}
} else {
header("location:index.php?p=upload-kyc&msg=2&score_id=" . $exp_score_data_set['id']);
}
} else {
// aply logic for null state
$sql_count = "select count(user_id), score_id from tbl_getaccounts where user_id={$id};";
$result_set = mysql_query_with_throw($sql_count);
$result = mysql_fetch_array($result_set);
if ($result['count(user_id)' != 0]) {
header("location:index.php?p=my-score&type=bad");
}
$sql1_count = "select status from tbl_uploadkyc where user_id={$id};";
$result1_set = mysql_query_with_throw($sql1_count);
$result2 = mysql_fetch_array($result1_set);
if ($result2) {
if ($result2['status'] == 1) {
header("location:index.php?p=upload-kyc&msg=3");
}
if ($result2['status'] == "") {
header("location:index.php?p=upload-kyc&msg=2" . $exp_score_data_set['id']);
}
}
}
}
