
-- //MYSQL QUERY

CREATE TABLE `tbl_rpt001` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `vehicle_type` varchar(50) NOT NULL DEFAULT '',
  `vehi_IN_casu_ONL` varchar(50) NOT NULL DEFAULT '',
  `vehi_IN_casu_OFL` varchar(50) NOT NULL DEFAULT '',
  `vehi_IN_casu_MNL` varchar(50) NOT NULL DEFAULT '',
  `vehi_IN_pass_or_club_ONL` varchar(50) NOT NULL DEFAULT '',
  `vehi_IN_pass_or_club_OFL` varchar(50) NOT NULL DEFAULT '',
  `vehi_IN_pass_or_club_MNL` varchar(50) NOT NULL DEFAULT '',
  `Total_IN` varchar(50) NOT NULL DEFAULT '',
  `vehi_OUT_casu_ONL` varchar(50) NOT NULL DEFAULT '',
  `vehi_OUT_casu_OFL` varchar(50) NOT NULL DEFAULT '',
  `vehi_OUT_casu_MNL` varchar(50) NOT NULL DEFAULT '',
  `vehi_OUT_pass_or_club_ONL` varchar(50) NOT NULL DEFAULT '',
  `vehi_OUT_pass_or_club_OFL` varchar(50) NOT NULL DEFAULT '',
  `vehi_OUT_pass_or_club_MNL` varchar(50) NOT NULL DEFAULT '',
  `Total_OUT` varchar(50) NOT NULL DEFAULT '',
  `vehi_CPS_casu_ONL` varchar(50) NOT NULL DEFAULT '',
  `vehi_CPS_casu_OFL` varchar(50) NOT NULL DEFAULT '',
  `vehi_CPS_casu_MNL` varchar(50) NOT NULL DEFAULT '',
  `vehi_CPS_pass_or_club_ONL` varchar(50) NOT NULL DEFAULT '',
  `vehi_CPS_pass_or_club_OFL` varchar(50) NOT NULL DEFAULT '',
  `vehi_CPS_pass_or_club_MNL` varchar(50) NOT NULL DEFAULT '',
  `Total_CPS` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=259 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt0010` */


CREATE TABLE `tbl_rpt0010` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `vehicle_type` varchar(50) NOT NULL DEFAULT '',
  `qty` varchar(50) NOT NULL DEFAULT '',
  `discount_amount` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt0011` */


CREATE TABLE `tbl_rpt0011` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `VEH_TYPE` varchar(50) DEFAULT '',
  `MEM_ID` varchar(50) NOT NULL DEFAULT '',
  `MEM_name` varchar(50) NOT NULL DEFAULT '',
  `card_no` varchar(50) NOT NULL DEFAULT '',
  `MEM_TY` varchar(50) NOT NULL DEFAULT '',
  `PRD_CARD_TYPE` varchar(50) NOT NULL DEFAULT '',
  `MEM_ACT` varchar(50) NOT NULL DEFAULT '',
  `VAL_PRD_FROM_TO` varchar(50) NOT NULL DEFAULT '',
  `PMT_TYPE` varchar(50) NOT NULL DEFAULT '',
  `SEC_DPT` varchar(50) NOT NULL DEFAULT '',
  `MEM_Free` varchar(50) NOT NULL DEFAULT '',
  `Total` varchar(50) NOT NULL DEFAULT '',
  `User` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=1846 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt0012` */


CREATE TABLE `tbl_rpt0012` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `MEM_ID` varchar(50) NOT NULL DEFAULT '',
  `MEM_name` varchar(50) NOT NULL DEFAULT '',
  `card_no` varchar(50) NOT NULL DEFAULT '',
  `MEM_TY` varchar(50) NOT NULL DEFAULT '',
  `PRD_CARD_TYPE` varchar(50) NOT NULL DEFAULT '',
  `MEM_ACT` varchar(50) NOT NULL DEFAULT '',
  `VAL_PRD_FROM_TO` varchar(50) NOT NULL DEFAULT '',
  `PMT_TYPE` varchar(50) NOT NULL DEFAULT '',
  `AMT_Paid` varchar(50) NOT NULL DEFAULT '',
  `User` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt0016` */


