Inventory-Management-System-With-POS/history-log.php at main · CodeitSoft-Tech/Inventory-Management-System-With-POS · GitHub

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
<?php


	  include("includes/header.php");

	  if(!isset($_SESSION['admin_username']))
	  {
	     echo "<script>document.location='login.php'</script>";
	  }
	  else
	  {


	?>

           <!-- Main Content-->
			<div class="main-content pt-0">

				<div class="container">
					<div class="inner-body">

						<!-- Page Header -->
						<div class="page-header">
							<div>
								<h2 class="main-content-title tx-24 mg-b-5">History Log</h2>
								<ol class="breadcrumb">
									<li class="breadcrumb-item"><a href="index.php">Home</a></li>
									<li class="breadcrumb-item active" aria-current="page">History Log</li>
								</ol>
							</div>
						</div>
						<!-- End Page Header -->

						<!-- Row -->
						<div class="row sidemenu-height">
							<div class="col-lg-12">
								<div class="card custom-card">
									<div class="card-body">
										<!-- Row -->
										<div class="row row-sm">
											<div class="col-lg-12">
												<div class="card custom-card">
													<div class="col-md-9">
													<form method="post" action="">

															<button name="btn" type="submit" class="btn btn-primary mb-4 mt-4">Click to delete after 30 days</button>
														</form>
													    </div>

													<div class="card-body">
														<div class="table-responsive border">

															<table class="table text-nowrap text-md-nowrap table-striped mg-b-0">
																<thead>
																	<tr>
																		<th>History Log</th>
																	</tr>
																</thead>
																<tbody>
																<?php

										                      		$query = mysqli_query($db,"select * from history_log natural join admin_tbl order by log_date desc")or die(mysqli_error());
										                      		while($row = mysqli_fetch_array($query))
										                      		{


				                      							?>

				                      							<tr>
										                        <td><?php echo $row['fullname']." ".$row['action']." last ".date("M d, Y h:i a",strtotime($row['log_date'])); ?></td>

										                      </tr>
																<?php } ?>
																</tbody>
															</table>
														</div>
													</div>
												</div>
											</div>
										</div>
										<!-- End Row -->
									</div>
								</div>
							</div>
						</div>
						<!-- End Row -->

					</div>
				</div>
			</div>
			<!-- End Main Content-->


<?php  include("includes/footer.php"); ?>
<?php

	if(isset($_POST['btn']))
	{
		$del = "DELETE FROM history_log WHERE DATE_FORMAT(log_date, '%m/%d/%Y') < DATE_SUB(NOW(), INTERVAL 30 DAY)";
	    $run = mysqli_query($db, $del);


	    if($run)
	    {
	    	echo "<script>alert('Done!')</script>";
	    	echo "<script>document.location='history-log.php'</script>";
	    }
	}

?>

<?php } ?>