View Javadoc
1   /*
2    * MoneyWise: Finance Application
3    * Copyright 2012-2026. Tony Washer
4    *
5    * Licensed under the Apache License, Version 2.0 (the "License"); you may not
6    * use this file except in compliance with the License.  You may obtain a copy
7    * of the License at
8    *
9    *   http://www.apache.org/licenses/LICENSE-2.0
10   *
11   * Unless required by applicable law or agreed to in writing, software
12   * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
13   * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  See the
14   * License for the specific language governing permissions and limitations under
15   * the License.
16   */
17  package io.github.tonywasher.joceanus.moneywise.sheets;
18  
19  import io.github.tonywasher.joceanus.oceanus.base.OceanusException;
20  import io.github.tonywasher.joceanus.moneywise.data.basic.MoneyWiseBasicDataType;
21  import io.github.tonywasher.joceanus.moneywise.data.basic.MoneyWiseBasicResource;
22  import io.github.tonywasher.joceanus.moneywise.data.basic.MoneyWiseDataSet;
23  import io.github.tonywasher.joceanus.moneywise.data.basic.MoneyWiseDepositRate;
24  import io.github.tonywasher.joceanus.prometheus.data.PrometheusDataValues;
25  import io.github.tonywasher.joceanus.prometheus.sheets.PrometheusSheetEncrypted;
26  
27  /**
28   * SheetDataItem extension for DepositRate.
29   *
30   * @author Tony Washer
31   */
32  public final class MoneyWiseSheetDepositRate
33          extends PrometheusSheetEncrypted<MoneyWiseDepositRate> {
34      /**
35       * NamedArea for Rates.
36       */
37      private static final String AREA_RATES = MoneyWiseDepositRate.LIST_NAME;
38  
39      /**
40       * Deposit column.
41       */
42      private static final int COL_DEPOSIT = COL_KEYSETID + 1;
43  
44      /**
45       * Rate column.
46       */
47      private static final int COL_RATE = COL_DEPOSIT + 1;
48  
49      /**
50       * Bonus column.
51       */
52      private static final int COL_BONUS = COL_RATE + 1;
53  
54      /**
55       * EndDate column.
56       */
57      private static final int COL_ENDDATE = COL_BONUS + 1;
58  
59      /**
60       * Constructor for loading a spreadsheet.
61       *
62       * @param pReader the spreadsheet reader
63       */
64      MoneyWiseSheetDepositRate(final MoneyWiseReader pReader) {
65          /* Call super constructor */
66          super(pReader, AREA_RATES);
67  
68          /* Access the Rates list */
69          final MoneyWiseDataSet myData = (MoneyWiseDataSet) pReader.getData();
70          setDataList(myData.getDepositRates());
71      }
72  
73      /**
74       * Constructor for creating a spreadsheet.
75       *
76       * @param pWriter the spreadsheet writer
77       */
78      MoneyWiseSheetDepositRate(final MoneyWiseWriter pWriter) {
79          /* Call super constructor */
80          super(pWriter, AREA_RATES);
81  
82          /* Access the Rates list */
83          final MoneyWiseDataSet myData = (MoneyWiseDataSet) pWriter.getData();
84          setDataList(myData.getDepositRates());
85      }
86  
87      @Override
88      protected PrometheusDataValues loadSecureValues() throws OceanusException {
89          /* Build data values */
90          final PrometheusDataValues myValues = getRowValues(MoneyWiseDepositRate.OBJECT_NAME);
91          myValues.addValue(MoneyWiseBasicDataType.DEPOSIT, loadInteger(COL_DEPOSIT));
92          myValues.addValue(MoneyWiseBasicResource.MONEYWISEDATA_FIELD_RATE, loadBytes(COL_RATE));
93          myValues.addValue(MoneyWiseBasicResource.DEPOSITRATE_BONUS, loadBytes(COL_BONUS));
94          myValues.addValue(MoneyWiseBasicResource.DEPOSITRATE_ENDDATE, loadDate(COL_ENDDATE));
95  
96          /* Return the values */
97          return myValues;
98      }
99  
100     @Override
101     protected void insertSecureItem(final MoneyWiseDepositRate pItem) throws OceanusException {
102         /* Set the fields */
103         super.insertSecureItem(pItem);
104         writeInteger(COL_DEPOSIT, pItem.getDepositId());
105         writeBytes(COL_RATE, pItem.getRateBytes());
106         writeBytes(COL_BONUS, pItem.getBonusBytes());
107         writeDate(COL_ENDDATE, pItem.getEndDate());
108     }
109 
110     @Override
111     protected int getLastColumn() {
112         /* Return the last column */
113         return COL_ENDDATE;
114     }
115 }