} else {
$sp_detail = $class_sp->retrieveDetail($spid);
}
if (!is_array($products)) {
$products = explode(',', $products);
}
$ajaxResult = array();
$ajaxResult['period'] = 'p-' . $period;
$ajaxResult['period_text'] = $sp_detail['package_prefix'] . '<br />' . substr($period_start_raw, 0, 5) . ' - ' . substr($period_end_raw, 0, 5);
if ($level == 'p') {
$cogs_result = ReportCOGS::retrieveSummaryByProducts($products, $spid, $period_start, $period_end);
foreach ($products as $pid) {
$ajaxResult['row-' . $pid] = intval($cogs_result[$pid]['total_quantity']);
}
} else {
$cogs_result = ReportCOGS::retrieveSummaryByArticles($products, $spid, $period_start, $period_end);
$palist = $class_pa->retrieveAllArticlesByProducts($products);
foreach ($palist as $pid => $pdata) {
$row_content = '<table align="center" border="0"' . ' cellpadding="0" cellspacing="0">';
foreach ($pdata as $aid => $adata) {
if ($level == 'l') {
$left = $adata['length'] == 0 ? '<span class="notice">None</span>' : textLength($adata['length']);
} else {
$left = $adata['ean'];
}
$row_content .= '<tr><td>' . $left . '</td><td>=</td><td>' . intval($cogs_result[$adata['ean']]['total_quantity']) . '</td></tr>';
}
$row_content .= '</table>';
$ajaxResult['row-' . $pid] = $row_content;
}
}
if ($show_minimum_data) {
$price_uvp = 'N/A';
$price_default = 'N/A';
$price_selling_old_amazon = 'N/A';
$price_selling_amazon = 'N/A';
$mat_exp = $p->material_expense;
$cogs = 'N/A';
} else {
$price_uvp = $p->getPriceUVP();
$price_default = $p->getPriceDefault();
$price_selling_old_amazon = $p->getPriceSellingOld($sp_id_amazon);
$price_selling_amazon = $p->getPriceSelling($sp_id_amazon);
$mat_exp = $p->material_expense;
$cogs = $p->getProductCOGSValue();
$report_cogs_lastyear = ReportCOGS::retrieveSummaryByArticles($pids, '*', $last_year_start, $last_year_end);
$report_cogs_thisyear = ReportCOGS::retrieveSummaryByArticles($pids, '*', $this_year_start, $this_year_end);
}
foreach ($p->articles as $aid => $a) {
if ($p->isArticleKilled($aid)) {
continue;
}
$article_counter++;
$ean = $p->getEAN($aid);
$size = $p->getLengthOrSizeAsText($aid);
if ($show_minimum_data) {
$stock_available = 'N/A';
$booked = 'N/A';
$last_year_sold_qty = 'N/A';
$last_year_net_sales = 'N/A';
$last_year_gross_profit = 'N/A';
$this_year_sold_qty = 'N/A';
