public function index()
{
$datas = D('test')->getPk();
$datas = Category::Fetch(array(1, 2, 3));
dump($datas);
$this->display();
}
public function index()
{
//首页轮播图片
$where['page_del'] = '0';
$where['column_id'] = '72';
$result = D('Page')->where($where)->order('page_sort ASC')->limit(3)->select();
foreach ($result as $k => $v) {
if ($k == '0') {
//显示第一张图片
$result[$k]['block'] = '1';
}
$result[$k]['page_summary'] = html_entity_decode($result[$k]['page_summary']);
}
$this->assign('indexImg', $result);
//案例
$m = D('Column')->order('column_sort ASC')->relation(true)->select();
$pid = Category::getChildsId($m, '76');
$pid[] = '76';
$where = null;
$where['product_del'] = '0';
$where['column_id'] = array('in', $pid);
$order = 'product_sort,product_createtime desc';
$result = D('Product')->where($where)->order($order)->limit(14)->relation(true)->select();
foreach ($result as $k => $v) {
$result[$k]['url'] = __APP__ . '/Product/detail/id/' . $v['id'];
}
$this->assign('productList', $result);
//新闻中心
$where = null;
$m = D('News');
$where['news_del'] = '0';
$where['column_id'] = '73';
$order = 'news_sort,news_addtime desc';
$result = D('News')->where($where)->order($order)->relation(true)->select();
foreach ($result as $k => $v) {
$result[$k]['url'] = __APP__ . '/News/detail/id/' . $v['id'];
}
$this->assign('newsList', $result);
//常见问题
$where = null;
$m = D('News');
$where['news_del'] = '0';
$where['column_id'] = '75';
$order = 'news_sort,news_addtime desc';
$result = D('News')->where($where)->order($order)->limit('3')->relation(true)->select();
foreach ($result as $k => $v) {
$result[$k]['url'] = __APP__ . '/News/detail/id/' . $v['id'];
}
$this->assign('cjwtList', $result);
$this->display();
}
/**
* 测试－用户模型
*/
public function lists()
{
$cid = I('cid', 0, 'intval');
$cate = get_category(1);
$self = Category::getSelf($cate, $cid);
//当前栏目信息
$patterns = array('/' . C('TMPL_TEMPLATE_SUFFIX') . '$/');
$replacements = array('');
$template_list = preg_replace($patterns, $replacements, $self['template_list']);
if (empty($template_list)) {
$this->error('模板不存在');
}
$this->assign('title', '专题首页');
$this->display($template_list);
}
/**
* 留言列表
* @date: 2015-12-30 上午02:11:24
* @author: zhouqg
* @param: variable
* @return:
*/
public function index()
{
// 搜索功能
$keyword = I('post.keyword');
if (!empty($keyword)) {
$where['message_title'] = array('like', "%{$keyword}%");
$this->assign('keyword', $keyword);
}
//栏目选择
$selColumn = I('post.selColumn');
if (!empty($selColumn) && $selColumn != '0') {
$where['column_id'] = $selColumn;
$this->assign('selColumn', $selColumn);
}
//获得栏目列表
$m = D('Column')->where(array('model_id' => $this->modelId))->order('column_sort ASC')->select();
$m = Category::unlimitedForLevel($m, ' ├─');
$this->assign('Column', $m);
$m = D('Message');
$where['message_del'] = '0';
$order = 'message_sort,message_addtime desc';
$result = D('Message')->where($where)->relation(true)->select();
//**分页实现代码
$count = count($result);
// 查询满足要求的总记录数
$Page = new \Think\Page($count, 15);
// 实例化分页类 传入总记录数和每页显示的记录数(20)
$show = $Page->show();
// 分页显示输出
$this->assign('page', $show);
// 赋值分页输出
$this->assign('count', $count);
// 赋值分页输出
//**分页实现代码
$result = D('Message')->where($where)->relation(true)->limit($Page->firstRow . ',' . $Page->listRows)->order($order)->select();
foreach ($result as $k => $v) {
$result[$k]['message_title'] = Common::substr_ext($v['message_title'], 0, 16, 'utf-8', "");
}
// dump($result);
// exit;
$this->assign('vlist', $result);
//赋值
$this->display();
}
/**
* 文章内容
* @date: 2016-2-01 上午06:49:55
* @author: zhouqg
* @param: variable
* @return:
*/
public function group()
{
//**分类id
$id = I('get.id');
if (!preg_match('/^\\d+$/i', $id)) {
$this->error('url参数错误');
exit;
//仿制用户恶意输出url参数
}
$m = D('Column')->order('column_sort ASC')->relation(true)->select();
$pid = Category::getChildsId($m, $id);
$pid[] = $id;
//列表
$where = null;
$where['product_del'] = '0';
$where['column_id'] = array('in', $pid);
$order = 'product_sort,product_createtime desc';
$result = D('Product')->where($where)->order($order)->relation(true)->select();
foreach ($result as $k => $v) {
$result[$k]['url'] = __APP__ . '/Product/detail/id/' . $v['id'];
}
$this->assign('productList', $result);
$this->display();
}
/**
* 修改单页
* @date: 2015-12-29 上午02:24:35
* @author: zhouqg
* @param: variable
* @return:
*/
public function edit()
{
$id = I('get.id');
$m = D('Page');
//读取数据库模型model文件，关联模型。
$arr = $m->relation(true)->find($id);
$arr['page_summary_decode'] = html_entity_decode($arr['page_summary']);
$arr['page_content_decode'] = html_entity_decode($arr['page_content']);
$this->assign('cate', $arr);
$m = D('Column')->where(array('model_id' => $this->modelId))->order('column_sort ASC')->select();
$m = Category::unlimitedForLevel($m, ' ├─');
$this->assign('column', $m);
$this->display();
}
/**
* 单页模型控制器方法
*/
public function group()
{
$id = I('get.id');
//类别ID
if (!preg_match('/^\\d+$/i', $id)) {
$this->error('url参数错误');
exit;
//仿制用户恶意输出url参数
}
// dump($id);
// exit;
//**获取当前栏目的信息
$topcate = D('Column')->where("id={$id}")->order('column_sort')->relation(true)->select();
foreach ($topcate as $k2 => $v2) {
$topcate[$k2]['column_content'] = htmlspecialchars_decode($v2['column_content']);
}
// dump($topcate);
// exit;
//获取当前栏目的名称
$column_name = $topcate[0]['column_name'];
$this->assign('vcolumn', $column_name);
// dump($column_name);
// exit;
if ($topcate == null) {
$this->error('参数错误');
}
$this->assign('blist', $topcate);
//****SEO信息
$title = $topcate[0]['column_name'];
$m = M('Config');
$data = $m->field('config_webname')->find();
//dump($data);
//exit;
$title = $title . ' - ' . $data['config_webname'];
//dump($title);
//exit;
$keywords = $topcate[0]['column_keyw'];
$description = $topcate[0]['column_descr'];
$this->assign('title', $title);
$this->assign('keywords', $keywords);
$this->assign('description', $description);
//dump($title);
//exit;
$if = $topcate[0]['f_id'];
if ($if == 0) {
//是父级栏目的情况
//**获取栏目的下级所有子栏目
import('Class.Category', APP_PATH);
//文件在当前项目目录下的class目录
$m = D('Column')->order('column_sort ASC')->relation(true)->select();
$m = Category::getChilds($m, $id);
//获取id所有的下级栏目的信息
//二级导航栏目的url，可根据手机站或pc站自动适配url
$modlu = __ACTION__;
strpos($modlu, "mobile");
if (strpos($modlu, "mobile") == '') {
//如果url中不存在mobile（不区分大小写）
//栏目url
foreach ($m as $k3 => $v3) {
$m[$k3]['url'] = __APP__ . '/' . $v3['url'] . '/' . group . '/' . 'id' . '/' . $v3['id'];
}
} else {
//栏目url
foreach ($m as $k3 => $v3) {
$m[$k3]['url'] = __APP__ . '/' . 'mobile' . '/' . $v3['url'] . '/' . group . '/' . 'id' . '/' . $v3['id'];
}
}
// var_dump($m);
// exit;
$this->assign('navlist', $m);
} else {
//是二级栏目的情况
//**获取栏目的上级所有子栏目
$m = D('Column')->order('column_sort ASC')->relation(true)->select();
//$m=Category::getChilds($m,$id);//获取id所有的下级栏目的信息
$m = Category::getParents($m, $id);
//获取id所有的下级栏目的信息
//**获取栏目父级id,并且查询下级所有子栏目
$cid = $m['0']['id'];
$m = D('Column')->order('column_sort ASC')->relation(true)->select();
$m = Category::getChilds($m, $cid);
//获取id所有的下级栏目的信息
//二级导航栏目的url，可根据手机站或pc站自动适配url
$modlu = __ACTION__;
strpos($modlu, "mobile");
if (strpos($modlu, "mobile") == '') {
//如果url中不存在mobile（不区分大小写）
//栏目url
foreach ($m as $k3 => $v3) {
$m[$k3]['url'] = __APP__ . '/' . $v3['url'] . '/' . group . '/' . 'id' . '/' . $v3['id'];
}
} else {
//栏目url
foreach ($m as $k3 => $v3) {
$m[$k3]['url'] = __APP__ . '/' . 'mobile' . '/' . $v3['url'] . '/' . group . '/' . 'id' . '/' . $v3['id'];
}
}
// var_dump($m);
// exit;
$this->assign('navlist', $m);
}
//**获取子栏目的上级栏目,全局导航
import('Class.Category', APP_PATH);
//文件在当前项目目录下的class目录
$m = D('Column')->order('column_sort ASC')->relation(true)->select();
$m = Category::getParents($m, $id);
//获取nv_id所有的上级栏目的信息
//全局导航栏目的url，可根据手机站或者pc站石洞适配url
$modlu = __ACTION__;
strpos($modlu, "mobile");
if (strpos($modlu, "mobile") == '') {
//如果url中不存在mobile（不区分大小写）
//栏目url
foreach ($m as $k3 => $v3) {
$m[$k3]['url'] = __APP__ . '/' . $v3['url'] . '/' . group . '/' . 'id' . '/' . $v3['id'];
}
} else {
//栏目url
foreach ($m as $k3 => $v3) {
$m[$k3]['url'] = __APP__ . '/' . 'mobile' . '/' . $v3['url'] . '/' . group . '/' . 'id' . '/' . $v3['id'];
}
}
// var_dump($m);
// exit;
$this->assign('topnavlist', $m);
//**全局导航 判断设置最后一个没有尖括号
$last = count($m) - 1;
$this->assign('last', $last);
//echo $last;
//exit;
$this->display();
}
/**
* 删除栏目处理
*/
public function delete()
{
//**判断是否有限权，显示登录管理员信息
$id = $_SESSION['id'];
//dump($id);
//exit;
$m = D('Admin');
$arr = $m->find($id);
$arr = $arr['admin_type'];
//dump($arr);
//exit;
if ($arr == 1) {
// 如果不是超级管理员限权
$this->error('你不是超级管理员，没有限权！');
}
//exit;
//**删除栏目下文章操作
//查询指定id的栏目信息
$id = I('get.id');
//类别ID
$topcate = M('Column')->where("id={$id}")->order('column_sort')->select();
//dump($topcate);
//exit;
//查询所有栏目的信息
$m = M('Column')->order('column_sort')->select();
//dump($m);
//exit;
//查询指定id的栏目下的所有文章
foreach ($topcate as $k => $v) {
$cids = Category::getChildsId($m, $v['id']);
//传递一个父级分类ID返回所有子分类ID
$cids[] = $v['id'];
//将父级id也压进来赋值给$cids
// dump($cids);
// exit;
//查询数据，没有分页
$where = array('nv_id' => array('IN', $cids));
//查询新闻表nv_id字段和$cids相等时的数据
//$News=('News');
$topcate[$k]['news'] = D('News')->field('id')->where($where)->where("news_dell=0")->select();
$result = $topcate[$k]['news'];
//查询新闻表下的所有文章 查询新闻数据赋值给字段news
}
//dump($result);
//exit;
//二维数组变一维数组
foreach ($result as $value) {
$new_id[] = $value['id'];
}
// dump($new_id);
// exit;
//删除栏目下的文章操作
$m = D('News');
//数据库表，配置文件中定义了表前缀，这里则不需要写
//判断id是数组还是一个数值
if (is_array($new_id)) {
$where = 'id in(' . implode(',', $new_id) . ')';
//implode() 函数返回一个由数组元素组合成的字符串
// dump($where);
// exit;
$data['news_dell'] = 1;
$count_News = $m->where($where)->save($data);
//批量删除至回收站
} else {
$where = 'id=' . $new_id;
}
/**
* 删除栏目及其子栏目操作
*/
$m = M('Column');
$id = I('get.id');
//dump($id);
//exit;
//查询指定id的栏目信息
$topcate = M('Column')->where("id={$id}")->order('column_sort')->select();
// dump($topcate);
// exit;
$m = M('Column')->order('column_sort')->select();
//查询指定id的栏目下的所有文章
foreach ($topcate as $k => $v) {
$id = Category::getChildsId($m, $v['id']);
//传递一个父级分类ID返回所有子分类ID
$id[] = $v['id'];
//将父级id也压进来赋值给$cids
}
// dump($id);
// exit;
//判断id是数组还是一个数值
if (is_array($id)) {
$where = 'id in(' . implode(',', $id) . ')';
//implode() 函数返回一个由数组元素组合成的字符串
} else {
$where = 'id=' . $id;
}
// dump($where);
// exit;
$count_Column = D('Column')->where($where)->delete();
//修改表单用save函数
//$count_Column=$m->where($where)->delete($id);
if ($count_Column > 0) {
$this->success('成功删除该栏目及所属文章', U('Category/index'), 6);
} else {
$this->error('删除失败');
}
}
/**
* 产品模型控制器方法
*/
public function group()
{
//**字符截取函数
import('Class.String', APP_PATH);
//文件在当前项目目录下的class目录
$id = I('get.id');
//类别ID
if (!preg_match('/^\\d+$/i', $id)) {
$this->error('url参数错误');
exit;
//仿制用户恶意输出url参数
}
//dump($id);
//exit;
$m = D('Column')->order('column_sort ASC')->relation(true)->find($id);
//获取当前栏目的名称
$column_name = $m['column_name'];
$this->assign('vcolumn', $column_name);
// dump($m);
// exit;
if ($m['f_id'] == 0) {
//**获取栏目的下级所有子栏目
$m = D('Column')->order('column_sort ASC')->relation(true)->select();
$m = Category::getChilds($m, $id);
//获取id所有的下级栏目的信息
} else {
//**获取栏目的上级所有子栏目
$m = D('Column')->order('column_sort ASC')->relation(true)->select();
//$m=Category::getChilds($m,$id);//获取id所有的下级栏目的信息
$m = Category::getParents($m, $id);
//获取id所有的下级栏目的信息
//**获取栏目父级id,并且查询下级所有子栏目
$cid = $m['0']['id'];
$m = D('Column')->order('column_sort ASC')->relation(true)->select();
$m = Category::getChilds($m, $cid);
//获取id所有的下级栏目的信息
}
// dump($m);
// exit;
//二级导航栏目的url，可根据手机站或pc站自动适配url
$modlu = __ACTION__;
strpos($modlu, "mobile");
if (strpos($modlu, "mobile") == '') {
//如果url中不存在mobile（不区分大小写）
//栏目url
foreach ($m as $k3 => $v3) {
$m[$k3]['url'] = __APP__ . '/' . $v3['url'] . '/' . group . '/' . 'id' . '/' . $v3['id'];
}
} else {
//栏目url
foreach ($m as $k3 => $v3) {
$m[$k3]['url'] = __APP__ . '/' . 'mobile' . '/' . $v3['url'] . '/' . group . '/' . 'id' . '/' . $v3['id'];
}
}
$this->assign('navlist', $m);
//var_dump($m);
//exit;
//**获取子栏目的上级栏目
import('Class.Category', APP_PATH);
//文件在当前项目目录下的class目录
$m = D('Column')->order('column_sort ASC')->relation(true)->select();
$m = Category::getParents($m, $id);
//获取nv_id所有的上级栏目的信息
//全局导航栏目的url，可根据手机站或者pc站石洞适配url
$modlu = __ACTION__;
strpos($modlu, "mobile");
if (strpos($modlu, "mobile") == '') {
//如果url中不存在mobile（不区分大小写）
//栏目url
foreach ($m as $k3 => $v3) {
$m[$k3]['url'] = __APP__ . '/' . $v3['url'] . '/' . group . '/' . 'id' . '/' . $v3['id'];
}
} else {
//栏目url
foreach ($m as $k3 => $v3) {
$m[$k3]['url'] = __APP__ . '/' . 'mobile' . '/' . $v3['url'] . '/' . group . '/' . 'id' . '/' . $v3['id'];
}
}
//var_dump($m);
//exit;
$this->assign('topnavlist', $m);
//**全局导航 判断设置最后一个没有尖括号
$last = count($m) - 1;
$this->assign('last', $last);
//echo $last;
//exit;
//**获取当前栏目的信息
$topcate = D('Column')->where("id={$id}")->order('column_sort')->relation(true)->select();
$this->assign('nav_list', $topcate);
//dump($topcate);
//exit;
if ($topcate == null) {
$this->error('参数错误');
}
$this->assign('blist', $topcate);
//****SEO信息
$title = $topcate[0]['column_name'];
$m = M('Config');
$data = $m->field('config_webname')->find();
//dump($data);
//exit;
$title = $title . ' - ' . $data['config_webname'];
//dump($title);
//exit;
$keywords = $topcate[0]['column_keyw'];
$description = $topcate[0]['column_descr'];
$this->assign('title', $title);
$this->assign('keywords', $keywords);
$this->assign('description', $description);
//dump($title);
//exit;
//**获取所有栏目的信息
import('Class.Category', APP_PATH);
$m = D('Column')->order('column_sort')->relation(true)->select();
//查询所有栏目的信息
//dump($m);
//exit;
//****查询指定id的栏目下的所有子栏目文章
foreach ($topcate as $k => $v) {
$cids = Category::getChildsId($m, $v['id']);
//传递一个父级分类ID返回所有子分类ID
$cids[] = $v['id'];
//将父级id也压进来赋值给$cids
//dump($cids);
//exit;
$where = array('nv_id' => array('IN', $cids));
//查询新闻表nv_id字段和$cids相等时的数据
$topcate[$k]['news'] = D('News')->where($where)->where("news_dell=0")->relation(true)->select();
$result = $topcate[$k]['news'];
//查询新闻表下的所有文章 查询新闻数据赋值给字段news
//**分页实现代码
$count = count($result);
// 查询满足要求的总记录数
$Page = new \Think\Page($count, C('PAGE_PRODUCT__HOME'));
// 实例化分页类 传入总记录数和每页显示的记录数(25)
$show = $Page->show();
// 分页显示输出
//**分页实现代码
//查询数据，实现分页
$where = array('nv_id' => array('IN', $cids));
//查询新闻表nv_id字段和$cids相等时的数据
$m = D('News');
$field = 'g.id,g.news_content,g.news_title,g.news_pic,g.news_sort';
$topcate[$k]['news'] = $m->alias('g')->join('LEFT JOIN tuzi_attr i ON i.id = g.news_type')->join('LEFT JOIN tuzi_column c ON c.id = g.nv_id')->field($field)->where($where)->where("news_dell=0")->order('news_sort,id desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$result = $topcate[$k]['news'];
//查询新闻表下的所有文章 查询新闻数据赋值给字段news
// dump($result);
// exit;
}
//循环过滤html src标签和截取中文函数 用于摘要简介 substr_ext函数写在commonaction.class.php中
foreach ($result as $k2 => $v2) {
$result[$k2]['news_content'] = $this->substr_ext($v2['news_content'], 0, 160, 'utf-8', "");
}
foreach ($result as $k2 => $v2) {
$result[$k2]['news_title'] = $this->substr_ext($v2['news_title'], 0, 220, 'utf-8', "");
}
foreach ($result as $k2 => $v2) {
$result[$k2]['news_pic'] = __ROOT__ . $v2['news_pic'];
}
//全局导航栏目的url，可根据手机站或者pc站石洞适配url
$modlu = __ACTION__;
strpos($modlu, "mobile");
if (strpos($modlu, "mobile") == '') {
//如果url中不存在mobile（不区分大小写）
//文章url
foreach ($result as $k3 => $v3) {
$result[$k3]['url'] = __APP__ . '/' . CONTROLLER_NAME . '/' . detail . '/' . 'id' . '/' . $v3['id'];
}
} else {
//文章url
foreach ($result as $k3 => $v3) {
$result[$k3]['url'] = __APP__ . '/' . 'mobile' . '/' . CONTROLLER_NAME . '/' . detail . '/' . 'id' . '/' . $v3['id'];
}
}
// dump($result);
// exit;
//**分页实现代码
$this->assign('page', $show);
// 赋值分页输出
//**分页实现代码
$this->assign('vlist', $result);
//dump($topcate);
//dump($result);
//exit;
$this->display();
}
/**
* 修改新闻
* @date: 2015-12-23 上午02:24:35
* @author: zhouqg
* @param: variable
* @return:
*/
public function edit()
{
$id = I('get.id');
$m = D('News');
//读取数据库模型model文件，关联模型。
$arr = $m->relation(true)->find($id);
$arr['news_content_decode'] = html_entity_decode($arr['news_content']);
$this->assign('cate', $arr);
$m = D('Column')->where(array('model_id' => $this->modelId))->order('column_sort ASC')->select();
$m = Category::unlimitedForLevel($m, ' ├─');
$this->assign('column', $m);
//读取原有属性的id 然后跟属性数据库的值对比 有则置值为1 没有则是0
$m = D('News');
//读取数据库模型model文件，关联模型。
$arr = $m->relation(true)->find($id);
$arr = $arr['child'];
foreach ($arr as $k => $v) {
$arr[$k] = $v['id'];
}
//文章属性
$attr = M('Attr')->where(array('model_id' => $this->modelId))->select();
foreach ($attr as $k => $v) {
if (in_array($v['id'], $arr)) {
$attr[$k]['access'] = '1';
} else {
$attr[$k]['access'] = '0';
}
}
$this->assign('attr', $attr);
$this->display();
}
/**
* 文章内容
* @date: 2016-2-01 上午06:49:55
* @author: zhouqg
* @param: variable
* @return:
*/
public function group()
{
//**分类id
$id = I('get.id');
if (!preg_match('/^\\d+$/i', $id)) {
$this->error('url参数错误');
exit;
//仿制用户恶意输出url参数
}
//新闻中心
$where = null;
$m = D('News');
$where['news_del'] = '0';
$where['column_id'] = $id;
$order = 'news_sort,news_addtime desc';
$result = D('News')->where($where)->order($order)->relation(true)->select();
//分页
$count = count($result);
// 查询满足要求的总记录数
$Page = getpage($count, '25');
$show = $Page->show();
// 分页显示输出
$this->assign('page', $show);
// 赋值分页输出
$result = D('News')->where($where)->order($order)->limit($Page->firstRow . ',' . $Page->listRows)->relation(true)->select();
foreach ($result as $k => $v) {
$result[$k]['url'] = __APP__ . '/News/detail/id/' . $v['id'];
}
$this->assign('newsList', $result);
//获取上下级栏目
$m = D('Column')->order('column_sort ASC')->relation(true)->select();
//$m=Category::getChilds($m,$id);//获取id所有的下级栏目的信息
$m = Category::getParents($m, $id);
//获取id所有的下级栏目的信息
foreach ($m as $k => $v) {
$m[$k]['url'] = __APP__ . '/News/group/id/' . $v['id'];
}
$this->assign('clist', $m);
//相关列表
$m = D('News');
$where['news_del'] = '0';
$where['id'] = array('neq', $id);
$order = 'news_sort,news_updatetime desc';
$list = $m->where($where)->order($order)->limit('10')->relation(true)->select();
foreach ($list as $k => $v) {
$list[$k]['url'] = __APP__ . '/News/detail/id/' . $v['id'];
}
$this->assign('vlist', $list);
$this->display();
}
/**
* 显示文章修改
*/
public function edit()
{
$id = I('get.id');
$m = D('News');
//读取数据库模型model文件，关联模型。
$arr = $m->relation(true)->find($id);
//dump($arr);
//exit;
//文章属性
$attr = M('Attr')->select();
$this->assign('flagtypelist', $attr);
//显示所属栏目
$m = M('Column')->order('column_sort ASC')->select();
$m = Category::unlimitedForLevel($m, ' ├─');
$this->assign('Columnlist', $m);
$this->assign('cate', $arr);
$this->display();
}
/**
* 显示回收站批量移动
*/
public function movetrach()
{
//dump($_POST);
//exit;
$id = I('post.id');
//dump($id);
//exit;
if ($id == null) {
$this->error('请选择删除项！');
}
$id_one = $id[0];
//dump($id_one);
//exit;
$m = D('News');
//读取数据库模型model文件，关联模型。
$arr = $m->relation(true)->find($id_one);
//dump($arr);
//exit;
//组合数组赋值给前台显示
$id = implode(',', $id);
$this->assign('data', $id);
//显示所属栏目
$m = M('Column')->order('column_sort ASC')->select();
$m = Category::unlimitedForLevel($m, ' ├─');
$this->assign('Columnlist', $m);
$this->assign('cate', $arr);
$this->display();
}
/**
* 删除栏目
* @date: 2015-12-24 上午07:59:22
* @author: zhouqg
* @param: variable
* @return:
*/
public function delete()
{
$m = D('Column');
$id = I('get.id');
if ($id == null) {
$this->error('请选择删除项！');
}
$m = D('Column')->order('column_sort ASC')->select();
$m = Category::getChilds($m, $id);
if (!empty($m)) {
$this->error('该栏目存在子栏目，不可删除！');
}
$m = D('News')->where("column_id={$id}")->select();
if (!empty($m)) {
$this->error('该栏目下有内容，请先删除所有内容（包括回收站）！');
}
$m = D('Column');
$count = $m->delete($id);
if ($count > 0) {
$this->success("删除成功！");
} else {
$this->error('删除失败！');
}
}
/**
* 显示文章修改
*/
public function edit()
{
$id = I('get.id');
$m = D('News');
//读取数据库模型model文件，关联模型。
$arr = $m->relation(true)->find($id);
$arr['news_showpic'] = __ROOT__ . $arr['news_pic'];
// dump($arr);
// exit;
$this->assign('cate', $arr);
//读取原有属性的id 然后跟属性数据库的值对比 有则置值为1 没有则是0
$m = D('News');
//读取数据库模型model文件，关联模型。
$arr = $m->relation(true)->find($id);
$arr = $arr['child'];
// dump($arr);
// exit;
foreach ($arr as $k2 => $v2) {
$arr[$k2] = $v2['id'];
}
// dump($arr);
// exit;
//文章属性
$attr = M('Attr')->select();
foreach ($attr as $k2 => $v2) {
if (in_array($v2['id'], $arr)) {
$attr[$k2]['access'] = '1';
} else {
$attr[$k2]['access'] = '0';
}
}
$this->assign('flagtypelist', $attr);
// dump($attr);
// dump($arr);
// exit;
//显示所属栏目
$m = M('Column')->order('column_sort ASC')->select();
$m = Category::unlimitedForLevel($m, ' ├─');
$this->assign('Columnlist', $m);
$this->display();
}
public function ifedit()
{
$id = I('get.id');
//dump($id);
$m = M('Column');
$arr = $m->find($id);
//dump($arr);
//exit;
if ($arr['column_ifimg'] == 1) {
$id = I('get.id');
//**获取栏目的下级所有子栏目
$m = D('Column')->select();
$m = Category::getChilds($m, $id);
//获取id所有的下级栏目的信息
//将二维数组变成一维数组
foreach ($m as $value) {
$data[] = $value['id'];
}
$data[] = $id;
//dump($data);
//exit;
$m = D('Column');
//数据库表，配置文件中定义了表前缀，这里则不需要写
//判断id是数组还是一个数值
if (is_array($data)) {
$where = 'id in(' . implode(',', $data) . ')';
//implode() 函数返回一个由数组元素组合成的字符串
} else {
$where = 'id=' . $data;
}
//dump($where);
//exit;
$date['column_ifimg'] = 0;
$count = $m->where($where)->save($date);
//修改表单用save函数
if ($count > 0) {
$this->success('关闭成功！');
} else {
$this->error('关闭失败！');
}
} else {
$id = I('get.id');
//**获取栏目的下级所有子栏目
$m = D('Column')->select();
$m = Category::getChilds($m, $id);
//获取id所有的下级栏目的信息
//将二维数组变成一维数组
foreach ($m as $value) {
$data[] = $value['id'];
}
$data[] = $id;
//dump($data);
//exit;
$m = D('Column');
//数据库表，配置文件中定义了表前缀，这里则不需要写
//判断id是数组还是一个数值
if (is_array($data)) {
$where = 'id in(' . implode(',', $data) . ')';
//implode() 函数返回一个由数组元素组合成的字符串
} else {
$where = 'id=' . $data;
}
//dump($where);
//exit;
$date['column_ifimg'] = 1;
$count = $m->where($where)->save($date);
//修改表单用save函数
if ($count > 0) {
$this->success('开启成功！');
} else {
$this->error('开启失败！');
}
}
}
