header("Content-Type: text/event-stream");
header("Cache-Control: no-cache");
// header('retry: 1000');
require_once "DbConnection.php";
require_once "../models/Orders.php";
session_start();
if (!isset($_SESSION['rows'])) {
$_SESSION['rows'] = 0;
}
var_dump($_SESSION);
$tblRows = $_SESSION['rows'];
$dbConnection = DbConnection::getConnection();
$orderInterface = new Orders($dbConnection);
$dbRowSet = $dbConnection->query("SELECT count(*) as count from orders");
$resultArr = $dbRowSet->fetch_assoc();
// $resultArr = json_encode($resultArr);
// echo "data: {$resultArr}\n\n";
if ($tblRows != 0 && $tblRows < $resultArr['count']) {
$_SESSION['rows'] = $resultArr['count'];
$ordersSet = $orderInterface->getOrders("and status != 'canceled' order by date,time desc limit 1");
$order = $ordersSet->fetch_assoc();
$response = array();
$response['response'] = $order;
$response = json_encode($response);
echo "data: {$response}\n\n";
ob_end_flush();
flush();
} else {
$_SESSION['rows'] = $resultArr['count'];
}
<?php
require_once "DbConnection.php";
require_once "../models/Orders.php";
session_start();
$orderInterface = new Orders(DbConnection::getConnection());
if (isset($_POST['dest'])) {
switch ($_POST['dest']) {
case 'cancelOrder':
$orderInterface->setOrderStatus('canceled', $_POST['msg']);
break;
case 'getOrders':
$ordersRowSet = $orderInterface->getOrders("and status = 'proccessing' order by date,time");
$orders = array();
while ($order = $ordersRowSet->fetch_assoc()) {
array_push($orders, $order);
}
echo json_encode($orders);
break;
case 'getOrderDetails':
$ordersRowSet = $orderInterface->getOrderDetails($_POST['oId']);
$orders = array();
while ($order = $ordersRowSet->fetch_assoc()) {
array_push($orders, $order);
}
echo json_encode($orders);
break;
case 'deliver':
$orderInterface->setOrderStatus('Out for delivery', $_POST['oId']);
$dbConnection = DbConnection::getConnection();
$dbConnection->query("CREATE EVENT updateStatus" . $_POST['oId'] . "\n ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 MINUTE DO\n UPDATE orders SET status = 'Done' WHERE o_id = " . $_POST['oId'] . ";");
