-
Notifications
You must be signed in to change notification settings - Fork 0
/
products.php
309 lines (233 loc) · 14.5 KB
/
products.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
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
<?php
require_once('./admin/database/config.php');
require_once('./admin/inc/auxilliaries.php');
$cur_page = 'products';
$Products = new Admin($pdo, "products");
$Categories = new Admin($pdo, "categories");
$fetchCategory = $Categories->readWithNoRestriction();
$currentPage = isset($_GET['page']) ? $_GET['page'] : 1;
$categories = isset($_GET['category']) ? $_GET['category'] : array();
// $totalRecords = $Products->getTotalRecords($categories);
$limit = 9;
// Calculate the total number of pages
// $totalPages = ceil($totalRecords / $limit);
// Ensure that the current page is within the valid range
// $page = min($currentPage, $totalPages);
// $skip = ($page <= 1) ? 0 : $limit * ($page - 1);
$numAdjacentPages = 2;
// exit;
// 2. Construct an SQL query using these category IDs
// if (!empty($categories)) {
// $fetchProducts = $Products->getPaginatedData($limit, $skip, $categories);
// } else {
// $fetchProducts = $Products->getPaginatedData($limit, $skip);
// }
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>Products - Real Steel co. Ltd</title>
<!-- <link rel="manifest" href="./favicon/site.webmanifest" /> -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css" integrity="sha512-iecdLmaskl7CVkqkXNQ/ZH/XLlvWZOJyj7Yy7tcenmpD1ypASozpmT/E0iPtmFIB46ZmdtAc9eNBvH0H/ZpiBw==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<script src="https://cdn.tailwindcss.com"></script>
<link rel="stylesheet" href="./styles/footer.css" />
<link href="https://fonts.googleapis.com/css?family=Barlow Condensed" rel="stylesheet" />
<!-- <link rel="stylesheet" href="./style.css" /> -->
<link rel="stylesheet" href="./styles/product.css" />
<!-- favicon -->
<link rel="apple-touch-icon" sizes="180x180" href="./favicon/apple-touch-icon.png">
<link rel="icon" type="image/png" sizes="32x32" href="./favicon/favicon-32x32.png">
<link rel="icon" type="image/png" sizes="16x16" href="./favicon/favicon-16x16.png">
<link rel="manifest" href="./favicon/site.webmanifest">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<!-- paginate library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/paginationjs/2.1.4/pagination.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/paginationjs/2.1.4/pagination.css" />
<style>
.product {
width: 260px;
}
body {
overflow-x: hidden;
}
</style>
</head>
<body>
<?php require_once './inc/nav-hero.php' ?>
<h1 class="font-extrabold text-7xl px-4 text-center pt-36 text-white">Products Listing</h1>
</section>
<div class="grid grid-cols-1 lg:grid-cols-12 grid-rows-1 lg:gap-4 w-screen">
<div id="filter-div" class="lg:col-span-3">
<!--
This example requires some changes to your config:
```
// tailwind.config.js
module.exports = {
// ...
plugins: [
// ...
require('@tailwindcss/forms'),
],
}
```
-->
<div class="bg-white">
<div>
<!--
Mobile filter dialog
Off-canvas filters for mobile, show/hide based on off-canvas filters state.
-->
<div class="relative z-40 lg:hidden" role="dialog" aria-modal="true">
<!--
Off-canvas menu backdrop, show/hide based on off-canvas menu state.
Entering: "transition-opacity ease-linear duration-300"
From: "opacity-0"
To: "opacity-100"
Leaving: "transition-opacity ease-linear duration-300"
From: "opacity-100"
To: "opacity-0"
-->
<div class="fixed inset-0 bg-black bg-opacity-25"></div>
<div class="fixed inset-0 z-40 flex">
<div class="relative ml-auto sm:flex h-full w-full max-w-xs flex-col overflow-y-auto bg-white py-4 pb-12 shadow-xl">
<div class="flex items-center justify-between px-4">
<h2 class="text-2xl text-gray-900">Filter List</h2>
<button id="close-icon" type="button" class="-mr-2 flex h-10 w-10 items-center justify-center rounded-md bg-white p-2 text-black">
<span class="sr-only">Close menu</span>
<svg class="icon h-10 w-10" fill="none" viewBox="0 0 24 24" stroke-width="3" stroke="currentColor" aria-hidden="true">
<path stroke-linecap="round" stroke-linejoin="round" d="M6 18L18 6M6 6l12 12" />
</svg>
</button>
</div>
<!-- Filters -->
<form action="" method="GET" class="mt-4 border-t border-gray-200">
<div class="border-t border-gray-200 px-4 py-6">
<h3 class="-mx-2 -my-3 flow-root">
<!-- Expand/collapse section button -->
<button type="button" class="flex w-full items-center justify-between bg-white px-2 py-3 text-black hover:text-gray-500" aria-controls="filter-section-mobile-0" aria-expanded="false">
<span class="font-medium text-gray-900">Category</span>
<span class="ml-6 flex items-center">
<!-- Expand icon, show/hide based on section open state. -->
<svg class="h-5 w-5 text-black" viewBox="0 0 20 20" fill="currentColor" aria-hidden="true">
<path d="M10.75 4.75a.75.75 0 00-1.5 0v4.5h-4.5a.75.75 0 000 1.5h4.5v4.5a.75.75 0 001.5 0v-4.5h4.5a.75.75 0 000-1.5h-4.5v-4.5z" />
</svg>
<!-- Collapse icon, show/hide based on section open state. -->
<svg class="h-5 w-5 text-black" viewBox="0 0 20 20" fill="currentColor" aria-hidden="true">
<path fill-rule="evenodd" d="M4 10a.75.75 0 01.75-.75h10.5a.75.75 0 010 1.5H4.75A.75.75 0 014 10z" clip-rule="evenodd" />
</svg>
</span>
</button>
</h3>
<!-- Filter section, show/hide based on section state. MOBILE VIEW -->
<div class="pt-6" id="filter-section-mobile-0">
<div class="space-y-6">
<?php foreach ($fetchCategory as $category) { ?>
<div class="flex items-center">
<input id="filter-mobile-color-0" name="category[]" value="<?php echo $category['id'] ?>" type="checkbox" class="h-4 w-4 rounded border-gray-300 text-indigo-600 focus:ring-indigo-500" <?php echo in_array($category['id'], $categories) ? 'checked' : 'jj' ?>>
<label for="filter-mobile-color-0" class="ml-3 min-w-0 flex-1 text-gray-500"><?php echo $category['name'] ?></label>
</div>
<?php } ?>
<!-- <button type="submit" class="py-2 px-4 bg-indigo-600 hover:bg-indigo-700 focus:ring-indigo-500 focus:ring-offset-indigo-200 text-white w-full transition ease-in duration-200 text-center text-lg font-semibold shadow-md focus:outline-none focus:ring-2 focus:ring-offset-2 rounded-lg ">Filter</button> -->
</div>
</div>
</div>
</form>
</div>
</div>
</div>
<main class="mx-auto max-w-7xl px-4 sm:px-6 lg:px-8">
<div class="flex items-baseline justify-between border-b border-gray-200 pb-6 pt-8">
<h1 class="text-4xl font-bold tracking-tight text-gray-900">Filter</h1>
<div class="flex items-center">
<button type="button" class="-m-2 ml-5 p-2 text-gray-400 hover:text-gray-500 sm:ml-7">
<span class="sr-only">View grid</span>
<!-- <svg class="h-5 w-5" aria-hidden="true" viewBox="0 0 20 20" fill="currentColor">
<path fill-rule="evenodd" d="M4.25 2A2.25 2.25 0 002 4.25v2.5A2.25 2.25 0 004.25 9h2.5A2.25 2.25 0 009 6.75v-2.5A2.25 2.25 0 006.75 2h-2.5zm0 9A2.25 2.25 0 002 13.25v2.5A2.25 2.25 0 004.25 18h2.5A2.25 2.25 0 009 15.75v-2.5A2.25 2.25 0 006.75 11h-2.5zm9-9A2.25 2.25 0 0011 4.25v2.5A2.25 2.25 0 0013.25 9h2.5A2.25 2.25 0 0018 6.75v-2.5A2.25 2.25 0 0015.75 2h-2.5zm0 9A2.25 2.25 0 0011 13.25v2.5A2.25 2.25 0 0013.25 18h2.5A2.25 2.25 0 0018 15.75v-2.5A2.25 2.25 0 0015.75 11h-2.5z" clip-rule="evenodd" />
</svg> -->
<!-- <button type="button" class="text-white bg-blue-700 hover:bg-blue-800 focus:ring-4 focus:ring-blue-300 font-medium rounded-lg text-lg px-5 py-1 me-2 mb-2 dark:bg-blue-600 dark:hover:bg-blue-700 focus:outline-none">Filter</button> -->
</button>
<button type="button" class="-m-2 ml-4 p-2 text-gray-400 hover:text-gray-500 sm:ml-6 lg:hidden">
<span class="sr-only">Filters</span>
<svg class="h-5 w-5" aria-hidden="true" viewBox="0 0 20 20" fill="currentColor">
<path fill-rule="evenodd" d="M2.628 1.601C5.028 1.206 7.49 1 10 1s4.973.206 7.372.601a.75.75 0 01.628.74v2.288a2.25 2.25 0 01-.659 1.59l-4.682 4.683a2.25 2.25 0 00-.659 1.59v3.037c0 .684-.31 1.33-.844 1.757l-1.937 1.55A.75.75 0 018 18.25v-5.757a2.25 2.25 0 00-.659-1.591L2.659 6.22A2.25 2.25 0 012 4.629V2.34a.75.75 0 01.628-.74z" clip-rule="evenodd" />
</svg>
</button>
</div>
</div>
<section aria-labelledby="products-heading" class="pb-24 pt-6">
<h2 id="products-heading" class="sr-only">Products</h2>
<div class="">
<!-- Filters -->
<form action="" method="GET" class="hidden lg:block">
<div class="border-b border-gray-200 py-6">
<h3 class="-my-3 flow-root">
<!-- Expand/collapse section button -->
<button type="button" class="flex w-full items-center justify-between bg-white py-3 text-sm text-gray-400 hover:text-gray-500" aria-controls="filter-section-0" aria-expanded="false">
<span class="font-medium text-gray-900">category</span>
<span class="ml-6 flex items-center">
<!-- Expand icon, show/hide based on section open state. -->
<svg class="h-5 w-5" viewBox="0 0 20 20" fill="currentColor" aria-hidden="true">
<path d="M10.75 4.75a.75.75 0 00-1.5 0v4.5h-4.5a.75.75 0 000 1.5h4.5v4.5a.75.75 0 001.5 0v-4.5h4.5a.75.75 0 000-1.5h-4.5v-4.5z" />
</svg>
<!-- Collapse icon, show/hide based on section open state. -->
<svg class="h-5 w-5" viewBox="0 0 20 20" fill="currentColor" aria-hidden="true">
<path fill-rule="evenodd" d="M4 10a.75.75 0 01.75-.75h10.5a.75.75 0 010 1.5H4.75A.75.75 0 014 10z" clip-rule="evenodd" />
</svg>
</span>
</button>
</h3>
<!-- Filter section, show/hide based on section state. DESKTOP VIEW -->
<div class="pt-6" id="filter-section-0">
<div class="space-y-4">
<?php foreach ($fetchCategory as $category) { ?>
<div class="flex items-center">
<input id="filter-mobile-color-0" name="category[]" value="<?php echo $category['id'] ?>" type="checkbox" class="h-4 w-4 rounded border-gray-300 text-indigo-600 focus:ring-indigo-500" <?php echo in_array($category['id'], $categories) ? 'checked' : 'jj' ?>>
<label for="filter-color-0" class="ml-3 text-md text-gray-600"><?php echo $category['name'] ?></label>
</div>
<?php } ?>
<!-- <button type="button" class="text-white bg-blue-700 hover:bg-blue-800 focus:ring-4 focus:ring-blue-300 font-medium rounded-lg text-lg px-14 py-2 me-2 mb-2 dark:bg-blue-600 dark:hover:bg-blue-700 focus:outline-none">Filter</button> -->
<!-- <button type="submit" class="py-2 px-4 bg-indigo-600 hover:bg-indigo-700 focus:ring-indigo-500 focus:ring-offset-indigo-200 text-white w-full transition ease-in duration-200 text-center text-lg font-semibold shadow-md focus:outline-none focus:ring-2 focus:ring-offset-2 rounded-lg ">Filter</button> -->
</div>
</div>
</div>
</form>
<!-- Product grid -->
<div class="lg:col-span-3">
<!-- Your content -->
</div>
</div>
</section>
</main>
</div>
</div>
</div>
<div class=" lg:col-span-9 lg:col-start-4 ">
<!-- source: https://github.com/mfg888/Responsive-Tailwind-CSS-Grid/blob/main/index.html -->
<button id="filter-trigger" type="button" class="flex -m-2 mt-4 mx-12 p-2 text-2xl text-gray-400 hover:text-gray-500 sm:ml-6 lg:hidden">
<span class="mr-4">Filters</span>
<svg class="h-8 w-8" aria-hidden="true" viewBox="0 0 20 20" fill="currentColor">
<path fill-rule="evenodd" d="M2.628 1.601C5.028 1.206 7.49 1 10 1s4.973.206 7.372.601a.75.75 0 01.628.74v2.288a2.25 2.25 0 01-.659 1.59l-4.682 4.683a2.25 2.25 0 00-.659 1.59v3.037c0 .684-.31 1.33-.844 1.757l-1.937 1.55A.75.75 0 018 18.25v-5.757a2.25 2.25 0 00-.659-1.591L2.659 6.22A2.25 2.25 0 012 4.629V2.34a.75.75 0 01.628-.74z" clip-rule="evenodd" />
</svg>
</button>
<!-- ✅ Grid Section - Starts Here 👇 -->
<section id="data-container" class="w-fit mx-auto grid grid-cols-1 lg:grid-cols-3 md:grid-cols-2 justify-items-center justify-center gap-y-8 gap-x-6 mt-10 mb-5">
</section>
<!-- 🛑 Grid Section - Ends Here -->
<div class="mr-10 flex justify-end my-6">
<section id="pagination" class="ml-12" aria-label="page-navigation">
</section>
</div>
</div>
</div>
<?php require_once './inc/footer.php' ?>
<script src="./scripts/product-ajax.js">
</script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/flowbite/2.0.0/flowbite.min.js"></script>
<!-- <script src="https://pagination.js.org/dist/2.6.0/pagination.min.js"></script> -->
<script src="./scripts/mobile-filter-toggle.js"></script>
<script src="./scripts/togglemenu.js"></script>
</body>
</html>