深圳智汇创想科技有限公司

测试fba货件合计优化

select
        sum(tafs.quantity_shipped) as quantityShipped,
        sum(tafs.quantity_deliveryed) as quantityDeliveryed,
        sum(tafs.quantity_received) as quantityReceived,
        sum(case when tafs.quantity_deliveryed > 0 then tafs.diff_shipped_deliveryed else 0 end) as diffShippedDeliveryed,
        sum(case when tafs.quantity_received > 0 then tafs.diff_received_deliveryed else 0 end) as diffReceivedDeliveryed,
        sum(case when tafs.quantity_received > 0 then tafs.diff_shipped_received else 0 end) as diffShippedReceived,
        sum(tafs.times_deliverying_receiving) as timesDeliveryingReceiving,
        sum(tafs.times_receiving_grounding) as timesReceivingGrounding
from t_amz_fba_shipment tafs
where tafs.customer_id = 1
and tafs.shipment_id = 'FBA1745DP01B';

测试预计到货时间

-- 预计到货时间 等于创建时间+预计到达时长
-- 找创建时间
SELECT create_time,source_id FROM test_zhcxkj_center_warehouse.t_amz_fba_shipment where seller_id='AM2O6YLW0PDVC'and source_id<>0 and deliverying_time>='2023-01-01 00:00:00' and shipment_id='FBA15GS27621' limit 200;
-- SELECT * FROM test_zhcxkj_center_warehouse.t_amz_fba_shipment_item where seller_id='AM2O6YLW0PDVC' and source_id<>0 and shipment_id='FBA15GS27621';
-- sourceID 找国家UK

SELECT  order_source_country FROM test_zhcxkj_center_data.rb_order_source where id=8072;


-- 国家找预计到达时长    13

SELECTexpected_arrival_days FROM rb_transport_country_expected_arrival_days where country='GB' and customer_id=1  and transport_id=2978;