	<?php


class crm_my_performance_depart_controller extends adminCommon{
    
	
	private function getAuser(){
		
		$AdminM			=	$this -> MODEL('admin');
		
		$adminUserInfo	=	$AdminM -> getAdminUser(array('uid' => $_SESSION['auid']),array('field'=>'org,power,spower'));
		
		if($adminUserInfo['org'] > 0){
			
        	$crmM		=	$this->MODEL('crm');	
        	$orgInfo	=	$crmM -> getOrgInfo(array('id' => $adminUserInfo['org']));
        	
        	$oIds	=	$orgIds	=	$orgIdss	=	$orgIdsss	=	array();
        	 
        	if ($adminUserInfo['power'] == '1'){	// 同级部门权限
        		$oList	=	$crmM -> getOrgList(array('level' => $orgInfo['level']));
        		
        		foreach ($oList as $k => $v) {
        			$orgIds[]	=	$v['id'];
        		}	
        	}
        	
        	if ($adminUserInfo['power'] == '1'){	// 子部门权限
	        	if ($orgInfo['level'] == '1'){
	        		 
	        		$orgList			=	$crmM -> getOrgList(array('fid' => $adminUserInfo['org']));
	        		
	        		foreach ($orgList as $ok => $ov) {
	        			$orgIdss[]		=	$ov['id'];	
	        		}
	        		
	        		$orgLists			=	$crmM -> getOrgList(array('fid' => array('in', pylode(',', $orgIdss))));
	        		
	        		foreach ($orgLists as $ook => $oov) {
	        			$orgIdsss[]		=	$oov['id'];
	        		}
	        		
	        	}elseif ($orgInfo['level'] == '2'){
	        		 
	        		$orgList			=	$crmM -> getOrgList(array('fid' => $adminUserInfo['org']));
	        		foreach ($orgList as $ok => $ov) {
	        			$orgIdss[]		=	$ov['id'];	
	        		}
	        		
	        	} 
        	}
        	$oIds			=	array_merge($orgIds, $orgIdss, $orgIdsss);
        	
            $adminUserList	=	$AdminM -> getList(array('uid'=>array('<>',$_SESSION['auid']),'org'=>array('in', pylode(',', $oIds))),array('field'=>'`uid`,`name`,`username`'));
    		foreach($adminUserList as $v){
    			$uids[]		=	$v['uid'];
    		}
    		$this->yunset('adminUserList',$adminUserList);
    		return $uids;
    	}
	}
	
	private $chartType = 'line';
    
    private function getTotal($timeBegin = '', $timeEnd = ''){
    	
    	$uids	=	$this->getAuser();
//    	$this->yunset('adminUserList',$pData['auser']);
    	
        $comM               =   $this->MODEL('company');
        $where              =   array();
		if($_GET['crmmanager']){
			$where['crm_uid']	=	$_GET['crmmanager'];
		}else{
		    $where['PHPYUNBTWSTART_A']  =   '';
		    $where['crm_uid'][]	        =	array('<>',0,'AND');
		    $where['crm_uid'][]	        =	array('in',pylode(',',$uids),'AND');
		    $where['PHPYUNBTWEND_A']    =   '';
		}
        if ($timeBegin != '') {
            $where['crm_time'][]    =   array('>=', $timeBegin);
            $where['crm_time'][]    =   array('<=', $timeEnd);
        }
        $comlist            =   $comM->getList($where, array('field' => 'count(uid) as `num`'));
        $row                =   $comlist['list'];
        $all                =   isset($row[0]['num']) && $row[0]['num'] > 0 ? $row[0]['num'] : 0;   //  所有客户
        $cwhere             =   array();
		if($_GET['crmmanager']){
			$cwhere['crm_uid']	=	$_GET['crmmanager'];
		}else{
		    $cwhere['PHPYUNBTWSTART_A']  =   '';
		    $cwhere['crm_uid'][]	     =	array('<>',0,'AND');
		    $cwhere['crm_uid'][]	     =	array('in',pylode(',',$uids),'AND');
		    $cwhere['PHPYUNBTWEND_A']    =   '';
		}
        
		$cwhere['isfollow'] =   '0';
        
        if ($timeBegin != '') {
            $cwhere['crm_time'][] = array('>=', $timeBegin);
            $cwhere['crm_time'][] = array('<=', $timeEnd);
        }
        $comlist            =   $comM->getList($cwhere, array('field' => 'count(uid) as `num`'));
        $row                =   $comlist['list'];
        $new                =   isset($row[0]['num']) && $row[0]['num'] > 0 ? $row[0]['num'] : 0;   //  待跟进客户
        $attention          =   $all - $new;    //  已近跟进客户
        return array( $all, $new, $attention);
    }

