From 8ca35bd3eb8e868f8d576353aa40e53335822f6e Mon Sep 17 00:00:00 2001
From: prashant
Date: Wed, 1 Oct 2014 14:36:14 +0530
Subject: updated email contents

---
 tbc_external_review.module | 243 ++++++++++++++++++++++++++++++++++++++++++++-
 1 file changed, 239 insertions(+), 4 deletions(-)

(limited to 'tbc_external_review.module')

diff --git a/tbc_external_review.module b/tbc_external_review.module
index e1a2650..df9bdfc 100755
--- a/tbc_external_review.module
+++ b/tbc_external_review.module
@@ -143,8 +143,35 @@
             "title" => "ER Remove Book",
             "page callback" => "tbc_external_review_er_remove_book_all",
             "access arguments" => array("download tbc_external_review"),
-            "type" => MENU_LOCAL_TASK
-            
+            "type" => MENU_LOCAL_TASK            
+        ); 
+        $items["tbc_external_review/mail"] = array(
+            "title" => "Mail Email To Reviewer",
+            "page callback" => "tbc_external_review_mail_all",
+            "access arguments" => array("download tbc_external_review"),
+            "type" => MENU_DEFAULT_LOCAL_TASK 
+
+        ); 
+        $items["tbc_external_review/reminder"] = array(
+        "title" => "Reviewer Reminder",
+        "description" => "Failed to complete review",
+        "page callback" => "_er_reminder_all",   
+        "access arguments" =>array("download tbc_external_review"),
+        "type" => MENU_NORMAL_ITEM
+        );  
+        $items["tbc_external_review/reminder/reviewer_reminder"] = array(
+        "title" => "Reviewer reminder",
+        "description" => "Failed to complete review",
+        "page callback" => "_er_reminder_all",   
+        "access arguments" =>array("download tbc_external_review"),
+        "type" => MENU_DEFAULT_LOCAL_TASK             
+        );   
+        $items["tbc_external_review/reminder/tbc_reviewer_reminder"] = array(
+        "title" => "TBC Reviewer Reminder",
+        "description" => "Failed to review",
+        "page callback" => "_er_tbc_reviewer_reminder_all",   
+        "access arguments" =>array("download tbc_external_review"),
+        "type" => MENU_LOCAL_TASK         
         );           
         return $items;
     }
@@ -2210,12 +2237,13 @@
         }
         return $page_content;
     }
+
     function tbc_external_review_er_assign_book_form(){
           $query = "  
              SELECT pre.id AS id, pre.book, pre.author, pre.edition, usr.uid, erd.completed FROM textbook_companion_preference pre
              LEFT JOIN external_review_details erd ON erd.preference_id = pre.id
              LEFT JOIN users usr ON usr.uid = erd.uid
-             WHERE erd.status = 0 AND completed = 0
+             WHERE erd.status = 0
              ORDER BY pre.book ASC
          ";
          $result = db_query($query);
@@ -2224,7 +2252,7 @@
          while($row1 = db_fetch_object($result)) {
             $books[$row1->id] = "{$row1->book} (Author: {$row1->author}, Edition: {$row1->edition})";           
          }
-
+                    
          $querys = "  
              SELECT * FROM users_roles rol
              LEFT JOIN users usr ON usr.uid = rol.uid
@@ -2257,6 +2285,7 @@
         );
         return $form;
     }
+
     function tbc_external_review_er_assign_book_form_validate($form, &$form_state) {
         if(!$form_state["values"]["reviewers"]) {
             form_set_error("reviewers", "Please select a reviewer.");
@@ -2265,6 +2294,7 @@
             form_set_error("book", "Please select a book.");
         }
     }
+
     function tbc_external_review_er_assign_book_form_submit($form, &$form_state){
     
             $v = $form_state["values"];
@@ -2279,6 +2309,7 @@
             drupal_set_message("Book alloted successfully", "status");
             
     }
+
     function tbc_external_review_er_assign_book_all() {
         $page_content .= "";
         $page_content .= "";
@@ -2287,6 +2318,7 @@
         $page_content .= drupal_get_form("tbc_external_review_er_assign_book_form");
         return $page_content;
     }
+
     function tbc_external_review_er_remove_book_form(){
          $query = "  
             SELECT pre.id AS id, pre.book, pre.author, pre.edition, usr.uid FROM textbook_companion_preference pre
@@ -2314,11 +2346,13 @@
         );
         return $form;
     }
+
     function tbc_external_review_er_remove_book_form_validate($form, &$form_state) {
         if(!$form_state["values"]["book"]) {
             form_set_error("book", "Please select a book.");
         }
     }
+
     function tbc_external_review_er_remove_book_form_submit($form, &$form_state){    
             $v = $form_state["values"];
             $query = "
@@ -2332,11 +2366,212 @@
             drupal_set_message("Book removed successfully", "status");
             
     }
+
     function tbc_external_review_er_remove_book_all() {
         $page_content .= "";        
         $page_content .= drupal_get_form("tbc_external_review_er_remove_book_form");
         return $page_content;
     }
