老师:店铺列表开发时,点击二级店铺类别显示的结果和一级店铺类别一样
来源:9-7 店铺列表页前端的开发下
			philip_I
2018-11-29
前端结果:
代码:
shoplist.js:
$(function() {
var loading = false;
// 分页允许返回的最大条数,超过此数值,禁止访问后台
var maxItems = 999;
// 一页返回的最大条数
var pageSize = 3;
var listUrl = ‘/o2o/fronted/listshops’;
var searchDivUrl = ‘/o2o/fronted/listshopspageinfo’;
// 页码
var pageNum = 1;
var parentId = getQueryString(‘parentId’);
var areaId = ‘’;
var shopCategoryId = ‘’;
var shopName = ‘’;
// 加载店铺列表以及区域列表 
getSearchDivData();
// 预先加载pageSize *pageNum 条
addItems(pageSize, pageNum);
function getSearchDivData() {
    var url = searchDivUrl + '?' + 'parentId=' + parentId;
    $.getJSON(url,
            function(data) {
                if (data.success) {
                    var shopCategoryList = data.shopCategoryList;
                    var html = '';
                    html += '<a href="#" class="button" data-category-id=""> 全部类别  </a>';
                    shopCategoryList.map(function(item, index) {
                                html += '<a href="#" class="button" data-category-id='
                                        + item.shopCategoryId
                                        + '>'
                                        + item.shopCategoryName
                                        + '</a>';
                            });
                    $('#shoplist-search-div').html(html);
                    var selectOptions = '<option value="">全部街道</option>';
                    var areaList = data.areaList;
                    areaList.map(function(item, index) {
                        selectOptions += '<option value="'
                                + item.areaId + '">'
                                + item.areaName + '</option>';
                    });
                    $('#area-search').html(selectOptions);
                }
            });
}
function addItems(pageSize, pageIndex) {
    // 生成新条目的HTML
    var url = listUrl + '?' + 'pageIndex=' + pageIndex + '&pageSize='
            + pageSize + '&parentId=' + parentId + '&areaId=' + areaId
            + '&shopCategoryId=' + shopCategoryId + '&shopName=' + shopName;
    loading = true;
    alert("url:"+url);
    $.getJSON(url, function(data) {
        if (data.success) {
            maxItems = data.count;
            var html = '';
            data.shopList.map(function(item, index) {
                html += '' + '<div class="card" data-shop-id="'
                        + item.shopId + '">' + '<div class="card-header">'
                        + item.shopName + '</div>'
                        + '<div class="card-content">'
                        + '<div class="list-block media-list">' + '<ul>'
                        + '<li class="item-content">'
                        + '<div class="item-media">' + '<img src="'
                        + item.shopImg + '" width="44">' + '</div>'
                        + '<div class="item-inner">'
                        + '<div class="item-subtitle">' + item.shopDesc
                        + '</div>' + '</div>' + '</li>' + '</ul>'
                        + '</div>' + '</div>' + '<div class="card-footer">'
                        + '<p class="color-gray">'
                        + new Date(item.lastEditTime).Format("yyyy-MM-dd")
                        + '更新</p>' + '<span>点击查看</span>' + '</div>'
                        + '</div>';
            });
            $('.list-div').append(html);
            var total = $('.list-div .card').length;
            if (total >= maxItems) {
                // 异常加载提示符
                $('.infinite-scroll-preloader').hide();
            }else{
                $('.infinite-scroll-preloader').show();
            }
            pageNum += 1;
            loading = false;
            // 刷新页面,显示新加载的店铺
            $.refreshScroller();
        }
    });
}
// 下滑屏幕 自动进行分页搜索
$(document).on('infinite', '.infinite-scroll-bottom', function() {
    if (loading)
        return;
    addItems(pageSize, pageNum);
});
$('.shop-list').on('click', '.card', function(e) {
    var shopId = e.currentTarget.dataset.shopId;
    window.location.href = '/o2o/fronted/shopdetail?shopId=' + shopId;
});
$('#shoplist-search-div').on('click','.button',function(e) {
            if (parentId) {// 如果传递过来的是一个父类下的子类
                shopCategoryId = e.target.dataset.categoryId;
                alert('ID:'+shopCategoryId);
                if ($(e.target).hasClass('button-fill')) {
                    $(e.target).removeClass('button-fill');
                    shopCategoryId = '';
                } else {
                    $(e.target).addClass('button-fill').siblings().removeClass('button-fill');
                }
                $('.list-div').empty();
                pageNum = 1;
                addItems(pageSize, pageNum);
            } else {// 如果传递过来的父类为空,则按照父类查询
                parentId = e.target.dataset.categoryId;
                if ($(e.target).hasClass('button-fill')) {
                    $(e.target).removeClass('button-fill');
                    parentId = '';
                } else {
                    $(e.target).addClass('button-fill').siblings()
                            .removeClass('button-fill');
                }
                $('.list-div').empty();
                pageNum = 1;
                addItems(pageSize, pageNum);
                parentId = '';
            }
        });
$('#search').on('change', function(e) {
    shopName = e.target.value;
    $('.list-div').empty();
    pageNum = 1;
    addItems(pageSize, pageNum);
});
$('#area-search').on('change', function() {
    areaId = $('#area-search').val();
    $('.list-div').empty();
    pageNum = 1;
    addItems(pageSize, pageNum);
});
$('#me').click(function() {
    $.openPanel('#panel-right-demo');
});
$.init();
});
shopDao.xml:
<?xml version="1.0" encoding="UTF-8"?>
 
   
       
       
       
       
       
       
       
       
       
       
       
       
         
         
       
       
         
         
       
       
         
         
       
   
   
      SELECT
      s.shop_id,
      s.shop_name,
      s.shop_desc,
      s.shop_addr,
      s.phone,
      s.shop_img,
      s.priority,
      s.create_time,
      s.last_edit_time,
      s.enable_status,
      s.advice,
      a.area_id,
      a.area_name,
      sc.shop_category_id,
      sc.shop_category_name
      FROM
      tb_shop s,
      tb_area a,
      tb_shop_category sc
      
        
          and s.shop_category_id=#{shopCondition.shopCategory.shopCategoryId}
         
         
          and s.shop_category_id in(select shop_category_id from tb_shop_category
          WHERE parent_id = #{shopCondition.shopCategory.parent.shopCategoryId}) 
         
         
          and s.area_id=#{shopCondition.area.areaId}
         
         
          and s.shop_name like '%${shopCondition.shopName}%'
         
         
          and s.enable_status = #{shopCondition.enableStatus}
         
         
          and s.owner_id=#{shopCondition.owner.userId}
         
         AND
         s.area_id = a.area_id 
         AND
         s.shop_category_id = sc.shop_category_id 
      
      ORDER BY
      s.priority DESC
      LIMIT #{rowIndex},#{pageSize};
   
   
      SELECT
      count(1)
      FROM
      tb_shop s,
      tb_area a,
      tb_shop_category sc
      
        
          and s.shop_category_id=#{shopCondition.shopCategory.shopCategoryId}
         
         
          and s.shop_category_id in(select shop_category_id from tb_shop_category
          WHERE parent_id =#{shopCondition.shopCategory.parent.shopCategoryId}) 
         
         
          and s.area_id=#{shopCondition.area.areaId}
         
         
          and s.shop_name like '%${shopCondition.shopName}%'
         
         
          and s.enable_status = #{shopCondition.enableStatus}
         
         
          and s.owner_id=#{shopCondition.owner.userId}
         
         AND
         s.area_id = a.area_id 
         AND
         s.shop_category_id = sc.shop_category_id 
      
   
 
 数据库:
写回答
	1回答
- 
				
						翔仔
2018-11-30
同学好,其实解决这个问题不用靠猜,我看同学已经有很好的意识能够在前端打印当时传入的shopCategoryId以及parent了,既然做到这,也可以尝试进入到后端调试,看看最终后端console输出的sql语句是啥,然后分析下这个sql为什么会获取到一模一样的数据,之后修改下mapper即可解决,我的mapper如下
<select id="queryShopList" resultMap="shopMap"> SELECT s.shop_id, s.shop_name, s.shop_desc, s.shop_addr, s.phone, s.shop_img, s.priority, s.create_time, s.last_edit_time, s.enable_status, s.advice, a.area_id, a.area_name, sc.shop_category_id, sc.shop_category_name FROM tb_shop s, tb_area a, tb_shop_category sc <where> <if test="shopCondition.shopCategory != null and shopCondition.shopCategory.shopCategoryId != null"> and s.shop_category_id = #{shopCondition.shopCategory.shopCategoryId} </if> <if test="shopCondition.shopCategory != null and shopCondition.shopCategory.parent!=null and shopCondition.shopCategory.parent.shopCategoryId !=null"> and s.shop_category_id in (select shop_category_id from tb_shop_category WHERE parent_id = #{shopCondition.shopCategory.parent.shopCategoryId}) </if> <if test="shopCondition.area != null and shopCondition.area.areaId != null"> and s.area_id = #{shopCondition.area.areaId} </if> <if test="shopCondition.shopName != null"> and s.shop_name like '%${shopCondition.shopName}%' </if> <if test="shopCondition.enableStatus != null"> and s.enable_status = #{shopCondition.enableStatus} </if> <if test="shopCondition.owner != null and shopCondition.owner.userId != null"> and s.owner_id = #{shopCondition.owner.userId} </if> AND s.area_id=a.area_id AND s.shop_category_id = sc.shop_category_id </where> ORDER BY s.priority DESC LIMIT #{rowIndex},#{pageSize}; </select>012018-11-30 
相似问题