Latheesan

<?php

// Dummy request params
$skus = array('0001/102/0', '0001/102/1');
$showTypes = array('Available', 'Unavailable');

// Raw Data - this is loaded from db
$data = array(
    array('SKU' => '0001/102/0', 'ReportDate' => '01/09/2013', 'Available' => 10, 'Unavailable' => 11),
    array('SKU' => '0001/102/1', 'ReportDate' => '01/09/2013', 'Available' => 20, 'Unavailable' => 21),
    array('SKU' => '0001/102/0', 'ReportDate' => '02/09/2013', 'Available' => 15, 'Unavailable' => 16),
    array('SKU' => '0001/102/1', 'ReportDate' => '02/09/2013', 'Available' => 6,  'Unavailable' => 7),
);

// Init
$profile_data = array();

// Build Profile Header
$profile_header = array();
$profile_header[0] = 'Date Range';
foreach ($skus as $sku) {
    foreach ($showTypes as $showType) {
        $profile_header[] = $sku .' '. $showType;
    }
}
$profile_data[] = $profile_header;

// Sort Profile Data
$data_sorted = array();
foreach ($data as $skuData) {
    foreach ($skuData as $key => $val) {
        if (in_array($key, $showTypes)) {
            $data_sorted[$skuData['ReportDate']][$skuData['SKU']][$key] = $skuData[$key];
        }
    }
}

// Build Profile Data
foreach ($data_sorted as $reportDate => $skuList) {
    $skuLine = array($reportDate);
    foreach ($skuList as $sku => $skuData) {
        foreach ($skuData as $k => $v) {
            $skuLine[] = $v;
        }
    }
    $profile_data[] = $skuLine;
}

// Finished
echo json_encode($profile_data);

?>