exec_query('assets', ["*"]);
$whereFarm_farm = ($_SESSION['farm_id'] == 9) ? "record_id = {$_SESSION['farm_id']} OR record_id = 10" : "record_id = {$_SESSION['farm_id']}";
$whereFarm_farm = ($_SESSION['farm_id'] == 9) ? "record_id = {$_SESSION['farm_id']} OR record_id = 10" : "record_id = {$_SESSION['farm_id']}";
if ($_SESSION['farm_id'] == 0) {
$whereFarm = "1";
} else {
$whereFarm = ($_SESSION['farm_id'] == 9) ? "farm_id = {$_SESSION['farm_id']} OR farm_id = 10" : "farm_id = {$_SESSION['farm_id']}";
}
$sqlQueryAssets = "SELECT A.*,B.asset_type_name,C.farm_name FROM assets A
LEFT JOIN asset_types B ON A.asset_type_id = B.record_id
LEFT JOIN farms C ON A.farm_id = C.record_id
WHERE $whereFarm ORDER BY farm_name ASC, fleet_no ASC, asset_type_name ASC";
$asset_res = $db->query($sqlQueryAssets);
$asset_list = '';
$assetsArr = $asset_res->fetch_all(MYSQLI_ASSOC);
foreach ($assetsArr as $index => $asset) {
$currentFarm = $asset['farm_name'];
$nextFarm = $assetsArr[$index + 1]['farm_name'];
$prevFarm = $assetsArr[$index - 1]['farm_name'];
$currentType = $asset['asset_type_name'];
$nextType = $assetsArr[$index + 1]['asset_type_name'];
$prevType = $assetsArr[$index - 1 ?? 0]['asset_type_name'];
if ($currentFarm != $prevFarm) {
$asset_list = $asset_list . "";
}
$asset_list = $asset_list . "";
}
if ($_SESSION['farm_id'] == 0) {
$farms_res = $db->exec_query('farms', ["*"]);
$farm_list = '';
} else {
$farms_res = $db->exec_query('farms', ["*"], '', '', '', '', $whereFarm_farm);
$farm_list = '';
}
$html = new html("DIESEL REPORTS");
$farm_list_responce = $html->http_get_curl("api.elegantwork.co.za/fuel/inter_site_com.php", ['get_sites'], ['']);
$farm_list_responce = explode("|", $farm_list_responce);
foreach ($farm_list_responce as $site) {
$data_sites = explode(",", $site);
$farm_list = $farm_list . "";
}
?>