<?php


class ask_model extends model{

    /**
     * @desc   查询member会员表
     * @param array $where
     * @param string $field
     * @return array|bool|false|string|void
     */
    private function getMemberList($where = array(), $field = '*'){
        
        $members  =   $this -> select_all('member', $where, $field);
        
        return $members;
    }

    /**
     * @desc    获取问答管理列表
     * @Desc    查训 question 表数据 ，多条数据查询
     * @param   $whereData :查询条件
     * @param   $data :自定义处理数组
     * @return array|bool|false|string|void
     */
	public function getList($whereData,$data=array())
    {
       
		$select   =   $data['field'] ? $data['field'] : '*';     
      
		$List     =   $this -> select_all('question', $whereData, $select);
		
		if(is_array($List) && $List ){
		    
		    if (isset($data['utype']) && $data['utype']=='admin') {
		        
		        $qids = array();

                foreach ($List as $v) {

                    $qids[] =   $v['id'];
                    $uids[] =   $v['uid'];   //作者id
                    $cids[] =   $v['cid'];   //类别id
                }

    			$awhere = array('qid'=>array('in', pylode(',', $qids)),'groupby'=>'qid');

    			if($data['utype']!='admin'){
    				$awhere['status'] = 1;
    			}

    			$alist	        =	$this->select_all('answer',$awhere,'qid,count(*) as num');
    			$memberList		=	$this->select_all('member',array('uid'=>array('in',pylode(',',$uids))));
    			$qclassList		=	$this->getQclassList(array('id'=>array('in',pylode(',',$cids))));
    			
    			foreach($List as $key => $val){
    				
    				$List[$key]['answer_num'] = 0;

    				if(!empty($alist)){
						foreach($alist as $av){
							if($av['qid'] == $val['id']){
								$List[$key]['answer_num']	=	$av['num'];	//	 参会企业
							}
						}
					}
					$List[$key]['pic']=checkpic($val['pic'],$this->config['sy_friend_icon']);
    				foreach($memberList as $v){
    					if($val['uid'] == $v['uid']){
    						$List[$key]['username']	=	$v['username'];
    					}
    				}
    				foreach($qclassList as $value){
    					if($val['cid'] == $value['id']){
    						$List[$key]['classname']	=	$value['name'];
    					}
    				}
    			}
		    }
			if(isset($data['utype']) && $data['utype'] == 'hot'){	// 推荐达人
				$recUser	=	$recUids	=	array();
				foreach ($List as $k => $v){
					$v['pic']	    =	checkpic($v['pic'], $this->config['sy_friend_icon']);
					if(!in_array($v['uid'], $recUids)){
						$recUids[]	=	$v['uid'];
						$recUser[]	=	$v;
					}
				}
				$List['recUser']	=	$recUser;
			}
			return $List;  
		}
	}

    /**
     * @desc    获取问答详情;查询 question 单条记录查询
     * @param $id
     * @param array $data
     * @return array|bool|false|string|void
     */
    public function getInfo($id, $data = array())
    {

        if (!empty($id)) {

            $where['id']    =   intval($id);
        } elseif ($data['where']) {

            $where          =   $data['where'];
        }

        $select     =   $data['field'] ? $data['field'] : '*';
        $question   =   $this->select_once('question', $where, $select);
        if ($question && is_array($question)) {
            $question['pic'] = checkpic($question['pic'], $this->config['sy_friend_icon']);
        }
        return $question;
	}

    /**
     * @desc    修改问答详情;修改question表数据
     * @param $whereData
     * @param array $data
     * @return bool
     */
    public function upAskInfo($whereData, $data = array())
    {

        if (!empty($whereData)) {

            $PostData   =   array(

                'title'     =>  $data['title'],
                'cid'       =>  $data['cid'],
                'visit'     =>  $data['visit'],
                'is_recom'  =>  $data['is_recom'],
                'content'   =>  $data['content'],
                'ip'        =>  fun_ip_get()
            );
            $result     =   $this->update_once('question', $PostData, array('id' => $whereData['id']));
            return $result;
        }else{

            return false;
        }
    }

    /**
     * @desc 修改问答审核状态
     * @param $id
     * @param array $data
     * @return bool
     */
    public function upStatusInfo($id,$where='', $data = array())
    {

        if (!empty($id)) {
            if (is_array($id)) {

                $where['id'] = array('in', pylode(',', $id));
            } else {

                $where['id'] = intval($id);
            }

            $result =   $this->update_once('question', $data, $where);
            return $result;
        }else{
            return false;
        }
    }

    public function upRecommend($whereData, $data = array())
    {

        if (!empty($whereData)) {

            $result =   $this->update_once('question', $data, $whereData);
            return $result;
        }else{

            return false;
        }
    }

