给我写一个完整的饭店管理系统,包括所有具体代码项目
时间: 2024-03-06 22:47:05 浏览: 19
好的,餐厅管理系统通常包括以下功能:菜品管理、订单管理、桌位管理、员工管理、库存管理等。
以下是一个简单的实现:
1. 菜品管理
菜品表(dishes):
id(菜品编号)
name(菜品名称)
price(单价)
category(所属分类)
菜品分类表(dishes_category):
id(分类编号)
name(分类名称)
菜品管理功能包括菜品的添加、修改、删除和查询。具体实现如下:
添加菜品:
```python
def add_dish(name, price, category):
sql = "INSERT INTO dishes (name, price, category) VALUES (%s, %s, %s)"
cursor.execute(sql, (name, price, category))
db.commit()
```
修改菜品:
```python
def update_dish(id, name, price, category):
sql = "UPDATE dishes SET name=%s, price=%s, category=%s WHERE id=%s"
cursor.execute(sql, (name, price, category, id))
db.commit()
```
删除菜品:
```python
def delete_dish(id):
sql = "DELETE FROM dishes WHERE id=%s"
cursor.execute(sql, (id,))
db.commit()
```
查询菜品:
```python
def query_dishes(name=None, category=None):
sql = "SELECT * FROM dishes WHERE 1=1"
if name:
sql += " AND name LIKE %s"
if category:
sql += " AND category=%s"
cursor.execute(sql, ('%'+name+'%', category))
results = cursor.fetchall()
return results
```
2. 订单管理
订单表(orders):
id(订单编号)
table_id(桌位编号)
dish_id(菜品编号)
quantity(数量)
create_time(下单时间)
桌位表(tables):
id(桌位编号)
name(桌位名称)
订单管理功能包括订单的添加、修改、删除和查询。具体实现如下:
添加订单:
```python
def add_order(table_id, dish_id, quantity):
sql = "INSERT INTO orders (table_id, dish_id, quantity, create_time) VALUES (%s, %s, %s, NOW())"
cursor.execute(sql, (table_id, dish_id, quantity))
db.commit()
```
修改订单:
```python
def update_order(id, table_id, dish_id, quantity):
sql = "UPDATE orders SET table_id=%s, dish_id=%s, quantity=%s WHERE id=%s"
cursor.execute(sql, (table_id, dish_id, quantity, id))
db.commit()
```
删除订单:
```python
def delete_order(id):
sql = "DELETE FROM orders WHERE id=%s"
cursor.execute(sql, (id,))
db.commit()
```
查询订单:
```python
def query_orders(table_id=None, create_time=None):
sql = "SELECT orders.id, tables.name, dishes.name, orders.quantity, orders.create_time FROM orders JOIN tables ON orders.table_id=tables.id JOIN dishes ON orders.dish_id=dishes.id WHERE 1=1"
if table_id:
sql += " AND orders.table_id=%s"
if create_time:
sql += " AND DATE(orders.create_time)=%s"
cursor.execute(sql, (table_id, create_time))
results = cursor.fetchall()
return results
```
3. 桌位管理
桌位管理功能包括桌位的添加、修改、删除和查询。具体实现如下:
添加桌位:
```python
def add_table(name):
sql = "INSERT INTO tables (name) VALUES (%s)"
cursor.execute(sql, (name,))
db.commit()
```
修改桌位:
```python
def update_table(id, name):
sql = "UPDATE tables SET name=%s WHERE id=%s"
cursor.execute(sql, (name, id))
db.commit()
```
删除桌位:
```python
def delete_table(id):
sql = "DELETE FROM tables WHERE id=%s"
cursor.execute(sql, (id,))
db.commit()
```
查询桌位:
```python
def query_tables(name=None):
sql = "SELECT * FROM tables WHERE 1=1"
if name:
sql += " AND name LIKE %s"
cursor.execute(sql, ('%'+name+'%',))
results = cursor.fetchall()
return results
```
4. 员工管理
员工表(employees):
id(员工编号)
name(员工姓名)
position(职位)
salary(薪水)
员工管理功能包括员工的添加、修改、删除和查询。具体实现如下:
添加员工:
```python
def add_employee(name, position, salary):
sql = "INSERT INTO employees (name, position, salary) VALUES (%s, %s, %s)"
cursor.execute(sql, (name, position, salary))
db.commit()
```
修改员工:
```python
def update_employee(id, name, position, salary):
sql = "UPDATE employees SET name=%s, position=%s, salary=%s WHERE id=%s"
cursor.execute(sql, (name, position, salary, id))
db.commit()
```
删除员工:
```python
def delete_employee(id):
sql = "DELETE FROM employees WHERE id=%s"
cursor.execute(sql, (id,))
db.commit()
```
查询员工:
```python
def query_employees(name=None, position=None):
sql = "SELECT * FROM employees WHERE 1=1"
if name:
sql += " AND name LIKE %s"
if position:
sql += " AND position=%s"
cursor.execute(sql, ('%'+name+'%', position))
results = cursor.fetchall()
return results
```
5. 库存管理
库存表(inventory):
id(库存编号)
dish_id(菜品编号)
quantity(数量)
库存管理功能包括库存的添加、修改、删除和查询。具体实现如下:
添加库存:
```python
def add_inventory(dish_id, quantity):
sql = "INSERT INTO inventory (dish_id, quantity) VALUES (%s, %s)"
cursor.execute(sql, (dish_id, quantity))
db.commit()
```
修改库存:
```python
def update_inventory(id, dish_id, quantity):
sql = "UPDATE inventory SET dish_id=%s, quantity=%s WHERE id=%s"
cursor.execute(sql, (dish_id, quantity, id))
db.commit()
```
删除库存:
```python
def delete_inventory(id):
sql = "DELETE FROM inventory WHERE id=%s"
cursor.execute(sql, (id,))
db.commit()
```
查询库存:
```python
def query_inventory(dish_id=None):
sql = "SELECT * FROM inventory WHERE 1=1"
if dish_id:
sql += " AND dish_id=%s"
cursor.execute(sql, (dish_id,))
results = cursor.fetchall()
return results
```
以上是一个简单的餐厅管理系统的基本功能。当然,具体实现还需要考虑一些细节和优化。