admin-dashboard-stats.php

<?php
/***********************************************************
 Copyright (C) 2019 Orange

 This program is free software; you can redistribute it and/or
 modify it under the terms of the GNU General Public License
 version 2 as published by the Free Software Foundation.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.

 You should have received a copy of the GNU General Public License along
 with this program; if not, write to the Free Software Foundation, Inc.,
 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 ***********************************************************/

define("TITLE_DASHBOARD_STATISTICS", _("Statistics Dashboard"));

use Fossology\Lib\Db\DbManager;

class dashboardReporting extends FO_Plugin
{
  protected $pgVersion;

  private $dbManager;

  function __construct()
  {
    $this->Name       = "dashboard-statistics";
    $this->Title      = TITLE_DASHBOARD_STATISTICS;
    $this->MenuList   = "Admin::Dashboards::Statistics";
    $this->DBaccess   = PLUGIN_DB_ADMIN;
    parent::__construct();
    $this->dbManager = $GLOBALS['container']->get('db.manager');
  }

  function CountAllJobs()
  {
    $query = "SELECT ag.agent_name,ag.agent_desc,count(jq.*) AS fired_jobs ";
    $query.= "FROM agent ag LEFT OUTER JOIN jobqueue jq ON (jq.jq_type = ag.agent_name) ";
    $query.= "GROUP BY ag.agent_name,ag.agent_desc ORDER BY fired_jobs DESC;";

    $rows = $this->dbManager->getRows($query);

    $V = "<table border=1>";
    $V .= "<tr><th>".("AgentName")."</th><th>"._("Description")."</th><th>"._("Number of jobs")."</th></tr>";

    foreach ($rows as $agData) {
      $V .= "<tr><td>".$agData['agent_name']."</td><td>".$agData['agent_desc']."</td><td align='right'>".$agData['fired_jobs']."</td></tr>";
    }

    $V .= "</table>";

    return $V;
  }

  public function Output()
  {
      $V = "<h1> Statistics </h1>";
      $V .= "<table style='width: 100%;' border=0>\n";

      $V .= "<tr>";
      $V .= "<td class='dashboard'>";
      $text = _("Jobs Sumary");
      $V .= "<h2>$text</h2>\n";
      $V .= $this->CountAllJobs();
      $V .= "</td>";
      $V .= "</tr>";

      $V .= "</table>";

      return $V;
  }
}

$dash = new dashboardReporting ;
$dash->Initialize();