bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php

if(isset($_GET['fromto'])&& $_GET['fromto']!='')

{

include_once "dbc.php";

error_reporting (E_ALL ^ E_NOTICE);

$fromto = $_GET['fromto'];
$explod = explode("-",$fromto);

$fromdate=$explod[0];
			$sqldate = strtotime($fromdate);

$fromdatesql = date("Y-m-d",$sqldate);

$todate=$explod[1];

$sqldate1 = strtotime($todate);

$todatesql = date("Y-m-d",$sqldate1);

$type = $_GET['type'];

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<title>FROM <?php echo $fromdatesql; ?>TO <?php echo $todatesql; ?>SALES REPORT</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<style type="text/css" media="print">
.hide {
	display: none
}
</style>
<script type="text/javascript">

function printpage() {

document.getElementById('printButton').style.visibility="hidden";

window.print();

document.getElementById('printButton').style.visibility="visible";

}

</script>
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/main.min.css">
<body>
<h3 align="center"><strong> Raga Designers  Sales Report</strong></h3>
<h5 align="right"><strong>From</strong> <?php echo $fromdatesql; ?> <strong>To</strong> <?php echo $todatesql; ?></h5>
<input name="print" type="button" value="Print" id="printButton" onClick="printpage()" class="btn btn-primary">
<table id="dataTable" class="table table-bordered table-condensed table-hover table-striped">
  <tr>
    <td><strong>Total Sales </strong></td>
    <td><strong>Received Amount</strong></td>
    <td><strong>Service Tax Collected</strong></td>
    <td><strong>Total Outstanding </strong></td>
  </tr>
  <tr>
    <td>&nbsp;
      <?php

if($_GET['type']!=""){

$total = $db->queryUniqueValue("SELECT sum(total) FROM sales where paid_status = '$type' AND status = '1' AND date BETWEEN '$fromdatesql' AND '$todatesql'"); echo $total = round($total, 2);}
			  else
			  {
				  $total = $db->queryUniqueValue("SELECT sum(total) FROM sales where status = '1' AND date BETWEEN '$fromdatesql' AND '$todatesql'"); echo $total = round($total, 2);

}?></td>
    <td>&nbsp;
      <?php

if($_GET['type']!=""){

$ra = $db->queryUniqueValue("SELECT sum(paid) FROM sales where paid_status = '$type' AND status = '1' AND date BETWEEN '$fromdatesql' AND '$todatesql'"); echo $ra = round($ra, 2);

}

else

{

$ra = $db->queryUniqueValue("SELECT sum(paid) FROM sales where status = '1' AND date BETWEEN '$fromdatesql' AND '$todatesql'"); echo $ra = round($ra, 2);

}

?></td>
    <td>&nbsp;
      <?php

if($_GET['type']!=""){

$ra = $db->queryUniqueValue("SELECT sum(paid) FROM sales where paid_status = '$type' AND status = '1' AND date BETWEEN '$fromdatesql' AND '$todatesql'");

$tax = (($ra * 12.36)/100);

echo $stax = round($tax, 2);

}

else

{

$ra = $db->queryUniqueValue("SELECT sum(paid) FROM sales where status = '1' AND date BETWEEN '$fromdatesql' AND '$todatesql'");

$tax = (($ra * 12.36)/100);

echo $stax = round($tax, 2);

}

?></td>
    <td >&nbsp;
      <?php

if($_GET['type']!=""){

$out = $db->queryUniqueValue("SELECT sum(balance) FROM sales where paid_status = '$type' AND status = '1' AND date BETWEEN '$fromdatesql' AND '$todatesql'");

echo $out = round($out, 2);

}

else{

$out = $db->queryUniqueValue("SELECT sum(balance) FROM sales where status = '1' AND date BETWEEN '$fromdatesql' AND '$todatesql'"); echo $out = round($out, 2);

}

?></td>
  </tr>
</table>
<table id="dataTable" class="table table-bordered table-condensed table-hover table-striped">
  <tr  style="background-color:#428bca; color:#fff;">
    <th>Date</th>
    <th>Invoice No</th>
    <th>Client ID</th>
    <th>Website</th>
    <th>Contact</th>
    <th>Paid</th>
    <th>Balance</th>
    <th>S.Tax Coll</th>
    <th>Total</th>
  </tr>
  <?php

if($_GET['type']!=""){

$result = $db->query("SELECT * FROM sales where paid_status = '$type' AND status = '1' AND `date` BETWEEN '$fromdatesql' AND '$todatesql' ");

}else{

$result = $db->query("SELECT * FROM sales where status = '1' AND `date` BETWEEN '$fromdatesql' AND '$todatesql' ");

}

while ($line = $db->fetchNextObject($result)) {

$client_id = $line->client_id;

$sql3 = "SELECT * FROM client where client_id = '$client_id'";

$result3 = mysql_query($sql3);

$r3 = mysql_fetch_array($result3);

?>
  <tr>
    <td><?php echo $line->date; ?><br/>
      S: <?php echo $line->start_date; ?><br>
      C: <?php echo $line->completion_date; ?></td>
    <td><?php echo $line->invoice_no; ?></td>
    <td><?php echo $line->client_id; ?><br/>
      <?php echo $r3['company_name']; ?>,<br/>
      <?php echo $r3['name']; ?><br/>
      <?php echo $r3['mail']; ?></td>
    <td><?php echo $r3['website']; ?></td>
    <td>M: <?php echo $r3['mobile_number']; ?>,<br/>
      M1: <?php echo $r3['alter_mobile']; ?>,<br/>
      L: <?php echo $r3['phone']; ?><br/>
      F: <?php echo $r3['fax']; ?></td>
    <td><?php echo $line->paid; ?></td>
    <td><?php echo $line->balance; ?></td>
    <td><?php $t=$line->paid; echo $st = (($t* 12.36)/100) ?></td>
    <td><?php echo $line->total; ?></td>
  </tr>
  <?php

}

?>
</table>
<?php include 'chat1.php'; ?>
</body>
</html>
<?php

}