-- backuo sps_menu then run this query

UPDATE `sps_menu` SET `menu_item` = 'dashboard', `menu_url` = 'admin', `menu_class` = '', `parent_menu_id` = 0, `action` = '1', `order` = 1.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2016-12-22 07:13:46', `updated_at` = '2017-02-02 07:59:54', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 1;

UPDATE `sps_menu` SET `menu_item` = 'equipment_type', `menu_url` = 'admin/equipment', `menu_class` = 'menu', `parent_menu_id` = 11, `action` = '', `order` = 2.01, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2016-12-22 08:18:13', `updated_at` = '2017-04-13 01:06:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 2;

UPDATE `sps_menu` SET `menu_item` = 'vehicle_type', `menu_url` = 'admin/vehicle', `menu_class` = 'menu', `parent_menu_id` = 11, `action` = '', `order` = 2.02, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2016-12-22 08:18:13', `updated_at` = '2017-04-13 01:06:03', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 3;

UPDATE `sps_menu` SET `menu_item` = 'user_role', `menu_url` = 'admin/user_role', `menu_class` = 'menu', `parent_menu_id` = 17, `action` = '1,2,3,4', `order` = 3.02, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2016-12-22 08:18:13', `updated_at` = '2017-04-10 07:22:17', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 4;

UPDATE `sps_menu` SET `menu_item` = 'menu_access', `menu_url` = 'admin/menu_access', `menu_class` = 'menu', `parent_menu_id` = 11, `action` = '0', `order` = 0.00, `status` = 0, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-03-14 05:48:53', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 5;

UPDATE `sps_menu` SET `menu_item` = 'payment_mode', `menu_url` = 'admin/payment', `menu_class` = 'menu', `parent_menu_id` = 11, `action` = '', `order` = 2.03, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-13 01:06:17', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 6;

UPDATE `sps_menu` SET `menu_item` = 'gate_configuration', `menu_url` = 'admin/gate', `menu_class` = 'menu', `parent_menu_id` = 11, `action` = '', `order` = 2.04, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-13 01:06:20', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 7;

UPDATE `sps_menu` SET `menu_item` = 'transactions_entry', `menu_url` = 'admin/transaction/view_entries', `menu_class` = 'menu', `parent_menu_id` = 12, `action` = '1', `order` = 4.02, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:22:30', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 8;

UPDATE `sps_menu` SET `menu_item` = 'transactions_exit', `menu_url` = 'admin/transaction/view_exits', `menu_class` = 'menu', `parent_menu_id` = 12, `action` = '1', `order` = 4.03, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:22:34', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 9;

UPDATE `sps_menu` SET `menu_item` = 'configuration_management', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 0, `action` = '1', `order` = 2.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-02-16 08:14:14', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 11;

UPDATE `sps_menu` SET `menu_item` = 'transactions', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 0, `action` = '1', `order` = 4.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-07 06:54:37', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 12;

UPDATE `sps_menu` SET `menu_item` = 'ipaddress', `menu_url` = 'admin/ipaddress', `menu_class` = 'menu', `parent_menu_id` = 11, `action` = '', `order` = 2.05, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-13 01:06:24', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 13;

UPDATE `sps_menu` SET `menu_item` = 'holidays', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 11, `action` = '1', `order` = 2.08, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:22:46', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 14;

UPDATE `sps_menu` SET `menu_item` = 'users_management', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 0, `action` = '1', `order` = 3.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-07 06:54:06', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 17;

UPDATE `sps_menu` SET `menu_item` = 'user_create', `menu_url` = 'admin/user_create', `menu_class` = 'menu', `parent_menu_id` = 17, `action` = '1,2,3,4', `order` = 3.01, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:22:53', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 18;

UPDATE `sps_menu` SET `menu_item` = 'access_rights', `menu_url` = 'admin/access_rights', `menu_class` = 'menu', `parent_menu_id` = 17, `action` = '0', `order` = 3.03, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:22:59', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 19;

UPDATE `sps_menu` SET `menu_item` = 'weekdays_weekends', `menu_url` = 'admin/weekdays_weekends', `menu_class` = 'menu', `parent_menu_id` = 14, `action` = '1', `order` = 2.08, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:23:04', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 20;

