コード例 #1
0
ファイル: PagerTest.php プロジェクト: atiarda/bolt
 /**
  * @dataProvider makelinkProvider
  */
 public function testMakelink($expected, $pageArray, $params)
 {
     $app = $this->getApp();
     $_GET = $params;
     $app['request'] = Request::createFromGlobals();
     $pager = new Pager($pageArray, $app);
     $this->assertEquals($expected, $pager->makelink());
 }
コード例 #2
0
ファイル: Log.php プロジェクト: pkdevboxy/site-v20
 public function getActivity($amount = 10, $minlevel = 1)
 {
     $codes = array('save content', 'login', 'logout', 'fixme', 'user');
     $param = Pager::makeParameterId('activity');
     /* @var $query \Symfony\Component\HttpFoundation\ParameterBag */
     $query = $this->app['request']->query;
     $page = $query ? $query->get($param, $query->get('page', 1)) : 1;
     $query = sprintf("SELECT * FROM %s WHERE code IN (?) OR (level >= ?) ORDER BY date DESC", $this->tablename);
     $query = $this->app['db']->getDatabasePlatform()->modifyLimitQuery($query, intval($amount), intval(($page - 1) * $amount));
     $params = array($codes, $minlevel);
     $paramTypes = array(DoctrineConn::PARAM_STR_ARRAY, \PDO::PARAM_INT);
     $stmt = $this->app['db']->executeQuery($query, $params, $paramTypes);
     $rows = $stmt->fetchAll(2);
     // 2 = Query::HYDRATE_COLUMN
     // Set up the pager
     $pagerQuery = sprintf("SELECT count(*) as count FROM %s WHERE code IN (?) OR (level >= ?)", $this->tablename);
     $params = array($codes, $minlevel);
     $paramTypes = array(DoctrineConn::PARAM_STR_ARRAY, \PDO::PARAM_INT);
     $rowcount = $this->app['db']->executeQuery($pagerQuery, $params, $paramTypes)->fetch();
     $pager = array('for' => 'activity', 'count' => $rowcount['count'], 'totalpages' => ceil($rowcount['count'] / $amount), 'current' => $page, 'showing_from' => ($page - 1) * $amount + 1, 'showing_to' => ($page - 1) * $amount + count($rows));
     $this->app['storage']->setPager('activity', $pager);
     return $rows;
 }
コード例 #3
0
ファイル: General.php プロジェクト: Twiebie/bolt
 /**
  * Get the 'latest activity' for the dashboard.
  *
  * @param Request $request
  *
  * @return \Bolt\Response\BoltResponse
  */
 public function latestActivity(Request $request)
 {
     // Test/get page number
     $param = Pager::makeParameterId('activity');
     $page = $request->query ? $request->query->get($param, $request->query->get('page', 1)) : 1;
     $change = $this->app['logger.manager']->getActivity('change', $page, 8);
     $system = $this->app['logger.manager']->getActivity('system', $page, 8, ['context' => ['authentication', 'security']]);
     $response = $this->render('@bolt/components/panel-activity.twig', ['context' => ['change' => $change, 'system' => $system]]);
     $response->setPublic()->setSharedMaxAge(3600);
     return $response;
 }
コード例 #4
0
ファイル: Frontend.php プロジェクト: Johardmeier/bolt
 /**
  * The search result page controller.
  *
  * @param Request $request      The Symfony Request
  * @param array   $contenttypes The content type slug(s) you want to search for
  *
  * @return BoltResponse
  */
 public function search(Request $request, array $contenttypes = null)
 {
     $q = '';
     $context = __FUNCTION__;
     if ($request->query->has('q')) {
         $q = $request->query->get('q');
     } elseif ($request->query->has($context)) {
         $q = $request->query->get($context);
     }
     $q = Input::cleanPostedData($q, false);
     $param = Pager::makeParameterId($context);
     $page = $request->query->get($param, $request->query->get('page', 1));
     $pageSize = $this->getOption('general/search_results_records') ?: ($this->getOption('general/listing_records') ?: 10);
     $offset = ($page - 1) * $pageSize;
     $limit = $pageSize;
     // set-up filters from URL
     $filters = [];
     foreach ($request->query->all() as $key => $value) {
         if (strpos($key, '_') > 0) {
             list($contenttypeslug, $field) = explode('_', $key, 2);
             if (isset($filters[$contenttypeslug])) {
                 $filters[$contenttypeslug][$field] = $value;
             } else {
                 $contenttype = $this->getContentType($contenttypeslug);
                 if (is_array($contenttype)) {
                     $filters[$contenttypeslug] = [$field => $value];
                 }
             }
         }
     }
     if (count($filters) == 0) {
         $filters = null;
     }
     $result = $this->app['storage']->searchContent($q, $contenttypes, $filters, $limit, $offset);
     $pager = ['for' => $context, 'count' => $result['no_of_results'], 'totalpages' => ceil($result['no_of_results'] / $pageSize), 'current' => $page, 'showing_from' => $offset + 1, 'showing_to' => $offset + count($result['results']), 'link' => $this->generateUrl('search', ['q' => $q]) . '&page_search='];
     $this->app['storage']->setPager($context, $pager);
     $globals = ['records' => $result['results'], $context => $result['query']['use_q'], 'searchresult' => $result];
     $template = $this->templateChooser()->search();
     return $this->render($template, [], $globals);
 }
