============36561=================

INSERT INTO  sps_eod_report_select (eod_report_id, eod_report_name,status,area_id, location_id, created_by,updated_by)

VALUES ('','vehicle_type_wise_revenue_report_in_gate','0','1','1','1','0')

 

INSERT INTO  sps_eod_report_select (eod_report_id, eod_report_name,status,area_id, location_id, created_by,updated_by)

VALUES ('','vehicle_type_wise_revenue_report_out_gate','0','1','1','1','0')

 

INSERT INTO  sps_eod_report_select (eod_report_id, eod_report_name,status,area_id, location_id, created_by,updated_by)

VALUES ('','vehicle_type_wise_revenue_report_cps_gate','0','1','1','1','0')

==========end=====================

 

==============35784==============

INSERT INTO `sps_eod_report_select` (`eod_report_id`, `eod_report_name`, `status`, `area_id`, `location_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `deleted_at`) VALUES

('', 'mixed_transaction', 0, 1, 1, 1, 0, '2019-01-28 08:01:47', '2019-01-28 08:02:02', '0000-00-00 00:00:00');

==============end================

==============35810==================

UPDATE `sps_eod_report_select` SET `eod_report_name` = 'cashier_wise_PT_report' WHERE `sps_eod_report_select`.`eod_report_id` = 17;

================end==================

================35787================

INSERT INTO  sps_eod_report_select (eod_report_id, eod_report_name,status,area_id, location_id, created_by,updated_by)

VALUES ('','vehicle_type_wise_revenue','0','1','1','1','0')

================