Example #1
0
def stats_item(user_id):
    """
    用户统计明细
    :param user_id:
    :return:
    """
    user_info = get_user_row_by_id(user_id)
    # 检查资源是否存在
    if not user_info:
        abort(404)
    # 检查资源是否删除
    if user_info.status_delete == STATUS_DEL_OK:
        abort(410)

    # 统计数据
    user_stats_item_info = get_user_row_by_id(user_id)
    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('user stats item')
    # 渲染模板
    return render_template(
        'user/stats_item.html',
        user_stats_item_info=user_stats_item_info,
        **document_info
    )
Example #2
0
def filter_user_name(user_id):
    """
    用户姓名
    :param user_id:
    :return:
    """
    user_info = get_user_row_by_id(user_id)
    return user_info.name if user_info else '-'
Example #3
0
def ajax_delete():
    """
    用户删除
    :return:
    """
    ajax_success_msg = AJAX_SUCCESS_MSG.copy()
    ajax_failure_msg = AJAX_FAILURE_MSG.copy()

    # 检查删除权限
    if not permission_user_section_del.can():
        ext_msg = _('Permission Denied')
        ajax_failure_msg['msg'] = _('Del Failure, %(ext_msg)s', ext_msg=ext_msg)
        return jsonify(ajax_failure_msg)

    # 检查请求方法
    if not (request.method == 'GET' and request.is_xhr):
        ext_msg = _('Method Not Allowed')
        ajax_failure_msg['msg'] = _('Del Failure, %(ext_msg)s', ext_msg=ext_msg)
        return jsonify(ajax_failure_msg)

    # 检查请求参数
    user_id = request.args.get('user_id', 0, type=int)
    if not user_id:
        ext_msg = _('ID does not exist')
        ajax_failure_msg['msg'] = _('Del Failure, %(ext_msg)s', ext_msg=ext_msg)
        return jsonify(ajax_failure_msg)

    user_info = get_user_row_by_id(user_id)
    # 检查资源是否存在
    if not user_info:
        ext_msg = _('ID does not exist')
        ajax_failure_msg['msg'] = _('Del Failure, %(ext_msg)s', ext_msg=ext_msg)
        return jsonify(ajax_failure_msg)
    # 检查资源是否删除
    if user_info.status_delete == STATUS_DEL_OK:
        ext_msg = _('Already deleted')
        ajax_failure_msg['msg'] = _('Del Failure, %(ext_msg)s', ext_msg=ext_msg)
        return jsonify(ajax_failure_msg)
    # 检查是否正在使用
    # 报价、订单
    if count_quotation(**{'uid': user_id, 'status_delete': STATUS_DEL_NO}):
        ext_msg = _('Currently In Use')
        ajax_failure_msg['msg'] = _('Del Failure, %(ext_msg)s', ext_msg=ext_msg)
        return jsonify(ajax_failure_msg)

    current_time = datetime.utcnow()
    user_data = {
        'status_delete': STATUS_DEL_OK,
        'delete_time': current_time,
        'update_time': current_time,
    }
    result = edit_user(user_id, user_data)
    if result:
        ajax_success_msg['msg'] = _('Del Success')
        return jsonify(ajax_success_msg)
    else:
        ajax_failure_msg['msg'] = _('Del Failure')
        return jsonify(ajax_failure_msg)
