/**
  * Test the reorder method.
  *
  * @return  void
  *
  * @since   12.3
  */
 public function testReorder()
 {
     $this->object->load(array('id1' => 25, 'id2' => 51));
     $this->object->ordering = 25;
     $this->object->store();
     $object2 = new TableDbTestComposite(TestCaseDatabase::$driver);
     $object2->load(array('id1' => 25, 'id2' => 51));
     $this->assertEquals(25, $object2->ordering, 'Preconditions');
     $this->object->reorder();
     $object2->load(array('id1' => 25, 'id2' => 51));
     $this->assertEquals(2, $object2->ordering, 'Elements did not get reordered');
 }
Ejemplo n.º 2
0
 function reorder($where = '')
 {
     parent::reorder('option_id = ' . $this->_db->Quote($this->option_id));
 }
Ejemplo n.º 3
0
 /**
  * Prepare and sanitise the table data prior to saving.
  *
  * @param   JTable  $table  A JTable object.
  *
  * @return  void
  *
  * @since   1.6
  */
 protected function prepareTable($table)
 {
     // Set the publish date to now
     $db = $this->getDbo();
     if ($table->state == 1 && (int) $table->publish_up == 0) {
         $table->publish_up = JFactory::getDate()->toSql();
     }
     if ($table->state == 1 && intval($table->publish_down) == 0) {
         $table->publish_down = $db->getNullDate();
     }
     // Increment the content version number.
     $table->version++;
     // Reorder the articles within the category so the new article is first
     if (empty($table->id)) {
         $table->reorder('catid = ' . (int) $table->catid . ' AND state >= 0');
     }
 }
Ejemplo n.º 4
0
 /**
  * Method to set new item ordering as first or last.
  * 
  * @param   JTable  $table      Item table to save.
  * @param   string  $position   'first' or other are last.
  *
  * @return  type    
  */
 public function setOrderPosition($table, $position = null)
 {
     if ($position == 'first') {
         if (!$table->ordering) {
             $table->reorder('catid = ' . (int) $table->catid . ' AND published >= 0');
         }
     } else {
         // Set ordering to the last item if not set
         if (empty($table->ordering)) {
             $db = JFactory::getDbo();
             $db->setQuery('SELECT MAX(ordering) FROM #__' . $this->component . '_' . $this->list_name);
             $max = $db->loadResult();
             $table->ordering = $max + 1;
         }
     }
 }
Ejemplo n.º 5
0
 function reorder()
 {
     parent::reorder('product_id = ' . $this->_db->Quote($this->product_id));
 }
Ejemplo n.º 6
0
 /**
  * Prepare and sanitise the table data prior to saving.
  *
  * @param   JTable  $table  A JTable object.
  *
  * @return  void
  *
  * @since   1.6
  */
 protected function prepareTable($table)
 {
     // Reorder the articles within the category so the new article is first
     if (empty($table->id)) {
         $table->reorder('enabled >= 1');
     }
 }