console.log('load stock');/*
分组ID:1,绑定的仓库ID：1,2,3,6,7<br />分组ID:2,绑定的仓库ID：8<br />查询的SKU：BR20Y0183<br />原有总库存：18368<br />分组1库存：17896<br />分组2库存：0<br />分组3库存：0<br />分组4库存：0<br />Array
(
    [0] => Array
        (
            [sku] => BR20Y0183
            [sid] => 2
            [price] => 4.80
            [stockpos] => A165-3-4
            [stock] => 17438
            [tem_stock] => 521
            [sku_sales] => 134202
            [status] => 上架
        )

    [1] => Array
        (
            [sku] => BR20Y0183
            [sid] => 4
            [price] => 
            [stockpos] => 
            [stock] => -49
            [tem_stock] => 0
            [sku_sales] => 211
            [status] => 上架
        )

    [2] => Array
        (
            [sku] => BR20Y0183
            [sid] => 6
            [price] => 
            [stockpos] => 
            [stock] => 1500
            [tem_stock] => 0
            [sku_sales] => 0
            [status] => 上架
        )

    [3] => Array
        (
            [sku] => BR20Y0183
            [sid] => 10
            [price] => 
            [stockpos] => 
            [stock] => 0
            [tem_stock] => 0
            [sku_sales] => 0
            [status] => 上架
        )

)
更新BR20Y0183库存：16917<br />更新BR20Y0183库存：-49<br />更新BR20Y0183库存：1500<br />更新BR20Y0183库存：0<br />BR20Y0183，总库存：18368<br />Array
(
    [BR20Y0183] => Array
        (
            [0] => 2
            [1] => 4
            [2] => 6
            [3] => 10
        )

)
写入1<br />写入3<br />写入7<br />写入8<br />Array
(
    [0] => Array
        (
            [sku] => BR20Y0183
            [sid] => 2
            [price] => 4.80
            [stockpos] => A165-3-4
            [stock] => 16917
            [tem_stock] => 521
            [sku_sales] => 134202
            [status] => 上架
        )

    [1] => Array
        (
            [sku] => BR20Y0183
            [sid] => 4
            [price] => 
            [stockpos] => 
            [stock] => -49
            [tem_stock] => 0
            [sku_sales] => 211
            [status] => 上架
        )

    [2] => Array
        (
            [sku] => BR20Y0183
            [sid] => 6
            [price] => 
            [stockpos] => 
            [stock] => 1500
            [tem_stock] => 0
            [sku_sales] => 0
            [status] => 上架
        )

    [3] => Array
        (
            [sku] => BR20Y0183
            [sid] => 10
            [price] => 
            [stockpos] => 
            [stock] => 0
            [tem_stock] => 0
            [sku_sales] => 0
            [status] => 上架
        )

    [4] => Array
        (
            [sku] => BR20Y0183
            [sid] => 1
            [price] => 0
            [stockpos] => 
            [stock] => 0
            [sku_sales] => 0
        )

    [5] => Array
        (
            [sku] => BR20Y0183
            [sid] => 3
            [price] => 0
            [stockpos] => 
            [stock] => 0
            [sku_sales] => 0
        )

    [6] => Array
        (
            [sku] => BR20Y0183
            [sid] => 7
            [price] => 0
            [stockpos] => 
            [stock] => 0
            [sku_sales] => 0
        )

    [7] => Array
        (
            [sku] => BR20Y0183
            [sid] => 8
            [price] => 0
            [stockpos] => 
            [stock] => 0
            [sku_sales] => 0
        )

)
{"sku":"BR20Y0183","sid":"2","price":"4.80","stockpos":"A165-3-4","stock":16917,"tem_stock":"521","sku_sales":134202,"status":"\u4e0a\u67b6"}<br />{"sku":"BR20Y0183","sid":"4","price":null,"stockpos":null,"stock":"-49","tem_stock":"0","sku_sales":211,"status":"\u4e0a\u67b6"}<br />{"sku":"BR20Y0183","sid":"6","price":null,"stockpos":null,"stock":"1500","tem_stock":"0","sku_sales":0,"status":"\u4e0a\u67b6"}<br />{"sku":"BR20Y0183","sid":"10","price":null,"stockpos":null,"stock":"0","tem_stock":"0","sku_sales":0,"status":"\u4e0a\u67b6"}<br />{"sku":"BR20Y0183","sid":1,"price":0,"stockpos":"","stock":0,"sku_sales":0}<br />{"sku":"BR20Y0183","sid":3,"price":0,"stockpos":"","stock":0,"sku_sales":0}<br />{"sku":"BR20Y0183","sid":7,"price":0,"stockpos":"","stock":0,"sku_sales":0}<br />{"sku":"BR20Y0183","sid":8,"price":0,"stockpos":"","stock":0,"sku_sales":0}<br />更新分组：1,SKU:BR20Y0183库存：16396<br />更新分组：1,SKU:BR20Y0183库存：1500<br />更新分组：1,SKU:BR20Y0183库存：0<br />更新分组：1,SKU:BR20Y0183库存：0<br />更新分组：1,SKU:BR20Y0183库存：0<br />更新分组：2,SKU:BR20Y0183库存：0<br />分组ID：1,SKU：{"BR20Y0183":17896}<br />分组ID：2,SKU：{"BR20Y0183":0}<br />update  `gsp_goods`  set goods_storage = case  when goods_serial = 'BR20Y0183' then 18368 END WHERE goods_serial IN ('BR20Y0183') <br />update  `gsp_goods`  set goods_storage_1 = case  when goods_serial = 'BR20Y0183' then 17896 END WHERE goods_serial IN ('BR20Y0183');<br />update  `gsp_goods`  set goods_storage_2 = case  when goods_serial = 'BR20Y0183' then 0 END WHERE goods_serial IN ('BR20Y0183');<br />success at 2024-05-19 04:14:34
*/