PHP eZPersistentObject::handleRows方法代码示例

    function fetchClassListByGroups( $groupFilter, $groupFilterType = 'include' )
    {
        $notIn = ( $groupFilterType == 'exclude' );

        if ( is_array( $groupFilter ) && count( $groupFilter ) > 0 )
        {
            $db = eZDB::instance();
            $groupFilter = $db->generateSQLINStatement( $groupFilter, 'ccg.group_id', $notIn );

            $classNameFilter = eZContentClassName::sqlFilter( 'cc' );
            $version = eZContentClass::VERSION_STATUS_DEFINED;

            $sql = "SELECT DISTINCT cc.*, $classNameFilter[nameField] " .
                   "FROM ezcontentclass cc, ezcontentclass_classgroup ccg, $classNameFilter[from] " .
                   "WHERE cc.version = $version" .
                   "      AND cc.id = ccg.contentclass_id" .
                   "      AND $groupFilter" .
                   "      AND $classNameFilter[where] " .
                   "ORDER BY $classNameFilter[nameField] ASC";

            $rows = $db->arrayQuery( $sql );
            $classes = eZPersistentObject::handleRows( $rows, 'eZContentClass', true );
        }
        else
        {
            $classes = eZContentClass::fetchList( eZContentClass::VERSION_STATUS_DEFINED, true, false, array( 'name' => 'asc' ) );
        }

        return array( 'result' => $classes );
    }

 static function fetchListByOrder($orderID, $asObject = true)
 {
     $db = eZDB::instance();
     $orderID = (int) $orderID;
     $rows = $db->arrayQuery("SELECT ezorder_status_history.*, ezorder_status.name AS status_name " . "FROM ezorder_status_history, ezorder_status " . "WHERE order_id = {$orderID} AND" . "      ezorder_status.status_id = ezorder_status_history.status_id " . "ORDER BY ezorder_status_history.modified DESC");
     return eZPersistentObject::handleRows($rows, 'eZOrderStatusHistory', $asObject);
 }

 function canCreateClassList($asObject = false, $includeFilter = true, $groupList = false, $fetchID = false)
 {
     $ini = eZINI::instance();
     $groupArray = array();
     $languageCodeList = eZContentLanguage::fetchLocaleList();
     $allowedLanguages = array('*' => array());
     $user = eZUser::currentUser();
     $accessResult = $user->hasAccessTo('content', 'create');
     $accessWord = $accessResult['accessWord'];
     $classIDArray = array();
     $classList = array();
     $fetchAll = false;
     if ($accessWord == 'yes') {
         $fetchAll = true;
         $allowedLanguages['*'] = $languageCodeList;
     } else {
         if ($accessWord == 'no') {
             // Cannot create any objects, return empty list.
             return $classList;
         } else {
             foreach ($accessResult['policies'] as $policy) {
                 $policyArray = $this->classListFromPolicy($policy, $languageCodeList);
                 if (empty($policyArray)) {
                     continue;
                 }
                 // Wildcard on all classes
                 if ($policyArray['classes'] == '*') {
                     $fetchAll = true;
                     $allowedLanguages['*'] = array_unique(array_merge($allowedLanguages['*'], $policyArray['language_codes']));
                     // we remove individual class ids that are overriden in all languages by the wildcard (#EZP-20933)
                     foreach ($allowedLanguages as $classId => $classLanguageCodes) {
                         if ($classId == '*') {
                             continue;
                         }
                         if (!count(array_diff($classLanguageCodes, $allowedLanguages['*']))) {
                             unset($allowedLanguages[$classId]);
                         }
                     }
                 } else {
                     if (is_array($policyArray['classes']) && $this->hasCurrentSubtreeLimitation($policy)) {
                         foreach ($policyArray['classes'] as $class) {
                             if (isset($allowedLanguages[$class])) {
                                 $allowedLanguages[$class] = array_unique(array_merge($allowedLanguages[$class], $policyArray['language_codes']));
                             } else {
                                 // we don't add class identifiers that are already covered by the 'all classes' in a language
                                 if (!empty($allowedLanguages['*'])) {
                                     if (!count(array_diff($policyArray['language_codes'], $allowedLanguages['*']))) {
                                         continue;
                                     }
                                 }
                                 $allowedLanguages[$class] = $policyArray['language_codes'];
                             }
                         }
                         $classIDArray = array_merge($classIDArray, array_diff($policyArray['classes'], $classIDArray));
                     }
                 }
             }
         }
     }
     $db = eZDB::instance();
     $filterTableSQL = '';
     $filterSQL = '';
     // Create extra SQL statements for the class group filters.
     if (is_array($groupList)) {
         if (count($groupList) == 0) {
             return $classList;
         }
         $filterTableSQL = ', ezcontentclass_classgroup ccg';
         $filterSQL = " AND" . "      cc.id = ccg.contentclass_id AND" . "      ";
         $filterSQL .= $db->generateSQLINStatement($groupList, 'ccg.group_id', !$includeFilter, true, 'int');
     }
     $classNameFilter = eZContentClassName::sqlFilter('cc');
     if ($fetchAll) {
         // If $asObject is true we fetch all fields in class
         $fields = $asObject ? "cc.*, {$classNameFilter['nameField']}" : "cc.id, {$classNameFilter['nameField']}";
         $rows = $db->arrayQuery("SELECT DISTINCT {$fields} " . "FROM ezcontentclass cc{$filterTableSQL}, {$classNameFilter['from']} " . "WHERE cc.version = " . eZContentClass::VERSION_STATUS_DEFINED . " {$filterSQL} AND {$classNameFilter['where']} " . "ORDER BY {$classNameFilter['nameField']} ASC");
         $classList = eZPersistentObject::handleRows($rows, 'eZContentClass', $asObject);
     } else {
         // If the constrained class list is empty we are not allowed to create any class
         if (count($classIDArray) == 0) {
             return $classList;
         }
         $classIDCondition = $db->generateSQLINStatement($classIDArray, 'cc.id');
         // If $asObject is true we fetch all fields in class
         $fields = $asObject ? "cc.*, {$classNameFilter['nameField']}" : "cc.id, {$classNameFilter['nameField']}";
         $rows = $db->arrayQuery("SELECT DISTINCT {$fields} " . "FROM ezcontentclass cc{$filterTableSQL}, {$classNameFilter['from']} " . "WHERE {$classIDCondition} AND" . "      cc.version = " . eZContentClass::VERSION_STATUS_DEFINED . " {$filterSQL} AND {$classNameFilter['where']} " . "ORDER BY {$classNameFilter['nameField']} ASC");
         $classList = eZPersistentObject::handleRows($rows, 'eZContentClass', $asObject);
     }
     if ($asObject) {
         foreach ($classList as $key => $class) {
             $id = $class->attribute('id');
             if (isset($allowedLanguages[$id])) {
                 $languageCodes = array_unique(array_merge($allowedLanguages['*'], $allowedLanguages[$id]));
             } else {
                 $languageCodes = $allowedLanguages['*'];
             }
             $classList[$key]->setCanInstantiateLanguages($languageCodes);
         }
     }
     eZDebugSetting::writeDebug('kernel-content-class', $classList, "class list fetched from db");
//.........这里部分代码省略.........

 static function fetchClassList($contentclass_version, $group_id, $asObject = true, $orderByArray = array('name'))
 {
     $versionCond = '';
     $orderByClause = '';
     $group_id = (int) $group_id;
     $classNameSqlFilter = eZContentClassName::sqlEmptyFilter();
     if ($contentclass_version !== null) {
         $contentclass_version = (int) $contentclass_version;
         $versionCond = "AND class_group.contentclass_version='{$contentclass_version}'\n                            AND contentclass.version='{$contentclass_version}'\n";
     }
     if ($orderByArray) {
         foreach (array_keys($orderByArray) as $key) {
             if (strcasecmp($orderByArray[$key], 'name') === 0) {
                 $classNameSqlFilter = eZContentClassName::sqlAppendFilter('contentclass');
                 $orderByArray[$key] = $classNameSqlFilter['orderBy'];
             }
         }
         $orderByClause = 'ORDER BY ' . implode(', ', $orderByArray);
     }
     $db = eZDB::instance();
     $sql = "SELECT contentclass.* {$classNameSqlFilter['nameField']}\n                FROM ezcontentclass  contentclass, ezcontentclass_classgroup class_group {$classNameSqlFilter['from']}\n                WHERE contentclass.id=class_group.contentclass_id\n                {$versionCond}\n                AND class_group.group_id='{$group_id}' {$classNameSqlFilter['where']}\n                {$orderByClause}";
     $rows = $db->arrayQuery($sql);
     return eZPersistentObject::handleRows($rows, "eZContentClass", $asObject);
 }

//.........这里部分代码省略.........
                {
                    continue;
                }
                $classIDArrayPart = $policyArray['classes'];
                $languageCodeArrayPart = $policyArray['language_codes'];
                // No class limitation for this policy AND no previous limitation(s)
                if ( $classIDArrayPart == '*' && empty( $classIDArray ) )
                {
                    $fetchAll = true;
                    $allowedLanguages['*'] = array_unique( array_merge( $allowedLanguages['*'], $languageCodeArrayPart ) );
                }
                else if ( is_array( $classIDArrayPart ) )
                {
                    $fetchAll = false;
                    foreach( $classIDArrayPart as $class )
                    {
                        if ( isset( $allowedLanguages[$class] ) )
                        {
                            $allowedLanguages[$class] = array_unique( array_merge( $allowedLanguages[$class], $languageCodeArrayPart ) );
                        }
                        else
                        {
                            $allowedLanguages[$class] = $languageCodeArrayPart;
                        }
                    }
                    $classIDArray = array_merge( $classIDArray, array_diff( $classIDArrayPart, $classIDArray ) );
                }
            }
        }

        $db = eZDB::instance();

        $filterTableSQL = '';
        $filterSQL = '';
        // Create extra SQL statements for the class group filters.
        if ( is_array( $groupList ) )
        {
            if ( count( $groupList ) == 0 )
            {
                return $classList;
            }

            $filterTableSQL = ', ezcontentclass_classgroup ccg';
            $filterSQL = ( " AND" .
                           "      cc.id = ccg.contentclass_id AND" .
                           "      " );
            $filterSQL .= $db->generateSQLINStatement( $groupList, 'ccg.group_id', !$includeFilter, true, 'int' );
        }

        $classNameFilter = eZContentClassName::sqlFilter( 'cc' );

        if ( $fetchAll )
        {
            // If $asObject is true we fetch all fields in class
            $fields = $asObject ? "cc.*, $classNameFilter[nameField]" : "cc.id, $classNameFilter[nameField]";
            $rows = $db->arrayQuery( "SELECT DISTINCT $fields " .
                                     "FROM ezcontentclass cc$filterTableSQL, $classNameFilter[from] " .
                                     "WHERE cc.version = " . eZContentClass::VERSION_STATUS_DEFINED . " $filterSQL AND $classNameFilter[where] " .
                                     "ORDER BY $classNameFilter[nameField] ASC" );
            $classList = eZPersistentObject::handleRows( $rows, 'eZContentClass', $asObject );
        }
        else
        {
            // If the constrained class list is empty we are not allowed to create any class
            if ( count( $classIDArray ) == 0 )
            {
                return $classList;
            }

            $classIDCondition = $db->generateSQLINStatement( $classIDArray, 'cc.id' );
            // If $asObject is true we fetch all fields in class
            $fields = $asObject ? "cc.*, $classNameFilter[nameField]" : "cc.id, $classNameFilter[nameField]";
            $rows = $db->arrayQuery( "SELECT DISTINCT $fields " .
                                     "FROM ezcontentclass cc$filterTableSQL, $classNameFilter[from] " .
                                     "WHERE $classIDCondition AND" .
                                     "      cc.version = " . eZContentClass::VERSION_STATUS_DEFINED . " $filterSQL AND $classNameFilter[where] " .
                                     "ORDER BY $classNameFilter[nameField] ASC" );
            $classList = eZPersistentObject::handleRows( $rows, 'eZContentClass', $asObject );
        }

        if ( $asObject )
        {
            foreach ( $classList as $key => $class )
            {
                $id = $class->attribute( 'id' );
                if ( isset( $allowedLanguages[$id] ) )
                {
                    $languageCodes = array_unique( array_merge( $allowedLanguages['*'], $allowedLanguages[$id] ) );
                }
                else
                {
                    $languageCodes = $allowedLanguages['*'];
                }
                $classList[$key]->setCanInstantiateLanguages( $languageCodes );
            }
        }

        eZDebugSetting::writeDebug( 'kernel-content-class', $classList, "class list fetched from db" );
        return $classList;
    }

