infotelglpi / badges Goto Github PK

Problem with searching with the map: Modification of searchoptions.

Hi,

This is not a properly named "bug" but I can't find the way for a badge request.
I don't know what I have to activate in order to let a user ask for a new badge.
Of course, I might end up ask them to open a new ticket claiming for a badge but as I can read "Badge requests" when watching a badge details, I'm curious.

And anyway, thanks a lot for the plugin, it is very useful.

Bye bye

SQL Error when "delay_expired" is not setup.

*** MySQL query error:
  SQL: SELECT * 
         FROM `glpi_plugin_badges_badges`
         WHERE `date_expiration` IS NOT NULL
         AND `is_deleted` = '0'
         AND DATEDIFF(CURDATE(),`date_expiration`) >  
         AND DATEDIFF(CURDATE(),`date_expiration`) > 0 AND `states_id` NOT IN (999999) 
  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND DATEDIFF(CURDATE(),`date_expiration`) > 0 AND `states_id` NOT IN (999999)' at line 6
  Backtrace :
  src/DBmysqlIterator.php:112                        
  src/DBmysql.php:1056                               DBmysqlIterator->execute()
  marketplace/badges/inc/badge.class.php:618         DBmysql->request()
  src/CronTask.php:1020                              PluginBadgesBadge::cronBadgesAlert()
  front/cron.php:83                                  CronTask::launch()
  ``

Hi,

The asset format is tar.gz which is not the standard, plugins from @pluginsGLPI are all with bz2 format.

It would help for integration if plugins could use the same standards of packaging. Deployment scripts could then be simplier.

What do you think about this ?

Regards,

The plugin appears but the error message as well when I start install.a

Incorrect integer value: '' for column 'id' at row 1

PHP Warning: Declaration of PluginBadgesBadgeInjection::getTable() should be compatible with CommonDBTM::getTable($classname = NULL)

Hi,
When trying to install plugin, after click "Install" button I'm getting: "Incorrect integer value: '' for column 'id' at row 1".
GLPI version 0.90 (updated from 0.85.5, where it was working like a charm)

• Version of the plugin : 2.6.0

• Version of your GLPI : 9.5.1

• Steps to reproduce (which actions have you made) :
  I manually create an identifier
  I made it associatable to a service = yes
  Reservation = yes

• Expected result :
  In Tools/Reservations the created identifier should appear and does not appear.

• Actual result :
  The created identifier does not appear in the reservations list

• URL of the page :
  n/a

• Screenshot of the problem (if pertinent) :
  
  

Hello,

• The version of the plugin. => 2.3.0
• The version of your GLPI => 9.2.1

I cannot add a badge to a user if the user has only one profile on a sub-entity.
I can only add a badge if the user has a profile on root entity.

When adding a new badge, the user doesn't appear in the drop-down menu.

Am I missing something ?

Thanks,

PHP Warning: Declaration of PluginBadgesBadgeInjection::getTable() should be compatible with CommonDBTM::getTable($classname = NULL)

Bonjour
Dans la version 2.2.0, lorsque l'on veut modifier (pour un badge déjà enregistré) la valeur de champ date de fin de validité, si je vide le champ et que j'enregistre il me remet le contenu du champ.

In both versions 1.9.0 and 2.0.0

The locale "badges which expires" is used both by the notification of the same name AND for the description of the automatic action 'BadgesAlert'.
I believe that the description of the auto action should better use the locale "badges expired or badges which expires", at least to be homogeneous with other plugins such as Accounts/Certificates.

Hello

Please, could you tell me how to add supplier field ? or add this fields in your plugin

Thank you

Bonjour, j'ai récemment installé le plugin BADGES, pour pouvoir gérer les badges d'accès.
Donc je crée mes badges, je dis que les badges sont réservables.
Mais quand je vais dans l'onglet RESERVATION, mes badges n'apparaissent pas .... Donc je ne peux pas effectuer de réservation de badges ....

Merci d'avance

• Version of the plugin : 3.0.0
• Version of your GLPI : 10.0
• Steps to reproduce (which actions have you made) : Trying to associate a "badge" to a "DataCenter" or a "Datacenter/room"
• Expected result : Being able to link a badge to a relevant item like room, rack, datacenter (even a computer or a printer)
• Actual result : Not possible

I think it makes sense to link badges to items the badge will give access.

I hope my request is clear enough.

Patrick

Note rights are not displayed

Du to GLPI modification

With GLPI 0.95 and simcard plugin v2.1.1, I cannot install the plugin : error during installation

``
2016-10-28 11:23:44 [6@linux01]
*** MySQL query error:
SQL: INSERT INTO 'glpi_notificationtemplates'('id', 'name', 'itemtype', 'date_mod', 'comment', 'css') VALUES ('','Access Badges Return','PluginBadgesBadge', NOW(),'','');

Error: Incorrect integer value: '' for column 'id' at row 1
Backtrace :
plugins/badges/hook.php:130
inc/plugin.class.php:661 plugin_badges_install()
: Plugin->install()
front/plugin.form.php:49 call_user_func()
``

I have bypassed the problem by edit hook.php, line 130 :

$query_id = "INSERT INTOglpi_notificationtemplates(name, itemtype, date_mod, comment, css) VALUES ('Access Badges Return','PluginBadgesBadge', NOW(),'','');";

Seems to be an old bug already resolved but back again...

i added this code and then everything work fine

{% if item.isField('is_bookable') %}
{{ fields.dropdownYesNo(
'is_bookable',
item.fields['is_bookable'],
__('Bookable')
) }}
{% endif %}

Bonjour

J'ai constaté avoir des erreurs SQL liées au plugin badges depuis que j'ai migré en GLPI 1.9.4, voici le log

