fix: 查询库存数量为null赋予默认值

gongchunyi

21 小时以前 807c34f4859f36f6eff665efcb834adb57ea7174

fix: 查询库存数量为null赋予默认值

 src/main/resources/mapper/stock/StockInventoryMapper.xml

@@ -188,11 +188,12 @@
        select ifnull(sum(qualitity), 0)
        from stock_inventory
    </select>

    <select id="selectTotalByDate" resultType="java.math.BigDecimal">
        select sum(qualitity)
        select IFNULL(sum(qualitity), 0)
        from stock_inventory
        where
           create_time &gt;= #{now} and create_time &lt; DATE_ADD(#{now}, INTERVAL 1 DAY)
        where create_time &gt;= #{now}
          and create_time &lt; DATE_ADD(#{now}, INTERVAL 1 DAY)
    </select>

    <select id="selectStorageProductCountByDate" resultType="int">