5 && strlen($_POST['date_to']) > 5) { $dates = " fm.date_time_opened BETWEEN '{$_POST['date_from']} 00:00' AND '{$_POST['date_to']} 23:59'"; } if (isset($_POST['client_id']) && $_POST['client_id'] != "") { $where_data[] = " fm.client_id = {$_POST['client_id']}"; $other_side[] = " fm.client_id = {$_POST['client_id']}"; } if (isset($_POST['user_id']) && $_POST['user_id'] != "") { $where_data[] = " fm.user_id = {$_POST['user_id']}"; $other_side[] = " fm.user_id = {$_POST['user_id']}"; } if (isset($_POST['tank_id']) && $_POST['tank_id'] != "") { $where_data[] = " fm.tank_id = {$_POST['tank_id']}"; $other_side[] = " fm.tank_id = {$_POST['tank_id']}"; } if (isset($_POST['cash_type']) && $_POST['cash_type'] != "") { $where_data[] = " fm.cash_type = {$_POST['cash_type']}"; } if (isset($_POST['exclude_from_reports']) && $_POST['exclude_from_reports'] != "") { $where_data[] = " (c.company_id = {$_SESSION['company_id']} AND (c.exclude_from_reports = {$_POST['exclude_from_reports']}))"; } else { $where_data[] = " (c.company_id = {$_SESSION['company_id']} AND (c.exclude_from_reports = 0))"; } if (isset($_POST['site_id']) && $_POST['site_id'] != "") { $where_data[] = " fm.tank_id in (SELECT record_id FROM tanks WHERE company_id = {$_SESSION['company_id']} AND site_id = {$_POST['site_id']})"; $other_side[] = " fm.tank_id in (SELECT record_id FROM tanks WHERE company_id = {$_SESSION['company_id']} AND site_id = {$_POST['site_id']})"; } $data = implode(" AND ", $where_data); $other_data = implode(" AND ", $other_side); // echo $data; $latest_orders_res = $db->query("fuel_movement", "SELECT * FROM fuel_movement as fm LEFT JOIN clients as c ON c.record_id = fm.client_id WHERE ($data AND $dates ) OR (fm.client_id = 0 AND fm.status = 'MANUAL OVERRIDE' AND $dates AND $other_data) ORDER BY date_time_closed DESC"); $sql = str_replace("'", "\'", "SELECT * FROM fuel_movement as fm LEFT JOIN clients as c ON c.record_id = fm.client_id WHERE ($data AND $dates ) OR (fm.client_id = 0 AND fm.status = 'MANUAL OVERRIDE' AND $dates AND $other_data) ORDER BY date_time_closed DESC"); ?>

fetch_assoc()) { ?>
TANK DATE CLIENT AMOUNT (mL) VALUE (R) R/L STATUS TYPE
'> ' onchange="change(this,'date_time_closed','')"> ' onchange="change(this,'amount','')"> '> ' onchange="change(this,'fuel_price','')"> ' onchange="change(this,'status','')">