-- https://www.phpmyadmin.net/
--

START TRANSACTION;



-- --------------------------------------------------------

--
-- Table structure for table `category_leader_board`
--

CREATE TABLE `category_leader_board` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `department_id` bigint(20) UNSIGNED DEFAULT NULL,
  `earned_points` int(11) NOT NULL,
  `total_points` int(11) NOT NULL,
  `category` varchar(255) NOT NULL,
  `rank` int(11) NOT NULL,
  `month_year` varchar(255) NOT NULL,
  `tenant_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_leader_board`
--

INSERT INTO `category_leader_board` (`id`, `department_id`, `earned_points`, `total_points`, `category`, `rank`, `month_year`, `tenant_id`, `created_at`, `updated_at`) VALUES
(1, 1, 79, 210, 'Service Advisor', 1, '2025-02', 1, '2025-02-23 14:13:23', '2025-02-23 14:13:23'),
(2, 1, 9, 251030, 'BDC', 4, '2025-02', 1, '2025-02-24 15:15:23', '2025-02-24 15:15:23'),
(3, 4, 37, 382, 'Finance', 2, '2025-02', 1, '2025-02-23 14:19:23', '2025-02-23 14:19:23'),
(4, 2, 19, 40, 'Sales Agent', 2, '2025-02', 1, '2025-02-24 07:50:40', '2025-02-24 07:50:40'),
(5, 1, 15, 17284, 'Service Advisor', 1, '2025-03', 1, '2025-03-31 15:12:08', '2025-03-31 15:12:08'),
(6, 2, 4, 4650, 'Sales Agent', 2, '2025-03', 1, '2025-03-31 15:11:17', '2025-03-31 15:11:17'),
(7, 1, 104, 1078, 'Service Advisor', 1, '2025-04', 1, '2025-04-16 08:41:14', '2025-04-16 08:41:14'),
(8, 2, 45, 648, 'Sales Agent', 2, '2025-04', 1, '2025-04-16 08:40:29', '2025-04-16 08:40:29');

-- --------------------------------------------------------

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `no_of_emp` int(11) NOT NULL,
  `role` varchar(255) NOT NULL,
  `categories` varchar(255) NOT NULL,
  `slug` text NOT NULL,
  `tenant_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `name`, `no_of_emp`, `role`, `categories`, `slug`, `tenant_id`, `created_at`, `updated_at`) VALUES
(1, 'Service', 20, 'Service', '[\"BDC\",\"Service Advisor\",\"Express Tech\",\"Repair Tech\"]', 'service-department', 1, '2024-12-25 12:26:18', '2025-03-26 07:39:16'),
(2, 'Sales', 3, 'Sales Member', '[\"Sales Agent\"]', 'sales', 1, '2024-12-25 12:35:06', '2025-03-28 14:48:38'),
(3, 'Parts', 3, 'Parts', '[\"Back Counter\"]', 'parts', 1, '2024-12-25 12:38:39', '2025-01-07 14:12:16'),
(4, 'Finance', 5, 'Finance Agent', '[\"Finance\"]', 'finance', 1, '2024-12-25 20:47:00', '2025-01-07 14:05:05'),
(5, 'Fleet Sales', 4, 'Fleet Sales Department', '[\"Sales Team 2\"]', 'sales-team-2', 1, '2024-12-30 13:23:48', '2025-02-06 04:43:09');

-- --------------------------------------------------------

--
-- Table structure for table `department_leader_boards`
--

CREATE TABLE `department_leader_boards` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `department_id` bigint(20) UNSIGNED DEFAULT NULL,
  `earned_points` int(11) NOT NULL,
  `total_points` int(11) NOT NULL,
  `rank` int(11) NOT NULL,
  `month_year` varchar(255) NOT NULL,
  `tenant_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `department_leader_boards`
--

