-- MySqlBackup.NET 2.0.4 -- Dump Time: 2024-11-14 15:08:42 -- -------------------------------------- -- Server version 8.0.16 MySQL Community Server - GPL /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Definition of aliasproduct -- DROP TABLE IF EXISTS `aliasproduct`; CREATE TABLE IF NOT EXISTS `aliasproduct` ( `id` int(11) NOT NULL AUTO_INCREMENT, `aliasproduct` varchar(255) DEFAULT NULL, `product` varchar(255) DEFAULT NULL, `productid` int(11) DEFAULT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `qa` varchar(50) DEFAULT NULL, `administration` varchar(50) DEFAULT NULL, `admin` varchar(50) DEFAULT NULL, `qatime` datetime DEFAULT NULL, `administtime` datetime DEFAULT NULL, `admintime` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `qaid` varchar(50) DEFAULT NULL, `adminisid` varchar(50) DEFAULT NULL, `adminid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `apaprstatus` varchar(50) DEFAULT NULL, `aprejstatus` varchar(50) DEFAULT NULL, `aprtime` datetime DEFAULT NULL, `rejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; -- -- Dumping data for table aliasproduct -- /*!40000 ALTER TABLE `aliasproduct` DISABLE KEYS */; INSERT INTO `aliasproduct`(`id`,`aliasproduct`,`product`,`productid`,`created`,`updated`,`qa`,`administration`,`admin`,`qatime`,`administtime`,`admintime`,`userid`,`qaid`,`adminisid`,`adminid`,`deletestatus`,`apaprstatus`,`aprejstatus`,`aprtime`,`rejtime`) VALUES (1,'CHLOROBUTANOL','CHLOROBUTANOL',1,'2024-08-10 12:45:56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-08-10 16:45:02',NULL), (2,'CHLORBUTOL','CHLOROBUTANOL',1,'2024-08-10 12:47:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-08-10 16:45:04',NULL), (3,'CHLORBUTOL (IND. USE ONLY)','CHLOROBUTANOL',1,'2024-08-14 19:41:56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'1','1','0','2024-08-17 11:16:53',NULL), (4,'FUROSEMIDE','FUROSEMIDE',6,'2024-08-17 11:18:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'1','1','0','2024-10-04 14:15:34',NULL), (5,'A Alias','A',8,'2024-09-17 15:08:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'36',NULL,NULL,NULL,'0','1','0','2024-09-17 15:08:48',NULL), (6,'DOCUSATE SODIUM','DOCUSATE SODIUM',2,'2024-10-04 11:00:09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-10-04 11:01:25',NULL), (7,'PROPYL GALLATE','PROPYL GALLATE',4,'2024-10-04 11:24:01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-10-04 14:15:02',NULL), (8,'CHLOROBUTANOL','CHLOROBUTANOL',7,'2024-11-05 19:09:07',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-11-06 15:53:10',NULL), (9,'DOCUSATE SODIUM 85%','DOCUSATE SODIUM 85% POWDER',3,'2024-11-12 13:04:29',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'39',NULL,NULL,NULL,'0','1','0','2024-11-12 13:06:08',NULL); /*!40000 ALTER TABLE `aliasproduct` ENABLE KEYS */; -- -- Definition of consumedstock -- DROP TABLE IF EXISTS `consumedstock`; CREATE TABLE IF NOT EXISTS `consumedstock` ( `id` int(11) NOT NULL AUTO_INCREMENT, `batch` varchar(50) DEFAULT NULL, `comprodqty` varchar(50) DEFAULT NULL, `productid` varchar(50) DEFAULT NULL, `comprodid` varchar(50) DEFAULT NULL, `conbatch` varchar(50) DEFAULT NULL, `qty` varchar(50) DEFAULT NULL, `date` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table consumedstock -- /*!40000 ALTER TABLE `consumedstock` DISABLE KEYS */; INSERT INTO `consumedstock`(`id`,`batch`,`comprodqty`,`productid`,`comprodid`,`conbatch`,`qty`,`date`) VALUES (1,'41','10','7','1','16','10','2024-10-16 00:00:00'); /*!40000 ALTER TABLE `consumedstock` ENABLE KEYS */; -- -- Definition of customer -- DROP TABLE IF EXISTS `customer`; CREATE TABLE IF NOT EXISTS `customer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `custname` varchar(255) DEFAULT '', `gstin` varchar(255) DEFAULT '', `custadd` varchar(255) DEFAULT '', `custphone` varchar(255) DEFAULT '', `custemail` varchar(255) DEFAULT '', `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `custdrug` varchar(255) DEFAULT '', `consiadd` varchar(255) DEFAULT '', `consiname` varchar(255) DEFAULT '', `consiemail` varchar(255) DEFAULT '', `consiphone` varchar(255) DEFAULT '', `consigst` varchar(255) DEFAULT '', `considrug` varchar(255) DEFAULT '', `displayname` varchar(255) DEFAULT '', `type` varchar(255) DEFAULT '', `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `custaprstatus` varchar(50) DEFAULT NULL, `custrejstatus` varchar(50) DEFAULT NULL, `custaprtime` datetime DEFAULT NULL, `custrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8; -- -- Dumping data for table customer -- /*!40000 ALTER TABLE `customer` DISABLE KEYS */; INSERT INTO `customer`(`id`,`custname`,`gstin`,`custadd`,`custphone`,`custemail`,`created`,`updated`,`custdrug`,`consiadd`,`consiname`,`consiemail`,`consiphone`,`consigst`,`considrug`,`displayname`,`type`,`userid`,`deletestatus`,`custaprstatus`,`custrejstatus`,`custaprtime`,`custrejtime`) VALUES (1,'ISIS PHARMACEUTICALS AND CHEMICAL WORK','NA','25/1-3, SECTOR 12-C, NORTH KARACHI INDUSTRIAL AREA, KARACHI, PAKISTAN','00','NA','2024-10-04 11:54:02','2024-10-04 12:51:31','NA','','','','','','','ISIS PHARMACEUTICALS AND CHEMICAL WORK','Customer','39','0','1','0','2024-10-04 16:15:02',NULL), (2,'VISHNU AGENCIES','27AAAFV1634M1Z0','129, HINDUSTAN KOHINOOR COMPLEX, L.B.S. MARG, VIKHROLI (W), MUMBAI - 400 083','9820138604','info@laxachem.com','2024-10-04 11:57:57',NULL,'-','','','','','','','VISHNU AGENCIES','Customer','39','0','1','0','2024-10-04 16:16:23',NULL), (3,'SHITAL CHEMICALS','24ACZPP0208N1Z4','2 HIND ESTATE , B/H SUBHMANGAL ROADWAYS , NR SIGNATURE-II , SARKHEJ - SANAND CHAR RASTA SARKHEJ AHMEDABAD - 382210','48962223','''Shital Chemicals'' ','2024-10-04 12:01:17',NULL,'-','','','','','','','SHITAL CHEMICALS','Customer','39','0','1','0','2024-10-04 16:16:20',NULL), (4,'Coastal Medicare Pvt.Ltd.','37AACCC7990G1ZC','RS. NO. 9 / 2 , 5 , RAMCHANDRAPURAM SURAMAPALL Vijaywada,Krishna (Dist) SURAMAPALL - 521212','00','''cmd -'' ','2024-10-04 12:02:54',NULL,'-','','','','','','','Coastal Medicare Pvt.Ltd.','Customer','39','0','1','0','2024-10-04 16:16:18',NULL), (5,'CURETECH SKINCARE','02AAFFC6027J1ZR','PLOT NO 32,33 & 34, PHASE - IV, BHATOLI KALAN, BADDI - 173205','01795275143','''Shivam Thakur'' ','2024-10-04 12:04:18',NULL,'-','','','','','','','CURETECH SKINCARE','Customer','39','0','1','0','2024-10-04 16:16:15',NULL), (6,'DERREN HEALTHCARE PVT. LTD.','24AAGCD8975Q1ZQ','PLOT NO. 33,35/P & 36/P, XCELON IND. PARK BEHIND INTAS PHARMACEUTICALS LTD. SARKHEJ - BAVLA HIGHWAY, VILLAGE VASAN CHANCHARWADI TALUKA - SANAND, DIST. AHMEDABAD - 382213','7926840045','''DERREN ACCOUNTS'' ','2024-10-04 12:05:53',NULL,'-','','','','','','','DERREN HEALTHCARE PVT. LTD.','Customer','39','0','1','0','2024-10-04 16:16:13',NULL), (7,'ANUSHA ASSOCIATES','27AGFPM6892B1Z8','23-YUSUF MANSION , 16-18 DARYASTHAN STREET, VADGADI , MANDVI , MUMBAI-400003','8433889099','sales@anusha.co.in','2024-10-04 12:07:20',NULL,'-','','','','','','','ANUSHA ASSOCIATES','Customer','39','0','1','0','2024-10-04 16:16:11',NULL), (8,'ANOD PHARMA PVT.LTD.','09AACCA0228K1ZV','E-20 INDUSTRIAL AREA, PANKI SITE NO.- 1 KANPUR - 208022.','9794420569','shobhadwivedi@anod.in','2024-10-04 12:08:48',NULL,'-','','','','','','','ANOD PHARMA PVT.LTD.','Customer','39','0','1','0','2024-10-04 16:15:30',NULL), (9,'WENDT-CHEMIE','NA','WENDT-CHEMIE VERTRIEBSGESELLSCHAFT MBH & CO.KG WANDSBEKER ALLEE 72 D-22041 HAMBURG','00','-','2024-10-04 12:10:58',NULL,'-','','','','','','','WENDT-CHEMIE','Customer','39','0','1','0','2024-10-04 16:16:08',NULL), (10,'KHYATI HEALTHCARE PVT. LTD.','27AAICK3762E1ZH','58, JUHU SUPREME SHOPPING CENTRE, GULMOHAR CROSS ROAD NO. 9, JVPD SCHEM JUHU MUMBAI - 400049','9082948572','''Purchase KHPL'' ','2024-10-04 12:12:31',NULL,'-','','','','','','','KHYATI HEALTHCARE PVT. LTD.','Customer','39','0','1','0','2024-10-04 16:15:28',NULL), (11,'NITIN LIFESCIENCES LTD Unit- I','02AACCN0725G1Z3','RAMPUR GHAT ROAD, PAONTA SAHIB, DISTT. SIRMOUR (H.P) - 173025','9992113865','''Ravi Sharma'' ','2024-10-04 12:14:30',NULL,'-','','','','','','','NITIN LIFESCIENCES LTD Unit- I','Customer','39','0','1','0','2024-10-04 16:16:06',NULL), (12,'TAMMAN TITOE PHARMA PVT. LTD.','33AABCT9235A1ZQ','56-57 , SIDCO PHARMACEUTICAL COMPLEX ALATHUR CHENGALPATTU DISTRICT THIRUPORUR - 603110','9080945532','admin1@tammantitoepharma.in','2024-10-04 12:16:27',NULL,'-','','','','','','','TAMMAN TITOE PHARMA PVT. LTD.','Customer','39','0','1','0','2024-10-04 16:15:25',NULL), (13,'NATIONAL LABORATORIES UNIT-II','02AACFN3342E2ZX','VILLAGE -MANPURA OFF BADDI NALAGARH HIGHWAY DIST SOLAN MANPURA BADDI-174101','01795236924','National Laboratories ','2024-10-04 12:19:08',NULL,'MNB/16/925 & MB/16/926','','','','','','','NATIONAL LABORATORIES UNIT-II','Customer','39','0','1','0','2024-10-04 16:16:03',NULL), (14,'FDC LIMITED, JOGESHWARI,CORP','27AAACF0253H1Z0','142-148,S.V.ROAD,JOGESHWARI (W), MUMBAI - 400102','91','sandeep.naik@fdcindia.com','2024-10-04 12:20:57',NULL,'123-A, 72-A,1796-A, 1642-A','','','','','','','FDC LIMITED, JOGESHWARI,CORP','Customer','39','0','1','0','2024-10-04 16:15:20',NULL), (15,'ELKO ORGANIZATION (PVT) LTD.','NA','PLOT NO. 27 & 28 , SECTOR 12-B NORTH KARACHI INDUSTRIAL AREA, KARACHI PAKISTAN','00','-','2024-10-04 12:24:16',NULL,'-','','','','','','','ELKO ORGANIZATION (PVT) LTD.','Customer','39','0','1','0','2024-10-04 16:15:16',NULL), (16,'STAR LABORATORIES (PVT) LTD.','na','23 KM, MULTAN ROAD, (CHUNG) LAHORE - 53800, PAKISTAN','00','-','2024-10-04 12:25:05',NULL,'-','','','','','','','STAR LABORATORIES (PVT) LTD.','Customer','39','0','1','0','2024-10-04 16:15:58',NULL), (17,'LAWRENCE PHARMA PVT. LTD.','NA','193, CIRCULAR ROAD,2ND FLOOR BILAL MARKET CHOWK NEW ANARKALI LAHORE','00','-','2024-10-04 12:28:17',NULL,'-','','','','','','','LAWRENCE PHARMA PVT. LTD.','Customer','39','0','1','0','2024-10-04 16:15:13',NULL), (18,'S D FINE-CHEM LTD.','27AAACS5421L1ZA','E-27/28, MIDC, TARAPUR INDUSTRIAL AREA, PALGHAR, B-ROAD , BOISAR - 401506','24814444','purcor1@sdfine.com ','2024-10-04 12:34:32',NULL,'-','','','','','','','S D FINE-CHEM LTD.','Customer','39','0','1','0','2024-10-04 16:15:52',NULL), (19,'GEMINI EXPORTS','27AAAFG3731E1ZU','A-704, MARATHON FUTUREX, 7TH FLOOR, MAFATLAL MILL COMPOUND, N.M JOSHI MARG, LOWER PAREL, MUMBAI - 400013','9321294824','''Vijay'' ','2024-10-04 12:39:13',NULL,'20B ZONE. MH-MZ2-397910','','','','','','','GEMINI EXPORTS','Customer','39','0','1','0','2024-10-04 16:15:11',NULL), (20,'AKUMS DRUGS & PHARMACEUTICALS LTD','05AAECA7090B1Z2','PLOT NO.47, SECTOR 6A, I.I.E. SIDCUL, RANIPUR HARIDWAR - 249403','01334239947','''Raman Kapoor'' ','2024-10-04 12:41:12',NULL,'-','','','','','','','AKUMS DRUGS & PHARMACEUTICALS LTD','Customer','39','0','1','0','2024-10-04 16:15:55',NULL), (21,'VCARE MEDICINES','27AEKPB3528C1ZX','UNIT C/13 , 1 ST FLOOR , SHREERAM IND. ESTATE G.D. AMBEKAR ROAD WADALA (W) ,','9820899844','''vcare medicines'' ','2024-10-04 12:43:04',NULL,'-','','','','','','','VCARE MEDICINES','Customer','39','0','1','0','2024-10-04 16:15:06',NULL), (22,'OCTAVIUS PHARMA PVT. LTD.','24AAACO8145P1Z1','407/A, 4TH FLR, PRIMATE HOUSE OPP. MOTHER MILK PALACE NR. JUDGES BUNGLOWS CROSS ROAD, BODAKDEV, AHMEDABAD - 380015','9099932526','purchase@octaviuspharma.com','2024-10-04 12:45:03',NULL,'-','','','','','','','OCTAVIUS PHARMA PVT. LTD.','Customer','39','0','1','0','2024-10-04 16:15:39',NULL), (23,'ZEE LABORATORIES LIMITED','02AAACZ1397A1ZR','BEHIND 47-IND. AREA , GONDPUR PAONTA SAHIB - 173025 (HP) CON. PER.:- MR. HARVINDER SINGH','9816628377','''Kiran Waghela'' ','2024-10-25 18:50:12',NULL,'NA','','','','','','','ZEE LABORATORIES LIMITED','Customer','39','0','1','0','2024-10-25 18:50:58',NULL), (24,'SANJAY CHEMICALS','27AAPPS5000F1ZQ','277/2, BHAVESHWAR VILLA ROAD NO.31, SCHEME NO. 6, SION (E) MUMBAI - 400022','912249743721','''Vaibhav Shah'' ','2024-10-25 18:54:32',NULL,'NA','','','','','','','SANJAY CHEMICALS','Customer','39','0','1','0','2024-10-25 18:54:47',NULL), (25,'BELL PHARMA PVT. LTD.','27AABCB1393H1ZS','BELL HOUSE 75/C, GOVT. INDUSTRIAL ESTATE KANDIVALLI(W) MUMBAI-400067','24332473','bellpharma1958@yahoo.co.in','2024-10-25 19:11:01',NULL,'-','','','','','','','BELL PHARMA PVT. LTD.','Customer','39','0','1','0','2024-10-25 19:11:39',NULL); /*!40000 ALTER TABLE `customer` ENABLE KEYS */; -- -- Definition of discardedstock -- DROP TABLE IF EXISTS `discardedstock`; CREATE TABLE IF NOT EXISTS `discardedstock` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product` varchar(50) DEFAULT NULL, `batch` varchar(50) DEFAULT NULL, `quantity` varchar(50) DEFAULT NULL, `date` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table discardedstock -- /*!40000 ALTER TABLE `discardedstock` DISABLE KEYS */; /*!40000 ALTER TABLE `discardedstock` ENABLE KEYS */; -- -- Definition of dispatch -- DROP TABLE IF EXISTS `dispatch`; CREATE TABLE IF NOT EXISTS `dispatch` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lotno` varchar(255) DEFAULT '', `distype` varchar(255) DEFAULT '', `dod` date DEFAULT NULL, `bob` varchar(255) DEFAULT '', `dob` date DEFAULT NULL, `customer` varchar(255) DEFAULT NULL, `invoice` varchar(255) DEFAULT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `disaprstatus` varchar(50) DEFAULT NULL, `disrejstatus` varchar(50) DEFAULT NULL, `disaprtime` datetime DEFAULT NULL, `disrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8; -- -- Dumping data for table dispatch -- /*!40000 ALTER TABLE `dispatch` DISABLE KEYS */; INSERT INTO `dispatch`(`id`,`lotno`,`distype`,`dod`,`bob`,`dob`,`customer`,`invoice`,`created`,`updated`,`userid`,`deletestatus`,`disaprstatus`,`disrejstatus`,`disaprtime`,`disrejtime`) VALUES (1,'1','Export','2024-08-18 00:00:00','237','2024-08-18 00:00:00','1','EXP 20','2024-10-05 11:01:47',NULL,'39','0','1','0','2024-10-16 12:31:52',NULL), (2,'3','Local','2024-10-18 00:00:00','SPECIAL TRUCK','2024-10-18 00:00:00','2','130','2024-10-16 12:11:22',NULL,'39','0','1','0','2024-10-16 12:31:57',NULL), (3,'5','Local','2024-08-21 00:00:00','24128023','2024-08-22 00:00:00','3','133','2024-10-16 12:13:57',NULL,'39','0','1','0','2024-10-16 12:31:54',NULL), (4,'4','Local','2024-08-21 00:00:00','24128022','2024-08-22 00:00:00','4','134','2024-10-16 12:15:47',NULL,'39','0','1','0','2024-10-16 12:31:59',NULL), (5,'8','Local','2024-08-23 00:00:00','CM560034963IN','2024-08-24 00:00:00','5','137','2024-10-16 12:17:34',NULL,'39','0','1','0','2024-10-16 12:32:04',NULL), (6,'15','Local','2024-08-23 00:00:00','274210005862','2024-08-23 00:00:00','6','139','2024-10-16 12:19:49',NULL,'39','0','1','0','2024-10-16 12:32:02',NULL), (7,'7','Local','2024-09-17 00:00:00','767699111','2024-09-17 00:00:00','7','155','2024-10-16 12:21:59',NULL,'39','0','1','0','2024-10-16 12:32:06',NULL), (8,'14','Local','2024-09-08 00:00:00','274210005975','2024-09-09 00:00:00','8','150','2024-10-16 12:23:58',NULL,'39','0','1','0','2024-10-16 12:32:09',NULL), (9,'13','Local','2024-09-17 00:00:00','SPECIAL TRUCK','2024-09-17 00:00:00','2','157','2024-10-16 12:25:50',NULL,'39','0','1','0','2024-10-16 12:32:11',NULL), (10,'6','Export','2024-09-20 00:00:00','SPECIAL TRUCK','2024-09-20 00:00:00','9','EXP/26/2024-25','2024-10-16 12:40:03','2024-10-16 12:48:38','39','-1','1','0','2024-10-22 13:11:21',NULL), (11,'16','Export','2024-09-20 00:00:00','SPECIAL TRUCK','2024-09-20 00:00:00','9','EXP/26/2024-25','2024-10-16 12:49:41',NULL,'39','0','1','0','2024-10-22 13:11:43',NULL), (12,'17','Local','2024-09-20 00:00:00','SPECIAL TRUCK','2024-09-20 00:00:00','9','\tEXP/26/2024-25','2024-10-16 12:50:21',NULL,'39','0','1','0','2024-10-22 13:11:23',NULL), (13,'33','Export','2024-09-20 00:00:00','SPECIAL TRUCK','2024-09-20 00:00:00','9','EXP/26/2024-25','2024-10-16 12:53:33',NULL,'39','0','1','0','2024-10-22 13:11:25',NULL), (14,'18','Export','2024-09-07 00:00:00','BLRB007573','2024-09-20 00:00:00','15','EXP/22/2024-25','2024-10-16 13:00:17',NULL,'39','0','1','0','2024-10-22 13:11:45',NULL), (15,'10','Local','2024-09-17 00:00:00','24128090','2024-09-17 00:00:00','2','157','2024-10-16 13:02:34',NULL,'39','0','1','0','2024-10-22 13:11:48',NULL), (16,'39','Local','2024-09-10 00:00:00','767698444','2024-09-10 00:00:00','11','152','2024-10-16 13:34:14',NULL,'39','0','1','0','2024-10-22 13:11:51',NULL), (17,'34','Local','2024-09-18 00:00:00','910108865','2024-09-19 00:00:00','12','158','2024-10-16 13:35:44',NULL,'39','0','1','0','2024-10-22 13:11:53',NULL), (18,'35','Local','2024-09-24 00:00:00','767699763','2024-09-24 00:00:00','13','159','2024-10-16 13:37:35',NULL,'39','0','1','0','2024-10-22 13:11:55',NULL), (19,'36','Local','2024-09-24 00:00:00','767699774','2024-09-24 00:00:00','14','160','2024-10-16 13:38:51',NULL,'39','0','1','0','2024-10-22 13:11:35',NULL), (20,'40','Export','2024-09-25 00:00:00','SPECIAL TRUCK','2024-09-25 00:00:00','16','EXP/27/2024-25','2024-10-16 13:49:56',NULL,'39','0','1','0','2024-10-22 13:11:33',NULL), (21,'41','Export','2024-09-25 00:00:00','SPECIAL TRUCK','0024-09-25 00:00:00','16','EXP/27/2024-25','2024-10-16 13:54:51',NULL,'39','0','1','0','2024-10-22 13:11:31',NULL), (22,'42','Export','2024-09-25 00:00:00','SPECIAL TRUCK','2024-09-25 00:00:00','16','\tEXP/27/2024-25','2024-10-16 13:56:00',NULL,'39','0','1','0','2024-10-22 13:11:29',NULL), (23,'43','Export','2024-09-25 00:00:00','SPECIAL TRUCK','2024-09-25 00:00:00','16','\tEXP/27/2024-25','2024-10-16 13:57:00',NULL,'39','0','1','0','2024-10-22 13:11:57',NULL), (24,'24','Local','2024-10-06 00:00:00','SPECIAL TUCK','2024-10-06 00:00:00','2','169','2024-10-16 13:58:18',NULL,'39','0','1','0','2024-10-22 13:11:58',NULL), (25,'44','Export','2024-09-28 00:00:00','SPECIAL TRUCK','2024-09-28 00:00:00','17','EXP/28/2024-25','2024-10-16 13:59:34','2024-10-25 19:02:56','39','0','1','0','2024-10-25 19:03:09',NULL), (26,'45','Local','2024-10-20 00:00:00','24128161','2024-10-20 00:00:00','7','187','2024-10-22 12:51:15',NULL,'39','0','1','0','2024-10-22 13:12:02',NULL), (27,'52','Local','2024-09-06 00:00:00','764956076','2024-09-06 00:00:00','10','148','2024-10-22 13:19:16',NULL,'39','0','1','0','2024-10-22 13:20:34',NULL), (28,'6','Export','2024-09-20 00:00:00','SPECIAL TRUCK','2024-09-20 00:00:00','9','EXP/26/2024-25','2024-10-22 13:29:42',NULL,'39','1','1','0','2024-10-22 13:31:54',NULL), (29,'6','Export','2024-09-20 00:00:00','SPECIAL TRUCK','2024-09-20 00:00:00','9','EXP/26/2024-25','2024-10-24 14:00:17',NULL,'39','1','1','0','2024-10-24 14:14:05',NULL), (30,'6','Export','2024-09-20 00:00:00','SPECIAL TRUCK','2024-09-20 00:00:00','9','\tEXP/26/2024-25','2024-10-24 14:15:27',NULL,'39','1','1','0','2024-10-24 14:16:41',NULL), (31,'37','Local','2024-10-09 00:00:00','789564268','2024-10-09 00:00:00','3','174','2024-10-25 18:48:01',NULL,'39','0','1','0','2024-10-25 18:50:56',NULL), (32,'38','Local','2024-10-09 00:00:00','767701034','2024-10-10 00:00:00','23','176','2024-10-25 18:52:11',NULL,'39','0','1','0','2024-10-25 18:54:50',NULL), (33,'28','Local','2024-10-09 00:00:00','274210006344','2024-10-09 00:00:00','24','172','2024-10-25 18:56:03',NULL,'39','0','1','0','2024-10-25 18:57:36',NULL), (34,'48','Local','2024-10-22 00:00:00','24128165','2024-10-22 00:00:00','2','190','2024-10-25 19:07:22',NULL,'39','0','1','0','2024-10-25 19:11:36',NULL), (35,'49','Local','2024-10-22 00:00:00','24128165','2024-10-22 00:00:00','2','190','2024-10-25 19:08:36',NULL,'39','0','1','0','2024-10-25 19:11:38',NULL); /*!40000 ALTER TABLE `dispatch` ENABLE KEYS */; -- -- Definition of generateqr -- DROP TABLE IF EXISTS `generateqr`; CREATE TABLE IF NOT EXISTS `generateqr` ( `id` int(11) NOT NULL AUTO_INCREMENT, `presetid` varchar(255) DEFAULT '', `genid` varchar(255) DEFAULT '', `title` varchar(255) DEFAULT '', `aliasproductid` varchar(255) DEFAULT '', `name` varchar(255) DEFAULT '', `formula1` varchar(255) DEFAULT '', `batch` varchar(255) DEFAULT '', `molwt` varchar(255) DEFAULT '', `grosswt` varchar(255) DEFAULT '', `tarewt` varchar(255) DEFAULT '', `netwt` varchar(255) DEFAULT '', `mfgdate` date DEFAULT NULL, `expdate` date DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `manuid` varchar(255) DEFAULT '', `contfrom` varchar(255) DEFAULT '', `contto` varchar(255) DEFAULT '', `contno` varchar(255) DEFAULT '', `grade` varchar(255) DEFAULT '', `pack` varchar(255) DEFAULT '', `ncont` varchar(255) DEFAULT '', `qrqty` varchar(255) DEFAULT '', `totalqty` varchar(255) DEFAULT '', `dispatch` varchar(255) DEFAULT '0', `returnst` varchar(255) DEFAULT '0', `aprstatus` varchar(255) DEFAULT '0', `qrrejstatus` varchar(255) DEFAULT '0', `lotdisaprstatus` varchar(255) DEFAULT '0', `lotdisrejstatus` varchar(255) DEFAULT '0', `lotcreatedate` date DEFAULT NULL, `qraprtime` datetime DEFAULT NULL, `qrrejtime` datetime DEFAULT NULL, `storagecon` varchar(255) DEFAULT NULL, `storageconid` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8; -- -- Dumping data for table generateqr -- /*!40000 ALTER TABLE `generateqr` DISABLE KEYS */; INSERT INTO `generateqr`(`id`,`presetid`,`genid`,`title`,`aliasproductid`,`name`,`formula1`,`batch`,`molwt`,`grosswt`,`tarewt`,`netwt`,`mfgdate`,`expdate`,`userid`,`manuid`,`contfrom`,`contto`,`contno`,`grade`,`pack`,`ncont`,`qrqty`,`totalqty`,`dispatch`,`returnst`,`aprstatus`,`qrrejstatus`,`lotdisaprstatus`,`lotdisrejstatus`,`lotcreatedate`,`qraprtime`,`qrrejtime`,`storagecon`,`storageconid`) VALUES (1,'1','LAX/0824/001','','1','','','4','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','20','','500','1','0','1','0','1','0','2024-08-11 00:00:00','2024-08-11 16:16:38',NULL,'In an air tight container',NULL), (2,'6','LAX/0824/002','','4','','','9','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','8','','200','0','0','1','0','0','0','2024-08-17 00:00:00','2024-08-17 11:28:08',NULL,'Store protect from moisture and light',NULL), (3,'1','LAX/0824/003','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','12','','300','1','0','1','0','1','0','2024-08-17 00:00:00','2024-08-17 13:24:01',NULL,'Store protect from moisture at temperature not exceeding 30° C',NULL), (4,'1','LAX/0824/004','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','2','','50','1','0','1','0','1','0','2024-08-21 00:00:00','2024-08-21 11:49:27',NULL,'Store protect from moisture at temperature not exceeding 30° C',NULL), (5,'1','LAX/0824/005','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','1','0','1','0','1','0','2024-08-21 00:00:00','2024-08-21 11:49:45',NULL,'Store protect from moisture at temperature not exceeding 30° C',NULL), (6,'1','LAX/0824/006','','1','','','6','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','0','0','1','0','1','0','2024-08-24 00:00:00','2024-08-24 15:54:41',NULL,'Preserve in tight container',NULL), (7,'1','LAX/0924/007','','2','','','5','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','4','','100','1','0','1','0','1','0','2024-09-14 00:00:00','2024-09-14 15:55:28',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (8,'1','LAX/0924/008','','2','','','5','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','1','','5','1','0','1','0','1','0','2024-09-14 00:00:00','2024-09-14 15:56:17',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (10,'1','LAX/0924/009','','2','','','11','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','40','','200','1','0','1','0','1','0','2024-09-14 00:00:00','2024-09-14 17:43:26',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (11,'1','LAX/0924/011','','2','','','10','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','25','20','','500','0','0','1','0','0','0','2024-09-14 00:00:00','2024-09-14 17:48:47',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (12,'8','LAX/0924/012','','5','','','12','','','','5','2024-10-01 00:00:00','2026-07-01 00:00:00','36','0','','','','IP','5','4','','20','0','0','1','0','0','0','2024-09-17 00:00:00','2024-09-17 15:10:00',NULL,'A IP STORAGE','5'), (13,'1','LAX/1024/013','','2','','','5','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','1','','5','1','0','1','0','1','0','2024-10-03 00:00:00','2024-10-04 14:08:00',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (14,'1','LAX/1024/014','','2','','','5','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','2','','10','1','0','1','0','1','0','2024-10-03 00:00:00','2024-10-04 14:35:47',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (15,'1','LAX/1024/015','','2','','','5','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','1','','5','1','0','1','0','1','0','2024-10-03 00:00:00','2024-10-04 14:35:25',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (16,'1','LAX/1024/016','','1','','','7','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','1','0','1','0','1','0','2024-10-03 00:00:00','2024-10-04 14:35:07',NULL,'Preserve in tight container','4'), (17,'1','LAX/1024/017','','1','','','8','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','1','0','1','0','1','0','2024-10-03 00:00:00','2024-10-04 14:34:35',NULL,'Preserve in tight container','4'), (18,'1','LAX/1024/018','','1','','','11','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','12','','300','1','0','1','0','1','0','2024-10-03 00:00:00','2024-10-04 14:34:10',NULL,'In an air tight container','1'), (20,'2','LAX/1024/020','','6','','','24','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-10-04 00:00:00','2024-10-05 11:53:21',NULL,'Store protect from moisture','8'), (22,'2','LAX/1024/022','','6','','','13','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','25','1','','25','0','0','1','0','0','0','2024-10-05 00:00:00','2024-10-05 11:52:45',NULL,'Preserve in well closed container','11'), (24,'1','LAX/1024/023','','2','','','35','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','25','12','','300','1','0','1','0','1','0','2024-10-05 00:00:00','2024-10-05 12:03:41',NULL,'Store protect from moisture at temperature not exceeding 30° C','2'), (26,'2','LAX/1024/025','','6','','','13','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','25','1','','25','0','0','1','0','0','0','2024-10-05 00:00:00','2024-10-05 18:08:30',NULL,'Preserve in well closed container','11'), (27,'2','LAX/1024/027','','6','','','24','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','1','','25','0','0','1','0','0','0','2024-10-08 00:00:00','2024-10-08 14:04:37',NULL,'In an air tight container','9'), (28,'1','LAX/1024/028','','1','','','16','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','5','1','','5','1','0','1','0','1','0','2024-10-08 00:00:00','2024-10-08 17:07:55',NULL,'In an air tight container','1'), (29,'2','LAX/1024/029','','6','','','24','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','2','','50','0','0','1','0','0','0','2024-10-09 00:00:00','2024-10-09 17:20:55',NULL,'Store protect from moisture','8'), (30,'2','LAX/1024/030','','6','','','24','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-10-09 00:00:00','2024-10-09 18:08:36',NULL,'Store protect from moisture','8'), (31,'2','LAX/1024/031','','6','','','13','','','','5','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','5','1','','5','0','0','1','0','0','0','2024-10-15 00:00:00','2024-10-15 12:03:20',NULL,'Preserve in well closed container','11'), (32,'2','LAX/1024/032','','6','','','13','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','25','9','','225','0','0','1','0','0','0','2024-10-15 00:00:00','2024-10-15 12:03:31',NULL,'Preserve in well closed container','11'), (33,'1','LAX/1024/033','','1','','','15','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP,USP','25','20','','500','1','0','1','0','1','0','2024-10-16 00:00:00','2024-10-16 12:52:16',NULL,'Preserve in tight container','4'), (34,'1','LAX/1024/034','','2','','','16','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','5','2','','10','1','0','1','0','1','0','2024-10-16 00:00:00','2024-10-16 13:27:23',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (35,'1','LAX/1024/035','','2','','','16','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','1','0','1','0','1','0','2024-10-16 00:00:00','2024-10-16 13:27:29',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (36,'1','LAX/1024/036','','2','','','16','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','1','0','1','0','1','0','2024-10-16 00:00:00','2024-10-16 13:27:25',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (37,'1','LAX/1024/037','','2','','','16','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','1','0','1','0','1','0','2024-10-16 00:00:00','2024-10-16 13:27:30',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (38,'1','LAX/1024/038','','2','','','16','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','2','','50','1','0','1','0','1','0','2024-10-16 00:00:00','2024-10-16 13:27:32',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (39,'1','LAX/1024/039','','1','','','16','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','14','','350','1','0','1','0','1','0','2024-10-16 00:00:00','2024-10-16 13:30:57',NULL,'In an air tight container','1'), (40,'1','LAX/1024/040','','1','','','17','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','1','0','1','0','1','0','2024-10-16 00:00:00','2024-10-16 13:46:12',NULL,'In an air tight container','1'), (41,'1','LAX/1024/041','','1','','','19','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','1','0','1','0','1','0','2024-10-16 00:00:00','2024-10-16 13:46:14',NULL,'In an air tight container','1'), (42,'1','LAX/1024/042','','1','','','20','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','1','0','1','0','1','0','2024-10-16 00:00:00','2024-10-16 13:46:15',NULL,'In an air tight container','1'), (43,'1','LAX/1024/043','','1','','','21','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','1','0','1','0','1','0','2024-10-16 00:00:00','2024-10-16 13:46:17',NULL,'In an air tight container','1'), (44,'1','LAX/1024/044','','1','','','23','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','1','0','1','0','1','0','2024-10-16 00:00:00','2024-10-16 13:46:18',NULL,'In an air tight container','1'), (45,'1','LAX/1024/045','','2','','','35','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','25','8','','200','1','0','1','0','1','0','2024-10-18 00:00:00','2024-10-18 13:31:15',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (46,'2','LAX/1024/046','','6','','','13','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','USP','25','1','','25','0','0','1','0','0','0','2024-10-18 00:00:00','2024-10-18 13:31:26',NULL,'Preserve in well closed container','11'), (47,'2','LAX/1024/047','','6','','','24','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','EP','25','9','','225','0','0','1','0','0','0','2024-10-18 00:00:00','2024-10-18 13:31:37',NULL,'In an air tight container','10'), (48,'1','LAX/1024/048','','2','','','25','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','25','14','','350','1','0','1','0','1','0','2024-10-19 00:00:00','2024-10-19 12:00:50',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (49,'1','LAX/1024/049','','2','','','25','','','','5','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','5','20','','100','1','0','1','0','1','0','2024-10-19 00:00:00','2024-10-19 12:01:04',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (51,'2','LAX/1024/051','','6','','','24','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','EP','5','2','','10','0','0','1','0','0','0','2024-10-20 00:00:00','2024-10-22 11:28:00',NULL,'In an air tight container','10'), (52,'1','LAX/1024/052','','1','','','14','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','USP','25','20','','500','1','0','1','0','1','0','2024-10-22 00:00:00','2024-10-22 13:17:09',NULL,'Preserve in tight container','4'), (53,'1','LAX/1024/053','','2','','','25','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','25','2','','50','0','0','1','0','0','0','2024-10-22 00:00:00','2024-10-22 15:53:32',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (55,'2','LAX/1024/055','','6','','','24','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-10-23 00:00:00','2024-10-23 12:22:33',NULL,'Store protect from moisture','8'), (56,'1','LAX/1024/056','','2','','','26','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','25','4','','100','0','0','1','0','0','0','2024-10-24 00:00:00','2024-10-24 17:42:56',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (57,'1','LAX/1024/057','','1','','','26','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','3','','75','0','0','1','0','0','0','2024-10-24 00:00:00','2024-10-24 17:43:00',NULL,'In an air tight container','1'), (58,'1','LAX/1024/058','','2','','','26','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','25','12','','300','0','0','1','0','0','0','2024-10-24 00:00:00','2024-10-24 17:43:08',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (59,'1','LAX/1024/059','','1','','','27','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-10-25 00:00:00','2024-10-25 17:32:58',NULL,'In an air tight container','1'), (60,'1','LAX/1024/060','','1','','','28','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','BP','25','20','','500','0','0','1','0','0','0','2024-10-25 00:00:00','2024-10-25 17:32:56',NULL,'In an air tight container','1'), (61,'2','LAX/1024/061','','6','','','31','','','','25','2024-11-01 00:00:00','2029-10-01 00:00:00','39','0','','','','USP','25','7','','175','0','0','1','0','0','0','2024-10-25 00:00:00','2024-10-25 17:37:05',NULL,'Preserve in well closed container','11'), (62,'1','LAX/1024/062','','2','','','26','','','','25','2024-10-01 00:00:00','2029-09-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-10-27 00:00:00','2024-10-27 12:32:57',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (63,'1','LAX/1024/063','','2','','','36','','','','25','2024-11-01 00:00:00','2029-10-01 00:00:00','39','0','','','','IP','25','20','','500','0','0','1','0','0','0','2024-10-30 00:00:00','2024-10-30 18:36:57',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (64,'2','LAX/1024/064','','6','','','24','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','25','1','','25','0','0','1','0','0','0','2024-10-31 00:00:00','2024-10-31 12:31:47',NULL,'In an air tight container','9'), (65,'1','LAX/1124/065','','2','','','40','','','','25','2024-12-01 00:00:00','2029-11-01 00:00:00','39','0','','','','IP','25','2','','50','0','0','1','0','0','0','2024-11-06 00:00:00','2024-11-07 11:09:48',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (66,'2','LAX/1124/066','','6','','','24','','','','25','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-11-06 00:00:00','2024-11-07 11:10:00',NULL,'Store protect from moisture','8'), (67,'1','LAX/1124/067','','1','','','37','','','','25','2024-11-01 00:00:00','2029-10-01 00:00:00','39','0','','','','USP','25','4','','100','0','0','1','0','0','0','2024-11-06 00:00:00','2024-11-07 11:10:17',NULL,'Preserve in tight container','4'), (68,'1','LAX/1124/068','','2','','','40','','','','25','2024-12-01 00:00:00','2029-11-01 00:00:00','39','0','','','','IP','25','1','','25','0','0','1','0','0','0','2024-11-06 00:00:00','2024-11-07 11:10:29',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (69,'7','LAX/1124/069','','8','','','39','','','','25','2024-11-01 00:00:00','2029-10-01 00:00:00','39','0','','','','BP','25','1','','25','0','0','1','0','0','0','2024-11-06 00:00:00','2024-11-07 11:10:44',NULL,'In an air tight container','13'), (70,'2','LAX/1124/070','','6','','','24','','','','5','2024-09-01 00:00:00','2029-08-01 00:00:00','39','0','','','','BP','5','1','','5','0','0','1','0','0','0','2024-11-06 00:00:00','2024-11-07 11:10:53',NULL,'In an air tight container','9'), (71,'1','LAX/1124/071','','1','','','37','','','','25','2024-11-01 00:00:00','2029-10-01 00:00:00','39','0','','','','BP','25','2','','50','0','0','1','0','0','0','2024-11-06 00:00:00','2024-11-07 11:11:07',NULL,'In an air tight container','1'), (72,'1','LAX/1124/072','','2','','','40','','','','5','2024-12-01 00:00:00','2029-11-01 00:00:00','39','0','','','','IP','5','1','','5','0','0','1','0','0','0','2024-11-07 00:00:00','2024-11-07 17:01:25',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (73,'1','LAX/1124/073','','1','','','37','','','','5','2024-11-01 00:00:00','2029-10-01 00:00:00','39','0','','','','BP','5','1','','5','0','0','1','0','0','0','2024-11-10 00:00:00','2024-11-10 17:05:26',NULL,'In an air tight container','1'), (74,'7','LAX/1124/074','','8','','','41','','','','25','2024-11-01 00:00:00','2029-10-01 00:00:00','39','0','','','','USP','25','1','','25','0','0','1','0','0','0','2024-11-10 00:00:00','2024-11-10 17:05:47',NULL,'Preserve in tight container','14'), (75,'1','LAX/1124/075','','1','','','37','','','','25','2024-11-01 00:00:00','2029-10-01 00:00:00','39','0','','','','BP','25','4','','100','0','0','1','0','0','0','2024-11-12 00:00:00','2024-11-12 14:34:23',NULL,'In an air tight container','1'), (76,'1','LAX/1124/076','','2','','','40','','','','25','2024-12-01 00:00:00','2029-11-01 00:00:00','39','0','','','','IP','25','2','','50','0','0','1','0','0','0','2024-11-12 00:00:00','2024-11-12 14:34:39',NULL,'Store protect from moisture at temperature not exceeding 30°C','2'), (77,'2','LAX/1124/077','','6','','','32','','','','25','2024-11-01 00:00:00','2029-10-01 00:00:00','39','0','','','','BP','25','4','','100','0','0','1','0','0','0','2024-11-12 00:00:00','2024-11-12 14:35:19',NULL,'In an air tight container','9'), (78,'3','LAX/1124/078','','9','','','43','','','','25','2024-12-01 00:00:00','2029-11-01 00:00:00','39','0','','','','In-House','25','20','','500','0','0','1','0','0','0','2024-11-12 00:00:00','2024-11-12 16:41:28',NULL,'Preserve in well closed container','15'), (79,'3','LAX/1124/079','','9','','','44','','','','25','2024-12-01 00:00:00','2029-11-01 00:00:00','39','0','','','','In-House','25','10','','250','0','0','1','0','0','0','2024-11-12 00:00:00','2024-11-12 16:41:35',NULL,'Preserve in well closed container','15'), (80,'1','LAX/1124/080','','1','','','45','','','','25','2024-12-01 00:00:00','2029-11-01 00:00:00','39','0','','','','BP','25','12','','300','0','0','1','0','0','0','2024-11-12 00:00:00','2024-11-12 17:17:57',NULL,'In an air tight container','1'); /*!40000 ALTER TABLE `generateqr` ENABLE KEYS */; -- -- Definition of generateqrsr -- DROP TABLE IF EXISTS `generateqrsr`; CREATE TABLE IF NOT EXISTS `generateqrsr` ( `id` int(11) NOT NULL AUTO_INCREMENT, `contno` varchar(1000) DEFAULT '', `qrid` varchar(1000) DEFAULT '', `tarewt` varchar(1000) DEFAULT '', `grosswt` varchar(1000) DEFAULT '', `uninum` text, `sscc` text, `fdigit` varchar(50) DEFAULT NULL, `preview` varchar(50) DEFAULT NULL, `ssccrs` varchar(50) DEFAULT '0', `qrsrtqty` varchar(50) DEFAULT '0', `batchid` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=666 DEFAULT CHARSET=utf8; -- -- Dumping data for table generateqrsr -- /*!40000 ALTER TABLE `generateqrsr` DISABLE KEYS */; INSERT INTO `generateqrsr`(`id`,`contno`,`qrid`,`tarewt`,`grosswt`,`uninum`,`sscc`,`fdigit`,`preview`,`ssccrs`,`qrsrtqty`,`batchid`) VALUES (1,'1/20','1','2.2','27.2','001','089061816400090011','0','0','0','25','4'), (2,'2/20','1','2.2','27.2','002','089061816400090020','0','0','0','25','4'), (3,'3/20','1','2.2','27.2','003','089061816400090039','0','0','0','25','4'), (4,'4/20','1','2.2','27.2','004','089061816400090048','0','0','0','25','4'), (5,'5/20','1','2.2','27.2','005','089061816400090057','0','0','0','25','4'), (6,'6/20','1','2.2','27.2','006','089061816400090066','0','0','0','25','4'), (7,'7/20','1','2.2','27.2','007','089061816400090075','0','0','0','25','4'), (8,'8/20','1','2.2','27.2','008','089061816400090084','0','0','0','25','4'), (9,'9/20','1','2.2','27.2','009','089061816400090093','0','0','0','25','4'), (10,'10/20','1','2.2','27.2','010','089061816400090109','0','0','0','25','4'), (11,'11/20','1','2.2','27.2','011','089061816400090118','0','0','0','25','4'), (12,'12/20','1','2.2','27.2','012','089061816400090127','0','0','0','25','4'), (13,'13/20','1','2.2','27.2','013','089061816400090136','0','0','0','25','4'), (14,'14/20','1','2.2','27.2','014','089061816400090145','0','0','0','25','4'), (15,'15/20','1','2.2','27.2','015','089061816400090154','0','0','0','25','4'), (16,'16/20','1','2.2','27.2','016','089061816400090163','0','0','0','25','4'), (17,'17/20','1','2.2','27.2','017','089061816400090172','0','0','0','25','4'), (18,'18/20','1','2.2','27.2','018','089061816400090181','0','0','0','25','4'), (19,'19/20','1','2.2','27.2','019','089061816400090190','0','0','0','25','4'), (20,'20/20','1','2.2','27.2','020','089061816400090206','0','0','0','25','4'), (21,'1/8','2','4.25','29.25','001','089061816400540011','0','0','0','25','9'), (22,'2/8','2','4.25','29.25','002','089061816400540020','0','0','0','25','9'), (23,'3/8','2','4.25','29.25','003','089061816400540039','0','0','0','25','9'), (24,'4/8','2','4.25','29.25','004','089061816400540048','0','0','0','25','9'), (25,'5/8','2','4.25','29.25','005','089061816400540057','0','0','0','25','9'), (26,'6/8','2','4.25','29.25','006','089061816400540066','0','0','0','25','9'), (27,'7/8','2','4.25','29.25','007','089061816400540075','0','0','0','25','9'), (28,'8/8','2','4.25','29.25','008','089061816400540084','0','0','0','25','9'), (29,'1/12','3','2.8','27.8','021','089061816400090215','0','0','0','25','5'), (30,'2/12','3','2.8','27.8','022','089061816400090224','0','0','0','25','5'), (31,'3/12','3','2.8','27.8','023','089061816400090233','0','0','0','25','5'), (32,'4/12','3','2.8','27.8','024','089061816400090242','0','0','0','25','5'), (33,'5/12','3','2.8','27.8','025','089061816400090251','0','0','0','25','5'), (34,'6/12','3','2.8','27.8','026','089061816400090260','0','0','0','25','5'), (35,'7/12','3','2.8','27.8','027','089061816400090279','0','0','0','25','5'), (36,'8/12','3','2.8','27.8','028','089061816400090288','0','0','0','25','5'), (37,'9/12','3','2.8','27.8','029','089061816400090297','0','0','0','25','5'), (38,'10/12','3','2.8','27.8','030','089061816400090303','0','0','0','25','5'), (39,'11/12','3','2.8','27.8','031','089061816400090312','0','0','0','25','5'), (40,'12/12','3','2.8','27.8','032','089061816400090321','0','0','0','25','5'), (41,'1/2','4','2.8','27.8','033','089061816400090330','0','0','0','25','5'), (42,'2/2','4','2.8','27.8','034','089061816400090349','0','0','0','25','5'), (43,'1/1','5','2.8','27.8','035','089061816400090358','0','0','0','25','5'), (44,'1/20','6','2.2','27.2','036','089061816400090367','0','0','0','25','6'), (45,'2/20','6','2.2','27.2','037','089061816400090376','0','0','0','25','6'), (46,'3/20','6','2.2','27.2','038','089061816400090385','0','0','0','25','6'), (47,'4/20','6','2.2','27.2','039','089061816400090394','0','0','0','25','6'), (48,'5/20','6','2.2','27.2','040','089061816400090400','0','0','0','25','6'), (49,'6/20','6','2.2','27.2','041','089061816400090419','0','0','0','25','6'), (50,'7/20','6','2.2','27.2','042','089061816400090428','0','0','0','25','6'), (51,'8/20','6','2.2','27.2','043','089061816400090437','0','0','0','25','6'), (52,'9/20','6','2.2','27.2','044','089061816400090446','0','0','0','25','6'), (53,'10/20','6','2.2','27.2','045','089061816400090455','0','0','0','25','6'), (54,'11/20','6','2.2','27.2','046','089061816400090464','0','0','0','25','6'), (55,'12/20','6','2.2','27.2','047','089061816400090473','0','0','0','25','6'), (56,'13/20','6','2.2','27.2','048','089061816400090482','0','0','0','25','6'), (57,'14/20','6','2.2','27.2','049','089061816400090491','0','0','0','25','6'), (58,'15/20','6','2.2','27.2','050','089061816400090507','0','0','0','25','6'), (59,'16/20','6','2.2','27.2','051','089061816400090516','0','0','0','25','6'), (60,'17/20','6','2.2','27.2','052','089061816400090525','0','0','0','25','6'), (61,'18/20','6','2.2','27.2','053','089061816400090534','0','0','0','25','6'), (62,'19/20','6','2.2','27.2','054','089061816400090543','0','0','0','25','6'), (63,'20/20','6','2.2','27.2','055','089061816400090552','0','0','0','25','6'), (64,'1/4','7','2.8','27.8','056','089061816400090561','0','0','0','25','5'), (65,'2/4','7','2.8','27.8','057','089061816400090570','0','0','0','25','5'), (66,'3/4','7','2.8','27.8','058','089061816400090589','0','0','0','25','5'), (67,'4/4','7','2.8','27.8','059','089061816400090598','0','0','0','25','5'), (68,'1/1','8','0.25','5.25','060','089061816400090604','0','0','0','5','5'), (88,'1/40','10','0.25','5.25','061','089061816400090613','0','0','0','5','11'), (89,'2/40','10','0.25','5.25','062','089061816400090622','0','0','0','5','11'), (90,'3/40','10','0.25','5.25','063','089061816400090631','0','0','0','5','11'), (91,'4/40','10','0.25','5.25','064','089061816400090640','0','0','0','5','11'), (92,'5/40','10','0.25','5.25','065','089061816400090659','0','0','0','5','11'), (93,'6/40','10','0.25','5.25','066','089061816400090668','0','0','0','5','11'), (94,'7/40','10','0.25','5.25','067','089061816400090677','0','0','0','5','11'), (95,'8/40','10','0.25','5.25','068','089061816400090686','0','0','0','5','11'), (96,'9/40','10','0.25','5.25','069','089061816400090695','0','0','0','5','11'), (97,'10/40','10','0.25','5.25','070','089061816400090701','0','0','0','5','11'), (98,'11/40','10','0.25','5.25','071','089061816400090710','0','0','0','5','11'), (99,'12/40','10','0.25','5.25','072','089061816400090729','0','0','0','5','11'), (100,'13/40','10','0.25','5.25','073','089061816400090738','0','0','0','5','11'), (101,'14/40','10','0.25','5.25','074','089061816400090747','0','0','0','5','11'), (102,'15/40','10','0.25','5.25','075','089061816400090756','0','0','0','5','11'), (103,'16/40','10','0.25','5.25','076','089061816400090765','0','0','0','5','11'), (104,'17/40','10','0.25','5.25','077','089061816400090774','0','0','0','5','11'), (105,'18/40','10','0.25','5.25','078','089061816400090783','0','0','0','5','11'), (106,'19/40','10','0.25','5.25','079','089061816400090792','0','0','0','5','11'), (107,'20/40','10','0.25','5.25','080','089061816400090808','0','0','0','5','11'), (108,'21/40','10','0.25','5.25','081','089061816400090817','0','0','0','5','11'), (109,'22/40','10','0.25','5.25','082','089061816400090826','0','0','0','5','11'), (110,'23/40','10','0.25','5.25','083','089061816400090835','0','0','0','5','11'), (111,'24/40','10','0.25','5.25','084','089061816400090844','0','0','0','5','11'), (112,'25/40','10','0.25','5.25','085','089061816400090853','0','0','0','5','11'), (113,'26/40','10','0.25','5.25','086','089061816400090862','0','0','0','5','11'), (114,'27/40','10','0.25','5.25','087','089061816400090871','0','0','0','5','11'), (115,'28/40','10','0.25','5.25','088','089061816400090880','0','0','0','5','11'), (116,'29/40','10','0.25','5.25','089','089061816400090899','0','0','0','5','11'), (117,'30/40','10','0.25','5.25','090','089061816400090905','0','0','0','5','11'), (118,'31/40','10','0.25','5.25','091','089061816400090914','0','0','0','5','11'), (119,'32/40','10','0.25','5.25','092','089061816400090923','0','0','0','5','11'), (120,'33/40','10','0.25','5.25','093','089061816400090932','0','0','0','5','11'), (121,'34/40','10','0.25','5.25','094','089061816400090941','0','0','0','5','11'), (122,'35/40','10','0.25','5.25','095','089061816400090950','0','0','0','5','11'), (123,'36/40','10','0.25','5.25','096','089061816400090969','0','0','0','5','11'), (124,'37/40','10','0.25','5.25','097','089061816400090978','0','0','0','5','11'), (125,'38/40','10','0.25','5.25','098','089061816400090987','0','0','0','5','11'), (126,'39/40','10','0.25','5.25','099','089061816400090996','0','0','0','5','11'), (127,'40/40','10','0.25','5.25','100','089061816400091001','0','0','0','5','11'), (128,'1/20','11','2.8','27.8','101','089061816400091010','0','0','0','25','10'), (129,'2/20','11','2.8','27.8','102','089061816400091029','0','0','0','25','10'), (130,'3/20','11','2.8','27.8','103','089061816400091038','0','0','0','25','10'), (131,'4/20','11','2.8','27.8','104','089061816400091047','0','0','0','25','10'), (132,'5/20','11','2.8','27.8','105','089061816400091056','0','0','0','25','10'), (133,'6/20','11','2.8','27.8','106','089061816400091065','0','0','0','25','10'), (134,'7/20','11','2.8','27.8','107','089061816400091074','0','0','0','25','10'), (135,'8/20','11','2.8','27.8','108','089061816400091083','0','0','0','25','10'), (136,'9/20','11','2.8','27.8','109','089061816400091092','0','0','0','25','10'), (137,'10/20','11','2.8','27.8','110','089061816400091108','0','0','0','25','10'), (138,'11/20','11','2.8','27.8','111','089061816400091117','0','0','0','25','10'), (139,'12/20','11','2.8','27.8','112','089061816400091126','0','0','0','25','10'), (140,'13/20','11','2.8','27.8','113','089061816400091135','0','0','0','25','10'), (141,'14/20','11','2.8','27.8','114','089061816400091144','0','0','0','25','10'), (142,'15/20','11','2.8','27.8','115','089061816400091153','0','0','0','25','10'), (143,'16/20','11','2.8','27.8','116','089061816400091162','0','0','0','25','10'), (144,'17/20','11','2.8','27.8','117','089061816400091171','0','0','0','25','10'), (145,'18/20','11','2.8','27.8','118','089061816400091180','0','0','0','25','10'), (146,'19/20','11','2.8','27.8','119','089061816400091199','0','0','0','25','10'), (147,'20/20','11','2.8','27.8','120','089061816400091205','0','0','0','25','10'), (148,'1/4','12','12.25','17.25','001','0123456780019','0','0','0','5','12'), (149,'2/4','12','12.25','17.25','002','0123456780026','0','0','0','5','12'), (150,'3/4','12','12.25','17.25','003','0123456780033','0','0','0','5','12'), (151,'4/4','12','12.25','17.25','004','0123456780040','0','0','0','5','12'), (152,'1/1','13','0.25','5.25','121','089061816400091214','0','0','0','5','5'), (153,'1/2','14','0.25','5.25','122','089061816400091223','0','0','0','5','5'), (154,'2/2','14','0.25','5.25','123','089061816400091232','0','0','0','5','5'), (155,'1/1','15','0.25','5.25','124','089061816400091241','0','0','0','5','5'), (156,'1/20','16','2.2','27.2','125','089061816400091250','0','0','0','25','7'), (157,'2/20','16','2.2','27.2','126','089061816400091269','0','0','0','25','7'), (158,'3/20','16','2.2','27.2','127','089061816400091278','0','0','0','25','7'), (159,'4/20','16','2.2','27.2','128','089061816400091287','0','0','0','25','7'), (160,'5/20','16','2.2','27.2','129','089061816400091296','0','0','0','25','7'), (161,'6/20','16','2.2','27.2','130','089061816400091302','0','0','0','25','7'), (162,'7/20','16','2.2','27.2','131','089061816400091311','0','0','0','25','7'), (163,'8/20','16','2.2','27.2','132','089061816400091320','0','0','0','25','7'), (164,'9/20','16','2.2','27.2','133','089061816400091339','0','0','0','25','7'), (165,'10/20','16','2.2','27.2','134','089061816400091348','0','0','0','25','7'), (166,'11/20','16','2.2','27.2','135','089061816400091357','0','0','0','25','7'), (167,'12/20','16','2.2','27.2','136','089061816400091366','0','0','0','25','7'), (168,'13/20','16','2.2','27.2','137','089061816400091375','0','0','0','25','7'), (169,'14/20','16','2.2','27.2','138','089061816400091384','0','0','0','25','7'), (170,'15/20','16','2.2','27.2','139','089061816400091393','0','0','0','25','7'), (171,'16/20','16','2.2','27.2','140','089061816400091409','0','0','0','25','7'), (172,'17/20','16','2.2','27.2','141','089061816400091418','0','0','0','25','7'), (173,'18/20','16','2.2','27.2','142','089061816400091427','0','0','0','25','7'), (174,'19/20','16','2.2','27.2','143','089061816400091436','0','0','0','25','7'), (175,'20/20','16','2.2','27.2','144','089061816400091445','0','0','0','25','7'), (176,'1/20','17','2.2','27.2','145','089061816400091454','0','0','0','25','8'), (177,'2/20','17','2.2','27.2','146','089061816400091463','0','0','0','25','8'), (178,'3/20','17','2.2','27.2','147','089061816400091472','0','0','0','25','8'), (179,'4/20','17','2.2','27.2','148','089061816400091481','0','0','0','25','8'), (180,'5/20','17','2.2','27.2','149','089061816400091490','0','0','0','25','8'), (181,'6/20','17','2.2','27.2','150','089061816400091506','0','0','0','25','8'), (182,'7/20','17','2.2','27.2','151','089061816400091515','0','0','0','25','8'), (183,'8/20','17','2.2','27.2','152','089061816400091524','0','0','0','25','8'), (184,'9/20','17','2.2','27.2','153','089061816400091533','0','0','0','25','8'), (185,'10/20','17','2.2','27.2','154','089061816400091542','0','0','0','25','8'), (186,'11/20','17','2.2','27.2','155','089061816400091551','0','0','0','25','8'), (187,'12/20','17','2.2','27.2','156','089061816400091560','0','0','0','25','8'), (188,'13/20','17','2.2','27.2','157','089061816400091579','0','0','0','25','8'), (189,'14/20','17','2.2','27.2','158','089061816400091588','0','0','0','25','8'), (190,'15/20','17','2.2','27.2','159','089061816400091597','0','0','0','25','8'), (191,'16/20','17','2.2','27.2','160','089061816400091603','0','0','0','25','8'), (192,'17/20','17','2.2','27.2','161','089061816400091612','0','0','0','25','8'), (193,'18/20','17','2.2','27.2','162','089061816400091621','0','0','0','25','8'), (194,'19/20','17','2.2','27.2','163','089061816400091630','0','0','0','25','8'), (195,'20/20','17','2.2','27.2','164','089061816400091649','0','0','0','25','8'), (196,'1/12','18','2.2','27.2','165','089061816400091658','0','0','0','25','11'), (197,'2/12','18','2.2','27.2','166','089061816400091667','0','0','0','25','11'), (198,'3/12','18','2.2','27.2','167','089061816400091676','0','0','0','25','11'), (199,'4/12','18','2.2','27.2','168','089061816400091685','0','0','0','25','11'), (200,'5/12','18','2.2','27.2','169','089061816400091694','0','0','0','25','11'), (201,'6/12','18','2.2','27.2','170','089061816400091700','0','0','0','25','11'), (202,'7/12','18','2.2','27.2','171','089061816400091719','0','0','0','25','11'), (203,'8/12','18','2.2','27.2','172','089061816400091728','0','0','0','25','11'), (204,'9/12','18','2.2','27.2','173','089061816400091737','0','0','0','25','11'), (205,'10/12','18','2.2','27.2','174','089061816400091746','0','0','0','25','11'), (206,'11/12','18','2.2','27.2','175','089061816400091755','0','0','0','25','11'), (207,'12/12','18','2.2','27.2','176','089061816400091764','0','0','0','25','11'), (248,'1/1','20','3.3','28.3','001','089061816400230017','0','0','0','25','24'), (269,'1/1','22','3.3','28.3','002','089061816400230026','0','0','0','25','13'), (270,'1/12','24','2.8','27.8','237','089061816400092374','0','0','0','25','35'), (271,'2/12','24','2.8','27.8','238','089061816400092383','0','0','0','25','35'), (272,'3/12','24','2.8','27.8','239','089061816400092392','0','0','0','25','35'), (273,'4/12','24','2.8','27.8','240','089061816400092408','0','0','0','25','35'), (274,'5/12','24','2.8','27.8','241','089061816400092417','0','0','0','25','35'), (275,'6/12','24','2.8','27.8','242','089061816400092426','0','0','0','25','35'), (276,'7/12','24','2.8','27.8','243','089061816400092435','0','0','0','25','35'), (277,'8/12','24','2.8','27.8','244','089061816400092444','0','0','0','25','35'), (278,'9/12','24','2.8','27.8','245','089061816400092453','0','0','0','25','35'), (279,'10/12','24','2.8','27.8','246','089061816400092462','0','0','0','25','35'), (280,'11/12','24','2.8','27.8','247','089061816400092471','0','0','0','25','35'), (281,'12/12','24','2.8','27.8','248','089061816400092480','0','0','0','25','35'), (283,'1/1','26','3.3','28.3','003','089061816400230035','0','0','0','25','13'), (284,'1/1','27','3.3','28.3','004','089061816400230044','0','0','0','25','24'), (285,'1/1','28','0.9','5.9','249','089061816400092499','0','0','0','5','16'), (286,'1/2','29','3.3','28.3','005','089061816400230053','0','0','0','25','24'), (287,'2/2','29','3.3','28.3','006','089061816400230062','0','0','0','25','24'), (288,'1/1','30','3.3','28.3','007','089061816400230071','0','0','0','25','24'), (289,'1/1','31','0.25','5.25','008','089061816400230080','0','0','0','5','13'), (290,'1/9','32','3.3','28.3','009','089061816400230099','0','0','0','25','13'), (291,'2/9','32','3.3','28.3','010','089061816400230105','0','0','0','25','13'), (292,'3/9','32','3.3','28.3','011','089061816400230114','0','0','0','25','13'), (293,'4/9','32','3.3','28.3','012','089061816400230123','0','0','0','25','13'), (294,'5/9','32','3.3','28.3','013','089061816400230132','0','0','0','25','13'), (295,'6/9','32','3.3','28.3','014','089061816400230141','0','0','0','25','13'), (296,'7/9','32','3.3','28.3','015','089061816400230150','0','0','0','25','13'), (297,'8/9','32','3.3','28.3','016','089061816400230169','0','0','0','25','13'), (298,'9/9','32','3.3','28.3','017','089061816400230178','0','0','0','25','13'), (299,'1/20','33','2.2','27.2','250','089061816400092505','0','0','0','25','15'), (300,'2/20','33','2.2','27.2','251','089061816400092514','0','0','0','25','15'), (301,'3/20','33','2.2','27.2','252','089061816400092523','0','0','0','25','15'), (302,'4/20','33','2.2','27.2','253','089061816400092532','0','0','0','25','15'), (303,'5/20','33','2.2','27.2','254','089061816400092541','0','0','0','25','15'), (304,'6/20','33','2.2','27.2','255','089061816400092550','0','0','0','25','15'), (305,'7/20','33','2.2','27.2','256','089061816400092569','0','0','0','25','15'), (306,'8/20','33','2.2','27.2','257','089061816400092578','0','0','0','25','15'), (307,'9/20','33','2.2','27.2','258','089061816400092587','0','0','0','25','15'), (308,'10/20','33','2.2','27.2','259','089061816400092596','0','0','0','25','15'), (309,'11/20','33','2.2','27.2','260','089061816400092602','0','0','0','25','15'), (310,'12/20','33','2.2','27.2','261','089061816400092611','0','0','0','25','15'), (311,'13/20','33','2.2','27.2','262','089061816400092620','0','0','0','25','15'), (312,'14/20','33','2.2','27.2','263','089061816400092639','0','0','0','25','15'), (313,'15/20','33','2.2','27.2','264','089061816400092648','0','0','0','25','15'), (314,'16/20','33','2.2','27.2','265','089061816400092657','0','0','0','25','15'), (315,'17/20','33','2.2','27.2','266','089061816400092666','0','0','0','25','15'), (316,'18/20','33','2.2','27.2','267','089061816400092675','0','0','0','25','15'), (317,'19/20','33','2.2','27.2','268','089061816400092684','0','0','0','25','15'), (318,'20/20','33','2.2','27.2','269','089061816400092693','0','0','0','25','15'), (319,'1/2','34','0.25','5.25','270','089061816400092709','0','0','0','5','16'), (320,'2/2','34','0.25','5.25','271','089061816400092718','0','0','0','5','16'), (321,'1/1','35','2.8','27.8','272','089061816400092727','0','0','0','25','16'), (322,'1/1','36','2.8','27.8','273','089061816400092736','0','0','0','25','16'), (323,'1/1','37','2.8','27.8','274','089061816400092745','0','0','0','25','16'), (324,'1/2','38','2.8','27.8','275','089061816400092754','0','0','0','25','16'), (325,'2/2','38','2.8','27.8','276','089061816400092763','0','0','0','25','16'), (326,'1/14','39','2.8','27.8','277','089061816400092772','0','0','0','25','16'), (327,'2/14','39','2.8','27.8','278','089061816400092781','0','0','0','25','16'), (328,'3/14','39','2.8','27.8','279','089061816400092790','0','0','0','25','16'), (329,'4/14','39','2.8','27.8','280','089061816400092806','0','0','0','25','16'), (330,'5/14','39','2.8','27.8','281','089061816400092815','0','0','0','25','16'), (331,'6/14','39','2.8','27.8','282','089061816400092824','0','0','0','25','16'), (332,'7/14','39','2.8','27.8','283','089061816400092833','0','0','0','25','16'), (333,'8/14','39','2.8','27.8','284','089061816400092842','0','0','0','25','16'), (334,'9/14','39','2.8','27.8','285','089061816400092851','0','0','0','25','16'), (335,'10/14','39','2.8','27.8','286','089061816400092860','0','0','0','25','16'), (336,'11/14','39','2.8','27.8','287','089061816400092879','0','0','0','25','16'), (337,'12/14','39','2.8','27.8','288','089061816400092888','0','0','0','25','16'), (338,'13/14','39','2.8','27.8','289','089061816400092897','0','0','0','25','16'), (339,'14/14','39','2.8','27.8','290','089061816400092903','0','0','0','25','16'), (340,'1/20','40','2.2','27.2','291','089061816400092912','0','0','0','25','17'), (341,'2/20','40','2.2','27.2','292','089061816400092921','0','0','0','25','17'), (342,'3/20','40','2.2','27.2','293','089061816400092930','0','0','0','25','17'), (343,'4/20','40','2.2','27.2','294','089061816400092949','0','0','0','25','17'), (344,'5/20','40','2.2','27.2','295','089061816400092958','0','0','0','25','17'), (345,'6/20','40','2.2','27.2','296','089061816400092967','0','0','0','25','17'), (346,'7/20','40','2.2','27.2','297','089061816400092976','0','0','0','25','17'), (347,'8/20','40','2.2','27.2','298','089061816400092985','0','0','0','25','17'), (348,'9/20','40','2.2','27.2','299','089061816400092994','0','0','0','25','17'), (349,'10/20','40','2.2','27.2','300','089061816400093009','0','0','0','25','17'), (350,'11/20','40','2.2','27.2','301','089061816400093018','0','0','0','25','17'), (351,'12/20','40','2.2','27.2','302','089061816400093027','0','0','0','25','17'), (352,'13/20','40','2.2','27.2','303','089061816400093036','0','0','0','25','17'), (353,'14/20','40','2.2','27.2','304','089061816400093045','0','0','0','25','17'), (354,'15/20','40','2.2','27.2','305','089061816400093054','0','0','0','25','17'), (355,'16/20','40','2.2','27.2','306','089061816400093063','0','0','0','25','17'), (356,'17/20','40','2.2','27.2','307','089061816400093072','0','0','0','25','17'), (357,'18/20','40','2.2','27.2','308','089061816400093081','0','0','0','25','17'), (358,'19/20','40','2.2','27.2','309','089061816400093090','0','0','0','25','17'), (359,'20/20','40','2.2','27.2','310','089061816400093106','0','0','0','25','17'), (360,'1/20','41','2.2','27.2','311','089061816400093115','0','0','0','25','19'), (361,'2/20','41','2.2','27.2','312','089061816400093124','0','0','0','25','19'), (362,'3/20','41','2.2','27.2','313','089061816400093133','0','0','0','25','19'), (363,'4/20','41','2.2','27.2','314','089061816400093142','0','0','0','25','19'), (364,'5/20','41','2.2','27.2','315','089061816400093151','0','0','0','25','19'), (365,'6/20','41','2.2','27.2','316','089061816400093160','0','0','0','25','19'), (366,'7/20','41','2.2','27.2','317','089061816400093179','0','0','0','25','19'), (367,'8/20','41','2.2','27.2','318','089061816400093188','0','0','0','25','19'), (368,'9/20','41','2.2','27.2','319','089061816400093197','0','0','0','25','19'), (369,'10/20','41','2.2','27.2','320','089061816400093203','0','0','0','25','19'), (370,'11/20','41','2.2','27.2','321','089061816400093212','0','0','0','25','19'), (371,'12/20','41','2.2','27.2','322','089061816400093221','0','0','0','25','19'), (372,'13/20','41','2.2','27.2','323','089061816400093230','0','0','0','25','19'), (373,'14/20','41','2.2','27.2','324','089061816400093249','0','0','0','25','19'), (374,'15/20','41','2.2','27.2','325','089061816400093258','0','0','0','25','19'), (375,'16/20','41','2.2','27.2','326','089061816400093267','0','0','0','25','19'), (376,'17/20','41','2.2','27.2','327','089061816400093276','0','0','0','25','19'), (377,'18/20','41','2.2','27.2','328','089061816400093285','0','0','0','25','19'), (378,'19/20','41','2.2','27.2','329','089061816400093294','0','0','0','25','19'), (379,'20/20','41','2.2','27.2','330','089061816400093300','0','0','0','25','19'), (380,'1/20','42','2.2','27.2','331','089061816400093319','0','0','0','25','20'), (381,'2/20','42','2.2','27.2','332','089061816400093328','0','0','0','25','20'), (382,'3/20','42','2.2','27.2','333','089061816400093337','0','0','0','25','20'), (383,'4/20','42','2.2','27.2','334','089061816400093346','0','0','0','25','20'), (384,'5/20','42','2.2','27.2','335','089061816400093355','0','0','0','25','20'), (385,'6/20','42','2.2','27.2','336','089061816400093364','0','0','0','25','20'), (386,'7/20','42','2.2','27.2','337','089061816400093373','0','0','0','25','20'), (387,'8/20','42','2.2','27.2','338','089061816400093382','0','0','0','25','20'), (388,'9/20','42','2.2','27.2','339','089061816400093391','0','0','0','25','20'), (389,'10/20','42','2.2','27.2','340','089061816400093407','0','0','0','25','20'), (390,'11/20','42','2.2','27.2','341','089061816400093416','0','0','0','25','20'), (391,'12/20','42','2.2','27.2','342','089061816400093425','0','0','0','25','20'), (392,'13/20','42','2.2','27.2','343','089061816400093434','0','0','0','25','20'), (393,'14/20','42','2.2','27.2','344','089061816400093443','0','0','0','25','20'), (394,'15/20','42','2.2','27.2','345','089061816400093452','0','0','0','25','20'), (395,'16/20','42','2.2','27.2','346','089061816400093461','0','0','0','25','20'), (396,'17/20','42','2.2','27.2','347','089061816400093470','0','0','0','25','20'), (397,'18/20','42','2.2','27.2','348','089061816400093489','0','0','0','25','20'), (398,'19/20','42','2.2','27.2','349','089061816400093498','0','0','0','25','20'), (399,'20/20','42','2.2','27.2','350','089061816400093504','0','0','0','25','20'), (400,'1/20','43','2.2','27.2','351','089061816400093513','0','0','0','25','21'), (401,'2/20','43','2.2','27.2','352','089061816400093522','0','0','0','25','21'), (402,'3/20','43','2.2','27.2','353','089061816400093531','0','0','0','25','21'), (403,'4/20','43','2.2','27.2','354','089061816400093540','0','0','0','25','21'), (404,'5/20','43','2.2','27.2','355','089061816400093559','0','0','0','25','21'), (405,'6/20','43','2.2','27.2','356','089061816400093568','0','0','0','25','21'), (406,'7/20','43','2.2','27.2','357','089061816400093577','0','0','0','25','21'), (407,'8/20','43','2.2','27.2','358','089061816400093586','0','0','0','25','21'), (408,'9/20','43','2.2','27.2','359','089061816400093595','0','0','0','25','21'), (409,'10/20','43','2.2','27.2','360','089061816400093601','0','0','0','25','21'), (410,'11/20','43','2.2','27.2','361','089061816400093610','0','0','0','25','21'), (411,'12/20','43','2.2','27.2','362','089061816400093629','0','0','0','25','21'), (412,'13/20','43','2.2','27.2','363','089061816400093638','0','0','0','25','21'), (413,'14/20','43','2.2','27.2','364','089061816400093647','0','0','0','25','21'), (414,'15/20','43','2.2','27.2','365','089061816400093656','0','0','0','25','21'), (415,'16/20','43','2.2','27.2','366','089061816400093665','0','0','0','25','21'), (416,'17/20','43','2.2','27.2','367','089061816400093674','0','0','0','25','21'), (417,'18/20','43','2.2','27.2','368','089061816400093683','0','0','0','25','21'), (418,'19/20','43','2.2','27.2','369','089061816400093692','0','0','0','25','21'), (419,'20/20','43','2.2','27.2','370','089061816400093708','0','0','0','25','21'), (420,'1/20','44','2.2','27.2','371','089061816400093717','0','0','0','25','23'), (421,'2/20','44','2.2','27.2','372','089061816400093726','0','0','0','25','23'), (422,'3/20','44','2.2','27.2','373','089061816400093735','0','0','0','25','23'), (423,'4/20','44','2.2','27.2','374','089061816400093744','0','0','0','25','23'), (424,'5/20','44','2.2','27.2','375','089061816400093753','0','0','0','25','23'), (425,'6/20','44','2.2','27.2','376','089061816400093762','0','0','0','25','23'), (426,'7/20','44','2.2','27.2','377','089061816400093771','0','0','0','25','23'), (427,'8/20','44','2.2','27.2','378','089061816400093780','0','0','0','25','23'), (428,'9/20','44','2.2','27.2','379','089061816400093799','0','0','0','25','23'), (429,'10/20','44','2.2','27.2','380','089061816400093805','0','0','0','25','23'), (430,'11/20','44','2.2','27.2','381','089061816400093814','0','0','0','25','23'), (431,'12/20','44','2.2','27.2','382','089061816400093823','0','0','0','25','23'), (432,'13/20','44','2.2','27.2','383','089061816400093832','0','0','0','25','23'), (433,'14/20','44','2.2','27.2','384','089061816400093841','0','0','0','25','23'), (434,'15/20','44','2.2','27.2','385','089061816400093850','0','0','0','25','23'), (435,'16/20','44','2.2','27.2','386','089061816400093869','0','0','0','25','23'), (436,'17/20','44','2.2','27.2','387','089061816400093878','0','0','0','25','23'), (437,'18/20','44','2.2','27.2','388','089061816400093887','0','0','0','25','23'), (438,'19/20','44','2.2','27.2','389','089061816400093896','0','0','0','25','23'), (439,'20/20','44','2.2','27.2','390','089061816400093902','0','0','0','25','23'), (440,'1/8','45','2.8','27.8','391','089061816400093911','0','0','0','25','35'), (441,'2/8','45','2.8','27.8','392','089061816400093920','0','0','0','25','35'), (442,'3/8','45','2.8','27.8','393','089061816400093939','0','0','0','25','35'), (443,'4/8','45','2.8','27.8','394','089061816400093948','0','0','0','25','35'), (444,'5/8','45','2.8','27.8','395','089061816400093957','0','0','0','25','35'), (445,'6/8','45','2.8','27.8','396','089061816400093966','0','0','0','25','35'), (446,'7/8','45','2.8','27.8','397','089061816400093975','0','0','0','25','35'), (447,'8/8','45','2.8','27.8','398','089061816400093984','0','0','0','25','35'), (448,'1/1','46','3.3','28.3','018','089061816400230187','0','0','0','25','13'), (449,'1/9','47','2.2','27.2','019','089061816400230196','0','0','0','25','24'), (450,'2/9','47','2.2','27.2','020','089061816400230202','0','0','0','25','24'), (451,'3/9','47','2.2','27.2','021','089061816400230211','0','0','0','25','24'), (452,'4/9','47','2.2','27.2','022','089061816400230220','0','0','0','25','24'), (453,'5/9','47','2.2','27.2','023','089061816400230239','0','0','0','25','24'), (454,'6/9','47','2.2','27.2','024','089061816400230248','0','0','0','25','24'), (455,'7/9','47','2.2','27.2','025','089061816400230257','0','0','0','25','24'), (456,'8/9','47','2.2','27.2','026','089061816400230266','0','0','0','25','24'), (457,'9/9','47','2.2','27.2','027','089061816400230275','0','0','0','25','24'), (458,'1/14','48','2.8','27.8','399','089061816400093993','0','0','0','25','25'), (459,'2/14','48','2.8','27.8','400','089061816400094008','0','0','0','25','25'), (460,'3/14','48','2.8','27.8','401','089061816400094017','0','0','0','25','25'), (461,'4/14','48','2.8','27.8','402','089061816400094026','0','0','0','25','25'), (462,'5/14','48','2.8','27.8','403','089061816400094035','0','0','0','25','25'), (463,'6/14','48','2.8','27.8','404','089061816400094044','0','0','0','25','25'), (464,'7/14','48','2.8','27.8','405','089061816400094053','0','0','0','25','25'), (465,'8/14','48','2.8','27.8','406','089061816400094062','0','0','0','25','25'), (466,'9/14','48','2.8','27.8','407','089061816400094071','0','0','0','25','25'), (467,'10/14','48','2.8','27.8','408','089061816400094080','0','0','0','25','25'), (468,'11/14','48','2.8','27.8','409','089061816400094099','0','0','0','25','25'), (469,'12/14','48','2.8','27.8','410','089061816400094105','0','0','0','25','25'), (470,'13/14','48','2.8','27.8','411','089061816400094114','0','0','0','25','25'), (471,'14/14','48','2.8','27.8','412','089061816400094123','0','0','0','25','25'), (472,'1/20','49','0.25','5.25','413','089061816400094132','0','0','0','5','25'), (473,'2/20','49','0.25','5.25','414','089061816400094141','0','0','0','5','25'), (474,'3/20','49','0.25','5.25','415','089061816400094150','0','0','0','5','25'), (475,'4/20','49','0.25','5.25','416','089061816400094169','0','0','0','5','25'), (476,'5/20','49','0.25','5.25','417','089061816400094178','0','0','0','5','25'), (477,'6/20','49','0.25','5.25','418','089061816400094187','0','0','0','5','25'), (478,'7/20','49','0.25','5.25','419','089061816400094196','0','0','0','5','25'), (479,'8/20','49','0.25','5.25','420','089061816400094202','0','0','0','5','25'), (480,'9/20','49','0.25','5.25','421','089061816400094211','0','0','0','5','25'), (481,'10/20','49','0.25','5.25','422','089061816400094220','0','0','0','5','25'), (482,'11/20','49','0.25','5.25','423','089061816400094239','0','0','0','5','25'), (483,'12/20','49','0.25','5.25','424','089061816400094248','0','0','0','5','25'), (484,'13/20','49','0.25','5.25','425','089061816400094257','0','0','0','5','25'), (485,'14/20','49','0.25','5.25','426','089061816400094266','0','0','0','5','25'), (486,'15/20','49','0.25','5.25','427','089061816400094275','0','0','0','5','25'), (487,'16/20','49','0.25','5.25','428','089061816400094284','0','0','0','5','25'), (488,'17/20','49','0.25','5.25','429','089061816400094293','0','0','0','5','25'), (489,'18/20','49','0.25','5.25','430','089061816400094309','0','0','0','5','25'), (490,'19/20','49','0.25','5.25','431','089061816400094318','0','0','0','5','25'), (491,'20/20','49','0.25','5.25','432','089061816400094327','0','0','0','5','25'), (494,'1/2','51','0.9','5.9','028','089061816400230284','0','0','0','5','24'), (495,'2/2','51','0.9','5.9','029','089061816400230293','0','0','0','5','24'), (496,'1/20','52','2.2','27.2','435','089061816400094354','0','0','0','25','14'), (497,'2/20','52','2.2','27.2','436','089061816400094363','0','0','0','25','14'), (498,'3/20','52','2.2','27.2','437','089061816400094372','0','0','0','25','14'), (499,'4/20','52','2.2','27.2','438','089061816400094381','0','0','0','25','14'), (500,'5/20','52','2.2','27.2','439','089061816400094390','0','0','0','25','14'), (501,'6/20','52','2.2','27.2','440','089061816400094406','0','0','0','25','14'), (502,'7/20','52','2.2','27.2','441','089061816400094415','0','0','0','25','14'), (503,'8/20','52','2.2','27.2','442','089061816400094424','0','0','0','25','14'), (504,'9/20','52','2.2','27.2','443','089061816400094433','0','0','0','25','14'), (505,'10/20','52','2.2','27.2','444','089061816400094442','0','0','0','25','14'), (506,'11/20','52','2.2','27.2','445','089061816400094451','0','0','0','25','14'), (507,'12/20','52','2.2','27.2','446','089061816400094460','0','0','0','25','14'), (508,'13/20','52','2.2','27.2','447','089061816400094479','0','0','0','25','14'), (509,'14/20','52','2.2','27.2','448','089061816400094488','0','0','0','25','14'), (510,'15/20','52','2.2','27.2','449','089061816400094497','0','0','0','25','14'), (511,'16/20','52','2.2','27.2','450','089061816400094503','0','0','0','25','14'), (512,'17/20','52','2.2','27.2','451','089061816400094512','0','0','0','25','14'), (513,'18/20','52','2.2','27.2','452','089061816400094521','0','0','0','25','14'), (514,'19/20','52','2.2','27.2','453','089061816400094530','0','0','0','25','14'), (515,'20/20','52','2.2','27.2','454','089061816400094549','0','0','0','25','14'), (516,'1/2','53','27.8','52.8','455','089061816400094558','0','0','0','25','25'), (517,'2/2','53','27.8','52.8','456','089061816400094567','0','0','0','25','25'), (520,'1/1','55','3.3','28.3','030','089061816400230309','0','0','0','25','24'), (521,'1/4','56','2.8','27.8','459','089061816400094594','0','0','0','25','26'), (522,'2/4','56','2.8','27.8','460','089061816400094600','0','0','0','25','26'), (523,'3/4','56','2.8','27.8','461','089061816400094619','0','0','0','25','26'), (524,'4/4','56','2.8','27.8','462','089061816400094628','0','0','0','25','26'), (525,'1/3','57','2.8','27.8','463','089061816400094637','0','0','0','25','26'), (526,'2/3','57','2.8','27.8','464','089061816400094646','0','0','0','25','26'), (527,'3/3','57','2.8','27.8','465','089061816400094655','0','0','0','25','26'), (528,'1/12','58','2.8','27.8','466','089061816400094664','0','0','0','25','26'), (529,'2/12','58','2.8','27.8','467','089061816400094673','0','0','0','25','26'), (530,'3/12','58','2.8','27.8','468','089061816400094682','0','0','0','25','26'), (531,'4/12','58','2.8','27.8','469','089061816400094691','0','0','0','25','26'), (532,'5/12','58','2.8','27.8','470','089061816400094707','0','0','0','25','26'), (533,'6/12','58','2.8','27.8','471','089061816400094716','0','0','0','25','26'), (534,'7/12','58','2.8','27.8','472','089061816400094725','0','0','0','25','26'), (535,'8/12','58','2.8','27.8','473','089061816400094734','0','0','0','25','26'), (536,'9/12','58','2.8','27.8','474','089061816400094743','0','0','0','25','26'), (537,'10/12','58','2.8','27.8','475','089061816400094752','0','0','0','25','26'), (538,'11/12','58','2.8','27.8','476','089061816400094761','0','0','0','25','26'), (539,'12/12','58','2.8','27.8','477','089061816400094770','0','0','0','25','26'), (540,'1/20','59','2.2','27.2','478','089061816400094789','0','0','0','25','27'), (541,'2/20','59','2.2','27.2','479','089061816400094798','0','0','0','25','27'), (542,'3/20','59','2.2','27.2','480','089061816400094804','0','0','0','25','27'), (543,'4/20','59','2.2','27.2','481','089061816400094813','0','0','0','25','27'), (544,'5/20','59','2.2','27.2','482','089061816400094822','0','0','0','25','27'), (545,'6/20','59','2.2','27.2','483','089061816400094831','0','0','0','25','27'), (546,'7/20','59','2.2','27.2','484','089061816400094840','0','0','0','25','27'), (547,'8/20','59','2.2','27.2','485','089061816400094859','0','0','0','25','27'), (548,'9/20','59','2.2','27.2','486','089061816400094868','0','0','0','25','27'), (549,'10/20','59','2.2','27.2','487','089061816400094877','0','0','0','25','27'), (550,'11/20','59','2.2','27.2','488','089061816400094886','0','0','0','25','27'), (551,'12/20','59','2.2','27.2','489','089061816400094895','0','0','0','25','27'), (552,'13/20','59','2.2','27.2','490','089061816400094901','0','0','0','25','27'), (553,'14/20','59','2.2','27.2','491','089061816400094910','0','0','0','25','27'), (554,'15/20','59','2.2','27.2','492','089061816400094929','0','0','0','25','27'), (555,'16/20','59','2.2','27.2','493','089061816400094938','0','0','0','25','27'), (556,'17/20','59','2.2','27.2','494','089061816400094947','0','0','0','25','27'), (557,'18/20','59','2.2','27.2','495','089061816400094956','0','0','0','25','27'), (558,'19/20','59','2.2','27.2','496','089061816400094965','0','0','0','25','27'), (559,'20/20','59','2.2','27.2','497','089061816400094974','0','0','0','25','27'), (560,'1/20','60','2.2','27.2','498','089061816400094983','0','0','0','25','28'), (561,'2/20','60','2.2','27.2','499','089061816400094992','0','0','0','25','28'), (562,'3/20','60','2.2','27.2','500','089061816400095007','0','0','0','25','28'), (563,'4/20','60','2.2','27.2','501','089061816400095016','0','0','0','25','28'), (564,'5/20','60','2.2','27.2','502','089061816400095025','0','0','0','25','28'), (565,'6/20','60','2.2','27.2','503','089061816400095034','0','0','0','25','28'), (566,'7/20','60','2.2','27.2','504','089061816400095043','0','0','0','25','28'), (567,'8/20','60','2.2','27.2','505','089061816400095052','0','0','0','25','28'), (568,'9/20','60','2.2','27.2','506','089061816400095061','0','0','0','25','28'), (569,'10/20','60','2.2','27.2','507','089061816400095070','0','0','0','25','28'), (570,'11/20','60','2.2','27.2','508','089061816400095089','0','0','0','25','28'), (571,'12/20','60','2.2','27.2','509','089061816400095098','0','0','0','25','28'), (572,'13/20','60','2.2','27.2','510','089061816400095104','0','0','0','25','28'), (573,'14/20','60','2.2','27.2','511','089061816400095113','0','0','0','25','28'), (574,'15/20','60','2.2','27.2','512','089061816400095122','0','0','0','25','28'), (575,'16/20','60','2.2','27.2','513','089061816400095131','0','0','0','25','28'), (576,'17/20','60','2.2','27.2','514','089061816400095140','0','0','0','25','28'), (577,'18/20','60','2.2','27.2','515','089061816400095159','0','0','0','25','28'), (578,'19/20','60','2.2','27.2','516','089061816400095168','0','0','0','25','28'), (579,'20/20','60','2.2','27.2','517','089061816400095177','0','0','0','25','28'), (580,'1/7','61','3.3','28.3','031','089061816400230318','0','0','0','25','31'), (581,'2/7','61','3.3','28.3','032','089061816400230327','0','0','0','25','31'), (582,'3/7','61','3.3','28.3','033','089061816400230336','0','0','0','25','31'), (583,'4/7','61','3.3','28.3','034','089061816400230345','0','0','0','25','31'), (584,'5/7','61','3.3','28.3','035','089061816400230354','0','0','0','25','31'), (585,'6/7','61','3.3','28.3','036','089061816400230363','0','0','0','25','31'), (586,'7/7','61','3.3','28.3','037','089061816400230372','0','0','0','25','31'), (587,'1/1','62','2.8','27.8','518','089061816400095186','0','0','0','25','26'), (588,'1/20','63','2.8','27.8','519','089061816400095195','0','0','0','25','36'), (589,'2/20','63','2.8','27.8','520','089061816400095201','0','0','0','25','36'), (590,'3/20','63','2.8','27.8','521','089061816400095210','0','0','0','25','36'), (591,'4/20','63','2.8','27.8','522','089061816400095229','0','0','0','25','36'), (592,'5/20','63','2.8','27.8','523','089061816400095238','0','0','0','25','36'), (593,'6/20','63','2.8','27.8','524','089061816400095247','0','0','0','25','36'), (594,'7/20','63','2.8','27.8','525','089061816400095256','0','0','0','25','36'), (595,'8/20','63','2.8','27.8','526','089061816400095265','0','0','0','25','36'), (596,'9/20','63','2.8','27.8','527','089061816400095274','0','0','0','25','36'), (597,'10/20','63','2.8','27.8','528','089061816400095283','0','0','0','25','36'), (598,'11/20','63','2.8','27.8','529','089061816400095292','0','0','0','25','36'), (599,'12/20','63','2.8','27.8','530','089061816400095308','0','0','0','25','36'), (600,'13/20','63','2.8','27.8','531','089061816400095317','0','0','0','25','36'), (601,'14/20','63','2.8','27.8','532','089061816400095326','0','0','0','25','36'), (602,'15/20','63','2.8','27.8','533','089061816400095335','0','0','0','25','36'), (603,'16/20','63','2.8','27.8','534','089061816400095344','0','0','0','25','36'), (604,'17/20','63','2.8','27.8','535','089061816400095353','0','0','0','25','36'), (605,'18/20','63','2.8','27.8','536','089061816400095362','0','0','0','25','36'), (606,'19/20','63','2.8','27.8','537','089061816400095371','0','0','0','25','36'), (607,'20/20','63','2.8','27.8','538','089061816400095380','0','0','0','25','36'), (608,'1/1','64','3.3','28.3','038','089061816400230381','0','0','0','25','24'), (609,'1/2','65','2.8','27.8','539','089061816400095399','0','0','0','25','40'), (610,'2/2','65','2.8','27.8','540','089061816400095405','0','0','0','25','40'), (611,'1/1','66','3.3','28.3','039','089061816400230390','0','0','0','25','24'), (612,'1/4','67','2.2','27.2','541','089061816400095414','0','0','0','25','37'), (613,'2/4','67','2.2','27.2','542','089061816400095423','0','0','0','25','37'), (614,'3/4','67','2.2','27.2','543','089061816400095432','0','0','0','25','37'), (615,'4/4','67','2.2','27.2','544','089061816400095441','0','0','0','25','37'), (616,'1/1','68','2.8','27.8','545','089061816400095450','0','0','0','25','40'), (617,'1/1','69','2.2','27.2','001','089061816400160019','0','0','0','25','39'), (618,'1/1','70','0.9','5.9','040','089061816400230406','0','0','0','5','24'), (619,'1/2','71','2.2','27.2','546','089061816400095469','0','0','0','25','37'), (620,'2/2','71','2.2','27.2','547','089061816400095478','0','0','0','25','37'), (621,'1/1','72','0.25','5.25','548','089061816400095487','0','0','0','5','40'), (622,'1/1','73','0.25','5.25','549','089061816400095496','0','0','0','5','37'), (623,'1/1','74','2.2','27.2','002','089061816400160028','0','0','0','25','41'), (624,'1/4','75','2.8','27.8','550','089061816400095502','0','0','0','25','37'), (625,'2/4','75','2.8','27.8','551','089061816400095511','0','0','0','25','37'), (626,'3/4','75','2.8','27.8','552','089061816400095520','0','0','0','25','37'), (627,'4/4','75','2.8','27.8','553','089061816400095539','0','0','0','25','37'), (628,'1/2','76','2.8','27.8','554','089061816400095548','0','0','0','25','40'), (629,'2/2','76','2.8','27.8','555','089061816400095557','0','0','0','25','40'), (630,'1/4','77','3.3','28.3','041','089061816400230415','0','0','0','25','32'), (631,'2/4','77','3.3','28.3','042','089061816400230424','0','0','0','25','32'), (632,'3/4','77','3.3','28.3','043','089061816400230433','0','0','0','25','32'), (633,'4/4','77','3.3','28.3','044','089061816400230442','0','0','0','25','32'), (634,'1/20','78','2.2','27.2','001','089061816400300015','0','0','0','25','43'), (635,'2/20','78','2.2','27.2','002','089061816400300024','0','0','0','25','43'), (636,'3/20','78','2.2','27.2','003','089061816400300033','0','0','0','25','43'), (637,'4/20','78','2.2','27.2','004','089061816400300042','0','0','0','25','43'), (638,'5/20','78','2.2','27.2','005','089061816400300051','0','0','0','25','43'), (639,'6/20','78','2.2','27.2','006','089061816400300060','0','0','0','25','43'), (640,'7/20','78','2.2','27.2','007','089061816400300079','0','0','0','25','43'), (641,'8/20','78','2.2','27.2','008','089061816400300088','0','0','0','25','43'), (642,'9/20','78','2.2','27.2','009','089061816400300097','0','0','0','25','43'), (643,'10/20','78','2.2','27.2','010','089061816400300103','0','0','0','25','43'), (644,'11/20','78','2.2','27.2','011','089061816400300112','0','0','0','25','43'), (645,'12/20','78','2.2','27.2','012','089061816400300121','0','0','0','25','43'), (646,'13/20','78','2.2','27.2','013','089061816400300130','0','0','0','25','43'), (647,'14/20','78','2.2','27.2','014','089061816400300149','0','0','0','25','43'), (648,'15/20','78','2.2','27.2','015','089061816400300158','0','0','0','25','43'), (649,'16/20','78','2.2','27.2','016','089061816400300167','0','0','0','25','43'), (650,'17/20','78','2.2','27.2','017','089061816400300176','0','0','0','25','43'), (651,'18/20','78','2.2','27.2','018','089061816400300185','0','0','0','25','43'), (652,'19/20','78','2.2','27.2','019','089061816400300194','0','0','0','25','43'), (653,'20/20','78','2.2','27.2','020','089061816400300200','0','0','0','25','43'), (654,'1/12','80','2.2','27.2','556','089061816400095566','0','0','0','25','45'), (655,'2/12','80','2.2','27.2','557','089061816400095575','0','0','0','25','45'), (656,'3/12','80','2.2','27.2','558','089061816400095584','0','0','0','25','45'), (657,'4/12','80','2.2','27.2','559','089061816400095593','0','0','0','25','45'), (658,'5/12','80','2.2','27.2','560','089061816400095609','0','0','0','25','45'), (659,'6/12','80','2.2','27.2','561','089061816400095618','0','0','0','25','45'), (660,'7/12','80','2.2','27.2','562','089061816400095627','0','0','0','25','45'), (661,'8/12','80','2.2','27.2','563','089061816400095636','0','0','0','25','45'), (662,'9/12','80','2.2','27.2','564','089061816400095645','0','0','0','25','45'), (663,'10/12','80','2.2','27.2','565','089061816400095654','0','0','0','25','45'), (664,'11/12','80','2.2','27.2','566','089061816400095663','0','0','0','25','45'), (665,'12/12','80','2.2','27.2','567','089061816400095672','0','0','0','25','45'); /*!40000 ALTER TABLE `generateqrsr` ENABLE KEYS */; -- -- Definition of logtable -- DROP TABLE IF EXISTS `logtable`; CREATE TABLE IF NOT EXISTS `logtable` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, `action` varchar(1000) DEFAULT NULL, `time` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `tablename` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1071 DEFAULT CHARSET=utf8; -- -- Dumping data for table logtable -- /*!40000 ALTER TABLE `logtable` DISABLE KEYS */; INSERT INTO `logtable`(`id`,`username`,`action`,`time`,`userid`,`tablename`) VALUES (1,NULL,'User Logged In','2024-08-03 11:13:36','39','Login In'), (2,NULL,'New Company Added','2024-08-03 11:21:56','39','Company Unit'), (3,NULL,'User Logged In','2024-08-03 12:08:14','39','Login In'), (4,NULL,'User Logged In','2024-08-03 12:40:03','36','Login In'), (5,NULL,'Company Updated','2024-08-03 12:43:56','36','Company Unit'), (6,NULL,'Company Unit Approved','2024-08-03 12:47:53','36','Approval'), (7,NULL,'User Logged In','2024-08-03 12:50:13','39','Login In'), (8,NULL,'New Product Added','2024-08-03 12:54:21','39','Product'), (9,NULL,'New Product Added','2024-08-03 12:58:20','39','Product'), (10,NULL,'User Logged In','2024-08-03 13:02:08','37','Login In'), (11,NULL,'New Product Added','2024-08-03 13:04:29','39','Product'), (12,NULL,'User Logged Out','2024-08-03 13:06:28','37','Log Out'), (13,NULL,'New Product Added','2024-08-03 13:06:53','39','Product'), (14,NULL,'New Product Added','2024-08-03 13:10:05','39','Product'), (15,NULL,'New Product Added','2024-08-03 13:12:42','39','Product'), (16,NULL,'Product Updated','2024-08-03 13:14:19','39','Product'), (17,NULL,'User Logged In','2024-08-03 13:26:49','39','Login In'), (18,NULL,'Product Updated','2024-08-03 13:27:27','39','Product'), (19,NULL,'Product Updated','2024-08-03 13:28:14','39','Product'), (20,NULL,'User Logged In','2024-08-03 13:37:47','39','Login In'), (21,NULL,'User Logged In','2024-08-03 14:03:20','39','Login In'), (22,NULL,'User Logged In','2024-08-03 15:16:31','39','Login In'), (23,NULL,'User Logged In','2024-08-03 15:55:12','36','Login In'), (24,NULL,'User Logged In','2024-08-03 15:58:31','39','Login In'), (25,NULL,'User Logged In','2024-08-03 16:23:49','39','Login In'), (26,NULL,'New Product Added','2024-08-03 16:29:29','39','Product'), (27,NULL,'User Logged In','2024-08-03 16:31:57','37','Login In'), (28,NULL,'Product Approved','2024-08-03 16:33:10','37','Approval'), (29,NULL,'Product Approved','2024-08-03 16:33:41','37','Approval'), (30,NULL,'Product Approved','2024-08-03 16:36:24','37','Approval'), (31,NULL,'Product Approved','2024-08-03 16:38:19','37','Approval'), (32,NULL,'Product Updated','2024-08-03 16:43:31','39','Product'), (33,NULL,'User Logged Out','2024-08-03 16:43:34','37','Log Out'), (34,NULL,'User Logged In','2024-08-03 18:22:59','36','Login In'), (35,NULL,'User Logged In','2024-08-04 11:41:05','37','Login In'), (36,NULL,'User Logged In','2024-08-04 12:39:57','39','Login In'), (37,NULL,'User Logged In','2024-08-04 12:55:20','37','Login In'), (38,NULL,'Product Approved','2024-08-04 12:59:43','37','Approval'), (39,NULL,'Product Rejected','2024-08-04 13:03:26','37','Approval'), (40,NULL,'Product Approved','2024-08-04 13:07:16','37','Approval'), (41,NULL,'Product Updated','2024-08-04 13:08:22','39','Product'), (42,NULL,'User Logged In','2024-08-04 14:31:37','37','Login In'), (43,NULL,'Product Approved','2024-08-04 14:31:49','37','Approval'), (44,NULL,'User Logged In','2024-08-06 12:05:10','39','Login In'), (45,NULL,'Batch Added','2024-08-06 12:07:13','39','Batch'), (46,NULL,'Batch Updated','2024-08-06 12:09:55','39','Batch'), (47,NULL,'User Logged In','2024-08-07 11:54:04','39','Login In'), (48,NULL,'Batch Added','2024-08-07 11:56:35','39','Batch'), (49,NULL,'Batch Added','2024-08-07 11:58:02','39','Batch'), (50,NULL,'Batch Updated','2024-08-07 12:00:21','39','Batch'), (51,NULL,'Batch Updated','2024-08-07 12:00:29','39','Batch'), (52,NULL,'User Logged In','2024-08-09 12:06:33','39','Login In'), (53,NULL,'Batch Data Deleted','2024-08-09 12:06:48','39','Batch'), (54,NULL,'Batch Data Deleted','2024-08-09 12:06:52','39','Batch'), (55,NULL,'Batch Data Deleted','2024-08-09 12:06:55','39','Batch'), (56,NULL,'Batch Added','2024-08-09 12:08:25','39','Batch'), (57,NULL,'Batch Added','2024-08-09 12:09:18','39','Batch'), (58,NULL,'Batch Added','2024-08-09 12:09:59','39','Batch'), (59,NULL,'Batch Added','2024-08-09 12:10:43','39','Batch'), (60,NULL,'Batch Added','2024-08-09 12:11:29','39','Batch'), (61,NULL,'User Logged In','2024-08-09 16:11:09','37','Login In'), (62,NULL,'Batch Delete Approved','2024-08-09 16:12:02','37','Approval'), (63,NULL,'Batch Delete Approved','2024-08-09 16:12:31','37','Approval'), (64,NULL,'Batch Delete Approved','2024-08-09 16:12:53','37','Approval'), (65,NULL,'Batch Approved','2024-08-09 16:14:10','37','Approval'), (66,NULL,'Batch Approved','2024-08-09 16:14:53','37','Approval'), (67,NULL,'Batch Approved','2024-08-09 16:15:42','37','Approval'), (68,NULL,'Batch Approved','2024-08-09 16:16:25','37','Approval'), (69,NULL,'Batch Approved','2024-08-09 16:16:43','37','Approval'), (70,NULL,'User Logged Out','2024-08-09 16:17:27','37','Log Out'), (71,NULL,'User Logged In','2024-08-10 12:44:41','39','Login In'), (72,NULL,'Alias Product Added','2024-08-10 12:45:56','39','Alias Product'), (73,NULL,'Alias Product Added','2024-08-10 12:47:08','39','Alias Product'), (74,NULL,'User Logged In','2024-08-10 13:44:57','39','Login In'), (75,NULL,'User Logged In','2024-08-10 16:42:52','37','Login In'), (76,NULL,'Alias Product Approved','2024-08-10 16:45:02','37','Approval'), (77,NULL,'Alias Product Approved','2024-08-10 16:45:04','37','Approval'), (78,NULL,'User Logged Out','2024-08-10 16:45:12','37','Log Out'), (79,NULL,'User Logged In','2024-08-11 15:05:32','39','Login In'), (80,NULL,'Storage Condition Added','2024-08-11 15:07:16','39','Storage Condition'), (81,NULL,'User Logged In','2024-08-11 15:58:31','39','Login In'), (82,NULL,'User Logged In','2024-08-11 16:11:03','37','Login In'), (83,NULL,'Storage Condition Approved','2024-08-11 16:12:16','37','Storage Condition'), (84,NULL,'User Logged Out','2024-08-11 16:12:23','37','Log Out'), (85,NULL,'QR generated','2024-08-11 16:13:17','39','Generateqr'), (86,NULL,'User Logged In','2024-08-11 16:15:33','37','Login In'), (87,NULL,'Generateqr Approved','2024-08-11 16:16:38','37','Approval'), (88,NULL,'User Logged Out','2024-08-11 16:16:53','37','Log Out'), (89,NULL,'Single Print Had Taken','2024-08-11 16:17:02','39','generateqrsr'), (90,NULL,'Single Print Had Taken','2024-08-11 16:17:30','39','generateqrsr'), (91,NULL,'Single Print Had Taken','2024-08-11 16:18:25','39','generateqrsr'), (92,NULL,'Single Print Had Taken','2024-08-11 16:18:42','39','generateqrsr'), (93,NULL,'Single Print Had Taken','2024-08-11 16:34:49','39','generateqrsr'), (94,NULL,'Storage Condition Edited','2024-08-11 16:39:25','39','Storage Condition'), (95,NULL,'User Logged Out','2024-08-11 16:59:14','39','Log Out'), (96,NULL,'User Logged In','2024-08-11 16:59:16','39','Login In'), (97,NULL,'Single Print Had Taken','2024-08-11 16:59:36','39','generateqrsr'), (98,NULL,'User Logged In','2024-08-11 17:08:32','36','Login In'), (99,NULL,'Single Print Had Taken','2024-08-11 17:09:38','36','generateqrsr'), (100,NULL,'Multiple Print Had Taken','2024-08-11 17:10:28','36','generateqrsr'), (101,NULL,'User Logged In','2024-08-12 16:31:35','36','Login In'), (102,NULL,'Single Print Had Taken','2024-08-12 16:32:15','36','generateqrsr'), (103,NULL,'Multiple Print Had Taken','2024-08-12 16:32:28','36','generateqrsr'), (104,NULL,'Single Print Had Taken','2024-08-12 16:51:50','36','generateqrsr'), (105,NULL,'Single Print Had Taken','2024-08-12 16:55:45','36','generateqrsr'), (106,NULL,'Multiple Print Had Taken','2024-08-12 16:55:59','36','generateqrsr'), (107,NULL,'User Logged In','2024-08-14 11:51:23','39','Login In'), (108,NULL,'Single Print Had Taken','2024-08-14 11:51:41','39','generateqrsr'), (109,NULL,'Single Print Had Taken','2024-08-14 11:51:43','39','generateqrsr'), (110,NULL,'User Logged In','2024-08-14 13:30:45','39','Login In'), (111,NULL,'User Logged In','2024-08-14 19:40:44','39','Login In'), (112,NULL,'Alias Product Added','2024-08-14 19:41:56','39','Alias Product'), (113,NULL,'User Logged In','2024-08-14 19:42:35','37','Login In'), (114,NULL,'Alias Product Approved','2024-08-14 19:42:48','37','Approval'), (115,NULL,'Single Print Had Taken','2024-08-14 19:46:11','39','generateqrsr'), (116,NULL,'Single Print Had Taken','2024-08-14 19:46:31','39','generateqrsr'), (117,NULL,'Single Print Had Taken','2024-08-14 19:47:06','39','generateqrsr'), (118,NULL,'Single Print Had Taken','2024-08-14 19:47:21','39','generateqrsr'), (119,NULL,'Single Print Had Taken','2024-08-14 19:47:43','39','generateqrsr'), (120,NULL,'Single Print Had Taken','2024-08-14 20:02:36','39','generateqrsr'), (121,NULL,'Single Print Had Taken','2024-08-14 20:02:55','39','generateqrsr'), (122,NULL,'Single Print Had Taken','2024-08-14 20:05:33','39','generateqrsr'), (123,NULL,'Single Print Had Taken','2024-08-14 20:05:57','39','generateqrsr'), (124,NULL,'Single Print Had Taken','2024-08-14 20:07:11','39','generateqrsr'), (125,NULL,'Single Print Had Taken','2024-08-14 20:07:26','39','generateqrsr'), (126,NULL,'Single Print Had Taken','2024-08-14 20:08:38','39','generateqrsr'), (127,NULL,'Single Print Had Taken','2024-08-14 20:12:57','39','generateqrsr'), (128,NULL,'Single Print Had Taken','2024-08-14 20:13:14','39','generateqrsr'), (129,NULL,'Multiple Print Had Taken','2024-08-14 20:17:36','39','generateqrsr'), (130,NULL,'User Logged In','2024-08-16 14:54:59','39','Login In'), (131,NULL,'Company Updated','2024-08-16 14:56:29','39','Company Unit'), (132,NULL,'Single Print Had Taken','2024-08-16 14:57:47','39','generateqrsr'), (133,NULL,'Single Print Had Taken','2024-08-16 14:58:29','39','generateqrsr'), (134,NULL,'Single Print Had Taken','2024-08-16 15:02:11','39','generateqrsr'), (135,NULL,'Single Print Had Taken','2024-08-16 15:02:24','39','generateqrsr'), (136,NULL,'User Logged In','2024-08-16 15:29:11','36','Login In'), (137,NULL,'Single Print Had Taken','2024-08-16 15:30:00','36','generateqrsr'), (138,NULL,'Multiple Print Had Taken','2024-08-16 15:31:44','36','generateqrsr'), (139,NULL,'User Logged In','2024-08-16 15:36:22','39','Login In'), (140,NULL,'Storage Condition Added','2024-08-16 15:37:38','39','Storage Condition'), (141,NULL,'Single Print Had Taken','2024-08-16 16:01:39','39','generateqrsr'), (142,NULL,'Multiple Print Had Taken','2024-08-16 16:09:05','39','generateqrsr'), (143,NULL,'Multiple Print Had Taken','2024-08-16 16:09:05','39','generateqrsr'), (144,NULL,'Single Print Had Taken','2024-08-16 16:09:24','39','generateqrsr'), (145,NULL,'Single Print Had Taken','2024-08-16 16:09:42','39','generateqrsr'), (146,NULL,'Single Print Had Taken','2024-08-16 16:11:20','39','generateqrsr'), (147,NULL,'Multiple Print Had Taken','2024-08-16 16:11:55','39','generateqrsr'), (148,NULL,'Single Print Had Taken','2024-08-16 16:12:35','39','generateqrsr'), (149,NULL,'Multiple Print Had Taken','2024-08-16 16:12:55','39','generateqrsr'), (150,NULL,'Multiple Print Had Taken','2024-08-16 16:13:52','39','generateqrsr'), (151,NULL,'Multiple Print Had Taken','2024-08-16 16:15:00','39','generateqrsr'), (152,NULL,'Single Print Had Taken','2024-08-16 16:16:42','39','generateqrsr'), (153,NULL,'Single Print Had Taken','2024-08-16 16:18:40','39','generateqrsr'), (154,NULL,'Single Print Had Taken','2024-08-16 16:22:53','39','generateqrsr'), (155,NULL,'Single Print Had Taken','2024-08-16 16:24:05','39','generateqrsr'), (156,NULL,'User Logged In','2024-08-16 16:38:23','39','Login In'), (157,NULL,'Single Print Had Taken','2024-08-16 16:38:59','39','generateqrsr'), (158,NULL,'Single Print Had Taken','2024-08-16 16:39:46','39','generateqrsr'), (159,NULL,'Single Print Had Taken','2024-08-16 16:40:28','39','generateqrsr'), (160,NULL,'Single Print Had Taken','2024-08-16 16:40:56','39','generateqrsr'), (161,NULL,'Multiple Print Had Taken','2024-08-16 16:42:00','39','generateqrsr'), (162,NULL,'User Logged In','2024-08-16 17:04:12','39','Login In'), (163,NULL,'User Logged In','2024-08-16 17:08:38','37','Login In'), (164,NULL,'Company Unit Approved','2024-08-16 17:09:25','37','Approval'), (165,NULL,'Storage Condition Approved','2024-08-16 17:10:45','37','Storage Condition'), (166,NULL,'User Logged Out','2024-08-16 17:10:52','37','Log Out'), (167,NULL,'User Logged In','2024-08-16 17:49:39','39','Login In'), (168,NULL,'Single Print Had Taken','2024-08-16 17:49:58','39','generateqrsr'), (169,NULL,'Single Print Had Taken','2024-08-16 17:51:03','39','generateqrsr'), (170,NULL,'Multiple Print Had Taken','2024-08-16 17:52:07','39','generateqrsr'), (171,NULL,'Single Print Had Taken','2024-08-16 17:52:50','39','generateqrsr'), (172,NULL,'User Logged In','2024-08-16 17:54:23','39','Login In'), (173,NULL,'Single Print Had Taken','2024-08-16 17:54:36','39','generateqrsr'), (174,NULL,'Single Print Had Taken','2024-08-16 17:54:51','39','generateqrsr'), (175,NULL,'Single Print Had Taken','2024-08-16 17:55:19','39','generateqrsr'), (176,NULL,'Single Print Had Taken','2024-08-16 17:55:35','39','generateqrsr'), (177,NULL,'Single Print Had Taken','2024-08-16 17:55:52','39','generateqrsr'), (178,NULL,'Single Print Had Taken','2024-08-16 17:56:12','39','generateqrsr'), (179,NULL,'Single Print Had Taken','2024-08-16 17:56:36','39','generateqrsr'), (180,NULL,'Single Print Had Taken','2024-08-16 17:57:10','39','generateqrsr'), (181,NULL,'Single Print Had Taken','2024-08-16 17:57:21','39','generateqrsr'), (182,NULL,'Single Print Had Taken','2024-08-16 17:57:32','39','generateqrsr'), (183,NULL,'Single Print Had Taken','2024-08-16 17:57:43','39','generateqrsr'), (184,NULL,'Single Print Had Taken','2024-08-16 17:57:56','39','generateqrsr'), (185,NULL,'Single Print Had Taken','2024-08-16 17:58:09','39','generateqrsr'), (186,NULL,'Single Print Had Taken','2024-08-16 17:58:25','39','generateqrsr'), (187,NULL,'Single Print Had Taken','2024-08-16 17:58:44','39','generateqrsr'), (188,NULL,'Single Print Had Taken','2024-08-16 17:59:05','39','generateqrsr'), (189,NULL,'Single Print Had Taken','2024-08-16 17:59:32','39','generateqrsr'), (190,NULL,'Single Print Had Taken','2024-08-16 17:59:46','39','generateqrsr'), (191,NULL,'Single Print Had Taken','2024-08-16 18:00:05','39','generateqrsr'), (192,NULL,'Single Print Had Taken','2024-08-16 18:00:37','39','generateqrsr'), (193,NULL,'Single Print Had Taken','2024-08-16 18:00:56','39','generateqrsr'), (194,NULL,'Single Print Had Taken','2024-08-16 18:01:44','39','generateqrsr'), (195,NULL,'User Logged In','2024-08-16 18:24:52','39','Login In'), (196,NULL,'User Logged In','2024-08-17 10:40:35','39','Login In'), (197,NULL,'Batch Added','2024-08-17 10:46:21','39','Batch'), (198,NULL,'User Logged In','2024-08-17 11:12:01','39','Login In'), (199,NULL,'User Logged In','2024-08-17 11:12:39','37','Login In'), (200,NULL,'Batch Approved','2024-08-17 11:13:51','37','Approval'), (201,NULL,'Alias Product Delete Approved','2024-08-17 11:16:53','37','Approval'), (202,NULL,'Alias Product Added','2024-08-17 11:18:39','39','Alias Product'), (203,NULL,'Alias Product Approved','2024-08-17 11:18:53','37','Approval'), (204,NULL,'Storage Condition Added','2024-08-17 11:19:33','39','Storage Condition'), (205,NULL,'Storage Condition Approved','2024-08-17 11:23:26','37','Storage Condition'), (206,NULL,'QR generated','2024-08-17 11:25:29','39','Generateqr'), (207,NULL,'User Logged In','2024-08-17 11:26:10','37','Login In'), (208,NULL,'Generateqr Approved','2024-08-17 11:28:08','37','Approval'), (209,NULL,'Single Print Had Taken','2024-08-17 11:28:31','39','generateqrsr'), (210,NULL,'Single Print Had Taken','2024-08-17 11:47:00','39','generateqrsr'), (211,NULL,'Single Print Had Taken','2024-08-17 11:47:20','39','generateqrsr'), (212,NULL,'User Logged In','2024-08-17 12:07:49','39','Login In'), (213,NULL,'QR generated','2024-08-17 12:10:06','39','Generateqr'), (214,NULL,'User Logged In','2024-08-17 13:23:35','37','Login In'), (215,NULL,'Generateqr Approved','2024-08-17 13:24:01','37','Approval'), (216,NULL,'User Logged In','2024-08-17 13:55:53','39','Login In'), (217,NULL,'Single Print Had Taken','2024-08-17 13:59:18','39','generateqrsr'), (218,NULL,'Multiple Print Had Taken','2024-08-17 14:01:05','39','generateqrsr'), (219,NULL,'User Logged In','2024-08-17 14:24:38','39','Login In'), (220,NULL,'Single Print Had Taken','2024-08-17 14:24:50','39','generateqrsr'), (221,NULL,'Single Print Had Taken','2024-08-17 14:25:27','39','generateqrsr'), (222,NULL,'Single Print Had Taken','2024-08-17 14:25:44','39','generateqrsr'), (223,NULL,'Single Print Had Taken','2024-08-17 14:26:03','39','generateqrsr'), (224,NULL,'Single Print Had Taken','2024-08-17 14:26:14','39','generateqrsr'), (225,NULL,'Single Print Had Taken','2024-08-17 14:26:25','39','generateqrsr'), (226,NULL,'Single Print Had Taken','2024-08-17 14:26:56','39','generateqrsr'), (227,NULL,'Single Print Had Taken','2024-08-17 14:27:26','39','generateqrsr'), (228,NULL,'Single Print Had Taken','2024-08-17 14:27:39','39','generateqrsr'), (229,NULL,'Single Print Had Taken','2024-08-17 14:27:49','39','generateqrsr'), (230,NULL,'Single Print Had Taken','2024-08-17 14:28:04','39','generateqrsr'), (231,NULL,'Single Print Had Taken','2024-08-17 14:28:25','39','generateqrsr'), (232,NULL,'Single Print Had Taken','2024-08-17 14:28:46','39','generateqrsr'), (233,NULL,'Single Print Had Taken','2024-08-17 14:28:58','39','generateqrsr'), (234,NULL,'User Logged In','2024-08-21 11:32:09','39','Login In'), (235,NULL,'QR generated','2024-08-21 11:33:58','39','Generateqr'), (236,NULL,'QR generated','2024-08-21 11:34:37','39','Generateqr'), (237,NULL,'User Logged In','2024-08-21 11:49:01','37','Login In'), (238,NULL,'Generateqr Approved','2024-08-21 11:49:27','37','Approval'), (239,NULL,'Generateqr Approved','2024-08-21 11:49:46','37','Approval'), (240,NULL,'User Logged Out','2024-08-21 11:49:49','37','Log Out'), (241,NULL,'Single Print Had Taken','2024-08-21 11:52:04','39','generateqrsr'), (242,NULL,'Multiple Print Had Taken','2024-08-21 11:53:07','39','generateqrsr'), (243,NULL,'Single Print Had Taken','2024-08-21 11:54:54','39','generateqrsr'), (244,NULL,'Single Print Had Taken','2024-08-21 11:55:31','39','generateqrsr'), (245,NULL,'Single Print Had Taken','2024-08-21 11:55:41','39','generateqrsr'), (246,NULL,'User Logged In','2024-08-21 18:32:38','36','Login In'), (247,NULL,'User Logged In','2024-08-21 18:39:20','36','Login In'), (248,NULL,'User Logged In','2024-08-21 19:11:29','36','Login In'), (249,NULL,'User Logged Out','2024-08-21 19:11:34','36','Log Out'), (250,NULL,'User Logged In','2024-08-22 18:52:08','39','Login In'), (251,NULL,'User Logged In','2024-08-23 15:04:52','39','Login In'), (252,NULL,'Storage Condition Added','2024-08-23 15:07:55','39','Storage Condition'), (253,NULL,'User Logged In','2024-08-24 15:03:41','39','Login In'), (254,NULL,'User Logged In','2024-08-24 15:05:21','37','Login In'), (255,NULL,'Storage Condition Approved','2024-08-24 15:08:14','37','Storage Condition'), (256,NULL,'User Logged In','2024-08-24 15:21:41','37','Login In'), (257,NULL,'Storage Condition Approved','2024-08-24 15:21:47','37','Storage Condition'), (258,NULL,'QR generated','2024-08-24 15:28:16','39','Generateqr'), (259,NULL,'User Logged In','2024-08-24 15:29:21','37','Login In'), (260,NULL,'Generateqr Approved','2024-08-24 15:29:48','37','Approval'), (261,NULL,'User Logged Out','2024-08-24 15:37:56','39','Log Out'), (262,NULL,'User Logged In','2024-08-24 15:37:57','39','Login In'), (263,NULL,'Single Print Had Taken','2024-08-24 15:43:14','39','generateqrsr'), (264,NULL,'User Logged In','2024-08-24 15:53:24','37','Login In'), (265,NULL,'Generateqr Approved','2024-08-24 15:53:43','37','Approval'), (266,NULL,'User Logged Out','2024-08-24 15:53:50','37','Log Out'), (267,NULL,'User Logged In','2024-08-24 15:54:24','37','Login In'), (268,NULL,'Generateqr Approved','2024-08-24 15:54:41','37','Approval'), (269,NULL,'User Logged Out','2024-08-24 15:54:45','39','Log Out'), (270,NULL,'User Logged In','2024-08-24 15:54:47','39','Login In'), (271,NULL,'User Logged Out','2024-08-24 15:54:58','37','Log Out'), (272,NULL,'User Logged In','2024-08-24 15:55:18','37','Login In'), (273,NULL,'Single Print Had Taken','2024-08-24 15:55:18','39','generateqrsr'), (274,NULL,'User Logged Out','2024-08-24 15:55:28','37','Log Out'), (275,NULL,'Single Print Had Taken','2024-08-24 15:55:37','39','generateqrsr'), (276,NULL,'Single Print Had Taken','2024-08-24 15:55:58','39','generateqrsr'), (277,NULL,'User Logged In','2024-08-24 16:52:50','37','Login In'), (278,NULL,'User Logged Out','2024-08-24 16:53:34','37','Log Out'), (279,NULL,'User Logged In','2024-08-24 16:53:36','36','Login In'), (280,NULL,'User Logged In','2024-09-14 13:15:36','39','Login In'), (281,NULL,'QR generated','2024-09-14 13:26:24','39','Generateqr'), (282,NULL,'User Logged In','2024-09-14 15:35:20','39','Login In'), (283,NULL,'Batch Added','2024-09-14 15:40:50','39','Batch'), (284,NULL,'QR generated','2024-09-14 15:42:06','39','Generateqr'), (285,NULL,'Batch Added','2024-09-14 15:52:14','39','Batch'), (286,NULL,'User Logged In','2024-09-14 15:53:37','37','Login In'), (287,NULL,'Generateqr Approved','2024-09-14 15:55:28','37','Approval'), (288,NULL,'Batch Approved','2024-09-14 15:55:52','37','Approval'), (289,NULL,'Generateqr Approved','2024-09-14 15:56:17','37','Approval'), (290,NULL,'Batch Approved','2024-09-14 15:56:58','37','Approval'), (291,NULL,'User Logged Out','2024-09-14 15:58:44','37','Log Out'), (292,NULL,'QR generated','2024-09-14 15:59:00','39','Generateqr'), (293,NULL,'User Logged In','2024-09-14 15:59:07','37','Login In'), (294,NULL,'Generateqr Approved','2024-09-14 15:59:55','37','Approval'), (295,NULL,'User Logged Out','2024-09-14 16:00:14','37','Log Out'), (296,NULL,'User Logged In','2024-09-14 16:48:28','39','Login In'), (297,NULL,'QR Deleted','2024-09-14 17:36:38','39','Generateqr'), (298,NULL,'Multiple Print Had Taken','2024-09-14 17:37:05','39','generateqrsr'), (299,NULL,'User Logged In','2024-09-14 17:38:11','39','Login In'), (300,NULL,'Multiple Print Had Taken','2024-09-14 17:38:42','39','generateqrsr'), (301,NULL,'QR generated','2024-09-14 17:42:43','39','Generateqr'), (302,NULL,'User Logged In','2024-09-14 17:43:09','37','Login In'), (303,NULL,'Generateqr Approved','2024-09-14 17:43:26','37','Approval'), (304,NULL,'Multiple Print Had Taken','2024-09-14 17:44:18','39','generateqrsr'), (305,NULL,'QR generated','2024-09-14 17:48:34','39','Generateqr'), (306,NULL,'Generateqr Approved','2024-09-14 17:48:47','37','Approval'), (307,NULL,'Multiple Print Had Taken','2024-09-14 17:49:01','39','generateqrsr'), (308,NULL,'User Logged In','2024-09-14 18:09:46','39','Login In'), (309,NULL,'Multiple Print Had Taken','2024-09-14 18:09:57','39','generateqrsr'), (310,NULL,'User Logged In','2024-09-17 12:56:35','39','Login In'), (311,NULL,'User Logged In','2024-09-17 14:50:18','36','Login In'), (312,NULL,'Single Print Had Taken','2024-09-17 15:02:48','36','generateqrsr'), (313,NULL,'Multiple Print Had Taken','2024-09-17 15:03:10','36','generateqrsr'), (314,NULL,'New Product Added','2024-09-17 15:07:20','36','Product'), (315,NULL,'Product Approved','2024-09-17 15:07:44','36','Approval'), (316,NULL,'Batch Added','2024-09-17 15:08:16','36','Batch'), (317,NULL,'Batch Approved','2024-09-17 15:08:25','36','Approval'), (318,NULL,'Alias Product Added','2024-09-17 15:08:41','36','Alias Product'), (319,NULL,'Alias Product Approved','2024-09-17 15:08:48','36','Approval'), (320,NULL,'Storage Condition Added','2024-09-17 15:09:13','36','Storage Condition'), (321,NULL,'Storage Condition Approved','2024-09-17 15:09:21','36','Storage Condition'), (322,NULL,'QR generated','2024-09-17 15:09:48','36','Generateqr'), (323,NULL,'Generateqr Approved','2024-09-17 15:10:00','36','Approval'), (324,NULL,'Single Print Had Taken','2024-09-17 15:10:44','36','generateqrsr'), (325,NULL,'User Logged In','2024-09-17 15:32:45','36','Login In'), (326,NULL,'User Logged In','2024-09-18 19:16:18','36','Login In'), (327,NULL,'User Logged In','2024-09-20 18:40:27','36','Login In'), (328,NULL,'User Logged In','2024-09-27 13:39:59','39','Login In'), (329,NULL,'Batch Added','2024-09-27 13:42:25','39','Batch'), (330,NULL,'User Logged In','2024-09-27 16:33:06','37','Login In'), (331,NULL,'Batch Approved','2024-09-27 16:34:59','37','Approval'), (332,NULL,'User Logged Out','2024-09-27 16:35:44','37','Log Out'), (333,NULL,'User Logged In','2024-10-01 11:56:51','36','Login In'), (334,NULL,'User Logged In','2024-10-01 17:58:09','39','Login In'), (335,NULL,'User Logged In','2024-10-02 13:44:12','36','Login In'), (336,NULL,'User Logged In','2024-10-03 18:30:16','39','Login In'), (337,NULL,'QR generated','2024-10-03 18:33:00','39','Generateqr'), (338,NULL,'QR generated','2024-10-03 18:34:20','39','Generateqr'), (339,NULL,'QR generated','2024-10-03 18:34:51','39','Generateqr'), (340,NULL,'QR generated','2024-10-03 18:36:08','39','Generateqr'), (341,NULL,'QR generated','2024-10-03 18:36:49','39','Generateqr'), (342,NULL,'Batch Added','2024-10-03 18:38:17','39','Batch'), (343,NULL,'Batch Added','2024-10-03 18:39:16','39','Batch'), (344,NULL,'Batch Added','2024-10-03 18:41:45','39','Batch'), (345,NULL,'QR generated','2024-10-03 18:43:38','39','Generateqr'), (346,NULL,'QR generated','2024-10-03 18:44:24','39','Generateqr'), (347,NULL,'Batch Added','2024-10-03 18:45:30','39','Batch'), (348,NULL,'Batch Added','2024-10-03 18:46:08','39','Batch'), (349,NULL,'Batch Data Deleted','2024-10-03 18:46:37','39','Batch'), (350,NULL,'Batch Updated','2024-10-03 18:47:42','39','Batch'), (351,NULL,'Batch Added','2024-10-03 18:50:09','39','Batch'), (352,NULL,'Batch Added','2024-10-03 18:50:51','39','Batch'), (353,NULL,'Batch Added','2024-10-03 18:51:56','39','Batch'), (354,NULL,'Batch Added','2024-10-03 18:52:40','39','Batch'), (355,NULL,'Batch Added','2024-10-03 18:53:14','39','Batch'), (356,NULL,'User Logged In','2024-10-04 10:57:44','39','Login In'), (357,NULL,'Alias Product Added','2024-10-04 11:00:08','39','Alias Product'), (358,NULL,'User Logged In','2024-10-04 11:00:44','37','Login In'), (359,NULL,'Alias Product Approved','2024-10-04 11:01:25','37','Approval'), (360,NULL,'Batch Added','2024-10-04 11:03:16','39','Batch'), (361,NULL,'Batch Approved','2024-10-04 11:03:38','37','Approval'), (362,NULL,'Batch Added','2024-10-04 11:09:35','39','Batch'), (363,NULL,'Batch Updated','2024-10-04 11:09:52','39','Batch'), (364,NULL,'Batch Added','2024-10-04 11:10:33','39','Batch'), (365,NULL,'Batch Added','2024-10-04 11:11:15','39','Batch'), (366,NULL,'Batch Added','2024-10-04 11:11:52','39','Batch'), (367,NULL,'Batch Added','2024-10-04 11:13:35','39','Batch'), (368,NULL,'Batch Added','2024-10-04 11:15:22','39','Batch'), (369,NULL,'Batch Added','2024-10-04 11:17:26','39','Batch'), (370,NULL,'Batch Added','2024-10-04 11:18:08','39','Batch'), (371,NULL,'Batch Added','2024-10-04 11:18:40','39','Batch'), (372,NULL,'Batch Data Deleted','2024-10-04 11:21:02','39','Batch'), (373,NULL,'Product Updated','2024-10-04 11:22:54','39','Product'), (374,NULL,'Alias Product Added','2024-10-04 11:24:01','39','Alias Product'), (375,NULL,'Storage Condition Edited','2024-10-04 11:24:55','39','Storage Condition'), (376,NULL,'Storage Condition Added','2024-10-04 11:25:59','39','Storage Condition'), (377,NULL,'Storage Condition Deleted','2024-10-04 11:26:15','39','Storage Condition'), (378,NULL,'Storage Condition Added','2024-10-04 11:26:40','39','Storage Condition'), (379,NULL,'Storage Condition Added','2024-10-04 11:27:45','39','Storage Condition'), (380,NULL,'Storage Condition Added','2024-10-04 11:28:15','39','Storage Condition'), (381,NULL,'Storage Condition Added','2024-10-04 11:28:49','39','Storage Condition'), (382,NULL,'Storage Condition Added','2024-10-04 11:29:17','39','Storage Condition'), (383,NULL,'Customer Added','2024-10-04 11:54:02','39','Customer'), (384,NULL,'Customer Added','2024-10-04 11:57:57','39','Customer'), (385,NULL,'Customer Added','2024-10-04 12:01:16','39','Customer'), (386,NULL,'Customer Added','2024-10-04 12:02:54','39','Customer'), (387,NULL,'Customer Added','2024-10-04 12:04:18','39','Customer'), (388,NULL,'Customer Added','2024-10-04 12:05:53','39','Customer'), (389,NULL,'Customer Added','2024-10-04 12:07:19','39','Customer'), (390,NULL,'Customer Added','2024-10-04 12:08:47','39','Customer'), (391,NULL,'Customer Added','2024-10-04 12:10:58','39','Customer'), (392,NULL,'Customer Added','2024-10-04 12:12:31','39','Customer'), (393,NULL,'Customer Added','2024-10-04 12:14:29','39','Customer'), (394,NULL,'Customer Added','2024-10-04 12:16:26','39','Customer'), (395,NULL,'Customer Added','2024-10-04 12:19:07','39','Customer'), (396,NULL,'Customer Added','2024-10-04 12:20:57','39','Customer'), (397,NULL,'Customer Added','2024-10-04 12:24:16','39','Customer'), (398,NULL,'Customer Added','2024-10-04 12:25:04','39','Customer'), (399,NULL,'Customer Added','2024-10-04 12:28:17','39','Customer'), (400,NULL,'Customer Added','2024-10-04 12:34:31','39','Customer'), (401,NULL,'Customer Added','2024-10-04 12:39:13','39','Customer'), (402,NULL,'Customer Added','2024-10-04 12:41:12','39','Customer'), (403,NULL,'Customer Added','2024-10-04 12:43:03','39','Customer'), (404,NULL,'Customer Added','2024-10-04 12:45:02','39','Customer'), (405,NULL,'User Logged In','2024-10-04 12:46:36','37','Login In'), (406,NULL,'Product Approved','2024-10-04 12:46:53','37','Approval'), (407,NULL,'Batch Added','2024-10-04 12:48:01','39','Batch'), (408,NULL,'Batch Data Deleted','2024-10-04 12:48:10','39','Batch'), (409,NULL,'Customer Updated','2024-10-04 12:51:30','39','Customer'), (410,NULL,'User Logged In','2024-10-04 14:05:48','37','Login In'), (411,NULL,'Generateqr Approved','2024-10-04 14:08:00','37','Approval'), (412,NULL,'Batch Delete Approved','2024-10-04 14:08:38','37','Approval'), (413,NULL,'Storage Condition Approved','2024-10-04 14:08:58','37','Storage Condition'), (414,NULL,'Storage Condition Approved','2024-10-04 14:09:52','37','Storage Condition'), (415,NULL,'Storage Condition Approved','2024-10-04 14:10:10','37','Storage Condition'), (416,NULL,'Storage Condition Approved','2024-10-04 14:10:27','37','Storage Condition'), (417,NULL,'Storage Condition Rejected','2024-10-04 14:13:34','37','Approval'), (418,NULL,'Storage Condition Approved','2024-10-04 14:14:35','37','Storage Condition'), (419,NULL,'Alias Product Approved','2024-10-04 14:15:02','37','Approval'), (420,NULL,'Alias Product Delete Approved','2024-10-04 14:15:34','37','Approval'), (421,NULL,'User Logged In','2024-10-04 14:19:13','39','Login In'), (422,NULL,'Batch Delete Rejected','2024-10-04 14:20:08','37','Approval'), (423,NULL,'Batch Delete Rejected','2024-10-04 14:20:31','37','Approval'), (424,NULL,'Batch Approved','2024-10-04 14:21:11','37','Approval'), (425,NULL,'Batch Approved','2024-10-04 14:21:31','37','Approval'), (426,NULL,'Batch Approved','2024-10-04 14:22:14','37','Approval'), (427,NULL,'Batch Approved','2024-10-04 14:22:37','37','Approval'), (428,NULL,'Batch Approved','2024-10-04 14:23:31','37','Approval'), (429,NULL,'Batch Approved','2024-10-04 14:24:13','37','Approval'), (430,NULL,'Batch Approved','2024-10-04 14:25:05','37','Approval'), (431,NULL,'Batch Approved','2024-10-04 14:25:44','37','Approval'), (432,NULL,'Batch Approved','2024-10-04 14:26:12','37','Approval'), (433,NULL,'Batch Approved','2024-10-04 14:26:43','37','Approval'), (434,NULL,'Batch Approved','2024-10-04 14:27:02','37','Approval'), (435,NULL,'Batch Approved','2024-10-04 14:27:30','37','Approval'), (436,NULL,'Batch Approved','2024-10-04 14:27:37','37','Approval'), (437,NULL,'Batch Approved','2024-10-04 14:27:56','37','Approval'), (438,NULL,'Storage Condition Edited','2024-10-04 14:28:09','39','Storage Condition'), (439,NULL,'Storage Condition Updated','2024-10-04 14:28:14','39','Storage Condition'), (440,NULL,'Batch Approved','2024-10-04 14:29:08','37','Approval'), (441,NULL,'Storage Condition Approved','2024-10-04 14:29:39','37','Storage Condition'), (442,NULL,'Batch Approved','2024-10-04 14:30:12','37','Approval'), (443,NULL,'Batch Approved','2024-10-04 14:30:45','37','Approval'), (444,NULL,'Batch Delete Approved','2024-10-04 14:31:03','37','Approval'), (445,NULL,'Batch Approved','2024-10-04 14:31:51','37','Approval'), (446,NULL,'Batch Approved','2024-10-04 14:32:16','37','Approval'), (447,NULL,'Batch Approved','2024-10-04 14:32:35','37','Approval'), (448,NULL,'Batch Approved','2024-10-04 14:33:05','37','Approval'), (449,NULL,'Generateqr Approved','2024-10-04 14:33:49','37','Approval'), (450,NULL,'Generateqr Approved','2024-10-04 14:34:10','37','Approval'), (451,NULL,'Generateqr Approved','2024-10-04 14:34:35','37','Approval'), (452,NULL,'Generateqr Approved','2024-10-04 14:35:07','37','Approval'), (453,NULL,'Generateqr Approved','2024-10-04 14:35:25','37','Approval'), (454,NULL,'Generateqr Approved','2024-10-04 14:35:47','37','Approval'), (455,NULL,'Storage Condition Delete Approved','2024-10-04 14:50:58','37','Storage Condition'), (456,NULL,'User Logged Out','2024-10-04 14:51:45','37','Log Out'), (457,NULL,'User Logged In','2024-10-04 15:11:58','39','Login In'), (458,NULL,'QR generated','2024-10-04 15:17:18','39','Generateqr'), (459,NULL,'User Logged In','2024-10-04 16:05:24','38','Login In'), (460,NULL,'User Logged In','2024-10-04 16:07:14','39','Login In'), (461,NULL,'Customer Approved','2024-10-04 16:15:02','38','Approval'), (462,NULL,'Customer Approved','2024-10-04 16:15:06','38','Approval'), (463,NULL,'Customer Approved','2024-10-04 16:15:11','38','Approval'), (464,NULL,'Customer Approved','2024-10-04 16:15:13','38','Approval'), (465,NULL,'Customer Approved','2024-10-04 16:15:16','38','Approval'), (466,NULL,'Customer Approved','2024-10-04 16:15:20','38','Approval'), (467,NULL,'Customer Approved','2024-10-04 16:15:25','38','Approval'), (468,NULL,'Customer Approved','2024-10-04 16:15:28','38','Approval'), (469,NULL,'Customer Approved','2024-10-04 16:15:30','38','Approval'), (470,NULL,'Customer Approved','2024-10-04 16:15:39','38','Approval'), (471,NULL,'Customer Approved','2024-10-04 16:15:52','38','Approval'), (472,NULL,'Customer Approved','2024-10-04 16:15:55','38','Approval'), (473,NULL,'Customer Approved','2024-10-04 16:15:58','38','Approval'), (474,NULL,'Customer Approved','2024-10-04 16:16:03','38','Approval'), (475,NULL,'Customer Approved','2024-10-04 16:16:06','38','Approval'), (476,NULL,'Customer Approved','2024-10-04 16:16:08','38','Approval'), (477,NULL,'Customer Approved','2024-10-04 16:16:11','38','Approval'), (478,NULL,'Customer Approved','2024-10-04 16:16:13','38','Approval'), (479,NULL,'Customer Approved','2024-10-04 16:16:15','38','Approval'), (480,NULL,'Customer Approved','2024-10-04 16:16:18','38','Approval'), (481,NULL,'Customer Approved','2024-10-04 16:16:20','38','Approval'), (482,NULL,'Customer Approved','2024-10-04 16:16:23','38','Approval'), (483,NULL,'User Logged In','2024-10-04 19:22:09','39','Login In'), (484,NULL,'QR generated','2024-10-04 19:27:54','39','Generateqr'), (485,NULL,'User Logged In','2024-10-05 10:47:38','39','Login In'), (486,NULL,'QR generated','2024-10-05 10:58:02','39','Generateqr'), (487,NULL,'Lot Dispatched','2024-10-05 11:01:47','39','Dispatch'), (488,NULL,'User Logged Out','2024-10-05 11:09:00','39','Log Out'), (489,NULL,'User Logged In','2024-10-05 11:09:01','39','Login In'), (490,NULL,'Batch Updated','2024-10-05 11:10:08','39','Batch'), (491,NULL,'User Logged In','2024-10-05 11:10:45','37','Login In'), (492,NULL,'Batch Approved','2024-10-05 11:10:54','37','Approval'), (493,NULL,'QR generated','2024-10-05 11:12:01','39','Generateqr'), (494,NULL,'User Logged In','2024-10-05 11:19:15','39','Login In'), (495,NULL,'User Logged In','2024-10-05 11:51:15','37','Login In'), (496,NULL,'Generateqr Approved','2024-10-05 11:52:17','37','Approval'), (497,NULL,'Generateqr Approved','2024-10-05 11:52:45','37','Approval'), (498,NULL,'Generateqr Approved','2024-10-05 11:53:02','37','Approval'), (499,NULL,'Generateqr Approved','2024-10-05 11:53:21','37','Approval'), (500,NULL,'User Logged Out','2024-10-05 11:53:32','37','Log Out'), (501,NULL,'User Logged In','2024-10-05 11:55:49','39','Login In'), (502,NULL,'QR Deleted','2024-10-05 11:56:18','39','Generateqr'), (503,NULL,'Batch Added','2024-10-05 11:57:49','39','Batch'), (504,NULL,'User Logged Out','2024-10-05 11:58:04','39','Log Out'), (505,NULL,'User Logged In','2024-10-05 11:58:25','37','Login In'), (506,NULL,'Batch Approved','2024-10-05 11:58:32','37','Approval'), (507,NULL,'Batch Data Deleted','2024-10-05 11:59:02','39','Batch'), (508,NULL,'Batch Delete Approved','2024-10-05 11:59:28','37','Approval'), (509,NULL,'User Logged Out','2024-10-05 12:01:05','37','Log Out'), (510,NULL,'User Logged In','2024-10-05 12:01:07','39','Login In'), (511,NULL,'User Logged In','2024-10-05 12:01:50','39','Login In'), (512,NULL,'User Logged In','2024-10-05 12:02:24','39','Login In'), (513,NULL,'QR generated','2024-10-05 12:03:03','39','Generateqr'), (514,NULL,'User Logged Out','2024-10-05 12:03:18','39','Log Out'), (515,NULL,'User Logged In','2024-10-05 12:03:31','37','Login In'), (516,NULL,'Generateqr Approved','2024-10-05 12:03:41','37','Approval'), (517,NULL,'User Logged Out','2024-10-05 12:04:03','37','Log Out'), (518,NULL,'Multiple Print Had Taken','2024-10-05 12:04:14','37','generateqrsr'), (519,NULL,'User Logged In','2024-10-05 12:58:33','39','Login In'), (520,NULL,'Storage Condition Edited','2024-10-05 12:58:56','39','Storage Condition'), (521,NULL,'Storage Condition Updated','2024-10-05 12:59:05','39','Storage Condition'), (522,NULL,'User Logged Out','2024-10-05 12:59:19','39','Log Out'), (523,NULL,'User Logged In','2024-10-05 12:59:34','37','Login In'), (524,NULL,'Storage Condition Approved','2024-10-05 12:59:39','37','Storage Condition'), (525,NULL,'User Logged Out','2024-10-05 13:02:07','37','Log Out'), (526,NULL,'User Logged In','2024-10-05 13:02:09','39','Login In'), (527,NULL,'Storage Condition Edited','2024-10-05 13:02:18','39','Storage Condition'), (528,NULL,'User Logged In','2024-10-05 13:31:04','39','Login In'), (529,NULL,'QR generated','2024-10-05 13:31:44','39','Generateqr'), (530,NULL,'QR Deleted','2024-10-05 13:32:04','39','Generateqr'), (531,NULL,'Single Print Had Taken','2024-10-05 13:32:23','39','generateqrsr'), (532,NULL,'Single Print Had Taken','2024-10-05 13:33:19','39','generateqrsr'), (533,NULL,'User Logged In','2024-10-05 15:40:28','39','Login In'), (534,NULL,'QR generated','2024-10-05 15:41:11','39','Generateqr'), (535,NULL,'User Logged In','2024-10-05 17:17:42','39','Login In'), (536,NULL,'User Logged In','2024-10-05 18:02:29','39','Login In'), (537,NULL,'User Logged In','2024-10-05 18:08:15','37','Login In'), (538,NULL,'Generateqr Approved','2024-10-05 18:08:30','37','Approval'), (539,NULL,'Generateqr Approved','2024-10-05 18:08:39','37','Approval'), (540,NULL,'User Logged Out','2024-10-05 18:08:44','37','Log Out'), (541,NULL,'User Logged In','2024-10-06 18:24:46','37','Login In'), (542,NULL,'User Logged Out','2024-10-06 18:25:48','37','Log Out'), (543,NULL,'User Logged In','2024-10-07 15:54:09','39','Login In'), (544,NULL,'User Logged In','2024-10-08 10:44:41','39','Login In'), (545,NULL,'Single Print Had Taken','2024-10-08 10:45:15','39','generateqrsr'), (546,NULL,'User Logged In','2024-10-08 10:47:00','39','Login In'), (547,NULL,'Single Print Had Taken','2024-10-08 10:47:21','39','generateqrsr'), (548,NULL,'User Logged In','2024-10-08 14:03:32','39','Login In'), (549,NULL,'QR generated','2024-10-08 14:04:04','39','Generateqr'), (550,NULL,'User Logged Out','2024-10-08 14:04:19','39','Log Out'), (551,NULL,'User Logged In','2024-10-08 14:04:31','37','Login In'), (552,NULL,'Generateqr Approved','2024-10-08 14:04:37','37','Approval'), (553,NULL,'User Logged Out','2024-10-08 14:04:40','37','Log Out'), (554,NULL,'User Logged In','2024-10-08 14:04:46','39','Login In'), (555,NULL,'Single Print Had Taken','2024-10-08 14:05:46','39','generateqrsr'), (556,NULL,'User Logged In','2024-10-08 14:06:10','39','Login In'), (557,NULL,'Single Print Had Taken','2024-10-08 14:06:26','39','generateqrsr'), (558,NULL,'Single Print Had Taken','2024-10-08 14:06:54','39','generateqrsr'), (559,NULL,'User Logged In','2024-10-08 17:06:14','39','Login In'), (560,NULL,'QR generated','2024-10-08 17:07:11','39','Generateqr'), (561,NULL,'User Logged In','2024-10-08 17:07:48','37','Login In'), (562,NULL,'Generateqr Approved','2024-10-08 17:07:55','37','Approval'), (563,NULL,'Single Print Had Taken','2024-10-08 17:09:19','39','generateqrsr'), (564,NULL,'Single Print Had Taken','2024-10-08 17:09:40','39','generateqrsr'), (565,NULL,'User Logged In','2024-10-09 17:01:57','39','Login In'), (566,NULL,'QR generated','2024-10-09 17:02:58','39','Generateqr'), (567,NULL,'User Logged In','2024-10-09 17:20:19','37','Login In'), (568,NULL,'Generateqr Approved','2024-10-09 17:20:55','37','Approval'), (569,NULL,'User Logged Out','2024-10-09 17:21:35','37','Log Out'), (570,NULL,'Multiple Print Had Taken','2024-10-09 17:21:41','39','generateqrsr'), (571,NULL,'User Logged In','2024-10-09 18:06:55','39','Login In'), (572,NULL,'QR generated','2024-10-09 18:07:59','39','Generateqr'), (573,NULL,'User Logged Out','2024-10-09 18:08:14','39','Log Out'), (574,NULL,'User Logged In','2024-10-09 18:08:31','37','Login In'), (575,NULL,'Generateqr Approved','2024-10-09 18:08:36','37','Approval'), (576,NULL,'Single Print Had Taken','2024-10-09 18:08:53','37','generateqrsr'), (577,NULL,'User Logged In','2024-10-09 18:46:00','37','Login In'), (578,NULL,'User Logged In','2024-10-10 10:22:23','39','Login In'), (579,NULL,'Single Print Had Taken','2024-10-10 10:22:39','39','generateqrsr'), (580,NULL,'Single Print Had Taken','2024-10-10 10:23:03','39','generateqrsr'), (581,NULL,'User Logged In','2024-10-14 12:30:38','36','Login In'), (582,NULL,'User Logged In','2024-10-14 13:30:02','36','Login In'), (583,NULL,'User Updated','2024-10-14 13:30:41','36','Rights Management'), (584,NULL,'User Logged Out','2024-10-14 13:30:47','36','Log Out'), (585,NULL,'User Logged In','2024-10-14 13:30:53','36','Login In'), (586,NULL,'User Logged In','2024-10-15 11:29:25','39','Login In'), (587,NULL,'User Logged In','2024-10-15 11:39:45','36','Login In'), (588,NULL,'User Logged In','2024-10-15 11:52:07','39','Login In'), (589,NULL,'QR generated','2024-10-15 11:53:23','39','Generateqr'), (590,NULL,'QR generated','2024-10-15 11:54:16','39','Generateqr'), (591,NULL,'User Logged In','2024-10-15 12:03:04','37','Login In'), (592,NULL,'Generateqr Approved','2024-10-15 12:03:20','37','Approval'), (593,NULL,'Generateqr Approved','2024-10-15 12:03:31','37','Approval'), (594,NULL,'User Logged Out','2024-10-15 12:03:37','37','Log Out'), (595,NULL,'Single Print Had Taken','2024-10-15 12:29:13','39','generateqrsr'), (596,NULL,'Multiple Print Had Taken','2024-10-15 12:33:26','39','generateqrsr'), (597,NULL,'User Logged In','2024-10-15 16:44:08','39','Login In'), (598,NULL,'User Logged In','2024-10-15 19:41:57','36','Login In'), (599,NULL,'User Logged In','2024-10-16 11:05:38','39','Login In'), (600,NULL,'Single Print Had Taken','2024-10-16 11:06:01','39','generateqrsr'), (601,NULL,'User Logged In','2024-10-16 12:06:13','39','Login In'), (602,NULL,'Lot Dispatched','2024-10-16 12:11:22','39','Dispatch'), (603,NULL,'Lot Dispatched','2024-10-16 12:13:57','39','Dispatch'), (604,NULL,'Lot Dispatched','2024-10-16 12:15:46','39','Dispatch'), (605,NULL,'Lot Dispatched','2024-10-16 12:17:34','39','Dispatch'), (606,NULL,'Lot Dispatched','2024-10-16 12:19:48','39','Dispatch'), (607,NULL,'Lot Dispatched','2024-10-16 12:21:59','39','Dispatch'), (608,NULL,'Lot Dispatched','2024-10-16 12:23:58','39','Dispatch'), (609,NULL,'Lot Dispatched','2024-10-16 12:25:50','39','Dispatch'), (610,NULL,'User Logged Out','2024-10-16 12:30:56','39','Log Out'), (611,NULL,'User Logged In','2024-10-16 12:31:31','38','Login In'), (612,NULL,'Dispatch Approved','2024-10-16 12:31:52','38','Approval'), (613,NULL,'Dispatch Approved','2024-10-16 12:31:54','38','Approval'), (614,NULL,'Dispatch Approved','2024-10-16 12:31:57','38','Approval'), (615,NULL,'Dispatch Approved','2024-10-16 12:31:59','38','Approval'), (616,NULL,'Dispatch Approved','2024-10-16 12:32:02','38','Approval'), (617,NULL,'Dispatch Approved','2024-10-16 12:32:04','38','Approval'), (618,NULL,'Dispatch Approved','2024-10-16 12:32:06','38','Approval'), (619,NULL,'Dispatch Approved','2024-10-16 12:32:09','38','Approval'), (620,NULL,'Dispatch Approved','2024-10-16 12:32:11','38','Approval'), (621,NULL,'User Logged Out','2024-10-16 12:37:17','38','Log Out'), (622,NULL,'User Logged In','2024-10-16 12:37:21','39','Login In'), (623,NULL,'Lot Dispatched','2024-10-16 12:40:03','39','Dispatch'), (624,NULL,'Lot Dispatched Deleted','2024-10-16 12:46:58','39','Dispatch'), (625,NULL,'Lot Dispatched Data Updated','2024-10-16 12:48:37','39','Dispatch'), (626,NULL,'Lot Dispatched','2024-10-16 12:49:40','39','Dispatch'), (627,NULL,'Lot Dispatched','2024-10-16 12:50:21','39','Dispatch'), (628,NULL,'QR generated','2024-10-16 12:51:22','39','Generateqr'), (629,NULL,'User Logged In','2024-10-16 12:52:01','37','Login In'), (630,NULL,'Generateqr Approved','2024-10-16 12:52:16','37','Approval'), (631,NULL,'Lot Dispatched','2024-10-16 12:53:33','39','Dispatch'), (632,NULL,'Lot Dispatched','2024-10-16 13:00:16','39','Dispatch'), (633,NULL,'QR Deleted','2024-10-16 13:00:42','39','Generateqr'), (634,NULL,'Lot Dispatched','2024-10-16 13:02:33','39','Dispatch'), (635,NULL,'QR generated','2024-10-16 13:22:49','39','Generateqr'), (636,NULL,'QR generated','2024-10-16 13:23:33','39','Generateqr'), (637,NULL,'QR generated','2024-10-16 13:24:04','39','Generateqr'), (638,NULL,'QR generated','2024-10-16 13:24:52','39','Generateqr'), (639,NULL,'QR generated','2024-10-16 13:25:32','39','Generateqr'), (640,NULL,'User Logged Out','2024-10-16 13:26:51','39','Log Out'), (641,NULL,'User Logged In','2024-10-16 13:27:07','37','Login In'), (642,NULL,'Generateqr Approved','2024-10-16 13:27:23','37','Approval'), (643,NULL,'Generateqr Approved','2024-10-16 13:27:25','37','Approval'), (644,NULL,'Generateqr Approved','2024-10-16 13:27:29','37','Approval'), (645,NULL,'Generateqr Approved','2024-10-16 13:27:30','37','Approval'), (646,NULL,'Generateqr Approved','2024-10-16 13:27:32','37','Approval'), (647,NULL,'User Logged In','2024-10-16 13:27:40','39','Login In'), (648,NULL,'QR generated','2024-10-16 13:30:50','39','Generateqr'), (649,NULL,'Generateqr Approved','2024-10-16 13:30:57','37','Approval'), (650,NULL,'Lot Dispatched','2024-10-16 13:34:14','39','Dispatch'), (651,NULL,'Lot Dispatched','2024-10-16 13:35:44','39','Dispatch'), (652,NULL,'Lot Dispatched','2024-10-16 13:37:35','39','Dispatch'), (653,NULL,'Lot Dispatched','2024-10-16 13:38:50','39','Dispatch'), (654,NULL,'QR generated','2024-10-16 13:41:57','39','Generateqr'), (655,NULL,'QR generated','2024-10-16 13:42:26','39','Generateqr'), (656,NULL,'QR generated','2024-10-16 13:42:56','39','Generateqr'), (657,NULL,'QR generated','2024-10-16 13:43:29','39','Generateqr'), (658,NULL,'QR Deleted','2024-10-16 13:44:30','39','Generateqr'), (659,NULL,'QR generated','2024-10-16 13:45:25','39','Generateqr'), (660,NULL,'Generateqr Approved','2024-10-16 13:46:12','37','Approval'), (661,NULL,'Generateqr Approved','2024-10-16 13:46:14','37','Approval'), (662,NULL,'Generateqr Approved','2024-10-16 13:46:15','37','Approval'), (663,NULL,'Generateqr Approved','2024-10-16 13:46:17','37','Approval'), (664,NULL,'Generateqr Approved','2024-10-16 13:46:18','37','Approval'), (665,NULL,'Lot Dispatched','2024-10-16 13:49:55','39','Dispatch'), (666,NULL,'Lot Dispatched','2024-10-16 13:54:51','39','Dispatch'), (667,NULL,'Lot Dispatched','2024-10-16 13:56:00','39','Dispatch'), (668,NULL,'Lot Dispatched','2024-10-16 13:56:59','39','Dispatch'), (669,NULL,'Lot Dispatched','2024-10-16 13:58:17','39','Dispatch'), (670,NULL,'Lot Dispatched','2024-10-16 13:59:34','39','Dispatch'), (671,NULL,'User Logged In','2024-10-18 13:08:46','39','Login In'), (672,NULL,'QR generated','2024-10-18 13:24:36','39','Generateqr'), (673,NULL,'QR generated','2024-10-18 13:25:29','39','Generateqr'), (674,NULL,'QR generated','2024-10-18 13:29:55','39','Generateqr'), (675,NULL,'User Logged In','2024-10-18 13:30:54','37','Login In'), (676,NULL,'Generateqr Approved','2024-10-18 13:31:15','37','Approval'), (677,NULL,'Generateqr Approved','2024-10-18 13:31:26','37','Approval'), (678,NULL,'Generateqr Approved','2024-10-18 13:31:38','37','Approval'), (679,NULL,'User Logged Out','2024-10-18 13:31:51','37','Log Out'), (680,NULL,'Single Print Had Taken','2024-10-18 13:33:34','39','generateqrsr'), (681,NULL,'Single Print Had Taken','2024-10-18 13:33:49','39','generateqrsr'), (682,NULL,'Single Print Had Taken','2024-10-18 13:34:02','39','generateqrsr'), (683,NULL,'Single Print Had Taken','2024-10-18 13:34:23','39','generateqrsr'), (684,NULL,'User Logged In','2024-10-18 13:59:46','39','Login In'), (685,NULL,'Multiple Print Had Taken','2024-10-18 14:00:04','39','generateqrsr'), (686,NULL,'Multiple Print Had Taken','2024-10-18 14:01:48','39','generateqrsr'), (687,NULL,'Multiple Print Had Taken','2024-10-18 14:03:23','39','generateqrsr'), (688,NULL,'Multiple Print Had Taken','2024-10-18 14:04:11','39','generateqrsr'), (689,NULL,'User Logged In','2024-10-18 18:40:07','39','Login In'), (690,NULL,'User Logged In','2024-10-19 11:43:38','39','Login In'), (691,NULL,'QR generated','2024-10-19 11:45:39','39','Generateqr'), (692,NULL,'QR generated','2024-10-19 11:47:44','39','Generateqr'), (693,NULL,'QR generated','2024-10-19 11:48:58','39','Generateqr'), (694,NULL,'User Logged In','2024-10-19 12:00:27','37','Login In'), (695,NULL,'Generateqr Approved','2024-10-19 12:00:50','37','Approval'), (696,NULL,'Generateqr Approved','2024-10-19 12:01:04','37','Approval'), (697,NULL,'Generateqr Approved','2024-10-19 12:01:31','37','Approval'), (698,NULL,'User Logged Out','2024-10-19 12:01:45','37','Log Out'), (699,NULL,'User Logged In','2024-10-19 12:47:18','39','Login In'), (700,NULL,'Single Print Had Taken','2024-10-19 12:48:24','39','generateqrsr'), (701,NULL,'Multiple Print Had Taken','2024-10-19 12:48:36','39','generateqrsr'), (702,NULL,'Single Print Had Taken','2024-10-19 12:48:53','39','generateqrsr'), (703,NULL,'Single Print Had Taken','2024-10-19 12:49:10','39','generateqrsr'), (704,NULL,'Single Print Had Taken','2024-10-19 12:49:25','39','generateqrsr'), (705,NULL,'Multiple Print Had Taken','2024-10-19 12:50:27','39','generateqrsr'), (706,NULL,'Multiple Print Had Taken','2024-10-19 12:52:15','39','generateqrsr'), (707,NULL,'Multiple Print Had Taken','2024-10-19 12:54:16','39','generateqrsr'), (708,NULL,'User Logged In','2024-10-19 16:49:05','36','Login In'), (709,NULL,'User Updated','2024-10-19 16:50:44','36','Rights Management'), (710,NULL,'User Logged In','2024-10-20 17:23:39','39','Login In'), (711,NULL,'QR generated','2024-10-20 17:24:57','39','Generateqr'), (712,NULL,'User Logged In','2024-10-22 11:27:37','37','Login In'), (713,NULL,'Generateqr Approved','2024-10-22 11:28:00','37','Approval'), (714,NULL,'User Logged Out','2024-10-22 11:30:49','37','Log Out'), (715,NULL,'User Logged In','2024-10-22 12:45:55','39','Login In'), (716,NULL,'Lot Dispatched','2024-10-22 12:51:14','39','Dispatch'), (717,NULL,'User Logged Out','2024-10-22 12:51:32','39','Log Out'), (718,NULL,'User Logged In','2024-10-22 12:57:41','38','Login In'), (719,NULL,'Dispatch Approved','2024-10-22 13:11:21','38','Approval'), (720,NULL,'Dispatch Approved','2024-10-22 13:11:23','38','Approval'), (721,NULL,'Dispatch Approved','2024-10-22 13:11:25','38','Approval'), (722,NULL,'Dispatch Approved','2024-10-22 13:11:29','38','Approval'), (723,NULL,'Dispatch Approved','2024-10-22 13:11:31','38','Approval'), (724,NULL,'Dispatch Approved','2024-10-22 13:11:33','38','Approval'), (725,NULL,'Dispatch Approved','2024-10-22 13:11:35','38','Approval'), (726,NULL,'Dispatch Approved','2024-10-22 13:11:43','38','Approval'), (727,NULL,'Dispatch Approved','2024-10-22 13:11:45','38','Approval'), (728,NULL,'Dispatch Approved','2024-10-22 13:11:48','38','Approval'), (729,NULL,'Dispatch Approved','2024-10-22 13:11:51','38','Approval'), (730,NULL,'Dispatch Approved','2024-10-22 13:11:53','38','Approval'), (731,NULL,'Dispatch Approved','2024-10-22 13:11:55','38','Approval'), (732,NULL,'Dispatch Approved','2024-10-22 13:11:57','38','Approval'), (733,NULL,'Dispatch Approved','2024-10-22 13:11:58','38','Approval'), (734,NULL,'Dispatch Approved','2024-10-22 13:12:00','38','Approval'), (735,NULL,'Dispatch Approved','2024-10-22 13:12:02','38','Approval'), (736,NULL,'User Logged In','2024-10-22 13:14:27','39','Login In'), (737,NULL,'QR generated','2024-10-22 13:16:21','39','Generateqr'), (738,NULL,'User Logged Out','2024-10-22 13:16:48','38','Log Out'), (739,NULL,'User Logged In','2024-10-22 13:17:04','37','Login In'), (740,NULL,'Generateqr Approved','2024-10-22 13:17:09','37','Approval'), (741,NULL,'Lot Dispatched','2024-10-22 13:19:16','39','Dispatch'), (742,NULL,'User Logged Out','2024-10-22 13:19:53','39','Log Out'), (743,NULL,'User Logged In','2024-10-22 13:20:25','38','Login In'), (744,NULL,'Dispatch Approved','2024-10-22 13:20:34','38','Approval'), (745,NULL,'Lot Dispatched Deleted','2024-10-22 13:25:22','38','Dispatch'), (746,NULL,'User Logged Out','2024-10-22 13:27:02','38','Log Out'), (747,NULL,'User Logged In','2024-10-22 13:27:05','39','Login In'), (748,NULL,'Lot Dispatched','2024-10-22 13:29:42','39','Dispatch'), (749,NULL,'User Logged Out','2024-10-22 13:30:09','39','Log Out'), (750,NULL,'User Logged In','2024-10-22 13:30:12','38','Login In'), (751,NULL,'Dispatch Delete Approved','2024-10-22 13:30:17','38','Approval'), (752,NULL,'Dispatch Approved','2024-10-22 13:30:25','38','Approval'), (753,NULL,'User Logged Out','2024-10-22 13:31:02','38','Log Out'), (754,NULL,'User Logged In','2024-10-22 13:31:04','39','Login In'), (755,NULL,'Lot Dispatched Deleted','2024-10-22 13:31:41','39','Dispatch'), (756,NULL,'User Logged Out','2024-10-22 13:31:45','39','Log Out'), (757,NULL,'User Logged In','2024-10-22 13:31:48','38','Login In'), (758,NULL,'Dispatch Delete Approved','2024-10-22 13:31:54','38','Approval'), (759,NULL,'User Logged Out','2024-10-22 13:31:57','38','Log Out'), (760,NULL,'User Logged In','2024-10-22 13:32:00','39','Login In'), (761,NULL,'User Logged In','2024-10-22 15:32:25','39','Login In'), (762,NULL,'QR generated','2024-10-22 15:34:36','39','Generateqr'), (763,NULL,'QR generated','2024-10-22 15:35:16','39','Generateqr'), (764,NULL,'User Logged In','2024-10-22 15:53:08','37','Login In'), (765,NULL,'Generateqr Approved','2024-10-22 15:53:32','37','Approval'), (766,NULL,'Generateqr Approved','2024-10-22 15:53:42','37','Approval'), (767,NULL,'User Logged Out','2024-10-22 15:54:08','37','Log Out'), (768,NULL,'Single Print Had Taken','2024-10-22 15:56:26','39','generateqrsr'), (769,NULL,'Single Print Had Taken','2024-10-22 15:57:32','39','generateqrsr'), (770,NULL,'Single Print Had Taken','2024-10-22 15:57:55','39','generateqrsr'), (771,NULL,'Multiple Print Had Taken','2024-10-22 15:58:07','39','generateqrsr'), (772,NULL,'User Logged In','2024-10-22 18:08:48','39','Login In'), (773,NULL,'Multiple Print Had Taken','2024-10-22 18:09:45','39','generateqrsr'), (774,NULL,'Multiple Print Had Taken','2024-10-22 18:10:15','39','generateqrsr'), (775,NULL,'User Logged In','2024-10-23 11:45:20','39','Login In'), (776,NULL,'QR generated','2024-10-23 11:46:09','39','Generateqr'), (777,NULL,'Multiple Print Had Taken','2024-10-23 12:12:15','39','generateqrsr'), (778,NULL,'Single Print Had Taken','2024-10-23 12:12:44','39','generateqrsr'), (779,NULL,'Multiple Print Had Taken','2024-10-23 12:13:07','39','generateqrsr'), (780,NULL,'User Logged In','2024-10-23 12:22:12','37','Login In'), (781,NULL,'Generateqr Approved','2024-10-23 12:22:33','37','Approval'), (782,NULL,'User Logged Out','2024-10-23 12:23:07','37','Log Out'), (783,NULL,'Single Print Had Taken','2024-10-23 12:37:44','39','generateqrsr'), (784,NULL,'User Logged In','2024-10-23 16:32:24','36','Login In'), (785,NULL,'User Updated','2024-10-23 16:33:25','36','Rights Management'), (786,NULL,'User Updated','2024-10-23 16:34:59','36','Rights Management'), (787,NULL,'User Updated','2024-10-23 16:35:21','36','Rights Management'), (788,NULL,'User Logged Out','2024-10-23 16:54:39','36','Log Out'), (789,NULL,'User Logged In','2024-10-24 10:34:41','39','Login In'), (790,NULL,'Product Updated','2024-10-24 10:35:46','39','Product'), (791,NULL,'User Logged In','2024-10-24 10:36:49','37','Login In'), (792,NULL,'User Logged In','2024-10-24 10:37:16','37','Login In'), (793,NULL,'Product Approved','2024-10-24 10:37:24','37','Approval'), (794,NULL,'User Logged Out','2024-10-24 10:37:33','37','Log Out'), (795,NULL,'Multiple Print Had Taken','2024-10-24 10:38:14','39','generateqrsr'), (796,NULL,'Multiple Print Had Taken','2024-10-24 10:39:05','39','generateqrsr'), (797,NULL,'Multiple Print Had Taken','2024-10-24 10:39:57','39','generateqrsr'), (798,NULL,'Multiple Print Had Taken','2024-10-24 10:41:01','39','generateqrsr'), (799,NULL,'User Logged In','2024-10-24 11:12:19','37','Login In'), (800,NULL,'User Logged Out','2024-10-24 11:12:31','37','Log Out'), (801,NULL,'User Logged In','2024-10-24 13:48:20','39','Login In'), (802,NULL,'Product Updated','2024-10-24 13:51:21','39','Product'), (803,NULL,'Product Updated','2024-10-24 13:52:12','39','Product'), (804,NULL,'Dispatch Delete Approved','2024-10-24 13:56:19','37','Approval'), (805,NULL,'User Logged In','2024-10-24 13:56:45','38','Login In'), (806,NULL,'Lot Dispatched','2024-10-24 14:00:17','39','Dispatch'), (807,NULL,'Dispatch Approved','2024-10-24 14:00:27','38','Approval'), (808,NULL,'Lot Dispatched Deleted','2024-10-24 14:13:01','39','Dispatch'), (809,NULL,'Dispatch Delete Approved','2024-10-24 14:14:05','38','Approval'), (810,NULL,'Lot Dispatched','2024-10-24 14:15:26','39','Dispatch'), (811,NULL,'Dispatch Approved','2024-10-24 14:15:49','38','Approval'), (812,NULL,'Lot Dispatched Deleted','2024-10-24 14:16:30','39','Dispatch'), (813,NULL,'Dispatch Delete Approved','2024-10-24 14:16:41','38','Approval'), (814,NULL,'User Logged In','2024-10-24 14:27:39','39','Login In'), (815,NULL,'User Logged In','2024-10-24 16:05:38','37','Login In'), (816,NULL,'User Logged Out','2024-10-24 16:06:25','37','Log Out'), (817,NULL,'User Logged In','2024-10-24 17:34:53','39','Login In'), (818,NULL,'QR generated','2024-10-24 17:36:32','39','Generateqr'), (819,NULL,'QR generated','2024-10-24 17:37:07','39','Generateqr'), (820,NULL,'QR generated','2024-10-24 17:39:29','39','Generateqr'), (821,NULL,'User Logged In','2024-10-24 17:42:41','37','Login In'), (822,NULL,'Generateqr Approved','2024-10-24 17:42:56','37','Approval'), (823,NULL,'Generateqr Approved','2024-10-24 17:43:00','37','Approval'), (824,NULL,'Generateqr Approved','2024-10-24 17:43:08','37','Approval'), (825,NULL,'Multiple Print Had Taken','2024-10-24 17:44:48','39','generateqrsr'), (826,NULL,'Multiple Print Had Taken','2024-10-24 17:46:28','39','generateqrsr'), (827,NULL,'Multiple Print Had Taken','2024-10-24 17:47:17','39','generateqrsr'), (828,NULL,'User Logged In','2024-10-25 13:54:22','39','Login In'), (829,NULL,'Product Updated','2024-10-25 13:55:50','39','Product'), (830,NULL,'Product Updated','2024-10-25 14:01:50','39','Product'), (831,NULL,'User Logged In','2024-10-25 16:05:44','39','Login In'), (832,NULL,'QR generated','2024-10-25 16:06:29','39','Generateqr'), (833,NULL,'QR generated','2024-10-25 16:07:13','39','Generateqr'), (834,NULL,'User Logged In','2024-10-25 17:30:37','39','Login In'), (835,NULL,'User Logged In','2024-10-25 17:32:15','37','Login In'), (836,NULL,'Generateqr Approved','2024-10-25 17:32:56','37','Approval'), (837,NULL,'Generateqr Approved','2024-10-25 17:32:58','37','Approval'), (838,NULL,'Product Approved','2024-10-25 17:33:25','37','Approval'), (839,NULL,'QR generated','2024-10-25 17:34:25','39','Generateqr'), (840,NULL,'Generateqr Approved','2024-10-25 17:37:05','37','Approval'), (841,NULL,'Multiple Print Had Taken','2024-10-25 17:38:51','39','generateqrsr'), (842,NULL,'Multiple Print Had Taken','2024-10-25 17:51:28','39','generateqrsr'), (843,NULL,'Multiple Print Had Taken','2024-10-25 17:53:19','39','generateqrsr'), (844,NULL,'User Logged In','2024-10-25 18:36:49','39','Login In'), (845,NULL,'Lot Dispatched','2024-10-25 18:48:00','39','Dispatch'), (846,NULL,'Customer Added','2024-10-25 18:50:12','39','Customer'), (847,NULL,'User Logged In','2024-10-25 18:50:47','38','Login In'), (848,NULL,'Dispatch Approved','2024-10-25 18:50:56','38','Approval'), (849,NULL,'Customer Approved','2024-10-25 18:50:58','38','Approval'), (850,NULL,'Lot Dispatched','2024-10-25 18:52:10','39','Dispatch'), (851,NULL,'Customer Added','2024-10-25 18:54:32','39','Customer'), (852,NULL,'Customer Approved','2024-10-25 18:54:47','38','Approval'), (853,NULL,'Dispatch Approved','2024-10-25 18:54:50','38','Approval'), (854,NULL,'Lot Dispatched','2024-10-25 18:56:03','39','Dispatch'), (855,NULL,'Dispatch Approved','2024-10-25 18:57:36','38','Approval'), (856,NULL,'Lot Dispatched Data Updated','2024-10-25 19:02:56','39','Dispatch'), (857,NULL,'Dispatch Approved','2024-10-25 19:03:09','38','Approval'), (858,NULL,'QR Deleted','2024-10-25 19:04:41','39','Generateqr'), (859,NULL,'QR Deleted','2024-10-25 19:05:24','39','Generateqr'), (860,NULL,'Lot Dispatched','2024-10-25 19:07:22','39','Dispatch'), (861,NULL,'Lot Dispatched','2024-10-25 19:08:36','39','Dispatch'), (862,NULL,'Customer Added','2024-10-25 19:11:01','39','Customer'), (863,NULL,'Dispatch Approved','2024-10-25 19:11:36','38','Approval'), (864,NULL,'Dispatch Approved','2024-10-25 19:11:38','38','Approval'), (865,NULL,'Customer Approved','2024-10-25 19:11:39','38','Approval'), (866,NULL,'User Logged In','2024-10-27 08:51:23','39','Login In'), (867,NULL,'Single Print Had Taken','2024-10-27 08:57:48','39','generateqrsr'), (868,NULL,'Single Print Had Taken','2024-10-27 08:58:29','39','generateqrsr'), (869,NULL,'Single Print Had Taken','2024-10-27 08:58:42','39','generateqrsr'), (870,NULL,'Single Print Had Taken','2024-10-27 08:59:13','39','generateqrsr'), (871,NULL,'Single Print Had Taken','2024-10-27 09:00:04','39','generateqrsr'), (872,NULL,'Single Print Had Taken','2024-10-27 09:00:33','39','generateqrsr'), (873,NULL,'Single Print Had Taken','2024-10-27 09:01:13','39','generateqrsr'), (874,NULL,'Single Print Had Taken','2024-10-27 09:02:17','39','generateqrsr'), (875,NULL,'Single Print Had Taken','2024-10-27 09:03:01','39','generateqrsr'), (876,NULL,'Single Print Had Taken','2024-10-27 09:03:24','39','generateqrsr'), (877,NULL,'User Logged In','2024-10-27 12:18:06','39','Login In'), (878,NULL,'QR generated','2024-10-27 12:18:48','39','Generateqr'), (879,NULL,'User Logged In','2024-10-27 12:29:30','37','Login In'), (880,NULL,'Product Approved','2024-10-27 12:30:03','37','Approval'), (881,NULL,'Product Approved','2024-10-27 12:30:41','37','Approval'), (882,NULL,'Generateqr Approved','2024-10-27 12:32:57','37','Approval'), (883,NULL,'User Logged Out','2024-10-27 12:33:58','37','Log Out'), (884,NULL,'Single Print Had Taken','2024-10-27 12:37:49','39','generateqrsr'), (885,NULL,'User Logged In','2024-10-29 13:36:04','36','Login In'), (886,NULL,'User Logged In','2024-10-29 15:16:59','39','Login In'), (887,NULL,'Single Print Had Taken','2024-10-29 15:17:25','39','generateqrsr'), (888,NULL,'Single Print Had Taken','2024-10-29 15:18:54','39','generateqrsr'), (889,NULL,'Multiple Print Had Taken','2024-10-29 15:46:01','39','generateqrsr'), (890,NULL,'User Logged In','2024-10-30 15:46:36','39','Login In'), (891,NULL,'User Logged In','2024-10-30 16:37:50','37','Login In'), (892,NULL,'User Logged In','2024-10-30 17:32:48','39','Login In'), (893,NULL,'Batch Added','2024-10-30 17:34:10','39','Batch'), (894,NULL,'Batch Added','2024-10-30 17:35:18','39','Batch'), (895,NULL,'User Logged In','2024-10-30 17:35:30','37','Login In'), (896,NULL,'Batch Approved','2024-10-30 17:35:58','37','Approval'), (897,NULL,'Batch Approved','2024-10-30 17:36:12','37','Approval'), (898,NULL,'User Logged Out','2024-10-30 17:36:18','37','Log Out'), (899,NULL,'QR generated','2024-10-30 17:41:51','39','Generateqr'), (900,NULL,'User Logged In','2024-10-30 18:34:07','39','Login In'), (901,NULL,'User Logged In','2024-10-30 18:36:43','37','Login In'), (902,NULL,'Generateqr Approved','2024-10-30 18:36:57','37','Approval'), (903,NULL,'Multiple Print Had Taken','2024-10-30 18:37:23','39','generateqrsr'), (904,NULL,'Single Print Had Taken','2024-10-30 18:37:42','39','generateqrsr'), (905,NULL,'Multiple Print Had Taken','2024-10-30 18:38:28','39','generateqrsr'), (906,NULL,'User Logged In','2024-10-31 11:32:05','37','Login In'), (907,NULL,'Product Approved','2024-10-31 11:32:33','37','Approval'), (908,NULL,'User Logged Out','2024-10-31 11:32:38','37','Log Out'), (909,NULL,'User Logged In','2024-10-31 12:05:04','39','Login In'), (910,NULL,'QR generated','2024-10-31 12:12:18','39','Generateqr'), (911,NULL,'User Logged In','2024-10-31 12:31:13','37','Login In'), (912,NULL,'Generateqr Approved','2024-10-31 12:31:47','37','Approval'), (913,NULL,'User Logged In','2024-10-31 12:31:58','37','Login In'), (914,NULL,'User Logged Out','2024-10-31 12:32:02','37','Log Out'), (915,NULL,'User Logged In','2024-10-31 12:44:40','39','Login In'), (916,NULL,'Multiple Print Had Taken','2024-10-31 12:46:42','39','generateqrsr'), (917,NULL,'Single Print Had Taken','2024-10-31 12:47:22','39','generateqrsr'), (918,NULL,'Single Print Had Taken','2024-10-31 12:47:55','39','generateqrsr'), (919,NULL,'User Logged In','2024-10-31 12:49:51','39','Login In'), (920,NULL,'Single Print Had Taken','2024-10-31 12:50:05','39','generateqrsr'), (921,NULL,'Single Print Had Taken','2024-10-31 12:51:33','39','generateqrsr'), (922,NULL,'Single Print Had Taken','2024-10-31 12:52:51','39','generateqrsr'), (923,NULL,'Single Print Had Taken','2024-10-31 12:56:03','39','generateqrsr'), (924,NULL,'User Logged In','2024-11-02 11:48:02','36','Login In'), (925,NULL,'User Logged In','2024-11-05 19:03:28','39','Login In'), (926,NULL,'Batch Added','2024-11-05 19:04:27','39','Batch'), (927,NULL,'Storage Condition Added','2024-11-05 19:05:50','39','Storage Condition'), (928,NULL,'Batch Added','2024-11-05 19:08:31','39','Batch'), (929,NULL,'Alias Product Added','2024-11-05 19:09:07','39','Alias Product'), (930,NULL,'Storage Condition Added','2024-11-05 19:09:59','39','Storage Condition'), (931,NULL,'User Logged In','2024-11-06 15:41:51','39','Login In'), (932,NULL,'User Logged In','2024-11-06 15:44:26','37','Login In'), (933,NULL,'Storage Condition Approved','2024-11-06 15:50:38','37','Storage Condition'), (934,NULL,'Storage Condition Approved','2024-11-06 15:50:51','37','Storage Condition'), (935,NULL,'Alias Product Approved','2024-11-06 15:53:10','37','Approval'), (936,NULL,'Storage Condition Approved','2024-11-06 15:53:37','37','Storage Condition'), (937,NULL,'Batch Rejected','2024-11-06 15:57:39','37','Approval'), (938,NULL,'User Logged Out','2024-11-06 15:59:17','37','Log Out'), (939,NULL,'User Logged In','2024-11-06 16:08:05','39','Login In'), (940,NULL,'User Logged In','2024-11-06 16:10:44','37','Login In'), (941,NULL,'User Logged In','2024-11-06 16:30:10','39','Login In'), (942,NULL,'User Logged In','2024-11-06 18:08:21','39','Login In'), (943,NULL,'Batch Added','2024-11-06 18:09:28','39','Batch'), (944,NULL,'Batch Updated','2024-11-06 18:12:14','39','Batch'), (945,NULL,'Batch Added','2024-11-06 18:13:11','39','Batch'), (946,NULL,'Batch Added','2024-11-06 18:14:57','39','Batch'), (947,NULL,'User Logged In','2024-11-06 18:34:51','37','Login In'), (948,NULL,'Batch Approved','2024-11-06 18:35:17','37','Approval'), (949,NULL,'Batch Approved','2024-11-06 18:36:12','37','Approval'), (950,NULL,'Batch Approved','2024-11-06 18:36:34','37','Approval'), (951,NULL,'Batch Approved','2024-11-06 18:36:58','37','Approval'), (952,NULL,'Batch Approved','2024-11-06 18:37:13','37','Approval'), (953,NULL,'Batch Approved','2024-11-06 18:37:36','37','Approval'), (954,NULL,'User Logged Out','2024-11-06 18:37:43','37','Log Out'), (955,NULL,'QR generated','2024-11-06 18:38:25','39','Generateqr'), (956,NULL,'QR generated','2024-11-06 18:39:03','39','Generateqr'), (957,NULL,'QR generated','2024-11-06 18:40:00','39','Generateqr'), (958,NULL,'QR generated','2024-11-06 18:40:53','39','Generateqr'), (959,NULL,'QR generated','2024-11-06 18:41:32','39','Generateqr'), (960,NULL,'QR generated','2024-11-06 18:44:18','39','Generateqr'), (961,NULL,'QR generated','2024-11-06 18:45:15','39','Generateqr'), (962,NULL,'User Logged In','2024-11-07 10:50:16','39','Login In'), (963,NULL,'User Logged In','2024-11-07 11:09:30','37','Login In'), (964,NULL,'Generateqr Approved','2024-11-07 11:09:48','37','Approval'), (965,NULL,'Generateqr Approved','2024-11-07 11:10:00','37','Approval'), (966,NULL,'Generateqr Approved','2024-11-07 11:10:17','37','Approval'), (967,NULL,'Generateqr Approved','2024-11-07 11:10:29','37','Approval'), (968,NULL,'Generateqr Approved','2024-11-07 11:10:44','37','Approval'), (969,NULL,'Generateqr Approved','2024-11-07 11:10:53','37','Approval'), (970,NULL,'Generateqr Approved','2024-11-07 11:11:07','37','Approval'), (971,NULL,'User Logged Out','2024-11-07 11:11:13','37','Log Out'), (972,NULL,'Single Print Had Taken','2024-11-07 11:20:15','39','generateqrsr'), (973,NULL,'User Logged In','2024-11-07 11:21:27','39','Login In'), (974,NULL,'Single Print Had Taken','2024-11-07 11:21:48','39','generateqrsr'), (975,NULL,'Single Print Had Taken','2024-11-07 11:22:45','39','generateqrsr'), (976,NULL,'Multiple Print Had Taken','2024-11-07 11:23:48','39','generateqrsr'), (977,NULL,'Single Print Had Taken','2024-11-07 11:25:26','39','generateqrsr'), (978,NULL,'Single Print Had Taken','2024-11-07 11:26:17','39','generateqrsr'), (979,NULL,'Multiple Print Had Taken','2024-11-07 11:27:29','39','generateqrsr'), (980,NULL,'Single Print Had Taken','2024-11-07 11:28:57','39','generateqrsr'), (981,NULL,'Multiple Print Had Taken','2024-11-07 11:32:29','39','generateqrsr'), (982,NULL,'Multiple Print Had Taken','2024-11-07 11:32:48','39','generateqrsr'), (983,NULL,'Multiple Print Had Taken','2024-11-07 11:33:25','39','generateqrsr'), (984,NULL,'Single Print Had Taken','2024-11-07 11:36:25','39','generateqrsr'), (985,NULL,'User Logged In','2024-11-07 13:08:42','39','Login In'), (986,NULL,'User Logged In','2024-11-07 16:40:21','39','Login In'), (987,NULL,'QR generated','2024-11-07 16:41:27','39','Generateqr'), (988,NULL,'User Logged In','2024-11-07 17:01:07','37','Login In'), (989,NULL,'Generateqr Approved','2024-11-07 17:01:25','37','Approval'), (990,NULL,'User Logged Out','2024-11-07 17:01:30','37','Log Out'), (991,NULL,'User Logged In','2024-11-07 17:08:02','39','Login In'), (992,NULL,'Single Print Had Taken','2024-11-07 17:10:19','39','generateqrsr'), (993,NULL,'Single Print Had Taken','2024-11-07 17:11:23','39','generateqrsr'), (994,NULL,'User Logged In','2024-11-07 17:12:04','39','Login In'), (995,NULL,'User Logged Out','2024-11-07 17:12:27','39','Log Out'), (996,NULL,'User Logged In','2024-11-07 17:12:30','39','Login In'), (997,NULL,'Single Print Had Taken','2024-11-07 17:12:42','39','generateqrsr'), (998,NULL,'User Logged In','2024-11-08 10:38:08','39','Login In'), (999,NULL,'User Logged In','2024-11-08 10:38:47','39','Login In'), (1000,NULL,'Single Print Had Taken','2024-11-08 10:39:21','39','generateqrsr'), (1001,NULL,'Single Print Had Taken','2024-11-08 10:39:56','39','generateqrsr'), (1002,NULL,'Single Print Had Taken','2024-11-08 10:40:17','39','generateqrsr'), (1003,NULL,'User Logged In','2024-11-08 11:49:44','36','Login In'), (1004,NULL,'User Logged In','2024-11-10 15:28:33','39','Login In'), (1005,NULL,'QR generated','2024-11-10 15:30:05','39','Generateqr'), (1006,NULL,'User Logged In','2024-11-10 16:56:35','39','Login In'), (1007,NULL,'Storage Condition Added','2024-11-10 16:58:05','39','Storage Condition'), (1008,NULL,'User Logged In','2024-11-10 16:58:43','39','Login In'), (1009,NULL,'User Logged Out','2024-11-10 16:58:46','39','Log Out'), (1010,NULL,'User Logged In','2024-11-10 16:58:56','37','Login In'), (1011,NULL,'Storage Condition Approved','2024-11-10 16:59:12','37','Storage Condition'), (1012,NULL,'QR generated','2024-11-10 16:59:51','39','Generateqr'), (1013,NULL,'User Logged In','2024-11-10 17:02:50','37','Login In'), (1014,NULL,'Generateqr Approved','2024-11-10 17:05:26','37','Approval'), (1015,NULL,'Generateqr Approved','2024-11-10 17:05:47','37','Approval'), (1016,NULL,'User Logged Out','2024-11-10 17:05:55','37','Log Out'), (1017,NULL,'Single Print Had Taken','2024-11-10 17:20:01','39','generateqrsr'), (1018,NULL,'Single Print Had Taken','2024-11-10 17:20:51','39','generateqrsr'), (1019,NULL,'Single Print Had Taken','2024-11-10 17:21:09','39','generateqrsr'), (1020,NULL,'User Logged In','2024-11-12 12:58:30','39','Login In'), (1021,NULL,'QR generated','2024-11-12 12:59:31','39','Generateqr'), (1022,NULL,'QR generated','2024-11-12 13:00:22','39','Generateqr'), (1023,NULL,'Alias Product Added','2024-11-12 13:04:29','39','Alias Product'), (1024,NULL,'User Logged In','2024-11-12 13:05:54','37','Login In'), (1025,NULL,'Alias Product Approved','2024-11-12 13:06:08','null','Approval'), (1026,NULL,'Batch Added','2024-11-12 13:09:33','39','Batch'), (1027,NULL,'Batch Added','2024-11-12 13:10:07','39','Batch'), (1028,NULL,'QR generated','2024-11-12 13:11:02','39','Generateqr'), (1029,NULL,'Batch Added','2024-11-12 13:12:42','39','Batch'), (1030,NULL,'User Logged Out','2024-11-12 13:13:06','37','Log Out'), (1031,NULL,'User Logged In','2024-11-12 14:34:08','37','Login In'), (1032,NULL,'Generateqr Approved','2024-11-12 14:34:23','37','Approval'), (1033,NULL,'Generateqr Approved','2024-11-12 14:34:39','37','Approval'), (1034,NULL,'Batch Approved','2024-11-12 14:34:56','37','Approval'), (1035,NULL,'Batch Approved','2024-11-12 14:35:10','37','Approval'), (1036,NULL,'Generateqr Approved','2024-11-12 14:35:19','37','Approval'), (1037,NULL,'Batch Approved','2024-11-12 14:35:34','37','Approval'), (1038,NULL,'User Logged Out','2024-11-12 14:35:40','37','Log Out'), (1039,NULL,'User Logged In','2024-11-12 15:05:26','39','Login In'), (1040,NULL,'Storage Condition Added','2024-11-12 15:07:40','39','Storage Condition'), (1041,NULL,'User Logged In','2024-11-12 15:08:17','37','Login In'), (1042,NULL,'Storage Condition Approved','2024-11-12 15:08:38','37','Storage Condition'), (1043,NULL,'User Logged Out','2024-11-12 15:08:43','37','Log Out'), (1044,NULL,'QR generated','2024-11-12 15:11:01','39','Generateqr'), (1045,NULL,'QR generated','2024-11-12 15:11:42','39','Generateqr'), (1046,NULL,'User Logged In','2024-11-12 16:30:44','39','Login In'), (1047,NULL,'User Logged In','2024-11-12 16:30:44','39','Login In'), (1048,NULL,'Single Print Had Taken','2024-11-12 16:31:43','39','generateqrsr'), (1049,NULL,'User Logged In','2024-11-12 16:41:14','37','Login In'), (1050,NULL,'Generateqr Approved','2024-11-12 16:41:28','37','Approval'), (1051,NULL,'Generateqr Approved','2024-11-12 16:41:35','37','Approval'), (1052,NULL,'User Logged In','2024-11-12 17:12:00','39','Login In'), (1053,NULL,'Multiple Print Had Taken','2024-11-12 17:12:49','39','generateqrsr'), (1054,NULL,'Multiple Print Had Taken','2024-11-12 17:14:04','39','generateqrsr'), (1055,NULL,'Multiple Print Had Taken','2024-11-12 17:14:23','39','generateqrsr'), (1056,NULL,'Multiple Print Had Taken','2024-11-12 17:14:51','39','generateqrsr'), (1057,NULL,'QR generated','2024-11-12 17:17:13','39','Generateqr'), (1058,NULL,'User Logged In','2024-11-12 17:17:41','37','Login In'), (1059,NULL,'Generateqr Approved','2024-11-12 17:17:57','37','Approval'), (1060,NULL,'Multiple Print Had Taken','2024-11-12 17:18:17','39','generateqrsr'), (1061,NULL,'Multiple Print Had Taken','2024-11-12 17:22:23','39','generateqrsr'), (1062,NULL,'User Logged In','2024-11-12 18:48:37','39','Login In'), (1063,NULL,'Single Print Had Taken','2024-11-12 18:49:17','39','generateqrsr'), (1064,NULL,'User Logged In','2024-11-12 20:51:30','39','Login In'), (1065,NULL,'Single Print Had Taken','2024-11-12 20:51:44','39','generateqrsr'), (1066,NULL,'User Logged In','2024-11-14 11:17:27','39','Login In'), (1067,NULL,'Single Print Had Taken','2024-11-14 11:17:59','39','generateqrsr'), (1068,NULL,'Single Print Had Taken','2024-11-14 11:19:33','39','generateqrsr'), (1069,NULL,'User Logged In','2024-11-14 13:13:35','36','Login In'), (1070,NULL,'User Logged In','2024-11-14 15:07:07','36','Login In'); /*!40000 ALTER TABLE `logtable` ENABLE KEYS */; -- -- Definition of manufacture -- DROP TABLE IF EXISTS `manufacture`; CREATE TABLE IF NOT EXISTS `manufacture` ( `id` int(11) NOT NULL AUTO_INCREMENT, `manu` varchar(255) DEFAULT '', `dis` varchar(255) DEFAULT '', `lic` varchar(255) DEFAULT '', `prefix` varchar(255) DEFAULT '', `add1` varchar(1000) DEFAULT '', `details` text, `add2` varchar(1000) DEFAULT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `manuaprstatus` varchar(50) DEFAULT NULL, `manrejstatus` varchar(50) DEFAULT NULL, `manuaprtime` datetime DEFAULT NULL, `manurejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table manufacture -- /*!40000 ALTER TABLE `manufacture` DISABLE KEYS */; INSERT INTO `manufacture`(`id`,`manu`,`dis`,`lic`,`prefix`,`add1`,`details`,`add2`,`created`,`updated`,`userid`,`deletestatus`,`manuaprstatus`,`manrejstatus`,`manuaprtime`,`manurejtime`) VALUES (1,'LAXACHEM ORGANICS PVT. LTD.','LAXACHEM ORGANICS PVT LTD','(25) AMD/3/96','890618164','Plot No. D-2, MIDC',NULL,'AMRAVATI-444 607. (Maharashtra) INDIA ','2024-08-03 11:21:56','2024-08-16 14:56:29','39','0','1','0','2024-08-16 17:09:25',NULL); /*!40000 ALTER TABLE `manufacture` ENABLE KEYS */; -- -- Definition of pagemaster -- DROP TABLE IF EXISTS `pagemaster`; CREATE TABLE IF NOT EXISTS `pagemaster` ( `id` int(11) NOT NULL AUTO_INCREMENT, `roleid` varchar(50) NOT NULL DEFAULT '0', `pageid` varchar(50) NOT NULL DEFAULT '0', `pagename` varchar(50) NOT NULL DEFAULT '0', `status` varchar(50) NOT NULL DEFAULT '0', `rejstatus` varchar(50) NOT NULL DEFAULT '0', `createdat` datetime NOT NULL, `approvedat` datetime DEFAULT NULL, `rejremark` varchar(150) DEFAULT NULL, `rejectedat` datetime DEFAULT NULL, `itemname` varchar(500) DEFAULT NULL, `purpose` varchar(500) DEFAULT NULL, `deletestatus` varchar(500) DEFAULT NULL, `userid` varchar(500) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=261 DEFAULT CHARSET=utf8; -- -- Dumping data for table pagemaster -- /*!40000 ALTER TABLE `pagemaster` DISABLE KEYS */; INSERT INTO `pagemaster`(`id`,`roleid`,`pageid`,`pagename`,`status`,`rejstatus`,`createdat`,`approvedat`,`rejremark`,`rejectedat`,`itemname`,`purpose`,`deletestatus`,`userid`) VALUES (10,'37','1','product','1','0','2024-08-03 13:27:27','2024-08-03 16:33:41',NULL,NULL,'CHLOROBUTANOL','Edit','0','39'), (13,'37','4','product','1','0','2024-08-03 16:43:31','2024-08-04 12:59:43',NULL,NULL,'PROPYL GALLATE','Edit','0','39'), (14,'37','6','product','1','0','2024-08-04 13:08:23','2024-08-04 14:31:49',NULL,NULL,'FUROSEMIDE','Edit','0','39'), (21,'37','1','pbatch','1','0','2024-08-09 12:06:49','2024-08-09 16:12:02',NULL,NULL,'CH-40724','Delete','1','39'), (22,'37','2','pbatch','1','0','2024-08-09 12:06:52','2024-08-09 16:12:31',NULL,NULL,'CH-40624','Delete','1','39'), (23,'37','3','pbatch','1','0','2024-08-09 12:06:55','2024-08-09 16:12:53',NULL,NULL,'CH-50624','Delete','1','39'), (24,'37','4','pbatch','1','0','2024-08-09 12:08:25','2024-08-09 16:14:10',NULL,NULL,'CH-10824','New Item','0','39'), (25,'37','5','pbatch','1','0','2024-08-09 12:09:19','2024-08-09 16:14:53',NULL,NULL,'CH-20824','New Item','0','39'), (26,'37','6','pbatch','1','0','2024-08-09 12:10:00','2024-08-09 16:15:42',NULL,NULL,'CH-30824','New Item','0','39'), (27,'37','7','pbatch','1','0','2024-08-09 12:10:44','2024-08-09 16:16:25',NULL,NULL,'CH-40824','New Item','0','39'), (28,'37','8','pbatch','1','0','2024-08-09 12:11:30','2024-08-09 16:16:43',NULL,NULL,'CH-50824','New Item','0','39'), (29,'37','1','addproduct','1','0','2024-08-10 12:45:56','2024-08-10 16:45:02',NULL,NULL,'CHLOROBUTANOL','New Item','0','39'), (30,'37','2','addproduct','1','0','2024-08-10 12:47:08','2024-08-10 16:45:04',NULL,NULL,'CHLORBUTOL','New Item','0','39'), (31,'37','1','storagecondition','1','0','2024-08-11 15:07:16','2024-08-11 16:12:16',NULL,NULL,'In an air tight container','New Item','0','39'), (32,'37','1','generateqr','1','0','2024-08-11 16:13:18','2024-08-11 16:16:38',NULL,NULL,'LAX/0824/001','New Item',NULL,'39'), (34,'37','3','addproduct','1','0','2024-08-14 19:44:19','2024-08-17 11:16:53',NULL,NULL,'CHLORBUTOL (IND. USE ONLY)','Delete','1','39'), (35,'37','1','manufacture','1','0','2024-08-16 14:56:29','2024-08-16 17:09:25',NULL,NULL,'LAXACHEM ORGANICS PVT. LTD.','Edit','0','39'), (40,'37','2','generateqr','1','0','2024-08-17 11:25:30','2024-08-17 11:28:08',NULL,NULL,'LAX/0824/002','New Item',NULL,'39'), (41,'37','3','generateqr','1','0','2024-08-17 12:10:07','2024-08-17 13:24:01',NULL,NULL,'LAX/0824/003','New Item',NULL,'39'), (42,'37','4','generateqr','1','0','2024-08-21 11:33:59','2024-08-21 11:49:27',NULL,NULL,'LAX/0824/004','New Item',NULL,'39'), (43,'37','5','generateqr','1','0','2024-08-21 11:34:37','2024-08-21 11:49:45',NULL,NULL,'LAX/0824/005','New Item',NULL,'39'), (44,'37','4','storagecondition','1','0','2024-08-23 15:07:55','2024-08-24 15:21:47',NULL,NULL,'Preserve in tight container','New Item','0','39'), (45,'37','6','generateqr','1','0','2024-08-24 15:28:16','2024-08-24 15:54:41',NULL,NULL,'LAX/0824/006','New Item',NULL,'39'), (46,'37','7','generateqr','1','0','2024-09-14 13:26:24','2024-09-14 15:55:28',NULL,NULL,'LAX/0924/007','New Item',NULL,'39'), (48,'37','8','generateqr','1','0','2024-09-14 15:42:06','2024-09-14 15:56:17',NULL,NULL,'LAX/0924/008','New Item',NULL,'39'), (49,'37','11','pbatch','1','0','2024-09-14 15:52:15','2024-09-14 15:56:58',NULL,NULL,'CH-90824','New Item','0','39'), (50,'37','9','generateqr','1','0','2024-09-14 15:59:01','2024-09-14 15:59:55',NULL,NULL,'LAX/0924/009','New Item',NULL,'39'), (51,'37','10','generateqr','1','0','2024-09-14 17:42:44','2024-09-14 17:43:26',NULL,NULL,'LAX/0924/009','New Item',NULL,'39'), (52,'37','11','generateqr','1','0','2024-09-14 17:48:35','2024-09-14 17:48:47',NULL,NULL,'LAX/0924/011','New Item',NULL,'39'), (53,'36','8','product','1','0','2024-09-17 15:07:20','2024-09-17 15:07:44',NULL,NULL,'A','New Item','0','36'), (54,'36','12','pbatch','1','0','2024-09-17 15:08:16','2024-09-17 15:08:25',NULL,NULL,'A Batch','New Item','0','36'), (55,'36','5','addproduct','1','0','2024-09-17 15:08:41','2024-09-17 15:08:48',NULL,NULL,'A Alias','New Item','0','36'), (56,'36','5','storagecondition','1','0','2024-09-17 15:09:13','2024-09-17 15:09:21',NULL,NULL,'A IP STORAGE','New Item','0','36'), (57,'36','12','generateqr','1','0','2024-09-17 15:09:48','2024-09-17 15:10:00',NULL,NULL,'LAX/0924/012','New Item',NULL,'36'), (58,'37','13','pbatch','1','0','2024-09-27 13:42:26','2024-09-27 16:34:59',NULL,NULL,'DS-20924','New Item','0','39'), (59,'37','13','generateqr','1','0','2024-10-03 18:33:01','2024-10-04 14:08:00',NULL,NULL,'LAX/1024/013','New Item',NULL,'39'), (60,'37','14','generateqr','1','0','2024-10-03 18:34:21','2024-10-04 14:35:47',NULL,NULL,'LAX/1024/014','New Item',NULL,'39'), (61,'37','15','generateqr','1','0','2024-10-03 18:34:51','2024-10-04 14:35:25',NULL,NULL,'LAX/1024/015','New Item',NULL,'39'), (62,'37','16','generateqr','1','0','2024-10-03 18:36:09','2024-10-04 14:35:07',NULL,NULL,'LAX/1024/016','New Item',NULL,'39'), (63,'37','17','generateqr','1','0','2024-10-03 18:36:49','2024-10-04 14:34:35',NULL,NULL,'LAX/1024/017','New Item',NULL,'39'), (64,'37','14','pbatch','1','0','2024-10-03 18:38:18','2024-10-04 14:33:05',NULL,NULL,'CH-60824','New Item','0','39'), (65,'37','15','pbatch','1','0','2024-10-03 18:39:17','2024-10-04 14:32:35',NULL,NULL,'CH-70824','New Item','0','39'), (66,'37','16','pbatch','1','0','2024-10-03 18:41:46','2024-10-04 14:32:16',NULL,NULL,'CH-80824','New Item','0','39'), (67,'37','18','generateqr','1','0','2024-10-03 18:43:38','2024-10-04 14:34:10',NULL,NULL,'LAX/1024/018','New Item',NULL,'39'), (68,'37','19','generateqr','1','0','2024-10-03 18:44:24','2024-10-04 14:33:49',NULL,NULL,'LAX/1024/019','New Item',NULL,'39'), (69,'37','17','pbatch','1','0','2024-10-03 18:45:31','2024-10-04 14:31:51',NULL,NULL,'CH-10924','New Item','0','39'), (71,'37','18','pbatch','1','0','2024-10-03 18:46:37','2024-10-04 14:31:03',NULL,NULL,'CH-20924','Delete','1','39'), (72,'37','10','pbatch','1','0','2024-10-03 18:47:43','2024-10-04 14:30:45',NULL,NULL,'CH-20924','Edit','0','39'), (73,'37','19','pbatch','1','0','2024-10-03 18:50:09','2024-10-04 14:30:12',NULL,NULL,'CH-30924','New Item','0','39'), (74,'37','20','pbatch','1','0','2024-10-03 18:50:51','2024-10-04 14:29:08',NULL,NULL,'CH-40924','New Item','0','39'), (75,'37','21','pbatch','1','0','2024-10-03 18:51:56','2024-10-04 14:27:56',NULL,NULL,'CH-50924','New Item','0','39'), (77,'37','23','pbatch','1','0','2024-10-03 18:53:14','2024-10-04 14:27:37',NULL,NULL,'CH-70924','New Item','0','39'), (78,'37','6','addproduct','1','0','2024-10-04 11:00:09','2024-10-04 11:01:25',NULL,NULL,'DOCUSATE SODIUM','New Item','0','39'), (79,'37','24','pbatch','1','0','2024-10-04 11:03:16','2024-10-04 11:03:38',NULL,NULL,'DS-20824','New Item','0','39'), (81,'37','25','pbatch','1','0','2024-10-04 11:09:53','2024-10-04 14:26:12',NULL,NULL,'CH-80924','Edit','0','39'), (82,'37','26','pbatch','1','0','2024-10-04 11:10:33','2024-10-04 14:25:44',NULL,NULL,'CH-90924','New Item','0','39'), (83,'37','27','pbatch','1','0','2024-10-04 11:11:15','2024-10-04 14:25:05',NULL,NULL,'CH-100924','New Item','0','39'), (84,'37','28','pbatch','1','0','2024-10-04 11:11:52','2024-10-04 14:24:13',NULL,NULL,'CH-110924','New Item','0','39'), (85,'37','29','pbatch','1','0','2024-10-04 11:13:36','2024-10-04 14:23:31',NULL,NULL,'DS-10824','New Item','0','39'), (86,'37','30','pbatch','1','0','2024-10-04 11:15:22','2024-10-04 14:22:37',NULL,NULL,'DS-10924','New Item','0','39'), (87,'37','31','pbatch','1','0','2024-10-04 11:17:27','2024-10-04 14:22:14',NULL,NULL,'DS-11024','New Item','0','39'), (88,'37','32','pbatch','1','0','2024-10-04 11:18:08','2024-10-04 14:21:31',NULL,NULL,'DS-21024','New Item','0','39'), (89,'37','33','pbatch','1','0','2024-10-04 11:18:41','2024-10-04 14:21:11',NULL,NULL,'DS-31024','New Item','0','39'), (90,'37','9','pbatch','0','1','2024-10-04 11:21:03',NULL,'Retest date is wrong, not 5 years please write 2 years after mfg. date.','2024-10-04 14:20:31','FR-10824','Delete','-1','39'), (91,'37','4','addproduct','1','0','2024-10-04 11:21:59','2024-10-04 14:15:34',NULL,NULL,'FUROSEMIDE','Delete','1','39'), (93,'37','7','addproduct','1','0','2024-10-04 11:24:01','2024-10-04 14:15:02',NULL,NULL,'PROPYL GALLATE','New Item','0','39'), (94,'37','6','storagecondition','1','0','2024-10-04 11:25:59','2024-10-04 14:14:35',NULL,NULL,'In an air tight container','New Item','0','39'), (95,'37','3','storagecondition','1','0','2024-10-04 11:26:16','2024-10-04 14:50:58',NULL,NULL,'','Delete','1','39'), (97,'37','8','storagecondition','1','0','2024-10-04 11:27:45','2024-10-04 14:10:27',NULL,NULL,'Store protect from moisture','New Item','0','39'), (98,'37','9','storagecondition','1','0','2024-10-04 11:28:15','2024-10-04 14:10:10',NULL,NULL,'In an air tight container','New Item','0','39'), (99,'37','10','storagecondition','1','0','2024-10-04 11:28:49','2024-10-04 14:09:52',NULL,NULL,'In an air tight container','New Item','0','39'), (100,'37','11','storagecondition','1','0','2024-10-04 11:29:17','2024-10-04 14:08:58',NULL,NULL,'Preserve in well closed container','New Item','0','39'), (102,'38','2','customer','1','0','2024-10-04 11:57:57','2024-10-04 16:16:23',NULL,NULL,'VISHNU AGENCIES','New Item','0','39'), (103,'38','3','customer','1','0','2024-10-04 12:01:17','2024-10-04 16:16:20',NULL,NULL,'SHITAL CHEMICALS','New Item','0','39'), (104,'38','4','customer','1','0','2024-10-04 12:02:54','2024-10-04 16:16:18',NULL,NULL,'Coastal Medicare Pvt.Ltd.','New Item','0','39'), (105,'38','5','customer','1','0','2024-10-04 12:04:18','2024-10-04 16:16:15',NULL,NULL,'CURETECH SKINCARE','New Item','0','39'), (106,'38','6','customer','1','0','2024-10-04 12:05:53','2024-10-04 16:16:13',NULL,NULL,'DERREN HEALTHCARE PVT. LTD.','New Item','0','39'), (107,'38','7','customer','1','0','2024-10-04 12:07:20','2024-10-04 16:16:11',NULL,NULL,'ANUSHA ASSOCIATES','New Item','0','39'), (108,'38','8','customer','1','0','2024-10-04 12:08:48','2024-10-04 16:15:30',NULL,NULL,'ANOD PHARMA PVT.LTD.','New Item','0','39'), (109,'38','9','customer','1','0','2024-10-04 12:10:58','2024-10-04 16:16:08',NULL,NULL,'WENDT-CHEMIE','New Item','0','39'), (110,'38','10','customer','1','0','2024-10-04 12:12:31','2024-10-04 16:15:28',NULL,NULL,'KHYATI HEALTHCARE PVT. LTD.','New Item','0','39'), (111,'38','11','customer','1','0','2024-10-04 12:14:30','2024-10-04 16:16:06',NULL,NULL,'NITIN LIFESCIENCES LTD Unit- I','New Item','0','39'), (112,'38','12','customer','1','0','2024-10-04 12:16:27','2024-10-04 16:15:25',NULL,NULL,'TAMMAN TITOE PHARMA PVT. LTD.','New Item','0','39'), (113,'38','13','customer','1','0','2024-10-04 12:19:08','2024-10-04 16:16:03',NULL,NULL,'NATIONAL LABORATORIES UNIT-II','New Item','0','39'), (114,'38','14','customer','1','0','2024-10-04 12:20:57','2024-10-04 16:15:20',NULL,NULL,'FDC LIMITED, JOGESHWARI,CORP','New Item','0','39'), (115,'38','15','customer','1','0','2024-10-04 12:24:16','2024-10-04 16:15:16',NULL,NULL,'ELKO ORGANIZATION (PVT) LTD.','New Item','0','39'), (116,'38','16','customer','1','0','2024-10-04 12:25:05','2024-10-04 16:15:58',NULL,NULL,'STAR LABORATORIES (PVT) LTD.','New Item','0','39'), (117,'38','17','customer','1','0','2024-10-04 12:28:17','2024-10-04 16:15:13',NULL,NULL,'LAWRENCE PHARMA PVT. LTD.','New Item','0','39'), (118,'38','18','customer','1','0','2024-10-04 12:34:32','2024-10-04 16:15:52',NULL,NULL,'S D FINE-CHEM LTD.','New Item','0','39'), (119,'38','19','customer','1','0','2024-10-04 12:39:13','2024-10-04 16:15:11',NULL,NULL,'GEMINI EXPORTS','New Item','0','39'), (120,'38','20','customer','1','0','2024-10-04 12:41:12','2024-10-04 16:15:55',NULL,NULL,'AKUMS DRUGS & PHARMACEUTICALS LTD','New Item','0','39'), (121,'38','21','customer','1','0','2024-10-04 12:43:04','2024-10-04 16:15:06',NULL,NULL,'VCARE MEDICINES','New Item','0','39'), (122,'38','22','customer','1','0','2024-10-04 12:45:03','2024-10-04 16:15:39',NULL,NULL,'OCTAVIUS PHARMA PVT. LTD.','New Item','0','39'), (124,'37','34','pbatch','1','0','2024-10-04 12:48:10','2024-10-04 14:08:38',NULL,NULL,'DP-10924','Delete','1','39'), (125,'38','1','customer','1','0','2024-10-04 12:51:31','2024-10-04 16:15:02',NULL,NULL,'ISIS PHARMACEUTICALS AND CHEMICAL WORK','Edit','0','39'), (126,'37','7','storagecondition','1','0','2024-10-04 14:28:15','2024-10-04 14:29:39',NULL,NULL,'In an air tight container','Edit','0','39'), (127,'37','20','generateqr','1','0','2024-10-04 15:17:19','2024-10-05 11:53:21',NULL,NULL,'LAX/1024/020','New Item',NULL,'39'), (128,'37','21','generateqr','1','0','2024-10-04 19:27:54','2024-10-05 11:53:02',NULL,NULL,'LAX/1024/021','New Item',NULL,'39'), (129,'37','22','generateqr','1','0','2024-10-05 10:58:02','2024-10-05 11:52:45',NULL,NULL,'LAX/1024/022','New Item',NULL,'39'), (130,'38','1','dispatch','1','0','2024-10-05 11:01:47','2024-10-16 12:31:52',NULL,NULL,'LAX/0824/001','New Item','0','39'), (132,'37','23','generateqr','1','0','2024-10-05 11:12:02','2024-10-05 11:52:17',NULL,NULL,'LAX/1024/023','New Item',NULL,'39'), (133,'37','35','pbatch','1','0','2024-10-05 11:57:49','2024-10-05 11:58:32',NULL,NULL,'CH-60924','New Item','0','39'), (134,'37','22','pbatch','1','0','2024-10-05 11:59:02','2024-10-05 11:59:28',NULL,NULL,'CH-60924','Delete','1','39'), (135,'37','24','generateqr','1','0','2024-10-05 12:03:04','2024-10-05 12:03:41',NULL,NULL,'LAX/1024/023','New Item',NULL,'39'), (136,'37','2','storagecondition','1','0','2024-10-05 12:59:05','2024-10-05 12:59:39',NULL,NULL,'Store protect from moisture at temperature not exceeding 30°C','Edit','0','39'), (137,'37','25','generateqr','1','0','2024-10-05 13:31:44','2024-10-05 18:08:39',NULL,NULL,'LAX/1024/025','New Item',NULL,'39'), (138,'37','26','generateqr','1','0','2024-10-05 15:41:11','2024-10-05 18:08:30',NULL,NULL,'LAX/1024/025','New Item',NULL,'39'), (139,'37','27','generateqr','1','0','2024-10-08 14:04:04','2024-10-08 14:04:37',NULL,NULL,'LAX/1024/027','New Item',NULL,'39'), (140,'37','28','generateqr','1','0','2024-10-08 17:07:11','2024-10-08 17:07:55',NULL,NULL,'LAX/1024/028','New Item',NULL,'39'), (141,'37','29','generateqr','1','0','2024-10-09 17:02:59','2024-10-09 17:20:55',NULL,NULL,'LAX/1024/029','New Item',NULL,'39'), (142,'37','30','generateqr','1','0','2024-10-09 18:08:00','2024-10-09 18:08:36',NULL,NULL,'LAX/1024/030','New Item',NULL,'39'), (143,'37','31','generateqr','1','0','2024-10-15 11:53:23','2024-10-15 12:03:20',NULL,NULL,'LAX/1024/031','New Item',NULL,'39'), (144,'37','32','generateqr','1','0','2024-10-15 11:54:16','2024-10-15 12:03:31',NULL,NULL,'LAX/1024/032','New Item',NULL,'39'), (145,'38','2','dispatch','1','0','2024-10-16 12:11:22','2024-10-16 12:31:57',NULL,NULL,'LAX/0824/003','New Item','0','39'), (146,'38','3','dispatch','1','0','2024-10-16 12:13:57','2024-10-16 12:31:54',NULL,NULL,'LAX/0824/005','New Item','0','39'), (147,'38','4','dispatch','1','0','2024-10-16 12:15:47','2024-10-16 12:31:59',NULL,NULL,'LAX/0824/004','New Item','0','39'), (148,'38','5','dispatch','1','0','2024-10-16 12:17:34','2024-10-16 12:32:04',NULL,NULL,'LAX/0924/008','New Item','0','39'), (149,'38','6','dispatch','1','0','2024-10-16 12:19:49','2024-10-16 12:32:02',NULL,NULL,'LAX/1024/015','New Item','0','39'), (150,'38','7','dispatch','1','0','2024-10-16 12:21:59','2024-10-16 12:32:06',NULL,NULL,'LAX/0924/007','New Item','0','39'), (151,'38','8','dispatch','1','0','2024-10-16 12:23:58','2024-10-16 12:32:09',NULL,NULL,'LAX/1024/014','New Item','0','39'), (152,'38','9','dispatch','1','0','2024-10-16 12:25:50','2024-10-16 12:32:11',NULL,NULL,'LAX/1024/013','New Item','0','39'), (156,'38','11','dispatch','1','0','2024-10-16 12:49:41','2024-10-22 13:11:43',NULL,NULL,'LAX/1024/016','New Item','0','39'), (157,'38','12','dispatch','1','0','2024-10-16 12:50:21','2024-10-22 13:11:23',NULL,NULL,'LAX/1024/017','New Item','0','39'), (158,'37','33','generateqr','1','0','2024-10-16 12:51:23','2024-10-16 12:52:16',NULL,NULL,'LAX/1024/033','New Item',NULL,'39'), (159,'38','13','dispatch','1','0','2024-10-16 12:53:33','2024-10-22 13:11:25',NULL,NULL,'LAX/1024/033','New Item','0','39'), (160,'38','14','dispatch','1','0','2024-10-16 13:00:17','2024-10-22 13:11:45',NULL,NULL,'LAX/1024/018','New Item','0','39'), (161,'38','15','dispatch','1','0','2024-10-16 13:02:34','2024-10-22 13:11:48',NULL,NULL,'LAX/0924/009','New Item','0','39'), (162,'37','34','generateqr','1','0','2024-10-16 13:22:49','2024-10-16 13:27:23',NULL,NULL,'LAX/1024/034','New Item',NULL,'39'), (163,'37','35','generateqr','1','0','2024-10-16 13:23:33','2024-10-16 13:27:29',NULL,NULL,'LAX/1024/035','New Item',NULL,'39'), (164,'37','36','generateqr','1','0','2024-10-16 13:24:05','2024-10-16 13:27:25',NULL,NULL,'LAX/1024/036','New Item',NULL,'39'), (165,'37','37','generateqr','1','0','2024-10-16 13:24:52','2024-10-16 13:27:30',NULL,NULL,'LAX/1024/037','New Item',NULL,'39'), (166,'37','38','generateqr','1','0','2024-10-16 13:25:32','2024-10-16 13:27:32',NULL,NULL,'LAX/1024/038','New Item',NULL,'39'), (167,'37','39','generateqr','1','0','2024-10-16 13:30:50','2024-10-16 13:30:57',NULL,NULL,'LAX/1024/039','New Item',NULL,'39'), (168,'38','16','dispatch','1','0','2024-10-16 13:34:14','2024-10-22 13:11:51',NULL,NULL,'LAX/1024/039','New Item','0','39'), (169,'38','17','dispatch','1','0','2024-10-16 13:35:44','2024-10-22 13:11:53',NULL,NULL,'LAX/1024/034','New Item','0','39'), (170,'38','18','dispatch','1','0','2024-10-16 13:37:35','2024-10-22 13:11:55',NULL,NULL,'LAX/1024/035','New Item','0','39'), (171,'38','19','dispatch','1','0','2024-10-16 13:38:51','2024-10-22 13:11:35',NULL,NULL,'LAX/1024/036','New Item','0','39'), (172,'37','40','generateqr','1','0','2024-10-16 13:41:57','2024-10-16 13:46:12',NULL,NULL,'LAX/1024/040','New Item',NULL,'39'), (173,'37','41','generateqr','1','0','2024-10-16 13:42:27','2024-10-16 13:46:14',NULL,NULL,'LAX/1024/041','New Item',NULL,'39'), (174,'37','42','generateqr','1','0','2024-10-16 13:42:56','2024-10-16 13:46:15',NULL,NULL,'LAX/1024/042','New Item',NULL,'39'), (175,'37','43','generateqr','1','0','2024-10-16 13:43:29','2024-10-16 13:46:17',NULL,NULL,'LAX/1024/043','New Item',NULL,'39'), (176,'37','44','generateqr','1','0','2024-10-16 13:45:26','2024-10-16 13:46:18',NULL,NULL,'LAX/1024/044','New Item',NULL,'39'), (177,'38','20','dispatch','1','0','2024-10-16 13:49:56','2024-10-22 13:11:33',NULL,NULL,'LAX/1024/040','New Item','0','39'), (178,'38','21','dispatch','1','0','2024-10-16 13:54:51','2024-10-22 13:11:31',NULL,NULL,'LAX/1024/041','New Item','0','39'), (179,'38','22','dispatch','1','0','2024-10-16 13:56:00','2024-10-22 13:11:29',NULL,NULL,'LAX/1024/042','New Item','0','39'), (180,'38','23','dispatch','1','0','2024-10-16 13:57:00','2024-10-22 13:11:57',NULL,NULL,'LAX/1024/043','New Item','0','39'), (181,'38','24','dispatch','1','0','2024-10-16 13:58:18','2024-10-22 13:11:58',NULL,NULL,'LAX/1024/023','New Item','0','39'), (183,'37','45','generateqr','1','0','2024-10-18 13:24:36','2024-10-18 13:31:15',NULL,NULL,'LAX/1024/045','New Item',NULL,'39'), (184,'37','46','generateqr','1','0','2024-10-18 13:25:30','2024-10-18 13:31:26',NULL,NULL,'LAX/1024/046','New Item',NULL,'39'), (185,'37','47','generateqr','1','0','2024-10-18 13:29:55','2024-10-18 13:31:37',NULL,NULL,'LAX/1024/047','New Item',NULL,'39'), (186,'37','48','generateqr','1','0','2024-10-19 11:45:39','2024-10-19 12:00:50',NULL,NULL,'LAX/1024/048','New Item',NULL,'39'), (187,'37','49','generateqr','1','0','2024-10-19 11:47:44','2024-10-19 12:01:04',NULL,NULL,'LAX/1024/049','New Item',NULL,'39'), (188,'37','50','generateqr','1','0','2024-10-19 11:48:59','2024-10-19 12:01:31',NULL,NULL,'LAX/1024/050','New Item',NULL,'39'), (189,'37','51','generateqr','1','0','2024-10-20 17:24:57','2024-10-22 11:28:00',NULL,NULL,'LAX/1024/051','New Item',NULL,'39'), (190,'38','26','dispatch','1','0','2024-10-22 12:51:15','2024-10-22 13:12:02',NULL,NULL,'LAX/1024/045','New Item','0','39'), (191,'37','52','generateqr','1','0','2024-10-22 13:16:21','2024-10-22 13:17:09',NULL,NULL,'LAX/1024/052','New Item',NULL,'39'), (192,'38','27','dispatch','1','0','2024-10-22 13:19:16','2024-10-22 13:20:34',NULL,NULL,'LAX/1024/052','New Item','0','39'), (193,'36','10','dispatch','0','0','2024-10-22 13:25:23',NULL,NULL,NULL,'6','Delete','-1','38'), (194,'38','10','dispatch','1','0','2024-10-22 13:25:23','2024-10-22 13:30:17',NULL,NULL,'6','Delete','1','38'), (195,'37','10','dispatch','0','0','2024-10-22 13:25:23',NULL,NULL,NULL,'6','Delete','-1','38'), (197,'38','28','dispatch','1','0','2024-10-22 13:31:41','2024-10-22 13:31:54',NULL,NULL,'6','Delete','1','39'), (198,'37','53','generateqr','1','0','2024-10-22 15:34:37','2024-10-22 15:53:32',NULL,NULL,'LAX/1024/053','New Item',NULL,'39'), (199,'37','54','generateqr','1','0','2024-10-22 15:35:16','2024-10-22 15:53:42',NULL,NULL,'LAX/1024/054','New Item',NULL,'39'), (200,'37','55','generateqr','1','0','2024-10-23 11:46:10','2024-10-23 12:22:32',NULL,NULL,'LAX/1024/055','New Item',NULL,'39'), (202,'37','7','product','1','0','2024-10-24 13:51:22','2024-10-27 12:30:03',NULL,NULL,'CHLOROBUTANOL','Edit','0','39'), (203,'37','3','product','1','0','2024-10-24 13:52:12','2024-10-27 12:30:41',NULL,NULL,'DOCUSATE SODIUM 85% POWDER','Edit','0','39'), (205,'38','29','dispatch','1','0','2024-10-24 14:13:02','2024-10-24 14:14:05',NULL,NULL,'6','Delete','1','39'), (207,'38','30','dispatch','1','0','2024-10-24 14:16:30','2024-10-24 14:16:41',NULL,NULL,'6','Delete','1','39'), (208,'37','56','generateqr','1','0','2024-10-24 17:36:32','2024-10-24 17:42:56',NULL,NULL,'LAX/1024/056','New Item',NULL,'39'), (209,'37','57','generateqr','1','0','2024-10-24 17:37:08','2024-10-24 17:43:00',NULL,NULL,'LAX/1024/057','New Item',NULL,'39'), (210,'37','58','generateqr','1','0','2024-10-24 17:39:29','2024-10-24 17:43:08',NULL,NULL,'LAX/1024/058','New Item',NULL,'39'), (211,'37','2','product','1','0','2024-10-25 13:55:50','2024-10-25 17:33:25',NULL,NULL,'DOCUSATE SODIUM','Edit','0','39'), (212,'37','5','product','1','0','2024-10-25 14:01:50','2024-10-31 11:32:33',NULL,NULL,'4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','Edit','0','39'), (213,'37','59','generateqr','1','0','2024-10-25 16:06:29','2024-10-25 17:32:58',NULL,NULL,'LAX/1024/059','New Item',NULL,'39'), (214,'37','60','generateqr','1','0','2024-10-25 16:07:13','2024-10-25 17:32:56',NULL,NULL,'LAX/1024/060','New Item',NULL,'39'), (215,'37','61','generateqr','1','0','2024-10-25 17:34:26','2024-10-25 17:37:05',NULL,NULL,'LAX/1024/061','New Item',NULL,'39'), (216,'38','31','dispatch','1','0','2024-10-25 18:48:01','2024-10-25 18:50:56',NULL,NULL,'LAX/1024/037','New Item','0','39'), (217,'38','23','customer','1','0','2024-10-25 18:50:12','2024-10-25 18:50:58',NULL,NULL,'ZEE LABORATORIES LIMITED','New Item','0','39'), (218,'38','32','dispatch','1','0','2024-10-25 18:52:11','2024-10-25 18:54:50',NULL,NULL,'LAX/1024/038','New Item','0','39'), (219,'38','24','customer','1','0','2024-10-25 18:54:32','2024-10-25 18:54:47',NULL,NULL,'SANJAY CHEMICALS','New Item','0','39'), (220,'38','33','dispatch','1','0','2024-10-25 18:56:03','2024-10-25 18:57:36',NULL,NULL,'LAX/1024/028','New Item','0','39'), (221,'38','25','dispatch','1','0','2024-10-25 19:02:56','2024-10-25 19:03:09',NULL,NULL,'LAX/1024/044','Edit','0','39'), (222,'38','34','dispatch','1','0','2024-10-25 19:07:22','2024-10-25 19:11:36',NULL,NULL,'LAX/1024/048','New Item','0','39'), (223,'38','35','dispatch','1','0','2024-10-25 19:08:36','2024-10-25 19:11:38',NULL,NULL,'LAX/1024/049','New Item','0','39'), (224,'38','25','customer','1','0','2024-10-25 19:11:01','2024-10-25 19:11:39',NULL,NULL,'BELL PHARMA PVT. LTD.','New Item','0','39'), (225,'37','62','generateqr','1','0','2024-10-27 12:18:49','2024-10-27 12:32:57',NULL,NULL,'LAX/1024/062','New Item',NULL,'39'), (226,'37','36','pbatch','1','0','2024-10-30 17:34:11','2024-10-30 17:35:58',NULL,NULL,'CH-11024','New Item','0','39'), (227,'37','37','pbatch','1','0','2024-10-30 17:35:18','2024-10-30 17:36:12',NULL,NULL,'CH-21024','New Item','0','39'), (228,'37','63','generateqr','1','0','2024-10-30 17:41:51','2024-10-30 18:36:57',NULL,NULL,'LAX/1024/063','New Item',NULL,'39'), (229,'37','64','generateqr','1','0','2024-10-31 12:12:19','2024-10-31 12:31:47',NULL,NULL,'LAX/1024/064','New Item',NULL,'39'), (230,'37','38','pbatch','1','0','2024-11-05 19:04:27','2024-11-06 18:35:17',NULL,NULL,'FR-11124','New Item','0','39'), (231,'37','12','storagecondition','1','0','2024-11-05 19:05:50','2024-11-06 15:50:51',NULL,NULL,'Store protect from moisture and light','New Item','0','39'), (233,'37','8','addproduct','1','0','2024-11-05 19:09:07','2024-11-06 15:53:10',NULL,NULL,'CHLOROBUTANOL','New Item','0','39'), (234,'37','13','storagecondition','1','0','2024-11-05 19:09:59','2024-11-06 15:53:37',NULL,NULL,'In an air tight container','New Item','0','39'), (235,'37','40','pbatch','1','0','2024-11-06 18:09:29','2024-11-06 18:36:34',NULL,NULL,'CH-11124','New Item','0','39'), (236,'37','39','pbatch','1','0','2024-11-06 18:12:15','2024-11-06 18:36:58',NULL,NULL,'CHA-21024','Edit','0','39'), (237,'37','41','pbatch','1','0','2024-11-06 18:13:12','2024-11-06 18:37:13',NULL,NULL,'CHA-11024','New Item','0','39'), (238,'37','42','pbatch','1','0','2024-11-06 18:14:58','2024-11-06 18:37:36',NULL,NULL,'PG-11124','New Item','0','39'), (239,'37','65','generateqr','1','0','2024-11-06 18:38:26','2024-11-07 11:09:48',NULL,NULL,'LAX/1124/065','New Item',NULL,'39'), (240,'37','66','generateqr','1','0','2024-11-06 18:39:04','2024-11-07 11:10:00',NULL,NULL,'LAX/1124/066','New Item',NULL,'39'), (241,'37','67','generateqr','1','0','2024-11-06 18:40:00','2024-11-07 11:10:17',NULL,NULL,'LAX/1124/067','New Item',NULL,'39'), (242,'37','68','generateqr','1','0','2024-11-06 18:40:53','2024-11-07 11:10:29',NULL,NULL,'LAX/1124/068','New Item',NULL,'39'), (243,'37','69','generateqr','1','0','2024-11-06 18:41:32','2024-11-07 11:10:44',NULL,NULL,'LAX/1124/069','New Item',NULL,'39'), (244,'37','70','generateqr','1','0','2024-11-06 18:44:18','2024-11-07 11:10:53',NULL,NULL,'LAX/1124/070','New Item',NULL,'39'), (245,'37','71','generateqr','1','0','2024-11-06 18:45:16','2024-11-07 11:11:07',NULL,NULL,'LAX/1124/071','New Item',NULL,'39'), (246,'37','72','generateqr','1','0','2024-11-07 16:41:28','2024-11-07 17:01:25',NULL,NULL,'LAX/1124/072','New Item',NULL,'39'), (247,'37','73','generateqr','1','0','2024-11-10 15:30:06','2024-11-10 17:05:26',NULL,NULL,'LAX/1124/073','New Item',NULL,'39'), (248,'37','14','storagecondition','1','0','2024-11-10 16:58:05','2024-11-10 16:59:12',NULL,NULL,'Preserve in tight container','New Item','0','39'), (249,'37','74','generateqr','1','0','2024-11-10 16:59:51','2024-11-10 17:05:47',NULL,NULL,'LAX/1124/074','New Item',NULL,'39'), (250,'37','75','generateqr','1','0','2024-11-12 12:59:31','2024-11-12 14:34:23',NULL,NULL,'LAX/1124/075','New Item',NULL,'39'), (251,'37','76','generateqr','1','0','2024-11-12 13:00:22','2024-11-12 14:34:39',NULL,NULL,'LAX/1124/076','New Item',NULL,'39'), (252,'37','9','addproduct','1','0','2024-11-12 13:04:29','2024-11-12 13:06:08',NULL,NULL,'DOCUSATE SODIUM 85%','New Item','0','39'), (253,'37','43','pbatch','1','0','2024-11-12 13:09:33','2024-11-12 14:34:56',NULL,NULL,'DP-11124','New Item','0','39'), (254,'37','44','pbatch','1','0','2024-11-12 13:10:08','2024-11-12 14:35:10',NULL,NULL,'DP-21124','New Item','0','39'), (255,'37','77','generateqr','1','0','2024-11-12 13:11:02','2024-11-12 14:35:19',NULL,NULL,'LAX/1124/077','New Item',NULL,'39'), (256,'37','45','pbatch','1','0','2024-11-12 13:12:42','2024-11-12 14:35:34',NULL,NULL,'CH-21124','New Item','0','39'), (257,'37','15','storagecondition','1','0','2024-11-12 15:07:40','2024-11-12 15:08:38',NULL,NULL,'Preserve in well closed container','New Item','0','39'), (258,'37','78','generateqr','1','0','2024-11-12 15:11:02','2024-11-12 16:41:28',NULL,NULL,'LAX/1124/078','New Item',NULL,'39'), (259,'37','79','generateqr','1','0','2024-11-12 15:11:42','2024-11-12 16:41:35',NULL,NULL,'LAX/1124/079','New Item',NULL,'39'), (260,'37','80','generateqr','1','0','2024-11-12 17:17:13','2024-11-12 17:17:57',NULL,NULL,'LAX/1124/080','New Item',NULL,'39'); /*!40000 ALTER TABLE `pagemaster` ENABLE KEYS */; -- -- Definition of pbatch -- DROP TABLE IF EXISTS `pbatch`; CREATE TABLE IF NOT EXISTS `pbatch` ( `id` int(11) NOT NULL AUTO_INCREMENT, `batch` varchar(255) DEFAULT '', `product` varchar(255) DEFAULT '', `batchsize` varchar(255) DEFAULT '', `batchnumber` varchar(255) DEFAULT '', `mfgdate` date DEFAULT NULL, `expdate` date DEFAULT NULL, `weight` varchar(255) DEFAULT '', `remark` varchar(255) DEFAULT '', `pid` varchar(255) DEFAULT '', `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `bataprstatus` varchar(50) DEFAULT NULL, `batrejstatus` varchar(50) DEFAULT NULL, `bataprtime` datetime DEFAULT NULL, `batrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8; -- -- Dumping data for table pbatch -- /*!40000 ALTER TABLE `pbatch` DISABLE KEYS */; INSERT INTO `pbatch`(`id`,`batch`,`product`,`batchsize`,`batchnumber`,`mfgdate`,`expdate`,`weight`,`remark`,`pid`,`created`,`updated`,`userid`,`deletestatus`,`bataprstatus`,`batrejstatus`,`bataprtime`,`batrejtime`) VALUES (1,'CH-40724','1','500','NA','2024-07-01 00:00:00','2029-06-01 00:00:00','','','IP,BP,EP,USP','2024-08-07 12:00:22','2024-08-07 12:00:22','39','1','1','0','2024-08-09 16:12:02',NULL), (2,'CH-40624','1','500','NA','2024-06-01 00:00:00','2029-05-01 00:00:00','','','IP,BP,EP,USP','2024-08-07 12:00:30','2024-08-07 12:00:30','39','1','1','0','2024-08-09 16:12:31',NULL), (3,'CH-50624','1','500','NA','2024-06-01 00:00:00','2029-05-01 00:00:00','','','IP,BP,EP,USP','2024-08-07 11:58:02',NULL,'39','1','1','0','2024-08-09 16:12:53',NULL), (4,'CH-10824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:08:25',NULL,'39','0','1','0','2024-08-09 16:14:10',NULL), (5,'CH-20824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:09:18',NULL,'39','0','1','0','2024-08-09 16:14:53',NULL), (6,'CH-30824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:09:59',NULL,'39','0','1','0','2024-08-09 16:15:42',NULL), (7,'CH-40824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:10:43',NULL,'39','0','1','0','2024-08-09 16:16:25',NULL), (8,'CH-50824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-08-09 12:11:29',NULL,'39','0','1','0','2024-08-09 16:16:43',NULL), (9,'FR-10824','6','400','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP','2024-08-17 10:46:21',NULL,'39','0','1','0','2024-08-17 11:13:51',NULL), (10,'CH-20924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:47:43','2024-10-03 18:47:43','39','0','1','0','2024-10-04 14:30:45',NULL), (11,'CH-90824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-09-14 15:52:14',NULL,'39','0','1','0','2024-09-14 15:56:58',NULL), (12,'A Batch','8','20','ABATCHI','2024-09-01 00:00:00','2026-06-01 00:00:00','','','IP','2024-09-17 15:08:16',NULL,'36','0','1','0','2024-09-17 15:08:25',NULL), (13,'DS-20924','2','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-09-27 13:42:25',NULL,'39','0','1','0','2024-09-27 16:34:59',NULL), (14,'CH-60824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:38:17',NULL,'39','0','1','0','2024-10-04 14:33:05',NULL), (15,'CH-70824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:39:16',NULL,'39','0','1','0','2024-10-04 14:32:35',NULL), (16,'CH-80824','1','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:41:45',NULL,'39','0','1','0','2024-10-04 14:32:16',NULL), (17,'CH-10924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:45:30',NULL,'39','0','1','0','2024-10-04 14:31:51',NULL), (18,'CH-20924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:46:08',NULL,'39','1','1','0','2024-10-04 14:31:03',NULL), (19,'CH-30924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:50:09',NULL,'39','0','1','0','2024-10-04 14:30:12',NULL), (20,'CH-40924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:50:51',NULL,'39','0','1','0','2024-10-04 14:29:08',NULL), (21,'CH-50924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:51:56',NULL,'39','0','1','0','2024-10-04 14:27:56',NULL), (22,'CH-60924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-05 11:10:09','2024-10-05 11:10:09','39','1','1','0','2024-10-05 11:59:28',NULL), (23,'CH-70924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-03 18:53:14',NULL,'39','0','1','0','2024-10-04 14:27:37',NULL), (24,'DS-20824','2','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:03:16',NULL,'39','0','1','0','2024-10-04 11:03:38',NULL), (25,'CH-80924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:09:53','2024-10-04 11:09:53','39','0','1','0','2024-10-04 14:26:12',NULL), (26,'CH-90924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:10:33',NULL,'39','0','1','0','2024-10-04 14:25:44',NULL), (27,'CH-100924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:11:15',NULL,'39','0','1','0','2024-10-04 14:25:05',NULL), (28,'CH-110924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:11:52',NULL,'39','0','1','0','2024-10-04 14:24:13',NULL), (29,'DS-10824','2','500','NA','2024-08-01 00:00:00','2029-07-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:13:35',NULL,'39','0','1','0','2024-10-04 14:23:31',NULL), (30,'DS-10924','2','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:15:22',NULL,'39','0','1','0','2024-10-04 14:22:37',NULL), (31,'DS-11024','2','500','NA','2024-10-01 00:00:00','2029-09-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:17:26',NULL,'39','0','1','0','2024-10-04 14:22:14',NULL), (32,'DS-21024','2','500','NA','2024-10-01 00:00:00','2029-09-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:18:08',NULL,'39','0','1','0','2024-10-04 14:21:31',NULL), (33,'DS-31024','2','500','NA','2024-10-01 00:00:00','2029-09-01 00:00:00','','','IP,BP,EP,USP','2024-10-04 11:18:40',NULL,'39','0','1','0','2024-10-04 14:21:11',NULL), (34,'DP-10924','3','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','USP','2024-10-04 12:48:00',NULL,'39','1','1','0','2024-10-04 14:08:38',NULL), (35,'CH-60924','1','500','NA','2024-09-01 00:00:00','2029-08-01 00:00:00','','','IP,BP,EP,USP','2024-10-05 11:57:49',NULL,'39','0','1','0','2024-10-05 11:58:32',NULL), (36,'CH-11024','1','500','NA','2024-10-01 00:00:00','2029-09-01 00:00:00','','','IP,BP,EP,USP','2024-10-30 17:34:10',NULL,'39','0','1','0','2024-10-30 17:35:58',NULL), (37,'CH-21024','1','500','NA','2024-10-01 00:00:00','2029-09-01 00:00:00','','','IP,BP,EP,USP','2024-10-30 17:35:18',NULL,'39','0','1','0','2024-10-30 17:36:12',NULL), (38,'FR-11124','6','400','NA','2024-11-01 00:00:00','2029-10-01 00:00:00','','','IP,BP,EP,USP','2024-11-05 19:04:27',NULL,'39','0','1','0','2024-11-06 18:35:17',NULL), (39,'CHA-21024','7','25','NA','2024-10-01 00:00:00','2029-09-01 00:00:00','','','IP,BP,EP,USP','2024-11-06 18:12:15','2024-11-06 18:12:15','39','0','1','0','2024-11-06 18:36:58','2024-11-06 15:57:39'), (40,'CH-11124','1','500','NA','2024-11-01 00:00:00','2029-10-01 00:00:00','','','IP,BP,EP,USP','2024-11-06 18:09:28',NULL,'39','0','1','0','2024-11-06 18:36:34',NULL), (41,'CHA-11024','7','25','NA','2024-10-01 00:00:00','2029-09-01 00:00:00','','','IP,BP,EP,USP','2024-11-06 18:13:11',NULL,'39','0','1','0','2024-11-06 18:37:13',NULL), (42,'PG-11124','4','500','NA','2024-11-01 00:00:00','2029-10-01 00:00:00','','','IP,BP,USP','2024-11-06 18:14:57',NULL,'39','0','1','0','2024-11-06 18:37:36',NULL), (43,'DP-11124','3','500','NA','2024-11-01 00:00:00','2029-10-01 00:00:00','','','In-House','2024-11-12 13:09:33',NULL,'39','0','1','0','2024-11-12 14:34:56',NULL), (44,'DP-21124','3','200','NA','2024-11-01 00:00:00','2029-10-01 00:00:00','','','In-House','2024-11-12 13:10:07',NULL,'39','0','1','0','2024-11-12 14:35:10',NULL), (45,'CH-21124','1','500','NA','2024-11-01 00:00:00','2029-10-01 00:00:00','','','IP,BP,EP,USP','2024-11-12 13:12:42',NULL,'39','0','1','0','2024-11-12 14:35:34',NULL); /*!40000 ALTER TABLE `pbatch` ENABLE KEYS */; -- -- Definition of preset -- DROP TABLE IF EXISTS `preset`; CREATE TABLE IF NOT EXISTS `preset` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT '', `name` varchar(255) DEFAULT '', `formula` varchar(255) DEFAULT '', `batch` varchar(255) DEFAULT '', `molwt` varchar(255) DEFAULT '', `tarewt` varchar(255) DEFAULT '', `grosswt` varchar(255) DEFAULT '', `netwt` varchar(255) DEFAULT '', `gtin` varchar(255) DEFAULT '', `manufact` varchar(255) DEFAULT '', `storag` varchar(255) DEFAULT '', `grade` varchar(255) DEFAULT '', `uom` varchar(255) DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table preset -- /*!40000 ALTER TABLE `preset` DISABLE KEYS */; /*!40000 ALTER TABLE `preset` ENABLE KEYS */; -- -- Definition of product -- DROP TABLE IF EXISTS `product`; CREATE TABLE IF NOT EXISTS `product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT '', `brand` varchar(255) DEFAULT '', `gtin` varchar(255) DEFAULT '', `manu` varchar(255) DEFAULT '', `manutxt` varchar(255) DEFAULT '', `scon` varchar(255) DEFAULT '', `grade` varchar(255) DEFAULT '', `subname` varchar(255) DEFAULT '', `pack` varchar(255) DEFAULT '', `uom` varchar(255) DEFAULT '', `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `formula` varchar(255) DEFAULT NULL, `molwt` varchar(255) DEFAULT NULL, `deletestatus` varchar(255) DEFAULT NULL, `prodaprstatus` varchar(255) DEFAULT NULL, `prodrejstatus` varchar(255) DEFAULT NULL, `prodaprtime` datetime DEFAULT NULL, `prodrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; -- -- Dumping data for table product -- /*!40000 ALTER TABLE `product` DISABLE KEYS */; INSERT INTO `product`(`id`,`name`,`brand`,`gtin`,`manu`,`manutxt`,`scon`,`grade`,`subname`,`pack`,`uom`,`created`,`updated`,`userid`,`formula`,`molwt`,`deletestatus`,`prodaprstatus`,`prodrejstatus`,`prodaprtime`,`prodrejtime`) VALUES (1,'CHLOROBUTANOL','NA','8906181640009','1','LAXACHEM ORGANICS PVT LTD','Preserve in air tight container','IP,BP,EP,USP','HEMIHYDRATE','5,10,15,20,25','KGS','2024-08-03 12:54:22','2024-08-03 13:27:27','39','C4H7Cl3O,1/2H2O','186.5','0','1','0','2024-08-03 16:33:41',NULL), (2,'DOCUSATE SODIUM','NA','8906181640023','1','LAXACHEM ORGANICS PVT LTD','Preserve in well closed container','IP,BP,EP,USP','Dioctyl Sodium Sulfosuccinate','5,10,15,20,25','KGS','2024-08-03 12:58:20','2024-10-25 13:55:50','39','C20H37NaO7S','444.6','0','1','0','2024-10-25 17:33:25',NULL), (3,'DOCUSATE SODIUM 85% POWDER','NA','8906181640030','1','LAXACHEM ORGANICS PVT LTD','Preserve in well closed container','In-House','NA','5,10,15,20,25','KGS','2024-08-03 13:04:30','2024-10-24 13:52:12','39','NA','NA','0','1','0','2024-10-27 12:30:41',NULL), (4,'PROPYL GALLATE','NA','8906181640047','1','LAXACHEM ORGANICS PVT LTD','Store protect from light, in non-metallic container','IP,BP,USP','NA','5,10,15,20,25','KGS','2024-08-03 13:06:54','2024-08-03 16:43:31','39','C10H12O5','212.2','0','1','0','2024-08-04 12:59:43',NULL), (5,'4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid','NA','NA','1','LAXACHEM ORGANICS PVT LTD','NA','TECHNICAL','NA','5,10,15,20,25','KGS','2024-08-03 13:10:06','2024-10-25 14:01:50','39','C12H11CIN2O5S','330.7','0','1','0','2024-10-31 11:32:33',NULL), (6,'FUROSEMIDE','NA','8906181640054','1','LAXACHEM ORGANICS PVT LTD','Store protect from moisture and light','IP,BP,EP,USP','NA','5,10,15,20,25','KGS','2024-08-03 13:12:43','2024-08-04 13:08:23','39','C12H11CIN2O5S','330.7','0','1','0','2024-08-04 14:31:49','2024-08-04 13:03:26'), (7,'CHLOROBUTANOL','NA','8906181640016','1','LAXACHEM ORGANICS PVT LTD','In an air tight container','IP,BP,EP,USP','ANHYDROUS','5,10,15,20,25','KGS','2024-08-03 16:29:29','2024-10-24 13:51:22','39','C4H7Cl3O','177.5','0','1','0','2024-10-27 12:30:03',NULL), (8,'A','NA','12345678','1','LAXACHEM ORGANICS PVT LTD','NA','IP','Sub A','5','KGS','2024-09-17 15:07:20',NULL,'36','H2G4T5','224','0','1','0','2024-09-17 15:07:44',NULL); /*!40000 ALTER TABLE `product` ENABLE KEYS */; -- -- Definition of returnstock -- DROP TABLE IF EXISTS `returnstock`; CREATE TABLE IF NOT EXISTS `returnstock` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lotno` varchar(255) DEFAULT '', `remark` varchar(255) DEFAULT '', `dor` date DEFAULT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `status` varchar(50) DEFAULT '0', `deletestatus` varchar(50) DEFAULT '0', `rtime` varchar(50) DEFAULT NULL, `retaprstatus` varchar(50) DEFAULT NULL, `retrejstatus` varchar(50) DEFAULT NULL, `retaprtime` datetime DEFAULT NULL, `retrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table returnstock -- /*!40000 ALTER TABLE `returnstock` DISABLE KEYS */; /*!40000 ALTER TABLE `returnstock` ENABLE KEYS */; -- -- Definition of returnstocknew -- DROP TABLE IF EXISTS `returnstocknew`; CREATE TABLE IF NOT EXISTS `returnstocknew` ( `id` int(11) NOT NULL AUTO_INCREMENT, `lotid` varchar(50) DEFAULT NULL, `ssccno` varchar(50) DEFAULT NULL, `tarewt` varchar(50) DEFAULT NULL, `netwt` varchar(50) DEFAULT NULL, `grosswt` varchar(50) DEFAULT NULL, `created` varchar(50) DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `updated` varchar(50) DEFAULT NULL, `contno` varchar(50) DEFAULT NULL, `rntime` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table returnstocknew -- /*!40000 ALTER TABLE `returnstocknew` DISABLE KEYS */; /*!40000 ALTER TABLE `returnstocknew` ENABLE KEYS */; -- -- Definition of rolemaster -- DROP TABLE IF EXISTS `rolemaster`; CREATE TABLE IF NOT EXISTS `rolemaster` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) DEFAULT NULL, `password` varchar(50) DEFAULT NULL, `role` varchar(50) DEFAULT NULL, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table rolemaster -- /*!40000 ALTER TABLE `rolemaster` DISABLE KEYS */; /*!40000 ALTER TABLE `rolemaster` ENABLE KEYS */; -- -- Definition of storagecondition -- DROP TABLE IF EXISTS `storagecondition`; CREATE TABLE IF NOT EXISTS `storagecondition` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product` varchar(255) NOT NULL, `productid` int(11) NOT NULL DEFAULT '0', `grade` varchar(50) NOT NULL, `scondition` varchar(255) DEFAULT NULL, `aliasscondition` varchar(255) DEFAULT NULL, `createdat` datetime DEFAULT NULL, `updatedat` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT '0', `strgaprstatus` varchar(50) DEFAULT '0', `strgrejstatus` varchar(50) DEFAULT '0', `strgaprtime` datetime DEFAULT NULL, `strgrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; -- -- Dumping data for table storagecondition -- /*!40000 ALTER TABLE `storagecondition` DISABLE KEYS */; INSERT INTO `storagecondition`(`id`,`product`,`productid`,`grade`,`scondition`,`aliasscondition`,`createdat`,`updatedat`,`userid`,`deletestatus`,`strgaprstatus`,`strgrejstatus`,`strgaprtime`,`strgrejtime`) VALUES (1,'CHLOROBUTANOL',1,'BP',NULL,'In an air tight container','2024-08-11 15:07:16',NULL,'39','0','1','0','2024-08-11 16:12:16',NULL), (2,'CHLOROBUTANOL',1,'IP',NULL,'Store protect from moisture at temperature not exceeding 30°C','2024-08-16 15:37:38','2024-10-05 12:59:05','39','0','1','0','2024-10-05 12:59:39',NULL), (3,'FUROSEMIDE',6,'IP',NULL,'Store protect from moisture and light','2024-08-17 11:19:32',NULL,'39','1','1','0','2024-10-04 14:50:58',NULL), (4,'CHLOROBUTANOL',1,'USP',NULL,'Preserve in tight container','2024-08-23 15:07:55',NULL,'39','0','1','0','2024-08-24 15:21:47',NULL), (5,'A',8,'IP',NULL,'A IP STORAGE','2024-09-17 15:09:12',NULL,'36','0','1','0','2024-09-17 15:09:21',NULL), (6,'CHLOROBUTANOL',1,'EP',NULL,'In an air tight container','2024-10-04 11:25:59',NULL,'39','0','1','0','2024-10-04 14:14:35',NULL), (7,'CHLOROBUTANOL',1,'TECHNICAL',NULL,'In an air tight container','2024-10-04 11:26:40','2024-10-04 14:28:14','39','0','1','0','2024-10-04 14:29:39','2024-10-04 14:13:34'), (8,'DOCUSATE SODIUM',2,'IP',NULL,'Store protect from moisture','2024-10-04 11:27:44',NULL,'39','0','1','0','2024-10-04 14:10:27',NULL), (9,'DOCUSATE SODIUM',2,'BP',NULL,'In an air tight container','2024-10-04 11:28:14',NULL,'39','0','1','0','2024-10-04 14:10:10',NULL), (10,'DOCUSATE SODIUM',2,'EP',NULL,'In an air tight container','2024-10-04 11:28:48',NULL,'39','0','1','0','2024-10-04 14:09:52',NULL), (11,'DOCUSATE SODIUM',2,'USP',NULL,'Preserve in well closed container','2024-10-04 11:29:17',NULL,'39','0','1','0','2024-10-04 14:08:58',NULL), (12,'FUROSEMIDE',6,'IP',NULL,'Store protect from moisture and light','2024-11-05 19:05:49',NULL,'39','0','1','0','2024-11-06 15:50:51',NULL), (13,'CHLOROBUTANOL',7,'BP',NULL,'In an air tight container','2024-11-05 19:09:59',NULL,'39','0','1','0','2024-11-06 15:53:37',NULL), (14,'CHLOROBUTANOL',7,'USP',NULL,'Preserve in tight container','2024-11-10 16:58:04',NULL,'39','0','1','0','2024-11-10 16:59:12',NULL), (15,'DOCUSATE SODIUM 85% POWDER',3,'In-House',NULL,'Preserve in well closed container','2024-11-12 15:07:39',NULL,'39','0','1','0','2024-11-12 15:08:38',NULL); /*!40000 ALTER TABLE `storagecondition` ENABLE KEYS */; -- -- Definition of userm -- DROP TABLE IF EXISTS `userm`; CREATE TABLE IF NOT EXISTS `userm` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) DEFAULT '', `password` varchar(50) DEFAULT '', `rights` varchar(500) DEFAULT '', `addproduct` varchar(100) DEFAULT '', `scondition` varchar(100) DEFAULT '', `batch` varchar(100) DEFAULT '', `customerr` varchar(100) DEFAULT '', `dispatch` varchar(100) DEFAULT '', `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `dispatchreport` varchar(100) DEFAULT '', `generateqr` varchar(100) DEFAULT '', `logreport` varchar(100) DEFAULT '', `manufact` varchar(100) DEFAULT '', `products` varchar(100) DEFAULT '', `returnstocks` varchar(100) DEFAULT '', `rsreport` varchar(100) DEFAULT '', `ssccreport` varchar(100) DEFAULT '', `stocks` varchar(100) DEFAULT '', `generateqradministration` varchar(100) DEFAULT '', `userm` varchar(100) DEFAULT '', `role` varchar(50) DEFAULT NULL, `aliasproductadmin` varchar(50) DEFAULT NULL, `customeradmin` varchar(50) DEFAULT NULL, `dispatchadmin` varchar(50) DEFAULT NULL, `generateqradmin` varchar(50) DEFAULT NULL, `manufactureadmin` varchar(50) DEFAULT NULL, `pbatchadmin` varchar(50) DEFAULT NULL, `productadmin` varchar(50) DEFAULT NULL, `returnstockadmin` varchar(50) DEFAULT NULL, `stockadmin` varchar(50) DEFAULT NULL, `usermadmin` varchar(50) DEFAULT NULL, `sconditionadmin` varchar(50) DEFAULT NULL, `aliasproductadministration` varchar(50) DEFAULT NULL, `customeradministration` varchar(50) DEFAULT NULL, `dispatchadministration` varchar(50) DEFAULT NULL, `manufactureadministration` varchar(50) DEFAULT NULL, `pbatchadministration` varchar(50) DEFAULT NULL, `productadministration` varchar(50) DEFAULT NULL, `returnstockadministration` varchar(50) DEFAULT NULL, `stockadministration` varchar(50) DEFAULT NULL, `usermadministration` varchar(50) DEFAULT NULL, `sconditionadministration` varchar(50) DEFAULT NULL, `aliasproductqa` varchar(50) DEFAULT NULL, `customerqa` varchar(50) DEFAULT NULL, `dispatchqa` varchar(50) DEFAULT NULL, `generateqrqa` varchar(50) DEFAULT NULL, `manufactureqa` varchar(50) DEFAULT NULL, `pbatchqa` varchar(50) DEFAULT NULL, `productqa` varchar(50) DEFAULT NULL, `returnstockqa` varchar(50) DEFAULT NULL, `stockqa` varchar(50) DEFAULT NULL, `usermqa` varchar(50) DEFAULT NULL, `sconditionqa` varchar(50) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `approval` varchar(50) DEFAULT NULL, `reports` varchar(50) DEFAULT NULL, `subuser` varchar(255) DEFAULT NULL, `stockconversion` varchar(255) DEFAULT NULL, `stockdiscard` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1; -- -- Dumping data for table userm -- /*!40000 ALTER TABLE `userm` DISABLE KEYS */; INSERT INTO `userm`(`id`,`username`,`password`,`rights`,`addproduct`,`scondition`,`batch`,`customerr`,`dispatch`,`created`,`updated`,`dispatchreport`,`generateqr`,`logreport`,`manufact`,`products`,`returnstocks`,`rsreport`,`ssccreport`,`stocks`,`generateqradministration`,`userm`,`role`,`aliasproductadmin`,`customeradmin`,`dispatchadmin`,`generateqradmin`,`manufactureadmin`,`pbatchadmin`,`productadmin`,`returnstockadmin`,`stockadmin`,`usermadmin`,`sconditionadmin`,`aliasproductadministration`,`customeradministration`,`dispatchadministration`,`manufactureadministration`,`pbatchadministration`,`productadministration`,`returnstockadministration`,`stockadministration`,`usermadministration`,`sconditionadministration`,`aliasproductqa`,`customerqa`,`dispatchqa`,`generateqrqa`,`manufactureqa`,`pbatchqa`,`productqa`,`returnstockqa`,`stockqa`,`usermqa`,`sconditionqa`,`name`,`approval`,`reports`,`subuser`,`stockconversion`,`stockdiscard`) VALUES (36,'demoadmin','1234','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete',NULL,NULL,'','create,read,preview,print','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','','','create,read,edit,delete','','create,read,edit,delete','Admin','36','36','36','36','36','36','36','36','36','36','36','','','','','','','','','','','','','','','','','','','','','','Demo Admin','Show','Show','39,38,37,36','create,read,delete','create,read,delete'), (37,'qa-neha','qalopl#1','','read','read','read','read','read',NULL,NULL,'','read,preview,print','','read','read','read','','','read','','read','Quality Assurance','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','QA Neha','Show','Show','','read','read'), (38,'office-mukesh','officelopl#1','','read','read','read','read','read',NULL,NULL,'','read,preview,print','','read','read','read','','','read','','read','Administration','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','OFFICE Mukesh','Show','Show','','read','read'), (39,'user-faisal','userlopl#1','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete',NULL,NULL,'','create,read,preview,print','','create,read,edit,delete','create,read,edit,delete','create,read,edit,delete','','','create,read,edit,delete','','','User','','','','','','','','','','','','','38','38','','','','38','','','','37','','','37','37','37','37','','','','37','USER Faisal','Show','Show','','create,read,delete','create,read,delete'); /*!40000 ALTER TABLE `userm` ENABLE KEYS */; -- -- Definition of userrolemapping -- DROP TABLE IF EXISTS `userrolemapping`; CREATE TABLE IF NOT EXISTS `userrolemapping` ( `id` int(11) NOT NULL AUTO_INCREMENT, `Userid` int(11) NOT NULL DEFAULT '0', `adminroleid` varchar(50) NOT NULL DEFAULT '0', `adnimistratorroleid` varchar(50) NOT NULL DEFAULT '0', `qualityroleid` varchar(50) NOT NULL DEFAULT '0', `companyunit` varchar(50) NOT NULL DEFAULT '0', `companyid` varchar(50) NOT NULL DEFAULT '0', `adminstatus` bit(1) DEFAULT NULL, `administratorstatus` bit(1) DEFAULT NULL, `qualityarrusarnacestatus` bit(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table userrolemapping -- /*!40000 ALTER TABLE `userrolemapping` DISABLE KEYS */; INSERT INTO `userrolemapping`(`id`,`Userid`,`adminroleid`,`adnimistratorroleid`,`qualityroleid`,`companyunit`,`companyid`,`adminstatus`,`administratorstatus`,`qualityarrusarnacestatus`) VALUES (1,3,'1','1','2','CRUD','22',0,NULL,NULL); /*!40000 ALTER TABLE `userrolemapping` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-11-14 15:08:43 -- Total time: 0:0:0:0:937 (d:h:m:s:ms)