private void receiptChanged(CouchChange changes) throws DaoException { Document document = changes.getDoc(); // first delete all the old statistics documents that are associated to this Receipt _statisticDao.delete(_statisticDao.getIDsByReceipt(document.getId())); // then create a new one for each receipt entry Shop shop = null; Date timestamp = null; Category shopCategory = null; if (document.hasProperty("shopId")) { String shopId = document.getProperty("shopId").toString(); if (shopId != null) { Shop originalShop = _shopDao.get(document.getProperty("shopId").toString()); shop = new Shop(null, originalShop.getId(), null, originalShop.getTitle(), null); if (originalShop.getAddress() != null && originalShop.getAddress().getPos() != null) { LatLon pos = originalShop.getAddress().getPos(); shop.setAddress(new Address(null, null, null, null, pos.getLat(), pos.getLon())); } if (originalShop.getCategoryId() != null) { shopCategory = new Category( null, originalShop.getCategoryId(), null, originalShop.getCategory().getTitle(), null); } } } if (document.hasProperty("timeStamp")) { Object timestampObject = document.getProperty("timeStamp"); Long timestampLong = null; if (timestampObject instanceof BigDecimal) { timestampLong = ((BigDecimal) timestampObject).longValue(); } else { timestampLong = new Long(timestampObject.toString()); } if (timestampLong != null) timestamp = new Date(timestampLong); } if (document.hasProperty("receiptEntries")) { Object entriesObject = document.getProperty("receiptEntries"); if (entriesObject instanceof List<?>) { List<?> entries = (List<?>) entriesObject; for (Object entryObject : entries) { if (entryObject instanceof Map<?, ?>) { Map<?, ?> entryMap = (Map<?, ?>) entryObject; StatisticResult statistic = new StatisticResult(); statistic.setShop(shop); statistic.setShopCategory(shopCategory); statistic.setDate(timestamp); statistic.setReceiptId(document.getId()); statistic.setSequenceNr(changes.getSeq()); // package and product if (entryMap.containsKey("packageId")) { String packageId = entryMap.get("packageId").toString(); Package pkg = _packageDao.get(packageId); Product product = _productDao.get(pkg.getProductId()); statistic.setPackage( new Package( null, pkg.getId(), null, new Quantity(pkg.getQuantity().getQuantity(), null))); if (product != null) { statistic.setProduct( new Product(null, product.getId(), null, product.getTitle(), null, null)); Category category = null; if (product.getCategory() != null) { category = new Category( null, product.getCategoryId(), null, product.getCategory().getTitle(), null); statistic.setProductCategory(category); } } String unitId = pkg.getQuantity().getUnitId(); if (unitId != null) { Unit unit = _unitDao.get(unitId); statistic.setUnit( new Unit(null, unit.getId(), null, unit.getTitle(), null, unit.getFactor())); if (unit.getParentId() != null) { unit = _unitDao.get(unit.getParentId()); statistic.setParentUnit( new Unit(null, unit.getId(), null, unit.getTitle(), null, 0)); } } } // price if (entryMap.containsKey("price")) { Object priceObject = entryMap.get("price"); if (priceObject instanceof Map<?, ?>) { Map<?, ?> priceMap = (Map<?, ?>) priceObject; statistic.setPrice( new Price( new BigDecimal(priceMap.get("price").toString()), Currency.valueOf(priceMap.get("currency").toString()))); } } String json = JSON.formatJSON(JSON.defaultJSON().forValue(statistic)); System.err.println("JSON:\n" + json); _statisticDao.create(statistic); } } } } }
private void documentChanged(CouchChange changes) throws DaoException { List<StatisticResult> affectedStatistics = _statisticDao.getAffected(changes.getId()); Document document = changes.getDoc(); for (StatisticResult statistic : affectedStatistics) { switch (document.getDocTypeEnum()) { case PRODUCT: { Product targetProduct = statistic.getProduct(); // update title targetProduct.setTitle(document.getTitle()); // update category targetProduct.setCategory( _updateCategory(document, targetProduct.getCategoryId(), _productCategoryDao)); } break; case PACKAGE: // update quantity if (document.getPropertyList().containsKey("quantity")) { Object quantityObject = document.getProperty("quantity"); if (quantityObject instanceof Map<?, ?>) { Map<?, ?> quantityMap = (Map<?, ?>) quantityObject; Unit unit = _unitDao.get(quantityMap.get("unitId").toString()); Quantity quantity = new Quantity( new BigDecimal(quantityMap.get("quantity").toString()), new Unit(null, unit.getId(), null, unit.getTitle(), null, 0)); statistic.getPackage().setQuantity(quantity); } } break; case SHOP: { Shop targetShop = statistic.getShop(); // update title targetShop.setTitle(document.getTitle()); // update category targetShop.setCategory( _updateCategory(document, targetShop.getCategoryId(), _shopCategoryDao)); // update address (lat+lon) if (document.getAddress() != null) { statistic.getAddress().setPos(document.getAddress().getPos()); } else if (statistic.getAddress() != null) statistic.setAddress(null); } break; case PRODUCTCATEGORY: // update title statistic.getProduct().getCategory().setTitle(document.getTitle()); break; case SHOPCATEGORY: // update title statistic.getShop().getCategory().setTitle(document.getTitle()); break; case UNIT: // update title statistic.getPackage().getQuantity().getUnit().setTitle(document.getTitle()); // TODO: update parent break; } statistic.setSequenceNr(changes.getSeq()); _statisticDao.update(statistic); } }