//.........这里部分代码省略.........
         $table = "e" . $i;
         $langMask = trim(eZContentLanguage::languagesSQLFilter($table, 'lang_mask'));
         if ($glob === false && $i == $len - 1) {
             $selects[] = eZURLAliasML::generateFullSelect($table);
         } else {
             $selects[] = eZURLAliasML::generateSelect($table, $i, $len);
         }
         $tables[] = "ezurlalias_ml " . $table;
         $conds[] = eZURLAliasML::generateCond($table, $prevTable, $i, $langMask, $element);
         $prevTable = $table;
         ++$i;
     }
     if ($glob !== false) {
         ++$len;
         $table = "e" . $i;
         $langMask = trim(eZContentLanguage::languagesSQLFilter($table, 'lang_mask'));
         $selects[] = eZURLAliasML::generateFullSelect($table);
         $tables[] = "ezurlalias_ml " . $table;
         $conds[] = eZURLAliasML::generateGlobCond($table, $prevTable, $i, $langMask, $glob);
         $prevTable = $table;
         ++$i;
     }
     $elementOffset = $i - 1;
     $query = "SELECT DISTINCT " . join(", ", $selects) . " FROM " . join(", ", $tables) . " WHERE " . join(" AND ", $conds);
     $pathRows = $db->arrayQuery($query);
     $elements = array();
     if (count($pathRows) > 0) {
         foreach ($pathRows as $pathRow) {
             $redirectLink = false;
             $table = "e" . $elementOffset;
             $element = array('id' => $pathRow[$table . "_id"], 'parent' => $pathRow[$table . "_parent"], 'lang_mask' => $pathRow[$table . "_lang_mask"], 'text' => $pathRow[$table . "_text"], 'action' => $pathRow[$table . "_action"], 'link' => $pathRow[$table . "_link"]);
             $path = array();
             $lastID = false;
             for ($i = 0; $i < $len; ++$i) {
                 $table = "e" . $i;
                 $id = $pathRow[$table . "_id"];
                 $link = $pathRow[$table . "_link"];
                 $path[] = $pathRow[$table . "_text"];
                 if ($link != $id) {
                     // Mark the redirect link
                     $redirectLink = $link;
                     $redirectOffset = $i;
                 }
                 $lastID = $link;
             }
             if ($redirectLink) {
                 $newLinkID = $redirectLink;
                 // Resolve new links until a real element is found.
                 // TODO: Add max redirection count?
                 while ($newLinkID) {
                     $query = "SELECT id, parent, lang_mask, text, link FROM ezurlalias_ml WHERE id={$newLinkID}";
                     $rows = $db->arrayQuery($query);
                     if (count($rows) == 0) {
                         return false;
                     }
                     $newLinkID = false;
                     if ($rows[0]['id'] != $rows[0]['link']) {
                         $newLinkID = (int) $rows[0]['link'];
                     }
                 }
                 $id = (int) $newLinkID;
                 $path = array();
                 // Fetch path 'text' elements of correct parent path
                 while ($id != 0) {
                     $query = "SELECT parent, lang_mask, text FROM ezurlalias_ml WHERE id={$id}";
                     $rows = $db->arrayQuery($query);
                     if (count($rows) == 0) {
                         break;
                     }
                     $result = eZURLAliasML::choosePrioritizedRow($rows);
                     if (!$result) {
                         $result = $rows[0];
                     }
                     $id = (int) $result['parent'];
                     array_unshift($path, $result['text']);
                 }
                 // Fill in end of path elements
                 for ($i = $redirectOffset; $i < $len; ++$i) {
                     $table = "e" . $i;
                     $path[] = $pathRow[$table . "_text"];
                 }
             }
             $element['path'] = implode('/', $path);
             $elements[] = $element;
         }
     }
     $rows = array();
     $ids = array();
     // Discard duplicates
     foreach ($elements as $element) {
         $id = (int) $element['id'];
         if (isset($ids[$id])) {
             continue;
         }
         $ids[$id] = true;
         $rows[] = $element;
     }
     $objectList = eZPersistentObject::handleRows($rows, 'eZURLAliasML', true);
     return $objectList;
 }

 static function fetchListByRelatedContentObject($contentObjectID, $status = eZNewsletter::StatusPublished, $asObject = true)
 {
     $db = eZDB::instance();
     $condSQL = 'object_relations LIKE \'%/' . $db->escapeString($contentObjectID) . '/%\' AND
                 status = \'' . $db->escapeString($status) . '\'';
     $sql = 'SELECT *
             FROM eznewsletter
             WHERE ' . $condSQL;
     $rows = $db->arrayQuery($sql);
     $definition = eZNewsletter::definition();
     $className = $definition['class_name'];
     return eZPersistentObject::handleRows($rows, $className, $asObject);
 }

