Пример #1
0
 public function indexAction()
 {
     $this->enableLayout();
     // get a list of news objects and order them by date
     $blogList = new Object\BlogArticle\Listing();
     $blogList->setOrderKey("date");
     $blogList->setOrder("DESC");
     $conditions = [];
     if ($this->getParam("category")) {
         $conditions[] = "categories LIKE " . $blogList->quote("%," . (int) $this->getParam("category") . ",%");
     }
     if ($this->getParam("archive")) {
         $conditions[] = "DATE_FORMAT(FROM_UNIXTIME(date), '%Y-%c') = " . $blogList->quote($this->getParam("archive"));
     }
     if (!empty($conditions)) {
         $blogList->setCondition(implode(" AND ", $conditions));
     }
     $paginator = \Zend_Paginator::factory($blogList);
     $paginator->setCurrentPageNumber($this->getParam('page'));
     $paginator->setItemCountPerPage(5);
     $this->view->articles = $paginator;
     // get all categories
     $categories = Object\BlogCategory::getList();
     // this is an alternative way to get an object list
     $this->view->categories = $categories;
     // archive information, we have to do this in pure SQL
     $db = \Pimcore\Resource::get();
     $ranges = $db->fetchCol("SELECT DATE_FORMAT(FROM_UNIXTIME(date), '%Y-%c') as ranges FROM object_5 GROUP BY DATE_FORMAT(FROM_UNIXTIME(date), '%b-%Y') ORDER BY ranges ASC");
     $this->view->archiveRanges = $ranges;
 }
 /**
  * @param $classId
  * @param null $idField
  * @param null $storetable
  * @param null $querytable
  * @param null $relationtable
  */
 public function __construct($classId, $idField = null, $storetable = null, $querytable = null, $relationtable = null)
 {
     $this->db = \Pimcore\Resource::get();
     $this->fields = array();
     $this->relations = array();
     $this->fieldIds = array();
     $this->deletionFieldIds = array();
     $this->fieldDefinitions = [];
     if ($storetable == null) {
         $this->storetable = self::STORE_TABLE . $classId;
     } else {
         $this->storetable = $storetable;
     }
     if ($querytable == null) {
         $this->querytable = self::QUERY_TABLE . $classId;
     } else {
         $this->querytable = $querytable;
     }
     if ($relationtable == null) {
         $this->relationtable = self::RELATION_TABLE . $classId;
     } else {
         $this->relationtable = $relationtable;
     }
     if ($idField == null) {
         $this->idField = self::ID_FIELD;
     } else {
         $this->idField = $idField;
     }
 }
Пример #3
0
 /**
  *
  */
 public function httpErrorLogCleanup()
 {
     // keep the history for max. 7 days (=> exactly 144h), according to the privacy policy (EU/German Law)
     // it's allowed to store the IP for 7 days for security reasons (DoS, ...)
     $limit = time() - 6 * 86400;
     $db = \Pimcore\Resource::get();
     $db->delete("http_error_log", "date < " . $limit);
 }
Пример #4
0
 public function executeSQL($fileName)
 {
     $db = \Pimcore\Resource::get();
     $file = PIMCORE_PLUGINS_PATH . "/CoreShop/install/sql/{$fileName}.sql";
     $sql = file_get_contents($file);
     $mysqli = $db->getConnection();
     return $mysqli->multi_query($sql);
 }
Пример #5
0
 public function __construct(OnlineShop_Framework_IndexService_Tenant_IConfig $tenantConfig)
 {
     $this->name = $tenantConfig->getTenantName();
     $this->tenantConfig = $tenantConfig;
     $this->columnConfig = $tenantConfig->getAttributeConfig();
     $this->searchColumnConfig = $tenantConfig->getSearchAttributeConfig();
     $this->db = \Pimcore\Resource::get();
 }
 /**
  * Use the register method to register items with the container via the
  * protected $this->container property or the `getContainer` method
  * from the ContainerAwareTrait.
  *
  * @return void
  */
 public function register()
 {
     $container = $this->getContainer();
     $container->singleton(self::SERVICE_DB, function () {
         /** @var \Pimcore\Resource\Wrapper $resource */
         $resource = Resource::get();
         return $resource->getResource();
     });
 }
