Changeset 427 for trunk/index.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/index.php (modified) (1 diff)

trunk/index.php

@@ -231 +231 @@
       {
         $UserOptions = new Form('MemberOptions');
-        $DbResult = $this->Database->query('SELECT Member.Id, Member.InternetTariffNextMonth, Member.FamilyMemberCount, Member.BillingPeriodNext, Subject.Name, Subject.AddressStreet, Subject.AddressTown, Subject.AddressPSC, Subject.IC, Subject.DIC FROM Member JOIN Subject ON Subject.Id = Member.Subject WHERE Member.Id='.$this->System->Modules['User']->User['Member']);
-        $DbRow = $DbResult->fetch_array();
-        foreach($UserOptions->Definition['Items'] as $Index => $Item)
-        {
-          $UserOptions->Values[$Index] = $DbRow[$Index];
-        }
-        $UserOptions->OnSubmit = '?Action=MemberOptionsSave';
-        $Output .= $UserOptions->ShowEditForm();
+        $DbResult = $this->Database->query('SELECT Customer FROM UserCustomerRel WHERE User='.$this->System->Modules['User']->User['Id']);
+        if($DbResult->num_rows > 0)
+        {
+          $CustomerUserRel = $DbResult->fetch_assoc();
+          $DbResult = $this->Database->query('SELECT Member.Id, Member.InternetTariffNextMonth, '.
+            'Member.FamilyMemberCount, Member.BillingPeriodNext, Subject.Name, Subject.AddressStreet, '.
+            'Subject.AddressTown, Subject.AddressPSC, Subject.IC, Subject.DIC FROM Member JOIN Subject '.
+           'ON Subject.Id = Member.Subject WHERE Member.Id='.$CustomerUserRel['Customer']);        
+          $DbRow = $DbResult->fetch_array();
+          foreach($UserOptions->Definition['Items'] as $Index => $Item)
+          {
+            $UserOptions->Values[$Index] = $DbRow[$Index];
+          }
+          $UserOptions->OnSubmit = '?Action=MemberOptionsSave';
+          $Output .= $UserOptions->ShowEditForm();
+        } else $Output .= $this->SystemMessage('Chyba', 'Nejste zákazníkem');
       } else
       if($_GET['Action'] == 'MemberOptionsSave')