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

START TRANSACTION;



--
-- Database: `off_pos last update`
--

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

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

CREATE TABLE `tbl_access` (
  `id` int(11) NOT NULL,
  `module_name` varchar(55) CHARACTER SET utf32 COLLATE utf32_general_ci DEFAULT NULL,
  `function_name` varchar(55) 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) DEFAULT NULL,
  `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;

--
-- Dumping data for table `tbl_access`
--

INSERT INTO `tbl_access` (`id`, `module_name`, `function_name`, `label_name`, `parent_id`, `main_module_id`, `del_status`) VALUES
(1, 'Setting', NULL, 'Setting', NULL, 1, 'Live'),
(2, '', 'edit', 'Edit Setting', 1, NULL, 'Live'),
(3, 'Denomination', NULL, 'Denomination', NULL, 1, 'Live'),
(4, '', 'add', 'Add Denomination', 3, NULL, 'Live'),
(5, '', 'edit', 'Edit Denomination', 3, NULL, 'Live'),
(6, '', 'delete', 'Delete Denomination', 3, NULL, 'Live'),
(7, '', 'list', 'List Denomination', 3, NULL, 'Live'),
(8, 'Tax Setting', NULL, 'Tax Setting', NULL, 1, 'Live'),
(9, '', 'edit', 'Edit Tax', 8, NULL, 'Live'),
(10, 'Email Setting', NULL, 'Email Setting', NULL, 1, 'Live'),
(11, '', 'edit', 'Edit Email Setting', 10, NULL, 'Live'),
(12, 'SMS Setting', NULL, 'SMS Setting', NULL, 1, 'Live'),
(13, '', 'edit', 'Edit SMS Setting', 12, NULL, 'Live'),
(14, 'Printer Setup', NULL, 'Printer Setup', NULL, 1, 'Live'),
(15, '', 'add', 'Add Printer', 14, NULL, 'Live'),
(16, '', 'edit', 'Edit Pinter', 14, NULL, 'Live'),
(17, '', 'delete', 'Delete Printer', 14, NULL, 'Live'),
(18, '', 'list', 'List Printer', 14, NULL, 'Live'),
(19, 'Print Server Configuration', NULL, 'Print Server Configuration', NULL, 1, 'Live'),
(20, '', 'edit', 'Edit Print Server Configuration', 19, NULL, 'Live'),
(21, 'Assign Printer', NULL, 'Assign Printer', NULL, 1, 'Live'),
(22, '', 'edit', 'Edit Assign Printer', 21, NULL, 'Live'),
(23, 'White Label', NULL, 'White Label', NULL, 1, 'Live'),
(24, '', 'edit', 'Edit White Label', 23, NULL, 'Live'),
(25, 'Outlet', NULL, 'Outlet', NULL, 2, 'Live'),
(26, '', 'add', 'Add Outlet', 25, NULL, 'Live'),
(27, '', 'edit', 'Edit Outlet', 25, NULL, 'Live'),
(28, '', 'delete', 'Delete Outlet', 25, NULL, 'Live'),
(29, '', 'list', 'List Outlet', 25, NULL, 'Live'),
(30, 'Dashboard', NULL, 'Dashboard', NULL, 3, 'Live'),
(31, '', 'view', 'View Dashboard', 30, NULL, 'Live'),
(32, 'Fixed Asset Item', NULL, 'Fixed Asset Item', NULL, 4, 'Live'),
(33, '', 'add', 'Add Item', 32, NULL, 'Live'),
(34, '', 'edit', 'Edit Item', 32, NULL, 'Live'),
(35, '', 'delete', 'Delete Item', 32, NULL, 'Live'),
(36, '', 'list', 'List Item', 32, NULL, 'Live'),
(37, 'Fixed Asset Stock', NULL, 'Fixed Asset Stock', NULL, 4, 'Live'),
(38, '', 'add', 'Add Stock In', 37, NULL, 'Live'),
(39, '', 'edit', 'Edit Stock In', 37, NULL, 'Live'),
(40, '', 'delete', 'Delete Stock In', 37, NULL, 'Live'),
(41, '', 'list', 'List Stock In', 37, NULL, 'Live'),
(42, 'Fixed Asset Stock Out', NULL, 'Fixed Asset Stock Out', NULL, 4, 'Live'),
(43, '', 'add', 'Add Stock Out', 42, NULL, 'Live'),
(44, '', 'edit', 'Edit Stock Out', 42, NULL, 'Live'),
(45, '', 'delete', 'Delete Stock Out', 42, NULL, 'Live'),
(46, '', 'list', 'List Stock Out', 42, NULL, 'Live'),
(47, 'Fixed Asset Stock', NULL, 'Fixed Asset Stock', NULL, 4, 'Live'),
(48, '', 'view', 'View Stock', 47, NULL, 'Live'),
(49, 'Items', NULL, 'Items', NULL, 5, 'Live'),
(50, '', 'add', 'Add Item', 49, NULL, 'Live'),
(51, '', 'edit', 'Edit Item', 49, NULL, 'Live'),
(52, '', 'view', 'View Item', 49, NULL, 'Live'),
(53, '', 'delete', 'Delete Item', 49, NULL, 'Live'),
(54, '', 'list', 'List Item', 49, NULL, 'Live'),
(55, '', 'upload_item', 'Bulk Upload Item', 49, NULL, 'Live'),
(56, '', 'upload_photo', 'Bulk Upload Photo', 49, NULL, 'Live'),
(57, '', 'bulkdelete', 'Bulk Delete', 49, NULL, 'Live'),
(58, '', 'print_barcode', 'Print Barcode', 49, NULL, 'Live'),
(59, '', 'print_label', 'Print Label', 49, NULL, 'Live'),
(60, 'Item Category', NULL, 'Item Category', NULL, 5, 'Live'),
(61, '', 'add', 'Add Category', 60, NULL, 'Live'),
(62, '', 'edit', 'Edit Category', 60, NULL, 'Live'),
(63, '', 'delete', 'Delete Category', 60, NULL, 'Live'),
(64, '', 'list', 'List Category', 60, NULL, 'Live'),
(65, 'Unit', NULL, 'Unit', NULL, 5, 'Live'),
(66, '', 'add', 'Add Unit', 65, NULL, 'Live'),
(67, '', 'edit', 'Edit Unit', 65, NULL, 'Live'),
(68, '', 'delete', 'Delete Unit', 65, NULL, 'Live'),
(69, '', 'list', 'List Unit', 65, NULL, 'Live'),
(70, 'Variation Attribute', NULL, 'Variation Attribute', NULL, 5, 'Live'),
(71, '', 'add', 'Add Variation Attribute', 70, NULL, 'Live'),
(72, '', 'edit', 'Edit Variation Attribute', 70, NULL, 'Live'),
(73, '', 'delete', 'Delete Variation Attribute', 70, NULL, 'Live'),
(74, '', 'list', 'List Variation Attribute', 70, NULL, 'Live'),
(75, 'Servicing', NULL, 'Servicing', NULL, 6, 'Live'),
(76, '', 'add', 'Add Servicing', 75, NULL, 'Live'),
(77, '', 'edit', 'Edit Servicing', 75, NULL, 'Live'),
(78, '', 'delete', 'Delete Servicing', 75, NULL, 'Live'),
(79, '', 'list', 'List Servicing', 75, NULL, 'Live'),
(80, 'Warranty', NULL, 'Warranty', NULL, 6, 'Live'),
(81, '', 'add', 'Add Warranty Product', 80, NULL, 'Live'),
(82, '', 'edit', 'Edit Warranty Product', 80, NULL, 'Live'),
(83, '', 'delete', 'Delete Warranty Product', 80, NULL, 'Live'),
(84, '', 'list', 'List Warranty Product', 80, NULL, 'Live'),
(85, 'Warranty Checking', NULL, 'Warranty Checking', NULL, 6, 'Live'),
(86, '', 'filter', 'Warranty Checking', 85, NULL, 'Live'),
(87, 'Salary', NULL, 'Salary', NULL, 7, 'Live'),
(88, '', 'add', 'Add Salary', 87, NULL, 'Live'),
(89, '', 'edit', 'Edit Salary', 87, NULL, 'Live'),
(90, '', 'delete', 'Delete Salary', 87, NULL, 'Live'),
(91, '', 'list', 'List Salary', 87, NULL, 'Live'),
(92, '', 'print', 'Print Salary', 87, NULL, 'Live'),
(93, 'Installment Customer', NULL, 'Installment Customer', NULL, 8, 'Live'),
(94, '', 'add', 'Add Installment Customer', 93, NULL, 'Live'),
(95, '', 'edit', 'Edit Installment Customer', 93, NULL, 'Live'),
(96, '', 'view', 'View Installment Customer', 93, NULL, 'Live'),
(97, '', 'delete', 'Delete Installment Customer', 93, NULL, 'Live'),
(98, '', 'list', 'List Installment Customer', 93, NULL, 'Live'),
(99, '', 'sms_send', 'Send SMS To Due Customer', 93, NULL, 'Live'),
(100, 'Installment Sale', NULL, 'Installment Sale', NULL, 8, 'Live'),
(101, '', 'add', 'Add Installment Sale', 100, NULL, 'Live'),
(102, '', 'edit', 'Edit Installment Sale', 100, NULL, 'Live'),
(103, '', 'view', 'View Installment Sale', 100, NULL, 'Live'),
(104, '', 'delete', 'Delete Installment Sale', 100, NULL, 'Live'),
(105, '', 'list', 'List Installment Sale', 100, NULL, 'Live'),
(106, '', 'print', 'Print Installment Sale Invoice', 100, NULL, 'Live'),
(107, '', 'installment_collection', 'Installment Collection', 100, NULL, 'Live'),
(108, '', 'due_installment', 'Due Installment', 100, NULL, 'Live'),
(109, 'Purchase', NULL, 'Purchase', NULL, 9, 'Live'),
(110, '', 'add', 'Add Purchase', 109, NULL, 'Live'),
(111, '', 'edit', 'Edit Purchase', 109, NULL, 'Live'),
(112, '', 'view', 'View Purchase', 109, NULL, 'Live'),
(113, '', 'delete', 'Delete Purchase', 109, NULL, 'Live'),
(114, '', 'list', 'List Purchase', 109, NULL, 'Live'),
(115, '', 'print', 'Print Purchase Invoice', 109, NULL, 'Live'),
(116, '', 'print_barcode', 'Print Barcode Invoice', 109, NULL, 'Live'),
(117, 'Supplier', NULL, 'Supplier', NULL, 9, 'Live'),
(118, '', 'add', 'Add Supplier', 117, NULL, 'Live'),
(119, '', 'edit', 'Edit Supplier', 117, NULL, 'Live'),
(120, '', 'view', 'View Supplier', 117, NULL, 'Live'),
(121, '', 'delete', 'Delete Supplier', 117, NULL, 'Live'),
(122, '', 'list', 'List Supplier', 117, NULL, 'Live'),
(123, '', 'debit_supplier', 'Debit Supplier', 117, NULL, 'Live'),
(124, '', 'credit_supplier', 'Credit Supplier', 117, NULL, 'Live'),
(125, 'Transfer', NULL, 'Transfer', NULL, 9, 'Live'),
(126, '', 'add', 'Add Transfer', 125, NULL, 'Live'),
(127, '', 'edit', 'Edit Transfer', 125, NULL, 'Live'),
(128, '', 'view', 'View Transfer', 125, NULL, 'Live'),
(129, '', 'delete', 'Delete Transfer', 125, NULL, 'Live'),
(130, '', 'list', 'List Transfer', 125, NULL, 'Live'),
(131, '', 'status_change', 'Status Change', 125, NULL, 'Live'),
(132, '', 'challan_invoice', 'Challan Invoice', 125, NULL, 'Live'),
(133, 'Promotion', NULL, 'Promotion', NULL, 12, 'Live'),
(134, '', 'add', 'Add Promotion', 133, NULL, 'Live'),
(135, '', 'edit', 'Edit Promotion', 133, NULL, 'Live'),
(136, '', 'delete', 'Delete Promotion', 133, NULL, 'Live'),
(137, '', 'list', 'List Promotion', 133, NULL, 'Live'),
(138, 'Sale', NULL, 'Sale', NULL, 12, 'Live'),
(139, '', 'pos', 'POS', 138, NULL, 'Live'),
(140, '', 'add', 'Add Sale', 138, NULL, 'Live'),
(141, '', 'edit', 'Edit Sale', 138, NULL, 'Live'),
(142, '', 'delete', 'Delete Sale', 138, NULL, 'Live'),
(143, '', 'list', 'List Sale', 138, NULL, 'Live'),
(144, '', 'invoice', 'Print Sale Invoice', 138, NULL, 'Live'),
(145, '', 'challan', 'Print Challan', 138, NULL, 'Live'),
(146, '', 'delivery_status', 'Delivery Status', 138, NULL, 'Live'),
(147, 'Customer', NULL, 'Customer', NULL, 12, 'Live'),
(148, '', 'add', 'Add Customer', 147, NULL, 'Live'),
(149, '', 'edit', 'Edit Customer', 147, NULL, 'Live'),
(150, '', 'view', 'View Customer', 147, NULL, 'Live'),
(151, '', 'delete', 'Delete Customer', 147, NULL, 'Live'),
(152, '', 'list', 'List Customer', 147, NULL, 'Live'),
(153, '', 'bulk_upload', 'Bulk Customer Upload', 147, NULL, 'Live'),
(154, 'Customer Group', NULL, 'Customer Group', NULL, 12, 'Live'),
(155, '', 'add', 'Add Customer Group', 154, NULL, 'Live'),
(156, '', 'edit', 'Edit Customer Group', 154, NULL, 'Live'),
(157, '', 'delete', 'Delete Customer Group', 154, NULL, 'Live'),
(158, '', 'list', 'List Customer Group', 154, NULL, 'Live'),
(159, 'Delivery Partner', NULL, 'Delivery Partner', NULL, 12, 'Live'),
(160, '', 'add', 'Add Delivery Partner', 159, NULL, 'Live'),
(161, '', 'edit', 'Edit Delivery Partner', 159, NULL, 'Live'),
(162, '', 'delete', 'Delete Delivery Partner', 159, NULL, 'Live'),
(163, '', 'list', 'List Delivery Partner', 159, NULL, 'Live'),
(164, 'Stock', NULL, 'Stock', NULL, 14, 'Live'),
(165, '', 'view', 'View Stock', 164, NULL, 'Live'),
(166, 'Damage', NULL, 'Damage', NULL, 15, 'Live'),
(167, '', 'add', 'Add Damage', 166, NULL, 'Live'),
(168, '', 'edit', 'Edit Damage', 166, NULL, 'Live'),
(169, '', 'view', 'View Damage', 166, NULL, 'Live'),
(170, '', 'delete', 'Delete Damage', 166, NULL, 'Live'),
(171, '', 'list', 'List Damage', 166, NULL, 'Live'),
(172, 'Expense', NULL, 'Expense', NULL, 16, 'Live'),
(173, '', 'add', 'Add Expense', 172, NULL, 'Live'),
(174, '', 'edit', 'Edit Expense', 172, NULL, 'Live'),
(175, '', 'delete', 'Delete Expense', 172, NULL, 'Live'),
(176, '', 'list', 'List Expense', 172, NULL, 'Live'),
(177, 'Expense Category', NULL, 'Expense Category', NULL, 16, 'Live'),
(178, '', 'add', 'Add Expense Category', 177, NULL, 'Live'),
(179, '', 'edit', 'Edit Expense Category', 177, NULL, 'Live'),
(180, '', 'delete', 'Delete Expense Category', 177, NULL, 'Live'),
(181, '', 'list', 'List Expense Category', 177, NULL, 'Live'),
(182, 'Income', NULL, 'Income', NULL, 17, 'Live'),
(183, '', 'add', 'Add Income', 182, NULL, 'Live'),
(184, '', 'edit', 'Edit Income', 182, NULL, 'Live'),
(185, '', 'delete', 'Delete Income', 182, NULL, 'Live'),
(186, '', 'list', 'List Income', 182, NULL, 'Live'),
(187, 'Income Category', NULL, 'Income Category', NULL, 17, 'Live'),
(188, '', 'add', 'Add Income Category', 187, NULL, 'Live'),
(189, '', 'edit', 'Edit Income Category', 187, NULL, 'Live'),
(190, '', 'delete', 'Delete Income Category', 187, NULL, 'Live'),
(191, '', 'list', 'List Income Category', 187, NULL, 'Live'),
(192, 'Supplier Payment', NULL, 'Supplier Payment', NULL, 18, 'Live'),
(193, '', 'add', 'Add Supplier Payment', 192, NULL, 'Live'),
(194, '', 'edit', 'Edit Supplier Payment', 192, NULL, 'Live'),
(195, '', 'delete', 'Delete Supplier Payment', 192, NULL, 'Live'),
(196, '', 'list', 'List Supplier Payment', 192, NULL, 'Live'),
(197, '', 'receipt', 'Receipt Supplier Payment', 192, NULL, 'Live'),
(198, 'Customer Due Receive', NULL, 'Customer Due Receive', NULL, 19, 'Live'),
(199, '', 'add', 'Add Customer Due Receive', 198, NULL, 'Live'),
(200, '', 'edit', 'Edit Customer Due Receive', 198, NULL, 'Live'),
(201, '', 'delete', 'Delete Customer Due Receive', 198, NULL, 'Live'),
(202, '', 'list', 'List Customer Due Receive', 198, NULL, 'Live'),
(203, '', 'print', 'Print Customer Due Receive Invoice', 198, NULL, 'Live'),
(204, 'Sale Return', NULL, 'Sale Return', NULL, 20, 'Live'),
(205, '', 'add', 'Add Sale Return', 204, NULL, 'Live'),
(206, '', 'edit', 'Edit Sale Return', 204, NULL, 'Live'),
(207, '', 'view', 'View Sale Return', 204, NULL, 'Live'),
(208, '', 'delete', 'Delete Sale Return', 204, NULL, 'Live'),
(209, '', 'list', 'List Sale Return', 204, NULL, 'Live'),
(210, '', 'print', 'Print Sale Return Invoice', 204, NULL, 'Live'),
(211, 'Purchase Return', NULL, 'Purchase Return', NULL, 21, 'Live'),
(212, '', 'add', 'Add Purchase Return', 211, NULL, 'Live'),
(213, '', 'edit', 'Edit Purchase Return', 211, NULL, 'Live'),
(214, '', 'view', 'View Purchase Return', 211, NULL, 'Live'),
(215, '', 'delete', 'Delete Purchase Return', 211, NULL, 'Live'),
(216, '', 'list', 'List Purchase Return', 211, NULL, 'Live'),
(217, '', 'print', 'Print Purchase Return Invoice', 211, NULL, 'Live'),
(218, 'Accounting', NULL, 'Accounting', NULL, 22, 'Live'),
(219, '', 'add', 'Add Accounting', 218, NULL, 'Live'),
(220, '', 'edit', 'Edit Accounting', 218, NULL, 'Live'),
(221, '', 'delete', 'Delete Accounting', 218, NULL, 'Live'),
(222, '', 'list', 'List Accounting', 218, NULL, 'Live'),
(223, 'Deposit', NULL, 'Deposit', NULL, 22, 'Live'),
(224, '', 'add', 'Add Deposit', 223, NULL, 'Live'),
(225, '', 'edit', 'Edit Deposit', 223, NULL, 'Live'),
(226, '', 'delete', 'Delete Deposit', 223, NULL, 'Live'),
(227, '', 'list', 'List Deposit', 223, NULL, 'Live'),
(228, 'Balance Statement', NULL, 'Balance Statement', NULL, 22, 'Live'),
(229, '', 'list', 'Balance Statement', 228, NULL, 'Live'),
(230, 'Trial Balance', NULL, 'Trial Balance', NULL, 22, 'Live'),
(231, '', 'list', 'Trial Balance', 230, NULL, 'Live'),
(232, 'Balance Sheet', NULL, 'Balance Sheet', NULL, 22, 'Live'),
(233, '', 'list', 'Balance Sheet', 232, NULL, 'Live'),
(234, 'Attendance', NULL, 'Attendance', NULL, 23, 'Live'),
(235, '', 'add', 'Add Attendance', 234, NULL, 'Live'),
(236, '', 'edit', 'Edit Attendance', 234, NULL, 'Live'),
(237, '', 'delete', 'Delete Attendance', 234, NULL, 'Live'),
(238, '', 'list', 'List Attendance', 234, NULL, 'Live'),
(239, 'Quatation', NULL, 'Quatation', NULL, 24, 'Live'),
(240, '', 'add', 'Add Quatation', 239, NULL, 'Live'),
(241, '', 'edit', 'Edit Quatation', 239, NULL, 'Live'),
(242, '', 'view', 'View Quatation', 239, NULL, 'Live'),
(243, '', 'delete', 'Delete Quatation', 239, NULL, 'Live'),
(244, '', 'list', 'List Quatation', 239, NULL, 'Live'),
(245, '', 'copy', 'Copy Quatation', 239, NULL, 'Live'),
(246, '', 'print', 'Print Quatation', 239, NULL, 'Live'),
(247, 'Update Software', NULL, 'Update Software', NULL, 25, 'Live'),
(248, '', 'update', 'Update Software', 247, NULL, 'Live'),
(249, 'Report', NULL, 'Report', NULL, 26, 'Live'),
(250, '', 'register_report', 'Register Report', 249, NULL, 'Live'),
(251, '', 'customer_receive_report', 'Customer Receive Report', 249, NULL, 'Live'),
(252, '', 'daily_summary_report', 'Daily Summary Report', 249, NULL, 'Live'),
(253, '', 'sale_report', 'Sale Report', 249, NULL, 'Live'),
(254, '', 'service_sale_report', 'Service Sale Report', 249, NULL, 'Live'),
(255, '', 'employee_sale_report', 'Employee Sale Report', 249, NULL, 'Live'),
(256, '', 'product_sale_report', 'Product Sale Report', 249, NULL, 'Live'),
(257, '', 'detailed_sale_report', 'Detailed Sale Report', 249, NULL, 'Live'),
(258, '', 'stock_report', 'Stock Report', 249, NULL, 'Live'),
(259, '', 'low_stock_report', 'Low Stock Report', 249, NULL, 'Live'),
(260, '', 'profit_loss_report', 'Profit Loss Report', 249, NULL, 'Live'),
(261, '', 'product_profit_report', 'Product Profit Report', 249, NULL, 'Live'),
(262, '', 'attendance_report', 'Attendance Report', 249, NULL, 'Live'),
(263, '', 'supplier_ledger', 'Supplier Ledger', 249, NULL, 'Live'),
(264, '', 'supplier_balance_report', 'Supplier Balance Report', 249, NULL, 'Live'),
(265, '', 'customer_balance_report', 'Customer Balance Report', 249, NULL, 'Live'),
(266, '', 'customer_ledger', 'Customer Ledger', 249, NULL, 'Live'),
(267, '', 'purchase_report', 'Purchase Report', 249, NULL, 'Live'),
(268, '', 'product_purchase_report', 'Product Purchase Report', 249, NULL, 'Live'),
(269, '', 'expense_report', 'Expense Report', 249, NULL, 'Live'),
(270, '', 'income_report', 'Income Report', 249, NULL, 'Live'),
(271, '', 'salary_report', 'Salary Report', 249, NULL, 'Live'),
(272, '', 'purchase_return_report', 'Purchase Return Report', 249, NULL, 'Live'),
(273, '', 'sale_return_report', 'Sale Return Report', 249, NULL, 'Live'),
(274, '', 'damage_report', 'Damage Report', 249, NULL, 'Live'),
(275, '', 'installment_report', 'Installment Report', 249, NULL, 'Live'),
(276, '', 'installment_due_report', 'Installment Due Report', 249, NULL, 'Live'),
(277, '', 'tax_report', 'Tax Report', 249, NULL, 'Live'),
(278, '', 'servicing_report', 'Servicing Report', 249, NULL, 'Live'),
(279, '', 'item_tracing_report', 'Item Tracing Report', 249, NULL, 'Live'),
(280, '', 'price_history_report', 'Price History Report', 249, NULL, 'Live'),
(281, '', 'cash_flow_report', 'Cash Flow Report', 249, NULL, 'Live'),
(282, 'Roll', NULL, 'Roll', NULL, 27, 'Live'),
(283, '', 'add', 'Add Role', 282, NULL, 'Live'),
(284, '', 'edit', 'Edit Role', 282, NULL, 'Live'),
(285, '', 'delete', 'Delete Role', 282, NULL, 'Live'),
(286, '', 'list', 'List Role', 282, NULL, 'Live'),
(287, 'Employee', NULL, 'Employee', NULL, 27, 'Live'),
(288, '', 'add', 'Add Employee', 287, NULL, 'Live'),
(289, '', 'edit', 'Edit Employee', 287, NULL, 'Live'),
(290, '', 'delete', 'Delete Employee', 287, NULL, 'Live'),
(291, '', 'list', 'List Employee', 287, NULL, 'Live'),
(292, '', 'change_profile', 'Change Profile', 287, NULL, 'Live'),
(293, '', 'change_password', 'Change Password', 287, NULL, 'Live'),
(294, '', 'set_security_quatation', 'Set Security Quatation', 287, NULL, 'Live'),
(295, '', 'activate_user', 'Activate User', 287, NULL, 'Live'),
(296, '', 'deactivate_user', 'Deactivate User', 287, NULL, 'Live'),
(297, 'Brand', NULL, 'Brand', NULL, 5, 'Live'),
(298, '', 'add', 'Add Brand', 297, NULL, 'Live'),
(299, '', 'edit', 'Edit Brand', 297, NULL, 'Live'),
(300, '', 'delete', 'Delete Brand', 297, NULL, 'Live'),
(301, '', 'list', 'List Brand', 297, NULL, 'Live'),
(302, 'POS Category Sorting', NULL, 'POS Category Sorting', NULL, 5, 'Live'),
(303, '', 'sort', 'Sort Category List', 302, NULL, 'Live'),
(304, 'Rack', NULL, 'Rack', NULL, 5, 'Live'),
(305, '', 'add', 'Add Rack', 304, NULL, 'Live'),
(306, '', 'edit', 'Edit Rack', 304, NULL, 'Live'),
(307, '', 'delete', 'Delete Rack', 304, NULL, 'Live'),
(308, '', 'list', 'List Rack', 304, NULL, 'Live'),
(309, '', 'status', 'Status Change', 75, NULL, 'Live'),
(310, '', 'print', 'Print', 75, NULL, 'Live'),
(311, 'Multiple Currency', NULL, 'Multiple Currency', NULL, 1, 'Live'),
(312, '', 'add', 'Add Multiple Currency', 311, NULL, 'Live'),
(313, '', 'edit', 'Edit Multiple Currency', 311, NULL, 'Live'),
(314, '', 'delete', 'Delete Multiple Currency', 311, NULL, 'Live'),
(315, '', 'list', 'List Multiple Currency', 311, NULL, 'Live'),
(316, '', 'zReport', 'Z Report', 249, NULL, 'Live'),
(317, '', 'discountPermission', 'Discount Permission', 287, NULL, 'Live'),
(318, 'Uninstall License', NULL, 'Uninstall License', NULL, 25, 'Live'),
(319, '', 'uninstall', 'Uninstall License', 318, NULL, 'Live'),
(320, 'Notification', NULL, 'Notification', NULL, 1, 'Live'),
(321, '', 'list', 'List', 320, NULL, 'Live'),
(322, '', 'unreadList', 'Unread List', 320, NULL, 'Live'),
(323, '', 'marakAllAsRead', 'Mark All As Read', 320, NULL, 'Live'),
(324, '', 'delete', 'Delete', 320, NULL, 'Live'),
(325, 'Dummy Data', NULL, 'Dummy Data', NULL, 1, 'Live'),
(326, '', 'add_dummy_data', 'Import Dummy Data', 325, NULL, 'Live'),
(327, 'WhatsApp Setting', NULL, 'WhatsApp Setting', NULL, 1, 'Live'),
(328, '', 'whatsappSetting', 'WhatsApp Setting', 327, NULL, 'Live'),
(329, 'Delete Dummy Data', NULL, 'Delete Dummy Data', NULL, 1, 'Live'),
(330, '', 'deleteDummyData', 'Delete Dummy Data', 329, NULL, 'Live'),
(331, 'Wipe Transactional Data', NULL, 'Wipe Transactional Data', NULL, 1, 'Live'),
(332, '', 'wipeTransactionalData', 'Wipe Transactional Data', 331, NULL, 'Live'),
(333, 'Wipe All Data', NULL, 'Wipe All Data', NULL, 1, 'Live'),
(334, '', 'wipeAllData', 'Wipe All Data', 333, NULL, 'Live'),
(335, 'Payment Gateway', NULL, 'Payment Gateway', NULL, 1, 'Live'),
(336, '', 'edit', 'Edit Payment Gateway', 335, NULL, 'Live'),
(337, '', 'salePriceModify', 'Sale Price Modify', 287, NULL, 'Live'),
(338, '', 'available_loyalty_point', 'Available Loyalty Point Report', 249, NULL, 'Live'),
(339, '', 'usage_loyalty_point', 'Usage Loyalty Point Report', 249, NULL, 'Live'),
(340, 'Counter', NULL, 'Counter', NULL, 340, 'Live'),
(341, '', 'add', 'Add Counter', 340, NULL, 'Live'),
(342, '', 'edit', 'Edit Counter', 340, NULL, 'Live'),
(343, '', 'delete', 'Delete Counter', 340, NULL, 'Live'),
(344, '', 'list', 'List Counter', 340, NULL, 'Live');

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

--
-- Table structure for table `tbl_api_keys`
--

CREATE TABLE `tbl_api_keys` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `my_key` varchar(40) DEFAULT NULL,
  `level` int(2) NOT NULL,
  `ignore_limits` tinyint(1) NOT NULL DEFAULT 0,
  `is_private_key` tinyint(1) NOT NULL DEFAULT 0,
  `ip_addresses` text DEFAULT NULL,
  `date_created` varchar(55) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

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

CREATE TABLE `tbl_attendance` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) 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(55) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(11) 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, 'Easy', '', '2024-05-21 13:47:01', 1, 1, 'Delete'),
(2, 'Gentle Park', '', '2024-05-21 13:48:20', 1, 1, 'Delete'),
(3, 'Arong', '', '2024-05-21 13:48:50', 1, 1, 'Delete'),
(5, 'Le Reve', '', '2024-05-21 15:20:43', 1, 1, 'Delete'),
(6, 'Apple', '', '2024-05-23 12:22:26', 1, 1, 'Delete'),
(7, 'Samsung', '', '2024-05-23 12:22:35', 1, 1, 'Delete'),
(8, 'Sony', '', '2024-05-23 12:22:41', 1, 1, 'Delete'),
(9, 'HP', '', '2024-05-23 12:23:25', 1, 1, 'Delete'),
(10, 'Dell', '', '2024-05-23 12:23:36', 1, 1, 'Delete'),
(11, 'Asus', '', '2024-05-23 12:23:57', 1, 1, 'Delete'),
(12, 'Dlink', '', '2024-05-23 12:26:34', 1, 1, 'Delete'),
(13, 'TP Link', '', '2024-05-23 12:26:43', 1, 1, 'Delete'),
(14, 'Tenda', '', '2024-05-23 12:27:01', 1, 1, 'Delete'),
(15, 'Huawei', '', '2024-05-23 13:17:34', 1, 1, 'Delete'),
(16, 'LG', '', '2024-05-23 13:28:38', 1, 1, 'Delete'),
(17, 'Microsoft', '', '2024-05-23 16:51:48', 1, 1, 'Delete'),
(18, 'Lenovo', '', '2024-05-23 17:14:14', 1, 1, 'Delete'),
(19, 'Penasonic', '', '2024-05-25 14:20:57', 1, 1, 'Delete'),
(20, 'Beximco Pharmaceuticals Ltd.', '', '2024-05-26 13:18:45', 1, 1, 'Delete'),
(21, 'Drug International Ltd.', '', '2024-05-26 13:19:07', 1, 1, 'Delete'),
(22, 'ACME Laboratories Ltd.', '', '2024-05-26 13:19:54', 1, 1, 'Delete'),
(23, 'ACI Limited', '', '2024-05-26 14:00:39', 1, 1, 'Delete'),
(24, ' Biopharma Limited', '', '2024-05-26 14:15:19', 1, 1, 'Delete'),
(25, 'Square Pharmaceuticals PLC', '', '2024-05-26 14:43:05', 1, 1, 'Delete'),
(26, 'Popular Pharmaceuticals Ltd.', '', '2024-05-26 14:50:01', 1, 1, 'Delete'),
(27, 'Walton', '', '2024-05-26 20:57:02', 1, 1, 'Delete'),
(28, 'Vision', '', '2024-05-26 20:57:42', 1, 1, 'Delete'),
(29, 'Singer', '', '2024-05-26 20:57:48', 1, 1, 'Delete'),
(30, 'Panasonic', '', '2024-05-26 23:06:37', 1, 1, 'Delete'),
(31, 'Hike', '', '2024-05-28 10:20:14', 1, 1, 'Live'),
(32, 'Square', '', '2024-05-28 10:27:15', 1, 1, 'Live');

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

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

CREATE TABLE `tbl_companies` (
  `id` int(11) NOT NULL,
  `business_name` varchar(55) DEFAULT NULL,
  `short_name` varchar(11) NOT NULL DEFAULT 'OP',
  `email` varchar(55) 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,
  `product_display` varchar(55) DEFAULT NULL,
  `default_payment` int(11) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `invoice_footer` varchar(300) DEFAULT NULL,
  `letter_head_gap` varchar(11) DEFAULT NULL,
  `letter_footer_gap` varchar(55) DEFAULT NULL,
  `invoice_prefix` varchar(11) DEFAULT '',
  `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_invoice_enable_status` varchar(55) 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,
  `receipt_printer_invoice` int(11) 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(25) DEFAULT '2',
  `purchase_price_show_hide` varchar(11) NOT NULL DEFAULT 'No',
  `term_conditions` text NOT NULL,
  `allow_less_sale` varchar(11) NOT NULL,
  `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,
  `payment_api_setting` text DEFAULT NULL,
  `is_loyalty_enable` varchar(55) DEFAULT NULL,
  `minimum_point_to_redeem` int(11) DEFAULT NULL,
  `loyalty_rate` float DEFAULT NULL,
  `api_token` varchar(55) DEFAULT NULL,
  `whatsapp_app_key` text DEFAULT NULL,
  `whatsapp_authkey` text DEFAULT NULL,
  `added_date` int(55) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `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`, `product_display`, `default_payment`, `website`, `phone`, `invoice_footer`, `letter_head_gap`, `letter_footer_gap`, `invoice_prefix`, `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_invoice_enable_status`, `whatsapp_share_number`, `white_label`, `white_label_status`, `tax_registration_number`, `receipt_printer_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`, `payment_api_setting`, `is_loyalty_enable`, `minimum_point_to_redeem`, `loyalty_rate`, `api_token`, `whatsapp_app_key`, `whatsapp_authkey`, `added_date`, `user_id`, `del_status`) VALUES