UPDATE `sps_menu` SET `menu_item` = 'specialdays', `menu_url` = 'admin/special_days', `menu_class` = 'menu', `parent_menu_id` = 14, `action` = '1', `order` = 2.08, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:23:24', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 21;

UPDATE `sps_menu` SET `menu_item` = 'gate_monitoring', `menu_url` = 'admin/gate_monitoring', `menu_class` = 'menu', `parent_menu_id` = 0, `action` = '1', `order` = 12.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-07 06:56:27', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 22;

UPDATE `sps_menu` SET `menu_item` = 'shift_management', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 0, `action` = '1', `order` = 0.00, `status` = 0, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-13 01:10:11', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 23;

UPDATE `sps_menu` SET `menu_item` = 'user_shift', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 23, `action` = '1', `order` = 0.00, `status` = 0, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-13 01:10:15', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 24;

UPDATE `sps_menu` SET `menu_item` = 'active_users', `menu_url` = 'admin/active_users', `menu_class` = 'menu', `parent_menu_id` = 12, `action` = '1', `order` = 4.06, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:23:32', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 25;

UPDATE `sps_menu` SET `menu_item` = 'tariff_management', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 0, `action` = '1', `order` = 6.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-07 06:56:40', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 26;

UPDATE `sps_menu` SET `menu_item` = 'casual_tariff', `menu_url` = 'admin/tariff', `menu_class` = 'menu', `parent_menu_id` = 26, `action` = '1,2,3,4', `order` = 6.01, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:23:36', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 27;

UPDATE `sps_menu` SET `menu_item` = 'service_type', `menu_url` = 'admin/service_type', `menu_class` = 'menu', `parent_menu_id` = 11, `action` = '1,2,3,4', `order` = 2.06, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:23:42', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 28;

UPDATE `sps_menu` SET `menu_item` = 'overnight_tariff', `menu_url` = 'admin/overnight_tariff', `menu_class` = 'menu', `parent_menu_id` = 26, `action` = '1,2,3,4', `order` = 6.02, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:23:44', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 29;

UPDATE `sps_menu` SET `menu_item` = 'additional_tariff', `menu_url` = 'admin/additional_tariff', `menu_class` = 'menu', `parent_menu_id` = 26, `action` = '1,2,3,4', `order` = 6.03, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:23:49', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 30;

UPDATE `sps_menu` SET `menu_item` = 'voucher_management', `menu_url` = 'admin/voucher', `menu_class` = 'menu', `parent_menu_id` = 0, `action` = '', `order` = 9.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:28:28', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 31;

UPDATE `sps_menu` SET `menu_item` = 'member_tariff', `menu_url` = 'admin/member_tariff', `menu_class` = 'menu', `parent_menu_id` = 26, `action` = '1,2,3,4', `order` = 6.04, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:23:52', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 32;

UPDATE `sps_menu` SET `menu_item` = 'corporate', `menu_url` = 'admin/corporate', `menu_class` = 'menu', `parent_menu_id` = 38, `action` = '', `order` = 8.01, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:23:59', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 33;

UPDATE `sps_menu` SET `menu_item` = 'site_settings', `menu_url` = 'admin/site_settings', `menu_class` = 'menu', `parent_menu_id` = 0, `action` = '', `order` = 14.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-07 07:02:31', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 34;

UPDATE `sps_menu` SET `menu_item` = 'settlements', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 12, `action` = '', `order` = 4.07, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:27:35', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 35;

UPDATE `sps_menu` SET `menu_item` = 'input_settlements', `menu_url` = 'admin/input_settlements', `menu_class` = 'menu', `parent_menu_id` = 35, `action` = '', `order` = 4.07, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:27:39', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 36;

UPDATE `sps_menu` SET `menu_item` = 'info_settlements', `menu_url` = 'admin/info_settlements', `menu_class` = 'menu', `parent_menu_id` = 35, `action` = '', `order` = 4.07, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:27:42', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 37;

UPDATE `sps_menu` SET `menu_item` = 'member_management', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 0, `action` = '', `order` = 8.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-03-15 13:00:00', `updated_at` = '2017-04-07 06:57:57', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 38;

