-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `off_posnew`
--

-- --------------------------------------------------------

--
-- Table structure for table `tbl_access`
--

CREATE TABLE `tbl_access` (
  `id` int(11) NOT NULL,
  `module_name` varchar(100) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
  `function_name` varchar(100) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
  `label_name` varchar(100) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `main_module_id` int(11) DEFAULT NULL,
  `del_status` varchar(11) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;



-- --------------------------------------------------------

--
-- Table structure for table `tbl_attendance`
--

CREATE TABLE `tbl_attendance` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `in_time` time DEFAULT NULL,
  `out_time` time DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_closed` int(11) NOT NULL DEFAULT 2,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_brands`
--

CREATE TABLE `tbl_brands` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(10) UNSIGNED DEFAULT NULL,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_brands`
--

INSERT INTO `tbl_brands` (`id`, `name`, `description`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Samsung', '', '2023-11-29 18:12:08', 1, 1, 'Live'),
(2, 'Walton', '', '2023-11-29 18:12:13', 1, 1, 'Live'),
(3, 'Realmi', '', '2023-11-29 18:12:32', 1, 1, 'Live'),
(4, 'iPhone', '', '2023-11-29 18:12:37', 1, 1, 'Live'),
(5, 'Easy', '', '2023-11-29 18:13:02', 1, 1, 'Live'),
(6, 'Polo', '', '2023-11-29 18:13:25', 1, 1, 'Live'),
(7, 'Hike', '', '2023-11-29 18:13:30', 1, 1, 'Live'),
(8, 'Twelve', '', '2023-11-29 18:13:48', 1, 1, 'Live'),
(9, 'Redmi', '', '2023-11-29 19:51:56', 1, 1, 'Live'),
(10, 'One Pharma', '', '2023-11-29 20:06:57', 1, 1, 'Live'),
(11, 'Square', '', '2023-11-29 20:09:25', 1, 1, 'Live'),
(12, 'Panasonic', '', '2024-01-11 11:46:57', 1, 1, 'Live'),
(13, 'Sony', '', '2024-02-08 00:32:14', 1, 1, 'Live'),
(14, 'Metador', '', '2024-02-19 17:57:03', 1, 1, 'Live'),
(15, 'Hatil', '', '2024-02-22 21:14:48', 1, 1, 'Live'),
(16, 'Pepsi', '', '2024-02-22 21:26:09', 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_companies`
--

CREATE TABLE `tbl_companies` (
  `id` int(11) NOT NULL,
  `business_name` varchar(50) DEFAULT NULL,
  `short_name` varchar(11) NOT NULL DEFAULT 'OP',
  `email` varchar(50) DEFAULT NULL,
  `date_format` varchar(30) DEFAULT NULL,
  `zone_name` varchar(30) DEFAULT NULL,
  `currency` varchar(30) DEFAULT NULL,
  `currency_position` varchar(20) DEFAULT NULL,
  `precision` varchar(11) DEFAULT NULL,
  `default_customer` int(11) DEFAULT 1,
  `default_cursor_position` varchar(25) DEFAULT NULL,
  `default_payment` int(11) DEFAULT NULL,
  `website` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `invoice_footer` varchar(300) DEFAULT NULL,
  `inv_qr_code_status` varchar(10) DEFAULT NULL,
  `letter_head_gap` varchar(11) DEFAULT NULL,
  `letter_footer_gap` varchar(55) DEFAULT NULL,
  `print_format` varchar(300) DEFAULT 'Thermal',
  `invoice_prefix` varchar(11) DEFAULT '',
  `print_format_invoice` varchar(500) DEFAULT '80mm',
  `sms_setting_check` varchar(11) DEFAULT NULL,
  `invoice_logo` varchar(50) DEFAULT NULL,
  `show_hide` varchar(15) DEFAULT '',
  `item_modal_status` varchar(11) NOT NULL DEFAULT 'No',
  `whole_price_show_hide` varchar(11) NOT NULL DEFAULT 'No',
  `i_sale` varchar(11) NOT NULL DEFAULT 'Yes',
  `collect_tax` varchar(50) DEFAULT NULL,
  `tax_title` varchar(100) DEFAULT NULL,
  `tax_registration_no` varchar(100) DEFAULT NULL,
  `tax_is_gst` varchar(50) DEFAULT NULL,
  `tax_setting` text DEFAULT NULL,
  `tax_string` varchar(250) DEFAULT NULL,
  `sms_enable_status` int(11) DEFAULT NULL,
  `sms_service_provider` int(11) NOT NULL DEFAULT 0,
  `sms_details` text DEFAULT NULL,
  `smtp_type` varchar(20) DEFAULT NULL,
  `smtp_enable_status` int(11) DEFAULT NULL,
  `smtp_details` text DEFAULT NULL,
  `whatsapp_share_number` varchar(20) DEFAULT NULL,
  `white_label` text DEFAULT NULL,
  `white_label_status` int(11) DEFAULT 1,
  `tax_registration_number` varchar(250) DEFAULT NULL,
  `invoice_print` varchar(30) DEFAULT 'web_browser',
  `receipt_printer_invoice` int(11) DEFAULT NULL,
  `print_server_url_invoice` varchar(100) DEFAULT NULL,
  `open_cash_drawer_when_printing_invoice` varchar(255) DEFAULT NULL,
  `tax_type` int(11) NOT NULL DEFAULT 1,
  `decimals_separator` varchar(11) DEFAULT '.',
  `thousands_separator` varchar(11) DEFAULT '',
  `when_clicking_on_item_in_pos` varchar(20) DEFAULT '2',
  `purchase_price_show_hide` varchar(11) NOT NULL DEFAULT 'No',
  `term_conditions` text NOT NULL,
  `allow_less_sale` varchar(10) NOT NULL DEFAULT '',
  `is_rounding_enable` int(11) DEFAULT NULL,
  `direct_cart` varchar(11) NOT NULL DEFAULT 'No',
  `register_content` text DEFAULT NULL,
  `pos_total_payable_type` int(11) NOT NULL DEFAULT 1 COMMENT '0=None, 1=Top,2=Floor',
  `installment_days` int(11) DEFAULT NULL,
  `added_date` varchar(30) DEFAULT NULL,
  `user_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_companies`
--

INSERT INTO `tbl_companies` (`id`, `business_name`, `short_name`, `email`, `date_format`, `zone_name`, `currency`, `currency_position`, `precision`, `default_customer`, `default_cursor_position`, `default_payment`, `website`, `phone`, `invoice_footer`, `inv_qr_code_status`, `letter_head_gap`, `letter_footer_gap`, `print_format`, `invoice_prefix`, `print_format_invoice`, `sms_setting_check`, `invoice_logo`, `show_hide`, `item_modal_status`, `whole_price_show_hide`, `i_sale`, `collect_tax`, `tax_title`, `tax_registration_no`, `tax_is_gst`, `tax_setting`, `tax_string`, `sms_enable_status`, `sms_service_provider`, `sms_details`, `smtp_type`, `smtp_enable_status`, `smtp_details`, `whatsapp_share_number`, `white_label`, `white_label_status`, `tax_registration_number`, `invoice_print`, `receipt_printer_invoice`, `print_server_url_invoice`, `open_cash_drawer_when_printing_invoice`, `tax_type`, `decimals_separator`, `thousands_separator`, `when_clicking_on_item_in_pos`, `purchase_price_show_hide`, `term_conditions`, `allow_less_sale`, `is_rounding_enable`, `direct_cart`, `register_content`, `pos_total_payable_type`, `installment_days`, `added_date`, `user_id`, `del_status`) VALUES
(1, 'Dyan Super Shop', 'OP', 'Dyan@gmail.com', 'm/d/Y', 'Asia/Dhaka', '$', 'After Amount', '1', 1, 'Barcode Box', 1, '421 E. Commerce San Antonio, TX 782054', '(210) 224-13135', '<p>Thank you for visiting us!</p>\r\n', 'Enable', '200px', '100px', 'A4 Print', 'IN#', 'A4 Print', 'Yes', '1686116304.png', '', '', '', 'Yes', 'Yes', 'Yes', '10069', 'Yes', '[{\"id\":\"1\",\"tax\":\"CGST\",\"tax_rate\":\"15\"},{\"id\":\"1\",\"tax\":\"SGST\",\"tax_rate\":\"4\"},{\"id\":\"1\",\"tax\":\"IGST\",\"tax_rate\":\"22\"},{\"id\":\"1\",\"tax\":\"VAT\",\"tax_rate\":\"1\"}]', 'CGST:SGST:IGST:VAT:', 2, 2, '{\"field_1_0\":\"AC912936630bb5e4a34cf6247ff9d28f07\",\"field_1_1\":\"7183bbecf7b47009dd592f1e80f2cb1a\",\"field_1_2\":\"+15108923589\",\"field_2_0\":\"Doorsoft\",\"field_2_1\":\"e_1sybyh\",\"field_2_2\":\"Door Soft\",\"field_2_3\":\"+880\"}', 'Sendinblue', 2, '{\"host_name\":\"smtp.gmail.com\",\"port_address\":\"465\",\"encryption\":\"tls\",\"user_name\":\"mkraju.doorsoft@gmail.com\",\"password\":\"mhmrpahjwmyyveuc\",\"from_name\":\"Doorsoft\",\"from_email\":\"no-reply@offpos.com\",\"api_key\":\"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\"}', '01812391633', '{\"site_name\":\"Off POS | Retail POS and Stock Software\",\"site_footer\":\"Off POS | Retail POS and Stock Software\",\"site_title\":\"Door Soft\",\"site_link\":\"https:\\/\\/doorsoft.co\\/\",\"site_logo\":\"0c8c230edaadeaea344f1423d2c94a7f.png\",\"site_favicon\":\"4c9f6fb49fc6b6babf7c1799ae1fc0fb.ico\"}', 1, NULL, 'web_browser', 0, 'http://192.168.0.104', '', 1, ',', ',', '2', '', '<p><span style=\"color:#e74c3c\"><span style=\"font-size:16px\"><strong>Return and Refund Policy</strong></span></span><br />\r\n<span style=\"font-size:11px\"><span style=\"color:#000000\"><em>1. Return Eligibility:</em></span><br />\r\n<span style=\"color:#000000\">Within Specified Timeframe: Customers can return the software within 30 deys from the date of purchase.<br />\r\nCondition of Return: The software must be in its original packaging and in a resalable condition for a return to be accepted.</span></span><br />\r\n<span style=\"font-size:11px\"><span style=\"color:#000000\"><em>2. Refund Procedure:</em></span><br />\r\n<span style=\"color:#000000\">Refund Method: Refunds will be processed using the original payment method (credit card, cash, etc.).<br />\r\nProcessing Time: Allow [number of days] for the refund to be processed after the returned software is received.</span></span><br />\r\n<span style=\"font-size:11px\"><span style=\"color:#000000\"><em>3. Exclusions:</em><br />\r\nOpened or Used Software: Software that has been opened or used may not be eligible for a full refund. A restocking fee may apply.<br />\r\nNon-refundable Items: Certain items, such as software licenses or subscriptions, might be non-refundable.</span></span></p>\r\n', 'Yes', 0, 'No', '{\"register_op_balance\":\"Opening Balance\",\"register_expense\":\"Expense\",\"register_purchase\":\"Purchase\",\"register_purchase_return\":\"Purchase Return\",\"register_supplier_payment\":\"Supplier Payment\",\"register_sale\":\"Sale\",\"register_sale_return\":\"Sale Return\",\"register_installment_down_payment\":\"Installment Down Payment\",\"register_installment_collection\":\"Installment Collection\",\"register_customer_due_receive\":\"Customer Due Receive\",\"register_servicing\":\"Servicing\"}', 0, 3, '2023-03-14 17:38:01', 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_customers`
--

CREATE TABLE `tbl_customers` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `nid` varchar(50) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `address` varchar(120) DEFAULT NULL,
  `opening_balance` float DEFAULT 0,
  `opening_balance_type` varchar(10) NOT NULL DEFAULT 'Debit',
  `credit_limit` float DEFAULT NULL,
  `gst_number` varchar(50) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `date_of_birth` varchar(30) DEFAULT NULL,
  `customer_type` varchar(15) NOT NULL DEFAULT 'default',
  `permanent_address` varchar(120) DEFAULT NULL,
  `work_address` varchar(120) DEFAULT NULL,
  `customer_nid` varchar(50) DEFAULT NULL,
  `g_name` varchar(50) DEFAULT NULL,
  `g_mobile` varchar(15) DEFAULT NULL,
  `g_nid` varchar(50) DEFAULT NULL,
  `g_photo` varchar(50) DEFAULT NULL,
  `g_pre_address` varchar(120) DEFAULT NULL,
  `g_permanent_address` varchar(120) DEFAULT NULL,
  `g_work_address` varchar(120) DEFAULT NULL,
  `photo` varchar(50) DEFAULT NULL,
  `date_of_anniversary` varchar(30) DEFAULT NULL,
  `discount` varchar(11) DEFAULT '0',
  `price_type` int(11) NOT NULL DEFAULT 1 COMMENT '1=Retail;2=Wholesale',
  `same_or_diff_state` int(11) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT 0,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `tbl_customers`
--

INSERT INTO `tbl_customers` (`id`, `name`, `nid`, `phone`, `email`, `address`, `opening_balance`, `opening_balance_type`, `credit_limit`, `gst_number`, `group_id`, `date_of_birth`, `customer_type`, `permanent_address`, `work_address`, `customer_nid`, `g_name`, `g_mobile`, `g_nid`, `g_photo`, `g_pre_address`, `g_permanent_address`, `g_work_address`, `photo`, `date_of_anniversary`, `discount`, `price_type`, `same_or_diff_state`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Walk-in Customer', NULL, NULL, NULL, NULL, 0, 'Debit', 0, NULL, 0, NULL, 'default', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 1, NULL, NULL, 1, 1, 'Live'),
(34, 'Robiul Islam', '', '+0956854948', 'robiulislam@gmail.com', 'ABUPUR ISRAFIL HOUSE', 10, 'Debit', 100, '555', 0, '', 'default', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '3', 1, 1, '2023-11-29 21:10:50', 1, 1, 'Live'),
(35, 'Juniya Hossain', '', '01401748845', 'juniya.azhar.tahiya69@gmail.com', 'Nikunja 2 Dhaka 1207', 900, 'Credit', 1000, '55', 0, '', 'default', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '5', 1, 1, '2023-11-29 21:12:10', 1, 1, 'Live'),
(36, 'Azhar Raihan', '', '01629171720', 'azharraihan6969@gmail.com', 'Nikunja 2 Dhaka 1207', 100, 'Credit', 1000, '69', 1, NULL, 'default', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1%', 2, 2, '2023-12-26 16:07:00', 1, 1, 'Live'),
(37, 'Roni', '', '01401748845', 'robi@gmail.com', '', 0, 'Debit', 0, '69', 0, NULL, 'default', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', 1, 1, '2023-12-26 16:02023-12-26 16:07:00', 1, 1, 'Live'),
(38, 'Abdullah', '', '01629171721', 'abdullah@gmail.com', 'Nikunja 2 Dhaka 1207', 60, 'Debit', 100, '80', 1, NULL, 'default', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 1, 1, '2023-12-26 16:07:00', 1, 1, 'Live'),
(59, 'Rafsan', NULL, '01629171724', 'rafsan@gmail.com', 'Nikunja 2, Dhaka 1207', 0, 'Debit', NULL, NULL, NULL, NULL, 'installment', 'Nikunja 2, Dhaka 1207', 'Kazipara, Mirpur 10, Dhaka Bangladesh', '27beb6c668a2e364e8723ce72347b2f5.jpg', 'Mr.Jalal', '01629171725', 'd79e08eb9a5488925c3cce03fff1bab9.jpg', '627d878c51825999b4a3acf7c6fb2ed1.jpg', 'Nikunja 2, Dhaka 1207', 'Nikunja 2, Dhaka 1207', 'Nikunja 2, Dhaka 1207', 'a6ed3ec843325e556c5291170933ecdf.png', NULL, '0', 1, NULL, '2024-01-11 17:55:29', 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_customer_due_receives`
--

CREATE TABLE `tbl_customer_due_receives` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(50) DEFAULT NULL,
  `date` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `payment_method_id` int(11) NOT NULL DEFAULT 1,
  `payment_method_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `account_type` varchar(55) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `added_date` varchar(55) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT 0,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_customer_groups`
--

CREATE TABLE `tbl_customer_groups` (
  `id` int(11) NOT NULL,
  `group_name` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_damages`
--

CREATE TABLE `tbl_damages` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(50) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `total_loss` float DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_damage_details`
--

CREATE TABLE `tbl_damage_details` (
  `id` int(11) NOT NULL,
  `date` varchar(55) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `damage_quantity` float DEFAULT NULL,
  `last_purchase_price` float DEFAULT NULL,
  `loss_amount` float DEFAULT NULL,
  `total_amount` float(10,3) DEFAULT NULL,
  `damage_id` int(11) DEFAULT NULL,
  `item_type` varchar(55) DEFAULT NULL,
  `expiry_imei_serial` varchar(255) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_denominations`
--

CREATE TABLE `tbl_denominations` (
  `id` int(11) NOT NULL,
  `amount` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_denominations`
--

INSERT INTO `tbl_denominations` (`id`, `amount`, `description`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 10, '', '2023-12-03 13:32:38', 1, 1, 'Deleted'),
(2, 20, '', '2023-12-03 13:32:43', 1, 1, 'Live'),
(3, 50, '', '2023-12-03 13:32:49', 1, 1, 'Live'),
(4, 100, '', '2023-12-03 13:32:55', 1, 1, 'Live'),
(5, 200, '', '2023-12-03 13:33:02', 1, 1, 'Live'),
(6, 500, '', '2023-12-03 13:33:11', 1, 1, 'Live'),
(7, 1000, '', '2023-12-03 13:33:17', 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_deposits`
--

CREATE TABLE `tbl_deposits` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `type` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `payment_method_id` int(11) NOT NULL DEFAULT 1,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_expenses`
--

CREATE TABLE `tbl_expenses` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `payment_method_id` int(11) NOT NULL DEFAULT 1,
  `note` varchar(255) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_expense_items`
--

CREATE TABLE `tbl_expense_items` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_expense_items`
--

INSERT INTO `tbl_expense_items` (`id`, `name`, `description`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Electricity bill', '', '2024-01-03 19:18:29', 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_holds`
--

CREATE TABLE `tbl_holds` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `hold_no` varchar(55) NOT NULL DEFAULT '000000',
  `total_items` int(11) DEFAULT NULL,
  `sub_total` float DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `due_amount` double DEFAULT NULL,
  `due_payment_date` varchar(30) DEFAULT NULL,
  `disc` varchar(11) DEFAULT NULL,
  `disc_actual` float DEFAULT NULL,
  `vat` float DEFAULT NULL,
  `total_payable` float DEFAULT NULL,
  `payment_method_id` int(11) DEFAULT NULL,
  `table_id` int(11) DEFAULT NULL,
  `total_item_discount_amount` float NOT NULL,
  `sub_total_with_discount` float NOT NULL,
  `sub_total_discount_amount` float NOT NULL,
  `total_discount_amount` float NOT NULL,
  `delivery_charge` float NOT NULL,
  `sub_total_discount_value` varchar(11) NOT NULL,
  `sub_total_discount_type` varchar(11) NOT NULL,
  `token_no` varchar(50) DEFAULT NULL,
  `sale_date` varchar(30) DEFAULT NULL,
  `date_time` varchar(30) DEFAULT NULL,
  `sale_time` varchar(15) NOT NULL,
  `waiter_id` int(11) DEFAULT 0,
  `order_status` tinyint(1) DEFAULT NULL COMMENT '1=new order, 2=cancelled order, 3=invoiced order',
  `sale_vat_objects` text DEFAULT NULL,
  `order_type` tinyint(1) DEFAULT NULL COMMENT '1=dine in, 2 = take away, 3 = delivery',
  `added_date` varchar(30) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_holds_details`
--

CREATE TABLE `tbl_holds_details` (
  `id` int(11) NOT NULL,
  `food_menu_id` int(11) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `menu_price_without_discount` float NOT NULL,
  `menu_price_with_discount` float NOT NULL,
  `menu_unit_price` float NOT NULL,
  `menu_vat_percentage` float NOT NULL,
  `menu_taxes` text DEFAULT NULL,
  `menu_discount_value` varchar(11) DEFAULT NULL,
  `discount_type` varchar(11) NOT NULL,
  `menu_note` varchar(255) DEFAULT NULL,
  `discount_amount` double DEFAULT NULL,
  `holds_id` int(11) DEFAULT NULL,
  `is_promo_item` varchar(15) DEFAULT NULL,
  `promo_parent_id` int(11) DEFAULT NULL,
  `promo_item_object` varchar(300) DEFAULT NULL,
  `item_type` varchar(55) DEFAULT NULL,
  `expiry_imei_serial` varchar(255) DEFAULT NULL,
  `added_date` varchar(30) DEFAULT NULL,
  `item_seller_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_incomes`
--

CREATE TABLE `tbl_incomes` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `payment_method_id` int(11) DEFAULT 1,
  `payment_method_type` varchar(255) DEFAULT NULL,
  `account_type` varchar(50) DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_income_items`
--

CREATE TABLE `tbl_income_items` (
  `id` int(11) NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_income_items`
--

INSERT INTO `tbl_income_items` (`id`, `name`, `description`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Monthly Bonus', '', '2024-01-03 19:25:53', 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_installments`
--

CREATE TABLE `tbl_installments` (
  `id` int(11) NOT NULL,
  `date` varchar(30) DEFAULT NULL,
  `reference_no` varchar(30) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `quantity` int(10) NOT NULL DEFAULT 1,
  `item_type` varchar(55) DEFAULT NULL,
  `expiry_imei_serial` varchar(255) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `discount` varchar(11) DEFAULT NULL,
  `shipping_other` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  `down_payment` float(11,5) DEFAULT 0.00000,
  `remaining` float DEFAULT NULL,
  `number_of_installment` int(11) DEFAULT NULL,
  `percentage_of_interest` varchar(55) DEFAULT '0',
  `installment_type` int(11) DEFAULT NULL,
  `payment_method_id` int(11) NOT NULL DEFAULT 1,
  `payment_method_type` varchar(255) DEFAULT NULL,
  `account_type` varchar(55) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_installments`
--

INSERT INTO `tbl_installments` (`id`, `date`, `reference_no`, `customer_id`, `item_id`, `quantity`, `item_type`, `expiry_imei_serial`, `price`, `discount`, `shipping_other`, `total`, `down_payment`, `remaining`, `number_of_installment`, `percentage_of_interest`, `installment_type`, `payment_method_id`, `payment_method_type`, `account_type`, `added_date`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, '2024-02-25', '000001', 59, 12, 1, 'IMEI_Product', 'PC-00002', 15, '0,0', 2, 15300, 2.00000, 15298, 2, '2', 2, 2, NULL, 'Cash', '2024-02-25 12:31:24', 1, 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_installment_items`
--

CREATE TABLE `tbl_installment_items` (
  `id` int(11) NOT NULL,
  `installment_id` int(11) DEFAULT NULL,
  `amount_of_payment` float DEFAULT NULL,
  `paid_amount` float DEFAULT NULL,
  `payment_date` varchar(30) DEFAULT NULL,
  `paid_date` varchar(30) DEFAULT NULL,
  `paid_status` varchar(25) NOT NULL DEFAULT 'Unpaid',
  `payment_method_id` int(11) DEFAULT NULL,
  `payment_method_type` varchar(255) DEFAULT NULL,
  `account_type` varchar(55) DEFAULT NULL,
  `added_date` varchar(30) DEFAULT NULL,
  `installmentNotification` varchar(11) NOT NULL DEFAULT '1',
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_installment_items`
--

INSERT INTO `tbl_installment_items` (`id`, `installment_id`, `amount_of_payment`, `paid_amount`, `payment_date`, `paid_date`, `paid_status`, `payment_method_id`, `payment_method_type`, `account_type`, `added_date`, `installmentNotification`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(5, 1, 7649, NULL, '2024-02-27', NULL, 'Unpaid', NULL, NULL, NULL, '2024-02-25 13:25:42', '1', 1, 1, 1, 'Live'),
(6, 1, 7649, NULL, '2024-02-29', NULL, 'Unpaid', NULL, NULL, NULL, '2024-02-25 13:25:42', '1', 1, 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_items`
--

CREATE TABLE `tbl_items` (
  `id` int(11) NOT NULL,
  `code` varchar(50) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `generic_name` varchar(55) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `brand_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `alert_quantity` float DEFAULT NULL,
  `unit_type` int(11) DEFAULT NULL,
  `purchase_unit_id` int(11) DEFAULT NULL,
  `sale_unit_id` int(11) DEFAULT NULL,
  `conversion_rate` float DEFAULT 1,
  `purchase_price` float DEFAULT NULL,
  `last_three_purchase_avg` varchar(55) DEFAULT '0',
  `last_purchase_price` varchar(55) DEFAULT NULL,
  `sale_price` float DEFAULT NULL,
  `whole_sale_price` float DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `warranty` int(11) DEFAULT 0,
  `warranty_date` varchar(55) DEFAULT NULL,
  `guarantee` int(11) DEFAULT 0,
  `guarantee_date` varchar(55) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `tax_information` text DEFAULT NULL,
  `tax_string` text DEFAULT NULL,
  `variation_details` text DEFAULT NULL,
  `p_type` varchar(50) NOT NULL,
  `parent_id` int(11) DEFAULT 0,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `tbl_items`
--

INSERT INTO `tbl_items` (`id`, `code`, `name`, `generic_name`, `type`, `category_id`, `brand_id`, `supplier_id`, `alert_quantity`, `unit_type`, `purchase_unit_id`, `sale_unit_id`, `conversion_rate`, `purchase_price`, `last_three_purchase_avg`, `last_purchase_price`, `sale_price`, `whole_sale_price`, `description`, `warranty`, `warranty_date`, `guarantee`, `guarantee_date`, `photo`, `tax_information`, `tax_string`, `variation_details`, `p_type`, `parent_id`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, '001', 'কলম', NULL, 'General_Product', NULL, 14, 1, 1, 2, 2, 1, 12, 180, '180', '180', 20, 18, '', 0, 'month', 0, 'month', '', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, 'General_Product', 0, '2024-02-22 21:14:56', 1, 1, 'Deleted'),
(2, '002', 'Pepsi', NULL, 'General_Product', NULL, 16, 0, 200, 2, 5, 1, 24, 336, '336', '336', 25, 20, '', 0, 'month', 0, 'month', '', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, 'General_Product', 0, '2024-02-22 21:26:44', 1, 1, 'Live'),
(3, '003', 'Money Bag', NULL, 'General_Product', 1, 0, 1, 5, 1, 1, 1, 1, 150, '150', '150', 300, 280, '', 6, 'month', 0, 'month', '', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, 'General_Product', 0, '2024-02-22 21:32:00', 1, 1, 'Live'),
(4, '004', 'T-Shirt', NULL, 'Variation_Product', 11, 0, 1, 0, 1, 1, 1, 1, 0, '', '', 0, 0, '', 0, 'month', 0, 'month', '', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', '[\"{\\\"variation_name\\\":\\\"Color\\\",\\\"attribute_id\\\":\\\"1\\\",\\\"child_row_attribute\\\":\\\"[\\\\\\\"Blue\\\\\\\",\\\\\\\"Green\\\\\\\"]\\\"}\"]', 'Variation_Product', 0, '2024-02-23 19:32:12', 1, 1, 'Live'),
(5, '004-01', 'Blue', NULL, '0', 11, 0, 1, 2, 1, 1, 1, 1, 180, '180', '180', 250, 200, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 4, '2024-02-23 19:32:12', 1, 1, 'Live'),
(6, '004-02', 'Green', NULL, '0', 11, 0, 1, 1, 1, 1, 1, 1, 200, '200', '200', 300, 250, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 4, '2024-02-23 19:32:12', 1, 1, 'Live'),
(7, '007', 'Punjabi', NULL, 'Variation_Product', 11, 0, 1, 0, 2, 2, 1, 12, 0, '0', '0', 0, 0, '', 0, 'month', 0, 'month', '', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', '[\"{\\\"variation_name\\\":\\\"Size\\\",\\\"attribute_id\\\":\\\"2\\\",\\\"child_row_attribute\\\":\\\"\\\\\\\"\\\\\\\"\\\"}\",\"{\\\"variation_name\\\":\\\"Color\\\",\\\"attribute_id\\\":\\\"1\\\",\\\"child_row_attribute\\\":\\\"\\\\\\\"\\\\\\\"\\\"}\"]', 'Variation_Product', 0, '2024-02-23 19:46:59', 1, 1, 'Live'),
(8, '007-01', 'M - White', NULL, '0', 11, 0, 1, 2, 2, 2, 1, 12, 9600, '9600', '9600', 1000, 900, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 7, '2024-02-23 19:46:59', 1, 1, 'Live'),
(9, '007-02', 'M - Black', NULL, '0', 11, 0, 1, 5, 2, 2, 1, 12, 10800, '10800', '10800', 1100, 1000, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 7, '2024-02-23 19:46:59', 1, 1, 'Live'),
(10, '007-03', 'L - White', NULL, '0', 11, 0, 1, 8, 2, 2, 1, 12, 12000, '12000', '12000', 1200, 1100, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 7, '2024-02-23 19:46:59', 1, 1, 'Live'),
(11, '007-04', 'L - Black', NULL, '0', 11, 0, 1, 5, 2, 2, 1, 12, 13200, '13200', '13200', 1300, 1200, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 7, '2024-02-23 19:46:59', 1, 1, 'Live'),
(12, '012', 'Poco M2', NULL, 'IMEI_Product', 1, 0, 1, 5, 1, 1, 1, 1, 12000, '12000', '12000', 15000, 14000, '', 0, 'month', 0, 'month', '', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, 'IMEI_Product', 0, '2024-02-23 20:41:51', 1, 1, 'Live'),
(13, '013', 'Blander Matchine', NULL, 'Serial_Product', 1, 0, 0, 1, 1, 1, 1, 1, 3000, '3000', '3000', 5000, 4000, '', 1, 'month', 1, 'month', '', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, 'Serial_Product', 0, '2024-02-23 20:47:59', 1, 1, 'Live'),
(14, '014', 'Syringe', 'Paracetamol', 'Expiry_Product', 1, 0, 0, 5, 1, 1, 1, 1, 10, '10', '10', 15, 14, '', 0, 'month', 0, 'month', '', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, 'Expiry_Product', 0, '2024-02-23 21:06:15', 1, 1, 'Live'),
(15, '015', 'Napa', 'Paracetamol', 'Expiry_Product', 2, 0, 0, 5, 2, 2, 1, 10, 300, '300', '300', 50, 45, '', 0, 'month', 0, 'month', '', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, 'Expiry_Product', 0, '2024-02-23 21:16:15', 1, 1, 'Live'),
(16, '016', 'Moja', NULL, 'Variation_Product', 11, 0, 0, 0, 1, 1, 1, 1, 30, '30', '30', 50, 40, '', 0, 'month', 0, 'month', '', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', '[\"{\\\"variation_name\\\":\\\"Size\\\",\\\"attribute_id\\\":\\\"2\\\",\\\"child_row_attribute\\\":\\\"[\\\\\\\"S\\\\\\\",\\\\\\\"M\\\\\\\"]\\\"}\"]', 'Variation_Product', 0, '2024-02-23 21:57:06', 1, 1, 'Live'),
(17, '016-01', 'S', NULL, '0', 11, 0, 0, 5, 1, 1, 1, 1, 30, '30', '30', 50, 40, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 16, '2024-02-23 21:57:06', 1, 1, 'Live'),
(18, '016-02', 'M', NULL, '0', 11, 0, 0, 5, 1, 1, 1, 1, 30, '30', '30', 50, 40, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 16, '2024-02-23 21:57:06', 1, 1, 'Live'),
(19, '019', 'Variation Tset', NULL, 'Variation_Product', 1, 0, 0, 0, 1, 1, 1, 1, 0, '0', '0', 0, 0, '', 0, 'month', 0, 'month', '', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', '[\"{\\\"variation_name\\\":\\\"Size\\\",\\\"attribute_id\\\":\\\"2\\\",\\\"child_row_attribute\\\":\\\"[\\\\\\\"S\\\\\\\",\\\\\\\"M\\\\\\\",\\\\\\\"L\\\\\\\"]\\\"}\",\"{\\\"variation_name\\\":\\\"Color\\\",\\\"attribute_id\\\":\\\"1\\\",\\\"child_row_attribute\\\":\\\"[\\\\\\\"Black\\\\\\\",\\\\\\\"Blue\\\\\\\",\\\\\\\"Green\\\\\\\"]\\\"}\"]', 'Variation_Product', 0, '2024-02-23 22:34:56', 1, 1, 'Live'),
(20, '019-01', 'M - Black', NULL, '0', 1, 0, 0, 1, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:34:56', 1, 1, 'Deleted'),
(21, '019-02', 'M - Blue', NULL, '0', 1, 0, 0, 1, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:34:56', 1, 1, 'Deleted'),
(22, '019-03', 'L - Black', NULL, '0', 1, 0, 0, 1, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:34:56', 1, 1, 'Deleted'),
(23, '019-04', 'L - Blue', NULL, '0', 1, 0, 0, 1, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:34:56', 1, 1, 'Deleted'),
(24, '019-01', 'S - Black', NULL, '0', 1, 0, 0, 1, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:40:06', 1, 1, 'Live'),
(25, '019-02', 'S - Blue', NULL, '0', 1, 0, 0, 0, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:40:06', 1, 1, 'Live'),
(26, '019-03', 'S - Green', NULL, '0', 1, 0, 0, 0, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:40:06', 1, 1, 'Live'),
(27, '019-04', 'M - Black', NULL, '0', 1, 0, 0, 0, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:40:06', 1, 1, 'Live'),
(28, '019-05', 'M - Blue', NULL, '0', 1, 0, 0, 0, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:40:06', 1, 1, 'Live'),
(29, '019-06', 'M - Green', NULL, '0', 1, 0, 0, 1, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:40:06', 1, 1, 'Live'),
(30, '019-07', 'L - Black', NULL, '0', 1, 0, 0, 1, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:40:06', 1, 1, 'Live'),
(31, '019-08', 'L - Blue', NULL, '0', 1, 0, 0, 1, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:40:06', 1, 1, 'Live'),
(32, '019-09', 'L - Green', NULL, '0', 1, 0, 0, 1, 1, 1, 1, 1, 11, '11', '11', 11, 11, NULL, 0, NULL, 0, NULL, 'image_thumb.png', '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 19, '2024-02-23 22:40:06', 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_item_categories`
--

CREATE TABLE `tbl_item_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `sort_id` int(55) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(10) UNSIGNED DEFAULT NULL,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_item_categories`
--

INSERT INTO `tbl_item_categories` (`id`, `name`, `description`, `sort_id`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Uncategorized', '', NULL, '2023-11-29 17:55:35', 1, 1, 'Live'),
(2, 'Medicine', '', NULL, '2023-11-29 17:55:42', 1, 1, 'Live'),
(4, 'Computer Accessories', '', NULL, '2023-11-29 17:56:29', 1, 1, 'Live'),
(6, 'Electronic Accessories', '', NULL, '2023-11-29 18:00:27', 1, 1, 'Live'),
(7, 'Health Care', '', NULL, '2023-11-29 18:01:56', 1, 1, 'Live'),
(8, 'Sports', '', NULL, '2023-11-29 18:02:20', 1, 1, 'Live'),
(9, 'Groceries', '', NULL, '2023-11-29 18:21:01', 1, 1, 'Live'),
(10, 'Mobile Phone', '', NULL, '2023-11-29 19:51:18', 1, 1, 'Live'),
(11, 'Dress', '', NULL, '2023-11-29 19:51:18', 1, 1, 'Live'),
(12, 'Furniture', '', NULL, '2024-02-22 21:14:17', 1, 1, 'Live'),
(13, 'Drinks', '', NULL, '2024-02-22 21:26:35', 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_main_modules`
--

CREATE TABLE `tbl_main_modules` (
  `id` int(11) NOT NULL,
  `name` varchar(20) DEFAULT NULL,
  `del_status` varchar(15) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_main_modules`
--

INSERT INTO `tbl_main_modules` (`id`, `name`, `del_status`) VALUES
(1, 'Common', 'Live'),
(2, 'Product/Item & Other', 'Live'),
(3, 'Settings', 'Live'),
(4, 'Installment', 'Live'),
(5, 'Withdraw and Deposit', 'Live'),
(6, 'Online Order Setting', 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_notifications`
--

CREATE TABLE `tbl_notifications` (
  `id` int(11) NOT NULL,
  `notifications_details` varchar(300) DEFAULT NULL,
  `visible_status` int(11) DEFAULT 1,
  `read_status` int(11) NOT NULL DEFAULT 0,
  `installment_id` int(11) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_notifications`
--

INSERT INTO `tbl_notifications` (`id`, `notifications_details`, `visible_status`, `read_status`, `installment_id`, `date`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, 'Rafsan(01629171724) Poco M2 er kisti 7649 taka 02/29/2024 e debar kotha.', 1, 0, 1, '2024-02-28', NULL, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_outlets`
--

CREATE TABLE `tbl_outlets` (
  `id` int(11) NOT NULL,
  `outlet_name` varchar(50) DEFAULT NULL,
  `outlet_code` varchar(50) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `active_status` varchar(25) DEFAULT 'active',
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_outlets`
--

INSERT INTO `tbl_outlets` (`id`, `outlet_name`, `outlet_code`, `address`, `phone`, `email`, `added_date`, `user_id`, `active_status`, `company_id`, `del_status`) VALUES
(1, 'Mirpur', '000001', 'Mirpur 10, Dhaka Bangladesh', '01629171720', 'mirpur@gmail.com', '2023-11-29 19:29:44', 1, 'active', 1, 'Live'),
(2, 'Dhanmondi', '000002', 'Dhanmondi', '012456387', 'dhanmondi@gmail.com', '2023-12-10 17:52:07', 1, 'active', 1, 'Live'),
(3, 'Bashundhara', '000003', 'Nikunja 2, Dhaka 1207', '01629171727', 'bashundhara@gmail.com', '2024-01-25 12:00:06', 1, 'active', 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_payment_methods`
--

CREATE TABLE `tbl_payment_methods` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `account_type` varchar(25) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `current_balance` float DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_payment_methods`
--

INSERT INTO `tbl_payment_methods` (`id`, `name`, `account_type`, `description`, `current_balance`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Bank', 'Bank_Account', '', 10, '2023-07-30 21:22:42', 1, 1, 'Live'),
(2, 'Cash', 'Cash', '', 1001, '2023-07-30 21:22:42', 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_printers`
--

CREATE TABLE `tbl_printers` (
  `id` int(11) NOT NULL,
  `path` varchar(300) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `profile_` varchar(100) DEFAULT NULL,
  `characters_per_line` int(11) DEFAULT NULL,
  `printer_ip_address` varchar(20) DEFAULT NULL,
  `printer_port` varchar(20) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_printers`
--

INSERT INTO `tbl_printers` (`id`, `path`, `title`, `type`, `profile_`, `characters_per_line`, `printer_ip_address`, `printer_port`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'TEST', 'OFF POS Printer', 'windows', 'default', 46, '10.12.012', '50', '2023-12-10 16:53:47', 1, 1, 'Deleted');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_promotions`
--

CREATE TABLE `tbl_promotions` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `start_date` varchar(50) DEFAULT NULL,
  `end_date` varchar(50) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `food_menu_id` varchar(11) DEFAULT NULL,
  `qty` float DEFAULT NULL,
  `get_food_menu_id` varchar(11) DEFAULT NULL,
  `get_qty` float DEFAULT NULL,
  `discount` varchar(10) DEFAULT NULL,
  `status` int(11) DEFAULT 1,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_purchase`
--

CREATE TABLE `tbl_purchase` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(50) DEFAULT NULL,
  `invoice_no` varchar(100) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `other` float DEFAULT NULL,
  `grand_total` float DEFAULT NULL,
  `paid` float DEFAULT NULL,
  `due_amount` float DEFAULT NULL,
  `note` text DEFAULT NULL,
  `discount` varchar(11) DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_purchase`
--

INSERT INTO `tbl_purchase` (`id`, `reference_no`, `invoice_no`, `supplier_id`, `date`, `other`, `grand_total`, `paid`, `due_amount`, `note`, `discount`, `attachment`, `added_date`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(5, '000001', '34242342', 1, '2024-02-28', 0, 63360, 0, 63360, '', '', '', '2024-02-28 10:26:06', 1, 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_purchase_details`
--

CREATE TABLE `tbl_purchase_details` (
  `id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_type` varchar(50) DEFAULT NULL,
  `expiry_imei_serial` varchar(255) DEFAULT NULL,
  `unit_price` float DEFAULT NULL,
  `divided_price` float DEFAULT NULL,
  `quantity_amount` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_purchase_details`
--

INSERT INTO `tbl_purchase_details` (`id`, `item_id`, `item_type`, `expiry_imei_serial`, `unit_price`, `divided_price`, `quantity_amount`, `total`, `purchase_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, 13, 'Serial_Product', '123313123', 3000, 3000, 1, 3000, 5, 1, 1, 'Live'),
(2, 5, 'Variation_Product', '', 180, 180, 2, 360, 5, 1, 1, 'Live'),
(3, 12, 'IMEI_Product', '123123155', 12000, 12000, 1, 12000, 5, 1, 1, 'Live'),
(4, 12, 'IMEI_Product', '12312344', 12000, 12000, 1, 12000, 5, 1, 1, 'Live'),
(5, 12, 'IMEI_Product', '1231232222', 12000, 12000, 1, 12000, 5, 1, 1, 'Live'),
(6, 12, 'IMEI_Product', '12312322', 12000, 12000, 1, 12000, 5, 1, 1, 'Live'),
(7, 12, 'IMEI_Product', '13123123', 12000, 12000, 1, 12000, 5, 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_purchase_payments`
--

CREATE TABLE `tbl_purchase_payments` (
  `id` int(11) NOT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_purchase_return`
--

CREATE TABLE `tbl_purchase_return` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `pur_ref_no` varchar(255) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `purchase_date` varchar(55) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `return_status` varchar(100) DEFAULT NULL,
  `total_return_amount` float DEFAULT NULL,
  `payment_method_id` int(11) NOT NULL DEFAULT 1,
  `payment_method_type` varchar(255) DEFAULT NULL,
  `account_type` varchar(20) DEFAULT NULL,
  `note` varchar(300) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_purchase_return_details`
--

CREATE TABLE `tbl_purchase_return_details` (
  `id` int(11) NOT NULL,
  `pur_return_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_type` varchar(50) DEFAULT NULL,
  `expiry_imei_serial` varchar(255) DEFAULT NULL,
  `expiry_imei_serial_in` varchar(55) DEFAULT NULL,
  `return_note` text DEFAULT NULL,
  `return_quantity_amount` varchar(11) DEFAULT NULL,
  `unit_price` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  `return_status` varchar(100) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_quotations`
--

CREATE TABLE `tbl_quotations` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(50) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `other` float DEFAULT NULL,
  `subtotal` float DEFAULT NULL,
  `grand_total` float DEFAULT NULL,
  `discount` varchar(11) DEFAULT NULL,
  `due` float DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_quotation_details`
--

CREATE TABLE `tbl_quotation_details` (
  `id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `unit_price` float DEFAULT NULL,
  `quantity_amount` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  `quotation_id` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_register`
--

CREATE TABLE `tbl_register` (
  `id` int(11) NOT NULL,
  `opening_balance` float DEFAULT NULL,
  `opening_details` text DEFAULT NULL,
  `closing_balance` float DEFAULT NULL,
  `opening_balance_date_time` varchar(30) DEFAULT NULL,
  `closing_balance_date_time` varchar(30) DEFAULT NULL,
  `sale_paid_amount` float DEFAULT NULL,
  `refund_amount` float DEFAULT NULL,
  `customer_due_receive` float DEFAULT NULL,
  `payment_methods_sale` text NOT NULL,
  `register_status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1=open,2=closed',
  `others_currency` text DEFAULT NULL,
  `total_purchase` float DEFAULT NULL,
  `total_downpayment` float(10,3) DEFAULT NULL,
  `total_installmentcollection` float(10,3) DEFAULT NULL,
  `total_servicing` float(10,3) DEFAULT NULL,
  `total_purchase_return` int(55) DEFAULT NULL,
  `total_due_payment` float DEFAULT NULL,
  `total_expense` float DEFAULT NULL,
  `added_date` varchar(30) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_register`
--

INSERT INTO `tbl_register` (`id`, `opening_balance`, `opening_details`, `closing_balance`, `opening_balance_date_time`, `closing_balance_date_time`, `sale_paid_amount`, `refund_amount`, `customer_due_receive`, `payment_methods_sale`, `register_status`, `others_currency`, `total_purchase`, `total_downpayment`, `total_installmentcollection`, `total_servicing`, `total_purchase_return`, `total_due_payment`, `total_expense`, `added_date`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, 10, '[\"1||Bank||6\",\"2||Cash||4\"]', 25310.4, '2024-02-19 15:17:57', '2024-02-28 10:26:39', 22298.4, 0, 0, '{\"Bank\":22304.399215698242,\"Cash\":3006}', 2, NULL, 0, 2.000, 0.000, 3000.000, 0, 0, 0, '2024-02-19 15:17:57', 1, 1, 1, 'Live'),
(2, 112, '[\"1||Bank||100\",\"2||Cash||12\"]', 112, '2024-03-25 11:17:53', '2024-03-25 11:19:26', 0, 0, 0, '{\"Bank\":100,\"Cash\":12}', 2, NULL, 0, 0.000, 0.000, 0.000, 0, 0, 0, '2024-03-25 11:17:53', 1, 1, 1, 'Live'),
(3, 0, '[\"1||Bank||0\",\"2||Cash||0\"]', 0, '2024-03-25 11:19:29', '2024-03-25 11:19:34', 0, 0, 0, '{\"Bank\":0,\"Cash\":0}', 2, NULL, 0, 0.000, 0.000, 0.000, 0, 0, 0, '2024-03-25 11:19:29', 1, 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_salaries`
--

CREATE TABLE `tbl_salaries` (
  `id` int(11) NOT NULL,
  `month` varchar(11) DEFAULT NULL,
  `month_no` int(11) DEFAULT NULL,
  `year` varchar(11) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `total_amount` float DEFAULT NULL,
  `details_info` mediumtext DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_sales`
--

CREATE TABLE `tbl_sales` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `sale_no` varchar(50) NOT NULL DEFAULT '000000',
  `total_items` int(11) DEFAULT NULL,
  `sub_total` float DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `previous_due` float DEFAULT NULL,
  `due_amount` float DEFAULT NULL,
  `disc` varchar(11) DEFAULT NULL,
  `disc_actual` float DEFAULT NULL,
  `vat` float DEFAULT NULL,
  `total_payable` float DEFAULT NULL,
  `close_time` varchar(30) DEFAULT NULL,
  `total_item_discount_amount` float NOT NULL,
  `sub_total_with_discount` float NOT NULL,
  `sub_total_discount_amount` float NOT NULL,
  `total_discount_amount` float NOT NULL,
  `delivery_charge` float NOT NULL,
  `charge_type` varchar(55) DEFAULT NULL,
  `sub_total_discount_value` varchar(11) NOT NULL,
  `sub_total_discount_type` varchar(20) NOT NULL,
  `sale_date` varchar(20) NOT NULL,
  `date_time` varchar(30) DEFAULT NULL,
  `order_time` varchar(30) DEFAULT NULL,
  `grand_total` float DEFAULT NULL,
  `online_yes_no` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1-POS NO,2-Online Yes',
  `due_date_time` varchar(50) DEFAULT NULL,
  `account_note` varchar(100) DEFAULT NULL,
  `account_type` varchar(55) DEFAULT NULL,
  `sale_vat_objects` text DEFAULT NULL,
  `random_code` varchar(50) DEFAULT NULL,
  `note` varchar(300) DEFAULT NULL,
  `order_date_time` varchar(30) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `tbl_sales`
--

INSERT INTO `tbl_sales` (`id`, `customer_id`, `employee_id`, `sale_no`, `total_items`, `sub_total`, `paid_amount`, `previous_due`, `due_amount`, `disc`, `disc_actual`, `vat`, `total_payable`, `close_time`, `total_item_discount_amount`, `sub_total_with_discount`, `sub_total_discount_amount`, `total_discount_amount`, `delivery_charge`, `charge_type`, `sub_total_discount_value`, `sub_total_discount_type`, `sale_date`, `date_time`, `order_time`, `grand_total`, `online_yes_no`, `due_date_time`, `account_note`, `account_type`, `sale_vat_objects`, `random_code`, `note`, `order_date_time`, `added_date`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, 36, 0, 'IN#000001', 5, 18046, 22196.2, -100, 0, NULL, NULL, 4150.5, 22196.2, '15:49:36', 182.3, 18045.7, 0, 182.3, 0, 'delivery', '0.0', 'plain', '2024-02-25', '2024-02-25 15:49:36', '15:49:36', 22196.2, 1, NULL, '', 'Bank_Account', '[{\"tax_field_id\":\"IGST\",\"tax_field_type\":\"\",\"tax_field_amount\":\"3970.1\"},{\"tax_field_id\":\"VAT\",\"tax_field_type\":\"\",\"tax_field_amount\":\"180.4\"}]', 'rxJi2ztyJxcOXST', '', '2024-02-25 15:49:36', '2024-02-25 15:49:36', 1, 1, 1, 'Live'),
(2, 1, 0, 'IN#000002', 2, 72, 102.2, 0, 0, NULL, NULL, 30.2, 102.2, '10:21:29', 0, 72, 0, 0, 0, 'delivery', '0.0', 'plain', '2024-02-28', '2024-02-28 10:21:28', '10:21:28', 102.2, 1, NULL, '', 'Bank_Account', '[{\"tax_field_id\":\"CGST\",\"tax_field_type\":\"\",\"tax_field_amount\":\"10.8\"},{\"tax_field_id\":\"SGST\",\"tax_field_type\":\"\",\"tax_field_amount\":\"2.9\"},{\"tax_field_id\":\"IGST\",\"tax_field_type\":\"\",\"tax_field_amount\":\"15.8\"},{\"tax_field_id\":\"VAT\",\"tax_field_type\":\"\",\"tax_field_amount\":\"0.7\"}]', 'SnTEGLT9ix96y70', '', '2024-02-28 10:21:28', '2024-02-28 10:21:28', 1, 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_sales_details`
--

CREATE TABLE `tbl_sales_details` (
  `id` bigint(20) NOT NULL,
  `food_menu_id` int(11) DEFAULT NULL,
  `qty` float DEFAULT NULL,
  `menu_price_without_discount` float DEFAULT NULL,
  `menu_price_with_discount` float DEFAULT NULL,
  `menu_unit_price` float DEFAULT NULL,
  `purchase_price` float DEFAULT NULL,
  `menu_vat_percentage` float DEFAULT NULL,
  `menu_taxes` text DEFAULT NULL,
  `menu_discount_value` varchar(11) DEFAULT NULL,
  `discount_type` varchar(30) DEFAULT NULL,
  `menu_note` varchar(255) DEFAULT NULL,
  `discount_amount` double DEFAULT NULL,
  `item_type` varchar(50) DEFAULT NULL,
  `expiry_imei_serial` varchar(55) DEFAULT NULL,
  `sales_id` int(11) DEFAULT NULL,
  `is_promo_item` varchar(11) DEFAULT NULL,
  `promo_parent_id` int(11) DEFAULT NULL,
  `item_seller_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `tbl_sales_details`
--

INSERT INTO `tbl_sales_details` (`id`, `food_menu_id`, `qty`, `menu_price_without_discount`, `menu_price_with_discount`, `menu_unit_price`, `purchase_price`, `menu_vat_percentage`, `menu_taxes`, `menu_discount_value`, `discount_type`, `menu_note`, `discount_amount`, `item_type`, `expiry_imei_serial`, `sales_id`, `is_promo_item`, `promo_parent_id`, `item_seller_id`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, 2, 3, 60, 59.4, 20, 14, NULL, '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', '1%', 'percentage', '', 0.6, 'General_Product', '', 1, 'No', 0, 0, 1, 1, 1, 'Live'),
(2, 32, 3, 33, 32.7, 11, 11, NULL, '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', '1%', 'percentage', '', 0.3, 'Variation_Product', '', 1, 'No', 0, 0, 1, 1, 1, 'Live'),
(3, 12, 1, 14000, 13860, 14000, 12000, NULL, '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', '1%', 'percentage', '', 140, 'IMEI_Product', 'PC-00001', 1, 'No', 0, 0, 1, 1, 1, 'Live'),
(4, 15, 3, 135, 133.6, 45, 30, NULL, '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', '1%', 'percentage', '', 1.4, 'Expiry_Product', '2024-02-24', 1, 'No', 0, 0, 1, 1, 1, 'Live'),
(5, 13, 1, 4000, 3960, 4000, 3000, NULL, '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', '1%', 'percentage', '', 40, 'Serial_Product', 'BL-00002', 1, 'No', 0, 0, 1, 1, 1, 'Live'),
(6, 31, 2, 22, 22, 11, 11, NULL, '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', '0', 'plain', '', 0, 'Variation_Product', '', 2, 'No', 0, 0, 1, 1, 1, 'Live'),
(7, 15, 1, 50, 50, 50, 30, NULL, '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"15\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"4\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"22\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', '0', 'plain', '', 0, 'Expiry_Product', '2024-02-24', 2, 'No', 0, 0, 1, 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_sale_payments`
--

CREATE TABLE `tbl_sale_payments` (
  `id` int(11) NOT NULL,
  `date` varchar(55) DEFAULT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `currency_type` int(11) DEFAULT NULL,
  `multi_currency` varchar(10) DEFAULT NULL,
  `multi_currency_rate` float DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `sale_id` int(11) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `payment_name` varchar(100) DEFAULT NULL,
  `payment_details` varchar(255) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_sale_payments`
--

INSERT INTO `tbl_sale_payments` (`id`, `date`, `payment_id`, `currency_type`, `multi_currency`, `multi_currency_rate`, `amount`, `sale_id`, `added_date`, `payment_name`, `payment_details`, `outlet_id`, `user_id`, `company_id`, `del_status`) VALUES
(1, '2024-02-25', 1, NULL, NULL, NULL, 22196.2, 1, '2024-02-25 15:49:36', 'Bank', ',,', 1, 1, 1, 'Live'),
(2, '2024-02-28', 1, NULL, NULL, NULL, 102.2, 2, '2024-02-28 10:21:29', 'Bank', ',,', 1, 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_sale_return`
--

CREATE TABLE `tbl_sale_return` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(25) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `total_return_amount` float DEFAULT NULL,
  `payment_method_id` int(11) NOT NULL DEFAULT 1,
  `note` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_sale_return_details`
--

CREATE TABLE `tbl_sale_return_details` (
  `id` int(11) NOT NULL,
  `sale_return_id` int(11) NOT NULL,
  `sale_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `sale_quantity_amount` int(11) DEFAULT 0,
  `return_quantity_amount` int(11) DEFAULT 0,
  `item_type` varchar(55) DEFAULT NULL,
  `expiry_imei_serial` varchar(55) DEFAULT NULL,
  `menu_taxes` varchar(500) DEFAULT NULL,
  `unit_price_in_sale` float DEFAULT 0,
  `unit_price_in_return` float DEFAULT 0,
  `user_id` int(11) DEFAULT 0,
  `outlet_id` int(11) DEFAULT 0,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(10) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_servicing`
--

CREATE TABLE `tbl_servicing` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `date` varchar(55) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `product_model` varchar(55) DEFAULT NULL,
  `problem_description` text DEFAULT NULL,
  `receiving_date` varchar(55) DEFAULT NULL,
  `delivery_date` varchar(55) DEFAULT NULL,
  `servicing_charge` float(10,3) DEFAULT NULL,
  `paid_amount` float(10,3) DEFAULT NULL,
  `due_amount` float(10,3) DEFAULT NULL,
  `status` varchar(55) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `payment_method_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `del_status` varchar(25) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `tbl_servicing`
--

INSERT INTO `tbl_servicing` (`id`, `customer_id`, `date`, `product_name`, `product_model`, `problem_description`, `receiving_date`, `delivery_date`, `servicing_charge`, `paid_amount`, `due_amount`, `status`, `employee_id`, `added_date`, `payment_method_id`, `outlet_id`, `user_id`, `company_id`, `del_status`) VALUES
(3, 36, '2024-02-24', 'Hp Pavalion', 'Aux-0017', 'Display problem', '2024-02-24', '', 3000.000, 3000.000, 0.000, 'Received', 54, '2024-02-24 12:19:55', 2, 1, 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_sessions`
--

CREATE TABLE `tbl_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_sessions`
--

INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('3sl3250pmkoolbrkqnf0rrperu6sg28r', '::1', 1708844710, 0x[encoded data, 12890 characters]),
('gjkskreg5sgmh9d75ag7n6rhnumpfnfj', '::1', 1708845063, 0x[encoded data, 12890 characters]),
('rt4mti7vhl39acpqt06oe58ia62if7im', '::1', 1708845386, 0x[encoded data, 12890 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('hn9m8g1ilnprqmgprbc7c1a30dkn2cq3', '::1', 1708845688, 0x[encoded data, 12890 characters]),
('72rod45k27pb189jdaerf8u8dkk1o5vc', '::1', 1708846119, 0x[encoded data, 12890 characters]),
('b91l4pl1531fg7a5ivjcdnioorogspb0', '::1', 1708847267, 0x[encoded data, 12890 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('84sq24pda3t8csb1nq6e30li08d1f6so', '::1', 1708847654, 0x[encoded data, 12890 characters]),
('tq612vstk1dfj0196u32fjgr7j601b0v', '::1', 1708848010, 0x[encoded data, 12890 characters]),
('d91bkmkgkouvaqvt4lc1numo41tevlgi', '::1', 1708849177, 0x[encoded data, 12890 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('oounj7de36e2rqjevok92kcsn949gdqp', '::1', 1708849507, 0x[encoded data, 12890 characters]),
('b07kjqv9nds3lqe4dci6eh1fca8pe2b9', '::1', 1708849998, 0x[encoded data, 12890 characters]),
('7j4mqpd1f567brp72fh1oo25irs4kdpf', '::1', 1708850321, 0x[encoded data, 12890 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('rm1u49pki75v9fdb768nhs9i6jrgjqji', '::1', 1708850704, 0x[encoded data, 12890 characters]),
('r1gsasi4k985mubu1bjnvjb1dl7c3ig3', '::1', 1708851320, 0x[encoded data, 12890 characters]),
('pr29m1i9lgm6blb4lvevbaaj7emdmleo', '::1', 1708851702, 0x[encoded data, 12890 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('3thpnu4j6n1chrislmkgq3frj7shhu5u', '::1', 1708853710, 0x[encoded data, 12890 characters]),
('vk624c424uhkc16pb7o3ifnkc9bc3tkt', '::1', 1708854122, 0x[encoded data, 12890 characters]),
('vfa525ao7bcsdqij671efl58q64o90jv', '::1', 1708854576, 0x[encoded data, 12890 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('2302mlg9o768h7an08ip5s6ummiqpto0', '::1', 1708854826, 0x[encoded data, 12890 characters]),
('10faj0l4ci3g0do584s06dhlfduj1soc', '::1', 1709094366, 0x[encoded data, 12584 characters]),
('qrggp5kmihuk4jmeq96jj166iqpidqss', '::1', 1709095929, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730393039353932393b6f70656e5f636173685f6472617765727c733a323a224e6f223b),
('o8gm80skq7q1img1lit8o36m4hbl7qdo', '::1', 1709096017, 0x5f5f63695f6c6173745f726567656e65726174657c693a313730393039353932393b6f70656e5f636173685f6472617765727c733a323a224e6f223b),
('2n2aateq8nh6t1p4mv28ibv5b136sn8d', '::1', 1711343974, 0x5f5f63695f6c6173745f726567656e65726174657c693a313731313334333834303b6f70656e5f636173685f6472617765727c733a323a224e6f223b);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_set_opening_stocks`
--

CREATE TABLE `tbl_set_opening_stocks` (
  `id` bigint(255) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_type` varchar(55) DEFAULT NULL,
  `item_description` varchar(255) DEFAULT NULL,
  `stock_quantity` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `del_status` varchar(10) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_set_opening_stocks`
--

INSERT INTO `tbl_set_opening_stocks` (`id`, `item_id`, `item_type`, `item_description`, `stock_quantity`, `outlet_id`, `user_id`, `company_id`, `del_status`) VALUES
(7, 1, 'General_Product', '', 60, 1, 1, 1, 'Deleted'),
(8, 1, 'General_Product', '', 60, 2, 1, 1, 'Deleted'),
(11, 2, 'General_Product', '', 408, 1, 1, 1, 'Live'),
(12, 2, 'General_Product', '', 408, 2, 1, 1, 'Live'),
(13, 3, 'General_Product', '', 90, 1, 1, 1, 'Live'),
(14, 3, 'General_Product', '', 80, 2, 1, 1, 'Live'),
(15, 5, 'Variation_Product', NULL, 0, 3, 1, 1, 'Live'),
(16, 5, 'Variation_Product', NULL, 0, 2, 1, 1, 'Live'),
(17, 5, 'Variation_Product', NULL, 10, 1, 1, 1, 'Live'),
(18, 6, 'Variation_Product', NULL, 0, 3, 1, 1, 'Live'),
(19, 6, 'Variation_Product', NULL, 0, 2, 1, 1, 'Live'),
(20, 6, 'Variation_Product', NULL, 15, 1, 1, 1, 'Live'),
(33, 8, 'Variation_Product', NULL, 0, 3, 1, 1, 'Live'),
(34, 8, 'Variation_Product', NULL, 0, 2, 1, 1, 'Live'),
(35, 8, 'Variation_Product', NULL, 36, 1, 1, 1, 'Live'),
(36, 9, 'Variation_Product', NULL, 0, 3, 1, 1, 'Live'),
(37, 9, 'Variation_Product', NULL, 0, 2, 1, 1, 'Live'),
(38, 9, 'Variation_Product', NULL, 48, 1, 1, 1, 'Live'),
(39, 10, 'Variation_Product', NULL, 0, 3, 1, 1, 'Live'),
(40, 10, 'Variation_Product', NULL, 0, 2, 1, 1, 'Live'),
(41, 10, 'Variation_Product', NULL, 60, 1, 1, 1, 'Live'),
(42, 11, 'Variation_Product', NULL, 0, 3, 1, 1, 'Live'),
(43, 11, 'Variation_Product', NULL, 0, 2, 1, 1, 'Live'),
(44, 11, 'Variation_Product', NULL, 72, 1, 1, 1, 'Live'),
(45, 12, 'IMEI_Product', 'PC-00002', 1, 1, 1, 1, 'Live'),
(46, 12, 'IMEI_Product', 'PC-00001', 1, 1, 1, 1, 'Live'),
(47, 13, 'Serial_Product', 'BL-00002', 1, 1, 1, 1, 'Live'),
(48, 13, 'Serial_Product', 'BL-00001', 1, 1, 1, 1, 'Live'),
(49, 14, 'Expiry_Product', '2024-02-24', 5, 1, 1, 1, 'Live'),
(50, 14, 'Expiry_Product', '2024-02-23', 5, 1, 1, 1, 'Live'),
(51, 15, 'Expiry_Product', '2024-03-02', 20, 1, 1, 1, 'Live'),
(52, 15, 'Expiry_Product', '2024-02-24', 20, 1, 1, 1, 'Live'),
(53, 17, 'Variation_Product', NULL, 0, 3, 1, 1, 'Live'),
(54, 17, 'Variation_Product', NULL, 0, 2, 1, 1, 'Live'),
(55, 17, 'Variation_Product', NULL, 10, 1, 1, 1, 'Live'),
(56, 18, 'Variation_Product', NULL, 0, 3, 1, 1, 'Live'),
(57, 18, 'Variation_Product', NULL, 0, 2, 1, 1, 'Live'),
(58, 18, 'Variation_Product', NULL, 10, 1, 1, 1, 'Live'),
(59, 20, 'Variation_Product', NULL, 0, 3, 1, 1, 'Live'),
(60, 20, 'Variation_Product', NULL, 0, 2, 1, 1, 'Live'),
(61, 20, 'Variation_Product', NULL, 11, 1, 1, 1, 'Live'),
(62, 21, 'Variation_Product', NULL, 0, 3, 1, 1, 'Live'),
(63, 21, 'Variation_Product', NULL, 0, 2, 1, 1, 'Live'),
(64, 21, 'Variation_Product', NULL, 11, 1, 1, 1, 'Live'),
(65, 22, 'Variation_Product', NULL, 0, 3, 1, 1, 'Live'),
(66, 22, 'Variation_Product', NULL, 0, 2, 1, 1, 'Live'),
(67, 22, 'Variation_Product', NULL, 11, 1, 1, 1, 'Live'),
(68, 23, 'Variation_Product', NULL, 0, 3, 1, 1, 'Live'),
(69, 23, 'Variation_Product', NULL, 0, 2, 1, 1, 'Live'),
(70, 23, 'Variation_Product', NULL, 11, 1, 1, 1, 'Live'),
(71, 24, 'Variation_Product', NULL, 1, 3, 1, 1, 'Live'),
(72, 24, 'Variation_Product', NULL, 1, 2, 1, 1, 'Live'),
(73, 24, 'Variation_Product', NULL, 1, 1, 1, 1, 'Live'),
(74, 25, 'Variation_Product', NULL, 1, 3, 1, 1, 'Live'),
(75, 25, 'Variation_Product', NULL, 1, 2, 1, 1, 'Live'),
(76, 25, 'Variation_Product', NULL, 1, 1, 1, 1, 'Live'),
(77, 26, 'Variation_Product', NULL, 1, 3, 1, 1, 'Live'),
(78, 26, 'Variation_Product', NULL, 1, 2, 1, 1, 'Live'),
(79, 26, 'Variation_Product', NULL, 1, 1, 1, 1, 'Live'),
(80, 27, 'Variation_Product', NULL, 1, 3, 1, 1, 'Live'),
(81, 27, 'Variation_Product', NULL, 1, 2, 1, 1, 'Live'),
(82, 27, 'Variation_Product', NULL, 1, 1, 1, 1, 'Live'),
(83, 28, 'Variation_Product', NULL, 11, 3, 1, 1, 'Live'),
(84, 28, 'Variation_Product', NULL, 11, 2, 1, 1, 'Live'),
(85, 28, 'Variation_Product', NULL, 11, 1, 1, 1, 'Live'),
(86, 29, 'Variation_Product', NULL, 11, 3, 1, 1, 'Live'),
(87, 29, 'Variation_Product', NULL, 11, 2, 1, 1, 'Live'),
(88, 29, 'Variation_Product', NULL, 11, 1, 1, 1, 'Live'),
(89, 30, 'Variation_Product', NULL, 1, 3, 1, 1, 'Live'),
(90, 30, 'Variation_Product', NULL, 1, 2, 1, 1, 'Live'),
(91, 30, 'Variation_Product', NULL, 1, 1, 1, 1, 'Live'),
(92, 31, 'Variation_Product', NULL, 11, 3, 1, 1, 'Live'),
(93, 31, 'Variation_Product', NULL, 11, 2, 1, 1, 'Live'),
(94, 31, 'Variation_Product', NULL, 11, 1, 1, 1, 'Live'),
(95, 32, 'Variation_Product', NULL, 11, 3, 1, 1, 'Live'),
(96, 32, 'Variation_Product', NULL, 11, 2, 1, 1, 'Live'),
(97, 32, 'Variation_Product', NULL, 11, 1, 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Stand-in structure for view `tbl_stock_detail`
-- (See below for the actual view)
--
CREATE TABLE `tbl_stock_detail` (
`item_id` int(11)
,`item_type` varchar(55)
,`expiry_imei_serial` varchar(255)
,`stock_quantity` varchar(12)
,`outlet_id` int(11)
,`type` int(1)
,`description` varchar(18)
);

-- --------------------------------------------------------

--
-- Stand-in structure for view `tbl_stock_detail2`
-- (See below for the actual view)
--
CREATE TABLE `tbl_stock_detail2` (
`item_id` int(11)
,`item_type` varchar(55)
,`expiry_imei_serial` varchar(255)
,`stock_quantity` varchar(34)
,`outlet_id` int(11)
,`type` int(1)
,`description` varchar(18)
);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_suppliers`
--

CREATE TABLE `tbl_suppliers` (
  `id` int(11) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `contact_person` varchar(50) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `address` varchar(300) DEFAULT NULL,
  `description` varchar(300) DEFAULT NULL,
  `opening_balance` int(11) DEFAULT 0,
  `opening_balance_type` varchar(10) DEFAULT 'Credit',
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_suppliers`
--

INSERT INTO `tbl_suppliers` (`id`, `name`, `contact_person`, `phone`, `email`, `address`, `description`, `opening_balance`, `opening_balance_type`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Mr. Zaman', 'Mr. Jeson', '01401748845', 'mr.zaman@gmail.com', '', '', 0, 'Debit', '2024-02-01 12:02:12', 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_supplier_payments`
--

CREATE TABLE `tbl_supplier_payments` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(25) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `amount` float DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `payment_method_id` int(11) NOT NULL DEFAULT 1,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_time_zone`
--

CREATE TABLE `tbl_time_zone` (
  `id` int(11) NOT NULL,
  `country_code` varchar(2) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
  `zone_name` varchar(50) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
  `del_status` varchar(11) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_time_zone`
--

INSERT INTO `tbl_time_zone` (`id`, `country_code`, `zone_name`, `del_status`) VALUES
(1, 'AD', 'Europe/Andorra', 'Live'),
(2, 'AE', 'Asia/Dubai', 'Live'),
(3, 'AF', 'Asia/Kabul', 'Live'),
(4, 'AG', 'America/Antigua', 'Live'),
(5, 'AI', 'America/Anguilla', 'Live'),
(6, 'AL', 'Europe/Tirane', 'Live'),
(7, 'AM', 'Asia/Yerevan', 'Live'),
(8, 'AO', 'Africa/Luanda', 'Live'),
(9, 'AQ', 'Antarctica/McMurdo', 'Live'),
(10, 'AQ', 'Antarctica/Casey', 'Live'),
(11, 'AQ', 'Antarctica/Davis', 'Live'),
(12, 'AQ', 'Antarctica/DumontDUrville', 'Live'),
(13, 'AQ', 'Antarctica/Mawson', 'Live'),
(14, 'AQ', 'Antarctica/Palmer', 'Live'),
(15, 'AQ', 'Antarctica/Rothera', 'Live'),
(16, 'AQ', 'Antarctica/Syowa', 'Live'),
(17, 'AQ', 'Antarctica/Troll', 'Live'),
(18, 'AQ', 'Antarctica/Vostok', 'Live'),
(19, 'AR', 'America/Argentina/Buenos_Aires', 'Live'),
(20, 'AR', 'America/Argentina/Cordoba', 'Live'),
(21, 'AR', 'America/Argentina/Salta', 'Live'),
(22, 'AR', 'America/Argentina/Jujuy', 'Live'),
(23, 'AR', 'America/Argentina/Tucuman', 'Live'),
(24, 'AR', 'America/Argentina/Catamarca', 'Live'),
(25, 'AR', 'America/Argentina/La_Rioja', 'Live'),
(26, 'AR', 'America/Argentina/San_Juan', 'Live'),
(27, 'AR', 'America/Argentina/Mendoza', 'Live'),
(28, 'AR', 'America/Argentina/San_Luis', 'Live'),
(29, 'AR', 'America/Argentina/Rio_Gallegos', 'Live'),
(30, 'AR', 'America/Argentina/Ushuaia', 'Live'),
(31, 'AS', 'Pacific/Pago_Pago', 'Live'),
(32, 'AT', 'Europe/Vienna', 'Live'),
(33, 'AU', 'Australia/Lord_Howe', 'Live'),
(34, 'AU', 'Antarctica/Macquarie', 'Live'),
(35, 'AU', 'Australia/Hobart', 'Live'),
(36, 'AU', 'Australia/Currie', 'Live'),
(37, 'AU', 'Australia/Melbourne', 'Live'),
(38, 'AU', 'Australia/Sydney', 'Live'),
(39, 'AU', 'Australia/Broken_Hill', 'Live'),
(40, 'AU', 'Australia/Brisbane', 'Live'),
(41, 'AU', 'Australia/Lindeman', 'Live'),
(42, 'AU', 'Australia/Adelaide', 'Live'),
(43, 'AU', 'Australia/Darwin', 'Live'),
(44, 'AU', 'Australia/Perth', 'Live'),
(45, 'AU', 'Australia/Eucla', 'Live'),
(46, 'AW', 'America/Aruba', 'Live'),
(47, 'AX', 'Europe/Mariehamn', 'Live'),
(48, 'AZ', 'Asia/Baku', 'Live'),
(49, 'BA', 'Europe/Sarajevo', 'Live'),
(50, 'BB', 'America/Barbados', 'Live'),
(51, 'BD', 'Asia/Dhaka', 'Live'),
(52, 'BE', 'Europe/Brussels', 'Live'),
(53, 'BF', 'Africa/Ouagadougou', 'Live'),
(54, 'BG', 'Europe/Sofia', 'Live'),
(55, 'BH', 'Asia/Bahrain', 'Live'),
(56, 'BI', 'Africa/Bujumbura', 'Live'),
(57, 'BJ', 'Africa/Porto-Novo', 'Live'),
(58, 'BL', 'America/St_Barthelemy', 'Live'),
(59, 'BM', 'Atlantic/Bermuda', 'Live'),
(60, 'BN', 'Asia/Brunei', 'Live'),
(61, 'BO', 'America/La_Paz', 'Live'),
(62, 'BQ', 'America/Kralendijk', 'Live'),
(63, 'BR', 'America/Noronha', 'Live'),
(64, 'BR', 'America/Belem', 'Live'),
(65, 'BR', 'America/Fortaleza', 'Live'),
(66, 'BR', 'America/Recife', 'Live'),
(67, 'BR', 'America/Araguaina', 'Live'),
(68, 'BR', 'America/Maceio', 'Live'),
(69, 'BR', 'America/Bahia', 'Live'),
(70, 'BR', 'America/Sao_Paulo', 'Live'),
(71, 'BR', 'America/Campo_Grande', 'Live'),
(72, 'BR', 'America/Cuiaba', 'Live'),
(73, 'BR', 'America/Santarem', 'Live'),
(74, 'BR', 'America/Porto_Velho', 'Live'),
(75, 'BR', 'America/Boa_Vista', 'Live'),
(76, 'BR', 'America/Manaus', 'Live'),
(77, 'BR', 'America/Eirunepe', 'Live'),
(78, 'BR', 'America/Rio_Branco', 'Live'),
(79, 'BS', 'America/Nassau', 'Live'),
(80, 'BT', 'Asia/Thimphu', 'Live'),
(81, 'BW', 'Africa/Gaborone', 'Live'),
(82, 'BY', 'Europe/Minsk', 'Live'),
(83, 'BZ', 'America/Belize', 'Live'),
(84, 'CA', 'America/St_Johns', 'Live'),
(85, 'CA', 'America/Halifax', 'Live'),
(86, 'CA', 'America/Glace_Bay', 'Live'),
(87, 'CA', 'America/Moncton', 'Live'),
(88, 'CA', 'America/Goose_Bay', 'Live'),
(89, 'CA', 'America/Blanc-Sablon', 'Live'),
(90, 'CA', 'America/Toronto', 'Live'),
(91, 'CA', 'America/Nipigon', 'Live'),
(92, 'CA', 'America/Thunder_Bay', 'Live'),
(93, 'CA', 'America/Iqaluit', 'Live'),
(94, 'CA', 'America/Pangnirtung', 'Live'),
(95, 'CA', 'America/Atikokan', 'Live'),
(96, 'CA', 'America/Winnipeg', 'Live'),
(97, 'CA', 'America/Rainy_River', 'Live'),
(98, 'CA', 'America/Resolute', 'Live'),
(99, 'CA', 'America/Rankin_Inlet', 'Live'),
(100, 'CA', 'America/Regina', 'Live'),
(101, 'CA', 'America/Swift_Current', 'Live'),
(102, 'CA', 'America/Edmonton', 'Live'),
(103, 'CA', 'America/Cambridge_Bay', 'Live'),
(104, 'CA', 'America/Yellowknife', 'Live'),
(105, 'CA', 'America/Inuvik', 'Live'),
(106, 'CA', 'America/Creston', 'Live'),
(107, 'CA', 'America/Dawson_Creek', 'Live'),
(108, 'CA', 'America/Fort_Nelson', 'Live'),
(109, 'CA', 'America/Vancouver', 'Live'),
(110, 'CA', 'America/Whitehorse', 'Live'),
(111, 'CA', 'America/Dawson', 'Live'),
(112, 'CC', 'Indian/Cocos', 'Live'),
(113, 'CD', 'Africa/Kinshasa', 'Live'),
(114, 'CD', 'Africa/Lubumbashi', 'Live'),
(115, 'CF', 'Africa/Bangui', 'Live'),
(116, 'CG', 'Africa/Brazzaville', 'Live'),
(117, 'CH', 'Europe/Zurich', 'Live'),
(118, 'CI', 'Africa/Abidjan', 'Live'),
(119, 'CK', 'Pacific/Rarotonga', 'Live'),
(120, 'CL', 'America/Santiago', 'Live'),
(121, 'CL', 'America/Punta_Arenas', 'Live'),
(122, 'CL', 'Pacific/Easter', 'Live'),
(123, 'CM', 'Africa/Douala', 'Live'),
(124, 'CN', 'Asia/Shanghai', 'Live'),
(125, 'CN', 'Asia/Urumqi', 'Live'),
(126, 'CO', 'America/Bogota', 'Live'),
(127, 'CR', 'America/Costa_Rica', 'Live'),
(128, 'CU', 'America/Havana', 'Live'),
(129, 'CV', 'Atlantic/Cape_Verde', 'Live'),
(130, 'CW', 'America/Curacao', 'Live'),
(131, 'CX', 'Indian/Christmas', 'Live'),
(132, 'CY', 'Asia/Nicosia', 'Live'),
(133, 'CY', 'Asia/Famagusta', 'Live'),
(134, 'CZ', 'Europe/Prague', 'Live'),
(135, 'DE', 'Europe/Berlin', 'Live'),
(136, 'DE', 'Europe/Busingen', 'Live'),
(137, 'DJ', 'Africa/Djibouti', 'Live'),
(138, 'DK', 'Europe/Copenhagen', 'Live'),
(139, 'DM', 'America/Dominica', 'Live'),
(140, 'DO', 'America/Santo_Domingo', 'Live'),
(141, 'DZ', 'Africa/Algiers', 'Live'),
(142, 'EC', 'America/Guayaquil', 'Live'),
(143, 'EC', 'Pacific/Galapagos', 'Live'),
(144, 'EE', 'Europe/Tallinn', 'Live'),
(145, 'EG', 'Africa/Cairo', 'Live'),
(146, 'EH', 'Africa/El_Aaiun', 'Live'),
(147, 'ER', 'Africa/Asmara', 'Live'),
(148, 'ES', 'Europe/Madrid', 'Live'),
(149, 'ES', 'Africa/Ceuta', 'Live'),
(150, 'ES', 'Atlantic/Canary', 'Live'),
(151, 'ET', 'Africa/Addis_Ababa', 'Live'),
(152, 'FI', 'Europe/Helsinki', 'Live'),
(153, 'FJ', 'Pacific/Fiji', 'Live'),
(154, 'FK', 'Atlantic/Stanley', 'Live'),
(155, 'FM', 'Pacific/Chuuk', 'Live'),
(156, 'FM', 'Pacific/Pohnpei', 'Live'),
(157, 'FM', 'Pacific/Kosrae', 'Live'),
(158, 'FO', 'Atlantic/Faroe', 'Live'),
(159, 'FR', 'Europe/Paris', 'Live'),
(160, 'GA', 'Africa/Libreville', 'Live'),
(161, 'GB', 'Europe/London', 'Live'),
(162, 'GD', 'America/Grenada', 'Live'),
(163, 'GE', 'Asia/Tbilisi', 'Live'),
(164, 'GF', 'America/Cayenne', 'Live'),
(165, 'GG', 'Europe/Guernsey', 'Live'),
(166, 'GH', 'Africa/Accra', 'Live'),
(167, 'GI', 'Europe/Gibraltar', 'Live'),
(168, 'GL', 'America/Godthab', 'Live'),
(169, 'GL', 'America/Danmarkshavn', 'Live'),
(170, 'GL', 'America/Scoresbysund', 'Live'),
(171, 'GL', 'America/Thule', 'Live'),
(172, 'GM', 'Africa/Banjul', 'Live'),
(173, 'GN', 'Africa/Conakry', 'Live'),
(174, 'GP', 'America/Guadeloupe', 'Live'),
(175, 'GQ', 'Africa/Malabo', 'Live'),
(176, 'GR', 'Europe/Athens', 'Live'),
(177, 'GS', 'Atlantic/South_Georgia', 'Live'),
(178, 'GT', 'America/Guatemala', 'Live'),
(179, 'GU', 'Pacific/Guam', 'Live'),
(180, 'GW', 'Africa/Bissau', 'Live'),
(181, 'GY', 'America/Guyana', 'Live'),
(182, 'HK', 'Asia/Hong_Kong', 'Live'),
(183, 'HN', 'America/Tegucigalpa', 'Live'),
(184, 'HR', 'Europe/Zagreb', 'Live'),
(185, 'HT', 'America/Port-au-Prince', 'Live'),
(186, 'HU', 'Europe/Budapest', 'Live'),
(187, 'ID', 'Asia/Jakarta', 'Live'),
(188, 'ID', 'Asia/Pontianak', 'Live'),
(189, 'ID', 'Asia/Makassar', 'Live'),
(190, 'ID', 'Asia/Jayapura', 'Live'),
(191, 'IE', 'Europe/Dublin', 'Live'),
(192, 'IL', 'Asia/Jerusalem', 'Live'),
(193, 'IM', 'Europe/Isle_of_Man', 'Live'),
(194, 'IN', 'Asia/Kolkata', 'Live'),
(195, 'IO', 'Indian/Chagos', 'Live'),
(196, 'IQ', 'Asia/Baghdad', 'Live'),
(197, 'IR', 'Asia/Tehran', 'Live'),
(198, 'IS', 'Atlantic/Reykjavik', 'Live'),
(199, 'IT', 'Europe/Rome', 'Live'),
(200, 'JE', 'Europe/Jersey', 'Live'),
(201, 'JM', 'America/Jamaica', 'Live'),
(202, 'JO', 'Asia/Amman', 'Live'),
(203, 'JP', 'Asia/Tokyo', 'Live'),
(204, 'KE', 'Africa/Nairobi', 'Live'),
(205, 'KG', 'Asia/Bishkek', 'Live'),
(206, 'KH', 'Asia/Phnom_Penh', 'Live'),
(207, 'KI', 'Pacific/Tarawa', 'Live'),
(208, 'KI', 'Pacific/Enderbury', 'Live'),
(209, 'KI', 'Pacific/Kiritimati', 'Live'),
(210, 'KM', 'Indian/Comoro', 'Live'),
(211, 'KN', 'America/St_Kitts', 'Live'),
(212, 'KP', 'Asia/Pyongyang', 'Live'),
(213, 'KR', 'Asia/Seoul', 'Live'),
(214, 'KW', 'Asia/Kuwait', 'Live'),
(215, 'KY', 'America/Cayman', 'Live'),
(216, 'KZ', 'Asia/Almaty', 'Live'),
(217, 'KZ', 'Asia/Qyzylorda', 'Live'),
(218, 'KZ', 'Asia/Aqtobe', 'Live'),
(219, 'KZ', 'Asia/Aqtau', 'Live'),
(220, 'KZ', 'Asia/Atyrau', 'Live'),
(221, 'KZ', 'Asia/Oral', 'Live'),
(222, 'LA', 'Asia/Vientiane', 'Live'),
(223, 'LB', 'Asia/Beirut', 'Live'),
(224, 'LC', 'America/St_Lucia', 'Live'),
(225, 'LI', 'Europe/Vaduz', 'Live'),
(226, 'LK', 'Asia/Colombo', 'Live'),
(227, 'LR', 'Africa/Monrovia', 'Live'),
(228, 'LS', 'Africa/Maseru', 'Live'),
(229, 'LT', 'Europe/Vilnius', 'Live'),
(230, 'LU', 'Europe/Luxembourg', 'Live'),
(231, 'LV', 'Europe/Riga', 'Live'),
(232, 'LY', 'Africa/Tripoli', 'Live'),
(233, 'MA', 'Africa/Casablanca', 'Live'),
(234, 'MC', 'Europe/Monaco', 'Live'),
(235, 'MD', 'Europe/Chisinau', 'Live'),
(236, 'ME', 'Europe/Podgorica', 'Live'),
(237, 'MF', 'America/Marigot', 'Live'),
(238, 'MG', 'Indian/Antananarivo', 'Live'),
(239, 'MH', 'Pacific/Majuro', 'Live'),
(240, 'MH', 'Pacific/Kwajalein', 'Live'),
(241, 'MK', 'Europe/Skopje', 'Live'),
(242, 'ML', 'Africa/Bamako', 'Live'),
(243, 'MM', 'Asia/Yangon', 'Live'),
(244, 'MN', 'Asia/Ulaanbaatar', 'Live'),
(245, 'MN', 'Asia/Hovd', 'Live'),
(246, 'MN', 'Asia/Choibalsan', 'Live'),
(247, 'MO', 'Asia/Macau', 'Live'),
(248, 'MP', 'Pacific/Saipan', 'Live'),
(249, 'MQ', 'America/Martinique', 'Live'),
(250, 'MR', 'Africa/Nouakchott', 'Live'),
(251, 'MS', 'America/Montserrat', 'Live'),
(252, 'MT', 'Europe/Malta', 'Live'),
(253, 'MU', 'Indian/Mauritius', 'Live'),
(254, 'MV', 'Indian/Maldives', 'Live'),
(255, 'MW', 'Africa/Blantyre', 'Live'),
(256, 'MX', 'America/Mexico_City', 'Live'),
(257, 'MX', 'America/Cancun', 'Live'),
(258, 'MX', 'America/Merida', 'Live'),
(259, 'MX', 'America/Monterrey', 'Live'),
(260, 'MX', 'America/Matamoros', 'Live'),
(261, 'MX', 'America/Mazatlan', 'Live'),
(262, 'MX', 'America/Chihuahua', 'Live'),
(263, 'MX', 'America/Ojinaga', 'Live'),
(264, 'MX', 'America/Hermosillo', 'Live'),
(265, 'MX', 'America/Tijuana', 'Live'),
(266, 'MX', 'America/Bahia_Banderas', 'Live'),
(267, 'MY', 'Asia/Kuala_Lumpur', 'Live'),
(268, 'MY', 'Asia/Kuching', 'Live'),
(269, 'MZ', 'Africa/Maputo', 'Live'),
(270, 'NA', 'Africa/Windhoek', 'Live'),
(271, 'NC', 'Pacific/Noumea', 'Live'),
(272, 'NE', 'Africa/Niamey', 'Live'),
(273, 'NF', 'Pacific/Norfolk', 'Live'),
(274, 'NG', 'Africa/Lagos', 'Live'),
(275, 'NI', 'America/Managua', 'Live'),
(276, 'NL', 'Europe/Amsterdam', 'Live'),
(277, 'NO', 'Europe/Oslo', 'Live'),
(278, 'NP', 'Asia/Kathmandu', 'Live'),
(279, 'NR', 'Pacific/Nauru', 'Live'),
(280, 'NU', 'Pacific/Niue', 'Live'),
(281, 'NZ', 'Pacific/Auckland', 'Live'),
(282, 'NZ', 'Pacific/Chatham', 'Live'),
(283, 'OM', 'Asia/Muscat', 'Live'),
(284, 'PA', 'America/Panama', 'Live'),
(285, 'PE', 'America/Lima', 'Live'),
(286, 'PF', 'Pacific/Tahiti', 'Live'),
(287, 'PF', 'Pacific/Marquesas', 'Live'),
(288, 'PF', 'Pacific/Gambier', 'Live'),
(289, 'PG', 'Pacific/Port_Moresby', 'Live'),
(290, 'PG', 'Pacific/Bougainville', 'Live'),
(291, 'PH', 'Asia/Manila', 'Live'),
(292, 'PK', 'Asia/Karachi', 'Live'),
(293, 'PL', 'Europe/Warsaw', 'Live'),
(294, 'PM', 'America/Miquelon', 'Live'),
(295, 'PN', 'Pacific/Pitcairn', 'Live'),
(296, 'PR', 'America/Puerto_Rico', 'Live'),
(297, 'PS', 'Asia/Gaza', 'Live'),
(298, 'PS', 'Asia/Hebron', 'Live'),
(299, 'PT', 'Europe/Lisbon', 'Live'),
(300, 'PT', 'Atlantic/Madeira', 'Live'),
(301, 'PT', 'Atlantic/Azores', 'Live'),
(302, 'PW', 'Pacific/Palau', 'Live'),
(303, 'PY', 'America/Asuncion', 'Live'),
(304, 'QA', 'Asia/Qatar', 'Live'),
(305, 'RE', 'Indian/Reunion', 'Live'),
(306, 'RO', 'Europe/Bucharest', 'Live'),
(307, 'RS', 'Europe/Belgrade', 'Live'),
(308, 'RU', 'Europe/Kaliningrad', 'Live'),
(309, 'RU', 'Europe/Moscow', 'Live'),
(310, 'RU', 'Europe/Simferopol', 'Live'),
(311, 'RU', 'Europe/Volgograd', 'Live'),
(312, 'RU', 'Europe/Kirov', 'Live'),
(313, 'RU', 'Europe/Astrakhan', 'Live'),
(314, 'RU', 'Europe/Saratov', 'Live'),
(315, 'RU', 'Europe/Ulyanovsk', 'Live'),
(316, 'RU', 'Europe/Samara', 'Live'),
(317, 'RU', 'Asia/Yekaterinburg', 'Live'),
(318, 'RU', 'Asia/Omsk', 'Live'),
(319, 'RU', 'Asia/Novosibirsk', 'Live'),
(320, 'RU', 'Asia/Barnaul', 'Live'),
(321, 'RU', 'Asia/Tomsk', 'Live'),
(322, 'RU', 'Asia/Novokuznetsk', 'Live'),
(323, 'RU', 'Asia/Krasnoyarsk', 'Live'),
(324, 'RU', 'Asia/Irkutsk', 'Live'),
(325, 'RU', 'Asia/Chita', 'Live'),
(326, 'RU', 'Asia/Yakutsk', 'Live'),
(327, 'RU', 'Asia/Khandyga', 'Live'),
(328, 'RU', 'Asia/Vladivostok', 'Live'),
(329, 'RU', 'Asia/Ust-Nera', 'Live'),
(330, 'RU', 'Asia/Magadan', 'Live'),
(331, 'RU', 'Asia/Sakhalin', 'Live'),
(332, 'RU', 'Asia/Srednekolymsk', 'Live'),
(333, 'RU', 'Asia/Kamchatka', 'Live'),
(334, 'RU', 'Asia/Anadyr', 'Live'),
(335, 'RW', 'Africa/Kigali', 'Live'),
(336, 'SA', 'Asia/Riyadh', 'Live'),
(337, 'SB', 'Pacific/Guadalcanal', 'Live'),
(338, 'SC', 'Indian/Mahe', 'Live'),
(339, 'SD', 'Africa/Khartoum', 'Live'),
(340, 'SE', 'Europe/Stockholm', 'Live'),
(341, 'SG', 'Asia/Singapore', 'Live'),
(342, 'SH', 'Atlantic/St_Helena', 'Live'),
(343, 'SI', 'Europe/Ljubljana', 'Live'),
(344, 'SJ', 'Arctic/Longyearbyen', 'Live'),
(345, 'SK', 'Europe/Bratislava', 'Live'),
(346, 'SL', 'Africa/Freetown', 'Live'),
(347, 'SM', 'Europe/San_Marino', 'Live'),
(348, 'SN', 'Africa/Dakar', 'Live'),
(349, 'SO', 'Africa/Mogadishu', 'Live'),
(350, 'SR', 'America/Paramaribo', 'Live'),
(351, 'SS', 'Africa/Juba', 'Live'),
(352, 'ST', 'Africa/Sao_Tome', 'Live'),
(353, 'SV', 'America/El_Salvador', 'Live'),
(354, 'SX', 'America/Lower_Princes', 'Live'),
(355, 'SY', 'Asia/Damascus', 'Live'),
(356, 'SZ', 'Africa/Mbabane', 'Live'),
(357, 'TC', 'America/Grand_Turk', 'Live'),
(358, 'TD', 'Africa/Ndjamena', 'Live'),
(359, 'TF', 'Indian/Kerguelen', 'Live'),
(360, 'TG', 'Africa/Lome', 'Live'),
(361, 'TH', 'Asia/Bangkok', 'Live'),
(362, 'TJ', 'Asia/Dushanbe', 'Live'),
(363, 'TK', 'Pacific/Fakaofo', 'Live'),
(364, 'TL', 'Asia/Dili', 'Live'),
(365, 'TM', 'Asia/Ashgabat', 'Live'),
(366, 'TN', 'Africa/Tunis', 'Live'),
(367, 'TO', 'Pacific/Tongatapu', 'Live'),
(368, 'TR', 'Europe/Istanbul', 'Live'),
(369, 'TT', 'America/Port_of_Spain', 'Live'),
(370, 'TV', 'Pacific/Funafuti', 'Live'),
(371, 'TW', 'Asia/Taipei', 'Live'),
(372, 'TZ', 'Africa/Dar_es_Salaam', 'Live'),
(373, 'UA', 'Europe/Kiev', 'Live'),
(374, 'UA', 'Europe/Uzhgorod', 'Live'),
(375, 'UA', 'Europe/Zaporozhye', 'Live'),
(376, 'UG', 'Africa/Kampala', 'Live'),
(377, 'UM', 'Pacific/Midway', 'Live'),
(378, 'UM', 'Pacific/Wake', 'Live'),
(379, 'US', 'America/New_York', 'Live'),
(380, 'US', 'America/Detroit', 'Live'),
(381, 'US', 'America/Kentucky/Louisville', 'Live'),
(382, 'US', 'America/Kentucky/Monticello', 'Live'),
(383, 'US', 'America/Indiana/Indianapolis', 'Live'),
(384, 'US', 'America/Indiana/Vincennes', 'Live'),
(385, 'US', 'America/Indiana/Winamac', 'Live'),
(386, 'US', 'America/Indiana/Marengo', 'Live'),
(387, 'US', 'America/Indiana/Petersburg', 'Live'),
(388, 'US', 'America/Indiana/Vevay', 'Live'),
(389, 'US', 'America/Chicago', 'Live'),
(390, 'US', 'America/Indiana/Tell_City', 'Live'),
(391, 'US', 'America/Indiana/Knox', 'Live'),
(392, 'US', 'America/Menominee', 'Live'),
(393, 'US', 'America/North_Dakota/Center', 'Live'),
(394, 'US', 'America/North_Dakota/New_Salem', 'Live'),
(395, 'US', 'America/North_Dakota/Beulah', 'Live'),
(396, 'US', 'America/Denver', 'Live'),
(397, 'US', 'America/Boise', 'Live'),
(398, 'US', 'America/Phoenix', 'Live'),
(399, 'US', 'America/Los_Angeles', 'Live'),
(400, 'US', 'America/Anchorage', 'Live'),
(401, 'US', 'America/Juneau', 'Live'),
(402, 'US', 'America/Sitka', 'Live'),
(403, 'US', 'America/Metlakatla', 'Live'),
(404, 'US', 'America/Yakutat', 'Live'),
(405, 'US', 'America/Nome', 'Live'),
(406, 'US', 'America/Adak', 'Live'),
(407, 'US', 'Pacific/Honolulu', 'Live'),
(408, 'UY', 'America/Montevideo', 'Live'),
(409, 'UZ', 'Asia/Samarkand', 'Live'),
(410, 'UZ', 'Asia/Tashkent', 'Live'),
(411, 'VA', 'Europe/Vatican', 'Live'),
(412, 'VC', 'America/St_Vincent', 'Live'),
(413, 'VE', 'America/Caracas', 'Live'),
(414, 'VG', 'America/Tortola', 'Live'),
(415, 'VI', 'America/St_Thomas', 'Live'),
(416, 'VN', 'Asia/Ho_Chi_Minh', 'Live'),
(417, 'VU', 'Pacific/Efate', 'Live'),
(418, 'WF', 'Pacific/Wallis', 'Live'),
(419, 'WS', 'Pacific/Apia', 'Live'),
(420, 'YE', 'Asia/Aden', 'Live'),
(421, 'YT', 'Indian/Mayotte', 'Live'),
(422, 'ZA', 'Africa/Johannesburg', 'Live'),
(423, 'ZM', 'Africa/Lusaka', 'Live'),
(424, 'ZW', 'Africa/Harare', 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_transfer`
--

CREATE TABLE `tbl_transfer` (
  `id` int(11) NOT NULL,
  `transfer_type` int(11) NOT NULL DEFAULT 1,
  `reference_no` varchar(50) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `received_date` varchar(30) DEFAULT NULL,
  `note_for_sender` varchar(300) DEFAULT NULL,
  `note_for_receiver` varchar(300) DEFAULT NULL,
  `from_outlet_id` int(11) DEFAULT NULL,
  `to_outlet_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_transfer_items`
--

CREATE TABLE `tbl_transfer_items` (
  `id` int(11) NOT NULL,
  `status` int(11) DEFAULT NULL,
  `ingredient_id` int(11) DEFAULT NULL,
  `quantity_amount` float DEFAULT NULL,
  `transfer_id` int(11) DEFAULT NULL,
  `item_type` varchar(55) NOT NULL,
  `expiry_imei_serial` varchar(255) DEFAULT NULL,
  `from_outlet_id` int(11) DEFAULT NULL,
  `to_outlet_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_units`
--

CREATE TABLE `tbl_units` (
  `id` int(11) NOT NULL,
  `unit_name` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `tbl_units`
--

INSERT INTO `tbl_units` (`id`, `unit_name`, `description`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'PCS', '', '2023-11-29 18:10:29', 1, 1, 'Live'),
(2, 'Packet', '', '2023-11-29 18:10:43', 1, 1, 'Live'),
(3, 'Litter', '', '2023-11-29 18:10:55', 1, 1, 'Live'),
(4, 'Ton', '', '2023-11-29 18:10:59', 1, 1, 'Live'),
(5, 'Caret', '', '2023-11-29 18:11:47', 1, 1, 'Live'),
(6, 'KG', '', '2023-11-29 19:31:46', 1, 1, 'Live'),
(7, 'Sachets', '', '2024-02-13 11:56:15', 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_user_access`
--

CREATE TABLE `tbl_user_access` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `access_parent_id` int(11) DEFAULT NULL,
  `access_child_id` int(11) DEFAULT NULL,
  `del_status` varchar(11) NOT NULL DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_variations`
--

CREATE TABLE `tbl_variations` (
  `id` int(11) NOT NULL,
  `variation_name` varchar(255) DEFAULT NULL,
  `variation_value` text DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) DEFAULT 0,
  `del_status` varchar(10) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_variations`
--

INSERT INTO `tbl_variations` (`id`, `variation_name`, `variation_value`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Color', '[\"White\",\"Black\",\"Blue\",\"Green\"]', '2023-07-30 21:22:42', 1, 1, 'Live'),
(2, 'Size', '[\"S\",\"M\",\"L\",\"XL\"]', '2023-07-30 21:22:42', 1, 1, 'Live');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_warranties`
--

CREATE TABLE `tbl_warranties` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `customer_name` varchar(50) DEFAULT NULL,
  `customer_mobile` varchar(30) DEFAULT NULL,
  `product_name` varchar(100) DEFAULT NULL,
  `product_serial_no` varchar(100) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `receiving_date` varchar(55) DEFAULT NULL,
  `delivery_date` varchar(55) DEFAULT NULL,
  `current_status` varchar(25) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `outlet_id` int(11) DEFAULT NULL,
  `company_id` int(10) UNSIGNED DEFAULT NULL,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Structure for view `tbl_stock_detail`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `tbl_stock_detail`  AS   (select `op`.`item_id` AS `item_id`,`op`.`item_type` AS `item_type`,`op`.`item_description` AS `expiry_imei_serial`,`op`.`stock_quantity` AS `stock_quantity`,`op`.`outlet_id` AS `outlet_id`,1 AS `type`,'Opening' AS `description` from `tbl_set_opening_stocks` `op` where `op`.`del_status` = 'Live') union (select `pu`.`item_id` AS `item_id`,`pu`.`item_type` AS `item_type`,`pu`.`expiry_imei_serial` AS `expiry_imei_serial`,`pu`.`quantity_amount` AS `stock_quantity`,`pu`.`outlet_id` AS `outlet_id`,1 AS `type`,'Purchase' AS `description` from `tbl_purchase_details` `pu` where `pu`.`del_status` = 'Live') union (select `pr`.`item_id` AS `item_id`,`pr`.`item_type` AS `item_type`,`pr`.`expiry_imei_serial` AS `expiry_imei_serial`,`pr`.`return_quantity_amount` AS `stock_quantity`,`pr`.`outlet_id` AS `outlet_id`,2 AS `type`,'Purchase Return' AS `description` from `tbl_purchase_return_details` `pr` where `pr`.`del_status` = 'Live') union (select `pri`.`item_id` AS `item_id`,`pri`.`item_type` AS `item_type`,`pri`.`expiry_imei_serial_in` AS `expiry_imei_serial`,`pri`.`return_quantity_amount` AS `stock_quantity`,`pri`.`outlet_id` AS `outlet_id`,1 AS `type`,'Purchase Return In' AS `description` from `tbl_purchase_return_details` `pri` where `pri`.`return_status` = 'taken_by_sup_pro_returned' and `pri`.`del_status` = 'Live') union (select `i_s`.`item_id` AS `item_id`,`i_s`.`item_type` AS `item_type`,`i_s`.`expiry_imei_serial` AS `expiry_imei_serial`,`i_s`.`quantity` AS `stock_quantity`,`i_s`.`outlet_id` AS `outlet_id`,2 AS `type`,'Installment Sale' AS `description` from `tbl_installments` `i_s` where `i_s`.`del_status` = 'Live') union (select `s`.`food_menu_id` AS `item_id`,`s`.`item_type` AS `item_type`,'' AS `expiry_imei_serial`,`s`.`qty` AS `stock_quantity`,`s`.`outlet_id` AS `outlet_id`,2 AS `type`,'Sale' AS `description` from `tbl_sales_details` `s` where `s`.`del_status` = 'Live') union (select `s2`.`food_menu_id` AS `item_id`,`s2`.`item_type` AS `item_type`,`s2`.`expiry_imei_serial` AS `expiry_imei_serial`,0 AS `stock_quantity`,`s2`.`outlet_id` AS `outlet_id`,2 AS `type`,'Sale IMEI' AS `description` from `tbl_sales_details` `s2` where !(`s2`.`expiry_imei_serial` in (select `sr2`.`expiry_imei_serial` from `tbl_sale_return_details` `sr2` where `sr2`.`item_id` = `s2`.`food_menu_id` and `s2`.`outlet_id` = `sr2`.`outlet_id`)) and `s2`.`del_status` = 'Live') union (select `sr`.`item_id` AS `item_id`,`sr`.`item_type` AS `item_type`,'' AS `expiry_imei_serial`,`sr`.`return_quantity_amount` AS `stock_quantity`,`sr`.`outlet_id` AS `outlet_id`,1 AS `type`,'Sale Return' AS `description` from `tbl_sale_return_details` `sr` where `sr`.`del_status` = 'Live') union (select `d`.`item_id` AS `item_id`,`d`.`item_type` AS `item_type`,`d`.`expiry_imei_serial` AS `expiry_imei_serial`,`d`.`damage_quantity` AS `stock_quantity`,`d`.`outlet_id` AS `outlet_id`,2 AS `type`,'Damage' AS `description` from `tbl_damage_details` `d` where `d`.`del_status` = 'Live') union (select `tou`.`ingredient_id` AS `item_id`,`tou`.`item_type` AS `item_type`,`tou`.`expiry_imei_serial` AS `expiry_imei_serial`,`tou`.`quantity_amount` AS `stock_quantity`,`tou`.`outlet_id` AS `outlet_id`,2 AS `type`,'Transfer Out' AS `description` from `tbl_transfer_items` `tou` where `tou`.`from_outlet_id` = `tou`.`outlet_id` and `tou`.`del_status` = 'Live') union (select `ti`.`ingredient_id` AS `item_id`,`ti`.`item_type` AS `item_type`,`ti`.`expiry_imei_serial` AS `expiry_imei_serial`,`ti`.`quantity_amount` AS `stock_quantity`,`ti`.`to_outlet_id` AS `outlet_id`,1 AS `type`,'Transfer In' AS `description` from `tbl_transfer_items` `ti` where `ti`.`to_outlet_id` <> `ti`.`outlet_id` and `ti`.`del_status` = 'Live')  ;

-- --------------------------------------------------------

--
-- Structure for view `tbl_stock_detail2`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `tbl_stock_detail2`  AS   (select `op`.`item_id` AS `item_id`,`op`.`item_type` AS `item_type`,`op`.`item_description` AS `expiry_imei_serial`,`op`.`stock_quantity` AS `stock_quantity`,`op`.`outlet_id` AS `outlet_id`,1 AS `type`,'Opening' AS `description` from `tbl_set_opening_stocks` `op` where `op`.`del_status` = 'Live') union (select `pu`.`item_id` AS `item_id`,`pu`.`item_type` AS `item_type`,`pu`.`expiry_imei_serial` AS `expiry_imei_serial`,`pu`.`quantity_amount` * `i`.`conversion_rate` AS `stock_quantity`,`pu`.`outlet_id` AS `outlet_id`,1 AS `type`,'Purchase' AS `description` from (`tbl_purchase_details` `pu` join `tbl_items` `i`) where `pu`.`del_status` = 'Live' and `pu`.`item_id` = `i`.`id`) union (select `pr`.`item_id` AS `item_id`,`pr`.`item_type` AS `item_type`,`pr`.`expiry_imei_serial` AS `expiry_imei_serial`,-`pr`.`return_quantity_amount` AS `stock_quantity`,`pr`.`outlet_id` AS `outlet_id`,2 AS `type`,'Purchase Return' AS `description` from `tbl_purchase_return_details` `pr` where `pr`.`del_status` = 'Live') union (select `pri`.`item_id` AS `item_id`,`pri`.`item_type` AS `item_type`,`pri`.`expiry_imei_serial_in` AS `expiry_imei_serial`,`pri`.`return_quantity_amount` AS `stock_quantity`,`pri`.`outlet_id` AS `outlet_id`,1 AS `type`,'Purchase Return In' AS `description` from `tbl_purchase_return_details` `pri` where `pri`.`return_status` = 'taken_by_sup_pro_returned' and `pri`.`del_status` = 'Live') union (select `s`.`food_menu_id` AS `item_id`,`s`.`item_type` AS `item_type`,`s`.`expiry_imei_serial` AS `expiry_imei_serial`,-`s`.`qty` AS `stock_quantity`,`s`.`outlet_id` AS `outlet_id`,2 AS `type`,'Sale' AS `description` from `tbl_sales_details` `s` where `s`.`del_status` = 'Live') union (select `sr`.`item_id` AS `item_id`,`sr`.`item_type` AS `item_type`,`sr`.`expiry_imei_serial` AS `expiry_imei_serial`,`sr`.`return_quantity_amount` AS `stock_quantity`,`sr`.`outlet_id` AS `outlet_id`,1 AS `type`,'Sale Return' AS `description` from `tbl_sale_return_details` `sr` where `sr`.`del_status` = 'Live') union (select `d`.`item_id` AS `item_id`,`d`.`item_type` AS `item_type`,`d`.`expiry_imei_serial` AS `expiry_imei_serial`,-`d`.`damage_quantity` AS `stock_quantity`,`d`.`outlet_id` AS `outlet_id`,2 AS `type`,'Damage' AS `description` from `tbl_damage_details` `d` where `d`.`del_status` = 'Live') union (select `tou`.`ingredient_id` AS `item_id`,`tou`.`item_type` AS `item_type`,`tou`.`expiry_imei_serial` AS `expiry_imei_serial`,-`tou`.`quantity_amount` AS `stock_quantity`,`tou`.`outlet_id` AS `outlet_id`,2 AS `type`,'Transfer Out' AS `description` from `tbl_transfer_items` `tou` where `tou`.`from_outlet_id` = `tou`.`outlet_id` and `tou`.`del_status` = 'Live') union (select `ti`.`ingredient_id` AS `item_id`,`ti`.`item_type` AS `item_type`,`ti`.`expiry_imei_serial` AS `expiry_imei_serial`,`ti`.`quantity_amount` AS `stock_quantity`,`ti`.`to_outlet_id` AS `outlet_id`,1 AS `type`,'Transfer In' AS `description` from `tbl_transfer_items` `ti` where `ti`.`to_outlet_id` <> `ti`.`outlet_id` and `ti`.`del_status` = 'Live')  ;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_access`
--
ALTER TABLE `tbl_access`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_attendance`
--
ALTER TABLE `tbl_attendance`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_brands`
--
ALTER TABLE `tbl_brands`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_companies`
--
ALTER TABLE `tbl_companies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_customers`
--
ALTER TABLE `tbl_customers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_customer_due_receives`
--
ALTER TABLE `tbl_customer_due_receives`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_customer_groups`
--
ALTER TABLE `tbl_customer_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_damages`
--
ALTER TABLE `tbl_damages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_damage_details`
--
ALTER TABLE `tbl_damage_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_denominations`
--
ALTER TABLE `tbl_denominations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_deposits`
--
ALTER TABLE `tbl_deposits`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_expenses`
--
ALTER TABLE `tbl_expenses`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_expense_items`
--
ALTER TABLE `tbl_expense_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_holds`
--
ALTER TABLE `tbl_holds`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_holds_details`
--
ALTER TABLE `tbl_holds_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_incomes`
--
ALTER TABLE `tbl_incomes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_income_items`
--
ALTER TABLE `tbl_income_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_installments`
--
ALTER TABLE `tbl_installments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_installment_items`
--
ALTER TABLE `tbl_installment_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_items`
--
ALTER TABLE `tbl_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_item_categories`
--
ALTER TABLE `tbl_item_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_main_modules`
--
ALTER TABLE `tbl_main_modules`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_notifications`
--
ALTER TABLE `tbl_notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_outlets`
--
ALTER TABLE `tbl_outlets`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_payment_methods`
--
ALTER TABLE `tbl_payment_methods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_printers`
--
ALTER TABLE `tbl_printers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_promotions`
--
ALTER TABLE `tbl_promotions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_purchase`
--
ALTER TABLE `tbl_purchase`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_purchase_details`
--
ALTER TABLE `tbl_purchase_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_purchase_payments`
--
ALTER TABLE `tbl_purchase_payments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_purchase_return`
--
ALTER TABLE `tbl_purchase_return`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_purchase_return_details`
--
ALTER TABLE `tbl_purchase_return_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_quotations`
--
ALTER TABLE `tbl_quotations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_quotation_details`
--
ALTER TABLE `tbl_quotation_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_register`
--
ALTER TABLE `tbl_register`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_salaries`
--
ALTER TABLE `tbl_salaries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_sales`
--
ALTER TABLE `tbl_sales`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_sales_details`
--
ALTER TABLE `tbl_sales_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_sale_payments`
--
ALTER TABLE `tbl_sale_payments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_sale_return`
--
ALTER TABLE `tbl_sale_return`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_sale_return_details`
--
ALTER TABLE `tbl_sale_return_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_servicing`
--
ALTER TABLE `tbl_servicing`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_sessions`
--
ALTER TABLE `tbl_sessions`
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

--
-- Indexes for table `tbl_set_opening_stocks`
--
ALTER TABLE `tbl_set_opening_stocks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_suppliers`
--
ALTER TABLE `tbl_suppliers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_supplier_payments`
--
ALTER TABLE `tbl_supplier_payments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_time_zone`
--
ALTER TABLE `tbl_time_zone`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_transfer`
--
ALTER TABLE `tbl_transfer`
  ADD PRIMARY KEY (`id`) USING BTREE;

--
-- Indexes for table `tbl_transfer_items`
--
ALTER TABLE `tbl_transfer_items`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_units`
--
ALTER TABLE `tbl_units`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_user_access`
--
ALTER TABLE `tbl_user_access`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_variations`
--
ALTER TABLE `tbl_variations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_warranties`
--
ALTER TABLE `tbl_warranties`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_access`
--
ALTER TABLE `tbl_access`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=156;

--
-- AUTO_INCREMENT for table `tbl_attendance`
--
ALTER TABLE `tbl_attendance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_brands`
--
ALTER TABLE `tbl_brands`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `tbl_companies`
--
ALTER TABLE `tbl_companies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_customers`
--
ALTER TABLE `tbl_customers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- AUTO_INCREMENT for table `tbl_customer_due_receives`
--
ALTER TABLE `tbl_customer_due_receives`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_customer_groups`
--
ALTER TABLE `tbl_customer_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_damages`
--
ALTER TABLE `tbl_damages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_damage_details`
--
ALTER TABLE `tbl_damage_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_denominations`
--
ALTER TABLE `tbl_denominations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_deposits`
--
ALTER TABLE `tbl_deposits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_expenses`
--
ALTER TABLE `tbl_expenses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_expense_items`
--
ALTER TABLE `tbl_expense_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_holds`
--
ALTER TABLE `tbl_holds`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_holds_details`
--
ALTER TABLE `tbl_holds_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_incomes`
--
ALTER TABLE `tbl_incomes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_income_items`
--
ALTER TABLE `tbl_income_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_installments`
--
ALTER TABLE `tbl_installments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_installment_items`
--
ALTER TABLE `tbl_installment_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_items`
--
ALTER TABLE `tbl_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `tbl_item_categories`
--
ALTER TABLE `tbl_item_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `tbl_main_modules`
--
ALTER TABLE `tbl_main_modules`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_notifications`
--
ALTER TABLE `tbl_notifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_outlets`
--
ALTER TABLE `tbl_outlets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_payment_methods`
--
ALTER TABLE `tbl_payment_methods`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_printers`
--
ALTER TABLE `tbl_printers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_promotions`
--
ALTER TABLE `tbl_promotions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_purchase`
--
ALTER TABLE `tbl_purchase`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_purchase_details`
--
ALTER TABLE `tbl_purchase_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_purchase_payments`
--
ALTER TABLE `tbl_purchase_payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_purchase_return`
--
ALTER TABLE `tbl_purchase_return`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_purchase_return_details`
--
ALTER TABLE `tbl_purchase_return_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_quotations`
--
ALTER TABLE `tbl_quotations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_quotation_details`
--
ALTER TABLE `tbl_quotation_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_register`
--
ALTER TABLE `tbl_register`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_salaries`
--
ALTER TABLE `tbl_salaries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_sales`
--
ALTER TABLE `tbl_sales`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_sales_details`
--
ALTER TABLE `tbl_sales_details`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_sale_payments`
--
ALTER TABLE `tbl_sale_payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_sale_return`
--
ALTER TABLE `tbl_sale_return`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_sale_return_details`
--
ALTER TABLE `tbl_sale_return_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_servicing`
--
ALTER TABLE `tbl_servicing`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_set_opening_stocks`
--
ALTER TABLE `tbl_set_opening_stocks`
  MODIFY `id` bigint(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=98;

--
-- AUTO_INCREMENT for table `tbl_suppliers`
--
ALTER TABLE `tbl_suppliers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_supplier_payments`
--
ALTER TABLE `tbl_supplier_payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_time_zone`
--
ALTER TABLE `tbl_time_zone`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=425;

--
-- AUTO_INCREMENT for table `tbl_transfer`
--
ALTER TABLE `tbl_transfer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_transfer_items`
--
ALTER TABLE `tbl_transfer_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_units`
--
ALTER TABLE `tbl_units`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_user_access`
--
ALTER TABLE `tbl_user_access`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_variations`
--
ALTER TABLE `tbl_variations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_warranties`
--
ALTER TABLE `tbl_warranties`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

