public function moveDown() { $db = new PHPWS_DB('signup_slots'); $db->addWhere('sheet_id', $this->sheet_id); $db->addColumn('id', null, null, true); $slot_count = $db->select('one'); // If not already at bottom, move down one spot if ($this->s_order != $slot_count) { $db->resetColumns(); $db->addWhere('s_order', $this->s_order + 1); $db->addValue('s_order', $this->s_order); $db->update(); $this->s_order++; $this->save(); } }
public static function getEntries(PHPWS_DB $db, $limit, $offset = 0) { $db->resetColumns(); $db->setLimit($limit, $offset); $db->addOrder('sticky desc'); $db->addOrder('publish_date desc'); $db->loadClass('blog', 'Blog.php'); return $db->getObjects('Blog'); }