悬赏==问题1、搜索范围是商品 2、实时统计各省份商品数量 3、优化商品页面打开速度、优化商品检索响应速度

需求1：默认/其它情况下，搜索范围是商品

logo.htm

<div class="btn-group">
                        <button type="button" id="searchType" class="btn btn-default dropdown-toggle cus_btn " data-toggle="dropdown">
                            {if $do == 'goodslist'}商品
                            {elseif $do == 'tasklist'}求购
                            {elseif $do == 'sellerlist'}供应商
                            {elseif $do == 'pubtask'}商品
                            {else}
                            {if $task_open&&$shop_open}采购
                            {elseif !$task_open&&$shop_open}商品2
                            {/if}
                            {/if}
                        <span class="caret"></span>
                        </button>
                        <ul class="dropdown-menu" id="searchOption">
                            {if $task_open}
                            <li {if $do  == 'tasklist'}class="active"{/if}>
                                <a href="javascript:void(0);" rel="tasklist">求购</a>
                            </li>
                            {/if}
                            {if $shop_open}
                            <li {if $do  == 'goodslist'}class="active"{/if}>
                                <a href="javascript:void(0);" rel="goodslist">商品</a>
                            </li>
                            {/if}
                            <li {if $do  == 'sellerlist'}class="active"{/if}>
                                <a href="javascript:void(0);" rel="sellerlist">供应商</a>
                            </li>
                        </ul>
                    </div>

<script type="text/javascript">
        function searchlist(){
               var ky=$("#search").val();
               var searchvalue1=$("#searchOption li:first").hasClass('active');
               var searchvalue2=$("#searchOption li:eq(1)").hasClass('active');
            var searchvalue3=$("#searchOption li:eq(2)").hasClass('active');
            var ky=$("#search").val();
            if(searchvalue1==true){
                   search='1';
               }else if(searchvalue3==true){
                   search='3';
               }else{
                search='2';
            }
            $.post("index.php?do=searchlist&ky="+ky,{search:search},function(data){
                if(data){
                    $("#hotsearch").replaceWith(data);
                    $("#div_search_input").addClass('open');
                }else{
                    $("#hotsearch").hide();
                }

            })
             $("#searchOption>li").click(function(){
                   if($(this).hasClass('active')==true){
                       if($(this).text().contains('求购')){
                           $.post("index.php?do=searchlist&ky="+ky,{search:1},function(data){
                               $("#hotsearch").replaceWith(data);
                        })
                    }else if($(this).text().contains('供应商')){
                        $.post("index.php?do=searchlist&ky="+ky,{search:3},function(data){
                            $("#hotsearch").replaceWith(data);
                        })
                    }else{
                           $.post("index.php?do=searchlist&ky="+ky,{search:2},function(data){
                               $("#hotsearch").replaceWith(data);
                           })
                       }
                }
            });
        }
    </script>

需求2：实时统计各省份商品数量，数量为0的省份不显示

;tpl/default/goodslist.htm
;control/goodslist.php

