org.apache.ibatis.annotations.Results Java Examples

@Select(
    "<script>SELECT ID, KEY, CREATED, MODIFIED, NAME, DOMAIN, TYPE, DESCRIPTION, OWNER, CUSTOM_1, CUSTOM_2, CUSTOM_3, CUSTOM_4, ORG_LEVEL_1, ORG_LEVEL_2, ORG_LEVEL_3, ORG_LEVEL_4, MARKED_FOR_DELETION FROM WORKBASKET WHERE ID = #{id} "
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results(
    value = {
      @Result(property = "id", column = "ID"),
      @Result(property = "key", column = "KEY"),
      @Result(property = "created", column = "CREATED"),
      @Result(property = "modified", column = "MODIFIED"),
      @Result(property = "name", column = "NAME"),
      @Result(property = "domain", column = "DOMAIN"),
      @Result(property = "type", column = "TYPE"),
      @Result(property = "description", column = "DESCRIPTION"),
      @Result(property = "owner", column = "OWNER"),
      @Result(property = "custom1", column = "CUSTOM_1"),
      @Result(property = "custom2", column = "CUSTOM_2"),
      @Result(property = "custom3", column = "CUSTOM_3"),
      @Result(property = "custom4", column = "CUSTOM_4"),
      @Result(property = "orgLevel1", column = "ORG_LEVEL_1"),
      @Result(property = "orgLevel2", column = "ORG_LEVEL_2"),
      @Result(property = "orgLevel3", column = "ORG_LEVEL_3"),
      @Result(property = "orgLevel4", column = "ORG_LEVEL_4"),
      @Result(property = "markedForDeletion", column = "MARKED_FOR_DELETION")
    })
WorkbasketImpl findById(@Param("id") String id);
 

@Select(
    "<script>"
        + "SELECT DOMAIN, STATE, COUNT(STATE) as COUNT "
        + "FROM TASK "
        + "<where>"
        + "<if test='domains != null'>"
        + "DOMAIN IN (<foreach collection='domains' item='domain' separator=','>#{domain}</foreach>) "
        + "</if>"
        + "<if test='states != null'>"
        + "AND STATE IN (<foreach collection='states' item='state' separator=','>#{state}</foreach>) "
        + "</if>"
        + "</where>"
        + "GROUP BY DOMAIN, STATE"
        + "</script>")
@Results({
  @Result(column = "DOMAIN", property = "domain"),
  @Result(column = "STATE", property = "state"),
  @Result(column = "COUNT", property = "count"),
})
List<TaskQueryItem> getTasksCountByState(
    @Param("domains") List<String> domains, @Param("states") List<TaskState> states);
 

/**
 * 通过降级点来查询
 *
 * @param point
 * @return
 */
@Select("select * from point_return_value where app_group_name = #{appGroupName} and app_name = #{appName}  " +
        "and point = #{point}")
@Results({
        @Result(property = "id", column = "id"),
        @Result(property = "appGroupName", column = "app_group_name"),
        @Result(property = "appName", column = "app_name"),
        @Result(property = "point", column = "point"),
        @Result(property = "returnValueStr", column = "return_value_str"),
        @Result(property = "operatorName", column = "operator_name"),
        @Result(property = "operatorEmail", column = "operator_email"),
        @Result(property = "creatorName", column = "creator_name"),
        @Result(property = "creatorEmail", column = "creator_email"),
        @Result(property = "modifiedTime", column = "modify_time"),
        @Result(property = "createTime", column = "create_time")
})
PointReturnValueDO queryByPoint(@Param("appGroupName") String appGroupName, @Param("appName") String appName,
                                @Param("point") String point);
 

@Results(id = "dxpReceEndResult", value = {
	@Result(property = "msgGuid", column = "msg_guid"),
	@Result(property = "dxpMode", column = "dxp_mode"),
	@Result(property = "dxpStatus", column = "dxp_status"),
	@Result(property = "dxpHost", column = "dxp_host"),
	@Result(property = "msgType", column = "msg_type"),
	@Result(property = "msgName", column = "msg_name"),
	@Result(property = "msgId", column = "msg_Id"),
	@Result(property = "msgKey", column = "msg_key"),
	@Result(property = "msgTime", column = "msg_time"),
	@Result(property = "sendAd", column = "send_ad"),
	@Result(property = "receAd", column = "rece_ad"),
	@Result(property = "note", column = "note"),
	@Result(property = "sysDays", column = "sys_days"),
	@Result(property = "sysDate", column = "sys_date"),
})
@SelectProvider(type = DxpReceEndSqlProvide.class, method = "getDxpReceEndListSql")
List<DxpReceEnd> getDxpReceEndList(DxpReceEnd dxpReceEnd);
 

/**
 * 分页查询降级预案信息
 *
 * @param appGroupName
 * @param appName
 * @param sdsSchemeName
 * @param start
 * @param size
 * @return
 */
@Select("<script> select * from sds_scheme " +
        "<where> " +
        " <if test=\"appGroupName != null and appGroupName.length > 0 \"> app_group_name = #{appGroupName} </if> " +
        " <if test=\"appName != null and appName.length > 0 \"> and app_name = #{appName} </if> " +
        " <if test=\"sdsSchemeName != null and sdsSchemeName.length > 0\"> and sds_scheme_name like "
        + "concat('%', #{sdsSchemeName}, '%') </if> " +
        "</where>" +
        " order by modify_time desc " +
        " limit #{start}, #{size} </script> ")
@Results({
        @Result(property = "id", column = "id"),
        @Result(property = "appGroupName", column = "app_group_name"),
        @Result(property = "appName", column = "app_name"),
        @Result(property = "sdsSchemeName", column = "sds_scheme_name"),
        @Result(property = "operatorName", column = "operator_name"),
        @Result(property = "operatorEmail", column = "operator_email"),
        @Result(property = "creatorName", column = "creator_name"),
        @Result(property = "creatorEmail", column = "creator_email"),
        @Result(property = "modifiedTime", column = "modify_time"),
        @Result(property = "createTime", column = "create_time")
})
List<SdsSchemeDO> querySdsSchemeByPage(@Param("appGroupName") String appGroupName,
                                               @Param("appName") String appName,
                                               @Param("sdsSchemeName") String sdsSchemeName, @Param(
                                                       "start") Integer start, @Param("size") Integer size);
 

/**
 * 按条件查询心跳数据
 *
 * @param appGroupName
 * @param appName
 * @param point
 * @param startTime
 * @param endTime
 * @return
 */
@Select("select * from heartbeat where app_group_name = #{appGroupName} " +
        " and app_name = #{appName} " +
        " and point = #{point} " +
        " and statistics_cycle_time >= #{startTime}" +
        " and statistics_cycle_time <= #{endTime}")
@Results({
        @Result(property = "id", column = "id"),
        @Result(property = "appGroupName", column = "app_group_name"),
        @Result(property = "appName", column = "app_name"),
        @Result(property = "point", column = "point"),
        @Result(property = "downgradeNum", column = "downgrade_num"),
        @Result(property = "visitNum", column = "visit_num"),
        @Result(property = "exceptionNum", column = "exception_num"),
        @Result(property = "timeoutNum", column = "timeout_num"),
        @Result(property = "maxConcurrentNum", column = "max_concurrent_num"),
        @Result(property = "appIp", column = "app_ip"),
        @Result(property = "statisticsCycleTime", column = "statistics_cycle_time")
})
List<HeartbeatDO> queryHeartbeatList(@Param("appGroupName") String appGroupName, @Param("appName") String appName,
                                     @Param("point") String point, @Param("startTime") Date startTime, @Param(
                                             "endTime") Date endTime);
 

/**
 * 查询所有降级点返回值
 *
 * @return
 */
@Select("select * from point_return_value order by modify_time desc ")
@Results({
        @Result(property = "id", column = "id"),
        @Result(property = "appGroupName", column = "app_group_name"),
        @Result(property = "appName", column = "app_name"),
        @Result(property = "point", column = "point"),
        @Result(property = "returnValueStr", column = "return_value_str"),
        @Result(property = "operatorName", column = "operator_name"),
        @Result(property = "operatorEmail", column = "operator_email"),
        @Result(property = "creatorName", column = "creator_name"),
        @Result(property = "creatorEmail", column = "creator_email"),
        @Result(property = "modifiedTime", column = "modify_time"),
        @Result(property = "createTime", column = "create_time")
})
List<PointReturnValueDO> queryAllPointReturnValue();
 

@Results(id = "invtListResult", value = {
	@Result(property = "headGuid", column = "head_guid", id = true),
	@Result(property = "gNum", column = "g_num", jdbcType = JdbcType.INTEGER),
	@Result(property = "itemRecordNo", column = "item_record_no"),
	@Result(property = "itemNo", column = "item_no"),
	@Result(property = "itemName", column = "item_name"),
	@Result(property = "gCode", column = "g_code"),
	@Result(property = "gName", column = "g_name"),
	@Result(property = "gModel", column = "g_model"),
	@Result(property = "barCode", column = "bar_code"),
	@Result(property = "country", column = "country"),
	@Result(property = "currency", column = "currency"),
	@Result(property = "qty", column = "qty", jdbcType = JdbcType.INTEGER),
	@Result(property = "qty1", column = "qty1", jdbcType = JdbcType.INTEGER),
	@Result(property = "qty2", column = "qty2", jdbcType = JdbcType.INTEGER),
	@Result(property = "unit", column = "unit"),
	@Result(property = "unit1", column = "unit_1"),
	@Result(property = "unit2", column = "unit_2"),
	@Result(property = "price", column = "price", jdbcType = JdbcType.DOUBLE),
	@Result(property = "totalPrice", column = "total_price", jdbcType = JdbcType.DOUBLE),
	@Result(property = "note", column = "note"),
	@Result(property = "sysDate", column = "sys_date", jdbcType = JdbcType.TIMESTAMP),
})
@SelectProvider(type = InvtListSqlProvide.class, method = "getInvtListListByHeadGuidSql")
List<InvtList> getInvtListListByHeadGuid(String headGuid);
 

@Select(
    "<script> SELECT ID, TASK_ID, TEXT_FIELD, CREATOR, CREATED, MODIFIED"
        + " FROM TASK_COMMENT "
        + "WHERE ID = #{taskCommentId} "
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results(
    value = {
      @Result(property = "id", column = "ID"),
      @Result(property = "taskId", column = "TASK_ID"),
      @Result(property = "textField", column = "TEXT_FIELD"),
      @Result(property = "creator", column = "CREATOR"),
      @Result(property = "created", column = "CREATED"),
      @Result(property = "modified", column = "MODIFIED"),
    })
TaskCommentImpl findById(@Param("taskCommentId") String taskCommentId);
 

@Select(
    "<script>SELECT ID, COMPANY, SYSTEM, SYSTEM_INSTANCE, TYPE, VALUE "
        + "FROM OBJECT_REFERENCE "
        + "WHERE COMPANY = #{objectReference.company} "
        + "AND SYSTEM = #{objectReference.system} "
        + "AND SYSTEM_INSTANCE = #{objectReference.systemInstance} "
        + "AND TYPE = #{objectReference.type} "
        + "AND VALUE = #{objectReference.value} "
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results({
  @Result(property = "id", column = "ID"),
  @Result(property = "company", column = "COMPANY"),
  @Result(property = "system", column = "SYSTEM"),
  @Result(property = "systemInstance", column = "SYSTEM_INSTANCE"),
  @Result(property = "type", column = "TYPE"),
  @Result(property = "value", column = "VALUE")
})
ObjectReference findByObjectReference(@Param("objectReference") ObjectReference objectReference);
 

@Select(
    "<script> SELECT ID, TASK_ID, TEXT_FIELD, CREATOR, CREATED, MODIFIED"
        + " FROM TASK_COMMENT "
        + "WHERE TASK_ID = #{taskId} "
        + " ORDER BY CREATED ASC "
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results(
    value = {
      @Result(property = "id", column = "ID"),
      @Result(property = "taskId", column = "TASK_ID"),
      @Result(property = "textField", column = "TEXT_FIELD"),
      @Result(property = "creator", column = "CREATOR"),
      @Result(property = "created", column = "CREATED"),
      @Result(property = "modified", column = "MODIFIED"),
    })
List<TaskCommentImpl> findByTaskId(@Param("taskId") String taskId);
 

@Results(id = "orderListResult", value = {
	@Result(property = "headGuid", column = "head_guid"),
	@Result(property = "gNum", column = "g_num"),
	@Result(property = "itemNo", column = "item_no"),
	@Result(property = "itemName", column = "item_name"),
	@Result(property = "itemDescribe", column = "item_describe"),
	@Result(property = "barCode", column = "bar_code"),
	@Result(property = "unit", column = "unit"),
	@Result(property = "qty", column = "qty"),
	@Result(property = "price", column = "price"),
	@Result(property = "totalPrice", column = "total_price"),
	@Result(property = "currency", column = "currency"),
	@Result(property = "country", column = "country"),
	@Result(property = "note", column = "note"),
	@Result(property = "sysDate", column = "sys_date"),
})
@SelectProvider(type = OrderListSqlProvide.class, method = "getOrderListByHeadGuidSql")
List<OrderList> getOrderListByHeadGuid(String headGuid);
 

@Select(
    "<script>SELECT ID, PLANNED, STATE FROM TASK "
        + "WHERE ID IN(<foreach item='item' collection='taskIds' separator=',' >#{item}</foreach>) "
        + "AND STATE IN ( 'READY','CLAIMED') "
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results(
    value = {
      @Result(property = "left", column = "ID"),
      @Result(
          property = "right",
          column = "PLANNED",
          javaType = Instant.class,
          typeHandler = InstantTypeHandler.class)
    })
List<Pair<String, Instant>> filterTaskIdsForReadyAndClaimed(
    @Param("taskIds") List<String> taskIds);
 

@Select(
    "<script>SELECT ID, EXTERNAL_ID, STATE, WORKBASKET_ID, OWNER, MODIFIED, CLASSIFICATION_ID, "
        + "PLANNED, DUE, CALLBACK_STATE FROM TASK "
        + "<where> "
        + "<if test='taskIds != null'>ID IN(<foreach item='item' collection='taskIds' separator=',' >#{item}</foreach>)</if> "
        + "<if test='externalIds != null'>EXTERNAL_ID IN(<foreach item='item' collection='externalIds' separator=',' >#{item}</foreach>)</if> "
        + "</where> "
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results(
    value = {
      @Result(property = "taskId", column = "ID"),
      @Result(property = "externalId", column = "EXTERNAL_ID"),
      @Result(property = "workbasketId", column = "WORKBASKET_ID"),
      @Result(property = "classificationId", column = "CLASSIFICATION_ID"),
      @Result(property = "owner", column = "OWNER"),
      @Result(property = "taskState", column = "STATE"),
      @Result(property = "modified", column = "MODIFIED"),
      @Result(property = "due", column = "DUE"),
      @Result(property = "planned", column = "PLANNED"),
      @Result(property = "callbackState", column = "CALLBACK_STATE")
    })
List<MinimalTaskSummary> findExistingTasks(
    @Param("taskIds") List<String> taskIds, @Param("externalIds") List<String> externalIds);
 

@Insert(
    "<script>"
        + "INSERT INTO SCHEDULED_JOB (JOB_ID, PRIORITY, CREATED, DUE, STATE, LOCKED_BY, LOCK_EXPIRES, TYPE, RETRY_COUNT, ARGUMENTS) "
        + "VALUES ("
        + "<choose>"
        + "<when test=\"_databaseId == 'db2'\">"
        + "SCHEDULED_JOB_SEQ.NEXTVAL"
        + "</when>"
        + "<otherwise>"
        + "nextval('SCHEDULED_JOB_SEQ')"
        + "</otherwise>"
        + "</choose>"
        + ", #{job.priority}, #{job.created}, #{job.due}, #{job.state}, #{job.lockedBy}, #{job.lockExpires}, #{job.type}, #{job.retryCount}, #{job.arguments,javaType=java.util.Map,typeHandler=pro.taskana.common.internal.persistence.MapTypeHandler} )"
        + "</script>")
@Results(value = {@Result(property = "jobId", column = "JOB_ID")})
Integer insertJob(@Param("job") ScheduledJob job);
 

@Results(id = "storeResult", value = {
        @Result(property = "lmsNo", column = "lms_no"),
        @Result(property = "tradeCode", column = "trade_code"),
        @Result(property = "tradeName", column = "trade_name"),
        @Result(property = "itemNo", column = "item_no"),
        @Result(property = "codeTs", column = "code_ts"),
        @Result(property = "gName", column = "g_name"),
        @Result(property = "gModel", column = "g_model"),
        @Result(property = "tradeCountry", column = "trade_country"),
        @Result(property = "unit", column = "unit"),
        @Result(property = "declPrice", column = "decl_price"),
        @Result(property = "tradeCurr", column = "trade_curr"),
        @Result(property = "customsCode", column = "customs_code"),
        @Result(property = "legalIQty", column = "legal_i_qty"),
        @Result(property = "legalOQty", column = "legal_o_qty"),
        @Result(property = "legalRemainQty", column = "legal_remain_qty"),
        @Result(property = "periodStartQty", column = "period_start_qty")
})
@SelectProvider(type = StoreSqlProvide.class, method = "getStoreListSql")
List<Store> getStoreList(Store store);
 

@Select(
    "<script>SELECT * FROM WORKBASKET ORDER BY id "
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results(
    value = {
      @Result(property = "id", column = "ID"),
      @Result(property = "key", column = "KEY"),
      @Result(property = "name", column = "NAME"),
      @Result(property = "description", column = "DESCRIPTION"),
      @Result(property = "owner", column = "OWNER"),
      @Result(property = "domain", column = "DOMAIN"),
      @Result(property = "type", column = "TYPE"),
      @Result(property = "custom1", column = "CUSTOM_1"),
      @Result(property = "custom2", column = "CUSTOM_2"),
      @Result(property = "custom3", column = "CUSTOM_3"),
      @Result(property = "custom4", column = "CUSTOM_4"),
      @Result(property = "orgLevel1", column = "ORG_LEVEL_1"),
      @Result(property = "orgLevel2", column = "ORG_LEVEL_2"),
      @Result(property = "orgLevel3", column = "ORG_LEVEL_3"),
      @Result(property = "orgLevel4", column = "ORG_LEVEL_4")
    })
List<WorkbasketSummaryImpl> findAll();
 

@Select(
    "<script>SELECT ID, KEY, NAME, DESCRIPTION, OWNER, DOMAIN, TYPE, CUSTOM_1, CUSTOM_2, CUSTOM_3, CUSTOM_4, ORG_LEVEL_1, ORG_LEVEL_2, ORG_LEVEL_3, ORG_LEVEL_4 FROM WORKBASKET WHERE ID = #{id} "
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results(
    value = {
      @Result(property = "id", column = "ID"),
      @Result(property = "key", column = "KEY"),
      @Result(property = "name", column = "NAME"),
      @Result(property = "description", column = "DESCRIPTION"),
      @Result(property = "owner", column = "OWNER"),
      @Result(property = "domain", column = "DOMAIN"),
      @Result(property = "type", column = "TYPE"),
      @Result(property = "custom1", column = "CUSTOM_1"),
      @Result(property = "custom2", column = "CUSTOM_2"),
      @Result(property = "custom3", column = "CUSTOM_3"),
      @Result(property = "custom4", column = "CUSTOM_4"),
      @Result(property = "orgLevel1", column = "ORG_LEVEL_1"),
      @Result(property = "orgLevel2", column = "ORG_LEVEL_2"),
      @Result(property = "orgLevel3", column = "ORG_LEVEL_3"),
      @Result(property = "orgLevel4", column = "ORG_LEVEL_4")
    })
List<WorkbasketSummaryImpl> findSummaryById(@Param("key") String id);
 

@Select(
    "<script>SELECT ID, KEY, NAME, DESCRIPTION, OWNER, DOMAIN, TYPE, CUSTOM_1, CUSTOM_2, CUSTOM_3, CUSTOM_4, ORG_LEVEL_1, ORG_LEVEL_2, ORG_LEVEL_3, ORG_LEVEL_4 FROM WORKBASKET WHERE ID IN (SELECT TARGET_ID FROM DISTRIBUTION_TARGETS WHERE SOURCE_ID = #{id}) "
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results(
    value = {
      @Result(property = "id", column = "ID"),
      @Result(property = "key", column = "KEY"),
      @Result(property = "name", column = "NAME"),
      @Result(property = "description", column = "DESCRIPTION"),
      @Result(property = "owner", column = "OWNER"),
      @Result(property = "domain", column = "DOMAIN"),
      @Result(property = "type", column = "TYPE"),
      @Result(property = "custom1", column = "CUSTOM_1"),
      @Result(property = "custom2", column = "CUSTOM_2"),
      @Result(property = "custom3", column = "CUSTOM_3"),
      @Result(property = "custom4", column = "CUSTOM_4"),
      @Result(property = "orgLevel1", column = "ORG_LEVEL_1"),
      @Result(property = "orgLevel2", column = "ORG_LEVEL_2"),
      @Result(property = "orgLevel3", column = "ORG_LEVEL_3"),
      @Result(property = "orgLevel4", column = "ORG_LEVEL_4")
    })
List<WorkbasketSummaryImpl> findDistributionTargets(@Param("id") String id);
 

@Select(
    "<script>SELECT ID, KEY, CREATED, MODIFIED, NAME, DOMAIN, TYPE, DESCRIPTION, OWNER, CUSTOM_1, CUSTOM_2, CUSTOM_3, CUSTOM_4, ORG_LEVEL_1, ORG_LEVEL_2, ORG_LEVEL_3, ORG_LEVEL_4, MARKED_FOR_DELETION FROM WORKBASKET WHERE UPPER(KEY) = UPPER(#{key}) and UPPER(DOMAIN) = UPPER(#{domain}) "
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results(
    value = {
      @Result(property = "id", column = "ID"),
      @Result(property = "key", column = "KEY"),
      @Result(property = "created", column = "CREATED"),
      @Result(property = "modified", column = "MODIFIED"),
      @Result(property = "name", column = "NAME"),
      @Result(property = "domain", column = "DOMAIN"),
      @Result(property = "type", column = "TYPE"),
      @Result(property = "description", column = "DESCRIPTION"),
      @Result(property = "owner", column = "OWNER"),
      @Result(property = "custom1", column = "CUSTOM_1"),
      @Result(property = "custom2", column = "CUSTOM_2"),
      @Result(property = "custom3", column = "CUSTOM_3"),
      @Result(property = "custom4", column = "CUSTOM_4"),
      @Result(property = "orgLevel1", column = "ORG_LEVEL_1"),
      @Result(property = "orgLevel2", column = "ORG_LEVEL_2"),
      @Result(property = "orgLevel3", column = "ORG_LEVEL_3"),
      @Result(property = "orgLevel4", column = "ORG_LEVEL_4"),
      @Result(property = "markedForDeletion", column = "MARKED_FOR_DELETION")
    })
WorkbasketImpl findByKeyAndDomain(@Param("key") String key, @Param("domain") String domain);
 

@SelectProvider(type=UserSqlProvider.class, method="selectByExample")
@Results({
    @Result(column="id", property="id", jdbcType=JdbcType.INTEGER, id=true),
    @Result(column="username", property="username", jdbcType=JdbcType.VARCHAR),
    @Result(column="psw", property="psw", jdbcType=JdbcType.VARCHAR)
})
List<User> selectByExample(UserCriteria example);
 

@Results(id = "lgsHeadResult", value = {
	@Result(property = "guid", column = "guid"),
	@Result(property = "appType", column = "app_type"),
	@Result(property = "appTime", column = "app_time"),
	@Result(property = "appStatus", column = "app_status"),
	@Result(property = "appUid", column = "app_uid"),
	@Result(property = "appUname", column = "app_uname"),
	@Result(property = "appSenderId", column = "app_sender_id"),
	@Result(property = "declTime", column = "decl_time"),
	@Result(property = "logisticsCode", column = "logistics_code"),
	@Result(property = "logisticsName", column = "logistics_name"),
	@Result(property = "logisticsNo", column = "logistics_no"),
	@Result(property = "billNo", column = "bill_no"),
	@Result(property = "freight", column = "freight"),
	@Result(property = "insuredFee", column = "insured_fee"),
	@Result(property = "currency", column = "currency"),
	@Result(property = "weight", column = "weight"),
	@Result(property = "packNo", column = "pack_no"),
	@Result(property = "goodsInfo", column = "goods_info"),
	@Result(property = "consignee", column = "consignee"),
	@Result(property = "consigneeAddress", column = "consignee_address"),
	@Result(property = "consigneeTelephone", column = "consignee_telephone"),
	@Result(property = "note", column = "note"),
	@Result(property = "msgGuid", column = "msg_guid"),
	@Result(property = "delFlag", column = "del_flag"),
	@Result(property = "sysDays", column = "sys_days"),
	@Result(property = "sysDate", column = "sys_date"),
})
@SelectProvider(type = LgsHeadSqlProvide.class, method = "getLgsHeadListSql")
List<LgsHead> getLgsHeadList(LgsHead lgsHead);
 

/**
 * query all result by redis_info_id
 * @param redisInfoId queryId
 * @return List<RDBAnalyzeResult>
 */
@Select("select * from rdb_analyze_result where schedule_id != (select max(schedule_id) from rdb_analyze_result where redis_info_id = #{redisInfoId}) and redis_info_id = #{redisInfoId}")
@Results({ @Result(id = true, column = "id", property = "id"),
		@Result(column = "schedule_id", property = "scheduleId"),
		@Result(column = "redis_info_id", property = "redisInfoId"),
		@Result(column = "result", property = "result")})
List<RDBAnalyzeResult> selectAllResultByIdExceptLatest(Long redisInfoId);
 

@Select(
    "<script>"
        + "SELECT ID, BUSINESS_PROCESS_ID, PARENT_BUSINESS_PROCESS_ID, TASK_ID, EVENT_TYPE, CREATED, USER_ID, DOMAIN, WORKBASKET_KEY, "
        + "POR_COMPANY, POR_SYSTEM, POR_INSTANCE, POR_TYPE, POR_VALUE, TASK_CLASSIFICATION_KEY, TASK_CLASSIFICATION_CATEGORY,"
        + "ATTACHMENT_CLASSIFICATION_KEY, OLD_VALUE, NEW_VALUE, CUSTOM_1, CUSTOM_2, CUSTOM_3, CUSTOM_4, DETAILS "
        + "FROM HISTORY_EVENTS WHERE ID = #{id} "
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results(
    value = {
      @Result(property = "id", column = "ID"),
      @Result(property = "businessProcessId", column = "BUSINESS_PROCESS_ID"),
      @Result(property = "parentBusinessProcessId", column = "PARENT_BUSINESS_PROCESS_ID"),
      @Result(property = "taskId", column = "TASK_ID"),
      @Result(property = "eventType", column = "EVENT_TYPE"),
      @Result(property = "created", column = "CREATED"),
      @Result(property = "userId", column = "USER_ID"),
      @Result(property = "domain", column = "DOMAIN"),
      @Result(property = "workbasketKey", column = "WORKBASKET_KEY"),
      @Result(property = "porCompany", column = "POR_COMPANY"),
      @Result(property = "porSystem", column = "POR_SYSTEM"),
      @Result(property = "porInstance", column = "POR_INSTANCE"),
      @Result(property = "porType", column = "POR_TYPE"),
      @Result(property = "porValue", column = "POR_VALUE"),
      @Result(property = "taskClassificationKey", column = "TASK_CLASSIFICATION_KEY"),
      @Result(property = "taskClassificationCategory", column = "TASK_CLASSIFICATION_CATEGORY"),
      @Result(property = "attachmentClassificationKey", column = "ATTACHMENT_CLASSIFICATION_KEY"),
      @Result(property = "oldValue", column = "OLD_VALUE"),
      @Result(property = "newValue", column = "NEW_VALUE"),
      @Result(property = "custom1", column = "CUSTOM_1"),
      @Result(property = "custom2", column = "CUSTOM_2"),
      @Result(property = "custom3", column = "CUSTOM_3"),
      @Result(property = "custom4", column = "CUSTOM_4"),
      @Result(property = "details", column = "DETAILS")
    })
TaskanaHistoryEvent findById(@Param("id") String id);
 

@Select(
    "<script>SELECT ID, COMPANY, SYSTEM, SYSTEM_INSTANCE, TYPE, VALUE "
        + "FROM OBJECT_REFERENCE "
        + "WHERE ID = #{id}"
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results({
  @Result(property = "id", column = "ID"),
  @Result(property = "company", column = "COMPANY"),
  @Result(property = "system", column = "SYSTEM"),
  @Result(property = "systemInstance", column = "SYSTEM_INSTANCE"),
  @Result(property = "type", column = "TYPE"),
  @Result(property = "value", column = "VALUE")
})
ObjectReference findById(@Param("id") String id);
 

@Results(id = "impInvtHeadResult", value = {
	@Result(property = "guid", column = "guid", id = true),
	@Result(property = "preNo", column = "pre_no"),
	@Result(property = "invtNo", column = "invt_no"),
	@Result(property = "detailsCode", column = "detailscode"),
	@Result(property = "applyCode", column = "applycode"),
	@Result(property = "auditState", column = "audit_state"),
	@Result(property = "bwName", column = "bw_name"),
	@Result(property = "applyDate", column = "apply_date", jdbcType = JdbcType.TIMESTAMP),
	@Result(property = "payCode", column = "payecode"),
	@Result(property = "payName", column = "payename")
})
@SelectProvider(type = ImpInvtHeadSqlProvide.class, method = "getInvtHeadListByInvtNoSql")
List<ImpInvtHead> getInvtHeadListByInvtNo(String invtNo);
 

@Select(
    "<script>SELECT ID, KEY, PARENT_ID, PARENT_KEY, CATEGORY, TYPE, DOMAIN, VALID_IN_DOMAIN, CREATED, MODIFIED, NAME, DESCRIPTION, PRIORITY, SERVICE_LEVEL, APPLICATION_ENTRY_POINT, CUSTOM_1, CUSTOM_2, CUSTOM_3, CUSTOM_4, CUSTOM_5, CUSTOM_6, CUSTOM_7, CUSTOM_8 "
        + "FROM CLASSIFICATION "
        + "WHERE ID = #{id}"
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results({
  @Result(property = "id", column = "ID"),
  @Result(property = "key", column = "KEY"),
  @Result(property = "parentId", column = "PARENT_ID"),
  @Result(property = "parentKey", column = "PARENT_KEY"),
  @Result(property = "category", column = "CATEGORY"),
  @Result(property = "type", column = "TYPE"),
  @Result(property = "domain", column = "DOMAIN"),
  @Result(property = "isValidInDomain", column = "VALID_IN_DOMAIN"),
  @Result(property = "created", column = "CREATED"),
  @Result(property = "modified", column = "MODIFIED"),
  @Result(property = "name", column = "NAME"),
  @Result(property = "description", column = "DESCRIPTION"),
  @Result(property = "priority", column = "PRIORITY"),
  @Result(property = "serviceLevel", column = "SERVICE_LEVEL"),
  @Result(property = "applicationEntryPoint", column = "APPLICATION_ENTRY_POINT"),
  @Result(property = "custom1", column = "CUSTOM_1"),
  @Result(property = "custom2", column = "CUSTOM_2"),
  @Result(property = "custom3", column = "CUSTOM_3"),
  @Result(property = "custom4", column = "CUSTOM_4"),
  @Result(property = "custom5", column = "CUSTOM_5"),
  @Result(property = "custom6", column = "CUSTOM_6"),
  @Result(property = "custom7", column = "CUSTOM_7"),
  @Result(property = "custom8", column = "CUSTOM_8")
})
ClassificationImpl findById(@Param("id") String id);
 

@Results(id = "deliveryListResult", value = {
	@Result(property = "headGuid", column = "head_guid", id = true),
	@Result(property = "gNum", column = "g_num", id = true, jdbcType = JdbcType.INTEGER),
	@Result(property = "logisticsNo", column = "logistics_no"),
	@Result(property = "note", column = "note"),
	@Result(property = "sysDate", column = "sys_date", jdbcType = JdbcType.TIMESTAMP)
})
@SelectProvider(type = DeliveryListSqlProvide.class, method = "getDeliveryListByGuidSql")
List<DeliveryList> getDeliveryListByGuid(String headGuid);
 

@Results(id = "invtCancelResult", value = {
	@Result(property = "headGuid", column = "head_guid", id = true),
	@Result(property = "appType", column = "app_type"),
	@Result(property = "appTime", column = "app_time", jdbcType = JdbcType.TIMESTAMP),
	@Result(property = "appStatus", column = "app_status"),
	@Result(property = "appUid", column = "app_uid"),
	@Result(property = "appUname", column = "app_uname"),
	@Result(property = "appSenderId", column = "app_sender_id"),
	@Result(property = "declTime", column = "decl_time"),
	@Result(property = "customsCode", column = "customs_code"),
	@Result(property = "orderNo", column = "order_no"),
	@Result(property = "ebpCode", column = "ebp_code"),
	@Result(property = "ebpName", column = "ebp_name"),
	@Result(property = "ebcCode", column = "ebc_code"),
	@Result(property = "ebcName", column = "ebc_name"),
	@Result(property = "logisticsNo", column = "logistics_no"),
	@Result(property = "logisticsCode", column = "logistics_code"),
	@Result(property = "logisticsName", column = "logistics_name"),
	@Result(property = "copNo", column = "cop_no"),
	@Result(property = "preNo", column = "pre_no"),
	@Result(property = "invtNo", column = "invt_no"),
	@Result(property = "buyerIdType", column = "buyer_id_type"),
	@Result(property = "buyerIdNumber", column = "buyer_id_number"),
	@Result(property = "buyerName", column = "buyer_name"),
	@Result(property = "buyerTelephone", column = "buyer_telephone"),
	@Result(property = "agentCode", column = "agent_code"),
	@Result(property = "agentCode", column = "agent_name"),
	@Result(property = "reason", column = "reason"),
	@Result(property = "note", column = "note"),
	@Result(property = "delFlag", column = "del_flag"),
	@Result(property = "msgGuid", column = "msg_guid"),
	@Result(property = "sysDays", column = "sys_days"),
	@Result(property = "sysDate", column = "sys_date"),
})
@SelectProvider(type = InvtCancelSqlProvide.class, method = "getInvtCancelListSql")
List<InvtCancel> getInvtCancelList(InvtCancel invtCancel);
 

@Select(
    "<script> select CUSTOM_ATTRIBUTES from ATTACHMENT where id = #{attachmentId}"
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results(
    value = {
      @Result(
          property = "customAttributes",
          column = "CUSTOM_ATTRIBUTES",
          javaType = String.class,
          typeHandler = ClobTypeHandler.class)
    })
String getCustomAttributesAsString(@Param("attachmentId") String attachmentId);