def queryAllSell():
info = Basic.queryAllSell()
table = PrettyTable(["收银员编号", "商品编号", "出售流水号", "出售数量", "总价", "日期"])
for i in info:
table.add_row(i)
print(table)
print("以上共 {} 条记录.".format(len(info)))
def getBothTopStatic(left, right, com_no):
'''返回列表 每个元素是一个商品对象和cnt'''
all_sell = Basic.queryAllSell()
cnt_dict = {}
for DA in all_sell:
sell = Sell(DA)
com_no = sell.getComNo()
if com_no == None:
continue
now_date = sell.getTime().date()
if now_date >= left and now_date <= right:
cnt_dict.setdefault(com_no, 0)
cnt_dict[com_no] += 1
cnt_list = []
for com_num in cnt_dict: #key 编号,value is cnt
ob = Basic.queryOneCommodity(com_num)
cnt_list.append(pair(Commodity(ob), cnt_dict[com_num]))
cnt_list.sort(key=lambda x: (x.cnt), reverse=True)
return cnt_list