CREATE TABLE `tbl_rpt0016` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `TCI_Cash` varchar(50) NOT NULL DEFAULT '',
  `TCI_Digital` varchar(50) NOT NULL DEFAULT '',
  `CI_Digital_Fastag_ACCEPTED` varchar(50) NOT NULL DEFAULT '',
  `CI_Digital_Fastag_DECLINED` varchar(50) NOT NULL DEFAULT '',
  `CI_Digital_APS` varchar(50) NOT NULL DEFAULT '',
  `CI_Digital_UPI` varchar(50) NOT NULL DEFAULT '',
  `CI_Cash_EDC` varchar(50) NOT NULL DEFAULT '',
  `TMI_cash` varchar(50) NOT NULL DEFAULT '',
  `TMI_digital_cheque` varchar(50) NOT NULL DEFAULT '',
  `TVI` varchar(50) NOT NULL DEFAULT '',
  `TMR` varchar(50) NOT NULL DEFAULT '',
  `Club_Secure_VIP_membership_Report` varchar(50) NOT NULL DEFAULT '',
  `TCB` varchar(50) NOT NULL DEFAULT '',
  `TDB` varchar(50) NOT NULL DEFAULT '',
  `TPR` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt0017` */


CREATE TABLE `tbl_rpt0017` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `Gate` varchar(50) NOT NULL DEFAULT '',
  `Cashier` varchar(50) NOT NULL DEFAULT '',
  `Start_shift_time` varchar(50) NOT NULL DEFAULT '',
  `End_shift_time` varchar(50) NOT NULL DEFAULT '',
  `CASUAL_ONL` varchar(50) NOT NULL DEFAULT '',
  `CASUAL_OFL` varchar(50) NOT NULL DEFAULT '',
  `CASUAL_MNL` varchar(50) NOT NULL DEFAULT '',
  `PASS_ONL` varchar(50) NOT NULL DEFAULT '',
  `PASS_OFL` varchar(50) NOT NULL DEFAULT '',
  `PASS_MNL` varchar(50) NOT NULL DEFAULT '',
  `FOC` varchar(50) NOT NULL DEFAULT '',
  `MNL_f8` varchar(50) NOT NULL DEFAULT '',
  `MNL_LT` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=4586 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt0018` */


CREATE TABLE `tbl_rpt0018` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `Total_transaction_cancelled` varchar(50) NOT NULL DEFAULT '',
  `Previous_transaction_cancelled` varchar(50) NOT NULL DEFAULT '',
  `Total_trasanction_open_for_the_day` varchar(50) NOT NULL DEFAULT '',
  `Total_trasanction_open_till_previous_day` varchar(50) NOT NULL DEFAULT '',
  `total_previous_transaction_left` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt0018_1` */


CREATE TABLE `tbl_rpt0018_1` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) DEFAULT NULL,
  `report_date` date DEFAULT NULL,
  `ADM_user` varchar(50) NOT NULL DEFAULT '',
  `In_gate_ip_id` varchar(50) NOT NULL DEFAULT '',
  `ticket_no` varchar(50) NOT NULL DEFAULT '',
  `card_no` varchar(50) NOT NULL DEFAULT '',
  `veh_no` varchar(50) NOT NULL DEFAULT '',
  `in_date_time` varchar(50) NOT NULL DEFAULT '',
  `txn_cancellation` varchar(50) NOT NULL DEFAULT '',
  `txn_cancellation_datetime` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=57882 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt002` */


CREATE TABLE `tbl_rpt002` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `gate_id_shift_id_username` varchar(50) NOT NULL DEFAULT '',
  `system_cash(R)` varchar(50) NOT NULL DEFAULT '',
  `actual_cash(R)` varchar(50) NOT NULL DEFAULT '',
  `APVD_FOC(R)` varchar(50) NOT NULL DEFAULT '',
  `PT_QTY(nos)` varchar(50) NOT NULL DEFAULT '',
  `APVD_PT(R)` varchar(50) NOT NULL DEFAULT '',
  `RJT_PT(R)` varchar(50) NOT NULL DEFAULT '',
  `FT_RCV(R)` varchar(50) NOT NULL DEFAULT '',
  `expected_cash_RCV(R)` varchar(50) NOT NULL DEFAULT '',
  `actual_cash_RCV(R)` varchar(50) NOT NULL DEFAULT '',
  `Total_RCV(R)` varchar(50) NOT NULL DEFAULT '',
  `banking(R)` varchar(50) NOT NULL DEFAULT '',
  `qty(nos)` varchar(50) NOT NULL DEFAULT '',
  `RVN(R)` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2878 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt0022` */


CREATE TABLE `tbl_rpt0022` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `Total_trasanction_open_for_the_day` varchar(50) NOT NULL DEFAULT '',
  `Total_trasanction_open_for_the_day_casual` varchar(50) NOT NULL DEFAULT '',
  `Total_trasanction_open_for_the_day_membership` varchar(50) NOT NULL DEFAULT '',
  `total_previous_transaction_left` varchar(50) NOT NULL DEFAULT '',
  `total_previous_transaction_left_casual` varchar(50) NOT NULL DEFAULT '',
  `total_previous_transaction_left_membership` varchar(50) NOT NULL DEFAULT '',
  `total_overnight_charges` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt0022_1` */


