def sales_orders_status_delete(sender, **extra):
"""
状态跟踪 - 删除状态
1、明细删除状态同步更新
:param sender:
:param extra:
:return:
"""
# print(sender, extra)
sales_order_id = extra.get('sales_order_id')
status_delete = extra.get('status_delete')
current_time = extra.get('current_time')
if not sales_order_id:
return
sales_order_items = get_sales_order_items_rows(sales_order_id=sales_order_id)
result = True
for sales_order_item in sales_order_items:
sales_order_item_id = sales_order_item.id
sales_order_item_data = {
'status_delete': status_delete,
'delete_time': current_time,
'update_time': current_time,
}
result = result and edit_sales_order_items(sales_order_item_id, sales_order_item_data)
return result
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 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 edit(sales_order_id):
"""
采购订单编辑
"""
# 检查编辑权限
# enquiry_item_edit_permission = EnquiryItemEditPermission(enquiry_id)
# if not enquiry_item_edit_permission.can():
# abort(403)
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)
# 检查资源是否核准
if sales_order_info.status_audit == STATUS_AUDIT_OK:
resource = _('Order')
abort(
exceptions.Locked.code,
_('The %(resource)s has been approved, it cannot be modified',
resource=resource))
template_name = 'sales/order/edit.html'
# 加载编辑表单
form = SalesOrderEditForm(request.form)
form.uid.choices = get_user_choices()
# form.status_order.choices = STATUS_ORDER_CHOICES
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('sales order edit')
# 进入编辑页面
if request.method == 'GET':
# 获取明细
sales_order_items = get_sales_order_items_rows(
sales_order_id=sales_order_id)
# 表单赋值
form.uid.data = sales_order_info.uid
form.customer_cid.data = sales_order_info.customer_cid
form.customer_contact_id.data = sales_order_info.customer_contact_id
form.type_tax.data = sales_order_info.type_tax
form.amount_order.data = sales_order_info.amount_order
# form.sales_order_items = sales_order_items
while len(form.sales_order_items) > 0:
form.sales_order_items.pop_entry()
for sales_order_item in sales_order_items:
sales_order_item_form = SalesOrderItemEditForm()
sales_order_item_form.id = sales_order_item.id
sales_order_item_form.sales_order_id = sales_order_item.sales_order_id
sales_order_item_form.uid = sales_order_item.uid
sales_order_item_form.custom_production_brand = sales_order_item.custom_production_brand
sales_order_item_form.custom_production_model = sales_order_item.custom_production_model
sales_order_item_form.production_id = sales_order_item.production_id
sales_order_item_form.production_brand = sales_order_item.production_brand
sales_order_item_form.production_model = sales_order_item.production_model
sales_order_item_form.production_sku = sales_order_item.production_sku
sales_order_item_form.delivery_time = sales_order_item.delivery_time
sales_order_item_form.quantity = sales_order_item.quantity
sales_order_item_form.unit_price = sales_order_item.unit_price
sales_order_item_form.note = sales_order_item.note
sales_order_item_form.type_tax = sales_order_item.type_tax
form.sales_order_items.append_entry(sales_order_item_form)
# 渲染页面
return render_template(template_name,
sales_order_id=sales_order_id,
form=form,
**document_info)
# 处理编辑请求
if request.method == 'POST':
# 增删数据行不需要校验表单
# 表单新增空行
if form.data_line_add.data is not None:
if form.sales_order_items.max_entries and len(
form.sales_order_items.entries
) >= form.sales_order_items.max_entries:
flash('最多创建%s条记录' % form.sales_order_items.max_entries,
'danger')
else:
form.sales_order_items.append_entry()
return render_template(template_name,
sales_order_id=sales_order_id,
form=form,
**document_info)
# 表单删除一行
if form.data_line_del.data is not None:
if form.sales_order_items.min_entries and len(
form.sales_order_items.entries
) <= form.sales_order_items.min_entries:
flash('最少保留%s条记录' % form.sales_order_items.min_entries,
'danger')
else:
data_line_index = form.data_line_del.data
form.sales_order_items.entries.pop(data_line_index)
return render_template(template_name,
sales_order_id=sales_order_id,
form=form,
**document_info)
# 表单校验失败
if not form.validate_on_submit():
flash(_('Edit Failure'), 'danger')
# flash(form.errors, 'danger')
# flash(form.sales_order_items.errors, 'danger')
return render_template(template_name,
sales_order_id=sales_order_id,
form=form,
**document_info)
# 表单校验成功
# 获取明细
sales_order_items = get_sales_order_items_rows(
sales_order_id=sales_order_id)
sales_order_items_ids = [item.id for item in sales_order_items]
# 数据新增、数据删除、数据修改
sales_order_items_ids_new = []
amount_sales_order = 0
for sales_order_item in form.sales_order_items.entries:
# 错误
if sales_order_item.form.id.data and sales_order_item.form.id.data not in sales_order_items_ids:
continue
sales_order_item_data = {
'sales_order_id':
sales_order_id,
'uid':
form.uid.data,
'customer_cid':
form.customer_cid.data,
'customer_company_name':
get_customer_row_by_id(form.customer_cid.data).company_name,
'custom_production_brand':
sales_order_item.form.custom_production_brand.data,
'custom_production_model':
sales_order_item.form.custom_production_model.data,
'production_id':
sales_order_item.form.production_id.data,
'production_brand':
sales_order_item.form.production_brand.data,
'production_model':
sales_order_item.form.production_model.data,
'production_sku':
sales_order_item.form.production_sku.data,
'delivery_time':
sales_order_item.form.delivery_time.data,
'quantity':
sales_order_item.form.quantity.data,
'unit_price':
sales_order_item.form.unit_price.data,
'note':
sales_order_item.form.note.data,
'type_tax':
form.type_tax.data,
}
if not sales_order_item.form.id.data:
# 新增
add_sales_order_items(sales_order_item_data)
amount_sales_order += sales_order_item_data[
'quantity'] * sales_order_item_data['unit_price']
else:
# 修改
edit_sales_order_items(sales_order_item.form.id.data,
sales_order_item_data)
amount_sales_order += sales_order_item_data[
'quantity'] * sales_order_item_data['unit_price']
sales_order_items_ids_new.append(sales_order_item.form.id.data)
# 删除
sales_order_items_ids_del = list(
set(sales_order_items_ids) - set(sales_order_items_ids_new))
for sales_order_items_id in sales_order_items_ids_del:
delete_sales_order_items(sales_order_items_id)
# 更新采购订单
current_time = datetime.utcnow()
sales_order_data = {
'uid': form.uid.data,
'customer_cid': form.customer_cid.data,
'customer_contact_id': form.customer_contact_id.data,
'type_tax': form.type_tax.data,
'amount_production': amount_sales_order,
'amount_order': amount_sales_order,
'update_time': current_time,
}
result = edit_sales_order(sales_order_id, sales_order_data)
# 编辑操作成功
if result:
flash(_('Edit Success'), 'success')
return redirect(
request.args.get('next') or url_for('sales_order.lists'))
# 编辑操作失败
else:
flash(_('Edit Failure'), 'danger')
return render_template(template_name,
sales_order_id=sales_order_id,
form=form,
**document_info)
def add():
template_name = 'sales/order/add.html'
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('sales order add')
# 加载创建表单
form = SalesOrderAddForm(request.form)
form.uid.choices = get_user_choices()
form.uid.data = current_user.id
# form.contact_id.choices = default_choices_int
# 进入创建页面
if request.method == 'GET':
# 克隆单据
from_type = request.args.get('from_type')
from_id = request.args.get('from_id', type=int)
# 克隆单据 - 报价单
if from_type == 'sales_order' and from_id:
sales_order_id = from_id
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_items = get_sales_order_items_rows(
sales_order_id=sales_order_id)
# 表单赋值
form.uid.data = sales_order_info.uid
form.customer_cid.data = sales_order_info.customer_cid
form.customer_contact_id.data = sales_order_info.customer_contact_id
form.delivery_way.data = sales_order_info.delivery_way
form.note.data = sales_order_info.note
form.amount_order.data = sales_order_info.amount_order
# form.quotation_items = quotation_items
while len(form.sales_order_items) > 0:
form.sales_order_items.pop_entry()
for sales_order_item in sales_order_items:
sales_order_item_form = SalesOrderItemEditForm()
sales_order_item_form.id = sales_order_item.id
sales_order_item_form.sales_order_id = sales_order_item.sales_order_id
sales_order_item_form.uid = sales_order_item.uid
sales_order_item_form.custom_production_brand = sales_order_item.custom_production_brand
sales_order_item_form.custom_production_model = sales_order_item.custom_production_model
sales_order_item_form.production_id = sales_order_item.production_id
sales_order_item_form.production_brand = sales_order_item.production_brand
sales_order_item_form.production_model = sales_order_item.production_model
sales_order_item_form.production_sku = sales_order_item.production_sku
sales_order_item_form.delivery_time = sales_order_item.delivery_time
sales_order_item_form.quantity = sales_order_item.quantity
sales_order_item_form.unit_price = sales_order_item.unit_price
sales_order_item_form.note = sales_order_item.note
sales_order_item_form.type_tax = sales_order_item.type_tax
form.sales_order_items.append_entry(sales_order_item_form)
# 渲染页面
return render_template(template_name, form=form, **document_info)
# 处理创建请求
if request.method == 'POST':
# 表单新增空行
if form.data_line_add.data is not None:
if form.sales_order_items.max_entries and len(
form.sales_order_items.entries
) >= form.sales_order_items.max_entries:
flash('最多创建%s条记录' % form.sales_order_items.max_entries,
'danger')
else:
form.sales_order_items.append_entry()
return render_template(template_name, form=form, **document_info)
# 表单删除一行
if form.data_line_del.data is not None:
if form.sales_order_items.min_entries and len(
form.sales_order_items.entries
) <= form.sales_order_items.min_entries:
flash('最少保留%s条记录' % form.sales_order_items.min_entries,
'danger')
else:
data_line_index = form.data_line_del.data
form.sales_order_items.entries.pop(data_line_index)
return render_template(template_name, form=form, **document_info)
# 表单校验失败
if not form.validate_on_submit():
flash(_('Add Failure'), 'danger')
# flash(form.errors, 'danger')
return render_template(template_name, form=form, **document_info)
# 表单校验成功
# 创建订单
current_time = datetime.utcnow()
sales_order_data = {
'uid': form.uid.data,
'customer_cid': form.customer_cid.data,
'customer_contact_id': form.customer_contact_id.data,
'type_tax': form.type_tax.data,
'delivery_way': form.delivery_way.data,
'create_time': current_time,
'update_time': current_time,
}
sales_order_id = add_sales_order(sales_order_data)
amount_sales_order = 0
for sales_order_item in form.sales_order_items.entries:
current_time = datetime.utcnow()
sales_order_item_data = {
'sales_order_id':
sales_order_id,
'uid':
form.uid.data,
'customer_cid':
form.customer_cid.data,
'customer_company_name':
get_customer_row_by_id(form.customer_cid.data).company_name,
'custom_production_brand':
sales_order_item.form.custom_production_brand.data,
'custom_production_model':
sales_order_item.form.custom_production_model.data,
'production_id':
sales_order_item.form.production_id.data,
'production_brand':
sales_order_item.form.production_brand.data,
'production_model':
sales_order_item.form.production_model.data,
'production_sku':
sales_order_item.form.production_sku.data,
'delivery_time':
sales_order_item.form.delivery_time.data,
'quantity':
sales_order_item.form.quantity.data,
'unit_price':
sales_order_item.form.unit_price.data,
'note':
sales_order_item.form.note.data,
'type_tax':
form.type_tax.data,
'create_time':
current_time,
'update_time':
current_time,
}
# 新增
add_sales_order_items(sales_order_item_data)
amount_sales_order += (sales_order_item_data['quantity'] or 0) * (
sales_order_item_data['unit_price'] or 0)
# 更新报价
sales_order_data = {
'amount_production': amount_sales_order,
'amount_order': amount_sales_order,
'update_time': current_time,
}
result = edit_sales_order(sales_order_id, sales_order_data)
# todo 事务
# 明细保存
# 总表保存
# 创建操作成功
if result:
flash(_('Add Success'), 'success')
return redirect(
request.args.get('next') or url_for('sales_order.lists'))
# 创建操作失败
else:
flash(_('Add Failure'), 'danger')
return render_template(template_name, form=form, **document_info)