function getUserRequests() { $login_user_id = trim($_REQUEST['userID']); $rm = new Response_Methods(); $userRequestsDetailsArray = array(); //$dataResultSet=$rm->getSpecificDetails($login_user_id,'user_requests_t','login_user_id'); $dataResultSet = $rm->getSpecificDetailsRequest($login_user_id, 'Paid', 'user_requests_t', 'login_user_id', 'status'); //$dataResultSet=$rm->getAllDetails('user_details_t'); if (mysql_num_rows($dataResultSet) > 0) { while ($row = mysql_fetch_array($dataResultSet)) { $getUserRequestsFields['user_request_id'] = $row['user_request_id']; $getUserRequestsFields['payment_from_bank_id'] = $row['payment_from_bank_id']; $getUserRequestsFields['loginID'] = $row['login_user_id']; $getUserRequestsFields['payment_to_bank_id'] = $row['payment_to_bank_id']; //$getUserRequestsFields['payment_date']=$row['payment_date']; $getUserRequestsFields['fBank'] = $rm->idToValue('bank_name', 'bank_details_t', 'bank_id', $row['payment_from_bank_id']); $getUserRequestsFields['tBank'] = $rm->idToValue('bank_name', 'bank_details_t', 'bank_id', $row['payment_to_bank_id']); //$getUserRequestsFields['payment_reason']=$row['payment_reason']; $getUserRequestsFields['amount'] = $row['amount']; $getUserRequestsFields['payment_type'] = $row['payment_type']; $cdate = $row['request_created_date']; $getUserRequestsFields['request_created_date'] = date('Y/m/d', strtotime($cdate)); $getUserRequestsFields['request_created_time'] = date('H:i:s', strtotime($cdate)); $getUserRequestsFields['status'] = $row['status']; if ($row['status'] == 'Accepted') { $getUserRequestsFields['payment_id'] = $rm->idToValue('payment_id', 'payment_details_t', 'user_request_id', $row['user_request_id']); } array_push($userRequestsDetailsArray, $getUserRequestsFields); } $result = $rm->get_anything_details_success($userRequestsDetailsArray, 'User Request'); return $result; } else { $result = $rm->get_anything_details_fail('User Request'); return $result; } }