function prepare_message_review($dbh, $req_id)
{
$_SESSION['requestid'] = $req_id;
/* In order to display the message review screen, we need to first get the request record. Then the
* account ID is used to log into the Bronto API to extract other message-oriented information.
*/
$reqinfo = db_load_request($dbh, $req_id);
if ($reqinfo != null) {
$acctid = $reqinfo['account_id'];
$login_info = bronto_agency_login($acctid);
if ($login_info) {
$bapi = $login_info['binding'];
$session_id = $login_info['sessionID'];
$_SESSION['session_id'] = $session_id;
$username = $_SESSION['username'];
$rc = db_save_session($dbh, $session_id, $username, $acctid);
if ($rc == false) {
display_warnbox("Unable to save session information (id=" . $session_id . ",user="******")");
}
print_message_review_form($bapi, $session_id, $reqinfo);
if (db_update_request_status($dbh, $req_id, "UNDER_REVIEW") == false) {
display_warnbox("Unable to update request status.");
}
} else {
display_errorbox("Unable to contact the Bronto API server.");
print_requestid_form($req_id);
}
} else {
display_errorbox("Request ID " . $req_id . " is invalid.");
print_requestid_form($req_id);
}
}
$key_field = 'username';
$key_value = $_POST['username'];
if ($key_value != 'reviewer1') {
$result = db_get_records($dbh, $table_name, $key_field, $key_value, $sortby = null);
if ($result != null) {
$to_addr = $result[0]['email'];
$to_name = $result[0]['firstname'] . ' ' . $result[0]['lastname'];
$key_value = $_POST['fm_username'];
$result = db_get_records($dbh, $table_name, $key_field, $key_value, $sortby = null);
$from_addr = $result[0]['email'];
$from_name = $result[0]['firstname'] . ' ' . $result[0]['lastname'];
$cc_addrs = array();
$subject = 'Message with request ID# ' . $fm_requestid . ' is reassigned to you.';
$url_str = get_review_url($fm_requestid);
$body = "Hello " . $to_name . "!\n\n" . "{$from_name} has assigned a T-Reqs email approval request to you, for the email titled " . $result_message[0]['message_name'] . ".\n\n" . "Please use the link below to sign into the T-Reqs website, review the message, and either approve or reject it based on Senate guidelines." . ".\n\n" . " {$url_str}\n\n\n" . "Please reference the information provided below " . "with technical questions.\n\n" . "Request Details:\n" . " Request ID: {$fm_requestid}\n" . " Message Name: " . $result_message[0]['message_name'] . "\n" . " Site Name: " . $result_message[0]['account_name'] . "\n\n" . "\n\n\n" . "Sincerely,\n\n" . "{$from_name}\n" . "(via " . APP_NAME . ")\n\n";
send_email_message($from_addr, $from_name, $to_addr, $to_name, $cc_addrs, $subject, $body);
}
}
} else {
$result = db_get_records($dbh, "request", "uuid", $fm_requestid, $sortby = null);
db_update_request_status_user($dbh, $fm_requestid, $result[0]['status'], $result[0]['request_notes'], $result[0]['reviewer']);
}
include 'display_listrequest.php';
//AB //show request list
print_requestid_form();
} else {
print '<h2>T-Reqs blast e-mail message ID# ' . $fm_requestid . ' to be either reassigned to a different reviewer or to a different status.</h2>';
print '<h2>To put it back to the queue, just choose Default Reviewer and Awaiting Review otherwise choose a reviewer and Under Review to reassign.</h2>';
review_re_assign_form($dbh, 'user', 'role', 'REVIEWER', $fm_requestid);
//build the reassign <form>
}
