费用流水逻辑

• 费用流水增加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';
  
  

 

转载于:https://www.cnblogs.com/Dozeoff/p/9035426.html