diff options
| -rw-r--r-- | tbc_external_review.module | 48 |
1 files changed, 48 insertions, 0 deletions
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"); |