function sendMessage($from_user_id, $to_user_id, $message, $con) { $con->query("INSERT INTO `pm`(`message_id`, `from_user_id`, `to_user_id`, " . "`message`, `message_time`) " . "VALUES (null, '{$from_user_id}','{$to_user_id}','{$message}',now())"); $user = getUserDetail($from_user_id, $con); $message = str_replace("<br>", "\n", $message); $message = str_replace("<b>", "", $message); $message = str_replace("</b>", "", $message); pushToUser($to_user_id, "Dog Blood Donor PM", $user["firstname"] . ": " . $message, "pm", $from_user_id, $con); if ($con->error == "") { return 1; } else { return 0; } }
} } sendMessage(0, $user_id, $message, $con); // call pm functions if ($con->error == "") { $result = 1; } } else { //Create Request //save to db (request_type = 2) $con->query("INSERT INTO `request`(`request_id`, `from_user_id`, `for_dog_id`, `symptoms`, " . "`place_id`, `duedate`, `request_type`, `bloodstore_id`, `created_time`, `amount_volume`) " . "VALUES (null,'{$user_id}','{$dog_id}','{$symptoms}','{$place_id}','{$duedate}',2,'',now(),'{$volume}')"); $request_id = $con->insert_id; $bloodtype_id = $dog["dog_bloodtype_id"]; //find users that have dog that have this bloodtype_id if ($bloodtype_id == "1" | $bloodtype_id == "2") { $findUsers = $con->query("SELECT DISTINCT user_id FROM user_dog WHERE dog_bloodtype_id NOT IN (1,2)"); } else { $findUsers = $con->query("SELECT DISTINCT user_id FROM user_dog WHERE dog_bloodtype_id = '{$bloodtype_id}'"); } while ($userstopush = $findUsers->fetch_array()) { $user_id_to_push = $userstopush[0]; if ($user_id != $user_id_to_push) { pushToUser($user_id_to_push, "แจ้งเตือนการขอเลือด", "มีสุนัขต้องการเลือดหมู่ " . $bloodtype["bloodtype_name"] . " ด่วน !", "request", $request_id, $con); } } if ($con->error == "") { $result = 2; } } $response = array("result" => $result); echo json_encode($response);
<?php include "../../include/functions.php"; include "../../include/push_functions.inc.php"; include "../../include/dbcon.inc.php"; header('Content-Type: application/json'); $user_id = getUserIdFromToken($con, @$_POST["token"]); $request_id = $con->real_escape_string(@$_POST["request_id"]); $dog_id = $con->real_escape_string(@$_POST["dog_id"]); $res = $con->query("INSERT INTO `donate`(`donate_id`, `request_id`, `dog_id`, `donate_date`," . " `donate_status`, `donate_lastupdate`) " . "VALUES (null,'{$request_id}','{$dog_id}',0,0,now())"); $request = getRequestById($request_id, $con); $requser_id = $request["from_user_id"]; $status = getDonatorStatus($request_id, $dog_id, $con); if ($status == "real") { pushToUser($requser_id, "แจ้งเตือนการขอเลือด", "มีผู้บริจาคเลือดให้กับสุนัขของคุณ", "requester", $request_id, $con); } if ($con->error == "") { $response = array("result" => 1); } else { $response = array("result" => 0); } echo json_encode($response);
<?php date_default_timezone_set('Asia/Bangkok'); echo "Running Confirm Push Script at : " . date('l jS \\of F Y h:i:s A') . "\n"; include "../../include/dbcon.inc.php"; include "../../include/pm_functions.inc.php"; include "../../include/push_functions.inc.php"; $findrequest = $con->query("SELECT * FROM request WHERE date(duedate) < date(now() + INTERVAL 7 DAY) " . "AND request_id NOT IN (SELECT request_id FROM donate WHERE donate_status = 1 OR donate_status = 2)"); if ($findrequest->num_rows > 0) { echo "Found " . $findrequest->num_rows . " Requests to push\n"; while ($data = $findrequest->fetch_assoc()) { $user_id = $data["from_user_id"]; $request_id = $data["request_id"]; echo "Pushing to userid=" . $user_id . " from request_id=" . $request_id . " \n"; pushToUser($user_id, "แจ้งเตือนการยืนยันผู้บริจาค", "กรุณายืนยันการขอเลือดสุนัขของคุณ", "confirmalert", $request_id, $con); } } else { echo "No Request Found\n"; } echo "Program Finish at : " . date('l jS \\of F Y h:i:s A') . "\n";
$donatecalc = calculateDonator($request["amount_volume"]); $donators = getDonatorByRequestId($request_id, $con); $statsbefore = array("realneed" => $donatecalc["realdonator"], "realdonator" => sortRealDonator($donators, $donatecalc), "altneed" => $donatecalc["extradonator"], "altdonator" => sortAltDonator($donators, $donatecalc), "total" => $donatecalc["total"], "current" => sizeof($donator)); //print_r($statsbefore); $res = $con->query("UPDATE donate SET donate_status = '{$isDonate}' , donate_date = now() " . "WHERE request_id = '{$request_id}' AND dog_id ='{$dog_id}' "); echo $con->error; if ($con->error == "") { $response = array("result" => 1); } else { $response = array("result" => 0); } } if ($isDonate == 3) { //get after change $request = getRequestById($request_id, $con); $donator = getCurrentActiveDonateByRequestId($request_id, $con); $donatecalc = calculateDonator($request["amount_volume"]); $donators = getDonatorByRequestId($request_id, $con); $statsafter = array("realneed" => $donatecalc["realdonator"], "realdonator" => sortRealDonator($donators, $donatecalc), "altneed" => $donatecalc["extradonator"], "altdonator" => sortAltDonator($donators, $donatecalc), "total" => $donatecalc["total"], "current" => sizeof($donator)); //print_r($statsafter); //echo "afterdogid:".$statsafter["realdonator"][$statsafter["realneed"]-1]["dog_id"]; //echo "beforedogid:".$statsbefore["altdonator"][0]["dog_id"]; if (isset($statsbefore["altdonator"][0]["dog_id"])) { if ($statsafter["realdonator"][$statsafter["realneed"] - 1]["dog_id"] == $statsbefore["altdonator"][0]["dog_id"]) { $user = getDogById($statsafter["realdonator"][$statsafter["realneed"] - 1]["dog_id"], $con); $user_id = $user["user_id"]; pushToUser($user_id, "เปลื่ยนสถานะเป็นตัวจริง", "คุณเป็นผู้บริจาคตัวจริง", "donator", $request_id, $con); } } } echo json_encode($response);