added hide-show for manage_comments

1 files changed, 75 insertions, 16 deletions

diff --git a/tbc_external_review.module b/tbc_external_review.module
index 8947d2d..43c0b4d 100755
--- a/tbc_external_review.module
+++ b/tbc_external_review.module
@@ -1,4 +1,6 @@
 <?php 
+
+
     date_default_timezone_set('Asia/Calcutta');
     function tbc_external_review_menu() {
         $items = array();
@@ -73,6 +75,7 @@
             "access arguments" => array("administer tbc_external_review"),
             "type" => MENU_NORMAL_ITEM
         );
+        
         $items["tbc_external_review/mail_comments"] = array(
             "title" => "ER Mail Comments",
             "page callback" => "tbc_external_review_mail_comments_all",
@@ -111,6 +114,7 @@
             "access callback" => TRUE,
             "type" => MENU_CALLBACK
         );
+        
         $items["tbc_external_review/eligibility_test"] = array(
             "title" => "Eligibility Test",
             "page callback" => "tbc_external_review_eligibility_test_all",
@@ -533,7 +537,8 @@
         if($preference_id) {
             if($review) {
                 $query = "
-                    SELECT erc.*, cha.number AS chapter, exa.number AS example FROM external_review_comments erc
+                    SE
+                    LECT erc.*, cha.number AS chapter, exa.number AS example FROM external_review_comments erc
                     LEFT JOIN textbook_companion_chapter cha ON cha.id = erc.chapter_id 
                     LEFT JOIN textbook_companion_example exa ON exa.id = erc.example_id
                     WHERE erc.preference_id = %d AND erc.review = %d
@@ -963,6 +968,29 @@
             ";
             $result = db_query($query, $key);
             $data .= $key;
+
+        } 
+
+         else if($item == "hide-show1") {
+             
+            $query = "
+                UPDATE external_review_details
+                SET hidden = !hidden
+                WHERE preference_id = %d
+            ";
+            $result = db_query($query,$key);
+            $data .= $key;
+
+        }else if($item == "togglers" && $key) {
+            $query = "
+                UPDATE external_review_details
+                SET hidden = !hidden
+                WHERE preference_id = %d 
+                
+            ";
+            $result = db_query($query, $key);
+            $data .= $key;
+        
         } else if($item == "toggle" && $key) {
             $query = "
                 UPDATE external_review_comments
@@ -976,6 +1004,7 @@
             $result = db_query($query, $key);
             $data .= $key;
         }
+        
         echo $data;
         exit();
     }
@@ -1351,10 +1380,11 @@
                 LEFT JOIN textbook_companion_proposal pro ON pre.proposal_id = pro.id
                 LEFT JOIN users usr_con ON usr_con.uid = pro.uid
                 LEFT JOIN users usr_ext ON usr_ext.uid = erc.uid
-                LEFT JOIN external_review_details erd ON erd.preference_id = erc.preference_id
-                ORDER BY pre.book
+                LEFT JOIN external_review_details erd ON erd.preference_id = erc.preference_id 
+                ORDER BY erd.hidden
             ";
-            $result = db_query($query);
+             $result = db_query($query);
+                     
             $headers = array(
                 "Book", "Review No.",
                 "Status", "Contributor",
@@ -1362,25 +1392,51 @@
             );
             $rows = array();
             while($row = db_fetch_object($result)) {
+                  $hide_optionss= array(
+                    /* # linking in drupal l() */
+                    "fragment" => " ",
+                    "external" => TRUE,
+                    "attributes" => array(
+                        "class" => "hide-show1",
+                        "manages-comment" => "{$row->preference_id}",
+                    )
+                );
                 $item = array(
-                    "{$row->book}<br><em>by {$row->author}</em>",
-                    suffix($row->review),
-                    ($row->completed?"Completed":"Ongoing"),
-                    "{$row->contributor}",
-                    "{$row->reviewer}",
-                    l("View", "tbc_external_review/manage_comments/" . $row->preference_id)
+                    "data" => array(
+                        "{$row->book}<br><em>by {$row->author}</em>",
+                        suffix($row->review),
+                        ($row->completed?"Completed":"Ongoing"),
+                        "{$row->contributor}",
+                        "{$row->reviewer}",
+                        l("View", "tbc_external_review/manage_comments/" . $row->preference_id)
+                    ),
                 );
-                end($item);
-                $key = key($item);
+
+                if($row->hidden) {
+                 $item["class"] .= " dulls";
+                } 
+
+                end($item["data"]);
+                $key = key($item["data"]);
                 if(!$row->sent) {
-                    $item[$key] .= " | " . l("Mail", "tbc_external_review/mail_comments/" . $row->preference_id);
+                    $item["data"][$key] .= " | " . l("Mail", "tbc_external_review/mail_comments/" . $row->preference_id);
+                } else {
+                    $item["data"][$key] .= " | " . "Sent";
+                }
+                 
+                /* hide/unhide link */
+                end($item);
+                $key= key($item["data"]);
+                if($row->hidden) {
+                    $item["data"][$key] .= " | " . l("Show", "", $hide_optionss);
                 } else {
-                    $item[$key] .= " | " . "Sent";
+                    $item["data"][$key] .= " | " . l("Hide", "", $hide_optionss);
                 }
+
                 array_push($rows, $item);
             }
             $page_content .= theme("table", $headers, $rows);
-        }
+           }
         return $page_content;
     }
 
@@ -2167,4 +2223,7 @@
         drupal_add_js(drupal_get_path("module", "tbc_external_review") . "/js/tbc_external_review.js");
         drupal_add_js(drupal_get_path("module", "tbc_external_review") . "/js/timer.js");
     }
-?>
+ 
+
+    
+