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'))
def filter_customer_contact_name(contact_id, default='-'):
"""
客户联系人员
:param contact_id:
:param default:
:return:
"""
if not contact_id:
return default
customer_contact_info = get_customer_contact_row_by_id(contact_id)
return customer_contact_info.name if customer_contact_info else default
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'))
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'))
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)
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)
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)
