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