$c['expire'] = date('d-M-Y', strtotime($row['coupon_expire_date']));
$coupons[] = $c;
}
echo tep_draw_table('coupons', $coupons);
}
?>
</div>
<?php //Check if manual production instruction exist
$pnc_query = tep_db_query("SELECT * FROM products_non_configurator WHERE products_id=$product_id");
if(tep_db_num_rows($pnc_query)>0) {
$pnc = tep_db_fetch_array($pnc_query);
if($pnc['products_length']!='' || $pnc['products_instruction']!='') {
echo '<div> </div>';
echo '<div class="table-head" style="padding:10px;border:2px solid #999;">';
echo '<table class="noborder" border="0" cellpadding="0" cellspacing="0"></tr>';
$thumbnail = product_thumbnail($product['products_image']);
if($thumbnail!='') {
echo '<td class="noborder"><div style="border:1px solid #ccc;margin-right:10px;">'.$thumbnail.'</div></td>';
}
echo '<td class="noborder">';
if($pnc['products_length']!='') echo '<h3>Product Length: '.$pnc['products_length'].'</h3>';
if($pnc['products_instruction']!='') {
if($pnc['products_length']!='') echo '<div> </div>';
echo '<h3 style="margin:0;">Production Instruction:</h3>';
echo '<div>'.nl2br($pnc['products_instruction']).'</div>';
}
echo '</td>';
echo '</tr></table>';
echo '</div>';
}
}
$cat_query .= $filter_query;
$cat_query .= " GROUP BY jc.jng_sp_catalog_id";
$cat_query .= " ORDER BY jc.last_modified DESC";
$cat_query .= $page_query;
$cat_result = tep_db_query($cat_query);
$cat = array();
while ($row = tep_db_fetch_array($cat_result)) {
$cat[] = $row;
}
$content = '';
if (count($cat) > 0) {
$content .= '<div style="margin-bottom:20px;">';
$content .= '<input type="button" name="generatexml" value="Generate CAT XML" onclick="location.href=\'?open=sp-catalog-generator\';" />';
$content .= '</div>';
foreach ($cat as $c) {
$title = '';
$stock = $c['stock'];
if ($c['stock'] <= 0) {
$title = 'This product is out of stock';
$stock = '<strong class="red" title="' . $title . '">' . $stock . '</strong>';
}
$content .= '<div style="border:1px solid #ccc;float:left;padding:5px;margin:0px 20px 20px 0px;">';
$content .= '<div title="' . $title . '">' . product_thumbnail($c['products_image']) . '</div>';
$content .= '<div style="text-align:center;">' . $c['article_number'] . ' (' . $stock . ')</div>';
$content .= '</div>';
}
} else {
$content .= '<div>There is no active product in the catalog</div>';
}
$content .= '<div> </div>';
$title = 'Neckermann Active Catalog';