org.apache.ibatis.annotations.Result Java Exaples

Source File: WorkbasketMapper.java From taskana with Apache License 2.0

6 votes

@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);

Source File: PointReturnValueDao.java From sds with Apache License 2.0

6 votes

/**
 * 查询所有降级点返回值
 *
 * @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();

Source File: ObjectReferenceMapper.java From taskana with Apache License 2.0

6 votes

@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);

Source File: MonitorMapper.java From taskana with Apache License 2.0

6 votes

@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);

Source File: PubRtnMapper.java From maintain with MIT License

6 votes

@Results(id = "pubRtnResult", value = {
	@Result(property = "msgGuid", column = "msg_guid", id = true),
	@Result(property = "bizType", column = "biz_type"),
	@Result(property = "bizGuid", column = "biz_guid"),
	@Result(property = "preNo", column = "pre_no"),
	@Result(property = "h2kNo", column = "h2k_no"),
	@Result(property = "appStatus", column = "app_status"),
	@Result(property = "rtnStatus", column = "rtn_status"),
	@Result(property = "rtnTime", column = "rtn_time", jdbcType = JdbcType.TIMESTAMP),
	@Result(property = "rtnInfo", column = "rtn_info"),
	@Result(property = "note", column = "note"),
	@Result(property = "sysDays", column = "sys_days", jdbcType = JdbcType.INTEGER),
	@Result(property = "sysDate", column = "sys_date", jdbcType = JdbcType.TIMESTAMP)
})
@SelectProvider(type = PubRtnSqlProvide.class, method = "getPubRtnListByBizGuidSql")
List<PubRtn> getPubRtnListByBizGuid(String bizGuid);

Source File: PointReturnValueDao.java From sds with Apache License 2.0

6 votes

/**
 * 通过降级点来查询
 *
 * @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);

Source File: PointReturnValueDao.java From sds with Apache License 2.0

6 votes

/**
 * 批量查询降级点返回值
 *
 * @param appGroupName
 * @param appName
 * @param points
 * @param status
 * @return
 */
@Select(" <script> select * from point_return_value where app_group_name = #{appGroupName} " +
        " and app_name = #{appName} " +
        " <if test='points != null'> " +
        " and point in " +
        " <foreach collection=\"points\" item=\"point\" open=\"(\" close=\")\" separator=\",\">#{point}</foreach>" +
        "  </if> " +
        " and status = #{status} " +
        " </script> ")
@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> queryPointReturnValueBatch(@Param("appGroupName") String appGroupName,
                                                    @Param("appName") String appName,
                                                    @Param("points") List<String> points,
                                                    @Param("status") Integer status);

Source File: StoreMapper.java From maintain with MIT License

6 votes

@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);

Source File: SdsSchemeDao.java From sds with Apache License 2.0

6 votes

/**
 * 通过应用组名称来查询
 *
 * @param appGroupName
 * @param appName
 * @param sdsSchemeName
 * @return
 */
@Select("select * from sds_scheme where app_group_name = #{appGroupName} " +
        " and app_name = #{appName} " +
        " and sds_scheme_name = #{sdsSchemeName} " +
        " 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 = "sdsSchemeName", column = "sds_scheme_name"),
        @Result(property = "operatorName", column = "operator_name"),
        @Result(property = "operatorEmail", column = "operator_email"),
        @Result(property = "modifiedTime", column = "modify_time"),
        @Result(property = "createTime", column = "create_time")
})
SdsSchemeDO queryByGroupName(@Param("appGroupName") String appGroupName, @Param("appName") String appName,
                                 @Param("sdsSchemeName") String sdsSchemeName);

Source File: SdsSchemeDao.java From sds with Apache License 2.0

6 votes

