function likePost()
{
$rm = new Response_Methods();
if ($_SERVER['REQUEST_METHOD'] == "GET") {
$result = $rm->inValidServerMethod();
return $result;
}
//Check request url is https or not
if (!empty($_SERVER["HTTPS"])) {
if ($_SERVER["HTTPS"] !== "off") {
$USERID = trim($_POST['userId']);
//Get Request From Device
$POSTID = trim($_POST['postId']);
//Get Request From Device
$getArrayList = array();
if ($USERID == "" || $POSTID == "") {
$result = $rm->fields_validation();
return $result;
} else {
$checkLike = $rm->checkAlreadyLiked($USERID, $POSTID);
if ($checkLike > 0) {
$result = $rm->alreadyLiked();
return $result;
}
date_default_timezone_set('Asia/Calcutta');
$user_owner_id = $rm->idToValue('user_id_fk', 'news_feeds_t', 'post_id', $POSTID);
//getting user owner id
$createdDate = date('Y-m-d H:i:s');
$getInsertFieldValue['user_id_fk'] = $USERID;
$getInsertFieldValue['post_id_fk'] = $POSTID;
$getInsertFieldValue['user_owner_id_fk'] = $user_owner_id;
$getInsertFieldValue['likeDate_f'] = $createdDate;
$lastInserted_user_id = $rm->insert_record($getInsertFieldValue, 'likes_t');
if (!empty($lastInserted_user_id)) {
$sqlLikeCountUpdate = "update news_feeds_t set like_count_f= like_count_f+1 where post_id={$POSTID}";
mysql_query($sqlLikeCountUpdate, $GLOBALS['link']);
$deviceId = $rm->idToValue('device_id_f', 'user_details_t', 'user_id', $user_owner_id);
//getting deviceId
if ($deviceId != '') {
$message = "You have received a like on your post.";
$rm->sendPushNotification($deviceId, $message);
}
$result = $rm->getParticularPost($POSTID, $USERID);
return $result;
} else {
$result = $rm->likeUnSuccessful();
return $result;
}
}
// end of else first
} else {
$result = $rm->ssl_error();
return $result;
}
} else {
$result = $rm->ssl_error();
return $result;
}
}
function addComment()
{
$rm = new Response_Methods();
if ($_SERVER['REQUEST_METHOD'] == "GET") {
$result = $rm->inValidServerMethod();
return $result;
}
//Check request url is https or not
if (!empty($_SERVER["HTTPS"])) {
if ($_SERVER["HTTPS"] !== "off") {
date_default_timezone_set('Asia/Calcutta');
$comment = $rm->cleanData($_POST['comment']);
//Get Request From Device
$userId = $rm->cleanData($_POST['userId']);
$postId = $rm->cleanData($_POST['postId']);
$createdDate = date('Y-m-d H:i:s');
$getArrayList = array();
//echo $ENCRYPTEDPWD = md5($PASSWORD);
//echo $ENCRYPTEDPWD = base64_decode($PASSWORD);
//$ENCRYPTEDPWD=$PASSWORD;
if ($comment == "" || $userId == "" || $postId == "") {
$result = $rm->fields_validation();
return $result;
} else {
$user_owner_id = $rm->idToValue('user_id_fk', 'news_feeds_t', 'post_id', $postId);
$getInsertFieldValue['comment_text_f'] = $comment;
$getInsertFieldValue['user_id_fk'] = $userId;
$getInsertFieldValue['post_id_fk'] = $postId;
$getInsertFieldValue['comment_Date'] = $createdDate;
$getInsertFieldValue['user_owner_id_fk'] = $user_owner_id;
$lastInsertedCommentId = $rm->insert_record($getInsertFieldValue, 'comments_t');
if ($lastInsertedCommentId) {
$deviceId = $rm->idToValue('device_id_f', 'user_details_t', 'user_id', $user_owner_id);
//getting deviceId
if ($deviceId != '') {
$message = "You have received a comment on your post.";
$rm->sendPushNotification($deviceId, $message);
}
$result = $rm->addCommentSuccessJson($postId);
return $result;
} else {
$result = $rm->addCommentFailJson();
return $result;
}
}
} else {
$result = $rm->ssl_error();
return $result;
}
} else {
$result = $rm->ssl_error();
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 addFriendRequest()
{
$rm = new Response_Methods();
if ($_SERVER['REQUEST_METHOD'] == "GET") {
$result = $rm->inValidServerMethod();
return $result;
}
//Check request url is https or not
if (!empty($_SERVER["HTTPS"])) {
if ($_SERVER["HTTPS"] !== "off") {
$userId = trim($_POST['userId']);
$friendId = trim($_POST['friendId']);
if ($userId == "" || $friendId == "") {
$result = $rm->fields_validation();
return $result;
} else {
if ($userId == $friendId) {
$result = $rm->friendRequestFailforSameUser();
return $result;
} else {
$checkFriend = $rm->checkExistingFriendShip($userId, $friendId);
if ($checkFriend > 0) {
$result = $rm->friendshipAlreadyExists();
return $result;
}
date_default_timezone_set('Asia/Calcutta');
$createdDate = date('Y-m-d H:i:s');
$getList = array();
//preparing list and inserting values in friends_t table
$getInsertFieldValue['friend_one'] = $userId;
$getInsertFieldValue['friend_two'] = $friendId;
$getInsertFieldValue['created_date_f'] = $createdDate;
$lastInserted_friend_id = $rm->insert_record($getInsertFieldValue, 'friends_t');
if (!empty($lastInserted_friend_id)) {
$deviceId = $rm->idToValue('device_id_f', 'user_details_t', 'user_id', $friendId);
//getting deviceId
if ($deviceId) {
$message = "You have received a friend request in petbesties.";
$rm->sendPushNotification($deviceId, $message);
}
$result = $rm->friendRequestSuccess();
return $result;
} else {
$result = $rm->friendRequestFail();
return $result;
}
}
}
// end of else first
} else {
$result = $rm->ssl_error();
return $result;
}
} else {
$result = $rm->ssl_error();
return $result;
}
}
function addUserRequest()
{
//$companyId = $_REQUEST['companyId'];
$login_user_id = trim($_REQUEST['userID']);
$fromBankID = trim($_REQUEST['fromBankID']);
$toBankID = trim($_REQUEST['toBankID']);
//$paymentDate = trim($_REQUEST['paymentDate']);
//$paymentReason = trim($_REQUEST['paymentReason']);
$amount = trim($_REQUEST['amount']);
$paymentType = trim($_REQUEST['paymentType']);
$rm = new Response_Methods();
if ($login_user_id == "" || $fromBankID == "" || $amount == "" || $paymentType == "") {
$result = $rm->fields_validation();
return $result;
} else {
date_default_timezone_set('Asia/Calcutta');
$createdDate = date('Y-m-d H:i:s');
$getList = array();
//inserting payment details
$getInsertFieldValue['login_user_id'] = $login_user_id;
$companyID = $rm->idToValue('company_id', 'user_details_t', 'login_user_id', $login_user_id);
$getInsertFieldValue['payment_from_bank_id'] = $fromBankID;
$getInsertFieldValue['payment_to_bank_id'] = $toBankID;
//$getInsertFieldValue['payment_date']=$paymentDate;
//$getInsertFieldValue['payment_reason']=$paymentReason;
$getInsertFieldValue['amount'] = $amount;
$getInsertFieldValue['payment_type'] = $paymentType;
$getInsertFieldValue['request_created_date'] = $createdDate;
$getInsertFieldValue['company_id'] = $companyID;
$lastInserted_user_request_id = $rm->insert_record($getInsertFieldValue, 'user_requests_t');
if (!empty($lastInserted_user_request_id)) {
//Do Transactions by updating bank current balance
/* Sending Push Notification to Admin */
$gcm_regid = $rm->getUserGCMREGID(2);
if ($gcm_regid != "" || $gcm_regid != "NA") {
$gcm = new GCM();
$registatoin_ids = array($gcm_regid);
$msg = "User Payment Request Made. Please Check";
$message = array("Response" => $msg);
$resultPush = $gcm->send_notification($registatoin_ids, $message);
}
$result = $rm->userRequestSuccessJson($lastInserted_user_request_id);
return $result;
} else {
$result = $rm->userRequestFailJson();
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;
}
}
function getPaymentReports()
{
$userID = trim($_REQUEST['userID']);
$payment_type = trim($_REQUEST['payment_type']);
$from_date = trim($_REQUEST['from_date']);
$to_date = trim($_REQUEST['to_date']);
$rm = new Response_Methods();
$paymentDetailsArray = array();
if ($userID == "" || $payment_type == "" || $from_date == "" || $to_date == "") {
$result = $rm->fields_validation();
return $result;
} else {
$login_user_id = $rm->idToValue('login_user_id', 'user_details_t', 'user_id', $userID);
echo $rm->getPaymentDetails($login_user_id, $payment_type, $from_date, $to_date);
}
}
function updateRequestStatus()
{
$userRequestID = trim($_REQUEST['user_request_id']);
$requestStatus = trim($_REQUEST['status']);
$lastInserted_payment_id = 0;
$rm = new Response_Methods();
if ($userRequestID == "" || $requestStatus == "") {
$result = $rm->fields_validation();
return $result;
} else {
if ($requestStatus == 'Accepted') {
$fromBankID = $rm->idToValue('payment_from_bank_id', 'user_requests_t', 'user_request_id', $userRequestID);
$toBankID = $rm->idToValue('payment_to_bank_id', 'user_requests_t', 'user_request_id', $userRequestID);
$amount = $rm->idToValue('amount', 'user_requests_t', 'user_request_id', $userRequestID);
$fromBankBalance = $rm->idToValue('initial_bank_balance', 'bank_details_t', 'bank_id', $fromBankID);
$toBankBalance = $rm->idToValue('initial_bank_balance', 'bank_details_t', 'bank_id', $toBankID);
if ($fromBankBalance < $amount) {
$result = $rm->insufficient_balance();
return $result;
} else {
if ($fromBankID != $toBankID) {
$fromBankBalance = $fromBankBalance - $amount;
$toBankBalance = $toBankBalance + $amount;
}
$updateFromBankBalance['initial_bank_balance'] = $fromBankBalance;
$affectedRowsFrom = $rm->update_record($updateFromBankBalance, 'bank_details_t', 'bank_id', $fromBankID);
$updateToBankBalance['initial_bank_balance'] = $toBankBalance;
$affectedRowsTo = $rm->update_record($updateToBankBalance, 'bank_details_t', 'bank_id', $toBankID);
$getInsertFieldValue['amount'] = $amount;
$getInsertFieldValue['payment_from_bank_id'] = $fromBankID;
$getInsertFieldValue['payment_to_bank_id'] = $toBankID;
$getInsertFieldValue['user_request_id'] = $userRequestID;
$lastInserted_payment_id = $rm->insert_record($getInsertFieldValue, 'payment_details_t');
$login_user_id = $rm->idToValue('login_user_id', 'user_requests_t', 'user_request_id', $userRequestID);
$gcm_regid = $rm->getUserGCMREGID($login_user_id);
if ($gcm_regid != "" || $gcm_regid != "NA") {
$gcm = new GCM();
$registatoin_ids = array($gcm_regid);
$msg = "Request " . $requestStatus;
$message = array("Response" => $msg);
$resultPush = $gcm->send_notification($registatoin_ids, $message);
}
$getRegisterFieldValue['status'] = $requestStatus;
$affectedRows = $rm->update_record($getRegisterFieldValue, 'user_requests_t', 'user_request_id', $userRequestID);
if ($affectedRows >= 0) {
$result = $rm->requestStatusSuccess($lastInserted_payment_id);
return $result;
} else {
$result = $rm->requestStatusFail();
return $result;
}
}
}
}
}
function addNewsFeeds()
{
$rm = new Response_Methods();
if ($_SERVER['REQUEST_METHOD'] == "GET") {
$result = $rm->inValidServerMethod();
return $result;
}
//Check request url is https or not
if (!empty($_SERVER["HTTPS"])) {
if ($_SERVER["HTTPS"] !== "off") {
$userId = trim($_POST['userId']);
$post_image = trim($_POST['post_image']);
$post_description = $rm->cleanData(trim($_POST['post_description']));
$location_lat = $rm->cleanData(trim($_POST['location_lat']));
$location_lang = $rm->cleanData(trim($_POST['location_lang']));
if ($userId == "" || $post_description == "") {
$result = $rm->fields_validation();
return $result;
} else {
date_default_timezone_set('Asia/Calcutta');
$createdDate = date('Y-m-d H:i:s');
$getList = array();
//preparing list and inserting values in news_feed_table table
$getInsertFieldValue['user_id_fk'] = $userId;
//$getInsertFieldValue['post_image_f']=$post_image;
$getInsertFieldValue['post_description_f'] = $post_description;
$getInsertFieldValue['location_lang_f'] = $location_lang;
$getInsertFieldValue['location_lat_f'] = $location_lat;
$getInsertFieldValue['post_date_f'] = $createdDate;
$lastInserted_post_id = $rm->insert_record($getInsertFieldValue, 'news_feeds_t');
if (!empty($lastInserted_post_id)) {
$IMAGEURLBASEURL = BASEURL . '/images/';
$userImageBaseURL = "images/{$username}";
$username = $rm->idToValue('user_name_f', 'user_details_t', 'user_id', $userId);
$userImageBaseURL = "images/{$username}";
if (!is_dir($userImageBaseURL)) {
//mkdir - tells that need to create a directory
mkdir($userImageBaseURL);
mkdir($userImageBaseURL . '/profile_pics/');
mkdir($userImageBaseURL . '/post_photos/');
}
$rand = rand(00, 99999);
$img = 'data:image/png;base64,' . $post_image . '';
$img = str_replace('data:image/png;base64,', '', $img);
$img = str_replace(' ', '+', $img);
$data = base64_decode($img);
$image = 'post_photos' . $rand . '.png';
file_put_contents($userImageBaseURL . '/post_photos/' . $image, $data);
//file_put_contents($userImageBaseURL.'/profile_pics/'.$image, $data);
$IMAGEURL = $IMAGEURLBASEURL . $username . '/post_photos/' . $image;
$dimensions = $rm->getImageDimensions($data);
$getUpdatePostPic['image_width_f'] = $dimensions["width"];
$getUpdatePostPic['image_height_f'] = $dimensions["height"];
$thumbNames = $rm->createThumbs($data, $userImageBaseURL, $image, 'news_feed_post');
$getUpdatePostPic['thumb1'] = $thumbNames[0]['filename'];
$getUpdatePostPic['thumb2'] = $thumbNames[1]['filename'];
$getUpdatePostPic['thumb3'] = $thumbNames[2]['filename'];
$getUpdatePostPic['thumb4'] = $thumbNames[3]['filename'];
$getUpdatePostPic['thumb5'] = $thumbNames[4]['filename'];
$getUpdatePostPic['ipad_portrait_width'] = $thumbNames[3]['width'];
$getUpdatePostPic['ipad_portrait_height'] = $thumbNames[3]['height'];
$getUpdatePostPic['ipad_landscape_width'] = $thumbNames[4]['width'];
$getUpdatePostPic['ipad_landscape_height'] = $thumbNames[4]['height'];
$getUpdatePostPic['post_image_f'] = $IMAGEURL;
$updateResult = $rm->update_record($getUpdatePostPic, 'news_feeds_t', 'post_id', $lastInserted_post_id);
//$result=$rm->getPosts($userId);
$result = $rm->postCreationSuccessJson();
return $result;
} else {
$result = $rm->postCreationFailJson();
return $result;
}
}
// end of else first
} else {
$result = $rm->ssl_error();
return $result;
}
} else {
$result = $rm->ssl_error();
return $result;
}
}
public function getPaymentDetails($login_user_id, $payment_type, $date1, $date2)
{
$date1 = $date1 . ' 00:00:00';
$date2 = $date2 . ' 23:59:59';
$rm = new Response_Methods();
if ($payment_type == 1) {
$sqlSelect = "select payment_from_bank_id, payment_created_date, amount from payment_details_t where login_user_id={$login_user_id} and payment_created_date BETWEEN '{$date1}' and '{$date2}' and lower(payment_type)='withdrawal' ";
$dataResultSet = mysql_query($sqlSelect, $GLOBALS['link']);
$getList = array();
if (mysql_num_rows($dataResultSet) > 0) {
while ($row = mysql_fetch_array($dataResultSet)) {
$from_bank_id = $row['payment_from_bank_id'];
$fromBankName = $rm->idToValue('bank_name', 'bank_details_t', 'bank_id', $from_bank_id);
$getGroupDetails['fromBankName'] = $fromBankName;
$getGroupDetails['payment_date'] = $row['payment_created_date'];
$getGroupDetails['amount'] = $row['amount'];
$getGroupDetails['type'] = 'withdrawl';
array_push($getList, $getGroupDetails);
//converting array to string
}
$newData = json_encode(array($getList));
$newData = str_replace('\\/', '/', $newData);
$newData = substr($newData, 1, strlen($newData) - 2);
$newData = "{\"data\":{\"Error_Code\":\"1\",\"Error_Msg\":\"Success\",\"result\":" . $newData . "}}";
return $newData;
} else {
$errorCode = "2";
$errorMsg = "Result Not Found";
$newData = "{\"data\":{\"Error_Code\":\"" . $errorCode . "\",\"Error_Msg\":\"" . $errorMsg . "\"}}";
return $newData;
}
} else {
if ($payment_type == 2) {
$sqlSelect = "select payment_id, payment_from_bank_id, payment_to_bank_id, payment_created_date, amount, payment_type from payment_details_t where login_user_id={$login_user_id} and payment_created_date BETWEEN '{$date1}' and '{$date2}' and (lower(payment_type)='cheque' or lower(payment_type)='net' )";
$dataResultSet = mysql_query($sqlSelect, $GLOBALS['link']);
$getList = array();
if (mysql_num_rows($dataResultSet) > 0) {
while ($row = mysql_fetch_array($dataResultSet)) {
$from_bank_id = $row['payment_from_bank_id'];
$to_bank_id = $row['payment_to_bank_id'];
$payment_id = $row['payment_id'];
$fromBankName = $rm->idToValue('bank_name', 'bank_details_t', 'bank_id', $from_bank_id);
$toBankName = $rm->idToValue('bank_name', 'bank_details_t', 'bank_id', $to_bank_id);
$getGroupDetails['fromBankName'] = $fromBankName;
$getGroupDetails['toBankName'] = $toBankName;
$payment_type = $row['payment_type'];
if (strtolower($payment_type) == "cheque") {
$cheque_date = $rm->idToValue('cheque_date', 'cheque_details_t', 'payment_id', $payment_id);
$getGroupDetails['cheque_date'] = $cheque_date;
$getGroupDetails['type'] = 'cheque';
} else {
$getGroupDetails['payment_date'] = $row['payment_created_date'];
$getGroupDetails['type'] = 'net';
}
$getGroupDetails['amount'] = $row['amount'];
array_push($getList, $getGroupDetails);
//converting array to string
}
$newData = json_encode(array($getList));
$newData = str_replace('\\/', '/', $newData);
$newData = substr($newData, 1, strlen($newData) - 2);
$newData = "{\"data\":{\"Error_Code\":\"1\",\"Error_Msg\":\"Success\",\"result\":" . $newData . "}}";
return $newData;
} else {
$errorCode = "2";
$errorMsg = "Result Not Found";
$newData = "{\"data\":{\"Error_Code\":\"" . $errorCode . "\",\"Error_Msg\":\"" . $errorMsg . "\"}}";
return $newData;
}
}
}
}
function addPaymentDetails()
{
//$companyId = $_REQUEST['companyId'];
$companyID = trim($_REQUEST['companyID']);
$fromBankID = trim($_REQUEST['fromBankID']);
$toBankID = trim($_REQUEST['toBankID']);
//$paymentDate = trim($_REQUEST['paymentDate']);
$paymentReason = trim($_REQUEST['paymentReason']);
$amount = trim($_REQUEST['amount']);
$paymentType = trim($_REQUEST['paymentType']);
$userType = trim($_REQUEST['userType']);
$userID = trim($_REQUEST['userID']);
$user_request_id = trim($_REQUEST['user_request_id']);
$payment_id = trim($_REQUEST['payment_id']);
// in case of user
$affectedRowsPayment = -1;
$rm = new Response_Methods();
if ($companyID == "" || $fromBankID == "" || $paymentReason == "" || $amount == "" || $paymentType == "") {
$result = $rm->fields_validation();
return $result;
} else {
date_default_timezone_set('Asia/Calcutta');
$createdDate = date('Y-m-d H:i:s');
$getList = array();
$mailData["paymentDetails"] = array();
//inserting payment details
$getInsertFieldValue['company_id'] = $companyID;
$getInsertFieldValue['payment_from_bank_id'] = $fromBankID;
$getInsertFieldValue['payment_to_bank_id'] = $toBankID;
//$getInsertFieldValue['payment_date']=$paymentDate;
$getInsertFieldValue['payment_reason'] = $paymentReason;
$getInsertFieldValue['login_user_id'] = $userID;
$getInsertFieldValue['amount'] = $amount;
$getInsertFieldValue['payment_type'] = $paymentType;
$getInsertFieldValue['payment_created_date'] = $createdDate;
$checkRecords = mysql_query("SELECT user_request_id FROM user_requests_t WHERE user_request_id='{$user_request_id}'");
$checkRecords = mysql_num_rows($checkRecords);
if ($userType == 'Admin') {
$checkRecords = 1;
}
if ($checkRecords > 0) {
if (strtolower($userType) == "user") {
$affectedRowsPayment = $rm->update_record($getInsertFieldValue, 'payment_details_t', 'payment_id', $payment_id);
} else {
if (strtolower($userType) == "admin") {
$lastInserted_payment_id = $rm->insert_record($getInsertFieldValue, 'payment_details_t');
}
}
$mailData = $getInsertFieldValue;
$mailData['userID'] = $userID;
//array_push($mailData["paymentDetails"], $getInsertFieldValue);
if (!empty($lastInserted_payment_id)) {
//Do Transactions by updating banks current balance
$fromBankBalance = $rm->idToValue('initial_bank_balance', 'bank_details_t', 'bank_id', $fromBankID);
$toBankBalance = $rm->idToValue('initial_bank_balance', 'bank_details_t', 'bank_id', $toBankID);
if ($fromBankBalance < $amount) {
$result = $rm->insufficient_balance();
return $result;
}
if ($fromBankID != $toBankID) {
$fromBankBalance = $fromBankBalance - $amount;
$toBankBalance = $toBankBalance + $amount;
}
$updateFromBankBalance['initial_bank_balance'] = $fromBankBalance;
$affectedRowsFrom = $rm->update_record($updateFromBankBalance, 'bank_details_t', 'bank_id', $fromBankID);
$updateToBankBalance['initial_bank_balance'] = $toBankBalance;
$affectedRowsTo = $rm->update_record($updateToBankBalance, 'bank_details_t', 'bank_id', $toBankID);
}
//check payment type and insert details accordingly(cheque/net)
if (strtolower($paymentType) == "cheque") {
//insert cheque details
$mailData["chequeDetails"] = array();
if (!empty($lastInserted_payment_id)) {
$payment_id_inserted = $lastInserted_payment_id;
} else {
$payment_id_inserted = $payment_id;
}
$getChequeDetails['payment_id'] = $payment_id_inserted;
$getChequeDetails['cheque_number'] = trim($_REQUEST['chequeNo']);
$getChequeDetails['cheque_date'] = trim($_REQUEST['chequeDate']);
$getChequeDetails['to_whom_issued'] = trim($_REQUEST['chequeIssued']);
//$getChequeDetails['cheque_amount']=trim($_REQUEST['chequeAmount']);
$getChequeDetails['cheque_amount'] = $amount;
$getChequeDetails['cheque_created_date'] = $createdDate;
$lastInserted_cheque_id = $rm->insert_record($getChequeDetails, 'cheque_details_t');
array_push($mailData["chequeDetails"], $getChequeDetails);
} else {
if (strtolower($paymentType) == "net") {
//insert NET Banking Details
$mailData["netDetails"] = array();
if (!empty($lastInserted_payment_id)) {
$payment_id_inserted = $lastInserted_payment_id;
} else {
$payment_id_inserted = $payment_id;
}
$getNetBankingDetails['payment_id'] = $payment_id_inserted;
//$getNetBankingDetails['type']=trim($_REQUEST['netBankingType']);
$getNetBankingDetails['nbd_created_date'] = $createdDate;
$lastInserted_cheque_id = $rm->insert_record($getNetBankingDetails, 'net_banking_details_t');
array_push($mailData["netDetails"], $getNetBankingDetails);
//print_r($getNetBankingDetails);
}
}
if (strtolower($userType) == "user") {
$adminId = 1;
if ($adminId != 0) {
$adminEmail = $rm->getAdminEmailID($adminId);
//print_r($mailData);;
$sendMail = $rm->sendTransactionDetails($adminEmail, $mailData);
}
}
if (strtolower($userType) == "user" && $affectedRowsPayment >= 0) {
$result = $rm->paymentRegisterSuccessJson($payment_id);
$sqlUpdate = "update user_requests_t set status='Paid' where user_request_id={$user_request_id}";
mysql_query($sqlUpdate, $GLOBALS['link']);
return $result;
} else {
if (strtolower($userType) == "admin" && !empty($lastInserted_payment_id)) {
$result = $rm->paymentRegisterSuccessJson($lastInserted_payment_id);
$sqlUpdate = "update user_requests_t set status='Paid' where user_request_id={$user_request_id}";
mysql_query($sqlUpdate, $GLOBALS['link']);
return $result;
}
}
if (empty($lastInserted_payment_id) && strtolower($userType) == "admin") {
$result = $rm->paymentRegisterFailJson();
return $result;
}
if ($affectedRowsPayment < 0 && strtolower($userType) == "user") {
$result = $rm->paymentRegisterFailJson();
return $result;
}
} else {
$errorCode = "2";
$errorMsg = "User Request Not Exist";
$newData = "{\"data\":{\"Error_Code\":\"" . $errorCode . "\",\"Error_Msg\":\"" . $errorMsg . "\"}}";
//Json Format Response
return $newData;
}
}
}
public function getSingleCommentDetails($postId, $loggedInUserId, $commentId)
{
$commentArray = array();
$commentArray1 = array();
$postArray = array();
$postArray1 = array();
//$dataQueryInfo = "SELECT login_id,user_name_f FROM login_t WHERE user_name_f= '$USERNAME' AND password_f='$PASSWORD'";
//$dataQueryInfo = "SELECT u.user_id,u.user_name_f,c.comment_text_f,c.comment_date,c.comment_id,n.post_id FROM user_details_t u, comments_t c,news_feeds_t n WHERE (u.user_id=c.user_id_fk) and (n.post_id=c.post_id_fk) and (c.comment_id=$commentId) order by c.comment_id desc";
$dataQueryInfo = "SELECT u.user_id,u.user_name_f,u.profile_pic_f,c.comment_text_f,c.comment_date,c.comment_id,n.post_id,n.post_description_f,n.post_image_f,n.post_date_f,n.like_count_f,n.image_width_f,n.image_height_f FROM user_details_t u, comments_t c,news_feeds_t n WHERE (u.user_id=c.user_id_fk) and (n.post_id=c.post_id_fk) and (c.post_id_fk={$postId}) order by c.comment_id desc";
$dataResultSet = mysql_query($dataQueryInfo, $GLOBALS['link']);
$rm = new Response_Methods();
if (mysql_num_rows($dataResultSet) > 0) {
$countComments = mysql_num_rows($dataResultSet);
while ($row = mysql_fetch_array($dataResultSet)) {
$username = $row['user_name_f'];
$commentedUserId = $row['user_id'];
$commentText = $row['comment_text_f'];
$commentDate = $row['comment_date'];
$commentIdRow = $row['comment_id'];
$postId = $row['post_id'];
$post_description = $row['post_description_f'];
$post_image = $row['post_image_f'];
$post_date = $row['post_date_f'];
$like_count = $row['like_count_f'];
$image_width = $row['image_width_f'];
$image_height = $row['image_height_f'];
$commentArray['commentedUserName'] = $username;
$commentArray['commentedUserId'] = $commentedUserId;
$commentArray['commentText'] = $rm->removeslashes($commentText);
$commentArray['commentDate'] = $commentDate;
$commentArray['commentId'] = $commentIdRow;
$postArray['postId'] = $postId;
$postArray['post_description'] = $post_description;
$postArray['post_image_url'] = $post_image;
$postArray['post_date'] = $post_date;
$postArray['like_count'] = $like_count;
$postArray['image_width'] = $image_width;
$postArray['image_height'] = $image_height;
if ($loggedInUserId == $commentedUserId) {
$commentArray['editDeleteFlag'] = "1";
} else {
$commentArray['editDeleteFlag'] = "0";
}
//$getGrpDetails['commentCount']=$countComments;
array_push($commentArray1, $commentArray);
//array_push($postArray1,$postArray);
}
$postUserId = $rm->idToValue('user_id_fk', 'news_feeds_t', 'post_Id', $postId);
$postUserName = $rm->idToValue('user_name_f', 'user_details_t', 'user_id', $postUserId);
//getting user details
$user_profile_pic = $rm->idToValue('profile_pic_f', 'user_details_t', 'user_id', $postUserId);
//getting user details
$loginUserDetails = array("postUserName" => $postUserName, "user_profile_pic" => $user_profile_pic);
$postArray = array_merge($postArray, $loginUserDetails);
$sqlChangeCommentStatus = "update comments_t set comment_status_f=0 where comment_id=" . $commentId;
$updateCommentStatus = mysql_query($sqlChangeCommentStatus, $GLOBALS['link']);
$finalArray = array("comment_details" => $commentArray1, "post_details" => $postArray);
//print_r($getArrayList);
$newData = json_encode(array($finalArray));
$newData = str_replace('\\/', '/', $newData);
$newData = substr($newData, 1, strlen($newData) - 2);
$newData = "{\"data\":{\"Error_Code\":\"41\",\"Error_Msg\":\"Comment List Successful\",\"result\":" . $newData . "}}";
return $newData;
} else {
$errorCode = "42";
$errorMsg = "No Such Comment Found.";
$newData = "{\"data\":{\"Error_Code\":\"" . $errorCode . "\",\"Error_Msg\":\"" . $errorMsg . "\"}}";
//Json Format Response
return $newData;
//Comment Unsuccessful
}
}
function addPaymentDetails()
{
//$companyId = $_REQUEST['companyId'];
$companyID = trim($_REQUEST['companyID']);
$fromBankID = trim($_REQUEST['fromBankID']);
$toBankID = trim($_REQUEST['toBankID']);
//$paymentDate = trim($_REQUEST['paymentDate']);
$paymentReason = trim($_REQUEST['paymentReason']);
$amount = trim($_REQUEST['amount']);
$paymentType = trim($_REQUEST['paymentType']);
$rm = new Response_Methods();
if ($companyID == "" || $fromBankID == "" || $toBankID == "" || $paymentReason == "" || $amount == "" || $paymentType == "") {
$result = $rm->fields_validation();
return $result;
} else {
date_default_timezone_set('Asia/Calcutta');
$createdDate = date('Y-m-d H:i:s');
$getList = array();
//inserting payment details
$getInsertFieldValue['company_id'] = $companyID;
$getInsertFieldValue['payment_from_bank_id'] = $fromBankID;
$getInsertFieldValue['payment_to_bank_id'] = $toBankID;
//$getInsertFieldValue['payment_date']=$paymentDate;
$getInsertFieldValue['payment_reason'] = $paymentReason;
$getInsertFieldValue['amount'] = $amount;
$getInsertFieldValue['payment_type'] = $paymentType;
$getInsertFieldValue['payment_created_date'] = $createdDate;
$lastInserted_payment_id = $rm->insert_record($getInsertFieldValue, 'payment_details_t');
if (!empty($lastInserted_payment_id)) {
//Do Transactions by updating bank current balance
$fromBankBalance = $rm->idToValue('initial_bank_balance', 'bank_details_t', 'bank_id', $fromBankID);
$toBankBalance = $rm->idToValue('initial_bank_balance', 'bank_details_t', 'bank_id', $toBankID);
if ($fromBankID != $toBankID) {
$fromBankBalance = $fromBankBalance - $amount;
$toBankBalance = $toBankBalance + $amount;
}
$updateFromBankBalance['initial_bank_balance'] = $fromBankBalance;
$affectedRowsFrom = $rm->update_record($updateFromBankBalance, 'bank_details_t', 'bank_id', $fromBankID);
$updateToBankBalance['initial_bank_balance'] = $toBankBalance;
$affectedRowsTo = $rm->update_record($updateToBankBalance, 'bank_details_t', 'bank_id', $toBankID);
//check payment type and insert details accordingly(cheque/net)
if (strtolower($paymentType) == "cheque") {
//insert cheque details
//echo 'test';
$getChequeDetails['payment_id'] = $lastInserted_payment_id;
$getChequeDetails['cheque_number'] = trim($_REQUEST['chequeNo']);
$getChequeDetails['cheque_date'] = trim($_REQUEST['chequeDate']);
$getChequeDetails['to_whom_issued'] = trim($_REQUEST['chequeIssued']);
//$getChequeDetails['cheque_amount']=trim($_REQUEST['chequeAmount']);
$getChequeDetails['cheque_amount'] = $amount;
$getChequeDetails['cheque_created_date'] = $createdDate;
$lastInserted_cheque_id = $rm->insert_record($getChequeDetails, 'cheque_details_t');
} else {
if (strtolower($paymentType) == "net") {
//insert NET Banking Details
$getNetBankingDetails['payment_id'] = $lastInserted_payment_id;
$getNetBankingDetails['type'] = trim($_REQUEST['netBankingType']);
$getNetBankingDetails['nbd_created_date'] = $createdDate;
$lastInserted_cheque_id = $rm->insert_record($getNetBankingDetails, 'net_banking_details_t');
}
}
$result = $rm->paymentRegisterSuccessJson($lastInserted_payment_id);
return $result;
} else {
$result = $rm->paymentRegisterFailJson();
return $result;
}
}
}
