yllen / reports Goto Github PK
View Code? Open in Web Editor NEWAdditional reports
License: GNU Affero General Public License v3.0
reports's People
Contributors
Stargazers
Watchers
reports's Issues
Envoi par mail, Notification
Bonjour
Y aurait-il un moyen, un peu comme 'more reporting', d'envoyer des reports de maniere automatique ?
Merci
Ajout de filtres : action que vous avez realisee n est pas autorisee
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...
Error on generating "Applications by locations and versions" report
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)?
Error on generating the "Number of equipments by location" report
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)?
EVO ? : Lien avec autre script
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
Dropdown Multiple
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
Error on generating "Licenses by expiration date" report
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)?
Temps erroné après export [Wrong time after export]
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?
Cordialement
1.16 not compatible with GLPI 10.1
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
Report for actualtime download from Marketplace reference to non actualtime plugin folder
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:
Error on generating the "Printers" report
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)?
Presenter 2 (ou plus ?) reports sur un meme report
Bonjour
plusieurs cas :
- soit les reports existent déja et auquel cas comment 'enchainer' dans un report global les 'n' reports que l'on souhaite afficher.
- soit constituer avec 'n' requetes nouvelles un "nouveau report" pour lequel les requetes s'enchainent et presentation de 'n' reports
-> volonté de pouvoir présenter des tableaux croisés dynamiques à l'issu d'un rapport initial -> reformater les données (cumuls etc)
Getorderby
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
Error on generating "Location tree" report
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)?
Plugin Reports 1.14.1 - Probleme date
tracking hw changes?
Hello, with this plugin is possible to track item fields changes?
for example if I manually change group field in a computer
INFO : Contenu html
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
GLPI 10 compatibility
Hi!
GLPI 10 stable it's just around the corner, have you plans to bring compatibility to reports plugin?
Reports are shown only after logon/logoff
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.
Print view could shows only the result instead of the full form query
At the image below, I'm attempting to print a report:
I'd like to print only the result (red square) but the crits form is also shown. I'm using the droublons.php (Duplicated computers) report for this example.
Documentation
User/developer plugin documentation is missing.
- Create file names (locales,stat,report,config)
- functions, classes (description, parameters)
...
Evo : Un filtre saisi mais peut-etre 'n' champs à filtrer sur cette valeur
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
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.