PHP jng_warehouses::typeName示例

示例#1

文件： minierp_stock.php 项目： blasiuscosa/manobo-2008

 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;
 }

示例#2

文件： warehouses.php 项目： blasiuscosa/manobo-2008

$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 {
    $g = array();
    $g['id'] = '&nbsp;';
    $g['name'] = '&nbsp;';
    $g['long_id'] = '&nbsp;';
    $g['type'] = '&nbsp;';
    //$g['nick'] 	= '&nbsp;';
    //$g['city']  = '&nbsp;';
    $g['act'] = '';
    $wh_table[] = $g;