智慧农业后台管理
guoshilong
2022-08-20 2d86e3309fb4b47d298121ddbd1357d886a947f2
多传一个url
2 files modified
4 ■■■■ changed files
src/main/java/org/springblade/modules/farmplant/mapper/FarmPlantMapper.xml 2 ●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/stock/mapper/StockMapper.xml 2 ●●● patch | view | raw | blame | history
src/main/java/org/springblade/modules/farmplant/mapper/FarmPlantMapper.xml
@@ -188,7 +188,7 @@
    <!--已种植农产品列表-->
    <select id="strainTree" resultType="org.springblade.modules.farmplant.entity.Strain">
        select ss.id, ss.strain_name strainName
        select ss.id, ss.strain_name strainName,ss.url
        from sys_farm_plant sfp
                 left join sys_strain ss on ss.id = sfp.strain_id
        where sfp.status = "1"
src/main/java/org/springblade/modules/stock/mapper/StockMapper.xml
@@ -158,7 +158,7 @@
                 sys_stockrecord st
            LEFT JOIN (SELECT id, agricultural_name, factory_name,type FROM sys_stockfactory) stf
            ON st.stock_id1 = stf.id
        <if test="stock.stockType !=null and stock.stockType != '' ">
        <if test="stock.stockType !=null and stock.stockType !=''">
            WHERE stf.type =#{stock.stockType}
        </if>
        GROUP BY