Android Open Source - Expenses Expenses List

• Back to App/simple  ↑

From Project

Back to project page Expenses.

License

The source code is released under:

GNU General Public License

Java Source Code

/*
 *   Copyright 2013, 2014 Daniel Pereira Coelho
 *   //from  ww  w .  j a v  a2 s .c o m
 *   This file is part of the Expenses Android Application.
 *
 *   Expenses 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 in version 3.
 *
 *   Expenses 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 Expenses.  If not, see <http://www.gnu.org/licenses/>.
 * 
 */

package com.dpcsoftware.mn;

import java.io.File;
import java.util.ArrayList;
import java.util.Date;

import android.app.Dialog;
import android.content.Context;
import android.content.Intent;
import android.content.SharedPreferences;
import android.content.res.Resources;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.os.Environment;
import android.preference.PreferenceManager;
import android.view.LayoutInflater;
import android.view.View;
import android.view.View.OnClickListener;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.AdapterView.OnItemLongClickListener;
import android.widget.Button;
import android.widget.CursorAdapter;
import android.widget.ImageButton;
import android.widget.ImageView;
import android.widget.ListView;
import android.widget.TextView;

import com.actionbarsherlock.app.SherlockActivity;
import com.actionbarsherlock.view.ActionMode;
import com.actionbarsherlock.view.Menu;
import com.actionbarsherlock.view.MenuInflater;
import com.actionbarsherlock.view.MenuItem;



public class ExpensesList extends SherlockActivity implements OnItemClickListener, OnItemLongClickListener {
  private static final int NUMBER_OF_ITEMS = 40;
  
  private App app;
  private App.SpinnerMenu sMenu;
  private ArrayList<Long> selectedIds;
  private boolean pickMode = false;
  private ActionMode.Callback mActionModeCallback;
  private ActionMode mActionMode;
  private ListView listView;
  private ExAdapter adapterListView;
  private boolean creating = true; 
  private Runnable menuCallback = new Runnable() {
    public void run() {
      numberOfItems = NUMBER_OF_ITEMS;
      renderList();
    }
  };
  private int numberOfItems = NUMBER_OF_ITEMS;
  private View footer, header;
  private long filterId;
  private Date filterDate;
  private Resources rs;
  private SharedPreferences prefs;
  
  @Override
  public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    
    setContentView(R.layout.expenseslist);
    
    app = (App) getApplication();
    rs = getResources();
    prefs = PreferenceManager.getDefaultSharedPreferences(this);
    
    selectedIds = new ArrayList<Long>();
    
    mActionModeCallback = new RExActionModeCallback();
      
      listView = (ListView) findViewById(R.id.listView1);
      listView.setOnItemClickListener(this);
      listView.setOnItemLongClickListener(this);
      
      View emptyView = LayoutInflater.from(this).inflate(R.layout.empty_msg, null);
      ((TextView) emptyView.findViewById(R.id.textView1)).setText(R.string.expenseslist_c2);
      listView.setEmptyView(emptyView);
      
    footer = LayoutInflater.from(this).inflate(R.layout.expenseslist_footer, null);
    ((ImageButton) footer).setOnClickListener(new OnClickListener() {
      public void onClick(View v) {
        numberOfItems += NUMBER_OF_ITEMS;
        renderList();
      }
    });
    listView.addFooterView(footer);
    
    Bundle bd = getIntent().getExtras();
    if(bd != null) {
      filterId = bd.getLong("FILTER_ID",-1);
      if(filterId >= 0) {
        filterDate = (Date) bd.get("FILTER_DATE");
        header = LayoutInflater.from(this).inflate(R.layout.expenseslist_header, null);
        listView.addHeaderView(header);
      }
    }
    else {
      filterId = -1;
    }
    
