add_styles_page(); $functions = new functions(); $db = new db_safeguard(); $where_data[] = "company_id = {$_SESSION['company_id']}"; if (strlen($_POST['date_from']) > 5 && strlen($_POST['date_to']) > 5) { $where_data[] = " 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[] = " client_id = {$_POST['client_id']}"; } if (isset($_POST['user_id']) && $_POST['user_id'] != "") { $where_data[] = " user_id = {$_POST['user_id']}"; } if (isset($_POST['tank_id']) && $_POST['tank_id'] != "") { $where_data[] = " tank_id = {$_POST['tank_id']}"; } if (isset($_POST['cash_type']) && $_POST['cash_type'] != "") { $where_data[] = " cash_type = {$_POST['cash_type']}"; } $data = implode(" AND ", $where_data); // echo $data; $latest_orders_res = $db->query("fuel_movement", "SELECT * FROM fuel_movement WHERE $data ORDER BY date_time_closed DESC"); ?>
fetch_assoc()) { ?>
TANK DATE CLIENT AMOUNT (mL) VALUE (R) R/L USER STATUS TYPE
' class="inputs"> ' class="inputs" onchange="change(this,'date_time_closed','')"> ' class="inputs" onchange="change(this,'amount','')"> ' class="inputs"> ' class="inputs" onchange="change(this,'fuel_price','')"> ' onchange="change(this,'status','')" class="inputs">