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); }