public function shortSearch($params)
{
$query = Product::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(['like', 'sku', $this->sku])->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
<?php
use yii\jui\AutoComplete;
use frontend\models\products\Product;
?>
<div class="row">
<div class="col-xs-12 col-sm-8">
<div class="input-group">
<span class="input-group-addon">
<i class="ace-icon fa fa-cube"></i>
</span>
<?php
$this->registerCss('.ui-autocomplete{z-index:1060}');
$mainSKUs = Product::find()->where(['is not', 'stock_qty', null])->andWhere(['qty_per_order' => 1])->asArray()->indexBy('sku')->all();
echo AutoComplete::widget(['name' => 'main-sku', 'clientOptions' => ['source' => array_keys($mainSKUs)], 'options' => ['class' => 'form-control search-query', 'placeholder' => 'Put the main product SKU', 'id' => 'main-sku']]);
?>
<span class="input-group-btn">
<button type="button" class="btn btn-purple btn-sm" id="link-product">
<span class="ace-icon fa fa-link icon-on-right bigger-110"></span>
Link
</button>
</span>
</div>
</div>
</div>
