125 lines
3.9 KiB
Python
125 lines
3.9 KiB
Python
#!/usr/bin/env python3
|
||
# -*- coding: utf-8 -*-
|
||
"""初始化对账单示例数据"""
|
||
|
||
import sqlite3
|
||
import os
|
||
from datetime import datetime, timezone, timedelta
|
||
|
||
# 数据库路径
|
||
DB_PATH = os.path.join(os.path.dirname(__file__), 'server', 'data.db')
|
||
|
||
def get_beijing_time():
|
||
"""获取北京时间（UTC+8）的ISO格式字符串"""
|
||
beijing_tz = timezone(timedelta(hours=8))
|
||
return datetime.now(beijing_tz).isoformat()
|
||
|
||
def init_reconciliations():
|
||
"""初始化对账单示例数据"""
|
||
conn = sqlite3.connect(DB_PATH)
|
||
c = conn.cursor()
|
||
|
||
# 示例数据（根据图片中的数据）
|
||
sample_data = [
|
||
{
|
||
'order_date': '2025/10/31',
|
||
'contract_no': 'CGDD002876',
|
||
'material_name': '扩产-9988 红黑线',
|
||
'spec_model': 'PCXK0P0NSNT_1_2.54*1C14TE',
|
||
'transport_no': '快递上门',
|
||
'quantity': 45,
|
||
'unit': 'pcs',
|
||
'unit_price': 239.2,
|
||
'total_amount': 10764,
|
||
'delivery_date': '2025/11/3',
|
||
'shipment_date': '2025/11/3'
|
||
},
|
||
{
|
||
'order_date': '2025/9/20',
|
||
'contract_no': 'CGDD004562',
|
||
'material_name': '扩产-9988 红黑线',
|
||
'spec_model': 'M1H0EM0N511 PCXK0P0NSNT_1_2.54*1C14TE',
|
||
'transport_no': '快递上门',
|
||
'quantity': 355,
|
||
'unit': 'pcs',
|
||
'unit_price': 1.1,
|
||
'total_amount': 390.5,
|
||
'delivery_date': '2025/11/3',
|
||
'shipment_date': '2025/11/3'
|
||
},
|
||
{
|
||
'order_date': '2025/9/20',
|
||
'contract_no': 'CGDD004562',
|
||
'material_name': '扩产-9988 红黑线',
|
||
'spec_model': 'ETAP05-01',
|
||
'transport_no': '快递上门',
|
||
'quantity': 2,
|
||
'unit': 'pcs',
|
||
'unit_price': 245.46,
|
||
'total_amount': 490.92,
|
||
'delivery_date': '2025/11/3',
|
||
'shipment_date': '2025/11/3'
|
||
},
|
||
{
|
||
'order_date': '2025/9/20',
|
||
'contract_no': 'CGDD004562',
|
||
'material_name': 'M1H0EM0N511 红黑线',
|
||
'spec_model': 'PCXK0P0NSNT_1_2.54*1C14TE',
|
||
'transport_no': '快递上门',
|
||
'quantity': 6,
|
||
'unit': 'pcs',
|
||
'unit_price': 1.1,
|
||
'total_amount': 6.6,
|
||
'delivery_date': '2025/11/3',
|
||
'shipment_date': '2025/11/3'
|
||
},
|
||
{
|
||
'order_date': '2025/10/11',
|
||
'contract_no': 'CGDD002717',
|
||
'material_name': '扩产-9988 红黑线',
|
||
'spec_model': 'ETAP05-01',
|
||
'transport_no': '快递上门',
|
||
'quantity': 500,
|
||
'unit': 'pcs',
|
||
'unit_price': 228.45,
|
||
'total_amount': 114225,
|
||
'delivery_date': '2025/11/3',
|
||
'shipment_date': '2025/11/3'
|
||
}
|
||
]
|
||
|
||
now = get_beijing_time()
|
||
|
||
for data in sample_data:
|
||
c.execute('''
|
||
INSERT INTO reconciliations(
|
||
order_date, contract_no, material_name, spec_model, transport_no,
|
||
quantity, unit, unit_price, total_amount, delivery_date, shipment_date,
|
||
created_by, created_at, updated_at
|
||
) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?)
|
||
''', (
|
||
data['order_date'],
|
||
data['contract_no'],
|
||
data['material_name'],
|
||
data['spec_model'],
|
||
data['transport_no'],
|
||
data['quantity'],
|
||
data['unit'],
|
||
data['unit_price'],
|
||
data['total_amount'],
|
||
data['delivery_date'],
|
||
data['shipment_date'],
|
||
'admin',
|
||
now,
|
||
now
|
||
))
|
||
|
||
conn.commit()
|
||
count = len(sample_data)
|
||
conn.close()
|
||
|
||
print(f'✅ 成功初始化 {count} 条对账单示例数据')
|
||
|
||
if __name__ == '__main__':
|
||
init_reconciliations()
|