<?php

class tongji_controller extends company{
  
	function index_action(){
    
        $jobM                     =   $this -> MODEL('job');
    
        $resumeM                  =   $this -> MODEL('resume');
    
		$this->company_satic();
    
		$this->public_action();
    
		$tjtype	=	array("1"=>"区域","2"=>"学历","3"=>"薪资","4"=>"工作经验");
    
		$this->yunset("tjtype",$tjtype);
		
		$uid	=	$this->uid;
        $cwhere['com_id']	=   $uid;
    
        $ListA		=     $jobM->getList($cwhere,array('field'=>'id,name'));
		
		$JobList	=	$ListA['list'];
     
        if(is_array($JobList) && $_GET['jobid']){
          
          foreach($JobList as $v){
            
            if($_GET['jobid']==$v['id']){
              
              $this->yunset("jobname",$v['name']);
              
            }
          }
        }
    
        $this->yunset("JobList",$JobList);
    
        $lwhere['com_id']    =   $where['com_id']  =  $uid;
		
        $mwhere['fid']       =  $uid;
    	$mwhere['isdel']     =  9;
		if($_GET['jobid']){
      
            $jobid             =   intval($_GET['jobid']);
      
            $where['job_id']   =   $jobid;
      
            $lwhere['jobid']   =   $jobid;
      
            $mwhere['jobid']   =   $jobid;

            $tdwhere['job_id']  =   $jobid;
      
		}
		if($_GET['sedate']){
      
			$sedate=str_replace(" ","" ,$_GET['sedate']);
      
			$arr = explode('~', $sedate);
      
			$sdate = $arr[0];
      
  			$days = ceil(abs(time() - strtotime($sdate))/86400);
        
			$edate = $arr[1];
      
 			$days = ceil(abs(strtotime($edate) - strtotime($sdate))/86400);
      
			$edatetime=strtotime($edate)+86400-1;
      
		}else{
      
			$days = 30;
      
			$sdate = date('Y-m-d',(time()-$days*86400));
      
			$edate = date('Y-m-d');
      
			$edatetime=time();
      
		}
    	
        $where['datetime'][]    =   array('>=',strtotime($sdate));
    
        $where['datetime'][]    =   array('<=',$edatetime,'AND');
    
        $lwhere['datetime'][]   =   array('>=',strtotime($sdate));
    
        $lwhere['datetime'][]   =   array('<=',$edatetime,'AND');
    
        $mwhere['datetime'][]   =   array('>=',strtotime($sdate));
    
        $mwhere['datetime'][]   =   array('<=',$edatetime,'AND');

        $tdwhere['datetime'][]  =   array('>=',strtotime($sdate));
    
        $tdwhere['datetime'][]  =   array('<=',$edatetime,'AND');
      
		$this->yunset("sdate",$sdate);
    
		$this->yunset("edate",$edate);
    
		$this->yunset("days",$days);
        //------邀请面试成功率
        
        $useridmsg              =     $jobM->getYqmsNum($mwhere);
    
        $mwhere['is_browse']    =     3;    
    
        $cgmsg                  =     $jobM->getYqmsNum($mwhere);
		
		if ($useridmsg&&$cgmsg){
      
		    $cgl=number_format($cgmsg/$useridmsg*100, 0, ',', ' ');
        
		}else{
      
		    $cgl=0;
        
		}
		$this->yunset("useridmsg",$useridmsg);
    
		$this->yunset("cgl",$cgl);
    
		//------查询投递的职位
        $tdwhere['com_id']    =  $uid;  
        $tdwhere['isdel']     =  9; 

        $tdnum                =     $jobM->getSqJobNum($tdwhere);      
        
		$this->yunset("tdnum",$tdnum);
    
		$List=$this->tj("userid_job",$where,$days);
    
		$this->yunset("list",$List);
    
		//------职位被浏览统计

		$LookList=$this->tj("look_job",$lwhere,$days);
    
		$this->yunset("looklist",$LookList);
    
		//---------以下是统计类型

        $useridjob      =     $jobM->getSqJobList($where,array('field'=>'job_id,eid'));
		if(is_array($useridjob)){
      
			foreach($useridjob as $v){
        
                $job_id[]=$v['job_id'];
        
                $eid[]=$v['eid'];
			}
		}
		if($_GET['type']=="1"){
      
			include PLUS_PATH."city.cache.php";
      
			foreach($city_index as $k=>$v){
        
				$dateArr[] = $city_name[$v];
        
			}
      
            $cwhere['id']		=   array('in',pylode(',',$job_id));
            $cwhere['groupby']	=  'provinceid';
      
			$listA	=   $jobM->getList($cwhere,array('field'=>'count(*) as num,provinceid'));
			
			$list	=	$listA['list'];
			if(is_array($list)){
        
				foreach($list as $key=>$value){
          
					$list[$key]['fields'] = $city_name[$value['provinceid']];
          
				}
        
			}
      
			$this->yunset("piename","区域简历投递统计");
      
		}elseif($_GET['type']=="2"){
      
			include PLUS_PATH."user.cache.php";
      
			foreach($userdata['user_edu'] as $k=>$v){
        
				$dateArr[] = $userclass_name[$v];
        
			}
      
      
            $expectwhere['id']        =   array('in',pylode(',',$eid));
      
            $expectwhere['groupby']    =  'edu';
      
			$list       =     $resumeM->getSimpleList($expectwhere,array('field'=>"count(*) as num,edu"));
      
			if(is_array($list)){
        
				foreach($list as $key=>$value){
          
					$list[$key]['fields'] = $userclass_name[$value['edu']];
          
				}
        
			}
			$this->yunset("piename","学历简历投递统计");
      
		}elseif($_GET['type']=="3"){
      
			$TongJi=$this->MODEL('tongji');
      
			$list = $TongJi->DataTj('resume_expect',array('id'=>array('in',@implode(",",$eid))),'resume_expect',"id");
      
			$list=$list['salary'];
      
			if(is_array($list)){
        
				foreach($list as $key=>$value){
          
					$list[$key]['num'] = $value['count'];
          
					$list[$key]['fields'] = $value['name'];
          
				}
        
			}
      
			$this->yunset("piename","薪资简历投递统计");

		}elseif($_GET['type']=="4"){
      
			include PLUS_PATH."user.cache.php";
      
			foreach($userdata['user_exp'] as $k=>$v){
        
				$dateArr[] = $userclass_name[$v];
        
			}
      
            $rexpectwhere['id']        =   array('in',pylode(',',$eid));
      
            $rexpectwhere['groupby']    =  'exp';
      
			$list       =     $resumeM->getSimpleList($rexpectwhere,array('field'=>"count(*) as num,exp"));
      
			if(is_array($list)){
        
				foreach($list as $key=>$value){
          
					$list[$key]['fields'] = $userclass_name[$value['exp']];
          
				}
        
			}
			$this->yunset("piename","工作经验简历投递统计");
      
		}
		$this->yunset("pielist",$list);
        
		$this->com_tpl('tongji');
	}
	function tj($table,$where,$days){
     
        $tongjiM                  =   $this -> MODEL('tongji');
    
        $where['groupby']         =   'td';
    
        $where['orderby']         =   array('td,desc');
    
    
		$joblist                  =$tongjiM->tjtotal($table,$where,array('field'=>'FROM_UNIXTIME(`datetime`,"%Y%m%d") as td,count(*) as cnt'));
		//整合广告赚钱折线图
		if(is_array($joblist)){
			$AllNum = 0;
      
			foreach($joblist as $key=>$value){
        
				$AllNum +=$value['cnt'];
        
				$Date[$value['td']] = $value;
        
			}
			if($days>0){
        
				for($i=0;$i<=$days;$i++){
          
					$onday = date("Ymd", strtotime(' -'. $i . 'day'));
          
					$td    = date('m-d', strtotime(' -'. $i . 'day'));
          
					$date    = date('Y-m-d', strtotime(' -'. $i . 'day'));
          
					if(!empty($Date[$onday])){
            
						$Date[$onday]['td'] = $td;
            
						$Date[$onday]['date'] = $date;
            
						$List[$onday] = $Date[$onday];
            
					}else{
            
						$List[$onday] = array('td'=>$td,'cnt'=>0,'date'=>$date);
            
					}
          
				}
        
			}
      
		}
    
		ksort($List);
    
		return $List;
	}

}
?>