Changeset 694

Timestamp:

Sep 14, 2014, 9:41:58 PM (10 years ago)

Author:

chronos

Message:

• Added: Show list of registered user contacts in user panel.

Location:

trunk

Files:

• Application/Version.php (modified) (1 diff)
• Modules/User/UserPage.php (modified) (3 diffs)

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 692; // Subversion revision
+$Revision = 693; // Subversion revision
 $DatabaseRevision = 692; // SQL structure revision
 $ReleaseTime = strtotime('2014-09-14');

trunk/Modules/User/UserPage.php

@@ -13 +13 @@
         $Title .= '<div class="Action">'.$Item.'</div>';
     return('<div class="Panel"><div class="Title">'.$Title.'</div><div class="Content">'.$Content.'</div></div>');
+  }
+
+  function ShowContacts()
+  {
+    $Query = 'SELECT `Contact`.`Value`, (SELECT `Name` FROM `ContactCategory` WHERE `ContactCategory`.`Id` = `Contact`.`Category`) AS `Category` '.
+      'FROM `Contact` WHERE `User` = '.
+      $this->System->User->User['Id'];
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS T');
+    $DbRow = $DbResult->fetch_row();
+    $PageList = GetPageList($DbRow[0]);
+
+    $Output = '<div>Kontakty</div>';
+    $Output .= $PageList['Output'];
+    $Output .= '<table class="WideTable" style="font-size: small;">';
+
+    $TableColumns = array(
+      array('Name' => 'Category', 'Title' => 'Skupina'),
+      array('Name' => 'Value', 'Title' => 'Hodnota'),
+    );
+    $Order = GetOrderTableHeader($TableColumns, 'Value', 0);
+    $Output .= $Order['Output'];
+
+    $Query = $Query.' '.$Order['SQL'].$PageList['SQLLimit'];
+
+    $DbResult = $this->Database->query($Query);
+    while($Contact = $DbResult->fetch_assoc())
+    {
+      $Output .= '<tr><td>'.$Contact['Category'].'</td>'.
+      '<td>'.$Contact['Value'].'</td></tr>';
+    }
+    $Output .= '</table>';
+    $Output .= $PageList['Output'];
+
+    return($Output);
   }
 
@@ -29 +63 @@
           } else $Actions .= call_user_func($Action).'<br/>';
         }
-      $Output .= '<div class="Centred"><table id="MainTable"><tr><td>';
+      $Output .= '<div class="Centred"><table id="MainTable"><tr><td style="vertical-align:top;">';
       $Output .= $this->Panel('Nabídka uživatele', $Actions);
-      $Output .= '</td><td>';
+      $Output .= '</td><td style="vertical-align:top;">';
       if($this->System->User->User['Id'] != null)
         {
@@ -39 +73 @@
           $Form->OnSubmit = '?Action=UserOptionsSave';
           $Output .= $Form->ShowViewForm();
+
+          $Output .= '<br/>'.$this->ShowContacts();
         } else $Output .= $this->SystemMessage('Nastavení uživatele', 'Nejste přihlášen');