/** * 显示问题列表 */ public function actionIndex() { $sql = "select `{{question}}`.`id`,`{{question}}`.`question_content`,`{{question}}`.`add_time`,`{{question}}`.`update_time`,`{{question}}`.`answer_count`,`{{question}}`.`view_count`,`{{question}}`.`lock`,`{{question}}`.`focus_count`,`{{question}}`.`comment_count`,`{{question}}`.`best_answer`,`{{question}}`.`ip`,`{{users}}`.`username`,`{{users}}`.`uid`\n\t\t\t\tfrom `{{question}}`\t\t\t\t\n\t\t\t\tleft join `{{users}}` on (`{{users}}`.`uid` = `{{question}}`.`published_uid`)"; $condition = array(); //根据uid搜索 if (isset($_GET['uid'])) { $condition[] = "`{{users}}`.`uid`={$_GET['uid']} "; } if (isset($_POST['content'])) { $condition[] = " `{{question}}`.`question_content` like '%{$_POST['content']}%'"; } $conditions = implode('AND', $condition); //var_dump($conditions); if ($conditions) { $conditions = ' where ' . $conditions; $sql .= $conditions; } $sql .= " order by `{{question}}`.`add_time` desc "; $connection = Yii::app()->db; $criteria = new CDbCriteria(); $models = $connection->createCommand($sql)->queryAll(); $count = count($models); $pages = new CPagination($count); $pages->pageSize = 12; $pages->applylimit($criteria); $models = $connection->createCommand($sql . " LIMIT :offset,:limit"); $models->bindValue(':offset', $pages->currentPage * $pages->pageSize); $models->bindValue(':limit', $pages->pageSize); $models = $models->queryAll(); $this->render('index', array('models' => $models, 'pages' => $pages, 'count' => $count)); }
public function actionIndex($uid) { //自己才能看自己的个人中心 if ($uid != Yii::app()->user->id) { $this->redirect('/'); } //显示用户资料 $user_model = Users::model()->findByPk($uid); //获取ype if (isset($_GET['type']) && $_GET['type'] == 'focus') { //获取关注的问题 $sql = "select `{{question}}`.`id`,`{{question}}`.`question_content`,`{{question}}`.`add_time`,`{{question}}`.`published_uid`,`{{question}}`.`lock`,`{{question}}`.`best_answer`,`{{question}}`.`answer_count`,`{{question}}`.`view_count` from `{{question}}` left join `{{question_focus}}` on (`{{question_focus}}`.`question_id`=`{{question}}`.`id`) where `{{question_focus}}`.`uid`={$uid} order by `{{question_focus}}`.`add_time` desc"; } elseif (isset($_GET['type']) && $_GET['type'] == 'answer') { //获取回复的问题 $sql = "select `{{question}}`.`id`,`{{question}}`.`question_content`,`{{question}}`.`add_time`,`{{question}}`.`published_uid`,`{{question}}`.`lock`,`{{question}}`.`best_answer`,`{{question}}`.`answer_count`,`{{question}}`.`view_count` from `{{question}}` left join `{{answer}}` on (`{{answer}}`.`question_id`=`{{question}}`.`id`) where `{{answer}}`.`uid`={$uid}"; } else { //获取自己发布的问题 $sql = "select `{{question}}`.`id`,`{{question}}`.`question_content`,`{{question}}`.`add_time`,`{{question}}`.`published_uid`,`{{question}}`.`lock`,`{{question}}`.`best_answer`,`{{question}}`.`answer_count`,`{{question}}`.`view_count` from `{{question}}` where `{{question}}`.`published_uid`={$uid} order by `{{question}}`.`add_time` desc"; } $connection = Yii::app()->db; $criteria = new CDbCriteria(); $models = $connection->createCommand($sql)->queryAll(); $count = count($models); $pages = new CPagination($count); $pages->pageSize = 10; $pages->applylimit($criteria); $models = $connection->createCommand($sql . " LIMIT :offset,:limit"); $models->bindValue(':offset', $pages->currentPage * $pages->pageSize); $models->bindValue(':limit', $pages->pageSize); $models = $models->queryAll(); $this->render('index', array('user_model' => $user_model, 'models' => $models, 'pages' => $pages, 'count' => $count)); }
public function actionIndex($id) { //搜索内容 $sql = "select `{{question}}`.`id`,`{{topic}}`.`topic_title`,`{{question}}`.`question_content`,`{{question}}`.`lock`,`{{question}}`.`best_answer`,`{{question}}`.`view_count`,`{{question}}`.`answer_count` from `{{question}}` left join `{{topic_question}}` on (`{{topic_question}}`.`question_id`=`{{question}}`.`id`) left join `{{topic}}` on (`{{topic}}`.`id`=`{{topic_question}}`.`topic_id`) where `{{topic}}`.`id`={$id} "; $question_models = Yii::app()->db->createCommand($sql)->queryAll(); $connection = Yii::app()->db; $criteria = new CDbCriteria(); $count = count($question_models); $pages = new CPagination($count); $pages->pageSize = 10; $pages->applylimit($criteria); $question_models = $connection->createCommand($sql . " LIMIT :offset,:limit"); $question_models->bindValue(':offset', $pages->currentPage * $pages->pageSize); $question_models->bindValue(':limit', $pages->pageSize); $question_models = $question_models->queryAll(); $this->render('index', array('count' => $count, 'question_models' => $question_models, 'pages' => $pages)); }
public function actionIndex() { $sql = "select `{{users}}`.`uid`,`{{users}}`.`username`,`{{users}}`.`email`,`{{users}}`.`avatar_file`,`{{users}}`.`sex`,`{{users}}`.`birthday`,`{{users}}`.`reg_time`,`{{users}}`.`reg_ip`,`{{users}}`.`last_login`,`{{users}}`.`last_ip` from `{{users}}`"; //查找用户 if (isset($_POST['content'])) { $sql .= " where `{{users}}`.`username` like '%{$_POST['content']}%'"; } $connection = Yii::app()->db; $criteria = new CDbCriteria(); $models = $connection->createCommand($sql)->queryAll(); $count = count($models); $pages = new CPagination($count); $pages->pageSize = 14; $pages->applylimit($criteria); $models = $connection->createCommand($sql . " LIMIT :offset,:limit"); $models->bindValue(':offset', $pages->currentPage * $pages->pageSize); $models->bindValue(':limit', $pages->pageSize); $models = $models->queryAll(); $this->render('index', array('models' => $models, 'pages' => $pages, 'count' => $count)); }
public function actionIndex($word) { //获取搜索关键字 if ($word == '') { $this->error('未填入搜索关键字'); } //搜索内容 $sql = "select `id`,`question_content`,`lock`,`best_answer`,`view_count`,`answer_count` from {{question}} where `question_content` like '%{$word}%'"; $question_models = Yii::app()->db->createCommand($sql)->queryAll(); $connection = Yii::app()->db; $criteria = new CDbCriteria(); $count = count($question_models); $pages = new CPagination($count); $pages->pageSize = 10; $pages->applylimit($criteria); $question_models = $connection->createCommand($sql . " LIMIT :offset,:limit"); $question_models->bindValue(':offset', $pages->currentPage * $pages->pageSize); $question_models->bindValue(':limit', $pages->pageSize); $question_models = $question_models->queryAll(); $this->render('index', array('count' => $count, 'question_models' => $question_models, 'pages' => $pages, 'word' => $word)); }
/** * 显示主页 * @param String $order */ public function actionIndex($order = "new") { //根据不同的order 选择不同的sql语句 switch ($order) { case 'new': $sql = "select `{{question}}`.`id` as `question_id`,`{{question}}`.`question_content`,`{{question}}`.`add_time`,`{{question}}`.`answer_count`,`{{question}}`.`view_count`,`{{question}}`.`lock`,`{{question}}`.`best_answer`,`{{users}}`.`avatar_file`,`{{users}}`.`uid`\n\t\t\t\tfrom `{{question}}`\n\t\t\t\tleft join `{{users}}` on (`{{question}}`.`published_uid`=`{{users}}`.`uid`) order by `{{question}}`.`add_time` desc\n\t\t\t\t"; break; //热门查看人数排序 //热门查看人数排序 case 'hot': $sql = "select `{{question}}`.`id` as `question_id`,`{{question}}`.`question_content`,`{{question}}`.`add_time`,`{{question}}`.`answer_count`,`{{question}}`.`view_count`,`{{question}}`.`lock`\n\t\t\t\t,`{{users}}`.`avatar_file`,`{{users}}`.`uid`\n\t\t\t\tfrom `{{question}}`\n\t\t\t\tleft join `{{users}}` on (`{{question}}`.`published_uid`=`{{users}}`.`uid`) order by `{{question}}`.`view_count` desc\n\t\t\t\t"; break; //未回复数排序 //未回复数排序 case 'unresponsive': $sql = "select `{{question}}`.`id` as `question_id`,`{{question}}`.`question_content`,`{{question}}`.`add_time`,`{{question}}`.`answer_count`,`{{question}}`.`view_count`,`{{question}}`.`lock`\n\t\t\t\t,`{{users}}`.`avatar_file`,`{{users}}`.`uid`\n\t\t\t\tfrom `{{question}}`\n\t\t\t\tleft join `{{users}}` on (`{{question}}`.`published_uid`=`{{users}}`.`uid`) where `{{question}}`.`answer_count` = 0\n\t\t\t\t"; break; //默认根据时间排序 //默认根据时间排序 default: $sql = "select `{{question}}`.`id` as `question_id`,`{{question}}`.`question_content`,`{{question}}`.`add_time`,`{{question}}`.`answer_count`,`{{question}}`.`view_count`,`{{question}}`.`lock`\n\t\t\t\t,`{{users}}`.`avatar_file`,`{{users}}`.`uid`\n\t\t\t\tfrom `{{question}}`\n\t\t\t\tleft join `{{users}}` on (`{{question}}`.`published_uid`=`{{users}}`.`uid`) order by `{{question}}`.`add_time` desc\n\t\t\t\t"; break; } $connection = Yii::app()->db; $criteria = new CDbCriteria(); $models = $connection->createCommand($sql)->queryAll(); $count = count($models); $pages = new CPagination($count); $pages->pageSize = 10; $pages->applylimit($criteria); $models = $connection->createCommand($sql . " LIMIT :offset,:limit"); $models->bindValue(':offset', $pages->currentPage * $pages->pageSize); $models->bindValue(':limit', $pages->pageSize); $models = $models->queryAll(); //获取话题 $topic_models = Topic::model()->findAll(array('select' => 'id,topic_title', 'order' => 'discuss_count desc', 'limit' => '25')); $this->pageTitle = "首页"; $this->render('index', array('models' => $models, 'pages' => $pages, 'topic_models' => $topic_models)); }
public function actionSharecontact() { $organID = Commonmodel::getOrganID(); $dealer = Dealer::model()->find('userID=:userid', array(':userid' => $organID)); $share = BusinessShare::model()->findAll('InitiatorID=:intorID and Status=2', array(':intorID' => $organID)); foreach ($share as $key => $value) { $shareID .= ',' . $value['ShareID']; } $shareID = ltrim($shareID, ","); //查出shareID $sql = "select a.id,a.contact_user_id,a.customertype,\n\t\t a.cooperationtype,a.name,a.sex,\n\t\t a.companyname,a.phone,a.province,a.city,a.area,a.email,\n\t\t a.weixin,a.QQ,a.create_time,a.Status,a.jiapart_ID,a.update_time,\n\t\t (select b.category from tbl_customer_category b where a.customercategory=b.id and a.user_id={$organID}) as customercategory\n\t\t from tbl_business_contacts a where \n\t\t user_id='{$organID}' and Status=0 and a.contact_user_id in({$shareID})"; if ($_POST) { $search['name'] = $_POST['name']; $search['phone'] = $_POST['phone']; $search['keyword'] = $_POST['keyword']; if ($search) { if ($search['name']) { $sql .= " and name like'%{$search['name']}%'"; } if ($search['phone']) { $sql .= " and phone like '%{$search['phone']}%'"; } if ($search['keyword']) { $sql .= " and (companyname like '%{$search['keyword']}%') "; } } } $sql .= "order by create_time desc"; $criteria = new CDbCriteria(); $models = Yii::app()->db->createCommand($sql)->queryAll(); $count = count($models); $pages = new CPagination($count); $pages->pageSize = intval($_GET['rows']); $pages->applylimit($criteria); $models = Yii::app()->db->createCommand($sql . " LIMIT :offset,:limit"); $models->bindValue(':offset', $pages->currentPage * $pages->pageSize); $models->bindValue(':limit', $pages->pageSize); $models = $models->queryAll(); foreach ($models as $key => $value) { $data[$key]['id'] = $value['id']; $data[$key]['Initiator'] = F::msubstr($dealer['organName']); $data[$key]['companyID'] = $value['contact_user_id']; //$data[$key]['customertype'] = $value['customertype']; $data[$key]['cooperationtype'] = $value['cooperationtype']; $data[$key]['customercategory'] = $value['customercategory']; $data[$key]['name'] = $value['name']; $data[$key]['sex'] = $value['sex']; $data[$key]['companyname2'] = F::msubstr($value['companyname']); $data[$key]['companyname'] = $value['companyname']; $data[$key]['phone'] = $value['phone']; $data[$key]['province'] = $value['province']; $data[$key]['city'] = $value['city']; $data[$key]['area'] = $value['area']; $data[$key]['address'] = F::msubstr(Area::getCity($value['province']) . Area::getCity($value['city']) . Area::getCity($value['area'])); $data[$key]['email'] = $value['email']; $data[$key]['weixin'] = $value['weixin']; $data[$key]['QQ'] = $value['QQ']; $data[$key]['create_time'] = $value['create_time']; $data[$key]['Status'] = $value['Status']; $data[$key]['jiapart_ID'] = $value['jiapart_ID']; $data[$key]['update_time'] = $value['update_time']; //$data[$key]['checked']=true; } $rs = array('total' => $count, 'rows' => !empty($data) ? $data : array()); echo json_encode($rs); }
public static function getAll($params, &$pages, &$comLists) { $sql = $params['sql']; if (!$sql) { return false; } $pageSize = $params['pageSize']; $_size = isset($pageSize) ? $pageSize : 30; $com = Yii::app()->db->createCommand($sql)->query(); //添加限制,最多取1000条记录 //todo,按不同情况分不同最大条数 $total = $com->rowCount > 1000 ? 1000 : $com->rowCount; $pages = new CPagination($com->rowCount); $criteria = new CDbCriteria(); $pages->pageSize = $_size; $pages->applylimit($criteria); $com = Yii::app()->db->createCommand($sql . " LIMIT :offset,:limit"); $com->bindValue(':offset', $pages->currentPage * $pages->pageSize); $com->bindValue(':limit', $pages->pageSize); $comLists = $com->queryAll(); }
public function actionMessage($m) { $uid = Yii::app()->session['uid']; $data['uid'] = $uid; $sql = "select * from {{icontact}} where userid = {$uid} "; switch ($m) { case 2: break; case 1: $sql .= " and isread = 1 "; break; case 0: $sql .= " and isread = 0 "; break; } $order = " order by time desc "; $sql .= $order; $criteria = new CDbCriteria(); $model = Yii::app()->db->createCommand($sql)->queryAll(); $pages = new CPagination(count($model)); $pages->pageSize = 7; $pages->applylimit($criteria); $model = Yii::app()->db->createCommand($sql . " LIMIT :offset,:limit"); $model->bindValue(':offset', $pages->currentPage * $pages->pageSize); $model->bindValue(':limit', $pages->pageSize); $commentInfo = $model->queryAll(); $data['pages'] = $pages; $data['messageInfo'] = $commentInfo; $this->render("imessage", $data); }
public function actionArticles() { $uid = Yii::app()->session['uid']; $sql = "select b.*,l.label from {{blog}} b,{{label}} l where b.userid = {$uid} and b.labelid = l.id order by b.time desc "; $criteria = new CDbCriteria(); $model = Yii::app()->db->createCommand($sql)->queryAll(); $pages = new CPagination(count($model)); $pages->pageSize = 7; $pages->applylimit($criteria); $model = Yii::app()->db->createCommand($sql . " LIMIT :offset,:limit"); $model->bindValue(':offset', $pages->currentPage * $pages->pageSize); $model->bindValue(':limit', $pages->pageSize); $blogs = $model->queryAll(); $data['pages'] = $pages; $data['blogs'] = $blogs; $this->render('articles', $data); // $criteria = new CDbCriteria(); //AR的另一种写法 // $criteria->condition = "userid=".Yii::app()->session['uid']; // $blogs = new Blog(); // $total = $blogs->count($criteria); //统计条数 // // $pager = new CPagination($total); // $pager->pageSize = 7; // $pager->applyLimit($criteria); // $blogs = $blogs->findAll($criteria); // $data = array('pages'=>$pager,'blogs'=>$blogs); // $this->render('articles',$data); }
public function actionArticles() { $uid = Yii::app()->session['uid']; $sql = "select b.*,l.label from {{blog}} b,{{label}} l where b.userid = {$uid} and b.labelid = l.id order by b.time desc "; $criteria = new CDbCriteria(); $model = Yii::app()->db->createCommand($sql)->queryAll(); $pages = new CPagination(count($model)); $pages->pageSize = 7; $pages->applylimit($criteria); $model = Yii::app()->db->createCommand($sql . " LIMIT :offset,:limit"); $model->bindValue(':offset', $pages->currentPage * $pages->pageSize); $model->bindValue(':limit', $pages->pageSize); $blogs = $model->queryAll(); $data['pages'] = $pages; $data['blogs'] = $blogs; $this->render('articles', $data); }