| | |
|---|
| | | |
|---|
| | | <!--小程序农产品库存详情数据--> |
|---|
| | | <select id="statisticsProductx" resultType="org.springblade.modules.farmplant.vo.FarmProductStockVO"> |
|---|
| | | select sfps.strain_id strainId,sfps.weight,ss.url,ss.strain_name strainName from |
|---|
| | | select sfps.strain_id strainId,SUM(sfps.weight) AS weight,ss.url,ss.strain_name strainName from |
|---|
| | | sys_farm_product_stock sfps |
|---|
| | | left join sys_strain ss on ss.id = sfps.strain_id |
|---|
| | | LEFT JOIN sys_land land ON land.id = sfps.land_id |
|---|
| | |
|---|
| | | <if test="farmProductStock.farmId !=null and farmProductStock.farmId !='' "> |
|---|
| | | and land.farm_id = #{farmProductStock.farmId} |
|---|
| | | </if> |
|---|
| | | GROUP BY sfps.strain_id |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <!--销售对比库存是否充足--> |
|---|
