--
-- Host: 127.0.0.1    Database: inventory
-- ------------------------------------------------------


--
-- Table structure for table `ic_customaer_shopping_address`
--

CREATE TABLE `ic_customaer_shopping_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_customaer_shopping_address`
--


--
-- Table structure for table `ic_customer_due`
--

CREATE TABLE `ic_customer_due` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) DEFAULT NULL,
  `warehouse_id` int(11) DEFAULT NULL,
  `total_due` decimal(10,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_customer_due`
--

INSERT INTO `ic_customer_due` VALUES (1,5,3,15378.00),(2,10,3,924.00),(3,8,3,1941654.00),(4,2,3,28710.00),(5,11,3,0.00),(6,4,3,2706.00),(7,1,1,0.00),(8,1,4,396.00),(9,1,3,0.00),(10,6,3,1543036.00),(11,7,3,4881153.00),(12,NULL,3,0.00),(13,3,3,16830.00);

--
-- Table structure for table `ic_customer_payments`
--

CREATE TABLE `ic_customer_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) DEFAULT NULL,
  `warehouse_id` int(11) DEFAULT NULL,
  `paid_amount` decimal(10,2) DEFAULT '0.00',
  `sales` decimal(10,2) DEFAULT '0.00',
  `customer_type` varchar(45) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `transaction_type` varchar(45) DEFAULT NULL,
  `chack_no` varchar(45) DEFAULT NULL,
  `bank_name` varchar(45) DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `paid_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=357 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_customer_payments`
--

