package jnpf.limsMapper;
|
|
import jnpf.limsEntity.LimsMessageConfigRow;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Result;
|
import org.apache.ibatis.annotations.Results;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
@Mapper
|
public interface LimsMessageConfigMapper {
|
@Select("SELECT s.f_id AS config_id, s.f_enabled_mark AS config_enabled, " +
|
"s.f_message_source AS config_source, st.f_id AS relation_id, " +
|
"st.f_enabled_mark AS relation_enabled, st.f_message_type AS relation_message_type, " +
|
"t.f_id AS template_id, t.f_enabled_mark AS template_enabled, " +
|
"t.f_message_type AS template_message_type, t.f_message_source AS template_source, " +
|
"t.f_menu_url AS menu_url " +
|
"FROM base_msg_send s " +
|
"LEFT JOIN base_msg_send_template st ON st.f_send_config_id = s.f_id " +
|
"LEFT JOIN base_msg_template t ON t.f_id = st.f_template_id " +
|
"WHERE s.f_en_code = #{eventCode}")
|
@Results({
|
@Result(column = "config_id", property = "configId"),
|
@Result(column = "config_enabled", property = "configEnabled"),
|
@Result(column = "config_source", property = "configSource"),
|
@Result(column = "relation_id", property = "relationId"),
|
@Result(column = "relation_enabled", property = "relationEnabled"),
|
@Result(column = "relation_message_type", property = "relationMessageType"),
|
@Result(column = "template_id", property = "templateId"),
|
@Result(column = "template_enabled", property = "templateEnabled"),
|
@Result(column = "template_message_type", property = "templateMessageType"),
|
@Result(column = "template_source", property = "templateSource"),
|
@Result(column = "menu_url", property = "menuUrl")
|
})
|
List<LimsMessageConfigRow> selectByEventCode(@Param("eventCode") String eventCode);
|
}
|