Example #4
0
def pdf(sales_order_id):
    """
    文件下载
    :param sales_order_id:
    :return:
    """
    sales_order_info = get_sales_order_row_by_id(sales_order_id)
    # 检查资源是否存在
    if not sales_order_info:
        abort(404)
    # 检查资源是否删除
    if sales_order_info.status_delete == STATUS_DEL_OK:
        abort(410)

    sales_order_print_date = time_utc_to_local(
        sales_order_info.update_time).strftime('%Y-%m-%d')
    sales_order_code = '%s%s' % (
        g.SALES_ORDER_PREFIX, time_utc_to_local(
            sales_order_info.create_time).strftime('%y%m%d%H%M%S'))

    # 获取客户公司信息
    customer_info = get_customer_row_by_id(sales_order_info.customer_cid)

    # 获取客户联系方式
    customer_contact_info = get_customer_contact_row_by_id(
        sales_order_info.customer_contact_id)

    # 获取询价人员信息
    user_info = get_user_row_by_id(sales_order_info.uid)

    sales_order_items = get_sales_order_items_rows(
        sales_order_id=sales_order_id)

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('sales order pdf')

    template_name = 'sales/order/pdf.html'

    html = render_template(template_name,
                           sales_order_id=sales_order_id,
                           sales_order_info=sales_order_info,
                           customer_info=customer_info,
                           customer_contact_info=customer_contact_info,
                           user_info=user_info,
                           sales_order_items=sales_order_items,
                           sales_order_print_date=sales_order_print_date,
                           sales_order_code=sales_order_code,
                           **document_info)
    # return html
    return render_pdf(
        html=HTML(string=html),
        stylesheets=[CSS(string='@page {size:A4; margin:35px;}')],
        download_filename='采购订单.pdf'.encode('utf-8'))
Example #5
0
def pdf(buyer_order_id):
    """
    文件下载
    :param buyer_order_id:
    :return:
    """
    buyer_order_info = get_buyer_order_row_by_id(buyer_order_id)
    # 检查资源是否存在
    if not buyer_order_info:
        abort(404)
    # 检查资源是否删除
    if buyer_order_info.status_delete == STATUS_DEL_OK:
        abort(410)

    buyer_order_print_date = time_utc_to_local(
        buyer_order_info.update_time).strftime('%Y-%m-%d')
    buyer_order_code = '%s%s' % (
        g.BUYER_ORDER_PREFIX, time_utc_to_local(
            buyer_order_info.create_time).strftime('%y%m%d%H%M%S'))

    # 获取渠道公司信息
    supplier_info = get_supplier_row_by_id(buyer_order_info.supplier_cid)

    # 获取渠道联系方式
    supplier_contact_info = get_supplier_contact_row_by_id(
        buyer_order_info.supplier_contact_id)

    # 获取询价人员信息
    user_info = get_user_row_by_id(buyer_order_info.uid)

    buyer_order_items = get_buyer_order_items_rows(
        buyer_order_id=buyer_order_id)

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('buyer order pdf')

    template_name = 'buyer/order/pdf.html'

    html = render_template(template_name,
                           buyer_order_id=buyer_order_id,
                           buyer_order_info=buyer_order_info,
                           supplier_info=supplier_info,
                           supplier_contact_info=supplier_contact_info,
                           user_info=user_info,
                           buyer_order_items=buyer_order_items,
                           buyer_order_print_date=buyer_order_print_date,
                           buyer_order_code=buyer_order_code,
                           **document_info)
    # return html
    return render_pdf(
        html=HTML(string=html),
        stylesheets=[CSS(string='@page {size:A4; margin:35px;}')],
        download_filename='采购订单.pdf'.encode('utf-8'))
Example #6
0
def pdf(purchase_id):
    """
    文件下载
    :param purchase_id:
    :return:
    """
    purchase_info = get_purchase_row_by_id(purchase_id)
    # 检查资源是否存在
    if not purchase_info:
        abort(404)
    # 检查资源是否删除
    if purchase_info.status_delete == STATUS_DEL_OK:
        abort(410)

    purchase_print_date = time_utc_to_local(
        purchase_info.update_time).strftime('%Y-%m-%d')
    purchase_code = '%s%s' % (
        g.ENQUIRIES_PREFIX, time_utc_to_local(
            purchase_info.create_time).strftime('%y%m%d%H%M%S'))

    # 获取渠道公司信息
    supplier_info = get_supplier_row_by_id(purchase_info.supplier_cid)

    # 获取渠道联系方式
    supplier_contact_info = get_supplier_contact_row_by_id(
        purchase_info.supplier_contact_id)

    # 获取进货人员信息
    user_info = get_user_row_by_id(purchase_info.uid)

    purchase_items = get_purchase_items_rows(purchase_id=purchase_id)

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('purchase pdf')

    template_name = 'purchase/pdf.html'

    html = render_template(template_name,
                           purchase_id=purchase_id,
                           purchase_info=purchase_info,
                           supplier_info=supplier_info,
                           supplier_contact_info=supplier_contact_info,
                           user_info=user_info,
                           purchase_items=purchase_items,
                           purchase_print_date=purchase_print_date,
                           purchase_code=purchase_code,
                           **document_info)
    # return html
    return render_pdf(
        html=HTML(string=html),
        stylesheets=[CSS(string='@page {size:A4; margin:35px;}')],
        download_filename='销售出货.pdf'.encode('utf-8'))
