Changeset 1532:f6c9584b4677 for inc/core

Timestamp:

08/23/13 13:16:14 (12 years ago)

Author:

Nicolas <nikrou77@…>

Branch:

default

Message:

Fix issue #1535 : Allow categories to be ordered by drag and drop
Need to close isse #655 : duplicated

Location:

inc/core

Files:

• class.dc.blog.php (modified) (1 diff)
• class.dc.categories.php (modified) (1 diff)

inc/core/class.dc.blog.php

@@ -555 +555 @@
           $this->triggerBlog();
      }
+
+        /**
+        Set category position
+
+        @param  id              <b>integer</b>          Category ID
+        @param  left            <b>integer</b>          Category ID before
+        @param  right           <b>integer</b>          Category ID after
+        */
+        public function updCategoryPosition($id,$left,$right)
+        {
+                $this->categories()->updatePosition($id,$left,$right);
+                $this->triggerBlog();
+        }
      
      /**

inc/core/class.dc.categories.php

@@ -188 +188 @@
      }
      
+        public function updatePosition($id,$left,$right)
+        {
+                $sql = 'UPDATE '.$this->table.' SET '
+                        .$this->f_left.' = '.$left.', '
+                        .$this->f_right.' = '.$right
+                        .' WHERE '.$this->f_id .' = '.(integer) $id
+                        .$this->getCondition();
+
+                $this->con->begin();
+                try {
+                        $this->con->execute($sql);
+                        $this->con->commit();
+                } catch (Exception $e) {
+                        $this->con->rollback();
+                        throw $e;
+                }
+        }
+
      public function deleteNode($node,$keep_children=true)
      {