<?php
// ─── GET /api/pumps/jobcard-list.php ─────────────────────────────────────
// Returns pump_installation and pump_repair rows in a unified format
// for use in the invoice creation jobcard rich select.
define('ROOT', dirname(__DIR__, 2));
require_once ROOT . '/core/DB.php';
require_once ROOT . '/core/Response.php';
require_once ROOT . '/core/Auth.php';

Auth::require();
$db = DB::get();

$installs = $db->rows(
    "SELECT record_id, jobcard_no, client_name,
            area AS address, contact_number, jc_current_status,
            'install' AS pump_type
     FROM   pump_installation
     ORDER BY record_id DESC"
);

$repairs = $db->rows(
    "SELECT record_id, jobcard_no, address AS client_name,
            address, contact_number, jc_current_status,
            'repair' AS pump_type
     FROM   pump_repair
     ORDER BY record_id DESC"
);

Response::ok([
    'installs' => $installs,
    'repairs'  => $repairs,
]);