UPDATE `sps_menu` SET `menu_item` = 'member_customer', `menu_url` = 'admin/member', `menu_class` = 'menu', `parent_menu_id` = 38, `action` = '', `order` = 8.02, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-13 01:07:32', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 39;

UPDATE `sps_menu` SET `menu_item` = 'membership', `menu_url` = 'admin/membership', `menu_class` = 'menu', `parent_menu_id` = 38, `action` = '', `order` = 8.03, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-13 01:07:28', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 40;

UPDATE `sps_menu` SET `menu_item` = 'read_card', `menu_url` = 'admin/member/open_read_card', `menu_class` = 'menu', `parent_menu_id` = 38, `action` = '', `order` = 8.05, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:24:47', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 41;

UPDATE `sps_menu` SET `menu_item` = 'sticker_membership', `menu_url` = 'admin/sticker_membership', `menu_class` = 'menu', `parent_menu_id` = 38, `action` = '', `order` = 8.04, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-03-25 04:00:00', `updated_at` = '2017-04-10 07:24:51', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 42;

UPDATE `sps_menu` SET `menu_item` = 'ticket_layout', `menu_url` = 'admin/ticket_layout', `menu_class` = 'menu', `parent_menu_id` = 11, `action` = '1,2,3,4', `order` = 2.09, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:24:56', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 43;

UPDATE `sps_menu` SET `menu_item` = 'blocked_vehicles', `menu_url` = 'admin/blocked_vehicles', `menu_class` = 'menu', `parent_menu_id` = 11, `action` = '', `order` = 2.10, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-07 07:01:10', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 44;

UPDATE `sps_menu` SET `menu_item` = 'discount', `menu_url` = 'admin/discount', `menu_class` = 'menu', `parent_menu_id` = 0, `action` = '', `order` = 7.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:28:33', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 45;

UPDATE `sps_menu` SET `menu_item` = 'reports', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 0, `action` = '', `order` = 11.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-02-13 01:53:05', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 46;

UPDATE `sps_menu` SET `menu_item` = 'duplicate_ticket', `menu_url` = 'admin/reports/duplicate_ticket', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.25, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 01:15:53', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 47;

UPDATE `sps_menu` SET `menu_item` = 'corporate_report', `menu_url` = 'admin/corporate/?report=1', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.05, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 01:15:53', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 48;

UPDATE `sps_menu` SET `menu_item` = 'membership', `menu_url` = 'admin/reports/membership', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.26, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 01:15:53', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 49;

UPDATE `sps_menu` SET `menu_item` = 'offline_ticket', `menu_url` = 'admin/reports/offline_ticket', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.21, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 05:24:41', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 50;

UPDATE `sps_menu` SET `menu_item` = 'configure_statistic_list', `menu_url` = 'admin/reports/statistics_list', `menu_class` = 'menu', `parent_menu_id` = 11, `action` = '', `order` = 11.07, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-14 06:07:10', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 51;

UPDATE `sps_menu` SET `menu_item` = 'generate_report', `menu_url` = 'admin/reports/generate_report', `menu_class` = 'menu', `parent_menu_id` = 99, `action` = '', `order` = 10.02, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 01:15:53', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 52;

UPDATE `sps_menu` SET `menu_item` = 'configure_report', `menu_url` = 'admin/reports/configure_report', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.04, `status` = 0, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 01:15:53', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 53;

UPDATE `sps_menu` SET `menu_item` = 'manual_entry', `menu_url` = 'admin/transaction/manual_entry', `menu_class` = 'menu', `parent_menu_id` = 12, `action` = '1', `order` = 4.01, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:22:30', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 54;

UPDATE `sps_menu` SET `menu_item` = 'master', `menu_url` = 'admin/master', `menu_class` = '', `parent_menu_id` = 0, `action` = '', `order` = 5.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-19 04:25:07', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 55;

UPDATE `sps_menu` SET `menu_item` = 'f8_reason', `menu_url` = 'admin/f8_reason', `menu_class` = 'menu', `parent_menu_id` = 55, `action` = '', `order` = 5.01, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-19 04:36:56', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 56;

UPDATE `sps_menu` SET `menu_item` = 'upload_transaction', `menu_url` = 'admin/transaction/upload_transaction', `menu_class` = 'menu', `parent_menu_id` = 12, `action` = '', `order` = 4.04, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-20 00:26:47', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 57;

