function getDisplay($pid, $spid, $amvd_provision_rate, $row_class = 'o')
{
global $class_jc;
$result = '';
$obj_product = new Product($pid);
$have_amvd_catalog = $obj_product->isAddedToSalesPartner($spid);
$is_active = $obj_product->isActiveInSalesPartner($spid);
$products_image = $obj_product->displayImage(IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1);
$info = '<div style="margin-bottom:20px;">' . $obj_product->displayIDAndCode() . '</div>';
$info .= '<div class="w150" style="margin:0 auto;">' . $obj_product->displayRecentSoldTable() . '</div>';
$navids = array('0' => 'Please select a navigation...');
$navids_opts = retrieveNavIDs($spid, 'bn');
foreach ($navids_opts as $n_id => $n_name) {
//if doesn't work in dev environment, it could be caused by umlauts
//in the navigation name. Can be fixed by adding htmlspecialchars or
//but we don't need it for live (sahat- 16.09.2014)
$navids[$n_id] = $n_name;
}
$navid = $have_amvd_catalog ? $obj_product->getSalesPartnerMainNavigationID($spid) : null;
$navigation = '<select class="navigation input">' . loadComboListFromArray($navids, null, $navid, false) . '</select>';
$result .= '<tr id="' . $pid . '" class="' . $row_class . '">';
$result .= '<td class="img">' . $products_image . '</td>';
$result .= '<td class="name">' . $info . '</td>';
$result .= '<td class="pb">' . $navigation . '</td>';
$btn_update_text = $is_active ? 'Update' : 'Activate';
$btn_add = '<input type="button" style="width:90px;" class="add button blue" value="Add" title="Add this product to AM.VD Catalogue"/>';
$btn_update = '<input type="button" style="width:90px;" class="update button blue" value="' . $btn_update_text . '" title="Update and activate this product on AM.VD Catalogue"/>';
$btn_ignore = '<input type="button" style="width:90px;" class="ignore button" value="Ignore" title="Ignore from list"/>';
$btn_deactivate = '<input type="button" style="width:90px;" class="deactivate button blue" value="Deactivate" title="Deactivate or remove from AM.VD catalog"/>';
$i_hidden = '<input type="hidden" name="jcid" value="' . $obj_product->getSalesPartnerCatalogID($spid) . '"/>';
if ($have_amvd_catalog) {
$btn = $i_hidden . $btn_update . '<br/>' . $btn_deactivate;
} else {
$btn = $btn_add . '<br/>' . $btn_ignore;
}
$result .= '<td class="act">' . $btn;
$result .= '<input type="hidden" class="pid" value="' . $pid . '"/>';
$result .= '</td>';
$result .= '</tr>';
return $result;
}
if ($products['products_status'] == '1') {
$content .= '<a href="' . JNGWEBADDRESS . 'product_info.php?products_id=' . $products_id . '" target="_blank">View in J&G Website</a>';
} else {
$content .= '<span class="notice">Inactive in J&G Website</span>';
}
$content .= ' «';
foreach ($products_sp_link as $jng_sp_id => $spl) {
$link_text = 'Search in ' . $products_sp[$jng_sp_id]['package_prefix'] . ' Website';
$content .= '<br />» ';
$content .= $spl == '' ? '<span class="notice pointer" title="Required data for search is missing" onclick="alert($(this).attr(\'title\'));">' . $link_text . '</span>' : '<a href="' . $spl . '" target="_blank">' . $link_text . '</a>';
$content .= ' « ';
}
$content .= '</div>';
$content .= '<div class="tac" style="margin-top:20px;">';
$content .= '<h3>Sales</h3>';
$content .= $obj_product->displayRecentSoldTable();
$content .= '</div>';
$content .= '<div class="tac smallText notice">Inclucing J&G and all SP<br />Excluding Cancels</div>';
$content .= '<div class="tac" style="margin-top:20px;">';
$content .= '<h3>Availability</h3>';
$content .= '<table align="center" border="0" cellpadding="0" cellspacing="0">';
$content .= '<tr><td class="tal">Depot Stock</td><td>=</td><td class="tar">' . $depot_stock . '</td></tr>';
$content .= '<tr><td class="tal">Refill Orders</td><td>=</td><td class="tar">' . $depot_refill . '</td></tr>';
$content .= '<tr><td class="tal">Elements</td><td>=</td><td class="tar">' . $elements_status . '</td></tr>';
$content .= '</table>';
$content .= '</div>';
$content .= '<div class="tac smallText notice">Depot and Refill for all Lengths<br />Elements based on default length only</div>';
$content .= '<div class="tac" style="margin-top:20px;">';
$content .= '<div id="cogs-table">' . $obj_product->getProductCOGSObject()->drawDetailTable() . '</div>';
$cogs = $obj_product->getProductCOGSValue();
$content .= '<div>' . '<span id="cogs-manual-form" style="display:none;">' . '<input type="text" id="cogs-manual-input" value="' . $cogs . '" class="w100 tac" />' . '<br /><span class="notice">Set to 0 to use auto calculation</span>' . '</span>' . '<input type="button" id="cogs-manual-set" value="Set COGS Manually" />' . '</div>';
/**
* For handling submitted POST
* @global array $session_userinfo
* @param array $post_vars
*/
public function postProcess($post_vars)
{
global $session_userinfo;
$result = array();
if ($post_vars['me_action'] == 'SEARCH') {
$type = $post_vars['type'];
$jng_sp_id = $post_vars['jng_sp_id'];
//another strange case, in live datepicker filter is always given as \'datevalue\' instead of 'datevalue'
//still cant find the root cause (and it's ok in local dev), so for quickwin workaround we simple replace
//the \' value into ' with below update (sahat 11.02.2014)
//$post_filters = explode("|", $post_vars['post_filters']);
$post_filters = explode("|", str_replace('\\\'', "'", $post_vars['post_filters']));
$post_sorts = explode("|", $post_vars['post_sorts']);
$filters = array();
foreach ($post_filters as $f) {
$f_temp = explode('-', $f);
$field = $f_temp[0];
unset($f_temp[0]);
$value = implode('-', $f_temp);
//explode to array for input on field $multivalue_fields which allowed multivalue separated by $multivalue_separator
if (in_array($field, $this->multivalue_fields)) {
$mv_temp = explode(current($this->multivalue_separator), $value);
if (is_array($mv_temp) && $mv_temp > 0) {
foreach ($mv_temp as $mv) {
$mv = trim($mv);
if (!isset($filters[$field]) || !in_array($mv, $filters[$field])) {
$filters[$field][] = $mv;
}
}
} else {
$filters[$field][] = $value;
}
} else {
$filters[$field][] = $value;
}
}
$sorts = array();
foreach ($post_sorts as $s) {
list($field, $value) = explode("-", $s);
$sorts[$field][] = $value;
}
$query = $this->constructQuery($jng_sp_id, $filters, $sorts);
//die($query);
$dbq = tep_db_query($query);
$result = '';
$products_ids = array();
$total_stock = 0;
$total_stock_value = 0;
$total_margin = 0;
$total_sold = 0;
$total_rets = 0;
$total_sales = 0;
$total_vc = 0;
$total_sold_l30d = 0;
$total_sold_l60d = 0;
$total_sold_l90d = 0;
$total_sales_l30d = 0;
$total_sales_l60d = 0;
$total_sales_l90d = 0;
$display_spot = '';
while ($r = tep_db_fetch_array($dbq)) {
$products_ids[] = $r['products_id'];
$total_stock += $r['hh_stock'];
$total_stock_value += $r['hh_stock_value'];
$total_margin += $r['margin'];
$total_sold += $r['total_sold'];
$total_rets += $r['total_returned'];
$total_sales += $r['total_sales'];
$vc += $r['vc_now'];
//$total_vc += $r['total_vc'];
$total_vc += $r['vc_total'];
$total_sold_l30d += $r['sold_monthly_1'];
$total_sold_l60d += $r['sold_monthly_2'];
$total_sold_l90d += $r['sold_monthly_3'];
$total_sales_l30d += $r['sales_monthly_1'];
$total_sales_l60d += $r['sales_monthly_2'];
$total_sales_l90d += $r['sales_monthly_3'];
}
$jng_nodata = '<span class="notice">N/A for J&G</span>';
$returned_rate = number_format($total_sold > 0 ? $total_rets / $total_sold * 100 : 0, 1);
$n_products_ids = count($products_ids);
$result['type'] = $type;
$result['spid'] = $jng_sp_id;
$result['avg_margin'] = ($n_products_ids > 0 ? number_format($total_margin / $n_products_ids, 1) : 0) . '%';
$result['total'] = $n_products_ids;
$result['total_stock'] = $total_stock;
$result['total_stock_value'] = displayCurrency(CURRENCY_DEFAULT, convertCurrency($total_stock_value, CURRENCY_CODE_EURO, CURRENCY_DEFAULT));
$result['total_sold'] = $jng_sp_id == '0' ? $jng_nodata : $total_sold;
$result['total_rets'] = $jng_sp_id == '0' ? $jng_nodata : $total_rets . " ({$returned_rate}%)";
$result['total_sales'] = $jng_sp_id == '0' ? $jng_nodata : displayCurrency(DEFAULT_CURRENCY, $total_sales);
$result['vc'] = $jng_sp_id == '0' ? $jng_nodata : number_format($vc, 2);
//$result['total_vc'] = number_format($total_vc, 2);
$result['vc_total'] = $jng_sp_id == '0' ? $jng_nodata : number_format($total_vc, 2);
$result['total_sales_l30d'] = displayCurrency(DEFAULT_CURRENCY, $total_sales_l30d);
$result['total_sales_l60d'] = displayCurrency(DEFAULT_CURRENCY, $total_sales_l60d);
$result['total_sales_l90d'] = displayCurrency(DEFAULT_CURRENCY, $total_sales_l90d);
$result['total_sold_l30d'] = $total_sold_l30d;
$result['total_sold_l60d'] = $total_sold_l60d;
$result['total_sold_l90d'] = $total_sold_l90d;
$result['products_ids'] = implode(',', $products_ids);
} elseif ($post_vars['me_action'] == 'DISPLAY') {
use_class('products_minierp');
use_class('minierp_users');
use_class('Product');
$class_pm = new products_minierp();
$class_mu = new minierp_users();
$jng_sp_id = $post_vars['jng_sp_id'];
$type = $post_vars['type'];
$products_id = $post_vars['products_id'];
$is_killed = $post_vars['is_killed'];
$is_sp_not_yet_added = $post_vars['is_sp_not_yet_added'];
$added_post_vars = array('is_killed' => $is_killed, 'is_sp_not_yet_added' => $is_sp_not_yet_added);
$display_type = $post_vars['display_type'];
$row_number = $post_vars['row_number'];
$showing_id = $post_vars['showing_id'];
$obj_product = new Product($products_id);
$display_res = $this->retrieveDataForDisplay($jng_sp_id, $products_id, $added_post_vars, $display_type);
$res = $display_res[0];
$img_size = $display_type == 'thumbnail' ? IMAGE_SIZE_THUMBNAIL_2 : IMAGE_SIZE_THUMBNAIL_1;
//SHOW PURE IMAGE FOR SP THAT USED IT AS MAIN IMAGE
if (in_array($jng_sp_id, $this->sp_use_pure_image)) {
$obj_product->setDisplayImage(Product::IMAGE_TYPE_ZALANDO);
} else {
if (in_array($jng_sp_id, $this->sp_use_clear_image)) {
$obj_product->setDisplayImage(Product::IMAGE_TYPE_AMAZON);
}
}
//$products_image = webImageWithDetailLinkStars($image_used, $img_size, $img_size, 'Product '.$products_id, 'img-border', 'View Larger Image', IMAGE_SIZE_BIG_1, '', $res['stars'], 3, '', '', $res['products_brand_id']);
$products_image = $obj_product->displayImage($img_size, $img_size);
$position_padding = $display_type == 'thumbnail' ? '2px 0 0 15px;' : '';
$products_image = webImageAddPosition($row_number, $products_image, $position_padding);
$products_complexity = productComplexityName($res['complexity']);
$products_stars = drawStars($res['stars']);
$products_is_watched = $class_mu->isOnWatchlist($session_userinfo['id'], $products_id);
$resultsdt = array();
if ($display_type == 'table' || $type == 'displaytooltip') {
if ($type == 'thumbnail_tooltip') {
//HTML Version result
$sales_partner_id = $jng_sp_id == 'allsp' ? '0' : $jng_sp_id;
//TODO: seperate B2C and B2b calculation, or even better is if
// we can calculate it by the object directly
$price = $obj_product->getPriceSelling($sales_partner_id);
$net_price = Product::calculateNetPrice($price, VAT);
$cogs = $obj_product->getProductCOGSValue();
$profit = Product::calculateProfit($net_price, $cogs);
$margin = Product::calculateMargin($profit, $net_price);
$jng_nodata = '<span class="notice">N/A for J&G</span>';
$infos = array();
$infos[] = $obj_product->displayIDAndCode();
$infos[] = $res['products_name'];
if ($res['hh_stock'] > 0) {
$infos[] = '<strong class="green">Depot Stock = ' . $res['hh_stock'] . '</strong>';
} else {
$infos[] = '<strong>Depot Stock = 0</strong>';
}
$infos[] = 'Complexity = ' . $products_complexity;
if ($res['sample_created'] == '1') {
$infos[] = '<span class="green">Sample order created</span>';
} else {
$infos[] = '<span class="notice">No sample order created</span>';
}
if ($jng_sp_id == '0') {
$total_sold = $jng_nodata;
$return_info = $jng_nodata;
$qty_sold = $jng_nodata;
} else {
$returned_rate = number_format($res['returned_rate'], 1);
$sales_monthly = number_format($res['sales_monthly'], 1);
$sales_weekly = number_format($res['sales_weekly'], 1);
$total_sold = $res['total_sold'];
$return_info = $res['total_returned'] . ' (' . $returned_rate . '%)';
$qty_sold = "per Week: {$sales_weekly} ⋅ per Month: {$sales_monthly}";
}
$tooltip = '<div class="draw-table"><table border="0" cellpadding="0" cellspacing="0">';
$tooltip .= '<tr class="o"><td class="w200 bold">Brand</td><td class="w300 bold">' . $res['brand_name'] . '</td></tr>';
$tooltip .= '<tr class="e"><td>Info</td><td>• ' . implode('<br />• ', $infos) . '</td></tr>';
$tooltip .= '<tr class="o"><td>Price Preview</td><td>' . $obj_product->displayPricePreview($sales_partner_id) . '</td></tr>';
$tooltip .= '<tr class="e"><td>Margin in %</td><td>' . $obj_product->displayMargin($price, $margin) . '</td></tr>';
$tooltip .= '<tr class="o"><td>Age JG (finalized)</td><td>' . $res['jng_products_age'] . ' days</td></tr>';
$tooltip .= '<tr class="e"><td>Age (selected SP filter)</td><td>' . $res['products_age'] . ' days</td></tr>';
$tooltip .= '<tr class="o"><td>Total Sold (excl. JG)</td><td>' . $total_sold . '</td></tr>';
$tooltip .= '<tr class="e"><td>Total Returns (excl. JG)</td><td>' . $return_info . '</td></tr>';
$tooltip .= '<tr class="o"><td>Pieces Sold</td><td>' . str_replace('align="center"', 'align="left"', $obj_product->displayRecentSoldTable()) . '</div></td></tr>';
$tooltip .= '<tr class="e"><td>Qty. Sold (excl. JG)</td><td>' . $qty_sold . '</td></tr>';
$tooltip .= '</table></div>';
$ajaxResult = array();
$ajaxResult['type'] = $type;
$ajaxResult['spid'] = $jng_sp_id;
$ajaxResult['products_id'] = $products_id;
$ajaxResult['tooltip'] = $tooltip;
$ajaxResult['rownumber'] = $row_number;
$ajaxResult['showingid'] = $showing_id;
ajaxReturn($ajaxResult);
} else {
$sales_partner_id = $jng_sp_id == 'allsp' ? '0' : $jng_sp_id;
$price = $obj_product->getPriceSelling($sales_partner_id);
$net_price = Product::calculateNetPrice($price, VAT);
$cogs = $obj_product->getProductCOGSValue();
$profit = Product::calculateProfit($net_price, $cogs);
$margin = Product::calculateMargin($profit, $net_price);
$material_expenses = displayCurrency(DEFAULT_CURRENCY, convertCurrency($res['material_expenses'], 'EUR', DEFAULT_CURRENCY), false);
$products_price = displayCurrency(DEFAULT_CURRENCY, $res['products_price'], false);
$products_price_old = displayCurrency(DEFAULT_CURRENCY, $res['products_price_old'], false);
$products_created = date('d-M-Y', strtotime($res['products_date_added']));
$vc_now = number_format($res['vc_now'], 2);
$total_vc = number_format($res['vc_total'], 2);
$vc_percent = number_format($res['vc_percent'], 1);
//$margin = $res['margin'];
//$margin = '<span class="'.(($class_pm->priceMargindIsGood($res['products_price'], $margin)) ? 'green' : 'red') . '">' .
// number_format($margin, 1) . '%</span>';
$margin = $obj_product->displayMargin($price, $margin);
$returned_rate = number_format($res['returned_rate'], 1);
$discount = number_format($res['products_discount'], 2);
$total_sales = number_format($res['total_sales'], 2);
$sales_monthly = number_format($res['sales_monthly'], 1);
$sales_weekly = number_format($res['sales_weekly'], 1);
$jng_nodata = '<span class="notice">N/A' . ($type == 'displaytooltip' ? ' ' : '<br />') . 'for J&G</span>';
//0-4
$resultsdt[] = $products_image;
$resultsdt[] = $products_id;
$resultsdt[] = $res['products_model'];
$resultsdt[] = $res['products_name'];
//$resultsdt[] = $class_pm->displayProductName($products_id);
$resultsdt[] = $products_price_old;
//5-9
$resultsdt[] = $products_price;
$resultsdt[] = $discount;
$resultsdt[] = $jng_sp_id == '0' ? $jng_nodata : $vc_now;
$resultsdt[] = $jng_sp_id == '0' ? $jng_nodata : $vc_percent;
$resultsdt[] = $margin;
//10-14
$resultsdt[] = $res['products_age'];
$resultsdt[] = $jng_sp_id == '0' ? $jng_nodata : $res['total_sold'];
$resultsdt[] = $jng_sp_id == '0' ? $jng_nodata : $total_vc;
$resultsdt[] = $res['total_returned'];
$resultsdt[] = $jng_sp_id == '0' ? $jng_nodata : $returned_rate;
//15-19
$resultsdt[] = $jng_sp_id == '0' ? $jng_nodata : $total_sales;
$resultsdt[] = $res['sold_monthly_1'];
$resultsdt[] = $res['sold_monthly_2'];
$resultsdt[] = $res['sold_monthly_3'];
$resultsdt[] = $jng_sp_id == '0' ? $jng_nodata : $sales_weekly;
//20-24
$resultsdt[] = $jng_sp_id == '0' ? $jng_nodata : $sales_monthly;
$resultsdt[] = $res['brand_name'];
$resultsdt[] = $res['kill_status'];
$resultsdt[] = $products_created;
$resultsdt[] = $res['hh_stock'];
//25-28
$resultsdt[] = $products_complexity;
$resultsdt[] = $products_stars;
$resultsdt[] = $products_is_watched;
$resultsdt[] = $res['sample_created'];
//29
$resultsdt[] = $res['jng_products_age'];
$resultsdt[] = $material_expenses;
$resultsdt[] = $res['products_length'];
}
} elseif ($display_type == 'thumbnail') {
//0-4
$resultsdt[] = $products_image;
$resultsdt[] = $products_id;
$resultsdt[] = $res['products_model'];
$resultsdt[] = $products_stars;
$resultsdt[] = $products_is_watched;
//5
$resultsdt[] = $res['sample_created'];
}
$result['type'] = $type;
$result['spid'] = $jng_sp_id;
$result['result'] = implode($this->result_separator, $resultsdt);
$result['rownumber'] = $row_number;
$result['showingid'] = $showing_id;
}
ajaxReturn($result);
}
$cols = array();
foreach ($header as $hk => $hv) {
$value = '';
switch ($hk) {
case 'img':
$value .= webImageAddPosition($pos, $obj_product->displayImage(IMAGE_SIZE_THUMBNAIL_2, IMAGE_SIZE_THUMBNAIL_2_PORTRAIT));
break;
case 'nm w300':
$value .= $product['p']['products_brand_name'];
$value .= '<br />' . $obj_product->displayIDAndCode();
$value .= '<br />' . $product['pd']['2']['products_name'];
$value .= '<br /><br /><a href="?open=products-price&pids=' . $pid . '&hidemenu=true&hidecopyurl=true"';
$value .= ' class="bold view_webpage">» Click here to manage price details!</a>';
break;
case 'ps w150':
$value .= $obj_product->displayRecentSoldTable();
$value .= '<br /><br />';
$value .= $obj_product->displayYearlySoldTable();
break;
case 'st w100':
$value .= strval($stock);
break;
case 'act w150':
$value .= '<input type="hidden" name="pid" value="' . $pid . '" />';
if (!$added) {
$showadd = '';
$showrem = ' style="display:none;"';
} else {
$showadd = ' style="display:none;"';
$showrem = '';
}
foreach ($product_referer_ids as $product_referer_id) {
$npr++;
$content .= ' <h3>Product ' . $product_referer_id . ' Sales Data "All SP"</h3>';
$content .= ' <table border="0" cellpadding="0" cellspacing="0">';
$content .= ' <tr>';
$product_referer = $class_pm->retrieveDetail($product_referer_id, 'p,pl,sp');
$content .= ' <td align="center" rowspan="8">';
$content .= ' ' . webImageWithDetailLink($product_referer['p']['products_image'], IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1, 'Product ' . $product_referer_id, 'img-border');
$content .= ' <br/>' . drawStars($product_referer['p']['stars']);
$content .= ' </td>';
$content .= ' <td rowspan="8" width="10px;"> </td>';
$content .= ' <td>Age</td><td>= </td><td>' . intval($product_referer['sp']['0']['active_age']) . ' days</td>';
$content .= ' </tr>';
use_class('Product');
$obj_product = new Product($product_referer_id);
$content .= '<tr><td>Products Sold</td><td>= </td><td>' . str_replace('align="center"', 'align="left"', $obj_product->displayRecentSoldTable()) . '</td></tr>';
// $content .= ' <tr><td>Sold Last 30 Days </td><td>= </td><td>'.intval($product_referer['pl']['sold_monthly_1']).'</td></tr>';
// $content .= ' <tr><td>Sold Last 60 Days </td><td>= </td><td>'.intval($product_referer['pl']['sold_monthly_2']).'</td></tr>';
// $content .= ' <tr><td>Sold Last 90 Days</td><td>= </td><td>'.intval($product_referer['pl']['sold_monthly_3']).'</td></tr>';
$content .= ' <tr><td>Total Sold</td><td>= </td><td>' . intval($product_referer['sp']['0']['total_sold']) . '</td></tr>';
$content .= ' <tr><td>Total Return</td><td>= </td><td>' . intval($product_referer['sp']['0']['total_returned']) . '</td></tr>';
$content .= ' <tr><td>Returns Rate</td><td>= </td><td>' . number_format($product_referer['sp']['0']['returned_rate'], 2) . '%</td></tr>';
$content .= ' <tr><td>Total Sales</td><td>= </td><td>' . displayCurrency('EUR', $product_referer['sp']['0']['total_sales']) . '</td></tr>';
$content .= ' <tr><td>Sold per Week</td><td>= </td><td>' . number_format($product_referer['sp']['0']['sales_weekly'], 2) . '</td></tr>';
$content .= ' <tr><td>Sold per Month</td><td>= </td><td>' . number_format($product_referer['sp']['0']['sales_monthly'], 2) . '</td></tr>';
$content .= ' </table>';
if ($npr < count($product_referer_ids)) {
$content .= '<div style="border-bottom:solid 1px #ababab;margin-bottom:10px;"> </div>';
}
}
$content .= ' </div>';
