org.apache.ibatis.annotations.SelectProvider Java Examples

The following examples show how to use org.apache.ibatis.annotations.SelectProvider. 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: ImpInvtHeadMapper.java    From maintain with MIT License 5 votes vote down vote up
@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);
 
Example #2
Source File: InvtCancelMapper.java    From maintain with MIT License 5 votes vote down vote up
@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 #3
Source File: PayHeadMapper.java    From maintain with MIT License 5 votes vote down vote up
@Results(id = "payHeadResult", 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 = "payCode", column = "pay_code"),
	@Result(property = "payName", column = "pay_name"),
	@Result(property = "payTransactionId", column = "pay_transaction_id"),
	@Result(property = "ordNo", column = "ord_no"),
	@Result(property = "ebpCode", column = "ebp_code"),
	@Result(property = "ebpName", column = "ebp_name"),
	@Result(property = "payerIdType", column = "payer_id_type"),
	@Result(property = "payerIdNumber", column = "payer_id_number"),
	@Result(property = "payerName", column = "payer_name"),
	@Result(property = "telephone", column = "telephone"),
	@Result(property = "amountPaid", column = "amount_paid"),
	@Result(property = "currency", column = "currency"),
	@Result(property = "payTime", column = "pay_time"),
	@Result(property = "note", column = "note"),
	@Result(property = "msg_guid", column = "msg_guid"),
	@Result(property = "delFlag", column = "del_flag"),
	@Result(property = "sysDays", column = "sys_days"),
	@Result(property = "sysDate", column = "sys_date"),
})
@SelectProvider(type = PayHeadSqlProvide.class, method = "getPayHeadListSql")
List<PayHead> getPayHeadList(PayHead payHead);
 
Example #4
Source File: InvtHeadStatisticsMapper.java    From maintain with MIT License 5 votes vote down vote up
@Results({
	@Result(property = "name", column = "name"),
	@Result(property = "quantity", column = "quantity"),
	@Result(property = "goodsValue", column = "goods_value")
})
@SelectProvider(type = InvtHeadStatisticsSqlProvide.class, method = "statisticsInvtHeadQuantitySql")
List<InvtHeadStatistics> statisticsInvtHeadQuantity(InvtHeadStatistics invtHeadStatistics);
 
Example #5
Source File: LgsHeadMapper.java    From maintain with MIT License 5 votes vote down vote up
@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);
 
Example #6
Source File: PaymentMessageMapper.java    From maintain with MIT License 5 votes vote down vote up
@Results(id = "paymentMessageResult", value = {
	@Result(property = "id", column = "id", id = true),
	@Result(property = "xmlContent", column = "xml_content"),
	@Result(property = "createdDate", column = "created_date"),
	@Result(property = "dateNum", column = "date_num"),
})
@SelectProvider(type = PaymentMessageSqlProvide.class, method = "getPaymentMessageListSql")
List<PaymentMessage> getPaymentMessageList(PaymentMessage paymentMessage);
 
Example #7
Source File: VersionMapper.java    From maintain with MIT License 5 votes vote down vote up
@Results(id = "versionResult", value = {
	@Result(property = "versionNo", column = "version_no"),
	@Result(property = "baseSystem", column = "base_system"),
	@Result(property = "sendTime", column = "send_time"),
	@Result(property = "isUpdateTest", column = "is_update_test"),
	@Result(property = "updateTestTime", column = "update_test_time"),
	@Result(property = "isUpdateFormal", column = "is_update_formal"),
	@Result(property = "updateFormalTime", column = "update_formal_time"),
	@Result(property = "testResult", column = "test_result"),
	@Result(property = "testTime", column = "test_time"),
	@Result(property = "testResultDescription", column = "test_result_description"),
	@Result(property = "isPatch", column = "is_patch"),
})
@SelectProvider(type = VersionSqlProvide.class, method = "getVersionListSql")
List<Version> getVersionList(Version version);
 
