-- For FASTAg Eod Report
INSERT INTO sps_eod_report_select (`eod_report_name`, `status`, `area_id`, `location_id`, `eod_reportvise_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES ('fastag_summary_report', 1, 1, 1, 15.1, 1, 0, '2022-12-20 07:44:15', '2022-12-20 07:44:15', NULL);


-- EOD Transaction Cancellation Detail
UPDATE `sps_eod_report_select` SET `eod_report_name` = 'transaction_cancellation_detailed', `status` = 1, `area_id` = 1, `location_id` = 1, `eod_reportvise_id` = 18, `created_by` = 1, `updated_by` = 0, `created_at` = '2017-11-01 16:11:28', `updated_at` = '2023-09-04 12:33:07', `deleted_at` = NULL WHERE `eod_report_name` = 'transaction_cancellation';

-- EOD Transaction Cancellation Summary
INSERT INTO sps_eod_report_select (`eod_report_name`, `status`, `area_id`, `location_id`, `eod_reportvise_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES ( 'transaction_cancellation_summary', 1, 1, 1, 18.1, 1, 0, '2017-11-01 16:11:28', '2023-09-04 12:33:07', NULL);


-- EOD Overnight Vehicle Summary
INSERT INTO `sps_eod_report_select` (`eod_report_name`, `status`, `area_id`, `location_id`, `eod_reportvise_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES ('overnight_vehicle_report_summary', 1, 1, 1, 22.1, 1, 0, '2017-11-01 16:11:28', '2023-08-21 20:13:23', NULL);

-- EOD Overnight Vehicle Detail
UPDATE `sps_eod_report_select` SET `eod_report_name` = 'overnight_vehicle_report_detailed', `status` = 1, `area_id` = 1, `location_id` = 1, `eod_reportvise_id` = 22, `created_by` = 1, `updated_by` = 0, `created_at` = '2017-11-01 16:11:28', `updated_at` = '2023-08-21 20:13:23', `deleted_at` = NULL WHERE `eod_report_name` = 'overnight_vehicle_report';
