/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.16-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: weblinkltd_currentpos
-- ------------------------------------------------------
-- Server version	10.11.16-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `accounts`
--

DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `accounts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_no` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `initial_balance` double DEFAULT NULL,
  `total_balance` double NOT NULL,
  `note` text DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `accounts`
--

LOCK TABLES `accounts` WRITE;
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
INSERT INTO `accounts` VALUES
(1,'11111','Sales Accounts',1000,1000,'this is first account',1,1,'2018-12-18 02:58:02','2024-03-12 07:57:50'),
(3,'21211','Sa',NULL,0,NULL,0,1,'2018-12-18 02:58:56','2019-01-20 09:59:06'),
(5,'bank-1','zuhair',100000,100000,NULL,NULL,1,'2022-11-28 05:58:18','2022-11-28 05:58:18');
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `adjustments`
--

DROP TABLE IF EXISTS `adjustments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `adjustments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(191) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `document` varchar(191) DEFAULT NULL,
  `total_qty` double NOT NULL,
  `item` int(11) NOT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `adjustments`
--

LOCK TABLES `adjustments` WRITE;
/*!40000 ALTER TABLE `adjustments` DISABLE KEYS */;
INSERT INTO `adjustments` VALUES
(3,'adr-20240710-020412',1,'download (1).jpg',2,1,'RANGE AND CHARGING OF THE FIRST FULLY ELECTRIC BMW iX1.','2024-07-10 18:04:12','2024-07-10 18:04:47');
/*!40000 ALTER TABLE `adjustments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attendances`
--

DROP TABLE IF EXISTS `attendances`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `attendances` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `employee_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `checkin` varchar(191) DEFAULT NULL,
  `checkout` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `date` (`date`),
  UNIQUE KEY `employee_id` (`employee_id`),
  UNIQUE KEY `checkin` (`checkin`),
  UNIQUE KEY `attendances_date_employee_id_checkin_unique` (`date`,`employee_id`,`checkin`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attendances`
--

LOCK TABLES `attendances` WRITE;
/*!40000 ALTER TABLE `attendances` DISABLE KEYS */;
INSERT INTO `attendances` VALUES
(1,'2024-07-10',1,1,'10:00am','6:00pm',1,'Yes','2024-07-10 18:32:14','2024-07-10 18:32:14');
/*!40000 ALTER TABLE `attendances` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `billers`
--

DROP TABLE IF EXISTS `billers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `billers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `company_name` varchar(191) NOT NULL,
  `vat_number` varchar(191) DEFAULT NULL,
  `email` varchar(191) NOT NULL,
  `phone_number` varchar(191) NOT NULL,
  `address` varchar(191) NOT NULL,
  `city` varchar(191) NOT NULL,
  `state` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `billers`
--

LOCK TABLES `billers` WRITE;
/*!40000 ALTER TABLE `billers` DISABLE KEYS */;
INSERT INTO `billers` VALUES
(1,'John Watson',NULL,'The solution',NULL,'john@gmail.com','312313','36 housing road','london',NULL,NULL,'England',1,'2024-01-19 13:30:23','2024-01-19 13:30:23');
/*!40000 ALTER TABLE `billers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `brands`
--

DROP TABLE IF EXISTS `brands`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `brands` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `brands`
--

LOCK TABLES `brands` WRITE;
/*!40000 ALTER TABLE `brands` DISABLE KEYS */;
INSERT INTO `brands` VALUES
(1,'Apple','20240114102326.png',1,'2024-01-08 05:25:12','2024-01-14 16:23:26'),
(2,'Samsung','20240114102343.png',1,'2024-01-08 05:25:12','2024-01-14 16:23:43'),
(3,'Huawei','20240114102512.png',1,'2024-01-08 05:25:12','2024-01-14 16:25:12'),
(4,'Xiaomi','20240114103640.png',1,'2024-01-08 05:25:12','2024-01-14 16:36:40'),
(5,'Whirlpool','20240114103701.png',1,'2024-01-08 05:25:12','2024-01-14 16:37:01'),
(6,'Nestle','20240114103717.png',1,'2024-01-08 05:25:12','2024-01-14 16:37:17'),
(7,'Kraft','20240114103851.png',1,'2024-01-08 05:25:12','2024-01-14 16:38:51'),
(8,'Kellogs','20240114103906.png',1,'2024-01-08 05:25:12','2024-01-14 16:39:06'),
(9,'Unilever','20240114103928.png',1,'2024-01-08 05:25:12','2024-01-14 16:39:28'),
(10,'LG','20240114103943.png',1,'2024-01-08 05:25:12','2024-01-14 16:39:43'),
(11,'Haier','20240114102407.png',1,'2024-01-08 05:25:12','2024-01-14 16:24:07'),
(12,'Bosch','20240114103618.png',1,'2024-01-08 05:25:12','2024-01-14 16:36:18'),
(13,'Siemens','20240114104008.png',1,'2024-01-08 05:25:12','2024-01-14 16:40:08'),
(14,'Philips','20240114104027.png',1,'2024-01-08 05:25:12','2024-01-14 16:40:27'),
(15,'Nike','20240114104052.png',1,'2024-01-08 05:25:12','2024-01-14 16:40:52'),
(16,'Adidas','20240114104112.png',1,'2024-01-08 05:25:12','2024-01-14 16:41:12'),
(17,'Canon','20240114034815.png',1,'2024-01-14 09:48:15','2024-01-14 09:48:15'),
(18,'Omega','20240119071354.jpg',1,'2024-01-19 13:13:54','2024-01-19 13:14:59'),
(19,'jhakanaka',NULL,1,'2024-04-29 12:28:31','2024-04-29 12:28:31'),
(20,'BMW',NULL,1,'2024-07-10 17:56:33','2024-07-10 17:56:33');
/*!40000 ALTER TABLE `brands` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cash_registers`
--

DROP TABLE IF EXISTS `cash_registers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `cash_registers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cash_in_hand` double NOT NULL,
  `user_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cash_registers`
--

LOCK TABLES `cash_registers` WRITE;
/*!40000 ALTER TABLE `cash_registers` DISABLE KEYS */;
INSERT INTO `cash_registers` VALUES
(1,100,1,2,1,'2024-01-19 14:46:52','2024-01-19 14:46:52'),
(2,150,1,1,1,'2024-01-19 14:47:08','2024-01-19 14:47:08');
/*!40000 ALTER TABLE `cash_registers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories`
--

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES
(1,'Smartphone & Gadges',NULL,NULL,1,'2024-01-04 19:22:14','2024-01-08 06:22:02'),
(2,'Phone Accessories',NULL,1,1,'2024-01-04 19:22:14','2024-01-08 06:22:03'),
(3,'iPhone',NULL,1,1,'2024-01-04 19:22:14','2024-01-08 06:22:03'),
(4,'Samsung',NULL,1,1,'2024-01-04 19:22:14','2024-01-08 06:22:03'),
(5,'Phone Cases',NULL,1,1,'2024-01-04 19:22:15','2024-01-08 06:22:03'),
(6,'Laptops & Computers',NULL,NULL,1,'2024-01-04 19:22:15','2024-01-08 06:22:03'),
(7,'Keyboards',NULL,6,1,'2024-01-04 19:22:15','2024-01-08 06:22:03'),
(8,'Laptop Bags',NULL,6,1,'2024-01-04 19:22:15','2024-01-08 06:22:04'),
(9,'Mouses',NULL,6,1,'2024-01-04 19:22:15','2024-01-08 06:22:04'),
(10,'Webcams',NULL,6,1,'2024-01-04 19:22:15','2024-01-08 06:22:04'),
(11,'Monitors',NULL,6,1,'2024-01-04 19:22:15','2024-01-08 06:22:04'),
(12,'Smartwatches',NULL,NULL,1,'2024-01-04 19:22:15','2024-01-08 06:22:04'),
(13,'Sport Watches',NULL,12,1,'2024-01-04 19:22:15','2024-01-08 06:22:05'),
(14,'Kids Watches',NULL,12,1,'2024-01-04 19:22:15','2024-01-08 06:22:05'),
(15,'Women Watches',NULL,12,1,'2024-01-04 19:22:15','2024-01-08 06:22:05'),
(16,'Men Watches',NULL,12,1,'2024-01-04 19:22:15','2024-01-08 06:22:05'),
(17,'Appliances','20240117121109.png',NULL,1,'2024-01-04 19:22:15','2024-01-08 06:22:05'),
(18,'Dishwashers',NULL,17,1,'2024-01-04 19:22:15','2024-01-08 06:22:05'),
(19,'Dryers',NULL,17,1,'2024-01-04 19:22:15','2024-01-08 06:22:05'),
(20,'Washing machine',NULL,17,1,'2024-01-04 19:22:15','2024-01-08 06:22:05'),
(21,'Refrigerators',NULL,17,1,'2024-01-04 19:22:15','2024-01-08 06:22:05'),
(22,'Vacuum cleaners',NULL,17,1,'2024-01-04 19:22:15','2024-01-08 06:22:05'),
(23,'TVs, Audio & Video',NULL,NULL,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(24,'Television Accessories',NULL,23,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(25,'HD, DVD Players',NULL,23,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(26,'TV-DVD Combos',NULL,23,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(27,'Projectors',NULL,23,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(28,'Projection Screen',NULL,23,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(29,'Fruits & Vegetables',NULL,NULL,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(30,'Dairy & Egg',NULL,NULL,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(31,'Meat & Fish',NULL,NULL,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(32,'Sauces & Pickles',NULL,NULL,0,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(33,'Candy & Chocolates',NULL,NULL,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(34,'Foods',NULL,NULL,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(35,'Cooking',NULL,34,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(36,'Breakfast',NULL,34,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(37,'Beverages',NULL,34,1,'2024-01-04 19:22:16','2024-01-08 06:22:05'),
(38,'BackPack','20240119070653.jpg',NULL,1,NULL,NULL),
(40,'spices',NULL,NULL,1,'2024-04-29 12:28:15','2024-04-29 12:28:15'),
(42,'Bat','20240710012746.jpg',NULL,0,'2024-07-10 17:27:46','2024-07-10 17:51:06'),
(43,'vehicles','20240710015347.png',NULL,1,'2024-07-10 17:53:47','2024-07-10 17:53:47'),
(44,'Food',NULL,NULL,1,'2025-09-24 14:11:22','2025-09-24 14:11:22');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `coupons`
--

DROP TABLE IF EXISTS `coupons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `coupons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `amount` double NOT NULL,
  `minimum_amount` double DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `used` int(11) NOT NULL,
  `expired_date` date NOT NULL,
  `user_id` int(11) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `coupons`
--

LOCK TABLES `coupons` WRITE;
/*!40000 ALTER TABLE `coupons` DISABLE KEYS */;
/*!40000 ALTER TABLE `coupons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `couriers`
--

DROP TABLE IF EXISTS `couriers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `couriers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `phone_number` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `couriers`
--

LOCK TABLES `couriers` WRITE;
/*!40000 ALTER TABLE `couriers` DISABLE KEYS */;
INSERT INTO `couriers` VALUES
(1,'frido','019555555555','Banani , Dhaka',1,'2024-07-10 18:26:27','2024-07-10 18:26:27');
/*!40000 ALTER TABLE `couriers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `currencies`
--

DROP TABLE IF EXISTS `currencies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `currencies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `exchange_rate` double NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `currencies`
--

LOCK TABLES `currencies` WRITE;
/*!40000 ALTER TABLE `currencies` DISABLE KEYS */;
INSERT INTO `currencies` VALUES
(1,'US Dollar','USD',1,1,'2020-11-01 00:22:58','2023-04-02 09:51:28'),
(2,'Euro','Euro',0.95,1,'2020-11-01 01:29:12','2023-06-08 10:10:32'),
(3,'Bangladeshi Taka','BDT',110,0,'2023-09-06 07:05:29','2023-09-06 07:05:46');
/*!40000 ALTER TABLE `currencies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `custom_fields`
--

DROP TABLE IF EXISTS `custom_fields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `custom_fields` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `belongs_to` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `default_value` text DEFAULT NULL,
  `option_value` text DEFAULT NULL,
  `grid_value` int(11) NOT NULL,
  `is_table` tinyint(1) NOT NULL,
  `is_invoice` tinyint(1) NOT NULL,
  `is_required` tinyint(1) NOT NULL,
  `is_admin` tinyint(1) NOT NULL,
  `is_disable` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `custom_fields`
--

LOCK TABLES `custom_fields` WRITE;
/*!40000 ALTER TABLE `custom_fields` DISABLE KEYS */;
/*!40000 ALTER TABLE `custom_fields` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customer_groups`
--

DROP TABLE IF EXISTS `customer_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `percentage` varchar(191) NOT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer_groups`
--

LOCK TABLES `customer_groups` WRITE;
/*!40000 ALTER TABLE `customer_groups` DISABLE KEYS */;
INSERT INTO `customer_groups` VALUES
(1,'Regular','0',1,'2024-01-19 13:19:29','2024-01-19 13:19:29');
/*!40000 ALTER TABLE `customer_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customers`
--

DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `customers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_group_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `company_name` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `phone_number` varchar(191) NOT NULL,
  `tax_no` varchar(191) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `points` double DEFAULT NULL,
  `deposit` double DEFAULT NULL,
  `expense` double DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ecom` varchar(255) DEFAULT NULL,
  `dsf` varchar(255) DEFAULT 'df',
  `arabic_name` varchar(255) DEFAULT NULL,
  `admin` varchar(255) DEFAULT NULL,
  `franchise_location` varchar(255) DEFAULT NULL,
  `customer_type` varchar(255) DEFAULT 'Same as Customer',
  `customer_assigned_to` varchar(255) DEFAULT 'Advocate',
  `assigned` varchar(255) DEFAULT 'Advocate',
  `aaaaaaaa` varchar(255) DEFAULT 'aa',
  `district` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customers`
--

LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
INSERT INTO `customers` VALUES
(1,1,44,'James Bond','MI6','jamesbond@gmail.com','313131',NULL,'221 Baker Street','London',NULL,NULL,'England',26,NULL,NULL,1,'2024-01-19 13:23:29','2024-05-21 06:38:09',NULL,'df',NULL,NULL,NULL,'Same as Customer','Advocate','Advocate','aa',NULL),
(2,1,NULL,'Walk in Customer',NULL,'ashfaqdev.php@gmail.com','231313',NULL,'Halishahar','chittagong',NULL,NULL,'Bangladesh',2020,NULL,NULL,1,'2024-01-19 13:31:51','2025-09-24 14:08:29',NULL,'df',NULL,NULL,NULL,'Same as Customer','Advocate','Advocate','aa',NULL),
(3,1,NULL,'Frido',NULL,'Frido@gmail.com','01955555555',NULL,'Banani, Dhaka','Dhaka',NULL,NULL,NULL,264400,NULL,NULL,1,'2024-07-10 18:23:07','2024-07-10 18:24:16',NULL,'df',NULL,NULL,NULL,'Same as Customer','Advocate','Advocate','aa',NULL);
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `deliveries`
--

DROP TABLE IF EXISTS `deliveries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `deliveries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(191) NOT NULL,
  `sale_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `courier_id` int(11) DEFAULT NULL,
  `address` text NOT NULL,
  `delivered_by` varchar(191) DEFAULT NULL,
  `recieved_by` varchar(191) DEFAULT NULL,
  `file` varchar(191) DEFAULT NULL,
  `note` varchar(191) DEFAULT NULL,
  `status` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `deliveries`
--

LOCK TABLES `deliveries` WRITE;
/*!40000 ALTER TABLE `deliveries` DISABLE KEYS */;
/*!40000 ALTER TABLE `deliveries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `departments`
--

DROP TABLE IF EXISTS `departments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `departments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `departments`
--

LOCK TABLES `departments` WRITE;
/*!40000 ALTER TABLE `departments` DISABLE KEYS */;
INSERT INTO `departments` VALUES
(1,'IT',1,'2024-07-10 18:30:01','2024-07-10 18:30:01');
/*!40000 ALTER TABLE `departments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `deposits`
--

DROP TABLE IF EXISTS `deposits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `deposits` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `customer_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `deposits`
--

LOCK TABLES `deposits` WRITE;
/*!40000 ALTER TABLE `deposits` DISABLE KEYS */;
/*!40000 ALTER TABLE `deposits` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discount_plan_customers`
--

DROP TABLE IF EXISTS `discount_plan_customers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `discount_plan_customers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `discount_plan_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discount_plan_customers`
--

LOCK TABLES `discount_plan_customers` WRITE;
/*!40000 ALTER TABLE `discount_plan_customers` DISABLE KEYS */;
/*!40000 ALTER TABLE `discount_plan_customers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discount_plan_discounts`
--

DROP TABLE IF EXISTS `discount_plan_discounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `discount_plan_discounts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `discount_id` int(11) NOT NULL,
  `discount_plan_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discount_plan_discounts`
--

LOCK TABLES `discount_plan_discounts` WRITE;
/*!40000 ALTER TABLE `discount_plan_discounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `discount_plan_discounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discount_plans`
--

DROP TABLE IF EXISTS `discount_plans`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `discount_plans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discount_plans`
--

LOCK TABLES `discount_plans` WRITE;
/*!40000 ALTER TABLE `discount_plans` DISABLE KEYS */;
/*!40000 ALTER TABLE `discount_plans` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discounts`
--

DROP TABLE IF EXISTS `discounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `discounts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `applicable_for` varchar(191) NOT NULL,
  `product_list` longtext DEFAULT NULL,
  `valid_from` date NOT NULL,
  `valid_till` date NOT NULL,
  `type` varchar(191) NOT NULL,
  `value` double NOT NULL,
  `minimum_qty` double NOT NULL,
  `maximum_qty` double NOT NULL,
  `days` varchar(191) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discounts`
--

LOCK TABLES `discounts` WRITE;
/*!40000 ALTER TABLE `discounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `discounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dso_alerts`
--

DROP TABLE IF EXISTS `dso_alerts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `dso_alerts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_info` longtext NOT NULL,
  `number_of_products` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dso_alerts`
--

LOCK TABLES `dso_alerts` WRITE;
/*!40000 ALTER TABLE `dso_alerts` DISABLE KEYS */;
/*!40000 ALTER TABLE `dso_alerts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employees`
--

DROP TABLE IF EXISTS `employees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `employees` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone_number` varchar(191) NOT NULL,
  `department_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `staff_id` varchar(191) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employees`
--

LOCK TABLES `employees` WRITE;
/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
INSERT INTO `employees` VALUES
(1,'Frido Fight','frido@gmail.com','019555555555',1,45,'001','20240710023138.jpg','Banani , Dhaka','Dhaka','Bangladesh',1,'2024-07-10 18:31:38','2024-07-10 18:31:38');
/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expense_categories`
--

DROP TABLE IF EXISTS `expense_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `expense_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expense_categories`
--

LOCK TABLES `expense_categories` WRITE;
/*!40000 ALTER TABLE `expense_categories` DISABLE KEYS */;
INSERT INTO `expense_categories` VALUES
(1,'Electric Bill','Electric Bill',1,'2024-01-19 14:50:02','2024-01-19 14:50:02');
/*!40000 ALTER TABLE `expense_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expenses`
--

DROP TABLE IF EXISTS `expenses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `expenses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(191) NOT NULL,
  `expense_category_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `cash_register_id` int(11) DEFAULT NULL,
  `amount` double NOT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expenses`
--

LOCK TABLES `expenses` WRITE;
/*!40000 ALTER TABLE `expenses` DISABLE KEYS */;
INSERT INTO `expenses` VALUES
(1,'er-20240119-085023',1,1,1,1,2,200,NULL,'2024-01-19 14:50:23','2024-01-19 14:50:23'),
(2,'er-20240119-085046',1,2,1,1,1,120,NULL,'2024-01-19 14:50:46','2024-01-19 14:50:46');
/*!40000 ALTER TABLE `expenses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `external_services`
--

DROP TABLE IF EXISTS `external_services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `external_services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `active` int(11) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `external_services`
--

LOCK TABLES `external_services` WRITE;
/*!40000 ALTER TABLE `external_services` DISABLE KEYS */;
INSERT INTO `external_services` VALUES
(1,'PayPal','payment','Client ID,Client Secret;abcd1234,wxyz5678',1,NULL,NULL),
(2,'Stripe','payment','Public Key,Private Key;efgh1234,stuv5678',1,NULL,NULL);
/*!40000 ALTER TABLE `external_services` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `general_settings`
--

DROP TABLE IF EXISTS `general_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `general_settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `site_title` varchar(191) NOT NULL,
  `site_logo` varchar(191) DEFAULT NULL,
  `is_rtl` tinyint(1) DEFAULT NULL,
  `currency` varchar(191) NOT NULL,
  `package_id` int(11) DEFAULT NULL,
  `subscription_type` varchar(255) DEFAULT NULL,
  `staff_access` varchar(191) NOT NULL,
  `without_stock` varchar(255) NOT NULL DEFAULT 'no',
  `date_format` varchar(191) NOT NULL,
  `developed_by` varchar(191) DEFAULT NULL,
  `invoice_format` varchar(191) DEFAULT NULL,
  `decimal` int(11) DEFAULT 2,
  `state` int(11) DEFAULT NULL,
  `theme` varchar(191) NOT NULL,
  `modules` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `currency_position` varchar(191) NOT NULL,
  `expiry_date` date DEFAULT NULL,
  `is_zatca` tinyint(1) DEFAULT NULL,
  `company_name` varchar(191) DEFAULT NULL,
  `vat_registration_number` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `general_settings`
--

LOCK TABLES `general_settings` WRITE;
/*!40000 ALTER TABLE `general_settings` DISABLE KEYS */;
INSERT INTO `general_settings` VALUES
(1,'Enrich POS','20250924080223.png',0,'1',NULL,NULL,'all','yes','d-m-Y','Enrich Coder LLC','standard',2,1,'default.css',NULL,'2018-07-06 06:13:11','2025-09-24 14:02:23','prefix',NULL,0,'Enrich Coder LLC','98098007');
/*!40000 ALTER TABLE `general_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gift_card_recharges`
--

DROP TABLE IF EXISTS `gift_card_recharges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `gift_card_recharges` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gift_card_id` int(11) NOT NULL,
  `amount` double NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gift_card_recharges`
--

LOCK TABLES `gift_card_recharges` WRITE;
/*!40000 ALTER TABLE `gift_card_recharges` DISABLE KEYS */;
/*!40000 ALTER TABLE `gift_card_recharges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `gift_cards`
--

DROP TABLE IF EXISTS `gift_cards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `gift_cards` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `card_no` varchar(191) NOT NULL,
  `amount` double NOT NULL,
  `expense` double NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `expired_date` date DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `gift_cards`
--

LOCK TABLES `gift_cards` WRITE;
/*!40000 ALTER TABLE `gift_cards` DISABLE KEYS */;
/*!40000 ALTER TABLE `gift_cards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `holidays`
--

DROP TABLE IF EXISTS `holidays`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `holidays` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `note` text DEFAULT NULL,
  `is_approved` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `holidays`
--

LOCK TABLES `holidays` WRITE;
/*!40000 ALTER TABLE `holidays` DISABLE KEYS */;
INSERT INTO `holidays` VALUES
(1,1,'2024-07-11','2024-07-10','holiday',1,'2024-07-10 18:33:17','2024-07-10 18:33:17');
/*!40000 ALTER TABLE `holidays` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hrm_settings`
--

DROP TABLE IF EXISTS `hrm_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `hrm_settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `checkin` varchar(191) NOT NULL,
  `checkout` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hrm_settings`
--

LOCK TABLES `hrm_settings` WRITE;
/*!40000 ALTER TABLE `hrm_settings` DISABLE KEYS */;
INSERT INTO `hrm_settings` VALUES
(1,'10:00am','6:00pm','2019-01-02 02:20:08','2019-01-02 04:20:53');
/*!40000 ALTER TABLE `hrm_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `languages`
--

DROP TABLE IF EXISTS `languages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `languages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `languages`
--

LOCK TABLES `languages` WRITE;
/*!40000 ALTER TABLE `languages` DISABLE KEYS */;
INSERT INTO `languages` VALUES
(1,'en','2018-07-07 22:59:17','2019-12-24 17:34:20');
/*!40000 ALTER TABLE `languages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mail_settings`
--

DROP TABLE IF EXISTS `mail_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `mail_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `driver` varchar(191) NOT NULL,
  `host` varchar(191) NOT NULL,
  `port` varchar(191) NOT NULL,
  `from_address` varchar(191) NOT NULL,
  `from_name` varchar(191) NOT NULL,
  `username` varchar(191) NOT NULL,
  `password` varchar(191) NOT NULL,
  `encryption` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mail_settings`
--

LOCK TABLES `mail_settings` WRITE;
/*!40000 ALTER TABLE `mail_settings` DISABLE KEYS */;
INSERT INTO `mail_settings` VALUES
(1,'smtp','smtp.gmail.com','587','your_mail_address','your_mail_name','your_mail_username','1234','tls','2024-01-08 05:32:23','2024-01-08 05:32:23');
/*!40000 ALTER TABLE `mail_settings` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=232 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES
(1,'2014_10_12_000000_create_users_table',1),
(2,'2014_10_12_100000_create_password_resets_table',1),
(3,'2018_02_17_060412_create_categories_table',1),
(4,'2018_02_20_035727_create_brands_table',1),
(5,'2018_02_25_100635_create_suppliers_table',1),
(6,'2018_02_27_101619_create_warehouse_table',1),
(7,'2018_03_03_040448_create_units_table',1),
(8,'2018_03_04_041317_create_taxes_table',1),
(9,'2018_03_10_061915_create_customer_groups_table',1),
(10,'2018_03_10_090534_create_customers_table',1),
(11,'2018_03_11_095547_create_billers_table',1),
(12,'2018_04_05_054401_create_products_table',1),
(13,'2018_04_06_133606_create_purchases_table',1),
(14,'2018_04_06_154600_create_product_purchases_table',1),
(15,'2018_04_06_154915_create_product_warhouse_table',1),
(16,'2018_04_10_085927_create_sales_table',1),
(17,'2018_04_10_090133_create_product_sales_table',1),
(18,'2018_04_10_090254_create_payments_table',1),
(19,'2018_04_10_090341_create_payment_with_cheque_table',1),
(20,'2018_04_10_090509_create_payment_with_credit_card_table',1),
(21,'2018_04_13_121436_create_quotation_table',1),
(22,'2018_04_13_122324_create_product_quotation_table',1),
(23,'2018_04_14_121802_create_transfers_table',1),
(24,'2018_04_14_121913_create_product_transfer_table',1),
(25,'2018_05_13_082847_add_payment_id_and_change_sale_id_to_payments_table',2),
(26,'2018_05_13_090906_change_customer_id_to_payment_with_credit_card_table',3),
(27,'2018_05_20_054532_create_adjustments_table',4),
(28,'2018_05_20_054859_create_product_adjustments_table',4),
(29,'2018_05_21_163419_create_returns_table',5),
(30,'2018_05_21_163443_create_product_returns_table',5),
(31,'2018_06_02_050905_create_roles_table',6),
(32,'2018_06_02_073430_add_columns_to_users_table',7),
(33,'2018_06_03_053738_create_permission_tables',8),
(36,'2018_06_21_063736_create_pos_setting_table',9),
(37,'2018_06_21_094155_add_user_id_to_sales_table',10),
(38,'2018_06_21_101529_add_user_id_to_purchases_table',11),
(39,'2018_06_21_103512_add_user_id_to_transfers_table',12),
(40,'2018_06_23_061058_add_user_id_to_quotations_table',13),
(41,'2018_06_23_082427_add_is_deleted_to_users_table',14),
(42,'2018_06_25_043308_change_email_to_users_table',15),
(43,'2018_07_06_115449_create_general_settings_table',16),
(44,'2018_07_08_043944_create_languages_table',17),
(45,'2018_07_11_102144_add_user_id_to_returns_table',18),
(46,'2018_07_11_102334_add_user_id_to_payments_table',18),
(47,'2018_07_22_130541_add_digital_to_products_table',19),
(49,'2018_07_24_154250_create_deliveries_table',20),
(50,'2018_08_16_053336_create_expense_categories_table',21),
(51,'2018_08_17_115415_create_expenses_table',22),
(55,'2018_08_18_050418_create_gift_cards_table',23),
(56,'2018_08_19_063119_create_payment_with_gift_card_table',24),
(57,'2018_08_25_042333_create_gift_card_recharges_table',25),
(58,'2018_08_25_101354_add_deposit_expense_to_customers_table',26),
(59,'2018_08_26_043801_create_deposits_table',27),
(60,'2018_09_02_044042_add_keybord_active_to_pos_setting_table',28),
(61,'2018_09_09_092713_create_payment_with_paypal_table',29),
(62,'2018_09_10_051254_add_currency_to_general_settings_table',30),
(63,'2018_10_22_084118_add_biller_and_store_id_to_users_table',31),
(65,'2018_10_26_034927_create_coupons_table',32),
(66,'2018_10_27_090857_add_coupon_to_sales_table',33),
(67,'2018_11_07_070155_add_currency_position_to_general_settings_table',34),
(68,'2018_11_19_094650_add_combo_to_products_table',35),
(69,'2018_12_09_043712_create_accounts_table',36),
(70,'2018_12_17_112253_add_is_default_to_accounts_table',37),
(71,'2018_12_19_103941_add_account_id_to_payments_table',38),
(72,'2018_12_20_065900_add_account_id_to_expenses_table',39),
(73,'2018_12_20_082753_add_account_id_to_returns_table',40),
(74,'2018_12_26_064330_create_return_purchases_table',41),
(75,'2018_12_26_144210_create_purchase_product_return_table',42),
(76,'2018_12_26_144708_create_purchase_product_return_table',43),
(77,'2018_12_27_110018_create_departments_table',44),
(78,'2018_12_30_054844_create_employees_table',45),
(79,'2018_12_31_125210_create_payrolls_table',46),
(80,'2018_12_31_150446_add_department_id_to_employees_table',47),
(81,'2019_01_01_062708_add_user_id_to_expenses_table',48),
(82,'2019_01_02_075644_create_hrm_settings_table',49),
(83,'2019_01_02_090334_create_attendances_table',50),
(84,'2019_01_27_160956_add_three_columns_to_general_settings_table',51),
(85,'2019_02_15_183303_create_stock_counts_table',52),
(86,'2019_02_17_101604_add_is_adjusted_to_stock_counts_table',53),
(87,'2019_04_13_101707_add_tax_no_to_customers_table',54),
(89,'2019_10_14_111455_create_holidays_table',55),
(90,'2019_11_13_145619_add_is_variant_to_products_table',56),
(91,'2019_11_13_150206_create_product_variants_table',57),
(92,'2019_11_13_153828_create_variants_table',57),
(93,'2019_11_25_134041_add_qty_to_product_variants_table',58),
(94,'2019_11_25_134922_add_variant_id_to_product_purchases_table',58),
(95,'2019_11_25_145341_add_variant_id_to_product_warehouse_table',58),
(96,'2019_11_29_182201_add_variant_id_to_product_sales_table',59),
(97,'2019_12_04_121311_add_variant_id_to_product_quotation_table',60),
(98,'2019_12_05_123802_add_variant_id_to_product_transfer_table',61),
(100,'2019_12_08_114954_add_variant_id_to_product_returns_table',62),
(101,'2019_12_08_203146_add_variant_id_to_purchase_product_return_table',63),
(102,'2020_02_28_103340_create_money_transfers_table',64),
(103,'2020_07_01_193151_add_image_to_categories_table',65),
(105,'2020_09_26_130426_add_user_id_to_deliveries_table',66),
(107,'2020_10_11_125457_create_cash_registers_table',67),
(108,'2020_10_13_155019_add_cash_register_id_to_sales_table',68),
(109,'2020_10_13_172624_add_cash_register_id_to_returns_table',69),
(110,'2020_10_17_212338_add_cash_register_id_to_payments_table',70),
(111,'2020_10_18_124200_add_cash_register_id_to_expenses_table',71),
(112,'2020_10_21_121632_add_developed_by_to_general_settings_table',72),
(113,'2019_08_19_000000_create_failed_jobs_table',73),
(114,'2020_10_30_135557_create_notifications_table',73),
(115,'2020_11_01_044954_create_currencies_table',74),
(116,'2020_11_01_140736_add_price_to_product_warehouse_table',75),
(117,'2020_11_02_050633_add_is_diff_price_to_products_table',76),
(118,'2020_11_09_055222_add_user_id_to_customers_table',77),
(119,'2020_11_17_054806_add_invoice_format_to_general_settings_table',78),
(120,'2021_02_10_074859_add_variant_id_to_product_adjustments_table',79),
(121,'2021_03_07_093606_create_product_batches_table',80),
(122,'2021_03_07_093759_add_product_batch_id_to_product_warehouse_table',80),
(123,'2021_03_07_093900_add_product_batch_id_to_product_purchases_table',80),
(124,'2021_03_11_132603_add_product_batch_id_to_product_sales_table',81),
(127,'2021_03_25_125421_add_is_batch_to_products_table',82),
(128,'2021_05_19_120127_add_product_batch_id_to_product_returns_table',82),
(130,'2021_05_22_105611_add_product_batch_id_to_purchase_product_return_table',83),
(131,'2021_05_23_124848_add_product_batch_id_to_product_transfer_table',84),
(132,'2021_05_26_153106_add_product_batch_id_to_product_quotation_table',85),
(133,'2021_06_08_213007_create_reward_point_settings_table',86),
(134,'2021_06_16_104155_add_points_to_customers_table',87),
(135,'2021_06_17_101057_add_used_points_to_payments_table',88),
(136,'2021_07_06_132716_add_variant_list_to_products_table',89),
(137,'2021_09_27_161141_add_is_imei_to_products_table',90),
(138,'2021_09_28_170052_add_imei_number_to_product_warehouse_table',91),
(139,'2021_09_28_170126_add_imei_number_to_product_purchases_table',91),
(140,'2021_10_03_170652_add_imei_number_to_product_sales_table',92),
(141,'2021_10_10_145214_add_imei_number_to_product_returns_table',93),
(142,'2021_10_11_104504_add_imei_number_to_product_transfer_table',94),
(143,'2021_10_12_160107_add_imei_number_to_purchase_product_return_table',95),
(144,'2021_10_12_205146_add_is_rtl_to_general_settings_table',96),
(145,'2021_10_23_142451_add_is_approve_to_payments_table',97),
(146,'2022_01_13_191242_create_discount_plans_table',97),
(147,'2022_01_14_174318_create_discount_plan_customers_table',97),
(148,'2022_01_14_202439_create_discounts_table',98),
(149,'2022_01_16_153506_create_discount_plan_discounts_table',98),
(150,'2022_02_05_174210_add_order_discount_type_and_value_to_sales_table',99),
(154,'2022_05_26_195506_add_daily_sale_objective_to_products_table',100),
(155,'2022_05_28_104209_create_dso_alerts_table',101),
(156,'2022_06_01_112100_add_is_embeded_to_products_table',102),
(157,'2022_06_14_130505_add_sale_id_to_returns_table',103),
(159,'2022_07_19_115504_add_variant_data_to_products_table',104),
(160,'2022_07_25_194300_add_additional_cost_to_product_variants_table',104),
(161,'2022_09_04_195610_add_purchase_id_to_return_purchases_table',105),
(162,'2023_01_18_123842_alter_table_pos_setting',106),
(164,'2023_01_18_125040_alter_table_general_settings',107),
(165,'2023_01_18_133701_alter_table_pos_setting',108),
(166,'2023_01_25_145309_add_expiry_date_to_general_settings_table',109),
(167,'2023_02_23_125656_alter_table_sales',110),
(168,'2023_02_26_124100_add_package_id_to_general_settings_table',111),
(169,'2023_03_04_120325_create_custom_fields_table',111),
(170,'2023_03_22_174352_add_currency_id_and_exchange_rate_to_returns_table',112),
(171,'2023_03_27_114320_add_currency_id_and_exchange_rate_to_purchases_table',113),
(172,'2023_03_27_132747_add_currency_id_and_exchange_rate_to_return_purchases_table',114),
(173,'2023_04_25_150236_create_mail_settings_table',115),
(174,'2023_05_13_125424_add_zatca_to_general_settings_table',116),
(175,'2023_05_28_155540_create_tables_table',117),
(176,'2023_05_29_115039_add_is_table_to_pos_setting_table',117),
(177,'2023_05_29_115301_add_table_id_to_sales_table',117),
(178,'2023_05_31_165049_add_queue_no_to_sales_table',117),
(190,'2023_08_12_124016_add_staff_id_to_employees_table',121),
(192,'2023_07_23_160254_create_couriers_table',122),
(193,'2023_07_23_174343_add_courier_id_to_deliveries_table',122),
(194,'2023_08_14_142608_add_is_active_to_currencies_table',122),
(195,'2023_08_24_130203_change_columns_to_attendances_table',122),
(196,'2023_09_10_134503_add_without_stock_to_general_settings_table',123),
(204,'2023_09_26_211542_add_modules_to_general_settings_table',125),
(217,'2023_10_15_124306_add_return_qty_to_product_sales_table',129),
(219,'2023_12_03_235606_crete_external_services_table',131),
(221,'2023_03_14_174658_add_subscription_type_to_general_setting_table',130),
(222,'2024_02_04_131826_add_unit_cost_to_product_adjustments_table',132),
(223,'2024_02_13_173126_change_modules_to_general_settings_table',133),
(224,'2024_05_02_114215_add_payment_receiver_to_payments',134),
(225,'2024_05_06_132553_create_sms_templates_table',135),
(226,'2024_05_07_102225_add_send_sms_to_pos_setting_table',135),
(227,'2024_05_07_132625_add_is_default_to_sms_templates_table',135),
(228,'2024_05_08_112211_change_address_and_city_field_to_nullable_in_customers_table',135),
(229,'2024_05_08_151050_add_is_default_ecommerce_columne_to_sms_templates_table',135),
(230,'2024_05_20_182757_add_wholesale_price_to_products_table',136),
(231,'2024_05_21_170500_add_is_sent_to_transfers_table',137);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `money_transfers`
--

DROP TABLE IF EXISTS `money_transfers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `money_transfers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(191) NOT NULL,
  `from_account_id` int(11) NOT NULL,
  `to_account_id` int(11) NOT NULL,
  `amount` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `money_transfers`
--

LOCK TABLES `money_transfers` WRITE;
/*!40000 ALTER TABLE `money_transfers` DISABLE KEYS */;
/*!40000 ALTER TABLE `money_transfers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notifications`
--

DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(191) NOT NULL,
  `notifiable_type` varchar(191) NOT NULL,
  `notifiable_id` bigint(20) unsigned NOT NULL,
  `data` text NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notifications`
--

LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
INSERT INTO `password_resets` VALUES
('ashfaqdev.php@gmail.com','$2y$10$plxHOMxChJlHd9t6FQkoN.4dXMdtZ9fE5tXBBItzjxB1R5JF9OpbO','2023-07-15 11:31:30');
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment_with_cheque`
--

DROP TABLE IF EXISTS `payment_with_cheque`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment_with_cheque` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payment_id` int(11) NOT NULL,
  `cheque_no` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_with_cheque`
--

LOCK TABLES `payment_with_cheque` WRITE;
/*!40000 ALTER TABLE `payment_with_cheque` DISABLE KEYS */;
/*!40000 ALTER TABLE `payment_with_cheque` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment_with_credit_card`
--

DROP TABLE IF EXISTS `payment_with_credit_card`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment_with_credit_card` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payment_id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `customer_stripe_id` varchar(191) DEFAULT NULL,
  `charge_id` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_with_credit_card`
--

LOCK TABLES `payment_with_credit_card` WRITE;
/*!40000 ALTER TABLE `payment_with_credit_card` DISABLE KEYS */;
/*!40000 ALTER TABLE `payment_with_credit_card` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment_with_gift_card`
--

DROP TABLE IF EXISTS `payment_with_gift_card`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment_with_gift_card` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payment_id` int(11) NOT NULL,
  `gift_card_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_with_gift_card`
--

LOCK TABLES `payment_with_gift_card` WRITE;
/*!40000 ALTER TABLE `payment_with_gift_card` DISABLE KEYS */;
/*!40000 ALTER TABLE `payment_with_gift_card` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payment_with_paypal`
--

DROP TABLE IF EXISTS `payment_with_paypal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payment_with_paypal` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payment_id` int(11) NOT NULL,
  `transaction_id` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payment_with_paypal`
--

LOCK TABLES `payment_with_paypal` WRITE;
/*!40000 ALTER TABLE `payment_with_paypal` DISABLE KEYS */;
/*!40000 ALTER TABLE `payment_with_paypal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payments`
--

DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `payment_reference` varchar(191) NOT NULL,
  `user_id` int(11) NOT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `sale_id` int(11) DEFAULT NULL,
  `cash_register_id` int(11) DEFAULT NULL,
  `account_id` int(11) NOT NULL,
  `payment_receiver` varchar(255) DEFAULT NULL,
  `amount` double NOT NULL,
  `used_points` double DEFAULT NULL,
  `change` double NOT NULL,
  `paying_method` varchar(191) NOT NULL,
  `payment_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payments`
--

LOCK TABLES `payments` WRITE;
/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
INSERT INTO `payments` VALUES
(1,'spr-20240119-084017',1,NULL,1,NULL,1,NULL,1758,NULL,0,'Cash',NULL,'2024-01-19 14:40:17','2024-01-19 14:40:17'),
(2,'spr-20240119-084441',1,NULL,2,NULL,1,NULL,3017,NULL,0,'Cash',NULL,'2024-01-19 14:44:41','2024-01-19 14:44:41'),
(3,'spr-20240210-122224',1,NULL,5,2,1,NULL,1259,NULL,0,'Cash',NULL,'2024-02-10 06:22:24','2024-02-10 06:22:24'),
(4,'spr-20240225-014951',1,NULL,6,2,1,NULL,1299.99,NULL,0,'Credit Card',NULL,'2024-02-25 07:49:51','2024-02-25 07:49:51'),
(5,'spr-20240225-015013',1,NULL,7,2,1,NULL,2599.98,NULL,0,'Cash',NULL,'2024-02-25 07:50:13','2024-02-25 07:50:13'),
(6,'spr-20240228-112744',1,NULL,8,2,1,NULL,2558.99,NULL,0,'Cash',NULL,'2024-02-28 05:27:44','2024-02-28 05:27:44'),
(7,'spr-20240421-110143',1,NULL,9,2,1,NULL,350,NULL,0,'Cash',NULL,'2024-04-21 05:01:43','2024-04-21 05:01:43'),
(8,'spr-20240428-121544',1,NULL,13,2,1,NULL,1409,NULL,0,'Cash',NULL,'2024-04-28 06:15:44','2024-04-28 06:15:44'),
(9,'spr-20240429-062956',1,NULL,14,2,1,NULL,3800.99,NULL,0,'Cash',NULL,'2024-04-29 12:29:56','2024-04-29 12:29:56'),
(12,'spr-20240505-052905',1,NULL,20,2,1,NULL,2549.99,NULL,0,'Cash',NULL,'2024-05-05 11:29:05','2024-05-05 11:29:05'),
(13,'spr-20240508-020851',1,NULL,22,2,1,NULL,1349.99,NULL,0,'Cash',NULL,'2024-05-08 08:08:51','2024-05-08 08:08:51'),
(14,'spr-20240519-022423',1,NULL,23,2,1,NULL,1299.99,NULL,0,'Cash',NULL,'2024-05-19 08:24:23','2024-05-19 08:24:23'),
(15,'spr-20240519-022530',1,NULL,24,2,1,NULL,1300,NULL,0,'Cash',NULL,'2024-05-19 08:25:30','2024-05-19 08:25:30'),
(16,'spr-20240519-023055',1,NULL,25,2,1,NULL,1300,NULL,0,'Cash',NULL,'2024-05-19 08:30:55','2024-05-19 08:30:55'),
(18,'spr-20240521-013249',1,NULL,28,2,1,NULL,1050,NULL,0,'Cash',NULL,'2024-05-21 07:32:49','2024-05-21 07:32:49'),
(19,'ppr-20240710-020112',1,10,NULL,NULL,0,NULL,72252000,NULL,0,'Cash',NULL,'2024-07-10 18:01:12','2024-07-10 18:01:12'),
(20,'ppr-20240710-020112',1,11,NULL,NULL,0,NULL,72252000,NULL,0,'Cash',NULL,'2024-07-10 18:01:12','2024-07-10 18:01:12'),
(21,'spr-20240710-022416',1,NULL,29,2,1,'79320015.60',79320015.6,NULL,0,'Credit Card','done','2024-07-10 18:24:16','2024-07-10 18:24:16'),
(22,'spr-20250923-125510',1,NULL,30,2,1,NULL,1850.99,NULL,0,'Cash',NULL,'2025-09-23 06:55:10','2025-09-23 06:55:10'),
(23,'spr-20250924-075343',1,NULL,32,2,1,'00001234',6102.9,NULL,0,'Cash','Test','2025-09-24 13:53:43','2025-09-24 13:53:43'),
(24,'spr-20250924-080654',1,NULL,33,2,1,'000012340',16867.85,NULL,0,'Cash','16897','2025-09-24 14:06:54','2025-09-24 14:06:54'),
(25,'spr-20250924-080829',1,NULL,34,2,1,'0000123400',547000,NULL,0,'Cash',NULL,'2025-09-24 14:08:29','2025-09-24 14:08:29');
/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payrolls`
--

DROP TABLE IF EXISTS `payrolls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payrolls` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(191) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `amount` double NOT NULL,
  `paying_method` varchar(191) NOT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payrolls`
--

LOCK TABLES `payrolls` WRITE;
/*!40000 ALTER TABLE `payrolls` DISABLE KEYS */;
INSERT INTO `payrolls` VALUES
(1,'payroll-20240710-023251',1,1,1,1000000,'2','yes','2024-07-10 18:32:51','2024-07-10 18:32:51');
/*!40000 ALTER TABLE `payrolls` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES
(4,'products-edit','web','2018-06-03 01:00:09','2018-06-03 01:00:09'),
(5,'products-delete','web','2018-06-03 22:54:22','2018-06-03 22:54:22'),
(6,'products-add','web','2018-06-04 00:34:14','2018-06-04 00:34:14'),
(7,'products-index','web','2018-06-04 03:34:27','2018-06-04 03:34:27'),
(8,'purchases-index','web','2018-06-04 08:03:19','2018-06-04 08:03:19'),
(9,'purchases-add','web','2018-06-04 08:12:25','2018-06-04 08:12:25'),
(10,'purchases-edit','web','2018-06-04 09:47:36','2018-06-04 09:47:36'),
(11,'purchases-delete','web','2018-06-04 09:47:36','2018-06-04 09:47:36'),
(12,'sales-index','web','2018-06-04 10:49:08','2018-06-04 10:49:08'),
(13,'sales-add','web','2018-06-04 10:49:52','2018-06-04 10:49:52'),
(14,'sales-edit','web','2018-06-04 10:49:52','2018-06-04 10:49:52'),
(15,'sales-delete','web','2018-06-04 10:49:53','2018-06-04 10:49:53'),
(16,'quotes-index','web','2018-06-04 22:05:10','2018-06-04 22:05:10'),
(17,'quotes-add','web','2018-06-04 22:05:10','2018-06-04 22:05:10'),
(18,'quotes-edit','web','2018-06-04 22:05:10','2018-06-04 22:05:10'),
(19,'quotes-delete','web','2018-06-04 22:05:10','2018-06-04 22:05:10'),
(20,'transfers-index','web','2018-06-04 22:30:03','2018-06-04 22:30:03'),
(21,'transfers-add','web','2018-06-04 22:30:03','2018-06-04 22:30:03'),
(22,'transfers-edit','web','2018-06-04 22:30:03','2018-06-04 22:30:03'),
(23,'transfers-delete','web','2018-06-04 22:30:03','2018-06-04 22:30:03'),
(24,'returns-index','web','2018-06-04 22:50:24','2018-06-04 22:50:24'),
(25,'returns-add','web','2018-06-04 22:50:24','2018-06-04 22:50:24'),
(26,'returns-edit','web','2018-06-04 22:50:25','2018-06-04 22:50:25'),
(27,'returns-delete','web','2018-06-04 22:50:25','2018-06-04 22:50:25'),
(28,'customers-index','web','2018-06-04 23:15:54','2018-06-04 23:15:54'),
(29,'customers-add','web','2018-06-04 23:15:55','2018-06-04 23:15:55'),
(30,'customers-edit','web','2018-06-04 23:15:55','2018-06-04 23:15:55'),
(31,'customers-delete','web','2018-06-04 23:15:55','2018-06-04 23:15:55'),
(32,'suppliers-index','web','2018-06-04 23:40:12','2018-06-04 23:40:12'),
(33,'suppliers-add','web','2018-06-04 23:40:12','2018-06-04 23:40:12'),
(34,'suppliers-edit','web','2018-06-04 23:40:12','2018-06-04 23:40:12'),
(35,'suppliers-delete','web','2018-06-04 23:40:12','2018-06-04 23:40:12'),
(36,'product-report','web','2018-06-24 23:05:33','2018-06-24 23:05:33'),
(37,'purchase-report','web','2018-06-24 23:24:56','2018-06-24 23:24:56'),
(38,'sale-report','web','2018-06-24 23:33:13','2018-06-24 23:33:13'),
(39,'customer-report','web','2018-06-24 23:36:51','2018-06-24 23:36:51'),
(40,'due-report','web','2018-06-24 23:39:52','2018-06-24 23:39:52'),
(41,'users-index','web','2018-06-25 00:00:10','2018-06-25 00:00:10'),
(42,'users-add','web','2018-06-25 00:00:10','2018-06-25 00:00:10'),
(43,'users-edit','web','2018-06-25 00:01:30','2018-06-25 00:01:30'),
(44,'users-delete','web','2018-06-25 00:01:30','2018-06-25 00:01:30'),
(45,'profit-loss','web','2018-07-14 21:50:05','2018-07-14 21:50:05'),
(46,'best-seller','web','2018-07-14 22:01:38','2018-07-14 22:01:38'),
(47,'daily-sale','web','2018-07-14 22:24:21','2018-07-14 22:24:21'),
(48,'monthly-sale','web','2018-07-14 22:30:41','2018-07-14 22:30:41'),
(49,'daily-purchase','web','2018-07-14 22:36:46','2018-07-14 22:36:46'),
(50,'monthly-purchase','web','2018-07-14 22:48:17','2018-07-14 22:48:17'),
(51,'payment-report','web','2018-07-14 23:10:41','2018-07-14 23:10:41'),
(52,'warehouse-stock-report','web','2018-07-14 23:16:55','2018-07-14 23:16:55'),
(53,'product-qty-alert','web','2018-07-14 23:33:21','2018-07-14 23:33:21'),
(54,'supplier-report','web','2018-07-30 03:00:01','2018-07-30 03:00:01'),
(55,'expenses-index','web','2018-09-05 01:07:10','2018-09-05 01:07:10'),
(56,'expenses-add','web','2018-09-05 01:07:10','2018-09-05 01:07:10'),
(57,'expenses-edit','web','2018-09-05 01:07:10','2018-09-05 01:07:10'),
(58,'expenses-delete','web','2018-09-05 01:07:11','2018-09-05 01:07:11'),
(59,'general_setting','web','2018-10-19 23:10:04','2018-10-19 23:10:04'),
(60,'mail_setting','web','2018-10-19 23:10:04','2018-10-19 23:10:04'),
(61,'pos_setting','web','2018-10-19 23:10:04','2018-10-19 23:10:04'),
(62,'hrm_setting','web','2019-01-02 10:30:23','2019-01-02 10:30:23'),
(63,'purchase-return-index','web','2019-01-02 21:45:14','2019-01-02 21:45:14'),
(64,'purchase-return-add','web','2019-01-02 21:45:14','2019-01-02 21:45:14'),
(65,'purchase-return-edit','web','2019-01-02 21:45:14','2019-01-02 21:45:14'),
(66,'purchase-return-delete','web','2019-01-02 21:45:14','2019-01-02 21:45:14'),
(67,'account-index','web','2019-01-02 22:06:13','2019-01-02 22:06:13'),
(68,'balance-sheet','web','2019-01-02 22:06:14','2019-01-02 22:06:14'),
(69,'account-statement','web','2019-01-02 22:06:14','2019-01-02 22:06:14'),
(70,'department','web','2019-01-02 22:30:01','2019-01-02 22:30:01'),
(71,'attendance','web','2019-01-02 22:30:01','2019-01-02 22:30:01'),
(72,'payroll','web','2019-01-02 22:30:01','2019-01-02 22:30:01'),
(73,'employees-index','web','2019-01-02 22:52:19','2019-01-02 22:52:19'),
(74,'employees-add','web','2019-01-02 22:52:19','2019-01-02 22:52:19'),
(75,'employees-edit','web','2019-01-02 22:52:19','2019-01-02 22:52:19'),
(76,'employees-delete','web','2019-01-02 22:52:19','2019-01-02 22:52:19'),
(77,'user-report','web','2019-01-16 06:48:18','2019-01-16 06:48:18'),
(78,'stock_count','web','2019-02-17 10:32:01','2019-02-17 10:32:01'),
(79,'adjustment','web','2019-02-17 10:32:02','2019-02-17 10:32:02'),
(80,'sms_setting','web','2019-02-22 05:18:03','2019-02-22 05:18:03'),
(81,'create_sms','web','2019-02-22 05:18:03','2019-02-22 05:18:03'),
(82,'print_barcode','web','2019-03-07 05:02:19','2019-03-07 05:02:19'),
(83,'empty_database','web','2019-03-07 05:02:19','2019-03-07 05:02:19'),
(84,'customer_group','web','2019-03-07 05:37:15','2019-03-07 05:37:15'),
(85,'unit','web','2019-03-07 05:37:15','2019-03-07 05:37:15'),
(86,'tax','web','2019-03-07 05:37:15','2019-03-07 05:37:15'),
(87,'gift_card','web','2019-03-07 06:29:38','2019-03-07 06:29:38'),
(88,'coupon','web','2019-03-07 06:29:38','2019-03-07 06:29:38'),
(89,'holiday','web','2019-10-19 08:57:15','2019-10-19 08:57:15'),
(90,'warehouse-report','web','2019-10-22 06:00:23','2019-10-22 06:00:23'),
(91,'warehouse','web','2020-02-26 06:47:32','2020-02-26 06:47:32'),
(92,'brand','web','2020-02-26 06:59:59','2020-02-26 06:59:59'),
(93,'billers-index','web','2020-02-26 07:11:15','2020-02-26 07:11:15'),
(94,'billers-add','web','2020-02-26 07:11:15','2020-02-26 07:11:15'),
(95,'billers-edit','web','2020-02-26 07:11:15','2020-02-26 07:11:15'),
(96,'billers-delete','web','2020-02-26 07:11:15','2020-02-26 07:11:15'),
(97,'money-transfer','web','2020-03-02 05:41:48','2020-03-02 05:41:48'),
(98,'category','web','2020-07-13 12:13:16','2020-07-13 12:13:16'),
(99,'delivery','web','2020-07-13 12:13:16','2020-07-13 12:13:16'),
(100,'send_notification','web','2020-10-31 06:21:31','2020-10-31 06:21:31'),
(101,'today_sale','web','2020-10-31 06:57:04','2020-10-31 06:57:04'),
(102,'today_profit','web','2020-10-31 06:57:04','2020-10-31 06:57:04'),
(103,'currency','web','2020-11-09 00:23:11','2020-11-09 00:23:11'),
(104,'backup_database','web','2020-11-15 00:16:55','2020-11-15 00:16:55'),
(105,'reward_point_setting','web','2021-06-27 04:34:42','2021-06-27 04:34:42'),
(106,'revenue_profit_summary','web','2022-02-08 13:57:21','2022-02-08 13:57:21'),
(107,'cash_flow','web','2022-02-08 13:57:22','2022-02-08 13:57:22'),
(108,'monthly_summary','web','2022-02-08 13:57:22','2022-02-08 13:57:22'),
(109,'yearly_report','web','2022-02-08 13:57:22','2022-02-08 13:57:22'),
(110,'discount_plan','web','2022-02-16 09:12:26','2022-02-16 09:12:26'),
(111,'discount','web','2022-02-16 09:12:38','2022-02-16 09:12:38'),
(112,'product-expiry-report','web','2022-03-30 05:39:20','2022-03-30 05:39:20'),
(113,'purchase-payment-index','web','2022-06-05 14:12:27','2022-06-05 14:12:27'),
(114,'purchase-payment-add','web','2022-06-05 14:12:28','2022-06-05 14:12:28'),
(115,'purchase-payment-edit','web','2022-06-05 14:12:28','2022-06-05 14:12:28'),
(116,'purchase-payment-delete','web','2022-06-05 14:12:28','2022-06-05 14:12:28'),
(117,'sale-payment-index','web','2022-06-05 14:12:28','2022-06-05 14:12:28'),
(118,'sale-payment-add','web','2022-06-05 14:12:28','2022-06-05 14:12:28'),
(119,'sale-payment-edit','web','2022-06-05 14:12:28','2022-06-05 14:12:28'),
(120,'sale-payment-delete','web','2022-06-05 14:12:28','2022-06-05 14:12:28'),
(121,'all_notification','web','2022-06-05 14:12:29','2022-06-05 14:12:29'),
(122,'sale-report-chart','web','2022-06-05 14:12:29','2022-06-05 14:12:29'),
(123,'dso-report','web','2022-06-05 14:12:29','2022-06-05 14:12:29'),
(124,'product_history','web','2022-08-25 14:04:05','2022-08-25 14:04:05'),
(125,'supplier-due-report','web','2022-08-31 09:46:33','2022-08-31 09:46:33'),
(126,'custom_field','web','2023-05-02 07:41:35','2023-05-02 07:41:35');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pos_setting`
--

DROP TABLE IF EXISTS `pos_setting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `pos_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `biller_id` int(11) NOT NULL,
  `product_number` int(11) NOT NULL,
  `keybord_active` tinyint(1) NOT NULL,
  `is_table` tinyint(1) NOT NULL DEFAULT 0,
  `send_sms` tinyint(1) NOT NULL DEFAULT 0,
  `stripe_public_key` varchar(191) DEFAULT NULL,
  `stripe_secret_key` varchar(191) DEFAULT NULL,
  `paypal_live_api_username` varchar(191) DEFAULT NULL,
  `paypal_live_api_password` varchar(191) DEFAULT NULL,
  `paypal_live_api_secret` varchar(191) DEFAULT NULL,
  `payment_options` text DEFAULT NULL,
  `invoice_option` varchar(10) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  UNIQUE KEY `pos_setting_id_unique` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pos_setting`
--

LOCK TABLES `pos_setting` WRITE;
/*!40000 ALTER TABLE `pos_setting` DISABLE KEYS */;
INSERT INTO `pos_setting` VALUES
(1,2,1,1,3,0,0,1,NULL,NULL,'admin','admin',NULL,'cash,card,cheque,gift_card,deposit,paypal','A4','2018-09-02 03:17:04','2024-05-21 07:00:20');
/*!40000 ALTER TABLE `pos_setting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_adjustments`
--

DROP TABLE IF EXISTS `product_adjustments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_adjustments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `adjustment_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `unit_cost` double DEFAULT NULL,
  `qty` double NOT NULL,
  `action` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_adjustments`
--

LOCK TABLES `product_adjustments` WRITE;
/*!40000 ALTER TABLE `product_adjustments` DISABLE KEYS */;
INSERT INTO `product_adjustments` VALUES
(3,3,33,NULL,6690000,2,'+','2024-07-10 18:04:12','2024-07-10 18:04:47');
/*!40000 ALTER TABLE `product_adjustments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_batches`
--

DROP TABLE IF EXISTS `product_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_batches` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `batch_no` varchar(191) NOT NULL,
  `expired_date` date NOT NULL,
  `qty` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_batches`
--

LOCK TABLES `product_batches` WRITE;
/*!40000 ALTER TABLE `product_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_batches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_purchases`
--

DROP TABLE IF EXISTS `product_purchases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_purchases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `imei_number` text DEFAULT NULL,
  `qty` double NOT NULL,
  `recieved` double NOT NULL,
  `purchase_unit_id` int(11) NOT NULL,
  `net_unit_cost` double NOT NULL,
  `discount` double NOT NULL,
  `tax_rate` double NOT NULL,
  `tax` double NOT NULL,
  `total` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_purchases`
--

LOCK TABLES `product_purchases` WRITE;
/*!40000 ALTER TABLE `product_purchases` DISABLE KEYS */;
INSERT INTO `product_purchases` VALUES
(1,1,23,NULL,NULL,NULL,10,10,1,439,0,0,0,4390,'2024-01-19 13:46:04','2024-01-19 13:46:04'),
(2,1,27,NULL,NULL,NULL,10,10,1,0.89,0,0,0,8.9,'2024-01-19 13:46:04','2024-01-19 13:46:04'),
(3,1,20,NULL,NULL,NULL,10,10,1,399,0,0,0,3990,'2024-01-19 13:46:04','2024-01-19 13:46:04'),
(4,1,17,NULL,NULL,NULL,10,10,1,349,0,0,0,3490,'2024-01-19 13:46:04','2024-01-19 13:46:04'),
(5,1,16,NULL,NULL,NULL,10,10,1,79,0,0,0,790,'2024-01-19 13:46:04','2024-01-19 13:46:04'),
(6,1,30,NULL,NULL,NULL,10,10,1,100,0,10,100,1100,'2024-01-19 13:46:04','2024-01-19 13:46:04'),
(7,1,19,NULL,NULL,NULL,10,10,1,817.27,0,10,817.27,8990,'2024-01-19 13:46:04','2024-01-19 13:46:04'),
(8,1,3,NULL,NULL,NULL,10,10,1,272.73,0,10,272.73,3000,'2024-01-19 13:46:05','2024-01-19 13:46:05'),
(9,1,7,NULL,NULL,NULL,10,10,1,818.17,0,10,818.17,8999.9,'2024-01-19 13:46:05','2024-01-19 13:46:05'),
(10,1,2,NULL,NULL,NULL,10,10,1,909.09,0,10,909.09,10000,'2024-01-19 13:46:05','2024-01-19 13:46:05'),
(11,2,6,NULL,NULL,NULL,10,10,1,999.99,0,0,0,9999.9,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(12,2,13,NULL,NULL,NULL,10,10,1,227.27,0,10,227.27,2500,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(13,2,10,NULL,NULL,NULL,10,10,1,990,0,0,0,9900,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(14,2,21,NULL,NULL,NULL,10,10,1,369,0,0,0,3690,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(15,2,8,NULL,NULL,NULL,10,10,1,1090,0,10,1090,11990,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(16,2,12,NULL,NULL,NULL,10,10,1,908.18,0,10,908.18,9990,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(17,2,29,NULL,NULL,NULL,10,10,1,2.39,0,0,0,23.9,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(18,2,26,NULL,NULL,NULL,10,10,4,2.99,0,0,0,29.9,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(19,2,9,NULL,NULL,NULL,10,10,1,399,0,0,0,3990,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(20,2,11,NULL,NULL,NULL,10,10,1,1363.64,0,10,1363.64,15000,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(21,3,1,NULL,NULL,NULL,10,10,1,999.99,0,10,999.99,10999.9,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(22,3,18,NULL,NULL,NULL,10,10,1,417.27,0,10,417.27,4590,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(23,3,25,NULL,NULL,NULL,10,10,1,130,0,0,0,1300,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(24,3,28,NULL,NULL,NULL,10,10,1,2.39,0,0,0,23.9,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(25,3,14,NULL,NULL,NULL,10,10,1,318.18,0,10,318.18,3500,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(26,3,24,NULL,NULL,NULL,10,10,1,271.82,0,10,271.82,2990,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(27,3,4,NULL,NULL,NULL,10,10,1,818.18,0,10,818.18,9000,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(28,3,5,NULL,NULL,NULL,10,10,1,864.54,0,10,864.54,9509.9,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(29,3,22,NULL,NULL,NULL,10,10,1,275,0,0,0,2750,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(30,3,15,NULL,NULL,NULL,10,10,1,499,0,0,0,4990,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(31,4,1,NULL,NULL,NULL,11,11,1,999.99,0,10,1099.99,12099.89,'2024-01-19 14:26:48','2024-01-19 14:26:48'),
(32,4,18,NULL,NULL,NULL,10,10,1,417.27,0,10,417.27,4590,'2024-01-19 14:26:48','2024-01-19 14:26:48'),
(33,4,25,NULL,NULL,NULL,10,10,1,130,0,0,0,1300,'2024-01-19 14:26:48','2024-01-19 14:26:48'),
(34,4,28,NULL,NULL,NULL,10,10,1,2.39,0,0,0,23.9,'2024-01-19 14:26:48','2024-01-19 14:26:48'),
(35,4,14,NULL,NULL,NULL,10,10,1,318.18,0,10,318.18,3500,'2024-01-19 14:26:49','2024-01-19 14:26:49'),
(36,4,24,NULL,NULL,NULL,10,10,1,271.82,0,10,271.82,2990,'2024-01-19 14:26:49','2024-01-19 14:26:49'),
(37,4,4,NULL,NULL,NULL,10,10,1,818.18,0,10,818.18,9000,'2024-01-19 14:26:49','2024-01-19 14:26:49'),
(38,4,5,NULL,NULL,NULL,10,10,1,864.54,0,10,864.54,9509.9,'2024-01-19 14:26:49','2024-01-19 14:26:49'),
(39,4,22,NULL,NULL,NULL,10,10,1,275,0,0,0,2750,'2024-01-19 14:26:49','2024-01-19 14:26:49'),
(40,4,15,NULL,NULL,NULL,10,10,1,499,0,0,0,4990,'2024-01-19 14:26:49','2024-01-19 14:26:49'),
(41,5,23,NULL,NULL,NULL,10,10,1,439,0,0,0,4390,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(42,5,27,NULL,NULL,NULL,10,10,1,0.89,0,0,0,8.9,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(43,5,20,NULL,NULL,NULL,10,10,1,399,0,0,0,3990,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(44,5,17,NULL,NULL,NULL,10,10,1,349,0,0,0,3490,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(45,5,16,NULL,NULL,NULL,10,10,1,79,0,0,0,790,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(46,5,30,NULL,NULL,NULL,10,10,1,100,0,10,100,1100,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(47,5,19,NULL,NULL,NULL,10,10,1,817.27,0,10,817.27,8990,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(48,5,3,NULL,NULL,NULL,10,10,1,272.73,0,10,272.73,3000,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(49,5,7,NULL,NULL,NULL,10,10,1,818.17,0,10,818.17,8999.9,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(50,5,2,NULL,NULL,NULL,10,10,1,909.09,0,10,909.09,10000,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(51,6,6,NULL,NULL,NULL,10,10,1,999.99,0,0,0,9999.9,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(52,6,13,NULL,NULL,NULL,10,10,1,227.27,0,10,227.27,2500,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(53,6,10,NULL,NULL,NULL,10,10,1,990,0,0,0,9900,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(54,6,21,NULL,NULL,NULL,10,10,1,369,0,0,0,3690,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(55,6,8,NULL,NULL,NULL,10,10,1,1090,0,10,1090,11990,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(56,6,12,NULL,NULL,NULL,10,10,1,908.18,0,10,908.18,9990,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(57,6,29,NULL,NULL,NULL,10,10,1,2.39,0,0,0,23.9,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(58,6,26,NULL,NULL,NULL,10,10,4,2.99,0,0,0,29.9,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(59,6,9,NULL,NULL,NULL,10,10,1,399,0,0,0,3990,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(60,6,11,NULL,NULL,NULL,10,10,1,1363.64,0,10,1363.64,15000,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(61,7,17,NULL,NULL,NULL,1,1,1,349,0,0,0,349,'2024-01-19 14:52:02','2024-01-19 14:52:02'),
(62,7,20,NULL,NULL,NULL,1,1,1,399,0,0,0,399,'2024-01-19 14:52:02','2024-01-19 14:52:02'),
(63,8,7,NULL,NULL,NULL,5,5,1,800,0,10,400,4400,'2024-02-04 07:13:47','2024-02-04 07:13:47'),
(65,10,33,NULL,NULL,NULL,9,9,1,6690000,0,20,12042000,72252000,'2024-07-10 18:01:12','2024-07-10 18:01:12'),
(66,11,33,NULL,NULL,NULL,9,9,1,6690000,0,20,12042000,72252000,'2024-07-10 18:01:12','2024-07-10 18:01:12'),
(67,12,33,NULL,NULL,NULL,3,3,1,6690000,0,20,4014000,24084000,'2024-07-10 18:14:12','2024-07-10 18:14:12'),
(68,13,33,NULL,NULL,NULL,1,0,1,6690000,0,20,1338000,8028000,'2024-07-10 18:19:07','2024-07-10 18:19:07'),
(69,14,27,NULL,NULL,NULL,1000,1000,1,0.89,0,0,0,890,'2025-09-24 14:14:04','2025-09-24 14:14:04');
/*!40000 ALTER TABLE `product_purchases` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_quotation`
--

DROP TABLE IF EXISTS `product_quotation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_quotation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `quotation_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `qty` double NOT NULL,
  `sale_unit_id` int(11) NOT NULL,
  `net_unit_price` double NOT NULL,
  `discount` double NOT NULL,
  `tax_rate` double NOT NULL,
  `tax` double NOT NULL,
  `total` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_quotation`
--

LOCK TABLES `product_quotation` WRITE;
/*!40000 ALTER TABLE `product_quotation` DISABLE KEYS */;
INSERT INTO `product_quotation` VALUES
(1,1,17,NULL,NULL,1,1,499,0,0,0,499,'2024-01-19 14:51:32','2024-01-19 14:51:32'),
(2,1,20,NULL,NULL,1,1,499,0,0,0,499,'2024-01-19 14:51:32','2024-01-19 14:51:32');
/*!40000 ALTER TABLE `product_quotation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_returns`
--

DROP TABLE IF EXISTS `product_returns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_returns` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `return_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `imei_number` text DEFAULT NULL,
  `qty` double NOT NULL,
  `sale_unit_id` int(11) NOT NULL,
  `net_unit_price` double NOT NULL,
  `discount` double NOT NULL,
  `tax_rate` double NOT NULL,
  `tax` double NOT NULL,
  `total` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_returns`
--

LOCK TABLES `product_returns` WRITE;
/*!40000 ALTER TABLE `product_returns` DISABLE KEYS */;
INSERT INTO `product_returns` VALUES
(1,1,1,NULL,NULL,NULL,1,1,1181.81,0,10,118.18,1299.99,'2024-03-24 07:08:23','2024-03-24 07:08:23'),
(2,2,5,NULL,NULL,NULL,1,1,1046.35,0,10,104.64,1150.99,'2024-04-29 12:30:38','2024-04-29 12:30:38'),
(3,2,3,NULL,NULL,NULL,1,1,318.18,0,10,31.82,350,'2024-04-29 12:30:38','2024-04-29 12:30:38');
/*!40000 ALTER TABLE `product_returns` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_sales`
--

DROP TABLE IF EXISTS `product_sales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_sales` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sale_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `imei_number` text DEFAULT NULL,
  `qty` double NOT NULL,
  `return_qty` double NOT NULL DEFAULT 0,
  `sale_unit_id` int(11) NOT NULL,
  `net_unit_price` double NOT NULL,
  `discount` double NOT NULL,
  `tax_rate` double NOT NULL,
  `tax` double NOT NULL,
  `total` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_sales`
--

LOCK TABLES `product_sales` WRITE;
/*!40000 ALTER TABLE `product_sales` DISABLE KEYS */;
INSERT INTO `product_sales` VALUES
(1,1,14,NULL,NULL,NULL,1,0,1,453.64,0,10,45.36,499,'2024-01-19 14:40:16','2024-01-19 14:40:16'),
(2,1,2,NULL,NULL,NULL,1,0,1,1144.55,0,10,114.45,1259,'2024-01-19 14:40:16','2024-01-19 14:40:16'),
(3,2,16,NULL,NULL,NULL,1,0,1,109,0,0,0,109,'2024-01-19 14:44:41','2024-01-19 14:44:41'),
(4,2,18,NULL,NULL,NULL,1,0,1,544.55,0,10,54.45,599,'2024-01-19 14:44:41','2024-01-19 14:44:41'),
(5,2,9,NULL,NULL,NULL,1,0,1,559,0,0,0,559,'2024-01-19 14:44:41','2024-01-19 14:44:41'),
(6,2,4,NULL,NULL,NULL,1,0,1,954.55,0,10,95.45,1050,'2024-01-19 14:44:41','2024-01-19 14:44:41'),
(7,2,3,NULL,NULL,NULL,2,0,1,318.18,0,10,63.64,700,'2024-01-19 14:44:41','2024-01-19 14:44:41'),
(8,3,18,NULL,NULL,NULL,1,0,1,544.55,0,10,54.45,599,'2024-01-19 14:48:33','2024-01-19 14:48:33'),
(9,3,23,NULL,NULL,NULL,1,0,1,577,0,0,0,577,'2024-01-19 14:48:33','2024-01-19 14:48:33'),
(10,3,27,NULL,NULL,NULL,3,0,1,2,0,0,0,6,'2024-01-19 14:48:33','2024-01-19 14:48:33'),
(11,4,7,NULL,NULL,NULL,1,0,1,908.18,0,10,90.82,999,'2024-01-19 14:52:42','2024-01-19 14:53:31'),
(12,4,17,NULL,NULL,NULL,1,0,1,499,0,0,0,499,'2024-01-19 14:52:42','2024-01-19 14:53:31'),
(13,4,20,NULL,NULL,NULL,1,0,1,499,0,0,0,499,'2024-01-19 14:52:42','2024-01-19 14:53:31'),
(14,5,2,NULL,NULL,NULL,1,0,1,1144.55,0,10,114.45,1259,'2024-02-10 06:22:24','2024-02-10 06:22:24'),
(15,6,1,NULL,NULL,NULL,1,0,1,1181.81,0,10,118.18,1299.99,'2024-02-25 07:49:51','2024-02-25 07:49:51'),
(16,7,1,NULL,NULL,NULL,2,0,1,1181.81,0,10,236.36,2599.98,'2024-02-25 07:50:13','2024-02-25 07:50:13'),
(17,8,2,NULL,NULL,NULL,1,0,1,1144.55,0,10,114.45,1259,'2024-02-28 05:27:44','2024-02-28 05:27:44'),
(18,8,1,NULL,NULL,NULL,1,1,1,1181.81,0,10,118.18,1299.99,'2024-02-28 05:27:44','2024-03-24 07:08:23'),
(19,9,3,NULL,NULL,NULL,1,0,1,318.18,0,10,31.82,350,'2024-04-21 05:01:43','2024-04-21 05:01:43'),
(25,13,3,NULL,NULL,NULL,1,0,1,318.18,0,10,31.82,350,'2024-04-28 06:15:44','2024-04-28 06:15:44'),
(26,13,19,NULL,NULL,NULL,1,0,1,962.73,0,10,96.27,1059,'2024-04-28 06:15:44','2024-04-28 06:15:44'),
(27,14,5,NULL,NULL,NULL,1,1,1,1046.35,0,10,104.64,1150.99,'2024-04-29 12:29:56','2024-04-29 12:30:38'),
(28,14,4,NULL,NULL,NULL,1,0,1,954.55,0,10,95.45,1050,'2024-04-29 12:29:56','2024-04-29 12:29:56'),
(29,14,3,NULL,NULL,NULL,1,1,1,318.18,0,10,31.82,350,'2024-04-29 12:29:56','2024-04-29 12:30:38'),
(30,14,2,NULL,NULL,NULL,1,0,1,1136.36,0,10,113.64,1250,'2024-04-29 12:29:56','2024-04-29 12:29:56'),
(31,15,20,NULL,NULL,NULL,1,0,1,499,0,0,0,499,'2024-05-05 05:19:02','2024-05-05 05:19:02'),
(37,20,2,NULL,NULL,NULL,1,0,1,1136.36,0,10,113.64,1250,'2024-05-05 11:29:05','2024-05-05 11:29:05'),
(38,20,1,NULL,NULL,NULL,1,0,1,1181.81,0,10,118.18,1299.99,'2024-05-05 11:29:05','2024-05-05 11:29:05'),
(40,22,7,NULL,NULL,NULL,1,0,1,909.08,0,10,90.91,999.99,'2024-05-08 08:08:51','2024-05-08 08:08:51'),
(41,22,3,NULL,NULL,NULL,1,0,1,318.18,0,10,31.82,350,'2024-05-08 08:08:51','2024-05-08 08:08:51'),
(42,23,1,NULL,NULL,NULL,1,0,1,1181.81,0,10,118.18,1299.99,'2024-05-19 08:24:23','2024-05-19 08:24:23'),
(43,24,8,NULL,NULL,NULL,1,0,1,1181.82,0,10,118.18,1300,'2024-05-19 08:25:30','2024-05-19 08:25:30'),
(44,25,8,NULL,NULL,NULL,1,0,1,1181.82,0,10,118.18,1300,'2024-05-19 08:30:55','2024-05-19 08:30:55'),
(49,28,4,NULL,NULL,NULL,1,0,1,954.55,0,10,95.45,1050,'2024-05-21 07:32:49','2024-05-21 07:32:49'),
(50,29,33,NULL,NULL,NULL,1,0,1,66100013,0,20,13220002.6,79320015.6,'2024-07-10 18:24:16','2024-07-10 18:24:16'),
(51,30,5,NULL,NULL,NULL,1,0,1,1046.35,0,10,104.64,1150.99,'2025-09-23 06:55:10','2025-09-23 06:55:10'),
(52,30,3,NULL,NULL,NULL,2,0,1,318.18,0,10,63.64,700,'2025-09-23 06:55:10','2025-09-23 06:55:10'),
(53,31,27,NULL,NULL,NULL,10,0,1,1.29,0,0,0,12.9,'2025-09-24 13:48:54','2025-09-24 13:48:54'),
(54,32,30,NULL,NULL,NULL,5,0,1,200,0,10,100,1100,'2025-09-24 13:53:43','2025-09-24 13:53:43'),
(55,32,20,NULL,NULL,NULL,10,0,1,499,0,0,0,4990,'2025-09-24 13:53:43','2025-09-24 13:53:43'),
(56,32,27,NULL,NULL,NULL,10,0,1,1.29,0,0,0,12.9,'2025-09-24 13:53:43','2025-09-24 13:53:43'),
(57,33,3,NULL,NULL,NULL,5,0,1,318.18,0,10,159.09,1750,'2025-09-24 14:06:51','2025-09-24 14:06:51'),
(58,33,30,NULL,NULL,NULL,6,0,1,200,0,10,120,1320,'2025-09-24 14:06:51','2025-09-24 14:06:51'),
(59,33,2,NULL,NULL,NULL,11,0,1,1136.36,0,10,1250,13750,'2025-09-24 14:06:52','2025-09-24 14:06:52'),
(60,33,29,NULL,NULL,NULL,15,0,1,3.19,0,0,0,47.85,'2025-09-24 14:06:54','2025-09-24 14:06:54'),
(61,34,15,NULL,NULL,NULL,1000,0,1,547,0,0,0,547000,'2025-09-24 14:08:29','2025-09-24 14:08:29');
/*!40000 ALTER TABLE `product_sales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_transfer`
--

DROP TABLE IF EXISTS `product_transfer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_transfer` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `transfer_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `imei_number` text DEFAULT NULL,
  `qty` double NOT NULL,
  `purchase_unit_id` int(11) NOT NULL,
  `net_unit_cost` double NOT NULL,
  `tax_rate` double NOT NULL,
  `tax` double NOT NULL,
  `total` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_transfer`
--

LOCK TABLES `product_transfer` WRITE;
/*!40000 ALTER TABLE `product_transfer` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_transfer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_variants`
--

DROP TABLE IF EXISTS `product_variants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_variants` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `variant_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `item_code` varchar(191) NOT NULL,
  `additional_cost` double DEFAULT NULL,
  `additional_price` double DEFAULT NULL,
  `qty` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_variants`
--

LOCK TABLES `product_variants` WRITE;
/*!40000 ALTER TABLE `product_variants` DISABLE KEYS */;
INSERT INTO `product_variants` VALUES
(1,34,1,1,'10-1021540',NULL,NULL,0,'2025-09-24 14:13:08','2025-09-24 14:13:08');
/*!40000 ALTER TABLE `product_variants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_warehouse`
--

DROP TABLE IF EXISTS `product_warehouse`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_warehouse` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` varchar(191) NOT NULL,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `imei_number` text DEFAULT NULL,
  `warehouse_id` int(11) NOT NULL,
  `qty` double NOT NULL,
  `price` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_warehouse`
--

LOCK TABLES `product_warehouse` WRITE;
/*!40000 ALTER TABLE `product_warehouse` DISABLE KEYS */;
INSERT INTO `product_warehouse` VALUES
(1,'23',NULL,NULL,NULL,1,10,577,'2024-01-19 13:46:04','2024-05-21 12:40:42'),
(2,'27',NULL,NULL,NULL,1,990,1.29,'2024-01-19 13:46:04','2025-09-24 14:14:04'),
(3,'20',NULL,NULL,NULL,1,-1,499,'2024-01-19 13:46:04','2025-09-24 13:53:43'),
(4,'17',NULL,NULL,NULL,1,10,499,'2024-01-19 13:46:04','2024-04-28 06:05:43'),
(5,'16',NULL,NULL,NULL,1,10,109,'2024-01-19 13:46:04','2024-01-19 13:46:04'),
(6,'30',NULL,NULL,NULL,1,-1,200,'2024-01-19 13:46:04','2025-09-24 14:06:51'),
(7,'19',NULL,NULL,NULL,1,9,1059,'2024-01-19 13:46:04','2024-04-28 06:15:44'),
(8,'3',NULL,NULL,NULL,1,2,350,'2024-01-19 13:46:05','2025-09-24 14:06:50'),
(9,'7',NULL,NULL,NULL,1,12,NULL,'2024-01-19 13:46:05','2024-05-23 07:38:12'),
(10,'2',NULL,NULL,NULL,1,-6,NULL,'2024-01-19 13:46:05','2025-09-24 14:06:52'),
(11,'6',NULL,NULL,NULL,1,10,1111.99,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(12,'13',NULL,NULL,NULL,1,10,349,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(13,'10',NULL,NULL,NULL,1,10,1250,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(14,'21',NULL,NULL,NULL,1,10,599,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(15,'8',NULL,NULL,NULL,1,8,1300,'2024-01-19 13:50:04','2024-05-19 08:30:55'),
(16,'12',NULL,NULL,NULL,1,10,1250,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(17,'29',NULL,NULL,NULL,1,-5,3.19,'2024-01-19 13:50:04','2025-09-24 14:06:53'),
(18,'26',NULL,NULL,NULL,1,10,3.99,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(19,'9',NULL,NULL,NULL,1,10,559,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(20,'11',NULL,NULL,NULL,1,10,1750,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(21,'1',NULL,NULL,NULL,1,5,1299.99,'2024-01-19 13:53:21','2024-05-21 06:44:57'),
(22,'18',NULL,NULL,NULL,1,10,599,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(23,'25',NULL,NULL,NULL,1,10,157.99,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(24,'28',NULL,NULL,NULL,1,10,3.3,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(25,'14',NULL,NULL,NULL,1,9,499,'2024-01-19 13:53:21','2024-01-19 14:40:16'),
(26,'24',NULL,NULL,NULL,1,10,379,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(27,'4',NULL,NULL,NULL,1,8,1050,'2024-01-19 13:53:21','2024-05-21 07:32:49'),
(28,'5',NULL,NULL,NULL,1,10,1150.99,'2024-01-19 13:53:21','2024-04-29 12:30:38'),
(29,'22',NULL,NULL,NULL,1,10,399,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(30,'15',NULL,NULL,NULL,1,-990,547,'2024-01-19 13:53:21','2025-09-24 14:08:29'),
(31,'1',NULL,NULL,NULL,2,11,1299.99,'2024-01-19 14:26:48','2024-01-19 14:26:48'),
(32,'18',NULL,NULL,NULL,2,8,599,'2024-01-19 14:26:48','2024-01-19 14:48:33'),
(33,'25',NULL,NULL,NULL,2,10,157.99,'2024-01-19 14:26:48','2024-01-19 14:26:48'),
(34,'28',NULL,NULL,NULL,2,10,3.3,'2024-01-19 14:26:48','2024-01-19 14:26:48'),
(35,'14',NULL,NULL,NULL,2,10,499,'2024-01-19 14:26:49','2024-01-19 14:26:49'),
(36,'24',NULL,NULL,NULL,2,10,379,'2024-01-19 14:26:49','2024-01-19 14:26:49'),
(37,'4',NULL,NULL,NULL,2,9,1050,'2024-01-19 14:26:49','2024-01-19 14:44:41'),
(38,'5',NULL,NULL,NULL,2,10,1150.99,'2024-01-19 14:26:49','2024-01-19 14:26:49'),
(39,'22',NULL,NULL,NULL,2,10,399,'2024-01-19 14:26:49','2024-01-19 14:26:49'),
(40,'15',NULL,NULL,NULL,2,10,547,'2024-01-19 14:26:49','2024-01-19 14:26:49'),
(41,'23',NULL,NULL,NULL,2,9,577,'2024-01-19 14:28:26','2024-05-21 12:40:42'),
(42,'27',NULL,NULL,NULL,2,7,1.29,'2024-01-19 14:28:26','2024-01-19 14:48:33'),
(43,'20',NULL,NULL,NULL,2,10,499,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(44,'17',NULL,NULL,NULL,2,10,499,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(45,'16',NULL,NULL,NULL,2,9,109,'2024-01-19 14:28:26','2024-01-19 14:44:41'),
(46,'30',NULL,NULL,NULL,2,10,200,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(47,'19',NULL,NULL,NULL,2,10,1059,'2024-01-19 14:28:26','2024-01-19 14:28:26'),
(48,'3',NULL,NULL,NULL,2,8,350,'2024-01-19 14:28:26','2024-01-19 14:44:41'),
(49,'7',NULL,NULL,NULL,2,10,NULL,'2024-01-19 14:28:26','2024-05-23 07:38:12'),
(50,'2',NULL,NULL,NULL,2,10,NULL,'2024-01-19 14:28:26','2024-03-07 07:13:42'),
(51,'6',NULL,NULL,NULL,2,10,1111.99,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(52,'13',NULL,NULL,NULL,2,10,349,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(53,'10',NULL,NULL,NULL,2,10,1250,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(54,'21',NULL,NULL,NULL,2,10,599,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(55,'8',NULL,NULL,NULL,2,10,1300,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(56,'12',NULL,NULL,NULL,2,10,1250,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(57,'29',NULL,NULL,NULL,2,10,3.19,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(58,'26',NULL,NULL,NULL,2,10,3.99,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(59,'9',NULL,NULL,NULL,2,9,559,'2024-01-19 14:28:35','2024-01-19 14:44:41'),
(60,'11',NULL,NULL,NULL,2,10,1750,'2024-01-19 14:28:35','2024-01-19 14:28:35'),
(61,'32',NULL,NULL,NULL,1,0,NULL,'2024-04-29 12:29:17','2024-04-29 12:29:17'),
(62,'32',NULL,NULL,NULL,2,0,NULL,'2024-04-29 12:29:17','2024-04-29 12:29:17'),
(63,'33',NULL,NULL,NULL,1,13,NULL,'2024-07-10 18:01:12','2024-07-10 18:24:16'),
(64,'33',NULL,NULL,NULL,2,9,NULL,'2024-07-10 18:01:12','2024-07-10 18:01:12'),
(65,'34',NULL,1,NULL,1,0,NULL,'2025-09-24 14:13:08','2025-09-24 14:13:08'),
(66,'34',NULL,1,NULL,2,0,NULL,'2025-09-24 14:13:08','2025-09-24 14:13:08');
/*!40000 ALTER TABLE `product_warehouse` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `barcode_symbology` varchar(191) NOT NULL,
  `brand_id` int(11) DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `unit_id` int(11) NOT NULL,
  `purchase_unit_id` int(11) NOT NULL,
  `sale_unit_id` int(11) NOT NULL,
  `cost` double NOT NULL,
  `price` double NOT NULL,
  `wholesale_price` double DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `alert_quantity` double DEFAULT NULL,
  `daily_sale_objective` double DEFAULT NULL,
  `promotion` tinyint(4) DEFAULT NULL,
  `promotion_price` varchar(191) DEFAULT NULL,
  `starting_date` varchar(200) DEFAULT NULL,
  `last_date` date DEFAULT NULL,
  `tax_id` int(11) DEFAULT NULL,
  `tax_method` int(11) DEFAULT NULL,
  `image` longtext DEFAULT NULL,
  `file` varchar(191) DEFAULT NULL,
  `is_embeded` tinyint(1) DEFAULT NULL,
  `is_variant` tinyint(1) DEFAULT NULL,
  `is_batch` tinyint(1) DEFAULT NULL,
  `is_diffPrice` tinyint(1) DEFAULT NULL,
  `is_imei` tinyint(1) DEFAULT NULL,
  `featured` tinyint(4) DEFAULT NULL,
  `product_list` varchar(191) DEFAULT NULL,
  `variant_list` varchar(191) DEFAULT NULL,
  `qty_list` varchar(191) DEFAULT NULL,
  `price_list` varchar(191) DEFAULT NULL,
  `product_details` text DEFAULT NULL,
  `variant_option` text DEFAULT NULL,
  `variant_value` text DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES
(1,'Zenbook 14 OLED (UX3402)｜Laptops For Home – ASUS','59028109','standard','C128',2,6,1,1,1,1099.99,1299.99,NULL,16,NULL,NULL,1,'1050.99','2024-01-08',NULL,1,2,'202401081146401.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-08 05:46:42','2024-05-21 06:44:57'),
(2,'2021 Apple 12.9-inch iPad Pro Wi-Fi 512GB','2035892312345','standard','C128',3,6,1,1,1,1000,1250,1230,4,NULL,NULL,1,'1200.00','2024-01-08',NULL,1,2,'202401081246041.png,202401081246062.png,202401081246063.png,202401081246064.png',NULL,0,NULL,NULL,0,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-08 06:46:07','2025-09-24 14:06:51'),
(3,'Apple iPhone 11 (4GB-64GB) Black','49251814','standard','C128',1,1,1,1,1,300,350,NULL,10,NULL,NULL,1,NULL,'2024-01-08',NULL,1,2,'202401081255081.png,202401081255112.png,202401081255123.png,202401081255134.png,202401081255135.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-08 06:55:14','2025-09-24 14:06:50'),
(4,'Samsung Galaxy Chromebook Go, 14″ HD LED, Intel Celeron N4500','28090345','standard','C128',2,6,1,1,1,900,1050,NULL,17,NULL,NULL,NULL,NULL,NULL,NULL,1,2,'202401080121221.png,202401080121242.png,202401080121243.png,202401080121254.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-08 07:21:25','2024-05-21 07:32:49'),
(5,'SAMSUNG Galaxy Book Pro 15.6 Laptop – Intel Core i5','67015642','standard','C128',2,6,1,1,1,950.99,1150.99,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,1,2,'202401080124321.png,202401080124342.png,202401080124353.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-08 07:24:36','2024-04-29 12:30:38'),
(6,'Microsoft – Surface Laptop 4 13.5” Touch-Screen – AMD Ryzen 5','24005329','standard','C128',3,6,1,1,1,999.99,1111.99,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401080127451.png,202401080127462.png,202401080127473.jpg,202401080127484.jpg,202401080127485.jpg',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-08 07:27:49','2024-01-19 14:28:35'),
(7,'Acer Chromebook 315, 15.6 HD – Intel Celeron N4000','30798200','standard','C128',4,6,1,1,1,899.99,999.99,950,22,NULL,NULL,NULL,NULL,NULL,NULL,1,2,'202401080130241.png,202401080130242.png,202401080130253.png',NULL,0,NULL,NULL,0,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-08 07:30:25','2024-05-23 07:38:12'),
(8,'HP Victus 16-e00244AX GTX 1650 Gaming Laptop 16.1” FHD 144Hz','81526930','standard','C128',4,6,1,1,1,1199,1300,NULL,18,NULL,NULL,NULL,NULL,NULL,NULL,1,2,'202401080134061.png,202401080134072.png,202401080134073.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-08 07:34:08','2024-05-19 08:30:55'),
(9,'Epson Inkjet WorkForce Pro WF-3820DWF','20142029','standard','C128',2,6,1,1,1,399,559,NULL,19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401080141091.png,202401080141102.png,202401080141103.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-08 07:41:11','2024-01-19 14:44:41'),
(10,'iPhone 14 Pro 256GB Gold','29733132','standard','C128',1,1,1,1,1,990,1250,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401080143591.png,202401080144002.png,202401080144013.png,202401080144014.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-08 07:44:02','2024-01-19 14:28:35'),
(11,'Electrolux EW6F449ST PerfectCare 9 Kg Washing Machine','23279148','standard','C128',5,20,1,1,1,1500,1750,NULL,20,NULL,NULL,1,'1650','2024-01-13',NULL,1,2,'202401130329581.png,202401130330002.png,202401130330013.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-13 09:30:02','2024-01-19 14:28:35'),
(12,'GORENJE Waschmaschine WHP74EPS Waschmaschine','43879312','standard','C128',2,20,1,1,1,999,1250,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,1,2,'202401130338301.png,202401130338322.png,202401130338323.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-13 09:38:33','2024-01-19 14:28:35'),
(13,'iRobot Roomba E6 (6199) Robot Vacuum','56858702','standard','C128',4,22,1,1,1,250,349,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,1,2,'202401130343221.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-13 09:43:24','2024-01-19 14:28:35'),
(14,'Sony Bravia 55X90J 4K Ultra HD 55″ 140 Screen Google Smart LED TV','16530612','standard','C128',3,23,1,1,1,350,499,NULL,19,NULL,NULL,NULL,NULL,NULL,NULL,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-13 09:53:32','2024-01-19 14:40:16'),
(15,'Samsung 43AU7000 4K Ultra HD 43″ 109 Screen Smart LED TV','73189124','standard','C128',2,23,1,1,1,499,547,NULL,-980,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401130357131.png,202401130357152.png,202401130357153.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-13 09:57:16','2025-09-24 14:08:29'),
(16,'Apple TV HD 32GB (2nd Generation)','71493353','standard','C128',1,23,1,1,1,79,109,NULL,19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401130401491.png,202401130401522.png,202401130401533.png,202401130401544.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-13 10:01:55','2024-01-19 14:44:41'),
(17,'Apple Watch SE GPS + Cellular 40mm Space Gray','92178104','standard','C128',1,12,1,1,1,349,499,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401130410191.png,202401130410222.jpg,202401130410233.jpg',NULL,0,NULL,NULL,0,NULL,1,NULL,NULL,NULL,NULL,'Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.',NULL,NULL,1,'2024-01-13 10:10:24','2024-04-28 06:05:43'),
(18,'Xbox One Wireless Controller Black Color','93060790','standard','C128',NULL,1,1,1,1,459,599,NULL,18,NULL,NULL,NULL,NULL,NULL,NULL,1,2,'202401150808421.jpg,202401150808432.jpg',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'\r\nQuisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.\r\n',NULL,NULL,1,'2024-01-15 14:08:43','2024-01-19 14:48:33'),
(19,'Apple iPhone XS Max-64GB -white','22061536','standard','C128',1,1,1,1,1,899,1059,NULL,19,NULL,NULL,NULL,NULL,NULL,NULL,1,2,'202401150814131.jpg',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'\r\nQuisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.\r\n',NULL,NULL,1,'2024-01-15 14:14:14','2024-04-28 06:15:44'),
(20,'Apple Watch Series 8 GPS 45mm Midnight Aluminum Case','31429623','standard','C128',1,12,1,1,1,399,499,NULL,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401151009571.png,202401151009582.png,202401151009583.jpg',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'\r\nQuisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.\r\n',NULL,NULL,1,'2024-01-15 16:09:59','2025-09-24 13:53:43'),
(21,'Huawei Watch GT 2 Sport Stainless Steel 46mm','02456392','standard','C128',3,12,1,1,1,369,599,NULL,20,NULL,NULL,1,'499','2024-01-15',NULL,NULL,1,'202401151013061.png,202401151013062.png,202401151013073.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'\r\nQuisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.\r\n',NULL,NULL,1,'2024-01-15 16:13:07','2024-01-19 14:28:35'),
(22,'Samsung Galaxy Active 2 R835U Smartwatch 40mm','10203743','standard','C128',2,12,1,1,1,275,399,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401151019301.png,202401151019302.png,202401151019313.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'\r\nQuisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.\r\n',NULL,NULL,1,'2024-01-15 16:19:31','2024-01-19 14:26:49'),
(23,'Canon EOS R10 RF-S 18-45 IS STM','13929367','standard','C128',17,1,1,1,1,439,577,NULL,19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401151024231.png,202401151024232.png,202401151024233.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'\r\nQuisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.\r\n',NULL,NULL,1,'2024-01-15 16:24:24','2024-01-19 14:48:33'),
(24,'Sony A7 III Mirrorless Camera Body Only','99421096','standard','C128',2,1,1,1,1,299,379,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,1,2,'202401151026581.png,202401151026592.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'\r\nQuisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.\r\n',NULL,NULL,1,'2024-01-15 16:27:00','2024-01-19 14:26:49'),
(25,'WOLFANG GA420 Action Camera 4K 60FPS 24MP','99218280','standard','C128',4,1,1,1,1,130,157.99,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401151029321.png,202401151029332.jpg,202401151029343.jpg',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'\r\nQuisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.\r\nMorbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.\r\n',NULL,NULL,1,'2024-01-15 16:29:34','2024-01-19 14:26:48'),
(26,'Fresh Organic Navel Orange','33887520','standard','C128',NULL,29,4,4,4,2.99,3.99,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401151115301.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Fresh Organic Navel Orange',NULL,NULL,1,'2024-01-15 17:15:32','2024-01-19 14:28:35'),
(27,'Banana (pack of 12)','27583341','standard','C128',NULL,29,1,1,1,0.89,1.29,NULL,997,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401151118271.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'',NULL,NULL,1,'2024-01-15 17:18:28','2025-09-24 14:14:04'),
(28,'Water Melon ~ 3KG','19186147','standard','C128',NULL,29,1,1,1,2.39,3.3,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401151142511.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Water Melon ~ 3KG',NULL,NULL,1,'2024-01-15 17:42:53','2024-01-19 14:26:48'),
(29,'Gala Original Apple - 1KG','80912386','standard','C128',NULL,29,1,1,1,2.39,3.19,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'202401151144271.png',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'Gala Original Apple - 1KG',NULL,NULL,1,'2024-01-15 17:44:27','2025-09-24 14:06:52'),
(30,'Apple Smart Watch','12010761','standard','C128',1,12,1,1,1,100,200,NULL,9,NULL,NULL,NULL,NULL,NULL,NULL,1,1,'202401190429592.jpg',NULL,0,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,'',NULL,NULL,1,'2024-01-19 09:43:44','2025-09-24 14:06:51'),
(31,'Alpha Cheese','33357221','standard','C128',NULL,34,1,1,1,120,200,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'zummXD2dvAtI.png',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,1,'2024-04-14 06:15:06','2024-04-14 06:15:06'),
(32,'green spice','61226895','standard','C128',19,40,1,1,1,10,20,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,3,1,'zummXD2dvAtI.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,1,'2024-04-29 12:29:17','2024-04-29 12:29:17'),
(33,'BMW iX1','001','standard','C128',20,43,1,1,1,6690000,66100013,6690000,22,1,1,NULL,NULL,'2024-07-10',NULL,3,1,'202407100201121.jpg',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,'<p>The first fully electric BMW iX1 radiates electrifying determination and with its functionality and versatility provides inspiration to pursue new paths even in everyday use:<br />&nbsp;</p>\r\n<ul>\r\n<li>Self-assured presence on the exterior thanks to the monolithic design language and distinctive proportions</li>\r\n<li>Experience the strength of a 66.4 kWh battery capacity, powering your journey with lasting energy</li>\r\n<li>Modern multimedia cockpit due to the innovative BMW Curved Display with touch and voice control concept</li>\r\n</ul>\r\n<p><br />BMW iX1 xDrive30:<br />Energy consumption, combined WLTP in kWh/100 km:&nbsp;18.1 &ndash; 16.8&nbsp;<br />Electric range, WLTP in km:&nbsp;417 &ndash; 440</p>',NULL,NULL,1,'2024-07-10 18:01:12','2024-07-10 18:24:16'),
(34,'Banana','1021540','standard','C128',19,34,1,1,3,120,130,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'zummXD2dvAtI.png',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'','[\"1\"]','[null]',1,'2025-09-24 14:13:08','2025-09-24 14:13:08');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchase_product_return`
--

DROP TABLE IF EXISTS `purchase_product_return`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `purchase_product_return` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `return_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `imei_number` text DEFAULT NULL,
  `qty` double NOT NULL,
  `purchase_unit_id` int(11) NOT NULL,
  `net_unit_cost` double NOT NULL,
  `discount` double NOT NULL,
  `tax_rate` double NOT NULL,
  `tax` double NOT NULL,
  `total` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchase_product_return`
--

LOCK TABLES `purchase_product_return` WRITE;
/*!40000 ALTER TABLE `purchase_product_return` DISABLE KEYS */;
/*!40000 ALTER TABLE `purchase_product_return` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchases`
--

DROP TABLE IF EXISTS `purchases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `purchases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(191) NOT NULL,
  `user_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `currency_id` int(11) DEFAULT NULL,
  `exchange_rate` double DEFAULT NULL,
  `item` int(11) NOT NULL,
  `total_qty` double NOT NULL,
  `total_discount` double NOT NULL,
  `total_tax` double NOT NULL,
  `total_cost` double NOT NULL,
  `order_tax_rate` double DEFAULT NULL,
  `order_tax` double DEFAULT NULL,
  `order_discount` double DEFAULT NULL,
  `shipping_cost` double DEFAULT NULL,
  `grand_total` double NOT NULL,
  `paid_amount` double NOT NULL,
  `status` int(11) NOT NULL,
  `payment_status` int(11) NOT NULL,
  `document` varchar(191) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchases`
--

LOCK TABLES `purchases` WRITE;
/*!40000 ALTER TABLE `purchases` DISABLE KEYS */;
INSERT INTO `purchases` VALUES
(1,'pr-20240119-074604',1,1,1,1,1,10,100,0,2917.26,44758.8,0,0,0,0,44758.8,0,1,1,NULL,NULL,'2024-01-19 13:46:04','2024-01-19 13:46:04'),
(2,'pr-20240119-075004',1,1,1,1,1,10,100,0,3589.09,67113.7,0,0,0,0,67113.7,0,1,1,NULL,NULL,'2024-01-19 13:50:04','2024-01-19 13:50:04'),
(3,'pr-20240119-075321',1,1,NULL,1,1,10,100,0,3689.98,49653.7,0,0,0,0,49653.7,0,1,1,NULL,NULL,'2024-01-19 13:53:21','2024-01-19 13:53:21'),
(4,'pr-20240119-082648',1,2,1,NULL,NULL,10,101,0,3789.98,50753.69,0,0,0,0,50753.69,0,1,1,NULL,NULL,'2024-01-18 18:00:00','2024-01-19 14:26:48'),
(5,'pr-20240119-082826',1,2,1,NULL,NULL,10,100,0,2917.26,44758.8,0,0,0,0,44758.8,0,1,1,NULL,NULL,'2024-01-18 18:00:00','2024-01-19 14:28:26'),
(6,'pr-20240119-082835',1,2,1,NULL,NULL,10,100,0,3589.09,67113.7,0,0,0,0,67113.7,0,1,1,NULL,NULL,'2024-01-18 18:00:00','2024-01-19 14:28:35'),
(7,'pr-20240119-085202',1,1,1,NULL,NULL,2,2,0,0,748,0,0,0,0,748,0,1,1,NULL,NULL,'2024-01-19 14:52:02','2024-01-19 14:52:02'),
(8,'pr-20240204-011347',1,1,NULL,1,1,1,5,0,400,4400,0,0,0,0,4400,0,1,1,NULL,NULL,'2024-02-04 07:13:47','2024-02-04 07:13:47'),
(10,'pr-20240710-020112',1,1,NULL,NULL,NULL,1,9,0,12042000,72252000,NULL,0,NULL,NULL,72252000,72252000,1,2,NULL,NULL,'2024-07-10 18:01:12','2024-07-10 18:01:12'),
(11,'pr-20240710-020112',1,2,NULL,NULL,NULL,1,9,0,12042000,72252000,NULL,0,NULL,NULL,72252000,72252000,1,2,NULL,NULL,'2024-07-10 18:01:12','2024-07-10 18:01:12'),
(12,'pr-20240710-021412',1,1,NULL,1,1,1,3,0,4014000,24084000,20,4816800,0,100000,29000800,0,1,1,'20240710021412.png','this is this','2024-07-10 04:00:00','2024-07-10 18:14:12'),
(13,'pr-20240710-021907',1,1,NULL,1,1,1,1,0,1338000,8028000,20,1605600,0,10000,9643600,0,3,1,'20240710021907.png','this is this','2024-07-10 04:00:00','2024-07-10 18:19:07'),
(14,'pr-20250924-081404',1,1,1,1,1,1,1000,0,0,890,0,0,0,0,890,0,1,1,NULL,'Test','2025-09-22 18:00:00','2025-09-24 14:14:04');
/*!40000 ALTER TABLE `purchases` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `quotations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `quotations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(191) NOT NULL,
  `user_id` int(11) NOT NULL,
  `biller_id` int(11) NOT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `customer_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `item` int(11) NOT NULL,
  `total_qty` double NOT NULL,
  `total_discount` double NOT NULL,
  `total_tax` double NOT NULL,
  `total_price` double NOT NULL,
  `order_tax_rate` double DEFAULT NULL,
  `order_tax` double DEFAULT NULL,
  `order_discount` double DEFAULT NULL,
  `shipping_cost` double DEFAULT NULL,
  `grand_total` double NOT NULL,
  `quotation_status` int(11) NOT NULL,
  `document` varchar(191) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `quotations` WRITE;
/*!40000 ALTER TABLE `quotations` DISABLE KEYS */;
INSERT INTO `quotations` VALUES
(1,'qr-20240119-085132',1,1,1,1,1,2,2,0,0,998,0,0,NULL,NULL,998,1,NULL,NULL,'2024-01-19 14:51:32','2024-01-19 14:51:32');
/*!40000 ALTER TABLE `quotations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `return_purchases`
--

DROP TABLE IF EXISTS `return_purchases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `return_purchases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(191) NOT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `warehouse_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `account_id` int(11) NOT NULL,
  `currency_id` int(11) DEFAULT NULL,
  `exchange_rate` double DEFAULT NULL,
  `item` int(11) NOT NULL,
  `total_qty` double NOT NULL,
  `total_discount` double NOT NULL,
  `total_tax` double NOT NULL,
  `total_cost` double NOT NULL,
  `order_tax_rate` double DEFAULT NULL,
  `order_tax` double DEFAULT NULL,
  `grand_total` double NOT NULL,
  `document` varchar(191) DEFAULT NULL,
  `return_note` text DEFAULT NULL,
  `staff_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `return_purchases`
--

LOCK TABLES `return_purchases` WRITE;
/*!40000 ALTER TABLE `return_purchases` DISABLE KEYS */;
/*!40000 ALTER TABLE `return_purchases` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `returns`
--

DROP TABLE IF EXISTS `returns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `returns` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(191) NOT NULL,
  `user_id` int(11) NOT NULL,
  `sale_id` int(11) DEFAULT NULL,
  `cash_register_id` int(11) DEFAULT NULL,
  `customer_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `biller_id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `currency_id` int(11) DEFAULT NULL,
  `exchange_rate` double DEFAULT NULL,
  `item` int(11) NOT NULL,
  `total_qty` double NOT NULL,
  `total_discount` double NOT NULL,
  `total_tax` double NOT NULL,
  `total_price` double NOT NULL,
  `order_tax_rate` double DEFAULT NULL,
  `order_tax` double DEFAULT NULL,
  `grand_total` double NOT NULL,
  `document` varchar(191) DEFAULT NULL,
  `return_note` text DEFAULT NULL,
  `staff_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `returns`
--

LOCK TABLES `returns` WRITE;
/*!40000 ALTER TABLE `returns` DISABLE KEYS */;
INSERT INTO `returns` VALUES
(1,'rr-20240324-010823',1,8,2,2,1,1,1,1,1,1,1,0,118.18,1299.99,0,0,1299.99,NULL,NULL,NULL,'2024-03-24 07:08:23','2024-03-24 07:08:23'),
(2,'rr-20240429-063038',1,14,2,2,1,1,1,1,1,2,2,0,136.46,1500.99,0,0,1500.99,NULL,NULL,NULL,'2024-04-29 12:30:38','2024-04-29 12:30:38');
/*!40000 ALTER TABLE `returns` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reward_point_settings`
--

DROP TABLE IF EXISTS `reward_point_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `reward_point_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `per_point_amount` double NOT NULL,
  `minimum_amount` double NOT NULL,
  `duration` int(11) DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reward_point_settings`
--

LOCK TABLES `reward_point_settings` WRITE;
/*!40000 ALTER TABLE `reward_point_settings` DISABLE KEYS */;
INSERT INTO `reward_point_settings` VALUES
(1,300,1000,1,'Year',1,'2021-06-08 15:40:15','2021-06-27 05:20:55');
/*!40000 ALTER TABLE `reward_point_settings` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `role_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `role_has_permissions` (
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `role_has_permissions` WRITE;
/*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
INSERT INTO `role_has_permissions` VALUES
(4,1),
(4,2),
(4,4),
(5,1),
(5,2),
(6,1),
(6,2),
(6,4),
(7,1),
(7,2),
(7,4),
(8,1),
(8,2),
(8,4),
(9,1),
(9,2),
(9,4),
(10,1),
(10,2),
(11,1),
(11,2),
(12,1),
(12,2),
(12,4),
(13,1),
(13,2),
(13,4),
(14,1),
(14,2),
(15,1),
(15,2),
(16,1),
(16,2),
(17,1),
(17,2),
(18,1),
(18,2),
(19,1),
(19,2),
(20,1),
(20,2),
(20,4),
(21,1),
(21,2),
(21,4),
(22,1),
(22,2),
(22,4),
(23,1),
(23,2),
(24,1),
(24,2),
(24,4),
(25,1),
(25,2),
(25,4),
(26,1),
(26,2),
(27,1),
(27,2),
(28,1),
(28,2),
(28,4),
(29,1),
(29,2),
(29,4),
(30,1),
(30,2),
(31,1),
(31,2),
(32,1),
(32,2),
(33,1),
(33,2),
(34,1),
(34,2),
(35,1),
(35,2),
(36,1),
(36,2),
(37,1),
(37,2),
(38,1),
(38,2),
(39,1),
(39,2),
(40,1),
(40,2),
(41,1),
(41,2),
(42,1),
(42,2),
(43,1),
(43,2),
(44,1),
(44,2),
(45,1),
(45,2),
(46,1),
(46,2),
(47,1),
(47,2),
(48,1),
(48,2),
(49,1),
(49,2),
(50,1),
(50,2),
(51,1),
(51,2),
(52,1),
(52,2),
(53,1),
(53,2),
(54,1),
(54,2),
(55,1),
(55,2),
(55,4),
(56,1),
(56,2),
(56,4),
(57,1),
(57,2),
(57,4),
(58,1),
(58,2),
(59,1),
(59,2),
(60,1),
(60,2),
(61,1),
(61,2),
(62,1),
(62,2),
(63,1),
(63,2),
(63,4),
(64,1),
(64,2),
(64,4),
(65,1),
(65,2),
(66,1),
(66,2),
(67,1),
(67,2),
(68,1),
(68,2),
(69,1),
(69,2),
(70,1),
(70,2),
(71,1),
(71,2),
(72,1),
(72,2),
(73,1),
(73,2),
(74,1),
(74,2),
(75,1),
(75,2),
(76,1),
(76,2),
(77,1),
(77,2),
(78,1),
(78,2),
(79,1),
(79,2),
(80,1),
(80,2),
(81,1),
(81,2),
(82,1),
(82,2),
(83,1),
(83,2),
(84,1),
(84,2),
(85,1),
(85,2),
(86,1),
(86,2),
(87,1),
(87,2),
(88,1),
(88,2),
(89,1),
(89,2),
(89,4),
(90,1),
(90,2),
(91,1),
(91,2),
(92,1),
(92,2),
(93,1),
(93,2),
(94,1),
(94,2),
(95,1),
(95,2),
(96,1),
(96,2),
(97,1),
(97,2),
(98,1),
(98,2),
(99,1),
(99,2),
(100,1),
(100,2),
(101,1),
(101,2),
(102,1),
(102,2),
(103,1),
(103,2),
(104,1),
(104,2),
(105,1),
(105,2),
(106,1),
(106,4),
(107,1),
(108,1),
(109,1),
(110,1),
(111,1),
(112,1),
(113,1),
(114,1),
(115,1),
(116,1),
(117,1),
(118,1),
(119,1),
(120,1),
(121,1),
(122,1),
(123,1),
(124,1),
(125,1),
(126,1);
/*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `description` text DEFAULT NULL,
  `guard_name` varchar(191) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES
(1,'Admin','admin can access all data...','web',1,'2018-06-01 23:46:44','2018-06-02 23:13:05'),
(2,'Owner','Staff of shop','web',1,'2018-10-22 02:38:13','2022-02-01 13:13:30'),
(4,'staff','staff has specific acess...','web',1,'2018-06-02 00:05:27','2022-02-01 13:13:04'),
(5,'Customer',NULL,'web',1,'2020-11-05 06:43:16','2020-11-15 00:24:15');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sales`
--

DROP TABLE IF EXISTS `sales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sales` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(191) NOT NULL,
  `user_id` int(11) NOT NULL,
  `cash_register_id` int(11) DEFAULT NULL,
  `table_id` int(11) DEFAULT NULL,
  `queue` int(11) DEFAULT NULL,
  `customer_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `biller_id` int(11) DEFAULT NULL,
  `item` int(11) NOT NULL,
  `total_qty` double NOT NULL,
  `total_discount` double NOT NULL,
  `total_tax` double NOT NULL,
  `total_price` double NOT NULL,
  `grand_total` double NOT NULL,
  `currency_id` int(11) DEFAULT NULL,
  `exchange_rate` double DEFAULT NULL,
  `order_tax_rate` double DEFAULT NULL,
  `order_tax` double DEFAULT NULL,
  `order_discount_type` varchar(191) DEFAULT NULL,
  `order_discount_value` double DEFAULT NULL,
  `order_discount` double DEFAULT NULL,
  `coupon_id` int(11) DEFAULT NULL,
  `coupon_discount` double DEFAULT NULL,
  `shipping_cost` double DEFAULT NULL,
  `sale_status` int(11) NOT NULL,
  `payment_status` int(11) NOT NULL,
  `document` varchar(191) DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `sale_note` text DEFAULT NULL,
  `staff_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sales`
--

LOCK TABLES `sales` WRITE;
/*!40000 ALTER TABLE `sales` DISABLE KEYS */;
INSERT INTO `sales` VALUES
(1,'posr-20240119-084016',1,NULL,NULL,NULL,1,1,1,2,2,0,159.81,1758,1758,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,1758,NULL,NULL,'2024-01-19 14:40:16','2024-01-19 14:40:16'),
(2,'posr-20240119-084441',1,NULL,NULL,NULL,1,2,1,5,6,0,213.54,3017,3017,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,3017,NULL,NULL,'2024-01-19 14:44:41','2024-01-19 14:44:41'),
(3,'sr-20240119-084833',1,1,NULL,NULL,2,2,1,3,5,0,54.45,1182,1182,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,'2024-01-19 14:48:33','2024-01-19 14:48:33'),
(4,'sr-20240119-085242',1,2,NULL,NULL,1,1,1,3,3,0,90.82,1997,1997,NULL,NULL,0,0,'Flat',0,0,NULL,NULL,0,1,2,NULL,NULL,NULL,NULL,'2024-01-18 18:00:00','2024-01-19 14:53:31'),
(5,'posr-20240210-122224',1,2,NULL,NULL,2,1,1,1,1,0,114.45,1259,1259,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,1259,NULL,NULL,'2024-02-10 06:22:24','2024-02-10 06:22:24'),
(6,'posr-20240225-014951',1,2,NULL,NULL,2,1,1,1,1,0,118.18,1299.99,1299.99,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,1299.99,NULL,NULL,'2024-02-25 07:49:51','2024-02-25 07:49:51'),
(7,'posr-20240225-015013',1,2,NULL,NULL,2,1,1,1,2,0,236.36,2599.98,2599.98,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,2599.98,NULL,NULL,'2024-02-25 07:50:13','2024-02-25 07:50:13'),
(8,'posr-20240228-112744',1,2,NULL,NULL,2,1,1,2,2,0,232.63,2558.99,2558.99,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,2558.99,NULL,NULL,'2024-02-28 05:27:44','2024-02-28 05:27:44'),
(9,'posr-20240421-110143',1,2,1,1,2,1,1,1,1,0,31.82,350,350,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,350,NULL,NULL,'2024-04-21 05:01:43','2024-04-21 05:01:43'),
(13,'posr-20240428-121544',1,2,NULL,NULL,2,1,1,2,2,0,128.09,1409,1409,1,1,NULL,0,NULL,NULL,0,NULL,NULL,0,1,4,NULL,1409,NULL,NULL,'2024-04-28 06:15:44','2024-04-28 06:15:44'),
(14,'posr-20240429-062956',1,2,NULL,NULL,2,1,1,4,4,0,345.55,3800.99,3800.99,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,3800.99,NULL,NULL,'2024-04-29 12:29:56','2024-04-29 12:29:56'),
(15,'sr-20240505-111902',1,2,NULL,NULL,2,1,1,1,1,0,0,499,499,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,2,NULL,0,NULL,NULL,'2024-05-05 05:19:02','2024-05-05 05:20:14'),
(20,'posr-20240505-052905',1,2,NULL,NULL,2,1,1,2,2,0,231.82,2549.99,2549.99,1,1,NULL,0,NULL,NULL,0,NULL,NULL,0,1,4,NULL,2549.99,NULL,NULL,'2024-05-05 11:29:05','2024-05-05 11:29:05'),
(22,'posr-20240508-020851',1,2,NULL,NULL,2,1,1,2,2,0,122.73,1349.99,1349.99,1,1,NULL,0,NULL,NULL,0,NULL,NULL,0,1,4,NULL,1349.99,NULL,NULL,'2024-05-08 08:08:51','2024-05-08 08:08:51'),
(23,'posr-20240519-022423',1,2,NULL,NULL,2,1,1,1,1,0,118.18,1299.99,1299.99,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,1299.99,NULL,NULL,'2024-05-19 08:24:23','2024-05-19 08:24:23'),
(24,'posr-20240519-022530',1,2,NULL,NULL,2,1,1,1,1,0,118.18,1300,1300,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,1300,NULL,NULL,'2024-05-19 08:25:30','2024-05-19 08:25:30'),
(25,'posr-20240519-023055',1,2,NULL,NULL,2,1,1,1,1,0,118.18,1300,1300,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,1300,NULL,NULL,'2024-05-19 08:30:55','2024-05-19 08:30:55'),
(28,'posr-20240521-013249',1,2,NULL,NULL,2,1,1,1,1,0,95.45,1050,1050,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,1050,NULL,NULL,'2024-05-21 07:32:49','2024-05-21 07:32:49'),
(29,'posr-20240710-022416',1,2,NULL,NULL,3,1,1,1,1,0,13220002.6,79320015.6,79320015.6,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,79320015.6,'done','done','2024-07-10 04:00:00','2024-07-10 18:24:16'),
(30,'posr-20250923-125510',1,2,NULL,NULL,2,1,1,2,3,0,168.28,1850.99,1850.99,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,3,4,NULL,1850.99,NULL,NULL,'2025-09-23 06:55:10','2025-09-23 06:55:10'),
(31,'01',1,2,NULL,NULL,1,1,1,1,10,0,0,12.9,13.19,1,2,10,0.29,'Flat',10,10,NULL,NULL,10,1,1,NULL,NULL,'Test','Test','2025-08-31 18:00:00','2025-09-24 13:48:54'),
(32,'00001234',1,2,NULL,NULL,2,1,1,3,25,0,100,6102.9,6102.9,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,6102.9,'Test','Test','2025-08-31 18:00:00','2025-09-24 13:53:43'),
(33,'000012340',1,2,NULL,NULL,2,1,1,4,37,0,1529.09,16867.85,16867.85,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,16867.85,'16897','16897','2025-09-22 18:00:00','2025-09-24 14:06:49'),
(34,'posr-20250924-080829',1,2,NULL,NULL,2,1,1,1,1000,0,0,547000,547000,1,1,0,0,'Flat',NULL,0,NULL,NULL,0,1,4,NULL,547000,NULL,NULL,'2025-09-23 18:00:00','2025-09-24 14:08:29');
/*!40000 ALTER TABLE `sales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sms_templates`
--

DROP TABLE IF EXISTS `sms_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `content` text DEFAULT 'content',
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `is_default_ecommerce` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sms_templates`
--

LOCK TABLES `sms_templates` WRITE;
/*!40000 ALTER TABLE `sms_templates` DISABLE KEYS */;
INSERT INTO `sms_templates` VALUES
(1,'test template','eso nije kori...',0,0,'2024-05-19 08:14:12','2024-05-19 08:23:57'),
(2,'test template 2','fsdfsdf',1,1,'2024-05-19 08:20:25','2024-05-19 08:23:57');
/*!40000 ALTER TABLE `sms_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stock_counts`
--

DROP TABLE IF EXISTS `stock_counts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `stock_counts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(191) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `category_id` varchar(191) DEFAULT NULL,
  `brand_id` varchar(191) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `type` varchar(191) NOT NULL,
  `initial_file` varchar(191) DEFAULT NULL,
  `final_file` varchar(191) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `is_adjusted` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stock_counts`
--

LOCK TABLES `stock_counts` WRITE;
/*!40000 ALTER TABLE `stock_counts` DISABLE KEYS */;
INSERT INTO `stock_counts` VALUES
(1,'scr-20240710-020518',1,NULL,NULL,1,'full','20240710-020518.csv',NULL,NULL,0,'2024-07-10 18:05:18','2024-07-10 18:05:18'),
(2,'scr-20240710-020914',1,'43','20',1,'partial','20240710-020914.csv',NULL,NULL,0,'2024-07-10 18:09:14','2024-07-10 18:09:14');
/*!40000 ALTER TABLE `stock_counts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `suppliers`
--

DROP TABLE IF EXISTS `suppliers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `suppliers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `company_name` varchar(191) NOT NULL,
  `vat_number` varchar(191) DEFAULT NULL,
  `email` varchar(191) NOT NULL,
  `phone_number` varchar(191) NOT NULL,
  `address` varchar(191) NOT NULL,
  `city` varchar(191) NOT NULL,
  `state` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suppliers`
--

LOCK TABLES `suppliers` WRITE;
/*!40000 ALTER TABLE `suppliers` DISABLE KEYS */;
INSERT INTO `suppliers` VALUES
(1,'Abdullah',NULL,'Global Tech','31213131','abdullah@gmail.com','312313','Mirpur','Dhaka',NULL,NULL,'Bangladesh',1,'2024-01-19 13:41:37','2024-01-19 13:41:37');
/*!40000 ALTER TABLE `suppliers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tables`
--

DROP TABLE IF EXISTS `tables`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tables` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `number_of_person` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tables`
--

LOCK TABLES `tables` WRITE;
/*!40000 ALTER TABLE `tables` DISABLE KEYS */;
INSERT INTO `tables` VALUES
(1,'Table 1',3,'middle table',1,'2024-04-21 04:58:24','2024-04-21 04:58:24');
/*!40000 ALTER TABLE `tables` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `taxes`
--

DROP TABLE IF EXISTS `taxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `taxes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `rate` double NOT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `taxes`
--

LOCK TABLES `taxes` WRITE;
/*!40000 ALTER TABLE `taxes` DISABLE KEYS */;
INSERT INTO `taxes` VALUES
(1,'@10',10,1,'2024-01-08 05:26:16','2024-01-08 05:26:16'),
(2,'@15',15,1,'2024-01-08 05:26:29','2024-01-08 05:26:29'),
(3,'vat 20%',20,1,'2024-04-29 12:28:49','2024-04-29 12:28:49');
/*!40000 ALTER TABLE `taxes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transfers`
--

DROP TABLE IF EXISTS `transfers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `transfers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `reference_no` varchar(191) NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `from_warehouse_id` int(11) NOT NULL,
  `to_warehouse_id` int(11) NOT NULL,
  `item` int(11) NOT NULL,
  `total_qty` double NOT NULL,
  `total_tax` double NOT NULL,
  `total_cost` double NOT NULL,
  `shipping_cost` double DEFAULT NULL,
  `grand_total` double NOT NULL,
  `document` varchar(191) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `is_sent` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transfers`
--

LOCK TABLES `transfers` WRITE;
/*!40000 ALTER TABLE `transfers` DISABLE KEYS */;
/*!40000 ALTER TABLE `transfers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `units`
--

DROP TABLE IF EXISTS `units`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `units` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `unit_code` varchar(191) NOT NULL,
  `unit_name` varchar(191) NOT NULL,
  `base_unit` int(11) DEFAULT NULL,
  `operator` varchar(191) DEFAULT NULL,
  `operation_value` double DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `units`
--

LOCK TABLES `units` WRITE;
/*!40000 ALTER TABLE `units` DISABLE KEYS */;
INSERT INTO `units` VALUES
(1,'pc','Piece',NULL,'*',1,1,'2024-01-08 05:37:39','2024-01-08 05:37:39'),
(2,'dozen','Dozen',1,'*',12,1,'2024-01-08 05:38:27','2024-01-08 05:38:27'),
(3,'carton','Carton',1,'*',24,1,'2024-01-08 05:39:01','2024-01-08 05:39:01'),
(4,'kg','Kilogram',NULL,'*',1,1,'2024-01-08 05:39:37','2024-01-08 05:39:37'),
(5,'gm','Gram',4,'/',1000,1,'2024-01-08 05:40:00','2024-01-08 05:40:00');
/*!40000 ALTER TABLE `units` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `password` varchar(191) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `phone` varchar(191) NOT NULL,
  `company_name` varchar(191) DEFAULT NULL,
  `role_id` int(11) NOT NULL,
  `biller_id` int(11) DEFAULT NULL,
  `warehouse_id` int(11) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `is_deleted` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,'admin','ashfaqdev.php@gmail.com','$2y$10$D3NNYjFpxZ/7ve5fTVs.k.6cH5AfPyPC1JL7/G8NQoVcTPvt9nZoa','rygsD0iYHmdcqbGADghN9duHFNWB5EGPiguaJD6SWip7v7ELxoro5SRWRXF1','12112','lioncoders',1,NULL,NULL,1,0,'2018-06-02 03:24:15','2023-07-15 11:18:25'),
(3,'dhiman da','dhiman@gmail.com','$2y$10$Fef6vu5E67nm11hX7V5a2u1ThNCQ6n9DRCvRF9TD7stk.Pmt2R6O.','5ehQM6JIfiQfROgTbB5let0Z93vjLHS7rd9QD5RPNgOxli3xdo7fykU7vtTt','212','lioncoders',1,NULL,NULL,0,1,'2018-06-13 22:00:31','2020-11-05 07:06:51'),
(6,'test','test@gmail.com','$2y$10$TDAeHcVqHyCmurki0wjLZeIl1SngKX3WLOhyTiCoZG3souQfqv.LS','KpW1gYYlOFacumklO2IcRfSsbC3KcWUZzOI37gqoqM388Xie6KdhaOHIFEYm','1234','212312',4,NULL,NULL,0,1,'2018-06-23 03:05:33','2018-06-23 03:13:45'),
(8,'test','test@yahoo.com','$2y$10$hlMigidZV0j2/IPkgE/xsOSb8WM2IRlsMv.1hg1NM7kfyd6bGX3hC',NULL,'31231',NULL,4,NULL,NULL,0,1,'2018-06-24 22:35:49','2018-07-02 01:07:39'),
(9,'staff','anda@gmail.com','$2y$10$kxDbnynB6mB1e1w3pmtbSOlSxy/WwbLPY5TJpMi0Opao5ezfuQjQm','EOBWOQLzRNZHj4Qo59mIDEW4z1qk7Bewt7tgTwGSnMaGlez2Xt47zb6ReIb1','3123',NULL,4,5,1,1,0,'2018-07-02 01:08:08','2018-10-23 21:41:13'),
(10,'abul','abul@alpha.com','$2y$10$5zgB2OOMyNBNVAd.QOQIju5a9fhNnTqPx5H6s4oFlXhNiF6kXEsPq','x7HlttI5bM0vSKViqATaowHFJkLS3PHwfvl7iJdFl5Z1SsyUgWCVbLSgAoi0','1234','anda',1,NULL,NULL,0,0,'2018-09-07 23:44:48','2018-09-07 23:44:48'),
(11,'teststaff','a@a.com','$2y$10$5KNBIIhZzvvZEQEhkHaZGu.Q8bbQNfqYvYgL5N55B8Pb4P5P/b/Li','DkHDEcCA0QLfsKPkUK0ckL0CPM6dPiJytNa0k952gyTbeAyMthW3vi7IRitp','111','aa',4,5,1,0,1,'2018-10-22 02:47:56','2018-10-23 02:10:56'),
(12,'john','john@gmail.com','$2y$10$P/pN2J/uyTYNzQy2kRqWwuSv7P2f6GE/ykBwtHdda7yci3XsfOKWe','O0f1WJBVjT5eKYl3Js5l1ixMMtoU6kqrH7hbHDx9I1UCcD9CmiSmCBzHbQZg','10001',NULL,4,2,2,0,1,'2018-12-30 00:48:37','2019-03-06 04:59:49'),
(13,'jjj','test@test.com','$2y$10$/Qx3gHWYWUhlF1aPfzXaCeZA7fRzfSEyCIOnk/dcC4ejO8PsoaalG',NULL,'1213',NULL,1,NULL,NULL,0,1,'2019-01-03 00:08:31','2019-03-03 04:02:29'),
(19,'shakalaka','shakalaka@gmail.com','$2y$10$ketLWT0Ib/JXpo00eJlxoeSw.7leS8V1CUGInfbyOWT4F5.Xuo7S2',NULL,'1212','Digital image',5,NULL,NULL,1,0,'2020-11-09 00:07:16','2020-11-09 00:07:16'),
(21,'modon','modon@gmail.com','$2y$10$7VpoeGMkP8QCvL5zLwFW..6MYJ5MRumDLDoX.TTQtClS561rpFHY.',NULL,'2222','modon company',5,NULL,NULL,1,0,'2020-11-13 07:12:08','2020-11-13 07:12:08'),
(22,'dhiman','dhiman@gmail.com','$2y$10$3mPygsC6wwnDtw/Sg85IpuExtUhgaHx52Lwp7Rz0.FNfuFdfKVpRq',NULL,'+8801111111101','lioncoders',5,NULL,NULL,1,0,'2020-11-15 06:14:58','2020-11-15 06:14:58'),
(31,'mbs','mbs@gmail.com','$2y$10$6Ldm1rWEVSrlTmpjIXkeQO9KwWJz/j0FB4U.fY1oCFeax47rvttEK',NULL,'2121',NULL,4,1,2,0,0,'2021-12-29 06:40:22','2021-12-29 06:40:22'),
(39,'maja','maja@maja.com','$2y$10$lrMVhNDE9AuKhFrJIgG2y.zdtrCltR8/JB1okO0W8GsUcMjSFW7rW',NULL,'444555',NULL,4,5,2,1,0,'2022-09-14 04:37:21','2022-09-14 04:37:21'),
(42,'Tarik Iqbal','tarik_17@yahoo.co.uk','$2y$10$z2nZAsrIPrSWgPEtTY9D6.1vmkvYj4p3W3kamYvdoCDnCtlVqZp86',NULL,'',NULL,5,NULL,NULL,1,0,'2023-11-17 05:04:37','2023-11-28 15:10:11'),
(43,'support@lion-coders.com','support@lion-coders.com','$2y$10$ea.ekPLTQk0Y5087FqSbdevaN.gkEMGucgFJ13aGPEd.EqY45Y.AK',NULL,'',NULL,5,NULL,NULL,1,0,'2023-12-09 14:15:06','2023-12-09 14:15:50'),
(44,'james','jamesbond@gmail.com','$2y$10$7XCviP5GAZm6E/nlk4HQmuyw2kbhVpLbxsN6PqmNubmUKpiseGiEy',NULL,'313131','MI6',5,NULL,NULL,1,0,'2024-01-19 13:23:28','2024-01-19 13:23:28'),
(45,'frido','frido@gmail.com','$2y$10$EMD9dE3ozhXaZApMazyccOaHjwGknESTfoBi16Pl8to4cvzWRaUFa',NULL,'019555555555',NULL,1,NULL,NULL,1,0,'2024-07-10 18:31:38','2024-07-10 18:31:38'),
(46,'hope','hope@gmail.com','$2y$10$bjqwjDfboMbogykBL1FjiuSF5HstXWCeayPcwUhXOw8/f3nM3Q35e',NULL,'01300432335','ECPOS',2,NULL,NULL,1,0,'2025-09-23 08:54:11','2025-09-23 08:54:11');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `variants`
--

DROP TABLE IF EXISTS `variants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `variants` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `variants`
--

LOCK TABLES `variants` WRITE;
/*!40000 ALTER TABLE `variants` DISABLE KEYS */;
INSERT INTO `variants` VALUES
(1,'10','2025-09-24 14:13:08','2025-09-24 14:13:08');
/*!40000 ALTER TABLE `variants` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `warehouses`
--

DROP TABLE IF EXISTS `warehouses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `warehouses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `address` text NOT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `warehouses`
--

LOCK TABLES `warehouses` WRITE;
/*!40000 ALTER TABLE `warehouses` DISABLE KEYS */;
INSERT INTO `warehouses` VALUES
(1,'Shop 1','97090998',NULL,'london',1,'2024-01-19 13:28:31','2024-01-19 13:28:31'),
(2,'Shop 2','8098098',NULL,'Liverpool',1,'2024-01-19 13:28:52','2024-01-19 13:28:52');
/*!40000 ALTER TABLE `warehouses` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-05-05 15:22:39
