/**
* 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;
}
/**
* Remove a material.
*
* @param \Model\Material $material
*
* @return void
*/
protected function removeMaterial($material)
{
$material->remove();
$this->doRender = false;
$this->echoAjaxResponse(array('ok' => true));
}
<?php
/**
* Add a new material.
*
* @package ajax
* @author friend8 <*****@*****.**>
* @license https://www.gnu.org/licenses/lgpl.html LGPLv3
*/
require_once __DIR__ . '/../lib/system/config.default.php';
require_once __DIR__ . '/../lib/system/util/mysql.php';
$response = \Model\Material::create($_POST['data']);
echo json_encode(array('ok' => $response));
/**
* 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;
}
