public function add() {
$category = new CategoryModel();
$data = $category->where( 'cid=0' )->select();
$this->assign('data', $data);
//var_dump('<pre>');
//var_dump( $category );
$this->display( 'add' );
}
public function getIndex()
{
$locale = config::get('app.locale');
$categories = CategoryModel::where('lang', '=', $locale)->get();
$data = array();
$cats = array();
foreach ($categories as $category) {
$indx = $category->id;
$cats[] = array('id' => (int) $category->id, 'name' => $category->name);
}
$data['post_categories'] = $cats;
$this->layout->nest('content', 'ravel::admin.content.posts.home', $data);
}
/**
* 分类编辑页面
*/
function edit()
{
//得到Get传来的Id
$cate_id = $_GET['id'];
$category = new CategoryModel();
//where语句
$where = array('id' => $cate_id);
//获得分类表数据库数据
$list = $category->where($where)->find();
$this->assign('clist', $list);
//获得单元表的所有单元
$sec = new SectionModel();
$list = $sec->select();
$this->assign('slist', $list);
$this->display();
}
/**
* 单元删除页面
*/
function del()
{
//因为删除一个单元，就要删除其手下的分类类别，而删除分类类别后就要删除该类别下面的文章
//所有必须使用关联操作来执行
//序列化主键Id为：1,2,3,...以便批量删除
$del_id = $_POST['del_id'];
$section_id = implode($del_id, ',');
//实例化
$section = new SectionModel();
$category = new CategoryModel();
$article = new ArticleModel();
$menu_items = new MenuItemModel();
//如果单元删除成功
if ($section->delete($section_id)) {
//删除下属分类以及分类下属文章
$where = array('sectionid' => array('in', $section_id));
//删除分类
$category->where($where)->delete();
//删除文章
$article->where($where)->delete();
//删除单元后删除菜单项中的单元
$menu_where = array('type_id' => array('in', $section_id), 'type' => 'Section');
$menu_items->where($menu_where)->delete();
$this->assign('jumpUrl', __URL__ . '/index');
$this->success('单元,菜单项以及所有相关文章类别已删除~~~~');
} else {
$this->assign('jumpUrl', __URL__ . '/index');
$this->error('删除失败~~~~' . $category->getError());
}
}