    /**
     * @desc    发布问答
     * @param array $data
     * @return mixed
     */
    public function addAskInfo($data = array())
    {

        $return =   array();

        if (!empty($data)) {

            if ($data['title'] == "") {

                $return['msg']      =   "标题不能为空！";
                $return['errcode']  =   8;
                return $return;
            }
            include_once('notice.model.php');
            $noticeM    =   new notice_model($this->db, $this->def);
            $result     =   $noticeM->jycheck($_POST['authcode'], '职场提问');
            if (!empty($result)) {

                $return['errcode']  =   8;
                $return['msg']      =   $result['msg'] ? $result['msg'] : '';
                if ($result['error'] == 107) {

                    $return['waperrcode'] = 4;
                } else {

                    $return['waperrcode'] = 0;
                }
                return $return;
            }

            //判断每日最多发布问答数配置项，判断当日已发布问答数
            if (isset($this->config['sy_day_ask_num']) && (int)$this->config['sy_day_ask_num'] > 0) {

                $dayWhere        =   array(
                    'uid'               =>  $data['uid'],
                    'PHPYUNBTWSTART_A'  =>  '',
                    'add_time'          =>  array(
                        0   =>  array('>=', strtotime(date('Y-m-d')), ''),
                        1   =>  array('<', time(), '')
                    ),
                    'PHPYUNBTWEND_A'    =>  '',
                );
                $dayAskNum      =   $this->getQuestionNum($dayWhere);

                if ($dayAskNum >= $this->config['sy_day_ask_num']) {

                    $return['msg']      =   "您今天已发布" . $dayAskNum . "个问答了，请明日再发！";
                    $return['errcode']  =   8;
                    return $return;
                }
            }
            if (isset($this->config['sy_ip_ask_num']) && (int)$this->config['sy_ip_ask_num'] > 0) {

                $ip             =   fun_ip_get();
                $ipWhere        =   array(
                    'PHPYUNBTWSTART_A'  =>  '',
                    'ip'                =>  array(
                        0   =>  array('<>', '', ''),
                        1   =>  array('=', $ip, '')
                    ),
                    'PHPYUNBTWEND_A'    =>  '',
                    'PHPYUNBTWSTART_B'  =>  '',
                    'add_time'          =>  array(
                        0   =>  array('>=', strtotime(date('Y-m-d')), ''),
                        1   =>  array('<', time(), '')
                    ),
                    'PHPYUNBTWEND_B'    =>  '',
                );
                $dayIpAskNum    =   $this->getQuestionNum($ipWhere);

                if ($dayIpAskNum >= $this->config['sy_ip_ask_num']) {

                    $return['msg']      =   "今日已发布".$dayIpAskNum."个问答了，请明日再发！";
                    $return['errcode']  =   8;
                    return $return;
                }
            }

            $auto   =   true;

            if ($data['usertype'] && $data['uid']) {

                include_once('userinfo.model.php');
                $userInfoM  =   new userinfo_model($this->db, $this->def);
                $mInfo      =   $userInfoM->getUserInfo(array("uid" => $data['uid']), array("usertype" => $data['usertype']));

                $addData['nickname']        =   trim($data['username']);

                if ($data['usertype'] == 2 || $data['usertype'] == 4) {

                    $addData['nickname']    =   $mInfo['name'];
                    $addData['pic']         =   $mInfo['logo'];
                } elseif ($data['usertype'] == 1 || $data['usertype'] == 5) {

                    $addData['nickname']    =   $mInfo['name'];
                    $addData['pic']         =   $mInfo['photo'];
                } elseif ($data['usertype'] == 3) {

                    $addData['nickname']    =   $mInfo['realname'];
                    $addData['pic']         =   $mInfo['photo'];
                }
            }

            $addData['title']   =   $data['title'];
            $addData['cid']     =   $data['cid'];
            $addData['content'] =   str_replace(array("&amp;", "background-color:#ffffff", "background-color:#fff", "white-space:nowrap;"), array("&", '', '', ''), $data["content"]);
            $addData['content'] =   strip_tags(trim($addData['content']), "<p> <br> <b>");
            $addData['uid']     =   $data['uid'];
            $addData['add_time']=   time();
            $addData['ip']      =   fun_ip_get();

            //后台开启问答审核，则默认为未审核；关闭审核，则默认为审核通过
            $addData['state']   =   $this->config['ask_check'] == 1 ? 0 : 1;

            //审核未通过的企业用户，发布问答为“未审核”状态
            if ($addData['state'] != 0 && $data['usertype'] == 2) {
                $member         =   $this->select_once('member', array('uid' => $data['uid']), '`status`');
                if ($member['status'] != 1) {
                    $addData['state'] = 0;
                }
            }

            $return['id']       =   $this->insert_into('question', $addData);

            if ($return['id']) {

                include_once('integral.model.php');
                $integralM  =   new integral_model($this->db, $this->def);
                $result     =   $integralM->max_time('发布问题', $data['uid'], $data['usertype']);
                if ($result == true || $auto == false) {

                    $integralM->company_invtal($data['uid'], $data['usertype'], $this->config['integral_question'], $auto, "发布问题", true, 2, 'integral');
                }

                include_once('friend.model.php');
                $this->addMemberLog($data['uid'], $data['usertype'], "发布了问答《" . $data['title'] . "》", 19, 1);

                unset($_SESSION['authcode']);

                if ($data['state'] == 0) {

                    require_once('admin.model.php');
                    $adminM =   new admin_model($this->db, $this->def);
                    $adminM->sendAdminMsg(array('first' => '有新的问答需要审核，用户《' . $data['username'] . "》发布了问答《" . $data['title'] . "》", 'type' => 11));

                    $return['msg']      =   "已发布，正在审核中！";
                    $return['errcode']  =   9;
                } else {

                    $return['msg']      =   "发布成功！";
                    $return['errcode']  =   9;
                }
            } else {

                $return['msg']          =   "提问失败！";
                $return['errcode']      =   8;
            }
        }
        return $return;
    }