(1, 'Dyan Super Shop', 'OP', 'Dyan@gmail.com', 'm/d/Y', 'Asia/Dhaka', '৳', 'Before Amount', '1', 1, 'Barcode Box', 'Image View', 1, '421 E. Commerce San Antonio, TX 782054', '(210) 224-13135', '<p>Thank you for visiting us!</p>\r\n', '200px', '100px', 'INV', 'Yes', '1712261806.png', '', '', '', 'Yes', 'Yes', 'Local Tax', '10069', 'Yes', '[{\"id\":\"1\",\"tax\":\"CGST\",\"tax_rate\":\"1\"},{\"id\":\"1\",\"tax\":\"SGST\",\"tax_rate\":\"1\"},{\"id\":\"1\",\"tax\":\"IGST\",\"tax_rate\":\"1\"},{\"id\":\"1\",\"tax\":\"VAT\",\"tax_rate\":\"1\"}]', 'CGST:SGST:IGST:VAT:', 1, 3, '{\"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\",\"field_3_0\":\"\",\"field_3_1\":\"x6rOGWgObd9dYIy2y1vlpcreZbIFibxR9VELNscX\",\"field_3_2\":\"8801969908462\",\"field_4_0\":\"\",\"field_4_1\":\"\",\"field_4_2\":\"\"}', 'Sendinblue', 1, '{\"host_name\":\"smtp.gmail.com\",\"port_address\":\"465\",\"encryption\":\"tls\",\"user_name\":\"mkraju.doorsoft@gmail.com\",\"password\":\"mhmrpahjwmyyveuc\",\"from_name\":\"Door Soft\",\"from_email\":\"no-reply@offpos.com\",\"api_key\":\"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\"}', 'Enable', '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\":\"e8479c463b815b121d0631649a24c792.png\",\"site_logo_dark\":\"a3ccd97d3a7373884fd30002d75366c3.png\",\"site_favicon\":\"6fd15bfae8a4874f86610e0279ad9e15.ico\"}', 0, NULL, 0, 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, 'Yes', '{\"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\"}', 2, 3, '{\"action_type_stripe\":\"Disable\",\"stripe_api_key\":\"xxxxxxxxxxxxxx\",\"stripe_publishable_key\":\"xxxxxxxxxxxxxx\",\"action_type_paypal\":\"Enable\",\"paypal_clinet_id\":\"xxxxxxxxxxxxxx\",\"paypal_secret_key\":\"xxxxxxxxxxxxxx\",\"company_id\":\"1\",\"user_id\":\"1\"}', 'enable', 40, 0.1, 'c10edad9-e361-4ba1-97e3-387f27ba4265', 'a661df56-01d5-4434-8e80-62b8eb0e6f76', 'czUiymWJ7gIWeB2cnWFrzb2yfxVf20EyoUG57O2BORc1qp61Am', NULL, 1, 'Live');

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

