Changeset 40 for trunk/Modules/Dance/Dance.php

Timestamp:

May 5, 2019, 11:48:18 PM (6 years ago)

Author:

chronos

Message:

• Added: New table DanceFigure to represent various dancing figures.

File:

• trunk/Modules/Dance/Dance.php (modified) (3 diffs)

trunk/Modules/Dance/Dance.php

@@ -18 +18 @@
   {
     $this->System->RegisterPage('tance', 'PageDanceList');
+    $this->System->RegisterPage('tanec', 'PageDance');
+    $this->System->RegisterPage('figura', 'PageDanceFigure');
+    $this->System->RegisterPage('figury', 'PageDanceFigureList');
     $this->System->RegisterMenuItem('/tance', 'Tance');
+    $this->System->RegisterMenuItem('/figury', 'Figury');
   }  
 }
 
-class PageDanceList extends Page
-{
-  function __construct($System)
-  {
-    parent::__construct($System);
-    $this->FullTitle = 'Tance';
-    $this->ShortTitle = 'Tance';
-  }
-
-  function Show()
-  {
-    $this->Title = 'Tance - '.$this->Title;
-    $Output = '<div class="title">Tance</div>';
-    $Output .= '<table class="WideTable">';
-    $Output .= '<tr><th>Název</th><th>Skupina</th>';
-    $DbResult2 = $this->Database->select('ResourceGroup', '*');
+class PageDance extends Page
+{
+  function __construct($System)
+  {
+    parent::__construct($System);
+    $this->FullTitle = 'Tanec';
+    $this->ShortTitle = 'Tanec';
+  }
+
+  function Show()
+  {
+    $this->Title = 'Tanec - Tance - '.$this->Title;
+    $Output = '';
+    if(count($this->System->PathItems) > 1)
+    {
+      $id = $this->System->PathItems[1] * 1;
+    } else return 'Položka nenalezena';
+    $Output .= '<div class="title">Tanec</div>';
+    $DbResult = $this->Database->select('Dance', '*, (SELECT DanceGroup.Name FROM DanceGroup WHERE DanceGroup.Id=Dance.Group) AS DanceGroupName', 'Id='.$id);
+    if ($DbResult->num_rows > 0)
+    {
+      $MeetItem = $DbResult->fetch_assoc();
+      if ($MeetItem['Link'] != '') $Link = '<a href="'.$MeetItem['Link'].'">Odkaz</a>';
+        else $Link = '';
+      $Output .= '<table class="ItemTable">'.
+        '<tr><th>Jméno</th><td>'.$MeetItem['Name'].'</td></tr>'.
+        '<tr><th>Skupina</th><td>'.$MeetItem['DanceGroupName'].'</td></tr>';
+      $Output .= '</table>';
+    } else $Output .= 'Položka nenalezena';
+
+    $Output .= '<br/><div class="title">Taneční figury</div>';
+    $Output .= '<table class="WideTable">';
+    $Output .= '<tr><th>Český název</th><th>Anglický název</th><th>Detail</th></tr>';
+    $DbResult = $this->Database->select('DanceFigure', '*', '(`Dance`='.$id.')');
+    while($DanceFigure = $DbResult->fetch_assoc())
+    {
+      $Output .= '<tr>'.
+        '<td>'.$DanceFigure['NameCz'].'</td>'.
+        '<td>'.$DanceFigure['NameEn'].'</td>'.
+        '<td><a href="'.$this->System->Link('/figura/'.$DanceFigure['Id'].'/').'">Ukázat</a></td>';
+        '</tr>';
+    }
+    $Output .= '</table>';
+
+    $Output .= '<br/><div class="title">Výuková videa</div>';
+    $Output .= '<table class="WideTable">';
+    $Output .= '<tr><th>Název</th><th>Skupina</th><th>Odkaz</th></tr>';
+    $DbResult = $this->Database->select('Resource', '*, (SELECT Name FROM ResourceGroup WHERE ResourceGroup.Id=Resource.Group) AS GroupName', '(`Dance`='.$id.')');
+    while($DbRow = $DbResult->fetch_assoc())
+    {
+      $Output .= '<tr>'.
+        '<td>'.$DbRow['Name'].'</td>'.
+        '<td>'.$DbRow['GroupName'].'</td>'.
+        '<td><a href="'.$DbRow['URL'].'">'.$DbRow['URL'].'</a></td>'.
+        '</tr>';
+    }
+    $Output .= '</table>';
+
+      /*
+          $DbResult2 = $this->Database->select('ResourceGroup', '*');
     while($ResourceGroup = $DbResult2->fetch_assoc())
     {
       $Output .= '<th>'.$ResourceGroup['Name'].'</th>';
     }
-    $Output .= '</tr>';
-    $DbResult = $this->Database->select('Dance', '*, (SELECT Name FROM DanceGroup WHERE DanceGroup.Id=Dance.Group) AS GroupName', '1 ORDER BY `Name`');
-    while($Dance = $DbResult->fetch_assoc())
-    {
-      $Output .= '<tr><td>'.$Dance['Name'].'</td><td>'.$Dance['GroupName'].'</td>';
+
       $DbResult2 = $this->Database->select('ResourceGroup', '*');
       while($ResourceGroup = $DbResult2->fetch_assoc())
       {
         $Output .= '<td>';
-        $DbResult3 = $this->Database->select('Resource', '*', '(`Dance`='.$Dance['Id'].') AND (`Group`='.$ResourceGroup['Id'].')');
         while($Resource = $DbResult3->fetch_assoc())
         {
@@ -57 +100 @@
         }
         $Output .= '</td>';
-      }
+      }*/
+  
+    return $Output;
+  }
+}
+
+class PageDanceList extends Page
+{
+  function __construct($System)
+  {
+    parent::__construct($System);
+    $this->FullTitle = 'Tance';
+    $this->ShortTitle = 'Tance';
+  }
+
+  function Show()
+  {
+    $this->Title = 'Tance - '.$this->Title;
+    $Output = '<div class="title">Tance</div>';
+    $Output .= '<table class="WideTable">';
+    $Output .= '<tr><th>Název</th><th>Skupina</th><th>Detail</th></tr>';
+    $DbResult = $this->Database->select('Dance', '*, (SELECT Name FROM DanceGroup WHERE DanceGroup.Id=Dance.Group) AS GroupName', '1 ORDER BY `Name`');
+    while($Dance = $DbResult->fetch_assoc())
+    {
+      $Output .= '<tr>'.
+        '<td>'.$Dance['Name'].'</td>'.
+        '<td>'.$Dance['GroupName'].'</td>'.
+        '<td><a href="'.$this->System->Link('/tanec/'.$Dance['Id'].'/').'">Ukázat</a></td>';
       $Output .= '</tr>';
     }
@@ -66 +136 @@
 }
 
+class PageDanceFigure extends Page
+{
+  function __construct($System)
+  {
+    parent::__construct($System);
+    $this->FullTitle = 'Taneční figura';
+    $this->ShortTitle = 'Figura';
+  }
+
+  function Show()
+  {
+    $this->Title = 'Taneční figura - Tance - '.$this->Title;
+    $Output = '';
+    if(count($this->System->PathItems) > 1)
+    {
+      $id = $this->System->PathItems[1] * 1;
+    } else return 'Položka nenalezena';
+    $Output .= '<div class="title">Taneční figura</div>';
+    $DbResult = $this->Database->select('DanceFigure', '*, (SELECT Dance.Name FROM Dance WHERE Dance.Id=DanceFigure.Dance) AS DanceName', 'Id='.$id);
+    if ($DbResult->num_rows > 0)
+    {
+      $DbRow = $DbResult->fetch_assoc();
+      $Output .= '<table class="ItemTable">'.
+        '<tr><th>České jméno</th><td>'.$DbRow['NameCz'].'</td></tr>'.
+        '<tr><th>Anglické jméno</th><td>'.$DbRow['NameEn'].'</td></tr>'.
+        '<tr><th>Tanec</th><td>'.$DbRow['DanceName'].'</td></tr>';
+      $Output .= '</table>';
+    } else $Output .= 'Položka nenalezena';
+
+    /*$Output .= '<br/><div class="title">Videa</div>';
+    $Output .= '<table class="WideTable">';
+    $Output .= '<tr><th>Skupina videí</th><th></th><th>Detail</th></tr>';
+    $DbResult = $this->Database->select('DanceFigure', '*', '(`Dance`='.$id.')');
+    while($DanceFigure = $DbResult->fetch_assoc())
+    {
+      $Output .= '<tr>'.
+        '<td>'.$DanceFigure['NameCz'].'</td>'.
+        '<td>'.$DanceFigure['NameEn'].'</td>'.
+        '<td><a href="'.$this->System->Link('/tance/figura/'.$DanceFigure['Id'].'/').'">Ukázat</a></td>';
+        '</tr>';
+    }
+    $Output .= '</table>';
+    */
+      /*
+          $DbResult2 = $this->Database->select('ResourceGroup', '*');
+    while($ResourceGroup = $DbResult2->fetch_assoc())
+    {
+      $Output .= '<th>'.$ResourceGroup['Name'].'</th>';
+    }
+
+      $DbResult2 = $this->Database->select('ResourceGroup', '*');
+      while($ResourceGroup = $DbResult2->fetch_assoc())
+      {
+        $Output .= '<td>';
+        while($Resource = $DbResult3->fetch_assoc())
+        {
+          $Output .= '<a href="'.$Resource['URL'].'">'.$Resource['Name'].'</a> ';
+        }
+        $Output .= '</td>';
+      }*/
+  
+    return $Output;
+  }
+}
+
+class PageDanceFigureList extends Page
+{
+  function __construct($System)
+  {
+    parent::__construct($System);
+    $this->FullTitle = 'Tance';
+    $this->ShortTitle = 'Tance';
+  }
+
+  function Show()
+  {
+    $this->Title = 'Tance - '.$this->Title;
+    $Output = '<div class="title">Taneční figury</div>';
+    $Output .= '<table class="WideTable">';
+    $Output .= '<tr><th>Název</th><th>Skupina</th><th>Tanec</th><th>Detail</th></tr>';
+    $DbResult = $this->Database->select('DanceFigure', '*, (SELECT Dance.Name FROM Dance WHERE Dance.Id=DanceFigure.Dance) AS DanceName', '1 ORDER BY `NameCz`');
+    while($DbRow = $DbResult->fetch_assoc())
+    {
+      $Output .= '<tr>'.
+        '<td>'.$DbRow['NameCz'].'</td>'.
+        '<td>'.$DbRow['NameEn'].'</td>'.
+        '<td>'.$DbRow['DanceName'].'</td>'.
+        '<td><a href="'.$this->System->Link('/figura/'.$DbRow['Id'].'/').'">Ukázat</a></td>';
+      $Output .= '</tr>';
+    }
+    $Output .= '</table>';
+
+    return($Output);
+  }
+}