public function createReviewers($reviewerPostData, $review)
{
if (sizeof($reviewerPostData) > 0) {
$reviewerGroupFactory = new ReviewerGroupFactory();
$review->getReviewers()->delete();
$reviewer = new Reviewer();
$reviewer->setEmployeeNumber($review->getEmployeeNumber());
$reviewer->setReviewerGroupId($reviewerGroupFactory->getReviewer('selfReviewer')->getId());
$reviewer->setReviewId($review->getId());
$reviewer->setStatus($this->getReviewerReviewStatusFactory()->getStatus('activated')->getStatusId());
$review->getReviewers()->add($reviewer);
foreach ($reviewerPostData as $key => $reviewers) {
foreach ($reviewers as $reviewerId) {
$group = $reviewerGroupFactory->getReviewer($key)->getId();
$reviewer = new Reviewer();
$reviewer->setEmployeeNumber($reviewerId);
$reviewer->setReviewerGroupId($group);
$reviewer->setReviewId($review->getId());
$reviewer->setStatus($this->getReviewerReviewStatusFactory()->getStatus('activated')->getStatusId());
$review->getReviewers()->add($reviewer);
}
}
}
return $review;
}
$result = mysql_query($query, $GLOBALS['connection']) or die("Error in query: {$query}. " . mysql_error());
// update file status
$query = "UPDATE {$GLOBALS['CONFIG']['db_prefix']}data SET status = '0', publishable='{$lpublishable}', realname='{$filename}' WHERE id='{$id}'";
$result = mysql_query($query, $GLOBALS['connection']) or die("Error in query: {$query}. " . mysql_error());
// rename and save file
$newFileName = $id . '.dat';
copy($_FILES['file']['tmp_name'], $GLOBALS['CONFIG']['dataDir'] . $newFileName);
AccessLog::addLogEntry($id, 'I');
/**
* Send out email notifications to reviewers
*/
$file_obj = new FileData($id, $GLOBALS['connection'], DB_NAME);
$get_full_name = $user_obj->getFullName();
$full_name = $get_full_name[0] . ' ' . $get_full_name[1];
$department = $file_obj->getDepartment();
$reviewer_obj = new Reviewer($id, $GLOBALS['connection'], DB_NAME);
$reviewer_list = $reviewer_obj->getReviewersForDepartment($department);
$date = date('Y-m-d H:i:s T');
// Build email for general notices
$mail_subject = msg('checkinpage_file_was_checked_in');
$mail_body2 = msg('checkinpage_file_was_checked_in') . "\n\n";
$mail_body2 .= msg('label_filename') . ': ' . $file_obj->getName() . "\n\n";
$mail_body2 .= msg('label_status') . ': ' . msg('addpage_new') . "\n\n";
$mail_body2 .= msg('date') . ': ' . $date . "\n\n";
$mail_body2 .= msg('addpage_uploader') . ': ' . $full_name . "\n\n";
$mail_body2 .= msg('email_thank_you') . ',' . "\n\n";
$mail_body2 .= msg('email_automated_document_messenger') . "\n\n";
$mail_body2 .= $GLOBALS['CONFIG']['base_url'] . "\n\n";
$email_obj = new Email();
$email_obj->setFullName($full_name);
$email_obj->setSubject($mail_subject);
/**
* Create a new reviewer or update an existing one.
*
* @param array $credentials
* @return $this
*/
protected function addUserAsReviewer($credentials)
{
$user = ['title' => $credentials['title'], 'last_name' => $credentials['last_name'], 'first_name' => $credentials['first_name'], 'email' => $credentials['email'], 'ers_id' => $credentials['ers_id'], 'user_id' => $credentials['ers_id']];
//check is the user is alredy a reviewer in his own group (added by himself...)
$selfAsReviewer = DB::table('reviewers')->where('ers_id', $user['ers_id'])->where('user_id', $user['ers_id'])->get();
if (!$selfAsReviewer) {
Reviewer::Create($user);
}
}
