From 421e398c18d68e09bdbce8ff059ce2c8cf044daa Mon Sep 17 00:00:00 2001
From: akshay
Date: Fri, 13 Dec 2024 12:17:48 +0530
Subject: table order by year in desc order

---
 lab_details.inc | 29 ++++++++++++++++++++++-------
 1 file changed, 22 insertions(+), 7 deletions(-)

diff --git a/lab_details.inc b/lab_details.inc
index beca4ef..1b335cf 100755
--- a/lab_details.inc
+++ b/lab_details.inc
@@ -49,22 +49,37 @@ function lab_migration_labs_progress_all()
     $query->fields('lab_migration_proposal');
     $query->condition('approval_status', 1);
     $query->condition('solution_status', 2);
+    $query->orderBy('approval_date','DESC');
     $result = $query->execute();
     if ($result->rowCount() == 0)
       {
-        $page_content .= "We are in the process of updating the lab migration data. ";
+        $page_content .= "We are in the process of updating the lab migration data.";
       }
     else
       {
-        //$result = db_query($query);
-        $page_content .= "<ol reversed>";
+        $preference_rows = array();
+        $i = $result->rowCount();
         while ($row = $result->fetchObject())
           {
-            $page_content .= "<li>";
-            $page_content .= $row->university . " ({$row->lab_title})";
-            $page_content .= "</li>";
+            $approval_date = date("Y", $row->approval_date);
+            $preference_rows[] = array(
+                $i,
+                $row->university,
+                $row->lab_title,
+                $approval_date
+            );
+            $i--;
           }
-        $page_content .= "</ol>";
+        $preference_header = array(
+            'No',
+            'Institute',
+            'Lab',
+            'Year'
+        );
+        $page_content .= theme('table', array(
+            'header' => $preference_header,
+            'rows' => $preference_rows
+        ));
       }
     return $page_content;
   }
-- 
cgit