反馈

lxw

2023-02-03 83e8326cdb4f7e5d6b0ab4048240ec3ade89573c

反馈

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

@@ -3,4 +3,8 @@
import com.whyc.pojo.BOMFeedbak;

public interface BOMFeedbakMapper extends CustomMapper<BOMFeedbak>{
    //获取发送者的反馈个数
    int selectSender(Long id);
    //获取接收者的反馈个数
    int selectReceiver(Long id);
}

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

@@ -12,18 +12,35 @@
    @Autowired(required = false)
    private BOMFeedbakMapper mapper;
    //统计
    public int getFkStatistic(DocUser user) {
        int fk=0;
    public Map<String, Integer> getFkStatistic(DocUser user,Map<String, Integer> map) {
        int sendFk=0;
        int recevierFk=0;
        switch (user.getRoleId()){
            //普通员工
            case "1001":

                map.put("sendFk",0);
                sendFk=mapper.selectSender(user.getId());
                map.put("sendFk",sendFk);
                break;
            //项目经理
            case "1002":break;
            case "1002":
                map.put("sendFk",0);
                map.put("recevierFk",0);
                sendFk=mapper.selectSender(user.getId());
                recevierFk=mapper.selectReceiver(user.getId());
                map.put("sendFk",sendFk);
                map.put("recevierFk",recevierFk);
                break;
            //总经理
            case "1003":break;
            case "1003":
                map.put("sendFk",0);
                map.put("recevierFk",0);
                sendFk=mapper.selectSender(user.getId());
                recevierFk=mapper.selectReceiver(user.getId());
                map.put("sendFk",sendFk);
                map.put("recevierFk",recevierFk);
                break;
        }
        return fk;
        return map;
    }
}

 src/main/java/com/whyc/webSocket/WorksheetSocket.java

@@ -47,7 +47,7 @@
                try {
                    while (!currentThread().isInterrupted()) {
                        Map<String, Integer> statisticMap = mainService.getStatusStatistic((DocUser) httpSession.getAttribute("user"));
                        statisticMap.put("fk",1);
                        feedbakService.getFkStatistic((DocUser) httpSession.getAttribute("user"),statisticMap);
                        session.getBasicRemote().sendObject(new Response().set(1, statisticMap));
                        sleep(2000);
                    }

 src/main/resources/mapper/BOMFeedbakMapper.xml

New file
@@ -0,0 +1,13 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.BOMFeedbakMapper">


    <select id="selectSender" resultType="java.lang.Integer">
        select count(*) as senderCount   from tb_bom_feedback where sender_id=#{id}
    </select>
    <select id="selectReceiver" resultType="java.lang.Integer">
        select   count(*) as receiverCount from tb_bom_feedback where receiver_ids like ${id}
    </select>

</mapper>