/**
   * 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;
  }