<?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);
