DETAILED SUMMARY

Order Summary   |   Quote Print

Order Tag:

query($query); while($rows = $result->fetch_assoc()) { $submit = $rows['submit']; } //$query = ("SELECT * FROM order_entry WHERE orderTag = '$orderName' and email = '$email' order by `date` asc"); $query = ("SELECT * FROM order_entry WHERE orderTag = '$orderName' and PO = '$PO' and email = '$email' order by `date` asc"); $result = $mysqli->query($query); while($rows = $result->fetch_assoc()) { $shade = $rows['shade']; $type = $rows ['type']; $product = $rows['product']; $price = $rows['price']; $code = $rows['code']; $reid = $rows['reid']; $orderTag = $rows['orderTag']; $shadeID = $rows['shadeID']; $quantity = $rows['quantity']; $width = $rows['width']; $length = $rows['length']; $measure = $rows['measure']; $sbs = $rows['sideBySide']; $group = $rows['group']; $series = $rows['series']; $fabric = $rows['fabric']; $hem = $rows['hem']; $hemColor = $rows['hemColor']; $hemCaps = $rows['hemCaps']; $controlPosition = $rows['controlPosition']; $controlSystem = $rows['controlSystem']; $controlColorPower = $rows['controlColorPower']; $controlController = $rows['controlController']; $controlClutchMotor = $rows['controlClutchMotor']; //Temporary Drive for Promo $drive = $rows['controlClutchMotor']; $controlclutchCover = $rows['controlclutchCover']; $valance = $rows['valance']; $valanceFinish = $rows['valanceFinish']; $valanceCaps = $rows['valanceCaps']; $valanceReturn = $rows['valanceReturn']; $mount = $rows['mount']; $trim = $rows['trim']; $trimColor = $rows['trimColor']; $pull = $rows['pull']; $pullColor = $rows['pullColor']; $chainDrop = $rows['chainDrop']; $chainDropLength = $rows['chainDropLength']; $liftAssist = $rows['liftAssist']; $ultraLite = $rows['ultraLite']; $springAssist = $rows['springAssist']; $clutchColor = $rows['clutchColor']; $childSafety = $rows['childSafety']; $holdDownBrackets = $rows['holdDownBrackets']; $sideChannel = $rows['sideChannel']; $sideChannelMount = $rows['sideChannelMount']; $sideChannelFinish = $rows['sideChannelFinish']; $rollType = $rows['rollType']; $special = $rows['specialInstruction']; //back $back_group = $rows['backGroup']; $back_series = $rows['backSeries']; $back_fabric = $rows['backFabric']; $back_hem = $rows['backHem']; $back_hemColor = $rows['backhemFinish']; $back_hemCaps = $rows['backHemCaps']; $back_controlPosition = $rows['backCPosition']; $back_controlSystem = $rows['backCSystem']; $back_controlColorPower = $rows['backCColorPower']; $back_controlController = $rows['backCController']; $back_controlClutchMotor = $rows['backCClutchMotor']; //Drapery $open = $rows['open']; $idle = $rows['idle']; $drapery = $rows['drapery']; $track = $rows['track']; $fullness = $rows['fullness']; if($product){ $lower = strtolower($code); if($type == 'Add On'){ $img = "image/addons/{$lower}.jpg"; } else if($type == 'Market'){ $img = "image/marketing/{$lower}.jpg"; } echo ('
'); echo('' .$shadeID .''); echo('
'); if($submit == 0){ echo('
'); echo(''); echo('
'); } echo('

Quantity

Product

'); echo('

'.$quantity .'

'); echo('

'.$product .'

'); echo('
'); echo('

'); if(($role == 'Manager' || $role == 'Tech' || $role == 'Sunglow') && $hide == 'false'){ if($type != 'Market' && $product != 'Simple Service'){ echo('

Dealer Price: $' .(number_format($quantity * ((100 - $discount) * $price /100),2)) .' – '); } else{ echo('

Dealer Price: $' .number_format($quantity * $price, 2) .' – '); } } echo('MSRP: $' .number_format($quantity * $price, 2) .'

