| Server IP : 173.209.174.21 / Your IP : 216.73.216.89 Web Server : Apache/2.4.58 (Ubuntu) System : Linux wcfs-server 6.8.0-124-generic #124-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 13:00:45 UTC 2026 x86_64 User : nodor ( 1000) PHP Version : 8.3.6 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/wcfs/NAOPOS/api/ |
Upload File : |
<?php
declare(strict_types=1);
require __DIR__ . '/db.php';
require __DIR__ . '/helpers.php';
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
json_response(['error' => 'Method not allowed'], 405);
}
$payload = read_json_body();
$businessDate = require_business_date($payload['businessDate'] ?? null);
$pdo = db();
$pdo->beginTransaction();
try {
$deleteItems = $pdo->prepare(
'DELETE i
FROM sale_items i
INNER JOIN sales s ON s.id = i.sale_id
WHERE s.business_date = :business_date'
);
$deleteItems->execute(['business_date' => $businessDate]);
$deleteSales = $pdo->prepare(
'DELETE FROM sales WHERE business_date = :business_date'
);
$deleteSales->execute(['business_date' => $businessDate]);
$pdo->commit();
json_response(['ok' => true]);
} catch (Throwable $error) {
$pdo->rollBack();
json_response(['error' => $error->getMessage()], 500);
}