INSERT INTO `ic_customer_payments` VALUES (11,5,3,0.00,976800.00,NULL,1,NULL,NULL,NULL,NULL,'Invoice','2018-05-28','2018-06-03 02:33:51','2018-06-03 02:33:51'),(12,5,3,976800.00,0.00,NULL,1,NULL,NULL,NULL,NULL,'Invoice','2018-05-28','2018-06-03 02:33:51','2018-06-03 02:33:51'),(23,10,3,0.00,3300.00,NULL,4,NULL,NULL,NULL,NULL,'Invoice','2018-06-03','2018-07-06 22:42:22','2018-07-06 22:42:22'),(24,10,3,2376.00,0.00,NULL,4,NULL,NULL,NULL,NULL,'Invoice','2018-06-03','2018-07-06 22:42:22','2018-07-06 22:42:22'),(65,2,3,0.00,28710.00,NULL,6,NULL,NULL,NULL,NULL,'Invoice','2018-07-07','2018-07-06 23:14:08','2018-07-06 23:14:08'),(66,2,3,0.00,0.00,NULL,6,NULL,NULL,NULL,NULL,'Invoice','2018-07-07','2018-07-06 23:14:08','2018-07-06 23:14:08'),(75,1,4,0.00,396.00,NULL,10,NULL,NULL,NULL,NULL,'Invoice','2018-07-07','2018-07-07 01:35:44','2018-07-07 01:35:44'),(76,1,4,0.00,0.00,NULL,10,NULL,NULL,NULL,NULL,'Invoice','2018-07-07','2018-07-07 01:35:44','2018-07-07 01:35:44'),(77,6,3,0.00,660.00,NULL,11,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-07 21:58:37','2018-07-07 21:58:37'),(78,6,3,0.00,0.00,NULL,11,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-07 21:58:37','2018-07-07 21:58:37'),(79,6,3,0.00,660.00,NULL,12,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-07 22:14:49','2018-07-07 22:14:49'),(80,6,3,0.00,0.00,NULL,12,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-07 22:14:49','2018-07-07 22:14:49'),(81,7,3,0.00,990.00,NULL,3,NULL,NULL,NULL,NULL,'Invoice','2018-05-29','2018-07-07 22:15:56','2018-07-07 22:15:56'),(82,7,3,0.00,0.00,NULL,3,NULL,NULL,NULL,NULL,'Invoice','2018-05-29','2018-07-07 22:15:56','2018-07-07 22:15:56'),(87,8,3,0.00,732600.00,NULL,15,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-07 23:18:39','2018-07-07 23:18:39'),(88,8,3,0.00,0.00,NULL,15,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-07 23:18:39','2018-07-07 23:18:39'),(89,5,3,0.00,2970.00,NULL,16,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 00:14:11','2018-07-08 00:14:11'),(90,5,3,0.00,0.00,NULL,16,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 00:14:11','2018-07-08 00:14:11'),(91,8,3,0.00,28600.00,NULL,17,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 00:32:04','2018-07-08 00:32:04'),(92,8,3,0.00,0.00,NULL,17,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 00:32:04','2018-07-08 00:32:04'),(185,8,3,0.00,74470.00,NULL,25,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 06:16:20','2018-07-08 06:16:20'),(186,8,3,0.00,0.00,NULL,25,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 06:16:20','2018-07-08 06:16:20'),(187,NULL,3,0.00,74470.00,NULL,25,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 06:16:40','2018-07-08 06:16:40'),(188,NULL,3,0.00,0.00,NULL,25,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 06:16:40','2018-07-08 06:16:40'),(193,8,3,0.00,396.00,NULL,22,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 06:29:28','2018-07-08 06:29:28'),(194,8,3,0.00,0.00,NULL,22,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 06:29:28','2018-07-08 06:29:28'),(195,8,3,0.00,60170.00,NULL,20,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 23:00:24','2018-07-08 23:00:24'),(196,8,3,0.00,0.00,NULL,20,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 23:00:24','2018-07-08 23:00:24'),(207,4,3,0.00,977790.00,NULL,1,NULL,NULL,NULL,NULL,'Invoice','2018-05-28','2018-07-08 23:33:51','2018-07-08 23:33:51'),(208,4,3,976800.00,0.00,NULL,1,NULL,NULL,NULL,NULL,'Invoice','2018-05-28','2018-07-08 23:33:51','2018-07-08 23:33:51'),(213,7,3,0.00,732864.00,NULL,22,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 23:45:06','2018-07-08 23:45:06'),(214,7,3,0.00,0.00,NULL,22,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-08 23:45:06','2018-07-08 23:45:06'),(217,7,3,0.00,528.00,NULL,26,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-08 23:46:42','2018-07-08 23:46:42'),(218,7,3,0.00,0.00,NULL,26,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-08 23:46:42','2018-07-08 23:46:42'),(221,7,3,0.00,1320.00,NULL,27,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-08 23:50:45','2018-07-08 23:50:45'),(222,7,3,0.00,0.00,NULL,27,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-08 23:50:45','2018-07-08 23:50:45'),(225,4,3,0.00,1716.00,NULL,28,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-08 23:55:50','2018-07-08 23:55:50'),(226,4,3,0.00,0.00,NULL,28,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-08 23:55:50','2018-07-08 23:55:50'),(261,5,3,0.00,13398.00,NULL,30,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 01:35:52','2018-07-09 01:35:52'),(262,5,3,0.00,0.00,NULL,30,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 01:35:52','2018-07-09 01:35:52'),(263,NULL,3,0.00,13398.00,NULL,30,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 01:38:20','2018-07-09 01:38:20'),(264,NULL,3,0.00,0.00,NULL,30,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 01:38:20','2018-07-09 01:38:20'),(269,6,3,0.00,1848.00,NULL,29,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 01:41:30','2018-07-09 01:41:30'),(270,6,3,0.00,0.00,NULL,29,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 01:41:30','2018-07-09 01:41:30'),(271,8,3,0.00,528.00,NULL,32,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 01:43:44','2018-07-09 01:43:44'),(272,8,3,0.00,0.00,NULL,32,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 01:43:45','2018-07-09 01:43:45'),(273,6,3,0.00,924.00,NULL,33,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 01:51:22','2018-07-09 01:51:22'),(274,6,3,0.00,0.00,NULL,33,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 01:51:22','2018-07-09 01:51:22'),(277,6,3,0.00,792.00,NULL,31,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 02:57:57','2018-07-09 02:57:57'),(278,6,3,0.00,0.00,NULL,31,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 02:57:57','2018-07-09 02:57:57'),(279,7,3,0.00,1056.00,NULL,35,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:00:20','2018-07-09 03:00:20'),(280,7,3,0.00,0.00,NULL,35,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:00:20','2018-07-09 03:00:20'),(283,8,3,0.00,2904.00,NULL,34,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:15:58','2018-07-09 03:15:58'),(284,8,3,0.00,0.00,NULL,34,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:15:58','2018-07-09 03:15:58'),(287,8,3,0.00,1980.00,NULL,36,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:22:57','2018-07-09 03:22:57'),(288,8,3,0.00,0.00,NULL,36,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:22:57','2018-07-09 03:22:57'),(293,6,3,0.00,1056.00,NULL,37,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:31:24','2018-07-09 03:31:24'),(294,6,3,0.00,0.00,NULL,37,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:31:24','2018-07-09 03:31:24'),(295,8,3,0.00,1320.00,NULL,38,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:34:50','2018-07-09 03:34:50'),(296,8,3,0.00,0.00,NULL,38,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:34:50','2018-07-09 03:34:50'),(297,6,3,0.00,57200.00,NULL,39,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:45:37','2018-07-09 03:45:37'),(298,6,3,0.00,0.00,NULL,39,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:45:38','2018-07-09 03:45:38'),(299,7,3,0.00,185900.00,NULL,40,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:49:45','2018-07-09 03:49:45'),(300,7,3,0.00,0.00,NULL,40,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 03:49:45','2018-07-09 03:49:45'),(301,8,3,0.00,132.00,NULL,21,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-09 03:59:11','2018-07-09 03:59:11'),(302,8,3,0.00,0.00,NULL,21,NULL,NULL,NULL,NULL,'Invoice','2018-07-08','2018-07-09 03:59:11','2018-07-09 03:59:11'),(303,7,3,0.00,976800.00,NULL,42,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:00:35','2018-07-09 04:00:35'),(304,7,3,0.00,0.00,NULL,42,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:00:35','2018-07-09 04:00:35'),(305,7,3,0.00,976800.00,NULL,44,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:04:34','2018-07-09 04:04:34'),(306,7,3,0.00,0.00,NULL,44,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:04:34','2018-07-09 04:04:34'),(307,7,3,0.00,3960.00,NULL,45,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:05:07','2018-07-09 04:05:07'),(308,7,3,0.00,0.00,NULL,45,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:05:07','2018-07-09 04:05:07'),(309,7,3,0.00,28600.00,NULL,47,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:06:05','2018-07-09 04:06:05'),(310,7,3,0.00,0.00,NULL,47,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:06:05','2018-07-09 04:06:05'),(311,7,3,0.00,792.00,NULL,41,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:06:11','2018-07-09 04:06:11'),(312,7,3,0.00,0.00,NULL,41,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:06:11','2018-07-09 04:06:11'),(313,7,3,0.00,143000.00,NULL,46,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:13:21','2018-07-09 04:13:21'),(314,7,3,0.00,0.00,NULL,46,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:13:21','2018-07-09 04:13:21'),(315,6,3,0.00,976800.00,NULL,49,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:18:06','2018-07-09 04:18:06'),(316,6,3,0.00,0.00,NULL,49,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:18:06','2018-07-09 04:18:06'),(317,8,3,0.00,976800.00,NULL,48,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:25:09','2018-07-09 04:25:09'),(318,8,3,0.00,0.00,NULL,48,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:25:09','2018-07-09 04:25:09'),(319,6,3,0.00,396.00,NULL,43,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:25:32','2018-07-09 04:25:32'),(320,6,3,0.00,0.00,NULL,43,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:25:32','2018-07-09 04:25:32'),(321,7,3,0.00,990.00,NULL,51,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:29:47','2018-07-09 04:29:47'),(322,7,3,0.00,0.00,NULL,51,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:29:47','2018-07-09 04:29:47'),(323,8,3,0.00,3960.00,NULL,50,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:40:33','2018-07-09 04:40:33'),(324,8,3,0.00,0.00,NULL,50,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:40:33','2018-07-09 04:40:33'),(325,7,3,0.00,52800.00,NULL,52,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:58:50','2018-07-09 04:58:50'),(326,7,3,0.00,0.00,NULL,52,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 04:58:50','2018-07-09 04:58:50'),(329,7,3,0.00,44880.00,NULL,53,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:01:46','2018-07-09 05:01:46'),(330,7,3,0.00,0.00,NULL,53,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:01:47','2018-07-09 05:01:47'),(331,7,3,0.00,990.00,NULL,55,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:02:48','2018-07-09 05:02:48'),(332,7,3,0.00,0.00,NULL,55,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:02:48','2018-07-09 05:02:48'),(333,8,3,0.00,2970.00,NULL,54,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:03:09','2018-07-09 05:03:09'),(334,8,3,0.00,0.00,NULL,54,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:03:09','2018-07-09 05:03:09'),(335,6,3,0.00,244200.00,NULL,56,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:11:23','2018-07-09 05:11:23'),(336,6,3,0.00,0.00,NULL,56,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:11:23','2018-07-09 05:11:23'),(337,6,3,0.00,258500.00,NULL,57,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:12:35','2018-07-09 05:12:35'),(338,6,3,0.00,0.00,NULL,57,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:12:35','2018-07-09 05:12:35'),(339,7,3,0.00,1700019.00,NULL,58,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:12:59','2018-07-09 05:12:59'),(340,7,3,0.00,0.00,NULL,58,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:13:00','2018-07-09 05:13:00'),(341,7,3,0.00,132.00,NULL,59,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:17:28','2018-07-09 05:17:28'),(342,7,3,0.00,0.00,NULL,59,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:17:28','2018-07-09 05:17:28'),(343,7,3,0.00,132.00,NULL,60,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:17:40','2018-07-09 05:17:40'),(344,7,3,0.00,0.00,NULL,60,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:17:40','2018-07-09 05:17:40'),(345,7,3,0.00,132.00,NULL,62,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:19:44','2018-07-09 05:19:44'),(346,7,3,0.00,0.00,NULL,62,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:19:44','2018-07-09 05:19:44'),(347,3,3,0.00,14850.00,NULL,64,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:27:56','2018-07-09 05:27:56'),(348,3,3,0.00,0.00,NULL,64,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:27:56','2018-07-09 05:27:56'),(349,3,3,0.00,1980.00,NULL,63,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:29:19','2018-07-09 05:29:19'),(350,3,3,0.00,0.00,NULL,63,NULL,NULL,NULL,NULL,'Invoice','2018-07-09','2018-07-09 05:29:19','2018-07-09 05:29:19'),(351,7,3,0.00,264.00,NULL,65,NULL,NULL,NULL,NULL,'Invoice','2018-07-10','2018-07-09 22:18:15','2018-07-09 22:18:15'),(352,7,3,0.00,0.00,NULL,65,NULL,NULL,NULL,NULL,'Invoice','2018-07-10','2018-07-09 22:18:15','2018-07-09 22:18:15'),(353,7,3,0.00,990.00,NULL,66,NULL,NULL,NULL,NULL,'Invoice','2018-07-10','2018-07-09 22:20:00','2018-07-09 22:20:00'),(354,7,3,0.00,0.00,NULL,66,NULL,NULL,NULL,NULL,'Invoice','2018-07-10','2018-07-09 22:20:00','2018-07-09 22:20:00'),(355,7,3,0.00,28600.00,NULL,67,NULL,NULL,NULL,NULL,'Invoice','2018-07-10','2018-07-09 22:32:09','2018-07-09 22:32:09'),(356,7,3,0.00,0.00,NULL,67,NULL,NULL,NULL,NULL,'Invoice','2018-07-10','2018-07-09 22:32:09','2018-07-09 22:32:09');

--
-- Table structure for table `ic_customers`
--

CREATE TABLE `ic_customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) NOT NULL,
  `billing_name` varchar(255) DEFAULT NULL,
  `billing_email` varchar(255) DEFAULT NULL,
  `billing_phone` varchar(255) DEFAULT NULL,
  `billing_address` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `country` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_customers`
--

