Changeset 486 for trunk/Common

Timestamp:

Feb 10, 2013, 9:20:06 PM (12 years ago)

Author:

chronos

Message:

• Upraveno: Příprava na zrušení tabulek dokladů a jejich převedení na tabulky File a FinanceInvoice.

Location:

trunk/Common

Files:

• Database.php (modified) (1 diff)
• Global.php (modified) (2 diffs)

trunk/Common/Database.php

@@ -150 +150 @@
 }
 
+function TimeToMysqlDateTime($Time)
+{
+  if($Time == NULL) return(NULL);
+    else return(date('Y-m-d H:i:s', $Time));  
+}
+
+function TimeToMysqlDate($Time)
+{
+  if($Time == NULL) return(NULL);
+    else return(date('Y-m-d', $Time));  
+}
+
+function TimeToMysqlTime($Time)
+{
+  if($Time == NULL) return(NULL);
+    else return(date('H:i:s', $Time));  
+}
+
+function MysqlDateTimeToTime($DateTime)
+{
+  if($DateTime == '') return(0);      
+  $Parts = explode(' ', $DateTime);
+  $DateParts = explode('-', $Parts[0]); 
+  $TimeParts = explode(':', $Parts[1]);
+  $Result = mktime($TimeParts[0], $TimeParts[1], $TimeParts[2], $DateParts[1], $DateParts[2], $DateParts[0]); 
+  return($Result);  
+}
+
+function MysqlDateToTime($Date)
+{
+  if($Date == '') return(0);
+  return(MysqlDateTimeToTime($Date.' 0:0:0'));  
+}
+
+function MysqlTimeToTime($Time)
+{
+  if($Time == '') return(0);
+  return(MysqlDateTimeToTime('0000-00-00 '.$Time));  
+}
+
 ?>

trunk/Common/Global.php

@@ -338 +338 @@
 }
 
-function TimeToMysqlDateTime($Time)
-{
-  if($Time == NULL) return(NULL);
-    else return(date('Y-m-d H:i:s', $Time));  
-}
-
-function TimeToMysqlDate($Time)
-{
-  if($Time == NULL) return(NULL);
-    else return(date('Y-m-d', $Time));  
-}
-
-function MysqlDateTimeToTime($DateTime)
-{
-  if($DateTime == '') return(0);      
-  $Parts = explode(' ', $DateTime);
-  $DateParts = explode('-', $Parts[0]); 
-  $TimeParts = explode(':', $Parts[1]);
-  $Result = mktime($TimeParts[0], $TimeParts[1], $TimeParts[2], $DateParts[1], $DateParts[2], $DateParts[0]); 
-  return($Result);  
-}
-
-function MysqlDateToTime($Date)
-{
-  if($Date == '') return(0);
-  return(MysqlDateTimeToTime($Date.' 0:0:0'));  
-}
-
-function MysqlTimeToTime($Time)
-{
-  if($Time == '') return(0);
-  return(MysqlDateTimeToTime('0000-00-00 '.$Time));  
-}
-
 function HumanDate($Time)
 {
@@ -416 +382 @@
   return($Result);
 } 
+
+function ExtractTime($Time)
+{ 
+  return(array(
+        'Year' => date('Y', $Time), 
+        'Month' => date('n', $Time), 
+        'Day' => date('j', $Time),
+        'Hour' => date('h', $Time),
+        'Minute' => date('i', $Time),
+        'Second' => date('s', $Time)
+  ));
+}
 
 function GetQueryStringArray($QueryString)