$value = $brand_id;
$type = str_replace('set-', '', $type);
} else {
$pbgs = array('value' => $value);
tep_db_perform('products_best_good_settings', $pbgs, 'update', "id={$type}");
}
$result['type'] = $type;
$result['value'] = $value;
ajaxReturn($result);
exit;
} elseif ($_POST['me_action'] == 'RECALCMARGIN') {
set_time_limit(0);
use_class('logger');
$logger = new logger('cron', 'daily-counter-products-matexp');
$logger->write('Margin is recalculated manually by ' . $session_userinfo['username']);
$products = $class_pm->retrieveList("active_status=1");
$pcounter = 0;
foreach ($products as $p) {
$pcounter++;
$class_pm->updateMargin($p['products_id']);
echo '. ';
}
$logger->write($pcounter . ' products updated successfully');
$logger->close();
echo 'DONE!';
exit;
}
}
$sop_mouse_over = array();
$sop_mouse_over['hide_hard'] = 'Report 0 stock for products with Hard Complexity and no depot stock on J&G and all SP Websites';
$sop_mouse_over['hide_extreme'] = 'Report 0 stock for products with Extreme Complexity and no depot stock on J&G and all SP Websites';
}
//PAGE INITALIZER (Finding what parameters are sent to module)
$showsearchform = true;
if (isset($_POST['product']) || isset($_GET['product'])) {
$p = tep_db_prepare_input(isset($_POST['product']) ? $_POST['product'] : $_GET['product']);
if ($p == '') {
$messagebox->add('Please enter a Product ID / Code / EAN');
} elseif (strlen($p) == 13 && is_numeric($p)) {
$pinfo = $class_ean->getProductArticle($p);
$pid = $pinfo['products_id'];
$aid = $pinfo['products_articles_id'];
$ps = $class_pm->stockRetrieveDetail($fg_whid, $pid, $aid);
openStockDetail($ps['products_stock_id']);
} else {
if (substr($p, 0, 1) == '0') {
$products = $class_pm->retrieveList("products_model='{$p}'");
if (count($products) > 0) {
$p = $products[0]['products_id'];
}
}
$articles = $class_pa->retrieveList($p);
if (count($articles) == 0) {
$ps = $class_pm->stockRetrieveDetail($fg_whid, $p, '0');
if (!is_null($ps)) {
openStockDetail($ps['products_stock_id']);
}
} else {
$content .= drawProductInfo($p, $articles);
$content .= '<h3 style="clear:both;padding-top:30px;">or open another product below</h3>';
}
}
<?php
//SUBMIT ACTION
$PR_SUSPICIOUS_LIMIT = 10;
if (isset($_POST)) {
if ($_POST['me_action'] == 'RECOUNTPRODUCTSMATEXPENSES') {
$products_id = tep_db_prepare_input($_POST['products_id']);
use_class("products_minierp");
$class_pm = new products_minierp();
$filter = $products_id == '*' ? 'material_expenses=0' : "products_id IN ({$products_id})";
$products = $class_pm->retrieveList($filter);
foreach ($products as $p) {
$class_pm->calculateMaterialExpenses($p['products_id']);
}
$messagebox->add('Material Expenses is Recalculated', 'green');
} elseif ($_POST['me_action'] == 'RECOUNTPRODUCTSBOUGHT') {
tep_db_query("UPDATE products SET products_ordered=0");
$products_query = tep_db_query("SELECT op.products_id, COUNT(op.products_id) AS count_result FROM orders_products op INNER JOIN orders o ON o.orders_id=op.orders_id AND o.orders_status<=10 GROUP BY op.products_id");
while ($row = tep_db_fetch_array($products_query)) {
$product_id = $row['products_id'];
$count_result = $row['count_result'];
$recount_query = "UPDATE products SET products_ordered={$count_result} WHERE products_id={$product_id}";
tep_db_query($recount_query);
}
$messagebox->add('Products Bought is Recount', 'green');
} elseif ($_POST['me_action'] == 'RECOUNTPRODUCTSRATING') {
if (isset($_POST['products_id']) && $_POST['products_id'] != '') {
$products_id = tep_db_prepare_input($_POST['products_id']);
$counter = 0;
if ($products_id == '*') {
$ratequery = tep_db_query("SELECT products_id, COUNT(products_id) AS total_rated, SUM(rating_point)/COUNT(rating_point) AS rate_point FROM products_rating GROUP BY products_id");
