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