    public function index_action()
    {
         
    	$uids	=	$this->getAuser();
    	
        list ($all, $new, $attention) = $this->getTotal(strtotime(date('Y-m-01 00:00:00', time())), time());
        $data[]     =   array('time' => '本月', 'all' => $all, 'new' => $new, 'attention' => $attention);

        $timeEnd    =   strtotime(date('Y-m-d 00:00:00', time()));
        $week       =   date('w');
        if ($week == 0)
            $week = 7;
        $week --;
        $monday     =   strtotime("-{$week} day", $timeEnd);
        list ($all, $new, $attention)   =   $this->getTotal($monday, $timeEnd);
        $data[]     =   array('time' => '本周', 'all' => $all, 'new' => $new, 'attention' => $attention);
        $all        =   $this->getTotal($monday, $timeEnd);
        
        list ($all, $new, $attention)   =   $this->getTotal(strtotime('-1 day', $timeEnd), $timeEnd);
        $data[]     =   array('time' => '昨日', 'all' => $all, 'new' => $new, 'attention' => $attention);

        list ($all, $new, $attention) = $this->getTotal();
        $data[]     = array('time' => '累计', 'all' => $all, 'new' => $new, 'attention' => $attention);

        $this->yunset('data', $data);

        if ($_GET['time'] || $_GET['stime'] || $_GET['etime']) {
            if ($_GET['time']) {
                if ($_GET['time'] == - 1) {
                    
                    $timeBegin  =   mktime(0, 0, 0, date('m'), date('d'), date('y'));
                    $timeEnd    =   time();
                    $title      =   "客户统计 - 今天";
                } elseif ($_GET['time'] == 1) {
                    
                    $timeBegin  =   mktime(0, 0, 0, date('m'), date('d'), date('y'))- 86400;
                    $timeEnd    =   mktime(23, 59, 59, date('m'), date('d'), date('Y')) - 86400;
                    $title      =   "客户统计 - 昨天";
                } else {
                    
                    $timeBegin  =   mktime(0, 0, 0, date('m'), date('d'), date('Y')) - $_GET['time'] * 86400;
                    $timeEnd    =   mktime(23, 59, 59, date('m'), date('d'), date('Y'));
                    $title      =   "客户统计 - {$_GET['time']}天内";
                }
            }
            
            if ($_GET['stime']) {
                $stime          =   explode('-', $_GET['stime']);
                $etime          =   explode('-', $_GET['etime']);

                $timeBegin      =   mktime(0, 0, 0, $stime[1], $stime[2], $stime[0]);
                $timeEnd        =   mktime(23, 59, 59, $etime[1], $etime[2], $etime[0]);
                $title          =   "客户统计 - {$_GET['stime']}~{$_GET['etime']}";
            }
            
        } else {
            
            $title              =   "客户统计 - 全部数据";
        }

        $names  =   $values =   $dataGroupNames =   array();
        $where  =   array();
         
		
		if($_GET['crmmanager']){
			$where['crm_uid']	=	$_GET['crmmanager'];
		}else{
		    $where['PHPYUNBTWSTART_A']  =   '';
		    $where['crm_uid'][]	        =	array('<>',0,'AND');
		    $where['crm_uid'][]	        =	array('in',pylode(',',$uids),'AND');
		    $where['PHPYUNBTWEND_A']    =   '';
 		}
        if ($timeBegin != '') {
            $where['crm_time'][]    =   array('>=', $timeBegin);
            $where['crm_time'][]    =   array('<=', $timeEnd);
        }
        
        $where['groupby']   =   'date';
        $where['orderby']   =   'date';
        
        $companyM   =   $this->MODEL('company');
        
        $comlist    =   $companyM -> getList($where, array('field' => "count(uid) as `num`, from_unixtime(crm_time,'%Y-%m-%d') as `date`"));
        
        $row        =   $comlist['list'];
        
        $totalAll   =   0;
        
        if (count($row) < 1) {
            $all    =   array(
                'names'     =>  array(),
                'values'    =>  array()
            );
        } else {
            
            $allNames   =   array();
            $allValues  =    array();
            
            foreach ($row as $r) {
                $allNames[]     =   $r['date'];
                $allValues[]    =   $r['num'];

                $totalAll += $r['num'];
            }
            $all = array(
                'names'     =>  $allNames,
                'values'    =>  $allValues
            );
        }
        
        $cwhere                 =   array();
        
        if($_GET['crmmanager']){
			$cwhere['crm_uid']	=	$_GET['crmmanager'];
		}else{
		    $cwhere['PHPYUNBTWSTART_A']  =   '';
		    $cwhere['crm_uid'][]	     =	array('<>',0,'AND');
		    $cwhere['crm_uid'][]	     =	array('in',pylode(',',$uids),'AND');
		    $cwhere['PHPYUNBTWEND_A']    =   '';
		}
        $cwhere['isfollow']     =   '0';
        
        if ($timeBegin != '') {
            $cwhere['crm_time'][]   =   array('>=', $timeBegin);
            $cwhere['crm_time'][]   =   array('<=', $timeEnd);
        }
        
        $cwhere['groupby']      =   'date';
        $cwhere['orderby']      =   'date';
        
        $comlist    =   $companyM -> getList($cwhere, array('field' => "count(uid) as `num`, from_unixtime(crm_time,'%Y-%m-%d') as `date`"));
        $row        =   $comlist['list'];
        $totalNew   =   0;
        
        if (count($row) < 1) {
            $new    =   array(
                'names'     =>  array(),
                'values'    =>  array()
            );
        } else {
            
            $newNames   =   array();
            $newValues  =   array();
            
            foreach ($row as $r) {
                
                $newNames[]     =   $r['date'];
                $newValues[]    =   $r['num'];

                $totalNew += $r['num'];
            }
            $new    =   array(
                'names'     =>  $newNames,
                'values'    =>  $newValues
            );
        }
        $names  =   array_merge($all['names'], $new['names']);
        $names  =   array_unique($names);
        
        usort($names, 'usortS');

        $allValues  =   $newValues  =   array();
        $allK       =   $newK       =   0;
        
        foreach ($names as $n) {
            if (in_array($n, $all['names'])) {
                
                $allValues[]    =   $all['values'][$allK];
                $allK ++;
            } else {
                
                $allValues[]    =   0;
            }

            if (in_array($n, $new['names'])) {
                
                $newValues[]    =   $new['values'][$newK];
                $newK ++;
            } else {
            
                $newValues[] = 0;
            }
            
            $attentionValues[] = end($allValues) - end($newValues);
        }

        $all['values']  =   $allValues;
        $new['values']  =   $newValues;

        $dataGroupNames[]   =   '客户总数';
        $dataGroupNames[]   =   '未跟进';
        $dataGroupNames[]   =   '已跟进';

        $values[]   =   array(
            'name' =>   '客户总数',
            'type' =>   $this->chartType,
            'data' =>   $all['values']
        );
        $values[]   =   array(
            'name' =>   '未跟进',
            'type' =>   $this->chartType,
            'data' =>   $new['values']
        );

        $values[]   =   array(
            'name' =>   '已跟进',
            'type' =>   $this->chartType,
            'data' =>   $attentionValues
        );
        $data       =   array(
            'title'             =>  $title,
            'names'             =>  $names,
            'values'            =>  $values,
            'dataGroupNames'    =>  $dataGroupNames
        );
        $this->yunset($data);

        $this->yunset(array('totalAll'  => $totalAll, 'totalNew' => $totalNew, 'totalAttention' => ($totalAll - $totalNew)));

        $this->yuntpl(array('admin/crm_my_performance_depart'));
    }

