/**
* 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]);
}
