<?php
session_start();

/* if($_SESSION["login"]!="True")
  {
  header('Location:./index.php');
  } */




/* if($_SESSION["login"]!="True")
  {
  header('Location:./index.php');
  } */




require_once("config.inc.php");
require_once("DBConnector1.php");
$db = new DBConnector();

/* $sql="select * from s_mas1";
  $result =$db->RunQuery($sql);
  while($row = mysqli_fetch_array($result)){
  $sql1="update s_mas set QTYINHAND_STORES=".$row["QTYINHAND_STORES"]." where STK_NO='".$row['STK_NO']."'";
  $result1 =$db->RunQuery($sql1);
  }
  echo "ok"; */
$_SESSION["insert"] = 0;
$_SESSION["update"] = 0;
?>






<link rel="stylesheet" href="css/table.css" type="text/css"/>
<link rel="stylesheet" type="text/css" media="all" href="css/jsDatePick_ltr.min.css" />
<script type="text/javascript" src="js/jsDatePick.min.1.3.js"></script>

<script type="text/javascript" language="javascript" src="js/get_cat_description.js"></script>
<script type="text/javascript" language="javascript" src="js/datepickr.js"></script>



<script language="javascript" type="text/javascript">
<!--
    /****************************************************
     Author: Eric King
     Url: http://redrival.com/eak/index.shtml
     This script is free to use as long as this info is left in
     Featured on Dynamic Drive script library (http://www.dynamicdrive.com)
     ****************************************************/
    var win = null;
    function NewWindow(mypage, myname, w, h, scroll, pos) {
        if (pos == "random") {
            LeftPosition = (screen.width) ? Math.floor(Math.random() * (screen.width - w)) : 100;
            TopPosition = (screen.height) ? Math.floor(Math.random() * ((screen.height - h) - 75)) : 100;
        }
        if (pos == "center") {
            LeftPosition = (screen.width) ? (screen.width - w) / 2 : 100;
            TopPosition = (screen.height) ? (screen.height - h) / 2 : 100;
        } else if ((pos != "center" && pos != "random") || pos == null) {
            LeftPosition = 0;
            TopPosition = 20
        }
            settings = 'width=' + w + ',height=' + h + ',top=' + TopPosition + ',left=' + LeftPosition + ',scrollbars=' + scroll + ',location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=no';
            win = window.open(mypage, myname, settings);
        }
    //    -->
</script>

    <script type="text/j        avascript">
    functio        n open            Win()
    {
        myWindow = window.open('serach_inv.php', '', 'width=200,he            ight=100');
        myWindo        w.focu            s();

    }
        </script>

        <script type                ="text/javascript">
    window.onl                    oad = function () {
                             new JsDatePick({
                            useMode: 2,
                                   target: "dte_dor",
            dat                                eFormat: "%Y-%m-%d"
                    /*selectedDate:{				This is an example of what the full co                                 nfiguration offers.
                     day:5,						For full documentation about these settings please see the full v                                 ersion of the code.
                                           month:9,
                                            year:2006
                                     },
                     year                                 sRange:[1978,2020],
                                                      limitToToday:false,
                     cellC                                 olorScheme:"beige",
                     dat                                 eFormat:"%m-%d-%Y",
                                                  imgPath:"img/",
                                      weekStart                Day:1*/
        })            ;
    };
</script>

</label>

