反馈

lxw

2023-10-26 c4a9593c6fc6cfe4269d4379a348a1e7c215b2d4

反馈

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

@@ -50,6 +50,7 @@
            case "1001":
                map.put("sendFk",0);
                sendFk=mapper.selectSender(user.getId());
                recevierFk=mapper.selectReceiver(user.getId());
                map.put("sendFk",sendFk);
                break;
            //项目经理

 src/main/resources/mapper/BOMFeedbakMapper.xml

@@ -7,7 +7,7 @@
        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}%'  and confirm_status=0
        select  count(*) as receiverCount from tb_bom_feedback where  FIND_IN_SET('${id}',receiver_ids)>0  and confirm_status=0
    </select>

    <select id="getSenderStatus" resultType="BOMFeedback">
@@ -33,7 +33,7 @@
        <where>
            tb_bom_feedback.product_id=tb_product_history.id
            and tb_bom_feedback.sender_id=tb_doc_user.id
            and receiver_ids like '%${id}%'
            and FIND_IN_SET('${id}',receiver_ids)>0
            <foreach collection="flags" item="flag"  open="and (" close=")" separator="or">
                confirm_status=#{flag}
            </foreach>
@@ -49,7 +49,7 @@
        <where>
            tb_bom_feedback.product_id=tb_product_history.id
            and tb_bom_feedback.sender_id=tb_doc_user.id
            and receiver_ids like '%${id}%'
            and FIND_IN_SET('${id}',receiver_ids)>0
            <foreach collection="flags" item="flag"  open="and (" close=")" separator="or">
                confirm_status=#{flag}
            </foreach>