コード例 #5
0
ファイル: Log.php プロジェクト: MenZil-Team/bolt
 /**
  * System log overview route
  *
  * @param Request $request
  *
  * @return \Bolt\Response\BoltResponse|\Symfony\Component\HttpFoundation\RedirectResponse
  */
 public function systemOverview(Request $request)
 {
     $action = $request->query->get('action');
     if ($action == 'clear') {
         $this->manager()->clear('system');
         $this->flashes()->success(Trans::__('The system log has been cleared.'));
         return $this->redirectToRoute('systemlog');
     } elseif ($action == 'trim') {
         $this->manager()->trim('system');
         $this->flashes()->success(Trans::__('The system log has been trimmed.'));
         return $this->redirectToRoute('systemlog');
     }
     // Test/get page number
     $param = Pager::makeParameterId('activity');
     $page = $request->query ? $request->query->get($param, $request->query->get('page', 1)) : 1;
     $options = ['level' => $request->query->get('level'), 'context' => $request->query->get('context')];
     $activity = $this->manager()->getActivity('system', $page, 16, $options);
     return $this->render('@bolt/activity/systemlog.twig', ['entries' => $activity]);
 }
コード例 #6
0
ファイル: Storage.php プロジェクト: realitygaps/site-v20
 /**
  * Decodes contextual page number from current request url if found.
  *
  * @param string $context Pager id/name in url which value we find
  *
  * @return mixed Page number in context
  */
 protected function decodePageParameter($context = '')
 {
     $param = Pager::makeParameterId($context);
     /* @var $query \Symfony\Component\HttpFoundation\ParameterBag */
     $query = $this->app['request']->query;
     $page = $query ? $query->get($param, $query->get('page', 1)) : 1;
     return $page;
 }
コード例 #7
0
ファイル: Storage.php プロジェクト: Cinal/bolt
 /**
  * Decodes contextual page number from current request url if found.
  *
  * @param string $context      Pager id/name in url which value we find
  * @param array  $inParameters
  *
  * @return mixed Page number in context
  * @deprecated Not used in core anymore
  */
 protected function decodePageParameter($context = '', $inParameters = null)
 {
     if (isset($inParameters['page']) && $inParameters['page'] !== null) {
         return $inParameters['page'];
     } else {
         $param = Pager::makeParameterId($context);
         /* @var $query \Symfony\Component\HttpFoundation\ParameterBag */
         $query = $this->app['request']->query;
         $page = $query ? $query->get($param, $query->get('page', 1)) : 1;
     }
     return $page;
 }
