/** * Returns array of ID of all active warehouses * @return integer[] * @throws \Exception */ public static function activeWarehousesIds() { if (static::$activeWarehousesIds === null) { static::$activeWarehousesIds = Warehouse::getDb()->cache(function ($db) { return Warehouse::find()->where('is_active=1')->select('id')->orderBy(['sort_order' => SORT_ASC, 'id' => SORT_ASC])->asArray()->column($db); }, 86400, new TagDependency(['tags' => [ActiveRecordHelper::getCommonTag(Warehouse::className())]])); } return static::$activeWarehousesIds; }
/** * Relation to Warehouse * @return \yii\db\ActiveQuery */ public function getWarehouse() { return $this->hasOne(Warehouse::className(), ['id' => 'warehouse_id']); }
public function actionIndex() { $searchModel = new SearchModel(['model' => Warehouse::className(), 'partialMatchAttributes' => ['name'], 'scenario' => 'default']); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); return $this->render('index', ['dataProvider' => $dataProvider, 'searchModel' => $searchModel]); }