prepare($count_query); $stmt->execute($params); $total_records = $stmt->fetchColumn(); $total_pages = ceil($total_records / $limit); $query .= " ORDER BY xi.inquiry_date DESC LIMIT $limit OFFSET $offset"; $stmt = $db->prepare($query); $stmt->execute($params); $inquiries = $stmt->fetchAll(); // Fetch items for each inquiry foreach ($inquiries as &$inquiry) { $stmt = $db->prepare(" SELECT it.*, t.name_$lang as xray_name FROM xray_inquiry_items it JOIN xray_tests t ON it.xray_id = t.id WHERE it.inquiry_id = ?"); $stmt->execute([$inquiry['id']]); $inquiry['items'] = $stmt->fetchAll(); } unset($inquiry); $all_xrays_list = $db->query("SELECT id, name_$lang as name, price FROM xray_tests ORDER BY name_$lang ASC")->fetchAll(); ?>

#
No inquiries found.
	Linked to Visit # ()				: basename($item['attachment']), 'path' => $item['attachment']]]; } elseif (!is_array($atts)) { $atts = []; } ?>

1): ?>