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;
}
}
