/** * 留言列表 * @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: 2015-12-23 上午09:21:48 * @author: zhouqg * @param: variable * @return: */ public function add() { //显示所属栏目 $id = I('get.id'); if (!$id) { $id = '0'; } $m = D('Column')->order('column_sort ASC')->select(); $m = Category::unlimitedForLevel($m, ' ├─'); //新闻栏目为1 $this->assign('cate', $m); $this->assign('pid', $id); //显示栏目所属模型 $m = M('Model')->select(); $this->assign('Modellist', $m); $m = D('Column'); //读取父类模型id $modelId = $m->find($id); $this->assign('modelId', $modelId['model_id']); $this->display(); }
/** * 栏目首页显示 */ public function index() { import('Class.Category', APP_PATH); //该文件放在APP所在目录下的Class目录,当前项目路径 $m = D('Column')->order('column_sort ASC', 'column_addtime ASC')->relation(true)->select(); $m = Category::unlimitedForLevel($m, ' ├─'); //关联查询模型的名字 foreach ($m as $k3 => $v3) { $url = $v3['url']; $mm = D('Model'); $data['model_table'] = $url; $arr = $mm->where($data)->select(); if ($v3['column_link'] == 1) { $m[$k3]['model_name'] = '<span style="color:#FF0000">外部链接</span>'; } if ($v3['column_link'] == 2) { $m[$k3]['model_name'] = '内部链接'; } if ($v3['column_link'] == 0) { $m[$k3]['model_name'] = $arr['0']['model_name']; } } //栏目链接重构 foreach ($m as $k3 => $v3) { if ($v3['column_link'] == 1) { $m[$k3]['url'] = ''; } if ($v3['column_link'] == 2) { $m[$k3]['url'] = ''; } if ($v3['column_link'] == 0) { $m[$k3]['url'] = __APP__ . '/' . MODULE_NAME . '/' . $v3['url'] . '/' . index . '/' . 'id' . '/' . $v3['id']; } } // dump($m); // exit; $this->assign('vlist', $m); $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(); }
/** * 修改新闻 * @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(); }
/** * 显示文章修改 */ 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(); }
/** * 显示文章修改 */ 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(); }