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())
{
$reid = $rows['reid'];
$quantity = $rows['quantity'];
$product = $rows['product'];
$shade = $rows['shade'];
$shadeID = $rows['shadeID'];
$fabric = $rows['fabric'];
$controlSystem = $rows['controlSystem'];
$drive = $rows['controlClutchMotor'];
$valance = $rows['valance'];
$price = $rows['price'];
//$code = $rows['code'];
//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'];
$discountQuery = "SELECT discount FROM quotes WHERE `reid` = '$reid'";
$resultSet = $conn->query($discountQuery);
$row_cnt = $resultSet->num_rows;
if($row_cnt == 1){
while($rows = $resultSet->fetch_assoc()){
$percent = ($rows['discount']);
}
}
else{
$percent = 0;
}
?>
$back_fabric");
}
else{
echo("—");
}
?>
$back_controlSystem");
}
else if($back_controlSystem == 'Motor'){
echo ("
$back_controlClutchMotor");
}
else if($back_controlSystem != null){
echo("
$back_controlSystem");
}
else{
echo("—");
}
?>
%
query($ssQuery);
if ($result->num_rows == 1){
while($rows = $result->fetch_assoc())
{
$price = $rows['price'];
}
?>
query($discountQuery);
$row_cnt = $resultSet->num_rows;
if($row_cnt == 1){
while($rows = $resultSet->fetch_assoc()){
$percent = ($rows['discount']);
}
}
else{
$percent = 0;
}
?>
%
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;
}
?>
query($discountQuery);
$row_cnt = $resultSet->num_rows;
if($row_cnt == 1){
while($rows = $resultSet->fetch_assoc()){
$percent = ($rows['discount']);
}
}
else{
$percent = 0;
}
?>
%
;?>.jpg){kind=logo}