2017-06-19 09:00:04 [@serveur]
*** MySQL query error:
SQL: SELECT *
FROM glpi_plugin_badges_badges
WHERE date_expiration IS NOT NULL
AND is_deleted = '0'
AND DATEDIFF(CURDATE(),date_expiration) > -
AND DATEDIFF(CURDATE(),date_expiration) < 0 AND states_id NOT IN (999999)
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND DATEDIFF(CURDATE(),date_expiration) < 0 AND states_id NOT IN (999999)' at line 6
Backtrace :
inc\dbmysql.class.php:872
inc\dbmysql.class.php:558 DBmysqlIterator->__construct()
plugins\badges\inc\badge.class.php:441 DBmysql->request()
: PluginBadgesBadge::cronBadgesAlert()
inc\crontask.class.php:832 call_user_func()
front\cron.php:88 CronTask::launch()
2017-06-19 09:00:04 [@serveur]
*** MySQL query error:
SQL: SELECT *
FROM glpi_plugin_badges_badges
WHERE date_expiration IS NOT NULL
AND is_deleted = '0'
AND DATEDIFF(CURDATE(),date_expiration) >
AND DATEDIFF(CURDATE(),date_expiration) > 0 AND states_id NOT IN (999999)
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND DATEDIFF(CURDATE(),date_expiration) > 0 AND states_id NOT IN (999999)' at line 6
Backtrace :
inc\dbmysql.class.php:872
inc\dbmysql.class.php:558 DBmysqlIterator->__construct()
plugins\badges\inc\badge.class.php:441 DBmysql->request()
: PluginBadgesBadge::cronBadgesAlert()
inc\crontask.class.php:832 call_user_func()
front\cron.php:88 CronTask::launch()

Hello,

I just have a question about the badge plugin. Are there any developments planned? If so it would be interesting to have a drop-down menu in order to be able to add several sites. For example, if you have sites in Paris, Lyon, Bordeaux and Marseille, you can select Paris and Lyon.

Thanks !

Bonjour,
Après installation et activation du plugin "Badges" les 4 INSERT suivants du fichier "badges/sql/empty-2.0.1.sql" n'ont pas été exécutés:

INSERT INTO glpi_plugin_badges_configs VALUES (1, '30', '30', '30');
INSERT INTO glpi_notificationtemplates VALUES(NULL, 'Alert Badges', 'PluginBadgesBadge', '2010-02-23 23:44:46','',NULL);
INSERT INTO glpi_displaypreferences VALUES (NULL,'PluginBadgesBadge','3','2','0');
INSERT INTO glpi_displaypreferences VALUES (NULL,'PluginBadgesBadge','4','3','0');
INSERT INTO glpi_displaypreferences VALUES (NULL,'PluginBadgesBadge','5','4','0');

J'ai exécuté manuellement le premier INSERT dans glpi_plugin_badges_configs sinon j'obtenais un message d'erreur.
Les 4 autres INSERT sont-ils nécessaires au bon fonctionnement du plugin?
Quel est leur rôle?
Dois-je les exécuter manuellement?

Cordialement

Hello,

I used to use the Badges plugin to manage my access badges. This plugin was working very well on my GLPI version 9.3/9.4.

I updated my instance a little more than a month ago to the 9.5 version of GLPI and integrated the latest version of the badge plugin (2.6.0) which is supposed to be compatible with the 9.5.x version. I can activate the plugin and access the available badges, but when I want to assign it, by clicking on "Add to cart" or "Send", nothing happens. Also when I click on "Cancel", the buttons seem inactive:

I tried to remove/reinstall the plugin but same thing, there is nothing to do.

• Version of the plugin : 2.6.0

• Version of your GLPI : 9.5.3

• Steps to reproduce (which actions have you made) : When I click on "Add to cart" or "Send" or "Cancel", nothing happens.

• Expected result : booking validation

• Actual result : Nothing

• URL of the page : https://mydomain.tld/plugins/badges/front/wizard.form.php?action=badgerequest# (this "#" is added when I click on the button (add to card, send or cancel)

• Screenshot of the problem (if pertinent) : https://i.gyazo.com/a58069cea7c85de9aa8a0814e48eaa08.png

Thank you for your help.

Dear GLPi user.

BEFORE SUBMITTING YOUR ISSUE, please make sure to read and follow these steps :

• Verify that your question has not already been asked
• Please use the below template.
• Delete this text before submiting your issue.

The Plugin team.

• Version of the plugin :
  3.0.0

• Version of your GLPI : 10.0.0.2

• URL of the page :
  glpi/marketplace/badges/front/badge.form.php

*problem
Hello, We don't have the possibility to make our badges reservable.
We use to have the option in the last version (9.5.6).

• Screenshot of the problem (if pertinent) :
  

Type of badge

Bonjour,

Version utilisée:

• CentOS 7
• GLPI 0.90.1
• Plugin Badges for GLPI 2.1.1

Dans les logs GLPI le plugin Badges génère l'erreur SQL suivante:

*** MySQL query error:
SQL: SELECT *
FROM glpi_plugin_badges_badges
WHERE date_expiration IS NOT NULL
AND is_deleted = '0'
AND DATEDIFF(CURDATE(),date_expiration) >
AND DATEDIFF(CURDATE(),date_expiration) > 0 AND states_id NOT IN (999999)
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to
use near 'AND DATEDIFF(CURDATE(),date_expiration) > 0 AND states_id NOT IN (999999)' at line 6

Cordialement

• Version of the plugin :

• Version of your GLPI :
  9.2.3

• Steps to reproduce (which actions have you made) :
  When I try to install the plugins, show the message, that is only available higher 9.3 but the last GLPI version is 9.2.3