From fc0cc7e808f9228b39b1e6b9d29c5417f41dbcc4 Mon Sep 17 00:00:00 2001 From: yujian <yujian@123.com> Date: 星期五, 24 五月 2019 16:52:02 +0800 Subject: [PATCH] 删除 老版动态查询商品 关联yeshi_ec_taobao_goods 的sql --- fanli/src/main/java/com/yeshi/fanli/util/taobao/TaoKeApiUtil.java | 127 ++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 126 insertions(+), 1 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/util/taobao/TaoKeApiUtil.java b/fanli/src/main/java/com/yeshi/fanli/util/taobao/TaoKeApiUtil.java index 6a71e4c..56f444e 100644 --- a/fanli/src/main/java/com/yeshi/fanli/util/taobao/TaoKeApiUtil.java +++ b/fanli/src/main/java/com/yeshi/fanli/util/taobao/TaoKeApiUtil.java @@ -10,6 +10,7 @@ import org.yeshi.utils.taobao.TbImgUtil; import com.taobao.api.ApiException; +import com.yeshi.fanli.dto.taobao.TaoBaoShopInfoDTO; import com.yeshi.fanli.entity.taobao.RelateGoods; import com.yeshi.fanli.entity.taobao.SearchFilter; import com.yeshi.fanli.entity.taobao.TaoBaoGoodsBrief; @@ -26,6 +27,7 @@ import com.yeshi.fanli.tag.PageEntity; import com.yeshi.fanli.util.MoneyBigDecimalUtil; import com.yeshi.fanli.util.StringUtil; +import com.yeshi.fanli.util.TaoBaoConstant; import com.yeshi.fanli.util.TimeUtil; import net.sf.json.JSONArray; @@ -224,6 +226,8 @@ if (!StringUtil.isNullOrEmpty(item.optString("material_lib_type"))) goods.setMaterialLibType(item.optInt("material_lib_type")); + else + goods.setMaterialLibType(0); return goods; } @@ -1100,6 +1104,8 @@ goods.setZkPrice(new BigDecimal(item.optString("zk_final_price"))); goods.setAuctionUrl(item.optString("item_url")); goods.setPictUrl(item.optString("pict_url")); + goods.setSalesCount(item.optString("volume")); + goods.setUserType(item.optInt("user_type")); list.add(goods); } } @@ -1232,6 +1238,63 @@ return list; } + + /** + * 搴楅摵鎼滅储 + * + * @param key + * -搴楅摵鍚嶇О + * @param page + * -椤电爜 + * @return + */ + public static TaoBaoShopInfoDTO searchShop(String key, int page, int pageSize) { + TaoBaoShopInfoDTO dto = new TaoBaoShopInfoDTO(); + if (StringUtil.isNullOrEmpty(key)) + return dto; + + PageEntity pageEntity = new PageEntity(); + List<TaoBaoShopInfo> list = new ArrayList<>(); + Map<String, String> map = new HashMap<>(); + map.put("method", "taobao.tbk.shop.get"); + map.put("fields", "user_id,shop_title,shop_type,seller_nick,pict_url,shop_url"); + map.put("q", key); + map.put("page_size", pageSize + ""); + map.put("page_no", page + ""); + String resultStr = TaoKeBaseUtil.baseRequestForThreeTimes(map, true); + JSONObject resultDate = JSONObject.fromObject(resultStr); + if (resultDate.optJSONObject("tbk_shop_get_response") != null + && resultDate.optJSONObject("tbk_shop_get_response").optJSONObject("results") != null) { + JSONArray array = resultDate.optJSONObject("tbk_shop_get_response").optJSONObject("results") + .optJSONArray("n_tbk_shop"); + if (array != null) { + for (int i = 0; i < array.size(); i++) { + JSONObject item = array.optJSONObject(i); + TaoBaoShopInfo info = new TaoBaoShopInfo(); + info.setPictureUrl(item.optString("pict_url")); + info.setSellerNick(item.optString("seller_nick")); + info.setShopTitle(item.optString("shop_title")); + info.setShopType(item.optString("shop_type")); + info.setShopUrl(item.optString("shop_url")); + info.setUserId(item.optLong("user_id")); + list.add(info); + } + } + + JSONObject optJSONObject = resultDate.optJSONObject("tbk_shop_get_response"); + int totalResults = optJSONObject.getInt("total_results"); + int totalPage = totalResults % pageSize == 0 ? totalResults / pageSize : totalResults / pageSize + 1; + pageEntity.setTotalCount(totalResults); + pageEntity.setTotalPage(totalPage); + } + pageEntity.setPageIndex(page); + pageEntity.setPageSize(pageSize); + + dto.setListInfo(list); + dto.setPage(pageEntity); + return dto; + } + /** * TODO 鎸夎澶囩寽浣犲枩娆� * @@ -1660,8 +1723,10 @@ String itemLink = resultJSON.optString("item_url"); TaoBaoGoodsBrief goods = new TaoBaoGoodsBrief(); goods.setAuctionUrl(itemLink); - if (!StringUtil.isNullOrEmpty(resultJSON.optString("coupon_info"))) + if (!StringUtil.isNullOrEmpty(resultJSON.optString("coupon_info"))) { goods.setCouponLink(couponLink); + goods.setCouponInfo(resultJSON.optString("coupon_info")); + } String tkRate = resultJSON.optString("max_commission_rate"); if (!StringUtil.isNullOrEmpty(tkRate)) { goods.setTkRate(new BigDecimal(tkRate)); @@ -1693,6 +1758,50 @@ } } + + public static void taoKeContent() { + Map<String, String> map = new HashMap<>(); + map.put("method", "taobao.tbk.content.get"); + map.put("adzone_id",TaoBaoConstant.TAOBAO_SPECIAL_PID_DEFAULT.split("_")[3]); + map.put("type", "1"); + map.put("count", "100"); + + TaoKeAppInfo app = new TaoKeAppInfo(); + app.setAppKey(TaoBaoConstant.TAOBAO_AUTH_APPKEY); + app.setAppSecret(TaoBaoConstant.TAOBAO_AUTH_APPSECRET); + try { + JSONObject json = TaoKeBaseUtil.baseRequest(map,app); + System.out.println(json); + } catch (TaoKeApiException e) { + e.printStackTrace(); + } + } + + + public static void taoKeContentSource(String contentId,String source) { + Map<String, String> map = new HashMap<>(); + map.put("method", "taobao.tbk.dg.optimus.material"); + map.put("adzone_id",TaoBaoConstant.TAOBAO_SPECIAL_PID_DEFAULT.split("_")[3]); + map.put("page_size", "10"); + map.put("page_no", "1"); + map.put("content_id",contentId); + map.put("content_source", source); + map.put("material_id", "1"); + + + TaoKeAppInfo app = new TaoKeAppInfo(); + app.setAppKey(TaoBaoConstant.TAOBAO_AUTH_APPKEY); + app.setAppSecret(TaoBaoConstant.TAOBAO_AUTH_APPSECRET); + try { + JSONObject json = TaoKeBaseUtil.baseRequest(map,app); + System.out.println(json); + } catch (TaoKeApiException e) { + e.printStackTrace(); + } + } + + + // AA5ISJ @@ -1787,6 +1896,22 @@ goods.setPictUrlWhite(item.optString("white_image")); return goods; } + + public static void getShopGoodsList(Long shopId) + { + Map<String, String> map = new HashMap<>(); + map.put("method", "tmall.omni.pc.iteminfo.getbyshopid"); + map.put("shop_id",shopId+""); + TaoKeAppInfo app = new TaoKeAppInfo(); + app.setAppKey("24838852"); + app.setAppSecret("bc8265e2bf8d8115329d652f9d3d4cd8"); + try { + JSONObject json = TaoKeBaseUtil.baseRequest(map,app); + System.out.println(json); + } catch (TaoKeApiException e) { + e.printStackTrace(); + } + } } -- Gitblit v1.8.0