/**
* 得到反馈信息列表
*
* @param xml
* @return
* @throws DocumentException
*/
public static List<TradingFeedBackDetail> getFeedBackListElement(String xml) throws Exception {
List<TradingFeedBackDetail> lifb = new ArrayList();
Document document = formatStr2Doc(xml);
Element rootElt = document.getRootElement();
Element recommend = rootElt.element("FeedbackDetailArray");
Iterator<Element> iter = recommend.elementIterator("FeedbackDetail");
while (iter.hasNext()) {
Element element = iter.next();
TradingFeedBackDetail tfbd = new TradingFeedBackDetail();
tfbd.setCommentinguser(element.elementText("CommentingUser"));
tfbd.setCommentinguserscore(Long.parseLong(element.elementText("CommentingUserScore")));
tfbd.setCommenttext(
StringEscapeUtils.escapeXml(element.element("CommentText").getStringValue()));
tfbd.setCommenttime(DateUtils.returnDate(element.elementText("CommentTime")));
tfbd.setCommenttype(element.elementText("CommentType"));
tfbd.setItemid(element.elementText("ItemID"));
tfbd.setRole(element.elementText("Role"));
tfbd.setFeedbackid(element.elementText("FeedbackID"));
tfbd.setTransactionid(element.elementText("TransactionID"));
tfbd.setOrderlineitemid(element.elementText("OrderLineItemID"));
tfbd.setItemtitle(element.elementText("ItemTitle"));
tfbd.setCreateTime(new Date());
if (element.elementText("ItemPrice") != null) {
tfbd.setItemprice(Double.parseDouble(element.elementText("ItemPrice")));
}
lifb.add(tfbd);
}
return lifb;
}
/**
* 通过Title 查询是相似分类信息
*
* @param xml
* @return
* @throws DocumentException
*/
public static List<TradingReseCategory> selectCategoryByKey(String xml) throws Exception {
List<TradingReseCategory> litrc = new ArrayList();
// 商品分类目录查询
Document document = formatStr2Doc(xml);
Element rootElt = document.getRootElement();
if (rootElt == null) {
return litrc;
}
Element recommend = rootElt.element("SuggestedCategoryArray");
if (recommend == null) {
return litrc;
}
Iterator<Element> ite = recommend.elementIterator("SuggestedCategory");
while (ite.hasNext()) {
Element ele = ite.next();
Element cate = ele.element("Category");
Element PercentItemFound = ele.element("PercentItemFound");
TradingReseCategory trc = new TradingReseCategory();
trc.setId(Long.parseLong(cate.elementText("CategoryID")));
trc.setCategoryId(cate.elementText("CategoryID"));
Iterator<Element> ites = cate.elementIterator("CategoryParentName");
String cateName = "";
while (ites.hasNext()) {
Element ent = ites.next();
cateName = cateName + ent.getText() + ":";
}
trc.setCategoryKey(PercentItemFound.getText() + "%");
trc.setCategoryName(cateName + cate.elementText("CategoryName"));
litrc.add(trc);
}
return litrc;
}
/**
* 通过Title 商品所属分类查询
*
* @param xml
* @param key
* @return
* @throws DocumentException
*/
public static List<TradingReseCategory> selectCategoryBytitle(String xml, String key)
throws Exception {
List<TradingReseCategory> litrc = new ArrayList();
// 之前是做商品所属分类查询
Document document = formatStr2Doc(xml);
Element rootElt = document.getRootElement();
Element recommend = rootElt.element("searchResult");
Iterator<Element> iter = recommend.elementIterator("item");
while (iter.hasNext()) {
Element ele = iter.next();
Element elecate = ele.element("primaryCategory");
TradingReseCategory trc = new TradingReseCategory();
trc.setId(Long.parseLong(elecate.elementText("categoryId")));
trc.setCategoryId(elecate.elementText("categoryId"));
trc.setCategoryName(StringEscapeUtils.escapeHtml(elecate.elementText("categoryName")));
trc.setCategoryKey(key);
litrc.add(trc);
}
return litrc;
}
/**
* 定时从在线商品中同步数据下来，行成在线数据
*
* @param xml
* @return
* @throws DocumentException
*/
public static List<TradingListingData> getItemListElememt(String xml, String ebayAccount)
throws Exception {
List li = new ArrayList();
Document document = formatStr2Doc(xml);
Element rootElt = document.getRootElement();
Element recommend = rootElt.element("ItemArray");
Iterator<Element> iter = recommend.elementIterator("Item");
String listType = "";
while (iter.hasNext()) {
TradingListingData item = new TradingListingData();
Element element = iter.next();
item.setTitle(StringEscapeUtils.escapeXml(element.elementText("Title")));
item.setItemId(element.elementText("ItemID"));
item.setSite(element.elementText("Site"));
item.setSku(element.elementText("SKU"));
item.setEbayAccount(ebayAccount);
if ("FixedPriceItem".equals(element.elementText("ListingType"))) {
if (element.element("Variations") != null) {
listType = "2";
} else {
listType = element.elementText("ListingType");
}
} else {
listType = element.elementText("ListingType");
}
item.setListingType(listType);
item.setPrice(
Double.parseDouble(element.element("SellingStatus").elementText("CurrentPrice")));
Element shippingdes = element.element("ShippingDetails");
if (shippingdes != null) {
List<Element> shippingit = shippingdes.elements("ShippingServiceOptions");
Element shippingOption = shippingit.get(0);
if (shippingOption != null) {
Element option = shippingOption.element("ShippingServiceCost");
if (option != null) {
item.setShippingPrice(Double.parseDouble(option.getText()));
} else {
item.setShippingPrice(0.00);
}
} else {
item.setShippingPrice(0.00);
}
} else {
item.setShippingPrice(0.00);
}
item.setQuantity(
Long.parseLong(element.elementText("Quantity"))
- Long.parseLong(element.element("SellingStatus").elementText("QuantitySold")));
item.setQuantitysold(
Long.parseLong(element.element("SellingStatus").elementText("QuantitySold")));
Element elflag = element.element("SellingStatus").element("ListingStatus");
if (elflag != null) {
if (elflag.getText().equals("Active")) {
item.setIsFlag("0");
} else {
item.setIsFlag("1");
}
} else {
item.setIsFlag("1");
}
item.setSubtitle("");
item.setBuyitnowprice(
Double.parseDouble(
element.element("ListingDetails").elementText("ConvertedBuyItNowPrice")));
item.setReserveprice(
Double.parseDouble(
element.element("ListingDetails").elementText("ConvertedReservePrice")));
item.setListingduration(element.elementText("ListingDuration"));
item.setStarttime(
DateUtils.returnDate(element.element("ListingDetails").elementText("StartTime")));
item.setEndtime(
DateUtils.returnDate(element.element("ListingDetails").elementText("EndTime")));
String url = element.element("PictureDetails").elementText("GalleryURL");
// item.setPicUrl(url.substring(0,url.lastIndexOf("_")+1)+"14"+url.substring(url.lastIndexOf(".")));
item.setPicUrl("http://thumbs.ebaystatic.com/pict/" + item.getItemId() + ".jpg");
li.add(item);
}
return li;
}