/**
* Updates an existing Products 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);
$brands = Brands::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, 'brands' => $brands]);
}
}
/**
* 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);
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, 'id_country' => $this->id_country]);
$query->andFilterWhere(['like', 'name', $this->name]);
return $dataProvider;
}
public function search($input)
{
$query = Brands::query();
$columns = Schema::getColumnListing('brands');
$attributes = array();
foreach ($columns as $attribute) {
if (isset($input[$attribute]) and !empty($input[$attribute])) {
$query->where($attribute, $input[$attribute]);
$attributes[$attribute] = $input[$attribute];
} else {
$attributes[$attribute] = null;
}
}
return [$query->get(), $attributes];
}
/**
* @return \yii\db\ActiveQuery
*/
public function getBrands0()
{
return $this->hasMany(Brands::className(), ['updatedBy' => 'id']);
}
public function getNameBrand()
{
return $this->hasOne(Brands::className(), ['id' => 'id_brand'])->one()->name;
}
/**
* Show the home page to the user.
*
* @return Response
*/
public function index()
{
$data['brands'] = Brands::all();
$data['latest'] = Product::orderBy('product_id', 'desc')->take('6')->get();
return view('frontend/livesearch', $data);
}
/**
* 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.');
}
}