public function controlerJob($maincont)
{
if ($maincont->isLoggued()) {
/*$_POST["author"]="gg42";
$_POST["body"]="move Ur body4242";
$_POST["published"]="1";
$_POST["postid"]="2";
$_POST["id"]=3;
$_SESSION["backmod"]="comment";
$_SESSION["backact"]="admin";*/
if (isset($_POST["id"])) {
$p = new Comment($_POST["id"]);
$p->setAuthor($_POST["author"]);
$p->setBody($_POST["body"]);
//$p->setHour(date("h:i:s"));
//$p->setDate(date("Y-m-d"));
$p->setPublished($_POST["published"]);
$p->setPostid($_POST["postid"]);
}
$maincont->goModule("comment", "admin");
//$maincont->goModule($_SESSION["backmod"],$_SESSION["backact"]);
} else {
$maincont->goModule("admin", "loginform");
}
}
public function controlerJob($maincont)
{
if (isset($_POST["author"])) {
//print_r($_POST);
$p = new Comment();
$p->setAuthor($_POST["author"]);
$p->setBody($_POST["body"]);
$p->setHour(date("h:i:s"));
$p->setDate(date("Y-m-d"));
$p->setPublished("0");
$p->setPostid($_POST["postid"]);
}
$maincont->goModule("home", "display");
}
public function findCommentById($id)
{
$stmt = $this->dtb->prepare('SELECT * FROM comments WHERE postID = :pid');
$stmt->bindValue(':pid', $pid, PDO::PARAM_INT);
$stmt->execute();
$data = array();
$um = new PdoUserManager();
$pm = new PdoPostManager();
$d = $stmt->fetch(PDO::FETCH_OBJ);
$c = new Comment();
$c->setId($d->id);
$c->setBody($d->body);
//$c->setPost($pm->findPostById($d->postID));
$c->setUser($um->findUserById($d->userID));
$c->setPublicationDate($d->publicationDate);
$data[] = $c;
$stmt->closeCursor();
return $data;
}
/**
* Save changes to comment.
* @return int the comment ID
*/
function execute()
{
$journal =& Request::getJournal();
$enableComments = $journal->getSetting('enableComments');
$commentDao =& DAORegistry::getDAO('CommentDAO');
$comment = $this->comment;
if (!isset($comment)) {
$comment = new Comment();
}
$user =& Request::getUser();
$comment->setTitle($this->getData('title'));
$comment->setBody($this->getData('body'));
if (($enableComments == COMMENTS_ANONYMOUS || $enableComments == COMMENTS_UNAUTHENTICATED) && (Request::getUserVar('anonymous') || $user == null)) {
$comment->setPosterName($this->getData('posterName'));
$comment->setPosterEmail($this->getData('posterEmail'));
$comment->setUser(null);
} else {
$comment->setPosterName($user->getFullName());
$comment->setPosterEmail($user->getEmail());
$comment->setUser($user);
}
$comment->setParentCommentId($this->parentId);
if (isset($this->comment)) {
$commentDao->updateComment($comment);
} else {
$comment->setSubmissionId($this->articleId);
$comment->setChildCommentCount(0);
$commentDao->insertComment($comment);
$this->commentId = $comment->getId();
}
return $this->commentId;
}
/**
* Creates and returns a submission comment object from a row
* @param $row array
* @return Comment object
*/
function &_returnCommentFromRow($row, $childLevels = 0)
{
$userDao =& DAORegistry::getDAO('UserDAO');
$comment = new Comment();
$comment->setId($row['comment_id']);
$comment->setSubmissionId($row['submission_id']);
$comment->setUser($userDao->getUser($row['user_id']), true);
$comment->setPosterIP($row['poster_ip']);
$comment->setPosterName($row['poster_name']);
$comment->setPosterEmail($row['poster_email']);
$comment->setTitle($row['title']);
$comment->setBody($row['body']);
$comment->setDatePosted($this->datetimeFromDB($row['date_posted']));
$comment->setDateModified($this->datetimeFromDB($row['date_modified']));
$comment->setParentCommentId($row['parent_comment_id']);
$comment->setChildCommentCount($row['num_children']);
if (!HookRegistry::call('CommentDAO::_returnCommentFromRow', array(&$comment, &$row, &$childLevels))) {
if ($childLevels > 0) {
$comment->setChildren($this->getCommentsByParentId($row['comment_id'], $childLevels - 1));
} else {
if ($childLevels == SUBMISSION_COMMENT_RECURSE_ALL) {
$comment->setChildren($this->getCommentsByParentId($row['comment_id'], SUBMISSION_COMMENT_RECURSE_ALL));
}
}
}
return $comment;
}
protected function handleComment(&$username, &$password, &$articleId, &$title, &$body)
{
$userDAO = DAORegistry::getDAO('UserDAO');
$user = $userDAO->getUserByCredentials($username, $password);
if ($user == null) {
return 'ERROR_CREDENTIALS';
}
if ($title == null || $title == '' || $body == null || $body == '' || $articleId == null || $articleId == '') {
return 'ERROR_PARAMS';
}
if (DAORegistry::getDAO('PublishedArticleDAO')->getPublishedArticleByArticleId($articleId) == null) {
return 'ERROR_NO_ARTICLE';
}
$commentDao =& DAORegistry::getDAO('CommentDAO');
$comment = new Comment();
$comment->setSubmissionId($articleId);
$comment->setBody($body);
$comment->setTitle($title);
$comment->setUser($user);
$comment->setChildCommentCount(0);
$comment->setPosterName($user->getFullName());
$comment->setPosterEmail($user->getEmail());
$result = $commentDao->insertComment($comment);
echo (int) $result;
}
/**
* Save changes to comment.
* @return int the comment ID
*/
function execute()
{
$conference =& Request::getConference();
$schedConf =& Request::getSchedConf();
$enableComments = $conference->getSetting('enableComments');
$commentsRequireRegistration = $conference->getSetting('commentsRequireRegistration');
$commentsAllowAnonymous = $conference->getSetting('commentsAllowAnonymous');
$commentDao =& DAORegistry::getDAO('CommentDAO');
$comment = $this->comment;
if (!isset($comment)) {
$comment = new Comment();
}
$user =& Request::getUser();
$comment->setTitle($this->getData('title'));
$comment->setBody($this->getData('body'));
if (($commentsAllowAnonymous || !$commentsRequireRegistration) && (Request::getUserVar('anonymous') || $user == null)) {
$comment->setPosterName($this->getData('posterName'));
$comment->setPosterEmail($this->getData('posterEmail'));
$comment->setUser(null);
} else {
$comment->setPosterName($user->getFullName());
$comment->setPosterEmail($user->getEmail());
$comment->setUser($user);
}
$comment->setParentCommentId($this->parentId);
if (isset($this->comment)) {
$commentDao->updateComment($comment);
} else {
$comment->setPaperId($this->paperId);
$comment->setChildCommentCount(0);
$commentDao->insertComment($comment);
$this->commentId = $comment->getId();
}
return $this->commentId;
}
function importPendingEmailAsComment(&$incoming_mail, &$project, &$user, &$mailbox, $page_id = '')
{
$parent = ProjectObjects::findById(!empty($page_id) ? $page_id : $incoming_mail->getParentId());
//EOF:mod 20120820
if (!instance_of($parent, 'ProjectObject')) {
// parent object does not exists
$incoming_mail->setState(INCOMING_MAIL_STATUS_PARENT_NOT_EXISTS);
$incoming_mail_save = $incoming_mail->save();
return new Error(incoming_mail_module_get_status_description(INCOMING_MAIL_STATUS_PARENT_NOT_EXISTS));
}
// if
if (!$mailbox->getAcceptAllRegistered() && instance_of($user, 'User') && !$parent->canComment($user)) {
// user cannot create comments to parent object
$incoming_mail->setState(INCOMING_MAIL_STATUS_USER_CANNOT_CREATE_COMMENT);
$incoming_mail_save = $incoming_mail->save();
return new Error(incoming_mail_module_get_status_description(INCOMING_MAIL_STATUS_USER_CANNOT_CREATE_COMMENT));
} else {
if (!$parent->can_have_comments || $parent->getIsLocked() || $parent->getState() < STATE_VISIBLE) {
// parent object can't have comments
$incoming_mail->setState(INCOMING_MAIL_STATUS_USER_CANNOT_CREATE_COMMENT);
$incoming_mail_save = $incoming_mail->save();
return new Error(incoming_mail_module_get_status_description(INCOMING_MAIL_STATUS_USER_CANNOT_CREATE_COMMENT));
}
// if
}
// if
$comment = new Comment();
$comment->log_activities = false;
$comment->setCreatedBy($user);
$comment->setCreatedOn($incoming_mail->getCreatedOn());
$comment->setProjectId($parent->getProjectId());
$comment->setState(STATE_VISIBLE);
$comment->setSource(OBJECT_SOURCE_EMAIL);
$comment->setVisibility($parent->getVisibility());
$comment->setParent($parent);
$body_content = '';
if (stripos($incoming_mail->getBody(), '-- REPLY ABOVE THIS LINE --') !== false) {
$body_content = substr($incoming_mail->getBody(), 0, strpos($incoming_mail->getBody(), '-- REPLY ABOVE THIS LINE --'));
} else {
$body_content = $incoming_mail->getBody();
}
$comment->setBody($body_content);
IncomingMailImporter::attachFilesToProjectObject($incoming_mail, $comment);
//$save = $comment->save();
$save = $comment->save(true);
if ($save && !is_error($save)) {
$activity = new NewCommentActivityLog();
$activity->log($comment, $user);
if (instance_of($user, 'User')) {
$parent->subscribe($user);
}
// if
$comment->ready();
//BOF:mod 20111110 #493
preg_match("/\\[CID(.*?)\\](.*)/is", $incoming_mail->getSubject(), $results);
if (count($results) > 0) {
$project = new Project($parent->getProjectId());
$variables = array('owner_company_name' => get_owner_company(), 'project_name' => $project->getName(), 'project_url' => $project->getOverviewUrl(), 'object_type' => $comment->getVerboseType(), 'object_name' => $comment->getName(), 'object_body' => $comment->getFormattedBody(), 'object_url' => $comment->getViewUrl(), 'comment_body' => $comment->getFormattedBody(), 'comment_url' => $comment->getViewUrl(), 'created_by_url' => $user->getViewUrl(), 'created_by_name' => $user->getDisplayName(), 'details_body' => '', 'comment_id' => $comment->getId());
$emailed_comment_id = $results[1];
$emailed_comment = new Comment($emailed_comment_id);
$emailed_comment_creator_id = $emailed_comment->getCreatedById();
$email_to = array();
$temp_user_id = $user->getId();
$temp_comment_id = $comment->getId();
$rows = db_execute_all("select user_id from " . TABLE_PREFIX . "assignments_action_request where comment_id='" . $emailed_comment_id . "' and marked_for_email='1'");
foreach ($rows as $row) {
if ($row['user_id'] != $temp_user_id) {
$email_to[] = new User($row['user_id']);
db_execute("insert into " . TABLE_PREFIX . "assignments_action_request (user_id, marked_for_email, selected_by_user_id, comment_id, date_added) values ('" . $row['user_id'] . "', '1', '" . $temp_user_id . "', '" . $temp_comment_id . "', now())");
}
}
$row = db_execute_one("select a.selected_by_user_id from " . TABLE_PREFIX . "assignments_action_request a where a.comment_id='" . $emailed_comment_id . "' and a.marked_for_email='1' and a.selected_by_user_id not in (select b.user_id from " . TABLE_PREFIX . "assignments_action_request b where b.comment_id='" . $emailed_comment_id . "' and b.marked_for_email='1') limit 0, 1");
if (!empty($row['selected_by_user_id'])) {
if ($row['selected_by_user_id'] != $temp_user_id) {
$email_to[] = new User($row['selected_by_user_id']);
db_execute("insert into " . TABLE_PREFIX . "assignments_action_request (user_id, marked_for_email, selected_by_user_id, comment_id, date_added) values ('" . $row['selected_by_user_id'] . "', '1', '" . $temp_user_id . "', '" . $temp_comment_id . "', now())");
}
}
//ApplicationMailer::send(array(new User($emailed_comment_creator_id)), 'resources/new_comment', $variables, $parent);
$attachments = null;
$object_attachments = $comment->getAttachments();
if ($object_attachments) {
$attachments = array();
foreach ($object_attachments as $object_attachment) {
$attachments[] = array('path' => $object_attachment->getFilePath(), 'name' => $object_attachment->getName(), 'mime_type' => $object_attachment->getMimeType());
}
}
ApplicationMailer::send($email_to, 'resources/new_comment', $variables, $parent, $attachments);
}
//EOF:mod 20111110 #493
if (!empty($page_id)) {
//$link = mysql_connect(DB_HOST, DB_USER, DB_PASS);
//mysql_select_db(DB_NAME, $link);
//mysql_query("insert into testing (date_added, content) values (now(), 'Page_id: " . $page_id . "')");
//mysql_close($link);
$task =& IncomingMailImporter::importPendingEmailToTaskList($incoming_mail, $project, $user, $page_id, $comment);
return $task;
} else {
return $comment;
}
}
// if
return $save;
}
