-
Notifications
You must be signed in to change notification settings - Fork 0
/
your-payment.php
133 lines (118 loc) · 4.41 KB
/
your-payment.php
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
127
128
129
130
131
132
133
<?php
require('dbconnect.php');
session_start();
$Scode = $_SESSION['Scode'];
$user = $_SESSION['UserId'];
$month =date('Y-m');
$s = "SELECT * FROM add_payment_type WHERE Society_Code = '$Scode' ";
$r = mysqli_query($conn,$s);
?>
<!DOCTYPE html>
<html>
<!-- Mirrored from static.pixum.co/up-real-estate-html/index.html by HTTrack Website Copier/3.x [XR&CO'2014], Sat, 30 Mar 2019 05:43:21 GMT -->
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="format-detection" content="telephone=no"/>
<link rel="shortcut icon" type="image/x-icon" href="images/favicon/1.ico"/>
<title>Home page</title>
<link rel="stylesheet" type="text/css" media="screen" href="css/lib/bootstrap/bootstrap.min.css">
<link rel="stylesheet" type="text/css" media="screen" href="fonts/font-awesome-4.4.0/css/font-awesome.min.css">
<link rel="stylesheet" type="text/css" media="screen" href="vendors/jquery-ui-1.11.4/jquery-ui.min.css">
<link rel="stylesheet" type="text/css" media="screen" href="vendors/jcarousel/css/jquery.jcarousel.css">
<link rel="stylesheet" type="text/css" media="screen" href="css/style.css" />
<script type="text/javascript" src="js/libs/jquery.min.js"></script>
<script type="text/javascript" src="js/main.js"></script>
<script type="text/javascript" src="vendors/jquery-ui-1.11.4/jquery-ui.min.js"></script>
<script type="text/javascript" src="vendors/languageswitcher/languageswitcher.js"></script>
<script type="text/javascript" src="vendors/jcarousel/js/jquery.jcarousel.min.js"></script>
<script src="https://maps.googleapis.com/maps/api/js?v=3.exp"></script>
</head>
<body>
<!-- include header -->
<?php
require('header.php');
?>
<!-- banner -->
<div class="home-banner style-4">
<div class="container">
<div class="banner-content">
<div class="banner-message">
<div class="banner-entry">
<span class="entry-title">Features</span>
<span class="entry-message">Some text will be here</span>
</div>
</div>
</div>
</div>
</div>
<br><br>
<!-- Container -->
<br>
<div class="container">
<div class="row">
<div class="col-sm-12">
<div class="contact-form-shortcode contact-form">
<div class="contact-form-entry">
<h2 class="block-title inversed">Your Payments</h2>
<center>
<?php
while($row = mysqli_fetch_assoc($r))
{
$pid = $row['Pay_Id'];
$sql = "SELECT * FROM payment WHERE Pay_Id='$pid' AND User_Id = '$user'";
$result = mysqli_query($conn,$sql);
$rr = mysqli_fetch_assoc($result);
?>
<br><br><br>
<span style="color: black; font-size: 20px"><?php echo $pid;?></span><br>
<span style=" font-size: 20px"> Rupees : <?php echo $rr['Rupees'];?></span><br>
<?php
if ($rr['Payment_Status'] == 1) {
$x = "Paied";
?>
<span style=" font-size: 20px"><?php echo $x;?></span>
<?php
}
else
{
$x = "Pendding";
?>
<span style=" color: red; font-size: 20px"><?php echo $x;?></span>
<?php
}
?>
<?php
}
?>
<?php
$total = "SELECT SUM(Rupees) AS X
FROM add_payment_type
WHERE Society_Code='$Scode'";
$totalr = mysqli_query($conn,$total);
$totalrr = mysqli_fetch_assoc($totalr);
$paied = "SELECT SUM(Rupees) AS XX
FROM payment
WHERE Society_Code='$Scode' AND User_Id ='$user' AND Payment_Status =1";
$paiedr = mysqli_query($conn,$paied);
$paiedrr = mysqli_fetch_assoc($paiedr);
$pendding = $totalrr['X'] - $paiedrr['XX'];
?>
<br><br><br>
<span style=" font-size: 20px"> Total : <?php echo $totalrr['X'];?></span><br>
<span style=" font-size: 20px"> Paied : <?php echo $paiedrr['XX'];?></span><br>
<span style=" font-size: 20px"> Pendding : <?php echo $pendding;?></span><br>
</center>
</div>
</div>
</div>
</div>
<div class="empty-space"></div>
</div>
<!-- Shows some of users-->
<?php
require('some-users.php');
?>
</body>
<!-- Mirrored from static.pixum.co/up-real-estate-html/index.html by HTTrack Website Copier/3.x [XR&CO'2014], Sat, 30 Mar 2019 05:44:00 GMT -->
</html>