made manage_comments page tabbed.

added email send on Mark Completed.
test page added, remove later

1 files changed, 112 insertions, 2 deletions

diff --git a/tbc_external_review.module b/tbc_external_review.module
index 06c6a29..b1b1468 100644
--- a/tbc_external_review.module
+++ b/tbc_external_review.module
@@ -70,8 +70,24 @@
             "title" => "ER View Status",
             "page callback" => "tbc_external_review_view_status_all",
             "access arguments" => array("administer tbc_external_review"),
+            "access callback" => TRUE,
+            "weight" => 30,
             "type" => MENU_NORMAL_ITEM
         );
+        $items["tbc_external_review/view_status/all"] = array(
+            "title" => "All",
+            "page callback" => "tbc_external_review_view_status_all",
+            "access callback" => TRUE,
+            "weight" => 1,
+            "type" => MENU_DEFAULT_LOCAL_TASK,
+        );
+        $items["tbc_external_review/view_status/recent"] = array(
+            "title" => "Recently Completed",
+            "page callback" => "tbc_external_review_view_status_recent_all",
+            "access callback" => TRUE,
+            "weight" => 2,
+            "type" => MENU_LOCAL_TASK,
+        );
         $items["tbc_external_review/add_book"] = array(
             "title" => "ER Add Book",
             "page callback" => "tbc_external_review_add_book_all",
@@ -83,6 +99,12 @@
             "access arguments" => array("download tbc_external_review"),
             "type" => MENU_CALLBACK
         );
+        $items["tbc_external_review/test"] = array(
+            "title" => "ER Add Book",
+            "page callback" => "tbc_external_review_test_all",
+            "access arguments" => array("download tbc_external_review"),
+            "type" => MENU_CALLBACK
+        );
         return $items;
     }
 
@@ -702,7 +724,7 @@
     }
 
     function tbc_external_review_view_status_all() {
-        $page_content = "";
+       $page_content = "";
         $query = "
             SELECT * from textbook_companion_preference tcp INNER JOIN external_review_details erd 
             ON (tcp.id = erd.preference_id AND erd.status=1) INNER JOIN users ON (erd.uid = users.uid)
@@ -748,6 +770,36 @@
         return $page_content;
     }
 
+    function tbc_external_review_view_status_recent_all() {
+        $page_content = "";
+        $query = "
+            SELECT * FROM external_review_details erd
+            LEFT JOIN textbook_companion_preference pre ON erd.preference_id = pre.id
+            LEFT JOIN users usr ON erd.uid = usr.uid
+            WHERE erd.completed = 1
+            ORDER BY time DESC
+        ";
+        $result = db_query($query);
+        $headers = array(
+            "Book", "Review No.",
+            "Status", "Time",
+            "Reviewer"
+        );
+        $rows = array($query);
+        while($row = db_fetch_object($result)) {
+            $item = array(
+                "{$row->book}<br><em>by {$row->author}</em>",
+                suffix($row->review),
+                ($row->status?"Completed":"Ongoing"),
+                "{$row->time}",
+                "{$row->name}"
+            );
+            array_push($rows, $item);
+        }
+        $page_content .= theme("table", $headers, $rows);
+        return $page_content;
+    }
+
     function tbc_external_review_manage_comments_all($preference_id=0) {
         global $base_url;
         $page_content = "";
@@ -877,8 +929,43 @@
                 if(!$result) {
                     drupal_set_message("Updation failed.", "error");
                 } else {
+                    /* fetching the book and review details */
+                    $query = "
+                        SELECT * FROM external_review_details erd
+                        LEFT JOIN textbook_companion_preference pre ON erd.preference_id = pre.id
+                        WHERE erd.preference_id = %d
+                    ";
+                    $result = db_query($query, $preference_id);
+                    $row = db_fetch_object($result);
+                    
+                    $review_no = suffix($row->review);
+                    /* sending mail */
+                    $to = "{$user->mail}";
+                    $from = "textbook@scilab.in";
+                    $subject = "External Review - Textbook Companion Project";
+                    $body = "
+                        Dear {$user->name} <br><br>
+                        You have completed a review. <br><br>
+                        Book: <b>{$row->book}</b> <br>
+                        Author: <b>{$row->author}</b><br>
+                        Review: <b>{$review_no}</b> <br><br>
+                        We will review your comments soon.<br>
+                        Thank you for your patience. <br><br>
+                        Best Wishes, <br>
+                        Scilab.in
+                    ";
+                    $message = array(
+                        "to" => $to,
+                        "from" => $from,
+                        "subject" => $subject,
+                        "body" => $body,
+                        "headers" => array(
+                            "Bcc" => "mukulrkulkarni@gmail.com, lavitha89@gmail.com, rush2jrp@gmail.com",
+                            "Content-Type" => "text/html; charset=UTF-8; format=flowed"
+                        )
+                    );
+                    drupal_mail_send($message);
                     drupal_set_message("Book marked as completed successfully.");
-                    /* send mail here */
                 }
                 drupal_goto("tbc_external_review/status");
             } else {
@@ -929,6 +1016,29 @@
         return $page_content;
     }
 
+    function tbc_external_review_test_all() {
+        global $user;
+        $page_content = "";
+        /* sending mail */
+        $to = "rush2jrp@gmail.com";
+        $from = "jayaram@iitb.ac.in";
+        $subject = "Test Subject";
+        $body = "<b>Test body</b>";
+        $message = array(
+            "to" => $to,
+            "from" => $from,
+            "subject" => $subject,
+            "body" => $body,
+            "headers" => array(
+                "Cc" => "jayaram@iitb.ac.in",
+                "Bcc" => "jayaram@iitb.ac.in",
+                "Content-Type" => "text/html; charset=UTF-8; format=flowed"
+            )
+        );
+        drupal_mail_send($message);
+        return $page_content;
+    }
+
     function tbc_external_review_init() {
         drupal_add_css(drupal_get_path("module", "tbc_external_review") . "/css/tbc_external_review.css");
         drupal_add_js(drupal_get_path("module", "tbc_external_review") . "/js/jquery.lightbox_me.js");