-- 查询哪些批次还处于锁定状态
SELECT
   sbd.*
FROM
   store_storage_check ssc
   INNER JOIN store_storage_check_details sscd ON sscd.storage_check_id = ssc.storage_check_id
   INNER JOIN store_batch_details sbd ON sbd.batch_details_id = sscd.batch_details_id
WHERE
   ssc.storage_check_status = 100
   AND sbd.locked = 1
GROUP BY sbd.batch_details_id ;


-- 解锁
UPDATE store_batch_details
    SET locked = 0
WHERE
    batch_details_id IN ( SELECT sscd.batch_details_id FROM store_storage_check ssc INNER JOIN store_storage_check_details sscd ON sscd.storage_check_id = ssc.storage_check_id WHERE ssc.storage_check_status = 100 ) ;

解锁

-- 订货明细 (包括退货信息)
SELECT
   atpr.third_business_no as '伟添单号',
   sco.store_order_code as 'DC单号',
   sco.customer_order_code as 'DW单号',
   w.warehouse_name as '仓库',
   sc.customer_name as '货主',
   sc2.customer_name as '门店',
   scod.goods_name as '商品名称',
   scod.order_quantity as '数量',
   scod.goods_unit_price as '单价',
   sco.pay_time as '支付时间',
   DATE_FORMAT(atpr.create_time, '%Y-%m-%d %H:%i:%s') as '推送时间',
   sro.return_order_no as '退货单号',
   srod.return_quantity as '退货数量',
   srod.already_return_quantity as '已退数量'
FROM
   api_third_platform_record atpr
   INNER JOIN store_customer_order sco on atpr.source_order_no = sco.customer_order_no
   INNER JOIN store_customer_order_details scod on sco.customer_order_id = scod.customer_order_id
   INNER JOIN store_customer sc on sco.goods_owner_id = sc.customer_id
   INNER JOIN store_customer sc2 on sco.customer_id = sc2.customer_id
   INNER JOIN warehouse w on sco.warehouse_id = w.warehouse_id
   LEFT JOIN store_return_order_details srod on scod.customer_order_details_id = srod.customer_order_details_id
   LEFT JOIN store_return_order sro on srod.return_order_id = sro.return_order_id
WHERE
   atpr.app_no = 'APP-00005'
   and atpr.api_call_type = 1
   and w.warehouse_id=354267059846443008
   and atpr.create_time >= '2023-10-01 00:00:00'
   and atpr.create_time < '2023-12-01 00:00:00' ;


-- 退货明细
SELECT
   atpr.third_business_no as '伟添单号',
   sco.store_order_code as 'DC单号',
   sco.customer_order_code as 'DW单号',
   sro.return_order_no as '退货单号',
   w.warehouse_name as '仓库',
   sc.customer_name as '货主',
   sc2.customer_name as '门店',
   srod.goods_name as '商品名称',
   srod.return_quantity as '退货数量',
   srod.already_return_quantity as '已退数量',
   srod.goods_unit_price as '单价'
FROM
   api_third_platform_record atpr
   INNER JOIN store_customer_order sco on atpr.source_order_no = sco.customer_order_no
   INNER JOIN store_customer_order_details scod on sco.customer_order_id = scod.customer_order_id
   INNER JOIN store_customer sc on sco.goods_owner_id = sc.customer_id
   INNER JOIN store_customer sc2 on sco.customer_id = sc2.customer_id
   INNER JOIN warehouse w on sco.warehouse_id = w.warehouse_id
   INNER JOIN store_return_order sro on sco.customer_order_id = sro.customer_order_id
   INNER JOIN store_return_order_details srod on srod.return_order_id = sro.return_order_id and scod.customer_order_details_id = srod.customer_order_details_id
WHERE
   atpr.app_no = 'APP-00005'
   and w.warehouse_id=354267059846443008
   and atpr.create_time >= '2023-10-01 00:00:00'
   and atpr.create_time < '2023-12-01 00:00:00' ;

UPDATE store_customer_order_details scod,
   store_warehouse_owner_goods swog
SET
   scod.warehouse_owner_goods_code = swog.warehouse_owner_goods_code
WHERE
   scod.warehouse_owner_goods_no = swog.warehouse_owner_goods_no
   AND scod.warehouse_owner_goods_code IS NULL
   AND scod.enterprise_id = 425339972154118144;

SELECT sco.customer_order_no,sco.customer_order_code,sco.store_order_code,swog.warehouse_owner_goods_no,aar.business_no,aar.third_no
FROM
   store_customer_order sco
   INNER JOIN store_customer_order_details scod ON sco.customer_order_id = scod.customer_order_id
   INNER JOIN store_warehouse_owner_goods swog ON scod.warehouse_owner_goods_id = swog.warehouse_owner_goods_id
WHERE swog.goods_owner_id != sco.goods_owner_id AND sco.create_time >= '2024-3-17 00:00:00' ;