Example #7
0
def pdf(enquiry_id):
    """
    文件下载
    :param enquiry_id:
    :return:
    """
    enquiry_info = get_enquiry_row_by_id(enquiry_id)
    # 检查资源是否存在
    if not enquiry_info:
        abort(404)
    # 检查资源是否删除
    if enquiry_info.status_delete == STATUS_DEL_OK:
        abort(410)

    enquiry_print_date = time_utc_to_local(
        enquiry_info.update_time).strftime('%Y-%m-%d')
    enquiry_code = '%s%s' % (
        g.ENQUIRIES_PREFIX, time_utc_to_local(
            enquiry_info.create_time).strftime('%y%m%d%H%M%S'))

    # 获取客户公司信息
    supplier_info = get_supplier_row_by_id(enquiry_info.supplier_cid)

    # 获取客户联系方式
    supplier_contact_info = get_supplier_contact_row_by_id(
        enquiry_info.supplier_contact_id)

    # 获取询价人员信息
    user_info = get_user_row_by_id(enquiry_info.uid)

    enquiry_items = get_enquiry_items_rows(enquiry_id=enquiry_id)

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('enquiry edit')

    template_name = 'enquiry/pdf.html'

    html = render_template(template_name,
                           enquiry_id=enquiry_id,
                           enquiry_info=enquiry_info,
                           supplier_info=supplier_info,
                           supplier_contact_info=supplier_contact_info,
                           user_info=user_info,
                           enquiry_items=enquiry_items,
                           enquiry_print_date=enquiry_print_date,
                           enquiry_code=enquiry_code,
                           **document_info)
    # return html
    return render_pdf(
        html=HTML(string=html),
        stylesheets=[CSS(string='@page {size:A4; margin:35px;}')],
        download_filename='询价单.pdf'.encode('utf-8'))
Example #8
0
def pdf(quotation_id):
    """
    文件下载
    :param quotation_id:
    :return:
    """
    quotation_info = get_quotation_row_by_id(quotation_id)
    # 检查资源是否存在
    if not quotation_info:
        abort(404)
    # 检查资源是否删除
    if quotation_info.status_delete == STATUS_DEL_OK:
        abort(410)

    quotation_print_date = time_utc_to_local(
        quotation_info.update_time).strftime('%Y-%m-%d')
    quotation_code = '%s%s' % (
        g.QUOTATION_PREFIX, time_utc_to_local(
            quotation_info.create_time).strftime('%y%m%d%H%M%S'))

    # 获取客户公司信息
    customer_info = get_customer_row_by_id(quotation_info.customer_cid)

    # 获取客户联系方式
    customer_contact_info = get_customer_contact_row_by_id(
        quotation_info.customer_contact_id)

    # 获取报价人员信息
    user_info = get_user_row_by_id(quotation_info.uid)

    quotation_items = get_quotation_items_rows(quotation_id=quotation_id)

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('quotation download')

    template_name = 'quotation/pdf.html'

    html = render_template(template_name,
                           quotation_id=quotation_id,
                           quotation_info=quotation_info,
                           customer_info=customer_info,
                           customer_contact_info=customer_contact_info,
                           user_info=user_info,
                           quotation_items=quotation_items,
                           quotation_print_date=quotation_print_date,
                           quotation_code=quotation_code,
                           **document_info)
    # return html
    return render_pdf(
        html=HTML(string=html),
        stylesheets=[CSS(string='@page {size:A4; margin:35px;}')],
        download_filename='报价单.pdf'.encode('utf-8'))
