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('开启失败!'); } } }