Пример #7
0
 /**
  * @return \Zend_Db_Adapter_Abstract
  */
 protected function getDb()
 {
     if (!$this->db) {
         // we're using a new mysql connection here to avoid problems with active (nested) transactions
         \Logger::debug("Initialize dedicated MySQL connection for the cache adapter");
         $this->db = Resource::getConnection();
     }
     return $this->db;
 }
Пример #8
0
 /**
  * @return bool|string
  */
 public function getExistingLengths()
 {
     $db = \Pimcore\Resource::get();
     $query = "\n            SELECT length FROM " . OnlineShop_Framework_VoucherService_Token_Resource::TABLE_NAME . "\n            WHERE voucherSeriesId = ?\n            GROUP BY length";
     try {
         return $db->fetchAssoc($query, $this->getId());
     } catch (Exception $e) {
         return false;
     }
 }
 public function showAction()
 {
     $offset = $this->_getParam("start");
     $limit = $this->_getParam("limit");
     $orderby = "ORDER BY id DESC";
     $sortingSettings = \Pimcore\Admin\Helper\QueryParams::extractSortingSettings($this->getAllParams());
     if ($sortingSettings['orderKey']) {
         $orderby = "ORDER BY " . $sortingSettings['orderKey'] . " " . $sortingSettings['order'];
     }
     $queryString = " WHERE 1=1";
     if ($this->_getParam("priority") != "-1" && ($this->_getParam("priority") == "0" || $this->_getParam("priority"))) {
         $queryString .= " AND priority <= " . $this->_getParam("priority");
     } else {
         $queryString .= " AND (priority = 6 OR priority = 5 OR priority = 4 OR priority = 3 OR priority = 2 OR priority = 1 OR priority = 0)";
     }
     if ($this->_getParam("fromDate")) {
         $datetime = $this->_getParam("fromDate");
         if ($this->_getParam("fromTime")) {
             $datetime = substr($datetime, 0, 11) . $this->_getParam("fromTime") . ":00";
         }
         $queryString .= " AND timestamp >= '" . $datetime . "'";
     }
     if ($this->_getParam("toDate")) {
         $datetime = $this->_getParam("toDate");
         if ($this->_getParam("toTime")) {
             $datetime = substr($datetime, 0, 11) . $this->_getParam("toTime") . ":00";
         }
         $queryString .= " AND timestamp <= '" . $datetime . "'";
     }
     if ($this->_getParam("component")) {
         $queryString .= " AND component =  '" . $this->_getParam("component") . "'";
     }
     if ($this->_getParam("relatedobject")) {
         $queryString .= " AND relatedobject = " . $this->_getParam("relatedobject");
     }
     if ($this->_getParam("message")) {
         $queryString .= " AND message like '%" . $this->_getParam("message") . "%'";
     }
     $db = Resource::get();
     $count = $db->fetchCol("SELECT count(*) FROM " . Log\Helper::ERROR_LOG_TABLE_NAME . $queryString);
     $total = $count[0];
     $result = $db->fetchAll("SELECT * FROM " . Log\Helper::ERROR_LOG_TABLE_NAME . $queryString . " {$orderby} LIMIT {$offset}, {$limit}");
     $errorDataList = array();
     if (!empty($result)) {
         foreach ($result as $r) {
             $parts = explode("/", $r['filelink']);
             $filename = $parts[count($parts) - 1];
             $fileobject = str_replace(PIMCORE_DOCUMENT_ROOT, "", $r['fileobject']);
             $errorData = array("id" => $r['id'], "message" => $r['message'], "timestamp" => $r['timestamp'], "priority" => $this->getPriorityName($r['priority']), "filename" => $filename, "fileobject" => $fileobject, "relatedobject" => $r['relatedobject'], "component" => $r['component'], "source" => $r['source']);
             $errorDataList[] = $errorData;
         }
     }
     $results = array("p_totalCount" => $total, "p_results" => $errorDataList);
     $this->_helper->json($results);
 }
 public function updateSubTenantEntries($objectId, $subTenantData, $subObjectId = null)
 {
     $db = \Pimcore\Resource::get();
     $db->delete($this->getTenantRelationTablename(), "o_id = " . $db->quote($subObjectId ? $subObjectId : $objectId));
     if ($subTenantData) {
         //implementation specific tenant get logic
         foreach ($subTenantData as $data) {
             $db->insert($this->getTenantRelationTablename(), $data);
         }
     }
 }