Example #9
0
def pdf(delivery_id):
    """
    文件下载
    :param delivery_id:
    :return:
    """
    delivery_info = get_delivery_row_by_id(delivery_id)
    # 检查资源是否存在
    if not delivery_info:
        abort(404)
    # 检查资源是否删除
    if delivery_info.status_delete == STATUS_DEL_OK:
        abort(410)

    delivery_print_date = time_utc_to_local(
        delivery_info.update_time).strftime('%Y-%m-%d')
    delivery_code = '%s%s' % (
        g.ENQUIRIES_PREFIX, time_utc_to_local(
            delivery_info.create_time).strftime('%y%m%d%H%M%S'))

    # 获取客户公司信息
    customer_info = get_customer_row_by_id(delivery_info.customer_cid)

    # 获取客户联系方式
    customer_contact_info = get_customer_contact_row_by_id(
        delivery_info.customer_contact_id)

    # 获取出货人员信息
    user_info = get_user_row_by_id(delivery_info.uid)

    delivery_items = get_delivery_items_rows(delivery_id=delivery_id)

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('delivery pdf')

    template_name = 'delivery/pdf.html'

    html = render_template(template_name,
                           delivery_id=delivery_id,
                           delivery_info=delivery_info,
                           customer_info=customer_info,
                           customer_contact_info=customer_contact_info,
                           user_info=user_info,
                           delivery_items=delivery_items,
                           delivery_print_date=delivery_print_date,
                           delivery_code=delivery_code,
                           **document_info)
    # return html
    return render_pdf(
        html=HTML(string=html),
        stylesheets=[CSS(string='@page {size:A4; margin:35px;}')],
        download_filename='销售出货.pdf'.encode('utf-8'))
Example #10
0
    def __call__(self, form, field):
        # 用户异常处理
        user_info = get_user_row_by_id(field.data)

        if not user_info:
            raise ValidationError(u'异常操作,此用户不存在')
        if user_info.status_delete == int(STATUS_DEL_OK):
            raise ValidationError(u'异常操作,此用户已删除')

        user_profile_info = get_user_profile_row_by_id(field.data)
        if not user_profile_info:
            raise ValidationError(u'异常操作,此用户不存在')
Example #11
0
def info(enquiry_id):
    """
    询价详情
    :param enquiry_id:
    :return:
    """
    # 详情数据
    enquiry_info = get_enquiry_row_by_id(enquiry_id)
    # 检查资源是否存在
    if not enquiry_info:
        abort(404)
    # 检查资源是否删除
    if enquiry_info.status_delete == STATUS_DEL_OK:
        abort(410)

    enquiry_print_date = time_utc_to_local(
        enquiry_info.update_time).strftime('%Y-%m-%d')
    enquiry_code = '%s%s' % (
        g.ENQUIRIES_PREFIX, time_utc_to_local(
            enquiry_info.create_time).strftime('%y%m%d%H%M%S'))

    # 获取渠道公司信息
    supplier_info = get_supplier_row_by_id(enquiry_info.supplier_cid)

    # 获取渠道联系方式
    supplier_contact_info = get_supplier_contact_row_by_id(
        enquiry_info.supplier_contact_id)

    # 获取询价人员信息
    user_info = get_user_row_by_id(enquiry_info.uid)

    enquiry_items = get_enquiry_items_rows(enquiry_id=enquiry_id)

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('enquiry info')

    template_name = 'enquiry/info.html'

    return render_template(template_name,
                           enquiry_id=enquiry_id,
                           enquiry_info=enquiry_info,
                           supplier_info=supplier_info,
                           supplier_contact_info=supplier_contact_info,
                           user_info=user_info,
                           enquiry_items=enquiry_items,
                           enquiry_print_date=enquiry_print_date,
                           enquiry_code=enquiry_code,
                           **document_info)
