Changeset 2566:9bf417837888 for inc/core/class.dc.categories.php

Timestamp:

11/17/13 20:25:53 (12 years ago)

Author:

franck <carnet.franck.paul@…>

Branch:

2.6

Children:

2567:6c11245cbf04, 2568:61c67a7d17fa

Message:

Add some people in CREDITS, remove trailing spaces and tabs.

File:

• inc/core/class.dc.categories.php (modified) (32 diffs)

inc/core/class.dc.categories.php

@@ -22 +22 @@
      protected $f_right = 'cat_rgt';
      protected $f_id = 'cat_id';
-     
+
      protected $core;
      protected $blog_id;
-     
+
      public function __construct($core)
      {
@@ -34 +34 @@
           $this->add_condition = array('blog_id' => "'".$this->con->escape($this->blog_id)."'");
      }
-     
+
      public function getChildren($start=0,$id=null,$sort='asc',$fields=array())
      {
@@ -40 +40 @@
           return parent::getChildren($start,$id,$sort,$fields);
      }
-     
+
      public function getParents($id,$fields=array())
      {
@@ -46 +46 @@
           return parent::getParents($id,$fields);
      }
-     
+
      public function getParent($id,$fields=array())
      {
@@ -57 +57 @@
 {
      protected $con;
-     
+
      protected $table;
      protected $f_left;
      protected $f_right;
      protected $f_id;
-     
+
      protected $add_condition = array();
-     
+
      protected $parents;
-     
+
      public function __construct($con)
      {
           $this->con =& $con;
      }
-     
+
      public function getChildren($start=0,$id=null,$sort='asc',$fields=array())
      {
           $fields = count($fields) > 0 ? ', C2.'.implode(', C2.',$fields) : '';
-          
+
           $sql = 'SELECT C2.'.$this->f_id.', C2.'.$this->f_left.', C2.'.$this->f_right.', COUNT(C1.'.$this->f_id.') AS level '
-          . $fields.' '  
+          . $fields.' '
           . 'FROM '.$this->table.' AS C1, '.$this->table.' AS C2 %s '
           . 'WHERE C2.'.$this->f_left.' BETWEEN C1.'.$this->f_left.' AND C1.'.$this->f_right.' '
@@ -86 +86 @@
           . ' %s '
           . 'ORDER BY C2.'.$this->f_left.' '.($sort == 'asc' ? 'ASC' : 'DESC').' ';
-          
+
           $from = $where = '';
           if ($start > 0) {
@@ -93 +93 @@
                $where .= $this->getCondition('AND','C3.');
           }
-          
+
           $having = '';
           if ($id !== null) {
                $having = ' HAVING C2.'.$this->f_id.' = '.(integer) $id;
           }
-          
+
           $sql = sprintf($sql,$from,$where,$having);
-          
+
           return $this->con->select($sql);
      }
-     
+
      public function getParents($id,$fields=array())
      {
           $fields = count($fields) > 0 ? ', C1.'.implode(', C1.',$fields) : '';
-          
+
           return $this->con->select(
                'SELECT C1.'.$this->f_id.' '.$fields.' '
@@ -119 +119 @@
           );
      }
-     
+
      public function getParent($id,$fields=array())
      {
           $fields = count($fields) > 0 ? ', C1.'.implode(', C1.',$fields) : '';
-          
+
           return $this->con->select(
                'SELECT C1.'.$this->f_id.' '.$fields.' '
@@ -136 +136 @@
           );
      }
-     
+
      /* ------------------------------------------------
       * Tree manipulations
@@ -145 +145 @@
                throw new Exception('Invalid data block');
           }
-          
+
           if (is_array($data))
           {
@@ -155 +155 @@
                unset($D);
           }
-          
+
           # We want to put it at the end
           $this->con->writeLock($this->table);
@@ -162 +162 @@
                $rs = $this->con->select('SELECT MAX('.$this->f_id.') as n_id FROM '.$this->table);
                $id = $rs->n_id;
-               
+
                $rs = $this->con->select(
                     'SELECT MAX('.$this->f_right.') as n_r '.
@@ -169 +169 @@
                );
                $last = $rs->n_r == 0 ? 1 : $rs->n_r;
-               
+
                $data->{$this->f_id} = $id+1;
                $data->{$this->f_left} = $last+1;
                $data->{$this->f_right} = $last+2;
-               
+
                $data->insert();
                $this->con->unlock();
@@ -187 +187 @@
           }
      }
-     
+
         public function updatePosition($id,$left,$right)
         {
@@ -209 +209 @@
      {
           $node = (integer) $node;
-          
+
           $rs = $this->getChildren(0,$node);
           if ($rs->isEmpty()) {
@@ -216 +216 @@
           $node_left = (integer) $rs->{$this->f_left};
           $node_right = (integer) $rs->{$this->f_right};
-          
+
           try
           {
                $this->con->begin();
-               
+
                if ($keep_children)
                {
                     $this->con->execute('DELETE FROM '.$this->table.' WHERE '.$this->f_id.' = '.$node);
-                    
+
                     $sql = 'UPDATE '.$this->table.' SET '
                     . $this->f_right.' = CASE '
@@ -242 +242 @@
                     . 'WHERE '.$this->f_right.' > '.$node_left
                     . $this->getCondition();
-                    
+
                     $this->con->execute($sql);
                }
@@ -248 +248 @@
                {
                     $this->con->execute('DELETE FROM '.$this->table.' WHERE '.$this->f_left.' BETWEEN '.$node_left.' AND '.$node_right);
-                    
+
                     $node_delta = $node_right - $node_left + 1;
                     $sql = 'UPDATE '.$this->table.' SET '
@@ -264 +264 @@
                     . $this->getCondition();
                }
-               
+
                $this->con->commit();
           }
@@ -273 +273 @@
           }
      }
-     
+
      public function resetOrder()
      {
@@ -282 +282 @@
                .'ORDER BY '.$this->f_left.' ASC '
           );
-          
+
           $lft = 2;
           $this->con->begin();
@@ -304 +304 @@
           }
      }
-     
+
      public function setNodeParent($node,$target=0)
      {
@@ -312 +312 @@
           $node = (integer) $node;
           $target = (integer) $target;
-          
+
           $rs = $this->getChildren(0,$node);
           if ($rs->isEmpty()) {
@@ -320 +320 @@
           $node_right = (integer) $rs->{$this->f_right};
           $node_level = (integer) $rs->level;
-          
+
           if ($target > 0)
           {
@@ -336 +336 @@
           $target_right = (integer) $rs->{$this->f_right};
           $target_level = (integer) $rs->level;
-          
+
           if ($node_left == $target_left
                || ($target_left >= $node_left && $target_left <= $node_right)
@@ -344 +344 @@
                throw new Exception('Cannot move tree');
           }
-          
+
           if ($target_left < $node_left && $target_right > $node_right && $target_level < $node_level -1)
           {
@@ -405 +405 @@
                .    'OR '.$this->f_right.' BETWEEN '.$node_left.' AND '.$target_right.')';
           }
-          
+
           $sql .= ' '.$this->getCondition();
-          
+
           $this->con->execute($sql);
      }
-     
+
      public function setNodePosition($nodeA,$nodeB,$position='after')
      {
           $nodeA = (integer) $nodeA;
           $nodeB = (integer) $nodeB;
-          
+
           $rs = $this->getChildren(0,$nodeA);
           if ($rs->isEmpty()) {
@@ -423 +423 @@
           $A_right = $rs->{$this->f_right};
           $A_level = $rs->level;
-          
+
           $rs = $this->getChildren(0,$nodeB);
           if ($rs->isEmpty()) {
@@ -431 +431 @@
           $B_right = $rs->{$this->f_right};
           $B_level = $rs->level;
-          
+
           if ($A_level != $B_level) {
                throw new Exception('Cannot change position');
           }
-          
+
           $rs = $this->getParents($nodeA);
           $parentA = $rs->isEmpty() ? 0 : $rs->{$this->f_id};
           $rs = $this->getParents($nodeB);
           $parentB = $rs->isEmpty() ? 0 : $rs->{$this->f_id};
-          
+
           if ($parentA != $parentB) {
                throw new Exception('Cannot change position');
           }
-          
+
           if ($position == 'before')
           {
@@ -481 +481 @@
                }
           }
-          
+
           $sql .= $this->getCondition();
           $this->con->execute($sql);
      }
-     
+
      protected function getCondition($start='AND',$prefix='')
      {
@@ -491 +491 @@
                return '';
           }
-          
+
           $w = array();
           foreach ($this->add_condition as $c => $n) {
@@ -499 +499 @@
      }
 }
-?>