Changeset 974 for trunk/Modules/Finance/Finance.php

Timestamp:

Jun 30, 2025, 11:25:24 AM (3 weeks ago)

Author:

chronos

Message:

• Modified: Show finance operation time as DateTime type.
• Fixed: Corrected finance treasury stats calculation.

File:

• trunk/Modules/Finance/Finance.php (modified) (2 diffs)

trunk/Modules/Finance/Finance.php

@@ -53 +53 @@
         'BillCode' => array('Type' => 'TDocumentLineCode', 'Caption' => 'Označení', 'Default' => '', 'ReadOnly' => true),
         'Subject' => array('Type' => 'TSubject', 'Caption' => 'Subjekt', 'Default' => ''),
-        'Time' => array('Type' => 'Date', 'Caption' => 'Čas realizace', 'Default' => ''),
+        'Time' => array('Type' => 'DateTime', 'Caption' => 'Čas realizace', 'Default' => ''),
         'Cash' => array('Type' => 'Boolean', 'Caption' => 'Hotově', 'Default' => ''),
         'Taxable' => array('Type' => 'Boolean', 'Caption' => 'Zdanitelné', 'Default' => ''),
@@ -307 +307 @@
           '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))'.
+          '(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)'),
       ),