<?php
namespace app\lib;
class GA{
    const SUPERNOVA_KEY_PATH= BASE_DIR . 'config/supernova.json';
    const ALIPEARL_KEY_PATH= BASE_DIR . 'config/alipearl.json';
    const WIGGINS_KEY_PATH= BASE_DIR . 'config/wiggins.json';
    const YOLISSA_KEY_PATH= BASE_DIR . 'config/yolissa.json';
    const ASTERIA_KEY_PATH= BASE_DIR . 'config/asteria.json';
    private static $insances=[];
    private static function initializeAnalytics($dp){

        $KEY_FILE_LOCATION = self::getPath($dp);
        if(!$KEY_FILE_LOCATION){
            throw new  \Exception("store 配置不存在");
        }
        $client = new \Google_Client();
        $client->setApplicationName("Hello Analytics Reporting");
        $client->setAuthConfig($KEY_FILE_LOCATION);
        $client->setScopes(['https://www.googleapis.com/auth/analytics.readonly']);
        $analytics = new \Google_Service_AnalyticsReporting($client);

        return $analytics;
    }
    public static function getInstance($dp){
        if(isset(self::$insances[$dp])){
            return self::$insances[$dp];
        }else{
            self::$insances[$dp]=self::initializeAnalytics($dp);
            return self::$insances[$dp];
        }
    }
    private function getViewId($dp){
        $VIEW_ID="";
        switch($dp){
            case "1"://supernovahair
                $VIEW_ID="155703065";
            break;
            case "2"://asteriahair
                $VIEW_ID="162723112";
            break;
            case "3"://alipearlhair
                $VIEW_ID="148377136";
            break;
            case "5"://yolissahair
                $VIEW_ID="157127813";
            break;
            case "6"://wiggins
                $VIEW_ID="154631720";
            break;
        }
        return $VIEW_ID;
    }
    public static function getPath($dp){
        $path="";
        switch($dp){
            case "1"://supernovahair
                $path=self::SUPERNOVA_KEY_PATH;
            break;
            case "2"://asteriahair
                $path=self::ASTERIA_KEY_PATH;
            break;
            case "3"://alipearlhair
                $path=self::ALIPEARL_KEY_PATH;
            break;
            case "5"://yolissahair
                $path=self::YOLISSA_KEY_PATH;
            break;
            case "6"://alipearlhair
                $path=self::WIGGINS_KEY_PATH;
            break;
        }
        return $path;
        
        
    }
    public function contentpages($dp,$start_at,$end_at){
        $analytics=self::getInstance($dp);
        $metricArr=[
            'pageviews'=>"ga:pageviews",
            'uniquePageviews'=>"ga:uniquePageviews",
            'avgTimeOnPage'=>"ga:avgTimeOnPage",
            'entrances'=>"ga:entrances",
            'bounceRate'=>"ga:bounceRate",
            'exitRate'=>"ga:exitRate",
            'pageValue'=>"ga:pageValue",
        ];
        $dimensionArr=[
            'pagePath'=>'ga:pagePath',
            'date'=>"ga:date",
        ];
        $VIEW_ID = $this->getViewId($dp);//
        $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
        $dateRange->setStartDate($start_at);
        $dateRange->setEndDate($end_at);
        $metrics=[];
        $dimensions=[];
        foreach($metricArr as $k=>$v){
            $Metric = new \Google_Service_AnalyticsReporting_Metric();
            $Metric->setExpression($v);
            $Metric->setAlias($k);
            array_push($metrics,$Metric);
        }
        foreach($dimensionArr as $k=>$v){
            $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
            $Dimension->setName($v);
            array_push($dimensions,$Dimension);
            
        }

        $pageviewsFilter = new \Google_Service_AnalyticsReporting_MetricFilter();
        $pageviewsFilter->setMetricName("ga:pageviews");
        $pageviewsFilter->setOperator("GREATER_THAN");
        $pageviewsFilter->setComparisonValue("1");

        $MetricFilterClause=new \Google_Service_AnalyticsReporting_MetricFilterClause();
        $MetricFilterClause->setFilters(array($pageviewsFilter));


        $segmentDimensions = new \Google_Service_AnalyticsReporting_Dimension();
        $segmentDimensions->setName("ga:segment");
        array_push($dimensions,$segmentDimensions);


                // Create Dimension Filter.
        $dimensionFilter = new \Google_Service_AnalyticsReporting_SegmentDimensionFilter();
        $dimensionFilter->setDimensionName("ga:pagePath");
        $dimensionFilter->setOperator("REGEXP");
        $dimensionFilter->setExpressions(array("(fbclid|catalogsearch)"));


          // Create Segment Filter Clause.
        $segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause();
        $segmentFilterClause->setDimensionFilter($dimensionFilter);


        // Create the Or Filters for Segment.
        $orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment();
        $orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause));

          // Create the Simple Segment.
        $simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment();
        $simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment));

         // Create the Segment Filters.
        $segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter();
        $segmentFilter->setSimpleSegment($simpleSegment);
        $segmentFilter->setNot(True);

        // Create the Segment Definition.
        $segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition();
        $segmentDefinition->setSegmentFilters(array($segmentFilter));

        $dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment();
        $dynamicSegment->setSessionSegment($segmentDefinition);
        $dynamicSegment->setName('pagePath');

        $segment = new \Google_Service_AnalyticsReporting_Segment();
        $segment->setDynamicSegment($dynamicSegment);

        $orderBy=new \Google_Service_AnalyticsReporting_OrderBy();
        $orderBy->setFieldName('ga:pageviews');
        $orderBy->setSortOrder("DESCENDING");


        $request = new \Google_Service_AnalyticsReporting_ReportRequest();
        $request->setViewId($VIEW_ID);
        $request->setDateRanges($dateRange);
        $request->setMetrics($metrics);
        $request->setDimensions($dimensions);
        $request->setSegments(array($segment));
        $request->setOrderBys($orderBy);
        $request->setPageSize(5000);
        $request->setMetricFilterClauses($MetricFilterClause);

    
        $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
        $body->setReportRequests( array( $request) );
        $reports= $analytics->reports->batchGet( $body );

        $result=$this->getResults($reports);
         return $result;
       
    }
    public function trafficsource($dp,$start_at,$end_at){
        $analytics=self::getInstance($dp);
        $metricArr=[
            'users'=>"ga:users",
            'newUsers'=>"ga:newUsers",
            'sessions'=>"ga:sessions",
            'bounceRate'=>"ga:bounceRate",
            'pageviewsPerSession'=>"ga:pageviewsPerSession",
            'avgSessionDuration'=>"ga:avgSessionDuration",
            'transactionsPerVisit'=>"ga:transactionsPerVisit",
            'transactions'=>"ga:transactions",
            'transactionRevenue'=>"ga:transactionRevenue",
        ];
        $dimensionArr=[
            'pagePath'=>'ga:source',
            'date'=>"ga:date",
            'channelGrouping'=>"ga:channelGrouping",
            'landingPagePath'=>"ga:landingPagePath",
            'keyword'=>"ga:keyword",
            'socialNetwork'=>"ga:socialNetwork",
        ];
        $VIEW_ID = $this->getViewId($dp);//
        $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
        $dateRange->setStartDate($start_at);
        $dateRange->setEndDate($end_at);
        $metrics=[];
        $dimensions=[];
        foreach($metricArr as $k=>$v){
            $Metric = new \Google_Service_AnalyticsReporting_Metric();
            $Metric->setExpression($v);
            $Metric->setAlias($k);
            array_push($metrics,$Metric);
        }
        foreach($dimensionArr as $k=>$v){
            $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
            $Dimension->setName($v);
            array_push($dimensions,$Dimension);
        }

        $segmentDimensions = new \Google_Service_AnalyticsReporting_Dimension();
        $segmentDimensions->setName("ga:segment");
        array_push($dimensions,$segmentDimensions);


                // Create Dimension Filter.
        $dimensionFilter = new \Google_Service_AnalyticsReporting_SegmentDimensionFilter();
        $dimensionFilter->setDimensionName("ga:source");
        $dimensionFilter->setOperator("REGEXP");
        $dimensionFilter->setExpressions(array("(fbclid|catalogsearch)"));


          // Create Segment Filter Clause.
        $segmentFilterClause = new \Google_Service_AnalyticsReporting_SegmentFilterClause();
        $segmentFilterClause->setDimensionFilter($dimensionFilter);


        // Create the Or Filters for Segment.
        $orFiltersForSegment = new \Google_Service_AnalyticsReporting_OrFiltersForSegment();
        $orFiltersForSegment->setSegmentFilterClauses(array($segmentFilterClause));

          // Create the Simple Segment.
        $simpleSegment = new \Google_Service_AnalyticsReporting_SimpleSegment();
        $simpleSegment->setOrFiltersForSegment(array($orFiltersForSegment));

         // Create the Segment Filters.
        $segmentFilter = new \Google_Service_AnalyticsReporting_SegmentFilter();
        $segmentFilter->setSimpleSegment($simpleSegment);
        $segmentFilter->setNot(True);

        // Create the Segment Definition.
        $segmentDefinition = new \Google_Service_AnalyticsReporting_SegmentDefinition();
        $segmentDefinition->setSegmentFilters(array($segmentFilter));

        $dynamicSegment = new \Google_Service_AnalyticsReporting_DynamicSegment();
        $dynamicSegment->setSessionSegment($segmentDefinition);
        $dynamicSegment->setName('trafficsources filter');

        $segment = new \Google_Service_AnalyticsReporting_Segment();
        $segment->setDynamicSegment($dynamicSegment);


        $request = new \Google_Service_AnalyticsReporting_ReportRequest();
        $request->setViewId($VIEW_ID);
        $request->setDateRanges($dateRange);
        $request->setMetrics($metrics);
        $request->setDimensions($dimensions);
        $request->setSegments(array($segment));
        $request->setPageSize(5000);
        // $request->setOrderBys($orderBy);
        // $request->setMetricFilterClauses($MetricFilterClause);

    
        $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
        $body->setReportRequests( array( $request) );
        $reports= $analytics->reports->batchGet( $body );

        $result=$this->getResults($reports);
         return $result;

    }
    public function visitors_geo($dp,$start_at,$end_at){
        $analytics=self::getInstance($dp);
        $dimensionArr=[
            'country'=>'ga:country',
            'region'=>"ga:region",
        ];
        $metricArr=[
            'transactions'=>"ga:transactions",
            'transactionRevenue'=>"ga:transactionRevenue",
        ];
       
        $VIEW_ID = $this->getViewId($dp);//
        $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
        $dateRange->setStartDate($start_at);
        $dateRange->setEndDate($end_at);
        $metrics=[];
        $dimensions=[];
        foreach($metricArr as $k=>$v){
            $Metric = new \Google_Service_AnalyticsReporting_Metric();
            $Metric->setExpression($v);
            $Metric->setAlias($k);
            array_push($metrics,$Metric);
        }
        foreach($dimensionArr as $k=>$v){
            $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
            $Dimension->setName($v);
            array_push($dimensions,$Dimension);
        }

        $orderBy=new \Google_Service_AnalyticsReporting_OrderBy();
        $orderBy->setFieldName('ga:transactions');
        $orderBy->setSortOrder("DESCENDING");

        $request = new \Google_Service_AnalyticsReporting_ReportRequest();
        $request->setViewId($VIEW_ID);
        $request->setDateRanges($dateRange);
        $request->setMetrics($metrics);
        $request->setDimensions($dimensions);
        $request->setOrderBys($orderBy);

        $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
        $body->setReportRequests( array( $request) );
        $reports= $analytics->reports->batchGet( $body );

        $result=$this->getResults($reports);
         return $result;

    }
    public function product($dp,$start_at,$end_at){
        $analytics=self::getInstance($dp);
        $dimensionArr=[
            'productName'=>'ga:productName',
        ];
        $metricArr=[
            'itemRevenue'=>"ga:itemRevenue",
            'uniquePurchases'=>"ga:uniquePurchases",
            'itemQuantity'=>"ga:itemQuantity",
        ];
       
        $VIEW_ID = $this->getViewId($dp);//
        $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
        $dateRange->setStartDate($start_at);
        $dateRange->setEndDate($end_at);
        $metrics=[];
        $dimensions=[];
        foreach($metricArr as $k=>$v){
            $Metric = new \Google_Service_AnalyticsReporting_Metric();
            $Metric->setExpression($v);
            $Metric->setAlias($k);
            array_push($metrics,$Metric);
        }
        foreach($dimensionArr as $k=>$v){
            $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
            $Dimension->setName($v);
            array_push($dimensions,$Dimension);
        }

        $orderBy=new \Google_Service_AnalyticsReporting_OrderBy();
        $orderBy->setFieldName('ga:itemQuantity');
        $orderBy->setSortOrder("DESCENDING");

        $request = new \Google_Service_AnalyticsReporting_ReportRequest();
        $request->setViewId($VIEW_ID);
        $request->setDateRanges($dateRange);
        $request->setMetrics($metrics);
        $request->setDimensions($dimensions);
        $request->setOrderBys($orderBy);

        $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
        $body->setReportRequests( array( $request) );
        $reports= $analytics->reports->batchGet( $body );

        $result=$this->getResults($reports);
         return $result;
    }
    public function visitors_type($dp,$start_at,$end_at){
        $analytics=self::getInstance($dp);
        $dimensionArr=[
            'userType'=>'ga:userType',
            'date'=>'ga:date',
        ];
        $metricArr=[
            'users'=>"ga:users",
            'newUsers'=>"ga:newUsers",
        ];
       
        $VIEW_ID = $this->getViewId($dp);//
        $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
        $dateRange->setStartDate($start_at);
        $dateRange->setEndDate($end_at);
        $metrics=[];
        $dimensions=[];
        foreach($metricArr as $k=>$v){
            $Metric = new \Google_Service_AnalyticsReporting_Metric();
            $Metric->setExpression($v);
            $Metric->setAlias($k);
            array_push($metrics,$Metric);
        }
        foreach($dimensionArr as $k=>$v){
            $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
            $Dimension->setName($v);
            array_push($dimensions,$Dimension);
        }

        // $orderBy=new \Google_Service_AnalyticsReporting_OrderBy();
        // $orderBy->setFieldName('ga:itemQuantity');
        // $orderBy->setSortOrder("DESCENDING");

        $request = new \Google_Service_AnalyticsReporting_ReportRequest();
        $request->setViewId($VIEW_ID);
        $request->setDateRanges($dateRange);
        $request->setMetrics($metrics);
        $request->setDimensions($dimensions);
        // $request->setOrderBys($orderBy);

        $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
        $body->setReportRequests( array( $request) );
        $reports= $analytics->reports->batchGet( $body );

        $result=$this->getResults($reports);
         return $result;
    }
    public function productInfo($productName,$dp,$start_at,$end_at){
        $analytics=self::getInstance($dp);
        $dimensionArr=[
            'productName'=>'ga:productName',
        ];
        $metricArr=[
            'itemRevenue'=>"ga:itemRevenue",
            'revenuePerItem'=>"ga:revenuePerItem",
            'productRefundAmount'=>"ga:productRefundAmount",
            'quantityAddedToCart'=>"ga:quantityAddedToCart",
            // 'quantityRemovedFromCart'=>"ga:quantityRemovedFromCart",
            'itemQuantity'=>"ga:itemQuantity",
            'productListViews'=>"ga:productListViews",
            'productDetailViews'=>"ga:productDetailViews",
            'productAddsToCart'=>"ga:productAddsToCart",
            // 'productRemovesFromCart'=>"ga:productRemovesFromCart",
            'productCheckouts'=>"ga:productCheckouts",
            'uniquePurchases'=>"ga:uniquePurchases",
        ];
       
        $VIEW_ID = $this->getViewId($dp);//
        $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
        $dateRange->setStartDate($start_at);
        $dateRange->setEndDate($end_at);
        $metrics=[];
        $dimensions=[];
        foreach($metricArr as $k=>$v){
            $Metric = new \Google_Service_AnalyticsReporting_Metric();
            $Metric->setExpression($v);
            $Metric->setAlias($k);
            array_push($metrics,$Metric);
        }
        foreach($dimensionArr as $k=>$v){
            $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
            $Dimension->setName($v);
            array_push($dimensions,$Dimension);
        }
        $skuFilter = new \Google_Service_AnalyticsReporting_DimensionFilter();
        $skuFilter->setDimensionName("ga:productName");
        $skuFilter->setOperator("EXACT");
        $skuFilter->setExpressions([$productName]);

        $MetricFilterClause=new \Google_Service_AnalyticsReporting_MetricFilterClause();
        $MetricFilterClause->setFilters(array($skuFilter));


        $request = new \Google_Service_AnalyticsReporting_ReportRequest();
        $request->setViewId($VIEW_ID);
        $request->setDateRanges($dateRange);
        $request->setMetrics($metrics);
        $request->setDimensions($dimensions);
        $request->setDimensionFilterClauses($MetricFilterClause);
        // $request->setOrderBys($orderBy);

        $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
        $body->setReportRequests( array( $request) );
        $reports= $analytics->reports->batchGet( $body );

        $result=$this->getResults($reports);
         return $result;

    }
    public function goals($dp,$metricArr,$start_at,$end_at){
        $analytics=self::getInstance($dp);
        $dimensionArr=[
            // 'date'=>'ga:date',
            // 'sessionCount'=>'ga:sessionCount',
        ];
       
        $VIEW_ID = $this->getViewId($dp);//
        $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
        $dateRange->setStartDate($start_at);
        $dateRange->setEndDate($end_at);
        $metrics=[];
        $dimensions=[];
        foreach($metricArr as $k=>$v){
            $Metric = new \Google_Service_AnalyticsReporting_Metric();
            $Metric->setExpression($v);
            $Metric->setAlias($k);
            array_push($metrics,$Metric);
        }
        foreach($dimensionArr as $k=>$v){
            $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
            $Dimension->setName($v);
            array_push($dimensions,$Dimension);
        }
        $request = new \Google_Service_AnalyticsReporting_ReportRequest();
        $request->setViewId($VIEW_ID);
        $request->setDateRanges($dateRange);
        $request->setMetrics($metrics);
        $request->setDimensions($dimensions);
        // $request->setOrderBys($orderBy);

        $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
        $body->setReportRequests( array( $request) );
        $reports= $analytics->reports->batchGet( $body );

        $result=$this->getResults($reports);
        echo "<pre>";
        print_r($reports);exit;
         return $result;

    }
    public function regionProduct($region,$dp,$start_at,$end_at){
        $analytics=self::getInstance($dp);
        $dimensionArr=[
            'region'=>'ga:region',
        ];
        $metricArr=[
            'itemRevenue'=>"ga:itemRevenue",
            'revenuePerItem'=>"ga:revenuePerItem",
            'productRefundAmount'=>"ga:productRefundAmount",
            'quantityAddedToCart'=>"ga:quantityAddedToCart",
            // 'quantityRemovedFromCart'=>"ga:quantityRemovedFromCart",
            'itemQuantity'=>"ga:itemQuantity",
            'productListViews'=>"ga:productListViews",
            'productDetailViews'=>"ga:productDetailViews",
            'productAddsToCart'=>"ga:productAddsToCart",
            // 'productRemovesFromCart'=>"ga:productRemovesFromCart",
            'productCheckouts'=>"ga:productCheckouts",
            // 'uniquePurchases'=>"ga:uniquePurchases",
            'transactions'=>"ga:transactions",

        ];
       
        $VIEW_ID = $this->getViewId($dp);//
        $dateRange = new \Google_Service_AnalyticsReporting_DateRange();
        $dateRange->setStartDate($start_at);
        $dateRange->setEndDate($end_at);
        $metrics=[];
        $dimensions=[];
        foreach($metricArr as $k=>$v){
            $Metric = new \Google_Service_AnalyticsReporting_Metric();
            $Metric->setExpression($v);
            $Metric->setAlias($k);
            array_push($metrics,$Metric);
        }
        foreach($dimensionArr as $k=>$v){
            $Dimension = new \Google_Service_AnalyticsReporting_Dimension();
            $Dimension->setName($v);
            array_push($dimensions,$Dimension);
        }
        $regionFilter = new \Google_Service_AnalyticsReporting_DimensionFilter();
        $regionFilter->setDimensionName("ga:region");
        $regionFilter->setOperator("EXACT");
        $regionFilter->setExpressions([$region]);

        $MetricFilterClause=new \Google_Service_AnalyticsReporting_MetricFilterClause();
        $MetricFilterClause->setFilters(array($regionFilter));


        $request = new \Google_Service_AnalyticsReporting_ReportRequest();
        $request->setViewId($VIEW_ID);
        $request->setDateRanges($dateRange);
        $request->setMetrics($metrics);
        $request->setDimensions($dimensions);
        $request->setDimensionFilterClauses($MetricFilterClause);
        // $request->setOrderBys($orderBy);

        $body = new \Google_Service_AnalyticsReporting_GetReportsRequest();
        $body->setReportRequests( array( $request) );
        $reports= $analytics->reports->batchGet( $body );
        
        $result=$this->getResults($reports);
         return $result;
    }


    /**
     * Queries the Analytics Reporting API V4.
     *
     * @param service An authorized Analytics Reporting API V4 service object.
     * @return The Analytics Reporting API V4 response.
     */
    function getContentReport($VIEW_ID,$analytics,$metricArr,$dimensionArr) {
        
       
    }
    function getResults($reports) {
        $data=[];
        for ( $reportIndex = 0; $reportIndex < count( $reports ); $reportIndex++ ) {
            $item=[];
            $report = $reports[ $reportIndex ];
      
            $header = $report->getColumnHeader();
            $dimensionHeaders = $header->getDimensions();
            $metricHeaders = $header->getMetricHeader()->getMetricHeaderEntries();
            $rows = $report->getData()->getRows();
      
            for ( $rowIndex = 0; $rowIndex < count($rows); $rowIndex++) {
                $row = $rows[ $rowIndex ];
                $dimensions = $row->getDimensions();
        
                $metrics = $row->getMetrics();
                if($dimensionHeaders&&$dimensions){
                    for ($i = 0; $i < count($dimensionHeaders) && $i < count($dimensions); $i++) {
                        $header =   $dimensionHeaders[$i];
                        $header=str_replace('ga:','',$header);
                        $item[$header]=$dimensions[$i];

                            // print($dimensionHeaders[$i] . ": " . $dimensions[$i] . "\n\r");
                            // echo"<br/>";
                    }
                    // $date=$dimensions[0];
                    // $date=date('Y-m-d',strtotime($date));
        
                }else{
                    continue;
                }
            
                if($metricHeaders&&$metrics){
                    for ($j = 0; $j < count($metrics); $j++) {
                        $values = $metrics[$j]->getValues();
                        for ($k = 0; $k < count($values); $k++) {
                            $entry = $metricHeaders[$k];
                            $item[$entry->getName()]=$values[$k];
                            // print($entry->getName() . ": " . $values[$k] . "\n\r");
                            // echo"<br/>";
                        }
                    } 
                }
            $data[]=$item;
            }
        }
        return $data;
      }
    
}