INSERT INTO `language` (`id`, `phrase`, `english`) VALUES 
(NULL, 'ordermanage', 'Restaurent'),
(NULL, 'manage_category', 'Manage Category'),
(NULL, 'category_list', 'Category List'),
(NULL, 'manage_food', 'Manage Food'),
(NULL, 'add_food', 'Add Food'),
(NULL, 'food_list', 'Food List'),
(NULL, 'food_varient', 'Food Variant'),
(NULL, 'food_availablity', 'Food Availability'),
(NULL, 'add_varient', 'Add Variant'),
(NULL, 'varient_name', 'Variant Name'),
(NULL, 'variant_list', 'Variant List'),
(NULL, 'variant_edit', 'Update Variant'),
(NULL, 'food_availablelist', 'Food Available List'),
(NULL, 'add_availablity', 'Add Available Day & Time'),
(NULL, 'edit_availablity', 'Update Available Day & Time'),
(NULL, 'available_day', 'Available Day'),
(NULL, 'available_time', 'Available Time'),
(NULL, 'manage_addons', 'Manage Add-ons'),
(NULL, 'add_adons', 'Add Add-ons'),
(NULL, 'menu_addons', 'Add-ons Menu'),
(NULL, 'addons_list', 'Add-ons List'),
(NULL, 'assign_adons', 'Add-ons Assign'),
(NULL, 'assign_adons_list', 'Add-ons Assign List'),
(NULL, 'update_adons', 'Update Add-ons'),
(NULL, 'add_group_item', 'Add Group Item'),
(NULL, 'menu_type', 'Menu Type'),
(NULL, 'parent_cat', 'Parent Category'),
(NULL, 'is_offer', 'Offer'),
(NULL, 'offerdate', 'Offer Start Date'),
(NULL, 'offerenddate', 'Select Kitchen'),
(NULL, 'select_kitchen', 'Update'),
(NULL, 'kitchen_name', 'Kitchen Name'),
(NULL, 'is_special', 'Special'),
(NULL, 'is_custome_quantity', 'Custom Quantity'),
(NULL, 'cookedtime', 'Cooking Time'),
(NULL, 'item_name', 'Food Name'),
(NULL, 'component', 'Components'),
(NULL, 'vat_tax', 'Vat'),
(NULL, 'add_menu_type', 'Add Menu Type'),
(NULL, 'menu_type_list', 'Menu Type List'),
(NULL, 'menu_type_name', 'Menu Type'),
(NULL, 'icon', 'Icon'),
(NULL, 'menutype_edit', 'Menu Type Edit'),
(NULL, 'addons_name', 'Add-ons Name '),
(NULL, 'pos_invoice', 'POS Invoice'),
(NULL, 'order_list', 'Order List'),
(NULL, 'pending_order', 'Pending Order'),
(NULL, 'complete_order', 'Complete Order'),
(NULL, 'cancel_order', 'Cancel Order'),
(NULL, 'kitchen_dashboard', 'Kitchen Dashboard'),
(NULL, 'counter_dashboard', 'Counter Dashboard'),
(NULL, 'counter_list', 'Counter List'),
(NULL, 'pos_setting', 'POS Setting'),
(NULL, 'sound_setting', 'Sound Setting'),
(NULL, 'upload_notify', 'Upload Notification Sound'),
(NULL, 'placr_setting', 'Place order Setting'),
(NULL, 'waiter', 'Waiter'),
(NULL, 'table', 'Table Map'),
(NULL, 'table_map', 'Table Map'),
(NULL, 'is_sound', 'Is Sound Enable'),
(NULL, 'quick_ord', 'Quick Order Setting'),
(NULL, 'counter_no', 'Counter Number'),
(NULL, 'add_counter', 'Add Counter'),
(NULL, 'tabltno', 'Table No'),
(NULL, 'ord_num', 'Order Number'),
(NULL, 'ordtime', 'Order Time'),
(NULL, 'remtime', 'Remaining Time'),
(NULL, 'ordtcoun', 'Order Time Countdown Board'),
(NULL, 'orderid', 'Order ID'),
(NULL, 'customer_type', 'Customer Type'),
(NULL, 'ordate', 'Order Date'),
(NULL, 'service_chrg', 'Service Charge'),
(NULL, 'customer_paid_amount', 'Customer Paid Amount'),
(NULL, 'change_due', 'Change Due'),
(NULL, 'total_due', 'Total Due'),
(NULL, 'totalpayment', 'Total payment'),
(NULL, 'billing_to', 'Billing To'),
(NULL, 'bill_by', 'Bill By'),
(NULL, 'orderno', 'Order No.'),
(NULL, 'thanks_you', 'Thank you very much'),
(NULL, 'powerbybdtask', 'Powered  By: BDTASK, www.bdtask.com'),
(NULL, 'item', 'Item'),
(NULL, 'billing_from', 'Billing From'),
(NULL, 'order_status', 'Order Status'),
(NULL, 'billing_date', 'Billing Date'),
(NULL, 'cancel_reason', 'Cancel Reason'),
(NULL, 'customer_order', 'Customer Notes'),
(NULL, 'customerpicktime', 'Customer Pick-up Date and time'),
(NULL, 'size', 'Size'),
(NULL, 'qty', 'Quantity'),
(NULL, 'foodnote', 'Food Note'),
(NULL, 'addnotesi', 'Add Note'),
(NULL, 'sl_payment', 'Select Your Payment Method'),
(NULL, 'paymd', 'Payment Method'),
(NULL, 'crd_terminal', 'Card Terminal'),
(NULL, 'sl_bank', 'Select Bank'),
(NULL, 'lstdigit', 'Last 4 Digit'),
(NULL, 'cuspayment', 'Customer Payment'),
(NULL, 'cng_amount', 'Changes Amount'),
(NULL, 'pay_print', 'Pay Now & Print Invoice'),
(NULL, 'payn', 'Pay Now'),
(NULL, 'ordid', 'Order ID'),
(NULL, 'can_reason', 'Cancel Reason'),
(NULL, 'can_ord', 'Cancel Order'),
(NULL, 'add_customer', 'Add Customer'),
(NULL, 'fav_addesrr', 'Favorite Address'),
(NULL, 'nw_order', 'New Order'),
(NULL, 'ongoingorder', 'On Going Order'),
(NULL, 'tdayorder', 'Today Order'),
(NULL, 'onlineord', 'Online Order'),
(NULL, 'kitchen_status', 'Kitchen Status'),
(NULL, 'all', 'All'),
(NULL, 'del_company', 'Delivery Company'),
(NULL, 'thirdparty_orderid', 'Third-party Order ID'),
(NULL, 'vat_tax1', 'Vat/Tax'),
(NULL, 'quickorder', 'Quick Order'),
(NULL, 'placeorder', 'Place Order'),
(NULL, 'update_group_item', 'pdate Group Item'),
(NULL, 'addons_qty', 'Add-ons Qty'),
(NULL, 'add_to_cart', 'Add To cart'),
(NULL, 'add_to_cart_more', 'Add Multiple Variant'),
(NULL, 'select_this_table', 'Select This Table'),
(NULL, 'seat', 'Seat'),
(NULL, 'ord', 'Order'),
(NULL, 'seat_time', 'Time'),
(NULL, 'no_customer', 'No Customer'),
(NULL, 'mergeord', 'Merge Order'),
(NULL, 'before_time', 'Running Time'),
(NULL, 'cmplt', 'Complete'),
(NULL, 'split', 'Split'),
(NULL, 'no_order_run', 'No Order Running'),
(NULL, 'sl_product', 'Search Product'),
(NULL, 'ord_places', 'Order Placed Successfully'),
(NULL, 'do_print_in', 'Do you Want to Print Invoice???'),
(NULL, 'ord_complte', 'Order Completed'),
(NULL, 'ord_com_sucs', 'Order Completed Successfully'),
(NULL, 'token_no', 'Token NO'),
(NULL, 'ord_failed', 'Order Failed!!!'),
(NULL, 'failed_msg', 'Order not placed due to some reason. Please Try Again!!!. Thank You !!!'),
(NULL, 'ord_succ', 'Order Placed Successfully!!!'),
(NULL, 'succ_smg', 'Are you Sure to Print This Invoice????'),
(NULL, 'sl_option', 'Select Option'),
(NULL, 'req_failed', 'Request Failed, Please check your code and try again!'),
(NULL, 'person', 'Person'),
(NULL, 'ord_number', 'Order No.'),
(NULL, 'add_new_payment_type', 'Add New Payment Method'),
(NULL, 'discount_type', 'Discount Type'),
(NULL, 'type_slorder', 'Type and Select Order'),
(NULL, 'type_table', 'Type and Select Table'),
(NULL, 'Processingod', 'Processing...'),
(NULL, 'sLengthMenu', 'Display _MENU_ records per page'),
(NULL, 'sInfo', 'Showing _START_ to _END_ of _TOTAL_ entries'),
(NULL, 'sInfoEmpty', 'Showing 0 to 0 of 0 entries'),
(NULL, 'sInfoFiltered', '(Filtered from _MAX_ Total Records)'),
(NULL, 'sLoadingRecords', 'Loading...'),
(NULL, 'sZeroRecords', 'Nothing found - sorry'),
(NULL, 'sEmptyTable', 'No Data Available in Table'),
(NULL, 'sFirst', 'First'),
(NULL, 'sLast', 'Last'),
(NULL, 'sPrevious', 'Previous'),
(NULL, 'sNext', 'Next'),
(NULL, 'sSortAscending', 'Activate to sort column ascending'),
(NULL, 'sSortDescending', 'Activate to Sort Column Descending'),
(NULL, '_sign', 'Show %d Rows'),
(NULL, '_0sign', 'No Row Selected'),
(NULL, '_1sign', '1 Line Selected'),
(NULL, 'copy', 'Copy'),
(NULL, 'excel', 'Excel'),
(NULL, 'pdf', 'Pdf'),
(NULL, 'colvis', 'Colvis'),
(NULL, 'csv', 'CSV'),
(NULL, 'tok', 'Token'),
(NULL, 'clear', 'Clear'),
(NULL, 'shipping_name', 'Shipping Method Name'),
(NULL, 'shippingtime', 'Shipping Date & Time'),
(NULL, 'select_doc_type', 'Select Doc Type'),
(NULL, 'update_fooditem', 'Update Food Item'),
(NULL, 'split_order', 'Split Order'),
(NULL, 'table_manage', 'Manage Table'),
(NULL, 'table_list', 'Table List'),
(NULL, 'table_setting', 'Table Setting'),
(NULL, 'add_new_table', 'Add Table'),
(NULL, 'table_name', 'Table Name'),
(NULL, 'floor_select', 'Floor Select'),
(NULL, 'table_edit', 'Update Table'),
(NULL, 'res_table_setup', 'Restaurant Table Setup'),
(NULL, 'customertype_list', 'Customer Type List'),
(NULL, 'list_of_card_terminal', 'Card Terminal List'),
(NULL, 'add_new_terminal', 'Add New Terminal'),
(NULL, 'update_terminal', 'Update Terminal'),
(NULL, 'list_of_bank', 'Bank List'),
(NULL, 'add_bank', 'Add New Bank'),
(NULL, 'update_bank', 'Update Bank'),
(NULL, 'bank_name', 'Bank Name');

INSERT INTO `customer_type` (`customer_type`, `ordering`) VALUES('Walk In Customer', 1);
INSERT INTO `customer_type` (`customer_type`, `ordering`) VALUES('Online Customer', 1);
INSERT INTO `customer_type` (`customer_type`, `ordering`) VALUES('Third Party', 0);
INSERT INTO `customer_type` (`customer_type`, `ordering`) VALUES('Take Way', 0);
INSERT INTO `customer_type` (`customer_type`, `ordering`) VALUES('QR Customer', 0);
INSERT INTO `customer_type` (`customer_type`, `ordering`) VALUES('Hotel Customer', 1);

INSERT INTO `tbl_bank` (`bankid`, `bank_name`, `ac_name`, `ac_number`, `branch`, `signature_pic`) VALUES(2, 'City Bank', 'Kamal Hassan', '3869583', 'Uttara', './application/modules/hrm/assets/images/2020-01-18/e.jpg');
INSERT INTO `tbl_card_terminal` (`card_terminalid`, `terminal_name`) VALUES(1, 'Nexus Terminal');
INSERT INTO `tbl_posetting` (`possettingid`, `waiter`, `tableid`, `cooktime`, `productionsetting`, `tablemaping`, `soundenable`) VALUES(1, 1, 1, 1, 0, 1, 1);
INSERT INTO `tbl_quickordersetting` (`quickordid`, `waiter`, `tableid`, `cooktime`, `soundenable`, `tablemaping`) VALUES(1, 1, 1, 1, 1, 1);
INSERT INTO `tbl_soundsetting` (`soundid`, `nofitysound`, `addtocartsound`) VALUES(1, 'assets/2021-03-21/b1.mp3', 'h');
INSERT INTO `position` (`pos_id`, `position_name`, `position_details`) VALUES(9, 'Waiter', 'Restaurant Waiter');

INSERT INTO `acc_coa` (`HeadCode`, `HeadName`, `PHeadName`, `HeadLevel`, `IsActive`, `IsTransaction`, `IsGL`, `HeadType`, `IsBudget`, `IsDepreciation`, `DepreciationRate`, `CreateBy`, `CreateDate`, `UpdateBy`, `UpdateDate`)
 VALUES('30303', 'Restaurant Food', 'Service', 2, 1, 1, 0, 'I', 0, 0, '0.00', '1', '2021-10-02 16:52:31', '', '0000-00-00 00:00:00');

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
VALUES ('ordermanage', '', 'ordermanage', '0', '0', '1', '2021-09-06 00:00:00');

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'pos_invoice', 'pos-invoice', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'ordermanage';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'order_list', 'order-list', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'ordermanage';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'pending_order', 'pending-order', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'ordermanage';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'complete_order', 'complete-list', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'ordermanage';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'cancel_order', 'cancel-list', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'ordermanage';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'kitchen_dashboard', 'kitchen', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'ordermanage';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'counter_dashboard', 'counter-board', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'ordermanage';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'counter_list', 'counter-list', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'ordermanage';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'pos_setting', 'pos-setting', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'ordermanage';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'sound_setting', 'sound-setting', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'ordermanage';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'table_manage', 'restauranttable', 'ordermanage', '0', '0', '1', '2021-09-06 00:00:00';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'table_list', 'table-list', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'table_manage';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'table_setting', 'table-setting', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'table_manage';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'customer_type', 'customertype', 'ordermanage', '0', '0', '1', '2021-09-06 00:00:00';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'customertype_list', 'customer-type', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'customer_type';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'list_of_card_terminal', 'card-terminal', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'customer_type';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'manage_category', 'item_category', 'ordermanage', '0', '0', '1', '2021-09-06 00:00:00';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'add_category', 'category-create', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'manage_category';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'category_list', 'category-list', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'manage_category';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'manage_food', 'item_food', 'ordermanage', '0', '0', '1', '2021-09-06 00:00:00';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'add_food', 'food-create', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'manage_food';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'food_list', 'food-list', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'manage_food';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'add_group_item', 'food-groop-create', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'manage_food';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'food_varient', 'food-varient-list', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'manage_food';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'food_availablity', 'food-available-list', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'manage_food';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'menu_type', 'today-menu-type', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'manage_food';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'manage_addons', 'menu_addons', 'ordermanage', '0', '0', '1', '2021-09-06 00:00:00';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'add_adons', 'menu-addons-create', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'manage_addons';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'addons_list', 'menu-addons-list', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'manage_addons';

INSERT INTO `sec_menu_item` (`menu_title`, `page_url`, `module`, `parent_menu`, `is_report`, `createby`, `createdate`) 
SELECT 'assign_adons_list', 'assign-menu-addons', 'ordermanage', sec_menu_item.menu_id, '0', '1', '2021-09-06 00:00:00' 
FROM sec_menu_item WHERE sec_menu_item.menu_title = 'manage_addons';

ALTER TABLE user ADD waiter_kitchenToken TEXT NULL DEFAULT NULL AFTER device_token;

