Changeset 410 for trunk/finance/user_state.php

Timestamp:

Oct 4, 2012, 10:12:08 AM (12 years ago)

Author:

chronos

Message:

• Upraveno: Vazba tabulky User na Member oddělena do samostatné tabulky jako vztah N:N.

File:

• trunk/finance/user_state.php (modified) (1 diff)

trunk/finance/user_state.php

@@ -22 +22 @@
       if(!$this->System->Modules['User']->CheckPermission('Finance', 'DisplaySubjectState')) return('Nemáte oprávnění');
       $UserId = $this->System->Modules['User']->User['Id'];
-      $DbResult = $this->Database->query('SELECT * FROM Subject WHERE Id=(SELECT Subject FROM Member WHERE Id=(SELECT Member FROM User WHERE Id='.$UserId.'))');
+      $DbResult = $this->Database->query('SELECT * FROM Subject WHERE Id=(SELECT Subject FROM Member WHERE Id=(SELECT Customer FROM UserCustomerRel WHERE User='.$UserId.'))');
       $Subject = $DbResult->fetch_assoc();
     }