The SQL reporting module parses SQL statements--even complex statements with subselects--and auto-generates a sortable HTML table, a spreadsheet link, and a JPG graph.
The reporting interface is configurable to include/remove any or all of the controls. And there is also a "group by day, month, or year" dropdown box available that is not displayed here.
There are many configuration options for the graph in this module including Bar or Line types, graph and axis titles, and width and height.
EKCCMS contains so many wonderful features, it's time-consuming to show them all. So if you're in a hurry, here's a quick summary of some of the "prettiest" features:
Articles module: This module is not only useful for admin users wanting to write blogs, but can also be used for user-contributed content. It includes article comment abilities that can be configured to either allow or restrict anonymous comments. (It also has security features to prevent spambots from auto-posting comments.)
Audio/Video module: Automatically embed media into your site (MP3's, MP4's, FLV's, etc.)
Contact Us Form: Allows users to send you email, and keeps your email address hidden.
Dynamic Content module: Allows you to embed content from other websites, including the option to automatically refresh the data every few seconds (without the user having to refresh the page). In techie-terms, this module is "AJAX For Dummies."
File Explorer module: Allows you to display an "Explorer" style section on your website. Useful for those who want to offer downloadable files to their users, but don't want to constantly update the website everytime the files change.
Google Map: Easily embed a Google map from any street address.
Image Gallery: A fully-featured image gallery that auto-generates thumbnails. Includes many features such as a larger preview for the currently selected image, lightbox popup, full-image link, auto-animated slideshow, and more!
Menu module: Our menu module literally has it all, and all menus are automatically generated. Menu styles include static links, horizontal or vertical Javascript menus, auto-generated menu buttons with mouse-over highlighting, and "breadcrumbs." Any menu can include the complete site map, or just the "child" sections of the current section. Like we said, it's got it all!
RSS Feed: Syndicate content from any RSS feed right onto your website.
Search module: Our Search module provides an "in-house" search through all of your site's content, including content created by other modules (such as Articles).
SQL Reporting: We admit that this module is a bit "hi-tech" to configure (you must understand SQL). But it is a powerful tool for auto-generating spreadsheets and displaying graphs for any data you can obtain from a SQL statement. It is our bragging-right to say that this module has been used to generate reports and graphs for certain Fortune 500 executives for over five years.
Tabview control: A tabview control is useful to display a lot of information in very little screen real estate. Our tabview automatically "crunches" any section on your site into a self-contained block with clickable title tabs.
Twitter Feed module: Automatically embed your Twitter feed on your website ... all you need is your Twitter ID!
YouTube Video module: Automatically embed a YouTube video on your website ... all you need is the video ID!
See below for examples of some of these modules in action.
Articles can be entered by any registered user group that you configure, and use a simplified configuration of the WYSIWYG editor.
The Article Module can be used for anything from blog entries, news, recipes, technical help, FAQs, events...or whatever else your imagination can invent!
Optionally, articles can be expired either on a one-by-one basis, or by a global configuration option, so that once out-of-date material can "magically" disappear according to your preference!
For sites with large volumes of articles, built in pagination links make the user experience pleasant, and keep the page load time to a minimum!
Notice the (RSS) link above? Every Article Module can is configured for automatic syndication by default. Of course, this option can be disabled, as well, by simply unchecking one little box!
You can use a tabview control to fit a lot of information into a small spot! In this example, the content for this tabview control is linked to the Home section. This means that every content block on the home page automatically creates a tab in this tabview.
Tabviews can be linked to "hidden" sections, as well.
Here is the same news from the demo page, only using a slightly different configuration with "More/Less" links. The size of the article preview is configurable so you can display as much or little of the article as desired. (This module is configured to show 50 characters of preview.) Also, notice that the More/Less links use dynamic HTML to prevent having to reload the page. Lovely!
Notice the ...More...
For sites with large volumes of articles, built...More...
The Article Module can be used for ...More...
Articles can be entered by any registered user ...More...
John 8:12
Verse of the day
“[Dispute Over Jesus’ Testimony] When Jesus spoke again to the people, he said, “I am the light of the world. Whoever follows me will never walk in darkness, but will have the light of life.””
Brought to you by BibleGateway.com. Copyright (C) . All Rights Reserved.