function analysis_overview($period, $price_type)
{
use_class('jng_warehouses');
$class_jw = new jng_warehouses();
$q = "SELECT jw.name, jw.warehouse_code, jw.warehouse_type";
$q .= ", IF(jw.warehouse_type='E', SUM(mse.stock_open), SUM(msp.stock_open)) AS stock_open";
$q .= ", IF(jw.warehouse_type='E', SUM(mse.stock_close), SUM(msp.stock_close)) AS stock_close";
/*
if($price_type=='mat_exp') {
$q .= ", IF(jw.warehouse_type='E', SUM(mse.mat_exp_open), SUM(msp.mat_exp_open)) AS stock_value_open";
$q .= ", IF(jw.warehouse_type='E', SUM(mse.mat_exp_close), SUM(msp.mat_exp_close)) AS stock_value_close";
} else {
$q .= ", IF(jw.warehouse_type='E', 0, SUM(msp.purchase_price_open)) AS stock_value_open";
$q .= ", IF(jw.warehouse_type='E', 0, SUM(msp.purchase_price_close)) AS stock_value_close";
}
*/
if ($price_type == 'mat_exp') {
$q .= ", IF(jw.warehouse_type='E', SUM(mse.stock_open*mse.mat_exp_open), SUM(msp.stock_open*msp.mat_exp_open)) AS stock_value_open";
$q .= ", IF(jw.warehouse_type='E', SUM(mse.stock_close*mse.mat_exp_close), SUM(msp.stock_close*msp.mat_exp_close)) AS stock_value_close";
} else {
$q .= ", IF(jw.warehouse_type='E', 0, SUM(msp.stock_open*msp.purchase_price_open)) AS stock_value_open";
$q .= ", IF(jw.warehouse_type='E', 0, SUM(msp.stock_close*msp.purchase_price_close)) AS stock_value_close";
}
$q .= " FROM jng_warehouses jw";
$q .= " LEFT JOIN minierp_stock_elements mse ON mse.jng_warehouses_id=jw.jng_warehouses_id AND mse.stock_period='{$period}'";
$q .= " LEFT JOIN minierp_stock_products msp ON msp.jng_warehouses_id=jw.jng_warehouses_id AND msp.stock_period='{$period}'";
$q .= " GROUP BY jw.jng_warehouses_id";
$q .= " ORDER BY jw.jng_warehouses_id";
$r = tep_db_query($q);
$stocks = array();
$s = array();
$s['name'] = 'Warehouse Name';
$s['long_id'] = 'Code';
$s['status'] = 'Type';
$s['price'] = 'Inventory<br />BoP Value';
$s['price2'] = 'Inventory<br />EoP Value';
$s['price3'] = 'Inventory<br />Ave.Value';
$stocks[] = $s;
while ($row = tep_db_fetch_array($r)) {
$bop = $row['stock_value_open'];
$eop = $row['stock_value_close'];
$avg = ($bop + $eop) / 2;
$s['name'] = $row['name'];
$s['long_id'] = $row['warehouse_code'];
$s['status'] = $class_jw->typeName($row['warehouse_type']);
if ($row['warehouse_type'] == 'E' && $price_type != 'mat_exp') {
$s['price'] = '-';
$s['price2'] = '-';
$s['price3'] = '-';
} else {
$s['price'] = number_format($bop, 2);
$s['price2'] = number_format($eop, 2);
$s['price3'] = number_format($avg, 2);
}
$stocks[] = $s;
}
$result = tep_draw_table('', $stocks);
return $result;
}
<?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
use_class('jng_warehouses');
$class_jw = new jng_warehouses();
if (isset($_GET['id']) && $_GET['id'] != '') {
$wid = tep_db_prepare_input($_GET['id']);
} else {
header('Location: ?open=warehouses');
exit;
}
//SUBMIT ACTION
if (isset($_POST)) {
if ($_POST['me_action'] == 'WAREHOUSEDELETE') {
/*
$exist_query = tep_db_query("SELECT jng_warehouses_id FROM jng_warehouses WHERE jng_warehouses_id=$wid");
if(tep_db_num_rows($exist_query)>0) {
$check1_query = tep_db_query("SELECT * FROM minierp_groups_credentials WHERE warehouses_id=$wid");
$check1 = (tep_db_num_rows($check1_query)==0);
if($check1) {
tep_db_query("DELETE FROM jng_warehouses WHERE jng_warehouses_id=$wid");
$messagebox->add("Module ID: <strong>$wid</strong> is successfully deleted.");
$wid = 'new';
} else {
$messagebox->add('<strong>Module Deletion Failed:</strong>');
if(!$check1) $messagebox->add('• Module is still connected to 1 or more group.');
}
} else {
$messagebox->add("Module ID: <strong>$wid</strong> is not found on database.");
$wid = 'new';
}
*/
<?php
use_class('jng_warehouses');
$class_jw = new jng_warehouses();
//START TEMPLATE
$filter = '';
$order = "jng_warehouses_id";
$warehouses = $class_jw->retrieveList($filter, $order);
$g = array();
$g['id'] = 'ID';
$g['name'] = 'Name';
$g['long_id'] = 'Code';
$g['source'] = 'Type';
//$g['nick'] = 'PIC';
//$g['city'] = 'City';
$g['act'] = 'Status';
$wh_table[] = $g;
if (count($warehouses) > 0) {
foreach ($warehouses as $row) {
$detail = '?open=warehouse&id=' . $row['jng_warehouses_id'] . '&hidemenu=true';
$g = array();
$g['id'] = '<a href="' . $detail . '" class="view_webpage" title="Manage warehouse detail">' . $row['jng_warehouses_id'] . '</a>';
$g['name'] = '<a href="' . $detail . '" class="view_webpage" title="Manage warehouse detail">' . $row['name'] . '</a>';
$g['long_id'] = $row['warehouse_code'];
$g['source'] = $class_jw->typeName($row['warehouse_type']);
//$g['nick'] = '<a href="'.$row['pic'].'">'.$row['pic'].'</a>';
//$g['city'] = $row['address_city'];
$g['act'] = '<img src="images/icon-tick' . ($row['is_active'] == '1' ? '' : '-dis') . '.png" />';
$wh_table[] = $g;
}
} else {