Cost with inverted calculation

[jpdenss]

• Version of the plugin : .1.4.1

• Version of your GLPI : 9.2.3

• Steps to reproduce (which actions have you made) : I have registered a record model, with two types of counters (mono and color), for a color printer. They collect the two values ​​normally.

• Expected result : Apply the costs of color and monochrome, where each one has a different cost.

• Actual result : The plugin is reversing the applied costs. Where it should apply the cost of monochrome, it is using the cost of color, and the opposite of the same form. In the billing model view associated with the printer, it also displays reversed.

• Screenshot of the problem (if pertinent) : RECORD MODEL

BILLING MODEL

ITEMS ASSOCIATED WITH THE BILLING MODEL ---- INVERTED VALUES VIEW

VALUES APPLIED IN AN INVERTED WAY WHERE MULTIPLYING THE QUANTITY FOR THE CORRECT COST, SHOULD RESULT IN 124.40

[amma35]

Hi, which mysql or mariadb version do you use? We have a difference in behavior without reason on different environments on a function.

[jpdenss]

Hi. by the way, great job! Well, this is the information from GLPI system info: Software: Apache/2.4.33 (Win32) PHP/7.2.4 (Apache/2.4.33 (Win32) PHP/7.2.4 MySql Server: 5.7.21

[amma35]

I have no explanation for the moment but the problem comes from the execution of a request the result is not the same between mysql and mariadb.

[jpdenss]

In fact, as you said, I migrated my database to MariaDB and the problem really does not occur. Thanks!