prepare($countQuery);
$stmt->execute($params);
$totalDrugs = $stmt->fetchColumn();
$totalPages = ceil($totalDrugs / $limit);
// Fetch drugs with pagination
$query = "
SELECT d.*, g.name_$lang as group_name, s.name_$lang as supplier_name
FROM drugs d
LEFT JOIN drugs_groups g ON d.group_id = g.id
LEFT JOIN suppliers s ON d.supplier_id = s.id
$where
ORDER BY d.id DESC
LIMIT $limit OFFSET $offset";
$stmt = $db->prepare($query);
$stmt->execute($params);
$drugs = $stmt->fetchAll();
// Fetch all groups for filter dropdown
$gStmt = $db->query("SELECT * FROM drugs_groups ORDER BY name_$lang");
$all_drug_groups = $gStmt->fetchAll();
// Fetch all suppliers
$sStmt = $db->query("SELECT * FROM suppliers ORDER BY name_$lang");
$all_suppliers = $sStmt->fetchAll();
$sys_settings = get_system_settings();
$currency_symbol = $sys_settings['currency_symbol'] ?? '$';
// --- AJAX HANDLER ---
if (isset($_GET['ajax_search'])) {
ob_start();
if (empty($drugs)):
?>