/**
* TODO: In future models will have more relations which might not delete automatically. It should be tested properly
* TODO: Files should be deleted too
* Deletes all boards, threads and posts with 'is_deleted = 1', handles relation between them.
* @return array with deleted rows
*/
public static function clean()
{
$itemsToDelete = ['boardsIds' => [], 'threadsIds' => [], 'postsIds' => [], 'postDataIds' => [], 'postMessageIds' => []];
Post::getDeletedRows($itemsToDelete);
Thread::getDeletedRows($itemsToDelete);
Board::getDeletedRows($itemsToDelete);
self::getPostDataIds($itemsToDelete);
self::getPostMessageIds($itemsToDelete);
/**
* Deletes post_message's related to threads and posts
*/
$deleted['post_messages'] = PostMessage::deleteAll(['in', 'id', array_unique($itemsToDelete['postMessageIds'])]);
/**
* Deletes threads and posts because of FK
*/
$deleted['threads'] = Thread::deleteAll(['in', 'id', array_unique($itemsToDelete['threadsIds'])]);
/**
* Deleted posts and threads related to post_data
*/
$deleted['post_data'] = PostData::deleteAll(['in', 'id', array_unique($itemsToDelete['postDataIds'])]);
/**
* Deleted boards
*/
$deleted['boards'] = Board::deleteAll(['in', 'id', array_unique($itemsToDelete['boardsIds'])]);
$deleted['posts'] = $deleted['post_data'] - $deleted['threads'];
$deleted['total'] = $deleted['boards'] + $deleted['threads'] + $deleted['posts'] + $deleted['post_data'] + $deleted['post_messages'];
return $deleted;
}
public function create(string $boardName, array $data)
{
/** @var Board $board */
if (!($board = Board::findOne(['name' => $boardName]))) {
throw new UserException('Board was not found', 404);
}
$validationParams = $board->postsSettings->getValidationParams();
$thread = new Thread(['boardId' => $board->id]);
$postData = new PostData(['validationParams' => $validationParams]);
$uploadForm = new UploadForm(['files' => PostedFile::getPostedFiles($validationParams['maxFiles']), 'validationParams' => $validationParams]);
$toLoad = [$thread, $postData];
$toValidate = [$thread, $postData, $uploadForm];
if (!ARExtended::loadMultiple($toLoad, $data) || !Model::validateMultiple($toValidate)) {
throw new UserException('Failed to load/validate data', 400);
}
if (strlen($postData->messageText) == 0 && count($uploadForm->files)) {
throw new UserException('Must be attached atleast 1 file or non-empty message', 400);
}
$toSave = [$postData, $thread, $uploadForm];
$postData->on(PostData::EVENT_AFTER_INSERT, function ($event) use($thread) {
$thread->postDataId = $event->sender->id;
});
$saved = true;
foreach ($toSave as $model) {
if (method_exists($model, 'save')) {
$saved = $saved && $model->save();
if (!$saved) {
break;
}
}
}
if (!$saved) {
for ($i = count($toSave) - 1; $i >= 0; $i--) {
method_exists($toSave[$i], 'delete') && $toSave[$i]->delete();
}
throw new UserException('Failed to create thread', 500);
}
foreach ($uploadForm->getFileInfos() as $fileInfo) {
$postData->link('fileInfos', $fileInfo);
}
$thread->link('board', $board);
return $thread;
}
public function getPostData()
{
return $this->hasOne(PostData::className(), ['id' => 'post_data_id']);
}
