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 {