Lines Matching refs:tz
19 protected string $tz = 'localtime'; variable in dokuwiki\\plugin\\statistics\\Query
70 $this->tz = $dateTime->format('P');
126 $result = $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
156 … $result = $this->db->queryRecord($sql, [$this->tz, $this->tz, $this->from, $this->tz, $this->to]);
176 $count = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to]);
191 … $data['avgpages'] = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to]);
199 … $data['timespent'] = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to]);
206 … $data['logins'] = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to]);
213 …$data['registrations'] = $this->db->queryValue($sql, [$this->tz, $this->from, $this->tz, $this->to…
234 $TIME = "strftime('%H', DATETIME(P.dt, '$this->tz'))";
236 $TIME = "DATE(DATETIME(P.dt, '$this->tz'))";
252 $result = $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
268 $TIME = "strftime('%H', DATETIME(dt, '$this->tz'))";
270 $TIME = "DATE(DATETIME(dt, '$this->tz'))";
284 $result = $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
301 … $TIME = "strftime('%Y', DATETIME(dt, '$this->tz')), strftime('%W', DATETIME(dt, '$this->tz'))";
303 $TIME = "strftime('%Y-%m', DATETIME(dt, '$this->tz'))";
305 $TIME = "strftime('%d-%m', DATETIME(dt, '$this->tz'))";
321 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to, $info]);
338 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
352 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
368 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
382 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
399 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
413 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
428 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
440 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
455 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
467 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
487 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
508 …return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to, $this->tz, $this->…
524 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
541 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
558 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
576 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
600 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
615 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
635 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
653 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
670 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
689 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
707 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
732 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
757 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);