    if(app.showChangesDialog) {
      ChangesDialog cdg = new ChangesDialog(this);
      cdg.show();
      SharedPreferences.Editor pEditor = prefs.edit();
      pEditor.putInt("APP_VERSION", app.appVersion);
      pEditor.commit();
      app.showChangesDialog = false;
    }
    
    
   }
  
    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
       getSupportMenuInflater().inflate(R.menu.main, menu);
      
      sMenu = app.new SpinnerMenu(this,menuCallback);
      
      Bundle options = getIntent().getExtras();
        long newGroupId;
      if(options != null) {
          newGroupId = options.getLong("SET_GROUP_ID",-1);
          if(newGroupId >= 0 &&  newGroupId != app.activeGroupId)
              sMenu.setSelectedById(newGroupId);
        }
    
      return true;
    }
    
    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
      switch (item.getItemId()) {
        case R.id.item1:
          Intent intent = new Intent(this, AddEx.class);
          intent.putExtra("EDIT_MODE", false);
          startActivity(intent);
          break;
        case R.id.item2:
          Intent intent2 = new Intent(this, EditGroups.class);
             startActivity(intent2);
             break;
        case R.id.item3:
          Intent intent3 = new Intent(this, EditCategories.class);
             startActivity(intent3);
             break;
        case R.id.item4:
          Intent intent4 = new Intent(this, CategoryStats.class);
             startActivity(intent4);
             break;
        case R.id.item5:
          Intent intent5 = new Intent(this, TimeStats.class);
             startActivity(intent5);
             break;
        case R.id.item6:
          Intent intent6 = new Intent(this, EditPreferences.class);
             startActivity(intent6);
             break;
        case R.id.item8:
          Intent intent8 = new Intent(this, ExportData.class);
             startActivity(intent8);
             break;
        case R.id.item9:
          Intent intent9 = new Intent(this, About.class);
             startActivity(intent9);
             break;
      }
      
      return true;
    }
    
    @Override
    public void onResume() {
      super.onResume();
      if(mActionMode != null) mActionMode.finish();
      if(!creating) {
        if(app.mnUpdateList == true)
          renderList();
        if(app.mnUpdateMenu == true)
          sMenu.renderMenu();
        if(sMenu.getSpinner().getSelectedItemPosition() != app.activeGroupPos)
          sMenu.getSpinner().setSelection(app.activeGroupPos);
      }
      app.mnUpdateList = false;
      app.mnUpdateMenu = false;
      creating = false;

      //Verify auto backup
      if(prefs.getBoolean("BACKUP_AUTO", false)) {      
      int days;
      if(prefs.getString("BACKUP_AUTO_INT", "M").equals("M"))
        days = 30;
      else
        days = 7;
      
      if((new Date()).getTime() > (prefs.getLong("BACKUP_TIME", 0) + days*1000*60*60*24)) {
        //Backup procedure
        try {
          String stdAppFolder = Environment.getExternalStorageDirectory().getAbsolutePath() + "/" + rs.getString(R.string.app_name);
          File destDir = new File(prefs.getString("STD_FOLDER",stdAppFolder));
            if(!destDir.exists())
              destDir.mkdirs();
                      
            String destName;
            if(prefs.getBoolean("BACKUP_OVERRIDE_OLD", false))
              destName = rs.getString(R.string.app_name) + ".backup";
            else
              destName = rs.getString(R.string.app_name) + "_" + app.dateToUser("yyyy-MM-dd_H-m", new Date()) + ".backup";
          
          boolean tryCopy = App.copyFile(getDatabasePath(DatabaseHelper.DATABASE_NAME).getAbsolutePath(), destDir.getAbsolutePath() + "/" + destName);
    
          if (tryCopy == true) {
            SharedPreferences.Editor pEdit = prefs.edit();
            pEdit.putLong("BACKUP_TIME", (new Date().getTime()));
            pEdit.commit();
          }
        }
        catch (Exception e) {
          e.printStackTrace();
        }
      }
      }
    }
    
    @Override
    public void onPause() {
      super.onPause();
      if(mActionMode != null) mActionMode.finish();
    }
    
  @Override
  public void onStop() {
    super.onStop();
    SharedPreferences.Editor pEdit = prefs.edit();
    pEdit.putInt("ACTIVE_GROUP_POS", app.activeGroupPos);
    pEdit.putLong("ACTIVE_GROUP_ID", app.activeGroupId);
    pEdit.commit();
  }
    
    public void renderList() {
      SQLiteDatabase db = DatabaseHelper.quickDb(this, 0);
      String queryModifier = "", queryModifier2 = "";
      if(filterId != -1)
        queryModifier = " AND " + Db.Table1.TABLE_NAME + "." + Db.Table1.COLUMN_IDCAT + " = " + filterId;
      if(filterDate != null)
        queryModifier2 = " AND strftime('%Y-%m'," + Db.Table1.TABLE_NAME + "." + Db.Table1.COLUMN_DATAT + ") = '" + app.dateToDb("yyyy-MM", filterDate) + "'";

      Cursor c = db.rawQuery("SELECT " +
          Db.Table2.TABLE_NAME + "." + Db.Table2.COLUMN_NCAT + "," +
          Db.Table2.TABLE_NAME + "." + Db.Table2.COLUMN_CORCAT + "," +
          Db.Table1.TABLE_NAME + "." + Db.Table1.COLUMN_VALORT + "," + 
          Db.Table1.TABLE_NAME + "." + Db.Table1.COLUMN_DATAT + "," +
          Db.Table1.TABLE_NAME + "." + Db.Table1.COLUMN_DESCRIC + "," +
          Db.Table1.TABLE_NAME + "." + Db.Table1._ID +
          " FROM " +
          Db.Table1.TABLE_NAME + "," +
          Db.Table2.TABLE_NAME +
          " WHERE " +
          Db.Table1.TABLE_NAME + "." + Db.Table1.COLUMN_IDGRUPO + " = " + app.activeGroupId +
          " AND " + Db.Table1.TABLE_NAME + "." + Db.Table1.COLUMN_IDCAT + " = " + Db.Table2.TABLE_NAME + "." + Db.Table2._ID + queryModifier + queryModifier2 +
          " ORDER BY " +
          Db.Table1.TABLE_NAME + "." + Db.Table1.COLUMN_DATAT + " DESC, " +
          Db.Table1.TABLE_NAME + "." + Db.Table1._ID + " DESC" +
          " LIMIT " + numberOfItems,null);
      
      if(c.getCount() > 0 && filterId != -1) {
        c.moveToFirst();
        String text = c.getString(0);
        if(filterDate != null)
          text = text + ", " + app.dateToUser("MMMM / yyyy", filterDate);
        ((TextView) header.findViewById(R.id.textView2)).setText(text);
      }
     
      if(c.getCount() < numberOfItems)
        footer.setVisibility(View.GONE);
      else
        footer.setVisibility(View.VISIBLE);
      
      if(adapterListView == null) {
        adapterListView = new ExAdapter(this, c);
          listView.setAdapter(adapterListView);
      }
      else {
          adapterListView.changeCursor(c);
          adapterListView.notifyDataSetChanged();
      }

      db.close();
    }
    
    private class ExAdapter extends CursorAdapter {
      private LayoutInflater mInflater;
      
      public ExAdapter (Context context, Cursor c) {
          super(context, c, false);
          mInflater = LayoutInflater.from(context);
      }
      
        public View newView(Context context, Cursor cursor, ViewGroup parent) {
            return mInflater.inflate(R.layout.expenseslist_listitem,parent,false); 
        }
      
      public void bindView(View view, Context context, Cursor cursor) {
        ((TextView) view.findViewById(R.id.textView1)).setText(cursor.getString(0));
        ((ImageView) view.findViewById(R.id.imageView1)).getDrawable().setColorFilter(cursor.getInt(1), App.colorFilterMode);
        ((TextView) view.findViewById(R.id.textView2)).setText(app.printMoney( cursor.getFloat(2)));
        ((TextView) view.findViewById(R.id.textView3)).setText(app.dateToUser(null,cursor.getString(3)));
        TextView tvObs = ((TextView) view.findViewById(R.id.textView4));
        String obs = cursor.getString(4);
        if(obs.isEmpty())
          tvObs.setVisibility(View.GONE);
        else {
          tvObs.setText(obs);
          tvObs.setVisibility(View.VISIBLE);
        }
        
        if(selectedIds.contains(cursor.getLong(5)))
          selectItem(view,-1);
        else
          unselectItem(view,-1);
        
      }
    }
    
    private class RExActionModeCallback implements ActionMode.Callback {

      @Override
      public boolean onCreateActionMode(ActionMode mode, Menu menu) {
          MenuInflater inflater = mode.getMenuInflater();
          inflater.inflate(R.menu.context_readex, menu);
          return true;
      }

      @Override
      public boolean onPrepareActionMode(ActionMode mode, Menu menu) {
          return false;
      }

      @Override
      public boolean onActionItemClicked(ActionMode mode, MenuItem item) {
          switch (item.getItemId()) {
              case R.id.item1:
                  deleteExs(selectedIds);
                  renderList();
                  mode.finish();
                  return true;
              default:
                  return false;
          }
      }

      @Override
      public void onDestroyActionMode(ActionMode mode) {
             pickMode = false;
             clearSelections();
             mActionMode = null;
      }
  }
    
    private void selectItem(View v, long id) {
      if(id >= 0)
        selectedIds.add(id);
      
      v.setBackgroundColor(getResources().getColor(R.color.grayFirst));
    }
    
    private void unselectItem(View v, long id) {
      if(id >= 0)
        selectedIds.remove(selectedIds.indexOf(id));
      
    v.setBackgroundDrawable(getResources().getDrawable(R.drawable.statelist_normal));
    if(mActionMode != null && selectedIds.isEmpty())
      mActionMode.finish();
    }
    
    private void clearSelections(){
      int i,max,start;
      if(!selectedIds.isEmpty()) {
        max = listView.getChildCount();
        if(listView.getHeaderViewsCount() == 0)
          start = 0;
        else if(listView.getFirstVisiblePosition() == 0)
          start = 1;
        else
          start = 0;
        for(i = start;i < max;i++)
          unselectItem(listView.getChildAt(i),-1);            
         selectedIds.clear();
      }
    }
    
    @Override
    public void onItemClick(AdapterView<?> parent, View v, int position, long id) {
      if(pickMode) {
        if(!selectedIds.contains(id))
          selectItem(v,id);
        else
          unselectItem(v,id);
      }
      else {
      Intent intent = new Intent(ExpensesList.this, AddEx.class);
      Bundle args = new Bundle();
      args.putBoolean("EDIT_MODE",true);
      args.putLong("EM_ID", id);
      intent.putExtras(args);
      startActivity(intent);
      }
    }
    
    @Override
    public boolean onItemLongClick(AdapterView<?> parent, View view, int position, long id) {
      if(!pickMode) {
        pickMode = true;
        selectItem(view,id);
        mActionMode = startActionMode(mActionModeCallback);
      }      
      return true;
    }
    
    private void deleteExs(ArrayList<Long> ids) {
      SQLiteDatabase db = DatabaseHelper.quickDb(this,DatabaseHelper.MODE_WRITE);
      int i;      
      
      for(i = 0;i < ids.size();i++)
        db.delete(Db.Table1.TABLE_NAME,new String(Db.Table1._ID + " = " + ids.get(i)), null);
      
      app.setFlag(1);
      
      db.close();
    }
    
    private class ChangesDialog extends Dialog implements OnClickListener {
      
      public ChangesDialog(Context ctx) {
        super(ctx);
        
        setTitle(R.string.expenseslist_c1);
        setContentView(R.layout.expenseslist_changesdialog);
        
        ((Button) findViewById(R.id.button1)).setOnClickListener(this);
      }
      
      public void onClick(View v) {
        switch(v.getId()) {
        case R.id.button1:
          this.dismiss();
          break;
        }
      }
    }
}

Java Source Code List

• Back to App/simple  ↑