public function getQuestionDetail($QuestionId) { //获取问题的ID和父ID $QuestionInfo = $this->getComplain($QuestionId, 'id,author,time,qtype,view,status,description,resolve,photo,call_time,call_type,loginId,receive_time,comment,public,assess,sync,rtime'); //问题获取到 $CallTypeList = $this->config->CallTypeList; //格式化问题内容 if ($QuestionInfo['id']) { //解包压缩数组 $Comment = unserialize($QuestionInfo['comment']); //如果问题分类已经被转换 if ($Comment['convert']['to_id'] > 0) { $QuestionDetail = array('QuestionId' => $Comment['convert']['to_id'], 'QuestionType' => $Comment['convert']['to_type'], 'Transformed' => 1); } else { $QuestionDetail = array('QuestionId' => intval($QuestionInfo['id']), 'QuestionContent' => $QuestionInfo['description'], 'QuestionResolve' => $QuestionInfo['resolve'], 'AuthorName' => $QuestionInfo['author'], 'QuestionTime' => date("Y-m-d H:i:s", $QuestionInfo['time']), 'QuestionAttatch' => $QuestionInfo['photo'], 'Views' => $QuestionInfo['view'], 'QtypeId' => $QuestionInfo['qtype'], 'CallType' => $QuestionInfo['call_time'] > 0 ? $CallTypeList[$QuestionInfo['call_type']] : "", 'CallTime' => $QuestionInfo['call_time'] > 0 ? date("Y-m-d H:i:s", $QuestionInfo['call_time']) : 0, 'QuestionStauts' => $this->processStatus($QuestionInfo['status']), 'QuestionStatus' => $this->processStatus($QuestionInfo['status']), 'AcceptTime' => date("Y-m-d H:i:s", $QuestionInfo['receive_time']), 'Hidden' => $QuestionInfo['public'], 'AcceptOperatorName' => $QuestionInfo['loginId'], 'AssessStatus' => $QuestionInfo['assess'], "Sync" => $QuestionInfo['sync'], "RevokeTime" => date("Y-m-d H:i:s", $QuestionInfo['rtime'])); //获取回答内容 $AnswerInfo = $this->getAnswer($QuestionDetail['QuestionId']); //如果获取到回答 if ($AnswerInfo['id']) { $QuestionDetail['Answer'] = array('OperatorName' => $AnswerInfo['contact'], 'AnswerTime' => date("Y-m-d H:i:s", $AnswerInfo['time']), 'AnswerContent' => $AnswerInfo['content']); $QuestionDetail['AnswerLag'] = Base_Common::timeLagToText($QuestionInfo['time'], $AnswerInfo['time']); } } } else { return false; } return $QuestionDetail; }
/** *获取日期段的问题数量汇总列表 */ public function questionListAction() { $QuestionTypeList = $this->config->QuestionTypeList; $QuestionStatusList = $this->config->QuestionStatusList; //基础元素,必须参与验证 $List['Time'] = abs(intval($this->request->Time)); $List['QuestionType'] = trim($this->request->QuestionType); $List['QuestionStatus'] = abs(intval($this->request->QuestionStatus)); $List['QtypeId'] = abs(intval($this->request->QtypeId)); $List['Page'] = abs(intval($this->request->Page)); $List['PageSize'] = abs(intval($this->request->PageSize)); //URL验证码 $sign = $this->request->sign; //私钥,以后要移开到数据库存储 $p_sign = '5173'; $sign_to_check = base_common::check_sign($List, $p_sign); //不参与验证的元素 //验证URL是否来自可信的发信方 if ($sign_to_check == $sign) { //验证时间戳,时差超过600秒即认为非法 if (abs($List['Time'] - time()) <= 600) { if (isset($QuestionTypeList[$List['QuestionType']])) { if ($List['QtypeId'] >= 0) { $QtypeList = array(); $QtypeInfo = $this->oQtype->getQtypeById($List['QtypeId']); if ($QtypeInfo['id'] && $QtypeInfo['visiable'] || $List['QtypeId'] == 0) { $time = time(); $List['EndDate'] = date("Y-m-d", $time); if ($List['QuestionType'] == "complain") { $List['StartDate'] = date("Y-m-01", strtotime("-1 month", $time)); } else { $List['StartDate'] = date("Y-m-01", strtotime("-1 month", $time)); } //查询当前正在生效的公告列表 $oMenCache = new Base_Cache_Memcache("Complaint"); $M = $oMenCache->get('NewQuestionNumList_' . $List['StartDate'] . '_' . $List['EndDate'] . '_' . $List['QuestionType'] . '_' . $List['QtypeId'] . '_' . $List['QuestionStatus'] . '_' . $List['Page'] . '_' . $List['PageSize']); if ($M) { $QuestionList = json_decode($M, true); } else { switch ($List['QuestionType']) { //咨询 case "ask": $List['Parent'] = 0; $List['Revocation'] = 0; $List['hidden'] = 1; $QuestionList = $this->oQuestion->getQuestionList($List, "id,description,time,atime,status,qtype"); foreach ($QuestionList['QuestionList'] as $key => $QuestionInfo) { //生成问题链接 $QuestionList['QuestionList'][$key]['QuestionUrl'] = $this->oQuestion->getQuestionLink($QuestionInfo['id'], "question"); //生成问题状态 if ($QuestionInfo['status'] == 1) { $QuestionList['QuestionList'][$key]['QuestionStatus'] = 1; } else { $QuestionList['QuestionList'][$key]['QuestionStatus'] = 2; } } break; //建议 //建议 case "suggest": $List['Parent'] = 0; $List['Revocation'] = 0; $List['hidden'] = 1; $QuestionList = $this->oQuestion->getQuestionList($List, "id,description,time,atime,status,qtype"); foreach ($QuestionList['QuestionList'] as $key => $QuestionInfo) { //生成问题链接 $QuestionList['QuestionList'][$key]['QuestionUrl'] = $this->oQuestion->getQuestionLink($QuestionInfo['id'], "question"); //生成问题状态 if ($QuestionInfo['status'] == 1) { $QuestionList['QuestionList'][$key]['QuestionStatus'] = 1; } else { $QuestionList['QuestionList'][$key]['QuestionStatus'] = 2; } } break; //投诉 //投诉 case "complain": $List['Public'] = 0; $QuestionList = $this->oComplain->getComplainList($List, "id,description,time,atime,status,qtype"); foreach ($QuestionList['QuestionList'] as $key => $QuestionInfo) { //生成问题链接 $QuestionList['QuestionList'][$key]['QuestionUrl'] = $this->oComplain->getQuestionLink($QuestionInfo['id'], "complain"); //生成问题状态 if (in_array($QuestionInfo['status'], array(0, 4))) { $QuestionList['QuestionList'][$key]['QuestionStatus'] = 1; } elseif (in_array($QuestionInfo['status'], array(1, 3))) { $QuestionList['QuestionList'][$key]['QuestionStatus'] = 2; } if ($QuestionInfo['status'] == 2) { $QuestionList['QuestionList'][$key]['QuestionStatus'] = 3; } } break; } $QtypeList = array(); foreach ($QuestionList['QuestionList'] as $key => $QuestionInfo) { //获取问题分类 $CategoryInfo = $this->oCategory->getCategoryByQuestionType($List['QuestionType'], 'name'); //获取问题主分类 $QuestionList['QuestionList'][$key]['QuestionType'] = $CategoryInfo['name']; if (!isset($QtypeList[$QuestionInfo['qtype']])) { $QtypeList[$QuestionInfo['qtype']] = $this->oQtype->getQtypeById($QuestionInfo['qtype']); } $QuestionList['QuestionList'][$key]['Qtype'] = $QtypeList[$QuestionInfo['qtype']]['name']; //格式化提问时间 $QuestionList['QuestionList'][$key]['AddTime'] = date("Y-m-d H:i", $QuestionInfo['time']); //格式化回答时间 $QuestionList['QuestionList'][$key]['AnswerTimeLag'] = $QuestionInfo['QuestionStatus'] >= 2 && $QuestionInfo['atime'] ? Base_Common::timeLagToText($QuestionInfo['time'], $QuestionInfo['atime']) : "-"; //获取问题状态名称 $QuestionList['QuestionList'][$key]['QuestionStatusName'] = $QuestionStatusList[$QuestionInfo['QuestionStatus']]; //格式化问题内容 $QuestionList['QuestionList'][$key]['Content'] = Base_Common::cutstr($QuestionInfo['description'], 14); unset($QuestionInfo['description']); } $oMenCache->set('NewQuestionNumList_' . $List['StartDate'] . '_' . $List['EndDate'] . '_' . $List['QuestionType'] . '_' . $List['QtypeId'] . '_' . $List['QuestionStatus'] . '_' . $List['Page'] . '_' . $List['PageSize'], json_encode($QuestionList), 10); } $result = array('return' => 1, 'QuestionList' => $QuestionList); } else { $result = array('return' => 0, 'comment' => "无此问题主分类"); } } } else { $result = array('return' => 0, 'comment' => "无此问题分类"); } } else { $result = array('return' => 0, 'comment' => "时间有误"); } } else { $result = array('return' => 0, 'comment' => "验证失败,请检查URL"); } echo json_encode($result); }
/** *根据cookie信息获取未登录用户的服务记录数量 */ public function serviceLogUnloggedAction() { //基础元素,必须参与验证 $User['QuickAsk'] = urldecode(trim($this->request->QuickAsk)); $User['Time'] = abs(intval($this->request->Time)); $User['NewCount'] = abs(intval($this->request->NewCount)) ? abs(intval($this->request->NewCount)) : 3; //URL验证码 $sign = $this->request->sign; //私钥,以后要移开到数据库存储 $p_sign = '5173'; $sign_to_check = base_common::check_sign($User, $p_sign); //不参与验证的元素 $oMenCache = new Base_Cache_Memcache("Complaint"); $QuestionStatusList = $this->config->QuestionStatusList; $QuestionTypeList = $this->config->QuestionTypeList; //验证URL是否来自可信的发信方 if ($sign_to_check == $sign) { //验证时间戳,时差超过600秒即认为非法 if (abs($User['Time'] - time()) <= 600) { //初始化结果数组 $QuestionTypeArr = array('ask', 'suggest', 'complain'); foreach ($QuestionTypeArr as $key => $value) { $CategoryInfo = $this->oCategory->getCategoryByQuestionType($value, 'name'); $ServiceNum[$value] = array('Num' => 0, 'Content' => "我的" . $CategoryInfo['name'] . "记录"); } $NewLog = array(); $ask_type = unserialize(stripslashes($User['QuickAsk'])); $IdArr = array($ask_type['zx'], $ask_type['jy']); foreach ($IdArr as $key => $value) { if (trim($value) == "") { unset($IdArr[$key]); } } if (count($IdArr)) { //获取咨询数量 $ServiceNum['ask']['List'] = $this->oQuestion->getServiceQuestionList(array('IdList' => implode(",", $IdArr), 'QuestionType' => 'ask', 'Parent' => 0, 'Revocation' => 0)); $ServiceNum['ask']['Num'] = count($ServiceNum['ask']['List']); //从缓存服务器上获取是否有新未读数据 foreach ($ServiceNum['ask']['List'] as $key => $QuestionInfo) { $M = $oMenCache->get('fw' . $QuestionInfo['QuestionId']); if ($M) { $ServiceNum['ask']['New'] = 1; } //echo $QuestionInfo['QuestionId']."-".$QuestionInfo['status']."<br>"; if ($QuestionInfo['status'] == 1) { $NewLog[$QuestionInfo['time']][] = array('QuestionId' => $QuestionInfo['QuestionId'], 'QuestionType' => 'ask'); } } unset($ServiceNum['ask']['List']); //获取建议数量 $ServiceNum['suggest']['List'] = $this->oQuestion->getServiceQuestionList(array('IdList' => implode(",", $IdArr), 'QuestionType' => 'suggest', 'Parent' => 0, 'Revocation' => 0)); $ServiceNum['suggest']['Num'] = count($ServiceNum['suggest']['List']); //从缓存服务器上获取是否有新未读数据 foreach ($ServiceNum['suggest']['List'] as $key => $QuestionInfo) { $M = $oMenCache->get('fw' . $QuestionInfo['QuestionId']); if ($M) { $ServiceNum['suggest']['New'] = 1; } if ($QuestionInfo['status'] == 1) { $NewLog[$QuestionInfo['time']][] = array('QuestionId' => $QuestionInfo['QuestionId'], 'QuestionType' => 'suggest'); } } unset($ServiceNum['suggest']['List']); } else { $ServiceNum['ask']['Num'] = 0; $ServiceNum['suggest']['Num'] = 0; } $IdList = $ask_type['ts']; if (count(explode(',', $IdList)) >= 1 && $IdList != "") { //获取投诉数量 $ServiceNum['complain']['List'] = $this->oComplain->getComplainServiceList(array('IdList' => $IdList, 'Public' => '0,2')); $ServiceNum['complain']['Num'] = count($ServiceNum['complain']['List']); //从缓存服务器上获取是否有新未读数据 foreach ($ServiceNum['complain']['List'] as $key => $QuestionInfo) { $M = $oMenCache->get('ts' . $QuestionInfo['QuestionId']); if ($M) { $ServiceNum['complain']['New'] = 1; } if (in_array($QuestionInfo['status'], array(0, 4))) { $NewLog[$QuestionInfo['time']][] = array('QuestionId' => $QuestionInfo['QuestionId'], 'QuestionType' => 'complain'); } } unset($ServiceNum['complain']['List']); } else { $ServiceNum['complain']['Num'] = 0; } krsort($NewLog); $i = 0; $NewServiceList = array(); foreach ($NewLog as $Time => $TimeList) { foreach ($TimeList as $key => $Question) { if ($i < $User['NewCount']) { switch ($Question['QuestionType']) { case "ask": $QuestionInfo = $this->oQuestion->getQuestion($Question['QuestionId'], "id,description,time,atime,status,qtype"); //生成问题链接 $QuestionInfo['QuestionUrl'] = $this->oQuestion->getQuestionLink($QuestionInfo['id'], "question"); //复制问题分类 $QuestionInfo['QuestionType'] = $Question['QuestionType']; //生成问题状态 if ($QuestionInfo['status'] == 1) { $QuestionInfo['QuestionStatus'] = 1; } else { $QuestionInfo['QuestionStatus'] = 2; } $NewServiceList[] = $QuestionInfo; break; case "suggest": $QuestionInfo = $this->oQuestion->getQuestion($Question['QuestionId'], "id,description,time,atime,status,qtype"); //生成问题链接 $QuestionInfo['QuestionUrl'] = $this->oQuestion->getQuestionLink($QuestionInfo['id'], "question"); //复制问题分类 $QuestionInfo['QuestionType'] = $Question['QuestionType']; //生成问题状态 if ($QuestionInfo['status'] == 1) { $QuestionInfo['QuestionStatus'] = 1; } else { $QuestionInfo['QuestionStatus'] = 2; } $NewServiceList[] = $QuestionInfo; break; case "complain": $QuestionInfo = $this->oComplain->getComplain($Question['QuestionId'], "id,description,time,atime,status,qtype"); //生成问题链接 $QuestionInfo['QuestionUrl'] = $this->oComplain->getQuestionLink($QuestionInfo['id'], "complain"); //复制问题分类 $QuestionInfo['QuestionType'] = $Question['QuestionType']; //生成问题状态 if (in_array($QuestionInfo['status'], array(0, 4))) { $QuestionInfo['QuestionStatus'] = 1; } elseif (in_array($QuestionInfo['status'], array(1, 3))) { $QuestionInfo['QuestionStatus'] = 2; } if ($QuestionInfo['status'] == 2) { $QuestionInfo['QuestionStatus'] = 3; } $NewServiceList[] = $QuestionInfo; break; } } $i++; } } foreach ($NewServiceList as $key => $QuestionInfo) { if (!isset($QtypeList[$QuestionInfo['qtype']])) { $QtypeList[$QuestionInfo['qtype']] = $this->oQtype->getQtypeById($QuestionInfo['qtype']); } $NewServiceList[$key]['Qtype'] = $QtypeList[$QuestionInfo['qtype']]['name']; //格式化提问时间 $NewServiceList[$key]['AddTime'] = date("Y-m-d H:i", $QuestionInfo['time']); //格式化回答时间 $NewServiceList[$key]['AnswerTimeLag'] = $QuestionInfo['QuestionStatus'] >= 2 && $QuestionInfo['atime'] ? Base_Common::timeLagToText($QuestionInfo['time'], $QuestionInfo['atime']) : "-"; //获取问题状态名称 $NewServiceList[$key]['QuestionStatusName'] = $QuestionStatusList[$QuestionInfo['QuestionStatus']]; //格式化问题内容 $NewServiceList[$key]['Content'] = Base_Common::cutstr($QuestionInfo['description'], 14); //获取问题分类 $CategoryInfo = $QuestionTypeList[$QuestionInfo['QuestionType']]; //获取问题主分类 $NewServiceList[$key]['QuestionType'] = $CategoryInfo; unset($NewServiceList[$key]['description']); } //服务记录详情页面信息 $ServiceLogDetail = array('Url' => 'http://sc.5173.com/index.php?question/my_ask.html', 'Content' => '查看全部服务记录'); //入口信息 $ServiceEntrance = array('Url' => 'http://sc.5173.com/index.php?question/ask_skip.html', 'Content' => '我要提问'); $result = array('return' => 1, 'ServiceNum' => $ServiceNum, 'ServiceLogDetail' => $ServiceLogDetail, 'ServiceEntrance' => $ServiceEntrance, 'NewServiceList' => $NewServiceList); } else { $result = array('return' => 0, 'comment' => "时间有误"); } } else { $result = array('return' => 0, 'comment' => "验证失败,请检查URL"); } echo json_encode($result); }
public function getQuestionDetail($QuestionId, $History = 0) { //获取问题的ID和父ID $QuestionInfo = $this->getQuestion($QuestionId, 'id,pid', $History); //问题获取到 if ($QuestionInfo['id']) { //如果问题父ID大于0,为追问 if ($QuestionInfo['pid']) { $ParentID = $QuestionInfo['pid']; } else { $ParentID = $QuestionInfo['id']; } //获取主问内容 $ParentInfo = $this->getQuestion($ParentID, 'id,author,time,cid,cid1,qtype,attach,views,status,description,is_pj,comment,hidden', $History); //解包压缩数组 $Comment = unserialize($ParentInfo['comment']); //如果问题分类已经被转换 if ($Comment['convert']['to_id'] > 0) { $QuestionDetail = array('QuestionId' => $Comment['convert']['to_id'], 'QuestionType' => $Comment['convert']['to_type'], 'Transformed' => 1); } else { //格式化问题内容 $QuestionDetail = array('QuestionId' => intval($ParentInfo['id']), 'QuestionContent' => $ParentInfo['description'], 'AuthorName' => $ParentInfo['author'], 'QuestionTime' => date("Y-m-d H:i:s", $ParentInfo['time']), 'QuestionAttatch' => $ParentInfo['attach'], 'Views' => $ParentInfo['views'], 'CatagoryId' => $ParentInfo['cid'], 'QtypeId' => $ParentInfo['qtype'], 'QuestionStauts' => $this->processStatus($ParentInfo['status']), 'QuestionStatus' => $this->processStatus($ParentInfo['status']), 'SubQuestion' => 0, 'AssessStatus' => $ParentInfo['is_pj'], 'AssessCount' => intval($Comment['assess_num']), 'Hidden' => $ParentInfo['hidden'], 'Assess' => $ParentInfo['is_pj'] == 1 ? 0 : 1, 'SubQuestionList' => array()); //获取回答内容 $AnswerInfo = $this->getAnswer($QuestionDetail['QuestionId'], "*", $History); //如果获取到回答 if ($AnswerInfo['id']) { //可以继续追问 $QuestionDetail['SubQuestion'] = 1; //可以评价 $QuestionDetail['Assess'] = $QuestionDetail['Assess'] == 0 ? 0 : 1; //格式化回答内容 $QuestionDetail['Answer'] = array('OperatorName' => $AnswerInfo['author'], 'AnswerTime' => date("Y-m-d H:i:s", $AnswerInfo['time']), 'AnswerContent' => $AnswerInfo['content']); $QuestionDetail['AnswerLag'] = Base_Common::timeLagToText($ParentInfo['time'], $AnswerInfo['time']); } //获取追问信息 $SubQuestionList = $this->getQuestionList(array('Accepted' => -1, 'Parent' => $ParentID, 'Revocation' => -1, 'Help' => -1, 'History' => $History, 'QuestionType' => "ask,suggest"), 'id,time,cid,cid1,qtype,attach,views,status,description', 'asc'); $QuestionDetail['SubQuestionList'] = array(); if (count($SubQuestionList['QuestionNum']) > 0) { foreach ($SubQuestionList['QuestionList'] as $key => $SubQuestion) { //格式化追问内容 $QuestionDetail['SubQuestionList'][$key] = array('QuestionId' => intval($SubQuestion['id']), 'QuestionContent' => $SubQuestion['description'], 'QuestionTime' => date("Y-m-d H:i:s", $SubQuestion['time']), 'QuestionStauts' => $this->processStatus($SubQuestion['status']), 'QuestionStatus' => $this->processStatus($SubQuestion['status'])); //获取追问回答内容 $AnswerInfo = $this->getAnswer($SubQuestion['id'], "*", $History); //如果获取到回答 if ($AnswerInfo['id']) { //可以继续追问 $QuestionDetail['SubQuestion'] = 1; //格式化追问回答内容 $QuestionDetail['SubQuestionList'][$key]['Answer'] = array('OperatorName' => $AnswerInfo['author'], 'AnswerTime' => date("Y-m-d H:i:s", $AnswerInfo['time']), 'AnswerContent' => $AnswerInfo['content']); $QuestionDetail['SubQuestionList'][$key]['AnswerLag'] = Base_Common::timeLagToText($SubQuestion['time'], $AnswerInfo['time']); } else { //不可继续追问 $QuestionDetail['SubQuestion'] = 0; } } } } //如果是历史数据 if ($History > 0) { //不可继续追问 $QuestionDetail['SubQuestion'] = 0; //不可评价 $QuestionDetail['Assess'] = 0; } return $QuestionDetail; } else { return false; } }