File manager - Edit - /home/custbahd/irungikitchen.com/admin/modals/wand.php
Back
<!-- Birthday Countdown Start --> <div class="modal fade" id="bd_countdown"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title text-primary font-w600">Upcoming.<span class="flash">.</span></h5> <button type="button" class="close" data-dismiss="modal"><span>×</span> </button> </div> <div class="modal-body"> <div class="container"> <div class="bd-box"></div> </div> </div> <div class="modal-footer"> <a href="clients/birthdays" class="btn btn-primary">Discover more <i class="fa fa-angle-right ml-1"></i></a> </div> </div> </div> </div> <!-- Birthday Countdown End --> <!-- Tasks Start --> <div class="modal fade" id="reminders"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title">Reminders</h5> <button type="button" class="close" data-dismiss="modal"><span>×</span> </button> </div> <div class="modal-body"> <div class="container"> <div class="row mb-4"> <div class="col-md-12"> <button class="btn btn-primary btn-block" href="#reminder" data-toggle="modal"><i class="fa fa-plus-circle mr-2"></i> Create A Reminder</button> </div> </div> <div class="row"> <?php $sql = "SELECT COUNT(*), type FROM reminders WHERE deleted='' GROUP BY type ORDER BY id DESC"; $result = $conn->query($sql); while($row = mysqli_fetch_array($result)) { if ($row['type']=='Task') { $bg = "bg-success"; $btn = "btn-success"; } else { $bg = "bg-danger"; $btn = "btn-danger"; } echo "<div class='col-md-6'>"; echo "<div class='card text-white ".$bg." fs-12'>"; echo "<div class='card-header'>"; echo "<h5 class='card-title text-white fs-14'>".$row['type']."s</h5>"; echo "</div>"; echo "<div class='card-body mb-0'>"; echo "<p class='card-text fs-30'>".$row['COUNT(*)']." <span class='fs-12'>Upcoming</span></p>"; echo "<a href='reminders' class='btn btn-xs ".$btn." light btn-card'>Go To</a>"; echo "</div>"; echo "</div>"; echo "</div>"; include('modals/reminders/edit.php'); } ?> </div> </div> </div> <div class="modal-footer"> <a href="reminders" class="btn btn-primary">Task Manager <i class="fa fa-angle-right ml-1"></i></a> </div> </div> </div> </div> <!-- Tasks End --> <!-- Analytics Start --> <div class="modal fade" id="analytics"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <h5 class="modal-title">Analytics</h5> <button type="button" class="close" data-dismiss="modal"><span>×</span> </button> </div> <div class=""> <div class=""> <!--Top Sellers Start--> <div class="col-lg-12"> <div class="card"> <div class="card-header"> <h4 class="card-title fs-14">Top Sellers</h4> <div class="dropdown ml-auto text-right"> <div class="btn-link" data-toggle="dropdown"> <svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="24px" height="24px" viewBox="0 0 24 24" version="1.1"><g stroke="none" stroke-width="1" fill="none" fill-rule="evenodd"><rect x="0" y="0" width="24" height="24"></rect><circle fill="#000000" cx="12" cy="5" r="2"></circle><circle fill="#000000" cx="12" cy="12" r="2"></circle><circle fill="#000000" cx="12" cy="19" r="2"></circle></g></svg> </div> <div class="dropdown-menu dropdown-menu-right"> <a class="dropdown-item" href="rankings/products">View Rankings</a> <a class="dropdown-item" href="products">Manage All Products</a> </div> </div> </div> <div class="card-body"> <div class="table-responsive"> <table class="table table-responsive-md"> <thead> <tr> <th class="fs-12">PREVIEW</th> <th class="fs-12">ITEMS</th> <th class="fs-12">SALES</th> <th class="fs-12">ORDERS</th> <th class="fs-12">CLIENTS</th> <th class="fs-12">INCOME</th> </tr> </thead> <tbody> <?php $sql = "SELECT name, image, SUM(subtotal), SUM(quantity), COUNT(email), COUNT(DISTINCT email) FROM checkout GROUP BY name ORDER BY SUM(quantity) DESC LIMIT 6"; $result = $conn->query($sql); //display data on web page while($row = mysqli_fetch_array($result)){ echo '<tr class="fs-12">'; echo '<td><img src="images/'.$row["image"].'" style="width: 40px;height: 40px;border-radius: 100px;object-fit: cover;"></td>'; echo '<td>'.$row["name"].'</td>'; echo '<td>'; echo ''.number_format($row["SUM(quantity)"]).''; if ($row["SUM(quantity)"]==1) { echo ' item'; } else { echo ' items'; } echo '</td>'; echo '<td>'; echo ''.number_format($row["COUNT(email)"]).''; if ($row["COUNT(email)"]==1) { echo ' order'; } else { echo ' orders'; } echo '</td>'; echo '<td>'; echo ''.number_format($row["COUNT(DISTINCT email)"]).''; if ($row["COUNT(DISTINCT email)"]==1) { echo ' client'; } else { echo ' clients'; } echo '</td>'; echo '<td>'.number_format($row["SUM(subtotal)"]).'/-</td>'; echo '</tr>'; } ?> </tbody> </table> </div> </div> </div> </div> <!--Top Sellers End--> <!--Top Clients Start--> <div class="col-lg-12"> <div class="card"> <div class="card-header"> <h4 class="card-title fs-14">Top Clients</h4> </div> <div class="card-body"> <div class="table-responsive"> <table class="table table-responsive-md"> <thead> <tr> <th class="width80 fs-12">#</th> <th class="fs-12">NAMES</th> <th class="fs-12">ORDERS</th> <th class="fs-12">SPENT</th> <th class="fs-12">ACTION</th> </tr> </thead> <tbody> <?php $sql = "SELECT COUNT(DISTINCT client_id) FROM checkout"; $result = $conn->query($sql); //display data on web page while($row = mysqli_fetch_array($result)){ $top_count = '1'; } $sql = "SELECT client_id, fname, lname, email, COUNT(DISTINCT client_id), SUM(quantity), SUM(subtotal) FROM checkout GROUP BY client_id ORDER BY SUM(quantity) DESC LIMIT 10"; $result = $conn->query($sql); //display data on web page while($row = mysqli_fetch_array($result)){ echo '<tr class="fs-12">'; echo '<td><strong>'.number_format($top_count++).'</strong></td>'; echo '<td>'.$row["fname"].' '.$row["lname"].'</td>'; echo '<td>'; echo ''.number_format($row["SUM(quantity)"]).''; if ($row["SUM(quantity)"]==1) { echo ' item'; } else { echo ' items'; } echo '</td>'; echo '<td>'.number_format($row["SUM(subtotal)"]).'/-</td>'; echo '<td><a href="clients/manager/?client='.$row["client_id"].'" class="btn btn-success"><i class="fa fa-caret-right"></i></a></td>'; echo '</tr>'; } ?> </tbody> </table> </div> </div> </div> </div> <!--Top Clients End--> </div> </div> <div class="modal-footer"> <a href="analytics" class="btn btn-primary">Discover more <i class="fa fa-angle-right ml-1"></i></a> </div> </div> </div> </div> <!-- Analytics End -->
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 2.72 |
proxy
|
phpinfo
|
Settings