这里隐藏get set方法
public class BatchManagerViewVo implements Serializable{
/**
* @Description: serialVersionUID : TODO
*/
private static final long serialVersionUID = 1L;
private List<ResourcesItemDto> resourceItem;
private List<PriceInfoDto> priceInfo;
/**
* 主键(PM200600001)
*/
@Id
@Column(name = "ID")
private String id;
public List<ResourcesItemDto> getResourceItem() {
return resourceItem;
}
public void setResourceItem(List<ResourcesItemDto> resourceItem) {
this.resourceItem = resourceItem;
}
public List<PriceInfoDto> getPriceInfo() {
return priceInfo;
}
public void setPriceInfo(List<PriceInfoDto> priceInfo) {
this.priceInfo = priceInfo;
}
/**
* 场次名称
*/
@Column(name = "BATCH_NAME")
private String batchName;
/**
* 会员名称
*/
@Column(name = "MEMBER_NAME")
private String memberName;
/**
* 发起竞价的会员代码
*/
@Column(name = "MEMBER_CODE")
private String memberCode;
/**
* 委托状态:0-已生成,1-已发布,2.竞价中 3-已撤消,4--已作废,5-已完成
*/
@Column(name = "BATCH_STATE")
private String batchState;
/**
* 委托申请时间
*/
@Column(name = "BATCH_DATE")
private Date batchDate;
/**
* 结束时间
*/
@Column(name = "END_TIME")
private Date endTime;
/**
* 开始时间
*/
@Column(name = "START_TIME")
private Date startTime;
/**
* 履约保证金是否已经支付 1 - 已经支付 0 - 未支付(只有此状态为1才允许开始拍卖)
*/
@Column(name = "BOND_PAYMENT_STATUS")
private String bondPaymentStatus;
/**
* 结算方式:1-场外结算(默认) 2- 场内结算
*/
@Column(name = "SETTLEMENT_MODE")
private String settlementMode;
/**
* 作废时间
*/
@Column(name = "INVALID_DATE")
private Date invalidDate;
/**
* 审核操作员
*/
@Column(name = "AUDIT_OPERATOR")
private String auditOperator;
/**
* 终止操作员
*/
@Column(name = "STOP_OPERATOR")
private String stopOperator;
/**
* 作废操作员
*/
@Column(name = "INVALID_OPERATOR")
private String invalidOperator;
/**
* 申请操作员
*/
@Column(name = "APPLY_OPERATOR")
private String applyOperator;
/**
* 公告日
*/
@Column(name = "ANNOUNCEMENT_DAY")
private Date announcementDay;
/**
* 竞价日
*/
@Column(name = "BID_DAY")
private Date bidDay;
/**
* 买方保证金
*/
@Column(name = "BUYER_DEPOSIT")
private BigDecimal buyerDeposit;
/**
* 卖家保证金
*/
@Column(name = "SELLER_BOND")
private BigDecimal sellerBond;
/**
* 强制终止理由
*/
@Column(name = "FORCED_TERMINATION_REASON")
private String forcedTerminationReason;
/**
* 终止委托审核理由(待定)
*/
@Column(name = "AUDIT_STOP_REASON")
private String auditStopReason;
/**
* 终止委托审核时间(待定)
*/
@Column(name = "AUDIT_STOP_DATE")
private Date auditStopDate;
/**
* 终止委托申请理由(待定)
*/
@Column(name = "APPLY_STOP_REASON")
private String applyStopReason;
/**
* 终止委托申请时间(待定)
*/
@Column(name = "APPLY_STOP_DATE")
private Date applyStopDate;
/**
* 拒绝审核委托理由(待定)
*/
@Column(name = "REFUSE_AUDIT_REASON")
private String refuseAuditReason;
/**
* 委托审核时间(待定)
*/
@Column(name = "AUDIT_TIME")
private Date auditTime;
/**
* 定向竞价0否1是1
*/
@Column(name = "IS_DIRECTIONAL_BID")
private String isDirectionalBid;
/**
* 定向的原因,当场次定向时必须输入
*/
@Column(name = "DIRECTIONAL_REASON")
private String directionalReason;
/**
* 是否需要发送短信0不发送1发送
*/
@Column(name = "IS_SEND_MESSAGE")
private String isSendMessage;
/**
* 是否显示中标价格
*/
@Column(name = "IS_SHOW_DEAL_PRICE")
private String isShowDealPrice;
/**
* 是否显示定价
*/
@Column(name = "IS_SHOW_ORDER_PRICE")
private String isShowOrderPrice;
/**
* 是否显示中标会员
*/
@Column(name = "IS_SHOW_DEAL_MEMBER")
private String isShowDealMember;
/**
* 最少响应人数
*/
@Column(name = "MINIMUM_RESPONSE")
private String minimumResponse;
/**
* 是否显示成交结果
*/
@Column(name = "ISSHOWDEALRESULT")
private String isshowdealresult;
/**
* 竞价模式:1-公开增价,2自由报价,3-荷式竞价
*/
@Column(name = "BIDDING_TYPE")
private String biddingType;
/**
* 报盘方式:1-单价,2-总价
*/
@Column(name = "OFFER_TYPE")
private String offerType;
/**
* 是否显示起拍价 1显示(默认) 2不显示
*/
@Column(name = "IS_SHOW_STARTING_PIRCE")
private String isShowStartingPirce;
/**
* 域名
*/
@Column(name = "DOAMIN")
private String doamin;
/**
* 协议
*/
@Column(name = "EDITMENT")
private String editment;
}
<select id="findSellerBatchInfo" parameterType="com.ouyeel.chem.bdt.search.BatchManagerSerachModel" resultMap="batchInfoMap">
select
batch.ID,
batch.BATCH_NAME,
batch.BATCH_STATE batch_state,
batch.START_TIME batch_start_time,
batch.END_TIME batch_end_time,
batch.IS_DIRECTIONAL_BID batch_is_direc,
batch.BUYER_DEPOSIT batch_buyer_deposit,
batch.BIDDING_TYPE batch_bidding_type,
batch.OFFER_TYPE batch_offer_type,
batch.BATCH_DATE batch_date,
batch.ANNOUNCEMENT_DAY batch_announ,
batch.BID_DAY batch_bid_day,
price.id price_id,
price.STARTING_PIRCE price_starting_price,
price.BIDDING_GRADIENT price_bidding_gradient,
price.TAX_RATE price_tax_rate,
price.TAX_FREE_PRICE price_tax_free_price,
price.RESERVE_PRICE price_reserve_price,
item.PRODUCT_NAME item_product_name,
item.PRODUCT_NO item_product_no,
item.PACKAGES item_packages,
item.ORIGIN_PLACE item_origin_place,
item.WAREHOUSE_NAME item_warehouse,
item.PIECE_UNIT item_piece_unit,
item.TRADING_WEIGHT item_trading_weight
from bdt_batch batch
left join bdt_resources_item item on item.batch_id = batch.id
left join bdt_price_info price on price.batch_id = batch.id and item.id = price.item_id
where batch.member_code = #{memberCode,jdbcType=VARCHAR}<!-- and batch.id = 'P170508005' -->
<if test="id != null and id != '' ">
and batch.id like '%${id}%'
</if>
<if test="startTime != null and startTime != '' ">
and batch.batch_date >= #{startTime,jdbcType=TIMESTAMP}
</if>
<if test="endTime != null and endTime != '' ">
and batch.batch_date <= #{endTime,jdbcType=TIMESTAMP}
</if>
<if test="batchState != null and batchState != '' ">
and batch.batch_state = #{batchState,jdbcType=VARCHAR}
</if>
<if test="sidx != null and sidx != '' ">
order by batch.${sidx} ${sord}
</if>
<if test="sidx == null or sidx ==''">
order by batch.id desc
</if>
</select>
<resultMap type="com.ouyeel.chem.bdt.entity.vo.BatchManagerViewVo" id="batchInfoMap">
<!-- association字面意思关联,这里只专门做一对一关联; property表示是com.mybatis.bean.StudentTemp中的属性名称;
javaType表示该属性是什么类型对象 -->
<!-- property 表示com.mybatis.bean.Class中的属性; column 表示表中的列名 -->
<id property="id" column="id"/>
<result property="batchName" column="batch_name"/>
<result property="startTime" column="batch_start_time"/>
<result property="endTime" column="batch_end_time"/>
<result property="isDirectionalBid" column="batch_is_direc"/>
<result property="batchState" column="batch_state"/>
<result property="buyerDeposit" column="batch_buyer_deposit"/>
<result property="biddingType" column="batch_bidding_type"/>
<result property="offerType" column="batch_offer_type"/>
<result property="batchDate" column="batch_date"/>
<result property="announcementDay" column="batch_announ"/>
<result property="bidDay" column="batch_bid_day"/>
<!-- property表示集合类型属性名称,ofType表示集合中的对象是什么类型 -->
<collection property="priceInfo" ofType="com.ouyeel.chem.bdt.entity.PriceInfoDto">
<id property="id" column="price_id"/>
<result property="startingPirce" column="price_starting_price"/>
<result property="biddingGradient" column="price_bidding_gradient"/>
<result property="taxRate" column="price_tax_rate"/>
<result property="taxFreePrice" column="price_tax_free_price"/>
<result property="reservePrice" column="price_reserve_price"/>
</collection>
<!-- property表示集合类型属性名称,ofType表示集合中的对象是什么类型 -->
<collection property="resourceItem" ofType="com.ouyeel.chem.bdt.entity.ResourcesItemDto">
<result property="productName" column="item_product_name"/>
<result property="productNo" column="item_product_no"/>
<result property="packages" column="item_packages"/>
<result property="originPlace" column="item_origin_place"/>
<result property="warehouseName" column="item_warehouse"/>
<result property="pieceUnit" column="item_piece_unit"/>
<result property="tradingWeight" column="item_trading_weight"/>
</collection>
</resultMap>