/** * @param $JSON * INFO : API-11 | Status:Completed | Tested : Yes. | Tested in Live : Yes. */ function doGetAllCommentedPostsOfAnIndividualUser($JSON) { # JSON info's Reading. $facebookID = $JSON->facebook_id; # Extra JSON User info's Reading $os = $JSON->os; # value can be only 'a' or 'i' $language = $JSON->lang; # value can be only 'en' or 'ar' # Current app Using User's ID. $currentAppUsingUsersID = getUserIDFromFacebookID($facebookID); # Query creation. $query = "SELECT ci.id AS comment_id,ci.comment,ci.`commented_user_id`,ci.post_id,ci.timestamp_commented,\n pi.id AS post_id,pi.post,pi.timestamp_posted,\n ui.id AS user_id,ui.full_name,ui.facebook_id,ui.profile_picture_url,ui.flag_online\n FROM comments_info AS ci,posts_info AS pi,users_info AS ui\n WHERE\n pi.id=ci.post_id\n AND\n pi.posted_user_id=ui.id\n AND\n ci.flag_active=1\n AND\n ci.commented_user_id={commented-user-id}\n ORDER BY ci.timestamp_commented DESC"; $query = str_replace("{commented-user-id}", $currentAppUsingUsersID, $query); $db = new DBCon(); $result = $db->executeQuery($query); if (mysql_num_rows($result) > 0) { while ($resultRowAsArray = mysql_fetch_assoc($result)) { # Reading of Database values. $commentID = $resultRowAsArray['comment_id']; $comment = $resultRowAsArray['comment']; $commentedUserID = $resultRowAsArray['commented_user_id']; $postID = $resultRowAsArray['post_id']; $timestampCommented = $resultRowAsArray['timestamp_commented']; $postID = $resultRowAsArray['post_id']; $post = $resultRowAsArray['post']; $timestampPosted = $resultRowAsArray['timestamp_posted']; $userID = $resultRowAsArray['user_id']; $fullName = $resultRowAsArray['full_name']; $facebookID = $resultRowAsArray['facebook_id']; $profilePictureURL = $resultRowAsArray['profile_picture_url']; $flagOnline = $resultRowAsArray['flag_online']; # Assigning wanted details to this Array. $postsInfo[] = array("comment_id" => $commentID, "comment" => $comment, "commented_user_id" => $commentedUserID, "post_id" => $postID, "timestamp_commented" => $timestampCommented, "post_id" => $postID, "post" => $post, "post_user_id" => $userID, "full_name" => $fullName, "facebook_id" => $facebookID, "profile_picture_url" => $profilePictureURL, "flag_online" => $flagOnline, "timestamp_posted" => $timestampPosted); } $responseJSON = array("key" => REQUEST_ALL_COMMENTED_POSTS_OF_MINE, "response" => RESPONSE_SUCCESS, "message" => "Post Info Read.", "posts_info" => $postsInfo); } else { $responseJSON = array("key" => REQUEST_ALL_COMMENTED_POSTS_OF_MINE, "response" => RESPONSE_FAILED, "message" => "Comments Infos Empty"); } sendResponseToAppAndExitAPI($responseJSON); # Giving JSON Response to Mobile app. }
/** * @param $JSON * INFO : API-22 | Status:Completed Partially | Tested : Yes | Tested in Beta : Yes | Tested in Live : No. * TODO : 1.Send all details as Email to Sarrah's Email ID. * DONE : Fullname to Description. - and Test working fine or Not. */ function doAddDonate($JSON) { # Default Settings. $fileIndexName = "donate_food_image"; # index name used for File in Multipart Request. # Reading of POST Infos. $appUserFacebookID = $_POST['app_user_facebook_id']; $title = $_POST['title']; $description = $_POST['description']; $phoneNumber = $_POST['phone_number']; $latitude = $_POST['latitude']; $longitude = $_POST['longitude']; $city = $_POST['city']; $country = $_POST['country']; # Creation of other values. $ownerUserID = getUserIDFromFacebookID($appUserFacebookID); # Getting User ID from Facebook ID. $flagTaken = "0"; # by Default Donated food is not Taken. $flagActive = "1"; # by default Donated food is Active. $timestampSubmitted = time(); $imageFile = "without-image.png"; #$newFileName = getUniqueRandomeFileName($fileIndexName); ++++++ reverse here #$imageFile= $newFileName = getUniqueRandomeFileName($fileIndexName); # Save Image file of Food an continue according to the Result. $statusFileSave = true; #saveFileInFoodImagesDIR($fileIndexName, $newFileName); +++++++++ reverse here #$statusFileSave =saveFileInDonatedFoodImagesDIR($fileIndexName, $newFileName); # If Image file is not Saved in server , Send Failed response to app and Exit. if (!$statusFileSave) { $responseJSON = array("key" => REQUEST_ADD_DONATE, "response" => RESPONSE_FAILED, "message" => "Donate Food Image file save Failed."); sendResponseToAppAndExitAPI($responseJSON); # Giving JSON Response to Mobile app. } else { $query = "INSERT INTO " . TABLE_DONATED_FOODS_INFO . "\n (owner_user_id,title,image_file,description,phone_number,latitude,longitude,city,country,flag_taken,flag_active,timestamp_submitted)\n VALUES({$ownerUserID},'{$title}','{$imageFile}','{$description}','{$phoneNumber}','{$latitude}','{$longitude}','{$city}','{$country}',{$flagTaken},{$flagActive},'{$timestampSubmitted}')"; $db = new DBCon(); $result = $db->executeQuery($query); if ($result) { $responseJSON = array("key" => REQUEST_ADD_DONATE, "response" => RESPONSE_SUCCESS, "message" => "Success, 'Add Donate' Details Saved."); } else { $responseJSON = array("key" => REQUEST_ADD_DONATE, "response" => RESPONSE_FAILED, "message" => "Add Donate Failed - Insert Query Error."); } sendResponseToAppAndExitAPI($responseJSON); # Giving JSON Response to Mobile app. } }