/**
  * 编辑
  */
 public function editAct()
 {
     $id = intval(I("id"));
     if (IS_POST) {
         $check = D('WstSort')->where(array('sortdir' => $_POST['sortdir'], 'sortid' => array('neq', $id)))->select();
         if ($check) {
             $this->error('目录已经被其他分类使用');
         }
         $tid = D('WstSort')->where(array('sortid' => $_POST['parentid']))->getField('parentid');
         $tid = $tid ? $tid : 0;
         $_POST['treedid'] = $tid;
         $data = string_utf8_to_gb2312($_POST);
         if ($data) {
             $result = D("WstSort")->where(array('sortid' => $id))->save($data);
             if ($result) {
                 $this->success("修改成功!");
             } else {
                 $this->error("修改失败!");
             }
         } else {
             $this->error('修改失败');
         }
     } else {
         $info = D('WstSort')->getOneData($id);
         $this->assign('info', $info);
         $fenlei = D('WstSort')->getsort();
         $this->assign('fenlei', $fenlei);
         $chushi = D('WstScks')->getChushi();
         $this->assign('chushi', $chushi);
         $gkml = D('WstGkml')->getGkml();
         $this->assign('gkml', $gkml);
         $this->assign('actionName', ACTION_NAME);
     }
     $this->display('Category:add');
 }
 /**
  * 机构资料管理
  */
 public function dataList($page, $pagesize, $postData)
 {
     if ($postData['scxm']) {
         $cond['a.scxm'] = array('like', '%' . string_utf8_to_gb2312($postData['scxm']) . '%');
     }
     $cond['a.dellzt'] = 0;
     //$cond['xmlb']     = 1;
     //$cond['isshtml']  = 1;
     $count = $this->table(self::WST_WZNR . ' a')->where($cond)->count();
     $result = $this->table(self::WST_WZNR . ' a')->where($cond)->field('a.*')->order('a.id ASC')->limit($page, $pagesize)->select();
     $result = string_gb2312_to_utf8($result);
     $array['count'] = $count ? $count : 0;
     $array['data'] = $result;
     return $array;
 }
 /**
  * 链接管理
  */
 public function dataList($page, $pagesize, $postData)
 {
     if ($postData['linkname']) {
         $cond['a.linkname'] = array('like', '%' . string_utf8_to_gb2312($postData['linkname']) . '%');
     }
     //$cond['scksid'] = 1;
     $count = $this->table(self::WST_LINK . ' a')->where($cond)->count();
     $result = $this->table(self::WST_LINK . ' a')->where($cond)->field('a.*')->order('a.uptime DESC')->limit($page, $pagesize)->select();
     $result = string_gb2312_to_utf8($result);
     foreach ($result as $k => $v) {
         $result[$k]['class'] = self::$classify[$v['scfl']];
     }
     $array['count'] = $count ? $count : 0;
     $array['data'] = $result;
     return $array;
 }
 public function chushiList($page, $pagesize, $postData)
 {
     $tbWstWznr = \Hgtlin\Model\WstWznrModel::WST_WZNR;
     if ($postData['real_name']) {
         $cond['a.name'] = array('like', '%' . string_utf8_to_gb2312($postData['real_name']) . '%');
     }
     $count = $this->table(self::WST_SCKS . ' a')->join('left join ' . $tbWstWznr . ' b ON a.wznrid=b.id')->where($cond)->count();
     $result = $this->table(self::WST_SCKS . ' a')->join('left join ' . $tbWstWznr . ' b ON a.wznrid=b.id')->where($cond)->field('a.*,b.scxm')->order('a.id DESC')->limit($page, $pagesize)->select();
     $result = string_gb2312_to_utf8($result);
     foreach ($result as $k => $v) {
         //$result[$k]['rightsName'] = self::$rights[$v['rights']];
     }
     $array['count'] = $count ? $count : 0;
     $array['data'] = $result;
     return $array;
 }
 /**
  * 栏目申请表
  */
 public function dataList($page, $pagesize, $postData)
 {
     if ($postData['sqtime']) {
         $cond['a.sqtime'] = array('like', '%' . $postData['sqtime'] . '%');
     }
     if ($postData['name']) {
         $cond['a.name'] = array('like', '%' . string_utf8_to_gb2312($postData['name']) . '%');
     }
     if ($postData['code']) {
         $cond['a.code'] = array('like', '%' . $postData['code'] . '%');
     }
     $count = $this->table(self::WST_GKMLSQB . ' a')->where($cond)->count();
     $result = $this->table(self::WST_GKMLSQB . ' a')->where($cond)->field('a.*')->order('a.id DESC')->limit($page, $pagesize)->select();
     $result = string_gb2312_to_utf8($result);
     $array['count'] = $count ? $count : 0;
     $array['data'] = $result;
     return $array;
 }
 public function ArticleList($page, $pagesize, $postData)
 {
     if ($postData['card_type']) {
         if ($postData['card_type'] == 1) {
             $cond['visible'] = 1;
         } elseif ($postData['card_type'] == 2) {
             $cond['tuiji'] = 1;
         } else {
         }
     }
     if ($postData['sortid']) {
         $cond['sortid'] = $postData['sortid'];
     }
     if ($postData['title']) {
         $cond['title'] = array('like', '%' . string_utf8_to_gb2312($postData['title']) . '%');
     }
     $tbWstSort = \Hgtlin\Model\WstSortModel::WST_SORT;
     $tbWstScks = \Hgtlin\Model\WstScksModel::WST_SCKS;
     $count = $this->where($cond)->count();
     $result = $this->table(self::WST_CONTENT . ' a')->join('left join ' . $tbWstSort . ' b ON a.sortid=b.sortid')->join('left join ' . $tbWstScks . ' c ON a.scks=c.id')->where($cond)->field('a.*,b.sortname,c.name as scks_name')->order('articleid DESC')->limit($page, $pagesize)->select();
     $array['count'] = $count ? $count : 0;
     $array['data'] = string_gb2312_to_utf8($result);
     return $array;
 }
 /**
  * 栏目管理
  */
 public function dataList($page, $pagesize, $postData)
 {
     if ($postData['senddate']) {
         $cond['a.senddate'] = array('like', '%' . $postData['senddate'] . '%');
     }
     if ($postData['sqh']) {
         $cond['a.sqh'] = array('like', '%' . $postData['sqh'] . '%');
     }
     if ($postData['artitle']) {
         $cond['a.artitle'] = array('like', '%' . string_utf8_to_gb2312($postData['artitle']) . '%');
     }
     $count = $this->table(self::WST_GKMLXX . ' a')->where($cond)->count();
     $result = $this->table(self::WST_GKMLXX . ' a')->where($cond)->field('a.*')->order('a.id DESC')->limit($page, $pagesize)->select();
     $result = string_gb2312_to_utf8($result);
     $gkml = D('WstGkml')->getShortGkml();
     foreach ($result as $k => $v) {
         $result[$k]['mlid1'] = $gkml[$v['mlid1']];
         $result[$k]['mlid2'] = $gkml[$v['mlid2']];
         $result[$k]['mlid3'] = $gkml[$v['mlid3']];
     }
     $array['count'] = $count ? $count : 0;
     $array['data'] = $result;
     return $array;
 }
 public function searchResult($page, $pagesize, $keyword)
 {
     $cond['title'] = array('like', '%' . string_utf8_to_gb2312($keyword) . '%');
     $count = $this->where($cond)->count(1);
     $data = $this->where($cond)->limit($page, $pagesize)->order('articleid DESC')->select();
     $data = string_gb2312_to_utf8($data);
     foreach ($data as $k => $v) {
         $data[$k]['addtime'] = date('Y-m-d', strtotime($v['addtime']));
         $data[$k]['addtime1'] = date('m.d', strtotime($v['addtime']));
         $data[$k]['subcontent'] = utf8_strcut(strip_tags($data[$k]['content']), 0, 500);
     }
     $info['data'] = $data;
     $info['count'] = $count;
     return $info;
 }
 public function check($postArray)
 {
     $cond['username'] = string_utf8_to_gb2312($postArray['username']);
     return $this->where($cond)->find();
 }
 /**
  * 编辑
  */
 public function editAct()
 {
     $id = intval(I("id"));
     if (IS_POST) {
         $sort = D('WstSort')->where(array('sortid' => $_POST['sortid']))->find();
         $_POST['ldid'] = $_POST['leader'] ? implode(',', $_POST['leader']) : 0;
         $_POST['pid'] = $sort['parentid'];
         $_POST['tid'] = $sort['treedid'];
         $data = D("WstContent")->create();
         if ($data) {
             $data = string_utf8_to_gb2312($data);
             if (D("WstContent")->save($data) !== false) {
                 $this->success("修改成功!");
             } else {
                 $this->error("修改失败!");
             }
         } else {
             $this->error('"修改失败!"');
         }
     } else {
         if (!$id) {
             $this->error("非法操作!");
         }
         $data = D("WstContent")->getObject($id);
         if (!$data) {
             $this->error("该角色不存在!");
         }
         //树状栏目
         $result = D("WstSort")->field('sortid as id,sortname as name,parentid')->order(array("sortid" => "ASC"))->select();
         $result = string_gb2312_to_utf8($result);
         $tree = new p\Tree();
         foreach ($result as $r) {
             $r['selected'] = $r['id'] == $data['sortid'] ? 'selected' : '';
             $array[] = $r;
         }
         $str = "<option value='\$id' \$selected>\$spacer \$name</option>";
         $tree->init($array);
         $select_categorys = $tree->get_tree(0, $str);
         $this->assign("select_categorys", $select_categorys);
         //上传图片
         $img_upload = unifile_upload(array('name' => 'picture', 'content' => $data['picture'], 'table' => 'WstContent', 'p_key' => 'articleid', 'field_name' => 'picture'));
         $this->assign('img_upload', $img_upload);
         //编辑器
         $keditor = keditor(array('name' => 'content', 'content' => $data['content']));
         $this->assign('keditor', $keditor);
         //领导
         $leader = D('WstLd')->getContent($data['ldid']);
         $this->assign('leader', $leader);
         //领导子站
         $leaderSort = D('WstLdSort')->getContent();
         $this->assign('leaderSort', $leaderSort);
         //获取处室
         $chushi = D('WstScks')->getNewChushi();
         $this->assign('chushi', $chushi);
         //处室栏目
         $cslanmu = D('WstSort')->getChushiSort($data['scks']);
         $this->assign('cslanmu', $cslanmu);
         $this->assign('actionName', ACTION_NAME);
         $this->assign("info", $data);
         $this->display("Article:add");
     }
 }
 /**
  * 添加链接
  */
 public function addLinkAct()
 {
     if (IS_POST) {
         $_POST['uptime'] = date('Y-m-d H:i:s', time());
         $_POST['scksid'] = $this->_account['scks'];
         $data = string_utf8_to_gb2312($_POST);
         if ($data) {
             $id = D("WstLink")->add($data);
             if ($id) {
                 $this->success("成功");
             } else {
                 $this->error("失败!");
             }
         } else {
             $this->error('失败');
         }
     }
     $this->assign('actionName', ACTION_NAME);
     $this->display();
 }
 /**
  * 编辑用户
  */
 public function editChushiAct()
 {
     $id = intval(I("id"));
     if (IS_POST) {
         $data = string_utf8_to_gb2312($_POST);
         if ($data) {
             $result = D("WstScks")->where(array('id' => $id))->save($data);
             if ($result) {
                 $this->success("修改成功!");
             } else {
                 $this->error("修改失败!");
             }
         } else {
             $this->error('修改失败');
         }
     } else {
         $info = D('WstScks')->getOneData($id);
         $this->assign('info', $info);
         $childChushi = D('WstWznr')->getRelation();
         $this->assign('childChushi', $childChushi);
         $this->assign('actionName', ACTION_NAME);
     }
     $this->display('User:addChushi');
 }