--
-- Host: 127.0.0.1    Database: katsurarollerind_erp
-- ------------------------------------------------------


--
-- Table structure for table `auto_polish`
--

CREATE TABLE `auto_polish` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_card_id` int(11) NOT NULL,
  `customer_name` varchar(256) DEFAULT NULL,
  `core_dimension` varchar(256) DEFAULT NULL,
  `compound` varchar(255) DEFAULT NULL,
  `final_mesure_dia` varchar(256) DEFAULT NULL,
  `status` varchar(28) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `auto_polish`
--


--
-- Table structure for table `bond_applies`
--

CREATE TABLE `bond_applies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_card_id` int(11) NOT NULL,
  `customer_name` varchar(256) DEFAULT NULL,
  `core_dimension` varchar(256) DEFAULT NULL,
  `compound` varchar(255) DEFAULT NULL,
  `mesure_core_dia` varchar(256) DEFAULT NULL,
  `bond_under_layer` varchar(256) DEFAULT NULL,
  `bond_top_layer` varchar(256) DEFAULT NULL,
  `status` varchar(28) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bond_applies`
--

INSERT INTO `bond_applies` VALUES
(3,1,'I THINK INK',NULL,NULL,'7','CHEMLOC 202 A/B','NA','DONE',1,NULL,'2025-03-31 11:50:49','2025-03-31 11:50:49',NULL);

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `party_id` bigint(20) unsigned DEFAULT NULL,
  `salutation` varchar(12) DEFAULT NULL,
  `first_name` varchar(64) NOT NULL,
  `middle_name` varchar(64) DEFAULT NULL,
  `last_name` varchar(64) DEFAULT NULL,
  `designation` varchar(64) DEFAULT NULL,
  `mobile1` varchar(64) DEFAULT NULL,
  `mobile2` varchar(64) DEFAULT NULL,
  `email1` varchar(64) DEFAULT NULL,
  `email2` varchar(64) DEFAULT NULL,
  `priority` varchar(12) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contacts_party_id_index` (`party_id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` VALUES
(1,44,'MR','SHASHIDAR',NULL,'B V',NULL,'+91 98455 82493',NULL,'info@esscee-enterprises.in',NULL,'SECONDARY',1,1,'2024-04-22 09:47:45','2024-05-22 05:18:36',NULL),
(2,44,'MR','KALAIAH','','K U','','+91 96866 76638','','purchase@esscee-enterprises.in','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(3,44,'MR','CHANDRASEKAR','','K R','','+91 98450 41914','','info@esscee-enterprises.in','info.esscee@gmail.com','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(4,40,'MR','K K','','SHARMA','CHIEF EXECUTIVE OFFICER','+91 99982 00088','','kks@yamir.in','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(5,40,'MR','HARDIK','','PANCHAL','ASST. GENERAL MANAGER - PURCHASE','','','hardik.panchal@yamir.in','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(6,40,'MR','HARISINGH','','BAJIYA','','','','harisingh.bajiya@yamir.in','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(7,40,'MR','AVINASH','','NIKUMBH','MANAGER','+91 97253 53526','','avinash.nikumbh@yamir.in','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(8,79,'MR','MUKESH','','JAIN','','+91 94489 92443','','md@microprintpack.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(9,79,'MR','SUBRAMANYA','','','','+91 98804 00600','','flex@microprintpack.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(10,1,'MR','ANKIT','HARISH','DOSHI','','+91 97020 85588','','converter@hotmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(11,2,'MR','MURARI','MOHAN','CHOUDHARI','','+91 97097 43878','','printrahul@gmail.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(12,2,'MR','RAHUL','','CHOUDHARI','','+91 82506 67027','','printrahul@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(13,3,'MR','SADHASIVAM','','K','','+91 94432 87502','','kalaimagallables@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(14,5,'MR','RAMANATH','','KAMATH','','+91 97421 89785','','info@sharadapress.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(15,8,'MR','ARVINDH','','PRABAKARAN','','+91 94898 31886','','arvindhprabakaran@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(16,9,'MR','BENITO','','JOS','','+91 94470 57778','','jaannekm@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(17,10,'MR','DEEPAK','ELIJAH','SAMUEL','','+91 80562 38535','','deepak.elijah@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(18,6,'MR','BALAJI','','','','+91 91764 45002','','balaji.books2@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(19,4,'MR','SHIVAPRAKASH','','K','','+91 98867 56761','','shivaprakash.kh@gmail.com','krupagraphics20@gmail.com','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(20,5,'MR','RAMANATH','','KAMATH','','+91 97421 89783','','info@sharadapress.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(22,78,'MR','BALA','','','','','','ammbala893@gmail.com','','ADDITIONAL',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(23,12,'MR','SRINIVASAN','','G','CHIEF OPERATING OFFICER','+91 99400 26113','','srini.kandalaaprints@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(24,13,'MR','MURUGAN','','GURUSAMY','','+91 94431 29832','','ssapsvks@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(25,14,'MR','BASKARAN','','B','','+91 94421 79629','','teeteekay.svks@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(26,15,'MR','NATESAN','','SIVAKUMAR','','+91 90030 57695','','printers2003@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(27,11,'MR','GUNASEKHAR','','REDDY','','+91 98456 05972','+91 96869 96788','reddy20000@gmail.com','pragatitechnologiesblr@gmail.com','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(28,16,'MR','MURALITHARAN','','V','','+91 94433 21183','','murali@theorient.in','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(29,18,'MR','MAHESH','','MALLAPPA','','+91 98455 00674','','krupactp@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(30,19,'MR','KUMARASWAMY','','D B','','+91 97310 59005','','jobworkappl@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(31,20,'MR','DALJIBHAI','M','CHAUDHARI','','+91 94267 56060','','simlamultiprint2021@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(32,20,'MR','BABUBHAI','M','CHAUDHARI','','+91 94265 68999','','simlamultiprint2021@gmail.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(33,21,'MR','MANAN','','DHRAFANI','','+91 94280 14591','','manandhrafani1997@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(34,24,'MR','RAJENDRA PRASAD','','REDDY THUMMURU','','+91 95057 32999','+91 96035 36536','foreseeindiasales@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(35,22,'MR','MUKHTAR','','ALAM','','+91 99106 78627','+91 87008 38226','dpprintingandbinding@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(36,22,'MR','AKIL','','ALAM','','+91 99106 78625','','dpprintingandbinding@gmail.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(37,22,'MR','FARMAN','','AHMAD','','+91 90442 33064','','productiondpprinting@gmail.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(38,26,'MR','SHAILESH','','MADHAN','','+91 77087 40995','','shaileshmadhan@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(39,25,'MR','DEEPAK','','BHATIA','','+91 98101 15023','','dpb.delhi@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(40,28,'MR','CHANDRASEKARAN','','B','','+91 94423 44963','','priyaaoffset@yahoo.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(41,29,'MR','PRAVEEN','','GUPTA','','+91 94251 11557','','praveenguptammc@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(42,29,'MR','ATUL','','BHARDWAJ','','+91 83686 18265','','praveenguptammc@gmail.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(43,29,'MR','JHONNY','','','','+91 97113 78013','','praveenguptammc@gmail.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(44,30,'MR','AKHIL','','CHOPRA','','+91 98100 07905','','akhil@mailap.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(45,30,'MR','ASHWANI','','CHOPRA','','','','ashwani@mailap.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(46,31,'MR','ANANDHA KUMAR','','S','','+91 94438 49856','','nadisundaramprintersppm@gmail.com     ','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(47,32,'MR','LAKSHMANAN','','','','+91 91761 38999','','tingoprints@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(48,34,'MR','JAISON','T','FRANCIS','','+91 94474 90996','','jaisontf@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(49,35,'MR','NIKHIL','N','SIRPAUL','','+91 98119 50040 ','','nikhilg91@gmail.com','nikhil223@yahoo.com','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(50,36,'MR','VIJAY','','SHAH','','+91 98240 22334','','chiragoffset@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(51,41,'MR','NITIN','','GUPTA','','+91 98115 81918','','rpprinters68@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(52,38,'MR','BRAJESH','','TIWARI','SR. MANAGER - ENGINEERING SERVICES','+91 99251 55509','','brajesh.t@reproindialtd.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(53,43,'MR','MUNEER','','HOPUZ','','+91 98476 74503','','hopuzprinterskerala@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(54,43,'MR','AKHIL','','HOPUZ','','+91 92077 00022','+91 92077 00011','hopuzprinterskerala@gmail.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(55,46,'MR','PANKAJ','','GAKHAR','','+91 99111 69338','','aonevendors123@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(56,47,'MR','RONNY VARGHESE','','ABRAHAM','','+91 98462 36802','','ronnyKaripuzha@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(57,48,'MR','RAKESH','','SHARMA','','+91 93133 72130','','chandupress@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(58,49,'MR','BALAKRISHNAN','','','','+91 97890 58407','','info4spc@gmail.com','bala@packoprint.com','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(59,50,'MR','RAJESH','','AGRAWAL','','+91 93587 03141','','jbpublishing@rediffmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(60,53,'MR','SHARIQUE','','KAMAL M','','+91 99311 55012','+91 90380 06888','onlinegraph@yahoo.com','onlinegraphics22@gmail.com','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(61,52,'MR','SHIVA','','SHANKAR','','+91 97877 22731','','sale@safireprinting.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(62,54,'MR','BHANU','','BHINANI','','+91 93100 11010','','globecalco@yahoo.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(63,55,'MR','JANAKARAJAN','','K','','+91 99449 34903','','md@starcolourpark.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(64,56,'MR','PRAKASH','','A S','','+91 90366 44440','+91 90366 44441','infoscprints@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(65,59,'MR','RAMESH','','KATARIA','','+91 98100 06019','','rameshprinter@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(66,60,'MR','MANOJ','','VINAYA','','+91 93494 05442','+91 97476 46815','vinayaprinters@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(67,60,'MR','SASI','RAVUNNI KOCHITTAMAN','R K','','+91 93889 63064','','vinayaprinters@gmail.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(68,61,'MR','BRAJESH','','TIWARI','SR. MANAGER - ENGINEERING SERVICES','+91 99251 55509','','brajesh.t@reproindialtd.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(69,58,'MR','SONY','','GEORGE','','+91 94462 19584','','printparkoffsetprinters@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(70,62,'MR','MITHESH','BETTASWAMY','BHYRAPPAJI','','+91 94803 13909','','venkateshwaraprinters2010@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(71,64,'MR','MUKESH','RAVICHANDRA','SHETH','','+91 98986 17398','+91 94082 58582','naitikenterprise298@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(72,65,'MR','MOHAN BALAJI','','R','','+91 89397 55533','','ganeshaprint3@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(73,66,'MR','ALOK','','TRIPATHI','','+91 98182 02914','','yashprintographics@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(74,67,'MR','RAVIKUMAR','R','PATEL','','+91 85111 01999','','ravi@modernprintingmachinery.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(75,68,'MR','DHIREN','','THAKKAR','','+91 98201 45290','','nirmanmail@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(76,70,'MR','VARUN','','JOHAR','','+91 98103 86546','','varun@microprintsindia.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(77,71,'MR','VELUMANI','','','','+91 98433 32288','','maduraiprintandpack23@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(78,71,'MR','RAMESH','','','','+91 93644 55572','','maduraiprintandpack23@gmail.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(79,72,'MR','JAGMAL','','CHAUDHARY','','','','info@sgprintpacks.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(80,72,'MR','MOHIT','','CHAUDHARY','','+91 97187 49198','','mohit@sgprintpacks.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(81,73,'MR','ANKIT','','PATEL','','+91 98250 71655','','ankit.radhe@yahoo.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(82,74,'MR','KARTHIK','','D','','+91 98405 77894','+91 94452 96131','kumaraguruprints@gmail.com','kumaraguruprints.sales@gmail.com','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(83,69,'MR','JANARTHANAN','','H','','+91 92448 25555','','arkahitech@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(84,77,'MR','SURJEET','','SINGH','','+91 83840 87801','+91 99102 06924','ss.capital1993@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(85,78,'MR','JAYAKUMAR','','S','','+91 97900 14256','','systemsasiamatch@gmail.com','spares@asiamatch.in','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(86,80,'MR','RAKSHIT','','CHAUDHARY','','+91 90271 20816','','Rakshitlamination@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(87,63,'MR','ASHOK','','BHATT','','+91 97648 22322','','a_bhatt@dbcorp.in','','ADDITIONAL',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(88,63,'MR','VED','','SHARMA','','+91 96722 20234','','ved.sharma@dbcorp.in','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(89,63,'MR','SANJEEV','','PANDEY','','+91 93011 90997','','sanjeev.pandey1@dbcorp.in','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(90,63,'MR','ASHISH','','KUMAWAT','','+91 99830 97000','','a.kumawat@dbcorp.in','','ADDITIONAL',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(91,76,'MR','SRINIVAS','','KRISHNEGOWDA','','+91 91484 18200','','srinivaskrishnegowda@bbmpackaging.in','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(92,84,'MR','ANWAR','','MANSURI','','+91 98250 55260','','idealdb786@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(93,85,'MR','SOURABH','','DHAMECHA','','+91 87007 72995','','ecopacksolutions360@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(94,86,'MR','JASVIR','','SINGH','','+91 99105 88744','','qualityoffsetprinters5@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(95,27,'MR','DEEPAK','PRAKASH','MITTAL','','+91 98113 40726','','mittalenterprises1992@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(96,87,'MR','SANDIP','JUGALDAS','MISHRA','','+91 97127 49246','','jkprinters688@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(97,88,'MR','SANTOSH','','SAWANT','','+91 88797 97006','','santosh@fourelementsllp.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(98,89,'MR','ARUN','','KUMAR','','+91 75023 33333','','yaapress@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(99,90,'MR','RAVINDER','','KUMAR','','+91 98101 53307','+91 98101 23207','ravi.pxperts@gmail.com','info.pxperts@gmail.com ','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(100,37,'MR','CHENGA','','REDDY M','','+91 98852 42288','','chenga@citruspack.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(101,91,'MR','MANGAL','','SAIN','','+91 99906 15589','','mangel.sen@dbcorp.in','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(102,92,'MR','SUDHIR','','MITTAL','','+91 98117 56181','','mittalprintpack@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(103,93,'MR','GHANSHYAMBHAI','RAMANBHAI','PATEL','','+91 98259 31312','','aakrutiprinters90@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(104,82,'MR','RAJAT','N','KEDIA','','+91 63597 12000','','rajat.greenchilli@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(105,98,'MR','SARAVANAN','','M','','+91 92448 08052','','tigiprintroof@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(106,96,'MR','RAKESH','','BHARGAVA','','+91 98101 93546','','rakmopress06@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(107,96,'MR','MUKESH','','BHARGAVA','','+91 98110 57582','','rakmopress06@gmail.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(108,33,'MR','KAMAL','','GUPTA','','+91 98110 26253','','salasar1@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(109,99,'MR','SANJAY','','GOEL','','+91 93542 16020','','firstpress@gmail.com','','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(110,100,'MR','MOHAMED','','KHALID','','+91 93112 58997','','orders@printofast.com','quotation.options@gmail.com','PRIMARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(111,7,'Mr','AKSHAY',NULL,'KAUSHAL','DIRECTOR','9599299801',NULL,'akshay@provin.in',NULL,'Primary',1,1,'2024-05-27 23:44:46','2024-06-06 04:24:07',NULL),
(112,107,'MR','GURUPINDER','SINGH','VOHRA','PROPRIETOR','+91 98101 58859',NULL,'gurpinder.vohra@gmail.com',NULL,'PRIMARY',1,NULL,'2024-11-15 23:07:57','2024-11-15 23:07:57',NULL),
(113,106,'MR','KRISHNA DAS',NULL,'M P',NULL,'+91 90611 53815',NULL,'krishnadas.mp@thomsonpress.com',NULL,'PRIMARY',1,NULL,'2024-11-15 23:09:09','2024-11-15 23:09:09',NULL),
(114,108,'MR','RAVI','DEV','SHROFF','DIRECTOR','+91 98100 06797',NULL,'ravi.shroff@nutech.in',NULL,'PRIMARY',1,NULL,'2024-11-15 23:09:51','2024-11-15 23:09:51',NULL),
(115,110,'Mr','Utkal','kumar','moharana','Manager','9599299801',NULL,'utkal@katsura-roller-india.in',NULL,'Primary',1,1,'2024-12-10 00:04:42','2024-12-10 00:11:04',NULL),
(116,1,'MR','Gaurav','','Kumar','','+91 97020 85588','','gaurav@alpinesoftit.com','','SECONDARY',1,NULL,'2024-04-22 09:47:45','2024-04-22 09:49:09',NULL),
(117,111,'MR','ROHIT',NULL,'JAIN','DIRECTOR','93341 16553',NULL,'theoffsetters@gmail.com',NULL,'PRIMARY',20,NULL,'2025-01-21 04:08:09','2025-01-21 04:08:09',NULL),
(118,112,'MR','RAJIV',NULL,'BHARGAVA','DIRECTOR','9810388542',NULL,'info@hbdpackaging.com',NULL,'PRIMARY',20,NULL,'2025-01-23 00:43:19','2025-01-23 00:43:19',NULL),
(119,113,'MR','tesing',NULL,'tesing','tesing','2323232323',NULL,'info@provin.in','info@provin.in','PRIMARY',20,NULL,'2025-01-27 04:16:51','2025-01-27 04:16:51',NULL),
(120,114,'MR','VASANTHAKUMAR',NULL,'K',NULL,'87609 94269','94435 94269','roshanprintersvdl@gmail.com',NULL,'PRIMARY',20,NULL,'2025-02-07 04:13:51','2025-02-07 04:13:51',NULL),
(121,115,'MR','MINESH',NULL,'PATEL',NULL,'+91 98250 38799',NULL,'info@shreedharprinters.in','info@shreedharprinters.in','PRIMARY',1,NULL,'2025-02-08 01:00:44','2025-02-08 01:00:44',NULL),
(122,116,'MR','KARTHIK',NULL,'RAVI',NULL,'+91 90030 25191',NULL,'karthik@multivistaglobal.com',NULL,'PRIMARY',1,NULL,'2025-02-11 01:11:08','2025-02-11 01:11:08',NULL),
(123,117,'MR','JAKKID RAVINDRA',NULL,'REDDY',NULL,'+91 90006 05999',NULL,'ravisdpackaging@gmail.com','ravijdrpackaging@gmail.com','PRIMARY',1,NULL,'2025-02-11 22:21:46','2025-02-11 22:21:46',NULL),
(124,118,'MR','KAILASH',NULL,'JAJOO',NULL,'+91 98101 10914',NULL,'info@alltimeoffset.com',NULL,'PRIMARY',1,NULL,'2025-02-11 22:45:31','2025-02-11 22:45:31',NULL),
(125,119,'MR','Ashok',NULL,'Kumar',NULL,'+91 91766 20232',NULL,'rathnaindia@yahoo.com',NULL,'PRIMARY',1,NULL,'2025-02-12 05:34:04','2025-02-12 05:34:04',NULL),
(126,120,'MR','KAYYUM',NULL,'MEMON',NULL,'+91 98250 93100',NULL,'kayyum@concordprinting.in','concordenterprise@gmail.com','PRIMARY',1,NULL,'2025-02-13 03:47:35','2025-02-13 03:47:35',NULL),
(127,110,'MR','SATISH KUMAR',NULL,'M S',NULL,'+91 99017 72298',NULL,'satish@manipalgroup.info',NULL,'PRIMARY',1,NULL,'2025-02-13 04:24:58','2025-02-13 04:24:58',NULL),
(128,121,'MR','SANJAY',NULL,'NAGPAL',NULL,'+91 98100 65842',NULL,'sanjay@azurepress.net','azurepress@gmail.com','PRIMARY',1,NULL,'2025-02-13 06:15:41','2025-02-13 06:15:41',NULL),
(129,122,'MR','KAYYUM',NULL,'MEMON',NULL,'+91 98250 93100',NULL,'kayyum@concordprinting.in','concordenterprise@gmail.com','PRIMARY',1,NULL,'2025-02-14 03:34:59','2025-02-14 03:34:59',NULL),
(130,123,'MR','GIRISH',NULL,'PATEL',NULL,'+91 98249 91999',NULL,'admin@modernmultiprint.in',NULL,'PRIMARY',1,NULL,'2025-02-14 05:11:18','2025-02-14 05:11:18',NULL),
(131,124,'MR','RAJIV',NULL,'BHARGAVA',NULL,'+91 98101 10805',NULL,'rajiv.bhargava@hbdpackaging.com','info@hbdpackaging.com','PRIMARY',1,NULL,'2025-02-14 23:19:44','2025-02-14 23:19:44',NULL),
(132,125,'MR','GANESH','.','.',NULL,'9726722022','9824084222','pranampp2023@gmail.com',NULL,'PRIMARY',1,1,'2025-02-17 01:26:43','2025-02-17 01:29:48',NULL),
(133,126,'MR','BHARAT',NULL,'.',NULL,'9810157301','9871013777','rajkamalprinters@gmail.com',NULL,'PRIMARY',1,NULL,'2025-02-18 01:41:44','2025-02-18 01:41:44',NULL),
(134,127,'MR','VIKAS',NULL,'ARORA',NULL,'+91 93116 22258',NULL,'royaloffsetprinters@gmail.com',NULL,'PRIMARY',1,NULL,'2025-02-18 02:43:39','2025-02-18 02:43:39',NULL),
(135,128,'MR','AJAY',NULL,'SUNKU S G',NULL,'+91 98440 66044',NULL,'pmoffset@gmail.com','ajay@pmoffsetprinters.com','PRIMARY',1,NULL,'2025-02-19 03:10:34','2025-02-19 03:10:34',NULL),
(136,129,'MR','PIYUSH',NULL,'KAPOOR',NULL,'9555500045',NULL,'customersupport@katsura-roller-india.in',NULL,NULL,1,NULL,'2025-02-19 05:01:36','2025-02-19 05:01:36',NULL),
(137,130,'MR','Venkatesh',NULL,'PAI',NULL,'9880045855',NULL,'vpai.sudhindra@gmail.com',NULL,'PRIMARY',1,NULL,'2025-02-20 03:03:26','2025-02-20 03:03:26',NULL),
(138,131,'MR','JAYMIN',NULL,'PATEL',NULL,'+91 97261 24085',NULL,'sale.4elements@gmail.com',NULL,'PRIMARY',1,20,'2025-02-21 01:21:59','2025-02-21 03:00:26',NULL),
(139,132,'MR','SANTOSH',NULL,'BAMNE',NULL,'+91 98210 73986',NULL,'santoshbamne25@gmail.com',NULL,'PRIMARY',1,20,'2025-02-21 01:37:15','2025-02-21 03:00:03',NULL),
(140,133,'MR','FALITH',NULL,'PANDYA',NULL,'+91 99243 16160',NULL,'falitpandya@gmail.com','faliith@printvision.in','PRIMARY',1,NULL,'2025-02-22 06:58:02','2025-02-22 06:58:02',NULL),
(141,134,'MR','Shripal R',NULL,'Patel',NULL,'9327008607','9265268451','design@oceansdeepprinters.com',NULL,'PRIMARY',1,1,'2025-02-25 06:26:56','2025-02-25 06:32:30',NULL),
(142,135,'MR','VINAY',NULL,'BAWEJA',NULL,'+91 93100 49515',NULL,'Vny_60@yahoo.com','vibappl@hotmail.com','PRIMARY',1,NULL,'2025-02-25 07:05:35','2025-02-25 07:05:35',NULL),
(143,136,'MR','RANJITH',NULL,'.',NULL,'8129577795',NULL,'sterlingadmin@gmail.com',NULL,'PRIMARY',1,NULL,'2025-03-02 23:20:48','2025-03-02 23:20:48',NULL),
(144,136,'MR','RANJITH',NULL,'.',NULL,'8129577795',NULL,'sterlingadmin@gmail.com',NULL,'PRIMARY',1,NULL,'2025-03-03 07:22:55','2025-03-03 07:22:55',NULL);

--
-- Table structure for table `derubbers`
--

CREATE TABLE `derubbers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_card_id` int(11) NOT NULL,
  `customer_name` varchar(256) DEFAULT NULL,
  `core_dimension` varchar(256) DEFAULT NULL,
  `mesure_core_dia` varchar(256) DEFAULT NULL,
  `target_core_dia` varchar(256) DEFAULT NULL,
  `status` varchar(28) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `derubbers`
--

INSERT INTO `derubbers` VALUES
(3,1,'I THINK INK',NULL,'4',NULL,'DONE',1,NULL,'2025-03-31 11:50:28','2025-03-31 11:50:28',NULL);

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

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

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `final_grinds`
--

CREATE TABLE `final_grinds` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_card_id` int(11) NOT NULL,
  `customer_name` varchar(256) DEFAULT NULL,
  `core_dimension` varchar(256) DEFAULT NULL,
  `compound` varchar(255) DEFAULT NULL,
  `target_roller_dia` varchar(256) DEFAULT NULL,
  `mesure_dia` varchar(256) DEFAULT NULL,
  `status` varchar(28) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `final_grinds`