CREATE TABLE `tbl_rpt0022_1` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) DEFAULT NULL,
  `report_date` date DEFAULT NULL,
  `In_gate_user` varchar(50) NOT NULL DEFAULT '',
  `In_gate_ip_id` varchar(50) NOT NULL DEFAULT '',
  `ticket_no` varchar(50) NOT NULL DEFAULT '',
  `card_no` varchar(50) NOT NULL DEFAULT '',
  `veh_no` varchar(50) NOT NULL DEFAULT '',
  `in_date_time` varchar(50) NOT NULL DEFAULT '',
  `out_gate_user` varchar(50) NOT NULL DEFAULT '',
  `out_gate_ip` varchar(50) NOT NULL DEFAULT '',
  `out_datetime` varchar(50) NOT NULL DEFAULT '',
  `total_ov_amt` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=8475 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt0023` */


CREATE TABLE `tbl_rpt0023` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) DEFAULT NULL,
  `report_date` date DEFAULT NULL,
  `veh_type` varchar(50) NOT NULL DEFAULT '',
  `duration` varchar(50) NOT NULL DEFAULT '',
  `casual` varchar(50) NOT NULL DEFAULT '',
  `member` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2065 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt003` */


CREATE TABLE `tbl_rpt003` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `users` varchar(50) NOT NULL DEFAULT '',
  `FOC_qty` varchar(50) NOT NULL DEFAULT '',
  `FOC_APV` varchar(50) NOT NULL DEFAULT '',
  `FOC_RJT` varchar(50) NOT NULL DEFAULT '',
  `F8_qty` varchar(50) NOT NULL DEFAULT '',
  `F8_APV` varchar(50) NOT NULL DEFAULT '',
  `F8_RJT` varchar(50) NOT NULL DEFAULT '',
  `vouchers_qty` varchar(50) NOT NULL DEFAULT '',
  `vouchers_APV` varchar(50) NOT NULL DEFAULT '',
  `vouchers_RJT` varchar(50) NOT NULL DEFAULT '',
  `F8_FOC_qty` varchar(50) NOT NULL DEFAULT '',
  `F8_FOC_APV` varchar(50) NOT NULL DEFAULT '',
  `F8_FOC_RJT` varchar(50) NOT NULL DEFAULT '',
  `F8_vouchers_qty` varchar(50) NOT NULL DEFAULT '',
  `F8_vouchers_APV` varchar(50) NOT NULL DEFAULT '',
  `F8_vouchers_RJT` varchar(50) NOT NULL DEFAULT '',
  `total_qty` varchar(50) NOT NULL DEFAULT '',
  `total_APV` varchar(50) NOT NULL DEFAULT '',
  `total_RJT` varchar(50) NOT NULL DEFAULT '',
  `Created_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1530 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt004_1` */


CREATE TABLE `tbl_rpt004_1` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `cashier` varchar(50) NOT NULL DEFAULT '',
  `TOT_VEH_QTY_nos` varchar(50) NOT NULL DEFAULT '',
  `TOT_Income` varchar(50) NOT NULL DEFAULT '',
  `Cash_qty` varchar(50) NOT NULL DEFAULT '',
  `Cash_rev` varchar(50) NOT NULL DEFAULT '',
  `EDC_qty` varchar(50) NOT NULL DEFAULT '',
  `EDC_rev` varchar(50) NOT NULL DEFAULT '',
  `Memberships_qty` varchar(50) NOT NULL DEFAULT '',
  `Memberships_rev` varchar(50) NOT NULL DEFAULT '',
  `UPI_static_dynamic_qty` varchar(50) NOT NULL DEFAULT '',
  `UPI_static_dynamic_rev` varchar(50) NOT NULL DEFAULT '',
  `Fastag_qty` varchar(50) NOT NULL DEFAULT '',
  `Fastag_rev` varchar(50) NOT NULL DEFAULT '',
  `TOT_VCH_QTY_Nos` varchar(50) NOT NULL DEFAULT '',
  `TOT_VCH_DSC` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2801 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt004_2` */


CREATE TABLE `tbl_rpt004_2` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `cashier` varchar(50) NOT NULL DEFAULT '',
  `TOT_VEH_QTY_nos` varchar(50) NOT NULL DEFAULT '',
  `TOT_Income` varchar(50) NOT NULL DEFAULT '',
  `Cash_qty` varchar(50) NOT NULL DEFAULT '',
  `Cash_rev` varchar(50) NOT NULL DEFAULT '',
  `EDC_qty` varchar(50) NOT NULL DEFAULT '',
  `EDC_rev` varchar(50) NOT NULL DEFAULT '',
  `Memberships_qty` varchar(50) NOT NULL DEFAULT '',
  `Memberships_rev` varchar(50) NOT NULL DEFAULT '',
  `UPI_static_dynamic_qty` varchar(50) NOT NULL DEFAULT '',
  `UPI_static_dynamic_rev` varchar(50) NOT NULL DEFAULT '',
  `Fastag_qty` varchar(50) NOT NULL DEFAULT '',
  `Fastag_rev` varchar(50) NOT NULL DEFAULT '',
  `TOT_VCH_QTY_Nos` varchar(50) NOT NULL DEFAULT '',
  `TOT_VCH_DSC` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2878 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt005` */