{if $arrCountP1['$ky']}<a href="{$strUrl}&p=1" {if 1==$p} class="selected" {/if}>北京市($arrCountP1['$ky'])</a>{/if}
{if $arrCountP2['$ky']}<a href="{$strUrl}&p=2" {if 2==$p} class="selected" {/if}>天津市($arrCountP2['$ky'])</a>{/if}
{if $arrCountP3['$ky']}<a href="{$strUrl}&p=3" {if 3==$p} class="selected" {/if}>河北省($arrCountP3['$ky'])</a>{/if}
{if $arrCountP4['$ky']}<a href="{$strUrl}&p=4" {if 4==$p} class="selected" {/if}>山西省($arrCountP4['$ky'])</a>{/if}
{if $arrCountP5['$ky']}<a href="{$strUrl}&p=5" {if 5==$p} class="selected" {/if}>内蒙古($arrCountP5['$ky'])</a>{/if}
{if $arrCountP6['$ky']}<a href="{$strUrl}&p=6" {if 6==$p} class="selected" {/if}>辽宁省($arrCountP6['$ky'])</a>{/if}
{if $arrCountP7['$ky']}<a href="{$strUrl}&p=7" {if 7==$p} class="selected" {/if}>吉林省($arrCountP7['$ky'])</a>{/if}
{if $arrCountP8['$ky']}<a href="{$strUrl}&p=8" {if 8==$p} class="selected" {/if}>黑龙江省($arrCountP8['$ky'])</a>{/if}
{if $arrCountP9['$ky']}<a href="{$strUrl}&p=9" {if 9==$p} class="selected" {/if}>上海市($arrCountP9['$ky'])</a>{/if}
{if $arrCountP10['$ky']}<a href="{$strUrl}&p=10" {if 10==$p} class="selected" {/if}>江苏省($arrCountP10['$ky'])</a>{/if}
{if $arrCountP11['$ky']}<a href="{$strUrl}&p=11" {if 11==$p} class="selected" {/if}>浙江省($arrCountP11['$ky'])</a>{/if}
{if $arrCountP12['$ky']}<a href="{$strUrl}&p=12" {if 12==$p} class="selected" {/if}>安徽省($arrCountP12['$ky'])</a>{/if}
{if $arrCountP13['$ky']}<a href="{$strUrl}&p=13" {if 13==$p} class="selected" {/if}>福建省($arrCountP13['$ky'])</a>{/if}
{if $arrCountP14['$ky']}<a href="{$strUrl}&p=14" {if 14==$p} class="selected" {/if}>江西省($arrCountP14['$ky'])</a>{/if}
{if $arrCountP15['$ky']}<a href="{$strUrl}&p=15" {if 15==$p} class="selected" {/if}>山东省($arrCountP15['$ky'])</a>{/if}
{if $arrCountP16['$ky']}<a href="{$strUrl}&p=16" {if 16==$p} class="selected" {/if}>河南省($arrCountP16['$ky'])</a>{/if}
{if $arrCountP17['$ky']}<a href="{$strUrl}&p=17" {if 17==$p} class="selected" {/if}>湖北省($arrCountP17['$ky'])</a>{/if}
{if $arrCountP18['$ky']}<a href="{$strUrl}&p=18" {if 18==$p} class="selected" {/if}>湖南省($arrCountP18['$ky'])</a>{/if}
{if $arrCountP19['$ky']}<a href="{$strUrl}&p=19" {if 19==$p} class="selected" {/if}>广东省($arrCountP19['$ky'])</a>{/if}
{if $arrCountP20['$ky']}<a href="{$strUrl}&p=20" {if 20==$p} class="selected" {/if}>广西省($arrCountP20['$ky'])</a>{/if}
{if $arrCountP21['$ky']}<a href="{$strUrl}&p=21" {if 21==$p} class="selected" {/if}>海南省($arrCountP21['$ky'])</a>{/if}
{if $arrCountP22['$ky']}<a href="{$strUrl}&p=22" {if 22==$p} class="selected" {/if}>重庆市($arrCountP22['$ky'])</a>{/if}
{if $arrCountP23['$ky']}<a href="{$strUrl}&p=23" {if 23==$p} class="selected" {/if}>四川省($arrCountP23['$ky'])</a>{/if}
{if $arrCountP24['$ky']}<a href="{$strUrl}&p=24" {if 24==$p} class="selected" {/if}>贵州省($arrCountP24['$ky'])</a>{/if}
{if $arrCountP25['$ky']}<a href="{$strUrl}&p=25" {if 25==$p} class="selected" {/if}>云南省($arrCountP25['$ky'])</a>{/if}
{if $arrCountP26['$ky']}<a href="{$strUrl}&p=26" {if 26==$p} class="selected" {/if}>西藏($arrCountP26['$ky'])</a>{/if}
{if $arrCountP27['$ky']}<a href="{$strUrl}&p=27" {if 27==$p} class="selected" {/if}>陕西省($arrCountP27['$ky'])</a>{/if}
{if $arrCountP28['$ky']}<a href="{$strUrl}&p=28" {if 28==$p} class="selected" {/if}>甘肃省($arrCountP28['$ky'])</a>{/if}
{if $arrCountP29['$ky']}<a href="{$strUrl}&p=29" {if 29==$p} class="selected" {/if}>青海省($arrCountP29['$ky'])</a>{/if}
{if $arrCountP30['$ky']}<a href="{$strUrl}&p=30" {if 30==$p} class="selected" {/if}>宁夏省($arrCountP30['$ky'])</a>{/if}
{if $arrCountP31['$ky']}<a href="{$strUrl}&p=31" {if 31==$p} class="selected" {/if}>新疆($arrCountP31['$ky'])</a>{/if}
{if $arrCountP32['$ky']}<a href="{$strUrl}&p=32" {if 32==$p} class="selected" {/if}>台湾省($arrCountP32['$ky'])</a>{/if}
{if $arrCountP33['$ky']}<a href="{$strUrl}&p=33" {if 33==$p} class="selected" {/if}>香港($arrCountP33['$ky'])</a>{/if}
{if $arrCountP34['$ky']}<a href="{$strUrl}&p=34" {if 34==$p} class="selected" {/if}>澳门($arrCountP34['$ky'])</a>{/if}
{if $arrCountP35['$ky']}<a href="{$strUrl}&p=35" {if 35==$p} class="selected" {/if}>海外($arrCountP35['$ky'])</a>{/if}
{if $arrCountP36['$ky']}<a href="{$strUrl}&p=36" {if 36==$p} class="selected" {/if}>其他($arrCountP36['$ky'])</a>{/if}

