def adminDeleteBus(departure, destination, date, BusId):
BT = BusTable()
b = BT.get_one_bus(departure, destination, date, BusId)
flag = BT.delete_bus(b)
PT = PurchaseTable()
_list = PT.findRecordForOneBus(departure, destination, date, BusId)
for i in _list:
userAction.userDeleteTicket(i['username'], i['card'], departure, destination, date, BusId)
return flag
def updateTicketInfo(username):
BT = BusTable()
PT = PurchaseTable()
ET = ExpireTable()
_list = PT.searchRecord({'username': username}) #找某个用户的所有购买记录
for i in _list:
b = BT.get_one_bus(i['departure'], i['destination'], i['date'],
i['BusId'])
ticketTime = b['BusDate'] + b['dTime']
currTime = time.strftime('%Y-%m-%d%H:%M', time.localtime(time.time()))
if currTime > ticketTime: #过期票，将记录从perchase表移入到expire表
PT.deleteOneRecord(username, i['card'], i['departure'],
i['destination'], i['date'], i['BusId'])
ET.insertRecord(i)
def checkDeleteList(username, card=-1):
DT = DeleteTable()
BT = BusTable()
condition = {}
condition['username'] = username
if card != -1:
condition['card'] = card
_list1 = DT.searchRecord(condition)
_list2 = []
total_num = 0
for i in _list1:
_list2.append(
BT.get_one_bus(i['departure'], i['destination'], i['date'],
i['BusId']))
_list2[total_num]['Price'] = i['price']
total_num = total_num + 1
return _list2, total_num
def checkBookList(username, card="-1"):
PT = PurchaseTable()
BT = BusTable()
condition = {}
condition['username'] = username
if card != "-1":
condition['card'] = str(card)
_list1 = PT.searchRecord(condition)
_list2 = []
total_num = 0
for i in _list1:
ticket = TicketInterface.TicketInterface(
BT.get_one_bus(i['departure'], i['destination'], i['date'],
i['BusId']), i)
_list2.append(ticket)
_list2[total_num]['Price'] = i['price']
total_num = total_num + 1
return _list2, total_num
def adminDeleteBus(departure, destination, date, BusId):
BT = BusTable()
b = BT.get_one_bus(departure, destination, date, BusId)
BT.delete_bus(b)