libraries/transformations/text_plain__dateformat.inc.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * @package PhpMyAdmin-Transformation
   5  */
   6
   7 function PMA_transformation_text_plain__dateformat_info()
   8 {
   9     return array(
  10         'info' => __('Displays a TIME, TIMESTAMP, DATETIME or numeric unix timestamp column as formatted date. The first option is the offset (in hours) which will be added to the timestamp (Default: 0). Use second option to specify a different date/time format string. Third option determines whether you want to see local date or UTC one (use "local" or "utc" strings) for that. According to that, date format has different value - for "local" see the documentation for PHP\'s strftime() function and for "utc" it is done using gmdate() function.'),
  11         );
  12 }
  13
  14 /**
  15  *
  16  */
  17 function PMA_transformation_text_plain__dateformat($buffer, $options = array(), $meta = '')
  18 {
  19     // possibly use a global transform and feed it with special options:
  20     // include './libraries/transformations/global.inc.php';
  21
  22     // further operations on $buffer using the $options[] array.
  23     if (empty($options[0])) {
  24         $options[0] = 0;
  25     }
  26
  27     if (empty($options[2])) {
  28         $options[2] = 'local';
  29     } else {
  30         $options[2] = strtolower($options[2]);
  31     }
  32
  33     if (empty($options[1])) {
  34         if ($options[2] == 'local') {
  35             $options[1] = __('%B %d, %Y at %I:%M %p');
  36         } else {
  37             $options[1] = 'Y-m-d  H:i:s';
  38         }
  39     }
  40
  41     $timestamp = -1;
  42
  43     // INT columns will be treated as UNIX timestamps
  44     // and need to be detected before the verification for
  45     // MySQL TIMESTAMP
  46     if ($meta->type == 'int') {
  47         $timestamp = $buffer;
  48
  49     // Detect TIMESTAMP(6 | 8 | 10 | 12 | 14)
  50     // TIMESTAMP (2 | 4) not supported here.
  51     // (Note: prior to MySQL 4.1, TIMESTAMP has a display size, for example
  52     // TIMESTAMP(8) means YYYYMMDD)
  53     } else if (preg_match('/^(\d{2}){3,7}$/', $buffer)) {
  54
  55         if (strlen($buffer) == 14 || strlen($buffer) == 8) {
  56             $offset = 4;
  57         } else {
  58             $offset = 2;
  59         }
  60
  61         $d = array();
  62         $d['year']   = substr($buffer, 0, $offset);
  63         $d['month']  = substr($buffer, $offset, 2);
  64         $d['day']    = substr($buffer, $offset + 2, 2);
  65         $d['hour']   = substr($buffer, $offset + 4, 2);
  66         $d['minute'] = substr($buffer, $offset + 6, 2);
  67         $d['second'] = substr($buffer, $offset + 8, 2);
  68
  69         if (checkdate($d['month'], $d['day'], $d['year'])) {
  70             $timestamp = mktime($d['hour'], $d['minute'], $d['second'], $d['month'], $d['day'], $d['year']);
  71         }
  72     // If all fails, assume one of the dozens of valid strtime() syntaxes (http://www.gnu.org/manual/tar-1.12/html_chapter/tar_7.html)
  73     } else {
  74         if (preg_match('/^[0-9]\d{1,9}$/', $buffer)) {
  75             $timestamp = (int)$buffer;
  76         } else {
  77             $timestamp = strtotime($buffer);
  78         }
  79     }
  80
  81     // If all above failed, maybe it's a Unix timestamp already?
  82     if ($timestamp < 0 && preg_match('/^[1-9]\d{1,9}$/', $buffer)) {
  83         $timestamp = $buffer;
  84     }
  85
  86     // Reformat a valid timestamp
  87     if ($timestamp >= 0) {
  88         $timestamp -= $options[0] * 60 * 60;
  89         $source = $buffer;
  90         if ($options[2] == 'local') {
  91             $text = PMA_localisedDate($timestamp, $options[1]);
  92         } elseif ($options[2] == 'utc') {
  93             $text = gmdate($options[1], $timestamp);
  94         } else {
  95             $text = 'INVALID DATE TYPE';
  96         }
  97         $buffer = '<dfn onclick="alert(\'' . $source . '\');" title="' . $source . '">' . $text . '</dfn>';
  98     }
  99
 100     return $buffer;
 101 }
 102
 103 ?>