' . MENU_INVENTORY_CONSIGNMENT . '
';
$excelContent .= MENU_INVENTORY_CONSIGNMENT."\n\n";
if($_POST['date_from']!='') {
$msg .= REPORT_FROM.': '.$_POST['date_from'];
$excelContent .= REPORT_FROM.': '.$_POST['date_from'];
}
if($_POST['date_to']!='') {
$msg .= ' '.REPORT_TO.': '.$_POST['date_to'];
$excelContent .= ' '.REPORT_TO.': '.$_POST['date_to'];
}
if($_POST['location_group_id']!='' || $_POST['pgroup_id']!='') {
$msg .= '
';
$excelContent .= "\n\n";
}
if($_POST['location_group_id']!='' || $_POST['pgroup_id']!='') {
$msg .= '
';
$excelContent .= "\n\n";
}
if($_POST['pgroup_id']!='') {
$query=mysql_query("SELECT name FROM pgroups WHERE id=".$_POST['pgroup_id']);
$data=mysql_fetch_array($query);
$msg .= '
'.GENERAL_TYPE.': '.$data[0];
$excelContent .= GENERAL_TYPE.': '.$data[0];
}
$excelContent .= "\n".TABLE_ITEM_DETAIL;
$msg .= '
';
$excelContent .= "\n\n";
echo $this->element('/print/header-report',array('msg'=>$msg, 'action' => TABLE_ITEM_DETAIL));
$excelLots = "\t".TABLE_LOTS_NO;
$rowSpan = 10;
if($rowSettingUomDetail[0] == 0){
$excelLots = '';
$rowSpan = 9;
}
$excelContent .= TABLE_NO."\t".TABLE_SKU."\t".TABLE_TYPE."\t".TABLE_DATE."\tModule Code\tCustomer/Vendor Name\t".TABLE_LOCATION_GROUP."\t".TABLE_LOCATION.$excelLots."\t".TABLE_EXP_DATE_SHORT."\t".TABLE_QTY."\t".TABLE_UOM;
?>
|
|
|
|
Module Code |
Customer/Vendor Name |
|
|
|
|
|
|
= DATE(inventories.date)';
}
if ($col[3] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'inventories.location_group_id = ' . $col[3];
} else {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'inventories.location_group_id IN (SELECT location_groups.id FROM location_groups INNER JOIN customer_companies ON customer_companies.customer_id = location_groups.customer_id AND customer_companies.company_id IN (SELECT company_id FROM user_companies WHERE user_id = '.$user['User']['id'].') WHERE location_groups.location_group_type_id = 1 AND location_groups.customer_id > 0 GROUP BY location_groups.id)';
}
if ($col[4] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'inventories.product_id IN (SELECT product_id FROM product_pgroups WHERE pgroup_id = ' . $col[4]. ')';
}
if ($col[5] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= '(SELECT parent_id FROM products WHERE id=inventories.product_id) = ' . $col[5];
}
if ($col[6] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'inventories.product_id = ' . $col[6];
}
$totalQty=0;
$sql = "SELECT
cycle_product_id,
sales_order_id,
point_of_sales_id,
credit_memo_id,
purchase_order_id,
transfer_order_id,
consignment_id,
consignment_return_id,
vendor_consignment_id,
vendor_consignment_return_id,
inventories.type AS type,
customers.name AS cus_name,
vendors.name AS ven_name,
products.code AS pro_code,
products.name AS pro_name,
locations.name AS loc_name,
location_groups.name AS loc_g_name,
qty,
inventories.date AS date,
lots_number,
date_expired,
uoms.abbr AS uom_name,
products.price_uom_id AS price_uom_id
FROM inventories
LEFT JOIN customers ON customers.id = inventories.customer_id
LEFT JOIN vendors ON vendors.id = inventories.vendor_id
INNER JOIN products ON products.id = inventories.product_id
INNER JOIN uoms ON uoms.id = products.price_uom_id
INNER JOIN locations ON locations.id = inventories.location_id
INNER JOIN location_groups ON location_groups.id = inventories.location_group_id
WHERE ".$condition." ORDER BY inventories.id ASC";
$query = mysql_query($sql);
$index = 0;
while($data = mysql_fetch_array($query)){
$queryUom=mysql_query("SELECT id,name,abbr,1 AS conversion FROM uoms WHERE id=".$data['price_uom_id']."
UNION
SELECT id,name,abbr,(SELECT value FROM uom_conversions WHERE is_active=1 AND from_uom_id=".$data['price_uom_id']." AND to_uom_id=uoms.id) AS conversion FROM uoms WHERE id IN (SELECT to_uom_id FROM uom_conversions WHERE is_active=1 AND from_uom_id=".$data['price_uom_id'].")
ORDER BY conversion ASC");
while($dataUom=mysql_fetch_array($queryUom)){
$small_label = $dataUom['abbr'];
}
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Product |
|
|