Lines Matching refs:this
26 $this->hlp = $hlp;
27 $this->db = $hlp->getDB();
29 $this->setTimeFrame($today, $today);
30 $this->setPagination(0, 20);
51 $this->from = $from->format('Y-m-d H:i:s');
52 $this->to = $to->format('Y-m-d H:i:s');
54 $this->setTimezone();
65 $timezoneId = $this->hlp->getConf('timezone');
69 $dateTime = new \DateTime($this->from, new \DateTimeZone($timezoneId));
70 $this->tz = $dateTime->format('P');
89 $this->limit = " LIMIT $start,$limit";
91 $this->limit = " OFFSET $start";
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…
219 $data['current'] = $this->db->queryValue($sql);
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]);
337 $this->limit;
338 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
351 $this->limit;
352 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
367 $this->limit;
368 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
381 $this->limit;
382 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
398 $this->limit;
399 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
412 $this->limit;
413 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
427 $this->limit;
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]);
454 $this->limit;
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]);
486 $this->limit;
487 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
507 $this->limit;
508 …return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to, $this->tz, $this->…
523 $this->limit;
524 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
540 $this->limit;
541 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
557 $this->limit;
558 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
575 $this->limit;
576 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
599 $this->limit;
600 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
614 $this->limit;
615 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
634 $this->limit;
635 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
652 $this->limit;
653 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
669 $this->limit;
670 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
688 $this->limit;
689 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
706 $this->limit;
707 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
731 $this->limit;
732 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
755 $this->limit;
757 return $this->db->queryAll($sql, [$this->tz, $this->from, $this->tz, $this->to]);
771 $this->limit;
773 return $this->db->queryAll($sql);