package org.netevolved.integration.ecwid; import java.util.Collection; import java.util.Iterator; import org.apache.commons.io.IOUtils; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.apache.http.HttpEntity; import org.apache.http.HttpResponse; import org.apache.http.client.methods.HttpEntityEnclosingRequestBase; import org.apache.http.client.methods.HttpGet; import org.apache.http.client.methods.HttpPost; import org.apache.http.client.methods.HttpPut; import org.apache.http.client.methods.HttpRequestBase; import org.apache.http.entity.StringEntity; import org.apache.http.impl.client.CloseableHttpClient; import org.apache.http.impl.client.HttpClients; import org.apache.http.util.EntityUtils; import org.entermediadb.asset.MediaArchive; import org.ijsolutions.testbench.TestBench; import org.openedit.CatalogEnabled; import org.openedit.Data; import org.openedit.ModuleManager; import org.openedit.data.Searcher; import org.openedit.hittracker.HitTracker; import org.openedit.store.Product; import org.openedit.store.orders.OrderSearcher; import org.openedit.store.search.ProductSearcher; import org.openedit.users.Group; import org.openedit.users.User; import org.openedit.users.UserManager; import org.openedit.users.UserSearcher; import org.openedit.users.authenticate.PasswordGenerator; import org.openedit.util.OutputFiller; import com.google.gson.JsonArray; import com.google.gson.JsonElement; import com.google.gson.JsonObject; import com.google.gson.JsonParser; public class EcwidManager implements CatalogEnabled { // https://developers.ecwid.com/api-documentation/external-applications private static final Log log = LogFactory.getLog(EcwidManager.class); protected String fieldCatalogId; protected MediaArchive fieldMediaArchive; protected TestBench fieldTestBench; protected ModuleManager fieldModuleManager; protected OutputFiller filler = new OutputFiller(); protected String fieldAccessToken; protected String fieldBaseUrl; protected String fieldStoreId; public String getBaseUrl() { if (fieldBaseUrl == null) { fieldBaseUrl = getMediaArchive().getCatalogSettingValue("ecwidbaseurl"); } return fieldBaseUrl; } public void setBaseUrl(String inBaseUrl) { fieldBaseUrl = inBaseUrl; } public String getStoreId() { if (fieldStoreId == null) { fieldStoreId = getMediaArchive().getCatalogSettingValue("ecwidstoreid"); } return fieldStoreId; } public void setStoreId(String inStoreId) { fieldStoreId = inStoreId; } public String getAccessToken() { if (fieldAccessToken == null) { fieldAccessToken = getMediaArchive().getCatalogSettingValue("ecwidtoken"); } return fieldAccessToken; } public void setAccessToken(String inAccessToken) { fieldAccessToken = inAccessToken; } public String getCatalogId() { return fieldCatalogId; } public void setCatalogId(String inCatalogId) { fieldCatalogId = inCatalogId; } public ModuleManager getModuleManager() { return fieldModuleManager; } public void setModuleManager(ModuleManager inModuleManager) { fieldModuleManager = inModuleManager; } protected MediaArchive getMediaArchive() { if (fieldMediaArchive == null) { fieldMediaArchive = (MediaArchive) getModuleManager().getBean(getCatalogId(), "mediaArchive"); } return fieldMediaArchive; } public JsonObject getProducts() throws Exception { String url = getBaseUrl() + "/" + getStoreId() + "/products?token=" + getAccessToken(); CloseableHttpClient httpclient; httpclient = HttpClients.createDefault(); HttpRequestBase httpmethod = null; httpmethod = new HttpGet(url); HttpResponse resp = httpclient.execute(httpmethod); if (resp.getStatusLine().getStatusCode() != 200) { log.info("Ecwid Server error returned " + resp.getStatusLine().getStatusCode()); } HttpEntity entity = resp.getEntity(); String content = IOUtils.toString(entity.getContent()); JsonParser parser = new JsonParser(); JsonElement elem = parser.parse(content); // log.info(content); JsonObject json = elem.getAsJsonObject(); JsonArray items = json.get("items").getAsJsonArray(); Searcher searcher = getMediaArchive().getSearcher("product"); for (Iterator iterator = items.iterator(); iterator.hasNext();) { JsonObject object = (JsonObject) iterator.next(); String id = object.get("id").getAsString(); String sku = object.get("sku").getAsString(); Product p = (Product) searcher.searchById(sku); if(p!= null && p.get("ecwidid") == null) { p.setValue("ecwidid", id); searcher.saveData(p); } } return json; } public void addAllProducts() throws Exception { Searcher searcher = getMediaArchive().getSearcher("product"); HitTracker hits = searcher.getAllHits(); for (Iterator iterator = hits.iterator(); iterator.hasNext();) { Data product = (Data) iterator.next(); Product p = (Product) searcher.searchById(product.getId()); addProduct(p); getMediaArchive().getSearcher("product").saveData(p); } } public JsonObject addProduct(Product product) throws Exception { JsonObject json = createJsonObject(product); CloseableHttpClient httpclient; httpclient = HttpClients.createDefault(); HttpEntityEnclosingRequestBase method = null; if(product.get("ecwidid")== null) { String url = getBaseUrl() + "/" + getStoreId() + "/products?token=" + getAccessToken(); method = new HttpPost(url); method.setEntity(new StringEntity(json.toString(), "UTF-8")); } else { String url = getBaseUrl() + "/" + getStoreId() + "/products/" + product.get("ecwidid") + "?token=" + getAccessToken(); method = new HttpPut(url); method.setEntity(new StringEntity(json.toString(), "UTF-8")); } method.setHeader("Accept", "application/json"); method.setHeader("Content-type", "application/json"); method.setHeader("content-type", "application/json"); // POST // https://www.googleapis.com/upload/storage/v1/b/myBucket/o?uploadType=multipart HttpResponse resp = httpclient.execute(method); if (resp.getStatusLine().getStatusCode() != 200) { log.info("Google Server error returned " + resp.getStatusLine().getStatusCode() + ":" + resp.getStatusLine().getReasonPhrase()); String returned = EntityUtils.toString(resp.getEntity()); log.error(returned); return null; } HttpEntity entity = resp.getEntity(); JsonParser parser = new JsonParser(); String content = IOUtils.toString(entity.getContent()); JsonElement elem = parser.parse(content); if(product.get("ecwidid") == null) { product.setValue("ecwidid", elem.getAsJsonObject().get("id").getAsString()); } return elem.getAsJsonObject(); } private JsonObject createJsonObject(Product inProduct) { JsonObject json = new JsonObject(); json.addProperty("sku", inProduct.getId()); json.addProperty("description", inProduct.get("descrip")); json.addProperty("unlimited", true); if (inProduct.getRetailPrice() != null) { json.addProperty("compareToPrice", inProduct.getRetailPrice().doubleValue()); } if(inProduct.getYourPrice() != null) { json.addProperty("price", inProduct.getYourPrice().doubleValue()); } if(inProduct.get("ecwidid")!=null) { json.addProperty("id", inProduct.get("ecwidid")); } json.addProperty("isShippingRequired", false); json.addProperty("enabled", true); json.addProperty("name", inProduct.getName()); return json; } // private JsonObject createJsonObject(Category inCategory) { // // JsonObject json = new JsonObject(); // // json.addProperty("name", inCategory.getName()); // json.addProperty("description", inProduct.getDescription()); // json.addProperty("unlimited", true); // if (inProduct.getRetailPrice() != null) { // json.addProperty("price", inProduct.getRetailPrice().doubleValue()); // } // json.addProperty("isShippingRequired", false); // // json.addProperty("enabled", true); // json.addProperty("name", inProduct.getName()); // // return json; // // } public void syncOrders() throws Exception{ String url = getBaseUrl() + "/" + getStoreId() + "/orders?token=" + getAccessToken(); CloseableHttpClient httpclient; httpclient = HttpClients.createDefault(); HttpRequestBase httpmethod = null; httpmethod = new HttpGet(url); TestBench tm = getTestBench(); HttpResponse resp = httpclient.execute(httpmethod); if (resp.getStatusLine().getStatusCode() != 200) { log.info("Ecwid Server error returned " + resp.getStatusLine().getStatusCode()); } HttpEntity entity = resp.getEntity(); String content = IOUtils.toString(entity.getContent()); JsonParser parser = new JsonParser(); JsonElement elem = parser.parse(content); // log.info(content); JsonObject json = elem.getAsJsonObject(); JsonArray items = json.getAsJsonArray("items"); OrderSearcher searcher = (OrderSearcher) getMediaArchive().getSearcher("storeOrder"); UserSearcher um = (UserSearcher) getMediaArchive().getSearcher("user"); UserManager usermanager = (UserManager) getMediaArchive().getBean("userManager"); ProductSearcher products = (ProductSearcher) getMediaArchive().getSearcher("product"); for (Iterator iterator = items.iterator(); iterator.hasNext();) { JsonObject order = (JsonObject) iterator.next(); String email = order.get("email").getAsString(); JsonObject userdetails= null; if(order.get("shippingPerson") != null) { userdetails = order.get("shippingPerson").getAsJsonObject(); } if(userdetails == null) { userdetails = order.get("billingPerson").getAsJsonObject(); } User target = um.getUserByEmail(email); if(target == null) { target = (User) um.createNewData(); target.setEmail(email); target.setName(userdetails.get("name").getAsString()); target.setFirstName(userdetails.get("name").getAsString()); target.setPassword(new PasswordGenerator().generate()); target.setEnabled(true); um.saveData(target); tm.sendWelcomeEmail(target, ""); } target.setEnabled(true); JsonArray orderitems = order.get("items").getAsJsonArray(); for (Iterator iterator2 = orderitems.iterator(); iterator2.hasNext();) { JsonObject item = (JsonObject) iterator2.next(); String productid = item.get("sku").getAsString(); Product product = (Product) products.searchById(productid); // if(product == null) { // product = (Product) products.searchById("117"); //Test with PATI // } if(product != null) { String groupid = product.get("group"); if (groupid != null) { log.info("group property was set: " + groupid); Group group = usermanager.getGroup(groupid); if (group == null) { log.info("group did not exist - creating"); group = usermanager.createGroup(groupid,groupid); usermanager.saveGroup(group); } if (!target.isInGroup(group)) { log.info("saving data"); target.addGroup(group); } } String collegeid = product.get("college"); if (collegeid != null) { log.info("setting up college branding"); Group group = usermanager.getGroup(collegeid); if (group == null) { group = usermanager.createGroup(collegeid,collegeid); usermanager.saveGroup(group); } if (!target.isInGroup(group)) { target.addGroup(group); } target.setProperty("organization", collegeid); } Collection courses = product.getValues("classlist"); for (Iterator iterator3 = courses.iterator(); iterator3.hasNext();) { String courseid = (String) iterator3.next(); tm.addUserToClass(target.getUserName(),courseid,"student"); } } } } } private TestBench getTestBench() { if (fieldTestBench == null) { fieldTestBench = (TestBench) getModuleManager().getBean(getCatalogId(), "testBench"); } return fieldTestBench; } }