[Summary view] [Print] [Text view]

   1  <?php
   2  
   3  /*

   4   * Limb PHP Framework

   5   *

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

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

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

   9   */
  10  
  11  lmb_require('limb/active_record/src/lmbActiveRecord.class.php');
  12  
  13  /**

  14   * class lmbCmsDocument.

  15   *

  16   * @package cms

  17   * @version $Id$

  18   */
  19  class lmbCmsDocument extends lmbActiveRecord
  20  {
  21    protected $_db_table_name = 'document';
  22  
  23    protected $_lazy_attributes = array('content');
  24  
  25    protected $_has_one = array('node' => array('field' => 'node_id',
  26                                                'class' => 'lmbCmsNode'));
  27  
  28    function _createValidator()
  29    {
  30      $validator = new lmbValidator();
  31      $validator->addRequiredRule('content');
  32      return $validator;
  33    }
  34  
  35    static function findKidsForParent($parent_id, $conn = null)
  36    {
  37      if(!$parent_id)
  38        $parent_id = 0;
  39  
  40      $sql = 'SELECT document.* '.
  41             ' FROM document LEFT JOIN node ON node.id = document.node_id '.
  42             ' WHERE node.parent_id = '. $parent_id;
  43  
  44      return lmbActiveRecord :: findBySql('lmbCmsDocument', $sql, $conn);
  45    }
  46  
  47    function getPublishedKids()
  48    {
  49      $sql = 'SELECT document.* '.
  50             ' FROM document LEFT JOIN node ON node.object_id = document.id '.
  51             ' WHERE node.parent_id = '. $this->getNode()->id .
  52             ' AND document.is_published = 1';
  53  
  54      return lmbActiveRecord :: findBySql('lmbCmsDocument', $sql, $this->_db_conn);
  55    }
  56  }
  57  
  58  ?>