连接地址修改

zengh

2022-07-15 fabe7ee6a486b08d07b681f0e081c87c828878f2

连接地址修改

 src/main/java/org/springblade/modules/farmplant/controller/FarmProductStockController.java

@@ -180,14 +180,20 @@
        Map<String, String> sum = farmProductStockService.statisticsStock(year, farmId);
        //统计当前库存加工产品
        Map<String, String> jgsum = null;
        if (sum != null){
        map.put("sum",sum.get("sum"));
            map.put("ncpNcl", sum.get("cssum"));
        }else{
            map.put("sum",0);
            map.put("ncpNcl",0);
        }
        map.put("jgsum",0);

        //农产品年产量统计
//        List<Map<String, Double>> Nsum = farmProductStockService.statisticsYield(year, deptId);
//        double ncpNcl = Nsum.get(1).get("sum") + Nsum.get(0).get("sum");

        map.put("ncpNcl", sum.get("cssum"));


        //加工产品年产量统计
        map.put("jgNcl",0);

 src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.xml

@@ -252,6 +252,7 @@
        GROUP BY
        gptime
        ) AS righttable ON DATE_FORMAT( lefttable.date, '%Y-%c-%d' ) = righttable.gptime
        ORDER BY time
    </select>
    <!--按日统计产量-->
    <select id="statisticsStockDay" resultType="java.util.HashMap">

 src/main/java/org/springblade/modules/traceability/mapper/SweepRecordMapper.xml

@@ -170,6 +170,7 @@
        and sl.farm_id = #{sweepRecord.farmId}
        GROUP BY gptime
        ) AS righttable ON DATE_FORMAT(lefttable.date, '%Y-%c-%d') = righttable.gptime
        ORDER BY time
    </select>

    <!--获取扫描次数统计数据（年统计）-->