set_time_limit(0);
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
$jng_sp_id = '5';
//NEW PROCESS WITH NEW CALC METHOD
use_class('jng_sp_orders');
$class_jo = new jng_sp_orders();
$orders_query = tep_db_query("SELECT jng_sp_orders_id FROM jng_sp_orders WHERE jng_sp_id={$jng_sp_id}");
$orders_count = 0;
while ($row = tep_db_fetch_array($orders_query)) {
$orders_count++;
$dataArray = $class_jo->calculateAnalysisData($row['jng_sp_orders_id']);
$class_jo->saveAnalysisData($dataArray);
}
echo "{$orders_count} Order(s) are Processed";
echo '<br />';
//OLD PROCESS WITH OLD CALC METHOD
use_class('jng_sp_catalog');
$class_jc = new jng_sp_catalog();
$joi = array();
$joi_query = "SELECT joi.*";
$joi_query .= " FROM jng_sp_orders jo";
$joi_query .= " INNER JOIN jng_sp_orders_items joi ON joi.jng_sp_orders_id=jo.jng_sp_orders_id";
$joi_query .= " WHERE jo.jng_sp_id={$jng_sp_id}";
$joi_result = tep_db_query($joi_query);
while ($row = tep_db_fetch_array($joi_result)) {
if (!isset($joi[$row['products_id']])) {
/* RECALC VER. 2
$q = "SELECT DISTINCT p.products_id FROM products p ";
$q .= " INNER JOIN products_use_elements pue ON pue.products_id = p.products_id AND pue.finishing_goldplate = '1'";
$q .= " WHERE p.products_status = 1";
$r = tep_db_query($q);
while($row=tep_db_fetch_array($r)) {
$products_id = $row['products_id'];
$class_pm->calculateMaterialExpenses($products_id);
echo "update products $products_id<br/>";
$products[] = $products_id;
}
echo count($products)." Products Mat. Exp. is updated<br/>";
die("DONE");
*/
//RECALC VC
$orders = array();
$q = "SELECT jng_sp_orders_id, jng_sp_orders_items_id, confirm_order_time, products_id, price, material_expenses";
$q .= " FROM jng_sp_orders_items";
$q .= " WHERE price / material_expenses < 0.5";
$q .= " ORDER BY jng_sp_orders_id DESC";
$r = tep_db_query($q);
while ($row = tep_db_fetch_array($r)) {
$orders[] = $row['jng_sp_orders_id'];
}
tep_db_query("UPDATE jng_sp_orders_items SET material_expenses=0 WHERE jng_sp_orders_id IN (" . implode(',', $orders) . ")");
foreach ($orders as $order_id) {
$dataArray = $class_jo->calculateAnalysisData($order_id);
$class_jo->saveAnalysisData($dataArray);
}
echo count($orders) . " Order(s) are recalc";
tep_db_close();