From db5eb7cf96d20071bcd7df6194577165aa217bee Mon Sep 17 00:00:00 2001
From: yaowanxin <3588231647@qq.com>
Date: 星期四, 15 一月 2026 16:59:57 +0800
Subject: [PATCH] 1.修改来票台账详情接口，实时返回未来票数，未来票金额 2.未进行来票登记操作,同步未来票数，金额 3.字段数据类型修改 4.来票台账搜索当天记录sql语句
---
doc/create_table_process_route_item.sql | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diff --git a/doc/create_table_process_route_item.sql b/doc/create_table_process_route_item.sql
index ea0a8a7..a1efff9 100644
--- a/doc/create_table_process_route_item.sql
+++ b/doc/create_table_process_route_item.sql
@@ -50,6 +50,10 @@
create_time datetime null comment '褰曞叆鏃堕棿',
update_time datetime null comment '鏇存柊鏃堕棿',
work_order_no varchar(255) not null default '' comment '宸ュ崟缂栧彿',
+ plan_start_time datetime null comment '璁″垝寮�濮嬫椂闂�',
+ plan_end_time datetime null comment '璁″垝缁撴潫鏃堕棿',
+ actual_start_time datetime null comment '瀹為檯寮�濮嬫椂闂�',
+ actual_end_time datetime null comment '瀹為檯缁撴潫鏃堕棿',
status int not null default 0 comment '鐘舵�� 1 寰呯‘璁� 2 寰呯敓浜� 3鐢熶骇涓� 4宸茬敓浜� ',
tenant_id bigint not null comment '绉熸埛id'
);
--
Gitblit v1.9.3