public function single1kindAction() { $id = $this->dispatcher->getParam(0); $user_id = 0; if ($this->session->has("current_user")) { $user_id = unserialize($this->session->get("current_user"))->id; } $common = new model\common(); $sql = "call p_get_bd_detail(?)"; $query = $common->getReadConnection()->query($sql, array($id)); $result = $query->fetchAll(); if (count($result) != 1) { $this->response->redirect("fzf.php"); $this->view->disable(); } else { $this->view->bd = $result[0]; $query->nextRowSet(); //详细 $this->view->places = $query->fetchAll(); $query->nextRowSet(); //所有商圈 $this->view->bds = $query->fetchAll(); } if ($this->settings["is_mobile"] == "true") { $this->view->pick("bd/mb-single1kind"); } }
public function moreHistoryAction() { if ($this->settings["is_mobile"] == "true") { $idquestion = $_GET["idquestion"]; $idarticle = $_GET["idarticle"]; $idbookticket = $_GET["idbookticket"]; $idbookmeal = $_GET["idbookmeal"]; $idactvt = $_GET["idactvt"]; $common = new model\common(); $sql = "call p_get_history_data(?,?,?,?,?)"; $query = $common->getReadConnection()->query($sql, array($idquestion, $idarticle, $idbookticket, $idbookmeal, $idactvt)); //获取数据 $result = $query->fetchAll(); usort($result, function ($a, $b) { return $a["create_time"] < $b["create_time"]; }); $this->view->data = $result; $this->view->pick("index/mb-more"); $this->view->setRenderLevel(View::LEVEL_ACTION_VIEW); } }
public function evalMealAction() { if (!$this->session->has("current_user")) { $this->response->redirect("login/login"); $this->view->disable(); return; } if ($this->request->isPost()) { $book_meal_id = $_POST["id"]; $evaluation_rank = $_POST["evaluation_rank"]; $evaluation = $_POST["evaluation"]; $sql = "UPDATE `book_meal` SET `evaluation`=? ,`evaluation_rank`=?,`state`='cofirm_closed',`closed_time`=now() where id=?"; $myModel = new model\common(); $query = $myModel->getReadConnection()->query($sql, array($evaluation, $evaluation_rank, $book_meal_id)); $this->response->redirect("dofavor/singleMeal/" . $book_meal_id); $this->view->disable(); } }
/** * 微信个人中心 * URL:https://open.weixin.qq.com/connect/oauth2/authorize?appid=wxe5cc657d28788f78&redirect_uri=http%3a%2f%2fcssv.anneijia.com%2Flogin%2FwechatLogin&response_type=code&scope=snsapi_userinfo&state=ik#wechat_redirect * */ public function wechatMeAction() { require_once "/../../utility/wechat.class.php"; $weObj = new \UtillYou\Utility\Wechat(); $OAuthToken = $weObj->getOauthAccessToken(); if (!$OAuthToken) { echo '请通过微信客户端进入'; $this->view->disable(); return; } $O_user_info = $weObj->getOauthUserinfo($OAuthToken['access_token'], $OAuthToken['openid']); $sql = "call p_wechat_user_login(?,?,?,?,?,?,?,?,?)"; $common = new model\common(); $result = $common->getReadConnection()->query($sql, array($O_user_info['openid'], $O_user_info['nickname'], $O_user_info['sex'], $O_user_info['province'], $O_user_info['city'], $O_user_info['country'], serialize($O_user_info['privilege']), $O_user_info['headimgurl'], isset($O_user_info['unionid']) ? $O_user_info['unionid'] : ''))->fetchAll(); $db_user = (object) $result[0]; $this->session->set("current_user", serialize($db_user)); $this->session->set("wx_env", "wechat"); //$db_auth=model\rmAuthToken::findFirstByUser_id($db_user->id); //if($db_auth){//有,就更新 // $db_auth->selector=$selector; // $db_auth->token_hash=$token_hash; // $db_auth->update(); //}else{//没有,就创建 // $rm_auth_token=new model\rmAuthToken(); // $rm_auth_token->selector=$selector; // $rm_auth_token->token_hash=$token_hash; // $rm_auth_token->user_id=$db_user->id; // $rm_auth_token->create(); //} //setcookie("login_auth",$selector.":".$token,time()+60*60*24*30 ); return $this->response->redirect("user/me/" . $db_user->id); }
public function indexAction() { $this->view->title = "案内家-问答"; if ($this->settings["is_mobile"] == "true") { $sql = "select * from v_question_list order by question_id desc limit 20"; if (isset($_GET["k"])) { $key = $_GET["k"]; $value = $_GET["v"]; switch ($key) { case 'tag': $sql = "select a.is_secret,a.id as question_id,a.body,a.pics,a.votes,a.create_time,a.owner_id,a.owner_name,a.status,a.has_viewed,a.answers_count,a.has_accepted,a.deleted,group_concat(c.tag_name order by c.tag_id) as tag_names,group_concat(c.tag_id order by c.tag_id) as tag_ids\nfrom question a\n\tinner join user b on a.owner_id=b.id\n\tleft join question_tag c on a.id=c.question_id\n\twhere c.tag_id=?\n\tgroup by a.id;"; break; case "accepted": $sql .= " where has_accepted=?"; break; case "key": $sql .= " where body like '%" . $value . "%'"; break; default: # code... break; } } $common = new model\common(); if (isset($_GET["v"])) { $query = $common->getReadConnection()->query($sql, array($_GET["v"])); } else { $query = $common->getReadConnection()->query($sql); } //获取问题 $this->view->questions = $query->fetchAll(); $this->view->pick("question/mb-index"); } }
public function supportAction() { if (!$this->session->has("current_user")) { $this->response->redirect("index/index"); $this->view->disable(); return; } if ($this->request->isPost()) { $object_id = $_POST["object_id"]; $object_type = $_POST["object_type"]; $positive = $_POST["positive"] == "true" ? 1 : 0; $sql = "CALL p_support_article_comment(?,?,?,?);"; $myModel = new model\common(); if ($object_type == 'article') { $sql = "CALL p_support_article(?,?,?);"; $query = $myModel->getReadConnection()->query($sql, array($object_id, unserialize($this->session->get("current_user"))->id, $positive)); } else { $article_id = $_POST["article_id"]; $query = $myModel->getReadConnection()->query($sql, array($object_id, unserialize($this->session->get("current_user"))->id, $positive, $article_id)); } } }
public function usersAction() { $common = new model\common(); $query = $common->getReadConnection()->query("select * from user order by score desc limit 100"); $this->view->users = $query->fetchAll(); if ($this->settings["is_mobile"] == "true") { $this->view->pick("user/mb-users"); } }
public function hasInfoAction() { if ($this->session->has("current_user")) { $sql = "select count(id) as ct from user_notification where user_id=? and deleted=0 and viewed=0;"; $myModel = new model\common(); $query = $myModel->getReadConnection()->query($sql, array(unserialize($this->session->get("current_user"))->id)); echo $query->fetchAll()[0][0]; } else { echo "0"; } $this->view->disable(); }
public function closeActvtAction() { if (!$this->session->has("current_user")) { $this->response->redirect("index/index"); $this->view->disable(); return; } $actvt_id = $_POST["actvt_id"]; $sql = "update actvt set state='closed' where id=?"; $myModel = new model\common(); $query = $myModel->getReadConnection()->query($sql, array($actvt_id)); $this->view->disable(); }