def ajax_delete(): """ 渠道删除 :return: """ ajax_success_msg = AJAX_SUCCESS_MSG.copy() ajax_failure_msg = AJAX_FAILURE_MSG.copy() # 检查删除权限 if not permission_supplier_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) # 检查请求参数 supplier_id = request.args.get('supplier_id', 0, type=int) if not supplier_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) supplier_info = get_supplier_row_by_id(supplier_id) # 检查资源是否存在 if not supplier_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 supplier_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() supplier_data = { 'status_delete': STATUS_DEL_OK, 'delete_time': current_time, 'update_time': current_time, } result = edit_supplier(supplier_id, supplier_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 lists(): """ 渠道列表 :return: """ template_name = 'supplier/lists.html' # 文档信息 document_info = DOCUMENT_INFO.copy() document_info['TITLE'] = _('supplier lists') # 搜索条件 form = SupplierSearchForm(request.form) form.owner_uid.choices = DEFAULT_SEARCH_CHOICES_INT + [ (user.id, user.name) for user in get_user_rows(**{'status_delete': STATUS_DEL_NO}) ] # app.logger.info('') search_condition = [ Supplier.status_delete == STATUS_DEL_NO, ] if request.method == 'POST': # 表单校验失败 if not form.validate_on_submit(): flash(_('Search Failure'), 'danger') # 单独处理csrf_token if hasattr(form, 'csrf_token') and getattr(form, 'csrf_token').errors: map(lambda x: flash(x, 'danger'), form.csrf_token.errors) else: if form.company_name.data: search_condition.append( Supplier.company_name.like('%%%s%%' % form.company_name.data)) if form.company_type.data != DEFAULT_SEARCH_CHOICES_INT_OPTION: search_condition.append( Supplier.company_type == form.company_type.data) if form.owner_uid.data != DEFAULT_SEARCH_CHOICES_INT_OPTION: search_condition.append( Supplier.owner_uid == form.owner_uid.data) if form.start_create_time.data: search_condition.append( Supplier.create_time >= form.start_create_time.data) if form.end_create_time.data: search_condition.append( Supplier.create_time <= form.end_create_time.data) # 处理导出 if form.op.data == OPERATION_EXPORT: # 检查导出权限 if not permission_supplier_section_export.can(): abort(403) column_names = Supplier.__table__.columns.keys() query_sets = get_supplier_rows(*search_condition) return excel.make_response_from_query_sets( query_sets=query_sets, column_names=column_names, file_type='csv', file_name='%s.csv' % _('supplier lists')) # 批量删除 if form.op.data == OPERATION_DELETE: # 检查删除权限 if not permission_supplier_section_del.can(): abort(403) supplier_ids = request.form.getlist('supplier_id') # 检查删除权限 permitted = True for supplier_id in supplier_ids: # TODO 资源删除权限验证 if False: ext_msg = _('Permission Denied') flash(_('Del Failure, %(ext_msg)s', ext_msg=ext_msg), 'danger') permitted = False break # 检查是否正在使用 # 1、询价 if count_enquiry(**{ 'supplier_cid': supplier_id, 'status_delete': STATUS_DEL_NO }): ext_msg = _('Currently In Use') flash(_('Del Failure, %(ext_msg)s', ext_msg=ext_msg), 'danger') permitted = False break # 2、订单 if count_buyer_order(**{ 'supplier_cid': supplier_id, 'status_delete': STATUS_DEL_NO }): ext_msg = _('Currently In Use') flash(_('Del Failure, %(ext_msg)s', ext_msg=ext_msg), 'danger') permitted = False break if permitted: result_total = True for supplier_id in supplier_ids: current_time = datetime.utcnow() supplier_data = { 'status_delete': STATUS_DEL_OK, 'delete_time': current_time, 'update_time': current_time, } result = edit_supplier(supplier_id, supplier_data) if result: # 发送删除信号 signal_data = { 'supplier_id': supplier_id, 'status_delete': STATUS_DEL_OK, 'current_time': current_time, } signal_supplier_status_delete.send(app, **signal_data) result_total = result_total and result if result_total: flash(_('Del Success'), 'success') else: flash(_('Del Failure'), 'danger') # 翻页数据 pagination = get_supplier_pagination(form.page.data, PER_PAGE_BACKEND, *search_condition) # 渲染模板 return render_template(template_name, form=form, pagination=pagination, **document_info)
def lists(): """ 渠道联系方式列表 :return: """ template_name = 'supplier/contact/lists.html' # 文档信息 document_info = DOCUMENT_INFO.copy() document_info['TITLE'] = _('supplier contact lists') # 搜索条件 form = SupplierContactSearchForm(request.form) # app.logger.info('') search_condition = [ SupplierContact.status_delete == STATUS_DEL_NO, ] if request.method == 'POST': # 表单校验失败 if not form.validate_on_submit(): flash(_('Search Failure'), 'danger') # 单独处理csrf_token if hasattr(form, 'csrf_token') and getattr(form, 'csrf_token').errors: map(lambda x: flash(x, 'danger'), form.csrf_token.errors) else: if form.supplier_cid.data and form.supplier_company_name.data: search_condition.append( SupplierContact.cid == form.supplier_cid.data) if form.supplier_contact_name.data: search_condition.append( SupplierContact.name == form.supplier_contact_name.data) if form.address.data: search_condition.append( SupplierContact.address.like('%%%s%%' % form.address.data)) if form.mobile.data: search_condition.append( SupplierContact.mobile == form.mobile.data) # 处理导出 if form.op.data == OPERATION_EXPORT: # 检查导出权限 if not permission_supplier_section_export.can(): abort(403) column_names = SupplierContact.__table__.columns.keys() query_sets = get_supplier_rows(*search_condition) return excel.make_response_from_query_sets( query_sets=query_sets, column_names=column_names, file_type='csv', file_name='%s.csv' % _('supplier contact lists')) # 批量删除 if form.op.data == OPERATION_DELETE: # 检查删除权限 if not permission_supplier_section_del.can(): abort(403) supplier_contact_ids = request.form.getlist('supplier_contact_id') # 检查删除权限 permitted = True for supplier_contact_id in supplier_contact_ids: # TODO 资源删除权限验证 if False: ext_msg = _('Permission Denied') flash(_('Del Failure, %(ext_msg)s', ext_msg=ext_msg), 'danger') permitted = False break if permitted: result_total = True for supplier_contact_id in supplier_contact_ids: current_time = datetime.utcnow() supplier_contact_data = { 'status_delete': STATUS_DEL_OK, 'delete_time': current_time, 'update_time': current_time, } result = edit_supplier_contact(supplier_contact_id, supplier_contact_data) result_total = result_total and result if result_total: flash(_('Del Success'), 'success') else: flash(_('Del Failure'), 'danger') # 翻页数据 pagination = get_supplier_contact_pagination(form.page.data, PER_PAGE_BACKEND, *search_condition) # 渲染模板 return render_template(template_name, form=form, pagination=pagination, **document_info)