Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement