public function lastNullPrice($typeID) { //Get the last Null buy price $criteria = new CDbCriteria(); $criteria->condition = 'typeID=:typeID AND (characterID = 2) AND stationID = 60014899 AND transactionType = "buy"'; $criteria->params = array(':typeID' => $typeID); $criteria->order = 'transactionDateTime DESC'; //Run the query $lastNull = Wallet::Model()->find($criteria); return $lastNull->price; }
public function lastJitaPrice($typeID, $days, $walletID) { //Grab the characters from the db $members = $this->getMembersAsArray($this->getUsersGroup($walletID)); $sqlarray = '(' . implode(',', $members) . ')'; //Get the last Jita buy price $criteria = new CDbCriteria(); $criteria->condition = 'typeID=:typeID AND characterID IN ' . $sqlarray . ' AND stationID = 60003760 AND transactionType = "buy" AND personal = 0'; $criteria->params = array(':typeID' => $typeID); $criteria->order = 'transactionDateTime DESC'; //Run the query $lastJita = Wallet::Model()->find($criteria); if (!empty($lastJita)) { return $lastJita->price; } else { return 0; } }
public function lastSalePrice($typeID) { //Get the last sale price $criteria = new CDbCriteria(); $criteria->condition = 'typeID=:typeID AND transactionType = "sell"'; $criteria->params = array(':typeID' => $typeID); $criteria->order = 'transactionDateTime DESC'; //Run query $lastSale = Wallet::Model()->find($criteria); return $lastSale->price; }
//Get station information - not working yet as db stastations table is too old // $stationInfo = Stastations::Model()->findByPk($data->stationID); ?> <?php if ($index % 2) { echo "<tr class='odd'>"; } else { echo "<tr>"; } //Load the station information $statCriteria = new CDbCriteria(); $statCriteria->condition = 'stationID=:stationID'; $statCriteria->params = array(':stationID' => $data->stationID); $statCriteria->order = 'transactionDateTime DESC'; $station = Wallet::Model()->find($statCriteria); //Get our time stuff $timeLeft = $this->getHumanTime(strtotime("+ {$data->duration} day", strtotime($data->issued)) - strtotime("+ 5 hour")); ?> <?php $result = number_format($data->volRemaining / $data->volEntered * 100); if ($result > 50.0) { $left = "<img src='./images/accept.png'>"; } elseif ($result > 25.0) { $left = $left = "<img src='./images/error.png'>"; } else { $left = $left = "<img src='./images/exclamation.png'>"; } ?>
public function getItemHistoricalData($typeID, $sell = 'sell') { //Grab the characters from the db $members = $this->getMembersAsArray(Yii::app()->user->trackingGroupID); $sqlarray = '(' . implode(',', $members) . ')'; $criteria = new CdbCriteria(); $criteria->condition = 'typeID=:typeID AND transactionType = :sell AND personal = 0 AND characterID IN ' . $sqlarray . ''; $criteria->params = array(':typeID' => $typeID, ':sell' => $sell); $criteria->order = 'transactionDateTime'; $history = Wallet::Model()->findAll($criteria); $graphArray = '['; foreach ($history as $transaction) { $date = (strtotime($transaction->transactionDateTime) - 5 * 60 * 60) * 1000; $graphArray = $graphArray . '[' . $date . ',' . $transaction->price . '],'; } $graphArray = $graphArray . ']'; return $graphArray; }