Changeset 979

Timestamp:

Jul 13, 2025, 10:06:35 AM (16 hours ago)

Author:

chronos

Message:

• Fixed: Treasury check difference.

File:

• trunk/Modules/Finance/Finance.php (modified) (1 diff)

trunk/Modules/Finance/Finance.php

@@ -300 +300 @@
           '`Value20` * 20 + `Value50` * 50 + `Value100` * 100 + `Value200` * 200 + '.
           '`Value500` * 500 + `Value1000` * 1000 + `Value2000` * 2000 + `Value5000` * 5000)'),
-        'Missing' => array('Type' => 'Integer', 'Caption' => 'Chybí', 'Default' => '0', 'Suffix' => 'Kč', 'ReadOnly' => true,
-          'SQL' => '(`Value1` * 1 + `Value2` * 2 + `Value5` * 5 + `Value10` * 10 + '.
+        'Missing' => array('Type' => 'Integer', 'Caption' => 'Odchylka', 'Default' => '0', 'Suffix' => 'Kč', 'ReadOnly' => true,
+          'SQL' => 
+         '-(`Value1` * 1 + `Value2` * 2 + `Value5` * 5 + `Value10` * 10 + '.
           '`Value20` * 20 + `Value50` * 50 + `Value100` * 100 + `Value200` * 200 + '.
-          '`Value500` * 500 + `Value1000` * 1000 + `Value2000` * 2000 + `Value5000` * 5000) - '.
+          '`Value500` * 500 + `Value1000` * 1000 + `Value2000` * 2000 + `Value5000` * 5000) + '.
           '(SELECT (T2.`Value1` * 1 + T2.`Value2` * 2 + T2.`Value5` * 5 + T2.`Value10` * 10 + '.
           'T2.`Value20` * 20 + T2.`Value50` * 50 + T2.`Value100` * 100 + T2.`Value200` * 200 + '.
-          'T2.`Value500` * 500 + T2.`Value1000` * 1000 + T2.`Value2000` * 2000 + T2.`Value5000` * 5000) + '.
-          '(SELECT SUM(T3.Value) FROM FinanceOperation AS T3 WHERE (T3.Time <= TX.Time) AND (T3.Time > T2.Time) AND (T3.Treasury=TX.Treasury))'.
+          'T2.`Value500` * 500 + T2.`Value1000` * 1000 + T2.`Value2000` * 2000 + T2.`Value5000` * 5000)'.
+          ' + (SELECT SUM(T3.Value) FROM FinanceOperation AS T3 WHERE (T3.Time <= TX.Time) AND (T3.Time > T2.Time) AND (T3.Treasury=TX.Treasury))'.
           ' FROM FinanceTreasuryCheck AS T2 WHERE (T2.Time < TX.Time) ORDER BY T2.Time DESC LIMIT 1)'),
       ),