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

START TRANSACTION;



--
-- Database: `systest_jewellery`
--

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

--
-- Table structure for table `branch`
--

CREATE TABLE `branch` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint(20) NOT NULL COMMENT 'Login User Id',
  `branch_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `pincode` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT 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 `branch`
--

INSERT INTO `branch` (`id`, `uuid`, `created_by`, `branch_code`, `city`, `state`, `address`, `pincode`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'a0558459-d517-45e5-ab58-7d8b56bf91ed', 1, 'KLY', 'Kalyan', 'Maharashtra', 'Khadakpada', 421301, NULL, NULL, NULL),
(2, 'a8228f35-6241-4825-ae5b-435e11f37c66', 1, 'THN', 'Thane', 'Maharashtra', 'Manpada', 421300, NULL, NULL, NULL),
(3, 'a8228f35-6241-4825-ae5b-435e11f37c66', 1, 'MBR', 'Mumbra', 'Maharashtra', 'Manpada', 421300, NULL, NULL, NULL),
(4, 'a8228f35-6241-4825-ae5b-435e11f37c66', 1, 'MR', 'Mira Road', 'Maharashtra', 'Manpada', 421300, NULL, NULL, NULL),
(5, 'a8228f35-6241-4825-ae5b-435e11f37c66', 1, 'JOG', 'Jogeshwari', 'Maharashtra', 'Manpada', 421300, NULL, NULL, NULL),
(6, 'a8228f35-6241-4825-ae5b-435e11f37c66', 1, 'MLD', 'Malad', 'Maharashtra', 'Manpada', 421300, NULL, NULL, NULL),
(7, 'a8228f35-6241-4825-ae5b-435e11f37c66', 1, 'BND', 'Bandra', 'Maharashtra', 'Manpada', 421300, NULL, NULL, NULL),
(8, 'a8228f35-6241-4825-ae5b-435e11f37c66', 1, 'PNVL', 'Panvel', 'Maharashtra', 'Manpada', 421300, NULL, NULL, NULL),
(9, 'a8228f35-6241-4825-ae5b-435e11f37c66', 1, 'JJ', 'JJ', 'Maharashtra', 'Manpada', 421300, NULL, NULL, NULL),
(10, 'a8228f35-6241-4825-ae5b-435e11f37c66', 1, 'MNP', 'Mominpura', 'Maharashtra', 'Manpada', 421300, NULL, NULL, NULL),
(11, 'a8228f35-6241-4825-ae5b-435e11f37c66', 1, 'KND', 'Kondhwa', 'Maharashtra', 'Manpada', 421300, NULL, NULL, NULL),
(12, '43f8b0ed-7387-4879-b03e-68104b7d7aa8', 1, 'LKO', 'Lucknow', 'Uttar Pradesh', '85 Rohatas Enclave, Neelgiri Chauraha, Indira Nagar', 226016, NULL, NULL, NULL),
(13, 'dc4dd813-69d7-4907-ab86-cfe92ae02c73', 1, 'LKO', 'Lucknow', 'Uttar Pradesh', '85 Rohatas Enclave, Neelgiri Chauraha, Indira Nagar', 226016, NULL, NULL, NULL),
(14, '6649fa58-edf9-441a-b5c8-e06927444660', 1, 'LKO', 'Lucknow', 'Uttar Pradesh', '85 Rohatas Enclave, Neelgiri Chauraha, Indira Nagar\n85 Rohatas Enclave, Neelgiri Chauraha, Indira Nagar', 226016, NULL, NULL, NULL);

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

--
-- Table structure for table `branch_purchase`
--

CREATE TABLE `branch_purchase` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint(20) NOT NULL COMMENT 'Login User Id',
  `customer_id` bigint(20) NOT NULL,
  `branch_id` bigint(20) NOT NULL,
  `branch_lot_id` int(11) DEFAULT NULL,
  `invoice_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'invoice no',
  `rd` double(8,3) DEFAULT '0.000' COMMENT 'Real Diamond',
  `tq` double(8,3) DEFAULT '0.000' COMMENT '100% return gold',
  `og` double(8,3) DEFAULT '0.000' COMMENT 'old gold return',
  `cb` double(8,3) DEFAULT '0.000' COMMENT 'cancelled bill return',
  `fine` double(8,3) DEFAULT '0.000' COMMENT 'pure gold return',
  `transaction_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` enum('IN BRANCH','SENT TO HO','ACCEPTED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IN BRANCH',
  `metal_type` enum('GOLD','SILVER') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GOLD',
  `deleted_at` timestamp NULL DEFAULT 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 `branch_purchase`
--

INSERT INTO `branch_purchase` (`id`, `uuid`, `created_by`, `customer_id`, `branch_id`, `branch_lot_id`, `invoice_no`, `rd`, `tq`, `og`, `cb`, `fine`, `transaction_date`, `status`, `metal_type`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'a4d47fea-1cbe-461c-bb4f-4fba04dcc5b0', 8, 21, 1, 1, 'INV-KLY-01Dec2022_1', NULL, NULL, 1000.000, NULL, 50.000, '2022-12-01 13:00:41', 'SENT TO HO', 'GOLD', NULL, '2022-12-01 07:30:41', '2022-12-01 07:31:24'),
(2, '79a7d25d-5272-42a5-a8cd-c598d71c63a6', 8, 25, 1, 1, 'INV-KLY-01Dec2022_2', NULL, NULL, 2000.000, NULL, NULL, '2022-12-01 13:00:54', 'SENT TO HO', 'GOLD', NULL, '2022-12-01 07:30:54', '2022-12-01 07:31:24'),
(3, '2c27a7bc-6eeb-4035-b99b-4f62fdd3c30b', 8, 25, 1, 1, 'INV-KLY-01Dec2022_3', NULL, NULL, 1000.000, NULL, NULL, '2022-12-01 13:01:03', 'SENT TO HO', 'GOLD', NULL, '2022-12-01 07:31:03', '2022-12-01 07:31:24'),
(4, '53d91019-d6ae-455e-b56a-ed66d40b2fb7', 102, 66, 4, 2, 'INV-MR-03Dec2022_1', NULL, 16.330, 105.340, NULL, 10.000, '2022-12-03 15:50:46', 'SENT TO HO', 'GOLD', NULL, '2022-12-03 10:20:46', '2022-12-03 10:21:02'),
(5, '707d07a6-4e56-4640-af22-5a6b9e762899', 103, 66, 6, 3, 'INV-MLD-03Dec2022_2', NULL, 11.050, 8.440, NULL, NULL, '2022-12-03 15:51:58', 'SENT TO HO', 'GOLD', NULL, '2022-12-03 10:21:58', '2022-12-03 10:22:54'),
(6, '76ca2458-fdd0-48c8-82bf-734aa80fa9a6', 105, 66, 7, 4, 'INV-BND-03Dec2022_3', NULL, 1.740, 158.160, NULL, NULL, '2022-12-03 15:53:58', 'SENT TO HO', 'GOLD', NULL, '2022-12-03 10:23:58', '2022-12-03 10:24:01'),
(7, '66654a97-256d-42db-8a3f-4c67f6d6adee', 101, 66, 3, 5, 'INV-MBR-03Dec2022_4', NULL, NULL, 246.990, NULL, NULL, '2022-12-03 15:54:53', 'SENT TO HO', 'GOLD', NULL, '2022-12-03 10:24:53', '2022-12-03 10:27:55'),
(8, '291bf8a8-d7b7-4677-91c9-b767c955ee8b', 101, 66, 3, 5, 'INV-MBR-03Dec2022_5', 5.950, 72.770, 76.140, 7.510, 33.100, '2022-12-03 15:56:59', 'SENT TO HO', 'GOLD', NULL, '2022-12-03 10:26:59', '2022-12-03 10:27:55'),
(9, '9b9fd4ca-70e3-41f9-8b75-33a134019003', 101, 66, 3, 5, 'INV-MBR-03Dec2022_6', 1.570, 179.100, 198.400, 36.850, NULL, '2022-12-03 15:57:33', 'SENT TO HO', 'GOLD', NULL, '2022-12-03 10:27:33', '2022-12-03 10:27:55'),
(10, 'd3fd8c75-ad49-42ac-9d39-d1fcbb528eb0', 110, 66, 11, 6, 'INV-KND-03Dec2022_7', NULL, NULL, 84.840, NULL, NULL, '2022-12-03 15:59:15', 'SENT TO HO', 'GOLD', NULL, '2022-12-03 10:29:15', '2022-12-03 10:29:21'),
(11, 'b304b0e8-ffa1-4e91-bb70-9fd1bfde748a', 113, 66, 14, 7, 'INV-LKO-03Dec2022_8', NULL, NULL, 2.080, NULL, NULL, '2022-12-03 16:01:46', 'SENT TO HO', 'GOLD', NULL, '2022-12-03 10:31:46', '2022-12-03 10:32:02'),
(12, 'cfa6cab5-205b-43fe-85e5-ef4d6b4fdc65', 8, 65, 1, 8, 'INV-KLY-05Dec2022_1', NULL, NULL, 200.000, NULL, 100.000, '2022-12-05 18:12:24', 'SENT TO HO', 'GOLD', NULL, '2022-12-05 12:42:24', '2022-12-05 12:42:40'),
(13, '08de42a2-bc1c-4a13-abfe-379f62b524bd', 8, 25, 1, 9, 'INV-KLY-05Dec2022_2', NULL, NULL, 1000.000, 100.000, 100.000, '2022-12-05 19:10:32', 'SENT TO HO', 'GOLD', NULL, '2022-12-05 13:40:32', '2022-12-05 13:40:36'),
(14, 'a5cb44c1-013c-486a-bd96-d54f4be90fd3', 8, 14, 1, 10, 'INV-KLY-05Dec2022_3', NULL, NULL, 2000.000, 100.000, 200.000, '2022-12-05 19:47:47', 'SENT TO HO', 'GOLD', NULL, '2022-12-05 14:17:47', '2022-12-05 14:18:03'),
(15, '4ff4fae1-ebdb-4031-b1ac-91bf21117481', 8, 65, 1, 11, 'INV-KLY-05Dec2022_4', NULL, NULL, 1000.000, 100.000, 100.000, '2022-12-05 20:12:30', 'SENT TO HO', 'GOLD', NULL, '2022-12-05 14:42:30', '2022-12-05 14:42:33'),
(16, '76adb4d7-946e-43b6-9b5b-fe6e18400f88', 8, 25, 1, 12, 'INV-KLY-07Dec2022_1', NULL, NULL, 10000.000, 100.000, 2000.000, '2022-12-07 20:35:26', 'SENT TO HO', 'GOLD', NULL, '2022-12-07 15:05:26', '2022-12-07 15:05:57'),
(17, '706c787d-95be-45bc-8e3e-0164a4ebc05b', 8, 66, 1, 12, 'INV-KLY-07Dec2022_2', NULL, NULL, 100.000, 50.000, 100.000, '2022-12-07 20:35:48', 'SENT TO HO', 'GOLD', NULL, '2022-12-07 15:05:48', '2022-12-07 15:05:57'),
(18, '77f46d03-6332-4dda-ac2d-512405f5b524', 102, 14, 4, 13, 'INV-MR-08Dec2022_1', NULL, 16.330, 105.340, NULL, 10.000, '2022-12-08 16:28:37', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 10:58:37', '2022-12-08 10:59:00'),
(19, '2712e43c-362f-4928-b78f-1eae3563b5da', 103, 15, 6, 14, 'INV-MLD-08Dec2022_2', NULL, 11.050, 8.440, NULL, NULL, '2022-12-08 16:34:19', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 11:04:19', '2022-12-08 11:04:38'),
(20, '34f3c825-15b1-48c3-8cca-2ab1d04baef2', 105, 21, 7, 15, 'INV-BND-08Dec2022_3', NULL, 1.740, 158.160, NULL, NULL, '2022-12-08 16:35:46', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 11:05:46', '2022-12-08 11:05:50'),
(21, '7589393b-1cec-4a05-93e3-e955a406a3fe', 101, 14, 3, 16, 'INV-MBR-08Dec2022_4', 2.370, NULL, 246.990, 2.770, NULL, '2022-12-08 16:37:00', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 11:07:00', '2022-12-08 11:09:42'),
(22, '6a0e3b96-710f-457f-b0e2-f22f63ad723f', 101, 15, 3, 16, 'INV-MBR-08Dec2022_5', 3.580, 72.770, 76.140, 4.740, 33.100, '2022-12-08 16:37:51', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 11:07:51', '2022-12-08 11:09:42'),
(23, '69bdc712-99f9-459f-8eb0-cd17d103eb37', 101, 21, 3, 16, 'INV-MBR-08Dec2022_6', 1.570, 179.100, 198.400, 36.850, NULL, '2022-12-08 16:38:28', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 11:08:28', '2022-12-08 11:09:42'),
(24, '4dfc2dad-b3d7-4389-b0a8-c987511039a5', 110, 14, 11, 17, 'INV-KND-08Dec2022_7', NULL, NULL, 84.840, NULL, NULL, '2022-12-08 16:40:30', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 11:10:30', '2022-12-08 11:10:35'),
(25, 'ebbcda1c-c497-4b4f-b1be-8025f8b4f397', 113, 14, 14, 18, 'INV-LKO-08Dec2022_8', NULL, NULL, 2.080, NULL, NULL, '2022-12-08 16:41:45', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 11:11:45', '2022-12-08 11:11:48'),
(26, '6d18c619-f2b1-422e-a17c-593db57da911', 8, 66, 1, 19, 'INV-KLY-08Dec2022_9', 100.000, 100.000, 4000.000, 100.000, 100.000, '2022-12-08 17:06:49', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 11:36:49', '2022-12-08 11:37:22'),
(27, 'c4c0b35d-bef9-4de0-b766-09cce7f1ce1a', 8, 25, 1, 19, 'INV-KLY-08Dec2022_10', 100.000, 100.000, 1000.000, 100.000, 100.000, '2022-12-08 17:07:03', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 11:37:03', '2022-12-08 11:37:22'),
(28, '1fa687f3-e69d-447c-922a-42b2ebe8a75f', 8, 15, 1, 20, 'INV-KLY-08Dec2022_11', 100.000, 100.000, 1000.000, 100.000, 100.000, '2022-12-08 18:08:04', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 12:38:04', '2022-12-08 12:38:14'),
(29, '84799943-9213-48b9-abbf-f87300a87c10', 8, 15, 1, 21, 'INV-KLY-08Dec2022_12', 100.000, 100.000, 1000.000, 100.000, 100.000, '2022-12-08 18:30:11', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 13:00:11', '2022-12-08 13:00:25'),
(30, '133937d4-9d12-4097-b04d-b4676f47fddf', 8, 25, 1, 22, 'INV-KLY-08Dec2022_13', 100.000, 100.000, 1000.000, 100.000, 100.000, '2022-12-08 18:38:50', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 13:08:50', '2022-12-08 13:09:14'),
(31, '9db0f5d6-4c3d-476a-b87e-a20cebc4305e', 8, 66, 1, 22, 'INV-KLY-08Dec2022_14', 100.000, 100.000, 4000.000, 100.000, 100.000, '2022-12-08 18:39:06', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 13:09:06', '2022-12-08 13:09:14'),
(32, 'e1cc99c2-49c3-4761-ab5d-661480c4b4a3', 8, 25, 1, 23, 'INV-KLY-08Dec2022_15', 100.000, NULL, 1000.000, 100.000, 100.000, '2022-12-08 18:45:03', 'SENT TO HO', 'GOLD', NULL, '2022-12-08 13:15:03', '2022-12-08 13:15:09'),
(33, '1321cfbb-509b-42a6-b111-1ca39c7d74a5', 110, 66, 11, 24, 'INV-KND-09Dec2022_1', NULL, 30.600, 51.110, 1.920, NULL, '2022-12-09 13:25:16', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 07:55:16', '2022-12-09 09:40:43'),
(34, '632333ba-ae0e-40ca-930d-9cd776312f62', 110, 66, 11, 24, 'INV-KND-09Dec2022_2', NULL, 5.350, 40.170, 5.420, NULL, '2022-12-09 13:26:04', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 07:56:04', '2022-12-09 09:40:43'),
(35, 'c85a8858-5882-47c1-a20d-a82ebc6cce12', 110, 66, 11, 24, 'INV-KND-09Dec2022_3', NULL, 13.140, 107.680, NULL, NULL, '2022-12-09 15:07:50', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:37:50', '2022-12-09 09:40:43'),
(36, '430e6df9-ae72-4485-9451-4f8734669882', 110, 66, 11, 24, 'INV-KND-09Dec2022_4', NULL, 21.810, 24.860, NULL, NULL, '2022-12-09 15:08:13', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:38:13', '2022-12-09 09:40:43'),
(37, '38b277cd-c517-4f95-90dc-7d0966318fd3', 110, 66, 11, 24, 'INV-KND-09Dec2022_5', NULL, 13.020, 12.530, NULL, NULL, '2022-12-09 15:08:32', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:38:32', '2022-12-09 09:40:43'),
(38, '4164426f-ee95-47a1-900a-b2f614d68ba2', 110, 66, 11, 24, 'INV-KND-09Dec2022_6', NULL, 14.260, 18.080, NULL, NULL, '2022-12-09 15:08:52', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:38:52', '2022-12-09 09:40:43'),
(39, 'a11966b7-cbd9-423b-96b0-e2f3ba076cda', 110, 66, 11, 24, 'INV-KND-09Dec2022_7', NULL, 25.420, 61.960, NULL, NULL, '2022-12-09 15:09:12', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:39:12', '2022-12-09 09:40:43'),
(40, '3d439083-a20d-40e9-a39e-ffbfbdee237a', 110, 66, 11, 24, 'INV-KND-09Dec2022_8', NULL, 41.080, 13.310, NULL, NULL, '2022-12-09 15:09:33', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:39:33', '2022-12-09 09:40:43'),
(41, '8853fdbb-b074-4eb7-ace5-55dfdf572c8e', 109, 66, 10, NULL, 'INV-MNP-09Dec2022_9', NULL, 4.230, 15.660, NULL, NULL, '2022-12-09 15:12:57', 'IN BRANCH', 'GOLD', NULL, '2022-12-09 09:42:57', '2022-12-09 09:42:57'),
(42, 'dcb8e30f-1e3c-4816-990b-4be9a05e1bc4', 109, 66, 10, 25, 'INV-MNP-09Dec2022_10', NULL, 4.230, 15.660, NULL, NULL, '2022-12-09 15:13:48', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:43:48', '2022-12-09 09:48:17'),
(43, '8709e8cc-e1ea-4b75-97b5-3e64550114bf', 109, 66, 10, 25, 'INV-MNP-09Dec2022_11', NULL, 11.770, 16.630, NULL, NULL, '2022-12-09 15:15:59', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:45:59', '2022-12-09 09:48:17'),
(44, 'bf2db9aa-107a-4daa-adcb-4bd68f344a17', 109, 66, 10, 25, 'INV-MNP-09Dec2022_12', NULL, 28.140, 7.780, NULL, NULL, '2022-12-09 15:16:26', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:46:26', '2022-12-09 09:48:17'),
(45, 'be2e71a9-ce7b-4ee0-a283-df683fe994d3', 109, 66, 10, 25, 'INV-MNP-09Dec2022_13', NULL, 0.000, 28.500, NULL, NULL, '2022-12-09 15:16:38', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:46:38', '2022-12-09 09:48:17'),
(46, '55a67c77-1a4f-46e3-98b7-ce65806a4ff0', 109, 66, 10, 25, 'INV-MNP-09Dec2022_14', NULL, 3.180, 3.870, NULL, NULL, '2022-12-09 15:16:55', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:46:55', '2022-12-09 09:48:17'),
(47, '43288e90-6dcc-4530-88e0-9c51e4ca5cd7', 109, 66, 10, 25, 'INV-MNP-09Dec2022_15', NULL, 0.000, 54.050, 6.370, NULL, '2022-12-09 15:17:33', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:47:33', '2022-12-09 09:48:17'),
(48, '6f2308d7-80bb-41d1-8e72-0862969dad5f', 109, 66, 10, 25, 'INV-MNP-09Dec2022_16', NULL, 9.510, 39.160, 0.000, NULL, '2022-12-09 15:17:57', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:47:57', '2022-12-09 09:48:17'),
(49, '7ab63906-d33f-46e0-853d-79104860c921', 103, 66, 6, 26, 'INV-MLD-09Dec2022_17', NULL, NULL, 18.760, NULL, NULL, '2022-12-09 15:20:50', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:50:50', '2022-12-09 09:50:55'),
(50, '4059b1c5-5abe-47cb-b4b7-8e78ff66f6dc', 104, 66, 5, 27, 'INV-JOG-09Dec2022_18', NULL, 19.750, 37.950, NULL, NULL, '2022-12-09 15:21:54', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:51:54', '2022-12-09 09:52:53'),
(51, '6d2da398-cc84-4fa4-8a1d-823f57202d1b', 104, 66, 5, 27, 'INV-JOG-09Dec2022_19', NULL, 8.480, 445.400, NULL, 2.000, '2022-12-09 15:22:20', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:52:20', '2022-12-09 09:52:53'),
(52, '5274b98c-026b-4293-a986-ab9c9a3c6a63', 104, 66, 5, 27, 'INV-JOG-09Dec2022_20', NULL, 124.570, 151.330, NULL, 10.000, '2022-12-09 15:22:46', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:52:46', '2022-12-09 09:52:53'),
(53, 'c1c6ac2f-62a1-49d7-aaaf-787c410afb9a', 113, 66, 14, 28, 'INV-LKO-09Dec2022_21', NULL, NULL, 5.320, NULL, NULL, '2022-12-09 15:23:24', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 09:53:24', '2022-12-09 09:53:30'),
(54, 'c1341c3c-69c4-4317-8b68-0d9e2682e105', 102, 66, 4, 29, 'INV-MR-09Dec2022_22', NULL, 135.300, 144.300, NULL, NULL, '2022-12-09 15:30:06', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 10:00:06', '2022-12-09 10:02:56'),
(55, 'dfe5c36c-7202-4e3a-9eec-0fa2101afd00', 102, 66, 4, 29, 'INV-MR-09Dec2022_23', NULL, 44.040, 123.630, NULL, NULL, '2022-12-09 15:32:40', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 10:02:40', '2022-12-09 10:02:56'),
(56, 'a82a77f0-4de1-44a7-92de-135f728c3ca6', 101, 66, 3, 30, 'INV-MBR-09Dec2022_24', NULL, 51.820, 184.650, NULL, NULL, '2022-12-09 15:35:46', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 10:05:46', '2022-12-09 10:11:13'),
(57, '227e0007-59ea-45c8-9217-d5802b8f7632', 101, 66, 3, 30, 'INV-MBR-09Dec2022_25', 0.490, 66.920, 143.760, NULL, NULL, '2022-12-09 15:36:16', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 10:06:16', '2022-12-09 10:11:13'),
(58, 'e5fe54a7-77d1-47a1-94e1-51f8b2cc2051', 8, 21, 1, NULL, 'INV-KLY-09Dec2022_26', 1.000, 1.000, 20.000, 1.000, 17.000, '2022-12-09 15:47:45', 'IN BRANCH', 'GOLD', NULL, '2022-12-09 10:17:45', '2022-12-09 10:17:45'),
(59, '3d731bfe-a411-484c-b9bb-9e731e830855', 106, 66, 9, 31, 'INV-JJ-09Dec2022_27', NULL, 1.570, 9.520, NULL, NULL, '2022-12-09 16:04:13', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 10:34:13', '2022-12-09 10:38:23'),
(60, '027f82f9-c80c-4c3f-bbb2-860bf12b8142', 106, 66, 9, 31, 'INV-JJ-09Dec2022_28', 4.270, 38.780, 2.240, NULL, NULL, '2022-12-09 16:04:37', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 10:34:37', '2022-12-09 10:38:23'),
(61, '94a40ea0-1ef0-4b66-9f08-0b94210044ad', 103, 66, 6, 32, 'INV-MLD-09Dec2022_29', NULL, 3.310, 4.940, NULL, NULL, '2022-12-09 16:08:54', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 10:38:54', '2022-12-09 13:21:41'),
(62, 'add951a9-cb53-48e2-9392-085318acbecf', 103, 66, 6, 32, 'INV-MLD-09Dec2022_30', NULL, 2.960, 17.830, NULL, NULL, '2022-12-09 18:51:06', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 13:21:06', '2022-12-09 13:21:41'),
(63, '5730f0f4-da79-4a7f-8f35-c4a0568a8e67', 103, 66, 6, 32, 'INV-MLD-09Dec2022_31', NULL, 9.470, 10.070, 0.410, NULL, '2022-12-09 18:51:31', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 13:21:31', '2022-12-09 13:21:41'),
(64, '6ed341c9-18bd-4fe5-8912-a0978d08aa3e', 105, 66, 7, 33, 'INV-BND-09Dec2022_32', NULL, 4.550, 7.360, NULL, NULL, '2022-12-09 18:52:48', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 13:22:48', '2022-12-09 13:23:17'),
(65, 'a9316a78-3614-4fe6-92f5-66c607a02a9a', 105, 66, 7, 33, 'INV-BND-09Dec2022_33', NULL, 4.520, 4.350, NULL, NULL, '2022-12-09 18:53:11', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 13:23:11', '2022-12-09 13:23:17'),
(66, '564ca49f-2c56-4025-8b72-e79a79c7e771', 108, 66, 2, 34, 'INV-THN-09Dec2022_34', NULL, NULL, 31.920, NULL, NULL, '2022-12-09 18:54:06', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 13:24:06', '2022-12-09 13:24:34'),
(67, '30d6e47a-1e52-497f-9f39-b16102ed9022', 108, 66, 2, 34, 'INV-THN-09Dec2022_35', NULL, NULL, 28.760, NULL, NULL, '2022-12-09 18:54:16', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 13:24:16', '2022-12-09 13:24:34'),
(68, '33a72dd5-641e-4c27-b98b-c5d5c51fa8ba', 108, 66, 2, 34, 'INV-THN-09Dec2022_36', NULL, NULL, 117.450, NULL, NULL, '2022-12-09 18:54:26', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 13:24:26', '2022-12-09 13:24:34'),
(69, '02ecd71d-5bce-45f5-934c-e6a2cbf41827', 101, 66, 3, 35, 'INV-MBR-09Dec2022_37', NULL, 207.160, 140.160, NULL, NULL, '2022-12-09 19:08:18', 'SENT TO HO', 'GOLD', NULL, '2022-12-09 13:38:18', '2022-12-09 13:38:21'),
(70, 'd5a5c44f-ed52-4a7e-bce2-8205aa99d93f', 8, 25, 1, 36, 'INV-KLY-10Dec2022_1', 100.000, 100.000, 4000.000, 100.000, 100.000, '2022-12-10 17:18:48', 'SENT TO HO', 'GOLD', NULL, '2022-12-10 11:48:48', '2022-12-10 11:49:58'),
(71, 'd505744b-bcee-4ef8-87fb-2efd58e091a2', 105, 14, 7, 37, 'INV-BND-10Dec2022_2', 100.000, 100.000, 4000.000, 100.000, 100.000, '2022-12-10 21:23:26', 'SENT TO HO', 'GOLD', NULL, '2022-12-10 15:53:26', '2022-12-10 15:53:31'),
(72, 'e366d6c9-1876-4d9b-98c6-30f2cb1d606d', 8, 25, 1, 38, 'INV-KLY-12Dec2022_1', NULL, 100.000, 1000.000, NULL, 50.000, '2022-12-12 15:12:01', 'SENT TO HO', 'GOLD', NULL, '2022-12-12 09:42:01', '2022-12-12 09:45:30'),
(73, '455ef28f-7d69-4baf-8198-9579e5acec01', 8, 25, 1, 38, 'INV-KLY-12Dec2022_2', NULL, 100.000, 1000.000, NULL, 500.000, '2022-12-12 15:14:36', 'SENT TO HO', 'GOLD', NULL, '2022-12-12 09:44:36', '2022-12-12 09:45:30'),
(74, 'eea5f402-ff60-4caf-a19c-c271b157a44a', 8, 25, 1, 39, 'INV-KLY-13Dec2022_1', 10.000, 10.000, 1000.000, 10.000, 200.000, '2022-12-13 13:19:32', 'SENT TO HO', 'GOLD', NULL, '2022-12-13 07:49:32', '2022-12-13 07:52:01'),
(75, '796924f3-043d-4dd8-a1c6-167f7d7f7ea2', 8, 25, 1, 40, 'INV-KLY-13Dec2022_2', 100.000, 100.000, 1000.000, 100.000, 100.000, '2022-12-13 17:59:30', 'SENT TO HO', 'GOLD', NULL, '2022-12-13 12:29:30', '2022-12-13 12:30:29'),
(76, 'a5de2670-0a1f-4038-86e3-7853618d7c0a', 8, 25, 1, 40, 'INV-KLY-13Dec2022_3', 200.000, 200.000, 2000.000, 200.000, 200.000, '2022-12-13 18:00:10', 'SENT TO HO', 'GOLD', NULL, '2022-12-13 12:30:10', '2022-12-13 12:30:29'),
(77, 'f2e8b592-0ee6-490d-9339-386a98cc3cdf', 8, 65, 1, 41, 'INV-KLY-13Dec2022_4', 100.000, 100.000, 15000.000, 100.000, 100.000, '2022-12-13 18:55:52', 'SENT TO HO', 'GOLD', NULL, '2022-12-13 13:25:52', '2022-12-13 13:26:07'),
(78, 'f76fd62b-dbcc-42b5-a75d-389a2ff03c5f', 101, 14, 3, 42, 'INV-MBR-13Dec2022_5', 100.000, 100.000, 1000.000, 100.000, 100.000, '2022-12-13 19:27:43', 'SENT TO HO', 'GOLD', NULL, '2022-12-13 13:57:43', '2022-12-13 13:57:46');

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

--
-- Table structure for table `branch_purchases_lot`
--

CREATE TABLE `branch_purchases_lot` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint(20) NOT NULL COMMENT 'Login User Id',
  `branch_id` bigint(20) NOT NULL,
  `branch_lot` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_ghalai_lot_id` bigint(20) DEFAULT NULL,
  `total_rd` double(8,3) DEFAULT '0.000' COMMENT 'Real Diamond',
  `total_tq` double(8,3) DEFAULT '0.000' COMMENT '100% return gold',
  `total_og` double(8,3) DEFAULT '0.000' COMMENT 'old gold return',
  `total_cb` double(8,3) DEFAULT '0.000' COMMENT 'cancelled bill return',
  `total_fine` double(8,3) DEFAULT '0.000' COMMENT 'pure gold return',
  `transaction_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` enum('SENT TO HO','ACCEPTED','ADDED TO GHALAI LOT') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT 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 `branch_purchases_lot`
--

INSERT INTO `branch_purchases_lot` (`id`, `uuid`, `created_by`, `branch_id`, `branch_lot`, `main_ghalai_lot_id`, `total_rd`, `total_tq`, `total_og`, `total_cb`, `total_fine`, `transaction_date`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '24b0154a-44a2-46df-bcbe-65676c9555c5', 8, 1, 'KLY_01Dec2022_1', 1, 0.000, 0.000, 4000.000, 0.000, 50.000, '2022-12-01 01:01:24', 'ADDED TO GHALAI LOT', NULL, '2022-12-01 07:31:24', '2022-12-01 07:33:48'),
(2, '24913f32-7cdc-47f7-9c42-9e76de6dc5ca', 102, 4, 'MR_03Dec2022_1', 1, 0.000, 16.330, 105.340, 0.000, 10.000, '2022-12-03 03:51:02', 'ADDED TO GHALAI LOT', NULL, '2022-12-03 10:21:02', '2022-12-03 10:47:02'),
(3, '5267768d-5668-4818-8ce5-cd16c112ad15', 103, 6, 'MLD_03Dec2022_2', 1, 0.000, 11.050, 8.440, 0.000, 0.000, '2022-12-03 03:52:54', 'ADDED TO GHALAI LOT', NULL, '2022-12-03 10:22:54', '2022-12-03 10:47:02'),
(4, 'b30dc9cf-896e-40c9-a327-33765bd64ff3', 105, 7, 'BND_03Dec2022_3', 1, 0.000, 1.740, 158.160, 0.000, 0.000, '2022-12-03 03:54:01', 'ADDED TO GHALAI LOT', NULL, '2022-12-03 10:24:01', '2022-12-03 10:47:02'),
(5, '79f15483-147e-4f20-af41-d785948d9538', 101, 3, 'MBR_03Dec2022_4', 1, 7.520, 251.870, 521.530, 44.360, 33.100, '2022-12-03 03:57:55', 'ADDED TO GHALAI LOT', NULL, '2022-12-03 10:27:55', '2022-12-03 10:47:02'),
(6, 'aea8cfb1-3643-4799-b04b-4ebd9f156e13', 110, 11, 'KND_03Dec2022_5', 1, 0.000, 0.000, 84.840, 0.000, 0.000, '2022-12-03 03:59:21', 'ADDED TO GHALAI LOT', NULL, '2022-12-03 10:29:21', '2022-12-03 10:47:02'),
(7, 'ad741fa9-5de8-4d35-bcb3-2c02472a3935', 113, 14, 'LKO_03Dec2022_6', 1, 0.000, 0.000, 2.080, 0.000, 0.000, '2022-12-03 04:02:02', 'ADDED TO GHALAI LOT', NULL, '2022-12-03 10:32:02', '2022-12-03 10:47:02'),
(8, '30af77b2-3a1d-480e-9ad8-57613d2577a4', 8, 1, 'KLY_05Dec2022_1', NULL, 0.000, 0.000, 200.000, 0.000, 100.000, '2022-12-05 06:12:40', 'ADDED TO GHALAI LOT', NULL, '2022-12-05 12:42:40', '2022-12-05 13:07:50'),
(9, 'bc0b31ca-4d71-4d4a-9984-01cb035127a8', 8, 1, 'KLY_05Dec2022_2', NULL, 0.000, 0.000, 1000.000, 100.000, 100.000, '2022-12-05 07:10:36', 'ADDED TO GHALAI LOT', NULL, '2022-12-05 13:40:36', '2022-12-05 13:41:40'),
(10, '48d60f5e-d4f9-4860-8866-e06f2bd276cb', 8, 1, 'KLY_05Dec2022_3', NULL, 0.000, 0.000, 2000.000, 100.000, 200.000, '2022-12-05 07:48:03', 'ADDED TO GHALAI LOT', NULL, '2022-12-05 14:18:03', '2022-12-05 14:33:51'),
(11, '19b43cd6-e31b-4f9d-aec9-9a0854cbf397', 8, 1, 'KLY_05Dec2022_4', NULL, 0.000, 0.000, 1000.000, 100.000, 100.000, '2022-12-05 08:12:33', 'ADDED TO GHALAI LOT', NULL, '2022-12-05 14:42:33', '2022-12-05 14:43:22'),
(12, '018ba617-5849-45cc-87a2-407751c7c539', 8, 1, 'KLY_07Dec2022_1', 6, 0.000, 0.000, 10100.000, 150.000, 2100.000, '2022-12-07 08:35:57', 'ADDED TO GHALAI LOT', NULL, '2022-12-07 15:05:57', '2022-12-07 15:38:04'),
(13, '2751e743-b6b4-48e8-81fe-c5fbccc56e95', 102, 4, 'MR_08Dec2022_1', 7, 0.000, 16.330, 105.340, 0.000, 10.000, '2022-12-08 04:29:00', 'ADDED TO GHALAI LOT', NULL, '2022-12-08 10:59:00', '2022-12-08 11:19:58'),
(14, '29b7523f-af7c-44e1-9f1a-58f6673f3c2b', 103, 6, 'MLD_08Dec2022_2', 7, 0.000, 11.050, 8.440, 0.000, 0.000, '2022-12-08 04:34:37', 'ADDED TO GHALAI LOT', NULL, '2022-12-08 11:04:37', '2022-12-08 11:19:58'),
(15, '01b9a342-fefb-4cb2-b143-e424559e2168', 105, 7, 'BND_08Dec2022_3', 7, 0.000, 1.740, 158.160, 0.000, 0.000, '2022-12-08 04:35:50', 'ADDED TO GHALAI LOT', NULL, '2022-12-08 11:05:50', '2022-12-08 11:19:58'),
(16, 'dc53c7cf-1464-4da8-80b0-7e46fa91943d', 101, 3, 'MBR_08Dec2022_4', 7, 7.520, 251.870, 521.530, 44.360, 33.100, '2022-12-08 04:39:42', 'ADDED TO GHALAI LOT', NULL, '2022-12-08 11:09:42', '2022-12-08 11:19:58'),
(17, '4247ebec-92c2-4b65-b2fe-8f5dcf5f2888', 110, 11, 'KND_08Dec2022_5', 7, 0.000, 0.000, 84.840, 0.000, 0.000, '2022-12-08 04:40:35', 'ADDED TO GHALAI LOT', NULL, '2022-12-08 11:10:35', '2022-12-08 11:19:58'),
(18, '9b716b10-8185-4e5c-a346-4949ef3beff4', 113, 14, 'LKO_08Dec2022_6', 7, 0.000, 0.000, 2.080, 0.000, 0.000, '2022-12-08 04:41:48', 'ADDED TO GHALAI LOT', NULL, '2022-12-08 11:11:48', '2022-12-08 11:19:58'),
(19, '818ffeb2-f503-44db-8c19-cb553754dc3d', 8, 1, 'KLY_08Dec2022_7', NULL, 200.000, 200.000, 5000.000, 200.000, 200.000, '2022-12-08 05:07:22', 'ADDED TO GHALAI LOT', NULL, '2022-12-08 11:37:22', '2022-12-08 11:40:59'),
(20, 'bbe780ef-909e-43a9-b396-794c9914a196', 8, 1, 'KLY_08Dec2022_8', NULL, 100.000, 100.000, 1000.000, 100.000, 100.000, '2022-12-08 06:08:14', 'ADDED TO GHALAI LOT', NULL, '2022-12-08 12:38:14', '2022-12-08 12:48:15'),
(21, '302c5638-5221-4be7-b15a-fc25968bd3ee', 8, 1, 'KLY_08Dec2022_9', NULL, 100.000, 100.000, 1000.000, 100.000, 100.000, '2022-12-08 06:30:25', 'ADDED TO GHALAI LOT', NULL, '2022-12-08 13:00:25', '2022-12-08 13:01:40'),
(22, 'a5bc3215-fd8a-4fb3-a7e8-ffbbf939dfb1', 8, 1, 'KLY_08Dec2022_10', NULL, 200.000, 200.000, 5000.000, 200.000, 200.000, '2022-12-08 06:39:14', 'ADDED TO GHALAI LOT', NULL, '2022-12-08 13:09:14', '2022-12-08 13:11:18'),
(23, 'bb5aa94b-ae1e-4ed3-a903-3c20f061db4d', 8, 1, 'KLY_08Dec2022_11', NULL, 100.000, 0.000, 1000.000, 100.000, 100.000, '2022-12-08 06:45:09', 'ADDED TO GHALAI LOT', NULL, '2022-12-08 13:15:09', '2022-12-08 13:16:43'),
(24, 'ac57eefd-4203-4ac5-b756-14577aee948a', 110, 11, 'KND_09Dec2022_1', 1, 0.000, 164.680, 329.700, 7.340, 0.000, '2022-12-09 03:10:43', 'ADDED TO GHALAI LOT', NULL, '2022-12-09 09:40:43', '2022-12-09 14:57:00'),
(25, 'eb53aeb3-6ec2-47c1-9254-0ed65f33968f', 109, 10, 'MNP_09Dec2022_2', 1, 0.000, 56.830, 165.650, 6.370, 0.000, '2022-12-09 03:18:17', 'ADDED TO GHALAI LOT', NULL, '2022-12-09 09:48:17', '2022-12-09 14:57:00'),
(26, '4b25a86a-8c8b-41d2-84e9-c991ed6ace8c', 103, 6, 'MLD_09Dec2022_3', 1, 0.000, 0.000, 18.760, 0.000, 0.000, '2022-12-09 03:20:55', 'ADDED TO GHALAI LOT', NULL, '2022-12-09 09:50:55', '2022-12-09 14:57:00'),
(27, '2a2c7710-e663-49b4-94d4-df6dc46e13fa', 104, 5, 'JOG_09Dec2022_4', 1, 0.000, 152.800, 634.680, 0.000, 12.000, '2022-12-09 03:22:53', 'ADDED TO GHALAI LOT', NULL, '2022-12-09 09:52:53', '2022-12-09 14:57:00'),
(28, '94f09a68-3455-4265-9379-f245cb50ca63', 113, 14, 'LKO_09Dec2022_5', 1, 0.000, 0.000, 5.320, 0.000, 0.000, '2022-12-09 03:23:30', 'ADDED TO GHALAI LOT', NULL, '2022-12-09 09:53:30', '2022-12-09 14:57:00'),
(29, '4e3678a6-c7c5-4d6a-b04c-f89f6a687c79', 102, 4, 'MR_09Dec2022_6', 1, 0.000, 179.340, 267.930, 0.000, 0.000, '2022-12-09 03:32:56', 'ADDED TO GHALAI LOT', NULL, '2022-12-09 10:02:56', '2022-12-09 14:57:00'),
(30, 'e29af97a-b22f-42d5-9af6-9d37877c60b2', 101, 3, 'MBR_09Dec2022_7', 1, 0.490, 118.740, 328.410, 0.000, 0.000, '2022-12-09 03:41:13', 'ADDED TO GHALAI LOT', NULL, '2022-12-09 10:11:13', '2022-12-09 14:57:00'),
(31, '1697b67c-bc29-4141-8a7b-f01e0b9f6b92', 106, 9, 'JJ_09Dec2022_8', 1, 4.270, 40.350, 11.760, 0.000, 0.000, '2022-12-09 04:08:23', 'ADDED TO GHALAI LOT', NULL, '2022-12-09 10:38:23', '2022-12-09 14:57:00'),
(32, '502fc373-b467-4ccd-b270-43fadce2292e', 103, 6, 'MLD_09Dec2022_9', 1, 0.000, 15.740, 32.840, 0.410, 0.000, '2022-12-09 06:51:41', 'ADDED TO GHALAI LOT', NULL, '2022-12-09 13:21:41', '2022-12-09 14:57:00'),
(33, 'df3c3418-8d11-49a4-ab01-ecdda10b009f', 105, 7, 'BND_09Dec2022_10', 1, 0.000, 9.070, 11.710, 0.000, 0.000, '2022-12-09 06:53:17', 'ADDED TO GHALAI LOT', NULL, '2022-12-09 13:23:17', '2022-12-09 14:57:00'),
(34, '7df46b3c-562b-4d9c-8ce2-81d684dd792b', 108, 2, 'THN_09Dec2022_11', 1, 0.000, 0.000, 178.130, 0.000, 0.000, '2022-12-09 06:54:34', 'ADDED TO GHALAI LOT', NULL, '2022-12-09 13:24:34', '2022-12-09 14:57:00'),
(35, '1191db7b-2bfe-4969-8966-f1e68aeb621b', 101, 3, 'MBR_09Dec2022_12', 2, 0.000, 207.160, 140.160, 0.000, 0.000, '2022-12-09 07:08:21', 'ADDED TO GHALAI LOT', NULL, '2022-12-09 13:38:21', '2022-12-09 14:57:34'),
(36, '7bd9e13e-4815-4ebb-a705-d2a54ea53291', 8, 1, 'KLY_10Dec2022_1', 3, 100.000, 100.000, 4000.000, 100.000, 100.000, '2022-12-10 05:19:58', 'ADDED TO GHALAI LOT', NULL, '2022-12-10 11:49:58', '2022-12-10 11:51:41'),
(37, 'b7cce2ac-0ec5-4f6f-9663-b9d163ca611f', 105, 7, 'BND_10Dec2022_2', 4, 100.000, 100.000, 4000.000, 100.000, 100.000, '2022-12-10 09:23:31', 'ADDED TO GHALAI LOT', NULL, '2022-12-10 15:53:31', '2022-12-10 15:56:09'),
(38, '52f64117-f505-4dec-98ea-0fac9f6ab0af', 8, 1, 'KLY_12Dec2022_1', NULL, 0.000, 200.000, 2000.000, 0.000, 550.000, '2022-12-12 03:15:30', 'ADDED TO GHALAI LOT', NULL, '2022-12-12 09:45:30', '2022-12-12 09:50:38'),
(39, '7c882f34-729b-492b-9af0-3a2331655970', 8, 1, 'KLY_13Dec2022_1', NULL, 10.000, 10.000, 1000.000, 10.000, 200.000, '2022-12-13 01:22:01', 'ACCEPTED', NULL, '2022-12-13 07:52:01', '2022-12-13 07:53:05'),
(40, '94b1becc-d3f4-4d7b-9041-5601771dfdc8', 8, 1, 'KLY_13Dec2022_2', 6, 300.000, 300.000, 3000.000, 300.000, 300.000, '2022-12-13 06:00:29', 'ADDED TO GHALAI LOT', NULL, '2022-12-13 12:30:29', '2022-12-13 12:41:28'),
(41, '9bb5d385-b0a6-4c7d-a8fa-f6b8581736da', 8, 1, 'KLY_13Dec2022_3', 7, 100.000, 100.000, 15000.000, 100.000, 100.000, '2022-12-13 06:56:07', 'ADDED TO GHALAI LOT', NULL, '2022-12-13 13:26:07', '2022-12-13 13:36:44'),
(42, '09bbea24-1436-411d-b41a-af96c3bf2633', 101, 3, 'MBR_13Dec2022_4', 8, 100.000, 100.000, 1000.000, 100.000, 100.000, '2022-12-13 07:27:46', 'ADDED TO GHALAI LOT', NULL, '2022-12-13 13:57:46', '2022-12-13 15:00:28');

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

--
-- Table structure for table `bullion_vendor_sold_langdi`
--

CREATE TABLE `bullion_vendor_sold_langdi` (
  `id` bigint(20) NOT NULL,
  `uuid` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `vendor_id` bigint(36) NOT NULL,
  `type` enum('Sell Fine','Purchase Fine') DEFAULT NULL,
  `fine` double(10,3) DEFAULT NULL,
  `per_gm_rate` double(10,3) DEFAULT NULL,
  `amount` double(10,3) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `bullion_vendor_transaction`
--

CREATE TABLE `bullion_vendor_transaction` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint(20) NOT NULL COMMENT 'Login User Id',
  `updated_by` bigint(20) DEFAULT NULL COMMENT 'login user id',
  `vendor_id` bigint(20) NOT NULL,
  `langadi` double(8,3) DEFAULT NULL,
  `estimate_fine` double(8,2) DEFAULT NULL COMMENT 'In Percent',
  `estimate_tounch_percent` double(8,3) DEFAULT NULL,
  `actual_report_in_percent` double(8,2) DEFAULT NULL COMMENT 'In Percent',
  `actual_fine` double(8,3) DEFAULT NULL,
  `fine_received` double(16,3) DEFAULT '0.000',
  `transaction_details` text COLLATE utf8mb4_unicode_ci,
  `transaction_amount` bigint(20) DEFAULT NULL,
  `transaction_type` enum('GOLD','CASH','CHEQUE','CARD','UPI','INTERNET_BANKING','WALLET') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_date` datetime NOT NULL,
  `credit_debit` enum('CREDIT','DEBIT','FINE','PAY','RECEIVED') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metal_type` enum('GOLD','SILVER') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GOLD',
  `per_gm_rate` double(10,3) DEFAULT NULL,
  `amount` double(10,3) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bullion_vendor_transaction`
--

INSERT INTO `bullion_vendor_transaction` (`id`, `uuid`, `created_by`, `updated_by`, `vendor_id`, `langadi`, `estimate_fine`, `estimate_tounch_percent`, `actual_report_in_percent`, `actual_fine`, `fine_received`, `transaction_details`, `transaction_amount`, `transaction_type`, `transaction_date`, `credit_debit`, `metal_type`, `per_gm_rate`, `amount`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'bb089fc1-3719-4c7d-b395-64898c5b48de', 6, NULL, 10, 1146.010, NULL, NULL, 81.88, 938.353, 0.000, NULL, NULL, 'GOLD', '2022-12-09 08:35:51', 'DEBIT', 'GOLD', NULL, NULL, NULL, '2022-12-09 15:05:51', '2022-12-10 15:50:45'),
(2, '1ed5185e-c9b7-4ade-af79-cb588b08c5f4', 6, NULL, 10, 3948.500, 3200.00, 81.043, NULL, NULL, 0.000, NULL, NULL, 'GOLD', '2022-12-10 09:26:46', 'DEBIT', 'GOLD', NULL, NULL, NULL, '2022-12-10 15:56:46', '2022-12-10 15:56:46'),
(3, 'ade50963-7950-4834-bb33-abb31ef11562', 6, NULL, 10, NULL, NULL, NULL, NULL, NULL, 60.000, NULL, NULL, 'GOLD', '2022-12-13 06:35:04', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-13 13:05:04', '2022-12-13 13:05:04'),
(4, 'a820572e-8b52-4ca9-9bf4-9fe1e17821f2', 6, NULL, 10, 1970.000, 1600.00, 81.218, NULL, NULL, 0.000, NULL, NULL, 'GOLD', '2022-12-13 06:40:38', 'DEBIT', 'GOLD', NULL, NULL, NULL, '2022-12-13 13:10:38', '2022-12-13 13:10:38'),
(5, 'ae310e62-5e16-42a0-a88a-0d0eaa2a6cdb', 6, NULL, 98, 1250.000, 1100.00, 88.000, 90.00, 1125.000, 0.000, NULL, NULL, 'GOLD', '2022-12-13 06:41:51', 'DEBIT', 'GOLD', NULL, NULL, NULL, '2022-12-13 13:11:51', '2022-12-13 13:14:02'),
(6, '411a763e-b18c-46bf-9244-89e782465578', 6, NULL, 98, 1970.000, 1850.00, 93.909, 85.00, 1674.500, 0.000, NULL, NULL, 'GOLD', '2022-12-13 06:41:51', 'DEBIT', 'GOLD', NULL, NULL, NULL, '2022-12-13 13:11:51', '2022-12-13 13:15:37'),
(7, '06fea757-758d-4183-a9e8-9c13c1f87db3', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -175.000, NULL, NULL, 'GOLD', '2022-12-13 06:46:57', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-13 13:16:57', '2022-12-13 13:16:57'),
(8, '194ae62c-44b0-4781-8b4c-a3a465990a9b', 6, NULL, 98, 6980.000, 6500.00, 93.123, 85.00, 5933.000, 0.000, NULL, NULL, 'GOLD', '2022-12-13 07:08:45', 'DEBIT', 'GOLD', NULL, NULL, NULL, '2022-12-13 13:38:45', '2022-12-13 13:41:29'),
(9, 'f0ed0cd9-f114-46c3-bb7e-3fae6e4ac8c5', 6, NULL, 98, 7880.000, 7500.00, 95.178, 90.00, 7092.000, 0.000, NULL, NULL, 'GOLD', '2022-12-13 07:08:45', 'DEBIT', 'GOLD', NULL, NULL, NULL, '2022-12-13 13:38:45', '2022-12-13 13:40:06'),
(10, '22b3c92a-3c95-4f0a-85f7-b2db2cc84139', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -100.000, NULL, NULL, 'GOLD', '2022-12-13 07:12:27', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-13 13:42:27', '2022-12-13 13:42:27'),
(11, '6eb07f87-d375-429e-800e-aaa90cf4c281', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -50.000, NULL, NULL, 'GOLD', '2022-12-14 01:58:27', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 08:28:27', '2022-12-14 08:28:27'),
(12, '0e565ccb-9923-42f9-828b-24d1935d9a88', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -50.000, NULL, NULL, 'GOLD', '2022-12-14 01:58:45', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 08:28:45', '2022-12-14 08:28:45'),
(13, '93de41ce-65e8-42db-b30c-4e5d21ff2ab0', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -25.000, NULL, NULL, 'GOLD', '2022-12-14 02:57:38', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 09:27:38', '2022-12-14 09:27:38'),
(14, 'ebbddc21-6209-49df-ac1d-737b79770db2', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -25.000, NULL, NULL, 'GOLD', '2022-12-14 03:24:10', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 09:54:10', '2022-12-14 09:54:10'),
(15, 'a2d96e1e-d088-4d99-99b0-ff77840488cf', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, 25.000, NULL, NULL, 'GOLD', '2022-12-14 03:26:54', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 09:56:54', '2022-12-14 09:56:54'),
(16, 'e0e27525-3cd3-4a9a-9b4d-e93b07f310af', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, 50.000, NULL, NULL, 'GOLD', '2022-12-14 04:11:17', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 10:41:17', '2022-12-14 10:41:17'),
(17, '81d05d41-34a9-4be1-96e1-ac16659edadb', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, 50.000, NULL, NULL, 'GOLD', '2022-12-14 04:14:58', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 10:44:58', '2022-12-14 10:44:58'),
(18, '38dcf24b-bb5f-48dd-8341-88156dd1efca', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -100.000, NULL, NULL, 'GOLD', '2022-12-14 04:19:18', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 10:49:18', '2022-12-14 10:49:18'),
(19, '267816cb-881e-4e14-8ff0-c68a20f30068', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, 500.000, NULL, NULL, 'GOLD', '2022-12-14 04:20:05', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 10:50:05', '2022-12-14 10:50:05'),
(20, 'ebdcd790-ccf1-4a09-8874-1e74b55d2d12', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, 25.000, NULL, NULL, 'GOLD', '2022-12-14 04:42:49', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 11:12:49', '2022-12-14 11:12:49'),
(21, 'b03c07b2-a2fb-4774-8d9b-972cca5e4c6f', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -1.000, NULL, 5000, 'CASH', '2022-12-14 04:43:33', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 11:13:33', '2022-12-14 11:13:33'),
(22, '95c636e7-21fb-4cea-b41d-37ab81271e63', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, 50.000, NULL, NULL, 'GOLD', '2022-12-14 06:18:47', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 12:48:47', '2022-12-14 12:48:47'),
(23, '63ab0422-25da-414d-9390-a996dbb78454', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -50.000, NULL, NULL, 'GOLD', '2022-12-14 06:19:04', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-14 12:49:04', '2022-12-14 12:49:04'),
(24, '0ae2b849-ecd9-4f68-a326-5e48a29aa75c', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -10.000, NULL, 50000, 'CASH', '2022-12-15 10:25:26', 'FINE', 'GOLD', NULL, NULL, NULL, '2022-12-15 04:55:26', '2022-12-15 04:55:26'),
(25, '4e8e01d9-49bf-4282-9962-50727656b6a1', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, 1000.000, NULL, NULL, 'GOLD', '2022-12-15 01:49:06', 'FINE', 'GOLD', 500.000, 500000.000, NULL, '2022-12-15 08:19:06', '2022-12-15 08:19:06'),
(26, '11348cd6-5a4b-49db-bb2c-170dd67b277d', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -1000.000, NULL, NULL, 'GOLD', '2022-12-15 01:54:28', 'FINE', 'GOLD', 50.000, 50000.000, NULL, '2022-12-15 08:24:28', '2022-12-15 08:24:28'),
(27, 'b3c19dca-e76f-4669-abd1-9ef319ca1213', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, 2000.000, NULL, NULL, 'GOLD', '2022-12-15 01:55:36', 'FINE', 'GOLD', 10.000, 20000.000, NULL, '2022-12-15 08:25:36', '2022-12-15 08:25:36'),
(28, '54816792-133b-4afb-acbc-27b5b1830eee', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -1000.000, NULL, NULL, 'GOLD', '2022-12-15 01:56:37', 'FINE', 'GOLD', 10.000, 10000.000, NULL, '2022-12-15 08:26:37', '2022-12-15 08:26:37'),
(29, 'c81fd16a-c19b-4a8a-afdd-32975f2dceaf', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, 1000.000, NULL, NULL, 'GOLD', '2022-12-15 02:18:45', 'FINE', 'GOLD', 5.000, 5000.000, NULL, '2022-12-15 08:48:45', '2022-12-15 08:48:45'),
(30, 'dcb55a2a-c656-4daf-b80f-7119557b4584', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -24.000, NULL, NULL, 'GOLD', '2022-12-15 02:19:22', 'FINE', 'GOLD', 1.000, 24.000, NULL, '2022-12-15 08:49:22', '2022-12-15 08:49:22'),
(31, '74108959-e9fd-4ca5-9766-aece26840343', 6, NULL, 98, NULL, NULL, NULL, NULL, NULL, -52.000, NULL, NULL, 'GOLD', '2022-12-15 02:20:19', 'FINE', 'GOLD', 10.000, 520.000, NULL, '2022-12-15 08:50:19', '2022-12-15 08:50:19');

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

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

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

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

--
-- Table structure for table `ghalai_main_lot`
--

CREATE TABLE `ghalai_main_lot` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint(20) NOT NULL COMMENT 'Login User Id',
  `branch_purchases_ids` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `polish` double(8,3) NOT NULL DEFAULT '0.000',
  `bb` double(8,3) NOT NULL DEFAULT '0.000' COMMENT 'Unwanted Material',
  `gross_wt` double(8,3) DEFAULT NULL COMMENT 'before polish and removing BB',
  `net_wt` double(8,3) DEFAULT NULL COMMENT 'after polish and removing BB',
  `fine` double(8,3) DEFAULT NULL,
  `total_rawa` double(8,3) DEFAULT '0.000',
  `ghalai_lot_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` enum('INIT','SUB LOT CREATED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INIT',
  `metal_type` enum('GOLD','SILVER') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GOLD',
  `deleted_at` timestamp NULL DEFAULT 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 `ghalai_main_lot`
--

INSERT INTO `ghalai_main_lot` (`id`, `uuid`, `created_by`, `branch_purchases_ids`, `polish`, `bb`, `gross_wt`, `net_wt`, `fine`, `total_rawa`, `ghalai_lot_date`, `status`, `metal_type`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'bab2b539-486f-424f-a4f9-e344ad0d18d0', 6, '24,25,26,27,28,29,30,31,32,33,34', 151.280, 5.900, 2722.440, 2565.260, 12.000, NULL, '2022-12-09 18:58:39', 'SUB LOT CREATED', 'GOLD', NULL, '2022-12-09 13:28:39', '2022-12-09 14:57:00'),
(2, '280cf2dd-c487-48aa-9872-0e8a33de9362', 6, '35', 0.000, 1.800, 347.320, 345.520, 0.000, NULL, '2022-12-09 19:09:25', 'SUB LOT CREATED', 'GOLD', NULL, '2022-12-09 13:39:25', '2022-12-09 14:57:34'),
(3, '2b8f3773-fd97-4c7a-846e-d848dd404fd4', 6, '36', 10.000, 10.000, 4100.000, 4080.000, 100.000, NULL, '2022-12-10 17:20:52', 'SUB LOT CREATED', 'GOLD', NULL, '2022-12-10 11:50:52', '2022-12-10 11:51:41'),
(4, '58d12a36-a6b0-443f-943b-1036357a8ce1', 6, '37', 100.000, 10.000, 4100.000, 3990.000, 100.000, NULL, '2022-12-10 21:24:40', 'SUB LOT CREATED', 'GOLD', NULL, '2022-12-10 15:54:40', '2022-12-10 15:56:09'),
(5, '67394dff-8c00-4e17-9e90-258d47882324', 6, '38', 20.000, 20.000, 2200.000, 2160.000, 550.000, NULL, '2022-12-12 15:20:38', 'INIT', 'GOLD', NULL, '2022-12-12 09:50:38', '2022-12-12 09:50:38'),
(6, 'd191edb9-a927-4fc8-b944-721e1e2d19fe', 6, '40', 10.000, 10.000, 3300.000, 3280.000, 300.000, NULL, '2022-12-13 18:04:19', 'SUB LOT CREATED', 'GOLD', NULL, '2022-12-13 12:34:19', '2022-12-13 12:41:28'),
(7, '11e9fc5a-c1f1-420b-a6d2-4426a1d8ad79', 6, '41', 100.000, 100.000, 15100.000, 14900.000, 100.000, NULL, '2022-12-13 18:58:58', 'SUB LOT CREATED', 'GOLD', NULL, '2022-12-13 13:28:58', '2022-12-13 13:36:44'),
(8, 'eeab66c0-f46a-4106-af27-236cdb5445f9', 6, '42', 100.000, 10.000, 1100.000, 990.000, 100.000, NULL, '2022-12-13 19:29:09', 'SUB LOT CREATED', 'GOLD', NULL, '2022-12-13 13:59:09', '2022-12-13 15:00:28');

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

--
-- Table structure for table `ghalai_sub_lot`
--

CREATE TABLE `ghalai_sub_lot` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint(20) NOT NULL COMMENT 'Login User Id',
  `main_ghalai_lot_id` bigint(20) NOT NULL,
  `bullion_buyer_vendor_id` int(11) DEFAULT NULL,
  `bg` double(8,3) NOT NULL DEFAULT '0.000',
  `jp` double(8,3) DEFAULT '0.000',
  `loc` double(8,3) DEFAULT '0.000',
  `dp` double(8,3) DEFAULT '0.000',
  `before_ghalai_langadi` double(8,3) DEFAULT NULL COMMENT 'before bg jp loc dp removing',
  `final_langadi` double(8,3) DEFAULT NULL COMMENT 'after bg jp loc dp removing',
  `rawa` double(8,3) DEFAULT '0.000',
  `ghalai_lot_date` datetime NOT NULL,
  `status` enum('IN STOCK','SOLD') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IN STOCK',
  `metal_type` enum('GOLD','SILVER') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GOLD',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ghalai_sub_lot`
--

INSERT INTO `ghalai_sub_lot` (`id`, `uuid`, `created_by`, `main_ghalai_lot_id`, `bullion_buyer_vendor_id`, `bg`, `jp`, `loc`, `dp`, `before_ghalai_langadi`, `final_langadi`, `rawa`, `ghalai_lot_date`, `status`, `metal_type`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '17398f95-7bc7-47b8-be0c-8e87852f896b', 6, 1, 10, 1147.550, 0.430, 0.520, 0.590, 1159.740, 1146.010, 4.320, '2022-12-09 08:27:00', 'SOLD', 'GOLD', NULL, '2022-12-09 14:57:00', '2022-12-09 15:05:51'),
(2, 'bd512ea8-326f-4be1-8b46-aad790e60b6c', 6, 1, NULL, 814.770, 0.480, 0.580, 1.310, 819.880, 812.400, 4.320, '2022-12-09 08:27:00', 'IN STOCK', 'GOLD', NULL, '2022-12-09 14:57:00', '2022-12-09 14:57:00'),
(3, '5cee2c68-a2ad-4f9a-909d-4e000c542e9a', 6, 1, NULL, 527.580, 0.410, 0.530, 0.570, 538.950, 526.070, 4.320, '2022-12-09 08:27:00', 'IN STOCK', 'GOLD', NULL, '2022-12-09 14:57:00', '2022-12-09 14:57:00'),
(4, '479b6d15-d9fa-4904-aa25-0931888ca677', 6, 2, NULL, 345.520, 0.000, 0.000, 0.000, 345.520, 345.520, 0.000, '2022-12-09 08:27:34', 'IN STOCK', 'GOLD', NULL, '2022-12-09 14:57:34', '2022-12-09 14:57:34'),
(5, 'e5fe26df-6a99-4ba3-907e-e0b5e076b54c', 6, 3, NULL, 4060.000, 10.000, 10.000, 10.000, 4080.000, 4030.000, 10.000, '2022-12-10 05:21:41', 'IN STOCK', 'GOLD', NULL, '2022-12-10 11:51:41', '2022-12-10 11:51:41'),
(6, '256eba82-795f-4fd8-b16f-fb9c9be950fc', 6, 4, 10, 3950.000, 0.500, 0.500, 0.500, 3990.000, 3948.500, 3.000, '2022-12-10 09:26:09', 'SOLD', 'GOLD', NULL, '2022-12-10 15:56:09', '2022-12-10 15:56:46'),
(7, 'cb4f2163-a7d6-4a48-8e09-a9446c3e8652', 6, 6, 98, 1980.000, 2.000, 2.000, 6.000, 2000.000, 1970.000, 38.000, '2022-12-13 06:11:28', 'SOLD', 'GOLD', NULL, '2022-12-13 12:41:28', '2022-12-13 13:11:51'),
(8, '019af2b7-c93d-4574-a8f4-45b84eb749fb', 6, 6, 98, 1260.000, 2.000, 2.000, 6.000, 1280.000, 1250.000, 38.000, '2022-12-13 06:11:28', 'SOLD', 'GOLD', NULL, '2022-12-13 12:41:28', '2022-12-13 13:11:51'),
(9, '692d1e5d-93da-4307-88c9-ae8c5529cb85', 6, 7, NULL, 5.000, 2.000, 2.000, 6.000, 7900.000, -5.000, NULL, '2022-12-13 07:01:24', 'IN STOCK', 'GOLD', NULL, '2022-12-13 13:31:24', '2022-12-13 13:31:24'),
(10, 'e2af9111-68aa-429c-8849-ffb372c5effc', 6, 7, NULL, 5.000, 2.000, 2.000, 6.000, 700.000, -5.000, NULL, '2022-12-13 07:01:24', 'IN STOCK', 'GOLD', NULL, '2022-12-13 13:31:24', '2022-12-13 13:31:24'),
(11, 'f136d0d1-df99-4b35-a506-ca2e35a9aaf6', 6, 7, 98, 7890.000, 2.000, 2.000, 6.000, 7900.000, 7880.000, NULL, '2022-12-13 07:06:44', 'SOLD', 'GOLD', NULL, '2022-12-13 13:36:44', '2022-12-13 13:38:45'),
(12, 'd131aeae-5136-460e-b3fc-e8cedcb8ede1', 6, 7, 98, 6990.000, 2.000, 2.000, 6.000, 7000.000, 6980.000, NULL, '2022-12-13 07:06:44', 'SOLD', 'GOLD', NULL, '2022-12-13 13:36:44', '2022-12-13 13:38:45');

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

--
-- Table structure for table `ho_wallet`
--

CREATE TABLE `ho_wallet` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `amount` int(11) NOT NULL,
  `transaction_date` datetime NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `metal_stock`
--

CREATE TABLE `metal_stock` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rd` double(8,3) NOT NULL,
  `cb` double(8,3) NOT NULL,
  `fine` double(8,3) NOT NULL,
  `dp` double(8,3) NOT NULL,
  `rawa` double(8,3) NOT NULL,
  `old_gold` double(8,3) DEFAULT NULL,
  `cash` int(11) DEFAULT NULL,
  `polish` double(8,3) NOT NULL,
  `bb` double(8,3) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT 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 `metal_stock`
--

INSERT INTO `metal_stock` (`id`, `uuid`, `rd`, `cb`, `fine`, `dp`, `rawa`, `old_gold`, `cash`, `polish`, `bb`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, '', 714.760, 724.120, 20580.000, 0.000, 58.570, 6980.540, 100050, 491.280, 167.700, NULL, NULL, '2022-12-17 13:50:52');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci 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_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_08_06_121120_create_user_extra_details_table', 1),
(6, '2022_08_06_121121_create_branch_table', 1),
(7, '2022_08_06_121141_create_metal_stock_table', 1),
(8, '2022_08_06_121157_create_vendor_reminder_table', 1),
(9, '2022_08_06_121219_create_branch_purchase_table', 1),
(10, '2022_08_06_121238_create_ghalai_main_lot_table', 1),
(11, '2022_08_06_121253_create_ghalai_sub_lot_table', 1),
(12, '2022_08_06_124014_create_bullion_vendor_transaction_table', 1),
(13, '2022_08_06_124803_create_normal_vendor_transaction_table', 1),
(14, '2022_08_07_044031_create_jobs_table', 2),
(15, '2022_08_27_004042_create_branch_purchases_lot_table', 3),
(16, '2022_08_27_005542_create_pivot_branch_purchases_and_its_lot_table', 3),
(17, '2022_08_27_143332_create_ho_wallet_table', 4);

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

--
-- Table structure for table `normal_vendor_transaction`
--

CREATE TABLE `normal_vendor_transaction` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `invoice_id` bigint(20) DEFAULT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint(20) NOT NULL COMMENT 'Login User Id',
  `updated_by` bigint(20) DEFAULT NULL COMMENT 'login user id',
  `vendor_id` bigint(20) NOT NULL,
  `particular` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `jewellery_wt` double(8,3) DEFAULT NULL,
  `fine_gave` double(8,3) NOT NULL DEFAULT '0.000',
  `transaction_date` datetime NOT NULL,
  `transaction_type` enum('GOLD','CASH','CHEQUE','CARD','UPI','INTERNET_BANKING','WALLET') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metal_type` enum('GOLD','SILVER') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GOLD',
  `paymentStatus` enum('partial','fully','pending') COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `credit_debit` enum('CREDIT','DEBIT','FINE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `per_gm_rate` double(10,3) DEFAULT NULL,
  `amount` double(10,3) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `normal_vendor_transaction`
--

INSERT INTO `normal_vendor_transaction` (`id`, `invoice_id`, `uuid`, `created_by`, `updated_by`, `vendor_id`, `particular`, `jewellery_wt`, `fine_gave`, `transaction_date`, `transaction_type`, `metal_type`, `paymentStatus`, `credit_debit`, `per_gm_rate`, `amount`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, NULL, '5884a527-af16-4658-a481-cb00655b114e', 6, 6, 23, '{\"item\":\"\'chain\'\",\"item_wt_in_gram\":\"100\",\"jewellery_wt\":null,\"purity\":\"85\",\"garbage\":\"5\",\"weight\":\"90\"}', 1900.000, 1900.000, '2022-12-15 06:48:27', NULL, 'GOLD', 'partial', 'CREDIT', NULL, NULL, NULL, '2022-12-15 13:18:27', '2022-12-17 01:48:02'),
(2, NULL, '14986225-8c53-4ab7-80ce-ae0e9532cc7d', 6, 6, 23, '{\"item\":\"\'ring\'\",\"item_wt_in_gram\":\"1000\",\"jewellery_wt\":null,\"purity\":\"90\",\"garbage\":\"5\",\"weight\":\"950\"}', -950.000, -950.000, '2022-12-16 04:18:14', NULL, 'GOLD', 'partial', 'CREDIT', NULL, NULL, NULL, '2022-12-16 10:48:14', '2022-12-17 01:49:17'),
(3, NULL, '3924b7f0-84cd-4294-8685-8e4a6e59d8f0', 6, NULL, 13, '{\"item\":\"\'nechlace\'\",\"item_wt_in_gram\":\"500\",\"jewellery_wt\":null,\"purity\":\"90\",\"garbage\":\"5\",\"weight\":\"475\"}', -475.000, 0.000, '2022-12-17 11:16:13', NULL, 'GOLD', 'fully', 'CREDIT', NULL, NULL, NULL, '2022-12-17 05:46:13', '2022-12-17 01:50:52'),
(4, 3, 'e279bcb9-b181-45db-ac20-702b2ac642fa', 6, NULL, 13, NULL, NULL, 200.000, '2022-12-17 00:00:00', 'GOLD', 'GOLD', 'pending', 'FINE', 10.000, NULL, NULL, '2022-12-17 05:52:33', '2022-12-17 07:07:11'),
(5, 3, '5e984dc9-51ca-4155-9aa3-af8bba393c4c', 6, 6, 23, NULL, NULL, 275.000, '2022-12-17 13:51:11', 'GOLD', 'GOLD', 'pending', 'FINE', 1.000, 1.000, NULL, '2022-12-16 20:21:11', '2022-12-17 08:21:11'),
(6, NULL, 'b945a1d0-ffcd-4e0f-a16f-e4f180476e2e', 6, NULL, 13, '{\"item\":\"\'Mix\'\",\"item_wt_in_gram\":\"2000\",\"jewellery_wt\":null,\"purity\":\"90\",\"garbage\":\"5\",\"weight\":\"1900\"}', -1900.000, 0.000, '2022-12-17 01:57:18', NULL, 'GOLD', 'fully', 'CREDIT', NULL, NULL, NULL, '2022-12-17 08:27:18', '2022-12-17 01:05:46'),
(7, 6, 'edbc8143-2ff0-4a5b-9bc1-c62875627755', 6, 6, 23, NULL, NULL, 500.000, '2022-12-17 13:58:36', 'GOLD', 'GOLD', 'pending', 'FINE', 1.000, 500.000, NULL, '2022-12-16 20:28:36', '2022-12-17 08:28:36'),
(8, 6, '14b07292-7126-46a5-95d7-a7c209fa4ffe', 6, 6, 23, NULL, NULL, 200.000, '2022-12-17 14:01:26', 'GOLD', 'GOLD', 'pending', 'FINE', 1.000, 200.000, NULL, '2022-12-16 20:31:26', '2022-12-17 08:31:26'),
(9, 6, 'a7749246-62d9-46f7-b850-ffe8bca9aa0c', 6, 6, 23, NULL, NULL, 200.000, '2022-12-17 18:15:11', 'CASH', 'GOLD', 'pending', 'FINE', 10.000, 2000.000, NULL, '2022-12-17 00:45:11', '2022-12-17 12:45:11'),
(10, 6, 'b7949487-474d-4ce6-8b10-08d64117146e', 6, 6, 23, NULL, NULL, 200.000, '2022-12-17 18:15:14', 'CASH', 'GOLD', 'pending', 'FINE', 10.000, 2000.000, NULL, '2022-12-17 00:45:14', '2022-12-17 12:45:14'),
(11, 6, 'fc1292c9-a8f9-4872-a9cd-151ec10fb79e', 6, 6, 23, NULL, NULL, 200.000, '2022-12-17 18:15:35', 'CASH', 'GOLD', 'pending', 'FINE', 10.000, 2000.000, NULL, '2022-12-17 00:45:35', '2022-12-17 12:45:35'),
(12, 6, 'c825214e-1785-429d-b6f7-33072e57e8f0', 6, 6, 23, NULL, NULL, 100.000, '2022-12-17 18:18:10', 'GOLD', 'GOLD', 'pending', 'FINE', 10.000, 10.000, NULL, '2022-12-17 00:48:10', '2022-12-17 12:48:10'),
(13, 6, '18dd546a-6c12-4e5b-8029-846bfa531b05', 6, 6, 23, NULL, NULL, 100.000, '2022-12-17 18:18:38', 'GOLD', 'GOLD', 'pending', 'FINE', 10.000, 10.000, NULL, '2022-12-17 00:48:38', '2022-12-17 12:48:38'),
(14, 6, 'f3c054c7-6d05-40db-9a7b-c98a8f755f17', 6, 6, 23, NULL, NULL, 100.000, '2022-12-17 18:26:03', 'GOLD', 'GOLD', 'pending', 'FINE', 1.000, 400.000, NULL, '2022-12-17 00:56:03', '2022-12-17 12:56:03'),
(15, 6, '510529c7-f6a2-473a-8e6f-046a810987ff', 6, 6, 23, NULL, NULL, 100.000, '2022-12-17 18:26:45', 'GOLD', 'GOLD', 'pending', 'FINE', 1.000, 100.000, NULL, '2022-12-17 00:56:45', '2022-12-17 12:56:45'),
(16, 6, '247347e3-5dcb-4bd4-a17b-5f633e0a8501', 6, 6, 23, NULL, NULL, 100.000, '2022-12-17 18:26:49', 'GOLD', 'GOLD', 'pending', 'FINE', 1.000, 100.000, NULL, '2022-12-17 00:56:49', '2022-12-17 12:56:49'),
(17, 6, 'd01b7f7b-8d1b-4435-b826-4716354e9cac', 6, 6, 23, NULL, NULL, 100.000, '2022-12-17 18:35:46', 'GOLD', 'GOLD', 'pending', 'FINE', 1.000, 1.000, NULL, '2022-12-17 01:05:46', '2022-12-17 13:05:46'),
(18, 1, '5c8f9b0e-9269-4eac-bdfb-7fab4ba5625e', 6, 6, 23, NULL, NULL, 100.000, '2022-12-17 19:16:08', 'GOLD', 'GOLD', 'pending', 'FINE', 100.000, NULL, NULL, '2022-12-17 01:46:08', '2022-12-17 13:46:08'),
(19, 1, '30ac5dc4-0704-4c76-bc6c-011ae9213b58', 6, 6, 23, NULL, NULL, 100.000, '2022-12-17 19:16:55', 'GOLD', 'GOLD', 'pending', 'FINE', 100.000, NULL, NULL, '2022-12-17 01:46:55', '2022-12-17 13:46:55'),
(20, 1, 'c354476f-16ce-4251-ab20-e4d25438fb5f', 6, 6, 23, NULL, NULL, 100.000, '2022-12-17 19:18:02', 'GOLD', 'GOLD', 'pending', 'FINE', 100.000, NULL, NULL, '2022-12-17 01:48:02', '2022-12-17 13:48:02'),
(21, 2, 'ea4ff1e8-a59d-4bc6-a81e-90b4077a235e', 6, 6, 23, NULL, NULL, 100.000, '2022-12-17 19:19:17', 'GOLD', 'GOLD', 'pending', 'FINE', 100.000, NULL, NULL, '2022-12-17 01:49:17', '2022-12-17 13:49:17'),
(22, 3, '0e83b59b-6670-4b11-b839-63c492d10c79', 6, 6, 23, NULL, NULL, 500.000, '2022-12-17 19:20:52', 'GOLD', 'GOLD', 'pending', 'FINE', 10.000, NULL, NULL, '2022-12-17 01:50:52', '2022-12-17 13:50:52'),
(23, NULL, 'ca0bbab1-bd57-469f-b9eb-f1980922774b', 6, NULL, 12, '{\"item\":\"\'ring_manu\'\",\"item_wt_in_gram\":\"1000\",\"jewellery_wt\":null,\"purity\":\"70\",\"garbage\":\"5\",\"weight\":\"750\"}', -750.000, 0.000, '2022-12-17 08:18:01', NULL, 'GOLD', 'pending', 'CREDIT', NULL, NULL, NULL, '2022-12-17 14:48:01', '2022-12-17 14:48:01');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_team` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `transaction_log`
--

CREATE TABLE `transaction_log` (
  `id` bigint(20) NOT NULL,
  `transaction_id` bigint(20) NOT NULL,
  `vendor_type` enum('normal','bullion') NOT NULL,
  `vendor_id` bigint(20) NOT NULL,
  `fine_wt` double(10,3) DEFAULT NULL,
  `per_gm_rate` double(10,3) DEFAULT NULL,
  `amount` double(10,3) DEFAULT NULL,
  `remark` longtext,
  `transaction_type` enum('cash','gold') NOT NULL,
  `created_by` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `modified_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transaction_log`
--

INSERT INTO `transaction_log` (`id`, `transaction_id`, `vendor_type`, `vendor_id`, `fine_wt`, `per_gm_rate`, `amount`, `remark`, `transaction_type`, `created_by`, `created_at`, `modified_at`) VALUES
(1, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 20:47:20', '2022-12-15 20:47:20'),
(2, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 20:55:56', '2022-12-15 20:55:56'),
(3, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 20:58:42', '2022-12-15 20:58:42'),
(4, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 21:00:30', '2022-12-15 21:00:30'),
(5, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 21:01:15', '2022-12-15 21:01:15'),
(6, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 21:03:08', '2022-12-15 21:03:08'),
(7, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 21:06:20', '2022-12-15 21:06:20'),
(8, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 21:08:21', '2022-12-15 21:08:21'),
(9, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 21:10:12', '2022-12-15 21:10:12'),
(10, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 21:10:29', '2022-12-15 21:10:29'),
(11, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 21:17:09', '2022-12-15 21:17:09'),
(12, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 21:22:53', '2022-12-15 21:22:53'),
(13, 1, 'normal', 23, 100.000, 1.000, 100.000, 'test note', 'gold', 6, '2022-12-15 21:34:16', '2022-12-15 21:34:16'),
(14, 1, 'normal', 23, 10.000, 500.000, 5000.000, 'test note', 'cash', 6, '2022-12-15 22:06:20', '2022-12-15 22:06:20'),
(15, 1, 'normal', 23, 10.000, 500.000, 5000.000, 'test note', 'cash', 6, '2022-12-15 22:08:54', '2022-12-15 22:08:54'),
(16, 1, 'normal', 23, 10.000, 500.000, 5000.000, 'test note', 'cash', 6, '2022-12-15 22:09:45', '2022-12-15 22:09:45'),
(17, 1, 'normal', 23, 10.000, 500.000, 5000.000, 'test note', 'cash', 6, '2022-12-15 22:10:28', '2022-12-15 22:10:28'),
(18, 1, 'normal', 23, 90.000, 1.000, 90.000, NULL, 'gold', 6, '2022-12-15 22:12:45', '2022-12-15 22:12:45'),
(19, 1, 'normal', 23, 100.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 22:13:56', '2022-12-15 22:13:56'),
(20, 1, 'normal', 23, 100.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 22:15:19', '2022-12-15 22:15:19'),
(21, 1, 'normal', 23, 100.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 22:16:49', '2022-12-15 22:16:49'),
(22, 1, 'normal', 23, 100.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 22:20:23', '2022-12-15 22:20:23'),
(23, 1, 'normal', 23, 100.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 22:20:40', '2022-12-15 22:20:40'),
(24, 1, 'normal', 23, 100.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 22:22:38', '2022-12-15 22:22:38'),
(25, 1, 'normal', 23, 100.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 22:22:58', '2022-12-15 22:22:58'),
(26, 1, 'normal', 23, 100.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 22:25:52', '2022-12-15 22:25:52'),
(27, 1, 'normal', 23, 1000.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 22:32:19', '2022-12-15 22:32:19'),
(28, 1, 'normal', 23, 1000.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 22:32:54', '2022-12-15 22:32:54'),
(29, 1, 'normal', 23, 1000.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 22:45:46', '2022-12-15 22:45:46'),
(30, 1, 'normal', 23, 950.000, 1.000, 1.000, 'pay', 'gold', 6, '2022-12-15 22:50:08', '2022-12-15 22:50:08'),
(31, 1, 'normal', 23, 950.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 23:04:29', '2022-12-15 23:04:29'),
(32, 1, 'normal', 23, 950.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 23:06:03', '2022-12-15 23:06:03'),
(33, 1, 'normal', 23, 950.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 23:19:58', '2022-12-15 23:19:58'),
(34, 1, 'normal', 23, 100.000, 1.000, 2.000, 'test', 'gold', 6, '2022-12-15 23:22:39', '2022-12-15 23:22:39'),
(35, 1, 'normal', 23, 1900.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 23:24:13', '2022-12-15 23:24:13'),
(36, 1, 'normal', 23, 1000.000, 1.000, 1.000, '1', 'gold', 6, '2022-12-15 23:24:59', '2022-12-15 23:24:59'),
(37, 1, 'normal', 23, NULL, NULL, NULL, NULL, 'gold', 6, '2022-12-15 23:26:25', '2022-12-15 23:26:25'),
(38, 1, 'normal', 23, NULL, NULL, NULL, NULL, 'gold', 6, '2022-12-15 23:27:39', '2022-12-15 23:27:39'),
(39, 1, 'normal', 23, NULL, NULL, NULL, NULL, 'gold', 6, '2022-12-15 23:28:00', '2022-12-15 23:28:00'),
(40, 1, 'normal', 23, NULL, NULL, NULL, NULL, 'gold', 6, '2022-12-15 23:36:56', '2022-12-15 23:36:56'),
(41, 1, 'normal', 23, NULL, NULL, NULL, NULL, 'gold', 6, '2022-12-15 23:38:19', '2022-12-15 23:38:19'),
(42, 2, 'normal', 23, 950.000, 10.000, 9500.000, 'tesr remark', 'gold', 6, '2022-12-17 05:20:21', '2022-12-17 05:20:21');

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

--
-- Table structure for table `user_extra_details`
--

CREATE TABLE `user_extra_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `user_details_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_details_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

--
-- Table structure for table `vendor_reminder`
--

CREATE TABLE `vendor_reminder` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint(20) NOT NULL COMMENT 'Login User Id',
  `updated_by` bigint(20) DEFAULT '0' COMMENT 'login user id',
  `vendor_id` bigint(20) NOT NULL,
  `reminder_date` date DEFAULT NULL,
  `reminder_note` text COLLATE utf8mb4_unicode_ci,
  `vendor_type` enum('BULLION','NORMAL') COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_reminder`
--

INSERT INTO `vendor_reminder` (`id`, `uuid`, `created_by`, `updated_by`, `vendor_id`, `reminder_date`, `reminder_note`, `vendor_type`, `transaction_uuid`, `deleted_at`, `created_at`, `updated_at`) VALUES
(14, '09ab52d1-a35b-456f-a5c3-e7ff2e7e19cf', 6, 0, 23, '2022-12-16', 'pay', 'NORMAL', '5884a527-af16-4658-a481-cb00655b114e', NULL, '2022-12-15 13:18:27', '2022-12-15 13:18:27'),
(15, 'be8175da-bdea-4a70-81ef-c3a8158352f7', 6, 0, 23, '2022-12-17', 'Pay', 'NORMAL', '14986225-8c53-4ab7-80ce-ae0e9532cc7d', NULL, '2022-12-16 10:48:14', '2022-12-16 10:48:14'),
(16, '5a2e92c9-1f07-4292-b562-6885256d2190', 6, 0, 13, '2022-12-18', 'test note', 'NORMAL', '3924b7f0-84cd-4294-8685-8e4a6e59d8f0', NULL, '2022-12-17 05:46:13', '2022-12-17 05:46:13'),
(17, '0aeec1fe-83e2-4b87-8df3-3434dd08e88d', 6, 0, 13, '2022-12-18', 'test', 'NORMAL', 'e279bcb9-b181-45db-ac20-702b2ac642fa', NULL, '2022-12-17 05:52:33', '2022-12-17 05:52:33'),
(18, 'dee662a5-3628-4270-8fc7-9a0a2c0cf3e7', 6, 0, 13, '2022-12-17', 'test', 'NORMAL', 'b945a1d0-ffcd-4e0f-a16f-e4f180476e2e', NULL, '2022-12-17 08:27:18', '2022-12-17 08:27:18'),
(19, 'a60045f3-8770-46ea-bd67-a4c6ca084c82', 6, 0, 12, '2022-12-30', 'test', 'NORMAL', 'ca0bbab1-bd57-469f-b9eb-f1980922774b', NULL, '2022-12-17 14:48:01', '2022-12-17 14:48:01');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `branch`
--
ALTER TABLE `branch`
  ADD PRIMARY KEY (`id`),
  ADD KEY `branch_code` (`branch_code`,`city`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `teams`
--
ALTER TABLE `teams`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teams_user_id_index` (`user_id`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `transaction_log`
--
ALTER TABLE `transaction_log`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

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

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

