<?
session_start();
include("opendb.php");
include("test.php");
$ker=mysqli_query($db,"select brstate from branch where brcode='$brcode'");
$kar=mysqli_fetch_array($ker);
$ordres=mysqli_query($db,"select max(orderno) from purorder_spare where brcode='$brcode'");
$ordrow=mysqli_fetch_row($ordres);
$ordnumber=$ordrow[0]+1;
?>
<BASE TARGET=main22>
<title>Demo</title>
<link rel="stylesheet" href="style.css" type="text/css" />
<script type="text/javascript" src="scripts/jquery-latest.js"></script>
<link type="text/css" href="includes/style1.css" rel="stylesheet" />
<link type="text/css" href="css/form.css" rel="stylesheet" />
<script type="text/javascript">
        $(function() {
          if ($.browser.msie && $.browser.version.substr(0,1)<7)
          {
			$('li').has('ul').mouseover(function(){
				$(this).children('ul').show();
				}).mouseout(function(){
				$(this).children('ul').hide();
				})
          }
        });        
    </script>
<script>
function valid()
{
}
</script>
<body background="back_ground.jpg">
<?php include('logo2.php'); ?>
<?php include('includes/top.php'); ?>
<form name='f1' action='<?print $PHP_SELF?>' onSubmit="return valid()" method='post'> 

<br>
<table class="container"><tr><td>
<font style="font-family: 'Trebuchet MS',Verdana,Helvetica,sans-serif; font-size:15px;">  &nbsp;&nbsp;Service >> <a href="service_menu.php" style="text-decoration:none;">Service</a> >> Part Master</font>
<br>
<script>
var pna=[];
var hand=[];
var price=[];
var disc=[];
function getname()
{
 if(document.f1.partcode.selectedIndex<=0)
 {
 document.f1.prtname.value="";
 document.f1.price.value="";
 //document.f1.discount.value="";
 document.f1.hand.value="";
 }
 else{
 document.f1.prtname.value=pna[document.f1.partcode.selectedIndex];
 document.f1.price.value=price[document.f1.partcode.selectedIndex];
 document.f1.discount.value=disc[document.f1.partcode.selectedIndex];
 document.f1.hand.value=hand[document.f1.partcode.selectedIndex];

var act=parseFloat(document.f1.price.value)*parseFloat(document.f1.qty.value);
 var hnd=parseFloat(act)*document.f1.hand.value/100;

 var act1=act*parseFloat(document.f1.discount.value)/100;

 document.f1.aprice.value=parseFloat(act+hnd-act1).toFixed(2);
 act=document.f1.aprice.value;

 var act2=parseFloat(document.f1.aprice.value);
  var cst=parseFloat(act2)*document.f1.cst.value/100;
  var gtot=parseFloat(act2+cst).toFixed(2);
  document.f1.tot.value=gtot;
 }
}
function calcamt()
{
var act=parseFloat(document.f1.price.value)*parseFloat(document.f1.qty.value);
 var hnd=parseFloat(act)*document.f1.hand.value/100;

 var act1=act*parseFloat(document.f1.discount.value)/100;

 document.f1.aprice.value=parseFloat(act+hnd-act1).toFixed(2);
 act=document.f1.aprice.value;

 var act2=parseFloat(document.f1.aprice.value);
  var cst=parseFloat(act2)*document.f1.cst.value/100;
  var gtot=parseFloat(act2+cst).toFixed(2);
  document.f1.tot.value=gtot;
}
function valid()
{
 if(document.f1.partcode.selectedIndex<=0)
 {
  alert('Invalid Item code');
  return false;
 }
/*
var x=document.getElementById("mselect")
 document.f1.partcode1.value=x.options[x.selectedIndex].text
x.remove(x.selectedIndex)
*/
}
</script>
<body bgcolor='ivory'>
<center>
<input type=hidden name='partcode1'>
<table>
<th colspan=10><h3>ITEM PURCHASE ORDER (<?print $ordnumber?>)</h3></th>
<tr>
<td>Part Code</td><td><select name='partcode' id='mselect' onChange=getname();><option></option>
<?
$i=1;
$re=mysqli_query($db,"select * from newpartmaster order by partcode");
while($row=mysqli_fetch_array($re))
{
 print "<option value='$row[0]'>$row[0]</option>";
 print "\n<script> pna[$i]='$row[partname]'; hand[$i]='spares';</script>";
if($kar[0]=='Kerala') 
{  
$disres=mysqli_query($db,"select lstprice,discount from spareprmast where partcode='$row[0]' and brcode='ERA153' order by effectfrom desc");
$disrow=mysqli_fetch_array($disres);
}
else
{
$disres=mysqli_query($db,"select lstprice,discount from spareprmast where partcode='$row[0]' and brcode='BAN682' order by effectfrom desc");
$disrow=mysqli_fetch_array($disres);
}


 print "<script>price[$i]='$disrow[0]'; </script>";
 print "<script>disc[$i]='spares'; </script>";
 $i++;
}


