/** * 搜索结果 */ public function word() { if (!Q("post.word")) { $this->error("请输入搜索关键字!"); } $word = Q("post.word"); $where = "cnname like '%" . $word . "%'"; $db = K("video"); $video = $db->lists_select($where); $category = K("category"); $categorytop = $category->tops(); $this->assign("categorytop", $categorytop); $array = $category->select(); foreach ($video[0] as $key => $value) { $parentChannel = Data::parentChannel($array, $value["pid"]); foreach ($parentChannel as $v) { $video[0][$key]["cntitleF"] = $v["cntitle"]; $video[0][$key]["entitleF"] = $v["entitle"]; } } $this->assign("prefix", $this->upload_prefix()); $this->assign("video", $video[0]); $this->assign("page", $video[1]); $this->display(); }
/** * 解析记录 */ public function index() { $video = K("video")->field("vid,cnname,enname,uploadtime,py_video.cid,cntitle,entitle,pid,uid")->where(array("uid" => Q("session.uid")))->select(); $category = M("category")->select(); foreach ($video as $key => $value) { $parentChannel = Data::parentChannel($category, $value["pid"]); foreach ($parentChannel as $v) { $video[$key]["cntitleF"] = $v["cntitle"]; } } $this->assign("video", $video); $this->display(); }
public function index() { //组装地址后缀 if (!isset($_GET['s'])) { $this->formatUrl(); } //读取当前分类信息 $field = $this->db->getOne(Q('cate_id')); View::with('field', $field); //读取当前分类下的所有品牌 $brand = new \Home\Model\Brand(); $brandData = $brand->getRel(Q('cate_id')); View::with('brandData', $brandData); //读取该分类下所有商品对应的规格属性 $cateAttr = $this->assignCateAttr(); View::with('cateAttr', $cateAttr); //根据筛选条件分配商品信息 $goodsData = $this->getGoods(); View::with('goodsData', $goodsData); //全部商品分类 $cateData = $this->db->getChan(); // p($cateData); View::with('cateData', $cateData); //分配相关分类 $data = $this->db->getAll(); $d = Data::parentChannel($data, $_GET['cate_id'], 'cate_id', 'pid'); foreach ($d as $key => $v) { if ($v['pid'] == 0) { $cateRel = $this->db->getRel($v['cate_id']); } } View::with('cateRel', $cateRel); //最近浏览商品 $goods = new \Home\Model\Goods(); $viewData = $goods->recentView(); View::with('viewData', $viewData); //最新发布商品 $new = $goods->getNew(); View::with('new', $new); View::make($this->tpl . 'lists.html'); }
public function index() { //商品主要数据 $goodsData = $this->db->getOne(Q('goods_id')); if (!$goodsData) { echo '没有此商品记录'; exit; } View::with('goodsData', $goodsData); //最近浏览 $viewData = $this->db->recentView(); View::with('viewData', $viewData); //最新发布商品 $new = $this->db->getNew(); View::with('new', $new); //缩略图数据 $pics = new \Home\Model\Pics(); $picsData = $pics->getAll(Q('goods_id')); View::with('picsData', $picsData); //商品属性数据 $im_attr = Db::table('goods_attr ga')->join('shop_attr sa', 'ga.attr_id', '=', 'sa.attr_id')->where('goods_id', Q('goods_id'))->where('sa.attr_type', 2)->groupBy('sa.attr_id')->get(); View::with('im_attr', $im_attr); //取当前商品的全部规格属性 $goods_attr = Db::table('goods_attr')->where('goods_id', $goodsData['goods_id'])->get(); View::with('goods_attr', $goods_attr); //全部商品分类 $cate = new \Home\Model\Cate(); $cateData = $cate->getChan(); // p($cateData); View::with('cateData', $cateData); //分配相关分类 $data = $cate->getAll(); $d = Data::parentChannel($data, $goodsData['cate_id'], 'cate_id', 'pid'); foreach ($d as $key => $v) { if ($v['pid'] == 0) { $cateRel = $cate->getRel($v['cate_id']); } } View::with('cateRel', $cateRel); View::make($this->tpl . 'goods.html'); }
private function createHtml($aid) { $content = ContentViewModel::getInstance($this->mid)->getOne($aid); $html = new Html(); //内容静态 $html->content($content); //生成栏目 $category = Data::parentChannel($this->category, $content['cid']); //生成当前栏目 $html->relation_category($content['cid']); foreach ($category as $cat) { $html->relation_category($cat['cid']); } //生成首页 $html->index(); return true; }
public function delCategory($cid) { if (!$cid || !isset($this->category[$cid])) { $this->error = 'cid参数错误'; return false; } //如果存在子栏目不进行删除 if (M('category')->where(array('pid' => $cid))->find()) { $this->error = '请先删除子栏目'; return false; } $ContentModel = ContentModel::getInstance($this->category[$cid]['mid']); $ContentModel->where(array('cid' => $cid))->del(); //删除栏目权限 M("category_access")->where("cid={$cid}")->del(); //删除栏目 if ($this->del($cid)) { $html = new Html(); //生成首页 $html->index(); //更新父级栏目 $parentCategory = Data::parentChannel(S('category'), $cid); if (!empty($parentCategory)) { foreach ($parentCategory as $cat) { $html->relation_category($cat['cid']); } } //更新缓存 $this->updateCache(); return true; } else { $this->error = '删除失败'; return false; } }
} ?> </div> <!--内容主体--> <div class="content container"> <div class="row"> <div class="col-md-8"> <!--内容主体--> <div id="main"> <header>你的位置: <?php $sep = " > "; if (!empty($_REQUEST['cid'])) { $cat = cache("category"); $cat = array_reverse(Data::parentChannel($cat, $_REQUEST['cid'])); $str = "<a href='http://localhost/v5/plugin'>首页</a> > "; foreach ($cat as $c) { $str .= "<a href='" . Url::getCategoryUrl($c) . "'>" . $c['catname'] . "</a>" . $sep; } echo substr($str, 0, -strlen($sep)); } ?> </header> <div class="title"> <h2><?php echo $hdcms['title']; ?> </h2> <p>
/** * 生成所有父级栏目 * @param $cid * @return bool */ public function parent_category($cid) { $parent = Data::parentChannel($this->category, $cid); if (!$parent) { return; } foreach ($parent as $p) { $this->relation_category($p['cid']); } return true; }