X-Git-Url: http://www.aleph1.co.uk/gitweb/?a=blobdiff_plain;ds=sidebyside;f=web%2Fcore%2Fmodules%2Fviews%2Fsrc%2FPlugin%2Fviews%2Fquery%2FDateSqlInterface.php;fp=web%2Fcore%2Fmodules%2Fviews%2Fsrc%2FPlugin%2Fviews%2Fquery%2FDateSqlInterface.php;h=caa741939b300724e71af9a7778a818d931d426d;hb=af6d1fb995500ae68849458ee10d66abbdcfb252;hp=0000000000000000000000000000000000000000;hpb=680c79a86e3ed402f263faeac92e89fb6d9edcc0;p=yaffs-website

diff --git a/web/core/modules/views/src/Plugin/views/query/DateSqlInterface.php b/web/core/modules/views/src/Plugin/views/query/DateSqlInterface.php
new file mode 100644
index 000000000..caa741939
--- /dev/null
+++ b/web/core/modules/views/src/Plugin/views/query/DateSqlInterface.php
@@ -0,0 +1,62 @@
+<?php
+
+namespace Drupal\views\Plugin\views\query;
+
+/**
+ * Defines an interface for handling date queries with SQL.
+ *
+ * @internal
+ *   Classes implementing this interface should only be used by the Views SQL
+ *   query plugin.
+ *
+ * @see \Drupal\views\Plugin\views\query\Sql
+ */
+interface DateSqlInterface {
+
+  /**
+   * Returns a native database expression for a given field.
+   *
+   * @param string $field
+   *   The query field that will be used in the expression.
+   * @param bool $string_date
+   *   For certain databases, date format functions vary depending on string or
+   *   numeric storage.
+   *
+   * @return string
+   *   An expression representing a date field with timezone.
+   */
+  public function getDateField($field, $string_date);
+
+  /**
+   * Creates a native database date formatting.
+   *
+   * @param string $field
+   *   An appropriate query expression pointing to the date field.
+   * @param string $format
+   *   A format string for the result. For example: 'Y-m-d H:i:s'.
+   *
+   * @return string
+   *   A string representing the field formatted as a date as specified by
+   *   $format.
+   */
+  public function getDateFormat($field, $format);
+
+  /**
+   * Applies the given offset to the given field.
+   *
+   * @param string &$field
+   *   The date field in a string format.
+   * @param int $offset
+   *   The timezone offset in seconds.
+   */
+  public function setFieldTimezoneOffset(&$field, $offset);
+
+  /**
+   * Set the database to the given timezone.
+   *
+   * @param string $offset
+   *   The timezone.
+   */
+  public function setTimezoneOffset($offset);
+
+}