exec_query('users', ["*"], '', '', '', '', "user_type = 'MECHANIC'", "ORDER BY username ASC"); $users_list = ''; while ($users = $user_type_res->fetch_assoc()) { $users_list = $users_list . ""; } $asset_res = $db->exec_query('assets', ["*"]); $whereFarm = ($_SESSION['farm_id'] == 0)? "1":"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 . ""; } if($currentType != $prevType){ $asset_list = $asset_list . " "; continue; } if($currentType != $nextType){ $asset_list = $asset_list . " "; continue; } if($currentFarm != $nextFarm){ $asset_list = $asset_list . ""; } $asset_list = $asset_list . ""; } $farms_res = $db->exec_query('farms', ["*"], '', '', '', '', $whereFarm); $farm_list = ''; while ($farms = $farms_res->fetch_assoc()) { $farm_list = $farm_list . ""; } $group_res = $db->exec_query('asset_types', ["*"]); $groups = ''; while ($group = $group_res->fetch_assoc()) { $groups = $groups . ""; } $html = new html("ASSET REPORTS"); ?>

FILTER: