D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
salvation.incrediblebengal.com
/
admin
/
database
/
Filename :
encode_restro.sql
back
Copy
-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Apr 12, 2022 at 04:11 PM -- Server version: 10.4.21-MariaDB -- PHP Version: 7.4.23 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `encode_restro` -- -- -------------------------------------------------------- -- -- Table structure for table `additional_expenses` -- CREATE TABLE `additional_expenses` ( `exp_id` int(11) NOT NULL, `exp_purpose` varchar(100) NOT NULL, `exp_type` varchar(50) NOT NULL, `exp_date` datetime NOT NULL, `exp_amount` int(11) NOT NULL, `exp_mode` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `additional_expenses` -- INSERT INTO `additional_expenses` (`exp_id`, `exp_purpose`, `exp_type`, `exp_date`, `exp_amount`, `exp_mode`) VALUES (1, 'renovation of restaurent', 'renovate', '2022-01-02 18:00:00', 50000, 'UPI'), (5, 'qwfreyfdxb bnhgjrdbdf', 'ergtrb argr', '2022-01-03 20:00:00', 32000, 'cheque'); -- -------------------------------------------------------- -- -- Table structure for table `customer_details` -- CREATE TABLE `customer_details` ( `customer_id` int(11) NOT NULL, `customer_name` varchar(50) NOT NULL, `customer_phone` bigint(15) NOT NULL, `customer_address` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `customer_details` -- INSERT INTO `customer_details` (`customer_id`, `customer_name`, `customer_phone`, `customer_address`) VALUES (126, 'jhg jyryt', 6876515165, 'slg'), (127, 'K Kumar', 9465436546, 'sliguri'), (128, 'arnab kar', 6734201016, 'Mallaguri'), (129, 'Manab Roy', 3464187943, 'Jalpaiguri'), (130, 'navin', 9649816515, 'slg'), (131, 'K Mangalam', 8735403216, 'Jalpaiguri'), (132, 'Dipak Shah', 6968721350, 'Siliguri'), (133, 'Shakti Pandey', 9584871210, 'hakim Para'), (134, 'P K reddy', 1654065056, 'Bagdogra'), (135, 'S Chhetri', 165795454, 'Shiv Mandir'), (136, 'G K Puri', 2498784651, 'Siliguri'), (137, 'G K Puri', 2498784651, 'Siliguri'), (138, 'kjgf jydttfcg', 4671316357, 'jktyhgd fghfc'), (139, 'RK Ray', 8759321560, 'Matigara'), (140, 'Rakesh Saha', 2164956429, 'Siliguri'), (141, 'ggyu gygug', 3354661644, 'kmghjhghub igyuy'), (142, 'kashi raj', 2542165468, 'sil;iguri'), (143, 'kashi raj', 2542165468, 'siliguri'), (144, 'Samudr gupta', 6832465756, 'siliguri'), (145, 'Samudr gupta', 6587410101, 'siliguri'), (146, 'kush raj', 6832465657, 'siliguri'), (147, 'afor apple', 6551478514, 'siliguri'), (148, 'kashi raj', 9541201452, 'siliguri'), (149, 'kashi raj', 9541201452, 'siliguri'), (150, 'jgyf jgfjyg', 6542103872, 'kgfjhgv kgyvkuygfjf'), (151, 'fdthf yjtfytcvjy', 5678651561, 'rdhf yjtfutrdfytfyd'), (152, 'jfyu uyguyfd ', 4654165198, 'sliguri'), (153, 'Aadi Rajan', 6724968498, 'Siliguri'), (154, 'kamal Kar', 8448165184, 'siliguri'), (155, 'anupam singh', 5498987988, 'siliguri'), (156, 'anupam singh', 5498987988, 'siliguri'), (157, 'anupam singh', 5498987988, 'siliguri'), (158, 'ab gaazi', 7865566657, 'Siliguri'), (159, 'J P Narayan', 7816515054, 'Siliguri'), (160, 'K Gopal', 8418475012, 'siliguri'), (161, 'A Niwas', 8721324632, 'siliguri'), (162, 'T Ravi', 4062416461, 'Siliguri'), (163, 'M. Pintu', 6879871320, 'siliguri'), (164, 'Tanya Ravi', 6875165468, 'Siliguri'), (165, 'R K Rao', 9867510160, 'Siliguri'), (166, 'shehnaj Gill', 8465761321, 'siliguri'), (167, 'K vishwas', 8478546328, 'siliguri'), (168, 'K Madhav', 8451215702, 'Siliguri'), (171, 'M MAdhav', 4535573385, 'siliguri'), (172, 'J Poddar', 9584878152, 'Siliguri'), (173, '', 0, ''), (174, 'Santosh Singh', 7216516503, 'Siliguri'), (175, 'S Maharaj', 9584712014, 'siliguri'), (176, 'C Mishra', 6952035491, 'siliguri'), (177, 'hghg kjuhi', 3549845415, 'kjyguy '), (178, 'N V Shekhar', 9871511004, 'Siliguri'), (179, 'abc', 8498165165, 'dfsd'), (180, 'S Sarkar', 8574125510, 'siliguri'), (181, 'R L Burnwal', 6855415410, 'Siliguri, Pradhan Nagar'), (185, 'R Madhav', 3487303616, 'siliguri'), (186, 'B Roy', 6548422200, 'Siliguri'), (187, 'K Narayan', 5140211787, 'Agra'), (188, 'Sharvan Shah', 9587178959, 'Siliguri, Matigara'), (189, 'Gautam Sharma', 6548785410, 'Siliguri, Pradhan Nagar'), (190, 'p ghosh', 6354965161, 'Siliguri'), (191, 'P Kumar', 9865849165, 'Siliguri, Champasari'), (192, 'R Pradhan', 9148720652, 'Siliguri, Subhash Pally'), (193, 'Anamika', 9876543210, 'Siliguri'), (194, 'Manab Roy', 3464187943, 'Jalpaiguri'), (195, 'R K Rao', 9867510160, 'Siliguri'), (196, 'Shaktidas', 9541351302, 'SLG, Mallaguri'), (197, 'ab gaazi', 7865566657, 'Siliguri'), (198, 'S Maharaj', 9584712014, 'siliguri'), (199, 'M. Chandra', 9354654631, 'Siliguri, Uttorayon'), (200, 'C Samantha', 6546546576, 'Siliguri, College para'), (201, 'M Bishwas', 9135431321, 'Siliguri, Matigara'), (202, 'B K Sarkar', 8475112225, 'Siliguri, Ashram Para'), (203, 'Arijit Kar', 7458995514, 'Siliguri, Shanti Nagar'), (204, 'Navin Patidar', 9584712035, 'Jalpaiguri'), (205, 'Prashant Shah', 9656546516, 'Siliguri'), (206, '', 0, 'Siliguri, Matigara'), (207, '', 0, 'Siliguri, Matigara'), (208, '', 0, 'Siliguri, Matigara'), (209, '', 0, 'Siliguri, Matigara'), (210, '', 0, 'Siliguri, Matigara'), (211, '', 0, 'Siliguri, Matigara'), (212, '', 0, 'Siliguri, Matigara'), (221, 'G Gpoal', 9865424654, 'Checkpost, Siliguri'), (222, 'Pritish Sharma', 5898766576, 'Siliguri'), (223, 'Priyam Pal', 6876434656, 'Shiv Mandir, Siliguri'), (224, 'Vidya Rani', 3986465465, 'Jalpaiguri'), (225, 'Anshu Gupta', 6546658897, 'Santoshi Nagar, Siliguri'), (226, 'Mridula Pradhan', 3869865354, 'Checkpost, Siliguri'), (227, 'Rishi Banarjee', 9321631660, 'njp, siliguri'), (228, 'Anup Singh', 6658635468, 'Siliguri'), (229, 'Vaibhav Sharma', 6466546874, 'Siliguri'), (230, 'Ramesh Jha', 6546559879, 'Shiv Mandir, Siliguri'), (231, 'Bhanu', 6879842157, 'Delhi'), (232, 'Priyam Pradhan', 8766080986, 'Shiv Mandir, Siliguri'), (233, 'V Singh', 5746446546, 'Checkpost, Siliguri'), (234, 'ballabh Sarkar', 5676541654, 'Shishudangi, siliguri'), (235, 'vikash ', 9879321657, 'Siliguri'), (236, 'M Krishnan', 6786341968, 'Bagdogra, Siliguri'), (237, ' Pankaj Thakur', 6764649849, 'Adarsh Nagar, Siliguri'), (238, 'Sneha Thakur', 6546461616, 'Adarsh Nagar, Siliguri'), (239, 'Pujan Yadav', 6876546549, 'Mahananda Colony, Siliguri'), (240, 'Z Prasad', 3687646546, 'NJP Gate Bazar'), (241, 'Suman Prasad', 6384684946, 'Shishudangi, siliguri'), (242, 'jhug', 6587656587, 'yhtyhggcyhg'), (243, 'Parthiv Patel', 6546875614, 'Siliguri'), (244, 'Sawan Singh', 6476976465, 'Subhah Pally, Slg'), (245, 'Pradeep Shaw', 4656871331, 'Pradhan Nagar, Siliguri'), (246, 'shubhash Gupta', 5464612365, 'Patiramjote, Matigara'), (247, 'anjali Krishna', 9813530465, 'khaprail Bazar, Siliguri'), (248, 'Vyas Yadav', 3547641634, 'Matigara, siliguri'), (249, 'radhe shyam ', 6468765464, 'Siliguri'), (250, 'R. D. Tiwari', 6546657684, 'Adarsh Nagar, Siliguri'), (251, 'jkhghj jhg', 3546545845, 'slg'), (252, 'lknjkonh kjhjk', 1265765165, 'slg'), (253, 'Sonu Singh', 4686498784, 'Siliguri'), (254, 'P Pandey', 6387154653, 'Siliguri'), (255, 'S Lama', 3546663578, 'Checkpost, Siliguri'), (256, 'M Singh', 3546464687, 'Siliguri'), (257, 'Jolly Singh', 6587665468, 'Checkpost, Siliguri'), (258, 'V Ganesh', 3587534654, 'Shiv Mandir, Siliguri'), (259, 'Raj Tanwir', 1234535768, 'Shiv Mandir, Siliguri'), (260, 'P K Thakur', 6788464690, 'Adarsh Nagar, Siliguri'), (261, 'Anup Thakur', 6360063143, 'Siliguri'), (262, 'Sapna Yadav', 6547965654, 'Shishudangi, siliguri'), (263, 'A P Madan', 6584646354, 'Siliguri'), (264, 'J Kumar', 3546465479, 'Shiv Mandir, Siliguri'); -- -------------------------------------------------------- -- -- Table structure for table `customer_enquiry` -- CREATE TABLE `customer_enquiry` ( `enquiry_id` int(11) NOT NULL, `enquiry_name` varchar(50) NOT NULL, `enquiry_phone` varchar(15) NOT NULL, `enquiry_subject` varchar(100) NOT NULL, `enquiry_person` int(11) NOT NULL, `enquiry_msg` varchar(500) NOT NULL, `enquiry_doc` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `customer_enquiry` -- INSERT INTO `customer_enquiry` (`enquiry_id`, `enquiry_name`, `enquiry_phone`, `enquiry_subject`, `enquiry_person`, `enquiry_msg`, `enquiry_doc`) VALUES (1, 'enq_name', 'enq_phone', 'enq_subject', 0, 'enq_msg', 'enq_doc'), (2, 'Bhole Shankar', '6784542413', 'Buffet Booking', 21, 'Buffet Booking for Birthday Party at 24/01/2022 night 10PM.', 'Print Order Details __ Encode Restro.pdf'), (3, 'Kunal Poddar', '6754658465', 'Booking Birth Day Party', 6, 'jyguy gy tfyt giuyf yty urf tfuy.', 'Print Order Details __ Encode Restro.pdf'), (4, 'Ramesh Prasad', '8676324684', 'Buffet Biiking', 50, 'jyufg ugf yhvugfv 01/02/2022 at 9pm to 12pm.', 'secondry.jpg'), (5, 'kgh hghb', '4313243546', 'knhjh kuhgu 34565hgf y', 20, ' frbtgbr sr btd dudshtrshaet.', 'Diploma-Certificate.jpg'), (6, 'kalike', '9887464687', 'kg kugkuyg', 1000, 'kuyguy hgiuytgiuygu yfyutdfrt6fguy.', 'high-school-diploma-certificate.jpg'), (7, 'saFGAER', '3546543543', 'hgfhvhjgf', 50, 'dsgtdr.', 'sonu-10th-doc.jpg'), (8, 'Utkarsh', '9998898989', 'jhkuhg bkuyguigkh', 75, 'kjhgu kkihguygkguyg.', 'Encode Restaurent - Admin Dashboard.pdf'), (9, 'Ratnesh Ray', '2724657696', 'Birthday Celebration', 10, 'fyhgjhgvj hgjhgjhgjh gjygfjyfgjvgh.', 'sg-brochure.txt'); -- -------------------------------------------------------- -- -- Table structure for table `delivery_cart` -- CREATE TABLE `delivery_cart` ( `serial_id` int(11) NOT NULL, `order_type` varchar(50) NOT NULL, `food_id` int(11) NOT NULL, `food_name` varchar(50) NOT NULL, `food_price` int(11) NOT NULL, `food_qty` int(11) NOT NULL, `food_subtotal` int(11) NOT NULL, `order_date` varchar(50) NOT NULL, `customer_phone` bigint(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `delivery_order` -- CREATE TABLE `delivery_order` ( `order_id` int(11) NOT NULL, `customer_phone` bigint(20) NOT NULL, `total_payment` varchar(50) NOT NULL, `order_type` varchar(50) NOT NULL, `order_status` varchar(50) NOT NULL, `order_date` varchar(50) DEFAULT NULL, `waiter_name` varchar(20) NOT NULL, `customer_ip` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `delivery_order` -- INSERT INTO `delivery_order` (`order_id`, `customer_phone`, `total_payment`, `order_type`, `order_status`, `order_date`, `waiter_name`, `customer_ip`) VALUES (103, 6786341968, '200.00', 'take-away', 'running', '2022-03-07', 'Warner', '::1'), (104, 6764649849, '200.00', 'take-away', 'running', '2022-03-07', 'Warner', '::1'), (105, 6546461616, '200.00', 'take-away', 'running', '2022-03-07', 'Warner', '::1'), (106, 6876546549, '650.00', 'take-away', 'running', '2022-03-07', 'Warner', '::1'), (107, 3687646546, '210.00', 'take-away', 'running', '2022-03-08', 'Warner', '::1'), (108, 6384684946, '2000.00', 'take-away', 'running', '2022-03-08', 'Warner', '::1'), (109, 6546875614, '540.00', 'take-away', 'paid', '2022-03-11', 'Warner', '::1'), (110, 6476976465, '583.00', 'take-away', 'paid', '2022-03-12', 'Warner', '::1'), (111, 4656871331, '300.00', 'take-away', 'running', '2022-03-12', 'Warner', '::1'), (112, 5464612365, '150.00', 'take-away', 'paid', '2022-03-14', 'Warner', '::1'), (113, 9813530465, '1916.00', 'take-away', 'paid', '2022-03-14', 'Warner', '::1'), (114, 3547641634, '1290.00', 'take-away', 'paid', '2022-03-25', 'Warner', '::1'), (115, 6468765464, '390.00', 'take-away', 'paid', '2022-03-17', 'Warner', '::1'), (116, 6587665468, '130.00', 'take-away', 'paid', '2022-03-25', 'Warner', '::1'), (117, 3587534654, '660.00', 'take-away', 'paid', '2022-03-25', 'Warner', '127.0.0.1'), (118, 1234535768, '120.00', 'take-away', 'paid', '2022-03-28', 'Warner', '::1'), (119, 6547965654, '498.00', 'take-away', 'paid', '2022-03-29', 'Warner', '::1'); -- -------------------------------------------------------- -- -- Table structure for table `delivery_orderlist` -- CREATE TABLE `delivery_orderlist` ( `serial_id` int(11) NOT NULL, `order_id` int(11) NOT NULL, `order_type` varchar(50) DEFAULT NULL, `food_id` int(11) NOT NULL, `food_name` varchar(100) NOT NULL, `food_price` int(11) NOT NULL, `food_qty` int(11) NOT NULL, `food_subtotal` int(11) NOT NULL, `order_date` varchar(50) NOT NULL, `customer_phone` bigint(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `delivery_orderlist` -- INSERT INTO `delivery_orderlist` (`serial_id`, `order_id`, `order_type`, `food_id`, `food_name`, `food_price`, `food_qty`, `food_subtotal`, `order_date`, `customer_phone`) VALUES (117, 106, 'take-away', 2, 'Fry Momo(8pc)', 50, 2, 100, '2022-03-07', 6876546549), (118, 106, 'take-away', 5, 'Egg Roll', 50, 2, 100, '2022-03-07', 6876546549), (123, 106, 'take-away', 14, 'Vanila Icecream', 75, 2, 150, '2022-03-07', 6876546549), (124, 106, 'take-away', 12, 'Ice Cream', 50, 1, 50, '2022-03-07', 6876546549), (125, 106, 'take-away', 7, 'Chicken Biryani', 150, 3, 450, '2022-03-07', 6876546549), (126, 107, 'take-away', 4, 'Chicken Roll', 80, 1, 80, '2022-03-08', 3687646546), (127, 107, 'take-away', 2, 'Fry Momo(8pc)', 50, 1, 50, '2022-03-08', 3687646546), (128, 107, 'take-away', 13, 'Chocolate Icecream', 80, 1, 80, '2022-03-08', 3687646546), (132, 108, 'take-away', 7, 'Chicken Biryani', 150, 5, 750, '2022-03-08', 6384684946), (133, 108, 'take-away', 19, 'Chicken Tangadi', 200, 5, 1000, '2022-03-08', 6384684946), (134, 108, 'take-away', 12, 'Ice Cream', 50, 5, 250, '2022-03-08', 6384684946), (135, 109, 'take-away', 25, 'Fry Rice(200g)', 30, 3, 90, '2022-03-11', 6546875614), (136, 109, 'take-away', 18, 'Chiken Curry', 150, 3, 450, '2022-03-11', 6546875614), (137, 110, 'take-away', 24, 'Plain Rice (250g)', 20, 3, 60, '2022-03-12', 6476976465), (138, 110, 'take-away', 21, 'paneer tikka masala', 179, 2, 358, '2022-03-12', 6476976465), (139, 110, 'take-away', 23, 'gobi-masala', 165, 1, 165, '2022-03-12', 6476976465), (149, 111, 'take-away', 16, 'Samosa Chat', 60, 4, 240, '2022-03-12', 4656871331), (150, 111, 'take-away', 11, 'masala tea', 15, 4, 60, '2022-03-12', 4656871331), (151, 112, 'take-away', 14, 'Vanila Icecream', 75, 2, 150, '2022-03-14', 5464612365), (152, 113, 'take-away', 7, 'Chicken Biryani', 150, 4, 600, '2022-03-14', 9813530465), (153, 113, 'take-away', 18, 'Chiken Curry', 150, 4, 600, '2022-03-14', 9813530465), (154, 113, 'take-away', 21, 'paneer tikka masala', 179, 4, 716, '2022-03-14', 9813530465), (155, 114, 'take-away', 7, 'Chicken Biryani', 150, 3, 450, '2022-03-25', 3547641634), (156, 114, 'take-away', 18, 'Chiken Curry', 150, 2, 300, '2022-03-25', 3547641634), (157, 114, 'take-away', 17, 'Chiken Tikka', 180, 3, 540, '2022-03-25', 3547641634), (161, 115, 'take-away', 3, 'Veg Roll', 30, 1, 30, '2022-03-17', 6468765464), (162, 115, 'take-away', 6, 'Motton Roll', 100, 3, 300, '2022-03-17', 6468765464), (163, 115, 'take-away', 11, 'masala tea', 15, 4, 60, '2022-03-17', 6468765464), (164, 116, 'take-away', 4, 'Chicken Roll', 80, 1, 80, '2022-03-25', 6587665468), (165, 116, 'take-away', 12, 'Ice Cream', 50, 1, 50, '2022-03-25', 6587665468), (166, 117, 'take-away', 7, 'Chicken Biryani', 150, 4, 600, '2022-03-25', 3587534654), (167, 117, 'take-away', 25, 'Fry Rice(200g)', 30, 2, 60, '2022-03-25', 3587534654), (168, 118, 'take-away', 15, 'Masala Chat', 50, 2, 100, '2022-03-28', 1234535768), (169, 118, 'take-away', 10, 'milk tea', 10, 2, 20, '2022-03-28', 1234535768), (170, 119, 'take-away', 21, 'paneer tikka masala', 179, 2, 358, '2022-03-29', 6547965654), (171, 119, 'take-away', 24, 'Plain Rice (250g)', 20, 2, 40, '2022-03-29', 6547965654), (172, 119, 'take-away', 12, 'Ice Cream', 50, 2, 100, '2022-03-29', 6547965654); -- -------------------------------------------------------- -- -- Table structure for table `dinein_order` -- CREATE TABLE `dinein_order` ( `order_id` int(11) NOT NULL, `table_id` int(11) NOT NULL, `customer_phone` bigint(20) NOT NULL, `total_payment` int(11) NOT NULL, `order_status` varchar(50) NOT NULL, `order_date` varchar(50) NOT NULL, `waiter_name` varchar(20) NOT NULL, `customer_ip` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `dinein_order` -- INSERT INTO `dinein_order` (`order_id`, `table_id`, `customer_phone`, `total_payment`, `order_status`, `order_date`, `waiter_name`, `customer_ip`) VALUES (199, 8, 6466546874, 728, 'paid', '2022-03-02', 'Warner', '::1'), (200, 2, 6546559879, 200, 'paid', '2022-03-02', 'Warner', '::1'), (201, 1, 6879842157, 330, 'paid', '2022-03-03', 'Warner', '::1'), (202, 2, 8766080986, 660, 'paid', '2022-03-03', 'Warner', '::1'), (203, 2, 5746446546, 45, 'paid', '2022-03-03', 'Warner', '::1'), (204, 1, 6587656587, 320, 'running', '2022-03-08', 'Warner', '::1'), (205, 2, 6546657684, 430, 'paid', '2022-03-17', 'Warner', '::1'), (206, 1, 3546545845, 240, 'paid', '2022-03-17', 'Warner', '::1'), (207, 3, 1265765165, 560, 'paid', '2022-03-17', 'Warner', '::1'), (208, 2, 4686498784, 1167, 'paid', '2022-03-21', 'Warner', '::1'), (209, 4, 6387154653, 230, 'paid', '2022-03-22', 'Warner', '::1'), (210, 5, 3546663578, 1681, 'paid', '2022-03-23', 'Warner', '::1'), (211, 4, 3546464687, 420, 'paid', '2022-03-23', 'Warner', '::1'), (212, 1, 6788464690, 898, 'paid', '2022-03-28', 'Warner', '::1'), (213, 3, 6360063143, 1530, 'paid', '2022-03-28', 'Warner', '::1'), (214, 5, 6584646354, 900, 'paid', '2022-03-29', 'Warner', '127.0.0.1'), (215, 2, 3546465479, 60, 'paid', '2022-03-29', 'Warner', '127.0.0.1'); -- -------------------------------------------------------- -- -- Table structure for table `dinein_order_items` -- CREATE TABLE `dinein_order_items` ( `serial_id` int(11) NOT NULL, `order_id` int(11) NOT NULL, `table_id` int(11) NOT NULL, `food_id` int(11) NOT NULL, `food_name` varchar(50) NOT NULL, `food_price` int(11) NOT NULL, `food_qty` int(11) NOT NULL, `food_subtotal` int(11) NOT NULL, `order_date` varchar(50) NOT NULL, `customer_phone` bigint(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `dinein_order_items` -- INSERT INTO `dinein_order_items` (`serial_id`, `order_id`, `table_id`, `food_id`, `food_name`, `food_price`, `food_qty`, `food_subtotal`, `order_date`, `customer_phone`) VALUES (412, 200, 2, 5, 'Egg Roll', 50, 2, 100, '2022-03-02', 6546559879), (413, 200, 2, 15, 'Masala Chat', 50, 3, 150, '2022-03-02', 6546559879), (414, 201, 1, 2, 'Fry Momo(8pc)', 50, 3, 150, '2022-03-03', 6879842157), (415, 201, 1, 15, 'Masala Chat', 50, 3, 150, '2022-03-03', 6879842157), (416, 201, 1, 8, 'red tea', 10, 3, 30, '2022-03-03', 6879842157), (417, 202, 2, 17, 'Chiken Tikka', 180, 2, 360, '2022-03-03', 8766080986), (418, 202, 2, 18, 'Chiken Curry', 150, 2, 300, '2022-03-03', 8766080986), (430, 207, 3, 2, 'Fry Momo(8pc)', 50, 2, 100, '2022-03-17', 1265765165), (431, 207, 3, 15, 'Masala Chat', 50, 2, 100, '2022-03-17', 1265765165), (432, 207, 3, 17, 'Chiken Tikka', 180, 2, 360, '2022-03-17', 1265765165), (442, 209, 4, 5, 'Egg Roll', 50, 3, 150, '2022-03-22', 6387154653), (443, 209, 4, 4, 'Chicken Roll', 80, 1, 80, '2022-03-22', 6387154653), (444, 210, 5, 24, 'Plain Rice (250g)', 20, 4, 80, '2022-03-23', 3546663578), (445, 210, 5, 23, 'gobi-masala', 165, 4, 660, '2022-03-23', 3546663578), (446, 210, 5, 21, 'paneer tikka masala', 179, 4, 716, '2022-03-23', 3546663578), (447, 210, 5, 12, 'Ice Cream', 50, 3, 150, '2022-03-23', 3546663578), (449, 210, 5, 14, 'Vanila Icecream', 75, 1, 75, '2022-03-23', 3546663578), (450, 211, 4, 2, 'Fry Momo(8pc)', 50, 2, 100, '2022-03-23', 3546464687), (453, 211, 4, 8, 'red tea', 10, 2, 20, '2022-03-23', 3546464687), (454, 211, 4, 7, 'Chicken Biryani', 150, 2, 300, '2022-03-23', 3546464687), (455, 212, 1, 24, 'Plain Rice (250g)', 20, 3, 60, '2022-03-28', 6788464690), (456, 212, 1, 18, 'Chiken Curry', 150, 5, 750, '2022-03-28', 6788464690), (457, 212, 1, 17, 'Chiken Tikka', 180, 1, 180, '2022-03-28', 6788464690), (459, 212, 1, 21, 'paneer tikka masala', 179, 2, 358, '2022-03-28', 6788464690), (460, 213, 3, 7, 'Chicken Biryani', 150, 5, 750, '2022-03-28', 6360063143), (461, 213, 3, 18, 'Chiken Curry', 150, 5, 750, '2022-03-28', 6360063143), (463, 213, 3, 11, 'masala tea', 15, 2, 30, '2022-03-28', 6360063143), (465, 214, 5, 7, 'Chicken Biryani', 150, 3, 450, '2022-03-29', 6584646354), (466, 214, 5, 18, 'Chiken Curry', 150, 3, 450, '2022-03-29', 6584646354), (467, 215, 2, 11, 'masala tea', 15, 4, 60, '2022-03-29', 3546465479); -- -------------------------------------------------------- -- -- Table structure for table `food_item` -- CREATE TABLE `food_item` ( `food_id` int(11) NOT NULL, `food_name` varchar(50) NOT NULL, `food_price` int(11) NOT NULL, `food_unit` varchar(50) NOT NULL, `food_qty` int(11) NOT NULL, `food_stock` int(11) NOT NULL, `food_category` varchar(50) NOT NULL, `food_img` varchar(300) NOT NULL, `food_status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `food_item` -- INSERT INTO `food_item` (`food_id`, `food_name`, `food_price`, `food_unit`, `food_qty`, `food_stock`, `food_category`, `food_img`, `food_status`) VALUES (1, 'Veg Momo (8pc)', 30, 'Plate', 50, 100, 'fast-food', 'momo.png', 1), (2, 'Fry Momo(8pc)', 50, 'plate', 10, 50, 'fast-food', 'fried-momo.png', 1), (3, 'Veg Roll', 30, 'piece', 58, 100, 'fast-food', 'plane-roll.png', 1), (4, 'Chicken Roll', 80, 'piece', 53, 200, 'fast-food', 'chicken-roll.png', 1), (5, 'Egg Roll', 50, 'piece', 36, 50, 'fast-food', 'egg-roll.png', 1), (6, 'Motton Roll', 100, 'piece', 95, 100, 'fast-food', 'motton-roll.png', 1), (7, 'Chicken Biryani', 150, 'plate', 500, 500, 'non-veg', 'panir-chowmin.png', 1), (8, 'red tea', 10, 'cup', 200, 500, 'beverage', 'lemon-tea.jfif', 1), (9, 'lemon tea', 10, 'cup', 50, 200, 'beverage', 'lemon-tea.jfif', 1), (10, 'milk tea', 10, 'cup', 50, 500, 'beverage', 'milk-tea.png', 1), (11, 'masala tea', 15, 'cup', 500, 20, 'beverage', 'milk-tea.png', 1), (12, 'Ice Cream', 50, 'glass', 50, 100, 'desert', 'ice-cream.png', 1), (13, 'Chocolate Icecream', 80, 'glass', 5, 20, 'desert', 'chocolate-icecream.png', 1), (14, 'Vanila Icecream', 75, 'glass', 3, 20, 'desert', 'vanilla-icecream.png', 1), (15, 'Masala Chat', 50, 'plate', 5, 50, 'fast-food', 'masala-chat.jfif', 1), (16, 'Samosa Chat', 60, 'plate', 0, 50, 'fast-food', 'samosa-chat.jfif', 1), (17, 'Chiken Tikka', 180, 'plate', 6, 30, 'non-veg', 'chicken-tikka.png', 1), (18, 'Chiken Curry', 150, 'plate', 76, 20, 'non-veg', 'chicken-curry.png', 1), (19, 'Chicken Tangadi', 200, 'plate', 37, 50, 'non-veg', 'chicken-tangdi.png', 1), (20, 'veg burger', 70, 'plate', 0, 0, 'veg, fast-food', 'veg-burger.png', 1), (21, 'paneer tikka masala', 179, 'plate', 36, 0, 'veg', 'paneer-tikka-masala.jpg', 1), (22, 'paneer tikka', 149, 'plate', 2, 0, 'veg', 'paneer-tikka.png', 1), (23, 'gobi-masala', 165, 'plate', 22, 0, 'veg', 'gobi-masala.jpg', 1), (24, 'Plain Rice (250g)', 20, 'plate', 38, 0, 'mains', 'main-rice.jpg', 1), (25, 'Fry Rice(200g)', 30, 'plate', 51, 0, 'mains', 'fry-rice.jpg', 1); -- -------------------------------------------------------- -- -- Table structure for table `kitchen_orderlist` -- CREATE TABLE `kitchen_orderlist` ( `kot_id` int(11) NOT NULL, `kot_status` varchar(10) NOT NULL DEFAULT '0', `cust_phone` varchar(15) NOT NULL, `order_id` int(11) NOT NULL, `order_date` date NOT NULL, `order_type` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `kitchen_orderlist` -- INSERT INTO `kitchen_orderlist` (`kot_id`, `kot_status`, `cust_phone`, `order_id`, `order_date`, `order_type`) VALUES (29, '0', '9465436546', 26, '2021-12-07', 'dine_in'), (30, '1', '6734201016', 27, '2021-12-07', 'dine_in'), (31, '0', '3464187943', 13, '2021-12-07', 'pickup'), (32, '0', '9649816515', 28, '2021-12-07', 'dine_in'), (33, '0', '8735403216', 29, '2021-12-10', 'dine_in'), (34, '0', '8735403216', 30, '2021-12-10', 'dine_in'), (35, '0', '8735403216', 31, '2021-12-10', 'dine_in'), (36, '0', '8735403216', 32, '2021-12-10', 'dine_in'), (37, '0', '8735403216', 33, '2021-12-10', 'dine_in'), (38, '0', '6968721350', 34, '2021-12-10', 'dine_in'), (39, '0', '9584871210', 35, '2021-12-10', 'dine_in'), (40, '0', '9584871210', 36, '2021-12-10', 'dine_in'), (41, '0', '9584871210', 37, '2021-12-10', 'dine_in'), (42, '0', '9584871210', 38, '2021-12-10', 'dine_in'), (43, '0', '9584871210', 39, '2021-12-10', 'dine_in'), (44, '0', '9584871210', 40, '2021-12-10', 'dine_in'), (45, '0', '9584871210', 41, '2021-12-10', 'dine_in'), (46, '0', '9584871210', 42, '2021-12-10', 'dine_in'), (47, '0', '1654065056', 43, '2021-12-10', 'dine_in'), (48, '0', '1654065056', 44, '2021-12-10', 'dine_in'), (49, '0', '1654065056', 45, '2021-12-10', 'dine_in'), (50, '0', '1654065056', 46, '2021-12-10', 'dine_in'), (51, '0', '0165795454', 47, '2021-12-10', 'dine_in'), (52, '0', '0165795454', 48, '2021-12-10', 'dine_in'), (53, '0', '0165795454', 49, '2021-12-10', 'dine_in'), (54, '0', '0165795454', 50, '2021-12-10', 'dine_in'), (55, '0', '0165795454', 51, '2021-12-10', 'dine_in'), (56, '0', '0165795454', 52, '2021-12-10', 'dine_in'), (57, '0', '0165795454', 53, '2021-12-10', 'dine_in'), (58, '0', '0165795454', 54, '2021-12-10', 'dine_in'), (59, '0', '2498784651', 55, '2021-12-10', 'dine_in'), (60, '0', '2498784651', 56, '2021-12-10', 'dine_in'), (61, '0', '4671316357', 57, '2021-12-10', 'dine_in'), (62, '0', '8759321560', 14, '2021-12-10', 'pickup'), (63, '0', '2164956429', 58, '2021-12-11', 'dine_in'), (64, '0', '3354661644', 59, '2021-12-11', 'dine_in'), (65, '0', '2542165468', 15, '2021-12-24', 'pickup'), (66, '0', '6832465756', 16, '2021-12-27', 'pickup'), (67, '0', '6832465756', 17, '2021-12-27', 'pickup'), (68, '0', '6832465756', 18, '2021-12-27', 'pickup'), (69, '0', '6832465756', 19, '2021-12-27', 'pickup'), (70, '0', '6587410101', 60, '2021-12-27', 'dine_in'), (71, '0', '6587410101', 61, '2021-12-27', 'dine_in'), (72, '0', '6587410101', 62, '2021-12-27', 'dine_in'), (73, '0', '6587410101', 63, '2021-12-27', 'dine_in'), (74, '0', '6587410101', 64, '2021-12-27', 'dine_in'), (75, '0', '6587410101', 65, '2021-12-27', 'dine_in'), (76, '0', '6587410101', 66, '2021-12-27', 'dine_in'), (77, '0', '6587410101', 67, '2021-12-27', 'dine_in'), (78, '0', '6587410101', 68, '2021-12-27', 'dine_in'), (79, '0', '6587410101', 69, '2021-12-27', 'dine_in'), (80, '0', '6587410101', 70, '2021-12-27', 'dine_in'), (81, '0', '6587410101', 71, '2021-12-27', 'dine_in'), (82, '0', '6587410101', 72, '2021-12-27', 'dine_in'), (83, '0', '6587410101', 73, '2021-12-27', 'dine_in'), (84, '0', '6587410101', 74, '2021-12-27', 'dine_in'), (85, '0', '6587410101', 75, '2021-12-27', 'dine_in'), (86, '0', '6587410101', 76, '2021-12-27', 'dine_in'), (87, '0', '6587410101', 77, '2021-12-27', 'dine_in'), (88, '0', '6587410101', 78, '2021-12-27', 'dine_in'), (89, '0', '6587410101', 79, '2021-12-27', 'dine_in'), (90, '0', '6587410101', 80, '2021-12-27', 'dine_in'), (91, '0', '6832465657', 20, '2021-12-27', 'pickup'), (92, '0', '6832465657', 21, '2021-12-27', 'pickup'), (93, '0', '6832465657', 22, '2021-12-27', 'pickup'), (94, '0', '6832465657', 23, '2021-12-27', 'pickup'), (95, '0', '6832465657', 24, '2021-12-27', 'pickup'), (96, '0', '6832465657', 25, '2021-12-27', 'pickup'), (97, '0', '6832465657', 26, '2021-12-27', 'pickup'), (98, '0', '6832465657', 27, '2021-12-27', 'pickup'), (99, '0', '6832465657', 28, '2021-12-27', 'pickup'), (100, '0', '6832465657', 29, '2021-12-27', 'pickup'), (101, '0', '6832465657', 30, '2021-12-27', 'pickup'), (102, '0', '6832465657', 31, '2021-12-27', 'pickup'), (103, '0', '6832465657', 32, '2021-12-27', 'pickup'), (104, '0', '6832465657', 33, '2021-12-27', 'pickup'), (105, '0', '6551478514', 34, '2021-12-27', 'pickup'), (106, '0', '9541201452', 35, '2022-01-04', 'pickup'), (107, '0', '6542103872', 36, '2022-01-05', 'pickup'), (108, '0', '5678651561', 37, '2022-01-05', 'pickup'), (109, '0', '4654165198', 81, '2022-01-05', 'dine_in'), (110, '0', '6724968498', 82, '2022-01-05', 'dine_in'), (111, '0', '8448165184', 83, '2022-01-06', 'dine_in'), (112, '0', '7865566657', 84, '2022-01-17', 'dine_in'), (113, '0', '7865566657', 85, '2022-01-17', 'dine_in'), (114, '0', '7865566657', 86, '2022-01-17', 'dine_in'), (115, '0', '7816515054', 87, '2022-01-17', 'dine_in'), (116, '0', '7816515054', 88, '2022-01-17', 'dine_in'), (117, '0', '7816515054', 89, '2022-01-17', 'dine_in'), (118, '0', '7816515054', 90, '2022-01-17', 'dine_in'), (119, '0', '7816515054', 0, '2022-01-17', 'dine_in'), (120, '0', '7816515054', 87, '2022-01-17', 'dine_in'), (121, '1', '', 0, '2022-01-18', ''), (122, '0', '8418475012', 91, '2022-01-18', 'dine_in'), (123, '0', '8721324632', 92, '2022-01-18', 'dine_in'), (124, '0', '4062416461', 93, '2022-01-18', 'dine_in'), (125, '0', '6879871320', 94, '2022-01-19', 'dine_in'), (126, '0', '6875165468', 95, '2022-01-19', 'dine_in'), (127, '0', '6875165468', 0, '2022-01-19', ''), (128, '1', '', 0, '2022-01-20', ''), (129, '0', '9867510160', 96, '2022-01-20', 'dine_in'), (130, '0', '8465761321', 97, '2022-01-20', 'dine_in'), (131, '1', '6952035491', 98, '2022-01-28', 'dine_in'), (132, '0', '9584873216', 104, '2022-02-01', 'dine_in'), (133, '0', '3487303616', 0, '2022-02-01', 'dine_in'), (134, '0', '6548422200', 0, '2022-02-02', 'dine_in'), (135, '1', '9587178959', 38, '2022-02-07', 'take-away'), (151, '0', '6548785410', 54, '2022-02-07', 'take-away'), (152, '0', '6354965161', 0, '2022-02-07', 'dine_in'), (153, '0', '9865849165', 55, '2022-02-08', 'take-away'), (154, '0', '9865849165', 56, '2022-02-08', 'take-away'), (155, '0', '9865849165', 57, '2022-02-08', 'take-away'), (156, '0', '9865849165', 58, '2022-02-08', 'take-away'), (157, '0', '9865849165', 59, '2022-02-08', 'take-away'), (158, '0', '9865849165', 60, '2022-02-08', 'take-away'), (159, '0', '9865849165', 61, '2022-02-08', 'take-away'), (160, '0', '9865849165', 62, '2022-02-08', 'take-away'), (161, '0', '9865849165', 63, '2022-02-08', 'take-away'), (162, '0', '9865849165', 64, '2022-02-08', 'take-away'), (163, '0', '9148720652', 65, '2022-02-08', 'take-away'), (164, '0', '9148720652', 66, '2022-02-08', 'take-away'), (165, '0', '9876543210', 0, '2022-02-15', 'dine_in'), (166, '0', '9876543210', 67, '2022-02-15', 'take-away'), (167, '0', '9867510160', 68, '2022-02-16', 'take-away'), (168, '0', '9867510160', 69, '2022-02-16', 'take-away'), (169, '0', '9867510160', 70, '2022-02-16', 'take-away'), (170, '0', '9867510160', 71, '2022-02-16', 'take-away'), (171, '0', '9867510160', 72, '2022-02-16', 'take-away'), (172, '0', '9867510160', 73, '2022-02-16', 'take-away'), (173, '0', '9867510160', 74, '2022-02-16', 'take-away'), (174, '0', '9867510160', 75, '2022-02-16', 'take-away'), (175, '0', '9867510160', 76, '2022-02-16', 'take-away'), (176, '0', '9867510160', 77, '2022-02-16', 'take-away'), (177, '0', '9867510160', 78, '2022-02-16', 'take-away'), (178, '0', '9867510160', 79, '2022-02-16', 'take-away'), (179, '0', '9867510160', 80, '2022-02-16', 'take-away'), (180, '0', '9541351302', 0, '2022-02-16', 'dine_in'), (181, '0', '7865566657', 81, '2022-02-16', 'take-away'), (182, '0', '7865566657', 82, '2022-02-16', 'take-away'), (183, '0', '7865566657', 83, '2022-02-16', 'take-away'), (184, '0', '9584712014', 84, '2022-02-16', 'take-away'), (185, '0', '9354654631', 85, '2022-02-16', 'take-away'), (186, '0', '9354654631', 86, '2022-02-16', 'take-away'), (187, '0', '9135431321', 87, '2022-02-17', 'take-away'), (188, '0', '8475112225', 88, '2022-02-17', 'take-away'), (189, '0', '8475112225', 89, '2022-02-17', 'take-away'), (190, '0', '9656546516', 0, '2022-02-19', 'dine_in'), (191, '0', '', 0, '2022-03-01', ''), (192, '0', '3869865354</br>', 0, '2022-03-01', ''), (193, '0', '3869865354</br>', 0, '2022-03-01', 'dine_in'), (194, '0', '3869865354</br>', 0, '2022-02-28', 'dine_in'), (195, '0', '6466546874</br>', 0, '2022-03-02', 'dine_in'), (196, '0', '6546559879</br>', 0, '2022-03-02', 'dine_in'), (197, '0', '6879842157</br>', 201, '2022-03-03', 'dine_in'), (198, '0', '8766080986</br>', 200, '2022-03-02', 'dine_in'), (199, '0', '5746446546</br>', 200, '2022-03-02', 'dine_in'), (200, '0', '6546875614', 109, '2022-03-11', ''), (201, '0', '6476976465', 110, '2022-03-12', 'take-away'), (202, '0', '5464612365', 112, '2022-03-14', 'take-away'), (203, '0', '9813530465', 113, '2022-03-14', 'take-away'), (204, '0', '6546657684</br>', 200, '2022-03-02', 'dine_in'), (205, '0', '6468765464', 115, '2022-03-17', 'take-away'), (206, '0', '4686498784</br>', 200, '2022-03-02', 'dine_in'), (207, '0', '4686498784</br>', 200, '0000-00-00', 'dine_in'), (208, '0', '6387154653</br>', 0, '0000-00-00', 'dine_in'), (209, '0', '6387154653</br>', 209, '2022-03-22', 'dine_in'), (210, '0', '', 0, '0000-00-00', 'dine_in'), (211, '0', '3546663578</br>', 210, '2022-03-23', 'dine_in'), (212, '0', '3546464687</br>', 211, '2022-03-23', 'dine_in'), (213, '0', '1265765165</br>', 207, '2022-03-17', 'dine_in'), (214, '0', '3546545845</br>', 206, '2022-03-17', 'dine_in'), (215, '0', '3587534654', 117, '2022-03-25', 'take-away'), (216, '0', '6587665468', 116, '2022-03-25', 'take-away'), (217, '0', '3547641634', 114, '2022-03-25', 'take-away'), (218, '0', '6360063143</br>', 213, '2022-03-28', 'dine_in'), (219, '0', '1234535768', 118, '2022-03-28', 'take-away'), (220, '0', '6788464690</br>', 212, '2022-03-28', 'dine_in'), (221, '0', '6584646354</br>', 214, '2022-03-29', 'dine_in'), (222, '0', '3546465479</br>', 215, '2022-03-29', 'dine_in'), (223, '0', '6547965654', 119, '2022-03-29', 'take-away'); -- -------------------------------------------------------- -- -- Table structure for table `pay_orders` -- CREATE TABLE `pay_orders` ( `p_id` int(11) NOT NULL, `order_id` varchar(50) NOT NULL, `razorpay_payment_id` varchar(50) NOT NULL, `status` varchar(50) NOT NULL, `phone` bigint(15) NOT NULL, `name` varchar(50) NOT NULL, `price` int(11) NOT NULL, `order_date` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `pay_orders` -- INSERT INTO `pay_orders` (`p_id`, `order_id`, `razorpay_payment_id`, `status`, `phone`, `name`, `price`, `order_date`) VALUES (20, 'order_IUE3BmwaqwK5Vk', 'pay_IUE3Jm2yZYX0Zh', 'success', 8787878787, 'kali singh', 100, '2021-12-06 12:00:00:am'), (21, 'order_IUECV897VxFiQE', 'pay_IUECf46ZLKfzit', 'success', 9595959595, 'hmgfyg', 190, ''), (22, 'order_IUVZ1vUqCHNheZ', 'pay_IUVZAoGT2CA9FB', 'success', 9898982013, 'R prasad', 85, ''), (23, 'order_IUVoSmJBF7NNob', 'pay_IUVpIqpRrsJvTp', 'success', 8984750750, 'B. Sarkar', 1450, ''), (24, 'order_IUW9KspaT4YugF', 'pay_IUW9ZBlRH9RXX9', 'success', 7897891010, 'C Shekhar', 495, ''), (25, 'order_IUWETXq21gw4f8', 'pay_IUWEbmH9tAfCXK', 'success', 6731311331, 'M. Shami', 60, ''), (26, 'order_IUWTGePo1hQTR8', 'pay_IUWTkAGAmHeuwW', 'success', 9879842136, 'K. Ray', 460, ''), (27, 'order_IUWfyBnctAtmao', 'pay_IUWgWT7NEXPJan', 'success', 6403031771, 'C. Kumar', 1195, ''), (28, 'order_IUWnjgY1ddz39U', 'pay_IUWnsU5y4Atwnq', 'success', 8973102658, 'B Gupta', 120, ''), (29, 'order_IUXmssRMDraVIy', 'pay_IUXvGgJiOBKX5S', 'success', 7986686320, 'P Raja', 150, ''), (30, 'order_IUYuYNGgLAbSDO', 'pay_IUYumNjBDk3dTz', 'success', 6846546316, 'P Parker', 360, ''), (31, 'order_IUZ8DdpoKWklf1', 'pay_IUZ8LOPyb8aF6A', 'success', 9825825811, 'Kali Singh', 75, ''), (32, 'order_IUaMvWj25QtAqS', 'pay_IUaN31LkuTKdof', 'success', 8264796130, 'dhiraj Adhikari', 195, ''), (33, 'order_IUaSwzoiwSRuXT', 'pay_IUaT3T1Ghoulht', 'success', 6876515165, 'jhg jyryt', 160, ''), (34, 'order_IUaZZQYpk5m36k', 'pay_IUaZg51sy1z9dk', 'success', 9465436546, 'K Kumar', 240, ''), (35, 'order_IUaZZQYpk5m36k', 'pay_IUaZg51sy1z9dk', 'success', 9465436546, 'K Kumar', 240, ''), (36, 'order_IUb1tc7L0pGUdV', 'pay_IUb29wiqZXJdWd', 'success', 6734201016, 'arnab kar', 990, ''), (37, 'order_IUbJQtMdc3Kv3C', 'pay_IUbJXisVjQLSVU', 'success', 3464187943, 'Manab Roy', 1050, ''), (38, 'order_IUdFsUSZSyQWcw', 'pay_IUdG1Q1EO2ZiuZ', 'success', 9649816515, 'navin', 100, ''), (39, 'order_IVjTIcKCaFA0au', 'pay_IVjTRDNtT7ij1Z', 'success', 8735403216, 'K Mangalam', 60, ''), (40, 'order_IVmBYDpVyaNkxH', 'pay_IVmBgClnprsbmC', 'success', 6968721350, 'Dipak Shah', 300, ''), (41, 'order_IVmF0VCZpLGyBs', 'pay_IVmF6yPFPjMKQL', 'success', 9584871210, 'Shakti Pandey', 560, ''), (42, 'order_IVmLLN1EClkUmZ', 'pay_IVmLTkKGc0mtj8', 'success', 1654065056, 'P K reddy', 240, ''), (43, 'order_IVmZ47ZpVWRSEn', 'pay_IVmZBEzU2GmNKz', 'success', 165795454, 'S Chhetri', 675, ''), (44, 'order_IVmu38ebET8lNH', 'pay_IVmuAPZL5jUxzm', 'success', 2498784651, 'G K Puri', 200, ''), (45, 'order_IVmzGLgBN54sSM', 'pay_IVmzN8V5gyGI1X', 'success', 4671316357, 'kjgf jydttfcg', 1340, ''), (46, 'order_IVn6WR6Gzy3wiA', 'pay_IVn6mKMi6NgcGu', 'success', 8759321560, 'RK Ray', 825, ''), (47, 'order_IW7vgS2V6l0i5k', 'pay_IW7vw4xcRL9X9n', 'success', 2164956429, 'Rakesh Saha', 300, ''), (48, 'order_IWANgk22BjoMtG', 'pay_IWANpGDcBTcmv9', 'success', 3354661644, 'ggyu gygug', 60, ''), (49, 'order_IbFj6v8ABp5zeN', 'pay_IbFjHjI7ojZEMv', 'success', 2542165468, 'kashi raj', 560, ''), (50, 'order_IcVaoYispe2t1S', 'pay_IcVawnn2rloqYy', 'success', 6832465756, 'Samudr gupta', 620, ''), (51, 'order_IcVnerM9Vgc6MG', 'pay_IcVnm9FJPgMgFi', 'success', 6587410101, 'Samudr gupta', 160, ''), (52, 'order_IcWlSUoWgn8Cil', 'pay_IcWlnkU0goEJua', 'success', 6832465657, 'kush raj', 100, ''), (53, 'order_IcWlSUoWgn8Cil', 'pay_IcWlnkU0goEJua', 'success', 6832465657, 'kush raj', 100, ''), (54, 'order_IcWtQSxDwraghf', 'pay_IcWtXHO9iM96Ax', 'success', 6832465657, 'kush raj', 100, ''), (55, 'order_IcXBwcWdw3ciQI', 'pay_IcXC6RywoO35j3', 'success', 6551478514, 'afor apple', 75, ''), (56, 'order_IfdX3xRdcd3sNd', 'pay_IfdXDVp7aKzICK', 'success', 9541201452, 'kashi raj', 130, ''), (57, 'order_IfzG0ZtDCHoCqv', 'pay_IfzG8hS5ii5l0z', 'success', 6542103872, 'jgyf jgfjyg', 225, ''), (58, 'order_IfzGwkY9MboWD9', 'pay_IfzH4SEBJtkAv3', 'success', 5678651561, 'fdthf yjtfytcvjy', 80, ''), (59, 'order_Ig4giYXvTY5NZj', 'pay_Ig4gqL2Wq4cFWv', 'success', 4654165198, 'jfyu uyguyfd ', 285, ''), (60, 'order_Ig4jLiCOZRgcTm', 'pay_Ig4jUGcx5D2dLC', 'success', 6724968498, 'Aadi Rajan', 808, ''), (61, 'order_IgTU61v10jJijy', 'pay_IgTUEFcaXU9iS6', 'success', 8448165184, 'kamal Kar', 200, ''), (62, 'order_IkmgrrklUZ9WNU', 'pay_Ikmh0EQDbNKES0', 'success', 7865566657, 'ab gaazi', 585, ''), (63, 'order_IknSdmcBztDkAi', 'pay_IknSncKOOB7ndo', 'success', 7816515054, 'J P Narayan', 750, ''), (64, 'order_IlD12PBB8ZIiiy', 'pay_IlD5GQK1rs2FVP', 'success', 8418475012, 'K Gopal', 380, ''), (65, 'order_IlDTwYhjBav80g', 'pay_IlDU98sceHWoyA', 'success', 8721324632, 'A Niwas', 100, ''), (66, 'order_IlEWsnwVBzCfpJ', 'pay_IlEX2t2RMgZqzZ', 'success', 4062416461, 'T Ravi', 1645, ''), (67, 'order_IlaXLXCROndEaa', 'pay_IlaXTd8rMqfG3A', 'success', 6879871320, 'M. Pintu', 285, ''), (68, 'order_Ilb0FjALbFiUJE', 'pay_Ilb0OGkw1Oc5fA', 'success', 6875165468, 'Tanya Ravi', 850, ''), (69, 'order_Ilhzv4VpOe7VAV', 'pay_Ili03vSRr8PKZm', 'success', 9867510160, 'R K Rao', 120, ''), (70, 'order_IlwL2qjaZvqKDD', 'pay_IlwLACDGRuENrq', 'success', 8465761321, 'shehnaj Gill', 595, ''), (71, 'order_Ip9L90g5i9rkzl', 'pay_Ip9LIjIWjsAsSY', 'success', 6952035491, 'C Mishra', 750, ''), (72, 'order_IpbsejeMgBCEk0', 'pay_IpbsqM22iVwltb', 'success', 6855415410, 'R L Burnwal', 360, ''), (73, 'order_IqgjUI3gWHLBhL', 'pay_IqgjmHA8Q5OfJx', 'success', 9584873216, 'm Swami', 750, ''), (74, 'order_IqlBnCmpLcuQ5v', 'pay_IqlBvED50XzCYJ', 'success', 3487303616, 'R Madhav', 180, ''), (75, 'order_Ir75yjAdn0X8uG', 'pay_Ir767HHOj7eHWB', 'success', 6548422200, 'B Roy', 1140, ''), (76, 'order_Ir8xE993i0hebn', 'pay_Ir8xx1SVugLfjF', 'success', 5140211787, 'K Narayan', 250, ''), (77, 'order_Ir8xE993i0hebn', 'pay_Ir8xx1SVugLfjF', 'success', 5140211787, 'K Narayan', 250, ''), (78, 'order_Ir8xE993i0hebn', 'pay_Ir8xx1SVugLfjF', 'success', 5140211787, 'K Narayan', 250, ''), (79, 'order_Ir8xE993i0hebn', 'pay_Ir8xx1SVugLfjF', 'success', 5140211787, 'K Narayan', 250, ''), (80, '', '', 'success', 0, '', 0, ''), (81, 'order_It34rbcdJBJGV2', 'pay_It35AWJbEBJCLW', 'success', 9587178959, 'Sharvan Shah', 185, '2022-02-07'), (82, 'order_It34rbcdJBJGV2', 'pay_It35AWJbEBJCLW', 'success', 9587178959, 'Sharvan Shah', 185, '2022-02-07'), (83, 'order_It34rbcdJBJGV2', 'pay_It35AWJbEBJCLW', 'success', 9587178959, 'Sharvan Shah', 185, '2022-02-07'), (84, 'order_It34rbcdJBJGV2', 'pay_It35AWJbEBJCLW', 'success', 9587178959, 'Sharvan Shah', 185, '2022-02-07'), (85, 'order_It34rbcdJBJGV2', 'pay_It35AWJbEBJCLW', 'success', 9587178959, 'Sharvan Shah', 185, '2022-02-07'), (86, 'order_It8ZStmnjIdqCR', 'pay_It8ZjG7YkCYWya', 'success', 6548785410, 'Gautam Sharma', 1587, '2022-02-07'), (87, 'order_ItBCn8JTox4gtU', 'pay_ItBCvLBrtnq4mL', 'success', 6354965161, 'p ghosh', 260, '2022-02-07'), (88, 'order_ItROjCfAvIJUyj', 'pay_ItRP7Ud0WpW5H2', 'success', 9865849165, 'P Kumar', 330, '2022-02-08'), (89, 'order_ItWZ7NcPQKvIME', 'pay_ItWcuR3kgENCaM', 'success', 9148720652, 'R Pradhan', 450, '2022-02-08'), (90, 'order_Ixr8527gGG0hJr', 'pay_Ixr8G0dDtbjAQ5', 'success', 9656546516, 'Prashant Shah', 1500, '2022-02-19'), (91, 'order_J2BB72MJ6PFdKt', 'pay_J2BBNL2cT2gA04', 'success', 0, '', 0, '2022-03-02'), (92, 'order_J2BB72MJ6PFdKt', 'pay_J2BBNL2cT2gA04', 'success', 0, '', 0, '2022-03-02'), (93, 'order_J2BEkOGQnSQU0f', 'pay_J2BEpzQv1oqBVI', 'success', 6466546874, 'Vaibhav Sharma', 0, '2022-03-02'), (94, 'order_J2BGNM25aFlFDd', 'pay_J2BGTmmSVc26E1', 'success', 6466546874, 'Vaibhav Sharma', 764, '2022-03-02'), (95, 'order_J2BGNM25aFlFDd', 'pay_J2BGTmmSVc26E1', 'success', 6466546874, 'Vaibhav Sharma', 764, '2022-03-02'), (96, 'order_J2BHvd6iZDhNac', 'pay_J2BV2ug77N3uQU', 'success', 6466546874, 'Vaibhav Sharma', 764, '2022-03-02'), (97, 'order_J2BrQQp3UwkXFa', 'pay_J2BrXhjp47usrX', 'success', 6466546874, 'Vaibhav Sharma', 764, '2022-03-02'), (98, 'order_J2DKahcWPVoerb', 'pay_J2DL66g3lrb2gu', 'success', 6466546874, 'Vaibhav Sharma', 764, '2022-03-02'), (99, 'order_J2Dyi4o4XE6li7', 'pay_J2DyttPNuzzJN1', 'success', 6546559879, 'Ramesh Jha', 764, '2022-03-02'), (100, 'order_J2E1QKyNOmhDxD', 'pay_J2E1sZf567MhLs', 'success', 6546559879, 'Ramesh Jha', 764, '2022-03-02'), (101, 'order_J506aCwfCq3qQH', 'pay_J507IC0fvPcNBv', 'success', 6384684946, '', 0, '2022-03-09'), (102, 'order_J6uNAXbeptg2ow', 'pay_J6uNTcWtv6TbiD', 'success', 9813530465, '', 0, '2022-03-14'), (103, 'order_J6uPauIXprblkN', 'pay_J6uPkXmdWvfS1o', 'success', 9813530465, '', 0, '2022-03-14'), (104, 'order_J6vMmFiGjrVrbs', 'pay_J6vPN6HRbZxLlL', 'success', 9813530465, '', 0, '2022-03-14'), (105, 'order_J6vMmFiGjrVrbs', 'pay_J6vPN6HRbZxLlL', 'success', 9813530465, '', 0, '2022-03-14'), (106, 'order_J6vMmFiGjrVrbs', 'pay_J6vPN6HRbZxLlL', 'success', 9813530465, '', 0, '2022-03-14'), (107, 'order_J6vTpWdZf2bVSO', 'pay_J6vUBzTZfEJfW3', 'success', 9813530465, '', 0, '2022-03-14'), (108, 'order_J6vTpWdZf2bVSO', 'pay_J6vUBzTZfEJfW3', 'success', 9813530465, '', 0, '2022-03-14'), (109, 'order_J6vYJMWjFXL8rO', 'pay_J6vYTAztz3P7cs', 'success', 9813530465, '', 0, '2022-03-14'), (110, 'order_J6vi2KOFNgMuLm', 'pay_J6vnpoII3NRc3z', 'success', 9813530465, '', 0, '2022-03-14'), (111, 'order_J6vi2KOFNgMuLm', 'pay_J6vnpoII3NRc3z', 'success', 9813530465, '', 0, '2022-03-14'), (112, 'order_J6vxUotR943bWO', 'pay_J6vzuvRfqsVJWw', 'success', 9813530465, '', 0, '2022-03-14'), (113, 'order_J6w3RcKWL9djVH', 'pay_J6w3aigoBtyNyz', 'success', 9813530465, 'anjali Krishna', 0, '2022-03-14'), (114, 'order_J6w3RcKWL9djVH', 'pay_J6w3aigoBtyNyz', 'success', 9813530465, 'anjali Krishna', 0, '2022-03-14'), (115, 'order_J6w9PWFWSUYoZr', 'pay_J6w9z5F4klo1Cv', 'success', 9813530465, 'anjali Krishna', 2012, '2022-03-14'), (116, 'order_J6w9PWFWSUYoZr', 'pay_J6w9z5F4klo1Cv', 'success', 9813530465, 'anjali Krishna', 2012, '2022-03-14'), (117, 'order_J6wIoYbAKFVbMX', 'pay_J6wIv5ach3ELFU', 'success', 5464612365, 'shuybhash Gupta', 158, '2022-03-14'), (118, 'order_J6wLwKg9dLLNPa', 'pay_J6wM2pJQL7qy9G', 'success', 5464612365, 'shubhash Gupta', 158, '2022-03-14'), (119, 'order_J6wPSrMPpALoge', 'pay_J6xZhMN5jlvf0j', 'success', 5464612365, 'shubhash Gupta', 158, '2022-03-14'), (120, 'order_J6xaOcRW7m2tMW', 'pay_J6xaWEH64iRunf', 'success', 9813530465, 'anjali Krishna', 2012, '2022-03-14'), (121, 'order_J8BGTcJQRrImYf', 'pay_J8BGcr255tp9QC', 'success', 6546657684, 'R. D. Tiwari', 452, '2022-03-17'), (122, 'order_J8BGTcJQRrImYf', 'pay_J8BGcr255tp9QC', 'success', 6546657684, 'R. D. Tiwari', 452, '2022-03-17'), (123, 'order_J8BGTcJQRrImYf', 'pay_J8BGcr255tp9QC', 'success', 6546657684, 'R. D. Tiwari', 452, '2022-03-17'), (124, 'order_J8BGTcJQRrImYf', 'pay_J8BGcr255tp9QC', 'success', 6546657684, 'R. D. Tiwari', 452, '2022-03-17'), (125, 'order_J8BGTcJQRrImYf', 'pay_J8BGcr255tp9QC', 'success', 6546657684, 'R. D. Tiwari', 452, '2022-03-17'), (126, 'order_J8BM3y9DwTsW0Y', 'pay_J8BMBeZusiZQQl', 'success', 6546657684, 'R. D. Tiwari', 452, '2022-03-17'), (127, 'order_J8BM3y9DwTsW0Y', 'pay_J8BMBeZusiZQQl', 'success', 6546657684, 'R. D. Tiwari', 452, '2022-03-17'), (128, 'order_J8BM3y9DwTsW0Y', 'pay_J8BMBeZusiZQQl', 'success', 6546657684, 'R. D. Tiwari', 452, '2022-03-17'), (129, 'order_J8D7suxW2xJrTk', 'pay_J8D83YVkH7xwma', 'success', 6468765464, 'radhe shyam ', 410, '2022-03-17'), (130, 'order_J8BGTcJQRrImYf', '', 'success', 6546657684, 'R. D. Tiwari', 452, '2022-03-21'), (131, 'order_JAV1QRYBm4TyCL', 'pay_JAV1YulPJ9NkUP', 'success', 1265765165, 'lknjkonh kjhjk', 588, '2022-03-23'), (132, 'order_JAV1QRYBm4TyCL', 'pay_JAV1YulPJ9NkUP', 'success', 1265765165, 'lknjkonh kjhjk', 588, '2022-03-23'), (133, 'order_JAV1QRYBm4TyCL', 'pay_JAV1YulPJ9NkUP', 'success', 1265765165, 'lknjkonh kjhjk', 588, '2022-03-23'), (134, 'order_JAV1QRYBm4TyCL', 'pay_JAV1YulPJ9NkUP', 'success', 1265765165, 'lknjkonh kjhjk', 588, '2022-03-23'), (135, 'order_JAV1QRYBm4TyCL', 'pay_JAV1YulPJ9NkUP', 'success', 1265765165, 'lknjkonh kjhjk', 588, '2022-03-23'), (136, 'order_JAV1QRYBm4TyCL', 'pay_JAV1YulPJ9NkUP', 'success', 1265765165, 'lknjkonh kjhjk', 588, '2022-03-23'), (137, 'order_JAV1QRYBm4TyCL', 'pay_JAV1YulPJ9NkUP', 'success', 1265765165, 'lknjkonh kjhjk', 588, '2022-03-23'), (138, 'order_JAZBZHxDTKUNtE', 'pay_JAZBj9WQJ5bKvg', 'success', 3546663578, 'S Lama', 1765, '2022-03-23'), (139, 'order_JBIWe8FY3aNfYr', 'pay_JBIWmbe4fulpxe', 'success', 6587665468, 'Jolly Singh', 137, '2022-03-25'), (140, 'order_JBKHPFJFD2O9PQ', 'pay_JBKHWFRcfOiNHY', 'success', 3547641634, 'Vyas Yadav', 1355, '2022-03-25'), (141, 'order_JCVYq9dHH5emwJ', 'pay_JCVYxrhWvkMrsT', 'success', 6360063143, 'Anup Thakur', 1607, '2022-03-28'), (142, 'order_JCVaCnQbHsZB4Y', 'pay_JCVaLPNb5KSXkq', 'success', 6788464690, 'P K Thakur', 943, '2022-03-28'), (143, 'order_JCVaiTeLc7Oa1R', 'pay_JCVaqBRpE9tWz1', 'success', 1234535768, 'Raj Tanwir', 126, '2022-03-28'), (144, 'order_JCsrWAoEyKpAz8', 'pay_JCsriqBqdhmtIF', 'success', 6788464690, 'P K Thakur', 943, '2022-03-29'), (145, 'order_JCt0f9oEdIgQ4L', 'pay_JCt0n8v1LfBe4R', 'success', 6788464690, 'P K Thakur', 943, '2022-03-29'), (146, 'order_JCt0f9oEdIgQ4L', 'pay_JCt0n8v1LfBe4R', 'success', 6788464690, 'P K Thakur', 943, '2022-03-29'), (147, 'order_JCt0f9oEdIgQ4L', 'pay_JCt0n8v1LfBe4R', 'success', 6788464690, 'P K Thakur', 943, '2022-03-29'), (148, 'order_JCt0f9oEdIgQ4L', 'pay_JCt0n8v1LfBe4R', 'success', 6788464690, 'P K Thakur', 943, '2022-03-29'), (149, 'order_JCt0f9oEdIgQ4L', 'pay_JCt0n8v1LfBe4R', 'success', 6788464690, 'P K Thakur', 943, '2022-03-29'), (150, 'order_JCtoWwQ6hFZA3s', 'pay_JCtr2KbldBWcyq', 'success', 6788464690, 'P K Thakur', 943, '2022-03-29'), (151, 'order_JCtxpBPbNWLVNc', 'pay_JCtxvwti5srghk', 'success', 6788464690, 'P K Thakur', 943, '2022-03-29'), (152, 'order_JCuYxvanFLpGzj', 'pay_JCuZ8gJZJjXrhO', 'success', 6788464690, 'P K Thakur', 0, '2022-03-29'), (153, 'order_JCuwZZAFAm1ats', 'pay_JCv1IhdAG8qYhJ', 'success', 6788464690, 'P K Thakur', 0, '2022-03-29'), (154, 'order_JCuwZZAFAm1ats', 'pay_JCv1IhdAG8qYhJ', 'success', 6788464690, 'P K Thakur', 0, '2022-03-29'), (155, 'order_JCv2xalf5D23pO', 'pay_JCv3ql0l0EQyro', 'success', 6788464690, 'P K Thakur', 0, '2022-03-29'), (156, 'order_JCvbJXdfDko8kh', 'pay_JCvdoFnd4oejO2', 'success', 6584646354, 'A P Madan', 0, '2022-03-29'), (157, 'order_JCwyiBw0oBdlL1', 'pay_JCwyyAMmgqfMJj', 'success', 6547965654, 'Sapna Yadav', 0, '2022-03-29'); -- -------------------------------------------------------- -- -- Table structure for table `purchase_dealer` -- CREATE TABLE `purchase_dealer` ( `dealer_id` int(11) NOT NULL, `dealer_name` varchar(100) NOT NULL, `dealer_phone` bigint(20) NOT NULL, `dealer_email` varchar(100) NOT NULL, `store_name` varchar(50) NOT NULL, `store_phone` bigint(20) NOT NULL, `store_address` varchar(250) NOT NULL, `purchase_date` datetime NOT NULL, `total_price` int(11) NOT NULL, `paid_price` int(11) NOT NULL, `due_price` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `purchase_dealer` -- INSERT INTO `purchase_dealer` (`dealer_id`, `dealer_name`, `dealer_phone`, `dealer_email`, `store_name`, `store_phone`, `store_address`, `purchase_date`, `total_price`, `paid_price`, `due_price`) VALUES (13, 'Roshan Shah', 6574001238, 'rroshan@g.in', 'Roshani Groceries', 9874561230, 'Tumbajote', '2021-07-29 18:32:00', 200, 200, 0), (14, 'Sujit Sharma', 8547123690, 'sujit@gmail.in', 'Sujit Store', 5487120369, 'Beldangi', '2021-08-06 19:06:00', 2800, 2500, 300), (15, 'Dipak Ghasita Ram', 9875646516, 'grdipak@gmail.com', 'Ghasita Ram Bhandar', 9654156160, 'Mahabir Sthan', '2021-12-21 17:31:00', 6820, 6820, 0), (16, 'Dipak Ghasita Ram', 9875646516, 'grdipak@gmail.com', 'Ghasita Ram Bhandar', 9654156160, 'Mahabir Sthan', '2021-12-21 17:31:00', 6820, 6820, 0), (17, 'Dipak Ghasita Ram', 9875646516, 'grdipak@gmail.com', 'Ghasita Ram Bhandar', 9654156160, 'Mahabir Sthan', '2021-12-21 17:31:00', 6820, 6820, 0), (18, 'Dipak Ghasita Ram', 9875646516, 'grdipak@gmail.com', 'Ghasita Ram Bhandar', 9654156160, 'Mahabir Sthan', '2021-12-21 17:31:00', 6820, 6820, 0), (19, 'Abhishek Chaurasia', 6735465021, 'cbhandar84@gmail.com', 'Chaurasia Bhandar', 8635751657, 'Mahabir Sthan', '2022-01-10 19:00:00', 15500, 15000, 500), (20, 'Abhishek Chaurasia', 6735465021, 'cbhandar84@gmail.com', 'Chaurasia Bhandar', 8635751657, 'Mahabir Sthan', '2022-01-10 17:26:00', 1600, 1600, 0), (21, 'B Khatri', 8418918418, 'slg_mrelaince@gmail.com', 'Relaince Mall', 8418918418, 'Bardwan Road, Siliguri', '2022-01-10 20:33:00', 15725, 15600, 125); -- -------------------------------------------------------- -- -- Table structure for table `purchase_items` -- CREATE TABLE `purchase_items` ( `item_id` int(11) NOT NULL, `item_name` varchar(100) NOT NULL, `item_rate` int(11) NOT NULL, `item_qty` varchar(50) NOT NULL, `purchase_stock` varchar(50) NOT NULL, `item_unit` varchar(10) NOT NULL, `item_total` int(11) NOT NULL, `dealer_id` int(11) NOT NULL, `purchase_date` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `purchase_items` -- INSERT INTO `purchase_items` (`item_id`, `item_name`, `item_rate`, `item_qty`, `purchase_stock`, `item_unit`, `item_total`, `dealer_id`, `purchase_date`) VALUES (29, 'ring pasta', 50, '5000', '5000', 'kg', 25, 13, '2021-07-29 18:32:00'), (30, 'meggie masala', 10, '2', '10', 'packet', 100, 13, '2021-07-29 18:32:00'), (31, 'tomato catchup', 65, '0', '10', 'bottle', 325, 13, '2021-07-29 18:32:00'), (32, 'sprite', 90, '7', '10', 'bottle', 450, 13, '2021-07-29 18:32:00'), (33, 'coffee powder', 450, '2', '5', 'packet', 900, 14, '2021-08-03 17:25:00'), (34, 'paneer', 280, '5', '30', 'kg', 1500, 14, '2021-08-03 17:25:00'), (35, 'milk powder', 400, '20', '20', 'kg', 400, 14, '2021-08-03 17:25:00'), (66, 'Krishna Bhog Aata packet(40kg)', 1050, '5', '', '', 0, 19, '2022-01-10 19:00:00'), (67, 'maida(50kg)', 1300, '5', '', '', 0, 19, '2022-01-10 19:00:00'), (68, 'Coffee Powder(1kg)', 750, '5', '', '', 0, 19, '2022-01-10 19:00:00'), (69, 'Sprite(2L)', 80, '20', '', '', 0, 20, '2022-01-10 17:26:00'), (70, 'jgfg jhgfyu', 59, '10', '', '', 0, 21, '2022-01-10 20:33:00'), (71, 'kjhfy hjdfgv', 149, '25', '', '', 0, 21, '2022-01-10 20:33:00'), (72, 'kuyrygv jfjgcfdf', 499, '20', '500', '', 0, 21, '2022-01-10 20:33:00'); -- -------------------------------------------------------- -- -- Table structure for table `recipe_category` -- CREATE TABLE `recipe_category` ( `recipe_category_id` int(11) NOT NULL, `recipe_category_name` varchar(100) NOT NULL, `recipe_category_img` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `recipe_category` -- INSERT INTO `recipe_category` (`recipe_category_id`, `recipe_category_name`, `recipe_category_img`) VALUES (1, 'fast-food', 'fast-food.png'), (2, 'beverage', 'beverage.png'), (3, 'desert', 'desert.png'), (4, 'non-veg', 'non-veg.png'), (5, 'veg', 'veg.png'), (6, 'mains', 'dish.png'), (7, 'starter', 'salad.png'), (8, 'breakfast', 'breakfast.png'); -- -------------------------------------------------------- -- -- Table structure for table `restro_details` -- CREATE TABLE `restro_details` ( `restro_id` int(11) NOT NULL, `restro_name` varchar(50) NOT NULL, `restro_opening` date NOT NULL, `restro_phone` bigint(12) NOT NULL, `restro_phone2` bigint(12) NOT NULL, `restro_email` varchar(100) NOT NULL, `restro_city` varchar(50) NOT NULL, `restro_address` varchar(100) NOT NULL, `restro_owner` varchar(50) NOT NULL, `restro_owner_phone` bigint(12) NOT NULL, `restro_owner_address` varchar(100) NOT NULL, `restro_owner_city` varchar(50) NOT NULL, `restro_gst` varchar(50) NOT NULL, `restro_logo` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `restro_details` -- INSERT INTO `restro_details` (`restro_id`, `restro_name`, `restro_opening`, `restro_phone`, `restro_phone2`, `restro_email`, `restro_city`, `restro_address`, `restro_owner`, `restro_owner_phone`, `restro_owner_address`, `restro_owner_city`, `restro_gst`, `restro_logo`) VALUES (1, 'Delhi Yummy Bites', '2021-03-04', 9876543210, 1800121555, 'info@delhiyummybites.com', 'Siliguri', 'College Para, 1 no. Gate', 'Vikram Sarkar', 9584763021, 'Sliguri, Pradhan Nagar', 'Siliguri', '23 ABSF8541A 1B5', 'restaurent-logo.png'); -- -------------------------------------------------------- -- -- Table structure for table `restro_staff` -- CREATE TABLE `restro_staff` ( `staff_id` int(11) NOT NULL, `staff_name` varchar(100) NOT NULL, `staff_pass` varchar(10) NOT NULL, `staff_phone` bigint(15) NOT NULL, `staff_phone2` bigint(15) NOT NULL, `staff_email` varchar(100) NOT NULL, `staff_dob` date NOT NULL, `staff_city` varchar(100) NOT NULL, `staff_address` varchar(100) NOT NULL, `staff_role` varchar(50) NOT NULL, `staff_joining` date NOT NULL, `staff_salary` int(11) NOT NULL, `staff_img` varchar(100) NOT NULL, `staff_doc` varchar(100) NOT NULL, `staff_status` varchar(50) NOT NULL, `restro_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `restro_staff` -- INSERT INTO `restro_staff` (`staff_id`, `staff_name`, `staff_pass`, `staff_phone`, `staff_phone2`, `staff_email`, `staff_dob`, `staff_city`, `staff_address`, `staff_role`, `staff_joining`, `staff_salary`, `staff_img`, `staff_doc`, `staff_status`, `restro_id`) VALUES (1, 'P. Pandey', 'pandey#123', 98766543210, 6547654654, 'ppandey123@g.in', '1987-01-24', 'Siliguri', 'Champasari Anchal, Champasari', 'waiter', '2021-01-14', 8000, '', '', 'active', 1), (2, 'Kumar Ranjit', '', 987650505, 0, 'kranjit123@gmail.com', '1991-10-04', 'Falakata', 'Falakata, Cooch Behar', 'waiter', '2020-12-10', 5000, 'p-pandey.jpg', 'Diploma-Certificate.jpg', 'active', 1), (3, 'Sonu Singh', '', 6745120334, 8448915632, 'ssingh257@gmail.com', '1998-05-01', 'Jaisalmer', 'Rajasthan', 'chef', '2020-06-24', 15000, 'person2.jpg', 'gsm6-marksheet.txt', 'active', 1), (4, 'Rohit Kumar', '', 9584141502, 9818418457, 'rohitkumar502@gmail.com', '1988-07-04', 'Danapur', 'Danapur Chowk, Danapur, Bihar', 'maid', '2022-02-01', 5000, 'rohit-kumar.png', 'rohit-document.jpg', 'inactive', 1), (5, 'admin', 'a@123', 8457101542, 0, 'encodersrestro@gmail.com', '0000-00-00', 'Siliguri', 'College Para, near basu clinic', 'admin', '0000-00-00', 0, '', '', 'active', 1), (6, 'Vinod', 'wait@123', 9584754565, 85471024852, 'vinodray1994@gmail.com', '1994-06-15', 'Siliguri', 'College Para, near basu clinic', 'waiter', '0000-00-00', 5000, '', '', 'active', 1), (7, 'basu', 'cash@123', 6846871601, 0, 'basupadhyay369@gmail.com', '0000-00-00', 'Siliguri', 'Matigara', 'cashier', '0000-00-00', 12000, '', '', 'active', 1); -- -------------------------------------------------------- -- -- Table structure for table `restro_tables` -- CREATE TABLE `restro_tables` ( `table_id` int(11) NOT NULL, `table_number` varchar(10) NOT NULL, `table_seat` int(11) NOT NULL, `table_type` varchar(50) NOT NULL, `table_status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `restro_tables` -- INSERT INTO `restro_tables` (`table_id`, `table_number`, `table_seat`, `table_type`, `table_status`) VALUES (1, 'table 1', 4, 'ac', 0), (2, 'table 2', 4, 'ac', 0), (3, 'table 3', 4, 'ac', 0), (4, 'table 4', 4, 'ac', 0), (5, 'table 5', 4, 'ac', 0), (6, 'table 6', 4, 'ac', 0), (7, 'table 7', 10, 'ac', 0), (8, 'table 8', 10, 'ac', 0), (9, 'table 9', 4, 'non_ac', 0), (10, 'table 10', 4, 'non_ac', 0); -- -------------------------------------------------------- -- -- Table structure for table `table_orderlist` -- CREATE TABLE `table_orderlist` ( `serial_id` int(11) NOT NULL, `order_id` int(11) DEFAULT NULL, `table_id` int(11) NOT NULL, `food_id` int(11) NOT NULL, `food_name` varchar(100) NOT NULL, `food_price` int(11) NOT NULL, `food_qty` int(11) NOT NULL, `food_subtotal` int(11) NOT NULL, `order_date` varchar(50) NOT NULL, `customer_phone` bigint(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `table_orderlist` -- INSERT INTO `table_orderlist` (`serial_id`, `order_id`, `table_id`, `food_id`, `food_name`, `food_price`, `food_qty`, `food_subtotal`, `order_date`, `customer_phone`) VALUES (455, 212, 1, 24, 'Plain Rice (250g)', 20, 3, 60, '2022-03-28', 6788464690), (456, 212, 1, 18, 'Chiken Curry', 150, 3, 450, '2022-03-28', 6788464690), (457, 212, 1, 17, 'Chiken Tikka', 180, 1, 180, '2022-03-28', 6788464690), (459, 212, 1, 21, 'paneer tikka masala', 179, 2, 358, '2022-03-28', 6788464690), (460, 213, 3, 7, 'Chicken Biryani', 150, 3, 450, '2022-03-28', 6360063143), (461, 213, 3, 18, 'Chiken Curry', 150, 3, 450, '2022-03-28', 6360063143), (463, 213, 3, 11, 'masala tea', 15, 4, 60, '2022-03-28', 6360063143), (465, 214, 5, 7, 'Chicken Biryani', 150, 3, 450, '2022-03-29', 6584646354), (466, 214, 5, 18, 'Chiken Curry', 150, 3, 450, '2022-03-29', 6584646354); -- -- Indexes for dumped tables -- -- -- Indexes for table `additional_expenses` -- ALTER TABLE `additional_expenses` ADD PRIMARY KEY (`exp_id`); -- -- Indexes for table `customer_details` -- ALTER TABLE `customer_details` ADD PRIMARY KEY (`customer_id`); -- -- Indexes for table `customer_enquiry` -- ALTER TABLE `customer_enquiry` ADD PRIMARY KEY (`enquiry_id`); -- -- Indexes for table `delivery_cart` -- ALTER TABLE `delivery_cart` ADD PRIMARY KEY (`serial_id`); -- -- Indexes for table `delivery_order` -- ALTER TABLE `delivery_order` ADD PRIMARY KEY (`order_id`); -- -- Indexes for table `delivery_orderlist` -- ALTER TABLE `delivery_orderlist` ADD PRIMARY KEY (`serial_id`); -- -- Indexes for table `dinein_order` -- ALTER TABLE `dinein_order` ADD PRIMARY KEY (`order_id`); -- -- Indexes for table `dinein_order_items` -- ALTER TABLE `dinein_order_items` ADD PRIMARY KEY (`serial_id`); -- -- Indexes for table `food_item` -- ALTER TABLE `food_item` ADD PRIMARY KEY (`food_id`); -- -- Indexes for table `kitchen_orderlist` -- ALTER TABLE `kitchen_orderlist` ADD PRIMARY KEY (`kot_id`); -- -- Indexes for table `pay_orders` -- ALTER TABLE `pay_orders` ADD PRIMARY KEY (`p_id`); -- -- Indexes for table `purchase_dealer` -- ALTER TABLE `purchase_dealer` ADD PRIMARY KEY (`dealer_id`); -- -- Indexes for table `purchase_items` -- ALTER TABLE `purchase_items` ADD PRIMARY KEY (`item_id`); -- -- Indexes for table `recipe_category` -- ALTER TABLE `recipe_category` ADD PRIMARY KEY (`recipe_category_id`); -- -- Indexes for table `restro_staff` -- ALTER TABLE `restro_staff` ADD PRIMARY KEY (`staff_id`); -- -- Indexes for table `restro_tables` -- ALTER TABLE `restro_tables` ADD PRIMARY KEY (`table_id`); -- -- Indexes for table `table_orderlist` -- ALTER TABLE `table_orderlist` ADD PRIMARY KEY (`serial_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `additional_expenses` -- ALTER TABLE `additional_expenses` MODIFY `exp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `customer_details` -- ALTER TABLE `customer_details` MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=265; -- -- AUTO_INCREMENT for table `customer_enquiry` -- ALTER TABLE `customer_enquiry` MODIFY `enquiry_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `delivery_cart` -- ALTER TABLE `delivery_cart` MODIFY `serial_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=235; -- -- AUTO_INCREMENT for table `delivery_order` -- ALTER TABLE `delivery_order` MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=120; -- -- AUTO_INCREMENT for table `delivery_orderlist` -- ALTER TABLE `delivery_orderlist` MODIFY `serial_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=173; -- -- AUTO_INCREMENT for table `dinein_order` -- ALTER TABLE `dinein_order` MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=216; -- -- AUTO_INCREMENT for table `dinein_order_items` -- ALTER TABLE `dinein_order_items` MODIFY `serial_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=468; -- -- AUTO_INCREMENT for table `food_item` -- ALTER TABLE `food_item` MODIFY `food_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `kitchen_orderlist` -- ALTER TABLE `kitchen_orderlist` MODIFY `kot_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=224; -- -- AUTO_INCREMENT for table `pay_orders` -- ALTER TABLE `pay_orders` MODIFY `p_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=158; -- -- AUTO_INCREMENT for table `purchase_dealer` -- ALTER TABLE `purchase_dealer` MODIFY `dealer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `purchase_items` -- ALTER TABLE `purchase_items` MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73; -- -- AUTO_INCREMENT for table `recipe_category` -- ALTER TABLE `recipe_category` MODIFY `recipe_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `restro_staff` -- ALTER TABLE `restro_staff` MODIFY `staff_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `restro_tables` -- ALTER TABLE `restro_tables` MODIFY `table_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `table_orderlist` -- ALTER TABLE `table_orderlist` MODIFY `serial_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=468; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;