Changeset 9498 for trunk/MagicSoft/Mars/datacenter/db/include.php

Timestamp:

08/20/09 14:43:59 (15 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/include.php (modified) (11 diffs)

trunk/MagicSoft/Mars/datacenter/db/include.php

@@ -255 +255 @@
 }
 
+//for download of output
 function PrintText($result0)
 {
-//    header("Content-type: application/octet");
-//    header("Content-Disposition: attachment; filename=query-result.txt");
-
     while ($row0 = mysql_fetch_assoc($result0))
     {
@@ -293 +291 @@
 }
 
-function Checkbox2($val, $set, $text)
-{
-    $value=$val.$set;
-    switch ($set)
-    {
-    case  "ON":
-        if (!isset($_POST["submit"]) && ereg(" ".$val." ", $_GET["Set"]))
-            $_POST[$value]="On";
-        break;
-    case "Off":
-        if (!isset($_POST["submit"]) && ereg(" ".$val." ", $_GET["Set2"]))
-            $_POST[$value]="On";
-        break;
-    }
-
-    if ($_POST[$value]=="On")
+function Checkbox2($value, $text)
+{
+    if ($_SESSION[$value]=="On")
         $checked = "checked";
     else
@@ -316 +301 @@
 }
 
-function CheckWhere($column, $_GET)
+function CheckWhere($column)
 {
     foreach ($_GET as $key => $element)
@@ -330 +315 @@
 }
 
-function CheckGroup($column, $_GET)
+function CheckGroup($column)
 {
     foreach ($_GET as $key => $element)
@@ -344 +329 @@
 }
 
-function CheckStatusGroup($column, $_GET)
+function CheckStatusGroup($column)
 {
     foreach ($_GET as $key => $element)
@@ -353 +338 @@
 }
 
-function CheckEnumGroup($column, $_GET)
+function CheckEnumGroup($column)
 {
     foreach ($_GET as $key => $element)
@@ -360 +345 @@
                 return -1;
     return 0;
-}
-
-function CreateMenu($rows)
-{
-    $menu = "";
-
-    if (empty($_GET["fNumResults"]))
-        return;
-
-    if ($_GET["fNumStart"]!=0)
-    {
-        $uri = htmlspecialchars($_SERVER["REQUEST_URI"]);
-        $pos = strpos($uri, "fNumStart");
-        $amp3=FALSE;
-        if ($pos!=FALSE)
-        {
-            $amp1 = substr($uri, 0, $pos-1);
-            $amp2 = substr($uri, $pos);
-            $amp3 = strchr($amp2, "&");
-
-            $uri = $amp1;
-        }
-        $pos = $_GET["fNumStart"]-$rows;
-        if ($pos<0)
-            $pos=0;
-        $uri .= "&fNumStart=" . $pos;
-        if ($amp3!=FALSE)
-            $uri .= $amp3;
-
-        $menu .= "<A HREF='" . $uri . "'><<< Prev</A>\n";
-    }
-
-    $menu .= "&nbsp;&nbsp;&nbsp;---&nbsp;<B>";
-    $menu .= $_GET["fNumStart"];
-    $menu .= "</B>&nbsp;---&nbsp;&nbsp;&nbsp;\n";
-
-    if ($rows==$_GET["fNumResults"])
-    {
-        $uri = $_SERVER["REQUEST_URI"];
-        $pos = strpos($uri, "fNumStart");
-        $amp3=FALSE;
-        if ($pos!=FALSE)
-        {
-            $amp1 = substr($uri, 0, $pos-1);
-            $amp2 = substr($uri, $pos);
-            $amp3 = strchr($amp2, "&");
-
-            $uri = $amp1;
-        }
-        $uri .= "&fNumStart=" . ($_GET["fNumStart"]+$rows);
-        if ($amp3!=FALSE)
-            $uri .= $amp3;
-
-        $menu .= "<A HREF='" . htmlspecialchars($uri) . "'>Next >>></A>\n";
-    }
-    return $menu;
 }
 
@@ -455 +384 @@
 }
 
-function PrintMagicTable($result0, $alias, $rightalign, $limitsmean, $limitsmin, $limitsmax, $form, $_GET)
+//function for button in builddatasets.php
+function GetClearedURL($all)
+{
+//    $url=htmlspecialchars($_SERVER["REQUEST_URI"]);
+    $url=$_SERVER["REQUEST_URI"];
+//    echo "before:".$url."<br>";
+    if ($all=="yes")
+    {
+//        echo "replace <br>";
+//        $url=str_replace("&DisplaySelected", "halo", $url);
+        $url=str_replace("&DisplaySelected=yes", "", $url);
+        $url=str_replace("&DisplaySelected=no", "", $url);
+    }
+    $url=str_replace("&insert=yes", "", $url);
+    $url=str_replace("&fSendTxt=2", "", $url);
+    $url=str_replace("&fSendTxt=1", "", $url);
+//    echo "after:".$url."<br>";
+    $url=htmlspecialchars($url);
+    return $url;
+}
+
+function PrintUpdateDataSetButton()
+{
+    if (empty($_SESSION["insert"]))
+        printf("<input type='submit' value='Update Data Set'>&nbsp;&nbsp;&nbsp;\n");
+    else
+        printf("<input type='button' value='Continue' onClick='self.location.href=\"%s\"'>&nbsp;&nbsp;&nbsp;\n", GetClearedURL());
+
+}
+
+//function for button in builddatasets.php
+function PrintDisplaySequencesButtons()
+{
+    if ($_SESSION["DisplaySelected"]!="yes" && ($_SESSION["sequon"]!=" " || $_SESSION["sequoff"]!=" "))
+    {
+        PrintUpdateDataSetButton();
+        printf("<input type='button' value='Display Selected Sequences' onClick='self.location.href=\"%s&DisplaySelected=yes\"'><br><br>\n", GetClearedURL("yes"));
+    }
+
+    if ($_SESSION["DisplaySelected"]=="yes")
+    {
+        PrintUpdateDataSetButton();
+        printf("<input type='button' value='Display All Sequences' onClick='self.location.href=\"%s&DisplaySelected=no\"'>\n", GetClearedURL("yes"));
+        printf("&nbsp;&nbsp;&nbsp;<i>Currently only selected sequences are displayed.</i><br><br>\n");
+    }
+}
+
+
+function ReplaceInUri($name, $rows, $direction, $result1=0)
+{
+    $uri = htmlspecialchars($_SERVER["REQUEST_URI"]);
+    $pos = strpos($uri, "fNumStart");
+    $amp3=FALSE;
+    if ($pos!=FALSE)
+    {
+        $amp1 = substr($uri, 0, $pos-1);
+        $amp2 = substr($uri, $pos);
+        $amp3 = strchr($amp2, "&");
+
+        $uri = $amp1;
+    }
+
+    switch($direction)
+    {
+    case 0:
+        $pos = $_GET["fNumStart"]-$rows;
+        if ($pos<0)
+            $pos=0;
+        break;
+    case 1:
+        $pos = $_GET["fNumStart"]+$rows;
+        break;
+    case 2:
+        $pos = 0;
+        break;
+    case 3:
+        $row1 = mysql_fetch_assoc($result1);
+        $pos = $row1["FOUND_ROWS()"]-$rows+1;
+        break;
+    }
+
+    $uri .= "&fNumStart=" . $pos;
+    if ($amp3!=FALSE)
+        $uri .= $amp3;
+
+    switch($direction)
+    {
+    case 0:
+        $link .= " <A HREF='" . $uri . "'>< Prev</A> \n";
+        break;
+    case 1:
+        $link .= " <A HREF='" . $uri . "'>Next ></A> \n";
+        break;
+    case 2:
+        $link .= " <A HREF='" . $uri . "'><< First</A> \n";
+        break;
+    case 3:
+        $link .= " <A HREF='" . $uri . "'>Last >></A> \n";
+        break;
+    }
+    return $link;
+}
+
+function CreateMenu($rows, $result1)
+{
+    $menu = "";
+
+    if (empty($_GET["fNumResults"]))
+        return;
+
+    if ($_GET["fNumStart"]!=0)
+    {
+        $menu .= ReplaceInUri("fNumStart", $rows, 2);
+        $menu .= ReplaceInUri("fNumStart", $rows, 0);
+    }
+
+    $menu .= "&nbsp;&nbsp;&nbsp;---&nbsp;<B>";
+    if (empty($_GET["fNumStart"]))
+        $menu .= "0";
+    else
+        $menu .= $_GET["fNumStart"];
+    $menu .= "</B>&nbsp;---&nbsp;&nbsp;&nbsp;\n";
+
+    if ($rows==$_GET["fNumResults"])
+    {
+        $menu .= ReplaceInUri("fNumStart", $rows, 1);
+        $menu .= ReplaceInUri("fNumStart", $rows, 3, $result1);
+    }
+    return $menu;
+}
+
+function PrintMagicTable($result0, $alias, $rightalign, $limitsmean, $limitsmin, $limitsmax, $result1, $form="")
 {
     $col   = FALSE;
@@ -470 +530 @@
 
 
-    $menu = CreateMenu(mysql_num_rows($result0));
-
+    $menu = CreateMenu(mysql_num_rows($result0), $result1);
+
+    if ($form)
+    {
+        printf("<form method='POST'>");
+        PrintDisplaySequencesButtons();
+    }
     printf("\n<center>\n");
-    if ($form)
-        printf("<form method='POST'>");
     if (empty($_GET["fPrintTable"]))
         printf("%s\n", $menu);
+
     printf("<table BORDER='0' style='margin-top:1ex'>\n");
     $counter=0;
@@ -518 +582 @@
         if ($form)
         {
-            CheckBox2($row0["Sequ"], "ON","");
-            CheckBox2($row0["Sequ"], "Off","");
+            CheckBox2($row0["Sequ"]."ON","");
+            CheckBox2($row0["Sequ"]."Off","");
         }
         foreach ($row0 as $key => $element)
@@ -607 +671 @@
      */
 
-    printf("<P><B>Number of displayed results: %d</B><P><P>\n", mysql_num_rows($result0));
+    $row1 = mysql_fetch_assoc($result1);
+    printf("<P><B>Number of displayed results: %d of %s in total</B><P><P>\n", mysql_num_rows($result0), $row1["FOUND_ROWS()"]);
     if (empty($_GET["fPrintTable"]))
         printf("%s\n", $menu);
     printf("<P>\n");
+    printf("</center>\n");
 
     if (!$form)
     {
-        printf("</center>\n");
         printf("</td>\n");
         printf("</tr>\n");
     }
+    else
+        PrintDisplaySequencesButtons();
 }