<?php use_class('minierp_stock'); $class_ms = new minierp_stock(); use_class('jng_warehouses'); $class_jw = new jng_warehouses(); //GET PAGE $session_page = 'analysis-stock-list'; $page = 1; if (isset($_GET['page'])) { $page = $_GET['page']; } //FILTER OPTIONS $period_options = $class_ms->analysis_period(); $period = $_SESSION[$session_page]['period']; if (isset($_POST['period'])) { $period = tep_db_prepare_input($_POST['period']); } if (is_null($period) || !array_key_exists($period, $period_options)) { $period_keys = array_keys($period_options); $period = $period_keys[0]; } $_SESSION[$session_page]['period'] = $period; $period_opt = '<select name="period">'; foreach ($period_options as $value => $option) { $sel = $period == $value ? 'selected="selected"' : ''; $period_opt .= '<option value="' . $value . '" ' . $sel . '>' . $option . '</option>'; } $period_opt .= '</select>'; $wh_lists = $class_jw->retrieveList(); $wh_options = array();
<?php global $db; require_once '../confy.php'; require_once '../functions.php'; require_once '../functions-2.php'; tep_db_connect(); use_class('products_minierp'); $class_pm = new products_minierp(); use_class('elements_stock'); $class_es = new elements_stock(); use_class('minierp_stock'); $class_ms = new minierp_stock(); $period = date('Ym'); //PRODUCTS $total_products = array(); foreach ($class_ms->whid_by_status as $status => $jng_warehouses_id) { if ($status != '20') { if (!isset($total_products[$jng_warehouses_id])) { $total_products[$jng_warehouses_id] = array(); } //JNG $q = tep_db_query("SELECT products_id, products_articles_id, products_quantity FROM orders_products WHERE status={$status}"); while ($row = tep_db_fetch_array($q)) { $products_id = $row['products_id']; $articles_id = $row['products_articles_id']; if (!isset($total_products[$jng_warehouses_id][$products_id])) { $total_products[$jng_warehouses_id][$products_id] = array(); } if (!isset($total_products[$jng_warehouses_id][$products_id][$articles_id])) { $total_products[$jng_warehouses_id][$products_id][$articles_id] = 0;
<?php use_class('minierp_stock'); $class_ms = new minierp_stock(); //GET PAGE $session_page = 'analysis-stock-overview'; //FILTER OPTIONS $period_options = $class_ms->analysis_period(); $period = $_SESSION[$session_page]['period']; if (isset($_POST['period'])) { $period = tep_db_prepare_input($_POST['period']); } if (is_null($period) || !array_key_exists($period, $period_options)) { $period_keys = array_keys($period_options); $period = $period_keys[0]; } $_SESSION[$session_page]['period'] = $period; $period_opt = '<select name="period">'; foreach ($period_options as $value => $option) { $sel = $period == $value ? 'selected="selected"' : ''; $period_opt .= '<option value="' . $value . '" ' . $sel . '>' . $option . '</option>'; } $period_opt .= '</select>'; $price_type_options = array('mat_exp' => 'Material Expenses'); $price_type_options['purchase_price'] = 'Purchase Price'; $price_type = $_SESSION[$session_page]['price_type']; if (isset($_POST['price_type'])) { $price_type = tep_db_prepare_input($_POST['price_type']); } if (is_null($price_type) || !array_key_exists($price_type, $price_type_options)) { $price_type_keys = array_keys($price_type_options);