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)