+    
+    function _er_reminder_all($id=0, $confirm="") {
+              $page_content = "";
+              if($id && $confirm == "yes"){
+            $query = "
+               SELECT pre.id AS id, pre.book, pre.author, pre.edition, erd.failed_reminder, usr.uid, erp.first_name, erp.last_name, usr.mail FROM textbook_companion_preference pre
+                    LEFT JOIN external_review_details erd ON erd.preference_id = pre.id          
+                    LEFT JOIN users_roles rol ON erd.uid = rol.uid            
+                    LEFT JOIN users usr ON usr.uid = erd.uid
+                    LEFT JOIN external_review_profile erp ON erp.uid = erd.uid
+                    WHERE erd.status = 1 AND completed = 0 AND rol.rid = 9 AND id = {$id}
+                    ";
+            $result = db_query($query);
+            $row = db_fetch_object($result);
+            
+            /* increment failed_reminder */
+            $query = "
+              UPDATE external_review_details
+              SET failed_reminder = failed_reminder + 1
+              WHERE preference_id = {$id}
+            ";
+            db_query($query);
+
+            /* sending mail */
+            $to = $row->mail;
+            $subject = "Failed to review book on time";
+            $body = "
+            <p>
+              Dear Reviewer,<br><br>
+              This is to remind you that it has been 15 days since the book was allotted to you. You still have 15 days left from the provided 30 days to submit your review comments.<br>
+              Please submit your review comments in the Scilab interface. If you fail to submit the comments on time, the textbook will be removed from your account.<br>
+              Please note that extension of deadline is not possible on any account.<br><br>
+              Regards,<br>
+              Scilab Team
+            </p>
+            ";
+            $message = array(
+              "to" => $to,
+              "subject" => $subject,
+              "body" => $body,
+              "headers" => array(
+                "From" => "textbook@scilab.in",
+                "Bcc" => "textbook@scilab.in, lavitha89@gmail.com, bhavani.jalkrish@gmail.com, rush2jrp@gmail.com",
+                "Content-Type" => "text/html; charset=UTF-8; format=flowed"
+              )
+            );
+            echo "<pre>";
+            print_r($message);
+            die;
+            drupal_mail_send($message);
+            drupal_set_message("Reminder sent successfully.");
+            drupal_goto("tbc_external_review/reminder/reviewer_reminder");
+            } else if($id) {
+            $query = "
+             SELECT pre.id AS id, pre.book, pre.author, pre.edition, usr.uid, erp.first_name, erp.last_name, erd.failed_reminder, usr.mail FROM textbook_companion_preference pre
+                    LEFT JOIN external_review_details erd ON erd.preference_id = pre.id          
+                    LEFT JOIN users_roles rol ON erd.uid = rol.uid            
+                    LEFT JOIN users usr ON usr.uid = erd.uid
+                    LEFT JOIN external_review_profile erp ON erp.uid = erd.uid
+                    WHERE erd.status = 1 AND completed = 0 AND rol.rid = 9 AND id = {$id}
+                    ";
+            $result = db_query($query);
+            $row = db_fetch_object($result);
+            $page_content .= "Are you sure you want to notify?<br><br>";
+            $page_content .= "Book: <b>{$row->book}</b><br>";
+            $page_content .= "Author: <b>{$row->author}</b><br>";
+            $page_content .= "Reviewer: <b>{$row->first_name} {$row->last_name}</b><br>";
+            $page_content .= l("Yes", "tbc_external_review/reminder/reviewer_reminder/{$row->id}/yes") . " | ";
+            $page_content .= l("Cancel", "tbc_external_review/reminder/reviewer_reminder");
+          } else {
+            $query = "
+               SELECT pre.id AS id, pre.book, pre.author, pre.edition, usr.uid, erd.failed_reminder, erp.first_name, erp.last_name, usr.mail FROM textbook_companion_preference pre
+                    LEFT JOIN external_review_details erd ON erd.preference_id = pre.id          
+                    LEFT JOIN users_roles rol ON erd.uid = rol.uid            
+                    LEFT JOIN users usr ON usr.uid = erd.uid
+                    LEFT JOIN external_review_profile erp ON erp.uid = erd.uid
+                    WHERE erd.status = 1 AND completed = 0 AND rol.rid = 9
+                    ";
+            $result = db_query($query);
+            
+            $headers = array(
+             "Book", "Author", "Reviewer Name",
+               "Remainders", "Action"
+            );
+            $rows = array();  
+            while ($row = db_fetch_object($result)) {
+              $item  =array(        
+                $row->book,
+                $row->author,
+                $row->first_name,       
+                $row->failed_reminder,
+                l("Remind", "tbc_external_review/reminder/reviewer_reminder/{$row->id}")
+      );
+            array_push($rows, $item);
+    }
+            $page_content .= theme("table", $headers, $rows);
+  }
+  
+  return $page_content;
+}
+
+    function _er_tbc_reviewer_reminder_all($id=0, $confirm="") {
+       $page_content = "";
+       if($id && $confirm == "yes"){
+    $query = "
+            SELECT DISTINCT pre.id, erc.review AS id, pre.book, pre.author, pre.edition, usr.uid, erd.failed_reminder,
+            erd.failed_review, erc.review, erp.first_name, erp.last_name, usr.mail FROM textbook_companion_preference pre
+            LEFT JOIN external_review_details erd ON erd.preference_id = pre.id          
+            LEFT JOIN users_roles rol ON erd.uid = rol.uid            
+            LEFT JOIN users usr ON usr.uid = erd.uid
+            LEFT JOIN external_review_comments erc ON erc.uid = erd.uid
+            LEFT JOIN external_review_profile erp ON erp.uid = erd.uid
+            WHERE erd.status = 1 AND rol.rid = 9 AND erc.review = 0 AND pre.id = {$id}
+                    ";
+            $result = db_query($query);
+            $row = db_fetch_object($result);
+              /* increment failed_reminder */
+            $query = "    
+              UPDATE external_review_details
+              SET failed_review = failed_review + 1
+              WHERE preference_id = {$id}
+            ";
+            
+            /* sending mail */
+            
+           // $to = $row->mail;
+            $subject = "Failed to review TBC on time";
+            $body = "
+            <p>
+              Dear TBC reviewer,<br><br>
+              This is to inform you that {$row->first_name} {$row->last_name} have failed to review the TBC book on time.<br>
+              
+              Regards,<br>
+              Scilab Team
+            </p>
+            ";
+            $message = array(
+              "to" => "lavitha89@gmail.com, bhavani.jalkrish@gmail.com ",
+              "subject" => $subject,
+              "body" => $body,
+              "headers" => array(
+                "From" => "textbook@scilab.in",
+                "Bcc" => "rush2jrp@gmail.com",
+                "Content-Type" => "text/html; charset=UTF-8; format=flowed"
+              )
+            );
+            drupal_mail_send($message);  
+            db_query($query);
+            drupal_set_message("Reminder sent successfully.");
+            drupal_goto("tbc_external_review/reminder/tbc_reviewer_reminder");
+  } else if($id) {
+            $query = "
+            SELECT DISTINCT pre.id AS id, pre.book, pre.author, pre.edition, usr.uid, erd.failed_reminder, erc.review, erp.first_name, erp.last_name, usr.mail FROM textbook_companion_preference pre
+                    LEFT JOIN external_review_details erd ON erd.preference_id = pre.id          
+                    LEFT JOIN users_roles rol ON erd.uid = rol.uid            
+                    LEFT JOIN users usr ON usr.uid = erd.uid
+                    LEFT JOIN external_review_comments erc ON erc.uid = erd.uid
+                    LEFT JOIN external_review_profile erp ON erp.uid = erd.uid
+                    WHERE erd.status = 1 AND erc.review = 0 AND rol.rid = 9 AND pre.id = {$id}
+                    ";
+            $result = db_query($query);
+            $row = db_fetch_object($result);
+            $page_content .= "Are you sure you want to notify?<br><br>";
+            $page_content .= "Book: <b>{$row->book}</b><br>";
+            $page_content .= "Author: <b>{$row->author}</b><br>";
+            $page_content .= "Reviewer: <b>{$row->first_name} {$row->last_name}</b><br>";
+            $page_content .= l("Yes", "tbc_external_review/reminder/tbc_reviewer_reminder/{$row->id}/yes") . " | ";
+            $page_content .= l("Cancel", "tbc_external_review/reminder/tbc_reviewer_reminder");
+  } else {
+            $query = "
+            SELECT DISTINCT pre.id AS id, pre.book, pre.author, pre.edition, usr.uid, erd.failed_reminder, erd.failed_review, erp.first_name, erp.last_name, usr.mail FROM textbook_companion_preference pre
+                    LEFT JOIN external_review_details erd ON erd.preference_id = pre.id          
+                    LEFT JOIN users_roles rol ON erd.uid = rol.uid            
+                    LEFT JOIN users usr ON usr.uid = erd.uid
+                    LEFT JOIN external_review_comments erc ON erc.uid = erd.uid
+                    LEFT JOIN external_review_profile erp ON erp.uid = erd.uid
+                    WHERE erd.status = 1 AND rol.rid = 9 AND erc.review = 0
+                    ";
+            $result = db_query($query);
+            
+            $headers = array(
+             "Book", "Author", "Reviewer Name",
+               "Reminder count", "Action"
+            );
+            $rows = array();  
+            while ($row = db_fetch_object($result)) {
+              $item  =array(        
+                $row->book,
+                $row->author,
+                $row->first_name,       
+                $row->failed_review,
+                l("Remind", "tbc_external_review/reminder/tbc_reviewer_reminder/{$row->id}")
+      );
+      array_push($rows, $item);
+    }
+    $page_content .= theme("table", $headers, $rows);
+  }
+  
+  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-1.11.0.min.js");
-- 
cgit