CodeExplorer
You are a developer and looking for Shopware projects?
Apply Now!
getOffset example
return $a;
}
/** * @return array */
public static function castTopicPartition(TopicPartition $c, array $a)
{
$prefix = Caster::PREFIX_VIRTUAL;
$a += [
$prefix.'offset' => $c->getOffset(),
$prefix.'partition' => $c->getPartition(),
$prefix.'topic' => $c->getTopic(),
];
return $a;
}
/** * @return array */
public static function castMessage(Message $c, array $a, Stub $stub, bool $isNested)
{
}
/** * @return array */
public static function castTopicPartition(TopicPartition $c, array $a)
{
$prefix = Caster::PREFIX_VIRTUAL;
$a += [
$prefix.'offset' => $c->getOffset(),
$prefix.'partition' => $c->getPartition(),
$prefix.'topic' => $c->getTopic(),
];
return $a;
}
/** * @return array */
public static function castMessage(Message $c, array $a, Stub $stub, bool $isNested)
{
$this->helper->addFilters($definition, $criteria, $search, $context);
$this->helper->addPostFilters($definition, $criteria, $search, $context);
$this->helper->addQueries($definition, $criteria, $search, $context);
$this->helper->addSortings($definition, $criteria, $search, $context);
$this->helper->addTerm($criteria, $search, $context, $definition);
$search->setSize(self::MAX_LIMIT);
$limit = $criteria->getLimit();
if ($limit !== null) {
$search->setSize($limit);
}
$search->setFrom((int) $criteria->getOffset());
return $search;
}
/** * @return array<string, mixed> */
private function convertSearch(Criteria $criteria, EntityDefinition $definition, Context $context, Search $search): array
{
if (!$criteria->getGroupFields()) {
$array = $search->toArray();
$this->helper->addPostFilters($definition, $criteria, $search, $context);
$this->helper->addQueries($definition, $criteria, $search, $context);
$this->helper->addSortings($definition, $criteria, $search, $context);
$this->helper->addTerm($criteria, $search, $context, $definition);
$search->setSize(self::MAX_LIMIT);
$limit = $criteria->getLimit();
if ($limit !== null) {
$search->setSize($limit);
}
$search->setFrom((int) $criteria->getOffset());
return $search;
}
/** * @return array<string, mixed> */
private function convertSearch(Criteria $criteria, EntityDefinition $definition, Context $context, Search $search): array
{
if (!$criteria->getGroupFields()) {
$array = $search->toArray();
'#default_value' => $this->getItemsPerPage(),
];
}
}
if ($this->isOffsetExposed()) {
$form['offset'] = [
'#type' => 'textfield',
'#size' => 10,
'#maxlength' => 10,
'#title' => $this->options['expose']['offset_label'],
'#default_value' => $this->getOffset(),
];
}
}
public function exposedFormValidate(&$form, FormStateInterface $form_state) {
if (!$form_state->isValueEmpty('offset') && trim($form_state->getValue('offset'))) {
if (!is_numeric($form_state->getValue('offset')) || $form_state->getValue('offset') < 0) {
$form_state->setErrorByName('offset', $this->t('Offset must be a number greater than or equal to 0.'));
}
}
}
];
}
}
if ($this->isOffsetExposed()) {
$form['offset'] = [
'#type' => 'textfield',
'#size' => 10,
'#maxlength' => 10,
'#title' => $this->options['expose']['offset_label'],
'#default_value' => $this->getOffset(),
];
}
}
public function exposedFormValidate(&$form, FormStateInterface $form_state) {
if (!$form_state->isValueEmpty('offset') && trim($form_state->getValue('offset'))) {
if (!is_numeric($form_state->getValue('offset')) || $form_state->getValue('offset') < 0) {
$form_state->setErrorByName('offset', $this->t('Offset must be a number greater than or equal to 0.'));
}
}
}
// Add a pager, initialize, and test.
$view->displayHandlers->get('default')->overrideOption('pager', [
'type' => 'full',
'options' => ['items_per_page' => 10],
]);
$view->initPager();
$this->assertTrue($view->usePager());
// Test setting and getting the offset. $rand = rand();
$view->setOffset($rand);
$this->assertEquals($rand, $view->getOffset());
// Test the getBaseTable() method. $expected = [
'views_test_data' => TRUE,
'#global' => TRUE,
];
$this->assertSame($expected, $view->getBaseTables());
// Test response methods. $this->assertInstanceOf(Response::class, $view->getResponse());
$new_response = new Response();
'type' => 'full',
'options' => ['items_per_page' => 10],
]);
$view->initPager();
$this->assertTrue($view->usePager());
// Test setting and getting the offset. $rand = rand();
$view->setOffset($rand);
$this->assertEquals($rand, $view->getOffset());
// Test the getBaseTable() method. $expected = [
'views_test_data' => TRUE,
'#global' => TRUE,
];
$this->assertSame($expected, $view->getBaseTables());
// Test response methods. $this->assertInstanceOf(Response::class, $view->getResponse());
$new_response = new Response();
'variant.id as __variant_id',
'variant.ordernumber as __variant_ordernumber',
]);
}
foreach ($select as $selection) {
$query->addSelect($selection);
}
$query->addGroupBy('product.id');
if ($criteria->getOffset() !== null) {
$query->setFirstResult($criteria->getOffset());
}
if ($criteria->getLimit() !== null) {
$query->setMaxResults($criteria->getLimit());
}
return $query;
}
/** * {@inheritdoc} * * @throws Exception */
'variant.ordernumber as __variant_ordernumber',
]);
}
foreach ($select as $selection) {
$query->addSelect($selection);
}
$query->addGroupBy('product.id');
if ($criteria->getOffset() !== null) {
$query->setFirstResult($criteria->getOffset());
}
if ($criteria->getLimit() !== null) {
$query->setMaxResults($criteria->getLimit());
}
return $query;
}
/** * {@inheritdoc} * * @throws Exception */
$this->criteria->setTotalCountMode(Criteria::TOTAL_COUNT_MODE_NONE);
$ids = $this->repository->searchIds($this->criteria, $this->context);
$values = $ids->getIds();
if (empty($values)) {
return null;
}
if (!$this->autoIncrement) {
$this->criteria->setOffset($this->criteria->getOffset() + $this->criteria->getLimit());
return $values;
}
$last = end($values);
if (!\is_string($last)) {
throw new \RuntimeException('Expected string as last element of ids array');
}
$increment = $ids->getDataFieldOfId($last, 'autoIncrement');
$this->criteria->setFilter('increment', new RangeFilter('autoIncrement', [RangeFilter::GT => $increment]));
$ids = $this->repository->searchIds($this->criteria, $this->context);
$values = $ids->getIds();
if (empty($values)) {
return null;
}
if (!$this->autoIncrement) {
$this->criteria->setOffset($this->criteria->getOffset() + $this->criteria->getLimit());
return $values;
}
$last = end($values);
if (!\is_string($last)) {
throw new \RuntimeException('Expected string as last element of ids array');
}
$increment = $ids->getDataFieldOfId($last, 'autoIncrement');
$this->criteria->setFilter('increment', new RangeFilter('autoIncrement', [RangeFilter::GT => $increment]));
/**
* {@inheritdoc}
*/
public function getValue(ResultRow $values, $field = NULL) {
// Note: 1 is subtracted from the counter start value below because the // counter value is incremented by 1 at the end of this function. $count = is_numeric($this->options['counter_start']) ? $this->options['counter_start'] - 1 : 0;
$pager = $this->view->pager;
// Get the base count of the pager. if ($pager->usePager()) {
$count += ($pager->getItemsPerPage() * $pager->getCurrentPage() + $pager->getOffset());
}
// Add the counter for the current site. $count += $this->view->row_index + 1;
return $count;
}
}
public function getValue(ResultRow $values, $field = NULL) {
// Note: 1 is subtracted from the counter start value below because the // counter value is incremented by 1 at the end of this function. $count = is_numeric($this->options['counter_start']) ? $this->options['counter_start'] - 1 : 0;
$pager = $this->view->pager;
// Get the base count of the pager. if ($pager->usePager()) {
$count += ($pager->getItemsPerPage() * $pager->getCurrentPage() + $pager->getOffset());
}
// Add the counter for the current site. $count += $this->view->row_index + 1;
return $count;
}
}
if (\is_string($timeZoneFromAbbr)) {
$databaseZone = timezone_open($timeZoneFromAbbr);
if (!$databaseZone instanceof DateTimeZone) {
$databaseZone = null;
}
}
}
$phpZone = timezone_open(date_default_timezone_get());
if ($databaseZone instanceof DateTimeZone && $phpZone instanceof DateTimeZone) {
$databaseTime = new DateTime('now', $databaseZone);
$offset = abs($databaseZone->getOffset(new DateTime()) - $phpZone->getOffset($databaseTime));
}
}
if (empty($offset)) {
$sql = 'SELECT UNIX_TIMESTAMP()-' . time();
$offset = (int) $connection->executeQuery($sql)->fetchOne();
}
$this->View()->assign(['success' => true, 'offset' => $offset < 60 ? 0 : round($offset / 60)]);
}
$databaseZone = timezone_open($timeZoneFromAbbr);
if (!$databaseZone instanceof DateTimeZone) {
$databaseZone = null;
}
}
}
$phpZone = timezone_open(date_default_timezone_get());
if ($databaseZone instanceof DateTimeZone && $phpZone instanceof DateTimeZone) {
$databaseTime = new DateTime('now', $databaseZone);
$offset = abs($databaseZone->getOffset(new DateTime()) - $phpZone->getOffset($databaseTime));
}
}
if (empty($offset)) {
$sql = 'SELECT UNIX_TIMESTAMP()-' . time();
$offset = (int) $connection->executeQuery($sql)->fetchOne();
}
$this->View()->assign(['success' => true, 'offset' => $offset < 60 ? 0 : round($offset / 60)]);
}
return self::asort(self::readEntry(['Names'], $displayLocale), $displayLocale);
}
/** * @throws \Exception if the timezone identifier does not exist * @throws RuntimeException if there's no timezone DST transition information available */
public static function getRawOffset(string $timezone, int $timestamp = null): int
{
$dateTimeImmutable = new \DateTimeImmutable(date('Y-m-d H:i:s', $timestamp ?? time()), new \DateTimeZone($timezone));
return $dateTimeImmutable->getOffset();
}
public static function getGmtOffset(string $timezone, int $timestamp = null, string $displayLocale = null): string
{
$offset = self::getRawOffset($timezone, $timestamp);
$abs = abs($offset);
return sprintf(self::readEntry(['Meta', 'GmtFormat'], $displayLocale), sprintf(self::readEntry(['Meta', 'HourFormat'.(0 <= $offset ? 'Pos' : 'Neg')], $displayLocale), $abs / 3600, $abs / 60 % 60));
}
/** * @throws MissingResourceException if the timezone identifier has no associated country code */
}
/** * @throws \Exception if the timezone identifier does not exist * @throws RuntimeException if there's no timezone DST transition information available */
public static function getRawOffset(string $timezone, int $timestamp = null): int
{
$dateTimeImmutable = new \DateTimeImmutable(date('Y-m-d H:i:s', $timestamp ?? time()), new \DateTimeZone($timezone));
return $dateTimeImmutable->getOffset();
}
public static function getGmtOffset(string $timezone, int $timestamp = null, string $displayLocale = null): string
{
$offset = self::getRawOffset($timezone, $timestamp);
$abs = abs($offset);
return sprintf(self::readEntry(['Meta', 'GmtFormat'], $displayLocale), sprintf(self::readEntry(['Meta', 'HourFormat'.(0 <= $offset ? 'Pos' : 'Neg')], $displayLocale), $abs / 3600, $abs / 60 % 60));
}
/** * @throws MissingResourceException if the timezone identifier has no associated country code */
public function testSetItemsPerPage() {
$this->pager->setItemsPerPage(6);
$this->assertEquals(6, $this->pager->getItemsPerPage());
}
/** * Tests the getOffset() method. * * @see \Drupal\views\Plugin\views\pager\PagerPluginBase::getOffset() */
public function testGetOffset() {
$this->assertEquals(1, $this->pager->getOffset());
}
/** * Tests the setOffset() method. * * @see \Drupal\views\Plugin\views\pager\PagerPluginBase::setOffset() */
public function testSetOffset() {
$this->pager->setOffset(2);
$this->assertEquals(2, $this->pager->getOffset());
}
$this->pager->setItemsPerPage(6);
$this->assertEquals(6, $this->pager->getItemsPerPage());
}
/** * Tests the getOffset() method. * * @see \Drupal\views\Plugin\views\pager\PagerPluginBase::getOffset() */
public function testGetOffset() {
$this->assertEquals(1, $this->pager->getOffset());
}
/** * Tests the setOffset() method. * * @see \Drupal\views\Plugin\views\pager\PagerPluginBase::setOffset() */
public function testSetOffset() {
$this->pager->setOffset(2);
$this->assertEquals(2, $this->pager->getOffset());
}
$handler->handle($condition, $query);
}
return $query;
}
/** * @return array[] */
private function fetchCustomers(Criteria $criteria, QueryBuilder $query)
{
if ($criteria->getOffset() !== null) {
$query->setFirstResult($criteria->getOffset());
}
if ($criteria->getLimit() !== null) {
$query->setMaxResults($criteria->getLimit());
}
foreach ($criteria->getSortings() as $sorting) {
$handler = $this->handlerRegistry->getSortingHandler($sorting);
$handler->handle($sorting, $query);
}
}
return $query;
}
/** * @return array[] */
private function fetchCustomers(Criteria $criteria, QueryBuilder $query)
{
if ($criteria->getOffset() !== null) {
$query->setFirstResult($criteria->getOffset());
}
if ($criteria->getLimit() !== null) {
$query->setMaxResults($criteria->getLimit());
}
foreach ($criteria->getSortings() as $sorting) {
$handler = $this->handlerRegistry->getSortingHandler($sorting);
$handler->handle($sorting, $query);
}
use IntegrationTestBehaviour;
public function testFromParameterBagComputesOffset(): void
{
$extensionCriteria = ExtensionCriteria::fromArray([
'limit' => 25,
'page' => 1,
]);
static::assertEquals(25, $extensionCriteria->getLimit());
static::assertEquals(0, $extensionCriteria->getOffset());
$extensionCriteria = ExtensionCriteria::fromArray([
'limit' => 10,
'page' => 5,
]);
static::assertEquals(10, $extensionCriteria->getLimit());
static::assertEquals(40, $extensionCriteria->getOffset());
}
public function testItIgnoresInvalidValuesForSortDirection(): void
{
$timezone_info = array();
if ( $tz_string ) {
try {
$tz = new DateTimeZone( $tz_string );
} catch ( Exception $e ) {
$tz = '';
}
if ( $tz ) {
$now = new DateTime( 'now', $tz );
$formatted_gmt_offset = $this->format_gmt_offset( $tz->getOffset( $now ) / HOUR_IN_SECONDS );
$tz_name = str_replace( '_', ' ', $tz->getName() );
$timezone_info['abbr'] = $now->format( 'T' );
$timezone_info['description'] = sprintf(
/* translators: 1: Timezone name, 2: Timezone abbreviation, 3: UTC abbreviation and offset, 4: UTC offset. */
__( 'Your timezone is set to %1$s (%2$s), currently %3$s (Coordinated Universal Time %4$s).' ),
$tz_name,
'<abbr>' . $timezone_info['abbr'] . '</abbr>',
'<abbr>UTC</abbr>' . $formatted_gmt_offset,
$formatted_gmt_offset
);
}
if ( $tz_string ) {
try {
$tz = new DateTimeZone( $tz_string );
} catch ( Exception $e ) {
$tz = '';
}
if ( $tz ) {
$now = new DateTime( 'now', $tz );
$formatted_gmt_offset = $this->format_gmt_offset( $tz->getOffset( $now ) / HOUR_IN_SECONDS );
$tz_name = str_replace( '_', ' ', $tz->getName() );
$timezone_info['abbr'] = $now->format( 'T' );
$timezone_info['description'] = sprintf(
/* translators: 1: Timezone name, 2: Timezone abbreviation, 3: UTC abbreviation and offset, 4: UTC offset. */
__( 'Your timezone is set to %1$s (%2$s), currently %3$s (Coordinated Universal Time %4$s).' ),
$tz_name,
'<abbr>' . $timezone_info['abbr'] . '</abbr>',
'<abbr>UTC</abbr>' . $formatted_gmt_offset,
$formatted_gmt_offset
);
}
public function toExtJs($result)
{
if ($result instanceof ValidResult) {
return [
'valid' => true,
'offset' => $result->getOffset(),
'total' => $result->getTotal(),
'success' => true,
];
}
if ($result instanceof FinishResult) {
return [
'valid' => false,
'offset' => $result->getOffset(),
'total' => $result->getTotal(),
'success' => true,
];
/**
* @template TEntityCollection of EntityCollection
*
* @param EntitySearchResult<TEntityCollection> $searchResult
* @param array<string, mixed> $parameters
*
* @return array{first?: string, prev?: string, next?: string, last?: string}
*/
protected function createPaginationLinks(EntitySearchResult $searchResult, string $uri, array $parameters): array
{
$limit = $searchResult->getCriteria()->getLimit() ?? 0;
$offset = $searchResult->getCriteria()->getOffset() ?? 0;
if ($limit <= 0) {
return [];
}
$pagination = [
'first' => $this->buildPaginationUrl($uri, $parameters, $limit, 1),
];
$currentPage = 1 + (int) floor($offset / $limit);
if ($currentPage > 1) {
$pagination['prev'] = $this->buildPaginationUrl($uri, $parameters, $limit, $currentPage - 1);
}
protected function createPaginationLinks(EntitySearchResult $searchResult, string $uri, array $parameters): array
{
$limit = $searchResult->getCriteria()->getLimit() ?? 0;
$offset = $searchResult->getCriteria()->getOffset() ?? 0;
if ($limit <= 0) {
return [];
}
$pagination = [
'first' => $this->buildPaginationUrl($uri, $parameters, $limit, 1),
];
$currentPage = 1 + (int) floor($offset / $limit);
if ($currentPage > 1) {
$pagination['prev'] = $this->buildPaginationUrl($uri, $parameters, $limit, $currentPage - 1);
}