INSERT INTO `ic_customers` VALUES (1,'Mr. Niloy','Cash','niloy enterprise','employee','01779379503','niloy@gmail.com','uttara, Dhaka','billing namwe','monno@gmail.com','01779379503','uttara, Dhaka','Active','2018-04-04 00:47:38','2018-04-04 00:47:38',NULL),(2,'Nipa Electronics','Credit','nipa enterprise','employee','01779379503','nipa@gmail.com','uttara, Dhaka','billing namwe','nipa@gmail.com','01779379503','uttara, Dhaka','Active','2018-04-04 00:49:04','2018-04-04 00:49:04',NULL),(3,'Mamun Hardware Store','Credit','nipa enterprise','Mamun Hardware Store','01779379503','mamun@gmail.com','Banani bazer','Mamun Hardware Store','mamun@gmail.com','01779379503','Banani bazer','0','2018-04-16 03:56:43','2018-04-15 21:56:43',NULL),(4,'Sumon khan','Cash','sumon enterprise','employee','01779379503','sumon@gmail.com','banani','Sumon khan','sumon@gmail.com','01779379503','banani','0','2018-04-19 03:57:41','2018-04-18 21:57:41',NULL),(5,'amir ali','Cash','amir enterprise','employee','01779379503','amir@gmail.com','Azampur','amir ali','amir@gmail.com','01779379503','Azampur','Active','2018-04-21 05:17:25','2018-04-21 05:17:25',NULL),(6,'Abul khair','Credit','Rk rider','employee','+1264344557','kahir@gmail.com','ti67u567','Abul khair','kahir@gmail.com','+1264344557','ti67u567','InActive','2018-04-24 05:06:36','2018-04-24 05:06:36',NULL),(7,'aman khan','Credit','Rk rider','employee','+2445678222','aman@gmail.com','wer32r3','aman khan','aman@gmail.com','+2445678222','wer32r3','Active','2018-04-24 22:19:24','2018-04-24 22:19:24',NULL),(8,'hasan ali','Credit','nipa enterprise','employee','+93','hasan@gmail.com','weqrqwe32','hasan ali','hasan@gmail.com','+376','weqrqwe32','Active','2018-04-25 04:49:47','2018-04-24 22:49:47','Afghanistan');

--
-- Table structure for table `ic_expense`
--

CREATE TABLE `ic_expense` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expense_type_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `description` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `amount` int(11) NOT NULL,
  `expense_date` timestamp NULL DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `status` varchar(255) CHARACTER SET latin1 NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `_idx` (`expense_type_id`),
  CONSTRAINT `` FOREIGN KEY (`expense_type_id`) REFERENCES `ic_expense_type` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=koi8r COLLATE=koi8r_bin;

--
-- Dumping data for table `ic_expense`
--

INSERT INTO `ic_expense` VALUES (1,1,0,NULL,1320,'2018-05-15 18:00:00',7,'Active','2018-05-28 09:19:13','2018-05-28 03:19:13'),(3,1,1,NULL,500,'2018-05-14 18:00:00',4,'Active','2018-05-28 09:07:40','2018-05-28 03:07:40'),(4,1,1,NULL,600,'2018-05-14 18:00:00',5,'Active','2018-05-28 03:10:46','2018-05-28 03:10:46'),(5,1,3,NULL,60,'2018-05-08 18:00:00',26,'Active','2018-05-28 09:20:09','2018-05-28 03:20:09'),(6,1,3,NULL,300,'2018-05-21 18:00:00',7,'Active','2018-05-28 03:15:41','2018-05-28 03:15:41'),(7,1,0,NULL,3000,'2018-05-15 18:00:00',7,'Active','2018-05-28 03:17:46','2018-05-28 03:17:46'),(8,1,0,NULL,3000,'2018-05-14 18:00:00',7,'Active','2018-05-28 03:18:47','2018-05-28 03:18:47'),(9,1,3,NULL,200,'2018-05-14 18:00:00',26,'Active','2018-05-28 03:19:05','2018-05-28 03:19:05'),(10,1,3,NULL,2000,'2018-04-30 18:00:00',26,'Active','2018-05-28 09:21:00','2018-05-28 03:21:00');

--
-- Table structure for table `ic_expense_type`
--

CREATE TABLE `ic_expense_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `name_2` (`name`),
  KEY `name_3` (`name`),
  KEY `name_4` (`name`),
  KEY `name_5` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_expense_type`
--

INSERT INTO `ic_expense_type` VALUES (1,'convence ok','2018-03-15 00:21:10','2018-03-15 00:19:26');

--
-- Table structure for table `ic_invoice`
--

CREATE TABLE `ic_invoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_no` varchar(255) DEFAULT NULL,
  `customer_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `sales_date` timestamp NULL DEFAULT NULL,
  `sub_total` decimal(10,2) DEFAULT NULL,
  `discount_taka` decimal(10,2) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `truck_fare` decimal(10,2) DEFAULT NULL,
  `vat` decimal(10,2) DEFAULT NULL,
  `total_amount` decimal(10,2) DEFAULT NULL,
  `paid_amount` decimal(10,2) DEFAULT NULL,
  `due_amount` decimal(10,2) DEFAULT NULL,
  `transaction_type` varchar(255) DEFAULT NULL,
  `chack_no` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `invoice_type` varchar(45) DEFAULT 'active',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_invoice`
--

