public function before_delete(\Orm\Model $obj)
{
$member_ids = \Notice\Model_NoticeStatus::get_col_array('member_id', array('where' => array('notice_id' => $obj->id)));
foreach ($member_ids as $member_id) {
\Notice\Site_Util::delete_unread_count_cache($member_id);
}
}
public static function delete_timeline4id($timeline_id)
{
$delete_target_notice_cache_member_ids = array();
$writable_connection = \MyOrm\Model::connection(true);
\DBUtil::set_connection($writable_connection);
\DB::start_transaction();
if (is_enabled('notice')) {
\Notice\Site_NoOrmModel::delete_member_watch_content_multiple4foreign_data('timeline', $timeline_id);
$notice_ids = \Notice\Site_NoOrmModel::get_notice_ids4foreign_data('timeline', $timeline_id);
$delete_target_notice_cache_member_ids = \Notice\Site_NoOrmModel::get_notice_status_member_ids4notice_ids($notice_ids);
\Notice\Site_NoOrmModel::delete_notice_multiple4ids($notice_ids);
}
if (!\DB::delete('timeline')->where('id', $timeline_id)->execute()) {
throw new \FuelException('Failed to delete timeline. id:' . $timeline_id);
}
\DB::commit_transaction();
\DBUtil::set_connection(null);
// delete caches
if ($delete_target_notice_cache_member_ids) {
foreach ($delete_target_notice_cache_member_ids as $member_id) {
\Notice\Site_Util::delete_unread_count_cache($member_id);
}
}
Site_Util::delete_cache($timeline_id);
}
public static function update_notice_status2unread($member_id_to, $notice_id)
{
$is_changed_status = \Notice\Model_NoticeStatus::change_status2unread($member_id_to, $notice_id);
if (\Config::get('notice.cache.unreadCount.isEnabled') && $is_changed_status) {
\Notice\Site_Util::delete_unread_count_cache($member_id_to);
}
return $is_changed_status;
}
public static function _init()
{
if (is_enabled('notice')) {
static::$_observers['MyOrm\\Observer_InsertNotice'] = array('events' => array('after_insert'), 'update_properties' => array('foreign_table' => array('thread_comment' => 'value'), 'foreign_id' => array('thread_comment_id' => 'property'), 'type_key' => array('like' => 'value'), 'member_id_from' => array('member_id' => 'property'), 'member_id_to' => array('related' => array('thread_comment' => 'member_id'))));
$type = \Notice\Site_Util::get_notice_type('like');
static::$_observers['MyOrm\\Observer_DeleteNotice'] = array('events' => array('before_delete'), 'conditions' => array('foreign_table' => array('thread_comment' => 'value'), 'foreign_id' => array('thread_comment_id' => 'property'), 'type' => array($type => 'value')));
}
}
public static function _init()
{
if (\Module::loaded('timeline')) {
static::$_observers['MyOrm\\Observer_InsertMemberFollowTimeline'] = array('events' => array('after_insert'), 'timeline_relations' => array('foreign_table' => array('album_image' => 'value'), 'foreign_id' => array('album_image_id' => 'property')), 'property_from_member_id' => 'member_id');
}
if (is_enabled('notice')) {
static::$_observers['MyOrm\\Observer_InsertNotice'] = array('events' => array('after_insert'), 'update_properties' => array('foreign_table' => array('album_image' => 'value'), 'foreign_id' => array('album_image_id' => 'property'), 'type_key' => array('like' => 'value'), 'member_id_from' => array('member_id' => 'property'), 'member_id_to' => array('related' => array('album_image' => array('album' => 'member_id')))));
$type = \Notice\Site_Util::get_notice_type('like');
static::$_observers['MyOrm\\Observer_DeleteNotice'] = array('events' => array('before_delete'), 'conditions' => array('foreign_table' => array('album_image' => 'value'), 'foreign_id' => array('album_image_id' => 'property'), 'type' => array($type => 'value')));
}
}
private function execute(\Orm\Model $obj)
{
// 親記事削除時
if (empty($this->_conditions['type'])) {
// delete member_watch_content
self::delete_member_watch_content($obj, $this->_conditions);
}
$notices = \Site_Model::get4relation('\\Notice\\Model_Notice', $this->_conditions, $obj);
foreach ($notices as $notice) {
// 親記事削除時
if (empty($this->_conditions['type'])) {
$notice->delete();
} else {
// delete notice_member_from
if (self::delete_notice_member_from($notice->id, $obj->member_id)) {
$parent_content_member_id = \Site_Model::get_value4table_and_id($notice->foreign_table, $notice->foreign_id, 'member_id');
if (!\Notice\Model_NoticeMemberFrom::get_count4notice_id($notice->id, $parent_content_member_id)) {
$notice->delete();
}
}
}
}
// 親記事削除時
if (empty($this->_conditions['type'])) {
$foreign_table = \Util_Array::get_first_key($this->_conditions['foreign_table']);
$foreign_id = $obj->id;
$notices = \Notice\Model_Notice::get4parent_data($foreign_table, $foreign_id);
foreach ($notices as $notice) {
$notice->delete();
}
} else {
$type = \Util_Array::get_first_key($this->_conditions['type']);
// comment 削除時
if ($type == \Notice\Site_Util::get_notice_type('comment')) {
$foreign_table = \Util_Array::get_first_key($this->_conditions['foreign_table']) . '_comment';
$foreign_id = $obj->id;
$notices = \Notice\Model_Notice::get4foreign_data($foreign_table, $foreign_id);
foreach ($notices as $notice) {
$notice->delete();
}
}
}
}
private function execute($obj)
{
list($foreign_table, $foreign_id, $member_id_to, $member_id_from, $type_key) = self::get_variables($obj);
if (self::check_already_executed($foreign_table, $foreign_id, $member_id_to, $member_id_from, $type_key)) {
return;
}
if (!\Model_Member::check_is_active($member_id_to)) {
$member_id_to = null;
}
// watch content
if ($member_id_to && $member_id_from != $member_id_to) {
\Notice\Site_Util::regiser_watch_content($member_id_from, $foreign_table, $foreign_id, $type_key);
}
// get mention targets
$mentioned_member_ids = array();
if (conf('mention.isEnabled', 'notice') && \Notice\Site_Util::check_mention_target($foreign_table, $type_key)) {
$body_porp = !empty($this->_update_properties['body_prop_name']) ? $this->_update_properties['body_prop_name'] : 'body';
$mentioned_member_ids = \Notice\Site_Model::get_mentioned_member_ids4body($obj->{$body_porp});
$mentioned_member_ids = \Util_Array::delete_in_array($mentioned_member_ids, array($member_id_from));
// 自分宛の mention は無効
}
// get notice targets
$notice_member_ids = \Notice\Site_Util::get_notice_target_member_ids($member_id_to, $member_id_from, $foreign_table, $foreign_id, $type_key);
// 重複通知防止
$notice_member_ids = \Util_Array::delete_in_array($notice_member_ids, $mentioned_member_ids);
if (!$notice_member_ids && !$mentioned_member_ids) {
return;
}
// notice 実行
if ($notice_member_ids) {
\Notice\Site_Model::execut_notice($foreign_table, $foreign_id, $type_key, $member_id_from, $notice_member_ids);
}
// mention 実行
if ($mentioned_member_ids) {
$mention_type_key = $type_key == 'comment' ? 'comment_mention' : 'parent_mention';
\Notice\Site_Model::execut_notice($foreign_table, $foreign_id, $mention_type_key, $member_id_from, $mentioned_member_ids);
}
}
protected function change_notice_status2read($member_id, $foreign_table, $foreign_id, $type_key = null)
{
if ($read_count = \Notice\Site_Util::change_status2read($member_id, $foreign_table, $foreign_id, $type_key)) {
$this->set_notification_count();
}
}
public function test_delete_notice()
{
// 事前準備
$config_type_key = 'like';
\Model_MemberConfig::set_value(1, \Notice\Form_MemberConfig::get_name('comment'), 0);
\Model_MemberConfig::set_value(2, \Notice\Form_MemberConfig::get_name($config_type_key), 1);
\Model_MemberConfig::set_value(2, \Notice\Site_Util::get_member_config_name_for_watch_content('comment'), 0);
self::$member_id = 1;
$note = self::set_note();
$note_comment = self::save_comment(self::$note_id, 2);
self::$note_comment_id = $note_comment->id;
$note_id = self::$note_id;
$foreign_id = self::$note_comment_id;
$notice_count_all_before = \Notice\Model_Notice::get_count();
$notice_status_count_all_before = \Notice\Model_NoticeStatus::get_count();
$notice_member_from_count_all_before = \Notice\Model_NoticeMemberFrom::get_count();
// イイね実行
$is_liked = (bool) Model_NoteCommentLike::change_registered_status4unique_key(array('note_comment_id' => self::$note_comment_id, 'member_id' => 4));
$notice = \Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $foreign_id, \Notice\Site_Util::get_notice_type(self::$type_key));
$this->assertNotNull($notice);
// 件数確認
$this->assertEquals($notice_count_all_before + 1, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before + 1, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before + 1, \Notice\Model_NoticeMemberFrom::get_count());
// 関連テーブルのレコードが作成されていることを確認
$this->assertNotNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(2, $notice->id));
$this->assertNotNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice->id, 4));
$this->assertNotNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $foreign_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
// イイねを取り消し
$is_liked = (bool) Model_NoteCommentLike::change_registered_status4unique_key(array('note_comment_id' => self::$note_comment_id, 'member_id' => 4));
// 件数確認
$this->assertEquals($notice_count_all_before, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before, \Notice\Model_NoticeMemberFrom::get_count());
// 関連テーブルのレコードが削除されていることを確認
$this->assertNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(2, $notice->id));
$this->assertNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice->id, 4));
$this->assertNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $foreign_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
// イイね実行
$is_liked = (bool) Model_NoteCommentLike::change_registered_status4unique_key(array('note_comment_id' => self::$note_comment_id, 'member_id' => 4));
$notice = \Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $foreign_id, \Notice\Site_Util::get_notice_type(self::$type_key));
$this->assertNotNull($notice);
// note_comment 削除
$note_comment->delete();
// 件数確認
$this->assertEquals($notice_count_all_before, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before, \Notice\Model_NoticeMemberFrom::get_count());
// 再度 comment 投稿
$note_comment = self::save_comment(self::$note_id, 2);
self::$note_comment_id = $note_comment->id;
// イイね実行
$is_liked = (bool) Model_NoteCommentLike::change_registered_status4unique_key(array('note_comment_id' => self::$note_comment_id, 'member_id' => 4));
// 件数確認
$this->assertEquals($notice_count_all_before + 1, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before + 1, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before + 1, \Notice\Model_NoticeMemberFrom::get_count());
// note 削除
$note->delete_with_relations();
// 件数確認
$this->assertEquals($notice_count_all_before, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before, \Notice\Model_NoticeMemberFrom::get_count());
// 関連テーブルのレコードが削除されていることを確認
$this->assertNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(2, $notice->id));
$this->assertNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice->id, 4));
$this->assertNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $foreign_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
}
/**
* Update status already read all
*
* @access public
* @return Response (json)
* @throws Exception in Controller_Base::controller_common_api
* @see Controller_Base::controller_common_api
*/
public function post_read_all()
{
$this->controller_common_api(function () {
if (!is_enabled('notice')) {
throw new \HttpNotFoundException();
}
\DB::start_transaction();
$updated_count = \Notice\Site_Util::change_all_status2read4member_id($this->u->id);
\DB::commit_transaction();
$data = array('result' => (bool) $updated_count, 'updated_count' => $updated_count);
$this->set_response_body_api($data);
});
}
public function test_delete_notice()
{
// 事前準備
\Model_MemberConfig::set_value(2, \Notice\Form_MemberConfig::get_name(self::$type_key), 1);
\Model_MemberConfig::set_value(2, \Notice\Site_Util::get_member_config_name_for_watch_content(self::$type_key), 1);
\Model_MemberConfig::set_value(3, \Notice\Form_MemberConfig::get_name(self::$type_key), 1);
\Model_MemberConfig::set_value(3, \Notice\Site_Util::get_member_config_name_for_watch_content(self::$type_key), 1);
self::$member_id = 1;
self::set_note();
$note_id = self::$note_id;
$foreign_id = self::$note_id;
$notice_count_all_before = \Notice\Model_Notice::get_count();
$notice_status_count_all_before = \Notice\Model_NoticeStatus::get_count();
$notice_member_from_count_all_before = \Notice\Model_NoticeMemberFrom::get_count();
$member_watch_content_count_all_before = \Notice\Model_MemberWatchContent::get_count();
// 他人がイイね
$like_id = Model_NoteLike::change_registered_status4unique_key(array('note_id' => $note_id, 'member_id' => 2));
$notice = \Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $note_id, \Notice\Site_Util::get_notice_type(self::$type_key));
$this->assertNotNull($notice);
// 件数確認
$this->assertEquals($notice_count_all_before + 1, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before + 1, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before + 1, \Notice\Model_NoticeMemberFrom::get_count());
$this->assertEquals($member_watch_content_count_all_before + 1, \Notice\Model_MemberWatchContent::get_count());
// 関連テーブルのレコードが作成されていることを確認
$this->assertNotNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(self::$member_id, $notice->id));
$this->assertNotNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice->id, 2));
$this->assertNotNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $note_id, 2));
$this->assertNotNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $note_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
// イイねを取り消し
$like_id = Model_NoteLike::change_registered_status4unique_key(array('note_id' => $note_id, 'member_id' => 2));
// 件数確認
$this->assertEquals($notice_count_all_before, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before, \Notice\Model_NoticeMemberFrom::get_count());
$this->assertEquals($member_watch_content_count_all_before + 1, \Notice\Model_MemberWatchContent::get_count());
// watch は解除されない
// 関連テーブルのレコードが削除されていることを確認
$this->assertNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(self::$member_id, $notice->id));
$this->assertNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice->id, 2));
$this->assertNotNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $note_id, 2));
// watch は解除されない
$this->assertNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $note_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
// 他人のイイね＋自分がコメント
$note_like_id = Model_NoteLike::change_registered_status4unique_key(array('note_id' => $note_id, 'member_id' => 2));
self::save_comment(1, 'Test comment1.');
$notice_like = \Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $note_id, \Notice\Site_Util::get_notice_type(self::$type_key));
$notice_comment = \Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $note_id, \Notice\Site_Util::get_notice_type('comment'));
$this->assertNotNull($notice_like);
$this->assertNotNull($notice_comment);
// 件数確認
$this->assertEquals($notice_count_all_before + 2, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before + 2, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before + 2, \Notice\Model_NoticeMemberFrom::get_count());
$this->assertEquals($member_watch_content_count_all_before + 1, \Notice\Model_MemberWatchContent::get_count());
// 関連テーブルのレコードが作成されていることを確認
$this->assertNotNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(2, $notice_comment->id));
$this->assertNotNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(self::$member_id, $notice_like->id));
$this->assertNotNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice_like->id, 2));
$this->assertNotNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice_comment->id, self::$member_id));
$this->assertNotNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $note_id, 2));
$this->assertNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $note_id, self::$member_id));
$this->assertNotNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $note_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
// イイねを取り消し
$like_id = Model_NoteLike::change_registered_status4unique_key(array('note_id' => $note_id, 'member_id' => 2));
// 件数確認
$this->assertEquals($notice_count_all_before + 1, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before + 1, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before + 1, \Notice\Model_NoticeMemberFrom::get_count());
$this->assertEquals($member_watch_content_count_all_before + 1, \Notice\Model_MemberWatchContent::get_count());
// watch は解除されない
// 関連テーブルのレコードが削除されていることを確認
$this->assertNotNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(2, $notice_comment->id));
$this->assertNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(self::$member_id, $notice_like->id));
$this->assertNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice_like->id, 2));
$this->assertNotNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice_comment->id, self::$member_id));
$this->assertNotNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $note_id, 2));
$this->assertNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $note_id, self::$member_id));
$this->assertNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $note_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
// 他人がイイね
$note_like_id = Model_NoteLike::change_registered_status4unique_key(array('note_id' => $note_id, 'member_id' => 3));
$notice = \Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $note_id, \Notice\Site_Util::get_notice_type(self::$type_key));
$this->assertNotNull($notice);
// note 削除
$note = Model_Note::find($note_id);
$note->delete_with_relations();
// 件数確認
$this->assertEquals($notice_count_all_before, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before, \Notice\Model_NoticeMemberFrom::get_count());
$this->assertEquals($member_watch_content_count_all_before, \Notice\Model_MemberWatchContent::get_count());
// 関連テーブルのレコードが削除されていることを確認
$this->assertNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(self::$member_id, $notice->id));
$this->assertNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice->id, 3));
$this->assertNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $note_id, 3));
$this->assertNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $note_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
}
protected function convert_mention2link($string)
{
if (!$this->options['mention2link_is_enabled']) {
return $string;
}
if (!$this->options['mention2link']) {
return $string;
}
return preg_replace_callback(\Notice\Site_Util::get_match_pattern2mention(), array('static', 'mention2link_callback'), $string);
}
/**
* @dataProvider mention_provider
*/
public function test_comment_mention($member_id_from, $mention_member_ids, $countup_nums_exp, $is_cahced_mention_member_ids_exp, $countup_nums_all_exp)
{
if (!is_enabled('notice')) {
\Util_Develop::output_test_info(__FILE__, __LINE__);
$this->markTestSkipped('notice module is disabled.');
}
// 事前準備
$notice_count_all_before = \Notice\Model_Notice::get_count();
// set cache
$notice_counts_before = array();
foreach ($mention_member_ids as $mention_member_id) {
$notice_counts_before[$mention_member_id] = \Notice\Site_Util::get_unread_count($mention_member_id);
}
// timeline_comment save
$body = \Site_Test::get_mention_body($mention_member_ids);
$timeline = Site_Model::save_timeline($member_id_from, FBD_PUBLIC_FLAG_ALL, 'normal', null, null, $body);
$timeline_id = $timeline->id;
// check_cache
if (self::$is_check_notice_cache) {
foreach ($mention_member_ids as $mention_member_id) {
if (in_array($mention_member_id, $is_cahced_mention_member_ids_exp)) {
$this->assertFalse(\Notice\Site_Test::check_no_cache4notice_unread($mention_member_id));
} else {
$this->assertTrue(\Notice\Site_Test::check_no_cache4notice_unread($mention_member_id));
}
}
}
foreach ($mention_member_ids as $mention_member_id) {
// notice count 取得
$notice_count = \Notice\Site_Util::get_unread_count($mention_member_id);
if (self::$is_check_notice_cache) {
$this->assertFalse(\Notice\Site_Test::check_no_cache4notice_unread($mention_member_id));
}
// cache が生成されていることを確認
// execute test
$this->assertEquals($notice_counts_before[$mention_member_id] + $countup_nums_exp[$mention_member_id], $notice_count);
// count up を確認
}
// Model_Notice
// 件数
$notice_count_all = \Notice\Model_Notice::get_count();
$this->assertEquals($notice_count_all_before + $countup_nums_all_exp, $notice_count_all);
}
private static function check_no_cache($member_id)
{
return is_null(\Site_Develop::get_cache(\Notice\Site_Util::get_unread_count_cache_key($member_id), \Config::get('notice.cache.unreadCount.expir')));
}
public static function delete_album_image_multiple4ids($album_image_ids = array(), $with_delete_timeline = false)
{
if (!is_array($album_image_ids)) {
$album_image_ids = (array) $album_image_ids;
}
$delete_target_notice_cache_member_ids = array();
$delete_target_timeline_ids = array();
$writable_connection = \MyOrm\Model::connection(true);
\DBUtil::set_connection($writable_connection);
\DB::start_transaction();
foreach ($album_image_ids as $album_image_id) {
if (is_enabled('notice')) {
\Notice\Site_NoOrmModel::delete_member_watch_content_multiple4foreign_data('album_image', $album_image_id);
$notice_ids = \Notice\Site_NoOrmModel::get_notice_ids4foreign_data('album_image', $album_image_id);
$delete_target_notice_cache_member_ids += \Notice\Site_NoOrmModel::get_notice_status_member_ids4notice_ids($notice_ids);
\Notice\Site_NoOrmModel::delete_notice_multiple4ids($notice_ids);
}
if (is_enabled('timeline') && $with_delete_timeline) {
$delete_target_timeline_ids += \timeline\site_noormmodel::delete_timeline_multiple4foreign_data('album_image', $album_image_id);
}
}
$file_names = \Util_Orm::conv_col2array(Model_AlbumImage::get4ids($album_image_ids), 'file_name');
\DB::delete('album_image')->where('id', 'in', $album_image_ids)->execute();
\DB::commit_transaction();
\DBUtil::set_connection(null);
\DB::start_transaction();
if ($files = \Model_File::get4names($file_names)) {
foreach ($files as $file) {
$file->delete();
}
}
\DB::commit_transaction();
// delete caches
if ($delete_target_notice_cache_member_ids) {
foreach ($delete_target_notice_cache_member_ids as $member_id) {
\Notice\Site_Util::delete_unread_count_cache($member_id);
}
}
if ($delete_target_timeline_ids) {
foreach ($delete_target_timeline_ids as $timeline_id) {
\Timeline\Site_Util::delete_cache($timeline_id);
}
}
}
public function test_delete_notice()
{
// 事前準備
\Model_MemberConfig::set_value(2, \Notice\Form_MemberConfig::get_name(self::$type_key), 1);
\Model_MemberConfig::set_value(2, \Notice\Site_Util::get_member_config_name_for_watch_content(self::$type_key), 1);
\Model_MemberConfig::set_value(3, \Notice\Form_MemberConfig::get_name(self::$type_key), 1);
\Model_MemberConfig::set_value(3, \Notice\Site_Util::get_member_config_name_for_watch_content(self::$type_key), 1);
self::$member_id = 1;
self::$album_image = \Album\Site_Test::setup_album_image(self::$member_id, null, 1);
self::$album = Model_Album::find(self::$album_image->album_id);
$album_image_id = self::$album_image->id;
$foreign_id = self::$album_image->id;
$notice_count_all_before = \Notice\Model_Notice::get_count();
$notice_status_count_all_before = \Notice\Model_NoticeStatus::get_count();
$notice_member_from_count_all_before = \Notice\Model_NoticeMemberFrom::get_count();
$member_watch_content_count_all_before = \Notice\Model_MemberWatchContent::get_count();
// liked from others.
$like_id = Model_AlbumImageLike::change_registered_status4unique_key(array('album_image_id' => $album_image_id, 'member_id' => 2));
$notice = \Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $album_image_id, \Notice\Site_Util::get_notice_type(self::$type_key));
$this->assertNotNull($notice);
// check count
$this->assertEquals($notice_count_all_before + 1, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before + 1, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before + 1, \Notice\Model_NoticeMemberFrom::get_count());
$this->assertEquals($member_watch_content_count_all_before + 1, \Notice\Model_MemberWatchContent::get_count());
// check created related table records.
$this->assertNotNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(self::$member_id, $notice->id));
$this->assertNotNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice->id, 2));
$this->assertNotNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $album_image_id, 2));
$this->assertNotNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $album_image_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
// undo like.
$like_id = Model_AlbumImageLike::change_registered_status4unique_key(array('album_image_id' => $album_image_id, 'member_id' => 2));
// check count
$this->assertEquals($notice_count_all_before, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before, \Notice\Model_NoticeMemberFrom::get_count());
$this->assertEquals($member_watch_content_count_all_before + 1, \Notice\Model_MemberWatchContent::get_count());
// keep watched
// check deleted related table records.
$this->assertNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(self::$member_id, $notice->id));
$this->assertNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice->id, 2));
$this->assertNotNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $album_image_id, 2));
// keep watched
$this->assertNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $album_image_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
// others execute like and coment myself.
$album_image_like_id = Model_AlbumImageLike::change_registered_status4unique_key(array('album_image_id' => $album_image_id, 'member_id' => 2));
\Site_Test::save_comment('album_image', $album_image_id, 1, 'Test comment1.');
$notice_like = \Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $album_image_id, \Notice\Site_Util::get_notice_type(self::$type_key));
$notice_comment = \Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $album_image_id, \Notice\Site_Util::get_notice_type('comment'));
$this->assertNotNull($notice_like);
$this->assertNotNull($notice_comment);
// check count
$this->assertEquals($notice_count_all_before + 2, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before + 2, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before + 2, \Notice\Model_NoticeMemberFrom::get_count());
$this->assertEquals($member_watch_content_count_all_before + 1, \Notice\Model_MemberWatchContent::get_count());
// check created related table records.
$this->assertNotNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(2, $notice_comment->id));
$this->assertNotNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(self::$member_id, $notice_like->id));
$this->assertNotNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice_like->id, 2));
$this->assertNotNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice_comment->id, self::$member_id));
$this->assertNotNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $album_image_id, 2));
$this->assertNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $album_image_id, self::$member_id));
$this->assertNotNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $album_image_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
// undo like.
$like_id = Model_AlbumImageLike::change_registered_status4unique_key(array('album_image_id' => $album_image_id, 'member_id' => 2));
// check count
$this->assertEquals($notice_count_all_before + 1, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before + 1, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before + 1, \Notice\Model_NoticeMemberFrom::get_count());
$this->assertEquals($member_watch_content_count_all_before + 1, \Notice\Model_MemberWatchContent::get_count());
// keep watch
// check created related table records.
$this->assertNotNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(2, $notice_comment->id));
$this->assertNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(self::$member_id, $notice_like->id));
$this->assertNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice_like->id, 2));
$this->assertNotNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice_comment->id, self::$member_id));
$this->assertNotNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $album_image_id, 2));
$this->assertNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $album_image_id, self::$member_id));
$this->assertNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $album_image_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
// others execute like.
$album_image_like_id = Model_AlbumImageLike::change_registered_status4unique_key(array('album_image_id' => $album_image_id, 'member_id' => 3));
$notice = \Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $album_image_id, \Notice\Site_Util::get_notice_type(self::$type_key));
$this->assertNotNull($notice);
// delete album_image.
$album_image = Model_AlbumImage::find($album_image_id);
$album_image->delete();
// check count
$this->assertEquals($notice_count_all_before, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before, \Notice\Model_NoticeMemberFrom::get_count());
$this->assertEquals($member_watch_content_count_all_before, \Notice\Model_MemberWatchContent::get_count());
// check deleted related table records.
$this->assertNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(self::$member_id, $notice->id));
$this->assertNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice->id, 3));
$this->assertNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $album_image_id, 3));
$this->assertNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $album_image_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
// album delete test
// setup
self::$album_image = \Album\Site_Test::setup_album_image(self::$member_id, null, 1, self::$album->id);
$foreign_id = self::$album_image->id;
$album_image_id = self::$album_image->id;
// others execute like.
$album_image_like_id = Model_AlbumImageLike::change_registered_status4unique_key(array('album_image_id' => $album_image_id, 'member_id' => 4));
$notice = \Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $album_image_id, \Notice\Site_Util::get_notice_type(self::$type_key));
$this->assertNotNull($notice);
// delete album_image
self::$album->delete();
// check count
$this->assertEquals($notice_count_all_before, \Notice\Model_Notice::get_count());
$this->assertEquals($notice_status_count_all_before, \Notice\Model_NoticeStatus::get_count());
$this->assertEquals($notice_member_from_count_all_before, \Notice\Model_NoticeMemberFrom::get_count());
$this->assertEquals($member_watch_content_count_all_before, \Notice\Model_MemberWatchContent::get_count());
// check deleted related table records.
$this->assertNull(\Notice\Model_NoticeStatus::get4member_id_and_notice_id(self::$member_id, $notice->id));
$this->assertNull(\Notice\Model_NoticeMemberFrom::get4notice_id_and_member_id($notice->id, 3));
$this->assertNull(\Notice\Model_MemberWatchContent::get_one4foreign_data_and_member_id(self::$foreign_table, $album_image_id, 3));
$this->assertNull(\Notice\Model_Notice::get_last4foreign_data(self::$foreign_table, $album_image_id, \Notice\Site_Util::get_notice_type(self::$type_key)));
}
public function test_delete_album_image_multiple4ids()
{
$timeline_ids = array_unique(\Util_Orm::conv_col2array(\Timeline\Model_TimelineChildData::get4foreign_table_and_foreign_ids('album_image_id', self::$album_image->id), 'timeline_id'));
$notices = array();
if (is_enabled('notice')) {
$notice_ids = \Util_Orm::conv_col2array(\Notice\Model_Notice::get4foreign_data('album_image', self::$album_image->id), 'id');
$notice_ids += \Util_Orm::conv_col2array(\Notice\Model_Notice::get4parent_data('album_image', self::$album_image->id), 'id');
$notice_ids = array_unique($notice_ids);
}
$notice_statuses = \Notice\Model_NoticeStatus::query()->where('notice_id', 'in', $notice_ids)->get();
$file_name = self::$album_image->file_name;
$file = \Model_File::get4name($file_name);
$file_size = $file->filesize;
$member_filesize_before = self::$member->filesize_total;
// timeline view cache 作成
if (self::$is_check_timeline_view_cache) {
$timeline_view_cache_before = \Timeline\Site_Util::make_view_cache4foreign_table_and_foreign_id('album', $album->id, \Config::get('timeline.types.album_image'));
}
// file
if (conf('upload.storageType') == 'db') {
$this->assertNotNull(\Model_FileBin::get4name(self::$album_image->file_name));
}
// album_image delete.
Site_NoOrmModel::delete_album_image_multiple4ids(self::$album_image->id, true);
// 件数
$this->assertEmpty(Model_AlbumImage::query()->where('id', self::$album_image->id)->get());
$this->assertEmpty(Model_AlbumImageLike::query()->where('album_image_id', self::$album_image_comment->id)->get());
$this->assertEmpty(Model_AlbumImageComment::query()->where('album_image_id', self::$album_image->id)->get());
$this->assertEmpty(Model_AlbumImageCommentLike::query()->where('album_image_comment_id', self::$album_image_comment->id)->get());
// file
$this->assertEmpty(\Model_File::get4name($file_name));
// meber_filesize
$this->assertEquals($member_filesize_before - $file_size, self::get_member_filesize_total(self::$member_id));
// timeline
if (is_enabled('timeline')) {
$timeline_child_datas = \Timeline\Model_TimelineChildData::get4foreign_table_and_foreign_ids('album_image', self::$album_image->id);
$this->assertEmpty($timeline_child_datas);
if ($timeline_ids) {
$this->assertEmpty(\Timeline\Model_Timeline::query()->where('id', 'in', $timeline_ids)->get());
}
// timeline view cache check
if (self::$is_check_timeline_view_cache && $timeline_ids) {
foreach ($timeline_ids as ${$timeline_id}) {
$this->assertEmpty(\Timeline\Site_Util::get_view_cache($timeline_id));
}
}
}
// notice
if (is_enabled('notice')) {
$this->assertEmpty(\Notice\Model_MemberWatchContent::get4foreign_data('album_image', self::$album_image->id));
if ($notice_ids) {
$this->assertEmpty(\Notice\Model_Notice::query()->where('id', 'in', $notice_ids)->get());
$this->assertEmpty(\Notice\Model_NoticeStatus::query()->where('notice_id', 'in', $notice_ids)->get());
$this->assertEmpty(\Notice\Model_NoticeMemberFrom::query()->where('notice_id', 'in', $notice_ids)->get());
}
if (self::$is_check_notice_cache) {
foreach ($notice_statuses as $notice_statuse) {
$this->assertEmpty(\Notice\Site_Util::get_unread_count_cache($notice_statuse->member_id));
}
}
}
}