/**
 * 分页查询降级预案信息
 *
 * @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);

Source File: HeartbeatDao.java From sds with Apache License 2.0

6 votes

/**
 * 按条件查询心跳数据
 *
 * @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);

Source File: TaskCommentMapper.java From taskana with Apache License 2.0

6 votes

@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);

Source File: TaskCommentMapper.java From taskana with Apache License 2.0

6 votes

@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);

Source File: TaskMapper.java From taskana with Apache License 2.0

6 votes

@Select(
    "<script> "
        + "<choose>"
        + "<when  test='accessIds == null'>"
        + "SELECT t.ID FROM TASK t WHERE 1 = 2 "
        + "</when>"
        + "<otherwise>"
        + "SELECT t.ID FROM TASK t WHERE t.ID IN(<foreach item='item' collection='taskIds' separator=',' >#{item}</foreach>)"
        + "AND NOT (t.WORKBASKET_ID IN ( "
        + "<choose>"
        + "<when test=\"_databaseId == 'db2'\">"
        + "SELECT WID from (SELECT WORKBASKET_ID as WID, MAX(PERM_READ) as MAX_READ FROM WORKBASKET_ACCESS_LIST AS s where "
        + "</when>"
        + "<otherwise>"
        + "SELECT WID from (SELECT WORKBASKET_ID as WID, MAX(PERM_READ::int) as MAX_READ FROM WORKBASKET_ACCESS_LIST AS s where "
        + "</otherwise>"
        + "</choose>"
        + "ACCESS_ID IN (<foreach item='item' collection='accessIds' separator=',' >#{item}</foreach>) "
        + "group by WORKBASKET_ID ) AS f where max_read = 1 ))"
        + "</otherwise>"
        + "</choose>"
        + "</script>")
@Results(value = {@Result(property = "id", column = "ID")})
List<String> filterTaskIdsNotAuthorizedFor(
    @Param("taskIds") List<String> taskIds, @Param("accessIds") List<String> accessIds);

Source File: TaskMapper.java From taskana with Apache License 2.0

6 votes

@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);

Source File: InvtListMapper.java From maintain with MIT License

6 votes

@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);

Source File: TaskQueryMapper.java From taskana with Apache License 2.0

6 votes

@Select(
    "<script>SELECT ID, COMPANY, SYSTEM, SYSTEM_INSTANCE, TYPE, VALUE "
        + "FROM OBJECT_REFERENCE "
        + "<where>"
        + "<if test='company != null'>AND COMPANY IN(<foreach item='item' collection='company' separator=',' >#{item}</foreach>)</if> "
        + "<if test='system != null'>AND SYSTEM IN(<foreach item='item' collection='system' separator=',' >#{item}</foreach>)</if> "
        + "<if test='systemInstance != null'>AND SYSTEM_INSTANCE IN(<foreach item='item' collection='systemInstance' separator=',' >#{item}</foreach>)</if> "
        + "<if test='type != null'>AND TYPE IN(<foreach item='item' collection='type' separator=',' >#{item}</foreach>)</if> "
        + "<if test='value != null'>AND VALUE IN(<foreach item='item' collection='value' separator=',' >#{item}</foreach>)</if> "
        + "</where>"
        + "<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")
})
List<ObjectReference> queryObjectReferences(ObjectReferenceQueryImpl objectReference);

Source File: JobMapper.java From taskana with Apache License 2.0

6 votes

@Select(
    "<script> SELECT   JOB_ID, PRIORITY, CREATED, DUE, STATE, LOCKED_BY, LOCK_EXPIRES, TYPE, RETRY_COUNT, ARGUMENTS "
        + "FROM SCHEDULED_JOB "
        + "WHERE STATE IN ( 'READY') AND (DUE is null OR DUE &lt; CURRENT_TIMESTAMP) AND (LOCK_EXPIRES is null OR LOCK_EXPIRES &lt; CURRENT_TIMESTAMP) AND RETRY_COUNT > 0 "
        + "ORDER BY PRIORITY DESC "
        + "<if test=\"_databaseId == 'db2'\">with UR </if> "
        + "</script>")
@Results(
    value = {
      @Result(property = "jobId", column = "JOB_ID"),
      @Result(property = "priority", column = "PRIORITY"),
      @Result(property = "created", column = "CREATED"),
      @Result(property = "due", column = "DUE"),
      @Result(property = "state", column = "STATE"),
      @Result(property = "lockedBy", column = "LOCKED_BY"),
      @Result(property = "lockExpires", column = "LOCK_EXPIRES"),
      @Result(property = "type", column = "TYPE"),
      @Result(property = "retryCount", column = "RETRY_COUNT"),
      @Result(
          property = "arguments",
          column = "ARGUMENTS",
          javaType = Map.class,
          typeHandler = MapTypeHandler.class)
    })
List<ScheduledJob> findJobsToRun();

Source File: DxpReceEndMapper.java From maintain with MIT License

6 votes

@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);

Source File: WorkbasketMapper.java From taskana with Apache License 2.0

6 votes

@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();

Source File: TaskMapper.java From taskana with Apache License 2.0

6 votes

@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);

Source File: WorkbasketMapper.java From taskana with Apache License 2.0

6 votes

@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);

Source File: HistoryEventMapper.java From taskana with Apache License 2.0

5 votes

@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);

Source File: DxpReceMsgMapper.java From maintain with MIT License

5 votes

@Results(id = "dxpReceMsgResult", value = {
	@Result(property = "msgGuid", column = "msg_guid"),
	@Result(property = "encoding", column = "encoding"),
	@Result(property = "msgSize", column = "msg_size"),
	@Result(property = "msgBlob", column = "msg_blob"),
	@Result(property = "bizBlob", column = "biz_blob"),
	@Result(property = "note", column = "note"),
	@Result(property = "sysDays", column = "sys_days"),
	@Result(property = "sysDate", column = "sys_date"),
})
@SelectProvider(type = DxpReceMsgSqlProvide.class, method = "getDxpReceMsgByMsgGuidSql")
DxpReceMsg getDxpReceMsgByMsgGuid(String msgGuid);

Source File: DeliveryHeadMapper.java From maintain with MIT License

5 votes

@Results(id = "deliveryHeadResult", 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", jdbcType = JdbcType.TIMESTAMP),
	@Result(property = "customsCode", column = "customs_code"),
	@Result(property = "copNo", column = "cop_no"),
	@Result(property = "preNo", column = "pre_no"),
	@Result(property = "rkdNo", column = "rkd_no"),
	@Result(property = "operatorCode", column = "operator_code"),
	@Result(property = "operatorName", column = "operator_name"),
	@Result(property = "ieFlag", column = "ie_flag"),
	@Result(property = "trafMode", column = "traf_mode"),
	@Result(property = "trafNo", column = "traf_no"),
	@Result(property = "voyageNo", column = "voyage_no"),
	@Result(property = "billNo", column = "bill_no"),
	@Result(property = "logisticsCode", column = "logistics_code"),
	@Result(property = "logisticsName", column = "logistics_name"),
	@Result(property = "unloadLocation", column = "unload_location"),
	@Result(property = "note", column = "note"),
	@Result(property = "delFlag", column = "del_flag", jdbcType = JdbcType.INTEGER),
	@Result(property = "msgGuid", column = "msg_guid"),
	@Result(property = "sysDays", column = "sys_days", jdbcType = JdbcType.INTEGER),
	@Result(property = "sysDate", column = "sys_date", jdbcType = JdbcType.TIMESTAMP),
})
@SelectProvider(type = DeliveryHeadSqlProvide.class, method = "getDeliveryHeadListSql")
List<DeliveryHead> getDeliveryHeadList(DeliveryHead deliveryHead);

Source File: ClassificationMapper.java From taskana with Apache License 2.0

5 votes

@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);

Source File: ClassificationMapper.java From taskana with Apache License 2.0

5 votes

@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 KEY = #{key}"
        + "AND DOMAIN = #{domain}"
        + "<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 findByKeyAndDomain(@Param("key") String key, @Param("domain") String domain);

Source File: InvtCancelMapper.java From maintain with MIT License

5 votes

@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);

Source File: ObjectReferenceMapper.java From taskana with Apache License 2.0

5 votes

@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);

Source File: TaxHeadMapper.java From maintain with MIT License

5 votes

@Results(id = "taxHeadResult", value = {
	@Result(property = "headGuid", column = "head_guid"),
	@Result(property = "returnTime", column = "return_time"),
	@Result(property = "customsCode", column = "customs_code"),
	@Result(property = "invtNo", column = "invt_no"),
	@Result(property = "orderNo", column = "order_no"),
	@Result(property = "logisticsNo", column = "logistics_no"),
	@Result(property = "taxNo", column = "tax_no"),
	@Result(property = "taxTotal", column = "tax_total"),
	@Result(property = "customsTax", column = "customs_tax"),
	@Result(property = "valueAddedTax", column = "value_added_tax"),
	@Result(property = "consumptionTax", column = "consumption_tax"),
	@Result(property = "status", column = "status"),
	@Result(property = "entDutyNo", column = "ent_duty_no"),
	@Result(property = "note", column = "note"),
	@Result(property = "idNumber", column = "id_number"),
	@Result(property = "assureCode", column = "assure_code"),
	@Result(property = "assureName", column = "company_name"),
	@Result(property = "ebcCode", column = "ebc_code"),
	@Result(property = "ebcName", column = "ebc_name"),
	@Result(property = "logisticsCode", column = "logistics_code"),
	@Result(property = "logisticsName", column = "logistics_name"),
	@Result(property = "delFlag", column = "del_flag"),
	@Result(property = "msgGuid", column = "msg_guid"),
	@Result(property = "sysDays", column = "sys_days"),
	@Result(property = "sysDate", column = "sys_date"),
	@Result(property = "agentCode", column = "agent_code"),
	@Result(property = "agentName", column = "agent_name"),
})
@SelectProvider(type = TaxHeadSqlProvide.class, method = "getTaxHeadListSql")
List<TaxHead> getTaxHeadList(TaxHead taxHead);

org.apache.ibatis.annotations.Result Java Examples