/** * 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; }