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)