";
echo "ABN:$companyvars[ABN]
";
echo "Phone:".$companyvars[phone]."";
?>
"; ?>
PRICEBOOK
| Customer Information |
|
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]); }
?>
|
|
|
|
cat'");
//GET THE CUSTOMERS DISCOUNT
//### 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%HVY GAL%'
order by length(code), inventory.cat,inventory.code");
if(count($inv) > "0"){
showRows("CHAIN-LINK FABRIC - HEAVY GAL 2.50mm","",$inv);
}
//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%HVY GAL%'
order by length(code),inventory.cat,inventory.code");
if(count($inv) > "0"){
showRows("CHAIN-LINK FABRIC - HEAVY GAL 3.15mm","",$inv);
}
//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 '%STD GAL%'
order by length(code),inventory.cat,inventory.code");
if(count($inv) > "0"){
showRows("CHAIN-LINK FABRIC - STANDARD GAL","",$inv);
}
//PVC - BLACK
$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%'
order by length(code),inventory.cat,inventory.code");
if(count($inv) > "0"){
showRows("CHAIN-LINK FABRIC - PVC BLACK","",$inv);
}
//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");
if(count($inv) > "0"){
showRows("CHAIN-LINK FABRIC - PVC GREEN","",$inv);
}
//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");
if(count($inv) > "0"){
showRows("CHAIN-LINK FABRIC - FUSION BONDED BLACK","",$inv);
}
?>
"0"){
showRows("TIE 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");
if(count($inv) > "0"){
showRows("LACING 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 'BW%'
order by inventory.cat,inventory.code");
if(count($inv) > "0"){
showRows("BARB 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");
if(count($inv) > "0"){
showRows("HELICOIL / CABLE WIRE","",$inv);
}
// CLIPPING TOOLS
$inv = getFieldArray("inventory.*",
"inventory,invpricebookitems",
"where inventory.id=invpricebookitems.inventoryid AND
invpricebookitems.pricebook='$_REQUEST[id]' AND
(inventory.cat='12' OR inventory.cat='19' )
order by inventory.cat,inventory.code");
if(count($inv) > "0"){
showRows("CLIPPING","",$inv);
}
?>