    /**
     * @desc   查询问答类别表
     * @param array $where
     * @param array $data
     * @return array|bool|false|string|void
     */
    public function getQclassList($where = array(), $data = array())
    {

        $select     =   $data['field'] ? $data['field'] : '*';
        $q_class    =   $this->select_all('q_class', $where, $select);
        return $q_class;
    }
	
	/**
	* @desc   获取问答类别详情
	*/
    public function getQclassInfo($id, $data = array())
    {

        if (!empty($id)) {

            $select     =   $data['field'] ? $data['field'] : '*';
            $QclassInfo =   $this->select_once('q_class', array('id' => intval($id)), $select);
            if ($QclassInfo['pic']) {

                $QclassInfo['pic']  =   checkpic($QclassInfo['pic']);
            }
        }
        return $QclassInfo;
    }

    /**
     * @desc   修改问答类别
     * @param $whereData
     * @param array $data
     * @return bool
     */
	public function upQclassInfo($whereData,$data = array())
    {
		
		if(!empty($whereData)) {
			
			$PostData	=	array(
				'name'		=>	$data['name'],
				'pid'		=>	$data['pid'],
				'sort'		=>	$data['sort'],
				'intro'		=>	$data['intro'],
				'content'	=>	$data['content'],
			);

			if($data['pic']){
				$PostData['pic']	=	$data['pic'];
			}
			
			if ($data && is_array($data)){
				
				 $nid  =  $this -> update_once('q_class', $PostData, array('id'=>$whereData['id']));
			}
		}
		return $nid;
	}

    /**
     * @desc   添加问答类别
     * @param array $data
     * @return bool
     */
    public function addQclassInfo($data = array())
    {

        $PostData   =   array(

            'name'      =>  $data['name'],
            'pid'       =>  $data['pid'],
            'sort'      =>  $data['sort'],
            'intro'     =>  $data['intro'],
            'content'   =>  $data['content'],
        );

        if ($data['pic']) {
            $PostData['pic']    =   $data['pic'];
        }

        if ($data && is_array($data)) {

            $nid    =   $this->insert_into('q_class', $PostData);
        }
        return $nid;
    }
	
	/**
	* @desc   查询问答话题
	*/
	public function getAnswersList($where = array(), $data=array()){
		
	    $field  =	empty($data['field']) ? '*' : $data['field'];
	    
	    $answers  =   $this -> select_all('answer', $where, $field);
		if(is_array($answers) && $answers ){
			
			$aids = array();
			foreach($answers  as $v){
				
				$aids[]		=	$v['id'];

				$a_uid[]	=	$v['uid'];
				
				$qid[]		=	$v['qid'];
			
			}

			$arwhere = array('aid'=>array('in', pylode(',', $aids)),'groupby'=>'aid');

			if($data['utype']!='admin'){
				$arwhere['status'] = 1;
			}

			$arlist	=	$this->select_all('answer_review',$arwhere,'aid,count(*) as num');
			

			$awhere['uid']	=	array('in',pylode(',',$a_uid));
			
			$member		=	$this -> select_all('member',$awhere);
			$resume		=	$this -> select_all('resume',$awhere,'`uid`,`photo`');
			
			$company	=	$this -> select_all('company',$awhere,'`uid`,`logo`');
			$ltinfo		=	$this -> select_all('lt_info',$awhere,'`uid`,`photo`');
			$question	=	$this -> getList(array('id'=>array('in',pylode(',',$qid))),array('field'=>'`id` as `qid`, `title`'));
			
			foreach($answers as $key => $val){

				$answers[$key]['comment'] = 0;

				if(!empty($arlist)){
					foreach($arlist as $arv){
						if($arv['aid']==$val['id']){
							$answers[$key]['comment'] = $arv['num'];
						}
					}
				}

		        if(strlen($val['nickname'])>10){
		          $answers[$key]['nickname']   =  mb_substr($val['nickname'],0,10,'utf-8').'...';
		        }
				foreach($member as $v){
					
					if($val['uid'] == $v['uid']){
						
						$answers[$key]['username']	=	$v['username'];
						
						if(!$val['nickname']){
							
							$answers[$key]['nickname']	=	$v['username'];
						}
					
					}
				
				}
				foreach($question as $v){
					
					if($val['qid']==$v['qid']){
						
						$answers[$key]['title']	=	$v['title'];
						
						$answers[$key]['qid']	=	$v['qid'];
					}
				}
				$answers[$key]['content'] = str_replace("\r\n","<br />",$val["content"]);
				
				if($val['pic']){
					
					$pic=checkpic($val['pic']);
				}else{
					foreach($resume as $va){
						
						if($va['uid']==$val['uid']){
							
							$pic=checkpic($va['photo']);
								
						}
					}
					foreach($company as $va){
						
						if($va['uid']==$val['uid']){
							
							$pic=checkpic($va['logo']);
							
						}
					}
					foreach($ltinfo as $va){
						
						if($va['uid']==$val['uid']){
							
							$pic=checkpic($va['photo']);
							
						}
					}
				}
				
				
				if($pic){
					
					$answers[$key]['pic']=$pic;
				}else{
					
					$answers[$key]['pic']=checkpic('',$this->config['sy_friend_icon']);
				}
			}
		
		}

	    return $answers;
	
	}	
	
