Changeset 737 for trunk/Modules/Portal/Portal.php

Timestamp:

Apr 14, 2015, 10:16:16 PM (10 years ago)

Author:

chronos

Message:

• Added: Experimental models internal database structure regeneration.

File:

• trunk/Modules/Portal/Portal.php (modified) (14 diffs)

trunk/Modules/Portal/Portal.php

@@ -14 +14 @@
     $this->Description = 'Community portal.';
     $this->Dependencies = array('News');
-  }  
+  }
 
   function DoInstall()
   {
   }
-  
+
   function DoUninstall()
-  {     
-  }
-  
+  {
+  }
+
   function DoStart()
   {
@@ -29 +29 @@
     $this->System->FormManager->RegisterClass('MemberOptions', array(
       'Title' => 'Nastavení domácnosti',
-      'Table' => '(SELECT Member.Id, Member.FamilyMemberCount, Subject.Name, Subject.AddressStreet, Subject.AddressTown, Subject.AddressPSC, Subject.IC, Subject.DIC FROM Member JOIN Subject ON Subject.Id = Member.Subject)',
+      'SQL' => '(SELECT Member.Id, Member.FamilyMemberCount, Subject.Name, Subject.AddressStreet, Subject.AddressTown, Subject.AddressPSC, Subject.IC, Subject.DIC FROM Member JOIN Subject ON Subject.Id = Member.Subject)',
+      'Table' => 'MemberOptions',
       'Items' => array(
         'Name' => array('Type' => 'String', 'Caption' => 'Fakturační jméno', 'Default' => ''),
@@ -43 +44 @@
     ));
     $this->System->ModuleManager->Modules['User']->UserPanel[] = array('PagePortal', 'UserPanel');
-  }  
-  
+  }
+
   function DoStop()
-  { 
-  } 
+  {
+  }
 }
 
@@ -54 +55 @@
   var $FullTitle = 'Zděchovský rozcestník';
   var $ShortTitle = 'Rozcestník';