INSERT INTO `department_leader_boards` (`id`, `department_id`, `earned_points`, `total_points`, `rank`, `month_year`, `tenant_id`, `created_at`, `updated_at`) VALUES
(336, 1, 44, 200, 1, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(337, 2, 21, 30, 2, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(338, 4, 14, 47, 3, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(339, 3, 10, 45, 4, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(340, 5, 10, 30, 4, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(341, 1, 94, 251385, 1, '2025-02', 1, '2025-02-24 15:15:23', '2025-02-24 15:15:23'),
(342, 4, 37, 382, 1, '2025-02', 1, '2025-02-23 14:19:23', '2025-02-23 14:19:23'),
(343, 2, 19, 40, 1, '2025-02', 1, '2025-02-24 07:50:40', '2025-02-24 07:50:40'),
(344, 1, 15, 37976, 1, '2025-03', 1, '2025-03-31 15:12:08', '2025-03-31 15:12:08'),
(345, 2, 4, 4650, 1, '2025-03', 1, '2025-03-31 15:11:17', '2025-03-31 15:11:17'),
(346, 1, 104, 1118, 1, '2025-04', 1, '2025-04-16 08:41:14', '2025-04-16 08:41:14'),
(347, 2, 45, 648, 2, '2025-04', 1, '2025-04-16 08:40:29', '2025-04-16 08:40:29');

-- --------------------------------------------------------

--
-- Table structure for table `employee_leader_boards`
--

CREATE TABLE `employee_leader_boards` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` bigint(20) UNSIGNED DEFAULT NULL,
  `earned_points` int(11) NOT NULL,
  `rank` int(11) NOT NULL,
  `month_year` varchar(255) NOT NULL,
  `tenant_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employee_leader_boards`
--

INSERT INTO `employee_leader_boards` (`id`, `employee_id`, `earned_points`, `rank`, `month_year`, `tenant_id`, `created_at`, `updated_at`) VALUES
(667, NULL, 18, 1, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(668, NULL, 13, 2, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(669, NULL, 10, 3, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(670, NULL, 10, 3, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(671, NULL, 10, 3, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(672, NULL, 9, 4, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(673, NULL, 8, 5, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(674, NULL, 7, 6, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(675, NULL, 4, 7, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(676, NULL, 4, 7, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(677, NULL, 3, 8, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(678, NULL, 2, 9, '2025-01', 1, '2025-01-29 20:00:05', '2025-01-29 20:00:05'),
(679, NULL, 37, 1, '2025-02', 1, '2025-02-23 14:13:23', '2025-02-23 14:13:23'),
(680, NULL, 20, 3, '2025-02', 1, '2025-02-17 14:58:15', '2025-02-17 14:58:15'),
(681, NULL, 4, 4, '2025-02', 1, '2025-02-06 20:21:13', '2025-02-06 20:21:13'),
(682, NULL, 2, 7, '2025-02', 1, '2025-02-06 20:23:17', '2025-02-06 20:23:17'),
(683, NULL, 23, 2, '2025-02', 1, '2025-02-23 14:19:23', '2025-02-23 14:19:23'),
(684, NULL, 4, 4, '2025-02', 1, '2025-02-24 15:15:23', '2025-02-24 15:15:23'),
(685, NULL, 4, 4, '2025-02', 1, '2025-02-24 07:50:40', '2025-02-24 07:50:40'),
(686, 399618577, 4, 2, '2025-03', 1, '2025-03-13 09:44:00', '2025-03-13 09:44:00'),
(687, 544214350, 4, 2, '2025-03', 1, '2025-03-25 10:45:02', '2025-03-25 10:45:02'),
(688, 345504284, 7, 1, '2025-03', 1, '2025-03-31 15:12:08', '2025-03-31 15:12:08'),
(689, 393055536, 1, 5, '2025-03', 1, '2025-03-25 10:45:05', '2025-03-25 10:45:05'),
(690, 36140626, 4, 2, '2025-03', 1, '2025-03-31 15:11:17', '2025-03-31 15:11:17'),
(691, 216080184, 11, 4, '2025-04', 1, '2025-04-15 09:27:33', '2025-04-15 09:27:33'),
(692, 288519492, 16, 3, '2025-04', 1, '2025-04-10 16:50:58', '2025-04-10 16:50:58'),
(693, 36140626, 41, 1, '2025-04', 1, '2025-04-16 08:40:29', '2025-04-16 08:40:29'),
(694, 544214350, 6, 5, '2025-04', 1, '2025-04-01 07:28:27', '2025-04-01 07:28:27'),
(695, 399618577, 40, 2, '2025-04', 1, '2025-04-16 08:41:14', '2025-04-16 08:41:14'),
(696, 345504284, 6, 5, '2025-04', 1, '2025-04-10 19:26:54', '2025-04-10 19:26:54'),
(697, 751831830, 5, 7, '2025-04', 1, '2025-04-11 09:49:28', '2025-04-11 09:49:28'),
(698, 923536494, 5, 7, '2025-04', 1, '2025-04-11 09:49:41', '2025-04-11 09:49:41'),
(699, 147207293, 5, 7, '2025-04', 1, '2025-04-14 23:43:35', '2025-04-14 23:43:35'),
(700, 989256556, 5, 7, '2025-04', 1, '2025-04-15 10:06:35', '2025-04-15 10:06:35');

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2024_10_29_131524_create_admins_table', 1),
(6, '2024_11_04_122143_create_departments_table', 1),
(7, '2024_11_04_141743_create_products_table', 1),
(8, '2024_11_05_203616_create_employees_table', 1),
(9, '2024_11_15_173900_create_targets_table', 1),
(10, '2024_11_19_161901_create_points_table', 1),
(11, '2024_11_21_175849_create_department_leader_boards_table', 1),
(12, '2024_11_21_222817_create_employee_leader_boards_table', 1),
(13, '2025_02_02_100429_create_category_leader_board_table', 2),
(14, '2025_02_02_103109_add_indexes_to_tables', 2),
(15, '2025_02_21_142831_add_parent_target_to_targets_table', 3);

-- --------------------------------------------------------

--
-- Table structure for table `points`
--

CREATE TABLE `points` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employee_id` bigint(20) UNSIGNED NOT NULL,
  `department_id` bigint(20) UNSIGNED DEFAULT NULL,
  `target_id` bigint(20) UNSIGNED DEFAULT NULL,
  `category` varchar(255) NOT NULL,
  `points` int(11) NOT NULL,
  `vin_no` varchar(255) NOT NULL,
  `status` enum('Redeemed','Rejected','Pending') NOT NULL,
  `detail` varchar(255) DEFAULT NULL,
  `tenant_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `points`
--

INSERT INTO `points` (`id`, `employee_id`, `department_id`, `target_id`, `category`, `points`, `vin_no`, `status`, `detail`, `tenant_id`, `created_at`, `updated_at`) VALUES
(211, 399618577, 1, 82, 'Service Advisor', 1, '12345678', 'Redeemed', NULL, 1, '2025-03-08 14:51:09', '2025-03-13 09:43:56'),
(212, 399618577, 1, 112, 'Service Advisor', 1, '12345678', 'Redeemed', NULL, 1, '2025-03-08 14:51:09', '2025-03-13 09:44:00'),
(214, 399618577, 1, 97, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-03-09 20:59:28', '2025-03-13 09:43:53'),
(215, 544214350, 1, 254, 'Service Advisor', 1, '1GC4YPEY3MF175945', 'Redeemed', NULL, 1, '2025-03-19 17:14:19', '2025-03-19 17:14:34'),
(216, 544214350, 1, 254, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-03-20 09:30:21', '2025-03-20 09:31:43'),
(217, 345504284, 1, 254, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-03-23 11:02:43', '2025-03-23 11:09:20'),
(218, 345504284, 1, 298, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-03-23 11:02:43', '2025-03-23 11:09:23'),
(219, 393055536, 1, 254, 'Service Advisor', 1, '123', 'Redeemed', NULL, 1, '2025-03-24 15:01:07', '2025-03-25 10:45:05'),
(220, 544214350, 1, 254, 'Service Advisor', 1, '5TFHY5F18JX716131', 'Redeemed', NULL, 1, '2025-03-25 10:42:49', '2025-03-25 10:44:59'),
(221, 544214350, 1, 298, 'Service Advisor', 1, '5TFHY5F18JX716131', 'Redeemed', NULL, 1, '2025-03-25 10:42:49', '2025-03-25 10:45:02'),
(222, 36140626, 2, 301, 'Sales Agent', 1, 'add vin # here #################', 'Redeemed', NULL, 1, '2025-03-28 14:47:42', '2025-03-28 14:49:49'),
(223, 36140626, 2, 304, 'Sales Agent', 1, 'testing1234567', 'Redeemed', NULL, 1, '2025-03-31 15:08:17', '2025-03-31 15:11:11'),
(224, 36140626, 2, 301, 'Sales Agent', 1, 'vin# here', 'Redeemed', NULL, 1, '2025-03-31 15:08:34', '2025-03-31 15:11:14'),
(225, 36140626, 2, 328, 'Sales Agent', 1, 'vin# here', 'Redeemed', NULL, 1, '2025-03-31 15:08:34', '2025-03-31 15:11:17'),
(226, 345504284, 1, 307, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-03-31 15:09:43', '2025-03-31 15:12:08'),
(227, 345504284, 1, 322, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-03-31 15:09:43', '2025-03-31 15:11:57'),
(228, 345504284, 1, 319, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-03-31 15:09:43', '2025-03-31 15:12:00'),
(229, 345504284, 1, 313, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-03-31 15:09:43', '2025-03-31 15:12:03'),
(230, 345504284, 1, 316, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-03-31 15:09:43', '2025-03-31 15:12:05'),
(231, 216080184, 1, 307, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:07:09', '2025-04-01 07:14:19'),
(232, 216080184, 1, 322, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:07:09', '2025-04-01 07:14:21'),
(233, 216080184, 1, 316, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:07:09', '2025-04-01 07:14:23'),
(234, 216080184, 1, 319, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:07:09', '2025-04-01 07:14:25'),
(235, 216080184, 1, 313, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:07:09', '2025-04-01 07:14:27'),
(236, 216080184, 1, 310, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:07:09', '2025-04-01 07:14:29'),
(237, 288519492, 1, 306, 'Service Advisor', 1, 'testingtest', 'Redeemed', NULL, 1, '2025-04-01 07:13:52', '2025-04-01 07:14:32'),
(238, 288519492, 1, 321, 'Service Advisor', 1, 'testingtest', 'Redeemed', NULL, 1, '2025-04-01 07:13:52', '2025-04-01 07:14:33'),
(239, 288519492, 1, 318, 'Service Advisor', 1, 'testingtest', 'Redeemed', NULL, 1, '2025-04-01 07:13:52', '2025-04-01 07:14:35'),
(240, 288519492, 1, 315, 'Service Advisor', 1, 'testingtest', 'Redeemed', NULL, 1, '2025-04-01 07:13:52', '2025-04-01 07:14:37'),
(241, 288519492, 1, 312, 'Service Advisor', 1, 'testingtest', 'Redeemed', NULL, 1, '2025-04-01 07:13:52', '2025-04-01 07:15:35'),
(242, 288519492, 1, 309, 'Service Advisor', 1, 'testingtest', 'Redeemed', NULL, 1, '2025-04-01 07:13:52', '2025-04-01 07:15:41'),
(243, 36140626, 2, 300, 'Sales Agent', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:23:14', '2025-04-01 07:24:30'),
(244, 36140626, 2, 327, 'Sales Agent', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:23:14', '2025-04-01 07:24:27'),
(245, 36140626, 2, 303, 'Sales Agent', 1, 'add vin # here', 'Redeemed', NULL, 1, '2025-04-01 07:23:28', '2025-04-01 07:24:24'),
(246, 36140626, 2, 327, 'Sales Agent', 1, 'add vin # here', 'Redeemed', NULL, 1, '2025-04-01 07:23:28', '2025-04-01 07:24:20'),
(247, 36140626, 2, 300, 'Sales Agent', 1, 'vin# here', 'Redeemed', NULL, 1, '2025-04-01 07:23:41', '2025-04-01 07:24:17'),
(248, 36140626, 2, 327, 'Sales Agent', 1, 'vin# here', 'Redeemed', NULL, 1, '2025-04-01 07:23:41', '2025-04-01 07:24:14'),
(249, 544214350, 1, 306, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:27:23', '2025-04-01 07:28:03'),
(250, 544214350, 1, 321, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:27:23', '2025-04-01 07:28:07'),
(251, 544214350, 1, 318, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:27:23', '2025-04-01 07:28:11'),
(252, 544214350, 1, 315, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:27:23', '2025-04-01 07:28:16'),
(253, 544214350, 1, 312, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:27:23', '2025-04-01 07:28:21'),
(254, 544214350, 1, 309, 'Service Advisor', 1, 'test1234567890', 'Redeemed', NULL, 1, '2025-04-01 07:27:23', '2025-04-01 07:28:27'),
(255, 36140626, 2, 300, 'Sales Agent', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-01 10:34:47', '2025-04-11 09:46:52'),
(256, 36140626, 2, 327, 'Sales Agent', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-01 10:34:47', '2025-04-11 09:46:57'),
(257, 399618577, 1, 306, 'Service Advisor', 1, 'add vin # here', 'Redeemed', NULL, 1, '2025-04-02 09:07:35', '2025-04-02 09:09:43'),
(258, 399618577, 1, 321, 'Service Advisor', 1, 'add vin # here', 'Redeemed', NULL, 1, '2025-04-02 09:07:35', '2025-04-02 09:09:46'),
(259, 399618577, 1, 315, 'Service Advisor', 1, 'add vin # here', 'Redeemed', NULL, 1, '2025-04-02 09:07:35', '2025-04-02 09:09:49'),
(260, 399618577, 1, 312, 'Service Advisor', 1, 'add vin # here', 'Redeemed', NULL, 1, '2025-04-02 09:07:35', '2025-04-02 09:09:52'),
(261, 399618577, 1, 318, 'Service Advisor', 1, 'add vin # here', 'Redeemed', NULL, 1, '2025-04-02 09:07:35', '2025-04-02 09:09:55'),
(262, 399618577, 1, 309, 'Service Advisor', 1, 'add vin # here', 'Redeemed', NULL, 1, '2025-04-02 09:07:35', '2025-04-02 09:09:57'),
(263, 36140626, 2, 300, 'Sales Agent', 1, 'testingtest', 'Redeemed', NULL, 1, '2025-04-02 09:08:22', '2025-04-02 09:10:17'),
(264, 36140626, 2, 327, 'Sales Agent', 1, 'testingtest', 'Redeemed', NULL, 1, '2025-04-02 09:08:22', '2025-04-02 09:10:19'),
(265, 36140626, 2, 303, 'Sales Agent', 1, 'testtest', 'Redeemed', NULL, 1, '2025-04-02 09:08:45', '2025-04-02 09:10:21'),
(266, 36140626, 2, 327, 'Sales Agent', 1, 'testtest', 'Redeemed', NULL, 1, '2025-04-02 09:08:45', '2025-04-02 09:10:23'),
(267, 36140626, 2, 300, 'Sales Agent', 1, 'vin# here', 'Redeemed', NULL, 1, '2025-04-02 09:09:14', '2025-04-02 09:10:25'),
(268, 36140626, 2, 327, 'Sales Agent', 1, 'vin# here', 'Redeemed', NULL, 1, '2025-04-02 09:09:14', '2025-04-02 09:10:27'),
(269, 288519492, 1, 306, 'Service Advisor', 1, 'testingtest', 'Redeemed', NULL, 1, '2025-04-03 14:50:06', '2025-04-03 14:50:32'),
(270, 288519492, 1, 309, 'Service Advisor', 1, 'testingtest', 'Redeemed', NULL, 1, '2025-04-03 14:50:06', '2025-04-03 14:50:33'),
(271, 288519492, 1, 312, 'Service Advisor', 1, 'testingtest', 'Redeemed', NULL, 1, '2025-04-03 14:50:06', '2025-04-03 14:50:35'),
(272, 288519492, 1, 315, 'Service Advisor', 1, 'testingtest', 'Redeemed', NULL, 1, '2025-04-03 14:50:06', '2025-04-03 14:50:37'),
(273, 399618577, 1, 306, 'Service Advisor', 1, '1GC4YPEY3MF175945', 'Redeemed', NULL, 1, '2025-04-04 11:16:47', '2025-04-04 11:17:54'),
(274, 399618577, 1, 309, 'Service Advisor', 1, '1GC4YPEY3MF175945', 'Redeemed', NULL, 1, '2025-04-04 11:16:47', '2025-04-04 11:17:56'),
(275, 399618577, 1, 312, 'Service Advisor', 1, '1GC4YPEY3MF175945', 'Redeemed', NULL, 1, '2025-04-04 11:16:47', '2025-04-04 11:17:59'),
(276, 399618577, 1, 315, 'Service Advisor', 1, '1GC4YPEY3MF175945', 'Redeemed', NULL, 1, '2025-04-04 11:16:47', '2025-04-04 11:17:27'),
(277, 399618577, 1, 306, 'Service Advisor', 1, '1GC4YPEY3MF175945', 'Redeemed', NULL, 1, '2025-04-04 13:42:41', '2025-04-08 10:34:28'),
(278, 36140626, 2, 300, 'Sales Agent', 1, '4T1BF1FK3EU794476', 'Redeemed', NULL, 1, '2025-04-07 17:26:46', '2025-04-07 17:27:27'),
(279, 36140626, 2, 327, 'Sales Agent', 1, '4T1BF1FK3EU794476', 'Redeemed', NULL, 1, '2025-04-07 17:26:46', '2025-04-07 17:27:32'),
(280, 399618577, 1, 306, 'Service Advisor', 1, '123456', 'Redeemed', NULL, 1, '2025-04-07 19:58:31', '2025-04-07 19:59:22'),
(281, 399618577, 1, 309, 'Service Advisor', 1, '123456', 'Redeemed', NULL, 1, '2025-04-07 19:58:31', '2025-04-07 19:59:26'),
(282, 399618577, 1, 312, 'Service Advisor', 1, '123456', 'Redeemed', NULL, 1, '2025-04-07 19:58:31', '2025-04-07 19:59:31'),
(283, 399618577, 1, 315, 'Service Advisor', 1, '123456', 'Redeemed', NULL, 1, '2025-04-07 19:58:31', '2025-04-07 19:59:34'),
(284, 399618577, 1, 306, 'Service Advisor', 1, 'testing vin', 'Redeemed', NULL, 1, '2025-04-09 14:50:27', '2025-04-09 14:54:58'),
(285, 399618577, 1, 309, 'Service Advisor', 1, 'testing vin', 'Redeemed', NULL, 1, '2025-04-09 14:50:27', '2025-04-09 14:55:00'),
(286, 399618577, 1, 312, 'Service Advisor', 1, 'testing vin', 'Redeemed', NULL, 1, '2025-04-09 14:50:27', '2025-04-09 14:55:04'),
(287, 399618577, 1, 318, 'Service Advisor', 1, 'testing vin', 'Redeemed', NULL, 1, '2025-04-09 14:50:27', '2025-04-09 14:55:07'),
(288, 399618577, 1, 321, 'Service Advisor', 1, 'testing vin', 'Redeemed', NULL, 1, '2025-04-09 14:50:27', '2025-04-09 14:55:09'),
(289, 399618577, 1, 315, 'Service Advisor', 1, 'testing vin', 'Redeemed', NULL, 1, '2025-04-09 14:50:27', '2025-04-09 14:55:13'),
(290, 36140626, 2, 300, 'Sales Agent', 1, 'testing vin', 'Redeemed', NULL, 1, '2025-04-09 14:53:04', '2025-04-09 14:54:08'),
(291, 36140626, 2, 327, 'Sales Agent', 1, 'testing vin', 'Redeemed', NULL, 1, '2025-04-09 14:53:04', '2025-04-09 14:54:11'),
(292, 36140626, 2, 303, 'Sales Agent', 1, '12345678', 'Redeemed', NULL, 1, '2025-04-09 14:53:17', '2025-04-09 14:54:13'),
(293, 36140626, 2, 327, 'Sales Agent', 1, '12345678', 'Redeemed', NULL, 1, '2025-04-09 14:53:17', '2025-04-09 14:54:14'),
(294, 36140626, 2, 301, 'Sales Agent', 1, '87654321', 'Redeemed', NULL, 1, '2025-04-09 14:53:33', '2025-04-09 14:54:17'),
(295, 36140626, 2, 328, 'Sales Agent', 1, '87654321', 'Redeemed', NULL, 1, '2025-04-09 14:53:33', '2025-04-09 14:54:19'),
(296, 399618577, 1, 306, 'Service Advisor', 1, '5TFHY5F18JX716131', 'Redeemed', NULL, 1, '2025-04-09 17:33:00', '2025-04-09 17:33:23'),
(297, 399618577, 1, 309, 'Service Advisor', 1, '5TFHY5F18JX716131', 'Redeemed', NULL, 1, '2025-04-09 17:33:00', '2025-04-09 17:33:35'),
(298, 399618577, 1, 313, 'Service Advisor', 1, '5TFHY5F18JX716131', 'Redeemed', NULL, 1, '2025-04-09 17:33:00', '2025-04-09 17:33:37'),
(299, 399618577, 1, 309, 'Service Advisor', 1, '5gy5t43ew34', 'Redeemed', NULL, 1, '2025-04-10 15:02:01', '2025-04-10 15:05:21'),
(300, 399618577, 1, 318, 'Service Advisor', 1, '5gy5t43ew34', 'Redeemed', NULL, 1, '2025-04-10 15:02:01', '2025-04-10 15:05:24'),
(301, 399618577, 1, 315, 'Service Advisor', 1, '5gy5t43ew34', 'Redeemed', NULL, 1, '2025-04-10 15:02:01', '2025-04-10 15:05:26'),
(302, 399618577, 1, 312, 'Service Advisor', 1, '5gy5t43ew34', 'Redeemed', NULL, 1, '2025-04-10 15:02:01', '2025-04-10 15:05:28'),
(303, 36140626, 2, 300, 'Sales Agent', 1, 'testing vin', 'Redeemed', NULL, 1, '2025-04-10 15:03:17', '2025-04-10 15:03:44'),
(304, 36140626, 2, 327, 'Sales Agent', 1, 'testing vin', 'Redeemed', NULL, 1, '2025-04-10 15:03:17', '2025-04-10 15:03:46'),
(305, 288519492, 1, 307, 'Service Advisor', 1, '1GC4YPEY3MF175945', 'Redeemed', NULL, 1, '2025-04-10 16:50:31', '2025-04-10 16:50:50'),
(306, 288519492, 1, 318, 'Service Advisor', 1, '1GC4YPEY3MF175945', 'Redeemed', NULL, 1, '2025-04-10 16:50:31', '2025-04-10 16:50:52'),
(307, 288519492, 1, 321, 'Service Advisor', 1, '1GC4YPEY3MF175945', 'Redeemed', NULL, 1, '2025-04-10 16:50:31', '2025-04-10 16:50:53'),
(308, 288519492, 1, 315, 'Service Advisor', 1, '1GC4YPEY3MF175945', 'Redeemed', NULL, 1, '2025-04-10 16:50:31', '2025-04-10 16:50:54'),
(309, 288519492, 1, 312, 'Service Advisor', 1, '1GC4YPEY3MF175945', 'Redeemed', NULL, 1, '2025-04-10 16:50:31', '2025-04-10 16:50:57'),
(310, 288519492, 1, 309, 'Service Advisor', 1, '1GC4YPEY3MF175945', 'Redeemed', NULL, 1, '2025-04-10 16:50:31', '2025-04-10 16:50:58'),
(311, 345504284, 1, 307, 'Service Advisor', 1, '1GYKPPRK3RZ100923', 'Redeemed', NULL, 1, '2025-04-10 19:26:15', '2025-04-10 19:26:36'),
(312, 345504284, 1, 321, 'Service Advisor', 1, '1GYKPPRK3RZ100923', 'Redeemed', NULL, 1, '2025-04-10 19:26:15', '2025-04-10 19:26:39'),
(313, 345504284, 1, 316, 'Service Advisor', 1, '1GYKPPRK3RZ100923', 'Redeemed', NULL, 1, '2025-04-10 19:26:15', '2025-04-10 19:26:43'),
(314, 345504284, 1, 318, 'Service Advisor', 1, '1GYKPPRK3RZ100923', 'Redeemed', NULL, 1, '2025-04-10 19:26:15', '2025-04-10 19:26:45'),
(315, 345504284, 1, 313, 'Service Advisor', 1, '1GYKPPRK3RZ100923', 'Redeemed', NULL, 1, '2025-04-10 19:26:15', '2025-04-10 19:26:52'),
(316, 345504284, 1, 309, 'Service Advisor', 1, '1GYKPPRK3RZ100923', 'Redeemed', NULL, 1, '2025-04-10 19:26:15', '2025-04-10 19:26:54'),
(317, 36140626, 2, 303, 'Sales Agent', 1, '1GYKPPRK3RZ100923', 'Redeemed', NULL, 1, '2025-04-10 19:28:39', '2025-04-10 19:28:56'),
(318, 36140626, 2, 327, 'Sales Agent', 1, '1GYKPPRK3RZ100923', 'Redeemed', NULL, 1, '2025-04-10 19:28:39', '2025-04-10 19:28:59'),
(319, 36140626, 2, 300, 'Sales Agent', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:45:33', '2025-04-11 09:46:47'),
(320, 36140626, 2, 327, 'Sales Agent', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:45:33', '2025-04-11 09:46:49'),
(321, 399618577, 1, 309, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:46:02', '2025-04-11 09:46:20'),
(322, 399618577, 1, 312, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:46:02', '2025-04-11 09:46:22'),
(323, 399618577, 1, 315, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:46:02', '2025-04-11 09:46:25'),
(324, 751831830, 1, 309, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:48:25', '2025-04-11 09:49:21'),
(325, 751831830, 1, 321, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:48:25', '2025-04-11 09:49:23'),
(326, 751831830, 1, 318, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:48:25', '2025-04-11 09:49:24'),
(327, 751831830, 1, 315, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:48:25', '2025-04-11 09:49:26'),
(328, 751831830, 1, 312, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:48:25', '2025-04-11 09:49:28'),
(329, 923536494, 1, 309, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:49:08', '2025-04-11 09:49:30'),
(330, 923536494, 1, 321, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:49:08', '2025-04-11 09:49:31'),
(331, 923536494, 1, 318, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:49:08', '2025-04-11 09:49:34'),
(332, 923536494, 1, 315, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:49:08', '2025-04-11 09:49:38'),
(333, 923536494, 1, 312, 'Service Advisor', 1, 'vingoeshere', 'Redeemed', NULL, 1, '2025-04-11 09:49:08', '2025-04-11 09:49:41'),
(334, 399618577, 1, 309, 'Service Advisor', 1, '1209387645', 'Redeemed', NULL, 1, '2025-04-14 05:23:50', '2025-04-14 05:26:38'),
(335, 399618577, 1, 319, 'Service Advisor', 1, '1209387645', 'Redeemed', NULL, 1, '2025-04-14 05:23:50', '2025-04-14 05:26:41'),
(336, 399618577, 1, 321, 'Service Advisor', 1, '1209387645', 'Redeemed', NULL, 1, '2025-04-14 05:23:50', '2025-04-14 05:26:44'),
(337, 399618577, 1, 312, 'Service Advisor', 1, '1209387645', 'Redeemed', NULL, 1, '2025-04-14 05:23:50', '2025-04-14 05:26:48'),
(338, 399618577, 1, 315, 'Service Advisor', 1, '1209387645', 'Redeemed', NULL, 1, '2025-04-14 05:23:51', '2025-04-14 05:26:51'),
(339, 36140626, 2, 300, 'Sales Agent', 1, 'test', 'Redeemed', NULL, 1, '2025-04-14 05:24:35', '2025-04-14 05:25:35'),
(340, 36140626, 2, 327, 'Sales Agent', 1, 'test', 'Redeemed', NULL, 1, '2025-04-14 05:24:35', '2025-04-14 05:25:38'),
(341, 36140626, 2, 303, 'Sales Agent', 1, 'test2', 'Redeemed', NULL, 1, '2025-04-14 05:24:47', '2025-04-14 05:25:40'),
(342, 36140626, 2, 327, 'Sales Agent', 1, 'test2', 'Redeemed', NULL, 1, '2025-04-14 05:24:47', '2025-04-14 05:25:42'),
(343, 36140626, 2, 327, 'Sales Agent', 1, 'test3', 'Redeemed', NULL, 1, '2025-04-14 05:24:57', '2025-04-14 05:25:45'),
(344, 147207293, 1, 309, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-14 23:42:43', '2025-04-14 23:43:22'),
(345, 147207293, 1, 318, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-14 23:42:43', '2025-04-14 23:43:25'),
(346, 147207293, 1, 324, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-14 23:42:43', '2025-04-14 23:43:28'),
(347, 147207293, 1, 315, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-14 23:42:43', '2025-04-14 23:43:31'),
(348, 147207293, 1, 321, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-14 23:42:43', '2025-04-14 23:43:35'),
(349, 216080184, 1, 309, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 09:25:51', '2025-04-15 09:27:14'),
(350, 216080184, 1, 321, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 09:25:51', '2025-04-15 09:27:16'),
(351, 216080184, 1, 318, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 09:25:51', '2025-04-15 09:27:19'),
(352, 216080184, 1, 315, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 09:25:51', '2025-04-15 09:27:24'),
(353, 216080184, 1, 312, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 09:25:51', '2025-04-15 09:27:33'),
(354, 36140626, 2, 300, 'Sales Agent', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 09:26:27', '2025-04-15 09:26:48'),
(355, 36140626, 2, 327, 'Sales Agent', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 09:26:27', '2025-04-15 09:26:53'),
(356, 36140626, 2, 303, 'Sales Agent', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 10:03:52', '2025-04-15 10:04:40'),
(357, 36140626, 2, 327, 'Sales Agent', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 10:03:52', '2025-04-15 10:04:43'),
(358, 989256556, 1, 309, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 10:05:38', '2025-04-15 10:06:23'),
(359, 989256556, 1, 318, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 10:05:38', '2025-04-15 10:06:25'),
(360, 989256556, 1, 321, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 10:05:38', '2025-04-15 10:06:28'),
(361, 989256556, 1, 315, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 10:05:38', '2025-04-15 10:06:31'),
(362, 989256556, 1, 312, 'Service Advisor', 1, 'testing system', 'Redeemed', NULL, 1, '2025-04-15 10:05:38', '2025-04-15 10:06:35'),
(363, 399618577, 1, 309, 'Service Advisor', 1, 'testvin', 'Redeemed', NULL, 1, '2025-04-16 08:38:51', '2025-04-16 08:41:08'),
(364, 399618577, 1, 321, 'Service Advisor', 1, 'testvin', 'Redeemed', NULL, 1, '2025-04-16 08:38:51', '2025-04-16 08:41:10'),
(365, 399618577, 1, 318, 'Service Advisor', 1, 'testvin', 'Redeemed', NULL, 1, '2025-04-16 08:38:51', '2025-04-16 08:41:12'),
(366, 399618577, 1, 312, 'Service Advisor', 1, 'testvin', 'Redeemed', NULL, 1, '2025-04-16 08:38:51', '2025-04-16 08:41:14'),
(367, 36140626, 2, 300, 'Sales Agent', 1, 'testvin', 'Redeemed', NULL, 1, '2025-04-16 08:39:28', '2025-04-16 08:40:23'),
(368, 36140626, 2, 327, 'Sales Agent', 1, 'testvin', 'Redeemed', NULL, 1, '2025-04-16 08:39:28', '2025-04-16 08:40:26'),
(369, 36140626, 2, 303, 'Sales Agent', 1, 'testing vin', 'Redeemed', NULL, 1, '2025-04-16 08:39:49', '2025-04-16 08:40:28'),
(370, 36140626, 2, 327, 'Sales Agent', 1, 'testing vin', 'Redeemed', NULL, 1, '2025-04-16 08:39:49', '2025-04-16 08:40:29'),
(371, 70681879, 1, 337, 'BDC', 1, 'testing vin', 'Pending', NULL, 1, '2025-04-16 08:45:57', '2025-04-16 08:45:57');

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `number` varchar(255) NOT NULL,
  `status` enum('2','1','0') NOT NULL,
  `tenant_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `name`, `code`, `number`, `status`, `tenant_id`, `created_at`, `updated_at`) VALUES
(1, 'Fuel Injection Clean', '0001', '0001', '2', 1, '2024-12-25 20:28:05', '2024-12-25 20:28:05'),
(2, 'Brake Fluid Exchange', '0002', '0002', '2', 1, '2024-12-25 20:28:22', '2024-12-25 20:28:22'),
(3, 'Trans Fluid Exchange', '0003', '0003', '2', 1, '2024-12-25 20:29:20', '2024-12-25 20:29:20'),
(4, 'Cabin Filter', '0004', '0004', '2', 1, '2024-12-25 20:29:47', '2024-12-25 20:29:47'),
(5, 'Engine Air Filter', '0005', '0005', '2', 1, '2024-12-25 20:30:02', '2024-12-25 20:30:02'),
(6, 'Capture Lost Soul', '0006', '0006', '2', 1, '2024-12-25 20:31:12', '2024-12-25 20:31:12'),
(8, 'New Car Sale', '0008', '0008', '2', 1, '2024-12-25 20:32:04', '2024-12-25 20:32:04'),
(9, 'Used Car Sale', '0009', '0009', '2', 1, '2024-12-25 20:32:20', '2024-12-25 20:32:20'),
(10, 'Paint Protect Plan', '0010', '00012', '2', 1, '2024-12-25 20:32:46', '2025-02-05 10:45:42'),
(11, 'Service Contract', '0011', '00011', '2', 1, '2024-12-25 20:33:12', '2024-12-25 20:33:12'),
(12, 'Wheel Protect Plan', '0012', '00012', '2', 1, '2024-12-25 20:34:54', '2024-12-25 20:34:54'),
(13, 'Accessories Sale', '0013', '00013', '2', 1, '2024-12-25 20:41:26', '2024-12-25 20:41:26'),
(14, 'Oil Additive', '0014', '00014', '2', 1, '2024-12-25 20:42:33', '2024-12-25 20:42:33'),
(15, 'Fuel Additive', '0015', '00015', '2', 1, '2024-12-25 20:42:48', '2024-12-25 20:42:48'),
(18, 'Fleet Sale', '0017', '0017', '2', 1, '2025-01-06 08:11:10', '2025-02-26 07:55:39'),
(20, 'Security Alarm', '0018', '0018', '2', 1, '2025-02-26 07:54:11', '2025-02-26 07:55:31'),
(22, '12V Battery', '0020', '0020', '2', 1, '2025-02-27 07:14:44', '2025-02-27 07:15:47'),
(23, 'Sold 1 Tire', '0021', '0021', '2', 1, '2025-02-27 07:15:20', '2025-02-27 07:16:02'),
(24, 'Sold 2 Tires', '0022', '0022', '2', 1, '2025-02-27 07:16:22', '2025-02-27 07:16:22'),
(25, 'Sold 3 Tires', '0023', '0023', '2', 1, '2025-02-27 07:16:35', '2025-02-27 07:17:03'),
(26, 'Sold 4 Tires', '0024', '0024', '2', 1, '2025-02-27 07:16:52', '2025-02-27 07:16:52'),
(27, '130 Calls Goal Daily', '0025', '0025', '2', 1, '2025-03-19 08:12:11', '2025-03-19 08:12:11'),
(28, 'Alignment', '0026', '019', '2', 1, '2025-03-21 07:36:02', '2025-03-21 07:36:02');

-- --------------------------------------------------------

--
-- Table structure for table `targets`
--

CREATE TABLE `targets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `department_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `custom` varchar(255) DEFAULT NULL,
  `category` varchar(255) NOT NULL,
  `quantity` int(11) NOT NULL,
  `progress` int(11) DEFAULT NULL,
  `status` enum('0','1','2') NOT NULL,
  `last_date` date NOT NULL,
  `parent_target` text DEFAULT NULL,
  `completion_date` date DEFAULT NULL,
  `tenant_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `targets`
--

INSERT INTO `targets` (`id`, `department_id`, `product_id`, `custom`, `category`, `quantity`, `progress`, `status`, `last_date`, `parent_target`, `completion_date`, `tenant_id`, `created_at`, `updated_at`) VALUES
(3, 1, 1, NULL, 'Service Advisor', 10, 10, '1', '2025-01-12', NULL, '2025-01-17', 1, '2025-01-01 20:36:37', '2025-01-17 15:08:17'),
(4, 1, 2, NULL, 'Service Advisor', 50, 30, '1', '2025-01-12', NULL, NULL, 1, '2025-01-01 20:37:03', '2025-02-14 17:22:46'),
(6, 1, 4, NULL, 'Express Tech', 10, 1, '1', '2025-01-12', NULL, NULL, 1, '2025-01-01 20:38:05', '2025-02-14 17:23:49'),
(7, 1, 5, NULL, 'Express Tech', 10, 1, '1', '2025-01-12', NULL, NULL, 1, '2025-01-01 20:38:27', '2025-02-15 01:17:20'),
(9, 2, 8, NULL, 'Sales Agent', 10, 9, '1', '2025-12-31', NULL, NULL, 1, '2025-01-01 20:39:37', '2025-02-16 08:53:50'),
(10, 2, 9, NULL, 'Sales Agent', 10, 8, '1', '2025-12-31', NULL, NULL, 1, '2025-01-01 20:40:02', '2025-02-26 07:49:46'),
(11, 2, 13, NULL, 'Sales Agent', 10, 10, '1', '2025-12-31', NULL, '2025-01-29', 1, '2025-01-01 20:42:08', '2025-01-29 11:30:58'),
(12, 3, 14, NULL, 'Back Counter', 15, 6, '1', '2025-01-12', NULL, NULL, 1, '2025-01-01 20:43:24', '2025-02-26 07:49:53'),
(13, 3, 15, NULL, 'Back Counter', 15, 6, '1', '2025-01-12', NULL, NULL, 1, '2025-01-01 20:43:49', '2025-02-26 07:49:57'),
(16, 4, 11, NULL, 'Finance', 15, 9, '1', '2025-01-12', NULL, NULL, 1, '2025-01-01 19:05:49', '2025-02-16 08:53:35'),
(17, 4, 12, NULL, 'Finance', 15, 12, '1', '2025-01-12', NULL, NULL, 1, '2025-01-01 19:06:21', '2025-02-26 07:50:05'),
(18, 4, 10, NULL, 'Finance', 10, 8, '1', '2025-01-12', NULL, NULL, 1, '2025-01-01 19:07:00', '2025-02-16 08:53:37'),
(19, 3, NULL, 'Capture New Wholesale Account', 'All Categories', 15, NULL, '1', '2025-01-12', NULL, NULL, 1, '2025-01-01 01:51:24', '2025-02-26 07:50:00'),
(21, 1, NULL, 'call any body', 'BDC', 200000, 6, '1', '2026-03-14', NULL, NULL, 1, '2025-01-04 06:44:49', '2025-02-15 09:43:20'),
(23, 5, 18, NULL, 'Sales Team 2', 20, 10, '1', '2025-01-06', NULL, NULL, 1, '2025-01-06 08:11:50', '2025-02-16 08:53:24'),
(24, 1, 1, NULL, 'All Categories', 10, NULL, '1', '2025-12-31', NULL, NULL, 1, '2025-01-17 15:12:06', '2025-01-28 16:15:24'),
(25, 4, 12, NULL, 'Finance', 7, 2, '1', '2025-01-23', NULL, NULL, 1, '2025-01-22 14:51:08', '2025-02-26 07:50:09'),
(26, 5, 13, NULL, 'Sales Team 2', 10, NULL, '1', '2025-01-22', NULL, NULL, 1, '2025-01-22 15:30:14', '2025-02-26 07:50:23'),
(27, 1, 3, NULL, 'Repair Tech', 15, NULL, '1', '2025-01-01', NULL, NULL, 1, '2025-01-23 16:42:14', '2025-02-16 08:52:34'),
(28, 1, 1, NULL, 'Service Advisor', 10, 10, '1', '2025-12-31', NULL, '2025-02-06', 1, '2025-01-27 10:07:59', '2025-02-06 04:45:51'),
(29, 1, 3, NULL, 'Service Advisor', 10, 10, '1', '2025-12-31', NULL, '2025-02-06', 1, '2025-01-27 10:08:34', '2025-02-06 08:19:58'),
(30, 1, NULL, 'First Service Appointment', 'BDC', 10, NULL, '1', '2025-02-15', NULL, NULL, 1, '2025-02-04 15:22:37', '2025-02-15 09:18:35'),
(32, 1, 1, NULL, 'Service Advisor', 5, 4, '1', '2025-02-28', NULL, NULL, 1, '2025-02-14 09:28:42', '2025-02-17 09:51:25'),
(33, 1, NULL, 'call every old client', 'BDC', 10000, NULL, '1', '2026-08-06', NULL, NULL, 1, '2025-02-14 17:16:28', '2025-02-15 09:43:12'),
(34, 1, 2, NULL, 'Service Advisor', 50, 4, '1', '2025-02-25', NULL, NULL, 1, '2025-02-14 17:22:46', '2025-02-17 09:51:26'),
(36, 1, 4, NULL, 'Express Tech', 10, NULL, '1', '2025-02-25', NULL, NULL, 1, '2025-02-14 17:23:49', '2025-02-26 07:49:26'),
(37, 1, 5, NULL, 'Express Tech', 10, NULL, '1', '2025-02-26', NULL, NULL, 1, '2025-02-15 01:17:20', '2025-02-26 07:49:30'),
(39, 1, NULL, 'First Service Appointment', 'BDC', 10, NULL, '1', '2025-02-26', NULL, NULL, 1, '2025-02-15 09:18:35', '2025-02-16 08:53:17'),
(40, 1, 3, NULL, 'Repair Tech', 15, NULL, '1', '2025-03-11', NULL, NULL, 1, '2025-02-16 08:52:34', '2025-02-16 08:53:15'),
(41, 1, 1, NULL, 'Service Advisor', 5, NULL, '1', '2025-03-02', NULL, NULL, 1, '2025-02-16 08:52:48', '2025-02-16 08:53:05'),
(42, 1, 2, NULL, 'Service Advisor', 40, 12, '1', '2025-02-28', NULL, NULL, 1, '2025-02-16 08:52:53', '2025-02-26 07:49:35'),
(43, 1, 1, NULL, 'Service Advisor', 5, NULL, '1', '2025-03-02', NULL, NULL, 1, '2025-02-16 08:53:05', '2025-02-16 08:53:08'),
(44, 1, 1, NULL, 'Service Advisor', 5, 5, '1', '2025-02-28', NULL, '2025-02-20', 1, '2025-02-16 08:53:08', '2025-02-20 09:46:18'),
(45, 1, 3, NULL, 'Repair Tech', 15, NULL, '1', '2025-03-11', NULL, NULL, 1, '2025-02-16 08:53:15', '2025-02-26 07:49:39'),
(46, 1, NULL, 'First Service Appointment', 'BDC', 10, NULL, '1', '2025-02-27', NULL, NULL, 1, '2025-02-16 08:53:17', '2025-02-26 07:49:21'),
(47, 5, 18, NULL, 'Sales Team 2', 20, NULL, '1', '2025-02-17', NULL, NULL, 1, '2025-02-16 08:53:24', '2025-02-16 08:53:27'),
(48, 5, 18, NULL, 'Sales Team 2', 20, NULL, '1', '2025-02-17', NULL, NULL, 1, '2025-02-16 08:53:27', '2025-02-26 07:50:26'),
(50, 4, 11, NULL, 'Finance', 15, NULL, '1', '2025-02-27', NULL, NULL, 1, '2025-02-16 08:53:35', '2025-02-26 07:50:13'),
(51, 4, 10, NULL, 'Finance', 10, NULL, '1', '2025-02-27', NULL, NULL, 1, '2025-02-16 08:53:37', '2025-02-16 08:53:42'),
(53, 4, 10, NULL, 'Finance', 10, 1, '1', '2025-02-27', NULL, NULL, 1, '2025-02-16 08:53:42', '2025-02-26 07:50:19'),
(54, 2, 8, NULL, 'Sales Agent', 10, NULL, '1', '2026-02-15', NULL, NULL, 1, '2025-02-16 08:53:50', '2025-02-16 08:53:52'),
(55, 2, 8, NULL, 'Sales Agent', 10, 2, '1', '2026-02-15', NULL, NULL, 1, '2025-02-16 08:53:52', '2025-02-26 07:49:50'),
(56, 1, NULL, 'Call old customers', 'BDC', 12000, NULL, '1', '2025-06-30', NULL, NULL, 1, '2025-02-16 09:30:01', '2025-02-26 07:48:57'),
(57, 1, NULL, 'call testing', 'BDC', 24000, NULL, '1', '2026-02-16', NULL, NULL, 1, '2025-02-16 12:50:47', '2025-02-26 07:48:50'),
(58, 1, NULL, 'testing target', 'BDC', 3000, 1, '1', '2025-05-31', NULL, NULL, 1, '2025-02-16 12:54:08', '2025-02-26 07:49:02'),
(59, 5, NULL, 'Testing auto generation', 'Sales Team 2', 300, NULL, '2', '2025-03-23', 'parent', NULL, 1, '2025-02-21 14:42:04', '2025-02-21 14:42:04'),
(60, 5, NULL, 'Testing auto generation', 'Sales Team 2', 80, NULL, '1', '2025-02-28', '59', NULL, 1, '2025-02-21 14:42:04', '2025-02-26 07:50:29'),
(61, 5, NULL, 'Testing auto generation', 'Sales Team 2', 220, NULL, '1', '2025-03-23', '59', NULL, 1, '2025-03-01 00:00:00', '2025-02-21 14:42:04'),
(62, 1, NULL, 'sell any thing through calls', 'BDC', 1000, 1, '1', '2025-03-31', 'parent', NULL, 1, '2025-02-21 15:43:21', '2025-02-26 09:32:19'),
(63, 1, NULL, 'sell any thing through calls', 'BDC', 211, 1, '1', '2025-02-28', '62', NULL, 1, '2025-02-21 15:43:21', '2025-02-26 07:49:06'),
(64, 1, NULL, 'sell any thing through calls', 'BDC', 789, NULL, '1', '2025-03-31', '62', NULL, 1, '2025-03-01 00:00:00', '2025-02-21 15:43:21'),
(65, 1, 1, NULL, 'Service Advisor', 30, 4, '1', '2025-03-31', NULL, NULL, 1, '2025-02-22 14:16:44', '2025-02-26 07:49:42'),
(66, 1, NULL, 'Testing-calls', 'BDC', 12000, NULL, '1', '2026-03-31', 'parent', NULL, 1, '2025-02-26 07:22:13', '2025-02-26 09:32:15'),
(67, 1, NULL, 'Testing-calls', 'BDC', 90, NULL, '1', '2025-02-28', '66', NULL, 1, '2025-02-26 07:22:13', '2025-02-26 07:49:11'),
(68, 1, NULL, 'Testing-calls', 'BDC', 935, NULL, '1', '2025-03-31', '66', NULL, 1, '2025-03-01 00:00:00', '2025-02-26 07:22:13'),
(69, 1, NULL, 'Testing-calls', 'BDC', 905, NULL, '1', '2025-04-30', '66', NULL, 1, '2025-04-01 00:00:00', '2025-02-26 07:22:13'),
(70, 1, NULL, 'Testing-calls', 'BDC', 935, NULL, '1', '2025-05-31', '66', NULL, 1, '2025-05-01 00:00:00', '2025-02-26 07:22:13'),
(71, 1, NULL, 'Testing-calls', 'BDC', 905, NULL, '1', '2025-06-30', '66', NULL, 1, '2025-06-01 00:00:00', '2025-02-26 07:22:13'),
(72, 1, NULL, 'Testing-calls', 'BDC', 935, NULL, '1', '2025-07-31', '66', NULL, 1, '2025-07-01 00:00:00', '2025-02-26 07:22:13'),
(73, 1, NULL, 'Testing-calls', 'BDC', 935, NULL, '1', '2025-08-31', '66', NULL, 1, '2025-08-01 00:00:00', '2025-02-26 07:22:13'),
(74, 1, NULL, 'Testing-calls', 'BDC', 905, NULL, '1', '2025-09-30', '66', NULL, 1, '2025-09-01 00:00:00', '2025-02-26 07:22:13'),
(75, 1, NULL, 'Testing-calls', 'BDC', 935, NULL, '1', '2025-10-31', '66', NULL, 1, '2025-10-01 00:00:00', '2025-02-26 07:22:13'),
(76, 1, NULL, 'Testing-calls', 'BDC', 905, NULL, '1', '2025-11-30', '66', NULL, 1, '2025-11-01 00:00:00', '2025-02-26 07:22:13'),
(77, 1, NULL, 'Testing-calls', 'BDC', 935, NULL, '1', '2025-12-31', '66', NULL, 1, '2025-12-01 00:00:00', '2025-02-26 07:22:13'),
(78, 1, NULL, 'Testing-calls', 'BDC', 935, NULL, '1', '2026-01-31', '66', NULL, 1, '2026-01-01 00:00:00', '2025-02-26 07:22:13'),
(79, 1, NULL, 'Testing-calls', 'BDC', 844, NULL, '1', '2026-02-28', '66', NULL, 1, '2026-02-01 00:00:00', '2025-02-26 07:22:13'),
(80, 1, NULL, 'Testing-calls', 'BDC', 901, NULL, '1', '2026-03-31', '66', NULL, 1, '2026-03-01 00:00:00', '2025-02-26 07:22:13'),
(81, 1, 1, NULL, 'Service Advisor', 1440, NULL, '1', '2026-03-31', 'parent', NULL, 1, '2025-02-27 07:18:39', '2025-03-19 08:01:54'),
(82, 1, 1, NULL, 'Service Advisor', 7, 1, '1', '2025-02-28', '81', NULL, 1, '2025-02-27 07:18:39', '2025-03-14 07:39:04'),
(83, 1, 1, NULL, 'Service Advisor', 112, NULL, '1', '2025-03-31', '81', NULL, 1, '2025-03-01 00:00:00', '2025-02-27 07:18:39'),
(84, 1, 1, NULL, 'Service Advisor', 109, NULL, '1', '2025-04-30', '81', NULL, 1, '2025-04-01 00:00:00', '2025-02-27 07:18:39'),
(85, 1, 1, NULL, 'Service Advisor', 112, NULL, '1', '2025-05-31', '81', NULL, 1, '2025-05-01 00:00:00', '2025-02-27 07:18:39'),
(86, 1, 1, NULL, 'Service Advisor', 109, NULL, '1', '2025-06-30', '81', NULL, 1, '2025-06-01 00:00:00', '2025-02-27 07:18:39'),
(87, 1, 1, NULL, 'Service Advisor', 112, NULL, '1', '2025-07-31', '81', NULL, 1, '2025-07-01 00:00:00', '2025-02-27 07:18:39'),
(88, 1, 1, NULL, 'Service Advisor', 112, NULL, '1', '2025-08-31', '81', NULL, 1, '2025-08-01 00:00:00', '2025-02-27 07:18:39'),
(89, 1, 1, NULL, 'Service Advisor', 109, NULL, '1', '2025-09-30', '81', NULL, 1, '2025-09-01 00:00:00', '2025-02-27 07:18:39'),
(90, 1, 1, NULL, 'Service Advisor', 112, NULL, '1', '2025-10-31', '81', NULL, 1, '2025-10-01 00:00:00', '2025-02-27 07:18:39'),
(91, 1, 1, NULL, 'Service Advisor', 109, NULL, '1', '2025-11-30', '81', NULL, 1, '2025-11-01 00:00:00', '2025-02-27 07:18:39'),
(92, 1, 1, NULL, 'Service Advisor', 112, NULL, '1', '2025-12-31', '81', NULL, 1, '2025-12-01 00:00:00', '2025-02-27 07:18:39'),
(93, 1, 1, NULL, 'Service Advisor', 112, NULL, '1', '2026-01-31', '81', NULL, 1, '2026-01-01 00:00:00', '2025-02-27 07:18:39'),
(94, 1, 1, NULL, 'Service Advisor', 102, NULL, '1', '2026-02-28', '81', NULL, 1, '2026-02-01 00:00:00', '2025-02-27 07:18:39'),
(95, 1, 1, NULL, 'Service Advisor', 111, NULL, '1', '2026-03-31', '81', NULL, 1, '2026-03-01 00:00:00', '2025-02-27 07:18:39'),
(96, 1, 2, NULL, 'Service Advisor', 1440, NULL, '1', '2026-03-31', 'parent', NULL, 1, '2025-02-27 07:19:17', '2025-03-19 08:01:58'),
(97, 1, 2, NULL, 'Service Advisor', 7, 1, '1', '2025-02-28', '96', NULL, 1, '2025-02-27 07:19:17', '2025-03-14 07:40:51'),
(98, 1, 2, NULL, 'Service Advisor', 112, NULL, '1', '2025-03-31', '96', NULL, 1, '2025-03-01 00:00:00', '2025-02-27 07:19:17'),
(99, 1, 2, NULL, 'Service Advisor', 109, NULL, '1', '2025-04-30', '96', NULL, 1, '2025-04-01 00:00:00', '2025-02-27 07:19:17'),
(100, 1, 2, NULL, 'Service Advisor', 112, NULL, '1', '2025-05-31', '96', NULL, 1, '2025-05-01 00:00:00', '2025-02-27 07:19:17'),
(101, 1, 2, NULL, 'Service Advisor', 109, NULL, '1', '2025-06-30', '96', NULL, 1, '2025-06-01 00:00:00', '2025-02-27 07:19:17'),
(102, 1, 2, NULL, 'Service Advisor', 112, NULL, '1', '2025-07-31', '96', NULL, 1, '2025-07-01 00:00:00', '2025-02-27 07:19:17'),
(103, 1, 2, NULL, 'Service Advisor', 112, NULL, '1', '2025-08-31', '96', NULL, 1, '2025-08-01 00:00:00', '2025-02-27 07:19:17'),
(104, 1, 2, NULL, 'Service Advisor', 109, NULL, '1', '2025-09-30', '96', NULL, 1, '2025-09-01 00:00:00', '2025-02-27 07:19:17'),
(105, 1, 2, NULL, 'Service Advisor', 112, NULL, '1', '2025-10-31', '96', NULL, 1, '2025-10-01 00:00:00', '2025-02-27 07:19:17'),
(106, 1, 2, NULL, 'Service Advisor', 109, NULL, '1', '2025-11-30', '96', NULL, 1, '2025-11-01 00:00:00', '2025-02-27 07:19:17'),
(107, 1, 2, NULL, 'Service Advisor', 112, NULL, '1', '2025-12-31', '96', NULL, 1, '2025-12-01 00:00:00', '2025-02-27 07:19:17'),
(108, 1, 2, NULL, 'Service Advisor', 112, NULL, '1', '2026-01-31', '96', NULL, 1, '2026-01-01 00:00:00', '2025-02-27 07:19:17'),
(109, 1, 2, NULL, 'Service Advisor', 102, NULL, '1', '2026-02-28', '96', NULL, 1, '2026-02-01 00:00:00', '2025-02-27 07:19:17'),
(110, 1, 2, NULL, 'Service Advisor', 111, NULL, '1', '2026-03-31', '96', NULL, 1, '2026-03-01 00:00:00', '2025-02-27 07:19:17'),
(111, 1, 3, NULL, 'Service Advisor', 1440, NULL, '1', '2026-03-31', 'parent', NULL, 1, '2025-02-27 07:20:06', '2025-03-19 08:02:02'),
(112, 1, 3, NULL, 'Service Advisor', 7, 1, '1', '2025-02-28', '111', NULL, 1, '2025-02-27 07:20:06', '2025-03-14 07:40:55'),
(113, 1, 3, NULL, 'Service Advisor', 112, NULL, '1', '2025-03-31', '111', NULL, 1, '2025-03-01 00:00:00', '2025-02-27 07:20:06'),
(114, 1, 3, NULL, 'Service Advisor', 109, NULL, '1', '2025-04-30', '111', NULL, 1, '2025-04-01 00:00:00', '2025-02-27 07:20:06'),
(115, 1, 3, NULL, 'Service Advisor', 112, NULL, '1', '2025-05-31', '111', NULL, 1, '2025-05-01 00:00:00', '2025-02-27 07:20:06'),
(116, 1, 3, NULL, 'Service Advisor', 109, NULL, '1', '2025-06-30', '111', NULL, 1, '2025-06-01 00:00:00', '2025-02-27 07:20:06'),
(117, 1, 3, NULL, 'Service Advisor', 112, NULL, '1', '2025-07-31', '111', NULL, 1, '2025-07-01 00:00:00', '2025-02-27 07:20:06'),
(118, 1, 3, NULL, 'Service Advisor', 112, NULL, '1', '2025-08-31', '111', NULL, 1, '2025-08-01 00:00:00', '2025-02-27 07:20:06'),
(119, 1, 3, NULL, 'Service Advisor', 109, NULL, '1', '2025-09-30', '111', NULL, 1, '2025-09-01 00:00:00', '2025-02-27 07:20:06'),
(120, 1, 3, NULL, 'Service Advisor', 112, NULL, '1', '2025-10-31', '111', NULL, 1, '2025-10-01 00:00:00', '2025-02-27 07:20:06'),
(121, 1, 3, NULL, 'Service Advisor', 109, NULL, '1', '2025-11-30', '111', NULL, 1, '2025-11-01 00:00:00', '2025-02-27 07:20:06'),
(122, 1, 3, NULL, 'Service Advisor', 112, NULL, '1', '2025-12-31', '111', NULL, 1, '2025-12-01 00:00:00', '2025-02-27 07:20:06'),
(123, 1, 3, NULL, 'Service Advisor', 112, NULL, '1', '2026-01-31', '111', NULL, 1, '2026-01-01 00:00:00', '2025-02-27 07:20:06'),
(124, 1, 3, NULL, 'Service Advisor', 102, NULL, '1', '2026-02-28', '111', NULL, 1, '2026-02-01 00:00:00', '2025-02-27 07:20:06'),
(125, 1, 3, NULL, 'Service Advisor', 111, NULL, '1', '2026-03-31', '111', NULL, 1, '2026-03-01 00:00:00', '2025-02-27 07:20:06'),
(126, 1, 23, NULL, 'Service Advisor', 1440, NULL, '1', '2026-03-31', 'parent', NULL, 1, '2025-02-27 07:20:55', '2025-03-19 08:02:05'),
(127, 1, 23, NULL, 'Service Advisor', 7, NULL, '1', '2025-02-28', '126', NULL, 1, '2025-02-27 07:20:55', '2025-03-14 07:40:57'),
(128, 1, 23, NULL, 'Service Advisor', 112, NULL, '1', '2025-03-31', '126', NULL, 1, '2025-03-01 00:00:00', '2025-02-27 07:20:55'),
(129, 1, 23, NULL, 'Service Advisor', 109, NULL, '1', '2025-04-30', '126', NULL, 1, '2025-04-01 00:00:00', '2025-02-27 07:20:55'),
(130, 1, 23, NULL, 'Service Advisor', 112, NULL, '1', '2025-05-31', '126', NULL, 1, '2025-05-01 00:00:00', '2025-02-27 07:20:55'),
(131, 1, 23, NULL, 'Service Advisor', 109, NULL, '1', '2025-06-30', '126', NULL, 1, '2025-06-01 00:00:00', '2025-02-27 07:20:55'),
(132, 1, 23, NULL, 'Service Advisor', 112, NULL, '1', '2025-07-31', '126', NULL, 1, '2025-07-01 00:00:00', '2025-02-27 07:20:55'),
(133, 1, 23, NULL, 'Service Advisor', 112, NULL, '1', '2025-08-31', '126', NULL, 1, '2025-08-01 00:00:00', '2025-02-27 07:20:55'),
(134, 1, 23, NULL, 'Service Advisor', 109, NULL, '1', '2025-09-30', '126', NULL, 1, '2025-09-01 00:00:00', '2025-02-27 07:20:55'),
(135, 1, 23, NULL, 'Service Advisor', 112, NULL, '1', '2025-10-31', '126', NULL, 1, '2025-10-01 00:00:00', '2025-02-27 07:20:55'),
(136, 1, 23, NULL, 'Service Advisor', 109, NULL, '1', '2025-11-30', '126', NULL, 1, '2025-11-01 00:00:00', '2025-02-27 07:20:55'),
(137, 1, 23, NULL, 'Service Advisor', 112, NULL, '1', '2025-12-31', '126', NULL, 1, '2025-12-01 00:00:00', '2025-02-27 07:20:55'),
(138, 1, 23, NULL, 'Service Advisor', 112, NULL, '1', '2026-01-31', '126', NULL, 1, '2026-01-01 00:00:00', '2025-02-27 07:20:55'),
(139, 1, 23, NULL, 'Service Advisor', 102, NULL, '1', '2026-02-28', '126', NULL, 1, '2026-02-01 00:00:00', '2025-02-27 07:20:55'),
(140, 1, 23, NULL, 'Service Advisor', 111, NULL, '1', '2026-03-31', '126', NULL, 1, '2026-03-01 00:00:00', '2025-02-27 07:20:55'),
(141, 1, 24, NULL, 'Service Advisor', 1440, NULL, '1', '2026-03-31', 'parent', NULL, 1, '2025-02-27 07:21:21', '2025-03-19 08:02:09'),
(142, 1, 24, NULL, 'Service Advisor', 7, NULL, '1', '2025-02-28', '141', NULL, 1, '2025-02-27 07:21:21', '2025-03-14 07:41:00'),
(143, 1, 24, NULL, 'Service Advisor', 112, NULL, '1', '2025-03-31', '141', NULL, 1, '2025-03-01 00:00:00', '2025-02-27 07:21:21'),
(144, 1, 24, NULL, 'Service Advisor', 109, NULL, '1', '2025-04-30', '141', NULL, 1, '2025-04-01 00:00:00', '2025-02-27 07:21:21'),
(145, 1, 24, NULL, 'Service Advisor', 112, NULL, '1', '2025-05-31', '141', NULL, 1, '2025-05-01 00:00:00', '2025-02-27 07:21:21'),
(146, 1, 24, NULL, 'Service Advisor', 109, NULL, '1', '2025-06-30', '141', NULL, 1, '2025-06-01 00:00:00', '2025-02-27 07:21:21'),
(147, 1, 24, NULL, 'Service Advisor', 112, NULL, '1', '2025-07-31', '141', NULL, 1, '2025-07-01 00:00:00', '2025-02-27 07:21:21'),
(148, 1, 24, NULL, 'Service Advisor', 112, NULL, '1', '2025-08-31', '141', NULL, 1, '2025-08-01 00:00:00', '2025-02-27 07:21:21'),
(149, 1, 24, NULL, 'Service Advisor', 109, NULL, '1', '2025-09-30', '141', NULL, 1, '2025-09-01 00:00:00', '2025-02-27 07:21:21'),
(150, 1, 24, NULL, 'Service Advisor', 112, NULL, '1', '2025-10-31', '141', NULL, 1, '2025-10-01 00:00:00', '2025-02-27 07:21:21'),
(151, 1, 24, NULL, 'Service Advisor', 109, NULL, '1', '2025-11-30', '141', NULL, 1, '2025-11-01 00:00:00', '2025-02-27 07:21:21'),
(152, 1, 24, NULL, 'Service Advisor', 112, NULL, '1', '2025-12-31', '141', NULL, 1, '2025-12-01 00:00:00', '2025-02-27 07:21:21'),
(153, 1, 24, NULL, 'Service Advisor', 112, NULL, '1', '2026-01-31', '141', NULL, 1, '2026-01-01 00:00:00', '2025-02-27 07:21:21'),
(154, 1, 24, NULL, 'Service Advisor', 102, NULL, '1', '2026-02-28', '141', NULL, 1, '2026-02-01 00:00:00', '2025-02-27 07:21:21'),
(155, 1, 24, NULL, 'Service Advisor', 111, NULL, '1', '2026-03-31', '141', NULL, 1, '2026-03-01 00:00:00', '2025-02-27 07:21:21'),
(156, 1, 25, NULL, 'Service Advisor', 1440, NULL, '1', '2026-03-31', 'parent', NULL, 1, '2025-02-27 07:21:47', '2025-03-19 08:02:14'),
(157, 1, 25, NULL, 'Service Advisor', 7, NULL, '1', '2025-02-28', '156', NULL, 1, '2025-02-27 07:21:47', '2025-03-14 07:41:03'),
(158, 1, 25, NULL, 'Service Advisor', 112, NULL, '1', '2025-03-31', '156', NULL, 1, '2025-03-01 00:00:00', '2025-02-27 07:21:47'),
(159, 1, 25, NULL, 'Service Advisor', 109, NULL, '1', '2025-04-30', '156', NULL, 1, '2025-04-01 00:00:00', '2025-02-27 07:21:47'),
(160, 1, 25, NULL, 'Service Advisor', 112, NULL, '1', '2025-05-31', '156', NULL, 1, '2025-05-01 00:00:00', '2025-02-27 07:21:47'),
(161, 1, 25, NULL, 'Service Advisor', 109, NULL, '1', '2025-06-30', '156', NULL, 1, '2025-06-01 00:00:00', '2025-02-27 07:21:47'),
(162, 1, 25, NULL, 'Service Advisor', 112, NULL, '1', '2025-07-31', '156', NULL, 1, '2025-07-01 00:00:00', '2025-02-27 07:21:47'),
(163, 1, 25, NULL, 'Service Advisor', 112, NULL, '1', '2025-08-31', '156', NULL, 1, '2025-08-01 00:00:00', '2025-02-27 07:21:47'),
(164, 1, 25, NULL, 'Service Advisor', 109, NULL, '1', '2025-09-30', '156', NULL, 1, '2025-09-01 00:00:00', '2025-02-27 07:21:47'),
(165, 1, 25, NULL, 'Service Advisor', 112, NULL, '1', '2025-10-31', '156', NULL, 1, '2025-10-01 00:00:00', '2025-02-27 07:21:47'),
(166, 1, 25, NULL, 'Service Advisor', 109, NULL, '1', '2025-11-30', '156', NULL, 1, '2025-11-01 00:00:00', '2025-02-27 07:21:47'),
(167, 1, 25, NULL, 'Service Advisor', 112, NULL, '1', '2025-12-31', '156', NULL, 1, '2025-12-01 00:00:00', '2025-02-27 07:21:47'),
(168, 1, 25, NULL, 'Service Advisor', 112, NULL, '1', '2026-01-31', '156', NULL, 1, '2026-01-01 00:00:00', '2025-02-27 07:21:47'),
(169, 1, 25, NULL, 'Service Advisor', 102, NULL, '1', '2026-02-28', '156', NULL, 1, '2026-02-01 00:00:00', '2025-02-27 07:21:47'),
(170, 1, 25, NULL, 'Service Advisor', 111, NULL, '1', '2026-03-31', '156', NULL, 1, '2026-03-01 00:00:00', '2025-02-27 07:21:47'),
(171, 1, 26, NULL, 'Service Advisor', 1440, NULL, '1', '2026-03-31', 'parent', NULL, 1, '2025-02-27 07:22:14', '2025-03-19 08:02:18'),
(172, 1, 26, NULL, 'Service Advisor', 7, NULL, '1', '2025-02-28', '171', NULL, 1, '2025-02-27 07:22:14', '2025-03-14 07:41:08'),
(173, 1, 26, NULL, 'Service Advisor', 112, NULL, '1', '2025-03-31', '171', NULL, 1, '2025-03-01 00:00:00', '2025-02-27 07:22:14'),
(174, 1, 26, NULL, 'Service Advisor', 109, NULL, '1', '2025-04-30', '171', NULL, 1, '2025-04-01 00:00:00', '2025-02-27 07:22:14'),
(175, 1, 26, NULL, 'Service Advisor', 112, NULL, '1', '2025-05-31', '171', NULL, 1, '2025-05-01 00:00:00', '2025-02-27 07:22:14'),
(176, 1, 26, NULL, 'Service Advisor', 109, NULL, '1', '2025-06-30', '171', NULL, 1, '2025-06-01 00:00:00', '2025-02-27 07:22:14'),
(177, 1, 26, NULL, 'Service Advisor', 112, NULL, '1', '2025-07-31', '171', NULL, 1, '2025-07-01 00:00:00', '2025-02-27 07:22:14'),
(178, 1, 26, NULL, 'Service Advisor', 112, NULL, '1', '2025-08-31', '171', NULL, 1, '2025-08-01 00:00:00', '2025-02-27 07:22:14'),
(179, 1, 26, NULL, 'Service Advisor', 109, NULL, '1', '2025-09-30', '171', NULL, 1, '2025-09-01 00:00:00', '2025-02-27 07:22:14'),
(180, 1, 26, NULL, 'Service Advisor', 112, NULL, '1', '2025-10-31', '171', NULL, 1, '2025-10-01 00:00:00', '2025-02-27 07:22:14'),
(181, 1, 26, NULL, 'Service Advisor', 109, NULL, '1', '2025-11-30', '171', NULL, 1, '2025-11-01 00:00:00', '2025-02-27 07:22:14'),
(182, 1, 26, NULL, 'Service Advisor', 112, NULL, '1', '2025-12-31', '171', NULL, 1, '2025-12-01 00:00:00', '2025-02-27 07:22:14'),
(183, 1, 26, NULL, 'Service Advisor', 112, NULL, '1', '2026-01-31', '171', NULL, 1, '2026-01-01 00:00:00', '2025-02-27 07:22:14'),
(184, 1, 26, NULL, 'Service Advisor', 102, NULL, '1', '2026-02-28', '171', NULL, 1, '2026-02-01 00:00:00', '2025-02-27 07:22:14'),
(185, 1, 26, NULL, 'Service Advisor', 111, NULL, '1', '2026-03-31', '171', NULL, 1, '2026-03-01 00:00:00', '2025-02-27 07:22:14'),
(186, 1, 22, NULL, 'Service Advisor', 1440, NULL, '1', '2026-03-31', 'parent', NULL, 1, '2025-02-27 07:22:42', '2025-03-19 08:02:21'),
(187, 1, 22, NULL, 'Service Advisor', 7, NULL, '1', '2025-02-28', '186', NULL, 1, '2025-02-27 07:22:42', '2025-03-14 07:41:14'),
(188, 1, 22, NULL, 'Service Advisor', 112, NULL, '1', '2025-03-31', '186', NULL, 1, '2025-03-01 00:00:00', '2025-02-27 07:22:42'),
(189, 1, 22, NULL, 'Service Advisor', 109, NULL, '1', '2025-04-30', '186', NULL, 1, '2025-04-01 00:00:00', '2025-02-27 07:22:42'),
(190, 1, 22, NULL, 'Service Advisor', 112, NULL, '1', '2025-05-31', '186', NULL, 1, '2025-05-01 00:00:00', '2025-02-27 07:22:42'),
(191, 1, 22, NULL, 'Service Advisor', 109, NULL, '1', '2025-06-30', '186', NULL, 1, '2025-06-01 00:00:00', '2025-02-27 07:22:42'),
(192, 1, 22, NULL, 'Service Advisor', 112, NULL, '1', '2025-07-31', '186', NULL, 1, '2025-07-01 00:00:00', '2025-02-27 07:22:42'),
(193, 1, 22, NULL, 'Service Advisor', 112, NULL, '1', '2025-08-31', '186', NULL, 1, '2025-08-01 00:00:00', '2025-02-27 07:22:42'),
(194, 1, 22, NULL, 'Service Advisor', 109, NULL, '1', '2025-09-30', '186', NULL, 1, '2025-09-01 00:00:00', '2025-02-27 07:22:42'),
(195, 1, 22, NULL, 'Service Advisor', 112, NULL, '1', '2025-10-31', '186', NULL, 1, '2025-10-01 00:00:00', '2025-02-27 07:22:42'),
(196, 1, 22, NULL, 'Service Advisor', 109, NULL, '1', '2025-11-30', '186', NULL, 1, '2025-11-01 00:00:00', '2025-02-27 07:22:42'),
(197, 1, 22, NULL, 'Service Advisor', 112, NULL, '1', '2025-12-31', '186', NULL, 1, '2025-12-01 00:00:00', '2025-02-27 07:22:42'),
(198, 1, 22, NULL, 'Service Advisor', 112, NULL, '1', '2026-01-31', '186', NULL, 1, '2026-01-01 00:00:00', '2025-02-27 07:22:42'),
(199, 1, 22, NULL, 'Service Advisor', 102, NULL, '1', '2026-02-28', '186', NULL, 1, '2026-02-01 00:00:00', '2025-02-27 07:22:42'),
(200, 1, 22, NULL, 'Service Advisor', 111, NULL, '1', '2026-03-31', '186', NULL, 1, '2026-03-01 00:00:00', '2025-02-27 07:22:42'),
(216, 1, NULL, 'Testing targets', 'BDC', 123, NULL, '1', '2025-03-19', NULL, NULL, 1, '2025-03-19 14:35:13', '2025-03-19 15:16:42'),
(217, 1, 27, NULL, 'BDC', 6300, NULL, '1', '2026-04-30', 'parent', NULL, 1, '2025-03-19 15:18:51', '2025-03-19 15:24:37'),
(218, 1, 27, NULL, 'BDC', 201, NULL, '1', '2025-03-31', '217', NULL, 1, '2025-03-19 15:18:51', '2025-03-19 15:19:37'),
(219, 1, 27, NULL, 'BDC', 464, NULL, '1', '2025-04-30', '217', NULL, 1, '2025-04-01 00:00:00', '2025-03-19 15:18:51'),
(220, 1, 27, NULL, 'BDC', 480, NULL, '1', '2025-05-31', '217', NULL, 1, '2025-05-01 00:00:00', '2025-03-19 15:18:51'),
(221, 1, 27, NULL, 'BDC', 464, NULL, '1', '2025-06-30', '217', NULL, 1, '2025-06-01 00:00:00', '2025-03-19 15:18:51'),
(222, 1, 27, NULL, 'BDC', 480, NULL, '1', '2025-07-31', '217', NULL, 1, '2025-07-01 00:00:00', '2025-03-19 15:18:51'),
(223, 1, 27, NULL, 'BDC', 480, NULL, '1', '2025-08-31', '217', NULL, 1, '2025-08-01 00:00:00', '2025-03-19 15:18:51'),
(224, 1, 27, NULL, 'BDC', 464, NULL, '1', '2025-09-30', '217', NULL, 1, '2025-09-01 00:00:00', '2025-03-19 15:18:51'),
(225, 1, 27, NULL, 'BDC', 480, NULL, '1', '2025-10-31', '217', NULL, 1, '2025-10-01 00:00:00', '2025-03-19 15:18:51'),
(226, 1, 27, NULL, 'BDC', 464, NULL, '1', '2025-11-30', '217', NULL, 1, '2025-11-01 00:00:00', '2025-03-19 15:18:51'),
(227, 1, 27, NULL, 'BDC', 480, NULL, '1', '2025-12-31', '217', NULL, 1, '2025-12-01 00:00:00', '2025-03-19 15:18:51'),
(228, 1, 27, NULL, 'BDC', 480, NULL, '1', '2026-01-31', '217', NULL, 1, '2026-01-01 00:00:00', '2025-03-19 15:18:51'),
(229, 1, 27, NULL, 'BDC', 433, NULL, '1', '2026-02-28', '217', NULL, 1, '2026-02-01 00:00:00', '2025-03-19 15:18:51'),
(230, 1, 27, NULL, 'BDC', 480, NULL, '1', '2026-03-31', '217', NULL, 1, '2026-03-01 00:00:00', '2025-03-19 15:18:51'),
(231, 1, 27, NULL, 'BDC', 450, NULL, '1', '2026-04-30', '217', NULL, 1, '2026-04-01 00:00:00', '2025-03-19 15:18:51'),
(232, 1, 27, NULL, 'BDC', 3300, NULL, '1', '2026-04-30', 'parent', NULL, 1, '2025-03-19 15:20:15', '2025-03-19 15:24:40'),
(233, 1, 27, NULL, 'BDC', 105, NULL, '1', '2025-03-31', '232', NULL, 1, '2025-03-19 15:20:15', '2025-03-19 15:21:01'),
(234, 1, 27, NULL, 'BDC', 243, NULL, '1', '2025-04-30', '232', NULL, 1, '2025-04-01 00:00:00', '2025-03-19 15:20:15'),
(235, 1, 27, NULL, 'BDC', 251, NULL, '1', '2025-05-31', '232', NULL, 1, '2025-05-01 00:00:00', '2025-03-19 15:20:15'),
(236, 1, 27, NULL, 'BDC', 243, NULL, '1', '2025-06-30', '232', NULL, 1, '2025-06-01 00:00:00', '2025-03-19 15:20:15'),
(237, 1, 27, NULL, 'BDC', 251, NULL, '1', '2025-07-31', '232', NULL, 1, '2025-07-01 00:00:00', '2025-03-19 15:20:15'),
(238, 1, 27, NULL, 'BDC', 251, NULL, '1', '2025-08-31', '232', NULL, 1, '2025-08-01 00:00:00', '2025-03-19 15:20:15'),
(239, 1, 27, NULL, 'BDC', 243, NULL, '1', '2025-09-30', '232', NULL, 1, '2025-09-01 00:00:00', '2025-03-19 15:20:15'),
(240, 1, 27, NULL, 'BDC', 251, NULL, '1', '2025-10-31', '232', NULL, 1, '2025-10-01 00:00:00', '2025-03-19 15:20:15'),
(241, 1, 27, NULL, 'BDC', 243, NULL, '1', '2025-11-30', '232', NULL, 1, '2025-11-01 00:00:00', '2025-03-19 15:20:15'),
(242, 1, 27, NULL, 'BDC', 251, NULL, '1', '2025-12-31', '232', NULL, 1, '2025-12-01 00:00:00', '2025-03-19 15:20:15'),
(243, 1, 27, NULL, 'BDC', 251, NULL, '1', '2026-01-31', '232', NULL, 1, '2026-01-01 00:00:00', '2025-03-19 15:20:15'),
(244, 1, 27, NULL, 'BDC', 227, NULL, '1', '2026-02-28', '232', NULL, 1, '2026-02-01 00:00:00', '2025-03-19 15:20:15'),
(245, 1, 27, NULL, 'BDC', 251, NULL, '1', '2026-03-31', '232', NULL, 1, '2026-03-01 00:00:00', '2025-03-19 15:20:15'),
(246, 1, 27, NULL, 'BDC', 239, NULL, '1', '2026-04-30', '232', NULL, 1, '2026-04-01 00:00:00', '2025-03-19 15:20:15'),
(247, 1, 27, NULL, 'BDC', 500, NULL, '1', '2025-04-30', 'parent', NULL, 1, '2025-03-19 15:21:33', '2025-03-19 15:24:43'),
(248, 1, 27, NULL, 'BDC', 155, NULL, '1', '2025-03-31', '247', NULL, 1, '2025-03-19 15:21:33', '2025-03-26 07:30:57'),
(249, 1, 27, NULL, 'BDC', 345, NULL, '1', '2025-04-30', '247', NULL, 1, '2025-04-01 00:00:00', '2025-03-19 15:21:33'),
(250, 2, NULL, 'fuel tank', 'Sales Agent', 1000, NULL, '1', '2025-04-30', 'parent', NULL, 1, '2025-03-19 16:36:56', '2025-03-20 10:34:21'),
(251, 2, NULL, 'fuel tank', 'Sales Agent', 310, NULL, '1', '2025-03-31', '250', NULL, 1, '2025-03-19 16:36:56', '2025-03-20 10:33:49'),
(252, 2, NULL, 'fuel tank', 'Sales Agent', 690, NULL, '1', '2025-04-30', '250', NULL, 1, '2025-04-01 00:00:00', '2025-03-19 16:36:56'),
(253, 1, NULL, 'Throttle Body Clean', 'Service Advisor', 264, NULL, '1', '2025-04-30', 'parent', NULL, 1, '2025-03-19 17:13:18', '2025-03-26 07:38:36'),
(254, 1, NULL, 'Throttle Body Clean', 'Service Advisor', 82, 5, '1', '2025-03-31', '253', NULL, 1, '2025-03-19 17:13:18', '2025-03-26 07:30:52'),
(255, 1, NULL, 'Throttle Body Clean', 'Service Advisor', 182, NULL, '1', '2025-04-30', '253', NULL, 1, '2025-04-01 00:00:00', '2025-03-19 17:13:18'),
(256, 2, 8, NULL, 'Sales Agent', 250, NULL, '1', '2025-04-30', 'parent', NULL, 1, '2025-03-20 10:33:00', '2025-03-31 09:13:40'),
(257, 2, 8, NULL, 'Sales Agent', 225, NULL, '1', '2025-04-30', NULL, NULL, 1, '2025-03-20 10:33:00', '2025-03-26 07:30:43'),
(258, 2, 8, NULL, 'Sales Agent', 177, NULL, '1', '2025-04-30', '256', NULL, 1, '2025-04-01 00:00:00', '2025-03-20 10:33:00'),
(259, 2, NULL, 'used cars', 'Sales Agent', 250, NULL, '1', '2025-04-30', 'parent', NULL, 1, '2025-03-20 10:55:31', '2025-03-31 09:13:45'),
(260, 2, 9, NULL, 'Sales Agent', 225, NULL, '1', '2025-04-30', NULL, NULL, 1, '2025-03-20 10:55:31', '2025-03-26 07:30:36'),
(261, 2, NULL, 'used cars', 'Sales Agent', 177, NULL, '1', '2025-04-30', '259', NULL, 1, '2025-04-01 00:00:00', '2025-03-20 10:55:31'),
(262, 1, NULL, 'fuel injection clean', 'Service Advisor', 1400, NULL, '1', '2026-03-03', 'parent', NULL, 1, '2025-03-21 07:30:42', '2025-03-26 07:38:42'),
(263, 1, NULL, 'fuel injection clean', 'Service Advisor', 44, NULL, '1', '2025-03-31', '262', NULL, 1, '2025-03-21 07:30:42', '2025-03-23 11:00:40'),
(264, 1, NULL, 'fuel injection clean', 'Service Advisor', 121, NULL, '1', '2025-04-30', '262', NULL, 1, '2025-04-01 00:00:00', '2025-03-21 07:30:42'),
(265, 1, NULL, 'fuel injection clean', 'Service Advisor', 125, NULL, '1', '2025-05-31', '262', NULL, 1, '2025-05-01 00:00:00', '2025-03-21 07:30:42'),
(266, 1, NULL, 'fuel injection clean', 'Service Advisor', 121, NULL, '1', '2025-06-30', '262', NULL, 1, '2025-06-01 00:00:00', '2025-03-21 07:30:42'),
(267, 1, NULL, 'fuel injection clean', 'Service Advisor', 125, NULL, '1', '2025-07-31', '262', NULL, 1, '2025-07-01 00:00:00', '2025-03-21 07:30:42'),
(268, 1, NULL, 'fuel injection clean', 'Service Advisor', 125, NULL, '1', '2025-08-31', '262', NULL, 1, '2025-08-01 00:00:00', '2025-03-21 07:30:42'),
(269, 1, NULL, 'fuel injection clean', 'Service Advisor', 121, NULL, '1', '2025-09-30', '262', NULL, 1, '2025-09-01 00:00:00', '2025-03-21 07:30:42'),
(270, 1, NULL, 'fuel injection clean', 'Service Advisor', 125, NULL, '1', '2025-10-31', '262', NULL, 1, '2025-10-01 00:00:00', '2025-03-21 07:30:42'),
(271, 1, NULL, 'fuel injection clean', 'Service Advisor', 121, NULL, '1', '2025-11-30', '262', NULL, 1, '2025-11-01 00:00:00', '2025-03-21 07:30:42'),
(272, 1, NULL, 'fuel injection clean', 'Service Advisor', 125, NULL, '1', '2025-12-31', '262', NULL, 1, '2025-12-01 00:00:00', '2025-03-21 07:30:42'),
(273, 1, NULL, 'fuel injection clean', 'Service Advisor', 125, NULL, '1', '2026-01-31', '262', NULL, 1, '2026-01-01 00:00:00', '2025-03-21 07:30:42'),
(274, 1, NULL, 'fuel injection clean', 'Service Advisor', 113, NULL, '1', '2026-02-28', '262', NULL, 1, '2026-02-01 00:00:00', '2025-03-21 07:30:42'),
(275, 1, NULL, 'fuel injection clean', 'Service Advisor', 9, NULL, '1', '2026-03-03', '262', NULL, 1, '2026-03-01 00:00:00', '2025-03-21 07:30:42'),
(276, 1, NULL, 'alingment', 'Service Advisor', 100, NULL, '1', '2026-03-03', 'parent', NULL, 1, '2025-03-21 07:37:11', '2025-03-23 11:01:26'),
(277, 1, NULL, 'alingment', 'Service Advisor', 3, NULL, '1', '2025-03-31', '276', NULL, 1, '2025-03-21 07:37:11', '2025-03-23 11:00:34'),
(278, 1, NULL, 'alingment', 'Service Advisor', 9, NULL, '1', '2025-04-30', '276', NULL, 1, '2025-04-01 00:00:00', '2025-03-21 07:37:11'),
(279, 1, NULL, 'alingment', 'Service Advisor', 9, NULL, '1', '2025-05-31', '276', NULL, 1, '2025-05-01 00:00:00', '2025-03-21 07:37:11'),
(280, 1, NULL, 'alingment', 'Service Advisor', 9, NULL, '1', '2025-06-30', '276', NULL, 1, '2025-06-01 00:00:00', '2025-03-21 07:37:11'),
(281, 1, NULL, 'alingment', 'Service Advisor', 9, NULL, '1', '2025-07-31', '276', NULL, 1, '2025-07-01 00:00:00', '2025-03-21 07:37:11'),
(282, 1, NULL, 'alingment', 'Service Advisor', 9, NULL, '1', '2025-08-31', '276', NULL, 1, '2025-08-01 00:00:00', '2025-03-21 07:37:11'),
(283, 1, NULL, 'alingment', 'Service Advisor', 9, NULL, '1', '2025-09-30', '276', NULL, 1, '2025-09-01 00:00:00', '2025-03-21 07:37:11'),
(284, 1, NULL, 'alingment', 'Service Advisor', 9, NULL, '1', '2025-10-31', '276', NULL, 1, '2025-10-01 00:00:00', '2025-03-21 07:37:11'),
(285, 1, NULL, 'alingment', 'Service Advisor', 9, NULL, '1', '2025-11-30', '276', NULL, 1, '2025-11-01 00:00:00', '2025-03-21 07:37:11'),
(286, 1, NULL, 'alingment', 'Service Advisor', 9, NULL, '1', '2025-12-31', '276', NULL, 1, '2025-12-01 00:00:00', '2025-03-21 07:37:11'),
(287, 1, NULL, 'alingment', 'Service Advisor', 9, NULL, '1', '2026-01-31', '276', NULL, 1, '2026-01-01 00:00:00', '2025-03-21 07:37:11'),
(288, 1, NULL, 'alingment', 'Service Advisor', 8, NULL, '1', '2026-02-28', '276', NULL, 1, '2026-02-01 00:00:00', '2025-03-21 07:37:11'),
(289, 1, NULL, 'alingment', 'Service Advisor', -1, NULL, '1', '2026-03-03', '276', NULL, 1, '2026-03-01 00:00:00', '2025-03-21 07:37:11'),
(290, 1, 14, NULL, 'BDC', 123, NULL, '1', '2025-03-23', NULL, NULL, 1, '2025-03-22 15:19:27', '2025-03-23 11:00:14'),
(291, 1, NULL, 'Testing Target', 'BDC', 123, NULL, '1', '2025-03-23', NULL, NULL, 1, '2025-03-22 15:28:52', '2025-03-23 11:00:25'),
(292, 1, 14, NULL, 'BDC', 123, NULL, '1', '2025-03-23', NULL, NULL, 1, '2025-03-22 15:29:43', '2025-03-23 11:00:20'),
(293, 2, NULL, 'used cars', 'Sales Agent', 17, NULL, '1', '2025-03-31', '260', NULL, 1, '2025-03-23 10:59:15', '2025-03-26 07:30:33'),
(294, 2, NULL, 'used cars', 'Sales Agent', 56, NULL, '1', '2025-04-30', '260', NULL, 1, '2025-04-01 00:00:00', '2025-03-23 10:59:15'),
(295, 2, 8, NULL, 'Sales Agent', 17, NULL, '1', '2025-03-31', '257', NULL, 1, '2025-03-23 10:59:48', '2025-03-26 07:30:29'),
(296, 2, 8, NULL, 'Sales Agent', 56, NULL, '1', '2025-04-30', '257', NULL, 1, '2025-04-01 00:00:00', '2025-03-23 10:59:48'),
(297, 1, 1, NULL, 'Service Advisor', 120, NULL, '1', '2025-04-30', 'parent', NULL, 1, '2025-03-23 11:01:09', '2025-03-26 07:38:49'),
(298, 1, 1, NULL, 'Service Advisor', 28, 2, '1', '2025-03-31', '297', NULL, 1, '2025-03-23 11:01:09', '2025-03-26 07:30:47'),
(299, 1, 1, NULL, 'Service Advisor', 92, NULL, '1', '2025-04-30', '297', NULL, 1, '2025-04-01 00:00:00', '2025-03-23 11:01:09'),
(300, 2, 8, NULL, 'Sales Agent', 200, 12, '2', '2025-04-30', NULL, NULL, 1, '2025-03-26 07:40:36', '2025-04-16 08:40:23'),
(301, 2, 8, NULL, 'Sales Agent', 34, 3, '0', '2025-03-30', NULL, NULL, 1, '2025-03-26 07:40:36', '2025-04-15 10:09:46'),
(302, 2, 8, NULL, 'Sales Agent', 166, NULL, '1', '2025-04-30', '300', NULL, 1, '2025-04-01 00:00:00', '2025-03-26 07:40:36'),
(303, 2, 9, NULL, 'Sales Agent', 200, 7, '2', '2025-04-30', NULL, NULL, 1, '2025-03-31 09:14:38', '2025-04-16 08:40:28'),
(304, 2, 9, NULL, 'Sales Agent', 7, 1, '0', '2025-03-30', NULL, NULL, 1, '2025-03-31 09:14:38', '2025-04-15 10:10:01'),
(305, 2, 9, NULL, 'Sales Agent', 193, NULL, '1', '2025-04-30', '303', NULL, 1, '2025-04-01 00:00:00', '2025-03-31 09:14:38'),
(306, 1, 1, NULL, 'Service Advisor', 200, 9, '0', '2025-05-31', NULL, NULL, 1, '2025-03-31 09:15:59', '2025-04-10 07:38:16'),
(307, 1, 1, NULL, 'Service Advisor', 4, 4, '0', '2025-03-31', '306', '2025-04-10', 1, '2025-03-31 09:15:59', '2025-04-10 19:26:36'),
(308, 1, 1, NULL, 'Service Advisor', 116, NULL, '1', '2025-04-30', '306', NULL, 1, '2025-04-01 00:00:00', '2025-03-31 09:15:59'),
(309, 1, 2, NULL, 'Service Advisor', 120, 19, '2', '2025-04-30', NULL, NULL, 1, '2025-03-31 09:16:24', '2025-04-16 08:41:08'),
(310, 1, 2, NULL, 'Service Advisor', 4, 1, '0', '2025-03-30', NULL, NULL, 1, '2025-03-31 09:16:24', '2025-04-15 10:08:48'),
(311, 1, 2, NULL, 'Service Advisor', 116, NULL, '1', '2025-04-30', '309', NULL, 1, '2025-04-01 00:00:00', '2025-03-31 09:16:24'),
(312, 1, 3, NULL, 'Service Advisor', 120, 16, '2', '2025-04-30', NULL, NULL, 1, '2025-03-31 09:16:45', '2025-04-16 08:41:14'),
(313, 1, 3, NULL, 'Service Advisor', 4, 4, '0', '2025-03-31', '312', '2025-04-10', 1, '2025-03-31 09:16:45', '2025-04-10 19:26:52'),
(314, 1, 3, NULL, 'Service Advisor', 116, NULL, '1', '2025-04-30', '312', NULL, 1, '2025-04-01 00:00:00', '2025-03-31 09:16:45'),
(315, 1, 22, NULL, 'Service Advisor', 120, 16, '2', '2025-04-30', NULL, NULL, 1, '2025-03-31 09:17:17', '2025-04-15 10:06:31'),
(316, 1, 22, NULL, 'Service Advisor', 4, 3, '0', '2025-03-30', NULL, NULL, 1, '2025-03-31 09:17:17', '2025-04-15 10:09:25'),
(317, 1, 22, NULL, 'Service Advisor', 116, NULL, '1', '2025-04-30', '315', NULL, 1, '2025-04-01 00:00:00', '2025-03-31 09:17:17'),
(318, 1, 28, NULL, 'Service Advisor', 250, 13, '2', '2025-04-30', NULL, NULL, 1, '2025-03-31 09:17:46', '2025-04-16 08:41:12'),
(319, 1, 28, NULL, 'Service Advisor', 8, 3, '2', '2025-03-31', '318', NULL, 1, '2025-03-31 09:17:46', '2025-04-14 05:26:41'),
(320, 1, 28, NULL, 'Service Advisor', 242, NULL, '1', '2025-04-30', '318', NULL, 1, '2025-04-01 00:00:00', '2025-03-31 09:17:46'),
(321, 1, 26, NULL, 'Service Advisor', 120, 13, '2', '2025-04-30', NULL, NULL, 1, '2025-03-31 09:18:13', '2025-04-16 08:41:10'),
(322, 1, 26, NULL, 'Service Advisor', 4, 2, '2', '2025-03-31', '321', NULL, 1, '2025-03-31 09:18:13', '2025-04-01 07:14:21'),
(323, 1, 26, NULL, 'Service Advisor', 116, NULL, '1', '2025-04-30', '321', NULL, 1, '2025-04-01 00:00:00', '2025-03-31 09:18:13'),
(324, 1, 24, NULL, 'Service Advisor', 120, 1, '2', '2025-04-30', NULL, NULL, 1, '2025-03-31 09:18:40', '2025-04-14 23:43:28'),
(325, 1, 24, NULL, 'Service Advisor', 4, NULL, '2', '2025-03-31', '324', NULL, 1, '2025-03-31 09:18:40', '2025-03-31 09:18:40'),
(326, 1, 24, NULL, 'Service Advisor', 116, NULL, '1', '2025-04-30', '324', NULL, 1, '2025-04-01 00:00:00', '2025-03-31 09:18:40'),
(327, 2, 13, NULL, 'Sales Agent', 200, 20, '2', '2025-04-30', NULL, NULL, 1, '2025-03-31 09:19:25', '2025-04-16 08:40:29'),
(328, 2, 13, NULL, 'Sales Agent', 7, 2, '0', '2025-03-30', NULL, NULL, 1, '2025-03-31 09:19:25', '2025-04-15 10:10:10'),
(329, 2, 13, NULL, 'Sales Agent', 193, NULL, '1', '2025-04-30', '327', NULL, 1, '2025-04-01 00:00:00', '2025-03-31 09:19:25'),
(330, 3, 14, NULL, 'Back Counter', 120, NULL, '0', '2025-04-30', 'parent', NULL, 1, '2025-03-31 09:19:48', '2025-03-31 09:19:48'),
(331, 3, 14, NULL, 'Back Counter', 200, NULL, '2', '2025-04-30', NULL, NULL, 1, '2025-03-31 09:19:48', '2025-04-01 07:11:33'),
(332, 3, 14, NULL, 'Back Counter', 116, NULL, '1', '2025-04-30', '330', NULL, 1, '2025-04-01 00:00:00', '2025-03-31 09:19:48'),
(333, 3, 15, NULL, 'Back Counter', 120, NULL, '0', '2025-04-30', 'parent', NULL, 1, '2025-03-31 09:20:10', '2025-03-31 09:20:10'),
(334, 3, 15, NULL, 'Back Counter', 200, NULL, '2', '2025-04-30', NULL, NULL, 1, '2025-03-31 09:20:10', '2025-04-01 07:11:44'),
(335, 3, 15, NULL, 'Back Counter', 116, NULL, '1', '2025-04-30', '333', NULL, 1, '2025-04-01 00:00:00', '2025-03-31 09:20:10'),
(336, 4, 10, NULL, 'Finance', 200, NULL, '2', '2025-04-30', NULL, NULL, 1, '2025-04-04 13:42:00', '2025-04-04 13:42:00'),
(337, 1, 27, NULL, 'BDC', 40, NULL, '2', '2025-04-30', NULL, NULL, 1, '2025-04-15 10:11:21', '2025-04-15 10:11:21');

--
-- Indexes for table `category_leader_board`
--
ALTER TABLE `category_leader_board`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_leader_board_tenant_id_foreign` (`tenant_id`),
  ADD KEY `category_leader_board_department_id_index` (`department_id`),
  ADD KEY `category_leader_board_category_index` (`category`),
  ADD KEY `category_leader_board_earned_points_index` (`earned_points`),
  ADD KEY `category_leader_board_rank_index` (`rank`);

--
-- Indexes for table `departments`
--
ALTER TABLE `departments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `departments_slug_unique` (`slug`) USING HASH,
  ADD KEY `departments_tenant_id_foreign` (`tenant_id`);

--
-- Indexes for table `department_leader_boards`
--
ALTER TABLE `department_leader_boards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `department_leader_boards_tenant_id_foreign` (`tenant_id`),
  ADD KEY `department_leader_boards_department_id_index` (`department_id`),
  ADD KEY `department_leader_boards_earned_points_index` (`earned_points`),
  ADD KEY `department_leader_boards_rank_index` (`rank`);

--
-- Indexes for table `employee_leader_boards`
--
ALTER TABLE `employee_leader_boards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_leader_boards_tenant_id_foreign` (`tenant_id`),
  ADD KEY `employee_leader_boards_employee_id_index` (`employee_id`),
  ADD KEY `employee_leader_boards_earned_points_index` (`earned_points`),
  ADD KEY `employee_leader_boards_rank_index` (`rank`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `points`
--
ALTER TABLE `points`
  ADD PRIMARY KEY (`id`),
  ADD KEY `points_target_id_foreign` (`target_id`),
  ADD KEY `points_employee_id_index` (`employee_id`),
  ADD KEY `points_department_id_index` (`department_id`),
  ADD KEY `points_category_index` (`category`),
  ADD KEY `points_updated_at_index` (`updated_at`),
  ADD KEY `points_tenant_id_index` (`tenant_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_tenant_id_foreign` (`tenant_id`);

--
-- Indexes for table `targets`
--
ALTER TABLE `targets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `targets_product_id_foreign` (`product_id`),
  ADD KEY `targets_department_id_index` (`department_id`),
  ADD KEY `targets_category_index` (`category`),
  ADD KEY `targets_updated_at_index` (`updated_at`),
  ADD KEY `targets_tenant_id_index` (`tenant_id`);

--
-- AUTO_INCREMENT for table `category_leader_board`
--
ALTER TABLE `category_leader_board`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `departments`
--
ALTER TABLE `departments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `department_leader_boards`
--
ALTER TABLE `department_leader_boards`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=348;

--
-- AUTO_INCREMENT for table `employee_leader_boards`
--
ALTER TABLE `employee_leader_boards`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=701;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `points`
--
ALTER TABLE `points`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=372;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `targets`
--
ALTER TABLE `targets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=338;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `category_leader_board`
--
ALTER TABLE `category_leader_board`
  ADD CONSTRAINT `category_leader_board_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `category_leader_board_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `departments`
--
ALTER TABLE `departments`
  ADD CONSTRAINT `departments_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `department_leader_boards`
--
ALTER TABLE `department_leader_boards`
  ADD CONSTRAINT `department_leader_boards_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `department_leader_boards_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `employee_leader_boards`
--
ALTER TABLE `employee_leader_boards`
  ADD CONSTRAINT `employee_leader_boards_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`employee_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `employee_leader_boards_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `points`
--
ALTER TABLE `points`
  ADD CONSTRAINT `points_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `points_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`employee_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `points_target_id_foreign` FOREIGN KEY (`target_id`) REFERENCES `targets` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `points_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `targets`
--
ALTER TABLE `targets`
  ADD CONSTRAINT `targets_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `targets_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `targets_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE;
COMMIT;

