skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/SkxsQkTjMapper.xml
@@ -26,8 +26,8 @@ left join SJZT_MD."att_ad_base" c ON b."p_ad_code" = c."guid" left join SJZT_MD."att_ad_base" d ON c."p_ad_code" = d."guid" where 1=1 <if test="skxsQkTj.statisticTime!=null"> and DATE_FORMAT(sqt."statistic_time",'%Y-%m-%d') = #{skxsQkTj.statisticTime} <if test="skxsQkTj.queryTime!=null and skxsQkTj.queryTime!=''"> and DATE_FORMAT(sqt."statistic_time",'%Y-%m-%d') = #{skxsQkTj.queryTime} </if> <if test="skxsQkTj.resName!=null and skxsQkTj.resName!=''"> and sqt."res_name" like concat('%',#{skxsQkTj.resName},'%') @@ -124,8 +124,8 @@ left join SJZT_MD."att_ad_base" c ON b."p_ad_code" = c."guid" left join SJZT_MD."att_ad_base" d ON c."p_ad_code" = d."guid" where 1=1 <if test="skxsQkTj.statisticTime!=null"> and DATE_FORMAT(sqt."statistic_time",'%Y-%m-%d') = #{skxsQkTj.statisticTime} <if test="skxsQkTj.queryTime!=null and skxsQkTj.queryTime!=''"> and DATE_FORMAT(sqt."statistic_time",'%Y-%m-%d') = #{skxsQkTj.queryTime} </if> <if test="skxsQkTj.resName!=null and skxsQkTj.resName!=''"> and sqt."res_name" like concat('%',#{skxsQkTj.resName},'%') skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/XsfsQktjMapper.xml
@@ -8,8 +8,8 @@ xq.* from SJZT_ODS."xsfs_qktj" xq where 1=1 <if test="xsfsQktj.statisticTime!=null"> and date_format(xq."statistic_time","%Y-%m-%d") = #{xsfsQktj.statisticTime} <if test="xsfsQktj.queryTime!=null and xsfsQktj.queryTime!=''"> and date_format(xq."statistic_time",'%Y-%m-%d') = #{xsfsQktj.queryTime} </if> <if test="xsfsQktj.adCode!=null and xsfsQktj.adCode!=''"> and xq."ad_code" = #{xsfsQktj.adCode} @@ -22,8 +22,8 @@ xq.* from SJZT_ODS."xsfs_qktj" xq where 1=1 <if test="xsfsQktj.statisticTime!=null"> and date_format(xq."statistic_time",'%Y-%m-%d') = #{xsfsQktj.statisticTime} <if test="xsfsQktj.queryTime!=null and xsfsQktj.queryTime!=''"> and date_format(xq."statistic_time",'%Y-%m-%d') = #{xsfsQktj.queryTime} </if> <if test="xsfsQktj.adCode!=null and xsfsQktj.adCode!=''"> and xq."ad_code" = #{xsfsQktj.adCode} skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/vo/XsfsQktjVO.java
@@ -10,4 +10,9 @@ * 水库规模 */ private Integer isExport; /** * 查询时间 */ private String queryTime; }
