' . MENU_PRODUCT_INVENTORY_ACTIVITY . '
';
$excelContent .= MENU_PRODUCT_INVENTORY_ACTIVITY."\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['location_id']!='' || $_POST['pgroup_id']!='') {
$msg .= '
';
$excelContent .= "\n\n";
}
if($_POST['location_group_id']!='') {
$query=mysql_query("SELECT name FROM location_groups WHERE id=".$_POST['location_group_id']);
$data=mysql_fetch_array($query);
$msg .= '
'.TABLE_COMPANY.': '.$data[0];
$excelContent .= TABLE_COMPANY.': '.$data[0];
}
if($_POST['location_id']!='') {
$query=mysql_query("SELECT name FROM locations WHERE id=".$_POST['location_id']);
$data=mysql_fetch_array($query);
$msg .= '
'.TABLE_LOCATION.': '.$data[0];
$excelContent .= TABLE_LOCATION.': '.$data[0];
}
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];
}
$msg .= '
';
$excelContent .= "\n\n";
echo $this->element('/print/header-report',array('msg'=>$msg));
$excelLots = '';
$excelExp = '';
if($allowLost == true){
$excelLots = "\t".TABLE_LOTS_NO;
}
if($allowExpired == true){
$excelExp = "\t".TABLE_EXP_DATE_SHORT;
}
$excelContent .= TABLE_NO."\t".TABLE_SKU."\t".TABLE_LOCATION.$excelLots.$excelExp."\t".'Beginning'."\t".'Adjust'."\t".'PB'."\t".'PR'."\tSales\tReturn\t".'Transfer'."\t".'Ending'."\tOrder\t".TABLE_UOM;
?>
|
|
|
|
|
Beginning |
Adjust |
PB |
PR |
Sales |
Return |
Transfer |
Ending |
|
|
| Product |
| Total |
|
|
|
|
|
|
|
|
|
|
|
0?$dataGlobal['qty']:0;
$subTotalEBI = ($data['total_pb'] + $data['total_cm'] + $data['total_to_in'] + $data['total_cycle'] + $data['total_cus_consign_in'] + $data['total_ven_consign_in']) - ($data['total_so'] + $data['total_pbc'] + $data['total_pos'] + $data['total_to_out'] + $data['total_cus_consign_out'] + $data['total_ven_consign_out']);
// Total Purchase Bill
$subTotalBillQty = ($data['total_pb'] - $dataGlobal['total_pb']);
$subTotalParentBillQty += ($data['total_pb'] - $dataGlobal['total_pb']);
$totalBillQty += ($data['total_pb'] - $dataGlobal['total_pb']);
// Total Bill Return
$subTotalCreditQty = ($data['total_pbc'] - $dataGlobal['total_pbc']);
$subTotalParentCreditQty += ($data['total_pbc'] - $dataGlobal['total_pbc']);
$totalCreditQty += ($data['total_pbc'] - $dataGlobal['total_pbc']);
// Total Sales + Total POS
$subTotalInvoiceQty = (($data['total_pos'] + $data['total_so']) - ($dataGlobal['total_pos'] + $dataGlobal['total_so']));
$subTotalParentInvoiceQty += (($data['total_pos'] + $data['total_so']) - ($dataGlobal['total_pos'] + $dataGlobal['total_so']));
$totalInvoiceQty += (($data['total_pos'] + $data['total_so']) - ($dataGlobal['total_pos'] + $dataGlobal['total_so']));
// Total CM
$subTotalCreditMemoQty = ($data['total_cm'] - $dataGlobal['total_cm']);
$subTotalParentCreditMemoQty += ($data['total_cm'] - $dataGlobal['total_cm']);
$totalCreditMemoQty += ($data['total_cm'] - $dataGlobal['total_cm']);
// Total Adj
$subTotalAdjQty = ($data['total_cycle'] - $dataGlobal['total_cycle']);
$subTotalParentAdjQty += ($data['total_cycle'] - $dataGlobal['total_cycle']);
$totalAdjQty += ($data['total_cycle'] - $dataGlobal['total_cycle']);
// Total Transfer
$subTotalTransferQty = ($data['total_to_in'] - $data['total_to_out']) - ($dataGlobal['total_to_in'] - $dataGlobal['total_to_out']);
$subTotalParentTransferQty += ($data['total_to_in'] - $data['total_to_out']) - ($dataGlobal['total_to_in'] - $dataGlobal['total_to_out']);
$totalTransferQty += ($data['total_to_in'] - $data['total_to_out']) - ($dataGlobal['total_to_in'] - $dataGlobal['total_to_out']);
// Total Customer Consignment
$subTotalCusConsign = ($data['total_cus_consign_in'] - $data['total_cus_consign_out']) - ($dataGlobal['total_cus_consign_in'] - $dataGlobal['total_cus_consign_out']);
$subTotalParentCusConsign += ($data['total_cus_consign_in'] - $data['total_cus_consign_out']) - ($dataGlobal['total_cus_consign_in'] - $dataGlobal['total_cus_consign_out']);
$totalCusConsign += ($data['total_cus_consign_in'] - $data['total_cus_consign_out']) - ($dataGlobal['total_cus_consign_in'] - $dataGlobal['total_cus_consign_out']);
// Total Vendor Consignment
$subTotalVenConsign = ($data['total_ven_consign_in'] - $data['total_ven_consign_out']) - ($dataGlobal['total_ven_consign_in'] - $dataGlobal['total_ven_consign_out']);
$subTotalParentVenConsign += ($data['total_ven_consign_in'] - $data['total_ven_consign_out']) - ($dataGlobal['total_ven_consign_in'] - $dataGlobal['total_ven_consign_out']);
$totalVenConsign += ($data['total_ven_consign_in'] - $data['total_ven_consign_out']) - ($dataGlobal['total_ven_consign_in'] - $dataGlobal['total_ven_consign_out']);
// Total EBI & Total
$totalBBI += $subTotalBBI;
$totalEBI += $subTotalEBI;
$subTotalParentBBI += $subTotalBBI;
$subTotalParentEBI += $subTotalEBI;
// Total Order
$subTotalOrderQty = ($data['total_order'] - $dataGlobal['total_order']);
$subTotalParentOrderQty += ($data['total_order'] - $dataGlobal['total_order']);
$totalOrderQty += ($data['total_order'] - $dataGlobal['total_order']);
$oldProductId=$data['product_id'];
$oldProductCode=$data['product_code'];
$oldProductName=$data['product_name'];
$excelExpired = "";
$expDate = "";
if($allowExpired == true){
if($data['expired_date'] != '' && $data['expired_date'] != '0000-00-00'){
$expDate = dateShort($data['expired_date']);
} else {
$expDate = "";
}
$excelExpired = "\t".$expDate;
}
$excelLotsData = "";
if($allowLost == true){
$excelLotsData = "\t".$data['lots_number'];
}
$excelContent .= "\n".$index++."\t".$oldProductCode."\t".$data['location_name'].$excelLotsData.$excelExpired."\t".$subTotalBBI."\t".$subTotalAdjQty."\t".$subTotalBillQty."\t".($subTotalCreditQty*-1)."\t".($subTotalInvoiceQty*-1)."\t".$subTotalCreditMemoQty."\t".$subTotalTransferQty."\t".$subTotalEBI."\t".number_format($subTotalOrderQty, 0)."\t".$small_label; ?>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total |
|
|
|
|
|
|
|
|
|
|
| Total |
|
|
|
|
|
|
|
|
|
|