<?php include ("../../include/dbconnect.php");
  
?>
<title>Balance Sheet  Printing Printing</title>
<style type="text/css">
<!--
.style1 {font-family: Arial, Helvetica, sans-serif}
-->
</style>
<body background="../../images/fibermat.gif">
<center>
<table cellpadding=0 cellspacing=4 width=590>
<tr>
    <td style="padding:3px;" colspan=2 bgcolor="#93BEE2"><font class="Wf style1"><b>Balance Sheet Printing</b></font></td>
</tr><tr valign="top"><td colspan=2>
<font class="Wf">&nbsp;</font>
</td>
</tr>

<form method="POST" name="regform" action="balance_print.php" target="_blank">

<tr><td ><div align="right"><font face="Arial, Helvetica, sans-serif"><b>Select Company</b></font>
</div></td>
<td colspan=2><select name= 'compcode' >
  <?    $result=mysqli_query($conn,"select distinct compcode,name from company") or die(mysqli_error());
      
      while ( $row= mysqli_fetch_row($result))
      {
          echo "<option value='$row[0]'>";
	  echo $row[1];
	  echo "\n";
      }
?>
</select></td>
</tr>




<SCRIPT LANGUAGE="JavaScript" src="../../include/CalendarPopup.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript">
var cal = new CalendarPopup();
</SCRIPT>


		<tr > 



		

		<tr > 


	<td width="367"  align="left"><div align="right"><font  face="Arial, Helvetica, sans-serif">Date &nbsp;</font> </div></td>
		<td width="357" class="small_site_font_black" > 
		<?
		
		$enddt=strftime ("%d/%m/%Y", mktime(0,0,0,date("m"),date("d"),date("Y"))); ?>
		<input name="enddt"  type="text" onKeyPress="return event.keyCode!=13"  class="text_box_button" value="<?=$enddt?>" size="10" > 
		<a href="#" onClick="cal.select(document.regform.enddt,'anchor1','dd/MM/yyyy'); return false;"name="anchor1" id="anchor1"><img  src="../../images/cal.gif" border="0"></a>		</td>
		</tr>		
	<tr>
	<td width="367"  align="left"><div align="right"><font  face="Arial, Helvetica, sans-serif"><b>Closing Stock</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rawmaterial</font> </div></td>
	<td><input type="text" name="rawmaterial" value=""></td></tr>
	<tr>
	<td width="367"  align="left"><div align="right"><font  face="Arial, Helvetica, sans-serif">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Packing Materials</font> </div></td>
	<td><input type="text" name="packingmaterial" value=""></td></tr>
	<tr>
	<td width="367"  align="left"><div align="right"><font  face="Arial, Helvetica, sans-serif">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Finished Goods</font> </div></td>
	<td><input type="text" name="finishedgoods" value=""></td></tr>
	
				<tr > 


	<td width="367"  align="left"><div align="right"><font  face="Arial, Helvetica, sans-serif">Accounting Year &nbsp;</font> </div></td>
		<td width="357" class="small_site_font_black" > 		
		
<?
	$result = mysqli_query($conn,"select distinct account_year from  ledger order by account_year desc ") or die(mysqli_error());
	?>
	<select name="account_year">
	<?
	while($row = mysqli_fetch_row($result))
	{
          echo "<option value='$row[0]'>";
	  echo $row[0];
	  echo "\n";	
	}
?>
</select>
</td></tr> 
	
<tr>
<td colspan="2" align="center">
 <blockquote>  <input type =submit name=submit value = "Submit"></blockquote>
</table>



<center>
  <span class="style1"><font color="#000080"><font size="+1"><a href="../../index.html">Exit </a></font><font size="+1"><a href="../../index.html"></a></font></span>
</center>

                                                                             
</body>
</form>
