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

$db = new db();

$asset_id = $_GET["asset_id"];
$odo = $_GET["odo"];
$asset_type_id = $_GET["asset_type_id"];
$qr_code = $_GET["qr_code"];
$farm_id = $_GET["farm_id"];
$exp_date = $_GET["exp_date"];
$vin = $_GET["vin"];
$fuel = $_GET["fuel"];
$description = $_GET["description"];
$fleet_id = $_GET["fleet_id"];
$date = date("Y-m-d H:i", strtotime("+ 2hours"));


// $date = date('Y-m-d H:i');s

$res = $db->insert("INSERT INTO assets (`asset_type_id`, `asset_id`,`status`,`qr_code`,`farm_id`,`license_exp_date`,`vin`,`fuel_size`,`fleet_no`,`description`) VALUES ('$asset_type_id','$asset_id','ACTIVE','$qr_code','$farm_id','$exp_date','$vin','$fuel','$fleet_id','$description')");


if ($res) {
    $last_asset_res = $db->exec_query('assets', ['*'], '', '', '', '', "1", "ORDER BY record_id DESC");
    $asset_record = $last_asset_res->fetch_assoc();
    $db->insert("INSERT INTO asset_odo (`asset_record_id`,`odo`,`date`) VALUES ('{$asset_record['record_id']}','$odo','$date')");
    echo 1;
} else {
    echo 0;
}