"; print_r($hierids); exit;
        // month
        $month = $request->input('month', date('F Y', strtotime('now')));

        // if(in_array('all_data_access', $permissions)){
        //     $monthlyResponse = LambdaRequest::signedrequest('get', 'reports', 'gennovadc_reports/monthly_summary', ['month' => $month, 'hierarchy_ids' => json_encode('1655447961-8182461d-8ae6-49f3-9317-0475db5d4da3')]);
        // }else{
            $monthlyResponse = LambdaRequest::signedrequest('get', 'reports', 'gennovadc_reports/monthly_summary', ['month' => $month, 'hierarchy_ids' => json_encode($hierids)]);
        // }
        
        
        $monthSummary = [];
        $numericKeys = [];

        if (!empty($monthlyResponse->data->item)) {
            $firstItem = (array) $monthlyResponse->data->item[0];
            foreach ($firstItem as $key => $val) {
                $monthSummary[] = ['name' => ucwords(str_replace('_', ' ', $key)), 'key' => $key];
                if ($key !== 'product_name' && is_numeric($val)) {
                    $numericKeys[] = $key;
                }
            }
        }

        $totals = [];
        foreach ($numericKeys as $key) {
            $totals[$key] = 0;
        }

        foreach ($monthlyResponse->data->item as $item) {
            foreach ($numericKeys as $key) {
                $totals[$key] += $item->{$key} ?? 0;
            }
        }

        // week
        $weeklyResponse = LambdaRequest::signedrequest('get', 'reports', 'gennovadc_reports/weekly_summary', ['month' => $month, 'hierarchy_ids' => json_encode($hierids)]);
        $weeklyData = $weeklyResponse->data->item ?? [];
        $weeklySummary = [];
        $weeklyTotals = [];
        if (!empty($weeklyData)) {
            $firstItem = (array) $weeklyData[0];

            foreach ($firstItem as $key => $value) {
                $label = ucwords(str_replace(['_', '-'], ' ', $key));

                $weeklySummary[] = [
                    'label' => $label,
                    'key' => $key,
                ];

                if (is_numeric($value)) {
                    $weeklyTotals[$key] = 0;
                }
            }

            foreach ($weeklyData as $item) {
                foreach ($weeklyTotals as $key => $_) {
                    $weeklyTotals[$key] += $item->$key ?? 0;
                }
            }
        }

        // center
        $centerResponse = LambdaRequest::signedrequest('get', 'reports', 'gennovadc_reports/center_summary', ['month' => $month, 'hierarchy_ids' => json_encode($hierids)]);
        $centerSummarySubmission = $centerResponse->data->item ?? [];
        $centerTotals = $centerResponse->data->total ?? null;

        $centerSummary = [];

        if (!empty($centerSummarySubmission)) {
            $firstItem = (array) $centerSummarySubmission[0];
            foreach ($firstItem as $key => $val) {
                $label = ucwords(str_replace(['_', '-'], ' ', $key));
                $centerSummary[] = ['name' => $label, 'key' => $key];
            }
        }

        // centertrend
        $centerTrendResponse = LambdaRequest::signedrequest('get', 'reports', 'gennovadc_reports/center_trend_summary', ['hierarchy_ids' => json_encode($hierids)]);
        $centerTrendData = $this->trendReportDataArray($centerTrendResponse);
        $centerTrendSummarySubmission = $centerTrendData['item'] ?? [];
        $centerTrendTotals = (array) ($centerTrendData['total'] ?? []);
        $centerTrendSummary = $this->buildTrendSummaryColumns($centerTrendData);

        $unitTrendResponse = LambdaRequest::signedrequest('get', 'reports', 'gennovadc_reports/unit_trend_summary', ['hierarchy_ids' => json_encode($hierids)]);
        $unitTrendData = $this->trendReportDataArray($unitTrendResponse);
        $unitTrendSummarySubmission = $unitTrendData['item'] ?? [];
        $unitTrendSummary = $this->buildTrendSummaryColumns($unitTrendData);
        $unitTrendTotals = $this->trendReportTotals($unitTrendData, $unitTrendSummarySubmission, $unitTrendSummary);

        // transplant penetration
        $transplantPenetrationResponse = LambdaRequest::signedrequest(
            'get',
            'reports',
            'gennovadc_reports/transplant_penetration',
            ['month' => $month, 'hierarchy_ids' => json_encode($hierids)]
        );
        $transplantPenetrationSubmission = $transplantPenetrationResponse->data->transplant_penetration ?? [];

        // transplant summary
        $transplantSummaryResponse = LambdaRequest::signedrequest(
            'get',
            'reports',
            'gennovadc_reports/transplant_summary',
            ['month' => $month, 'hierarchy_ids' => json_encode($hierids)]
        );
        $transplantSummarySubmission = $transplantSummaryResponse->data->transplant_summary
            ?? ($transplantSummaryResponse->data->item ?? []);

        $transplantSummaryLayout = $this->transplantSummaryTableLayout();
        $transplantSummaryFlat = $transplantSummaryLayout['flat'];
        $transplantSummaryGroups = $transplantSummaryLayout['groups'];

        // activity summary
        $activitySummaryResponse = LambdaRequest::signedrequest(
            'get',
            'reports',
            'gennovadc_reports/activity_summary',
            ['month' => $month, 'hierarchy_ids' => json_encode($hierids)]
        );
        $activitySummarySubmission = $activitySummaryResponse->data->activity_summary
            ?? ($activitySummaryResponse->data->item ?? []);

        $activitySummaryColumns = $this->buildActivitySummaryColumns($activitySummarySubmission);

        $permissions = json_decode(auth()->user()->permissions);
        
        if(in_array('all_data_access', $permissions)){
            
             $response = LambdaRequest::signedrequest(
            'get',
            'ums',
            'hierarchy/hierarchy_below_me',
            [
                'partition' => 'rapport-gennovadc',
                'hierarchy_id' => 'root'
            ]
            );

        }else{
           
           $response = LambdaRequest::signedrequest(
            'get',
            'ums',
            'hierarchy/hierarchy_below_me',
            [
                'partition' => 'rapport-gennovadc',
                'hierarchy_id' => []
            ]
        );
        }
        

        $hierarchies = $response->data->hierarchies ?? [];

        // $hierarchies = array_filter($hierarchies, function ($h) {
        //     return (int)$h->level !== 1;
        // });

        usort($hierarchies, function ($a, $b) {
            return $b->level <=> $a->level;
        });

        //echo '
