public static String getSaldoTotalPlanilha(int codigoPlanilha) {
String toReturn;
Cursor c =
Database.get(
"select sum(ope_valor) as soma from Operacoes where ope_codigo_pla = "
+ codigoPlanilha
+ " and ope_codigo_top = 1");
Cursor c2 =
Database.get(
"select sum(ope_valor) as soma from Operacoes where ope_codigo_pla = "
+ codigoPlanilha
+ " and ope_codigo_top = 2");
try {
float aux = c.getFloat(c.getColumnIndex("soma")) - c2.getFloat(c2.getColumnIndex("soma"));
toReturn = String.valueOf(aux);
} catch (Exception e) {
toReturn = "0";
}
c.close();
c2.close();
return toReturn;
}
public static void insert(
int codigoPlanilha,
String descricao,
float valor,
int tipoOperacao,
String data,
int parcelas,
int ativo) {
// SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
// Calendar calendar = Calendar.getInstance();
// String data = formatter.format(calendar.getTime());
String query =
"insert into Operacoes(ope_descricao,ope_codigo_pla,ope_valor, ope_codigo_top, ope_data,ope_parcelas,ope_ativo) values ('"
+ descricao
+ "',"
+ codigoPlanilha
+ ","
+ valor
+ ","
+ tipoOperacao
+ ",'"
+ data
+ "',"
+ parcelas
+ ","
+ ativo
+ ")";
Database.run(query);
}
public static Operacoes findByTipoOperacao(int tipoOperacao) {
Operacoes toReturn;
Cursor c = Database.get("select * from Operacoes where ope_codigo_top = " + tipoOperacao);
try {
toReturn = new Operacoes(c);
} catch (Exception e) {
toReturn = null;
}
c.close();
return toReturn;
}
public static Operacoes findByNome(String descricao) {
Operacoes toReturn;
Cursor c = Database.get("select * from Operacoes where ope_descricao = '" + descricao + "'");
try {
toReturn = new Operacoes(c);
} catch (Exception e) {
toReturn = null;
}
c.close();
return toReturn;
}
public static List<Operacoes> findByPlanilha(int planilha) {
List<Operacoes> toReturn = new ArrayList<Operacoes>();
Cursor listOperacoes =
Database.get("select * from Operacoes where ope_codigo_pla = " + planilha);
try {
while (!listOperacoes.isAfterLast()) {
Operacoes ope = new Operacoes(listOperacoes);
toReturn.add(ope);
listOperacoes.moveToNext();
}
} catch (Exception e) {
toReturn = null;
}
listOperacoes.close();
return toReturn;
}
public static void delete() {
String query = "DROP TABLE Operacoes";
Database.run(query);
}
public static void create() {
String query =
"create table if not exists Operacoes (ope_codigo integer primary key autoincrement, ope_descricao varchar, ope_codigo_pla int, ope_valor float, ope_codigo_top int, ope_data date, ope_parcelas int, ope_ativo int)";
Database.run(query);
}