protected function SimplesitemapSitemapsForm::fetchSitemapInstancePublishedTimestamps in Simple XML sitemap 8.3

@todo Implement SitemapGeneratorBase::getPublishedTimestamp() per sitemap instead or at least return a constant.

Return value

array

1 call to SimplesitemapSitemapsForm::fetchSitemapInstancePublishedTimestamps()

SimplesitemapSitemapsForm::buildForm in src/Form/SimplesitemapSitemapsForm.php

Form constructor.

File

src/Form/SimplesitemapSitemapsForm.php, line 230

Class

SimplesitemapSitemapsForm

Class SimplesitemapSitemapsForm @package Drupal\simple_sitemap\Form

Namespace

Drupal\simple_sitemap\Form

Code

protected function fetchSitemapInstancePublishedTimestamps() {
  return $this->db
    ->query('SELECT type, MAX(sitemap_created) FROM (SELECT sitemap_created, type FROM {simple_sitemap} WHERE status = :status) AS timestamps GROUP BY type', [
    ':status' => 1,
  ])
    ->fetchAllKeyed(0, 1);
}