-
Notifications
You must be signed in to change notification settings - Fork 8
/
Copy pathmanage-supply.php
129 lines (117 loc) · 4.25 KB
/
manage-supply.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
<?php
session_start();
if(!isset($_SESSION['store_id'])) {
header("location:login.php");
exit();
}else{
include('config/db.php');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<title>Pharmacy</title>
<!-- Data Table CSS -->
<?php include("part/data-table-css.php");?>
<!-- Data Table CSS end -->
<!-- All CSS -->
<?php include("part/all-css.php");?>
<!-- All CSS end -->
</head>
<body class="hold-transition sidebar-mini layout-fixed">
<div class="wrapper">
<!-- Navbar -->
<?php include("part/navbar.php");?>
<!-- Navbar end -->
<!-- Sidebar -->
<?php include("part/sidebar.php");?>
<!-- Sidebar end -->
<div class="content-wrapper">
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-12">
<div class="card">
<div class="card-header py-2">
<div class="d-flex justify-content-between align-items-center">
<div>
<h6 class="fs-17 font-weight-600 mb-0">Supplier</h6>
</div>
<div class="text-right">
<a href="new-supply.php" class="btn btn-info btn-sm mr-1"><i class="fas fa-plus mr-1"></i>New Supply</a>
</div>
</div>
</div>
<div class="card-body">
<table id="example1" class="table table-bordered table-hover">
<thead>
<tr class="bg-info">
<th>SL</th>
<th>Supply Date</th>
<th>Title</th>
<th>Supplier</th>
<th>Supply Details</th>
<th>Total</th>
<th>After Discount</th>
<th>Paid</th>
<th>Due</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php
$n = 0;
$sql = $conn->query("SELECT * FROM `p_supply` WHERE `store` = '$_SESSION[store_id]'");
while($row = mysqli_fetch_assoc($sql)){
?>
<tr>
<th scope="row"><?php echo ++$n; ?></th>
<td><?php echo $row['supplydate']; ?></td>
<td><?php echo $row['title']; ?></td>
<td><?php echo $row['supplier']; ?></td>
<td><?php echo "<pre>".$row['details']."</pre>"; ?></td>
<td><?php echo $row['total']; ?></td>
<td><?php echo ($row['payable'] <= 0) ? $row['total'] : $row['payable']; ?></td>
<td><?php echo $row['paid']; ?></td>
<td><?php echo $row['due']; ?></td>
<td>
<a class="btn btn-info btn-sm disabled" data-toggle="modal" data-target="#edit-customer<?php echo $row['id']; ?>"><i class="fa fa-edit"></i></a>
<a href="actions/remove.php?remove&code=<?php echo base64_encode($row['id']); ?>&wr=<?php echo base64_encode("p_supply"); ?>" class="btn btn-danger btn-sm delete" onclick="return confirm('Are you sure to delete?')"> <i class="fa fa-trash"></i> </a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</section>
</div>
<!-- Footer -->
<?php include("part/footer.php");?>
<!-- Footer End -->
</div>
<!-- Alert -->
<?php include("part/alert.php");?>
<!-- Alert end -->
<!-- All JS -->
<?php include("part/all-js.php");?>
<!-- All JS end -->
<!-- Data Table JS -->
<?php include("part/data-table-js.php");?>
<!-- Data Table JS end -->
<!-- Page specific script -->
<script>
$(function () {
$(".select2").select2();
$(".select2bs4").select2({
theme: "bootstrap4",
});
});
</script>
</body>
</html>