-  
+
   function ShowActions($ActionGroup)
   {
-    $Output = '';    
-    $DbResult = $this->Database->query('SELECT `Id` FROM `Action` '.      
+    $Output = '';
+    $DbResult = $this->Database->query('SELECT `Id` FROM `Action` '.
       'WHERE (`Action`.`Group`='.$ActionGroup['Id'].') AND (`Action`.`Enable` = 1)');
     while($Action = $DbResult->fetch_assoc())
@@ -76 +77 @@
 
     $DbResult = $this->Database->query('SELECT COUNT(*) FROM NetworkDevice LEFT JOIN NetworkDeviceType ON NetworkDeviceType.Id = NetworkDevice.Type WHERE (NetworkDeviceType.ShowOnline = 1) AND (NetworkDevice.Online = 1)');
-    $DbRow = $DbResult->fetch_array();    
+    $DbRow = $DbResult->fetch_array();
     $OnlineComputers = $DbRow[0];
 
@@ -115 +116 @@
   {
     $Output = '<a href="'.$this->System->Link('/user/?Action=UserOptions').'">Profil</a><br />';
-    if($this->System->User->CheckPermission('Finance', 'MemberOptions')) 
+    if($this->System->User->CheckPermission('Finance', 'MemberOptions'))
       $Output .= '<a href="'.$this->System->Link('/?Action=MemberOptions').'">Domácnost</a><br />';
-    if($this->System->User->CheckPermission('Finance', 'DisplaySubjectState')) 
+    if($this->System->User->CheckPermission('Finance', 'DisplaySubjectState'))
       $Output .= '<a href="'.$this->System->Link('/finance/platby/').'">Finance</a><br />';
-    if($this->System->User->CheckPermission('Network', 'RegistredHostList')) 
+    if($this->System->User->CheckPermission('Network', 'RegistredHostList'))
       $Output .= '<a href="'.$this->System->Link('/network/user-hosts/').'">Počítače</a><br />';
-    if($this->System->User->CheckPermission('News', 'Insert')) 
+    if($this->System->User->CheckPermission('News', 'Insert'))
       $Output .= '<a href="'.$this->System->Link('/aktuality/?action=add').'">Vložení aktuality</a><br />';
     if($this->System->User->CheckPermission('EatingPlace', 'Edit'))
@@ -143 +144 @@
     return($Output);
   }
-  
+
   function OnlineHostList()
   {
@@ -167 +168 @@
     return($Output);
   }
-   
+
   function Panel($Title, $Content, $Menu = array())
   {
-    if(count($Menu) > 0) 
+    if(count($Menu) > 0)
       foreach($Menu as $Item)
         $Title .= '<div class="Action">'.$Item.'</div>';
@@ -197 +198 @@
             'Member.FamilyMemberCount, Member.BillingPeriodNext, Subject.Name, Subject.AddressStreet, '.
             'Subject.AddressTown, Subject.AddressPSC, Subject.AddressCountry, Subject.IC, Subject.DIC FROM Member JOIN Subject '.
-           'ON Subject.Id = Member.Subject WHERE Member.Id='.$CustomerUserRel['Customer']);        
+           'ON Subject.Id = Member.Subject WHERE Member.Id='.$CustomerUserRel['Customer']);
           $DbRow = $DbResult->fetch_array();
           foreach($Form->Definition['Items'] as $Index => $Item)
@@ -216 +217 @@
         if($Form->Values['BillingPeriodNext'] < 2)
           $Form->Values['BillingPeriodNext'] = 2;
-          
-        $DbResult = $this->Database->update('Member', 'Id='.$this->System->User->User['Member'], 
-           array('FamilyMemberCount' => $Form->Values['FamilyMemberCount'], 
+
+        $DbResult = $this->Database->update('Member', 'Id='.$this->System->User->User['Member'],
+           array('FamilyMemberCount' => $Form->Values['FamilyMemberCount'],
            'BillingPeriodNext' => $Form->Values['BillingPeriodNext']));
         $DbResult = $this->Database->query('SELECT Subject FROM Member WHERE Id='.$this->System->User->User['Member']);
         $Member = $DbResult->fetch_assoc();
-        $DbResult = $this->Database->update('Subject', 'Id='.$Member['Subject'], 
-          array('Name' => $Form->Values['Name'], 'AddressStreet' => $Form->Values['AddressStreet'], 
+        $DbResult = $this->Database->update('Subject', 'Id='.$Member['Subject'],
+          array('Name' => $Form->Values['Name'], 'AddressStreet' => $Form->Values['AddressStreet'],
           'AddressTown' => $Form->Values['AddressTown'], 'AddressCountry' => $Form->Values['AddressCountry'],
-          'AddressPSC' => $Form->Values['AddressPSC'], 'IC' => $Form->Values['IC'], 
+          'AddressPSC' => $Form->Values['AddressPSC'], 'IC' => $Form->Values['IC'],
           'DIC' => $Form->Values['DIC']));
         $Output .= $this->SystemMessage('Nastavení', 'Nastavení domácnosti uloženo.');
-        $this->System->ModuleManager->Modules['Log']->NewRecord('Member+Subject', 'Nastavení člena/subjektu změněno', 
+        $this->System->ModuleManager->Modules['Log']->NewRecord('Member+Subject', 'Nastavení člena/subjektu změněno',
           $Form->Values['Name']);
         $DbResult = $this->Database->query('SELECT Member.Id, Member.FamilyMemberCount, Member.BillingPeriodNext, '.
@@ -241 +242 @@
         $Form->OnSubmit = '?Action=MemberOptionsSave';
         $Output .= $Form->ShowEditForm();
-      } 
+      }
     } else $Output = $this->ShowMain();
     return($Output);
   }
-    
+
   function ShowMain()
   {
@@ -260 +261 @@
     while($PanelColumn =  $DbResult->fetch_assoc())
     {
-      if($PanelColumn != '') $Width = ' width="'.$PanelColumn['Width'].'"'; 
+      if($PanelColumn != '') $Width = ' width="'.$PanelColumn['Width'].'"';
         else $Width = '';
       $Output .= '<td valign="top"'.$Width.'>';
@@ -268 +269 @@
         if($Panel['Module'] == 'ActionGroup') $Output .= $this->ShowActions($ActionGroups[$Panel['Parameters']]);
         else if($Panel['Module'] == 'OnlineHostList') $Output .= $this->Panel('Online počítače', $this->OnlineHostList());
-        else if($Panel['Module'] == 'UserOptions') 
+        else if($Panel['Module'] == 'UserOptions')
         {
           //if($this->System->User->User['Id'] != null) $Output .= $this->Panel('Přihlášený uživatel', $this->UserPanel());
@@ -274 +275 @@
         if($Panel['Module'] == 'Webcam') $Output .= $this->Panel('Kamery', $this->WebcamPanel());
         if($Panel['Module'] == 'Meteo') $Output .= $this->Panel('Meteostanice', $this->MeteoPanel());
-        else if($Panel['Module'] == 'NewsGroupList') 
+        else if($Panel['Module'] == 'NewsGroupList')
           $Output .= $this->Panel('Aktuality', $this->System->ModuleManager->Modules['News']->Show(), array('<a href="?Action=CustomizeNews">Upravit</a>'));
       }
       $Output .= '</td>';
-    }  
+    }
     $Output .= '</tr></table>';
     return($Output);
-  }  
+  }
 }