	/**
	* @desc   修改回答
	*/
	public function upAnswerInfo($whereData ,$data = array()){
		
		if(!empty($whereData)) {
			
			if ($data && is_array($data)){
				
				 $nid  =  $this -> update_once('answer', $data, $whereData);
			
			}
		
		}
		
		return $nid;
	}
	/**
	* @desc   发布回答
	*/
	public function addAnswerInfo($data = array()){
		
		if(!empty($data)) {
			if($data['content']&&$data['id']){
				if($data['utype']=='wap'){
					session_cache_limiter('private, must-revalidate');
					
					session_start();
					
					$authcode=md5(strtolower($data['authcode']));	
					
					if($authcode!=$_SESSION['authcode'] || empty($_SESSION['authcode'])){
						
						unset($_SESSION['authcode']);
						
						$arr['msg']		=	"验证码错误！";
						
						return $arr;	
					}
				}
				
				$auto=true;
				 
				$info	=	$this -> getInfo($data['id'],array('field'=>'`id`,`uid`,`title`,`content`'));
				
				$content	=	$data["content"];
				
				$content	=	str_replace(array("&amp;","background-color:#ffffff","background-color:#fff","white-space:nowrap;"),array("&",'','',''),$content);
				
				$addData=array();
				
				if($data['usertype']&&$data['uid']){
					include_once ('userinfo.model.php');
					
					$userinfoM	=	new userinfo_model($this->db, $this->def);
					
					$minfo		=	$userinfoM -> getUserInfo(array("uid"=>$data['uid']),array("usertype"=>$data['usertype']));
					
					if($data['usertype']==2||$data['usertype']==4){
						
						$addData['nickname']	=	$minfo['name'];
						
						$addData['pic']			=	$minfo['logo'];
					}elseif($data['usertype']==1){
						
						$addData['nickname']	=	$minfo['name'];
						
						$addData['pic']			=	$minfo['photo'];
					}elseif($data['usertype']==3){
						
						$addData['nickname']	=	$minfo['realname'];
						
						$addData['pic']			=	$minfo['photo'];
					}
				}
				
				$addData['usertype']			=	$data['usertype'];
				
				$addData['qid']		=	$data['id'];
				
				$addData['content']	=	trim(strip_tags($content));
				
				$addData['uid']		=	$data['uid'];
				
				$addData['comment']	=	0;
				
				$addData['support']	=	0;
				
				$addData['oppose']	=	0;

				$addData['status']	=	isset($data['status']) ? $data['status'] : $this->config['answer_check'];
				
				$addData['add_time']=	time();
				
				$arr['id']=$this -> insert_into('answer', $addData);
				
				if($arr['id']){
					include_once ('integral.model.php');
				
					$integralM	=	new integral_model($this->db, $this->def);
					
					$result		=	$integralM->max_time('回答问题',$data['uid'],$data['usertype']);		
					if($result==true||$auto==false){
						
						$integralM->company_invtal($data['uid'],$data['usertype'],$this->config['integral_answer'],$auto,"回答问题",true,2,'integral');
					}
					if($addData['status']=='1'){
						$this -> update_once('question',array('answer_num'=>array('+','1'),"lastupdate"=>time()),array('id'=>$info['id']));
					}
					
					include_once ('friend.model.php');
					
					$this -> addMemberLog($data['uid'],$data['usertype'],"回答了问答《".$info['title']."》",19,1);
					
					$arr['msg']		=	"回答成功！";
					
					$arr['errcode']	=	9;
				}else{
					$arr['msg']		=	"回答失败！";
					
					$arr['errcode']	=	8;
				}
			}else{
				$arr['msg']		=	"非法操作！";
				
				$arr['errcode']	=	8;
			}
			return $arr;
		}
	}
	
