Changeset 756 for trunk/Modules/Finance/UserState.php

Timestamp:

Oct 25, 2015, 10:37:29 PM (9 years ago)

Author:

chronos

Message:

• Fixed: SQL upgrade script error.

File:

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

trunk/Modules/Finance/UserState.php

@@ -17 +17 @@
       '`Time`, -`Value`, `File`, `BillCode`, `PeriodFrom`, `PeriodTo`, `DocumentLineCode`.`Name` AS `BillName` FROM `FinanceInvoice` '.
       'LEFT JOIN `DocumentLineCode` ON `DocumentLineCode`.`Id`=`FinanceInvoice`.`BillCode` '.
-      'WHERE (`Subject`='.$Subject['Id'].')))';
+      'WHERE (`Subject`='.$Subject['Id'].') AND (`VisibleToUser` = 1)))';
 
     $Output = '<div style="text-align:center">Výpis finančních operací</div>';