--


--
-- Table structure for table `inspections`
--

CREATE TABLE `inspections` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_card_id` int(11) NOT NULL,
  `customer_name` varchar(256) DEFAULT NULL,
  `core_dimension` varchar(256) DEFAULT NULL,
  `compound` varchar(255) DEFAULT NULL,
  `roller_length1` varchar(256) DEFAULT NULL,
  `roller_length2` varchar(256) DEFAULT NULL,
  `roller_length3` varchar(256) DEFAULT NULL,
  `roller_length4` varchar(256) DEFAULT NULL,
  `roller_length5` varchar(256) DEFAULT NULL,
  `roller_diameter_x_1` varchar(256) DEFAULT NULL,
  `roller_diameter_x_2` varchar(256) DEFAULT NULL,
  `roller_diameter_x_3` varchar(256) DEFAULT NULL,
  `roller_diameter_x_4` varchar(256) DEFAULT NULL,
  `roller_diameter_x_5` varchar(256) DEFAULT NULL,
  `roller_diameter_y_1` varchar(256) DEFAULT NULL,
  `roller_diameter_y_2` varchar(256) DEFAULT NULL,
  `roller_diameter_y_3` varchar(256) DEFAULT NULL,
  `roller_diameter_y_4` varchar(256) DEFAULT NULL,
  `roller_diameter_y_5` varchar(256) DEFAULT NULL,
  `hardness_1` varchar(256) DEFAULT NULL,
  `hardness_2` varchar(256) DEFAULT NULL,
  `hardness_3` varchar(256) DEFAULT NULL,
  `hardness_4` varchar(256) DEFAULT NULL,
  `hardness_5` varchar(256) DEFAULT NULL,
  `cylindercity_1` varchar(256) DEFAULT NULL,
  `cylindercity_2` varchar(256) DEFAULT NULL,
  `cylindercity_3` varchar(256) DEFAULT NULL,
  `cylindercity_4` varchar(256) DEFAULT NULL,
  `cylindercity_5` varchar(256) DEFAULT NULL,
  `roundness_1` varchar(256) DEFAULT NULL,
  `roundness_2` varchar(256) DEFAULT NULL,
  `roundness_3` varchar(256) DEFAULT NULL,
  `roundness_4` varchar(256) DEFAULT NULL,
  `roundness_5` varchar(256) DEFAULT NULL,
  `roughness_1` varchar(128) DEFAULT NULL,
  `remarks` varchar(512) DEFAULT NULL,
  `status` varchar(28) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inspections`
--


