INSERT INTO `quotations` VALUES (17333,1063,'7010803751',1,4,2,2,'QUO/SB-07316/2025','2025-02-21','2147600.00',NULL,NULL,'2147600.00','M/s. Bharath Fabrications\r\nPlot No - B7, Industrial Growth Center,\r\nSipcot Erode District,\r\nPerundurai – 638052\r\nContact Person: Mr. Mohan - 9942032053',NULL,46,'2025-02-21 13:21:38','2025-02-21 13:21:38','pending',NULL,'40.00',NULL,'pending',NULL,0,3),(17334,2045,'8667073884',1,5,1,1,'QUO/SB-07317/2025','2025-02-21','435665.44',NULL,NULL,'435665.44','No.24, Kambar Street, Ramapuram, Chennai, Chennai, Tamil Nadu, 600053\r\nCONTACT - NAVEEN - 8667073884',NULL,47,'2025-02-21 13:27:05','2025-02-21 13:27:11','accepted',NULL,'7.83',NULL,'pending',NULL,0,1),(17335,1458,'04443514195',1,1,1,2,'QUO/SB-07318/2025','2025-02-21','573104.76',NULL,NULL,'573104.76','No.9 AND 7, VRB CONSTRUCTIONS, BAJANAI KOIL STREET, PALLIPATTU, Chennai, Tamil Nadu, 600113','Mr. K.Mohamed ibrahim',34,'2025-02-21 13:43:10','2025-02-21 16:35:05','pending',NULL,'9.72',NULL,'pending',NULL,0,18),(17336,999,'9444077535',1,4,2,1,'QUO/SB-07319/2025','2025-02-21','187159.80',NULL,NULL,'187159.80','FIRST FLOOR, NO.38, VENKATA MAISTRY STREET, CHENNAI.1, Chennai, Tamil Nadu, 600001',NULL,51,'2025-02-21 13:51:15','2025-02-21 13:51:21','accepted',NULL,'3.24',NULL,'pending',NULL,0,3),(17337,1863,'9549075835',1,1,2,1,'QUO/SB-07320/2025','2025-02-21','408575.00',NULL,NULL,'408575.00','NO.294/7, C C ROAD, KUDIMIKUDISAI VILLAGE, VANNANKULAM POST, ARNI TALUK, Tiruvannamalai, Tamil Nadu, 632315',NULL,26,'2025-02-21 13:55:46','2025-02-21 15:59:55','accepted',NULL,'7.00',NULL,'pending',NULL,0,18),(17338,1643,'9894196539',1,6,1,1,'QUO/SB-07321/2025','2025-02-21','615606.00',NULL,NULL,'615606.00','No.33/7, First Street, Reserve Bank Colony, MG Road, Chennai, Chennai, Tamil Nadu, 600041\r\nCONTACT - CHELLAMUTHU - 9176564044',NULL,47,'2025-02-21 14:16:42','2025-02-21 14:16:49','accepted',NULL,'11.00',NULL,'pending',NULL,0,1),(17339,1190,'9847481483',1,5,2,1,'QUO/SB-07322/2025','2025-02-21','713192.00',NULL,NULL,'713192.00','9/133, HAYFA STEELS, COURT ROAD, CALICUT, Kozhikode, Kerala, 673001',NULL,45,'2025-02-21 14:55:54','2025-02-21 14:55:54','pending',NULL,'13.00',NULL,'pending',NULL,0,3),(17340,1190,'9847481483',1,5,2,1,'QUO/SB-07323/2025','2025-02-21','652068.00',NULL,NULL,'652068.00','9/133, HAYFA STEELS, COURT ROAD, CALICUT, Kozhikode, Kerala, 673001',NULL,45,'2025-02-21 14:56:42','2025-02-21 14:56:42','pending',NULL,'12.00',NULL,'pending',NULL,0,3),(17341,773,'9025438798',1,1,1,1,'QUO/SB-07324/2025','2025-02-21','294705.00',NULL,NULL,'294705.00','BIOMAN SEWAGE SOLUTIONS\r\nPRIVATE LIMITED\r\n265/1, Agragaram Main Road,\r\nAyanambakkam,Chennai,\r\nThiruvallur, Tamil Nadu-600095\r\nCHENNAI\r\nTamil Nadu\r\n600095\r\ncontact no= babu 93449 04972, karthik=9345910116',NULL,48,'2025-02-21 14:58:22','2025-02-21 15:03:09','accepted',NULL,'5.00',NULL,'pending',NULL,0,3),(17342,1038,'9841078484',2,4,2,1,'QUO/SB-07325/2025','2025-02-21','1619550.00',NULL,NULL,'1619550.00','1,Sudharsan Nagar, Thirumullaivoyal, Tiruvallur, , 600062',NULL,24,'2025-02-21 15:05:57','2025-02-21 15:06:03','accepted',NULL,'30.00',NULL,'pending',NULL,0,1),(17343,1038,'9841078484',2,4,2,1,'QUO/SB-07326/2025','2025-02-21','765230.00',NULL,NULL,'765230.00','1,Sudharsan Nagar, Thirumullaivoyal, Tiruvallur, , 600062',NULL,24,'2025-02-21 15:08:11','2025-02-21 15:08:17','accepted',NULL,'14.00',NULL,'pending',NULL,0,1),(17344,1038,'9841078484',2,4,2,1,'QUO/SB-07327/2025','2025-02-21','818035.00',NULL,NULL,'818035.00','1,Sudharsan Nagar, Thirumullaivoyal, Tiruvallur, , 600062',NULL,24,'2025-02-21 15:10:03','2025-02-21 15:10:08','accepted',NULL,'15.00',NULL,'pending',NULL,0,1),(17345,1038,'9841078484',2,4,2,1,'QUO/SB-07328/2025','2025-02-21','597965.00',NULL,NULL,'597965.00','1,Sudharsan Nagar, Thirumullaivoyal, Tiruvallur, , 600062',NULL,24,'2025-02-21 15:21:06','2025-02-21 15:21:12','accepted',NULL,'11.00',NULL,'pending',NULL,0,1),(17346,1169,'9445048419',1,6,1,1,'QUO/SB-07329/2025','2025-02-21','915680.00',NULL,NULL,'915680.00','Ground Floor, No 1/ 47A,55A, Perumal Kovil Street, Chennai, Chennai, Tamil Nadu, 600068',NULL,46,'2025-02-21 15:26:19','2025-02-21 15:26:26','accepted',NULL,'16.00',NULL,'pending',NULL,0,18),(17347,1507,'9500083965',1,1,1,1,'QUO/SB-07330/2025','2025-02-21','433186.56',NULL,NULL,'433186.56','Plot No:7, 2nd street, Syndicate Bank colony Extension, Echangadu , Kovilambakkam, Chennai 600129.\r\nContact : Mr.Kannan (9500065041)',NULL,59,'2025-02-21 15:37:02','2025-02-21 15:44:03','accepted',NULL,'7.07',NULL,'pending',NULL,0,18),(17348,1957,'9495553703',1,1,2,1,'QUO/SB-07331/2025','2025-02-21','1004416.00',NULL,NULL,'1004416.00','7/183 G, KALLIYATH BUILDING, EAST BAZAR,TIRUR, TIRUR, \r\nMalappuram, Kerala, 676101\r\nCONTACT - Mr.Sudarshan - 9495553703',NULL,45,'2025-02-21 15:42:39','2025-02-21 16:39:20','accepted',NULL,'19.00',NULL,'pending',NULL,0,3),(17349,1347,'9884057268',1,3,2,1,'QUO/SB-07332/2025','2025-02-21','1462905.00',NULL,NULL,'1462905.00','SF NO. 301/3, CHENNAI BYE PASS ROAD , SENTHANEERPURAM, TRICHY - 620004',NULL,61,'2025-02-21 15:51:24','2025-02-21 15:51:30','accepted',NULL,'25.00',NULL,'pending',NULL,0,18),(17350,1976,'7845884314',1,3,2,1,'QUO/SB-07333/2025','2025-02-21','1175870.00',NULL,NULL,'1175870.00','S.F NO 126/20A2,126/21B, POLUR MAIN ROAD, Opp:SISHYA SCHOOL, INAMKARIANDAL POST, Inam Kariyandal, Tiruvannamalai, Tamil Nadu, 606604',NULL,36,'2025-02-21 15:56:34','2025-02-21 15:56:39','accepted',NULL,'20.00',NULL,'pending',NULL,0,18),(17351,2046,'9345713318',2,1,2,1,'QUO/SB-07334/2025','2025-02-21','551650.00',NULL,NULL,'551650.00','BLOCK NO 42, T.S NO 1511, Railway Feeder Road, Karaikudi, Sivaganga, Tamil Nadu, 630001','Mr. K.Mohamed ibrahim',34,'2025-02-21 16:43:24','2025-02-21 17:49:44','accepted',NULL,'10.00',NULL,'pending',NULL,0,1),(17352,556,'9160655575',1,1,1,2,'QUO/SB-07335/2025','2025-02-21','11955358.80',NULL,NULL,'11955358.80','SPR CONSTRUCTION PVT LTD Cooks Road Binny Mills\r\nPerambur Chennai - 600012 Sumit Kumar -\r\n9381212614 GST NO :33AANCS6295H1ZV',NULL,48,'2025-02-21 16:48:11','2025-02-21 16:48:45','accepted',NULL,'220.00',NULL,'pending',NULL,0,1),(17353,556,'9160655575',1,1,1,2,'QUO/SB-07336/2025','2025-02-21','2176710.60',NULL,NULL,'2176710.60','SPR CONSTRUCTION PVT LTD Cooks Road Binny Mills\r\nPerambur Chennai - 600012 Sumit Kumar -\r\n9381212614 GST NO :33AANCS6295H1ZV',NULL,48,'2025-02-21 16:51:21','2025-02-21 16:51:29','accepted',NULL,'40.00',NULL,'pending',NULL,0,1),(17354,556,'9160655575',1,1,1,2,'QUO/SB-07337/2025','2025-02-21','2167683.60',NULL,NULL,'2167683.60','SPR CONSTRUCTION PVT LTD Cooks Road Binny Mills\r\nPerambur Chennai - 600012 Sumit Kumar -\r\n9381212614 GST NO :33AANCS6295H1ZV',NULL,48,'2025-02-21 16:53:51','2025-02-21 16:53:58','accepted',NULL,'40.00',NULL,'pending',NULL,0,1),(17355,1660,'9341699000',1,1,1,1,'QUO/SB-07338/2025','2025-02-21','1092562.00',NULL,NULL,'1092562.00','1ST FLOOR, NO.232/107, DR SHIVARAM KARANTH NAGAR, KOTHANUR NEAR WATER TANK, BYRATHI VILLAGE,, Bengaluru, Bengaluru Urban, Karnataka, 560077',NULL,48,'2025-02-21 16:55:07','2025-02-21 16:55:12','accepted',NULL,'20.50',NULL,'pending',NULL,0,3),(17356,1429,'91741809996',1,1,2,2,'QUO/SB-07339/2025','2025-02-21','634840.00',NULL,NULL,'634840.00','NO.150 VICHOOR VILLAGE,MANALI NEW TOWN, CHENNAI -600103 CONTACT - Manimegalai.V +91 74180 9996',NULL,48,'2025-02-21 16:57:30','2025-02-21 16:57:44','accepted',NULL,'12.00',NULL,'pending',NULL,0,1),(17357,303,'9884355555',1,4,2,1,'QUO/SB-07340/2025','2025-02-21','345150.00',NULL,NULL,'345150.00','27/2 New No.57,Jones Street,, Mannady,Chennai-600001','Mr. B Rathinakumar',26,'2025-02-21 17:02:13','2025-02-21 17:02:37','accepted',NULL,'6.00',NULL,'pending',NULL,0,3),(17358,719,'9500127104',1,1,1,1,'QUO/SB-07341/2025','2025-02-21','381273.58',NULL,NULL,'381273.58','NEST ZONE INDIA PVT LTD\r\nS.NO.260/2A12A2, 2B1, 2C, 1B, OTIYAMBAKKAM MAIN ROAD,\r\nOTTIAMBAKKAM VILLAGE TAMBARAM TALUK,\r\nCHENNAI KALAVANI HARDWARES CHENGAPATTU \r\nTAMILNADU - 600130\r\nCONTACT-9840104706',NULL,47,'2025-02-21 17:11:28','2025-02-21 17:11:52','accepted',NULL,'6.91',NULL,'pending',NULL,0,1),(17359,719,'9500127104',1,1,1,2,'QUO/SB-07342/2025','2025-02-21','2460098.22',NULL,NULL,'2460098.22','NEST ZONE INDIA PVT LTD\r\nS.NO.365 / 5B  & S.NO. 366/1, UNNAMED ROAD,\r\nGATEWAY INTERNATIONAL SCHOOL,\r\nPADUR VILLAGE ,\r\nTHIRUPORUR TALUK,\r\nKELAMBAKKAM CHENGALPATTU TAMILNADU - 603103\r\nCONTACT - PRASANTH - 9655666561',NULL,47,'2025-02-21 17:15:10','2025-02-21 17:15:29','accepted',NULL,'44.87',NULL,'pending',NULL,0,1),(17360,657,'7299927453',1,6,1,1,'QUO/SB-07343/2025','2025-02-21','259847.80',NULL,NULL,'259847.80','PLOT NO .38,THIRUMALAI NAGAR ANNEXE\r\n1ST MAIN ROAD,\r\nPERUNGUDI,\r\nCHENNAI-600096\r\nCONTACT - SUNDARALINGAM - 9994251625',NULL,47,'2025-02-21 17:17:33','2025-02-21 17:17:38','accepted',NULL,'4.70',NULL,'pending',NULL,0,3),(17361,116,'9841290618',1,3,2,1,'QUO/SB-07344/2025','2025-02-21','60681.50',NULL,NULL,'60681.50','No.54,Jain Udyogic, Sembudoss Street,Chennai, , 600001',NULL,24,'2025-02-21 17:41:38','2025-02-21 17:41:44','accepted',NULL,'1.10',NULL,'pending',NULL,0,1),(17362,1038,'9841078484',2,4,2,1,'QUO/SB-07345/2025','2025-02-21','544570.00',NULL,NULL,'544570.00','1,Sudharsan Nagar, Thirumullaivoyal, Tiruvallur, , 600062',NULL,24,'2025-02-21 17:45:49','2025-02-21 17:45:54','accepted',NULL,'10.00',NULL,'pending',NULL,0,1),(17363,1623,'9626325204',1,3,2,2,'QUO/SB-07346/2025','2025-02-21','1728818.00',NULL,NULL,'1728818.00','R.S.NO.72/1, Mailam Main Road, Charulatha Traders, Vanur taluk, Tiruchitrambalam,\r\nViluppuram, Tamil Nadu, 605111',NULL,26,'2025-02-21 17:54:29','2025-02-21 17:54:35','accepted',NULL,'32.00',NULL,'pending',NULL,0,1),(17364,1285,'9841060021',2,1,2,1,'QUO/SB-07347/2025','2025-02-21','593245.00',NULL,NULL,'593245.00','No.76, KUNDRATHUR TO PORUR MAIN ROAD, KUNDRATHUR, Kancheepuram, Tamil Nadu, 600069',NULL,37,'2025-02-21 18:01:40','2025-02-21 18:01:46','accepted',NULL,'11.00',NULL,'pending',NULL,0,1),(17365,1936,'9841060021',2,1,2,1,'QUO/SB-07348/2025','2025-02-21','53395.00',NULL,NULL,'53395.00','NO 20 21 22, GANAPATHY NAGAR, MADHA ENGINEERING COLLEGE, Kavanur, Kancheepuram, Tamil Nadu, 603203',NULL,37,'2025-02-21 18:03:38','2025-02-21 18:03:43','accepted',NULL,'1.00',NULL,'pending',NULL,0,1),(17366,286,'9094779299',1,5,2,2,'QUO/SB-07349/2025','2025-02-21','504025.20',NULL,NULL,'504025.20','D-72, K.G Road, Kilpauk, Chennai, Chennai, Tamil Nadu, 600010',NULL,27,'2025-02-21 18:08:35','2025-02-21 18:08:40','accepted',NULL,'9.15',NULL,'pending',NULL,0,1),(17367,286,'9094779299',1,5,2,2,'QUO/SB-07350/2025','2025-02-21','708837.80',NULL,NULL,'708837.80','D-72, K.G Road, Kilpauk, Chennai, Chennai, Tamil Nadu, 600010',NULL,27,'2025-02-21 18:13:30','2025-02-21 18:13:36','accepted',NULL,'12.85',NULL,'pending',NULL,0,1);

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,1),(1,2),(1,9),(1,12),(1,13),(1,16),(1,17),(1,24),(1,26),(1,27),(1,28),(1,39),(1,40),(2,1),(2,2),(2,9),(2,12),(2,13),(2,16),(2,17),(2,26),(2,27),(2,28),(2,39),(2,40),(3,1),(3,2),(3,9),(3,12),(3,13),(3,16),(3,17),(3,26),(3,27),(3,28),(3,39),(3,40),(4,1),(4,2),(4,9),(4,12),(4,13),(4,16),(4,17),(4,24),(4,26),(4,27),(4,28),(4,39),(4,40),(5,1),(5,2),(5,4),(5,5),(5,9),(5,13),(5,16),(5,17),(5,24),(5,25),(5,26),(5,27),(5,28),(5,29),(5,30),(5,31),(5,32),(5,33),(5,34),(5,35),(5,36),(5,37),(5,38),(5,39),(5,40),(6,1),(6,2),(6,4),(6,5),(6,9),(6,13),(6,16),(6,17),(6,25),(6,26),(6,27),(6,28),(6,29),(6,30),(6,31),(6,32),(6,33),(6,34),(6,35),(6,36),(6,37),(6,38),(6,39),(6,40),(7,1),(7,2),(7,4),(7,5),(7,9),(7,13),(7,16),(7,17),(7,25),(7,26),(7,27),(7,28),(7,29),(7,30),(7,31),(7,32),(7,33),(7,34),(7,35),(7,36),(7,37),(7,38),(7,39),(7,40),(8,1),(8,2),(8,4),(8,5),(8,9),(8,13),(8,16),(8,17),(8,24),(8,25),(8,26),(8,27),(8,28),(8,29),(8,30),(8,31),(8,32),(8,33),(8,34),(8,35),(8,36),(8,37),(8,38),(8,39),(8,40),(9,1),(9,2),(9,4),(9,5),(9,10),(9,13),(9,16),(9,17),(9,23),(9,24),(9,25),(9,26),(9,27),(9,28),(9,29),(9,30),(9,31),(9,32),(9,33),(9,34),(9,35),(9,36),(9,37),(9,38),(9,39),(9,40),(10,1),(10,2),(10,4),(10,5),(10,10),(10,13),(10,16),(10,17),(10,25),(10,26),(10,27),(10,28),(10,29),(10,30),(10,31),(10,32),(10,33),(10,34),(10,35),(10,36),(10,37),(10,38),(10,39),(10,40),(11,1),(11,2),(11,4),(11,5),(11,10),(11,13),(11,16),(11,17),(11,25),(11,26),(11,27),(11,28),(11,29),(11,30),(11,31),(11,32),(11,33),(11,34),(11,35),(11,36),(11,37),(11,38),(11,39),(11,40),(12,1),(12,2),(12,4),(12,5),(12,10),(12,13),(12,16),(12,17),(12,23),(12,24),(12,25),(12,26),(12,27),(12,28),(12,29),(12,30),(12,31),(12,32),(12,33),(12,34),(12,35),(12,36),(12,37),(12,38),(12,39),(12,40),(13,1),(13,2),(13,4),(13,5),(13,13),(13,16),(13,17),(13,24),(13,25),(13,26),(13,27),(13,28),(13,29),(13,30),(13,31),(13,32),(13,33),(13,34),(13,35),(13,36),(13,37),(13,38),(13,39),(13,40),(14,1),(14,2),(14,4),(14,5),(14,13),(14,16),(14,17),(14,25),(14,26),(14,27),(14,28),(14,29),(14,30),(14,31),(14,32),(14,33),(14,34),(14,35),(14,36),(14,37),(14,38),(14,39),(14,40),(15,1),(15,2),(15,4),(15,5),(15,13),(15,16),(15,17),(15,25),(15,26),(15,27),(15,28),(15,29),(15,30),(15,31),(15,32),(15,33),(15,34),(15,35),(15,36),(15,37),(15,38),(15,39),(15,40),(16,1),(16,2),(16,4),(16,5),(16,13),(16,16),(16,17),(16,24),(16,25),(16,26),(16,27),(16,28),(16,29),(16,30),(16,31),(16,32),(16,33),(16,34),(16,35),(16,36),(16,37),(16,38),(16,39),(16,40),(17,1),(17,2),(17,4),(17,13),(17,14),(17,16),(17,17),(17,18),(17,19),(17,20),(17,21),(17,24),(17,25),(17,26),(17,27),(17,28),(17,29),(17,30),(17,31),(17,32),(17,33),(17,34),(17,35),(17,36),(17,37),(17,38),(17,39),(17,40),(18,1),(18,2),(18,4),(18,13),(18,14),(18,16),(18,17),(18,18),(18,19),(18,20),(18,21),(18,25),(18,26),(18,27),(18,28),(18,29),(18,30),(18,31),(18,32),(18,33),(18,34),(18,35),(18,36),(18,37),(18,38),(18,39),(18,40),(19,1),(19,2),(19,4),(19,13),(19,14),(19,16),(19,17),(19,18),(19,19),(19,20),(19,21),(19,24),(19,25),(19,26),(19,27),(19,28),(19,29),(19,30),(19,31),(19,32),(19,33),(19,34),(19,35),(19,36),(19,37),(19,38),(19,39),(19,40),(20,1),(20,2),(20,4),(20,13),(20,14),(20,16),(20,17),(20,18),(20,19),(20,20),(20,21),(20,24),(20,25),(20,26),(20,27),(20,28),(20,29),(20,30),(20,31),(20,32),(20,33),(20,34),(20,35),(20,36),(20,37),(20,38),(20,39),(20,40),(21,1),(21,2),(21,4),(21,5),(21,13),(21,14),(21,16),(21,18),(21,19),(21,20),(21,21),(21,24),(21,25),(21,26),(21,27),(21,28),(21,29),(21,30),(21,31),(21,32),(21,33),(21,34),(21,35),(21,36),(21,37),(21,38),(21,39),(21,40),(22,1),(22,2),(22,4),(22,5),(22,13),(22,14),(22,16),(22,18),(22,19),(22,20),(22,21),(22,25),(22,26),(22,27),(22,28),(22,29),(22,30),(22,31),(22,32),(22,33),(22,34),(22,35),(22,36),(22,37),(22,38),(22,39),(22,40),(23,1),(23,2),(23,4),(23,5),(23,13),(23,14),(23,16),(23,18),(23,19),(23,20),(23,21),(23,25),(23,26),(23,27),(23,28),(23,29),(23,30),(23,31),(23,32),(23,33),(23,34),(23,35),(23,36),(23,37),(23,38),(23,39),(23,40),(24,1),(24,2),(24,4),(24,5),(24,13),(24,14),(24,16),(24,18),(24,19),(24,20),(24,21),(24,24),(24,25),(24,26),(24,27),(24,28),(24,29),(24,30),(24,31),(24,32),(24,33),(24,34),(24,35),(24,36),(24,37),(24,38),(24,39),(24,40),(25,1),(25,2),(25,4),(25,5),(25,16),(25,18),(25,19),(25,20),(25,21),(25,23),(25,24),(25,25),(25,26),(25,27),(25,28),(25,29),(25,30),(25,31),(25,32),(25,33),(25,34),(25,35),(25,36),(25,37),(25,38),(25,39),(25,40),(26,1),(26,2),(26,4),(26,5),(26,16),(26,18),(26,19),(26,20),(26,21),(26,23),(26,25),(26,26),(26,27),(26,28),(26,29),(26,30),(26,31),(26,32),(26,33),(26,34),(26,35),(26,36),(26,37),(26,38),(26,39),(26,40),(27,1),(27,2),(27,4),(27,5),(27,16),(27,18),(27,19),(27,20),(27,21),(27,23),(27,25),(27,26),(27,27),(27,28),(27,29),(27,30),(27,31),(27,32),(27,33),(27,34),(27,35),(27,36),(27,37),(27,38),(27,39),(27,40),(28,1),(28,2),(28,4),(28,5),(28,16),(28,18),(28,19),(28,20),(28,21),(28,23),(28,24),(28,25),(28,26),(28,27),(28,28),(28,29),(28,30),(28,31),(28,32),(28,33),(28,34),(28,35),(28,36),(28,37),(28,38),(28,39),(28,40),(29,1),(29,2),(29,4),(29,6),(29,12),(29,16),(29,23),(29,24),(29,25),(29,26),(29,27),(29,28),(29,29),(29,30),(29,31),(29,32),(29,33),(29,34),(29,35),(29,36),(29,37),(29,38),(29,39),(29,40),(30,1),(30,2),(30,4),(30,6),(30,12),(30,16),(30,23),(30,25),(30,26),(30,27),(30,28),(30,29),(30,30),(30,31),(30,32),(30,33),(30,34),(30,35),(30,36),(30,37),(30,38),(30,39),(30,40),(31,1),(31,2),(31,4),(31,6),(31,12),(31,16),(31,23),(31,25),(31,26),(31,27),(31,28),(31,29),(31,30),(31,31),(31,32),(31,33),(31,34),(31,35),(31,36),(31,37),(31,38),(31,39),(31,40),(32,1),(32,2),(32,4),(32,6),(32,12),(32,16),(32,23),(32,24),(32,25),(32,26),(32,27),(32,28),(32,29),(32,30),(32,31),(32,32),(32,33),(32,34),(32,35),(32,36),(32,37),(32,38),(32,39),(32,40),(33,1),(33,2),(33,4),(33,16),(33,22),(33,24),(33,25),(33,26),(33,27),(33,28),(33,29),(33,30),(33,31),(33,32),(33,33),(33,34),(33,35),(33,36),(33,37),(33,38),(33,39),(33,40),(34,1),(34,2),(34,4),(34,16),(34,22),(34,25),(34,26),(34,27),(34,28),(34,29),(34,30),(34,31),(34,32),(34,33),(34,34),(34,35),(34,36),(34,37),(34,38),(34,39),(34,40),(35,1),(35,2),(35,4),(35,16),(35,22),(35,25),(35,26),(35,27),(35,28),(35,29),(35,30),(35,31),(35,32),(35,33),(35,34),(35,35),(35,36),(35,37),(35,38),(35,39),(35,40),(36,1),(36,2),(36,4),(36,16),(36,22),(36,24),(36,25),(36,26),(36,27),(36,28),(36,29),(36,30),(36,31),(36,32),(36,33),(36,34),(36,35),(36,36),(36,37),(36,38),(36,39),(36,40),(37,1),(37,2),(37,4),(37,16),(37,24),(37,25),(37,26),(37,27),(37,28),(37,29),(37,30),(37,31),(37,32),(37,33),(37,34),(37,35),(37,36),(37,37),(37,38),(37,39),(37,40),(38,1),(38,2),(38,4),(38,16),(38,25),(38,26),(38,27),(38,28),(38,29),(38,30),(38,31),(38,32),(38,33),(38,34),(38,35),(38,36),(38,37),(38,38),(38,39),(38,40),(39,1),(39,2),(39,4),(39,16),(39,25),(39,26),(39,27),(39,28),(39,29),(39,30),(39,31),(39,32),(39,33),(39,34),(39,35),(39,36),(39,37),(39,38),(39,39),(39,40),(40,1),(40,2),(40,4),(40,16),(40,24),(40,25),(40,26),(40,27),(40,28),(40,29),(40,30),(40,31),(40,32),(40,33),(40,34),(40,35),(40,36),(40,37),(40,38),(40,39),(40,40),(41,1),(41,4),(41,12),(41,16),(41,24),(41,25),(41,26),(41,27),(41,28),(41,29),(41,30),(41,31),(41,32),(41,33),(41,34),(41,35),(41,36),(41,37),(41,38),(41,39),(41,40),(42,1),(42,4),(42,12),(42,16),(42,25),(42,26),(42,27),(42,28),(42,29),(42,30),(42,31),(42,32),(42,33),(42,34),(42,35),(42,36),(42,37),(42,38),(42,39),(42,40),(43,1),(43,4),(43,12),(43,16),(43,25),(43,26),(43,27),(43,28),(43,29),(43,30),(43,31),(43,32),(43,33),(43,34),(43,35),(43,36),(43,37),(43,38),(43,39),(43,40),(44,1),(44,4),(44,12),(44,16),(44,24),(44,25),(44,26),(44,27),(44,28),(44,29),(44,30),(44,31),(44,32),(44,33),(44,34),(44,35),(44,36),(44,37),(44,38),(44,39),(44,40),(45,1),(45,4),(45,16),(45,23),(45,24),(45,26),(45,27),(45,28),(45,29),(45,30),(45,31),(45,32),(45,33),(45,34),(45,35),(45,36),(45,37),(45,38),(45,39),(45,40),(46,1),(46,4),(46,16),(46,23),(46,26),(46,27),(46,28),(46,29),(46,30),(46,31),(46,32),(46,33),(46,34),(46,35),(46,36),(46,37),(46,38),(46,39),(46,40),(47,1),(47,4),(47,16),(47,23),(47,26),(47,27),(47,28),(47,29),(47,30),(47,31),(47,32),(47,33),(47,34),(47,35),(47,36),(47,37),(47,38),(47,39),(47,40),(48,1),(48,4),(48,16),(48,23),(48,24),(48,26),(48,27),(48,28),(48,29),(48,30),(48,31),(48,32),(48,33),(48,34),(48,35),(48,36),(48,37),(48,38),(48,39),(48,40),(49,1),(49,4),(49,7),(49,8),(49,11),(49,16),(49,24),(49,26),(49,27),(49,28),(49,29),(49,30),(49,31),(49,32),(49,33),(49,34),(49,35),(49,36),(49,37),(49,38),(49,39),(49,40),(50,1),(50,4),(50,7),(50,8),(50,11),(50,16),(50,26),(50,27),(50,28),(50,29),(50,30),(50,31),(50,32),(50,33),(50,34),(50,35),(50,36),(50,37),(50,38),(50,39),(50,40),(51,1),(51,4),(51,7),(51,8),(51,11),(51,16),(51,26),(51,27),(51,28),(51,29),(51,30),(51,31),(51,32),(51,33),(51,34),(51,35),(51,36),(51,37),(51,38),(51,39),(51,40),(52,1),(52,4),(52,7),(52,8),(52,11),(52,16),(52,24),(52,26),(52,27),(52,28),(52,29),(52,30),(52,31),(52,32),(52,33),(52,34),(52,35),(52,36),(52,37),(52,38),(52,39),(52,40),(53,1),(53,15),(53,16),(53,24),(53,26),(53,27),(53,28),(53,29),(53,30),(53,31),(53,32),(53,33),(53,34),(53,35),(53,36),(53,37),(53,38),(53,39),(53,40),(54,1),(54,15),(54,16),(54,26),(54,27),(54,28),(54,29),(54,30),(54,31),(54,32),(54,33),(54,34),(54,35),(54,36),(54,37),(54,38),(54,39),(54,40),(55,1),(55,15),(55,16),(55,26),(55,27),(55,28),(55,29),(55,30),(55,31),(55,32),(55,33),(55,34),(55,35),(55,36),(55,37),(55,38),(55,39),(55,40),(56,1),(56,15),(56,16),(56,24),(56,26),(56,27),(56,28),(56,29),(56,30),(56,31),(56,32),(56,33),(56,34),(56,35),(56,36),(56,37),(56,38),(56,39),(56,40),(57,1),(57,16),(57,24),(57,26),(57,27),(57,28),(57,29),(57,30),(57,31),(57,32),(57,33),(57,34),(57,35),(57,36),(57,37),(57,38),(57,39),(57,40),(58,1),(58,16),(58,26),(58,27),(58,28),(58,29),(58,30),(58,31),(58,32),(58,33),(58,34),(58,35),(58,36),(58,37),(58,38),(58,39),(58,40),(59,1),(59,16),(59,26),(59,27),(59,28),(59,29),(59,30),(59,31),(59,32),(59,33),(59,34),(59,35),(59,36),(59,37),(59,38),(59,39),(59,40),(60,1),(60,16),(60,24),(60,26),(60,27),(60,28),(60,29),(60,30),(60,31),(60,32),(60,33),(60,34),(60,35),(60,36),(60,37),(60,38),(60,39),(60,40),(61,1),(61,16),(61,24),(61,25),(61,26),(61,27),(61,28),(61,29),(61,30),(61,31),(61,32),(61,33),(61,34),(61,35),(61,36),(61,37),(61,38),(61,39),(61,40),(62,1),(62,16),(62,25),(62,26),(62,27),(62,28),(62,29),(62,30),(62,31),(62,32),(62,33),(62,34),(62,35),(62,36),(62,37),(62,38),(62,39),(62,40),(63,1),(63,16),(63,25),(63,26),(63,27),(63,28),(63,29),(63,30),(63,31),(63,32),(63,33),(63,34),(63,35),(63,36),(63,37),(63,38),(63,39),(63,40),(64,1),(64,16),(64,24),(64,25),(64,26),(64,27),(64,28),(64,29),(64,30),(64,31),(64,32),(64,33),(64,34),(64,35),(64,36),(64,37),(64,38),(64,39),(64,40),(65,1),(65,24),(65,25),(65,26),(65,27),(65,28),(65,29),(65,30),(65,31),(65,32),(65,33),(65,34),(65,35),(65,36),(65,37),(65,38),(65,39),(65,40),(66,1),(66,25),(66,26),(66,27),(66,28),(66,29),(66,30),(66,31),(66,32),(66,33),(66,34),(66,35),(66,36),(66,37),(66,38),(66,39),(66,40),(67,1),(67,25),(67,26),(67,27),(67,28),(67,29),(67,30),(67,31),(67,32),(67,33),(67,34),(67,35),(67,36),(67,37),(67,38),(67,39),(67,40),(68,1),(68,24),(68,25),(68,26),(68,27),(68,28),(68,29),(68,30),(68,31),(68,32),(68,33),(68,34),(68,35),(68,36),(68,37),(68,38),(68,39),(68,40),(69,1),(69,24),(69,25),(69,26),(69,27),(69,28),(69,29),(69,30),(69,31),(69,32),(69,33),(69,34),(69,35),(69,36),(69,37),(69,38),(69,39),(69,40),(70,1),(70,25),(70,26),(70,27),(70,28),(70,29),(70,30),(70,31),(70,32),(70,33),(70,34),(70,35),(70,36),(70,37),(70,38),(70,39),(70,40),(71,1),(71,25),(71,26),(71,27),(71,28),(71,29),(71,30),(71,31),(71,32),(71,33),(71,34),(71,35),(71,36),(71,37),(71,38),(71,39),(71,40),(72,1),(72,24),(72,25),(72,26),(72,27),(72,28),(72,29),(72,30),(72,31),(72,32),(72,33),(72,34),(72,35),(72,36),(72,37),(72,38),(72,39),(72,40);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Admin','web','2023-05-23 04:49:29','2023-05-23 04:49:29',NULL),(25,'Marketing Manager','web','2023-09-16 01:29:37','2023-09-16 01:29:37',NULL),(26,'General Manager','web','2023-10-05 14:10:05','2023-10-05 14:10:05',NULL),(27,'Advisor AP Sales','web','2023-10-05 14:10:34','2023-10-05 14:10:34',NULL),(28,'Senior Sales Manager','web','2023-10-05 14:11:07','2023-10-05 14:11:07',NULL),(29,'Area sales manager','web','2023-10-05 14:11:42','2023-10-05 14:11:42',NULL),(30,'Zonal sales manager','web','2023-10-05 14:12:29','2023-10-05 14:12:29','2023-11-18 12:40:51'),(31,'Area Sales Incharge','web','2023-10-05 14:13:08','2023-10-05 14:13:08','2023-11-18 12:59:40'),(32,'Assistant General Manager','web','2023-10-05 14:13:38','2023-10-05 14:13:38','2023-11-18 12:59:34'),(33,'Area Manager','web','2023-10-05 14:14:20','2023-10-05 14:14:20','2023-11-18 12:59:28'),(34,'AGM - Sales Development','web','2023-10-05 14:14:53','2023-10-05 14:14:53','2023-11-18 12:59:21'),(35,'Senior Area sales incharge','web','2023-10-05 14:15:39','2023-10-05 14:15:39','2023-11-18 12:59:15'),(36,'Sales coordinator','web','2023-10-05 14:17:20','2023-10-05 14:17:20','2023-11-18 12:59:08'),(37,'Sales Manager','web','2023-10-17 16:22:56','2023-10-17 16:22:56',NULL),(38,'Accounts','web','2023-10-31 17:07:24','2023-10-31 17:07:24',NULL),(39,'Project Sales Manager','web','2024-01-02 13:56:21','2024-01-02 13:56:21',NULL),(40,'Trade Sales Manager','web','2024-01-02 13:57:36','2024-01-02 13:57:36',NULL);

