<?php

/**
 * +----------------------------------------------------------------------
 * | Created By PhpStorm
 * +----------------------------------------------------------------------
 * | DATE: 2021/4/14
 * +----------------------------------------------------------------------
 * | TIME: 15:46
 * +----------------------------------------------------------------------
 * | Author: YangXing(925032253@qq.com)
 * +----------------------------------------------------------------------
 * | Class: crmAction
 * +----------------------------------------------------------------------
 */



/**
 * crm 管理
 * Class crmAction
 */
class crmAction extends baseAction
{
    public function index()
    {
		$param = mvc::$URL_PARAMS;
        LibTpl::Set('param',$param);

		if(isset($param['from'])&& $param['from']=='ypim')
		{
			$param['page'] = 1;
			$param['per'] = 1;
			$LibCrmApi = new LibCrmApi();
			$res = $LibCrmApi->Get('cus/getCustomerList',$param);
			$result = $res['data'];
			if(count($result['data'])==0){
				LibFc::Go('http://crm2.yiparts.com:86/Admin/index.php/Member/Index?Type=0&account='.$param['word']);
				exit();
			}
		}

        $ypwModel = new YpwBase();
        $addressData = $ypwModel->YpwDb->Table(sprintf("select pc_pid,pc_id,pc_name from yp_province_city where pc_pid=0"));
        LibTpl::Set('address',$addressData);
		$LibCrmApi = new LibCrmApi();
		$res = $LibCrmApi->Get('cus/getBrands');
		LibTpl::Set('brandArr',$res['data']);
		$orderArr = [
			'null'=>['默认', ''],
			'pv'=>['浏览数', ' order by ua_pv desc'],
			'vin_count'=>['VIN数', ' order by ua_vin_count desc'],
			'number_count'=>['号码数', ' order by ua_number_count desc'],
			'epc_count'=>['EPC数', ' order by ua_epc_count desc']
		];
		//所有业务员

		$B2cBase = new B2cBase();
		$res = $B2cBase->get('an_user',['au_uid,au_group,au_name']," AND au_group IN ('跑街令','业务部') AND au_status=1 ORDER BY  au_name desc");
		$salesArr =[];
		foreach ($res['data'] as $key => $val) {
			$salesArr[$val['au_group']][$val['au_uid']] = $val['au_name'];
		}
		foreach ($salesArr as $skey => $sval) {
			$allKeys =array_keys($sval);
			
			$salesArr[$skey][implode(',',$allKeys)] = sprintf('选择 [%s] 所有人', $skey);
		}
		LibTpl::Set('salesArr',$salesArr);
		$endDayArr = [
			7=>'7天内',
			15=>'15天内',
			30=>'30天内',
			60=>'60天内',
			90=>'90天内',
			-7=>'过期7天',
			-15=>'过期15天',
			-30=>'过期30天',
			-60=>'过期60天',
			-365=>'所有过期'
		];
		LibTpl::Set('endDayArr', $endDayArr);

		LibTpl::Set('orderArr',$orderArr);
		
        LibTpl::Put();
    }

    public function getAddress()
    {
    	$ypwModel = new YpwBase();
    	if($_POST['pc_id'] > 0){
    	   $addressData = $ypwModel->YpwDb->Table(sprintf("select pc_pid,pc_id,pc_name from yp_province_city where pc_pid=%d",$_POST['pc_id']));

    	}else{
    	   $addressData = $ypwModel->YpwDb->Table(sprintf("select pc_pid,pc_id,pc_name from yp_province_city where pc_pid=0"));

    	}
    	//ob_clean();
    	echo json_encode($addressData);
    	//LibFc::ajaxJsonEncode(['status' => true,'data' => $addressData]);
    }

    public function communicationRecord()
    {
        //todo权限
        LibTpl::Put();
    }

	/**
	 * @method 导出数据
	 * @author zhengweihua 
	 * @copyright 2023-05-31
	 */
	public function export()
	{
		LibFc::checkDlRule('DL06');
		$params =mvc::$URL_PARAMS;
		// 全部取接口可能报超时，改为分页调取
		$params['page'] = 1;
		$params['per'] = 1000;
		$LibCrmApi = new LibCrmApi();
		$res = $LibCrmApi->Get('cus/getCustomerList',$params);
		$result = $res['data'];
		$aValues = [];
		if($result['data'])
		{	
			$arr = $result['data'];
			foreach ($arr as $val) 
			{
				$contact = '';
				if($val['ctr_contact']){
					$contact .= $val['ctr_contact'];
				}
				if($val['ctr_uname']){
					if($val['ctr_contact']){
						$contact .= '-'.$val['ctr_uname'];
					}else{
						$contact .= $val['ctr_uname'];
					}
				}
				$time = '';
				if($val['cansee'])
				{	
					if($val['ctr_pjl_shop_id'] > 0 && $val['shop_vip_etime'] > time()){
						$time =  date('Y-m-d',$val['shop_vip_etime'])."到期 [".ceil(($val['shop_vip_etime']-time())/3600/24)."]";
					}else if($val['ctr_pjl_shop_id'] > 0 && $val['shop_vip_etime'] <= time() && $val['shop_vip_etime'] > 0) {
						$time =  date('Y-m-d',$val['shop_vip_etime'])."到期 [过".ceil((time()-$val['shop_vip_etime'])/3600/24)."]";
					}else if($val['ctr_pjl_shop_id'] > 0 && $val['shop_vip_etime'] == 0){
						$timer = (int) (time() - $val['shop_apply_time']);
						if((int)($timer / 86400) < 1){
							$tips =  '今天';
						}else{
							$tips = floor($timer / 86400).'天前';
						}
						$time =  date('Y-m-d',$val['shop_apply_time'])."申请 [".$tips."]";
					}else if($val['ctr_pjl_shop_id'] == 0 && $val['shop_vip_etime'] == 0){
						$time =  "";
					}
				} 
				$aValues[] = [
					$val['cansee']?implode('',$val['pcts']):'',
					$val['ctr_comname'],
					$val['ctr_addr'],
					$contact,
					$val['ctr_tel'],
					$time,
					$val['ua_pv'],
					$val['ua_vin_count'],
					$val['ua_number_count'],
					$val['ua_epc_count']
				];
			}
				
		}

		$OthExcel = new OthExcel();
		$aValues['fields'] = [
			'省市','公司名称','地址','联系人','联系电话','到期/申请','浏览','VIN','号码','EPC'
		];
		$OthExcel->writer($aValues);exit;
	}

}