	/**
	* @desc   评论列表
	*/
	public function getCommentsList ($whereData,$data=array()) {       
		
		$select  =   $data['field'] ? $data['field'] : '*'; 
		
		$CommentList    =   $this -> select_all('answer_review',$whereData,$select);

		if(is_array($CommentList) && $CommentList ){
			
			foreach($CommentList  as $v){
				
				$uids[]		=	$v['uid'];
			
			}
			$where['uid']	=	array('in',pylode(',',$uids));
			
			$memberList		=	$this -> select_all('member',$where,"`username`,`uid`");
			
			$userList		=	$this -> select_all('resume',$where,"`photo`,`uid`,`name`");
			
			$comList		=	$this -> select_all('company',$where,"`logo`,`uid`,`name`");
			
			$ltList			=	$this -> select_all('lt_info',$where,"`photo`,`uid`,`realname`");
			
			$trainList		=	$this -> select_all('px_train',$where,"`logo`,`uid`,`name`");
			
			foreach($CommentList as $key => $val){
				
				if($val['usertype']==1){
					foreach($memberList as $v){
					
						if($v['uid']==$val['uid']){
							
							$CommentList[$key]['username']	=	$v['username'];
							
							// $CommentList[$key]['nickname']	=	$v['username'];
						}
					
					}
					foreach($userList as $v){
						
						if($v['uid']==$val['uid']){
							
							$CommentList[$key]['nickname']	=	$v['name'];
							
							$v['photo']?$CommentList[$key]['pic']=$v['photo']:$CommentList[$key]['pic']=$this->config['sy_friend_icon'];
						}
					}
				}
				
				if($val['usertype']==2){
					foreach($comList as $v){
						
						if($v['uid']==$val['uid']){
							$CommentList[$key]['nickname']	=	$v['name'];

							$v['logo']?$CommentList[$key]['pic']=$v['logo']:$CommentList[$key]['pic']=$this->config['sy_friend_icon'];
						}
					}
				}
				if($val['usertype']==3){
					foreach($ltList as $v){
						
						if($v['uid']==$val['uid']){
							$CommentList[$key]['nickname']	=	$v['realname'];

							$v['photo']?$CommentList[$key]['pic']=$v['photo']:$CommentList[$key]['pic']=$this->config['sy_friend_icon'];
						}
					}
				}
				if($val['usertype']==4){
					foreach($trainList as $v){
						
						if($v['uid']==$val['uid']){
							$CommentList[$key]['nickname']	=	$v['name'];

							$v['logo']?$CommentList[$key]['pic']=$v['logo']:$CommentList[$key]['pic']=$this->config['sy_friend_icon'];
						}
					}
				}
			
			}
		
		}
		
		return $CommentList;
	
	}
	
	/**
	* @desc   评论返回回答列表
	*/
	public function getCommentBackQuestion($id,$data=array()){
		
		if(!empty($id)){
			
			$select  		  =   $data['field'] ? $data['field'] : '*';	
			
			$QuestionInfo	  =	  $this -> select_once('answer', array('id'=>intval($id)), $select);
		
		}
		
		return $QuestionInfo;
	
	}
	public function statusAnswer($id, $upData = array())
    {

        $ids    =   @explode(',', trim($id));

        $return =   array('msg' => '非法操作！', 'errcode' =>  8);

        if (!empty($id)) {

            $idstr      =   pylode(',', $ids);

            $upData     =   array(

                'status'     =>  intval($upData['status']),
                'statusbody'=>  trim($upData['statusbody']),
            );

            $result     =   $this -> update_once('answer', $upData, array('id' => array('in', $idstr)));

            if ($result) {

                if($upData['status'] == 1 || $upData['status'] == 2){

                    $msg    =   array();
                    $uids   =   array();

                    $answers  =   $this -> select_all('answer',array('id' => array('in', $idstr)),'`id`,`uid`');

                    foreach ($answers as $v){

                        $uids[] =   $v['uid'];
                    }

                    foreach ($answers as $k => $v){

                        if ($upData['status'] == 2) {

                            $statusInfo         =   '您的问答回复审核未通过';

                            if ($upData['statusbody']) {
                                $statusInfo     .=  '，原因：'.$upData['statusbody'];
                            }

                            $msg[$v['uid']][]   =   $statusInfo;
                        }elseif ($upData['status'] == 1){

                            $msg[$v['uid']][]   =  '您的问答回复审核通过';
                        }
					}


                    //发送系统通知
                    require_once 'sysmsg.model.php';
                    $sysmsgM    =   new sysmsg_model($this->db, $this->def);
                    $sysmsgM -> addInfo(array('uid' => $uids,'usertype'=>2,'content'=>$msg));
                }
                
                $return['msg']      =   '问答回复审核成功!';
                    
				$return['errcode']  =  9;
                
			}else{

                $return['msg']      =  '审核回复(ID:'.$idstr.')设置失败';
                $return['errcode']  =  8;
            }

        }else {

            $return['msg']          =   '请选择需要审核的问答回复！';
            $return['errcode']      =   8;
        }

        return $return;
    }
    public function statusAnswerReview($id, $upData = array())
    {

        $ids    =   @explode(',', trim($id));

        $return =   array('msg' => '非法操作！', 'errcode' =>  8);

        if (!empty($id)) {

            $idstr      =   pylode(',', $ids);

            $upData     =   array(

                'status'     =>  intval($upData['status']),
                'statusbody'=>  trim($upData['statusbody']),
            );

            $result     =   $this -> update_once('answer_review', $upData, array('id' => array('in', $idstr)));

            if ($result) {

                if($upData['status'] == 1 || $upData['status'] == 2){

                    $msg    =   array();
                    $uids   =   array();

                    $answers  =   $this -> select_all('answer_review',array('id' => array('in', $idstr)),'`id`,`uid`');

                    foreach ($answers as $v){

                        $uids[] =   $v['uid'];
                    }

                    foreach ($answers as $k => $v){

                        if ($upData['status'] == 2) {

                            $statusInfo         =   '您的回复评论审核未通过';

                            if ($upData['statusbody']) {
                                $statusInfo     .=  '，原因：'.$upData['statusbody'];
                            }

                            $msg[$v['uid']][]   =   $statusInfo;
                        }elseif ($upData['status'] == 1){

                            $msg[$v['uid']][]   =  '您的回复评论审核通过';
                        }
					}


                    //发送系统通知
                    require_once 'sysmsg.model.php';
                    $sysmsgM    =   new sysmsg_model($this->db, $this->def);
                    $sysmsgM -> addInfo(array('uid' => $uids,'usertype'=>2,'content'=>$msg));
                }
                
                $return['msg']      =   '回复评论审核成功!';
                    
				$return['errcode']  =  9;
                
			}else{

                $return['msg']      =  '审核回复评论(ID:'.$idstr.')设置失败';
                $return['errcode']  =  8;
            }

        }else {

            $return['msg']          =   '请选择需要审核的回复评论！';
            $return['errcode']      =   8;
        }

        return $return;
    }
	/**
	* @desc   评论数量
	*/
	public function getAnswersNum($where=array()){
		
		return $this -> select_num('answer', $where);
	
	}
	
