org.apache.ibatis.annotations.Result Java Examples

The following examples show how to use org.apache.ibatis.annotations.Result. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example #1

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

Example #2

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

Example #3

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

Example #4

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

Example #5

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

Example #6

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

Example #7

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

Example #8

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

Example #9

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

Example #10

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

Example #11

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

Example #12

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

Example #13

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

Example #14

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

Example #15

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

Example #16

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

Example #17

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

Example #18

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

Example #19

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

Example #20

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

Example #21

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

Example #22

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

Example #23

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

Example #24

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

Example #25

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

Example #26

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

Example #27

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

Example #28

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

Example #29

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

Example #30

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