add_styles_page();
$db = new db_safeguard();
/*
Optimized JOIN Query
Instead of running 3 queries inside a loop,
we join pump_repair → pump_installation → jobcards
*/
$query = "
SELECT
pr.*,
pi.drilling_invoice,
jc.contact_number,
jc.address
FROM pump_repair pr
LEFT JOIN pump_installation pi
ON pr.installation_id = pi.record_id
LEFT JOIN jobcards jc
ON jc.jc_no = pi.drilling_invoice
WHERE pr.status = '0'
";
$pump_jobcards_res = $db->query("pump_repair", $query);
?>