public function usageCheck($installedItemID) { //Grab an industry job for this installedItemID if one exists $job = IndustryJobs::Model()->find('installedItemID=:installedItemID AND completed = 0', array(':installedItemID' => $installedItemID)); if ($job != NULL) { return "<img src='./images/tick.png' style='height: 12px; width: 12px;'>"; } }
public function storeData($walletID) { $attributes = $this->apiAttributes(); //Retrieve the XML dataset $industryJobs = $this->getEVEData($walletID); $character = Characters::Model()->findByPk($walletID); if (!isset($industryJobs->error)) { foreach ($industryJobs->result->rowset->row as $row) { //if ($row->attributes()->installerID == $character->characterID) //{ $exist = IndustryJobs::Model()->exists('jobID=:jobID', array(':jobID' => $row->attributes()->jobID)); // If this job doesn't exist yet, create a new one and populate it if (!$exist) { $jobRow = new IndustryJobs(); $jobRow->jobID = $row->attributes()->jobID; $jobRow->assemblyLineID = $row->attributes()->assemblyLineID; $jobRow->containerID = $row->attributes()->containerID; $jobRow->installedItemID = $row->attributes()->installedItemID; $jobRow->installedItemLocationID = $row->attributes()->installedItemLocationID; $jobRow->installedItemQuantity = $row->attributes()->installedItemQuantity; $jobRow->installedItemProductivityLevel = $row->attributes()->installedItemProductivityLevel; $jobRow->installedItemMaterialLevel = $row->attributes()->installedItemMaterialLevel; $jobRow->installedItemLicensedProductionRunsRemaining = $row->attributes()->installedItemLicensedProductionRunsRemaining; $jobRow->outputLocationID = $row->attributes()->outputLocationID; $jobRow->installerID = $row->attributes()->installerID; $jobRow->runs = $row->attributes()->runs; $jobRow->licensedProductionRuns = $row->attributes()->licensedProductionRuns; $jobRow->installedInSolarSystemID = $row->attributes()->installedInSolarSystemID; $jobRow->containerLocationID = $row->attributes()->containerLocationID; $jobRow->materialMultiplier = $row->attributes()->materialMultiplier; $jobRow->charMaterialMultiplier = $row->attributes()->charMaterialMultiplier; $jobRow->timeMultiplier = $row->attributes()->timeMultiplier; $jobRow->charTimeMultiplier = $row->attributes()->charTimeMultiplier; $jobRow->installedItemTypeID = $row->attributes()->installedItemTypeID; $jobRow->outputTypeID = $row->attributes()->outputTypeID; $jobRow->containerTypeID = $row->attributes()->containerTypeID; $jobRow->installedItemCopy = $row->attributes()->installedItemCopy; $jobRow->completed = $row->attributes()->completed; $jobRow->completedSuccessfully = $row->attributes()->completedSuccessfully; $jobRow->installedItemFlag = $row->attributes()->installedItemFlag; $jobRow->activityID = $row->attributes()->activityID; $jobRow->completedStatus = $row->attributes()->completedStatus; $jobRow->installTime = $row->attributes()->installTime; $jobRow->outputFlag = $row->attributes()->outputFlag; $jobRow->beginProductionTime = $row->attributes()->beginProductionTime; $jobRow->endProductionTime = $row->attributes()->endProductionTime; $jobRow->pauseProductionTime = $row->attributes()->pauseProductionTime; $jobRow->save(); print_r($jobRow->getErrors()); } else { // Retrieve the job $jobRow = IndustryJobs::Model()->findByPk($row->attributes()->jobID); // Do we need to move this job to assets? if ($jobRow->completed == 0 && $row->attributes()->completed == 1) { //Get the typeID details $typeID = Invtypes::Model()->findByPk($row->attributes()->outputTypeID); //Create a new asset $asset = new Assets(); $asset->characterID = $character->characterID; $asset->locationID = $row->attributes()->installedItemLocationID; $asset->typeID = $row->attributes()->outputTypeID; $asset->quantity = $row->attributes()->runs; $asset->flag = 4; $asset->singleton = 0; $asset->containerID = 0; $asset->locationName = $this->getLocationName($row->attributes()->installedItemLocationID); $asset->typeName = $typeID->typeName; $asset->groupID = $typeID->groupID; $asset->save(); } // Update the job row with the new data from CCP $jobRow->jobID = $row->attributes()->jobID; $jobRow->assemblyLineID = $row->attributes()->assemblyLineID; $jobRow->containerID = $row->attributes()->containerID; $jobRow->installedItemID = $row->attributes()->installedItemID; $jobRow->installedItemLocationID = $row->attributes()->installedItemLocationID; $jobRow->installedItemQuantity = $row->attributes()->installedItemQuantity; $jobRow->installedItemProductivityLevel = $row->attributes()->installedItemProductivityLevel; $jobRow->installedItemMaterialLevel = $row->attributes()->installedItemMaterialLevel; $jobRow->installedItemLicensedProductionRunsRemaining = $row->attributes()->installedItemLicensedProductionRunsRemaining; $jobRow->outputLocationID = $row->attributes()->outputLocationID; $jobRow->installerID = $row->attributes()->installerID; $jobRow->runs = $row->attributes()->runs; $jobRow->licensedProductionRuns = $row->attributes()->licensedProductionRuns; $jobRow->installedInSolarSystemID = $row->attributes()->installedInSolarSystemID; $jobRow->containerLocationID = $row->attributes()->containerLocationID; $jobRow->materialMultiplier = $row->attributes()->materialMultiplier; $jobRow->charMaterialMultiplier = $row->attributes()->charMaterialMultiplier; $jobRow->timeMultiplier = $row->attributes()->timeMultiplier; $jobRow->charTimeMultiplier = $row->attributes()->charTimeMultiplier; $jobRow->installedItemTypeID = $row->attributes()->installedItemTypeID; $jobRow->outputTypeID = $row->attributes()->outputTypeID; $jobRow->containerTypeID = $row->attributes()->containerTypeID; $jobRow->installedItemCopy = $row->attributes()->installedItemCopy; $jobRow->completed = $row->attributes()->completed; $jobRow->completedSuccessfully = $row->attributes()->completedSuccessfully; $jobRow->installedItemFlag = $row->attributes()->installedItemFlag; $jobRow->activityID = $row->attributes()->activityID; $jobRow->completedStatus = $row->attributes()->completedStatus; $jobRow->installTime = $row->attributes()->installTime; $jobRow->outputFlag = $row->attributes()->outputFlag; $jobRow->beginProductionTime = $row->attributes()->beginProductionTime; $jobRow->endProductionTime = $row->attributes()->endProductionTime; $jobRow->pauseProductionTime = $row->attributes()->pauseProductionTime; $jobRow->save(); } //} } } }
public static function test() { return IndustryJobs::model()->findAll(); }
<td style="text-align: left; width: 50px;">Install ME</td> <td style="text-align: left; width: 50px;">Install PE</td> <td style="text-align: left; width: 70px;">Install Runs</td> <td style="text-align: left; width: 70px;">Status</td> <td style="text-align: left width: 80px;">Result</td> <td style="text-align: left width: 80px;">Finish</td> <td style="text-align: left; width: 50px;">End Runs</td> <td style="text-align: left; width: 50px;">End ME</td> </tr> <?php $index = 0; $criteria = new CDbCriteria(); $criteria->order = 'endProductionTime DESC'; $criteria->condition = 'activityID = 8'; $results = IndustryJobs::Model()->findAll($criteria); foreach ($results as $row) { if ($index % 2) { echo "<tr class='odd'>"; } else { echo "<tr>"; } $itemInfo = new CDbCriteria(); $itemInfo->condition = 'typeID=:typeID'; $itemInfo->params = array(':typeID' => $row->outputTypeID); $itemName = Invtypes::Model()->find($itemInfo); //$icon = $this->getIcon($row->blueprintID); //$t2blueprint = $this->findT2Blueprints($row->typeID); $dateNow = date('Y-m-d H:i:s', strtotime("+4 hour")); $dateEnd = $row->endProductionTime; //$dateEnd = date("m-d H:i",strtotime($dateEnd));
foreach ($blueprints as $blueprint) { //$bp = Blueprints::Model()->find('itemID=:itemID',array(':itemID'=>$blueprint->itemID)); $bpcrit = new CDbCriteria(); $bpcrit->condition = 'installedItemID=:itemID AND completed = 1 AND activityID = 3'; $bpcrit->params = array(':itemID' => $blueprint->itemID); $bpcrit->order = 'installTime DESC'; $indJob = IndustryJobs::Model()->find($bpcrit); if ($indJob != NULL) { $blueprint->peLevel = $indJob->runs; $update = true; } $bpcrit = new CDbCriteria(); $bpcrit->condition = 'installedItemID=:itemID AND completed = 1 AND activityID = 4'; $bpcrit->params = array(':itemID' => $blueprint->itemID); $bpcrit->order = 'installTime DESC'; $indJob = IndustryJobs::Model()->find($bpcrit); if ($indJob != NULL) { $blueprint->meLevel = $indJob->runs; $update = true; } if ($update) { $blueprint->save(); } } $index = 0; $criteria = new CDbCriteria(); $criteria->order = 'blueprintID ASC'; $results = Blueprints::Model()->findAll($criteria); foreach ($results as $row) { if ($index % 2) { echo "<tr class='odd'>";