<fieldset>
    <legend>
        <div class="text_f                orheader">Enter Order Detail                s</div>
    </legend>

    <form n                    ame="form1" id="form1">
                <table width="100%" border="0"  class=\"form-matrix-table\">
                        <tr>
                            <td width="10%"><input type="text"  class="label_purchase" value="PR Serial No" disabled="disabled"/></td>
                            <td width="10%"><input type="text" name="invno" id="invno" value="" class="text_purchase3" onkeypress="keyset('searchcust', event);"   onblur="purord_ind('ord')                            ;"  /></td>
                            <td width="10%"><a href="search_materialReq.php?stname=ord" onclick="NewWindow(this.href, 'mywin', '800', '700', 'yes', 'center');
                                                                             return false" onfocus="this.blur()">
                                                       <input type="button" name="searchinv" id="searchinv" value="..." class="btn_purchase1" />
                                                   </a></td>
                                               <td width="10%"><input type="text"  class="label_purchase" value="Date" disabled="disabled"/></td>
                                               <td width="10%"><input type="text" size="20" name="invdate" id="invdate" value="<?php echo date("Y-m-d"); ?>" disabled="disabled" class="text_purchase3"/></td>
                                               <td width="10%"><a href="search_material_req?stname=ord" onclick="NewWindow(this.href, 'mywin', '800', '700', 'yes', 'center');
                        return fals                                                                  e" onfocus="this.blur()"></a></td>
                                                   <td width="10%"><input type="text"  class="label_purchase" value="Schedule Date" disabled="disabled"/></td>
                                                       <td width="10%"><input type="text" size="20" name="dte_shedule" id="dte_shedule" value="" class="text_purchase3"/>
                                                           <script type="text/javascript">
                                                                                  window.onload = function () {
                                                                             new JsDatePick({
                                                                            useMode: 2,
                                                                                       target: "dte_shedule",
                                                                                               dateFormat: "%Y-%m-%d"
                                        /*selectedDate:{        This is an example                                                                                 of what the full configuration offers.
                                         day:5,           For full documentation about these settings pl                                                                                ease see the full version of the code.
                                                                                           month:9,
                                                                                            year:2006
                                                                                     },
                                                                                                          yearsRange:[1978,2020],
                                                                                                      limitToToday:false,
                                                                                                           cellColorScheme:"beige",
                                                                                                         dateFormat:"%m-%d-%Y",
                                                                                                  imgPath:"img/",
                                                                                      weekStartD                                                               ay:1*/
                                                                                   });
                                                                             };
                                                                        </script>
                </td>
                                                           <td width="10%">&nbsp;</td>
                                                           </tr>

                                      <tr>
                                      </tr>

                       <tr>
                            <td width="10%"><input type="text"  class="label_purchase" value="PR Code No" disabled="disabled"/></td>
                            <td width="20%"><input type="text" name="invno" id="req_no" value="" class="text_purchase3"/></td>
                      
                                      
                          
                                                           </tr>


                                                           <tr>
                                                               <td>&nbsp;</td>
                                                               <td colspan="3">&nbsp;</td>
                                                               <td>&nbsp;</td>
                                                               <td>&nbsp;</td>
                                                               <td>&nbsp;</td>
                                                               <td>&nbsp;</td>
                                                               <td>&nbsp;</td>
                                                           </tr>
                                                           <tr>
                                                               <td><input type="text"  class="label_purchase" value="Supplier" disabled/></td>
                                                               <td colspan="3"><input type="text" class="text_purchase1" name="supplier_code" id="supplier_code" onblur="suppno_ind('purord');" onkeypress="keyset('salesrep', event);"/>
                                                                   <input type="text" disabled="disabled"  class="text_purchase2" id="supplier_name" name="supplier_name" />
                                                                   <a href="" onClick="NewWindow('serach_supplier.php?stname=purord', 'mywin', '800', '700', 'yes', 'center');
                            return false" onFocus="this.blur()">
                                                                       <input type="button" name="searchcust" id="searchcust" value="..."  class="btn_purchase">
                                                                   </a></td>
                                                               <td><input type="text"  class="label_purchase" value="LC No" disabled/></td>
                                                               <td><input type="text" size="15" name="lc_no" id="lc_no" value=""  class="text_purchase3" /></td>
                                                               <td><input type="text"  class="label_purchase" value="Pending" disabled/></td>

                                                               <td><input type="checkbox" id="chkPend" name="chkPend" disabled/></td>
                                                               <td>&nbsp;</td>
                                                           </tr>
                                                           <tr>
                                                               <td><input type="text"  class="label_purchase" value="Address" disabled/></td>
                                                               <td colspan="2"><input type="text"  class="text_purchase4"  disabled="disabled" id="address" name="address" /></td>
                                                               <td>&nbsp;</td>
                                                               <td><input type="text"  class="label_purchase" value="PI No" disabled="disabled"/></td>
                                                               <td><input type="text" size="15" name="pi_no" id="pi_no" value=""  class="text_purchase3" /></td>
                                                               <td><input type="text"  class="label_purchase" value="ISO No" disabled/></td>
                                                               <td><input type="text"  class="text_purchase4"  id="isoNo" name="isono" /></td>
                                                               <td>&nbsp;</td>
                                                               <td>&nbsp;</td>

                                                               <td>&nbsp;</td>
                                                           </tr>
                                                           <tr>
                                                               <td>&nbsp;</td>
                                                               <td>&nbsp;</td>
                                                               <td>&nbsp;</td>
                                                               <td>&nbsp;</td>
                                                               <td><label>
                                                                       <input type="text"  class="label_purchase" value="Department" disabled="disabled"/>
                                                                   </label></td>
                                                               <td><label>
                                                                       <select name="department" id="department" onkeypress="keyset('brand', event);" onchange="setord();" class="text_purchase3">
                                                                           <?php
                                                                           $sql = "select * from s_stomas order by CODE";
                                                                           $result = $db->RunQuery($sql);
                                                                           while ($row = mysqli_fetch_array($result)) {
                                                                               echo "<option value='" . $row["CODE"] . "'>" . $row["CODE"] . " " . $row["DESCRIPTION"] . "</option>";
                                                                           }
                                                                           ?>
                                                                       </select>
                                                                   </label></td>
                                                               <td><input type="text"  class="label_purchase" value="Purchasing Group" disabled/></td>
                                                               <td><input type="text"  class="text_purchase4"  id="purchasingGroup" name="purchasingGroup" /></td>
                                                               <td><label></label></td>
                                                               <td></td>
                                                               <td>&nbsp;</td>
                                                           </tr>
                                                           <tr>
                                                               <td height="41"><input type="text"  class="label_purchase" value="Order By" disabled="disabled"/></td>
                                                               <td><select name="salesrep" id="salesrep" onkeypress="keyset('dte_dor', event);" onchange="setord();" class="text_purchase3">
                                                                <option value="<?php echo $_SESSION["username"]; ?>"><?php echo $_SESSION["UserName"]; ?></option>
                                                                       <?php
                                                                       // $sql = "select * from s_salrep where cancel='1' order by REPCODE";
                                                                       // $result = $db->RunQuery($sql);
                                                                       // while ($row = mysqli_fetch_array($result)) {
                                                                       //     echo "<option value='" . $row["REPCODE"] . "'>" . $row["REPCODE"] . " " . $row["Name"] . "</option>";
                                                                       // }var_dump($_SESSION);

                                                                         $sql = "select * from user_mast";
                                                                       $result = $db->RunQuery($sql);
                                                                       while ($row = mysqli_fetch_array($result)) {
                                                                           echo "<option value='" . $row["user_name"] . "'>" . $row["user_name"] . " " . $row["Name"] . "</option>";
                                                                       }
                                                                       ?>
                                                                   </select></td>
                                                               <td>&nbsp;</td>
                                                               <td>&nbsp;</td>
                                                               <td><input type="text"  class="label_purchase" value="Brand" disabled="disabled"/></td>
                                                               <td><select name="brand" id="brand" onkeypress="keyset('searchitem', event);" class="text_purchase3"  onchange="assignbrandsession();">
                                                                       <?php
                                                                       $sql = "select * from brand_mas order by barnd_name";
                                                                       $result = $db->RunQuery($sql);
                                                                       while ($row = mysqli_fetch_array($result)) {
                                                                           echo "<option value='" . $row["barnd_name"] . "'>" . $row["barnd_name"] . "</option>";
                                                                       }
                                                                       ?>
                                                                   </select></td>
                                                               <td><input type="text"  class="label_purchase" value="VAT No" disabled/></td>
                                                               <td><input type="text"  class="text_purchase4"  id="vatNo" name="vatNo" /></td>
                                                               <td>&nbsp;</td>
                                                               <td>&nbsp;</td>
                                                           </tr>
                                                           <tr>
                                                               <td><input type="text"  class="label_purchase" value="Remark" disabled="disabled"/></td>
                                                               <td colspan="2"><input type="text"  class="text_purchase4"  id="remarks" name="remarks" /></td>
                                                               <td>&nbsp;</td>
                                                               <td><input type="text"  class="label_purchase" value="Service" disabled="disabled"/></td>
                                                               <td >
                                                                   <input type="radio" name="service" value="service" id="service"><b>Service</b><br>
                                                                   <input type="radio" name="service" value="service"><b> Material</b><br>
                                                               </td>
                                                               <td><input type="text"  class="label_purchase" value="PR No" disabled/></td>
                                                               <td><input type="text"  class="text_purchase4"  id="prNo"  /></td>
                                                               <td>&nbsp;</td>
                                                               <td>&nbsp;</td>
                                                               <td>&nbsp;</td>
                                                           </tr>

                                                           <tr>
                                                               <td><input type="text"  class="label_purchase" value="Reason" disabled="disabled"/></td>
                                                               <td colspan="2"><input type="text"  class="text_purchase4"  id="reason" name="reason" /></td>
                                                               <td>&nbsp;</td>
                                                               
                                                               
                                                           </tr>
                                                           </table>


                                                           <br/>
                                                           <fieldset>

                                                               <legend><div class="text_forheader">Item Details</div></legend>

                                                               <table width="84%" border="0">
                                                                   <tr>
                                                                       <td width="10%"><span class="style1">
                                                                               <input type="text"  class="label_purchase" value="Code" disabled/>
                                                                           </span></td>
                                                                       <td  width="40%"><span class="style1">
                                                                               <input type="text"  class="label_purchase" value="Description" disabled/>
                                                                           </span></td>
                                                                           <td  width="10%"><span class="style1">
                                                                                   <input type="text"  class="label_purchase" value="Part No" disabled/>
                                                                               </span></td>
                                                                               <td  width="10%"><span class="style1">
                                                                                       <input type="text"  class="label_purchase" value="UOM" disabled/>
                                                                                   </span></td>
                                                                       <td  width="10%"><span class="style1">
                                                                               <input type="text"  class="label_purchase" value="Qty" disabled/>
                                                                           </span></td>
                                                                       <td  width="10%">&nbsp;</td>
                                                                   </tr>
                                                                   <tr>
                                                                       <td><font color="#FFFFFF">
                                                                           <div id="test"><font color="#FFFFFF">
                                                                               <input type="text"  class="text_purchase3" name="itemd_hidden" id="itemd_hidden" size="10"  onkeypress="keyset('qty', event);"  onblur="itno_ind();"    />
                                                                               </font></div>  </font></td>
                                                                       <td><font color="#FFFFFF">
                                                                           <input type="text"  class="text_purchase6" size="40" id="itemd" name="itemd" onkeypress="keyset('rate', event);" />
                                                                           </font><a href="serach_item.php?stname=pur_ord" onClick="NewWindow(this.href, 'mywin', '1000', '700', 'yes', 'center');
                                                                            return false" onFocus="this.blur()">
                                                                            <input type="button" name="searchitem" id="searchitem" value="..." class="btn_purchase" ></a></td>
                                                                            <td><font color="#FFFFFF">
                                                                                <input type="text" size="15" name="partno" id="partno" value="" class="text_purchase3" onkeypress="keyset('qty', event);"/>
                                                                                </font></td>
                                                                                <td><font color="#FFFFFF">
                                                                                    <input type="text" size="15" name="uom" id="uom" value=""  class="text_purchase3" onkeypress="keyset('qty', event);"/>
                                                                                    </font></td>
                                                                       <td><font color="#FFFFFF">
                                                                           <input type="text" size="15" name="qty" id="qty" value="" class="text_purchase3"  onKeyPress="keyset('additem_tmp', event);"/>
                                                                           </font></td>
                                                                       <td><input type="button" name="additem_tmp" id="additem_tmp" value="Add" onClick="add_tmp();" class="btn_purchase1"></td>
                                                                   </tr>
                                                                   <tr>
                                                                       <td colspan="4">
                                                                           <div class="CSSTableGenerator" id="itemdetails" >
                                                                               <table>
                                                                                   <tr>
                                                                                       <td width="10%"   background="images/headingbg.gif" ><font color="#FFFFFF">Code</font></td>
                                                                                       <td width="40%"  background="images/headingbg.gif"><font color="#FFFFFF">Description</font></td>
                                                                                       <td width="10%"  background="images/headingbg.gif"><font color="#FFFFFF">Part No</font></td>
                                                                                       <td width="10%"  background="images/headingbg.gif"><font color="#FFFFFF">Qty</font></td>
                                                                                   </tr>
                                                                               </table>   </div>                                                 		</td>
                                                                   </tr>

                                                                   <tr>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                   </tr>

                                                                   <tr>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                   </tr>
                                                                   <tr>
                                                                       <td colspan="2" rowspan="5"><div id="storgrid"></div></td>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                   </tr>
                                                                   <tr>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                   </tr>
                                                                   <tr>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                   </tr>
                                                                   <tr>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                   </tr>
                                                                   <tr>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                       <td>&nbsp;</td>
                                                                   </tr>
                                                               </table>


                                                               </form>

                                                           </fieldset>

                                                           <table width="765" border="0" cellpadding="0">
                                                               <tr>
                                                                   <th height="189" colspan="5" align="left" nowrap="nowrap">
                                                                       <div align="left">


                                                                           <script>
                                                                               new_inv();
                                                                           </script>