--
-- Table structure for table `tbl_counters`
--

CREATE TABLE `tbl_counters` (
  `id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `outlet_id` varchar(11) DEFAULT NULL,
  `printer_id` varchar(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_counters`
--

INSERT INTO `tbl_counters` (`id`, `name`, `outlet_id`, `printer_id`, `description`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(15, 'Counter No-1', '4', '2', '', '2024-05-19 16:55:26', 1, 1, 'Live');

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

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

CREATE TABLE `tbl_customers` (
  `id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `nid` varchar(150) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `email` varchar(55) DEFAULT NULL,
  `address` varchar(150) DEFAULT NULL,
  `opening_balance` float DEFAULT NULL,
  `opening_balance_type` varchar(11) NOT NULL DEFAULT 'Debit',
  `credit_limit` float DEFAULT NULL,
  `gst_number` varchar(25) 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(150) DEFAULT NULL,
  `work_address` varchar(150) DEFAULT NULL,
  `customer_nid` varchar(150) DEFAULT NULL,
  `g_name` varchar(55) DEFAULT NULL,
  `g_mobile` varchar(30) DEFAULT NULL,
  `g_nid` varchar(150) DEFAULT NULL,
  `g_photo` varchar(150) DEFAULT NULL,
  `g_pre_address` varchar(150) DEFAULT NULL,
  `g_permanent_address` varchar(150) DEFAULT NULL,
  `g_work_address` varchar(150) DEFAULT NULL,
  `photo` varchar(150) 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'),
(80, 'Azhar Raihan', '', '01629171720', 'azharraihan6969@gmail.com', '', 1000, 'Credit', 0, '69', 0, '2024-04-28', 'default', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', 1, 1, '2024-04-28 00:15:25', 1, 1, 'Live'),
(81, 'Azhar Ullah', '', '+8801401748845', 'azharullah6969@gmail.com', '', 100, 'Debit', 0, '69', 0, '2024-04-28', 'default', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '0', 1, 1, '2024-04-28 00:16:12', 1, 1, 'Live'),
(82, 'Mr.Alex', '', '01987434455', '', '', 0, 'Credit', 1000, '55', 0, '', 'default', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', 2, 2, '2024-05-02 12:24:08', 1, 1, 'Live'),
(83, 'Juniya', '', '+8801302986732', 'juniya.azhar.tahiya69@gmail.com', '', 2000, 'Debit', 0, '69', 0, NULL, 'default', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 1, 1, '2024-05-07 16:38:08', 1, 1, 'Live'),
(84, 'Mr.John', NULL, '01987434455', 'john@gmail.com', 'Banasree, C Block, Roda No #5, Dhaka, Bangladesh.', NULL, 'Debit', NULL, NULL, NULL, NULL, 'installment', 'Banasree, C Block, Roda No #5, Dhaka, Bangladesh.', 'Tejgao Nabisko, Roda No #15, Dhaka, Bangladesh.', '39c0ab355721d05f96cb6579a9377138.jpg', 'Mr.Alex', '0998764864', '', '', 'Banasree, C Block, Roda No #5, Dhaka, Bangladesh.', 'Banasree, C Block, Roda No #5, Dhaka, Bangladesh.', 'Banasree, C Block, Roda No #5, Dhaka, Bangladesh.', 'cddfb218cd1151e55018b5cafa264eca.jpg', NULL, '0', 1, NULL, '2024-05-09 17:56:30', 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(55) 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(100) 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(11) 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(55) 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(55) 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 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_delivery_partners`
--

CREATE TABLE `tbl_delivery_partners` (
  `id` int(11) NOT NULL,
  `partner_name` varchar(55) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) 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;

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

--
-- 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, '', '2024-05-21 21:40:42', 1, 1, 'Live'),
(2, 20, '', '2024-05-21 21:40:50', 1, 1, 'Live'),
(3, 50, '', '2024-05-21 21:40:55', 1, 1, 'Live'),
(4, 100, '', '2024-05-21 21:41:02', 1, 1, 'Live'),
(5, 200, '', '2024-05-21 21:41:51', 1, 1, 'Live'),
(6, 500, '', '2024-05-21 21:41:58', 1, 1, 'Live'),
(7, 1000, '', '2024-05-21 21:42:03', 1, 1, 'Live');

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

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

CREATE TABLE `tbl_deposits` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) 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(55) 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;

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

--
-- Table structure for table `tbl_fixed_asset_items`
--

CREATE TABLE `tbl_fixed_asset_items` (
  `id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `added_date` varchar(55) 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;

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

--
-- Table structure for table `tbl_fixed_asset_stocks`
--

CREATE TABLE `tbl_fixed_asset_stocks` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `grand_total` float DEFAULT NULL,
  `note` 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;

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

--
-- Table structure for table `tbl_fixed_asset_stock_details`
--

CREATE TABLE `tbl_fixed_asset_stock_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,
  `asset_stocks_id` int(11) 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;

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

--
-- Table structure for table `tbl_fixed_asset_stock_outs`
--

CREATE TABLE `tbl_fixed_asset_stock_outs` (
  `id` int(11) NOT NULL,
  `reference_no` varchar(55) DEFAULT NULL,
  `date` varchar(30) DEFAULT NULL,
  `grand_total` float DEFAULT NULL,
  `note` varchar(300) 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;

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

--
-- Table structure for table `tbl_fixed_asset_stock_out_details`
--

CREATE TABLE `tbl_fixed_asset_stock_out_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,
  `asset_stock_out_id` int(11) 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;

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

--
-- 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` float DEFAULT NULL,
  `due_amount` float 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 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,
  `sub_total_discount_value` varchar(11) NOT NULL,
  `sub_total_discount_type` varchar(11) NOT NULL,
  `token_no` varchar(255) DEFAULT NULL,
  `sale_date` varchar(30) DEFAULT NULL,
  `date_time` varchar(30) DEFAULT NULL,
  `sale_time` varchar(30) NOT NULL,
  `waiter_id` int(11) DEFAULT 0,
  `order_status` tinyint(1) DEFAULT NULL COMMENT '1=new order, 2=cancelled order, 3=invoiced order',
  `delivery_partner_id` varchar(55) DEFAULT NULL COMMENT '1-Sent,2-Returned,3-Cash Received',
  `delivery_status` varchar(55) DEFAULT NULL COMMENT '1-Sent,2-Returned,3-Cash Received',
  `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 DEFAULT NULL,
  `menu_price_with_discount` float DEFAULT NULL,
  `menu_unit_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(11) NOT NULL,
  `menu_note` varchar(255) DEFAULT NULL,
  `discount_amount` float 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,
  `delivery_status` varchar(55) DEFAULT NULL COMMENT '1-Sent,2-Returned,3-Cash Received',
  `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(100) DEFAULT NULL,
  `account_type` varchar(55) 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(55) 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;

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

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

CREATE TABLE `tbl_installments` (
  `id` int(11) NOT NULL,
  `date` varchar(55) DEFAULT NULL,
  `reference_no` varchar(55) 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 DEFAULT NULL,
  `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(100) 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;

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

--
-- 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(100) DEFAULT NULL,
  `account_type` varchar(55) DEFAULT NULL,
  `added_date` varchar(55) 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;

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

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

CREATE TABLE `tbl_items` (
  `id` int(11) NOT NULL,
  `code` varchar(55) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `alternative_name` varchar(55) DEFAULT NULL,
  `generic_name` varchar(55) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `rack_id` int(11) DEFAULT NULL,
  `brand_id` int(11) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `alert_quantity` int(11) DEFAULT NULL,
  `unit_type` int(11) DEFAULT NULL,
  `purchase_unit_id` int(11) DEFAULT NULL,
  `sale_unit_id` int(11) DEFAULT NULL,
  `conversion_rate` int(11) 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,
  `loyalty_point` decimal(10,0) 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`, `alternative_name`, `generic_name`, `type`, `category_id`, `rack_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`, `loyalty_point`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, '001', 'T-Shirt', '', '', 'Variation_Product', 1, 0, 31, 30, 0, 2, 2, 1, 10, 0, '', '', 0, 0, '', 6, 'day', 0, 'month', '1716870139.png', '[{\"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\"}]', 'CGST:SGST:IGST:VAT:', '[\"{\\\"variation_name\\\":\\\"Size\\\",\\\"attribute_id\\\":\\\"1\\\",\\\"child_row_attribute\\\":\\\"[\\\\\\\"M\\\\\\\",\\\\\\\"L\\\\\\\"]\\\"}\",\"{\\\"variation_name\\\":\\\"Color\\\",\\\"attribute_id\\\":\\\"2\\\",\\\"child_row_attribute\\\":\\\"[\\\\\\\"Red\\\\\\\",\\\\\\\"Blue\\\\\\\"]\\\"}\"]', 'Variation_Product', 0, '10', '2024-05-28 10:22:21', 1, 1, 'Live'),
(2, '001-01', 'M - Red', NULL, NULL, '0', 1, 0, 31, 30, 5, 2, 2, 1, 10, 8000, '8000', '8000', 1000, 900, NULL, 6, 'day', 0, 'month', '', '[{\"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\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 1, '0', '2024-05-28 10:22:21', 1, 1, 'Live'),
(3, '001-02', 'M - Blue', NULL, NULL, '0', 1, 0, 31, 30, 5, 2, 2, 1, 10, 8000, '8000', '8000', 1000, 900, NULL, 6, 'day', 0, 'month', '', '[{\"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\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 1, '0', '2024-05-28 10:22:21', 1, 1, 'Live'),
(4, '001-03', 'L - Red', NULL, NULL, '0', 1, 0, 31, 30, 5, 2, 2, 1, 10, 8000, '8000', '8000', 1000, 900, NULL, 6, 'day', 0, 'month', '', '[{\"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\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 1, '0', '2024-05-28 10:22:21', 1, 1, 'Live'),
(5, '001-04', 'L - Blue', NULL, NULL, '0', 1, 0, 31, 30, 5, 2, 2, 1, 10, 8000, '8000', '8000', 1000, 900, NULL, 6, 'day', 0, 'month', '', '[{\"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\"}]', 'CGST:SGST:IGST:VAT:', NULL, '', 1, '0', '2024-05-28 10:22:21', 1, 1, 'Live'),
(6, '006', 'Napa', '', 'Paracetamol', 'Medicine_Product', 2, 1, 32, 31, 0, 2, 3, 1, 520, 420, '420', '420', 2, 1, '', 0, 'month', 0, 'month', '', '[{\"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\"}]', 'CGST:SGST:IGST:VAT:', NULL, 'Medicine_Product', 0, '0', '2024-05-28 10:27:26', 1, 1, 'Live');

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

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

CREATE TABLE `tbl_item_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(55) 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(11) 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, 'Dress', '', NULL, '2024-05-28 10:19:02', 1, 1, 'Live'),
(2, 'Medicine', '', NULL, '2024-05-28 10:25:03', 1, 1, 'Live');

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

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

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

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

--
-- Table structure for table `tbl_multiple_currencies`
--

CREATE TABLE `tbl_multiple_currencies` (
  `id` int(11) NOT NULL,
  `currency` varchar(11) DEFAULT NULL,
  `conversion_rate` float DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `company_id` int(1) DEFAULT NULL,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- 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;

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

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

CREATE TABLE `tbl_outlets` (
  `id` int(11) NOT NULL,
  `outlet_name` varchar(55) DEFAULT NULL,
  `outlet_code` varchar(55) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `email` varchar(55) 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
(4, 'Ninja Shop (Mirpur)', '000001', 'House No: 5, Road No: 4, Kazi Para, Mirpur 10, Dhaka.', '+88 01987 654321', '', '2024-05-19 15:01:58', 1, 'active', 1, 'Live'),
(5, 'Ninja Shop (Uttara)', '000002', 'Address: House No: 5, Road No: 4, Nikunja 2, Khilkhet, Dhaka.', '+88 01987 6543211', '', '2024-05-19 16:28:37', 1, 'active', 1, 'Live');

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

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

CREATE TABLE `tbl_payment_methods` (
  `id` int(11) NOT NULL,
  `name` varchar(55) DEFAULT NULL,
  `account_type` varchar(55) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `current_balance` float DEFAULT NULL,
  `status` varchar(55) NOT NULL DEFAULT 'Enable' COMMENT 'Enable, Disable',
  `added_date` varchar(55) DEFAULT NULL,
  `personalinformation` text 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`, `status`, `added_date`, `personalinformation`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Bank', 'Bank_Account', '', 10, 'Enable', '2023-07-30 21:22:42', NULL, 1, 1, 'Live'),
(2, 'Cash', 'Cash', '', 1001, 'Enable', '2023-07-30 21:22:42', NULL, 1, 1, 'Live'),
(6, 'Paypal', 'Paypal', '', 1, 'Disable', '2024-03-09 14:25:04', NULL, 1, 1, 'Live'),
(7, 'Stripe', 'Stripe', '', 1, 'Enable', '2024-03-09 14:25:33', NULL, 1, 1, 'Live'),
(8, 'Loyalty Point', 'Loyalty Point', '', 0, 'Enable', '2024-03-15 19:20:19', NULL, 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(255) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `profile_` varchar(100) DEFAULT NULL,
  `characters_per_line` int(11) DEFAULT NULL,
  `printer_ip_address` varchar(55) DEFAULT NULL,
  `printer_port` varchar(55) DEFAULT NULL,
  `print_format_invoice` varchar(25) DEFAULT NULL,
  `print_format` varchar(25) DEFAULT NULL,
  `qr_code_type` varchar(55) DEFAULT NULL,
  `invoice_print` varchar(55) DEFAULT NULL,
  `print_server_url_invoice` varchar(255) DEFAULT NULL,
  `inv_qr_code_status` varchar(25) DEFAULT NULL,
  `open_cash_drawer_when_printing_invoice` 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) 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`, `print_format_invoice`, `print_format`, `qr_code_type`, `invoice_print`, `print_server_url_invoice`, `inv_qr_code_status`, `open_cash_drawer_when_printing_invoice`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(2, '', 'General Printer', 'network', 'default', 30, '19.000.000', '90', 'A4 Print', 'A4 Print', 'Invoice Link', 'web_browser', '', 'Enable', '', '2024-05-19 16:54:45', 1, 1, 'Live');

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

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

CREATE TABLE `tbl_promotions` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `start_date` varchar(55) DEFAULT NULL,
  `end_date` varchar(55) 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(11) DEFAULT NULL,
  `coupon_code` varchar(4) 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(55) DEFAULT NULL,
  `invoice_no` varchar(55) 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` varchar(255) 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;

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

--
-- 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(55) 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;

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

--
-- 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(55) DEFAULT NULL,
  `pur_ref_no` varchar(55) 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(100) DEFAULT NULL,
  `account_type` varchar(55) DEFAULT NULL,
  `note` varchar(255) 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(55) DEFAULT NULL,
  `expiry_imei_serial` varchar(255) DEFAULT NULL,
  `expiry_imei_serial_in` varchar(55) DEFAULT NULL,
  `return_note` varchar(255) 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(55) 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,
  `note` varchar(300) 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,
  `item_type` varchar(55) DEFAULT NULL,
  `expiry_imei_serial` varchar(255) 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_racks`
--

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

--
-- Dumping data for table `tbl_racks`
--

INSERT INTO `tbl_racks` (`id`, `name`, `description`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Shelf No.1 (ACMI)', '', '2024-05-26 13:23:51', 1, 1, 'Live'),
(2, 'Shelf No.2 (Beximco)', '', '2024-05-26 13:23:58', 1, 1, 'Live'),
(3, 'Shelf No.3 ( ACI)', '', '2024-05-26 13:24:04', 1, 1, 'Live'),
(4, 'Shelf No.4 (Biopharma)', '', '2024-05-26 13:24:10', 1, 1, 'Live'),
(5, 'Shelf No.5 (Square)', '', '2024-05-26 13:24:24', 1, 1, 'Live'),
(6, 'Shelf No.6 (Popular)', '', '2024-05-26 13:24:33', 1, 1, 'Live'),
(7, 'Shelf No.7', '', '2024-05-26 13:24:38', 1, 1, 'Live'),
(8, 'Shelf No.8', '', '2024-05-26 13:24:47', 1, 1, 'Live'),
(9, 'Shelf No.9', '', '2024-05-26 13:24:54', 1, 1, 'Live');

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

--
-- 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(55) DEFAULT NULL,
  `closing_balance_date_time` varchar(55) 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 DEFAULT NULL,
  `total_installmentcollection` float DEFAULT NULL,
  `total_servicing` float DEFAULT NULL,
  `total_purchase_return` float DEFAULT NULL,
  `total_due_payment` float DEFAULT NULL,
  `total_expense` float DEFAULT NULL,
  `counter_id` varchar(11) 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`, `counter_id`, `added_date`, `user_id`, `outlet_id`, `company_id`, `del_status`) VALUES
(4, 1000, '[\"1||Bank||0\",\"2||Cash||1000\",\"6||Paypal||0\",\"7||Stripe||0\"]', 0, '2024-05-19 16:55:42', NULL, NULL, NULL, NULL, '', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '15', '2024-05-19 16:55:42', 1, 5, 1, 'Live');

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

--
-- Table structure for table `tbl_roles`
--

CREATE TABLE `tbl_roles` (
  `id` int(11) NOT NULL,
  `role_name` varchar(55) DEFAULT NULL,
  `added_date` varchar(55) 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=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_roles`
--

INSERT INTO `tbl_roles` (`id`, `role_name`, `added_date`, `user_id`, `company_id`, `del_status`) VALUES
(1, 'Admin', '2024-04-26 12:36:07', 1, 1, 'Live'),
(2, 'Manager', '2024-04-26 12:36:21', 1, 1, 'Live'),
(3, 'Cashier', '2024-04-26 12:37:06', 1, 1, 'Live'),
(4, 'Test Role', '2024-05-02 16:47:39', 1, 1, 'Live');

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

--
-- Table structure for table `tbl_role_access`
--

CREATE TABLE `tbl_role_access` (
  `id` int(11) NOT NULL,
  `role_id` int(11) DEFAULT NULL,
  `access_parent_id` int(11) DEFAULT NULL,
  `access_child_id` int(11) DEFAULT NULL,
  `del_status` varchar(11) DEFAULT 'Live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_role_access`
--

INSERT INTO `tbl_role_access` (`id`, `role_id`, `access_parent_id`, `access_child_id`, `del_status`) VALUES
(1, 1, 333, 334, 'Live'),
(2, 1, 331, 332, 'Live'),
(3, 1, 329, 330, 'Live'),
(4, 1, 327, 328, 'Live'),
(5, 1, 325, 326, 'Live'),
(6, 1, 320, 324, 'Live'),
(7, 1, 320, 321, 'Live'),
(8, 1, 320, 323, 'Live'),
(9, 1, 320, 322, 'Live'),
(10, 1, 335, 336, 'Live'),
(11, 1, 311, 312, 'Live'),
(12, 1, 311, 314, 'Live'),
(13, 1, 311, 313, 'Live'),
(14, 1, 311, 315, 'Live'),
(15, 1, 23, 24, 'Live'),
(16, 1, 19, 20, 'Live'),
(17, 1, 14, 15, 'Live'),
(18, 1, 14, 17, 'Live'),
(19, 1, 14, 16, 'Live'),
(20, 1, 14, 18, 'Live'),
(21, 1, 12, 13, 'Live'),
(22, 1, 10, 11, 'Live'),
(23, 1, 8, 9, 'Live'),
(24, 1, 3, 4, 'Live'),
(25, 1, 3, 6, 'Live'),
(26, 1, 3, 5, 'Live'),
(27, 1, 3, 7, 'Live'),
(28, 1, 1, 2, 'Live'),
(29, 1, 21, 22, 'Live'),
(30, 1, 25, 26, 'Live'),
(31, 1, 25, 28, 'Live'),
(32, 1, 25, 27, 'Live'),
(33, 1, 25, 29, 'Live'),
(34, 1, 30, 31, 'Live'),
(35, 1, 32, 33, 'Live'),
(36, 1, 32, 35, 'Live'),
(37, 1, 32, 34, 'Live'),
(38, 1, 32, 36, 'Live'),
(39, 1, 47, 48, 'Live'),
(40, 1, 42, 43, 'Live'),
(41, 1, 42, 45, 'Live'),
(42, 1, 42, 44, 'Live'),
(43, 1, 42, 46, 'Live'),
(44, 1, 37, 38, 'Live'),
(45, 1, 37, 40, 'Live'),
(46, 1, 37, 39, 'Live'),
(47, 1, 37, 41, 'Live'),
(48, 1, 49, 50, 'Live'),
(49, 1, 49, 57, 'Live'),
(50, 1, 49, 55, 'Live'),
(51, 1, 49, 56, 'Live'),
(52, 1, 49, 53, 'Live'),
(53, 1, 49, 51, 'Live'),
(54, 1, 49, 54, 'Live'),
(55, 1, 49, 58, 'Live'),
(56, 1, 49, 59, 'Live'),
(57, 1, 49, 52, 'Live'),
(58, 1, 70, 71, 'Live'),
(59, 1, 70, 73, 'Live'),
(60, 1, 70, 72, 'Live'),
(61, 1, 70, 74, 'Live'),
(62, 1, 304, 305, 'Live'),
(63, 1, 304, 307, 'Live'),
(64, 1, 304, 306, 'Live'),
(65, 1, 304, 308, 'Live'),
(66, 1, 302, 303, 'Live'),
(67, 1, 297, 298, 'Live'),
(68, 1, 297, 300, 'Live'),
(69, 1, 297, 299, 'Live'),
(70, 1, 297, 301, 'Live'),
(71, 1, 60, 61, 'Live'),
(72, 1, 60, 63, 'Live'),
(73, 1, 60, 62, 'Live'),
(74, 1, 60, 64, 'Live'),
(75, 1, 65, 66, 'Live'),
(76, 1, 65, 68, 'Live'),
(77, 1, 65, 67, 'Live'),
(78, 1, 65, 69, 'Live'),
(79, 1, 75, 76, 'Live'),
(80, 1, 75, 78, 'Live'),
(81, 1, 75, 77, 'Live'),
(82, 1, 75, 79, 'Live'),
(83, 1, 75, 310, 'Live'),
(84, 1, 75, 309, 'Live'),
(85, 1, 80, 81, 'Live'),
(86, 1, 80, 83, 'Live'),
(87, 1, 80, 82, 'Live'),
(88, 1, 80, 84, 'Live'),
(89, 1, 85, 86, 'Live'),
(90, 1, 87, 88, 'Live'),
(91, 1, 87, 90, 'Live'),
(92, 1, 87, 89, 'Live'),
(93, 1, 87, 91, 'Live'),
(94, 1, 87, 92, 'Live'),
(95, 1, 93, 94, 'Live'),
(96, 1, 93, 97, 'Live'),
(97, 1, 93, 95, 'Live'),
(98, 1, 93, 98, 'Live'),
(99, 1, 93, 99, 'Live'),
(100, 1, 93, 96, 'Live'),
(101, 1, 100, 101, 'Live'),
(102, 1, 100, 104, 'Live'),
(103, 1, 100, 108, 'Live'),
(104, 1, 100, 102, 'Live'),
(105, 1, 100, 107, 'Live'),
(106, 1, 100, 105, 'Live'),
(107, 1, 100, 106, 'Live'),
(108, 1, 100, 103, 'Live'),
(109, 1, 125, 126, 'Live'),
(110, 1, 125, 132, 'Live'),
(111, 1, 125, 129, 'Live'),
(112, 1, 125, 127, 'Live'),
(113, 1, 125, 130, 'Live'),
(114, 1, 125, 131, 'Live'),
(115, 1, 125, 128, 'Live'),
(116, 1, 117, 118, 'Live'),
(117, 1, 117, 124, 'Live'),
(118, 1, 117, 123, 'Live'),
(119, 1, 117, 121, 'Live'),
(120, 1, 117, 119, 'Live'),
(121, 1, 117, 122, 'Live'),
(122, 1, 117, 120, 'Live'),
(123, 1, 109, 110, 'Live'),
(124, 1, 109, 113, 'Live'),
(125, 1, 109, 111, 'Live'),
(126, 1, 109, 114, 'Live'),
(127, 1, 109, 116, 'Live'),
(128, 1, 109, 115, 'Live'),
(129, 1, 109, 112, 'Live'),
(130, 1, 138, 140, 'Live'),
(131, 1, 138, 142, 'Live'),
(132, 1, 138, 146, 'Live'),
(133, 1, 138, 141, 'Live'),
(134, 1, 138, 143, 'Live'),
(135, 1, 138, 139, 'Live'),
(136, 1, 138, 145, 'Live'),
(137, 1, 138, 144, 'Live'),
(138, 1, 159, 160, 'Live'),
(139, 1, 159, 162, 'Live'),
(140, 1, 159, 161, 'Live'),
(141, 1, 159, 163, 'Live'),
(142, 1, 154, 155, 'Live'),
(143, 1, 154, 157, 'Live'),
(144, 1, 154, 156, 'Live'),
(145, 1, 154, 158, 'Live'),
(146, 1, 147, 148, 'Live'),
(147, 1, 147, 153, 'Live'),
(148, 1, 147, 151, 'Live'),
(149, 1, 147, 149, 'Live'),
(150, 1, 147, 152, 'Live'),
(151, 1, 147, 150, 'Live'),
(152, 1, 133, 134, 'Live'),
(153, 1, 133, 136, 'Live'),
(154, 1, 133, 135, 'Live'),
(155, 1, 133, 137, 'Live'),
(156, 1, 164, 165, 'Live'),
(157, 1, 166, 167, 'Live'),
(158, 1, 166, 170, 'Live'),
(159, 1, 166, 168, 'Live'),
(160, 1, 166, 171, 'Live'),
(161, 1, 166, 169, 'Live'),
(162, 1, 177, 178, 'Live'),
(163, 1, 177, 180, 'Live'),
(164, 1, 177, 179, 'Live'),
(165, 1, 177, 181, 'Live'),
(166, 1, 172, 173, 'Live'),
(167, 1, 172, 175, 'Live'),
(168, 1, 172, 174, 'Live'),
(169, 1, 172, 176, 'Live'),
(170, 1, 182, 183, 'Live'),
(171, 1, 182, 185, 'Live'),
(172, 1, 182, 184, 'Live'),
(173, 1, 182, 186, 'Live'),
(174, 1, 187, 188, 'Live'),
(175, 1, 187, 190, 'Live'),
(176, 1, 187, 189, 'Live'),
(177, 1, 187, 191, 'Live'),
(178, 1, 192, 193, 'Live'),
(179, 1, 192, 195, 'Live'),
(180, 1, 192, 194, 'Live'),
(181, 1, 192, 196, 'Live'),
(182, 1, 192, 197, 'Live'),
(183, 1, 198, 199, 'Live'),
(184, 1, 198, 201, 'Live'),
(185, 1, 198, 200, 'Live'),
(186, 1, 198, 202, 'Live'),
(187, 1, 198, 203, 'Live'),
(188, 1, 204, 205, 'Live'),
(189, 1, 204, 208, 'Live'),
(190, 1, 204, 206, 'Live'),
(191, 1, 204, 209, 'Live'),
(192, 1, 204, 210, 'Live'),
(193, 1, 204, 207, 'Live'),
(194, 1, 211, 212, 'Live'),
(195, 1, 211, 215, 'Live'),
(196, 1, 211, 213, 'Live'),
(197, 1, 211, 216, 'Live'),
(198, 1, 211, 217, 'Live'),
(199, 1, 211, 214, 'Live'),
(200, 1, 230, 231, 'Live'),
(201, 1, 228, 229, 'Live'),
(202, 1, 223, 224, 'Live'),
(203, 1, 223, 226, 'Live'),
(204, 1, 223, 225, 'Live'),
(205, 1, 223, 227, 'Live'),
(206, 1, 232, 233, 'Live'),
(207, 1, 218, 219, 'Live'),
(208, 1, 218, 221, 'Live'),
(209, 1, 218, 220, 'Live'),
(210, 1, 218, 222, 'Live'),
(211, 1, 234, 235, 'Live'),
(212, 1, 234, 237, 'Live'),
(213, 1, 234, 236, 'Live'),
(214, 1, 234, 238, 'Live'),
(215, 1, 239, 240, 'Live'),
(216, 1, 239, 245, 'Live'),
(217, 1, 239, 243, 'Live'),
(218, 1, 239, 241, 'Live'),
(219, 1, 239, 244, 'Live'),
(220, 1, 239, 246, 'Live'),
(221, 1, 239, 242, 'Live'),
(222, 1, 318, 319, 'Live'),
(223, 1, 247, 248, 'Live'),
(224, 1, 249, 262, 'Live'),
(225, 1, 249, 281, 'Live'),
(226, 1, 249, 265, 'Live'),
(227, 1, 249, 266, 'Live'),
(228, 1, 249, 251, 'Live'),
(229, 1, 249, 252, 'Live'),
(230, 1, 249, 274, 'Live'),
(231, 1, 249, 257, 'Live'),
(232, 1, 249, 255, 'Live'),
(233, 1, 249, 269, 'Live'),
(234, 1, 249, 270, 'Live'),
(235, 1, 249, 276, 'Live'),
(236, 1, 249, 275, 'Live'),
(237, 1, 249, 279, 'Live'),
(238, 1, 249, 259, 'Live'),
(239, 1, 249, 280, 'Live'),
(240, 1, 249, 261, 'Live'),
(241, 1, 249, 268, 'Live'),
(242, 1, 249, 256, 'Live'),
(243, 1, 249, 260, 'Live'),
(244, 1, 249, 267, 'Live'),
(245, 1, 249, 272, 'Live'),
(246, 1, 249, 250, 'Live'),
(247, 1, 249, 271, 'Live'),
(248, 1, 249, 253, 'Live'),
(249, 1, 249, 273, 'Live'),
(250, 1, 249, 254, 'Live'),
(251, 1, 249, 278, 'Live'),
(252, 1, 249, 258, 'Live'),
(253, 1, 249, 264, 'Live'),
(254, 1, 249, 263, 'Live'),
(255, 1, 249, 277, 'Live'),
(256, 1, 249, 316, 'Live'),
(257, 1, 287, 295, 'Live'),
(258, 1, 287, 288, 'Live'),
(259, 1, 287, 293, 'Live'),
(260, 1, 287, 292, 'Live'),
(261, 1, 287, 296, 'Live'),
(262, 1, 287, 290, 'Live'),
(263, 1, 287, 317, 'Live'),
(264, 1, 287, 289, 'Live'),
(265, 1, 287, 291, 'Live'),
(266, 1, 287, 294, 'Live'),
(267, 1, 282, 283, 'Live'),
(268, 1, 282, 285, 'Live'),
(269, 1, 282, 284, 'Live'),
(270, 1, 282, 286, 'Live'),
(271, 2, 333, 334, 'Live'),
(272, 2, 331, 332, 'Live'),
(273, 2, 329, 330, 'Live'),
(274, 2, 327, 328, 'Live'),
(275, 2, 325, 326, 'Live'),
(276, 2, 320, 324, 'Live'),
(277, 2, 320, 321, 'Live'),
(278, 2, 320, 323, 'Live'),
(279, 2, 320, 322, 'Live'),
(280, 2, 335, 336, 'Live'),
(281, 2, 311, 312, 'Live'),
(282, 2, 311, 314, 'Live'),
(283, 2, 311, 313, 'Live'),
(284, 2, 311, 315, 'Live'),
(285, 2, 23, 24, 'Live'),
(286, 2, 19, 20, 'Live'),
(287, 2, 14, 15, 'Live'),
(288, 2, 14, 17, 'Live'),
(289, 2, 14, 16, 'Live'),
(290, 2, 14, 18, 'Live'),
(291, 2, 12, 13, 'Live'),
(292, 2, 10, 11, 'Live'),
(293, 2, 8, 9, 'Live'),
(294, 2, 3, 4, 'Live'),
(295, 2, 3, 6, 'Live'),
(296, 2, 3, 5, 'Live'),
(297, 2, 3, 7, 'Live'),
(298, 2, 1, 2, 'Live'),
(299, 2, 21, 22, 'Live'),
(300, 2, 25, 26, 'Live'),
(301, 2, 25, 28, 'Live'),
(302, 2, 25, 27, 'Live'),
(303, 2, 25, 29, 'Live'),
(304, 2, 30, 31, 'Live'),
(305, 2, 32, 33, 'Live'),
(306, 2, 32, 35, 'Live'),
(307, 2, 32, 34, 'Live'),
(308, 2, 32, 36, 'Live'),
(309, 2, 47, 48, 'Live'),
(310, 2, 42, 43, 'Live'),
(311, 2, 42, 45, 'Live'),
(312, 2, 42, 44, 'Live'),
(313, 2, 42, 46, 'Live'),
(314, 2, 37, 38, 'Live'),
(315, 2, 37, 40, 'Live'),
(316, 2, 37, 39, 'Live'),
(317, 2, 37, 41, 'Live'),
(318, 2, 49, 50, 'Live'),
(319, 2, 49, 57, 'Live'),
(320, 2, 49, 55, 'Live'),
(321, 2, 49, 56, 'Live'),
(322, 2, 49, 53, 'Live'),
(323, 2, 49, 51, 'Live'),
(324, 2, 49, 54, 'Live'),
(325, 2, 49, 58, 'Live'),
(326, 2, 49, 59, 'Live'),
(327, 2, 49, 52, 'Live'),
(328, 2, 70, 71, 'Live'),
(329, 2, 70, 73, 'Live'),
(330, 2, 70, 72, 'Live'),
(331, 2, 70, 74, 'Live'),
(332, 2, 304, 305, 'Live'),
(333, 2, 304, 307, 'Live'),
(334, 2, 304, 306, 'Live'),
(335, 2, 304, 308, 'Live'),
(336, 2, 302, 303, 'Live'),
(337, 2, 297, 298, 'Live'),
(338, 2, 297, 300, 'Live'),
(339, 2, 297, 299, 'Live'),
(340, 2, 297, 301, 'Live'),
(341, 2, 60, 61, 'Live'),
(342, 2, 60, 63, 'Live'),
(343, 2, 60, 62, 'Live'),
(344, 2, 60, 64, 'Live'),
(345, 2, 65, 66, 'Live'),
(346, 2, 65, 68, 'Live'),
(347, 2, 65, 67, 'Live'),
(348, 2, 65, 69, 'Live'),
(349, 2, 75, 76, 'Live'),
(350, 2, 75, 78, 'Live'),
(351, 2, 75, 77, 'Live'),
(352, 2, 75, 79, 'Live'),
(353, 2, 75, 310, 'Live'),
(354, 2, 75, 309, 'Live'),
(355, 2, 80, 81, 'Live'),
(356, 2, 80, 83, 'Live'),
(357, 2, 80, 82, 'Live'),
(358, 2, 80, 84, 'Live'),
(359, 2, 85, 86, 'Live'),
(360, 2, 87, 88, 'Live'),
(361, 2, 87, 90, 'Live'),
(362, 2, 87, 89, 'Live'),
(363, 2, 87, 91, 'Live'),
(364, 2, 87, 92, 'Live'),
(365, 2, 93, 94, 'Live'),
(366, 2, 93, 97, 'Live'),
(367, 2, 93, 95, 'Live'),
(368, 2, 93, 98, 'Live'),
(369, 2, 93, 99, 'Live'),
(370, 2, 93, 96, 'Live'),
(371, 2, 100, 101, 'Live'),
(372, 2, 100, 104, 'Live'),
(373, 2, 100, 108, 'Live'),
(374, 2, 100, 102, 'Live'),
(375, 2, 100, 107, 'Live'),
(376, 2, 100, 105, 'Live'),
(377, 2, 100, 106, 'Live'),
(378, 2, 100, 103, 'Live'),
(379, 2, 125, 126, 'Live'),
(380, 2, 125, 132, 'Live'),
(381, 2, 125, 129, 'Live'),
(382, 2, 125, 127, 'Live'),
(383, 2, 125, 130, 'Live'),
(384, 2, 125, 131, 'Live'),
(385, 2, 125, 128, 'Live'),
(386, 2, 117, 118, 'Live'),
(387, 2, 117, 124, 'Live'),
(388, 2, 117, 123, 'Live'),
(389, 2, 117, 121, 'Live'),
(390, 2, 117, 119, 'Live'),
(391, 2, 117, 122, 'Live'),
(392, 2, 117, 120, 'Live'),
(393, 2, 109, 110, 'Live'),
(394, 2, 109, 113, 'Live'),
(395, 2, 109, 111, 'Live'),
(396, 2, 109, 114, 'Live'),
(397, 2, 109, 116, 'Live'),
(398, 2, 109, 115, 'Live'),
(399, 2, 109, 112, 'Live'),
(400, 2, 138, 140, 'Live'),
(401, 2, 138, 142, 'Live'),
(402, 2, 138, 146, 'Live'),
(403, 2, 138, 141, 'Live'),
(404, 2, 138, 143, 'Live'),
(405, 2, 138, 139, 'Live'),
(406, 2, 138, 145, 'Live'),
(407, 2, 138, 144, 'Live'),
(408, 2, 159, 160, 'Live'),
(409, 2, 159, 162, 'Live'),
(410, 2, 159, 161, 'Live'),
(411, 2, 159, 163, 'Live'),
(412, 2, 154, 155, 'Live'),
(413, 2, 154, 157, 'Live'),
(414, 2, 154, 156, 'Live'),
(415, 2, 154, 158, 'Live'),
(416, 2, 147, 148, 'Live'),
(417, 2, 147, 153, 'Live'),
(418, 2, 147, 151, 'Live'),
(419, 2, 147, 149, 'Live'),
(420, 2, 147, 152, 'Live'),
(421, 2, 147, 150, 'Live'),
(422, 2, 133, 134, 'Live'),
(423, 2, 133, 136, 'Live'),
(424, 2, 133, 135, 'Live'),
(425, 2, 133, 137, 'Live'),
(426, 2, 164, 165, 'Live'),
(427, 2, 166, 167, 'Live'),
(428, 2, 166, 170, 'Live'),
(429, 2, 166, 168, 'Live'),
(430, 2, 166, 171, 'Live'),
(431, 2, 166, 169, 'Live'),
(432, 2, 177, 178, 'Live'),
(433, 2, 177, 180, 'Live'),
(434, 2, 177, 179, 'Live'),
(435, 2, 177, 181, 'Live'),
(436, 2, 172, 173, 'Live'),
(437, 2, 172, 175, 'Live'),
(438, 2, 172, 174, 'Live'),
(439, 2, 172, 176, 'Live'),
(440, 2, 182, 183, 'Live'),
(441, 2, 182, 185, 'Live'),
(442, 2, 182, 184, 'Live'),
(443, 2, 182, 186, 'Live'),
(444, 2, 187, 188, 'Live'),
(445, 2, 187, 190, 'Live'),
(446, 2, 187, 189, 'Live'),
(447, 2, 187, 191, 'Live'),
(448, 2, 192, 193, 'Live'),
(449, 2, 192, 195, 'Live'),
(450, 2, 192, 194, 'Live'),
(451, 2, 192, 196, 'Live'),
(452, 2, 192, 197, 'Live'),
(453, 2, 198, 199, 'Live'),
(454, 2, 198, 201, 'Live'),
(455, 2, 198, 200, 'Live'),
(456, 2, 198, 202, 'Live'),
(457, 2, 198, 203, 'Live'),
(458, 2, 204, 205, 'Live'),
(459, 2, 204, 208, 'Live'),
(460, 2, 204, 206, 'Live'),
(461, 2, 204, 209, 'Live'),
(462, 2, 204, 210, 'Live'),
(463, 2, 204, 207, 'Live'),
(464, 2, 211, 212, 'Live'),
(465, 2, 211, 215, 'Live'),
(466, 2, 211, 213, 'Live'),
(467, 2, 211, 216, 'Live'),
(468, 2, 211, 217, 'Live'),
(469, 2, 211, 214, 'Live'),
(470, 2, 230, 231, 'Live'),
(471, 2, 228, 229, 'Live'),
(472, 2, 223, 224, 'Live'),
(473, 2, 223, 226, 'Live'),
(474, 2, 223, 225, 'Live'),
(475, 2, 223, 227, 'Live'),
(476, 2, 232, 233, 'Live'),
(477, 2, 218, 219, 'Live'),
(478, 2, 218, 221, 'Live'),
(479, 2, 218, 220, 'Live'),
(480, 2, 218, 222, 'Live'),
(481, 2, 234, 235, 'Live'),
(482, 2, 234, 237, 'Live'),
(483, 2, 234, 236, 'Live'),
(484, 2, 234, 238, 'Live'),
(485, 2, 239, 240, 'Live'),
(486, 2, 239, 245, 'Live'),
(487, 2, 239, 243, 'Live'),
(488, 2, 239, 241, 'Live'),
(489, 2, 239, 244, 'Live'),
(490, 2, 239, 246, 'Live'),
(491, 2, 239, 242, 'Live'),
(492, 2, 318, 319, 'Live'),
(493, 2, 247, 248, 'Live'),
(494, 2, 249, 262, 'Live'),
(495, 2, 249, 281, 'Live'),
(496, 2, 249, 265, 'Live'),
(497, 2, 249, 266, 'Live'),
(498, 2, 249, 251, 'Live'),
(499, 2, 249, 252, 'Live'),
(500, 2, 249, 274, 'Live'),
(501, 2, 249, 257, 'Live'),
(502, 2, 249, 255, 'Live'),
(503, 2, 249, 269, 'Live'),
(504, 2, 249, 270, 'Live'),
(505, 2, 249, 276, 'Live'),
(506, 2, 249, 275, 'Live'),
(507, 2, 249, 279, 'Live'),
(508, 2, 249, 259, 'Live'),
(509, 2, 249, 280, 'Live'),
(510, 2, 249, 261, 'Live'),
(511, 2, 249, 268, 'Live'),
(512, 2, 249, 256, 'Live'),
(513, 2, 249, 260, 'Live'),
(514, 2, 249, 267, 'Live'),
(515, 2, 249, 272, 'Live'),
(516, 2, 249, 250, 'Live'),
(517, 2, 249, 271, 'Live'),
(518, 2, 249, 253, 'Live'),
(519, 2, 249, 273, 'Live'),
(520, 2, 249, 254, 'Live'),
(521, 2, 249, 278, 'Live'),
(522, 2, 249, 258, 'Live'),
(523, 2, 249, 264, 'Live'),
(524, 2, 249, 263, 'Live'),
(525, 2, 249, 277, 'Live'),
(526, 2, 249, 316, 'Live'),
(527, 2, 287, 295, 'Live'),
(528, 2, 287, 288, 'Live'),
(529, 2, 287, 293, 'Live'),
(530, 2, 287, 292, 'Live'),
(531, 2, 287, 296, 'Live'),
(532, 2, 287, 290, 'Live'),
(533, 2, 287, 317, 'Live'),
(534, 2, 287, 289, 'Live'),
(535, 2, 287, 291, 'Live'),
(536, 2, 287, 294, 'Live'),
(537, 2, 282, 283, 'Live'),
(538, 2, 282, 285, 'Live'),
(539, 2, 282, 284, 'Live'),
(540, 2, 282, 286, 'Live'),
(541, 3, 333, 334, 'Live'),
(542, 3, 331, 332, 'Live'),
(543, 3, 329, 330, 'Live'),
(544, 3, 327, 328, 'Live'),
(545, 3, 325, 326, 'Live'),
(546, 3, 320, 324, 'Live'),
(547, 3, 320, 321, 'Live'),
(548, 3, 320, 323, 'Live'),
(549, 3, 320, 322, 'Live'),
(550, 3, 335, 336, 'Live'),
(551, 3, 311, 312, 'Live'),
(552, 3, 311, 314, 'Live'),
(553, 3, 311, 313, 'Live'),
(554, 3, 311, 315, 'Live'),
(555, 3, 23, 24, 'Live'),
(556, 3, 19, 20, 'Live'),
(557, 3, 14, 15, 'Live'),
(558, 3, 14, 17, 'Live'),
(559, 3, 14, 16, 'Live'),
(560, 3, 14, 18, 'Live'),
(561, 3, 12, 13, 'Live'),
(562, 3, 10, 11, 'Live'),
(563, 3, 8, 9, 'Live'),
(564, 3, 3, 4, 'Live'),
(565, 3, 3, 6, 'Live'),
(566, 3, 3, 5, 'Live'),
(567, 3, 3, 7, 'Live'),
(568, 3, 1, 2, 'Live'),
(569, 3, 21, 22, 'Live'),
(570, 3, 25, 26, 'Live'),
(571, 3, 25, 28, 'Live'),
(572, 3, 25, 27, 'Live'),
(573, 3, 25, 29, 'Live'),
(574, 3, 30, 31, 'Live'),
(575, 3, 32, 33, 'Live'),
(576, 3, 32, 35, 'Live'),
(577, 3, 32, 34, 'Live'),
(578, 3, 32, 36, 'Live'),
(579, 3, 47, 48, 'Live'),
(580, 3, 42, 43, 'Live'),
(581, 3, 42, 45, 'Live'),
(582, 3, 42, 44, 'Live'),
(583, 3, 42, 46, 'Live'),
(584, 3, 37, 38, 'Live'),
(585, 3, 37, 40, 'Live'),
(586, 3, 37, 39, 'Live'),
(587, 3, 37, 41, 'Live'),
(588, 3, 49, 50, 'Live'),
(589, 3, 49, 57, 'Live'),
(590, 3, 49, 55, 'Live'),
(591, 3, 49, 56, 'Live'),
(592, 3, 49, 53, 'Live'),
(593, 3, 49, 51, 'Live'),
(594, 3, 49, 54, 'Live'),
(595, 3, 49, 58, 'Live'),
(596, 3, 49, 59, 'Live'),
(597, 3, 49, 52, 'Live'),
(598, 3, 70, 71, 'Live'),
(599, 3, 70, 73, 'Live'),
(600, 3, 70, 72, 'Live'),
(601, 3, 70, 74, 'Live'),
(602, 3, 304, 305, 'Live'),
(603, 3, 304, 307, 'Live'),
(604, 3, 304, 306, 'Live'),
(605, 3, 304, 308, 'Live'),
(606, 3, 302, 303, 'Live'),
(607, 3, 297, 298, 'Live'),
(608, 3, 297, 300, 'Live'),
(609, 3, 297, 299, 'Live'),
(610, 3, 297, 301, 'Live'),
(611, 3, 60, 61, 'Live'),
(612, 3, 60, 63, 'Live'),
(613, 3, 60, 62, 'Live'),
(614, 3, 60, 64, 'Live'),
(615, 3, 65, 66, 'Live'),
(616, 3, 65, 68, 'Live'),
(617, 3, 65, 67, 'Live'),
(618, 3, 65, 69, 'Live'),
(619, 3, 75, 76, 'Live'),
(620, 3, 75, 78, 'Live'),
(621, 3, 75, 77, 'Live'),
(622, 3, 75, 79, 'Live'),
(623, 3, 75, 310, 'Live'),
(624, 3, 75, 309, 'Live'),
(625, 3, 80, 81, 'Live'),
(626, 3, 80, 83, 'Live'),
(627, 3, 80, 82, 'Live'),
(628, 3, 80, 84, 'Live'),
(629, 3, 85, 86, 'Live'),
(630, 3, 87, 88, 'Live'),
(631, 3, 87, 90, 'Live'),
(632, 3, 87, 89, 'Live'),
(633, 3, 87, 91, 'Live'),
(634, 3, 87, 92, 'Live'),
(635, 3, 93, 94, 'Live'),
(636, 3, 93, 97, 'Live'),
(637, 3, 93, 95, 'Live'),
(638, 3, 93, 98, 'Live'),
(639, 3, 93, 99, 'Live'),
(640, 3, 93, 96, 'Live'),
(641, 3, 100, 101, 'Live'),
(642, 3, 100, 104, 'Live'),
(643, 3, 100, 108, 'Live'),
(644, 3, 100, 102, 'Live'),
(645, 3, 100, 107, 'Live'),
(646, 3, 100, 105, 'Live'),
(647, 3, 100, 106, 'Live'),
(648, 3, 100, 103, 'Live'),
(649, 3, 125, 126, 'Live'),
(650, 3, 125, 132, 'Live'),
(651, 3, 125, 129, 'Live'),
(652, 3, 125, 127, 'Live'),
(653, 3, 125, 130, 'Live'),
(654, 3, 125, 131, 'Live'),
(655, 3, 125, 128, 'Live'),
(656, 3, 117, 118, 'Live'),
(657, 3, 117, 124, 'Live'),
(658, 3, 117, 123, 'Live'),
(659, 3, 117, 121, 'Live'),
(660, 3, 117, 119, 'Live'),
(661, 3, 117, 122, 'Live'),
(662, 3, 117, 120, 'Live'),
(663, 3, 109, 110, 'Live'),
(664, 3, 109, 113, 'Live'),
(665, 3, 109, 111, 'Live'),
(666, 3, 109, 114, 'Live'),
(667, 3, 109, 116, 'Live'),
(668, 3, 109, 115, 'Live'),
(669, 3, 109, 112, 'Live'),
(670, 3, 138, 140, 'Live'),
(671, 3, 138, 142, 'Live'),
(672, 3, 138, 146, 'Live'),
(673, 3, 138, 141, 'Live'),
(674, 3, 138, 143, 'Live'),
(675, 3, 138, 139, 'Live'),
(676, 3, 138, 145, 'Live'),
(677, 3, 138, 144, 'Live'),
(678, 3, 159, 160, 'Live'),
(679, 3, 159, 162, 'Live'),
(680, 3, 159, 161, 'Live'),
(681, 3, 159, 163, 'Live'),
(682, 3, 154, 155, 'Live'),
(683, 3, 154, 157, 'Live'),
(684, 3, 154, 156, 'Live'),
(685, 3, 154, 158, 'Live'),
(686, 3, 147, 148, 'Live'),
(687, 3, 147, 153, 'Live'),
(688, 3, 147, 151, 'Live'),
(689, 3, 147, 149, 'Live'),
(690, 3, 147, 152, 'Live'),
(691, 3, 147, 150, 'Live'),
(692, 3, 133, 134, 'Live'),
(693, 3, 133, 136, 'Live'),
(694, 3, 133, 135, 'Live'),
(695, 3, 133, 137, 'Live'),
(696, 3, 164, 165, 'Live'),
(697, 3, 166, 167, 'Live'),
(698, 3, 166, 170, 'Live'),
(699, 3, 166, 168, 'Live'),
(700, 3, 166, 171, 'Live'),
(701, 3, 166, 169, 'Live'),
(702, 3, 177, 178, 'Live'),
(703, 3, 177, 180, 'Live'),
(704, 3, 177, 179, 'Live'),
(705, 3, 177, 181, 'Live'),
(706, 3, 172, 173, 'Live'),
(707, 3, 172, 175, 'Live'),
(708, 3, 172, 174, 'Live'),
(709, 3, 172, 176, 'Live'),
(710, 3, 182, 183, 'Live'),
(711, 3, 182, 185, 'Live'),
(712, 3, 182, 184, 'Live'),
(713, 3, 182, 186, 'Live'),
(714, 3, 187, 188, 'Live'),
(715, 3, 187, 190, 'Live'),
(716, 3, 187, 189, 'Live'),
(717, 3, 187, 191, 'Live'),
(718, 3, 192, 193, 'Live'),
(719, 3, 192, 195, 'Live'),
(720, 3, 192, 194, 'Live'),
(721, 3, 192, 196, 'Live'),
(722, 3, 192, 197, 'Live'),
(723, 3, 198, 199, 'Live'),
(724, 3, 198, 201, 'Live'),
(725, 3, 198, 200, 'Live'),
(726, 3, 198, 202, 'Live'),
(727, 3, 198, 203, 'Live'),
(728, 3, 204, 205, 'Live'),
(729, 3, 204, 208, 'Live'),
(730, 3, 204, 206, 'Live'),
(731, 3, 204, 209, 'Live'),
(732, 3, 204, 210, 'Live'),
(733, 3, 204, 207, 'Live'),
(734, 3, 211, 212, 'Live'),
(735, 3, 211, 215, 'Live'),
(736, 3, 211, 213, 'Live'),
(737, 3, 211, 216, 'Live'),
(738, 3, 211, 217, 'Live'),
(739, 3, 211, 214, 'Live'),
(740, 3, 230, 231, 'Live'),
(741, 3, 228, 229, 'Live'),
(742, 3, 223, 224, 'Live'),
(743, 3, 223, 226, 'Live'),
(744, 3, 223, 225, 'Live'),
(745, 3, 223, 227, 'Live'),
(746, 3, 232, 233, 'Live'),
(747, 3, 218, 219, 'Live'),
(748, 3, 218, 221, 'Live'),
(749, 3, 218, 220, 'Live'),
(750, 3, 218, 222, 'Live'),
(751, 3, 234, 235, 'Live'),
(752, 3, 234, 237, 'Live'),
(753, 3, 234, 236, 'Live'),
(754, 3, 234, 238, 'Live'),
(755, 3, 239, 240, 'Live'),
(756, 3, 239, 245, 'Live'),
(757, 3, 239, 243, 'Live'),
(758, 3, 239, 241, 'Live'),
(759, 3, 239, 244, 'Live'),
(760, 3, 239, 246, 'Live'),
(761, 3, 239, 242, 'Live'),
(762, 3, 318, 319, 'Live'),
(763, 3, 247, 248, 'Live'),
(764, 3, 249, 262, 'Live'),
(765, 3, 249, 281, 'Live'),
(766, 3, 249, 265, 'Live'),
(767, 3, 249, 266, 'Live'),
(768, 3, 249, 251, 'Live'),
(769, 3, 249, 252, 'Live'),
(770, 3, 249, 274, 'Live'),
(771, 3, 249, 257, 'Live'),
(772, 3, 249, 255, 'Live'),
(773, 3, 249, 269, 'Live'),
(774, 3, 249, 270, 'Live'),
(775, 3, 249, 276, 'Live'),
(776, 3, 249, 275, 'Live'),
(777, 3, 249, 279, 'Live'),
(778, 3, 249, 259, 'Live'),
(779, 3, 249, 280, 'Live'),
(780, 3, 249, 261, 'Live'),
(781, 3, 249, 268, 'Live'),
(782, 3, 249, 256, 'Live'),
(783, 3, 249, 260, 'Live'),
(784, 3, 249, 267, 'Live'),
(785, 3, 249, 272, 'Live'),
(786, 3, 249, 250, 'Live'),
(787, 3, 249, 271, 'Live'),
(788, 3, 249, 253, 'Live'),
(789, 3, 249, 273, 'Live'),
(790, 3, 249, 254, 'Live'),
(791, 3, 249, 278, 'Live'),
(792, 3, 249, 258, 'Live'),
(793, 3, 249, 264, 'Live'),
(794, 3, 249, 263, 'Live'),
(795, 3, 249, 277, 'Live'),
(796, 3, 249, 316, 'Live'),
(797, 3, 287, 295, 'Live'),
(798, 3, 287, 288, 'Live'),
(799, 3, 287, 293, 'Live'),
(800, 3, 287, 292, 'Live'),
(801, 3, 287, 296, 'Live'),
(802, 3, 287, 290, 'Live'),
(803, 3, 287, 317, 'Live'),
(804, 3, 287, 289, 'Live'),
(805, 3, 287, 291, 'Live'),
(806, 3, 287, 294, 'Live'),
(807, 3, 282, 283, 'Live'),
(808, 3, 282, 285, 'Live'),
(809, 3, 282, 284, 'Live'),
(810, 3, 282, 286, 'Live'),
(811, 4, 30, 31, 'Deleted'),
(812, 4, 25, 29, 'Live'),
(813, 4, 30, 31, '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` 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, 80, 0, 'INV000001', 1, 2000, 2060, -1000, 0, NULL, NULL, 60, 0, 2060, '10:28:36', 0, 2000, 0, 0, 0, 'delivery', '', 'plain', '2024-05-28', '2024-05-28 10:28:35', '10:28:35', 2060, 1, NULL, 'Cash Received', NULL, '', 'Bank_Account', '[{\"tax_field_id\":\"\",\"tax_field_type\":\"CGST\",\"tax_field_amount\":\"20.0\"},{\"tax_field_id\":\"\",\"tax_field_type\":\"SGST\",\"tax_field_amount\":\"20.0\"},{\"tax_field_id\":\"\",\"tax_field_type\":\"VAT\",\"tax_field_amount\":\"20.0\"}]', 'BwgiuDHKATWn4pA', '', '2024-05-28 10:28:35', '2024-05-28 10:28:35', 1, 4, 1, 'Live'),
(2, 80, 0, 'INV000002', 1, 2000, 2060, -1000, 0, NULL, NULL, 60, 0, 2060, '10:29:37', 0, 2000, 0, 0, 0, 'delivery', '', 'plain', '2024-05-28', '2024-05-28 10:29:37', '10:29:37', 2060, 1, NULL, 'Cash Received', NULL, '', 'Bank_Account', '[{\"tax_field_id\":\"\",\"tax_field_type\":\"CGST\",\"tax_field_amount\":\"20.0\"},{\"tax_field_id\":\"\",\"tax_field_type\":\"SGST\",\"tax_field_amount\":\"20.0\"},{\"tax_field_id\":\"\",\"tax_field_type\":\"VAT\",\"tax_field_amount\":\"20.0\"}]', 'bySixc1JyKdi0jI', '', '2024-05-28 10:29:37', '2024-05-28 10:29:37', 1, 4, 1, 'Live'),
(4, 80, 0, 'INV000004', 1, 6, 6, -1000, 0, NULL, NULL, 0.3, -0.3, 6, '10:34:12', 0, 6, 0, 0, 0, 'delivery', '', 'plain', '2024-05-28', '2024-05-28 10:34:11', '10:34:11', 6, 1, NULL, 'Cash Received', NULL, '', 'Bank_Account', '[{\"tax_field_id\":\"\",\"tax_field_type\":\"CGST\",\"tax_field_amount\":\"0.1\"},{\"tax_field_id\":\"\",\"tax_field_type\":\"SGST\",\"tax_field_amount\":\"0.1\"},{\"tax_field_id\":\"\",\"tax_field_type\":\"VAT\",\"tax_field_amount\":\"0.1\"}]', 'ztme0zqKkxSGLO1', '', '2024-05-28 10:34:11', '2024-05-28 10:34:11', 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, 3, 2, 2000, 2000, 1000, 800, 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, 'Variation_Product', '', 1, 'No', 0, 0, 'Cash Received', 0, 1, 4, 1, 'Live'),
(2, 3, 2, 2000, 2000, 1000, 800, 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, 'Variation_Product', '', 2, 'No', 0, 0, 'Cash Received', 0, 1, 4, 1, 'Live'),
(4, 6, 3, 6, 6, 2, 0.807692, 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, 'Medicine_Product', '2026-12-17', 4, 'No', 0, 0, 'Cash Received', 0, 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-28', 1, NULL, NULL, NULL, 2060, NULL, 1, '2024-05-28 10:28:36', 'Bank', ',,', NULL, 4, 1, 1, 'Live'),
(2, '2024-05-28', 1, NULL, NULL, NULL, 2060, NULL, 2, '2024-05-28 10:29:37', 'Bank', ',,', NULL, 4, 1, 1, 'Live'),
(3, '2024-05-28', 1, NULL, NULL, NULL, 6, NULL, 4, '2024-05-28 10:34:12', '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;

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

--
-- 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
('r3me6ldg1tl6df2lq4dnl2ph62utfmka', '103.14.130.185', 1716822932, 0x[encoded data, 20228 characters]),
('hhnnmmdj9hl0g0k80knrt92voocb8rsm', '103.14.130.185', 1716822864, 0x5f5f63695f6c6173745f726567656e65726174657c693a313731363832323836343b564945575f5041525345527c623a313b),
('8em4f4p5gjatbjrq2qs1hvq632mpjutt', '103.14.130.185', 1716822864, 0x5f5f63695f6c6173745f726567656e65726174657c693a313731363832323836343b564945575f5041525345527c623a313b),
('oubikvjal85hgnnqma9nuq7nlat4d3n7', '103.14.130.185', 1716823402, 0x[encoded data, 20228 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('mq9tiha75s8og0ajo6tr9pnm0dhpo6j9', '103.14.130.185', 1716823732, 0x[encoded data, 20228 characters]),
('nqciskh8cmm0sre64jo273ltode68v99', '103.14.130.185', 1716824636, 0x[encoded data, 20228 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('hclkeque3i459kb4dcabflbejb2rpger', '103.14.130.185', 1716825622, 0x[encoded data, 20228 characters]),
('fqn1vseo592nqf2hf30omr1sh5u4ccof', '202.134.8.192', 1716825964, 0x[encoded data, 20228 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('a11hcpoa9scc63g34rkrmsu8uit6a49r', '103.14.130.185', 1716826493, 0x[encoded data, 20228 characters]),
('jt2bvqeo4gh5vdj3linhupqboe16q0nr', '103.14.130.185', 1716826828, 0x[encoded data, 20228 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('se7i7md977fpl8c3i8a1eug9qnoej72t', '103.14.130.185', 1716827323, 0x[encoded data, 20228 characters]),
('880dbcfasi00611j0r1jsu4e4ohbb9lr', '103.14.130.185', 1716827904, 0x[encoded data, 20228 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('opk8doovrndhdvvnakrsmr8krn9kpogk', '103.14.130.185', 1716828477, 0x[encoded data, 20212 characters]),
('eu3q921ipetna6ugc37b7jf7e5spsulg', '103.14.130.185', 1716829088, 0x[encoded data, 20212 characters]);
INSERT INTO `tbl_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
('7uh0762v2bm7hhctp3lnu30i1s6vc65l', '202.134.9.146', 1716829095, 0x[encoded data, 20212 characters]),
('k2cvv2619p9f9n1r6pasud6uma2f4t98', '103.14.130.185', 1716868644, 0x[encoded data, 19800 characters]);
