public function listAction()
{
$comments = Comments::find(['order' => 'id ASC']);
if (!count($comments)) {
$this->_status['response']['status'] = false;
$this->_status['response']['code'] = 102;
return $this->response->setJsonContent($this->_status);
}
foreach ($comments as $comment) {
$this->_status['response']['comment'][] = ['post_id' => $comment->posts->id, 'posts_title' => $comment->posts->title, 'comment_name' => $comment->name, 'comment_email' => $comment->email, 'comment' => $comment->comment, 'date' => $comment->created_at];
}
return $this->response->setJsonContent($this->_status);
}
function launch()
{
global $interface;
global $user;
global $configArray;
// Process Delete Comment
if (isset($_GET['delete']) && is_object($user)) {
$comment = new Comments();
$comment->id = $_GET['delete'];
if ($comment->find(true)) {
if ($user->id == $comment->user_id) {
$comment->delete();
}
}
}
$interface->assign('id', $_GET['id']);
if (isset($_REQUEST['comment'])) {
if (!$user) {
$interface->assign('recordId', $_GET['id']);
$interface->assign('comment', $_REQUEST['comment']);
$interface->assign('followup', true);
$interface->assign('followupModule', 'EContentRecord');
$interface->assign('followupAction', 'UserComments');
$interface->setPageTitle('You must be logged in first');
$interface->assign('subTemplate', '../MyResearch/login.tpl');
$interface->setTemplate('view-alt.tpl');
$interface->display('layout.tpl', 'UserComments' . $_GET['id']);
exit;
}
$result = $this->saveComment();
}
$interface->assign('user', $user);
$eContentRecord = new EContentRecord();
$eContentRecord->id = $_GET['id'];
$eContentRecord->find(true);
$recordDriver = new EcontentRecordDriver();
$recordDriver->setDataObject($eContentRecord);
$interface->setPageTitle(translate('Comments') . ': ' . $recordDriver->getBreadcrumb());
$this->loadEContentComments();
$interface->assign('subTemplate', 'view-comments.tpl');
$interface->setTemplate('view.tpl');
// Display Page
$interface->display('layout.tpl');
}
/**
* Delete a comment
*
* @param int $id ID of comment to delete
* @param object $user User whose comment is being deleted.
*
* @return bool True for success, false for failure.
* @access public
*/
public static function deleteComment($id, $user)
{
$comment = new Comments();
$comment->id = $id;
if ($comment->find(true)) {
if ($user->id == $comment->user_id) {
$comment->delete();
return true;
}
}
return false;
}
public function saveItem()
{
$cat_id = Input::get('cat_id');
$item_id = Input::get('id');
//获取表单
if ($cat_id == 0) {
//新闻编辑
$title = Input::get('title');
$content = Input::get('content');
$abstract = Input::get('abstract');
$item = News::find($item_id);
} else {
if ($cat_id == 1) {
//项目编辑
$title = Input::get('title');
$content = Input::get('content');
$abstract = Input::get('abstract');
$begin_time = Input::get('begin_time');
$end_time = Input::get('end_time');
$item = Researches::find($item_id);
} else {
if ($cat_id == 2) {
//通知编辑
//
$title = Input::get('title');
$content = Input::get('content');
$item = Notices::find($item_id);
} else {
if ($cat_id == 3) {
//课程编辑
$course_name = Input::get('course_name');
$course_info = Input::get('course_info');
$teacher_address = Input::get('teacher_address');
$teacher_mail = Input::get('teacher_mail');
$TA_name = Input::get('TA_name');
$TA_address = Input::get('TA_address');
$TA_mail = Input::get('TA_mail');
$item = Courses::find($item_id);
$homeworks = Courses::find($item_id)->homework;
$coursewares = Courses::find($item_id)->courseware;
$course_notices = Courses::find($item_id)->comments;
foreach ($course_notices as $notice) {
$update_notice = Comments::find($notice->id);
$update_notice->comment = Input::get('course_notice_content' . $notice->id);
$update_notice->updated_at = date("Y-m-d H:i:s");
$update_notice->save();
}
foreach ($homeworks as $homework) {
//对已有项进行编辑
$delete_or_not = Input::get('homework_delete' . $homework->id);
if ($delete_or_not) {
//如果标记为删除则将已有作业进行删除
$delete_item = Homework::find($homework->id);
$delete_item->delete();
} else {
$update_item = Homework::find($homework->id);
$update_item->homework_item = Input::get('homework_label' . $homework->id);
$update_item->submit_deadline = Input::get('homework_submit_time' . $homework->id);
$update_item->deliver_deadline = Input::get('homework_deliver_time' . $homework->id);
$update_item->updated_at = date("Y-m-d H:i:s");
$update_item->save();
}
}
foreach ($coursewares as $courseware) {
$update_item = Courseware::find($courseware->id);
$update_item->label = Input::get('courseware_label' . $courseware->id);
$update_file_source = 'courseware_ppt' . $courseware->id;
$new_source = HomeController::upload_course($item_id, $update_file_source);
if ($new_source != "") {
//跟新源的同时将旧的课件删除
HomeController::delete_file($update_item->source);
$update_item->source = $new_source;
} else {
}
$update_item->updated_at = date("Y-m-d H:i:s");
$update_item->save();
}
}
}
}
}
//保存数据
if ($item) {
//表中已经存在该条目
if ($cat_id == 0) {
//新闻编辑
$item->title = $title;
$item->content = $content;
$item->abstract = $abstract;
$item->save();
return Redirect::to(URL::to('/news-detail', [$item_id]));
} else {
if ($cat_id == 1) {
//项目编辑
$item->title = $title;
$item->content = $content;
$item->abstract = $abstract;
$item->begin_time = $begin_time;
$item->end_time = $end_time;
$item->save();
return Redirect::to(URL::to('/research-detail', [$item_id]));
} else {
if ($cat_id == 2) {
//通知编辑
$item->title = $title;
$item->content = $content;
$item->save();
return Redirect::to(URL::to('/notice-detail', [$item_id]));
} else {
if ($cat_id == 3) {
//课程编辑
$item->course_name = $course_name;
$item->course_info = $course_info;
$item->teacher_address = $teacher_address;
$item->teacher_mail = $teacher_mail;
$item->TA_name = $TA_name;
$item->TA_address = $TA_address;
$item->TA_mail = $TA_mail;
$item->save();
$course_notices_add_count = Input::get('course_notice_add_count');
if ($course_notices_add_count) {
//增加新的通知
for ($i = 1; $i <= $course_notices_add_count; $i++) {
$add_or_not = Input::get('course_notice_add_or_not' . $i);
if (!$add_or_not) {
$notice = new Comments();
$notice->course_id = $item_id;
$notice->comment = Input::get('course_notice_add_content' . $i);
$notice->created_at = date("Y-m-d H:i:s");
$notice->updated_at = date("Y-m-d H:i:s");
$notice->save();
}
}
}
$homework_add_count = Input::get('homework_add_count');
if ($homework_add_count) {
//当添加了新的作业，将其添加到homework数据库中
for ($i = 1; $i <= $homework_add_count; $i++) {
$add_or_not = Input::get('homework_add_or_not' . $i);
if (!$add_or_not) {
$homework = new Homework();
$homework->course_id = $item_id;
$homework->homework_item = Input::get('homework_add_item' . $i);
$homework->submit_deadline = Input::get('homework_add_submit_time' . $i);
$homework->deliver_deadline = Input::get('homework_add_deliver_time' . $i);
$homework->created_at = date("Y-m-d H:i:s");
$homework->updated_at = date("Y-m-d H:i:s");
$homework->save();
}
}
}
$courseware_add_count = Input::get('courseware_add_count');
if ($courseware_add_count) {
//当添加了新的课件，将其添加到courseware表中
for ($i = 1; $i <= $courseware_add_count; $i++) {
$courseware = new Courseware();
$courseware->course_id = $item_id;
$courseware->label = Input::get('courseware_add_label' . $i);
//先将课件上传到数据库中
$file_source = 'courseware_add_source' . $i;
$courseware->source = HomeController::upload_course($item_id, $file_source);
$courseware->created_at = date("Y-m-d H:i:s");
$courseware->updated_at = date("Y-m-d H:i:s");
$courseware->save();
}
}
return Redirect::to(URL::to('/course', [$item_id]));
}
}
}
}
} else {
//对已有条目进行更新
if ($cat_id == 0) {
//新闻条目
News::insert(['title' => $title, 'abstract' => $abstract, 'content' => $content]);
$item = News::all()->last();
return Redirect::to(URL::to('/news-detail', [$item->id]));
} else {
if ($cat_id == 1) {
//项目条目
Researches::insert(['title' => $title, 'abstract' => $abstract, 'content' => $content, 'begin_time' => $begin_time, 'end_time' => $end_time]);
$item = Researches::all()->last();
return Redirect::to(URL::to('/research-detail', [$item->id]));
} else {
if ($cat_id == 2) {
//通知编辑
Notices::insert(['title' => $title, 'content' => $content]);
$item = Notices::all()->last();
return Redirect::to(URL::to('/notice-detail', [$item->id]));
} else {
if ($cat_id == 3) {
Courses::insert(['course_name' => $course_name, 'course_info' => $course_info, 'teacher_address' => $teacher_address, 'TA_name' => $TA_name, 'TA_address' => $TA_address]);
$item = Courses::all()->last();
return Redirect::to(URL::to('/course', [$item->id]));
}
}
}
}
}
//return View::make('/news-detail',[$item_id]);
}
function DeleteComment()
{
require_once ROOT_DIR . '/services/MyResearch/lib/Comments.php';
global $user;
global $configArray;
// Process Delete Comment
if (is_object($user)) {
$comment = new Comments();
$comment->id = $_GET['commentId'];
$comment->source = 'eContent';
if ($comment->find(true)) {
if ($user->id == $comment->user_id) {
$comment->delete();
}
}
}
return '<result>true</result>';
}
private function _getReviewTitles($reviewTag)
{
//Load a list of reviews based on the tag
$comments = new Comments();
$comments->whereAdd("comment like \"%#" . mysql_escape_string($reviewTag) . '"');
$comments->find();
$recordIds = array();
$reviews = array();
$datesSaved = array();
while ($comments->fetch()) {
$resourceId = $comments->resource_id;
//Load the resource from the database
$resource = new Resource();
$resource->id = $comments->resource_id;
$resource->find(true);
$recordIds[$resource->record_id] = $resource->record_id;
$comment = preg_replace('/#.*/', '', $comments->comment);
$reviews[$resource->record_id] = $comment;
$datesSaved[$resource->record_id] = $comments->created;
}
$titles = $this->loadTitleInformationForIds($recordIds, $reviews, $datesSaved);
return array('success' => true, 'listName' => $reviewTag, 'listDescription' => 'Tagged reviews', 'titles' => $titles, 'cacheLength' => 24);
}
function DeleteComment()
{
require_once ROOT_DIR . '/services/MyResearch/lib/Comments.php';
global $user;
// Process Delete Comment
if (is_object($user)) {
$comment = new Comments();
$comment->id = $_GET['commentId'];
if ($comment->find(true)) {
if ($user->id == $comment->user_id || $user->hasRole('opacAdmin')) {
$comment->delete();
}
}
}
return '<result>true</result>';
}
// Retrieve values from configuration file
$configArray = readConfig();
// Setup time zone
date_default_timezone_set($configArray['Site']['timezone']);
// Setup Local Database Connection
ConnectionManager::connectToDatabase();
// Setup index connection
ConnectionManager::connectToIndex();
// Delete the expired searches -- this cleans up any junk left in the database
// from old search histories that were not caught by the session garbage collector.
$count = 0;
$fixed = 0;
$searchObject = SearchObjectFactory::initSearchObject();
$searchObject->disableLogging();
$comments = new Comments();
if ($comments->find()) {
while ($comments->fetch()) {
$commentsRecord = new Comments_record();
$commentsRecord->comment_id = $comments->id;
if ($commentsRecord->find(true)) {
$query = 'local_ids_str_mv:"' . addcslashes($commentsRecord->record_id, '"') . '"';
$searchObject->setQueryString($query);
$result = $searchObject->processSearch();
$searchObject->close();
if (PEAR::isError($result)) {
PEAR::raiseError($result->getMessage());
}
if ($result['response']['numFound'] > 0) {
$idArray = $result['response']['docs'][0]["local_ids_str_mv"];
if ($comments->verifyLinks($idArray)) {
++$fixed;
