Activity.php
4.86 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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
<?php
/**
* tpshop
* ============================================================================
* * 版权所有 2015-2027 深圳搜豹网络科技有限公司，并保留所有权利。
* 网站地址: http://www.tp-shop.cn
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和使用 .
* 不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* $Author: IT宇宙人 2015-08-10 $
*/
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 Activity extends Base {
/**
* 商品详情页
*/
public function group(){
//form表单提交
C('TOKEN_ON',true);
$goodsLogic = new GoodsLogic();
$goods_id = I("get.id/d");
$group_buy_info = M('GroupBuy')->where(['goods_id'=>$goods_id,'start_time'=>['<=',time()],'end_time'=>['>=',time()]])->find(); // 找出这个商品
if(empty($group_buy_info))
{
$this->error("此商品没有团购活动",U('Home/Goods/goodsInfo',array('id'=>$goods_id)));
exit;
}
$goods = M('Goods')->where("goods_id", $goods_id)->find();
$goods_images_list = M('GoodsImages')->where("goods_id", $goods_id)->select(); // 商品 图册
$goods_attribute = M('GoodsAttribute')->getField('attr_id,attr_name'); // 查询属性
$goods_attr_list = M('GoodsAttr')->where("goods_id", $goods_id)->select(); // 查询商品属性表
// 商品规格 价钱 库存表 找出 所有 规格项id
$keys = M('SpecGoodsPrice')->where("goods_id", $goods_id)->getField("GROUP_CONCAT(`key` SEPARATOR '_') ");
if($keys)
{
$specImage = M('SpecImage')->where("goods_id = :goods_id and src != '' ")->bind(['goods_id'=>$goods_id])->getField("spec_image_id,src");// 规格对应的 图片表， 例如颜色
$keys = str_replace('_',',',$keys);
$sql = "SELECT a.name,a.order,b.* FROM __PREFIX__spec AS a INNER JOIN __PREFIX__spec_item AS b ON a.id = b.spec_id WHERE b.id IN($keys) ORDER BY a.order";
$filter_spec2 = DB::query($sql);
foreach($filter_spec2 as $key => $val)
{
$filter_spec[$val['name']][] = array(
'item_id'=> $val['id'],
'item'=> $val['item'],
'src'=>$specImage[$val['id']],
);
}
}
$spec_goods_price = M('spec_goods_price')->where("goods_id", $goods_id)->getField("key,price,store_count"); // 规格 对应 价格 库存表
M('Goods')->where("goods_id", $goods_id)->save(array('click_count'=>$goods['click_count']+1 )); // 统计点击数
$commentStatistics = $goodsLogic->commentStatistics($goods_id);// 获取某个商品的评论统计
$navigate_goods = navigate_goods($goods_id,1); // 面包屑导航
$point_rate = tpCache('shopping.point_rate');
$this->assign('point_rate', $point_rate);
$this->assign('group_buy_info',$group_buy_info);
$this->assign('spec_goods_price', json_encode($spec_goods_price,true)); // 规格 对应 价格 库存表
$this->assign('navigate_goods',$navigate_goods);
$this->assign('commentStatistics',$commentStatistics);
$this->assign('goods_attribute',$goods_attribute);
$this->assign('goods_attr_list',$goods_attr_list);
$this->assign('filter_spec',$filter_spec);
$this->assign('goods_images_list',$goods_images_list);
$this->assign('goods',$goods);
return $this->fetch();
}
/**
* 团购活动列表
*/
public function group_list()
{
$count = M('GroupBuy')->where(time()." >= start_time and ".time()." <= end_time ")->count();// 查询满足要求的总记录数
$Page = new Page($count,20);// 实例化分页类 传入总记录数和每页显示的记录数
$show = $Page->show();// 分页显示输出
$this->assign('page',$show);// 赋值分页输出
$list = M('GroupBuy')->where(time()." >= start_time and ".time()." <= end_time ")->limit($Page->firstRow.','.$Page->listRows)->select(); // 找出这个商品
$this->assign('list', $list);
return $this->fetch();
}
public function apply_shop()
{
if(IS_POST){
$data = I('post.');
$this->success('成功',U('activity/apply_shop'));
}
return $this->fetch();
}
}