/*
* Copyright (C) 2012-2016 The Android Money Manager Ex Project Team
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU 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 General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
package com.money.manager.ex.database;
import android.content.Context;
import com.money.manager.ex.R;
import com.money.manager.ex.utils.MmxFileUtils;
/**
* A dataset for the query that fetches recurring transactions.
*/
public class QueryBillDeposits
extends Dataset {
// constructor
public QueryBillDeposits(Context context) {
super(MmxFileUtils.getRawAsString(context, R.raw.query_billdeposits), DatasetType.QUERY,
QueryBillDeposits.class.getSimpleName());
}
// fields
public static String BDID = "BDID";
public static String PAYEEID = "PAYEEID";
public static String PAYEENAME = "PAYEENAME";
public static String TOACCOUNTID = "TOACCOUNTID";
public static String TOACCOUNTNAME = "TOACCOUNTNAME";
public static String ACCOUNTID = "ACCOUNTID";
public static String ACCOUNTNAME = "ACCOUNTNAME";
public static String CURRENCYID = "CURRENCYID";
public static String CATEGSUBCATEGNAME = "CATEGSUBCATEGNAME";
public static String CATEGNAME = "CATEGNAME";
public static String SUBCATEGNAME = "SUBCATEGNAME";
public static String TRANSCODE = "TRANSCODE";
public static String TRANSAMOUNT = "TRANSAMOUNT";
public static String NEXTOCCURRENCEDATE = "NEXTOCCURRENCEDATE";
public static String REPEATS = "REPEATS";
public static String DAYSLEFT = "DAYSLEFT";
public static String NOTES = "NOTES";
public static String STATUS = "STATUS";
public static String NUMOCCURRENCES = "NUMOCCURRENCES";
public static String TOTRANSAMOUNT = "TOTRANSAMOUNT";
public static String TRANSACTIONNUMBER = "TRANSACTIONNUMBER";
public static String TRANSDATE = "TRANSDATE";
public static String AMOUNT = "AMOUNT";
public static String USERNEXTOCCURRENCEDATE = "USERNEXTOCCURRENCEDATE";
// get all columns
@Override
public String[] getAllColumns() {
return new String[]{BDID + " AS _id", BDID, PAYEEID, PAYEENAME, TOACCOUNTID, TOACCOUNTNAME,
ACCOUNTID, ACCOUNTNAME, CURRENCYID, CATEGSUBCATEGNAME,
CATEGNAME, SUBCATEGNAME, TRANSCODE, TRANSAMOUNT, NEXTOCCURRENCEDATE, REPEATS,
DAYSLEFT, NOTES, STATUS, NUMOCCURRENCES, TOTRANSAMOUNT,
TRANSACTIONNUMBER, TRANSDATE, AMOUNT, USERNEXTOCCURRENCEDATE};
}
}