INSERT INTO `ic_invoice` VALUES (1,'ei000001',4,3,'2018-05-27 18:00:00',888900.00,0.00,0.00,0.00,10.00,977790.00,976800.00,990.00,'Cash',NULL,NULL,'2018-05-28','active',1,1,'2018-05-28 02:24:12','2018-07-08 23:33:51'),(3,'ei000003',7,3,'2018-05-28 18:00:00',900.00,0.00,0.00,0.00,10.00,990.00,0.00,990.00,'Cash',NULL,NULL,'2018-05-29','active',8,NULL,'2018-05-28 21:45:10','2018-07-07 22:15:56'),(4,'ei000004',10,3,'2018-06-02 18:00:00',3000.00,0.00,0.00,0.00,10.00,3300.00,2376.00,924.00,'Cash',NULL,NULL,'2018-06-03','active',1,1,'2018-06-03 03:39:09','2018-07-06 22:42:22'),(6,'ei000006',2,3,'2018-07-06 18:00:00',26100.00,0.00,0.00,0.00,10.00,28710.00,0.00,28710.00,'Cash',NULL,NULL,'2018-07-07','active',1,1,'2018-07-06 22:55:33','2018-07-06 23:14:08'),(7,'ei000007',11,3,'2018-07-06 18:00:00',7200.00,0.00,0.00,0.00,10.00,7920.00,0.00,7920.00,'Cash',NULL,NULL,'2018-07-07','return',1,NULL,'2018-07-06 23:18:23','2018-07-06 23:18:23'),(9,'ei000009',1,1,'2018-07-06 18:00:00',360.00,0.00,0.00,0.00,10.00,396.00,0.00,396.00,'Cash',NULL,NULL,'2018-07-07','return',1,NULL,'2018-07-07 01:31:57','2018-07-07 01:31:57'),(10,'ei000010',1,4,'2018-07-06 18:00:00',360.00,0.00,0.00,0.00,10.00,396.00,0.00,396.00,'Cash',NULL,NULL,'2018-07-07','active',1,1,'2018-07-07 01:34:26','2018-07-07 01:35:44'),(11,'ei000011',6,3,'2018-07-07 18:00:00',600.00,0.00,0.00,0.00,10.00,660.00,0.00,660.00,'Cash',NULL,NULL,'2018-07-08','active',1,NULL,'2018-07-07 21:58:37','2018-07-07 21:58:37'),(12,'ei000012',6,3,'2018-07-07 18:00:00',600.00,0.00,0.00,0.00,10.00,660.00,0.00,660.00,'Cash',NULL,NULL,'2018-07-08','active',1,NULL,'2018-07-07 21:58:51','2018-07-07 22:14:49'),(13,'ei000013',8,3,'2018-07-07 18:00:00',705000.00,0.00,0.00,0.00,10.00,775500.00,0.00,775500.00,'Cash',NULL,NULL,'2018-07-08','return',1,NULL,'2018-07-07 23:05:19','2018-07-07 23:05:19'),(15,'ei000015',8,3,'2018-07-07 18:00:00',666000.00,0.00,0.00,0.00,10.00,732600.00,0.00,732600.00,'Cash',NULL,NULL,'2018-07-08','active',1,NULL,'2018-07-07 23:15:15','2018-07-07 23:18:39'),(16,'ei000016',5,3,'2018-07-07 18:00:00',2700.00,0.00,0.00,0.00,10.00,2970.00,0.00,2970.00,'Cash',NULL,NULL,'2018-07-08','active',1,NULL,'2018-07-08 00:14:11','2018-07-08 00:14:11'),(17,'ei000017',8,3,'2018-07-07 18:00:00',26000.00,0.00,0.00,0.00,10.00,28600.00,0.00,28600.00,'Cash',NULL,NULL,'2018-07-08','active',1,NULL,'2018-07-08 00:32:04','2018-07-08 00:32:04'),(18,'ei000018',8,3,'2018-07-07 18:00:00',39000.00,0.00,0.00,0.00,10.00,42900.00,0.00,42900.00,'Cash',NULL,NULL,'2018-07-08','return',1,NULL,'2018-07-08 00:33:35','2018-07-08 00:33:35'),(20,'ei000020',8,3,'2018-07-07 18:00:00',54700.00,0.00,0.00,0.00,10.00,60170.00,0.00,60170.00,'Cash',NULL,NULL,'2018-07-08','active',1,1,'2018-07-08 00:39:03','2018-07-08 23:00:23'),(21,'ei000021',8,3,'2018-07-07 18:00:00',120.00,0.00,0.00,0.00,10.00,132.00,0.00,132.00,'Cash',NULL,NULL,'2018-07-08','active',1,NULL,'2018-07-08 00:39:38','2018-07-09 03:59:11'),(22,'ei000022',7,3,'2018-07-07 18:00:00',666240.00,0.00,0.00,0.00,10.00,732864.00,0.00,732864.00,'Cash',NULL,NULL,'2018-07-08','active',1,1,'2018-07-08 00:40:32','2018-07-08 23:45:05'),(25,'ei000025',0,3,'2018-07-07 18:00:00',67700.00,0.00,0.00,0.00,10.00,74470.00,0.00,74470.00,'Cash',NULL,NULL,'2018-07-08','active',1,1,'2018-07-08 00:49:18','2018-07-08 06:16:40'),(26,'ei000026',7,3,'2018-07-08 18:00:00',480.00,0.00,0.00,0.00,10.00,528.00,0.00,528.00,'Cash',NULL,NULL,'2018-07-09','active',1,1,'2018-07-08 23:44:58','2018-07-08 23:46:41'),(27,'ei000027',7,3,'2018-07-08 18:00:00',1200.00,0.00,0.00,0.00,10.00,1320.00,0.00,1320.00,'Cash',NULL,NULL,'2018-07-09','active',1,1,'2018-07-08 23:46:31','2018-07-08 23:50:45'),(28,'ei000028',4,3,'2018-07-08 18:00:00',1560.00,0.00,0.00,0.00,10.00,1716.00,0.00,1716.00,'Cash',NULL,NULL,'2018-07-09','active',1,1,'2018-07-08 23:50:40','2018-07-08 23:55:50'),(29,'ei000029',6,3,'2018-07-08 18:00:00',1680.00,0.00,0.00,0.00,10.00,1848.00,0.00,1848.00,'Cash',NULL,NULL,'2018-07-09','active',1,1,'2018-07-08 23:54:07','2018-07-09 01:41:30'),(30,'ei000030',0,3,'2018-07-08 18:00:00',12180.00,0.00,0.00,0.00,10.00,13398.00,0.00,13398.00,'Cash',NULL,NULL,'2018-07-09','active',1,1,'2018-07-08 23:58:26','2018-07-09 01:38:20'),(31,'ei000031',6,3,'2018-07-08 18:00:00',720.00,0.00,0.00,0.00,10.00,792.00,0.00,792.00,'Cash',NULL,NULL,'2018-07-09','active',1,1,'2018-07-09 01:41:08','2018-07-09 02:57:57'),(32,'ei000032',8,3,'2018-07-08 18:00:00',480.00,0.00,0.00,0.00,10.00,528.00,0.00,528.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 01:43:44','2018-07-09 01:43:44'),(33,'ei000033',6,3,'2018-07-08 18:00:00',840.00,0.00,0.00,0.00,10.00,924.00,0.00,924.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 01:51:22','2018-07-09 01:51:22'),(34,'ei000034',8,3,'2018-07-08 18:00:00',2640.00,0.00,0.00,0.00,10.00,2904.00,0.00,2904.00,'Cash',NULL,NULL,'2018-07-09','active',1,1,'2018-07-09 02:57:47','2018-07-09 03:15:58'),(35,'ei000035',7,3,'2018-07-08 18:00:00',960.00,0.00,0.00,0.00,10.00,1056.00,0.00,1056.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 03:00:19','2018-07-09 03:00:19'),(36,'ei000036',8,3,'2018-07-08 18:00:00',1800.00,0.00,0.00,0.00,10.00,1980.00,0.00,1980.00,'Cash',NULL,NULL,'2018-07-09','active',1,1,'2018-07-09 03:15:49','2018-07-09 03:22:57'),(37,'ei000037',6,3,'2018-07-08 18:00:00',960.00,0.00,0.00,0.00,10.00,1056.00,0.00,1056.00,'Cash',NULL,NULL,'2018-07-09','active',1,1,'2018-07-09 03:22:50','2018-07-09 03:31:24'),(38,'ei000038',8,3,'2018-07-08 18:00:00',1200.00,0.00,0.00,0.00,10.00,1320.00,0.00,1320.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 03:34:50','2018-07-09 03:34:50'),(39,'ei000039',6,3,'2018-07-08 18:00:00',52000.00,0.00,0.00,0.00,10.00,57200.00,0.00,57200.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 03:45:37','2018-07-09 03:45:37'),(40,'ei000040',7,3,'2018-07-08 18:00:00',169000.00,0.00,0.00,0.00,10.00,185900.00,0.00,185900.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 03:49:45','2018-07-09 03:49:45'),(41,'ei000041',7,3,'2018-07-08 18:00:00',720.00,0.00,0.00,0.00,10.00,792.00,0.00,792.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 04:00:09','2018-07-09 04:06:11'),(42,'ei000042',7,3,'2018-07-08 18:00:00',888000.00,0.00,0.00,0.00,10.00,976800.00,0.00,976800.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 04:00:35','2018-07-09 04:00:35'),(43,'ei000043',6,3,'2018-07-08 18:00:00',360.00,0.00,0.00,0.00,10.00,396.00,0.00,396.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 04:01:30','2018-07-09 04:25:32'),(44,'ei000044',7,3,'2018-07-08 18:00:00',888000.00,0.00,0.00,0.00,10.00,976800.00,0.00,976800.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 04:04:34','2018-07-09 04:04:34'),(45,'ei000045',7,3,'2018-07-08 18:00:00',3600.00,0.00,0.00,0.00,10.00,3960.00,0.00,3960.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 04:05:07','2018-07-09 04:05:07'),(46,'ei000046',7,3,'2018-07-08 18:00:00',130000.00,0.00,0.00,0.00,10.00,143000.00,0.00,143000.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 04:05:24','2018-07-09 04:13:21'),(47,'ei000047',7,3,'2018-07-08 18:00:00',26000.00,0.00,0.00,0.00,10.00,28600.00,0.00,28600.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 04:06:05','2018-07-09 04:06:05'),(48,'ei000048',8,3,'2018-07-08 18:00:00',888000.00,0.00,0.00,0.00,10.00,976800.00,0.00,976800.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 04:17:46','2018-07-09 04:25:09'),(49,'ei000049',6,3,'2018-07-08 18:00:00',888000.00,0.00,0.00,0.00,10.00,976800.00,0.00,976800.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 04:18:06','2018-07-09 04:18:06'),(50,'ei000050',8,3,'2018-07-08 18:00:00',3600.00,0.00,0.00,0.00,10.00,3960.00,0.00,3960.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 04:27:56','2018-07-09 04:40:33'),(51,'ei000051',7,3,'2018-07-08 18:00:00',900.00,0.00,0.00,0.00,10.00,990.00,0.00,990.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 04:29:47','2018-07-09 04:29:47'),(52,'ei000052',7,3,'2018-07-08 18:00:00',48000.00,0.00,0.00,0.00,10.00,52800.00,0.00,52800.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 04:58:49','2018-07-09 04:58:50'),(53,'ei000053',7,3,'2018-07-08 18:00:00',40800.00,0.00,0.00,0.00,10.00,44880.00,0.00,44880.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 05:00:36','2018-07-09 05:01:46'),(54,'ei000054',8,3,'2018-07-08 18:00:00',2700.00,0.00,0.00,0.00,10.00,2970.00,0.00,2970.00,'Cash',NULL,NULL,'2018-07-09','active',1,1,'2018-07-09 05:01:07','2018-07-09 05:03:09'),(55,'ei000055',7,3,'2018-07-08 18:00:00',900.00,0.00,0.00,0.00,10.00,990.00,0.00,990.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 05:02:48','2018-07-09 05:02:48'),(56,'ei000056',6,3,'2018-07-08 18:00:00',222000.00,0.00,0.00,0.00,10.00,244200.00,0.00,244200.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 05:11:23','2018-07-09 05:11:23'),(57,'ei000057',6,3,'2018-07-08 18:00:00',235000.00,0.00,0.00,0.00,10.00,258500.00,0.00,258500.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 05:12:34','2018-07-09 05:12:34'),(58,'ei000058',7,3,'2018-07-08 18:00:00',927000.00,0.00,0.00,0.00,10.00,1700019.00,0.00,1700019.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 05:12:59','2018-07-09 05:12:59'),(59,'ei000059',7,3,'2018-07-08 18:00:00',120.00,0.00,0.00,0.00,10.00,132.00,0.00,132.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 05:17:28','2018-07-09 05:17:28'),(60,'ei000060',7,3,'2018-07-08 18:00:00',120.00,0.00,0.00,0.00,10.00,132.00,0.00,132.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 05:17:40','2018-07-09 05:17:40'),(61,'ei000061',7,3,'2018-07-08 18:00:00',120.00,0.00,0.00,0.00,10.00,132.00,0.00,132.00,'Cash',NULL,NULL,'2018-07-09','draft',1,NULL,'2018-07-09 05:18:17','2018-07-09 05:18:17'),(62,'ei000062',7,3,'2018-07-08 18:00:00',120.00,0.00,0.00,0.00,10.00,132.00,0.00,132.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 05:19:44','2018-07-09 05:19:44'),(63,'ei000063',3,3,'2018-07-08 18:00:00',1800.00,0.00,0.00,0.00,10.00,1980.00,0.00,1980.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 05:25:56','2018-07-09 05:29:19'),(64,'ei000064',3,3,'2018-07-08 18:00:00',13500.00,0.00,0.00,0.00,10.00,14850.00,0.00,14850.00,'Cash',NULL,NULL,'2018-07-09','active',1,NULL,'2018-07-09 05:27:55','2018-07-09 05:27:55'),(65,'ei000065',7,3,'2018-07-09 18:00:00',240.00,0.00,0.00,0.00,10.00,264.00,0.00,264.00,'Cash',NULL,NULL,'2018-07-10','active',1,NULL,'2018-07-09 22:18:15','2018-07-09 22:18:15'),(66,'ei000066',7,3,'2018-07-09 18:00:00',900.00,0.00,0.00,0.00,10.00,990.00,0.00,990.00,'Cash',NULL,NULL,'2018-07-10','active',1,NULL,'2018-07-09 22:20:00','2018-07-09 22:20:00'),(67,'ei000067',7,3,'2018-07-09 18:00:00',26000.00,0.00,0.00,0.00,10.00,28600.00,0.00,28600.00,'Cash',NULL,NULL,'2018-07-10','active',1,NULL,'2018-07-09 22:32:09','2018-07-09 22:32:09');

--
-- Table structure for table `ic_invoice_detail`
--

CREATE TABLE `ic_invoice_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `quantity` decimal(10,2) DEFAULT NULL,
  `unit_price` decimal(10,2) DEFAULT NULL,
  `unit_price_actual` decimal(10,2) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `invoice_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `product_id_idx` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=304 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_invoice_detail`
--

INSERT INTO `ic_invoice_detail` VALUES (19,2,2.00,900.00,900.00,1800.00,4),(20,4,7.00,120.00,120.00,840.00,4),(21,4,3.00,120.00,120.00,360.00,4),(71,2,29.00,900.00,900.00,26100.00,6),(72,2,8.00,900.00,900.00,7200.00,7),(74,4,3.00,120.00,120.00,360.00,9),(76,4,3.00,120.00,120.00,360.00,10),(77,4,5.00,120.00,120.00,600.00,11),(79,4,5.00,120.00,0.00,600.00,12),(80,2,1.00,900.00,900.00,900.00,3),(81,3,3.00,222000.00,222000.00,666000.00,13),(82,1,3.00,13000.00,13000.00,39000.00,13),(86,3,3.00,222000.00,222000.00,666000.00,15),(87,2,3.00,900.00,900.00,2700.00,16),(88,1,2.00,13000.00,13000.00,26000.00,17),(89,1,3.00,13000.00,13000.00,39000.00,18),(154,2,3.00,900.00,900.00,2700.00,25),(155,1,5.00,13000.00,13000.00,65000.00,25),(186,2,3.00,900.00,900.00,2700.00,20),(187,1,4.00,13000.00,13000.00,52000.00,20),(199,3,4.00,222000.00,222000.00,888000.00,1),(200,2,1.00,900.00,900.00,900.00,1),(204,3,3.00,222000.00,222000.00,666000.00,22),(205,4,2.00,120.00,120.00,240.00,22),(207,4,4.00,120.00,120.00,480.00,26),(209,4,10.00,120.00,120.00,1200.00,27),(211,4,13.00,120.00,120.00,1560.00,28),(241,2,11.00,900.00,900.00,9900.00,30),(242,4,19.00,120.00,120.00,2280.00,30),(245,4,14.00,120.00,120.00,1680.00,29),(246,4,4.00,120.00,120.00,480.00,32),(247,4,7.00,120.00,120.00,840.00,33),(249,4,6.00,120.00,120.00,720.00,31),(250,4,8.00,120.00,120.00,960.00,35),(254,4,22.00,120.00,120.00,2640.00,34),(256,4,15.00,120.00,120.00,1800.00,36),(259,4,8.00,120.00,120.00,960.00,37),(260,4,10.00,120.00,120.00,1200.00,38),(261,1,4.00,13000.00,13000.00,52000.00,39),(262,1,13.00,13000.00,13000.00,169000.00,40),(263,4,1.00,120.00,120.00,120.00,21),(265,3,4.00,222000.00,222000.00,888000.00,42),(267,3,4.00,222000.00,222000.00,888000.00,44),(268,2,4.00,900.00,900.00,3600.00,45),(270,1,2.00,13000.00,13000.00,26000.00,47),(271,4,6.00,120.00,120.00,720.00,41),(272,1,10.00,13000.00,13000.00,130000.00,46),(274,3,4.00,222000.00,222000.00,888000.00,49),(275,3,4.00,222000.00,222000.00,888000.00,48),(276,4,3.00,120.00,120.00,360.00,43),(278,2,1.00,900.00,900.00,900.00,51),(279,2,4.00,900.00,900.00,3600.00,50),(280,1,3.00,13000.00,13000.00,39000.00,52),(281,2,10.00,900.00,900.00,9000.00,52),(285,2,2.00,900.00,900.00,1800.00,53),(286,1,3.00,13000.00,13000.00,39000.00,53),(287,2,1.00,900.00,900.00,900.00,55),(288,2,3.00,900.00,900.00,2700.00,54),(289,3,1.00,222000.00,222000.00,222000.00,56),(290,3,1.00,222000.00,0.00,222000.00,57),(291,1,1.00,13000.00,13000.00,13000.00,57),(292,3,4.00,222000.00,222000.00,888000.00,58),(293,1,3.00,13000.00,13000.00,39000.00,58),(294,4,1.00,120.00,120.00,120.00,59),(295,4,1.00,120.00,0.00,120.00,60),(296,4,1.00,120.00,0.00,120.00,61),(297,4,1.00,120.00,120.00,120.00,62),(299,2,15.00,900.00,900.00,13500.00,64),(300,4,15.00,120.00,120.00,1800.00,63),(301,4,2.00,120.00,120.00,240.00,65),(302,2,1.00,900.00,900.00,900.00,66),(303,1,2.00,13000.00,13000.00,26000.00,67);

--
-- Table structure for table `ic_product_category`
--

CREATE TABLE `ic_product_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_product_category`
--

INSERT INTO `ic_product_category` VALUES (1,'FURNITURE FITTINGS','2018-04-11 11:47:48','2018-04-11 05:47:48'),(3,'TOOLS AND HARDWARE','2018-04-11 11:48:05','2018-04-11 05:48:05'),(4,'PAINT AND BRUSH','2018-04-11 11:48:23','2018-04-11 05:48:23');

--
-- Table structure for table `ic_product_unit`
--

CREATE TABLE `ic_product_unit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_product_unit`
--

INSERT INTO `ic_product_unit` VALUES (1,'Kg',NULL,'2018-04-09 00:44:17'),(2,'Gm',NULL,NULL),(3,'Ltr',NULL,NULL),(4,'Pcs',NULL,NULL),(5,'Hali',NULL,NULL),(6,'Dozen',NULL,NULL);

--
-- Table structure for table `ic_products`
--

CREATE TABLE `ic_products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `sales_price` decimal(10,0) NOT NULL,
  `purchase_price` decimal(10,0) DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `unit_id` int(11) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `unit_id_idx` (`unit_id`),
  CONSTRAINT `unit_id` FOREIGN KEY (`unit_id`) REFERENCES `ic_product_unit` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_products`
--

INSERT INTO `ic_products` VALUES (1,'DOOR HINGE(SS FINISHED)',13000,12000,1,'Content Here',2,'InActive','2018-04-11 11:49:00','2018-04-11 05:49:00'),(2,'DOOR LOCK-587(SS COLOR)',900,400,1,'content here',4,'Active','2018-04-11 11:49:26','2018-04-11 05:49:26'),(3,'ROLLER FOAM (RRA901)',222000,800,4,'Test',4,'Active','2018-04-11 11:49:53','2018-04-11 05:49:53'),(4,'ROLLER FOAM (RRY901)',120,16,4,'asdsf',4,'Active','2018-04-11 11:50:09','2018-04-11 05:50:09'),(5,'test',600,500,4,NULL,6,'Active','2018-05-28 00:25:25','2018-05-28 00:25:25');

--
-- Table structure for table `ic_purchase`
--

CREATE TABLE `ic_purchase` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_no` varchar(255) DEFAULT NULL,
  `supplier_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `purchase_date` timestamp NULL DEFAULT NULL,
  `sub_total` decimal(10,2) DEFAULT NULL,
  `discount_taka` decimal(10,2) DEFAULT NULL,
  `discount_percentage` decimal(10,2) DEFAULT NULL,
  `truck_fare` decimal(10,2) DEFAULT NULL,
  `vat` decimal(10,2) DEFAULT NULL,
  `grand_total` decimal(10,2) DEFAULT NULL,
  `paid_amount` decimal(10,2) DEFAULT NULL,
  `due_amount` decimal(10,2) DEFAULT NULL,
  `transaction_type` varchar(255) DEFAULT NULL,
  `chack_no` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_purchase`
--

INSERT INTO `ic_purchase` VALUES (1,'ep000001',2,3,'2018-05-27 18:00:00',3600.00,0.00,0.00,0.00,10.00,3960.00,3960.00,0.00,'Cash',NULL,NULL,'2018-05-28',1,1,'2018-05-28 02:08:05','2018-06-03 02:38:53'),(2,'ep000002',5,3,'2018-06-02 18:00:00',400.00,0.00,0.00,0.00,10.00,440.00,440.00,440.00,'Cash',NULL,NULL,'2018-06-03',1,NULL,'2018-06-03 02:27:18','2018-06-03 02:27:18'),(3,'ep000003',5,3,'2018-06-02 18:00:00',133312.00,0.00,0.00,0.00,10.00,146643.20,146643.20,0.00,'Cash',NULL,NULL,'2018-06-03',1,1,'2018-06-03 03:38:00','2018-06-03 03:38:30'),(4,'ep000004',3,1,'2018-07-06 18:00:00',48.00,0.00,0.00,0.00,10.00,52.80,0.00,52.80,'Cash',NULL,NULL,'2018-07-07',1,NULL,'2018-07-06 22:21:10','2018-07-06 22:21:10'),(5,'ep000005',2,3,'2018-07-06 18:00:00',1280.00,0.00,0.00,0.00,10.00,1408.00,0.00,1408.00,'Cash',NULL,NULL,'2018-07-07',1,NULL,'2018-07-07 01:33:17','2018-07-07 01:33:17'),(6,'ep000006',3,4,'2018-07-06 18:00:00',864.00,0.00,0.00,0.00,10.00,950.40,0.00,950.40,'Cash',NULL,NULL,'2018-07-07',1,NULL,'2018-07-07 01:34:01','2018-07-07 01:34:01'),(7,'ep000007',5,3,'2018-07-07 18:00:00',89600.00,0.00,0.00,0.00,10.00,98560.00,0.00,98560.00,'Cash',NULL,NULL,'2018-07-08',1,NULL,'2018-07-07 22:48:48','2018-07-07 22:48:48'),(8,'ep000008',3,3,'2018-07-08 18:00:00',96160.00,0.00,0.00,0.00,10.00,105776.00,0.00,105776.00,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-08 23:49:02','2018-07-08 23:49:02'),(9,'ep000009',3,3,'2018-07-08 18:00:00',208.00,0.00,0.00,0.00,10.00,228.80,0.00,228.80,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-08 23:53:09','2018-07-08 23:53:09'),(10,'ep000010',3,3,'2018-07-08 18:00:00',48.00,0.00,0.00,0.00,10.00,52.80,0.00,52.80,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-08 23:56:24','2018-07-08 23:56:25'),(11,'ep000011',4,3,'2018-07-08 18:00:00',80.00,0.00,0.00,0.00,10.00,88.00,0.00,88.00,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-08 23:57:18','2018-07-08 23:57:18'),(12,'ep000012',3,3,'2018-07-08 18:00:00',80.00,0.00,0.00,0.00,10.00,88.00,0.00,88.00,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 00:03:30','2018-07-09 00:03:30'),(13,'ep000013',5,3,'2018-07-08 18:00:00',224.00,0.00,0.00,0.00,10.00,246.40,0.00,246.40,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 00:10:49','2018-07-09 00:10:50'),(14,'ep000014',5,3,'2018-07-08 18:00:00',51296.00,0.00,0.00,0.00,10.00,56425.60,0.00,56425.60,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 00:59:50','2018-07-09 00:59:50'),(15,'ep000015',6,3,'2018-07-08 18:00:00',160.00,0.00,0.00,0.00,10.00,176.00,0.00,176.00,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 01:42:32','2018-07-09 01:42:32'),(16,'ep000016',5,3,'2018-07-08 18:00:00',112.00,0.00,0.00,0.00,10.00,123.20,0.00,123.20,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 01:46:36','2018-07-09 01:46:36'),(17,'ep000017',4,3,'2018-07-08 18:00:00',192.00,0.00,0.00,0.00,10.00,211.20,0.00,211.20,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 02:10:11','2018-07-09 02:10:11'),(18,'ep000018',5,3,'2018-07-08 18:00:00',128.00,0.00,0.00,0.00,10.00,140.80,0.00,140.80,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 02:59:50','2018-07-09 02:59:50'),(19,'ep000019',6,3,'2018-07-08 18:00:00',160.00,0.00,0.00,0.00,10.00,176.00,0.00,176.00,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 03:15:16','2018-07-09 03:15:17'),(20,'ep000020',4,3,'2018-07-08 18:00:00',1600.00,0.00,0.00,0.00,10.00,1760.00,0.00,1760.00,'Cash',NULL,NULL,'2018-07-09',1,1,'2018-07-09 03:21:42','2018-07-09 03:24:00'),(21,'ep000021',5,3,'2018-07-08 18:00:00',124896.00,0.00,0.00,0.00,10.00,137385.60,0.00,137385.60,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 04:04:12','2018-07-09 04:04:12'),(22,'ep000022',6,3,'2018-07-08 18:00:00',65280.00,0.00,0.00,0.00,10.00,71808.00,0.00,71808.00,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 04:17:13','2018-07-09 04:17:13'),(23,'ep000023',6,3,'2018-07-08 18:00:00',12000.00,0.00,0.00,0.00,10.00,13200.00,0.00,13200.00,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 04:43:52','2018-07-09 04:43:52'),(24,'ep000024',5,3,'2018-07-08 18:00:00',86400.00,0.00,0.00,0.00,10.00,95040.00,0.00,95040.00,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 04:59:48','2018-07-09 04:59:48'),(25,'ep000025',1,3,'2018-07-08 18:00:00',7600.00,0.00,0.00,0.00,10.00,8360.00,0.00,8360.00,'Cash',NULL,NULL,'2018-07-09',1,NULL,'2018-07-09 05:23:57','2018-07-09 05:23:57'),(26,'ep000026',5,3,'2018-07-09 18:00:00',20456614.00,0.00,0.00,0.00,10.00,22901675.60,0.00,22901675.60,'Cash',NULL,NULL,'2018-07-10',1,NULL,'2018-07-09 22:17:41','2018-07-09 22:17:41');

--
-- Table structure for table `ic_purchase_detail`
--

CREATE TABLE `ic_purchase_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `quantity` decimal(10,2) NOT NULL,
  `unit_price` decimal(10,2) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `test_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `test_id_idx` (`test_id`),
  KEY `product_id_idx` (`product_id`),
  KEY `purchase_id_po_idx` (`purchase_id`),
  CONSTRAINT `test_id` FOREIGN KEY (`test_id`) REFERENCES `ic_products` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_purchase_detail`
--

INSERT INTO `ic_purchase_detail` VALUES (7,2,1.00,400.00,400.00,2,NULL),(8,3,4.00,800.00,3200.00,1,NULL),(9,2,1.00,400.00,400.00,1,NULL),(13,4,7.00,16.00,112.00,3,NULL),(14,3,1.00,800.00,800.00,3,NULL),(15,2,1.00,400.00,400.00,3,NULL),(16,1,11.00,12000.00,132000.00,3,NULL),(17,4,3.00,16.00,48.00,4,NULL),(18,4,5.00,16.00,80.00,5,NULL),(19,2,3.00,400.00,1200.00,5,NULL),(20,4,4.00,16.00,64.00,6,NULL),(21,3,1.00,800.00,800.00,6,NULL),(22,3,7.00,800.00,5600.00,7,NULL),(23,1,7.00,12000.00,84000.00,7,NULL),(24,4,10.00,16.00,160.00,8,NULL),(25,1,8.00,12000.00,96000.00,8,NULL),(26,4,13.00,16.00,208.00,9,NULL),(27,4,3.00,16.00,48.00,10,NULL),(28,4,5.00,16.00,80.00,11,NULL),(29,4,5.00,16.00,80.00,12,NULL),(30,4,14.00,16.00,224.00,13,NULL),(31,4,6.00,16.00,96.00,14,NULL),(32,3,4.00,800.00,3200.00,14,NULL),(33,1,4.00,12000.00,48000.00,14,NULL),(34,4,10.00,16.00,160.00,15,NULL),(35,4,7.00,16.00,112.00,16,NULL),(36,4,12.00,16.00,192.00,17,NULL),(37,4,8.00,16.00,128.00,18,NULL),(38,4,10.00,16.00,160.00,19,NULL),(41,4,100.00,16.00,1600.00,20,NULL),(42,4,6.00,16.00,96.00,21,NULL),(43,2,4.00,400.00,1600.00,21,NULL),(44,1,10.00,12000.00,120000.00,21,NULL),(45,3,4.00,800.00,3200.00,21,NULL),(46,4,5.00,16.00,80.00,22,NULL),(47,3,4.00,800.00,3200.00,22,NULL),(48,2,5.00,400.00,2000.00,22,NULL),(49,1,5.00,12000.00,60000.00,22,NULL),(50,3,10.00,800.00,8000.00,23,NULL),(51,2,10.00,400.00,4000.00,23,NULL),(52,2,6.00,400.00,2400.00,24,NULL),(53,1,7.00,12000.00,84000.00,24,NULL),(54,4,100.00,16.00,1600.00,25,NULL),(55,2,15.00,400.00,6000.00,25,NULL),(56,4,1995.00,16.00,31920.00,26,NULL),(57,2,1456.00,400.00,582400.00,26,NULL),(58,1,1678.00,12000.00,20000136.00,26,NULL);

--
-- Table structure for table `ic_role`
--

CREATE TABLE `ic_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_role`
--

INSERT INTO `ic_role` VALUES (1,'Super Admin'),(2,'Admin'),(3,'Employee');

--
-- Table structure for table `ic_stocks`
--

CREATE TABLE `ic_stocks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `stock` decimal(10,2) DEFAULT NULL,
  `warehouse_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_id_idx` (`product_id`),
  KEY `ware_id_idx` (`warehouse_id`),
  CONSTRAINT `product_id` FOREIGN KEY (`product_id`) REFERENCES `ic_products` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `wareh_id` FOREIGN KEY (`warehouse_id`) REFERENCES `ic_warehouse` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_stocks`
--

INSERT INTO `ic_stocks` VALUES (1,3,0.00,3),(2,2,1455.00,3),(3,4,2143.00,3),(4,1,1676.00,3),(5,4,3.00,1),(6,4,1.00,4),(7,3,1.00,4);

--
-- Table structure for table `ic_supplier_due`
--

CREATE TABLE `ic_supplier_due` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_id` int(11) DEFAULT NULL,
  `warehouse_id` int(11) DEFAULT NULL,
  `total_due` decimal(10,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_supplier_due`
--

INSERT INTO `ic_supplier_due` VALUES (1,2,3,1408.00),(2,5,3,23290037.20),(3,3,1,52.80),(4,3,4,950.40),(5,3,3,106145.60),(6,4,3,2059.20),(7,6,3,85360.00),(8,1,3,8360.00);

--
-- Table structure for table `ic_supplier_payments`
--

CREATE TABLE `ic_supplier_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_id` int(11) DEFAULT NULL,
  `warehouse_id` int(11) DEFAULT NULL,
  `paid_amount` decimal(10,2) DEFAULT '0.00',
  `purchase` decimal(10,2) DEFAULT '0.00',
  `purchase_id` int(11) DEFAULT NULL,
  `transaction_type` varchar(45) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `chack_no` varchar(255) DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `paid_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_supplier_payments`
--

INSERT INTO `ic_supplier_payments` VALUES (7,5,3,0.00,440.00,2,NULL,NULL,NULL,NULL,'Purchase','2018-06-03','2018-06-03 02:27:19','2018-06-03 02:27:19'),(8,5,3,440.00,0.00,2,NULL,NULL,NULL,NULL,'Purchase','2018-06-03','2018-06-03 02:27:19','2018-06-03 02:27:19'),(9,2,3,0.00,3960.00,1,NULL,NULL,NULL,NULL,'Purchase','2018-05-28','2018-06-03 02:38:54','2018-06-03 02:38:54'),(10,2,3,3960.00,0.00,1,NULL,NULL,NULL,NULL,'Purchase','2018-05-28','2018-06-03 02:38:54','2018-06-03 02:38:54'),(13,5,3,0.00,146643.20,3,NULL,NULL,NULL,NULL,'Purchase','2018-06-03','2018-06-03 03:38:31','2018-06-03 03:38:31'),(14,5,3,146643.20,0.00,3,NULL,NULL,NULL,NULL,'Purchase','2018-06-03','2018-06-03 03:38:31','2018-06-03 03:38:31'),(15,3,1,0.00,52.80,4,NULL,NULL,NULL,NULL,'Purchase','2018-07-07','2018-07-06 22:21:10','2018-07-06 22:21:10'),(16,3,1,0.00,0.00,4,NULL,NULL,NULL,NULL,'Purchase','2018-07-07','2018-07-06 22:21:10','2018-07-06 22:21:10'),(17,2,3,0.00,1408.00,5,NULL,NULL,NULL,NULL,'Purchase','2018-07-07','2018-07-07 01:33:17','2018-07-07 01:33:17'),(18,2,3,0.00,0.00,5,NULL,NULL,NULL,NULL,'Purchase','2018-07-07','2018-07-07 01:33:17','2018-07-07 01:33:17'),(19,3,4,0.00,950.40,6,NULL,NULL,NULL,NULL,'Purchase','2018-07-07','2018-07-07 01:34:01','2018-07-07 01:34:01'),(20,3,4,0.00,0.00,6,NULL,NULL,NULL,NULL,'Purchase','2018-07-07','2018-07-07 01:34:01','2018-07-07 01:34:01'),(21,5,3,0.00,98560.00,7,NULL,NULL,NULL,NULL,'Purchase','2018-07-08','2018-07-07 22:48:48','2018-07-07 22:48:48'),(22,5,3,0.00,0.00,7,NULL,NULL,NULL,NULL,'Purchase','2018-07-08','2018-07-07 22:48:48','2018-07-07 22:48:48'),(23,3,3,0.00,105776.00,8,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-08 23:49:02','2018-07-08 23:49:02'),(24,3,3,0.00,0.00,8,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-08 23:49:02','2018-07-08 23:49:02'),(25,3,3,0.00,228.80,9,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-08 23:53:09','2018-07-08 23:53:09'),(26,3,3,0.00,0.00,9,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-08 23:53:09','2018-07-08 23:53:09'),(27,3,3,0.00,52.80,10,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-08 23:56:25','2018-07-08 23:56:25'),(28,3,3,0.00,0.00,10,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-08 23:56:25','2018-07-08 23:56:25'),(29,4,3,0.00,88.00,11,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-08 23:57:18','2018-07-08 23:57:18'),(30,4,3,0.00,0.00,11,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-08 23:57:18','2018-07-08 23:57:18'),(31,3,3,0.00,88.00,12,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 00:03:30','2018-07-09 00:03:30'),(32,3,3,0.00,0.00,12,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 00:03:30','2018-07-09 00:03:30'),(33,5,3,0.00,246.40,13,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 00:10:50','2018-07-09 00:10:50'),(34,5,3,0.00,0.00,13,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 00:10:50','2018-07-09 00:10:50'),(35,5,3,0.00,56425.60,14,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 00:59:50','2018-07-09 00:59:50'),(36,5,3,0.00,0.00,14,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 00:59:50','2018-07-09 00:59:50'),(37,6,3,0.00,176.00,15,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 01:42:33','2018-07-09 01:42:33'),(38,6,3,0.00,0.00,15,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 01:42:33','2018-07-09 01:42:33'),(39,5,3,0.00,123.20,16,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 01:46:36','2018-07-09 01:46:36'),(40,5,3,0.00,0.00,16,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 01:46:36','2018-07-09 01:46:36'),(41,4,3,0.00,211.20,17,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 02:10:12','2018-07-09 02:10:12'),(42,4,3,0.00,0.00,17,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 02:10:12','2018-07-09 02:10:12'),(43,5,3,0.00,140.80,18,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 02:59:50','2018-07-09 02:59:50'),(44,5,3,0.00,0.00,18,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 02:59:50','2018-07-09 02:59:50'),(45,6,3,0.00,176.00,19,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 03:15:17','2018-07-09 03:15:17'),(46,6,3,0.00,0.00,19,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 03:15:17','2018-07-09 03:15:17'),(51,4,3,0.00,1760.00,20,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 03:24:00','2018-07-09 03:24:00'),(52,4,3,0.00,0.00,20,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 03:24:00','2018-07-09 03:24:00'),(53,5,3,0.00,137385.60,21,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 04:04:12','2018-07-09 04:04:12'),(54,5,3,0.00,0.00,21,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 04:04:12','2018-07-09 04:04:12'),(55,6,3,0.00,71808.00,22,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 04:17:13','2018-07-09 04:17:13'),(56,6,3,0.00,0.00,22,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 04:17:13','2018-07-09 04:17:13'),(57,6,3,0.00,13200.00,23,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 04:43:52','2018-07-09 04:43:52'),(58,6,3,0.00,0.00,23,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 04:43:52','2018-07-09 04:43:52'),(59,5,3,0.00,95040.00,24,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 04:59:48','2018-07-09 04:59:48'),(60,5,3,0.00,0.00,24,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 04:59:48','2018-07-09 04:59:48'),(61,1,3,0.00,8360.00,25,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 05:23:57','2018-07-09 05:23:57'),(62,1,3,0.00,0.00,25,NULL,NULL,NULL,NULL,'Purchase','2018-07-09','2018-07-09 05:23:57','2018-07-09 05:23:57'),(63,5,3,0.00,22901675.60,26,NULL,NULL,NULL,NULL,'Purchase','2018-07-10','2018-07-09 22:17:41','2018-07-09 22:17:41'),(64,5,3,0.00,0.00,26,NULL,NULL,NULL,NULL,'Purchase','2018-07-10','2018-07-09 22:17:41','2018-07-09 22:17:41');

--
-- Table structure for table `ic_suppliers`
--

CREATE TABLE `ic_suppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `company` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address1` varchar(255) NOT NULL DEFAULT 'null',
  `address2` varchar(45) DEFAULT 'null',
  `city` varchar(45) NOT NULL DEFAULT 'null',
  `state` varchar(45) DEFAULT 'null',
  `zip` varchar(45) NOT NULL DEFAULT 'null',
  `country` varchar(45) DEFAULT 'null',
  `status` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_suppliers`
--

INSERT INTO `ic_suppliers` VALUES (1,'MD.Alamin (Roller Handle)','Bangla Roller handle','employee','01747044734','ar@gmail.com','rtertr','null','null','null','null','null','Active','2018-04-11 11:53:59','2018-04-11 05:53:59'),(2,'MR.Jelin','ZHIYAN BRUSH FACTORY','Paint foam factory','13606103564','Famousbrush@yahoo.com','china','null','null','null','null','null','0','2018-04-11 05:52:19','2018-04-11 05:52:19'),(3,'Candy','Bolts Door lock Factory','Bolts Door lock Factory','13456015525','candy@gmail.com','China','null','null','null','null','null','0','2018-04-11 05:55:52','2018-04-11 05:55:52'),(4,'lamom jhej','nipa enterprise','employee','+8801787894555','lamom@gmail.com','hmmm','y65y','uttara','uttara','1206',NULL,'InActive','2018-04-24 11:52:41','2018-04-24 05:52:40'),(5,'rabiul islam','nipa enterprise','employee','+213','rabiul0420@gmail.com','zcafeg','weteryrty','uttara','uttara','1206','Algeria','Active','2018-04-25 05:01:29','2018-04-24 23:01:29'),(6,'Super Admin','ewrewr','retrt','+880','muhaiminurabir@gmail.com','qe23432',NULL,'retre','ertt','44343','Bangladesh','0','2018-06-03 00:43:51','2018-06-03 00:43:51');

--
-- Table structure for table `ic_warehouse`
--

CREATE TABLE `ic_warehouse` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ic_warehouse`
--

INSERT INTO `ic_warehouse` VALUES (1,'Enam badda','badda, dhaka','2018-03-12 23:17:33','2018-03-12 03:17:58'),(3,'Enam Uttara','Uttara,Dhaka','2018-03-12 23:17:57','2018-03-12 04:06:20'),(4,'Enam Khilkhet','Khilkhet, Dhaka','2018-05-16 23:34:39','2018-05-16 23:34:39');