UPDATE `sps_menu` SET `menu_item` = 'bank_deposit', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 12, `action` = '', `order` = 4.08, `status` = 0, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2023-01-04 11:49:35', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 58;

UPDATE `sps_menu` SET `menu_item` = 'bank_deposit_input', `menu_url` = 'admin/bank_deposit_input', `menu_class` = 'menu', `parent_menu_id` = 58, `action` = '', `order` = 4.07, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:27:39', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 59;

UPDATE `sps_menu` SET `menu_item` = 'bank_deposit_info', `menu_url` = 'admin/bank_deposit_info', `menu_class` = 'menu', `parent_menu_id` = 58, `action` = '', `order` = 4.07, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-10 07:27:39', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 60;

UPDATE `sps_menu` SET `menu_item` = 'bay_management', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 0, `action` = '', `order` = 13.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-07 07:02:31', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 61;

UPDATE `sps_menu` SET `menu_item` = 'zones', `menu_url` = 'admin/zone', `menu_class` = 'menu', `parent_menu_id` = 61, `action` = '', `order` = 13.01, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-13 01:07:28', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 62;

UPDATE `sps_menu` SET `menu_item` = 'levels', `menu_url` = 'admin/level', `menu_class` = 'menu', `parent_menu_id` = 61, `action` = '', `order` = 13.02, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-13 01:07:28', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 63;

UPDATE `sps_menu` SET `menu_item` = 'bays', `menu_url` = 'admin/bay', `menu_class` = 'menu', `parent_menu_id` = 61, `action` = '', `order` = 13.03, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-04-13 01:07:28', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 64;

UPDATE `sps_menu` SET `menu_item` = 'offline_transaction', `menu_url` = 'admin/transaction/offline_transaction', `menu_class` = 'menu', `parent_menu_id` = 12, `action` = '', `order` = 4.05, `status` = 0, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-20 00:26:47', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 65;

UPDATE `sps_menu` SET `menu_item` = 'f3_reason', `menu_url` = 'admin/f3_reason', `menu_class` = 'menu', `parent_menu_id` = 55, `action` = '', `order` = 5.02, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-05-12 04:41:40', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 66;

UPDATE `sps_menu` SET `menu_item` = 'overnight_vehicle', `menu_url` = 'admin/overnight_vehicle', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.24, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 05:24:41', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 67;

UPDATE `sps_menu` SET `menu_item` = 'foc_approvers', `menu_url` = 'admin/foc_approvers', `menu_class` = 'menu', `parent_menu_id` = 55, `action` = '', `order` = 5.03, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-05-16 08:22:16', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 68;

UPDATE `sps_menu` SET `menu_item` = 'trans_cancellation', `menu_url` = 'admin/reports/trans_cancellation', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.28, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 01:15:53', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 69;

UPDATE `sps_menu` SET `menu_item` = 'login_history', `menu_url` = 'admin/reports/login_history', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.11, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 07:15:53', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 70;

UPDATE `sps_menu` SET `menu_item` = 'overnight_report', `menu_url` = 'admin/reports/overnight_report', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.23, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 07:15:53', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 71;

UPDATE `sps_menu` SET `menu_item` = 'maturity_report', `menu_url` = 'admin/reports/maturity_report', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.15, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 07:15:53', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 72;

UPDATE `sps_menu` SET `menu_item` = 'logged_in_cashier', `menu_url` = 'admin/reports/logged_in_cashier', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.10, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-14 07:15:53', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 73;

UPDATE `sps_menu` SET `menu_item` = 'member_activity', `menu_url` = 'admin/member_activity', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.19, `status` = 1, `location_id` = 3, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 80;

UPDATE `sps_menu` SET `menu_item` = 'user_pershift_recap_report', `menu_url` = 'admin/user_pershift_recap_report', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.29, `status` = 1, `location_id` = 3, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 83;

UPDATE `sps_menu` SET `menu_item` = 'manual_report', `menu_url` = 'admin/reports/manual_report', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.14, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 07:15:53', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 84;

UPDATE `sps_menu` SET `menu_item` = 'vehicle_activity', `menu_url` = 'admin/vehicle_activity', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.30, `status` = 1, `location_id` = 3, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 86;

