[Summary view] [Print] [Text view]

   1  <?php
   2  /*

   3   * Limb PHP Framework

   4   *

   5   * @link http://limb-project.com

   6   * @copyright  Copyright &copy; 2004-2007 BIT(http://bit-creative.com)

   7   * @license    LGPL http://www.gnu.org/copyleft/lesser.html

   8   */
   9  lmb_require('limb/active_record/src/lmbActiveRecord.class.php');
  10  lmb_require('limb/cms/src/model/lmbCmsImageFileObject.class.php');
  11  lmb_require('limb/cms/src/model/lmbCmsNode.class.php');
  12  
  13  /**

  14   * class lmbCmsImage.

  15   *

  16   * @package cms

  17   * @version $Id: lmbCmsImage.class.php 5998 2007-06-18 12:28:49Z pachanga $

  18   */
  19  class lmbCmsImage extends lmbActiveRecord
  20  {
  21    protected $_has_one = array('original' => array('field' => 'original_id',
  22                                                       'class' => 'lmbCmsImageFileObject'),
  23                                'thumbnail' => array('field' => 'thumbnail_id',
  24                                                       'class' => 'lmbCmsImageFileObject'),
  25                                'icon' => array('field' => 'icon_id',
  26                                                'class' => 'lmbCmsImageFileObject'),
  27                                'node' => array('field' => 'node_id',
  28                                                'class' => 'lmbCmsNode'));
  29  
  30    protected $_db_table_name = 'image';
  31  
  32    protected function _createValidator()
  33    {
  34      $validator = new lmbValidator();
  35      $validator->addRequiredObjectRule('original');
  36      $validator->addRequiredObjectRule('thumbnail');
  37      $validator->addRequiredObjectRule('icon');
  38      return $validator;
  39    }
  40  
  41    static function findForParentNode($parent, $conn = null)
  42    {
  43      $sql = 'SELECT image.* '.
  44             ' FROM image LEFT JOIN node ON node.id = image.node_id '.
  45             ' WHERE node.parent_id = '. $parent->id;
  46  
  47      if(!is_object($conn))
  48        $conn = lmbActiveRecord :: getDefaultConnection();
  49  
  50      $stmt = $conn->newStatement($sql);
  51      return lmbActiveRecord :: decorateRecordSet($stmt->getRecordSet(), 'lmbCmsImage', $conn);
  52    }
  53  }
  54  ?>