aboutsummaryrefslogtreecommitdiff
path: root/app/Models/StatsDAO.php
AgeCommit message (Collapse)Author
2019-09-29PDO refactoring for code simplification (#2522)Gravatar Alexandre Alapetite
* PDO refactor * Automatic prefix when using the syntax `_tableName` * Uniformity: MySQL is now PDO::ATTR_EMULATE_PREPARES = false just like SQLite and PostgreSQL, with consequences such as only one statement per query * Use PDO methods exec(), query(), prepare() + execute() in a more efficient way * Remove auto-update SQL code for versions older than FreshRSS 1.5 (3 years old) * The name of the default category is set in PHP instead of in the DB (simplies SQL and allows changing the name according to the FreshRSS language) * Rename `->bd` to `->pdo` (less of a frenshism, and more informative) * Fix some requests, which were not compatible with MySQL prepared statements * Whitespace * Fix syntax for PostgreSQL sequences + MySQL install * Minor formatting * Fix lastInsertId for PostgreSQL * Use PHP 5.6+ const Take advantage of https://github.com/FreshRSS/FreshRSS/pull/2527 https://www.php.net/manual/en/migration56.new-features.php * A bit of forgotten PHP 5.6 simplification for cURL * Forgotten $s * Mini fix custom user config https://github.com/FreshRSS/FreshRSS/pull/2490/files#r326290346 * More work on install.php but not finished * install.php working * More cleaning of PDO in install * Even more simplification Take advantage of PDO->exec() to run multiple statements * Disallow changing the name of the default category https://github.com/FreshRSS/FreshRSS/pull/2522#discussion_r326967724
2017-08-20May abbreviation conflictGravatar Alexandre Alapetite
2017-08-20May abbreviationGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/1560
2016-09-29Fix SQLiteGravatar Alexandre Alapetite
2016-09-27A bit more PostgreSQLGravatar Alexandre Alapetite
Simplified statistics https://github.com/FreshRSS/FreshRSS/pull/1250
2016-09-25Merge branch 'FreshRSS/dev' into PostgreSQLGravatar Alexandre Alapetite
2016-09-11Simplify SQL in statisticsGravatar Alexandre Alapetite
Reduce the use of product-specific date functions. Improve performances. Remove redundant functions.
2016-08-31Merge branch 'FreshRSS/dev' into PostgreSQLGravatar Alexandre Alapetite
2016-08-28Variable initializationGravatar Alexandre Alapetite
PHP warning when not feed is iddle https://github.com/FreshRSS/FreshRSS/issues/1227#issuecomment-242702464
2016-08-07Problematic MySQL reserved keywordGravatar Alexandre Alapetite
`read` and `reads` are reserved keywords
2016-08-02PostgreSQL draftGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/416 Based on @Damstre work https://github.com/FreshRSS/FreshRSS/pull/1071 Not tested
2016-02-21CSP for statisticsGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/1075
2014-12-11Update i18n for statisticsGravatar Marien Fressinaud
2014-11-08Refactor some if statementsGravatar Alexis Degrugillier
2014-11-08Add more info in article repartition pageGravatar Alexis Degrugillier
I added the same information than on the main stat page (total, read, unread and favorite) on the repartition page. Some refactoring was needed.
2014-10-09Change statistic averageGravatar Alexis Degrugillier
I was using the stats and it feels that the stat average was useless in that form since the line is always at the same position no matter what is the value. So I deleted that line and added the average in the title. It is way more useful this way. I updated some translations both on i18n files and on http://i18n.freshrss.org
2014-10-05Coding styleGravatar Marien Fressinaud
Remove spaces before parenthesis bis See https://github.com/marienfressinaud/FreshRSS/issues/655
2014-10-05Let's begin the big refactoring!Gravatar Marien Fressinaud
Minz_Translate::t\s? replaces by _t See https://github.com/marienfressinaud/FreshRSS/issues/655
2014-09-29Add an average per day for the 30 day periodGravatar Alexis Degrugillier
2014-09-19Few fixes about statisticsGravatar Marien Fressinaud
2014-09-19Fix repartition stats with 0 or 1 article.Gravatar Marien Fressinaud
2014-09-01Add average on repartition charts.Gravatar Alexis Degrugillier
It needs some verification on the value used to calculate the averages.
2014-07-24Add repartition statistic support in SqliteGravatar Alexis Degrugillier
2014-07-24Add article repartition in statsGravatar Alexis Degrugillier
Add article repartition per hour, per day of week, per month for all feeds but also for individual feeds.
2014-07-22Idle feeds: link to configuration pageGravatar Alexandre Alapetite
https://github.com/marienfressinaud/FreshRSS/issues/544
2014-07-18Add statistics support for SqliteGravatar Alexis Degrugillier
Add statistics support for Sqlite by tweeking one query and rewrite an other. The rewrite implied a complete refactor of the MySql query as well. Now the code is more flexible and make less queries to the database. See #527
2014-07-06Prepare statistics for SQLiteGravatar Alexandre Alapetite
Temporarily disable 30-day statistics for SQLite https://github.com/marienfressinaud/FreshRSS/issues/100 https://github.com/marienfressinaud/FreshRSS/issues/90
2014-06-15Refactor and formattingGravatar Alexis Degrugillier
2014-06-15Refactor statisticsGravatar Alexis Degrugillier
I made a new controller to handle statistics. The old statistics have been moved in that controller and a new action has been added to display idle feeds. I also added a menu in the left panel to navigate between the statistics pages. See #90
2014-01-26Modification des statistiques.Gravatar Alexis Degrugillier
Ajout de la liste des 10 plus gros contributeurs Ajout de règles CSS pour les thèmes Flat et Dark Modification de l'affichage des camemberts (tri par nombre qui remplace le tri alphabétique)
2014-01-25Ajout de statistiques de l'applicationGravatar Alexis Degrugillier
Conflicts: app/i18n/en.php app/i18n/fr.php
generated by cgit v1.2.3 (git 2.39.1) at 2026-02-10 15:16:24 +0000