public static ESRRecord load(final String id) { ESRRecord ret = new ESRRecord(id); if (ret.exists()) { return ret; } return null; }
public Color getBackground(Object element, int columnIndex) { ESRRecord rec = (ESRRecord) element; if (rec.getRejectCode().equals(ESRRecord.REJECT.OK)) { if (StringTool.isNothing(rec.getGebucht())) { return Desk.getColor(Desk.COL_GREY); } return Desk.getColor(Desk.COL_WHITE); } else { return Desk.getColor(Desk.COL_RED); } }
public String getColumnText(Object element, int columnIndex) { String text = ""; // $NON-NLS-1$ ESRRecord rec = (ESRRecord) element; switch (columnIndex) { case ESRView.DATUM_INDEX: text = rec.get("Datum"); // $NON-NLS-1$ break; case ESRView.RN_NUMMER_INDEX: Rechnung rn = rec.getRechnung(); if (rn != null) { text = rn.getNr(); } break; case ESRView.BETRAG_INDEX: text = rec.getBetrag().getAmountAsString(); break; case ESRView.EINGELESEN_INDEX: text = rec.getEinlesedatatum(); break; case ESRView.VERRECHNET_INDEX: text = rec.getVerarbeitungsdatum(); break; case ESRView.GUTGESCHRIEBEN_INDEX: text = rec.getValuta(); break; case ESRView.PATIENT_INDEX: text = rec.getPatient().getLabel(); break; case ESRView.BUCHUNG_INDEX: String dat = rec.getGebucht(); if (StringTool.isNothing(dat)) { text = Messages.ESRView2_notbooked; } else { text = new TimeTool(dat).toString(TimeTool.DATE_GER); } break; case ESRView.DATEI_INDEX: text = rec.getFile(); break; } return text; }
static { addMapping( TABLENAME, PersistentObject.DATE_COMPOUND, "Eingelesen=S:D:EINGELESEN", //$NON-NLS-1$ "Verarbeitet=S:D:VERARBEITET", //$NON-NLS-1$ "Gutgeschrieben=S:D:GUTSCHRIFT", //$NON-NLS-1$ "BetragInRp=BETRAGINRP", //$NON-NLS-1$ CODE, RECHNUNGS_ID, PATIENT_ID, MANDANT_ID, FLD_REJECT_CODE, "Gebucht=S:D:GEBUCHT", "File" //$NON-NLS-1$ //$NON-NLS-2$ ); ESRRecord init = load("1"); // $NON-NLS-1$ if (init == null) { createOrModifyTable(createDB); } else { String v = init.get("File"); // $NON-NLS-1$ if (StringTool.isNothing(v)) { // < version 1 getConnection() .exec( "ALTER TABLE " + TABLENAME + " ADD deleted CHAR(1) default '0';"); //$NON-NLS-1$ //$NON-NLS-2$ init.set("File", VERSION); // $NON-NLS-1$ } else { VersionInfo vi = new VersionInfo(v); if (vi.isOlder("2.0.0")) { // $NON-NLS-1$ createOrModifyTable(upd2); } init.set("File", VERSION); // $NON-NLS-1$ } } }