Changeset 442 for trunk/Common/Types/DateTime.php

Timestamp:

Oct 14, 2012, 9:27:26 PM (12 years ago)

Author:

chronos

Message:

• Upraveno: Zápis a čtení hodnot formuláře do databáze se nyní provádí přes obsluhu jednotlivých formulářových typů. Toto je použito především u převodu formátu data a času z mysql na php time.

File:

• trunk/Common/Types/DateTime.php (modified) (9 diffs)

trunk/Common/Types/DateTime.php

@@ -11 +11 @@
     global $MonthNames;
     
-    if($Item['Value'] != '')
-    {
-      $ValueParts = explode(' ', $Item['Value']);
-      $DateParts = explode('-', $ValueParts[0]);
-      $TimeParts = explode(':', $ValueParts[1]);
-
-      $Output = ($DateParts[2] * 1).'.'.($DateParts[1] * 1).'.'.$DateParts[0].' '.$TimeParts[0].':'.$TimeParts[1].':'.$TimeParts[2];
-    } else $Output = '';
+    if(strtolower($Item['Value']) == 'now') $Item['Value'] = time();
+    $Parts = getdate($Item['Value']);
+    $Output = $Parts['mday'].'.'.$Parts['mon'].'.'.$Parts['year'].' '.
+      $Parts['hours'].':'.$Parts['minutes'].':'.$Parts['seconds'];
     return($Output);
   }
@@ -26 +22 @@
     global $MonthNames;
 
-    $ValueParts = explode(' ', $Item['Value']);
-    $DateParts = explode('-', $ValueParts[0]);
-    $TimeParts = explode(':', $ValueParts[1]);
+    if(strtolower($Item['Value']) == 'now') $Item['Value'] = time();
+    $Parts = getdate($Item['Value']);
 
     // Hour
@@ -34 +29 @@
     for($I = 1; $I <= 24; $I++)
     {
-      if($TimeParts[2] == $I) $Selected = ' selected="1"'; else $Selected = '';
+      if($Parts['hours'] == $I) $Selected = ' selected="1"'; else $Selected = '';
       $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
     }
@@ -42 +37 @@
     for($I = 1; $I <= 60; $I++)
     {
-      if($TimeParts[1] == $I) $Selected = ' selected="1"'; else $Selected = '';
+      if($Parts['minutes'] == $I) $Selected = ' selected="1"'; else $Selected = '';
       $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
     }
@@ -50 +45 @@
     for($I = 1; $I <= 60; $I++)
     {
-      if($TimeParts[0] == $I) $Selected = ' selected="1"'; else $Selected = '';
+      if($Parts['seconds'] == $I) $Selected = ' selected="1"'; else $Selected = '';
       $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
     }
@@ -58 +53 @@
     for($I = 1; $I <= 31; $I++)
     {
-      if($DateParts[2] == $I) $Selected = ' selected="1"'; else $Selected = '';
+      if($Parts['mday'] == $I) $Selected = ' selected="1"'; else $Selected = '';
       $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
     }
@@ -66 +61 @@
     for($I = 1; $I <= 12; $I++)
     {
-      if($DateParts[1] == $I) $Selected = ' selected="1"'; else $Selected = '';
+      if($Parts['mon'] == $I) $Selected = ' selected="1"'; else $Selected = '';
       $Output .= '<option value="'.$I.'"'.$Selected.'>'.$MonthNames[$I].'</option>';
     }
@@ -74 +69 @@
     for($I = 1900; $I < 2100; $I++)
     {
-      if($DateParts[0] == $I) $Selected = ' selected="1"'; else $Selected = '';
+      if($Parts['year'] == $I) $Selected = ' selected="1"'; else $Selected = '';
       $Output .= '<option value="'.$I.'"'.$Selected.'>'.$I.'</option>';
     }
@@ -83 +78 @@
   function OnLoad($Item)
   {
-    return($_POST[$Item['Name'].'-year'].'-'.$_POST[$Item['Name'].'-month'].'-'.$_POST[$Item['Name'].'-day'].' '.
-      $_POST[$Item['Name'].'-hour'].':'.$_POST[$Item['Name'].'-minute'].':'.$_POST[$Item['Name'].'-second']);
+    return(mktime($_POST[$Item['Name'].'-hour'], $_POST[$Item['Name'].'-minute'], $_POST[$Item['Name'].'-second'],
+      $_POST[$Item['Name'].'-month'], $_POST[$Item['Name'].'-day'], $_POST[$Item['Name'].'-year']));
+  }
+
+  function OnLoadDb($Item)
+  {
+    return(MysqlDateTimeToTime($Item['Value']));
+  }
+  
+  function OnSaveDb($Item)
+  {
+    return(date('Y-m-d H:i:s', $Item['Value']));
   }