public function actionIndex() { $type = zmf::val('type', 1); if (!$type || $type == 'staycheck') { $status = Posts::STATUS_STAYCHECK; } else { $status = Posts::STATUS_PASSED; } $sql = "SELECT c.id,c.uid,c.content,c.cTime,p.title,c.logid,c.status FROM {{comments}} c,{{posts}} p WHERE c.status={$status} AND c.logid=p.id ORDER BY c.cTime DESC"; Posts::getAll(array('sql' => $sql), $pager, $items); if (!empty($items)) { $uids = array_filter(array_keys(CHtml::listData($items, 'uid', ''))); $uidsStr = join(',', $uids); if ($uidsStr != '') { $usernames = Yii::app()->db->createCommand("SELECT id,truename FROM {{users}} WHERE id IN({$uidsStr})")->queryAll(); if (!empty($usernames)) { foreach ($items as $k => $val) { foreach ($usernames as $val2) { if ($val['uid'] > 0 && $val['uid'] == $val2['id']) { $items[$k]['loginUsername'] = $val2['truename']; } } } } } } $this->render('index', array('pages' => $pager, 'posts' => $items)); }
public function actionNotice() { $sql = "SELECT * FROM {{notification}} WHERE uid='{$this->uid}' ORDER BY cTime DESC"; Posts::getAll(array('sql' => $sql), $pages, $comLists); Notification::model()->updateAll(array('new' => 0), 'uid=:uid', array(':uid' => $this->uid)); $data = array('posts' => $comLists, 'pages' => $pages); $this->pageTitle = $this->userInfo['truename'] . '的提醒 - ' . zmf::config('sitename'); $this->render('notice', $data); }
public function actionMap() { $this->layout = 'common'; $sql = "SELECT id,title,lat,`long`,comments,favorite,cTime FROM {{posts}} WHERE lat!='' AND `long`!='' AND `status`=1 ORDER BY cTime ASC"; Posts::getAll(array('sql' => $sql, 'pageSize' => 100), $pages, $posts); foreach ($posts as $k => $val) { $posts[$k]['href'] = Yii::app()->createUrl('posts/view', array('id' => $val['id'])); $posts[$k]['cTime'] = zmf::formatTime($val['cTime']); } $posts = !empty($posts) ? $posts : array(); $data = array('postJson' => CJSON::encode($posts), 'loadMap' => empty($posts) ? false : true); $this->pageTitle = '足迹 - ' . zmf::config('sitename'); $this->selectNav = 'map'; $this->render('/index/map', $data); }
public function actionIndex() { $this->poiType = zmf::filterInput($_GET['type']); $this->poiOrder = zmf::filterInput($_GET['order']); $areaid = zmf::filterInput($_GET['areaid']); if (!$this->poiOrder || !in_array($this->poiOrder, array('1', '2'))) { $this->poiOrder = '1'; } $where = $order = ''; if ($areaid) { $extra = Area::getAreaInfo($areaid); $areaIds = $extra['areaIds']; $areaInfo = $extra['areaInfo']; if ($areaIds) { $where .= " areaid IN({$areaIds}) AND "; } } $_typename = Position::exClassify($this->poiType); if ($this->poiType && $_typename && !is_array($_typename)) { $where .= " classify='{$this->poiType}' AND "; } else { $this->poiType = ''; $_typename = '的景点、酒店、餐厅及购物'; } if ($this->poiOrder == '1') { $order = ' ORDER BY score DESC'; } elseif ($this->poiOrder == '2') { $order = ' ORDER BY scorer DESC'; } //获取景点列表 $sql = "SELECT id,title_cn,title_en,title_local,address_cn,address_en,address_local,score,scorer,attach,lat,`long`,faceimg,classify FROM {{position}} WHERE {$where} forWedding=1 AND status=" . Posts::STATUS_PASSED . $order; Posts::getAll(array('sql' => $sql), $pages, $posts); //获取所有受推荐地区 $areas = Area::getTops(0); //面包屑 $breads[] = CHtml::link('目的地', array('position/index')); if ($areaInfo) { $breads[] = $areaInfo['title']; } //页面SEO $this->pageTitle = '目的地 - ' . zmf::config('sitename'); $this->render('index', array('posts' => $posts, 'pages' => $pages, 'areas' => $areas, 'breads' => $breads, 'areaId' => $areaid)); }
public function actionView($id) { $id = zmf::filterInput($id); if (!$id || !is_numeric($id)) { throw new CHttpException(404, '你所查看的页面不存在.'); } $info = Naodong::model()->findByPk($id); if ($info == NULL) { throw new CHttpException(404, '你所查看的页面不存在.'); } //更新访问次数 Posts::updateCount($id, 'Naodong'); //获取评论列表 $sql = "SELECT * FROM {{comments}} WHERE logid='{$id}' AND classify='naodong' AND status=" . Posts::STATUS_PASSED . " ORDER BY cTime ASC"; Posts::getAll(array('sql' => $sql, 'pageSize' => 2), $pages, $comLists); //获取上下篇 $preInfo = Naodong::model()->find(array('condition' => 'id>:id AND status=' . Posts::STATUS_PASSED, 'select' => 'id,title', 'params' => array(':id' => $id))); $nextInfo = Naodong::model()->find(array('condition' => 'id<:id AND status=' . Posts::STATUS_PASSED, 'select' => 'id,title', 'params' => array(':id' => $id))); $authorInfo = $recommends = array(); if ($info['uid']) { //获取作者信息 $authorInfo = Users::getUserInfo($info['uid']); //获取作者相关推荐 $recommends = Naodong::getRecommends($info['uid'], $id); } //获取是否赞过 if ($this->uid) { if (UserAction::checkAction($id, 'favorNaodong')) { $this->favored = true; } } $data = array('info' => $info, 'posts' => $comLists, 'pages' => $pages, 'userInfo' => $authorInfo, 'recommends' => $recommends, 'preInfo' => $preInfo, 'nextInfo' => $nextInfo); $this->pageTitle = $info['title'] . ' - ' . zmf::config('sitename'); $this->pageDescription = zmf::subStr($info['content'], 140); $this->mobileTitle = $authorInfo['truename']; $this->render('/index/view', $data); }
public function actionView($id) { $this->layout = '/layouts/group'; $this->currentModule = 'group'; $info = WeddingGroup::model()->findByPk($id); if (!$info) { throw new CHttpException(404, '你所查看的页面不存在'); } $info->avatar = $info->getAvatar($info->avatar); if (zmf::uid()) { $reInfo = GroupLink::findRelation($this->uid, $id); if ($reInfo) { $this->joined = true; } } //获取团队成员 $criteria = new CDbCriteria(array('condition' => 'gl.groupid=' . $id, 'join' => 'LEFT JOIN {{group_link}} gl ON t.id=gl.uid', 'select' => 't.id,t.truename,t.avatar')); $members = new CActiveDataProvider('Users', array('pagination' => array('pageSize' => 10), 'criteria' => $criteria)); //获取团队案例列表 $sql = "SELECT p.id,p.title,p.faceimg,p.uid,p.colid,p.cTime,p.updateTime FROM {{posts}} p WHERE p.groupid='{$id}' AND p.classify=" . Posts::CLASSIFY_WEDDING . " AND p.status=" . Posts::STATUS_PASSED . " ORDER BY p.cTime DESC"; Posts::getAll(array('sql' => $sql), $pages, $posts); if (!empty($posts)) { foreach ($posts as $k => $p) { if ($p['faceimg'] > 0) { $_attach = Attachments::getOne($p['faceimg']); $_url = Attachments::getUrl($_attach); $posts[$k]['faceimg'] = $_url; } else { $posts[$k]['faceimg'] = ''; } } } $data = array('info' => $info, 'posts' => $posts, 'pages' => $pages); $this->pageTitle = $info['title'] . ' - ' . zmf::config('sitename'); $this->render('view', $data); }
/** * 用户关注列表 */ public function actionFavors() { $sql = "SELECT logid FROM {{favorites}} WHERE uid='{$this->uid}' AND classify='user' ORDER BY cTime DESC"; Posts::getAll(array('sql' => $sql), $pages, $comLists); $lists = array(); if (!empty($comLists)) { foreach ($comLists as $uid) { $lists[] = Users::getUserInfo($uid['logid']); } } $data = array('posts' => $lists, 'pages' => $pages, 'from' => 'favors'); $this->pageTitle = $this->userInfo['truename'] . '的关注列表 - ' . zmf::config('sitename'); $this->render('favorites', $data); }
public function actionFavorites() { $sql = "SELECT * FROM {{favorites}} WHERE uid='{$this->uid}' AND classify!='user' ORDER BY cTime DESC"; Posts::getAll(array('sql' => $sql), $pages, $lists); if (!empty($lists)) { foreach ($lists as $k => $v) { $type = $v['classify']; $_info = ''; $_url = ''; switch ($type) { case 'posts': $_info = Posts::getSimpleInfo(array('keyid' => $v['logid'], 'origin' => 'posts')); $_url = Yii::app()->createUrl('posts/index', array('id' => $v['logid'])); break; case 'answer': $_info = Posts::getSimpleInfo(array('keyid' => $v['logid'], 'origin' => 'answer')); $_url = Yii::app()->createUrl('question/answer', array('id' => $v['logid'])); break; case 'poipost': $_info = Posts::getSimpleInfo(array('keyid' => $v['logid'], 'origin' => 'poipost')); $_url = Yii::app()->createUrl('poipost/view', array('id' => $v['logid'])); break; case 'poitips': $_info = Posts::getSimpleInfo(array('keyid' => $v['logid'], 'origin' => 'poitips')); $_url = ''; break; } if (!$_info) { unset($lists[$k]); continue; } $lists[$k]['data'] = $_info; $lists[$k]['url'] = $_url; $lists[$k]['classify'] = $type; } } $data = array('posts' => $lists, 'pages' => $pages); $this->pageTitle = $this->userInfo['username'] . '的收藏 - ' . zmf::config('sitename'); $this->render('favorites', $data); }
public function actionIndex() { $this->pType = zmf::filterInput($_GET['type']); $this->pOrder = zmf::filterInput($_GET['order']); $areaid = zmf::filterInput($_GET['areaid']); $colid = zmf::filterInput($_GET['colid']); $tagid = zmf::filterInput($_GET['tagid']); if (!$this->pOrder || !in_array($this->pOrder, array('1', '2'))) { $this->pOrder = '1'; } $where = $order = $areaInfo = ''; if ($areaid) { $extra = Area::getAreaInfo($areaid); $areaIds = $extra['areaIds']; $areaInfo = $extra['areaInfo']; if ($areaIds) { $where .= " p.areaid IN({$areaIds}) AND "; } } if ($colid) { $where .= " p.colid='{$colid}' AND "; $this->selectColid = $colid; } if ($this->pOrder == '1') { $order = ' ORDER BY p.cTime DESC'; } elseif ($this->pOrder == '2') { $order = ' ORDER BY p.hits DESC'; } if ($tagid) { $sql = "SELECT p.id,p.title,p.faceimg,p.uid,p.colid,p.cTime,p.updateTime FROM {{posts}} p,{{tag_relation}} tr WHERE tr.tagid='{$tagid}' AND tr.classify='posts' AND tr.logid=p.id AND {$where} p.classify=" . Posts::CLASSIFY_WEDDING . " AND p.status=" . Posts::STATUS_PASSED . $order; } else { $sql = "SELECT p.id,p.title,p.faceimg,p.uid,p.colid,p.cTime,p.updateTime FROM {{posts}} p WHERE {$where} p.classify=" . Posts::CLASSIFY_WEDDING . " AND p.status=" . Posts::STATUS_PASSED . $order; } Posts::getAll(array('sql' => $sql), $pages, $posts); if (!empty($posts)) { foreach ($posts as $k => $p) { $posts[$k]['coltitle'] = ''; if ($p['colid']) { $coltitle = Column::getOne($p['colid'], 'title'); if ($coltitle) { $posts[$k]['coltitle'] = $coltitle; } } if ($p['faceimg'] > 0) { $_attach = Attachments::getOne($p['faceimg']); $_url = Attachments::getUrl($_attach); $posts[$k]['faceimg'] = $_url; } else { $posts[$k]['faceimg'] = ''; } } } //面包屑 $breads[] = CHtml::link('作品集', array('posts/index')); if ($areaInfo) { $breads[] = $areaInfo['title']; } //获取所有受推荐地区 $areas = Area::getTops(0); //文章分类 $cols = Column::allCols(1, 0, 1, Posts::CLASSIFY_WEDDING); //推荐的标签 $suggestTags = Tags::getTops('posts'); $data = array('posts' => $posts, 'pages' => $pages, 'breads' => $breads, 'areas' => $areas, 'areaId' => $areaid, 'cols' => $cols, 'tags' => $suggestTags, 'tagid' => $tagid); $this->pageTitle = '作品集 - ' . zmf::config('sitename'); $this->render('all', $data); }