/**
* Load all assets for the given material.
*
* @param integer $materialId
*
* @return \self
*/
public static function loadListMaterial($materialId)
{
$sql = '
SELECT `materialAssetId`
FROM materialAssets
WHERE `materialId` = ' . \sqlval($materialId) . '
AND !deleted
ORDER BY percentage
';
$materialAssetIds = query($sql, true);
$obj = new self();
if (empty($materialAssetIds)) {
return $obj;
}
$list = array();
foreach ($materialAssetIds as $materialAsset) {
$list[$materialAsset['materialAssetId']] = \Model\MaterialAsset::loadById($materialAsset['materialAssetId']);
}
$obj->setList($list);
return $obj;
}
/**
* Load the materials for the blueprint.
*
* @return void
*/
public function loadMaterials()
{
$sql = '
SELECT
`materialId`,
`materialAssetId`,
percentage,
talent
FROM materialsToBlueprints
WHERE `blueprintId` = ' . \sqlval($this->blueprintId) . '
AND !deleted
';
$materialIds = query($sql, true);
$list = array();
foreach ($materialIds as $material) {
$list[$material['materialId']] = array('material' => \Model\Material::loadById($material['materialId']), 'materialAsset' => \Model\MaterialAsset::loadById($material['materialAssetId']), 'percentage' => intval($material['percentage']), 'talent' => $material['talent']);
}
$this->materialList = $list;
}
