/**
* @param Object_Concrete $object
* @return array
*/
public function load(Object_Concrete $object)
{
$fieldDef = $object->getClass()->getFieldDefinition($this->model->getFieldname());
$values = array();
foreach ($fieldDef->getAllowedTypes() as $type) {
try {
$definition = Object_Objectbrick_Definition::getByKey($type);
} catch (Exception $e) {
continue;
}
$tableName = $definition->getTableName($object->getClass(), false);
try {
$results = $this->db->fetchAll("SELECT * FROM " . $tableName . " WHERE o_id = ? AND fieldname = ?", array($object->getId(), $this->model->getFieldname()));
} catch (Exception $e) {
$results = array();
}
$allRelations = $this->db->fetchAll("SELECT * FROM object_relations_" . $object->getO_classId() . " WHERE src_id = ? AND ownertype = 'objectbrick' AND ownername = ?", array($object->getO_id(), $this->model->getFieldname()));
$fieldDefinitions = $definition->getFieldDefinitions();
$brickClass = "Object_Objectbrick_Data_" . ucfirst($type);
foreach ($results as $result) {
$brick = new $brickClass($object);
$brick->setFieldname($result["fieldname"]);
$brick->setObject($object);
foreach ($fieldDefinitions as $key => $fd) {
/*if ($fd->isRelationType()) {
$relations = array();
foreach ($allRelations as $relation) {
if ($relation["fieldname"] == $key) {
$relations[] = $relation;
}
}
$brick->setValue( $key, $fd->getDataFromResource($relations));
}*/
if (method_exists($fd, "load")) {
// datafield has it's own loader
$value = $fd->load($brick);
if ($value === 0 || !empty($value)) {
$brick->setValue($key, $value);
}
} else {
if (is_array($fd->getColumnType())) {
$multidata = array();
foreach ($fd->getColumnType() as $fkey => $fvalue) {
$multidata[$key . "__" . $fkey] = $result[$key . "__" . $fkey];
}
$brick->setValue($key, $fd->getDataFromResource($multidata));
} else {
$brick->setValue($key, $fd->getDataFromResource($result[$key]));
}
}
}
$setter = "set" . ucfirst($type);
$this->model->{$setter}($brick);
$values[] = $brick;
}
}
return $values;
}
/**
* @param Object_Concrete|Object_Fieldcollection_Data_Abstract|Object_Localizedfield $object
* @return null | array
*/
public function load($object, $params = array())
{
$db = Pimcore_Resource::get();
$data = null;
if ($object instanceof Object_Concrete) {
if (!method_exists($this, "getLazyLoading") or !$this->getLazyLoading() or $params["force"]) {
$relations = $db->fetchAll("SELECT * FROM object_relations_" . $object->getClassId() . " WHERE src_id = ? AND fieldname = ? AND ownertype = 'object'", array($object->getO_id(), $this->getName()));
} else {
return null;
}
} else {
if ($object instanceof Object_Fieldcollection_Data_Abstract) {
$relations = $db->fetchAll("SELECT * FROM object_relations_" . $object->getObject()->getClassId() . " WHERE src_id = ? AND fieldname = ? AND ownertype = 'fieldcollection' AND ownername = ? AND position = ?", array($object->getObject()->getId(), $this->getName(), $object->getFieldname(), $object->getIndex()));
} else {
if ($object instanceof Object_Localizedfield) {
$relations = $db->fetchAll("SELECT * FROM object_relations_" . $object->getObject()->getClassId() . " WHERE src_id = ? AND fieldname = ? AND ownertype = 'localizedfield' AND ownername = 'localizedfield' AND position = ?", array($object->getObject()->getId(), $this->getName(), $params["language"]));
} else {
if ($object instanceof Object_Objectbrick_Data_Abstract) {
$relations = $db->fetchAll("SELECT * FROM object_relations_" . $object->getObject()->getClassId() . " WHERE src_id = ? AND fieldname = ? AND ownertype = 'objectbrick' AND ownername = ? AND position = ?", array($object->getObject()->getId(), $this->getName(), $object->getFieldname(), $object->getType()));
// THIS IS KIND A HACK: it's necessary because of this bug PIMCORE-1454 and therefore cannot be removed
if (count($relations) < 1) {
$relations = $db->fetchAll("SELECT * FROM object_relations_" . $object->getObject()->getClassId() . " WHERE src_id = ? AND fieldname = ? AND ownertype = 'objectbrick' AND ownername = ? AND (position IS NULL OR position = '')", array($object->getObject()->getId(), $this->getName(), $object->getFieldname()));
}
// HACK END
}
}
}
}
// using PHP sorting to order the relations, because "ORDER BY index ASC" in the queries above will cause a
// filesort in MySQL which is extremly slow especially when there are millions of relations in the database
usort($relations, function ($a, $b) {
if ($a["index"] == $b["index"]) {
return 0;
}
return $a["index"] < $b["index"] ? -1 : 1;
});
$data = $this->getDataFromResource($relations);
return $data;
}
/**
* @param Object_Concrete|Object_Fieldcollection_Data_Abstract|Object_Localizedfield $object
* @return null | array
*/
public function load($object, $params = array())
{
$db = Pimcore_Resource::get();
if ($object instanceof Object_Concrete) {
if (!method_exists($this, "getLazyLoading") or !$this->getLazyLoading() or $params["force"]) {
$relations = $db->fetchAll("SELECT * FROM object_relations_" . $object->getClassId() . " WHERE src_id = ? AND fieldname = ? AND ownertype = 'object' ORDER BY `index` ASC", array($object->getO_id(), $this->getName()));
return $this->getDataFromResource($relations);
} else {
return null;
}
} else {
if ($object instanceof Object_Fieldcollection_Data_Abstract) {
$relations = $db->fetchAll("SELECT * FROM object_relations_" . $object->getObject()->getClassId() . " WHERE src_id = ? AND fieldname = ? AND ownertype = 'fieldcollection' AND ownername = ? AND position = ? ORDER BY `index` ASC", array($object->getObject()->getId(), $this->getName(), $object->getFieldname(), $object->getIndex()));
return $this->getDataFromResource($relations);
} else {
if ($object instanceof Object_Localizedfield) {
$relations = $db->fetchAll("SELECT * FROM object_relations_" . $object->getObject()->getClassId() . " WHERE src_id = ? AND fieldname = ? AND ownertype = 'localizedfield' AND ownername = 'localizedfield' AND position = ? ORDER BY `index` ASC", array($object->getObject()->getId(), $this->getName(), $params["language"]));
return $this->getDataFromResource($relations);
} else {
if ($object instanceof Object_Objectbrick_Data_Abstract) {
$relations = $db->fetchAll("SELECT * FROM object_relations_" . $object->getObject()->getClassId() . " WHERE src_id = ? AND fieldname = ? AND ownertype = 'objectbrick' AND ownername = ? ORDER BY `index` ASC", array($object->getObject()->getId(), $this->getName(), $object->getFieldname()));
return $this->getDataFromResource($relations);
}
}
}
}
}