CREATE TABLE `tbl_rpt005` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `Vehicle_type` varchar(50) NOT NULL DEFAULT '',
  `EDC_QTY` varchar(50) NOT NULL DEFAULT '',
  `EDC_Rev` varchar(50) NOT NULL DEFAULT '',
  `UPI_Static_dynamic_qr_code_QTY` varchar(50) NOT NULL DEFAULT '',
  `UPI_Static_dynamic_qr_code_Rev` varchar(50) NOT NULL DEFAULT '',
  `web_payment_QTY` varchar(50) NOT NULL DEFAULT '',
  `web_payment_Rev` varchar(50) NOT NULL DEFAULT '',
  `Fastag_payment_QTY` varchar(50) NOT NULL DEFAULT '',
  `Fastag_payment_Rev` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=259 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt006_1` */


CREATE TABLE `tbl_rpt006_1` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `Vehicle_type` varchar(50) NOT NULL DEFAULT '',
  `Cash_QTY` varchar(50) NOT NULL DEFAULT '',
  `Cash_Rev` varchar(50) NOT NULL DEFAULT '',
  `EDC_QTY` varchar(50) NOT NULL DEFAULT '',
  `EDC_Rev` varchar(50) NOT NULL DEFAULT '',
  `Digital_Payments_QTY` varchar(50) NOT NULL DEFAULT '',
  `Digital_Payments_Rev` varchar(50) NOT NULL DEFAULT '',
  `RFID_membership_QTY` varchar(50) NOT NULL DEFAULT '',
  `RFID_membership_Rev` varchar(50) NOT NULL DEFAULT '',
  `Sticker_Membership_QTY` varchar(50) NOT NULL DEFAULT '',
  `Sticker_Membership_Rev` varchar(50) NOT NULL DEFAULT '',
  `Club_Secure_VIP_member_QTY` varchar(50) NOT NULL DEFAULT '',
  `Club_Secure_VIP_member_Rev` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=259 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt006_2` */


CREATE TABLE `tbl_rpt006_2` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `Vehicle_type` varchar(50) NOT NULL DEFAULT '',
  `Cash_QTY` varchar(50) NOT NULL DEFAULT '',
  `Cash_Rev` varchar(50) NOT NULL DEFAULT '',
  `EDC_QTY` varchar(50) NOT NULL DEFAULT '',
  `EDC_Rev` varchar(50) NOT NULL DEFAULT '',
  `Digital_Payments_QTY` varchar(50) NOT NULL DEFAULT '',
  `Digital_Payments_Rev` varchar(50) NOT NULL DEFAULT '',
  `RFID_membership_QTY` varchar(50) NOT NULL DEFAULT '',
  `RFID_membership_Rev` varchar(50) NOT NULL DEFAULT '',
  `Sticker_Membership_QTY` varchar(50) NOT NULL DEFAULT '',
  `Sticker_Membership_Rev` varchar(50) NOT NULL DEFAULT '',
  `Club_Secure_VIP_member_QTY` varchar(50) NOT NULL DEFAULT '',
  `Club_Secure_VIP_member_Rev` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=259 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt006_3` */


CREATE TABLE `tbl_rpt006_3` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `Vehicle_type` varchar(50) NOT NULL DEFAULT '',
  `Cash_QTY` varchar(50) NOT NULL DEFAULT '',
  `Cash_Rev` varchar(50) NOT NULL DEFAULT '',
  `EDC_QTY` varchar(50) NOT NULL DEFAULT '',
  `EDC_Rev` varchar(50) NOT NULL DEFAULT '',
  `Digital_Payments_QTY` varchar(50) NOT NULL DEFAULT '',
  `Digital_Payments_Rev` varchar(50) NOT NULL DEFAULT '',
  `RFID_membership_QTY` varchar(50) NOT NULL DEFAULT '',
  `RFID_membership_Rev` varchar(50) NOT NULL DEFAULT '',
  `Sticker_Membership_QTY` varchar(50) NOT NULL DEFAULT '',
  `Sticker_Membership_Rev` varchar(50) NOT NULL DEFAULT '',
  `Club_Secure_VIP_member_QTY` varchar(50) NOT NULL DEFAULT '',
  `Club_Secure_VIP_member_Rev` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=259 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt007` */


