Changeset 486 for trunk/Common/Database.php

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.

File:

• trunk/Common/Database.php (modified) (1 diff)

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));  
+}
+
 ?>