Example #8
Source File: ImpPayHeadMapper.java    From maintain with MIT License 4 votes vote down vote up
@Results(id = "impPayHeadResult", 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 = "payCode", column = "pay_code"),
	@Result(property = "payName", column = "pay_name"),
	@Result(property = "payTransactionId", column = "pay_transaction_id"),
	@Result(property = "orderNo", column = "order_no"),
	@Result(property = "ebpCode", column = "ebp_code"),
	@Result(property = "ebpName", column = "ebp_name"),
	@Result(property = "payerIdType", column = "payer_id_type"),
	@Result(property = "payerIdNumber", column = "payer_id_number"),
	@Result(property = "payerName", column = "payer_name"),
	@Result(property = "telephone", column = "telephone"),
	@Result(property = "amountPaid", column = "amount_paid"),
	@Result(property = "currency", column = "currency"),
	@Result(property = "payTime", column = "pay_time"),
	@Result(property = "note", column = "note"),
	@Result(property = "sysDays", column = "sys_days"),
	@Result(property = "sysDate", column = "sys_date"),
	@Result(property = "returnStatus", column = "return_status"),
	@Result(property = "returnTime", column = "return_time"),
	@Result(property = "returnInfo", column = "return_info"),
	@Result(property = "seqno", column = "seqno"),
	@Result(property = "managercustomscode", column = "managercustomscode"),
	@Result(property = "paymenttype", column = "paymenttype"),
	@Result(property = "customerflag", column = "customerflag"),
	@Result(property = "ietype", column = "ietype"),
	@Result(property = "payecode", column = "payecode"),
	@Result(property = "cbecodeinsp", column = "cbecodeinsp"),
	@Result(property = "coininsp", column = "coininsp"),
	@Result(property = "cbecode", column = "cbecode"),
	@Result(property = "cbename", column = "cbename"),
	@Result(property = "billmode", column = "billmode"),
	@Result(property = "basicid", column = "basicid"),
	@Result(property = "approvaldate", column = "approvaldate"),
	@Result(property = "auditstate", column = "auditstate"),
	@Result(property = "applydate", column = "applydate"),
	@Result(property = "uuid", column = "uuid"),
})
@SelectProvider(type = ImpPayHeadSqlProvide.class, method = "getImpPayHeadListSql")
List<ImpPayHead> getImpPayHeadList(ImpPayHead impPayHead);
 
Example #9
Source File: PersonalInfoMapper.java    From maintain with MIT License 4 votes vote down vote up
@ResultMap("personalInfoResult")
@SelectProvider(type = PersonalInfoSqlProvide.class, method = "getPersonalInfoByNameCertIdSql")
PersonalInfo getPersonalInfoByNameCertId(String name, String certId);
 
Example #10
Source File: UnitMapper.java    From maintain with MIT License 4 votes vote down vote up
@SelectProvider(type = UnitSqlProvide.class, method = "countUnitsSql")
long countUnits();
 
Example #11
Source File: SysPrivilegeMapper.java    From mybatis-action with Apache License 2.0 4 votes vote down vote up
@SelectProvider(type = SysPrivilegeProvider.class, method = "selectById")
SysPrivilege selectById(Long id);
 
Example #12
Source File: MemberMapper.java    From maintain with MIT License 4 votes vote down vote up
@SelectProvider(type = MemberSqlProvide.class, method = "countMemberSql")
long countMember(Member member);
 
Example #13
Source File: ServerSystemMapper.java    From maintain with MIT License 4 votes vote down vote up
@SelectProvider(type = ServerSystemSqlProvide.class, method = "getServerSystemListSql")
List<ServerSystem> getServerSystemList(ServerSystem serverSystem);
 
Example #14
Source File: PersonalInfoMapper.java    From maintain with MIT License 4 votes vote down vote up
@ResultMap("personalInfoResult")
@SelectProvider(type = PersonalInfoSqlProvide.class, method = "statisticsPersonalInfoSql")
List<PersonalInfo> statisticsPersonalInfo(PersonalInfo personalInfo);
 
