yllen / reports Goto Github PK
View Code? Open in Web Editor NEWAdditional reports
License: GNU Affero General Public License v3.0
Additional reports
License: GNU Affero General Public License v3.0
When trying to generate the "Licenses by expiration date" report, the following errors are shown at the page and the report isn't generated:
Warning: mysqli::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 363
Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 367
Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 372
Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 372
Warning: DBmysql::fetchQueryWarnings(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 1913
The following errors are thrown at <GLPI_ROOT>\files\_log\php-errors.log
:
[2022-12-06 15:34:51] glpiphplog.WARNING: *** PHP Warning (2): mysqli::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 363
Backtrace :
src/DBmysql.php:363 mysqli->query()
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...s/report/licensesexpires/licensesexpires.php:78 PluginReportsAutoReport->execute()
[2022-12-06 15:34:51] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 367
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...s/report/licensesexpires/licensesexpires.php:78 PluginReportsAutoReport->execute()
[2022-12-06 15:34:51] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 372
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...s/report/licensesexpires/licensesexpires.php:78 PluginReportsAutoReport->execute()
[2022-12-06 15:34:51] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 372
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...s/report/licensesexpires/licensesexpires.php:78 PluginReportsAutoReport->execute()
[2022-12-06 15:34:51] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::fetchQueryWarnings(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 1913
Backtrace :
src/DBmysql.php:385 DBmysql->fetchQueryWarnings()
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...s/report/licensesexpires/licensesexpires.php:78 PluginReportsAutoReport->execute()
The following error are thrown at <GLPI_ROOT>\files\_log\sql-errors.log
:
[2022-12-06 15:34:51] glpisqllog.ERROR: DBmysql::query() in /home/robertinho/public_html/glpi/src/DBmysql.php line 370
*** MySQL query error:
SQL: SELECT COUNT(*) AS count FROM `glpi_users` LEFT JOIN `glpi_profiles_users` ON (`glpi_profiles_users`.`users_id` = `glpi_users`.`id`) WHERE `glpi_users`.`id` = '14' AND `glpi_users`.`is_active` = '1' AND `glpi_users`.`is_deleted` = '0' AND `glpi_profiles_users`.`profiles_id` = '4' AND (`glpi_profiles_users`.`entities_id` = '0')
Error:
Backtrace :
src/DBmysqlIterator.php:112
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...s/report/licensesexpires/licensesexpires.php:78 PluginReportsAutoReport->execute()
{"user":"[email protected]"}
I'm using GLPI 10.0.5 and there's no License right now at my GLPI instance, but it will gonna have into the future.
When I'd run the query through PHPMyAdmin it runs successfully, so I believe that the SELECT COUNT
query isn't allowed through the DBmysqlIterator
or maybe some problem related to the entities permission (#18)?
Bonjour
Y aurait-il un moyen, un peu comme 'more reporting', d'envoyer des reports de maniere automatique ?
Merci
In the GLPI reports plugin this shows up as
PHP Deprecated function (8192): Creation of dynamic property PluginReportsAutoReport::$plug is deprecated in /var/www/html/glpi/plugins/reports/inc/autoreport.class.php at line 57
reports/inc/autoreport.class.php
Line 57 in 79bf1d9
See
https://stackoverflow.com/questions/74991682/php-8-2-dynamic-properties-deprecated-how-to-use-them-anyway-in-a-compatible-wa
for possible solutions. The options are to rework the class to not use dynamic properties, to extend stdClass, or to add an attribute.
Support will be dropped in PHP9, apparently, but that's not on the PHP version support grid yet https://www.php.net/supported-versions.php
I'd like to submit a PR, but I don't think I'm likely to do that any time soon, as I don't know the plugin code (or GLPI, for that matter) well enough.
I'm using GLPI 10.0.5 and I'm receiving the following error when attempting to generate the "Printers" report:
PHP error log:
[06-Dec-2022 17:11:00 America/Sao_Paulo] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 363
[06-Dec-2022 17:11:00 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 367
[06-Dec-2022 17:11:00 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 372
[06-Dec-2022 17:11:00 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 372
[06-Dec-2022 17:11:00 America/Sao_Paulo] PHP Warning: DBmysql::fetchQueryWarnings(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 1913
php-errors.log
:
[2022-12-06 17:11:00] glpiphplog.WARNING: *** PHP Warning (2): mysqli::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 363
Backtrace :
src/DBmysql.php:363 mysqli->query()
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/printers/printers.php:129 PluginReportsAutoReport->execute()
[2022-12-06 17:11:00] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 367
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/printers/printers.php:129 PluginReportsAutoReport->execute()
[2022-12-06 17:11:00] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 372
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/printers/printers.php:129 PluginReportsAutoReport->execute()
[2022-12-06 17:11:00] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 372
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/printers/printers.php:129 PluginReportsAutoReport->execute()
[2022-12-06 17:11:00] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::fetchQueryWarnings(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 1913
Backtrace :
src/DBmysql.php:385 DBmysql->fetchQueryWarnings()
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/printers/printers.php:129 PluginReportsAutoReport->execute()
sql-errors.log
:
[2022-12-06 17:11:00] glpisqllog.ERROR: DBmysql::query() in /home/robertinho/public_html/glpi/src/DBmysql.php line 370
*** MySQL query error:
SQL: SELECT COUNT(*) AS count FROM `glpi_users` LEFT JOIN `glpi_profiles_users` ON (`glpi_profiles_users`.`users_id` = `glpi_users`.`id`) WHERE `glpi_users`.`id` = '14' AND `glpi_users`.`is_active` = '1' AND `glpi_users`.`is_deleted` = '0' AND `glpi_profiles_users`.`profiles_id` = '4' AND (`glpi_profiles_users`.`entities_id` = '0')
Error:
Backtrace :
src/DBmysqlIterator.php:112
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/printers/printers.php:129 PluginReportsAutoReport->execute()
{"user":"[email protected]"}
When I'd run the query through PHPMyAdmin it runs successfully, so I believe that the SELECT COUNT
query isn't allowed through the DBmysqlIterator
or maybe some problem related to the entities permission (#18)?
I'm using GLPI 10.0.5 and when attempting to generate the "Location tree" report I'm receiving the following errors:
PHP error log:
[06-Dec-2022 16:58:58 America/Sao_Paulo] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 363
[06-Dec-2022 16:58:58 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 367
[06-Dec-2022 16:58:58 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 372
[06-Dec-2022 16:58:58 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 372
[06-Dec-2022 16:58:58 America/Sao_Paulo] PHP Warning: DBmysql::fetchQueryWarnings(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 1913
php-errors.log
:
[2022-12-06 16:58:58] glpiphplog.WARNING: *** PHP Warning (2): mysqli::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 363
Backtrace :
src/DBmysql.php:363 mysqli->query()
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/location/location.php:59 PluginReportsAutoReport->execute()
[2022-12-06 16:58:58] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 367
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/location/location.php:59 PluginReportsAutoReport->execute()
[2022-12-06 16:58:58] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 372
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/location/location.php:59 PluginReportsAutoReport->execute()
[2022-12-06 16:58:58] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 372
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/location/location.php:59 PluginReportsAutoReport->execute()
[2022-12-06 16:58:58] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::fetchQueryWarnings(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 1913
Backtrace :
src/DBmysql.php:385 DBmysql->fetchQueryWarnings()
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/location/location.php:59 PluginReportsAutoReport->execute()
sql-errors.log
:
[2022-12-06 16:58:58] glpisqllog.ERROR: DBmysql::query() in /home/robertinho/public_html/glpi/src/DBmysql.php line 370
*** MySQL query error:
SQL: SELECT COUNT(*) AS count FROM `glpi_users` LEFT JOIN `glpi_profiles_users` ON (`glpi_profiles_users`.`users_id` = `glpi_users`.`id`) WHERE `glpi_users`.`id` = '14' AND `glpi_users`.`is_active` = '1' AND `glpi_users`.`is_deleted` = '0' AND `glpi_profiles_users`.`profiles_id` = '4' AND (`glpi_profiles_users`.`entities_id` = '0')
Error:
Backtrace :
src/DBmysqlIterator.php:112
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/location/location.php:59 PluginReportsAutoReport->execute()
{"user":"[email protected]"}
When I'd run the query through PHPMyAdmin it runs successfully, so I believe that the SELECT COUNT
query isn't allowed through the DBmysqlIterator
or maybe some problem related to the entities permission (#18)?
Hi
I need to try the latest nightly build of GLPI to check if a problem is resolved, but your plugin will not install
This plugin requires GLPI >= 10.0.0 and < 10.1.0
Also, I would like to create my own custom report. Please can you advise what steps i need to perform to register my own reports.
Thanks
Bonjour
plusieurs cas :
-> volonté de pouvoir présenter des tableaux croisés dynamiques à l'issu d'un rapport initial -> reformater les données (cumuls etc)
I'm using GLPI 10.0.5 and the following error is being thrown when attempting to generate the "Number of equipments by location" report:
[06-Dec-2022 16:50:11 America/Sao_Paulo] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 363
[06-Dec-2022 16:50:11 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 367
[06-Dec-2022 16:50:11 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 372
[06-Dec-2022 16:50:11 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 372
[06-Dec-2022 16:50:11 America/Sao_Paulo] PHP Warning: DBmysql::fetchQueryWarnings(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 1913
php-errors.log
:
[2022-12-06 16:50:11] glpiphplog.WARNING: *** PHP Warning (2): mysqli::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 363
Backtrace :
src/DBmysql.php:363 mysqli->query()
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...equipmentbylocation/equipmentbylocation.php:116 PluginReportsAutoReport->execute()
[2022-12-06 16:50:11] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 367
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...equipmentbylocation/equipmentbylocation.php:116 PluginReportsAutoReport->execute()
[2022-12-06 16:50:11] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 372
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...equipmentbylocation/equipmentbylocation.php:116 PluginReportsAutoReport->execute()
[2022-12-06 16:50:11] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 372
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...equipmentbylocation/equipmentbylocation.php:116 PluginReportsAutoReport->execute()
[2022-12-06 16:50:11] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::fetchQueryWarnings(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 1913
Backtrace :
src/DBmysql.php:385 DBmysql->fetchQueryWarnings()
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...equipmentbylocation/equipmentbylocation.php:116 PluginReportsAutoReport->execute()
sql-errors.log
:
[2022-12-06 16:50:11] glpisqllog.ERROR: DBmysql::query() in /home/robertinho/public_html/glpi/src/DBmysql.php line 370
*** MySQL query error:
SQL: SELECT COUNT(*) AS count FROM `glpi_users` LEFT JOIN `glpi_profiles_users` ON (`glpi_profiles_users`.`users_id` = `glpi_users`.`id`) WHERE `glpi_users`.`id` = '14' AND `glpi_users`.`is_active` = '1' AND `glpi_users`.`is_deleted` = '0' AND `glpi_profiles_users`.`profiles_id` = '4' AND (`glpi_profiles_users`.`entities_id` = '0')
Error:
Backtrace :
src/DBmysqlIterator.php:112
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...equipmentbylocation/equipmentbylocation.php:116 PluginReportsAutoReport->execute()
{"user":"[email protected]"}
When I'd run the query through PHPMyAdmin it runs successfully, so I believe that the SELECT COUNT
query isn't allowed through the DBmysqlIterator
or maybe some problem related to the entities permission (#18)?
User/developer plugin documentation is missing.
Bonjour
Version mysql 5.7.24
soit la table glpi_tickettasks (par exemple)
cette table comporte un champs content qui contient une données html : ok
je cree un report
et j'aimerais visualiser cette colonne avec le design qu'elle contient
en php on peut utiliser la fonction "htmlspecialchars_decode".
comment faire pour utiliser cette fonction dans le report ? ou peut etr eune fonction mysql (mais je n'ai pas trouvé)
Merci
Bonjour
J'ai un souci particulier
j'ai repris le coding d'un précédent report (qui fonctionne).
j'ai mis la nouvelle requete : elle fonctionne. ok
Je souhaite ajouter filtre (texte, et user)
et là, lorsque j'appuie sur le bouton 'recherche' j'obtiens un beau 'l'action que vous avez réalisée n'est pas autorisée'
ca doit etre un truc 'gros' comme une maison...
Bonjour
est-il possible de réaliser un filtre avec une selection multiple ?
ci-dessous, un seul choix est possible
$StatusTicket = array('----------','Nouveau','En cours (attribué)', 'En cours (planifié)', 'en attente', 'Resolu', 'Clos');
$selectionst = new PluginReportsArrayCriteria($report,'STSTICK','Status du ticket',$StatusTicket);
J'ai vu dans front/report.contract.php l'instruction dropdown qui permet de faire 'n' selections. (ici c'est sur el type de contrat, mais c'est sur le principe)
foreach ($CFG_GLPI["contract_types"] as $itemtype) {
if ($item = getItemForItemtype($itemtype)) {
$values[$itemtype] = $item->getTypeName();
}
}
Dropdown::showFromArray('item_type', $values, ['value' => 0,
'multiple' => true]);
Pourrait-on 'facilement' l'utiliser avec le plugin 'reports' ?
Ensuite, pouvoir renseigner certaines valeurs 'par defaut' dans ce dropdown ?
Merci
Hi!
GLPI 10 stable it's just around the corner, have you plans to bring compatibility to reports plugin?
Bonjour @yllen
La fonction PluginReportsColumnLink permet de faire un lien avec une table : ok
si on reprend les parametres on a 'champs du lien' 'titre de la colonne' 'table'
Est-il possible de faire un lien avec un autre script (autre autre report par exemple) ? ce report attendrait le parametre 'champs du lien'
exemple :
on a un report de groupe d'utilisateurs, et ensuite on fait lien pour visualiser des informations utilisateurs à l'aide d'un second report.
Dans le report maitre on aurait alors :
...\reports\report\report.php?id=userid
peut etre existe -t-il deja cette fonctionnalité ?
Merci
Bonjour,
je souhaite générer des rapports pour avoir le temps passé sur les tickets, mais après chaque export je me retrouve avec 1h ajoutée au temps de traitement.
Pouvez-vous m'aider ?
Hello,
I want to generate reports to get the time spent on tickets, but after each export I find myself with 1 hour added to the processing time.
Can you help me?
After changing the permission of a report for a profile that I belong, I had to logoff and logon again for the report to be shown at the Tools -> Report page.
I'm using GLPI 10.0.5.
I'm using GLPI 10.0.5 and the following errors are being thrown when attempting to generate the "Applications by locations and versions" report:
error_log
(PHP error log):
[06-Dec-2022 16:07:40 America/Sao_Paulo] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 363
[06-Dec-2022 16:07:40 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 367
[06-Dec-2022 16:07:40 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 372
[06-Dec-2022 16:07:40 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 372
[06-Dec-2022 16:07:40 America/Sao_Paulo] PHP Warning: DBmysql::fetchQueryWarnings(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 1913
php-errors.log
:
[2022-12-06 16:07:40] glpiphplog.WARNING: *** PHP Warning (2): mysqli::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 363
Backtrace :
src/DBmysql.php:363 mysqli->query()
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...ationsbylocation/applicationsbylocation.php:105 PluginReportsAutoReport->execute()
[2022-12-06 16:07:40] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 367
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...ationsbylocation/applicationsbylocation.php:105 PluginReportsAutoReport->execute()
[2022-12-06 16:07:40] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 372
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...ationsbylocation/applicationsbylocation.php:105 PluginReportsAutoReport->execute()
[2022-12-06 16:07:40] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 372
Backtrace :
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...ationsbylocation/applicationsbylocation.php:105 PluginReportsAutoReport->execute()
[2022-12-06 16:07:40] glpiphplog.WARNING: *** PHP Warning (2): DBmysql::fetchQueryWarnings(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php at line 1913
Backtrace :
src/DBmysql.php:385 DBmysql->fetchQueryWarnings()
src/DBmysqlIterator.php:112 DBmysql->query()
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...ationsbylocation/applicationsbylocation.php:105 PluginReportsAutoReport->execute()
sql-errors.log
:
[2022-12-06 16:07:40] glpisqllog.ERROR: DBmysql::query() in /home/robertinho/public_html/glpi/src/DBmysql.php line 370
*** MySQL query error:
SQL: SELECT COUNT(*) AS count FROM `glpi_users` LEFT JOIN `glpi_profiles_users` ON (`glpi_profiles_users`.`users_id` = `glpi_users`.`id`) WHERE `glpi_users`.`id` = '14' AND `glpi_users`.`is_active` = '1' AND `glpi_users`.`is_deleted` = '0' AND `glpi_profiles_users`.`profiles_id` = '4' AND (`glpi_profiles_users`.`entities_id` = '0')
Error:
Backtrace :
src/DBmysqlIterator.php:112
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
...ationsbylocation/applicationsbylocation.php:105 PluginReportsAutoReport->execute()
{"user":"[email protected]"}
When I'd run the query through PHPMyAdmin it runs successfully, so I believe that the SELECT COUNT
query isn't allowed through the DBmysqlIterator
or maybe some problem related to the entities permission (#18)?
Hi, A reference from this ticket in another plugin, I don't know where is the problem, so I open a new one here. ticgal/actualtime#96
The case is when I replaced in the URL the string from "plugins" to "marketplace", the following error is show up:
Hello, with this plugin is possible to track item fields changes?
for example if I manually change group field in a computer
Bonjour
Dans les colonnes de report on peut ajouter des tris : ok.
Soit 5 colonnes dans un report (Numéro cde, Description, creation, NumLigne, etat)
3 d'entre elles sont triées (sorton activé : Numéro cde, Creation et numligne), mais 2 sont liées (Clé principale numero cde et l'autre secondaire numligne)
Comment peut on gérer cela dans le report ?
Merci
Bonjour
j'ai pu me debrouiller avec des getcriteria et donc construire la requete finale via des concatenations en OR, str_replace etc, mais existe t-il possibilité à partir d'un seul filtre de réaliser la requete sur 2 champs d'une table ?
Ex : filtre de type texte : ok
et en fait on veut rechercher (par la requete) des champs différents d'une (ou pleusieurs tables)
Merci
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.