$nonrefill_orders_today[$a_counter] = '<b>-</b>';
$order_qty[$a_counter] = '<b>-</b>';
}
foreach ($p['articles'] as $aid => $a) {
$a_counter++;
$count_nonrefill_orders = $class_do->countOrdersNonRefillByArticle($pid, $aid);
$count_nonrefill_orders_today = $class_do->countOrdersNonRefillByArticle($pid, $aid);
$size[$a_counter] = $a['article_length'] > 0 ? textLength($a['article_length']) : '<span class="notice">None</span>';
$sold_last_month_nopromo[$a_counter] = intval($a['article_fc_base_monthly']);
$sold_last_month[$a_counter] = intval($a['article_sold_monthly_1']);
$stock[$a_counter] = intval($a['article_stock']);
$stock_target[$a_counter] = $obj_product->getDIOHstockTarget($aid);
$qty_ordered[$a_counter] = intval($a['article_orders_qty']);
$nonrefill_orders[$a_counter] = $count_nonrefill_orders;
$nonrefill_orders_today[$a_counter] = $count_nonrefill_orders_today;
if ($obj_product->isArticleKilled($aid)) {
//Set text of killed article to gray
$size[$a_counter] = '<span class="notice">' . $size[$a_counter] . '</span>';
$sold_last_month_nopromo[$a_counter] = '<span class="notice">' . $sold_last_month_nopromo[$a_counter] . '</span>';
$sold_last_month[$a_counter] = '<span class="notice">' . $sold_last_month[$a_counter] . '</span>';
$stock[$a_counter] = '<span class="notice">' . $stock[$a_counter] . '</span>';
$stock_target[$a_counter] = '<span class="notice">' . $stock_target[$a_counter] . '</span>';
$qty_ordered[$a_counter] = '<span class="notice">' . $qty_ordered[$a_counter] . '</span>';
$nonrefill_orders[$a_counter] = '<span class="notice">' . $nonrefill_orders[$a_counter] . '</span>';
$nonrefill_orders_today[$a_counter] = '<span class="notice">' . $nonrefill_orders_today[$a_counter] . '</span>';
$button_disabled = ' disabled="disabled"';
} else {
if ($nonrefill_orders_today[$a_counter] > 0) {
$nonrefill_orders_today[$a_counter] = '<span class="green">' . $nonrefill_orders_today[$a_counter] . '</span>';
}
$button_disabled = '';
for ($ai = 0; $ai < $total_additional_image; $ai++) {
$p_image = DIR_WS_IMAGES . $p->getAdditionalImage($ai);
if (is_file($p_image)) {
$img_path = thumbimage($p_image, $pi2_width, $pi2_height, 1, 1, DIR_WS_IMAGES . 'imagecache');
$obj_excel_draw = new PHPExcel_Worksheet_Drawing();
$obj_excel_draw->setWorksheet($obj_ws);
$obj_excel_draw->setPath($img_path);
$obj_excel_draw->setCoordinates(chr($column_ai[$ai]) . $row_products_images);
$obj_excel_draw->setOffsetX($offset_ai[$ai]);
$obj_excel_draw->setOffsetY($img_offset);
}
}
}
$row_total = $row_products_images;
foreach ($p->articles as $aid => $a) {
if ($p->isArticleKilled($aid)) {
continue;
}
$article_counter++;
//ELEMENTS!
$ean = $p->getEAN($aid);
$size = $p->getLengthOrSizeAsText($aid);
$cell_ean = 'A' . ($row_total + 2);
$element_rowstart = $row_total + 3;
$obj_ws->getStyle($cell_ean)->getFont()->setBold(true);
$obj_ws->setCellValue($cell_ean, "EAN Code: {$ean} ({$size})");
$range_elements_header = $obj_ws->getStyle('A' . $element_rowstart . ':I' . $element_rowstart);
$range_elements_header->getFont()->setBold(true);
$range_elements_header->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setRGB($table_header_bgcolor);
$obj_ws->setCellValue('A' . $element_rowstart, 'Element');
$obj_ws->setCellValue('B' . $element_rowstart, 'ID');