	/**
	* @desc  获取评论详细信息
	*/
	public function getReviewInfo($id,$data=array()){
		
		if(!empty($id)){
			
			$select   	  =   $data['field'] ? $data['field'] : '*';	
			
			$ReviewInfo	  =	 $this -> select_once('answer_review', array('id'=>intval($id)), $select);
		
		}
		
		return $ReviewInfo;
	
	}
	
	/**
	* @desc   修改评论
	*/
	public function upReview($whereData ,$data = array()){
		
		if(!empty($whereData)) {
			
			$PostData	=	array(
				
				'content'	=>	$data['content'],
			
			);
			
			if ($data && is_array($data)){
				
				 $nid  =  $this -> update_once('answer_review', $PostData, array('id'=>$whereData['id']));
			
			}
		
		}
		
		return $nid;
	}
	/**
	* @desc   发布评论
	*/
	public function addReview($addData = array()){
		
		if(!empty($addData)) {
			
			$auto=true;
			 
			$data['aid']		=	(int)$addData['aid'];
			
			$data['qid']		=	(int)$addData['qid'];
			
			$data['content']	=	str_replace(array("&amp;","background-color:#ffffff","background-color:#fff","white-space:nowrap;"),array("&",'background-color:','background-color:','white-space:'),$addData['content']);
			 
			$data['uid']		=	$addData['uid'];
			
			$data['add_time']	=	time();

			$data['status']		=	isset($addData['status'])?$addData['status']:$this->config['answer_review_check'];
			
			$data['usertype']	=	$addData['usertype'];
			
			$new_id=$this -> insert_into('answer_review', $data);
			
			if($new_id){
				include_once ('integral.model.php');
				
				$integralM	=	new integral_model($this->db, $this->def);
				
				$result		=	$integralM -> max_time('评论问答',$addData['uid'],$data['usertype']);
				
				if($result==true||$auto==false){
					
					$integralM->company_invtal($data['uid'],$data['usertype'],$this->config['integral_answerpl'],$auto,"评论问答",true,2,'integral');
				}
				
				$this -> addMemberLog($addData['uid'],$addData['usertype'],"评论问答",19,1);
				if($data['status']=='1'){
					$this -> upAnswerInfo(array('id'=>$addData['aid']),array('comment'=>array('+','1')));
				}
				
				return '1';
			}else{
				return '0';
			}
		
		}
	}
	
	/**
	* @desc   删除评论
	*/
	public function delReview($delId){
		
		if(empty($delId)){
			
			return array(
				
				'errcode'	=>	8,
				
				'msg'		=>	'请选择要删除的数据！',
			
			);
		
		}else{
			
			if(is_array($delId)){
				
				$delId	=	pylode(',',$delId);
				
				$return['layertype']	=	1;
			
			}else{
				
				$return['layertype']	=	0;
			}
			
			$nid	=	$this -> delete_all('answer_review',array('id' => array('in',$delId)),'');
			
			if($nid){
			    $delNum =   count(explode(',', $delId));
				$this -> update_once("answer",array('comment'=>array('-', $delNum)),array('id'=>$_GET['aid']));
				
				$return['errcode']	=	$nid?'9':'8';
				
				$return['msg']		=	$nid ?'问答评论删除成功！' : '问答评论删除失败！';
			
			}
		
		}
		
		return	$return;
	
	}
	
