dashboard.php

<?php
require_once('includes/load.php');

$page_title = 'Dashboard';
// Checkin What level user has permission to view this page
page_require_level(2);

$c_equipment     = count_by_id('equipments');
$c_transfer       = count_by_id('transfers');
$c_sector          = count_by_id('sectors');
$c_user          = count_by_id('users');

$pieChartEquipmentPerTyperEquip = pieChartEquipmentPerTyperEquip();
$barChartLoansPerSector = barChartLoanPerSector();
$horizontalBarChartEquipmentPerManufacturer = horizontalBarChartEquipmentPerManufacturer();
$pieChartEquipmentPerSituation = pieChartEquipmentPerSituation();

$recent_equipments    = find_recent_equipment_added('5');
$recent_transfers    = find_recent_transfer_added('5');

?>
<?php include_once('layouts/header.php'); ?>
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.9.3/Chart.bundle.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.9.3/Chart.min.css"/>

<div class="row">
  <div class="col-md-6">
    <?= 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"> <?= $c_user['total']; ?> </h2>
        <p class="text-muted">Usuários</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-th-large"></i>
      </div>
      <div class="panel-value pull-right">
        <h2 class="margin-top"> <?= $c_equipment['total']; ?> </h2>
        <p class="text-muted">Equipamentos</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-random"></i>
      </div>
      <div class="panel-value pull-right">
        <h2 class="margin-top"> <?= $c_transfer['total']; ?> </h2>
        <p class="text-muted">Transferências</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-object-align-vertical"></i>
      </div>
      <div class="panel-value pull-right">
        <h2 class="margin-top"> <?= $c_sector['total']; ?></h2>
        <p class="text-muted">Setores</p>
      </div>
    </div>
  </div>
</div>
<hr>
<!-- Charts -->
<div class="row" style="background-color:white">
  <div>
    <div class="col-md-7">
      <canvas id="pieChart" width="500" height="200"></canvas>
    </div>
    <div class="col-md-5">
      <canvas id="barChart" width="300" height="200"></canvas>
    </div>
  </div>
</div>
<hr>
<div class="row" style="background-color:white">
  <div>
    <div class="col-md-5">
      <canvas id="horizontalBar" width="300" height="200"></canvas>
    </div>
    <div class="col-md-7">
      <canvas id="doughnutChart" width="500" height="200"></canvas>      
    </div>
  </div>
</div>
<!-- /Charts -->
<hr>

<div class="row">   
  <div class="col-md-6">
    <div class="panel panel-default">
      <div class="panel-heading">
        <strong>
          <span class="glyphicon glyphicon-th"></span>
          <span>Equipamentos adicionados recentemente</span>
        </strong>
      </div>
      <div class="panel-body">
        <table class="table table-striped table-bordered table-condensed">
          <thead>
            <tr>
              <th>Tombo</th>
              <th>Especificações</th>
            </tr>
          </thead>
          <tbody>
            <?php foreach ($recent_equipments as  $r_e): ?>
              <tr>
                <td><?= remove_junk(first_character($r_e['tombo'])); ?></td>
                <td><?= remove_junk(ucfirst($r_e['specifications'])); ?></td>
              </tr>

            <?php endforeach; ?>
          </tbody>
        </table>
      </div>
    </div>
  </div>
  <div class="col-md-6">
    <div class="panel panel-default">
      <div class="panel-heading">
        <strong>
          <span class="glyphicon glyphicon-th"></span>
          <span>Transferências feitas recentemente</span>
        </strong>
      </div>
      <div class="panel-body">
        <table class="table table-striped table-bordered table-condensed">
          <thead>
            <tr>
              <th>Tombo</th>
              <th>Tipo de equipamento</th>
              <th>Usuário Responsável</th>
            </tr>
          </thead>
          <tbody>
            <?php foreach ($recent_transfers as  $recent_transfer): ?>
              <tr>
                <td><?= remove_junk(first_character($recent_transfer['tombo'])); ?></td>
                <td><?= remove_junk(ucfirst($recent_transfer['type_equip'])); ?></td>
                <td><?= remove_junk(first_character($recent_transfer['responsible_user'])); ?></td>
              </tr>

            <?php endforeach; ?>
          </tbody>
        </table>
      </div>
    </div>
  </div>
</div> 


