public function goodsByCate($cateID, $n = null, $start = null) { $cateObj = new CategoryModel(); $allCates = $cateObj->select(); $cateList = $cateObj->getCatTree($allCates, $cateID); $cateIDList = array($cateID); foreach ($cateList as $v) { $cateIDList[] = $v['cat_id']; } $instring = implode(',', $cateIDList); $sql = 'select goods_id,goods_name, shop_price, market_price, thumb_img, add_time, goods_img from ' . $this->table . ' where cat_id in (' . $instring . ') order by add_time desc'; if (is_numeric($n) && is_numeric($start)) { $sql .= ' limit ' . $start . ',' . $n; } $data = $this->db->getAll($sql); return $data; }
<?php define('ACC', true); require '../system/init.php'; //echo __ROOT__;exit; $cat = new CategoryModel(); $catlist = $cat->getList(); $cattree = $cat->getCatTree($catlist, 0); include __ROOT__ . 'view/admin/templates/goodsadd.html';
<?php /* 后台文件 Background entry file */ if (!defined('ACC')) { define('ACC', true); require '../system/init.php'; } // $cat = new CategoryModel(); $catelist = $cat->getList(); //print_r($catelist); $catetree = $cat->getCatTree($catelist, 0); //print_r($catetree); include __ROOT__ . 'view/admin/templates/catelist.html';
/* 栏目页。 */ define('ACC', true); require '../system/init.php'; $cateObj = new CategoryModel(); $goodsObj = new GoodsModel(); $catID = $_GET['cat_id']; $cateInfo = $cateObj->find($catID); if (!isset($cateInfo)) { header('Location: index.php'); } //树状导航 $allCates = $cateObj->select(); $cateList = $cateObj->getCatTree($allCates, 0, 1); //面包屑导航 $cateNav = $cateObj->getTree($allCates, $catID); //print_r($cateNav); //分页显示 $curPage = isset($_GET['page']) ? $_GET['page'] : 1; $goodsCnt = count($goodsObj->goodsByCate($catID)); $perPage = 4; $pageObj = new PaginationHelper($goodsCnt, $perPage, $curPage); $pageMenu = $pageObj->showPageMenu(); //取出栏目下的商品 $goodsList = $goodsObj->goodsByCate($catID, $perPage, ($curPage - 1) * $perPage); //浏览记录 if (isset($_COOKIE['goods_history'])) { $goods_history = _unserialize($_COOKIE['goods_history']); }