--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(2) NOT NULL,
  `invoice_number` varchar(32) NOT NULL,
  `invoice_date` date NOT NULL,
  `currency` varchar(3) NOT NULL DEFAULT 'INR',
  `amount` decimal(12,2) NOT NULL,
  `gst_rate` tinyint(4) NOT NULL,
  `cgst` decimal(12,2) NOT NULL DEFAULT 0.00,
  `sgst` decimal(12,2) NOT NULL DEFAULT 0.00,
  `igst` decimal(12,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT '%',
  `shipping_charges` decimal(12,2) NOT NULL DEFAULT 0.00,
  `core_repair_charges` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_in_words` varchar(1024) DEFAULT NULL,
  `party_id` int(11) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `pincode` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `region` varchar(255) DEFAULT NULL,
  `gstin` varchar(255) DEFAULT NULL,
  `contact_ids` varchar(128) DEFAULT NULL,
  `invoice_for` varchar(255) DEFAULT NULL,
  `invoice_for_emails` varchar(512) DEFAULT NULL,
  `inquiry` varchar(255) DEFAULT NULL,
  `shipment_terms` varchar(255) DEFAULT NULL,
  `payment_terms` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `order_type` varchar(255) NOT NULL,
  `manufacturer_id` int(11) NOT NULL,
  `machine_model_id` int(11) NOT NULL,
  `roller_type` varchar(255) DEFAULT NULL,
  `variant` varchar(128) DEFAULT NULL,
  `status` varchar(12) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoices_invoice_number_unique` (`invoice_number`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoices`
--

INSERT INTO `invoices` VALUES
(1,'DO','KPI/DO/24-25/0001','2025-03-17','INR',23050.00,18,0.00,0.00,4011.00,10.00,5.00,500.00,26293.00,'Rupees Twenty Six Thousands Two Hundred  Ninety Three   Only',1,'7/3, SADANWADI, OPP BHANDUP POLICE STATION, OFF LBS MARG, LAKE ROAD, BHANDUP (W)','MUMBAI','MAHARASHTRA','400078','INDIA','WEST','27AHSPD9460C1Z6','10, 116','MR ANKIT DOSHI, MR Gaurav Kumar','converter@hotmail.com, gaurav@alpinesoftit.com','Mail','5','100','Size; Rubber Diameter x Core Diameter x Rubber Length, Maker\'s inspection is to be final as for the quality.',NULL,'Rerubberization',1,1,NULL,'Oil Base','Generated',1,NULL,'2025-03-17 06:11:53','2025-03-17 06:14:32',NULL),
(2,'DO','KPI/DO/24-25/0002','2025-03-18','INR',23050.00,18,0.00,0.00,4191.00,10.00,5.00,1500.00,27473.00,'Rupees Twenty Seven Thousands Four Hundred  Seventy Three   Only',1,'7/3, SADANWADI, OPP BHANDUP POLICE STATION, OFF LBS MARG, LAKE ROAD, BHANDUP (W)','MUMBAI','MAHARASHTRA','400078','INDIA','WEST','27AHSPD9460C1Z6','10, 116','MR ANKIT DOSHI, MR Gaurav Kumar','converter@hotmail.com, gaurav@alpinesoftit.com','Mail','5','100','Size; Rubber Diameter x Core Diameter x Rubber Length, Maker\'s inspection is to be final as for the quality.',NULL,'Rerubberization',1,1,NULL,'Oil Base','Generated',1,NULL,'2025-03-18 03:49:10','2025-03-18 03:49:10',NULL);

--
-- Table structure for table `invoices_items`
--

CREATE TABLE `invoices_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) NOT NULL,
  `roller_id` int(11) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `dimensions` varchar(255) DEFAULT NULL,
  `compound` varchar(255) DEFAULT NULL,
  `compound_id` int(11) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `rate` decimal(8,2) NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  `cgst` decimal(8,2) NOT NULL,
  `sgst` decimal(8,2) NOT NULL,
  `igst` decimal(8,2) NOT NULL,
  `total` decimal(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoices_items`
--

INSERT INTO `invoices_items` VALUES
(14,1,1,'Ink first form roller - 520GX','49x510x595','SIGMA ECO 30',1,1,4998.00,4998.00,0.00,0.00,900.00,5898.00,NULL,NULL),
(15,1,2,'Ink first form roller (Osc) - 520GX','49x510x595','SIGMA ECO 30',1,0,4998.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(16,1,3,'Ink second form roller  - 520GX','47x510x560','SIGMA ECO 30',1,0,4794.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(17,1,4,'Ink third form roller  - 520GX','45x510x576','SIGMA ECO 30',1,2,4590.00,9180.00,0.00,0.00,1652.00,10832.00,NULL,NULL),
(18,1,5,'Ink fourth form roller  - 520GX','51x510x614','SIGMA ECO 30',1,0,5202.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(19,1,13,'Plate holding roller  - 520GX','22x504x538','SIGMA ECO 30',1,4,2218.00,8872.00,0.00,0.00,1597.00,10469.00,NULL,NULL),
(20,1,10,'Ink ductor roller  - 520GX','45.5x515x607','SIGMA ECO 30',2,0,4686.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(21,1,6,'? 52 distributor roller  - 520GX','52x515x600','SIGMA ECO 30',3,0,5356.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(22,1,7,'? 52 distributor roller  - 520GX','52x515x600','SIGMA ECO 30',3,0,5356.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(23,1,8,'? 52 distributor roller  - 520GX','52x515x640','SIGMA ECO 30',3,0,5356.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(24,1,9,'? 52 distributor roller  - 520GX','52x515x640','SIGMA ECO 30',3,0,5356.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(25,1,11,'Water form roller  - 520GX','50.5x511x615','HW-25',4,0,5677.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(26,1,12,'Metering roller  - 520GX','63x548x632','HW-25',5,0,7595.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(27,2,1,'Ink first form roller - 520GX','49x510x595','SIGMA ECO 30',1,1,4998.00,4998.00,0.00,0.00,900.00,5898.00,NULL,NULL),
(28,2,2,'Ink first form roller (Osc) - 520GX','49x510x595','SIGMA ECO 30',1,0,4998.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(29,2,3,'Ink second form roller  - 520GX','47x510x560','SIGMA ECO 30',1,0,4794.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(30,2,4,'Ink third form roller  - 520GX','45x510x576','SIGMA ECO 30',1,2,4590.00,9180.00,0.00,0.00,1652.00,10832.00,NULL,NULL),
(31,2,5,'Ink fourth form roller  - 520GX','51x510x614','SIGMA ECO 30',1,0,5202.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(32,2,13,'Plate holding roller  - 520GX','22x504x538','SIGMA ECO 30',1,4,2218.00,8872.00,0.00,0.00,1597.00,10469.00,NULL,NULL),
(33,2,10,'Ink ductor roller  - 520GX','45.5x515x607','SIGMA ECO 30',2,0,4686.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(34,2,6,'? 52 distributor roller  - 520GX','52x515x600','SIGMA ECO 30',3,0,5356.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(35,2,7,'? 52 distributor roller  - 520GX','52x515x600','SIGMA ECO 30',3,0,5356.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(36,2,8,'? 52 distributor roller  - 520GX','52x515x640','SIGMA ECO 30',3,0,5356.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(37,2,9,'? 52 distributor roller  - 520GX','52x515x640','SIGMA ECO 30',3,0,5356.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(38,2,11,'Water form roller  - 520GX','50.5x511x615','HW-25',4,0,5677.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(39,2,12,'Metering roller  - 520GX','63x548x632','HW-25',5,0,7595.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL);

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `job_cards`
--

CREATE TABLE `job_cards` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_card_no` varchar(32) NOT NULL,
  `job_card_date` date NOT NULL,
  `shipping_date` date DEFAULT NULL,
  `order_no` varchar(32) NOT NULL,
  `party_id` int(11) NOT NULL,
  `roller_no` varchar(32) NOT NULL,
  `roller_id` int(11) DEFAULT NULL,
  `roller_dimensions` varchar(64) NOT NULL,
  `hardness` varchar(255) NOT NULL,
  `final_dimensions` varchar(64) DEFAULT NULL,
  `drawing_no` varchar(64) NOT NULL,
  `compound` varchar(255) NOT NULL,
  `compound_id` int(11) DEFAULT NULL,
  `derubber_barcode` varchar(32) DEFAULT NULL,
  `derubber_status` varchar(32) DEFAULT NULL,
  `derubber_date` timestamp NULL DEFAULT NULL,
  `sand_blast_barcode` varchar(32) DEFAULT NULL,
  `sand_blast_status` varchar(32) DEFAULT NULL,
  `sand_blast_date` timestamp NULL DEFAULT NULL,
  `bond_apply_barcode` varchar(32) DEFAULT NULL,
  `bond_apply_status` varchar(32) DEFAULT NULL,
  `bond_apply_date` timestamp NULL DEFAULT NULL,
  `sheet_apply_barcode` varchar(32) DEFAULT NULL,
  `sheet_apply_status` varchar(32) DEFAULT NULL,
  `sheet_apply_date` timestamp NULL DEFAULT NULL,
  `vulcanization_barcode` varchar(32) DEFAULT NULL,
  `vulcanization_status` varchar(32) DEFAULT NULL,
  `vulcanization_date` timestamp NULL DEFAULT NULL,
  `rough_grinding_barcode` varchar(32) DEFAULT NULL,
  `rough_grinding_status` varchar(32) DEFAULT NULL,
  `rough_grinding_date` timestamp NULL DEFAULT NULL,
  `side_cutting_barcode` varchar(32) DEFAULT NULL,
  `side_cutting_status` varchar(32) DEFAULT NULL,
  `side_cutting_date` timestamp NULL DEFAULT NULL,
  `final_grinding_barcode` varchar(32) DEFAULT NULL,
  `final_grinding_status` varchar(32) DEFAULT NULL,
  `final_grinding_date` timestamp NULL DEFAULT NULL,
  `auto_polish_barcode` varchar(32) DEFAULT NULL,
  `auto_polish_status` varchar(32) DEFAULT NULL,
  `auto_polish_date` timestamp NULL DEFAULT NULL,
  `finishing_barcode` varchar(32) DEFAULT NULL,
  `finishing_status` varchar(32) DEFAULT NULL,
  `finishing_date` timestamp NULL DEFAULT NULL,
  `shipping_barcode` varchar(32) DEFAULT NULL,
  `shipping_status` varchar(32) DEFAULT NULL,
  `shipping_datetime` timestamp NULL DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_cards`
--

INSERT INTO `job_cards` VALUES
(1,'25030001','2025-03-18','2025-03-18','KPI/DO/24-25/0001',1,'A101',1,'49x0x510x595','(30°)',NULL,'1','SIGMA ECO 30',1,'25030001A','REJECT','2025-03-31 11:50:28','25030001B','REJECT','2025-03-31 11:50:40','25030001C','REJECT','2025-03-31 11:50:49','25030001D','REJECT','2025-03-31 11:51:04','25030001E','REJECT','2025-03-31 11:52:51','25030001F','REJECT',NULL,'25030001G','REJECT',NULL,'25030001H','REJECT',NULL,'25030001I','REJECT',NULL,'25030001J','REJECT',NULL,'25030001K','REJECT',NULL,NULL,1,NULL,'2025-03-18 03:12:08','2025-03-31 11:52:51',NULL),
(2,'25030002','2025-03-21','2025-03-21','KPI/DO/24-25/0001',1,'A101',1,'49x0x510x595','(30°)',NULL,'1','SIGMA ECO 30',1,'25030002A',NULL,NULL,'25030002B',NULL,NULL,'25030002C',NULL,NULL,'25030002D',NULL,NULL,'25030002E',NULL,NULL,'25030002F',NULL,NULL,'25030002G',NULL,NULL,'25030002H',NULL,NULL,'25030002I',NULL,NULL,'25030002J',NULL,NULL,'25030002K',NULL,NULL,NULL,1,NULL,'2025-03-21 03:02:54','2025-03-21 03:02:54',NULL),
(3,'25030003','2025-03-21','2025-03-21','KPI/DO/24-25/0001',1,'A102',4,'45x0x510x576','(30°)',NULL,'3','SIGMA ECO 30',1,'25030003A',NULL,NULL,'25030003B',NULL,NULL,'25030003C',NULL,NULL,'25030003D',NULL,NULL,'25030003E',NULL,NULL,'25030003F',NULL,NULL,'25030003G',NULL,NULL,'25030003H',NULL,NULL,'25030003I',NULL,NULL,'25030003J',NULL,NULL,'25030003K',NULL,NULL,NULL,1,NULL,'2025-03-21 03:03:14','2025-03-21 03:03:14',NULL);

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

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext 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,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `machine_models`
--

CREATE TABLE `machine_models` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `manufacturer_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `machine_models_manufacturer_id_index` (`manufacturer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `machine_models`
--

INSERT INTO `machine_models` VALUES
(1,1,'520',1,1,'2024-04-22 10:35:36','2024-04-22 05:43:53',NULL),
(2,1,'580',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(3,1,'660',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(4,1,'680',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(5,1,'750W',1,1,'2024-04-22 10:35:36','2025-02-14 05:18:37',NULL),
(6,1,'920',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(7,1,'3304',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(8,3,'1F',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(9,3,'2F',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(10,3,'3F',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(11,1,'3200',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(12,3,'3DP',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(13,3,'4DP',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(14,2,'1050',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(15,2,'920ST',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(16,2,'940ST',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(17,2,'970ST',1,1,'2024-04-22 10:35:36','2024-04-22 05:42:49',NULL),
(18,3,'5G',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(19,3,'D1000',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(20,3,'D2000',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(21,3,'D3000',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(22,2,'690',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(23,2,'760',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(24,2,'780',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(25,3,'V3000',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(26,3,'L-750-S',1,NULL,'2024-04-22 10:35:36','2024-04-22 10:35:36',NULL),
(27,2,'670ST',1,NULL,'2024-04-24 05:01:04','2024-04-24 05:01:04',NULL),
(28,2,'790ST',1,NULL,'2024-04-24 05:01:33','2024-04-24 05:01:33',NULL),
(29,1,'750',1,1,'2024-04-24 05:10:17','2025-02-17 02:38:11',NULL),
(30,1,'680X',1,NULL,'2024-04-24 05:12:18','2024-04-24 05:12:18',NULL),
(31,8,'MLP 13',1,NULL,'2024-05-27 23:50:07','2024-05-27 23:50:07',NULL),
(32,2,'PEARL PRINTERS',1,NULL,'2024-08-06 05:00:38','2024-08-06 05:00:38',NULL),
(33,8,'VAR18B',20,NULL,'2025-01-23 01:32:09','2025-01-23 01:32:09',NULL),
(34,8,'MLP16C',20,NULL,'2025-01-23 01:32:27','2025-01-23 01:32:27',NULL),
(35,5,'LS-640',1,NULL,'2025-02-13 06:20:22','2025-02-13 06:20:22',NULL),
(36,1,'750-W',1,NULL,'2025-02-14 05:12:25','2025-02-14 05:12:25',NULL),
(37,4,'MO-V',1,NULL,'2025-02-17 23:16:20','2025-02-17 23:16:20',NULL);

--
-- Table structure for table `manufacturers`
--

CREATE TABLE `manufacturers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `manufacturers`
--

INSERT INTO `manufacturers` VALUES
(1,'RYOBI',1,1,'2024-04-22 09:47:07','2024-11-13 04:40:32',NULL),
(2,'RMGT',1,1,'2024-04-22 09:47:07','2024-04-22 04:38:56',NULL),
(3,'MITSUBISHI',1,NULL,'2024-04-22 09:47:07','2024-04-22 09:49:09',NULL),
(4,'HEIDELBERG',1,NULL,'2024-04-22 09:47:07','2024-04-22 09:49:09',NULL),
(5,'KOMORI',1,NULL,'2024-04-22 09:47:07','2024-04-22 09:49:09',NULL),
(6,'MAN ROLAND',1,NULL,'2024-04-22 09:47:07','2024-04-22 09:49:09',NULL),
(7,'KOENIG & BAUER',1,NULL,'2024-04-22 09:47:07','2024-04-22 09:49:09',NULL),
(8,'MIYAKOSHI',1,NULL,'2024-05-27 23:49:30','2024-05-27 23:49:30',NULL);

--
-- Table structure for table `materials`
--

CREATE TABLE `materials` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `roller_type` varchar(128) DEFAULT NULL,
  `variant` varchar(128) DEFAULT NULL,
  `compound` varchar(256) DEFAULT NULL,
  `bond_1` varchar(256) DEFAULT NULL,
  `bond_2` varchar(256) DEFAULT NULL,
  `curing_agent_1` varchar(128) DEFAULT NULL,
  `curing_agent_2` varchar(128) DEFAULT NULL,
  `curing_agent_3` varchar(128) DEFAULT NULL,
  `wrapping_film` varchar(128) DEFAULT NULL,
  `basic_cost` decimal(10,2) DEFAULT 0.00,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `materials`
--

INSERT INTO `materials` VALUES
(1,'Ink Form','Oil Base','SIGMA ECO 30','CHEMLOC 202 A/B',NULL,'S-80',NULL,NULL,'PET',20.00,1,NULL,'2024-12-26 01:51:42','2024-12-26 01:51:42',NULL),
(2,'Ductor Roller','Oil Base','SIGMA ECO 30','CHEMLOC 202 A/B',NULL,'S-80',NULL,NULL,'PET',20.00,1,NULL,'2024-12-26 02:00:17','2024-12-26 02:00:17',NULL),
(3,'Ink Transfer Roller','Oil Base','SIGMA ECO 30','CHEMLOC 202 A/B',NULL,'S-80',NULL,NULL,'PET',20.00,1,NULL,'2024-12-26 02:00:50','2024-12-26 02:00:50',NULL),
(4,'Damp Form Roller','Oil Base','HW-25','CHEMLOC 202 A/B',NULL,'S-80',NULL,NULL,'PET',22.00,1,NULL,'2024-12-26 02:07:16','2024-12-26 02:07:16',NULL),
(5,'Damp Metering / Pan Roller','Oil Base','HW-25','CHEMLOC 202 A/B',NULL,'S-80',NULL,NULL,'PET',22.00,1,1,'2024-12-27 05:24:54','2024-12-27 05:29:33',NULL),
(6,'Ink Form','UV','UVS-30 EPDM','CHEMLOC 202 A/B',NULL,'S-80','MS-R','TRA','No. 8',25.00,1,1,'2024-12-27 05:25:31','2024-12-27 05:26:03',NULL),
(7,'Ductor Roller','UV','UVS-30 EPDM','CHEMLOC 202 A/B',NULL,'S-80','MS-R','TRA','No. 8',25.00,1,NULL,'2024-12-27 05:27:11','2024-12-27 05:27:11',NULL),
(8,'Ink Transfer Roller','UV','UVS-30 EPDM','CHEMLOC 202 A/B',NULL,'S-80','MS-R','TRA','No. 8',25.00,1,NULL,'2024-12-27 05:27:28','2024-12-27 05:27:28',NULL),
(9,'Damp Form Roller','UV','UV HW-25','CHEMLOC 202 A/B',NULL,'S-80',NULL,NULL,'No. 8',27.00,1,NULL,'2024-12-27 05:29:01','2024-12-27 05:29:01',NULL),
(10,'Damp Metering / Pan Roller','UV','UV HW-25','CHEMLOC 202 A/B',NULL,'S-80',NULL,NULL,'No. 8',27.00,1,NULL,'2024-12-27 05:30:42','2024-12-27 05:30:42',NULL),
(11,'Ink Form','Combi','HS-UV 30','CHEMLOC 202 A/B',NULL,'S-80','MS-R','TRA','No. 8',25.00,1,NULL,'2024-12-27 05:31:29','2024-12-27 05:31:29',NULL),
(12,'Ductor Roller','Combi','HS-UV 30','CHEMLOC 202 A/B',NULL,'S-80','MS-R','TRA','No. 8',25.00,1,NULL,'2024-12-27 05:31:43','2024-12-27 05:31:43',NULL),
(13,'Ink Transfer Roller','Combi','HS-UV 30','CHEMLOC 202 A/B',NULL,'S-80','MS-R','TRA','No. 8',25.00,1,NULL,'2024-12-27 05:32:01','2024-12-27 05:32:01',NULL),
(14,'Damp Form Roller','Combi','UV HW-25','CHEMLOC 202 A/B',NULL,'S-80',NULL,NULL,'No. 8',27.00,1,NULL,'2024-12-27 05:32:58','2024-12-27 05:32:58',NULL),
(15,'Damp Metering / Pan Roller','Combi','UV HW-25','CHEMLOC 202 A/B',NULL,'S-80',NULL,NULL,'No. 8',27.00,1,NULL,'2024-12-27 05:33:11','2024-12-27 05:33:11',NULL);

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

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

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

INSERT INTO `migrations` VALUES
(505,'0001_01_01_000000_create_users_table',1),
(506,'0001_01_01_000001_create_cache_table',1),
(507,'0001_01_01_000002_create_jobs_table',1),
(508,'2024_04_09_102445_create_personal_access_tokens_table',1),
(509,'2024_04_09_115650_create_contacts_table',1),
(510,'2024_04_09_122234_create_manufacturers_table',1),
(511,'2024_04_09_124719_create_rollers_table',1),
(512,'2024_04_10_142818_create_machine_models_table',1),
(513,'2024_04_13_072047_create_parties_table',1),
(514,'2024_05_03_063530_create_quotations_table',1),
(515,'2024_05_03_070139_create_quotations_items_table',1),
(516,'2024_05_06_095929_create_materials_table',1),
(517,'2024_05_20_105639_create_job_cards_table',1),
(518,'2024_06_06_062538_create_roller_numbers_table',1),
(519,'2024_06_10_080949_create_derubbers_table',1),
(520,'2024_06_10_081005_create_sand_blasts_table',1),
(521,'2024_06_10_081020_create_bond_applies_table',1),
(522,'2024_06_10_081039_create_sheet_plyings_table',1),
(523,'2024_06_10_081150_create_vulcanizes_table',1),
(524,'2024_06_10_081227_create_rough_grinds_table',1),
(525,'2024_06_10_081248_create_side_cuts_table',1),
(526,'2024_06_10_081355_create_final_grinds_table',1),
(527,'2024_06_10_090724_create_auto_polish_table',1),
(528,'2024_06_10_090757_create_inspections_table',1),
(529,'2024_06_11_061124_create_invoices_table',1),
(530,'2024_06_11_063308_create_invoices_items_table',1),
(531,'2024_08_09_160519_vulcanizations_jobcards',1),
(532,'2024_10_03_085925_create_permission_tables',1);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES
(1,'App\\Models\\User',1),
(1,'App\\Models\\User',17),
(1,'App\\Models\\User',19),
(1,'App\\Models\\User',20),
(2,'App\\Models\\User',2),
(3,'App\\Models\\User',3),
(4,'App\\Models\\User',4),
(5,'App\\Models\\User',5),
(6,'App\\Models\\User',6),
(7,'App\\Models\\User',7),
(8,'App\\Models\\User',8),
(9,'App\\Models\\User',9),
(10,'App\\Models\\User',10),
(11,'App\\Models\\User',11),
(14,'App\\Models\\User',21);

--
-- Table structure for table `parties`
--

CREATE TABLE `parties` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('C','D') NOT NULL DEFAULT 'C',
  `dealer_code` varchar(2) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `address1` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `address3` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `pincode` varchar(6) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `region` varchar(255) DEFAULT NULL,
  `gstin` varchar(16) DEFAULT NULL,
  `pancard` varchar(56) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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=137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `parties`
--

INSERT INTO `parties` VALUES
(1,'D','IT','I THINK INK','7/3, SADANWADI, OPP BHANDUP POLICE STATION,','OFF LBS MARG, LAKE ROAD,','BHANDUP (W)','MUMBAI','MAHARASHTRA','400078','INDIA','WEST','27AHSPD9460C1Z6',NULL,1,1,'2024-04-22 09:48:15','2024-12-12 00:37:30',NULL),
(2,'C',NULL,'RAHUL PRINTER (CREATIVE DIGITAL & OFFSET PRESS)','MRM SCHOOL ROAD,','RAJKUMAR GANJ,','LALBAGH','DHARBHANGA','BIHAR','846004','INDIA','NORTH','10APUPC0001J2ZK',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(3,'C',NULL,'KALAIMAGAL LABELS','#17, VIVEKANANDAR STREET,','SENGUNTHAPURAM 9TH CROSS','','KARUR','TAMIL NADU','639002','INDIA','SOUTH','33DFEPS2444G1ZJ',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(4,'C',NULL,'KRUPA GRAPHICS','# 8 & 8/1,','Obaiahlane 2nd Cross,','Cottonpet','BENGALURU','KARNATAKA','560053','INDIA','SOUTH','29BWEPS3834D1ZD',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(5,'C',NULL,'THE MANGALORE TRADING ASSOCIATION (PVT) LTD (PROP.OF SHARADA PRESS)','CAR STREET','','','MANGALURU','KARNATAKA','575001','INDIA','SOUTH','29AABCT1215G1ZN',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(6,'C',NULL,'BALAJI BOOKS','60-61A, PIPDIC Electronic park','Thirubuvanai','PONDICHERRY','PONDICHERRY','TAMIL NADU','605107','INDIA','SOUTH','34AAFPN3941E1ZY',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(7,'C',NULL,'PROVIN TECHNOS PRIVATE LIMITED','B-206, OKHLA INDUSTRIAL AREA','PHASE 1','','NEW DELHI','DELHI','110020','INDIA','NORTH','07AAGCP6651F1ZC',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(8,'C',NULL,'GRAHAM OFFSET PRINTERS','3/1440B,','SATTUR ROAD, VADAPATTI,','NEAR SIVAKASI BUS STAND,','SIVAKASI','TAMIL NADU','626189','INDIA','SOUTH','',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(9,'C',NULL,'PROCESS COLOR HOLOGRAM PRIVATE LIMITED','34/659 B, JAAN OFFSET PRINTING PVT LTD,','CIVIL LANE ROAD,','PADIVATTOM,','COCHIN','KERALA','682024','INDIA','SOUTH','32AABCJ2819E1Z2',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(10,'C',NULL,'ELIJAH PRINTING SOLUTIONS','NO. 42A, MURTHY NAGAR MAIN ROAD,','1ST CROSS STREET, PADI,','NEAR SIVASAKTHI CINEMAS & BSNL TELEPHONE EXCHANGE','CHENNAI','TAMIL NADU','600050','INDIA','SOUTH','33EACPS0679M1Z8',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(11,'C',NULL,'PRAGATI TECHNOLOGIES','NO. 57, RUDRAPPA GARDEN,','KASTURBA NAGAR,','CHAMARAJAPET,','BENGALURU','KARNATAKA','560026','INDIA','SOUTH','29AXKPA2639N1Z2',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(12,'C',NULL,'KANDALAA PRINTS','PLOT NO. 332-P2 (CORNER),','2ND PHASE, HAROHALLI INDUSTRIAL AREA,','HAROHALLI,','RAMNAGARA','KARNATAKA','562112','INDIA','SOUTH','29AAVFK2432R1ZE',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(13,'C',NULL,'SRI RAMAKRISHNA PRINTERS','3/1464-1, OLD RTO OFFICE NEAR,','SATTUR ROAD,','VIRUDHUNAGAR,','SIVAKASI','TAMIL NADU','626123','INDIA','SOUTH','33AWMPM9088J1ZS',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(14,'C',NULL,'TEE TEE KAY OFFSET PRINTERS','4/1723A, 56,','VETTU COLONY','','SIVAKASI','TAMIL NADU','626189','INDIA','SOUTH','33AAJFT8263D1Z4',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(15,'C',NULL,'KRISHNARAJ PRINTERS','36, J J KHAN ROAD,','DEVARAJAN STREET,','ROYAPETTAH,','CHENNAI','TAMIL NADU','600014','INDIA','SOUTH','33AAAFK5326P1Z7',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(16,'C',NULL,'THE ORIENT INDUSTRIES','52, MUNDAGA NADAR STREET,','VIRUDUNAGAR,','','SIVAKASI','TAMIL NADU','626123','INDIA','SOUTH','33AABFT3157G1ZF',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(17,'C',NULL,'ANGELS PUBLISHING CORPORATION','TANGRA INDUSTRIAL ESTATE-II, BL-29,','PREMISES NO. 21, 45, RADHANATH CHOWDHURY ROAD','EARLIER POTTERY ROAD,','KOLKATA','WEST BENGAL','700015','INDIA','EAST','19ABOFA5703B1ZN',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(18,'C',NULL,'KRUPA PRINTERS','NO.11/1, GROUND FLOOR, 14TH CROSS,','MAGADI MAIN ROAD, POLICE QUARTERS LAYOUT,','6TH BLOCK, RAJAJINAGAR,','BENGALURU','KARNATAKA','560010','INDIA','SOUTH','29AUXPM2297A1Z4',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(19,'C',NULL,'ACCELTECH PRINTING PRIVATE LIMITED','39/2-H','BSK 1ST STAGE, KALYANI GARDEN','N. R. COLONY','BENGALURU','KARNATAKA','560050','INDIA','SOUTH','29AARCA6063D1ZG',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(20,'C',NULL,'SIMLA MULTI PRINT LLP','172, MAHESHWARI INDUSTRIAL ESTATE, NR. HANUMANPURA BRTS BUS STOP','DUDHESHWAR ROAD, TADVIPURA','SHAHIBAUG,','AHMEDABAD','GUJARAT','380004','INDIA','WEST','24AEKFS7523J1ZP',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(21,'C',NULL,'UNIQUE PACKAGING SOLUTIONS','BLOCK NO. 781, ROOM NO. 5578','BAPUNAGAR CHAR RASTA,','BAPU NAGAR,','AHMEDABAD','GUJARAT','380021','INDIA','WEST','24AAGFU5705J1Z3',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(22,'C',NULL,'DP PRINTING AND BINDING','B-149, OKHLA INDUSTRIAL AREA, PHASE-1,','SOUTH DELHI, NEW DELHI, 110020','OKHLA','NEW DELHI','DELHI','110020','INDIA','NORTH','07BERPA9009K1Z7',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(23,'C',NULL,'DP PRINTING AND BINDING (754)','B-149, OKHLA INDUSTRIAL AREA, PHASE-1,','SOUTH DELHI, NEW DELHI, 110020','OKHLA','NEW DELHI','DELHI','110020','INDIA','NORTH','07BERPA9009K1Z7',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(24,'C',NULL,'FORESEE INDIA','PLOT NO 100 – 101, CHERMAS BUILDING,','A.P. APPAREL PARK, ST. PETER’S COLLEGE RD,','GUNDLAPOCHAMPALLY,','MEDCHAL MALKAJGIRI','TELANGANA','500055','INDIA','SOUTH','36AQBPT2027R1ZD',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(25,'C',NULL,'DPB PRINT INDIA PRIVATE LIMITED','G-79, SITE-V, UPSIDC, KASNA','SURAJPUR INDUSTRIAL AREA,',NULL,'GREATER NOIDA','UTTAR PRADESH','201310','INDIA','NORTH','09AAHCD0573B1ZY',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(26,'C',NULL,'SNEKA INDUSTRIES','281 B,','KAMARAJAR ROAD,','','SIVAKASI','TAMIL NADU','626124','INDIA','SOUTH','33BQWPS9319H1Z2',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(27,'C',NULL,'MITTAL ENTERPRISES','3/1/23,','SITE 4,','SAHIBABAD INDUSTRIAL AREA,','GHAZIABAD','UTTAR PRADESH','201010','INDIA','NORTH','09AAQPM5742F1ZC',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(28,'C',NULL,'PRIYA OFFSET PRINTERS','4/1665A,','HUSSAIN COLONY,','','SIVAKASI','TAMIL NADU','626189','INDIA','SOUTH','33ABDPP2569D1ZU',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(29,'C',NULL,'ERRORLESS BOOKS PRIVATE LIMITED','D-167, EPIP, GALI NO. 25,','NEAR LG GODOWN, KASNA,','GAUTAM BUDDHA NAGAR','GREATER NOIDA','UTTAR PRADESH','201310','INDIA','NORTH','09AAFCE1207R1ZD',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(30,'C',NULL,'A P INDIA','D-3/4,','OKHLA INDUSTRIAL AREA,','PHASE - 2,','NEW DELHI','DELHI','110020','INDIA','NORTH','07ACJPC0180C1Z9',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(31,'C',NULL,'EMERALD TRADERS','114A, SOUTH RAJAVEETHI,','TOWN PANCHAYAT,','PAPANASAM,','TANJORE','TAMIL NADU','614205','INDIA','SOUTH','33AZAPM9074F1ZD',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(32,'C',NULL,'TINGO PRINTS','NO. 9, 1ST FLOOR,','RAMASAMY STREET,','TAMBARAM,','CHENNAI','TAMIL NADU','600045','INDIA','SOUTH','33AAOFT5213E1ZD',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(33,'C',NULL,'SALASAR IMAGING SYSTEMS (II)','A-97,','SECTOR - 58,','','NOIDA','UTTAR PRADESH','203207','INDIA','NORTH','09AATFS3893C1ZM',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(34,'C',NULL,'EBENEZER PRINTPACK PRIVATE LIMITED','TMC 49/1221,','KANJANI ROAD,','OLARIKKARA,','THRISSUR','KERALA','680012','INDIA','SOUTH','32AACCE1999F1ZP',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(35,'C',NULL,'NIKHIL OFFSET','SHED NO. 223,','DSIDC COMPLEX,','OKHLA INDUSTRIAL AREA, PHASE - 1,','NEW DELHI','DELHI','110020','INDIA','NORTH','07AATPS1208F1ZM',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(36,'C',NULL,'CHIRAG OFFSET PRIVATE LIMITED','55/13/3-4-5, O/S-RAIPUR GATE,','CITY MILL COMPOUND,','KANKARIA ROAD, KANKARIA,','AHMEDABAD','GUJARAT','380022','INDIA','WEST','24AABCC3017H1Z8',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(37,'C',NULL,'CITRUS PACKAGING SOLUTIONS PRIVATE LIMITED','PLOT NO A-20, ROAD NO 7,','GANDHI NAGAR,','IDA KUKATPALLY,','HYDERABAD','TELANGANA','500037','INDIA','SOUTH','36AAHCC1842Q1Z9',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(38,'C',NULL,'QONTRAC PRINTS PRIVATE LIMITED','268, 269, 270, 271,','SURAT SPECIAL ECONOMIC ZONE,','SACHIN,','SURAT','GUJARAT','394230','INDIA','WEST','24AAACQ6366L2Z3',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(39,'C',NULL,'AL HADARA PRINTING PRESS','8442,','INDUSTRIAL AREA,','JEDDAH 22428','SAUDI ARABIA','OVERSEAS','0','SAUDI ARABIA','NORTH','0',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(40,'C',NULL,'YAMIR PACKAGING PVT LTD','PLOT NO. D-8A & D-8,','MASCOT INDUSTRIAL PARK,','VILLAGE JADAVPURA, TALUKA KADI,','MEHSANA','GUJARAT','382120','INDIA','WEST','24AAACY0728N2Z5',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(41,'C',NULL,'ORANGE PLANET LLP','A-60,','SECTOR - 64,','GAUTAM BUDH NAGAR','NOIDA','UTTAR PRADESH','201301','INDIA','NORTH','09AAEFO2778D1Z5',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(42,'C',NULL,'CLASSY PRINTING PRESS PVT LTD','KAMEROTAR','RADHE RADHE','THIMI','BHAKTAPUR','OVERSEAS','977','NEPAL','NORTH','0',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(43,'C',NULL,'HOPUZ PRINTERS','237/18, CHEVAYUR ROAD,','ANTHIYOORKUNNU P.O,','KODIKUTHIPARAMBU,','MALAPPURAM','KERALA','673637','INDIA','SOUTH','32AAIFH7008P1Z5',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(44,'C',NULL,'ESS CEE PRINT PACK PRIVATE LIMITED','#256, 4TH PHASE, 8TH CROSS','PEENYA INDUSTRIAL AREA','','BENGALURU','KARNATAKA','560058','INDIA','SOUTH','29AAHCE0382R1ZZ',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(45,'C',NULL,'LABH OFFSET','SHED NO. B 6, J K ESTATE,','RUSTOM MILL, DUDHESHWAR,','','AHMEDABAD','GUJARAT','380001','INDIA','WEST','24AAGFL1836R1ZW',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(46,'C',NULL,'A ONE PRINTING COMPANY','153, FIRST FLOOR, KRISHNA PALACE,','BARA BAZAR, BASAI ROAD,','','GURUGRAM','HARYANA','122001','INDIA','NORTH','06AQAPP3289Q1Z5',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(47,'C',NULL,'MALANKARA ORTHODOX SYRIAN CHURCH','CATHOLICATE ARAMANA,','MUTTAMBALAM P.O,','DEVALOKAM,','KOTTAYAM','KERALA','686004','INDIA','SOUTH','32AAATM7039F1ZT',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(48,'C',NULL,'CHANDU PRESS','D-97, GROUND FLOOR, NEAR LAXMI NAGAR,','SHAKARPUR,','EAST DELHI','DELHI','DELHI','110092','INDIA','NORTH','07AAGFC6699D1Z7',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(49,'C',NULL,'STERLING PRINTS AND CONVERSIONS','450, MULTI INDUSTRIAL ESTATE,','GERUGAMBAKKAM, NEAR PSSBB MILLENNIUM SCHOOL,','PORUR','CHENNAI','TAMIL NADU','600122','INDIA','SOUTH','33AALFS7733F1Z2',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(50,'C',NULL,'PANKAJ PRINTING PRESS','D 28,','SITE A,','INDUSTRIAL AREA,','MATHURA','UTTAR PRADESH','281004','INDIA','NORTH','09AAWPA0861H1ZK',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(51,'C',NULL,'THULIKA OFFSET PRINTING','41/2771, ROOM NO-3,','PEDIKKAT CHAMBERS,','PARAMARAROAD,','COCHIN','KERALA','682018','INDIA','SOUTH','32AVAPM7543D1ZX',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(52,'C',NULL,'THE SAFIRE INDUSTRIES','3/28, VEMBAKOTTAI ROAD,','AYYANAR COLONY,','SITHURAJAPURAM,','SIVAKASI','TAMIL NADU','626189','INDIA','SOUTH','33AABFT3312M1ZD',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(53,'C',NULL,'ONLINE GRAPHICS','T-155J,','FIRST FLOOR,','KESHAB CHANDRA SEN STREET,','KOLKATA','WEST BENGAL','700009','INDIA','EAST','19ALXPK0176D2ZS',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(54,'C',NULL,'FALCON PRINTOGRAPHICS PRIVATE LIMITED','PLOT NO. 03,','UDYOG KENDRA-II, ECOTECH-III,','GAUTAM BUDDHA NAGAR,','GREATER NOIDA','UTTAR PRADESH','201306','INDIA','NORTH','09AABCF0817E1Z1',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(55,'C',NULL,'STAR COLOURPARK INDIA PRIVATE LIMITED','483, 110 ASOKA PLAZA,','DR NANJAPPA ROAD,','GANDHIPURAM','COIMBATORE','TAMIL NADU','641018','INDIA','SOUTH','33AABCN5735F1ZP',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(56,'C',NULL,'SUBRAMANIAM COLOUR PRINTS','62 & 63, VAISHNAVDEVI INDUSTRIAL ESTATE PHASE 2,','KUMBALGUDU INDUSTRIAL AREA PHASE 2,','RAMOHALLI ROAD, OFF MYSORE ROAD,','BENGALURU','KARNATAKA','560074','INDIA','SOUTH','29ADAPP7355G1ZA',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(57,'C',NULL,'SNJ DISTILLERS PRIVATE LIMITED','56/1, KALLAPIRANPURAM VILLAGE & POST,','MADURANTAKAM TALUK','','CHENGALPATTU','TAMIL NADU','603308','INDIA','SOUTH','33AALCS9312F1ZD',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(58,'C',NULL,'PRINT PARK','GUPTA TOWERS, 1464D,','ST. BENEDICT 3RD CROSS ROAD','43, ERNAKULAM NORTH,','ERNAKULAM','KERALA','682018','INDIA','SOUTH','32AOWPG3666E1ZT',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(59,'C',NULL,'RAMESH PRINTERS','213','DSIDC SHED','OKHLA INDUSTRIAL AREA','PHASE 1','DELHI','110020','INDIA','NORTH','07AINPK8765B1ZZ',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(60,'C',NULL,'VINAYA PRINTERS','30/526,','CHAMPAKKARA MARKET,','POONITHURA,','ERNAKULAM','KERALA','682038','INDIA','SOUTH','32AZLPS4733N1ZT',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(61,'C',NULL,'QONTRAC PRINTS PRIVATE LIMITED - II','268, 269, 270, 271,','SURAT SPECIAL ECONOMIC ZONE,','SACHIN,','SURAT','GUJARAT','394230','INDIA','WEST','24AAACQ6366L2Z3',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(62,'C',NULL,'SRI VENKATESHWARA PRINTERS','NO. 50,','KEMPAMBHUDHI LAKE MAIN ROAD,','KEMPEGOWDA NAGAR,','BENGALURU','KARNATAKA','560019','INDIA','SOUTH','29AGFPB0270J1ZM',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(63,'C',NULL,'D B CORP LIMITED','NO. 10,','JAWAHARLAL NEHRU MARG,','MALVIYA NAGAR,','JAIPUR','RAJASTHAN','302015','INDIA','NORTH','08AACCM5772G1ZB',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(64,'C',NULL,'NAITIK ENTERPRISE','2, F-35/36/37,','RAVI ESTATE, SHANIDEV MANDIR ROAD,','TAVDIPURA,','AHMEDABAD','GUJARAT','380004','INDIA','WEST','24AFNPS9406E1Z8',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(65,'C',NULL,'GANESHA PRINTS AND TRADES','NO.10, VISALAKSHI 2ND CROSS STREET,','LAKSHMI AMMAN NAGAR,','ERUKKANCHERY,','CHENNAI','TAMIL NADU','600118','INDIA','SOUTH','33ADFPV7147K1Z3',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(66,'C',NULL,'YASH PRINTOGRAPHICS','GROUND FLOOR, A-12, A-12,','SECTOR-8, SWANI FURNITURE,','GAUTAMBUDDHA NAGAR,','NOIDA','UTTAR PRADESH','201301','INDIA','NORTH','09ADJPT8102G1ZC',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(67,'C',NULL,'MODERN MACHINERY','GROUND FLOOR, PLOT NO 4,','SONARDA TIMBER ZONE, OPP AAROHI FARM, SONARADA,','NARODA DEHGAM ROAD, NR NARMADA CANAL, DEHGAM,','GANDHINAGAR','GUJARAT','382305','INDIA','WEST','24AZKPP6946M1ZL',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(68,'C',NULL,'NIRMAN IMPRESSE PRIVATE LIMITED','2ND FLOOR, A/2- 239,','SHAH AND NAHAR INDUSTRIAL ESTATE, SITA RAM JADHAV MARG,','DHANRAJ MILL COMPOUND, LOWER PAREL,','MUMBAI','MAHARASHTRA','400013','INDIA','WEST','27AABCN3326Q1Z4',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(69,'C',NULL,'ARKA PRESS','584/1,','POOMPUGAR NAGAR,','GOLDWINS,','COIMBATORE','TAMIL NADU','641014','INDIA','SOUTH','33AHSPJ7832J2ZV',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(70,'C',NULL,'MICRO PRINTS (INDIA)','192-193,','DSIDC SHEDS, PHASE-I,','OKHLA INDUSTRIAL AREA,','NEW DELHI','DELHI','110020','INDIA','NORTH','07AEHPJ1922P1Z9',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(71,'C',NULL,'MADURAI PRINT & PACK PRIVATE LIMITED','NO 16/22,','THIRUVAPPUDAIYAR KOVIL SANNATHI STREET,','SELLUR,','MADURAI','TAMIL NADU','625002','INDIA','SOUTH','33AAPCM8912K1Z0',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(72,'C',NULL,'S G PRINT PACKS PRIVATE LIMITED','F 478,','SECTOR 63,','GAUTAMBUDDHA NAGAR,','NOIDA','UTTAR PRADESH','201301','INDIA','NORTH','09AAJCS5390P1ZF',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(73,'C',NULL,'RADHE OFFSET','411/5B/2,','KAPASI ESTATE, OPP ADITYA SYNTHETIC','B/H MANGAL EATATE GIDC, NARODA,','AHMEDABAD','GUJARAT','382330','INDIA','WEST','24AAIFR3520Q1ZX',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(74,'C',NULL,'KUMARAGURU PRINTS','NO. 22','SADASIVAM STREET,','GOPALAPURAM,','CHENNAI','TAMIL NADU','600086','INDIA','SOUTH','33CHLPK5733Q1ZQ',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(75,'C',NULL,'SIXMAX PRINT AND PACKAGING PRIVATE LIMITED','SHED NO. 49, 2ND MAIN ROAD,','SIDCO INDUSTRIAL ESTATE,','THIRUMAZHISAI,','CHENNAI','TAMIL NADU','600124','INDIA','SOUTH','33ABFCS8591K1ZR',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(76,'C',NULL,'BBM PACKAGING PRIVATE LIMITED','NO. 3, OLD NO. 18 AND 23,','SY NOS 24, 35, 36 AND 37, 3RD MAIN ROAD,','PHASE 1, PEENYA INDUSTRIAL AREA, PEENYA,','BENGALURU','KARNATAKA','560058','INDIA','SOUTH','29AABCM5048A1ZR',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(77,'C',NULL,'CAPITAL OFFSET','POCKET G, PLOT NO - 252,','SECTOR 3, BAWANA,','BAWANA INDUSTRIAL AREA,','NEW DELHI','DELHI','110039','INDIA','NORTH','07AAUPS4065R1ZJ',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(78,'C',NULL,'PIONEER OVERSEAS PRIVATE LIMITED','158,','THIURTHANGAL ROAD','','SIVAKASI','TAMIL NADU','626123','INDIA','SOUTH','33AABCP6169K1Z6',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(79,'C',NULL,'MICRO PRINT & PACK PRIVATE LIMITED','NO. 22/2, 274C, BOMMASANDRA-JIGANI UNIK ROAD','BOMMASANDRA INDUSTRIAL AREA','YARANDAHALLI','BENGALURU','KARNATAKA','560099','INDIA','NORTH','29AAOCM0329H1ZA',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(80,'C',NULL,'RAKSHIT LAMINATION','A-60,','BEHIND AMAR UJALA,','DELHI ROAD','MEERUT','UTTAR PRADESH','250002','INDIA','NORTH','09AICPC9048C1ZI',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(81,'C',NULL,'SAI PRINTO PACK PVT LTD (NOIDA)','PLOT NO - 23,','SECTOR - 140, PHASE - II,','GAUTAM BUDH NAGAR,','NOIDA','UTTAR PRADESH','201305','INDIA','NORTH','09AAECS9835J1ZQ',NULL,1,1,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(82,'C',NULL,'GREEN CHILLI ADVERTISING PRIVATE LIMITED - II','3001-3003, NEW SARDAR TRADERS MARKET,','PUNA KUMBHARIYA ROAD,','','SURAT','GUJARAT','395010','INDIA','WEST','24AAHCG6708P1Z5',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(83,'C',NULL,'SHIVAM SHRI PRINTERS','NO. 3,','POLOGROUND,','INDUSTRIAL ESTATE,','INDORE','MADHYA PRADESH','452015','INDIA','WEST','23BQOPS1453E1ZU',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(84,'C',NULL,'IDEAL DUPLICATING BUREAU','NO.69,','SARVODAY CENTRE,','NEAR SALAPOSE ROAD,','AHMEDABAD','GUJARAT','380001','INDIA','WEST','24AACFI0396R1ZY',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(85,'C',NULL,'ECOPACK SOLUTIONS','J-7, POCKET J','SECTOR - 5, DSIIDC,','BAWANA','DELHI','DELHI','110039','INDIA','NORTH','07AAHFE8182E1ZC',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(86,'C',NULL,'QUALITY OFFSET PRINTERS','B-97, GROUND FLOOR,','BACK SIDE LANE, PHASE - 1,','NARAINA INDUSTRIAL AREA, NARAINA','DELHI','DELHI','110028','INDIA','NORTH','07GRMPS5037J1Z4',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(87,'C',NULL,'J K PRINTERS','37, SHAYONA ESTATE','NR VADILAL ICE CREAM','DUDHESHWAR ROAD','AHMEDABAD','GUJARAT','380004','INDIA','WEST','24BOXPM3140M1ZG',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(88,'C',NULL,'FOUR ELEMENTS PRINTECH LLP','GA2, SUMEET LOGISTICS PARK,','VILLAGE KUKSE BORIVALI,','MUMBAI - NASHIK HIGHWAY, BHIWANDI,','THANE','MAHARASHTRA','421302','INDIA','WEST','27AAIFF2356E1ZK',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(89,'C',NULL,'YAAZHINI PRESS','7/83, SRIVILLIPUTHUR MAIN ROAD,','NEAR SENTHIL TYRE WORKS,','SIMCO COLONY, ANAIYUR,','VIRUDHUNAGAR','TAMIL NADU','626123','INDIA','SOUTH','33AACFY9657P1Z9',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(90,'C',NULL,'PRINTOLOGY XPERTS LLP','51, DSIDC SHEDS,','OKHLA INDUSTRIAL AREA','PHASE 1','NEW DELHI','DELHI','110020','INDIA','NORTH','07AAUFP5816B1Z3',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(91,'C',NULL,'M P PRINTERS (A UNIT OF D B CORP LTD)','B-220,','PHASE-2','NOIDA','GAUTAMBUDDHA NAGAR','UTTAR PRADESH','201305','INDIA','NORTH','09AACCM5772G2Z8',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(92,'C',NULL,'MITTAL PRINT N PACK','BASEMENT, 348,','FUNCTIONAL INDUSTRIAL ESTATE AT PATPARGANJ,','SHAHDARA','NEW DELHI','DELHI','110092','INDIA','NORTH','07ACEPM8941Q1ZU',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(93,'C',NULL,'AAKRUTI PRINTERS','A/8, ALOK SHOPPING CENTER, NR RAMKRISHNA NAGAR,','OPP. HARBHOLANATH SOCIETY, NATIONAL HIGHWAY, RAKHIAL,','RAMRAJYA NAGAR CHAR RASTA AMRAIWADI,','AHMEDABAD','GUJARAT','380023','INDIA','WEST','24AGDPP2499M1ZV',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(94,'C',NULL,'ORRVEE INDUSTRIES','118/26,','VELAYUTHAM ROAD,','VIRUDHUNAGAR','SIVAKASI','TAMIL NADU','626123','INDIA','SOUTH','33AAAFO1653P1Z5',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(95,'C',NULL,'SESHAASAI E-FORMS PRIVATE LIMITED','GF-1, INDUSTRIAL ESTATE,','5TH CROSS RD,','PEENYA 1ST STAGE,','BENGALURU','KARNATAKA','560058','INDIA','SOUTH','29AAGCS2240B1ZQ',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(96,'C',NULL,'RAKMO PRESS PRIVATE LIMITED','I-57, SURAJPUR ROAD,','SURAJPUR INDUSTRIAL AREA,','KASNA GREATER NOIDA,','GAUTAMBUDDHA NAGAR','UTTAR PRADESH','201306','INDIA','NORTH','09AAACR1429H1ZI',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(97,'C',NULL,'FRIENDS COLOR IMAGES PRIVATE LIMITED','PLOT NO 148,','IMT MANESAR','SECTOR 4,','GURUGRAM','HARYANA','122050','INDIA','NORTH','06AAACF3495R1Z1',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(98,'C',NULL,'TIGI PRINT ROOF PRIVATE LIMITED','PLOT NO 38,','SIDCO','PATTANAM VILLAGE','TINDIVANAM','TAMIL NADU','604001','INDIA','SOUTH','33AAJCT0517F1ZP',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(99,'C',NULL,'FIRST IMPRESSION CORPORATE SERVICES PRIVATE LIMITED','E-114,','SECTOR -63,','NOIDA,','GAUTAMBUDDHA NAGAR','UTTAR PRADESH','201301','INDIA','NORTH','09AAACF1547N1ZE',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(100,'C',NULL,'OPTION PRINTOFAST','A 33 / 24 A,','SITE IV INDUSTRIAL AREA,','SAHIBABAD,','GHAZIABAD','UTTAR PRADESH','201001','INDIA','NORTH','09AAAFO4064C1ZK',NULL,1,NULL,'2024-04-22 09:48:15','2024-04-22 09:49:09',NULL),
(101,'D','AB','Rajesh',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'2024-05-06 04:05:15','2024-12-11 23:53:39','2024-12-11 23:53:39'),
(102,'C',NULL,'PROVIN PRINTECH PVT LTD','C-119','2nd FLOOR, OKHLA INDUSTRIAL AREA,','PHASE -1','NEW DELHI','DELHI','110020','india','NORTH',NULL,NULL,1,NULL,'2024-05-27 05:04:48','2024-05-27 05:04:48',NULL),
(103,'C',NULL,'Provin Technos Pvt Ltd.,','C-119, 2nd Floor, Okhla Industrial Area,','Phase I',NULL,'Delhi','Delhi','110020','India',NULL,'07AAGCP6651F1ZC',NULL,1,NULL,'2024-06-18 03:16:54','2024-06-18 03:16:54',NULL),
(104,'C',NULL,'PEARL PRINTERS','C-105','OKHLA INDUSTRIAL AREA','PAHSE - 1','NEW DELHI','DELHI','110020','india','NORTH','07AAGCP6651F1ZC',NULL,1,NULL,'2024-08-06 04:44:05','2024-08-06 04:44:22','2024-08-06 04:44:22'),
(105,'C','A1','PEARL PRINTERS','C-105','OKHLA INDUSTRIAL AREA','PAHSE - 1','NEW DELHI','DELHI','110020','INDIA',NULL,'07AAGCP6651F1ZC',NULL,1,1,'2024-08-06 04:50:57','2024-08-06 04:51:45',NULL),
(106,'C',NULL,'THOMSON PRESS (INDIA) LTD','18/35, DELHI-MATHURA ROAD',NULL,NULL,'Faridabad','Haryana','121007','India','North','06AAACT4827F1ZI',NULL,2,NULL,'2024-11-13 03:45:35','2024-11-13 03:45:35',NULL),
(107,'C',NULL,'KRITI','B-279, OKHLA INDUSTRIAL AREA','PHASE-1','.','NEW DELHI','DELHI','110020','INDIA','NORTH','07ABZPV7074P1Z6',NULL,2,1,'2024-11-13 03:47:36','2025-02-18 05:57:25',NULL),
(108,'C',NULL,'NUTECH PRINT SERVICES - INDIA','PLOT NO 3 & 4','SECTOR 59, PHASE-II','BALLABGARH','FARIDABAD','HARYANA','121004','INDIA','NORTH','06AAGFN7723H1Z7',NULL,2,NULL,'2024-11-13 04:05:19','2024-11-13 04:05:19',NULL),
(109,'D','KR','Shah Exports Pvt. Ltd.','B 112, Sec 35,','Faridabad','Haryana','Faridabad','Haryana','120023','India','north','27AALFS8301D1Z9',NULL,1,NULL,'2024-11-14 03:25:23','2024-12-11 23:53:26','2024-12-11 23:53:26'),
(110,'C',NULL,'MANIPAL TECHNOLOGIES LIMITED','COMMERCIAL PRINTING DIVISION','UNIT-5, PLOT NO.3 A1 & A2,','SHIVALLI INDUSTRIAL AREA, MANIPAL,','UDUPI','KARNATAKA','576104','INDIA','SOUTH','29AABCM9516H1Z8','AABCM9516H',1,1,'2024-12-09 23:41:51','2025-02-13 04:15:29',NULL),
(111,'C',NULL,'THE OFFSETTER INDIA PVT LTD','MUKERJI HOUSE 69/4','DR T.N. BANERJEE ROAD','CHHAJJUBAGH','PATNA','BIHAR','800001','INDIA','EAST','10AAACT8595Q1ZP','AAACT8595Q',20,NULL,'2025-01-21 04:07:04','2025-01-21 04:07:04',NULL),
(112,'C',NULL,'H B D PACKAGING PRIVATE LIMITED','19, UDYOG KENDRA 2, INDUSTRIAL AREA,','ECOTECH 3','GREATER NOIDA','GREATER NOIDA','UTTAR PRADESH','201306','INDIA','NORTH','09AAACH0512K1ZV','AAACH0512K',20,NULL,'2025-01-23 00:41:28','2025-01-23 00:41:28',NULL),
(113,'C',NULL,'Testing','Testing','Testing','Testing','Delhi','Delhi','110020','India','NORTH','07AAGCP6651F1ZC','AAGCP6651F',20,NULL,'2025-01-27 04:11:46','2025-01-27 04:11:46',NULL),
(114,'C',NULL,'ROSHAN PRINTERS','ROSHAN GARDEN, NEAR P.N.K NAGAR,','JOTHI NAGAR MURUGAN KOIL BACK SIDE','KURINJIPADI, VADALUR','CUDDALORE','TAMIL NADU','607303','India','SOUTH','33IWJPS8789D2ZN','IWJPS8789D',20,20,'2025-02-07 04:12:24','2025-02-07 05:27:13',NULL),
(115,'C',NULL,'SHREEDHAR PRINTERS PVT. LTD.','J & K BLOCK','RAVI INDUSTRIAL ESTATE','DUDHESHWAR','AHMEDABAD','GUJARAT','380004','India','West','24AAICS0400P1ZF',NULL,1,1,'2025-02-08 00:52:15','2025-02-08 01:03:02',NULL),
(116,'C',NULL,'MULTIVISTA GLOBAL PVT LTD','43,','VANDALUR KELAMBAKKAM ROAD,','PUDUPAKKAM,','CHENNAI','TAMIL NADU','603103','India','South','33AAACM7613G1ZS','AAACM7613G',1,1,'2025-02-11 00:50:21','2025-02-11 01:31:12',NULL),
(117,'C',NULL,'SD PACKAGING','179, BLOCK4,','MPR ESTATES,','SECUNDERABAD,','HYDERABAD','TELANGANA','500011','India','South','36ADQFS9865C1ZE','ADQFS9865C',1,NULL,'2025-02-11 22:18:59','2025-02-11 22:18:59',NULL),
(118,'C',NULL,'ALL TIME OFFSET PRINTERS','F- 406,','SECTOR 63,','.','NOIDA','UTTAR PRADESH','201301','India','North','09ADCPJ8659B1ZH','ADCPJ8659B',1,1,'2025-02-11 22:43:31','2025-02-11 22:46:56',NULL),
(119,'C',NULL,'RATHNA OFFSET PRINTERS','40,','PETERS ROAD,','ROYAPETTAH,','CHENNAI','TAMIL NADU','600014','India','South','33AAAFR0858D1ZM','AAAFR0858D',1,NULL,'2025-02-12 05:32:02','2025-02-12 05:32:02',NULL),
(120,'C',NULL,'PRAVIN PRINTING PRESS','D-37, SARDAR ESTATE,','ROAD NO.3,','AJWA ROAD,','VADODARA','GUJARAT','390019','India','West','24ACRPM7691N1ZM','ACRPM7691N',1,NULL,'2025-02-13 03:42:34','2025-02-13 03:42:34',NULL),
(121,'C',NULL,'AZURE PRESS PVT. LTD','PLOT NO. 74, SECTOR-16,','HSIIDC,','DISTT. JHAJJAR,','BAHADURGARH','HARYANA','124507','INDIA','North','06AAHCA9361L1ZA','AAHCA9361L',1,NULL,'2025-02-13 06:03:54','2025-02-13 06:03:54',NULL),
(122,'C',NULL,'CONCORD PRINTING','Plot No. 19,','Shah Industrial Park 3,','Halol-Kotambi Rd., Kotambi,','Vadodara','GUJARAT','391510','INDIA','West','24AAMFC5811F1ZP','AAMFC5811F',1,NULL,'2025-02-14 03:31:41','2025-02-14 03:31:41',NULL),
(123,'C',NULL,'MODERN MULTIPRINT PVT LTD','BEHIND HOTEL SATLUJ,','OPP NATIONAL HANDLOOM CORPORATION,','NARODA,','AHMEDABAD','GUJARAT','382330','INDIA','West','24AANCM4211B1Z0','AANCM4211B',1,NULL,'2025-02-14 05:09:49','2025-02-14 05:09:49',NULL),
(124,'C',NULL,'H B D PACKAGING PVT LTD','PLOT NO. 19,','UDYOG KENDRA INDUSTRIAL AREA,','ECOTECH III,','GREATER NOIDA','UTTAR PRADESH','201306','INDIA','North','09AAACH0512K1ZV','AAACH0512K',1,NULL,'2025-02-14 23:17:33','2025-02-14 23:17:33',NULL),
(125,'C',NULL,'PRANAM PRINT PACK','GROUND FLOOR, AMBIKA BHUVAN,','NEAR SHAHPUR FIRE STATION,','O/S SHAHPUR GATE, SHAHPUR','AHMEDABAD','GUJARAT','380004','INDIA','W','24ABEFP1374K1Z5','ABEFP1374K',1,NULL,'2025-02-17 01:24:54','2025-02-17 01:24:54',NULL),
(126,'C',NULL,'RAJ KAMAL CIRCUITS INDIA','CB-384/40,','RING ROAD,','NARAINA,','DELHI','DELHI','110028','INDIA','North','07AFPPP0451E1ZI','AFPPP0451E',1,1,'2025-02-18 01:40:24','2025-02-18 02:41:30',NULL),
(127,'C',NULL,'ROYAL OFFSET PRINTERS','A-89/1,','NARAINA INDUSTRIAL AREA,','PHASE I,','NEW DELHI','DELHI','110028','INDIA','North','07AEHPA4121K2ZU','AEHPA4121K',1,1,'2025-02-18 02:41:02','2025-02-18 03:58:48',NULL),
(128,'C',NULL,'PM OFFSET PRINTERS','NO. 29 AND 30,','J.C. INDUSTRIAL ESTATE,','YELACHENAHALLI KANAKAPURA ROAD,','BENGALURU','KARNATAKA','560062','INDIA','SOUTH','29AADFP3917E1ZA','AADFP3917E',1,NULL,'2025-02-19 03:06:52','2025-02-19 03:06:52',NULL),
(129,'C',NULL,'KATSURA STOCK','PLOT NO 118,','DLF INDUSTRIAL AREA PHASE 1,','SECTOR- 32','FARIDABAD','HARYANA','121003','INDIA','NORTH','06AAKCK9091L1ZU','AAKCK9091L',1,NULL,'2025-02-19 04:59:35','2025-02-19 04:59:35',NULL),
(130,'C',NULL,'SRI SUDHINDRA OFFSET PROCESS','NO.97-98,','MALLESWARAM','.','BENGALURU','KARNATAKA','560003','INDIA','SOUTH','29AALFS4730J1ZR','AALFS4730J',1,NULL,'2025-02-20 02:58:27','2025-02-20 02:58:27',NULL),
(131,'C',NULL,'FOUR ELEMENTS PRINT PACK','SHUBH INDUSTRIAL ZONE- 6, PLOT NO- 4,','27 NATIONAL HIGHWAY, BEHIND BALSON INDUSTRIES VILL- RIBDA,','TAL. GONDAL,','RAJKOT','GUJARAT','360311','INDIA','west','24AAIFF2410M1ZM','AAIFF2410M',1,NULL,'2025-02-21 01:19:53','2025-02-21 01:19:53',NULL),
(132,'C',NULL,'SAP PRINT SOLUTIONS PVT LTD','PLOT NO.30, SEC-2,','VASAI TALUKA INDUSTRIAL ESTATE, GAURAIPADA,','VASAI EAST,','MUMBAI','MAHARASHTRA','401208','INDIA','west','27AALCS8406N1ZO','AALCS8406N',1,NULL,'2025-02-21 01:35:38','2025-02-21 01:35:38',NULL),
(133,'C',NULL,'PRINT VISION PVT LTD','PRINT VISION HOUSE LANE,','OPP.CENTRAL BANK OF INDIA,','AMBAWADI','AHMEDABAD','GUJARAT','380006','INDIA','West','24AAACP9194M1ZV','AAACP9194M',1,NULL,'2025-02-22 06:55:26','2025-02-22 06:55:26',NULL),
(134,'C',NULL,'Oceans Deep Printers','C1, Chinaibaug Estate','Near Union Bank','Near Torrent Power, Dudheshwar','AHMEDABAD','GUJARAT','380004','INDIA','WEST','24ACTPP0310K1ZL','ACTPP0310K',1,NULL,'2025-02-25 06:25:19','2025-02-25 06:25:19',NULL),
(135,'C',NULL,'VIBA PRESS PVT LTD','C - 66/3','PHASE-II','OKHLA INDUSTRIAL AREA',NULL,'NEW DELHI','110020','INDIA','North','07AAACV3123A1Z1','AAACV3123A',1,NULL,'2025-02-25 07:03:28','2025-02-25 07:03:28',NULL),
(136,'C',NULL,'STERLING PRINT HOUSE PVT LTD','49/1849, PONNEKKARA,','CHERANELLOR ROAD AIMS,','PONNEKKARA PO.','COCHIN','KERALA','682041','INDIA','SOUTH','32AADCS3232J1ZN','AADCS3232J',1,NULL,'2025-03-02 23:19:18','2025-03-02 23:19:18',NULL);

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES
(1,'view dashboard','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(2,'view users','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(3,'create users','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(4,'edit users','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(5,'delete users','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(6,'view parties','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(7,'create parties','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(8,'edit parties','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(9,'delete parties','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(10,'view contacts','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(11,'create contacts','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(12,'edit contacts','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(13,'delete contacts','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(14,'view manufacturers','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(15,'create manufacturers','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(16,'edit manufacturers','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(17,'delete manufacturers','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(18,'view machine models','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(19,'create machine models','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(20,'edit machine models','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(21,'delete machine models','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(22,'view rollers','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(23,'create rollers','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(24,'edit rollers','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(25,'delete rollers','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(26,'view materials','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(27,'create materials','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(28,'edit materials','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(29,'delete materials','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(30,'view quotations','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(31,'create quotations','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(32,'edit quotations','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(33,'delete quotations','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(34,'view proforma invoice','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(35,'create proforma invoice','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(36,'edit proforma invoice','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(37,'delete proforma invoice','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(38,'view roller numbers','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(39,'create roller numbers','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(40,'edit roller numbers','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(41,'delete roller numbers','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(42,'view job cards','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(43,'create job cards','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(44,'edit job cards','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(45,'delete job cards','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(46,'view batch code','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(47,'create batch code','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(48,'edit batch code','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(49,'delete batch code','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(50,'view scan barcode','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(51,'view derubber','web','2024-10-05 02:57:37','2024-10-05 02:57:37'),
(52,'view sand blast','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(53,'view bond apply','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(54,'view sheet plying','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(55,'view vulcanization','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(56,'view rough grinding','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(57,'view side cutting','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(58,'view final grinding','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(59,'view auto polish','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(60,'view finishing','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(61,'view shipping','web','2024-10-05 02:57:38','2024-10-05 02:57:38');

--
-- Table structure for table `quotations`
--

CREATE TABLE `quotations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(2) NOT NULL,
  `quotation_number` varchar(32) NOT NULL,
  `quotation_date` date NOT NULL,
  `currency` varchar(3) NOT NULL DEFAULT 'INR',
  `amount` decimal(12,2) NOT NULL,
  `gst_rate` tinyint(4) NOT NULL,
  `cgst` decimal(12,2) NOT NULL DEFAULT 0.00,
  `sgst` decimal(12,2) NOT NULL DEFAULT 0.00,
  `igst` decimal(12,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT '%',
  `shipping_charges` decimal(12,2) NOT NULL DEFAULT 0.00,
  `core_repair_charges` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_in_words` varchar(1024) DEFAULT NULL,
  `party_id` int(11) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `pincode` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `region` varchar(255) DEFAULT NULL,
  `gstin` varchar(255) DEFAULT NULL,
  `contact_ids` varchar(128) DEFAULT NULL,
  `quotation_for` varchar(255) DEFAULT NULL,
  `quotation_for_emails` varchar(512) DEFAULT NULL,
  `inquiry` varchar(255) DEFAULT NULL,
  `shipment_terms` varchar(255) DEFAULT NULL,
  `payment_terms` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `order_type` varchar(255) NOT NULL,
  `manufacturer_id` int(11) NOT NULL,
  `machine_model_id` int(11) NOT NULL,
  `roller_type` varchar(255) DEFAULT NULL,
  `variant` varchar(128) DEFAULT NULL,
  `status` enum('Generated','Converted','Cancelled','Partially Converted') NOT NULL DEFAULT 'Generated',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `quotations_quotation_number_unique` (`quotation_number`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quotations`
--

INSERT INTO `quotations` VALUES
(1,'DO','KQ/DO/24-25/0001','2025-03-17','INR',23050.00,18,0.00,0.00,4011.00,10.00,5.00,500.00,26293.00,'Rupees Twenty Six Thousands Two Hundred  Ninety Three   Only',1,'7/3, SADANWADI, OPP BHANDUP POLICE STATION, OFF LBS MARG, LAKE ROAD, BHANDUP (W)','MUMBAI','MAHARASHTRA','400078','INDIA','WEST','27AHSPD9460C1Z6','10, 116','MR ANKIT DOSHI, MR Gaurav Kumar','converter@hotmail.com, gaurav@alpinesoftit.com','Mail','5','100','Size; Rubber Diameter x Core Diameter x Rubber Length, Maker\'s inspection is to be final as for the quality.',NULL,'Rerubberization',1,1,NULL,'Oil Base','Converted',1,NULL,'2025-03-17 06:11:18','2025-03-18 03:49:10',NULL);

--
-- Table structure for table `quotations_items`
--

CREATE TABLE `quotations_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `quotation_id` bigint(20) NOT NULL,
  `roller_id` int(11) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `dimensions` varchar(255) DEFAULT NULL,
  `compound` varchar(255) DEFAULT NULL,
  `compound_id` int(11) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `rate` decimal(8,2) NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  `cgst` decimal(8,2) NOT NULL,
  `sgst` decimal(8,2) NOT NULL,
  `igst` decimal(8,2) NOT NULL,
  `total` decimal(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quotations_items`
--

INSERT INTO `quotations_items` VALUES
(1,1,1,'Ink first form roller - 520GX','49x510x595','SIGMA ECO 30',1,1,4998.00,4998.00,0.00,0.00,900.00,5898.00,NULL,NULL),
(2,1,2,'Ink first form roller (Osc) - 520GX','49x510x595','SIGMA ECO 30',1,0,4998.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(3,1,3,'Ink second form roller  - 520GX','47x510x560','SIGMA ECO 30',1,0,4794.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(4,1,4,'Ink third form roller  - 520GX','45x510x576','SIGMA ECO 30',1,2,4590.00,9180.00,0.00,0.00,1652.00,10832.00,NULL,NULL),
(5,1,5,'Ink fourth form roller  - 520GX','51x510x614','SIGMA ECO 30',1,0,5202.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(6,1,13,'Plate holding roller  - 520GX','22x504x538','SIGMA ECO 30',1,4,2218.00,8872.00,0.00,0.00,1597.00,10469.00,NULL,NULL),
(7,1,10,'Ink ductor roller  - 520GX','45.5x515x607','SIGMA ECO 30',2,0,4686.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(8,1,6,'? 52 distributor roller  - 520GX','52x515x600','SIGMA ECO 30',3,0,5356.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(9,1,7,'? 52 distributor roller  - 520GX','52x515x600','SIGMA ECO 30',3,0,5356.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(10,1,8,'? 52 distributor roller  - 520GX','52x515x640','SIGMA ECO 30',3,0,5356.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(11,1,9,'? 52 distributor roller  - 520GX','52x515x640','SIGMA ECO 30',3,0,5356.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(12,1,11,'Water form roller  - 520GX','50.5x511x615','HW-25',4,0,5677.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL),
(13,1,12,'Metering roller  - 520GX','63x548x632','HW-25',5,0,7595.00,0.00,0.00,0.00,0.00,0.00,NULL,NULL);

--
-- 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`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES
(1,'Admin','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(2,'Derubber','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(3,'SandBlast','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(4,'BondApply','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(5,'SheetPlying','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(6,'Vulcanize','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(7,'RoughGrind','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(8,'SideCut','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(9,'FinalGrind','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(10,'AutoPolish','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(11,'Inspection','web','2024-10-05 02:57:38','2024-10-05 02:57:38'),
(14,'Shipping','web','2025-01-10 07:50:42','2025-01-10 07:50:42');

--
-- Table structure for table `roller_numbers`
--

CREATE TABLE `roller_numbers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `roller_no` varchar(4) NOT NULL,
  `po_no` varchar(32) DEFAULT NULL,
  `party_id` int(11) DEFAULT NULL,
  `manufacturer_id` int(11) NOT NULL,
  `machine_model_id` int(11) NOT NULL,
  `roller_id` int(11) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `compound` varchar(255) DEFAULT NULL,
  `compound_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roller_numbers_roller_no_unique` (`roller_no`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roller_numbers`
--

INSERT INTO `roller_numbers` VALUES
(1,'A101','KPI/DO/24-25/0001',1,1,1,1,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:12:07','2025-03-18 00:12:07',NULL),
(2,'A102','KPI/DO/24-25/0001',1,1,1,4,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:12:07','2025-03-31 12:02:18',NULL),
(3,'A103','KPI/DO/24-25/0001',1,1,1,4,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:12:07','2025-03-18 00:12:07',NULL),
(4,'A104','KPI/DO/24-25/0001',1,1,1,13,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:12:07','2025-03-18 00:12:07',NULL),
(5,'A105','KPI/DO/24-25/0001',1,1,1,13,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:12:07','2025-03-18 00:12:07',NULL),
(6,'A106','KPI/DO/24-25/0001',1,1,1,13,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:12:07','2025-03-18 00:12:07',NULL),
(7,'A107','KPI/DO/24-25/0001',1,1,1,13,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:12:07','2025-03-18 00:12:07',NULL),
(8,'A108','KPI/DO/24-25/0001',1,1,1,1,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:24:45','2025-03-18 00:24:45',NULL),
(9,'A109','KPI/DO/24-25/0001',1,1,1,4,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:24:45','2025-03-18 00:24:45',NULL),
(10,'A110','KPI/DO/24-25/0001',1,1,1,4,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:24:45','2025-03-18 00:24:45',NULL),
(11,'A111','KPI/DO/24-25/0001',1,1,1,13,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:24:45','2025-03-18 00:24:45',NULL),
(12,'A112','KPI/DO/24-25/0001',1,1,1,13,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:24:45','2025-03-18 00:24:45',NULL),
(13,'A113','KPI/DO/24-25/0001',1,1,1,13,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:24:45','2025-03-18 00:24:45',NULL),
(14,'A114','KPI/DO/24-25/0001',1,1,1,13,1,'SIGMA ECO 30',1,1,NULL,'2025-03-18 00:24:45','2025-03-18 00:24:45',NULL);

--
-- Table structure for table `rollers`
--

CREATE TABLE `rollers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `machine_model_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(256) DEFAULT NULL,
  `diag_no` text NOT NULL,
  `core_diameter` double NOT NULL,
  `outer_diameter` double NOT NULL,
  `overall_length` double NOT NULL,
  `effective_length` double NOT NULL,
  `hardness` varchar(255) NOT NULL,
  `cylindercity` varchar(256) DEFAULT NULL,
  `roundness` varchar(256) DEFAULT NULL,
  `champer` varchar(256) DEFAULT '0',
  `taper` varchar(256) DEFAULT '0',
  `drawing` varchar(256) DEFAULT NULL,
  `core_charges` varchar(256) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rollers_machine_model_id_index` (`machine_model_id`)
) ENGINE=InnoDB AUTO_INCREMENT=252 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rollers`
--

INSERT INTO `rollers` VALUES
(1,1,'Ink first form roller - 520GX','Ink Form','1',0,49,595,510,'(30°)',NULL,NULL,'0','0','pdf/1738836744_6YENE6.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-03-17 22:41:46',NULL),
(2,1,'Ink first form roller (Osc) - 520GX','Ink Form','1',0,49,595,510,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(3,1,'Ink second form roller  - 520GX','Ink Form','2',0,47,560,510,'(30°)',NULL,NULL,'2','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(4,1,'Ink third form roller  - 520GX','Ink Form','3',0,45,576,510,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(5,1,'Ink fourth form roller  - 520GX','Ink Form','4',0,51,614,510,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(6,1,'? 52 distributor roller  - 520GX','Ink Transfer Roller','7',0,52,600,515,'(50°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(7,1,'? 52 distributor roller  - 520GX','Ink Transfer Roller','8',0,52,600,515,'(50°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(8,1,'? 52 distributor roller  - 520GX','Ink Transfer Roller','10',0,52,640,515,'(50°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(9,1,'? 52 distributor roller  - 520GX','Ink Transfer Roller','11',0,52,640,515,'(50°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(10,1,'Ink ductor roller  - 520GX','Ductor Roller','12',0,45.5,607,515,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(11,1,'Water form roller  - 520GX','Damp Form Roller','13',0,50.5,615,511,'(20°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(12,1,'Metering roller  - 520GX','Damp Metering / Pan Roller','14',0,63,632,548,'(20°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(13,1,'Plate holding roller  - 520GX','Ink Form','15',0,22,538,504,'(60°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(14,15,'Ink first form roller - 920ST-STD','Ink Form','1',44,64,1017.8,910,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:14:42',NULL),
(15,15,'Ink first form roller (Osc) - 920ST-STD','Ink Form','1',44,64,1017.8,910,'(30°)','0','0','1','0','pdf/1740724999_wYUZxV.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:13:21',NULL),
(16,15,'Ink second form roller  - 920ST-STD','Ink Form','2',44,62,956.8,910,'(30°)','0','0','2','0','pdf/1738836890_9t5RlL.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-06 04:44:54',NULL),
(17,15,'Ink second form roller (Osc) - 920ST-STD','Ink Form','2',44,62,956.8,910,'(30°)','0','0','1','0','pdf/1740725031_w55NZY.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:13:54',NULL),
(18,15,'Ink third form roller  - 920ST-STD','Ink Form','3',44,66,956.8,910,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:22:57',NULL),
(19,15,'Ink third form roller (Osc) - 920ST-STD','Ink Form','3',44,66,956.8,910,'(30°)','0','0','1','0','pdf/1740725092_XV44B0.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:14:55',NULL),
(20,15,'Ink fourth form roller  - 920ST-STD','Ink Form','4',59,77,1017.8,910,'(30°)',NULL,NULL,'2','0','pdf/1740725152_xtf0Kp.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:15:54',NULL),
(21,15,'? 66 transfer roller - 920ST-STD','Ink Transfer Roller','6',38,66,954,910,'(30°)',NULL,NULL,'2','0','pdf/1740724824_TwQFlF.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:10:26',NULL),
(22,15,'? 66 transfer roller - 920ST-STD','Ink Transfer Roller','7',38,66,954,910,'(30°)',NULL,NULL,'2','0','pdf/1740724785_KTOWUN.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:09:50',NULL),
(23,15,'? 66 transfer roller - 920ST-STD','Ink Transfer Roller','8',38,66,954,910,'(30°)',NULL,NULL,'2','0','pdf/1740724745_wPau6w.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:09:12',NULL),
(24,15,'? 68 transfer roller - 920ST-STD','Ink Transfer Roller','9',38,68,998,910,'(30°)',NULL,NULL,'2','0','pdf/1740724669_3WnFGk.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:07:50',NULL),
(25,15,'? 68 transfer roller - 920ST-STD','Ink Transfer Roller','10',38,68,998,910,'(30°)',NULL,NULL,'2','0','pdf/1740724636_eT05HM.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:07:18',NULL),
(26,15,'Ink ductor roller  - 920ST-STD','Ductor Roller','13',36,50,1023,910,'(30°)',NULL,NULL,'2','0','pdf/1740724590_DNR2Ug.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:06:33',NULL),
(27,15,'Metering roller  - 920ST-STD','Damp Metering / Pan Roller','14',54,80,1040.8,960,'(25°)',NULL,NULL,'0','0','pdf/1740724512_IeSKbI.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:05:14',NULL),
(28,15,'Water form roller  - 920ST-STD','Damp Form Roller','15',44,60.34,1047,911,'(25°)',NULL,NULL,'2','0','pdf/1740724431_90qeaQ.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:04:04',NULL),
(29,16,'Ink first form roller - 940ST-STD','Ink Form','1',44,64,1052.8,945,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:23:39',NULL),
(30,16,'Ink first form roller (Osc) - 940ST-STD','Ink Form','1',44,64,1052.8,945,'(30°)','0','0','1','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:23:55',NULL),
(31,16,'Ink second form roller  - 940ST-STD','Ink Form','2',44,62,991.8,945,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:24:14',NULL),
(32,16,'Ink second form roller (Osc) - 940ST-STD','Ink Form','2',44,62,991.8,945,'(30°)','0','0','1','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:24:44',NULL),
(33,16,'Ink third form roller  - 940ST-STD','Ink Form','3',44,66,991.8,945,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:25:05',NULL),
(34,16,'Ink third form roller (Osc) - 940ST-STD','Ink Form','3',44,66,991.8,945,'(30°)','0','0','1','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:25:24',NULL),
(35,16,'Ink fourth form roller  - 940ST-STD','Ink Form','4',59,77,1052.8,945,'(30°)',NULL,NULL,'2','0','pdf/1740726940_vC7qS1.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:45:48',NULL),
(36,16,'? 66 transfer roller - 940ST-STD','Ink Transfer Roller','6',38,66,989,945,'(30°)',NULL,NULL,'2','0','pdf/1740726878_q2B9p2.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:44:42',NULL),
(37,16,'? 66 transfer roller - 940ST-STD','Ink Transfer Roller','7',38,66,989,945,'(30°)',NULL,NULL,'2','0','pdf/1740726842_VPo3WN.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:44:05',NULL),
(38,16,'? 66 transfer roller - 940ST-STD','Ink Transfer Roller','8',38,66,989,945,'(30°)',NULL,NULL,'2','0','pdf/1740726820_8AY1ZF.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:43:41',NULL),
(39,16,'? 68 transfer roller - 940ST-STD','Ink Transfer Roller','9',38,68,1033,945,'(30°)',NULL,NULL,'2','0','pdf/1740726752_F7ZN4I.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:42:34',NULL),
(40,16,'? 68 transfer roller - 940ST-STD','Ink Transfer Roller','10',38,68,1033,945,'(30°)',NULL,NULL,'2','0','pdf/1740726720_cmhWOU.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:42:07',NULL),
(41,16,'Ink ductor roller  - 940ST-STD','Ductor Roller','13',36,50,1058,945,'(30°)',NULL,NULL,'2','0','pdf/1740726278_zsjsyl.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:37:45',NULL),
(42,16,'Metering roller  - 940ST-STD','Damp Metering / Pan Roller','14',54,80,1075.8,995,'(25°)',NULL,NULL,'0','0','pdf/1740726236_UxOYA4.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:34:05',NULL),
(43,16,'Water form roller  - 940ST-STD','Damp Form Roller','15',44,60.34,1082,946,'(25°)',NULL,NULL,'2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-20 04:18:49',NULL),
(44,5,'Ink first form roller - 750W','Ink Form','1',0,64,867.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(45,5,'Ink first form roller (Osc) - 750W','Ink Form','1',0,64,867.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(46,5,'ink second form roller - 750W','Ink Form','2',0,62,821.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(47,5,'ink second form roller (Osc) - 750W','Ink Form','2',0,62,821.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(48,5,'ink third form roller - 750W','Ink Form','3',0,66,821.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(49,5,'ink third form roller (Osc) - 750W','Ink Form','3',0,66,821.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(50,5,'ink fourth form roller - 750W','Ink Form','4',0,77,867.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(51,5,'? 66 distributor roller - 750W','Ink Transfer Roller','6',0,66,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(52,5,'? 66 distributor roller - 750W','Ink Transfer Roller','7',0,66,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(53,5,'? 66 distributor roller - 750W','Ink Transfer Roller','8',0,66,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(54,5,'? 68 distributor roller - 750W','Ink Transfer Roller','9',0,68,848,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(55,5,'? 68 distributor roller - 750W','Ink Transfer Roller','10',0,68,848,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(56,5,'ink ductor roller - 750W','Ductor Roller','13',0,50,874,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(57,5,'Metering roller - 750W','Damp Metering / Pan Roller','14',0,80,891.8,825,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(58,5,'Water form roller - 750W','Damp Form Roller','15',0,60.34,898,776,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(59,17,'Ink first form roller - 970ST','Ink Form','1',44,64,1052.8,945,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:28:16',NULL),
(60,17,'Ink first form roller (Osc) - 970ST','Ink Form','1',44,64,1052.8,945,'(30°)','0','0','1','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:28:30',NULL),
(61,17,'Ink second form roller - 970ST','Ink Form','2',44,62,991.8,945,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:28:50',NULL),
(62,17,'Ink second form roller (Osc) - 970ST','Ink Form','2',44,62,991.8,945,'(30°)','0','0','1','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:29:13',NULL),
(63,17,'Ink third form roller - 970ST','Ink Form','3',44,66,991.8,945,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:29:32',NULL),
(64,17,'Ink third form roller (Osc) - 970ST','Ink Form','3',44,66,991.8,945,'(30°)','0','0','1','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-25 05:29:50',NULL),
(65,17,'Ink fourth form roller - 970ST','Ink Form','4',59,77,1052.8,945,'(30°)',NULL,NULL,'2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-20 04:20:35',NULL),
(66,17,'? 66 transfer roller - 970ST','Ink Transfer Roller','6',38,66,989,945,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-24 06:54:45',NULL),
(67,17,'? 66 transfer roller - 970ST','Ink Transfer Roller','7',38,66,989,945,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-24 06:55:23',NULL),
(68,17,'? 66 transfer roller - 970ST','Ink Transfer Roller','8',38,66,989,945,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-24 06:55:49',NULL),
(69,17,'? 68 transfer roller - 970ST','Ink Transfer Roller','9',38,68,1033,945,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-24 06:56:33',NULL),
(70,17,'? 68 transfer roller - 970ST','Ink Transfer Roller','10',38,68,1033,945,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-24 06:56:57',NULL),
(71,17,'Ink ductor roller - 970ST','Ductor Roller','13',36,50,1058,945,'(30°)','0','0','2','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-24 06:57:21',NULL),
(72,17,'Metering roller - 970ST','Damp Metering / Pan Roller','14',54,80,1075.8,995,'(25°)','0','0','0','0',NULL,NULL,1,20,'2025-01-02 05:37:30','2025-01-24 06:57:42',NULL),
(73,17,'Water form roller - 970ST','Damp Form Roller','15',44,70.4,1082,946,'(20°)','0','0','2','0','pdf/1740726195_WSWo2B.pdf',NULL,1,1,'2025-01-02 05:37:30','2025-02-28 01:33:21',NULL),
(74,27,'Ink first form roller (oscillating*) - 670ST','Ink Form','1',0,64,867.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(75,27,'Ink second form roller (oscillating*) - 670ST','Ink Form','2',0,62,821.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(76,27,'Ink third form roller (oscillating*) - 670ST','Ink Form','3',0,66,821.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(77,27,'Ink fourth form roller - 670ST','Ink Form','4',0,77,867.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(78,27,'? 66 transfer roller - 670ST','Ink Transfer Roller','6',0,66,819,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(79,27,'? 66 transfer roller - 670ST','Ink Transfer Roller','7',0,66,819,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(80,27,'? 66 transfer roller - 670ST','Ink Transfer Roller','8',0,66,819,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(81,27,'? 68 transfer roller - 670ST','Ink Transfer Roller','9',0,68,848,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(82,27,'? 68 transfer roller - 670ST','Ink Transfer Roller','10',0,68,848,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(83,27,'Ink ductor roller - 670ST','Ductor Roller','13',0,50,874,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(84,27,'Metering roller - 670ST','Damp Metering / Pan Roller','14',0,80,891.8,825,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(85,27,'Water form roller - 670ST','Damp Form Roller','15',0,60.34,898,671,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(86,28,'Ink first form roller (oscillating*) - 790ST','Ink Form','1',0,64,867.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(87,28,'Ink second form roller (oscillating*) - 790ST','Ink Form','2',0,62,821.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(88,28,'Ink third form roller (oscillating*) - 790ST','Ink Form','3',0,66,821.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(89,28,'Ink fourth form roller - 790ST','Ink Form','4',0,77,867.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(90,28,'? 66 transfer roller - 790ST','Ink Transfer Roller','6',0,66,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(91,28,'? 66 transfer roller - 790ST','Ink Transfer Roller','7',0,66,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(92,28,'? 66 transfer roller - 790ST','Ink Transfer Roller','8',0,66,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(93,28,'? 68 transfer roller - 790ST','Ink Transfer Roller','9',0,68,848,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(94,28,'? 68 transfer roller - 790ST','Ink Transfer Roller','10',0,68,848,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(95,28,'Ink ductor roller - 790ST','Ductor Roller','13',0,50,874,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(96,28,'Metering roller - 790ST','Damp Metering / Pan Roller','14',0,80,891.8,825,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(97,28,'Water form roller - 790ST','Damp Form Roller','15',0,60.34,898,776,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(98,29,'Ink first form roller - 750','Ink Form','1',0,64,867.8,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:34:36',NULL),
(99,29,'Ink first form roller  (Osc) - 750','Ink Form','1',0,64,867.8,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:35:35',NULL),
(100,29,'Ink second form roller - 750','Ink Form','2',0,62,806.8,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:37:15',NULL),
(101,29,'Ink second form roller  (Osc) - 750','Ink Form','2',0,62,806.8,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:39:36',NULL),
(102,29,'Ink third form roller - 750','Ink Form','3',0,66,806.8,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:41:16',NULL),
(103,29,'Ink third form roller  (Osc) - 750','Ink Form','3',0,66,806.8,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:42:29',NULL),
(104,29,'Ink fourth form roller - 750','Ink Form','4',0,68,867.8,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:45:41',NULL),
(105,29,'? 66 distributor roller - 750','Ink Transfer Roller','6',0,66,804,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:46:57',NULL),
(106,29,'? 66 distributor roller - 750','Ink Transfer Roller','7',0,66,804,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:47:52',NULL),
(107,29,'? 66 distributor roller - 750','Ink Transfer Roller','8',0,66,804,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:48:39',NULL),
(108,29,'? 68 distributor roller - 750','Ink Transfer Roller','9',0,68,848,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:54:51',NULL),
(109,29,'? 68 distributor roller - 750','Ink Transfer Roller','10',0,68,848,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:56:28',NULL),
(110,29,'Ink ductor roller - 750','Ductor Roller','13',0,50,874,760,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:57:55',NULL),
(111,29,'Metering roller - 750','Damp Metering / Pan Roller','14',0,80,891.8,810,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:59:13',NULL),
(112,29,'Water form roller - 750','Damp Form Roller','15',0,60.34,898,761,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30','2025-02-17 06:59:56',NULL),
(113,24,'Ink first form roller - 782/4/5E/EP','Ink Form','1',0,63,867.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(114,24,'Ink first form roller\n(Osc) - 782/4/5E/EP','Ink Form','1',0,63,867.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(115,24,'Ink second form roller - 782/4/5E/EP','Ink Form','2',0,65,828.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(116,24,'Ink second form roller (Osc) - 782/4/5E/EP','Ink Form','2',0,65,828.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(117,24,'Ink third form roller - 782/4/5E/EP','Ink Form','3',0,61.5,828.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(118,24,'Ink third form roller\n(Osc) - 782/4/5E/EP','Ink Form','3',0,61.5,828.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(119,24,'Ink fourth form roller - 782/4/5E/EP','Ink Form','4',0,77,867.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(120,24,'? 66 distributor roller - 782/4/5E/EP','Ink Transfer Roller','6',0,66,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(121,24,'? 66 distributor roller - 782/4/5E/EP','Ink Transfer Roller','7',0,66,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(122,24,'? 66 distributor roller - 782/4/5E/EP','Ink Transfer Roller','8',0,66,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(123,24,'? 68 distributor roller - 782/4/5E/EP','Ink Transfer Roller','9',0,68,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(124,24,'? 68 distributor roller - 782/4/5E/EP','Ink Transfer Roller','10',0,68,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(125,24,'Ink ductor roller - 782/4/5E/EP','Ductor Roller','12',0,50,874,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(126,24,'Metering roller - 782/4/5E/EP','Damp Metering / Pan Roller','13',0,80,891.8,821,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(127,24,'Water form roller - 782/4/5E/EP','Damp Form Roller','14',0,66.5,898,776,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(128,23,'Ink first form roller - 760/E','Ink Form','1',0,64,867.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(129,23,'Ink first form roller\n(Osc) - 760/E','Ink Form','1',0,64,867.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(130,23,'Ink second form roller - 760/E','Ink Form','2',0,62,821.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(131,23,'Ink second form roller (Osc) - 760/E','Ink Form','2',0,62,821.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(132,23,'Ink third form roller - 760/E','Ink Form','3',0,66,821.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(133,23,'Ink third form roller (Osc) - 760/E','Ink Form','3',0,66,821.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(134,23,'Ink fourth form roller - 760/E','Ink Form','4',0,77,867.8,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(135,23,'? 66 transfer roller - 760/E','Ink Transfer Roller','6',0,66,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(136,23,'? 66 transfer roller - 760/E','Ink Transfer Roller','7',0,66,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(137,23,'? 66 transfer roller - 760/E','Ink Transfer Roller','8',0,66,819,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(138,23,'? 68 transfer roller - 760/E','Ink Transfer Roller','9',0,68,848,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(139,23,'? 68 transfer roller - 760/E','Ink Transfer Roller','10',0,68,848,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(140,23,'Ink ductor roller - 760/E','Ductor Roller','13',0,50,874,775,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(141,23,'Metering roller - 760/E','Damp Metering / Pan Roller','14',0,80,891.8,825,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(142,23,'Water form roller - 760/E','Damp Form Roller','15',0,60.34,898,776,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(143,30,'Ink first form roller (Osc) - 680X','Ink Form','1',0,64,867.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(144,30,'Ink second form roller (Osc) - 680X','Ink Form','2',0,62,821.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(145,30,'Ink third form roller (Osc) - 680X','Ink Form','3',0,66,821.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(146,30,'Ink fourth form roller - 680X','Ink Form','4',0,77,867.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(147,30,'? 66 distributor roller - 680X','Ink Transfer Roller','6',0,66,819,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(148,30,'? 66 distributor roller - 680X','Ink Transfer Roller','7',0,66,819,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(149,30,'? 66 distributor roller - 680X','Ink Transfer Roller','8',0,66,819,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(150,30,'? 68 distributor roller - 680X','Ink Transfer Roller','9',0,68,848,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(151,30,'? 68 distributor roller - 680X','Ink Transfer Roller','10',0,68,848,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(152,30,'Ink ductor roller - 680X','Ductor Roller','13',0,50,874,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(153,30,'Metering roller - 680X','Damp Metering / Pan Roller','14',0,80,891.8,825,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(154,30,'Water form roller - 680X','Damp Form Roller','15',0,60.34,898,671,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(155,4,'Ink first form roller - 680ST','Ink Form','1',0,64,777.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(156,4,'Ink first form roller (Osc) - 680ST','Ink Form','1',0,64,777.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(157,4,'ink second form roller - 680ST','Ink Form','2',0,62,743.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(158,4,'ink second form roller (Osc) - 680ST','Ink Form','2',0,62,743.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(159,4,'ink third form roller - 680ST','Ink Form','3',0,66,743.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(160,4,'ink third form roller (Osc) - 680ST','Ink Form','3',0,66,743.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(161,4,'ink fourth form roller - 680ST','Ink Form','4',0,68,777.8,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(162,4,'? 66 distributor roller - 680ST','Ink Transfer Roller','6',0,66,714,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(163,4,'? 66 distributor roller - 680ST','Ink Transfer Roller','7',0,66,714,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(164,4,'? 66 distributor roller - 680ST','Ink Transfer Roller','8',0,66,714,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(165,4,'? 68 distributor roller - 680ST','Ink Transfer Roller','9',0,68,758,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(166,4,'? 68 distributor roller - 680ST','Ink Transfer Roller','10',0,68,758,670,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(167,4,'ink ductor roller - 680ST','Ductor Roller','13',0,50,784,670,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(168,4,'Metering roller - 680ST','Damp Metering / Pan Roller','14',0,80,801.8,720,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(169,4,'Water form roller - 680ST','Damp Form Roller','15',0,60.34,807,671,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(170,14,'Ink first form roller - 1050ST','Ink Form','1',0,90,1164,1072,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(171,14,'Ink first form roller (Osc) - 1050ST','Ink Form','1',0,90,1164,1072,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(172,14,'ink second form roller - 1050ST','Ink Form','2',0,80,1154,1066,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(173,14,'ink second form roller (Osc) - 1050ST','Ink Form','2',0,80,1154,1066,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(174,14,'ink third form roller - 1050ST','Ink Form','3',0,85,1154,1066,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(175,14,'ink third form roller (Osc) - 1050ST','Ink Form','3',0,85,1154,1066,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(176,14,'ink fourth form roller - 1050ST','Ink Form','4',0,101,1206,1066,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(177,14,'Distributor roller - 1050ST','Ink Transfer Roller','6',0,65,1164,1064,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(178,14,'Distributor roller - 1050ST','Ink Transfer Roller','7',0,80,1164,1064,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(179,14,'Distributor roller - 1050ST','Ink Transfer Roller','8',0,80,1244,1064,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(180,14,'Distributor roller - 1050ST','Ink Transfer Roller','10',0,80,1244,1064,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(181,14,'Distributor roller - 1050ST','Ink Transfer Roller','11',0,90,1208,1064,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(182,14,'Distributor roller - 1050ST','Ink Transfer Roller','13',0,90,1208,1064,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(183,14,'ink ductor roller - 1050ST','Ductor Roller','14',0,72,1200,1066,'(30°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(184,14,'Metering roller - 1050ST','Damp Metering / Pan Roller','15',0,84,1252,1161,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(185,14,'Water form roller - 1050ST','Damp Form Roller','16',0,94,1265.5,1078,'(25°)',NULL,NULL,'0','0',NULL,NULL,1,1,'2025-01-02 05:37:30',NULL,NULL),
(186,33,'1ST INK FORM ROLLER (K1705100-02)','Ink Form','17',48,73,555,470,'30','00','00','00','00','pdf/1737624585_xjWQwh.png',NULL,20,1,'2025-01-23 03:57:15','2025-02-28 01:46:30',NULL),
(187,33,'2ND INK FORM ROLLER (K1705101-02)','Ink Form','9',52,75,555,470,'30','00','00','00','00','pdf/1737624894_NWFarS.png',NULL,20,1,'2025-01-23 04:04:54','2025-02-28 01:47:27',NULL),
(188,33,'WATER FORM ROLLER (K0001908-01)','Damp Form Roller','21',70,90,540,480,'25','0','0','3','0','pdf/1737625141_1WOjAU.png',NULL,20,1,'2025-01-23 04:09:04','2025-02-28 01:48:34',NULL),
(189,33,'METERING ROLLER (NA-D697-04)','Damp Metering / Pan Roller','22',36,58,578,490,'30','0','0','5','0','pdf/1737625649_dC1JYS.png',NULL,20,NULL,'2025-01-23 04:17:31','2025-01-23 04:17:31',NULL),
(190,7,'INK DUCTOR ROLLER','Ductor Roller','2',0,31,0,333,'25','0','0','0','00',NULL,NULL,20,20,'2025-02-07 04:22:49','2025-02-07 05:19:05',NULL),
(191,7,'INK DISTRIBUTOR ROLLER','Ink Transfer Roller','4',0,34,0,335,'35','0','0','0','0',NULL,NULL,20,20,'2025-02-07 04:26:47','2025-02-07 05:19:44',NULL),
(192,7,'INK DISTRIBUTOR ROLLER','Ink Transfer Roller','6',0,34,0,335,'35','0','0','0','0',NULL,NULL,20,20,'2025-02-07 04:39:03','2025-02-07 05:20:30',NULL),
(193,7,'INK DISTRIBUTOR ROLLER (BRIDGE)','Ink Transfer Roller','7',0,34,0,327,'35','0','0','0','0',NULL,NULL,20,20,'2025-02-07 04:52:38','2025-02-07 05:20:58',NULL),
(194,7,'INK DISTRIBUTOR ROLLER','Ink Transfer Roller','9',0,34,0,335,'35','0','0','0','0',NULL,NULL,20,NULL,'2025-02-07 05:22:01','2025-02-07 05:22:01',NULL),
(195,7,'INK DISTRIBUTOR ROLLER','Ink Transfer Roller','11',0,34,0,335,'35','0','0','0','0',NULL,NULL,20,NULL,'2025-02-07 05:22:51','2025-02-07 05:22:51',NULL),
(196,7,'INK FIRST FORM ROLLER','Ink Form','14',0,61.5,0,335,'30','0','0','0','0',NULL,NULL,20,NULL,'2025-02-07 05:23:36','2025-02-07 05:23:36',NULL),
(197,7,'INK SECOND FORM ROLLER','Ink Form','15',0,56,0,335,'30','0','0','0','0',NULL,NULL,20,NULL,'2025-02-07 05:24:06','2025-02-07 05:24:06',NULL),
(198,7,'INK THIRD FORM ROLLER','Ink Form','16',0,65,0,335,'30','0','0','0','0',NULL,NULL,20,NULL,'2025-02-07 05:24:43','2025-02-07 05:24:43',NULL),
(199,7,'SQUEEZE ROLLER','Ink Transfer Roller','17',0,46,0,396,'30','0','0','0','0',NULL,NULL,20,NULL,'2025-02-07 05:25:22','2025-02-07 05:25:22',NULL),
(200,7,'METERING ROLLER','Damp Metering / Pan Roller','19',0,46,0,396,'20','0','0','0','0',NULL,NULL,20,NULL,'2025-02-07 05:26:06','2025-02-07 05:26:06',NULL),
(201,7,'WATER FORM ROLLER','Damp Form Roller','21',0,65.4,0,340,'20','0','0','0','0',NULL,NULL,20,NULL,'2025-02-07 05:26:51','2025-02-07 05:26:51',NULL),
(202,35,'1ST FORM ROLLER','Ink Form','A',61,88,1107.5,1035,'30','0','0','2','0',NULL,NULL,1,NULL,'2025-02-13 07:00:11','2025-02-13 07:00:11',NULL),
(203,35,'2ND FORM ROLLER','Ink Form','B',58,78,1107.5,1035,'30','0','0','2','0',NULL,NULL,1,NULL,'2025-02-13 23:19:21','2025-02-13 23:19:21',NULL),
(204,35,'3RD FORM ROLLER','Ink Form','C',58,85,1107.5,1035,'30','0','0','2','0',NULL,NULL,1,NULL,'2025-02-13 23:31:16','2025-02-13 23:31:16',NULL),
(205,35,'4TH FORM ROLLER','Ink Form','D',61,90,1107.5,1035,'30','0','0','2','0',NULL,NULL,1,NULL,'2025-02-13 23:42:37','2025-02-13 23:42:37',NULL),
(206,35,'DUCT ROLLER','Ductor Roller','E',48,64,1122,1035,'30','0','0','0','0',NULL,NULL,1,NULL,'2025-02-13 23:45:37','2025-02-13 23:45:37',NULL),
(207,35,'DISTRIBUTING ROLLER','Ink Transfer Roller','F',58,78,1146.5,1035,'35','0','0','2','0',NULL,NULL,1,NULL,'2025-02-13 23:48:10','2025-02-13 23:48:10',NULL),
(208,35,'DISTRIBUTING ROLLER','Ink Transfer Roller','H',61,90,1146.5,1035,'35','0','0','2','0',NULL,NULL,1,NULL,'2025-02-13 23:50:54','2025-02-13 23:50:54',NULL),
(209,35,'DISTRIBUTING ROLLER','Ink Transfer Roller','S',61,88,1146.5,1035,'35','0','0','2','0',NULL,NULL,1,NULL,'2025-02-13 23:58:11','2025-02-13 23:58:11',NULL),
(210,35,'FORM ROLLER','Damp Form Roller','V',76,101,1200,1042,'25','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 00:10:06','2025-02-14 00:10:06',NULL),
(211,35,'METERING ROLLER','Damp Metering / Pan Roller','W',60,86,1205,1112,'25','0','0','0','0',NULL,NULL,1,NULL,'2025-02-14 00:17:52','2025-02-14 00:17:52',NULL),
(212,21,'INK DUCTOR ROLLER','Ductor Roller','B',38,63,1070,1030,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 08:12:03','2025-02-14 08:12:03',NULL),
(213,21,'INK TRANSFER ROLLER','Ink Transfer Roller','D',50,78,1098,1030,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 08:17:33','2025-02-14 08:17:33',NULL),
(214,21,'INK TRANSFER ROLLER','Ink Transfer Roller','E',35,61,1278,1030,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 08:20:11','2025-02-14 08:20:11',NULL),
(215,21,'INK TRANSFER ROLLER','Ink Transfer Roller','H',45,72,1128,1030,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 08:22:35','2025-02-14 08:22:35',NULL),
(216,21,'INK TRANSFER ROLLER','Ink Transfer Roller','M',45,71,1162,1030,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 08:24:34','2025-02-14 08:24:34',NULL),
(217,21,'INK TRANSFER ROLLER','Ink Transfer Roller','L',64,93,1098,1030,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 08:27:05','2025-02-14 08:27:05',NULL),
(218,21,'INK TRANSFER ROLLER','Ink Transfer Roller','N',45,71,1156,1030,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 08:30:02','2025-02-14 08:30:02',NULL),
(219,21,'INK TRANSFER ROLLER','Ink Transfer Roller','HQ',35,61,1098,1030,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 08:32:31','2025-02-14 08:32:31',NULL),
(220,21,'INK FORM ROLLER','Ink Form','W',55,84,1120.8,1030,'28','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 08:34:29','2025-02-14 08:34:29',NULL),
(221,21,'INK FORM ROLLER','Ink Form','X',50,75,1094.8,1030,'28','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 08:37:37','2025-02-14 08:37:37',NULL),
(222,21,'INK FORM ROLLER','Ink Form','Y',45,71,1094.8,1030,'28','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 08:39:59','2025-02-14 08:39:59',NULL),
(223,21,'INK FORM ROLLER','Ink Form','Z',55,80,1122.8,1030,'28','0','0','2','0',NULL,NULL,1,NULL,'2025-02-14 08:42:03','2025-02-14 08:42:03',NULL),
(224,21,'WATER FOUNTAIN ROLLER','Damp Metering / Pan Roller','DT',61,82,1167.5,1062,'25','0','0','0','0',NULL,NULL,1,NULL,'2025-02-14 08:47:00','2025-02-14 08:47:00',NULL),
(225,21,'WATER FORM ROLLER','Damp Form Roller','DQ',66,92,1166,1035,'25','0','0','1','0',NULL,NULL,1,NULL,'2025-02-14 08:49:14','2025-02-14 08:49:14',NULL),
(226,37,'Form Inking Roller (White)','Ink Form','1',0,57,0,658,'0','0','0','0','0',NULL,NULL,1,NULL,'2025-02-17 23:31:59','2025-02-17 23:31:59',NULL),
(227,37,'Form Inking Roller (Blue)','Ink Form','2',0,53,0,658,'0','0','0','0','0',NULL,NULL,1,NULL,'2025-02-17 23:40:11','2025-02-17 23:40:11',NULL),
(228,37,'Form Inking Roller (Red)','Ink Form','3',0,51,0,658,'0','0','0','0','0',NULL,NULL,1,NULL,'2025-02-17 23:42:11','2025-02-17 23:42:11',NULL),
(229,37,'Form Inking Roller (Yellow)','Ink Form','4',0,55,0,658,'0','0','0','0','0',NULL,NULL,1,NULL,'2025-02-17 23:43:29','2025-02-17 23:43:29',NULL),
(230,37,'Rubber Covered Roller (Red)','Ink Transfer Roller','9',0,51,731,654,'0','0','0','0','0',NULL,NULL,1,1,'2025-02-17 23:45:31','2025-02-18 01:29:11',NULL),
(231,37,'Rubber Covered Roller (Yellow)','Ink Transfer Roller','10',0,55,731,654,'0','0','0','0','0',NULL,NULL,1,1,'2025-02-17 23:57:20','2025-02-18 01:29:51',NULL),
(232,37,'Rubber Covered Roller (White)','Ink Transfer Roller','12',0,57,731,654,'0','0','0','0','0',NULL,NULL,1,1,'2025-02-18 00:39:24','2025-02-18 01:30:31',NULL),
(233,37,'Rubber Covered Roller (Red)','Ink Transfer Roller','14',0,51,731,654,'0','0','0','0','0',NULL,NULL,1,1,'2025-02-18 00:40:59','2025-02-18 01:31:04',NULL),
(234,37,'Rubber Covered Roller (Blue)','Ink Transfer Roller','16',0,53,731,654,'0','0','0','0','0',NULL,NULL,1,1,'2025-02-18 00:42:54','2025-02-18 01:31:40',NULL),
(235,37,'Rubber Covered Roller (Red)','Ink Transfer Roller','19',0,51,731,654,'0','0','0','0','0',NULL,NULL,1,1,'2025-02-18 00:45:08','2025-02-18 01:32:09',NULL),
(236,37,'Water Pan Roller (ALCOLOR)','Damp Metering / Pan Roller','21',0,84.6,674,674,'0','0','0','0','0',NULL,NULL,1,1,'2025-02-18 00:47:25','2025-02-18 01:35:00',NULL),
(237,37,'Form Dampening Roller (ALCOLOR)','Damp Form Roller','24',0,68,658,658,'0','0','0','0','0',NULL,NULL,1,1,'2025-02-18 00:49:03','2025-02-18 01:35:52',NULL),
(238,20,'INK DUCTOR ROLLER','Ductor Roller','B',32,57,862,822,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-03-03 05:06:42','2025-03-03 05:06:42',NULL),
(239,20,'INK TRANSFER ROLLER','Ink Transfer Roller','D',45,65,1078,826,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-03-03 05:10:04','2025-03-03 05:10:04',NULL),
(240,20,'INK TRANSFER ROLLER','Ink Transfer Roller','E',45,65,1078,826,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-03-03 05:12:20','2025-03-03 05:12:20',NULL),
(241,20,'INK TRANSFER ROLLER','Ink Transfer Roller','H',45,65,932,826,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-03-03 06:10:49','2025-03-03 06:10:49',NULL),
(242,20,'INK TRANSFER ROLLER','Ink Transfer Roller','L',45,65,960,826,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-03-03 06:17:34','2025-03-03 06:17:34',NULL),
(243,20,'INK TRANSFER ROLLER','Ink Transfer Roller','M',45,65,1078,826,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-03-03 06:19:28','2025-03-03 06:19:28',NULL),
(244,20,'INK TRANSFER ROLLER','Ink Transfer Roller','N',50,77,988,826,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-03-03 06:25:49','2025-03-03 06:25:49',NULL),
(245,20,'INK TRANSFER ROLLER','Ink Transfer Roller','Q',35,55,902,826,'32','0','0','2','0',NULL,NULL,1,NULL,'2025-03-03 06:48:41','2025-03-03 06:48:41',NULL),
(246,20,'INK FORM ROLLER','Ink Form','W',50,77,928,826,'28','0','0','2','0',NULL,NULL,1,NULL,'2025-03-03 06:54:25','2025-03-03 06:54:25',NULL),
(247,20,'INK FORM ROLLER','Ink Form','X',45,65,902,826,'28','0','0','2','0',NULL,NULL,1,NULL,'2025-03-03 06:56:11','2025-03-03 06:56:11',NULL),
(248,20,'INK FORM ROLLER','Ink Form','Y',45,69,902,826,'28','0','0','2','0',NULL,NULL,1,NULL,'2025-03-03 07:00:04','2025-03-03 07:00:04',NULL),
(249,20,'INK FORM ROLLER','Ink Form','Z',50,73,928,826,'28','0','0','2','0',NULL,NULL,1,NULL,'2025-03-03 07:03:52','2025-03-03 07:03:52',NULL),
(250,20,'WATER FOUNTAIN ROLLER','Damp Metering / Pan Roller','DT',52,73,993,860,'25','0','0','0','0',NULL,NULL,1,NULL,'2025-03-03 07:07:04','2025-03-03 07:07:04',NULL),
(251,20,'WATER FORM ROLLER','Damp Form Roller','DQ',60,81.5,953,833,'25','0','0','1','0',NULL,NULL,1,NULL,'2025-03-03 07:10:01','2025-03-03 07:10:01',NULL);

--
-- Table structure for table `rough_grinds`
--

CREATE TABLE `rough_grinds` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_card_id` int(11) NOT NULL,
  `customer_name` varchar(256) DEFAULT NULL,
  `core_dimension` varchar(256) DEFAULT NULL,
  `compound` varchar(255) DEFAULT NULL,
  `target_roller_dia` varchar(256) DEFAULT NULL,
  `mesure_dia` varchar(256) DEFAULT NULL,
  `status` varchar(28) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rough_grinds`
--


--
-- Table structure for table `sand_blasts`
--

CREATE TABLE `sand_blasts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_card_id` int(11) NOT NULL,
  `customer_name` varchar(256) DEFAULT NULL,
  `core_dimension` varchar(256) DEFAULT NULL,
  `actual_core_dia` varchar(256) DEFAULT NULL,
  `mesure_core_dia` varchar(256) DEFAULT NULL,
  `status` varchar(28) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sand_blasts`
--

INSERT INTO `sand_blasts` VALUES
(3,1,'I THINK INK',NULL,NULL,'4984','DONE',1,NULL,'2025-03-31 11:50:40','2025-03-31 11:50:40',NULL);

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES
('4Bsh7EJcXPWdYBdwP3oqgAI0CjtcLyj72rEgjJr2',NULL,'198.235.24.221','Expanse, a Palo Alto Networks company, searches across the global IPv4 space multiple times per day to identify customers&#39; presences on the Internet. If you would like to be excluded from our scans, please send IP addresses/domains to: scaninfo@paloaltonetworks.com','YTozOntzOjY6Il90b2tlbiI7czo0MDoicmFwMmZKYVd4RGh1dmJ5ckI1Y25IQmJ4NVFnb1dXWDdmaU5GU2dQYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vZXJwLmthdHN1cmEtcm9sbGVyLWluZGlhLmluIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1743494922),
('9Vh9eqcNmMC8T2szIwTxnT7SPhE4XbdNweQzNPpR',NULL,'152.59.97.32','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNnhmdTZqNFcyNjZVYTMwbWJiQ2lvVHlwOGJpZHdDMEVCRVp4VmFMWiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTA6Imh0dHBzOi8vZXJwLmthdHN1cmEtcm9sbGVyLWluZGlhLmluL3JvbGxlci1udW1iZXJzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1743442465),
('ih2lDUWzdCnxHuieAMoOqChULea61klCQwFR8stV',NULL,'51.81.46.212','','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQU55aUlKcVBNbE1pTGw2TXdsZkx1Q3l3Sk9ZRU9wU0hzN3RydmZoUyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vZXJwLmthdHN1cmEtcm9sbGVyLWluZGlhLmluIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1743440375),
('ISZl7qZ1jPRonyqJPWoSfCLFzlT6MwHknhyzVNrM',NULL,'152.56.72.237','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZkZVR2JYR1F4UFhjV2s3VDEwUWFna3NPYkNOUW50UzlmMzJrUUhRayI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTI6Imh0dHBzOi8vZXJwLmthdHN1cmEtcm9sbGVyLWluZGlhLmluL2pvYi1jYXJkcy92aWV3LzEiO319',1743486240),
('y9DoBUydxjuWS8U88UbsRNZR2gY4qksUiRmZQ7Mg',NULL,'152.56.72.184','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSkVYamFndWxzTmp4ZkRieWFTWmhYQmV3cDRQRlBZdWlzdWlEQXg0RiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vZXJwLmthdHN1cmEtcm9sbGVyLWluZGlhLmluL2hvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1743506675);

--
-- Table structure for table `sheet_plyings`
--

CREATE TABLE `sheet_plyings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_card_id` int(11) NOT NULL,
  `customer_name` varchar(256) DEFAULT NULL,
  `core_dimension` varchar(256) DEFAULT NULL,
  `compound` varchar(255) DEFAULT NULL,
  `target_roller_dia` varchar(256) DEFAULT NULL,
  `mesure_roller_dia` varchar(256) DEFAULT NULL,
  `target_rubber_length` varchar(256) DEFAULT NULL,
  `measure_rubber_length` varchar(256) DEFAULT NULL,
  `wrapping_film_type` varchar(256) DEFAULT NULL,
  `status` varchar(28) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sheet_plyings`
--

INSERT INTO `sheet_plyings` VALUES
(3,1,'I THINK INK',NULL,NULL,NULL,'34',NULL,'34','PET','DONE',1,NULL,'2025-03-31 11:51:04','2025-03-31 11:51:04',NULL);

--
-- Table structure for table `shippings`
--

CREATE TABLE `shippings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `job_card_id` int(11) NOT NULL,
  `customer_name` varchar(256) DEFAULT NULL,
  `core_dimension` varchar(256) DEFAULT NULL,
  `roller_number` varchar(256) DEFAULT NULL,
  `roller_type` varchar(256) DEFAULT NULL,
  `roller_size` varchar(256) DEFAULT NULL,
  `qc_details` varchar(256) DEFAULT NULL,
  `shipping_date` date DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `shippings`
--


--
-- Table structure for table `side_cuts`
--

CREATE TABLE `side_cuts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_card_id` int(11) NOT NULL,
  `customer_name` varchar(256) DEFAULT NULL,
  `core_dimension` varchar(256) DEFAULT NULL,
  `compound` varchar(255) DEFAULT NULL,
  `champer` varchar(255) DEFAULT NULL,
  `taper` varchar(255) DEFAULT NULL,
  `target_length` varchar(256) DEFAULT NULL,
  `mesure_length` varchar(256) DEFAULT NULL,
  `status` varchar(28) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `side_cuts`
--


--
-- Table structure for table `vulcanizations_jobcards`
--

CREATE TABLE `vulcanizations_jobcards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vulcanization_id` int(11) NOT NULL,
  `job_card_id` int(11) NOT NULL,
  `status` varchar(128) 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=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vulcanizations_jobcards`
--

INSERT INTO `vulcanizations_jobcards` VALUES
(1,1,1,'DONE','2025-03-31 05:42:21','2025-03-31 11:36:35',NULL),
(2,2,1,'DONE','2025-03-31 11:37:41','2025-03-31 11:45:59',NULL),
(3,3,1,'REJECT','2025-03-31 11:51:42','2025-03-31 11:52:51',NULL);

--
-- Table structure for table `vulcanizes`
--

CREATE TABLE `vulcanizes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `batch_code` int(11) NOT NULL,
  `batch_date` date DEFAULT NULL,
  `status` varchar(28) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) 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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vulcanizes`
--

INSERT INTO `vulcanizes` VALUES
(1,1,'2025-03-31','DONE',1,NULL,'2025-03-31 05:42:02','2025-03-31 11:36:35',NULL),
(2,2,'2025-03-31','DONE',1,NULL,'2025-03-31 11:36:58','2025-03-31 11:45:59',NULL),
(3,3,'2025-03-31','REJECT',1,NULL,'2025-03-31 11:51:32','2025-03-31 11:52:51',NULL);