'); } else if($shade == "GEMINI DUAL SHADE" || $shade == "DUAL SQUARE FASCIA"){ echo ('
'); echo('' .$shadeID .''); echo('
'); if($submit == 0){ echo('
'); echo(''); $myShade = strtolower("'$shade'"); echo(''); echo('
'); } echo('

Quantity

Product

Details

Front Fabric

Front Bottom Bar

Front Drive

Back Fabric

Back Bottom Bar

Back Drive

Valance

Mount

Special Instructions

'); echo('

'.$quantity .'

'); echo('

'.$shade .'

'); echo('

' .$width .'", '.$length .'", '.$measure .'

'); echo('

'.$fabric .'

'); echo('

' .$hem .', ' .$hemColor .', ' .$hemCaps .'

'); echo('

' .$controlPosition .', '.$controlSystem .', ' .$controlColorPower .', ' .$controlController . ', ' .$controlClutchMotor .'

'); echo('

'.$back_fabric .'

'); echo('

' .$back_hem .', ' .$back_hemColor .', ' .$back_hemCaps .'

'); echo('

' .$back_controlPosition .', '.$back_controlSystem .', ' .$back_controlColorPower .', ' .$back_controlController . ', ' .$back_controlClutchMotor .'

'); echo('

' .$valance .', ' .$valanceFinish .', ' .$valanceCaps .'

'); echo('

' .$mount .' 

'); echo('

' .$special .'

'); echo('

'); if(($role == 'Manager' || $role == 'Tech' || $role == 'Sunglow') && $hide == 'false'){ echo('

Dealer Price: $' .(number_format($quantity * ((100 - $discount) * $price /100),2)) .' – '); } echo('MSRP: $' .number_format($quantity * $price, 2) .'

'); } else if($shade == "EXOSCREEN"){ echo ('
'); echo('' .$shadeID .''); echo('
'); if($submit == 0){ echo('
'); echo(''); $myShade = strtolower("'$shade'"); echo(''); echo('
'); } echo('

Quantity

Product

Details

Fabric

Drive

Valance

Mount

Special Instructions

'); echo('

'.$quantity .'

'); echo('

'.$shade .'

'); echo('

' .$width .'", '.$length .'", '.$measure .'

'); echo('

'.$fabric .'

'); echo('

' .$controlPosition .', '.$controlSystem .', ' .$controlColorPower .'

'); echo('

' .$valance .', ' .$valanceFinish .'

'); echo('

' .$mount .' 

'); echo('

' .$special .'

'); echo('

'); if(($role == 'Manager' || $role == 'Tech' || $role == 'Sunglow') && $hide == 'false'){ echo('

Dealer Price: $' .(number_format($quantity * ((100 - 25) * $price /100),2)) .' – '); } echo('MSRP: $' .number_format($quantity * $price, 2) .'

'); } else if($shade == "DRAPERY TRACK"){ echo ('
'); echo('' .$shadeID .''); echo('
'); if($submit == 0){ echo('
'); echo(''); $myShade = strtolower("'$shade'"); echo(''); echo('
'); } echo('

Quantity

Product

Details

Drive

Style

Mount

Special Instructions

'); echo('

'.$quantity .'

'); echo('

'.$shade .'

'); echo('

' .$width .'", '.$measure .'

'); echo('

' .$controlPosition .', '.$controlSystem .', ' .$controlColorPower .', ' .$controlController .'

'); echo('

' .$open .', '.$idle .', ' .$drapery .', ' .$track .'

'); echo('

' .$mount .' 

'); echo('

' .$special .'

'); echo('

'); if(($role == 'Manager' || $role == 'Tech' || $role == 'Sunglow') && $hide == 'false'){ echo('

Dealer Price: $' .(number_format($quantity * ((100 - $discount) * $price /100),2)) .' – '); } echo('MSRP: $' .number_format($quantity * $price, 2) .'