コード例 #8
0
ファイル: Frontend.php プロジェクト: atiarda/bolt
 /**
  * Returns an array of the parameters used in getContent for listing pages.
  *
  * @param  Request $request         The Symfony Request
  * @param  string  $contenttypeslug The content type slug
  *
  * @return array                    Parameters to use in getContent
  */
 private function getListingParameters(Request $request, $contenttypeslug)
 {
     $contenttype = $this->getContentType(current(explode('/', $contenttypeslug)));
     // If the contenttype is 'viewless', don't show the listing / record page.
     if (isset($contenttype['viewless']) && $contenttype['viewless'] === true) {
         $this->abort(Response::HTTP_NOT_FOUND, "Page " . $contenttype['slug'] . " not found.");
     }
     // Build the pager
     $pagerid = Pager::makeParameterId($contenttype['slug']);
     $page = $request->query->get($pagerid, $request->query->get('page', 1));
     // Theme value takes precedence over CT & default config
     // @see https://github.com/bolt/bolt/issues/3951
     if (!($amount = $this->getOption('theme/listing_records', false))) {
         $amount = empty($contenttype['listing_records']) ? $this->getOption('general/listing_records') : $contenttype['listing_records'];
     }
     if (!($order = $this->getOption('theme/listing_sort', false))) {
         $order = empty($contenttype['sort']) ? null : $contenttype['sort'];
     }
     // If $order is not set, one of two things can happen: Either we let `getContent()` sort by itself, or we
     // explicitly set it to sort on the general/listing_sort setting.
     if ($order === null) {
         $taxonomies = $this->getOption('taxonomy');
         $hassortorder = false;
         if (!empty($contenttype['taxonomy'])) {
             foreach ($contenttype['taxonomy'] as $contenttypetaxonomy) {
                 if ($taxonomies[$contenttypetaxonomy]['has_sortorder']) {
                     // We have a taxonomy with a sortorder, so we must keep $order = false, in order
                     // to let `getContent()` handle it. We skip the fallback that's a few lines below.
                     $hassortorder = true;
                 }
             }
         }
         if (!$hassortorder) {
             $order = $this->getOption('general/listing_sort');
         }
     }
     return ['limit' => $amount, 'order' => $order, 'page' => $page, 'paging' => true];
 }
コード例 #9
0
ファイル: Frontend.php プロジェクト: aaleksu/bolt_cm
 /**
  * The search result page controller.
  *
  * @param Request            $request      The Symfony Request
  * @param \Silex\Application $app          The application/container
  * @param array              $contenttypes The content type slug(s) you want to search for
  *
  * @return \Twig_Markup
  */
 public function search(Request $request, Silex\Application $app, array $contenttypes = null)
 {
     $q = '';
     $context = __FUNCTION__;
     if ($request->query->has('q')) {
         $q = $request->get('q');
     } elseif ($request->query->has($context)) {
         $q = $request->get($context);
     }
     $q = Input::cleanPostedData($q, false);
     $param = Pager::makeParameterId($context);
     /* @var $query \Symfony\Component\HttpFoundation\ParameterBag */
     $query = $request->query;
     $page = $query ? $query->get($param, $query->get('page', 1)) : 1;
     $config = $app['config'];
     $pageSize = $config->get('general/search_results_records') ?: ($config->get('general/listing_records') ?: 10);
     $offset = ($page - 1) * $pageSize;
     $limit = $pageSize;
     // set-up filters from URL
     $filters = array();
     foreach ($request->query->all() as $key => $value) {
         if (strpos($key, '_') > 0) {
             list($contenttypeslug, $field) = explode('_', $key, 2);
             if (isset($filters[$contenttypeslug])) {
                 $filters[$contenttypeslug][$field] = $value;
             } else {
                 $contenttype = $app['storage']->getContentType($contenttypeslug);
                 if (is_array($contenttype)) {
                     $filters[$contenttypeslug] = array($field => $value);
                 }
             }
         }
     }
     if (count($filters) == 0) {
         $filters = null;
     }
     $result = $app['storage']->searchContent($q, $contenttypes, $filters, $limit, $offset);
     $pager = array('for' => $context, 'count' => $result['no_of_results'], 'totalpages' => ceil($result['no_of_results'] / $pageSize), 'current' => $page, 'showing_from' => $offset + 1, 'showing_to' => $offset + count($result['results']), 'link' => $app['url_generator']->generate('search', array('q' => $q)) . '&page_search=');
     $app['storage']->setPager($context, $pager);
     $app['twig']->addGlobal('records', $result['results']);
     $app['twig']->addGlobal($context, $result['query']['use_q']);
     $app['twig']->addGlobal('searchresult', $result);
     $template = $app['templatechooser']->search();
     return $this->render($app, $template, 'search');
 }
