From 9721baea9f8c2c181c75879a5245e50c2d64be36 Mon Sep 17 00:00:00 2001
From: Jayaram Pai
Date: Sat, 1 Mar 2014 14:19:08 +0530
Subject: added add_book textbook_companion /manage_proposal/all

ref: "function _proposal_all()" in manage_proposal.inc of
textbook_companion module.
new proposal_status:4 - External
---
 tbc_external_review.module | 48 ++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 48 insertions(+)

diff --git a/tbc_external_review.module b/tbc_external_review.module
index 6847237..db94052 100644
--- a/tbc_external_review.module
+++ b/tbc_external_review.module
@@ -50,6 +50,12 @@
             "access arguments" => array("administer tbc_external_review"),
             "type" => MENU_NORMAL_ITEM
         );
+        $items["tbc_external_review/add_book"] = array(
+            "title" => "ER Add Book",
+            "page callback" => "tbc_external_review_add_book_all",
+            "access arguments" => array("administer tbc_external_review"),
+            "type" =>  MENU_CALLBACK
+        );
         $items["tbc_external_review/ajax"] = array(
             "page callback" => "tbc_external_review_ajax",
             "access arguments" => array("download tbc_external_review"),
@@ -697,6 +703,48 @@
         return $page_content;
     }
 
+    function tbc_external_review_add_book_all($preference_id=0, $action = "") {
+        if($action == "confirm") {
+            $query = "
+                INSERT INTO {external_review_details}
+                (preference_id)
+                VALUES
+                (%d)
+            ";
+            $result = db_query($query, $preference_id);
+            if(!$result) {
+                drupal_set_message("An error occured while adding the book for review.", "error");
+            } 
+            $query = "
+                UPDATE textbook_companion_proposal
+                SET proposal_status = 4
+                WHERE id IN
+                (SELECT proposal_id from textbook_companion_preference WHERE id = %d)
+            ";
+            if(!$result) {
+                drupal_set_message("Book status update failed.", "error");
+            } else {
+                drupal_set_message("Book added successfully.", "status");
+            }
+            $result = db_query($query, $preference_id);
+        } else if ($preference_id) {
+            $page_content = "";
+            $query = "
+                SELECT * FROM {textbook_companion_preference} WHERE id = %d
+            ";
+            $result = db_query($query, $preference_id);
+            $row = db_fetch_object($result);
+            $page_content .= "<strong>Do you want to continue adding the book ?</strong><br>";
+            $page_content .= "Book: {$row->book} <br>";
+            $page_content .= "Author: {$row->author} <br>";
+            $page_content .= l("Yes", "tbc_external_review/add_book/{$row->id}/confirm") . " | ";
+            $page_content .= l("Cancel", "manage_proposal/all");
+            return $page_content;
+        }
+        drupal_goto("manage_proposal/all");
+    }
+
+
     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");
-- 
cgit