$cat = \common\models\BlindCatid::find()->where(['id_blind' => $model->id])->all();
$title = '<ul>';
foreach ($cat as $c) {
$catObj = \backend\modules\category\models\Category::find()->where(['id' => $c->id_cat])->one();
$title .= "<li>" . $catObj->name . "</li>";
}
$title .= "</ul>";
return $title;
}], ['attribute' => 'status', 'format' => 'text', 'value' => function ($model) {
if ($model->status == 1) {
return 'Опубликовано';
} else {
return 'Не опубликовано';
}
}], ['class' => DataColumn::className(), 'header' => 'Цена', 'format' => 'html', 'value' => function ($model) {
$page2BlindID = PageToBlind::find()->where(['id_blind' => $model->id])->all();
$supIds = [];
foreach ($page2BlindID as $page) {
$s = PageItem::find()->where(['id_page' => $page->id_pages, 'item_type' => 'materials'])->all();
$supIds = array_merge($supIds, $s);
}
foreach ($supIds as $s) {
$sup = Supplies::find()->where(['id' => $s->id_item])->one();
$prices[] = $sup->price;
}
if (isset($prices) && !empty($prices)) {
$pricesMin = min($prices);
$pricesMax = max($prices);
}
return "<div style='width: 100px'>" . $pricesMin . " - " . $pricesMax . "</div>";
}], ['class' => DataColumn::className(), 'header' => 'Действия', 'format' => 'html', 'value' => function ($model) {
public function actionDel_page_blind()
{
$id = PageBlinds::find()->where(['name' => $_GET[id]])->one();
$del = PageToBlind::deleteAll(['id_pages' => $id->id]);
}
public static function getSupplies($id, $idPage = 0)
{
if ($idPage == 0) {
$page = PageToBlind::find()->where(['id_blind' => $id])->one();
$idPage = $page->id_pages;
}
$allPagess = PageToBlind::find()->where(['id_blind' => $id])->all();
/*Debag::prn($allPagess);*/
$i = 0;
$count = count($allPagess);
foreach ($allPagess as $ap) {
if ($ap->id_pages == $idPage) {
$next = $allPagess[$i + 1]->id_pages;
if ($i == 0) {
$end = end($allPagess);
$end = $end->id_pages;
} else {
if ($i == $count - 1) {
$next = $allPagess[0]->id_pages;
}
$end = $allPagess[$i - 1]->id_pages;
}
}
$i++;
}
$html = '
<div class="title">
<b>Вызов</b> <span>замерщика с образцами</span> бесплатный<br>
Бесплатное <span>3D моделирование жалюзей</span> <b>на ваших окнах</b>
</div>
<a href="#" class="close"></a>
<a href="#" class="cause">Вызвать замерщика</a>
<div class="popup_content">
<div class="prices">';
$html .= PageBlinds::getNameTitle($idPage);
if ($count > 1) {
$html .= '<a href="#" id-page="' . $end . '" id-blind="' . $id . '" class="left pageChange">' . PageBlinds::getNameTitle($end) . '</a>
<a href="#" id-page="' . $next . '" id-blind="' . $id . '" class="right pageChange">' . PageBlinds::getNameTitle($next) . '</a>';
}
$html .= '</div>';
//$supplies = BlindIdmaterials::find()->where(['id_blind'=>$id])->all();
$supplies = PageItem::find()->where(['id_page' => $idPage])->all();
/*$blm = BlindMaterials::find()->where(['id_blind'=>$id])->all();
foreach($blm as $b){
$arrBlmID[] = $b->id_materials;
}*/
$k = 1;
$j = 0;
foreach ($supplies as $v) {
//$supl = \backend\modules\supplies\models\Supplies::find()->where(['id'=>$v->id_materials])->one();
if ($v->item_type == 'zagolovok') {
$zag = PageForTitle::getName($v->id_item);
if ($j != 0) {
$html .= "</div></div></div>";
} else {
$j = 1;
}
$html .= '<div class="group">
<div class="title">' . $zag . '</div>
<div class="group_items">';
$k = 1;
continue;
//echo self::getTitle($id,$v->id_materials).'<br>';
}
$supl = \backend\modules\supplies\models\Supplies::find()->where(['id' => $v->id_item])->one();
if ($k == 1) {
$html .= '<div class="line">';
}
$html .= '<div class="item">
<a href="#"><img src="' . $supl->images . '" alt="" width="163px"/></a>
<span>Код: ' . $supl->code . '</span>
<a href="#" class="order" blind-id="' . $id . '" suuples-id="' . $v->id_item . '">Заказать</a>
</div>';
if ($k == 5) {
$html .= '</div>';
$k = 1;
}
if ($v->item_type == 'zagolovok') {
$html .= '';
//echo self::getTitle($id,$v->id_materials).'<br>';
}
$k++;
}
$html .= '</div></div></div></div>';
return $html;
}
echo $form->field($model, 'description')->widget(CKEditor::className(), ['editorOptions' => \mihaildev\elfinder\ElFinder::ckeditorOptions('elfinder', ['preset' => 'standard', 'inline' => false])]);
?>
</div>
<div id="panel2" class="tab-pane fade <?php
echo $tabContent2;
?>
">
<h3>Материалы</h3>
<?php
echo $form->field($model, 'pagename')->textInput(['maxlength' => true, 'class' => 'form-control pagenameInp']);
?>
<a class="btn btn-success" href="#" id="addPage">Добавить страницу</a>
<hr>
<?php
$pages = \common\models\PageToBlind::find()->where(['id_blind' => $blind->id])->all();
$ul = '';
$k = 0;
foreach ($pages as $p) {
if ($k == 0) {
$title = \common\models\PageBlinds::getNameTitleAdmin($p->id_pages);
$inp = $title;
$title = str_replace(' ', '_', $title);
//$ul .= '<li class="active"><a href="#panel'.$title.'">'.$title.'</a><span page-id="'.$title.'" class="delPages">x</span></li>';
$ul .= '<li class="active"><a href="#panel' . $title . '"><input id-page="' . $title . '" type="text" class="insetName" value="' . $inp . '"/></a><span page-id="' . $title . '" class="delPages">x</span></li>';
$page = \common\models\PageItem::find()->where(['id_page' => $p->id_pages])->all();
$html = '<div id="panel' . $title . '" class="tabPanel activeMy"><h3>' . $inp . '</h3>';
$html .= '<table id="t_' . $title . '" class="table table-bordered">';
foreach ($page as $pg) {
if ($pg->item_type == 'materials') {
$html .= \common\classes\Supplies::getOneAddSupplies($pg->id_item, $title);
public static function getCount($id)
{
//Debag::prn($id);
//$sup = Supplies::find()->where(['type_blind' => $id])->all();
$page2BlindID = PageToBlind::find()->where(['id_blind' => $id])->all();
$supIds = [];
foreach ($page2BlindID as $page) {
$s = PageItem::find()->where(['id_page' => $page->id_pages, 'item_type' => 'materials'])->all();
$supIds = array_merge($supIds, $s);
}
$colors = [];
$materials = [];
$count = [];
$prices = [];
foreach ($supIds as $s) {
$sup = Supplies::find()->where(['id' => $s->id_item])->one();
//Debag::prn($sup);
$colors[] = $sup->color;
$materials[] = $sup->type_mat;
$prices[] = $sup->price;
}
$colors = count(array_unique($colors));
$materials = count(array_unique($materials));
//Debag::prn($prices);
if (isset($prices) && !empty($prices)) {
$prices = min($prices);
$count['min_price'] = $prices;
}
$count['colors'] = $colors;
$count['materials'] = $materials;
//$count['min_price']= $prices;
// Debag::prn($colors);
return $count;
}