예제 #1
0
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)
예제 #2
0
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)