$headers['c w150 tac'] = 'Pieces Sold (1)';
$headers['d w150 tac'] = 'Pieces Sold (2)';
$headers['e w100 tac'] = 'Stock Available';
$headers['f w100 tac'] = 'Action';
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'LOADPRODUCT') {
$pid = tep_db_prepare_input($_POST['pid']);
$rowclass = tep_db_prepare_input($_POST['rowclass']);
$product = new product($pid);
$row = '<tr id="row-' . $pid . '" class="' . $rowclass . '">';
foreach ($headers as $hk => $hv) {
$value = '';
$hk_classes = explode(' ', $hk);
switch ($hk_classes[0]) {
case 'a':
$value = $product->displayImage(IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1);
break;
case 'b':
$value .= '<strong>' . $product->brand_name . '</strong>';
$value .= '<br /><a href="?open=product-detail&products_id=' . $product->id . '" target="_blank">' . $product->id . ' / ' . $product->code . '</a>';
if (!is_null($product->last_keep_timestamp)) {
$value .= '<br /><br />';
$value .= '<span class="red">« Last kept on ' . date('d.m.Y', $product->last_keep_timestamp) . ' by ' . $product->last_keep_by . ' »</span>';
}
break;
case 'c':
$value = $product->displayYearlySoldTable();
break;
case 'd':
$value = $product->displayRecentSoldTable();
break;
use_class('element');
$prid = $pid;
$family_id = $p_data['p']['family_id'];
$stars = $p_data['p']['stars'];
$obj_family = new products_family(null, $pid);
$family_name = $obj_family->name;
$prinfo = constructProductDetailInfo($pid, $p_data, true, true);
if ($family_id != '') {
$fm = $obj_family->retrieveMembers();
foreach ($fm as $fpid) {
$family_is_locked = (int) $obj_family->productIsFamilyLocked($fpid);
$family_members[] = "#box-pids-family|{$fpid}||{$family_is_locked}";
}
}
//$primage = webImageWithDetailLinkStars($p_data['p']['products_image'], $image_size_w, $image_size_h, 'Product '.$pid, 'img-border', "Product $pid (Reference product)", '500', '500', $stars);
$primage = $obj_product->displayImage($image_size_w, $image_size_h, '(Reference Product)');
/* Moved this as function to object class products_family
$family_searchkey = $p_data['p']['family_searchkey'];
$q = "SELECT products_id, family_id FROM products";
$q .= " WHERE products_id != $pid AND family_searchkey = '$family_searchkey'";
if ($family_id != '') {
$q .= " AND (family_id != '$family_id' OR IFNULL(family_id,'') = '')";
}
$q .= " UNION";
$q .= " SELECT p.products_id, p.family_id FROM products_articles pa";
$q .= " INNER JOIN products p ON p.products_id = pa.products_id";
$q .= " WHERE pa.products_id != $pid AND pa.family_searchkey = '$family_searchkey'";
if ($family_id != '') {
$q .= " AND (p.family_id != '$family_id' OR IFNULL(p.family_id,'') = '')";
}
