query("leads", "UPDATE `leads` SET `STATUS` = '{$_POST['status']}', `additional_notes` = '{$_POST['additional_notes']}' WHERE `jc_no` = '$_POST[jc_no]'"); // echo "INSERT INTO `fuel_movement`(`tank_id`, `amount`, `status`, `date_time_opened`, `date_time_closed`, `user_id`, `odo`, `asset_id`, `flow_rate`, `pulses`, `sent_email`) VALUES ('[value-1]','[value-2]','[value-3]','[value-4]','[value-5]','[value-6]','[value-7]','[value-8]','[value-9]','[value-10]','[value-11]','[value-12]')"; // echo "INSERT INTO `fuel_movement`(`tank_id`, `amount`, `status`, `date_time_opened`, `date_time_closed`, `user_id`, `odo`, `asset_id`, `flow_rate`, `pulses`) VALUES ('3','AMOUNT','MANUAL OVERRIDE','2025-11-04 start','2025-11-04 closed','8','odo','1_01','0.00','0')"; // echo "record_id = 230, asset_id = B3-106, fleet_id = B3-106, odo = 110716"; // echo "INSERT INTO `fuel_movement`(`tank_id`, `amount`, `status`, `date_time_opened`, `date_time_closed`, `user_id`, `odo`, `asset_id`, `flow_rate`, `pulses`) VALUES ('3','48','MANUAL OVERRIDE','2025-11-04 14:29','2025-11-04 14:29','8','1107.16','1_230','34.00','0')"; // echo "record_id = 228, asset_id = B3-104, fleet_id = B3-104, odo = 110764"; // echo "INSERT INTO `fuel_movement`(`tank_id`, `amount`, `status`, `date_time_opened`, `date_time_closed`, `user_id`, `asset_id`, `flow_rate`, `pulses`) VALUES ('3','48','MANUAL OVERRIDE','2025-11-04 14:32','2025-11-04 14:32','8','1_228','34.00','0')"; // echo "record_id = 117, asset_id = B3-201, fleet_id = B3-201, odo = 110885"; // echo "INSERT INTO `fuel_movement`(`tank_id`, `amount`, `status`, `date_time_opened`, `date_time_closed`, `user_id`, `asset_id`, `flow_rate`, `pulses`) VALUES ('3','121','MANUAL OVERRIDE','2025-11-04 14:35','2025-11-04 14:35','8','1_117','34.00','0')"; // echo "record_id = 116, asset_id = B3-103, fleet_id = B3-103, odo = 110945"; // echo "INSERT INTO `fuel_movement`(`tank_id`, `amount`, `status`, `date_time_opened`, `date_time_closed`, `user_id`, `asset_id`, `flow_rate`, `pulses`) VALUES ('3','60','MANUAL OVERRIDE','2025-11-04 14:40','2025-11-04 14:40','8','1_116','34.00','0')"; // echo "record_id = 229, asset_id = B3-105, fleet_id = B3-105, odo = 110983"; // echo "INSERT INTO `fuel_movement`(`tank_id`, `amount`, `status`, `date_time_opened`, `date_time_closed`, `user_id`, `asset_id`, `flow_rate`, `pulses`) VALUES ('3','38','MANUAL OVERRIDE','2025-11-04 14:44','2025-11-04 14:44','8','1_229','34.00','0')"; // echo "record_id = 231, asset_id = B3-107, fleet_id = B3-107, odo = 111033"; // echo "INSERT INTO `fuel_movement`(`tank_id`, `amount`, `status`, `date_time_opened`, `date_time_closed`, `user_id`, `asset_id`, `flow_rate`, `pulses`) VALUES ('3','50','MANUAL OVERRIDE','2025-11-04 14:47','2025-11-04 14:47','8','1_231','34.00','0')"; // echo "record_id = 132, asset_id = B4-102, fleet_id = B4-102, odo = 111141"; // echo "INSERT INTO `fuel_movement`(`tank_id`, `amount`, `status`, `date_time_opened`, `date_time_closed`, `user_id`, `asset_id`, `flow_rate`, `pulses`) VALUES ('3','108','MANUAL OVERRIDE','2025-11-04 14:50','2025-11-04 14:50','8','1_132','34.00','0')"; // echo "record_id = 115, asset_id = B3-102, fleet_id = B3-102, odo = 111196"; // echo "INSERT INTO `fuel_movement`(`tank_id`, `amount`, `status`, `date_time_opened`, `date_time_closed`, `user_id`, `asset_id`, `flow_rate`, `pulses`) VALUES ('3','55','MANUAL OVERRIDE','2025-11-04 14:55','2025-11-04 14:55','8','1_115','34.00','0')"; // echo "record_id = 114, asset_id = B3-101, fleet_id = B3-101, odo = 111253"; // echo "INSERT INTO `fuel_movement`(`tank_id`, `amount`, `status`, `date_time_opened`, `date_time_closed`, `user_id`, `asset_id`, `flow_rate`, `pulses`) VALUES ('3','57','MANUAL OVERRIDE','2025-11-04 14:58','2025-11-04 14:58','8','1_114','34.00','0')"; // echo "record_id = 228, asset_id = B3-104, fleet_id = B3-104, odo = 111322"; // echo "INSERT INTO `fuel_movement`(`tank_id`, `amount`, `status`, `date_time_opened`, `date_time_closed`, `user_id`, `asset_id`, `flow_rate`, `pulses`) VALUES ('3','69','MANUAL OVERRIDE','2025-11-05 14:53','2025-11-05 14:53','8','1_228','34.00','0')";