function execute($requests)
{
$v = array();
$target_c_diary_ids = $requests['target_c_diary_ids'];
// 日記が選択されていない場合はエラー
if (!$target_c_diary_ids) {
admin_client_redirect('diary_list', WORD_DIARY . "が選択されていません");
}
$ids_ary = split(":", $target_c_diary_ids);
$v = array();
$diary_list = array();
foreach ($ids_ary as $id) {
$diary = db_diary_get_c_diary4id($id);
if (!$diary) {
admin_client_redirect('diary_list', '指定された' . WORD_DIARY . "は存在しません");
}
$diary['count_comments'] = db_diary_count_c_diary_comment4c_diary_id($id);
$member = db_member_c_member4c_member_id($diary['c_member_id']);
$diary['c_member'] = $member;
array_push($diary_list, $diary);
}
$this->set('diary_list', $diary_list);
$this->set('target_c_diary_ids', $target_c_diary_ids);
$v['SNS_NAME'] = SNS_NAME;
$v['OPENPNE_VERSION'] = OPENPNE_VERSION;
$this->set($v);
return 'success';
}
function execute($requests)
{
$v = array();
$target_c_diary_id = $requests['target_c_diary_id'];
$v = array();
$diary = db_diary_get_c_diary4id($target_c_diary_id);
if (!$diary) {
admin_client_redirect('diary_list', '指定された' . WORD_DIARY . 'は存在しません');
}
$diary['count_comments'] = db_diary_count_c_diary_comment4c_diary_id($target_c_diary_id);
$member = db_member_c_member4c_member_id($diary['c_member_id']);
$diary['c_member'] = $member;
$this->set('diary', $diary);
$v['SNS_NAME'] = SNS_NAME;
$v['OPENPNE_VERSION'] = OPENPNE_VERSION;
$this->set($v);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_diary_id = $requests['target_c_diary_id'];
$tmpfile_1 = $requests['tmpfile_1'];
$tmpfile_2 = $requests['tmpfile_2'];
$tmpfile_3 = $requests['tmpfile_3'];
$body = $requests['body'];
// ----------
if (is_null($body) || $body === '') {
$p = array('target_c_diary_id' => $target_c_diary_id, 'msg' => "コメントを入力してださい");
openpne_redirect('pc', 'page_fh_diary', $p);
}
//--- 権限チェック
$c_diary = db_diary_get_c_diary4id($target_c_diary_id);
$target_c_member_id = $c_diary['c_member_id'];
$target_c_member = db_member_c_member4c_member_id($target_c_member_id);
if ($u != $target_c_member_id) {
// check public_flag
if (!pne_check_diary_public_flag($target_c_diary_id, $u)) {
openpne_redirect('pc', 'page_h_err_diary_access');
}
//アクセスブロック設定
if (db_member_is_access_block($u, $target_c_member_id)) {
openpne_redirect('pc', 'page_h_access_block');
}
}
//日記コメント停止設定
if (OPENPNE_USE_DIARY_COMMENT && !$c_diary['is_comment_input']) {
openpne_forward('pc', 'page', 'fh_diary');
exit;
}
if (!db_diary_is_writable_comment4c_diary_id($target_c_diary_id)) {
$_REQUEST['msg'] = 'コメントが1000番に達したので、この' . WORD_DIARY . 'にはコメントできません';
openpne_forward('pc', 'page', 'fh_diary');
exit;
}
//---
//---画像アップロードサイズチェック
$filesize = 0;
if ($tmpfile_1) {
$filesize += util_image_get_c_tmp_filesize4filename("dc_{$c_diary_comment_id}_1", $tmpfile_1);
}
if ($tmpfile_2) {
$filesize += util_image_get_c_tmp_filesize4filename("dc_{$c_diary_comment_id}_2", $tmpfile_2);
}
if ($tmpfile_3) {
$filesize += util_image_get_c_tmp_filesize4filename("dc_{$c_diary_comment_id}_3", $tmpfile_3);
}
if ($filesize) {
$result = util_image_check_add_image_upload($filesize, $u, 'diary');
if ($result) {
if ($result == 2) {
$result = 3;
}
$_REQUEST['msg'] = util_image_get_upload_err_msg($result);
openpne_forward('pc', 'page', 'fh_diary');
exit;
}
}
//日記コメント書き込み
$c_diary_comment_id = db_diary_insert_c_diary_comment($u, $target_c_diary_id, $body);
$sessid = session_id();
$filename_1 = image_insert_c_image4tmp("dc_{$c_diary_comment_id}_1", $tmpfile_1, $u);
$filename_2 = image_insert_c_image4tmp("dc_{$c_diary_comment_id}_2", $tmpfile_2, $u);
$filename_3 = image_insert_c_image4tmp("dc_{$c_diary_comment_id}_3", $tmpfile_3, $u);
t_image_clear_tmp($sessid);
db_diary_insert_c_diary_comment_images($c_diary_comment_id, $filename_1, $filename_2, $filename_3);
//日記コメント記入履歴更新
if ($u != $target_c_member_id) {
db_diary_insert_c_diary_comment_log($u, $target_c_diary_id);
}
db_diary_update_c_diary_comment_log($target_c_diary_id);
//日記コメントが書き込まれたので日記自体を未読扱いにする
db_diary_update_c_diary_is_checked($target_c_diary_id, 0);
// お知らせメール送信(携帯へ)
if ($u != $target_c_member_id) {
send_diary_comment_info_mail($c_diary_comment_id, $u);
}
if (OPENPNE_USE_POINT_RANK) {
// コメント者と被コメント者が違う場合にポイント加算
if ($u != $target_c_member_id) {
//書いた人にポイント付与
$point = db_action_get_point4c_action_id(3);
db_point_add_point($u, $point);
//書かれた人にポイント付与
$point = db_action_get_point4c_action_id(2);
db_point_add_point($target_c_member_id, $point);
}
}
$p = array('target_c_diary_id' => $target_c_diary_id, 'comment_count' => db_diary_count_c_diary_comment4c_diary_id($target_c_diary_id));
openpne_redirect('pc', 'page_fh_diary', $p);
}
/**
* SNS全体の最新日記リスト取得
* 日記公開範囲を考慮
*
* @param int $limit
* @return array_of_array (c_diary.*, nickname)
*/
function p_h_home_c_diary_all_list($limit)
{
$sql = 'SELECT * FROM c_diary WHERE public_flag = \'public\'' . ' ORDER BY c_diary.r_datetime DESC';
$c_diary_list_all = db_get_all_limit($sql, 0, $limit);
foreach ($c_diary_list_all as $key => $value) {
$c_member = db_member_c_member4c_member_id_LIGHT($value['c_member_id']);
$c_diary_list_all[$key]['nickname'] = $c_member['nickname'];
$c_diary_list_all[$key]['count_comments'] = db_diary_count_c_diary_comment4c_diary_id($value['c_diary_id']);
}
return $c_diary_list_all;
}
/**
* お気に入りメンバーの日記リスト（ページャ付き）
*/
function db_bookmark_diary_list_with_pager($c_member_id, $page_size, $page)
{
$bookmarks = db_bookmark_c_member_id_list($c_member_id, true);
if (!$bookmarks) {
return array(array(), false, false, 0);
}
$ids = implode(',', array_map('intval', $bookmarks));
$sql = 'SELECT c_diary.* FROM c_diary, c_member WHERE c_diary.c_member_id IN (' . $ids . ') AND c_diary.public_flag = \'public\' AND c_diary.c_member_id=c_member.c_member_id ORDER BY r_datetime DESC';
$diary_list = db_get_all_page($sql, intval($page), intval($page_size));
foreach ($diary_list as $key => $value) {
$diary_list[$key]['c_member'] = db_member_c_member4c_member_id_LIGHT($value['c_member_id']);
$diary_list[$key]['count_comments'] = db_diary_count_c_diary_comment4c_diary_id($value['c_diary_id']);
}
$sql = 'SELECT count(*) FROM c_diary WHERE c_member_id IN (' . $ids . ')';
$total_num = db_get_one($sql);
if ($total_num != 0) {
$total_page_num = ceil($total_num / $page_size);
if ($page >= $total_page_num) {
$next = false;
} else {
$next = true;
}
if ($page <= 1) {
$prev = false;
} else {
$prev = true;
}
}
return array($diary_list, $prev, $next, $total_num);
}
function monitor_diary_comment_list4c_diary_id($c_diary_id, $page_size, $page)
{
$page = intval($page);
$page_size = intval($page_size);
$where = " WHERE c_diary_comment.c_diary_id = ? ";
$params[] = intval($c_diary_id);
$select = "SELECT c_diary_comment.*, c_diary.subject";
$from = " FROM c_diary_comment" . " LEFT JOIN c_diary ON c_diary.c_diary_id = c_diary_comment.c_diary_id ";
$order = " ORDER BY r_datetime desc";
$sql = $select . $from . $where . $order;
$list = db_get_all_limit($sql, ($page - 1) * $page_size, $page_size, $params);
foreach ($list as $key => $value) {
$list[$key]['c_member'] = db_member_c_member_with_profile($value['c_member_id']);
$list[$key]['count_comments'] = db_diary_count_c_diary_comment4c_diary_id($value['c_diary_id']);
}
$sql = "SELECT COUNT(*) " . $from . $where;
$total_num = db_get_one($sql, $params);
$total_page_num = ceil($total_num / $page_size);
$next = $page < $total_page_num;
$prev = $page > 1;
return array($list, $prev, $next, $total_num, $total_page_num);
}
