草稿箱分页条件查询

huangh

2024-09-19 49aed349c28d41705101f3611795e77c0fc4639a

草稿箱分页条件查询

 dyh-service/dyh-mediate/src/main/java/cn/huge/module/draft/controller/web/CasedraftInfoWebController.java

@@ -281,6 +281,11 @@
        if (StringUtils.isNotBlank(plaintiffs)){
            terms.put("plaintiffs", plaintiffs);
        }
        // 申请方当事人名称关键词
        String plaintiffsKey = request.getParameter("plaintiffsKey");
        if (StringUtils.isNotBlank(plaintiffsKey)){
            terms.put("plaintiffsKey", plaintiffsKey);
        }
        // 申请方代理人名称
        String pagents = request.getParameter("pagents");
        if (StringUtils.isNotBlank(pagents)){
@@ -290,6 +295,11 @@
        String defendants = request.getParameter("defendants");
        if (StringUtils.isNotBlank(defendants)){
            terms.put("defendants", defendants);
        }
        // 被申请方当事人名称关键词
        String defendantsKey = request.getParameter("defendantsKey");
        if (StringUtils.isNotBlank(defendantsKey)){
            terms.put("defendantsKey", defendantsKey);
        }
        // 被申请方代理人名称
        String dagents = request.getParameter("dagents");
@@ -340,6 +350,16 @@
            terms.put("updateStart", updateStart);
            terms.put("updateEnd", updateEnd);
        }
        // 保存时间排序
        String saveTimeSort = request.getParameter("saveTimeSort");
        if (StringUtils.isNotBlank(saveTimeSort)){
            terms.put("saveTimeSort", saveTimeSort);
        }
        // 事件等级排序
        String caseLevelSort = request.getParameter("caseLevelSort");
        if (StringUtils.isNotBlank(caseLevelSort)){
            terms.put("caseLevelSort", caseLevelSort);
        }
        return terms;
    }

@@ -370,6 +390,23 @@
        try {
            Map<String, Object> terms = getParameter();
            Sort sort = Sort.by(Sort.Direction.DESC, "create_time");
            if(terms.get("saveTimeSort") != null) {
                String saveTimeSort = terms.get("saveTimeSort").toString().toUpperCase();
                if("ASC".equals(saveTimeSort)) {
                    sort = Sort.by(Sort.Direction.ASC, "update_time");
                } else if("DESC".equals(saveTimeSort)) {
                    sort = Sort.by(Sort.Direction.DESC, "update_time");
                }
            }
            if (terms.get("caseLevelSort") != null) {
                String caseLevelSort = terms.get("caseLevelSort").toString().toUpperCase();
                if("ASC".equals(caseLevelSort)) {
                    sort = Sort.by(Sort.Direction.ASC, "case_level");
                } else if("DESC".equals(caseLevelSort)) {
                    sort = Sort.by(Sort.Direction.DESC, "case_level");
                }
            }

            PageRequest pageRequest = PageRequest.of(page-1, size, sort);
            Page<CasedraftInfo> casedraftInfoPage = service.pageQuery(pageRequest, terms);
            return ReturnSucUtils.getRepInfo( "处理成功", casedraftInfoPage);

 dyh-service/dyh-mediate/src/main/java/cn/huge/module/draft/dao/mapper/xml/CasedraftInfoMapper.xml

@@ -338,12 +338,18 @@
                <if test="terms.plaintiffs != null and terms.plaintiffs !=''">
                    and plaintiffs = #{terms.plaintiffs}
                </if>
                <if test="terms.plaintiffsKey != null and terms.plaintiffsKey !=''">
                    and plaintiffs like CONCAT('%', #{terms.plaintiffsKey}, '%')
                </if>
                <if test="terms.pagents != null and terms.pagents !=''">
                    and pagents = #{terms.pagents}
                </if>
                <if test="terms.defendants != null and terms.defendants !=''">
                    and defendants = #{terms.defendants}
                </if>
                <if test="terms.defendantsKey != null and terms.defendantsKey !=''">
                    and defendants like CONCAT('%', #{terms.defendantsKey}, '%')
                </if>
                <if test="terms.dagents != null and terms.dagents !=''">
                    and dagents = #{terms.dagents}
                </if>