admin.php

<?php
  $page_title = 'Inicio';
  require_once('includes/load.php');
  
  // Verificar que nivel de usuario tiene permiso de ver esta página.
  page_require_level(1);

  $c_categorie     = count_by_id('categories');
  $c_product       = count_by_id('products');
  $c_sale          = count_by_id('sales');
  $c_user          = count_by_id('users');
  $products_sold   = find_higest_saleing_product('10');
  $recent_products = find_recent_product_added('5');
  $recent_sales    = find_recent_sale_added('5')
?>

<?php include_once('layouts/header.php'); ?>

<br>
<div class="row">
  <div class="col-md-6">
    <?php echo display_msg($msg); ?>
  </div>
</div>
<div class="row">
  <div class="col-md-3">
    <div class="panel panel-box clearfix">
      <div class="panel-icon pull-left bg-green">
        <i class="glyphicon glyphicon-user"></i>
      </div>
      <div class="panel-value pull-right">
        <h2 class="margin-top"> <?php  echo $c_user['total']; ?> </h2>
        <p class="text-muted">Usuarios</p>
      </div>
    </div>
  </div>
  <div class="col-md-3">
    <div class="panel panel-box clearfix">
      <div class="panel-icon pull-left bg-red">
        <i class="glyphicon glyphicon-list"></i>
      </div>
      <div class="panel-value pull-right">
        <h2 class="margin-top"> <?php  echo $c_categorie['total']; ?> </h2>
        <p class="text-muted">Categorías</p>
      </div>
    </div>
  </div>
  <div class="col-md-3">
    <div class="panel panel-box clearfix">
      <div class="panel-icon pull-left bg-blue">
        <i class="glyphicon glyphicon-shopping-cart"></i>
      </div>
      <div class="panel-value pull-right">
        <h2 class="margin-top"> <?php  echo $c_product['total']; ?> </h2>
        <p class="text-muted">Productos</p>
      </div>
    </div>
  </div>
  <div class="col-md-3">
    <div class="panel panel-box clearfix">
      <div class="panel-icon pull-left bg-yellow">
        <i class="glyphicon glyphicon-usd"></i>
      </div>
      <div class="panel-value pull-right">
        <h2 class="margin-top"> <?php  echo $c_sale['total']; ?></h2>
        <p class="text-muted">Ventas</p>
      </div>
    </div>
  </div>
</div>
<br><br>
<div class="row">
  <div class="col-md-4">
    <div class="panel panel-default">
      <div class="panel-heading">
        <strong>
          <span class="glyphicon glyphicon-th"></span>
          <span>Productos más vendidos</span>
        </strong>
      </div>
      <div class="panel-body">
        <table class="table table-striped table-condensed">
          <thead>
            <tr>
              <th class="text-center">Descripción</th>
              <th class="text-center">Nº Ventas</th>
              <th class="text-center">Cant. vendida</th>
            <tr>
          </thead>
          <tbody>
            <?php foreach ($products_sold as  $product_sold): ?>
              <tr>
                <td><?php echo remove_junk(first_character($product_sold['name'])); ?></td>
                <td class="text-center"><?php echo (int)$product_sold['totalSold']; ?></td>
                <td class="text-center"><?php echo (int)$product_sold['totalQty']; ?></td>
              </tr>
            <?php endforeach; ?>
          <tbody>
        </table>
      </div>
    </div>
  </div>
  <div class="col-md-4">
    <div class="panel panel-default">
      <div class="panel-heading">
        <strong>
          <span class="glyphicon glyphicon-th"></span>
          <span>ÚLTIMAS VENTAS</span>
        </strong>
      </div>
      <div class="panel-body">
        <table class="table table-striped table-condensed">
          <thead>
            <tr>
              <th class="text-center" style="width: 50px;">#</th>
              <th class="text-center">Descripción</th>
              <th class="text-center">Fecha</th>
              <th class="text-center">Venta</th>
            </tr>
          </thead>
          <tbody>
            <?php foreach ($recent_sales as  $recent_sale): ?>
            <tr>
              <td class="text-center"><?php echo count_id();?></td>
              <td>
              <a href="edit_sale.php?id=<?php echo (int)$recent_sale['id']; ?>">
                <?php echo remove_junk(first_character($recent_sale['name'])); ?>
              </a>
              </td>
              <td class="text-center"><?php echo remove_junk(ucfirst($recent_sale['date'])); ?></td>
              <td class="text-center">$<?php echo remove_junk(first_character($recent_sale['price'])); ?></td>
            </tr>
            <?php endforeach; ?>
          </tbody>
        </table>
      </div>
    </div>
  </div>
  <div class="col-md-4">
    <div class="panel panel-default">
      <div class="panel-heading">
        <strong>
          <span class="glyphicon glyphicon-th"></span>
          <span>Productos recientemente añadidos</span>
        </strong>
      </div>
      <div class="panel-body">
        <div class="list-group" style="border: none; !important">
          <?php foreach ($recent_products as  $recent_product): ?>
            <a class="list-group-item clearfix" style="border: none; border-top: 0.5px solid #dbdbdb; border-bottom: 0.5px solid #dbdbdb;" href="edit_product.php?id=<?php echo    (int)$recent_product['id'];?>">
              <h5 class="list-group-item-heading"><b>
                <?php echo remove_junk(first_character($recent_product['name']));?>
                <span class="label label-warning pull-right">
                  $<?php echo (int)$recent_product['sale_price']; ?>
                </span>
              </b></h5>
              <span class="list-group-item-text pull-right">
                <?php echo remove_junk(first_character($recent_product['categorie'])); ?>
              </span>
            </a>
          <?php endforeach; ?>
        </div>
      </div>
    </div>
  </div>
</div>

<?php include_once('layouts/footer.php'); ?>