Beispiel #1
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Supplies::find()->orderBy('id DESC');
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id, 'type_mat' => $this->type_mat, 'type_blind' => $this->type_blind, 'color' => $this->color, 'status' => $this->status]);
     $query->andFilterWhere(['like', 'images', $this->images])->andFilterWhere(['like', 'type_width', $this->type_width])->andFilterWhere(['like', 'price', $this->price])->andFilterWhere(['like', 'code', $this->code]);
     return $dataProvider;
 }
Beispiel #2
0
 public function actionGet_order()
 {
     $blind = Blind::find()->where(['id' => $_GET['blId']])->one();
     $materials = \backend\modules\supplies\models\Supplies::find()->where(['id' => $_GET['mtId']])->one();
     $telephone = $_GET['tel'];
     $order = new Orders();
     $order->blind = (string) $blind->name;
     $order->materials = (string) $materials->code;
     $order->telephone = (string) $telephone;
     $order->dt_add = time();
     $order->save();
     echo $order->id;
     $email = Options::find()->where(['key' => 'email_to_prod'])->one();
     mail($email->value, "Заказ с вашего сайта", "С вашего сайта заказали:<br>Номер заказа: {$blind->id}<br>Название жалюзи: {$blind->name}<br>Код материала: {$materials->code}<br>Телефон для связ: {$telephone}", "Content-type: text/html; charset=UTF-8\r\n");
 }
Beispiel #3
0
    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) {
    /*$view = Html::a("<img src='".\yii\helpers\Url::base()."crud_img/view.png' width='20px' title='Просмотр'></a>", ['/blind/blind/view','id'=>$model->id]);*/
    $view = Html::a("<img src='" . \yii\helpers\Url::base() . "crud_img/edit.png' width='20px' title='Редактировать'></a>", ['/blind/blind/update', 'id' => $model->id]);
    $view .= Html::a("<img src='" . \yii\helpers\Url::base() . "crud_img/del.png' width='20px' title='Удалить'></a>", ['/blind/blind/delete', 'id' => $model->id]);
    return $view;
}]]]);
?>
Beispiel #4
0
 public function actionChange_sup()
 {
     if (isset($_GET['code_val'])) {
         $id = explode('_', $_GET['id']);
         $sup = Supplies::find()->where(['id' => $id[1]])->one();
         $sup->code = $_GET['code_val'];
         $sup->save();
     }
     if (isset($_GET['mat_val'])) {
         $id = explode('_', $_GET['id']);
         $sup = Supplies::find()->where(['id' => $id[1]])->one();
         $sup->type_mat = $_GET['mat_val'];
         $sup->save();
     }
     if (isset($_GET['blind_val'])) {
         $id = explode('_', $_GET['id']);
         $sup = Supplies::find()->where(['id' => $id[1]])->one();
         $sup->type_blind = $_GET['blind_val'];
         $sup->save();
     }
     if (isset($_GET['price_val'])) {
         $id = explode('_', $_GET['id']);
         $sup = Supplies::find()->where(['id' => $id[1]])->one();
         $sup->price = $_GET['price_val'];
         $sup->save();
     }
     if (isset($_GET['width_val'])) {
         $id = explode('_', $_GET['id']);
         $sup = Supplies::find()->where(['id' => $id[1]])->one();
         $sup->type_width = $_GET['width_val'];
         $sup->save();
     }
     if (isset($_GET['color_val'])) {
         $sup = Supplies::find()->where(['id' => $_GET['id']])->one();
         $sup->color = $_GET['color_val'];
         $sup->save();
     }
     if (isset($_GET['img_val'])) {
         $sup = Supplies::find()->where(['id' => $_GET['id']])->one();
         $sup->images = $_GET['img_val'];
         $sup->save();
     }
     if (isset($_GET['id_mat']) && $_GET['id_page']) {
         // $pageItem = PageItem::find()->where(['id_item'=>$_GET['id_mat'],'id_blind'=>$_GET['id_page']])->all();
         $pageItem = PageItem::deleteAll(['id_item' => $_GET['id_mat'], 'id_blind' => $_GET['id_page']]);
     }
 }
Beispiel #5
0
 public function actionPubl_materials()
 {
     $arr = explode(",", $_GET['val']);
     $html = '';
     foreach ($arr as $a) {
         if (!empty($a)) {
             $sup = \backend\modules\supplies\models\Supplies::find()->where(['code' => $a])->one();
             if (isset($sup->id)) {
                 $html .= \common\classes\Supplies::getOneAddSupplies($sup->id, $_GET['id_page']);
             }
         }
     }
     return $html;
 }
Beispiel #6
0
 public static function getOneAddSupplies($id, $title)
 {
     $supl = \backend\modules\supplies\models\Supplies::find()->where(['id' => $id])->one();
     $html = '';
     $html .= '<tr class="itemPage" page-id="' . $title . '" materials-id="' . $supl->id . '" item-type="materials">';
     $html .= '<td><img src="' . $supl->images . '" style = "width:100px;"/></td>';
     $html .= '<td>' . $supl->code . '</td>';
     $type_materials = Material::find()->where(['id' => $supl->type_mat])->one();
     $html .= '<td>' . $type_materials->name . '</td>';
     if ($supl->type_blind == 1) {
         $html .= '<td>Горизонтальные</td>';
     }
     if ($supl->type_blind == 2) {
         $html .= '<td>Вертикальные</td>';
     }
     if ($supl->type_blind == 3) {
         $html .= '<td>Рулонные</td>';
     }
     $html .= '<td>' . $supl->type_width . '</td>';
     $color = Color::find()->where(['id' => $supl->color])->one();
     $html .= '<td><div class="colorSuplies" style="width:50px;height:25px;background: ' . $color->value . '"></div></td>';
     $html .= '<td>' . $supl->price . '</td>';
     $html .= '<td><a id-materials="' . $supl->id . '"class = "delSuplies" href="#">Открепить</a></td>';
     $html .= '</tr>';
     return $html;
 }
Beispiel #7
0
 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;
 }