Changeset 11599 for trunk/www/db_po/get_date.php

Timestamp:

07/26/11 10:51:38 (14 years ago)

Author:

Daniela Dorner

Message:

added various new features (min, max, user, show/hide of columns, ...) and changed layout

File:

• trunk/www/db_po/get_date.php (modified) (7 diffs)

trunk/www/db_po/get_date.php

@@ -21 +21 @@
     if (empty($_GET["fDateValuePrev"]))
         $_GET["fDateValuePrev"]="";
+    if (empty($_GET["fStatusDate"]))
+        $_GET["fStatusDate"]="";
 
     include("db.php");
@@ -43 +45 @@
     if (strcmp("month",$_GET["fDateName"])==0)
     {
-        $identifier1="Y";
+        $identifier1="%Y";
         $identifier2="m";
         $newdatename="day";
@@ -49 +51 @@
     if (strcmp("day",$_GET["fDateName"])==0)
     {
-        $identifier1="m";
+        $identifier1="%Y-%m";
         $identifier2="d";
         $newdatename="hour";
@@ -55 +57 @@
     if (strcmp("hour",$_GET["fDateName"])==0)
     {
-        $identifier1="d";
+        $identifier1="%Y-%m-%d";
         $identifier2="H";
         $newdatename="min";
@@ -61 +63 @@
     if (strcmp("min",$_GET["fDateName"])==0)
     {
-        $identifier1="H";
+        $identifier1="%Y-%m-%d %H";
         $identifier2="i";
         $newdatename="sec";
@@ -67 +69 @@
     if (strcmp("sec",$_GET["fDateName"])==0)
     {
-        $identifier1="i";
+        $identifier1="%Y-%m-%d %H:%i";
         $identifier2="s";
         $newdatename="";
@@ -80 +82 @@
             $query0.=" WHERE NOT fValidFrom='0000-00-00 00:00:00' ";
         else
-            $query0.=" WHERE Date_Format(fValidFrom, '%". $identifier1."')=".$_GET["fDateValuePrev"];
+            $query0.=" WHERE Date_Format(fValidFrom, '". $identifier1."')='".$_GET["fStatusDate"]."'";
+            //$query0.=" WHERE Date_Format(fValidFrom, '%". $identifier1."')=".$_GET["fDateValuePrev"];
         $query0.=" GROUP BY valid";
         $result0=mysql_query($query0, $db_id);
     }
-    //echo $_GET["fDateValuePrev"];
+    //echo $query0;
 
-    //echo $query0;
     if (empty($newdatename))
         printf("<select id='%s%d'>\n", $_GET["fDateName"], $_GET["fIdx"]);
     else
-    {
-        //if (empty($identifier1))
-        //{
-            printf("<select id='%s%d' onchange=\"get_dates('%s', this.value, this.value, %d, 'yes')\">\n",
-                   $_GET["fDateName"], $_GET["fIdx"], $newdatename, $_GET["fIdx"]);
-        //}
-        //else
-        //{
-        //    printf("<select id='%s%d' onchange=\"get_dates('%s', this.value, '%s', %d, 'yes')\">\n",
-        //           $_GET["fDateName"], $_GET["fIdx"], $newdatename, $_GET["fDateValuePrev"], $_GET["fIdx"]);
-        //}
-    }
+        printf("<select id='%s%d' onchange=\"get_dates('%s', this.value, this.value, %d, 'yes')\">\n",
+               $_GET["fDateName"], $_GET["fIdx"], $newdatename, $_GET["fIdx"]);
     if (strcmp($_GET["fDateValue"],"empty")!=0)
         printf("<option value='empty'>%s</option>\n", $_GET["fDateName"]);