# MediaOrderSQLQueryBuilder.java

    /*
     * Copyright (C) 2000 - 2024 Silverpeas
     *
     * This program is free software: you can redistribute it and/or modify
     * it under the terms of the GNU Affero General Public License as
     * published by the Free Software Foundation, either version 3 of the
     * License, or (at your option) any later version.
     *
     * As a special exception to the terms and conditions of version 3.0 of
     * the GPL, you may redistribute this Program in connection with Free/Libre
     * Open Source Software ("FLOSS") applications as described in Silverpeas's
     * FLOSS exception. You should have received a copy of the text describing
     * the FLOSS exception, and it is also available here:
     * "http://www.silverpeas.org/docs/core/legal/floss_exception.html"
     *
     * This program is distributed in the hope that it will be useful,
     * but WITHOUT ANY WARRANTY; without even the implied warranty of
     * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
     * GNU Affero General Public License for more details.
     *
     * You should have received a copy of the GNU Affero General Public License
     * along with this program. If not, see <https://www.gnu.org/licenses/>.
     */
    package org.silverpeas.components.gallery.dao;

    import org.silverpeas.components.gallery.model.MediaOrderCriteriaProcessor;
    import org.silverpeas.components.gallery.model.Order;
    import org.apache.commons.lang3.time.DateUtils;
    import org.silverpeas.core.persistence.jdbc.sql.JdbcSqlQuery;

    import java.util.ArrayList;
    import java.util.Date;
    import java.util.List;

    /**
     * A dynamic builder of a SQL query.
     */
    public class MediaOrderSQLQueryBuilder implements MediaOrderCriteriaProcessor {

      private boolean done = false;
      private final StringBuilder sqlQuery = new StringBuilder();
      private final StringBuilder from = new StringBuilder();
      private final StringBuilder where = new StringBuilder();
      private final List<Object> parameters = new ArrayList<>();
      private String conjunction = "";

      @Override
      public void startProcessing() {
        sqlQuery
            .append("select O.orderId, O.userId, O.instanceId, O.createDate, O.processDate, O.processUser ");
        from.append("from SC_Gallery_Order O ");
      }

      @Override
      public void endProcessing() {
        sqlQuery.append(from);
        if (where.length() > 0) {
          sqlQuery.append(" where ").append(where);
        }
        done = true;
      }

      @SuppressWarnings("unchecked")
      @Override
      public JdbcSqlQuery result() {
        return JdbcSqlQuery.create(sqlQuery.toString(), parameters);
      }

      @Override
      public MediaOrderCriteriaProcessor then() {
        if (!done) {
          conjunction = " and ";
        }
        return this;
      }

      @Override
      public MediaOrderCriteriaProcessor processComponentInstance(String componentInstanceId) {
        if (!done) {
          where(conjunction).append("O.instanceId = ?");
          parameters.add(componentInstanceId);
          conjunction = "";
        }
        return this;
      }

      @Override
      public MediaOrderCriteriaProcessor processOrderer(String ordererId) {
        if (!done) {
          where(conjunction).append("O.userId = ?");
          parameters.add(ordererId);
          conjunction = "";
        }
        return this;
      }

      @Override
      public MediaOrderCriteriaProcessor processNbDaysAfterThatDeleteAnOrder(final Date referenceDate,
          final int nbDaysAfterThatDeleteAnOrder) {
        if (!done) {
          where(conjunction).append("O.createDate < ?");
          parameters.add(DateUtils.addDays(referenceDate, -nbDaysAfterThatDeleteAnOrder));
          conjunction = "";
        }
        return this;
      }

      @Override
      public MediaOrderCriteriaProcessor processIdentifiers(List<String> identifiers) {
        if (!done) {
          StringBuilder params = new StringBuilder();
          for (String identifier : identifiers) {
            if (params.length() > 0) {
              params.append(",");
            }
            params.append("?");
            parameters.add(identifier);
          }
          where(conjunction).append("O.orderId in (").append(params).append(")");
          conjunction = "";
        }
        return this;
      }

      @Override
      public List<Order> orderingResult(final List<Order> orders) {
        return orders;
      }

      /**
       * Centralization to perform the where clause.
       * @param conjunction the conjunction.
       * @return the builder completed with conjunction.
       */
      private StringBuilder where(String conjunction) {
        if (where.length() > 0) {
          where.append(conjunction);
        }
        return where;
      }
    }