package thyyxxk.webserver.dao.his.zhuyuanyisheng;


import org.apache.ibatis.annotations.*;
import thyyxxk.webserver.entity.zhuyuanyisheng.emrcontrolrule.EmrRule;
import thyyxxk.webserver.entity.zhuyuanyisheng.emrcontrolrule.QualityControlAnalysisOfMedicalRecords;
import thyyxxk.webserver.entity.zhuyuanyisheng.emrcontrolrule.RuleAdd;

import java.util.Date;
import java.util.List;
import java.util.Map;

public interface EmrControlDao {

    @Select("select count(1) " + "from emr_control_temp_code a, " + "     emr_control_rule b " + "where a.rule_id = b.id " + "  and code = #{code} " + "  and b.type = #{type} ")
    int getEmrRuleCount(String code, int type);

    @Insert("insert into emr_control_temp_code (code, rule_id) values (#{code},#{id})")
    void insertControlRule(@Param("id") String id, @Param("code") String code);


    @Insert("insert into emr_control_rule (id, type, off_or_on_rule,prompt_statement,name,sql,prescription) " +
            "values (#{id},#{param.type},#{param.offOrOnRule},#{param.promptStatement},#{param.name}," +
            "#{param.sql},#{param.prescription})")
    void insertRule(@Param("id") String id, @Param("param") RuleAdd param);

    @Select("select name, id, group_name,sql_sentence " +
            "from emr_data_maintenance " +
            "where data_type = 3")
    List<Map<String, Object>> getAvailableObjects();

    @Select("select sql_sentence " +
            " from emr_data_maintenance " +
            " where id = 7")
    String selectedSpecifyTheTimeOfAdmissionSql();

    @Select("select rtrim(inpatient_no)                                                  as inpatient_no, " +
            "       admiss_times, " +
            "       (select rtrim(name) from zd_unit_code where code = zk_ward)          as deptName, " +
            "       (select rtrim(name) from a_employee_mi where code = refer_physician) as tubeBedDoctorName, " +
            "       admiss_date," +
            "       rtrim(name) as name " +
            "from zy_actpatient " +
            "where ${condition} ")
    List<QualityControlAnalysisOfMedicalRecords> selectedPatientsAdmittedAtTheSpecifiedTime(String condition);

    @Select("select id, " +
            "       type, " +
            "       off_or_on_rule, " +
            "       prompt_statement, " +
            "       name, " +
            "       sql, " +
            "       prescription " +
            "from emr_control_rule ")
    List<EmrRule> selectRules();

    @Select("select id, " +
            "       type, " +
            "       off_or_on_rule, " +
            "       prompt_statement, " +
            "       name, " +
            "       sql, " +
            "       prescription " +
            "from emr_control_rule " +
            "where off_or_on_rule = 1")
    List<EmrRule> selectRulesOpen();

    @Select("select code " +
            "from emr_control_temp_code " +
            "where rule_id = #{id} ")
    List<String> selectedEmrCode(String id);

    @Select("${sql} ")
    Map<String, Object> executeSql(String sql);

    @Select("<script>" +
            "select count(1) " +
            "from emr_patient_data " +
            "where pat_no = #{patNo} " +
            "  and times = #{times} " +
            "  and create_date &gt;= #{date} " +
            "  and emr_category_code in " +
            "<foreach collection='codeList' item='item'  open='(' close=')' separator=','>" +
            "#{item}" +
            "</foreach>" +
            "</script>")
    int determineWhetherTheDataWasCreated(String patNo,
                                          Integer times,
                                          Date date,
                                          List<String> codeList);

    @Select("select rtrim(code_rs) " +
            "from dj_user_role a, " +
            "     a_employee_mi b " +
            "where role_id = 38 " +
            "  and a.user_code = b.code " +
            "  and isnull(b.del_flag, 0) = 0")
    List<String> peopleWhoGetMedicalDepartment();

    @Update("update emr_control_rule set off_or_on_rule = #{offOn} where id = #{id} ")
    int switchQualityControl(String id, Integer offOn);

    @Delete("delete emr_control_rule where id = #{id};" +
            "delete emr_control_temp_code where rule_id = #{id} ")
    void deleteRuleById(String id);

    @Select("select code from emr_control_temp_code where rule_id = #{id}")
    List<String> selectEmrCodeByRuleId(String id);

    @Update("update emr_data_maintenance " +
            "set sql_sentence = #{date} " +
            "where id = 7")
    void setTheTime(String date);


    @Select("select sql_sentence " +
            "from emr_data_maintenance where id = 7 ")
    String getAdmissDate();

}