/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Types::find();
$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]);
$query->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
/**
* Updates an existing Devices model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id
* @return mixed
*/
public function actionUpdate($id)
{
$model = $this->findModel($id);
$listparent = Devices::find()->all();
$listobject = Objects::find()->all();
$listbrend = Brends::find()->all();
$listinterface = Interfaces::find()->all();
$liststate = States::find()->all();
$listype = Types::find()->all();
if ($model->load(Yii::$app->request->post()) && $model->save()) {
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render('update', ['model' => $model, 'listparent' => $listparent, 'listobject' => $listobject, 'listbrend' => $listbrend, 'listinterface' => $listinterface, 'liststate' => $liststate, 'listype' => $listype]);
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Types::find();
// add conditions that should always apply here
$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;
}
// grid filtering conditions
$query->andFilterWhere(['ID' => $this->ID, 'isReduced' => $this->isReduced]);
$query->andFilterWhere(['like', 'description', $this->description]);
return $dataProvider;
}
public static function getTypesList()
{
// Выбираем только те категории, у которых есть дочерние категории
$parents = Types::find()->select(['id', 'name'])->all();
return ArrayHelper::map($parents, 'id', 'name');
}
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\ArrayHelper;
/* @var $this yii\web\View */
/* @var $model app\models\Cards */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="cards-form">
<?php
$form = ActiveForm::begin();
?>
<?php
$types = \app\models\Types::find()->all();
$items = ArrayHelper::map($types, 'id', 'name');
$params = ['prompt' => 'Выберите тип карты'];
echo $form->field($model, 'cardTypeID')->dropDownList($items, $params);
?>
<?php
$clubs = \app\models\Clubs::find()->all();
$items = ArrayHelper::map($clubs, 'id', 'name');
$params = ['prompt' => 'Выберите клуб'];
echo $form->field($model, 'clubID')->dropDownList($items, $params);
?>
<?php
echo $form->field($model, 'cost')->textInput();
?>
public function assign_volume_type($From, $To, $VolumeType)
{
/* echo $From;
echo $To;
echo $VolumeType;
*/
$From_id = Pages::find(array('fields' => '_id'), array('conditions' => array('filename' => $From)));
$To_id = Pages::find(array('fields' => '_id'), array('conditions' => array('_id' => $To)));
$Types_id = Types::find(array('fields' => '_id'), array('conditions' => array('_id' => $VolumeType)));
foreach ($Types_id as $t) {
$type_id = $t['_id'];
$type_name = $t['name'];
$type_no = $t['no'];
}
foreach ($From_id as $t) {
$from_sort_order = $t['sort_order'];
$volume_number = $t['volume_number'];
}
foreach ($To_id as $t) {
$to_sort_order = $t['sort_order'];
}
$data = array('type.no' => $type_no, 'type.id' => $type_id, 'type.name' => $type_name, 'ip' => $_SERVER['REMOTE_ADDR']);
for ($i = $from_sort_order; $i <= $to_sort_order; $i++) {
$new_page = Pages::find(array('fields' => '_id'), array('conditions' => array('sort_order' => $i, 'volume_number' => $volume_number)))->save($data);
}
// return $this->render(array('json' => $data = array($new_page), 'status'=> 200));
}
public static function types($id)
{
return \App\Models\Types::find($id);
}
<div class="row row-offcanvas row-offcanvas-right">
<div class="col-xs-12 col-sm-9">
<p class="pull-right visible-xs">
<button type="button" class="btn btn-primary btn-xs" data-toggle="offcanvas">Меню</button>
</p>
<div class="row">
</div><!--/row-->
</div><!--/span-->
<?php
$cities = \app\models\City::find()->count();
$clubs = \app\models\Clubs::find()->count();
$cards = \app\models\Cards::find()->count();
$types = \app\models\Types::find()->count();
$orders = \app\models\Order::find()->count();
$viziting = \app\models\Viziting::find()->count();
$duration = \app\models\Duration::find()->count();
?>
<div class="col-xs-6 col-sm-3 sidebar-offcanvas" id="sidebar" role="navigation">
<div class="list-group">
<?php
if (Yii::$app->user->identity->username == "admin") {
echo '<a href="/city" class="list-group-item">Города (' . $cities . ')</a>
<a href="/clubs" class="list-group-item">Клубы (' . $clubs . ')</a>
<a href="/cards" class="list-group-item">Карты (' . $cards . ')</a>
<a href="/types" class="list-group-item">Типы карт (' . $types . ')</a>
<a href="/viziting" class="list-group-item">Время посещений (' . $viziting . ')</a>
<a href="/duration" class="list-group-item">Сроки действия карт (' . $duration . ')</a>';
use app\models\States;
use app\models\Types;
use yii\helpers\ArrayHelper;
/* @var $this yii\web\View */
/* @var $searchModel app\models\DevicesSearch */
/* @var $dataProvider yii\data\ActiveDataProvider */
$this->title = 'Devices';
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="devices-index">
<h1><?php
echo Html::encode($this->title);
?>
</h1>
<?php
// echo $this->render('_search', ['model' => $searchModel]);
?>
<p>
<?php
echo Html::a('Create Devices', ['create'], ['class' => 'btn btn-success']);
?>
</p>
<?php
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'name', 'description:ntext', ['attribute' => 'type', 'label' => 'Тип', 'value' => 'types.name', 'filter' => ArrayHelper::map(Types::find()->all(), 'id', 'name')], ['attribute' => 'state', 'label' => 'state', 'value' => 'states.name', 'filter' => ArrayHelper::map(States::find()->all(), 'id', 'name')], ['attribute' => 'idobject', 'label' => 'Обьект', 'value' => 'objects.name', 'filter' => ArrayHelper::map(Objects::find()->all(), 'id', 'name')], ['class' => 'yii\\grid\\ActionColumn']]]);
?>
</div>