'); } else{ //Image Selector if($shade == 'ROLLER SHADE'){ $img = 'image/placeholder/roller.jpg'; } else if($shade == 'INTERLUDE SHADE'){ $img = 'image/placeholder/interlude.jpg'; } else if($shade == 'ILLUSION SHADE'){ $img = 'image/placeholder/illusion.jpg'; } else if($shade == 'VISION SHADE'){ $img = 'image/placeholder/vision2.jpg'; } else if($shade == 'PANEL TRACK'){ $img = 'image/placeholder/panel_track.jpg'; } else if($shade == 'ROMAN SHADE'){ $img = 'image/placeholder/roman.jpg'; } else if($shade == 'FIXED SHADE'){ $img = 'image/placeholder/fixed.jpg'; } else if($shade == 'NIMBUS SKYLIGHT SHADE'){ $img = 'image/placeholder/nimbus.jpg'; } else if($shade == 'ARIA SHADE'){ $img = 'image/placeholder/aria.jpg'; } else if($shade == 'SB ROLLER SHADE'){ $img = 'image/placeholder/sb-rol.jpg'; } else if($shade == 'SB INTERLUDE SHADE'){ $img = 'image/placeholder/sb-int.jpg'; } else if($shade == 'SB ILLUSION SHADE'){ $img = 'image/placeholder/sb-ill.jpg'; } else{ $img = 'image/placeholder/roller.jpg'; } echo ('
'); echo('' .$shadeID .''); echo('
'); if($submit == 0){ echo('
'); echo(''); $myShade = strtolower("'$shade'"); echo(''); echo('
'); } echo('

Quantity

Product

Details

Fabric

Bottom Bar

Drive

Valance

Mount

Roll Type

Lift Assist

Side Channels

Special Instructions

'); echo('

'.$quantity .'

'); echo('

'.$shade .'

'); echo('

' .$width .'", '.$length .'", '.$measure .', '.$sbs .'

'); echo('

'.$fabric .'

'); echo('

' .$hem .', ' .$hemColor .', ' .$hemCaps .'

'); if($controlSystem != null && $controlSystem != "Neo" && $controlSystem != "ZeroGravity"){ echo('

' .$controlPosition .', '.$controlSystem .', ' .$controlColorPower .', ' .$controlController . ', ' .$controlClutchMotor .'

'); } else{ echo('

' .$controlSystem .'

'); } echo('

' .$valance .', ' .$valanceFinish .', ' .$valanceCaps .'

'); echo('

' .$mount .' 

'); echo('

' .$rollType .' 

'); if($liftAssist == 'true' || $liftAssist == 'on'){ echo('

Yes  

'); } else{ echo('

No  

'); } if($sideChannel != '' && $sideChannel != 'None'){ echo('

' .$sideChannel .', ' .$sideChannelMount .', ' .$sideChannelFinish .'

'); } else{ echo('

None

'); } echo('

' .$special .'

'); echo('

'); if(($role == 'Manager' || $role == 'Tech' || $role == 'Sunglow') && $hide == 'false'){ if($drive == 'PROMO - Cord Lift 32 - Somfy 32 [CL32]'){ echo('

Dealer Price: $' .(number_format($quantity * ((100 - 75) * $price /100),2)) .' – '); } else{ echo('

Dealer Price: $' .(number_format($quantity * ((100 - $discount) * $price /100),2)) .' – '); } //echo('

Dealer Price: $' .(number_format($quantity * ((100 - $discount) * $price /100),2)) .' – '); } echo('MSRP: $' .number_format($quantity * $price, 2) .'

'); } } //Simple Service $ssQuery = "SELECT price FROM simple_service where PO = '$PO'"; $result = $mysqli->query($ssQuery); if ($result->num_rows == 1){ while($rows = $result->fetch_assoc()) { $price = $rows['price']; } ?>
Simple Service

Quantity

Product

1

Simple Service

MSRP: $

Dealer Price: $

query($exoQuery); if ($result->num_rows == 1){ while($rows = $result->fetch_assoc()) { $exoQ = $rows['totalQuantity']; } if($exoQ >= 1) { if($exoQ > 2){ $exoP = ($exoQ - 2) * 100 + 500; } else{ $exoP = 500; } ?>
ExoScreen Install

Quantity

Product

1

ExoScreen Install

MSRP:$

Dealer Price: $


Dealer Price:

$ 0.00

'); } ?>
MSRP:

$ 0.00

(+Tax & Shipping)