/**
* Читка всех сгенерированных миниатюр
*/
public function actionClearAllThumbnails()
{
/**
* @var $files StorageFile[]
*/
if ($files = StorageFile::find()->all()) {
foreach ($files as $file) {
$file->deleteTmpDir();
}
}
}
public function safeUp()
{
$rows = (new \yii\db\Query())->select(['id', 'files'])->from('cms_tree')->all();
if ($rows) {
foreach ($rows as $row) {
/**
* @var \skeeks\cms\models\CmsTree $model
*/
if (!($modelId = \yii\helpers\ArrayHelper::getValue($row, 'id'))) {
continue;
}
if (!($model = \skeeks\cms\models\CmsTree::findOne($modelId))) {
continue;
}
$files = \yii\helpers\ArrayHelper::getValue($row, 'files');
if (!$files) {
continue;
}
$files = Json::decode($files);
if ($images = \yii\helpers\ArrayHelper::getValue($files, 'images')) {
foreach ($images as $src) {
$storageFile = \skeeks\cms\models\StorageFile::find()->where(['src' => $src])->one();
if ($storageFile) {
if (!$model->getCmsTreeImages()->andWhere(['storage_file_id' => $storageFile->id])->one()) {
$model->link('images', $storageFile);
}
}
}
}
if ($files = \yii\helpers\ArrayHelper::getValue($files, 'files')) {
foreach ($files as $src) {
$storageFile = \skeeks\cms\models\StorageFile::find()->where(['src' => $src])->one();
if ($storageFile) {
if (!$model->getCmsTreeFiles()->andWhere(['storage_file_id' => $storageFile->id])->one()) {
$model->link('files', $storageFile);
}
}
}
}
}
}
$rows = (new \yii\db\Query())->select(['id', 'files'])->from('cms_content_element')->all();
if ($rows) {
foreach ($rows as $row) {
/**
* @var \skeeks\cms\models\CmsContentElement $model
*/
if (!($modelId = \yii\helpers\ArrayHelper::getValue($row, 'id'))) {
continue;
}
if (!($model = \skeeks\cms\models\CmsContentElement::findOne($modelId))) {
continue;
}
$files = \yii\helpers\ArrayHelper::getValue($row, 'files');
if (!$files) {
continue;
}
$files = Json::decode($files);
if ($images = \yii\helpers\ArrayHelper::getValue($files, 'images')) {
foreach ($images as $src) {
$storageFile = \skeeks\cms\models\StorageFile::find()->where(['src' => $src])->one();
if ($storageFile) {
if (!$model->getCmsContentElementImages()->andWhere(['storage_file_id' => $storageFile->id])->one()) {
$model->link('images', $storageFile);
}
}
}
}
if ($files = \yii\helpers\ArrayHelper::getValue($files, 'files')) {
foreach ($files as $src) {
$storageFile = \skeeks\cms\models\StorageFile::find()->where(['src' => $src])->one();
if ($storageFile) {
if (!$model->getCmsContentElementFiles()->andWhere(['storage_file_id' => $storageFile->id])->one()) {
$model->link('files', $storageFile);
}
}
}
}
}
}
}
<p></p>
<? $dataProvider->pagination->defaultPageSize = 10; ?>
<?php
echo \skeeks\cms\modules\admin\widgets\GridViewHasSettings::widget(['dataProvider' => $dataProvider, 'filterModel' => $search->getLoadedModel(), 'pjaxOptions' => ['id' => 'sx-storage-files'], 'columns' => [['class' => \yii\grid\DataColumn::className(), 'value' => function (\skeeks\cms\models\StorageFile $model) {
return \yii\helpers\Html::a('<i class="glyphicon glyphicon-circle-arrow-left"></i> ' . \Yii::t('skeeks/cms', 'Choose file'), $model->src, ['class' => 'btn btn-primary', 'onclick' => 'sx.SelectFile.submit("' . $model->src . '"); return false;', 'data-pjax' => 0]);
}, 'format' => 'raw'], ['class' => \skeeks\cms\modules\admin\grid\ActionColumn::className(), 'controller' => \Yii::$app->createController('cms/admin-storage-files')[0], 'isOpenNewWindow' => true], ['class' => \yii\grid\DataColumn::className(), 'value' => function (\skeeks\cms\models\StorageFile $model) {
if ($model->isImage()) {
$smallImage = \Yii::$app->imaging->getImagingUrl($model->src, new \skeeks\cms\components\imaging\filters\Thumbnail());
return "<a href='" . $model->src . "' data-pjax='0' class='sx-fancybox' title='" . \Yii::t('skeeks/cms', 'Increase') . "'>\n <img src='" . $smallImage . "' />\n </a>";
}
return \yii\helpers\Html::tag('span', $model->extension, ['class' => 'label label-primary', 'style' => 'font-size: 18px;']);
}, 'format' => 'raw'], 'name', ['class' => \yii\grid\DataColumn::className(), 'value' => function (\skeeks\cms\models\StorageFile $model) {
$model->cluster_id;
$cluster = \Yii::$app->storage->getCluster($model->cluster_id);
return $cluster->name;
}, 'filter' => \yii\helpers\ArrayHelper::map(\Yii::$app->storage->getClusters(), 'id', 'name'), 'format' => 'html', 'attribute' => 'cluster_id'], ['attribute' => 'mime_type', 'filter' => \yii\helpers\ArrayHelper::map(\skeeks\cms\models\StorageFile::find()->groupBy(['mime_type'])->all(), 'mime_type', 'mime_type')], ['attribute' => 'extension', 'filter' => \yii\helpers\ArrayHelper::map(\skeeks\cms\models\StorageFile::find()->groupBy(['extension'])->all(), 'extension', 'extension')], ['class' => \skeeks\cms\grid\FileSizeColumnData::className(), 'attribute' => 'size'], ['class' => \skeeks\cms\grid\CreatedAtColumn::className()], ['class' => \skeeks\cms\grid\CreatedByColumn::className()]]]);
?>
<?php
echo $form->fieldSetEnd();
?>
<hr />
<?php
echo \yii\helpers\Html::a("<i class='glyphicon glyphicon-question-sign'></i>", "#", ['class' => 'btn btn-default', 'onclick' => "sx.dialog({'title' : '" . \Yii::t('skeeks/cms', 'Help') . "', 'content' : '#sx-help'}); return false;"]);
?>
<div style="display: none;" id="sx-help">
<?\Yii::t('skeeks/cms','Help in the process of writing ...')?>
</div>
