/**
* This method was generated by MyBatis Generator. This method corresponds to the database table
* `trade_move_check`
*
* @mbggenerated
*/
public String selectByExample(TradeMoveCheckExample example) {
SQL sql = new SQL();
if (example != null && example.isDistinct()) {
sql.SELECT_DISTINCT("id");
} else {
sql.SELECT("id");
}
sql.SELECT("order_id");
sql.SELECT("order_sn");
sql.SELECT("order_no");
sql.SELECT("is_move_success");
sql.SELECT("is_in_info");
sql.SELECT("info_flag");
sql.SELECT("info_desc");
sql.SELECT("create_time");
sql.SELECT("update_time");
sql.FROM("`trade_move_check`");
applyWhere(sql, example, false);
if (example != null && example.getOrderByClause() != null) {
sql.ORDER_BY(example.getOrderByClause());
}
String sqlStr = sql.toString();
if (example.getPage() != null) {
sqlStr =
sqlStr
+ " limit "
+ example.getPage().getOffset()
+ ","
+ example.getPage().getLimit()
+ "";
}
return sqlStr;
}
/**
* This method was generated by MyBatis Generator. This method corresponds to the database table
* `orderguidereward`
*
* @mbggenerated
*/
public String selectByExample(FinalOrderGuideRewardCriteria example) {
SQL sql = new SQL();
if (example != null && example.isDistinct()) {
sql.SELECT_DISTINCT("orderGuideRewardId");
} else {
sql.SELECT("orderGuideRewardId");
}
sql.SELECT("orderId");
sql.SELECT("guideId");
sql.SELECT("orderRewardType");
sql.SELECT("comment");
sql.SELECT("reward");
sql.SELECT("status");
sql.SELECT("updated_at");
sql.SELECT("created_at");
sql.FROM("`orderguidereward`");
applyWhere(sql, example, false);
if (example != null && example.getOrderByClause() != null) {
sql.ORDER_BY(example.getOrderByClause());
}
String sqlStr = sql.toString();
if (example.getPage() != null) {
sqlStr =
sqlStr
+ " limit "
+ example.getPage().getOffset()
+ ","
+ example.getPage().getLimit()
+ "";
}
return sqlStr;
}
/**
* This method was generated by MyBatis Generator. This method corresponds to the database table
* `trade_move_check`
*
* @mbggenerated
*/
public String countByExample(TradeMoveCheckExample example) {
SQL sql = new SQL();
sql.SELECT("count(*)").FROM("`trade_move_check`");
applyWhere(sql, example, false);
return sql.toString();
}
private SQL startQuery() {
SQL sql = new SQL();
return sql.SELECT("DISTINCT r.resource_id, r.repository_id, r.id, r.uri").FROM("resource r");
}
/**
* This method was generated by MyBatis Generator. This method corresponds to the database table
* `agentaccountlog`
*
* @mbggenerated
*/
public String countByExample(FinalAgentaccountLogCriteria example) {
SQL sql = new SQL();
sql.SELECT("count(*)").FROM("`agentaccountlog`");
applyWhere(sql, example, false);
return sql.toString();
}
/**
* This method was generated by MyBatis Generator. This method corresponds to the database table
* `agentaccountlog`
*
* @mbggenerated
*/
public String selectByExample(FinalAgentaccountLogCriteria example) {
SQL sql = new SQL();
if (example != null && example.isDistinct()) {
sql.SELECT_DISTINCT("agentAccountLogId");
} else {
sql.SELECT("agentAccountLogId");
}
sql.SELECT("agentId");
sql.SELECT("agentUserId");
sql.SELECT("agentUserName");
sql.SELECT("orderId");
sql.SELECT("type");
sql.SELECT("bizType");
sql.SELECT("price");
sql.SELECT("content");
sql.SELECT("comment");
sql.SELECT("tips");
sql.SELECT("bizStatus");
sql.SELECT("payType");
sql.SELECT("bizComment");
sql.SELECT("updated_at");
sql.SELECT("created_at");
sql.FROM("`agentaccountlog`");
applyWhere(sql, example, false);
if (example != null && example.getOrderByClause() != null) {
sql.ORDER_BY(example.getOrderByClause());
}
String sqlStr = sql.toString();
if (example.getPage() != null) {
sqlStr =
sqlStr
+ " limit "
+ example.getPage().getOffset()
+ ","
+ example.getPage().getLimit()
+ "";
}
return sqlStr;
}
/**
* This method was generated by MyBatis Generator. This method corresponds to the database table
* `orderguidereward`
*
* @mbggenerated
*/
public String countByExample(FinalOrderGuideRewardCriteria example) {
SQL sql = new SQL();
sql.SELECT("count(*)").FROM("`orderguidereward`");
applyWhere(sql, example, false);
return sql.toString();
}