Example #12
0
def preview(sales_order_id):
    """
    打印预览
    :param sales_order_id:
    :return:
    """
    sales_order_info = get_sales_order_row_by_id(sales_order_id)
    # 检查资源是否存在
    if not sales_order_info:
        abort(404)
    # 检查资源是否删除
    if sales_order_info.status_delete == STATUS_DEL_OK:
        abort(410)

    sales_order_print_date = time_utc_to_local(
        sales_order_info.update_time).strftime('%Y-%m-%d')
    sales_order_code = '%s%s' % (
        g.SALES_ORDER_PREFIX, time_utc_to_local(
            sales_order_info.create_time).strftime('%y%m%d%H%M%S'))

    # 获取渠道公司信息
    customer_info = get_customer_row_by_id(sales_order_info.customer_cid)

    # 获取渠道联系方式
    customer_contact_info = get_customer_contact_row_by_id(
        sales_order_info.customer_contact_id)

    # 获取询价人员信息
    user_info = get_user_row_by_id(sales_order_info.uid)

    sales_order_items = get_sales_order_items_rows(
        sales_order_id=sales_order_id)

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('sales order preview')

    template_name = 'sales/order/preview.html'

    return render_template(template_name,
                           sales_order_id=sales_order_id,
                           sales_order_info=sales_order_info,
                           customer_info=customer_info,
                           customer_contact_info=customer_contact_info,
                           user_info=user_info,
                           sales_order_items=sales_order_items,
                           sales_order_print_date=sales_order_print_date,
                           sales_order_code=sales_order_code,
                           **document_info)
Example #13
0
def preview(buyer_order_id):
    """
    打印预览
    :param buyer_order_id:
    :return:
    """
    buyer_order_info = get_buyer_order_row_by_id(buyer_order_id)
    # 检查资源是否存在
    if not buyer_order_info:
        abort(404)
    # 检查资源是否删除
    if buyer_order_info.status_delete == STATUS_DEL_OK:
        abort(410)

    buyer_order_print_date = time_utc_to_local(
        buyer_order_info.update_time).strftime('%Y-%m-%d')
    buyer_order_code = '%s%s' % (
        g.BUYER_ORDER_PREFIX, time_utc_to_local(
            buyer_order_info.create_time).strftime('%y%m%d%H%M%S'))

    # 获取渠道公司信息
    supplier_info = get_supplier_row_by_id(buyer_order_info.supplier_cid)

    # 获取渠道联系方式
    supplier_contact_info = get_supplier_contact_row_by_id(
        buyer_order_info.supplier_contact_id)

    # 获取询价人员信息
    user_info = get_user_row_by_id(buyer_order_info.uid)

    buyer_order_items = get_buyer_order_items_rows(
        buyer_order_id=buyer_order_id)

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('buyer order preview')

    template_name = 'buyer/order/preview.html'

    return render_template(template_name,
                           buyer_order_id=buyer_order_id,
                           buyer_order_info=buyer_order_info,
                           supplier_info=supplier_info,
                           supplier_contact_info=supplier_contact_info,
                           user_info=user_info,
                           buyer_order_items=buyer_order_items,
                           buyer_order_print_date=buyer_order_print_date,
                           buyer_order_code=buyer_order_code,
                           **document_info)
Example #14
0
def preview(purchase_id):
    """
    打印预览
    :param purchase_id:
    :return:
    """
    purchase_info = get_purchase_row_by_id(purchase_id)
    # 检查资源是否存在
    if not purchase_info:
        abort(404)
    # 检查资源是否删除
    if purchase_info.status_delete == STATUS_DEL_OK:
        abort(410)

    purchase_print_date = time_utc_to_local(
        purchase_info.update_time).strftime('%Y-%m-%d')
    purchase_code = '%s%s' % (
        g.ENQUIRIES_PREFIX, time_utc_to_local(
            purchase_info.create_time).strftime('%y%m%d%H%M%S'))

    # 获取渠道公司信息
    supplier_info = get_supplier_row_by_id(purchase_info.supplier_cid)

    # 获取渠道联系方式
    supplier_contact_info = get_supplier_contact_row_by_id(
        purchase_info.supplier_contact_id)

    # 获取进货人员信息
    user_info = get_user_row_by_id(purchase_info.uid)

    purchase_items = get_purchase_items_rows(purchase_id=purchase_id)

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('purchase preview')

    template_name = 'purchase/preview.html'

    return render_template(template_name,
                           purchase_id=purchase_id,
                           purchase_info=purchase_info,
                           supplier_info=supplier_info,
                           supplier_contact_info=supplier_contact_info,
                           user_info=user_info,
                           purchase_items=purchase_items,
                           purchase_print_date=purchase_print_date,
                           purchase_code=purchase_code,
                           **document_info)
