销售查询功能实现
作为管理员,对销售的明细的查询是必要的。
前端的界面如下:
虽然saleList表中有数据,但是并没有写入到表格中,所以希纳是的界面销售前端页面没有数据,要完成的是将表中的数据列入表格。
展示销售概况,在views.py 添加功能函数,在urls.py下添加路径
path('main/', shop_views.main, name='main'),
path('main/sales_query/', shop_views.sales_query, name='sales_query'),
def sales_query(request):
"""
交易概况页面
:param request:
:return:
"""
if request.method == "GET":
username = request.GET.get("username")
# 判断是否登录
if username is None:
return redirect(reverse('login'))
else:
# =========去数据库读取模块信息======
# 实例化mysqL连接
mysql_db = pymysql.connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
# 创建指针
cursor = mysql_db.cursor()
# 准备SQL语句
sql = "Select SerialNumber, TotalNumber,TotalPrice,ReceiveMoney,ReturnMoney,UserName,BuyTime " \
"from SalesList As T1 Left Outer Join Login As T2 on T1.LoginId = T2.LoginId " \
"Order By BuyTime DESC"
try:
cursor.execute(sql)
sales_list = cursor.fetchall() # ((),(),(),())
return render(request, 'sales_query.html', context={
'sales_list': sales_list, 'username': username})
except Exception as e:
return HttpResponse("读取数据库数据出现异常,具体原因:" + str(e))
finally:
mysql_db.close()
前端用模板语言关键代码如下:
<table class="table table-striped table-hover table-bordered" id="student" style="">
<thead style="background-color:cornflowerblue; color:white">
<tr>
<th>序号</th>
<th>流水单号</th>