コード例 #10
0
ファイル: Manager.php プロジェクト: aleksabp/bolt
 /**
  * Get a specific activity log.
  *
  * @param string  $log     The log to query.  Either 'change' or 'system'
  * @param integer $amount  Number of results to return
  * @param integer $level
  * @param string  $context
  *
  * @throws \Exception
  *
  * @return array
  */
 public function getActivity($log, $amount = 10, $level = null, $context = null)
 {
     if ($log == 'system') {
         $table = $this->table_system;
     } elseif ($log == 'change') {
         $table = $this->table_change;
     } else {
         throw new \Exception("Invalid log type requested: {$log}");
     }
     try {
         /** @var $reqquery \Symfony\Component\HttpFoundation\ParameterBag */
         $reqquery = $this->app['request']->query;
         // Test/get page number
         $param = Pager::makeParameterId('activity');
         $page = $reqquery ? $reqquery->get($param, $reqquery->get('page', 1)) : 1;
         // Build the base query
         $query = $this->app['db']->createQueryBuilder()->select('*')->from($table)->orderBy('id', 'DESC')->setMaxResults(intval($amount))->setFirstResult(intval(($page - 1) * $amount));
         // Set up optional WHERE clause(s)
         $query = $this->setWhere($query, $level, $context);
         // Get the rows from the database
         $rows = $query->execute()->fetchAll();
         // Find out how many entries we're paging form
         $query = $this->app['db']->createQueryBuilder()->select('COUNT(id) as count')->from($table);
         // Set up optional WHERE clause(s)
         $query = $this->setWhere($query, $level, $context);
         $rowcount = $query->execute()->fetch();
         // Set up the pager
         $pager = array('for' => 'activity', 'count' => $rowcount['count'], 'totalpages' => ceil($rowcount['count'] / $amount), 'current' => $page, 'showing_from' => ($page - 1) * $amount + 1, 'showing_to' => ($page - 1) * $amount + count($rows));
         $this->app['storage']->setPager('activity', $pager);
     } catch (DBALException $e) {
         // Oops. User will get a warning on the dashboard about tables that need to be repaired.
         $rows = array();
     }
     if ($log == 'change') {
         return $this->decodeChangeLog($rows);
     }
     return $rows;
 }
コード例 #11
0
ファイル: Frontend.php プロジェクト: watermelon-pixels/bolt
 public static function taxonomy(Silex\Application $app, $taxonomytype, $slug)
 {
     // First, get some content
     $context = $taxonomytype . '_' . $slug;
     $pagerid = Pager::makeParameterId($context);
     /* @var $query \Symfony\Component\HttpFoundation\ParameterBag */
     $query = $app['request']->query;
     $page = $query->get($pagerid, $query->get('page', 1));
     $amount = $app['config']->get('general/listing_records');
     $order = $app['config']->get('general/listing_sort');
     $content = $app['storage']->getContentByTaxonomy($taxonomytype, $slug, array('limit' => $amount, 'order' => $order, 'page' => $page));
     $taxonomytype = $app['storage']->getTaxonomyType($taxonomytype);
     // No taxonomytype, no possible content..
     if (empty($taxonomytype)) {
         return false;
     } else {
         $taxonomyslug = $taxonomytype['slug'];
     }
     if (!$content) {
         $app->abort(404, "Content for '{$taxonomyslug}/{$slug}' not found.");
     }
     $chosen = 'taxonomy';
     // Set the template based on the (optional) setting in taxonomy.yml, or fall back to default listing template
     if ($app['config']->get('taxonomy/' . $taxonomyslug . '/listing_template')) {
         $template = $app['config']->get('taxonomy/' . $taxonomyslug . '/listing_template');
     } else {
         $template = $app['config']->get('general/listing_template');
     }
     $app['log']->setValue('templatechosen', $app['config']->get('general/theme') . "/{$template} ({$chosen})");
     // Fallback: If file is not OK, show an error page
     $filename = $app['paths']['themepath'] . "/" . $template;
     if (!file_exists($filename) || !is_readable($filename)) {
         $error = sprintf("No template for '%s'-listing defined. Tried to use '%s/%s'.", $taxonomyslug, basename($app['config']->get('general/theme')), $template);
         $app['log']->setValue('templateerror', $error);
         $app->abort(404, $error);
     }
     $name = $slug;
     // Look in taxonomies in 'content', to get a display value for '$slug', perhaps.
     foreach ($content as $record) {
         $flat = \utilphp\util::array_flatten($record->taxonomy);
         $key = $app['paths']['root'] . $taxonomytype['slug'] . '/' . $slug;
         if (isset($flat[$key])) {
             $name = $flat[$key];
         }
         $key = $app['paths']['root'] . $taxonomytype['singular_slug'] . '/' . $slug;
         if (isset($flat[$key])) {
             $name = $flat[$key];
         }
     }
     $app['twig']->addGlobal('records', $content);
     $app['twig']->addGlobal('slug', $name);
     $app['twig']->addGlobal('taxonomy', $app['config']->get('taxonomy/' . $taxonomyslug));
     $app['twig']->addGlobal('taxonomytype', $taxonomyslug);
     return $app['render']->render($template);
 }