Ticket #76 (closed defect: fixed)

Opened 14 years ago

Last modified 14 years ago

数据接口-/yp/company_price_js4.jsp

Reported by: huangzhong Owned by:
Priority: major Milestone:
Component: 系统相关 Version: 6.0
Keywords: 接口整理 Cc:
Due Date: 31/01/2012

Description (last modified by huangzhong) (diff)

参数及默认值

area
areaID
areaTag:这三个都是地区(优先级从上到下)
productID:产品id
tagId:返回js的数据的显示位置的id
notjs:默认是以JS的格式显示,notjs:true是以HTML格式显示
time:浏览器缓存时间(单位为秒)

描述

显示型号对应的经销商及价格

用途及具体的传参

产品库终端页面(报价)中的全国报价及全国经销商 http://product.pconline.com.cn/notebook/lenovo/467274_price.html

缓存方式及时间

浏览器缓存:默认为3600秒
mc缓存:
js方式:7200秒
html:900秒

逻辑

只列出购买了该品牌广告的商家,点击更多才列出没有购买这个品牌广告的vip商家和免费商家,按商品最后更新时间降序排列

使用频率

每分钟44.63次

查询效率

比较慢,关联了一些没有用到的表(V_PP_AREA、V_PDL_PRODUCT)

涉及到的表

v_ent_product、ent_company、pdl_ad、pp_ad、V_PP_AREA、V_PDL_PRODUCT

备注

接口返回html数据,产品库使用r系统调用

Attachments

7601.png Download (38.9 KB) - added by huangzhong 14 years ago.

Change History

comment:1 Changed 14 years ago by huangzhong

  • Status changed from new to closed
  • Resolution set to fixed
  • Description modified (diff)

Changed 14 years ago by huangzhong

comment:2 Changed 14 years ago by huangzhong

  • Description modified (diff)

comment:3 Changed 14 years ago by huangzhong

  • Description modified (diff)
Note: See TracTickets for help on using tickets.