PivotTable's and PivotMatrix's Field Order

Adding order number to row and column headers 


PivotTable::create(array(
    ...
    'map' => array(
        'rowHeader' => function($rowHeader, $headerInfo) {
            $v = $rowHeader;
            if (isset($headerInfo['childOrder']))
                $v = $headerInfo['childOrder'] . ". " . $v;
            return $v;
        },
        'columnHeader' => function($colHeader, $headerInfo) {
            $v = $colHeader;
            if (isset($headerInfo['childOrder']))
                $v = $headerInfo['childOrder'] . ". " . $v;

            return $v;
        },
    ),
    ...
));



PivotMatrix::create(array(
    ...
    'map' => array(
        'rowHeader' => function($rowHeader, $headerInfo) {
            $v = $rowHeader;
            if (isset($headerInfo['childOrder']))
                $v = $headerInfo['childOrder'] . ". " . $v;
            return $v;
        },
        'columnHeader' => function($colHeader, $headerInfo) {
            $v = $colHeader;
            if (isset($headerInfo['childOrder']))
                $v = $headerInfo['childOrder'] . ". " . $v;

            return $v;
        },
    ),
    ...
));
 
  dollar_sales - sum   dollar_sales - count   dollar_sales - avg  
  orderYear   orderQuarter  
  customerName   productLine   productName  
1. Year-2004
2. Year-2005
Total
Total
Total
1. AV Stores, Co.
Total
2. Amica Models & Co.
Total
3. Anna's Decorations, Ltd
Total
4. Alpha Cognac
Total
5. Atelier graphique
Total
Total
$99,984
$35
$2,857
-
-
-
$99,984
$35
$2,857
$82,223
$26
$3,162
-
-
-
$82,223
$26
$3,162
-
-
-
$56,932
$19
$2,996
$56,932
$19
$2,996
-
-
-
$12,432
$5
$2,486
$12,432
$5
$2,486
$7,743
$3
$2,581
-
-
-
$7,743
$3
$2,581
$189,951
$64
$2,968
$69,365
$24
$2,890
$259,315
$88
$2,947
Page size:
Description