Example #15
0
def preview(delivery_id):
    """
    打印预览
    :param delivery_id:
    :return:
    """
    delivery_info = get_delivery_row_by_id(delivery_id)
    # 检查资源是否存在
    if not delivery_info:
        abort(404)
    # 检查资源是否删除
    if delivery_info.status_delete == STATUS_DEL_OK:
        abort(410)

    delivery_print_date = time_utc_to_local(
        delivery_info.update_time).strftime('%Y-%m-%d')
    delivery_code = '%s%s' % (
        g.ENQUIRIES_PREFIX, time_utc_to_local(
            delivery_info.create_time).strftime('%y%m%d%H%M%S'))

    # 获取客户公司信息
    customer_info = get_customer_row_by_id(delivery_info.customer_cid)

    # 获取客户联系方式
    customer_contact_info = get_customer_contact_row_by_id(
        delivery_info.customer_contact_id)

    # 获取出货人员信息
    user_info = get_user_row_by_id(delivery_info.uid)

    delivery_items = get_delivery_items_rows(delivery_id=delivery_id)

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('delivery preview')

    template_name = 'delivery/preview.html'

    return render_template(template_name,
                           delivery_id=delivery_id,
                           delivery_info=delivery_info,
                           customer_info=customer_info,
                           customer_contact_info=customer_contact_info,
                           user_info=user_info,
                           delivery_items=delivery_items,
                           delivery_print_date=delivery_print_date,
                           delivery_code=delivery_code,
                           **document_info)
Example #16
0
def preview(quotation_id):
    """
    打印预览
    :param quotation_id:
    :return:
    """
    quotation_info = get_quotation_row_by_id(quotation_id)
    # 检查资源是否存在
    if not quotation_info:
        abort(404)
    # 检查资源是否删除
    if quotation_info.status_delete == STATUS_DEL_OK:
        abort(410)

    quotation_print_date = time_utc_to_local(
        quotation_info.update_time).strftime('%Y-%m-%d')
    quotation_code = '%s%s' % (
        g.QUOTATION_PREFIX, time_utc_to_local(
            quotation_info.create_time).strftime('%y%m%d%H%M%S'))

    # 获取客户公司信息
    customer_info = get_customer_row_by_id(quotation_info.customer_cid)

    # 获取客户联系方式
    customer_contact_info = get_customer_contact_row_by_id(
        quotation_info.customer_contact_id)

    # 获取报价人员信息
    user_info = get_user_row_by_id(quotation_info.uid)

    quotation_items = get_quotation_items_rows(quotation_id=quotation_id)

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('quotation preview')

    template_name = 'quotation/preview.html'

    return render_template(template_name,
                           quotation_id=quotation_id,
                           quotation_info=quotation_info,
                           customer_info=customer_info,
                           customer_contact_info=customer_contact_info,
                           user_info=user_info,
                           quotation_items=quotation_items,
                           quotation_print_date=quotation_print_date,
                           quotation_code=quotation_code,
                           **document_info)
Example #17
0
def info(user_id):
    """
    用户详情
    :param user_id:
    :return:
    """
    # 详情数据
    user_info = get_user_row_by_id(user_id)
    # 检查资源是否存在
    if not user_info:
        abort(404)
    # 检查资源是否删除
    if user_info.status_delete == STATUS_DEL_OK:
        abort(410)
    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('user info')
    # 渲染模板
    return render_template('user/info.html', user_info=user_info, **document_info)
