function getBankDetails()
{
//$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 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;
}
}
