CREATE DATABASE  IF NOT EXISTS `ebillingapp` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `ebillingapp`;
--
-- Host: localhost    Database: ebillingapp
-- ------------------------------------------------------


--
-- Table structure for table `app-banner-slider`
--

CREATE TABLE `app-banner-slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ImgName` varchar(150) NOT NULL,
  `ImgPath` varchar(150) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app-banner-slider`
--

INSERT INTO `app-banner-slider` VALUES (20,'BANTOP-stop','imagedb/slider/banner-slider-top-DTmilk.jpg','2020-05-04 17:55:59','2020-05-04 17:55:59'),(21,'BANTOP','imagedb/slider/banner-slider-topsanitizer-combo.jpg','2020-05-07 23:25:05','2020-05-07 23:25:05'),(22,'BANTOP','imagedb/slider/banner-slider-tophandwash750-combo.jpg','2020-05-07 22:36:07','2020-05-07 22:36:07');

--
-- Table structure for table `app-single-banner`
--

CREATE TABLE `app-single-banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ImgName` varchar(11) NOT NULL,
  `ImgPath` varchar(150) NOT NULL,
  `SubCategoryName` varchar(150) DEFAULT NULL,
  `SubCategoryId` int(11) DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app-single-banner`
--

INSERT INTO `app-single-banner` VALUES (1,'ROW1','imagedb/slider/app-single-banner-1st-row.jpg','Fresh Vegetables',2,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'ROW2','imagedb/slider/app-single-banner-2nd-row.jpg','Daily Needs',11,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'ROW3','imagedb/slider/app-single-banner-3rd-row.jpg','Beauty Store',59,'0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `app-subcategory-banner`
--

CREATE TABLE `app-subcategory-banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ImgName` varchar(150) NOT NULL,
  `ImgPath` varchar(150) NOT NULL,
  `SubCategoryId` int(11) DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `app-subcategory-banner`
--

INSERT INTO `app-subcategory-banner` VALUES (4,'Buy Fruits','imagedb/slider/banner-marigold.jpg',1,'2020-01-16 00:00:00','2020-01-16 00:00:00'),(5,'Available Bread and Bun','imagedb/slider/banner-slider-top-bread.jpg',2,'2020-04-12 00:00:00','2020-04-12 00:00:00'),(6,'Available School Accessories','imagedb/slider/banner-slider-top-school.jpg',12,'2020-04-28 00:00:00','2020-04-12 00:00:00'),(7,'Prawn and Pomfret','imagedb/slider/banner-slider-top-prawn.jpg',5,'2020-05-01 00:00:00','2020-05-01 00:00:00');

--
-- Table structure for table `karloff_account_manager`
--

CREATE TABLE `karloff_account_manager` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_no` int(11) DEFAULT NULL,
  `NetAmount` float NOT NULL DEFAULT '0',
  `PromocodeDiscount` int(11) DEFAULT '0',
  `GoCashAmount` int(11) NOT NULL DEFAULT '0',
  `cash_amount` float NOT NULL DEFAULT '0',
  `card_amount` float NOT NULL DEFAULT '0',
  `paytm_amount` float NOT NULL DEFAULT '0',
  `online_amount` float NOT NULL DEFAULT '0',
  `settled` int(11) NOT NULL DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoice_no` (`invoice_no`)
) ENGINE=InnoDB AUTO_INCREMENT=6715 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_account_manager`
--

INSERT INTO `karloff_account_manager` VALUES (6697,6366,269,0,0,0,0,0,269,1,'2020-05-29 10:17:41','2020-05-29 10:17:41'),(6698,6367,542,0,0,0,0,0,542,1,'2020-05-29 10:18:09','2020-05-29 10:18:09'),(6699,6368,423,0,0,423,0,0,0,1,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(6700,6369,223,0,0,0,0,0,223,1,'2020-05-29 10:18:50','2020-05-29 10:18:50'),(6701,6370,485,0,0,0,0,0,485,1,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(6702,6371,240,0,0,0,0,0,240,1,'2020-05-29 10:37:03','2020-05-29 10:37:03'),(6703,6372,1155,0,0,1155,0,0,0,1,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(6704,6373,260,0,0,0,0,0,260,1,'2020-05-29 10:37:36','2020-05-29 10:37:36'),(6705,6374,382,0,0,382,0,0,0,1,'2020-05-29 10:59:09','2020-05-29 10:59:09'),(6706,6375,242,0,0,242,0,0,0,1,'2020-05-29 10:59:25','2020-05-29 10:59:25'),(6707,6376,418,0,0,0,418,0,0,1,'2020-06-08 15:09:49','2020-06-08 15:09:49'),(6708,6377,828,0,0,800,28,0,0,1,'2020-06-08 15:19:58','2020-06-08 15:19:58'),(6709,6378,493,0,0,493,0,0,0,1,'2020-06-08 15:24:17','2020-06-08 15:24:17'),(6710,6379,615,0,0,615,0,0,0,1,'2020-06-08 15:26:43','2020-06-08 15:26:43'),(6711,6380,488,0,0,488,0,0,0,1,'2020-06-08 15:29:31','2020-06-08 15:29:31'),(6712,6381,418,0,0,418,0,0,0,1,'2020-06-08 15:31:56','2020-06-08 15:31:56'),(6713,6382,402,0,0,0,402,0,0,1,'2020-06-09 17:13:27','2020-06-09 17:13:27'),(6714,6383,562,0,0,28,534,0,0,1,'2020-06-09 17:22:18','2020-06-09 17:22:18');

--
-- Table structure for table `karloff_address_manager`
--

CREATE TABLE `karloff_address_manager` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) NOT NULL DEFAULT '0',
  `full_name` varchar(255) DEFAULT NULL,
  `phone_no` varchar(10) NOT NULL DEFAULT '0',
  `house_no` text,
  `locality` text,
  `landmark` text,
  `city` text,
  `state` text,
  `type` enum('HOME','OFFICE') DEFAULT NULL,
  `is_default` tinyint(4) NOT NULL DEFAULT '0',
  `pincode` int(6) NOT NULL DEFAULT '0',
  `latitude` float DEFAULT '0',
  `longitude` float DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `customer_id` (`customer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_address_manager`
--

INSERT INTO `karloff_address_manager` VALUES (2,2089683698,'SUBARNA ROY','9856254722','34','DIAMOND ROAD','KAKALI ABASAN','BERHAMPORE','WEST BENGAL','HOME',0,742101,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,1123455497,'Sujoy Chandra Maitra','9475990243','43','S N Bannerjee Road','Judges Court','Berhampore','West Bengal','HOME',0,742101,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `karloff_admin`
--

CREATE TABLE `karloff_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fname` varchar(80) NOT NULL,
  `lname` varchar(80) NOT NULL,
  `nickname` varchar(50) DEFAULT NULL,
  `uname` varchar(50) NOT NULL,
  `email` varchar(150) NOT NULL,
  `adm_mobile` bigint(20) NOT NULL,
  `pwd` varchar(150) NOT NULL,
  `adm_type` int(11) NOT NULL,
  `adm_stat` int(11) NOT NULL,
  `adm_store` int(11) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uname` (`uname`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_admin`
--

INSERT INTO `karloff_admin` VALUES (40,'TAPAS',' ',NULL,'tapas','tapas@gmail.com',9999999999,'FGIj3JPnn7Vh5e6vIYXXmA==',1,1,2,'2020-05-27 19:54:39','2020-05-27 19:54:39');

--
-- Table structure for table `karloff_app_notification`
--

CREATE TABLE `karloff_app_notification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) DEFAULT NULL,
  `notification` varchar(500) DEFAULT NULL,
  `notification_img_path` varchar(500) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `action` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_app_notification`
--

INSERT INTO `karloff_app_notification` VALUES (5,'BHAGIRATHI MILK AVAILABLE','BUY MILK, PANEER, DAHI, LASSI','imagedb/notificat/5E840581666BC.jpg','2020-04-01 08:37:45',NULL),(6,'Same Day Delivery Available','BUY MILK, PANEER, DAHI, LASSI','imagedb/notificat/5E8A0EF9B2BA8.jpg','2020-04-05 22:31:45',NULL),(7,'Pujar Ful - Flower','Now Pujar Ful, Grapes, Apple, Pomegranate Available. ','imagedb/notificat/5E8BEAE6975FD.jpg','2020-04-07 08:22:22',NULL);

--
-- Table structure for table `karloff_brand`
--

CREATE TABLE `karloff_brand` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `BrandName` varchar(150) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=401 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_brand`
--