Пример #11
0
 /**
  * @static
  * @return string[]
  */
 public static function getPriorities()
 {
     $priorities = array();
     $priorityNames = array(Zend_Log::DEBUG => "DEBUG", Zend_Log::INFO => "INFO", Zend_Log::NOTICE => "INFO", Zend_Log::WARN => "WARN", Zend_Log::ERR => "ERR", Zend_Log::CRIT => "CRIT", Zend_Log::ALERT => "ALERT", Zend_Log::EMERG => "EMERG");
     $db = Resource::get();
     $priorityNumbers = $db->fetchCol("SELECT priority FROM " . Log\Helper::ERROR_LOG_TABLE_NAME . " WHERE NOT ISNULL(priority) GROUP BY priority;");
     foreach ($priorityNumbers as $priorityNumber) {
         $priorities[$priorityNumber] = $priorityNames[$priorityNumber];
     }
     return $priorities;
 }
Пример #12
0
 public function insertOrUpdateVoucherSeries()
 {
     $db = \Pimcore\Resource::get();
     try {
         $query = 'INSERT INTO ' . OnlineShop_Framework_VoucherService_Token_Resource::TABLE_NAME . '(token,length,voucherSeriesId) VALUES (?,?,?)
                 ON DUPLICATE KEY UPDATE token = ?, length = ?';
         $db->query($query, [trim($this->configuration->getToken()), $this->getFinalTokenLength(), $this->getSeriesId(), trim($this->configuration->getToken()), $this->getFinalTokenLength()]);
     } catch (Exception $e) {
         return ['error' => 'Something went wrong.'];
         //TODO Error
     }
 }
Пример #13
0
    /**
     * @param OnlineShop_Framework_Pricing_IRule $rule
     * @param string                             $field
     *
     * @return mixed
     */
    private function getData(OnlineShop_Framework_Pricing_IRule $rule, $field)
    {
        if (!array_key_exists($rule->getId(), self::$cache)) {
            $query = <<<'SQL'
SELECT 1

    , priceRule.ruleId
	, count(priceRule.o_id) as "soldCount"
	, sum(orderItem.totalPrice) as "salesAmount"

	-- DEBUG INFOS
	, orderItem.oo_id as "orderItem"
	, `order`.orderdate

FROM object_query_%2$d as `order`

    -- ordered products
    JOIN object_relations_%2$d as orderItems
        ON( 1
            AND orderItems.fieldname = "items"
            AND orderItems.src_id = `order`.oo_id
        )

	-- order item
	JOIN object_%1$d as orderItem
		ON ( 1
    	    AND orderItem.o_id = orderItems.dest_id
		)

	-- add active price rules
	JOIN object_collection_PricingRule_%1$d as priceRule
		ON( 1
			AND priceRule.o_id = orderItem.oo_id
			AND priceRule.fieldname = "PricingRules"
			AND priceRule.ruleId = %3$d
		)

WHERE 1
    AND `order`.orderState = "committed"

LIMIT 1
SQL;
            try {
                $query = sprintf($query, \Pimcore\Model\Object\OnlineShopOrderItem::classId(), \Pimcore\Model\Object\OnlineShopOrder::classId(), $rule->getId());
                $conn = \Pimcore\Resource::getConnection();
                self::$cache[$rule->getId()] = $conn->fetchRow($query);
            } catch (Exception $e) {
                Logger::error($e);
            }
        }
        return self::$cache[$rule->getId()][$field];
    }
