<?php// PC主页namespace app\index\controller;use think\Db;use think\Cache;use think\Session;use think\Controller;use app\shop\common\GuessGoods;class Zixun extends Controller{ public function index(){ /*获取文章模块*/ $news_actile = Db::table('destoon_article_menu')->select(); //资讯 $zixun = Db::table('destoon_article_'.$news_actile[0]['menu_id'])->order('hits desc')->limit(6)->select(); if(!empty($zixun)){ $zixun['menu_id'] = $news_actile[0]['menu_id']; $zixun['menu_name'] = $news_actile[0]['menu_name']; $zixun['article'] = $news_actile[0]['menu_zjm']; $zixun['pic'] = $news_actile[0]['picture']; } //服装 $fuzhuang = Db::table('destoon_article_'.$news_actile[1]['menu_id'])->order('hits desc')->limit(6)->select(); if(!empty($fuzhuang)){ $fuzhuang['menu_id'] = $news_actile[1]['menu_id']; $fuzhuang['menu_name'] = $news_actile[1]['menu_name']; $fuzhuang['article'] = $news_actile[1]['menu_zjm']; $fuzhuang['pic'] = $news_actile[1]['picture']; } //鞋子 $xiezi = Db::table('destoon_article_'.$news_actile[2]['menu_id'])->order('hits desc')->limit(6)->select(); if(!empty($xiezi)){ $xiezi['menu_id'] = $news_actile[2]['menu_id']; $xiezi['menu_name'] = $news_actile[2]['menu_name']; $xiezi['article'] = $news_actile[2]['menu_zjm']; $xiezi['pic'] = $news_actile[2]['picture']; } //美容 $meirong = Db::table('destoon_article_'.$news_actile[3]['menu_id'])->order('hits desc')->limit(6)->select(); if(!empty($meirong)){ $meirong['menu_id'] = $news_actile[3]['menu_id']; $meirong['menu_name'] = $news_actile[3]['menu_name']; $meirong['article'] = $news_actile[3]['menu_zjm']; $meirong['pic'] = $news_actile[3]['picture']; } //小商品 $xiaoshangping = Db::table('destoon_article_'.$news_actile[4]['menu_id'])->order('hits desc')->limit(6)->select(); if(!empty($xiaoshangping)){ $xiaoshangping['menu_id'] = $news_actile[4]['menu_id']; $xiaoshangping['menu_name'] = $news_actile[4]['menu_name']; $xiaoshangping['article'] = $news_actile[4]['menu_zjm']; $xiaoshangping['pic'] = $news_actile[4]['picture']; } //母婴 $muying = Db::table('destoon_article_'.$news_actile[5]['menu_id'])->order('hits desc')->limit(6)->select(); if(!empty($muying)){ $muying['menu_id'] = $news_actile[5]['menu_id']; $muying['menu_name'] = $news_actile[5]['menu_name']; $muying['article'] = $news_actile[5]['menu_zjm']; $muying['pic'] = $news_actile[5]['picture']; } //食品 $shipin = Db::table('destoon_article_'.$news_actile[6]['menu_id'])->order('hits desc')->limit(6)->select(); if(!empty($shipin)){ $shipin['menu_id'] = $news_actile[6]['menu_id']; $shipin['menu_name'] = $news_actile[6]['menu_name']; $shipin['article'] = $news_actile[6]['menu_zjm']; $shipin['pic'] = $news_actile[6]['picture']; } //代购 $daigou = Db::table('destoon_article_'.$news_actile[7]['menu_id'])->order('hits desc')->limit(6)->select(); if(!empty($daigou)){ $daigou['menu_id'] = $news_actile[7]['menu_id']; $daigou['menu_name'] = $news_actile[7]['menu_name']; $daigou['article'] = $news_actile[7]['menu_zjm']; $daigou['pic'] = $news_actile[7]['picture']; } //推荐 $tuijian = Db::table('destoon_article_'.$news_actile[0]['menu_id'])->order('addtime desc')->limit(10)->select(); if(!empty($tuijian)){ $tuijian['menu_id'] = $news_actile[0]['menu_id']; $tuijian['menu_name'] = $news_actile[0]['menu_name']; $tuijian['article'] = $news_actile[0]['menu_zjm']; $tuijian['pic'] = $news_actile[0]['picture']; } //焦点图 $pic_thumb = Db::table('destoon_article_'.$news_actile[0]['menu_id']) ->where('pic_thumb','0')->order('addtime desc')->limit(5)->select(); return $this->fetch('', [
'zixun' => $zixun,
'fuzhuang' => $fuzhuang,
'xiezi' => $xiezi,
'meirong' => $meirong,
'xiaoshangping' => $xiaoshangping,
'muying' => $muying,
'shipin' => $shipin,
'daigou' => $daigou,
'tuijian' => $tuijian,
'pic_thumb' => $pic_thumb, ]); } public function newslist(){ $get_id = $_GET['id']; $news_list = Db::table('destoon_article_'.$get_id)->order('addtime desc')->paginate(7); $menu_name = Db::table('destoon_article_menu')->where('menu_id',$get_id)->value('menu_name'); //排行 $news_order = Db::table('destoon_article_'.$get_id)->order('hits desc')->limit(10)->select(); //推荐 $news_tuijian = Db::table('destoon_article_'.$get_id)->where('thumb','neq','null')->order('addtime desc')->limit(5)->select(); $this->assign('id', $get_id);
$this->assign('news_order', $news_order);
$this->assign('news_tuijian', $news_tuijian);
$this->assign('menu_name', $menu_name);
$this->assign('list', $news_list); return $this->fetch(); } public function contents(){ $id = $_GET['id'];
$content = $_GET['content']; $list = Db::table('destoon_article_'.$content)->where('itemid',$id)->find(); $main = Db::table('destoon_article_data_'.$content)->where('itemid',$id)->value('content'); //排行 $news_order = Db::table('destoon_article_'.$content)->order('hits desc')->limit(10)->select(); //推荐 $news_tuijian = Db::table('destoon_article_'.$content)->where('thumb','neq','null')->order('addtime desc')->limit(5)->select(); $this->assign('content_id', $id);
$this->assign('id', $content); $this->assign('main', $main);
$this->assign('list', $list); $this->assign('news_order', $news_order); $this->assign('news_tuijian', $news_tuijian); return $this->fetch(); } public function show(){ $id = $_GET['id']; $content = $_GET['content']; $list = Db::table('destoon_article_'.$content)->where('itemid',$id)->find(); $main = Db::table('destoon_article_data_'.$content)->where('itemid',$id)->value('content'); //排行 $news_order = Db::table('destoon_article_'.$content)->order('hits desc')->limit(10)->select(); //推荐 $news_tuijian = Db::table('destoon_article_'.$content)->where('thumb','neq','null')->order('addtime desc')->limit(5)->select(); $this->assign('content_id', $id); $this->assign('id', $content); $this->assign('main', $main); $this->assign('list', $list); $this->assign('news_order', $news_order); $this->assign('news_tuijian', $news_tuijian); return $this->fetch(); } }