Example #15
Source File: PersonalInfoMapper.java    From maintain with MIT License 4 votes vote down vote up
@ResultMap("personalInfoResult")
@SelectProvider(type = PersonalInfoSqlProvide.class, method = "getPersonalInfoListSql")
List<PersonalInfo> getPersonalInfoList(PersonalInfo personalInfo);
 
Example #16
Source File: DistBillListMapper.java    From maintain with MIT License 4 votes vote down vote up
@ResultMap("distBillListResult")
@SelectProvider(type = DistBillListSqlProvide.class, method = "getDistBillListListBySearchTextSql")
List<DistBillList> getDistBillListListBySearchText(String seqNo, String searchText);
 
Example #17
Source File: MemberMapper.java    From maintain with MIT License 4 votes vote down vote up
@ResultMap("memberResult")
@SelectProvider(type = MemberSqlProvide.class, method = "getMemberByUserNameSql")
Member getMemberByUserName(String userName);
 
Example #18
Source File: OrderListMapper.java    From maintain with MIT License 4 votes vote down vote up
@ResultType(Long.class)
@SelectProvider(type = OrderListSqlProvide.class, method = "countOrderListSql")
Long countOrderList(String headGuid);
 
Example #19
Source File: TradeMapper.java    From maintain with MIT License 4 votes vote down vote up
@Results(id = "tradeResult", value = {
	@Result(property = "code", column = "trade_mode", id = true),
	@Result(property = "name", column = "abbr_trade")
})
@SelectProvider(type = TradeSqlProvide.class, method = "getTradeByCodeSql")
Para getTradeByCode(String code);
 
Example #20
Source File: MessageMapper.java    From albert with MIT License 4 votes vote down vote up
@SelectProvider(type = MessageSqlProvider.class, method = "getThemeList")
public List<ThemeDTO> getThemeList();
 
Example #21
Source File: ImpInvtHeadMapper.java    From maintain with MIT License 4 votes vote down vote up
@ResultMap(value = "impInvtHeadResult")
@SelectProvider(type = ImpInvtHeadSqlProvide.class, method = "getInvtHeadListByOrderNoLogisticsNoSql")
List<ImpInvtHead> getInvtHeadListByOrderNoLogisticsNo(String ebcCode, String orderNo, String logisticsCode, String logisticsNo);
 
Example #22
Source File: ImpInvtHeadMapper.java    From maintain with MIT License 4 votes vote down vote up
@ResultMap(value = "impInvtHeadResult")
@SelectProvider(type = ImpInvtHeadSqlProvide.class, method = "getInvtHeadListByCopNoSql")
List<ImpInvtHead> getInvtHeadListByCopNo(String copNo);
 
Example #23
Source File: ServerSystemMapper.java    From maintain with MIT License 4 votes vote down vote up
@SelectProvider(type = ServerSystemSqlProvide.class, method = "getServerSystemByIpSql")
ServerSystem getServerSystemByIp(String ip);
 
