";
		// var_dump($change);die;
		$Params['order'] = 'nadsView';
        LibTpl::Set('sale', $sale);
        LibTpl::Set('area', $area);
        LibTpl::Set('today', $today);
        LibTpl::Set('conform', $change);
        LibTpl::Set('price', $price);
        LibTpl::Set('Params', $Params);
        LibTpl::Set('title', '广告位简易报表');
        LibTpl::Put();
    }


    // 展示广告设计要求,素材
    public function nadsDesign()
    {
        $Params = mvc::$URL_PARAMS;

        // 已有数据
        $ads = new AdsBase();
        $adsAr = $ads->get('pj_user_ads', ['*'], sprintf('and ads_id = %d', $Params['ads']), true);

        LibTpl::Set('adsAr', $adsAr['data']);
        LibTpl::Put();
    }

    // 通知设计
    public function nadsDesignSave()
    {
        $res = ['res' => true, 'data' => ''];
        if (isset($_POST['ads_id']) && filter_var($_POST['ads_id'], FILTER_VALIDATE_INT))
        {
            $ads = new AdsBase();

            $table = 'pj_user_ads';
            $where = sprintf('and ads_id = %d', $_POST['ads_id']);
            $column = ['ads_design' => time()];

            // 更新素材数据
            $res = $ads->set($table, $column, $where);
        }

        echo json_encode($res);
    }

    // 保存广告要求, 素材
    public function nadsSave()
    {
        $res = ['res' => true, 'data' => ''];
        if (isset($_POST['ads_id']) && filter_var($_POST['ads_id'], FILTER_VALIDATE_INT))
        {
            $ads = new AdsBase();

            $table = 'pj_user_ads';
            $where = sprintf('and ads_id = %d', $_POST['ads_id']);
            $column = array_merge(['ads_sucai' => '', 'ads_require' => ''], $_POST);
            $column['ads_sucai'] = trim($column['ads_sucai']);

            // 查找是否第一次提交素材
            $res = $ads->get($table, ['ads_sucai_time'], $where, true);
            if ($column['ads_sucai'] && isset($res['data']['ads_sucai_time']) && !$res['data']['ads_sucai_time']) {
                $column['ads_sucai_time'] = time();
            }

            // 更新素材数据
            $res = $ads->set($table, $column, $where);
        }

        echo json_encode($res);
    }

    // 展示跑街令所有广告图片, 提供模板参考
    public function nadsTemplate()
    {
        $ads = new AdsBase();
        $Params = mvc::$URL_PARAMS;

        $adsAr = [];
        if (isset($Params['tpl']) && filter_var($Params['tpl'], FILTER_VALIDATE_INT))
        {
            $table = 'pj_user_ads join pj_place_ads on ads_id=pla_ads_id';
            $where = sprintf('and pla_pa_id =%d and ads_img != "" order by ads_atime desc', $Params['tpl']);
            $adsAr = $ads->get($table, ['distinct ads_img'], $where);

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

        LibTpl::Set('Params', $Params);
        LibTpl::Set('adsAr', $adsAr);
        LibTpl::Put();
    }

    // 保存广告样板
    public function nadsSaveTpl()
    {
        $res = ['res' => true, 'data' => ''];
        if (isset($_POST['ads_id']) && filter_var($_POST['ads_id'], FILTER_VALIDATE_INT))
        {
            $ads = new AdsBase();

            $table = 'pj_user_ads';
            $where = sprintf('and ads_id = %d', $_POST['ads_id']);
            $column = array_merge(['ads_template' => ''], $_POST);

            // 更新素材数据
            $res = $ads->set($table, $column, $where);
        }

        echo json_encode($res);
    }

	//申请单列表页面
	function applyList()
	{
		LibTpl::Set('title', '申请单列表');
		$typeArr = [
			'invcode'=>'邀请码',
			'user'=>'账户相关',
			'orther'=>'其他'
		];
		LibTpl::Set('typeArr', $typeArr);
		LibTpl::Put();
	}

	/* 
	* 获取申请单列表数据
	*/
	function getApplyList()
	{
		$statusArr = [
			'0'=>'待处理',
			'2'=>'初审状态',
			'1'=> '已处理',
			'-1'=> '退回'
			
		];
		$typeArr = [
			'invcode'=>'邀请码',
			'user'=>'账户相关',
			'orther'=>'其他'
		];
		$Params = mvc::$URL_PARAMS;
		$where = sprintf('and ap_by_uid=%d', $_SESSION['_userid']);
		
		foreach($Params as $filed=>$val)
		{
			$val = LibFc::Escape($val);
			if($val == '') continue;
			switch($filed)
			{
				case 'keyword':
					$where .= sprintf(" and ap_content like '%%%s%%'", $val);
				break;
				case 'ap_type':
					$where .= sprintf(" and ap_type = '%s'", $val);
				break;
			}
		}

		$PjlBase = new PjlBase();
		$res = $PjlBase->get('bu_apply',['count(*) count'], $where, true);
		$count = $res['data']['count'];
		$listArr = [];
		if ($count > 0)
		{
			$page = (int) $Params['page'];
			$page = $page < 1 ? 1: $page;
			$limit = empty($Params['limit'])? 30: (int) $Params['limit'];
			$res = $PjlBase->get('bu_apply',['*'],sprintf('%s order by ap_id desc limit %d, %d', $where, ($page-1)*$limit, $limit));
			
			if (!empty($res['data']))
			{
				$listArr = $res['data'];
				foreach($listArr as $k=> &$v)
				{	
					$v['status_text'] = $statusArr[$v['ap_status']]??'';
					$v['ap_type_text'] = $typeArr[$v['ap_type']]??'';
					$v['ap_atime'] = date('Y-m-d H:i', $v['ap_atime']);
					$v['imgs'] = $v['ap_imgs']?explode(',',$v['ap_imgs']):'';
					$v['ap_etime'] = $v['ap_etime']?date('Y-m-d H:i', $v['ap_etime']):'';
					//先给了间隔
					$v['ap_content'] = strip_tags(str_replace("
",'  ',$v['ap_content']));
					$listArr[$k] = $v;
				}
				unset($v);
			}
		}
		$arr = [
			"code"=>0,
			"msg"=>"",
			"count"=>$count,
			"data"=>$listArr
		];
		echo json_encode($arr);
	}

	// 提交申请单页面
	function apply()
	{	
		$title = '创建申请单';
		$Params = mvc::$URL_PARAMS;
		$PjlBase = new PjlBase();
		if(!empty($Params['ap_id']))
		{
			$title = '编辑申请单';
			$res = $PjlBase->get('bu_apply',['*'], sprintf(" and ap_id=%d", $Params['ap_id']), true);
			$applyArr = $res['data'];
			
			$applyArr['imgs'] = explode(',', $applyArr['ap_imgs']);
			LibTpl::Set('applyArr', $applyArr);
		}
		LibTpl::Set('Params', $Params);
		LibTpl::Set('title', $title);
		LibTpl::Put();
	}
	
	//新增、编辑申请单
	function AddOrEditApply()
	{	
		$updateFlag = false;
		$PjlBase = new PjlBase();
		if(!empty($_POST['ap_id'])){
			$res = $PjlBase->get('bu_apply',['*'], sprintf(" and ap_id=%d ", $_POST['ap_id']), true);
			
			if(!empty($res['data'])){
				$updateFlag = true;
				//已处理不可编辑
				if($res['data']['ap_status']==1){
					LibFc::ajaxJsonEncode(['status'=>false, 'data'=>'该申请单已处理完毕，不可编辑！']);
				}
			}
			
		}
		$ap_to_uid  = 0;
		$dataArr = ['account'=> trim($_POST['ap_to_username'])];
		$LibYpApi = new LibYpApi();
		$res = $LibYpApi->Get('user/getUserByAccount',$dataArr);
		if($res['status']){
			$ap_to_uid = !empty($res['data'][0]['u_id'])?$res['data'][0]['u_id']:0;
		}
		$data   =  [
			'ap_type' => $_POST['ap_type'],
			'ap_to_uid' => $ap_to_uid, 
			'ap_imgs' =>  empty($_POST['imgs'])?'':implode(',',$_POST['imgs']),
			'ap_to_username'  =>	$_POST['ap_to_username']?trim($_POST['ap_to_username']):'',
			'ap_by_uid' => $_SESSION['_userid'],
			'ap_by_name' => $_SESSION['_realname'],
			'ap_content' => $_POST['ap_content'],
			'ap_status' => 0,
			'ap_atime' => time(),
		];
		if($updateFlag){
			$res =  $PjlBase->set('bu_apply',$data,sprintf(" and ap_id=%d ", $_POST['ap_id']));	
		}else{
			$res =  $PjlBase->add('bu_apply',$data);
		}
		if($_POST['ap_type']=='invcode'){
			$LibYpApi = new LibYpApi();
			$msg = "您有新的申请单等待处理，内容：".Strip_tags($_POST['ap_content']);
			$YpwUser = new YpwUser();
			$res = $YpwUser->getUser(['u_id'], sprintf('and u_name="%s"', 'wenfeng'), true);
			$postData = [
				'msg'=> $msg,
				'uids'=> $res['data']['u_id'],
				'msgType'=>'im'
			];
			$LibYpApi->Get('im/sendImSysNotice',[],$postData);
		}
		return LibFc::ajaxJsonEncode($res);
		// $data = [
		// 	'code' => $res?1:0,
		// 	'msg' => $res?'操作成功':'操作失败，请重试',
		// ];
		// exit(json_encode($data));
	}
	// 删除申请单
	function delApply()
	{
		if (is_numeric($_POST['ap_id']) ) {
            $PjlBase = new PjlBase();
            $result = $PjlBase->del('bu_apply', sprintf(' and ap_id = %d ', $_POST['ap_id']));
        }
		LibFc::ajaxJsonEncode($result);
	}

	// 上传图片
	function uploadImg()
	{
		$site = isset($_REQUEST['site']) ? strtolower(trim($_REQUEST['site'])): 'b2c';
		$OthFileCenter = new OthFileCenter();
		$dataArr = ['cate'=>$_REQUEST['cate'], 'file'=>$_FILES['file']];
		$fileRes = $OthFileCenter->upload($dataArr, $site);
		LibFc::ajaxJsonEncode($fileRes);
	}

	function uploadEditorImg()
	{
		$Params = mvc::$URL_PARAMS;
		$OthFileCenter = new OthFileCenter();
		$site = isset($_REQUEST['site']) ? strtolower(trim($_REQUEST['site'])): 'b2c';
		$dataArr = ['cate'=>$_REQUEST['cate'], 'file'=>$_FILES['upfile']];
		
		$fileRes = $OthFileCenter->upload($dataArr, $site);
		if($fileRes['status'])
		{
			$dataArr=[
				"state"=>"SUCCESS",
				"url"=>str_replace($fileRes['data']['small'], '', $fileRes['data']['url']),
				"title"=>$fileRes['data']['name'].'.'.$fileRes['data']['ext'],
    			"original"=>$fileRes['data']['name'].'.'.$fileRes['data']['ext']
			];
			echo json_encode($dataArr);
			die;
		}
	}

	/**
	 * @method 广告列表
	 * @author zhengweihua 
	 * @copyright 2023-05-30
	 */
	public function adsList()
	{
		$Params = mvc::$URL_PARAMS;


		//业务员
		$PjlBase = new PjlBase();
		$salesRes = $PjlBase->get('bu_user',['usr_name']," AND usr_status=1 AND usr_name!='' order by usr_seq,convert(usr_name using gbk)");
		LibTpl::Set('salesArr', $salesRes['data']);

		$AdsBase = new AdsBase();
		$res =$AdsBase->Get('pj_place', ['*'], ' order by pa_seq');
		$placeArr = $res['data'];
		LibTpl::Set('placeArr', $placeArr);
		LibTpl::Set('Params', $Params);
        LibTpl::Set('title', '广告列表-跑街的');
        LibTpl::Put();
	}

	/**
	 * @method 获取广告列表
	 * @author zhengweihua 
	 * @copyright 2023-05-29
	 */
	public function getAdsList()
	{
		LibFc::checkDlRule('DL07');
		$Params = mvc::$URL_PARAMS;
		$nowPage = isset($Params['page']) && $Params['page'] > 0 ? (int) $Params['page']:1;
        $perPage = empty($Params['limit'])? 30: (int) $Params['limit'];
		$where = '';
		foreach($Params as $k=>$v)
        {
            $v = trim($v);
            if($v == '') continue;
            switch($k)
            {
                case 'word':
                    $where .= sprintf(" and ads_name like '%%%s%%'", LibFc::Escape($v));
                break;
                case 'pa_id':
                    $where .= sprintf(" and pa_id =%d", $v);
                break;
				case 'pla_status':
                    $where .= sprintf(" and pla_status =%d", $v);
                break;
				case 'pla_sales':
                    $where .= sprintf(" and pla_sales ='%s'", LibFc::Escape($v));
                break;
				case 'pal_shoufei':
                    $where .= sprintf(" and pal_shoufei =%d", $v);
                break;
				case 'betime':
					$t = explode(' ~ ', $v);
					$where .= sprintf(" and pla_atime >= %d and pla_atime < %d", strtotime($t[0]), strtotime($t[1])+86400);
				break;
				case 'valid_status':
					if($v == 1){
						$where .= sprintf(" and pat_btime <= %d and pat_etime + 86400 >= %d",time(),time());
					}
					if($v == -1){
						$where .= sprintf(" and pat_etime + 86400 < %d",time());
					}	
				break;
				case 'tftime':
					$t = explode(' ~ ', $v);
					$sql = sprintf(" select pat_pla_id from pj_place_ads_time where pat_btime >= %d or pat_etime < %d ",strtotime($t[1])+86400, strtotime($t[0]));
					$where .= sprintf(" and pla_id not in (%s)",$sql);
				break;
				case 'tfword':
					$orwhere  = [];
					$YpcBase = new YpcBase();
					$res =$YpcBase->Get('yp_brand', ['b_id'], sprintf(" AND b_name LIKE '%%%s%%' ",LibFc::Escape($v)));	
					if($res['data']){
						$orwhere[] = sprintf(" pat_keyword in (%s)",implode(',',array_column($res['data'],'b_id')));
					}
					$AdsBase = new AdsBase();
					$res =$AdsBase->Get('yp_province_city', ['pc_id'], sprintf(" AND pc_name LIKE '%%%s%%' ",LibFc::Escape($v)));
					if($res['data']){
						$orwhere[] = sprintf(" pat_pc_id in (%s)",implode(',',array_column($res['data'],'pc_id')));
					}
					$where .= sprintf(" and %s",implode(' or ',$orwhere));
				break;
				case 'mod_type':
					if($v=='pc'){
						$sql = " select pat_pla_id from pj_place_ads_time where pat_modpc = 1 and pat_modcv =0 ";
					}elseif ($v=='cv') {
						$sql = " select pat_pla_id from pj_place_ads_time where pat_modpc = 0 and pat_modcv =1 ";
					}elseif($v=='all') {
						$sql = " select pat_pla_id from pj_place_ads_time where pat_modpc = 1 OR pat_modcv =1 ";
					}
					$where .= sprintf(" and pla_id in (%s)",$sql);
				break;
            }
        }
		
		$AdsBase = new AdsBase();
		$res =$AdsBase->Get('yp_province_city', ['pc_id as id','pc_name as name'], '');
		$pcArr = array_column($res['data'], 'name', 'id');

		$YpcBase = new YpcBase();
		$res =$YpcBase->Get('yp_brand', ['b_id as id','b_name as name'], '');
		$brandArr = array_column($res['data'], 'name', 'id');

		$table = 'pj_place_ads join pj_place on pa_id=pla_pa_id join pj_place_group on pg_id=pa_pg_id join pj_user_ads on ads_id=pla_ads_id left JOIN pj_place_ads_time ON pat_pla_id = pla_id ';
		$res = $AdsBase->get($table, ['count(distinct pla_id) as count'], $where, true);
		$total = $res['data']['count'];
      
		$adsArr = [];
		if($total > 0)
		{
			$res = $AdsBase->get($table, ['*'], sprintf(" %s group by pla_id order by CASE WHEN MIN(pat_etime) > %d THEN MIN(pat_etime)-%d ELSE %d*2 END ASC, max(pat_etime) desc limit %d,%d", $where, time(), time(),time(), ($nowPage-1)*$perPage, $perPage));
			
			$adsArr = array_column($res['data'], null, 'pla_id');
			$absIds = array_column($res['data'],'pla_ads_id');
			if(!empty($adsArr))
			{
				$res = $AdsBase->get('pj_place_ads_time', ['*'], sprintf(" and pat_pla_id in(%s) order by pat_etime desc", implode(',', array_keys($adsArr))));
				/**
				 * @var $adsReportDate array 获取广告的展现量和点击量
				 */
				$adsReportDate = $AdsBase->get('pj_ads_report_date',['ard_ads_id','sum(ard_show) as ard_show_sum,sum(ard_click) as ard_click_sum'],sprintf(' and ard_ads_id in(%s) group by ard_ads_id',implode(',',$absIds)));
				if(!empty($adsReportDate['data']))
				{
					$adsReportDate = array_column($adsReportDate['data'],null,'ard_ads_id');
					foreach($adsReportDate as &$value)
					{
						$value['click_rate'] = $value['ard_click_sum'] > 0 ? (number_format($value['ard_click_sum'] / $value['ard_show_sum'],4) * 100). '%' : '';
					}
				}
				else
				{
					$adsReportDate = [];
				}
				foreach ($adsArr as $key => $val) {
					$val['ard_show_sum'] = $adsReportDate[$val['pla_ads_id']]['ard_show_sum']?:'';
					$val['ard_click_sum'] = $adsReportDate[$val['pla_ads_id']]['ard_click_sum'] ?: '';
					$val['click_rate'] = $adsReportDate[$val['pla_ads_id']]['click_rate'] ?: '';
					$adsArr[$key] = $val;
				}

				foreach($res['data'] as $v)
				{
					$v['word'] = [];

					if($adsArr[$v['pat_pla_id']]['pa_keyword_type'] == 'brand'){
						$v['word'][] = $brandArr[$v['pat_keyword']];
					}

					if($adsArr[$v['pat_pla_id']]['pa_is_area']){
						$v['word'][] = $pcArr[$v['pat_pc_id']];
					}
					$v['word'] = implode(' ', $v['word']);
					
					$adsArr[$v['pat_pla_id']]['times'][] = $v;
				}
			}
		}
		
		$this->ajaxReturnJson(0,'',$total,array_values($adsArr));
		
	}

	/**
	 * @method 广告位统计
	 * @author zhengweihua 
	 * @copyright 2023-05-29
	 */
    public function adSlotStatistics()
    {
        //todo 权限
        $params = mvc::$URL_PARAMS;
        $plaId = (int) $params['ard_id'];
        if($plaId <= 0){
            echo '';exit;
        }
        $adsDb = (new AdsBase)->AdsDb;

		$groupByArr = [
			'day'=>['日统计', 'ard_date'],
			'month'=>['月统计', 'left(ard_date,6)'],
			'year'=>['年统计', 'left(ard_date,4)']
		];
		LibTpl::Set('groupByArr',$groupByArr);
		if(empty($groupByArr[$params['group']]))
			$params['group'] = 'month';
		$dfiled = $groupByArr[$params['group']][1];

        $result = $adsDb->Table(sprintf("select * from pj_place_ads_time where pat_pla_id =%d order by pat_etime desc",$plaId));
        $a = $adsDb->Row(sprintf("select * from pj_place_ads join pj_place on pa_id=pla_pa_id join pj_place_group on pg_id=pa_pg_id join pj_user_ads on ads_id=pla_ads_id JOIN pj_place_ads_time ON pat_pla_id = pla_id where ads_id=%d",$plaId));
        if($a['pa_keyword_type'] == 'brand'){
            $brandId = array_column($result,'pat_keyword');
            $where = '';
           
            $YpcBase = new YpcBase();
            $res =$YpcBase->Get('yp_brand', ['b_id as id','b_name as name'], sprintf(' and b_id in (%s) order by b_initial',implode(",",$brandId)));
            $allPcArr = array_column($res['data'], null, 'id');
            if(!empty($params['ard_month'])){
                $temp = explode(" ~ ",$params['ard_month']);
				$temp[0] = (int) date('Ymd',strtotime($temp[0]));
				//月份的天数
				$daynum = date('t',strtotime($temp[1]));
				$temp[1] = date('Ym',strtotime($temp[1])).$daynum;
               
                $where .= sprintf(" and ard_date between %d and %d",$temp['0'],$temp['1']);
            }
            if(!empty($params['ard_brand'])){
                $where .= sprintf(" and ard_word=%d",$params['ard_brand']);
            }
            $brand = $adsDb->Table(sprintf("select ard_word,sum(ard_show) as ard_show,sum(ard_click) ard_click, %s as ard_month from pj_ads_report_date as a where ard_ads_id=%d and 1=1 %s GROUP BY ard_month,ard_word order by ard_month desc",$dfiled, $plaId,$where));
            $brandArr = [];
            $click = 0;
            $show = 0;
            $other = [];
            foreach ($brand as $key => $value)
            {
                $click += $value['ard_click'];
                $show += $value['ard_show'];
                if(!in_array($value['ard_word'],$brandId)){
                    $other[] = $value;
                    unset($brand[$key]);
                }
            }
            $others = [];
            foreach ($other as $value)
            {
                $others[$value['ard_month']]['ard_click'] += $value['ard_click'];
                $others[$value['ard_month']]['ard_show'] += $value['ard_show'];
            }
            foreach ($brand as $val)
            {
                $brandArr[$val['ard_month']][] = $val;
            }
            $temp = [
                'ard_month' => '全部汇总',
                'ard_word' => '',
                'ard_pct_id' => '',
                'ard_show' => $show,
                'ard_click' => $click
            ];
            foreach ($brandArr as $key => &$item)
            {
                if(isset($others[$key])){
                    array_push($item,[
                        'ard_month' => $key,
                        'ard_word' => '其它',
                        'ard_pct_id' => 0,
                        'ard_show' => $others[$key]['ard_show'],
                        'ard_click' => $others[$key]['ard_click']
                    ]);
                }
                if(count($item) > 1){
                    foreach ($item as &$items)
                    {
                        if($items['ard_word'] != '其它'){
                            $items['ard_word'] = $allPcArr[$items['ard_word']]['name'];
                        }
                    }
                    array_multisort(array_column($item,'ard_show'), SORT_DESC, $item);
                    array_push($item,[
                        'ard_word' => "当月汇总",
                        'ard_pct_id' => '',
                        'ard_show' => array_sum(array_column($item,'ard_show')),
                        'ard_click' => array_sum(array_column($item,'ard_click')),
                        'ard_month' => $item['0']['ard_month']
                    ]);
                }else{
                    $item['0']['ard_word'] = $allPcArr[$item['0']['ard_word']]['name'];
                }
            }
            $brandArr['全部汇总']['0'] = $temp;
            LibTpl::Set('allPcArr',$allPcArr);
            LibTpl::Set('brandArr',$brandArr);
        }
        if(empty($brandArr)){
            //todo 优化
			$where = '';
			if(!empty($params['ard_month'])){
				$temp = explode(" ~ ",$params['ard_month']);
				$temp[0] = (int) date('Ymd',strtotime($temp[0]));
				//月份的天数
				$daynum = date('t',strtotime($temp[1]));
				$temp[1] = date('Ym',strtotime($temp[1])).$daynum;
				$where .= sprintf(" and ard_date between %d and %d",$temp['0'],$temp['1']);
			}
            if($a['pa_is_area']){
                $cityId = array_column($result,'pat_pc_id');
                //$where = '';
                //$where .= sprintf(" and ard_pct_id in (%s)",implode(",",$cityId));
                if(!empty($params['pc_id'])){
                    $where .= sprintf(" and ard_pct_id=%d",$params['pc_id']);
                }

                $address = $adsDb->Table(sprintf("select pc_id as id ,pc_name as name from yp_province_city where pc_pid=0 and pc_id in (%s)",implode(',',$cityId)));
                $address = array_column($address,null,'id');
                $list =  $adsDb->Table(sprintf("select ard_pct_id,sum(ard_show) as ard_show,sum(ard_click) ard_click, %s as ard_month from pj_ads_report_date where ard_ads_id=%d and 1=1 %s GROUP BY ard_month,ard_pct_id order by ard_month desc",$dfiled, $plaId,$where));
                $other = [];
                $click = 0;
                $show = 0;
                foreach ($list as $key => $value)
                {
                    $click += $value['ard_click'];
                    $show += $value['ard_show'];
                    if(!in_array($value['ard_pct_id'],$cityId)){
                        $other[] = $value;
                        unset($list[$key]);
                    }
                }
                $others = [];
                foreach ($other as $value)
                {
                    $others[$value['ard_month']]['ard_click'] += $value['ard_click'];
                    $others[$value['ard_month']]['ard_show'] += $value['ard_show'];
                }
                $listArr = [];
                foreach ($list as $value)
                {
                    $listArr[$value['ard_month']][] = $value;
                }
                $temp = [
                    'ard_month' => '全部汇总',
                    'pc_name' => '',
                    'ard_pct_id' => '',
                    'ard_show' => $show,
                    'ard_click' => $click
                ];
                foreach ($listArr as $key => &$value)
                {
                    if(isset($others[$key])){
                        array_push($value,[
                            'ard_month' => $key,
                            'pc_name' => '其它',
                            'ard_pct_id' => 0,
                            'ard_show' => $others[$key]['ard_show'],
                            'ard_click' => $others[$key]['ard_click']
                        ]);
                    }

                    if(count($value) > 1){
                        array_multisort(array_column($value,'ard_show'), SORT_DESC, $value);
                        foreach ($value as &$items)
                        {
                            if($items['pc_name'] != '其它'){
                                $items['pc_name'] = $address[$items['ard_pct_id']]['name'];
                            }
                        }
                        //var_dump($value);
                        array_push($value,[
                            'pc_name' => "当月汇总",
                            'ard_pct_id' => '',
                            'ard_show' => array_sum(array_column($value,'ard_show')),
                            'ard_click' => array_sum(array_column($value,'ard_click')),
                            'ard_month' => $value['0']['ard_month']
                        ]);
                    }else{
                        $value['0']['pc_name'] = $address[$value['0']['ard_pct_id']]['name'];
                    }
                }
                $listArr['全部汇总']['0'] = $temp;
                LibTpl::Set('address',$address);
                LibTpl::Set('listArr',$listArr);
            }
			else
			{
				$list =  $adsDb->Table(sprintf("select ard_pct_id,sum(ard_show) as ard_show,sum(ard_click) ard_click, %s as ard_month from pj_ads_report_date where ard_ads_id=%d and 1=1 %s GROUP BY ard_month order by ard_month desc",$dfiled, $plaId,$where));
                $other = [];
                $click = 0;
                $show = 0;
                foreach ($list as $key => $value)
                {
                    $click += $value['ard_click'];
                    $show += $value['ard_show'];
                }
                
                $listArr = [];
                foreach ($list as $value)
                {
                    $listArr[$value['ard_month']][] = $value;
                }
                $temp = [
                    'ard_month' => '全部汇总',
                    'ard_show' => $show,
                    'ard_click' => $click
                ];
                foreach ($listArr as $key => &$value)
                {
                    if(isset($others[$key])){
                        array_push($value,[
                            'ard_month' => $key,
                            'ard_show' => $others[$key]['ard_show'],
                            'ard_click' => $others[$key]['ard_click']
                        ]);
                    }

                    if(count($value) > 1){
                        array_multisort(array_column($value,'ard_show'), SORT_DESC, $value);
                        array_push($value,[
                            'ard_show' => array_sum(array_column($value,'ard_show')),
                            'ard_click' => array_sum(array_column($value,'ard_click')),
                            'ard_month' => $value['0']['ard_month']
                        ]);
                    }
                }
				unset($value);
                $listArr['全部汇总']['0'] = $temp;
                LibTpl::Set('quanqiuArr',$listArr);
			}
        }

        LibTpl::Set('title',$a['ads_name'].'---统计报表');
        LibTpl::Set('param',$params);
        LibTpl::Set('plaId',$plaId);
        $res = LibTpl::Fetch();
		echo $res;
    }

	/**
	 * @method 跟进记录列表
	 * @author zhengweihua 
	 * @copyright 2023-12-25
	 */
	public function followList()
	{	
		LibFc::checkDlRule('DL05');
		$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);
		}
		$dayRange = date('Y-m-d').' ~ '.date('Y-m-d');
		LibTpl::Set('dayRange',$dayRange);
		LibTpl::Set('salesArr',$salesArr);
		LibTpl::Put();
	}

	/**
	 * @method  获取跟进记录列表
	 * @author zhengweihua 
	 * @copyright 2023-12-25
	 */
	public function getFollowList()
	{
		LibFc::checkDlRule('DL05');
		$Params = mvc::$URL_PARAMS;
		$BaseDb = new BaseDb(mvc::$cfg['DB']['YPCRM']);
		$order = 'order by cfo_atime desc';
		$where = '';
		foreach($Params as $k=>$v)
        {
            $v = trim($v);
            if($v == '') continue;
            switch($k)
            {
				case 'keyword':
					$where .=sprintf("AND ctr_comname like '%%%s%%'",$v);
					break;
              	case 'follow_name':
				$where .=sprintf(" AND cfo_au_uid IN (%s)",$v);
					break;
				case 'follow_time':
					//最后申请时间
					$temp = explode('~',$v);
					if(count($temp)>1){
						$where .= sprintf(" AND  cfo_atime between %d and %d",strtotime($temp[0]),strtotime($temp[1])+86399);
					}
					break;
            }
        }
		$table = 'crm_follow left join crm_customer on cfo_ctr_id = ctr_id';
		$countres = $BaseDb->get($table,['count(*) as count'],$where,true);
		$count = $countres['data']['count'];
		$listArr = [];
		if ($count > 0)
		{
			$page = (int) $Params['page'];
			$page = $page < 1 ? 1: $page;
			$limit = empty($Params['limit'])? 30: (int) $Params['limit'];
			$fields = ['crm_follow.*,ctr_comname,ctr_contact,ctr_tel'];

			$res = $BaseDb->get($table, $fields,sprintf('%s %s limit %s, %s', $where,$order, ($page-1)*$limit, $limit));
			if(!empty($res['data']))
			{
				$listArr = $res['data'];	

			}
		}
		$arr = [
			"code"=>0,
			"msg"=>"",
			"count"=>$count,
			"data"=>$listArr
		];
		echo json_encode($arr);
	}


	/**
	 * @method  获取客户统计数据
	 * @author zhengweihua 
	 * @copyright 2024-2-23
	 */
	public function customerViews()
	{
		$Params = mvc::$URL_PARAMS;

		$page = empty($Params['page']) || $Params['page'] < 1? 1: (int) $Params['page'];
		$perPage = isset($_COOKIE['perPage'])? $_COOKIE['perPage'] : 20;
		$curDayTime  = strtotime(date('Y-m-d'));
		$where = sprintf(' AND fsl_etime>=%d',$curDayTime);
		if($_SESSION['_usergroup']=='kefu'){
			$where = sprintf(' AND fsl_etime>=%d AND fsl_remark not like "%%月卡%%"',$curDayTime);
		}

		$owhere = sprintf(' AND fsl_etime>=%d',$curDayTime);
		$AdsBase = new AdsBase();
		$res = $this->getSalesUser();
		$salesArr = $res['data'];
		LibTpl::Set('salesArr',$salesArr);
		$saleUidArr = [];
		foreach ($salesArr as $key => $val) {
			foreach ($val as $kk => $vv) {
				$saleUidArr[] = $kk;
			}
		}
		$saleUidArr = array_unique($saleUidArr);
		$B2cBase = new B2cBase();
		$res = $B2cBase->get('an_user',['au_uid,au_name'],"AND au_status=1");
		$userArr = array_column($res['data'],'au_name','au_uid');
		$adsCondition = '';
		if(!isset($Params['uid']) && empty($Params['uid'])){
			if(in_array($_SESSION['_userid'],$saleUidArr)) $Params['uid'] = $_SESSION['_userid'];
		}
		foreach ($Params as $key => $val) {
			if(!$val) continue;
			switch ($key) {
				case 'sve_id':
					$where .= sprintf(" AND fsl_sve_id=%d",$val);
					$owhere .= sprintf(" AND fsl_sve_id=%d",$val);
					break;
				case 'pa_id':
					if(in_array($val,[84,86])){
						$sswhere = sprintf(" AND pa_id=%d and pat_modpc=1 AND pat_etime>=%d ",$val,$curDayTime);
						$adsCondition .=  sprintf(" and pat_modpc=1 and pat_etime>=%d",$curDayTime);
					}elseif(in_array($val,[840,860])){
						$sswhere = sprintf(" AND pa_id=%d and pat_modcv=1 AND pat_etime>=%d",($val/10),$curDayTime);
						$adsCondition .= sprintf(" and pat_modcv=1 and pat_etime>=%d",$curDayTime);
					}else{
						$sswhere = sprintf(" AND pa_id=%d AND pat_etime>=%d ",$val,$curDayTime);
					}
					$table = 'pj_place_ads 
					join pj_place on pa_id=pla_pa_id
					join pj_place_ads_time on pat_pla_id =pla_id';
					$res = $AdsBase->get($table,['pla_id'],$sswhere);
					if($res['data']){
						$desIds = implode(',',array_column($res['data'],'pla_id'));
						$where .= sprintf(" and fsl_des_id in (%s)",$desIds);
						$owhere  .= sprintf(" and fsl_des_id in (%s)",$desIds);
						
					}
					break;
				case 'uid':
					// $sql =  sprintf('SELECT distinct cca_ctr_id from crm_customer_admin where cca_au_uid in (%s)',$val);
					// $where .= sprintf(" AND (duc_usr_id in (%s) or ctr_id IN (%s))",$val,$sql);
					$where .= sprintf(" AND (cca_au_uid IN (%s) OR ccs_au_uid IN (%s))",$val,$val);
					// $owhere  .= sprintf(" AND duc_usr_id in (%s)",$val);
					break;
				case 'word':
					$where .= sprintf(" AND ctr_comname like '%%%s%%'",$val);
					break;
				case 'status':
					if($val==-1){
						$where .= sprintf(" AND fsl_etime<=%d ",$curDayTime);
						$owhere  .= sprintf(" AND fsl_etime<=%d ",$curDayTime);
					}elseif($val==1){
						$where .= sprintf(" AND fsl_etime>%d",$curDayTime);
						$owhere  .= sprintf(" AND fsl_etime>%d",$curDayTime);
					}
					break;
				case 'fwtime':
					$arr = explode('~',$val);
					if($arr){
						$where .= sprintf(" AND fsl_etime >=%d AND fsl_etime<%d",strtotime($arr[0]),strtotime($arr[1]));
						$owhere .= sprintf(" AND fsl_etime >=%d AND fsl_etime<%d",strtotime($arr[0]),strtotime($arr[1]));
					}
					break;

			}
 		}
		
		 if ($_SESSION['_usergroup'] == 'shangji') {
			$canSeeUser = $_SESSION['_xiajiUid'];
		} elseif ($_SESSION['_usergroup'] == 'yewu') {
			$canSeeUser = [$_SESSION['_userid']];
		}
		
		$res =$AdsBase->Get('yp_province_city', ['pc_id as id','pc_name as name'], '');
		$pcArr = array_column($res['data'], 'name', 'id');

		$YpcBase = new YpcBase();
		$res =$YpcBase->Get('yp_brand', ['b_id as id','b_name as name'], '');
		$brandArr = array_column($res['data'], 'name', 'id');

		$area = $AdsBase->get('pj_place', ['pa_id', 'pa_name', 'pa_size'], 'order by pa_name');
        $area = array_column($area['data'], null, 'pa_id');

        $area[84]['pa_name'] = 'VIN解码-乘用车';
        $area[84*10] = array_merge($area[84], [
            'pa_id' => 84*10,
            'pa_name' => 'VIN解码-商用车',
        ]);

        $area[86]['pa_name'] = '车型查询-乘用车';
        $area[86*10] = array_merge($area[86], [
            'pa_id' => 86*10,
            'pa_name' => '车型查询-商用车',
        ]);
        ksort($area, SORT_STRING); 
		LibTpl::Set('paArr',$area);
		//服务项目
		$CrmBase = new CrmBase();
		$res = $CrmBase->get('fad_service',['sve_id,sve_text']);
		LibTpl::Set('sveArr',array_column($res['data'],'sve_text','sve_id'));

		$ctrArr = [];
		//获取所有有合同的客户
		$table = sprintf('fad_contract 
		join crm_customer on ctr_id = fct_ctr_id
		JOIN crm_customer_admin on cca_ctr_id = fct_ctr_id
		JOIN fad_link_fct_sve on fsl_fct_id = fct_id
		join fad_link_fct_usr on duc_fct_id = fct_id
		left join crm_customer_share on ccs_ctr_id = fct_ctr_id');
		$CrmBase = 	new CrmBase();
		$res = $CrmBase->get($table, ['count(distinct ctr_id) as counts'], $where, true);
		$total = $res['data']['counts'];
		if ($total > 0) {
			$orderby = 'order by fsl_etime asc';
			$res = $CrmBase->get($table, ['crm_customer.*,cca_au_uid'], sprintf(" %s  GROUP BY ctr_id %s LIMIT %d, %d",$where,$orderby,($page - 1) * $perPage, $perPage));
			$ctrArr = $res['data'];
			$ctrIds = array_column($ctrArr,'ctr_id');
			//获取计划
			$ctrIdArr = array_column($res['data'],'ctr_id');
			$dayPlanArr = [];
			$planres = $CrmBase->get('crm_plan',['cp_ctr_id,cp_ok'],sprintf(" AND cp_date=%d AND cp_ctr_id in (%s)",date('Ymd'),implode(',', $ctrIdArr)));
			if($planres['data']){
				foreach ($planres['data'] as $key => $val) {
					$dayPlanArr[$val['cp_ctr_id']] = $val['cp_ok'];
				}
			}
			

			//当前用户的客户意向等级
			$CrmContract = 	new CrmContract();
			$yixiangres = $CrmContract->getYixiangCtr($_SESSION['_userid']);

			$yixiangArr = $yixiangres['data'];
			$table = 'fad_link_fct_sve 
			join fad_service on sve_id = fsl_sve_id
			join fad_contract on fct_id = fsl_fct_id
			join fad_link_fct_usr on fct_id = duc_fct_id';
			$sveRes = $CrmBase->get($table,['fct_id,fct_ctr_id,fct_modified,fsl_btime,fsl_etime,fsl_sve_id,fsl_remark,fsl_des_id,sve_text,duc_usr_id'],sprintf(" %s AND fct_ctr_id IN (%s) order by fsl_etime asc",$owhere,implode(',',$ctrIds)));
			$sveArr = [];
			if($sveRes['data']){
				foreach ($sveRes['data'] as $key => $val) {
					//剩余时长 
					$val['lastDay'] = ceil(($val['fsl_etime'] - $curDayTime)  /3600 /24);
					//总时长
					$val['totalDay'] = ceil(($val['fsl_etime'] - $val['fsl_btime'])  /3600 /24);
					if ($val['fsl_sve_id'] == 7 && $val['fsl_des_id']) {
						$table = 'pj_place_ads 
						join pj_place on pa_id=pla_pa_id
						join pj_place_ads_time on pla_id = pat_pla_id';
						$res = $AdsBase->get($table, ['*'], sprintf(" %s AND pla_id = %d order by pat_etime asc",$adsCondition,$val['fsl_des_id']));
						
						if ($res['data']) {
							// $val['sve_text']  = $val['sve_text'].'-'.$res['data']['pa_name'];
							$adsArr = [];
							foreach ($res['data'] as $kk => $vv) {
								$item = [
									'pa_name'=>$vv['pa_name'],
									'sales'=> $vv['pla_sales'],
									'stime'=>date('Y-m-d',$vv['pat_btime']),
									'etime'=>date('Y-m-d',$vv['pat_etime']),
									'lastDay'=> ceil(($vv['pat_etime'] - $curDayTime)  /3600 /24),
									'totalDay'=> ceil(($vv['pat_etime'] - $vv['pat_btime']) /3600 /24)
								];
								$temp = $item['pa_name'];
								if ($vv['pa_is_area']) {
									$item['pa_name'] .='-'.$pcArr[$vv['pat_pc_id']];
								} else if ($vv['pa_is_keyword']) {
									if ($vv['pa_keyword_type'] === 'brand') {
											//
										if ((!$Params['pa_id']||in_array($Params['pa_id'],[84,86])) &&  $vv['pat_modpc'] && isset($brandArr[$vv['pat_keyword']])) {
											$item['pa_name'] =$temp.'-乘用车-'.$brandArr[$vv['pat_keyword']];
											$adsArr[] = $item;
										}
										//(!$Params['pa_id']||in_array($Params['pa_id'],[840,860])) &&
										if ( (!$Params['pa_id']||in_array($Params['pa_id'],[840,860])) &&$vv['pat_modcv'] && isset($brandArr[$vv['pat_keyword']])) {
											$item['pa_name'] =$temp.'-商用车-'.$brandArr[$vv['pat_keyword']];
											$adsArr[] = $item;
										}
									}
								} else {
									$item['pa_name'] .= '全球';
								}
								if ($vv['pa_keyword_type'] != 'brand') $adsArr[] = $item;
								
							}
							$val['adsArr'] = $adsArr;
						}
					}
					$sveArr[$val['fct_ctr_id']][] = $val;
				}
			}
			foreach ($ctrArr as $key => &$val) {
				$val['cansee'] = 'Y';
				if($canSeeUser && !in_array($val['cca_au_uid'],$canSeeUser)) $val['cansee'] = 'N';
				$val['sveArr'] = $sveArr[$val['ctr_id']]??[];
				$val['rank_name'] = $yixiangArr[$_SESSION['_userid']][$val['ctr_id']]?$yixiangArr[$_SESSION['_userid']][$val['ctr_id']]['cla_name']:'';
				$val['day_plan'] = $dayPlanArr[$val['ctr_id']]??'';
			}
			unset($val);
		}
		$Params['order'] = 'customerViews';
		LibTpl::Set('Params',$Params);
		$Pages = LibPage::Show($total,$perPage,true);
		LibTpl::Set('Pages',$Pages);
		LibTpl::Set('userArr',$userArr);
		LibTpl::Set('ctrArr',$ctrArr);
		LibTpl::Put();
	}

	/**
	 * 
	 */
	public function customerZjdq()
	{
		$Params = mvc::$URL_PARAMS;
		$CrmBase = new CrmBase();
		$AdsBase = new AdsBase();
		$curDayTime = strtotime(date('Y-m-d'));
		$where = sprintf(' AND fsl_etime>=%d AND fsl_remark not like "%%月卡%%"',$curDayTime);	
		$order =  ' order by fsl_etime asc';
		$adsCondition = sprintf(' and pat_etime>=%d',$curDayTime);
		
		$endDayArr  = ['+7'=>'7天内','+15'=>'15天内','+30'=>'30天内','+60'=>'60天内'];
		
		//过期的
		if($Params['action']=='gq'){
			$where = sprintf(' AND fsl_etime<%d',$curDayTime);
			$order =  ' order by fsl_etime desc';
			$adsCondition = sprintf(' and pat_etime<%d',$curDayTime);
			$endDayArr  = ['-7'=>'7天内','-15'=>'15天内','-30'=>'30天内','-60'=>'60天内'];
		}	
		LibTpl::Set('endDayArr',$endDayArr);
		$res = $this->getSalesUser('');
		$salesArr =$res['data'];
		LibTpl::Set('salesArr',$salesArr);
		$saleUidArr = [];
		foreach ($salesArr as $key => $val) {
			foreach ($val as $kk => $vv) {
				$saleUidArr[] = $kk;
			}
		}
		$saleUidArr = array_unique($saleUidArr);
		$B2cBase = new B2cBase();
		$res = $B2cBase->get('an_user',['au_uid,au_name'],"AND au_status=1");
		$userArr = array_column($res['data'],'au_name','au_uid');
		$sswhere = $adsCondition;
		if(!isset($Params['uid']) && empty($Params['uid'])){
			if(in_array($_SESSION['_userid'],$saleUidArr)) $Params['uid'] = $_SESSION['_userid'];
			
		}
		
		$res =$AdsBase->Get('yp_province_city', ['pc_id as id','pc_name as name'], '');
		$pcArr = array_column($res['data'], 'name', 'id');

		$YpcBase = new YpcBase();
		$res =$YpcBase->Get('yp_brand', ['b_id as id','b_name as name'], '');
		$brandArr = array_column($res['data'], 'name', 'id');

		foreach ($Params as $key => $val) {
			if(!$val) continue;
			switch ($key) {
				case 'sve_id':
					$where .= sprintf(" AND fsl_sve_id=%d",$val);
					break;
				case 'pa_id':
					if(in_array($val,[84,86])){
						$sswhere .= sprintf(" AND pa_id=%d and pat_modpc=1",$val);
						$adsCondition .= " and pat_modpc=1";
					}elseif(in_array($val,[840,860])){
						$sswhere .= sprintf(" AND pa_id=%d and pat_modcv=1",($val/10));
						$adsCondition .=" and pat_modcv=1";
					}else{
						$sswhere .= sprintf(" AND pa_id=%d",$val);
					}
					$table = 'pj_place_ads 
					join pj_place on pa_id=pla_pa_id
					join pj_place_ads_time on pat_pla_id =pla_id';
					
					$res = $AdsBase->get($table,['pla_id'],$sswhere);
					if($res['data']){
						$desIds = implode(',',array_column($res['data'],'pla_id'));
						$where .= sprintf(" and fsl_des_id in (%s)",$desIds);
					}
					break;
				case 'uid':
					if($_SESSION['_usergroup']=='kefu'){
						if($val==$_SESSION['_userid']){
							$where .= sprintf(" AND (cca_au_uid in (%s) or (ctr_kefu=%d AND cca_au_uid=172999))",$val,$val);	
						}elseif ($val==172999) { //2026/08/18：当客服搜索跑街令的时候把共享的用户也显示出来
							$where .= sprintf(" AND (cca_au_uid in (%s) OR ccs_ctr_id IS NOT NULL) ",$val);	
						}
					}else{
						$where .= sprintf(" AND (cca_au_uid in (%s) OR ccs_au_uid in (%s))",$val,$val);	
					}
					
					break;
				case 'word':
					$where .= sprintf(" AND ctr_comname like '%%%s%%'",$val);
					break;
				case 'fwtime':
					$arr = explode('~',$val);
					if($arr){
						$where .= sprintf(" AND fsl_etime >=%d AND fsl_etime<%d",strtotime($arr[0]),strtotime($arr[1]));	
					}
					break;
				case 'endDay':
					$etime = strtotime($val.' days',strtotime(date('Y-m-d')));
					if($Params['action']=='gq'){
						$where .= sprintf(" AND fsl_etime>=%d",$etime);	
					}else{
						$where .= sprintf(" AND fsl_etime<%d",$etime);
					}
					break;
				case 'tfword':
					$word = explode(',', str_replace('，', ',', $val));
					$pidArr =[];
					$bidArr =[];
					foreach ($word as $item_wd)
					{
						$item_wd = trim($item_wd);
						$pid = array_search($item_wd,$pcArr);
						if($pid) $pidArr[] = $pid;
						$bid = array_search($item_wd,$brandArr);
						if($bid) $bidArr[] = $bid;
					}
					$table = 'pj_place_ads 
					join pj_place on pa_id=pla_pa_id
					join pj_place_ads_time on pat_pla_id =pla_id';
					$sswhereArr = [];
					if($pidArr){
						$sswhereArr[] = sprintf(" pat_pc_id in (%s) ",implode(',',$pidArr));
					}
					if($bidArr){
						$sswhereArr[] = sprintf(" pat_keyword in (%s) ",implode(',',$bidArr));
					}
					if($sswhereArr){
						$str = implode('or',$sswhereArr);
						$sswhere .= sprintf(" and (%s)",$str);
						$adsCondition .= sprintf(" and (%s)",$str);
						$res = $AdsBase->get($table,['pla_id'],$sswhere);
						if($res['data']){
							$desIds = implode(',',array_column($res['data'],'pla_id'));
							$where .= sprintf(" and fsl_des_id in (%s)",$desIds);
						}
					}
					
					break;

			}
 		}

		$res = $AdsBase->get('pj_place',['pa_id,pa_name']); 
		LibTpl::Set('paArr',array_column($res['data'],null,'pa_id'));
		//服务项目
		$CrmBase = new CrmBase();
		$res = $CrmBase->get('fad_service',['sve_id,sve_text']);
		LibTpl::Set('sveArr',array_column($res['data'],'sve_text','sve_id'));

		

		$area = $AdsBase->get('pj_place', ['pa_id', 'pa_name', 'pa_size'], 'order by pa_name');
        $area = array_column($area['data'], null, 'pa_id');

        $area[84]['pa_name'] = 'VIN解码-乘用车';
        $area[84*10] = array_merge($area[84], [
            'pa_id' => 84*10,
            'pa_name' => 'VIN解码-商用车',
        ]);

        $area[86]['pa_name'] = '车型查询-乘用车';
        $area[86*10] = array_merge($area[86], [
            'pa_id' => 86*10,
            'pa_name' => '车型查询-商用车',
        ]);
        ksort($area, SORT_STRING); 
		LibTpl::Set('paArr',$area);

		$table = sprintf('fad_link_fct_sve 
		join fad_service on fsl_sve_id = sve_id
		join fad_contract on fct_id =fsl_fct_id
		join fad_link_fct_usr on duc_fct_id = fct_id
		join crm_customer on fct_ctr_id =ctr_id
		join crm_customer_admin on cca_ctr_id = fct_ctr_id
		left join crm_customer_share on ccs_ctr_id = fct_ctr_id');
		$res = $CrmBase->get($table,['count(*) as counts'],$where,true);
		$total = $res['data']['counts'];
		if($total>0){
			$fields = ['ctr_id,ctr_uid,ctr_comname,cca_au_uid,fct_id,fct_modified,fad_link_fct_sve.*,sve_text,duc_usr_id'];
			$res = $CrmBase->get($table, $fields, sprintf(" %s %s", $where, $order));
			
			//当前用户的客户意向等级
			$CrmContract = 	new CrmContract();
			$yixiangres = $CrmContract->getYixiangCtr($_SESSION['_userid']);
			$yixiangArr = $yixiangres['data'];

			//正常的项目
			$ccres = $CrmBase->get($table,['*'],sprintf("AND fsl_etime>%d",time()));
			$commonArr = [];
			foreach ($ccres['data'] as $key => $val) {
				$commonArr[$val['ctr_id']][$val['fsl_id']] = $val['fsl_sve_id'].'_'.$val['fsl_remark'];
			}
			
			$listArr = [];

			if ($_SESSION['_usergroup'] == 'shangji') {
				$canSeeUser = $_SESSION['_xiajiUid'];
			} elseif ($_SESSION['_usergroup'] == 'yewu') {
				$canSeeUser = [$_SESSION['_userid']];
			}

			//获取计划
			$ctrIdArr = array_column($res['data'],'ctr_id');
			$dayPlanArr = [];
			$planres = $CrmBase->get('crm_plan',['cp_ctr_id,cp_ok'],sprintf(" AND cp_date=%d AND cp_ctr_id in (%s)",date('Ymd'),implode(',', $ctrIdArr)));
			if($planres['data']){
				foreach ($planres['data'] as $key => $val) {
					$dayPlanArr[$val['cp_ctr_id']] = $val['cp_ok']?'Y':'N';
				}
			}

			foreach ($res['data'] as $key => $val) {
				$val['cansee'] = 'Y';
				if($canSeeUser && !in_array($val['cca_au_uid'],$canSeeUser)) $val['cansee'] = 'N';
				//存在续费的排除
				$tempCommon = $commonArr;
				unset($tempCommon[$val['ctr_id']][$val['fsl_id']]);
				if($tempCommon[$val['ctr_id']] && $val['fsl_sve_id']!=7 && in_array($val['fsl_sve_id'].'_'.$val['fsl_remark'],$tempCommon[$val['ctr_id']])){
					continue;
				}
				$val['rank_name'] = $yixiangArr[$_SESSION['_userid']][$val['ctr_id']]?$yixiangArr[$_SESSION['_userid']][$val['ctr_id']]['cla_name']:'';

				//剩余时长 
				$val['lastDay'] = ($val['fsl_etime'] - $curDayTime)>0?ceil(($val['fsl_etime'] - $curDayTime)  /3600 /24):floor(($val['fsl_etime'] - $curDayTime)  /3600 /24);
				//总时长
				$val['totalDay'] = ceil(($val['fsl_etime'] - $val['fsl_btime'])  /3600 /24);

				if ($val['fsl_sve_id'] == 7 && $val['fsl_des_id']) {
					$table = 'pj_place_ads 
					join pj_place on pa_id=pla_pa_id
					join pj_user_ads on pla_ads_id = ads_id
					join pj_place_ads_time on pla_id = pat_pla_id';
					$res = $AdsBase->get($table, ['*'], sprintf(" %s AND pla_id = %d",$adsCondition,$val['fsl_des_id']));
					
					
					if ($res['data']) {
		
						$adsArr = [];
						foreach ($res['data'] as $kk => $vv) {
							//排除已经续费的广告
							$ccsres = $AdsBase->get($table,['count(*) as counts'],sprintf(" and pla_id!=%d and ads_u_id =%d and pla_pa_id=%d and pat_keyword=%d 
							and  pat_pc_id=%d and pat_etime>%d and pat_modpc=%d and pat_modcv=%d ",$vv['pla_id'],$vv['ads_u_id'],$vv['pla_pa_id'],$vv['pat_keyword'],$vv['pat_pc_id'],time(),$vv['pat_modpc'],$vv['pat_modcv']),true);
							
							if($ccsres['data']['counts']>0){
								continue;
							}
			
							$item = [
								'pa_name'=>$vv['pa_name'],
								'sales'=> $vv['pla_sales'],
								'stime'=>date('Y-m-d',$vv['pat_btime']),
								'etime'=>date('Y-m-d',$vv['pat_etime']),
								'lastDay'=> ceil(($vv['pat_etime'] - $curDayTime)  /3600 /24),
								'totalDay'=> ceil(($vv['pat_etime'] - $vv['pat_btime']) /3600 /24)
							];
							$temp = $item['pa_name'];
							if ($vv['pa_is_area']) {
								$item['pa_name'] .='-'.$pcArr[$vv['pat_pc_id']];
							} else if ($vv['pa_is_keyword']) {
								if ($vv['pa_keyword_type'] === 'brand') {
									
									if ((!$Params['pa_id']||in_array($Params['pa_id'],[84,86])) && $vv['pat_modpc'] && isset($brandArr[$vv['pat_keyword']])) {
										$item['pa_name'] =$temp.'-乘用车-'.$brandArr[$vv['pat_keyword']];
										$adsArr[] = $item;
									}
									if ((!$Params['pa_id']||in_array($Params['pa_id'],[840,860])) && $vv['pat_modcv'] && isset($brandArr[$vv['pat_keyword']])) {
										
										$item['pa_name'] =$temp.'-商用车-'.$brandArr[$vv['pat_keyword']];
										$adsArr[] = $item;
									}
								}
							} else {
								$item['pa_name'] .= '全球';
							}
							if ($vv['pa_keyword_type'] != 'brand') $adsArr[] = $item;
						}
						if($adsArr){
							$val['adsArr'] = $adsArr;
						}

						if(!$adsArr){
							continue;
						}
						
					}
				}
				$val['day_plan'] = $dayPlanArr[$val['ctr_id']]??'';
				$listArr[] = $val;
			}
		}

		$Params['order'] = 'customerZjdq';
		LibTpl::Set('Params',$Params);
		
		LibTpl::Set('userArr',$userArr);
		LibTpl::Set('listArr',$listArr);
		LibTpl::Put();
	}

	/**
	 * @method 申请锁定
	 * @author zhengweihua 
	 * @copyright 2025-03-29
	 */
	public function applyLock()
	{	
		$Params = mvc::$URL_PARAMS;
		$where = '';
		if($Params['ads_id']){
			$where = sprintf(" AND ads_id=%d",$Params['ads_id']);
		}
		$modtype = '';
		if($Params['type']=='all'){
			$where .= sprintf(" AND pat_pc_id=%d",$Params['pc_id']);
		}else{
			$where .= sprintf(" AND pat_keyword=%d",$Params['pc_id']);
		}
	
		if($Params['type']=='pc'){
			$modtype = '乘用车';
			$where .= " AND pat_modpc=1";
		}
		if($Params['type']=='cv'){
			$modtype = '商用车';
			$where .= " AND pat_modcv=1";
		}
		$ads = new AdsBase();
		$column = ['pa_name','pat_pc_id','pat_keyword','pla_id'];
        $table = 'pj_user_ads a 
		JOIN pj_place_ads b ON ads_id = pla_ads_id 
		JOIN pj_place c ON pla_pa_id = pa_id
		join pj_place_ads_time on pla_id = pat_pla_id';
        $adsAr = $ads->get($table, $column, $where,true);
		if($adsAr['data']){

			if($adsAr['data']['pat_keyword']){
				$com = new ComBase();
				$brand = $com->get('bc_brand', ['brand_name'], sprintf('AND brand_id=%d',$adsAr['data']['pat_keyword']),true);
				$adsAr['data']['pc_name'] = $brand['data']['brand_name'];
			}else if($adsAr['data']['pat_pc_id']){
				$pc = $ads->get('yp_province_city', ['pc_name'], sprintf('AND pc_id=%d',$adsAr['data']['pat_pc_id']),true);
				$adsAr['data']['pc_name'] = $pc['data']['pc_name'];
			}else{
				$adsAr['data']['pc_name'] = '独家';
			}	
			$adsAr['data']['type'] = $Params['type'];
			$adsAr['data']['pc_id'] = $Params['pc_id'];
			$adsAr['data']['ads_name'] =  $adsAr['data']['pa_name'].($modtype?'-'.$modtype:'') .'-'.$adsAr['data']['pc_name'];
		}
		$this->HEAD_CSSJS['plugin'][] = 'ueditor';
		LibTpl::Set('HEAD_CSSJS', $this->HEAD_CSSJS);
		LibTpl::Set('dataArr',$adsAr['data']);
		LibTpl::Put();
	}

	/**
	 * @method 保存申请内容
	 * @author zhengweihua 
	 * @copyright 2025-03-29
	 */
	public function saveApplyLock()
	{
		if($_SERVER['REQUEST_METHOD']=='POST' && $_POST['cal_txt'])
		{
			$CrmBase = new CrmBase();
			//判断是否已经锁定
			$where = sprintf(" AND cal_check=1 AND cal_pla_id=%d AND cal_type='%s' AND cal_pc_id=%d", $_POST['pla_id'], $_POST['type'], $_POST['pc_id']);
			$res = $CrmBase->get('crm_ads_lock', ['*'], $where, true);
			if ($res['data']) {
				LibFc::ReturnJson(false,'该位置已被锁定，不可申请');
			}
			//判断是否已经申请过
			$where = sprintf(" AND cal_au_uid = %d AND cal_pla_id=%d AND cal_type='%s' AND cal_pc_id=%d", $_SESSION['_userid'], $_POST['pla_id'], $_POST['type'], $_POST['pc_id']);
			$res = $CrmBase->get('crm_ads_lock', ['*'], $where, true);
			if($res['data']){
				$data = [
					'cal_txt' => $_POST['cal_txt'],
					'cal_atime' => time(),
					'cal_etime' => time(),
					'cal_check'=>0,
					'cal_check_time'=>0,
				];
				$return  = $CrmBase->set('crm_ads_lock', $data,$where);
			}else{

				$where = '';
				if($_POST['pla_id']){
					$where = sprintf(" AND pla_id=%d",$_POST['pla_id']);
				}
	
				if($_POST['type']=='all'){
					$where .= sprintf(" AND pat_pc_id=%d",$_POST['pc_id']);
				}else{
					$where .= sprintf(" AND pat_keyword=%d",$_POST['pc_id']);
				}
			
				if($_POST['type']=='pc'){
		
					$where .= " AND pat_modpc=1";
				}
				if($_POST['type']=='cv'){
					$where .= " AND pat_modcv=1";
				}
				$ads = new AdsBase();
				$column = ['pla_id','pla_pa_id','pat_etime'];
				$table = 'pj_place_ads 
				join pj_place_ads_time on pla_id = pat_pla_id';
				$adsAr = $ads->get($table, $column, $where,true);

				$data = [
					'cal_txt' => $_POST['cal_txt'],
					'cal_au_uid' => $_SESSION['_userid'],
					'cal_atime' => time(),
					'cal_etime' => time(),
					'cal_ads_name'=>$_POST['ads_name'],
					'cal_pla_id' => $_POST['pla_id'],
					'cal_type' => $_POST['type'],
					'cal_pc_id' => $_POST['pc_id'],
					'cal_pa_id' => $adsAr['data']['pla_pa_id'],
					'cal_locked_stime'=> strtotime('-60 day',$adsAr['data']['pat_etime']),
					'cal_locked_etime'=> strtotime('-30 day',$adsAr['data']['pat_etime'])+86399,
				];

				$return  = $CrmBase->add('crm_ads_lock', $data);
			}
			
			LibFc::ReturnJson(true,$return['data']);
		}
		LibFc::ReturnJson(false,'请填写申请内容');
		
	}

	/**
	 * @method 解锁
	 * @author zhengweihua 
	 * @copyright 2025-03-29
	 */
	public function releaseLock()
	{
		if($_SERVER['REQUEST_METHOD']=='POST')
		{
			if(!$_POST['cal_pla_id'] && !$_POST['cal_pc_id'] && !$_POST['cal_type']){
				return LibFc::ReturnJson(false,'参数错误');
			}
			//锁定后在60-37天之间允许解锁一次，37-30天之间不再允许解锁；
			$CrmBase = new CrmBase();
			$res = $CrmBase->get('crm_ads_lock',['*'],sprintf(" AND cal_check=1 AND cal_au_uid=%d AND cal_pla_id=%d AND cal_pc_id=%d AND cal_type='%s'",$_SESSION['_userid'],$_POST['cal_pla_id'],$_POST['cal_pc_id'],$_POST['cal_type']),true);
			if ($res['data']) {
				$lockinfo = $res['data'];
				$AdsBase = new AdsBase();
				$table = 'pj_place_ads join pj_place_ads_time on pla_id = pat_pla_id';
				$where = '';
				if ($lockinfo['cal_pla_id']) {
					$where = sprintf(" AND pla_id=%d", $lockinfo['cal_pla_id']);
				}
				if (in_array($lockinfo['cal_type'], ['pc', 'cv'])) {
					$where .= sprintf(" AND pat_keyword=%d %s", $lockinfo['cal_pc_id'], $lockinfo['cal_type'] == 'pc' ? ' AND pat_modpc=1' : ' AND pat_modcv=1');
				} else {
					$where .= sprintf(" AND pat_pc_id=%d", $lockinfo['cal_pc_id']);
				}
				$adsinfo = $AdsBase->get($table, ['*'], $where, true);
				if ($adsinfo['data']) {
					$pat_etime = $adsinfo['data']['pat_etime'];
					$curtime = time();
					$day37 = strtotime(date('Y-m-d', strtotime('-37 day', $pat_etime)));
					$day60 = strtotime(date('Y-m-d', strtotime('-60 day', $pat_etime)));
					if ($curtime < $day37 && $curtime > $day60) {
						if ($lockinfo['cal_unlock_count'] > 0) {
							return LibFc::ReturnJson(false, '您已解锁过一次了，不允许再次解锁');
						}
						$where = sprintf(" AND cal_id=%d", $lockinfo['cal_id']);
						$sres = $CrmBase->set('crm_ads_lock', ['cal_unlock_count' => '#@cal_unlock_count+1', 'cal_check' => 2], $where);
						return LibFc::ReturnJson(true,'操作成功');
					} else {
						return LibFc::ReturnJson(false, '不允许解锁');
					}
				}
			}
		}

		LibFc::ReturnJson(false,'参数错误');
	}

	/**
	 * @method 审核
	 * @author zhengweihua 
	 * @copyright 2025-03-29
	 */
	public function auditApplyLock()
	{
		if($_SERVER['REQUEST_METHOD']=='POST'&&$_POST['cal_id'])
		{	
			$cal_id = $_POST['cal_id'];
			$cal_check = $_POST['cal_check'];
			$CrmBase = new CrmBase();
		
			$res = $CrmBase->set('crm_ads_lock',['cal_check'=>$cal_check,'cal_check_time'=>time()],sprintf(" AND cal_id=%d",$cal_id));
			return LibFc::ReturnJson(true,$res['data']);
		}
	}

	/**
	 * 变更收款状态
	 */
	public function changeReceivedStatus()
	{
		if($_SERVER['REQUEST_METHOD']=='POST'&&$_POST['cal_id'])
		{	
			$cal_id = $_POST['cal_id'];
			$cal_received = $_POST['cal_received'];
			$CrmBase = new CrmBase();
			
			$data = [
				'cal_received'=>$cal_received,
				'cal_received_time'=>$cal_received==1?time():0
			];
			$res = $CrmBase->set('crm_ads_lock',$data,sprintf(" AND cal_id=%d",$cal_id));
			return LibFc::ReturnJson(true,$res['data']);
		}
	}

	/**
	 * @method 锁定管理
	 * @author zhengweihua 
	 * @copyright 2025-04-09
	 */
	public function lockList()
	{	
		$Params = mvc::$URL_PARAMS;
		$page = empty($Params['page']) || $Params['page'] < 1? 1: (int) $Params['page'];
		$perPage = isset($_COOKIE['perPage'])? $_COOKIE['perPage'] : 20;
		$where = '';
		$hasRule = LibFc::checkDlRule('DL17', false);
		LibTpl::Set('hasRule',$hasRule);
		if(!$hasRule){
			$where .= sprintf(' AND cal_au_uid = %d',$_SESSION['_userid']);
		}
		foreach($Params as $k=>$v)
		{	
			if($k!='cal_check' && !$v) continue;
			switch($k)
			{
				case 'cal_check':
					if(is_numeric($v)){
						$where .= sprintf(' AND cal_check = %d',$v);
					}
					break;
				case 'cal_atime':
					$arr = explode('~',$v);
					if($arr){
						$where .= sprintf(' AND cal_atime >= %d and cal_atime<= %d ',strtotime($arr[0]),strtotime($arr[1])+24*3600-1);
					}
					break;
			
				case 'cal_au_uid':
					if(!is_array($v)){
						$where .=sprintf(' AND cal_au_uid in (%s)',$v);	
					}else{
						$where .=sprintf(' AND cal_au_uid in (%s)',implode(',',$v));	
					}
					break;
				case 'keyword':
					$where .=sprintf(' AND cal_ads_name like \'%%%s%%\'',$v);	
					break;
			}
		}
		$CrmBase = new CrmBase();
		$res = $CrmBase->get('crm_ads_lock',['count(*) as counts'],$where,true);

		$count = $res['data']['counts'];
		$orderArr = [
			1=>'cal_etime DESC',
			2=>'cal_etime ASC',
			3=>' CASE 
				WHEN cal_locked_etime < UNIX_TIMESTAMP(NOW()) THEN 1 
				ELSE 0 
			END,
			cal_locked_etime DESC',
			4=>' CASE 
				WHEN cal_locked_etime < UNIX_TIMESTAMP(NOW()) THEN 1 
				ELSE 0 
			END,
			cal_locked_etime ASC',
		];
		if($count > 0)
		{	
		
			$orderStr = $orderArr[$Params['order_by']]??'cal_etime DESC';	
			
			$res = $CrmBase->get('crm_ads_lock',['*'],$where . sprintf(' ORDER BY %s limit %d,%d',$orderStr,($page-1)*$perPage,$perPage));
			$list = $res['data'];
			$auUid = array_column($list,'cal_au_uid');
			if($auUid){
				$B2cBase = new B2cBase();
				$ures = $B2cBase->get('an_user',['au_uid','au_name'],sprintf(" AND au_uid in (%s)",implode(',',$auUid)));
				$userArr = array_column($ures['data'],'au_name','au_uid');
			}
			$ads = new AdsBase();
			$groupColors = []; // 用于存储组的颜色
			$groupCounts = []; // 用于统计每个组的数量

			// 动态生成颜色函数（基于 HSL）
			function generateColor($index) {
				$hue = ($index * 137) % 360; // 使用黄金角度（137.5°）生成均匀分布的颜色
				$saturation = 70; // 饱和度固定为 70%
				$lightness = 85; // 亮度固定为 85%（浅色系）
				return "hsl($hue, {$saturation}%, {$lightness}%)";
			}

			// 统计每个组的数量
			foreach ($list as $val) {
				$unikey = $val['cal_pla_id'] . '_' . $val['cal_pa_id'] . '_' . $val['cal_type'] . '_' . $val['cal_pc_id'];
				$groupCounts[$unikey] = ($groupCounts[$unikey] ?? 0) + 1;
			}
			//已审核的数组
			$checkGroup = [];
			$curtime = time();
			foreach ($list as $key => &$val) {
			
				// $val['cal_day'] = ceil(($val['cal_locked_etime'] - time())/3600/24)+29;
				$unikey = $val['cal_pla_id'].'_'.$val['cal_pa_id'].'_'.$val['cal_type'].'_'.$val['cal_pc_id'];
				$val['unikey'] = $unikey;
				if($val['cal_check']==1){
					$checkGroup[] =	$unikey;
				}
				// $sameGroup[$unikey] = $val['cal_id'];

				// 如果组内有多个元素，分配颜色
				if ($groupCounts[$unikey] > 1) {
					if (!isset($groupColors[$unikey])) {
						$groupColors[$unikey] = generateColor(count($groupColors)); // 动态生成颜色
					}
					$val['group_color'] = $groupColors[$unikey]; // 分配颜色
				} else {
					$val['group_color'] = ''; // 单独的元素不分配颜色
				}

				if($val['cal_pa_id']){
					$where  = sprintf(" AND pat_pla_id=%d",$val['cal_pla_id']);
				}
				if($val['cal_type']=='pc'){
					$where  .=" AND pat_modpc=1 AND pat_keyword=".$val['cal_pc_id'];
				}elseif ($val['cal_type']=='cv') {
					$where  .=" AND pat_modcv=1 AND pat_keyword=".$val['cal_pc_id'];
				}else{
					$where  .=" AND pat_pc_id=".$val['cal_pc_id'];
				}			

				$res = $ads->get('pj_place_ads_time',['pat_btime','pat_etime'],$where,true);
				$pat_etime = $res['data']['pat_etime'];
				$val['cal_day'] = ceil(($pat_etime - time())/3600/24);
				$val['can_unlock'] = 0;
				$day37 = strtotime(date('Y-m-d', strtotime('-37 day', $pat_etime)));
				$day60 = strtotime(date('Y-m-d', strtotime('-60 day', $pat_etime)));
				if ($curtime < $day37 && $curtime > $day60) {
					if ($val['cal_unlock_count'] == 0) {
						$val['can_unlock'] = 1;
					}
				}

				$val['ads_name'] = '';
				$val['cal_au_name'] = $userArr[$val['cal_au_uid']]??'';
			}
			unset($val);
			LibTpl::Set('listArr', $list);
		}
		LibTpl::Set('checkGroup', $checkGroup);

		$pageMsg = LibPage::show($count,$perPage,true);
		LibTpl::Set('pageMsg', $pageMsg);

		//所有业务员
		$res = $this->getSalesUser();
		
		LibTpl::Set('salesArr',$res['data']);

		LibTpl::Set('Params', $Params);
		LibTpl::Set('PageTitle', '广告锁定记录');
		LibTpl::Put();
	}

	/**
	 * @method 编辑锁定申请
	 * @author zhengweihua 
	 * @copyright 2025-10-28
	 */
	public function editLockApply()
	{	
		if($_SERVER['REQUEST_METHOD']=='POST'&&$_POST['cal_txt'])
		{	
			if(!$_POST['cal_id']){
				return LibFc::ReturnJson(false,'参数错误');
			}
			$CrmBase = new CrmBase();
			$res = $CrmBase->set('crm_ads_lock',['cal_txt'=>$_POST['cal_txt']],sprintf(" AND cal_id=%d",$_POST['cal_id']));
			return LibFc::ReturnJson(true,$res['data']);
		}

		$Params = mvc::$URL_PARAMS;
		if(!$Params['cal_id']){
			LibFc::ReturnJson(false,'参数错误');
		}
		
		$CrmBase = new CrmBase();
		$res = $CrmBase->get('crm_ads_lock',['*'],sprintf(" AND cal_id=%d",$Params['cal_id']),true);
		if(!$res['data']){
			LibFc::ReturnJson(false,'参数错误');
		}
		LibTpl::Set('dataArr',$res['data']);
		$this->HEAD_CSSJS['plugin'][] = 'ueditor';
		LibTpl::Set('HEAD_CSSJS', $this->HEAD_CSSJS);
		LibTpl::Put();
	}

	/**
	 * @method 解锁锁定申请
	 * @author zhengweihua 
	 * @copyright 2025-10-28
	 */
	public function unlockApplyLock()
	{
		if($_SERVER['REQUEST_METHOD']=='POST'&&$_POST['cal_id'])
		{	

			//锁定后在60-37天之间允许解锁一次，37-30天之间不再允许解锁；
			$CrmBase = new CrmBase();
			$res = $CrmBase->get('crm_ads_lock',['*'],sprintf(" AND cal_id=%d AND cal_au_uid = %d",$_POST['cal_id'],$_SESSION['_userid']),true);
			if ($res['data']) {
				$lockinfo = $res['data'];
				$AdsBase = new AdsBase();
				$table = 'pj_place_ads join pj_place_ads_time on pla_id = pat_pla_id';
				$where = '';
				if ($lockinfo['cal_pla_id']) {
					$where = sprintf(" AND pla_id=%d", $lockinfo['cal_pla_id']);
				}
				if (in_array($lockinfo['cal_type'], ['pc', 'cv'])) {
					$where .= sprintf(" AND pat_keyword=%d %s", $lockinfo['cal_pc_id'], $lockinfo['cal_type'] == 'pc' ? ' AND pat_modpc=1' : ' AND pat_modcv=1');
				} else {
					$where .= sprintf(" AND pat_pc_id=%d", $lockinfo['cal_pc_id']);
				}
				$adsinfo = $AdsBase->get($table, ['*'], $where, true);
				if ($adsinfo['data']) {
					$pat_etime = $adsinfo['data']['pat_etime'];
					$curtime = time();
					$day37 = strtotime(date('Y-m-d', strtotime('-37 day', $pat_etime)));
					$day60 = strtotime(date('Y-m-d', strtotime('-60 day', $pat_etime)));
					if ($curtime < $day37 && $curtime > $day60) {
						if ($lockinfo['cal_unlock_count'] > 0) {
							return LibFc::ReturnJson(false, '您已解锁过一次了，不允许再次解锁');
						}
						$where = sprintf(" AND cal_id=%d", $lockinfo['cal_id']);
						$sres = $CrmBase->set('crm_ads_lock', ['cal_unlock_count' => '#@cal_unlock_count+1', 'cal_check' => 2], $where);
						return LibFc::ReturnJson(true,'操作成功');
					} else {
						return LibFc::ReturnJson(false, '不允许解锁');
					}
				}
			}
		}	
	}

	public function updateLockedTime()
	{
		$CrmBase = new CrmBase();
		$CrmBase->set('crm_ads_lock',['cal_locked_etime'=>'#@cal_locked_etime-86400'],sprintf(" AND cal_locked_etime>%d",time()));	

	}
}