$re=mysqli_query($db,"select * from labourmaster order by labname");
while($row=mysqli_fetch_array($re))
{
 print "<option value='$row[3]'>$row[3]</option>";
 print "\n<script> pna[$i]='$row[3]'; hand[$i]='labour';</script>";
 

$disres=mysqli_query($db,"select hrrate,totallcv from labourmaster where labname='$row[3]'");
$disrow=mysqli_fetch_array($disres);



 print "<script>price[$i]='$disrow[0]'; </script>";
 print "<script>disc[$i]='spares'; </script>";
 $i++;
}







?>
</select></td><td>Part Name </td><td COLSPAN=3><input type=text readonly  name='prtname' size=30></td></tr>
<tr><td>Qty</td><td><input type=text name='qty' size=3 value='1' onChange='calcamt()'></td>
  <td>Price </td><td><input type=text  name='price' size=10></td>
  <td>Disc% </td><td><select name='discount' onChange='calcamt()'> 
    <option value='19.49'>19.49</option>
    <option value='14.63'>14.63</option>
    <option value='0'>0</option>
</select>


   Act Price <input type=text name='aprice' size=10>
</td></tr>
<tr><td>Hand Chrg%</td><td><input type=text name='hand' size=6 value='2.5'></td>
<?
 $cstres=mysqli_query($db,"select tax from taxmaster where type='cst'");
  $cstrow=mysqli_fetch_row($cstres);
?>
<td>CST%</td><td><input type=text name='cst'  size=6 value='<?print $cstrow[0]?>'></td>
<td>Total</td><td><input type=text name='tot'   size=16></td></tr>
<tr><td colspan=6 align=center bgcolor='steelblue'><input type=submit value='Add' name='add'></td></tr>
</table>
</form>
<?
if($save)
{
if(strlen($brcode)<=0)
{
 print "<script> alert('Session timed out'); parent.document.location='../index.html'; </script>";
 return;
}
$tbl='suptmp'.$brcode.$user;
$re=mysqli_query($db,"select * from $tbl");
$dt=date("Y-m-d");
$pres=mysqli_query($db,"select max(orderno) from purorder_spare where brcode='$brcode'");
$prow=mysqli_fetch_row($pres);
if($prow[0]<=0)
 $orderno=1;
else
 $orderno=($prow[0]+1);

while($ro=mysqli_fetch_array($re))
{
 $sql="insert into purorder_spare (partcode,partname,qty,date,orderto,brcode,orderno) values('$ro[0]','$ro[1]','$ro[2]','$dt','$to','$brcode','$orderno')";
 mysqli_query($db,$sql) or die(mysqli_error($db));

}
log_entry($brcode,$user,$REMOTE_ADDR,"Purchase Order Saved:$orderno,branch:$brcode");

mysqli_query($db,"delete from $tbl");
print "<b>Purchase order ".$orderno." has been saved</B>";
}
?>
<link rel="stylesheet" href="../style.css" type="text/css" />
<style>
	tr{background-color:white}
	th{background-color:steelblue;color:white}
</style>
<center>
<form action='<?print $PHP_SELF?>' onSubmit='return valid()'>
<table border=1 width=100%>
<tr><td><center>Order To : 
<?
$brres=mysqli_query($db,"select brcode,brname from branch where brcode!='$brcode' order by brname");
print "<select name='to'>";
 while($brrow=mysqli_fetch_array($brres))
 {
   print "<option value='$brrow[0]'>$brrow[1]</option>";
 }
$brres1=mysqli_query($db,"select distinct code,supname from sup_master order by supname");
 while($brrow1=mysqli_fetch_array($brres1))
 {
   print "<option value='$brrow1[0]'>$brrow1[1]</option>";
 }

print "</select>";
?>
&nbsp;
<input type=submit value='Save & Print' name='save'>
</td></tr></table>
</form>

<br>
<?
$tbl='suptmp'.$brcode.$user;
$sql="create table $tbl (partcode varchar(100),prtname varchar(200), qty double(14,2), brcode varchar(100))";

//$sql="create table $tbl (partcode varchar(100),prtname varchar(200), qty double(14,2), price double(14,2), discount double(14,2), hand double(14,2), cst double(14,2), tot double(14,2), brcode varchar(100))";
mysqli_query($db,$sql);


if($add)
{
  $res1=mysqli_query($db,"select * from $tbl where partcode='$partcode'");
  if(mysqli_num_rows($res1)>0)
  {
    print "<script> alert('Duplicate Entry')</script>";
    //return;
  }

 $sql="insert into $tbl values('$partcode','$prtname','$qty', '$brcode')";
 mysqli_query($db,$sql);
}

$res=mysqli_query($db,"select * from $tbl");
if(mysqli_num_rows($res)>0)
{
  $i=1;
  print "<table border=1 cellpadding=3> <th>No <th>Item Code <th>Item Name <th>Qty <th> Del";
  while($row=mysqli_fetch_array($res))
  {
    print "\n<form action='$PHP_SELF'> <input type=hidden name='partcode' value='$row[0]'><tr><td>";
    print $i++."</td><td>$row[0]</td><td>$row[1]</td><td>$row[2]</td>";
    print "<td><input type=submit value='Del' name='Del'></td></tr></form>";
  }
 print "</table>";
}

if($Del)
{
 mysqli_query($db,"delete from $tbl where partcode='$partcode'")or die('err'.mysqli_error($db));
}
?>
<script>
 function valid()
 {
  if(confirm('Do you want to save?'))
   return true;
  else
    return false;
 }
</script>

