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(
