<?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']); } } } }