智慧农业后台管理
guoshilong
2022-08-22 32e81fa68cf76e2331eb88a2299ee0ecd8faa7b3
修改为可以卖出全部产品
2 files modified
4 ■■■■ changed files
src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml 2 ●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.xml 2 ●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml
@@ -424,7 +424,7 @@
        SELECT
        CASE
            WHEN
                weight > #{sale} THEN
                weight >= #{sale} THEN
                TRUE ELSE FALSE
                END result
        FROM
src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.xml
@@ -56,7 +56,7 @@
        SELECT
            CASE
                WHEN
                    product_inventory_num > #{saleNum} THEN
                    product_inventory_num >= #{saleNum} THEN
                    TRUE ELSE FALSE
                END result
        FROM