src/main/java/cc/mrbird/febs/ai/service/impl/AiAgentServiceImpl.java

@@ -59,7 +59,8 @@
        }
        query.eq(AiAgentCategory::getCompanyId, dto.getCompanyId());
        query.eq(AiAgentCategory::getState, 1);
        query.orderByAsc(AiAgentCategory::getSort);
//        query.orderByAsc(AiAgentCategory::getSort);
        query.orderByDesc(AiAgentCategory::getSort);
        List<AiAgentCategory> listByQuery = aiAgentCategoryMapper.selectList(query);
        if (CollUtil.isNotEmpty(listByQuery)){
            for (AiAgentCategory entity : listByQuery){

 src/main/java/cc/mrbird/febs/ai/service/impl/AiProductCategoryServiceImpl.java

@@ -59,7 +59,8 @@
        query.eq(AiProductCategory::getLevel, ProductCategoryLevelEnum.LEVEL_TWO.getLevel());
        query.eq(AiProductCategory::getState, 1);
        query.eq(AiProductCategory::getHotState, 1);
        query.orderByAsc(AiProductCategory::getSort);
//        query.orderByAsc(AiProductCategory::getSort);
        query.orderByDesc(AiProductCategory::getSort);
        List<AiProductCategory> listByQuery = this.getListByQuery(query);
        if (CollUtil.isNotEmpty(listByQuery)){
            for (AiProductCategory aiProductCategory : listByQuery){
@@ -87,7 +88,8 @@
        query.eq(AiProductCategory::getLevel, ProductCategoryLevelEnum.LEVEL_TWO.getLevel());
        query.eq(AiProductCategory::getState, 1);
        query.eq(AiProductCategory::getHotState, 1);
        query.orderByAsc(AiProductCategory::getSort);
//        query.orderByAsc(AiProductCategory::getSort);
        query.orderByDesc(AiProductCategory::getSort);
        List<AiProductCategory> listByQuery = this.getListByQuery(query);
        if (CollUtil.isNotEmpty(listByQuery)){
            for (AiProductCategory aiProductCategory : listByQuery){
@@ -115,7 +117,8 @@
        query.eq(AiProductCategory::getLevel, ProductCategoryLevelEnum.LEVEL_ONE.getLevel());
        query.eq(AiProductCategory::getState, 1);
        query.eq(AiProductCategory::getHotState, 1);
        query.orderByAsc(AiProductCategory::getSort);
//        query.orderByAsc(AiProductCategory::getSort);
        query.orderByDesc(AiProductCategory::getSort);
        List<AiProductCategory> listByQuery = this.getListByQuery(query);
        if (CollUtil.isNotEmpty(listByQuery)){
            for (AiProductCategory aiProductCategory : listByQuery){
@@ -138,7 +141,8 @@
                Wrappers.lambdaQuery(AiProductCategory.class)
                        .eq(AiProductCategory::getParentId, dto.getParentId())
                        .eq(AiProductCategory::getState, 1)
                .orderByAsc(AiProductCategory::getSort)
//                .orderByAsc(AiProductCategory::getSort)
                .orderByDesc(AiProductCategory::getSort)
        );
        if (CollUtil.isNotEmpty(aiProductCategories)){
            for (AiProductCategory aiProductCategory : aiProductCategories) {
@@ -176,7 +180,8 @@
        query.eq(AiProductCategory::getCompanyId, dto.getCompanyId());
        query.eq(AiProductCategory::getState, 1);
        query.eq(AiProductCategory::getLevel, ProductCategoryLevelEnum.LEVEL_ONE.getLevel());
        query.orderByAsc(AiProductCategory::getSort);
//        query.orderByAsc(AiProductCategory::getSort);
        query.orderByDesc(AiProductCategory::getSort);
        List<AiProductCategory> listByQuery = this.getListByQuery(query);
        if (CollUtil.isNotEmpty(listByQuery)){
            for (AiProductCategory aiProductCategory : listByQuery){

 src/main/resources/mapper/modules/AiAgentMapper.xml

@@ -21,5 +21,7 @@
                </if>
            </if>
        </where>

        order by a.create_time desc
    </select>
</mapper>

 src/main/resources/mapper/modules/AiProductMapper.xml

@@ -28,6 +28,6 @@
                </if>
            </if>
        </where>
        order by a.sort asc
        order by a.sort desc
    </select>
</mapper>

 src/main/resources/mapper/modules/AiProductPointMapper.xml

@@ -26,6 +26,6 @@
                </if>
            </if>
        </where>
        order by a.sort asc
        order by a.sort desc
    </select>
</mapper>