powerInf/getPwrInf

lxw

2023-06-01 7a22433eae5550d49f8de54bdc77ab29a79fd59a

powerInf/getPwrInf

 src/main/java/com/whyc/controller/PowerInfController.java

@@ -1,7 +1,5 @@
package com.whyc.controller;

import com.baomidou.mybatisplus.extension.api.R;
import com.github.pagehelper.PageInfo;
import com.whyc.dto.Response;
import com.whyc.factory.BattinfGroupFactory;
import com.whyc.pojo.Battinf;
@@ -13,18 +11,12 @@
import com.whyc.service.PowerInfService;
import com.whyc.service.StationInfService;
import com.whyc.util.ActionUtil;
import com.whyc.util.CommonUtil;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.apache.poi.util.StringUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.PipedWriter;
import java.util.List;

@RequestMapping("powerInf")
@RestController
@@ -201,4 +193,11 @@
        return service.getExceptionCause(num);
    }


    @GetMapping("getPwrInf")
    @ApiOperation(value = "获取用户管理的机房")
    public Response getPwrInf() {
        UserInf userInf = (UserInf) ActionUtil.getUser();
        return service.getPwrInf(userInf.getUId());
    }
}

 src/main/java/com/whyc/mapper/PowerInfMapper.java

@@ -31,4 +31,6 @@
    int getNum(int userId);

    List<PowerInf> getPwrdevInfAnalysis(int userId);

    List<PowerInf> getPwrInf(Long userId);
}

 src/main/java/com/whyc/service/PowerInfService.java

@@ -151,5 +151,10 @@
        query.select("StationName","PowerProducer","exception_cause","exception_cause_analysis").eq("num",num);
        PowerInf powerInf = mapper.selectOne(query);
        return new Response().set(1,powerInf);
    }

    public Response getPwrInf(Long userId) {
        List<PowerInf> list = mapper.getPwrInf(userId);
        return new Response().set(1, list, "查询成功");
    }
}

 src/main/resources/mapper/PowerInfMapper.xml

@@ -212,6 +212,24 @@
                              and db_user.tb_user_inf.uid = db_user.tb_user_battgroup_baojigroup_usr.uid
                              and db_user.tb_user_inf.uid = #{userId})
    </select>
    <select id="getPwrInf" resultType="com.whyc.pojo.PowerInf">
        select distinct StationId,stationName1,stationName2,StationName3,stationName5 from db_pwrdev_inf.tb_pwrdev_inf p
        <where>
            <if test="uId!=null and uId!=0">
                and StationId in ( select distinct inf.StationId from
                (select StationId from db_battinf.tb_battinf union select StationId from db_pwrdev_inf.tb_pwrdev_inf )
                inf,
                db_user.tb_user_battgroup_baojigroup_battgroup,
                db_user.tb_user_battgroup_baojigroup_usr,
                db_user.tb_user_inf
                where db_user.tb_user_battgroup_baojigroup_battgroup.StationId=inf.StationId
                and
                db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id
                and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid
                and db_user.tb_user_inf.uid=#{uId} )
            </if>
        </where>
    </select>


</mapper>