Erpgg.php
3.75 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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
<?php
/**
* tpshop
* ============================================================================
* * 版权所有 2015-2027 深圳搜豹网络科技有限公司，并保留所有权利。
* 网站地址: http://www.tpshop.cn
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和使用 .
* 不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* $Author: IT宇宙人 2015-08-10 $
*
* TPshop为照顾新手，让新手们都能读懂代码，将代码写的比较通俗易懂，不写太过高深代码。
*/
namespace app\home\controller;
use think\Controller;
use Think\Exception;
use think\Url;
use think\Config;
use think\Page;
use think\Verify;
use think\Db;
use think\Cookie;
use think\Cache;
class Erpgg extends Base {
public function _initialize() {
define('MODULE_NAME',$this->request->module()); // 当前模块名称是
define('CONTROLLER_NAME',$this->request->controller()); // 当前控制器名称
define('ACTION_NAME',$this->request->action()); // 当前操作名称是
define('PREFIX',C('database.prefix')); // 数据库表前缀
}
public function index(){
$stoid=I('stoid/d',0);
if (empty($stoid)) {
return $this->fetch();
}
//SELECT * from wxd_ad where store_id=1 and pid=601 and (intype=0 or (intype=2 and find_in_set('2192',pickup_listid)>0) or ad_Id not IN(SELECT ad_id from wxd_ad where store_id=1 and pid=601 and (intype=1 and find_in_set('2192',pickup_listid)>0)))
$getpickupid=I('pickupid');
$where="pid=601 and enabled = 1 and start_time <= " . time() ." and end_time >= " . time() . " and store_id=".$stoid;
$where1="";
if ($getpickupid)
{
/*--
$where1="(intype=0 or (intype=2 and find_in_set(".$getpickupid.",pickup_listid)>0) or ad_id not in(select ad_id from wxd_ad where $where and (intype=1 and find_in_set(".$getpickupid.",pickup_listid)>0) ))";--*/
$where1="(intype=0 or (intype=2 and find_in_set(".$getpickupid.",pickup_listid)>0) or (intype=1 and find_in_set(".$getpickupid.",pickup_listid)<=0))";
}
$adimg=M('ad')
->where($where)
->where($where1)
->order('orderby asc')
->select();
if (empty($adimg))
{
return $this->fetch();
}
$newimglist=array();
$ni=0;
foreach ($adimg as $k=>$v)
{
$adcodeimg=explode(',',$v['ad_code']);
$url_len = count($adcodeimg);
for ($i = 0; $i < $url_len; $i++) {
$newimglist[$ni]['ad_code']=$adcodeimg[$i];
$ni=$ni+1;
}
}
$this->assign('adimg',$newimglist);
return $this->fetch();
}
public function index1(){
$stoid=I('stoid/d',0);
if (empty($stoid)) {
return $this->fetch();
}
$adimg=M('ad')->where("pid=601 and enabled = 1 and start_time <= " . time() ." and end_time >= " . time() . " and store_id=".$stoid)->order('orderby asc')->select();
if (empty($adimg))
{
return $this->fetch();
}
$newimglist=array();
$ni=0;
foreach ($adimg as $k=>$v)
{
$adcodeimg=explode(',',$v['ad_code']);
$url_len = count($adcodeimg);
for ($i = 0; $i < $url_len; $i++) {
$newimglist[$ni]['ad_code']=$adcodeimg[$i];
$ni=$ni+1;
}
}
$this->assign('adimg',$newimglist);
return $this->fetch();
}
}