//.........这里部分代码省略.........
     $def = self::definition();
     $fields = $def["fields"];
     $tables = $def["name"];
     $class_name = $def["class_name"];
     $sqlFieldArray = array('DISTINCT( cjwnl_user.email )', 'cjwnl_user.*');
     $sqlTableArray = array('cjwnl_user');
     $sqlCondArray = array();
     $sqlCondArray[] = 'cjwnl_user.id = cjwnl_subscription.newsletter_user_id';
     $sqlTableArray[] = 'cjwnl_subscription';
     /*    if ( $userStatus )
           {
               $conditions = array( 'status' => (int) $userStatus );
               $sqlCondAndArray[] = 'cjwnl_user.status=' . (int) $userStatus;
           }*/
     //  var_dump( $conditionArray );
     //    $subscriptionListIdArray = $filterArray[ 'cjwnl_subscription.list_contentobject_id' ];
     //    $subscriptionListStatus = $filterArray[ 'cjwnl_subscription.status' ];
     //    $countSubscriptionListIdArray =  count( $subscriptionListIdArray );
     // merge subscription list to filter subscriptions
     /*      if ( $countSubscriptionListIdArray > 0 || $subscriptionListStatus !== false )
             {
                 $sqlTableArray[] = 'cjwnl_subscription';
                 $sqlCondAndArray[] = 'cjwnl_user.id = cjwnl_subscription.newsletter_user_id';
     
                 if ( $subscriptionListStatus )
                 {
                     $sqlCondAndArray[] = 'cjwnl_subscription.status = '. $db->escapeString( $subscriptionListStatus );
                 }
     
                 if (  $countSubscriptionListIdArray > 0 )
                 {
                     $sqlCondAndArray[] = 'cjwnl_subscription.list_contentobject_id '. $db->generateSQLINStatement( $subscriptionListIdArray );
                 }
             }
             */
     //  $sqlCondAndArray[] = 'cjwnl_user.email like "%@%"';
     if ((int) $limit != 0) {
         $limit = array('limit' => $limit, 'offset' => $offset);
     }
     //   $field_filters = array( 'cjwnl_user.id' );
     //   $custom_tables = array( 'cjwnl_subscription ' );
     //   $custom_conds = ' AND cjwnl_user.id = cjwnl_subscription.newsletter_user_id';
     $sqlFieldString = '';
     if (count($sqlFieldArray) > 0) {
         $sqlFieldString = implode(', ', $sqlFieldArray);
     }
     $sqlTableString = '';
     if (count($sqlTableArray) > 0) {
         $sqlTableString = implode(', ', $sqlTableArray);
     }
     foreach ($filterArray as $filter) {
         $sqlCondArray[] = self::filterText($filter);
     }
     //        var_dump( $sqlCondArray );
     $sqlCondAndString = '';
     if (count($sqlCondArray) > 0) {
         $sqlCondAndString = 'WHERE ' . implode("\n AND ", $sqlCondArray) . ' ';
     }
     /*   $sql = 'SELECT COUNT( cjwnl_subscription.id ) as count, cjwnl_user.*
          FROM cjwnl_user, cjwnl_subscription
          WHERE cjwnl_user.id = cjwnl_subscription.newsletter_user_id'
          . $sqlCondAndString
          . ' GROUP BY cjwnl_user.id';*/
     /*    $sql = 'SELECT DISTINCT( cjwnl_user.email ), cjwnl_user.*
                           FROM cjwnl_user, cjwnl_subscription
                           WHERE cjwnl_user.id = cjwnl_subscription.newsletter_user_id'
           . $sqlCondAndString;*/
     $sql = "SELECT {$sqlFieldString}\n                FROM {$sqlTableString}\n                {$sqlCondAndString}";
     //eZPersistentObject::replaceFieldsWithShortNames( $db, $fields, $conditions );
     /*        $conditions['cjwnl_user.email'][0] = '>=';
             $conditions['cjwnl_user.email'][1] = 'fe';
             //$conditions['cjwnl_user.email'] = array( 'like', '.de' );
             $conditions['cjwnl_user.name'] = array( 'like', '%fe%' );
     */
     /*    $conditionText = eZPersistentObject::conditionText( $conditions );
     
             echo $conditionText;*/
     //echo '<hr>';
     //        echo $sql;
     eZDebug::writeDebug(print_r($filterArray, true));
     eZDebug::writeDebug(print_r($sqlCondArray, true));
     eZDebug::writeDebug($sql);
     //$db->arrayQuery( $sql );
     $rows = $db->arrayQuery($sql, $limit);
     $objectList = eZPersistentObject::handleRows($rows, $class_name, $asObject);
     return $objectList;
     /*       $objectList = eZPersistentObject::fetchObjectList(
                             self::definition(),
                             $field_filters,
                             $conds,
                             $sorts,
                             $limit,
                             $asObject,
                             $grouping,
                             $custom_fields,
                             $custom_tables,
                             $custom_conds );
             return $objectList;
     */
 }

