forked from pipspritam/Full-Stack-Shopping-website-with-jsp
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathbill.jsp
97 lines (92 loc) · 3.93 KB
/
bill.jsp
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
<%@ include file="navbar.jsp" %>
<%@ include file="dbconnect.jsp" %>
<%
String email = (String)session.getAttribute("email");
String order_id = request.getParameter("order_id");
Statement stmt = con.createStatement();
ResultSet rs=stmt.executeQuery("select * from users where email='"+email+"'");
Statement stmt1 = con.createStatement();
ResultSet rs1=stmt1.executeQuery("select * from orders where order_id='" + order_id + "'");
rs.next();
rs1.next();
%>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Tax Invoice</title>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>TAX INVOICE</title>
<link rel="stylesheet" href="./css/bill.css">
</head>
<body>
<div class="container">
<div class="col-2">
<div class="bill-ship order-div">
<h1>Bill To</h1>
<div class="delivery-address-div">
<p class="label">Name </p>
<p><%= rs.getString("name") %></p>
<p class="label">Email </p>
<p><%= rs.getString("email") %></p>
<p class="label">Phone </p>
<p><%= rs.getString("phone") %></p>
<p class="label">Address</p>
<p><%= rs.getString("address") %></p>
<p class="label">Pincode</p>
<p><%= rs.getString("pincode") %></p>
</div>
</div>
<div class="bill-ship order-div">
<h1>Ship To</h1>
<div class="delivery-address-div">
<p class="label">Name </p>
<p><%= rs1.getString("shipping_name") %></p>
<p class="label">Email </p>
<p><%= rs1.getString("shipping_email") %></p>
<p class="label">Phone </p>
<p><%= rs1.getString("shipping_phone") %></p>
<p class="label">Address</p>
<p><%= rs1.getString("shipping_address") %></p>
<p class="label">Pincode</p>
<p><%= rs1.getString("shipping_pincode")%></p>
</div>
</div>
</div>
<div class="col-2">
<div class="tax-invoice order-div">
<h1>Tax Invoice</h1>
<div class="delivery-address-div">
<p class="label">Order Id</p>
<p><%= order_id %></p>
<p class="label">Date </p>
<p><%= rs1.getString("buy_date") %></p>
<p class="label">Time </p>
<p><%= rs1.getString("buy_time") %></p>
</div>
</div>
<div class="order-div">
<h1>Order Details</h1>
<div class="product-details-div">
<div class="product-details">
<h3><%= rs1.getString("product_name") %></h3>
<p>Price: <span>₹</span><%= pretty_print_price(rs1.getString("price")) %></p>
<p>Quantity: <span><%= rs1.getString("quantity") %></span></p>
<p>Payable: <span><%= pretty_print_price(rs1.getString("total_payable")) %></span></p>
<p>Payment Method: <span><%= rs1.getString("payment_method") %></span></p>
</div>
</div>
</div>
</div>
<form class="print" action="./print.jsp" method="POST" target="_blank">
<input type="hidden" name="order_id" value="<%= order_id %>">
<input class="print-btn" type="submit" value="Print Bill">
</form>
<div class="msg-div">
<h1>Thank You For Shopping With Us</h1>
<a class="continue-btn" href="./index.jsp">Continue Shopping</a>
</div>
</div>
</body>
</html>