-- 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` bigint(55) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `sale_no` varchar(55) NOT NULL DEFAULT '000000',
  `total_items` int(11) DEFAULT NULL,
  `sub_total` float DEFAULT NULL,
  `paid_amount` float 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,
  `rounding` float DEFAULT NULL,
  `total_payable` float DEFAULT NULL,
  `close_time` varchar(30) DEFAULT NULL,
  `total_item_discount_amount` float DEFAULT NULL,
  `sub_total_with_discount` float DEFAULT NULL,
  `sub_total_discount_amount` float DEFAULT NULL,
  `total_discount_amount` float DEFAULT NULL,
  `delivery_charge` float DEFAULT 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',
  `delivery_partner_id` int(11) DEFAULT NULL,
  `delivery_status` varchar(55) DEFAULT NULL COMMENT '1-Sent,2-Returned,3-Cash Received',
  `due_date_time` varchar(55) DEFAULT NULL,
  `account_note` varchar(100) DEFAULT NULL,
  `account_type` varchar(55) DEFAULT NULL,
  `sale_vat_objects` text DEFAULT NULL,
  `random_code` varchar(55) 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`, `rounding`, `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`, `delivery_partner_id`, `delivery_status`, `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, 84, 0, 'INV000001', 1, 44403, 46179, 0, 0, NULL, NULL, 1776, 0, 46179, '19:24:34', 0, 44403, 0, 0, 0, 'delivery', '', 'plain', '2024-05-25', '2024-05-25 19:24:33', '19:24:33', 46179, 1, NULL, 'Cash Received', NULL, '', 'Bank_Account', '[{\"tax_field_id\":\"\",\"tax_field_type\":\"CGST\",\"tax_field_amount\":\"444.0\"},{\"tax_field_id\":\"\",\"tax_field_type\":\"SGST\",\"tax_field_amount\":\"444.0\"},{\"tax_field_id\":\"\",\"tax_field_type\":\"IGST\",\"tax_field_amount\":\"444.0\"},{\"tax_field_id\":\"\",\"tax_field_type\":\"VAT\",\"tax_field_amount\":\"444.0\"}]', 'W9BJNNmMWaKpY4M', '', '2024-05-25 19:24:33', '2024-05-25 19:24:33', 1, 4, 1, 'Live');

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

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

CREATE TABLE `tbl_sales_details` (
  `id` bigint(55) 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` float DEFAULT NULL,
  `item_type` varchar(55) 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,
  `delivery_status` varchar(55) DEFAULT NULL COMMENT '1-Sent,2-Returned,3-Cash Received',
  `loyalty_point_earn` float 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`, `delivery_status`, `loyalty_point_earn`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(1, 294, 1, 44403, 44403, 44403, 26829, NULL, '[{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"CGST\",\"tax_field_percentage\":\"1\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"SGST\",\"tax_field_percentage\":\"1\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"IGST\",\"tax_field_percentage\":\"1\"},{\"tax_field_id\":\"1\",\"tax_field_company_id\":\"1\",\"tax_field_name\":\"VAT\",\"tax_field_percentage\":\"1\"}]', '', 'plain', '', 0, 'Serial_Product', 'DELLU2422HE123459', 1, 'No', 0, 0, 'Cash Received', 20, 1, 4, 1, 'Live');

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

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

CREATE TABLE `tbl_sale_payments` (
  `id` int(11) NOT NULL,
  `date` varchar(30) 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,
  `usage_point` 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,
  `others_currency` 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`, `usage_point`, `sale_id`, `added_date`, `payment_name`, `payment_details`, `others_currency`, `outlet_id`, `user_id`, `company_id`, `del_status`) VALUES
(1, '2024-05-25', 1, NULL, NULL, NULL, 46179, NULL, 1, '2024-05-25 19:24:34', 'Bank', ',,', NULL, 4, 1, 1, 'Live');

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

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

