<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>COMAPNY</title>
<link rel="stylesheet" type="text/css" href="js/calendar.css" />
<link rel="stylesheet" href="styles.css" type="text/css" />
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/calendar.js"></script>
<script type="text/javascript" src="js/jquery.min.js"></script>
<script type="text/javascript" >
function getValue()
{
//alert("test....");
var n = document.getElementById('n').value;
n = Number(n);
document.getElementById('n1').value=n;
}
</script>
</head>
<body onload="getValue();">
<?php require_once("config/dbConnect.php"); ?>
<div id="header_wrapper_holder_all">
<div id="wrapper" style="border:none">
<div style="width:970px;position:relative;float:left;border-top:solid 1px #000;border-bottom:solid 1px #000">
<table width="100%">
<tr>
<td style="width:220px">Date</td>
<td style="width:300px">Particulars</td>
<td style="width:225px;text-align:center">Debit</td>
<td style="width:225px;text-align:center">Credit</td>
</tr>
</table>
</div>
<div style="width:970px;position:relative;float:left;">
<table width="100%">
<?php
$prevMonth = date('Y-m-d', strtotime('-1 month'));
$prevMonthFirst = date('Y-m-01', strtotime('-1 month'));
$prevMonthLast = date('Y-m-t', strtotime('-1 month'));
$ledger1 = "SELECT j2.*,j1.*FROM jabeda1 j1,jabeda2 j2 WHERE j1.id = j2.jId AND j2.amount!=0 AND j2.date BETWEEN '$prevMonthFirst' AND '$prevMonthLast'";
//echo $ledger1;
$res1 = mysql_query($ledger1) or die(mysql_error());
$t_debit1 = 0;
$t_credit1 = 0;
while($rowArr1 = mysql_fetch_array($res1))
{
//if($rowArr['amount']!='0')
//{
//echo"<pre>";echo print_r($rowArr);echo"</pre>";
if($rowArr1['input_type']=='Expenses')
{
$t_credit1 = $rowArr1['amount'] + $t_credit1;
}
if($rowArr1['input_type']=='Deposit')
{
$t_debit1 = $rowArr1['amount'] + $t_debit1;
}
}
?>
<tr>
<td style="width:220px">2012-11-01</td>
<td style="width:300px">Dr Opening balance</td>
<?php
$tVal1 = $t_debit1-$t_credit1;
$newTest1 = substr_count($tVal1,"-");
if($newTest1)
{
?>
<td style="width:225px;text-align:center"><?php echo abs($tVal1); ?></td>
<td style="width:225px;text-align:center"> </td>
<?php
}else{
?>
<td style="width:225px;text-align:center"> </td>
<td style="width:225px;text-align:center"><?php echo abs($tVal1); ?></td>
<?php } ?>
</tr>
<?php
$date = date('Y-m-d');
$firstDate = date('Y-m-01', strtotime($date));
$lastDate = date('Y-m-t', strtotime($date));
$prevMonth = date('Y-m-d', strtotime('-1 month'));
$nextMonth = date('Y-m-d', strtotime('+1 month'));
$ledger = "SELECT j2.*,j1.*FROM jabeda1 j1,jabeda2 j2 WHERE j1.id = j2.jId AND j2.amount!=0 AND j2.date BETWEEN '$firstDate' AND '$lastDate'";
//echo $ledger;
$res = mysql_query($ledger) or die(mysql_error());
$t_debit = 0;
$t_credit = 0;
while($rowArr = mysql_fetch_array($res))
{
//if($rowArr['amount']!='0')
//{
//echo"<pre>";echo print_r($rowArr);echo"</pre>";
if($rowArr['input_type']=='Expenses')
{
$t_credit = $rowArr['amount'] + $t_credit;
?>
<tr>
<td style="width:220px"><?php echo $rowArr['date']; ?></td>
<td style="width:300px;text-align:justify"> <strong>Dr Purchase Local R/M-Credit</strong> </br>Being the amount credit <strong><?php echo $rowArr['name']; ?></strong> </td>
<td style="width:225px;text-align:center"> </td>
<td style="width:225px;text-align:center"><?php echo $rowArr['amount']; ?></td>
</tr>
<?php }
if($rowArr['input_type']=='Deposit') {
$t_debit = $rowArr['amount'] + $t_debit;
?>
<tr>
<td style="width:220px"><?php echo $rowArr['date']; ?></td>
<td style="width:300px;text-align:justify"><strong>Cr Sales-Credit </strong></br>Being the amount credit sales <strong><?php echo $rowArr['name']; ?></strong></td>
<td style="width:225px;text-align:center"><?php echo $rowArr['amount']; ?></td>
<td style="width:225px;text-align:center"></td>
</tr>
<?php } ?>
<?php
}
?>
</table>
<div id="res">
<table width="100%">
<tr>
<td style="width:50%;font-weight:bold;text-align:center"><?php echo $t_debit;?></td>
<td style="width:50%;font-weight:bold;text-align:center"><?php echo $t_credit;?></td>
</tr>
<tr>
<?php
$tVal = $t_debit-$t_credit;
$newTest = substr_count($tVal,"-");
//global $tVal;
?>
<?php
if($newTest)
{
?>
<td style="width:50%;text-align:center"><?php echo abs($tVal);?></td>
<?php
}
else
{
?>
<td style="width:50%;text-align:center"><?php echo $tVal;?></td>
<?php
}
?>
</tr>
</table>
</div>
<div id="res" style="border-bottom:solid 2px #000;">
<table width="100%">
<tr>
<?php
if($newTest)
{
?>
<td style="width:225px;text-align:center;font-weight:bold"><?php echo abs($tVal)+$t_debit;?></td>
<td style="width:225px;text-align:center;font-weight:bold"><?php echo $t_credit;?></td>
<?php
}
else
{
?>
<td style="width:50%;text-align:center;font-weight:bold"><?php echo $t_debit;?></td>
<td style="width:50%;text-align:center;font-weight:bold"><?php echo $t_credit+ $t_debit;?></td>
<?php
}
?>
</tr>
</table>
</div>
</div>
</div>
</div>
</body>
</html>