public static void postProperty() {
String name = params.get("name");
String value = params.get("value");
Prop p = new Prop();
p.name = name;
p.value = value;
p.save();
renderText(p.id.toString());
}
public static void removeProperty() {
String id = params.get("id");
Prop p = Prop.findById(Long.valueOf(id));
List<Specification> specifications =
Specification.em()
.createQuery(
"select r from Specification r join fetch r.properties s where s.id="
+ Long.valueOf(id),
Specification.class)
.getResultList();
for (Specification spec : specifications) {
spec.properties.remove(p);
spec.save();
}
if (p != null) p.delete();
renderText(id);
}
/**
* Initializes the scanner.
*
* @param f input file
* @param pr database properties
* @param frag allow parsing of document fragment
* @throws IOException I/O exception
*/
XMLScanner(final IO f, final Prop pr, final boolean frag) throws IOException {
input = new XMLInput(f);
fragment = frag;
try {
for (int e = 0; e < ENTITIES.length; e += 2) {
ents.add(token(ENTITIES[e]), token(ENTITIES[e + 1]));
}
dtd = pr.is(Prop.DTD);
chop = pr.is(Prop.CHOP);
String enc = null;
// process document declaration...
if (consume(DOCDECL)) {
if (s()) {
if (!version()) error(DECLSTART);
boolean s = s();
enc = encoding();
if (enc != null) {
if (!s) error(WSERROR);
s = s();
}
if (sddecl() != null && !s) error(WSERROR);
s();
final int ch = nextChar();
if (ch != '?' || nextChar() != '>') error(DECLWRONG);
} else {
prev(5);
}
}
encoding = enc == null ? UTF8 : enc;
if (!fragment) {
final int n = consume();
if (!s(n)) {
if (n != '<') error(BEFOREROOT);
prev(1);
}
}
} catch (final IOException ex) {
input.close();
throw ex;
}
}
public static void impSpec(File file) {
if (file != null) {
List<Specification> specifications = new ArrayList<Specification>();
Specification spec = null;
Material material = null;
try {
FileInputStream fileInputStream = new FileInputStream(file);
HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream);
HSSFSheet worksheet = workbook.getSheetAt(0);
HSSFRow row = null;
HSSFCell cell = null;
Map<Integer, String> headerMap = new HashMap<Integer, String>();
Prop prop = null;
if (worksheet.getLastRowNum() > 0) {
row = worksheet.getRow(0);
for (int i = 0; i < row.getLastCellNum(); i++) {
headerMap.put(Integer.valueOf(i), row.getCell(i).getStringCellValue());
}
}
for (int i = 1; i < worksheet.getLastRowNum(); i++) {
row = worksheet.getRow(i);
cell = row.getCell(0);
String materialName = cell.getStringCellValue();
cell = row.getCell(1);
String specification = cell.getStringCellValue();
cell = row.getCell(2);
Double number = cell.getNumericCellValue();
cell = row.getCell(3);
String unit = cell.getStringCellValue();
cell = row.getCell(4);
String company = cell.getStringCellValue();
cell = row.getCell(5);
Date date = cell.getDateCellValue();
cell = row.getCell(6);
String description = cell.getStringCellValue();
spec = new Specification();
for (int x = 7; x < row.getLastCellNum(); x++) {
cell = row.getCell(x);
String value = "";
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
value = String.valueOf(cell.getNumericCellValue());
} else {
value = cell.getStringCellValue();
}
prop = new Prop();
prop.name = headerMap.get(x);
prop.value = value;
prop.save();
spec.properties.add(prop);
}
spec.name = specification;
spec.specification = specification;
if (number != null && !"".equals(number)) spec.amount = number;
spec.unit = unit;
spec.company = company;
if (materialName != null && !"".equals(materialName)) {
material = Material.find("name=?", materialName.trim()).first();
spec.material = material;
}
spec.arrival_time = date;
spec.description = description;
spec.save();
specifications.add(spec);
}
renderJSON(specifications);
} catch (Exception e) {
e.printStackTrace();
}
}
}
