/**
* Load all characters for the logged in user.
*
* @return \self
*/
public static function loadList()
{
$sql = '
SELECT `characterId`
FROM characters
WHERE userid = ' . \sqlval($_SESSION['userId']) . '
AND !deleted
';
$characterIds = query($sql, true);
$obj = new self();
if (empty($characterIds)) {
return $obj;
}
$list = array();
foreach ($characterIds as $character) {
$list[$character['characterId']] = \Model\Character::loadById($character['characterId']);
}
$obj->setList($list);
return $obj;
}
/**
* Load all item types.
*
* @return \self
*/
public static function loadList()
{
$sql = '
SELECT `itemTypeId`
FROM itemTypes
WHERE !deleted
ORDER BY `type`, `name`
';
$itemTypeIds = query($sql, true);
$obj = new self();
if (empty($itemTypeIds)) {
return $obj;
}
$list = array();
foreach ($itemTypeIds as $itemType) {
$list[$itemType['itemTypeId']] = \Model\ItemType::loadById($itemType['itemTypeId']);
}
$obj->setList($list);
return $obj;
}
/**
* Load all available techniques.
*
* @return \self
*/
public static function loadList()
{
$sql = '
SELECT `techniqueId`
FROM techniques
WHERE !deleted
ORDER BY `name`
';
$techniqueIds = query($sql, true);
$obj = new self();
if (empty($techniqueIds)) {
return $obj;
}
$list = array();
foreach ($techniqueIds as $technique) {
$list[$technique['techniqueId']] = \Model\Technique::loadById($technique['techniqueId']);
}
$obj->setList($list);
return $obj;
}
/**
* 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 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 all available blueprints for the logged in user.
*
* @return \self
*/
public static function loadList($orderBy = 'name')
{
$sql = '
SELECT `blueprintId`
FROM blueprints
WHERE userid = ' . \sqlval($_SESSION['userId']) . '
AND !deleted
ORDER BY ' . sqlval($orderBy, false) . '
';
$blueprintIds = query($sql, true);
$obj = new self();
if (empty($blueprintIds)) {
return $obj;
}
$list = array();
foreach ($blueprintIds as $blueprint) {
$list[$blueprint['blueprintId']] = \Model\Blueprint::loadById($blueprint['blueprintId']);
}
$obj->setList($list);
return $obj;
}
/**
* Load all craftings for the logged in user.
*
* @param boolean $onlyUnfinished
*
* @return \self
*/
public static function loadList($onlyUnfinished = false)
{
$sql = '
SELECT `craftingId`
FROM craftings
WHERE `userId` = ' . \sqlval($_SESSION['userId']) . '
AND !deleted
' . ($onlyUnfinished ? 'AND !done' : '') . '
ORDER BY done, `name`
';
$craftingIds = query($sql, true);
$obj = new self();
if (empty($craftingIds)) {
return $obj;
}
$list = array();
foreach ($craftingIds as $crafting) {
$list[$crafting['craftingId']] = \Model\Crafting::loadById($crafting['craftingId']);
}
$obj->setList($list);
return $obj;
}
/**
* Load all items.
*
* @return \self
*/
public static function loadList($groupBy = 'itemType')
{
$sql = '
SELECT `itemId`
FROM items
WHERE !deleted
ORDER BY `name`
';
$itemIds = query($sql, true);
$obj = new self();
if (empty($itemIds)) {
return $obj;
}
$list = array();
foreach ($itemIds as $item) {
$itemObject = \Model\Item::loadById($item['itemId']);
if (!is_array($list[$itemObject->getItemType()])) {
$list[$itemObject->getItemType()] = array();
}
$list[$itemObject->getItemType()][$item['itemId']] = $itemObject;
}
$obj->setList($list);
return $obj;
}
/**
* Parse server response properties.
*
* @return \Torann\RelateIQ\Resource\RiqListItem
*/
public static function parseResponse($list, $response)
{
$listItem = new self();
$listItem->id = $response['id'];
$listItem->modifiedDate = $response['modifiedDate'];
$listItem->createdDate = $response['createdDate'];
$listItem->accountId = $response['accountId'];
$listItem->contactIds = $response['contactIds'];
foreach ($response['fieldValues'] as $key => $fieldValue) {
$listItem->fieldValues[$key] = $fieldValue;
}
$listItem->setList($list);
return $listItem;
}
/**
* Add multiple members to this mailinglist.
*
* @param array $members
* @param bool $upsert
*
* @return Mailinglist
*/
public function addMembers($members = [], $upsert = false)
{
$upsert = $upsert ? 'yes' : 'no';
foreach ($members as $key => $member) {
if (!is_string($member)) {
$members[$key] = $this->_parseMemberParams($member);
}
}
$mailinglist = new self();
$mailinglist->setList($this->mailgun(true)->post("lists/{$this->address}/members.json", ['members' => json_encode($members), 'upsert' => $upsert])->http_response_body->list);
return $mailinglist;
}
/**
* Create Hstore by array.
*
* @return Hstore
**/
public static function make($array)
{
$self = new self();
return $self->setList($array);
}
public static function parseResponseObject($list, $response)
{
$listItem = new self();
$listItem->id = $response->id;
$listItem->modifiedDate = $response->modifiedDate;
$listItem->createdDate = $response->createdDate;
$listItem->accountId = $response->accountId;
$listItem->contactIds = $response->contactIds;
foreach ($response->fieldValues as $key => $fieldValue) {
$listItem->fieldValues[$key] = $fieldValue;
}
$listItem->setList($list);
return $listItem;
}