INSERT INTO `karloff_brand` VALUES (1,'PepsiCo','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'Hindustan Unilever','0000-00-00 00:00:00','0000-00-00 00:00:00'),(400,'DUKE','2020-05-27 11:40:28','2020-05-27 11:40:28');

--
-- Table structure for table `karloff_cart_items`
--

CREATE TABLE `karloff_cart_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CustomerId` bigint(20) NOT NULL,
  `ProductId` int(11) NOT NULL,
  `Quantity` int(11) NOT NULL DEFAULT '1',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_cart_items`
--


--
-- Table structure for table `karloff_category`
--

CREATE TABLE `karloff_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CategoryName` varchar(50) NOT NULL,
  `CategoryIconPath` varchar(150) DEFAULT NULL,
  `productType` tinyint(4) DEFAULT '0',
  `CategoryOrder` int(11) NOT NULL DEFAULT '0',
  `isActive` int(11) NOT NULL DEFAULT '1',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_category`
--

INSERT INTO `karloff_category` VALUES (1,'Fruits | Vegetables','imagedb/category/5D039343774C5.jpg',1,0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'Bakery | Cakes | Dairy','imagedb/category/5D0392A2CDB16.jpg',1,0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'Foodgrain | Oil | Masala','imagedb/category/5D03933BD6DFF.jpg',1,0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,'Snacks & Branded Foods','imagedb/category/5D03936C1BD85.jpg',1,0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,'Egg | Meat | Fish','imagedb/category/5DBBCCFAE3725.jpg',1,0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,'Beverage','imagedb/category/5D0392B0D70D3.jpg',1,0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,'Baby Care','imagedb/category/5D039289A28B7.jpg',1,0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,'Personal Care','imagedb/category/5D0393633EA08.jpg',1,0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,'Household Needs','imagedb/category/5D03935AD71E7.jpg',1,0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,'Gourmet & World Food','imagedb/category/5D0393527B82A.jpg',1,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,'Christmas Cake','imagedb/category/5E023905E6B9E.jpg',1,0,0,'2019-12-24 21:34:19','2019-12-24 21:34:19'),(12,'School Supplies','imagedb/category/5EA5643AB13AA.jpg',1,0,1,'2020-04-26 15:40:59','2020-04-26 15:40:59'),(13,'Garments Men','imagedb/category/5EBFF438C0A3F.jpg',2,0,1,'2020-04-26 17:43:58','2020-04-26 17:43:58'),(15,'Garments Women','imagedb/category/5EC23DA92FD3F.jpg',2,0,1,'2020-05-18 13:10:26','2020-05-18 13:10:26');

--
-- Table structure for table `karloff_club_membership`
--

CREATE TABLE `karloff_club_membership` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) NOT NULL,
  `membership_id` int(11) NOT NULL,
  `transaction_id` int(11) DEFAULT NULL,
  `expiry` date DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_club_membership`
--

INSERT INTO `karloff_club_membership` VALUES (2,1563821847,3,38,'2020-11-28',1,'2019-11-29 13:37:57','2019-11-29 13:37:57'),(3,1563821848,1,39,'2019-12-29',1,'2019-11-29 14:18:19','2019-11-29 14:18:19'),(4,1564496262,3,41,'2020-12-22',1,'2019-11-29 14:18:19','2019-11-29 14:18:19'),(5,1577160,3,0,'2020-12-22',1,'2019-11-29 14:18:19','2019-11-29 14:18:19'),(6,1573055,3,0,'2020-12-22',1,'2019-11-29 14:18:19','2019-11-29 14:18:19'),(7,1577174,3,0,'2020-12-22',1,'2019-11-29 14:18:19','2019-11-29 14:18:19'),(8,1578281,1,24,'2020-02-05',1,'2020-01-06 09:14:07','2020-01-06 09:14:07'),(9,1919147752,3,0,'2020-12-22',1,'2019-11-29 14:18:19','2019-11-29 14:18:19'),(10,1572510,3,0,'2020-12-22',1,'2019-11-29 14:18:19','2019-11-29 14:18:19'),(11,805667235,3,0,'2020-12-22',1,'2019-11-29 14:18:19','2019-11-29 14:18:19'),(12,1576178,3,0,'2020-12-22',1,'2019-11-29 14:18:19','2019-11-29 14:18:19'),(13,1576177,3,0,'2020-12-22',1,'2019-11-29 14:18:19','2019-11-29 14:18:19'),(14,1578379,1,0,'2020-02-06',1,'2019-11-29 14:18:19','2019-11-29 14:18:19'),(15,80842748527,3,49,'2021-01-10',1,'2020-01-11 21:45:36','2020-01-11 21:45:36'),(16,44650152462,3,0,'2020-02-12',1,'2020-01-13 21:45:36','2020-01-13 21:45:36'),(17,60194287467,3,0,'2020-02-12',1,'2020-01-13 21:45:36','2020-01-13 21:45:36'),(18,1564393723,1,56,'2020-02-12',1,'2020-01-13 18:37:28','2020-01-13 18:37:28'),(19,87646508773,3,68,'2021-01-16',1,'2020-01-17 22:02:11','2020-01-17 22:02:11'),(20,77155610795,1,71,'2020-02-17',1,'2020-01-18 17:52:31','2020-01-18 17:52:31'),(21,1575044,3,0,'2020-12-31',1,'2019-11-29 14:18:19','2019-11-29 14:18:19'),(22,31688494929,3,0,'2021-01-18',1,'2020-01-19 14:18:19','2020-01-19 14:18:19'),(23,1272195223,3,0,'2021-01-24',1,'2020-01-25 14:18:19','2020-01-25 14:18:19'),(24,1577126,3,0,'2021-01-24',1,'2020-01-25 14:18:19','2020-01-25 14:18:19'),(25,1577983,2,113,'2020-07-30',1,'2020-02-01 16:14:25','2020-02-01 16:14:25'),(26,1577613,1,0,'2020-03-07',1,'2020-02-08 17:52:31','2020-02-08 17:52:31'),(27,652212394961,1,161,'2020-03-13',1,'2020-02-12 15:52:08','2020-02-12 15:52:08'),(28,1577704,3,0,'2021-02-17',1,'2020-02-18 11:27:45','2020-02-18 11:27:45'),(29,84779862790,3,0,'2021-02-18',1,'2020-02-19 15:55:38','2020-02-19 15:55:38'),(30,1578453,3,0,'2021-02-19',1,'2020-02-20 11:28:20','2020-02-20 11:28:20'),(31,1445451847,1,224,'2020-03-28',1,'2020-02-27 11:51:50','2020-02-27 11:51:50'),(32,426474777315,2,257,'2020-08-31',1,'2020-03-04 22:17:14','2020-03-04 22:17:14'),(33,38728290047,1,331,'2020-04-17',1,'2020-03-18 21:39:20','2020-03-18 21:39:20'),(34,1578243,1,349,'2020-04-19',1,'2020-03-20 18:17:48','2020-03-20 18:17:48'),(35,541332159649,1,350,'2020-04-19',1,'2020-03-20 20:20:29','2020-03-20 20:20:29'),(36,21504858351,3,376,'2021-03-22',1,'2020-03-22 07:28:36','2020-03-22 07:28:36'),(37,6502576039,2,0,'2020-09-25',1,'2020-03-26 10:07:41','2020-03-26 10:07:41'),(38,394419473687,1,577,'2020-04-26',1,'2020-03-27 10:44:45','2020-03-27 10:44:45'),(39,257653682768,1,620,'2020-04-26',1,'2020-03-27 22:25:45','2020-03-27 22:25:45'),(40,256486874350,1,648,'2020-04-27',1,'2020-03-28 13:49:52','2020-03-28 13:49:52'),(41,98796497533,1,655,'2020-04-27',1,'2020-03-28 17:34:40','2020-03-28 17:34:40'),(42,49410178463,1,727,'2020-04-29',1,'2020-03-30 14:23:20','2020-03-30 14:23:20'),(43,985005691662,1,797,'2020-05-02',1,'2020-04-02 02:20:18','2020-04-02 02:20:18'),(44,276124660648,1,843,'2020-05-03',1,'2020-04-03 19:04:19','2020-04-03 19:04:19'),(45,61955711163,2,851,'2020-09-30',1,'2020-04-03 21:54:52','2020-04-03 21:54:52'),(55,257653682768,1,2028,'2020-06-11',1,'2020-05-12 00:38:46','2020-05-12 00:38:46'),(47,9582486721170,1,1086,'2020-05-10',1,'2020-04-10 16:17:47','2020-04-10 16:17:47'),(48,451653743244,2,1488,'2020-10-18',1,'2020-04-21 17:13:21','2020-04-21 17:13:21'),(49,351621898073,2,1508,'2020-10-19',1,'2020-04-22 09:42:37','2020-04-22 09:42:37'),(50,90397517246,1,1544,'2020-05-23',1,'2020-04-23 20:02:33','2020-04-23 20:02:33'),(51,2062020142531,1,1676,'2020-06-04',1,'2020-04-27 18:55:13','2020-04-27 18:55:13'),(52,98796497533,3,1720,'2021-04-29',1,'2020-04-29 10:50:32','2020-04-29 10:50:32'),(53,1572582,3,54030520,'2021-05-02',1,'2020-05-03 10:50:32','2020-05-03 10:50:32'),(54,75102776747,3,1924,'2021-05-07',1,'2020-05-07 09:30:45','2020-05-07 09:30:45'),(56,958248672117,1,2076,'2020-06-13',1,'2020-05-14 16:55:35','2020-05-14 16:55:35'),(57,67898698182,1,2086,'2020-06-14',1,'2020-05-15 03:01:25','2020-05-15 03:01:25'),(58,221504482287,1,2099,'2020-06-14',1,'2020-05-15 19:27:07','2020-05-15 19:27:07'),(59,702653047925,2,2103,'2020-11-11',1,'2020-05-15 21:06:14','2020-05-15 21:06:14'),(60,219814898399,3,0,'2021-05-21',1,'2020-05-22 14:06:14','2020-05-22 14:06:14'),(61,90397517246,1,2284,'2020-06-25',1,'2020-05-26 16:12:40','2020-05-26 16:12:40');

--
-- Table structure for table `karloff_creditor`
--

CREATE TABLE `karloff_creditor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creditor_id` bigint(20) NOT NULL,
  `creditor_name` varchar(150) NOT NULL DEFAULT 'NO_NAME',
  `creditor_address` varchar(500) NOT NULL DEFAULT 'NO_ADDRESS',
  `creditor_gst` varchar(50) NOT NULL DEFAULT '0',
  `mobile` bigint(20) NOT NULL DEFAULT '0',
  `e_mail` varchar(150) DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mobile` (`mobile`),
  UNIQUE KEY `customer_id` (`creditor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_creditor`
--

INSERT INTO `karloff_creditor` VALUES (5,1793340335,'Ram Sharma','','',9437525549,'info@karloffgo.in','0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,658919722,'Sham Kumar','DAIHATTA ROAD','GH876780689HG65',6524244577,'INFO@KARLOFF.IN','0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,1485456721,'Shanti Gopal','DAIHATTA ROAD','GH8767806BB9566',9547652312,'INFO@KARLOFF.IN','0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `karloff_customer`
--

CREATE TABLE `karloff_customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `cust_gst` varchar(50) DEFAULT NULL,
  `mobile` bigint(20) NOT NULL DEFAULT '0',
  `mobile_verified` bit(1) NOT NULL DEFAULT b'0',
  `check_premium` int(11) NOT NULL DEFAULT '0',
  `MembershipCardNo` bigint(20) DEFAULT '0',
  `MembershipCardValidFrom` date DEFAULT NULL,
  `MembershipCardValidUpto` date DEFAULT NULL,
  `pwd` varchar(250) DEFAULT 'NO_PASSWORD',
  `e_mail` varchar(150) DEFAULT NULL,
  `GoCashBalance` int(11) NOT NULL DEFAULT '0',
  `RewardPointBalance` int(11) NOT NULL DEFAULT '0',
  `referral_code` varchar(6) DEFAULT NULL,
  `unique_code` varchar(6) DEFAULT NULL,
  `token` text,
  `fcm_token` text,
  `reg_type` int(11) NOT NULL DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mobile` (`mobile`),
  UNIQUE KEY `customer_id` (`customer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_customer`
--

INSERT INTO `karloff_customer` VALUES (2,1123455497,'Kartick Chandra Mitra','1981-12-23','',9932544236,'\0',0,0,'0000-00-00','0000-00-00','','secretary@mceducation',0,0,'','','',NULL,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,1448675042,'6254210147',NULL,NULL,6254210147,'\0',0,NULL,NULL,NULL,'','',0,0,NULL,'',NULL,NULL,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,2005636096,'9732547747',NULL,NULL,9732547747,'\0',0,NULL,NULL,NULL,'NO_PASSWORD','',0,0,NULL,NULL,NULL,NULL,0,'2019-06-25 12:45:31','2019-06-25 12:45:31'),(28,2089683698,'Jatin Das',NULL,NULL,9999954545,'\0',0,1070416288843496,'2019-07-07','2020-07-06','NO_PASSWORD','jatindas@gmail.com',0,0,NULL,NULL,NULL,NULL,0,'2019-07-07 16:11:37','2019-07-07 16:11:37'),(29,227506411,'9732554545',NULL,NULL,9732554545,'\0',0,2103574553880279,'2019-07-07','2020-07-06','NO_PASSWORD','',0,0,NULL,NULL,NULL,NULL,0,'2019-07-07 16:15:01','2019-07-07 16:15:01'),(30,1475891488,'6792554545',NULL,NULL,6792554545,'\0',0,6290364464264039,'2019-07-07','2020-07-06','NO_PASSWORD','',0,0,NULL,NULL,NULL,NULL,0,'2019-07-07 16:43:56','2019-07-07 16:43:56'),(31,1001,'Tap',NULL,NULL,999,'\0',0,0,NULL,NULL,'NO_PASSWORD',NULL,0,0,NULL,NULL,NULL,NULL,0,'2020-06-02 12:52:39','2020-06-02 12:52:39'),(32,2062020142531,'Tapas',NULL,NULL,9988334455,'\0',0,0,NULL,NULL,'NO_PASSWORD',NULL,0,0,NULL,NULL,NULL,NULL,0,'2020-06-02 14:25:31','2020-06-02 14:25:31'),(33,2062020143244,'7766554433',NULL,NULL,7766554433,'\0',0,0,NULL,NULL,'NO_PASSWORD',NULL,0,0,NULL,NULL,NULL,NULL,0,'2020-06-02 14:32:44','2020-06-02 14:32:44'),(34,2062020143336,'5544332211',NULL,NULL,5544332211,'\0',0,0,NULL,NULL,'NO_PASSWORD',NULL,0,0,NULL,NULL,NULL,NULL,0,'2020-06-02 14:33:36','2020-06-02 14:33:36'),(35,2062020152532,'8877665544',NULL,NULL,8877665544,'\0',0,0,NULL,NULL,'NO_PASSWORD',NULL,0,0,NULL,NULL,NULL,NULL,0,'2020-06-02 15:25:32','2020-06-02 15:25:32');

--
-- Table structure for table `karloff_delivery_charge`
--

CREATE TABLE `karloff_delivery_charge` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `LimitStartRange` float NOT NULL DEFAULT '0',
  `LimitEndRange` float NOT NULL DEFAULT '0',
  `DeliveryCharge` float NOT NULL DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_delivery_charge`
--

INSERT INTO `karloff_delivery_charge` VALUES (1,0,100,50,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,101,200,30,'0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `karloff_delivery_slot`
--

CREATE TABLE `karloff_delivery_slot` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `OrderTimeFrom` time DEFAULT NULL,
  `OrderTimeUpto` time NOT NULL,
  `DeliverySlotFrom` time DEFAULT '00:00:00',
  `DeliverySlotUpto` time NOT NULL,
  `is_next_day` tinyint(4) NOT NULL DEFAULT '0',
  `order_limit` int(11) NOT NULL DEFAULT '0',
  `isActive` int(11) NOT NULL DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_delivery_slot`
--

INSERT INTO `karloff_delivery_slot` VALUES (1,'18:00:00','21:59:59','07:00:00','08:59:59',1,10,1,'2019-06-22 11:03:11','2019-06-22 11:03:11'),(7,'22:00:00','23:59:59','09:00:00','10:59:59',1,15,1,'2019-06-22 11:03:11','2019-06-22 11:03:11'),(8,'00:00:00','09:59:59','11:00:00','12:59:59',0,25,1,'2019-06-22 11:03:11','2019-06-22 11:03:11'),(9,'10:00:00','11:59:59','13:00:00','14:59:59',0,10,1,'2019-06-22 11:03:11','2019-06-22 11:03:11'),(10,'12:00:00','13:59:59','15:00:00','16:59:59',0,10,1,'2019-06-22 11:03:11','2019-06-22 11:03:11'),(11,'14:00:00','15:59:59','17:00:00','18:59:59',0,20,1,'2019-06-22 11:03:11','2019-06-22 11:03:11'),(12,'16:00:00','17:59:59','19:00:00','20:59:59',0,0,1,'2019-06-22 11:03:11','2019-06-22 11:03:11');

--
-- Table structure for table `karloff_deliveryboy`
--

CREATE TABLE `karloff_deliveryboy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` varchar(20) DEFAULT NULL,
  `passWord` varchar(20) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `mobileNo` bigint(10) NOT NULL DEFAULT '0',
  `latitude` float NOT NULL DEFAULT '0',
  `longitude` float NOT NULL DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_deliveryboy`
--

INSERT INTO `karloff_deliveryboy` VALUES (1,'ramu',NULL,'MUKUL',9999999999,24.5522,88.3367,'2020-05-11 15:32:52','2020-05-11 15:32:52');

--
-- Table structure for table `karloff_deliveryboystat`
--

CREATE TABLE `karloff_deliveryboystat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deliveryBoyId` int(11) DEFAULT '0',
  `orderId` bigint(20) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_deliveryboystat`
--

INSERT INTO `karloff_deliveryboystat` VALUES (1,1,5643365652,4,'2020-05-11 15:34:20','2020-05-11 15:34:20');

--
-- Table structure for table `karloff_designation`
--

CREATE TABLE `karloff_designation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `designation_title` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_designation`
--

INSERT INTO `karloff_designation` VALUES (1,'Administrator'),(2,'Senior Manager'),(3,'Cashier'),(4,'Store Keeper');

--
-- Table structure for table `karloff_gocash`
--

CREATE TABLE `karloff_gocash` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `TransactionId` varchar(50) NOT NULL DEFAULT '0',
  `order_id` bigint(20) NOT NULL,
  `CustomerId` bigint(20) NOT NULL DEFAULT '0',
  `TransactionDate` date DEFAULT NULL,
  `TransactionNote` varchar(150) DEFAULT NULL,
  `Credit` float NOT NULL DEFAULT '0',
  `Debit` float NOT NULL DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2553 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_gocash`
--

INSERT INTO `karloff_gocash` VALUES (2545,'1590601416',54017881,1577445,'2020-05-27','Payment for Order Id: 54017881',0,9,'2020-05-27 23:13:36','2020-05-27 23:13:36'),(2546,'237709973',237709973,136745370514,'2020-05-28','Amount Debited for the Payment of Subscription Product',0,44,'2020-05-28 18:10:50','2020-05-28 18:10:50'),(2547,'49453813',49453813,86825446175,'2020-05-28','Amount Debited for the Payment of Subscription Product',0,22,'2020-05-28 18:10:50','2020-05-28 18:10:50'),(2548,'203939520',203939520,77597967339,'2020-05-28','Amount Debited for the Payment of Subscription Product',0,22,'2020-05-28 18:10:50','2020-05-28 18:10:50'),(2549,'479284258',479284258,1578228,'2020-05-28','Amount Debited for the Payment of Subscription Product',0,18,'2020-05-28 18:10:51','2020-05-28 18:10:51'),(2550,'1590669925',0,51969139641,'2020-05-28','150 Points converted to Karlpay',45,0,'2020-05-28 18:15:25','2020-05-28 18:15:25'),(2551,'1590672748',0,51969139641,'2020-05-28','150 Points converted to Karlpay',45,0,'2020-05-28 19:02:28','2020-05-28 19:02:28'),(2552,'1590672788',0,51969139641,'2020-05-28','30 Points converted to Karlpay',9,0,'2020-05-28 19:03:08','2020-05-28 19:03:08');

--
-- Table structure for table `karloff_invoice_details`
--

CREATE TABLE `karloff_invoice_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(11) NOT NULL DEFAULT '0',
  `order_id` bigint(20) NOT NULL DEFAULT '0',
  `customer_id` bigint(20) NOT NULL DEFAULT '0',
  `product_id` int(11) NOT NULL DEFAULT '0',
  `product_category_id` int(11) NOT NULL DEFAULT '0',
  `product_subcategory_id` int(11) DEFAULT '0',
  `CgstPercent` float NOT NULL DEFAULT '0',
  `SgstPercent` float NOT NULL DEFAULT '0',
  `IgstPercent` float NOT NULL DEFAULT '0',
  `BaseValue` float NOT NULL DEFAULT '0',
  `CgstAmount` float NOT NULL DEFAULT '0',
  `SgstAmount` float NOT NULL DEFAULT '0',
  `IgstAmount` float NOT NULL DEFAULT '0',
  `RoundOffAmount` float NOT NULL DEFAULT '0',
  `CouponCode` varchar(50) DEFAULT NULL,
  `CouponCodeDiscount` int(11) NOT NULL DEFAULT '0',
  `CashbackCode` varchar(50) DEFAULT NULL,
  `CashbackDiscountAmount` int(11) NOT NULL DEFAULT '0',
  `subYesorNot` int(11) NOT NULL DEFAULT '0',
  `qty` int(11) NOT NULL DEFAULT '0',
  `net_amount` float NOT NULL DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65924 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_invoice_details`
--

INSERT INTO `karloff_invoice_details` VALUES (65767,6368,5227268,34945861003,359,1,2,0,0,0,9,0,0,0,0,NULL,0,NULL,0,0,1,9,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(65768,6368,5227268,34945861003,360,1,2,0,0,0,23,0,0,0,0,NULL,0,NULL,0,0,1,23,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(65769,6368,5227268,34945861003,2344,4,55,0,0,0,12.7119,1.14,1.14,0,0,NULL,0,NULL,0,0,1,15,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(65770,6368,5227268,34945861003,2309,4,55,0,0,0,8.47458,0.76,0.76,0,0,NULL,0,NULL,0,0,1,10,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(65771,6368,5227268,34945861003,2214,4,55,0,0,0,16.9492,1.53,1.53,0,0,NULL,0,NULL,0,0,1,20,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(65772,6368,5227268,34945861003,2270,4,23,0,0,0,28.5714,0.71,0.71,0,0,NULL,0,NULL,0,0,1,30,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(65773,6368,5227268,34945861003,1407,4,24,0,0,0,47.3214,2.84,2.84,0,0,NULL,0,NULL,0,0,1,53,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(65774,6368,5227268,34945861003,2224,4,21,0,0,0,39.2857,2.36,2.36,0,0,NULL,0,NULL,0,0,1,44,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(65775,6368,5227268,34945861003,1214,2,84,0,0,0,44,0,0,0,0,NULL,0,NULL,0,0,2,44,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(65776,6368,5227268,34945861003,2225,4,21,0,0,0,40.1786,2.41,2.41,0,0,NULL,0,NULL,0,0,1,45,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(65777,6368,5227268,34945861003,1220,2,11,0,0,0,123.81,3.1,3.1,0,0,NULL,0,NULL,0,0,2,130,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(65782,6369,50360246,85072915488,1112,3,43,0,0,0,19.0476,0.48,0.48,0,0,NULL,0,NULL,0,0,1,20,'2020-05-29 10:18:50','2020-05-29 10:18:50'),(65783,6369,50360246,85072915488,2228,3,10,0,0,0,23,0,0,0,0,NULL,0,NULL,0,0,1,23,'2020-05-29 10:18:50','2020-05-29 10:18:50'),(65784,6369,50360246,85072915488,1320,3,43,0,0,0,18.0952,0.45,0.45,0,0,NULL,0,NULL,0,0,1,19,'2020-05-29 10:18:50','2020-05-29 10:18:50'),(65785,6369,50360246,85072915488,1741,3,43,0,0,0,39,0,0,0,0,NULL,0,NULL,0,0,1,39,'2020-05-29 10:18:50','2020-05-29 10:18:50'),(65786,6369,50360246,85072915488,1027,3,9,0,0,0,40,2,2,0,0,NULL,0,NULL,0,0,2,44,'2020-05-29 10:18:50','2020-05-29 10:18:50'),(65787,6369,50360246,85072915488,2592,3,8,0,0,0,23.2143,1.39,1.39,0,0,NULL,0,NULL,0,0,2,26,'2020-05-29 10:18:50','2020-05-29 10:18:50'),(65788,6369,50360246,85072915488,1332,3,43,0,0,0,22.8571,0.57,0.57,0,0,NULL,0,NULL,0,0,1,24,'2020-05-29 10:18:50','2020-05-29 10:18:50'),(65789,6369,50360246,85072915488,1001,3,8,0,0,0,12.381,0.31,0.31,0,0,NULL,0,NULL,0,0,1,13,'2020-05-29 10:18:50','2020-05-29 10:18:50'),(65790,6369,50360246,85072915488,1279,3,43,0,0,0,14.2857,0.36,0.36,0,0,NULL,0,NULL,0,0,1,15,'2020-05-29 10:18:50','2020-05-29 10:18:50'),(65797,6370,53018200,1578330,377,1,2,0,0,0,25,0,0,0,0,NULL,0,NULL,0,0,1,25,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65798,6370,53018200,1578330,392,1,2,0,0,0,18,0,0,0,0,NULL,0,NULL,0,0,1,18,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65799,6370,53018200,1578330,370,1,2,0,0,0,48,0,0,0,0,NULL,0,NULL,0,0,4,48,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65800,6370,53018200,1578330,380,1,2,0,0,0,20,0,0,0,0,NULL,0,NULL,0,0,2,20,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65801,6370,53018200,1578330,1868,3,42,0,0,0,112.381,2.81,2.81,0,0,NULL,0,NULL,0,0,1,118,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65802,6370,53018200,1578330,362,1,2,0,0,0,8,0,0,0,0,NULL,0,NULL,0,0,1,8,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65803,6370,53018200,1578330,2409,9,62,0,0,0,32.2034,2.9,2.9,0,0,NULL,0,NULL,0,0,1,38,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65804,6370,53018200,1578330,1354,4,23,0,0,0,25.4237,2.29,2.29,0,0,NULL,0,NULL,0,0,1,30,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65805,6370,53018200,1578330,551,1,2,0,0,0,25,0,0,0,0,NULL,0,NULL,0,0,1,25,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65806,6370,53018200,1578330,2344,4,55,0,0,0,12.7119,1.14,1.14,0,0,NULL,0,NULL,0,0,1,15,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65807,6370,53018200,1578330,403,1,2,0,0,0,14,0,0,0,0,NULL,0,NULL,0,0,1,14,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65808,6370,53018200,1578330,382,1,2,0,0,0,20,0,0,0,0,NULL,0,NULL,0,0,1,20,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65809,6370,53018200,1578330,7,1,2,0,0,0,12,0,0,0,0,NULL,0,NULL,0,0,1,12,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65810,6370,53018200,1578330,378,1,2,0,0,0,10,0,0,0,0,NULL,0,NULL,0,0,1,10,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65811,6370,53018200,1578330,367,1,2,0,0,0,6,0,0,0,0,NULL,0,NULL,0,0,1,6,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65812,6370,53018200,1578330,360,1,2,0,0,0,69,0,0,0,0,NULL,0,NULL,0,0,3,69,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65813,6370,53018200,1578330,359,1,2,0,0,0,9,0,0,0,0,NULL,0,NULL,0,0,1,9,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(65828,6371,5137813,241453851865,2273,3,42,0,0,0,115.238,2.88,2.88,0,0,NULL,0,NULL,0,0,1,121,'2020-05-29 10:37:03','2020-05-29 10:37:03'),(65829,6371,5137813,241453851865,2270,4,23,0,0,0,28.5714,0.71,0.71,0,0,NULL,0,NULL,0,0,1,30,'2020-05-29 10:37:03','2020-05-29 10:37:03'),(65830,6371,5137813,241453851865,1354,4,23,0,0,0,25.4237,2.29,2.29,0,0,NULL,0,NULL,0,0,1,30,'2020-05-29 10:37:03','2020-05-29 10:37:03'),(65831,6371,5137813,241453851865,1229,4,23,0,0,0,27.1186,2.44,2.44,0,0,NULL,0,NULL,0,0,1,32,'2020-05-29 10:37:03','2020-05-29 10:37:03'),(65832,6371,5137813,241453851865,929,4,23,0,0,0,22.8814,2.06,2.06,0,0,NULL,0,NULL,0,0,1,27,'2020-05-29 10:37:03','2020-05-29 10:37:03'),(65835,6372,53414028,50778715080,1027,3,9,0,0,0,20,1,1,0,0,NULL,0,NULL,0,0,1,22,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65836,6372,53414028,50778715080,2273,3,42,0,0,0,115.238,2.88,2.88,0,0,NULL,0,NULL,0,0,1,121,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65837,6372,53414028,50778715080,1683,4,23,0,0,0,33.8983,3.05,3.05,0,0,NULL,0,NULL,0,0,1,40,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65838,6372,53414028,50778715080,1873,3,42,0,0,0,119.048,2.98,2.98,0,0,NULL,0,NULL,0,0,1,125,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65839,6372,53414028,50778715080,2309,4,55,0,0,0,33.8983,3.05,3.05,0,0,NULL,0,NULL,0,0,4,40,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65840,6372,53414028,50778715080,1218,3,42,0,0,0,71.4286,4.29,4.29,0,0,NULL,0,NULL,0,0,1,80,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65841,6372,53414028,50778715080,1050,3,10,0,0,0,215,0,0,0,0,NULL,0,NULL,0,0,1,215,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65842,6372,53414028,50778715080,1320,3,43,0,0,0,18.0952,0.45,0.45,0,0,NULL,0,NULL,0,0,1,19,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65843,6372,53414028,50778715080,1725,3,10,0,0,0,48,0,0,0,0,NULL,0,NULL,0,0,1,48,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65844,6372,53414028,50778715080,1446,8,30,0,0,0,8.47458,0.76,0.76,0,0,NULL,0,NULL,0,0,1,10,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65845,6372,53414028,50778715080,1220,2,11,0,0,0,123.81,3.1,3.1,0,0,NULL,0,NULL,0,0,2,130,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65846,6372,53414028,50778715080,2374,8,30,0,0,0,12.7119,1.14,1.14,0,0,NULL,0,NULL,0,0,3,15,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65847,6372,53414028,50778715080,1436,8,30,0,0,0,66.1017,5.95,5.95,0,0,NULL,0,NULL,0,0,1,78,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65848,6372,53414028,50778715080,2291,3,43,0,0,0,53,0,0,0,0,NULL,0,NULL,0,0,1,53,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65849,6372,53414028,50778715080,2393,4,23,0,0,0,12.7119,1.14,1.14,0,0,NULL,0,NULL,0,0,3,15,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65850,6372,53414028,50778715080,2270,4,23,0,0,0,28.5714,0.71,0.71,0,0,NULL,0,NULL,0,0,1,30,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65851,6372,53414028,50778715080,1290,3,43,0,0,0,22.8571,0.57,0.57,0,0,NULL,0,NULL,0,0,1,24,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65852,6372,53414028,50778715080,1212,2,84,0,0,0,90,0,0,0,0,NULL,0,NULL,0,0,5,90,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(65866,6373,5254018,529850189578,1220,2,11,0,0,0,247.619,6.19,6.19,0,0,NULL,0,NULL,0,0,4,260,'2020-05-29 10:37:36','2020-05-29 10:37:36'),(65867,6374,50941743,483128003826,1126,3,43,0,0,0,29.5238,0.74,0.74,0,0,NULL,0,NULL,0,0,1,31,'2020-05-29 10:59:09','2020-05-29 10:59:09'),(65868,6374,50941743,483128003826,1316,3,43,0,0,0,21.9048,0.55,0.55,0,0,NULL,0,NULL,0,0,1,23,'2020-05-29 10:59:09','2020-05-29 10:59:09'),(65869,6374,50941743,483128003826,1311,3,43,0,0,0,4.7619,0.12,0.12,0,0,NULL,0,NULL,0,0,1,5,'2020-05-29 10:59:09','2020-05-29 10:59:09'),(65870,6374,50941743,483128003826,1298,3,43,0,0,0,30,0,0,0,0,NULL,0,NULL,0,0,1,30,'2020-05-29 10:59:09','2020-05-29 10:59:09'),(65871,6374,50941743,483128003826,91,3,43,0,0,0,17.1429,0.43,0.43,0,0,NULL,0,NULL,0,0,1,18,'2020-05-29 10:59:09','2020-05-29 10:59:09'),(65872,6374,50941743,483128003826,2099,4,22,0,0,0,152.542,13.73,13.73,0,0,NULL,0,NULL,0,0,1,180,'2020-05-29 10:59:09','2020-05-29 10:59:09'),(65873,6374,50941743,483128003826,2214,4,55,0,0,0,33.8983,3.05,3.05,0,0,NULL,0,NULL,0,0,2,40,'2020-05-29 10:59:09','2020-05-29 10:59:09'),(65874,6374,50941743,483128003826,1385,4,23,0,0,0,23.8095,0.6,0.6,0,0,NULL,0,NULL,0,0,1,25,'2020-05-29 10:59:09','2020-05-29 10:59:09'),(65875,6374,50941743,483128003826,921,4,23,0,0,0,25.4237,2.29,2.29,0,0,NULL,0,NULL,0,0,1,30,'2020-05-29 10:59:09','2020-05-29 10:59:09'),(65882,6375,55828221,928693191219,2035,3,8,0,0,0,190.476,4.76,4.76,0,0,NULL,0,NULL,0,0,5,200,'2020-05-29 10:59:25','2020-05-29 10:59:25'),(65883,6375,55828221,928693191219,2042,3,43,0,0,0,17.1429,0.43,0.43,0,0,NULL,0,NULL,0,0,1,18,'2020-05-29 10:59:25','2020-05-29 10:59:25'),(65884,6375,55828221,928693191219,1770,3,43,0,0,0,24,0,0,0,0,NULL,0,NULL,0,0,2,24,'2020-05-29 10:59:25','2020-05-29 10:59:25'),(65885,6376,2020060714015840,2005636096,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,0,1,199,'2020-06-08 15:09:49','2020-06-08 15:09:49'),(65886,6376,2020060714015840,2005636096,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,0,1,134,'2020-06-08 15:09:49','2020-06-08 15:09:49'),(65887,6376,2020060714015840,2005636096,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,0,1,85,'2020-06-08 15:09:49','2020-06-08 15:09:49'),(65888,6377,2020060713530440,2005636096,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,0,1,199,'2020-06-08 15:19:58','2020-06-08 15:19:58'),(65889,6377,2020060713530440,2005636096,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,0,1,134,'2020-06-08 15:19:58','2020-06-08 15:19:58'),(65890,6377,2020060713530440,2005636096,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,0,1,85,'2020-06-08 15:19:58','2020-06-08 15:19:58'),(65891,6377,2020060713530440,2005636096,2063,8,38,0,0,0,336.2,36.9,36.9,0,0,NULL,0,NULL,0,0,1,410,'2020-06-08 15:19:58','2020-06-08 15:19:58'),(65895,6378,2020060623073940,2005636096,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,0,1,199,'2020-06-08 15:24:17','2020-06-08 15:24:17'),(65896,6378,2020060623073940,2005636096,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,0,1,134,'2020-06-08 15:24:17','2020-06-08 15:24:17'),(65897,6378,2020060623073940,2005636096,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,0,1,85,'2020-06-08 15:24:17','2020-06-08 15:24:17'),(65898,6378,2020060623073940,2005636096,253,6,19,0,0,0,50.4,9.8,9.8,0,0,NULL,0,NULL,0,0,1,70,'2020-06-08 15:24:17','2020-06-08 15:24:17'),(65899,6378,2020060623073940,2005636096,2374,8,30,0,0,0,4.1,0.45,0.45,0,0,NULL,0,NULL,0,0,1,5,'2020-06-08 15:24:17','2020-06-08 15:24:17'),(65902,6379,2020060623020040,2005636096,2378,8,37,0,0,0,20.5,2.25,2.25,0,0,NULL,0,NULL,0,0,1,25,'2020-06-08 15:26:43','2020-06-08 15:26:43'),(65903,6379,2020060623020040,2005636096,2420,8,30,0,0,0,176.3,19.35,19.35,0,0,NULL,0,NULL,0,0,1,215,'2020-06-08 15:26:43','2020-06-08 15:26:43'),(65904,6379,2020060623020040,2005636096,2421,8,30,0,0,0,176.3,19.35,19.35,0,0,NULL,0,NULL,0,0,1,215,'2020-06-08 15:26:43','2020-06-08 15:26:43'),(65905,6379,2020060623020040,2005636096,2422,4,24,0,0,0,140.8,9.6,9.6,0,0,NULL,0,NULL,0,0,1,160,'2020-06-08 15:26:43','2020-06-08 15:26:43'),(65909,6380,2020060622400940,2005636096,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,0,1,134,'2020-06-08 15:29:31','2020-06-08 15:29:31'),(65910,6380,2020060622400940,2005636096,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,0,1,85,'2020-06-08 15:29:31','2020-06-08 15:29:31'),(65911,6380,2020060622400940,2005636096,253,6,19,0,0,0,50.4,9.8,9.8,0,0,NULL,0,NULL,0,0,1,70,'2020-06-08 15:29:31','2020-06-08 15:29:31'),(65912,6380,2020060622400940,2005636096,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,0,1,199,'2020-06-08 15:29:31','2020-06-08 15:29:31'),(65916,6381,2020060622293340,2005636096,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,0,1,85,'2020-06-08 15:31:56','2020-06-08 15:31:56'),(65917,6381,2020060622293340,2005636096,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,0,1,134,'2020-06-08 15:31:56','2020-06-08 15:31:56'),(65918,6381,2020060622293340,2005636096,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,0,1,199,'2020-06-08 15:31:56','2020-06-08 15:31:56'),(65919,6382,2020060617165140,2005636096,2044,8,37,0,0,0,329.64,36.18,36.18,0,0,NULL,0,NULL,0,0,3,402,'2020-06-09 17:13:27','2020-06-09 17:13:27'),(65920,6383,2020060617132240,2005636096,2044,8,37,0,0,0,329.64,36.18,36.18,0,0,NULL,0,NULL,0,0,3,402,'2020-06-09 17:22:18','2020-06-09 17:22:18'),(65921,6383,2020060617132240,2005636096,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,0,1,85,'2020-06-09 17:22:18','2020-06-09 17:22:18'),(65922,6383,2020060617132240,2005636096,253,6,19,0,0,0,50.4,9.8,9.8,0,0,NULL,0,NULL,0,0,1,70,'2020-06-09 17:22:18','2020-06-09 17:22:18'),(65923,6383,2020060617132240,2005636096,2374,8,30,0,0,0,4.1,0.45,0.45,0,0,NULL,0,NULL,0,0,1,5,'2020-06-09 17:22:18','2020-06-09 17:22:18');

--
-- Table structure for table `karloff_invoice_master`
--

CREATE TABLE `karloff_invoice_master` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(11) NOT NULL DEFAULT '0',
  `order_id` bigint(20) NOT NULL DEFAULT '0',
  `customer_id` bigint(20) NOT NULL DEFAULT '0',
  `delivery_charge` int(11) NOT NULL DEFAULT '0',
  `GoCashPay` int(11) NOT NULL DEFAULT '0',
  `Promocode` varchar(25) DEFAULT NULL,
  `PromocodeDiscount` int(11) NOT NULL DEFAULT '0',
  `PromoDiscBasePrice` float NOT NULL DEFAULT '0',
  `PromoDiscGST` float NOT NULL DEFAULT '0',
  `CouponCodeTotalDiscount` int(11) NOT NULL DEFAULT '0',
  `CashbackTotalDiscount` int(11) NOT NULL DEFAULT '0',
  `discount_amount` float NOT NULL DEFAULT '0',
  `RedeemAmount` int(11) NOT NULL DEFAULT '0',
  `RewardAmount` int(11) NOT NULL DEFAULT '0',
  `BaseValue` float NOT NULL DEFAULT '0',
  `CgstAmount` float NOT NULL DEFAULT '0',
  `SgstAmount` float NOT NULL DEFAULT '0',
  `IgstAmount` float NOT NULL DEFAULT '0',
  `InvoiceAmount` float NOT NULL DEFAULT '0',
  `NetAmount` float NOT NULL DEFAULT '0',
  `round_off_amount` float NOT NULL DEFAULT '0',
  `order_status` int(11) NOT NULL DEFAULT '0',
  `payment_code` varchar(25) NOT NULL DEFAULT 'TXN_NOT_COMPLETE',
  `InvoiceDate` date DEFAULT NULL,
  `InvoiceDatetime` bigint(20) DEFAULT NULL,
  `InvoiceCancelDate` date DEFAULT NULL,
  `InvoiceCancelDatetime` bigint(20) DEFAULT NULL,
  `order_receive_date` date DEFAULT NULL,
  `order_receive_datetime` bigint(20) DEFAULT NULL,
  `delivery_date` varchar(150) DEFAULT NULL,
  `address_id` int(11) NOT NULL DEFAULT '0',
  `TxnId` int(11) DEFAULT NULL COMMENT 'ID value from karloff_transaction',
  `sale_point` varchar(50) DEFAULT NULL,
  `sales_person` int(11) NOT NULL DEFAULT '0',
  `sale_type` int(11) NOT NULL DEFAULT '0',
  `token_no` int(11) NOT NULL DEFAULT '0',
  `cause_of_cancel` varchar(250) DEFAULT NULL,
  `SubscriptionYorNo` int(11) NOT NULL DEFAULT '0',
  `CancelledBy` int(11) NOT NULL DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_id` (`order_id`),
  UNIQUE KEY `invoice_id` (`invoice_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6760 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_invoice_master`
--

INSERT INTO `karloff_invoice_master` VALUES (6743,6367,50854981,644488618132,0,0,'',0,0,0,0,0,0,0,0,473.007,34.49,34.49,0,542,542,0,3,'TXN_SUCCESS','2020-05-29',1590727689,NULL,NULL,'2020-05-28',1590679628,'29 May, 09:00 am - 10:59 am',1127,2319,'2',34,1,0,NULL,0,0,'2020-05-29 10:18:09','2020-05-29 10:18:09'),(6744,6368,5227268,34945861003,0,0,'',0,0,0,0,0,0,0,0,393.3,14.85,14.85,0,423,423,0,3,'TXN_COD','2020-05-29',1590727715,NULL,NULL,'2020-05-28',1590681802,'29 May, 09:00 am - 10:59 am',471,0,'2',34,1,0,NULL,0,0,'2020-05-29 10:18:35','2020-05-29 10:18:35'),(6745,6369,50360246,85072915488,0,0,'',0,0,0,0,0,0,0,0,211.89,5.555,5.555,0,223,223,0,3,'TXN_SUCCESS','2020-05-29',1590727730,NULL,NULL,'2020-05-29',1590726243,'29 May, 11:00 am - 12:59 pm',740,2327,'2',34,1,0,NULL,0,0,'2020-05-29 10:18:50','2020-05-29 10:18:50'),(6746,6370,53018200,1578330,0,0,'',0,0,0,0,0,0,0,0,466.71,9.145,9.145,0,485,485,0,3,'TXN_SUCCESS','2020-05-29',1590728779,NULL,NULL,'2020-05-28',1590680010,'29 May, 09:00 am - 10:59 am',89,2320,'2',34,1,0,NULL,0,0,'2020-05-29 10:36:19','2020-05-29 10:36:19'),(6747,6371,5137813,241453851865,0,0,'',0,0,0,0,0,0,0,0,219.23,10.385,10.385,0,240,240,0,3,'TXN_SUCCESS','2020-05-29',1590728823,NULL,NULL,'2020-05-28',1590681913,'29 May, 09:00 am - 10:59 am',876,2323,'2',34,1,0,NULL,0,0,'2020-05-29 10:37:03','2020-05-29 10:37:03'),(6748,6372,53414028,50778715080,0,0,'',0,0,0,0,0,0,0,0,1092.85,31.075,31.075,0,1155,1155,0,3,'TXN_COD','2020-05-29',1590728839,NULL,NULL,'2020-05-28',1590677494,'29 May, 09:00 am - 10:59 am',528,0,'2',34,1,0,NULL,0,0,'2020-05-29 10:37:20','2020-05-29 10:37:20'),(6749,6373,5254018,529850189578,0,0,'',0,0,0,0,0,0,0,0,247.62,6.19,6.19,0,260,260,0,3,'TXN_SUCCESS','2020-05-29',1590728856,NULL,NULL,'2020-05-29',1590719245,'29 May, 11:00 am - 12:59 pm',765,2325,'2',34,1,0,NULL,0,0,'2020-05-29 10:37:36','2020-05-29 10:37:36'),(6750,6374,50941743,483128003826,0,0,'',0,0,0,0,0,0,0,0,339.007,21.51,21.51,0,382,382,0,3,'TXN_COD','2020-05-29',1590730149,NULL,NULL,'2020-05-28',1590666549,'29 May, 11:00 am - 12:59 pm',720,0,'2',34,1,0,NULL,0,0,'2020-05-29 10:59:09','2020-05-29 10:59:09'),(6751,6375,55828221,928693191219,0,0,'',0,0,0,0,0,0,0,0,231.62,5.19,5.19,0,242,242,0,3,'TXN_COD','2020-05-29',1590730165,NULL,NULL,'2020-05-29',1590692698,'29 May, 11:00 am - 12:59 pm',529,0,'2',34,1,0,NULL,0,0,'2020-05-29 10:59:25','2020-05-29 10:59:25'),(6752,6376,2020060714015840,2005636096,0,0,NULL,0,0,0,0,0,0,0,0,334.26,41.87,41.87,0,418,418,0,5,'0','2020-06-08',NULL,NULL,NULL,'2020-06-07',NULL,'2020-06-08',0,NULL,'2',40,3,0,NULL,0,0,'2020-06-08 15:09:49','2020-06-08 15:09:49'),(6753,6377,2020060713530440,2005636096,0,0,NULL,0,0,0,0,0,0,0,0,670.46,78.77,78.77,0,828,828,0,5,'0','2020-06-08',NULL,NULL,NULL,'2020-06-07',NULL,'2020-06-08',0,NULL,'2',40,3,0,NULL,0,0,'2020-06-08 15:19:58','2020-06-08 15:19:58'),(6754,6378,2020060623073940,2005636096,0,0,NULL,0,0,0,0,0,0,0,0,388.76,52.12,52.12,0,493,493,0,5,'0','2020-06-08',NULL,NULL,NULL,'2020-06-06',NULL,'2020-06-08',0,NULL,'2',40,3,0,NULL,0,0,'2020-06-08 15:24:17','2020-06-08 15:24:17'),(6755,6379,2020060623020040,2005636096,0,0,NULL,0,0,0,0,0,0,0,0,513.9,50.55,50.55,0,615,615,0,5,'0','2020-06-08',NULL,NULL,NULL,'2020-06-06',NULL,'2020-06-08',0,NULL,'2',40,3,0,NULL,0,0,'2020-06-08 15:26:43','2020-06-08 15:26:43'),(6756,6380,2020060622400940,2005636096,0,0,NULL,0,0,0,0,0,0,0,0,384.66,51.67,51.67,0,488,488,0,5,'0','2020-06-08',NULL,NULL,NULL,'2020-06-06',NULL,'2020-06-08',0,NULL,'2',40,3,0,NULL,0,0,'2020-06-08 15:29:31','2020-06-08 15:29:31'),(6757,6381,2020060622293340,2005636096,0,0,NULL,0,0,0,0,0,0,0,0,334.26,41.87,41.87,0,418,418,0,5,'0','2020-06-08',NULL,NULL,NULL,'2020-06-06',NULL,'2020-06-08',0,NULL,'2',40,3,0,NULL,0,0,'2020-06-08 15:31:56','2020-06-08 15:31:56'),(6758,6382,2020060617165140,2005636096,0,0,NULL,0,0,0,0,0,0,0,0,329.64,36.18,36.18,0,402,402,0,5,'0','2020-06-09',NULL,NULL,NULL,'2020-06-06',NULL,'2020-06-09',0,NULL,'2',40,3,0,NULL,0,0,'2020-06-09 17:13:27','2020-06-09 17:13:27'),(6759,6383,2020060617132240,2005636096,0,0,NULL,0,0,0,0,0,0,0,0,445.34,58.33,58.33,0,562,562,0,5,'0','2020-06-09',NULL,NULL,NULL,'2020-06-06',NULL,'2020-06-09',0,NULL,'2',40,3,0,NULL,0,0,'2020-06-09 17:22:18','2020-06-09 17:22:18');

--
-- Table structure for table `karloff_membership`
--

CREATE TABLE `karloff_membership` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text NOT NULL,
  `days` int(11) NOT NULL,
  `price` float NOT NULL,
  `sale_price` float NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_membership`
--

INSERT INTO `karloff_membership` VALUES (1,'Silver','Free Delivery\r\nNo Minimum Purchase Amount\r\nOne Month Validity',30,200,100,1,'2019-10-30 12:20:41','2019-10-30 12:20:41'),(2,'Gold','Free Delivery\r\nNo Minimum Purchase Amount\r\nSix Month Validity',180,600,300,1,'2019-10-30 12:20:41','2019-10-30 12:20:41'),(3,'Platinum','Free Delivery\r\nNo Minimum Purchase Amount\r\nTwelve Month Validity',365,1200,500,1,'2019-10-30 12:21:17','2019-10-30 12:21:17');

--
-- Table structure for table `karloff_metadata`
--

CREATE TABLE `karloff_metadata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `meta_key` varchar(50) DEFAULT NULL,
  `meta_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_metadata`
--

INSERT INTO `karloff_metadata` VALUES (2,'referral_points','5');

--
-- Table structure for table `karloff_notify_me`
--

CREATE TABLE `karloff_notify_me` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) NOT NULL,
  `product_id` int(11) NOT NULL,
  `is_notified` tinyint(4) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2917 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_notify_me`
--

INSERT INTO `karloff_notify_me` VALUES (2911,189393727918,1792,0,'2020-05-27 18:42:48','2020-05-27 18:42:48'),(2912,221562375626,2267,0,'2020-05-28 10:00:17','2020-05-28 10:00:17'),(2913,55820839957,374,0,'2020-05-28 12:21:49','2020-05-28 12:21:49'),(2914,790019468614,1214,0,'2020-05-28 16:18:40','2020-05-28 16:18:40'),(2915,47655197811,2141,0,'2020-05-28 19:24:34','2020-05-28 19:24:34'),(2916,112848950970,1527,0,'2020-05-29 10:45:57','2020-05-29 10:45:57');

--
-- Table structure for table `karloff_offer`
--

CREATE TABLE `karloff_offer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `OfferTitle` varchar(500) NOT NULL,
  `Description` varchar(1500) NOT NULL,
  `ImagePath` varchar(150) NOT NULL DEFAULT 'NO_IMAGE_PATH',
  `StartDate` date DEFAULT NULL,
  `EndDate` date DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_offer`
--

INSERT INTO `karloff_offer` VALUES (1,'karlPay Offer','GET Rs.200 CASHBACK ON RECHARGE OF Rs.2000 and GET Rs.50 CASHBACK ON RECHARGE OF Rs.500','imagedb/notificat/karlpay-offer-01-01.jpg','2019-06-27','2020-01-31','2019-06-27 06:15:32','2019-06-27 06:15:32'),(2,'Offer on Onion','Flat 60% OFF on Onion','imagedb/notificat/Onion-offer1-01.jpg','2019-06-11','2020-01-31','2019-06-27 06:15:32','2019-06-27 06:15:32');

--
-- Table structure for table `karloff_order_status`
--

CREATE TABLE `karloff_order_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status_name` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_order_status`
--

INSERT INTO `karloff_order_status` VALUES (0,'Failed'),(1,'New'),(2,'Viewed'),(3,'Processing'),(4,'Dispatched'),(5,'Delivered'),(6,'Cancelled'),(7,'Initialized'),(8,'Processed');

--
-- Table structure for table `karloff_packingdb`
--

CREATE TABLE `karloff_packingdb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `packing_name` varchar(50) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=345 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_packingdb`
--

INSERT INTO `karloff_packingdb` VALUES (5,'1 Kg','0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,'2 Kg','0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,'5 Kg','0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,'100 Gm','0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,'150 Gm','0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,'200 Gm','0000-00-00 00:00:00','0000-00-00 00:00:00'),(12,'250 Gm','0000-00-00 00:00:00','0000-00-00 00:00:00'),(13,'300 gm','0000-00-00 00:00:00','0000-00-00 00:00:00'),(14,'500 Gm','0000-00-00 00:00:00','0000-00-00 00:00:00'),(15,'Pack of 6','0000-00-00 00:00:00','0000-00-00 00:00:00'),(16,'Pack of 3','0000-00-00 00:00:00','0000-00-00 00:00:00'),(17,'400 gm','0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,'Pack of 1','0000-00-00 00:00:00','0000-00-00 00:00:00'),(19,'Pack of 2','0000-00-00 00:00:00','0000-00-00 00:00:00'),(20,'Pack of 4','0000-00-00 00:00:00','0000-00-00 00:00:00'),(21,'Pack of 5','0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,'200 ml','0000-00-00 00:00:00','0000-00-00 00:00:00'),(23,'250 ml','0000-00-00 00:00:00','0000-00-00 00:00:00'),(24,'100 ml','0000-00-00 00:00:00','0000-00-00 00:00:00'),(25,'Pack of 76','0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,'Pack of 120','0000-00-00 00:00:00','0000-00-00 00:00:00'),(27,'Pack of 50','0000-00-00 00:00:00','0000-00-00 00:00:00'),(28,'Pack of 8','0000-00-00 00:00:00','0000-00-00 00:00:00'),(29,'47 gm','0000-00-00 00:00:00','0000-00-00 00:00:00'),(30,'1 Litre','0000-00-00 00:00:00','0000-00-00 00:00:00'),(31,'25 gm','0000-00-00 00:00:00','0000-00-00 00:00:00'),(32,'50 gm','0000-00-00 00:00:00','0000-00-00 00:00:00'),(34,'750 ml','0000-00-00 00:00:00','0000-00-00 00:00:00'),(35,'2 Litre','0000-00-00 00:00:00','0000-00-00 00:00:00'),(36,'Pack of 24','0000-00-00 00:00:00','0000-00-00 00:00:00'),(37,'XXL Size, 12 pcs Pouch','2019-07-12 10:42:29','2019-07-12 10:42:29'),(38,'X-Large, 38 pcs','2019-07-12 11:03:08','2019-07-12 11:03:08'),(39,'80 pcs','2019-07-12 11:19:33','2019-07-12 11:19:33'),(40,'XXXL, 7 pcs Pouch','2019-07-12 11:36:26','2019-07-12 11:36:26'),(41,'64','2019-07-12 14:49:36','2019-07-12 14:49:36'),(42,'36','2019-07-12 15:14:35','2019-07-12 15:14:35'),(43,'60','2019-07-12 15:27:07','2019-07-12 15:27:07'),(44,'10','2019-07-12 15:50:21','2019-07-12 15:50:21'),(45,'26','2019-07-12 18:22:50','2019-07-12 18:22:50'),(46,'11','2019-07-13 17:26:23','2019-07-13 17:26:23'),(47,'20','2019-07-13 17:52:21','2019-07-13 17:52:21'),(48,'18','2019-07-13 18:55:41','2019-07-13 18:55:41'),(49,'54','2019-07-15 14:57:02','2019-07-15 14:57:02'),(50,'8','2019-07-15 16:11:34','2019-07-15 16:11:34'),(51,'123','2019-07-15 16:31:27','2019-07-15 16:31:27'),(52,'9','2019-07-15 17:00:03','2019-07-15 17:00:03'),(53,'46','2019-07-15 17:15:27','2019-07-15 17:15:27'),(54,'75 gms','2019-07-15 19:06:31','2019-07-15 19:06:31'),(55,'125 ml','2019-07-16 13:03:06','2019-07-16 13:03:06'),(56,'220 ml','2019-07-16 13:10:08','2019-07-16 13:10:08'),(57,'1 pc','2019-07-16 14:28:49','2019-07-16 14:28:49'),(58,'400 ml','2019-07-16 14:46:31','2019-07-16 14:46:31'),(59,'150 ml','2019-07-16 15:53:48','2019-07-16 15:53:48'),(60,'475 ml','2019-07-16 16:15:20','2019-07-16 16:15:20'),(61,'165 ml','2019-07-16 16:19:18','2019-07-16 16:19:18'),(62,'3 pcs','2019-07-16 16:28:11','2019-07-16 16:28:11'),(63,'240 ml','2019-07-16 17:26:13','2019-07-16 17:26:13'),(64,'50 ml','2019-07-16 17:34:02','2019-07-16 17:34:02'),(65,'1 pc 7 pck','2019-07-16 19:22:54','2019-07-16 19:22:54'),(66,'75 Stems','2019-07-17 11:39:05','2019-07-17 11:39:05'),(67,'500 ml','2019-07-17 11:51:54','2019-07-17 11:51:54'),(68,'72 pcs','2019-07-17 12:37:03','2019-07-17 12:37:03'),(69,'120 ml','2019-07-17 13:03:31','2019-07-17 13:03:31'),(70,'750 gm','2019-07-17 17:28:48','2019-07-17 17:28:48'),(71,'1.2 L','2019-07-17 17:31:47','2019-07-17 17:31:47'),(72,'450 gm','2019-07-17 18:07:42','2019-07-17 18:07:42'),(73,'623 gm','2019-07-17 18:25:06','2019-07-17 18:25:06'),(74,'1.25 ml','2019-07-18 17:41:55','2019-07-18 17:41:55'),(75,'300 ml','2019-07-18 17:42:09','2019-07-18 17:42:09'),(76,'1.25 l','2019-07-18 17:46:00','2019-07-18 17:46:00'),(77,'600 ml','2019-07-18 18:00:20','2019-07-18 18:00:20'),(78,'1.75 ml','2019-07-18 18:34:04','2019-07-18 18:34:04'),(79,'225 ml','2019-07-18 19:14:54','2019-07-18 19:14:54'),(80,'32 glasses','2019-07-19 12:12:45','2019-07-19 12:12:45'),(81,'400 g','2019-07-19 13:04:40','2019-07-19 13:04:40'),(82,'280 gm','2019-07-19 13:50:40','2019-07-19 13:50:40'),(83,'45 gm','2019-07-19 14:06:00','2019-07-19 14:06:00'),(84,'140 gm','2019-07-19 14:20:12','2019-07-19 14:20:12'),(85,'40 gm','2019-07-19 14:52:09','2019-07-19 14:52:09'),(86,'25 pcs','2019-07-19 15:18:08','2019-07-19 15:18:08'),(87,'63 gm','2019-07-19 16:54:57','2019-07-19 16:54:57'),(88,'273 gm','2019-07-19 17:04:53','2019-07-19 17:04:53'),(89,'700 ml','2019-07-20 13:37:20','2019-07-20 13:37:20'),(90,'96 g','2019-07-20 14:01:33','2019-07-20 14:01:33'),(91,'180 ml','2019-07-20 15:56:11','2019-07-20 15:56:11'),(92,'130 gm','2019-07-20 17:19:00','2019-07-20 17:19:00'),(93,'17 g','2019-07-20 18:05:20','2019-07-20 18:05:20'),(94,'47 g','2019-07-20 18:17:22','2019-07-20 18:17:22'),(95,'35 g','2019-07-20 18:44:26','2019-07-20 18:44:26'),(96,'30 gm','2019-07-22 14:42:56','2019-07-22 14:42:56'),(97,'450 ml','2019-07-22 14:59:35','2019-07-22 14:59:35'),(98,'20 gm','2019-07-22 15:38:30','2019-07-22 15:38:30'),(99,'185 g','2019-07-22 16:15:23','2019-07-22 16:15:23'),(100,'65 ml','2019-07-22 16:56:23','2019-07-22 16:56:23'),(101,'2 pcs','2019-07-24 16:35:48','2019-07-24 16:35:48'),(102,'4 pcs','2019-07-24 16:36:26','2019-07-24 16:36:26'),(103,'5 pcs','2019-07-24 16:36:35','2019-07-24 16:36:35'),(104,'6 pcs','2019-07-24 16:36:57','2019-07-24 16:36:57'),(105,'7 pcs','2019-07-24 16:37:12','2019-07-24 16:37:12'),(106,'12 pcs','2019-07-24 16:37:23','2019-07-24 16:37:23'),(107,'10 pcs','2019-07-24 16:37:33','2019-07-24 16:37:33'),(108,'4 kg','2019-07-27 17:07:06','2019-07-27 17:07:06'),(109,'700 gm','2019-07-27 19:02:11','2019-07-27 19:02:11'),(110,'45 ml','2019-07-27 19:20:53','2019-07-27 19:20:53'),(111,'175 gm','2019-07-29 14:10:03','2019-07-29 14:10:03'),(112,'800 gm','2019-07-29 15:24:00','2019-07-29 15:24:00'),(113,'1.5 kg','2019-07-29 16:28:27','2019-07-29 16:28:27'),(114,'125 gm','2019-07-29 18:09:06','2019-07-29 18:09:06'),(115,'975 ml','2019-07-29 18:48:38','2019-07-29 18:48:38'),(116,'16 l','2019-07-30 17:53:18','2019-07-30 17:53:18'),(117,'1.5 l','2019-07-30 17:53:25','2019-07-30 17:53:25'),(118,'18 l','2019-07-30 18:33:39','2019-07-30 18:33:39'),(119,'10 l','2019-07-31 17:27:16','2019-07-31 17:27:16'),(120,'75 ml','2019-08-01 12:09:46','2019-08-01 12:09:46'),(121,'5 ml','2019-08-01 14:18:05','2019-08-01 14:18:05'),(122,'30 pcs','2019-08-01 15:12:50','2019-08-01 15:12:50'),(123,'100 pcs','2019-08-01 16:30:28','2019-08-01 16:30:28'),(124,'72 mtr','2019-08-01 16:40:40','2019-08-01 16:40:40'),(125,'625 ml','2019-08-01 17:12:16','2019-08-01 17:12:16'),(126,'10 gm','2019-08-01 18:07:19','2019-08-01 18:07:19'),(127,'1 refeil','2019-08-01 19:07:41','2019-08-01 19:07:41'),(128,'270 ml','2019-08-02 14:28:13','2019-08-02 14:28:13'),(129,'425 ml','2019-08-02 17:33:56','2019-08-02 17:33:56'),(130,'500 pcs','2019-08-05 12:30:39','2019-08-05 12:30:39'),(131,'50 pcs','2019-08-05 12:54:32','2019-08-05 12:54:32'),(132,'Pack of 12','2019-08-05 13:01:44','2019-08-05 13:01:44'),(133,'Pack of 25','2019-08-05 13:43:18','2019-08-05 13:43:18'),(134,'90 gm','2019-08-05 18:32:33','2019-08-05 18:32:33'),(135,'80 gm','2019-08-05 18:32:40','2019-08-05 18:32:40'),(136,'165 gm','2019-08-06 11:57:41','2019-08-06 11:57:41'),(137,'44 pcs','2019-08-13 11:33:43','2019-08-13 11:33:43'),(138,'90 ml','2019-08-16 14:31:21','2019-08-16 14:31:21'),(139,'6 ml','2019-08-22 12:50:31','2019-08-22 12:50:31'),(140,'3 ml','2019-08-22 12:50:41','2019-08-22 12:50:41'),(141,'3.2 ml','2019-08-22 12:51:04','2019-08-22 12:51:04'),(142,'4.5 ml','2019-08-26 11:40:09','2019-08-26 11:40:09'),(143,'70 gm','2019-08-26 18:06:50','2019-08-26 18:06:50'),(144,'10 kg','2019-11-02 13:23:35','2019-11-02 13:23:35'),(145,'5 litre','2019-11-06 16:31:00','2019-11-06 16:31:00'),(146,'950 gm','2019-11-07 17:44:34','2019-11-07 17:44:34'),(147,'5 gm','2019-11-22 18:45:58','2019-11-22 18:45:58'),(148,'7gm','2019-11-23 18:58:05','2019-11-23 18:58:05'),(149,'15 gm','2019-12-04 16:08:20','2019-12-04 16:08:20'),(150,'8 gm','2019-12-06 17:45:43','2019-12-06 17:45:43'),(151,'18 gm','2019-12-11 15:01:09','2019-12-11 15:01:09'),(152,'105 gm','2019-12-12 14:37:09','2019-12-12 14:37:09'),(153,'3 litre','2019-12-12 18:59:38','2019-12-12 18:59:38'),(154,'122 ml','2019-12-12 20:30:06','2019-12-12 20:30:06'),(155,'24gm','2019-12-13 13:59:04','2019-12-13 13:59:04'),(156,'125gm* 4','2019-12-13 20:22:09','2019-12-13 20:22:09'),(157,'95 ml','2019-12-13 22:20:29','2019-12-13 22:20:29'),(158,'860ml','2019-12-14 11:55:57','2019-12-14 11:55:57'),(159,'BUY 3 GET 1','2019-12-14 12:43:38','2019-12-14 12:43:38'),(160,'Buy 2 Get 1','2019-12-14 13:20:12','2019-12-14 13:20:12'),(161,'3KG','2019-12-14 13:41:55','2019-12-14 13:41:55'),(162,'145GM','2019-12-14 13:48:57','2019-12-14 13:48:57'),(163,'160GM','2019-12-14 14:05:18','2019-12-14 14:05:18'),(164,'950gm','2019-12-14 14:28:02','2019-12-14 14:28:02'),(165,'650ML','2019-12-14 15:01:57','2019-12-14 15:01:57'),(166,'370ML','2019-12-14 15:06:00','2019-12-14 15:06:00'),(167,'195 ML','2019-12-14 15:06:15','2019-12-14 15:06:15'),(168,'195ML','2019-12-14 15:06:23','2019-12-14 15:06:23'),(169,'340ML','2019-12-14 15:06:32','2019-12-14 15:06:32'),(170,'185ML','2019-12-14 15:06:44','2019-12-14 15:06:44'),(171,'580ML','2019-12-14 15:06:57','2019-12-14 15:06:57'),(172,'600gm','2019-12-14 15:22:20','2019-12-14 15:22:20'),(173,'350ml','2019-12-14 15:59:57','2019-12-14 15:59:57'),(174,'400gm+100gm','2019-12-14 16:04:19','2019-12-14 16:04:19'),(175,'5ltr+1ltr','2019-12-14 16:17:39','2019-12-14 16:17:39'),(176,'118ml','2019-12-14 16:58:01','2019-12-14 16:58:01'),(177,'245ml','2019-12-14 17:15:14','2019-12-14 17:15:14'),(178,'250ml+100ml','2019-12-14 17:44:27','2019-12-14 17:44:27'),(179,'85gm','2019-12-14 17:48:16','2019-12-14 17:48:16'),(180,'155ml','2019-12-14 18:14:57','2019-12-14 18:14:57'),(181,'190ml+50ml','2019-12-14 18:33:42','2019-12-14 18:33:42'),(182,'Rs 10','2019-12-14 18:41:50','2019-12-14 18:41:50'),(183,'Rs 5','2019-12-14 18:42:01','2019-12-14 18:42:01'),(184,'1kg+400gm','2019-12-14 20:04:07','2019-12-14 20:04:07'),(185,'Rs20','2019-12-14 20:05:47','2019-12-14 20:05:47'),(186,'38gm','2019-12-14 20:53:07','2019-12-14 20:53:07'),(187,'235ML','2019-12-15 10:28:49','2019-12-15 10:28:49'),(188,'102ML','2019-12-15 10:34:22','2019-12-15 10:34:22'),(189,'42M','2019-12-15 10:56:58','2019-12-15 10:56:58'),(190,'100 GM+25% EXTRA','2019-12-15 11:07:37','2019-12-15 11:07:37'),(191,'55G','2019-12-15 11:21:42','2019-12-15 11:21:42'),(192,'Rs 42','2019-12-15 13:16:18','2019-12-15 13:16:18'),(193,'Rs 32','2019-12-15 13:16:31','2019-12-15 13:16:31'),(194,'120gm','2019-12-15 14:23:57','2019-12-15 14:23:57'),(195,'60gm','2019-12-15 15:13:25','2019-12-15 15:13:25'),(196,'15 PCS','2019-12-15 15:26:00','2019-12-15 15:26:00'),(197,'14 pcs','2019-12-15 15:42:34','2019-12-15 15:42:34'),(198,'175 ML','2019-12-17 13:23:25','2019-12-17 13:23:25'),(199,'Rs 30','2019-12-17 13:40:59','2019-12-17 13:40:59'),(200,'16 gm','2019-12-17 16:13:05','2019-12-17 16:13:05'),(201,'Sachet','2019-12-17 16:27:08','2019-12-17 16:27:08'),(202,'11gm','2019-12-17 16:56:30','2019-12-17 16:56:30'),(203,'80ml','2019-12-17 17:10:45','2019-12-17 17:10:45'),(204,'25ml','2019-12-17 17:16:20','2019-12-17 17:16:20'),(205,'8ml','2019-12-17 17:24:11','2019-12-17 17:24:11'),(206,'3 gm','2019-12-17 17:26:35','2019-12-17 17:26:35'),(207,'35 ml','2019-12-17 18:26:41','2019-12-17 18:26:41'),(208,'190ML + FREE LOOFAH','2019-12-17 18:31:10','2019-12-17 18:31:10'),(209,'30gm','2019-12-17 18:32:06','2019-12-17 18:32:06'),(210,'35gm','2019-12-17 18:32:16','2019-12-17 18:32:16'),(211,'60ML','2019-12-17 19:00:59','2019-12-17 19:00:59'),(212,'185ML*3','2019-12-17 19:35:14','2019-12-17 19:35:14'),(213,'190ML+185ML','2019-12-17 19:40:30','2019-12-17 19:40:30'),(214,'30ML','2019-12-17 20:22:14','2019-12-17 20:22:14'),(215,'55 ML','2019-12-17 20:24:55','2019-12-17 20:24:55'),(216,'RS.18','2019-12-17 20:52:43','2019-12-17 20:52:43'),(217,'190ML','2019-12-17 22:19:16','2019-12-17 22:19:16'),(218,'10 Tea bags','2019-12-18 11:54:19','2019-12-18 11:54:19'),(219,'Mrp 15','2019-12-18 12:07:57','2019-12-18 12:07:57'),(220,'Rs 15','2019-12-18 12:09:44','2019-12-18 12:09:44'),(221,'22gm','2019-12-18 12:33:38','2019-12-18 12:33:38'),(222,'275 g','2019-12-18 12:39:15','2019-12-18 12:39:15'),(223,'7.5 ml','2019-12-18 12:39:42','2019-12-18 12:39:42'),(224,'42 gm','2019-12-18 12:54:19','2019-12-18 12:54:19'),(225,'2Kg + 1Kg ','2019-12-18 13:22:14','2019-12-18 13:22:14'),(226,'1Kg + 500g','2019-12-18 13:55:43','2019-12-18 13:55:43'),(227,'170ML','2019-12-18 14:21:47','2019-12-18 14:21:47'),(228,'188GM','2019-12-18 14:57:28','2019-12-18 14:57:28'),(229,'196g','2019-12-18 15:53:03','2019-12-18 15:53:03'),(230,'93.1g','2019-12-18 16:14:17','2019-12-18 16:14:17'),(231,'550 ml','2019-12-18 17:19:19','2019-12-18 17:19:19'),(232,'12 gm','2019-12-19 11:13:03','2019-12-19 11:13:03'),(233,'Pack of 10','2019-12-19 11:42:27','2019-12-19 11:42:27'),(234,'240gm','2019-12-19 12:25:33','2019-12-19 12:25:33'),(235,'Rs.20','2019-12-19 12:32:07','2019-12-19 12:32:07'),(236,'625gm','2019-12-19 14:26:47','2019-12-19 14:26:47'),(237,'buy4get1','2019-12-19 14:26:57','2019-12-19 14:26:57'),(238,'65gm','2019-12-19 14:34:36','2019-12-19 14:34:36'),(239,'200ml+185ml','2019-12-19 14:45:31','2019-12-19 14:45:31'),(240,'200ml','2019-12-19 14:46:02','2019-12-19 14:46:02'),(241,'100ml','2019-12-19 14:46:15','2019-12-19 14:46:15'),(242,'20 PCS','2019-12-19 15:01:32','2019-12-19 15:01:32'),(243,'1 pkt','2019-12-19 16:44:55','2019-12-19 16:44:55'),(244,'500g + 200g','2019-12-19 18:59:33','2019-12-19 18:59:33'),(245,'4Kg + 1Kg','2019-12-19 19:00:29','2019-12-19 19:00:29'),(246,'6Kg + 2Kg','2019-12-19 19:00:39','2019-12-19 19:00:39'),(247,'Bundle','2019-12-20 15:01:42','2019-12-20 15:01:42'),(248,'350 gm','2019-12-21 18:52:33','2019-12-21 18:52:33'),(249,'270gm','2019-12-21 18:57:26','2019-12-21 18:57:26'),(250,'425 gm','2019-12-21 19:14:31','2019-12-21 19:14:31'),(251,'425gm','2019-12-21 19:15:04','2019-12-21 19:15:04'),(252,'450gm','2019-12-21 19:15:15','2019-12-21 19:15:15'),(253,'275gm','2019-12-21 19:15:24','2019-12-21 19:15:24'),(254,'250gm','2019-12-21 19:15:39','2019-12-21 19:15:39'),(255,'475gm','2019-12-21 19:16:27','2019-12-21 19:16:27'),(256,'25kg','2019-12-22 20:28:25','2019-12-22 20:28:25'),(257,'6gm','2019-12-22 21:00:54','2019-12-22 21:00:54'),(258,'13gm','2019-12-22 21:01:01','2019-12-22 21:01:01'),(259,'60 gm','2019-12-23 16:03:31','2019-12-23 16:03:31'),(260,'375 gm','2019-12-23 16:18:41','2019-12-23 16:18:41'),(261,'180 gm','2019-12-23 17:09:52','2019-12-23 17:09:52'),(262,'107 gm','2019-12-23 18:03:52','2019-12-23 18:03:52'),(263,'435 gm','2019-12-23 18:40:47','2019-12-23 18:40:47'),(264,'900 gm','2019-12-23 18:52:17','2019-12-23 18:52:17'),(265,'9046135295','2020-01-04 21:09:48','2020-01-04 21:09:48'),(266,'875gm','2020-01-07 12:01:50','2020-01-07 12:01:50'),(267,'650gm','2020-01-07 21:40:19','2020-01-07 21:40:19'),(268,'13.2gm','2020-01-31 11:51:11','2020-01-31 11:51:11'),(269,'27.5gm','2020-01-31 12:03:39','2020-01-31 12:03:39'),(270,'37.3gm','2020-01-31 12:11:42','2020-01-31 12:11:42'),(271,'Rs. 10','2020-01-31 12:22:08','2020-01-31 12:22:08'),(272,'Rs. 20','2020-01-31 12:22:14','2020-01-31 12:22:14'),(273,'Rs. 12','2020-01-31 12:27:16','2020-01-31 12:27:16'),(274,'70gm','2020-01-31 12:31:49','2020-01-31 12:31:49'),(275,'280gm','2020-01-31 12:34:32','2020-01-31 12:34:32'),(276,'420gm','2020-01-31 12:38:38','2020-01-31 12:38:38'),(277,'560gm','2020-01-31 12:48:46','2020-01-31 12:48:46'),(278,'64gm','2020-01-31 12:55:30','2020-01-31 12:55:30'),(279,'96gm','2020-01-31 13:30:10','2020-01-31 13:30:10'),(280,'Rs 45','2020-01-31 13:49:31','2020-01-31 13:49:31'),(281,'Rs 50','2020-01-31 13:56:04','2020-01-31 13:56:04'),(282,'75ml','2020-02-06 21:06:35','2020-02-06 21:06:35'),(283,'350gm','2020-02-08 13:08:40','2020-02-08 13:08:40'),(284,'Rs.7','2020-02-19 17:44:34','2020-02-19 17:44:34'),(285,'25bag','2020-02-24 11:44:10','2020-02-24 11:44:10'),(286,'25 tea bags','2020-02-24 11:44:27','2020-02-24 11:44:27'),(287,'95gm','2020-03-13 14:06:33','2020-03-13 14:06:33'),(288,'900ml','2020-03-15 13:17:52','2020-03-15 13:17:52'),(289,'9 gm','2020-03-31 10:40:54','2020-03-31 10:40:54'),(290,'Pack of 42','2020-04-07 16:36:40','2020-04-07 16:36:40'),(291,'Pack of 16','2020-04-07 16:45:57','2020-04-07 16:45:57'),(292,'Pack of 36','2020-04-07 16:51:03','2020-04-07 16:51:03'),(293,'Pack of36','2020-04-07 16:52:13','2020-04-07 16:52:13'),(294,'Pack of 14','2020-04-07 16:53:40','2020-04-07 16:53:40'),(295,'Pack of 7','2020-04-07 16:54:02','2020-04-07 16:54:02'),(296,'Pack of 32','2020-04-07 16:54:53','2020-04-07 16:54:53'),(297,'Pack of 26','2020-04-07 16:55:27','2020-04-07 16:55:27'),(298,'Pack of 28','2020-04-07 18:31:53','2020-04-07 18:31:53'),(299,'Pack of 18','2020-04-07 18:34:38','2020-04-07 18:34:38'),(300,'Pack of 9','2020-04-07 18:37:15','2020-04-07 18:37:15'),(301,'Pack of 22','2020-04-07 18:42:16','2020-04-07 18:42:16'),(302,'480 gm','2020-04-11 14:11:58','2020-04-11 14:11:58'),(303,'410 gm','2020-04-11 14:18:58','2020-04-11 14:18:58'),(304,'Pack of 30','2020-04-12 12:28:20','2020-04-12 12:28:20'),(305,'Pack of 64','2020-04-22 13:50:04','2020-04-22 13:50:04'),(306,'550gm','2020-04-25 13:43:52','2020-04-25 13:43:52'),(307,'360gm','2020-04-25 14:34:50','2020-04-25 14:34:50'),(308,'1 Ream','2020-04-26 20:37:55','2020-04-26 20:37:55'),(309,'XL','2020-05-01 19:35:37','2020-05-01 19:35:37'),(310,'L','2020-05-01 19:37:05','2020-05-01 19:37:05'),(311,'S','2020-05-01 19:37:07','2020-05-01 19:37:07'),(312,'M','2020-05-01 19:37:12','2020-05-01 19:37:12'),(313,'XXL','2020-05-01 19:37:20','2020-05-01 19:37:20'),(314,'XXXL','2020-05-01 19:37:31','2020-05-01 19:37:31'),(316,'28','2020-05-14 13:18:23','2020-05-14 13:18:23'),(318,'30','2020-05-14 13:19:17','2020-05-14 13:19:17'),(319,'32','2020-05-14 13:19:23','2020-05-14 13:19:23'),(320,'34','2020-05-14 13:21:11','2020-05-14 13:21:11'),(321,'38','2020-05-14 13:21:18','2020-05-14 13:21:18'),(322,'40','2020-05-14 13:21:23','2020-05-14 13:21:23'),(323,'42','2020-05-14 13:21:27','2020-05-14 13:21:27'),(324,'44','2020-05-14 13:21:32','2020-05-14 13:21:32'),(325,'30B','2020-05-18 15:07:22','2020-05-18 15:07:22'),(326,'32B','2020-05-18 15:07:32','2020-05-18 15:07:32'),(327,'34B','2020-05-18 15:07:43','2020-05-18 15:07:43'),(328,'36B','2020-05-18 15:07:51','2020-05-18 15:07:51'),(329,'38B','2020-05-18 15:07:59','2020-05-18 15:07:59'),(330,'32C','2020-05-18 15:41:15','2020-05-18 15:41:15'),(331,'34C','2020-05-18 15:41:23','2020-05-18 15:41:23'),(332,'36C','2020-05-18 15:41:39','2020-05-18 15:41:39'),(333,'38C','2020-05-18 15:41:49','2020-05-18 15:41:49'),(334,'40B','2020-05-18 15:41:55','2020-05-18 15:41:55'),(335,'40C','2020-05-18 15:42:01','2020-05-18 15:42:01'),(336,'Roll','2020-04-29 21:40:34','2020-04-29 21:40:34'),(337,'100 tea bag','2020-05-07 14:31:06','2020-05-07 14:31:06'),(338,'34D','2020-05-19 17:24:55','2020-05-19 17:24:55'),(339,'36D','2020-05-19 17:25:08','2020-05-19 17:25:08'),(340,'38D','2020-05-19 17:25:20','2020-05-19 17:25:20'),(341,'42C','2020-05-26 20:05:32','2020-05-26 20:05:32'),(342,'40D','2020-05-26 20:05:41','2020-05-26 20:05:41'),(343,'44C','2020-05-26 20:17:38','2020-05-26 20:17:38'),(344,'42D','2020-05-26 20:59:46','2020-05-26 20:59:46');

--
-- Table structure for table `karloff_payment_category`
--

CREATE TABLE `karloff_payment_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_category_code` varchar(150) NOT NULL,
  `payment_category_name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_payment_category`
--

INSERT INTO `karloff_payment_category` VALUES (1,'CAT_ORDER','On-line Transaction for Order Placement '),(2,'CAT_MEMBERSHIP','On-line Transaction for Membership'),(3,'CAT_GOCASH','On-line Transaction for Go Cash');

--
-- Table structure for table `karloff_payment_mode`
--

CREATE TABLE `karloff_payment_mode` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_code` varchar(150) NOT NULL,
  `payment_name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_payment_mode`
--

INSERT INTO `karloff_payment_mode` VALUES (1,'TXN_CASH','Cash Payment'),(2,'TXN_CARD','Card Payment'),(3,'TXN_GOCASH','GoCash Payment'),(4,'TXN_SUCCESS','Online Payment'),(5,'TXN_COD','Cash on Delivery'),(6,'TXN_UNPAID','Code for Unpaid or Failed Online Payment');

--
-- Table structure for table `karloff_pin`
--

CREATE TABLE `karloff_pin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pincode` int(11) NOT NULL DEFAULT '0',
  `store_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_pin`
--

INSERT INTO `karloff_pin` VALUES (1,742101,1),(2,742102,1),(3,742103,2);

--
-- Table structure for table `karloff_pointdb`
--

CREATE TABLE `karloff_pointdb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) NOT NULL DEFAULT '0',
  `TransactionDate` date DEFAULT NULL,
  `CustomerId` bigint(20) DEFAULT NULL,
  `CardNo` bigint(20) DEFAULT '0',
  `TransactionDetails` varchar(150) DEFAULT NULL,
  `RewardCredit` int(11) DEFAULT '0',
  `RewardDebit` int(11) DEFAULT '0',
  `ConvertPoint` int(11) DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8713 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_pointdb`
--

INSERT INTO `karloff_pointdb` VALUES (8703,0,'2020-05-28',857452268854,0,'Points for using referral',5,0,0,'2020-05-28 19:02:08','2020-05-28 19:02:08'),(8704,0,'2020-05-28',51969139641,0,'Points for referring : bbb',5,0,0,'2020-05-28 19:02:08','2020-05-28 19:02:08'),(8705,0,'2020-05-28',51969139641,0,'Points converted to KarlPay amount',0,0,150,'2020-05-28 19:02:28','2020-05-28 19:02:28'),(8706,0,'2020-05-28',378187332457,0,'Points for using referral',5,0,0,'2020-05-28 19:02:47','2020-05-28 19:02:47'),(8707,0,'2020-05-28',51969139641,0,'Points for referring : gggh',5,0,0,'2020-05-28 19:02:47','2020-05-28 19:02:47'),(8708,0,'2020-05-28',294173506328,0,'Points for using referral',5,0,0,'2020-05-28 19:02:57','2020-05-28 19:02:57'),(8709,0,'2020-05-28',51969139641,0,'Points for referring : hhg',5,0,0,'2020-05-28 19:02:57','2020-05-28 19:02:57'),(8710,0,'2020-05-28',51969139641,0,'Points converted to KarlPay amount',0,0,30,'2020-05-28 19:03:08','2020-05-28 19:03:08'),(8711,50854981,'2020-05-29',644488618132,0,'Reward Point Added against your Order ID: 50854981',1,0,0,'2020-05-29 10:18:09','2020-05-29 10:18:09'),(8712,53414028,'2020-05-29',50778715080,0,'Reward Point Added against your Order ID: 53414028',2,0,0,'2020-05-29 10:37:20','2020-05-29 10:37:20');

--
-- Table structure for table `karloff_prod_colour`
--

CREATE TABLE `karloff_prod_colour` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `colourName` varchar(100) DEFAULT NULL,
  `hexCode` varchar(9) DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_prod_colour`
--

INSERT INTO `karloff_prod_colour` VALUES (1,'BLUE','#371ca3','2020-04-28 13:55:50','2020-04-28 13:55:50'),(2,'RED','#e02424','2020-04-28 13:55:50','2020-04-28 13:55:50'),(4,'PINK','#d823df','2020-05-01 15:35:57','2020-05-01 15:35:57'),(5,'ORANGE','#f58700','2020-05-01 15:35:57','2020-05-01 15:35:57'),(16,'WHITE',NULL,'2020-05-15 18:15:22','2020-05-15 18:15:22'),(6,'CARBONE BLUE',NULL,'2020-05-14 14:00:34','2020-05-14 14:00:34'),(17,'MID NIGHT SNOW MEL',NULL,'2020-05-15 19:46:15','2020-05-15 19:46:15'),(9,'CHARCOAL MEL',NULL,'2020-05-15 16:24:37','2020-05-15 16:24:37'),(10,'BLACK',NULL,'2020-05-15 16:25:09','2020-05-15 16:25:09'),(11,'NAVY',NULL,'2020-05-15 16:25:18','2020-05-15 16:25:18'),(12,'INK BLUE MEL',NULL,'2020-05-15 16:26:03','2020-05-15 16:26:03'),(13,'GRAPHITE',NULL,'2020-05-15 16:26:33','2020-05-15 16:26:33'),(14,'GREY MEL',NULL,'2020-05-15 16:27:07','2020-05-15 16:27:07'),(15,'GREY',NULL,'2020-05-15 16:27:15','2020-05-15 16:27:15'),(18,'LIGHT DENIM SNOW MEL',NULL,'2020-05-15 19:46:31','2020-05-15 19:46:31'),(19,'MID GREY SNOW MEL',NULL,'2020-05-15 19:46:50','2020-05-15 19:46:50'),(20,'MID GREY MEL',NULL,'2020-05-15 19:47:15','2020-05-15 19:47:15'),(21,'DARK DENIM SNOW MEL',NULL,'2020-05-15 19:47:44','2020-05-15 19:47:44'),(22,'GRAPHITE & BLACK',NULL,'2020-05-17 13:53:18','2020-05-17 13:53:18'),(23,'GRAPHITE & NAVY',NULL,'2020-05-17 13:54:06','2020-05-17 13:54:06'),(24,'GRAPHITE & BLUE',NULL,'2020-05-17 13:54:39','2020-05-17 13:54:39'),(25,'RED & NAVY',NULL,'2020-05-17 13:55:02','2020-05-17 13:55:02'),(26,'RED & BLACK',NULL,'2020-05-17 13:55:27','2020-05-17 13:55:27'),(27,'ROYAL BLUE',NULL,'2020-05-17 17:51:43','2020-05-17 17:51:43'),(28,'LEGING BLUE',NULL,'2020-05-17 17:51:54','2020-05-17 17:51:54'),(29,'POTENT PURPLE',NULL,'2020-05-17 18:17:02','2020-05-17 18:17:02'),(30,'EBONY',NULL,'2020-05-17 18:17:26','2020-05-17 18:17:26'),(31,'TRUE NAVY',NULL,'2020-05-17 18:17:42','2020-05-17 18:17:42'),(32,'OCEAN DEPTH',NULL,'2020-05-17 18:17:58','2020-05-17 18:17:58'),(33,'LEGION BLUE',NULL,'2020-05-17 18:39:05','2020-05-17 18:39:05'),(34,'CINNABAR',NULL,'2020-05-17 18:56:17','2020-05-17 18:56:17'),(35,'SHANGHAI RED',NULL,'2020-05-17 18:56:45','2020-05-17 18:56:45'),(36,'GUNMETAL',NULL,'2020-05-17 18:57:04','2020-05-17 18:57:04'),(37,'BLUE CORAL',NULL,'2020-05-17 18:57:21','2020-05-17 18:57:21'),(38,'WINETASTING',NULL,'2020-05-17 18:57:40','2020-05-17 18:57:40'),(39,'CHECK',NULL,'2020-05-18 11:48:02','2020-05-18 11:48:02'),(40,'PRINT',NULL,'2020-05-18 11:48:09','2020-05-18 11:48:09'),(41,'PEACH',NULL,'2020-05-18 15:06:43','2020-05-18 15:06:43'),(43,'SKIN',NULL,'2020-05-18 15:42:29','2020-05-18 15:42:29'),(44,'DPINK',NULL,'2020-05-19 16:03:54','2020-05-19 16:03:54'),(0,NULL,NULL,'2020-05-19 17:40:20','2020-05-19 17:40:20'),(46,'MAROON',NULL,'2020-05-19 16:04:12','2020-05-19 16:04:12'),(47,'MOUVE',NULL,'2020-05-19 16:04:19','2020-05-19 16:04:19'),(48,'RPINK',NULL,'2020-05-19 16:04:28','2020-05-19 16:04:28'),(49,'CARROT',NULL,'2020-05-19 16:04:45','2020-05-19 16:04:45'),(51,'WINE',NULL,'2020-05-22 17:43:53','2020-05-22 17:43:53'),(52,'RED MEL',NULL,'2020-05-27 13:52:25','2020-05-27 13:52:25'),(53,'LIGHT DENIM MEL',NULL,'2020-05-27 13:53:09','2020-05-27 13:53:09');

--
-- Table structure for table `karloff_productdb`
--

CREATE TABLE `karloff_productdb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ProductCode` varchar(50) NOT NULL DEFAULT 'NO_PRODUCT_CODE',
  `HsnCode` varchar(150) NOT NULL DEFAULT 'No HSN Found',
  `ProductName` varchar(500) NOT NULL DEFAULT 'No Product Name Found',
  `ProductMrp` float NOT NULL DEFAULT '0',
  `ProductOfferprice` float NOT NULL DEFAULT '0',
  `ProductClubprice` float NOT NULL DEFAULT '0',
  `ProductSubscriptionPrice` float NOT NULL DEFAULT '0',
  `ProductDiscountAmount` float NOT NULL DEFAULT '0',
  `ProductDiscountPercentage` float NOT NULL DEFAULT '0',
  `ClubDiscountAmount` float NOT NULL DEFAULT '0',
  `ClubDiscountPercentage` float NOT NULL DEFAULT '0',
  `FoodPreference` varchar(50) NOT NULL DEFAULT '0',
  `ProductBrand` int(11) DEFAULT NULL,
  `ProductIgst` float NOT NULL DEFAULT '0',
  `ProductCgst` float NOT NULL DEFAULT '0',
  `ProductSgst` float NOT NULL DEFAULT '0',
  `DeliverySlot` int(11) DEFAULT NULL,
  `ProductCategory` int(11) DEFAULT NULL,
  `ProductSubcategoryL1` int(11) DEFAULT NULL,
  `CurrentStock` float NOT NULL DEFAULT '0',
  `PseudoStock` float NOT NULL DEFAULT '0',
  `CriticalStock` float NOT NULL DEFAULT '0',
  `ProductPack` int(11) DEFAULT NULL,
  `ProductUnit` int(11) DEFAULT NULL,
  `productColour` int(11) NOT NULL DEFAULT '0',
  `IndividualLimit` int(11) NOT NULL DEFAULT '0',
  `PromoCode` int(11) DEFAULT NULL,
  `ProductImagePathSmall` varchar(150) DEFAULT NULL,
  `ProductImagePath1` varchar(150) DEFAULT NULL,
  `ProductImagePath2` varchar(150) DEFAULT NULL,
  `ProductImagePath3` varchar(150) DEFAULT NULL,
  `ProductAbout` varchar(2500) DEFAULT NULL,
  `ProductStorageUseage` varchar(2500) DEFAULT NULL,
  `ProductBenefits` varchar(2500) DEFAULT NULL,
  `ProductOtherInfo` varchar(2500) DEFAULT NULL,
  `ProductVolume` varchar(2500) DEFAULT NULL,
  `isSubscribe` int(11) NOT NULL DEFAULT '0',
  `ProductEnable` int(11) DEFAULT NULL,
  `productType` tinyint(4) NOT NULL DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2423 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_productdb`
--

INSERT INTO `karloff_productdb` VALUES (253,'1563455019','22021020','Mirinda - 2litre',80,70,60,0,0,0,0,0,'0',1,0,14,14,NULL,6,19,8,-1,10,35,13,0,1,NULL,'imagedb/product/5D306F7FE5D6C.jpg','imagedb/product/5D306F8A7EA02.jpg','imagedb/product/5D306F914B5D3.jpg','imagedb/product/5D306F990ACC3.jpg','','Store in cool place','','','Available',0,0,0,'2019-07-18 18:33:39','2019-07-18 18:33:39'),(259,'1563457455','22021020','7 Up Soft Drink 2 litre',85,85,85,0,0,0,0,0,'0',1,0,14,14,NULL,6,19,80,81,5,35,13,0,1,NULL,'imagedb/product/5E12D4C621416.jpg','imagedb/product/5E12D4D081D76.jpg',NULL,NULL,'7UPs sparkling and crisp lemon and lime flavour keeps you positive and confident against all odds. It aims to connect with people who choose to be their natural self and stand out in the crowd. 7UP celebrates the Hum toh hain like this! attitude of consumers.','Store in cool place','7UPs sparkling and crisp lemon and lime flavour keeps you positive and confident against all odds. ','','Available.',0,1,0,'2019-07-18 19:14:15','2019-07-18 19:14:15'),(2044,'1576929851','34013019','Lifebuoy handwash mild care 185ml*3',134,134,134,0,0,0,0,0,'1',3,0,9,9,NULL,8,37,80,63,5,212,7,0,1,NULL,'imagedb/product/5DFE0B31A3C4D.jpg','imagedb/product/5DFE0B3BB8244.jpg',NULL,NULL,'','','','','',0,0,0,'2019-12-21 17:34:11','2019-12-21 17:34:11'),(2050,'1576931344','34013019','Lifebuoy handwash total 1.5 litre',199,199,199,0,0,0,0,0,'1',3,0,9,9,NULL,8,37,80,72,3,117,16,0,1,NULL,'imagedb/product/5DFE48C0CA86A.jpg','imagedb/product/5DFE48CECEC59.jpg',NULL,NULL,'','','','','',0,0,0,'2019-12-21 17:59:04','2019-12-21 17:59:04'),(2063,'1576935365','33051090','sunsilk stunning black shampoo 650ml',415,410,405,0,0,0,0,0,'0',3,0,9,9,NULL,8,38,80,77,2,165,13,0,10,NULL,'imagedb/product/5DFE219534B41.jpg','imagedb/product/5DFE21A8BD23F.jpg',NULL,NULL,'','','','','',0,1,0,'2019-12-21 19:06:05','2019-12-21 19:06:05'),(2254,'1582525217','09023020','LIPTON LEMON HONEY GREEN TEA BAG 25PC',145,138,135,0,0,0,0,0,'0',3,0,2.5,2.5,NULL,6,51,80,80,3,286,9,0,1,NULL,'imagedb/product/5E536EEB11471.jpg','imagedb/product/5E536EF4609F0.jpg',NULL,NULL,'','','','','',0,0,0,'2020-02-24 11:50:17','2020-02-24 11:50:17'),(2306,'1576822344','22021010','Pepsi 750ml',38,38,38,0,0,0,0,0,'0',1,0,14,14,NULL,6,19,80,80,10,34,13,0,10,NULL,'imagedb/product/5E12D4EA509BC.jpg','imagedb/product/5E12D4F253A3B.jpg','','','','Store in cool place','','','Available',0,0,0,'2019-07-18 18:33:39','2019-07-18 18:33:39'),(2374,'1576311815','34054000','VIM LEMON BAR Rs.5',5,5,5,0,0,0,0,0,'0',3,0,9,9,NULL,8,30,135,115,5,183,7,0,3,NULL,'imagedb/product/5DFF6B7758EA7.jpg','imagedb/product/5DFF6B824A540.jpg',NULL,NULL,'','','','','',0,1,0,'2019-12-14 13:53:34','2019-12-14 13:53:34'),(2378,'1576342175','38089400','Godrej Protekt Hand Sanitizer 50ML',25,25,25,0,0,0,0,0,'0',3,0,9,9,NULL,8,37,80,74,5,64,7,0,1,NULL,'imagedb/product/5E92F1073BCB7.jpg','imagedb/product/5E92F09C09446.jpg',NULL,NULL,'','','','','',0,0,0,'2019-12-14 22:19:42','2019-12-14 22:19:42'),(2420,'1576305043','34022010','Comfort Fabric Conditioner anti bacterial action 860ml ',218,215,215,0,0,0,0,0,'0',3,0,9,9,NULL,8,30,3,0,2,158,13,0,1,NULL,'imagedb/product/5EA01A327745A.jpg','imagedb/product/5EA01A3FABB06.jpg',NULL,NULL,'','','','','',0,1,0,'2019-12-14 12:00:43','2019-12-14 12:00:43'),(2421,'1576305043','34022010','Comfort Fabric Conditioner after wash lily fresh 860ml',218,215,215,0,0,0,0,0,'0',3,0,9,9,NULL,8,30,3,0,2,158,13,0,1,NULL,'imagedb/product/5EA01B08CFEF0.jpg','imagedb/product/5EA01B1185B88.jpg',NULL,NULL,'','','','','',0,1,0,'2019-12-14 12:00:43','2019-12-14 12:00:43'),(2422,'1573287256','20079930','Kissan Pineapple Jam 500GM ',160,160,160,0,0,0,0,0,'0',3,0,6,6,NULL,4,24,80,73,3,14,13,0,1,NULL,'imagedb/product/5DC6758AB85D0.jpg','imagedb/product/5DC6759D9C45E.jpg',NULL,NULL,'Packed with the goodness of fresh pineapples, this jam is one sweet-sour treat you and your kids should not give a miss. Add a generous amount of Kissan Pineapple Jam on a slice of brown/white bread, and watch the happiness meter hit an all-time high! Kissan Pineapple Jam is best partnered with bread to provide yummy on the go breakfast for your kid every morning. Think of different ways to eat it in. Spread it on a crunchy cracker, roll it up in a chapatti, drink it stirred in milk or whip up a bread and Jam delight for your kids breakfast with an assortment of flavors. Heres making breakfast time, merrier and healthier since Pineapples are known to be rich in vitamin A and calcium.','Store in coool place ','Packed with the goodness of fresh pineapples, this jam is one sweet-sour treat you and your kids should not give a miss. Add a generous amount of Kissan Pineapple Jam on a slice of brown/white bread, and watch the happiness meter hit an all-time high! Kissan Pineapple Jam is best partnered with bread to provide yummy on the go breakfast for your kid every morning. Think of different ways to eat it in. Spread it on a crunchy cracker, roll it up in a chapatti, drink it stirred in milk or whip up a bread and Jam delight for your kids breakfast with an assortment of flavors. Heres making breakfast time, merrier and healthier since Pineapples are known to be rich in vitamin A and calcium.','','Available',0,1,0,'2019-11-09 13:44:16','2019-11-09 13:44:16');

--
-- Table structure for table `karloff_promo_code`
--

CREATE TABLE `karloff_promo_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `PromoCode` varchar(50) NOT NULL,
  `PromoCodeDetails` varchar(250) NOT NULL,
  `DiscountType` varchar(150) DEFAULT NULL,
  `ProductId` varchar(150) DEFAULT NULL,
  `SubCategoryId` varchar(150) DEFAULT NULL,
  `OfferProductId` varchar(150) DEFAULT NULL,
  `OfferProductQuantity` int(11) NOT NULL DEFAULT '0',
  `Frequency` int(11) NOT NULL DEFAULT '0',
  `SubscriptionType` varchar(150) DEFAULT NULL,
  `CouponAmount` int(11) NOT NULL DEFAULT '0',
  `minInvoiceAmount` int(11) NOT NULL DEFAULT '0',
  `ProductValue` int(11) NOT NULL DEFAULT '0',
  `ProductValueLimit` int(11) NOT NULL DEFAULT '0',
  `ValidFrom` date DEFAULT NULL,
  `ValidTill` date DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_promo_code`
--

INSERT INTO `karloff_promo_code` VALUES (2,'RECHARGE50','Cashback on KarlPay Wallet Recharge','CASHBACK','KARLPAY',NULL,'0',0,0,'0',50,0,500,0,'2019-12-29','2020-03-24','2019-11-05 14:47:53','2019-11-05 14:47:53'),(9,'RCGH200','Cashback on KarlPay Wallet Recharge','CASHBACK','KARLPAY',NULL,'0',0,0,'0',200,0,2000,0,'2019-12-29','2020-03-24','2019-11-05 14:47:53','2019-11-05 14:47:53'),(10,'RECHARGE10','Cashback on KarlPay Wallet Recharge','CASHBACK','KARLPAY',NULL,'0',0,0,'0',10,0,100,0,'2019-12-29','2020-03-24','2019-11-05 14:47:53','2019-11-05 14:47:53'),(11,'RCH10K','Cashback on KarlPay Wallet Recharge','CASHBACK','KARLPAY',NULL,'0',0,0,'0',1000,0,10000,0,'2020-05-01','2020-05-31','2020-05-01 14:47:53','2020-05-01 14:47:53'),(12,'RCH05K','Cashback on KarlPay Wallet Recharge','CASHBACK','KARLPAY',NULL,'0',0,0,'0',500,0,5000,0,'2020-05-01','2020-05-31','2020-05-01 14:47:53','2020-05-01 14:47:53');

--
-- Table structure for table `karloff_promocode_applied`
--

CREATE TABLE `karloff_promocode_applied` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) NOT NULL,
  `coupon_applied` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_promocode_applied`
--

INSERT INTO `karloff_promocode_applied` VALUES (1,112342566,'DIWALI150'),(3,1123455497,'DIWALI150'),(7,1563821848,'DIWALI150'),(8,1563821848,'Diwali150'),(9,1571330,'RICE0550'),(10,1571330,''),(11,1564496262,''),(12,1573055,'');

--
-- Table structure for table `karloff_purchase_details`
--

CREATE TABLE `karloff_purchase_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) NOT NULL DEFAULT '0',
  `customer_id` bigint(20) NOT NULL DEFAULT '0',
  `product_id` int(11) NOT NULL DEFAULT '0',
  `product_category_id` int(11) DEFAULT '0',
  `product_subcategory_id` int(11) DEFAULT '0',
  `BaseValue` float NOT NULL DEFAULT '0',
  `CgstAmount` float NOT NULL DEFAULT '0',
  `SgstAmount` float NOT NULL DEFAULT '0',
  `IgstAmount` float NOT NULL DEFAULT '0',
  `CgstPercent` float DEFAULT '0',
  `SgstPercent` float NOT NULL DEFAULT '0',
  `IgstPercent` float NOT NULL DEFAULT '0',
  `RoundOffAmount` float NOT NULL DEFAULT '0',
  `qty` int(11) NOT NULL DEFAULT '0',
  `net_amount` float NOT NULL DEFAULT '0',
  `isConfirm` int(11) NOT NULL DEFAULT '0',
  `purchaseDate` date DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_purchase_details`
--


--
-- Table structure for table `karloff_purchase_master`
--

CREATE TABLE `karloff_purchase_master` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` varchar(50) NOT NULL,
  `order_id` bigint(20) NOT NULL,
  `creditor_id` bigint(20) DEFAULT NULL,
  `delivery_charge` int(11) DEFAULT '0',
  `discount_amount` float NOT NULL DEFAULT '0',
  `BaseValue` float NOT NULL DEFAULT '0',
  `CgstAmount` float NOT NULL DEFAULT '0',
  `SgstAmount` float NOT NULL DEFAULT '0',
  `IgstAmount` float NOT NULL DEFAULT '0',
  `NetAmount` float NOT NULL DEFAULT '0',
  `qty` int(11) NOT NULL DEFAULT '0',
  `round_off_amount` float NOT NULL DEFAULT '0',
  `order_status` int(11) NOT NULL DEFAULT '0',
  `payment_code` int(11) DEFAULT NULL,
  `InvoiceDate` date DEFAULT NULL,
  `InvoiceDatetime` bigint(20) DEFAULT NULL,
  `cause_of_cancel` varchar(250) DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_purchase_master`
--


--
-- Table structure for table `karloff_sale_type`
--

CREATE TABLE `karloff_sale_type` (
  `id` int(11) NOT NULL,
  `sale_status_name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_sale_type`
--

INSERT INTO `karloff_sale_type` VALUES (1,'Delivery'),(3,'Store');

--
-- Table structure for table `karloff_store_details`
--

CREATE TABLE `karloff_store_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `karloff_branch` varchar(150) NOT NULL,
  `branch_address` varchar(500) NOT NULL,
  `contact_no` varchar(150) DEFAULT NULL,
  `status` bit(1) NOT NULL DEFAULT b'0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_store_details`
--

INSERT INTO `karloff_store_details` VALUES (1,'KHAGRA','59, Daihatta Road, PO- Khagra, City- Berhampore, West Bengal. 742103','9733414333, 9733933033','','2020-02-01 00:00:00','2020-02-01 00:00:00'),(2,'KARLOFF','46 Rejaul Karim Sarani,\r\nBerhampore','9474100333','','2020-02-01 00:00:00','2020-02-01 00:00:00');

--
-- Table structure for table `karloff_subcategorylevel1`
--

CREATE TABLE `karloff_subcategorylevel1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CategoryId` int(11) NOT NULL,
  `SubcategoryL1Name` varchar(50) NOT NULL,
  `SubCategoryIconPath` varchar(150) DEFAULT NULL,
  `SubCategoryOrder` int(11) NOT NULL DEFAULT '0',
  `isActive` int(11) NOT NULL DEFAULT '1',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_subcategorylevel1`
--

INSERT INTO `karloff_subcategorylevel1` VALUES (1,1,'Fruits','imagedb/subcategory/5D42ABCC32EFE.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,1,'Fresh Vegetables','imagedb/subcategory/5E855ECFCD408.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,1,'Cuts & Sprouts','imagedb/subcategory/5D42C2FD904E7.jpg',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,1,'Exotic Fruits & Veggies','imagedb/subcategory/5D42AB96F361C.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,1,'Herbs & Seasoning','imagedb/subcategory/5D42ABDB3D2D4.jpg',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,1,'Flower Bouquets & Bunches','imagedb/subcategory/5D42ABA93FB4F.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,3,'Atta, Flours & Sooji','imagedb/subcategory/Atta-flour-sooji.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,3,'Salt, Sugar & Jaggery','imagedb/subcategory/salt-sugar-jaggery.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,3,'Rice & Rice Products','imagedb/subcategory/rice-riceproducts.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,2,'Dairy','imagedb/subcategory/5D42AC1142C5A.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(12,2,'Breads & Buns','imagedb/subcategory/bread-bun.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(13,2,'Cookies, Rusk & Khari','imagedb/subcategory/cookies-rusk-khari.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(14,7,'Diapers & Wipes','imagedb/subcategory/diapers-wipes.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(15,7,'Baby Food & Formula','imagedb/subcategory/baby-food.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(16,7,'Baby Bath & Hygiene','imagedb/subcategory/5E95FEDDCF463.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(17,6,'Fruit Juices & Drinks','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,6,'Health Drink, Supplement','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(19,6,'Energy & Soft Drinks','imagedb/subcategory/5E227359E8595.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(21,4,'Noodle & Pasta','imagedb/subcategory/5DFA52471E6D0.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,4,'Breakfast Cereals','imagedb/subcategory/5DFA51A91FDC2.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(23,4,'Biscuits & Cookies','imagedb/subcategory/5DFA518BA0146.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(24,4,'Spreads, Sauces, Ketchup','imagedb/subcategory/spreads-sauces-ketchup.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(25,5,'Eggs','imagedb/subcategory/egg.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,5,'Mutton ','imagedb/subcategory/mutton.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(28,5,'Fish ','imagedb/subcategory/fish.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(30,9,'Detergents & Dishwash','imagedb/subcategory/5DFA13FB0839D.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(31,9,'Fresheners & Repellents','imagedb/subcategory/5DFA142011AF9.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(32,9,'Disposables, Garbage Bag','imagedb/subcategory/5E95FFFDA393D.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(33,9,'Bins & Bathroom Ware','imagedb/subcategory/5E9600E8AD7A8.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(34,9,'Mops, Brushes & Scrubs','imagedb/subcategory/5DFA142CB5B25.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(35,8,'Oral Care','imagedb/subcategory/5DFA13399AE35.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(36,8,'Feminine Hygiene','imagedb/subcategory/5DFA12E8B0A80.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(37,8,'Bath & Hand Wash','imagedb/subcategory/5DFA12BB9DFF6.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(38,8,'Hair Care','imagedb/subcategory/5DFA130E1E23B.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(39,8,'Health & Medicine','imagedb/subcategory/5DFA131C87051.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(40,3,'Dals & Pulses','imagedb/subcategory/dal-pulses.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(42,3,'Edible Oils & Ghee','imagedb/subcategory/edible-oil-ghee.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(43,3,'Masalas & Spices','imagedb/subcategory/masala-spices.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(44,1,'Dry Fruits','imagedb/subcategory/dry-fruits.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(45,2,'Gourmet Breads','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(46,2,'Ice Creams & Desserts','imagedb/subcategory/ice-cream-desert.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(47,2,'Bakery Snacks','imagedb/subcategory/bakery-snacks.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(48,2,'Cakes & Pastries','imagedb/subcategory/cakes-pastries.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(49,6,'Water','imagedb/subcategory/5E227580F06FC.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(50,6,'Coffee','imagedb/subcategory/5E2276D3F2E21.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(51,6,'Tea','imagedb/subcategory/5E22783D1E38A.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(52,4,'Frozen Veggies & Snacks','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(53,4,'Snacks & Namkeen','imagedb/subcategory/5E56AB58B0F0A.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(54,4,'Ready To Cook & Eat','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(55,4,'Chocolates & Candies','imagedb/subcategory/5E56AB780004F.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(56,4,'Pickles & Chutney','imagedb/subcategory/5DFA5274191F6.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(57,4,'Indian Mithai','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(58,8,'Mens Grooming','imagedb/subcategory/5DFA132B0AD10.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(59,8,'Skin Care','imagedb/subcategory/5DFA13467C47D.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(60,8,'Makeup','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(61,8,'Fragrances & Deos','imagedb/subcategory/5DFA12FA1FC86.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(62,9,'All Purpose Cleaners','imagedb/subcategory/5DFA138BAE54E.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(63,9,'Pooja Needs','imagedb/subcategory/5DFA144ACBA13.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(64,9,'Party & Festive Needs','imagedb/subcategory/5DFA143B4DD42.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(65,9,'Car & Shoe Care','imagedb/subcategory/5DFA13E640502.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(66,9,'Stationery','imagedb/subcategory/5DFA145A4D41E.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(67,5,'Chicken','imagedb/subcategory/5E1B1C95DACA0.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(69,10,'Oils & Vinegar','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(70,10,'Dairy & Cheese','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(71,10,'Snacks, Dry Fruits, Nuts','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(73,10,'Cooking & Baking Needs','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(74,10,'Chocolates & Biscuits','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(75,10,'Sauces, Spreads & Dips','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(76,10,'Cereals & Breakfast','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(77,10,'Drinks & Beverages','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(78,10,'Tinned & Processed Food','',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(79,7,'Mothers & Maternity','imagedb/subcategory/mothers-maternity.jpg',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(80,7,'Feeding & Nursing','',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(81,7,'Baby Grooming','',0,1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(84,2,'Milk','imagedb/subcategory/milk.jpg',0,1,'2019-11-05 00:00:00','2019-11-05 00:00:00'),(85,9,'Kitchen Utensils','imagedb/subcategory/5E9601F31C6B8.jpg',0,1,'2019-12-19 22:04:26','2019-12-19 22:04:26'),(86,8,'Sexual Wellness','imagedb/subcategory/5E1ECCC37DD34.jpg',0,1,'2019-12-23 10:58:09','2019-12-23 10:58:09'),(87,11,'Christmas Cake','imagedb/subcategory/5E023CCF44023.jpg',0,0,'2019-12-24 21:44:43','2019-12-24 21:44:43'),(88,12,'Exercise Books','imagedb/subcategory/5EA5662753FC9.jpg',0,1,'2020-04-26 15:42:25','2020-04-26 15:42:25'),(89,12,'Pen Pencils','imagedb/subcategory/5EA568E56577C.jpg',0,1,'2020-04-26 15:59:34','2020-04-26 15:59:34'),(90,12,'Erasers  Sharpeners','imagedb/subcategory/5EA564F820D59.jpg',0,1,'2020-04-26 16:00:20','2020-04-26 16:00:20'),(91,12,'Exam Pads & Pencil Box','imagedb/subcategory/5EA56533D149A.jpg',0,1,'2020-04-26 16:00:47','2020-04-26 16:00:47'),(92,12,'Games & Calculators','imagedb/subcategory/5EA56717A7E3E.jpg',0,1,'2020-04-26 16:01:12','2020-04-26 16:01:12'),(93,12,'Colours & Crayons','imagedb/subcategory/5EA56476B6D1F.jpg',0,1,'2020-04-26 16:01:32','2020-04-26 16:01:32'),(94,12,'Files, Folders & Notebooks','imagedb/subcategory/5EA5666A7C8A2.jpg',0,1,'2020-04-26 16:02:20','2020-04-26 16:02:20'),(95,12,'Scissor, Glue & Tape','imagedb/subcategory/5EA569A9E51E6.jpg',0,1,'2020-04-26 16:03:47','2020-04-26 16:03:47'),(96,12,'Printing Paper','imagedb/subcategory/5EA5A25C3208F.jpg',0,1,'2020-04-26 20:27:46','2020-04-26 20:27:46'),(99,13,'Under Garments - Men','imagedb/subcategory/5EBFF77D48E98.jpg',0,1,'2020-05-12 14:46:43','2020-05-12 14:46:43'),(100,13,'Shirts','imagedb/subcategory/5EBFFAF6D2F6E.jpg',0,1,'2020-05-15 15:57:48','2020-05-15 15:57:48'),(101,13,'T-Shirts','imagedb/subcategory/5EBFFAEC9018C.jpg',0,1,'2020-05-15 15:57:57','2020-05-15 15:57:57'),(102,13,'SHORTS MEN','imagedb/subcategory/5EC226A4A8E2E.jpg',0,1,'2020-05-18 11:38:53','2020-05-18 11:38:53'),(103,15,'Under Garments - Women','imagedb/subcategory/5EC23D5A10FF2.jpg',0,1,'2020-05-18 13:16:12','2020-05-18 13:16:12');

--
-- Table structure for table `karloff_subscription`
--

CREATE TABLE `karloff_subscription` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CustomerId` bigint(20) NOT NULL DEFAULT '0',
  `ProductId` int(11) NOT NULL DEFAULT '0',
  `ProductQty` int(11) NOT NULL DEFAULT '0',
  `SubscriptionStartDate` date DEFAULT NULL,
  `LastOrderDeliverDate` date DEFAULT NULL,
  `SubscriptionName` int(11) NOT NULL DEFAULT '0',
  `subscriptionDetails` varchar(500) DEFAULT NULL,
  `SubscriptionStatus` int(11) NOT NULL DEFAULT '0',
  `BillingStatus` int(11) NOT NULL DEFAULT '0',
  `SubscriptionDaysCycle` int(11) NOT NULL DEFAULT '0',
  `DayCycleCompleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_subscription`
--

INSERT INTO `karloff_subscription` VALUES (41,902906077545,1214,1,'2020-03-25','2020-04-12',2,NULL,2,0,15,0),(30,731631130188,1214,1,'2020-02-09','2020-05-28',2,NULL,1,0,15,0),(67,157820421181,1214,1,'2020-05-18','2020-05-23',1,NULL,3,0,30,0),(39,136745370514,1214,1,'2020-03-02','2020-05-28',1,NULL,1,0,30,0),(26,1564393723,1212,5,'2020-01-05','2020-04-29',1,NULL,2,0,30,0);

--
-- Table structure for table `karloff_subscription_name`
--

CREATE TABLE `karloff_subscription_name` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `SubscriptionName` varchar(50) DEFAULT NULL,
  `DaysCycle` int(11) NOT NULL DEFAULT '0',
  `DayFrequency` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_subscription_name`
--

INSERT INTO `karloff_subscription_name` VALUES (1,'Daily',30,0),(2,'Alternate Day',15,2),(3,'Every 3 Days',10,3),(4,'Weekly',7,7),(5,'Monthly',1,29);

--
-- Table structure for table `karloff_subscription_status`
--

CREATE TABLE `karloff_subscription_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `StatusName` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_subscription_status`
--

INSERT INTO `karloff_subscription_status` VALUES (1,'Active'),(2,'Paused'),(3,'Cancelled');

--
-- Table structure for table `karloff_subsription_custlist`
--

CREATE TABLE `karloff_subsription_custlist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customerId` bigint(20) DEFAULT NULL,
  `deliveryDate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_subsription_custlist`
--


--
-- Table structure for table `karloff_transaction`
--

CREATE TABLE `karloff_transaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `txn_id` varchar(50) NOT NULL DEFAULT '0',
  `paymentCategory` varchar(50) DEFAULT NULL,
  `txn_amount` varchar(50) NOT NULL DEFAULT '0',
  `payment_mode` varchar(50) NOT NULL DEFAULT '0',
  `bank_txnid` varchar(50) NOT NULL DEFAULT '0',
  `txn_order_id` varchar(50) NOT NULL DEFAULT '0',
  `txn_status` varchar(50) NOT NULL DEFAULT '0',
  `txn_type` varchar(50) NOT NULL DEFAULT '0',
  `txn_gateway_name` varchar(50) NOT NULL DEFAULT '0',
  `txn_resp_code` varchar(50) NOT NULL DEFAULT '0',
  `txn_bank_name` varchar(50) NOT NULL DEFAULT '0',
  `txn_date` varchar(50) DEFAULT NULL,
  `order_date` date DEFAULT NULL,
  `order_datetime` bigint(20) NOT NULL DEFAULT '0',
  `isRefund` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2331 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_transaction`
--

INSERT INTO `karloff_transaction` VALUES (2325,'20200529111212800110168885329480038',NULL,'260.00','UPI','015007474957','1590719355929','TXN_SUCCESS','','ICICI','01','','2020-05-29 07:59:17.0','2020-05-29',1590690600,0),(2326,'20200529111212800110168567329008153',NULL,'447.00','DC','202015087418701','1590725123270','TXN_SUCCESS','','SBIFSS','01','State Bank of India','2020-05-29 09:35:25.0','2020-05-29',1590690600,0),(2327,'20200529111212800110168941329583632',NULL,'223.00','CC','202051513171470','1590726257684','TXN_SUCCESS','','HDFC','01','State Bank of India','2020-05-29 09:54:20.0','2020-05-29',1590690600,0),(2328,'20200529111212800110168053629483313',NULL,'142.00','UPI','015010467338','1590726871265','TXN_SUCCESS','','ICICI','01','','2020-05-29 10:04:34.0','2020-05-29',1590690600,0),(2329,'20200529111212800110168111829621179',NULL,'482.00','PPI','139020539681','1590727259439','TXN_SUCCESS','','WALLET','01','WALLET','2020-05-29 10:11:01.0','2020-05-29',1590690600,0),(2330,'20200529111212800110168175529243631',NULL,'313.00','PPI','139022214236','1590729723429','TXN_SUCCESS','','WALLET','01','WALLET','2020-05-29 10:52:04.0','2020-05-29',1590690600,0);

--
-- Table structure for table `karloff_unitdb`
--

CREATE TABLE `karloff_unitdb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `unit_name` varchar(50) NOT NULL COMMENT 'KARLOFF',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_unitdb`
--

INSERT INTO `karloff_unitdb` VALUES (7,'Pc','0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,'Pkt','0000-00-00 00:00:00','0000-00-00 00:00:00'),(13,'Bottle','0000-00-00 00:00:00','0000-00-00 00:00:00'),(14,'Carton','2019-07-15 18:36:36','2019-07-15 18:36:36'),(15,'Tin','2019-07-15 18:36:48','2019-07-15 18:36:48'),(16,'Pouch','2019-07-17 17:29:07','2019-07-17 17:29:07'),(17,'Can','2019-07-18 17:41:24','2019-07-18 17:41:24'),(18,'Cup','2019-07-20 13:38:22','2019-07-20 13:38:22'),(19,'Cone','2019-07-20 13:38:30','2019-07-20 13:38:30'),(20,'Tub','2019-07-20 13:38:52','2019-07-20 13:38:52'),(22,'Jar','2019-11-06 16:31:46','2019-11-06 16:31:46'),(24,'Aluminium Foil','2019-11-19 16:00:00','2019-11-19 16:00:00'),(25,'Combo','2019-12-13 20:23:18','2019-12-13 20:23:18'),(26,'Bowl','2019-12-14 17:31:24','2019-12-14 17:31:24'),(27,'Liquid','2019-12-14 18:07:51','2019-12-14 18:07:51'),(28,'Kg','2019-12-15 15:28:43','2019-12-15 15:28:43'),(29,'gm','2019-12-15 15:32:59','2019-12-15 15:32:59'),(30,'Tube','2019-12-17 12:27:54','2019-12-17 12:27:54'),(31,'1 Pc','2019-12-17 17:27:42','2019-12-17 17:27:42'),(32,'Sachet','2019-12-17 17:31:06','2019-12-17 17:31:06'),(33,'Poly Packet','2019-12-18 13:25:38','2019-12-18 13:25:38'),(34,'Box','2019-12-18 14:30:30','2019-12-18 14:30:30'),(35,'pcs','2019-12-24 15:02:05','2019-12-24 15:02:05'),(36,'9 gm','2020-03-31 10:39:03','2020-03-31 10:39:03'),(37,'Roll','2020-04-29 21:41:10','2020-04-29 21:41:10');

--
-- Table structure for table `karloff_weborder`
--

CREATE TABLE `karloff_weborder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `storeId` varchar(50) DEFAULT NULL,
  `order_id` bigint(20) NOT NULL DEFAULT '0',
  `customer_id` bigint(20) NOT NULL DEFAULT '0',
  `delivery_charge` int(11) NOT NULL DEFAULT '0',
  `GoCashPay` int(11) NOT NULL DEFAULT '0',
  `Promocode` varchar(25) DEFAULT NULL,
  `PromocodeDiscount` int(11) NOT NULL DEFAULT '0',
  `PromoDiscBasePrice` float NOT NULL DEFAULT '0',
  `PromoDiscGST` float NOT NULL DEFAULT '0',
  `CouponCodeTotalDiscount` int(11) NOT NULL DEFAULT '0',
  `CashbackTotalDiscount` int(11) NOT NULL DEFAULT '0',
  `discount_amount` float NOT NULL DEFAULT '0',
  `RedeemAmount` int(11) NOT NULL DEFAULT '0',
  `BaseValue` float NOT NULL DEFAULT '0',
  `CgstAmount` float NOT NULL DEFAULT '0',
  `SgstAmount` float DEFAULT '0',
  `IgstAmount` float NOT NULL DEFAULT '0',
  `InvoiceAmount` float NOT NULL DEFAULT '0',
  `NetAmount` float NOT NULL DEFAULT '0',
  `round_off_amount` float NOT NULL DEFAULT '0',
  `order_status` int(11) NOT NULL DEFAULT '0',
  `payment_code` varchar(25) NOT NULL DEFAULT '0',
  `order_date` date DEFAULT NULL,
  `order_datetime` bigint(20) DEFAULT NULL,
  `delivery_date` varchar(128) DEFAULT NULL,
  `address_id` int(11) NOT NULL DEFAULT '0',
  `TxnId` int(11) NOT NULL DEFAULT '0' COMMENT 'ID value from karloff_transaction',
  `cancelDate` date DEFAULT NULL,
  `cancelDatetime` bigint(20) DEFAULT NULL,
  `cause_of_cancel` varchar(250) DEFAULT NULL,
  `CancelledBy` int(11) NOT NULL DEFAULT '0',
  `SubscriptionYorNo` int(11) NOT NULL DEFAULT '0',
  `payment_timeout` bigint(20) DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8366 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_weborder`
--

INSERT INTO `karloff_weborder` VALUES (8339,'1',54185197,90397517246,0,0,'',0,0,0,0,0,0,0,123.69,9.155,9.155,0,142,142,0,2,'TXN_SUCCESS','2020-05-29',1590726821,'29 May, 05:00 pm - 06:59 pm',232,2328,NULL,NULL,NULL,0,0,1590727301,'2020-05-29 10:03:41','2020-05-29 10:03:41'),(8340,'2',55598273,288833031675,0,0,'',0,0,0,0,0,0,0,458.5,11.75,11.75,0,482,482,0,2,'TXN_SUCCESS','2020-05-29',1590727255,'29 May, 01:00 pm - 02:59 pm',514,2329,NULL,NULL,NULL,0,0,1590727735,'2020-05-29 10:10:55','2020-05-29 10:10:55'),(8341,'2',54383726,35009114770,20,0,'',0,0,0,0,0,0,0,120,0,0,0,120,140,0,6,'TXN_UNPAID','2020-05-29',1590727603,'29 May, 03:00 pm - 04:59 pm',1377,0,'2020-05-29',1590690600,'Cancelled due to payment timeout.',0,0,1590727903,'2020-05-29 10:16:43','2020-05-29 10:16:43'),(8342,'2',54587696,288833031675,0,0,'',0,0,0,0,0,0,0,288.65,12.175,12.175,0,313,313,0,2,'TXN_SUCCESS','2020-05-29',1590729465,'29 May, 05:00 pm - 06:59 pm',514,2330,NULL,NULL,NULL,0,0,1590730125,'2020-05-29 10:47:45','2020-05-29 10:47:45'),(8343,'1',51329489,11786370710,0,0,'',0,0,0,0,0,0,0,225.13,8.435,8.435,0,242,242,0,2,'TXN_COD','2020-05-29',1590730033,'29 May, 05:00 pm - 06:59 pm',294,0,NULL,NULL,NULL,0,0,NULL,'2020-05-29 10:57:13','2020-05-29 10:57:13'),(8344,NULL,0,0,0,0,NULL,0,0,0,0,0,0,0,360,39.4,39.4,0,360,360,0,0,'0',NULL,NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-04 15:58:17','2020-06-04 15:58:17'),(8345,'2',506202018054540,2062020142531,0,0,NULL,0,0,0,0,0,0,0,645,58.05,58.05,0,645,645,0,7,'0','2020-06-05',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-05 19:21:36','2020-06-05 19:21:36'),(8346,'2',5,4,0,0,NULL,0,0,0,0,0,0,0,170,23.8,23.8,0,170,170,0,7,'0','2020-06-05',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-05 20:14:31','2020-06-05 20:14:31'),(8347,'2',606202016182940,2062020142531,0,0,NULL,0,0,0,0,0,0,0,445,38.75,38.75,0,445,445,0,7,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 16:18:32','2020-06-06 16:18:32'),(8348,'2',2020060616290040,2062020142531,0,0,NULL,0,0,0,0,0,0,0,225.8,21.5,21.5,0,245,245,0,7,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 16:29:04','2020-06-06 16:29:04'),(8349,'2',2020060616385640,1123455497,0,0,NULL,0,0,0,0,0,0,0,50.4,9.8,9.8,0,70,70,0,7,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 16:38:59','2020-06-06 16:38:59'),(8350,'2',2020060616411040,2062020142531,0,0,NULL,0,0,0,0,0,0,0,222.8,18.6,18.6,0,210,210,0,7,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 16:41:29','2020-06-06 16:41:29'),(8351,'2',2020060616593940,1123455497,0,0,NULL,0,0,0,0,0,0,0,457.9,38.55,38.55,0,535,535,0,7,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 16:59:59','2020-06-06 16:59:59'),(8352,'2',2020060617132240,2005636096,0,0,NULL,0,0,0,0,0,0,0,445.34,58.33,58.33,0,562,562,0,5,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 17:13:35','2020-06-06 17:13:35'),(8353,'2',2020060617165140,2005636096,0,0,NULL,0,0,0,0,0,0,0,329.64,36.18,36.18,0,402,402,0,5,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 17:23:39','2020-06-06 17:17:02'),(8354,'2',2020060617241240,2089683698,0,0,NULL,0,0,0,0,0,0,0,160.28,21.86,21.86,0,204,204,0,7,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 17:24:34','2020-06-06 17:24:15'),(8355,'2',2020060622271240,2089683698,0,0,NULL,0,0,0,0,0,0,0,61.2,11.9,11.9,0,85,85,0,7,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 22:27:18','2020-06-06 22:27:18'),(8356,'2',2020060622293340,2005636096,0,0,NULL,0,0,0,0,0,0,0,334.26,41.87,41.87,0,418,418,0,5,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 22:29:39','2020-06-06 22:29:39'),(8357,'2',2020060622340340,2062020143244,0,0,NULL,0,0,0,0,0,0,0,358.1,33.45,33.45,0,425,425,0,7,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 22:34:06','2020-06-06 22:34:06'),(8358,'2',2020060622361440,227506411,0,0,NULL,0,0,0,0,0,0,0,670.46,78.77,78.77,0,828,828,0,7,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 22:36:17','2020-06-06 22:36:17'),(8359,'2',2020060622400940,2005636096,0,0,NULL,0,0,0,0,0,0,0,384.66,51.67,51.67,0,488,488,0,5,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 22:40:13','2020-06-06 22:40:13'),(8360,'2',2020060622502640,2089683698,0,0,NULL,0,0,0,0,0,0,0,670.46,78.77,78.77,0,828,828,0,7,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 22:50:32','2020-06-06 22:50:32'),(8361,'2',2020060623020040,2005636096,0,0,NULL,0,0,0,0,0,0,0,513.9,50.55,50.55,0,615,615,0,5,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 23:02:05','2020-06-06 23:02:05'),(8362,'2',2020060623073940,2005636096,0,0,NULL,0,0,0,0,0,0,0,388.76,52.12,52.12,0,493,493,0,5,'0','2020-06-06',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-06 23:07:42','2020-06-06 23:07:42'),(8363,'2',2020060710251840,2089683698,0,0,NULL,0,0,0,0,0,0,0,654.82,85.59,85.59,0,826,826,0,7,'0','2020-06-07',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-07 10:25:23','2020-06-07 10:25:23'),(8364,'2',2020060713530440,2005636096,0,0,NULL,0,0,0,0,0,0,0,670.46,78.77,78.77,0,828,828,0,5,'0','2020-06-07',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-07 13:53:11','2020-06-07 13:53:11'),(8365,'2',2020060714015840,2005636096,0,0,NULL,0,0,0,0,0,0,0,334.26,41.87,41.87,0,418,418,0,5,'0','2020-06-07',NULL,NULL,0,0,NULL,NULL,NULL,0,0,NULL,'2020-06-07 14:02:02','2020-06-07 14:02:02');

--
-- Table structure for table `karloff_weborder_details`
--

CREATE TABLE `karloff_weborder_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) NOT NULL DEFAULT '0',
  `customer_id` bigint(20) NOT NULL DEFAULT '0',
  `product_id` int(11) DEFAULT NULL,
  `product_category_id` int(11) DEFAULT NULL,
  `product_subcategory_id` int(11) DEFAULT NULL,
  `CgstPercent` int(11) NOT NULL DEFAULT '0',
  `SgstPercent` int(11) NOT NULL DEFAULT '0',
  `IgstPercent` int(11) NOT NULL DEFAULT '0',
  `BaseValue` float NOT NULL DEFAULT '0',
  `CgstAmount` float NOT NULL DEFAULT '0',
  `SgstAmount` float NOT NULL DEFAULT '0',
  `IgstAmount` float NOT NULL DEFAULT '0',
  `RoundOffAmount` float NOT NULL DEFAULT '0',
  `CouponCode` varchar(50) DEFAULT NULL,
  `CouponCodeDiscount` int(11) NOT NULL DEFAULT '0',
  `CashbackCode` varchar(50) DEFAULT NULL,
  `CashbackDiscountAmount` int(11) NOT NULL DEFAULT '0',
  `qty` int(11) NOT NULL DEFAULT '0',
  `net_amount` float NOT NULL DEFAULT '0',
  `subYesorNot` int(11) NOT NULL DEFAULT '0',
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52088 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `karloff_weborder_details`
--

INSERT INTO `karloff_weborder_details` VALUES (51968,5524603,150379639967,978,5,25,0,0,0,60,0,0,0,0,NULL,0,NULL,0,2,60,0,'2020-05-29 00:44:52','2020-05-29 00:44:52'),(51969,5524603,150379639967,2384,8,37,0,0,0,46.6102,4.19,4.19,0,0,NULL,0,NULL,0,1,55,0,'2020-05-29 00:44:52','2020-05-29 00:44:52'),(51970,5524603,150379639967,1027,3,9,0,0,0,40,2,2,0,0,NULL,0,NULL,0,2,44,0,'2020-05-29 00:44:52','2020-05-29 00:44:52'),(51971,5524603,150379639967,360,1,2,0,0,0,115,0,0,0,0,NULL,0,NULL,0,5,115,0,'2020-05-29 00:44:52','2020-05-29 00:44:52'),(51972,51427945,529850189578,1220,2,11,0,0,0,247.619,6.19,6.19,0,0,NULL,0,NULL,0,4,260,0,'2020-05-29 07:55:14','2020-05-29 07:55:14'),(51973,5254018,529850189578,1220,2,11,0,0,0,247.619,6.19,6.19,0,0,NULL,0,NULL,0,4,260,0,'2020-05-29 07:57:25','2020-05-29 07:57:25'),(51974,50019509,1576177,360,1,2,0,0,0,22,0,0,0,0,NULL,0,NULL,0,1,22,0,'2020-05-29 08:12:00','2020-05-29 08:12:00'),(51975,50019509,1576177,359,1,2,0,0,0,9,0,0,0,0,NULL,0,NULL,0,1,9,0,'2020-05-29 08:12:00','2020-05-29 08:12:00'),(51976,5365481,1571330,2223,4,21,0,0,0,13.3929,0.8,0.8,0,0,NULL,0,NULL,0,1,15,0,'2020-05-29 09:26:36','2020-05-29 09:26:36'),(51977,51942591,23426776306,2228,3,10,0,0,0,46,0,0,0,0,NULL,0,NULL,0,2,46,0,'2020-05-29 09:35:19','2020-05-29 09:35:19'),(51978,51942591,23426776306,1437,8,30,0,0,0,33.0508,2.97,2.97,0,0,NULL,0,NULL,0,1,39,0,'2020-05-29 09:35:19','2020-05-29 09:35:19'),(51979,51942591,23426776306,1212,2,84,0,0,0,36,0,0,0,0,NULL,0,NULL,0,2,36,0,'2020-05-29 09:35:19','2020-05-29 09:35:19'),(51980,51942591,23426776306,1799,9,66,0,0,0,12.7119,1.14,1.14,0,0,NULL,0,NULL,0,1,15,0,'2020-05-29 09:35:19','2020-05-29 09:35:19'),(51981,51942591,23426776306,1800,9,66,0,0,0,8.47458,0.76,0.76,0,0,NULL,0,NULL,0,1,10,0,'2020-05-29 09:35:19','2020-05-29 09:35:19'),(51982,51942591,23426776306,2299,8,39,0,0,0,24.1071,1.45,1.45,0,0,NULL,0,NULL,0,1,27,0,'2020-05-29 09:35:19','2020-05-29 09:35:19'),(51983,51942591,23426776306,508,9,62,0,0,0,103.39,9.31,9.31,0,0,NULL,0,NULL,0,1,122,0,'2020-05-29 09:35:19','2020-05-29 09:35:19'),(51984,51942591,23426776306,498,9,62,0,0,0,48.3051,4.35,4.35,0,0,NULL,0,NULL,0,1,57,0,'2020-05-29 09:35:19','2020-05-29 09:35:19'),(51985,51942591,23426776306,2243,4,21,0,0,0,24.1071,1.45,1.45,0,0,NULL,0,NULL,0,1,27,0,'2020-05-29 09:35:19','2020-05-29 09:35:19'),(51986,51942591,23426776306,2040,3,43,0,0,0,68,0,0,0,0,NULL,0,NULL,0,1,68,0,'2020-05-29 09:35:19','2020-05-29 09:35:19'),(51987,54720081,23426776306,360,1,2,0,0,0,115,0,0,0,0,NULL,0,NULL,0,5,115,0,'2020-05-29 09:37:47','2020-05-29 09:37:47'),(51988,54921438,85072915488,1112,3,43,0,0,0,19.0476,0.48,0.48,0,0,NULL,0,NULL,0,1,20,0,'2020-05-29 09:41:49','2020-05-29 09:41:49'),(51989,54921438,85072915488,1001,3,8,0,0,0,12.381,0.31,0.31,0,0,NULL,0,NULL,0,1,13,0,'2020-05-29 09:41:49','2020-05-29 09:41:49'),(51990,54921438,85072915488,1027,3,9,0,0,0,20,1,1,0,0,NULL,0,NULL,0,1,22,0,'2020-05-29 09:41:49','2020-05-29 09:41:49'),(51991,54921438,85072915488,2592,3,8,0,0,0,23.2143,1.39,1.39,0,0,NULL,0,NULL,0,2,26,0,'2020-05-29 09:41:49','2020-05-29 09:41:49'),(51992,54921438,85072915488,2269,4,23,0,0,0,28.5714,0.71,0.71,0,0,NULL,0,NULL,0,1,30,0,'2020-05-29 09:41:49','2020-05-29 09:41:49'),(51993,50360246,85072915488,1112,3,43,0,0,0,19.0476,0.48,0.48,0,0,NULL,0,NULL,0,1,20,0,'2020-05-29 09:54:03','2020-05-29 09:54:03'),(51994,50360246,85072915488,2228,3,10,0,0,0,23,0,0,0,0,NULL,0,NULL,0,1,23,0,'2020-05-29 09:54:03','2020-05-29 09:54:03'),(51995,50360246,85072915488,1320,3,43,0,0,0,18.0952,0.45,0.45,0,0,NULL,0,NULL,0,1,19,0,'2020-05-29 09:54:03','2020-05-29 09:54:03'),(51996,50360246,85072915488,1741,3,43,0,0,0,39,0,0,0,0,NULL,0,NULL,0,1,39,0,'2020-05-29 09:54:03','2020-05-29 09:54:03'),(51997,50360246,85072915488,1027,3,9,0,0,0,40,2,2,0,0,NULL,0,NULL,0,2,44,0,'2020-05-29 09:54:03','2020-05-29 09:54:03'),(51998,50360246,85072915488,2592,3,8,0,0,0,23.2143,1.39,1.39,0,0,NULL,0,NULL,0,2,26,0,'2020-05-29 09:54:03','2020-05-29 09:54:03'),(51999,50360246,85072915488,1332,3,43,0,0,0,22.8571,0.57,0.57,0,0,NULL,0,NULL,0,1,24,0,'2020-05-29 09:54:03','2020-05-29 09:54:03'),(52000,50360246,85072915488,1001,3,8,0,0,0,12.381,0.31,0.31,0,0,NULL,0,NULL,0,1,13,0,'2020-05-29 09:54:03','2020-05-29 09:54:03'),(52001,50360246,85072915488,1279,3,43,0,0,0,14.2857,0.36,0.36,0,0,NULL,0,NULL,0,1,15,0,'2020-05-29 09:54:03','2020-05-29 09:54:03'),(52002,54185197,90397517246,508,9,62,0,0,0,101.695,9.15,9.15,0,0,NULL,0,NULL,0,1,120,0,'2020-05-29 10:03:41','2020-05-29 10:03:41'),(52003,54185197,90397517246,1214,2,84,0,0,0,22,0,0,0,0,NULL,0,NULL,0,1,22,0,'2020-05-29 10:03:41','2020-05-29 10:03:41'),(52004,55598273,288833031675,1290,3,43,0,0,0,22.8571,0.57,0.57,0,0,NULL,0,NULL,0,1,24,0,'2020-05-29 10:10:55','2020-05-29 10:10:55'),(52005,55598273,288833031675,1289,3,43,0,0,0,13.3333,0.33,0.33,0,0,NULL,0,NULL,0,1,14,0,'2020-05-29 10:10:55','2020-05-29 10:10:55'),(52006,55598273,288833031675,1069,3,43,0,0,0,72.381,1.81,1.81,0,0,NULL,0,NULL,0,1,76,0,'2020-05-29 10:10:55','2020-05-29 10:10:55'),(52007,55598273,288833031675,2318,3,40,0,0,0,83,0,0,0,0,NULL,0,NULL,0,1,83,0,'2020-05-29 10:10:55','2020-05-29 10:10:55'),(52008,55598273,288833031675,2304,3,40,0,0,0,83,0,0,0,0,NULL,0,NULL,0,1,83,0,'2020-05-29 10:10:55','2020-05-29 10:10:55'),(52009,55598273,288833031675,1027,3,9,0,0,0,20,1,1,0,0,NULL,0,NULL,0,1,22,0,'2020-05-29 10:10:55','2020-05-29 10:10:55'),(52010,55598273,288833031675,1022,3,40,0,0,0,112.5,6.75,6.75,0,0,NULL,0,NULL,0,1,126,0,'2020-05-29 10:10:55','2020-05-29 10:10:55'),(52011,55598273,288833031675,1293,3,43,0,0,0,13.3333,0.33,0.33,0,0,NULL,0,NULL,0,1,14,0,'2020-05-29 10:10:55','2020-05-29 10:10:55'),(52012,55598273,288833031675,2035,3,8,0,0,0,38.0952,0.95,0.95,0,0,NULL,0,NULL,0,1,40,0,'2020-05-29 10:10:55','2020-05-29 10:10:55'),(52013,54383726,35009114770,2017,8,36,0,0,0,120,0,0,0,0,NULL,0,NULL,0,3,120,0,'2020-05-29 10:16:43','2020-05-29 10:16:43'),(52014,54587696,288833031675,1069,3,43,0,0,0,72.381,1.81,1.81,0,0,NULL,0,NULL,0,1,76,0,'2020-05-29 10:47:45','2020-05-29 10:47:45'),(52015,54587696,288833031675,1467,9,30,0,0,0,76.2712,6.86,6.86,0,0,NULL,0,NULL,0,1,90,0,'2020-05-29 10:47:45','2020-05-29 10:47:45'),(52016,54587696,288833031675,1290,3,43,0,0,0,22.8571,0.57,0.57,0,0,NULL,0,NULL,0,1,24,0,'2020-05-29 10:47:45','2020-05-29 10:47:45'),(52017,54587696,288833031675,2204,3,42,0,0,0,117.143,2.93,2.93,0,0,NULL,0,NULL,0,1,123,0,'2020-05-29 10:47:45','2020-05-29 10:47:45'),(52018,51329489,11786370710,2432,4,23,0,0,0,20.339,1.83,1.83,0,0,NULL,0,NULL,0,1,24,0,'2020-05-29 10:57:13','2020-05-29 10:57:13'),(52019,51329489,11786370710,1690,4,23,0,0,0,27.1186,2.44,2.44,0,0,NULL,0,NULL,0,1,32,0,'2020-05-29 10:57:13','2020-05-29 10:57:13'),(52020,51329489,11786370710,1358,3,42,0,0,0,58.0952,1.45,1.45,0,0,NULL,0,NULL,0,1,61,0,'2020-05-29 10:57:13','2020-05-29 10:57:13'),(52021,51329489,11786370710,1323,3,42,0,0,0,108.571,2.71,2.71,0,0,NULL,0,NULL,0,1,114,0,'2020-05-29 10:57:13','2020-05-29 10:57:13'),(52022,51329489,11786370710,2391,3,9,0,0,0,11,0,0,0,0,NULL,0,NULL,0,1,11,0,'2020-05-29 10:57:13','2020-05-29 10:57:13'),(52023,0,0,NULL,NULL,NULL,0,0,0,0,0,0,0,0,NULL,0,NULL,0,0,0,0,'2020-06-04 16:25:03','2020-06-04 16:25:03'),(52024,0,32,253,6,19,0,0,0,140,19.6,19.6,0,0,NULL,0,NULL,0,2,70,0,'2020-06-05 16:38:26','2020-06-05 16:38:26'),(52025,0,32,2374,8,30,0,0,0,5,0.45,0.45,0,0,NULL,0,NULL,0,1,5,0,'2020-06-05 17:10:30','2020-06-05 17:10:30'),(52026,0,32,2420,8,30,0,0,0,215,19.35,19.35,0,0,NULL,0,NULL,0,1,215,0,'2020-06-05 17:18:50','2020-06-05 17:18:50'),(52027,506202018054540,2062020142531,2420,8,30,0,0,0,645,58.05,58.05,0,0,NULL,0,NULL,0,3,215,0,'2020-06-05 19:21:36','2020-06-05 19:21:36'),(52028,5,4,259,6,19,0,0,0,170,23.8,23.8,0,0,NULL,0,NULL,0,2,85,0,'2020-06-05 20:14:31','2020-06-05 20:14:31'),(52029,606202016182940,2062020142531,253,6,19,0,0,0,70,9.8,9.8,0,0,NULL,0,NULL,0,1,70,0,'2020-06-06 16:18:32','2020-06-06 16:18:32'),(52030,606202016182940,2062020142531,2420,8,30,0,0,0,215,19.35,19.35,0,0,NULL,0,NULL,0,1,215,0,'2020-06-06 16:19:00','2020-06-06 16:19:00'),(52031,606202016182940,2062020142531,2422,4,24,0,0,0,160,9.6,9.6,0,0,NULL,0,NULL,0,1,160,0,'2020-06-06 16:19:12','2020-06-06 16:19:12'),(52032,2020060616290040,2062020142531,259,6,19,0,0,0,85,11.9,11.9,0,0,NULL,0,NULL,0,1,85,0,'2020-06-06 16:29:04','2020-06-06 16:29:04'),(52033,2020060616290040,2062020142531,2422,4,24,0,0,0,140.8,9.6,9.6,0,0,NULL,0,NULL,0,1,160,0,'2020-06-06 16:33:25','2020-06-06 16:33:25'),(52034,2020060616385640,1123455497,253,6,19,0,0,0,50.4,9.8,9.8,0,0,NULL,0,NULL,0,1,70,0,'2020-06-06 16:38:59','2020-06-06 16:38:59'),(52035,2020060616411040,2062020142531,2422,4,24,0,0,0,140.8,9.6,9.6,0,0,NULL,0,NULL,0,1,160,0,'2020-06-06 16:41:29','2020-06-06 16:41:29'),(52036,2020060616411040,2062020142531,2378,8,37,0,0,0,61.5,6.75,6.75,0,0,NULL,0,NULL,0,3,25,0,'2020-06-06 16:41:54','2020-06-06 16:41:54'),(52037,2020060616411040,2062020142531,2374,8,30,0,0,0,20.5,2.25,2.25,0,0,NULL,0,NULL,0,5,25,0,'2020-06-06 16:56:44','2020-06-06 16:56:44'),(52038,2020060616593940,1123455497,2422,4,24,0,0,0,281.6,19.2,19.2,0,0,NULL,0,NULL,0,2,320,0,'2020-06-06 16:59:59','2020-06-06 16:59:59'),(52039,2020060616593940,1123455497,2421,8,30,0,0,0,176.3,19.35,19.35,0,0,NULL,0,NULL,0,1,215,0,'2020-06-06 17:01:19','2020-06-06 17:01:19'),(52040,2020060617132240,2005636096,2044,8,37,0,0,0,329.64,36.18,36.18,0,0,NULL,0,NULL,0,3,402,0,'2020-06-06 17:13:35','2020-06-06 17:13:35'),(52041,2020060617132240,2005636096,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,1,85,0,'2020-06-06 17:13:44','2020-06-06 17:13:44'),(52042,2020060617132240,2005636096,253,6,19,0,0,0,50.4,9.8,9.8,0,0,NULL,0,NULL,0,1,70,0,'2020-06-06 17:13:49','2020-06-06 17:13:49'),(52043,2020060617132240,2005636096,2374,8,30,0,0,0,4.1,0.45,0.45,0,0,NULL,0,NULL,0,1,5,0,'2020-06-06 17:14:22','2020-06-06 17:14:22'),(52044,2020060617165140,2005636096,2044,8,37,0,0,0,329.64,36.18,36.18,0,0,NULL,0,NULL,0,3,402,0,'2020-06-06 17:17:01','2020-06-06 17:17:01'),(52046,2020060617241240,2089683698,253,6,19,0,0,0,50.4,9.8,9.8,0,0,NULL,0,NULL,0,1,70,0,'2020-06-06 17:24:15','2020-06-06 17:24:15'),(52048,2020060617241240,2089683698,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,1,134,0,'2020-06-06 17:24:16','2020-06-06 17:24:16'),(52049,2020060622271240,2089683698,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,1,85,0,'2020-06-06 22:27:17','2020-06-06 22:27:17'),(52050,2020060622293340,2005636096,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,1,85,0,'2020-06-06 22:29:39','2020-06-06 22:29:39'),(52051,2020060622293340,2005636096,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,1,134,0,'2020-06-06 22:29:45','2020-06-06 22:29:45'),(52052,2020060622293340,2005636096,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,1,199,0,'2020-06-06 22:29:47','2020-06-06 22:29:47'),(52053,2020060622340340,2062020143244,2378,8,37,0,0,0,41,4.5,4.5,0,0,NULL,0,NULL,0,2,25,0,'2020-06-06 22:34:06','2020-06-06 22:34:06'),(52054,2020060622340340,2062020143244,2421,8,30,0,0,0,176.3,19.35,19.35,0,0,NULL,0,NULL,0,1,215,0,'2020-06-06 22:34:07','2020-06-06 22:34:07'),(52055,2020060622340340,2062020143244,2422,4,24,0,0,0,140.8,9.6,9.6,0,0,NULL,0,NULL,0,1,160,0,'2020-06-06 22:34:08','2020-06-06 22:34:08'),(52056,2020060622361440,227506411,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,1,85,0,'2020-06-06 22:36:17','2020-06-06 22:36:17'),(52057,2020060622361440,227506411,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,1,134,0,'2020-06-06 22:36:17','2020-06-06 22:36:17'),(52058,2020060622361440,227506411,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,1,199,0,'2020-06-06 22:36:18','2020-06-06 22:36:18'),(52059,2020060622361440,227506411,2063,8,38,0,0,0,336.2,36.9,36.9,0,0,NULL,0,NULL,0,1,410,0,'2020-06-06 22:36:18','2020-06-06 22:36:18'),(52060,2020060622400940,2005636096,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,1,134,0,'2020-06-06 22:40:13','2020-06-06 22:40:13'),(52061,2020060622400940,2005636096,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,1,85,0,'2020-06-06 22:40:14','2020-06-06 22:40:14'),(52062,2020060622400940,2005636096,253,6,19,0,0,0,50.4,9.8,9.8,0,0,NULL,0,NULL,0,1,70,0,'2020-06-06 22:40:14','2020-06-06 22:40:14'),(52063,2020060622400940,2005636096,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,1,199,0,'2020-06-06 22:40:15','2020-06-06 22:40:15'),(52064,2020060622502640,2089683698,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,1,134,0,'2020-06-06 22:50:32','2020-06-06 22:50:32'),(52065,2020060622502640,2089683698,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,1,85,0,'2020-06-06 22:50:32','2020-06-06 22:50:32'),(52066,2020060622502640,2089683698,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,1,199,0,'2020-06-06 22:50:33','2020-06-06 22:50:33'),(52067,2020060622502640,2089683698,2063,8,38,0,0,0,336.2,36.9,36.9,0,0,NULL,0,NULL,0,1,410,0,'2020-06-06 22:50:34','2020-06-06 22:50:34'),(52068,2020060623020040,2005636096,2378,8,37,0,0,0,20.5,2.25,2.25,0,0,NULL,0,NULL,0,1,25,0,'2020-06-06 23:02:05','2020-06-06 23:02:05'),(52069,2020060623020040,2005636096,2420,8,30,0,0,0,176.3,19.35,19.35,0,0,NULL,0,NULL,0,1,215,0,'2020-06-06 23:02:05','2020-06-06 23:02:05'),(52070,2020060623020040,2005636096,2421,8,30,0,0,0,176.3,19.35,19.35,0,0,NULL,0,NULL,0,1,215,0,'2020-06-06 23:02:06','2020-06-06 23:02:06'),(52071,2020060623020040,2005636096,2422,4,24,0,0,0,140.8,9.6,9.6,0,0,NULL,0,NULL,0,1,160,0,'2020-06-06 23:02:06','2020-06-06 23:02:06'),(52072,2020060623073940,2005636096,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,1,199,0,'2020-06-06 23:07:42','2020-06-06 23:07:42'),(52073,2020060623073940,2005636096,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,1,134,0,'2020-06-06 23:07:43','2020-06-06 23:07:43'),(52074,2020060623073940,2005636096,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,1,85,0,'2020-06-06 23:07:44','2020-06-06 23:07:44'),(52075,2020060623073940,2005636096,253,6,19,0,0,0,50.4,9.8,9.8,0,0,NULL,0,NULL,0,1,70,0,'2020-06-06 23:07:44','2020-06-06 23:07:44'),(52076,2020060623073940,2005636096,2374,8,30,0,0,0,4.1,0.45,0.45,0,0,NULL,0,NULL,0,1,5,0,'2020-06-06 23:07:57','2020-06-06 23:07:57'),(52077,2020060710251840,2089683698,2044,8,37,0,0,0,329.64,36.18,36.18,0,0,NULL,0,NULL,0,3,134,0,'2020-06-07 10:25:22','2020-06-07 10:25:22'),(52078,2020060710251840,2089683698,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,1,85,0,'2020-06-07 10:25:24','2020-06-07 10:25:24'),(52079,2020060710251840,2089683698,253,6,19,0,0,0,100.8,19.6,19.6,0,0,NULL,0,NULL,0,2,70,0,'2020-06-07 10:26:15','2020-06-07 10:26:15'),(52080,2020060710251840,2089683698,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,1,199,0,'2020-06-07 10:37:25','2020-06-07 10:37:25'),(52081,2020060713530440,2005636096,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,1,199,0,'2020-06-07 13:53:11','2020-06-07 13:53:11'),(52082,2020060713530440,2005636096,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,1,134,0,'2020-06-07 13:53:11','2020-06-07 13:53:11'),(52083,2020060713530440,2005636096,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,1,85,0,'2020-06-07 13:53:12','2020-06-07 13:53:12'),(52084,2020060713530440,2005636096,2063,8,38,0,0,0,336.2,36.9,36.9,0,0,NULL,0,NULL,0,1,410,0,'2020-06-07 13:53:12','2020-06-07 13:53:12'),(52085,2020060714015840,2005636096,2050,8,37,0,0,0,163.18,17.91,17.91,0,0,NULL,0,NULL,0,1,199,0,'2020-06-07 14:02:02','2020-06-07 14:02:02'),(52086,2020060714015840,2005636096,2044,8,37,0,0,0,109.88,12.06,12.06,0,0,NULL,0,NULL,0,1,134,0,'2020-06-07 14:02:02','2020-06-07 14:02:02'),(52087,2020060714015840,2005636096,259,6,19,0,0,0,61.2,11.9,11.9,0,0,NULL,0,NULL,0,1,85,0,'2020-06-07 14:02:02','2020-06-07 14:02:02');

--
-- Dumping events for database 'ebillingapp'
--

--
-- Dumping routines for database 'ebillingapp'
--
/*!50003 DROP PROCEDURE IF EXISTS `sp_AddtoCart_OneProduct` */;
DELIMITER ;;
CREATE  PROCEDURE `sp_AddtoCart_OneProduct`(IN intProductID INT,
IN intCustomerID BIGINT,
IN intOrderID BIGINT,
IN intQty INT,
IN intUserID INT)
BEGIN
DECLARE intStoreID,intProdCat,intProdSubCat,intPseudoStock,isOrderDetailsPresent,isProductDetailsPresent INT;
DECLARE fProdOfferPrice,fProdClubPrice,fIGSTPer,fCGSTPer,fSGSTPer float;
DECLARE fPriceP,fRate,fCGST,fSGST,fIGST FLOAT;
DECLARE isCustomerClubMember VARCHAR(10);

SET intStoreID = 0; SET intProdCat = 0; SET intProdSubCat = 0;set intPseudoStock = 0; set isOrderDetailsPresent =0; SET isProductDetailsPresent =0;
SET fProdOfferPrice = 0;SET fProdClubPrice = 0;SET fIGSTPer = 0;SET fCGSTPer = 0;SET fSGSTPer = 0;
SET fPriceP =0; set fRate = 0; set fCGST = 0; set fSGST =0; set fIGST = 0;

select adm_store INTO intStoreID from karloff_admin where id = intUserID;

  CALL `sp_getCustomerClubMemberDetails`(intCustomerID,isCustomerClubMember);
  
select ProductOfferprice,ProductClubprice,PseudoStock,ProductIgst,ProductCgst,ProductSgst,
ProductCategory,ProductSubcategoryL1 into fProdOfferPrice,fProdClubPrice,intPseudoStock,
fIGSTPer,fCGSTPer,fSGSTPer,intProdCat,intProdSubCat	

from karloff_productdb where id = intProductID;
			 
		IF (isCustomerClubMember = 'Yes') THEN
		  SET fPriceP = fProdClubPrice;
		ELSE
		 SET fPriceP = fProdOfferPrice;
		END IF;
		
		   
set fPriceP = (fPriceP * intQty);
-- set fRate = (fPriceP * intQty);
set fCGST = (fPriceP * (fCGSTPer/100));
set fSGST = (fPriceP * (fSGSTPer/100));
set fIGST = (fPriceP * (fIGSTPer/100));

set fRate = (fPriceP -(fCGST + fSGST + fIGST));


SELECT Count(ID) into isProductDetailsPresent FROM karloff_weborder_details WHERE order_id = intOrderID and product_id = intProductID;

IF (isProductDetailsPresent > 0) THEN

 UPDATE karloff_weborder_details SET BaseValue = (BaseValue + fRate),CgstAmount = (CgstAmount + fCGST),SgstAmount = (SgstAmount + fSGST),
 IgstAmount = (IgstAmount + fIGST), qty = (qty + intQty)  
  WHERE order_id = intOrderID and product_id = intProductID;

ELSE
 INSERT INTO `karloff_weborder_details`(`order_id`,`customer_id`,`product_id`,`product_category_id`,`product_subcategory_id`,`BaseValue`,`CgstAmount`,
`SgstAmount`,`IgstAmount`,`qty`,`net_amount`,`updated_at`,`created_at`)
VALUES(intOrderID,intCustomerID,intProductID,intProdCat,intProdSubCat,fRate,fCGST,fSGST,fIGST,intQty,fPriceP,CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP());

END IF;


SELECT Count(ID) into isOrderDetailsPresent FROM karloff_weborder WHERE order_id = intOrderID;

	IF (isOrderDetailsPresent > 0) THEN
				
		update karloff_weborder set BaseValue = (BaseValue + fRate),CgstAmount = (CgstAmount + fCGST), 
		SgstAmount = (SgstAmount + fSGST),IgstAmount = (IgstAmount + fIGST),InvoiceAmount = (InvoiceAmount + fPriceP),
		NetAmount = (NetAmount + fPriceP)
		where order_id = intOrderID;
		
		
	ELSE
       INSERT INTO `karloff_weborder`(`storeId`,`order_id`,`customer_id`,`BaseValue`,`CgstAmount`,`SgstAmount`,`IgstAmount`,`InvoiceAmount`,
		`NetAmount`,`order_status`,`order_date`,`updated_at`,`created_at`)
		VALUES(intStoreID,intOrderID,intCustomerID,fRate,fCGST,fSGST,fIGST,fPriceP,fPriceP,7,Current_Date(),CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP());
	END IF;


 CALL sp_UpdatePsudoProductStock(intProductID,intQty,intOrderID,1);

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_AddtoCart_OneProduct_main` */;
DELIMITER ;;
CREATE  PROCEDURE `sp_AddtoCart_OneProduct_main`(IN intProductID INT,
IN intCustomerID varchar(200),
IN intOrderID varchar(200),
IN intQty INT,
IN intUserID INT)
BEGIN

call sp_AddtoCart_OneProduct(intProductID,intCustomerID,intOrderID,intQty,intUserID);

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_generateInvoice_details` */;
DELIMITER ;;
CREATE  PROCEDURE `sp_generateInvoice_details`(IN intCardAmount INT,
IN intCashAmount INT,
IN intPaytemAmount INT,
IN intOnlineAmount INT,
IN intUserID INT,
IN intOrderID BIGINT)
BEGIN
DECLARE intCurrentMaxInvoiveID,intNewInvoiveID,intTHISInvoiveIDPresent,intStoreID,intNetAmount INT;

set intCurrentMaxInvoiveID =0; set intNewInvoiveID =0;set intTHISInvoiveIDPresent =0;set intStoreID=0;set intNetAmount =0;

select MAX(invoice_id) into intCurrentMaxInvoiveID from karloff_invoice_master;
SET intNewInvoiveID = (intCurrentMaxInvoiveID + 1);
select COUNT(id) into intTHISInvoiveIDPresent from karloff_invoice_master where invoice_id = intNewInvoiveID;
IF (intTHISInvoiveIDPresent > 0) THEN
	SET intNewInvoiveID = (intNewInvoiveID + 1);
END IF;

select adm_store INTO intStoreID from karloff_admin where id = intUserID;
select NetAmount INTO intNetAmount from karloff_weborder where order_id = intOrderID;


INSERT INTO `karloff_invoice_master`(`invoice_id`,`order_id`,`customer_id`,`delivery_charge`,`GoCashPay`,`Promocode`,`PromocodeDiscount`,`PromoDiscBasePrice`,`PromoDiscGST`,
`CouponCodeTotalDiscount`,`CashbackTotalDiscount`,`discount_amount`,`RedeemAmount`,`BaseValue`,`CgstAmount`,`SgstAmount`,`IgstAmount`,`InvoiceAmount`,`NetAmount`,
`round_off_amount`,`order_status`,`payment_code`,`InvoiceDate`,`order_receive_date`,`order_receive_datetime`,`delivery_date`,`sale_point`,`sales_person`,
`sale_type`,`updated_at`,`created_at`) 
SELECT intNewInvoiveID,`order_id`,`customer_id`,`delivery_charge`,`GoCashPay`,`Promocode`,`PromocodeDiscount`,`PromoDiscBasePrice`,`PromoDiscGST`,
`CouponCodeTotalDiscount`,`CashbackTotalDiscount`,`discount_amount`,`RedeemAmount`,`BaseValue`,`CgstAmount`,`SgstAmount`,`IgstAmount`,`InvoiceAmount`,`NetAmount`,
`round_off_amount`,`order_status`,`payment_code`,Current_Date(),`order_date`,`order_datetime`,Current_Date(),intStoreID,intUserID,3,CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP()
 FROM `karloff_weborder` WHERE order_id = intOrderID;

UPDATE `karloff_invoice_master` SET order_status = 5 WHERE order_id = intOrderID;
UPDATE `karloff_weborder` SET order_status = 5 WHERE order_id = intOrderID;

INSERT INTO `karloff_invoice_details`(`invoice_id`,`order_id`,`customer_id`,`product_id`,`product_category_id`,`product_subcategory_id`,`CgstPercent`,`SgstPercent`,`IgstPercent`,
`BaseValue`,`CgstAmount`,`SgstAmount`,`IgstAmount`,`RoundOffAmount`,`CouponCode`,`CouponCodeDiscount`,`CashbackCode`,`CashbackDiscountAmount`,
`subYesorNot`,`qty`,`net_amount`,`updated_at`,`created_at`)
SELECT intNewInvoiveID,`order_id`,`customer_id`,`product_id`,`product_category_id`,`product_subcategory_id`,`CgstPercent`,`SgstPercent`,`IgstPercent`,
`BaseValue`,`CgstAmount`,`SgstAmount`,`IgstAmount`,`RoundOffAmount`,`CouponCode`,`CouponCodeDiscount`,`CashbackCode`,`CashbackDiscountAmount`,
`subYesorNot`,`qty`,`net_amount`,CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP() FROM `karloff_weborder_details` WHERE order_id = intOrderID;

INSERT INTO `karloff_account_manager`(`invoice_no`,`NetAmount`,`PromocodeDiscount`,`GoCashAmount`,`cash_amount`,`card_amount`,`paytm_amount`,`online_amount`,
`settled`,`updated_at`,`created_at`) VALUES(intNewInvoiveID,intNetAmount,0,0,intCashAmount,intCardAmount,intPaytemAmount,intOnlineAmount,1,CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP());

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_generateInvoice_details_main` */;
DELIMITER ;;
CREATE  PROCEDURE `sp_generateInvoice_details_main`(IN intCardAmount INT,
IN intCashAmount INT,
IN intPaytemAmount INT,
IN intOnlineAmount INT,
IN intUserID INT,
IN intOrderID varchar(200))
BEGIN
CALL sp_generateInvoice_details(intCardAmount,intCashAmount,intPaytemAmount,intOnlineAmount,intUserID,intOrderID);
END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_getCartDetails_fromOrderID` */;
DELIMITER ;;
CREATE  PROCEDURE `sp_getCartDetails_fromOrderID`(IN intOrderID varchar(200))
BEGIN

-- select `product_id`,`BaseValue`,`CgstAmount`,`SgstAmount`,`IgstAmount`,`qty`,`net_amount` from karloff_weborder_details where order_id = intOrderID;
select t2.ProductName,`product_id`,`BaseValue`,`CgstAmount`,`SgstAmount`,`IgstAmount`,`qty`,`net_amount` 
from karloff_weborder_details t1,karloff_productdb t2 where t1.product_id=t2.id and order_id = intOrderID;


select `BaseValue`,`CgstAmount`,`SgstAmount`,`IgstAmount`,`NetAmount` from karloff_weborder where order_id = intOrderID;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_getCustomerClubMemberDetails` */;
DELIMITER ;;
CREATE  PROCEDURE `sp_getCustomerClubMemberDetails`(IN intCustomerID BIGINT,OUT strYesNo VARCHAR(20))
BEGIN
DECLARE intRowPresent INT;
SET strYesNo = 'No';
SET intRowPresent = 0;

	select (Select Count(ID) from karloff_club_membership where customer_id = t1.customer_id 
	and  expiry >= Current_Date()) INTO intRowPresent 
	from karloff_customer t1 where t1.id = intCustomerID;
    
    IF (intRowPresent > 0) THEN
      SET strYesNo = 'Yes';
    END IF;
                
END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_UpdatePsudoProductStock` */;
DELIMITER ;;
CREATE  PROCEDURE `sp_UpdatePsudoProductStock`(IN intProductID INT,
IN intQty INT,
IN intOrderID varchar(200),
IN intRemoved INT)
BEGIN

	IF (intRemoved = 1) THEN  -- Product Added on cart
      update karloff_productdb set PseudoStock = (PseudoStock - intQty) where id = intProductID;
	ELSE   -- Product Removed from cart
       update karloff_productdb set PseudoStock = (PseudoStock + intQty) where id = intProductID;
   
     CALL sp_UpdateWebOrderTableforProductRemoved(intProductID,intQty,intOrderID);
	
    END IF;
END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_UpdateWebOrderTableforProductRemoved` */;
DELIMITER ;;
CREATE  PROCEDURE `sp_UpdateWebOrderTableforProductRemoved`(IN intProductID INT,
IN intQty INT,
IN intOrderID BIGINT)
BEGIN

DECLARE fPriceP,fRate,fCGST,fSGST,fIGST FLOAT;

SET fPriceP =0; set fRate = 0; set fCGST = 0; set fSGST =0; set fIGST = 0;

SELECT `BaseValue`,`CgstAmount`,`SgstAmount`,`IgstAmount`,`net_amount` 
INTO fRate,fCGST,fSGST,fIGST,fPriceP
FROM karloff_weborder_details WHERE order_id = intOrderID AND product_id = intProductID;


update karloff_weborder set BaseValue = (BaseValue - fRate),CgstAmount = (CgstAmount - fCGST), 
		SgstAmount = (SgstAmount - fSGST),IgstAmount = (IgstAmount - fIGST),InvoiceAmount = (InvoiceAmount - fPriceP),
		NetAmount = (NetAmount - fPriceP),updated_at= CURRENT_TIMESTAMP()
		where order_id = intOrderID;

DELETE FROM karloff_weborder_details WHERE order_id = intOrderID AND product_id = intProductID;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `test_procedure` */;
DELIMITER ;;
CREATE  PROCEDURE `test_procedure`()
BEGIN
DECLARE intProductID,intQty,intUserID INT;
DECLARE intCustomerID,intOrderID BIGINT;
/* -- DECLARE Param5 VARCHAR(500);
 --  `sp_AddtoCart_OneProduct`(IN intProductID INT,IN intCustomerID BIGINT,IN intOrderID BIGINT,IN intQty INT,IN intUserID INT) 
 
 SET intProductID = 2420; SET intQty =1;  SET intUserID = 40;
  SET intCustomerID = 2062020142531; SET intOrderID =0506202018054540; 
  
 call `sp_AddtoCart_OneProduct`(intProductID,intCustomerID,intOrderID,intQty,intUserID);
-- SELECT Param3;
 -- select ;
 */
 SET intProductID = 259; SET intQty =2;
  SET intOrderID =2020060617165140; 
 call sp_UpdatePsudoProductStock(intProductID,intQty,intOrderID,0);
END ;;
DELIMITER ;


