public function replyAction() { $content = $this->getRequest()->getParam('context'); // echo $content; //得到expertid $expertid = $_SESSION["userinfo"][0][id]; $questionid = $_SESSION["question"][questionid]; $usertable = new UserModel(); $db1 = $usertable->getAdapter(); $response = new Expert_ResponseModel(); $db2 = $response->getAdapter(); $question = new User_QuestionModel(); $db3 = $question->getAdapter(); // exit(); $questions = $db3->query('SELECT userconquestion.* FROM userconquestion WHERE id=? ', $questionid)->fetchAll(); $userid = $questions[0][userid]; // print_r($questions); //获取当前时间 $t = time(); $time = date("Y-m-d H:i:s", $t); $set = array('expertid' => $expertid, 'userid' => $userid, 'questionid' => $questionid, 'response' => $content, 'time' => $time); // print_r($insertset); $flag1 = $response->insert($set); $state = 0; $updateset = array('state' => $state); $question->update($updateset, $db3->quoteInto('id = ?', $questionid)); $this->view->info = '回复成功'; $this->view->expertid = $expertid; $this->_forward('result7', 'globals'); }
public function expertdetailAction() { $replypage = $this->getRequest()->getParam('replypage', '0'); $questionpage = $this->getRequest()->getParam('questionpage', '0'); $id = $this->getRequest()->getParam('expertid', '0'); $type = $this->getRequest()->getParam('type', '0'); $userid = $_SESSION["userinfo"][0][id]; $usertable = new UserModel(); $db1 = $usertable->getAdapter(); $expertinfo = new expertinfoModel(); $db2 = $expertinfo->getAdapter(); $expert = $db2->query('SELECT * FROM expertinfo,User WHERE expertinfo.userid = User.id and User.id =? ', $id)->fetchAll(); //print_r($expert); $question = new User_QuestionModel(); $db3 = $question->getAdapter(); $response = new Expert_ResponseModel(); $db4 = $response->getAdapter(); $questions = $db3->query('SELECT * FROM userconquestion,User WHERE userconquestion.state=1 and userconquestion.userid=User.id and userconquestion.expertid=? order by time desc ', $id)->fetchAll(); // exit(); //print_r($questions); $questionnum = count($questions); $responses = $db4->query('select * from expertconresponse,userconquestion,User where expertconresponse.expertid=? and expertconresponse.questionid=userconquestion.id and userconquestion.userid=User.id order by time desc', $id)->fetchAll(); //print_r($responses); $replynum = count($responses); $Isconcern = $db3->query('SELECT COUNT(*) as num FROM userconexpert where expertid=? and userid=? ', array($id, $userid))->fetchAll()[0][num]; $replypages = ceil($replynum / 3); //确定页面显示的规范 处理分页的逻辑 这是reply的 if ($replypage < 3) { if ($replypages > 3) { $set = array(1, 2, 3, 4); } else { $set = array(); for ($i = 1; $i <= $replypages; $i++) { $set[] = $i; } } } else { if ($replypage >= 3) { if ($replypage + 3 <= $replypages) { $set = array($replypage, $replypage + 1, $replypage + 2, $replypage + 3); } else { $set = array(); for ($i = $replypage; $i <= $replypages; $i++) { $set[] = $i; } } } } $questionpages = ceil($questionnum / 6); if ($questionpage < 3) { if ($questionpages > 3) { $questionset = array(1, 2, 3, 4); } else { $questionset = array(); for ($i = 1; $i <= $questionpages; $i++) { $questionset[] = $i; } } } else { if ($questionpage >= 3) { if ($questionpage + 3 <= $questionpages) { $questionset = array($questionpage, $questionpage + 1, $questionpage + 2, $questionpage + 3); } else { $questionset = array(); for ($i = $questionpage; $i <= $questionpages; $i++) { $questionset[] = $i; } } } } $this->view->replypage = $replypage; $this->view->replynums = $replynum; $this->view->questionpage = $questionpage; $this->view->questionnums = $questionnum; $this->view->replys = $set; $this->view->questions = $questionset; $this->view->expertid = $id; $this->view->result = $expert; $this->view->question = $questions; $this->view->responses = $responses; $this->view->type = $type; $this->view->userid = $userid; $this->view->Isconcern = $Isconcern; }