68% sql-reporting-services

Code Review | SQL Reporting Services - SSRS Plugin for WordPress

WordPress plugin SQL Reporting Services - SSRS Plugin for WordPress scored 68% from 54 tests.

About plugin

  • Plugin page: sql-reporting-ser...
  • Plugin version: 1.0.3
  • PHP compatiblity: 5.3+
  • PHP version: 7.4.16
  • WordPress compatibility: 3.7.1-5.7
  • WordPress version: 5.9.2
  • First release: Dec 28, 2018
  • Latest release: Mar 12, 2021
  • Number of updates: 19
  • Update frequency: every 42.4 days
  • Top authors: modulemasters (100%)

Code review

54 tests

User reviews

1 review

Install metrics

30+ active / 1,067 total downloads
Download (1.09 MB)

Benchmarks

Plugin footprint 65% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | It is important to correctly install your plugin, without throwing errors or notices
The plugin installed gracefully, with no errors

Server metrics [RAM: ▲4.46MB] [CPU: ▼292.94ms] Passed 4 tests

Server-side resources used by SQL Reporting Services - SSRS Plugin for WordPress
Normal server usage
PageMemory (MB)CPU Time (ms)
Home /8.35 ▲4.8477.11 ▲22.29
Dashboard /wp-admin8.37 ▲4.9765.86 ▲30.04
Posts /wp-admin/edit.php8.37 ▲4.7372.87 ▲27.12
Add New Post /wp-admin/post-new.php10.27 ▲3.30115.53 ▼1,251.20
Media Library /wp-admin/upload.php8.37 ▲5.0867.81 ▲40.80
Freemius Debug [v.2.4.1] /wp-admin/admin.php?page=freemius8.3748.16
SQL Reporting Services /wp-admin/options-general.php?page=sqlreportingservices8.3758.93

Server storage [IO: ▲4.10MB] [DB: ▲0.00MB] Passed 3 tests

How much does this plugin use your filesystem and database?
This plugin was installed successfully
Filesystem: 273 new files
Database: no new tables, 4 new options
New WordPress options
fs_debug_mode
fs_active_plugins
fs_gdpr
fs_accounts

Browser metrics Passed 4 tests

SQL Reporting Services - SSRS Plugin for WordPress: an overview of browser usage
This plugin has a minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /3,935 ▲19315.95 ▲0.178.73 ▲1.862.04 ▼0.11
Dashboard /wp-admin2,939 ▲816.15 ▼0.10155.01 ▲12.20173.60 ▲9.65
Posts /wp-admin/edit.php2,728 ▲343.24 ▲0.0163.90 ▼4.72224.00 ▲76.93
Add New Post /wp-admin/post-new.php1,675 ▲1416.82 ▼4.95428.60 ▲2.00166.40 ▲8.95
Media Library /wp-admin/upload.php1,736 ▲385.54 ▲0.00139.25 ▼1.43206.91 ▲21.59
Freemius Debug [v.2.4.1] /wp-admin/admin.php?page=freemius1,4392.5354.07170.04
SQL Reporting Services /wp-admin/options-general.php?page=sqlreportingservices1,2942.4753.33208.54

Uninstaller [IO: ▲0.00MB] [DB: ▲0.00MB] 50% from 4 tests

🔸 Tests weight: 35 | Verifying that this plugin uninstalls completely without leaving any traces
The following items require your attention
  • This plugin did not uninstall without warnings or errors
    • > Notice in wp-content/plugins/sql-reporting-services/freemius/includes/class-freemius.php+8540
    Undefined property: stdClass::$plugins
  • The uninstall procedure has failed, leaving 4 options in the database
    • fs_accounts
    • fs_active_plugins
    • fs_debug_mode
    • fs_gdpr

Smoke tests 50% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | A shallow check that no server-side errors were triggered
Even though everything seems fine, this is not an exhaustive test

SRP 0% from 2 tests