$arrCountP1= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat like '$ky' and province =1  " );
$arrCountP2= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat like '$ky' and province =2  " );
$arrCountP3= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat like '$ky' and province =3  " );
$arrCountP4= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat like '$ky' and province =4  " );
$arrCountP5= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =5  " );
$arrCountP6= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =6  " );
$arrCountP7= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =7  " );
$arrCountP8= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =8  " );
$arrCountP9= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =9  " );
$arrCountP10= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =10  " );
$arrCountP11= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =11  " );
$arrCountP12= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =12  " );
$arrCountP13= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =13  " );
$arrCountP14= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =14  " );
$arrCountP15= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =15  " );
$arrCountP16= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =16  " );
$arrCountP17= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =17  " );
$arrCountP18= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =18  " );
$arrCountP19= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =19  " );
$arrCountP20= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =20  " );
$arrCountP21= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =21  " );
$arrCountP22= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =22  " );
$arrCountP23= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =23  " );
$arrCountP24= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =24  " );
$arrCountP25= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =25  " );
$arrCountP26= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =26  " );
$arrCountP27= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =27  " );
$arrCountP28= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =28  " );
$arrCountP29= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =29  " );
$arrCountP30= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =30  " );
$arrCountP31= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =31  " );
$arrCountP32= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =32  " );
$arrCountP33= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =33  " );
$arrCountP34= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =34  " );
$arrCountP35= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =35  " );
$arrCountP36= db_factory::get_count ( "select count(*) from " . TABLEPRE . "witkey_service where cat = '$ky' and province =36  " );

需求3：优化商品页面打开速度、优化商品检索响应速度

;control/goodslist.php

;tpl/default/goodslist.htm

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除
收藏举报

报告相同问题？

关注问题

商品省份归属统计，36行代码运行太慢，如何简化提速？ php sql 数据库
2022-03-09 21:50

回答 1 已采纳一个sql就能同时取出所有省份的统计数据，干哈分这么多？ select province, count(*) ct from " . TABLEPRE . "service where cat = '
【求助】mysql四表统计数量:统计中国各个省份安装企业站点数量 java mysql 有问必答
2021-05-11 14:47

回答 5 已采纳是按省份还是按城市统计?
SQL优化，报表类数据问题 sql
2016-11-15 03:28

