' . MENU_PRODUCT_INVENTORY_VALUATION_SUMMARY . '
';
$excelContent .= MENU_PRODUCT_INVENTORY_VALUATION_SUMMARY."\n\n";
if($_POST['date']!='') {
$msg .= ' '.TABLE_DATE.': '.$_POST['date'];
$excelContent .= ' '.TABLE_DATE.': '.$_POST['date']."\n\n";
}
echo $this->element('/print/header-report',array('msg'=>$msg));
$excelContent .= TABLE_NO."\t".TABLE_NAME."\t".TABLE_UOM."\t".'On Hand'."\t".'Avg Cost ('.$rowSym[0].")\t".'Asset Value ('.$rowSym[0].")\t".'% of Tot Asset';
?>
|
|
|
On Hand |
Avg Cost () |
Asset Value () |
% of Tot Asset |
= DATE(inventory_valuations.date)';
}
if ($col[1] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'inventory_valuations.pid=' . $col[1];
}
?>
| Inventory |
0?$assetValue:0)."\t".((($assetValue>0?$assetValue:0)/($asset>0?$asset:1))*100).'%'; ?>
|
|
|
|
|
0?$assetValue:0),2); ?> |
0?$assetValue:0)/($asset>0?$asset:1))*100,2).'%'; ?> |
0?$onHand:0);
$totalAssetValue += $assetValue;
$onHand = 0;
$assetValue = 0;
}
}
$onHand += $data['qty'];
$avgCost = $data['avg_cost'];
$assetValue += $data['qty'] * $data['avg_cost'];
$oldProductId = $data['pid'];
$oldProductName = $data['product_name'];
$oldUomName = $data['uom_name'];
}
$totalOnHand += $onHand;
$totalAssetValue += $assetValue;
if(mysql_num_rows($query)){
$excelContent .= "\n".$index."\t".$oldProductName."\t".$oldUomName."\t".number_format($onHand, 3)."\t".number_format($avgCost, $avgDecimal)."\t".$assetValue."\t".(($assetValue/($asset>0?$asset:1))*100).'%'; ?>
|
|
|
|
|
|
0?$asset:1))*100, 2).'%'; ?> |
| Total Inventory |
|
|
|
|
| |
| TOTAL |
|
|
|
|