/** * @param string $result * * @return bool */ public function doUpdate($result) { $return = true; $xmlObj = $this->createXmlObject($result); $orders = $xmlObj->result->rowset->row; foreach ($orders as $order) { $data = self::getXmlAttr($order); $marketOrder = MarketOrder::findOne(['characterID' => $data['charID'], 'orderID' => $data['orderID']]); if (!$marketOrder) { $marketOrder = new MarketOrder(); $marketOrder->characterID = $data['charID']; $marketOrder->orderID = $data['orderID']; } $marketOrder->stationID = $data['stationID']; $marketOrder->volEntered = $data['volEntered']; $marketOrder->volRemaining = $data['volRemaining']; $marketOrder->minVolume = $data['minVolume']; $marketOrder->orderState = $data['orderState']; $marketOrder->typeID = $data['typeID']; $marketOrder->range = $data['range']; $marketOrder->accountKey = $data['accountKey']; $marketOrder->duration = $data['duration']; $marketOrder->escrow = $data['escrow']; $marketOrder->price = $data['price']; $marketOrder->bid = $data['bid']; $marketOrder->issued = date($data['issued']); $return = $marketOrder->save() && $return; } return $return; }
/** * @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(); }