Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Imported From: http://groups.google.com/group/in-portal-dev/browse_thread/thread/0dc2f6487f72107a#

I propose to make category item tag HasAdditionalImages look like this:

Code Block
/**

...

 
 * Allows to detect if item has any additional images available 
 * 
 * @param Array $params 
 * @return string 
 */ 
function HasAdditionalImages($params) 
{ 
    static $cache = null; 

    $object =& $this->getObject($params);

...

 
    /* @var $object kDBList */

...

 

    if (!isset($cache))

...

 { 
        $resource_ids = $object->GetCol('ResourceId');

...

 
        $sql = 'SELECT ImageId, ResourceId 
                FROM ' . $this->Application->getUnitOption('img',

...

 'TableName') .

...

 ' 
                WHERE ResourceId IN (' . implode(',', $resource_ids)

...

 . ') AND DefaultImg != 1 AND Enabled =

...

 1 
                GROUP BY ResourceId'; 
        $cache = $this->Conn->GetCol($sql, 'ResourceId');

...

$resource_id = $object->GetDBField('ResourceId');

...

 

    return array_key_exists($resource_id, $cache) ?

...

 $cache[$resource_id] : false;

...

 
} 

This will allow to check for category item additional images during list
printing list printing without additional sql for each printed category item. 

Related Tasks

Jira Legacy
serverSystem Jira
serverId513b375f-8291-

Best Regards,
http://www.in-portal.com
http://www.alex-time.com
3313-9d9f-704c39b1f915
keyINP-497