openslx-ng/slx-admin.git/modules-available/statistics_reporting/inc/getdata.inc.php, branch master Web Interface zum Verwalten der Hochschul-/UniSpezifischen Einstellungen der Linux-Umgebung https://git.openslx.org/openslx-ng/slx-admin.git/atom/modules-available/statistics_reporting/inc/getdata.inc.php?h=master 2023-11-14T13:47:55+00:00 Add function param/return types, fix a lot more phpstorm complaints 2023-11-14T13:47:55+00:00 Simon Rettberg 2023-11-14T13:47:55+00:00 urn:sha1:06bff0b9b84d47c43f9bc8aff06a29d85ebb7ed0 Moderize Database handling 2021-05-11T12:51:13+00:00 Simon Rettberg 2021-05-06T08:26:09+00:00 urn:sha1:8dc2b92d667f1401ab9f1315a36add61658f899c * Auto-convert to utf8mb4_unicode_520_ci * Use foreach instead of while to loop over results * Drop useless statement caching * Keep emulated prepares, as we sometimes loop over nested queries [statistics_reporting] Query rewrite: Use iterative approach 2018-01-04T17:34:28+00:00 Simon Rettberg 2018-01-04T17:34:28+00:00 urn:sha1:406cd79ff35ab1dd3ba796207f2ea471e87f17d5 Several simple test cases yielded incorrect results, also sessions partially overlapping with the selected hours were not handled properly. Iterative processing of logged events instead of single humongous unmaintainable SQL query. [statistics_reporting] Extend remote report by hwstats, date ranges, userstats 2017-04-24T14:05:13+00:00 Simon Rettberg 2017-04-24T14:05:13+00:00 urn:sha1:e9aa7ceb89c487f5d2c2bb102f67618ebfcae08b This implements #3108 [statistics_reporting] fixed clients/locations without offline-length entries not showing 2017-04-04T14:11:03+00:00 Udo Walter 2017-04-04T14:11:03+00:00 urn:sha1:3a94f3629aada7197caafc696a86eada598648f1 [statistics_reporting] Convert NULL to 0 so stupidtable doesn't mess up 2017-04-03T11:51:34+00:00 Simon Rettberg 2017-04-03T11:51:34+00:00 urn:sha1:3cd3abab1a33459d3613fa342cbd8fd9135b1202 [statistics_reporting] included currently offline clients in offline time + bugfixes + some comments 2017-02-23T16:44:39+00:00 Udo Walter 2017-02-23T16:44:39+00:00 urn:sha1:1fe5e109bc29af02de89c6513744c4c8755d5422 [statistics_reporting] Consistent field naming across classes, templates etc. 2017-02-08T12:38:04+00:00 Simon Rettberg 2017-02-08T12:38:04+00:00 urn:sha1:3a09daee1ebaf014536e14e82ca0fd4c2c92a41f [statistics_reporting] Use indexed fields for joins, return location id from GetData::* 2017-02-07T13:55:23+00:00 Simon Rettberg 2017-02-07T13:55:23+00:00 urn:sha1:5dd18528ebd23cbc8b6d86c988d398a0058d1bab [statistics_reporting] Make getdata functions options flag based in preparation of data export 2017-01-31T14:45:28+00:00 Simon Rettberg 2017-01-31T14:45:28+00:00 urn:sha1:5c6b40b28ead1157260e4abc2e697a696f69520e