$update = strtolower($_POST['update']);
     $products_id = tep_db_prepare_input($_GET['products_id']);
     if ($update == 'add') {
         $class_mu->addToWatchlist($session_userinfo['id'], $products_id);
     } else {
         $class_mu->removeFromWatchlist($session_userinfo['id'], $products_id);
     }
     $result = array();
     $result['pid'] = $products_id;
     $result['update'] = $update;
     ajaxReturn($result);
     exit;
 } elseif ($_POST['me_action'] == 'UPDATECOMPLEXITY') {
     $products_id = tep_db_prepare_input($_GET['products_id']);
     $complexity = tep_db_prepare_input($_POST['complexity']);
     $class_pm->updateComplexity($products_id, $complexity);
     echo utf8_encode(productComplexityName($complexity));
     exit;
 } elseif ($_POST['me_action'] == 'UPDATEPRODUCTINFO') {
     //UPDATE PRODUCT DETAIL
     $products_id = tep_db_prepare_input($_POST['products_id']);
     //Update Table products
     $sql_data_array = array();
     $sql_data_array['active_status'] = tep_db_prepare_input($_POST['active_status']);
     $sql_data_array['products_status'] = tep_db_prepare_input($_POST['products_status']);
     //	$sql_data_array['products_date_added']		  = tep_db_prepare_input($_POST['products_date_added']).' '.tep_db_prepare_input($_POST['products_date_added_time']);
     //	$sql_data_array['products_last_modified']	  = tep_db_prepare_input($_POST['products_last_modified']).' '.tep_db_prepare_input($_POST['products_last_modified_time']);
     $sql_data_array['products_last_modified'] = date('Y-m-d H:i:s');
     if (isset($_POST['products_weight'])) {
         $sql_data_array['products_weight'] = tep_db_prepare_input($_POST['products_weight']);
     }
示例#2
0
 $q .= " UNION ALL";
 $q .= " SELECT DATE(do.order_date) AS rowdate, do.products_id, do.quantity, p.complexity ";
 $q .= " FROM depot_orders do";
 $q .= " LEFT JOIN products p ON p.products_id = do.products_id";
 $q .= " LEFT JOIN jng_sp_orders_items joi ON do.trans_type='SP' AND joi.jng_sp_orders_items_id=do.trans_id";
 $q .= " LEFT JOIN orders_products op ON do.trans_type='JG' AND op.orders_products_id=do.trans_id";
 //$q .= " WHERE DATE(do.order_date)>DATE('$filterdate_start') AND DATE(do.order_date)<DATE('$filterdate_end') AND do.status NOT IN (10, 12)";
 $q .= " WHERE do.order_date>'{$filterdate_start}' AND do.order_date<='{$filterdate_end}' AND do.status NOT IN (10, 12)";
 $q .= " AND (IFNULL(do.trans_type, 'AR')='AR' OR NOT (IFNULL(joi.mode, 0)=4 OR IFNULL(op.mode, 0)=4))";
 $q .= " ) dt";
 $q .= " ORDER BY rowdate DESC, complexity";
 $r = tep_db_query($q);
 $dbq = tep_db_query($q);
 $data = array();
 while ($r = tep_db_fetch_array($dbq)) {
     $complexity = $r['complexity'] != '' ? $r['complexity'] : $class_pm->updateComplexity($r['products_id']);
     $complexity_settings = $class_pm->retrieveComplexitySettings($complexity);
     $data[$r['rowdate']]['complexity'][$complexity] += $r['quantity'];
     $data[$r['rowdate']]['avgtotal'] += $complexity_settings['avg'];
 }
 $result = '<div class="kpi-infobox" style="float:right;min-width:400px;">';
 $result .= '<div class="ui-state-default ui-corner-all" style="float:right;margin:10px 10px 0 0"><span title="Hide/Show KPI Complexity" class="ui-icon ui-icon-minus" id="kpi-depot-info"></span></div>';
 $result .= '<div class="ibox ui-corner-all" style="padding:10px;">';
 $result .= '<h3>Current Settings</h3>';
 $result .= '<table class="form" border="0" cellpadding="0" cellspacing="0">';
 $result .= '<tr><td>AVG Time Product Easy</td><td>= ' . $bgst['vate_avgtime'] . ' minutes</td></tr>';
 $result .= '<tr><td>AVG Time Product Medium</td><td>= ' . $bgst['vatm_avgtime'] . ' minutes</td></tr>';
 $result .= '<tr><td>AVG Time Product Hard</td><td>= ' . $bgst['vath_avgtime'] . ' minutes</td></tr>';
 $result .= '<tr><td>AVG Time Product Extreme</td><td>= ' . $bgst['vatx_avgtime'] . ' minutes</td></tr>';
 $result .= '<tr><td>Available Time per Smith per Day</td><td>= ' . $bgst['atpdps'] . ' minutes</td></tr>';
 $result .= '</table>';
<?php

global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
set_time_limit(0);
ini_set('memory_limit', '256M');
use_class('products_minierp');
$class_pm = new products_minierp();
$n_complexity_added = 0;
//$dbq = tep_db_query("SELECT * FROM products ORDER BY products_id "); //APPLY TO ALL PRODUCTS
$dbq = tep_db_query("SELECT * FROM products WHERE IFNULL(complexity,'') = '' AND active_status = 1 ORDER BY products_id ");
//APPLY TO ALL PRODUCTS WHICH HAVE NO complexity
while ($r = tep_db_fetch_array($dbq)) {
    $pid = $r['products_id'];
    $update = $class_pm->updateComplexity($pid);
    if ($update) {
        $complexity = $class_pm->getProductComplexity($pid);
        echo "<p style=\"font-size:14px;\">Products {$pid} set with <strong>complexity {$complexity}</strong></p>";
        $n_complexity_added++;
    } else {
        echo "<p style=\"font-size:14px;color:red;\">Products {$pid} HAVE NO complexity</p>";
    }
}
echo "<br/><h2>{$n_complexity_added} Products are set with complexity</h2>";