PHP PHPWS_DB::setLimit方法代码示例

 public function loadFeeds()
 {
     $db = new PHPWS_DB('phpws_key');
     $db->addWhere('module', $this->module);
     $db->addWhere('active', 1);
     $db->addWhere('restricted', 0);
     $db->addWhere('show_after', time(), '<');
     $db->addWhere('hide_after', time(), '>');
     $db->addOrder('create_date desc');
     // rss limit is 15
     $db->setLimit('15');
     $result = $db->getObjects('Key');
     if (PHPWS_Error::isError($result)) {
         $this->_feeds = NULL;
         $this->_error = $result;
         return $result;
     } else {
         $this->_feeds = $result;
         return TRUE;
     }
 }

 /**
  * Gets random page from the database
  *
  * @author Greg Meiste <greg.meiste+github@gmail.com>
  */
 function random()
 {
     $db = new PHPWS_DB('wiki_pages');
     $db->addOrder('random');
     $db->setLimit(1);
     $db->addColumn('title');
     $result = $db->select('col');
     if (!PHPWS_Error::logIfError($result) && $result != NULL) {
         PHPWS_Core::reroute(PHPWS_Text::linkAddress('wiki', array('page' => $result[0])));
     }
     PHPWS_Core::reroute(PHPWS_Text::linkAddress('wiki'));
 }

 public function loadDefaultSchedule()
 {
     $sch_id = PHPWS_Settings::get('calendar', 'public_schedule');
     if ($sch_id > 0) {
         $this->schedule = new Calendar_Schedule((int) $sch_id);
     } elseif ($sch_id == -1) {
         $this->schedule = new Calendar_Schedule();
     } else {
         $db = new PHPWS_DB('calendar_schedule');
         $db->addColumn('id');
         $db->addWhere('public', 1);
         $db->setLimit(1);
         $id = $db->select('one');
         if (PHPWS_Error::isError($id)) {
             PHPWS_Error::log($id);
             return;
         }
         if (empty($id)) {
             $id = -1;
         }
         PHPWS_Settings::set('calendar', 'public_schedule', $id);
         PHPWS_Settings::save('calendar');
     }
 }

 public static function autoForward()
 {
     $current_url = PHPWS_Core::getCurrentUrl();
     if (preg_match('@pagesmith/\\d+@', $current_url)) {
         $page_name = str_replace('/', ':', $current_url);
         $db = new PHPWS_DB('access_shortcuts');
         $db->addColumn('keyword');
         $db->addWhere('url', $page_name);
         $db->setLimit(1);
         $keyword = $db->select('one');
         if (!empty($keyword)) {
             PHPWS_Core::reroute($keyword);
             exit;
         }
     }
 }

 public function viewImage($id, $view_folder = true)
 {
     Layout::addStyle('filecabinet');
     PHPWS_Core::initModClass('filecabinet', 'Image.php');
     $image = new PHPWS_Image($id);
     $folder = new Folder($image->folder_id);
     if (!$folder->allow()) {
         $content = dgettext('filecabinet', 'Sorry, the file you requested is off limits.');
         Layout::add($content);
         return;
     }
     $tpl['TITLE'] = $image->title;
     if ($image->width > FC_MAX_IMAGE_POPUP_WIDTH || $image->height > FC_MAX_IMAGE_POPUP_HEIGHT) {
         if (FC_MAX_IMAGE_POPUP_WIDTH < FC_MAX_IMAGE_POPUP_HEIGHT) {
             $ratio = FC_MAX_IMAGE_POPUP_WIDTH / $image->width;
             $image->width = FC_MAX_IMAGE_POPUP_WIDTH;
             $image->height = $image->height * $ratio;
         } else {
             $ratio = FC_MAX_IMAGE_POPUP_HEIGHT / $image->height;
             $image->height = FC_MAX_IMAGE_POPUP_HEIGHT;
             $image->width = $image->width * $ratio;
         }
         $tpl['IMAGE'] = sprintf('<a href="%s">%s</a>', $image->getPath(), $image->getTag());
     } else {
         $tpl['IMAGE'] = $image->getTag();
     }
     $tpl['DESCRIPTION'] = $image->getDescription();
     $tpl['CLOSE'] = javascript('close_window');
     if ($view_folder && $folder->public_folder) {
         $db = new PHPWS_DB('images');
         $db->setLimit(1);
         $db->addWhere('folder_id', $image->folder_id);
         $db->addWhere('title', $image->title, '>');
         $db->addOrder('title');
         $next_img = $db->getObjects('PHPWS_Image');
         if (!empty($next_img)) {
             $next_link = Icon::show('next', dgettext('filecabinet', 'Next image'));
             $tpl['NEXT'] = sprintf('<a id="next-link" href="%s%s">%s</a>', PHPWS_Core::getHomeHttp(), $next_img[0]->popupAddress(), $next_link);
         }
         $db->resetWhere();
         $db->resetOrder();
         $db->addWhere('folder_id', $image->folder_id);
         $db->addWhere('title', $image->title, '<');
         $db->addOrder('title desc');
         $prev_img = $db->getObjects('PHPWS_Image');
         if (!empty($prev_img)) {
             $prev_link = Icon::show('previous', dgettext('filecabinet', 'Previous image'));
             $tpl['PREV'] = sprintf('<a id="prev-link" href="%s%s">%s</a>', PHPWS_Core::getHomeHttp(), $prev_img[0]->popupAddress(), $prev_link);
         }
     }
     $content = PHPWS_Template::process($tpl, 'filecabinet', 'image_view.tpl');
     Layout::nakedDisplay($content);
 }

 /**
  * Loads the report instance for the last execution performed.
  * The loaded object will contain a null ID if the report has
  * never been executed. Returns true/false on success/failure.
  *
  * @throws DatabaseException
  * @return boolean
  */
 public function loadLastExec()
 {
     $db = new PHPWS_DB('hms_report');
     $db->addWhere('report', $this->getReportClassName());
     $db->addWhere('completed_timestamp', 'NULL', 'IS NOT');
     $db->addOrder('completed_timestamp DESC');
     $db->setLimit(1);
     $result = $db->loadObject($this->report);
     if (PHPWS_Error::logIfError($result)) {
         throw new DatabaseException($result->toString());
     }
     return true;
 }

 public static function whatsnewBlock()
 {
     if (PHPWS_Settings::get('whatsnew', 'cache_timeout') > 0) {
         $cache_key = 'whatsnew_cache_key';
         $content = PHPWS_Cache::get($cache_key, PHPWS_Settings::get('whatsnew', 'cache_timeout'));
         if (!empty($content)) {
             return $content;
         }
     }
     $link = null;
     $summary = null;
     $date = null;
     $module_name = null;
     $exclude = unserialize(PHPWS_Settings::get('whatsnew', 'exclude'));
     $db = new PHPWS_DB('phpws_key');
     $db->addJoin('left', 'phpws_key', 'modules', 'module', 'title');
     $db->addWhere('active', 1);
     $db->addWhere('restricted', 0);
     if ($exclude) {
         foreach ($exclude as $module) {
             $db->addWhere('module', $module, '!=');
         }
     }
     $db->addOrder('update_date desc');
     $db->setLimit(PHPWS_Settings::get('whatsnew', 'qty_items'));
     $db->setIndexBy('id');
     $db->addColumn('phpws_key.url');
     $db->addColumn('phpws_key.title');
     $db->addColumn('phpws_key.summary');
     $db->addColumn('phpws_key.update_date');
     $db->addColumn('modules.title', null, 'module_title');
     $db->addColumn('modules.proper_name');
     //        $db->setTestMode();
     $result = $db->select();
     $tpl['TITLE'] = PHPWS_Text::parseOutput(PHPWS_Settings::get('whatsnew', 'title'));
     $tpl['TEXT'] = PHPWS_Text::parseOutput(PHPWS_Settings::get('whatsnew', 'text'));
     if (!PHPWS_Error::logIfError($result) && !empty($result)) {
         foreach ($result as $item) {
             $link = '<a href="' . $item['url'] . '">' . $item['title'] . '</a>';
             if (PHPWS_Settings::get('whatsnew', 'show_summaries')) {
                 $summary = PHPWS_Text::parseOutput($item['summary']);
             }
             if (PHPWS_Settings::get('whatsnew', 'show_dates')) {
                 $date = strftime(WHATSNEW_DATE_FORMAT, $item['update_date']);
             }
             if (PHPWS_Settings::get('whatsnew', 'show_source_modules')) {
                 $module_name = dgettext($item['module_title'], PHPWS_Text::parseOutput($item['proper_name']));
             }
             $tpl['new-items'][] = array('LINK' => $link, 'SUMMARY' => $summary, 'DATE' => $date, 'MODULE_NAME' => $module_name);
         }
     } else {
         $tpl['new-items'][] = array('LINK' => dgettext('whatsnew', 'Sorry, no results'));
     }
     $content = PHPWS_Template::process($tpl, 'whatsnew', 'block.tpl');
     if (PHPWS_Settings::get('whatsnew', 'cache_timeout') > 0 && !Current_User::isLogged() && !Current_User::allow('whatsnew')) {
         PHPWS_Cache::save($cache_key, $content);
     }
     return $content;
 }

 public function lightbox()
 {
     javascript('lightbox');
     $message = null;
     PHPWS_Core::initModClass('filecabinet', 'Image.php');
     $folder = new Folder($this->file_id);
     if (!$folder->public_folder) {
         if (!Current_User::allow('filecabinet')) {
             return null;
         } else {
             $message = dgettext('filecabinet', 'Folder is private. Slideshow not available');
         }
     }
     $db = new PHPWS_DB('images');
     $db->addWhere('folder_id', $this->file_id);
     if ($this->num_visible < 99) {
         $db->addOrder('rand');
         $db->setLimit($this->num_visible);
     }
     $result = $db->getObjects('PHPWS_Image');
     if (PHPWS_Error::logIfError($result) || !$result) {
         return dgettext('filecabinet', 'Folder missing image files.');
     } else {
         foreach ($result as $image) {
             $img = sprintf('<a title="%s" href="%s">%s</a>', $image->getTitle(), $image->getPath(), $image->getThumbnail());
             $tpl['thumbnails'][] = array('IMAGE' => $img);
         }
         if ($this->vertical) {
             $tpl_file = 'lightbox_vert.tpl';
         } else {
             $tpl_file = 'lightbox_horz.tpl';
         }
         if ($message) {
             $tpl['MESSAGE'] = $message;
         }
         return PHPWS_Template::process($tpl, 'filecabinet', $tpl_file);
     }
 }

 public static function isEnabledForStudent(ApplicationFeatureRegistration $feature, $term, Student $student)
 {
     $db = new PHPWS_DB('hms_application_feature');
     $db->addWhere('name', $feature->getName());
     $db->addWhere('term', $term);
     $db->setLimit(1);
     $result = $db->select('row');
     if (PHPWS_Error::logIfError($result)) {
         throw new DatabaseException($result->toString());
     }
     if (empty($result) || is_null($result)) {
         return false;
     }
     if (!$feature->showForStudent($student, $term)) {
         return false;
     }
     if ($result['enabled'] == 0) {
         return false;
     }
     if (!is_null($result['start_date']) && time() < $result['start_date']) {
         return false;
     }
     if (!is_null($result['end_date']) && time() > $result['end_date']) {
         return false;
     }
     return true;
 }

 public function newProperties()
 {
     \PHPWS_Core::initModClass('properties', 'Property.php');
     $db = new \PHPWS_DB('properties');
     $db->addOrder('created desc');
     $db->setLimit('5');
     $properties = $db->getObjects('Properties\\Property');
     if (empty($properties)) {
         return null;
     }
     foreach ($properties as $prop) {
         $new_properties[] = array('NAME' => $prop->getViewLink());
     }
     return $new_properties;
 }

 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');
 }

 public function delete()
 {
     $db = new \PHPWS_DB('prop_photo');
     $db->addWhere('id', $this->id);
     $result = $db->delete();
     if (\PHPWS_Error::isError($result)) {
         \PHPWS_Error::log($result);
         return;
     }
     @unlink($this->path);
     @unlink(Photo::thumbnailPath($this->path));
     // if deleted pick is main pic, add new main
     if ($this->main_pic) {
         $db->reset();
         $db->addWhere('pid', $this->pid);
         $db->addValue('main_pic', 1);
         $db->setLimit(1);
         $db->update();
     }
 }