@Override
public void onStart() {
super.onStart();
try {
SharedPreferences prefs =
PreferenceManager.getDefaultSharedPreferences(ListTransactions.this);
String username = prefs.getString("user", "anon");
DBHelper dbhelper = new DBHelper(this);
SQLiteDatabase db = dbhelper.getReadableDatabase();
Cursor trans =
db.rawQuery(
"select t._id,t.uid, item,quantity, transdate,transamount,transtype,cheque_no,cheque_party,cheque_details, t.remarks from transactions t inner join stock a on ( a._id = t.account_id) where "
+ condition
+ "and t.uid='"
+ username
+ "'",
null);
if (trans.getCount() == 0) this.findViewById(R.id.textError).setVisibility(View.VISIBLE);
else this.findViewById(R.id.textError).setVisibility(View.INVISIBLE);
ArrayList<Map<String, String>> listTrans = new ArrayList<Map<String, String>>();
while (trans.moveToNext()) {
// get trans details for display
LinkedHashMap<String, String> tran = new LinkedHashMap<String, String>();
tran.put("transid", trans.getString(trans.getColumnIndex(Database.TRANSACTIONS_ID)));
tran.put("acno", trans.getString(trans.getColumnIndex(Database.STOCK_NAME)));
tran.put(
"transdate", trans.getString(trans.getColumnIndex(Database.TRANSACTIONS_TRANSDATE)));
tran.put(
"transtype", trans.getString(trans.getColumnIndex(Database.TRANSACTIONS_TRANSTYPE)));
tran.put(
"transamount",
trans.getString(trans.getColumnIndex(Database.TRANSACTIONS_TRANSAMOUNT)));
tran.put(
"transremarks",
trans.getString(trans.getColumnIndex(Database.TRANSACTIONS_CHEQUE_PARTY)));
String chequeno = trans.getString(trans.getColumnIndex(Database.TRANSACTIONS_CHEQUE_NO));
String transDetails = "Cash";
if (!chequeno.trim().equals("")) transDetails = chequeno;
tran.put("transdetails", transDetails);
listTrans.add(tran);
}
trans.close();
db.close();
dbhelper.close();
SimpleAdapter adapter =
new SimpleAdapter(
this,
listTrans,
R.layout.transaction,
new String[] {
"transid",
"acno",
"transdate",
"transdetails",
"transtype",
"transamount",
"transremarks"
},
new int[] {
R.id.textTransId,
R.id.textAcno,
R.id.textTransDate,
R.id.textTransDetails,
R.id.textTransType,
R.id.textTransAmount,
R.id.textTransRemarks
});
listTransactions.setAdapter(adapter);
} catch (Exception ex) {
Toast.makeText(this, ex.getMessage(), Toast.LENGTH_LONG).show();
}
}
