stock-holdings-lines-iframe.php

// cols to labels
$qtyhead1 = $CURRENT_USER['qtyheadingcode'];
$qtyHeadings = mysql_get('qty_headings',$qtyhead1);
$colsToLabels = array( // used to header and sorting
'shl.pallet_no' => 'Pallet No',
'shl.lot_no' => 'Lot No',
'shl.date_code' => 'Date Code',
'shl.bb_date' => 'Best Before Date',
'shl.rec_date' => 'Goods in Date', // added 10/3/16
'wn.name' => coalesce(@$companyInfo['warehouse_column_name'],"Warehouse"),
'shl.qty1' => coalesce(@$qtyHeadings['qty1'],'qty1'),
'shl.qty2' => coalesce(@$qtyHeadings['qty2'],'qty2'),
'shl.qty3' => coalesce(@$qtyHeadings['qty3'],'qty3'),
'shl.qty1_cleared' => 'Cleared ' . coalesce(@$qtyHeadings['qty1'],'qty1'),
'shl.qty1_precleared' => 'Pre Cleared ' . coalesce(@$qtyHeadings['qty1'],'qty1'),
'shl.qty2_cleared' => 'Cleared ' . coalesce(@$qtyHeadings['qty2'],'qty2'),
'shl.qty2_precleared' => 'Pre Cleared ' . coalesce(@$qtyHeadings['qty2'],'qty2'),
'shl.qty3_cleared' => 'Cleared ' . coalesce(@$qtyHeadings['qty3'],'qty3'),
'shl.qty3_precleared' => 'Pre Cleared ' . coalesce(@$qtyHeadings['qty3'],'qty3'),
'shl.all_qty' => "Alloc " . coalesce(@$qtyHeadings[strtolower($qtyHeadings['default'])],''),
'shl.free_qty' => "Free " . coalesce(@$qtyHeadings[strtolower($qtyHeadings['default'])],''),
//
);
if(@$qtyHeadings['bbd']) {
unset($colsToLabels['shl.date_code']);
}
else {
unset($colsToLabels['shl.bb_date']);
}