	/**
	* @desc   删除试卷
	*/
	public function delquestion($delId,$data = array()){
		
		if($delId){
			if($data['utype'] = 'admin'){
				$delQuesWhere	=	array('id' => array('in',$delId));
				$delAnWhere		=	array('qid' => array('in',$delId));
			}else{
				$delQuesWhere	=	array('uid'=>$data['uid'],'id' => array('in',$delId));
				$delAnWhere		=	array('uid'=>$data['uid'],'qid' => array('in',$delId));
			}
			$result=$this -> delete_all('question' , $delQuesWhere,'');
			
			$this -> delete_all('answer_review' , $delAnWhere,'');
			
			$this -> delete_all('answer' , $delAnWhere,'');
			
		}
		return $result;
	}
	
	/**
	* @desc   删除问答类别
	*/
	public function delQclass($delId){
		
		if(empty($delId)){
           
			return	array(
              
			  'errcode' => 8,
               
			  'msg' 	=> '请选择要删除的数据！',                
            );
        
		}else{
			
			if(is_array($delId)){
				
				$delId	=	pylode(',',$delId);
				
				$return['layertype']	=	1;
			
			}else{
				
				$return['layertype']	=	0;
			}

			 
			$nid	=	$this -> delete_all('q_class',array('id' => array('in',$delId)),'');
			
			if($nid){
				
				$return['msg']		=	'问答分类';
				
				$return['errcode']	=	$nid ? '9' :'8';
				
				$return['msg']		=	$nid ? $return['msg'].'删除成功！' : $return['msg'].'删除失败！';
			
			}
		
		}
		
		return	$return;
		
	}
	
	public function delquestiongroups($delId){
		
		if($delId){
			
			$this -> delete_all('question' , array('id' => array('in',$delId)),'');
			
			$this -> delete_all('answer' , array('qid' => array('in',$delId)),'');
			
			$this -> delete_all('answer_review' , array('qid' => array('in',$delId)),'');
			
		}
	}
	
	/**
	* @desc   删除回答
	*/
	public function delAnswer($where=array(),$delId=''){
	 
		if($where){
			
			$result	=	$this -> delete_all('answer' , $where,'');
			
		}else{
			$result['layertype']		=	0;
			if(is_array($delId)){
				
				$delId	=	pylode(',',$delId);
				
				$result['layertype']	=	1;
			}
			$result['id']	=	$this -> delete_all('answer' , array('id'=>array('in',$delId)),'');
			
			$this -> delete_all("answer_review",array('aid'=>array('in',$delId)),'');
			
			$result['msg']		=	'用户回答(ID:'.$delId.')';
			
			$result['errcode']	=	$result['id']?9:8;
			
			$result['msg']		=	$result['id']?'删除成功！':'删除失败！';
		}
		return $result;
	}
	
	/**
	* @desc    获取问答数量
	* @desc    查询 question 数量
	*/
	public function getQuestionNum($wheredata = array()){
		
		return $this -> select_num('question',$wheredata);
	
	}
	
	/**
	 * @desc 查询关注信息表单条记录
	 * 
	 */
	public function getAtnInfo($whereData = array(), $data = array()){
	    
	    $select    =   $data['field'] ? $data['field'] : '*';
	    
	    $atnInfo   =   $this -> select_once('attention', $whereData, $select);
	    
	    return $atnInfo; 
	    
	}
	
	/**
	 * @desc   attention 表数据删除
	 * @param  array $whereData
	 * @return boolean
	 */
	function delAttention($whereData = array() ,$data = array()){
	    
	    if($data['type']=='one'){//单个删除
	        
	        $limit =	'limit 1';
	        
	    }
	    
	    if($data['type']=='all'){//多个删除
	        
	        $limit =	'';
	        
	    }
 
	    $result    =	$this	->	delete_all('attention', $whereData, $limit);
	    
	    return	$result;
	}
	
	/**
	 * @desc   修改attention表数据
	 * @param  array $whereData
	 * @param  array $data
	 * @return boolean
	 */
	function upAttention( $data = array(), $whereData = array()){
	    
	    if(!empty($whereData) && !empty($data)){
	        
	        $nid   =   $this -> update_once('attention', $data, $whereData);
	        
	    }
	    
	    return $nid;
	    
	}
	/**
	 * @desc   添加attention表数据
	 * @param  array $whereData
	 * @param  array $data
	 * @return boolean
	 */
	function addAttention($data = array()){
	    
	    if(!empty($data)){
	        
	        $nid   =   $this -> insert_into('attention', $data);
	        
	    }
	    
	    return $nid;
	    
	}
	
