/*
 * Copyright (C) 2000 - 2026 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:
 * "https://www.silverpeas.org/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.mydb.web;

import org.apache.commons.lang3.StringUtils;
import org.silverpeas.components.mydb.model.DataSourceDefinition;
import org.silverpeas.components.mydb.model.DbColumn;
import org.silverpeas.components.mydb.model.DbTable;
import org.silverpeas.components.mydb.model.MyDBConnectionInfo;
import org.silverpeas.components.mydb.model.TableFieldValue;
import org.silverpeas.components.mydb.model.TableRow;
import org.silverpeas.components.mydb.model.predicates.AbstractColumnValuePredicate;
import org.silverpeas.components.mydb.service.MyDBException;
import org.silverpeas.components.mydb.service.MyDBRuntimeException;
import org.silverpeas.core.admin.user.model.SilverpeasRole;
import org.silverpeas.kernel.util.StringUtil;
import org.silverpeas.kernel.logging.SilverLogger;
import org.silverpeas.core.web.http.HttpRequest;
import org.silverpeas.core.web.mvc.controller.ComponentContext;
import org.silverpeas.core.web.mvc.controller.MainSessionController;
import org.silverpeas.core.web.mvc.webcomponent.annotation.Homepage;
import org.silverpeas.core.web.mvc.webcomponent.annotation.LowestRoleAccess;
import org.silverpeas.core.web.mvc.webcomponent.annotation.RedirectTo;
import org.silverpeas.core.web.mvc.webcomponent.annotation.RedirectToInternal;
import org.silverpeas.core.web.mvc.webcomponent.annotation.RedirectToInternalJsp;
import org.silverpeas.core.web.mvc.webcomponent.annotation.WebComponentController;

import javax.annotation.Nonnull;
import javax.ws.rs.GET;
import javax.ws.rs.POST;
import javax.ws.rs.Path;
import javax.ws.rs.Produces;
import javax.ws.rs.core.MediaType;
import javax.ws.rs.core.Response;
import java.sql.JDBCType;
import java.util.Collections;
import java.util.Enumeration;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Optional;
import java.util.Set;
import java.util.function.Predicate;
import java.util.stream.Collectors;
import java.util.stream.Stream;

import static org.silverpeas.components.mydb.web.TableRowsFilter.FIELD_NONE;
import static org.silverpeas.kernel.util.StringUtil.defaultStringIfNotDefined;
import static org.silverpeas.core.web.util.viewgenerator.html.arraypanes.ArrayLinesTag.AJAX_EXPORT_PARAMETER_NAME;
import static org.silverpeas.core.web.util.viewgenerator.html.arraypanes.ArrayPane.getOrderByFrom;
import static org.silverpeas.core.web.util.viewgenerator.html.arraypanes.ArrayPane.getPaginationPageFrom;

/**
 * The web controller of the MyDB application. Like all of the web controllers in
 * Silverpeas, it is both session-scoped and spawn per application instance.
 * @author mmoquillon
 */
