add_styles_page(); $db = new db_safeguard(); session_start(); // ── Fetch installation record ──────────────────────────────────────────────── $install_res = $db->query("pump_installation", "SELECT * FROM pump_installation WHERE record_id = '{$_GET['record_id']}'"); $install = $install_res->fetch_assoc(); // ── Fetch linked drilling jobcard ──────────────────────────────────────────── $jobcard_history = null; if (!empty($install['drilling_invoice'])) { $jc_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE jc_no = '{$install['drilling_invoice']}'"); $jobcard_history = $jc_res->fetch_assoc(); } // ── Fetch notes ─────────────────────────────────────────────────────────────── $notes_res = $db->query("notes", "SELECT * FROM notes WHERE jobcard_id = '{$_GET['jobcard_no']}' AND reason NOT LIKE '%BIT%' AND reason NOT LIKE '%INSTALL%' ORDER BY record_id ASC"); // ── Fetch replaced items ────────────────────────────────────────────────────── $replaced_res = $db->query("replaced_items", "SELECT * FROM replaced_items WHERE jobcard_no = '{$_GET['jobcard_no']}' ORDER BY record_id ASC"); // ── Fetch payments ──────────────────────────────────────────────────────────── $payments_res = $db->query("jobcard_payments", "SELECT * FROM jobcard_payments WHERE jobcard_id = '{$_GET['jobcard_no']}' ORDER BY record_id ASC"); // ── Fetch install images ────────────────────────────────────────────────────── $images_res = $db->query("notes", "SELECT * FROM notes WHERE jobcard_id = '{$_GET['jobcard_no']}' AND reason LIKE 'INSTALL IMAGE' ORDER BY record_id ASC"); // ── Signature paths (jc_no param matches install_actions.php convention) ───── $jc_no = $_GET['jobcard_no'] ?? $install['jobcard_no']; $sig_dir = __DIR__ . "/signatures/"; $sig_url = "/app/jobcards/pump/signatures/"; $emp_sig_file = $sig_dir . "employee-jc_{$jc_no}-{$_SESSION['user_id']}-signature.png"; $emp_sig_url = $sig_url . "employee-jc_{$jc_no}-{$_SESSION['user_id']}-signature.png"; $cli_sig_file = $sig_dir . "client-jc_{$jc_no}-{$_SESSION['user_id']}-signature.png"; $cli_sig_url = $sig_url . "client-jc_{$jc_no}-{$_SESSION['user_id']}-signature.png"; // ── Pump slip path ──────────────────────────────────────────────────────────── $slip_dir = __DIR__ . "/pump_slip/"; $slip_url = "/app/jobcards/pump/pump_slip/"; $slip_exists = !empty($install['pump_slip']) && file_exists($slip_dir . $install['pump_slip']); // ── Payment totals ──────────────────────────────────────────────────────────── $total_paid = 0; $payment_rows = []; if ($payments_res && $payments_res->num_rows > 0) { while ($p = $payments_res->fetch_assoc()) { $total_paid += (float)($p['amount'] ?? 0); $payment_rows[] = $p; } } // ── Total meters drilled from jobcard_timeline ─────────────────────────────── $total_meters = 0; if ($jobcard_history) { $drilling_tl = $db->query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = '{$jobcard_history['record_id']}'"); if ($drilling_tl && $drilling_tl->num_rows > 0) { $stop_types = ['DRILLING_STOP','DRILLING_PAUSE','RIEMING_STOP','RIEMING_PAUSE', 'BLASTING_STOP','BLASTING_PAUSE','CASING_STOP','CASING_PAUSE']; while ($tl = $drilling_tl->fetch_assoc()) { if (in_array($tl['type'], $stop_types)) { $total_meters += (int)($tl['meters'] ?? 0); } } } } ?> Install Summary — JC <?= htmlspecialchars($install['jobcard_no']) ?>
Pump Installation — Job Summary

JC

Installed By
Attended By
Date Attended
Finished
✓ Complete ● In Progress
← HOME
Borehole
Pump Depth
HDPE Pipe
Cable
Meters Drilled
Crack

Installation Details

Jobcard No
Drilling Invoice
Client Name
Area
Contact Number
Attended By
Installed By
Date Attended
Date Finished
Pack No
Pump No
GPS Co-ordinates
Status Complete In Progress
Problem Description
Solution
Pump Slip
Pump Slip

Drilling Jobcard History

DRILLING INVOICE:

Jobcard ID
Client Name
Address
Contact Number
Other Number
Alternate Number
Break Found On
Water Strike
Water Flow
Total Meters Drilled m

Notes

num_rows > 0): ?> fetch_assoc()): ?>
Reason Note Image Date / Time
note —
No notes recorded.

Site Images

num_rows > 0): ?>
fetch_assoc()): $img_file = $img['image'] ?? $img['image_name'] ?? $img['file_name'] ?? $img['filename'] ?? ''; ?>
<?= htmlspecialchars($img['note'] ?? '') ?>
No site images captured.

Payments

MethodAmountSlip / ProofDate
R slip —
TOTAL RECEIVED R
No payment records found.

Signatures

Employee Signature
Employee Signature No signature captured
Client Signature
Client Signature No signature captured

Terms & Disclaimer

Please Note: Savuki Drilling Mpumalanga
  1. Cannot be held responsible for any damage or borehole collapse.
  2. Steel casings must be installed on the recommendation of the drill team.
  3. Will not be held liable for any damage on property.
  4. No water is guaranteed even if Savuki Drilling surveyed.
  5. Client pays for service of drilling, not water.
SAFETY PRECAUTION —
CUSTOMER IS RESPONSIBLE FOR COVERING OF BOREHOLE AFTER DRILLING.
SAVUKI DRILLING MPUMALANGA WILL NOT BE LIABLE FOR ANY ACCIDENTS CAUSED BY ANY UNCOVERED BOREHOLES.