exec_query('users', ["*"], '', '', '', '', "user_type = 'MECHANIC'", "ORDER BY username ASC"); $users_list = ''; while ($users = $user_type_res->fetch_assoc()) { $users_list = $users_list . ""; } if ($_SESSION['farm_id'] == 0) { $farms_res = $db->exec_query('farms', ["*"]); $asset_type_res = $db->exec_query('assets', ["*"]); $asset_type_list = ''; while ($asset_type = $asset_type_res->fetch_assoc()) { $asset_type_list = $asset_type_list . ""; } } else { $farms_res = $db->exec_query('farms', ["*"], '', '', '', '', "record_id = {$_SESSION['farm_id']}"); $asset_type_res = $db->exec_query('assets', ["*"], '', '', '', "farm_id = {$_SESSION['farm_id']}"); $asset_type_list = ''; while ($asset_type = $asset_type_res->fetch_assoc()) { $asset_type_list = $asset_type_list . ""; } } $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: