From: leon <leon@roojs.com>
Date: Tue, 7 Nov 2023 05:31:20 +0000 (+0800)
Subject: sort the timezone
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=ab7158559bb10e18e030654f24edacb70f31a57e

sort the timezone
---

diff --git a/TimeZone.php b/TimeZone.php
index 1d8629d9..72a629fb 100644
--- a/TimeZone.php
+++ b/TimeZone.php
@@ -86,8 +86,9 @@ class Pman_Core_TimeZone extends Pman
                 AND
                 Name NOT LIKE 'Etc%'
             ORDER BY
-                timeoffset DESC,
-                Name DESC
+                SUBSTRING_INDEX(Name, '/', 1) ASC,
+                timeoffset ASC,
+                Name ASC
         ");
 
         while($ce->fetch()) {
@@ -149,6 +150,10 @@ class Pman_Core_TimeZone extends Pman
             return '';
         }
 
+        if($dt == '0000-00-00 00:00:00' || $dt == '') {
+            $dt = 'NOW';
+        }
+
         $date = new DateTime($dt, new DateTimeZone($tz));
         return $date->format('P');
     }