回答 3 已采纳 SELECT province, count(DISTINCT city) AS cityNum, count(DISTINCT country) AS countryNum, count(DISTI
Java毕业设计：基于Springboot河北省地方特色商品销售商城网站系统毕业设计源代码作品和开题报告
2024-09-28 16:49

黄菊华老师的博客（2）比较法：通过对国内外有关课题系统的功能、相关技术、内容等方面进行比较分析，从而提出系统所存在的问题，并提出相应的解决措施（3）模拟法模拟法是先依照原型的主要特征，创设一个相似的模型，然后通过...
这个最多的省份及数量该怎么办呢？ python
2023-04-04 09:38

回答 1 已采纳注意，d这个列表，我是随便在网上找了一个，和你的那个不一定一样，你自己替换成你的 d = { "北京大学": "北京", "清华大学": "北京", "中国人民大学": "北
echarts地图问题[中国地图省份之间有空隙，是什么问题？怎么解决？]
2018-12-03 02:33

回答 3 已采纳最终还是靠我自己解决了。是 china.js 的问题，之前引用的是从 GitHub 上下载的，从CSDN 上重新下载一个替换就好了。链接：https://pan.baidu.com/s
js代码太臃肿了，求大神优化前端
2017-08-19 03:42

回答 3 已采纳 ``` 你的dom id起规则点，和返回的json键名称一致或者大部分一致，就可以通过each遍历赋值，如下面的，你的id第一个字母应该改小写c，和data一致，不要搞个大写，又要处理一便
Java毕业设计：基于Springboot湖南地方特产商品在线购物商城毕业设计源代码作品和开题报告
2024-09-23 20:08

黄菊华老师的博客 1：研究背景与意义湖南地方特产商品在线购物商城的研究背景和意义可以从以下几个方面进行详细阐述：研究背景地方特产资源丰富：湖南作为中国的一个重要省份，拥有丰富的自然资源和独特的地域文化，孕育了众多...
如何设计GIS迭代器求中国各省份的NDVI平均值 arcgis
2022-12-24 15:41

回答 3 已采纳首先，使用 ArcGIS 中的掩膜提取工具将中国各省份的 NDVI 数据提取出来。然后，使用 GIS 迭代器遍历每个省份的 NDVI 数据，计算每个省份的 NDVI 平均值。代码示例如下： # 引
1.任意输入十个存入列表，找出其中的最小值输出。2..存储着所有省份的列表，请让用户输入一个名称，判断该省份是否在这个列表中，如果在，输出某某省在该列表中，如果不在，输出某某省不在该列表中。. python
2022-11-01 17:33

回答 1 已采纳 list_num = [] for i in range(10): n = eval(input("请输入整数: ")) list_num.append(n) list_num.so
Java 学习，Mybatis连接数据库Mysql，做多表查询，查询省份province和对应城市city的信息，为什么输出的城市信息是重复的？ java mysql 数据库
2022-10-28 10:44

回答 1 已采纳
基于用户画像的商品推荐方案总结
2021-12-17 17:14

herosunly的博客 1. 方案一 1.1 赛题方案解析 1.1.1 赛题介绍 1.1.2 解题思路 1.1.3 数据探索性分析 1.1.4 CatBoost分析 1.1.5 Fasttext分析 1.1.6 数据分析小结 1.1.7 数据预处理 1.1.8 文本特征构造 1.1.9 算法模型 1.1.10 模型...
求中国各城市的OSM数据，后缀名必须是.OSM blender javascript 其他动画
2021-03-11 18:51

回答 1 已采纳 pbf文件下载：http://download.openstreetmap.fr/extracts/asia/china/ pbf转OSM文件软件：https://wiki.openstreetma
mysql商品查询,mysql基本查询
2021-03-18 01:27

weixin_39559750的博客 -- 简单查询-- 查询所有的商品SELECT * FROM product;-- 查询商品名和商品价格.SELECT pname,price FROM product;-- 查询价格,去掉重复值.SELECT DISTINCT price FROM product;-- 查询结果是表达式(运算查询)：将...
flink sql实战案例之商品销量实时统计
2020-04-02 15:19

无尴尬不青春的博客本文主要介绍如何通过flink sql的方式进行商品实时销量的统计。业务流程介绍： 1.使用otter采集业务库binlog数据输出到kafka 2.flink读取kafka数据进行商品销量统计 3.统计结果输出到mysql 4.下游业务系统直.....
没有解决我的问题, 去提问

问题事件

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
系统已结题 3月19日
关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
修改了问题 3月11日
关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
创建了问题 3月11日

悬赏问题

¥15 有人会用py或者r画这种图吗
¥15 MOD04_3K图像预处理
¥15 [VASP]关于超胞大小和k 点网格的收敛性测试
¥15 pip下载paddle2onnx离谱错误
¥60 db2move nlzxams import 导出db2备份数据报错
¥15 关于#python#的问题：全文总结功能咨询
¥15 俄罗斯方块中无法同时消除多个满行
¥15 使用gojs3.0，如何在nodeDataArray设置好text的位置，再go.TextBlock alignment中进行相应的改变
¥15 psfusion图像融合指标很低
¥15 银河麒麟linux系统如何修改/etc/hosts权限为777

悬赏==问题1、搜索范围是商品 2、实时统计各省份商品数量 3、优化商品页面打开速度、优化商品检索响应速度

0条回答 默认 最新

问题事件

悬赏问题

0条回答默认最新