- 费用流水增加actualWeight字段,获取actualWeight逻辑如下:
- RDC换面单产生真实扣费,重量取值t_scan_package的Chargeable Weight(收入计费重),已经开始取值,
- 完了将t_scan_package的信息同步到OC的表t_waybill_sorting,取值字段:chargeble weight,数据库保留位数数4位,比如:123.0000
- 费用流水要求保留2位小数:123.00
- select
a.seller_id
from (
select t.seller_id
from t_fin_trade_detail t
where 1=1
and date_format(t.trade_time, '%Y%m%d') = date_format(date_sub(now(),interval 1 day), '%Y%m%d')
and t.trade_type = 2
and t.is_active = 1
group by t.seller_id
) a - select * from t_fin_trade_detail where trade_time BETWEEN '2018-05-13 00:59:59' and '2018-05-13 23:59:59';