Example #24
Source File: GoodMapper.java    From maintain with MIT License 4 votes vote down vote up
@Results(id = "goodResult", value = {
	@Result(property = "seqNo", column = "seq_no"),
	@Result(property = "cbeCode", column = "cbe_code"),
	@Result(property = "cbeName", column = "cbe_name"),
	@Result(property = "applyCode", column = "apply_code"),
	@Result(property = "applyName", column = "apply_name"),
	@Result(property = "listNo", column = "list_no"),
	@Result(property = "goodsNo", column = "goods_no"),
	@Result(property = "shelfGoodsName", column = "shelf_goods_name"),
	@Result(property = "describe", column = "describe"),
	@Result(property = "codeTs", column = "code_ts"),
	@Result(property = "goodsName", column = "goods_name"),
	@Result(property = "goodsModel", column = "goods_model"),
	@Result(property = "unit", column = "unit"),
	@Result(property = "currency", column = "currency"),
	@Result(property = "unit1", column = "unit1"),
	@Result(property = "unit2", column = "unit2"),
	@Result(property = "price", column = "price"),
	@Result(property = "priceRmb", column = "price_rmb"),
	@Result(property = "taxCode", column = "tax_code"),
	@Result(property = "ecpCode", column = "ecp_code"),
	@Result(property = "ecpName", column = "ecp_name"),
	@Result(property = "country", column = "country"),
	@Result(property = "image", column = "image"),
	@Result(property = "barCode", column = "bar_code"),
	@Result(property = "limitationGoodsCode", column = "limitation_goods_code"),
	@Result(property = "positionSeq", column = "position_seq"),
	@Result(property = "isTax", column = "is_tax"),
	@Result(property = "isPermit", column = "is_permit"),
	@Result(property = "brands", column = "brands"),
	@Result(property = "superviseId", column = "supervise_id"),
	@Result(property = "itemNo", column = "item_no"),
	@Result(property = "applyUser", column = "apply_user"),
	@Result(property = "status", column = "status"),
	@Result(property = "approveMan", column = "approve_man"),
	@Result(property = "approveTime", column = "approve_time"),
	@Result(property = "approveOpinion", column = "approve_opinion"),
	@Result(property = "decTime", column = "dec_time"),
	@Result(property = "updateTime", column = "update_time"),
	@Result(property = "indbTime", column = "indb_time"),
	@Result(property = "shelfGoodsNameForeign", column = "shelf_goods_name_foreign"),
	@Result(property = "approveType", column = "approve_type"),
	@Result(property = "batchNumbers", column = "batch_numbers"),
	@Result(property = "modifyMark", column = "modify_mark"),
	@Result(property = "isSimple", column = "is_simple"),
})
@SelectProvider(type = GoodSqlProvide.class, method = "getGoodListSql")
List<Good> getGoodList(Good good);
 
Example #25
Source File: CountryMapper.java    From maintain with MIT License 4 votes vote down vote up
@Results(id = "countryResult", value = {
	@Result(property = "code", column = "country_code", id = true),
	@Result(property = "name", column = "coun_c_name")
})
@SelectProvider(type = CountrySqlProvide.class, method = "getCountryByCodeSql")
Para getCountryByCode(String code);
 
Example #26
Source File: PermissionMapper.java    From maintain with MIT License 4 votes vote down vote up
@SelectProvider(type = PermissionSqlProvide.class, method = "getPermissionListByMemberCodeSql")
List<Permission> getPermissionListByMemberCode(String memberCode);
 
Example #27
Source File: UserMapper.java    From SpringbootMybatis with Apache License 2.0 4 votes vote down vote up
@SelectProvider(type=UserSqlProvider.class, method="countByExample")
long countByExample(UserCriteria example);
 
Example #28
Source File: ImportBillInMapper.java    From maintain with MIT License 4 votes vote down vote up
@SelectProvider(type = ImportBillSqlProvide.class, method = "statisticsBillSql")
ImportBill statisticsBill(ImportBill importBill);
 
Example #29
Source File: BaseMapper.java    From jeesuite-libs with Apache License 2.0 4 votes vote down vote up
@SelectProvider(type = CountByExampleProvider.class, method = "countByExample")
@ResultType(Long.class)
long countByExample(T example);
 
Example #30
Source File: GrantCompanyMapper.java    From maintain with MIT License 4 votes vote down vote up
@Results(id = "resultGrantCompany", value = {
	@Result(property = "authorizationToken", column = "authorization_token", id = true),
	@Result(property = "companyCode", column = "company_code")
})
@SelectProvider(type = GrantCompanySqlProvide.class, method = "getGrantCompanyByAuthTokenSql")
GrantCompany getGrantCompanyByAuthToken(String authorizationToken);