Пример #14
0
 /**
  * @param \Zend_Controller_Request_Abstract $request
  * @return bool|void
  */
 public function routeShutdown(\Zend_Controller_Request_Abstract $request)
 {
     if (!Tool::useFrontendOutputFilters($request)) {
         return $this->disable();
     }
     $db = \Pimcore\Resource::get();
     $enabled = $db->fetchOne("SELECT id FROM targeting_personas UNION SELECT id FROM targeting_rules LIMIT 1");
     if (!$enabled) {
         return $this->disable();
     }
     if ($request->getParam("document") instanceof Document\Page) {
         $this->document = $request->getParam("document");
     }
 }
Пример #15
0
 /**
  * @param int $duration days
  * @param string|null $seriesId
  * @return bool
  */
 public static function cleanUpStatistics($duration, $seriesId = null)
 {
     $query = "DELETE FROM " . OnlineShop_Framework_VoucherService_Statistic_Resource::TABLE_NAME . " WHERE DAY(DATEDIFF(date, NOW())) >= ?";
     $params[] = $duration;
     if (isset($seriesId)) {
         $query .= " AND voucherSeriesId = ?";
         $params[] = $seriesId;
     }
     $db = \Pimcore\Resource::get();
     try {
         $db->query($query, $params);
         return true;
     } catch (Exception $e) {
         return false;
     }
 }
Пример #16
0
 /**
  * @param $key
  * @param $language
  * @return \Pimcore\Model\Metadata\Predefined
  */
 public static function getByKeyAndLanguage($key, $language)
 {
     $db = \Pimcore\Resource::get();
     $list = new self();
     $condition = "name = " . $db->quote($key);
     if ($language) {
         $condition .= " AND language = " . $db->quote($language);
     } else {
         $condition .= " AND (language = '' OR LANGUAGE IS NULL)";
     }
     $list->setCondition($condition);
     $list = $list->load();
     if ($list) {
         return $list[0];
     }
     return null;
 }
Пример #17
0
 /**
  * @param string $token
  * @param int $usages
  * @return bool
  */
 public static function isUsedToken($token, $usages = 1)
 {
     $db = \Pimcore\Resource::get();
     $query = "SELECT usages, seriesId FROM " . self::TABLE_NAME . " WHERE token = ? ";
     $params[] = $token;
     try {
         $usages['usages'] = $db->fetchOne($query, $params);
         if ($usages > $usages) {
             return $usages['seriesId'];
         } else {
             return false;
         }
         // If an Error occurs the token is defined as used.
     } catch (Exception $e) {
         return true;
     }
 }
Пример #18
0
 /**
  *
  */
 public function writeLog()
 {
     $code = (string) $this->getResponse()->getHttpResponseCode();
     $db = \Pimcore\Resource::get();
     try {
         $uri = $this->getRequest()->getScheme() . "://" . $this->getRequest()->getHttpHost() . $this->getRequest()->getRequestUri();
         $exists = $db->fetchOne("SELECT date FROM http_error_log WHERE uri = ?", $uri);
         if ($exists) {
             $db->query("UPDATE http_error_log SET `count` = `count` + 1, date = ? WHERE uri = ?", [time(), $uri]);
         } else {
             $db->insert("http_error_log", array("uri" => $uri, "code" => (int) $code, "parametersGet" => serialize($_GET), "parametersPost" => serialize($_POST), "cookies" => serialize($_COOKIE), "serverVars" => serialize($_SERVER), "date" => time(), "count" => 1));
         }
     } catch (\Exception $e) {
         \Logger::error("Unable to log http error");
         \Logger::error($e);
     }
 }