    function usortS($prev, $next)
    {
        $p  =   strtotime($prev);
        $n  =   strtotime($next);
        if ($p == $n)
            return 0;

        return ($p > $n) ? 1 : - 1;
    }

    function concern_action(){
        if ($_GET['time'] || $_GET['stime'] || $_GET['etime']) {
            if ($_GET['time']) {
                if ($_GET['time'] == - 1) {
                    
                    $timeBegin  =   mktime(0, 0, 0, date('m'), date('d'), date('y'));
                    $timeEnd    =   time();
                    $title      =   "客户统计 - 今天";
                } elseif ($_GET['time'] == 1) {
                    
                    $timeBegin  =   mktime(0, 0, 0, date('m'), date('d'), date('y')) - 86400;
                    $timeEnd    =   mktime(23, 59, 59, date('m'), date('d'), date('Y')) - 86400;
                    $title      =   "客户统计 - 昨天";
                } else {
                    
                    $timeBegin  =   mktime(0, 0, 0, date('m'), date('d'), date('Y')) - $_GET['time'] * 86400;
                    $timeEnd    =   mktime(23, 59, 59, date('m'), date('d'), date('Y'));
                    $title      =   "客户统计 - {$_GET['time']}天内";
                }
            }
            if ($_GET['stime']) {
                
                $stime          =   explode('-', $_GET['stime']);
                $etime          =   explode('-', $_GET['etime']);

                $timeBegin      =   mktime(0, 0, 0, $stime[1], $stime[2], $stime[0]);
                $timeEnd        =   mktime(23, 59, 59, $etime[1], $etime[2], $etime[0]);
                $title          =   "跟进记录统计 - {$_GET['stime']}~{$_GET['etime']}";
            }
        } else {
            
            $title = "跟进记录统计 - 全部数据";
        }
        
        $names  =   $values =   $where  =   array();
        
        $uids	=	$this->getAuser();
		if($_GET['crmmanager']){
			$where['auid']	=	$_GET['crmmanager'];
		}else{
			$where['auid']  =   array('in',pylode(',',$uids));
        }
        if ($timeBegin != '') {
            $where['atime'][]   =   array('>=', $timeBegin);
            $where['atime'][]   =   array('<=', $timeEnd);
        }
        $where['groupby']   =   'type';
        $where['orderby']   =   'type';
        
        $crmM   =   $this->MODEL('crm');
        $row    =   $crmM->getConcernList($where, array('field' => 'count(id) as `num`, `type`'));

        $total  =   0;
        
        foreach ($row as $r) {
            $names[]        =   $r['type'];
            $rr['value']    =   $r['num'];
            $rr['name']     =   $r['type'];
            $values[]       =   $rr;
            $total += $r['num'];
        }
        $data   =   array(
            'title'     =>  $title,
            'names'     =>  $names,
            'values'    =>  $values
        );
        $this->yunset($data);
        $this->yunset('total', $total);
        
        include (PLUS_PATH . "crm.cache.php");
        $this->yunset('crmclass_name', $crmclass_name);
        $this->yuntpl(array('admin/crm_my_concern_depart'));
    }

