$content .= '<tr style="background:#efccef;"><td class="w080">Purple Block</td><td>=</td><td>Current Calendar Week</td></tr>';
$content .= '<tr><td class="blue">Blue Line</td><td class="blue">=</td><td class="blue">Forecasting based on weekly average of ' . $log_base_info . '</td></tr>';
$content .= '<tr><td class="red">Red Line</td><td class="red">=</td><td class="red">Real weekly elements usage</td></tr>';
$content .= '</table></div>';
$content .= '</div>';
$content .= '<div class="float-box w400 ui-corner-all" style="' . $box_style . '">';
$content .= '<h3>Forecast Details</h3>';
$content .= '<div><table border="0" cellspacing="0" cellpadding="0">';
$content .= '<tr><td>Today</td><td>=</td><td class="w080">KW ' . $kw_now . '</td></tr>';
$content .= '<tr><td>L30D usage</td><td>=</td><td>' . $monthly_usage . '</td></tr>';
$content .= '<tr><td>Weekly average</td><td>=</td><td>' . $last_week_usage . '</td></tr>';
$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>';
function getDIOHstockTarget($articles_id)
{
if (is_null(self::$diohStopLevel)) {
self::loadDIOHsettings();
}
//old method using average:
//return ceil(($this->log_articles[$articles_id][self::DIOH_BASENUMBER_COLUMN_NAME]/30) * self::$diohStopLevel[$this->stars]);
//new method useing forecasting
$fc = new forecasting();
return $fc->calcForecast($this->log_articles[$articles_id][self::FORECAST_DAILY_COLUMN_NAME], self::$diohStopLevel[$this->stars]);
}
