news/viewpaymentreport.php at main · Code-Arcade/news · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<?php
include("header.php");
if(isset($_GET['delid']))
{
	$sql="DELETE FROM payment WHERE paymentid='$_GET[delid]'";
	$qsql = mysqli_query($con,$sql);
	if(mysqli_affected_rows($con) == 1)
	{
		echo "<script>alert('payment record deleted successfully...');</script>";
		echo "<script>window.location='viewpayment.php';</script>";
	}
}
?>

  <!--  catg header banner section -->
  <section id="aa-catg-head-banner">
    <div class="aa-catg-head-banner-area">
     <div class="container">
      <div class="aa-catg-head-banner-content">
        <h2>Checkout Page</h2>
      </div>
     </div>
   </div>
  </section>
  <!--  / catg header banner section -->

 <!--  Cart view section -->
 <section id="checkout">
   <div class="container">
     <div class="row">
       <div class="col-md-12">
        <div class="checkout-area">
          <form action="" method="post">
            <div class="row">


              <div class="col-md-12">
                <div class="checkout-left">
                  <div class="panel-group" id="accordion">

<!--  Billing Details -->
<div class="panel panel-default aa-checkout-billaddress">
  <div class="panel-heading">
	<h4 class="panel-title">
	  <a  data-parent="#accordion" >
		View Payment
	  </a>
	</h4>
  </div>
  <div id="collapseThree">
	<div class="panel-body">
<table id="myTable"  class="table table-striped table-bordered">
	<thead>
		<tr>
			<th>Advertiser</th>
			<th>Payment Date</th>
			<th>Particulars</th>
			<th>Paid Amount</th>
		</tr>
	</thead>
	<tbody>
	<?php
	$sql= "SELECT payment.*,advertiser.*  FROM payment LEFT JOIN advertiser ON payment.advertiserid=advertiser.advertiserid WHERE payment.status!='' ";
	if(isset($_GET['paidfor']))
	{
		$sql = $sql . " AND payment.paymenttype='$_GET[paidfor]'";
	}
	//echo $sql;
	//paymenttype
	$totcollection = 0;
	$qsql = mysqli_query($con,$sql);
	echo mysqli_error($con);
	while($rs = mysqli_fetch_array($qsql))
	{
		$totcollection = $totcollection +  $gtotal ;
		$cgst = ($rs['cgst'] * $rs['paidamt'])/100;
		$sgst = ($rs['sgst'] * $rs['paidamt'])/100;
		$gtotal = $rs['paidamt'] + ($cgst + $sgst);
		echo "<tr>
			<td>$rs[advertisername]</td>
			<td>$rs[paymentdate]</td>
			<td>$rs[paymenttype]</td>
			<td>Total  - ₹$rs[paidamt]<br>CGST - ₹$cgst<br>SGST - ₹$sgst <br><b>Grand Total - ₹$gtotal</b></td>
		</tr>";
	}
	?>
	</tbody>
</table>
	</div>
  </div>
</div>

				   </div>
                </div>
              </div>
             </div>
          </form>
         </div>
       </div>
     </div>
   </div>
 </section>
 <!--  / Cart view section -->

 <?php
 include("footer.php");
 ?>
 <script>
 $(document).ready( function () {
    $('#myTable').DataTable();
} );
 </script>
 <script>
 function confirmdelete()
 {
	 if(confirm('Are you sure want to delete this record?') == true)
	 {
		 return true;
	 }
	 else
	 {
		 return false;
	 }
 }
 </script>