def sign_up_process(): try: name = request.form.get("name") account = request.form.get("account") password = request.form.get("password") confirm_password = request.form.get("confirm_password") user = session.query( models.Users).filter(models.Users.account_tk == account).first() if user: flash('Tên tài khoản đã tồn tại') return redirect("/sign_up") user = models.Users() user.name = name user.account_tk = account user.super = False user.ctv = False user.enduser = True user.create_at = str(datetime.datetime.now()) user.password = password user.money = 0 session.add(user) session.commit() session.close() flash('Tạo tài khoản "' + name + '" thành công!') except Exception as e: flash('Hệ thống lỗi, nhờ báo cáo sự cố với bộ phận kỹ thuật.') return redirect("/sign_up") return redirect("/login")
def ChangeFriendlistToFriendData(friend_id): #フレンドidから名前と画像を取得 users = session.query(User).filter(User.id == friend_id).all() session.commit() #print(users) if users == []: return None for row in users: return [row.id, row.icon_image, row.name]
def GetPointByUserId(friend_id): #idからポイントを取得 users = session.query(User).filter(User.id == friend_id).all() session.commit() #print(users) if users == []: return None for row in users: return row.point
def nick_detail(): code = request.args.get("code") id = request.args.get("id") data = session.query(models.Nicks).filter(models.Nicks.code == code, models.Nicks.id == id).first() list_image = data.images.split(",") return render_template('web/detail-nick.html', list_image=list_image, data=data)
def GetUserLoginData(UserName): print(type(UserName)) select = (UserName) print("select",select) users = session.query(User).filter(User.name==select).all() session.commit() if users ==[]: return None for row in users: return [row.id,row.icon_image,row.name,row.password,row.point,row.friend_list]
def list_nick(): game_name = request.args.get("game", None) price = request.args.get("price", None) code = request.args.get("find", None) page_size = 12 if game_name: data = session.query(models.Nicks).filter( models.Nicks.game_name == game_name, models.Nicks.status == 'Đang bán').order_by(desc(models.Nicks.id)) else: data = session.query(models.Nicks).filter( models.Nicks.status == 'Đang bán').order_by(desc(models.Nicks.id)) if code: data = data.filter(models.Nicks.code == code) if price: price_cv = list(price.split(",")) price1 = None price2 = None if len(price_cv) > 1: price1 = int(price_cv[0]) price2 = int(price_cv[1]) data = data.filter(models.Nicks.price > price1) data = data.filter(models.Nicks.price <= price2) elif int(price) == 1000000: data = data.filter(models.Nicks.price > int(price)) else: data = data.filter(models.Nicks.price <= int(price)) data = data.limit(page_size) data = data.all() for d in data: if d.images: list_image = d.images.split(",") d.images = list_image[0] return render_template('web/list.html', data=data, game_name=game_name, price=price, code=code)
def insertHFRequestDetail(runId, hotelrequestinput): hotelflightrequestinput = hotelrequestinput.all() data2insert = [] for rec in hotelflightrequestinput: for competitor in rec.CompetitorIds.split(','): for length in rec.RentalLength.split(','): try: checkin = session.query( hotelflightrequestDateDettbl).filter_by( hotelflightrequestinputdetailsId=rec. hotelflightrequestinputdetailsId).one_or_none() hotelflightcrawlrequest = hotelflightCrawlReqtbl( RequestId=rec.RequestId, RequestRunId=runId, hotelflightrequestinputdetailsId=rec. hotelflightrequestinputdetailsId, StatusId=5, CheckInDate=datetime.now().strftime('%d-%m-%Y') if checkin is None else checkin.CheckInDate, RentalLength=rec.RentalLength, CompetitorName=session.query(competitortbl).filter_by( Id=competitor).one().name, PointOfSale=session.query(postbl).filter_by( PointOfSaleId=rec.PointOfSaleId).one().PointOfSale, Adult=rec.AdultId, Child=rec.ChildID, CrawlMode=session.query(crawlmode).filter_by( CrawlModeId=rec.CrawlMode).one().CrawlMode, HotelName=session.query(hoteltbl).filter_by( HotelId=rec.HotelId).one().HotelName, WebSiteHotelId='', FromAirportCode=session.query(airporttbl).filter_by( AirportCodeId=rec.FromAirportCodeId).one( ).AirportCode, ToAirportCode=session.query(airporttbl).filter_by( AirportCodeId=rec.ToAirportCodeId).one( ).AirportCode, call_func=rec.call_func, CreatedDatetime=datetime.now()) data2insert.append(hotelflightcrawlrequest) except Exception: logger.error( 'Object hotelflightcrawlrequest failed to create for Request ID' + str(rec.RequestId) + ': ', exc_info=True) continue try: session.bulk_save_objects(data2insert) session.commit() print("Thread Ended") except Exception: logger.error( 'function insertHFRequestDetail failed to save in DB for RunID ' + str(runId) + ': ', exc_info=True)
def index(): page_size = request.args.get("page_size") list_origin = common.LIST_ORIGIN page_size = int(page_size) if page_size else 10 data = session.query(models.Info).order_by(models.Info.id.desc()).all() count = len(data) page_size = page_size if page_size < len(data) else len(data) check_view = True if page_size < len(data) else False session.close() return render_template('sango/web/index.html', data=data, list_origin=list_origin, page_size=page_size, check_view=check_view, location=app.config['LOCATION'], loca=app.config['LOCA'])
def detail_product(id): try: list_origin = common.LIST_ORIGIN data = session.query(models.Product).filter(models.Product.id == id).first() data.price = json.loads(data.price) session.close() return render_template('sango/web/detail-product.html', data=data, list_origin=list_origin, location=app.config['LOCATION']) except: session.rollback() raise finally: session.close()
def index(): data_lq = session.query(models.Nicks).filter( models.Nicks.status == 'Đang bán', models.Nicks.game_name == 'Liên Quân').order_by(desc( models.Nicks.id)).limit(6).all() data_nr = session.query(models.Nicks).filter( models.Nicks.status == 'Đang bán', models.Nicks.game_name == 'Ngọc Rồng').order_by(desc( models.Nicks.id)).limit(8).all() for lq in data_lq: if lq.images: list_image = lq.images.split(",") lq.images = list_image[0] for nr in data_nr: if nr.images: list_image = nr.images.split(",") nr.images = list_image[0] return render_template('web/index.html', data_lq=data_lq, data_nr=data_nr, user=current_user)
def confirm_request(): try: id = request.form.get("id") history = session.query( models.History).filter(models.History.id == id).first() history.status = "Processed" session.merge(history) session.commit() session.close() flash("Xử lý request thành công!") except Exception as e: flash('Hệ thống lỗi, nhờ báo cáo sự cố với bộ phận kỹ thuật.') return redirect("/admin-ctv")
def UpdateLendInfoData(user_id_data,book_id_data): #print(user_id_data) own_book_id_data = (GetOwnBookIDByUseridAndBookid(user_id_data,book_id_data)) lends = session.query(Lend_info).filter(Lend_info.own_book_id == own_book_id_data).all() if lends == []: raise Exception('Error!') else: #print(lends) for lend in lends: lend.is_valid = False #print("valid",lend.is_valid) print("貸し出し終了しました") session.commit()
def GetLendData(id): print(type(id)) select = (id) print("select", select) users = session.query(Lend_info).filter(Lend_info.id == id).all() session.commit() if users == []: return None for row in users: return [ row.id, row.borrower_id, row.own_book_id, row.created_at, row.returned_at, row.deadline, row.is_valid ]
def profile(): page_size = 12 data_qr = session.query( models.History).filter(models.History.user_id == user_id).order_by( desc(models.History.id)).all() data = [] for d in data_qr: rd = { "id": d.id, "card": d.card, "buy": d.buy, "info": json.loads(d.info), } data.append(rd) return render_template('web/profile.html', data=data)
def login_process(): try: username = request.form.get("username") password = request.form.get("password") user = session.query(models.Users).filter( models.Users.account_tk == username, models.Users.password == password).first() if user: login_user(user) else: flash('Mật khẩu không chính xác') return redirect("/login") except Exception as e: flash('Hệ thống lỗi, nhờ báo cáo sự cố với bộ phận kỹ thuật.') return redirect("/login") return redirect("/")
def edit_product(): try: id = request.form.get("id") typep = request.form.get("type") name = request.form.get("name") price = request.form.get("price") color = request.form.get("color") origin = request.form.get("origin") mainten = request.form.get("mainten") wood_type = request.form.get("wood_type") short_info = request.form.get("short_info") long_info = request.form.get("long_info") product = session.query(models.Product).filter(models.Product.id == int(id)).first() file_name = product.image if 'image' in request.files: image = request.files['image'] if image.filename != '': file_old = product.image file_name = common.upload_file(image, file_old) product.type = typep product.name = name product.price = price product.color = int(color) if color else None product.origin = origin product.mainten = int(mainten) if color else None product.image = file_name product.wood_type = wood_type product.short_info = short_info product.long_info = long_info session.merge(product) session.commit() session.close() flash('Chỉnh sửa sản phẩm thành công!') except Exception as e: flash('Hệ thống lỗi, nhờ báo cáo sự cố với bộ phận kỹ thuật.') return redirect("/admin")
def admin(): per = checkPermisson() if per == 'admin': nicks_qr = session.query(models.Nicks).order_by(desc( models.Nicks.id)).all() # Get info nicks sold = [] on_sale = [] nicks = [] for nick in nicks_qr: if nick.status == 'Đang bán': on_sale.append(nick) if nick.status == 'Đã bán': sold.append(nick) # Convert nicks data user = session.query( models.Users).filter(models.Users.id == nick.user_id).first() data = { "id": nick.id, "code": nick.code, "name": nick.name, "game_name": nick.game_name, "price": nick.price, "user": { "name": user.name, "id": user.id }, "status": nick.status, "game_info": json.loads(nick.game_info), "images": nick.images.split(",") } nicks.append(data) # Get info users ctv = [] enduser = [] users = [] users_qr = session.query( models.Users).filter(models.Users.super == False).all() for user in users_qr: if user.ctv: ctv.append(user) elif user.enduser: enduser.append(user) return render_template('admin/admin.html', nicks=nicks, sold=sold, on_sale=on_sale, ctv=ctv, enduser=enduser) elif per == 'ctv': nicks_qr = session.query(models.Nicks).filter( models.Nicks.user_id == current_user.id).order_by( desc(models.Nicks.id)).all() # Get info nicks sold = [] on_sale = [] nicks = [] for nick in nicks_qr: if nick.status == 'Đang bán': on_sale.append(nick) if nick.status == 'Đã bán': sold.append(nick) # Convert nicks data data = { "id": nick.id, "code": nick.code, "name": nick.name, "game_name": nick.game_name, "price": nick.price, "status": nick.status, "game_info": json.loads(nick.game_info) } nicks.append(data) return render_template('admin/ctv-nick.html', nicks=nicks, sold=sold, on_sale=on_sale) else: return redirect("/404")
def edit_nick(): try: id = request.form.get('id') nick = session.query( models.Nicks).filter(models.Nicks.id == id).first() name = request.form.get('name') nick.name = name price = request.form.get('price') nick.price = price game_type = request.form.get('gameType') code = '' # Game Info if game_type == 'LQ': code = 'LQ-' + str(int(datetime.datetime.utcnow().timestamp())) game_name = 'Liên Quân' data = { "account": request.form.get('account'), "password": request.form.get('password'), "rank": request.form.get('rank'), "tuong": request.form.get('slTuong'), "skin": request.form.get('Skin'), "ngoc": request.form.get('ngoc'), "da_quy": request.form.get('daQuy') } else: code = 'NR-' + str(int(datetime.datetime.utcnow().timestamp())) game_name = 'Ngọc Rồng' data = { "nickType": request.form.get('nickType'), "server": request.form.get('server'), "hanhTinh": request.form.get('hanhTinh'), "bongTai": True if request.form.get('bongTai') == 'on' else False, "deTu": True if request.form.get('deTu') == 'on' else False } # Image if 'files' not in request.files: nick.images = nick.images else: images = request.files.getlist('files') # if user does not select file, browser also # submit an empty part without filename list_image = [] if images: for image in images: if image.filename == '': nick.images = nick.images else: path = app.config['UPLOAD_FOLDER'] + code os.mkdir(path) file_name = common.upload_file(image, path) list_image.append( os.path.join(UPLOAD_FOLDER + code, image.filename)) nick.images = ','.join(list_image) nick.status = request.form.get('status') nick.game_name = game_name nick.game_info = json.dumps(data) nick.code = code nick.create_at = str(datetime.datetime.now()) nick.user_id = current_user.id session.merge(nick) session.commit() session.close() flash('Update thông tin nick thành công!') except Exception as e: flash(e) flash('Hệ thống lỗi, nhờ báo cáo sự cố với bộ phận kỹ thuật.') redirect("/admin") return redirect("/admin")
def load_user(user_id): return session.query(models.User).filter( models.User.id == user_id).first()
def admin_ctv(): per = checkPermisson() if per == 'admin': # Get info nicks nicks = session.query(models.Nicks).all() sold = [] on_sale = [] nicks = [] for nick in nicks: if nick.status == 'Đang bán': on_sale.append(nick) if nick.status == 'Đã bán': sold.append(nick) # Get info users ctv = [] enduser = [] users = [] users_qr = session.query( models.Users).filter(models.Users.super == False).all() for user in users_qr: if user.ctv: historys = session.query(models.History).filter( models.History.user_id == user.id, models.History.card == False, models.History.buy == False, models.History.status == 'Confirm').all() ctv_sale = session.query(models.Nicks).filter( models.Nicks.user_id == user.id).all() request_info = [] for history in historys: info = json.loads(history.info) request = { "id": history.id, "price": info["price"], "descripton": info["description"] } request_info.append(request) data = { "id": user.id, "name": user.name, "account_tk": user.account_tk, "super": user.super, "ctv": user.ctv, "enduser": user.enduser, "create_at": user.create_at, "password": user.password, "money": user.money, "request": len(historys), "request_info": request_info, "sale": len(ctv_sale) } ctv.append(data) elif user.enduser: enduser.append(user) return render_template('admin/ctv.html', nicks=nicks, sold=sold, on_sale=on_sale, ctv=ctv, enduser=enduser) else: return redirect("/error")
def detail_info(id): list_origin = common.LIST_ORIGIN data = session.query(models.Info).filter(models.Info.id == id).first() session.close() return render_template('sango/web/detail-info.html', data=data, list_origin=list_origin, location=app.config['LOCATION'])
def admin_history(): per = checkPermisson() if per == 'admin': # Get info nicks nicks_qr = session.query(models.Nicks).all() sold = [] on_sale = [] nicks = [] for nick in nicks_qr: if nick.status == 'Đang bán': on_sale.append(nick) if nick.status == 'Đã bán': sold.append(nick) # Convert nicks data user = session.query( models.Users).filter(models.Users.id == nick.user_id).first() data = { "id": nick.id, "code": nick.code, "name": nick.name, "game_name": nick.game_name, "price": nick.price, "user": { "name": user.name, "id": user.id }, "status": nick.status } nicks.append(data) # Get info users ctv = [] enduser = [] users = [] users_qr = session.query( models.Users).filter(models.Users.super == False).all() for user in users_qr: if user.ctv: ctv.append(user) elif user.enduser: enduser.append(user) historys = session.query(models.History).all() data = [] for his in historys: # Convert nicks data user = session.query( models.Users).filter(models.Users.id == his.user_id).first() history = { "id": his.id, "card": his.card, "buy": his.buy, "info": json.loads(his.info), "create_at": his.create_at, "user": { "name": user.name, "id": user.id }, "status": his.status } data.append(history) return render_template('admin/history.html', data=data, nicks=nicks, sold=sold, on_sale=on_sale, ctv=ctv, enduser=enduser) elif per == 'ctv': # Get info nicks nicks = session.query(models.Nicks).filter( models.Nicks.user_id == current_user.id).order_by( desc(models.Nicks.id)).all() sold = [] on_sale = [] for nick in nicks: if nick.status == 'Đang bán': on_sale.append(nick) if nick.status == 'Đã bán': sold.append(nick) historys = session.query(models.History).filter( models.History.user_id == current_user.id, models.History.card == False, models.History.buy == False).all() data = [] for his in historys: # Convert nicks data user = session.query( models.Users).filter(models.Users.id == his.user_id).first() history = { "id": his.id, "card": his.card, "buy": his.buy, "info": json.loads(his.info), "create_at": his.create_at, "status": his.status } data.append(history) return render_template('admin/ctv-request.html', historys=data, sold=sold, on_sale=on_sale) else: return redirect("/error")
def insertHRequestDetail(runId, hotelrequestinput): hotelrequestinput = hotelrequestinput.all() data2insert = [] for rec in hotelrequestinput: for competitor in rec.CompetitorIds.split(','): for length in rec.RentalLength.split(','): try: starRec = session.query(starratingtbl).filter_by( StarRatingId=rec.StarRating).one_or_none() boardRec = session.query(boardtypetbl).filter_by( BoardTypeId=rec.BoardType).one_or_none() roomRec = session.query(roomtypetbl).filter_by( RoomTypeId=rec.RoomType).one_or_none() hotelcrawlrequest = hotelCrawlRequesttbl( RequestId=rec.RequestId, RequestRunId=runId, HotelReqestInputDetailsId=rec. HotelReqestInputDetailsId, StatusId=5, CheckInDate=session.query(requestDateDettbl).filter_by( HotelRequestInputDetailsId=rec. HotelReqestInputDetailsId).one().CheckInDate, RentalLength=rec.RentalLength, CompetitorName=session.query(competitortbl).filter_by( Id=competitor).one().name, PointOfSale=session.query(postbl).filter_by( PointOfSaleId=rec.PointOfSaleId).one().PointOfSale, Adult=rec.AdultId, Child=rec.ChildID, CrawlMode=session.query(crawlmode).filter_by( CrawlModeId=rec.CrawlMode).one().CrawlMode, HotelName=session.query(hoteltbl).filter_by( HotelId=rec.HotelId).one().HotelName, WebSiteHotelId='', CityName=session.query(citytbl).filter_by( CityId=rec.CityId).one().CityName, CountryName=session.query(countrytbl).filter_by( CountryID=rec.CountryId).one().CountryName, StarRating=None if starRec is None else starRec.StarRating, BoardType=None if boardRec is None else boardRec.BoardTypeCode, RoomType=None if roomRec is None else roomRec.RoomType, call_func=rec.call_func, CreatedDatetime=datetime.now()) data2insert.append(hotelcrawlrequest) except Exception: logger.error( 'Object hotelcrawlrequest failed to create for Request ID' + str(rec.RequestId) + ': ', exc_info=True) logger.error( '-------------------------Error Ends----------------------------------------' ) print("Error Occured check the Logs...") continue try: session.bulk_save_objects(data2insert) session.commit() ph = Process(target=produceMsg, args=(runId, )) ph.run() print("Thread Ended") except Exception: logger.error( 'function hotelrequestinput failed to save in DB for RunID ' + str(runId) + ': ', exc_info=True) logger.error( '------------------------Error Ends-----------------------------------------' ) print("Error Occured check the Logs...")
def info(): data = session.query(models.Info).order_by(models.Info.id.desc()).all() return render_template('sango/admin/list-info.html', data=data)
def admin_edit_product(id): list_origin = common.LIST_ORIGIN data = session.query(models.Product).filter(models.Product.id == id).first() return render_template('sango/admin/edit-product.html', data=data, list_origin=list_origin)
def admin_detail_product(id): data = session.query(models.Product).filter(models.Product.id == id).first() return render_template('sango/admin/detail-product.html', data=data)
def admin_add_product(): list_origin = common.LIST_ORIGIN data = session.query(models.Product).all() session.close() return render_template('sango/admin/add-product.html', data=data, list_origin=list_origin)
def edit_info(id): data = session.query(models.Info).filter(models.Info.id == id).first() return render_template('sango/admin/edit-info.html', data=data)
def admin(): data = session.query(models.Product).order_by(models.Product.id.desc()).all() session.close() return render_template('sango/admin/managerment.html', data=data)
except Exception: logger.error( 'function insertHFRequestDetail failed to save in DB for RunID ' + str(runId) + ': ', exc_info=True) if __name__ == '__main__': '''Start of the Program to it will keep looking for now time records in ScheduleDatetbl ''' timeNow = time(int(datetime.now().strftime('%H')), int(datetime.now().strftime('%M'))) #-------------------------------------------------------------------------------------------- ''' first line is for production, second line is for testing ''' #data=session.query(ScheduleDatetbl).filter_by(ScheduleTime=timeNow).all() data = session.query(ScheduleDatetbl).filter_by(ScheduleDatesId=185).all() #data=session.query(ScheduleDatetbl).all() #-------------------------------------------------------------------------------------------- for sched in data: reqID = sched.SD_RequestId print('Schedule Request ID', reqID) typeOfRequest = session.query(requestMastertbl).filter_by( RequestId=reqID).one().RequestModeId if typeOfRequest == 2: requestinput = session.query(hotelRequestInputtbl).filter_by( RequestId=reqID) if typeOfRequest == 3: requestinput = session.query(hotelflightrequestinputtbl).filter_by( RequestId=reqID) noOfReq = requestinput.count() reqRun = requestRunDetailtbl(