<?php include "../../root.class.php";
$html = new html();
$html->add_styles_page();
// $html->check_user_type("ADMIN");
$db = new db_safeguard();

//get the current date and time
$current_date_time = date("Y-m-d H:i", strtotime("+2 hours"));

//get the seeion user id
$user_id = $_SESSION['user_id'];

$check_jobcard_id = $_GET['jc_no'];

if (strpos($check_jobcard_id, "PR") !== false) {
    // echo "Contains PR";
    $jobcards = $db->query("pump_repair", "SELECT * FROM pump_repair WHERE jobcard_no = {$_GET['jc_no']}");
    echo "SELECT * FROM pump_repair WHERE jobcard_no = {$_GET['jc_no']}";

} else if (strpos($check_jobcard_id, "PI") !== false) {

    $jobcards = $db->query("pump_installation", "SELECT * FROM pump_installation WHERE jobcard_no = {$_GET['jc_no']}");
    echo "SELECT * FROM pump_installation WHERE jobcard_no = {$_GET['jc_no']}";
}else {
  exit();
}