/**
* Load all available materials.
*
* @return \self
*/
public static function loadList()
{
$sql = '
SELECT `materialId`
FROM materials
WHERE !deleted
ORDER BY `name`
';
$materialIds = query($sql, true);
$obj = new self();
if (empty($materialIds)) {
return $obj;
}
$list = array();
foreach ($materialIds as $material) {
$list[$material['materialId']] = \Model\Material::loadById($material['materialId']);
}
$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;
}
