$product_keywords = $spinfo['keywords'];
$product_ean = $product['p']['products_ean'];
$product_price = $spinfo['price'];
$product_price_old = $spinfo['price_old'] > 0 ? $spinfo['price_old'] : '';
$product_price_new = $spinfo['price_new'] > 0 ? $spinfo['price_new'] : '';
$product_price_new_start = $spinfo['price_new_start'] != '0000-00-00' ? date('d.m.Y', strtotime($spinfo['price_new_start'])) : '';
$product_navigation = $spinfo['navigation'];
$product_nav_secondary = explode(',', $spinfo['navigation2']);
$product_navigation3 = $spinfo['navigation3'];
$product_length = $spinfo['length'];
$product_color = $spinfo['color'];
$product_material = $spinfo['material'];
$comment = stripslashes($spinfo['comment']);
$last_active_status = $spinfo['last_active_status'];
$min_image = NECKERMANN_MIN_IMAGE;
$total_image = countTotalImage($spinfo['products_id']);
$need_more = $min_image - $total_image;
if ($need_more > 0) {
if ($total_image == 0) {
$image_status = "X - no image uploaded (min {$min_image} needed)";
} else {
$image_status = "X - {$need_more} more image needed";
}
$image_checked = '';
} else {
$image_status = "OK - {$total_image} image is uploaded for this product";
$image_checked = 'checked="checked"';
}
$content .= '<div style="float:left;margin-bottom:20px;">';
$content .= ' <div style="margin-bottom:10px;">';
//$content .= ' <input type="button" value="Finalized Overview" onclick="location.href=\'?open=sp-products-finalize\';" /> ';
$status['name'] = $row['status_name'] == '1';
$status['desc'] = $row['status_desc'] == '1';
$status['keywords'] = $row['status_keywords'] == '1';
//$status['price'] = ($row['status_price']=='1');
$status['length'] = $row['status_length'] == '1';
$status['color'] = $row['status_color'] == '1';
$status['material'] = $row['status_material'] == '1';
$status_data = true;
foreach ($status as $s) {
if ($s === false) {
$status_data = false;
break;
}
}
//$status_image = ($row['status_image']=='1');
$status_image = countTotalImage($row['products_id']) >= NECKERMANN_MIN_IMAGE;
}
$status_total = $status_data && $status_image;
if ($status_total) {
$have_activable = true;
$all_activable_cids[] = $row['jng_sp_catalog_id'];
}
$active_checked = $status_total && $row['active_status'] == '1' ? 'checked="checked"' : '';
$active_disabled = $status_total === false ? 'disabled="disabled"' : '';
$active = '<input type="checkbox" name="cb_product[]" value="' . $row['jng_sp_catalog_id'] . '" ' . $active_checked . ' ' . $active_disabled . ' />';
$detail_link = "?open=sp-product&id={$row['products_id']}";
$status_ok = '<strong class="green">OK</strong>';
$c = array();
$c['img'] = '<div id="cid' . $row['jng_sp_catalog_id'] . '"><a href="' . $detail_link . '" title="View and Manage Product Detail for Neckermann Catalog">' . webImage($row['products_image'], '80', '80') . '</a></div>';
$c['name'] = '<strong>' . $row['products_id'] . ' / ' . $row['article_number'] . '</strong>' . '<br />' . $row['name'];
$c['info'] = $status_data ? $status_ok : '<a href="' . $detail_link . '">Need Follow Up</a>';
