tep_db_connect();
define('STOCK_WARNING_LIMIT', 0.5);
//Alert if stock availibility is below this level (in percentage, 0,8=80%)
$products = array();
$articles = array();
use_class('products_minierp');
$class_pm = new products_minierp();
$bg_settings = $class_pm->retrieveBestGoodSettings();
$q = "SELECT pal.products_id, pal.products_articles_id AS articles_id, IFNULL(ps.stock, 0) AS stock";
$q .= " FROM products_log pl";
$q .= " INNER JOIN products p ON p.products_id=pl.products_id AND p.stars=3";
$q .= " INNER JOIN products_articles_log pal ON pal.products_id=pl.products_id";
$q .= " LEFT JOIN products_stock ps ON ps.jng_warehouses_id=" . WAREHOUSE_ID_PRODUCTS_HAMBURG . " AND ps.products_id=pl.products_id AND ps.articles_id=pal.products_articles_id";
$r = tep_db_query($q);
while ($row = tep_db_fetch_array($r)) {
$target = $class_pm->getDIOHstockTarget($row['products_id'], $row['articles_id']);
$percent = $target == 0 ? 0 : $row['stock'] / $target;
if ($percent < STOCK_WARNING_LIMIT) {
if (!in_array($row['products_id'], $products)) {
$products[] = $row['products_id'];
}
$articles[] = $row['products_id'] . '-' . $row['articles_id'];
}
}
$products_total = count($products);
$articles_total = count($articles);
if ($products_total > 0) {
$subject = 'Depot Stock Report';
$send_message = '<p>This email is sent automatically by Manobo.</p>';
$send_message .= '<p>We have today ' . $products_total . ' Top Seller Products (' . $articles_total . ' Articles) with stock ' . STOCK_WARNING_LIMIT * 100 . '% below our stock target</p>';
$send_message .= '<p>MANOBO</p>';
