<?php
include "../classes/db.class.php";
session_start();

$db = new db();

$update_column = [];
$update_value = [];
$date = date("Y-m-d H:i", strtotime("+ 2hours"));


if (isset($_GET['odo'])) {
    if ($db->Insert("INSERT INTO asset_odo (`odo`,`asset_record_id`,`date`) VALUES ('{$_GET['odo']}','{$_GET['asset_record_id']}','{$date}')")) {
        // echo "INSERT INTO asset_odo (`odo`,`asset_record_id`,`date`) VALUES ('{$_GET['odo']}','{$_GET['asset_record_id']}','{$date}')";
        // $db->Update('job_cards',['odo'],['{$_GET['odo']}']);
        echo 1;
        $update_column[] = 'odo';
        $update_value[] = $_GET['odo'];
    } else {
        echo "INSERT INTO asset_odo (`odo`,`asset_record_id`,`date`) VALUES ('{$_GET['odo']}','{$_GET['asset_record_id']}','{$date}')";
    }
}

if(isset($_GET['parts'])){
    $update_column[] = 'parts';
    $update_value[] = $_GET['parts'];
}


if(isset($_GET['notes'])){
    $update_column[] = 'notes';
    $update_value[] = $_GET['notes'];
}


$res = $db->Update('job_cards', $update_column, $update_value, "record_id = {$_GET['jobcard_no']}");

if ($res) {
    echo 1;
} else {
    echo 0;
}