--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` varchar(255) DEFAULT NULL,
  `mobile_number` varchar(255) DEFAULT NULL,
  `billing_address` text DEFAULT NULL,
  `delivery_address` text DEFAULT NULL,
  `email_address` varchar(255) DEFAULT NULL,
  `credit_limit` decimal(8,2) DEFAULT NULL,
  `invoice_number` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `tax` decimal(8,2) DEFAULT NULL,
  `total` decimal(8,2) DEFAULT NULL,
  `update_payment_total` varchar(200) DEFAULT NULL,
  `sub_total_sum` varchar(255) DEFAULT NULL,
  `discount_type` int(10) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `shipping_amt` varchar(255) DEFAULT NULL,
  `tax_type` varchar(200) DEFAULT NULL,
  `discount_amount` varchar(200) DEFAULT NULL,
  `invoice_status` varchar(150) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `delivery_status` enum('Pending','Partial Delivery','Delivered') DEFAULT 'Pending',
  `payment_status` varchar(255) NOT NULL DEFAULT 'pending',
  `due_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` VALUES (24,'2','9876543211','address test\r\naddress2\r\nchennai, Tamilnadu 600029\r\nIndia','address test\r\naddress2\r\nchennai, Tamilnadu 600029\r\nIndia','ganesh@testing.com',20000.00,'2023/0001','2023-06-19',81.00,500.00,'350','1482.00',2,'estsghfd yb mahdf','2023-06-19 01:06:03','2023-06-22 01:35:28','100','2','31','quotation','Pending','Pending','pending','2023-06-20'),(26,'3','7894561230','695 Old Drive\r\nIpsum dolorem alias\r\nQuod id quo ad labo, Molestiae voluptate 66934\r\nDucimus cupidatat s','695 Old Drive\r\nIpsum dolorem alias\r\nQuod id quo ad labo, Molestiae voluptate 66934\r\nDucimus cupidatat s','qiwoxyb@mailinator.com',5.00,'2023/0002','2023-06-19',141.48,900.48,'500.48','786.00',2,'perfoma invoice store','2023-06-19 06:41:15','2023-06-22 01:35:31','0.00','2','27','proforma','Accepted','Pending','pending','2023-06-12'),(27,'3','7894561230','695 Old Drive\r\nIpsum dolorem alias\r\nQuod id quo ad labo, Molestiae voluptate 66934\r\nDucimus cupidatat s','695 Old Drive\r\nIpsum dolorem alias\r\nQuod id quo ad labo, Molestiae voluptate 66934\r\nDucimus cupidatat s','qiwoxyb@mailinator.com',5.00,'2023/0003','2000-01-01',2484.00,16200.00,NULL,'13800.00',2,'Adipisicing ipsum q','2023-06-19 06:44:13','2023-06-22 01:35:34','6','2','84','proforma','Rejected','Pending','pending','2023-06-29'),(28,'3','7894561230','695 Old Drive\r\nIpsum dolorem alias\r\nQuod id quo ad labo, Molestiae voluptate 66934\r\nDucimus cupidatat s','695 Old Drive\r\nIpsum dolorem alias\r\nQuod id quo ad labo, Molestiae voluptate 66934\r\nDucimus cupidatat s','qiwoxyb@mailinator.com',5.00,'2023/0004','2023-06-19',182.52,1190.52,'1100','1014.00',2,'fdgh fythyt urg','2023-06-19 06:59:08','2023-06-22 01:59:29','0.00','2','6','proforma','Accepted',NULL,'pending','2022-06-16'),(29,'3','7894561230','695 Old Drive\r\nIpsum dolorem alias\r\nQuod id quo ad labo, Molestiae voluptate 66934\r\nDucimus cupidatat s','695 Old Drive\r\nIpsum dolorem alias\r\nQuod id quo ad labo, Molestiae voluptate 66934\r\nDucimus cupidatat s','qiwoxyb@mailinator.com',5.00,'2023/0005','2023-06-19',237.60,1550.60,'550.6','1320.00',2,'test','2023-06-19 07:02:20','2023-06-22 01:35:37','0.00','2','6','proforma','Rejected','Pending','pending','2023-06-23');

--
-- Table structure for table `transports`
--

CREATE TABLE `transports` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `transports`
--

INSERT INTO `transports` VALUES (1,'Arranged by Suryadev','active','2023-08-29 01:34:45','2023-08-29 01:34:45',NULL),(2,'Arranged by Party','active','2023-08-29 01:35:03','2023-08-29 01:35:03',NULL);


