Revize 1635
Přidáno uživatelem Ondřej Fibich před asi 12 roky(ů)
| freenetis/branches/testing/application/models/members_traffic.php | ||
|---|---|---|
|
SELECT
|
||
|
IFNULL(SUM(upload),0) AS upload,
|
||
|
IFNULL(SUM(download),0) AS download,
|
||
|
day
|
||
|
IFNULL(SUM(upload),0) + IFNULL(SUM(download),0) AS total,
|
||
|
IFNULL(AVG(upload),0) AS avg_upload,
|
||
|
IFNULL(AVG(download),0) AS avg_download,
|
||
|
IFNULL(SUM(local_upload),0) AS local_upload,
|
||
|
IFNULL(SUM(local_download),0) AS local_download,
|
||
|
SUM(upload - local_upload) AS foreign_upload,
|
||
|
SUM(download - local_download) AS foreign_download,
|
||
|
day,
|
||
|
WEEK(day) AS week,
|
||
|
MONTH(day) AS month,
|
||
|
YEAR(day) AS year
|
||
|
FROM members_traffics d
|
||
|
$group_by
|
||
|
) d
|
||
| ... | ... | |
|
member_id,
|
||
|
IFNULL(SUM(upload),0) AS upload,
|
||
|
IFNULL(SUM(download),0) AS download,
|
||
|
day
|
||
|
IFNULL(SUM(upload),0) + IFNULL(SUM(download),0) AS total,
|
||
|
IFNULL(AVG(upload),0) AS avg_upload,
|
||
|
IFNULL(AVG(download),0) AS avg_download,
|
||
|
IFNULL(SUM(local_upload),0) AS local_upload,
|
||
|
IFNULL(SUM(local_download),0) AS local_download,
|
||
|
SUM(upload - local_upload) AS foreign_upload,
|
||
|
SUM(download - local_download) AS foreign_download,
|
||
|
day,
|
||
|
WEEK(day) AS week,
|
||
|
MONTH(day) AS month,
|
||
|
YEAR(day) AS year
|
||
|
FROM members_traffics d
|
||
|
$group_by
|
||
|
) d
|
||
| ... | ... | |
|
SELECT
|
||
|
IFNULL(SUM(upload),0) AS upload,
|
||
|
IFNULL(SUM(download),0) AS download,
|
||
|
day
|
||
|
IFNULL(SUM(upload),0) + IFNULL(SUM(download),0) AS total,
|
||
|
IFNULL(AVG(upload),0) AS avg_upload,
|
||
|
IFNULL(AVG(download),0) AS avg_download,
|
||
|
IFNULL(SUM(local_upload),0) AS local_upload,
|
||
|
IFNULL(SUM(local_download),0) AS local_download,
|
||
|
SUM(upload - local_upload) AS foreign_upload,
|
||
|
SUM(download - local_download) AS foreign_download,
|
||
|
day,
|
||
|
WEEK(day) AS week,
|
||
|
MONTH(day) AS month,
|
||
|
YEAR(day) AS year
|
||
|
FROM members_traffics d
|
||
|
WHERE d.member_id = ?
|
||
|
$group_by
|
||
Také k dispozici: Unified diff
Opravy:
- oprava chybne upravenych dotazu u provozu