";
echo "ABN:$companyvars[ABN]
";
echo "Phone:".$companyvars[phone]."";
?>
"; ?>
PRICEBOOK
| Customer Information |
Delivery Address |
Details |
Account Contact |
|
";
if(!empty($client[telephone])) { echo "Ph. ".$client[telephone]."
"; }
if(!empty($client[email])) { echo "E. ".$client[email]."
"; }
if(!empty($client[invAddress])) { echo nl2br($client[invAddress]); }
?>
|
".nl2br($quote[delAddress])."
";
echo "Ship Via: $quote[shipVia]";
}
?>
|
|
|
cat'");
//GET THE CUSTOMERS DISCOUNT
$diamonds=array("32","40","45","50","60");
//### CHAINLINK FABRIC
//HEAVY GAL 2.5
$inv = getFieldArray("inventory.*",
"inventory,invpricebookitems",
"where inventory.id=invpricebookitems.inventoryid AND
invpricebookitems.pricebook='$_REQUEST[id]' AND
inventory.cat='5' AND
inventory.desc like '%2.5%HEAVY GAL%'
order by substr(inventory.code,-7,2), length(code), inventory.cat,inventory.code");
foreach($diamonds as $row){
$tmp=$inv;
foreach($tmp as $key => $val){
if(substr($val['code'],-7,2)!=$row) { unset($tmp[$key]); }
}
if(count($tmp) > 0){
showRows("CHAINLINK - HEAVY GAL 2.50MM $row MESH","",$tmp);
}
}
//HEAVY GAL 3.15
$inv = getFieldArray("inventory.*",
"inventory,invpricebookitems",
"where inventory.id=invpricebookitems.inventoryid AND
invpricebookitems.pricebook='$_REQUEST[id]' AND
inventory.cat='5' AND
inventory.desc like '%3.15%HEAVY GAL%'
order by length(code),inventory.cat,inventory.code");
foreach($diamonds as $row){
$tmp=$inv;
foreach($tmp as $key => $val){
if(substr($val['code'],-7,2)!=$row) { unset($tmp[$key]); }
}
if(count($tmp) > 0){
showRows("CHAINLINK - HEAVY GAL 3.15MM $row MESH","",$tmp);
}
}
//STD GAL
$inv = getFieldArray("inventory.*",
"inventory,invpricebookitems",
"where inventory.id=invpricebookitems.inventoryid AND
invpricebookitems.pricebook='$_REQUEST[id]' AND
inventory.cat='5' AND
inventory.desc like '%STANDARD GAL%'
order by length(code),inventory.cat,inventory.code");
foreach($diamonds as $row){
$tmp=$inv;
foreach($tmp as $key => $val){
if(substr($val['code'],-7,2)!=$row) { unset($tmp[$key]); }
}
if(count($tmp) > 0){
showRows("CHAINLINK - STANDARD GAL $row MESH","",$tmp);
}
}
//PVC - BLACK 2.50
$inv = getFieldArray("inventory.*",
"inventory,invpricebookitems",
"where inventory.id=invpricebookitems.inventoryid AND
invpricebookitems.pricebook='$_REQUEST[id]' AND
inventory.cat='5' AND
inventory.desc like '%BLACK%PVC%' AND
inventory.desc like '%2.50%'
order by length(code),inventory.cat,inventory.code");
foreach($diamonds as $row){
$tmp=$inv;
foreach($tmp as $key => $val){
if(substr($val['code'],-7,2)!=$row) { unset($tmp[$key]); }
}
if(count($tmp) > 0){
showRows("CHAINLINK - PVC BLACK 2.50 $row MESH","",$tmp);
}
}
//PVC - BLACK 3.15
$inv = getFieldArray("inventory.*",
"inventory,invpricebookitems",
"where inventory.id=invpricebookitems.inventoryid AND
invpricebookitems.pricebook='$_REQUEST[id]' AND
inventory.cat='5' AND
inventory.desc like '%BLACK%PVC%' AND
inventory.desc like '%3.15%'
order by length(code),inventory.cat,inventory.code");
foreach($diamonds as $row){
$tmp=$inv;
foreach($tmp as $key => $val){
if(substr($val['code'],-7,2)!=$row) { unset($tmp[$key]); }
}
if(count($tmp) > 0){
showRows("CHAINLINK - PVC BLACK 3.15MM $row MESH","",$tmp);
}
}
//PVC - GREEN
$inv = getFieldArray("inventory.*",
"inventory,invpricebookitems",
"where inventory.id=invpricebookitems.inventoryid AND
invpricebookitems.pricebook='$_REQUEST[id]' AND
inventory.cat='5' AND
inventory.desc like '%GREEN%PVC%'
order by length(code),inventory.cat,inventory.code");
foreach($diamonds as $row){
$tmp=$inv;
foreach($tmp as $key => $val){
if(substr($val['code'],-7,2)!=$row) { unset($tmp[$key]); }
}
if(count($tmp) > 0){
showRows("CHAINLINK - PVC GREEN $row MESH","",$tmp);
}
}
//FUSE BONDED
$inv = getFieldArray("inventory.*",
"inventory,invpricebookitems",
"where inventory.id=invpricebookitems.inventoryid AND
invpricebookitems.pricebook='$_REQUEST[id]' AND
inventory.cat='5' AND
inventory.desc like '%Bonded%'
order by length(code),inventory.cat,inventory.code");
showRows("CHAINLINK - FUSE BONDED","",$inv);
// TIE WIRE
$inv = getFieldArray("inventory.*",
"inventory,invpricebookitems",
"where inventory.id=invpricebookitems.inventoryid AND
invpricebookitems.pricebook='$_REQUEST[id]' AND
inventory.cat='11' AND
inventory.code like 'TW%%'
order by inventory.cat,inventory.code");
showRows("TIE WIRE","",$inv);
// HELICOIL WIRE
$inv = getFieldArray("inventory.*",
"inventory,invpricebookitems",
"where inventory.id=invpricebookitems.inventoryid AND
invpricebookitems.pricebook='$_REQUEST[id]' AND
inventory.cat='11' AND
inventory.desc like '%HELI%'
order by inventory.cat,inventory.code");
showRows("HELICOIL WIRE","",$inv);
// PLAIN WIRE
$inv = getFieldArray("inventory.*",
"inventory,invpricebookitems",
"where inventory.id=invpricebookitems.inventoryid AND
invpricebookitems.pricebook='$_REQUEST[id]' AND
inventory.cat='11' AND
inventory.code like 'PW%'
order by inventory.cat,inventory.code");
showRows("PLAIN WIRE","",$inv);
// Lacing WIRE
$inv = getFieldArray("inventory.*",
"inventory,invpricebookitems",
"where inventory.id=invpricebookitems.inventoryid AND
invpricebookitems.pricebook='$_REQUEST[id]' AND
inventory.cat='11' AND
inventory.code like 'LW%'
order by inventory.cat,length(code), inventory.code");
showRows("LACING WIRE","",$inv);
?>