exec_query('users', ["*"], '', '', '', '', "user_type = 'MANAGER'", "ORDER BY username ASC"); $users_list = ''; while ($users = $user_type_res->fetch_assoc()) { $users_list = $users_list . ""; } $whereFarm = ($_SESSION['record_id'] == 0) ? "1" : "record_id = {$_SESSION['record_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.record_id = C.record_id WHERE $whereFarm ORDER BY farm_name ASC, fleet_no ASC, asset_type_name ASC"; $farms_res = $db->exec_query('farms', ["*"], '', '', '', '', $whereFarm); $farm_list = ''; while ($farms = $farms_res->fetch_assoc()) { $farm_list = $farm_list . ""; } $type_res = $db->exec_query('farming_types', ["*"]); $type_list = ''; while ($typs = $type_res->fetch_assoc()) { $type_list = $type_list . ""; } $name_res = $db->exec_query('farming_action', ["*"]); $name_list = ''; while ($names = $name_res->fetch_assoc()) { $name_list = $name_list . ""; } $group_res = $db->exec_query('asset_types', ["*"]); $groups = ''; while ($group = $group_res->fetch_assoc()) { $groups = $groups . ""; } $html = new html("ERRAND REPORTS"); ?>

FILTER: