Example #1
0
    /**
     * Load a material by ID
     *
     * @param integer $id
     *
     * @return \self
     */
    public static function loadById($id)
    {
        $sql = '
			SELECT
				`materialId`,
				`materialTypeId`,
				`name`,
				additional
			FROM materials
			WHERE `materialId` = ' . \sqlval($id) . '
				AND !deleted
		';
        $material = \query($sql);
        $obj = new self();
        $obj->fill($material);
        $obj->loadMaterialAssets();
        return $obj;
    }