Changeset 11505 for trunk/www/db_po/get_values.php

Timestamp:

07/21/11 11:24:15 (13 years ago)

Author:

Daniela Dorner

Message:

added plenty of new features to view and edit the configuration database

File:

• trunk/www/db_po/get_values.php (modified) (2 diffs)

trunk/www/db_po/get_values.php

@@ -4 +4 @@
     ini_set("mysql.trace_mode", "On");
 
+    if (empty($_GET["fGetValCase"]))
+    {
+        echo "Please specify how you want to display the table (for view or for insert).";
+        //1: insert
+        //2: view
+        //3: view compare
+        return;
+    }
     if (empty($_GET["fKey"]))
     {
-        echo "Please select a key.<br>";
+        echo "Please select a key.";
         return;
     }
     if (empty($_GET["fProgram"]))
     {
-        echo "Please select a program.<br>";
+        echo "Please select a program.";
         return;
     }
-
+    if (empty($_GET["fStatusDate"]))
+        $_GET["fStatusDate"]="";
 
     include("db.php");
@@ -26 +35 @@
 
     $query1 = "SELECT Max(fCounter) FROM History";
+    // get counter of fStatusDate or current status
+    if ($_GET["fGetValCase"]!=1 && $_GET["fStatusDate"]!="")
+        $query1.=" WHERE (fValidFrom < '".$_GET["fStatusDate"]."' OR fValidFrom like '".$_GET["fStatusDate"]."%')";
+
     $result1=mysql_query($query1, $db_id);
     $row1 = mysql_fetch_row($result1);
-    $maxcount=$row1[0];
-    //echo $maxcount;
+    $counter=$row1[0];
+    mysql_free_result($result1);
 
-    $query0 ="SELECT fIndex, fProgram, fKey, fValue, fDescription, fCounter FROM ProgramOption ";
-    $query0.="WHERE fKey='".$_GET["fKey"]."'";
-    if ($_GET["fProgram"]!="all")
+    //get key1 and key2 separately from DB (for function AddRow())
+    $query2 = "SELECT fKey1, SUBSTRING(fKey2,2), fType FROM ProgramOption WHERE Concat(fKey1,fKey2)='".$_GET["fKey"]."'";
+    $result2=mysql_query($query2, $db_id);
+    $row2 = mysql_fetch_row($result2);
+    $key1=$row2[0];
+    $key2=$row2[1];
+    $type=$row2[2];
+    mysql_free_result($result2);
+
+    $query0 ="SELECT fIndex, fValidFrom, fProgram, Concat(fKey1,fKey2), fValue, fDescription, fCounter, fType, fMin, fMax, fKey1, SUBSTRING(fKey2,2), if(fOriginalIndex=0, fIndex, fOriginalIndex) FROM ProgramOption ";
+    $query0.="WHERE 1=1 ";
+    if (strcmp($_GET["fKey"],"all")!=0)
+        $query0.="AND Concat(fKey1,fKey2)='".$_GET["fKey"]."' ";
+    if (strcmp($_GET["fProgram"],"all")!=0)
         $query0.="AND fProgram='".$_GET["fProgram"]."' ";
+    if ($_GET["fGetValCase"]!=1)
+    {
+        $query0.="AND NOT isnull(fValue) ";
+        $query0.="AND fCounter>=".$counter;
+        if ($_GET["fStatusDate"]!="")
+            $query0.=" AND (fValidFrom < '".$_GET["fStatusDate"]."' OR fValidFrom like '".$_GET["fStatusDate"]."%') ";
+    }
+    $query0.=" ORDER BY fOriginalIndex, fIndex";
 
     $result0=mysql_query($query0, $db_id);
 
-    printf("<td valign='top'>Please edit:</td>\n");
-    printf("<td>\n");
-    printf("<button onClick='ShowCurrent();' id='showcurrent' style='display:none'>Show Current</button>\n");
-    printf("<button onClick='ShowAll();' id='showall' style='display:inline'>Show All</button>\n");
-    printf("<button onClick='addRow(\"%s\",\"%s\");' id='addrow' style='display:inline'>Add Row</button>\n", $_GET["fProgram"], $_GET["fKey"]);
-    printf("<table border='1' width='100px' height='100px'><tbody id='valtable'>\n");
-    printf("<tr><th>Index / Counter</th><th>Program</th><th>Key</th><th>Value</th><th>Description</th>");
-    printf("<th>Action</th></tr>\n");
-    while ($row0 = mysql_fetch_row($result0))
+    if ($_GET["fGetValCase"]==1)
     {
-        if ($row0[5]==$maxcount)
-            printf("<tr id='new%s' style='display:'>\n", $row0[0]);
-        else
-            printf("<tr id='old%s' style='display:none'>\n", $row0[0]);
-        printf("<td> %s / %s</td>\n", $row0[0], $row0[5]);
-        printf("<td id='prog%s'>%s</td>\n", $row0[0], $row0[1]);
-        printf("<td id='key%s'>%s</td>\n", $row0[0], $row0[2]);
-        printf("<td align='right' id='val%s'>%s</td>\n", $row0[0], $row0[3]);
-        printf("<td id='descr%s'>%s</td>\n", $row0[0], $row0[4]);
-        if ($row0[5]==$maxcount)
-            printf("<td id='action%s'><input type='button' value='Edit' onclick='EditRow(\"%s\")'></td>\n</tr>\n", $row0[0], $row0[0]);
-        else
-            printf("<td id='action%s'></td>\n</tr>\n", $row0[0]);
-        $maxindex=$row0[0];
+        printf("<button onClick='ShowCurrent();' id='showcurrent' style='display:none'>Show Current</button>\n");
+        printf("<button onClick='ShowAll();' id='showall' style='display:inline'>Show History</button>\n");
+        printf("<button onClick='addRow(3, \"%s\",\"%s\",\"%s\",\"%s\",\"%s\");' id='addrowvals' style='display:inline'>Add Value</button>\n",
+               $_GET["fProgram"], $_GET["fKey"], $key1, $key2, $type);
     }
