/**
* Loads a list of predefined properties for the specicifies parameters, returns an array of Property\Predefined elements
*
* @return array
*/
public function load()
{
$properties = array();
$propertiesData = $this->db->fetchCol("SELECT id FROM properties_predefined" . $this->getCondition() . $this->getOrder() . $this->getOffsetLimit(), $this->model->getConditionVariables());
foreach ($propertiesData as $propertyData) {
$properties[] = Property\Predefined::getById($propertyData);
}
$this->model->setProperties($properties);
return $properties;
}
/**
* Loads a list of predefined properties for the specicifies parameters, returns an array of Property\Predefined elements
*
* @return array
*/
public function load()
{
$properties = array();
$propertiesData = $this->db->fetchAll($this->model->getFilter(), $this->model->getOrder());
foreach ($propertiesData as $propertyData) {
$properties[] = Property\Predefined::getById($propertyData["id"]);
}
$this->model->setProperties($properties);
return $properties;
}
public function propertiesAction()
{
if ($this->getParam("data")) {
$this->checkPermission("predefined_properties");
if ($this->getParam("xaction") == "destroy") {
$data = \Zend_Json::decode($this->getParam("data"));
if (\Pimcore\Tool\Admin::isExtJS6()) {
$id = $data["id"];
} else {
$id = $data;
}
$property = Property\Predefined::getById($id);
$property->delete();
$this->_helper->json(array("success" => true, "data" => array()));
} else {
if ($this->getParam("xaction") == "update") {
$data = \Zend_Json::decode($this->getParam("data"));
// save type
$property = Property\Predefined::getById($data["id"]);
$property->setValues($data);
$property->save();
$this->_helper->json(array("data" => $property, "success" => true));
} else {
if ($this->getParam("xaction") == "create") {
$data = \Zend_Json::decode($this->getParam("data"));
unset($data["id"]);
// save type
$property = Property\Predefined::create();
$property->setValues($data);
$property->save();
$this->_helper->json(array("data" => $property, "success" => true));
}
}
}
} else {
// get list of types
$list = new Property\Predefined\Listing();
$list->setLimit($this->getParam("limit"));
$list->setOffset($this->getParam("start"));
$sortingSettings = \Pimcore\Admin\Helper\QueryParams::extractSortingSettings($this->getAllParams());
if ($sortingSettings['orderKey']) {
$list->setOrderKey($sortingSettings['orderKey']);
$list->setOrder($sortingSettings['order']);
} else {
$list->setOrderKey('name');
}
if ($this->getParam("filter")) {
$list->setCondition("`name` LIKE " . $list->quote("%" . $this->getParam("filter") . "%") . " OR `description` LIKE " . $list->quote("%" . $this->getParam("filter") . "%"));
}
$list->load();
$properties = array();
if (is_array($list->getProperties())) {
foreach ($list->getProperties() as $property) {
$properties[] = $property;
}
}
$this->_helper->json(array("data" => $properties, "success" => true, "total" => $list->getTotalCount()));
}
}
public function propertiesAction()
{
if ($this->getParam("data")) {
$this->checkPermission("predefined_properties");
if ($this->getParam("xaction") == "destroy") {
$data = \Zend_Json::decode($this->getParam("data"));
if (\Pimcore\Tool\Admin::isExtJS6()) {
$id = $data["id"];
} else {
$id = $data;
}
$property = Property\Predefined::getById($id);
$property->delete();
$this->_helper->json(["success" => true, "data" => []]);
} elseif ($this->getParam("xaction") == "update") {
$data = \Zend_Json::decode($this->getParam("data"));
// save type
$property = Property\Predefined::getById($data["id"]);
$property->setValues($data);
$property->save();
$this->_helper->json(["data" => $property, "success" => true]);
} elseif ($this->getParam("xaction") == "create") {
$data = \Zend_Json::decode($this->getParam("data"));
unset($data["id"]);
// save type
$property = Property\Predefined::create();
$property->setValues($data);
$property->save();
$this->_helper->json(["data" => $property, "success" => true]);
}
} else {
// get list of types
$list = new Property\Predefined\Listing();
if ($this->getParam("filter")) {
$filter = $this->getParam("filter");
$list->setFilter(function ($row) use($filter) {
foreach ($row as $value) {
if (strpos($value, $filter) !== false) {
return true;
}
}
return false;
});
}
$list->load();
$properties = [];
if (is_array($list->getProperties())) {
foreach ($list->getProperties() as $property) {
$properties[] = $property;
}
}
$this->_helper->json(["data" => $properties, "success" => true, "total" => $list->getTotalCount()]);
}
}