$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");