public function indexAction()
{
$categories = Categories::find("is_actived=1");
$this->logger->info('INDEX');
$products = [];
$categoryId = $this->request->getQuery("cid", "int");
#$categoryId = $this->dispatcher->getParam("cid");
$subcatId = $this->request->getQuery("sid", "int");
if (!$categoryId) {
$categoryId = 1;
}
$category = Categories::findFirst($categoryId);
if ($subcatId) {
$query = Products::query()->where("is_available=1");
$query->andWhere("sub_category_id={$subcatId}");
$query->andWhere("status='Approved'");
$products = $query->execute();
} else {
$query = Products::query()->where("is_available=1");
$query->andWhere("category_id={$categoryId}");
$query->andWhere("status='Approved'");
$products = $query->execute();
}
$subcats = SubCategories::find("category_id={$categoryId}");
$this->view->categories = $categories;
$this->view->subcats = $subcats;
$this->view->currentCategory = $category;
$this->view->products = $products;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getCategory()
{
return $this->hasOne(Categories::className(), ['id' => 'category_id']);
}
echo $form->field($model, 'price')->textInput(['maxlength' => true]);
?>
<?php
echo $form->field($model, 'Ingredients')->textarea(['rows' => 6]);
?>
<?php
echo $form->field($model, 'created')->textInput();
?>
<?php
echo $form->field($model, 'updated')->textInput();
?>
<?php
$listData = ArrayHelper::map(Categories::find()->all(), 'id', 'name');
?>
<?php
echo $form->field($model, 'category_id')->dropDownList($listData, ['prompt' => 'Select...']);
?>
<div class="form-group">
<?php
echo Html::submitButton($model->isNewRecord ? Yii::t('app', 'Create') : Yii::t('app', 'Update'), ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
</div>
<?php
ActiveForm::end();
/**
* Finds the Categories model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Categories the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Categories::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