Пример #19
0
 /**
  * @return OnlineShop_Framework_ICartItem[]
  */
 public function getSubItems()
 {
     if ($this->subItems == null) {
         $this->subItems = array();
         $itemClass = get_class($this) . "_List";
         $itemList = new $itemClass();
         $db = \Pimcore\Resource::get();
         $itemList->setCondition("cartId = " . $db->quote($this->getCartId()) . " AND parentItemKey = " . $db->quote($this->getItemKey()));
         foreach ($itemList->getCartItems() as $item) {
             if ($item->getProduct() != null) {
                 $this->subItems[] = $item;
             } else {
                 Logger::warn("product " . $item->getProductId() . " not found");
             }
         }
     }
     return $this->subItems;
 }
Пример #20
0
 /**
  * @param $file
  * @throws \Zend_Db_Adapter_Exception
  */
 public function insertDump($file)
 {
     $sql = file_get_contents($file);
     // we have to use the raw connection here otherwise \Zend_Db uses prepared statements, which causes problems with inserts (: placeholders)
     // and mysqli causes troubles because it doesn't support multiple queries
     if ($this->db->getResource() instanceof \Zend_Db_Adapter_Mysqli) {
         $mysqli = $this->db->getConnection();
         $mysqli->multi_query($sql);
         // loop through results, because ->multi_query() is asynchronous
         do {
             if ($result = $mysqli->store_result()) {
                 $mysqli->free_result();
             }
         } while ($mysqli->next_result());
     } else {
         if ($this->db->getResource() instanceof \Zend_Db_Adapter_Pdo_Mysql) {
             $this->db->getConnection()->exec($sql);
         }
     }
     \Pimcore\Resource::reset();
     // set the id of the system user to 0
     $this->db->update("users", array("id" => 0), $this->db->quoteInto("name = ?", "system"));
 }
