排序

liuhaonan

2022-05-27 f04802851ffecf0e85b30f4ea7b73da5fbdbf188

 ximon-admin/src/main/java/com/sandu/ximon/admin/service/IpVolumeService.java

@@ -14,6 +14,7 @@
import com.sandu.ximon.admin.vo.TerminalVO;
import com.sandu.ximon.dao.bo.BroadcastTerminalV2EntityBo;
import com.sandu.ximon.dao.domain.BroadcastTerminalV2Entity;
import com.sandu.ximon.dao.enums.OrderByEnums;
import com.sandu.ximon.dao.enums.PoleBindingEnums;
import com.sandu.ximon.dao.mapper.IPBroadcastMapper;
import org.springframework.beans.factory.annotation.Autowired;
@@ -70,17 +71,20 @@
        if (broadcastTerminalV2Param == null) {
            broadcastTerminalV2Param = new BroadcastTerminalV2Param();
        }

        //排序字段
        String orderByResult = "id";
        String orderByResult = OrderByEnums.IP_VOLUME_ID.getCode();
        //正序、倒叙
        String orderBySeq = "ASC";
        String orderBySeq = OrderByEnums.ASC.getCode();
        if (order != null) {
            switch (order) {
                case 1:
                    orderByResult = "create_time";
                    orderByResult = OrderByEnums.IP_VOLUME_ID.getCode();
                    break;
                case 2:
                    orderByResult = "create_time";
                    orderByResult = OrderByEnums.IP_VOLUME_NAME.getCode();
                case 3:
                    orderByResult = OrderByEnums.IP_VOLUME_POLE_NAME.getCode();
                default:
            }
        }
@@ -96,11 +100,12 @@
                    break;
            }
        }

        //排序方式
        String orderBy = orderByResult + " " + orderBySeq;

        //在线状态全部的话需要分页
        if (baseConditionVO != null && 2 == broadcastTerminalV2Param.getWorkState()) {
            PageHelper.startPage(baseConditionVO.getPageNo(), baseConditionVO.getPageSize());
            PageHelper.startPage(baseConditionVO.getPageNo(), baseConditionVO.getPageSize(), orderBy);
        }

        List<BroadcastTerminalV2EntityBo> broadcastTerminalV2EntityBos;