| | |
| | | |
| | | <!--已种植农产品列表--> |
| | | <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" |
| | |
| | | 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 |