项目

一般

简介

需求 #12374

由 叶振鹏 更新于 超过 5 年 之前

<p>相关接口：</p>

<p>os/OperationBanner/getOperationList&nbsp;<a href="http://xdebug.yishou.com/dist/project-api-list?project_id=1&amp;api_id=2740">http://xdebug.yishou.com/dist/project-api-list?project_id=1&amp;api_id=2740</a></p>

<p>os/OperationBanner/addOperation&nbsp;<a href="http://xdebug.yishou.com/dist/project-api-list?project_id=1&amp;api_id=2741">http://xdebug.yishou.com/dist/project-api-list?project_id=1&amp;api_id=2741</a></p>

<p>os/OperationBanner/getOperationInfo&nbsp;<a href="http://xdebug.yishou.com/dist/project-api-list?project_id=1&amp;api_id=2742">http://xdebug.yishou.com/dist/project-api-list?project_id=1&amp;api_id=2742</a></p>

<p>os/OperationBanner/editOperation&nbsp;<a href="http://xdebug.yishou.com/dist/project-api-list?project_id=1&amp;api_id=2743">http://xdebug.yishou.com/dist/project-api-list?project_id=1&amp;api_id=2743</a></p>

<p>os/OperationBanner/checkOperation&nbsp;<a href="http://xdebug.yishou.com/dist/project-api-list?project_id=1&amp;api_id=2744">http://xdebug.yishou.com/dist/project-api-list?project_id=1&amp;api_id=2744</a></p>

<p>相关sql：</p>

<pre>
CREATE TABLE `fmys_search_operation_banner` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT &#39;主键值&#39;,
`operation_name` varchar(20) NOT NULL DEFAULT &#39;&#39; COMMENT &#39;运维位名称&#39;,
`operation_type` tinyint(1) NOT NULL DEFAULT &#39;1&#39; COMMENT &#39;展示类型{1:竖版广告图运营位,2:横版推荐搜索关键词运营位,3:横版广告图运营位}&#39;,
`banner_id` int(11) unsigned NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;与module_banner绑定&#39;,
`show_position` smallint(5) unsigned NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;展示位置&#39;,
`status` tinyint(1) unsigned NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;审核状态{0:禁用,1:启用}&#39;,
`recommend_keyword` varchar(100) NOT NULL DEFAULT &#39;&#39; COMMENT &#39;横版推荐搜索关键词列表&#39;,
`create_time` int(11) unsigned NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;创建时间&#39;,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=&#39;搜索商品运营配置&#39;

CREATE TABLE `fmys_operation_keyword` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT &#39;主键id&#39;,
`operation_id` int(11) unsigned NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;与search_operation_banner绑定&#39;,
`keyword` varchar(20) NOT NULL DEFAULT &#39;&#39;,
`create_time` int(11) unsigned NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;创建时间&#39;,
PRIMARY KEY (`id`),
KEY `keyword` (`keyword`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=&#39;搜索商品运营搜索关键词&#39;</pre>

返回