Customization Frequently Asked Questions

How can I generate reports with or from Simple Groupware?

You can use the custom PHP include module to create a PHP based report, see this page.

You can also use a SQL query with sgsML, for example "<sgs-dir>/bin/modules/ schema_sys/nosql_processes.xml" (the query is in the "default_sql" attribute).

Another option might be to query the database directly with Eclipse Birt, Crystal Reports, JasperReports, etc.


How can I forbid folder deletion but keep rights on creating, editing and deleting elements?

You can change the required rights from "write" to "admin" in "<sgs-dir>/bin/ajax.php" (server-side) and from "rights_writeable_folder" to "rights_admin" in "<sgs-dir>/bin/ext/js/menu.js".

replace:

static function folder_delete($folder) {
self::_require_access($folder, "write");

with:

static function folder_delete($folder) {
self::_require_access($folder, "admin");

replace:

if (!no_folder_operations && rights_writeable_folder) {
...
smenuitem("{t}Delete incl subfolders{/t}","folder_delete()");

with:

if (!no_folder_operations && rights_admin) {
...
smenuitem("{t}Delete incl subfolders{/t}","folder_delete()");