-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 8.0.16 - 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 */ /*!80016 DEFAULT ENCRYPTION='N' */; 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, `deletestatus` varchar(50) DEFAULT NULL, `apaprstatus` varchar(50) DEFAULT NULL, `aprejstatus` varchar(50) DEFAULT NULL, `aprtime` datetime DEFAULT NULL, `rejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.aliasproduct: ~12 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`, `deletestatus`, `apaprstatus`, `aprejstatus`, `aprtime`, `rejtime`) VALUES (1, 'CHLOROBUTANOL', 'CHLOROBUTANOL', 1, '2024-08-10 12:45:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '39', NULL, NULL, NULL, '0', '1', '0', '2024-08-10 16:45:02', NULL), (2, 'CHLORBUTOL', 'CHLOROBUTANOL', 1, '2024-08-10 12:47:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '39', NULL, NULL, NULL, '0', '1', '0', '2024-08-10 16:45:04', NULL), (3, 'CHLORBUTOL (IND. USE ONLY)', 'CHLOROBUTANOL', 1, '2024-08-14 19:41:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '39', NULL, NULL, NULL, '1', '1', '0', '2024-08-17 11:16:53', NULL), (4, 'FUROSEMIDE', 'FUROSEMIDE', 6, '2024-08-17 11:18:40', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '39', NULL, NULL, NULL, '0', '1', '0', '2024-08-17 11:18:53', NULL), (5, 'DOCUSATE SODIUM', 'DOCUSATE SODIUM', 2, '2024-09-18 09:45:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '39', NULL, NULL, NULL, '0', '1', '0', '2024-09-18 09:45:25', NULL), (6, 'DOCUSATE SODIUM 85%', 'DOCUSATE SODIUM 85% POWDER', 3, '2024-09-18 12:50:44', '2024-10-02 13:04:21', NULL, NULL, NULL, NULL, NULL, NULL, '39', NULL, NULL, NULL, '0', '1', '0', '2024-10-02 13:04:27', NULL), (7, '-', 'PROPYL GALLATE', 4, '2024-09-28 11:16:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '39', NULL, NULL, NULL, '0', '1', '0', '2024-09-28 17:13:42', NULL), (8, 'Test 1 Alias', 'Test 1', 8, '2024-10-07 15:43:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '36', NULL, NULL, NULL, '0', '1', '0', '2024-10-07 15:43:24', NULL), (9, '1511A', 'test 1511', 9, '2024-11-15 16:45:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '36', NULL, NULL, NULL, '0', '1', '0', '2024-11-15 16:45:10', NULL), (10, 'W1112AL', 'Wednessday', 10, '2024-12-11 15:39:46', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '36', NULL, NULL, NULL, '0', '1', '0', '2024-12-11 15:39:51', NULL), (11, 'v', 'vnnv', 11, '2024-12-17 19:15:10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '36', NULL, NULL, NULL, '0', '1', '0', '2024-12-17 19:15:24', NULL), (12, 'p1 alias', 'Alpha p1', 12, '2025-01-02 14:16:46', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '36', NULL, NULL, NULL, '0', '1', '0', '2025-01-02 14:16:56', NULL); /*!40000 ALTER TABLE `aliasproduct` ENABLE KEYS */; -- Dumping structure for table laxachem.consumedstock CREATE TABLE IF NOT EXISTS `consumedstock` ( `id` int(11) NOT NULL AUTO_INCREMENT, `batch` varchar(50) DEFAULT NULL, `comprodqty` varchar(50) DEFAULT NULL, `productid` varchar(50) DEFAULT NULL, `comprodid` varchar(50) DEFAULT NULL, `conbatch` varchar(50) DEFAULT NULL, `qty` varchar(50) DEFAULT NULL, `date` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.consumedstock: ~0 rows (approximately) /*!40000 ALTER TABLE `consumedstock` DISABLE KEYS */; INSERT INTO `consumedstock` (`id`, `batch`, `comprodqty`, `productid`, `comprodid`, `conbatch`, `qty`, `date`) VALUES (1, '5', '201', '1', '1', '4', '20', '2024-01-26'); /*!40000 ALTER TABLE `consumedstock` 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 '', `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `custaprstatus` varchar(50) DEFAULT NULL, `custrejstatus` varchar(50) DEFAULT NULL, `custaprtime` datetime DEFAULT NULL, `custrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.customer: ~0 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`, `userid`, `deletestatus`, `custaprstatus`, `custrejstatus`, `custaprtime`, `custrejtime`) VALUES (1, 'B PHARMA', '213652014', 'AMRAVATI', '8547896523', 'bpharma@gmail.com', '2024-11-15 16:44:48', NULL, 'DG112233', '', '', '', '', '', '', 'B PHARMA', 'Customer', '36', '0', '1', '0', '2024-11-15 16:44:53', NULL); /*!40000 ALTER TABLE `customer` ENABLE KEYS */; -- Dumping structure for table laxachem.discardedstock CREATE TABLE IF NOT EXISTS `discardedstock` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product` varchar(50) DEFAULT NULL, `batch` varchar(50) DEFAULT NULL, `quantity` varchar(50) DEFAULT NULL, `date` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.discardedstock: ~0 rows (approximately) /*!40000 ALTER TABLE `discardedstock` DISABLE KEYS */; /*!40000 ALTER TABLE `discardedstock` 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, `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `disaprstatus` varchar(50) DEFAULT NULL, `disrejstatus` varchar(50) DEFAULT NULL, `disaprtime` datetime DEFAULT NULL, `disrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.dispatch: ~3 rows (approximately) /*!40000 ALTER TABLE `dispatch` DISABLE KEYS */; INSERT INTO `dispatch` (`id`, `lotno`, `distype`, `dod`, `bob`, `dob`, `customer`, `invoice`, `created`, `updated`, `userid`, `deletestatus`, `disaprstatus`, `disrejstatus`, `disaprtime`, `disrejtime`) VALUES (1, '31', 'Export', '2024-11-15', '11122', '2024-11-15', '1', '1111', '2024-11-15 16:54:16', NULL, '36', '0', '1', '0', '2024-11-15 16:54:24', NULL), (2, '35', 'Export', '2024-12-11', '12011', '2024-12-11', '1', '12011', '2024-12-11 15:47:26', NULL, '36', '0', '1', '0', '2024-12-11 15:47:31', NULL), (3, '40', 'Export', '2025-01-02', '02012024110', '2025-01-02', '1', '02012024001', '2025-01-02 14:20:13', NULL, '36', '0', '1', '0', '2025-01-02 14:21:48', 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, `userid` varchar(50) DEFAULT NULL, `manuid` varchar(255) DEFAULT '', `contfrom` varchar(255) DEFAULT '', `contto` varchar(255) DEFAULT '', `contno` varchar(255) DEFAULT '', `grade` varchar(255) DEFAULT '', `pack` varchar(255) DEFAULT '', `ncont` varchar(255) DEFAULT '', `qrqty` varchar(255) DEFAULT '', `totalqty` varchar(255) DEFAULT '', `dispatch` varchar(255) DEFAULT '0', `returnst` varchar(255) DEFAULT '0', `aprstatus` varchar(255) DEFAULT '0', `qrrejstatus` varchar(255) DEFAULT '0', `lotdisaprstatus` varchar(255) DEFAULT '0', `lotdisrejstatus` varchar(255) DEFAULT '0', `lotcreatedate` date DEFAULT NULL, `qraprtime` datetime DEFAULT NULL, `qrrejtime` datetime DEFAULT NULL, `storagecon` varchar(255) DEFAULT NULL, `storageconid` varchar(255) DEFAULT NULL, `customerid` varchar(255) DEFAULT NULL, `displaygrade` varchar(255) DEFAULT NULL, `explabel` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.generateqr: ~38 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`, `userid`, `manuid`, `contfrom`, `contto`, `contno`, `grade`, `pack`, `ncont`, `qrqty`, `totalqty`, `dispatch`, `returnst`, `aprstatus`, `qrrejstatus`, `lotdisaprstatus`, `lotdisrejstatus`, `lotcreatedate`, `qraprtime`, `qrrejtime`, `storagecon`, `storageconid`, `customerid`, `displaygrade`, `explabel`) VALUES (1, '1', 'LAX/0824/001', '', '1', '', '', '4', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'BP', '25', '20', '', '500', '0', '0', '1', '0', '0', '0', '2024-08-11', '2024-08-11 16:16:38', NULL, 'In an air tight container', NULL, NULL, NULL, NULL), (3, '1', 'LAX/0824/003', '', '2', '', '', '5', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'IP', '25', '12', '', '300', '0', '0', '1', '0', '0', '0', '2024-08-17', '2024-08-17 13:24:01', NULL, 'Store protect from moisture at temperature not exceeding 30° C', NULL, NULL, NULL, NULL), (4, '1', 'LAX/0824/004', '', '2', '', '', '5', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'IP', '25', '2', '', '50', '0', '0', '1', '0', '0', '0', '2024-08-21', '2024-08-21 11:49:27', NULL, 'Store protect from moisture at temperature not exceeding 30° C', NULL, NULL, NULL, NULL), (5, '1', 'LAX/0824/005', '', '2', '', '', '5', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'IP', '25', '1', '', '25', '0', '0', '1', '0', '0', '0', '2024-08-21', '2024-08-21 11:49:45', NULL, 'Store protect from moisture at temperature not exceeding 30° C', NULL, NULL, NULL, NULL), (6, '1', 'LAX/0824/006', '', '1', '', '', '6', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'BP,USP', '25', '20', '', '500', '0', '0', '1', '0', '0', '0', '2024-08-24', '2024-08-24 15:54:41', NULL, 'Preserve in tight container', NULL, NULL, NULL, NULL), (7, '1', 'LAX/0924/007', '', '2', '', '', '5', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'IP', '25', '4', '', '100', '0', '0', '1', '0', '0', '0', '2024-09-14', '2024-09-14 15:55:28', NULL, 'Store protect from moisture at temperature not exceeding 30° C', '2', NULL, NULL, NULL), (8, '1', 'LAX/0924/008', '', '2', '', '', '5', '', '', '', '5', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'IP', '5', '1', '', '5', '0', '0', '1', '0', '0', '0', '2024-09-14', '2024-09-14 15:56:17', NULL, 'Store protect from moisture at temperature not exceeding 30° C', '2', NULL, NULL, NULL), (10, '1', 'LAX/0924/009', '', '2', '', '', '11', '', '', '', '5', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'IP', '5', '40', '', '200', '0', '0', '1', '0', '0', '0', '2024-09-14', '2024-09-14 17:43:26', NULL, 'Store protect from moisture at temperature not exceeding 30° C', '2', NULL, NULL, NULL), (11, '1', 'LAX/0924/011', '', '2', '', '', '10', '', '', '', '25', '2024-10-01', '2029-09-01', '39', '0', '', '', '', 'IP', '25', '20', '', '500', '0', '0', '1', '0', '0', '0', '2024-09-14', '2024-09-14 17:48:47', NULL, 'Store protect from moisture at temperature not exceeding 30° C', '2', NULL, NULL, NULL), (12, '2', 'LAX/0924/012', '', '5', '', '', '12', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'BP', '25', '5', '', '125', '0', '0', '1', '0', '0', '0', '2024-09-18', '2024-09-18 09:47:11', NULL, 'In an air tight container', '5', NULL, NULL, NULL), (13, '2', 'LAX/0924/013', '', '5', '', '', '12', '', '', '', '5', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'BP', '5', '1', '', '5', '0', '0', '1', '0', '0', '0', '2024-09-18', '2024-09-18 09:48:18', NULL, 'In an air tight container', '5', NULL, NULL, NULL), (14, '1', 'LAX/0924/014', '', '1', '', '', '13', '', '', '', '25', '2024-10-01', '2029-09-01', '39', '0', '', '', '', 'BP', '25', '20', '', '500', '0', '0', '1', '0', '0', '0', '2024-09-19', '2024-09-19 15:28:29', NULL, 'In an air tight container', '1', NULL, NULL, NULL), (15, '1', 'LAX/0924/015', '', '1', '', '', '14', '', '', '', '25', '2024-10-01', '2029-09-01', '39', '0', '', '', '', 'BP', '25', '20', '', '500', '0', '0', '1', '0', '0', '0', '2024-09-19', '2024-09-19 15:28:49', NULL, 'In an air tight container', '1', NULL, NULL, NULL), (16, '1', 'LAX/0924/016', '', '1', '', '', '15', '', '', '', '25', '2024-10-01', '2029-09-01', '39', '0', '', '', '', 'BP', '25', '20', '', '500', '0', '0', '1', '0', '0', '0', '2024-09-19', '2024-09-19 15:29:01', NULL, 'In an air tight container', '1', NULL, NULL, NULL), (17, '1', 'LAX/0924/017', '', '1', '', '', '16', '', '', '', '25', '2024-10-01', '2029-09-01', '39', '0', '', '', '', 'BP', '25', '20', '', '500', '0', '0', '1', '0', '0', '0', '2024-09-19', '2024-09-19 15:29:35', NULL, 'In an air tight container', '1', NULL, NULL, NULL), (18, '1', 'LAX/0924/018', '', '1', '', '', '7', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'BP,USP', '25', '20', '', '500', '0', '0', '1', '0', '0', '0', '2024-09-20', '2024-09-20 16:17:28', NULL, 'Preserve in tight container', '4', NULL, NULL, NULL), (19, '1', 'LAX/0924/019', '', '1', '', '', '8', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'BP,USP', '25', '20', '', '500', '0', '0', '1', '0', '0', '0', '2024-09-20', '2024-09-20 16:17:39', NULL, 'Preserve in tight container', '4', NULL, NULL, NULL), (20, '1', 'LAX/0924/020', '', '1', '', '', '18', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'BP,USP', '25', '20', '', '500', '0', '0', '1', '0', '0', '0', '2024-09-20', '2024-09-20 16:20:16', NULL, 'Preserve in tight container', '4', NULL, NULL, NULL), (21, '1', 'LAX/0924/021', '', '2', '', '', '19', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'IP', '25', '1', '', '25', '0', '0', '1', '0', '0', '0', '2024-09-22', '2024-09-22 16:45:21', NULL, 'Store protect from moisture at temperature not exceeding 30° C', '2', NULL, NULL, NULL), (22, '1', 'LAX/0924/022', '', '2', '', '', '19', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'IP', '25', '1', '', '25', '0', '0', '1', '0', '0', '0', '2024-09-22', '2024-09-24 12:08:47', NULL, 'Store protect from moisture at temperature not exceeding 30° C', '2', NULL, NULL, NULL), (23, '1', 'LAX/0924/023', '', '2', '', '', '19', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'IP', '25', '1', '', '25', '0', '0', '1', '0', '0', '0', '2024-09-27', '2024-09-28 15:08:18', NULL, 'Store protect from moisture at temperature not exceeding 30° C', '2', NULL, NULL, NULL), (24, '1', 'LAX/0924/024', '', '2', '', '', '19', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'IP', '25', '1', '', '25', '0', '0', '1', '0', '0', '0', '2024-09-28', '2024-09-28 15:08:52', NULL, 'Store protect from moisture at temperature not exceeding 30° C', '2', NULL, NULL, NULL), (25, '1', 'LAX/0924/025', '', '2', '', '', '19', '', '', '', '25', '2024-09-01', '2029-08-01', '39', '0', '', '', '', 'IP', '25', '2', '', '50', '0', '0', '1', '0', '0', '0', '2024-09-28', '2024-09-28 15:09:05', NULL, 'Store protect from moisture at temperature not exceeding 30° C', '2', NULL, NULL, NULL), (26, '2', 'LAX/0924/026', '', '5', '', '', '21', '', '', '', '5', '2024-10-01', '2029-09-01', '39', '0', '', '', '', 'USP', '5', '1', '', '5', '0', '0', '1', '0', '0', '0', '2024-09-28', '2024-09-28 17:13:59', NULL, 'Preserve in well closed container', '7', NULL, NULL, NULL), (27, '2', 'LAX/0924/027', '', '5', '', '', '21', '', '', '', '5', '2024-10-01', '2029-09-01', '39', '0', '', '', '', 'USP', '5', '1', '', '5', '0', '0', '1', '0', '0', '0', '2024-09-28', '2024-09-28 17:14:11', NULL, 'Preserve in well closed container', '7', NULL, NULL, NULL), (28, '1', 'LAX/0924/028', '', '1', '', '', '20', '', '', '', '25', '2024-10-01', '2029-09-01', '39', '0', '', '', '', 'BP', '25', '20', '', '500', '0', '0', '1', '0', '0', '0', '2024-09-28', '2024-09-28 17:14:25', NULL, 'In an air tight container', '1', NULL, NULL, NULL), (29, '3', 'LAX/1024/029', '', '6', '', '', '17', '', '', '', '25', '2024-07-01', '2029-06-01', '39', '0', '', '', '', 'TECHNICAL', '25', '1', '', '25', '0', '0', '1', '0', '0', '0', '2024-10-02', '2024-10-02 13:06:44', NULL, 'Preserve in well closed container', '8', NULL, NULL, NULL), (30, '8', 'LAX/1024/030', '', '8', '', '', '22', '', '', '', '25', '2024-11-01', '2026-01-01', '36', '0', '', '', '', 'In-House', '25', '2', '', '50', '0', '0', '1', '0', '0', '0', '2024-10-07', '2024-10-07 15:44:40', NULL, 'Teest 1 In-House Grade', '9', NULL, NULL, NULL), (31, '9', 'LAX/1124/031', '', '9', '', '', '23', '', '', '', '15', '2024-12-01', '2027-07-01', '36', '0', '', '', '', 'IP', '15', '3', '', '45', '1', '0', '1', '0', '1', '0', '2024-11-15', '2024-11-15 16:48:25', NULL, '1511 Alias Condition', '10', '1', 'IP', 'Exp. Date'), (32, '9', 'LAX/1124/032', '', '9', '', '', '23', '', '', '', '25', '2024-12-01', '2027-07-01', '36', '0', '', '', '', 'BP', '25', '4', '', '100', '0', '0', '1', '0', '0', '0', '2024-11-15', '2024-11-15 16:49:54', NULL, '1511 BP alias condition', '11', '1', '', 'Retest Date'), (33, '1', 'LAX/1124/033', '', '2', '', '', '5', '', '', '', '5', '2024-09-01', '2029-08-01', '36', '0', '', '', '', 'BP', '5', '1', '', '5', '0', '0', '1', '0', '0', '0', '2024-11-15', '2024-11-15 19:17:35', NULL, 'In an air tight container', '1', '1', '', 'Exp./Retest Date'), (34, '1', 'LAX/1124/034', '', '2', '', '', '5', '', '', '', '5', '2024-09-01', '2029-08-01', '36', '0', '', '', '', 'BP,EP', '5', '2', '', '10', '0', '0', '1', '0', '0', '0', '2024-11-15', '2024-11-15 19:27:11', NULL, 'In an air tight container', '1', '1', 'IndustrialUse', 'Exp./Retest Date'), (35, '10', 'LAX/1224/035', '', '10', '', '', '24', '', '', '', '15', '2025-01-01', '2026-07-01', '36', '0', '', '', '', 'IP', '15', '5', '', '75', '1', '1', '1', '0', '1', '0', '2024-12-11', '2024-12-11 15:41:49', NULL, 'Wednesday ip grade', '14', '0', 'IP', 'Retest'), (36, '1', 'LAX/1224/036', '', '2', '', '', '5', '', '', '', '5', '2024-09-01', '2029-08-01', '36', '0', '', '', '', 'BP', '5', '1', '', '5', '0', '0', '1', '0', '0', '0', '2024-12-17', '2024-12-17 19:02:53', NULL, 'po', '12', '0', 'BP', 'Retest'), (37, '1', 'LAX/1224/037', '', '1', '', '', '5', '', '', '', '5', '2024-09-01', '2029-08-01', '36', '0', '', '', '', 'IP', '5', '2', '', '10', '0', '0', '1', '0', '0', '0', '2024-12-17', '2024-12-17 19:04:22', NULL, 'Store protect from moisture at temperature not exceeding 30° C', '2', '1', 'IP', 'Exp./Retest'), (38, '11', 'LAX/1224/038', '', '11', '', '', '25', '', '', '', '31', '2025-01-01', '2026-01-01', '36', '0', '', '', '', 'TECHNICAL', '31', '2', '', '62', '0', '0', '1', '0', '0', '0', '2024-12-17', '2024-12-17 19:18:06', NULL, 'vt', '16', '1', 'TECHNICALS', 'Exp./Retest'), (39, '1', 'LAX/1224/039', '', '1', '', '', '5', '', '', '', '10', '2024-09-01', '2029-08-01', '36', '0', '', '', '', 'IP', '10', '5', '', '50', '0', '0', '0', '0', '0', '0', '2024-12-19', NULL, NULL, 'Store protect from moisture at temperature not exceeding 30° C', '2', '1', 'IP', 'Exp./Retest'), (40, '12', 'LAX/0125/040', '', '12', '', '', '26', '', '', '', '15', '2025-02-01', '2026-07-01', '36', '0', '', '', '', 'IP', '15', '10', '', '150', '1', '1', '1', '0', '1', '0', '2025-01-02', '2025-01-02 14:19:44', NULL, 'Alpha p1 IP', '17', '0', 'IP', 'Retest'); /*!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, `fdigit` varchar(50) DEFAULT NULL, `preview` varchar(50) DEFAULT NULL, `ssccrs` varchar(50) DEFAULT '0', `qrsrtqty` varchar(50) DEFAULT '0', `batchid` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=360 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.generateqrsr: ~332 rows (approximately) /*!40000 ALTER TABLE `generateqrsr` DISABLE KEYS */; INSERT INTO `generateqrsr` (`id`, `contno`, `qrid`, `tarewt`, `grosswt`, `uninum`, `sscc`, `fdigit`, `preview`, `ssccrs`, `qrsrtqty`, `batchid`) VALUES (1, '1/20', '1', '2.2', '27.2', '001', '089061816400090011', '0', '0', '0', '25', '4'), (2, '2/20', '1', '2.2', '27.2', '002', '089061816400090020', '0', '0', '0', '25', '4'), (3, '3/20', '1', '2.2', '27.2', '003', '089061816400090039', '0', '0', '0', '25', '4'), (4, '4/20', '1', '2.2', '27.2', '004', '089061816400090048', '0', '0', '0', '25', '4'), (5, '5/20', '1', '2.2', '27.2', '005', '089061816400090057', '0', '0', '0', '25', '4'), (6, '6/20', '1', '2.2', '27.2', '006', '089061816400090066', '0', '0', '0', '25', '4'), (7, '7/20', '1', '2.2', '27.2', '007', '089061816400090075', '0', '0', '0', '25', '4'), (8, '8/20', '1', '2.2', '27.2', '008', '089061816400090084', '0', '0', '0', '25', '4'), (9, '9/20', '1', '2.2', '27.2', '009', '089061816400090093', '0', '0', '0', '25', '4'), (10, '10/20', '1', '2.2', '27.2', '010', '089061816400090109', '0', '0', '0', '25', '4'), (11, '11/20', '1', '2.2', '27.2', '011', '089061816400090118', '0', '0', '0', '25', '4'), (12, '12/20', '1', '2.2', '27.2', '012', '089061816400090127', '0', '0', '0', '25', '4'), (13, '13/20', '1', '2.2', '27.2', '013', '089061816400090136', '0', '0', '0', '25', '4'), (14, '14/20', '1', '2.2', '27.2', '014', '089061816400090145', '0', '0', '0', '25', '4'), (15, '15/20', '1', '2.2', '27.2', '015', '089061816400090154', '0', '0', '0', '25', '4'), (16, '16/20', '1', '2.2', '27.2', '016', '089061816400090163', '0', '0', '0', '25', '4'), (17, '17/20', '1', '2.2', '27.2', '017', '089061816400090172', '0', '0', '0', '25', '4'), (18, '18/20', '1', '2.2', '27.2', '018', '089061816400090181', '0', '0', '0', '25', '4'), (19, '19/20', '1', '2.2', '27.2', '019', '089061816400090190', '0', '0', '0', '25', '4'), (20, '20/20', '1', '2.2', '27.2', '020', '089061816400090206', '0', '0', '0', '25', '4'), (29, '1/12', '3', '2.8', '27.8', '021', '089061816400090215', '0', '0', '0', '25', '5'), (30, '2/12', '3', '2.8', '27.8', '022', '089061816400090224', '0', '0', '0', '25', '5'), (31, '3/12', '3', '2.8', '27.8', '023', '089061816400090233', '0', '0', '0', '25', '5'), (32, '4/12', '3', '2.8', '27.8', '024', '089061816400090242', '0', '0', '0', '25', '5'), (33, '5/12', '3', '2.8', '27.8', '025', '089061816400090251', '0', '0', '0', '25', '5'), (34, '6/12', '3', '2.8', '27.8', '026', '089061816400090260', '0', '0', '0', '25', '5'), (35, '7/12', '3', '2.8', '27.8', '027', '089061816400090279', '0', '0', '0', '25', '5'), (36, '8/12', '3', '2.8', '27.8', '028', '089061816400090288', '0', '0', '0', '25', '5'), (37, '9/12', '3', '2.8', '27.8', '029', '089061816400090297', '0', '0', '0', '25', '5'), (38, '10/12', '3', '2.8', '27.8', '030', '089061816400090303', '0', '0', '0', '25', '5'), (39, '11/12', '3', '2.8', '27.8', '031', '089061816400090312', '0', '0', '0', '25', '5'), (40, '12/12', '3', '2.8', '27.8', '032', '089061816400090321', '0', '0', '0', '25', '5'), (41, '1/2', '4', '2.8', '27.8', '033', '089061816400090330', '0', '0', '0', '25', '5'), (42, '2/2', '4', '2.8', '27.8', '034', '089061816400090349', '0', '0', '0', '25', '5'), (43, '1/1', '5', '2.8', '27.8', '035', '089061816400090358', '0', '0', '0', '25', '5'), (44, '1/20', '6', '2.2', '27.2', '036', '089061816400090367', '0', '0', '0', '25', '6'), (45, '2/20', '6', '2.2', '27.2', '037', '089061816400090376', '0', '0', '0', '25', '6'), (46, '3/20', '6', '2.2', '27.2', '038', '089061816400090385', '0', '0', '0', '25', '6'), (47, '4/20', '6', '2.2', '27.2', '039', '089061816400090394', '0', '0', '0', '25', '6'), (48, '5/20', '6', '2.2', '27.2', '040', '089061816400090400', '0', '0', '0', '25', '6'), (49, '6/20', '6', '2.2', '27.2', '041', '089061816400090419', '0', '0', '0', '25', '6'), (50, '7/20', '6', '2.2', '27.2', '042', '089061816400090428', '0', '0', '0', '25', '6'), (51, '8/20', '6', '2.2', '27.2', '043', '089061816400090437', '0', '0', '0', '25', '6'), (52, '9/20', '6', '2.2', '27.2', '044', '089061816400090446', '0', '0', '0', '25', '6'), (53, '10/20', '6', '2.2', '27.2', '045', '089061816400090455', '0', '0', '0', '25', '6'), (54, '11/20', '6', '2.2', '27.2', '046', '089061816400090464', '0', '0', '0', '25', '6'), (55, '12/20', '6', '2.2', '27.2', '047', '089061816400090473', '0', '0', '0', '25', '6'), (56, '13/20', '6', '2.2', '27.2', '048', '089061816400090482', '0', '0', '0', '25', '6'), (57, '14/20', '6', '2.2', '27.2', '049', '089061816400090491', '0', '0', '0', '25', '6'), (58, '15/20', '6', '2.2', '27.2', '050', '089061816400090507', '0', '0', '0', '25', '6'), (59, '16/20', '6', '2.2', '27.2', '051', '089061816400090516', '0', '0', '0', '25', '6'), (60, '17/20', '6', '2.2', '27.2', '052', '089061816400090525', '0', '0', '0', '25', '6'), (61, '18/20', '6', '2.2', '27.2', '053', '089061816400090534', '0', '0', '0', '25', '6'), (62, '19/20', '6', '2.2', '27.2', '054', '089061816400090543', '0', '0', '0', '25', '6'), (63, '20/20', '6', '2.2', '27.2', '055', '089061816400090552', '0', '0', '0', '25', '6'), (64, '1/4', '7', '2.8', '27.8', '056', '089061816400090561', '0', '0', '0', '25', '5'), (65, '2/4', '7', '2.8', '27.8', '057', '089061816400090570', '0', '0', '0', '25', '5'), (66, '3/4', '7', '2.8', '27.8', '058', '089061816400090589', '0', '0', '0', '25', '5'), (67, '4/4', '7', '2.8', '27.8', '059', '089061816400090598', '0', '0', '0', '25', '5'), (68, '1/1', '8', '0.25', '5.25', '060', '089061816400090604', '0', '0', '0', '5', '5'), (88, '1/40', '10', '0.25', '5.25', '061', '089061816400090613', '0', '0', '0', '5', '11'), (89, '2/40', '10', '0.25', '5.25', '062', '089061816400090622', '0', '0', '0', '5', '11'), (90, '3/40', '10', '0.25', '5.25', '063', '089061816400090631', '0', '0', '0', '5', '11'), (91, '4/40', '10', '0.25', '5.25', '064', '089061816400090640', '0', '0', '0', '5', '11'), (92, '5/40', '10', '0.25', '5.25', '065', '089061816400090659', '0', '0', '0', '5', '11'), (93, '6/40', '10', '0.25', '5.25', '066', '089061816400090668', '0', '0', '0', '5', '11'), (94, '7/40', '10', '0.25', '5.25', '067', '089061816400090677', '0', '0', '0', '5', '11'), (95, '8/40', '10', '0.25', '5.25', '068', '089061816400090686', '0', '0', '0', '5', '11'), (96, '9/40', '10', '0.25', '5.25', '069', '089061816400090695', '0', '0', '0', '5', '11'), (97, '10/40', '10', '0.25', '5.25', '070', '089061816400090701', '0', '0', '0', '5', '11'), (98, '11/40', '10', '0.25', '5.25', '071', '089061816400090710', '0', '0', '0', '5', '11'), (99, '12/40', '10', '0.25', '5.25', '072', '089061816400090729', '0', '0', '0', '5', '11'), (100, '13/40', '10', '0.25', '5.25', '073', '089061816400090738', '0', '0', '0', '5', '11'), (101, '14/40', '10', '0.25', '5.25', '074', '089061816400090747', '0', '0', '0', '5', '11'), (102, '15/40', '10', '0.25', '5.25', '075', '089061816400090756', '0', '0', '0', '5', '11'), (103, '16/40', '10', '0.25', '5.25', '076', '089061816400090765', '0', '0', '0', '5', '11'), (104, '17/40', '10', '0.25', '5.25', '077', '089061816400090774', '0', '0', '0', '5', '11'), (105, '18/40', '10', '0.25', '5.25', '078', '089061816400090783', '0', '0', '0', '5', '11'), (106, '19/40', '10', '0.25', '5.25', '079', '089061816400090792', '0', '0', '0', '5', '11'), (107, '20/40', '10', '0.25', '5.25', '080', '089061816400090808', '0', '0', '0', '5', '11'), (108, '21/40', '10', '0.25', '5.25', '081', '089061816400090817', '0', '0', '0', '5', '11'), (109, '22/40', '10', '0.25', '5.25', '082', '089061816400090826', '0', '0', '0', '5', '11'), (110, '23/40', '10', '0.25', '5.25', '083', '089061816400090835', '0', '0', '0', '5', '11'), (111, '24/40', '10', '0.25', '5.25', '084', '089061816400090844', '0', '0', '0', '5', '11'), (112, '25/40', '10', '0.25', '5.25', '085', '089061816400090853', '0', '0', '0', '5', '11'), (113, '26/40', '10', '0.25', '5.25', '086', '089061816400090862', '0', '0', '0', '5', '11'), (114, '27/40', '10', '0.25', '5.25', '087', '089061816400090871', '0', '0', '0', '5', '11'), (115, '28/40', '10', '0.25', '5.25', '088', '089061816400090880', '0', '0', '0', '5', '11'), (116, '29/40', '10', '0.25', '5.25', '089', '089061816400090899', '0', '0', '0', '5', '11'), (117, '30/40', '10', '0.25', '5.25', '090', '089061816400090905', '0', '0', '0', '5', '11'), (118, '31/40', '10', '0.25', '5.25', '091', '089061816400090914', '0', '0', '0', '5', '11'), (119, '32/40', '10', '0.25', '5.25', '092', '089061816400090923', '0', '0', '0', '5', '11'), (120, '33/40', '10', '0.25', '5.25', '093', '089061816400090932', '0', '0', '0', '5', '11'), (121, '34/40', '10', '0.25', '5.25', '094', '089061816400090941', '0', '0', '0', '5', '11'), (122, '35/40', '10', '0.25', '5.25', '095', '089061816400090950', '0', '0', '0', '5', '11'), (123, '36/40', '10', '0.25', '5.25', '096', '089061816400090969', '0', '0', '0', '5', '11'), (124, '37/40', '10', '0.25', '5.25', '097', '089061816400090978', '0', '0', '0', '5', '11'), (125, '38/40', '10', '0.25', '5.25', '098', '089061816400090987', '0', '0', '0', '5', '11'), (126, '39/40', '10', '0.25', '5.25', '099', '089061816400090996', '0', '0', '0', '5', '11'), (127, '40/40', '10', '0.25', '5.25', '100', '089061816400091001', '0', '0', '0', '5', '11'), (128, '1/20', '11', '2.8', '27.8', '101', '089061816400091010', '0', '0', '0', '25', '10'), (129, '2/20', '11', '2.8', '27.8', '102', '089061816400091029', '0', '0', '0', '25', '10'), (130, '3/20', '11', '2.8', '27.8', '103', '089061816400091038', '0', '0', '0', '25', '10'), (131, '4/20', '11', '2.8', '27.8', '104', '089061816400091047', '0', '0', '0', '25', '10'), (132, '5/20', '11', '2.8', '27.8', '105', '089061816400091056', '0', '0', '0', '25', '10'), (133, '6/20', '11', '2.8', '27.8', '106', '089061816400091065', '0', '0', '0', '25', '10'), (134, '7/20', '11', '2.8', '27.8', '107', '089061816400091074', '0', '0', '0', '25', '10'), (135, '8/20', '11', '2.8', '27.8', '108', '089061816400091083', '0', '0', '0', '25', '10'), (136, '9/20', '11', '2.8', '27.8', '109', '089061816400091092', '0', '0', '0', '25', '10'), (137, '10/20', '11', '2.8', '27.8', '110', '089061816400091108', '0', '0', '0', '25', '10'), (138, '11/20', '11', '2.8', '27.8', '111', '089061816400091117', '0', '0', '0', '25', '10'), (139, '12/20', '11', '2.8', '27.8', '112', '089061816400091126', '0', '0', '0', '25', '10'), (140, '13/20', '11', '2.8', '27.8', '113', '089061816400091135', '0', '0', '0', '25', '10'), (141, '14/20', '11', '2.8', '27.8', '114', '089061816400091144', '0', '0', '0', '25', '10'), (142, '15/20', '11', '2.8', '27.8', '115', '089061816400091153', '0', '0', '0', '25', '10'), (143, '16/20', '11', '2.8', '27.8', '116', '089061816400091162', '0', '0', '0', '25', '10'), (144, '17/20', '11', '2.8', '27.8', '117', '089061816400091171', '0', '0', '0', '25', '10'), (145, '18/20', '11', '2.8', '27.8', '118', '089061816400091180', '0', '0', '0', '25', '10'), (146, '19/20', '11', '2.8', '27.8', '119', '089061816400091199', '0', '0', '0', '25', '10'), (147, '20/20', '11', '2.8', '27.8', '120', '089061816400091205', '0', '0', '0', '25', '10'), (148, '1/5', '12', '2.2', '27.2', '001', '089061816400230017', '0', '0', '0', '25', '12'), (149, '2/5', '12', '2.2', '27.2', '002', '089061816400230026', '0', '0', '0', '25', '12'), (150, '3/5', '12', '2.2', '27.2', '003', '089061816400230035', '0', '0', '0', '25', '12'), (151, '4/5', '12', '2.2', '27.2', '004', '089061816400230044', '0', '0', '0', '25', '12'), (152, '5/5', '12', '2.2', '27.2', '005', '089061816400230053', '0', '0', '0', '25', '12'), (153, '1/1', '13', '0.9', '5.9', '006', '089061816400230062', '0', '0', '0', '5', '12'), (154, '1/20', '14', '2.2', '27.2', '121', '089061816400091214', '0', '0', '0', '25', '13'), (155, '2/20', '14', '2.2', '27.2', '122', '089061816400091223', '0', '0', '0', '25', '13'), (156, '3/20', '14', '2.2', '27.2', '123', '089061816400091232', '0', '0', '0', '25', '13'), (157, '4/20', '14', '2.2', '27.2', '124', '089061816400091241', '0', '0', '0', '25', '13'), (158, '5/20', '14', '2.2', '27.2', '125', '089061816400091250', '0', '0', '0', '25', '13'), (159, '6/20', '14', '2.2', '27.2', '126', '089061816400091269', '0', '0', '0', '25', '13'), (160, '7/20', '14', '2.2', '27.2', '127', '089061816400091278', '0', '0', '0', '25', '13'), (161, '8/20', '14', '2.2', '27.2', '128', '089061816400091287', '0', '0', '0', '25', '13'), (162, '9/20', '14', '2.2', '27.2', '129', '089061816400091296', '0', '0', '0', '25', '13'), (163, '10/20', '14', '2.2', '27.2', '130', '089061816400091302', '0', '0', '0', '25', '13'), (164, '11/20', '14', '2.2', '27.2', '131', '089061816400091311', '0', '0', '0', '25', '13'), (165, '12/20', '14', '2.2', '27.2', '132', '089061816400091320', '0', '0', '0', '25', '13'), (166, '13/20', '14', '2.2', '27.2', '133', '089061816400091339', '0', '0', '0', '25', '13'), (167, '14/20', '14', '2.2', '27.2', '134', '089061816400091348', '0', '0', '0', '25', '13'), (168, '15/20', '14', '2.2', '27.2', '135', '089061816400091357', '0', '0', '0', '25', '13'), (169, '16/20', '14', '2.2', '27.2', '136', '089061816400091366', '0', '0', '0', '25', '13'), (170, '17/20', '14', '2.2', '27.2', '137', '089061816400091375', '0', '0', '0', '25', '13'), (171, '18/20', '14', '2.2', '27.2', '138', '089061816400091384', '0', '0', '0', '25', '13'), (172, '19/20', '14', '2.2', '27.2', '139', '089061816400091393', '0', '0', '0', '25', '13'), (173, '20/20', '14', '2.2', '27.2', '140', '089061816400091409', '0', '0', '0', '25', '13'), (174, '1/20', '15', '2.2', '27.2', '141', '089061816400091418', '0', '0', '0', '25', '14'), (175, '2/20', '15', '2.2', '27.2', '142', '089061816400091427', '0', '0', '0', '25', '14'), (176, '3/20', '15', '2.2', '27.2', '143', '089061816400091436', '0', '0', '0', '25', '14'), (177, '4/20', '15', '2.2', '27.2', '144', '089061816400091445', '0', '0', '0', '25', '14'), (178, '5/20', '15', '2.2', '27.2', '145', '089061816400091454', '0', '0', '0', '25', '14'), (179, '6/20', '15', '2.2', '27.2', '146', '089061816400091463', '0', '0', '0', '25', '14'), (180, '7/20', '15', '2.2', '27.2', '147', '089061816400091472', '0', '0', '0', '25', '14'), (181, '8/20', '15', '2.2', '27.2', '148', '089061816400091481', '0', '0', '0', '25', '14'), (182, '9/20', '15', '2.2', '27.2', '149', '089061816400091490', '0', '0', '0', '25', '14'), (183, '10/20', '15', '2.2', '27.2', '150', '089061816400091506', '0', '0', '0', '25', '14'), (184, '11/20', '15', '2.2', '27.2', '151', '089061816400091515', '0', '0', '0', '25', '14'), (185, '12/20', '15', '2.2', '27.2', '152', '089061816400091524', '0', '0', '0', '25', '14'), (186, '13/20', '15', '2.2', '27.2', '153', '089061816400091533', '0', '0', '0', '25', '14'), (187, '14/20', '15', '2.2', '27.2', '154', '089061816400091542', '0', '0', '0', '25', '14'), (188, '15/20', '15', '2.2', '27.2', '155', '089061816400091551', '0', '0', '0', '25', '14'), (189, '16/20', '15', '2.2', '27.2', '156', '089061816400091560', '0', '0', '0', '25', '14'), (190, '17/20', '15', '2.2', '27.2', '157', '089061816400091579', '0', '0', '0', '25', '14'), (191, '18/20', '15', '2.2', '27.2', '158', '089061816400091588', '0', '0', '0', '25', '14'), (192, '19/20', '15', '2.2', '27.2', '159', '089061816400091597', '0', '0', '0', '25', '14'), (193, '20/20', '15', '2.2', '27.2', '160', '089061816400091603', '0', '0', '0', '25', '14'), (194, '1/20', '16', '2.2', '27.2', '161', '089061816400091612', '0', '0', '0', '25', '15'), (195, '2/20', '16', '2.2', '27.2', '162', '089061816400091621', '0', '0', '0', '25', '15'), (196, '3/20', '16', '2.2', '27.2', '163', '089061816400091630', '0', '0', '0', '25', '15'), (197, '4/20', '16', '2.2', '27.2', '164', '089061816400091649', '0', '0', '0', '25', '15'), (198, '5/20', '16', '2.2', '27.2', '165', '089061816400091658', '0', '0', '0', '25', '15'), (199, '6/20', '16', '2.2', '27.2', '166', '089061816400091667', '0', '0', '0', '25', '15'), (200, '7/20', '16', '2.2', '27.2', '167', '089061816400091676', '0', '0', '0', '25', '15'), (201, '8/20', '16', '2.2', '27.2', '168', '089061816400091685', '0', '0', '0', '25', '15'), (202, '9/20', '16', '2.2', '27.2', '169', '089061816400091694', '0', '0', '0', '25', '15'), (203, '10/20', '16', '2.2', '27.2', '170', '089061816400091700', '0', '0', '0', '25', '15'), (204, '11/20', '16', '2.2', '27.2', '171', '089061816400091719', '0', '0', '0', '25', '15'), (205, '12/20', '16', '2.2', '27.2', '172', '089061816400091728', '0', '0', '0', '25', '15'), (206, '13/20', '16', '2.2', '27.2', '173', '089061816400091737', '0', '0', '0', '25', '15'), (207, '14/20', '16', '2.2', '27.2', '174', '089061816400091746', '0', '0', '0', '25', '15'), (208, '15/20', '16', '2.2', '27.2', '175', '089061816400091755', '0', '0', '0', '25', '15'), (209, '16/20', '16', '2.2', '27.2', '176', '089061816400091764', '0', '0', '0', '25', '15'), (210, '17/20', '16', '2.2', '27.2', '177', '089061816400091773', '0', '0', '0', '25', '15'), (211, '18/20', '16', '2.2', '27.2', '178', '089061816400091782', '0', '0', '0', '25', '15'), (212, '19/20', '16', '2.2', '27.2', '179', '089061816400091791', '0', '0', '0', '25', '15'), (213, '20/20', '16', '2.2', '27.2', '180', '089061816400091807', '0', '0', '0', '25', '15'), (214, '1/20', '17', '2.2', '27.2', '181', '089061816400091816', '0', '0', '0', '25', '16'), (215, '2/20', '17', '2.2', '27.2', '182', '089061816400091825', '0', '0', '0', '25', '16'), (216, '3/20', '17', '2.2', '27.2', '183', '089061816400091834', '0', '0', '0', '25', '16'), (217, '4/20', '17', '2.2', '27.2', '184', '089061816400091843', '0', '0', '0', '25', '16'), (218, '5/20', '17', '2.2', '27.2', '185', '089061816400091852', '0', '0', '0', '25', '16'), (219, '6/20', '17', '2.2', '27.2', '186', '089061816400091861', '0', '0', '0', '25', '16'), (220, '7/20', '17', '2.2', '27.2', '187', '089061816400091870', '0', '0', '0', '25', '16'), (221, '8/20', '17', '2.2', '27.2', '188', '089061816400091889', '0', '0', '0', '25', '16'), (222, '9/20', '17', '2.2', '27.2', '189', '089061816400091898', '0', '0', '0', '25', '16'), (223, '10/20', '17', '2.2', '27.2', '190', '089061816400091904', '0', '0', '0', '25', '16'), (224, '11/20', '17', '2.2', '27.2', '191', '089061816400091913', '0', '0', '0', '25', '16'), (225, '12/20', '17', '2.2', '27.2', '192', '089061816400091922', '0', '0', '0', '25', '16'), (226, '13/20', '17', '2.2', '27.2', '193', '089061816400091931', '0', '0', '0', '25', '16'), (227, '14/20', '17', '2.2', '27.2', '194', '089061816400091940', '0', '0', '0', '25', '16'), (228, '15/20', '17', '2.2', '27.2', '195', '089061816400091959', '0', '0', '0', '25', '16'), (229, '16/20', '17', '2.2', '27.2', '196', '089061816400091968', '0', '0', '0', '25', '16'), (230, '17/20', '17', '2.2', '27.2', '197', '089061816400091977', '0', '0', '0', '25', '16'), (231, '18/20', '17', '2.2', '27.2', '198', '089061816400091986', '0', '0', '0', '25', '16'), (232, '19/20', '17', '2.2', '27.2', '199', '089061816400091995', '0', '0', '0', '25', '16'), (233, '20/20', '17', '2.2', '27.2', '200', '089061816400092000', '0', '0', '0', '25', '16'), (234, '1/20', '18', '2.2', '27.2', '201', '089061816400092019', '0', '0', '0', '25', '7'), (235, '2/20', '18', '2.2', '27.2', '202', '089061816400092028', '0', '0', '0', '25', '7'), (236, '3/20', '18', '2.2', '27.2', '203', '089061816400092037', '0', '0', '0', '25', '7'), (237, '4/20', '18', '2.2', '27.2', '204', '089061816400092046', '0', '0', '0', '25', '7'), (238, '5/20', '18', '2.2', '27.2', '205', '089061816400092055', '0', '0', '0', '25', '7'), (239, '6/20', '18', '2.2', '27.2', '206', '089061816400092064', '0', '0', '0', '25', '7'), (240, '7/20', '18', '2.2', '27.2', '207', '089061816400092073', '0', '0', '0', '25', '7'), (241, '8/20', '18', '2.2', '27.2', '208', '089061816400092082', '0', '0', '0', '25', '7'), (242, '9/20', '18', '2.2', '27.2', '209', '089061816400092091', '0', '0', '0', '25', '7'), (243, '10/20', '18', '2.2', '27.2', '210', '089061816400092107', '0', '0', '0', '25', '7'), (244, '11/20', '18', '2.2', '27.2', '211', '089061816400092116', '0', '0', '0', '25', '7'), (245, '12/20', '18', '2.2', '27.2', '212', '089061816400092125', '0', '0', '0', '25', '7'), (246, '13/20', '18', '2.2', '27.2', '213', '089061816400092134', '0', '0', '0', '25', '7'), (247, '14/20', '18', '2.2', '27.2', '214', '089061816400092143', '0', '0', '0', '25', '7'), (248, '15/20', '18', '2.2', '27.2', '215', '089061816400092152', '0', '0', '0', '25', '7'), (249, '16/20', '18', '2.2', '27.2', '216', '089061816400092161', '0', '0', '0', '25', '7'), (250, '17/20', '18', '2.2', '27.2', '217', '089061816400092170', '0', '0', '0', '25', '7'), (251, '18/20', '18', '2.2', '27.2', '218', '089061816400092189', '0', '0', '0', '25', '7'), (252, '19/20', '18', '2.2', '27.2', '219', '089061816400092198', '0', '0', '0', '25', '7'), (253, '20/20', '18', '2.2', '27.2', '220', '089061816400092204', '0', '0', '0', '25', '7'), (254, '1/20', '19', '2.2', '27.2', '221', '089061816400092213', '0', '0', '0', '25', '8'), (255, '2/20', '19', '2.2', '27.2', '222', '089061816400092222', '0', '0', '0', '25', '8'), (256, '3/20', '19', '2.2', '27.2', '223', '089061816400092231', '0', '0', '0', '25', '8'), (257, '4/20', '19', '2.2', '27.2', '224', '089061816400092240', '0', '0', '0', '25', '8'), (258, '5/20', '19', '2.2', '27.2', '225', '089061816400092259', '0', '0', '0', '25', '8'), (259, '6/20', '19', '2.2', '27.2', '226', '089061816400092268', '0', '0', '0', '25', '8'), (260, '7/20', '19', '2.2', '27.2', '227', '089061816400092277', '0', '0', '0', '25', '8'), (261, '8/20', '19', '2.2', '27.2', '228', '089061816400092286', '0', '0', '0', '25', '8'), (262, '9/20', '19', '2.2', '27.2', '229', '089061816400092295', '0', '0', '0', '25', '8'), (263, '10/20', '19', '2.2', '27.2', '230', '089061816400092301', '0', '0', '0', '25', '8'), (264, '11/20', '19', '2.2', '27.2', '231', '089061816400092310', '0', '0', '0', '25', '8'), (265, '12/20', '19', '2.2', '27.2', '232', '089061816400092329', '0', '0', '0', '25', '8'), (266, '13/20', '19', '2.2', '27.2', '233', '089061816400092338', '0', '0', '0', '25', '8'), (267, '14/20', '19', '2.2', '27.2', '234', '089061816400092347', '0', '0', '0', '25', '8'), (268, '15/20', '19', '2.2', '27.2', '235', '089061816400092356', '0', '0', '0', '25', '8'), (269, '16/20', '19', '2.2', '27.2', '236', '089061816400092365', '0', '0', '0', '25', '8'), (270, '17/20', '19', '2.2', '27.2', '237', '089061816400092374', '0', '0', '0', '25', '8'), (271, '18/20', '19', '2.2', '27.2', '238', '089061816400092383', '0', '0', '0', '25', '8'), (272, '19/20', '19', '2.2', '27.2', '239', '089061816400092392', '0', '0', '0', '25', '8'), (273, '20/20', '19', '2.2', '27.2', '240', '089061816400092408', '0', '0', '0', '25', '8'), (274, '1/20', '20', '2.2', '27.2', '241', '089061816400092417', '0', '0', '0', '25', '18'), (275, '2/20', '20', '2.2', '27.2', '242', '089061816400092426', '0', '0', '0', '25', '18'), (276, '3/20', '20', '2.2', '27.2', '243', '089061816400092435', '0', '0', '0', '25', '18'), (277, '4/20', '20', '2.2', '27.2', '244', '089061816400092444', '0', '0', '0', '25', '18'), (278, '5/20', '20', '2.2', '27.2', '245', '089061816400092453', '0', '0', '0', '25', '18'), (279, '6/20', '20', '2.2', '27.2', '246', '089061816400092462', '0', '0', '0', '25', '18'), (280, '7/20', '20', '2.2', '27.2', '247', '089061816400092471', '0', '0', '0', '25', '18'), (281, '8/20', '20', '2.2', '27.2', '248', '089061816400092480', '0', '0', '0', '25', '18'), (282, '9/20', '20', '2.2', '27.2', '249', '089061816400092499', '0', '0', '0', '25', '18'), (283, '10/20', '20', '2.2', '27.2', '250', '089061816400092505', '0', '0', '0', '25', '18'), (284, '11/20', '20', '2.2', '27.2', '251', '089061816400092514', '0', '0', '0', '25', '18'), (285, '12/20', '20', '2.2', '27.2', '252', '089061816400092523', '0', '0', '0', '25', '18'), (286, '13/20', '20', '2.2', '27.2', '253', '089061816400092532', '0', '0', '0', '25', '18'), (287, '14/20', '20', '2.2', '27.2', '254', '089061816400092541', '0', '0', '0', '25', '18'), (288, '15/20', '20', '2.2', '27.2', '255', '089061816400092550', '0', '0', '0', '25', '18'), (289, '16/20', '20', '2.2', '27.2', '256', '089061816400092569', '0', '0', '0', '25', '18'), (290, '17/20', '20', '2.2', '27.2', '257', '089061816400092578', '0', '0', '0', '25', '18'), (291, '18/20', '20', '2.2', '27.2', '258', '089061816400092587', '0', '0', '0', '25', '18'), (292, '19/20', '20', '2.2', '27.2', '259', '089061816400092596', '0', '0', '0', '25', '18'), (293, '20/20', '20', '2.2', '27.2', '260', '089061816400092602', '0', '0', '0', '25', '18'), (294, '1/1', '21', '2.8', '27.8', '261', '089061816400092611', '0', '0', '0', '25', '19'), (295, '1/1', '22', '2.8', '27.8', '262', '089061816400092620', '0', '0', '0', '25', '19'), (296, '1/1', '23', '2.8', '27.8', '263', '089061816400092639', '0', '0', '0', '25', '19'), (297, '1/1', '24', '2.8', '27.8', '264', '089061816400092648', '0', '0', '0', '25', '19'), (298, '1/2', '25', '2.8', '27.8', '265', '089061816400092657', '0', '0', '0', '25', '19'), (299, '2/2', '25', '2.8', '27.8', '266', '089061816400092666', '0', '0', '0', '25', '19'), (300, '1/1', '26', '0.25', '5.25', '007', '089061816400230071', '0', '0', '0', '5', '21'), (301, '1/1', '27', '0.9', '5.9', '008', '089061816400230080', '0', '0', '0', '5', '21'), (302, '1/20', '28', '2.2', '27.2', '267', '089061816400092675', '0', '0', '0', '25', '20'), (303, '2/20', '28', '2.2', '27.2', '268', '089061816400092684', '0', '0', '0', '25', '20'), (304, '3/20', '28', '2.2', '27.2', '269', '089061816400092693', '0', '0', '0', '25', '20'), (305, '4/20', '28', '2.2', '27.2', '270', '089061816400092709', '0', '0', '0', '25', '20'), (306, '5/20', '28', '2.2', '27.2', '271', '089061816400092718', '0', '0', '0', '25', '20'), (307, '6/20', '28', '2.2', '27.2', '272', '089061816400092727', '0', '0', '0', '25', '20'), (308, '7/20', '28', '2.2', '27.2', '273', '089061816400092736', '0', '0', '0', '25', '20'), (309, '8/20', '28', '2.2', '27.2', '274', '089061816400092745', '0', '0', '0', '25', '20'), (310, '9/20', '28', '2.2', '27.2', '275', '089061816400092754', '0', '0', '0', '25', '20'), (311, '10/20', '28', '2.2', '27.2', '276', '089061816400092763', '0', '0', '0', '25', '20'), (312, '11/20', '28', '2.2', '27.2', '277', '089061816400092772', '0', '0', '0', '25', '20'), (313, '12/20', '28', '2.2', '27.2', '278', '089061816400092781', '0', '0', '0', '25', '20'), (314, '13/20', '28', '2.2', '27.2', '279', '089061816400092790', '0', '0', '0', '25', '20'), (315, '14/20', '28', '2.2', '27.2', '280', '089061816400092806', '0', '0', '0', '25', '20'), (316, '15/20', '28', '2.2', '27.2', '281', '089061816400092815', '0', '0', '0', '25', '20'), (317, '16/20', '28', '2.2', '27.2', '282', '089061816400092824', '0', '0', '0', '25', '20'), (318, '17/20', '28', '2.2', '27.2', '283', '089061816400092833', '0', '0', '0', '25', '20'), (319, '18/20', '28', '2.2', '27.2', '284', '089061816400092842', '0', '0', '0', '25', '20'), (320, '19/20', '28', '2.2', '27.2', '285', '089061816400092851', '0', '0', '0', '25', '20'), (321, '20/20', '28', '2.2', '27.2', '286', '089061816400092860', '0', '0', '0', '25', '20'), (322, '1/1', '29', '2.2', '27.2', '001', '089061816400300015', '0', '0', '0', '25', '17'), (323, '1/2', '30', '123.65', '148.65', '001', '012345679910250015', '0', '0', '0', '25', '22'), (324, '2/2', '30', '123.65', '148.65', '002', '012345679910250024', '0', '0', '0', '25', '22'), (325, '1/3', '31', '12.11', '27.11', '001', '012345678952140010', '0', '0', '0', '15', '23'), (326, '2/3', '31', '12.11', '27.11', '002', '012345678952140029', '0', '0', '0', '15', '23'), (327, '3/3', '31', '12.11', '27.11', '003', '012345678952140038', '0', '0', '0', '15', '23'), (328, '1/4', '32', '23.23', '48.230000000000004', '004', '012345678952140047', '0', '0', '0', '25', '23'), (329, '2/4', '32', '23.23', '48.230000000000004', '005', '012345678952140056', '0', '0', '0', '25', '23'), (330, '3/4', '32', '23.23', '48.230000000000004', '006', '012345678952140065', '0', '0', '0', '25', '23'), (331, '4/4', '32', '23.23', '48.230000000000004', '007', '012345678952140074', '0', '0', '0', '25', '23'), (332, '1/1', '33', '1', '6', '287', '089061816400092879', '0', '0', '0', '5', '5'), (333, '1/2', '34', '1', '6', '288', '089061816400092888', '0', '0', '0', '5', '5'), (334, '2/2', '34', '1', '6', '289', '089061816400092897', '0', '0', '0', '5', '5'), (335, '1/5', '35', '12.25', '27.25', '001', '012546986532140011', '0', '0', '1', '15', '24'), (336, '2/5', '35', '12.25', '27.25', '002', '012546986532140020', '0', '0', '0', '15', '24'), (337, '3/5', '35', '12.25', '27.25', '003', '012546986532140039', '0', '0', '0', '15', '24'), (338, '4/5', '35', '12.25', '27.25', '004', '012546986532140048', '0', '0', '0', '15', '24'), (339, '5/5', '35', '12.25', '27.25', '005', '012546986532140057', '0', '0', '0', '15', '24'), (340, '1/1', '36', '1', '6', '290', '089061816400092903', '0', '0', '0', '5', '5'), (341, '1/2', '37', '1', '6', '291', '089061816400092912', '0', '0', '0', '5', '5'), (342, '2/2', '37', '1', '6', '292', '089061816400092921', '0', '0', '0', '5', '5'), (343, '1/2', '38', '1', '32', '001', '0van001NaN', '0', '0', '0', '31', '25'), (344, '2/2', '38', '1', '32', '002', '0van002NaN', '0', '0', '0', '31', '25'), (345, '1/5', '39', '1', '11', '293', '089061816400092930', '0', '0', '0', '10', '5'), (346, '2/5', '39', '1', '11', '294', '089061816400092949', '0', '0', '0', '10', '5'), (347, '3/5', '39', '1', '11', '295', '089061816400092958', '0', '0', '0', '10', '5'), (348, '4/5', '39', '1', '11', '296', '089061816400092967', '0', '0', '0', '10', '5'), (349, '5/5', '39', '1', '11', '297', '089061816400092976', '0', '0', '0', '10', '5'), (350, '1/10', '40', '12.25', '27.25', '001', '012548796589740012', '0', '0', '1', '15', '26'), (351, '2/10', '40', '12.25', '27.25', '002', '012548796589740021', '0', '0', '1', '15', '26'), (352, '3/10', '40', '12.25', '27.25', '003', '012548796589740030', '0', '0', '1', '15', '26'), (353, '4/10', '40', '12.25', '27.25', '004', '012548796589740049', '0', '0', '0', '15', '26'), (354, '5/10', '40', '12.25', '27.25', '005', '012548796589740058', '0', '0', '0', '15', '26'), (355, '6/10', '40', '12.25', '27.25', '006', '012548796589740067', '0', '0', '0', '15', '26'), (356, '7/10', '40', '12.25', '27.25', '007', '012548796589740076', '0', '0', '0', '15', '26'), (357, '8/10', '40', '12.25', '27.25', '008', '012548796589740085', '0', '0', '0', '15', '26'), (358, '9/10', '40', '12.25', '27.25', '009', '012548796589740094', '0', '0', '0', '15', '26'), (359, '10/10', '40', '12.25', '27.25', '010', '012548796589740100', '0', '0', '0', '15', '26'); /*!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=778 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.logtable: ~777 rows (approximately) /*!40000 ALTER TABLE `logtable` DISABLE KEYS */; INSERT INTO `logtable` (`id`, `username`, `action`, `time`, `userid`, `tablename`) VALUES (1, NULL, 'User Logged In', '2024-08-03 11:13:36', '39', 'Login In'), (2, NULL, 'New Company Added', '2024-08-03 11:21:56', '39', 'Company Unit'), (3, NULL, 'User Logged In', '2024-08-03 12:08:14', '39', 'Login In'), (4, NULL, 'User Logged In', '2024-08-03 12:40:03', '36', 'Login In'), (5, NULL, 'Company Updated', '2024-08-03 12:43:56', '36', 'Company Unit'), (6, NULL, 'Company Unit Approved', '2024-08-03 12:47:53', '36', 'Approval'), (7, NULL, 'User Logged In', '2024-08-03 12:50:13', '39', 'Login In'), (8, NULL, 'New Product Added', '2024-08-03 12:54:21', '39', 'Product'), (9, NULL, 'New Product Added', '2024-08-03 12:58:20', '39', 'Product'), (10, NULL, 'User Logged In', '2024-08-03 13:02:08', '37', 'Login In'), (11, NULL, 'New Product Added', '2024-08-03 13:04:29', '39', 'Product'), (12, NULL, 'User Logged Out', '2024-08-03 13:06:28', '37', 'Log Out'), (13, NULL, 'New Product Added', '2024-08-03 13:06:53', '39', 'Product'), (14, NULL, 'New Product Added', '2024-08-03 13:10:05', '39', 'Product'), (15, NULL, 'New Product Added', '2024-08-03 13:12:42', '39', 'Product'), (16, NULL, 'Product Updated', '2024-08-03 13:14:19', '39', 'Product'), (17, NULL, 'User Logged In', '2024-08-03 13:26:49', '39', 'Login In'), (18, NULL, 'Product Updated', '2024-08-03 13:27:27', '39', 'Product'), (19, NULL, 'Product Updated', '2024-08-03 13:28:14', '39', 'Product'), (20, NULL, 'User Logged In', '2024-08-03 13:37:47', '39', 'Login In'), (21, NULL, 'User Logged In', '2024-08-03 14:03:20', '39', 'Login In'), (22, NULL, 'User Logged In', '2024-08-03 15:16:31', '39', 'Login In'), (23, NULL, 'User Logged In', '2024-08-03 15:55:12', '36', 'Login In'), (24, NULL, 'User Logged In', '2024-08-03 15:58:31', '39', 'Login In'), (25, NULL, 'User Logged In', '2024-08-03 16:23:49', '39', 'Login In'), (26, NULL, 'New Product Added', '2024-08-03 16:29:29', '39', 'Product'), (27, NULL, 'User Logged In', '2024-08-03 16:31:57', '37', 'Login In'), (28, NULL, 'Product Approved', '2024-08-03 16:33:10', '37', 'Approval'), (29, NULL, 'Product Approved', '2024-08-03 16:33:41', '37', 'Approval'), (30, NULL, 'Product Approved', '2024-08-03 16:36:24', '37', 'Approval'), (31, NULL, 'Product Approved', '2024-08-03 16:38:19', '37', 'Approval'), (32, NULL, 'Product Updated', '2024-08-03 16:43:31', '39', 'Product'), (33, NULL, 'User Logged Out', '2024-08-03 16:43:34', '37', 'Log Out'), (34, NULL, 'User Logged In', '2024-08-03 18:22:59', '36', 'Login In'), (35, NULL, 'User Logged In', '2024-08-04 11:41:05', '37', 'Login In'), (36, NULL, 'User Logged In', '2024-08-04 12:39:57', '39', 'Login In'), (37, NULL, 'User Logged In', '2024-08-04 12:55:20', '37', 'Login In'), (38, NULL, 'Product Approved', '2024-08-04 12:59:43', '37', 'Approval'), (39, NULL, 'Product Rejected', '2024-08-04 13:03:26', '37', 'Approval'), (40, NULL, 'Product Approved', '2024-08-04 13:07:16', '37', 'Approval'), (41, NULL, 'Product Updated', '2024-08-04 13:08:22', '39', 'Product'), (42, NULL, 'User Logged In', '2024-08-04 14:31:37', '37', 'Login In'), (43, NULL, 'Product Approved', '2024-08-04 14:31:49', '37', 'Approval'), (44, NULL, 'User Logged In', '2024-08-06 12:05:10', '39', 'Login In'), (45, NULL, 'Batch Added', '2024-08-06 12:07:13', '39', 'Batch'), (46, NULL, 'Batch Updated', '2024-08-06 12:09:55', '39', 'Batch'), (47, NULL, 'User Logged In', '2024-08-07 11:54:04', '39', 'Login In'), (48, NULL, 'Batch Added', '2024-08-07 11:56:35', '39', 'Batch'), (49, NULL, 'Batch Added', '2024-08-07 11:58:02', '39', 'Batch'), (50, NULL, 'Batch Updated', '2024-08-07 12:00:21', '39', 'Batch'), (51, NULL, 'Batch Updated', '2024-08-07 12:00:29', '39', 'Batch'), (52, NULL, 'User Logged In', '2024-08-09 12:06:33', '39', 'Login In'), (53, NULL, 'Batch Data Deleted', '2024-08-09 12:06:48', '39', 'Batch'), (54, NULL, 'Batch Data Deleted', '2024-08-09 12:06:52', '39', 'Batch'), (55, NULL, 'Batch Data Deleted', '2024-08-09 12:06:55', '39', 'Batch'), (56, NULL, 'Batch Added', '2024-08-09 12:08:25', '39', 'Batch'), (57, NULL, 'Batch Added', '2024-08-09 12:09:18', '39', 'Batch'), (58, NULL, 'Batch Added', '2024-08-09 12:09:59', '39', 'Batch'), (59, NULL, 'Batch Added', '2024-08-09 12:10:43', '39', 'Batch'), (60, NULL, 'Batch Added', '2024-08-09 12:11:29', '39', 'Batch'), (61, NULL, 'User Logged In', '2024-08-09 16:11:09', '37', 'Login In'), (62, NULL, 'Batch Delete Approved', '2024-08-09 16:12:02', '37', 'Approval'), (63, NULL, 'Batch Delete Approved', '2024-08-09 16:12:31', '37', 'Approval'), (64, NULL, 'Batch Delete Approved', '2024-08-09 16:12:53', '37', 'Approval'), (65, NULL, 'Batch Approved', '2024-08-09 16:14:10', '37', 'Approval'), (66, NULL, 'Batch Approved', '2024-08-09 16:14:53', '37', 'Approval'), (67, NULL, 'Batch Approved', '2024-08-09 16:15:42', '37', 'Approval'), (68, NULL, 'Batch Approved', '2024-08-09 16:16:25', '37', 'Approval'), (69, NULL, 'Batch Approved', '2024-08-09 16:16:43', '37', 'Approval'), (70, NULL, 'User Logged Out', '2024-08-09 16:17:27', '37', 'Log Out'), (71, NULL, 'User Logged In', '2024-08-10 12:44:41', '39', 'Login In'), (72, NULL, 'Alias Product Added', '2024-08-10 12:45:56', '39', 'Alias Product'), (73, NULL, 'Alias Product Added', '2024-08-10 12:47:08', '39', 'Alias Product'), (74, NULL, 'User Logged In', '2024-08-10 13:44:57', '39', 'Login In'), (75, NULL, 'User Logged In', '2024-08-10 16:42:52', '37', 'Login In'), (76, NULL, 'Alias Product Approved', '2024-08-10 16:45:02', '37', 'Approval'), (77, NULL, 'Alias Product Approved', '2024-08-10 16:45:04', '37', 'Approval'), (78, NULL, 'User Logged Out', '2024-08-10 16:45:12', '37', 'Log Out'), (79, NULL, 'User Logged In', '2024-08-11 15:05:32', '39', 'Login In'), (80, NULL, 'Storage Condition Added', '2024-08-11 15:07:16', '39', 'Storage Condition'), (81, NULL, 'User Logged In', '2024-08-11 15:58:31', '39', 'Login In'), (82, NULL, 'User Logged In', '2024-08-11 16:11:03', '37', 'Login In'), (83, NULL, 'Storage Condition Approved', '2024-08-11 16:12:16', '37', 'Storage Condition'), (84, NULL, 'User Logged Out', '2024-08-11 16:12:23', '37', 'Log Out'), (85, NULL, 'QR generated', '2024-08-11 16:13:17', '39', 'Generateqr'), (86, NULL, 'User Logged In', '2024-08-11 16:15:33', '37', 'Login In'), (87, NULL, 'Generateqr Approved', '2024-08-11 16:16:38', '37', 'Approval'), (88, NULL, 'User Logged Out', '2024-08-11 16:16:53', '37', 'Log Out'), (89, NULL, 'Single Print Had Taken', '2024-08-11 16:17:02', '39', 'generateqrsr'), (90, NULL, 'Single Print Had Taken', '2024-08-11 16:17:30', '39', 'generateqrsr'), (91, NULL, 'Single Print Had Taken', '2024-08-11 16:18:25', '39', 'generateqrsr'), (92, NULL, 'Single Print Had Taken', '2024-08-11 16:18:42', '39', 'generateqrsr'), (93, NULL, 'Single Print Had Taken', '2024-08-11 16:34:49', '39', 'generateqrsr'), (94, NULL, 'Storage Condition Edited', '2024-08-11 16:39:25', '39', 'Storage Condition'), (95, NULL, 'User Logged Out', '2024-08-11 16:59:14', '39', 'Log Out'), (96, NULL, 'User Logged In', '2024-08-11 16:59:16', '39', 'Login In'), (97, NULL, 'Single Print Had Taken', '2024-08-11 16:59:36', '39', 'generateqrsr'), (98, NULL, 'User Logged In', '2024-08-11 17:08:32', '36', 'Login In'), (99, NULL, 'Single Print Had Taken', '2024-08-11 17:09:38', '36', 'generateqrsr'), (100, NULL, 'Multiple Print Had Taken', '2024-08-11 17:10:28', '36', 'generateqrsr'), (101, NULL, 'User Logged In', '2024-08-12 16:31:35', '36', 'Login In'), (102, NULL, 'Single Print Had Taken', '2024-08-12 16:32:15', '36', 'generateqrsr'), (103, NULL, 'Multiple Print Had Taken', '2024-08-12 16:32:28', '36', 'generateqrsr'), (104, NULL, 'Single Print Had Taken', '2024-08-12 16:51:50', '36', 'generateqrsr'), (105, NULL, 'Single Print Had Taken', '2024-08-12 16:55:45', '36', 'generateqrsr'), (106, NULL, 'Multiple Print Had Taken', '2024-08-12 16:55:59', '36', 'generateqrsr'), (107, NULL, 'User Logged In', '2024-08-14 11:51:23', '39', 'Login In'), (108, NULL, 'Single Print Had Taken', '2024-08-14 11:51:41', '39', 'generateqrsr'), (109, NULL, 'Single Print Had Taken', '2024-08-14 11:51:43', '39', 'generateqrsr'), (110, NULL, 'User Logged In', '2024-08-14 13:30:45', '39', 'Login In'), (111, NULL, 'User Logged In', '2024-08-14 19:40:44', '39', 'Login In'), (112, NULL, 'Alias Product Added', '2024-08-14 19:41:56', '39', 'Alias Product'), (113, NULL, 'User Logged In', '2024-08-14 19:42:35', '37', 'Login In'), (114, NULL, 'Alias Product Approved', '2024-08-14 19:42:48', '37', 'Approval'), (115, NULL, 'Single Print Had Taken', '2024-08-14 19:46:11', '39', 'generateqrsr'), (116, NULL, 'Single Print Had Taken', '2024-08-14 19:46:31', '39', 'generateqrsr'), (117, NULL, 'Single Print Had Taken', '2024-08-14 19:47:06', '39', 'generateqrsr'), (118, NULL, 'Single Print Had Taken', '2024-08-14 19:47:21', '39', 'generateqrsr'), (119, NULL, 'Single Print Had Taken', '2024-08-14 19:47:43', '39', 'generateqrsr'), (120, NULL, 'Single Print Had Taken', '2024-08-14 20:02:36', '39', 'generateqrsr'), (121, NULL, 'Single Print Had Taken', '2024-08-14 20:02:55', '39', 'generateqrsr'), (122, NULL, 'Single Print Had Taken', '2024-08-14 20:05:33', '39', 'generateqrsr'), (123, NULL, 'Single Print Had Taken', '2024-08-14 20:05:57', '39', 'generateqrsr'), (124, NULL, 'Single Print Had Taken', '2024-08-14 20:07:11', '39', 'generateqrsr'), (125, NULL, 'Single Print Had Taken', '2024-08-14 20:07:26', '39', 'generateqrsr'), (126, NULL, 'Single Print Had Taken', '2024-08-14 20:08:38', '39', 'generateqrsr'), (127, NULL, 'Single Print Had Taken', '2024-08-14 20:12:57', '39', 'generateqrsr'), (128, NULL, 'Single Print Had Taken', '2024-08-14 20:13:14', '39', 'generateqrsr'), (129, NULL, 'Multiple Print Had Taken', '2024-08-14 20:17:36', '39', 'generateqrsr'), (130, NULL, 'User Logged In', '2024-08-16 14:54:59', '39', 'Login In'), (131, NULL, 'Company Updated', '2024-08-16 14:56:29', '39', 'Company Unit'), (132, NULL, 'Single Print Had Taken', '2024-08-16 14:57:47', '39', 'generateqrsr'), (133, NULL, 'Single Print Had Taken', '2024-08-16 14:58:29', '39', 'generateqrsr'), (134, NULL, 'Single Print Had Taken', '2024-08-16 15:02:11', '39', 'generateqrsr'), (135, NULL, 'Single Print Had Taken', '2024-08-16 15:02:24', '39', 'generateqrsr'), (136, NULL, 'User Logged In', '2024-08-16 15:29:11', '36', 'Login In'), (137, NULL, 'Single Print Had Taken', '2024-08-16 15:30:00', '36', 'generateqrsr'), (138, NULL, 'Multiple Print Had Taken', '2024-08-16 15:31:44', '36', 'generateqrsr'), (139, NULL, 'User Logged In', '2024-08-16 15:36:22', '39', 'Login In'), (140, NULL, 'Storage Condition Added', '2024-08-16 15:37:38', '39', 'Storage Condition'), (141, NULL, 'Single Print Had Taken', '2024-08-16 16:01:39', '39', 'generateqrsr'), (142, NULL, 'Multiple Print Had Taken', '2024-08-16 16:09:05', '39', 'generateqrsr'), (143, NULL, 'Multiple Print Had Taken', '2024-08-16 16:09:05', '39', 'generateqrsr'), (144, NULL, 'Single Print Had Taken', '2024-08-16 16:09:24', '39', 'generateqrsr'), (145, NULL, 'Single Print Had Taken', '2024-08-16 16:09:42', '39', 'generateqrsr'), (146, NULL, 'Single Print Had Taken', '2024-08-16 16:11:20', '39', 'generateqrsr'), (147, NULL, 'Multiple Print Had Taken', '2024-08-16 16:11:55', '39', 'generateqrsr'), (148, NULL, 'Single Print Had Taken', '2024-08-16 16:12:35', '39', 'generateqrsr'), (149, NULL, 'Multiple Print Had Taken', '2024-08-16 16:12:55', '39', 'generateqrsr'), (150, NULL, 'Multiple Print Had Taken', '2024-08-16 16:13:52', '39', 'generateqrsr'), (151, NULL, 'Multiple Print Had Taken', '2024-08-16 16:15:00', '39', 'generateqrsr'), (152, NULL, 'Single Print Had Taken', '2024-08-16 16:16:42', '39', 'generateqrsr'), (153, NULL, 'Single Print Had Taken', '2024-08-16 16:18:40', '39', 'generateqrsr'), (154, NULL, 'Single Print Had Taken', '2024-08-16 16:22:53', '39', 'generateqrsr'), (155, NULL, 'Single Print Had Taken', '2024-08-16 16:24:05', '39', 'generateqrsr'), (156, NULL, 'User Logged In', '2024-08-16 16:38:23', '39', 'Login In'), (157, NULL, 'Single Print Had Taken', '2024-08-16 16:38:59', '39', 'generateqrsr'), (158, NULL, 'Single Print Had Taken', '2024-08-16 16:39:46', '39', 'generateqrsr'), (159, NULL, 'Single Print Had Taken', '2024-08-16 16:40:28', '39', 'generateqrsr'), (160, NULL, 'Single Print Had Taken', '2024-08-16 16:40:56', '39', 'generateqrsr'), (161, NULL, 'Multiple Print Had Taken', '2024-08-16 16:42:00', '39', 'generateqrsr'), (162, NULL, 'User Logged In', '2024-08-16 17:04:12', '39', 'Login In'), (163, NULL, 'User Logged In', '2024-08-16 17:08:38', '37', 'Login In'), (164, NULL, 'Company Unit Approved', '2024-08-16 17:09:25', '37', 'Approval'), (165, NULL, 'Storage Condition Approved', '2024-08-16 17:10:45', '37', 'Storage Condition'), (166, NULL, 'User Logged Out', '2024-08-16 17:10:52', '37', 'Log Out'), (167, NULL, 'User Logged In', '2024-08-16 17:49:39', '39', 'Login In'), (168, NULL, 'Single Print Had Taken', '2024-08-16 17:49:58', '39', 'generateqrsr'), (169, NULL, 'Single Print Had Taken', '2024-08-16 17:51:03', '39', 'generateqrsr'), (170, NULL, 'Multiple Print Had Taken', '2024-08-16 17:52:07', '39', 'generateqrsr'), (171, NULL, 'Single Print Had Taken', '2024-08-16 17:52:50', '39', 'generateqrsr'), (172, NULL, 'User Logged In', '2024-08-16 17:54:23', '39', 'Login In'), (173, NULL, 'Single Print Had Taken', '2024-08-16 17:54:36', '39', 'generateqrsr'), (174, NULL, 'Single Print Had Taken', '2024-08-16 17:54:51', '39', 'generateqrsr'), (175, NULL, 'Single Print Had Taken', '2024-08-16 17:55:19', '39', 'generateqrsr'), (176, NULL, 'Single Print Had Taken', '2024-08-16 17:55:35', '39', 'generateqrsr'), (177, NULL, 'Single Print Had Taken', '2024-08-16 17:55:52', '39', 'generateqrsr'), (178, NULL, 'Single Print Had Taken', '2024-08-16 17:56:12', '39', 'generateqrsr'), (179, NULL, 'Single Print Had Taken', '2024-08-16 17:56:36', '39', 'generateqrsr'), (180, NULL, 'Single Print Had Taken', '2024-08-16 17:57:10', '39', 'generateqrsr'), (181, NULL, 'Single Print Had Taken', '2024-08-16 17:57:21', '39', 'generateqrsr'), (182, NULL, 'Single Print Had Taken', '2024-08-16 17:57:32', '39', 'generateqrsr'), (183, NULL, 'Single Print Had Taken', '2024-08-16 17:57:43', '39', 'generateqrsr'), (184, NULL, 'Single Print Had Taken', '2024-08-16 17:57:56', '39', 'generateqrsr'), (185, NULL, 'Single Print Had Taken', '2024-08-16 17:58:09', '39', 'generateqrsr'), (186, NULL, 'Single Print Had Taken', '2024-08-16 17:58:25', '39', 'generateqrsr'), (187, NULL, 'Single Print Had Taken', '2024-08-16 17:58:44', '39', 'generateqrsr'), (188, NULL, 'Single Print Had Taken', '2024-08-16 17:59:05', '39', 'generateqrsr'), (189, NULL, 'Single Print Had Taken', '2024-08-16 17:59:32', '39', 'generateqrsr'), (190, NULL, 'Single Print Had Taken', '2024-08-16 17:59:46', '39', 'generateqrsr'), (191, NULL, 'Single Print Had Taken', '2024-08-16 18:00:05', '39', 'generateqrsr'), (192, NULL, 'Single Print Had Taken', '2024-08-16 18:00:37', '39', 'generateqrsr'), (193, NULL, 'Single Print Had Taken', '2024-08-16 18:00:56', '39', 'generateqrsr'), (194, NULL, 'Single Print Had Taken', '2024-08-16 18:01:44', '39', 'generateqrsr'), (195, NULL, 'User Logged In', '2024-08-16 18:24:52', '39', 'Login In'), (196, NULL, 'User Logged In', '2024-08-17 10:40:35', '39', 'Login In'), (197, NULL, 'Batch Added', '2024-08-17 10:46:21', '39', 'Batch'), (198, NULL, 'User Logged In', '2024-08-17 11:12:01', '39', 'Login In'), (199, NULL, 'User Logged In', '2024-08-17 11:12:39', '37', 'Login In'), (200, NULL, 'Batch Approved', '2024-08-17 11:13:51', '37', 'Approval'), (201, NULL, 'Alias Product Delete Approved', '2024-08-17 11:16:53', '37', 'Approval'), (202, NULL, 'Alias Product Added', '2024-08-17 11:18:39', '39', 'Alias Product'), (203, NULL, 'Alias Product Approved', '2024-08-17 11:18:53', '37', 'Approval'), (204, NULL, 'Storage Condition Added', '2024-08-17 11:19:33', '39', 'Storage Condition'), (205, NULL, 'Storage Condition Approved', '2024-08-17 11:23:26', '37', 'Storage Condition'), (206, NULL, 'QR generated', '2024-08-17 11:25:29', '39', 'Generateqr'), (207, NULL, 'User Logged In', '2024-08-17 11:26:10', '37', 'Login In'), (208, NULL, 'Generateqr Approved', '2024-08-17 11:28:08', '37', 'Approval'), (209, NULL, 'Single Print Had Taken', '2024-08-17 11:28:31', '39', 'generateqrsr'), (210, NULL, 'Single Print Had Taken', '2024-08-17 11:47:00', '39', 'generateqrsr'), (211, NULL, 'Single Print Had Taken', '2024-08-17 11:47:20', '39', 'generateqrsr'), (212, NULL, 'User Logged In', '2024-08-17 12:07:49', '39', 'Login In'), (213, NULL, 'QR generated', '2024-08-17 12:10:06', '39', 'Generateqr'), (214, NULL, 'User Logged In', '2024-08-17 13:23:35', '37', 'Login In'), (215, NULL, 'Generateqr Approved', '2024-08-17 13:24:01', '37', 'Approval'), (216, NULL, 'User Logged In', '2024-08-17 13:55:53', '39', 'Login In'), (217, NULL, 'Single Print Had Taken', '2024-08-17 13:59:18', '39', 'generateqrsr'), (218, NULL, 'Multiple Print Had Taken', '2024-08-17 14:01:05', '39', 'generateqrsr'), (219, NULL, 'User Logged In', '2024-08-17 14:24:38', '39', 'Login In'), (220, NULL, 'Single Print Had Taken', '2024-08-17 14:24:50', '39', 'generateqrsr'), (221, NULL, 'Single Print Had Taken', '2024-08-17 14:25:27', '39', 'generateqrsr'), (222, NULL, 'Single Print Had Taken', '2024-08-17 14:25:44', '39', 'generateqrsr'), (223, NULL, 'Single Print Had Taken', '2024-08-17 14:26:03', '39', 'generateqrsr'), (224, NULL, 'Single Print Had Taken', '2024-08-17 14:26:14', '39', 'generateqrsr'), (225, NULL, 'Single Print Had Taken', '2024-08-17 14:26:25', '39', 'generateqrsr'), (226, NULL, 'Single Print Had Taken', '2024-08-17 14:26:56', '39', 'generateqrsr'), (227, NULL, 'Single Print Had Taken', '2024-08-17 14:27:26', '39', 'generateqrsr'), (228, NULL, 'Single Print Had Taken', '2024-08-17 14:27:39', '39', 'generateqrsr'), (229, NULL, 'Single Print Had Taken', '2024-08-17 14:27:49', '39', 'generateqrsr'), (230, NULL, 'Single Print Had Taken', '2024-08-17 14:28:04', '39', 'generateqrsr'), (231, NULL, 'Single Print Had Taken', '2024-08-17 14:28:25', '39', 'generateqrsr'), (232, NULL, 'Single Print Had Taken', '2024-08-17 14:28:46', '39', 'generateqrsr'), (233, NULL, 'Single Print Had Taken', '2024-08-17 14:28:58', '39', 'generateqrsr'), (234, NULL, 'User Logged In', '2024-08-21 11:32:09', '39', 'Login In'), (235, NULL, 'QR generated', '2024-08-21 11:33:58', '39', 'Generateqr'), (236, NULL, 'QR generated', '2024-08-21 11:34:37', '39', 'Generateqr'), (237, NULL, 'User Logged In', '2024-08-21 11:49:01', '37', 'Login In'), (238, NULL, 'Generateqr Approved', '2024-08-21 11:49:27', '37', 'Approval'), (239, NULL, 'Generateqr Approved', '2024-08-21 11:49:46', '37', 'Approval'), (240, NULL, 'User Logged Out', '2024-08-21 11:49:49', '37', 'Log Out'), (241, NULL, 'Single Print Had Taken', '2024-08-21 11:52:04', '39', 'generateqrsr'), (242, NULL, 'Multiple Print Had Taken', '2024-08-21 11:53:07', '39', 'generateqrsr'), (243, NULL, 'Single Print Had Taken', '2024-08-21 11:54:54', '39', 'generateqrsr'), (244, NULL, 'Single Print Had Taken', '2024-08-21 11:55:31', '39', 'generateqrsr'), (245, NULL, 'Single Print Had Taken', '2024-08-21 11:55:41', '39', 'generateqrsr'), (246, NULL, 'User Logged In', '2024-08-21 18:32:38', '36', 'Login In'), (247, NULL, 'User Logged In', '2024-08-21 18:39:20', '36', 'Login In'), (248, NULL, 'User Logged In', '2024-08-21 19:11:29', '36', 'Login In'), (249, NULL, 'User Logged Out', '2024-08-21 19:11:34', '36', 'Log Out'), (250, NULL, 'User Logged In', '2024-08-22 18:52:08', '39', 'Login In'), (251, NULL, 'User Logged In', '2024-08-23 15:04:52', '39', 'Login In'), (252, NULL, 'Storage Condition Added', '2024-08-23 15:07:55', '39', 'Storage Condition'), (253, NULL, 'User Logged In', '2024-08-24 15:03:41', '39', 'Login In'), (254, NULL, 'User Logged In', '2024-08-24 15:05:21', '37', 'Login In'), (255, NULL, 'Storage Condition Approved', '2024-08-24 15:08:14', '37', 'Storage Condition'), (256, NULL, 'User Logged In', '2024-08-24 15:21:41', '37', 'Login In'), (257, NULL, 'Storage Condition Approved', '2024-08-24 15:21:47', '37', 'Storage Condition'), (258, NULL, 'QR generated', '2024-08-24 15:28:16', '39', 'Generateqr'), (259, NULL, 'User Logged In', '2024-08-24 15:29:21', '37', 'Login In'), (260, NULL, 'Generateqr Approved', '2024-08-24 15:29:48', '37', 'Approval'), (261, NULL, 'User Logged Out', '2024-08-24 15:37:56', '39', 'Log Out'), (262, NULL, 'User Logged In', '2024-08-24 15:37:57', '39', 'Login In'), (263, NULL, 'Single Print Had Taken', '2024-08-24 15:43:14', '39', 'generateqrsr'), (264, NULL, 'User Logged In', '2024-08-24 15:53:24', '37', 'Login In'), (265, NULL, 'Generateqr Approved', '2024-08-24 15:53:43', '37', 'Approval'), (266, NULL, 'User Logged Out', '2024-08-24 15:53:50', '37', 'Log Out'), (267, NULL, 'User Logged In', '2024-08-24 15:54:24', '37', 'Login In'), (268, NULL, 'Generateqr Approved', '2024-08-24 15:54:41', '37', 'Approval'), (269, NULL, 'User Logged Out', '2024-08-24 15:54:45', '39', 'Log Out'), (270, NULL, 'User Logged In', '2024-08-24 15:54:47', '39', 'Login In'), (271, NULL, 'User Logged Out', '2024-08-24 15:54:58', '37', 'Log Out'), (272, NULL, 'User Logged In', '2024-08-24 15:55:18', '37', 'Login In'), (273, NULL, 'Single Print Had Taken', '2024-08-24 15:55:18', '39', 'generateqrsr'), (274, NULL, 'User Logged Out', '2024-08-24 15:55:28', '37', 'Log Out'), (275, NULL, 'Single Print Had Taken', '2024-08-24 15:55:37', '39', 'generateqrsr'), (276, NULL, 'Single Print Had Taken', '2024-08-24 15:55:58', '39', 'generateqrsr'), (277, NULL, 'User Logged In', '2024-08-24 16:52:50', '37', 'Login In'), (278, NULL, 'User Logged Out', '2024-08-24 16:53:34', '37', 'Log Out'), (279, NULL, 'User Logged In', '2024-08-24 16:53:36', '36', 'Login In'), (280, NULL, 'User Logged In', '2024-09-14 13:15:36', '39', 'Login In'), (281, NULL, 'QR generated', '2024-09-14 13:26:24', '39', 'Generateqr'), (282, NULL, 'User Logged In', '2024-09-14 15:35:20', '39', 'Login In'), (283, NULL, 'Batch Added', '2024-09-14 15:40:50', '39', 'Batch'), (284, NULL, 'QR generated', '2024-09-14 15:42:06', '39', 'Generateqr'), (285, NULL, 'Batch Added', '2024-09-14 15:52:14', '39', 'Batch'), (286, NULL, 'User Logged In', '2024-09-14 15:53:37', '37', 'Login In'), (287, NULL, 'Generateqr Approved', '2024-09-14 15:55:28', '37', 'Approval'), (288, NULL, 'Batch Approved', '2024-09-14 15:55:52', '37', 'Approval'), (289, NULL, 'Generateqr Approved', '2024-09-14 15:56:17', '37', 'Approval'), (290, NULL, 'Batch Approved', '2024-09-14 15:56:58', '37', 'Approval'), (291, NULL, 'User Logged Out', '2024-09-14 15:58:44', '37', 'Log Out'), (292, NULL, 'QR generated', '2024-09-14 15:59:00', '39', 'Generateqr'), (293, NULL, 'User Logged In', '2024-09-14 15:59:07', '37', 'Login In'), (294, NULL, 'Generateqr Approved', '2024-09-14 15:59:55', '37', 'Approval'), (295, NULL, 'User Logged Out', '2024-09-14 16:00:14', '37', 'Log Out'), (296, NULL, 'User Logged In', '2024-09-14 16:48:28', '39', 'Login In'), (297, NULL, 'QR Deleted', '2024-09-14 17:36:38', '39', 'Generateqr'), (298, NULL, 'Multiple Print Had Taken', '2024-09-14 17:37:05', '39', 'generateqrsr'), (299, NULL, 'User Logged In', '2024-09-14 17:38:11', '39', 'Login In'), (300, NULL, 'Multiple Print Had Taken', '2024-09-14 17:38:42', '39', 'generateqrsr'), (301, NULL, 'QR generated', '2024-09-14 17:42:43', '39', 'Generateqr'), (302, NULL, 'User Logged In', '2024-09-14 17:43:09', '37', 'Login In'), (303, NULL, 'Generateqr Approved', '2024-09-14 17:43:26', '37', 'Approval'), (304, NULL, 'Multiple Print Had Taken', '2024-09-14 17:44:18', '39', 'generateqrsr'), (305, NULL, 'QR generated', '2024-09-14 17:48:34', '39', 'Generateqr'), (306, NULL, 'Generateqr Approved', '2024-09-14 17:48:47', '37', 'Approval'), (307, NULL, 'Multiple Print Had Taken', '2024-09-14 17:49:01', '39', 'generateqrsr'), (308, NULL, 'User Logged In', '2024-09-14 18:09:46', '39', 'Login In'), (309, NULL, 'Multiple Print Had Taken', '2024-09-14 18:09:57', '39', 'generateqrsr'), (310, NULL, 'User Logged In', '2024-09-17 12:56:35', '39', 'Login In'), (311, NULL, 'User Logged In', '2024-09-17 19:20:23', '39', 'Login In'), (312, NULL, 'User Logged In', '2024-09-18 09:42:03', '39', 'Login In'), (313, NULL, 'User Logged In', '2024-09-18 09:43:09', '37', 'Login In'), (314, NULL, 'Batch Added', '2024-09-18 09:44:13', '39', 'Batch'), (315, NULL, 'Batch Approved', '2024-09-18 09:44:25', '37', 'Approval'), (316, NULL, 'Alias Product Added', '2024-09-18 09:45:18', '39', 'Alias Product'), (317, NULL, 'Alias Product Approved', '2024-09-18 09:45:25', '37', 'Approval'), (318, NULL, 'Storage Condition Added', '2024-09-18 09:46:28', '39', 'Storage Condition'), (319, NULL, 'Storage Condition Approved', '2024-09-18 09:46:34', '37', 'Storage Condition'), (320, NULL, 'QR generated', '2024-09-18 09:47:05', '39', 'Generateqr'), (321, NULL, 'Generateqr Approved', '2024-09-18 09:47:11', '37', 'Approval'), (322, NULL, 'QR generated', '2024-09-18 09:48:10', '39', 'Generateqr'), (323, NULL, 'Generateqr Approved', '2024-09-18 09:48:18', '37', 'Approval'), (324, NULL, 'Multiple Print Had Taken', '2024-09-18 09:48:58', '39', 'generateqrsr'), (325, NULL, 'Multiple Print Had Taken', '2024-09-18 09:49:41', '37', 'generateqrsr'), (326, NULL, 'Single Print Had Taken', '2024-09-18 09:50:04', '37', 'generateqrsr'), (327, NULL, 'User Logged In', '2024-09-18 12:34:26', '39', 'Login In'), (328, NULL, 'Batch Added', '2024-09-18 12:35:22', '39', 'Batch'), (329, NULL, 'Batch Added', '2024-09-18 12:36:14', '39', 'Batch'), (330, NULL, 'Batch Added', '2024-09-18 12:37:14', '39', 'Batch'), (331, NULL, 'User Logged In', '2024-09-18 12:47:21', '39', 'Login In'), (332, NULL, 'Batch Added', '2024-09-18 12:48:14', '39', 'Batch'), (333, NULL, 'Batch Added', '2024-09-18 12:49:50', '39', 'Batch'), (334, NULL, 'Alias Product Added', '2024-09-18 12:50:43', '39', 'Alias Product'), (335, NULL, 'Product Updated', '2024-09-18 12:51:01', '39', 'Product'), (336, NULL, 'User Logged In', '2024-09-18 13:42:44', '39', 'Login In'), (337, NULL, 'QR Deleted', '2024-09-18 13:43:33', '39', 'Generateqr'), (338, NULL, 'User Logged In', '2024-09-18 14:05:52', '37', 'Login In'), (339, NULL, 'Batch Approved', '2024-09-18 14:06:25', '37', 'Approval'), (340, NULL, 'Batch Approved', '2024-09-18 14:06:46', '37', 'Approval'), (341, NULL, 'Batch Approved', '2024-09-18 14:07:08', '37', 'Approval'), (342, NULL, 'Batch Approved', '2024-09-18 14:07:20', '37', 'Approval'), (343, NULL, 'Batch Approved', '2024-09-18 14:07:40', '37', 'Approval'), (344, NULL, 'Alias Product Approved', '2024-09-18 14:08:13', '37', 'Approval'), (345, NULL, 'Product Approved', '2024-09-18 14:08:36', '37', 'Approval'), (346, NULL, 'User Logged Out', '2024-09-18 14:08:42', '37', 'Log Out'), (347, NULL, 'User Logged In', '2024-09-18 17:14:09', '39', 'Login In'), (348, NULL, 'User Logged In', '2024-09-19 12:17:06', '39', 'Login In'), (349, NULL, 'QR generated', '2024-09-19 12:17:58', '39', 'Generateqr'), (350, NULL, 'QR generated', '2024-09-19 12:18:41', '39', 'Generateqr'), (351, NULL, 'QR generated', '2024-09-19 12:19:11', '39', 'Generateqr'), (352, NULL, 'QR generated', '2024-09-19 12:19:57', '39', 'Generateqr'), (353, NULL, 'User Logged In', '2024-09-19 15:28:13', '37', 'Login In'), (354, NULL, 'Generateqr Approved', '2024-09-19 15:28:29', '37', 'Approval'), (355, NULL, 'Generateqr Approved', '2024-09-19 15:28:49', '37', 'Approval'), (356, NULL, 'Generateqr Approved', '2024-09-19 15:29:01', '37', 'Approval'), (357, NULL, 'Generateqr Approved', '2024-09-19 15:29:35', '37', 'Approval'), (358, NULL, 'User Logged Out', '2024-09-19 15:30:29', '37', 'Log Out'), (359, NULL, 'User Logged In', '2024-09-19 16:45:26', '39', 'Login In'), (360, NULL, 'User Logged In', '2024-09-19 17:42:00', '36', 'Login In'), (361, NULL, 'User Logged In', '2024-09-19 18:02:01', '36', 'Login In'), (362, NULL, 'User Logged In', '2024-09-19 18:03:06', '36', 'Login In'), (363, NULL, 'User Logged In', '2024-09-19 18:03:45', '36', 'Login In'), (364, NULL, 'User Logged In', '2024-09-19 18:05:11', '36', 'Login In'), (365, NULL, 'User Logged In', '2024-09-19 18:12:11', '36', 'Login In'), (366, NULL, 'User Logged In', '2024-09-19 18:22:57', '36', 'Login In'), (367, NULL, 'User Logged In', '2024-09-19 19:00:01', '39', 'Login In'), (368, NULL, 'User Logged In', '2024-09-19 19:00:28', '39', 'Login In'), (369, NULL, 'Single Print Had Taken', '2024-09-19 19:00:57', '39', 'generateqrsr'), (370, NULL, 'Single Print Had Taken', '2024-09-19 19:01:19', '39', 'generateqrsr'), (371, NULL, 'Single Print Had Taken', '2024-09-19 19:02:19', '39', 'generateqrsr'), (372, NULL, 'Single Print Had Taken', '2024-09-19 19:02:55', '39', 'generateqrsr'), (373, NULL, 'Single Print Had Taken', '2024-09-19 19:03:29', '39', 'generateqrsr'), (374, NULL, 'Single Print Had Taken', '2024-09-19 19:04:42', '39', 'generateqrsr'), (375, NULL, 'Single Print Had Taken', '2024-09-19 19:05:28', '39', 'generateqrsr'), (376, NULL, 'Single Print Had Taken', '2024-09-19 19:06:38', '39', 'generateqrsr'), (377, NULL, 'Single Print Had Taken', '2024-09-19 19:07:18', '39', 'generateqrsr'), (378, NULL, 'Multiple Print Had Taken', '2024-09-19 19:08:27', '39', 'generateqrsr'), (379, NULL, 'Multiple Print Had Taken', '2024-09-19 19:10:57', '39', 'generateqrsr'), (380, NULL, 'Multiple Print Had Taken', '2024-09-19 19:11:59', '39', 'generateqrsr'), (381, NULL, 'Multiple Print Had Taken', '2024-09-19 19:13:21', '39', 'generateqrsr'), (382, NULL, 'Multiple Print Had Taken', '2024-09-19 19:18:52', '39', 'generateqrsr'), (383, NULL, 'User Logged In', '2024-09-20 13:54:41', '39', 'Login In'), (384, NULL, 'User Logged In', '2024-09-20 15:58:50', '39', 'Login In'), (385, NULL, 'QR generated', '2024-09-20 16:01:03', '39', 'Generateqr'), (386, NULL, 'QR generated', '2024-09-20 16:03:07', '39', 'Generateqr'), (387, NULL, 'Batch Added', '2024-09-20 16:04:49', '39', 'Batch'), (388, NULL, 'User Logged In', '2024-09-20 16:17:06', '37', 'Login In'), (389, NULL, 'Generateqr Approved', '2024-09-20 16:17:28', '37', 'Approval'), (390, NULL, 'Generateqr Approved', '2024-09-20 16:17:39', '37', 'Approval'), (391, NULL, 'Batch Approved', '2024-09-20 16:18:06', '37', 'Approval'), (392, NULL, 'User Logged Out', '2024-09-20 16:18:14', '37', 'Log Out'), (393, NULL, 'QR generated', '2024-09-20 16:19:12', '39', 'Generateqr'), (394, NULL, 'User Logged In', '2024-09-20 16:19:47', '37', 'Login In'), (395, NULL, 'Generateqr Approved', '2024-09-20 16:20:16', '37', 'Approval'), (396, NULL, 'Single Print Had Taken', '2024-09-20 16:26:24', '39', 'generateqrsr'), (397, NULL, 'Single Print Had Taken', '2024-09-20 16:27:13', '39', 'generateqrsr'), (398, NULL, 'Single Print Had Taken', '2024-09-20 16:29:01', '39', 'generateqrsr'), (399, NULL, 'Single Print Had Taken', '2024-09-20 16:29:25', '39', 'generateqrsr'), (400, NULL, 'User Logged In', '2024-09-21 11:19:13', '39', 'Login In'), (401, NULL, 'Batch Added', '2024-09-21 11:20:39', '39', 'Batch'), (402, NULL, 'User Logged In', '2024-09-21 14:22:59', '39', 'Login In'), (403, NULL, 'User Logged In', '2024-09-21 14:57:43', '37', 'Login In'), (404, NULL, 'Batch Approved', '2024-09-21 14:59:08', '37', 'Approval'), (405, NULL, 'User Logged In', '2024-09-21 20:09:07', '39', 'Login In'), (406, NULL, 'Single Print Had Taken', '2024-09-21 20:09:50', '39', 'generateqrsr'), (407, NULL, 'Single Print Had Taken', '2024-09-21 20:10:27', '39', 'generateqrsr'), (408, NULL, 'Single Print Had Taken', '2024-09-21 20:10:43', '39', 'generateqrsr'), (409, NULL, 'User Logged In', '2024-09-21 20:11:34', '39', 'Login In'), (410, NULL, 'Single Print Had Taken', '2024-09-21 20:11:51', '39', 'generateqrsr'), (411, NULL, 'Multiple Print Had Taken', '2024-09-21 20:12:22', '39', 'generateqrsr'), (412, NULL, 'Single Print Had Taken', '2024-09-21 20:21:59', '39', 'generateqrsr'), (413, NULL, 'Single Print Had Taken', '2024-09-21 20:22:33', '39', 'generateqrsr'), (414, NULL, 'Single Print Had Taken', '2024-09-21 20:22:51', '39', 'generateqrsr'), (415, NULL, 'Single Print Had Taken', '2024-09-21 20:24:07', '39', 'generateqrsr'), (416, NULL, 'Single Print Had Taken', '2024-09-21 20:25:09', '39', 'generateqrsr'), (417, NULL, 'Single Print Had Taken', '2024-09-21 20:25:34', '39', 'generateqrsr'), (418, NULL, 'Single Print Had Taken', '2024-09-21 20:27:33', '39', 'generateqrsr'), (419, NULL, 'Single Print Had Taken', '2024-09-21 20:28:48', '39', 'generateqrsr'), (420, NULL, 'Single Print Had Taken', '2024-09-21 20:29:18', '39', 'generateqrsr'), (421, NULL, 'Single Print Had Taken', '2024-09-21 20:29:59', '39', 'generateqrsr'), (422, NULL, 'Single Print Had Taken', '2024-09-21 20:32:11', '39', 'generateqrsr'), (423, NULL, 'User Logged In', '2024-09-22 14:18:00', '39', 'Login In'), (424, NULL, 'QR generated', '2024-09-22 14:18:48', '39', 'Generateqr'), (425, NULL, 'User Logged In', '2024-09-22 16:03:39', '39', 'Login In'), (426, NULL, 'User Logged In', '2024-09-22 16:45:05', '37', 'Login In'), (427, NULL, 'Generateqr Approved', '2024-09-22 16:45:21', '37', 'Approval'), (428, NULL, 'User Logged In', '2024-09-22 18:07:16', '39', 'Login In'), (429, NULL, 'User Logged In', '2024-09-22 18:33:17', '39', 'Login In'), (430, NULL, 'QR generated', '2024-09-22 18:34:33', '39', 'Generateqr'), (431, NULL, 'Single Print Had Taken', '2024-09-22 18:37:39', '39', 'generateqrsr'), (432, NULL, 'User Logged In', '2024-09-22 18:39:05', '39', 'Login In'), (433, NULL, 'Single Print Had Taken', '2024-09-22 18:39:35', '39', 'generateqrsr'), (434, NULL, 'User Logged In', '2024-09-24 11:30:20', '39', 'Login In'), (435, NULL, 'User Logged In', '2024-09-24 12:00:09', '39', 'Login In'), (436, NULL, 'User Logged In', '2024-09-24 12:03:59', '37', 'Login In'), (437, NULL, 'Single Print Had Taken', '2024-09-24 12:04:54', '37', 'generateqrsr'), (438, NULL, 'Single Print Had Taken', '2024-09-24 12:05:27', '37', 'generateqrsr'), (439, NULL, 'Single Print Had Taken', '2024-09-24 12:05:58', '37', 'generateqrsr'), (440, NULL, 'User Logged In', '2024-09-24 12:07:38', '37', 'Login In'), (441, NULL, 'Generateqr Approved', '2024-09-24 12:08:47', '37', 'Approval'), (442, NULL, 'User Logged In', '2024-09-24 13:15:47', '39', 'Login In'), (443, NULL, 'Single Print Had Taken', '2024-09-24 13:16:08', '39', 'generateqrsr'), (444, NULL, 'User Logged In', '2024-09-24 15:30:50', '36', 'Login In'), (445, NULL, 'User Logged In', '2024-09-25 17:57:28', '39', 'Login In'), (446, NULL, 'Single Print Had Taken', '2024-09-25 17:58:31', '39', 'generateqrsr'), (447, NULL, 'Single Print Had Taken', '2024-09-25 17:59:12', '39', 'generateqrsr'), (448, NULL, 'Single Print Had Taken', '2024-09-25 17:59:42', '39', 'generateqrsr'), (449, NULL, 'Single Print Had Taken', '2024-09-25 18:00:21', '39', 'generateqrsr'), (450, NULL, 'Single Print Had Taken', '2024-09-25 18:00:47', '39', 'generateqrsr'), (451, NULL, 'Single Print Had Taken', '2024-09-25 18:01:11', '39', 'generateqrsr'), (452, NULL, 'User Logged In', '2024-09-26 12:42:29', '36', 'Login In'), (453, NULL, 'User Logged In', '2024-09-26 12:42:31', '36', 'Login In'), (454, NULL, 'User Logged In', '2024-09-26 18:48:19', '36', 'Login In'), (455, NULL, 'User Logged In', '2024-09-26 18:49:07', '36', 'Login In'), (456, NULL, 'User Logged In', '2024-09-26 19:00:33', '36', 'Login In'), (457, NULL, 'User Logged In', '2024-09-26 19:08:25', '36', 'Login In'), (458, NULL, 'User Logged In', '2024-09-26 19:14:52', '36', 'Login In'), (459, NULL, 'User Logged In', '2024-09-26 19:30:47', '36', 'Login In'), (460, NULL, 'User Logged In', '2024-09-26 20:11:32', '39', 'Login In'), (461, NULL, 'Batch Added', '2024-09-26 20:24:39', '39', 'Batch'), (462, NULL, 'User Logged In', '2024-09-26 20:36:33', '39', 'Login In'), (463, NULL, 'User Logged In', '2024-09-27 13:51:19', '39', 'Login In'), (464, NULL, 'QR generated', '2024-09-27 13:53:49', '39', 'Generateqr'), (465, NULL, 'User Logged In', '2024-09-27 16:30:57', '39', 'Login In'), (466, NULL, 'User Logged In', '2024-09-27 17:45:42', '39', 'Login In'), (467, NULL, 'User Logged In', '2024-09-27 17:47:09', '37', 'Login In'), (468, NULL, 'User Logged In', '2024-09-27 19:46:52', '36', 'Login In'), (469, NULL, 'User Logged In', '2024-09-27 20:01:46', '36', 'Login In'), (470, NULL, 'User Logged In', '2024-09-28 11:06:49', '39', 'Login In'), (471, NULL, 'Batch Added', '2024-09-28 11:12:45', '39', 'Batch'), (472, NULL, 'QR generated', '2024-09-28 11:14:17', '39', 'Generateqr'), (473, NULL, 'QR generated', '2024-09-28 11:15:44', '39', 'Generateqr'), (474, NULL, 'Alias Product Added', '2024-09-28 11:16:42', '39', 'Alias Product'), (475, NULL, 'User Logged In', '2024-09-28 11:57:03', '39', 'Login In'), (476, NULL, 'User Logged In', '2024-09-28 12:19:58', '39', 'Login In'), (477, NULL, 'Storage Condition Added', '2024-09-28 12:44:51', '39', 'Storage Condition'), (478, NULL, 'User Logged In', '2024-09-28 13:40:58', '39', 'Login In'), (479, NULL, 'User Logged In', '2024-09-28 15:06:28', '37', 'Login In'), (480, NULL, 'Batch Approved', '2024-09-28 15:08:05', '37', 'Approval'), (481, NULL, 'Generateqr Approved', '2024-09-28 15:08:18', '37', 'Approval'), (482, NULL, 'Batch Approved', '2024-09-28 15:08:38', '37', 'Approval'), (483, NULL, 'Generateqr Approved', '2024-09-28 15:08:52', '37', 'Approval'), (484, NULL, 'Generateqr Approved', '2024-09-28 15:09:05', '37', 'Approval'), (485, NULL, 'Storage Condition Approved', '2024-09-28 15:10:10', '37', 'Storage Condition'), (486, NULL, 'User Logged Out', '2024-09-28 15:10:30', '37', 'Log Out'), (487, NULL, 'User Logged In', '2024-09-28 15:12:48', '39', 'Login In'), (488, NULL, 'User Logged In', '2024-09-28 15:14:28', '37', 'Login In'), (489, NULL, 'Storage Condition Added', '2024-09-28 15:15:11', '39', 'Storage Condition'), (490, NULL, 'Storage Condition Approved', '2024-09-28 15:15:18', '37', 'Storage Condition'), (491, NULL, 'QR generated', '2024-09-28 15:16:10', '39', 'Generateqr'), (492, NULL, 'QR generated', '2024-09-28 15:16:37', '39', 'Generateqr'), (493, NULL, 'QR generated', '2024-09-28 15:17:07', '39', 'Generateqr'), (494, NULL, 'User Logged Out', '2024-09-28 15:19:01', '37', 'Log Out'), (495, NULL, 'Multiple Print Had Taken', '2024-09-28 15:22:01', '39', 'generateqrsr'), (496, NULL, 'User Logged In', '2024-09-28 15:23:24', '39', 'Login In'), (497, NULL, 'Multiple Print Had Taken', '2024-09-28 15:23:48', '39', 'generateqrsr'), (498, NULL, 'Multiple Print Had Taken', '2024-09-28 15:24:09', '39', 'generateqrsr'), (499, NULL, 'Multiple Print Had Taken', '2024-09-28 15:25:38', '39', 'generateqrsr'), (500, NULL, 'User Logged In', '2024-09-28 16:02:44', '39', 'Login In'), (501, NULL, 'User Logged In', '2024-09-28 16:22:12', '39', 'Login In'), (502, NULL, 'User Logged In', '2024-09-28 16:43:09', '39', 'Login In'), (503, NULL, 'User Logged In', '2024-09-28 17:12:57', '39', 'Login In'), (504, NULL, 'User Logged In', '2024-09-28 17:13:28', '37', 'Login In'), (505, NULL, 'Alias Product Approved', '2024-09-28 17:13:42', '37', 'Approval'), (506, NULL, 'Generateqr Approved', '2024-09-28 17:13:59', '37', 'Approval'), (507, NULL, 'Generateqr Approved', '2024-09-28 17:14:11', '37', 'Approval'), (508, NULL, 'Generateqr Approved', '2024-09-28 17:14:25', '37', 'Approval'), (509, NULL, 'User Logged Out', '2024-09-28 17:14:38', '37', 'Log Out'), (510, NULL, 'User Logged In', '2024-09-28 19:03:57', '39', 'Login In'), (511, NULL, 'Multiple Print Had Taken', '2024-09-28 19:05:10', '39', 'generateqrsr'), (512, NULL, 'Single Print Had Taken', '2024-09-28 19:05:40', '39', 'generateqrsr'), (513, NULL, 'Single Print Had Taken', '2024-09-28 19:06:15', '39', 'generateqrsr'), (514, NULL, 'Single Print Had Taken', '2024-09-28 19:06:51', '39', 'generateqrsr'), (515, NULL, 'Single Print Had Taken', '2024-09-28 19:07:18', '39', 'generateqrsr'), (516, NULL, 'Single Print Had Taken', '2024-09-28 19:08:28', '39', 'generateqrsr'), (517, NULL, 'Single Print Had Taken', '2024-09-28 19:09:00', '39', 'generateqrsr'), (518, NULL, 'Multiple Print Had Taken', '2024-09-28 19:10:08', '39', 'generateqrsr'), (519, NULL, 'Single Print Had Taken', '2024-09-28 19:13:34', '39', 'generateqrsr'), (520, NULL, 'Single Print Had Taken', '2024-09-28 19:14:10', '39', 'generateqrsr'), (521, NULL, 'User Logged In', '2024-09-29 11:55:22', '39', 'Login In'), (522, NULL, 'User Logged In', '2024-09-29 14:23:13', '37', 'Login In'), (523, NULL, 'User Logged Out', '2024-09-29 14:23:20', '37', 'Log Out'), (524, NULL, 'User Logged In', '2024-10-01 11:11:40', '36', 'Login In'), (525, NULL, 'User Logged In', '2024-10-01 11:33:49', '36', 'Login In'), (526, NULL, 'User Logged In', '2024-10-01 11:36:16', '36', 'Login In'), (527, NULL, 'User Logged In', '2024-10-01 11:44:46', '36', 'Login In'), (528, NULL, 'User Logged In', '2024-10-01 11:46:51', '36', 'Login In'), (529, NULL, 'User Logged In', '2024-10-01 11:57:10', '36', 'Login In'), (530, NULL, 'User Logged In', '2024-10-01 13:25:15', '39', 'Login In'), (531, NULL, 'User Logged In', '2024-10-01 16:58:05', '36', 'Login In'), (532, NULL, 'User Logged In', '2024-10-01 17:58:34', '39', 'Login In'), (533, NULL, 'User Logged In', '2024-10-01 17:59:24', '39', 'Login In'), (534, NULL, 'User Logged In', '2024-10-01 18:52:53', '39', 'Login In'), (535, NULL, 'User Logged In', '2024-10-02 12:54:27', '39', 'Login In'), (536, NULL, 'Product Updated', '2024-10-02 12:55:34', '39', 'Product'), (537, NULL, 'User Logged In', '2024-10-02 13:01:50', '37', 'Login In'), (538, NULL, 'Product Approved', '2024-10-02 13:02:12', '37', 'Approval'), (539, NULL, 'Storage Condition Added', '2024-10-02 13:03:32', '39', 'Storage Condition'), (540, NULL, 'Storage Condition Approved', '2024-10-02 13:03:40', '37', 'Storage Condition'), (541, NULL, 'Alias Product Edited', '2024-10-02 13:04:19', '39', 'Alias Product'), (542, NULL, 'Alias Product Updated', '2024-10-02 13:04:20', '39', 'Alias Product'), (543, NULL, 'Alias Product Approved', '2024-10-02 13:04:27', '37', 'Approval'), (544, NULL, 'Product Updated', '2024-10-02 13:05:39', '39', 'Product'), (545, NULL, 'Product Approved', '2024-10-02 13:05:46', '37', 'Approval'), (546, NULL, 'Batch Updated', '2024-10-02 13:06:01', '39', 'Batch'), (547, NULL, 'Batch Approved', '2024-10-02 13:06:07', '37', 'Approval'), (548, NULL, 'QR generated', '2024-10-02 13:06:36', '39', 'Generateqr'), (549, NULL, 'Generateqr Approved', '2024-10-02 13:06:44', '37', 'Approval'), (550, NULL, 'Single Print Had Taken', '2024-10-02 13:07:04', '39', 'generateqrsr'), (551, NULL, 'Single Print Had Taken', '2024-10-02 13:07:38', '37', 'generateqrsr'), (552, NULL, 'Single Print Had Taken', '2024-10-02 13:08:58', '37', 'generateqrsr'), (553, NULL, 'Single Print Had Taken', '2024-10-02 13:09:14', '37', 'generateqrsr'), (554, NULL, 'Single Print Had Taken', '2024-10-02 13:09:55', '37', 'generateqrsr'), (555, NULL, 'User Logged In', '2024-10-02 13:52:03', '36', 'Login In'), (556, NULL, 'User Logged In', '2024-10-02 16:11:24', '36', 'Login In'), (557, NULL, 'User Logged In', '2024-10-02 16:13:40', '36', 'Login In'), (558, NULL, 'User Logged In', '2024-10-02 16:50:49', '36', 'Login In'), (559, NULL, 'User Logged In', '2024-10-04 11:12:30', '36', 'Login In'), (560, NULL, 'User Logged In', '2024-10-04 12:01:46', '36', 'Login In'), (561, NULL, 'User Logged In', '2024-10-04 13:23:34', '36', 'Login In'), (562, NULL, 'User Logged In', '2024-10-04 13:30:54', '36', 'Login In'), (563, NULL, 'User Logged In', '2024-10-04 19:10:42', '36', 'Login In'), (564, NULL, 'New User Added', '2024-10-04 19:11:29', '36', 'Rights Management'), (565, NULL, 'User Updated', '2024-10-04 19:12:45', '36', 'Rights Management'), (566, NULL, 'User Updated', '2024-10-04 19:13:26', '36', 'Rights Management'), (567, NULL, 'User Updated', '2024-10-04 19:15:47', '36', 'Rights Management'), (568, NULL, 'User Logged Out', '2024-10-04 19:15:55', '36', 'Log Out'), (569, NULL, 'User Logged In', '2024-10-04 19:16:04', '44', 'Login In'), (570, NULL, 'User Logged In', '2024-10-05 10:24:43', '39', 'Login In'), (571, NULL, 'Single Print Had Taken', '2024-10-05 10:25:05', '39', 'generateqrsr'), (572, NULL, 'Single Print Had Taken', '2024-10-05 10:25:31', '39', 'generateqrsr'), (573, NULL, 'User Logged In', '2024-10-05 10:46:57', '39', 'Login In'), (574, NULL, 'User Logged In', '2024-10-05 15:08:59', '36', 'Login In'), (575, NULL, 'User Logged In', '2024-10-05 17:18:25', '39', 'Login In'), (576, NULL, 'Single Print Had Taken', '2024-10-05 17:19:01', '39', 'generateqrsr'), (577, NULL, 'Single Print Had Taken', '2024-10-05 17:19:17', '39', 'generateqrsr'), (578, NULL, 'User Logged In', '2024-10-06 13:26:18', '39', 'Login In'), (579, NULL, 'Multiple Print Had Taken', '2024-10-06 13:26:37', '39', 'generateqrsr'), (580, NULL, 'User Logged In', '2024-10-06 13:27:48', '39', 'Login In'), (581, NULL, 'Multiple Print Had Taken', '2024-10-06 13:28:26', '39', 'generateqrsr'), (582, NULL, 'User Logged In', '2024-10-07 10:46:51', '36', 'Login In'), (583, NULL, 'User Updated', '2024-10-07 10:49:18', '36', 'Rights Management'), (584, NULL, 'User Logged Out', '2024-10-07 10:49:27', '36', 'Log Out'), (585, NULL, 'User Logged In', '2024-10-07 10:49:33', '36', 'Login In'), (586, NULL, 'User Logged In', '2024-10-07 15:22:56', '36', 'Login In'), (587, NULL, 'User Updated', '2024-10-07 15:23:14', '36', 'Rights Management'), (588, NULL, 'User Logged Out', '2024-10-07 15:23:19', '36', 'Log Out'), (589, NULL, 'User Logged In', '2024-10-07 15:23:27', '36', 'Login In'), (590, NULL, 'User Updated', '2024-10-07 15:24:02', '36', 'Rights Management'), (591, NULL, 'User Logged Out', '2024-10-07 15:24:05', '36', 'Log Out'), (592, NULL, 'User Logged In', '2024-10-07 15:24:13', '36', 'Login In'), (593, NULL, 'User Updated', '2024-10-07 15:24:53', '36', 'Rights Management'), (594, NULL, 'User Logged Out', '2024-10-07 15:24:55', '36', 'Log Out'), (595, NULL, 'User Logged In', '2024-10-07 15:25:04', '36', 'Login In'), (596, NULL, 'User Logged Out', '2024-10-07 15:36:02', '36', 'Log Out'), (597, NULL, 'User Logged In', '2024-10-07 15:36:07', '36', 'Login In'), (598, NULL, 'User Updated', '2024-10-07 15:37:23', '36', 'Rights Management'), (599, NULL, 'User Logged Out', '2024-10-07 15:37:26', '36', 'Log Out'), (600, NULL, 'User Logged In', '2024-10-07 15:37:36', '36', 'Login In'), (601, NULL, 'New Product Added', '2024-10-07 15:42:16', '36', 'Product'), (602, NULL, 'Product Approved', '2024-10-07 15:42:22', '36', 'Approval'), (603, NULL, 'Batch Added', '2024-10-07 15:42:55', '36', 'Batch'), (604, NULL, 'Batch Approved', '2024-10-07 15:43:01', '36', 'Approval'), (605, NULL, 'Alias Product Added', '2024-10-07 15:43:20', '36', 'Alias Product'), (606, NULL, 'Alias Product Approved', '2024-10-07 15:43:24', '36', 'Approval'), (607, NULL, 'Storage Condition Added', '2024-10-07 15:43:47', '36', 'Storage Condition'), (608, NULL, 'Storage Condition Approved', '2024-10-07 15:43:57', '36', 'Storage Condition'), (609, NULL, 'QR generated', '2024-10-07 15:44:32', '36', 'Generateqr'), (610, NULL, 'Generateqr Approved', '2024-10-07 15:44:40', '36', 'Approval'), (611, NULL, 'Single Print Had Taken', '2024-10-07 15:45:03', '36', 'generateqrsr'), (612, NULL, 'Multiple Print Had Taken', '2024-10-07 15:45:31', '36', 'generateqrsr'), (613, NULL, 'User Logged In', '2024-10-07 20:23:22', '39', 'Login In'), (614, NULL, 'User Logged In', '2024-10-07 20:42:11', '36', 'Login In'), (615, NULL, 'User Logged In', '2024-10-08 13:48:30', '39', 'Login In'), (616, NULL, 'Single Print Had Taken', '2024-10-08 13:48:54', '39', 'generateqrsr'), (617, NULL, 'User Logged In', '2024-10-08 13:49:49', '39', 'Login In'), (618, NULL, 'Single Print Had Taken', '2024-10-08 13:50:07', '39', 'generateqrsr'), (619, NULL, 'User Logged In', '2024-10-09 20:28:23', '36', 'Login In'), (620, NULL, 'User Logged In', '2024-10-10 08:20:03', '36', 'Login In'), (621, NULL, 'User Logged Out', '2024-10-10 08:21:03', '36', 'Log Out'), (622, NULL, 'User Logged In', '2024-10-11 12:56:03', '36', 'Login In'), (623, NULL, 'User Logged In', '2024-10-14 11:27:45', '36', 'Login In'), (624, NULL, 'User Logged In', '2024-10-14 12:29:01', '36', 'Login In'), (625, NULL, 'User Logged In', '2024-10-14 13:33:10', '36', 'Login In'), (626, NULL, 'User Logged In', '2024-10-14 18:34:08', '36', 'Login In'), (627, NULL, 'User Logged In', '2024-10-14 19:16:42', '36', 'Login In'), (628, NULL, 'User Logged In', '2024-10-15 11:34:59', '36', 'Login In'), (629, NULL, 'User Updated', '2024-10-15 11:35:41', '36', 'Rights Management'), (630, NULL, 'User Logged In', '2024-10-15 17:29:29', '36', 'Login In'), (631, NULL, 'User Logged In', '2024-10-15 18:22:35', '36', 'Login In'), (632, NULL, 'User Logged In', '2024-10-15 19:44:20', '36', 'Login In'), (633, NULL, 'User Logged In', '2024-10-16 14:18:05', '39', 'Login In'), (634, NULL, 'User Logged In', '2024-10-18 22:50:19', '39', 'Login In'), (635, NULL, 'User Logged In', '2024-10-20 09:00:22', '36', 'Login In'), (636, NULL, 'User Logged In', '2024-10-21 18:57:55', '36', 'Login In'), (637, NULL, 'User Logged In', '2024-10-29 13:35:20', '36', 'Login In'), (638, NULL, 'User Logged In', '2024-11-02 11:47:38', '36', 'Login In'), (639, NULL, 'User Logged In', '2024-11-07 11:00:13', '36', 'Login In'), (640, NULL, 'Single Print Had Taken', '2024-11-07 11:02:25', '36', 'generateqrsr'), (641, NULL, 'User Logged In', '2024-11-14 13:14:35', '36', 'Login In'), (642, NULL, 'User Logged In', '2024-11-14 13:47:51', '36', 'Login In'), (643, NULL, 'User Logged In', '2024-11-14 15:06:34', '36', 'Login In'), (644, NULL, 'User Logged In', '2024-11-14 15:54:56', '36', 'Login In'), (645, NULL, 'User Logged In', '2024-11-14 17:06:42', '36', 'Login In'), (646, NULL, 'Single Print Had Taken', '2024-11-14 17:08:37', '36', 'generateqrsr'), (647, NULL, 'User Logged In', '2024-11-14 17:56:07', '36', 'Login In'), (648, NULL, 'User Logged In', '2024-11-15 11:13:07', '36', 'Login In'), (649, NULL, 'User Logged In', '2024-11-15 11:46:09', '36', 'Login In'), (650, NULL, 'User Logged In', '2024-11-15 16:33:52', '36', 'Login In'), (651, NULL, 'New Product Added', '2024-11-15 16:43:01', '36', 'Product'), (652, NULL, 'Product Approved', '2024-11-15 16:43:10', '36', 'Approval'), (653, NULL, 'Batch Added', '2024-11-15 16:43:39', '36', 'Batch'), (654, NULL, 'Batch Approved', '2024-11-15 16:43:44', '36', 'Approval'), (655, NULL, 'Customer Added', '2024-11-15 16:44:47', '36', 'Customer'), (656, NULL, 'Customer Approved', '2024-11-15 16:44:53', '36', 'Approval'), (657, NULL, 'Alias Product Added', '2024-11-15 16:45:06', '36', 'Alias Product'), (658, NULL, 'Alias Product Approved', '2024-11-15 16:45:10', '36', 'Approval'), (659, NULL, 'Storage Condition Added', '2024-11-15 16:45:35', '36', 'Storage Condition'), (660, NULL, 'Storage Condition Added', '2024-11-15 16:47:01', '36', 'Storage Condition'), (661, NULL, 'Storage Condition Approved', '2024-11-15 16:47:10', '36', 'Storage Condition'), (662, NULL, 'Storage Condition Approved', '2024-11-15 16:47:12', '36', 'Storage Condition'), (663, NULL, 'QR generated', '2024-11-15 16:48:19', '36', 'Generateqr'), (664, NULL, 'Generateqr Approved', '2024-11-15 16:48:25', '36', 'Approval'), (665, NULL, 'Multiple Print Had Taken', '2024-11-15 16:48:49', '36', 'generateqrsr'), (666, NULL, 'Single Print Had Taken', '2024-11-15 16:49:12', '36', 'generateqrsr'), (667, NULL, 'QR generated', '2024-11-15 16:49:48', '36', 'Generateqr'), (668, NULL, 'Generateqr Approved', '2024-11-15 16:49:54', '36', 'Approval'), (669, NULL, 'Multiple Print Had Taken', '2024-11-15 16:50:30', '36', 'generateqrsr'), (670, NULL, 'Multiple Print Had Taken', '2024-11-15 16:50:55', '36', 'generateqrsr'), (671, NULL, 'Single Print Had Taken', '2024-11-15 16:51:14', '36', 'generateqrsr'), (672, NULL, 'Multiple Print Had Taken', '2024-11-15 16:53:10', '36', 'generateqrsr'), (673, NULL, 'Single Print Had Taken', '2024-11-15 16:53:40', '36', 'generateqrsr'), (674, NULL, 'Lot Dispatched', '2024-11-15 16:54:16', '36', 'Dispatch'), (675, NULL, 'Dispatch Approved', '2024-11-15 16:54:24', '36', 'Approval'), (676, NULL, 'User Logged In', '2024-11-15 19:02:39', '36', 'Login In'), (677, NULL, 'Storage Condition Added', '2024-11-15 19:13:05', '36', 'Storage Condition'), (678, NULL, 'Storage Condition Approved', '2024-11-15 19:13:13', '36', 'Storage Condition'), (679, NULL, 'Storage Condition Added', '2024-11-15 19:13:29', '36', 'Storage Condition'), (680, NULL, 'Storage Condition Approved', '2024-11-15 19:13:38', '36', 'Storage Condition'), (681, NULL, 'QR generated', '2024-11-15 19:15:21', '36', 'Generateqr'), (682, NULL, 'Generateqr Approved', '2024-11-15 19:17:35', '36', 'Approval'), (683, NULL, 'QR generated', '2024-11-15 19:26:57', '36', 'Generateqr'), (684, NULL, 'Generateqr Approved', '2024-11-15 19:27:11', '36', 'Approval'), (685, NULL, 'User Logged In', '2024-11-19 10:57:53', '39', 'Login In'), (686, NULL, 'User Logged In', '2024-11-19 17:16:27', '36', 'Login In'), (687, NULL, 'User Logged In', '2024-11-21 21:59:18', '36', 'Login In'), (688, NULL, 'User Logged In', '2024-12-03 12:40:37', '36', 'Login In'), (689, NULL, 'User Logged In', '2024-12-03 17:42:50', '36', 'Login In'), (690, NULL, 'User Logged In', '2024-12-03 17:43:20', '36', 'Login In'), (691, NULL, 'User Logged In', '2024-12-03 17:43:28', '36', 'Login In'), (692, NULL, 'User Logged In', '2024-12-03 18:04:57', '36', 'Login In'), (693, NULL, 'User Logged In', '2024-12-03 19:20:22', '36', 'Login In'), (694, NULL, 'User Logged In', '2024-12-04 15:32:03', '36', 'Login In'), (695, NULL, 'User Logged In', '2024-12-04 15:59:32', '36', 'Login In'), (696, NULL, 'User Logged In', '2024-12-05 11:09:10', '36', 'Login In'), (697, NULL, 'User Logged In', '2024-12-05 12:36:40', '36', 'Login In'), (698, NULL, 'User Logged In', '2024-12-11 14:43:42', '36', 'Login In'), (699, NULL, 'User Logged In', '2024-12-11 15:37:15', '36', 'Login In'), (700, NULL, 'New Product Added', '2024-12-11 15:38:39', '36', 'Product'), (701, NULL, 'Product Approved', '2024-12-11 15:38:47', '36', 'Approval'), (702, NULL, 'Batch Added', '2024-12-11 15:39:19', '36', 'Batch'), (703, NULL, 'Batch Approved', '2024-12-11 15:39:28', '36', 'Approval'), (704, NULL, 'Alias Product Added', '2024-12-11 15:39:46', '36', 'Alias Product'), (705, NULL, 'Alias Product Approved', '2024-12-11 15:39:51', '36', 'Approval'), (706, NULL, 'Storage Condition Added', '2024-12-11 15:40:27', '36', 'Storage Condition'), (707, NULL, 'Storage Condition Added', '2024-12-11 15:40:44', '36', 'Storage Condition'), (708, NULL, 'Storage Condition Approved', '2024-12-11 15:40:51', '36', 'Storage Condition'), (709, NULL, 'Storage Condition Approved', '2024-12-11 15:40:53', '36', 'Storage Condition'), (710, NULL, 'QR generated', '2024-12-11 15:41:39', '36', 'Generateqr'), (711, NULL, 'Generateqr Approved', '2024-12-11 15:41:49', '36', 'Approval'), (712, NULL, 'Single Print Had Taken', '2024-12-11 15:42:08', '36', 'generateqrsr'), (713, NULL, 'Multiple Print Had Taken', '2024-12-11 15:42:21', '36', 'generateqrsr'), (714, NULL, 'Lot Dispatched', '2024-12-11 15:47:26', '36', 'Dispatch'), (715, NULL, 'Dispatch Approved', '2024-12-11 15:47:31', '36', 'Approval'), (716, NULL, 'Stock Returned', '2024-12-11 15:50:16', '36', 'Return Stocks'), (717, NULL, 'Returnstock Approved', '2024-12-11 15:50:21', '36', 'Approval'), (718, NULL, 'User Logged In', '2024-12-11 19:00:14', '39', 'Login In'), (719, NULL, 'User Logged In', '2024-12-12 19:45:01', '36', 'Login In'), (720, NULL, 'User Logged In', '2024-12-12 20:05:55', '36', 'Login In'), (721, NULL, 'New Product Added', '2024-12-12 20:16:07', '36', 'Product'), (722, NULL, 'User Logged In', '2024-12-17 18:54:08', '36', 'Login In'), (723, NULL, 'Product Rejected', '2024-12-17 18:55:27', '36', 'Approval'), (724, NULL, 'QR generated', '2024-12-17 19:01:10', '36', 'Generateqr'), (725, NULL, 'Generateqr Approved', '2024-12-17 19:02:53', '36', 'Approval'), (726, NULL, 'QR generated', '2024-12-17 19:03:50', '36', 'Generateqr'), (727, NULL, 'Generateqr Approved', '2024-12-17 19:04:22', '36', 'Approval'), (728, NULL, 'Product Updated', '2024-12-17 19:12:11', '36', 'Product'), (729, NULL, 'Product Approved', '2024-12-17 19:12:20', '36', 'Approval'), (730, NULL, 'Batch Added', '2024-12-17 19:13:28', '36', 'Batch'), (731, NULL, 'Batch Approved', '2024-12-17 19:13:36', '36', 'Approval'), (732, NULL, 'Alias Product Added', '2024-12-17 19:15:09', '36', 'Alias Product'), (733, NULL, 'Alias Product Approved', '2024-12-17 19:15:24', '36', 'Approval'), (734, NULL, 'Storage Condition Added', '2024-12-17 19:17:07', '36', 'Storage Condition'), (735, NULL, 'Storage Condition Approved', '2024-12-17 19:17:15', '36', 'Storage Condition'), (736, NULL, 'QR generated', '2024-12-17 19:17:57', '36', 'Generateqr'), (737, NULL, 'Generateqr Approved', '2024-12-17 19:18:06', '36', 'Approval'), (738, NULL, 'User Logged In', '2024-12-19 17:21:47', '36', 'Login In'), (739, NULL, 'User Logged In', '2024-12-19 17:21:57', '36', 'Login In'), (740, NULL, 'Single Print Had Taken', '2024-12-19 17:27:29', '36', 'generateqrsr'), (741, NULL, 'Product Updated', '2024-12-19 17:55:45', '36', 'Product'), (742, NULL, 'QR generated', '2024-12-19 17:57:29', '36', 'Generateqr'), (743, NULL, 'User Logged In', '2024-12-29 13:11:57', '36', 'Login In'), (744, NULL, 'User Logged In', '2024-12-29 16:45:50', '36', 'Login In'), (745, NULL, 'User Logged In', '2024-12-30 11:08:20', '36', 'Login In'), (746, NULL, 'User Logged In', '2025-01-02 13:29:50', '36', 'Login In'), (747, NULL, 'User Logged In', '2025-01-02 13:33:04', '36', 'Login In'), (748, NULL, 'User Logged In', '2025-01-02 14:08:19', '36', 'Login In'), (749, NULL, 'New Company Added', '2025-01-02 14:09:11', '36', 'Company Unit'), (750, NULL, 'Company Unit Approved', '2025-01-02 14:11:06', '36', 'Approval'), (751, NULL, 'New Product Added', '2025-01-02 14:12:03', '36', 'Product'), (752, NULL, 'Product Approved', '2025-01-02 14:15:55', '36', 'Approval'), (753, NULL, 'Batch Added', '2025-01-02 14:16:16', '36', 'Batch'), (754, NULL, 'Batch Approved', '2025-01-02 14:16:27', '36', 'Approval'), (755, NULL, 'Alias Product Added', '2025-01-02 14:16:45', '36', 'Alias Product'), (756, NULL, 'Alias Product Approved', '2025-01-02 14:16:56', '36', 'Approval'), (757, NULL, 'Storage Condition Added', '2025-01-02 14:17:20', '36', 'Storage Condition'), (758, NULL, 'Storage Condition Approved', '2025-01-02 14:17:32', '36', 'Storage Condition'), (759, NULL, 'QR generated', '2025-01-02 14:18:04', '36', 'Generateqr'), (760, NULL, 'Generateqr Approved', '2025-01-02 14:19:44', '36', 'Approval'), (761, NULL, 'Lot Dispatched', '2025-01-02 14:20:12', '36', 'Dispatch'), (762, NULL, 'Dispatch Approved', '2025-01-02 14:21:48', '36', 'Approval'), (763, NULL, 'Stock Returned', '2025-01-02 14:22:14', '36', 'Return Stocks'), (764, NULL, 'Returnstock Approved', '2025-01-02 14:26:44', '36', 'Approval'), (765, NULL, 'User Logged In', '2025-01-03 16:39:51', '36', 'Login In'), (766, NULL, 'User Logged In', '2025-01-03 17:02:08', '36', 'Login In'), (767, NULL, 'User Logged In', '2025-01-03 17:21:27', '36', 'Login In'), (768, NULL, 'User Logged In', '2025-01-03 19:02:50', '36', 'Login In'), (769, NULL, 'User Logged In', '2025-01-03 19:14:41', '39', 'Login In'), (770, NULL, 'Single Print Had Taken', '2025-01-03 19:15:57', '39', 'generateqrsr'), (771, NULL, 'User Logged In', '2025-01-03 19:16:50', '39', 'Login In'), (772, NULL, 'Single Print Had Taken', '2025-01-03 19:17:01', '39', 'generateqrsr'), (773, NULL, 'User Logged In', '2025-02-07 12:04:52', '36', 'Login In'), (774, NULL, 'User Logged In', '2025-02-21 12:28:16', '39', 'Login In'), (775, NULL, 'User Logged In', '2025-02-21 12:51:09', '39', 'Login In'), (776, NULL, 'User Logged In', '2025-04-17 13:24:57', '36', 'Login In'), (777, NULL, 'User Logged In', '2025-04-17 13:25:07', '36', 'Login In'); /*!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, `deletestatus` varchar(50) DEFAULT NULL, `manuaprstatus` varchar(50) DEFAULT NULL, `manrejstatus` varchar(50) DEFAULT NULL, `manuaprtime` datetime DEFAULT NULL, `manurejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 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`, `deletestatus`, `manuaprstatus`, `manrejstatus`, `manuaprtime`, `manurejtime`) VALUES (1, 'LAXACHEM ORGANICS PVT. LTD.', 'LAXACHEM ORGANICS PVT LTD', '(25) AMD/3/96', '890618164', 'Plot No. D-2, MIDC', NULL, 'AMRAVATI-444 607. (Maharashtra) INDIA ', '2024-08-03 11:21:56', '2024-08-16 14:56:29', '39', '0', '1', '0', '2024-08-16 17:09:25', NULL), (2, 'Alpha PVT', 'Alpha', 'DG1100', 'GSTIN00011', 'Amravati', NULL, 'Amravati', '2025-01-02 14:09:12', NULL, '36', '0', '1', '0', '2025-01-02 14:11:06', 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', `rejstatus` varchar(50) NOT NULL DEFAULT '0', `createdat` datetime NOT NULL, `approvedat` datetime DEFAULT NULL, `rejremark` varchar(150) DEFAULT NULL, `rejectedat` datetime DEFAULT NULL, `itemname` varchar(500) DEFAULT NULL, `purpose` varchar(500) DEFAULT NULL, `deletestatus` varchar(500) DEFAULT NULL, `userid` varchar(500) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.pagemaster: ~115 rows (approximately) /*!40000 ALTER TABLE `pagemaster` DISABLE KEYS */; INSERT INTO `pagemaster` (`id`, `roleid`, `pageid`, `pagename`, `status`, `rejstatus`, `createdat`, `approvedat`, `rejremark`, `rejectedat`, `itemname`, `purpose`, `deletestatus`, `userid`) VALUES (4, '37', '2', 'product', '1', '0', '2024-08-03 12:58:20', '2024-08-03 16:33:10', NULL, NULL, 'DOCUSATE SODIUM', 'New Item', '0', '39'), (7, '37', '5', 'product', '1', '0', '2024-08-03 13:10:06', '2024-08-04 13:07:16', NULL, NULL, 'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid', 'New Item', '0', '39'), (10, '37', '1', 'product', '1', '0', '2024-08-03 13:27:27', '2024-08-03 16:33:41', NULL, NULL, 'CHLOROBUTANOL', 'Edit', '0', '39'), (12, '37', '7', 'product', '1', '0', '2024-08-03 16:29:29', '2024-08-03 16:36:24', NULL, NULL, 'CHLOROBUTANOL', 'New Item', '0', '39'), (13, '37', '4', 'product', '1', '0', '2024-08-03 16:43:31', '2024-08-04 12:59:43', NULL, NULL, 'PROPYL GALLATE', 'Edit', '0', '39'), (14, '37', '6', 'product', '1', '0', '2024-08-04 13:08:23', '2024-08-04 14:31:49', NULL, NULL, 'FUROSEMIDE', 'Edit', '0', '39'), (21, '37', '1', 'pbatch', '1', '0', '2024-08-09 12:06:49', '2024-08-09 16:12:02', NULL, NULL, 'CH-40724', 'Delete', '1', '39'), (22, '37', '2', 'pbatch', '1', '0', '2024-08-09 12:06:52', '2024-08-09 16:12:31', NULL, NULL, 'CH-40624', 'Delete', '1', '39'), (23, '37', '3', 'pbatch', '1', '0', '2024-08-09 12:06:55', '2024-08-09 16:12:53', NULL, NULL, 'CH-50624', 'Delete', '1', '39'), (24, '37', '4', 'pbatch', '1', '0', '2024-08-09 12:08:25', '2024-08-09 16:14:10', NULL, NULL, 'CH-10824', 'New Item', '0', '39'), (25, '37', '5', 'pbatch', '1', '0', '2024-08-09 12:09:19', '2024-08-09 16:14:53', NULL, NULL, 'CH-20824', 'New Item', '0', '39'), (26, '37', '6', 'pbatch', '1', '0', '2024-08-09 12:10:00', '2024-08-09 16:15:42', NULL, NULL, 'CH-30824', 'New Item', '0', '39'), (27, '37', '7', 'pbatch', '1', '0', '2024-08-09 12:10:44', '2024-08-09 16:16:25', NULL, NULL, 'CH-40824', 'New Item', '0', '39'), (28, '37', '8', 'pbatch', '1', '0', '2024-08-09 12:11:30', '2024-08-09 16:16:43', NULL, NULL, 'CH-50824', 'New Item', '0', '39'), (29, '37', '1', 'addproduct', '1', '0', '2024-08-10 12:45:56', '2024-08-10 16:45:02', NULL, NULL, 'CHLOROBUTANOL', 'New Item', '0', '39'), (30, '37', '2', 'addproduct', '1', '0', '2024-08-10 12:47:08', '2024-08-10 16:45:04', NULL, NULL, 'CHLORBUTOL', 'New Item', '0', '39'), (31, '37', '1', 'storagecondition', '1', '0', '2024-08-11 15:07:16', '2024-08-11 16:12:16', NULL, NULL, 'In an air tight container', 'New Item', '0', '39'), (32, '37', '1', 'generateqr', '1', '0', '2024-08-11 16:13:18', '2024-08-11 16:16:38', NULL, NULL, 'LAX/0824/001', 'New Item', NULL, '39'), (34, '37', '3', 'addproduct', '1', '0', '2024-08-14 19:44:19', '2024-08-17 11:16:53', NULL, NULL, 'CHLORBUTOL (IND. USE ONLY)', 'Delete', '1', '39'), (35, '37', '1', 'manufacture', '1', '0', '2024-08-16 14:56:29', '2024-08-16 17:09:25', NULL, NULL, 'LAXACHEM ORGANICS PVT. LTD.', 'Edit', '0', '39'), (36, '37', '2', 'storagecondition', '1', '0', '2024-08-16 15:37:38', '2024-08-16 17:10:45', NULL, NULL, 'Store protect from moisture at temperature not exceeding 30° C', 'New Item', '0', '39'), (37, '37', '9', 'pbatch', '1', '0', '2024-08-17 10:46:22', '2024-08-17 11:13:51', NULL, NULL, 'FR-10824', 'New Item', '0', '39'), (38, '37', '4', 'addproduct', '1', '0', '2024-08-17 11:18:40', '2024-08-17 11:18:53', NULL, NULL, 'FUROSEMIDE', 'New Item', '0', '39'), (39, '37', '3', 'storagecondition', '1', '0', '2024-08-17 11:19:33', '2024-08-17 11:23:26', NULL, NULL, 'Store protect from moisture and light', 'New Item', '0', '39'), (40, '37', '2', 'generateqr', '1', '0', '2024-08-17 11:25:30', '2024-08-17 11:28:08', NULL, NULL, 'LAX/0824/002', 'New Item', NULL, '39'), (41, '37', '3', 'generateqr', '1', '0', '2024-08-17 12:10:07', '2024-08-17 13:24:01', NULL, NULL, 'LAX/0824/003', 'New Item', NULL, '39'), (42, '37', '4', 'generateqr', '1', '0', '2024-08-21 11:33:59', '2024-08-21 11:49:27', NULL, NULL, 'LAX/0824/004', 'New Item', NULL, '39'), (43, '37', '5', 'generateqr', '1', '0', '2024-08-21 11:34:37', '2024-08-21 11:49:45', NULL, NULL, 'LAX/0824/005', 'New Item', NULL, '39'), (44, '37', '4', 'storagecondition', '1', '0', '2024-08-23 15:07:55', '2024-08-24 15:21:47', NULL, NULL, 'Preserve in tight container', 'New Item', '0', '39'), (45, '37', '6', 'generateqr', '1', '0', '2024-08-24 15:28:16', '2024-08-24 15:54:41', NULL, NULL, 'LAX/0824/006', 'New Item', NULL, '39'), (46, '37', '7', 'generateqr', '1', '0', '2024-09-14 13:26:24', '2024-09-14 15:55:28', NULL, NULL, 'LAX/0924/007', 'New Item', NULL, '39'), (47, '37', '10', 'pbatch', '1', '0', '2024-09-14 15:40:51', '2024-09-14 15:55:52', NULL, NULL, 'CH-20924', 'New Item', '0', '39'), (48, '37', '8', 'generateqr', '1', '0', '2024-09-14 15:42:06', '2024-09-14 15:56:17', NULL, NULL, 'LAX/0924/008', 'New Item', NULL, '39'), (49, '37', '11', 'pbatch', '1', '0', '2024-09-14 15:52:15', '2024-09-14 15:56:58', NULL, NULL, 'CH-90824', 'New Item', '0', '39'), (50, '37', '9', 'generateqr', '1', '0', '2024-09-14 15:59:01', '2024-09-14 15:59:55', NULL, NULL, 'LAX/0924/009', 'New Item', NULL, '39'), (51, '37', '10', 'generateqr', '1', '0', '2024-09-14 17:42:44', '2024-09-14 17:43:26', NULL, NULL, 'LAX/0924/009', 'New Item', NULL, '39'), (52, '37', '11', 'generateqr', '1', '0', '2024-09-14 17:48:35', '2024-09-14 17:48:47', NULL, NULL, 'LAX/0924/011', 'New Item', NULL, '39'), (53, '37', '12', 'pbatch', '1', '0', '2024-09-18 09:44:13', '2024-09-18 09:44:25', NULL, NULL, 'DS-10824', 'New Item', '0', '39'), (54, '37', '5', 'addproduct', '1', '0', '2024-09-18 09:45:19', '2024-09-18 09:45:25', NULL, NULL, 'DOCUSATE SODIUM', 'New Item', '0', '39'), (55, '37', '5', 'storagecondition', '1', '0', '2024-09-18 09:46:28', '2024-09-18 09:46:34', NULL, NULL, 'In an air tight container', 'New Item', '0', '39'), (56, '37', '12', 'generateqr', '1', '0', '2024-09-18 09:47:05', '2024-09-18 09:47:11', NULL, NULL, 'LAX/0924/012', 'New Item', NULL, '39'), (57, '37', '13', 'generateqr', '1', '0', '2024-09-18 09:48:11', '2024-09-18 09:48:18', NULL, NULL, 'LAX/0924/013', 'New Item', NULL, '39'), (58, '37', '13', 'pbatch', '1', '0', '2024-09-18 12:35:23', '2024-09-18 14:06:25', NULL, NULL, 'CH-10924', 'New Item', '0', '39'), (59, '37', '14', 'pbatch', '1', '0', '2024-09-18 12:36:15', '2024-09-18 14:06:46', NULL, NULL, 'CH-30924', 'New Item', '0', '39'), (60, '37', '15', 'pbatch', '1', '0', '2024-09-18 12:37:14', '2024-09-18 14:07:08', NULL, NULL, 'CH-40924', 'New Item', '0', '39'), (61, '37', '16', 'pbatch', '1', '0', '2024-09-18 12:48:15', '2024-09-18 14:07:20', NULL, NULL, 'CH-50924', 'New Item', '0', '39'), (65, '37', '14', 'generateqr', '1', '0', '2024-09-19 12:17:58', '2024-09-19 15:28:29', NULL, NULL, 'LAX/0924/014', 'New Item', NULL, '39'), (66, '37', '15', 'generateqr', '1', '0', '2024-09-19 12:18:42', '2024-09-19 15:28:49', NULL, NULL, 'LAX/0924/015', 'New Item', NULL, '39'), (67, '37', '16', 'generateqr', '1', '0', '2024-09-19 12:19:11', '2024-09-19 15:29:01', NULL, NULL, 'LAX/0924/016', 'New Item', NULL, '39'), (68, '37', '17', 'generateqr', '1', '0', '2024-09-19 12:19:58', '2024-09-19 15:29:35', NULL, NULL, 'LAX/0924/017', 'New Item', NULL, '39'), (69, '37', '18', 'generateqr', '1', '0', '2024-09-20 16:01:03', '2024-09-20 16:17:28', NULL, NULL, 'LAX/0924/018', 'New Item', NULL, '39'), (70, '37', '19', 'generateqr', '1', '0', '2024-09-20 16:03:08', '2024-09-20 16:17:39', NULL, NULL, 'LAX/0924/019', 'New Item', NULL, '39'), (71, '37', '18', 'pbatch', '1', '0', '2024-09-20 16:04:50', '2024-09-20 16:18:06', NULL, NULL, 'CH-70824', 'New Item', '0', '39'), (72, '37', '20', 'generateqr', '1', '0', '2024-09-20 16:19:13', '2024-09-20 16:20:16', NULL, NULL, 'LAX/0924/020', 'New Item', NULL, '39'), (73, '37', '19', 'pbatch', '1', '0', '2024-09-21 11:20:40', '2024-09-21 14:59:08', NULL, NULL, 'CH-80824', 'New Item', '0', '39'), (74, '37', '21', 'generateqr', '1', '0', '2024-09-22 14:18:48', '2024-09-22 16:45:21', NULL, NULL, 'LAX/0924/021', 'New Item', NULL, '39'), (75, '37', '22', 'generateqr', '1', '0', '2024-09-22 18:34:33', '2024-09-24 12:08:47', NULL, NULL, 'LAX/0924/022', 'New Item', NULL, '39'), (76, '37', '20', 'pbatch', '1', '0', '2024-09-26 20:24:40', '2024-09-28 15:08:05', NULL, NULL, 'CH-70924', 'New Item', '0', '39'), (77, '37', '23', 'generateqr', '1', '0', '2024-09-27 13:53:50', '2024-09-28 15:08:18', NULL, NULL, 'LAX/0924/023', 'New Item', NULL, '39'), (78, '37', '21', 'pbatch', '1', '0', '2024-09-28 11:12:45', '2024-09-28 15:08:38', NULL, NULL, 'DS-20924', 'New Item', '0', '39'), (79, '37', '24', 'generateqr', '1', '0', '2024-09-28 11:14:17', '2024-09-28 15:08:52', NULL, NULL, 'LAX/0924/024', 'New Item', NULL, '39'), (80, '37', '25', 'generateqr', '1', '0', '2024-09-28 11:15:45', '2024-09-28 15:09:05', NULL, NULL, 'LAX/0924/025', 'New Item', NULL, '39'), (81, '37', '7', 'addproduct', '1', '0', '2024-09-28 11:16:42', '2024-09-28 17:13:42', NULL, NULL, '-', 'New Item', '0', '39'), (82, '37', '6', 'storagecondition', '1', '0', '2024-09-28 12:44:51', '2024-09-28 15:10:10', NULL, NULL, 'Preserve in well closed container', 'New Item', '0', '39'), (83, '37', '7', 'storagecondition', '1', '0', '2024-09-28 15:15:11', '2024-09-28 15:15:18', NULL, NULL, 'Preserve in well closed container', 'New Item', '0', '39'), (84, '37', '26', 'generateqr', '1', '0', '2024-09-28 15:16:10', '2024-09-28 17:13:59', NULL, NULL, 'LAX/0924/026', 'New Item', NULL, '39'), (85, '37', '27', 'generateqr', '1', '0', '2024-09-28 15:16:37', '2024-09-28 17:14:11', NULL, NULL, 'LAX/0924/027', 'New Item', NULL, '39'), (86, '37', '28', 'generateqr', '1', '0', '2024-09-28 15:17:08', '2024-09-28 17:14:25', NULL, NULL, 'LAX/0924/028', 'New Item', NULL, '39'), (88, '37', '8', 'storagecondition', '1', '0', '2024-10-02 13:03:32', '2024-10-02 13:03:40', NULL, NULL, 'Preserve in well closed container', 'New Item', '0', '39'), (89, '37', '6', 'addproduct', '1', '0', '2024-10-02 13:04:21', '2024-10-02 13:04:27', NULL, NULL, 'DOCUSATE SODIUM 85%', 'Edit', '0', '39'), (90, '37', '3', 'product', '1', '0', '2024-10-02 13:05:39', '2024-10-02 13:05:46', NULL, NULL, 'DOCUSATE SODIUM 85% POWDER', 'Edit', '0', '39'), (91, '37', '17', 'pbatch', '1', '0', '2024-10-02 13:06:02', '2024-10-02 13:06:07', NULL, NULL, 'DP-10624', 'Edit', '0', '39'), (92, '37', '29', 'generateqr', '1', '0', '2024-10-02 13:06:36', '2024-10-02 13:06:44', NULL, NULL, 'LAX/1024/029', 'New Item', NULL, '39'), (93, '36', '8', 'product', '1', '0', '2024-10-07 15:42:17', '2024-10-07 15:42:22', NULL, NULL, 'Test 1', 'New Item', '0', '36'), (94, '36', '22', 'pbatch', '1', '0', '2024-10-07 15:42:55', '2024-10-07 15:43:01', NULL, NULL, 'Test 1 batch', 'New Item', '0', '36'), (95, '36', '8', 'addproduct', '1', '0', '2024-10-07 15:43:21', '2024-10-07 15:43:24', NULL, NULL, 'Test 1 Alias', 'New Item', '0', '36'), (96, '36', '9', 'storagecondition', '1', '0', '2024-10-07 15:43:47', '2024-10-07 15:43:57', NULL, NULL, 'Teest 1 In-House Grade', 'New Item', '0', '36'), (97, '36', '30', 'generateqr', '1', '0', '2024-10-07 15:44:32', '2024-10-07 15:44:40', NULL, NULL, 'LAX/1024/030', 'New Item', NULL, '36'), (98, '36', '9', 'product', '1', '0', '2024-11-15 16:43:01', '2024-11-15 16:43:10', NULL, NULL, 'test 1511', 'New Item', '0', '36'), (99, '36', '23', 'pbatch', '1', '0', '2024-11-15 16:43:39', '2024-11-15 16:43:44', NULL, NULL, '1511B', 'New Item', '0', '36'), (100, '36', '1', 'customer', '1', '0', '2024-11-15 16:44:48', '2024-11-15 16:44:53', NULL, NULL, 'B PHARMA', 'New Item', '0', '36'), (101, '36', '9', 'addproduct', '1', '0', '2024-11-15 16:45:06', '2024-11-15 16:45:10', NULL, NULL, '1511A', 'New Item', '0', '36'), (102, '36', '10', 'storagecondition', '1', '0', '2024-11-15 16:45:35', '2024-11-15 16:47:10', NULL, NULL, '1511 Alias Condition', 'New Item', '0', '36'), (103, '36', '11', 'storagecondition', '1', '0', '2024-11-15 16:47:01', '2024-11-15 16:47:12', NULL, NULL, '1511 BP alias condition', 'New Item', '0', '36'), (104, '36', '31', 'generateqr', '1', '0', '2024-11-15 16:48:19', '2024-11-15 16:48:25', NULL, NULL, 'LAX/1124/031', 'New Item', NULL, '36'), (105, '36', '32', 'generateqr', '1', '0', '2024-11-15 16:49:48', '2024-11-15 16:49:54', NULL, NULL, 'LAX/1124/032', 'New Item', NULL, '36'), (106, '36', '1', 'dispatch', '1', '0', '2024-11-15 16:54:16', '2024-11-15 16:54:24', NULL, NULL, 'LAX/1124/031', 'New Item', '0', '36'), (107, '36', '12', 'storagecondition', '1', '0', '2024-11-15 19:13:05', '2024-11-15 19:13:13', NULL, NULL, 'po', 'New Item', '0', '36'), (108, '36', '13', 'storagecondition', '1', '0', '2024-11-15 19:13:29', '2024-11-15 19:13:38', NULL, NULL, 'op', 'New Item', '0', '36'), (109, '36', '33', 'generateqr', '1', '0', '2024-11-15 19:15:22', '2024-11-15 19:17:35', NULL, NULL, 'LAX/1124/033', 'New Item', NULL, '36'), (110, '36', '34', 'generateqr', '1', '0', '2024-11-15 19:26:58', '2024-11-15 19:27:11', NULL, NULL, 'LAX/1124/034', 'New Item', NULL, '36'), (111, '36', '10', 'product', '1', '0', '2024-12-11 15:38:39', '2024-12-11 15:38:47', NULL, NULL, 'Wednessday', 'New Item', '0', '36'), (112, '36', '24', 'pbatch', '1', '0', '2024-12-11 15:39:20', '2024-12-11 15:39:28', NULL, NULL, 'W112B', 'New Item', '0', '36'), (113, '36', '10', 'addproduct', '1', '0', '2024-12-11 15:39:46', '2024-12-11 15:39:51', NULL, NULL, 'W1112AL', 'New Item', '0', '36'), (114, '36', '14', 'storagecondition', '1', '0', '2024-12-11 15:40:27', '2024-12-11 15:40:51', NULL, NULL, 'Wednesday ip grade', 'New Item', '0', '36'), (115, '36', '15', 'storagecondition', '1', '0', '2024-12-11 15:40:44', '2024-12-11 15:40:53', NULL, NULL, 'Wednesday bp grade', 'New Item', '0', '36'), (116, '36', '35', 'generateqr', '1', '0', '2024-12-11 15:41:39', '2024-12-11 15:41:49', NULL, NULL, 'LAX/1224/035', 'New Item', NULL, '36'), (117, '36', '2', 'dispatch', '1', '0', '2024-12-11 15:47:26', '2024-12-11 15:47:31', NULL, NULL, 'LAX/1224/035', 'New Item', '0', '36'), (118, '36', '1', 'returnstock', '1', '0', '2024-12-11 15:50:17', '2024-12-11 15:50:21', NULL, NULL, 'LAX/1224/035', 'New Item', '0', '36'), (120, '36', '36', 'generateqr', '1', '0', '2024-12-17 19:01:11', '2024-12-17 19:02:53', NULL, NULL, 'LAX/1224/036', 'New Item', NULL, '36'), (121, '36', '37', 'generateqr', '1', '0', '2024-12-17 19:03:50', '2024-12-17 19:04:22', NULL, NULL, 'LAX/1224/037', 'New Item', NULL, '36'), (123, '36', '25', 'pbatch', '1', '0', '2024-12-17 19:13:28', '2024-12-17 19:13:36', NULL, NULL, '101', 'New Item', '0', '36'), (124, '36', '11', 'addproduct', '1', '0', '2024-12-17 19:15:10', '2024-12-17 19:15:24', NULL, NULL, 'v', 'New Item', '0', '36'), (125, '36', '16', 'storagecondition', '1', '0', '2024-12-17 19:17:07', '2024-12-17 19:17:15', NULL, NULL, 'vt', 'New Item', '0', '36'), (126, '36', '38', 'generateqr', '1', '0', '2024-12-17 19:17:57', '2024-12-17 19:18:05', NULL, NULL, 'LAX/1224/038', 'New Item', NULL, '36'), (127, '36', '11', 'product', '0', '0', '2024-12-19 17:55:46', NULL, NULL, NULL, 'vnnv', 'Edit', '0', '36'), (128, '36', '39', 'generateqr', '0', '0', '2024-12-19 17:57:30', NULL, NULL, NULL, 'LAX/1224/039', 'New Item', NULL, '36'), (129, '36', '2', 'manufacture', '1', '0', '2025-01-02 14:09:12', '2025-01-02 14:11:06', NULL, NULL, 'Alpha PVT', 'New Item', '0', '36'), (130, '36', '12', 'product', '1', '0', '2025-01-02 14:12:04', '2025-01-02 14:15:55', NULL, NULL, 'Alpha p1', 'New Item', '0', '36'), (131, '36', '26', 'pbatch', '1', '0', '2025-01-02 14:16:17', '2025-01-02 14:16:27', NULL, NULL, 'p1b1', 'New Item', '0', '36'), (132, '36', '12', 'addproduct', '1', '0', '2025-01-02 14:16:46', '2025-01-02 14:16:56', NULL, NULL, 'p1 alias', 'New Item', '0', '36'), (133, '36', '17', 'storagecondition', '1', '0', '2025-01-02 14:17:20', '2025-01-02 14:17:32', NULL, NULL, 'Alpha p1 IP', 'New Item', '0', '36'), (134, '36', '40', 'generateqr', '1', '0', '2025-01-02 14:18:04', '2025-01-02 14:19:44', NULL, NULL, 'LAX/0125/040', 'New Item', NULL, '36'), (135, '36', '3', 'dispatch', '1', '0', '2025-01-02 14:20:13', '2025-01-02 14:21:48', NULL, NULL, 'LAX/0125/040', 'New Item', '0', '36'), (136, '36', '2', 'returnstock', '1', '0', '2025-01-02 14:22:15', '2025-01-02 14:26:44', NULL, NULL, 'LAX/0125/040', 'New Item', '0', '36'); /*!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, `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT NULL, `bataprstatus` varchar(50) DEFAULT NULL, `batrejstatus` varchar(50) DEFAULT NULL, `bataprtime` datetime DEFAULT NULL, `batrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.pbatch: ~26 rows (approximately) /*!40000 ALTER TABLE `pbatch` DISABLE KEYS */; INSERT INTO `pbatch` (`id`, `batch`, `product`, `batchsize`, `batchnumber`, `mfgdate`, `expdate`, `weight`, `remark`, `pid`, `created`, `updated`, `userid`, `deletestatus`, `bataprstatus`, `batrejstatus`, `bataprtime`, `batrejtime`) VALUES (1, 'CH-40724', '1', '500', 'NA', '2024-07-01', '2029-06-01', '', '', 'IP,BP,EP,USP', '2024-08-07 12:00:22', '2024-08-07 12:00:22', '39', '1', '1', '0', '2024-08-09 16:12:02', NULL), (2, 'CH-40624', '1', '500', 'NA', '2024-06-01', '2029-05-01', '', '', 'IP,BP,EP,USP', '2024-08-07 12:00:30', '2024-08-07 12:00:30', '39', '1', '1', '0', '2024-08-09 16:12:31', NULL), (3, 'CH-50624', '1', '500', 'NA', '2024-06-01', '2029-05-01', '', '', 'IP,BP,EP,USP', '2024-08-07 11:58:02', NULL, '39', '1', '1', '0', '2024-08-09 16:12:53', NULL), (4, 'CH-10824', '1', '500', 'NA', '2024-08-01', '2029-07-01', '', '', 'IP,BP,EP,USP', '2024-08-09 12:08:25', NULL, '39', '0', '1', '0', '2024-08-09 16:14:10', NULL), (5, 'CH-20824', '1', '500', 'NA', '2024-08-01', '2029-07-01', '', '', 'IP,BP,EP,USP', '2024-08-09 12:09:18', NULL, '39', '0', '1', '0', '2024-08-09 16:14:53', NULL), (6, 'CH-30824', '1', '500', 'NA', '2024-08-01', '2029-07-01', '', '', 'IP,BP,EP,USP', '2024-08-09 12:09:59', NULL, '39', '0', '1', '0', '2024-08-09 16:15:42', NULL), (7, 'CH-40824', '1', '500', 'NA', '2024-08-01', '2029-07-01', '', '', 'IP,BP,EP,USP', '2024-08-09 12:10:43', NULL, '39', '0', '1', '0', '2024-08-09 16:16:25', NULL), (8, 'CH-50824', '1', '500', 'NA', '2024-08-01', '2029-07-01', '', '', 'IP,BP,EP,USP', '2024-08-09 12:11:29', NULL, '39', '0', '1', '0', '2024-08-09 16:16:43', NULL), (9, 'FR-10824', '6', '400', 'NA', '2024-08-01', '2029-07-01', '', '', 'IP,BP', '2024-08-17 10:46:21', NULL, '39', '0', '1', '0', '2024-08-17 11:13:51', NULL), (10, 'CH-20924', '1', '500', 'NA', '2024-09-01', '2029-08-01', '', '', 'IP,BP,EP,USP', '2024-09-14 15:40:50', NULL, '39', '0', '1', '0', '2024-09-14 15:55:52', NULL), (11, 'CH-90824', '1', '500', 'NA', '2024-08-01', '2029-07-01', '', '', 'IP,BP,EP,USP', '2024-09-14 15:52:14', NULL, '39', '0', '1', '0', '2024-09-14 15:56:58', NULL), (12, 'DS-10824', '2', '500', 'NA', '2024-08-01', '2029-07-01', '', '', 'IP,BP,EP,USP', '2024-09-18 09:44:13', NULL, '39', '0', '1', '0', '2024-09-18 09:44:25', NULL), (13, 'CH-10924', '1', '500', 'NA', '2024-09-01', '2029-08-01', '', '', 'IP,BP,EP,USP', '2024-09-18 12:35:22', NULL, '39', '0', '1', '0', '2024-09-18 14:06:25', NULL), (14, 'CH-30924', '1', '500', 'NA', '2024-09-01', '2029-08-01', '', '', 'IP,BP,EP,USP', '2024-09-18 12:36:14', NULL, '39', '0', '1', '0', '2024-09-18 14:06:46', NULL), (15, 'CH-40924', '1', '500', 'NA', '2024-09-01', '2029-08-01', '', '', 'IP,BP,EP,USP', '2024-09-18 12:37:14', NULL, '39', '0', '1', '0', '2024-09-18 14:07:08', NULL), (16, 'CH-50924', '1', '500', 'NA', '2024-09-01', '2029-08-01', '', '', 'IP,BP,EP,USP', '2024-09-18 12:48:14', NULL, '39', '0', '1', '0', '2024-09-18 14:07:20', NULL), (17, 'DP-10624', '3', '500', 'NA', '2024-06-01', '2029-05-01', '', '', 'TECHNICAL', '2024-10-02 13:06:02', '2024-10-02 13:06:02', '39', '0', '1', '0', '2024-10-02 13:06:07', NULL), (18, 'CH-70824', '1', '500', 'NA', '2024-08-01', '2029-07-01', '', '', 'IP,BP,EP,USP', '2024-09-20 16:04:49', NULL, '39', '0', '1', '0', '2024-09-20 16:18:06', NULL), (19, 'CH-80824', '1', '500', 'NA', '2024-08-01', '2029-07-01', '', '', 'IP,BP,EP,USP', '2024-09-21 11:20:39', NULL, '39', '0', '1', '0', '2024-09-21 14:59:08', NULL), (20, 'CH-70924', '1', '500', 'NA', '2024-09-01', '2029-08-01', '', '', 'IP,BP,EP,USP', '2024-09-26 20:24:39', NULL, '39', '0', '1', '0', '2024-09-28 15:08:05', NULL), (21, 'DS-20924', '2', '500', 'NA', '2024-09-01', '2029-08-01', '', '', 'IP,BP,EP,USP', '2024-09-28 11:12:45', NULL, '39', '0', '1', '0', '2024-09-28 15:08:38', NULL), (22, 'Test 1 batch', '8', '1000', '', '2024-10-01', '2025-12-01', '', '', 'In-House', '2024-10-07 15:42:55', NULL, '36', '0', '1', '0', '2024-10-07 15:43:01', NULL), (23, '1511B', '9', '2000', '', '2024-11-01', '2027-06-01', '', '', 'IP,BP', '2024-11-15 16:43:39', NULL, '36', '0', '1', '0', '2024-11-15 16:43:44', NULL), (24, 'W112B', '10', '200', '', '2024-12-01', '2026-06-01', '', '', 'IP,BP', '2024-12-11 15:39:19', NULL, '36', '0', '1', '0', '2024-12-11 15:39:28', NULL), (25, '101', '11', '500', '', '2024-12-01', '2025-12-01', '', '', 'IP,TECHNICAL', '2024-12-17 19:13:28', NULL, '36', '0', '1', '0', '2024-12-17 19:13:36', NULL), (26, 'p1b1', '12', '200', '', '2025-01-01', '2026-06-01', '', '', 'IP', '2025-01-02 14:16:16', NULL, '36', '0', '1', '0', '2025-01-02 14:16:27', 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 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.preset: ~0 rows (approximately) /*!40000 ALTER TABLE `preset` DISABLE KEYS */; /*!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, `userid` varchar(50) DEFAULT NULL, `formula` varchar(255) DEFAULT NULL, `molwt` varchar(255) DEFAULT NULL, `deletestatus` varchar(255) DEFAULT NULL, `prodaprstatus` varchar(255) DEFAULT NULL, `prodrejstatus` varchar(255) DEFAULT NULL, `prodaprtime` datetime DEFAULT NULL, `prodrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.product: ~12 rows (approximately) /*!40000 ALTER TABLE `product` DISABLE KEYS */; INSERT INTO `product` (`id`, `name`, `brand`, `gtin`, `manu`, `manutxt`, `scon`, `grade`, `subname`, `pack`, `uom`, `created`, `updated`, `userid`, `formula`, `molwt`, `deletestatus`, `prodaprstatus`, `prodrejstatus`, `prodaprtime`, `prodrejtime`) VALUES (1, 'CHLOROBUTANOL', 'NA', '8906181640009', '1', 'LAXACHEM ORGANICS PVT LTD', 'Preserve in air tight container', 'IP,BP,EP,USP', 'HEMIHYDRATE', '5,10,15,20,25', 'KGS', '2024-08-03 12:54:22', '2024-08-03 13:27:27', '39', 'C4H7Cl3O,1/2H2O', '186.5', '0', '1', '0', '2024-08-03 16:33:41', NULL), (2, 'DOCUSATE SODIUM', 'NA', '8906181640023', '1', 'LAXACHEM ORGANICS PVT LTD', 'Preserve in well closed container', 'IP,BP,EP,USP', 'Dioctyl Sodium Sulfosuccinate', '5,10,15,20,25', 'KGS', '2024-08-03 12:58:20', NULL, '39', 'C20H37NaO7S', '444.6', '0', '1', '0', '2024-08-03 16:33:10', NULL), (3, 'DOCUSATE SODIUM 85% POWDER', 'NA', '8906181640030', '1', 'LAXACHEM ORGANICS PVT LTD', 'Preserve in well closed container', 'TECHNICAL', 'NA', '5,10,15,20,25', 'KGS', '2024-08-03 13:04:30', '2024-10-02 13:05:39', '39', 'NA', 'NA', '0', '1', '0', '2024-10-02 13:05:46', NULL), (4, 'PROPYL GALLATE', 'NA', '8906181640047', '1', 'LAXACHEM ORGANICS PVT LTD', 'Store protect from light, in non-metallic container', 'IP,BP,USP', 'NA', '5,10,15,20,25', 'KGS', '2024-08-03 13:06:54', '2024-08-03 16:43:31', '39', 'C10H12O5', '212.2', '0', '1', '0', '2024-08-04 12:59:43', NULL), (5, 'Sodium salt of 4-Chloro-2-[(furan-2-ylmethyl)amino]5-sulfamoylbenzoic acid', 'NA', 'NA', '1', 'LAXACHEM ORGANICS PVT LTD', 'NA', 'TECHNICAL', 'NA', '5,10,15,20,25', 'KGS', '2024-08-03 13:10:06', NULL, '39', 'C12H11CIN2O5S', '330.7', '0', '1', '0', '2024-08-04 13:07:16', NULL), (6, 'FUROSEMIDE', 'NA', '8906181640054', '1', 'LAXACHEM ORGANICS PVT LTD', 'Store protect from moisture and light', 'IP,BP,EP,USP', 'NA', '5,10,15,20,25', 'KGS', '2024-08-03 13:12:43', '2024-08-04 13:08:23', '39', 'C12H11CIN2O5S', '330.7', '0', '1', '0', '2024-08-04 14:31:49', '2024-08-04 13:03:26'), (7, 'CHLOROBUTANOL', 'NA', '8906181640016', '1', 'LAXACHEM ORGANICS PVT LTD', 'In an air tight container', 'IP,BP,EP,USP', 'ANHYDROUS', '5,10,15,20,25', 'KGS', '2024-08-03 16:29:29', NULL, '39', 'C4H7Cl3O', '177.5', '0', '1', '0', '2024-08-03 16:36:24', NULL), (8, 'Test 1', '', '1234567991025', '1', 'LAXACHEM ORGANICS PVT LTD', '', 'In-House', 'Sub Test 1', '25', 'KGS', '2024-10-07 15:42:17', NULL, '36', 'HY6GY7', '12.25', '0', '1', '0', '2024-10-07 15:42:22', NULL), (9, 'test 1511', '', '1234567895214', '1', 'LAXACHEM ORGANICS PVT LTD', '', 'IP,BP', '1511', '12,15,25', 'KGS', '2024-11-15 16:43:01', NULL, '36', 'H3O', '120.23', '0', '1', '0', '2024-11-15 16:43:10', NULL), (10, 'Wednessday', '', '1254698653214', '1', 'LAXACHEM ORGANICS PVT LTD', '', 'IP,BP', '1112', '15,20,25', 'KGS', '2024-12-11 15:38:39', NULL, '36', 'H7YU78H', '15', '0', '1', '0', '2024-12-11 15:38:47', NULL), (11, 'vnnv', 'nv', 'van', '1', 'LAXACHEM ORGANICS PVT LTD', 'nx', 'IP,TECHNICAL', 'mvcx', '31', 'KGS', '2024-12-12 20:16:07', '2024-12-19 17:55:46', '36', '13', '31', '0', '0', '0', '2024-12-17 19:12:20', '2024-12-17 18:55:27'), (12, 'Alpha p1', '', '1254879658974', '1', 'LAXACHEM ORGANICS PVT LTD', '', 'IP', 'Alpha Prod', '15', 'KGS', '2025-01-02 14:12:04', NULL, '36', 'FR12GY', '12.25', '0', '1', '0', '2025-01-02 14:15:55', NULL); /*!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, `userid` varchar(50) DEFAULT NULL, `status` varchar(50) DEFAULT '0', `deletestatus` varchar(50) DEFAULT '0', `rtime` varchar(50) DEFAULT NULL, `retaprstatus` varchar(50) DEFAULT NULL, `retrejstatus` varchar(50) DEFAULT NULL, `retaprtime` datetime DEFAULT NULL, `retrejtime` datetime DEFAULT NULL, `customerid` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 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`, `userid`, `status`, `deletestatus`, `rtime`, `retaprstatus`, `retrejstatus`, `retaprtime`, `retrejtime`, `customerid`) VALUES (1, '35', 'Faulty Container', '2024-12-11', '2024-12-11 15:50:16', NULL, '36', '0', '0', '2024-12-11 15:50:16', '1', '0', '2024-12-11 15:50:21', NULL, '1'), (2, '40', 'Defau;ty Container', '2025-01-02', '2025-01-02 14:22:14', NULL, '36', '0', '0', '2025-01-02 14:22:14', '1', '0', '2025-01-02 14:26:44', NULL, '1'); /*!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, `userid` varchar(50) DEFAULT NULL, `updated` varchar(50) DEFAULT NULL, `contno` varchar(50) DEFAULT NULL, `rntime` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.returnstocknew: ~4 rows (approximately) /*!40000 ALTER TABLE `returnstocknew` DISABLE KEYS */; INSERT INTO `returnstocknew` (`id`, `lotid`, `ssccno`, `tarewt`, `netwt`, `grosswt`, `created`, `userid`, `updated`, `contno`, `rntime`) VALUES (1, '35', '012546986532140011', '12.25', '15', '27.25', NULL, NULL, NULL, '1/5', '2024-12-11 15:50:16'), (2, '40', '012548796589740030', '12.25', '15', '27.25', NULL, NULL, NULL, '3/10', '2025-01-02 14:22:15'), (3, '40', '012548796589740021', '12.25', '15', '27.25', NULL, NULL, NULL, '2/10', '2025-01-02 14:22:15'), (4, '40', '012548796589740012', '12.25', '15', '27.25', NULL, NULL, NULL, '1/10', '2025-01-02 14:22:16'); /*!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 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.rolemaster: ~0 rows (approximately) /*!40000 ALTER TABLE `rolemaster` DISABLE KEYS */; /*!40000 ALTER TABLE `rolemaster` ENABLE KEYS */; -- Dumping structure for table laxachem.storagecondition CREATE TABLE IF NOT EXISTS `storagecondition` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product` varchar(255) NOT NULL, `productid` int(11) NOT NULL DEFAULT '0', `grade` varchar(50) NOT NULL, `scondition` varchar(255) DEFAULT NULL, `aliasscondition` varchar(255) DEFAULT NULL, `createdat` datetime DEFAULT NULL, `updatedat` datetime DEFAULT NULL, `userid` varchar(50) DEFAULT NULL, `deletestatus` varchar(50) DEFAULT '0', `strgaprstatus` varchar(50) DEFAULT '0', `strgrejstatus` varchar(50) DEFAULT '0', `strgaprtime` datetime DEFAULT NULL, `strgrejtime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8; -- Dumping data for table laxachem.storagecondition: ~17 rows (approximately) /*!40000 ALTER TABLE `storagecondition` DISABLE KEYS */; INSERT INTO `storagecondition` (`id`, `product`, `productid`, `grade`, `scondition`, `aliasscondition`, `createdat`, `updatedat`, `userid`, `deletestatus`, `strgaprstatus`, `strgrejstatus`, `strgaprtime`, `strgrejtime`) VALUES (1, 'CHLOROBUTANOL', 1, 'BP', NULL, 'In an air tight container', '2024-08-11 15:07:16', NULL, '39', '0', '1', '0', '2024-08-11 16:12:16', NULL), (2, 'CHLOROBUTANOL', 1, 'IP', NULL, 'Store protect from moisture at temperature not exceeding 30° C', '2024-08-16 15:37:38', NULL, '39', '0', '1', '0', '2024-08-16 17:10:45', NULL), (3, 'FUROSEMIDE', 6, 'IP', NULL, 'Store protect from moisture and light', '2024-08-17 11:19:32', NULL, '39', '0', '1', '0', '2024-08-17 11:23:26', NULL), (4, 'CHLOROBUTANOL', 1, 'USP', NULL, 'Preserve in tight container', '2024-08-23 15:07:55', NULL, '39', '0', '1', '0', '2024-08-24 15:21:47', NULL), (5, 'DOCUSATE SODIUM', 2, 'BP', NULL, 'In an air tight container', '2024-09-18 09:46:28', NULL, '39', '0', '1', '0', '2024-09-18 09:46:34', NULL), (6, 'DOCUSATE SODIUM 85% POWDER', 3, 'USP', NULL, 'Preserve in well closed container', '2024-09-28 12:44:50', NULL, '39', '0', '1', '0', '2024-09-28 15:10:10', NULL), (7, 'DOCUSATE SODIUM', 2, 'USP', NULL, 'Preserve in well closed container', '2024-09-28 15:15:11', NULL, '39', '0', '1', '0', '2024-09-28 15:15:18', NULL), (8, 'DOCUSATE SODIUM 85% POWDER', 3, 'TECHNICAL', NULL, 'Preserve in well closed container', '2024-10-02 13:03:32', NULL, '39', '0', '1', '0', '2024-10-02 13:03:40', NULL), (9, 'Test 1', 8, 'In-House', NULL, 'Teest 1 In-House Grade', '2024-10-07 15:43:47', NULL, '36', '0', '1', '0', '2024-10-07 15:43:57', NULL), (10, 'test 1511', 9, 'IP', NULL, '1511 Alias Condition', '2024-11-15 16:45:34', NULL, '36', '0', '1', '0', '2024-11-15 16:47:10', NULL), (11, 'test 1511', 9, 'BP', NULL, '1511 BP alias condition', '2024-11-15 16:47:01', NULL, '36', '0', '1', '0', '2024-11-15 16:47:12', NULL), (12, 'CHLOROBUTANOL', 1, 'BP', NULL, 'po', '2024-11-15 19:13:04', NULL, '36', '0', '1', '0', '2024-11-15 19:13:13', NULL), (13, 'CHLOROBUTANOL', 1, 'BP', NULL, 'op', '2024-11-15 19:13:29', NULL, '36', '0', '1', '0', '2024-11-15 19:13:38', NULL), (14, 'Wednessday', 10, 'IP', NULL, 'Wednesday ip grade', '2024-12-11 15:40:26', NULL, '36', '0', '1', '0', '2024-12-11 15:40:51', NULL), (15, 'Wednessday', 10, 'BP', NULL, 'Wednesday bp grade', '2024-12-11 15:40:44', NULL, '36', '0', '1', '0', '2024-12-11 15:40:53', NULL), (16, 'vnnv', 11, 'TECHNICAL', NULL, 'vt', '2024-12-17 19:17:07', NULL, '36', '0', '1', '0', '2024-12-17 19:17:15', NULL), (17, 'Alpha p1', 12, 'IP', NULL, 'Alpha p1 IP', '2025-01-02 14:17:20', NULL, '36', '0', '1', '0', '2025-01-02 14:17:32', NULL); /*!40000 ALTER TABLE `storagecondition` 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 '', `scondition` varchar(100) DEFAULT '', `batch` varchar(100) DEFAULT '', `customerr` varchar(100) DEFAULT '', `dispatch` varchar(100) DEFAULT '', `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `dispatchreport` varchar(100) DEFAULT '', `generateqr` varchar(100) DEFAULT '', `logreport` varchar(100) DEFAULT '', `manufact` varchar(100) DEFAULT '', `products` varchar(100) DEFAULT '', `returnstocks` varchar(100) DEFAULT '', `rsreport` varchar(100) DEFAULT '', `ssccreport` varchar(100) DEFAULT '', `stocks` varchar(100) DEFAULT '', `generateqradministration` varchar(100) DEFAULT '', `userm` varchar(100) DEFAULT '', `role` varchar(50) DEFAULT NULL, `aliasproductadmin` varchar(50) DEFAULT NULL, `customeradmin` varchar(50) DEFAULT NULL, `dispatchadmin` varchar(50) DEFAULT NULL, `generateqradmin` varchar(50) DEFAULT NULL, `manufactureadmin` varchar(50) DEFAULT NULL, `pbatchadmin` varchar(50) DEFAULT NULL, `productadmin` varchar(50) DEFAULT NULL, `returnstockadmin` varchar(50) DEFAULT NULL, `stockadmin` varchar(50) DEFAULT NULL, `usermadmin` varchar(50) DEFAULT NULL, `sconditionadmin` varchar(50) DEFAULT NULL, `aliasproductadministration` varchar(50) DEFAULT NULL, `customeradministration` varchar(50) DEFAULT NULL, `dispatchadministration` varchar(50) DEFAULT NULL, `manufactureadministration` varchar(50) DEFAULT NULL, `pbatchadministration` varchar(50) DEFAULT NULL, `productadministration` varchar(50) DEFAULT NULL, `returnstockadministration` varchar(50) DEFAULT NULL, `stockadministration` varchar(50) DEFAULT NULL, `usermadministration` varchar(50) DEFAULT NULL, `sconditionadministration` varchar(50) DEFAULT NULL, `aliasproductqa` varchar(50) DEFAULT NULL, `customerqa` varchar(50) DEFAULT NULL, `dispatchqa` varchar(50) DEFAULT NULL, `generateqrqa` varchar(50) DEFAULT NULL, `manufactureqa` varchar(50) DEFAULT NULL, `pbatchqa` varchar(50) DEFAULT NULL, `productqa` varchar(50) DEFAULT NULL, `returnstockqa` varchar(50) DEFAULT NULL, `stockqa` varchar(50) DEFAULT NULL, `usermqa` varchar(50) DEFAULT NULL, `sconditionqa` varchar(50) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `approval` varchar(50) DEFAULT NULL, `reports` varchar(50) DEFAULT NULL, `subuser` varchar(255) DEFAULT NULL, `stockconversion` varchar(255) DEFAULT NULL, `stockdiscard` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1; -- Dumping data for table laxachem.userm: ~5 rows (approximately) /*!40000 ALTER TABLE `userm` DISABLE KEYS */; INSERT INTO `userm` (`id`, `username`, `password`, `rights`, `addproduct`, `scondition`, `batch`, `customerr`, `dispatch`, `created`, `updated`, `dispatchreport`, `generateqr`, `logreport`, `manufact`, `products`, `returnstocks`, `rsreport`, `ssccreport`, `stocks`, `generateqradministration`, `userm`, `role`, `aliasproductadmin`, `customeradmin`, `dispatchadmin`, `generateqradmin`, `manufactureadmin`, `pbatchadmin`, `productadmin`, `returnstockadmin`, `stockadmin`, `usermadmin`, `sconditionadmin`, `aliasproductadministration`, `customeradministration`, `dispatchadministration`, `manufactureadministration`, `pbatchadministration`, `productadministration`, `returnstockadministration`, `stockadministration`, `usermadministration`, `sconditionadministration`, `aliasproductqa`, `customerqa`, `dispatchqa`, `generateqrqa`, `manufactureqa`, `pbatchqa`, `productqa`, `returnstockqa`, `stockqa`, `usermqa`, `sconditionqa`, `name`, `approval`, `reports`, `subuser`, `stockconversion`, `stockdiscard`) VALUES (36, 'demoadmin', '1234', '', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', NULL, NULL, '', 'create,read,preview,print', '', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', '', '', 'create,read,edit,delete', '', 'create,read,edit,delete', 'Admin', '36', '36', '36', '36', '36', '36', '36', '36', '36', '36', '36', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Demo Admin', 'Show', 'Show', '', 'create,read,delete', 'create,read,delete'), (37, 'qa-neha', 'qalopl#1', '', 'read', '', 'read', 'read', 'read', NULL, NULL, '', 'read,preview', '', 'read', 'read', 'read', '', '', 'read', '', '', 'Quality Assurance', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', '', NULL, 'QA Neha', 'Show', 'Show', '', NULL, NULL), (38, 'office-mukesh', 'officelopl#1', '', 'create,read', 'create,read', 'create,read', 'create,read', 'create,read', NULL, NULL, '', 'read,preview', '', 'create,read', 'create,read', 'create,read', '', '', 'create,read', '38', '', 'Administration', '36', '36', '36', '36', '36', '36', '36', '36', '36', '', '36', '38', '38', '38', '38', '38', '38', '38', '38', '', '38', '37', '37', '37', '37', '37', '37', '37', '37', '37', '', '37', 'OFFICE Mukesh', 'Show', 'Show', '', NULL, NULL), (39, 'user-faisal', 'userlopl#1', '', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', NULL, NULL, '', 'create,read,preview,print', '', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', '', '', 'create,read,edit,delete', '', '', 'User', '', '', '', '', '', '', '', '', '', '', '', '', '38', '38', '', '', '', '38', '', '', '', '37', '', '', '37', '37', '37', '37', '', '', '', '37', 'USER Faisal', 'Show', 'Show', '', NULL, NULL), (44, 'testuser', '1234', '', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', NULL, NULL, '', 'create,read,preview,print', '', 'create,read,edit,delete', 'create,read,edit,delete', 'create,read,edit,delete', '', '', 'create,read,edit,delete', '', 'create,read,edit,delete', 'Admin', '44', '44', '44', '44', '44', '44', '44', '44', '44', '44', '44', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'testuser', 'Show', 'Show', '', 'create,read', 'create,read'); /*!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: ~0 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 */;