Main Menu

(1 themes)
Who is Online
4 user(s) are online (1 user(s) are browsing Publisher)

Members: 0
Guests: 4


Two awesome XOOPS gwReports

    • Published by Admin on 23-May-2017 10:20 (1947 reads)
    a) gwReports is a serious MySQL reporting tool implemented as a module for XOOPS. gwReports allows the module administrator to enter SQL queries in such a way that they can be run by users in a controlled manner. The module administrator defines reports, which can consist of one or more SQL queries, known as sections. Access to a report is strictly controlled by the group permissions the module administrator assigns to it. A report can take parameters, such as a date range, if needed. The column output of a report section can be customized with a variety of formatting options. Reports can be organized into a menu system by topic, or accessed through system blocks. All of this is done without any programming required; only the creation of the SQL query is needed.

    A new auto-complete parameter type that allows you to specify a simple query that returns possible values for a parameter. When the report user enters a partial value for the parameter, the system will respond with a selection list of possible matches using jQuery UI autocomplete. (prototyped by KS Tan)

    Report sections can include a data tools option which adds the jQuery UI dataTables plugin to the report display. This enables column sorting, value filtering and pagination. (prototyped by KS Tan)

    Some possible uses include, adding visibility to data already collected within the CMS, making data from external sources visible in the CMS and providing access to archived data.

    Navigate through the articles
    Previous article Common Utilities Xoops 2.5.9
    Rating 2.33/5
    Rating: 2.3/5 (160 votes)