Changeset 2 for trunk

Timestamp:

Aug 4, 2018, 1:08:58 AM (6 years ago)

Author:

chronos

Message:

• Added: New page Meet where items from external webs will be imported.

Location:

trunk

Files:

• . (modified) (1 prop)
• Meet.php (added)
• index.php (modified) (4 diffs)

trunk/index.php

@@ -3 +3 @@
 include_once('Database.php');
 include_once('Config.php');
+include_once('Meet.php');
 
+function HumanDate($Time)
+{
+  return(date('j.n.Y', $Time));
+}
+ 
 class Application
 {
@@ -30 +36 @@
   {
     $Output = '<div>'.
-      '<a href="'.$this->Link('/tance/').'">Tance</a> ';
-    $Output .= '<a href="'.$this->Link('/skoly/').'">Školy</a> '.
+      '<a href="'.$this->Link('/tance/').'">Tance</a> '.
+      '<a href="'.$this->Link('/skoly/').'">Školy</a> '.
+      '<a href="'.$this->Link('/seznamka/').'">Seznamka</a> '.
       '</div>';
     return($Output);
@@ -100 +107 @@
   }
 
+  function ShowMeetList()
+  {
+    $Meet = new Meet();
+    $Meet->Id = 1;
+    $Meet->URL = 'https://www.tanecniskola.cz/seznamka/';
+    $Meet->Database = $this->Database;
+    $Meet->Parse();
+    
+    $Gender = array('Muž', 'Žena');
+    
+    $Output = '<h4 style="text-align: center;">Inzeráty:</h4>';
+    $Output .= '<table class="WideTable">';
+    $Output .= '<tr><th>Datum</th><th>Jméno</th><th>Výška</th><th>Věk</th><th>Email</th><th>Telefon</th><th>Pohlaví</th><th>Zpráva</th><th>Zdroj</th>';
+    $Output .= '</tr>';
+    $DbResult = $this->Database->select('MeetItem', '*, (SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName, '.
+      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL', '1 ORDER BY `Date` DESC');
+    while($MeetItem = $DbResult->fetch_assoc())
+    {
+      $Output .= '<tr>'.
+        '<td>'.HumanDate(MysqlDateToTime($MeetItem['Date'])).'</td>'.
+        '<td>'.$MeetItem['Name'].'</td>'.
+        '<td>'.$MeetItem['Height'].'</td>'.
+        '<td>'.$MeetItem['Age'].'</td>'.
+        '<td>'.$MeetItem['Email'].'</td>'.
+        '<td>'.$MeetItem['Phone'].'</td>'.
+        '<td>'.$Gender[$MeetItem['Gender']].'</td>'.
+        '<td>'.$MeetItem['Message'].'</td>'.
+        '<td><a href="'.$this->Link($MeetItem['SourceURL']).'">'.$MeetItem['SourceName'].'</a></td>';      
+      $Output .= '</tr>';
+    }
+    $Output .= '</table>';    
+
+    return($Output);
+  }
+
   function ShowPage($Content)
   {
@@ -131 +173 @@
     if(count($this->PathItems) > 0) {
       if($this->PathItems[0] == 'skoly') $Output .= $this->ShowSchoolList();
-      else if($this->PathItems[0] == 'skoly') $Output .= $this->ShowDanceList();
+      else if($this->PathItems[0] == 'tance') $Output .= $this->ShowDanceList();
+      else if($this->PathItems[0] == 'seznamka') $Output .= $this->ShowMeetList();
       else $Output .= $this->ShowDanceList();
     } else $Output .= $this->ShowDanceList();