/**
* @param int $characterID
*
* @return string
* @throws \yii\web\NotFoundHttpException
*/
public function actionCreate($characterID)
{
Url::remember(Url::current(), self::REMEMBER_NAME);
$character = $this->loadCharacter($characterID);
$this->getView()->addBread(['label' => 'Demands', 'url' => ['demand/index', 'characterID' => $characterID]])->addBread(['label' => 'Create'])->setCharacter($character);
$marketDemand = new MarketDemand();
$marketDemand->characterID = $characterID;
$marketDemand->userID = \Yii::$app->user->id;
if ($this->isAjax()) {
$type = $this->get('sType');
if ($type == 'station') {
$sql = '(SELECT sStation.stationID, sStation.stationName, sStation.stationTypeID FROM staStations as sStation WHERE sStation.stationName LIKE "%' . $_GET['q'] . '%")
UNION
(SELECT cStation.stationID, cStation.stationName, cStation.stationTypeID FROM api_eve_conquerableStation as cStation WHERE cStation.stationName LIKE "%' . $_GET['q'] . '%")';
} elseif ($type == 'item') {
$sql = 'SELECT typeID, typeName FROM invTypes WHERE typeName LIKE "%' . $_GET['q'] . '%" AND published ="1" ORDER BY typeName';
}
$return = \Yii::$app->db->createCommand($sql)->queryAll();
echo Json::encode($return);
// @todo change response type
\Yii::$app->end();
} elseif ($this->isPost() && $marketDemand->load($this->post())) {
if ($marketDemand->save()) {
UpdaterEveCentral::addType($marketDemand->typeID);
return $this->redirect(['demand/list', 'characterID' => $characterID]);
}
}
return $this->render('create', ['marketDemand' => $marketDemand]);
}
/**
* @return \yii\web\Response
*/
public function actionUpdate()
{
UpdaterEveCentral::update();
return $this->redirect(Url::previous(self::REMEMBER_NAME));
}
/**
*
*/
public function actionUpdate()
{
UpdaterEveCentral::update(false);
}