<script>
// pie chart
var ctx = document.getElementById('pieChart');
var myChart = new Chart(ctx, {
  type: 'pie',
  data: {
    labels: [
    <?php foreach ($pieChartEquipmentPerTyperEquip as $count_type_equip): ?>
      "<?= $count_type_equip['name'] ?>",
    <?php endforeach; ?>
    ],
    datasets: [{
      label: 'Tipo de Equipamento',
      data: [
      <?php foreach ($pieChartEquipmentPerTyperEquip as $count_type_equip): ?>
        "<?= $count_type_equip['count'] ?>",
      <?php endforeach; ?>
      ],              
      backgroundColor: [
      <?php foreach ($pieChartEquipmentPerTyperEquip as $count_type_equip):
        $rand1 = mt_rand(0, 255); $rand2 = mt_rand(0, 255); $rand3 = mt_rand(0, 255); ?>
        '<?= "rgba($rand1, $rand2, $rand3)" ?>',
      <?php endforeach; ?>
      ]

    }]
  },
});

// bar chart
var ctx = document.getElementById('barChart');
var myChart = new Chart(ctx, {
  type: 'bar',
  data: {
    labels: [
    <?php foreach ($barChartLoansPerSector as $count_sector): ?>
      "<?= $count_sector['name'] ?>",
    <?php endforeach; ?>
    ],
    datasets: [{
      label: 'Transferências por Setor',
      data: [
      <?php foreach ($barChartLoansPerSector as $count_sector): ?>
        "<?= $count_sector['count'] ?>",
      <?php endforeach; ?>
      ],
      backgroundColor: [
      <?php foreach ($barChartLoansPerSector as $count_sector):
        $rand1 = mt_rand(0, 255); $rand2 = mt_rand(0, 255); $rand3 = mt_rand(0, 255); ?>
        '<?= "rgba($rand1, $rand2, $rand3)" ?>',
      <?php endforeach; ?>
      ]
    }]
  },
  options: {
    scales: {
      yAxes: [{
        ticks: {
          beginAtZero: true
        }
      }]
    }
  }
});

// bar horizontal chart
new Chart(document.getElementById("horizontalBar"), {
  type: "horizontalBar",
  data: {
    labels: [
    <?php foreach ($horizontalBarChartEquipmentPerManufacturer as $count_manufacturer): ?>
      "<?= $count_manufacturer['name'] ?>",
    <?php endforeach; ?>
    ],
    datasets: [{
      label: "Equipamentos por Fabricante",
      data: [
        <?php foreach ($horizontalBarChartEquipmentPerManufacturer as $count_manufacturer): ?>
          "<?= $count_manufacturer['count'] ?>",
        <?php endforeach; ?>
      ],
      fill: false,
      backgroundColor: [
        <?php foreach ($horizontalBarChartEquipmentPerManufacturer as $count_manufacturer):
          $rand1 = mt_rand(0, 255); $rand2 = mt_rand(0, 255); $rand3 = mt_rand(0, 255); ?>
          '<?= "rgba($rand1, $rand2, $rand3)" ?>',
        <?php endforeach; ?>      
    ],
      "borderWidth": 1
    }]
  },
    "options": {
      "scales": {
      "xAxes": [{
        "ticks": {
          "beginAtZero": true
        }
      }]
    }
  }
});

// doughnut chart
var ctxD = document.getElementById("doughnutChart").getContext('2d');
var myLineChart = new Chart(ctxD, {
  type: 'doughnut',
  data: {
    labels: [
    <?php foreach ($pieChartEquipmentPerSituation as $count_situation): ?>
      "<?= $count_situation['name'] ?>",
    <?php endforeach; ?>
    ],
    datasets: [{
      data: [
      <?php foreach ($pieChartEquipmentPerSituation as $count_situation): ?>
        "<?= $count_situation['count'] ?>",
      <?php endforeach; ?>
      ],              
      backgroundColor: [
      <?php foreach ($pieChartEquipmentPerSituation as $count_situation):
        $rand1 = mt_rand(0, 255); $rand2 = mt_rand(0, 255); $rand3 = mt_rand(0, 255); ?>
        '<?= "rgba($rand1, $rand2, $rand3)" ?>',
      <?php endforeach; ?>
      ]
    }]
  },
  options: {
    responsive: true
  }
});
</script>

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