Changeset 48 for trunk/Modules/Meet/MeetPage.php

Timestamp:

Dec 22, 2019, 11:43:06 PM (5 years ago)

Author:

chronos

Message:

• Added: Allow to login as administrator.
• Added: Allow to hide meet items.

File:

• trunk/Modules/Meet/MeetPage.php (modified) (5 diffs)

trunk/Modules/Meet/MeetPage.php

@@ -59 +59 @@
 
     $DbResult = $this->Database->query('SELECT COUNT(*) FROM (SELECT *, '.
-      '(SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName FROM `MeetItem`) AS T WHERE '.$Where);
+      '(SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName FROM `MeetItem`) AS T WHERE (T.Hidden=0) AND '.$Where);
     $DbRow = $DbResult->fetch_row();
     $PageList = GetPageList($DbRow[0]);
@@ -82 +82 @@
     $Output .= $Order['Output'];
     $DbResult = $this->Database->query('SELECT * FROM (SELECT *, (SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName, '.
-      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL FROM MeetItem) AS T WHERE '.
+      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL FROM MeetItem) AS T WHERE (T.Hidden=0) AND '.
       $Where.$Order['SQL'].$PageList['SQLLimit']);
     while($MeetItem = $DbResult->fetch_assoc())
@@ -149 +149 @@
       $id = $this->System->PathItems[2] * 1;
     } else return 'Položka nenalezena';
+    if ($this->System->IsAdmin())
+    {
+      if (array_key_exists('hide', $_GET)) $this->Database->update('MeetItem', 'Id='.$id, array('Hidden' => 1));
+      if (array_key_exists('unhide', $_GET)) $this->Database->update('MeetItem', 'Id='.$id, array('Hidden' => 0));
+    }
+
     $Output .= '<div class="title">Inzerát</div>';
     $Gender = array('', 'Muž', 'Žena');
@@ -172 +178 @@
         '<tr><th>Zdroj importu</th><td><a href="'.$MeetItem['SourceURL'].'">'.$MeetItem['SourceName'].'</a></td></tr>';
       $Output .= '</table>';
+      if ($this->System->IsAdmin()) {
+        if ($MeetItem['Hidden'] == '1')
+          $Output .= '<div>Skrytá položka <a href="?unhide">Zviditelnit</a></div>';
+          else $Output .= '<div>Viditelná položka <a href="?hide">Skrýt</a></div>';
+      }
     } else $Output .= 'Položka nenalezena';
     return $Output;
@@ -197 +208 @@
 
     $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 `Time` DESC LIMIT 30');
+      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL', '`Hidden`=0 ORDER BY `Time` DESC LIMIT 30');
     while($MeetItem = $DbResult->fetch_assoc())
     {