/**
* @param array|null $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = MarketOrder::find()->joinWith(['staStation', 'invTypes']);
$dataProvider = new ActiveDataProvider(['query' => $query]);
if (!$this->load($params) && !$this->validate()) {
return $dataProvider;
}
$dataProvider->getSort()->attributes['stationName'] = ['asc' => ['staStations.stationName' => SORT_ASC], 'desc' => ['staStations.stationName' => SORT_DESC]];
$dataProvider->getSort()->attributes['typeName'] = ['asc' => ['invTypes.typeName' => SORT_ASC], 'desc' => ['invTypes.typeName' => SORT_DESC]];
$query->andFilterWhere(['stationID' => $this->stationID])->andFilterWhere(['like', 'stationName', $this->getAttribute('stationName')])->andFilterWhere(['like', 'typeName', $this->getAttribute('typeName')])->andFilterWhere(['orderState' => $this->orderState])->andFilterWhere(['characterID' => $this->characterID]);
return $dataProvider;
}
/**
* @return static
*/
public function getOrders()
{
return MarketOrder::find()->where(['characterID' => $this->characterID, 'stationID' => $this->stationID, 'typeID' => $this->typeID, 'orderState' => MarketOrder::ORDER_STATE_OPEN])->all();
}
