function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$target_c_diary_id = $requests['target_c_diary_id'];
$subject = $requests['subject'];
$body = $requests['body'];
$public_flag = util_cast_public_flag_diary($requests['public_flag']);
$tmpfile_1 = $requests['tmpfile_1'];
$tmpfile_2 = $requests['tmpfile_2'];
$tmpfile_3 = $requests['tmpfile_3'];
$category = array_unique(preg_split('/\\s+/', $requests['category']));
$is_comment_input = $requests['is_comment_input'];
// ----------
//--- 権限チェック
//日記作成者
$c_diary = db_diary_get_c_diary4id($target_c_diary_id);
if ($c_diary['c_member_id'] != $u) {
handle_kengen_error();
}
//---
$sessid = session_id();
if (count($category) > 5) {
$_REQUEST['msg'] = 'カテゴリは5つまでしか指定できません';
openpne_forward('pc', 'page', 'h_diary_edit');
exit;
}
foreach ($category as $value) {
if (mb_strwidth($value) > 20) {
$_REQUEST['msg'] = 'カテゴリはひとつにつき全角10文字（半角20文字）以内で入力してください';
openpne_forward('pc', 'page', 'h_diary_edit');
exit;
}
}
// 画像アップロード可能サイズチェック
$filesize = 0;
$del_file = array();
if ($tmpfile_1) {
$filesize += util_image_get_c_tmp_filesize4filename("d_{$target_c_diary_id}_1", $tmpfile_1);
if ($c_diary['image_filename_1']) {
$del_file[] = $c_diary['image_filename_1'];
}
}
if ($tmpfile_2) {
$filesize += util_image_get_c_tmp_filesize4filename("d_{$target_c_diary_id}_2", $tmpfile_2);
if ($c_diary['image_filename_2']) {
$del_file[] = $c_diary['image_filename_2'];
}
}
if ($tmpfile_3) {
$filesize += util_image_get_c_tmp_filesize4filename("d_{$target_c_diary_id}_3", $tmpfile_3);
if ($c_diary['image_filename_3']) {
$del_file[] = $c_diary['image_filename_3'];
}
}
if ($filesize) {
$result = util_image_check_change_image_upload($filesize, $del_file, $u, 'diary');
if ($result) {
if ($result == 2) {
$result = 3;
}
$_REQUEST['msg'] = util_image_get_upload_err_msg($result);
openpne_forward('pc', 'page', 'h_diary_edit');
exit;
}
}
//カテゴリ登録しなおし
db_diary_category_delete_c_diary_category_diary($target_c_diary_id);
$c_diary_category_list = db_diary_category_list4c_member_id($c_diary['c_member_id']);
foreach ($category as $value) {
if (empty($value)) {
break;
}
// 同一のカテゴリ名が登録済みかどうかを確認
$c_category_id = 0;
foreach ($c_diary_category_list as $c_diary_category) {
if ($c_diary_category['category_name'] == $value) {
$c_category_id = $c_diary_category['c_diary_category_id'];
break;
}
}
// 未登録の場合は新規に登録する
if (!$c_category_id) {
$c_category_id = db_diary_category_insert_category($c_diary['c_member_id'], $value);
}
db_diary_category_insert_c_diary_category_diary($target_c_diary_id, $c_category_id);
}
$filename_1 = $filename_2 = $filename_3 = '';
if ($tmpfile_1) {
db_image_data_delete($c_diary['image_filename_1'], $u);
$filename_1 = image_insert_c_image4tmp("d_{$target_c_diary_id}_1", $tmpfile_1, $u);
}
if ($tmpfile_2) {
db_image_data_delete($c_diary['image_filename_2'], $u);
$filename_2 = image_insert_c_image4tmp("d_{$target_c_diary_id}_2", $tmpfile_2, $u);
}
if ($tmpfile_3) {
db_image_data_delete($c_diary['image_filename_3'], $u);
$filename_3 = image_insert_c_image4tmp("d_{$target_c_diary_id}_3", $tmpfile_3, $u);
}
if (!OPENPNE_USE_DIARY_COMMENT) {
$is_comment_input = $c_diary['is_comment_input'];
}
t_image_clear_tmp($sessid);
db_diary_update_c_diary($target_c_diary_id, $subject, $body, $public_flag, $is_comment_input, $filename_1, $filename_2, $filename_3);
$p = array('target_c_diary_id' => $target_c_diary_id);
openpne_redirect('pc', 'page_fh_diary', $p);
}
/**
* 日記削除
* コメント、画像も削除
*
* @param int $c_diary_id
*/
function db_diary_delete_c_diary($c_diary_id)
{
//function cacheの削除
$c_diary = db_diary_get_c_diary4id($c_diary_id);
pne_cache_drop('db_diary_get_c_diary_list4c_member_id', $c_diary['c_member_id'], 5);
// 画像
db_image_data_delete($c_diary['image_filename_1'], $c_diary['c_member_id']);
db_image_data_delete($c_diary['image_filename_2'], $c_diary['c_member_id']);
db_image_data_delete($c_diary['image_filename_3'], $c_diary['c_member_id']);
// コメント
$sql = 'SELECT image_filename_1, image_filename_2, image_filename_3, c_member_id FROM c_diary_comment WHERE c_diary_id =?';
$params = array(intval($c_diary_id));
$comment_images = db_get_all($sql, $params);
//カテゴリ
db_diary_category_delete_c_diary_category_diary($c_diary_id);
foreach ($comment_images as $value) {
db_image_data_delete($value['image_filename_1'], $value['c_member_id']);
db_image_data_delete($value['image_filename_2'], $value['c_member_id']);
db_image_data_delete($value['image_filename_3'], $value['c_member_id']);
}
$sql = 'DELETE FROM c_diary_comment_log WHERE c_diary_id = ?';
db_query($sql, $params);
$sql = 'DELETE FROM c_diary_comment WHERE c_diary_id = ?';
db_query($sql, $params);
// 日記
$sql = 'DELETE FROM c_diary WHERE c_diary_id = ?';
db_query($sql, $params);
}
/**
* 日記削除
* コメント、画像も削除
*
* @param int $c_diary_id
*/
function kanshi_db_diary_delete_c_diary($c_diary_id)
{
if ($c_diary = db_diary_get_c_diary4id($c_diary_id)) {
//function cacheの削除
pne_cache_drop('db_diary_get_c_diary_list4c_member_id', $c_diary['c_member_id'], 5);
// 画像
image_data_delete($c_diary['image_filename_1']);
image_data_delete($c_diary['image_filename_2']);
image_data_delete($c_diary['image_filename_3']);
// コメント
$sql = 'SELECT image_filename_1, image_filename_2, image_filename_3 FROM c_diary_comment WHERE c_diary_id =?';
$params = array(intval($c_diary_id));
$comment_images = db_get_all($sql, $params);
//カテゴリ
db_diary_category_delete_c_diary_category_diary($c_diary_id);
foreach ($comment_images as $value) {
image_data_delete($value['image_filename_1']);
image_data_delete($value['image_filename_2']);
image_data_delete($value['image_filename_3']);
}
$sql = 'DELETE FROM c_diary_comment WHERE c_diary_id = ?';
db_query($sql, $params);
// 日記
$sql = 'DELETE FROM c_diary WHERE c_diary_id = ?';
if (db_query($sql, $params)) {
return array(1, 0, '');
} else {
return array(0, 2, 'DB更新エラー');
}
} else {
// return array(0, 99, '既に削除されているか存在しません');
// 監視ツールがリトライを行ってしまう為、成功フラグを返してしまう
return array(1, 0, '');
}
}
