-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 5.7.14-log - MySQL Community Server (GPL) -- Server OS: Win64 -- HeidiSQL Version: 10.2.0.5599 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!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' */; -- Dumping database structure for laxachem CREATE DATABASE IF NOT EXISTS `laxachem` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `laxachem`; -- Dumping structure for table laxachem.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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.aliasproduct: ~30 rows (approximately) /*!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`) VALUES (15, 'duco4', 'DUCOSATE SODIUM', 17, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (17, 'DUSOSATE SODIUM 12', 'DUCOSATE SODIUM', 18, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (18, 'Ducosate Sodium 1234', 'DUCOSATE SODIUM', 18, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (19, 'Ducom', 'DUCOSATE SODIUM', 18, '2024-03-21 14:53:39', '2024-03-21 14:53:39', '0', NULL, NULL, NULL, NULL, NULL, '2', NULL, NULL, NULL), (20, 'sdfdsg', 'DUCOSATE SODIUM', 18, '2024-03-21 15:03:08', '2024-03-21 15:03:08', '1', NULL, NULL, '2024-03-28 17:08:39', NULL, NULL, '3', NULL, NULL, NULL), (21, 'Tulip Contras', 'TULIP C', 15, '2024-03-25 15:22:34', '2024-03-25 15:22:43', '1', NULL, NULL, '2024-03-28 17:08:52', NULL, NULL, '3', NULL, NULL, NULL), (22, 'Ducosate Sodium 12', 'Ducosate Sodium', 23, '2024-03-27 11:49:22', NULL, '0', NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (23, 'ducosate radium alpha z', 'Ducosate Sodium', 23, '2024-04-02 16:23:12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (24, 'ducosate radium alpha z', 'Ducosate Sodium', 23, '2024-04-02 16:23:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (25, 'ducosate radium alpha z', 'Ducosate Sodium', 23, '2024-04-02 16:24:43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (26, 'duco alpha', 'Ducosate Sodium', 23, '2024-04-02 16:26:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (27, 'duco alpha', 'Ducosate Sodium', 23, '2024-04-02 16:27:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (28, 'Ducomtdr aserdutilicia', 'Ducosate Sodium', 23, '2024-04-03 11:42:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (29, 'aserdity lucocium sulphonacii', 'Ducosate Sodium', 23, '2024-04-03 11:43:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (30, 'alpha Beta', 'Ducosate Sodium', 23, '2024-04-03 11:51:58', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (31, 'Beta Alpha', 'Ducosate Sodium', 23, '2024-04-03 11:53:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (32, 'AlphaBegta22', 'Ducosate Sodium', 23, '2024-04-03 11:59:47', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (33, 'beta two one alpha', 'Ducosate Sodium', 23, '2024-04-03 12:50:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (34, 'beta two one alpha', 'Ducosate Sodium', 23, '2024-04-03 12:50:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (35, 'dfbfgngfjghj', 'Ducosate Sodium', 23, '2024-04-03 12:53:17', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (36, 'ASDFRETTFFD', 'Ducosate Sodium', 23, '2024-04-03 13:09:36', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (37, 'ASDFRETTFFD', 'Ducosate Sodium', 23, '2024-04-03 13:09:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (38, 'dfshrgjhgk', 'Ducosate Sodium', 23, '2024-04-03 13:23:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (39, 'safsdfbgffgjghk', 'Ducosate Sodium', 23, '2024-04-03 13:24:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (40, 'Alpha Nine', 'Ducodine Alphaa Nine', 24, '2024-04-03 14:23:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (41, 'asdrewacolatemenia', 'Ducodine Alphaa Nine', 24, '2024-04-03 16:28:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (42, 'Alpha 10', 'Ducodine Alphaa Nine', 24, '2024-04-03 16:31:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (43, 'alpha 112', 'Ducodine Alphaa Nine', 24, '2024-04-03 17:05:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (44, 'alpha12', 'Ducodine Alphaa Nine', 24, '2024-04-03 17:08:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL), (45, 'laxapro', 'LaxachemProject', 26, '2024-04-08 15:38:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', NULL, NULL, NULL); /*!40000 ALTER TABLE `aliasproduct` ENABLE KEYS */; -- Dumping structure for table laxachem.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 '', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.customer: ~7 rows (approximately) /*!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`) VALUES (17, 'VAIBHAV', 'GSTIN1001', 'NAGPUR', '985285285', 'VAIBHAV@GMAIL.COM', NULL, NULL, 'DGFF111', '', '', '', '', '', '', 'VBHV', 'Customer'), (18, 'Mohd Waseem', 'Gstin0000', 'Amravati', '9898989898', 'sdfsdfds@gmail.com', NULL, NULL, 'dg11112', '', '', '', '', '', '', 'waseem', 'Customer'), (19, 'Sharique Sir', 'GSTIN122', 'Amravati', '874521478', 'shariques@gmail.com', '2024-04-03 14:13:03', NULL, 'dg1234', '', '', '', '', '', '', 'no name', 'Customer'), (20, 'Pratik Mohod', 'P1234', 'Amravati ', '8797987987', 'Pmohod@gmail.com', '2024-04-04 12:36:43', NULL, 'PG234', '', '', '', '', '', '', 'Pratik', 'Customer'), (21, 'Chandan Saraf', 'ch123', 'Amravati', '79885887', 'chandan@gmail.com', '2024-04-04 12:40:18', NULL, 'ch4566', '', '', '', '', '', '', 'chandan', 'Customer'), (22, 'Sahl Khan', 'GSTIN1111', 'Amravai', '9856985692', 'sahil@gamil.com', '2024-04-08 12:07:38', NULL, 'DG1234', '', '', '', '', '', '', 'Sahil', 'Customer'), (23, 'Pratik Mohod', 'PGTIN', 'Amravati', '9856985698', 'pratikm@gmail.com', '2024-04-08 15:37:33', NULL, 'DG124`', '', '', '', '', '', '', 'Pratik', 'Customer'); /*!40000 ALTER TABLE `customer` ENABLE KEYS */; -- Dumping structure for table laxachem.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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.dispatch: ~9 rows (approximately) /*!40000 ALTER TABLE `dispatch` DISABLE KEYS */; INSERT INTO `dispatch` (`id`, `lotno`, `distype`, `dod`, `bob`, `dob`, `customer`, `invoice`, `created`, `updated`) VALUES (10, '8', 'Export', '2023-12-12', '12', '2023-12-12', NULL, NULL, NULL, NULL), (11, '9', 'Export', '2024-02-28', '1001', '2024-02-28', '16', NULL, NULL, NULL), (12, '34', 'Export', '2024-03-18', '1234', '2024-03-18', '16', NULL, NULL, NULL), (13, '33', 'Export', '2024-03-18', '1122', '2024-03-18', '16', NULL, NULL, NULL), (14, '32', 'Export', '2024-03-18', '12321', '2024-03-18', '16', NULL, NULL, NULL), (15, '31', 'Export', '2024-03-18', '2225', '2024-03-18', '16', NULL, NULL, NULL), (16, '35', 'Export', '2024-03-20', '12321', '2024-03-20', '16', NULL, NULL, NULL), (17, '36', 'Export', '2024-03-20', '121212', '2024-03-20', '16', NULL, NULL, NULL), (18, '30', 'Export', '2024-03-21', 'BILL1100', '2024-03-21', '16', 'INV1100', NULL, NULL); /*!40000 ALTER TABLE `dispatch` ENABLE KEYS */; -- Dumping structure for table laxachem.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, `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', `lotcreatedate` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.generateqr: ~41 rows (approximately) /*!40000 ALTER TABLE `generateqr` DISABLE KEYS */; INSERT INTO `generateqr` (`id`, `presetid`, `genid`, `title`, `aliasproductid`, `name`, `formula1`, `batch`, `molwt`, `grosswt`, `tarewt`, `netwt`, `mfgdate`, `expdate`, `manuid`, `contfrom`, `contto`, `contno`, `grade`, `pack`, `ncont`, `qrqty`, `totalqty`, `dispatch`, `returnst`, `lotcreatedate`) VALUES (1, '3', '', 'fafa', '', 'faa', 'faaf', 'fasfafa', 'dvsv', 'fsgfsg', 'sfgg', 'sgs', '2023-09-11', '2023-09-12', '8', '12', '13', '', '', '', '', '', '', '0', '0', NULL), (3, '2', '', 'fdsg', '', '', '2212', '0', '', '', '', '2112', '2023-10-17', '2023-10-17', '13', '', '', '', 'IP', '12', '21', '', '', '0', '0', NULL), (4, '3', '', 'v', '', '', '131', '0', '', '', '', '12', '2023-10-17', '2023-10-17', '14', '', '', '', 'BP', '1', '2', '', '', '0', '0', NULL), (5, '3', 'LAX/1123/005', 'v', '', '', '233', '0', '', '', '', '33', '2023-11-01', '2023-11-01', '14', '', '', '', 'BP', '12', '23', '', '', '0', '0', NULL), (6, '6', 'LAX/1123/006', 'sddgg', '', '', '33', '0', '', '', '', '33', '2023-11-01', '2023-11-01', '15', '', '', '', 'EP', 'BP', '3', '', '', '0', '0', NULL), (7, '6', 'LAX/1123/007', 'sddgg', '', '', '22', 'fafssa', '', '', '', '22', '2023-11-01', '2023-11-01', '15', '', '', '', 'BP', 'BP', '23', '', '', '0', '0', NULL), (8, '2', 'LAX/1223/008', '', '', '', '10', 'fada', '', '', '', '10', '2023-12-01', '2024-03-01', '15', '', '', '', 'USP', 'shsh', '10', '', '100', '1', '0', NULL), (9, '12', 'LAX/1223/009', '', '', '', '22', 'rr', '', '', '', '20', '2023-12-01', '2024-12-01', '17', '', '', '', 'BP', '10', '12', '', '240', '1', '0', NULL), (10, '13', 'LAX/0224/010', '', '', '', '', '20', '', '', '', '10', '2024-03-01', '0001-01-01', '0', '', '', '', 'BP', '10', '5', '', '50', '0', '0', NULL), (11, '13', 'LAX/0224/011', '', '', '', '', '20', '', '', '', '10', '2024-03-01', '0001-01-01', '0', '', '', '', 'BP', '10', '5', '', '50', '0', '0', NULL), (12, '13', 'LAX/0224/011', '', '', '', '', '20', '', '', '', '10', '2024-03-01', '0001-01-01', '0', '', '', '', 'BP', '10', '5', '', '50', '0', '0', NULL), (13, '13', 'LAX/0224/011', '', '', '', '', '20', '', '', '', '10', '2024-03-01', '0001-01-01', '0', '', '', '', 'BP', '10', '5', '', '50', '0', '0', NULL), (14, '13', 'LAX/0224/014', '', '', '', '', '20', '', '', '', '10', '2024-03-01', '0001-01-01', '0', '', '', '', 'BP', '10', '5', '', '50', '0', '0', NULL), (15, '14', 'LAX/0224/015', '', '', '', '', '21', '', '', '', '15', '2024-03-01', '0001-01-01', '0', '', '', '', 'EP', '15', '5', '', '75', '0', '0', NULL), (16, '15', 'LAX/0324/016', '', '', '', '', '22', '', '', '', '10', '2024-01-01', '0001-01-01', '0', '', '', '', 'EP', '10', '5', '', '50', '0', '0', NULL), (17, '15', 'LAX/0324/017', '', '', '', '', '23', '', '', '', '10', '2024-02-01', '0001-01-01', '0', '', '', '', 'EP', '10', '3', '', '30', '0', '0', NULL), (18, '15', 'LAX/0324/018', '', '', '', '', '22', '', '', '', '10', '2024-01-01', '0001-01-01', NULL, '', '', '', 'EP', '10', '5', '', '50', '0', '0', NULL), (19, '14', 'LAX/0324/019', '', '', '', '', '21', '', '', '', '15', '2024-03-01', '0001-01-01', NULL, '', '', '', 'EP', '15', '5', '', '75', '0', '0', NULL), (20, '17', 'LAX/0324/020', '', '', '', '', '24', '', '', '', '12', '2024-02-01', '0001-01-01', '0', '', '', '', 'BP,USP', '12', '5', '', '60', '0', '0', NULL), (21, '17', 'LAX/0324/021', '', '6', '', '', '24', '', '', '', '12', '2024-02-01', '0001-01-01', '0', '', '', '', 'BP,USP', '12', '3', '', '36', '0', '0', NULL), (22, '18', 'LAX/0324/022', '', '7', '', '', '25', '', '', '', '18', '2024-01-01', '2024-05-01', '0', '', '', '', 'IP,BP,EP,USP', '18', '3', '', '54', '0', '0', NULL), (23, '18', 'LAX/0324/023', '', '7', '', '', '25', '', '', '', '18', '2024-01-01', '2024-05-01', '0', '', '', '', 'BP', '18', '2', '', '36', '0', '0', NULL), (24, '18', 'LAX/0324/024', '', '7', '', '', '25', '', '', '', '18', '2024-01-01', '2024-05-01', '0', '', '', '', 'BP', '18', '3', '', '54', '0', '0', NULL), (25, '17', 'LAX/0324/025', '', '6', '', '', '24', '', '', '', '12', '2024-02-01', '0001-01-01', '0', '', '', '', 'BP,USP', '12', '3', '', '36', '0', '0', NULL), (26, '17', 'LAX/0324/026', '', '6', '', '', '24', '', '', '', '12', '2024-02-01', '0001-01-01', '0', '', '', '', 'BP', '12', '3', '', '36', '0', '0', NULL), (27, '17', 'LAX/0324/027', '', '6', '', '', '24', '', '', '', '12', '2024-02-01', '0001-01-01', '0', '', '', '', 'USP', '12', '3', '', '36', '0', '0', NULL), (28, '17', 'LAX/0324/028', '', '6', '', '', '24', '', '', '', '12', '2024-02-01', '0001-01-01', '0', '', '', '', 'BP', '12', '3', '', '36', '0', '0', NULL), (29, '18', 'LAX/0324/029', '', '7', '', '', '25', '', '', '', '18', '2024-01-01', '2024-05-01', '0', '', '', '', 'IP', '18', '4', '', '72', '0', '0', NULL), (30, '17', 'LAX/0324/030', '', '6', '', '', '24', '', '', '', '12', '2024-02-01', '0001-01-01', '0', '', '', '', 'BP,USP', '12', '3', '', '36', '1', '0', '2024-03-11'), (31, '18', 'LAX/0324/031', '', '17', '', '', '34', '', '', '', '18', '2024-01-01', '2024-05-01', '0', '', '', '', 'IP,BP,EP,USP', '18', '5', '', '90', '1', '0', '2024-03-14'), (32, '18', 'LAX/0324/032', '', '17', '', '', '34', '', '', '', '18', '2024-01-01', '2024-05-01', '0', '', '', '', 'EP', '18', '3', '', '54', '1', '0', '2024-03-16'), (33, '18', 'LAX/0324/033', '', '17', '', '', '34', '', '', '', '18', '2024-02-01', '2024-06-01', '0', '', '', '', 'EP', '18', '3', '', '54', '1', '0', '2024-03-16'), (34, '17', 'LAX/0324/034', '', '16', '', '', '24', '', '', '', '12', '2024-03-01', '2024-10-01', '0', '', '', '', 'BP', '12', '2', '', '24', '1', '0', '2024-03-16'), (35, '18', 'LAX/0324/035', '', '18', '', '', '35', '', '', '', '18', '2024-02-01', '2024-11-01', '0', '', '', '', 'IP,BP', '18', '3', '', '54', '1', '0', '2024-03-19'), (36, '17', 'LAX/0324/036', '', '15', '', '', '24', '', '', '', '12', '2024-03-01', '2024-10-01', '0', '', '', '', 'BP,USP', '12', '5', '', '60', '1', '0', '2024-03-20'), (37, '23', 'LAX/0324/037', '', '22', '', '', '36', '', '', '', '120', '2024-02-01', '2024-07-01', '0', '', '', '', 'IP,BP', '120', '3', '', '360', '0', '0', '2024-03-27'), (38, '17', 'LAX/0324/038', '', '15', '', '', '24', '', '', '', '12', '2024-03-01', '2024-10-01', '0', '', '', '', 'BP,USP', '12', '3', '', '36', '0', '0', '2024-03-29'), (39, '18', 'LAX/0324/039', '', '17', '', '', '25', '', '', '', '18', '2024-02-01', '2024-06-01', '0', '', '', '', 'IP,BP', '18', '2', '', '36', '0', '0', '2024-03-29'), (40, '23', 'LAX/0324/040', '', '22', '', '', '36', '', '', '', '120', '2024-02-01', '2024-07-01', '0', '', '', '', 'IP', '120', '3', '', '360', '0', '0', '2024-03-29'), (41, '24', 'LAX/0424/041', '', '40', '', '', '37', '', '', '', '12', '2024-02-01', '2024-11-01', '0', '', '', '', 'BP', '12', '3', '', '36', '0', '0', '2024-04-03'), (42, '24', 'LAX/0424/042', '', '41', '', '', '37', '', '', '', '12', '2024-02-01', '2024-11-01', '0', '', '', '', 'BP', '12', '3', '', '36', '0', '0', '2024-04-08'); /*!40000 ALTER TABLE `generateqr` ENABLE KEYS */; -- Dumping structure for table laxachem.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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=221 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.generateqrsr: ~195 rows (approximately) /*!40000 ALTER TABLE `generateqrsr` DISABLE KEYS */; INSERT INTO `generateqrsr` (`id`, `contno`, `qrid`, `tarewt`, `grosswt`, `uninum`, `sscc`) VALUES (7, '0', '0', '', '', '00000000', NULL), (8, '1/21', '3', '2112', '', NULL, '00012345678000000011'), (9, '2/21', '3', '2112', '', NULL, '00012345678000000020'), (10, '3/21', '3', '2112', '', NULL, '00012345678000000031'), (11, '4/21', '3', '2112', '', NULL, '00012345678000000042'), (12, '5/21', '3', '2112', '', NULL, '00012345678000000053'), (13, '6/21', '3', '2112', '', NULL, '00012345678000000064'), (14, '7/21', '3', '2112', '', NULL, '00012345678000000075'), (15, '8/21', '3', '2112', '', NULL, '00012345678000000084'), (16, '9/21', '3', '2112', '', NULL, '00012345678000000093'), (17, '10/21', '3', '2112', '', NULL, '00012345678000000101'), (18, '11/21', '3', '2112', '', NULL, '00012345678000000112'), (19, '12/21', '3', '2112', '', NULL, '00012345678000000123'), (20, '13/21', '3', '2112', '', NULL, '00012345678000000134'), (21, '14/21', '3', '2112', '', NULL, '00012345678000000145'), (22, '15/21', '3', '2112', '', NULL, '00012345678000000154'), (23, '16/21', '3', '2112', '', NULL, '00012345678000000163'), (24, '17/21', '3', '2112', '', NULL, '00012345678000000172'), (25, '18/21', '3', '2112', '', NULL, '00012345678000000181'), (26, '19/21', '3', '2112', '', NULL, '00012345678000000190'), (27, '20/21', '3', '2112', '', NULL, '00012345678000000204'), (28, '21/21', '3', '2112', '', '00000000', '00012345678000000215'), (29, '1/2', '4', '', '', '00000001', '00012345678000000011'), (30, '2/2', '4', '', '', '00000002', '00012345678000000020'), (31, '1/23', '5', '33', '66', '00000003', '000123456783000000034'), (32, '2/23', '5', '33', '66', '00000004', '000123456783000000041'), (33, '3/23', '5', '33', '66', '00000005', '000123456783000000052'), (34, '4/23', '5', '33', '66', '00000006', '000123456783000000065'), (35, '5/23', '5', '33', '66', '00000007', '000123456783000000072'), (36, '6/23', '5', '33', '66', '00000008', '000123456783000000081'), (37, '7/23', '5', '33', '66', '00000009', '000123456783000000094'), (38, '8/23', '5', '33', '66', '00000010', '000123456783000000102'), (39, '9/23', '5', '33', '66', '00000011', '000123456783000000111'), (40, '10/23', '5', '33', '66', '00000012', '000123456783000000124'), (41, '11/23', '5', '33', '66', '00000013', '000123456783000000133'), (42, '12/23', '5', '33', '66', '00000014', '000123456783000000140'), (43, '13/23', '5', '33', '66', '00000015', '000123456783000000153'), (44, '14/23', '5', '33', '66', '00000016', '000123456783000000164'), (45, '15/23', '5', '33', '66', '00000017', '000123456783000000171'), (46, '16/23', '5', '33', '66', '00000018', '000123456783000000182'), (47, '17/23', '5', '33', '66', '00000019', '000123456783000000195'), (48, '18/23', '5', '33', '66', '00000020', '000123456783000000201'), (49, '19/23', '5', '33', '66', '00000021', '000123456783000000212'), (50, '20/23', '5', '33', '66', '00000022', '000123456783000000225'), (51, '21/23', '5', '33', '66', '00000023', '000123456783000000232'), (52, '22/23', '5', '33', '66', '00000024', '000123456783000000241'), (53, '23/23', '5', '33', '66', '00000025', '000123456783000000254'), (54, '1/3', '6', '33', '66', '00000026', '00012345678000000260'), (55, '2/3', '6', '33', '66', '00000027', '00012345678000000271'), (56, '3/3', '6', '33', '66', '00000028', '00012345678000000282'), (57, '1/23', '7', '22', '44', '00000029', '00012345678000000293'), (58, '2/23', '7', '22', '44', '00000030', '00012345678000000303'), (59, '3/23', '7', '22', '44', '00000031', '00012345678000000312'), (60, '4/23', '7', '22', '44', '00000032', '00012345678000000321'), (61, '5/23', '7', '22', '44', '00000033', '00012345678000000330'), (62, '6/23', '7', '22', '44', '00000034', '00012345678000000341'), (63, '7/23', '7', '22', '44', '00000035', '00012345678000000352'), (64, '8/23', '7', '22', '44', '00000036', '00012345678000000363'), (65, '9/23', '7', '22', '44', '00000037', '00012345678000000374'), (66, '10/23', '7', '22', '44', '00000038', '00012345678000000385'), (67, '11/23', '7', '22', '44', '00000039', '00012345678000000394'), (68, '12/23', '7', '22', '44', '00000040', '00012345678000000400'), (69, '13/23', '7', '22', '44', '00000041', '00012345678000000411'), (70, '14/23', '7', '22', '44', '00000042', '00012345678000000422'), (71, '15/23', '7', '22', '44', '00000043', '00012345678000000433'), (72, '16/23', '7', '22', '44', '00000044', '00012345678000000444'), (73, '17/23', '7', '22', '44', '00000045', '00012345678000000455'), (74, '18/23', '7', '22', '44', '00000046', '00012345678000000464'), (75, '19/23', '7', '22', '44', '00000047', '00012345678000000473'), (76, '20/23', '7', '22', '44', '00000048', '00012345678000000482'), (77, '21/23', '7', '22', '44', '00000049', '00012345678000000491'), (78, '22/23', '7', '22', '44', '00000050', '00012345678000000503'), (79, '23/23', '7', '22', '44', '00000051', '00012345678000000514'), (80, '1/10', '8', '10', '20', '00000052', '00012345678000000525'), (81, '2/10', '8', '10', '20', '00000053', '00012345678000000534'), (82, '3/10', '8', '10', '20', '00000054', '00012345678000000543'), (83, '4/10', '8', '10', '20', '00000055', '00012345678000000552'), (84, '5/10', '8', '10', '20', '00000056', '00012345678000000561'), (85, '6/10', '8', '10', '20', '00000057', '00012345678000000570'), (86, '7/10', '8', '10', '20', '00000058', '00012345678000000581'), (87, '8/10', '8', '10', '20', '00000059', '00012345678000000592'), (88, '9/10', '8', '10', '20', '00000060', '00012345678000000604'), (89, '10/10', '8', '10', '20', '00000061', '00012345678000000613'), (90, '1/12', '9', '10', '30', '00000062', '000000000620'), (91, '2/12', '9', '10', '30', '00000063', '000000000631'), (92, '3/12', '9', '10', '30', '00000064', '000000000642'), (93, '4/12', '9', '10', '30', '00000065', '000000000653'), (94, '5/12', '9', '10', '30', '00000066', '000000000664'), (95, '6/12', '9', '10', '30', '00000067', '000000000675'), (96, '7/12', '9', '10', '30', '00000068', '000000000684'), (97, '8/12', '9', '10', '30', '00000069', '000000000693'), (98, '9/12', '9', '10', '30', '00000070', '000000000701'), (99, '10/12', '9', '10', '30', '00000071', '000000000712'), (100, '11/12', '9', '10', '30', '00000072', '000000000723'), (101, '12/12', '9', '10', '30', '00000073', '000000000734'), (102, '1/5', '10', '10', '20', '00000074', '000000000745'), (103, '2/5', '10', '10', '20', '00000075', '000000000754'), (104, '3/5', '10', '10', '20', '00000076', '000000000763'), (105, '4/5', '10', '10', '20', '00000077', '000000000772'), (106, '5/5', '10', '10', '20', '00000078', '000000000781'), (107, '1/5', '12', '45', '55', '00000079', '000000000790'), (108, '1/5', '12', '45', '55', '00000079', '000000000790'), (109, '2/5', '12', '45', '55', '00000080', '000000000806'), (110, '2/5', '12', '45', '55', '00000080', '000000000806'), (111, '3/5', '12', '45', '55', '00000081', '000000000815'), (112, '3/5', '12', '45', '55', '00000081', '000000000815'), (113, '4/5', '12', '45', '55', '00000082', '000000000824'), (114, '4/5', '12', '45', '55', '00000082', '000000000824'), (115, '5/5', '12', '45', '55', '00000083', '000000000833'), (116, '5/5', '12', '45', '55', '00000083', '000000000833'), (117, '1/5', '13', '45', '55', '00000079', '000000000790'), (118, '2/5', '13', '45', '55', '00000080', '000000000806'), (119, '3/5', '13', '45', '55', '00000081', '000000000815'), (120, '4/5', '13', '45', '55', '00000082', '000000000824'), (121, '5/5', '13', '45', '55', '00000083', '000000000833'), (122, '1/5', '14', '10', '20', '00000084', '000000000842'), (123, '2/5', '14', '10', '20', '00000085', '000000000851'), (124, '3/5', '14', '10', '20', '00000086', '000000000860'), (125, '4/5', '14', '10', '20', '00000087', '000000000879'), (126, '5/5', '14', '10', '20', '00000088', '000000000888'), (127, '1/5', '15', '35', '50', '00000089', '000000000897'), (128, '2/5', '15', '35', '50', '00000090', '000000000903'), (129, '3/5', '15', '35', '50', '00000091', '000000000912'), (130, '4/5', '15', '35', '50', '00000092', '000000000921'), (131, '5/5', '15', '35', '50', '00000093', '000000000930'), (132, '1/5', '16', '10', '20', '00000094', '000000000949'), (133, '2/5', '16', '10', '20', '00000095', '000000000958'), (134, '3/5', '16', '10', '20', '00000096', '000000000967'), (135, '4/5', '16', '10', '20', '00000097', '000000000976'), (136, '5/5', '16', '10', '20', '00000098', '000000000985'), (137, '1/3', '17', '45', '55', '00000099', '000000000994'), (138, '2/3', '17', '45', '55', '00000100', '000000001009'), (139, '3/3', '17', '45', '55', '00000101', '000000001018'), (140, '1/5', '18', '42', '52', '00000102', '000000001027'), (141, '2/5', '18', '42', '52', '00000103', '000000001036'), (142, '3/5', '18', '42', '52', '00000104', '000000001045'), (143, '4/5', '18', '42', '52', '00000105', '000000001054'), (144, '5/5', '18', '42', '52', '00000106', '000000001063'), (145, '2/5', '19', '45', '60', '00000108', '000000001081'), (146, '3/5', '19', '45', '60', '00000109', '000000001090'), (147, '4/5', '19', '45', '60', '00000110', '000000001106'), (148, '5/5', '19', '45', '60', '00000111', '000000001115'), (149, '1/5', '20', '16', '28', '00000112', '000000001124'), (150, '2/5', '20', '16', '28', '00000113', '000000001133'), (151, '3/5', '20', '16', '28', '00000114', '000000001142'), (152, '4/5', '20', '16', '28', '00000115', '000000001151'), (153, '5/5', '20', '16', '28', '00000116', '000000001160'), (154, '1/3', '21', '120', '132', '00000117', '000000001179'), (155, '2/3', '21', '120', '132', '00000118', '000000001188'), (156, '3/3', '21', '120', '132', '00000119', '000000001197'), (157, '1/3', '22', '120', '138', '00000120', '000000001203'), (158, '2/3', '22', '120', '138', '00000121', '000000001212'), (159, '3/3', '22', '120', '138', '00000122', '000000001221'), (160, '1/2', '23', '120', '138', '00000123', '000000001230'), (161, '2/2', '23', '120', '138', '00000124', '000000001249'), (162, '1/3', '24', '111', '129', '00000125', '000000001258'), (163, '2/3', '24', '111', '129', '00000126', '000000001267'), (164, '3/3', '24', '111', '129', '00000127', '000000001276'), (165, '1/3', '25', '120', '132', '00000128', '000000001285'), (166, '2/3', '25', '120', '132', '00000129', '000000001294'), (167, '3/3', '25', '120', '132', '00000130', '000000001300'), (168, '1/3', '26', '102', '114', '00000131', '000000001319'), (169, '2/3', '26', '102', '114', '00000132', '000000001328'), (170, '3/3', '26', '102', '114', '00000133', '000000001337'), (171, '1/3', '27', '102', '114', '00000134', '000000001346'), (172, '2/3', '27', '102', '114', '00000135', '000000001355'), (173, '3/3', '27', '102', '114', '00000136', '000000001364'), (174, '1/3', '28', '102', '114', '00000137', '000000001373'), (175, '2/3', '28', '102', '114', '00000138', '000000001382'), (176, '3/3', '28', '102', '114', '00000139', '000000001391'), (177, '1/4', '29', '545', '563', '00000140', '000000001407'), (178, '2/4', '29', '545', '563', '00000141', '000000001416'), (179, '3/4', '29', '545', '563', '00000142', '000000001425'), (180, '4/4', '29', '545', '563', '00000143', '000000001434'), (181, '2/3', '30', '34', '46', '00000145', '000000001452'), (182, '3/3', '30', '34', '46', '00000146', '000000001461'), (183, '1/5', '31', '120', '138', '00000147', '000000001470'), (184, '2/5', '31', '120', '138', '00000148', '000000001489'), (185, '3/5', '31', '120', '138', '00000149', '000000001498'), (186, '4/5', '31', '120', '138', '00000150', '000000001504'), (187, '5/5', '31', '120', '138', '00000151', '000000001513'), (188, '1/3', '32', '132', '150', '00000152', '000000001522'), (189, '2/3', '32', '132', '150', '00000153', '000000001531'), (190, '3/3', '32', '132', '150', '00000154', '000000001540'), (191, '1/3', '33', '333', '351', '00000155', '000000001559'), (192, '2/3', '33', '333', '351', '00000156', '000000001568'), (193, '3/3', '33', '333', '351', '00000157', '000000001577'), (194, '1/2', '34', '222', '234', '00000158', '000000001586'), (195, '2/2', '34', '222', '234', '00000159', '000000001595'), (196, '1/3', '35', '123', '141', '00000160', '000000001601'), (197, '2/3', '35', '123', '141', '00000161', '000000001610'), (198, '3/3', '35', '123', '141', '00000162', '000000001629'), (199, '1/5', '36', '125.2', '137.2', '00000163', '000000001638'), (200, '2/5', '36', '125.2', '137.2', '00000164', '000000001647'), (201, '3/5', '36', '125.2', '137.2', '00000165', '000000001656'), (202, '4/5', '36', '125.2', '137.2', '00000166', '000000001665'), (203, '5/5', '36', '125.2', '137.2', '00000167', '000000001674'), (204, '1/3', '37', '120', '240', '00000168', '000000001683'), (205, '2/3', '37', '120', '240', '00000169', '000000001692'), (206, '3/3', '37', '120', '240', '00000170', '000000001708'), (207, '1/3', '38', '120', '132', '00000171', '000000001717'), (208, '2/3', '38', '120', '132', '00000172', '000000001726'), (209, '3/3', '38', '120', '132', '00000173', '000000001735'), (210, '1/2', '39', '180', '198', '00000174', '000000001744'), (211, '2/2', '39', '180', '198', '00000175', '000000001753'), (212, '1/3', '40', '156', '276', '00000176', '000000001762'), (213, '2/3', '40', '156', '276', '00000177', '000000001771'), (214, '3/3', '40', '156', '276', '00000178', '000000001780'), (215, '1/3', '41', '200', '212', '00000179', '000000001799'), (216, '2/3', '41', '200', '212', '00000180', '000000001805'), (217, '3/3', '41', '200', '212', '00000181', '000000001814'), (218, '1/3', '42', '150', '162', '00000182', '000000001823'), (219, '2/3', '42', '150', '162', '00000183', '000000001832'), (220, '3/3', '42', '150', '162', '00000184', '000000001841'); /*!40000 ALTER TABLE `generateqrsr` ENABLE KEYS */; -- Dumping structure for table laxachem.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=595 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.logtable: ~594 rows (approximately) /*!40000 ALTER TABLE `logtable` DISABLE KEYS */; INSERT INTO `logtable` (`id`, `username`, `action`, `time`, `userid`, `tablename`) VALUES (1, NULL, 'QR generated', NULL, '3', NULL), (2, NULL, 'QR generated', '2024-03-07 17:07:21', '3', NULL), (3, NULL, 'Alias Product Added', '2024-03-07 17:22:18', '3', NULL), (4, NULL, 'Alias Product Edited', '2024-03-07 17:24:04', '3', NULL), (5, NULL, 'Alias Product Updated', '2024-03-07 17:24:12', '3', NULL), (6, NULL, 'Batch Added', '2024-03-07 17:40:27', '3', 'pbatch'), (7, NULL, 'Customer Added', '2024-03-07 17:50:47', '3', 'customer'), (8, NULL, 'Customer Updated', '2024-03-07 17:51:13', '3', 'customer'), (9, NULL, 'New Company Added', '2024-03-07 18:32:49', '3', 'manufacture'), (10, NULL, 'Company Updated', '2024-03-07 18:33:02', '3', 'manufacture'), (11, NULL, 'Company Deleted', '2024-03-07 18:33:23', '3', 'manufacture'), (12, NULL, 'New Product Added', '2024-03-07 18:37:40', '3', 'product'), (13, NULL, 'Product Updated', '2024-03-07 18:37:50', '3', 'product'), (14, NULL, 'Product Deleted', '2024-03-07 18:37:55', '3', 'product'), (15, NULL, 'Batch Data Deleted', '2024-03-07 18:39:09', '3', 'pbatch'), (16, NULL, 'Customer Updated', '2024-03-07 18:39:46', '3', 'customer'), (17, NULL, 'Customer Deleted', '2024-03-07 18:39:53', '3', 'customer'), (18, NULL, 'Alias Product Added', '2024-03-07 18:40:19', '3', 'AliasProduct'), (19, NULL, 'Alias Product Edited', '2024-03-07 18:40:22', '3', 'AliasProduct'), (20, NULL, 'Alias Product Updated', '2024-03-07 18:40:25', '3', 'AliasProduct'), (21, NULL, 'Single Print Had Taken', '2024-03-07 18:41:46', '3', 'generateqrsr'), (22, NULL, 'Multiple Print Had Taken', '2024-03-07 18:42:01', '3', 'generateqrsr'), (23, NULL, 'New User Added', '2024-03-08 11:25:42', '3', 'userm'), (24, NULL, 'User Data And Rights Updated', '2024-03-08 11:26:19', '3', 'userm'), (25, NULL, 'User Deleted', '2024-03-08 11:26:24', '3', 'userm'), (26, NULL, 'QR generated', '2024-03-08 11:33:21', '3', 'generateqrsr'), (27, NULL, 'Single Print Had Taken', '2024-03-08 11:33:54', '3', 'generateqrsr'), (28, NULL, 'Multiple Print Had Taken', '2024-03-08 11:34:01', '3', 'generateqrsr'), (29, NULL, 'User Data And Rights Updated', '2024-03-08 12:04:06', '3', 'userm'), (30, NULL, 'Product Deleted', '2024-03-08 12:45:27', '3', 'product'), (31, NULL, 'Product Updated', '2024-03-08 12:45:59', '3', 'product'), (32, NULL, 'Multiple Print Had Taken', '2024-03-08 15:04:05', '3', 'generateqrsr'), (33, NULL, 'Single Print Had Taken', '2024-03-08 15:04:26', '3', 'generateqrsr'), (34, NULL, 'Single Print Had Taken', '2024-03-08 15:04:38', '3', 'generateqrsr'), (35, NULL, 'Single Print Had Taken', '2024-03-08 15:04:47', '3', 'generateqrsr'), (36, NULL, 'Single Print Had Taken', '2024-03-08 15:04:57', '3', 'generateqrsr'), (37, NULL, 'Multiple Print Had Taken', '2024-03-08 15:05:05', '3', 'generateqrsr'), (38, NULL, 'Single Print Had Taken', '2024-03-08 15:06:38', '3', 'generateqrsr'), (39, NULL, 'Multiple Print Had Taken', '2024-03-08 15:06:47', '3', 'generateqrsr'), (40, NULL, 'Single Print Had Taken', '2024-03-08 15:07:12', '3', 'generateqrsr'), (41, NULL, 'Multiple Print Had Taken', '2024-03-08 15:07:22', '3', 'generateqrsr'), (42, NULL, 'Multiple Print Had Taken', '2024-03-08 15:09:22', '3', 'generateqrsr'), (43, NULL, 'Multiple Print Had Taken', '2024-03-08 15:10:13', '3', 'generateqrsr'), (44, NULL, 'Multiple Print Had Taken', '2024-03-08 15:11:00', '3', 'generateqrsr'), (45, NULL, 'Multiple Print Had Taken', '2024-03-08 15:12:16', '3', 'generateqrsr'), (46, NULL, 'Multiple Print Had Taken', '2024-03-08 15:14:44', '3', 'generateqrsr'), (47, NULL, 'Multiple Print Had Taken', '2024-03-08 15:16:54', '3', 'generateqrsr'), (48, NULL, 'Single Print Had Taken', '2024-03-08 16:10:00', '3', 'generateqrsr'), (49, NULL, 'Multiple Print Had Taken', '2024-03-08 16:10:28', '3', 'generateqrsr'), (50, NULL, 'Multiple Print Had Taken', '2024-03-08 16:15:51', '3', 'generateqrsr'), (51, NULL, 'Multiple Print Had Taken', '2024-03-08 16:16:38', '3', 'generateqrsr'), (52, NULL, 'Multiple Print Had Taken', '2024-03-08 16:17:11', '3', 'generateqrsr'), (53, NULL, 'Multiple Print Had Taken', '2024-03-08 17:13:17', '3', 'generateqrsr'), (54, NULL, 'Multiple Print Had Taken', '2024-03-08 17:16:04', '3', 'generateqrsr'), (55, NULL, 'Multiple Print Had Taken', '2024-03-08 17:17:55', '3', 'generateqrsr'), (56, NULL, 'Multiple Print Had Taken', '2024-03-08 17:19:27', '3', 'generateqrsr'), (57, NULL, 'Multiple Print Had Taken', '2024-03-08 17:19:52', '3', 'generateqrsr'), (58, NULL, 'Multiple Print Had Taken', '2024-03-08 17:21:18', '3', 'generateqrsr'), (59, NULL, 'Multiple Print Had Taken', '2024-03-08 17:21:31', '3', 'generateqrsr'), (60, NULL, 'Multiple Print Had Taken', '2024-03-08 17:30:19', '3', 'generateqrsr'), (61, NULL, 'Multiple Print Had Taken', '2024-03-08 17:31:54', '3', 'generateqrsr'), (62, NULL, 'Multiple Print Had Taken', '2024-03-08 17:32:46', '3', 'generateqrsr'), (63, NULL, 'Multiple Print Had Taken', '2024-03-08 17:46:44', '3', 'generateqrsr'), (64, NULL, 'Multiple Print Had Taken', '2024-03-08 17:48:02', '3', 'generateqrsr'), (65, NULL, 'Multiple Print Had Taken', '2024-03-08 17:50:06', '3', 'generateqrsr'), (66, NULL, 'Multiple Print Had Taken', '2024-03-08 17:55:40', '3', 'generateqrsr'), (67, NULL, 'Multiple Print Had Taken', '2024-03-08 18:02:53', '3', 'generateqrsr'), (68, NULL, 'Multiple Print Had Taken', '2024-03-08 18:04:20', '3', 'generateqrsr'), (69, NULL, 'Multiple Print Had Taken', '2024-03-08 18:05:39', '3', 'generateqrsr'), (70, NULL, 'Multiple Print Had Taken', '2024-03-08 18:06:33', '3', 'generateqrsr'), (71, NULL, 'Multiple Print Had Taken', '2024-03-08 18:09:07', '3', 'generateqrsr'), (72, NULL, 'Multiple Print Had Taken', '2024-03-08 18:09:15', '3', 'generateqrsr'), (73, NULL, 'Multiple Print Had Taken', '2024-03-08 18:09:40', '3', 'generateqrsr'), (74, NULL, 'Multiple Print Had Taken', '2024-03-08 18:09:50', '3', 'generateqrsr'), (75, NULL, 'Multiple Print Had Taken', '2024-03-08 18:09:57', '3', 'generateqrsr'), (76, NULL, 'Multiple Print Had Taken', '2024-03-08 18:09:57', '3', 'generateqrsr'), (77, NULL, 'Multiple Print Had Taken', '2024-03-08 18:09:58', '3', 'generateqrsr'), (78, NULL, 'Multiple Print Had Taken', '2024-03-08 18:09:58', '3', 'generateqrsr'), (79, NULL, 'Multiple Print Had Taken', '2024-03-08 18:09:58', '3', 'generateqrsr'), (80, NULL, 'Multiple Print Had Taken', '2024-03-08 18:09:58', '3', 'generateqrsr'), (81, NULL, 'Multiple Print Had Taken', '2024-03-08 18:09:59', '3', 'generateqrsr'), (82, NULL, 'Multiple Print Had Taken', '2024-03-08 18:09:59', '3', 'generateqrsr'), (83, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:00', '3', 'generateqrsr'), (84, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:09', '3', 'generateqrsr'), (85, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:10', '3', 'generateqrsr'), (86, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:11', '3', 'generateqrsr'), (87, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:11', '3', 'generateqrsr'), (88, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:11', '3', 'generateqrsr'), (89, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:11', '3', 'generateqrsr'), (90, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:12', '3', 'generateqrsr'), (91, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:12', '3', 'generateqrsr'), (92, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:12', '3', 'generateqrsr'), (93, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:13', '3', 'generateqrsr'), (94, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:13', '3', 'generateqrsr'), (95, NULL, 'Multiple Print Had Taken', '2024-03-08 18:11:23', '3', 'generateqrsr'), (96, NULL, 'Multiple Print Had Taken', '2024-03-08 18:12:06', '3', 'generateqrsr'), (97, NULL, 'Multiple Print Had Taken', '2024-03-08 18:15:42', '3', 'generateqrsr'), (98, NULL, 'Multiple Print Had Taken', '2024-03-08 18:15:47', '3', 'generateqrsr'), (99, NULL, 'Multiple Print Had Taken', '2024-03-08 18:15:53', '3', 'generateqrsr'), (100, NULL, 'Multiple Print Had Taken', '2024-03-08 18:17:32', '3', 'generateqrsr'), (101, NULL, 'Multiple Print Had Taken', '2024-03-08 18:19:01', '3', 'generateqrsr'), (102, NULL, 'Single Print Had Taken', '2024-03-08 18:26:37', '3', 'generateqrsr'), (103, NULL, 'Single Print Had Taken', '2024-03-08 18:26:51', '3', 'generateqrsr'), (104, NULL, 'Single Print Had Taken', '2024-03-08 18:33:01', '3', 'generateqrsr'), (105, NULL, 'Single Print Had Taken', '2024-03-08 18:34:33', '3', 'generateqrsr'), (106, NULL, 'Single Print Had Taken', '2024-03-08 18:36:03', '3', 'generateqrsr'), (107, NULL, 'Single Print Had Taken', '2024-03-08 18:36:56', '3', 'generateqrsr'), (108, NULL, 'Single Print Had Taken', '2024-03-08 18:38:01', '3', 'generateqrsr'), (109, NULL, 'Single Print Had Taken', '2024-03-08 18:39:00', '3', 'generateqrsr'), (110, NULL, 'Single Print Had Taken', '2024-03-08 18:40:08', '3', 'generateqrsr'), (111, NULL, 'Single Print Had Taken', '2024-03-08 18:40:59', '3', 'generateqrsr'), (112, NULL, 'Single Print Had Taken', '2024-03-08 18:42:03', '3', 'generateqrsr'), (113, NULL, 'Single Print Had Taken', '2024-03-08 21:08:01', '3', 'generateqrsr'), (114, NULL, 'Single Print Had Taken', '2024-03-08 22:28:45', '3', 'generateqrsr'), (115, NULL, 'Single Print Had Taken', '2024-03-08 22:29:02', '3', 'generateqrsr'), (116, NULL, 'Single Print Had Taken', '2024-03-08 22:30:15', '3', 'generateqrsr'), (117, NULL, 'Single Print Had Taken', '2024-03-08 22:32:33', '3', 'generateqrsr'), (118, NULL, 'Single Print Had Taken', '2024-03-08 22:33:08', '3', 'generateqrsr'), (119, NULL, 'Single Print Had Taken', '2024-03-08 22:34:00', '3', 'generateqrsr'), (120, NULL, 'Single Print Had Taken', '2024-03-08 22:34:38', '3', 'generateqrsr'), (121, NULL, 'Single Print Had Taken', '2024-03-08 22:37:19', '3', 'generateqrsr'), (122, NULL, 'Multiple Print Had Taken', '2024-03-08 22:37:44', '3', 'generateqrsr'), (123, NULL, 'Single Print Had Taken', '2024-03-08 22:38:28', '3', 'generateqrsr'), (124, NULL, 'Multiple Print Had Taken', '2024-03-08 22:41:16', '3', 'generateqrsr'), (125, NULL, 'Multiple Print Had Taken', '2024-03-08 22:42:12', '3', 'generateqrsr'), (126, NULL, 'Single Print Had Taken', '2024-03-08 22:49:44', '3', 'generateqrsr'), (127, NULL, 'Single Print Had Taken', '2024-03-08 22:49:57', '3', 'generateqrsr'), (128, NULL, 'Single Print Had Taken', '2024-03-08 22:51:57', '3', 'generateqrsr'), (129, NULL, 'Single Print Had Taken', '2024-03-08 22:57:35', '3', 'generateqrsr'), (130, NULL, 'Multiple Print Had Taken', '2024-03-08 22:57:54', '3', 'generateqrsr'), (131, NULL, 'Single Print Had Taken', '2024-03-09 18:55:03', '3', 'generateqrsr'), (132, NULL, 'Multiple Print Had Taken', '2024-03-09 18:55:15', '3', 'generateqrsr'), (133, NULL, 'Single Print Had Taken', '2024-03-09 19:38:53', '3', 'generateqrsr'), (134, NULL, 'Single Print Had Taken', '2024-03-09 19:40:48', '3', 'generateqrsr'), (135, NULL, 'Single Print Had Taken', '2024-03-11 10:26:35', '3', 'generateqrsr'), (136, NULL, 'Single Print Had Taken', '2024-03-11 10:26:58', '3', 'generateqrsr'), (137, NULL, 'Single Print Had Taken', '2024-03-11 10:27:20', '3', 'generateqrsr'), (138, NULL, 'Single Print Had Taken', '2024-03-11 11:13:45', '3', 'generateqrsr'), (139, NULL, 'Multiple Print Had Taken', '2024-03-11 11:15:56', '3', 'generateqrsr'), (140, NULL, 'Single Print Had Taken', '2024-03-11 11:17:39', '3', 'generateqrsr'), (141, NULL, 'Single Print Had Taken', '2024-03-11 11:19:32', '3', 'generateqrsr'), (142, NULL, 'Single Print Had Taken', '2024-03-11 11:20:52', '3', 'generateqrsr'), (143, NULL, 'Single Print Had Taken', '2024-03-11 11:21:18', '3', 'generateqrsr'), (144, NULL, 'Single Print Had Taken', '2024-03-11 11:21:27', '3', 'generateqrsr'), (145, NULL, 'Single Print Had Taken', '2024-03-11 11:21:41', '3', 'generateqrsr'), (146, NULL, 'Single Print Had Taken', '2024-03-11 11:23:01', '3', 'generateqrsr'), (147, NULL, 'User Data And Rights Updated', '2024-03-11 11:47:23', '3', 'userm'), (148, NULL, 'QR generated', '2024-03-11 15:29:12', '3', 'generateqrsr'), (149, NULL, 'QR generated', '2024-03-11 15:41:04', '3', 'generateqrsr'), (150, NULL, 'Single Print Had Taken', '2024-03-12 11:01:32', '3', 'generateqrsr'), (151, NULL, 'Alias Product Added', '2024-03-13 16:53:00', '3', 'AliasProduct'), (152, NULL, 'Alias Product Added', '2024-03-13 16:54:36', '3', 'AliasProduct'), (153, NULL, 'Alias Product Edited', '2024-03-13 17:02:28', '3', 'AliasProduct'), (154, NULL, 'Alias Product Updated', '2024-03-13 17:02:38', '3', 'AliasProduct'), (155, NULL, 'Alias Product Edited', '2024-03-13 17:06:35', '3', 'AliasProduct'), (156, NULL, 'Alias Product Updated', '2024-03-13 17:06:40', '3', 'AliasProduct'), (157, NULL, 'Alias Product Added', '2024-03-14 11:34:57', '3', 'AliasProduct'), (158, NULL, 'Alias Product Edited', '2024-03-14 11:35:28', '3', 'AliasProduct'), (159, NULL, 'Alias Product Added', '2024-03-14 11:39:39', '3', 'AliasProduct'), (160, NULL, 'Alias Product Added', '2024-03-14 11:39:47', '3', 'AliasProduct'), (161, NULL, 'Alias Product Added', '2024-03-14 11:39:54', '3', 'AliasProduct'), (162, NULL, 'Alias Product Edited', '2024-03-14 11:47:44', '3', 'AliasProduct'), (163, NULL, 'Alias Product Edited', '2024-03-14 11:50:24', '3', 'AliasProduct'), (164, NULL, 'Alias Product Edited', '2024-03-14 11:51:01', '3', 'AliasProduct'), (165, NULL, 'Alias Product Updated', '2024-03-14 11:51:08', '3', 'AliasProduct'), (166, NULL, 'Alias Product Added', '2024-03-14 11:52:55', '3', 'AliasProduct'), (167, NULL, 'Alias Product Edited', '2024-03-14 11:53:30', '3', 'AliasProduct'), (168, NULL, 'Alias Product Updated', '2024-03-14 11:53:34', '3', 'AliasProduct'), (169, NULL, 'Alias Product Edited', '2024-03-14 11:54:58', '3', 'AliasProduct'), (170, NULL, 'Alias Product Updated', '2024-03-14 11:55:03', '3', 'AliasProduct'), (171, NULL, 'Alias Product Edited', '2024-03-14 12:02:19', '3', 'AliasProduct'), (172, NULL, 'Alias Product Updated', '2024-03-14 12:02:23', '3', 'AliasProduct'), (173, NULL, 'Single Print Had Taken', '2024-03-14 13:40:42', '3', 'generateqrsr'), (174, NULL, 'Single Print Had Taken', '2024-03-14 13:41:01', '3', 'generateqrsr'), (175, NULL, 'Single Print Had Taken', '2024-03-14 13:41:18', '3', 'generateqrsr'), (176, NULL, 'Single Print Had Taken', '2024-03-14 13:41:58', '3', 'generateqrsr'), (177, NULL, 'Batch Added', '2024-03-14 14:43:16', '3', 'pbatch'), (178, NULL, 'Alias Product Added', '2024-03-14 14:44:49', '3', 'AliasProduct'), (179, NULL, 'QR generated', '2024-03-14 14:45:29', '3', 'generateqrsr'), (180, NULL, 'Single Print Had Taken', '2024-03-14 14:45:38', '3', 'generateqrsr'), (181, NULL, 'Multiple Print Had Taken', '2024-03-14 14:46:13', '3', 'generateqrsr'), (182, NULL, 'Single Print Had Taken', '2024-03-14 14:54:37', '3', 'generateqrsr'), (183, NULL, 'Single Print Had Taken', '2024-03-14 14:58:09', '3', 'generateqrsr'), (184, NULL, 'Single Print Had Taken', '2024-03-14 14:58:52', '3', 'generateqrsr'), (185, NULL, 'Single Print Had Taken', '2024-03-14 15:00:19', '3', 'generateqrsr'), (186, NULL, 'Single Print Had Taken', '2024-03-14 15:01:15', '3', 'generateqrsr'), (187, NULL, 'Single Print Had Taken', '2024-03-14 15:03:00', '3', 'generateqrsr'), (188, NULL, 'Single Print Had Taken', '2024-03-14 15:04:00', '3', 'generateqrsr'), (189, NULL, 'Single Print Had Taken', '2024-03-14 15:05:38', '3', 'generateqrsr'), (190, NULL, 'Single Print Had Taken', '2024-03-14 15:09:32', '3', 'generateqrsr'), (191, NULL, 'Single Print Had Taken', '2024-03-14 15:10:45', '3', 'generateqrsr'), (192, NULL, 'Single Print Had Taken', '2024-03-14 15:11:28', '3', 'generateqrsr'), (193, NULL, 'Single Print Had Taken', '2024-03-14 15:13:44', '3', 'generateqrsr'), (194, NULL, 'Single Print Had Taken', '2024-03-14 15:15:07', '3', 'generateqrsr'), (195, NULL, 'Single Print Had Taken', '2024-03-14 15:15:55', '3', 'generateqrsr'), (196, NULL, 'Single Print Had Taken', '2024-03-14 15:16:24', '3', 'generateqrsr'), (197, NULL, 'Single Print Had Taken', '2024-03-14 15:17:25', '3', 'generateqrsr'), (198, NULL, 'Single Print Had Taken', '2024-03-14 15:18:26', '3', 'generateqrsr'), (199, NULL, 'Single Print Had Taken', '2024-03-14 15:19:37', '3', 'generateqrsr'), (200, NULL, 'Single Print Had Taken', '2024-03-14 15:20:58', '3', 'generateqrsr'), (201, NULL, 'Single Print Had Taken', '2024-03-14 15:21:29', '3', 'generateqrsr'), (202, NULL, 'Single Print Had Taken', '2024-03-14 15:22:04', '3', 'generateqrsr'), (203, NULL, 'Single Print Had Taken', '2024-03-14 15:23:29', '3', 'generateqrsr'), (204, NULL, 'Single Print Had Taken', '2024-03-14 15:24:24', '3', 'generateqrsr'), (205, NULL, 'Single Print Had Taken', '2024-03-14 15:25:13', '3', 'generateqrsr'), (206, NULL, 'Single Print Had Taken', '2024-03-14 15:26:35', '3', 'generateqrsr'), (207, NULL, 'Single Print Had Taken', '2024-03-14 15:27:44', '3', 'generateqrsr'), (208, NULL, 'Single Print Had Taken', '2024-03-14 15:29:24', '3', 'generateqrsr'), (209, NULL, 'Single Print Had Taken', '2024-03-14 15:30:12', '3', 'generateqrsr'), (210, NULL, 'Single Print Had Taken', '2024-03-14 15:30:51', '3', 'generateqrsr'), (211, NULL, 'Single Print Had Taken', '2024-03-14 15:32:32', '3', 'generateqrsr'), (212, NULL, 'Single Print Had Taken', '2024-03-14 15:33:35', '3', 'generateqrsr'), (213, NULL, 'Single Print Had Taken', '2024-03-14 15:34:26', '3', 'generateqrsr'), (214, NULL, 'Single Print Had Taken', '2024-03-14 15:35:49', '3', 'generateqrsr'), (215, NULL, 'Single Print Had Taken', '2024-03-14 15:36:40', '3', 'generateqrsr'), (216, NULL, 'Single Print Had Taken', '2024-03-14 15:37:15', '3', 'generateqrsr'), (217, NULL, 'Single Print Had Taken', '2024-03-14 15:37:40', '3', 'generateqrsr'), (218, NULL, 'Single Print Had Taken', '2024-03-14 15:38:25', '3', 'generateqrsr'), (219, NULL, 'Single Print Had Taken', '2024-03-14 15:38:53', '3', 'generateqrsr'), (220, NULL, 'Single Print Had Taken', '2024-03-14 15:39:26', '3', 'generateqrsr'), (221, NULL, 'Single Print Had Taken', '2024-03-14 15:41:03', '3', 'generateqrsr'), (222, NULL, 'Single Print Had Taken', '2024-03-14 15:41:46', '3', 'generateqrsr'), (223, NULL, 'Single Print Had Taken', '2024-03-14 15:42:48', '3', 'generateqrsr'), (224, NULL, 'Single Print Had Taken', '2024-03-14 15:43:33', '3', 'generateqrsr'), (225, NULL, 'Single Print Had Taken', '2024-03-14 15:44:54', '3', 'generateqrsr'), (226, NULL, 'Single Print Had Taken', '2024-03-14 15:57:47', '3', 'generateqrsr'), (227, NULL, 'Single Print Had Taken', '2024-03-14 15:58:48', '3', 'generateqrsr'), (228, NULL, 'Single Print Had Taken', '2024-03-14 15:59:26', '3', 'generateqrsr'), (229, NULL, 'Single Print Had Taken', '2024-03-14 16:01:27', '3', 'generateqrsr'), (230, NULL, 'Single Print Had Taken', '2024-03-14 16:03:07', '3', 'generateqrsr'), (231, NULL, 'Single Print Had Taken', '2024-03-14 16:03:33', '3', 'generateqrsr'), (232, NULL, 'Single Print Had Taken', '2024-03-14 16:19:51', '3', 'generateqrsr'), (233, NULL, 'Single Print Had Taken', '2024-03-14 16:20:47', '3', 'generateqrsr'), (234, NULL, 'Single Print Had Taken', '2024-03-14 16:21:27', '3', 'generateqrsr'), (235, NULL, 'Single Print Had Taken', '2024-03-14 16:22:06', '3', 'generateqrsr'), (236, NULL, 'Single Print Had Taken', '2024-03-14 16:25:22', '3', 'generateqrsr'), (237, NULL, 'Single Print Had Taken', '2024-03-14 16:26:00', '3', 'generateqrsr'), (238, NULL, 'Single Print Had Taken', '2024-03-14 16:26:26', '3', 'generateqrsr'), (239, NULL, 'Single Print Had Taken', '2024-03-14 16:26:51', '3', 'generateqrsr'), (240, NULL, 'Single Print Had Taken', '2024-03-14 16:27:21', '3', 'generateqrsr'), (241, NULL, 'Single Print Had Taken', '2024-03-14 16:27:45', '3', 'generateqrsr'), (242, NULL, 'Single Print Had Taken', '2024-03-14 16:28:08', '3', 'generateqrsr'), (243, NULL, 'Single Print Had Taken', '2024-03-14 16:28:35', '3', 'generateqrsr'), (244, NULL, 'Single Print Had Taken', '2024-03-14 16:29:28', '3', 'generateqrsr'), (245, NULL, 'Single Print Had Taken', '2024-03-14 16:30:04', '3', 'generateqrsr'), (246, NULL, 'Single Print Had Taken', '2024-03-14 16:31:13', '3', 'generateqrsr'), (247, NULL, 'Single Print Had Taken', '2024-03-14 16:31:51', '3', 'generateqrsr'), (248, NULL, 'Single Print Had Taken', '2024-03-14 16:32:27', '3', 'generateqrsr'), (249, NULL, 'Single Print Had Taken', '2024-03-14 16:34:38', '3', 'generateqrsr'), (250, NULL, 'Single Print Had Taken', '2024-03-14 16:35:56', '3', 'generateqrsr'), (251, NULL, 'Single Print Had Taken', '2024-03-14 16:41:10', '3', 'generateqrsr'), (252, NULL, 'Single Print Had Taken', '2024-03-14 16:42:36', '3', 'generateqrsr'), (253, NULL, 'Single Print Had Taken', '2024-03-14 16:43:24', '3', 'generateqrsr'), (254, NULL, 'Single Print Had Taken', '2024-03-14 16:46:53', '3', 'generateqrsr'), (255, NULL, 'Single Print Had Taken', '2024-03-14 16:52:03', '3', 'generateqrsr'), (256, NULL, 'Single Print Had Taken', '2024-03-14 16:52:36', '3', 'generateqrsr'), (257, NULL, 'Single Print Had Taken', '2024-03-14 16:54:39', '3', 'generateqrsr'), (258, NULL, 'Single Print Had Taken', '2024-03-14 16:57:57', '3', 'generateqrsr'), (259, NULL, 'Single Print Had Taken', '2024-03-14 16:58:23', '3', 'generateqrsr'), (260, NULL, 'Single Print Had Taken', '2024-03-14 17:16:22', '3', 'generateqrsr'), (261, NULL, 'Single Print Had Taken', '2024-03-14 17:17:02', '3', 'generateqrsr'), (262, NULL, 'Single Print Had Taken', '2024-03-14 17:24:29', '3', 'generateqrsr'), (263, NULL, 'Single Print Had Taken', '2024-03-14 17:25:51', '3', 'generateqrsr'), (264, NULL, 'Single Print Had Taken', '2024-03-14 17:27:30', '3', 'generateqrsr'), (265, NULL, 'Single Print Had Taken', '2024-03-15 11:10:24', '3', 'generateqrsr'), (266, NULL, 'Multiple Print Had Taken', '2024-03-15 11:10:52', '3', 'generateqrsr'), (267, NULL, 'Multiple Print Had Taken', '2024-03-15 11:55:39', '3', 'generateqrsr'), (268, NULL, 'Single Print Had Taken', '2024-03-15 11:58:43', '3', 'generateqrsr'), (269, NULL, 'Single Print Had Taken', '2024-03-15 12:01:00', '3', 'generateqrsr'), (270, NULL, 'Single Print Had Taken', '2024-03-15 12:01:34', '3', 'generateqrsr'), (271, NULL, 'Single Print Had Taken', '2024-03-15 12:01:55', '3', 'generateqrsr'), (272, NULL, 'Single Print Had Taken', '2024-03-15 12:03:35', '3', 'generateqrsr'), (273, NULL, 'Single Print Had Taken', '2024-03-15 12:04:02', '3', 'generateqrsr'), (274, NULL, 'Single Print Had Taken', '2024-03-15 12:04:58', '3', 'generateqrsr'), (275, NULL, 'Single Print Had Taken', '2024-03-15 12:05:51', '3', 'generateqrsr'), (276, NULL, 'Multiple Print Had Taken', '2024-03-15 12:06:34', '3', 'generateqrsr'), (277, NULL, 'Single Print Had Taken', '2024-03-15 12:06:45', '3', 'generateqrsr'), (278, NULL, 'Single Print Had Taken', '2024-03-15 12:07:07', '3', 'generateqrsr'), (279, NULL, 'Single Print Had Taken', '2024-03-15 12:07:32', '3', 'generateqrsr'), (280, NULL, 'Single Print Had Taken', '2024-03-15 12:08:11', '3', 'generateqrsr'), (281, NULL, 'Single Print Had Taken', '2024-03-15 12:08:29', '3', 'generateqrsr'), (282, NULL, 'Single Print Had Taken', '2024-03-15 12:09:11', '3', 'generateqrsr'), (283, NULL, 'Single Print Had Taken', '2024-03-15 12:09:34', '3', 'generateqrsr'), (284, NULL, 'Single Print Had Taken', '2024-03-15 12:10:20', '3', 'generateqrsr'), (285, NULL, 'Single Print Had Taken', '2024-03-15 12:11:33', '3', 'generateqrsr'), (286, NULL, 'Single Print Had Taken', '2024-03-15 16:13:05', '3', 'generateqrsr'), (287, NULL, 'QR generated', '2024-03-16 14:55:16', '3', 'generateqrsr'), (288, NULL, 'Single Print Had Taken', '2024-03-16 14:55:32', '3', 'generateqrsr'), (289, NULL, 'Multiple Print Had Taken', '2024-03-16 14:55:41', '3', 'generateqrsr'), (290, NULL, 'QR generated', '2024-03-16 15:10:22', '3', 'generateqrsr'), (291, NULL, 'Single Print Had Taken', '2024-03-16 15:10:40', '3', 'generateqrsr'), (292, NULL, 'Single Print Had Taken', '2024-03-16 15:10:49', '3', 'generateqrsr'), (293, NULL, 'Multiple Print Had Taken', '2024-03-16 15:10:55', '3', 'generateqrsr'), (294, NULL, 'QR generated', '2024-03-16 15:12:30', '3', 'generateqrsr'), (295, NULL, 'Single Print Had Taken', '2024-03-16 15:12:36', '3', 'generateqrsr'), (296, NULL, 'Multiple Print Had Taken', '2024-03-16 15:12:52', '3', 'generateqrsr'), (297, NULL, 'Company Updated', '2024-03-17 11:25:08', '3', 'manufacture'), (298, NULL, 'Company Updated', '2024-03-17 11:26:56', '3', 'manufacture'), (299, NULL, 'Product Updated', '2024-03-17 11:56:47', '3', 'product'), (300, NULL, 'Product Deleted', '2024-03-17 14:43:21', '3', 'product'), (301, NULL, 'Batch Data Deleted', '2024-03-17 14:54:24', '3', 'pbatch'), (302, NULL, 'Customer Updated', '2024-03-17 15:11:58', '3', 'customer'), (303, NULL, 'User Data And Rights Updated', '2024-03-17 17:05:53', '3', 'userm'), (304, NULL, 'User Data And Rights Updated', '2024-03-17 17:06:53', '3', 'userm'), (305, NULL, 'User Data And Rights Updated', '2024-03-18 10:30:23', '3', 'userm'), (306, NULL, 'Single Print Had Taken', '2024-03-18 11:32:25', '3', 'generateqrsr'), (307, NULL, 'Multiple Print Had Taken', '2024-03-18 11:32:47', '3', 'generateqrsr'), (308, NULL, 'Single Print Had Taken', '2024-03-18 11:36:59', '3', 'generateqrsr'), (309, NULL, 'Single Print Had Taken', '2024-03-18 11:37:27', '3', 'generateqrsr'), (310, NULL, 'Single Print Had Taken', '2024-03-18 11:37:55', '3', 'generateqrsr'), (311, NULL, 'Single Print Had Taken', '2024-03-18 11:39:25', '3', 'generateqrsr'), (312, NULL, 'Single Print Had Taken', '2024-03-18 11:44:13', '3', 'generateqrsr'), (313, NULL, 'Single Print Had Taken', '2024-03-18 11:48:00', '3', 'generateqrsr'), (314, NULL, 'Single Print Had Taken', '2024-03-18 11:54:21', '3', 'generateqrsr'), (315, NULL, 'Single Print Had Taken', '2024-03-18 12:05:55', '3', 'generateqrsr'), (316, NULL, 'Single Print Had Taken', '2024-03-18 12:13:41', '3', 'generateqrsr'), (317, NULL, 'Single Print Had Taken', '2024-03-18 12:14:32', '3', 'generateqrsr'), (318, NULL, 'New User Added', '2024-03-18 12:17:43', '3', 'userm'), (319, NULL, 'Lot Added', '2024-03-18 12:20:58', '3', 'dispatch'), (320, NULL, 'Lot Added', '2024-03-18 12:22:08', '3', 'dispatch'), (321, NULL, 'Lot Added', '2024-03-18 16:21:48', '3', 'dispatch'), (322, NULL, 'Lot Added', '2024-03-18 16:23:51', '3', 'dispatch'), (323, NULL, 'Batch Added', '2024-03-19 11:44:10', '3', 'pbatch'), (324, NULL, 'Alias Product Added', '2024-03-19 11:44:41', '3', 'AliasProduct'), (325, NULL, 'QR generated', '2024-03-19 11:45:23', '3', 'generateqrsr'), (326, NULL, 'Single Print Had Taken', '2024-03-19 11:45:29', '3', 'generateqrsr'), (327, NULL, 'Single Print Had Taken', '2024-03-19 11:45:57', '3', 'generateqrsr'), (328, NULL, 'Single Print Had Taken', '2024-03-20 15:01:46', '3', 'generateqrsr'), (329, NULL, 'Multiple Print Had Taken', '2024-03-20 15:01:56', '3', 'generateqrsr'), (330, NULL, 'Lot Added', '2024-03-20 15:33:37', '3', 'dispatch'), (331, NULL, 'QR generated', '2024-03-20 15:40:17', '3', 'generateqrsr'), (332, NULL, 'Lot Added', '2024-03-20 15:40:34', '3', 'dispatch'), (333, NULL, 'Single Print Had Taken', '2024-03-21 10:35:18', '3', 'generateqrsr'), (334, NULL, 'Single Print Had Taken', '2024-03-21 10:36:08', '3', 'generateqrsr'), (335, NULL, 'Single Print Had Taken', '2024-03-21 10:36:42', '3', 'generateqrsr'), (336, NULL, 'Single Print Had Taken', '2024-03-21 10:37:34', '3', 'generateqrsr'), (337, NULL, 'Single Print Had Taken', '2024-03-21 10:39:09', '3', 'generateqrsr'), (338, NULL, 'Single Print Had Taken', '2024-03-21 10:39:38', '3', 'generateqrsr'), (339, NULL, 'Single Print Had Taken', '2024-03-21 10:40:43', '3', 'generateqrsr'), (340, NULL, 'Single Print Had Taken', '2024-03-21 10:41:14', '3', 'generateqrsr'), (341, NULL, 'Single Print Had Taken', '2024-03-21 10:42:07', '3', 'generateqrsr'), (342, NULL, 'Single Print Had Taken', '2024-03-21 10:42:53', '3', 'generateqrsr'), (343, NULL, 'Single Print Had Taken', '2024-03-21 10:44:16', '3', 'generateqrsr'), (344, NULL, 'Single Print Had Taken', '2024-03-21 10:44:40', '3', 'generateqrsr'), (345, NULL, 'Single Print Had Taken', '2024-03-21 10:45:05', '3', 'generateqrsr'), (346, NULL, 'Single Print Had Taken', '2024-03-21 10:45:58', '3', 'generateqrsr'), (347, NULL, 'Single Print Had Taken', '2024-03-21 10:47:15', '3', 'generateqrsr'), (348, NULL, 'Single Print Had Taken', '2024-03-21 10:48:25', '3', 'generateqrsr'), (349, NULL, 'Single Print Had Taken', '2024-03-21 10:50:14', '3', 'generateqrsr'), (350, NULL, 'Single Print Had Taken', '2024-03-21 10:50:57', '3', 'generateqrsr'), (351, NULL, 'Single Print Had Taken', '2024-03-21 10:51:36', '3', 'generateqrsr'), (352, NULL, 'Single Print Had Taken', '2024-03-21 10:52:06', '3', 'generateqrsr'), (353, NULL, 'Single Print Had Taken', '2024-03-21 10:52:35', '3', 'generateqrsr'), (354, NULL, 'Single Print Had Taken', '2024-03-21 10:53:03', '3', 'generateqrsr'), (355, NULL, 'Single Print Had Taken', '2024-03-21 10:54:11', '3', 'generateqrsr'), (356, NULL, 'Single Print Had Taken', '2024-03-21 10:54:36', '3', 'generateqrsr'), (357, NULL, 'Single Print Had Taken', '2024-03-21 10:55:06', '3', 'generateqrsr'), (358, NULL, 'Single Print Had Taken', '2024-03-21 10:55:35', '3', 'generateqrsr'), (359, NULL, 'Single Print Had Taken', '2024-03-21 10:56:13', '3', 'generateqrsr'), (360, NULL, 'Single Print Had Taken', '2024-03-21 10:56:37', '3', 'generateqrsr'), (361, NULL, 'Lot Added', '2024-03-21 11:15:23', '3', 'dispatch'), (362, NULL, 'Single Print Had Taken', '2024-03-21 11:26:09', '3', 'generateqrsr'), (363, NULL, 'Single Print Had Taken', '2024-03-21 11:26:33', '3', 'generateqrsr'), (364, NULL, 'Single Print Had Taken', '2024-03-21 11:27:18', '3', 'generateqrsr'), (365, NULL, 'Single Print Had Taken', '2024-03-21 11:28:26', '3', 'generateqrsr'), (366, NULL, 'Single Print Had Taken', '2024-03-21 11:34:25', '3', 'generateqrsr'), (367, NULL, 'Single Print Had Taken', '2024-03-21 11:36:52', '3', 'generateqrsr'), (368, NULL, 'Single Print Had Taken', '2024-03-21 11:43:17', '3', 'generateqrsr'), (369, NULL, 'Single Print Had Taken', '2024-03-21 11:43:45', '3', 'generateqrsr'), (370, NULL, 'Single Print Had Taken', '2024-03-21 11:45:42', '3', 'generateqrsr'), (371, NULL, 'Single Print Had Taken', '2024-03-21 11:49:14', '3', 'generateqrsr'), (372, NULL, 'Single Print Had Taken', '2024-03-21 11:50:03', '3', 'generateqrsr'), (373, NULL, 'Single Print Had Taken', '2024-03-21 11:50:45', '3', 'generateqrsr'), (374, NULL, 'Single Print Had Taken', '2024-03-21 11:51:09', '3', 'generateqrsr'), (375, NULL, 'Single Print Had Taken', '2024-03-21 11:52:42', '3', 'generateqrsr'), (376, NULL, 'Single Print Had Taken', '2024-03-21 11:53:03', '3', 'generateqrsr'), (377, NULL, 'Single Print Had Taken', '2024-03-21 11:53:28', '3', 'generateqrsr'), (378, NULL, 'Single Print Had Taken', '2024-03-21 11:53:48', '3', 'generateqrsr'), (379, NULL, 'Single Print Had Taken', '2024-03-21 11:54:45', '3', 'generateqrsr'), (380, NULL, 'Single Print Had Taken', '2024-03-21 11:55:40', '3', 'generateqrsr'), (381, NULL, 'Single Print Had Taken', '2024-03-21 11:56:03', '3', 'generateqrsr'), (382, NULL, 'Single Print Had Taken', '2024-03-21 11:57:26', '3', 'generateqrsr'), (383, NULL, 'Single Print Had Taken', '2024-03-21 11:57:50', '3', 'generateqrsr'), (384, NULL, 'Single Print Had Taken', '2024-03-21 11:58:02', '3', 'generateqrsr'), (385, NULL, 'Single Print Had Taken', '2024-03-21 11:58:31', '3', 'generateqrsr'), (386, NULL, 'Single Print Had Taken', '2024-03-21 11:59:09', '3', 'generateqrsr'), (387, NULL, 'Single Print Had Taken', '2024-03-21 11:59:44', '3', 'generateqrsr'), (388, NULL, 'Single Print Had Taken', '2024-03-21 12:01:02', '3', 'generateqrsr'), (389, NULL, 'Single Print Had Taken', '2024-03-21 12:02:37', '3', 'generateqrsr'), (390, NULL, 'Single Print Had Taken', '2024-03-21 12:05:47', '3', 'generateqrsr'), (391, NULL, 'Single Print Had Taken', '2024-03-21 12:07:32', '3', 'generateqrsr'), (392, NULL, 'Single Print Had Taken', '2024-03-21 12:08:16', '3', 'generateqrsr'), (393, NULL, 'Single Print Had Taken', '2024-03-21 12:09:28', '3', 'generateqrsr'), (394, NULL, 'Single Print Had Taken', '2024-03-21 12:11:30', '3', 'generateqrsr'), (395, NULL, 'Single Print Had Taken', '2024-03-21 12:13:25', '3', 'generateqrsr'), (396, NULL, 'Single Print Had Taken', '2024-03-21 12:13:30', '3', 'generateqrsr'), (397, NULL, 'Single Print Had Taken', '2024-03-21 12:13:30', '3', 'generateqrsr'), (398, NULL, 'Single Print Had Taken', '2024-03-21 12:17:28', '3', 'generateqrsr'), (399, NULL, 'Single Print Had Taken', '2024-03-21 12:18:20', '3', 'generateqrsr'), (400, NULL, 'Single Print Had Taken', '2024-03-21 12:19:11', '3', 'generateqrsr'), (401, NULL, 'Single Print Had Taken', '2024-03-21 12:20:02', '3', 'generateqrsr'), (402, NULL, 'Single Print Had Taken', '2024-03-21 12:20:45', '3', 'generateqrsr'), (403, NULL, 'Single Print Had Taken', '2024-03-21 12:23:23', '3', 'generateqrsr'), (404, NULL, 'Single Print Had Taken', '2024-03-21 12:24:06', '3', 'generateqrsr'), (405, NULL, 'Single Print Had Taken', '2024-03-21 12:26:21', '3', 'generateqrsr'), (406, NULL, 'Single Print Had Taken', '2024-03-21 12:27:45', '3', 'generateqrsr'), (407, NULL, 'Single Print Had Taken', '2024-03-21 12:33:56', '3', 'generateqrsr'), (408, NULL, 'Alias Product Added', '2024-03-21 14:53:38', '3', 'Alias Product'), (409, NULL, 'Alias Product Added', '2024-03-21 15:03:07', '3', 'Alias Product'), (410, NULL, 'Single Print Had Taken', '2024-03-21 16:15:01', '3', 'generateqrsr'), (411, NULL, 'Single Print Had Taken', '2024-03-21 16:16:26', '3', 'generateqrsr'), (412, NULL, 'Single Print Had Taken', '2024-03-21 16:17:50', '3', 'generateqrsr'), (413, NULL, 'Single Print Had Taken', '2024-03-21 16:18:27', '3', 'generateqrsr'), (414, NULL, 'Single Print Had Taken', '2024-03-21 16:19:11', '3', 'generateqrsr'), (415, NULL, 'Single Print Had Taken', '2024-03-21 16:19:43', '3', 'generateqrsr'), (416, NULL, 'Single Print Had Taken', '2024-03-21 16:20:20', '3', 'generateqrsr'), (417, NULL, 'Single Print Had Taken', '2024-03-21 16:20:42', '3', 'generateqrsr'), (418, NULL, 'Single Print Had Taken', '2024-03-21 16:21:24', '3', 'generateqrsr'), (419, NULL, 'Single Print Had Taken', '2024-03-21 16:21:57', '3', 'generateqrsr'), (420, NULL, 'Single Print Had Taken', '2024-03-21 16:22:57', '3', 'generateqrsr'), (421, NULL, 'Single Print Had Taken', '2024-03-21 16:23:37', '3', 'generateqrsr'), (422, NULL, 'Single Print Had Taken', '2024-03-21 16:24:46', '3', 'generateqrsr'), (423, NULL, 'Single Print Had Taken', '2024-03-22 14:29:02', '3', 'generateqrsr'), (424, NULL, 'Single Print Had Taken', '2024-03-22 14:29:12', '3', 'generateqrsr'), (425, NULL, 'Multiple Print Had Taken', '2024-03-22 14:29:23', '3', 'generateqrsr'), (426, NULL, 'Single Print Had Taken', '2024-03-22 16:04:23', '3', 'generateqrsr'), (427, NULL, 'Single Print Had Taken', '2024-03-23 11:22:52', '3', 'generateqrsr'), (428, NULL, 'Multiple Print Had Taken', '2024-03-23 11:23:00', '3', 'generateqrsr'), (429, NULL, 'Single Print Had Taken', '2024-03-23 11:23:45', '3', 'generateqrsr'), (430, NULL, 'Multiple Print Had Taken', '2024-03-23 11:24:14', '3', 'generateqrsr'), (431, NULL, 'Multiple Print Had Taken', '2024-03-23 11:24:36', '3', 'generateqrsr'), (432, NULL, 'Single Print Had Taken', '2024-03-23 11:25:16', '3', 'generateqrsr'), (433, NULL, 'Single Print Had Taken', '2024-03-23 11:25:59', '3', 'generateqrsr'), (434, NULL, 'Single Print Had Taken', '2024-03-23 11:26:55', '3', 'generateqrsr'), (435, NULL, 'Single Print Had Taken', '2024-03-23 11:28:11', '3', 'generateqrsr'), (436, NULL, 'Single Print Had Taken', '2024-03-23 11:29:01', '3', 'generateqrsr'), (437, NULL, 'Single Print Had Taken', '2024-03-23 11:32:00', '3', 'generateqrsr'), (438, NULL, 'Single Print Had Taken', '2024-03-23 11:32:38', '3', 'generateqrsr'), (439, NULL, 'Single Print Had Taken', '2024-03-23 11:33:25', '3', 'generateqrsr'), (440, NULL, 'Single Print Had Taken', '2024-03-23 11:34:43', '3', 'generateqrsr'), (441, NULL, 'Single Print Had Taken', '2024-03-23 11:35:46', '3', 'generateqrsr'), (442, NULL, 'Single Print Had Taken', '2024-03-23 11:39:42', '3', 'generateqrsr'), (443, NULL, 'Single Print Had Taken', '2024-03-23 11:41:37', '3', 'generateqrsr'), (444, NULL, 'Single Print Had Taken', '2024-03-23 12:17:39', '3', 'generateqrsr'), (445, NULL, 'Multiple Print Had Taken', '2024-03-23 12:22:39', '3', 'generateqrsr'), (446, NULL, 'Single Print Had Taken', '2024-03-24 12:02:44', '3', 'generateqrsr'), (447, NULL, 'Single Print Had Taken', '2024-03-25 15:06:42', '3', 'generateqrsr'), (448, NULL, 'Single Print Had Taken', '2024-03-25 15:09:15', '3', 'generateqrsr'), (449, NULL, 'Single Print Had Taken', '2024-03-25 15:10:42', '3', 'generateqrsr'), (450, NULL, 'Single Print Had Taken', '2024-03-25 15:12:44', '3', 'generateqrsr'), (451, NULL, 'Single Print Had Taken', '2024-03-25 15:13:10', '3', 'generateqrsr'), (452, NULL, 'Single Print Had Taken', '2024-03-25 15:13:35', '3', 'generateqrsr'), (453, NULL, 'Single Print Had Taken', '2024-03-25 15:13:56', '3', 'generateqrsr'), (454, NULL, 'Single Print Had Taken', '2024-03-25 15:14:16', '3', 'generateqrsr'), (455, NULL, 'Single Print Had Taken', '2024-03-25 15:14:36', '3', 'generateqrsr'), (456, NULL, 'Single Print Had Taken', '2024-03-25 15:14:57', '3', 'generateqrsr'), (457, NULL, 'Single Print Had Taken', '2024-03-25 15:16:13', '3', 'generateqrsr'), (458, NULL, 'Single Print Had Taken', '2024-03-25 15:16:36', '3', 'generateqrsr'), (459, NULL, 'Alias Product Added', '2024-03-25 15:22:33', '3', 'Alias Product'), (460, NULL, 'Alias Product Edited', '2024-03-25 15:22:39', '3', 'Alias Product'), (461, NULL, 'Alias Product Updated', '2024-03-25 15:22:43', '3', 'Alias Product'), (462, NULL, 'Multiple Print Had Taken', '2024-03-26 10:58:03', '3', 'generateqrsr'), (463, NULL, 'Multiple Print Had Taken', '2024-03-26 10:58:45', '3', 'generateqrsr'), (464, NULL, 'Multiple Print Had Taken', '2024-03-26 11:02:28', '3', 'generateqrsr'), (465, NULL, 'Multiple Print Had Taken', '2024-03-26 11:03:08', '3', 'generateqrsr'), (466, NULL, 'Multiple Print Had Taken', '2024-03-26 11:04:12', '3', 'generateqrsr'), (467, NULL, 'Multiple Print Had Taken', '2024-03-26 11:05:22', '3', 'generateqrsr'), (468, NULL, 'Multiple Print Had Taken', '2024-03-26 11:05:42', '3', 'generateqrsr'), (469, NULL, 'Multiple Print Had Taken', '2024-03-26 11:06:19', '3', 'generateqrsr'), (470, NULL, 'Multiple Print Had Taken', '2024-03-26 11:06:28', '3', 'generateqrsr'), (471, NULL, 'Multiple Print Had Taken', '2024-03-26 11:08:05', '3', 'generateqrsr'), (472, NULL, 'Multiple Print Had Taken', '2024-03-26 11:08:57', '3', 'generateqrsr'), (473, NULL, 'Multiple Print Had Taken', '2024-03-26 11:14:22', '3', 'generateqrsr'), (474, NULL, 'Single Print Had Taken', '2024-03-26 12:04:48', '3', 'generateqrsr'), (475, NULL, 'Single Print Had Taken', '2024-03-26 12:05:56', '3', 'generateqrsr'), (476, NULL, 'Single Print Had Taken', '2024-03-26 12:07:30', '3', 'generateqrsr'), (477, NULL, 'Single Print Had Taken', '2024-03-26 12:08:11', '3', 'generateqrsr'), (478, NULL, 'Single Print Had Taken', '2024-03-26 12:31:40', '3', 'generateqrsr'), (479, NULL, 'Multiple Print Had Taken', '2024-03-26 12:31:48', '3', 'generateqrsr'), (480, NULL, 'Single Print Had Taken', '2024-03-26 13:32:42', '3', 'generateqrsr'), (481, NULL, 'Single Print Had Taken', '2024-03-26 13:35:47', '3', 'generateqrsr'), (482, NULL, 'Single Print Had Taken', '2024-03-26 13:38:13', '3', 'generateqrsr'), (483, NULL, 'Single Print Had Taken', '2024-03-26 13:38:35', '3', 'generateqrsr'), (484, NULL, 'Multiple Print Had Taken', '2024-03-26 13:38:42', '3', 'generateqrsr'), (485, NULL, 'Single Print Had Taken', '2024-03-26 13:39:12', '3', 'generateqrsr'), (486, NULL, 'Single Print Had Taken', '2024-03-26 13:40:03', '3', 'generateqrsr'), (487, NULL, 'Single Print Had Taken', '2024-03-26 13:41:09', '3', 'generateqrsr'), (488, NULL, 'Single Print Had Taken', '2024-03-26 13:41:50', '3', 'generateqrsr'), (489, NULL, 'Single Print Had Taken', '2024-03-26 13:43:52', '3', 'generateqrsr'), (490, NULL, 'Single Print Had Taken', '2024-03-26 13:44:45', '3', 'generateqrsr'), (491, NULL, 'Single Print Had Taken', '2024-03-26 15:21:46', '3', 'generateqrsr'), (492, NULL, 'Single Print Had Taken', '2024-03-26 15:22:56', '3', 'generateqrsr'), (493, NULL, 'Single Print Had Taken', '2024-03-26 15:24:07', '3', 'generateqrsr'), (494, NULL, 'Single Print Had Taken', '2024-03-26 15:25:00', '3', 'generateqrsr'), (495, NULL, 'Single Print Had Taken', '2024-03-26 15:25:47', '3', 'generateqrsr'), (496, NULL, 'Single Print Had Taken', '2024-03-27 11:11:50', '3', 'generateqrsr'), (497, NULL, 'Multiple Print Had Taken', '2024-03-27 11:12:16', '3', 'generateqrsr'), (498, NULL, 'Multiple Print Had Taken', '2024-03-27 11:13:15', '3', 'generateqrsr'), (499, NULL, 'Single Print Had Taken', '2024-03-27 11:21:40', '3', 'generateqrsr'), (500, NULL, 'Single Print Had Taken', '2024-03-27 11:29:52', '3', 'generateqrsr'), (501, NULL, 'Single Print Had Taken', '2024-03-27 11:38:46', '3', 'generateqrsr'), (502, NULL, 'Single Print Had Taken', '2024-03-27 11:41:04', '3', 'generateqrsr'), (503, NULL, 'Single Print Had Taken', '2024-03-27 11:43:03', '3', 'generateqrsr'), (504, NULL, 'New Product Added', '2024-03-27 11:45:06', '3', 'Product'), (505, NULL, 'Batch Added', '2024-03-27 11:48:59', '3', 'Batch'), (506, NULL, 'Alias Product Added', '2024-03-27 11:49:21', '3', 'Alias Product'), (507, NULL, 'QR generated', '2024-03-27 11:50:06', '3', 'Generateqr'), (508, NULL, 'Single Print Had Taken', '2024-03-27 11:50:14', '3', 'generateqrsr'), (509, NULL, 'Single Print Had Taken', '2024-03-27 11:52:03', '3', 'generateqrsr'), (510, NULL, 'Single Print Had Taken', '2024-03-27 11:52:32', '3', 'generateqrsr'), (511, NULL, 'Single Print Had Taken', '2024-03-27 11:55:20', '3', 'generateqrsr'), (512, NULL, 'Single Print Had Taken', '2024-03-27 11:57:02', '3', 'generateqrsr'), (513, NULL, 'Single Print Had Taken', '2024-03-27 11:57:42', '3', 'generateqrsr'), (514, NULL, 'Single Print Had Taken', '2024-03-27 11:58:04', '3', 'generateqrsr'), (515, NULL, 'Single Print Had Taken', '2024-03-27 11:58:50', '3', 'generateqrsr'), (516, NULL, 'Single Print Had Taken', '2024-03-27 11:59:20', '3', 'generateqrsr'), (517, NULL, 'Single Print Had Taken', '2024-03-27 11:59:49', '3', 'generateqrsr'), (518, NULL, 'Single Print Had Taken', '2024-03-27 12:00:47', '3', 'generateqrsr'), (519, NULL, 'Single Print Had Taken', '2024-03-27 12:01:08', '3', 'generateqrsr'), (520, NULL, 'Single Print Had Taken', '2024-03-27 12:01:59', '3', 'generateqrsr'), (521, NULL, 'Multiple Print Had Taken', '2024-03-27 12:03:06', '3', 'generateqrsr'), (522, NULL, 'Multiple Print Had Taken', '2024-03-27 12:28:06', '3', 'generateqrsr'), (523, NULL, 'Single Print Had Taken', '2024-03-27 12:28:17', '3', 'generateqrsr'), (524, NULL, 'User Data And Rights Updated', '2024-03-27 12:37:42', '3', 'userm'), (525, NULL, 'User Data And Rights Updated', '2024-03-27 12:44:53', '3', 'userm'), (526, NULL, 'User Data And Rights Updated', '2024-03-27 12:46:00', '3', 'userm'), (527, NULL, 'User Deleted', '2024-03-27 15:00:22', '3', 'userm'), (528, NULL, 'User Deleted', '2024-03-27 15:27:40', '3', 'userm'), (529, NULL, 'User Deleted', '2024-03-28 11:25:44', '3', 'userm'), (530, NULL, 'QR generated', '2024-03-29 12:15:54', '3', 'Generateqr'), (531, NULL, 'QR generated', '2024-03-29 12:20:05', '3', 'Generateqr'), (532, NULL, 'Single Print Had Taken', '2024-03-29 12:20:24', '3', 'generateqrsr'), (533, NULL, 'QR generated', '2024-03-29 12:21:40', '3', 'Generateqr'), (534, NULL, 'Single Print Had Taken', '2024-03-29 12:22:06', '3', 'generateqrsr'), (535, NULL, 'Multiple Print Had Taken', '2024-03-29 12:22:34', '3', 'generateqrsr'), (536, NULL, 'Single Print Had Taken', '2024-03-29 16:07:07', '3', 'generateqrsr'), (537, NULL, 'Single Print Had Taken', '2024-03-29 16:13:05', '3', 'generateqrsr'), (538, NULL, 'Multiple Print Had Taken', '2024-03-29 16:13:21', '3', 'generateqrsr'), (539, NULL, 'Single Print Had Taken', '2024-03-29 16:29:41', '3', 'generateqrsr'), (540, NULL, 'Single Print Had Taken', '2024-04-01 13:18:38', '3', 'generateqrsr'), (541, NULL, 'Multiple Print Had Taken', '2024-04-01 13:18:53', '3', 'generateqrsr'), (542, NULL, 'Multiple Print Had Taken', '2024-04-01 13:32:36', '3', 'generateqrsr'), (543, NULL, 'Single Print Had Taken', '2024-04-01 13:36:53', '3', 'generateqrsr'), (544, NULL, 'Multiple Print Had Taken', '2024-04-01 13:47:48', '3', 'generateqrsr'), (545, NULL, 'Alias Product Added', '2024-04-02 16:27:26', '3', 'Alias Product'), (546, NULL, 'Alias Product Added', '2024-04-03 11:43:36', '3', 'Alias Product'), (547, NULL, 'Alias Product Added', '2024-04-03 11:51:58', '3', 'Alias Product'), (548, NULL, 'Alias Product Added', '2024-04-03 11:58:57', '3', 'Alias Product'), (549, NULL, 'Alias Product Added', '2024-04-03 11:59:47', '3', 'Alias Product'), (550, NULL, 'Alias Product Added', '2024-04-03 13:23:50', '3', 'Alias Product'), (551, NULL, 'Alias Product Added', '2024-04-03 13:24:59', '3', 'Alias Product'), (552, NULL, 'New Company Added', '2024-04-03 13:30:47', '3', 'Company Unit'), (553, NULL, 'New Product Added', '2024-04-03 14:11:10', '3', 'Product'), (554, NULL, 'Batch Added', '2024-04-03 14:12:07', '3', 'Batch'), (555, NULL, 'Customer Added', '2024-04-03 14:13:02', '3', 'Customer'), (556, NULL, 'Single Print Had Taken', '2024-04-03 14:22:27', '3', 'generateqrsr'), (557, NULL, 'Multiple Print Had Taken', '2024-04-03 14:22:33', '3', 'generateqrsr'), (558, NULL, 'Alias Product Added', '2024-04-03 14:23:14', '3', 'Alias Product'), (559, NULL, 'QR generated', '2024-04-03 14:23:52', '3', 'Generateqr'), (560, NULL, 'Single Print Had Taken', '2024-04-03 14:24:05', '3', 'generateqrsr'), (561, NULL, 'Multiple Print Had Taken', '2024-04-03 14:24:23', '3', 'generateqrsr'), (562, NULL, 'Single Print Had Taken', '2024-04-03 14:24:34', '3', 'generateqrsr'), (563, NULL, 'Alias Product Added', '2024-04-03 16:31:19', '3', 'Alias Product'), (564, NULL, 'Alias Product Added', '2024-04-03 17:05:05', '3', 'Alias Product'), (565, NULL, 'Alias Product Added', '2024-04-03 17:11:28', '3', 'Alias Product'), (566, NULL, 'New Company Added', '2024-04-04 12:33:49', '3', 'Company Unit'), (567, NULL, 'Customer Added', '2024-04-04 12:36:42', '3', 'Customer'), (568, NULL, 'Customer Added', '2024-04-04 12:40:18', '3', 'Customer'), (569, NULL, 'Customer Deleted', '2024-04-04 12:41:33', '3', 'Customer'), (570, NULL, 'Product Updated', '2024-04-05 15:42:51', '3', 'Product'), (571, NULL, 'QR generated', '2024-04-08 12:03:14', '3', 'Generateqr'), (572, NULL, 'Customer Added', '2024-04-08 12:10:04', '3', 'Customer'), (573, NULL, 'Company Deleted', '2024-04-08 15:02:31', '3', 'Company Unit'), (574, NULL, 'Company Deleted', '2024-04-08 15:02:35', '3', 'Company Unit'), (575, NULL, 'Company Deleted', '2024-04-08 15:02:39', '3', 'Company Unit'), (576, NULL, 'Company Deleted', '2024-04-08 15:02:43', '3', 'Company Unit'), (577, NULL, 'Company Deleted', '2024-04-08 15:02:47', '3', 'Company Unit'), (578, NULL, 'Company Deleted', '2024-04-08 15:02:51', '3', 'Company Unit'), (579, NULL, 'Company Deleted', '2024-04-08 15:02:55', '3', 'Company Unit'), (580, NULL, 'Company Deleted', '2024-04-08 15:02:58', '3', 'Company Unit'), (581, NULL, 'New Company Added', '2024-04-08 15:03:43', '3', 'Company Unit'), (582, NULL, 'Company Deleted', '2024-04-08 15:06:43', '3', 'Company Unit'), (583, NULL, 'New Company Added', '2024-04-08 15:07:29', '3', 'Company Unit'), (584, NULL, 'Company Deleted', '2024-04-08 15:13:55', '3', 'Company Unit'), (585, NULL, 'New Company Added', '2024-04-08 15:17:14', '3', 'Company Unit'), (586, NULL, 'Company Deleted', '2024-04-08 15:26:36', '3', 'Company Unit'), (587, NULL, 'New Company Added', '2024-04-08 15:27:21', '3', 'Company Unit'), (588, NULL, 'New Product Added', '2024-04-08 15:28:49', '3', 'Product'), (589, NULL, 'Product Deleted', '2024-04-08 15:30:31', '3', 'Product'), (590, NULL, 'New Product Added', '2024-04-08 15:34:05', '3', 'Product'), (591, NULL, 'Batch Added', '2024-04-08 15:36:20', '3', 'Batch'), (592, NULL, 'Customer Added', '2024-04-08 15:37:32', '3', 'Customer'), (593, NULL, 'Alias Product Added', '2024-04-08 15:38:01', '3', 'Alias Product'), (594, NULL, 'New Product Added', '2024-04-08 15:39:17', '3', 'Product'); /*!40000 ALTER TABLE `logtable` ENABLE KEYS */; -- Dumping structure for table laxachem.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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.manufacture: ~2 rows (approximately) /*!40000 ALTER TABLE `manufacture` DISABLE KEYS */; INSERT INTO `manufacture` (`id`, `manu`, `dis`, `lic`, `prefix`, `add1`, `details`, `add2`, `created`, `updated`, `userid`) VALUES (22, 'LAXACHEM ORGANICS PVT. LTD.', 'LAXACHEM ORGANICS PVT. LTD.', '(25) AMD/3/96', 'GTIN1000', 'Plot No. D-2, MIDC', NULL, 'AMRAVATI-444607. (Maharashtra) INDIA', NULL, NULL, NULL), (29, 'WebMedia India', 'WebMedia', 'DGWEB', 'GTINWEB', 'Railway Station', NULL, 'Amravati', '2024-04-08 15:27:22', NULL, NULL); /*!40000 ALTER TABLE `manufacture` ENABLE KEYS */; -- Dumping structure for table laxachem.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', `createdat` datetime NOT NULL, `approvedat` datetime DEFAULT NULL, `rejremark` varchar(150) DEFAULT NULL, `rejectedat` datetime DEFAULT NULL, `itemname` varchar(500) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.pagemaster: ~86 rows (approximately) /*!40000 ALTER TABLE `pagemaster` DISABLE KEYS */; INSERT INTO `pagemaster` (`id`, `roleid`, `pageid`, `pagename`, `status`, `createdat`, `approvedat`, `rejremark`, `rejectedat`, `itemname`) VALUES (1, '3', '32', 'addproduct', '1', '2024-04-03 11:59:47', NULL, NULL, NULL, NULL), (2, '11', '32', 'addproduct', '0', '2024-04-03 11:59:47', NULL, NULL, NULL, NULL), (3, '3', '38', 'addproduct', '1', '2024-04-03 13:23:50', NULL, NULL, NULL, NULL), (4, '11', '38', 'addproduct', '0', '2024-04-03 13:23:50', NULL, NULL, NULL, NULL), (5, '4', '38', 'addproduct', '0', '2024-04-03 13:23:50', NULL, NULL, NULL, NULL), (6, '17', '38', 'addproduct', '0', '2024-04-03 13:23:51', NULL, NULL, NULL, NULL), (7, '21', '38', 'addproduct', '0', '2024-04-03 13:23:51', NULL, NULL, NULL, NULL), (8, '3', '39', 'addproduct', '-1', '2024-04-03 13:24:59', NULL, 'Quality i not upto the mark', NULL, NULL), (9, '11', '39', 'addproduct', '0', '2024-04-03 13:24:59', NULL, NULL, NULL, NULL), (10, '4', '39', 'addproduct', '0', '2024-04-03 13:24:59', NULL, NULL, NULL, NULL), (11, '17', '39', 'addproduct', '0', '2024-04-03 13:24:59', NULL, NULL, NULL, NULL), (12, '21', '39', 'addproduct', '0', '2024-04-03 13:24:59', NULL, NULL, NULL, NULL), (13, '', '24', 'addproduct', '0', '2024-04-03 13:30:47', NULL, NULL, NULL, NULL), (14, '', '24', 'addproduct', '0', '2024-04-03 13:30:47', NULL, NULL, NULL, NULL), (15, '', '24', 'addproduct', '0', '2024-04-03 13:30:47', NULL, NULL, NULL, NULL), (16, '3', '24', 'product', '-1', '2024-04-03 14:11:11', '2024-04-08 14:51:30', 'Not Available', '2024-04-08 14:59:25', NULL), (17, '11', '24', 'product', '0', '2024-04-03 14:11:11', NULL, NULL, NULL, NULL), (18, '4', '24', 'product', '0', '2024-04-03 14:11:11', NULL, NULL, NULL, NULL), (19, '17', '24', 'product', '0', '2024-04-03 14:11:11', NULL, NULL, NULL, NULL), (20, '21', '24', 'product', '0', '2024-04-03 14:11:11', NULL, NULL, NULL, NULL), (21, '', '37', 'pbatch', '0', '2024-04-03 14:12:07', NULL, NULL, NULL, NULL), (22, '', '37', 'pbatch', '0', '2024-04-03 14:12:07', NULL, NULL, NULL, NULL), (23, '17', '37', 'pbatch', '0', '2024-04-03 14:12:07', NULL, NULL, NULL, NULL), (24, '21', '37', 'pbatch', '0', '2024-04-03 14:12:07', NULL, NULL, NULL, NULL), (25, '', '19', 'customer', '0', '2024-04-03 14:13:03', NULL, NULL, NULL, NULL), (26, '', '19', 'customer', '0', '2024-04-03 14:13:03', NULL, NULL, NULL, NULL), (27, '', '19', 'customer', '0', '2024-04-03 14:13:03', NULL, NULL, NULL, NULL), (28, '3', '40', 'addproduct', '1', '2024-04-03 14:23:14', '2024-04-08 14:53:27', NULL, NULL, NULL), (29, '11', '40', 'addproduct', '0', '2024-04-03 14:23:14', NULL, NULL, NULL, NULL), (30, '4', '40', 'addproduct', '0', '2024-04-03 14:23:14', NULL, NULL, NULL, NULL), (31, '17', '40', 'addproduct', '0', '2024-04-03 14:23:14', NULL, NULL, NULL, NULL), (32, '21', '40', 'addproduct', '0', '2024-04-03 14:23:14', NULL, NULL, NULL, NULL), (33, '', '42', 'addproduct', '0', '2024-04-03 16:31:19', NULL, NULL, NULL, NULL), (34, '', '42', 'addproduct', '0', '2024-04-03 16:31:19', NULL, NULL, NULL, NULL), (35, '', '42', 'addproduct', '0', '2024-04-03 16:31:19', NULL, NULL, NULL, NULL), (36, '', '43', 'addproduct', '0', '2024-04-03 17:05:05', NULL, NULL, NULL, NULL), (37, '', '43', 'addproduct', '0', '2024-04-03 17:05:05', NULL, NULL, NULL, NULL), (38, '', '43', 'addproduct', '0', '2024-04-03 17:05:05', NULL, NULL, NULL, NULL), (39, '1', '44', 'addproduct', '0', '2024-04-03 17:10:21', NULL, NULL, NULL, NULL), (40, '2', '44', 'addproduct', '0', '2024-04-03 17:10:36', NULL, NULL, NULL, NULL), (41, '1', '44', 'addproduct', '0', '2024-04-03 17:10:53', NULL, NULL, NULL, NULL), (42, '2', '44', 'addproduct', '0', '2024-04-03 17:10:59', NULL, NULL, NULL, NULL), (43, '2', '44', 'addproduct', '0', '2024-04-03 17:11:14', NULL, NULL, NULL, NULL), (44, '1', '25', 'manufacture', '0', '2024-04-04 12:33:49', NULL, '', NULL, NULL), (45, '2', '25', 'manufacture', '0', '2024-04-04 12:33:49', NULL, NULL, NULL, NULL), (46, '1', '25', 'manufacture', '0', '2024-04-04 12:33:49', NULL, '', NULL, NULL), (47, '2', '25', 'manufacture', '0', '2024-04-04 12:33:49', NULL, NULL, NULL, NULL), (48, '2', '25', 'manufacture', '0', '2024-04-04 12:33:49', NULL, NULL, NULL, NULL), (52, '', '21', 'customer', '0', '2024-04-04 12:40:18', NULL, NULL, NULL, NULL), (53, '', '21', 'customer', '0', '2024-04-04 12:40:18', NULL, NULL, NULL, NULL), (54, '', '21', 'customer', '0', '2024-04-04 12:40:18', NULL, NULL, NULL, NULL), (55, '', '42', 'generateqr', '0', '2024-04-08 12:03:14', NULL, NULL, NULL, 'LAX/0424/042'), (56, '', '42', 'generateqr', '0', '2024-04-08 12:03:14', NULL, NULL, NULL, 'LAX/0424/042'), (57, '', '42', 'generateqr', '0', '2024-04-08 12:03:14', NULL, NULL, NULL, 'LAX/0424/042'), (58, '11', '22', 'customer', '0', '2024-04-08 12:08:50', '2024-04-08 14:35:54', NULL, NULL, 'Sahl Khan'), (59, '4', '22', 'customer', '0', '2024-04-08 12:09:42', NULL, NULL, NULL, 'Sahl Khan'), (60, '17', '22', 'customer', '0', '2024-04-08 12:09:52', NULL, NULL, NULL, 'Sahl Khan'), (64, '', '27', 'manufacture', '0', '2024-04-08 15:07:30', NULL, NULL, NULL, 'WebMedia India'), (65, '', '27', 'manufacture', '0', '2024-04-08 15:07:30', NULL, NULL, NULL, 'WebMedia India'), (66, '', '27', 'manufacture', '0', '2024-04-08 15:07:30', NULL, NULL, NULL, 'WebMedia India'), (67, '3', '28', 'manufacture', '1', '2024-04-08 15:16:30', '2024-04-08 15:17:52', NULL, NULL, 'WebMedia India'), (68, '24', '28', 'manufacture', '0', '2024-04-08 15:17:07', NULL, NULL, NULL, 'WebMedia India'), (69, '17', '28', 'manufacture', '0', '2024-04-08 15:17:10', NULL, NULL, NULL, 'WebMedia India'), (70, '3', '29', 'manufacture', '0', '2024-04-08 15:27:22', NULL, NULL, NULL, 'WebMedia India'), (71, '24', '29', 'manufacture', '0', '2024-04-08 15:27:22', NULL, NULL, NULL, 'WebMedia India'), (72, '17', '29', 'manufacture', '0', '2024-04-08 15:27:22', NULL, NULL, NULL, 'WebMedia India'), (73, '', '25', 'product', '0', '2024-04-08 15:28:49', NULL, NULL, NULL, 'LaxacemProject'), (74, '', '25', 'product', '0', '2024-04-08 15:28:49', NULL, NULL, NULL, 'LaxacemProject'), (75, '', '25', 'product', '0', '2024-04-08 15:28:49', NULL, NULL, NULL, 'LaxacemProject'), (76, '3', '26', 'product', '0', '2024-04-08 15:31:47', NULL, NULL, NULL, 'LaxachemProject'), (77, '3', '26', 'product', '0', '2024-04-08 15:32:53', NULL, NULL, NULL, 'LaxachemProject'), (78, '', '26', 'product', '0', '2024-04-08 15:33:45', NULL, NULL, NULL, 'LaxachemProject'), (79, '', '26', 'product', '0', '2024-04-08 15:33:59', NULL, NULL, NULL, 'LaxachemProject'), (80, '3', '38', 'pbatch', '0', '2024-04-08 15:36:20', NULL, NULL, NULL, 'LAXAP01'), (81, '', '38', 'pbatch', '0', '2024-04-08 15:36:20', NULL, NULL, NULL, 'LAXAP01'), (82, '', '38', 'pbatch', '0', '2024-04-08 15:36:20', NULL, NULL, NULL, 'LAXAP01'), (83, '3', '23', 'customer', '0', '2024-04-08 15:37:33', NULL, NULL, NULL, 'Pratik Mohod'), (84, '', '23', 'customer', '0', '2024-04-08 15:37:33', NULL, NULL, NULL, 'Pratik Mohod'), (85, '', '23', 'customer', '0', '2024-04-08 15:37:33', NULL, NULL, NULL, 'Pratik Mohod'), (86, '3', '45', 'addproduct', '0', '2024-04-08 15:38:02', NULL, NULL, NULL, 'laxapro'), (87, '', '45', 'addproduct', '0', '2024-04-08 15:38:02', NULL, NULL, NULL, 'laxapro'), (88, '', '45', 'addproduct', '0', '2024-04-08 15:38:02', NULL, NULL, NULL, 'laxapro'), (89, '3', '27', 'product', '0', '2024-04-08 15:39:17', NULL, NULL, NULL, 'CofeeSofil'), (90, '3', '27', 'product', '0', '2024-04-08 15:39:17', NULL, NULL, NULL, 'CofeeSofil'), (91, '', '27', 'product', '0', '2024-04-08 15:39:17', NULL, NULL, NULL, 'CofeeSofil'), (92, '', '27', 'product', '0', '2024-04-08 15:39:17', NULL, NULL, NULL, 'CofeeSofil'); /*!40000 ALTER TABLE `pagemaster` ENABLE KEYS */; -- Dumping structure for table laxachem.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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.pbatch: ~36 rows (approximately) /*!40000 ALTER TABLE `pbatch` DISABLE KEYS */; INSERT INTO `pbatch` (`id`, `batch`, `product`, `batchsize`, `batchnumber`, `mfgdate`, `expdate`, `weight`, `remark`, `pid`, `created`, `updated`) VALUES (1, '1234', '2', '2334', '442', '2023-10-16', '2023-10-16', '', '', 'BP', NULL, NULL), (3, 'fada', '2', '1313', '131313', '2023-10-16', '2023-10-16', '', '', 'IP', NULL, NULL), (4, 'scff', '2', 'dgdg', '133131', '2023-10-16', '2023-10-16', '', '', 'BP', NULL, NULL), (5, '113', '2', '13', '313', '1333-12-03', '2023-10-16', '', '', 'BP', NULL, NULL), (6, '0303', '2', '3030', '30303', '2023-03-03', '3033-03-16', '', '', 'IP', NULL, NULL), (7, 'zgg', '2', '116', '1616', '2023-11-16', '2023-10-16', '', '', 'BP', NULL, NULL), (8, 'fafssa', '6', 'agagadg', 'agagag', '2023-12-01', '2023-09-01', '', '', 'BP,EP', NULL, NULL), (9, '0303', '2', '3030', '30303', '2023-03-01', '3033-03-01', '', '', 'IP,BP', NULL, NULL), (10, 'fafssa', '6', 'agagadg', 'agagag', '2023-12-01', '2023-09-01', '', '', 'IP,BP,EP', NULL, NULL), (11, '123', '7', '123', '123', '2023-11-01', '2023-11-01', '', '', 'IP,BP', NULL, NULL), (12, '1313133', '8', '1313', '11313', '2024-01-01', '2023-12-01', '', '', '', NULL, NULL), (13, '1313', '8', '113', '11313', '2023-12-01', '2023-12-01', '', '', 'EP', NULL, NULL), (14, '33', '8', '3', '333', '2023-12-01', '2023-12-01', '', '', 'IP,BP', NULL, NULL), (15, 'fsgs', '7', 'shdsh', 'sdhdsd', '2023-12-01', '2023-12-01', '', '', 'IP,BP', NULL, NULL), (16, 'gsd', '2', 'dshds', 'dhdshds', '2023-12-01', '2023-12-01', '', '', 'USP', NULL, NULL), (18, 'gd', '4', 'dsgsg', 'dhdshsh', '2024-02-01', '2025-07-01', '', '', 'BP', NULL, NULL), (19, 'rr', '12', 'rqr', 'rqrqr', '2023-12-01', '2024-12-01', '', '', 'BP', NULL, NULL), (20, 'B1111', '13', '10', 'IB1010', '2024-03-01', '2024-12-01', '', '', 'BP', NULL, NULL), (21, 'B10010', '14', '12', 'BI10010', '2024-03-01', '2024-12-01', '', '', 'EP', NULL, NULL), (22, 'B12345', '15', '10', 'IB12345', '2024-01-01', '2024-12-01', '', '', 'EP', NULL, NULL), (23, 'B101896', '15', '12', 'IB101896', '2024-02-01', '2024-09-01', '', '', 'EP', NULL, NULL), (24, 'BATCH01', '17', '12', 'IBATCH01', '2024-02-01', '2024-09-01', '', '', 'BP,USP', NULL, NULL), (25, 'BATCH0002', '18', '18', 'IBATCH0002', '2024-01-01', '2024-05-01', '', '', 'IP,BP,EP,USP', NULL, NULL), (26, 'Batch1010', '18', '10', 'Ibatch1010', '2024-01-01', '2024-10-01', '', '', 'BP', NULL, NULL), (27, 'Batch1010', '18', '10', 'Ibatch1010', '2024-01-01', '2024-10-01', '', '', 'BP', NULL, NULL), (28, 'Batch1010', '18', '10', 'Ibatch1010', '2024-01-01', '2024-10-01', '', '', 'BP', NULL, NULL), (29, 'Batch1010', '18', '10', 'Ibatch1010', '2024-01-01', '2024-10-01', '', '', 'BP', NULL, NULL), (30, 'Batch1010', '18', '10', 'Ibatch1010', '2024-01-01', '2024-10-01', '', '', 'BP', NULL, NULL), (31, 'Batch1010', '18', '10', 'Ibatch1010', '2024-01-01', '2024-10-01', '', '', 'BP', NULL, NULL), (32, 'b1111', '18', '10', 'ib1111', '2024-01-01', '2024-06-01', '', '', 'BP', NULL, NULL), (33, 'b11111', '18', '10', 'ib1111', '2024-01-01', '2024-06-01', '', '', 'IP', NULL, NULL), (34, 'Batch10101', '18', '18', 'IBATCH', '2024-01-01', '2024-05-01', '', '', 'IP,BP,EP,USP', NULL, NULL), (35, 'Batch10111', '18', '12', 'ib10000', '2024-01-01', '2024-10-01', '', '', 'IP,BP', NULL, NULL), (36, 'batch67', '23', '1000', 'ibatch67', '2024-01-01', '2024-06-01', '', '', 'IP,BP', '2024-03-27 11:48:59', NULL), (37, 'Alpha 9', '24', '12', 'IAlpha', '2024-01-01', '2024-10-01', '', '', 'BP', '2024-04-03 14:12:07', NULL), (38, 'LAXAP01', '26', '120', 'ILAXAP01', '2024-01-01', '2024-10-01', '', '', 'USP', '2024-04-08 15:36:20', NULL); /*!40000 ALTER TABLE `pbatch` ENABLE KEYS */; -- Dumping structure for table laxachem.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 AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.preset: ~2 rows (approximately) /*!40000 ALTER TABLE `preset` DISABLE KEYS */; INSERT INTO `preset` (`id`, `title`, `name`, `formula`, `batch`, `molwt`, `tarewt`, `grosswt`, `netwt`, `gtin`, `manufact`, `storag`, `grade`, `uom`) VALUES (5, 'dfd', 'zddzf', 'zdfzf', 'zdfdzff', '', '', '', '', '', '', '', '', ''), (6, 'cvzdv', 'bsb', 'bsbs', 'bsbs', '1', '2', '3', '4', '', '', '', '', ''); /*!40000 ALTER TABLE `preset` ENABLE KEYS */; -- Dumping structure for table laxachem.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, `formula` varchar(255) DEFAULT NULL, `molwt` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.product: ~22 rows (approximately) /*!40000 ALTER TABLE `product` DISABLE KEYS */; INSERT INTO `product` (`id`, `name`, `brand`, `gtin`, `manu`, `manutxt`, `scon`, `grade`, `subname`, `pack`, `uom`, `created`, `updated`, `formula`, `molwt`) VALUES (3, 'Valga', 'dvs', 'dvvd', '22', 'LAXACHEM ORGANICS PVT. LTD.', 'qwwe', 'IP', 'Valu', '12', NULL, NULL, '2024-04-05 15:42:52', 'H3CN5', '15'), (5, 'sddgg', 'dgag', 'adgag', '14', '', 'gagagga', 'IP,EP,USP', '', 'gag', 'agaga', NULL, NULL, NULL, NULL), (6, 'sddgg', 'dgag', 'adgag', '0', '', 'gagagga', 'IP,BP,EP,USP', '', 'IP,BP,EP,USP', 'dgsdgsd', NULL, NULL, NULL, NULL), (7, 'tin', 'dummy', '1313', '15', '', '12', 'BP,EP,USP', '', '10,15,20', NULL, NULL, NULL, NULL, NULL), (8, 'feqfe', 'egeq', 'geqgeq', '15,17', '', 'fshfsh', 'BP,EP', '', '10,25,30', 'KG', NULL, NULL, NULL, NULL), (9, 'gsfgsh', 'ffddj', 'jdfjdj', '17', '', 'fshfsh', 'BP', '', '2342', 'LTR', NULL, NULL, NULL, NULL), (10, 'IC/1123/002', 'hfshs', 'ffsfs', '15', '', 'fjsjsfj', 'BP,EP', '', 'faaf', 'KG', NULL, NULL, NULL, NULL), (11, 'dhdh', 'hdh', 'ddh', '15,17', '12345678,agagad', 'hdf', 'IP,BP', '', '120', 'LTR', NULL, NULL, NULL, NULL), (13, 'TUSQXC', 'REFRILL', 'GTIN0011', '19', 'LAXAM', 'KEEP IN DRY PLACES', 'BP', 'TQ', '10', 'KG', NULL, NULL, NULL, NULL), (14, 'COFIL', 'LAXACHEMICALS', 'GTIN02222', '20', 'LAXACHEMICALS', 'KEEP IN COOL PLACES', 'EP', '', '15', 'KG', NULL, NULL, NULL, NULL), (15, 'TULIP C', 'LAXACHEM', 'GTIN11214', '15', '12345678', 'KEEP IN COOL PLACES', 'EP', 'HYDEROSULPHATE', '10', 'LTR', NULL, NULL, NULL, NULL), (16, 'Chemchlo', 'laxachemm', 'GTIN9999', '20', 'LAXACHEMICALS', 'NA', 'EP', 'Chem', '12', 'KG', NULL, NULL, NULL, NULL), (17, 'DUCOSATE SODIUM', 'Laxachem', 'GTIN120120', '21', 'LAXACHEM', 'KEEP AWAY FROM CHILD', 'BP,USP', 'Dioclyle Sodium Sulfosuccinate', '12', 'KG', NULL, NULL, NULL, NULL), (18, 'DUCOSATE SODIUM', 'LAXACHEM ORGANICS PVT. LTD.', 'GTIN11000', '22', 'LAXACHEM ORGANICS PVT. LTD.', 'kKEEP IN COOL PLACES', 'IP,BP,EP,USP', 'Dioctyle Sodium Sulfosuccinate', '18', 'KG', NULL, NULL, NULL, NULL), (19, 'Suffocillicitate Drugnile Alpha ', 'Serum Institute', 'Gtin11000', '23', 'Serum Institute', 'Keep In dry Places', 'IP', 'Suffocilliciate', '12', 'KG', NULL, NULL, NULL, NULL), (20, 'Suffocillicitate Drugnile Alpha ', 'Serum Institute', 'Gtin11000', '23', 'Serum Institute', 'Keep In dry Places', 'IP', 'Suffocilliciate', '12', 'KG', NULL, NULL, NULL, NULL), (21, 'Suffocillicitate Drugnile Alpha ', 'Serum Institute', 'Gtin11000', '23', 'Serum Institute', 'Keep In dry Places', 'IP', 'Suffocilliciate', '12', 'KG', NULL, NULL, NULL, NULL), (22, 'Suffocicilate', 'fdsfdf', 'fdsfdsgf', '22', 'LAXACHEM ORGANICS PVT. LTD.', 'dsdgdfg', 'EP', 'asddasf', '33', 'KG', NULL, NULL, NULL, NULL), (23, 'Ducosate Sodium', 'LaxaChem', 'GTIN0101000', '22', 'LAXACHEM ORGANICS PVT. LTD.', 'Keep this product in cool and dry places and also keep this product away from children', 'IP,BP', 'Dioctyle Sodium Sulfosccinate', '120', 'KG', '2024-03-27 11:45:06', NULL, 'CH3SD1F', '100'), (24, 'Ducodine Alphaa Nine', 'WebMedia', 'GTIN001', '22', 'LAXACHEM ORGANICS PVT. LTD.', 'Keep In Cool Places', 'BP', 'Duconine Alpha', '12', 'KG', '2024-04-03 14:11:11', NULL, 'HC4H55', '123'), (26, 'LaxachemProject', 'WebMedia', 'GTINWEB', '29', 'WebMedia', 'NA', 'USP', 'LaxaProject', '12', 'KG', '2024-04-08 15:31:22', NULL, 'DOTNET', '12'), (27, 'CofeeSofil', 'LaxaChem', 'GTIN001', '22', 'LAXACHEM ORGANICS PVT. LTD.', 'NA', 'IP,EP', 'Cofee', '458', 'KG', '2024-04-08 15:39:10', NULL, 'HG1S2', '123'); /*!40000 ALTER TABLE `product` ENABLE KEYS */; -- Dumping structure for table laxachem.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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.returnstock: ~2 rows (approximately) /*!40000 ALTER TABLE `returnstock` DISABLE KEYS */; INSERT INTO `returnstock` (`id`, `lotno`, `remark`, `dor`, `created`, `updated`) VALUES (17, '35', 'fgdfg', '2024-03-22', '2024-03-22 15:04:37', '2024-03-22 15:04:37'), (18, '34', '', '0001-01-01', '2024-03-22 15:19:04', '2024-03-22 15:19:04'); /*!40000 ALTER TABLE `returnstock` ENABLE KEYS */; -- Dumping structure for table laxachem.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, `updated` varchar(50) DEFAULT NULL, `contno` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.returnstocknew: ~1 rows (approximately) /*!40000 ALTER TABLE `returnstocknew` DISABLE KEYS */; INSERT INTO `returnstocknew` (`id`, `lotid`, `ssccno`, `tarewt`, `netwt`, `grosswt`, `created`, `updated`, `contno`) VALUES (1, '34', '000000001595', '222', '12', '234', '', '', '2/2'); /*!40000 ALTER TABLE `returnstocknew` ENABLE KEYS */; -- Dumping structure for table laxachem.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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.rolemaster: ~2 rows (approximately) /*!40000 ALTER TABLE `rolemaster` DISABLE KEYS */; INSERT INTO `rolemaster` (`id`, `username`, `password`, `role`, `created`, `updated`) VALUES (1, 'admin', '1234', 'Administration,Admin', '2024-04-03 14:42:42', NULL), (2, 'admin1', '1234', 'Quality Assurer,Administration,Admin', '2024-04-03 14:54:58', NULL); /*!40000 ALTER TABLE `rolemaster` ENABLE KEYS */; -- Dumping structure for table laxachem.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 '', `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, `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, `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, `name` varchar(50) DEFAULT NULL, `approval` varchar(50) DEFAULT NULL, `reports` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1; -- Dumping data for table laxachem.userm: ~7 rows (approximately) /*!40000 ALTER TABLE `userm` DISABLE KEYS */; INSERT INTO `userm` (`id`, `username`, `password`, `rights`, `addproduct`, `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`, `aliasproductadministration`, `customeradministration`, `dispatchadministration`, `manufactureadministration`, `pbatchadministration`, `productadministration`, `returnstockadministration`, `aliasproductqa`, `customerqa`, `dispatchqa`, `generateqrqa`, `manufactureqa`, `pbatchqa`, `productqa`, `returnstockqa`, `name`, `approval`, `reports`) VALUES (3, 'admin', '1234', 'manufacturelocations,products,batch,customer,addprod,generate,dispatch,returnst,stocks,user,report,dispatchreport,returnsreport,sscre,logrep,usermanagem,rolemanagem', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', '2024-03-27 12:46:00', '2024-03-27 12:46:00', '', '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', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Waseem', 'Show', NULL), (4, 'admin1', '1234', 'manufacturelocations,products,customer,generate,dispatch,batch,user,report', '', '', '', '', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', 'administration', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (11, 'admin2', '1234', '', 'create,read', 'create,read', 'create,read', 'create,read', NULL, NULL, '', 'create,read', '', 'create,read,edit', 'create,read', 'create,read', '', '', 'create,read', '', 'create,read', 'admin', '', '', '', '', '11', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL, NULL), (17, 'admin3', '2345', 'manufacturelocations,products', '', '', '', '', NULL, NULL, '', 'create', '', '', '', '', '', '', '', '', '', 'quality assurance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (21, 'Salman', '234235', '', '', '', '', '', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', 'quality assurance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (24, 'admin11', '1234', '', 'delete', 'edit', 'read', '', NULL, NULL, '', '', '', '', 'create', '', '', '', '', '', '', 'Administration', '', '11', '', '', '', '', '11', '', '', '4', '', '', '24', '', '', '', '21', '', '', '', '17', '17', '', 'Waseem', NULL, NULL), (25, 'subhda1', '1235', '', 'create,read', 'create,read', 'create,read', '', NULL, NULL, '', 'create', '', 'create,read', 'create,read', '', '', '', '', '', '', 'User', '3', '3', '', '', '3', '3', '3,3', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Subhda Radke', 'Hide', NULL); /*!40000 ALTER TABLE `userm` ENABLE KEYS */; -- Dumping structure for table laxachem.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 laxachem.userrolemapping: ~1 rows (approximately) /*!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', b'0', NULL, NULL); /*!40000 ALTER TABLE `userrolemapping` ENABLE KEYS */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;