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)