yumoqing
e3c19bc359
- Updated financial_core.py - Updated models/receivables.json - Added mysql.ddl.sql - Added API files: debug_receivables, receivables CRUD, test_env - Added UI files: financial_vouchers, index, payments, receipts, receivable_edit, receivables
26 lines
1.1 KiB
Python
26 lines
1.1 KiB
Python
#!/usr/bin/env python3
|
|
# -*- coding: utf-8 -*-
|
|
"""Receivable delete API"""
|
|
import json
|
|
|
|
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('financial_management')
|
|
async with DBPools().sqlorContext(dbname) as sor:
|
|
existing = await sor.sqlExe("SELECT id FROM receivables WHERE id = ${id}$", {'id': record_id})
|
|
if not existing:
|
|
result['options'] = {'title': 'Error', 'message': '记录不存在', 'type': 'error'}
|
|
else:
|
|
await sor.sqlExe("DELETE FROM receivables WHERE id = ${id}$", {'id': record_id})
|
|
result = {'widgettype': 'Message', 'options': {'title': 'Success', 'message': '删除成功', 'type': 'success'}}
|
|
|
|
except Exception as e:
|
|
result['options'] = {'title': 'Error', 'message': f'删除失败: {str(e)}', 'type': 'error'}
|
|
|
|
return json.dumps(result, ensure_ascii=False)
|