function getAllBankDetails() { //$bankID = trim($_REQUEST['bankID']); $rm = new Response_Methods(); $bankDetailsArray = array(); //$companyID = trim($_REQUEST['companyID']); //$dataResultSet=$rm->getSpecificDetails($companyID,'bank_details_t','company_id'); $dataResultSet = $rm->getAllDetails('bank_details_t'); if (mysql_num_rows($dataResultSet) > 0) { while ($row = mysql_fetch_array($dataResultSet)) { $getBankFields['bankID'] = $row['bank_id']; $getBankFields['companyID'] = $row['company_id']; $getBankFields['bankName'] = $row['bank_name']; $getBankFields['custName'] = $row['account_holder_name']; $getBankFields['accNumber'] = $row['account_number']; //$getBankFields['bankAddress']=$row['bank_address']; $getBankFields['ifsc'] = $row['bank_ifsc']; //$getBankFields['micr']=$row['bank_micr']; $getBankFields['accType'] = $row['account_type']; $getBankFields['initialBalance'] = $row['initial_bank_balance']; $cdate = $row['bank_created_date']; $getBankFields['createdDate'] = date('Y/m/d', strtotime($cdate)); array_push($bankDetailsArray, $getBankFields); } $result = $rm->get_anything_details_success($bankDetailsArray, 'Bank'); return $result; } else { $result = $rm->get_anything_details_fail('Bank'); return $result; } }
function getCompanyDetails() { if (isset($_REQUEST['loginID '])) { $loginID = $_REQUEST['loginID']; } $rm = new Response_Methods(); $companyDetailsArray = array(); //$dataResultSet=$rm->getSpecificDetails($companyID,'company_details_t','company_id'); $dataResultSet = $rm->getAllDetails('company_details_t'); if (mysql_num_rows($dataResultSet) > 0) { while ($row = mysql_fetch_array($dataResultSet)) { $getCompanyFields['companyID'] = $row['company_id']; $pending_requests_count = $rm->getPendingRequest($row['company_id']); $getCompanyFields['companyName'] = $row['company_name']; $getCompanyFields['companyTanNo'] = $row['company_tan_no']; $getCompanyFields['companyPanNo'] = $row['company_pan_no']; $getCompanyFields['companyAddress'] = $row['company_address']; $getCompanyFields['pendingRequest'] = $pending_requests_count; $cdate = $row['company_created_date']; $getCompanyFields['createdDate'] = date('Y/m/d', strtotime($cdate)); array_push($companyDetailsArray, $getCompanyFields); } $result = $rm->get_anything_details_success($companyDetailsArray, 'Company'); return $result; } else { $result = $rm->get_anything_details_fail('Company'); return $result; } }
function checkBankBalance() { //$companyId = $_REQUEST['companyId']; $bank_id = trim($_REQUEST['bankID']); $amount = trim($_REQUEST['amount']); $rm = new Response_Methods(); if ($amount == "" || $bank_id == "") { $result = $rm->fields_validation(); return $result; } else { $currentBalance = $rm->idToValue('initial_bank_balance', 'bank_details_t', 'bank_id', $bank_id); if ($currentBalance != 'NA') { if ($amount > $currentBalance) { $result = $rm->insufficientAmountJson(); return $result; } else { $result = $rm->sufficientAmountJson(); return $result; } } else { $result = $rm->get_anything_details_fail('Bank'); return $result; } } }
function getCompanyList() { $rm = new Response_Methods(); $companyDetailsArray = array(); //$dataResultSet=$rm->getSpecificDetails($companyID,'company_details_t','company_id'); $dataResultSet = $rm->getAllDetails('company_details_t'); if (mysql_num_rows($dataResultSet) > 0) { while ($row = mysql_fetch_array($dataResultSet)) { $getCompanyFields['companyID'] = $row['company_id']; $getCompanyFields['companyName'] = $row['company_name']; array_push($companyDetailsArray, $getCompanyFields); } $result = $rm->get_anything_details_success($companyDetailsArray, 'Company'); return $result; } else { $result = $rm->get_anything_details_fail('Company'); return $result; } }
function getUserDetails() { $companyID = trim($_REQUEST['companyID']); $rm = new Response_Methods(); if ($companyID == "") { $result = $rm->fields_validation(); return $result; } $userDetailsArray = array(); $dataResultSet = $rm->getSpecificDetails($companyID, 'user_details_t', 'company_id'); //$dataResultSet=$rm->getAllDetails('user_details_t'); if (mysql_num_rows($dataResultSet) > 0) { while ($row = mysql_fetch_array($dataResultSet)) { /* $getUserFields['userID']=$row['user_id']; if($row['user_image']!='') $userPic=$row['user_image']; else $userPic='noImage.jpg'; $getUserFields['image']="http://phbjharkhand.in/bookOfAccounts/userPics/$userPic"; $getUserFields['login_user_id']=$row['login_user_id']; $cdate=$row['user_created_date']; $getUserFields['createdDate']=date('Y/m/d', strtotime($cdate)); */ $getUserFields['userID'] = $row['user_id']; $getUserFields['userFname'] = $row['user_fname']; $getUserFields['userLname'] = $row['user_lname']; $getUserFields['age'] = $row['user_age']; $getUserFields['sex'] = $row['user_sex']; $getUserFields['emailId'] = $row['user_email_id']; $userType = $rm->getUserType($row['login_user_id']); $getUserFields['userType'] = $userType; $getUserFields['address'] = $row['user_address']; array_push($userDetailsArray, $getUserFields); } $result = $rm->get_anything_details_success($userDetailsArray, 'User'); return $result; } else { $result = $rm->get_anything_details_fail('User'); return $result; } }
function getBankDetails() { $rm = new Response_Methods(); $bankDetailsArray = array(); $email_id = trim($_REQUEST['emailID']); $fullName = trim($_REQUEST['fullName']); $bankidsCheck = trim($_REQUEST['bankIDs']); //$bankids=array(33,34); //$bankidsCheck="33-34"; $stringToArray = explode(",", $bankidsCheck); //print_r ($stringToArray); //die(); $dataResultSet = $rm->getSpecificINDetails($stringToArray, 'bank_details_t', 'bank_id'); if (mysql_num_rows($dataResultSet) > 0) { while ($row = mysql_fetch_array($dataResultSet)) { $getBankFields['bankID'] = $row['bank_id']; $getBankFields['companyID'] = $row['company_id']; $getBankFields['bankName'] = $row['bank_name']; $getBankFields['custName'] = $row['account_holder_name']; $getBankFields['accNumber'] = $row['account_number']; //$getBankFields['bankAddress']=$row['bank_address']; $getBankFields['ifsc'] = $row['bank_ifsc']; //$getBankFields['micr']=$row['bank_micr']; $getBankFields['accType'] = $row['account_type']; $getBankFields['initialBalance'] = $row['initial_bank_balance']; $cdate = $row['bank_created_date']; $getBankFields['createdDate'] = date('Y/m/d', strtotime($cdate)); array_push($bankDetailsArray, $getBankFields); } //print_r($bankDetailsArray); $rm->sendMailBankDetails($email_id, $bankDetailsArray, $fullName); $result = $rm->get_anything_details_success($bankDetailsArray, 'Bank'); return $result; } else { $result = $rm->get_anything_details_fail('Bank'); return $result; } }
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; } }