	function setAttention($data = array()){
		
		$isset  =   $this->getAtnInfo(array('uid'=>$data['uid'],'type'=>$data['type']));
		
		$ids    =   @explode(',',$isset['ids']);
		
		if($data['type']=='1'){
			$info		=	$this -> getInfo($data['id'],array('field'=>"`id`,`title`,`uid`,`atnnum`"));
			
			$gourl		=	Url('ask',array("c"=>"content","id"=>$info['id']));
			
			$content	=	"关注了<a href=\"".$gourl."\" target=\"_blank\">《".$info['title']."》</a>。";
			
			$n_contemt	=	"取消了对<a href=\"".$gourl."\" target=\"_blank\">《".$info['title']."》</a>的关注。";
			
			$log		=	"关注了《".$info['title']."》";
			
			$n_log		=	"取消了对《".$info['title']."》的关注";
		}else{
			$info		=	$this -> getQclassInfo($data['id'],array('field'=>"`id`,`name`,`atnnum`"));
			
			$content	=	"关注了《".$info['name']."》。";
			
			$n_contemt	=	"取消了《".$info['name']."》。";
			
			$log		=	"关注了".$info['name'];
			
			$n_log		=	"取消了对".$info['name']."</a>的关注。";
		}

		if($info['uid']==$data['uid']){
			$return['msg']		=	'不能关注自己发布的问题！';
			
			$return['errcode']	=	8;
			
			return $return;
		}else{
			$adata['uid']	=	$data['uid'];
			
			$adata['type']	=	$data['type'];
			
			$arr['isadd']	=	1;

			if($ids[0]==''||$ids[0]=='0'){
				$adata['ids']=	$data['id'];
				if(is_array($isset)&&$isset){
					$nid = $this -> upAttention($adata,array("id"=>$isset['id']));
				}else{
					$nid = $this -> addAttention($adata);
				}

				$this -> addMemberLog($data['uid'],$data['usertype'],$log,5,1);//会员日志

			} else if(in_array($data['id'],$ids)&&$ids[0]){
				$nids=array();
				foreach($ids as $val){
					if($val!=$data['id'] && $val && in_array($val,$nids)==false){
						$nids[]=$val;
					}
				}
				$arr['isadd']	=	0;
				
				$adata['ids']	=	pylode(',',$nids);
				
				$nid = $this -> upAttention($adata,array("id"=>$isset['id']));
				
				$this -> addMemberLog($data['uid'],$data['usertype'],$n_log,5,1);//会员日志

			}else if(in_array($data['id'],$ids)==false&&$ids[0]>0){

				$ids[]			=	$data['id'];
				
				$adata['ids']	=	pylode(',',$ids);
				
				$nid = $this -> upAttention($adata,array("id"=>$isset['id']));

				$this -> addMemberLog($data['uid'],$data['usertype'],$log,5,1);//会员日志

			}else if(in_array($data['id'],$ids)==false&&$ids[0]<1){

				$nid = $this -> upAttention(array("ids"=>$ids),array("id"=>$isset['id']));

				$this -> addMemberLog($data['uid'],$data['usertype'],$log,5,1);//会员日志

			}
			if($nid){
				if($data['type']=='1'){
					if($arr['isadd']){
						$atnnum	=	$info['atnnum']+1;
						
						$this -> upStatusInfo($info['id'], array("atnnum" => $atnnum));
				
						$sql['content']	=	$content;
					}else{
						$atnnum	=	$info['atnnum']-1;
						
						$this -> upStatusInfo($info['id'], array("atnnum" => $atnnum));
				
						$sql['content']	=	$n_contemt;
					}
				}
				if($data['type']=='2'){
					include(LIB_PATH."cache.class.php");
					
					$cacheclass	=	new cache(PLUS_PATH,$this->obj);
					
					$makecache	=	$cacheclass->ask_cache("ask.cache.php");
				}
				
				if($atnnum<0){
					$atnnum=0;
				}
				
				$return['id']		=	$nid;
				
				$return['msg']		=	'操作成功！';
				
				$return['errcode']	=	9;
				
				$return['atnnum']	=	$atnnum;
				
				$return['isadd']	=	$arr['isadd'];
				
				return $return;
			}else{
				$return['msg']		=	'操作失败！';
				
				$return['errcode']	=	8;
				
				return $return;
			}
		}
	}
	
	function upSupportInfo($data=array()){
		if(!empty($data)){
			
			$cookid	=	explode(',', $_COOKIE['support']);
			
			if(in_array($data['aid'],$cookid)){
				
				echo '2';die;
			}else{
				$id	=	$this -> upAnswerInfo(array('id'=>$data['aid']),array('support'=>array('+','1')));
				
				if($id){
					$this -> addMemberLog($data['uid'],$data['usertype'],"给问题回答点赞",19,1);
					
					$sendid		=	array();
					
					$sendid[]	=	$data['aid'];
					
					if($_COOKIE['support']){
						$support=	$_COOKIE['support'].','.pylode(',',$sendid);
					}else{
						$support=	pylode(',',$sendid);
					}
					require_once ('cookie.model.php');
					
					$cookieM	=	new cookie_model($this->db, $this->def);
					
					$cookieM -> SetCookie("support",$support,time() + 86400);
					
					echo '1';
				}else{
					echo '0';die;
				}
			}
		}
	}
	
    /**
     * @desc   引用log类，添加用户日志   
     */
    private function addMemberLog($uid,$usertype,$content,$opera='',$type='') {
        
        require_once ('log.model.php');
        
        $LogM = new log_model($this->db, $this->def);
        
        return  $LogM -> addMemberLog($uid,$usertype,$content,$opera,$type); 
        
    }
	
}
?>