web_server/src/main/java/thyyxxk/webserver/dao_his/adverseevent/AdverseEventDao.java

package thyyxxk.webserver.dao_his.adverseevent;

import org.apache.ibatis.annotations.*;
import thyyxxk.webserver.pojo.adverseevent.HandlerInfo;
import thyyxxk.webserver.pojo.adverseevent.ReportDetail;
import thyyxxk.webserver.pojo.adverseevent.ReportIndex;
import thyyxxk.webserver.pojo.dictionary.PureCodeName;

import java.util.List;

@Mapper
public interface AdverseEventDao {
    @Select("select dept_name from adverse_dept where dept_id=#{code}")
    String getDeptName(@Param("code") String code);

    @Select("select rtrim(code_rs) from a_employee_mi where code=#{code}")
    String selectCodeRsByCode(@Param("code") String code);

    @Insert("insert into adverse_event (t_id, category, occur_datetime, submit_datetime, " +
            "department, dept_code, user_name, user_level, work_year, course, result, nurse_reason, " +
            "nurse_reason_else, patient_reason, patient_reason_else, environ_reason, " +
            "environ_reason_else, manage_reason, manage_reason_else, pro_nurse, " +
            "pro_nurse_else, pro_patient, pro_patient_else, pro_environ, pro_environ_else, " +
            "pro_manage, pro_manage_else, user_id, dept_dealer_id, dept_dealer_name) VALUES " +
            "(#{tid}, #{category}, #{occurDatetime}, #{submitDatetime}, #{department}, #{deptCode}," +
            "#{userName}, #{userLevel}, #{workYear}, #{course}, #{result}, #{nurseReason}, " +
            "#{nurseReasonElse}, #{patientReason}, #{patientReasonElse}, #{environReason}, " +
            "#{environReasonElse}, #{manageReason}, #{manageReasonElse}, #{proNurse}, " +
            "#{proNurseElse}, #{proPatient}, #{proPatientElse}, #{proEnviron}, " +
            "#{proEnvironElse}, #{proManage}, #{proManageElse}, #{userId}," +
            "#{deptDealerId}, #{deptDealerName})")
    void submitNewReport(ReportDetail reportDetail);

    @Update("update adverse_event set category=#{category}, occur_datetime=#{occurDatetime}, " +
            "department=#{department}, dept_code=#{deptCode}, user_level=#{userLevel}, work_year=#{workYear}, " +
            "course=#{course}, result=#{result}, nurse_reason=#{nurseReason}, " +
            "nurse_reason_else=#{nurseReasonElse}, patient_reason=#{patientReason}, " +
            "patient_reason_else=#{patientReasonElse}, environ_reason=#{environReason}," +
            " environ_reason_else=#{environReasonElse}, manage_reason=#{manageReason}, " +
            "manage_reason_else=#{manageReasonElse}, pro_nurse=#{proNurse}, " +
            "pro_nurse_else=#{proNurseElse}, pro_patient=#{proPatient}, " +
            "pro_patient_else=#{proPatientElse}, pro_environ=#{proEnviron}, " +
            "pro_environ_else=#{proEnvironElse}, pro_manage=#{proManage}, " +
            "pro_manage_else=#{proManageElse} where p_id=#{pid}")
    void modifyReport(ReportDetail reportDetail);

    @Select("select p_id,category,occur_datetime,submit_datetime,accepted,handled " +
            "from adverse_event where user_id=#{userId} and deleted=0")
    List<ReportIndex> getHistories(@Param("userId") String paramString);

    @Select("select * from adverse_event where p_id=#{pid}")
    ReportDetail getReportDetail(@Param("pid") Integer pid);

    @Select("select dept_id from adverse_dept where leader_code=#{code}")
    List<String> getLeaderDepts(@Param("code") String code);

    @Select("<script>" +
            "select p_id,category,occur_datetime,submit_datetime,user_name,accepted,handled " +
            "from adverse_event where dept_code in " +
            "<foreach collection='deptCodes' item='deptCode' separator=',' open='(' close=')'>" +
            "#{deptCode}" +
            "</foreach> " +
            "</script>")
    List<ReportIndex> getReportsForDeptLeader(@Param("deptCodes") List<String> deptCodes);

    @Select("<script>" +
            "select p_id,category,occur_datetime,submit_datetime,user_name " +
            "from adverse_event where dept_code in " +
            "<foreach collection='deptCodes' item='deptCode' separator=',' open='(' close=')'>" +
            "#{deptCode}" +
            "</foreach> " +
            "and accepted=0 and deleted=0" +
            "</script>")
    List<ReportIndex> getUnAcceptedReports(@Param("deptCodes") List<String> deptCodes);

    @Select("<script>" +
            "select p_id,category,occur_datetime,submit_datetime,user_name " +
            "from adverse_event where dept_code in " +
            "<foreach collection='deptCodes' item='deptCode' separator=',' open='(' close=')'>" +
            "#{deptCode}" +
            "</foreach> " +
            "and accepted=1 and handled=0 and deleted=0" +
            "</script>")
    List<ReportIndex> getAcceptedReports(@Param("deptCodes") List<String> deptCodes);

    @Select("<script>" +
            "select p_id,category,occur_datetime,submit_datetime,user_name " +
            "from adverse_event where dept_code in " +
            "<foreach collection='deptCodes' item='deptCode' separator=',' open='(' close=')'>" +
            "#{deptCode}" +
            "</foreach> " +
            "and handled=1 and deleted=0" +
            "</script>")
    List<ReportIndex> getHandledReports(@Param("deptCodes") List<String> deptCodes);

    @Select("select p_id,category,occur_datetime,submit_datetime,accepted,handled," +
            "user_name,dept_code, department, dept_dealer_name, printed from adverse_event where " +
            "deleted=0 order by occur_datetime desc")
    List<ReportIndex> getAllReports();

    @Update("update adverse_event set accepted=1 where p_id=#{pid}")
    void updateAccepted(@Param("pid") Integer pid);

    @Select("select rtrim(code_rs) code, rtrim(name) name from a_employee_mi where code=#{code}")
    PureCodeName selectUserCodeRsAndName(@Param("code") String code);

    @Update("update adverse_event set handled=1, dept_dealing=#{dealing}, " +
            "dept_dealer_id=#{userId}, dept_dealer_name=#{userName}, " +
            "dept_deal_time=#{datetime} where p_id=#{pid}")
    void updateDeptHandled(HandlerInfo handlerInfo);

    @Update("update adverse_event set final_dealing=#{dealing}, " +
            "final_dealer_id=#{userId}, final_dealer_name=#{userName}, " +
            "final_deal_time=#{datetime} where p_id=#{pid}")
    void updateFinalHandled(HandlerInfo handlerInfo);

    @Select("select dept_id code, dept_name name from adverse_dept")
    List<PureCodeName> getAllDepts();

    @Update("update adverse_event set deleted=1,delete_operate_id=#{operId}, " +
            "delete_time=getdate() where p_id=#{pid}")
    void updateDeleted(@Param("pid") Integer pid, @Param("operId") String operId);

    @Update("update adverse_event set printed=1 where p_id=#{pid}")
    void updatePrinted(@Param("pid") Integer pid);
}