$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]); }