UPDATE `sps_menu` SET `menu_item` = 'transactions_entry_report', `menu_url` = 'admin/reports/transactions_entry', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.27, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 87;

UPDATE `sps_menu` SET `menu_item` = 'tariff_report', `menu_url` = 'admin/reports/tariff', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.26, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 88;

UPDATE `sps_menu` SET `menu_item` = 'additionalTariff_report', `menu_url` = 'admin/additional_tariff/?report=1', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.02, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 89;

UPDATE `sps_menu` SET `menu_item` = 'overnightTariff_report', `menu_url` = 'admin/overnight_tariff/?report=1', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.22, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 90;

UPDATE `sps_menu` SET `menu_item` = 'vehicle_number_change', `menu_url` = 'admin/vehicle_number_change', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.31, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 91;

UPDATE `sps_menu` SET `menu_item` = 'voucher_consumption', `menu_url` = 'admin/voucher_consumption', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.32, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 92;

UPDATE `sps_menu` SET `menu_item` = 'membershipProduct_report', `menu_url` = 'admin/member_tariff/?report=1', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.18, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 93;

UPDATE `sps_menu` SET `menu_item` = 'lost_ticket_report', `menu_url` = 'admin/reports/lost_ticket', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.12, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '2017-04-13 07:15:53', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 94;

UPDATE `sps_menu` SET `menu_item` = 'questioned_tickets', `menu_url` = 'admin/questioned_tickets', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.09, `status` = 1, `location_id` = 3, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 95;

UPDATE `sps_menu` SET `menu_item` = 'card_transaction', `menu_url` = 'admin/reports/card_transaction', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.03, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 96;

UPDATE `sps_menu` SET `menu_item` = 'eod_report_select', `menu_url` = 'admin/reports/eod_report_select', `menu_class` = 'menu', `parent_menu_id` = 99, `action` = '', `order` = 10.01, `status` = 1, `location_id` = 3, `area_id` = 1, `created_by` = 1, `created_at` = '2017-06-07 06:51:00', `updated_at` = '2017-06-07 06:51:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 97;

UPDATE `sps_menu` SET `menu_item` = 'tax', `menu_url` = 'admin/tax', `menu_class` = 'menu', `parent_menu_id` = 55, `action` = '', `order` = 5.04, `status` = 1, `location_id` = 1, `area_id` = 0, `created_by` = 0, `created_at` = '2017-07-18 07:08:44', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 98;

UPDATE `sps_menu` SET `menu_item` = 'eod', `menu_url` = '', `menu_class` = '', `parent_menu_id` = 0, `action` = '', `order` = 10.00, `status` = 1, `location_id` = 0, `area_id` = 0, `created_by` = 0, `created_at` = '0000-00-00 00:00:00', `updated_at` = '2017-02-13 01:53:05', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 99;

UPDATE `sps_menu` SET `menu_item` = 'loyalty_discount', `menu_url` = 'admin/loyalty_discount', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.13, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2020-02-18 01:41:45', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 100;

UPDATE `sps_menu` SET `menu_item` = 'max_charge_discount', `menu_url` = 'admin/max_charge_discount', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.16, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2020-02-18 01:42:04', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 1 WHERE `id` = 101;

UPDATE `sps_menu` SET `menu_item` = 'mixed_transaction', `menu_url` = 'admin/reports/mixed_transaction', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.20, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2020-07-10 01:15:52', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 102;

UPDATE `sps_menu` SET `menu_item` = 'dwell_time_report', `menu_url` = 'admin/dwell_time_report', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.07, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2020-07-10 01:17:03', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 103;

UPDATE `sps_menu` SET `menu_item` = 'frequency_report', `menu_url` = 'admin/frequency_report', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.08, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2020-07-10 01:22:19', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 105;

UPDATE `sps_menu` SET `menu_item` = 'detailed_payments_report', `menu_url` = 'admin/detailed_payments_report', `menu_class` = 'menu', `parent_menu_id` = 46, `action` = '', `order` = 11.06, `status` = 1, `location_id` = 1, `area_id` = 1, `created_by` = 1, `created_at` = '2022-05-30 01:04:41', `updated_at` = '0000-00-00 00:00:00', `deleted_at` = NULL, `updated_by` = 0 WHERE `id` = 106;