<?php 

$cust_id = $_SESSION['id'];

$table_name = $_SESSION['db_prefix']."_direct_delivery_lines_temp";
$line_query = "SELECT *  FROM $table_name WHERE  user_name =  '".$_SESSION['username']."' AND store_item_id>0";
$line_result = mySQL_query($line_query);
$line_num = mysql_num_rows($line_result);

?>
</head>
<?php include('../include/wait.php') ?>

<body onLoad="MM_showHideLayers('wait','','hide')" onFocus="MM_showHideLayers('wait','','hide');"  onBlur="MM_showHideLayers('wait','','hide');">

<div class="wizard_page_middle_frame">
<div class="wizard_frame">
<?php 
include('../include/customer_block.php');
echo '<br>';
?>
</div>

<form id="form1" method="get" action="direct_deliveryWiz6.php" >
<div class="wizard_frame"><br>
<br>
<table width="650" id="table_display" >
          <tr>
            <td height="26" colspan="2" align="left" valign="top">Item</td>
            <td width="136" align="left" valign="top">Group</td>
            <td width="45" align="left" valign="top">Unit</td>
            <td width="47" align="left" valign="top">quantity</td>
            <td width="56" align="left" valign="top">unit price</td>
            <td width="62" align="left" valign="top">total</td>
            </tr>
          <?php
				$i=0;
				$sub_tot=0;
				$a5_total=0;
				 while ($i<$line_num){
					 $a0 = mysql_result($line_result, $i, "order_line_id");
					 $a1 = mysql_result($line_result, $i, "store_item_id");
					 $table_name = $_SESSION['db_prefix']."_store_items";
						$item_query = "SELECT item_name, unit, subCategory, register FROM $table_name WHERE store_item_id = '".$a1."' ";
						$item_result = mySQL_query($item_query);
						$a1a = mysql_result($item_result, 0, "item_name");
						$a3a = mysql_result($item_result, 0, "unit");
						$a4a = mysql_result($item_result, 0, "subCategory");
						$register = mysql_result($item_result, 0, "register");
					 $a2 = mysql_result($line_result, $i, "quantity");
					 $a3 = mysql_result($line_result, $i, "price");
					 
					$a5=$a2*$a3;
					$a5_total=$a5_total+$a5;
					 
				 ?>
          <tr>
            <td colspan="2" valign="top"><?php echo $a1a ?>
              <?php if ($register=='yes') {
	$table_name = $_SESSION['db_prefix']."_store_register";
    $position_query = "SELECT serial_number FROM $table_name WHERE store_item_id = '".$a1."' AND job_card IS NULL ORDER BY serial_number ASC";
	$arrId2 = array ();
	$arrName2 = array ();
	$position_result = execsql($position_query);
	if ($position_result!="") {
	$position_num = mysql_num_rows($position_result);
	$b = 0;
	while ($b < $position_num) {
		$arrId2[$b] = mysql_result($position_result, $b, "serial_number");
		$arrName2[$b] = mysql_result($position_result, $b, "serial_number");
		$b++;
	}
	}
	}
	?>
              <div id='select_div' style="display:<?php if (($register=='yes') AND ($quantity>0)) {?> block; <?php } else { ?> none; <?php } ?>"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img src="../images/exclamation_mark_red_small.png" width="10" height="16">Serial no:
                <select name="serial_select<?php echo $i ?>"  id="serial_select<?php echo $i ?>" class="select120"  >
                  <?php if (($register=='yes') AND ($quantity>0)) {?>
                  <option value="  " selected="selected"> </option>
                  <?php } else { ?>
                  <option value="." selected="selected">.</option>
                  <?php } ?>
                  <?php
        	for ($j = 0; $j < count($arrId2); $j++) {
    		echo "<option value=" . "\"" . $arrId2[$j] . "\"" . ">" . $arrName2[$j] . "</option>";
	}
?>
                </select>
              </div>
            <input type="hidden" name="register_text<?php echo $i ?>" id="register_text<?php echo $i ?>" value="<?php if ($register=='yes') {echo 'yes';} else {echo 'no';} ?>"></td>
            <td valign="top"><?php echo $a4a ?></td>
            <td valign="top"><?php echo $a3a ?></td>
            <td valign="top"><?php echo $a2 ?></td>
            <td align="right" valign="top"><?php echo $a3. "  /" .$a3a ?>&nbsp;</td>
            <td align="right" valign="top"><?php echo number_format($a5, 2, '.', ',')?></td>
            </tr>
          <?php 
			   // $a6_total=$a6_total+$a6;
				$i++;
				 }
				 ?>
          <tr>
            <td colspan="2" align="left" valign="top">&nbsp;</td>
            <td align="left" valign="top">&nbsp;</td>
            <td align="left" valign="top">&nbsp;</td>
            <td align="left" valign="top">&nbsp;</td>
            <td align="left" valign="top">Total:</td>
            <td align="right" valign="top"><?php echo number_format($a5_total, 2, '.', ',') ?></td>
            </tr>
          </table>
</div>
<div class="wizard_frame">
      <input name="s" type="hidden" id="s" value="4" />
          <input name="p" type="hidden" id="p" value="4" />
          <label class="label_std">If you want to make changes use the 'Prev' button to go back. <br />
            Click 'New' to make a new entry or to finish the wizard click 'Finish'.</label>
        </div>
        <div class="wizard_frame">
      <table width="590" height="50" align="center" id="table_button_bar">
          <tr>
            <td width="117"><input type="button" name="lastprev_button" class="imagebutton" value="Prev" onClick="needToConfirm = false;   MM_showHideLayers('wait','','show'); MM_goToURL('parent','direct_deliveryWizbase.php?s=&amp;p=2');return document.MM_returnValue" /></td>
            <td width="115">&nbsp;</td>
            <td width="99"><input name="cancelbutton" type="button" class="imagebutton" id="cancelbutton" onClick="javascript:cancel_confirmation(1, '../store/store_main.php'); needToConfirm = false;" value="Cancel" /></td>
            <td width="125"><input type="submit" name="new_button" class="imagebutton" id="new_button" value="New" onClick="needToConfirm = false; MM_showHideLayers('wait','','show');" /></td>
            <td width="110"><input  name="finish_button" type="submit" class="imagebutton" id="finish_button" value="Finish" onClick="needToConfirm = false; MM_showHideLayers('wait','','show');"  /></td>
          </tr>
        </table>
        </div>
  
  
</form>
<script language="JavaScript" type="text/javascript" xml:space="preserve">
  var frmvalidator  = new Validator("form1");
  frmvalidator.EnableMsgsTogether();
  
  for (i = 0; i < 50; i++) {
  frmvalidator.addValidation("serial_select"+i,"req","- serial no on line "+(i+1)+".");
  }
</script>
</div>

