/**
* Import a medicament from one row of the BAG-Medi file
*
* @param row
* <pre>
* row[0] = ID,bzw Name
* row[1] = Generikum
* row[2] = Pharmacode
* row[3] = BAG-Dossier
* row[4] = Swissmedic-Nr
* row[5] = Swissmedic-Liste
* row[6]
* row[7] = Namen
* row[8] = EK-Preis
* row[9] = VK-Preis
* row[10]= Limitatio (Y/N)
* row[11]= LimitatioPts
* row[12]= Gruppe (optional)
* row[13]= Substance (optional)
* </pre>
*
* @return
*/
public static boolean importUpdate(final String[] row) throws ElexisException {
String pharmacode = "0";
BAGMedi imp = null;
// Kein Pharmacode, dann nach Name suchen
if (StringTool.isNothing(row[2].trim())) {
String mid = qbe.findSingle(Artikel.FLD_NAME, "=", row[7]);
if (mid != null) {
imp = BAGMedi.load(mid);
}
} else {
try {
// strip leading zeroes
int pcode = Integer.parseInt(row[2].trim());
pharmacode = Integer.toString(pcode);
} catch (Exception ex) {
ExHandler.handle(ex);
log.log(Level.WARNING, "Pharmacode falsch: " + row[2]);
}
qbe.clear(true);
qbe.add(Artikel.FLD_SUB_ID, "=", pharmacode);
qbe.or();
qbe.add(Artikel.FLD_SUB_ID, Query.EQUALS, row[2].trim());
List<Artikel> lArt = qbe.execute();
if (lArt == null) {
throw new ElexisException(
BAGMediImporter.class,
"Article list was null while scanning for " + pharmacode,
ElexisException.EE_UNEXPECTED_RESPONSE,
true);
}
if (lArt.size() > 1) {
// Duplikate entfernen, genau einen gültigen und existierenden Artikel behalten
Iterator<Artikel> it = lArt.iterator();
boolean hasValid = false;
Artikel res = null;
while (it.hasNext()) {
Artikel ax = it.next();
if (hasValid || (!ax.isValid())) {
if (res == null) {
res = ax;
}
it.remove();
} else {
hasValid = true;
}
}
if (!hasValid) {
if (res != null) {
if (res.isDeleted()) {
res.undelete();
lArt.add(res);
}
}
}
}
imp = lArt.size() > 0 ? BAGMedi.load(lArt.get(0).getId()) : null;
}
if (imp == null || (!imp.isValid())) {
imp = new BAGMedi(row[7], pharmacode);
String sql =
new StringBuilder()
.append("INSERT INTO ")
.append(BAGMedi.EXTTABLE)
.append(" (ID) VALUES (")
.append(imp.getWrappedId())
.append(");")
.toString();
PersistentObject.getConnection().exec(sql);
} else {
String sql =
new StringBuilder()
.append("SELECT ID FROM ")
.append(BAGMedi.EXTTABLE)
.append(" WHERE ID=")
.append(imp.getWrappedId())
.toString();
String extid = PersistentObject.getConnection().queryString(sql);
if (extid == null) {
sql =
new StringBuilder()
.append("INSERT INTO ")
.append(BAGMedi.EXTTABLE)
.append(" (ID) VALUES (")
.append(imp.getWrappedId())
.append(");")
.toString();
PersistentObject.getConnection().exec(sql);
}
}
imp.update(row);
return true;
}
