add_styles_page(); $db = new db_safeguard(); session_start(); // ── Fetch repair record ────────────────────────────────────────────────────── $repair_res = $db->query("pump_repair", "SELECT * FROM pump_repair WHERE record_id = '{$_GET['record_id']}'"); $repair = $repair_res->fetch_assoc(); // ── Fetch linked installation record ──────────────────────────────────────── $install = null; $jobcard_history = null; if (!empty($repair['installation_id'])) { $inst_res = $db->query("pump_installation", "SELECT * FROM pump_installation WHERE record_id = '{$repair['installation_id']}'"); $install = $inst_res->fetch_assoc(); if ($install && !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 replaced items ───────────────────────────────────────────────────── $replaced_res = $db->query("replaced_items", "SELECT * FROM replaced_items WHERE jobcard_no = '{$repair['jobcard_no']}' ORDER BY record_id ASC"); // ── Fetch notes ─────────────────────────────────────────────────────────────── $notes_res = $db->query("notes", "SELECT * FROM notes WHERE jobcard_id = '{$repair['jobcard_no']}' AND reason NOT LIKE '%BIT%' AND reason NOT LIKE '%INSTALL%' ORDER BY record_id ASC"); // ── Fetch payments ──────────────────────────────────────────────────────────── $payments_res = $db->query("jobcard_payments", "SELECT * FROM jobcard_payments WHERE jobcard_id = '{$repair['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 ─────────────────────────────────────────────────────────── $sig_dir = __DIR__ . "/signatures/"; $sig_url = "/app/jobcards/pump/signatures/"; $emp_sig_file = $sig_dir . "employee-jc_{$repair['jobcard_no']}-{$_SESSION['user_id']}-signature.png"; $emp_sig_url = $sig_url . "employee-jc_{$repair['jobcard_no']}-{$_SESSION['user_id']}-signature.png"; $cli_sig_file = $sig_dir . "client-jc_{$repair['jobcard_no']}-{$_SESSION['user_id']}-signature.png"; $cli_sig_url = $sig_url . "client-jc_{$repair['jobcard_no']}-{$_SESSION['user_id']}-signature.png"; // ── Pump slip path ──────────────────────────────────────────────────────────── $slip_url = "/app/jobcards/pump/pump_slip/" . ($repair['pump_slip'] ?? ''); $slip_exists = !empty($repair['pump_slip']) && file_exists(__DIR__ . "/pump_slip/" . $repair['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']; $payment_rows[] = $p; } } ?> Job Summary — JC <?= htmlspecialchars($repair['jobcard_no']) ?>
Pump Repair — Job Summary

JC

Record ID #
Repaired By
Started
Finished
✓ Complete ● In Progress
← HOME

Repair Details

Jobcard No
Repaired By
Client Type
Contact Number
Address
GPS Co-ordinates
Date / Time Started
Date / Time Finished
Status Complete In Progress
Problem Description
Solution
Pump Slip
Pump Slip

Installation History

DRILLING INVOICE:

Client Name
Address
Contact Number
Other Number
Alternate Number
Break Found On
Water Strike
Water Flow
Attended By
Borehole Meters
HDPE Meters
Cable Meters
Pump Depth
Meters Drilled
Crack
Pack No
Pump No

Replaced Items

num_rows > 0): ?> fetch_assoc()): ?>
# Item Date Added
No replaced items recorded.

Notes

num_rows > 0): ?> fetch_assoc()): ?>
Reason Note Image Date / Time
note image —
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

Method Amount Slip / Proof Date
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.