//.........这里部分代码省略.........
         $field_array = array_unique(array_intersect($field_filters, array_keys($fields)));
     } else {
         $field_array = array_keys($fields);
     }
     if ($custom_fields !== null and is_array($custom_fields)) {
         foreach ($custom_fields as $custom_field) {
             if (is_array($custom_field)) {
                 $custom_text = $custom_field["operation"];
                 if (isset($custom_field["name"])) {
                     $field_name = $custom_field["name"];
                     $custom_text .= " AS {$field_name}";
                 }
             } else {
                 $custom_text = $custom_field;
             }
             $field_array[] = $custom_text;
         }
     }
     eZPersistentObject::replaceFieldsWithShortNames($db, $fields, $field_array);
     $field_text = '';
     $i = 0;
     foreach ($field_array as $field_item) {
         if ($i % 7 == 0 and $i > 0) {
             $field_text .= ",       ";
         } else {
             if ($i > 0) {
                 $field_text .= ', ';
             }
         }
         $field_text .= $field_item;
         ++$i;
     }
     $where_text = eZPersistentObject::conditionText($conds);
     if ($custom_conds) {
         $where_text .= $custom_conds;
     }
     $sort_text = "";
     if ($sorts !== false and (isset($def["sort"]) or is_array($sorts))) {
         $sort_list = array();
         if (is_array($sorts)) {
             $sort_list = $sorts;
         } else {
             if (isset($def['sort'])) {
                 $sort_list = $def["sort"];
             }
         }
         if (count($sort_list) > 0) {
             $sort_text = " ORDER BY ";
             $i = 0;
             foreach ($sort_list as $sort_id => $sort_type) {
                 if ($i > 0) {
                     $sort_text .= ", ";
                 }
                 if ($sort_type == "desc") {
                     $sort_text .= "{$sort_id} DESC";
                 } else {
                     $sort_text .= "{$sort_id} ASC";
                 }
                 ++$i;
             }
         }
     }
     $grouping_text = "";
     if (isset($def["grouping"]) or is_array($grouping) and count($grouping) > 0) {
         $grouping_list = isset($def["grouping"]) ? $def["grouping"] : array();
         if (is_array($grouping)) {
             $grouping_list = $grouping;
         }
         if (count($grouping_list) > 0) {
             $grouping_text = " GROUP BY ";
             $i = 0;
             foreach ($grouping_list as $grouping_id) {
                 if ($i > 0) {
                     $grouping_text .= ", ";
                 }
                 $grouping_text .= "{$grouping_id}";
                 ++$i;
             }
         }
     }
     $db_params = array();
     if (is_array($limit)) {
         if (isset($limit["offset"])) {
             $db_params["offset"] = $limit["offset"];
         }
         if (isset($limit['limit'])) {
             $db_params["limit"] = $limit["limit"];
         } else {
             $db_params["limit"] = $limit["length"];
         }
     }
     $sqlText = "SELECT {$field_text}\n                    FROM   {$tables}" . $where_text . $grouping_text . $sort_text;
     $rows = $db->arrayQuery($sqlText, $db_params);
     // Indicate that a DB error occured.
     if ($rows === false) {
         return null;
     }
     $objectList = eZPersistentObject::handleRows($rows, $class_name, $asObject);
     return $objectList;
 }

 /**
  * Fetch all Newsletter user with extended field
  * whith option to Filter data
  *
  *
  * @param array $filterArray condtions which will be combined with 'AND'
  * @param integer $limit
  * @param integer $offset
  * @param boolean $asObject
  * @return array with CjwNewsletterUser objects
  */
 static function fetchByFilter($filterInternalArray, $filterExternalArray, $limit = 50, $offset = 0, $asObject = true, $isCount = false)
 {
     //  var_dump( $filterArray );
     /*
     
              -- alle Frauen
     -- zw 30 und 40 Jahre
     -- die 'sport' aboniert haben
     -- plz bereich 9xxxx
     
     -- SELECT count( cjwnl_subscription.id )
     SELECT cjwnl_subscription.*
     FROM cjwnl_user, cjwnl_subscription
     -- , clubuser
     WHERE cjwnl_user.id = cjwnl_subscription.newsletter_user_id
     -- AND cjwnl_user.external_user_id = clubuser.id
     AND cjwnl_subscription.list_contentobject_id IN ( '109' )
     -- AND cjwnl_user.email like '%@%gmx.de'
     
     -- AND clubuser_optin.name = 'Oldie 95 Newsletter'
     -- AND clubuser.anrede = 'Frau'
     AND cjwnl_user.salutation = 2
     
     -- filter auf externe tabellen nicht cjwnl
     -- nur nutzen wenn ein externer Filter ausgewählt wurde
     AND EXISTS (
         SELECT clubuser.id AS external_user_id
         -- , clubuser.*
         FROM clubuser_optin, clubuser_optin_relation, clubuser
         WHERE clubuser.id = clubuser_optin_relation.clubuserid
         AND clubuser_optin_relation.optinid = clubuser_optin.id
     
         AND cjwnl_user.external_user_id = clubuser.id
     
         -- AND clubuser_optin.name = 'Oldie 95 Newsletter'
         -- AND clubuser.anrede = 'Frau'
         -- AND cjwnl_user.salutation = 2
     
         -- age 30 - 40
         AND clubuser.geburtsdatum <= DATE_SUB(curdate(), INTERVAL 30 YEAR)
         AND clubuser.geburtsdatum >= DATE_SUB(curdate(), INTERVAL 40 YEAR)
         -- optin sport (35)
         -- AND clubuser_optin.name = 'sport'
          AND clubuser_optin.id = 35
         -- plz 9x
          AND clubuser.plz like '9%'
     
     );
     */
     $db = eZDB::instance();
     $field_filters = null;
     $conditions = null;
     $sorts = null;
     //   $limit = null;
     //   $asObject = true;
     $grouping = false;
     $custom_fields = null;
     $custom_tables = null;
     $custom_conds = null;
     $def = self::definition();
     $fields = $def["fields"];
     $tables = $def["name"];
     $class_name = $def["class_name"];
     if ((int) $limit != 0) {
         $limit = array('limit' => $limit, 'offset' => $offset);
     }
     $sqlInternal = self::getFilterInternalSql($filterInternalArray);
     $sqlExternalCondAndString = self::getFilterExternalSql($filterExternalArray);
     $sql = "{$sqlInternal}\n                {$sqlExternalCondAndString}";
     eZDebug::writeDebug($sql);
     //$db->arrayQuery( $sql );
     if ($isCount) {
         $rows = $db->arrayQuery($sql);
         return $rows[0]['count'];
     } else {
         $rows = $db->arrayQuery($sql, $limit);
         $objectList = eZPersistentObject::handleRows($rows, $class_name, $asObject);
         return $objectList;
     }
     /*       $objectList = eZPersistentObject::fetchObjectList(
             self::definition(),
             $field_filters,
             $conds,
             $sorts,
             $limit,
             $asObject,
             $grouping,
             $custom_fields,
             $custom_tables,
//.........这里部分代码省略.........

 static public function makeList( $rows )
 {
     if ( !is_array( $rows ) || count( $rows ) == 0 )
         return array();
     $list = array();
     $maxNumberOfLanguages = eZContentLanguage::maxCount();
     foreach ( $rows as $row )
     {
         $row['always_available'] = $row['lang_mask'] % 2;
         $mask = $row['lang_mask'] & ~1;
         for ( $i = 1; $i < $maxNumberOfLanguages; ++$i )
         {
             $newMask = (1 << $i);
             if ( ($newMask & $mask) > 0 )
             {
                 $row['lang_mask'] = (1 << $i);
                 $list[] = $row;
             }
         }
     }
     $objectList = eZPersistentObject::handleRows( $list, 'eZPathElement', true );
     return $objectList;
 }

    /**
     * Returns the next queued item, excluding those for which another version of the same content is being published.
     * @return ezpContentPublishingProcess|false
     */
    private static function getNextItem()
    {
        $pendingStatusValue = ezpContentPublishingProcess::STATUS_PENDING;
        $workingStatusValue = ezpContentPublishingProcess::STATUS_WORKING;
        $sql = <<<SQL
SELECT *
FROM
  ezpublishingqueueprocesses p,
  ezcontentobject_version v
WHERE p.status = {$pendingStatusValue}
  AND p.ezcontentobject_version_id = v.id
  AND v.contentobject_id NOT IN (
    SELECT v.contentobject_id
    FROM ezpublishingqueueprocesses p,
      ezcontentobject_version v
    WHERE
      p.ezcontentobject_version_id = v.id
      AND p.status = {$workingStatusValue}
  )
ORDER BY p.created, p.ezcontentobject_version_id ASC
SQL;
        $db = eZDB::instance();
        $rows = $db->arrayQuery($sql, array('offset' => 0, 'limit' => 1));
        if (count($rows) == 0) {
            return false;
        }
        /** @var ezpContentPublishingProcess[] $persistentObjects */
        $persistentObjects = eZPersistentObject::handleRows($rows, 'ezpContentPublishingProcess', true);
        return $persistentObjects[0];
    }

 /**
  * Fetches block attached to this zone
  *
  * Only blocks that matches the current enviornment bitmask will be
  * returned.
  *
  * @param int $currentEnvId Int of current enviornment
  * @param string $clusterIdentifier
  * @return MMBlock[] Array
  */
 public function fetchBlocks( $currentEnvId, $clusterIdentifier )
 {
     $db = MMDB::instance();
     $query = "SELECT block.*
         FROM
             mm_block AS block
         JOIN
             mm_homepage_zone_has_block AS join_tbl ON join_tbl.block_id = block.id
         WHERE
             join_tbl.zone_id = {$this->ID}
             AND join_tbl.environment & {$currentEnvId}
             AND join_tbl.cluster_identifier = '{$clusterIdentifier}'
         ORDER BY
             join_tbl.position";
     $rows = $db->arrayQuery( $query );
     if ( $rows && count( $rows ) >= 1 )
         return eZPersistentObject::handleRows( $rows, "MMBlock", true );
 }

    /**
     * Fetches all blocks related to this page.
     *
     * The results are sorted by the 'position' coloumn on the M2M table.
     *
     * @param string $blockType The block type (COLUMN or SCRIPT)
     * @return MMStaticPageBlock[]
     **/
    public function fetchBlocks( $blockType )
    {
        $db = MMDB::instance();
        $blockType = $db->escapeString( $blockType );
        $query = "SELECT block.*
            FROM
                mm_static_page_block AS block
            JOIN
                mm_static_page_has_block AS join_tbl ON join_tbl.static_block_id = block.id
            WHERE
                join_tbl.static_page_id = {$this->ID}
                AND block.block_type = '{$blockType}'
            ORDER BY
                join_tbl.position";

        $rows = $db->arrayQuery( $query );
        if ( $rows && count( $rows ) >= 1 )
            return eZPersistentObject::handleRows( $rows, "MMStaticPageBlock", true );

        return false;
    }

 static function fetchAllClasses($asObject = true, $includeFilter = true, $groupList = false)
 {
     $filterTableSQL = '';
     $filterSQL = '';
     if (is_array($groupList)) {
         $filterTableSQL = ', ezcontentclass_classgroup ccg';
         $filterSQL = " AND" . "      cc.id = ccg.contentclass_id AND" . "      ccg.group_id ";
         $groupText = implode(', ', $groupList);
         if ($includeFilter) {
             $filterSQL .= "IN ( {$groupText} )";
         } else {
             $filterSQL .= "NOT IN ( {$groupText} )";
         }
     }
     $classNameFilter = eZContentClassName::sqlFilter('cc');
     $classList = array();
     $db = eZDb::instance();
     // If $asObject is true we fetch all fields in class
     $fields = $asObject ? "cc.*" : "cc.id, {$classNameFilter['nameField']}";
     $rows = $db->arrayQuery("SELECT DISTINCT {$fields} " . "FROM ezcontentclass cc{$filterTableSQL}, {$classNameFilter['from']} " . "WHERE cc.version = " . eZContentClass::VERSION_STATUS_DEFINED . "{$filterSQL} AND {$classNameFilter['where']}" . "ORDER BY {$classNameFilter['nameField']} ASC");
     $classList = eZPersistentObject::handleRows($rows, 'eZContentClass', $asObject);
     return $classList;
 }