🔹 Tests weight: 20 | The single-responsibility principle: PHP files have to remain inert when accessed directly, throwing no errors and performing no actions
Please fix the following
  • 3× GET requests to PHP files return non-empty strings:
    • > /wp-content/plugins/sql-reporting-services/admin/partials/sql-reporting-services-admin-display.php
    • > /wp-content/plugins/sql-reporting-services/freemius/templates/ajax-loader.php
    • > /wp-content/plugins/sql-reporting-services/public/partials/sql-reporting-services-public-display.php
  • 34× PHP files trigger server errors when accessed directly (only 10 are shown):
    • > PHP Fatal error
      Uncaught Error: Interface 'ISSRSBaseType' not found in wp-content/plugins/sql-reporting-services/includes/SSRS/SSRSType/ReportParameter.php:31
    • > PHP Fatal error
      Uncaught Error: Interface 'ISSRSBaseType' not found in wp-content/plugins/sql-reporting-services/includes/SSRS/SSRSType/ReportPaperSize.php:31
    • > PHP Fatal error
      Uncaught Error: Class 'SSRSBaseType' not found in wp-content/plugins/sql-reporting-services/includes/SSRS/SSRSType/CatalogItemCollection.php:31
    • > PHP Fatal error
      Uncaught Error: Interface 'ISSRSBaseType' not found in wp-content/plugins/sql-reporting-services/includes/SSRS/SSRSType/CatalogItem.php:31
    • > PHP Fatal error
      Uncaught Error: Class 'RenderBaseType' not found in wp-content/plugins/sql-reporting-services/includes/SSRS/RenderType/RenderAsIMAGE.php:31
    • > PHP Fatal error
      Uncaught Error: Interface 'ISSRSBaseType' not found in wp-content/plugins/sql-reporting-services/includes/SSRS/SSRSType/PageSettings.php:31
    • > PHP Fatal error
      Uncaught Error: Class 'SSRSBaseType' not found in wp-content/plugins/sql-reporting-services/includes/SSRS/SSRSType/ExecutionInfo2.php:31
    • > PHP Fatal error
      Uncaught Error: Call to undefined function freemius() in wp-content/plugins/sql-reporting-services/freemius/templates/partials/network-activation.php:6
    • > PHP Notice
      Undefined variable: VARS in wp-content/plugins/sql-reporting-services/freemius/templates/account/partials/addon.php on line 6
    • > PHP Fatal error
      Uncaught Error: Interface 'ISSRSBaseType' not found in wp-content/plugins/sql-reporting-services/includes/SSRS/SSRSType/Warning.php:31

User-side errors Passed 1 test

🔹 Test weight: 20 | A shallow check that no browser errors were triggered
No browser issues were found

Optimizations

Plugin configuration 97% from 29 tests

readme.txt 94% from 16 tests

Perhaps the most important file in your plugin readme.txt gets parsed in order to generate the public listing of your plugin
These attributes need your attention:
  • Tags: There are too many tags (12 tag instead of maximum 10)
The official readme.txt might help

sql-reporting-services/sql-reporting-services.php Passed 13 tests

The entry point to "SQL Reporting Services - SSRS Plugin for WordPress" version 1.0.3 is a PHP file that has certain tags in its header comment area
111 characters long description:
This plugin allows you to embed Microsoft SQL Reporting Services (SSRS) reports right into your WordPress site.

Code Analysis 97% from 3 tests

File types Passed 1 test

🔸 Test weight: 35 | A short review of files and their extensions; it is not recommended to include executable files
No dangerous file extensions were detected47,684 lines of code in 220 files:
LanguageFilesBlank linesComment linesLines of code
PHP1627,66818,83732,155
PO File105,7106,91312,558
Sass29399772,523
JavaScript53859200
Markdown1610192
CSS121329
JSON10027

PHP code 50% from 2 tests

An short overview of logical lines of code, cyclomatic complexity, and other code metrics
The following items need your attention
  • Cyclomatic complexity of classes should be reduced to less than 1000 (currently 2,895)
Cyclomatic complexity
Average complexity per logical line of code0.59
Average class complexity43.70
▷ Minimum class complexity1.00
▷ Maximum class complexity2,895.00
Average method complexity4.31
▷ Minimum method complexity1.00
▷ Maximum method complexity86.00
Code structure
Namespaces0
Interfaces2
Traits0
Classes94
▷ Abstract classes33.19%
▷ Concrete classes9196.81%
▷ Final classes00.00%
Methods1,274
▷ Static methods18014.13%
▷ Public methods92072.21%
▷ Protected methods221.73%
▷ Private methods33226.06%
Functions97
▷ Named functions97100.00%
▷ Anonymous functions00.00%
Constants129
▷ Global constants10077.52%
▷ Class constants2922.48%
▷ Public constants29100.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

Using a strong compression for your PNG files is a great way to speed-up your plugin
3 PNG files occupy 0.03MB with 0.01MB in potential savings
Potential savings
Compression of 3 random PNG files using pngquant
FileSize - originalSize - compressedSavings
freemius/assets/img/plugin-icon.png9.16KB5.26KB▼ 42.58%
freemius/assets/img/sql-reporting-services.png9.16KB5.26KB▼ 42.58%
freemius/assets/img/theme-icon.png10.97KB5.78KB▼ 47.37%