<?php

include "../../root.class.php";
$db = new db_safeguard();

if($_SERVER['REQUEST_METHOD'] !== 'POST'){
    exit;
}

// $current_date_time = date("Y-m-d H:i", strtotime("+2 hours"));
$drilling_invoice = $_POST['jobcard_id'];
$install_team_id = 26;

$pump_install_res = $db->query("pump_installation","SELECT * FROM pump_installation");

$no_installs = 0;

if ($pump_install_res->num_rows < 0) {
  $no_installs = 1;

  $pump_install_id = "PI_" . $no_installs;
} else {
  $pump_install = $pump_install_res->fetch_assoc();
  $no_installs = $pump_install['record_id'] + 1;

  $pump_install_id = "PI_" . $no_installs;
}

// echo "INSERT INTO `pump_installation`(`jobcard_no`,`drilling_invoice`,`drilling_team_id`) VALUES ('{$pump_install_id}','{$drilling_invoice}','{$install_team_id}')";

$query = "INSERT INTO `pump_installation`(`jobcard_no`,`drilling_invoice`,`drilling_team_id`) VALUES ('{$pump_install_id}','{$drilling_invoice}','{$install_team_id}')";

$result = $db->query("pump_installation", $query);

if($result){
  echo "CREATED";
}else{
  echo "ERROR";
}