-    printf("<div id='addline'></div>");
-    printf("</tbody></table>\n<br>\n");
-    printf("<div id='maxindex' style='display:none'>%s</div>\n", $maxindex);
-    printf("</td>\n");
+    printf("<table font-size='-1' border='1' width='100px' height='100px'><tbody id='valtable%s'>\n", $_GET["fGetValCase"]);
+    printf("<tr>");
+    printf("<th>Index / Orig / Counter</th>\n");
+    printf("<th>Valid since</th>\n");
+    printf("<th>Program</th>\n");
+    //printf("<th>Key</th>\n");
+    printf("<th>Key1</th>\n");
+    printf("<th>Key2</th>\n");
+    printf("<th>Value</th>\n");
+    printf("<th>Type</th>\n");
+    if ($_GET["fGetValCase"]==1)//show only in edit mode
+        printf("<th class='description%d'>Description</th>\n", $_GET["fGetValCase"]);
+    else
+        printf("<th class='description%d' style='display:none'>Description</th>\n", $_GET["fGetValCase"]);
+    if ($_GET["fGetValCase"]==1)//show only in edit mode
+        printf("<th>Action</th>\n");
+    printf("<th>Min</th>\n");
+    printf("<th>Max</th>\n");
+    printf("</tr>\n");
+    $maxindex=0;
+    if ($result0)
+        while ($row0 = mysql_fetch_row($result0))
+        {
+            if ($_GET["fGetValCase"]==1)
+            {
+                if ($row0[6]==$counter)
+                    printf("<tr id='new%s' style='display:'>\n", $row0[0]);
+                else
+                    printf("<tr id='old%s' style='display:none'>\n", $row0[0]);
+            }
+            else
+                printf("<tr id='%scompare%s' style='display:'>\n", $_GET["fGetValCase"], $row0[12]);
 
-    mysql_free_result($result0);
+            printf("<td> %s / %s / %s <div id='%dorigindex%s' style='display:none'>%s</div> </td>\n",
+                   $row0[0], $row0[12], $row0[6], $_GET["fGetValCase"], $row0[0], $row0[12]);
+            if (strcmp('0000-00-00 00:00:00', $row0[1])==0)
+                printf("<td id='notyetvalid%s'> %s </td>\n", $row0[0], $row0[1]);
+            else
+                printf("<td> %s </td>\n", $row0[1]);
+            printf("<td id='prog%s'>%s</td>\n", $row0[0], $row0[2]);
+            //printf("<td id='key%s'>%s</td>\n", $row0[0], $row0[3]);
+            printf("<td id='1key%s'>%s</td>\n", $row0[0], $row0[10]);
+            printf("<td id='2key%s'>%s</td>\n", $row0[0], $row0[11]);
+            printf("<td align='right' id='val%s'>%s</td>\n", $row0[0], $row0[4]);
+            printf("<td id='type%s'>%s</td>\n", $row0[0], $row0[7]);
+            if ($_GET["fGetValCase"]==1)//show only in edit mode
+                printf("<td class='description%d' id='descr%s'>%s</td>\n", $_GET["fGetValCase"], $row0[0], $row0[5]);
+            else
+                printf("<td class='description%d' style='display:none' id='descr%s'>%s</td>\n", $_GET["fGetValCase"], $row0[0], $row0[5]);
+            if ($_GET["fGetValCase"]==1)//show only in edit mode
+            {
+                if ($row0[6]==$counter)
+                    printf("<td id='action%s'><input type='button' value='Edit' onclick='EditRow(\"%s\")'></td>\n", $row0[0], $row0[0]);
+                else
+                    printf("<td id='action%s'></td>\n", $row0[0]);
+            }
+            printf("<td id='min%s'>%s</td>\n", $row0[0], $row0[8]);
+            printf("<td id='max%s'>%s</td>\n", $row0[0], $row0[9]);
+            printf("</tr>\n");
+            if ($row0[0]>$maxindex)
+                $maxindex=$row0[0];
+        }
+    printf("</tbody></table>\n");
+    if ($_GET["fGetValCase"]==1)
+    {
+        printf("<button onClick='ShowCurrent();' id='showcurrent2' style='display:none'>Show Current</button>\n");
+        printf("<button onClick='ShowAll();' id='showall2' style='display:inline'>Show History</button>\n");
+        printf("<button onClick='addRow(3,\"%s\",\"%s\",\"%s\",\"%s\",\"%s\");' id='addrowvals2' style='display:inline'>Add Value</button>\n",
+               $_GET["fProgram"], $_GET["fKey"], $key1, $key2, $type);
+    }
+    else
+    {
+        printf("<button onClick='HideDescription(%d);' id='hidedescr%d' style='display:none'>Hide Description</button>\n", $_GET["fGetValCase"], $_GET["fGetValCase"]);
+        printf("<button onClick='ShowDescription(%d);' id='showdescr%d' style='display:'>Show Description</button>\n", $_GET["fGetValCase"], $_GET["fGetValCase"]);
+    }
+
+    if ($_GET["fGetValCase"]==3)
+        printf("<div id='maxindex3' style='display:none'>%s</div>\n", $maxindex);
+    else
+        printf("<div id='maxindex' style='display:none'>%s</div>\n", $maxindex);
+
+    if ($result0)
+        mysql_free_result($result0);
 
     mysql_close($db_id);