@Service
public class SupervisionEnforceStrengthServiceImpl implements SupervisionEnforceStrengthService {

@Override
    public ZFJDGZVO zfjdgz(supervisionEnforceStrengthDTO1 dto) {
        ZFJDGZVO zfjdgzvo = new ZFJDGZVO();
        Integer allNum = zfjdgzMapper.selectAllNum(dto);
        Integer dailyNum = zfjdgzMapper.selectDailyNum(dto);
        Integer specialNum = zfjdgzMapper.selectSpecialNum(dto);
        Integer finishNum = zfjdgzMapper.selectIsFinishNum(dto);
        Integer cloudNum = zfjdgzMapper.selectCloudNum(dto);
        zfjdgzvo.setAllNum(allNum);
        zfjdgzvo.setDailyNum(dailyNum);
        zfjdgzvo.setSpecialNum(specialNum);
        //重点问题检出率-日常检查
        Integer q11 = zfjdgzMapper.q11(dto);
        Integer q12 = zfjdgzMapper.q12(dto);
        Integer q13 = zfjdgzMapper.q13(dto);
        //重点问题检出率-随机监听检查
        Integer q31 = zfjdgzMapper.q31(dto);
        Integer q32 = zfjdgzMapper.q32(dto);
        Integer q33 = zfjdgzMapper.q33(dto);
        //重点问题检出率-异地监督检查
        Integer q41 = zfjdgzMapper.q41(dto);
        Integer q42 = zfjdgzMapper.q42(dto);
        Integer q43 = zfjdgzMapper.q43(dto);
        
        //省略业务代码 （给zfjdgzvo赋值）

        return zfjdgzvo;
    }
}


//上面的q11 ,q12方法的sql是这样的。其他的方法类似
  <select id="q11" resultType="java.lang.Integer">
        SELECT IFNULL(SUM(DAILY_ALL_NUM),0)
        FROM "SALN_MID_DATA"."TS_ZFJDGZ"
        <where>
            <if test="dto.city != null and dto.city != ''">
                AND CITY_CODE = #{dto.city}
            </if>
            <if test="dto.district != null and dto.district != ''">
                AND DISTRICT_CODE = #{dto.district}
            </if>
        </where>
    </select>
    <select id="q12" resultType="java.lang.Integer">
        SELECT IFNULL(SUM(DAILY_KEY_QUESTION_NUM),0)
        FROM "SALN_MID_DATA"."TS_ZFJDGZ"
        <where>
            <if test="dto.city != null and dto.city != ''">
                AND CITY_CODE = #{dto.city}
            </if>
            <if test="dto.district != null and dto.district != ''">
                AND DISTRICT_CODE = #{dto.district}
            </if>
        </where>
    </select>