<?php
/**
* Created by PhpStorm.
* User: hssh_win8.1
* Date: 2015/10/6
* Time: 20:19
* files: goodstrash.php
*/
require_once './common/include.php';
// 实例化数据库 注意 不是用bl_goods 是用 bl_cate
$mu = new ModelUser('bl_cate');
if (!isset($_GET['cate_id']) || intval($_GET['cate_id']) < 1) {
$cate_id = 1;
} else {
$cate_id = $_GET['cate_id'] + 0;
}
// 获取所有栏目
$res = $mu->select(array('cate_id', 'cate_name', 'parent_id'), "1 order by cate_id");
$catelist = ToolsInfClassify::ClassifyForOne($res);
//print_r($catelist);
// 获取该栏目下所有的子栏目
$allCateId = ToolsInfClassify::ChildrenId($res, $cate_id);
array_unshift($allCateId, $cate_id);
//print_r($allCateId);
// 获得cate_id栏目下的所有商品
$sql = "select g.* from bl_goods as g left join bl_cate as c on g.cate_id=c.cate_id where c.cate_id in (" . implode(',', $allCateId) . ') && g.is_delete=1';
$goodslist = $mu->getAll($sql);
require ROOT . 'view/admin/templates/goodstrash.html';
<?php
/**
* Created by PhpStorm.
* User: hssh_win8.1
* Date: 2015/10/4
* Time: 20:40
* file: cateadd.php 栏目添加
*/
require_once './common/include.php';
$mu = new ModelUser('bl_cate');
$sql = 'select * from bl_cate where 1 order by cate_id ';
$res = $mu->getAll($sql);
// 无限极分类 返回 一维数组
$catelist = ToolsInfClassify::ClassifyForOne($res);
require ROOT . 'view/admin/templates/cateadd.html';
<?php
/**
* Created by PhpStorm.
* User: hssh_win8.1
* Date: 2015/10/5
* Time: 13:02
*/
require_once './common/include.php';
$mu = new ModelUser('bl_cate');
$sql = "select c1.cate_id,c1.cate_name,c1.is_delete,c1.parent_id,c2.cate_name as parent_name from bl_cate as c1 left join bl_cate as c2 on c1.parent_id=c2.cate_id where c1.is_delete=1";
$catelist = $mu->getAll($sql);
//print_r($catelist);
require ROOT . 'view/admin/templates/catetrash.html';
