prepare("SELECT company_name FROM vendor_master WHERE id = ?"); $stmts->bind_param("i", $company_id); $stmts->execute(); $stmts->bind_result($company_name); $stmts->fetch(); $stmts->close(); // 3) Lookup vehicle_no $stmtt = $conn->prepare("SELECT vehicle_no FROM vehicle_master WHERE id = ?"); $stmtt->bind_param("i", $vehicle_id); $stmtt->execute(); $stmtt->bind_result($vehicle_no); $stmtt->fetch(); $stmtt->close(); // 4) Lookup driver_name $stmtp = $conn->prepare("SELECT driver_name FROM driver_master WHERE id = ?"); $stmtp->bind_param("i", $driver_id); $stmtp->execute(); $stmtp->bind_result($driver_name); $stmtp->fetch(); $stmtp->close(); // 5) Calculate duration between reporting and unloading $dtReport = new DateTime($reporting); $dtUnload = new DateTime($unloading); $interval = $dtReport->diff($dtUnload); $total_duration = $interval->format('%a days, %h hours, %i minutes'); $created_at = date("Y-m-d H:i:s"); // 6) Insert into reports $stmt = $conn->prepare(" INSERT INTO reports ( form_date, company_name, item_name, value, loading_expenses, office_expenses, total_cost, vehicle_no, vehicle_capacity, vehicle_insurance_validy, total_fair, advance_fair, demorage, balance_payable, broker, driver_name, mobile_no, reporting, sold_to, sold_value, unloading_expenses, road_expenses, parking_charge, del_total_cost, unloading, total_duration, created_at ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "); $stmt->bind_param( "sssssssssssssssssssssssssss", $form_date, $company_name, $item_name, $value, $loading_expenses, $office_expenses, $total_cost, $vehicle_no, $vehicle_capacity, $vehicle_insurance_validy, $total_fair, $advance_fair, $demorage, $balance_payable, $broker, $driver_name, $mobile_no, $reporting, $sold_to, $sold_value, $unloading_expenses, $road_expenses, $parking_charge, $del_total_cost, $unloading, $total_duration, $created_at ); if ($stmt->execute()) { echo ""; } else { error_log("MySQL Error: " . $stmt->error); echo ""; } $stmt->close(); } require_once('includes/header.php'); ?>
Purchase
Transporter
Seller
Cancel