$content .= '</table></div>'; $content .= '</div>'; $content .= '<div style="clear:both;padding-top:20px;">'; $content .= '<h2 style="margin-bottom:0;">Elements Sourcing using Forecast Simulation</h2>'; $stock_target = $fc->calcForecast($daily_usage, element::$diohStopLevel[$e->stars], true); $stock_available = $e->retrieveStockQuantity(); $refill_ordered = $e->retrieveOrdersQuantity($aid); $needed_in_sourcing = $e->retreiveNeededInSourcingQuantity(); $missing_qty = $stock_target - ($stock_available + $refill_ordered + $needed_in_sourcing); if ($missing_qty < 0) { $missing_qty = 0; } $content .= '<div class="float-box w300 ui-corner-all" style="padding:5px;margin-right:10px;"><table border="0" cellspacing="0" cellpadding="0">'; $content .= '<tr><td>Daily Average</td><td>=</td><td>' . $daily_usage . '</td></tr>'; $content .= '<tr><td title="Stock Target based on DIOH Target Settings">Stock Target (' . element::$diohStopLevel[$e->stars] . ' days)</td><td>=</td><td>' . $stock_target . '</td></tr>'; $content .= '<tr><td>Stock Available</td><td>=</td><td>' . $stock_available . '</td></tr>'; $content .= '<tr><td>Refill Ordered</td><td>=</td><td>' . $refill_ordered . '</td></tr>'; $content .= '<tr><td>Needed in Sourcing Tab</td><td>=</td><td>' . $needed_in_sourcing . '</td></tr>'; $content .= '<tr><td class="bold">Missing Quantity</td><td class="bold">=</td><td class="bold">' . $missing_qty . '</td></tr>'; $content .= '</table></div>'; $content .= '<div style="clear:both;"> </div>'; if ($last_week_usage == 0) { $content .= '<h3 class="red">No recent usage found, forecasting is not possible!</h3>'; } $content .= '<div id="graph-forecasting-element"></div>'; $javascript .= ' var chartDataParams = "' . $year . '|||' . $fc->drawDataForGraph($last_week_usage, true) . '"; chartDataParams += "|||' . implode('|', $weekly_usage) . '"; addChart("graph-forecasting-element", "calendar-week.php?data=" + chartDataParams, 1000, 400); '; $title = 'Element Usage Forecasting';
$missing_qty = 0; } $show_box = $articles_id == '*' || $articles_id == $aid ? '' : 'display:none;'; $content .= '<div class="float-box w300 ui-corner-all" style="padding:5px;margin:0 10px 10px 0;' . $show_box . '"><table border="0" cellspacing="0" cellpadding="0">'; $content .= '<tr><td colspan="3" class="bold">EAN ' . $a['products_ean'] . ' - ' . $a_title . '</td></tr>'; $content .= '<tr><td>Daily Average <span class="red" title="' . $forecasting_conf['promotion-orders-desc'] . '">(!)</span></td><td>=</td><td>' . $daily_sold . '</td></tr>'; $content .= '<tr><td title="Stock Target based on DIOH Target Settings">Stock Target (' . Product::$diohStopLevel[$p->stars] . ' days)</td><td>=</td><td>' . $stock_target . '</td></tr>'; $content .= '<tr><td>Stock Available</td><td>=</td><td>' . $stock_available . ' <span class="notice">(' . $stock_available_dioh . ')</span></td></tr>'; $content .= '<tr><td>Refill Ordered</td><td>=</td><td>' . $refill_ordered . '</td></tr>'; $content .= '<tr><td class="bold">Missing Quantity</td><td class="bold">=</td><td class="bold">' . $missing_qty . '</td></tr>'; $content .= '</table></div>'; } $content .= '<div style="clear:both;"> </div>'; if ($last_week_sold == 0) { $content .= '<h3 class="red">No recent sales found, forecasting is not possible!</h3>'; } $content .= '<div id="graph-forecasting-product"></div>'; $javascript .= ' var chartDataParams = "' . $year . '|||' . $fc->drawDataForGraph($last_week_sold) . '"; chartDataParams += "|||' . implode('|', $weekly_sold_real_nopromo) . '"; addChart("graph-forecasting-product", "calendar-week.php?data=" + chartDataParams, 1000, 400); $("#txt-show-all-articles").click(function() { $(this).fadeOut(fadeSpeed); $(".float-box").fadeIn(fadeSpeed); }); '; if ($hidecopyurl) { $show_page_title = false; } else { $title = 'Product Sold Forecasting'; }