Пример #21
0
 public function getTranslations($type, $params)
 {
     if (in_array($type, array('website', 'admin'))) {
         $listClass = '\\Pimcore\\Model\\Translation\\' . ucfirst($type) . '\\Listing';
         /**
          * @var $list \Pimcore\Model\Translation\Website\Listing
          */
         $list = new $listClass();
         if ($key = $params['key']) {
             $list->addConditionParam(" `key` LIKE " . \Pimcore\Resource::get()->quote("%" . $key . "%"), '');
         }
         $list->addConditionParam(" `creationDate` >= ? ", $params['creationDateFrom']);
         $list->addConditionParam(" `creationDate` <= ? ", $params['creationDateTill']);
         $list->addConditionParam(" `modificationDate` >= ? ", $params['modificationDateFrom']);
         $list->addConditionParam(" `modificationDate` <= ? ", $params['modificationDateTill']);
         $data = $list->load();
         $result = array();
         foreach ($data as $obj) {
             $result[] = $obj->getForWebserviceExport();
         }
         return $result;
     } else {
         throw new \Exception("Parameter 'type' has to be 'website' or 'admin'");
     }
 }
 *
 * LICENSE
 *
 * This source file is subject to the new BSD license that is bundled
 * with this package in the file LICENSE.txt.
 * It is also available through the world-wide-web at this URL:
 * http://www.pimcore.org/license
 *
 * @copyright  Copyright (c) 2009-2014 pimcore GmbH (http://www.pimcore.org)
 * @license    http://www.pimcore.org/license     New BSD License
 */
chdir(__DIR__);
include_once "startup.php";
use Pimcore\Model\Search;
// clear all data
$db = \Pimcore\Resource::get();
$db->query("TRUNCATE `search_backend_data`;");
$elementsPerLoop = 100;
$types = array("asset", "document", "object");
foreach ($types as $type) {
    $listClassName = "\\Pimcore\\Model\\" . ucfirst($type) . "\\Listing";
    $list = new $listClassName();
    if (method_exists($list, "setUnpublished")) {
        $list->setUnpublished(true);
    }
    $elementsTotal = $list->getTotalCount();
    for ($i = 0; $i < ceil($elementsTotal / $elementsPerLoop); $i++) {
        $list->setLimit($elementsPerLoop);
        $list->setOffset($i * $elementsPerLoop);
        echo "Processing " . $type . ": " . ($list->getOffset() + $elementsPerLoop) . "/" . $elementsTotal . "\n";
        $elements = $list->load();
Пример #23
0
 /**
  * @param $code
  * @return bool
  */
 public static function tokenExists($code)
 {
     $db = \Pimcore\Resource::get();
     $query = "SELECT EXISTS(SELECT id FROM " . self::TABLE_NAME . " WHERE token = ?)";
     $result = $db->fetchOne($query, $code);
     if ($result == 0) {
         return false;
     }
     return true;
 }
 /**
  * @param Object\Concrete $object
  * @return void
  */
 public function delete($object)
 {
     $db = Resource::get();
     $db->delete("object_metadata_" . $object->getClassId(), $db->quoteInto("o_id = ?", $object->getId()) . " AND " . $db->quoteInto("fieldname = ?", $this->getName()));
 }
 private function inquire($type)
 {
     try {
         $condense = $this->getParam("condense");
         $this->checkUserPermission($type . "s");
         if ($this->isPost()) {
             $data = file_get_contents("php://input");
             $idList = explode(',', $data);
         } else {
             if ($this->getParam("ids")) {
                 $idList = explode(',', $this->getParam("ids"));
             } else {
                 $idList = array();
             }
         }
         if ($this->getParam("id")) {
             $idList[] = $this->getParam("id");
         }
         $resultData = array();
         foreach ($idList as $id) {
             $resultData[$id] = 0;
         }
         if ($type == "object") {
             $col = "o_id";
         } else {
             $col = "id";
         }
         $sql = "select " . $col . " from " . $type . "s where " . $col . " IN (" . implode(',', $idList) . ")";
         $result = \Pimcore\Resource::get()->fetchAll($sql);
         foreach ($result as $item) {
             $id = $item[$col];
             if ($condense) {
                 unset($resultData[$id]);
             } else {
                 $resultData[$id] = 1;
             }
         }
         $this->encoder->encode(array("success" => true, "data" => $resultData));
     } catch (\Exception $e) {
         $this->encoder->encode(array("success" => false, "msg" => $e->getMessage()));
     }
 }
Пример #26
0
 /**
  * @param  $value
  * @return string
  */
 public function quote($value, $type = null)
 {
     $db = Resource::get();
     return $db->quote($value, $type);
 }
Пример #27
0
 /**
  * @param $tableDefinitions
  * @param $tableNames
  */
 public static function updateTableDefinitions(&$tableDefinitions, $tableNames)
 {
     if (!is_array($tableDefinitions)) {
         $tableDefinitions = array();
     }
     $db = \Pimcore\Resource::get();
     $tmp = array();
     foreach ($tableNames as $tableName) {
         $tmp[$tableName] = $db->fetchAll("show columns from " . $tableName);
     }
     foreach ($tmp as $tableName => $columns) {
         foreach ($columns as $column) {
             $column["Type"] = strtolower($column["Type"]);
             if (strtolower($column["Null"]) == "yes") {
                 $column["Null"] = "null";
             }
             //                $fieldName = strtolower($column["Field"]);
             $fieldName = $column["Field"];
             $tableDefinitions[$tableName][$fieldName] = $column;
         }
     }
 }
Пример #28
0
 /**
  * @param $filters
  * @param $field
  * @param $drillDownFilters
  * @return array|mixed
  */
 public function getAvailableOptions($filters, $field, $drillDownFilters)
 {
     $db = Resource::get();
     $baseQuery = $this->getBaseQuery($filters, array($field), true, $drillDownFilters, $field);
     $data = array();
     if ($baseQuery) {
         $sql = $baseQuery["data"] . " GROUP BY " . $db->quoteIdentifier($field);
         $data = $db->fetchAll($sql);
     }
     $filteredData = array();
     foreach ($data as $d) {
         if (!empty($d[$field]) || $d[$field] === 0) {
             $filteredData[] = array("value" => $d[$field]);
         }
     }
     return array("data" => array_merge(array(array("value" => null)), $filteredData));
 }
 /**
  * @param null $key
  * @throws \Exception
  */
 public function initResource($key = null)
 {
     $myClass = get_class($this);
     $resource = null;
     if (!$key) {
         // check for a resource in the cache
         if (array_key_exists($myClass, self::$resourceClassCache)) {
             $resource = self::$resourceClassCache[$myClass];
         } else {
             $classes = $this->getParentClasses($myClass);
             foreach ($classes as $class) {
                 $delimiter = "_";
                 // old prefixed class style
                 if (strpos($class, "\\")) {
                     $delimiter = "\\";
                     // that's the new with namespaces
                 }
                 $classParts = explode($delimiter, $class);
                 $length = count($classParts);
                 $className = null;
                 for ($i = 0; $i < $length; $i++) {
                     // check for a general DBMS resource adapter
                     $tmpClassName = implode($delimiter, $classParts) . $delimiter . "Resource";
                     if ($className = $this->determineResourceClass($tmpClassName)) {
                         break;
                     }
                     // this is just for compatibility anymore, this was before the standard way
                     // but as there will not be a specialized implementation anymore eg. Oracle, PostgreSQL, ...
                     // we can move that below the general resource adapter as a fallback
                     $tmpClassName = implode($delimiter, $classParts) . $delimiter . "Resource" . $delimiter . ucfirst(Resource::getType());
                     if ($className = $this->determineResourceClass($tmpClassName)) {
                         break;
                     }
                     array_pop($classParts);
                 }
                 if ($className && $className != "Pimcore\\Resource") {
                     //\Logger::debug("Found resource implementation " . $className . " for " . $myClass);
                     $resource = $className;
                     self::$resourceClassCache[$myClass] = $resource;
                     break;
                 }
             }
         }
     } else {
         // check in cache
         $cacheKey = $myClass . "-" . $key;
         if (array_key_exists($cacheKey, self::$resourceClassCache)) {
             $resource = self::$resourceClassCache[$cacheKey];
         } else {
             $delimiter = "_";
             // old prefixed class style
             if (strpos($key, "\\") !== false) {
                 $delimiter = "\\";
                 // that's the new with namespaces
             }
             // check for a specialized resource adapter for the current DBMS
             $resourceClass = $key . $delimiter . "Resource" . $delimiter . ucfirst(Resource::getType());
             if (!($resource = $this->determineResourceClass($resourceClass))) {
                 $resource = $key . $delimiter . "Resource";
             }
             self::$resourceClassCache[$cacheKey] = $resource;
         }
     }
     if (!$resource) {
         \Logger::critical("No resource implementation found for: " . $myClass);
         throw new \Exception("No resource implementation found for: " . $myClass);
     }
     $resource = "\\" . ltrim($resource, "\\");
     $this->resource = new $resource();
     $this->resource->setModel($this);
     $db = Resource::get();
     $this->resource->configure($db);
     if (method_exists($this->resource, "init")) {
         $this->resource->init();
     }
 }
Пример #30
0
 /**
  * returns sql query statement to filter according to this data types value(s)
  * @param  $value
  * @param  $operator
  * @return string
  *
  */
 public function getFilterCondition($value, $operator)
 {
     $db = \Pimcore\Resource::get();
     $value = $db->quote($value);
     $key = $db->quoteIdentifier($this->name, $this->name);
     return "IFNULL(" . $key . ", 0) = " . $value . " ";
 }