    private function getAmountTotal($timeBegin = '', $timeEnd = '')
    {
        
        $where  =   array();
        $uids	=	$this->getAuser();
		if($_GET['crmmanager']){
			$where['crm_uid']	=	$_GET['crmmanager'];
		}else{
		    $where['PHPYUNBTWSTART_A']  =   '';
		    $where['crm_uid'][]	        =	array('<>',0,'AND');
		    $where['crm_uid'][]	        =	array('in',pylode(',',$uids),'AND');
		    $where['PHPYUNBTWEND_A']    =   '';
		}
        $where['order_state']       =   '2';
        if ($timeBegin != '') {
            
            $where['order_time'][]  =   array('>=', $timeBegin);
            $where['order_time'][]  =   array('<=', $timeEnd);
        }

        $companyorderM  =   $this->MODEL('companyorder');
        $row            =   $companyorderM->getList($where, array('field' => 'sum(order_price) as `num`'));

        $all            =   isset($row[0]['num']) && $row[0]['num'] > 0 ? $row[0]['num'] : 0;

        return array($all);
    }

    public function amount_action()
    {
        list ($all) =   $this->getAmountTotal(strtotime(date('Y-m-01 00:00:00', time())), time());
        $data[]     =   array('time' => '本月', 'all' => $all);

        $timeEnd    =   strtotime(date('Y-m-d 00:00:00', time()));
        $week       = date('w');
        if ($week == 0)
            $week   =   7;
        $week --;
        $monday     =   strtotime("-{$week} day", $timeEnd);
        list ($all) =   $this->getAmountTotal($monday, $timeEnd);
        $data[] = array('time' => '本周', 'all' => $all);

        $all        =   $this->getAmountTotal($monday, $timeEnd);
        list ($all) =   $this->getAmountTotal(strtotime('-1 day', $timeEnd), $timeEnd);
        $data[]     =   array('time' => '昨日', 'all' => $all);

        list ($all) =   $this->getAmountTotal();
        $data[]     =   array('time' => '累计','all' => $all);
        $this->yunset('data', $data);

        if ($_GET['time'] || $_GET['stime'] || $_GET['etime']) {
            if ($_GET['time']) {
                if ($_GET['time'] == - 1) {
                    
                    $timeBegin  =   mktime(0, 0, 0, date('m'), date('d'), date('y'));
                    $timeEnd    =   time();
                    $title      =   "客户统计 - 今天";
                } elseif ($_GET['time'] == 1) {
                    
                    $timeBegin  =   mktime(0, 0, 0, date('m'), date('d'), date('y')) - 86400;
                    $timeEnd    =   mktime(23, 59, 59, date('m'), date('d'), date('Y')) - 86400;
                    $title      =   "客户统计 - 昨天";
                } else {
                    
                    $timeBegin  =   mktime(0, 0, 0, date('m'), date('d'), date('Y'))  - $_GET['time'] * 86400;
                    $timeEnd    =   mktime(23, 59, 59, date('m'), date('d'), date('Y'));
                    $title      =   "客户统计 - {$_GET['time']}天内";
                }
            }
            if ($_GET['stime']) {
                $stime          =   explode('-', $_GET['stime']);
                $etime          =   explode('-', $_GET['etime']);

                $timeBegin      =   mktime(0, 0, 0, $stime[1], $stime[2], $stime[0]);
                $timeEnd        =   mktime(23, 59, 59, $etime[1], $etime[2], $etime[0]);
                $title          =   "成交金额统计 - {$_GET['stime']}~{$_GET['etime']}";
            }
        } else {
            
            $title = "成交金额统计 - 全部数据";
        }

        $names  =   $values =   $dataGroupNames =   array();
        
        $where  =   array();
        
         $uids	=	$this->getAuser();
		
        if($_GET['crmmanager']){
			$where['crm_uid']	=	$_GET['crmmanager'];
		}else{
		    $where['PHPYUNBTWSTART_A']  =   '';
		    $where['crm_uid'][]	        =	array('<>',0,'AND');
		    $where['crm_uid'][]	        =	array('in',pylode(',',$uids),'AND');
		    $where['PHPYUNBTWEND_A']    =   '';
		}
		$where['order_state']       =   '2';
        if ($timeBegin != '') {
            $where['order_time'][]  =   array('>=', $timeBegin);
            $where['order_time'][]  =   array('<=', $timeEnd);
        }
        $where['groupby']   =   'date';
        $where['orderby']   =   'date';
        $companyorderM      =   $this->MODEL('companyorder');
        $row                =   $companyorderM->getList($where, array('field' => "sum(order_price) as `num`, from_unixtime(order_time,'%Y-%m-%d') as `date`"));

        $totalAll   =   0;
        
        if (count($row) < 1) {
            $in =   array(
                'names'     =>  array(),
                'values'    =>  array()
            );
        } else {
            $inNames    =   array();
            $inValues   =   array();
            foreach ($row as $r) {
                $inNames[]  =   $r['date'];
                $inValues[] =   $r['num'];

                $totalAll += $r['num'];
            }
            $in =   array(
                'names'     =>  $inNames,
                'values'    =>  $inValues
            );
        }
        $names  =   array_merge($in['names']);
        $names  =   array_unique($names);
        
        usort($names, 'usortS');

        $inValues   =   array();
        $inK        =   0;
        
        foreach ($names as $n) {
            if (in_array($n, $in['names'])) {
                
                $inValues[] =   $in['values'][$inK];
                $inK ++;
            } else {
                
                $inValues[] =   0;
            }
        }

        $in['values']       =   $inValues;

        $dataGroupNames[]   =   '成交金额';

        $values[]   =   array(
            'name' =>   '成交金额',
            'type' =>   $this->chartType,
            'data' =>   $in['values']
        );

        $data   =   array(
            'title'     =>  $title,
            'names'     =>  $names,
            'values'    =>  $values,
            'dataGroupNames'    =>  $dataGroupNames
        );
        $this -> yunset($data);
        $this -> yunset(array('totalAll' => $totalAll));

        $this -> yuntpl(array('admin/crm_my_amount_depart'));
    }
}
?>