@SuppressWarnings({"CdiManagedBeanInconsistencyInspection", "VoidMethodAnnotatedWithGET"})
@WebComponentController("myDB")
public class MyDBWebController
    extends org.silverpeas.core.web.mvc.webcomponent.WebComponentController<MyDBWebRequestContext> {
  private static final long serialVersionUID = -4225125383775847790L;

  private static final String TRANSLATIONS_PATH = "org.silverpeas.mydb.multilang.mydb";
  private static final String ICONS_PATH = "org.silverpeas.mydb.settings.mydbIcons";

  public static final String MAIN_ARRAY_PANE_NAME = "mainArrayPaneName";
  public static final String FK_ARRAY_PANE_NAME = "fkArrayPaneName";
  public static final String FK_SELECTED = "fkSelectedRow";
  public static final String TABLE_VIEW = "tableView";
  public static final String USE_LAST_LOADED_ROWS = "useLastLoadedRows";
  public static final String ALL_TABLES = "tableNames";
  public static final String COMPARING_COLUMN = "comparingColumn";
  public static final String COMPARING_OPERATOR = "currentComparator";
  public static final String COMPARING_VALUE = "columnValue";
  public static final String COMPARING_OPERATORS = "comparators";
  public static final String ALL_COLUMNS = "tableColumns";
  public static final String UI_ROW_ID = "uiRowId";
  public static final String ROW = "row";
  public static final String ERROR_MESSAGE = "error";
  private static final String ERROR_NO_SELECTED_TABLE = "mydb.error.noSelectedTable";
  private static final String ERROR_INVALID_ROW_KEY = "mydb.error.invalidRow";

  private MyDBConnectionInfo connectionInfo;
  private transient TableView tableView;
  private String mainArrayPaneName;

  /**
   * Constructs a new Web controller for the specified context and with the
   * {@link MainSessionController} instance that is specific to the user behind the access to the
   * underlying application instance.
   * @param controller the main session controller for the current user.
   * @param context the context identifying among others the targeted application instance.
   */
  public MyDBWebController(final MainSessionController controller, final ComponentContext context) {
    super(controller, context, TRANSLATIONS_PATH, ICONS_PATH);
  }

  @Override
  protected void onInstantiation(final MyDBWebRequestContext context) {
    tableView = new TableView(getMultilang());
    final String instanceId = context.getComponentInstanceId();
    mainArrayPaneName = "Table" + instanceId;
    final List<MyDBConnectionInfo> availableConnectionInfo =
        MyDBConnectionInfo.getFromComponentInstance(instanceId);
    if (availableConnectionInfo.isEmpty()) {
      this.connectionInfo = new MyDBConnectionInfo("", instanceId).withDefaultTableName("");
    } else {
      if (availableConnectionInfo.size() > 1) {
        throw new MyDBRuntimeException(
            "There is more than one defined data source for MyDB " + instanceId + ": " +
                availableConnectionInfo.size() + " data sources found!");
      }
      this.connectionInfo = availableConnectionInfo.get(0);
    }
  }

  @GET
  @Path("Main")
  @Homepage
  @RedirectToInternal("{nextView}")
  @LowestRoleAccess(value = SilverpeasRole.READER)
  public void home(final MyDBWebRequestContext context) {
    String nextView = "ConnectionSetting";
    if (this.connectionInfo.isDefined()) {
      if (connectionInfoIsValid(context)) {
        nextView = "ViewTable";
      } else if (!context.getHighestUserRole().isGreaterThanOrEquals(SilverpeasRole.ADMIN)) {
        nextView = "Error";
        context.getRequest().setAttribute("errorMessageKey", "mydb.error.dataSource");
      }
    }
    context.addRedirectVariable("nextView", nextView);
  }

  @GET
  @Path("Error")
  @RedirectToInternalJsp("error.jsp")
  @LowestRoleAccess(value = SilverpeasRole.READER)
  public void error(final MyDBWebRequestContext context) {
    // nothing to do. Just redirect to the JSP
  }

  @GET
  @Path("ViewTable")
  @RedirectToInternalJsp("mydb.jsp")
  @LowestRoleAccess(value = SilverpeasRole.READER)
  public void viewTableContent(final MyDBWebRequestContext context) {
    try {
      if (!tableView.isDefined() && connectionInfo.isDefaultTableNameDefined()) {
        tableView.setTable(DbTable.defaultTable(connectionInfo).orElse(null));
      }
      final HttpRequest request = context.getRequest();
      if (context.getRequest().getParameterAsBoolean(AJAX_EXPORT_PARAMETER_NAME)) {
        tableView.setPagination(null);
      } else {
        tableView.setPagination(getPaginationPageFrom(request, getSessionTableViewId()));
      }
      tableView.setOrderBy(getOrderByFrom(request, tableView.getOrderBies(), getSessionTableViewId()));
      setUpRequestAttributes(request);
    } catch (MyDBRuntimeException e) {
      context.getMyDBMessageManager().setError(getString("mydb.error.table.read"), e);
    }
  }

  @GET
  @Path("NewRow")
  @RedirectToInternalJsp("rowForm.jsp")
  @LowestRoleAccess(value = SilverpeasRole.PUBLISHER)
  public void getNewTableRowForm(final MyDBWebRequestContext context) {
    if (tableView.isDefined()) {
      context.getRequest().setAttribute(ALL_COLUMNS, tableView.getColumns());
    } else {
      context.getRequest()
          .setAttribute(ERROR_MESSAGE, getMultilang().getString(ERROR_NO_SELECTED_TABLE));
    }
  }

  @GET
  @Path("GetRow")
  @RedirectToInternalJsp("rowForm.jsp")
  @LowestRoleAccess(value = SilverpeasRole.PUBLISHER)
  public void getTableRowForm(final MyDBWebRequestContext context) {
    try {
      if (tableView.isDefined()) {
        final String aimedUiRowId = context.getRequest().getParameter(UI_ROW_ID);
        final Optional<TableRowUIEntity> row = tableView.getLastRows().stream()
            .filter(r -> r.getId().equals(aimedUiRowId)).findFirst();
        if (row.isEmpty()) {
          context.getMessager().addError(getMultilang().getString(ERROR_INVALID_ROW_KEY));
          context.getResponse().setStatus(Response.Status.BAD_REQUEST.getStatusCode());
        } else {
          context.getRequest().setAttribute(ROW, row.get());
          context.getRequest().setAttribute(ALL_COLUMNS, tableView.getColumns());
        }
      } else {
        context.getRequest()
            .setAttribute(ERROR_MESSAGE, getMultilang().getString(ERROR_NO_SELECTED_TABLE));
      }
    } catch (Exception e) {
      context.getRequest().setAttribute(ERROR_MESSAGE, e.getLocalizedMessage());
    }
  }

  @GET
  @Path("ViewTargetTable")
  @RedirectToInternalJsp("fkTable.jsp")
  @LowestRoleAccess(value = SilverpeasRole.PUBLISHER)
  public void getForeignKeyTableViewFrom(final MyDBWebRequestContext context) {
    try {
      final String targetTableName = context.getRequest().getParameter(TABLE_VIEW);
      final String selectedRow = context.getRequest().getParameter(FK_SELECTED);
      final Map<String, String> fields = parseForeignKeyRow(selectedRow);
      final Optional<DbTable> targetTable = DbTable.table(targetTableName, connectionInfo);
      if (targetTable.isPresent()) {
        final TableView targetTableView = new TableView(getMultilang());
        targetTableView.setTable(targetTable.orElse(null));
        final HttpRequest request = context.getRequest();
        final String fkArrayPaneName = "FkTable@" + targetTableName;
        targetTableView.setPagination(getPaginationPageFrom(request, fkArrayPaneName));
        targetTableView.setOrderBy(getOrderByFrom(request, targetTableView.getOrderBies(), fkArrayPaneName));
        request.setAttribute(TABLE_VIEW, targetTableView);
        request.setAttribute(FK_ARRAY_PANE_NAME, fkArrayPaneName);
        TableRowUIEntity row = findMatchingTableRow(targetTableView, fields);
        request.setAttribute(FK_SELECTED, row != null ? row.getPkValue() : "");
      } else {
        context.getRequest()
            .setAttribute(ERROR_MESSAGE, getMultilang().getString("mydb.error.nonExistingTable"));
      }
    } catch (Exception e) {
      context.getRequest().setAttribute(ERROR_MESSAGE, e.getLocalizedMessage());
    }
  }

  private TableRowUIEntity findMatchingTableRow(final TableView table,
      final Map<String, String> fields) {
    final Predicate<TableRowUIEntity> rowMatcher = row -> {
      Set<Map.Entry<String, TableFieldValue>> rowFields = row.getData().getFields().entrySet();
      return fields.entrySet()
          .stream()
          .allMatch(f -> rowFields.stream()
              .anyMatch(r -> r.getKey().equals(f.getKey()) &&
                  r.getValue().toString().equals(f.getValue())));
    };

    return table.getRows()
        .stream()
        .filter(rowMatcher)
        .findFirst()
        .orElse(null);
  }

  @Nonnull
  private Map<String, String> parseForeignKeyRow(final String row) {
    if (StringUtil.isNotDefined(row)) {
      return Collections.emptyMap();
    }
    return Stream.of(row.split(";"))
        .map(s -> s.split(":"))
        .collect(Collectors.toMap(f -> f[0], f -> f.length == 2 ? f[1] : "null"));
  }

  @POST
  @Path("AddRow")
  @RedirectToInternalJsp("mydb.jsp")
  @LowestRoleAccess(value = SilverpeasRole.PUBLISHER)
  public void addNewTableRow(final MyDBWebRequestContext context) {
    final HttpRequest request = context.getRequest();
    try {
      if (tableView.isDefined()) {
        final Enumeration<String> params = request.getParameterNames();
        final Map<String, TableFieldValue> tuples = new HashMap<>();
        while (params.hasMoreElements()) {
          final String paramName = params.nextElement();
          final Optional<DbColumn> column = tableView.getColumn(paramName);
          column.ifPresent(c -> {
            final String paramValue = request.getParameter(paramName);
            if (paramValue == null || (paramValue.isEmpty() && !c.isOfTypeText())) {
              throwInvalidValueType(paramName, c.getType());
            }
            final TableFieldValue value = TableFieldValue.fromString(paramValue, c.getType());
            tuples.put(paramName, value);
          });
        }
        if (!tuples.isEmpty()) {
          tableView.addRow(new TableRow(tuples));
          context.getMessager().addSuccess(getMultilang().getString("mydb.add.success"));
        } else {
          context.getMessager().addError(getMultilang().getString(ERROR_INVALID_ROW_KEY));
          context.getResponse().setStatus(Response.Status.BAD_REQUEST.getStatusCode());
        }
      } else {
        context.getMessager().addError(getMultilang().getString(ERROR_NO_SELECTED_TABLE));
        context.getResponse().setStatus(Response.Status.BAD_REQUEST.getStatusCode());
      }
    } catch (IllegalArgumentException | MyDBRuntimeException e) {
      context.getMessager().addError(e.getLocalizedMessage());
      context.getResponse().setStatus(Response.Status.INTERNAL_SERVER_ERROR.getStatusCode());
      request.setAttribute(USE_LAST_LOADED_ROWS, true);
    }
    setUpRequestAttributes(request);
  }

  @POST
  @Path("UpdateRow")
  @RedirectToInternalJsp("mydb.jsp")
  @LowestRoleAccess(value = SilverpeasRole.PUBLISHER)
  public void updateTableRow(final MyDBWebRequestContext context) {
    final HttpRequest request = context.getRequest();
    try {
      if (tableView.isDefined()) {
        final String aimedUiRowId = request.getParameter(UI_ROW_ID);
        final Optional<TableRowUIEntity> row = tableView.getLastRows().stream()
            .filter(r -> r.getId().equals(aimedUiRowId)).findFirst();
        if (row.isEmpty()) {
          context.getMessager().addError(getMultilang().getString(ERROR_INVALID_ROW_KEY));
          context.getResponse().setStatus(Response.Status.BAD_REQUEST.getStatusCode());
        } else {
          final TableRow rowCopy = row.get().getData().getCopy();
          final Enumeration<String> params = request.getParameterNames();
          updateValues(request, rowCopy, params);
          if (tableView.updateRow(aimedUiRowId, rowCopy) > 0) {
            context.getMessager().addSuccess(getMultilang().getString("mydb.update.success"));
          } else {
            context.getMessager().addError(getMultilang().getString("mydb.update.none"));
          }
        }
      } else {
        context.getMessager().addError(getMultilang().getString(ERROR_NO_SELECTED_TABLE));
        context.getResponse().setStatus(Response.Status.BAD_REQUEST.getStatusCode());
      }
    } catch (IllegalArgumentException | MyDBRuntimeException e) {
      context.getMessager().addError(e.getLocalizedMessage());
      context.getResponse().setStatus(Response.Status.INTERNAL_SERVER_ERROR.getStatusCode());
      request.setAttribute(USE_LAST_LOADED_ROWS, true);
    }
    setUpRequestAttributes(request);
  }

  private void updateValues(final HttpRequest request, final TableRow row,
      final Enumeration<String> params) {
    while (params.hasMoreElements()) {
      final String paramName = params.nextElement();
      if (!paramName.equals(UI_ROW_ID)) {
        final TableFieldValue fieldValue = row.getFieldValue(paramName);
        final String newValue = request.getParameter(paramName);
        updateValue(paramName, fieldValue, newValue);
      }
    }
  }

  private void updateValue(final String name, final TableFieldValue value, final String newValue) {
    String newVal = newValue;
    if (AbstractColumnValuePredicate.EMPTY_VALUE.equals(newVal)) {
      newVal = "";
    }
    if (value != null && !value.toString().equals(newVal)) {
      if (newVal == null || (newVal.isEmpty() && !value.isText())) {
        throwInvalidValueType(name, value.getType());
      }
      value.update(newVal);
    }
  }

  @POST
  @Path("DeleteRow")
  @RedirectToInternalJsp("mydb.jsp")
  @LowestRoleAccess(value = SilverpeasRole.PUBLISHER)
  public void deleteTableRow(final MyDBWebRequestContext context) {
    final HttpRequest request = context.getRequest();
    try {
      if (tableView.isDefined()) {
        final String aimedUiRowId = request.getParameter(UI_ROW_ID);
        final Optional<TableRowUIEntity> row = tableView.getLastRows().stream()
            .filter(r -> r.getId().equals(aimedUiRowId)).findFirst();
        if (row.isEmpty()) {
          context.getMessager().addError(getMultilang().getString(ERROR_INVALID_ROW_KEY));
          context.getResponse().setStatus(Response.Status.BAD_REQUEST.getStatusCode());
        } else {
          if (tableView.deleteRow(aimedUiRowId) > 0) {
            context.getMessager().addSuccess(getMultilang().getString("mydb.delete.success"));
          } else {
            context.getMessager().addError(getMultilang().getString("mydb.delete.none"));
          }
        }
      } else {
        context.getMessager().addError(getMultilang().getString(ERROR_NO_SELECTED_TABLE));
        context.getResponse().setStatus(Response.Status.BAD_REQUEST.getStatusCode());
      }
    } catch (MyDBRuntimeException e) {
      context.getMessager().addError(e.getLocalizedMessage());
      context.getResponse().setStatus(Response.Status.INTERNAL_SERVER_ERROR.getStatusCode());
      request.setAttribute(USE_LAST_LOADED_ROWS, true);
    }
    setUpRequestAttributes(request);
  }

  @POST
  @Path("SetTable")
  @Produces(MediaType.APPLICATION_JSON)
  @LowestRoleAccess(value = SilverpeasRole.READER)
  public void selectTable(final MyDBWebRequestContext context) {
    HttpRequest request = context.getRequest();
    final String tableName = request.getParameter(TABLE_VIEW);
    if (StringUtil.isDefined(tableName) &&
        !tableName.equals(connectionInfo.getDefaultTableName())) {
      connectionInfo.setDefaultTableName(tableName);
      connectionInfo.save();
      clearTableView();
    }
  }

  @POST
  @Path("FilterTable")
  @RedirectToInternalJsp("mydb.jsp")
  @LowestRoleAccess(value = SilverpeasRole.READER)
  public void filterTableContent(final MyDBWebRequestContext context) {
    try {
      if (connectionInfo.isDefined()) {
        readRequestParameters(context.getRequest());
      }
      setUpRequestAttributes(context.getRequest());
    } catch(MyDBRuntimeException e) {
      context.getMessager().addError(e.getLocalizedMessage());
    }
  }

  @GET
  @Path("ConnectionSetting")
  @RedirectToInternalJsp("connectionSettings.jsp")
  @LowestRoleAccess(value = SilverpeasRole.ADMIN, onError = @RedirectTo("Main"))
  public void editConnection(final MyDBWebRequestContext context) {
    context.getRequest().setAttribute("currentConnectionInfo", connectionInfo);
    context.getRequest().setAttribute("availableDataSources", DataSourceDefinition.getAll());
  }

  @POST
  @Path("UpdateConnection")
  @RedirectToInternal("{nextView}")
  @LowestRoleAccess(value = SilverpeasRole.PUBLISHER, onError = @RedirectTo("Main"))
  public void saveConnection(final MyDBWebRequestContext context) {
    String dataSource = context.getRequest().getParameter("DataSource");
    String login = context.getRequest().getParameter("Login");
    String password = context.getRequest().getParameter("Password");
    int rowLimit = 0;
    if (context.getRequest().isParameterDefined("RowLimit")) {
      rowLimit = context.getRequest().getParameterAsInteger("RowLimit");
    }
    connectionInfo = connectionInfo.withDataSourceName(dataSource)
        .withLoginAndPassword(login, password)
        .withDataMaxNumber(rowLimit)
        .withoutAnyDefaultTable();
    final String nextView;
    // we check the connection: it is saved only if the connection with the data source can be
    // established. In that case, the current table view is cleared.
    if (connectionInfoIsValid(context)) {
      connectionInfo.save();
      clearTableView();
      nextView = "ViewTable";
    } else {
      nextView = "ConnectionSetting";
    }
    context.addRedirectVariable("nextView", nextView);
  }

  private boolean connectionInfoIsValid(final MyDBWebRequestContext context) {
    try {
      connectionInfo.checkConnection();
      return true;
    } catch (MyDBException e) {
      context.getMyDBMessageManager().setError(getString("mydb.error.invalidConnectionSettings"));
      SilverLogger.getLogger(this).error(e);
      return false;
    }
  }

  private void readRequestParameters(final HttpRequest request) {
    if (request.isParameterNotNull(COMPARING_COLUMN) &&
        request.isParameterNotNull(COMPARING_OPERATOR)) {
      final String fieldName = defaultStringIfNotDefined(request.getParameter(COMPARING_COLUMN),
          FIELD_NONE);
      final String comparator =
          defaultStringIfNotDefined(request.getParameter(COMPARING_OPERATOR), FIELD_NONE);
      final String value =
          defaultValueIfNotDefined(request.getParameter(COMPARING_VALUE));
      if (FIELD_NONE.equals(fieldName) || FIELD_NONE.equals(comparator) ||
          FIELD_NONE.equals(value)) {
        tableView.getFilter().clear();
      } else {
        tableView.filterOnColumn(fieldName);
        tableView.getFilter().setComparator(comparator);
        tableView.getFilter().setColumnValue(value);
      }
    }
  }

  private void clearTableView() {
    tableView.clear();
  }

  private void setUpRequestAttributes(final HttpRequest request) {
    final List<String> tableNames;
    if (connectionInfo.isDefined()) {
      tableNames = DbTable.list(connectionInfo);
    } else {
      tableNames = Collections.emptyList();
    }
    request.setAttribute(MAIN_ARRAY_PANE_NAME, getSessionTableViewId());
    request.setAttribute(TABLE_VIEW, tableView);
    request.setAttribute(ALL_TABLES, tableNames);
    request.setAttribute(COMPARING_COLUMN, tableView.getFilter()
        .getColumn()
        .map(DbColumn::getName).orElse(FIELD_NONE));
    request.setAttribute(COMPARING_OPERATOR, tableView.getFilter().getComparator());
    request.setAttribute(COMPARING_VALUE, tableView.getFilter().getColumnValue());
    request.setAttribute(COMPARING_OPERATORS, TableRowsFilter.getAllComparators());
  }

  private String getSessionTableViewId() {
    return this.mainArrayPaneName + tableView.getName();
  }

  private void throwInvalidValueType(final String name, final int expectedType) {
    throw new IllegalArgumentException(getMultilang().getString("mydb.error.invalidValue") + ". " +
        name + ": " + JDBCType.valueOf(expectedType).getName());
  }

  private static String defaultValueIfNotDefined(final String value) {
    String val = value;
    if (val == null || val.isEmpty()) {
      val = null;
    }
    return StringUtils.defaultString(val, TableRowsFilter.FIELD_NONE);
  }
}
