<?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}')")) {
        $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']) || isset($_GET['oil']) || isset($_GET['cons'])){
    $update_column[] = 'parts';
    $update_value[] = $_GET['parts'] . "|".$_GET['oil']. "|".$_GET['cons'];

}


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;
}