public function experthomeAction()
{
$id = $this->getRequest()->getParam('expertid', '0');
$questionid = $this->getRequest()->getParam('questionid', '0');
$type = $this->getRequest()->getParam('type', '0');
// $id=$_SESSION["userinfo"][0][id];
//echo $id;
//exit();
$usertable = new UserModel();
$db1 = $usertable->getAdapter();
$expertinfo = new expertinfoModel();
$db2 = $expertinfo->getAdapter();
$question = new User_QuestionModel();
$db3 = $question->getAdapter();
$response = new Expert_ResponseModel();
$db4 = $response->getAdapter();
if ($type == 0) {
$expert = $db2->query('SELECT * FROM expertinfo,User WHERE expertinfo.userid = User.id and User.id =? ', $id)->fetchAll();
//print_r($expert);
$questions = $db3->query('SELECT userconquestion.*,User.name FROM userconquestion,User WHERE userconquestion.state=1 and userconquestion.userid=User.id and userconquestion.expertid=? order by time desc ', $id)->fetchAll();
// print_r($questions);
// exit();
$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);
// exit();
$this->view->result = $expert;
$this->view->question = $questions;
$this->view->responses = $responses;
$this->view->type = $type;
$this->view->questionid = $questionid;
} else {
if ($type == 1) {
$expert = $db2->query('SELECT * FROM expertinfo,User WHERE expertinfo.userid = User.id and User.id =? ', $id)->fetchAll();
$question = $db3->query('SELECT userconquestion.*,User.name FROM userconquestion,User WHERE userconquestion.userid=User.id and userconquestion.id=? order by time desc ', $questionid)->fetchAll();
$set = array('expertid' => $id, 'questionid' => $questionid);
$_SESSION["question"] = $set;
$this->view->expertid = $id;
$this->view->result = $expert;
$this->view->question = $question;
$this->view->questionid = $questionid;
$this->view->type = $type;
}
}
}
public function expertregisterAction()
{
$account = $this->getRequest()->getParam('account');
$password = $this->getRequest()->getParam('password');
$name = $this->getRequest()->getParam('name');
$content = $this->getRequest()->getParam('context');
$work = $this->getRequest()->getParam('work');
$code = $this->getRequest()->getParam('surecode');
if ($code == $_SESSION["validcode"]) {
$User = new UserModel();
if ($User->ifRegister($account)) {
$set = array('account' => $account, 'password' => $password, 'name' => $name, 'email' => $account, 'type' => 2);
//在注册用户的时候顺带着要建一个用户个人信息
if ($User->insert($set) > 0) {
$where = "email='{$account}'";
$result = $User->fetchAll($where)->toArray();
$info = array('userid' => $result[0][id], 'sex' => 'M', 'name' => $result[0][name], 'sheng' => '北京市', 'shi' => '北京市', 'xian' => '东城区', 'birth' => '1994-5-29', 'interest' => '跑步');
$userinfo = new userinfoModel();
$expert = array('info' => $content, 'userid' => $result[0][id], 'work' => $work, 'concern' => 0, 'image' => '/WebOne/public/image/initial.png');
$expertinfo = new expertinfoModel();
if ($userinfo->insert($info) > 0 && $expertinfo->insert($expert) > 0) {
//注册账号成功
$this->render('ok');
}
} else {
$this->view->info = '1';
$this->_forward('error');
}
} else {
$this->view->info = '2';
//账号已经创建
$this->_forward('error');
}
} else {
$this->view->info = '3';
$this->render('error');
//验证码输入错误
}
}
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;
}
