/*
    * MoneyWise: Finance Application
    * Copyright 2012-2026. Tony Washer
    *
    * Licensed under the Apache License, Version 2.0 (the "License"); you may not
    * use this file except in compliance with the License.  You may obtain a copy
    * of the License at
    *
    *   http://www.apache.org/licenses/LICENSE-2.0
   *
   * Unless required by applicable law or agreed to in writing, software
   * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
   * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  See the
   * License for the specific language governing permissions and limitations under
   * the License.
   */
  package io.github.tonywasher.joceanus.moneywise.database;
  
  import io.github.tonywasher.joceanus.oceanus.base.OceanusException;
  import io.github.tonywasher.joceanus.oceanus.decimal.OceanusMoney;
  import io.github.tonywasher.joceanus.metis.data.MetisDataItem.MetisDataFieldId;
  import io.github.tonywasher.joceanus.moneywise.data.basic.MoneyWiseBasicDataType;
  import io.github.tonywasher.joceanus.moneywise.data.basic.MoneyWiseBasicResource;
  import io.github.tonywasher.joceanus.moneywise.data.basic.MoneyWiseDataSet;
  import io.github.tonywasher.joceanus.moneywise.data.basic.MoneyWiseTransaction;
  import io.github.tonywasher.joceanus.prometheus.data.PrometheusDataSet;
  import io.github.tonywasher.joceanus.prometheus.data.PrometheusDataValues;
  import io.github.tonywasher.joceanus.prometheus.database.PrometheusColumnDefinition;
  import io.github.tonywasher.joceanus.prometheus.database.PrometheusDataStore;
  import io.github.tonywasher.joceanus.prometheus.database.PrometheusTableDefinition;
  import io.github.tonywasher.joceanus.prometheus.database.PrometheusTableDefinition.PrometheusSortOrder;
  import io.github.tonywasher.joceanus.prometheus.database.PrometheusTableEncrypted;
  
  /**
   * TableEncrypted extension for Transaction.
   *
   * @author Tony Washer
   */
  public class MoneyWiseTableTransaction
          extends PrometheusTableEncrypted<MoneyWiseTransaction> {
      /**
       * The name of the Transactions table.
       */
      protected static final String TABLE_NAME = MoneyWiseTransaction.LIST_NAME;
  
      /**
       * Constructor.
       *
       * @param pDatabase the database control
       */
      protected MoneyWiseTableTransaction(final PrometheusDataStore pDatabase) {
          super(pDatabase, TABLE_NAME);
          final PrometheusTableDefinition myTableDef = getTableDef();
  
          /* Define the columns */
          final PrometheusColumnDefinition myDateCol = myTableDef.addDateColumn(MoneyWiseBasicResource.MONEYWISEDATA_FIELD_DATE);
          myTableDef.addBooleanColumn(MoneyWiseBasicResource.TRANSACTION_DIRECTION);
          myTableDef.addLongColumn(MoneyWiseBasicResource.TRANSACTION_ACCOUNT);
          myTableDef.addLongColumn(MoneyWiseBasicResource.TRANSACTION_PARTNER);
          myTableDef.addNullEncryptedColumn(MoneyWiseBasicResource.TRANSACTION_AMOUNT, OceanusMoney.BYTE_LEN);
          myTableDef.addReferenceColumn(MoneyWiseBasicDataType.TRANSCATEGORY, MoneyWiseTableTransCategory.TABLE_NAME);
          myTableDef.addBooleanColumn(MoneyWiseBasicResource.TRANSACTION_RECONCILED);
  
          /* Declare the sort order */
          myDateCol.setSortOrder(PrometheusSortOrder.ASCENDING);
      }
  
      @Override
      protected void declareData(final PrometheusDataSet pData) {
          final MoneyWiseDataSet myData = (MoneyWiseDataSet) pData;
          setList(myData.getTransactions());
      }
  
      /* Load the event */
      @Override
      protected PrometheusDataValues loadValues() throws OceanusException {
          /* Access the table definition */
          final PrometheusTableDefinition myTableDef = getTableDef();
  
          /* Build data values */
          final PrometheusDataValues myValues = getRowValues(MoneyWiseTransaction.OBJECT_NAME);
          myValues.addValue(MoneyWiseBasicResource.MONEYWISEDATA_FIELD_DATE, myTableDef.getDateValue(MoneyWiseBasicResource.MONEYWISEDATA_FIELD_DATE));
          myValues.addValue(MoneyWiseBasicResource.TRANSACTION_DIRECTION, myTableDef.getBooleanValue(MoneyWiseBasicResource.TRANSACTION_DIRECTION));
          myValues.addValue(MoneyWiseBasicDataType.TRANSCATEGORY, myTableDef.getIntegerValue(MoneyWiseBasicDataType.TRANSCATEGORY));
          myValues.addValue(MoneyWiseBasicResource.TRANSACTION_ACCOUNT, myTableDef.getLongValue(MoneyWiseBasicResource.TRANSACTION_ACCOUNT));
          myValues.addValue(MoneyWiseBasicResource.TRANSACTION_PARTNER, myTableDef.getLongValue(MoneyWiseBasicResource.TRANSACTION_PARTNER));
          myValues.addValue(MoneyWiseBasicResource.TRANSACTION_AMOUNT, myTableDef.getBinaryValue(MoneyWiseBasicResource.TRANSACTION_AMOUNT));
          myValues.addValue(MoneyWiseBasicResource.TRANSACTION_RECONCILED, myTableDef.getBooleanValue(MoneyWiseBasicResource.TRANSACTION_RECONCILED));
  
          /* Return the values */
          return myValues;
      }
  
      @Override
      protected void setFieldValue(final MoneyWiseTransaction pItem,
                                   final MetisDataFieldId iField) throws OceanusException {
          /* Switch on field id */
          final PrometheusTableDefinition myTableDef = getTableDef();
          if (MoneyWiseBasicResource.MONEYWISEDATA_FIELD_DATE.equals(iField)) {
             myTableDef.setDateValue(iField, pItem.getDate());
         } else if (MoneyWiseBasicResource.TRANSACTION_DIRECTION.equals(iField)) {
             myTableDef.setBooleanValue(iField, pItem.getDirection().isFrom());
         } else if (MoneyWiseBasicResource.TRANSACTION_AMOUNT.equals(iField)) {
             myTableDef.setBinaryValue(iField, pItem.getAmountBytes());
         } else if (MoneyWiseBasicResource.TRANSACTION_ACCOUNT.equals(iField)) {
             myTableDef.setLongValue(iField, pItem.getAccountId());
         } else if (MoneyWiseBasicResource.TRANSACTION_PARTNER.equals(iField)) {
             myTableDef.setLongValue(iField, pItem.getPartnerId());
         } else if (MoneyWiseBasicDataType.TRANSCATEGORY.equals(iField)) {
             myTableDef.setIntegerValue(iField, pItem.getCategoryId());
         } else if (MoneyWiseBasicResource.TRANSACTION_RECONCILED.equals(iField)) {
             myTableDef.setBooleanValue(iField, pItem.isReconciled());
         } else {
             super.setFieldValue(pItem, iField);
         }
     }
 }