普查统计水库柱状图数据接口支持季节查询

xieb

2024-09-26 024afbfeb399c4d800b4fa088149d92da4d8bbbf

普查统计水库柱状图数据接口支持季节查询

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/TbResGeneralInvestigationMapper.xml

@@ -139,6 +139,9 @@
                                      <if test="params.tbYear != null and params.tbYear !=''">
                                          AND TRGI."tb_year" = #{params.tbYear}
                                      </if>
                                      <if test="params.tbQuarter != null and params.tbQuarter !=''">
                                          AND TRGI."tb_quarter" = #{params.tbQuarter}
                                      </if>
                                    group by TRGI."tb_state_id",TRGI."res_guid"
                                ) tmp on tmp."tb_state_id" = trgis."guid"
                                LEFT JOIN SJZT_MD."att_res_base" arb on arb."code" = trgis."res_guid"