/** * Configuration Action for Super Admins */ public function actionIndex() { $query = ReportContent::find()->joinWith('content')->andWhere(['IS', 'content.space_id', new \yii\db\Expression('NULL')]); $countQuery = clone $query; $pagination = new \yii\data\Pagination(['totalCount' => $countQuery->count(), 'pageSize' => 20]); $query->offset($pagination->offset)->limit($pagination->limit); return $this->render('index', array('reportedContent' => $query->all(), 'pagination' => $pagination)); }
public static function onIntegrityCheck($event) { $integrityController = $event->sender; $integrityController->showTestHeadline("ReportContent Module (" . ReportContent::find()->count() . " entries)"); foreach (ReportContent::find()->joinWith('content')->all() as $rc) { if ($rc->content === null) { if ($integrityController->showFix("Deleting report id " . $rc->id . " without existing content!")) { $rc->delete(); } } } }