-
Notifications
You must be signed in to change notification settings - Fork 0
/
purchasedhistory.php
65 lines (56 loc) · 2.56 KB
/
purchasedhistory.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
<?php require_once('header.php'); ?>
<?php
function loadOrders()
{
$user_id = $_SESSION['user_id'];
$phistory = mysql_query("SELECT order_master.*, recievetype.*,customer.*, employee.*,recievetype_details.status,recievetype_details.accepted_date
FROM order_master INNER JOIN recievetype ON
order_master.om_receivetypeno = recievetype.receivetypeNo
INNER JOIN recievetype_details ON recievetype_details.or_num = order_master.om_orno
INNER JOIN customer ON order_master.om_cusno = customer.customer_num
INNER JOIN employee ON order_master.om_empno = employee.emp_no
WHERE recievetype_details.status = 'success' AND customer.customer_num = '$user_id'") or die(mysql_error());
while($fetch= mysql_fetch_assoc($phistory))
{
echo'<div class="lv-body">
<div class="lv-item media">
<div class="media-body">
<div class="lv-title">
<strong>Order Number : </strong>
OR-2016-'. $fetch['om_orno'] .'</div>
<div class="lv-body">
<strong>Purchased Date : </strong>
' . $fetch['accepted_date'] . ' <br>
<strong>Received Type</strong>
' . $fetch['receivetype'] . '
</div>
<div class="lv-actions actions dropdown">
<a href="#" data-toggle="dropdown" aria-expanded="true">
<i class="zmdi zmdi-more-vert"></i>
</a>
<ul class="dropdown-menu dropdown-menu-right">
<li>
<a href="orderdetails.php?om_orno='. $fetch['om_orno'] .'"">View</a>
</li>
</ul>
</div>
</div>
</div>
</div>';
}
}
?>
<div class="container">
<div class="block-header">
<h2>History of your transaction that has been completed :</h2>
</div>
<div class="card">
<div class="listview lv-bordered lv-lg">
<?php
loadOrders();
?>
</div>
</div>
</div>
</div>
<?php require_once('footer.php'); ?>