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 . ""; } $ajobcard_res = $db->exec_query('jobcard_types', ["*"]); $jobcard_list = ''; while ($type = $ajobcard_res->fetch_assoc()) { $jobcard_list = $jobcard_list . ""; } $html = new html("new job card"); ?>

scanner('qr_code', 'call_qr_search'); ?>

NEW JOB CARD: