def stats_item(customer_id):
"""
客户统计明细
:param customer_id:
:return:
"""
customer_info = get_customer_row_by_id(customer_id)
# 检查资源是否存在
if not customer_info:
abort(404)
# 检查资源是否删除
if customer_info.status_delete == STATUS_DEL_OK:
abort(410)
# 统计数据
customer_stats_item_info = get_customer_row_by_id(customer_id)
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('customer stats item')
# 渲染模板
return render_template(
'customer/stats_item.html',
customer_stats_item_info=customer_stats_item_info,
**document_info
)
def add():
"""
创建敏感产品
:return:
"""
template_name = 'production/sensitive/add.html'
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('production sensitive add')
# 加载创建表单
form = ProductionSensitiveAddForm(request.form)
# 进入创建页面
if request.method == 'GET':
# 渲染页面
return render_template(template_name, form=form, **document_info)
# 处理创建请求
if request.method == 'POST':
# 表单校验失败
if not form.validate_on_submit():
flash(_('Add Failure'), 'danger')
return render_template(template_name, form=form, **document_info)
# 表单校验成功
current_time = datetime.utcnow()
production_sensitive_data = {
'customer_cid':
form.customer_cid.data,
'customer_company_name':
get_customer_row_by_id(form.customer_cid.data).company_name,
'production_id':
form.production_id.data,
'production_brand':
form.production_brand.data.upper(),
'production_model':
form.production_model.data.upper(),
'production_sku':
form.production_sku.data,
'note':
form.note.data,
'create_time':
current_time,
'update_time':
current_time,
}
result = add_production_sensitive(production_sensitive_data)
# 创建操作成功
if result:
flash(_('Add Success'), 'success')
return redirect(
request.args.get('next')
or url_for('production_sensitive.lists'))
# 创建操作失败
else:
flash(_('Add Failure'), 'danger')
return render_template(template_name, form=form, **document_info)
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_company_name(customer_id, default='-'):
"""
客户公司名称
:param customer_id:
:param default:
:return:
"""
if not customer_id:
return default
customer_info = get_customer_row_by_id(customer_id)
return customer_info.company_name if customer_info else default
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 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 ajax_delete():
"""
客户删除
:return:
"""
ajax_success_msg = AJAX_SUCCESS_MSG.copy()
ajax_failure_msg = AJAX_FAILURE_MSG.copy()
# 检查删除权限
if not permission_customer_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)
# 检查请求参数
customer_id = request.args.get('customer_id', 0, type=int)
if not customer_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)
customer_info = get_customer_row_by_id(customer_id)
# 检查资源是否存在
if not customer_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 customer_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)
current_time = datetime.utcnow()
customer_data = {
'status_delete': STATUS_DEL_OK,
'delete_time': current_time,
'update_time': current_time,
}
result = edit_customer(customer_id, customer_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)
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)
def info(customer_id):
"""
客户详情
:param customer_id:
:return:
"""
# 详情数据
customer_info = get_customer_row_by_id(customer_id)
# 检查资源是否存在
if not customer_info:
abort(404)
# 检查资源是否删除
if customer_info.status_delete == STATUS_DEL_OK:
abort(410)
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('customer info')
# 渲染模板
return render_template('customer/info.html',
customer_info=customer_info,
**document_info)
def edit(customer_id):
"""
客户编辑
"""
customer_info = get_customer_row_by_id(customer_id)
# 检查资源是否存在
if not customer_info:
abort(404)
# 检查资源是否删除
if customer_info.status_delete == STATUS_DEL_OK:
abort(410)
template_name = 'customer/edit.html'
# 加载编辑表单
form = CustomerEditForm(request.form)
form.owner_uid.choices = get_user_choices()
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('customer edit')
# 进入编辑页面
if request.method == 'GET':
# 表单赋值
form.id.data = customer_info.id
form.company_name.data = customer_info.company_name
form.company_address.data = customer_info.company_address
form.company_site.data = customer_info.company_site
form.company_tel.data = customer_info.company_tel
form.company_fax.data = customer_info.company_fax
form.company_email.data = customer_info.company_email
form.company_type.data = customer_info.company_type
form.owner_uid.data = customer_info.owner_uid
form.create_time.data = customer_info.create_time
form.update_time.data = customer_info.update_time
# 渲染页面
return render_template(template_name,
customer_id=customer_id,
form=form,
**document_info)
# 处理编辑请求
if request.method == 'POST':
# 表单校验失败
if customer_id != form.id.data or not form.validate_on_submit():
flash(_('Edit Failure'), 'danger')
# flash(form.errors, 'danger')
return render_template(template_name,
customer_id=customer_id,
form=form,
**document_info)
# 表单校验成功
current_time = datetime.utcnow()
customer_data = {
'company_name': form.company_name.data,
'company_address': form.company_address.data,
'company_site': form.company_site.data,
'company_tel': form.company_tel.data,
'company_fax': form.company_fax.data,
'company_email': form.company_email.data,
'company_type': form.company_type.data,
'owner_uid': form.owner_uid.data,
'update_time': current_time,
}
result = edit_customer(customer_id, customer_data)
# 编辑操作成功
if result:
flash(_('Edit Success'), 'success')
return redirect(
request.args.get('next') or url_for('customer.lists'))
# 编辑操作失败
else:
flash(_('Edit Failure'), 'danger')
return render_template(template_name,
customer_id=customer_id,
form=form,
**document_info)
def edit(quotation_id):
"""
报价编辑
"""
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)
template_name = 'quotation/edit.html'
# 加载编辑表单
form = QuotationEditForm(request.form)
form.uid.choices = get_user_choices()
form.status_order.choices = STATUS_ORDER_CHOICES
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('quotation edit')
# 进入编辑页面
if request.method == 'GET':
# 获取明细
quotation_items = get_quotation_items_rows(quotation_id=quotation_id)
# 表单赋值
form.uid.data = quotation_info.uid
form.customer_cid.data = quotation_info.customer_cid
form.customer_contact_id.data = quotation_info.customer_contact_id
form.delivery_way.data = quotation_info.delivery_way
form.note.data = quotation_info.note
form.status_order.data = quotation_info.status_order
form.amount_quotation.data = quotation_info.amount_quotation
# form.quotation_items = quotation_items
while len(form.quotation_items) > 0:
form.quotation_items.pop_entry()
for quotation_item in quotation_items:
quotation_item_form = QuotationItemEditForm()
quotation_item_form.id = quotation_item.id
quotation_item_form.quotation_id = quotation_item.quotation_id
quotation_item_form.uid = quotation_item.uid
quotation_item_form.enquiry_production_model = quotation_item.enquiry_production_model
quotation_item_form.enquiry_quantity = quotation_item.enquiry_quantity
quotation_item_form.production_id = quotation_item.production_id
quotation_item_form.production_brand = quotation_item.production_brand
quotation_item_form.production_model = quotation_item.production_model
quotation_item_form.production_sku = quotation_item.production_sku
quotation_item_form.note = quotation_item.note
quotation_item_form.quantity = quotation_item.quantity
quotation_item_form.unit_price = quotation_item.unit_price
quotation_item_form.delivery_time = quotation_item.delivery_time
quotation_item_form.status_ordered = quotation_item.status_ordered
form.quotation_items.append_entry(quotation_item_form)
# 渲染页面
return render_template(template_name,
quotation_id=quotation_id,
form=form,
**document_info)
# 处理编辑请求
if request.method == 'POST':
# 增删数据行不需要校验表单
# 表单新增空行
if form.data_line_add.data is not None:
if form.quotation_items.max_entries and len(
form.quotation_items.entries
) >= form.quotation_items.max_entries:
flash('最多创建%s条记录' % form.quotation_items.max_entries, 'danger')
else:
form.quotation_items.append_entry()
return render_template(template_name,
quotation_id=quotation_id,
form=form,
**document_info)
# 表单删除一行
if form.data_line_del.data is not None:
if form.quotation_items.min_entries and len(
form.quotation_items.entries
) <= form.quotation_items.min_entries:
flash('最少保留%s条记录' % form.quotation_items.min_entries, 'danger')
else:
data_line_index = form.data_line_del.data
form.quotation_items.entries.pop(data_line_index)
return render_template(template_name,
quotation_id=quotation_id,
form=form,
**document_info)
# 表单校验失败
if not form.validate_on_submit():
flash(_('Edit Failure'), 'danger')
# flash(form.errors, 'danger')
# flash(form.quotation_items.errors, 'danger')
return render_template(template_name,
quotation_id=quotation_id,
form=form,
**document_info)
# 表单校验成功
# 获取明细
quotation_items = get_quotation_items_rows(quotation_id=quotation_id)
quotation_items_ids = [item.id for item in quotation_items]
# 数据新增、数据删除、数据修改
quotation_items_ids_new = []
amount_quotation = 0
for quotation_item in form.quotation_items.entries:
# 错误
if quotation_item.form.id.data and quotation_item.form.id.data not in quotation_items_ids:
continue
quotation_item_data = {
'quotation_id':
quotation_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,
'enquiry_production_model':
quotation_item.form.enquiry_production_model.data,
'enquiry_quantity':
quotation_item.form.enquiry_quantity.data,
'production_id':
quotation_item.form.production_id.data,
'production_brand':
quotation_item.form.production_brand.data,
'production_model':
quotation_item.form.production_model.data,
'production_sku':
quotation_item.form.production_sku.data,
'note':
quotation_item.form.note.data,
'delivery_time':
quotation_item.form.delivery_time.data,
'quantity':
quotation_item.form.quantity.data,
'unit_price':
quotation_item.form.unit_price.data,
'status_ordered':
quotation_item.form.status_ordered.data,
}
if not quotation_item.form.id.data:
# 新增
add_quotation_items(quotation_item_data)
amount_quotation += quotation_item_data[
'quantity'] * quotation_item_data['unit_price']
else:
# 修改
edit_quotation_items(quotation_item.form.id.data,
quotation_item_data)
amount_quotation += quotation_item_data[
'quantity'] * quotation_item_data['unit_price']
quotation_items_ids_new.append(quotation_item.form.id.data)
# 删除
quotation_items_ids_del = list(
set(quotation_items_ids) - set(quotation_items_ids_new))
for quotation_items_id in quotation_items_ids_del:
delete_quotation_items(quotation_items_id)
# 更新报价
current_time = datetime.utcnow()
quotation_data = {
'customer_cid': form.customer_cid.data,
'uid': form.uid.data,
'customer_contact_id': form.customer_contact_id.data,
'delivery_way': form.delivery_way.data,
'note': form.note.data,
'status_order': form.status_order.data,
'amount_production': amount_quotation,
'amount_quotation': amount_quotation,
'update_time': current_time,
}
result = edit_quotation(quotation_id, quotation_data)
# 编辑操作成功
if result:
flash(_('Edit Success'), 'success')
return redirect(
request.args.get('next') or url_for('quotation.lists'))
# 编辑操作失败
else:
flash(_('Edit Failure'), 'danger')
return render_template(template_name,
quotation_id=quotation_id,
form=form,
**document_info)
def add():
"""
创建报价
:return:
"""
template_name = 'quotation/add.html'
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('quotation add')
# 加载创建表单
form = QuotationAddForm(request.form)
form.uid.choices = get_user_choices()
form.uid.data = current_user.id
form.status_order.choices = STATUS_ORDER_CHOICES
# 进入创建页面
if request.method == 'GET':
# 克隆单据
from_type = request.args.get('from_type')
from_id = request.args.get('from_id', type=int)
# 克隆单据 - 报价单
if from_type == 'quotation' and from_id:
quotation_id = from_id
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_items = get_quotation_items_rows(
quotation_id=quotation_id)
# 表单赋值
form.uid.data = quotation_info.uid
form.customer_cid.data = quotation_info.customer_cid
form.customer_contact_id.data = quotation_info.customer_contact_id
form.delivery_way.data = quotation_info.delivery_way
form.note.data = quotation_info.note
form.status_order.data = quotation_info.status_order
form.amount_quotation.data = quotation_info.amount_quotation
# form.quotation_items = quotation_items
while len(form.quotation_items) > 0:
form.quotation_items.pop_entry()
for quotation_item in quotation_items:
quotation_item_form = QuotationItemEditForm()
quotation_item_form.id = quotation_item.id
quotation_item_form.quotation_id = quotation_item.quotation_id
quotation_item_form.uid = quotation_item.uid
quotation_item_form.enquiry_production_model = quotation_item.enquiry_production_model
quotation_item_form.enquiry_quantity = quotation_item.enquiry_quantity
quotation_item_form.production_id = quotation_item.production_id
quotation_item_form.production_brand = quotation_item.production_brand
quotation_item_form.production_model = quotation_item.production_model
quotation_item_form.production_sku = quotation_item.production_sku
quotation_item_form.note = quotation_item.note
quotation_item_form.quantity = quotation_item.quantity
quotation_item_form.unit_price = quotation_item.unit_price
quotation_item_form.delivery_time = quotation_item.delivery_time
quotation_item_form.status_ordered = quotation_item.status_ordered
form.quotation_items.append_entry(quotation_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.quotation_items.max_entries and len(
form.quotation_items.entries
) >= form.quotation_items.max_entries:
flash('最多创建%s条记录' % form.quotation_items.max_entries, 'danger')
else:
form.quotation_items.append_entry()
return render_template(template_name, form=form, **document_info)
# 表单删除一行
if form.data_line_del.data is not None:
if form.quotation_items.min_entries and len(
form.quotation_items.entries
) <= form.quotation_items.min_entries:
flash('最少保留%s条记录' % form.quotation_items.min_entries, 'danger')
else:
data_line_index = form.data_line_del.data
form.quotation_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()
quotation_data = {
'uid':
form.uid.data,
'customer_cid':
form.customer_cid.data,
'customer_contact_id':
form.customer_contact_id.data,
'delivery_way':
form.delivery_way.data,
'note':
form.note.data,
'status_order':
form.status_order.data,
'expiry_date':
(datetime.utcnow() + timedelta(days=7)).strftime('%Y-%m-%d'),
'create_time':
current_time,
'update_time':
current_time,
}
quotation_id = add_quotation(quotation_data)
amount_quotation = 0
for quotation_item in form.quotation_items.entries:
current_time = datetime.utcnow()
quotation_item_data = {
'quotation_id':
quotation_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,
'enquiry_production_model':
quotation_item.form.enquiry_production_model.data,
'enquiry_quantity':
quotation_item.form.enquiry_quantity.data,
'production_id':
quotation_item.form.production_id.data,
'production_brand':
quotation_item.form.production_brand.data,
'production_model':
quotation_item.form.production_model.data,
'production_sku':
quotation_item.form.production_sku.data,
'note':
quotation_item.form.note.data,
'delivery_time':
quotation_item.form.delivery_time.data,
'quantity':
quotation_item.form.quantity.data,
'unit_price':
quotation_item.form.unit_price.data,
'status_ordered':
quotation_item.form.status_ordered.data,
'create_time':
current_time,
'update_time':
current_time,
}
# 新增
add_quotation_items(quotation_item_data)
amount_quotation += (quotation_item_data['quantity'] or
0) * (quotation_item_data['unit_price'] or 0)
# 更新报价
quotation_data = {
'amount_production': amount_quotation,
'amount_quotation': amount_quotation,
'update_time': current_time,
}
result = edit_quotation(quotation_id, quotation_data)
# todo 事务
# 明细保存
# 总表保存
# 创建操作成功
if result:
flash(_('Add Success'), 'success')
return redirect(
request.args.get('next') or url_for('quotation.lists'))
# 创建操作失败
else:
flash(_('Add Failure'), 'danger')
return render_template(template_name, form=form, **document_info)
def edit(delivery_id):
"""
销售出货编辑
"""
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)
# 检查资源是否核准
if delivery_info.status_audit == STATUS_AUDIT_OK:
resource = _('Delivery')
abort(
exceptions.Locked.code,
_('The %(resource)s has been approved, it cannot be modified',
resource=resource))
template_name = 'delivery/edit.html'
# 加载编辑表单
form = DeliveryEditForm(request.form)
form.uid.choices = get_user_choices()
form.warehouse_id.choices = get_warehouse_choices(option_type='update')
# 内嵌表单货架选项
for item_form in form.delivery_items:
item_form.rack_id.choices = get_rack_choices(form.warehouse_id.data,
option_type='update')
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('delivery edit')
# 进入编辑页面
if request.method == 'GET':
# 获取明细
delivery_items = get_delivery_items_rows(delivery_id=delivery_id)
# 表单赋值
form.uid.data = delivery_info.uid
form.customer_cid.data = delivery_info.customer_cid
form.customer_contact_id.data = delivery_info.customer_contact_id
form.type_tax.data = delivery_info.type_tax
form.warehouse_id.data = delivery_info.warehouse_id
form.amount_delivery.data = delivery_info.amount_delivery
# form.buyer_delivery_items = buyer_delivery_items
while len(form.delivery_items) > 0:
form.delivery_items.pop_entry()
for delivery_item in delivery_items:
delivery_item_form = DeliveryItemsEditForm()
delivery_item_form.id = delivery_item.id
delivery_item_form.delivery_id = delivery_item.delivery_id
delivery_item_form.uid = delivery_item.uid
# delivery_item_form.supplier_cid = delivery_item.supplier_cid
# delivery_item_form.supplier_company_name = delivery_item.supplier_company_name
delivery_item_form.custom_production_brand = delivery_item.custom_production_brand
delivery_item_form.custom_production_model = delivery_item.custom_production_model
delivery_item_form.production_id = delivery_item.production_id
delivery_item_form.production_brand = delivery_item.production_brand
delivery_item_form.production_model = delivery_item.production_model
delivery_item_form.production_sku = delivery_item.production_sku
delivery_item_form.quantity = delivery_item.quantity
delivery_item_form.unit_price = delivery_item.unit_price
delivery_item_form.rack_id = delivery_item.rack_id
delivery_item_form.note = delivery_item.note
delivery_item_form.type_tax = delivery_item.type_tax
form.delivery_items.append_entry(delivery_item_form)
# 内嵌表单货架选项
for item_form in form.delivery_items:
item_form.rack_id.choices = get_rack_choices(
form.warehouse_id.data, option_type='update')
# 渲染页面
return render_template(template_name,
delivery_id=delivery_id,
form=form,
**document_info)
# 处理编辑请求
if request.method == 'POST':
# 修改仓库 - 不做校验
if form.warehouse_changed.data:
form.warehouse_changed.data = ''
return render_template(template_name, form=form, **document_info)
# 增删数据行不需要校验表单
# 表单新增空行
if form.data_line_add.data is not None:
if form.delivery_items.max_entries and len(
form.delivery_items.entries
) >= form.delivery_items.max_entries:
flash('最多创建%s条记录' % form.delivery_items.max_entries, 'danger')
else:
form.delivery_items.append_entry()
# 内嵌表单货架选项
for item_form in form.delivery_items:
item_form.rack_id.choices = get_rack_choices(
form.warehouse_id.data, option_type='update')
return render_template(template_name,
delivery_id=delivery_id,
form=form,
**document_info)
# 表单删除一行
if form.data_line_del.data is not None:
if form.delivery_items.min_entries and len(
form.delivery_items.entries
) <= form.delivery_items.min_entries:
flash('最少保留%s条记录' % form.delivery_items.min_entries, 'danger')
else:
data_line_index = form.data_line_del.data
form.delivery_items.entries.pop(data_line_index)
return render_template(template_name,
delivery_id=delivery_id,
form=form,
**document_info)
# 表单校验失败
if not form.validate_on_submit():
flash(_('Edit Failure'), 'danger')
# flash(form.errors, 'danger')
# flash(form.delivery_items.errors, 'danger')
return render_template(template_name,
delivery_id=delivery_id,
form=form,
**document_info)
# 表单校验成功
# 获取明细
delivery_items = get_delivery_items_rows(delivery_id=delivery_id)
delivery_items_ids = [item.id for item in delivery_items]
# 数据新增、数据删除、数据修改
delivery_items_ids_new = []
amount_delivery = 0
for delivery_item in form.delivery_items.entries:
# 错误
if delivery_item.form.id.data and delivery_item.form.id.data not in delivery_items_ids:
continue
delivery_item_data = {
'delivery_id':
delivery_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':
delivery_item.form.custom_production_brand.data,
'custom_production_model':
delivery_item.form.custom_production_model.data,
'production_id':
delivery_item.form.production_id.data,
'production_brand':
delivery_item.form.production_brand.data,
'production_model':
delivery_item.form.production_model.data,
'production_sku':
delivery_item.form.production_sku.data,
'quantity':
delivery_item.form.quantity.data,
'unit_price':
delivery_item.form.unit_price.data,
'warehouse_id':
form.warehouse_id.data,
'rack_id':
delivery_item.form.rack_id.data,
'note':
delivery_item.form.note.data,
'type_tax':
form.type_tax.data,
}
if not delivery_item.form.id.data:
# 新增
add_delivery_items(delivery_item_data)
amount_delivery += delivery_item_data[
'quantity'] * delivery_item_data['unit_price']
else:
# 修改
edit_delivery_items(delivery_item.form.id.data,
delivery_item_data)
amount_delivery += delivery_item_data[
'quantity'] * delivery_item_data['unit_price']
delivery_items_ids_new.append(delivery_item.form.id.data)
# 删除
delivery_items_ids_del = list(
set(delivery_items_ids) - set(delivery_items_ids_new))
for delivery_items_id in delivery_items_ids_del:
delete_delivery_items(delivery_items_id)
# 更新销售出货
current_time = datetime.utcnow()
delivery_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_delivery,
'amount_delivery': amount_delivery,
'warehouse_id': form.warehouse_id.data,
'update_time': current_time,
}
result = edit_delivery(delivery_id, delivery_data)
# 编辑操作成功
if result:
flash(_('Edit Success'), 'success')
return redirect(
request.args.get('next') or url_for('delivery.lists'))
# 编辑操作失败
else:
flash(_('Edit Failure'), 'danger')
return render_template(template_name,
delivery_id=delivery_id,
form=form,
**document_info)
def edit(customer_id):
"""
客户开票资料编辑
"""
customer_info = get_customer_row_by_id(customer_id)
# 检查资源是否存在
if not customer_info:
abort(404)
# 检查资源是否删除
if customer_info.status_delete == STATUS_DEL_OK:
abort(410)
customer_invoice_info = get_customer_invoice_row_by_id(customer_id)
template_name = 'customer/invoice/edit.html'
# 加载编辑表单
form = CustomerInvoiceEditForm(request.form)
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('customer invoice edit')
# 进入编辑页面
if request.method == 'GET':
current_time = datetime.utcnow()
# 表单赋值
form.cid.data = customer_id
form.company_name.data = getattr(customer_invoice_info, 'company_name',
customer_info.company_name)
form.company_address.data = getattr(customer_invoice_info,
'company_address', '')
form.company_tel.data = getattr(customer_invoice_info, 'company_tel',
'')
form.company_bank_name.data = getattr(customer_invoice_info,
'company_bank_name', '')
form.company_bank_account.data = getattr(customer_invoice_info,
'company_bank_account', '')
form.create_time.data = getattr(customer_invoice_info, 'create_time',
current_time)
form.update_time.data = getattr(customer_invoice_info, 'update_time',
current_time)
# 渲染页面
return render_template(template_name,
customer_id=customer_id,
form=form,
**document_info)
# 处理编辑请求
if request.method == 'POST':
# 表单校验失败
if customer_id != form.cid.data or not form.validate_on_submit():
flash(_('Edit Failure'), 'danger')
# flash(form.errors, 'danger')
return render_template(template_name,
customer_id=customer_id,
form=form,
**document_info)
# 表单校验成功
current_time = datetime.utcnow()
customer_invoice_data = {
'company_name': form.company_name.data,
'company_tax_id': form.company_tax_id.data,
'company_address': form.company_address.data,
'company_tel': form.company_tel.data,
'company_bank_name': form.company_bank_name.data,
'company_bank_account': form.company_bank_account.data,
'update_time': current_time,
}
if customer_invoice_info:
# 修改
result = edit_customer_invoice(customer_id, customer_invoice_data)
else:
# 创建
customer_invoice_data['cid'] = customer_id
result = add_customer_invoice(customer_invoice_data)
# 编辑操作成功
if result:
flash(_('Edit Success'), 'success')
return redirect(
request.args.get('next') or url_for('customer_invoice.lists'))
# 编辑操作失败
else:
flash(_('Edit Failure'), 'danger')
return render_template(template_name,
customer_id=customer_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)
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 edit(production_sensitive_id):
"""
敏感产品编辑
"""
production_sensitive_info = get_production_sensitive_row_by_id(
production_sensitive_id)
# 检查资源是否存在
if not production_sensitive_info:
abort(404)
# 检查资源是否删除
if production_sensitive_info.status_delete == STATUS_DEL_OK:
abort(410)
template_name = 'production/sensitive/edit.html'
# 加载编辑表单
form = ProductionSensitiveEditForm(request.form)
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('production sensitive edit')
# 进入编辑页面
if request.method == 'GET':
# 表单赋值
form.id.data = production_sensitive_info.id
form.customer_cid.data = production_sensitive_info.customer_cid
form.customer_company_name.data = production_sensitive_info.customer_company_name
form.production_id.data = production_sensitive_info.production_id
form.production_brand.data = production_sensitive_info.production_brand
form.production_model.data = production_sensitive_info.production_model
form.production_sku.data = production_sensitive_info.production_sku
form.note.data = production_sensitive_info.note
form.create_time.data = production_sensitive_info.create_time
form.update_time.data = production_sensitive_info.update_time
# 渲染页面
return render_template(template_name,
production_sensitive_id=production_sensitive_id,
form=form,
**document_info)
# 处理编辑请求
if request.method == 'POST':
# 表单校验失败
if production_sensitive_id != form.id.data or not form.validate_on_submit(
):
flash(_('Edit Failure'), 'danger')
return render_template(
template_name,
production_sensitive_id=production_sensitive_id,
form=form,
**document_info)
# 表单校验成功
current_time = datetime.utcnow()
production_sensitive_data = {
'customer_cid':
form.customer_cid.data,
'customer_company_name':
get_customer_row_by_id(form.customer_cid.data).company_name,
'production_id':
form.production_id.data,
'production_brand':
form.production_brand.data.upper(),
'production_model':
form.production_model.data.upper(),
'production_sku':
form.production_sku.data,
'note':
form.note.data,
'update_time':
current_time,
}
result = edit_production_sensitive(production_sensitive_id,
production_sensitive_data)
# 编辑操作成功
if result:
flash(_('Edit Success'), 'success')
return redirect(
request.args.get('next')
or url_for('production_sensitive.lists'))
# 编辑操作失败
else:
flash(_('Edit Failure'), 'danger')
return render_template(
template_name,
production_sensitive_id=production_sensitive_id,
form=form,
**document_info)
def ajax_delete():
"""
客户删除
:return:
"""
ajax_success_msg = AJAX_SUCCESS_MSG.copy()
ajax_failure_msg = AJAX_FAILURE_MSG.copy()
# 检查删除权限
if not permission_customer_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)
# 检查请求参数
customer_id = request.args.get('customer_id', 0, type=int)
if not customer_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)
customer_info = get_customer_row_by_id(customer_id)
# 检查资源是否存在
if not customer_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 customer_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(**{
'customer_cid': customer_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)
if count_sales_order(**{
'customer_cid': customer_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)
if count_production_sensitive(**{
'customer_cid': customer_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()
customer_data = {
'status_delete': STATUS_DEL_OK,
'delete_time': current_time,
'update_time': current_time,
}
result = edit_customer(customer_id, customer_data)
if result:
# 发送删除信号
signal_data = {
'customer_id': customer_id,
'status_delete': STATUS_DEL_OK,
'current_time': current_time,
}
signal_customer_status_delete.send(app, **signal_data)
ajax_success_msg['msg'] = _('Del Success')
return jsonify(ajax_success_msg)
else:
ajax_failure_msg['msg'] = _('Del Failure')
return jsonify(ajax_failure_msg)
def edit(customer_id):
"""
联系方式
注意 contact_name name 对换
"""
customer_info = get_customer_row_by_id(customer_id)
# 检查资源是否存在
if not customer_info:
abort(404)
# 检查资源是否删除
if customer_info.status_delete == STATUS_DEL_OK:
abort(410)
template_name = 'customer/contact/edit.html'
# 加载编辑表单
form = CustomerContactEditForm(request.form)
form.company_name.data = customer_info.company_name
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('customer contact edit')
# 进入编辑页面
if request.method == 'GET':
# 获取明细
customer_contact_items = get_customer_contact_rows(cid=customer_id)
# 表单赋值
# form.quotation_items = quotation_items
while len(form.customer_contact_items) > 0:
form.customer_contact_items.pop_entry()
for customer_contact_item in customer_contact_items:
customer_contact_item_form = CustomerContactItemEditForm()
customer_contact_item_form.id = customer_contact_item.id
customer_contact_item_form.contact_name = customer_contact_item.name
customer_contact_item_form.salutation = customer_contact_item.salutation
customer_contact_item_form.mobile = customer_contact_item.mobile
customer_contact_item_form.tel = customer_contact_item.tel
customer_contact_item_form.fax = customer_contact_item.fax
customer_contact_item_form.email = customer_contact_item.email
customer_contact_item_form.address = customer_contact_item.address
customer_contact_item_form.note = customer_contact_item.note
customer_contact_item_form.status_default = customer_contact_item.status_default
form.customer_contact_items.append_entry(customer_contact_item_form)
if not customer_contact_items:
form.customer_contact_items.append_entry()
# 渲染页面
return render_template(
template_name,
customer_id=customer_id,
form=form,
**document_info
)
# 处理编辑请求
if request.method == 'POST':
# 增删数据行不需要校验表单
# 表单新增空行
if form.data_line_add.data is not None:
if form.customer_contact_items.max_entries and len(
form.customer_contact_items.entries) >= form.customer_contact_items.max_entries:
flash('最多创建%s条记录' % form.customer_contact_items.max_entries, 'danger')
else:
form.customer_contact_items.append_entry()
return render_template(
template_name,
customer_id=customer_id,
form=form,
**document_info
)
# 表单删除一行
if form.data_line_del.data is not None:
if form.customer_contact_items.min_entries and len(
form.customer_contact_items.entries) <= form.customer_contact_items.min_entries:
flash('最少保留%s条记录' % form.customer_contact_items.min_entries, 'danger')
else:
data_line_index = form.data_line_del.data
form.customer_contact_items.entries.pop(data_line_index)
return render_template(
template_name,
customer_id=customer_id,
form=form,
**document_info
)
# 表单校验失败
if not form.validate_on_submit():
flash(_('Edit Failure'), 'danger')
# flash(form.errors, 'danger')
# flash(form.customer_contact_items.errors, 'danger')
return render_template(
template_name,
customer_id=customer_id,
form=form,
**document_info
)
# 表单校验成功
# 获取明细
customer_contact_items = get_customer_contact_rows(cid=customer_id)
customer_contact_items_ids = [item.id for item in customer_contact_items]
# 数据新增、数据删除、数据修改
customer_contact_items_ids_new = []
result = True
for customer_contact_item in form.customer_contact_items.entries:
# 错误
if customer_contact_item.form.id.data and customer_contact_item.form.id.data not in customer_contact_items_ids:
continue
customer_contact_item_data = {
'cid': customer_id,
'name': customer_contact_item.form.contact_name.data,
'salutation': customer_contact_item.form.salutation.data,
'mobile': customer_contact_item.form.mobile.data,
'tel': customer_contact_item.form.tel.data,
'fax': customer_contact_item.form.fax.data,
'email': customer_contact_item.form.email.data,
'address': customer_contact_item.form.address.data,
'note': customer_contact_item.form.note.data,
'status_default': customer_contact_item.form.status_default.data,
}
if not customer_contact_item.form.id.data:
# 新增
result = result and add_customer_contact(customer_contact_item_data)
else:
# 修改
result = result and edit_customer_contact(customer_contact_item.form.id.data,
customer_contact_item_data)
customer_contact_items_ids_new.append(customer_contact_item.form.id.data)
# 删除
customer_contact_items_ids_del = list(set(customer_contact_items_ids) - set(customer_contact_items_ids_new))
for customer_contact_items_id in customer_contact_items_ids_del:
result = result and delete_customer_contact(customer_contact_items_id)
# 编辑操作成功
if result:
flash(_('Edit Success'), 'success')
return redirect(request.args.get('next') or url_for('customer_contact.lists'))
# 编辑操作失败
else:
flash(_('Edit Failure'), 'danger')
return render_template(
template_name,
customer_id=customer_id,
form=form,
**document_info
)
def add():
"""
新增销售出货
:return:
"""
# return jsonify({})
template_name = 'delivery/add.html'
# 文档信息
document_info = DOCUMENT_INFO.copy()
document_info['TITLE'] = _('delivery add')
# 加载创建表单
form = DeliveryAddForm(request.form)
form.uid.choices = get_user_choices()
form.uid.data = current_user.id
form.warehouse_id.choices = get_warehouse_choices(option_type='create')
# 内嵌表单货架选项
for item_form in form.delivery_items:
item_form.rack_id.choices = get_rack_choices(form.warehouse_id.data,
option_type='create')
# 进入创建页面
if request.method == 'GET':
# 渲染页面
return render_template(template_name, form=form, **document_info)
# 处理创建请求
if request.method == 'POST':
# 修改仓库 - 不做校验
if form.warehouse_changed.data:
form.warehouse_changed.data = ''
return render_template(template_name, form=form, **document_info)
# 表单新增空行
if form.data_line_add.data is not None:
if form.delivery_items.max_entries and len(
form.delivery_items.entries
) >= form.delivery_items.max_entries:
flash('最多创建%s条记录' % form.delivery_items.max_entries, 'danger')
else:
form.delivery_items.append_entry()
# 内嵌表单货架选项
for item_form in form.delivery_items:
item_form.rack_id.choices = get_rack_choices(
form.warehouse_id.data, option_type='create')
return render_template(template_name, form=form, **document_info)
# 表单删除一行
if form.data_line_del.data is not None:
if form.delivery_items.min_entries and len(
form.delivery_items.entries
) <= form.delivery_items.min_entries:
flash('最少保留%s条记录' % form.delivery_items.min_entries, 'danger')
else:
data_line_index = form.data_line_del.data
form.delivery_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()
delivery_data = {
'uid': form.uid.data,
'customer_cid': form.customer_cid.data,
'customer_contact_id': form.customer_contact_id.data,
# 'type_delivery': form.type_delivery.data,
'warehouse_id': form.warehouse_id.data,
'create_time': current_time,
'update_time': current_time,
}
delivery_id = add_delivery(delivery_data)
amount_delivery = 0
for delivery_item in form.delivery_items.entries:
current_time = datetime.utcnow()
delivery_item_data = {
'delivery_id':
delivery_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,
'production_id':
delivery_item.form.production_id.data,
'production_brand':
delivery_item.form.production_brand.data,
'production_model':
delivery_item.form.production_model.data,
'production_sku':
delivery_item.form.production_sku.data,
'warehouse_id':
form.warehouse_id.data,
'rack_id':
delivery_item.form.rack_id.data,
'note':
delivery_item.form.note.data,
'quantity':
delivery_item.form.quantity.data,
'unit_price':
delivery_item.form.unit_price.data,
'create_time':
current_time,
'update_time':
current_time,
}
# 新增
add_delivery_items(delivery_item_data)
amount_delivery += (delivery_item_data['quantity']
or 0) * (delivery_item_data['unit_price'] or 0)
# 更新报价
delivery_data = {
'amount_production': amount_delivery,
'amount_delivery': amount_delivery,
'update_time': current_time,
}
result = edit_delivery(delivery_id, delivery_data)
# todo 事务
# 明细保存
# 总表保存
# 创建操作成功
if result:
flash(_('Add Success'), 'success')
return redirect(
request.args.get('next') or url_for('delivery.lists'))
# 创建操作失败
else:
flash(_('Add Failure'), 'danger')
return render_template(template_name, form=form, **document_info)
