/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Brands::find(); $dataProvider = new ActiveDataProvider([ 'query' => $query, ]); $this->load($params); $dataProvider->pagination->pageSize=$this->pageSize; 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, 'create_date' => $this->create_date, 'update_date' => $this->update_date, 'is_active' => $this->is_active, ]); $query->andFilterWhere(['like', 'name', $this->name]) ->andFilterWhere(['like', 'description', $this->description]) ->andFilterWhere(['like', 'image', $this->image]); return $dataProvider; }
protected function dataTables(){ $allModels = (new Query())->select( '('.(new Query())->select('count(*)')->from(Auctions::tableName())->createCommand()->rawSql.') as auctions,'. '('.(new Query())->select('count(*)')->from(Dealers::tableName())->createCommand()->rawSql.') as dealers,'. '('.(new Query())->select('count(*)')->from(Companies::tableName())->createCommand()->rawSql.') as companies,'. '('.(new Query())->select('count(*)')->from(Brands::tableName())->createCommand()->rawSql.') as brands,'. '('.(new Query())->select('count(*)')->from(Categories::tableName())->createCommand()->rawSql.') as categories' )->one(); $_message = Auction::loggerMessageFormat('Admin Dashboard Created With :: ',$allModels); Auction::info($_message); return new ArrayDataProvider([ 'allModels' => $allModels, 'pagination' => false ]); }
public function getBrand0(){ return $this->hasOne(Brands::className(),['id' => 'brand_id']); }
<?php $form = ActiveForm::begin([ 'id' => 'create-brand', //'action' => Url::to(['brand/create']), 'options' => [ 'data-pjax' => 1, 'enctype' => 'multipart/form-data' ], 'enableClientValidation' => false ]); ?> <?= Html::hiddenInput('id', $model->id);?> <?= $form->field($model, 'name')->textInput() ?> <?= $form->field($model, 'brand_id')->dropDownList(ArrayHelper::map(Brands::find()->asArray()->all(),'id' ,'name')) ?> <?= $form->field($model, 'cat_id')->dropDownList(ArrayHelper::map(Categories::find()->asArray()->all(),'id' ,'name')) ?> <?= $form->field($model, 'prize')->textInput() ?> <?= $form->field($model, 'image')->fileInput() ?> <?= $form->field($model, 'condition')->textarea(['row' => 2]) ?> <?= $form->field($model, 'extra_cond')->textarea(['row' => 2]) ?> <div class="form-group"> <?= Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']) ?> </div>
/** * Finds the Brands model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Brands the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Brands::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }