public static function getFilteredCatalogTagList($nb_catalog, $q = null, $fields = null, $order = null, $offset = 0, $num_items = 0)
    {
        $nb_catalog_id = nb_getMixedValue($nbu_customer, NABU_CATALOG_FIELD_ID);
        if (is_numeric($nb_catalog_id)) {
            $fields_part = nb_prefixFieldList(CNabuCatalogTagBase::getStorageName(), $fields, false, true, '`');
            $order_part = nb_prefixFieldList(CNabuCatalogTagBase::getStorageName(), $fields, false, false, '`');
        
            if ($num_items !== 0) {
                $limit_part = ($offset > 0 ? $offset . ', ' : '') . $num_items;
            } else {
                $limit_part = false;
            }
        
            $nb_item_list = CNabuEngine::getEngine()->getMainDB()->getQueryAsArray(
                "select " . ($fields_part ? $fields_part . ' ' : '* ')
                . 'from nb_catalog_tag '
               . 'where ' . NABU_CATALOG_FIELD_ID . '=%catalog_id$d '
                . ($order_part ? "order by $order_part " : '')
                . ($limit_part ? "limit $limit_part" : ''),
                array(
                    'catalog_id' => $nb_catalog_id
                )
            );
        } else {
            $nb_item_list = null;
        }
        
        return $nb_item_list;
    }
public static function getFilteredCatalogTagList($nb_catalog, $q = null, $fields = null, $order = null, $offset = 0, $num_items = 0)
    {
        $nb_catalog_id = nb_getMixedValue($nbu_customer, NABU_CATALOG_FIELD_ID);
        if (is_numeric($nb_catalog_id)) {
            $fields_part = nb_prefixFieldList(CNabuCatalogTagBase::getStorageName(), $fields, false, true, '`');
            $order_part = nb_prefixFieldList(CNabuCatalogTagBase::getStorageName(), $fields, false, false, '`');
        
            if ($num_items !== 0) {
                $limit_part = ($offset > 0 ? $offset . ', ' : '') . $num_items;
            } else {
                $limit_part = false;
            }
        
            $nb_item_list = CNabuEngine::getEngine()->getMainDB()->getQueryAsArray(
                "select " . ($fields_part ? $fields_part . ' ' : '* ')
                . 'from nb_catalog_tag '
               . 'where ' . NABU_CATALOG_FIELD_ID . '=%catalog_id$d '
                . ($order_part ? "order by $order_part " : '')
                . ($limit_part ? "limit $limit_part" : ''),
                array(
                    'catalog_id' => $nb_catalog_id
                )
            );
        } else {
            $nb_item_list = null;
        }
        
        return $nb_item_list;
    }
public static function getFilteredCatalogTagList ( $ nb_catalog , $ q = null , $ fields = null , $ order = null , $ offset = 0 , $ num_items = 0 ) { $ nb_catalog_id = nb_getMixedValue ( $ nbu_customer , NABU_CATALOG_FIELD_ID ) ; if ( is_numeric ( $ nb_catalog_id ) ) { $ fields_part = nb_prefixFieldList ( CNabuCatalogTagBase :: getStorageName ( ) , $ fields , false , true , '`' ) ; $ order_part = nb_prefixFieldList ( CNabuCatalogTagBase :: getStorageName ( ) , $ fields , false , false , '`' ) ; if ( $ num_items !== 0 ) { $ limit_part = ( $ offset > 0 ? $ offset . ', ' : '' ) . $ num_items ; } else { $ limit_part = false ; } $ nb_item_list = CNabuEngine :: getEngine ( ) -> getMainDB ( ) -> getQueryAsArray ( "select " . ( $ fields_part ? $ fields_part . ' ' : '* ' ) . 'from nb_catalog_tag ' . 'where ' . NABU_CATALOG_FIELD_ID . '=%catalog_id$d ' . ( $ order_part ? "order by $order_part " : '' ) . ( $ limit_part ? "limit $limit_part" : '' ) , array ( 'catalog_id' => $ nb_catalog_id ) ) ; } else { $ nb_item_list = null ; } return $ nb_item_list ; }
Gets a filtered list of Catalog Tag instances represented as an array. Params allows the capability of select a
subset of fields, order by concrete fields, or truncate the list by a number of rows starting in an offset.
@throws \nabu\core\exceptions\ENabuCoreException Raises an exception if $fields or $order have invalid values.
@param mixed $nb_catalog Catalog instance, object containing a Catalog Id field or an Id.
@param string $q Query string to filter results using a context index.
@param string|array $fields List of fields to put in the results.
@param string|array $order List of fields to order the results. Each field can be suffixed with "ASC" or "DESC"
to determine the short order
@param int $offset Offset of first row in the results having the first row at offset 0.
@param int $num_items Number of continue rows to get as maximum in the results.
@return array Returns an array with all rows found using the criteria.
Gets a filtered list of Catalog Tag instances represented as an array . Params allows the capability of select a subset of fields order by concrete fields or truncate the list by a number of rows starting in an offset .