def select():
global datetimes
global now
datetimes = datetime.datetime.now()
now = str(datetimes.year) + "-" + str(datetimes.month) + "-" + str(
datetimes.day) + "_" + str(datetimes.hour) + "-" + str(
datetimes.minute) + "-" + str(datetimes.second)
if request.method == 'POST':
printfile = request.files['uploadfile'] # 文件
place = request.form.get("place") # 打印点
copies = request.form.get("copies") # 份数
direction = request.form.get("direction") # 排版方向
colour = request.form.get("colour") # 彩色或黑白
paper_size = request.form.get("paper_size") # 纸张大小
print_way = request.form.get("print_way") # 单双面
time_way = request.form.get("time_way") # 预约或自动排队
pageCount = 1 # 文件页数
cost = 0.01
filename = printfile.filename
index_point = filename.rindex(".")
new_filename = str(
g.current_user.Tel_Number) + "_" + now + filename[index_point:]
# basepath = os.path.abspath(os.path.dirname(os.path.dirname(__file__)))
basepath = os.path.abspath(os.path.dirname(__file__)) # 当前文件所在目录
parentdir = os.path.dirname(basepath) # 父级目录
# 判断文件类型
# 识别不需要转换的文件
if filename[index_point:] in [".pdf", ".jpg", ".png", "jpeg"]:
upload_path = os.path.join(parentdir, 'static/Upload_Files',
secure_filename(new_filename))
printfile.save(upload_path)
if filename[index_point:] != '.pdf': # 图片文件一律按1页处理
pageCount = 1
cost = pageCount * cost
else:
# 读取页数
pageCount = read_pdf_pages(upload_path)
cost = pageCount * cost
# 需要转换格式的文件
else:
# 先将文件保存再处理
upload_path = os.path.join(
parentdir, 'static/Upload_Files/BeforeSwitchFile/',
secure_filename(new_filename))
printfile.save(upload_path)
# 对doc,ppt,xml文件转换，以及文件页数读取
switch = switch_topdf(upload_path)
if switch == 0:
i = new_filename.rindex(".")
new_filename = new_filename[:i] + ".pdf"
switched_dir = os.path.join(
parentdir, 'static/Upload_Files',
secure_filename(new_filename)) # 转换pdf后的文件路径
# 读取文件页数
pageCount = read_pdf_pages(switched_dir)
cost = pageCount * cost
else:
# 转换失败,返回用户文件格式不对
error = 1
return render_template('select.html', now=now, error=error)
# 写入数据库
user = User.query.filter(
User.Tel_Number == g.current_userphone).first()
order_forsql = Order()
order_forsql.User_Id = user.Id
order_forsql.File_Dir = new_filename
order_forsql.File_Name = filename
order_forsql.Time_Way = time_way
order_forsql.Print_Place = place
order_forsql.Print_Copies = copies
order_forsql.Print_Direction = direction
order_forsql.Print_Colour = colour
order_forsql.Print_size = paper_size
order_forsql.Print_way = print_way
order_forsql.Print_Money = cost
order_forsql.Print_Status = 0
order_forsql.Print_pages = pageCount
db.session.add(order_forsql)
db.session.commit()
param_order = Order.query.filter(Order.File_Dir == new_filename,
Order.User_Id == user.Id).first()
param = param_order.Id
param = (float(param) + 111) * 73 * 1.3
tradeid = str(g.current_user.Tel_Number) + "_" + now
data = {
"printfile": printfile,
"new_filename": new_filename,
"place": place,
"copies": copies,
"direction": direction,
"colour": colour,
"paper_size": paper_size,
"print_way": print_way,
"time_way": time_way,
"cost": cost,
"pageCount": pageCount,
"tradeid": new_filename
}
return render_template('confirm.html', data=data, param=param)
return render_template('select.html', now=now)
# @printer.route('/result', methods=['GET', 'POST'])
# def result():
# global result
# result = 0
# # user = User.query.filter(User.Tel_Number == g.current_userphone).first()
# # user_id = user.Id
# trade_number = request.args.get('out_trade_no')
# param = request.args.get('param')
# param = float(param)/1.3/73-111
# result_order = Order.query.filter(Order.Id == param).first()
# if result_order:
# result_order.Print_Status = 1
# result_order.Trade_Number = trade_number
# db.session.add(result_order)
# db.session.commit()
# result = 1
#
# return render_template('result.html', result=result)
# @printer.route('/test', methods=['GET', 'POST'])
# def test():
# data = {"printfile": 'printfile', "new_filename": 'new_filename', "place": 'place', "copies": 'copies', "direction": 'direction', "colour": 'colour', "paper_size": 'paper_size',
# "print_way": 'print_way', "time_way": 'time_way', "cost": 'cost', "pageCount": 'pageCount'}
# param = None
# return render_template('confirm.html', data=data, param=param)
def select():
# # 多文件上传
# money = 0
# page_count = 0
# new_filenames = []
# old_filenames = []
#
try:
max_id = db.session.query(db.func.max(Order.Id)).scalar() # 数据库最大的Id
xid = db.session.query(Order).filter(
Order.Id == max_id).first() # 通过最大Id 进行查找唯一的一列信息
macs = str(datetime.date.today()).replace('-', '') + '-' + str(
date_count(xid)) # 获取当前日期 + 当天已经销售的数目
except:
macs = str(datetime.date.today()).replace('-', '') + '-1'
pageCount = 0
cost = 0
datetimes = datetime.datetime.now()
now = str(datetimes.year) + "-" + str(datetimes.month) + "-" + str(
datetimes.day) + "_" + str(datetimes.hour) + "-" + str(
datetimes.minute) + "-" + str(datetimes.second)
form = Print()
datas = Order.query.order_by(Order.Id).limit(11)
user_datas = Order.query.order_by(
Order.User_Id == current_user.Id).limit(8)
if form.validate_on_submit():
if form.print_demand.data == '0':
print_file = form.print_file.data
print_place = form.print_place.data
print_copies = form.print_copies.data
print_type = form.print_type.data
print_color = form.print_color.data
print_size = form.print_size.data
print_way = form.print_way.data
print_time = form.print_time.data
time_way = form.print_demand.data
filename = print_file.filename
index_point = filename.rindex('.')
new_filename = str(
current_user.Tel_Number) + '_' + now + filename[index_point:]
basepath = os.path.abspath(os.path.dirname(__file__)) # 当前文件所在目录
parentdir = os.path.dirname(basepath) # 父级目录
upload_path = os.path.join(
parentdir, 'static/Upload_Files/BeforeSwitchFile/',
new_filename)
print_file.save(upload_path)
user = User.query.filter(
User.Tel_Number == current_user.Tel_Number).first()
order_forsql = Order()
order_forsql.Time_Way = time_way
order_forsql.User_Id = user.Id
order_forsql.File_Dir = new_filename
order_forsql.File_Name = filename
order_forsql.Print_Place = print_place
order_forsql.Print_Copies = print_copies
order_forsql.Print_Direction = print_type
order_forsql.Print_Colour = print_color
order_forsql.Print_size = print_size
order_forsql.Print_way = print_way
order_forsql.Print_Date = print_time
order_forsql.Trade_Number = macs
db.session.add(order_forsql)
db.session.commit()
data = {
"print_place": print_place,
"tradeid": macs,
"printfile": filename,
"now": now,
"print_copies": print_copies,
"user_tel": user.Tel_Number
}
identifi = ''
agent = request.environ.get('HTTP_USER_AGENT', '')
if ('AppleWebKit' in agent and 'Mobile' in agent):
identifi = 1
return render_template('use_templates/layui_pay_demand.html',
form=form,
data=data,
identifi=identifi)
else:
# all_file = request.files.getlist('print_file')
print_file = form.print_file.data
print_place = form.print_place.data
print_copies = form.print_copies.data
print_type = form.print_type.data
print_color = form.print_color.data
print_size = form.print_size.data
print_way = form.print_way.data
print_time = form.print_time.data
time_way = form.print_demand.data
if print_color == 'CMYGray':
print_cost = 0.2 * int(print_copies)
else:
print_cost = 0.8 * int(print_copies)
# for i in all_file:
filename = print_file.filename
index_point = filename.rindex('.')
new_filename = str(
current_user.Tel_Number) + '_' + now + filename[index_point:]
basepath = os.path.abspath(os.path.dirname(__file__)) # 当前文件所在目录
parentdir = os.path.dirname(basepath) # 父级目录
# 不需要转换的文件，pdf、jpg、png、jpeg
if filename[index_point:] in [".pdf", ".jpg", ".png", ".jpeg"]:
upload_path = os.path.join(parentdir, 'static/Upload_Files',
new_filename)
print_file.save(upload_path)
if filename[index_point:] != '.pdf':
pageCount = 1
cost = pageCount * print_cost + 0.2
else:
pageCount = read_pdf_pages(upload_path)
cost = pageCount * print_cost + 0.2
# 需要转换格式的文件
else:
upload_path = os.path.join(
parentdir, 'static/Upload_Files/BeforeSwitchFile/',
new_filename)
print_file.save(upload_path)
switchs = que.enqueue(switch_topdf, upload_path,
current_user.Id)
ps = conn.pubsub()
ps.subscribe(current_user.Id)
for i in ps.listen():
print(i)
if i['type'] == 'message':
if i['data'] == b'OK':
# redis_client.hset(current_user.Id, 'old_filename', filename)
sz = new_filename.rindex('.')
new_filename = new_filename[:sz] + '.pdf'
switched_dir = os.path.join(
parentdir, 'static/Upload_Files',
secure_filename(new_filename)) # 转换pdf后的文件路径
# 读取文件页数
pageCount = read_pdf_pages(switched_dir)
cost = pageCount * print_cost + 0.2
break
else:
# 转换失败,返回用户文件格式不对
flash('上传文件格式错误')
error = 1
return render_template(
'use_templates/layui_orderForGoods.html',
now=now,
error=error,
form=form)
else:
pass
user = User.query.filter(
User.Tel_Number == current_user.Tel_Number).first()
order_forsql = Order()
order_forsql.User_Id = user.Id
order_forsql.File_Dir = new_filename
order_forsql.File_Name = filename
order_forsql.Print_Place = print_place
order_forsql.Print_pages = pageCount
order_forsql.Print_Copies = print_copies
order_forsql.Print_Direction = print_type
order_forsql.Print_Colour = print_color
order_forsql.Print_size = print_size
order_forsql.Print_way = print_way
order_forsql.Print_Money = cost
order_forsql.Print_Date = print_time
order_forsql.Trade_Number = macs
order_forsql.Time_Way = time_way
db.session.add(order_forsql)
db.session.commit()
data = {
"printfile": filename,
"new_filename": new_filename,
"print_place": print_place,
"print_copies": print_copies,
"pageCount": pageCount,
"tradeid": macs,
"user_tel": user.Tel_Number,
"cost": round(cost, 2),
"now": now
}
identifi = ''
agent = request.environ.get('HTTP_USER_AGENT', '')
if ('AppleWebKit' in agent and 'Mobile' in agent):
identifi = 1
return render_template('use_templates/layui_pay_form.html',
form=form,
data=data,
identifi=identifi)
return render_template('use_templates/layui_orderForGoods.html',
now=now,
form=form,
datas=datas,
user_datas=user_datas)