Ticket #74 (closed 故障: fixed)

Opened 14 years ago

Last modified 14 years ago

查看频道文章是否跟产品关联的方法

Reported by: huangxianduan Owned by:
Priority: major Milestone:
Component: 产品库 Version: 报价库4.0
Keywords: 文章 Cc:
Due Date: 07/12/2011

Description (last modified by huangxianduan) (diff)

文章: http://apk.pconline.com.cn/heji/soft/1112/2608402.html
ulr最后的数字(2608402)就是文章的id,可以拿这个id查看cms的文章跟产品关联的关系表:

select * from tblarticleproduct t where t.article_id=2608402;

文章产品管联

  • 不用麻烦cms的同事,直接找DBA查看数据就可以知道文章跟产品的关联关系

Attachments

articleProduct.jpg Download (10.1 KB) - added by huangxianduan 14 years ago.
文章产品管联

Change History

Changed 14 years ago by huangxianduan

文章产品管联

comment:1 Changed 14 years ago by huangxianduan

  • Description modified (diff)

comment:2 Changed 14 years ago by huangxianduan

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

comment:3 Changed 14 years ago by huangxianduan

遇到编辑报障说产品关联的文章没同步时就可以用上面方法确认下文章是否真的与产品关联了

comment:4 Changed 14 years ago by yuanhuoqing

cms那边还提供一个接口jsp方便我们查询文章有没同步过来产品库,同步过来时的文章信息是怎样的,接口地址: http://cms.pconline.com.cn/service/getarticleproducts.jsp?op=getArticleProducts&aid=2610000

参数aid是文章id。如果接口返回信息为空是说明文章是没跟产品关联。

Last edited 14 years ago by yuanhuoqing (previous) (diff)
Note: See TracTickets for help on using tickets.