package fr.ifremer.quadrige2.ui.swing.common.content.db;
   
   /*-
    * #%L
    * Quadrige2 Core :: Quadrige2 UI Common
    * $Id:$
    * $HeadURL:$
    * %%
    * Copyright (C) 2017 Ifremer
   * %%
   * 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.
   * 
   * 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 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 <http://www.gnu.org/licenses/>.
   * #L%
   */
  
  
  import com.google.common.collect.Maps;
  import fr.ifremer.quadrige2.core.security.Quadrige2UserAuthority;
  import fr.ifremer.quadrige2.core.security.SecurityContextHelper;
  import fr.ifremer.quadrige2.core.service.ClientServiceLocator;
  import fr.ifremer.quadrige2.ui.swing.common.ApplicationUIContext;
  import fr.ifremer.quadrige2.ui.swing.common.ApplicationUIUtil;
  import fr.ifremer.quadrige2.ui.swing.common.callback.DatabaseUpdaterCallBack;
  import fr.ifremer.quadrige2.ui.swing.common.AbstractUIHandler;
  import jaxx.runtime.SwingUtil;
  import org.apache.commons.lang3.StringUtils;
  import org.apache.commons.logging.Log;
  import org.apache.commons.logging.LogFactory;
  import org.nuiton.updater.ApplicationInfo;
  import org.nuiton.updater.ApplicationUpdater;
  import org.nuiton.version.Version;
  
  import javax.swing.SwingUtilities;
  import java.beans.PropertyChangeEvent;
  import java.beans.PropertyChangeListener;
  import java.util.Map;
  
  import static org.nuiton.i18n.I18n.n;
  import static org.nuiton.i18n.I18n.t;
  
  /**
   * <p>DbManagerUIHandler class.</p>
   *
   * @since 1.0
   */
  public class DbManagerUIHandler extends AbstractUIHandler<ApplicationUIContext, DbManagerUI> {
  
      /**
       * Logger.
       */
      private static final Log LOG = LogFactory.getLog(DbManagerUIHandler.class);
  
      /**
       * <p>updateMessage.</p>
       */
      public void updateMessage() {
  
          boolean dbExist = getContext().isDbExist();
          boolean dbLoaded = getContext().isPersistenceLoaded();
  
          if (LOG.isDebugEnabled()) {
              LOG.debug("Rebuild information text... (dbExist?" + dbExist
                  + "/ dbLoaded?" + dbLoaded + ")");
          }
  
          String message;
  
          if (dbExist) {
  
  //            String jdbcUrl = config.getJdbcUrl();
  
              Map<String, String> characteristics = Maps.newLinkedHashMap();
  
              String title;
  
              characteristics.put(t("quadrige2.dbManager.characteristic.url"), getConfig().getJdbcUrl());
  
              if (dbLoaded) {
  
                  Version dbVersion = ClientServiceLocator.instance().getPersistenceService().getDbVersion();
  
                  // db loaded
                  title = n("quadrige2.dbManager.info.db.loaded");
  
                  characteristics.put(t("quadrige2.dbManager.characteristic.schemaVersion"), dbVersion == null ? "not found" : dbVersion.toString());
  
              } else {
  
                  // no db loaded
                 title = n("quadrige2.dbManager.info.no.db.loaded");
             }
 
             // get referential version
             String urlDb = getConfig().getUpdateDataUrl();
             if (getContext().checkUpdateReachable(urlDb, false)) {
 
                 ApplicationUpdater up = new ApplicationUpdater();
                 Map<String, ApplicationInfo> dbVersions = up.getVersions(urlDb, getConfig().getDataDirectory());
 
                 ApplicationInfo updateDbVersion = dbVersions.get(DatabaseUpdaterCallBack.DB_UPDATE_NAME);
 
                 if (updateDbVersion != null) {
                     String currentReferentialVersion = updateDbVersion.oldVersion;
                     String newReferentialVersion = updateDbVersion.newVersion;
                     characteristics.put(t("quadrige2.dbManager.characteristic.referentialVersion"), currentReferentialVersion);
                     if (newReferentialVersion != null) {
                         characteristics.put(t("quadrige2.dbManager.characteristic.lastReferentialVersion"), newReferentialVersion);
                     }
                 } else {
                     characteristics.put(t("quadrige2.dbManager.characteristic.referentialVersion.undefined"), "");
                 }
             }
 
             StringBuilder characteristicsToString = new StringBuilder("<ul>");
             for (Map.Entry<String, String> entry : characteristics.entrySet()) {
                 characteristicsToString.append("<li>");
                 characteristicsToString.append(entry.getKey());
                 characteristicsToString.append(" : <strong>");
                 characteristicsToString.append(entry.getValue());
                 characteristicsToString.append("</strong></li>");
             }
             characteristicsToString.append("</ul>");
 
             message = t(title, characteristicsToString);
 
         } else {
 
             // db does not exist
             message = t("quadrige2.dbManager.info.no.db.exist");
         }
         String result = ApplicationUIUtil.getHtmlString(message);
         getUI().getInformationArea().setText(result);
     }
 
     /** {@inheritDoc} */
     @Override
     public void beforeInit(DbManagerUI ui) {
         super.beforeInit(ui);
         ui.setContextValue(getContext());
 
         ui.setContextValue(SwingUtil.createActionIcon("manage-db"));
 
     }
 
     /** {@inheritDoc} */
     @Override
     public void afterInit(DbManagerUI ui) {
 
         initUI(ui);
         clearValidators();
 
         getModel().addPropertyChangeListener(ApplicationUIContext.PROPERTY_DB_EXIST, new PropertyChangeListener() {
             @Override
             public void propertyChange(PropertyChangeEvent evt) {
 
                 Boolean dbExist = (Boolean) evt.getNewValue();
                 String mnemonic;
                 if (dbExist) {
                     mnemonic = t("quadrige2.dbManager.action.reinstallDb.mnemonic");
                 } else {
                     mnemonic = t("quadrige2.dbManager.action.installDb.mnemonic");
                 }
                 if (StringUtils.isNotBlank(mnemonic)) {
                     getUI().getInstallOrReinstallDbButton().setMnemonic(mnemonic.charAt(0));
                 }
 
             }
         });
 
         updateMessage();
 
         SwingUtilities.invokeLater(
                 new Runnable() {
                     @Override
                     public void run() {
                         getContext().getMainUI().getBody().repaint();
                     }
                 }
         );
 
         // Export all referential to create a install DB : only available for local administrator (see mantis #26694)
         getUI().getExportAllReferentialToFileButton().setEnabled(
                 SecurityContextHelper.hasAuthority(Quadrige2UserAuthority.LOCAL_ADMIN)
         );
     }
 
     /** {@inheritDoc} */
     @Override
     public String getTitle() {
         return t("quadrige2.screen.DbManagerUI.title");
     }
 
     /**
      * <p>getInstallButtonText.</p>
      *
      * @param dbExist a boolean.
      * @return a {@link String} object.
      */
     public String getInstallButtonText(boolean dbExist) {
         String result;
         if (dbExist) {
             result = t("quadrige2.dbManager.action.reinstallDb");
         } else {
             result = t("quadrige2.dbManager.action.installDb");
         }
         return result;
     }
 
     /**
      * <p>getInstallButtonTip.</p>
      *
      * @param dbExist a boolean.
      * @return a {@link String} object.
      */
     public String getInstallButtonTip(boolean dbExist) {
         String result;
         if (dbExist) {
             result = t("quadrige2.dbManager.action.reinstallDb.tip");
         } else {
             result = t("quadrige2.dbManager.action.installDb.tip");
         }
         return result;
     }
 }