function __construct($title = '')
{
preg_match('@/plugins/(.*)/report/(.*)/@', $_SERVER['SCRIPT_NAME'], $regs);
$this->plug = $regs[1];
$this->name = $regs[2];
includeLocales($this->name, $this->plug);
$this->setTitle($title);
}
/**
* Search for reports in all activated plugins
*
* @return tab : an array which contains all the reports found (name => plugin)
**/
function searchReport()
{
global $DB;
$tab = array();
foreach ($DB->request('glpi_plugins', array('state' => Plugin::ACTIVATED)) as $plug) {
foreach (glob(GLPI_ROOT . '/plugins/' . $plug['directory'] . '/report/*', GLOB_ONLYDIR) as $path) {
$tab[basename($path)] = $plug['directory'];
includeLocales(basename($path), $plug['directory']);
}
}
return $tab;
}
(at your option) any later version.
reports 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 reports. If not, see <http://www.gnu.org/licenses/>.
--------------------------------------------------------------------------
*/
$USEDBREPLICATE = 1;
$DBCONNECTION_REQUIRED = 0;
// Not really a big SQL request
include "../../../../inc/includes.php";
includeLocales("equipmentbygroups");
//TRANS: The name of the report = List all devices of a group, ordered by users
Html::header(__('equipmentbygroups_report_title', 'reports'), $_SERVER['PHP_SELF'], "utils", "report");
Report::title();
if (isset($_GET["reset_search"])) {
resetSearch();
}
$_GET = getValues($_GET, $_POST);
displaySearchForm();
$sql = "SELECT `id` AS group_id,\n `name` AS group_name\n FROM `glpi_groups`\n WHERE `entities_id` = " . $_SESSION["glpiactive_entity"] . (isset($_GET["groups_id"]) && $_GET["groups_id"] ? " AND `glpi_groups`.`id` = " . $_GET["groups_id"] : "") . "\n ORDER BY `name`";
$result = $DB->query($sql);
$last_group_id = -1;
while ($datas = $DB->fetch_array($result)) {
if ($last_group_id != $datas["group_id"]) {
echo "<table class='tab_cadre' cellpadding='5'>";
echo "<tr><th>" . sprintf(__('%1$s: %2$s'), __('Group'), $datas['group_name']) . "</th></th></tr>";
reports 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 reports. If not, see <http://www.gnu.org/licenses/>.
--------------------------------------------------------------------------
*/
// Original Author of file: Benoit Machiavello
// ----------------------------------------------------------------------
$USEDBREPLICATE = 1;
$DBCONNECTION_REQUIRED = 1;
// Really a big SQL request
include "../../../../inc/includes.php";
includeLocales("histohard");
plugin_reports_checkRight('reports', "histohard", "r");
$computer = new Computer();
$computer->checkGlobal('r');
//TRANS: The name of the report = History of last hardware's installations
Html::header(__("histohard_report_title", 'reports'), $_SERVER['PHP_SELF'], "utils", "report");
Report::title();
echo "<div class='center'>";
echo "<table class='tab_cadrehov'>\n";
echo "<tr class='tab_bg_1 center'>" . "<th colspan='5'>" . __("History of last hardware's installations", 'reports') . "</th></tr>\n";
echo "<tr><th>" . __('Date of inventory', 'reports') . "</th>" . "<th>" . __('User') . "</th>" . "<th>" . __('Network device') . "</th>" . "<th>" . __(-'Field') . "</th>" . "<th>" . __('Modification', 'reports') . "</th></tr>\n";
$sql = "SELECT `glpi_logs`.`date_mod` AS dat, `linked_action`, `itemtype`, `itemtype_link`,\n `old_value`, `new_value`, `glpi_computers`.`id` AS cid, `name`, `user_name`\n FROM `glpi_logs`\n LEFT JOIN `glpi_computers` ON (`glpi_logs`.`items_id` = `glpi_computers`.`id`)\n WHERE `glpi_logs`.`date_mod` > DATE_SUB(Now(), INTERVAL 21 DAY)\n AND `itemtype` = 'Computer'\n AND `linked_action` IN (" . Log::HISTORY_CONNECT_DEVICE . ",\n " . Log::HISTORY_DISCONNECT_DEVICE . ",\n " . Log::HISTORY_DELETE_DEVICE . ",\n " . Log::HISTORY_UPDATE_DEVICE . ",\n " . Log::HISTORY_ADD_DEVICE . ")\n AND `glpi_computers`.`entities_id` = '" . $_SESSION["glpiactive_entity"] . "'\n ORDER BY `glpi_logs`.`id` DESC\n LIMIT 0,100";
$result = $DB->query($sql);
$prev = "";
$class = "tab_bg_2";
while ($data = $DB->fetch_array($result)) {
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 reports. If not, see <http://www.gnu.org/licenses/>.
--------------------------------------------------------------------------
*/
// Original Author of file: Remi Collet
// Purpose of file:
// ----------------------------------------------------------------------
$USEDBREPLICATE = 1;
$DBCONNECTION_REQUIRED = 1;
// Really a big SQL request
include "../../../../inc/includes.php";
includeLocales("histoinst");
plugin_reports_checkRight('reports', "histoinst", "r");
$computer = new Computer();
$computer->checkGlobal('r');
$software = new Software();
$software->checkGlobal('r');
//TRANS: The name of the report = History of last software's installations
Html::header(__('histoinst_report_title', 'reports'), $_SERVER['PHP_SELF'], "utils", "report");
Report::title();
echo "<div class='center'>";
echo "<table class='tab_cadrehov' cellpadding='5'>\n";
echo "<tr class='tab_bg_1 center'>" . "<th colspan='4'>" . __("History of last software's installations", "reports") . "</th></tr>\n";
echo "<tr class='tab_bg_2'><th>" . __('Date of inventory', 'reports') . "</th>" . "<th>" . __('User') . "</th>" . "<th>" . __("Computer's name") . "</th>" . "<th>" . sprintf(__('%1$s (%2$s)'), _n('Software', 'Software', 1), __('version')) . "</th></tr>\n";
$sql = "SELECT a.`date_mod` AS dat, a.`new_value`, `glpi_computers`.`id` AS cid, `name`,\n a.`user_name`\n FROM (SELECT `date_mod`, `new_value`, `user_name`, `items_id`, `id`\n FROM `glpi_logs`\n WHERE `glpi_logs`.`date_mod` > DATE_SUB(Now(), INTERVAL 21 DAY)\n AND `linked_action` = '" . Log::HISTORY_INSTALL_SOFTWARE . "'\n AND `itemtype` = 'Computer') a\n LEFT JOIN `glpi_computers` ON (a.`items_id` = `glpi_computers`.`id`)\n WHERE `glpi_computers`.`entities_id` = '" . $_SESSION["glpiactive_entity"] . "'\n ORDER BY a.`id` DESC\n LIMIT 0,200";
$result = $DB->query($sql);
$prev = "";
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
reports 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 reports. If not, see <http://www.gnu.org/licenses/>.
--------------------------------------------------------------------------
*/
//***********************REQUETES À REVOIR********************************
//*************************************************************************
include "../../../../inc/includes.php";
includeLocales("doublons");
plugin_reports_checkRight('reports', "doublons", "r");
$computer = new Computer();
$computer->checkGlobal('r');
//TRANS: The name of the report = Duplicate computers
Html::header(__('doublons_report_title', 'report'), $_SERVER['PHP_SELF'], "utils", "report");
Report::title();
$crits = array(0 => Dropdown::EMPTY_VALUE, 1 => __('Name'), 2 => __('Model') . " + " . __('Serial number'), 3 => __('Name') . " + " . __('Model') . " + " . __('Serial number'), 4 => __('MAC address'), 5 => __('IP address'), 6 => __('Inventory number'));
if (isset($_GET["crit"])) {
$crit = $_GET["crit"];
} else {
if (isset($_POST["crit"])) {
$crit = $_POST["crit"];
} else {
if (isset($_SESSION['plugin_reports_doublons_crit'])) {
$crit = $_SESSION['plugin_reports_doublons_crit'];
