public static function get_notice_status_member_ids4notice_ids($notice_ids)
{
if (!$notice_ids) {
return array();
}
return \Util_Db::conv_col(\DB::select('notice_id')->from('notice_status')->where('notice_id', 'in', $notice_ids)->execute()->as_array());
}
public static function delete_album_image_multiple4album_id($album_id, $with_delete_timeline = false, $limit = 0)
{
if (!$limit) {
$limit = conf('batch.limit.delete.album_image');
}
while ($album_image_ids = \Util_Db::conv_col(\DB::select('id')->from('album_image')->where('album_id', $album_id)->limit($limit)->as_assoc()->execute())) {
static::delete_album_image_multiple4ids($album_image_ids, $with_delete_timeline);
}
}
public static function delete_note4member_id($member_id, $limit = 0)
{
if (!$limit) {
$limit = conf('batch.limit.delete.note');
}
while ($note_ids = \Util_Db::conv_col(\DB::select('id')->from('note')->where('member_id', $member_id)->limit($limit)->as_assoc()->execute())) {
foreach ($note_ids as $note_id) {
static::delete_note4id($note_id);
}
}
}
public static function get_timeline_ids4foreign_data($foreign_table, $foreign_id)
{
return \Util_Db::conv_col(\DB::select('id')->from('timeline')->where('foreign_table', $foreign_table)->where('foreign_id', $foreign_id)->execute()->as_array());
}