'; print_r(['month' => $month, 'hierarchy_ids' => json_encode($hierids)]); print_r($transplantPenetrationSubmission); exit;
        // dd($hierarchies);
        return view($this->_viewname . '.dashboard', [
            'title' => 'My Dc Dashboard',
            'month' => $month,
            'filter_hier' => $hierarchies,

            'monthsummary' => $monthSummary,
            'monthsummarysubmission' => $monthlyResponse->data->item ?? [],
            'monthTotals' => $totals,

            'weeklysummarysubmission' => $weeklyResponse->data->item ?? [],
            'weeklysummary' => $weeklySummary,
            'weeklyTotals' => $weeklyTotals,

            'centersummarysubmission' => $centerSummarySubmission,
            'centersummary' => $centerSummary,
            'centerTotals' => $centerTotals,

            'centertrendsummarysubmission' => $centerTrendSummarySubmission,
            'centertrendsummary' => $centerTrendSummary,
            'centerTrendTotals' => $centerTrendTotals,

            'unittrendsummarysubmission' => $unitTrendSummarySubmission,
            'unittrendsummary' => $unitTrendSummary,
            'unitTrendTotals' => $unitTrendTotals,

            'transplantPenetrationSubmission' => $transplantPenetrationSubmission,

            'transplantSummarySubmission' => $transplantSummarySubmission,
            'transplantSummaryFlat' => $transplantSummaryFlat,
            'transplantSummaryGroups' => $transplantSummaryGroups,

            'activitySummarySubmission' => $activitySummarySubmission,
            'activitySummaryColumns' => $activitySummaryColumns,
        ]);
    }

    /** Normalize Lambda/API response to data array (handles nested body). */
    private function trendReportDataArray($response): array
    {
        if (!$response) {
            return [];
        }
        if (isset($response->body)) {
            $body = $response->body;
            if (is_string($body)) {
                $body = json_decode($body, true);
            } else {
                $body = json_decode(json_encode($body), true);
            }
            return is_array($body) ? ($body['data'] ?? []) : [];
        }
        if (isset($response->data)) {
            return json_decode(json_encode($response->data), true) ?: [];
        }
        return [];
    }

    /** Current month first, previous 11 (matches reports API rolling window). */
    private function rolling12MonthColumns(): array
    {
        $months = [];
        $cursor = now()->startOfMonth();
        for ($i = 0; $i < 12; $i++) {
            $d = $cursor->copy()->subMonths($i);
            $months[] = [
                'key' => strtoupper($d->format('M')) . '_' . $d->format('Y'),
                'label' => $d->format('M Y'),
            ];
        }
        return $months;
    }

    private function isLegacyFiscalMonthKey(string $key): bool
    {
        return (bool) preg_match('/^[A-Z]{3}$/', $key);
    }

    /** Use API months when present and year-aware; otherwise rolling 12 from today. */
    private function resolveTrendMonthColumns(array $data): array
    {
        $months = $data['months'] ?? [];
        if (is_array($months) && count($months) > 0) {
            $first = (array) ($months[0] ?? []);
            $firstKey = $first['key'] ?? '';
            if ($firstKey !== '' && !$this->isLegacyFiscalMonthKey($firstKey)) {
                return $months;
            }
        }
        return $this->rolling12MonthColumns();
    }

    /** Table columns for center / unit trend summary. */
    private function buildTrendSummaryColumns(array $data): array
    {
        $columns = [['name' => 'Product Name', 'key' => 'product_name']];
        foreach ($this->resolveTrendMonthColumns($data) as $month) {
            $month = (array) $month;
            if (empty($month['key'])) {
                continue;
            }
            $columns[] = [
                'name' => $month['label'] ?? $this->trendMonthKeyLabel($month['key']),
                'key' => $month['key'],
            ];
        }
        return $columns;
    }

    /** Totals row: use API total when present, else sum submission rows. */
    private function trendReportTotals(array $data, array $submission, array $columns): array
    {
        $apiTotal = $data['total'] ?? null;
        if (is_array($apiTotal) && !empty($apiTotal)) {
            return $apiTotal;
        }
        $totals = [];
        foreach (array_slice($columns, 1) as $col) {
            $totals[$col['key']] = 0;
        }
        foreach ($submission as $item) {
            $itemArr = (array) json_decode(json_encode($item), true);
            foreach (array_slice($columns, 1) as $col) {
                $totals[$col['key']] += $itemArr[$col['key']] ?? 0;
            }
        }
        return $totals;
    }

    private function trendMonthKeyLabel(string $key): string
    {
        if (preg_match('/^([A-Z]{3})_(\d{4})$/', $key, $m)) {
            $ts = strtotime($m[1] . ' 1 ' . $m[2]);
            if ($ts) {
                return date('M Y', $ts);
            }
        }
        return $key;
    }

    private function reportCellValue($row, string $key, ?string $nestedKey = null)
    {
        if ($nestedKey === null) {
            if (is_object($row) && isset($row->{$key})) {
                return $row->{$key};
            }
            if (is_array($row) && array_key_exists($key, $row)) {
                return $row[$key];
            }
            return '';
        }

        $parent = $this->reportCellValue($row, $key);
        if (is_object($parent) && isset($parent->{$nestedKey})) {
            return $parent->{$nestedKey};
        }
        if (is_array($parent) && array_key_exists($nestedKey, $parent)) {
            return $parent[$nestedKey];
        }

        return '';
    }

    private function transplantSummaryTableLayout(): array
    {
        return [
            'flat' => [
                ['key' => 'Position Codes', 'label' => 'Position Co'],
                ['key' => 'Total Transplants Plan', 'label' => 'Total Transplants Expected'],
                ['key' => 'Total Transplants Actual', 'label' => 'Total Transplants Actual'],
                ['key' => 'Gennova Share Denovo Plan', 'label' => 'Gennova Share Denovo plan'],
                ['key' => 'Gennova Share Denovo Actual', 'label' => 'Gennova Share Denovo Actual'],
                ['key' => 'Gennova Share Switch Plan', 'label' => 'Gennova Share Switch plan'],
                ['key' => 'Gennova Share Switch Actual', 'label' => 'Gennova Share Switch Actual'],
                ['key' => 'Gennova Share Graftsol Tx Plan', 'label' => 'Gennova Share Graftsol Tx plan'],
                ['key' => 'Gennova Share Graftsol Tx Actual', 'label' => 'Gennova Share Graftsol Tx Actual'],
            ],
            'groups' => [
                [
                    'name' => 'Kidney Transplant',
                    'columns' => [
                        ['key' => 'Kidney Tx Actual', 'label' => 'Kidney Tx Actual'],
                        ['key' => 'Kidney Gennova Share Denovo Actual', 'label' => 'Gennova Share Denovo Actual'],
                        ['key' => 'Kidney Gennova Share Switch Actual', 'label' => 'Gennova Share Switch Actual'],
                        ['key' => 'Kidney Gennova Share Graftsol Tx Actual', 'label' => 'Gennova Share Graftsol Tx Actual'],
                    ],
                ],
                [
                    'name' => 'Liver Transplant',
                    'columns' => [
                        ['key' => 'Liver Tx Actual', 'label' => 'Liver Tx Actual'],
                        ['key' => 'Liver Gennova Share Denovo Actual', 'label' => 'Gennova Share Denovo Actual'],
                        ['key' => 'Liver Gennova Share Switch Actual', 'label' => 'Gennova Share Switch Actual'],
                        ['key' => 'Liver Gennova Share Graftsol Tx Actual', 'label' => 'Gennova Share Graftsol Tx Actual'],
                    ],
                ],
                [
                    'name' => 'Cardioplegia',
                    'columns' => [
                        ['key' => 'Cardioplegia Plan', 'label' => 'Cardioplegia Expected'],
                        ['key' => 'Cardioplegia Actual', 'label' => 'Cardioplegia Actual'],
                        ['key' => 'Gennova Share Graftsol Cardioplegia', 'label' => 'Gennova Share Graftsol Cardioplegia'],
                    ],
                ],
            ],
        ];
    }

    private function buildActivitySummaryColumns($submission): array
    {
        if (empty($submission)) {
            return [];
        }

        $hiddenCols = ['Position_id', 'Position_owner'];
        $first = (array) ($submission[0] ?? []);
        $flatCols = [];
        $nestedCols = [];

        $fmtLabel = function (string $s): string {
            $s = str_replace('_', ' ', $s);
            $s = preg_replace('/\s+/', ' ', trim($s)) ?: '';

            return ucwords(strtolower($s));
        };

        foreach ($first as $key => $val) {
            if (in_array($key, $hiddenCols, true)) {
                continue;
            }
            if (is_object($val) || is_array($val)) {
                foreach ((array) $val as $subKey => $_) {
                    $nestedCols[] = [
                        'label' => $fmtLabel($key) . ' - ' . $fmtLabel((string) $subKey),
                        'parent' => $key,
                        'child' => $subKey,
                    ];
                }
            } else {
                $flatCols[] = [
                    'label' => $fmtLabel($key),
                    'parent' => $key,
                    'child' => null,
                ];
            }
        }

        $preferred = ['Product Name', '8. Activity', 'Activity', 'Month Plan', 'Month Actl', 'Month Actual', 'Month Plan '];
        $ordered = [];

        foreach ($preferred as $p) {
            foreach ($flatCols as $i => $c) {
                if (($c['label'] ?? '') === $p) {
                    $ordered[] = $c;
                    unset($flatCols[$i]);
                    break;
                }
            }
        }

        $months = [];
        $rest = [];
        foreach ($flatCols as $c) {
            $label = (string) ($c['label'] ?? '');
            if (preg_match('/^[A-Za-z]{3}-\d{2}$/', $label)) {
                $months[] = $c;
            } else {
                $rest[] = $c;
            }
        }

        usort($months, function ($a, $b) {
            $al = (string) ($a['label'] ?? '');
            $bl = (string) ($b['label'] ?? '');
            $ad = \DateTime::createFromFormat('M-y', $al);
            $bd = \DateTime::createFromFormat('M-y', $bl);
            $at = $ad ? $ad->getTimestamp() : 0;
            $bt = $bd ? $bd->getTimestamp() : 0;

            return $bt <=> $at;
        });

        return array_values(array_merge($ordered, $rest, $months, $nestedCols));
    }

}