laravel - Laravel 用户有目标，用户必须针对目标进行销售，所以我想根据目标日期获取用户的销售数据

Question

Laravel 用户有目标，用户必须针对目标进行销售，所以我想根据目标日期获取销售的用户数据

我正在获取销售数据，但不是根据目标，而且我每周每月每年对用户应用过滤器，并在位置明智以及用户明智的位置上应用过滤器

    $relations=['salescommon','leadgenerations','leadGenerationDoorKnock','Appraisals','ListingPresentation','ListingAgencyAgreementSigned','OfferReceived','Auctions','exchanges'];

    $userData=[];
    foreach($dates as $period=>$date){
    $user = User::select('id');
    $user->whereIn('id',$id);
        foreach($relations as $realtion)
        {
            $user->withCount($realtion .' as '.$realtion);
        }
        $user->whereBetween('created_at',[$date['start'],$date['end']]);

       $user->with(['targets']);

       $users=$user->get();

       foreach($relations as $realtion){
        $userData[$period][$realtion]=$users->sum($realtion);
       }
$dataVariable=[];

        foreach($dates as $index1=>$date){
            foreach($userData as $index2=>$data){
                if($index1 == $index2){
                    if($data){
                        foreach($relations as $relation){
                            $dataVariable[$relation][0]['name']='ACTUAL';
                            $dataVariable[$relation][0]['data'][]=$data[$relation];
                            $dataVariable[$relation][1]['name']='KPI';
                            $dataVariable[$relation][1]['data'][]=$data[$relation]+2;
                        }
                    }
                    else
                    {
                        foreach($relations as $relation){
                            $dataVariable[$relation][0]['name']='ACTUAL';
                            $dataVariable[$relation][0]['data'][]=0;
                            $dataVariable[$relation][1]['name']='KPI';
                            $dataVariable[$relation][1]['data'][]=0;
                        }
                    }
                }
            }
        }

标签： laravelsalesforcekpi