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

$db = new db();

if (isset($_GET['asset_record_id'])) {

    $res = $db->exec_query('assets', ['*'], '', '', '', '', "record_id = {$_GET['asset_record_id']}");
    $res_ass = $db->exec_query('asset_odo', ['*'], '', '', '', '', "asset_record_id = {$_GET['asset_record_id']}", "ORDER BY record_id DESC");
    $user = $res->fetch_assoc();
    $asset = $res_ass->fetch_assoc();

    echo $user['asset_id'] . ',' . $asset['odo'] . ',' . $user['asset_type_id'] . "," . $user['status'] . "," . $user['qr_code'] . "," . $user['farm_id'] . "," . $user['license_exp_date'] . "," . $user['fleet_no'] . "," . $user['description'] . ',' . $user['vin'] . ',' . $user['fuel_size'];
} else {
    
    $res = $db->exec_query('assets', ['*'], '', '', '', '', "qr_code LIKE '{$_GET['qr_code']}'");
    $user = $res->fetch_assoc();
    if ($res->num_rows < 1) {
        echo 0;
    } else {

        $res_ass = $db->exec_query('asset_odo', ['*'], '', '', '', '', "asset_record_id = {$user['record_id']}", "ORDER BY record_id DESC");
        $asset = $res_ass->fetch_assoc();

        echo $user['asset_id'] . ',' . $asset['odo'] . ',' . $user['asset_type_id'] . "," . $user['status'] . "," . $user['qr_code'] . "," . $user['farm_id'] . "," . $user['license_exp_date'] . "," . $user['fleet_no'] . "," . $user['description'] . ',' . $user['record_id'] . ',' . $user['vin'] . ',' . $user['fuel_size'];
    }
}