if ($department_stmt->rowCount() != 1) { header('Location:error.php?ec=14'); exit; //non-unique error } $filedata = new FileData($data_id, $pdo); // error check if (!$filedata->exists()) { header('Location:error.php?ec=2'); exit; } else { $category = $filedata->getCategory(); $realname = $filedata->getName(); $description = $filedata->getDescription(); $comment = $filedata->getComment(); $owner_id = $filedata->getOwner(); $department = $filedata->getDepartment(); //CHM $table_name_query = "SELECT table_name FROM {$GLOBALS['CONFIG']['db_prefix']}udf WHERE field_type = '4'"; $table_name_stmt = $pdo->prepare($table_name_query); $table_name_stmt->execute(); $result = $table_name_stmt->fetchAll(); $num_rows = $table_name_stmt->rowCount(); $t_name = array(); $i = 0; foreach ($result as $data) { $explode_v = explode('_', $data['table_name']); $t_name = $explode_v[2]; $i++; } // For the User dropdown
if ($GLOBALS['CONFIG']['file_expired_action'] != 4) { $reviewer_comments = 'To=' . msg('author') . ';Subject=' . msg('message_file_expired') . ';Comments=' . msg('email_file_was_rejected_because') . ' ' . $GLOBALS['CONFIG']['revision_expiration'] . ' ' . msg('days') . ';'; $user_obj = new user($root_id, $pdo); $date = date("D F d Y"); $time = date("h:i A"); $get_full_name = $user_obj->getFullName(); $full_name = $get_full_name[0] . ' ' . $get_full_name[1]; $mail_from = $full_name . ' <' . $user_obj->getEmailAddress() . '>'; $mail_headers = "From: {$mail_from}"; $mail_subject = msg('email_subject_review_status'); $mail_greeting = msg('email_greeting') . ":\n\r\t" . msg('email_i_would_like_to_inform'); $mail_body = msg('email_was_declined_for_publishing_at') . ' ' . $time . ' on ' . $date . ' ' . msg('email_because_you_did_not_revise') . ' ' . $GLOBALS['CONFIG']['revision_expiration'] . ' ' . msg('days'); $mail_salute = "\n\r\n\r" . msg('email_salute') . ",\n\r{$full_name}"; foreach ($data_result as $row) { $file_obj = new FileData($row['id'], $pdo); $user_obj = new User($file_obj->getOwner(), $pdo); $mail_to = $user_obj->getEmailAddress(); if ($GLOBALS['CONFIG']['demo'] == 'False') { mail($mail_to, $mail_subject . $file_obj->getName(), $mail_greeting . $file_obj->getName() . ' ' . $mail_body . $mail_salute, $mail_headers); } } } //do not show file if ($GLOBALS['CONFIG']['file_expired_action'] == 1) { $reviewer_comments = 'To=' . msg('author') . ';Subject=' . msg('message_file_expired') . ';Comments=' . msg('email_file_was_rejected_because') . ' ' . $GLOBALS['CONFIG']['revision_expiration'] . ' ' . msg('days'); foreach ($data_result as $row) { $file_obj = new FileData($row['id'], $pdo); $file_obj->Publishable(-1); $file_obj->setReviewerComments($reviewer_comments); } }
$mail_subject = !empty($_REQUEST['subject']) ? stripslashes($_REQUEST['subject']) : msg('email_subject_review_status'); $mail_from = $full_name . ' <' . $user_obj->getEmailAddress() . '>'; $mail_headers = "From: {$mail_from}" . "\r\n"; $mail_headers .= "Content-Type: text/plain; charset=UTF-8" . "\r\n"; if ($user_obj->isAdmin()) { $id_array = $user_obj->getAllRevieweeIds(); } else { $id_array = $user_obj->getRevieweeIds(); } $idfield = explode(' ', trim($lcheckbox)); foreach ($idfield as $key => $value) { // Check to make sure the current file_id is in their list of reviewable ID's if (in_array($value, $id_array)) { $fileid = $value; $file_obj = new FileData($fileid, $GLOBALS['connection'], DB_NAME); $user_obj = new User($file_obj->getOwner(), $GLOBALS['connection'], DB_NAME); $mail_to = $user_obj->getEmailAddress(); $dept_id = $file_obj->getDepartment(); // Build email for author notification if (isset($_POST['send_to_users'][0]) && in_array('owner', $_POST['send_to_users'])) { // Lets unset this now so the new array will just be user_id's $_POST['send_to_users'] = array_slice($_POST['send_to_users'], 1); $mail_body1 = $lcomments . "\n\n"; $mail_body1 .= msg('email_your_file_has_been_authorized') . "\n\n"; $mail_body1 .= msg('label_filename') . ': ' . $file_obj->getName() . "\n\n"; $mail_body1 .= msg('label_status') . ': ' . msg('message_authorized') . "\n\n"; $mail_body1 .= msg('date') . ': ' . $date . "\n\n"; $mail_body1 .= msg('label_reviewer') . ': ' . $full_name . "\n\n"; $mail_body1 .= msg('email_thank_you') . ',' . "\n\n"; $mail_body1 .= msg('email_automated_document_messenger') . "\n\n"; $mail_body1 .= $GLOBALS['CONFIG']['base_url'] . "\n\n";