Example #18
0
def setting():
    """
    设置
    """
    # return "Hello, World!\nSetting!"
    form = UserProfileForm(request.form)
    if request.method == 'GET':
        from app_backend.api.user import get_user_row_by_id
        user_info = get_user_row_by_id(current_user.id)
        if user_info:
            form.nickname.data = user_info.nickname
            form.avatar_url.data = user_info.avatar_url
            form.email.data = user_info.email
            form.phone.data = user_info.phone
            form.birthday.data = user_info.birthday
            form.create_time.data = user_info.create_time
            form.update_time.data = user_info.update_time
    if request.method == 'POST':
        if form.validate_on_submit():
            # todo 判断邮箱是否重复
            from app_backend.api.user import edit_user
            from datetime import datetime
            user_info = {
                'nickname': form.nickname.data,
                'avatar_url': form.avatar_url.data,
                'email': form.email.data,
                'phone': form.phone.data,
                'birthday': form.birthday.data,
                'update_time': datetime.utcnow(),
                'last_ip': get_real_ip(),
            }
            result = edit_user(current_user.id, user_info)
            if result == 1:
                flash(u'修改成功', 'success')
            if result == 0:
                flash(u'修改失败', 'warning')
        flash(form.errors, 'warning')  # 调试打开
    flash(u'Hello, %s' % current_user.email, 'info')  # 测试打开
    return render_template('./setting.html', title='setting', form=form)
Example #19
0
def edit(user_id):
    """
    用户编辑
    """
    user_info = get_user_row_by_id(user_id)
    # 检查资源是否存在
    if not user_info:
        abort(404)
    # 检查资源是否删除
    if user_info.status_delete == STATUS_DEL_OK:
        abort(410)

    template_name = 'user/edit.html'

    # 加载编辑表单
    form = UserEditForm(request.form)
    form.id.data = user_id  # id 仅作为编辑重复校验

    # 文档信息
    document_info = DOCUMENT_INFO.copy()
    document_info['TITLE'] = _('user edit')

    # 进入编辑页面
    if request.method == 'GET':
        # 表单赋值
        form.id.data = user_info.id
        form.name.data = user_info.name
        form.salutation.data = user_info.salutation
        form.mobile.data = user_info.mobile
        form.tel.data = user_info.tel
        form.fax.data = user_info.fax
        form.email.data = user_info.email
        form.role_id.data = user_info.role_id
        form.create_time.data = user_info.create_time
        form.update_time.data = user_info.update_time
        # 渲染页面
        return render_template(
            template_name,
            user_id=user_id,
            form=form,
            **document_info
        )

    # 处理编辑请求
    if request.method == 'POST':
        # 表单校验失败
        if not form.validate_on_submit():
            flash(_('Edit Failure'), 'danger')
            # flash(form.errors, 'danger')
            return render_template(
                template_name,
                user_id=user_id,
                form=form,
                **document_info
            )

        # 非系统角色,仅能修改自己的信息
        if not permission_role_administrator.can():
            if getattr(current_user, 'id') != form.id.data:
                flash(_('Permission denied, only the user\'s own information can be modified'), 'danger')
                # flash(form.errors, 'danger')
                return render_template(
                    template_name,
                    user_id=user_id,
                    form=form,
                    **document_info
                )
        # 表单校验成功

        # 编辑用户基本信息
        current_time = datetime.utcnow()
        user_data = {
            'name': form.name.data,
            'salutation': form.salutation.data,
            'mobile': form.mobile.data,
            'tel': form.tel.data,
            'fax': form.fax.data,
            'email': form.email.data,
            'role_id': form.role_id.data,
            'update_time': current_time,
        }
        result = edit_user(user_id, user_data)
        if not result:
            # 编辑操作失败
            flash(_('Edit Failure'), 'danger')
            return render_template(
                template_name,
                user_id=user_id,
                form=form,
                **document_info
            )

        user_auth_row = get_user_auth_row(user_id=user_id)
        if not user_auth_row:
            # 编辑操作失败
            flash(_('Edit Failure'), 'danger')
            return render_template(
                template_name,
                user_id=user_id,
                form=form,
                **document_info
            )
        # 编辑用户认证信息
        user_auth_data = {
            'user_id': user_id,
            'type_auth': TYPE_AUTH_ACCOUNT,
            'auth_key': form.name.data,
            'update_time': current_time,
        }
        result = edit_user_auth(user_auth_row.id, user_auth_data)

        if not result:
            # 编辑操作失败
            flash(_('Edit Failure'), 'danger')
            return render_template(
                template_name,
                user_id=user_id,
                form=form,
                **document_info
            )
        # 编辑操作成功
        flash(_('Edit Success'), 'success')
        return redirect(request.args.get('next') or url_for('user.lists'))