Changeset 32 for trunk/index.php

Timestamp:

Dec 30, 2018, 8:14:55 PM (5 years ago)

Author:

chronos

Message:

• Added: Meet item TimeImport time to see when was item imported to the database. Use TimeImport in RSS export for items with only date specified.

File:

• trunk/index.php (modified) (3 diffs)

trunk/index.php

@@ -272 +272 @@
       array('Name' => 'Age', 'Title' => 'Věk'),
       array('Name' => 'Weight', 'Title' => 'Váha'),
-      array('Name' => 'Location', 'Title' => 'Úmístění'),
+      array('Name' => 'Location', 'Title' => 'Umístění'),
       array('Name' => 'Gender', 'Title' => 'Pohlaví'),
       array('Name' => 'Message', 'Title' => 'Zpráva'),
@@ -360 +360 @@
 
     $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, UNIX_TIMESTAMP(`Time`) AS `UnixTime`', '1 ORDER BY `Time` DESC LIMIT 30');
+      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL', '1 ORDER BY `Time` DESC LIMIT 30');
     while($MeetItem = $DbResult->fetch_assoc())
     {
@@ -373 +373 @@
       if ($MeetItem['Height'] != '') $Description .= '<br/>Výška: '.$MeetItem['Height'].' cm';
       if ($MeetItem['Weight'] != '') $Description .= '<br/>Váha: '.$MeetItem['Weight'].' kg';      
-      $Description .= '<br/>Zdroj importu: <a href="'.$MeetItem['SourceURL'].'">'.$MeetItem['SourceName'].'</a>';
+      $Description .= '<br/>Zdroj importu: <a href="'.$MeetItem['SourceURL'].'">'.$MeetItem['SourceName'].'</a>';     
+      $Time = MysqlDateTimeToTime($MeetItem['Time']);
+      $TimeImport = MysqlDateTimeToTime($MeetItem['TimeImport']);      
+      // Append time part of TimeImport time to item time so new items will appear in correct time order even if item doesn't have time part specified
+      if (TimeToMysqlTime($Time) == '00:00:00')
+      {
+        $Time = MysqlDateTimeToTime(TimeToMysqlDate($Time).' '.TimeToMysqlTime($TimeImport));
+      }
       $RSS->Items[] = array(
         'Title' => $Title,
         'Description' => $Description,
-        'Time' => $MeetItem['UnixTime'],
+        'Time' => $Time,
         'Link' => $this->AbsoluteLink('/seznamka/inzerat/'.$MeetItem['Id'].'/'),
       );