Channel.php
2.08 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
<?php
/**
* tpshop
* ============================================================================
* * 版权所有 2015-2027 深圳搜豹网络科技有限公司，并保留所有权利。
* 网站地址: http://www.tp-shop.cn
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和使用 .
* 不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* 2016-03-29
* @author 当燃
*/
namespace app\home\controller;
use app\home\logic\CartLogic;
use app\home\logic\GoodsLogic;
use think\AjaxPage;
use think\Controller;
use think\Url;
use think\Config;
use think\Page;
use think\Verify;
use think\Db;
class Channel extends Base {
public function index(){
$cat_id = I('id/d',1);
$channel_cate = $this->cateTrre[$cat_id]['tmenu'];
$sub_id = ''; $sub_goods = array();
foreach ($channel_cate as $k=>$val){
$channel_cate[$k]['hot_sub'] = array();
$tmp = 0;
foreach ($val['sub_menu'] as $v){
if($v['is_hot']==1 && $tmp<=1){
$channel_cate[$k]['hot_sub'][$tmp] = $v;//取两个热门三级分类
$tmp++;
}
$sub_id .= $v['id'].',';//三级分类ID集
}
}
//查询所有此频道三级分类商品
$sub_id_str = '('.trim($sub_id,',').')';
$sql = "select goods_id,cat_id,goods_name,shop_price,market_price from __PREFIX__goods where is_on_sale=1 and cat_id in $sub_id_str ";
$sub_goods_arr = DB::query($sql);
if($sub_goods_arr){
foreach ($sub_goods_arr as $val){
$sub_goods[$val['cat_id']][] = $val;//商品按分类分组
}
//商品归属到三级分类下sub_goods项
foreach ($channel_cate as $kk=>$vv){
foreach ($vv['sub_menu'] as $mk=>$vo){
$channel_cate[$kk]['sub_menu'][$mk]['sub_goods'] = empty($sub_goods[$vo['id']]) ? array() : $sub_goods[$vo['id']];
}
}
}
$this->assign('parent_name', $this->cateTrre[$cat_id]['name']);
$this->assign('channel_cate',$channel_cate);
return $this->fetch();
}
}