Changeset 427 for trunk/finance/user_state.php

Timestamp:

Oct 10, 2012, 8:46:02 PM (12 years ago)

Author:

chronos

Message:

• Opraveno: Další chybné použití tabulky UserCustomerRel vedlo k chybě při zobrazení financí uživatele, který má právo platícího klienta, ale nemá vazbu na tabulu Member.

File:

• trunk/finance/user_state.php (modified) (2 diffs)

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 Customer FROM UserCustomerRel WHERE User='.$UserId.' LIMIT 1))');
-      $Subject = $DbResult->fetch_assoc();
+      $DbResult = $this->Database->query('SELECT Customer FROM UserCustomerRel WHERE User='.$UserId.' LIMIT 1');
+      if($DbResult->num_rows > 0)
+      {
+        $CustomerUserRel = $DbResult->fetch_assoc();
+        $DbResult = $this->Database->query('SELECT * FROM Subject WHERE Id=(SELECT Subject FROM Member WHERE Id='.$CustomerUserRel['Customer'].')');
+        $Subject = $DbResult->fetch_assoc();
+      } else return($this->SystemMessage('Chyba', 'Nejste zákazníkem'));
     }
     
@@ -42 +47 @@
     $FinanceYearSelected = $DbResult->fetch_assoc();
     $YearWhere = ' WHERE (Time >= "'.$FinanceYearSelected['DateStart'].'") AND (Time <= "'.$FinanceYearSelected['DateEnd'].'")';
-
-    
+   
     
     // Year list