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'>";