CREATE TABLE `tbl_sale_return` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `total_return_amount` float DEFAULT NULL,
  `paid` float DEFAULT NULL,
  `due` 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 NULL,
  `unit_price_in_return` float DEFAULT NULL,
  `user_id` int(11) DEFAULT 0,
  `outlet_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;

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

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

CREATE TABLE `tbl_servicing` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `product_name` varchar(55) 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 DEFAULT NULL,
  `paid_amount` float DEFAULT NULL,
  `due_amount` float 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(11) 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
(1, 84, '2024-05-23', 'Galaxy S24 Ultra', '458607044466034', 'Chargin cable problem', '2024-05-23', '2024-06-01', 5000, 2500, 2500, 'Delivered', 1, '2024-05-23 19:37:45', 1, 4, 1, 1, 'Live'),
(2, 84, '2024-05-25', 'Dell Ultra Sharp', 'DELLU2422HE123459', 'display  problem', '2024-05-25', '2024-06-01', 3000, 2000, 1000, 'Delivered', 1, '2024-05-25 20:00:52', 1, 4, 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
('9hftchncilvuid2g9h1im09htbmidf2l', '103.14.130.185', 1716458928, 0x[encoded data, 20286 characters]),
('d88puoee85l2dsmfdtl3jbmc49k8us1r', '103.14.130.185', 1716459389, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('rmt1mlbhfrc9v52p9o89n2gar3cgkoeo', '103.14.130.185', 1716459772, 0x[encoded data, 20286 characters]),
('4109qtn6lgineh0f53ku0enmiopehcc9', '103.14.130.185', 1716460288, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('0u3qeak8ev9iskal15j4fskhoss565cc', '103.14.130.185', 1716460603, 0x[encoded data, 20286 characters]),
('54bks6k51qv0qmr9f1usrfrfaerkc088', '103.14.130.185', 1716461310, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('j4lboj5mvi5ghu76lcmoplpp8u0ej36e', '103.14.130.185', 1716461678, 0x[encoded data, 20286 characters]),
('kmh3s3p3lc61rcmvv4tf074k86hd73h6', '103.14.130.185', 1716462003, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('p5m9438oqgii4t7bbqtm57fbqrrrfrm2', '103.14.130.185', 1716462516, 0x[encoded data, 20286 characters]),
('vcgsretplngs2daekrq5v1is5bh6st38', '103.14.130.185', 1716462208, 0x5f5f63695f6c6173745f726567656e65726174657c693a313731363436323230383b564945575f5041525345527c623a313b),
('11ue1p1da3u267bhe06jji4uvv3rtfmv', '103.14.130.185', 1716462208, 0x5f5f63695f6c6173745f726567656e65726174657c693a313731363436323230383b564945575f5041525345527c623a313b),
('fqo8bshvjv1ge5pfsl8ocrmi36rs356d', '103.14.130.185', 1716462937, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('ct4uhmdv34ckpm5g37aqt7k5t3eibet4', '103.14.130.185', 1716463393, 0x[encoded data, 20286 characters]),
('ee9e2p71lotnrohuknqibt9ug839j99f', '103.14.130.185', 1716464076, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('jffv7fkie7s7aucdfp5uq45js03jl37p', '103.14.130.185', 1716464812, 0x[encoded data, 20286 characters]),
('5qbf7ad9khv7j7vjrk4ic4l09f2in8j4', '202.134.10.142', 1716465114, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('sjnirnldqspujkt7eoredj3l2et32a3a', '103.14.130.185', 1716465544, 0x[encoded data, 20286 characters]),
('jv0agg2elt92khug0s9au088f0k16v4o', '103.14.130.185', 1716465274, 0x5f5f63695f6c6173745f726567656e65726174657c693a313731363436353237343b564945575f5041525345527c623a313b),
('evglna2qs923mp2j9rh9mkb71b0pk3e2', '103.14.130.185', 1716465274, 0x5f5f63695f6c6173745f726567656e65726174657c693a313731363436353237343b564945575f5041525345527c623a313b),
('5pch0kctcdlsv3nhff4hr6mijriakjsj', '103.14.130.185', 1716465952, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('1vqll8pv2pg8te34j8a0ner9qbsu2s40', '103.14.130.185', 1716466255, 0x[encoded data, 20286 characters]),
('npk48p5gd4u7retf2592ef8pt21qlkf0', '103.14.130.185', 1716466577, 0x[encoded data, 20286 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('raaumpqsvjrgug2l4tnm30dvbevktams', '103.14.130.185', 1716466903, 0x[encoded data, 20286 characters]),
('2quc3b6edib9ao086n8ms7ajqd2741pb', '103.14.130.185', 1716467248, 0x[encoded data, 20286 characters]);
