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

Timestamp:

Jan 3, 2015, 7:34:55 PM (10 years ago)

Author:

chronos

Message:

• Modified: Form class ItemActions changed to define URL using #RowId instead of addition of &i=number.

File:

• trunk/Modules/Finance/UserState.php (modified) (3 diffs)

trunk/Modules/Finance/UserState.php

@@ -70 +70 @@
     $this->System->Modules['Finance']->LoadTariffs(1);
 
-    if(array_key_exists('Subject', $_GET))
+    // Determine which customer should be displayed
+    if(array_key_exists('i', $_GET))
     {
       if(!$this->System->User->CheckPermission('Finance', 'Manage')) return('Nemáte oprávnění');
-      $DbResult = $this->Database->query('SELECT * FROM Subject WHERE Id='.$_GET['Subject']);
-      if($DbResult->num_rows > 0)
-        $Subject = $DbResult->fetch_assoc();
-      else return($this->SystemMessage('Chyba', 'Subjekt nenalezen'));
+      $CustomerId = $_GET['i'];
     } else
     {
@@ -85 +83 @@
       {
         $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();
+        $CustomerId = $CustomerUserRel['Customer'];
       } else return($this->SystemMessage('Chyba', 'Nejste zákazníkem'));
     }
-
-    if(!array_key_exists('show', $_GET)) $_GET['show'] = '';
-    $DbResult = $this->Database->query('SELECT Member.* '.
-      'FROM Member LEFT JOIN MemberPayment ON MemberPayment.Member=Member.Id WHERE Member.Subject='.$Subject['Id']);
-    if($DbResult->num_rows == 0)
+        
+    // Load customer info
+    $DbResult = $this->Database->query('SELECT * FROM Member WHERE Id='.$CustomerId);
+    if($DbResult->num_rows == 1)
     {
-      return($this->SystemMessage('Položka nenalezena', 'Zákazník nenalezen'));
-    }
-    $Member = $DbResult->fetch_assoc();
-    $Output = '<table width="100%" border="0" cellspacing="0" cellpadding="3"><tr><td valign="top">';
+        $Customer = $DbResult->fetch_assoc();      
+    } else return($this->SystemMessage('Položka nenalezena', 'Zákazník nenalezen'));
+    
+    
+    // Load subject info
+    $DbResult = $this->Database->query('SELECT * FROM Subject WHERE Id='.$Customer['Subject']);
+    if($DbResult->num_rows == 1)
+    {    
+      $Subject = $DbResult->fetch_assoc();      
+    } else return($this->SystemMessage('Položka nenalezena', 'Subjekt nenalezen'));
+    
+    
+    $Output = '<table width="100%" border="0" cellspacing="0" cellpadding="3"><tr><td valign="top">';        
 
     // Account state
@@ -131 +136 @@
     $DbResult = $this->Database->query('SELECT Service.Name, Service.Price FROM ServiceCustomerRel '.
       'LEFT JOIN Service ON Service.Id=ServiceCustomerRel.Service '.
-      'WHERE (ServiceCustomerRel.Customer='.$Member['Id'].') AND (ServiceCustomerRel.Action IS NULL)');
+      'WHERE (ServiceCustomerRel.Customer='.$Customer['Id'].') AND (ServiceCustomerRel.Action IS NULL)');
     while($DbRow = $DbResult->fetch_assoc())
     {
-          $Output .= '<tr><td>'.$DbRow['Name'].'</td><td>'.$DbRow['Price'].'</td></tr>';
+            $Output .= '<tr><td>'.$DbRow['Name'].'</td><td>'.$DbRow['Price'].'</td></tr>';
       $Total += $DbRow['Price'];
     }