CREATE TABLE `tbl_rpt007` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `Vehicle_type` varchar(50) NOT NULL DEFAULT '',
  `Cash_QTY` varchar(50) NOT NULL DEFAULT '',
  `Cash_ACT_CHG` varchar(50) NOT NULL DEFAULT '',
  `Cash_PP_AMT` varchar(50) NOT NULL DEFAULT '',
  `EDC_QTY` varchar(50) NOT NULL DEFAULT '',
  `EDC_ACT_CHG` varchar(50) NOT NULL DEFAULT '',
  `EDC_PP_AMT` varchar(50) NOT NULL DEFAULT '',
  `DP_QTY` varchar(50) NOT NULL DEFAULT '',
  `DP_ACT_CHG` varchar(50) NOT NULL DEFAULT '',
  `DP_PP_AMT` varchar(50) NOT NULL DEFAULT '',
  `RFID_Memberships_QTY` varchar(50) NOT NULL DEFAULT '',
  `RFID_Memberships_ACT_CHG` varchar(50) NOT NULL DEFAULT '',
  `RFID_Memberships_PP_AMT` varchar(50) NOT NULL DEFAULT '',
  `Stikcer_Memberships_QTY` varchar(50) NOT NULL DEFAULT '',
  `Stikcer_Memberships_ACT_CHG` varchar(50) NOT NULL DEFAULT '',
  `Stikcer_Memberships_PP_AMT` varchar(50) NOT NULL DEFAULT '',
  `Total_QTY` varchar(50) NOT NULL DEFAULT '',
  `Total_ACT_CHG` varchar(50) NOT NULL DEFAULT '',
  `Total_PP_AMT` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt008` */


CREATE TABLE `tbl_rpt008` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `V_CTG` varchar(50) NOT NULL DEFAULT '',
  `V_TYPE` varchar(50) NOT NULL DEFAULT '',
  `V_QTY` varchar(50) NOT NULL DEFAULT '',
  `V_NAME` varchar(50) NOT NULL DEFAULT '',
  `V_VAL_PRD` varchar(50) NOT NULL DEFAULT '',
  `V_DISCOUNT` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/*Table structure for table `tbl_rpt009` */


CREATE TABLE `tbl_rpt009` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `EOD_id` int(11) NOT NULL,
  `report_date` date DEFAULT NULL,
  `vehicle_type` varchar(50) NOT NULL DEFAULT '',
  `discount_type` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `qty` varchar(50) NOT NULL DEFAULT '',
  `validity_period` varchar(50) NOT NULL DEFAULT '',
  `discount_value` varchar(50) NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



CREATE TABLE `sps_eod_reports` (
  `report_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `from_date_report` date NOT NULL,
  `to_date_report` date NOT NULL,
  `filename` varchar(255) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `status_progress` varchar(20) DEFAULT NULL,
  `requested_by` int(10) DEFAULT NULL,
  `area_id` bigint(20) NOT NULL,
  `location_id` bigint(20) NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*Data for the table `sps_eod_reports` */

insert  into `sps_menu`(`menu_item`,`menu_url`,`menu_class`,`parent_menu_id`,`action`,`order`,`status`,`location_id`,`area_id`,`created_by`,`created_at`,`updated_at`,`deleted_at`,`updated_by`) values 
('generate_report_eod','admin/reports/generate_report_eod','menu',99,'',10.03,1,0,0,0,'2024-03-26 11:42:38','0000-00-00 00:00:00',NULL,0);

/*Table structure for table `sps_menu_action_mapping` */

/*Data for the table `sps_menu_action_mapping` */

INSERT INTO sps_menu_action_mapping (menu_id, action_id, area_id, location_id, created_by, updated_by)
SELECT sps_menu.id, 1, 1, 1, 0, 0
FROM sps_menu
WHERE sps_menu.menu_item = 'generate_report_eod';

INSERT INTO sps_access_rights (role_id, menu_id, action_id, area_id, location_id, created_by, updated_by)
SELECT 1, sps_menu.id, 1, 1, 1, 0, 0
FROM sps_menu
WHERE sps_menu.menu_item = 'generate_report_eod';