prepare($sql); $stmt->execute([ ':bunk_id' => $bunk_id, ':supplier' => $supplier, ':invoice_number' => $invoice_number, ':fuel_type_id' => $fuel_type_id, ':quantity' => $quantity, ':rate' => $rate, ':amount' => $amount, ':date' => $date ]); $success_message = "Fuel receipt recorded successfully!"; } catch (PDOException $e) { $error_message = "Error recording receipt: " . $e->getMessage(); } } else { $error_message = "Bunk, fuel type, quantity, rate, and date are required."; } } // Fetch master data for dropdowns try { $bunks_stmt = $pdoconn->query("SELECT id, name FROM bunks ORDER BY name"); $bunks = $bunks_stmt->fetchAll(PDO::FETCH_ASSOC); $fuel_types_stmt = $pdoconn->query("SELECT id, name FROM fuel_types ORDER BY name"); $fuel_types = $fuel_types_stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { $bunks = []; $fuel_types = []; $page_error = "Error fetching master data: " . $e->getMessage(); } // Fetch recent fuel receipts try { $receipts_stmt = $pdoconn->query(" SELECT fr.*, b.name as bunk_name, ft.name as fuel_type_name FROM fuel_receipts fr JOIN bunks b ON fr.bunk_id = b.id JOIN fuel_types ft ON fr.fuel_type_id = ft.id ORDER BY fr.date DESC, fr.id DESC LIMIT 20 "); $receipts = $receipts_stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { $receipts = []; $page_error = "Error fetching receipts: " . $e->getMessage(); } ?>

Record Fuel Receipt

New Receipt Entry

Date

Bunk

Supplier (e.g., IOCL)

Invoice Number

Fuel Type

Quantity (Ltr)

Rate

Recent Fuel Receipts

Date	Bunk	Supplier	Invoice #	Fuel	Qty	Rate	Amount
No fuel receipts recorded yet.