D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
salvation.incrediblebengal.com
/
admin
/
Filename :
item-summary.php
back
Copy
<?php include'config.php'; include'function.php'; include'get_session_access.php'; $page_title = "Food Item Summary."; ?> <!DOCTYPE html> <html lang="en"> <head> <title>Encode Restaurent - Admin Dashboard </title> <?php include'style.php'; ?> </head> <body> <div id="main-wrapper"> <?php include'header.php'; ?> <?php include'sidebar.php'; ?> <!--********************************** Content body start ***********************************--> <div class="content-body"> <!-- row --> <div class="container-fluid"> <div class="row"> <div class="col-lg-6 col-md-6 col-sm-12"> <div class="summary_list"> <h4>Dine In Top 10 Selling Food Items</h4> <table class="top_selling_item"> <thead> <tr> <th>Food Id</th> <th>Food Name</th> <th>Price</th> <th>Selling Qty.</th> </tr> </thead> <tbody> <?php $view_dine_record = mysqli_query($conn, "SELECT food_id, food_name, food_price, sum(food_qty) AS f_qty FROM table_orderlist GROUP BY food_id ORDER BY sum(food_qty) DESC LIMIT 10"); if($view_dine_record-> num_rows > 0){ while($res = mysqli_fetch_assoc($view_dine_record)){ ?> <tr> <td><?php echo $res['food_id']; ?></td> <td><?php echo $res['food_name']; ?></td> <td><i class="fa fa-inr"></i> <?php echo $res['food_price']; ?></td> <td><?php echo $res['f_qty']; ?></td> </tr> <?php } } ?> </tbody> </table> </div> </div> <div class="col-lg-6 col-md-6 col-sm-12"> <div class="summary_list"> <h4>Take Away Top Selling Food Items</h4> <table class="top_selling_item"> <thead> <tr> <th>Food Id</th> <th>Food Name</th> <th>Price</th> <th>Selling Qty.</th> </tr> </thead> <tbody> <?php $view_delivery_record = mysqli_query($conn, "SELECT food_id, food_name, food_price, sum(food_qty) AS f_qty FROM delivery_orderlist GROUP BY food_id ORDER BY sum(food_qty) DESC LIMIT 10"); if($view_delivery_record-> num_rows > 0){ while($rec = mysqli_fetch_assoc($view_delivery_record)){ ?> <tr> <td><?php echo $rec['food_id']; ?></td> <td><?php echo $rec['food_name']; ?></td> <td><i class="fa fa-inr"></i> <?php echo $rec['food_price']; ?></td> <td><?php echo $rec['f_qty']; ?></td> </tr> <?php } } ?> </tbody> </table> </div> </div> </div> </div> </div> <!--********************************** Content body end ***********************************--> <?php include'footer.php'; ?> </body> </html>