<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php
include('../include/session.php');
include ("../navigation/header.php");
include ("../navigation/store_sidebar.php");

  $s = $_GET['s'];
  $p = $_GET['p'];
  $_SESSION['p']=$p;
  $_SESSION['s']=$s;
  
  
  if (isset($_GET['prev_button']) )
     {
     $_SESSION['p']= $_SESSION['p']-1;
     }
     
  if (isset($_GET['next_button']) )
    {
    $_SESSION['p']=$_SESSION['p']+1;
    }
  
    
  
  if ($s==1) {
      $_SESSION['emp_id'] = $_GET['emp_id_select'];  
       $_SESSION['issue_date'] = $_GET['issue_date'];
    $_SESSION['authorised_by' ]= $_GET['authorised_by_select'];  
    $_SESSION['issued_by'] = $_GET['issued_by_select'];    
             
    $table_name = $_SESSION['db_prefix']."_employee";
    $name_query = "SELECT emp_first_name, emp_last_name FROM $table_name WHERE emp_id = '".$_SESSION['emp_id']."' ";
    $name_result = mySQL_query($name_query);
    $_SESSION['employee_name'] = mysql_result($name_result, 0, "emp_first_name").' '.mysql_result($name_result, 0, "emp_last_name");
  };
  
  if($s==2) {
    $table_name = $_SESSION['db_prefix']."_employee_supply_lines_temp";
    $delete_query = "DELETE FROM $table_name WHERE  user_name = '".$_SESSION['username']."'   "; 
    execsql($delete_query);
    
    $_SESSION['stock_error']=0;
    
$line_num = $_GET['line_num'];
$i=0;
while ($i<$line_num) {
if (isset($_GET['line_checkbox'.$i])) {
$_SESSION['category'.$i] =  $_GET['category'.$i];
$_SESSION['index'.$i] =  $_GET['index'.$i];
$store_item_id = $_GET['store_item_id'.$i];  

        $table_name = $_SESSION['db_prefix']."_store_items";
        $name_query = "SELECT item_name, price, quantity FROM $table_name WHERE store_item_id = '".$store_item_id."'  ";
        $name_result = mySQL_query($name_query);
        $_SESSION['store_item_name'] = mysql_result($name_result, 0, "item_name");
        $_SESSION['store_item_id'] = $store_item_id;
        $price = mysql_result($name_result, 0, "price");
        $stock = mysql_result($name_result, 0, "quantity");
        
$quantity = $_GET['quantity_text'.$i];

if ($quantity>$stock)  {
$table_name = $_SESSION['db_prefix']."_employee_supply_lines_temp";
$issued_query = "INSERT INTO $table_name ( store_item_id, quantity,  price,  error, user_name) VALUES ('".$store_item_id."','".$stock."', '".$price."', '1', '".$_SESSION['username']."' ) ";
execsql($issued_query);

$_SESSION['stock_error']=1;
}
else {
    $table_name = $_SESSION['db_prefix']."_employee_supply_lines_temp";
  $issued_query = "INSERT INTO $table_name ( store_item_id, quantity,  price,  error, user_name) VALUES ('".$store_item_id."','".$quantity."', '".$price."', '0', '".$_SESSION['username']."' ) ";
  execsql($issued_query);  
}

};
$i++;
}

if ($_SESSION['stock_error']==1) { ?>
<script language="javascript" type="text/javascript">
      window.location="supply_employeeWizbase.php?p=2&s=";
</script>
<?php }
    };
  

  ?>

<!--style sheets-->
<link rel="stylesheet" type="text/css" href="../css/wizard.css" />
<link href="../css/wait.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="../window/dhtmlwindow.css" type="text/css" />
<link rel="stylesheet" href="../window/modal.css" type="text/css" />

<!--jscript-->
<script type="text/javascript" src="../window/dhtmlwindow.js"></script>
<script type="text/javascript" src="../window/modal.js"></script>
<script language="JavaScript" src="../jscript/gen_validatorv4.js"  type="text/javascript" xml:space="preserve"></script>
<script type="text/javascript" src="../jscript/jquery.1.4.2.js"></script>
<script language="JavaScript" src="../jscript/cancel_confirmation.js"  type="text/javascript"></script>
<script language="JavaScript" src="../jscript/confirm_exit.js"  type="text/javascript"></script>
<script language="JavaScript" src="../jscript/show_hide_layers.js"  type="text/javascript"></script>
<script language="JavaScript" src="../jscript/alert_message.js"  type="text/javascript"></script>


<div class="main_frame">
<div class="page_head_frame">
          <label class="label_page_head">Supply employee</label>
          &nbsp;&nbsp;
          <label class="label_page_head_2"><?php echo $_SESSION['employee_name']; ?></label>
        </div>
        <br /><br /><br /><br />
        <table >
       <tr>
        <td >
        <div class="wizard_paging_frame">
        <table align="left">
          <tr>
            <td><?php if ($_SESSION['p']==1) { ?>
              <div class="active_step_frame">
                <div class="active_step_head_label">&nbsp;1</div></div>
                <div class="active_step_label">
                  Employee</div>
              <?php } else { ?>
              <div class="de_active_step_frame">
                <div class="de_active_step_head_label">&nbsp;1</div></div>
                <div class="de_active_step_label">
                  Employee</div>
              <?php } ?></td>
            <td><?php if ($_SESSION['p']==2) { ?>
              <div class="active_step_frame">
                <div class="active_step_head_label">&nbsp;2</div></div>
                <div class="active_step_label">
                  Items</div>
             <?php } else { ?>
              <div class="de_active_step_frame">
                <div class="de_active_step_head_label">&nbsp;2</div></div>
                <div class="de_active_step_label">
                  Items</div>
            <?php } ?></td>
            <td><?php if ($_SESSION['p']==3) { ?>
              <div class="active_step_frame">
                <div class="active_step_head_label">&nbsp;3</div></div>
                <div class="active_step_label">
                  Finish</div>
             <?php } else { ?>
              <div class="de_active_step_frame">
                <div class="de_active_step_head_label">&nbsp;3</div></div>
                <div class="de_active_step_label">
                  Finish</div>
              <?php } ?></td>
          </tr>
        </table>
        </div>
        </td>
       </tr>
    <tr>
    <td>
        
        <?php 
  if ($_SESSION['p']==1) { include("supply_employeeWiz1.php"); }
  if ($_SESSION['p']==2) { include("supply_employeeWiz2.php"); }
  if ($_SESSION['p']==3) { include("supply_employeeWiz4.php"); }
  
    ?></td>
    </tr>
  </table>
</div>


<?php include ('../navigation/side_bar.php'); ?>


