#!/usr/bin/env python3 # -*- coding: utf-8 -*- """Customer update API""" import json, time result = {'widgettype': 'Message', 'options': {'title': 'Error', 'message': 'Invalid request', 'type': 'error'}} try: record_id = params_kw.get('id', '').strip() if not record_id: result['options'] = {'title': 'Error', 'message': '记录ID不能为空', 'type': 'error'} else: dbname = get_module_dbname('customer_management') now = time.strftime('%Y-%m-%d %H:%M:%S') fields = ['customer_name', 'customer_type', 'phone', 'email', 'tax_id', 'industry', 'customer_level', 'address', 'owner_id', 'region', 'status'] set_parts = [] params = {'id': record_id} for f in fields: val = params_kw.get(f, None) if val is not None: set_parts.append(f + " = ${" + f + "}$") params[f] = val set_parts.append("updated_at = ${updated_at}$") params['updated_at'] = now if len(set_parts) <= 1: result['options'] = {'title': 'Error', 'message': '没有可更新的字段', 'type': 'error'} else: sql = "UPDATE customers SET " + ", ".join(set_parts) + " WHERE id = ${id}$" async with DBPools().sqlorContext(dbname) as sor: await sor.sqlExe(sql, params) result = {'widgettype': 'Message', 'options': {'title': 'Success', 'message': '更新成功', 'type': 'success'}} except Exception as e: result['options'] = {'title': 'Error', 'message': '更新失败: ' + str(e), 'type': 'error'} return json.dumps(result, ensure_ascii=False)