01 day

  1 <?php
  2 namespace Admin\Model;
  3 use Think\Model;
  4 class GoodsModel extends Model {
  5     
  6     protected $insertFields='goods_name,shop_price,is_on_sale,market_price,logo,goods_desc,brand_id,cat_id,type_id,promote_start_date,promote_end_date,promote_price,is_new,is_hos,is_best,sord,is_foot';
  7     protected $updateFields='id,goods_name,shop_price,is_on_sale,market_price,logo,goods_desc,brand_id,cat_id,type_id,promote_start_date,promote_end_date,promote_price,is_new,is_hos,is_best,sord,is_foot';
  8     
  9     protected $_validate = array(
 10         array('goods_name','require','商品名称不能为空',1,),
 11         array('shop_price','currency','商品价格必需为货币类型',1,),
 12         array('market_price','currency','市场价格必需为货币类型',1,),
 13         array('cat_id','currency','分类不能为空',1,),
 14     );
 15     
 16     protected function _before_insert(&$data, $options){
 17         if($_FILES['logo']['error']==0){
 18             $upload = new \Think\Upload();// 实例化上传类
 19             $upload->maxSize   =     1024*1024 ;// 设置附件上传大小
 20             $upload->exts      =     array('jpg', 'gif', 'png', 'jpeg');// 设置附件上传类型
 21             $upload->rootPath  =     './Public/Uploads/'; // 设置附件上传根目录
 22             $upload->savePath  =     'goods/'; // 设置附件上传（子）目录
 23             // 上传文件 
 24             $info   =   $upload->upload();
 25 //             var_dump($info);die;
 26             if(!$info) {// 上传错误提示错误信息
 27                 $this->error=$upload->getError();
 28                 return false;
 29             }else{// 上传成功
 30                 //原图片路径
 31                 $logo = $info['logo']['savepath'].$info['logo']['savename'];
 32                 //缩略图路径
 33                 $mbig_logo =  $info['logo']['savepath'].'mbig_'.$info['logo']['savename'];
 34                 $big_logo =  $info['logo']['savepath'].'big_'.$info['logo']['savename'];
 35                 $mid_logo =  $info['logo']['savepath'].'mid_'.$info['logo']['savename'];
 36                 $sm_logo =  $info['logo']['savepath'].'sm_'.$info['logo']['savename'];
 37                 $image = new \Think\Image();
 38                 $image->open('./Public/Uploads/'.$logo);
 39                 // 按照原图的比例生成一个最大为150*150的缩略图并保存为thumb.jpg
 40                 $image->thumb(700,700)->save('./Public/Uploads/'.$mbig_logo);
 41                 $image->thumb(300,300)->save('./Public/Uploads/'.$big_logo);
 42                 $image->thumb(150,150)->save('./Public/Uploads/'.$mid_logo);
 43                 $image->thumb(50,50)->save('./Public/Uploads/'.$sm_logo);
 44                 $data['logo'] = $logo;
 45                 $data['mbig_logo'] = $mbig_logo;
 46                 $data['big_logo'] = $big_logo;
 47                 $data['mid_logo'] = $mid_logo;
 48                 $data['sm_logo'] = $sm_logo;
 49             }
 50         }        
 51         $data['addtime'] = date('Y-m-d  H:i:s');
 52         $data['goods_desc'] = removeXSS($data['goods_desc']);
 53     }
 54     
 55     protected function _after_insert($data, $options){
 56         $id = $data['id'];
 57         /******************商品属性*********************/
 58         $goodsattr = I('post.attr_value_box');
 59         $gaModel = D('goods_attr');
 60         if($goodsattr){
 61             foreach ($goodsattr as $k=>$v){
 62                 $v = array_unique($v);
 63                 foreach ($v as $k1=>$v1){
 64                     if($v1=='')
 65                         continue;
 66                     $gaModel->add(array(
 67                         'attr_id'=>$k,
 68                         'goods_id'=>$id,
 69                         'attr_value'=>$v1
 70                     ));
 71                 }
 72             }
 73         }
 74         
 75         /******************扩展分类******************/
 76         $cbModle = D('category_box');
 77         $cib = I('post.cat_id_box');
 78         $cib = array_unique($cib);
 79         foreach ($cib as $k=>$v){
 80             if($v==0)
 81                 continue;
 82             $cbModle->add(array(
 83                 'cat_id'=>$v,
 84                 'goods_id'=>$id,
 85             ));
 86         }
 87         
 88         /***************商品相册*********************/
 89         $gpModle = D('goods_pic');
 90         if($_FILES['pic']){
 91             $pic = array();
 92             foreach ($_FILES['pic']['error'] as $k=>$v){
 93                 if($v != 0)
 94                     continue;
 95                 $pic[] = array(
 96                         'name'=>$_FILES['pic']['name'][$k],
 97                         'type'=>$_FILES['pic']['type'][$k],
 98                         'tmp_name'=>$_FILES['pic']['tmp_name'][$k],
 99                         'error'=>$v,
100                         'size'=>$_FILES['pic']['size'][$k],
101                 );
102             }
103             $_FILES = $pic;//$pic传得是文件;
104             foreach ($pic as $k=>$v){
105                 $upload = new \Think\Upload();// 实例化上传类
106                 $upload->maxSize   =     1024*1024 ;// 设置附件上传大小
107                 $upload->exts      =     array('jpg', 'gif', 'png', 'jpeg');// 设置附件上传类型
108                 $upload->rootPath  =     './Public/Uploads/'; // 设置附件上传根目录
109                 $upload->savePath  =     'goods_pic/'; // 设置附件上传（子）目录
110                 // 上传文件
111                 $info   =   $upload->upload(array($k=>$_FILES[$k]));
112                 if(!$info) {// 上传错误提示错误信息
113                     $this->error=$upload->getError();
114                     return false;
115                 }else{// 上传成功
116                     //原图片路径
117                     $pic = $info[$k]['savepath'].$info[$k]['savename'];
118                     //缩略图路径
119                     $big_pic =  $info[$k]['savepath'].'big_'.$info[$k]['savename'];
120                     $mid_pic =  $info[$k]['savepath'].'mid_'.$info[$k]['savename'];
121                     $sm_pic =  $info[$k]['savepath'].'sm_'.$info[$k]['savename'];
122                     $image = new \Think\Image();
123                     $image->open('./Public/Uploads/'.$pic);
124                     // 按照原图的比例生成一个最大为150*150的缩略图并保存为thumb.jpg
125                     $image->thumb(700,700)->save('./Public/Uploads/'.$big_pic);
126                     $image->thumb(300,300)->save('./Public/Uploads/'.$mid_pic);
127                     $image->thumb(50,50)->save('./Public/Uploads/'.$sm_pic);
128                     $gpModle->add(array(
129                         'goods_id'=>$id,
130                         'pic'=>$pic,
131                         'sm_pic'=>$sm_pic,
132                         'mid_pic'=>$mid_pic,
133                         'big_pic'=>$big_pic,
134                     ));
135                 }
136             }
137         }
138 
139         /***********会员价格*************/
140         $plData = I('post.price_level');
141         $mpModel = D('member_price');
142         if($plData){
143             foreach ($plData as $k=>$v){
144                 if($v<=0)
145                     continue;
146                 $mpModel->add(array(
147                     'price'=>$v,
148                     'level_id'=>$k,
149                     'goods_id'=>$id
150                 ));
151             }
152         }
153         
154     }
155     
156     protected function _before_update(&$data, $options){
157         $id = $options['where']['id'];
158         /******************商品属性******************/
159         $goodsattr = I('post.attr_value_box');
160         $goodsAttrId = I('post.goods_attr_id');
161         $gaModel = D('goods_attr');
162         $num = 0;
163         if($goodsattr){
164             foreach ($goodsattr as $k=>$v){
165                 foreach ($v as $k1=>$v1){
166                     if($goodsAttrId[$num]==""){
167                         $gaModel->add(array(
168                             'goods_id'=>$id,
169                             'attr_id'=>$k,
170                             'attr_value'=>$v1,
171                         ));
172                     }else{
173                         $gaModel->where(array(
174                             'id'=>$goodsAttrId[$num],
175                         ))->setField('attr_value',$v1);
176                     }
177                     $num++;
178                 }
179             }
180         }
181         
182         /******************扩展分类******************/
183         $cbModle = D('category_box');
184         $cib = I('post.cat_id_box');
185         if($cib){
186             $cbModle->where(array(
187                 'goods_id'=>$id,
188             ))->delete();
189             
190             $cib = array_unique($cib);
191             foreach ($cib as $k=>$v){
192                 if($v==0)
193                     continue;
194                 $cbModle->add(array(
195                         'cat_id'=>$v,
196                         'goods_id'=>$id,
197                 ));
198             }
199         }
200         /***************相册**********************/
201         $gpModle = D('goods_pic');
202             if($_FILES['pic']){
203                 $pic = array();
204                 foreach ($_FILES['pic']['error'] as $k=>$v){
205                     if($v != 0)
206                         continue;
207                     $pic[] = array(
208                             'name'=>$_FILES['pic']['name'][$k],
209                             'type'=>$_FILES['pic']['type'][$k],
210                             'tmp_name'=>$_FILES['pic']['tmp_name'][$k],
211                             'error'=>$v,
212                             'size'=>$_FILES['pic']['size'][$k],
213                     );
214                 }
215                 $_FILES = $pic;//$pic传得是文件;
216                 foreach ($pic as $k=>$v){
217                     $upload = new \Think\Upload();// 实例化上传类
218                     $upload->maxSize   =     1024*1024 ;// 设置附件上传大小
219                     $upload->exts      =     array('jpg', 'gif', 'png', 'jpeg');// 设置附件上传类型
220                     $upload->rootPath  =     './Public/Uploads/'; // 设置附件上传根目录
221                     $upload->savePath  =     'goods_pic/'; // 设置附件上传（子）目录
222                     // 上传文件
223                     $info   =   $upload->upload(array($k=>$_FILES[$k]));
224                     if(!$info) {// 上传错误提示错误信息
225                         $this->error=$upload->getError();
226                         return false;
227                     }else{// 上传成功
228                         //原图片路径
229                         $pic = $info[$k]['savepath'].$info[$k]['savename'];
230                         //缩略图路径
231                         $big_pic =  $info[$k]['savepath'].'big_'.$info[$k]['savename'];
232                         $mid_pic =  $info[$k]['savepath'].'mid_'.$info[$k]['savename'];
233                         $sm_pic =  $info[$k]['savepath'].'sm_'.$info[$k]['savename'];
234                         $image = new \Think\Image();
235                         $image->open('./Public/Uploads/'.$pic);
236                         // 按照原图的比例生成一个最大为150*150的缩略图并保存为thumb.jpg
237                         $image->thumb(700,700)->save('./Public/Uploads/'.$big_pic);
238                         $image->thumb(300,300)->save('./Public/Uploads/'.$mid_pic);
239                         $image->thumb(50,50)->save('./Public/Uploads/'.$sm_pic);
240                         $gpModle->add(array(
241                             'goods_id'=>$id,
242                             'pic'=>$pic,
243                             'sm_pic'=>$sm_pic,
244                             'mid_pic'=>$mid_pic,
245                             'big_pic'=>$big_pic,
246                         ));
247                     }
248                 }
249             }
250         
251         
252         
253         /***************相片**********************/
254         if($_FILES['logo']['error']==0){
255             $upload = new \Think\Upload();// 实例化上传类
256             $upload->maxSize   =     1024*1024 ;// 设置附件上传大小
257             $upload->exts      =     array('jpg', 'gif', 'png', 'jpeg');// 设置附件上传类型
258             $upload->rootPath  =     './Public/Uploads/'; // 设置附件上传根目录
259             $upload->savePath  =     'goods/'; // 设置附件上传（子）目录
260             // 上传文件
261             $info   =   $upload->upload();
262             //             var_dump($info);die;
263             if(!$info) {// 上传错误提示错误信息
264                 $this->error=$upload->getError();
265                 return false;
266             }else{// 上传成功
267                 //原图片路径
268                 $logo = $info['logo']['savepath'].$info['logo']['savename'];
269                 //缩略图路径
270                 $mbig_logo =  $info['logo']['savepath'].'mbig_'.$info['logo']['savename'];
271                 $big_logo =  $info['logo']['savepath'].'big_'.$info['logo']['savename'];
272                 $mid_logo =  $info['logo']['savepath'].'mid_'.$info['logo']['savename'];
273                 $sm_logo =  $info['logo']['savepath'].'sm_'.$info['logo']['savename'];
274                 $image = new \Think\Image();
275                 $image->open('./Public/Uploads/'.$logo);
276                 // 按照原图的比例生成一个最大为150*150的缩略图并保存为thumb.jpg
277                 $image->thumb(700,700)->save('./Public/Uploads/'.$mbig_logo);
278                 $image->thumb(300,300)->save('./Public/Uploads/'.$big_logo);
279                 $image->thumb(150,150)->save('./Public/Uploads/'.$mid_logo);
280                 $image->thumb(50,50)->save('./Public/Uploads/'.$sm_logo);
281                 $oldLogo = $this->field('logo,sm_logo,mid_logo,big_logo,mbig_logo')->find($id);
282                 unlink('./Public/Uploads/'.$oldLogo['logo']);
283                 unlink('./Public/Uploads/'.$oldLogo['sm_logo']);
284                 unlink('./Public/Uploads/'.$oldLogo['mid_logo']);
285                 unlink('./Public/Uploads/'.$oldLogo['big_logo']);
286                 unlink('./Public/Uploads/'.$oldLogo['mbig_logo']);
287                 $data['logo'] = $logo;
288                 $data['mbig_logo'] = $mbig_logo;
289                 $data['big_logo'] = $big_logo;
290                 $data['mid_logo'] = $mid_logo;
291                 $data['sm_logo'] = $sm_logo;
292             }
293         }
294         
295         /***************会员价格**********************/
296         $mpModel = D('member_price');
297         $plData = I('post.price_level');
298         if($plData){
299             $mpModel->where(array(
300                 'goods_id'=>$id,
301             ))->delete();
302             foreach ($plData as $k=>$v){
303                 if($v<=0)
304                     continue;
305                 $mpModel->add(array(
306                         'price'=>$v,
307                         'level_id'=>$k,
308                         'goods_id'=>$id
309                 ));
310             }
311         }
312         
313         
314         
315         /***************时间和描述XSS**********************/
316         $data['goods_desc'] = removeXSS($data['goods_desc']);
317     }
318     
319     /************一个分类id下包含子分类扩展分类所有的商品id*******/
320     public function getCatGOodsId($catId){
321         $catModel = D('Admin/Category');
322         $cats = $catModel->getchildCate($catId);//取出所有的子分类的id
323         $cats[] = $catId;
324         //取出商品id
325         $gId = $this->field('id')->where(array(
326             'cat_id'=>array('in',$cats),
327         ))->select();
328         //取出扩展分类
329         $cbModel = D('category_box');
330         $gIds = $cbModel->field('distinct goods_id id')->where(array(
331             'cat_id'=>array('in',$cats),
332         ))->select();
333         if($gId && $gIds){
334             $gId = array_merge($gId,$gIds);
335         }elseif ($gIds){
336             $gId = $gIds;
337         }
338         $arr = array();
339         foreach ($gId as $k=>$v){
340             if(!in_array($v['id'], $arr))
341                 $arr[] = $v['id'];
342         }
343         return $arr;
344     }
345     protected function _before_delete($options){
346         $id = $options['where']['id'];
347         /*****************库存量************************/
348         $gnModel = D('goods_number');
349         $gnModel->where(array(
350                 'goods_id'=>$id,
351         ))->delete();
352         /*****************商品属性************************/
353         $gaModel = D('goods_attr');
354         $gaModel->where(array(
355             'goods_id'=>$id,
356         ))->delete();
357         
358         /*****************扩展分类************************/
359         $cbModle = D('category_box');
360             $cbModle->where(array(
361                     'goods_id'=>$id,
362             ))->delete();
363         /***************商品相册*********************/
364         $gpModle = D('goods_pic');
365         $oldPic = $gpModle->field('pic,sm_pic,mid_pic,big_pic')
366                 ->where(array(
367                         'goods_id'=>$id,
368                 ))->select();
369         foreach ($oldPic as $k=>$v){
370             unlink('./Public/Uploads/'.$v['pic']);
371             unlink('./Public/Uploads/'.$v['sm_pic']);
372             unlink('./Public/Uploads/'.$v['mid_pic']);
373             unlink('./Public/Uploads/'.$v['big_pic']);
374         }
375         $gpModle->where(array(
376                 'goods_id'=>$id,
377         ))->delete();
378         
379         /***************会员价格**********************/
380         $mpModel = D('member_price');
381         $mpModel->where(array(
382                 'goods_id'=>$id,
383         ))->delete();
384         /***************相片**********************/
385         $oldLogo = $this->field('logo,sm_logo,mid_logo,big_logo,mbig_logo')->find($id);
386         unlink('./Public/Uploads/'.$oldLogo['logo']);
387         unlink('./Public/Uploads/'.$oldLogo['sm_logo']);
388         unlink('./Public/Uploads/'.$oldLogo['mid_logo']);
389         unlink('./Public/Uploads/'.$oldLogo['big_logo']);
390         unlink('./Public/Uploads/'.$oldLogo['mbig_logo']);
391     }
392     
393     public function search($pagecount=5){
394         $where = array();
395         //商品名称
396         $gn = I('get.gn');
397         if($gn)
398             $where['a.goods_name'] = array('like',"%$gn%");
399         //价格
400         $pt = I('get.pt');
401         $pf = I('get.pf');
402         if($pt && $pf)
403             $where['a.shop_price'] = array('between',array($pt,$pf));
404         elseif($pt)
405             $where['a.shop_price'] = array('egt',$pt);
406         elseif ($pf)
407             $where['a.shop_price'] = array('elt',$pf);
408         //时间
409         $tt = I('get.tt');
410         $tf = I('get.tf');
411         if($tt && $tf)
412             $where['a.addtime'] = array('between',array($tt,$tf));
413         elseif ($tt)
414             $where['a.addtime'] = array('eqt',$tt);
415         elseif ($tf)
416             $where['a.addtime'] = array('elt',$tf);
417         //上下架
418         $ios = I('get.ios');
419         if($ios)
420             $where['a.is_on_sale'] = array('eq',$ios);
421         //品牌
422         $bn = I('get.bn');
423         if($bn)
424             $where['a.brand_id'] = array('eq',$bn);
425         //分类
426         $catId = I('get.cat_id');
427 //         var_dump($catId);die;
428         if($catId>0){
429             $goodsId = $this->getCatGOodsId($catId);
430             $where['a.id'] = array('in',$goodsId);
431         }
432         
433         //排序
434         $paixu = I('get.paixu');
435         $name = 'id';
436         $pai = 'desc';
437         if($paixu){
438             if($paixu=='paixuIdasc')
439                 $pai = 'asc';
440             elseif ($paixu == 'paixuPricedesc')
441                 $name = 'shop_price';
442             elseif ($paixu == 'paixuPriceasc'){
443                 $name = 'shop_price';
444                 $pai = 'asc';
445             }
446         }
447         
448         $count  = $this->alias('a')->where($where)->count();// 查询满足要求的总记录数
449         $Page   = new \Think\Page($count,$pagecount);// 实例化分页类 传入总记录数和每页显示的记录数(25)
450                 $Page->setConfig('next','下一页');
451                 $Page->setConfig('prev','上一页');
452         $show  = $Page->show();// 分页显示输出
453         // 进行分页数据查询 注意limit方法的参数要使用Page类的属性
454         $list = $this->where($where)->limit($Page->firstRow.','.$Page->listRows)
455                 ->alias('a')
456                 ->field('a.*,b.brand_name,c.cat_name,GROUP_CONCAT(e.cat_name) cat_name_box')
457                 ->join('LEFT JOIN __BRAND__ b on a.brand_id=b.id')
458                 ->join('LEFT JOIN __CATEGORY__ c on a.cat_id=c.id')
459                 ->join('LEFT JOIN __CATEGORY_BOX__ d on a.id=d.goods_id')
460                 ->join('LEFT JOIN __CATEGORY__ e on e.id=d.cat_id')
461         ->order("$name $pai")
462         ->group('a.id')
463         ->select();
464         return array(
465         'data' =>$list,
466         'page'=>$show);
467     }
468     
469     
470     //取得促销价格信息;
471     public function zhuxiaoInfo(){
472         $date = date('Y-m-d H:i:s');
473         $data = $this->field('promote_price,goods_name,mid_logo,id')->where(array(
474             'promote_start_date'=>array('elt',$date),
475             'promote_end_date'=>array('egt',$date),
476             'promote_price'=>array('gt',0),
477             'is_on_sale'=>'是'
478         ))->order('sord asc')->limit(5)->select();
479         return $data;
480     }
481     
482     
483     
484     //取得热销信息
485     public function horBeseInfo($bnt){
486         $data = $this->field('shop_price,goods_name,mid_logo,id')->where(array(
487                 'shop_price'=>array('gt',0),
488                 "$bnt"=>array('eq','是'),
489                 'is_on_sale'=>'是'
490         ))->order('sord asc')->limit(5)->select();
491         return $data;
492     }
493 
494     
495     //计算最终价格
496     public function besePriceInfo($goods_id){
497         $level = session('level');
498         $date = date('Y-m-d H:i:s');
499         $promote_price = $data = $this->field('promote_price')->where(array(
500                 'promote_start_date'=>array('elt',$date),
501                 'promote_end_date'=>array('egt',$date),
502                 'promote_price'=>array('gt',0),
503                 'goods_id'=>$goods_id,
504                 'is_on_sale'=>'是'
505         ))->find();
506         //有没有登录
507         if($level){
508             //会员价格  登录了才有会员价格
509             $mpMdoel = D('member_price');
510             $mpData = $mpMdoel->where(array(
511                 'goods_id'=>$goods_id,
512                 'level_id'=>$level,
513                 'price'=>array('gt',0)
514             ))->find();
515             if($mpData){
516                 return min($promote_price['promote_price'],$mpData['price']);
517             }else{
518                 $gData = $this->field('shop_price')->where(array(
519                     'id'=>$goods_id,
520                 ))->find();
521                 return min($promote_price['promote_price'],$gData['shop_price']);
522             }
523         }else{
524             $gData = $this->field('shop_price')->where(array(
525                     'id'=>$goods_id,
526             ))->find();
527             if($promote_price['promote_price'])
528                 return min($promote_price['promote_price'],$gData['shop_price']);
529             else 
530                 return $gData['shop_price'];
531         }
532     }
533     
534     
535     public function getSearchInfo($Carid,$pagecount=4){
536         $GoodsId = $this->getCatGOodsId($Carid);//所有的商品id
537         $where['a.id']=array('in',$GoodsId);
538         /*************************品牌***************************/
539         $brandId = I('get.brand_id');
540         if($brandId){
541             $bid = strstr($brandId, '-');
542             $bId = str_replace($bid, '', $brandId);
543 //             $bId = (int)$brandId;
544             $where['a.brand_id'] = array('eq',$bId);
545         }
546         /*************************价格***************************/
547         $price = I('get.price');
548         if($price){
549             $pri = explode('-', $price);
550             $where['a.shop_price'] = array('between',array($pri[0],$pri[1]));
551         }
552         /*************************属性***************************/
553         $array = null;
554         foreach ($_GET as $k=>$v){
555             if(strpos($k,'attr_')===0){
556                 //属性id
557                 $attId = str_replace('attr_', '',$k);
558                 //属性值
559                 $attr_value = str_replace(strrchr($v,'-'),'',$v);
560                 
561                 $gaModel = D('goods_attr');
562                 $id = $gaModel->field('GROUP_CONCAT(goods_id) gids')->where(array(
563                     'attr_value'=>$attr_value,
564                     'attr_id'=>$attId,
565                 ))->find();
566                 //如果有商品id
567                 if($id['gids']){
568                     $id['gids'] = explode(',', $id['gids']);
569                     if($array == null)
570                         $array = $id['gids'];
571                     else{
572                         $array = array_intersect($array, $id['gids']);
573                         if(empty($array)){
574                             $where['a.id'] = array('eq',0);
575                             break;
576                         }
577                     }
578                 }else{
579                     $array = array();
580                     $where['a.id'] = array('eq',0);
581                     break;
582                 }
583             }
584         }
585         if($array)
586             $where['a.id'] = array('IN',$array);
587         
588         /***********************分页*****************************/
589         $count  = $this->alias('a')->where($where)->count();// 查询满足要求的总记录数
590         $Page   = new \Think\Page($count,$pagecount);// 实例化分页类 传入总记录数和每页显示的记录数(25)
591         $Page->setConfig('next','下一页');
592         $Page->setConfig('prev','上一页');
593         $data['pate']  = $Page->show();// 分页显示输出
594         /***********************数据*****************************/
595         $data['data'] = $this->alias('a')
596         ->field('a.id,a.goods_name,a.shop_price,a.mid_logo,a.id,sum(b.goods_number) X1')
597         ->join('LEFT JOIN __ORDER_GOODS__ b 
598                 on (a.id=b.goods_id 
599                 and 
600                 b.order_id in(select id from guo_order where pay_status="是"))')
601         ->group('a.id')
602         ->order('X1 desc')
603         ->where($where)->limit($Page->firstRow.','.$Page->listRows)
604         ->select();
605         return $data;
606     }
607 
608 }
公告

01 day
