"ER Books Available",
"page callback" => "tbc_external_review_all",
"access arguments" => array("access tbc_external_review"),
"type" => MENU_CALLBACK
);
$items["tbc_external_review/profile"] = array(
"title" => "TBC External Reviewer Profile",
"page callback" => "tbc_external_review_profile_all",
"access arguments" => array("access tbc_external_review"),
"type" => MENU_CALLBACK
);
$items["tbc_external_review/view_reviewers"] = array(
"title" => "ER List Reviewers",
"page callback" => "tbc_external_review_view_reviewers_all",
"access arguments" => array("administer tbc_external_review"),
"type" => MENU_NORMAL_ITEM
);
$items["tbc_external_review/reviewer_selections"] = array(
"title" => "TBC External Reviewer Selections",
"page callback" => "tbc_external_review_reviewer_selections_all",
"access arguments" => array("administer tbc_external_review"),
"type" => MENU_CALLBACK
);
$items["tbc_external_review/selected_books"] = array(
"title" => "External Review Books",
"page callback" => "tbc_external_review_selected_books_all",
"access arguments" => array("download tbc_external_review"),
"type" => MENU_NORMAL_ITEM
);
$items["tbc_external_review/status"] = array(
"title" => "External Review Status",
"page callback" => "tbc_external_review_status_all",
"access arguments" => array("download tbc_external_review"),
"type" => MENU_NORMAL_ITEM
);
$items["tbc_external_review/comments"] = array(
"title" => "External Review Comments",
"page callback" => "tbc_external_review_comments_all",
"access arguments" => array("download tbc_external_review"),
"weight" => 30,
"type" => MENU_NORMAL_ITEM,
);
$items["tbc_external_review/comments/new"] = array(
"title" => "Review Comment",
"page callback" => "tbc_external_review_comments_all",
"access arguments" => array("download tbc_external_review"),
"weight" => 1,
"type" => MENU_DEFAULT_LOCAL_TASK,
);
$items["tbc_external_review/comments/view"] = array(
"title" => "View Comments",
"page callback" => "tbc_external_review_comments_view_all",
"access arguments" => array("download tbc_external_review"),
"weight" => 2,
"type" => MENU_LOCAL_TASK,
);
$items["tbc_external_review/comments/captions"] = array(
"title" => "Review Captions",
"page callback" => "tbc_external_review_comments_captions_all",
"access arguments" => array("download tbc_external_review"),
"weight" => 2,
"type" => MENU_LOCAL_TASK,
);
$items["tbc_external_review/manage_comments"] = array(
"title" => "ER Manage Comments",
"page callback" => "tbc_external_review_manage_comments_all",
"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",
"access arguments" => array("administer tbc_external_review"),
"type" => MENU_CALLBACK
);
$items["tbc_external_review/manage_status"] = array(
"title" => "ER View Status",
"page callback" => "tbc_external_review_manage_status_all",
"access arguments" => array("administer tbc_external_review"),
"weight" => 30,
"type" => MENU_NORMAL_ITEM
);
$items["tbc_external_review/manage_status/all"] = array(
"title" => "All",
"page callback" => "tbc_external_review_manage_status_all",
"access arguments" => array("administer tbc_external_review"),
"weight" => 1,
"type" => MENU_DEFAULT_LOCAL_TASK,
);
$items["tbc_external_review/manage_status/recent"] = array(
"title" => "Recently Completed",
"page callback" => "tbc_external_review_manage_status_recent_all",
"access arguments" => array("administer tbc_external_review"),
"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",
"access arguments" => array("administer tbc_external_review"),
"type" => MENU_CALLBACK
);
$items["tbc_external_review/ajax"] = array(
"page callback" => "tbc_external_review_ajax",
"access callback" => TRUE,
"type" => MENU_CALLBACK
);
$items["tbc_external_review/eligibility_test"] = array(
"title" => "Eligibility Test",
"page callback" => "tbc_external_review_eligibility_test_all",
"access arguments" => array("access tbc_external_review"),
"type" => MENU_NORMAL_ITEM,
"file" => "tbc_external_review_eligibility_test.inc"
);
$items["tbc_external_review/manage_tests"] = array(
"title" => "Manage Eligibility Test",
"page callback" => "tbc_external_review_manage_tests_all",
"access arguments" => array("administer tbc_external_review"),
"type" => MENU_NORMAL_ITEM,
"file" => "tbc_external_review_eligibility_test.inc"
);
$items["tbc_external_review/er"] = array(
"title" => "ER Assign/ Remove Book",
"page callback" => "tbc_external_review_er_assign_book_all",
"access arguments" => array("access tbc_er_assign_add_remove_books"),
"type" => MENU_NORMAL_ITEM
);
$items["tbc_external_review/er/assign_book"] = array(
"title" => "ER Assign Book",
"page callback" => "tbc_external_review_er_assign_book_all",
"access arguments" => array("access tbc_er_assign_add_remove_books"),
"type" => MENU_DEFAULT_LOCAL_TASK
);
$items["tbc_external_review/er/remove_book"] = array(
"title" => "ER Remove Book",
"page callback" => "tbc_external_review_er_remove_book_all",
"access arguments" => array("access tbc_er_assign_add_remove_books"),
"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/reviewer_reminder"] = array(
"title" => "Reviewer reminder",
"description" => "Failed to complete review",
"page callback" => "_er_reminder_all",
"access arguments" =>array("tbc_external_review_reminder_mail"),
"type" => MENU_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("tbc_external_review_reminder_mail"),
"type" => MENU_LOCAL_TASK
);
/* $items["tbc_external_review/reminder_all"] = array(
"title" => "TBC/ ER Reviewer Reminders",
"description" => "Failed to complete review",
"page callback" => "_er_reminder_page_all",
"access arguments" =>array("download tbc_external_review"),
"type" => MENU_NORMAL_ITEM
);
$items["tbc_external_review/reminder_all/reviewer_reminder_all"] = array(
"title" => "Reviewer reminder",
"description" => "Failed to complete review",
"page callback" => "_er_reminder_page_all",
"access arguments" =>array("download tbc_external_review"),
"type" => MENU_DEFAULT_LOCAL_TASK
);
$items["tbc_external_review/reminder_all/tbc_reviewer_all_reminder"] = array(
"title" => "TBC Reviewer Reminder",
"description" => "Failed to review",
"page callback" => "_tbc_reviewer_reminder_page_all",
"access arguments" =>array("download tbc_external_review"),
"type" => MENU_LOCAL_TASK
);*/
/* ADMIN SETTINGS */
$items['admin/settings/tbc_external_review'] = array(
'title' => 'TBC external review module mail Settings',
'description' => 'TBC external review module mail Settings',
'page callback' => 'drupal_get_form',
'page arguments' => array('tbc_external_review_settings_form'),
'access arguments' => array('access tbc_administrator_mail_settings'),
'type' => MENU_NORMAL_ITEM,
'file' => 'tbc_external_review_settings.inc',
);
return $items;
}
function tbc_external_review_permission(){
return array(
'access tbc_external_review' => array(
'title' => t('access For tbc external review '),
'restrict access' => TRUE,
),
'administer tbc_external_review' => array(
'title' => t('administer tbc external review'),
'restrict access' => TRUE,
),
'tbc_external_review_reminder_mail' => array(
'title' => t('tbc external review reminder mail'),
'restrict access' => TRUE,
),
'download tbc_external_review' => array(
'title' => t('download tbc external review'),
'restrict access' => TRUE,
),
'access tbc_er_assign_add_remove_books' => array(
'title' => t('access tbc er assign add remove books'),
'restrict access' => TRUE,
),
'access tbc_administrator_mail_settings' => array(
'title' => t('access tbc administrator mail settings'),
'restrict access' => TRUE,
),
);
}
/* function tbc_external_review_perm() {
return array(
"access tbc_external_review", "administer tbc_external_review", "tbc_external_review_reminder_mail",
"download tbc_external_review", "access tbc_er_assign_add_remove_books"
);
}
book selection form
{external_review_details} database required.
fields: preference_id, uid, status
status = 1 for selected.
*/
function tbc_external_review_form($form, &$form_state) {
global $user;
$form = array();
/* create multiple checkboxes from database */
$result = remaining_books();
$num_rows = $result->rowCount();
if($num_rows > 0) {
while($row = $result->fetchObject()) {
$form[$row->id] = array(
"#type" => "checkbox",
"#title" => t("{$row->book} by {$row->author} ( ed: {$row->edition}, pub: {$row->year})"),
);
}
$form["submit"] = array(
"#type" => "submit",
"#value" => "Submit",
);
} else {
drupal_set_message("All the available books have been selected. Please wait for more updates. ", "status");
}
return $form;
}
function tbc_external_review_form_validate($form, &$form_state) {
$result = remaining_books();
$count = 0;
$selections = array();
while($row = ($result->fetchObject)) {
if($form_state["values"][$row->id] == 1) {
$count++;
array_push($selections, $row->id);
}
}
$remaining = remaining_books_count();
if($count > $remaining) {
form_set_error("", "You can select a maximum of {$remaining} books.");
} else {
$form_state["values"]["selections"] = $selections;
}
}
function tbc_external_review_form_submit($form, &$form_state) {
global $user;
$selections = $form_state["values"]["selections"];
foreach($selections as $selection) {
/*$query = "update {external_review_details} set uid = {$user->uid}, status = 1, review = 1 where preference_id = {$selection}";
db_query($query);*/
$query = db_update('external_review_details');
$query->fields(array(
'uid' => $user->uid,
'status' => 1,
'review' => 1,
));
$query->condition('preference_id', $selection);
$num_updated = $query->execute();
}
drupal_set_message("Your selections have been updated sucessfully. ", "status");
}
function tbc_external_review_all() {
global $user;
$page_content = "";
$remaining = remaining_books_count();
if($remaining > 0) {
$page_content = "You have {$remaining} selections remaining:";
$tbc_external_review_form = drupal_get_form("tbc_external_review_form");
$page_content .= drupal_render($tbc_external_review_form);
} else {
$page_content = "Thanks for your selections.";
}
return $page_content;
}
/* helper functions */
function remaining_books_count() {
global $user;
/*finding how many books the user can select */
// $query = "select count(*) from {external_review_details} where uid = {$user->uid}";
// $result = db_query($query);
$query = db_select('external_review_details');
$query->addExpression('count(*)');
$query->condition('uid', $user->uid);
$result = $query->execute();
//$row = db_fetch_array($result);
//$remaining = 6 - $row["count(*)"];
$row = $result->fetchAssoc();
$remaining = 6 - $row["count(*)"];
/* while ($row = $result->fetchAssoc()) {
$remaining = 6 - $row["count(*)"];
}*/
return $remaining;
}
function remaining_books() {
$query = "select * from {textbook_companion_preference} where id in (select preference_id from {external_review_details} where status = 0)";
$result = db_query($query);
return $result;
}
function suffix($number) {
/*
considering number will be not more than 10
eg: 11th, 21st - Not required
*/
$output = "";
switch ($number) {
case "1":
$output = $number. "st";
break;
case "2":
$output = $number. "nd";
break;
case "3":
$output = $number. "rd";
break;
default:
$output = $number. "th";
break;
}
return $output;
}
function send_mail_attachment($from, $to, $cc, $bcc, $subject, $message1, $file) {
// $file should include path and filename
$body = $message1;
$filename = basename($file);
$from = str_replace(array("\r", "\n"), '', $from); // to prevent email injection
$file_size = filesize($file);
$handle = fopen($file, "r");
$content = fread($handle, $file_size);
fclose($handle);
$content = chunk_split(base64_encode($content));
$uid = md5(uniqid(time()));
$filename = basename($file);
$eol = PHP_EOL;
// Basic headers
$header = "From: ".$from." <".$from.">".$eol;
$header .= "Reply-To: ".$from.$eol;
$header .= "Cc:". $cc.$eol;
$header .= "Bcc:". $bcc.$eol;
$header .= "MIME-Version: 1.0\r\n";
$header .= "Content-Type: multipart/mixed; boundary=\"".$uid."\"";
// Put everything else in $message
$message = "--".$uid.$eol;
$message .= "Content-Type: text/html; charset=ISO-8859-1".$eol;
$message .= "Content-Transfer-Encoding: 8bit".$eol.$eol;
$message .= $body.$eol;
$message .= "--".$uid.$eol;
$message .= "Content-Type: application/pdf; name=\"".$filename."\"".$eol;
$message .= "Content-Transfer-Encoding: base64".$eol;
$message .= "Content-Disposition: attachment; filename=\"".$filename."\"".$eol;
$message .= $content.$eol;
$message .= "--".$uid."--";
return mail($to, $subject, $message, $header);
}
/* external reviewer profile form,
save the data in {external_review_profile}
*/
function tbc_external_review_profile_form($form, &$form_state) {
global $user;
$form = array();
/* populating the form with previous entry details if exists */
/*$query = "
SELECT * FROM {external_review_profile}
WHERE uid = %d
";
$result = db_query($query, $user->uid);*/
//$row = db_fetch_array($result);
$query = db_select('external_review_profile');
$query->fields('external_review_profile');
$query->condition('uid', $user->uid);
$result = $query->execute();
$row = $result->external_review_profile;
$form["first_name"] = array(
"#type" => "textfield",
"#title" => t("First Name"),
"#required" => True,
"#default_value" => $row["first_name"],
);
$form["last_name"] = array(
"#type" => "textfield",
"#title" => t("Last Name"),
"#required" => True,
"#default_value" => $row["last_name"],
);
$form["designation"] = array(
"#type" => "textfield",
"#title" => t("Designation"),
"#required" => True,
"#default_value" => $row["designation"],
);
$form["university"] = array(
"#type" => "textfield",
"#title" => t("University/Institute"),
"#required" => True,
"#default_value" => $row["university"],
);
$form["phone"] = array(
"#type" => "textfield",
"#title" => t("Phone Number"),
"#required" => True,
"#default_value" => $row["phone"],
);
$form["email"] = array(
"#type" => "textfield",
"#title" => t("Email"),
"#required" => True,
"#default_value" => $row["email"],
);
$form["alt_email"] = array(
"#type" => "textfield",
"#title" => t("Alternate Email"),
"#default_value" => $row["alt_email"],
);
$form["address"] = array(
"#type" => "textarea",
"#title" => t("Postal Address"),
"#required" => True,
"#default_value" => $row["address"],
);
$form["description"] = array(
"#type" => "textarea",
"#title" => t("Description:
(Research interest / Level of expertise in Scilab / Teaching Expertise )
"),
"#required" => True,
"#default_value" => $row["description"],
);
$form["submit"] =array(
"#type" => "submit",
"#value" => "Update Profile",
);
return $form;
}
function tbc_external_review_profile_form_validate($form, &$form_state) {
/* validating phone */
if(!preg_match("/^[0-9]+$/", $form_state["values"]["phone"])) {
form_set_error("phone", "Please enter a valid Phone Number, only (0-9) allowed.");
}
/*validating email */
if(!valid_email_address($form_state["values"]["email"])) {
form_set_error("email", "Please enter a valid Email address");
}
if($form_state["values"]["alt_email"] && !valid_email_address($form_state["values"]["alt_email"])) {
form_set_error("alt_email", "Please enter a valid Alternate Email address" );
}
/* validating address */
if(strlen($form_state["values"]["address"]) < 20) {
form_set_error("address", "Please enter a proper Postal Address.");
}
/* validating description */
if(strlen($form_state["values"]["description"]) < 25) {
form_set_error("description", "Please enter a longer description.");
}
}
function tbc_external_review_profile_form_submit($form, &$form_state) {
global $user;
/* setting $val as the new values array */
$val = array();
$val = $form_state["values"];
/* checking whether the user already has an entry */
/*$query = "select uid from {external_review_profile} where uid = %d";
$result = db_query($query, $user->uid);*/
$query = db_select('external_review_profile');
$query->fields('external_review_profile', array('uid'));
$query->condition('uid', $user->uid);
$result = $query->execute();
$has_entry = $result->rowCount();
if($has_entry) {
/* update the existing entry */
/*$query = "update {external_review_profile}
set
first_name = '%s', last_name = '%s', designation = '%s',
university = '%s', phone = '%s', email = '%s', alt_email = '%s',
address = '%s', description = '%s'
where uid = %d
";
$result = db_query(
$query, $val["first_name"], $val["last_name"], $val["designation"], $val["university"],
$val["phone"], $val["email"], $val["alt_email"], $val["address"], $val["description"],
$user->uid
);*/
$query = db_update('external_review_profile');
$query->fields(array(
'first_name' => $val["first_name"],
'last_name' => $val["last_name"],
'designation' => $val["designation"],
'university' => $val["university"],
'phone' => $val["phone"],
'email' => $val["email"],
'alt_email' => $val["alt_email"],
'address' => $val["address"],
'description' => $val["description"],
'active' => 0,
));
$query->condition('uid', $user->uid);
$result = $query->execute();
} else {
/* create a new entry */
/* $query = "insert into {external_review_profile}
(uid, first_name, last_name, designation, university, phone, email, alt_email, address, description)
values
(%d, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')
";
$result = db_query(
$query, $user->uid, $val["first_name"], $val["last_name"], $val["designation"], $val["university"],
$val["phone"], $val["email"], $val["alt_email"], $val["address"], $val["description"]
);*/
$query = "insert into {external_review_profile}
(uid, first_name, last_name, designation, university, phone, email, alt_email, address, description, active)
values
(:uid, :first_name, :last_name, :designation, :university, :phone, :email, :alt_email, :address, :description, :active)
";
$args = array(
':uid' => $user->uid,
':first_name' => $val["first_name"],
':last_name' => $val["last_name"],
':designation' => $val["designation"],
':university' => $val["university"],
':phone' => $val["phone"],
':email' => $val["email"],
':alt_email' => $val["alt_email"],
':address' => $val["address"],
':description' => $val["description"],
':active' => 0,
);
$result = db_query($query, $args);
}
if($result) {
drupal_set_message("Profile updated successfully. Thank you.", "status");
} else {
drupal_set_message("Database updation failed. Please contact support.", "error");
}
// drupal_goto('tbc_external_review');
drupal_goto('tbc_external_review/eligibility_test');
}
function tbc_external_review_profile_all() {
$page_content = "";
$tbc_external_review_profile_form = drupal_get_form("tbc_external_review_profile_form");
$page_content .= drupal_render($tbc_external_review_profile_form);
return $page_content;
}
function tbc_external_review_view_reviewers_all() {
$page_content = "";
/*$query = "
SELECT * FROM {external_review_profile}
WHERE active = 1
";
$result = db_query($query);*/
$query = db_select('external_review_profile');
$query->fields('external_review_profile');
$query->condition('active', 1);
$result = $query->execute();
$page_content .= "";
while($row = $result->fetchObject()) {
$page_content .= "";
$page_content .= l("{$row->first_name} {$row->last_name}", "tbc_external_review/reviewer_selections/{$row->uid}");
$page_content .= " ";
}
$page_content .= " ";
return $page_content;
}
function tbc_external_review_reviewer_selections_all($uid=0) {
$page_content = "";
/* $query = "SELECT * FROM {external_review_profile} WHERE uid = %d";
$result = db_query($query, $uid);*/
$query = db_select('external_review_profile');
$query->fields('external_review_profile');
$query->condition('uid', $uid);
$result = $query->execute();
$row = $result->fetchObject();
$page_content .= "Books selected by {$row->first_name} {$row->last_name} ";
$query = "
SELECT * FROM {textbook_companion_preference} WHERE id IN
(SELECT preference_id FROM {external_review_details} WHERE uid = :uid)
";
$result = db_query($query, array(':uid' =>$uid));
$page_content .= "";
while($row =$result->fetchObject()) {
$page_content .= "";
$page_content .= t("{$row->book} by {$row->author} ( ed: {$row->edition}, pub: {$row->year})");
$page_content .= " ";
}
$page_content .= " ";
return $page_content;
}
function tbc_external_review_selected_books_all() {
global $user;
$page_content = "";
$query = "
SELECT * FROM {textbook_companion_preference} WHERE id IN
(SELECT preference_id FROM {external_review_details} WHERE uid = :uid)
";
$result = db_query($query, array(':uid' => $user->uid));
$headers = array(
"Book", "Author",
"Edition", "Action",
);
$rows = array();
while($row = $result->fetchObject()) {
$item = array(
"{$row->book}",
"{$row->author}",
"{$row->edition}",
l(t("Download [.zip]"), "full_download_external/book/{$row->id}")
);
array_push($rows, $item);
}
// $page_content .= theme("table", $headers, $rows);
$page_content .= theme('table', array('header' => $headers, 'rows' => $rows ));
return $page_content;
}
function tbc_external_review_comments_all() {
global $user;
$page_content = "";
$page_content .= "* Use this form to notify only examples that have errors.";
$tbc_external_review_comment_form = drupal_get_form("tbc_external_review_comment_form");
$page_content .= drupal_render($tbc_external_review_comment_form);
return $page_content;
}
function tbc_external_review_comments_view_all($preference_id = 0, $review = 0) {
// var_dump('okee');
// die;
global $user;
$page_content = "";
$page_content .= "* Check mark all the captions that do not make sense .
";
$tbc_external_review_comments_captions_form = drupal_get_form("tbc_external_review_comments_captions_form", $preference_id);
$page_content .= drupal_render($tbc_external_review_comments_captions_form);
}
else {
$query = "
SELECT * FROM {textbook_companion_preference} WHERE id IN
(SELECT preference_id FROM {external_review_details} WHERE uid =:uid)
";
$result = db_query($query, array(':uid' => $user->uid));
$headers = array(
"Book", "Edition",
"Action",
);
$rows = array();
while($row = $result->fetchObject()) {
$item = array(
"{$row->book}',
'#suffix' => '
',
'#validated' => TRUE,
'#ajax' => array(
'callback' => 'ajax_tbc_review_example_list_callback',
),
'#options' => _ajax_tbc_review_get_chapter_list($selected),
'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["example"] = array(
"#type" => "select",
'#prefix' => '',
'#suffix' => '
',
"#title" => t("Please select the example"),
'#validated' => TRUE,
'#ajax' => array(
'callback' => 'ajax_tbc_review_example_error_callback',
),
// "#options" => _get_books($user->uid),
'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
// if($form_state['values']['example'] > 0){
$form["error"] = array(
"#type" => "fieldset",
"#title" => "Types of errors found",
"#prefix" => "",
'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["error"]["ncf"] = array(
"#type" => "radios",
"#title" => t("Naming convention followed? (Checklist point 1, 2 and 4)"),
"#options" => array(
t("Yes"),
t("No"),
),
//'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["error"]["eit"] = array(
"#type" => "radios",
"#title" => t("Error in textbook mentioned as comment?"),
"#options" => array(
t("Yes"),
t("No"),
),
// '#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["error"]["axl"] = array(
"#type" => "radios",
"#title" => t("Axes labeled?"),
"#options" => array(
t("Yes"),
t("No"),
),
//'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["error"]["sua"] = array(
"#type" => "radios",
"#title" => t("Symbols used are appropiate?"),
"#options" => array(
t("Yes"),
t("No"),
),
// '#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["error"]["sfu"] = array(
"#type" => "radios",
"#title" => t("Scilab functions used?"),
"#options" => array(
t("Yes"),
t("No"),
),
//'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["error"]["sum"] = array(
"#type" => "radios",
"#title" => t("Solved using Matlab in textbook?"),
"#options" => array(
t("Yes"),
t("No"),
),
//'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["error"]["aci"] = array(
"#type" => "radios",
"#title" => t("Appropriate comments included as mentioned in checklist point 7?"),
"#options" => array(
t("Yes"),
t("No"),
),
// '#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["error"]["auu"] = array(
"#type" => "radios",
"#title" => t("Appropriate units used as given in the textbook?"),
"#options" => array(
t("Yes"),
t("No"),
),
//'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["error"]["teo"] = array(
"#type" => "radios",
"#title" => t("Typographical errors in output and/or comments?"),
"#options" => array(
t("Yes"),
t("No"),
),
//'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["error"]["amt"] = array(
"#type" => "radios",
"#title" => t("Answers matching with the textbook?"),
"#options" => array(
t("Yes"),
t("No"),
),
//'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["error"]["comment"] = array(
"#type" => "textarea",
"#title" => t("Other commment? (if any)"),
//'#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
$form["error"]["submit"] = array(
"#type" => "submit",
"#value" => "Submit Comment",
// '#states' => array('invisible' => array(':input[name="book"]' => array('value' => 0),),),
);
// }
return $form;
}
function ajax_tbc_review_chapter_list_callback($form, $form_state) {
$commands = array();
$book_default_value = $form_state['values']['book'];
if($book_default_value != 0){
$form["chapter"]["#options"] = _ajax_tbc_review_get_chapter_list($book_default_value);
$commands[] = ajax_command_replace('#ajax_tbc_review_select_chapter_lists', drupal_render($form['chapter']));
$commands[] = ajax_command_html('#ajax_tbc_review_select_example_lists','');
$commands[] = ajax_command_html('#comment-error-wrapper','');
}else{
$commands[] = ajax_command_html('#ajax_tbc_review_select_chapter_lists','');
$commands[] = ajax_command_html('#ajax_tbc_review_select_example_lists','');
$commands[] = ajax_command_html('#comment-error-wrapper','');
}
return array('#type' => 'ajax', '#commands' => $commands);
}
function ajax_tbc_review_example_list_callback($form, $form_state) {
$commands = array();
$chapter_default_value = $form_state['values']['chapter'];
if($chapter_default_value != 0){
$form["example"]["#options"] = _ajax_tbc_review_get_example_list($chapter_default_value);
$commands[] = ajax_command_replace('#ajax_tbc_review_select_example_lists', drupal_render($form["example"]));
$commands[] = ajax_command_html('#comment-error-wrapper','');
}else{
$commands[] = ajax_command_html('#ajax_tbc_review_select_example_lists','');
$commands[] = ajax_command_html('#comment-error-wrapper','');
}
return array('#type' => 'ajax', '#commands' => $commands);
}
function ajax_tbc_review_example_error_callback($form, $form_state) {
$commands = array();
$example_default_value = $form_state['values']['example'];
if($example_default_value != 0){
$form["error"]['#states'] = array('invisible' => array(':input[name="book"]' => array('value' => 0),),);
$commands[] = ajax_command_replace('#comment-error-wrapper', drupal_render($form["error"]));
}else{
// $commands[] = ajax_command_html('#ajax_tbc_review_select_example_lists','');
$commands[] = ajax_command_html('#comment-error-wrapper','');
}
return array('#type' => 'ajax', '#commands' => $commands);
}
/*function tbc_external_review_comment_form_validate($form, &$form_state) {
// for future use
}*/
function tbc_external_review_comment_form_submit($form, &$form_state) {
global $user;
$v = $form_state["values"];
/*$query = "
INSERT INTO {external_review_comments}
(uid, preference_id, chapter_id, example_id, ncf, eit, axl, sua, sfu, sum, aci, auu, teo, amt, comment, review)
VALUES
(
%d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, '%s',
(
SELECT review FROM external_review_details WHERE preference_id = %d
)
)
";
$result = db_query(
$query, $user->uid, $v["book"], $v["chapter"], $v["example"],
$v["ncf"], $v["eit"], $v["axl"], $v["sua"], $v["sfu"], $v["sum"],
$v["aci"], $v["auu"], $v["teo"], $v["amt"], $v["comment"], $v["book"]
);*/
$query = "
INSERT INTO {external_review_comments}
(uid, preference_id, chapter_id, example_id, ncf, eit, psi, axl, sua, sfu, sum, aci, auu, teo, amt, comment, review, hidden)
VALUES
(
:uid, :preference_id, :chapter_id, :example_id, :ncf, :eit, :psi, :axl, :sua, :sfu, :sum, :aci, :auu,
:teo, :amt, :comment,
(
SELECT review FROM external_review_details WHERE preference_id = :pref_id
), :hidden
)
";
$args = array(
':uid' => $user->uid,
':preference_id' => $v["book"],
':chapter_id' => $v["chapter"],
':example_id' => $v["example"],
':ncf' => $v["ncf"],
':eit' => $v["eit"],
':psi' => 0,
':axl' => $v["axl"],
':sua' => $v["sua"],
':sfu' => $v["sfu"],
':sum' => $v["sum"],
':aci' => $v["aci"],
':auu' => $v["auu"],
':teo' => $v["teo"],
':amt' => $v["amt"],
':comment' => $v["comment"],
//':review' => 0,
':hidden' => 0,
':pref_id' => $v["book"],
);
$result = db_query($query, $args);
drupal_set_message(t("Comment submited successfully"), "status");
}
/* Ajax Calls */
function tbc_external_review_ajax($item, $key) {
function _bool($var) {
if($var == 1) {
return "No";
}
return "Yes";
}
$data = "";
if($item == "book" && $key) {
/*$query = "select * from {textbook_companion_chapter} where preference_id = %d order by number";
$result = db_query($query, $key);*/
$query = db_select('textbook_companion_chapter');
$query->fields('textbook_companion_chapter');
$query->condition('preference_id', $key);
$query->orderBy('number', 'ASC');
$result = $query->execute();
$data .= "Please select the chapter. ";
while($row = $result->fetchObject()) {
$data .= "{$row->number} {$row->name} ";
}
} else if($item == "chapter" && $key) {
/*$query = "select * from {textbook_companion_example} where chapter_id = %d order by number";
$result = db_query($query, $key);*/
$query = db_select('textbook_companion_example');
$query->fields('textbook_companion_example');
$query->condition('chapter_id', $key);
$query->orderBy('number', 'ASC');
$result = $query->execute();
$data .= "Please select the example. ";
while($row = $result->fetchObject()) {
$data .= "{$row->number} {$row->caption} ";
}
} else if($item == "comment" && $key) {
/*$query = "
SELECT * FROM external_review_comments erc
LEFT JOIN textbook_companion_example_files tcef
ON (erc.example_id = tcef.example_id AND tcef.filetype = 'S')
WHERE erc.id = %d
";
$result = db_query($query, $key);*/
$query = db_select('external_review_comments', 'erc');
$query->fields('erc');
$query->leftJoin ("textbook_companion_example_files", "tcef", "(erc.example_id = tcef.example_id AND tcef.filetype = 'S')");
$query->fields('tcef');
$query->condition('erc.id', $key);
$result = $query->execute();
$row = $result->fetchObject();
/* fetching example file data */
$uploads_dir = $_SERVER['DOCUMENT_ROOT'] . base_path() . "uploads/";
$example_path = $uploads_dir . $row->filepath;
$example = file_get_contents(drupal_realpath($example_path));
//var_dump($example_path);
$data .= "Type of Error Status ";
$data .= "Naming convention followed? " . _bool($row->ncf) . " Error in textbook mentioned as comment? " . _bool($row->eit) . " Problem statement included in code? " . _bool($row->psi) . " Axes labeled? " . _bool($row->axl) . " Symbols used are appropiate? " . _bool($row->sua) . " Scilab functions used? " . _bool($row->sfu) . " Solved using Matlab in textbook? " . _bool($row->sum) . " Appropriate comments included as mentioned in checklist point 7? " . _bool($row->aci) . " Appropriate units used as given in the textbook? " . _bool($row->auu) . " Typographical errors in output and/or comments? " . _bool($row->teo) . " Answers matching with the textbook? " . _bool($row->amt) . " Any Other Comment? " . $row->comment . "
";
$data .= "";
} else if($item == "hide-show" && $key) {
/* $query = "
UPDATE external_review_comments
SET hidden = !hidden
WHERE id = %d
";
$result = db_query($query, $key);
*/
$query = "
UPDATE external_review_comments
SET hidden = !hidden
WHERE id = :id
";
$args = array(':id' => $key);
$result = db_query($query, $args);
/* $query = db_update('external_review_comments');
$query->fields(array(
'hidden' => 'NOT hidden',
));
$query->condition('id', $key);
$result = $query->execute();*/
$data .= $key;
}
else if($item == "hide-show1") {
/* $query = "
UPDATE external_review_details
SET hidden = !hidden
WHERE preference_id = %d
";
$result = db_query($query,$key);*/
$query = "
UPDATE external_review_details
SET hidden = !hidden
WHERE preference_id = :preference_id
";
$args = array(':preference_id' => $key);
$result = db_query($query, $args);
/*$query = db_update('external_review_details', 'erd');
$query->fields('erd', array(
'erd.hidden' => 'NOT erd.hidden',
));
$query->condition('preference_id', $key);
$result = $query->execute();*/
$data .= $key;
}else if($item == "toggle" && $key) {
/* $query = "
UPDATE external_review_comments
SET hidden = !hidden
WHERE preference_id = %d AND (
sfu != 1 AND
sum != 0 AND
amt != 1
)
";
$result = db_query($query, $key);*/
$query = "
UPDATE external_review_comments
SET hidden = !hidden
WHERE preference_id = :preference_id AND (
sfu != 1 AND
sum != 0 AND
amt != 1
)
";
$args = array(':preference_id' => $key);
$result = db_query($query, $args);
/* $query = db_update('external_review_comments');
$query->fields(array(
'hidden' => '!hidden',
));
$query->condition('preference_id', $key);
$query->condition('sfu', 1, '<>');
$query->condition('amt', 1, '<>');
$result = $query->execute();*/
$data .= $key;
}
echo $data;
exit();
}
/* Comment form helper functions */
function _ajax_tbc_review_get_books_list($uid) {
$query = "select * from {textbook_companion_preference} where id in
(select preference_id from {external_review_details} where uid = :uid) ORDER BY book ASC
";
$result = db_query($query, array(":uid" =>$uid));
$books = array();
$books[0] = "Please select a book";
while($row = $result->fetchObject()) {
$books[$row->id] = $row->book.' [ '.$row->author.' ]';
}
return $books;
}
function tbc_external_review_status_edit_form($form, &$form_state, $preference_id=0) {
/*$query = "
SELECT * FROM external_review_details
WHERE preference_id = %d
";
$result = db_query($query, $preference_id);*/
/*$query = db_select('external_review_details');
$query->fields('external_review_details');
$query->condition('preference_id', $preference_id);
$result = $query->execute();*/
$query = "
SELECT * FROM external_review_details
WHERE preference_id = {:preference_id}
";
$args = array(':preference_id' => $preference_id);
$result = db_query($query,$args);
$row = $result->fetchObject();
$form = array();
$form = array(
"#prefix" => "",
"#suffix" => "
"
);
$form["review"] = array(
"#type" => "select",
"#title" => "Review Number",
"#options" => range(0,10),
"#default_value" => $row->review,
);
$form["status"] = array(
"#type" => "radios",
"#title" => "Status",
"#options" => array(
t("Ongoing"),
t("Completed")
),
"#default_value" => $row->completed,
);
$form["preference_id"] = array(
"#type" => "hidden",
"#default_value" => $preference_id
);
$form["submit"] = array(
"#type" => "submit",
"#value" => "Update"
);
$form["cancel"] = array(
"#type" => "button",
"#value" => "Cancel",
);
return $form;
}
function tbc_external_review_status_edit_form_submit($form, &$form_state) {
/*$query = "
UPDATE external_review_details
SET review = {$form_state['values']['review']},
completed = {$form_state['values']['status']}
WHERE preference_id = {$form_state['values']['preference_id']}
";
$result = db_query($query);*/
$preferenceid = $form_state['values']['preference_id'];
$completed = $form_state['values']['status'];
$review = $form_state['values']['review'];
$query = db_update('external_review_details');
$query->fields(array(
'review' => $review,
'completed' => $completed,
));
$query->condition('preference_id', $preferenceid);
$result = $query->execute();
if(!$result) {
drupal_set_message("An error occured during updation.", "error");
} else {
drupal_set_message("Updated successfully.", "status");
}
}
function tbc_external_review_manage_status_all($action="", $preference_id=0, $confirm="") {
global $base_url;
$page_content = "";
if($action == "next" && $preference_id && $confirm == "yes") {
$query = "
UPDATE external_review_details
SET review = review + 1, completed = 0, sent = 0
WHERE preference_id = :preference_id
";
$args = array(":preference_id" => $preference_id);
$result = db_query($query,$args);
/* $query = db_update('external_review_details');
$query->fields(array(
'review' => 'review + 1',
'completed' => 0,
'sent' => 0,
));
$query->condition('preference_id', $preference_id);
$result = $query->execute();*/
if (!$result) {
drupal_set_message("Database updation failed", "error");
} else {
/* preparing to send mail to reviewer */
$query = "
SELECT * FROM textbook_companion_preference pre
LEFT JOIN textbook_companion_proposal pro ON pre.proposal_id = pro.id
LEFT JOIN external_review_details erd ON pre.id = erd.preference_id
LEFT JOIN users usr ON erd.uid = usr.uid
WHERE pre.id = :preference_id
";
$result = db_query($query, array(':preference_id' => $preference_id));
$row = $result->fetchObject();
$review_no = suffix($row->review);
$download_link = "Download [.zip] ";
/* sending mail */
$to = "{$row->mail}";
$subject = "Please Start {$review_no} Review - Textbook Companion Project";
$message = "
Dear {$row->name} {$row->book} {$row->author} {$review_no} {$download_link} " . suffix($row->review+1) . " review? {$row->book} {$row->author} {$row->name} {$row->reviewer} Status Edit Form ";
$page_content .= "Book: {$row->book} {$row->author} by {$row->author} ",
suffix($row->review),
($row->completed?"Completed":"Ongoing"),
"{$row->name}",
($row->completed?l("Next", "tbc_external_review/manage_status/next/" . $row->preference_id):"---") . " | " . l("Edit", "tbc_external_review/manage_status/edit/{$row->preference_id}")
);
array_push($rows, $item);
}
$page_content .= "Selected Books Books Not Selected by {$row->author} ",
suffix($row->review),
($row->status?"Completed":"Ongoing"),
"{$row->time}",
"{$row->name}"
);
array_push($rows, $item);
}
//$page_content .= theme("table", $headers, $rows);
$page_content .= theme('table', array('header' => $headers, 'rows' => $rows ));
return $page_content;
}
function tbc_external_review_manage_comments_all($preference_id=0, $review=0) {
global $base_url;
$page_content = "";
if($preference_id) {
$page_content .= "Toggle Hide-Show ";
$page_content .= "
";
$page_content .= "by {$row->author} ",
suffix($row->review),
($row->completed?"Completed":"Ongoing"),
"{$row->contributor}",
"{$row->reviewer}",
l("View", "tbc_external_review/manage_comments/" . $row->preference_id)
),
);
// not supported in drupal 7
/* if($row->hidden) {
$class_attrtibute = $item['class'];
$class = array("class" => " dulls");
$class_attrtibute .= $class;
} */
$key = key(array('class' => $item["class"]));
if($row->hidden) {
$item["class"][$key] .= " dulls";
}
end($item["data"]);
$key = key($item["data"]);
if(!$row->sent) {
$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["data"][$key] .= " | " . l("Hide", "",$hide_optionss);
}
//
array_push($rows, $item);
}}
//$page_content .= theme("table", $headers, $rows);
$page_content .= theme('table', array('header' => $headers, 'rows' => $rows ));
}
return $page_content;
}
function tbc_external_review_mail_comments_all($preference_id=0, $confirm="") {
function _bool($var) {
if($var == 1) {
return "No";
}
return "Yes";
}
$page_content = "";
if($confirm == "confirm") {
/*$query = "
SELECT * FROM external_review_details
WHERE preference_id = %d
";
$result = db_query($query, $preference_id);*/
$query = db_select('external_review_details');
$query->fields('external_review_details');
$query->condition('preference_id', $preference_id);
$result = $query->execute();
$row = $result->fetchObject();
$current_review = $row->review;
$review_dir = $_SERVER['DOCUMENT_ROOT'] . base_path() . "reviews/{$row->preference_id}/";
if(!file_exists($review_dir)) {
mkdir($review_dir, 0755, TRUE);
}
$review_file = $review_dir . "{$row->preference_id}-review-{$row->review}" . ".csv";
$fp = fopen($review_file, "w");
/* making the first row */
$item = array(
"Chapter No.", "Example No.",
"Naming convention followed?", "Error in textbook mentioned as comment?",
"Problem statement included in code?", "Axes labeled?", "Symbols used are appropiate?",
"Scilab functions used?", "Solved using Matlab in textbook?",
"Appropriate comments included?", "Appropriate units used as given in the textbook?",
"Typographical errors in output and/or comments?", "Answers matching with the textbook?", "Other Comments"
);
fputcsv($fp, $item);
$query = "
SELECT erc.*, cha.number AS chapter, exa.number AS example FROM external_review_comments erc
LEFT JOIN textbook_companion_chapter cha ON erc.chapter_id = cha.id
LEFT JOIN textbook_companion_example exa ON erc.example_id = exa.id
WHERE (erc.hidden = 0 AND erc.preference_id = :preference_id AND erc.review = :current_review)
ORDER BY chapter, example
";
$args = array(':preference_id' => $preference_id, ':current_review'=>$current_review);
$result = db_query($query, $args);
while($row = $result->fetchObject()) {
$item = array(
$row->chapter, $row->example,
_bool($row->ncf), _bool($row->eit),
_bool($row->psi), _bool($row->axl),
_bool($row->sua), _bool($row->sfu),
_bool($row->sum), _bool($row->aci),
_bool($row->auu), _bool($row->teo),
_bool($row->amt), "{$row->comment}"
);
fputcsv($fp, $item);
}
fclose($fp);
/* preparing and sending mail */
$query = "
SELECT * FROM external_review_details erd
LEFT JOIN textbook_companion_preference pre ON erd.preference_id = pre.id
LEFT JOIN textbook_companion_proposal pro ON pre.proposal_id = pro.id
LEFT JOIN users usr ON pro.uid = usr.uid
WHERE erd.preference_id = :preference_id
";
$args = array(':preference_id' => $preference_id);
$result = db_query($query, $args);
$row = $result->fetchObject();
$review_no = suffix($row->review);
$file = $review_file;
/*********************************************************/
$to = $row->mail;
$from = variable_get('tbc_external_review_from_email', '');
$bcc = variable_get('tbc_external_review_bcc_emails', '');
$cc = variable_get('tbc_external_review_cc_emails', '');
$subject = "Scilab Textbook Companion - {$review_no} Review";
$message = "
Dear {$row->name}{$row->book} {$row->author} {$review_no} Reply to this mail once the corrections are done. Note: The attachment is a comma separated file, which can be viewed using any office software. Are you sure you want to send mail? {$row->book} {$row->author} {$row->name} {$row->mail} ",
"#suffix" => "
"
);
$form["review"] = array(
"#type" => "select",
"#title" => "Review Number",
"#options" => range(0,10),
"#default_value" => 1
);
$form["preference_id"] = array(
"#type" => "hidden",
"#default_value" => $preference_id
);
$form["submit"] = array(
"#type" => "submit",
"#value" => "Submit"
);
$form["cancel"] = array(
"#type" => "button",
"#value" => "Cancel",
);
return $form;
}
function tbc_external_review_add_book_form_submit($form, &$form_state) {
$preference_id = $form_state["values"]["preference_id"];
$review = $form_state["values"]["review"];
/* $query = "
INSERT INTO {external_review_details}
(preference_id, review)
VALUES
(%d, %d)
";
$result = db_query($query, $preference_id, $review);*/
$query = "
INSERT INTO {external_review_details}
(uid, preference_id, review, status, completed, published, sent)
VALUES
(:uid, {:preference_id},{:review}, :status, :completed, :published, :sent)
";
$args = array(':uid' => 0,
':preference_id' => $preference_id,
':review' => $review,
':status' => 0,
':completed' => 0,
':published' => 0,
':sent' => 0
);
$result = db_query($query, $args);
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)
";
$result = db_query($query, $preference_id);*/
/* $query = db_update('textbook_companion_proposal');
$query->fields(array(
'proposal_status' => 4,
));
$subquery = db_select('textbook_companion_preference', '');
$subquery->fields('proposal_id', array(''));
$subquery->condition('id', $preference_id);
$query->condition('id', $subquery, 'IN');
$result = $query->execute();*/
$query = "
UPDATE textbook_companion_proposal
SET proposal_status = 4
WHERE id IN
(SELECT proposal_id from textbook_companion_preference WHERE id = :preference_id)
";
$args = array(':preference_id' => $preference_id);
$result = db_query($query,$args);
if(!$result) {
drupal_set_message("Book status update failed.", "error");
} else {
drupal_set_message("Book added successfully.", "status");
}
drupal_goto("manage_proposal/all");
}
function tbc_external_review_add_book_all($preference_id=0) {
if ($preference_id) {
$page_content = "";
/*$query = "
SELECT * FROM {textbook_companion_preference} WHERE id = %d
";
$result = db_query($query, $preference_id);*/
$query = "
SELECT * FROM {textbook_companion_preference} WHERE id = :preference_id
";
$args =array (':preference_id' => $preference_id);
$result = db_query($query,$args );
$row = $result->fetchObject();
$page_content .= "Do you want to continue adding the book? ",
"#suffix" => "
"
);
$form["wrapper"]["missing"] = array(
"#title" => "Are all examples from the book attempted by the contributor?",
"#type" => "radios",
"#options" => array(
t("Yes"),
t("No")
),
);
$form["wrapper"]["list"] = array(
"#prefix" => "",
"#suffix" => "
",
);
$form["wrapper"]["list"]["missed_chapter"] = array(
"#title" => "Chapter",
"#type" => "select",
"#options" => _missed_chapter()
);
$form["wrapper"]["list"]["missed_example"] = array(
"#title" => "Example",
"#type" => "select",
"#options" => _missed_example(),
);
$form["wrapper"]["more"] = array(
"#type" => "markup",
"#value" => "Add More {$row->book} {$row->author} {$review_no} Are you sure you want to mark the book completed? {$row->author} ",
suffix($row->review),
);
if($row->completed){
array_push($item, "Completed");
} else {
array_push(
$item, l("Mark Completed", "tbc_external_review/status/complete/".$row->preference_id)
);
}
array_push($rows, $item);
}
// $page_content .= theme("table", $headers, $rows);
$page_content .= theme('table', array('header' => $headers, 'rows' => $rows ));
}
return $page_content;
}
function tbc_external_review_er_assign_book_form($form,$form_state){
/* $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
ORDER BY pre.book ASC
";*/
$query = "
SELECT pre.proposal_id, 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
LEFT JOIN textbook_companion_proposal po ON pre.proposal_id = po.id
WHERE erd.status = 0 AND po.proposal_status !=3
ORDER BY pre.book ASC
";
$result = db_query($query);
$books = array();
$books[0] = "Please select a book";
while($row1 = $result->fetchObject()) {
$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
LEFT JOIN external_review_profile erp ON erp.uid = usr.uid
WHERE rol.rid = 9
ORDER BY erp.first_name ASC
";
$results = db_query($querys);
$reviewers = array();
$reviewers[0] = "Please select a reviewer";
while($row = $results->fetchObject()) {
$reviewers[$row->uid] = "{$row->first_name} {$row->last_name}";
}
$form = array();
$form["reviewers"] = array(
"#type" => "select",
"#title" => "",
"#description" => t("Please select a reviewer."),
"#options" => $reviewers
);
$form["book"] = array(
"#type" => "select",
"#title" => "",
"#description" => t("Please select a book."),
"#options" => $books
);
$form["submit"] = array(
"#type" => "submit",
"#value" => "Submit",
);
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.");
}
if(!$form_state["values"]["book"]) {
form_set_error("book", "Please select a book.");
}
}
function tbc_external_review_er_assign_book_form_submit($form, &$form_state){
$v = $form_state["values"];
/* $query = "
UPDATE external_review_details
SET status = 1 , uid = %d
WHERE preference_id = %d
";
$result = db_query($query,
$v["reviewers"], $v["book"]
);*/
$query = db_update('external_review_details');
$query->fields(array(
'status' => 1,
'uid' => $v["reviewers"],
));
$query->condition('preference_id', $v["book"]);
$result = $query->execute();
drupal_set_message("Book alloted successfully", "status");
}
function tbc_external_review_er_assign_book_all() {
$page_content .= "";
$page_content .= "";
$page_content .= "";
$page_content .= "";
$assign_book_form = drupal_get_form("tbc_external_review_er_assign_book_form");
$page_content .= drupal_render($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
LEFT JOIN external_review_details erd ON erd.preference_id = pre.id
LEFT JOIN users usr ON usr.uid = erd.uid
WHERE erd.status = 1
ORDER BY pre.book ASC
";
$result = db_query($query);*/
$query = db_select('textbook_companion_preference', 'pre');
$query->fields('pre', array('id', 'book', 'author', 'edition'));
$query->fields('usr', array('uid'));
$query->leftJoin('external_review_details', 'erd', 'erd.preference_id = pre.id');
$query->leftJoin('users', 'usr', 'usr.uid = erd.uid');
$query->condition('erd.status', 1);
$query->orderBy('pre.book', 'ASC');
$result = $query->execute();
$books = array();
$books[0] = "Please select a book";
while($row = $result->fetchObject()) {
$books[$row->id] = "{$row->book} (Author: {$row->author}, Edition: {$row->edition})";
}
$form["book"] = array(
"#type" => "select",
"#title" => "",
"#description" => t("Please select a book."),
"#options" => $books
);
$form["submit"] = array(
"#type" => "submit",
"#value" => "Submit",
);
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 = "
UPDATE external_review_details
SET status = 0 , uid = 0
WHERE preference_id = %d
";
$result = db_query($query,
$v["book"]
); */
$query = db_update('external_review_details');
$query->fields(array(
'status' => 0,
'uid' => 0,
));
$query->condition('preference_id', $v["book"]);
$result = $query->execute();
drupal_set_message("Book removed successfully", "status");
}
function tbc_external_review_er_remove_book_all() {
$page_content .= "";
$er_remove_book_form = drupal_get_form("tbc_external_review_er_remove_book_form");
$page_content .= drupal_render($er_remove_book_form);
return $page_content;
}
function _er_reminder_all($id=0, $confirm = "") {
function _er_reminder_mail($id){
$query = "
SELECT pre.id AS id, pre.book, pre.author, pre.edition, erd.failed_reminder,
erd.time, 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 = $result->fetchObject();
$start_date = new DateTime($row->time);
$current_date = new DateTime();
$since_start = $start_date->diff($current_date);
$diff = ($since_start->format('%a'));
if($diff % 15 == 0){
$query = "
UPDATE external_review_details
SET failed_reminder = failed_reminder + 1
WHERE preference_id = {:preference_id}
";
/* sending mail */
$to = $row->mail;
$subject = "Reminder to complete review";
$message = "
Dear Reviewer,
";
//drupal_mail_send($message);
send_mail("textbook@scilab.in", $to, $subject, $message);
db_query($query, array(':preference_id' => $id));
} else {
}
}
$query = "
SELECT pre.id AS id, pre.book, pre.author, pre.edition, usr.uid, erd.time, 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"
);
$rows = array();
while ($row = $result->fetchObject()) {
$item =array(
$row->book,
$row->author,
$row->first_name. " ". $row->last_name,
$row->failed_reminder,
_er_reminder_mail($row->id),
);
}
}
function _er_tbc_reviewer_reminder_all($id=0, $confirm="") {
function _tbc_er_reminder_mail($id){
/*$query = "
SELECT DISTINCT pre.id, erc.review AS id, pre.book, pre.author, pre.edition, usr.uid, erd.time, 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);*/
$query = db_select('textbook_companion_preference', 'pre');
$query->fields('pre', array('id', 'book', 'author', 'edition'));
$query->fields('erc', array('review', 'review'));
$query->fields('usr', array('uid', 'mail'));
$query->fields('erd', array('time', 'failed_reminder', 'failed_review'));
$query->fields('erp', array('first_name', 'last_name'));
$query->leftJoin('external_review_details', 'erd', 'erd.preference_id = pre.id');
$query->leftJoin('users_roles', 'rol', 'erd.uid = rol.uid');
$query->leftJoin('users', 'usr', 'usr.uid = erd.uid');
$query->leftJoin('external_review_comments', 'erc', 'erc.uid = erd.uid');
$query->leftJoin('external_review_profile', 'erp', 'erp.uid = erd.uid');
$query->condition('erd.status', 1);
$query->condition('rol.rid', 9);
$query->condition('erc.review', 0);
$query->condition('pre.id',$id);
$result = $query->execute();
$row = $result->fetchObject();
$start_date = new DateTime($row->time);
$current_date = new DateTime();
$since_start = $start_date->diff($current_date);
$diff = ($since_start->format('%a'));
if($diff % 15 == 0){
/* increment failed to review */
/* $query = "
UPDATE external_review_details
SET failed_review = failed_review + 1
WHERE preference_id = {$id}
";*/
$query = db_update('external_review_details');
$query->fields(array(
'failed_review' => 'failed_review + 1',
));
$query->condition('preference_id', $id);
$query = $query->execute();
/* sending mail */
$to = $row->mail;
$subject = "External reviewers book delay";
$message= "
Dear TBC Reviewers,{$row->first_name} {$row->last_name} has failed to review the Book: {$row->book} , Author: {$row->author} ,
Edition: {$row->edition} on time.
";
//drupal_mail_send($message);
send_mail("textbook@scilab.in", $to, $subject, $message);
db_query($query);
} 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);*/
$query = db_select('textbook_companion_preference', 'pre');
$query->fields('pre', array('id', 'book', 'author', 'edition'));
$query->fields('usr', array('uid', 'mail'));
$query->fields('erd', array('failed_reminder', 'failed_review'));
$query->fields('erp', array('first_name', 'last_name'));
$query->leftJoin('external_review_details', 'erd', 'erd.preference_id = pre.id');
$query->leftJoin('users_roles', 'rol', 'erd.uid = rol.uid');
$query->leftJoin('users', 'usr', 'usr.uid = erd.uid');
$query->leftJoin('external_review_comments', 'erc', 'erc.uid = erd.uid');
$query->leftJoin('external_review_profile', 'erp', 'erp.uid = erd.uid');
$query->condition('erd.status', 1);
$query->condition('rol.rid', 9);
$query->condition('erc.review', 0);
$result = $query->execute();
$headers = array(
"Book", "Author", "Reviewer Name", "Remainders"
);
$rows = array();
while ($row = $result->fetchObject()) {
$item = array(
$row->book,
$row->author,
$row->first_name ." ". $row->last_name,
$row->failed_review,
_tbc_er_reminder_mail($row->id),
);
}
}
function _er_reminder_page_all($id=0) {
$page_content = "";
/*$query = "
SELECT pre.id AS id, pre.book, pre.author, pre.edition, usr.uid, erd.time, 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);*/
$query = db_select('textbook_companion_preference', 'pre');
$query->fields('pre', array('id', 'book', 'author', 'edition'));
$query->fields('usr', array('uid', 'mail'));
$query->fields('erd', array('time', 'failed_reminder'));
$query->fields('erp', array('first_name', 'last_name'));
$query->leftJoin('external_review_details', 'erd', 'erd.preference_id = pre.id');
$query->leftJoin('users_roles', 'rol', 'erd.uid = rol.uid');
$query->leftJoin('users', 'usr', 'usr.uid = erd.uid');
$query->leftJoin('external_review_profile', 'erp', 'erp.uid = erd.uid');
$query->condition('erd.status', 1);
$query->condition('completed', 0);
$query->condition('rol.rid', 9);
$result = $query->execute();
$headers = array(
"Book", "Author", "Reviewer Name",
"Remainders"
);
$rows = array();
while ($row = $result->fetchObject()) {
$item =array(
$row->book,
$row->author,
$row->first_name. " ". $row->last_name,
$row->failed_reminder
);
array_push($rows, $item);
}
//$page_content .= theme("table", $headers, $rows);
$page_content .= theme('table', array('header' => $headers, 'rows' => $rows ));
return $page_content;
}
function _tbc_reviewer_reminder_page_all($id=0, $confirm="") {
$page_content = "";
/*$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); */
$query = db_select('textbook_companion_preference', 'pre');
$query->fields('pre', array('id', 'book', 'author', 'edition'));
$query->fields('usr', array('uid', 'mail'));
$query->fields('erd', array('failed_reminder', 'failed_review'));
$query->fields('erp', array('first_name', 'last_name'));
$query->leftJoin('external_review_details', 'erd', 'erd.preference_id = pre.id');
$query->leftJoin('users_roles', 'rol', 'erd.uid = rol.uid');
$query->leftJoin('users', 'usr', 'usr.uid = erd.uid');
$query->leftJoin('external_review_comments', 'erc', 'erc.uid = erd.uid');
$query->leftJoin('external_review_profile', 'erp', 'erp.uid = erd.uid');
$query->condition('erd.status', 1);
$query->condition('rol.rid', 9);
$query->condition('erc.review', 0);
$result = $query->execute();
$headers = array(
"Book", "Author", "Reviewer Name", "Remainders"
);
$rows = array();
while ($row = $result->fetchObject()) {
$item = array(
$row->book,
$row->author,
$row->first_name ." ". $row->last_name,
$row->failed_review,
);
array_push($rows, $item);
}
//$page_content .= theme("table", $headers, $rows);
$page_content .= theme('table', array('header' => $headers, 'rows' => $rows ));
return $page_content;
}
/*Used to replace drupal_mail*/
function send_mail($from, $to, $subject, $message) {
$my_module = 'tbc-external-review';
$my_mail_token = microtime();
$message = array(
'id' => $my_module . '_' . $my_mail_token,
'to' => $to,
'subject' => $subject,
'body' => array($message),
'headers' => array(
'From' => $from,
'Sender' => $from,
'Return-Path' => $from,
'Bcc' =>variable_get('tbc_external_review_bcc_emails', NULL),
),
);
$system = drupal_mail_system($my_module, $my_mail_token);
$message = $system->format($message);
if ($system->mail($message)) {
return TRUE;
}
else {
return FALSE;
}
}
function tbc_external_review_init() {
drupal_add_css(drupal_get_path("module", "tbc_external_review") . "/css/tbc_external_review.css");
drupal_add_css(drupal_get_path("module", "tbc_external_review") . "/css/pop.css");
drupal_add_js(drupal_get_path("module", "tbc_external_review") . "/js/jquery-1.9.1.js");
drupal_add_js(drupal_get_path("module", "tbc_external_review") . "/js/jquery-noconfilct.js");
// drupal_add_js(drupal_get_path("module", "tbc_external_review") . "/js/jquery.lightbox_me.js");
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");
}
function _ajax_tbc_review_get_chapter_list($preference_id = 0)
{
$book_chapters = array('0' => 'Please select...');
/*$book_chapters_q = db_query("SELECT * FROM {textbook_companion_chapter} WHERE preference_id = %d ORDER BY number ASC", $preference_id);*/
$query = db_select('textbook_companion_chapter');
$query->fields('textbook_companion_chapter');
$query->condition('preference_id', $preference_id);
$query->orderBy('number', 'ASC');
$book_chapters_q = $query->execute();
while ($book_chapters_data = $book_chapters_q->fetchObject())
{
$book_chapters[$book_chapters_data->id] = $book_chapters_data->number . '. ' . $book_chapters_data->name;
}
return $book_chapters;
}
function _ajax_tbc_review_get_example_list($chapter_id = 0)
{
$book_examples = array('0' => 'Please select...');
/*$book_examples_q = db_query("SELECT * FROM {textbook_companion_example} WHERE chapter_id = %d ORDER BY
CAST(SUBSTRING_INDEX(number, '.', 1) AS BINARY) ASC,
CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(number , '.', 2), '.', -1) AS UNSIGNED) ASC,
CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(number , '.', -1), '.', 1) AS UNSIGNED) ASC", $chapter_id);*/
$query = db_select('textbook_companion_example');
$query->fields('textbook_companion_example');
$query->condition('chapter_id', $chapter_id);
//$query->orderBy('CAST', 'ASC');
//$query->orderBy('CAST', 'ASC');
//$query->orderBy('CAST', 'ASC');
$book_examples_q = $query->execute();
while ($book_examples_data = $book_examples_q->fetchObject())
{
$book_examples[$book_examples_data->id] = $book_examples_data->number . ' (' . $book_examples_data->caption . ')';
}
return $book_examples;
}