Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): Failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found
in /home/monara/public_html/test.athavaneng.com/themes.php on line 99
Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 226
Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 227
Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 228
Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 229
Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 230
Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 231
prepare("INSERT INTO inventory_daily_capacity (rate_card_id, capacity_qty) VALUES (?, ?) ON DUPLICATE KEY UPDATE capacity_qty = ?");
if ($stmt->execute([$rate_card_id, $new_capacity, $new_capacity])) {
header("Location: inventory.php?status=success");
exit();
} else {
die("Database update failed.");
}
}
// 2. Handle AJAX Edit
if (isset($_GET['action']) && $_GET['action'] === 'ajax_edit') {
header('Content-Type: application/json');
$rate_card_id = (int)$_POST['rate_card_id']; // Changed to rate_card_id
$qty = (int)$_POST['qty'];
// Update the global capacity for this rate card
$stmt = $pdo->prepare("INSERT INTO inventory_daily_capacity (rate_card_id, capacity_qty) VALUES (?, ?) ON DUPLICATE KEY UPDATE capacity_qty = ?");
if ($stmt->execute([$rate_card_id, $qty, $qty])) {
echo json_encode(['status' => 'success']);
} else {
echo json_encode(['status' => 'error']);
}
exit();
}
// 2. Fetch Base Inventory
$allocations = $pdo->query("
SELECT idc.*, c.name as item_name, p.platform_name, a.placement_name, f.format_name,
(SELECT COALESCE(SUM(s.quantity), 0)
FROM schedule_items s
WHERE s.rate_card_id = idc.rate_card_id
AND s.scheduled_date = CURDATE()) as today_used,
(idc.capacity_qty - (SELECT COALESCE(SUM(s.quantity), 0)
FROM schedule_items s
WHERE s.rate_card_id = idc.rate_card_id
AND s.scheduled_date = CURDATE())) as remaining_today
FROM inventory_daily_capacity idc
JOIN rate_cards r ON idc.rate_card_id = r.id
JOIN content_items c ON r.content_item_id = c.id
JOIN platforms p ON r.platform_id = p.id
JOIN ad_placements a ON r.placement_id = a.id
JOIN media_formats f ON r.media_format_id = f.id
")->fetchAll();
$inventory_items = $pdo->query("
SELECT r.id as rate_card_id,
c.name as item_name,
p.platform_name,
a.placement_name,
f.format_name
FROM rate_cards r
JOIN content_items c ON r.content_item_id = c.id
JOIN platforms p ON r.platform_id = p.id
JOIN ad_placements a ON r.placement_id = a.id
JOIN media_formats f ON r.media_format_id = f.id
")->fetchAll();
include '../includes/header.php';
?>