HERMES: The Highly Extensible Reporting and Management Enterprise Suite<p>HERMES is an architecture under development for providing a php-based platform agnostic and database agnostic suite of tools for managing and reporting business resources.
Be the first to post a text review of HERMES PHP-Based Business Mgmt. Rate and review a project by clicking thumbs up or thumbs down in the right column.
Due to a number of issues in design choices taken early in HERMES, I have decided to abandon this project. There has never been enough community involvement to heep this running, and not enough to justify the re-engineering work that has to go on to modernize the code. Bear in mind that this was one of my first attempts at non-trivial application development and hence some problematic choices have occurred which would require a lot of effort to correct. Longer-term. I expect to be developing (either as add-ons or part of the core application) all of the HERMES functionality for LedgerSMB. In the mean time, bug fix or urgent support is still available through Metatron Technology Consulting (http://www.metatrontech.com), but community code development has ceased. If others are interested in taking over the project, feel free to ask :-)
Changes Made Since 0.4.0 * ADDED mime type 'text/html' for file attachments * FIXED debug info printed on the dispatch popup. Changes Made Since 0.3.4 * FIXED take ownership checkbox always checked. * ADDED user interface for assigning action items to others * FIXED unable to take ownership of action items * FIXED file uploads now unescape their data on retrieval, providing a cleaner interface * FIXED add_file popup not delivering focus correctly when denying submission * ADDED new MIME types, 'text/text' and 'application/octet-stream' * ADDED file attachments for customer records * ADDED file attachments for appointments * FIXED file attachments are now sent with the correct name Changes Made Since 0.3.3 * ADDED file uploads to TODO items. * ADDED customerless appointments. * FIXED time entered not displaying on forms/Customer/ToDoWork.php * ADDED database features for distribution lists (email or standard mailings) * FIXED broken time_span->incriment() function. Changes Made Since 0.3.2 * ADDED apps/objclass/web_reports which contains the web_report class. * ADDED root-level UI form Reports which manages the reports. * ADDED new labor reporting views in the olap schema. These include my_daily_labor, etc, total_daily_labor, etc, and emp_total_daily_labor. * Labor reporting views now report the number of hours worked as a double precision float rather than an interval. Changes Made Since 0.3.1 * ADDED human readible labor views named olap.emp_daily_labor, olap.emp_weekly_labor, olap.emp_monthly_labor, and emp_yearly_labor. * ADDED yearly and monthly views as well. * ADDED olap.weekly_labor view which does the same for weeks * ADDED olap.daily_labor view which lists labor by owner, type, and date * ADDED olap schema in database * ADDED group search interface * Performance Tuning on schema/shared_hosting/restrict_select * FIXED appointments not showing up. * UPDATED data-dump_pgsql.sh * ADDED interface for customerless action items * ADDED handling for queue templates in Intercom. * ADDED interface for dropping queues (must be empty). * ADDED popup interface to edit queue information/add new queues Changes Made since 0.3.0 * ADDED concept of AT's without customers. * FIXED javascript bug in forms/Customer/ToDoWork.php re: getting AT list. * FIXED State code MT pointing to Nebraska and Montana missing. * FIXED move_relation does not update pg_depend or move indexes. * ADDED admin module: QueueMgr * ADDED admin_group::GetByName now accepts an optional second argument as search mode. * FIXED SelectBox flawed comparison with default values for alphanumeric keys. * FIXED Datatype mismatch in foreign keys. * FIXED missing foreign key constraints. * ADDED new admin UI module, Queuemgr for managing queue memberships and templates. (incomplete) * ADDED new root-level UI module, Intercom for internal communications and technical support. * MOVED tables admin_groups and admin_gmember from admin module to core (necessary for group membership of queues). * ADDED function email_link for centralized management of email link behavior * ADDED function ui_header for automatically printing the headers and messages for the UI components. * ADDED DBAL_TS2Array function. Depricates ParseTimestamp() as it is easier to maintain. ParseTimestamp() is now a thin wrapper around DBAL_TS2Array(). * ADDED new UI sub-module MyWorkspace/MyQueues * ADDED css class Form_Header for use with form headers and messages * ADDED subscription code to action item model. This allows supplimental ownership. * ADDED action item queuing model code * ADDED UPGRADING doc. * MySQL is no longer supported due to reliance on subselects for subscriber model. Will reconsider when MySQL supports subselects. Changes Made since 0.3.0 Beta 3 * forms/Customer/ToDoWork now allows for time intered in 24 hr format Changes made since 0.3.0 Beta 2 * ADDED uninstall routine to the shared hosting layer. * ADDED security section to the shared hosting README. * Shared Hosting Layer now is beta-ready. * FIXED all install errors in restrict_select * ADDED pam_db_shared to authenticate when using the shared hosting layer. Changes made since 0.3.0 Beta 1 * ADDED bundled restrict_select plpgsql module for restricting selects in a shared hosting environment. This module is licensed under a more liberal BSD-style license. * ADDED hermes_shared_hosting schema for these the shared hosting layer's metatdata * ADDED installation/autoconfig routine for shared hosting layer (incomplete) Changes made since 0.3.0 Alpha 4 * REMOVED unnecessary EXECUTE statements from func.pgsql * FIXED numerous bugs relating to adding new or editing existing groups. * FIXED all parse errors in apps/scripts/admin/EditGroup.php * ADDED core API in base_api/base_func.php named hermes_if_scan() which scans for directory transversal attacks and kills the program if detected. * FIXED potential security hole allowing users to specify arbitrary scripts to be included. * FIXED numerous bugs relating to editing existing users. * UPDATED documentation in base_api/html_func * FIXED bug in hermesbase.pgsql that would fail if any diabled users exist in group when calling hermes_rebuild_group(). * FIXED parse error in func.pgsql * FIXED bug involving login screen being duplicated. * FIXED javascript bugs preventing editing or dropping of existing users. * ADDED new function in base_api/html_func named begin_form_js() (documented) * FIXED: Duplicate submissions now cut database access as advertised in Pgsql * FIXED multiple bugs regarding new user creation. * ADDED UI link to forms/Admin/UserConsole to create new group. Changes Made since 0.3.0 Alpha 3 * FIXED error-- script dying when creating calendar controls. * FIXED runaway variable construction in apps/scripts/CRM/user_search.php * FIXED javascript error on /forms/Admin/UserConsole.php * FIXED missing required file in apps/objclass/admin/user_group.obj.php * FIXED parse error in apps/objclass/admin/user_group.obj.php * FIXED missing include file error in formscripts/Admin/UserConsoleData.php * FIXED handling of hermes_make_symlinks.pl when libraries do not contain _ * FIXED numerous bugs in plt parser. * FIXED syntax error in installer when invoking the plt parser * the ical parameter attribute->class translation table has been completed Changes Made Since 0.3.0 Alpha 2 * Full skeletal classes for icalendar (RFC 2445) support (ongoing, not nearly ready for prime time) * The PLT parser is now a separate perl script in the installer. * Changed installer behavior regarding invalidly quoted inputs. * Installer now closes config.php before it starts adding the admin user. * Added 24 hr clock option to appointment forms. * FIXED serious bug: bill_amt not being saved when Action Item created. * Documentation added regarding used portions of the HERMES schemas and catalogs * Complete (untested) alpha support for shared hosting environments (not release delaying). Does NOT include a setup function. * HERMES now comes bundled with NuSOAP 0.6.4 (as lib/nusoap-0.6.4). * Updated PGSQL.README to document a common configuration issue with PostgreSQL Changes Made Since 0.3.0 Alpha 1 * Fixed all parse errors in lib/ical-0.0.1/core.php * Fixed parse error in lib/pcal_minphp-1.0.0 * Added experimental (and broken) support for PostgreSQL in shared hosting environments with a direct permissions enforcement layer. * Included a new shared hosting version of the PGSQL DLAPI. Changes since 0.2.1 * Added experimental classes for iCalendar functions in lib/ical * Rewritten User Management Tools! * Disabled return key blocking due to ease of use issues. * New User library for doing user searches etc. * Added hidden form for changing password (forms/.Password) * FIXED overwritten Admin/DBAL for MySQL. * Modified the SQLQuery in the PostgreSQL DBAL to ensure that only single statements are passed to it. * DBAL documentation updated * FAQ updated * Security Guide revised. * Inserted routines to automatically escape quotes within Get/Post/Cookie vars. * Updated PGSQL.README * Updated MYSQL.README * Revised roadmap * Updated interfaces in admin/DBAL to allow for manager fields in owners. * Updated documentation for lib/pcal * Added Documentation for Admin/DBAL * Added Documentation for the stored proceedures. * For PgSQL, moved all user management API's into stored proceedures. * PgSQL Sequences are now managed as part of the core Hermes admin module. * Administrative module class added (a_module). * Added manager column to owners table/view (reporting enhancement) * For MySQL, changed permissions on columns of user tables to provide added security. * For PgSQL added owners_user and owners_admin tables (now wrapped in updateable view). (Security change) * Added full user/group classes to wrap and extend Admin/DBAL calls. * Added module class to better support permissions access. Changes since 0.2.0 * Fixed database schema flaw which prevented user management from tools oob. * FIXED typo in error reporting in DBAL.php when connection to db fails. * lib/pcal now supports a cal_date_span object * lib/pcal cal_date now has plus(cal_date_span) and minus(cal_date_span) methods * lib/pcal cal_date now supports return_string() as the preferred alternative to ReturnString() (change for consistancy) * MAJOR DEV FEATURE: lib/pcal new function for calculating days between two cal_date objects. Changes since 0.1.3 * updated contrib/remake/remake.sh to use /etc/init.d/httpd to restart apache * Updated install.sh to provide GPL notice. * Updated PGSQL.README * Added documentation for apps/objclass/common/users.obj.php * Added documentation for apps/objclass/CRM_Appoint.obj.php * forms/MyWorkspace/Appoint now uses CRM_Appoint.obj.php classes * forms/MyWorkspace/Appoint now uses new UI model. * FIXED bug: Updating appointments causes ALL appointment information to be lost * FIXED bug: Appointment updates fail due to self-conflict. * Documented API: CRM_Action_Item::GetAppoints() * FIXED bug: Invitations not adding users to appointment. * FIXED bug: Action item association lost when date is changed using calendar * forms/Customer/AppointDetails now shows attendees' email addresses * forms/Customer/AppointDetails now uses CRM_Appoint_Attendee objects * Added api's for locating meeting attendees in database. * Added email address support for common_user class. * User invitations now use popup window (broken). Changes made since 0.1.2 * Changed default form to MyWorkspace. * FIXED forms/Customer/AppointDetails.php showing no invitees for meetings * Added feature: Now appointments can be attached to action items * Added new API's for action item/appointment integration (not yet documented) Changes made since 0.1.1p1 * FIXED trailing returns and tabs in MyWorkspace expertise field. * Changed formscripts/Customer/ToDoWorkData.php to treat a tlhour of '0' as authoritative * FIXED bugs regarding false negatives on appointment conflict detection * FIXED bugs regarding false positives on appointment conflict detection * Action Item Work form now resets time when entry is added. * Fixed errors with appointments not submitting * Moved all handling of todo item types and priorities to backend * added MySQL/PgSQL schema addition for backend priority and type tracking for action items. * Fixed bug regarding logging changed priorities in action items. Changes made since 0.1.1 * fixed bug with appointment object data type mismatch (time vs timestamp) * fixed bug with calendar control converting nonexistant hours to 24 hr format. * Fixed typo in MySQL upgrade script * Wrote mysql patch to correct mistake Changes made since 0.1.0 * Disabled allowing the return key to submit a form. Note this means you use the spacebar instead until a workaround can be found. * Appointment class now more or less formalized. * New action item type: Project container (unbilled). * index.php now includes files *after* registering its own variables * DBAL_pgsql ParseTimestamp() function now accepts timestamp without timezone * crm_appoint in pgsql now uses timestamp without timezone for timestamps Changes since 0.1.0 RC3 Fixed bug relating to country not displaying when customer added Fixed bug regarding lost search criteria on forms/Customer/Query (update button) Changes since 0.1.0 RC-2 updated INSTALL documentation Fixed stale username problem Changes since 0.1.0 RC-1 Extended installer to include the option of adding an administrative user. Fixed formatting issue with MyWorkspace/Appoint Updated FAQ regarding version number Set Customer tracking, Action Items and MyWorkspace to use Major Hyperlinks Added css support for major hyperlinks to make maintenance easier. Fixed pcal_minphp_db's cal_show_month_big() function so that the format is correct Fixed incorrectly adding zeros to minutes field in Customer/ToDoWork when represh hit Fixed formatting issues with forms/Customer/ToDoWork.php Fixed formatting issue in Windows with forms/MyWorkspace.php. Changes since 0.1.0 Beta 3: Newline/tab issues fixed with expertise field in MyWorkspace. MyWorkspace no longer depends on depricated $user_id constant. Added new permissions to the updatebeta3.pgsql script. Updated permissions for sequences in main schema to select only (for public)-- (pgsql only) Fixed password change failure with PostgreSQL. Changed db schema in-- changed crm_to_do.title from varchar(255) to text. Limit enforcement added to forms/Customers Added confirmation messages to added/saved records for Customers and Customers/ToDoWork forms/formscripts. Changes since 0.1.0 beta 2: Added GRANT ALL script (updatebeta.pgsql) for upgrading from previous betas. Added maxlength to all fields in forms/customers but these are not small enough to reflect the max in the database. This will be fixed in beta 4. Changed Customer/Query.php form to state Max records shown rather than records shown Set GRANT ALL on all sequences to PUBLIC pending the 0.3.0 work in pgsql Fixed broken HermesAddUserToGroup() in Admin/DBAL_pgsql-1.0.0 Removed globally registering cookies since this was causing some regression issues with admin tools. Fixed parse error in formscripts/Admin/User/NewData.php Updated documentation to include all stable api's. Fixed installer bug where installer does not disable itself when configuration file is not regenerated. Fixed bug in installer which created no symlinks if only one library was found. Fixed contact management classes' country handling. Fixed administrative user tracking in PostgreSQL. Fixed calendar library issues with accessing appointment information Fixed the callback script for Myworkplace/Appoint Added appointment title for MyWorkplace/Appoint Changes since 0.1.0 beta 1: Fixed todo action item tracking bug of linking to wrong customer Fixed login tracking issues. Fixed html injection vulnerabilitiy. Currently no html tags are allowed in any submissions Hermes now registers its own globals (GPCS). Change made to calendar control to allow it to work with php 4.1 pcal_db-1.0.0.php no longer supported and it is dropped Bug in retrieving customers from forms/Customer/ToDoWork fixed
Changes Made Since 0.3.4 * FIXED take ownership checkbox always checked. * ADDED user interface for assigning action items to others * FIXED unable to take ownership of action items * FIXED file uploads now unescape their data on retrieval, providing a cleaner interface * FIXED add_file popup not delivering focus correctly when denying submission * ADDED new MIME types, 'text/text' and 'application/octet-stream' * ADDED file attachments for customer records * ADDED file attachments for appointments * FIXED file attachments are now sent with the correct name Changes Made Since 0.3.3 * ADDED file uploads to TODO items. * ADDED customerless appointments. * FIXED time entered not displaying on forms/Customer/ToDoWork.php * ADDED database features for distribution lists (email or standard mailings) * FIXED broken time_span->incriment() function. Changes Made Since 0.3.2 * ADDED apps/objclass/web_reports which contains the web_report class. * ADDED root-level UI form Reports which manages the reports. * ADDED new labor reporting views in the olap schema. These include my_daily_labor, etc, total_daily_labor, etc, and emp_total_daily_labor. * Labor reporting views now report the number of hours worked as a double precision float rather than an interval. Changes Made Since 0.3.1 * ADDED human readible labor views named olap.emp_daily_labor, olap.emp_weekly_labor, olap.emp_monthly_labor, and emp_yearly_labor. * ADDED yearly and monthly views as well. * ADDED olap.weekly_labor view which does the same for weeks * ADDED olap.daily_labor view which lists labor by owner, type, and date * ADDED olap schema in database * ADDED group search interface * Performance Tuning on schema/shared_hosting/restrict_select * FIXED appointments not showing up. * UPDATED data-dump_pgsql.sh * ADDED interface for customerless action items * ADDED handling for queue templates in Intercom. * ADDED interface for dropping queues (must be empty). * ADDED popup interface to edit queue information/add new queues Changes Made since 0.3.0 * ADDED concept of AT's without customers. * FIXED javascript bug in forms/Customer/ToDoWork.php re: getting AT list. * FIXED State code MT pointing to Nebraska and Montana missing. * FIXED move_relation does not update pg_depend or move indexes. * ADDED admin module: QueueMgr * ADDED admin_group::GetByName now accepts an optional second argument as search mode. * FIXED SelectBox flawed comparison with default values for alphanumeric keys. * FIXED Datatype mismatch in foreign keys. * FIXED missing foreign key constraints. * ADDED new admin UI module, Queuemgr for managing queue memberships and templates. (incomplete) * ADDED new root-level UI module, Intercom for internal communications and technical support. * MOVED tables admin_groups and admin_gmember from admin module to core (necessary for group membership of queues). * ADDED function email_link for centralized management of email link behavior * ADDED function ui_header for automatically printing the headers and messages for the UI components. * ADDED DBAL_TS2Array function. Depricates ParseTimestamp() as it is easier to maintain. ParseTimestamp() is now a thin wrapper around DBAL_TS2Array(). * ADDED new UI sub-module MyWorkspace/MyQueues * ADDED css class Form_Header for use with form headers and messages * ADDED subscription code to action item model. This allows supplimental ownership. * ADDED action item queuing model code * ADDED UPGRADING doc. * MySQL is no longer supported due to reliance on subselects for subscriber model. Will reconsider when MySQL supports subselects. Changes Made since 0.3.0 Beta 3 * forms/Customer/ToDoWork now allows for time intered in 24 hr format Changes made since 0.3.0 Beta 2 * ADDED uninstall routine to the shared hosting layer. * ADDED security section to the shared hosting README. * Shared Hosting Layer now is beta-ready. * FIXED all install errors in restrict_select * ADDED pam_db_shared to authenticate when using the shared hosting layer. Changes made since 0.3.0 Beta 1 * ADDED bundled restrict_select plpgsql module for restricting selects in a shared hosting environment. This module is licensed under a more liberal BSD-style license. * ADDED hermes_shared_hosting schema for these the shared hosting layer's metatdata * ADDED installation/autoconfig routine for shared hosting layer (incomplete) Changes made since 0.3.0 Alpha 4 * REMOVED unnecessary EXECUTE statements from func.pgsql * FIXED numerous bugs relating to adding new or editing existing groups. * FIXED all parse errors in apps/scripts/admin/EditGroup.php * ADDED core API in base_api/base_func.php named hermes_if_scan() which scans for directory transversal attacks and kills the program if detected. * FIXED potential security hole allowing users to specify arbitrary scripts to be included. * FIXED numerous bugs relating to editing existing users. * UPDATED documentation in base_api/html_func * FIXED bug in hermesbase.pgsql that would fail if any diabled users exist in group when calling hermes_rebuild_group(). * FIXED parse error in func.pgsql * FIXED bug involving login screen being duplicated. * FIXED javascript bugs preventing editing or dropping of existing users. * ADDED new function in base_api/html_func named begin_form_js() (documented) * FIXED: Duplicate submissions now cut database access as advertised in Pgsql * FIXED multiple bugs regarding new user creation. * ADDED UI link to forms/Admin/UserConsole to create new group. Changes Made since 0.3.0 Alpha 3 * FIXED error-- script dying when creating calendar controls. * FIXED runaway variable construction in apps/scripts/CRM/user_search.php * FIXED javascript error on /forms/Admin/UserConsole.php * FIXED missing required file in apps/objclass/admin/user_group.obj.php * FIXED parse error in apps/objclass/admin/user_group.obj.php * FIXED missing include file error in formscripts/Admin/UserConsoleData.php * FIXED handling of hermes_make_symlinks.pl when libraries do not contain _ * FIXED numerous bugs in plt parser. * FIXED syntax error in installer when invoking the plt parser * the ical parameter attribute->class translation table has been completed Changes Made Since 0.3.0 Alpha 2 * Full skeletal classes for icalendar (RFC 2445) support (ongoing, not nearly ready for prime time) * The PLT parser is now a separate perl script in the installer. * Changed installer behavior regarding invalidly quoted inputs. * Installer now closes config.php before it starts adding the admin user. * Added 24 hr clock option to appointment forms. * FIXED serious bug: bill_amt not being saved when Action Item created. * Documentation added regarding used portions of the HERMES schemas and catalogs * Complete (untested) alpha support for shared hosting environments (not release delaying). Does NOT include a setup function. * HERMES now comes bundled with NuSOAP 0.6.4 (as lib/nusoap-0.6.4). * Updated PGSQL.README to document a common configuration issue with PostgreSQL Changes Made Since 0.3.0 Alpha 1 * Fixed all parse errors in lib/ical-0.0.1/core.php * Fixed parse error in lib/pcal_minphp-1.0.0 * Added experimental (and broken) support for PostgreSQL in shared hosting environments with a direct permissions enforcement layer. * Included a new shared hosting version of the PGSQL DLAPI. Changes since 0.2.1 * Added experimental classes for iCalendar functions in lib/ical * Rewritten User Management Tools! * Disabled return key blocking due to ease of use issues. * New User library for doing user searches etc. * Added hidden form for changing password (forms/.Password) * FIXED overwritten Admin/DBAL for MySQL. * Modified the SQLQuery in the PostgreSQL DBAL to ensure that only single statements are passed to it. * DBAL documentation updated * FAQ updated * Security Guide revised. * Inserted routines to automatically escape quotes within Get/Post/Cookie vars. * Updated PGSQL.README * Updated MYSQL.README * Revised roadmap * Updated interfaces in admin/DBAL to allow for manager fields in owners. * Updated documentation for lib/pcal * Added Documentation for Admin/DBAL * Added Documentation for the stored proceedures. * For PgSQL, moved all user management API's into stored proceedures. * PgSQL Sequences are now managed as part of the core Hermes admin module. * Administrative module class added (a_module). * Added manager column to owners table/view (reporting enhancement) * For MySQL, changed permissions on columns of user tables to provide added security. * For PgSQL added owners_user and owners_admin tables (now wrapped in updateable view). (Security change) * Added full user/group classes to wrap and extend Admin/DBAL calls. * Added module class to better support permissions access. Changes since 0.2.0 * Fixed database schema flaw which prevented user management from tools oob. * FIXED typo in error reporting in DBAL.php when connection to db fails. * lib/pcal now supports a cal_date_span object * lib/pcal cal_date now has plus(cal_date_span) and minus(cal_date_span) methods * lib/pcal cal_date now supports return_string() as the preferred alternative to ReturnString() (change for consistancy) * MAJOR DEV FEATURE: lib/pcal new function for calculating days between two cal_date objects. Changes since 0.1.3 * updated contrib/remake/remake.sh to use /etc/init.d/httpd to restart apache * Updated install.sh to provide GPL notice. * Updated PGSQL.README * Added documentation for apps/objclass/common/users.obj.php * Added documentation for apps/objclass/CRM_Appoint.obj.php * forms/MyWorkspace/Appoint now uses CRM_Appoint.obj.php classes * forms/MyWorkspace/Appoint now uses new UI model. * FIXED bug: Updating appointments causes ALL appointment information to be lost * FIXED bug: Appointment updates fail due to self-conflict. * Documented API: CRM_Action_Item::GetAppoints() * FIXED bug: Invitations not adding users to appointment. * FIXED bug: Action item association lost when date is changed using calendar * forms/Customer/AppointDetails now shows attendees' email addresses * forms/Customer/AppointDetails now uses CRM_Appoint_Attendee objects * Added api's for locating meeting attendees in database. * Added email address support for common_user class. * User invitations now use popup window (broken). Changes made since 0.1.2 * Changed default form to MyWorkspace. * FIXED forms/Customer/AppointDetails.php showing no invitees for meetings * Added feature: Now appointments can be attached to action items * Added new API's for action item/appointment integration (not yet documented) Changes made since 0.1.1p1 * FIXED trailing returns and tabs in MyWorkspace expertise field. * Changed formscripts/Customer/ToDoWorkData.php to treat a tlhour of '0' as authoritative * FIXED bugs regarding false negatives on appointment conflict detection * FIXED bugs regarding false positives on appointment conflict detection * Action Item Work form now resets time when entry is added. * Fixed errors with appointments not submitting * Moved all handling of todo item types and priorities to backend * added MySQL/PgSQL schema addition for backend priority and type tracking for action items. * Fixed bug regarding logging changed priorities in action items. Changes made since 0.1.1 * fixed bug with appointment object data type mismatch (time vs timestamp) * fixed bug with calendar control converting nonexistant hours to 24 hr format. * Fixed typo in MySQL upgrade script * Wrote mysql patch to correct mistake Changes made since 0.1.0 * Disabled allowing the return key to submit a form. Note this means you use the spacebar instead until a workaround can be found. * Appointment class now more or less formalized. * New action item type: Project container (unbilled). * index.php now includes files *after* registering its own variables * DBAL_pgsql ParseTimestamp() function now accepts timestamp without timezone * crm_appoint in pgsql now uses timestamp without timezone for timestamps Changes since 0.1.0 RC3 Fixed bug relating to country not displaying when customer added Fixed bug regarding lost search criteria on forms/Customer/Query (update button) Changes since 0.1.0 RC-2 updated INSTALL documentation Fixed stale username problem Changes since 0.1.0 RC-1 Extended installer to include the option of adding an administrative user. Fixed formatting issue with MyWorkspace/Appoint Updated FAQ regarding version number Set Customer tracking, Action Items and MyWorkspace to use Major Hyperlinks Added css support for major hyperlinks to make maintenance easier. Fixed pcal_minphp_db's cal_show_month_big() function so that the format is correct Fixed incorrectly adding zeros to minutes field in Customer/ToDoWork when represh hit Fixed formatting issues with forms/Customer/ToDoWork.php Fixed formatting issue in Windows with forms/MyWorkspace.php. Changes since 0.1.0 Beta 3: Newline/tab issues fixed with expertise field in MyWorkspace. MyWorkspace no longer depends on depricated $user_id constant. Added new permissions to the updatebeta3.pgsql script. Updated permissions for sequences in main schema to select only (for public)-- (pgsql only) Fixed password change failure with PostgreSQL. Changed db schema in-- changed crm_to_do.title from varchar(255) to text. Limit enforcement added to forms/Customers Added confirmation messages to added/saved records for Customers and Customers/ToDoWork forms/formscripts. Changes since 0.1.0 beta 2: Added GRANT ALL script (updatebeta.pgsql) for upgrading from previous betas. Added maxlength to all fields in forms/customers but these are not small enough to reflect the max in the database. This will be fixed in beta 4. Changed Customer/Query.php form to state Max records shown rather than records shown Set GRANT ALL on all sequences to PUBLIC pending the 0.3.0 work in pgsql Fixed broken HermesAddUserToGroup() in Admin/DBAL_pgsql-1.0.0 Removed globally registering cookies since this was causing some regression issues with admin tools. Fixed parse error in formscripts/Admin/User/NewData.php Updated documentation to include all stable api's. Fixed installer bug where installer does not disable itself when configuration file is not regenerated. Fixed bug in installer which created no symlinks if only one library was found. Fixed contact management classes' country handling. Fixed administrative user tracking in PostgreSQL. Fixed calendar library issues with accessing appointment information Fixed the callback script for Myworkplace/Appoint Added appointment title for MyWorkplace/Appoint Changes since 0.1.0 beta 1: Fixed todo action item tracking bug of linking to wrong customer Fixed login tracking issues. Fixed html injection vulnerabilitiy. Currently no html tags are allowed in any submissions Hermes now registers its own globals (GPCS). Change made to calendar control to allow it to work with php 4.1 pcal_db-1.0.0.php no longer supported and it is dropped Bug in retrieving customers from forms/Customer/ToDoWork fixed
Changes Made Since 0.3.3 * ADDED file uploads to TODO items. * ADDED customerless appointments. * FIXED time entered not displaying on forms/Customer/ToDoWork.php * ADDED database features for distribution lists (email or standard mailings) * FIXED broken time_span->incriment() function. Changes Made Since 0.3.2 * ADDED apps/objclass/web_reports which contains the web_report class. * ADDED root-level UI form Reports which manages the reports. * ADDED new labor reporting views in the olap schema. These include my_daily_labor, etc, total_daily_labor, etc, and emp_total_daily_labor. * Labor reporting views now report the number of hours worked as a double precision float rather than an interval. Changes Made Since 0.3.1 * ADDED human readible labor views named olap.emp_daily_labor, olap.emp_weekly_labor, olap.emp_monthly_labor, and emp_yearly_labor. * ADDED yearly and monthly views as well. * ADDED olap.weekly_labor view which does the same for weeks * ADDED olap.daily_labor view which lists labor by owner, type, and date * ADDED olap schema in database * ADDED group search interface * Performance Tuning on schema/shared_hosting/restrict_select * FIXED appointments not showing up. * UPDATED data-dump_pgsql.sh * ADDED interface for customerless action items * ADDED handling for queue templates in Intercom. * ADDED interface for dropping queues (must be empty). * ADDED popup interface to edit queue information/add new queues Changes Made since 0.3.0 * ADDED concept of AT's without customers. * FIXED javascript bug in forms/Customer/ToDoWork.php re: getting AT list. * FIXED State code MT pointing to Nebraska and Montana missing. * FIXED move_relation does not update pg_depend or move indexes. * ADDED admin module: QueueMgr * ADDED admin_group::GetByName now accepts an optional second argument as search mode. * FIXED SelectBox flawed comparison with default values for alphanumeric keys. * FIXED Datatype mismatch in foreign keys. * FIXED missing foreign key constraints. * ADDED new admin UI module, Queuemgr for managing queue memberships and templates. (incomplete) * ADDED new root-level UI module, Intercom for internal communications and technical support. * MOVED tables admin_groups and admin_gmember from admin module to core (necessary for group membership of queues). * ADDED function email_link for centralized management of email link behavior * ADDED function ui_header for automatically printing the headers and messages for the UI components. * ADDED DBAL_TS2Array function. Depricates ParseTimestamp() as it is easier to maintain. ParseTimestamp() is now a thin wrapper around DBAL_TS2Array(). * ADDED new UI sub-module MyWorkspace/MyQueues * ADDED css class Form_Header for use with form headers and messages * ADDED subscription code to action item model. This allows supplimental ownership. * ADDED action item queuing model code * ADDED UPGRADING doc. * MySQL is no longer supported due to reliance on subselects for subscriber model. Will reconsider when MySQL supports subselects. Changes Made since 0.3.0 Beta 3 * forms/Customer/ToDoWork now allows for time intered in 24 hr format Changes made since 0.3.0 Beta 2 * ADDED uninstall routine to the shared hosting layer. * ADDED security section to the shared hosting README. * Shared Hosting Layer now is beta-ready. * FIXED all install errors in restrict_select * ADDED pam_db_shared to authenticate when using the shared hosting layer. Changes made since 0.3.0 Beta 1 * ADDED bundled restrict_select plpgsql module for restricting selects in a shared hosting environment. This module is licensed under a more liberal BSD-style license. * ADDED hermes_shared_hosting schema for these the shared hosting layer's metatdata * ADDED installation/autoconfig routine for shared hosting layer (incomplete) Changes made since 0.3.0 Alpha 4 * REMOVED unnecessary EXECUTE statements from func.pgsql * FIXED numerous bugs relating to adding new or editing existing groups. * FIXED all parse errors in apps/scripts/admin/EditGroup.php * ADDED core API in base_api/base_func.php named hermes_if_scan() which scans for directory transversal attacks and kills the program if detected. * FIXED potential security hole allowing users to specify arbitrary scripts to be included. * FIXED numerous bugs relating to editing existing users. * UPDATED documentation in base_api/html_func * FIXED bug in hermesbase.pgsql that would fail if any diabled users exist in group when calling hermes_rebuild_group(). * FIXED parse error in func.pgsql * FIXED bug involving login screen being duplicated. * FIXED javascript bugs preventing editing or dropping of existing users. * ADDED new function in base_api/html_func named begin_form_js() (documented) * FIXED: Duplicate submissions now cut database access as advertised in Pgsql * FIXED multiple bugs regarding new user creation. * ADDED UI link to forms/Admin/UserConsole to create new group. Changes Made since 0.3.0 Alpha 3 * FIXED error-- script dying when creating calendar controls. * FIXED runaway variable construction in apps/scripts/CRM/user_search.php * FIXED javascript error on /forms/Admin/UserConsole.php * FIXED missing required file in apps/objclass/admin/user_group.obj.php * FIXED parse error in apps/objclass/admin/user_group.obj.php * FIXED missing include file error in formscripts/Admin/UserConsoleData.php * FIXED handling of hermes_make_symlinks.pl when libraries do not contain _ * FIXED numerous bugs in plt parser. * FIXED syntax error in installer when invoking the plt parser * the ical parameter attribute->class translation table has been completed Changes Made Since 0.3.0 Alpha 2 * Full skeletal classes for icalendar (RFC 2445) support (ongoing, not nearly ready for prime time) * The PLT parser is now a separate perl script in the installer. * Changed installer behavior regarding invalidly quoted inputs. * Installer now closes config.php before it starts adding the admin user. * Added 24 hr clock option to appointment forms. * FIXED serious bug: bill_amt not being saved when Action Item created. * Documentation added regarding used portions of the HERMES schemas and catalogs * Complete (untested) alpha support for shared hosting environments (not release delaying). Does NOT include a setup function. * HERMES now comes bundled with NuSOAP 0.6.4 (as lib/nusoap-0.6.4). * Updated PGSQL.README to document a common configuration issue with PostgreSQL Changes Made Since 0.3.0 Alpha 1 * Fixed all parse errors in lib/ical-0.0.1/core.php * Fixed parse error in lib/pcal_minphp-1.0.0 * Added experimental (and broken) support for PostgreSQL in shared hosting environments with a direct permissions enforcement layer. * Included a new shared hosting version of the PGSQL DLAPI. Changes since 0.2.1 * Added experimental classes for iCalendar functions in lib/ical * Rewritten User Management Tools! * Disabled return key blocking due to ease of use issues. * New User library for doing user searches etc. * Added hidden form for changing password (forms/.Password) * FIXED overwritten Admin/DBAL for MySQL. * Modified the SQLQuery in the PostgreSQL DBAL to ensure that only single statements are passed to it. * DBAL documentation updated * FAQ updated * Security Guide revised. * Inserted routines to automatically escape quotes within Get/Post/Cookie vars. * Updated PGSQL.README * Updated MYSQL.README * Revised roadmap * Updated interfaces in admin/DBAL to allow for manager fields in owners. * Updated documentation for lib/pcal * Added Documentation for Admin/DBAL * Added Documentation for the stored proceedures. * For PgSQL, moved all user management API's into stored proceedures. * PgSQL Sequences are now managed as part of the core Hermes admin module. * Administrative module class added (a_module). * Added manager column to owners table/view (reporting enhancement) * For MySQL, changed permissions on columns of user tables to provide added security. * For PgSQL added owners_user and owners_admin tables (now wrapped in updateable view). (Security change) * Added full user/group classes to wrap and extend Admin/DBAL calls. * Added module class to better support permissions access. Changes since 0.2.0 * Fixed database schema flaw which prevented user management from tools oob. * FIXED typo in error reporting in DBAL.php when connection to db fails. * lib/pcal now supports a cal_date_span object * lib/pcal cal_date now has plus(cal_date_span) and minus(cal_date_span) methods * lib/pcal cal_date now supports return_string() as the preferred alternative to ReturnString() (change for consistancy) * MAJOR DEV FEATURE: lib/pcal new function for calculating days between two cal_date objects. Changes since 0.1.3 * updated contrib/remake/remake.sh to use /etc/init.d/httpd to restart apache * Updated install.sh to provide GPL notice. * Updated PGSQL.README * Added documentation for apps/objclass/common/users.obj.php * Added documentation for apps/objclass/CRM_Appoint.obj.php * forms/MyWorkspace/Appoint now uses CRM_Appoint.obj.php classes * forms/MyWorkspace/Appoint now uses new UI model. * FIXED bug: Updating appointments causes ALL appointment information to be lost * FIXED bug: Appointment updates fail due to self-conflict. * Documented API: CRM_Action_Item::GetAppoints() * FIXED bug: Invitations not adding users to appointment. * FIXED bug: Action item association lost when date is changed using calendar * forms/Customer/AppointDetails now shows attendees' email addresses * forms/Customer/AppointDetails now uses CRM_Appoint_Attendee objects * Added api's for locating meeting attendees in database. * Added email address support for common_user class. * User invitations now use popup window (broken). Changes made since 0.1.2 * Changed default form to MyWorkspace. * FIXED forms/Customer/AppointDetails.php showing no invitees for meetings * Added feature: Now appointments can be attached to action items * Added new API's for action item/appointment integration (not yet documented) Changes made since 0.1.1p1 * FIXED trailing returns and tabs in MyWorkspace expertise field. * Changed formscripts/Customer/ToDoWorkData.php to treat a tlhour of '0' as authoritative * FIXED bugs regarding false negatives on appointment conflict detection * FIXED bugs regarding false positives on appointment conflict detection * Action Item Work form now resets time when entry is added. * Fixed errors with appointments not submitting * Moved all handling of todo item types and priorities to backend * added MySQL/PgSQL schema addition for backend priority and type tracking for action items. * Fixed bug regarding logging changed priorities in action items. Changes made since 0.1.1 * fixed bug with appointment object data type mismatch (time vs timestamp) * fixed bug with calendar control converting nonexistant hours to 24 hr format. * Fixed typo in MySQL upgrade script * Wrote mysql patch to correct mistake Changes made since 0.1.0 * Disabled allowing the return key to submit a form. Note this means you use the spacebar instead until a workaround can be found. * Appointment class now more or less formalized. * New action item type: Project container (unbilled). * index.php now includes files *after* registering its own variables * DBAL_pgsql ParseTimestamp() function now accepts timestamp without timezone * crm_appoint in pgsql now uses timestamp without timezone for timestamps Changes since 0.1.0 RC3 Fixed bug relating to country not displaying when customer added Fixed bug regarding lost search criteria on forms/Customer/Query (update button) Changes since 0.1.0 RC-2 updated INSTALL documentation Fixed stale username problem Changes since 0.1.0 RC-1 Extended installer to include the option of adding an administrative user. Fixed formatting issue with MyWorkspace/Appoint Updated FAQ regarding version number Set Customer tracking, Action Items and MyWorkspace to use Major Hyperlinks Added css support for major hyperlinks to make maintenance easier. Fixed pcal_minphp_db's cal_show_month_big() function so that the format is correct Fixed incorrectly adding zeros to minutes field in Customer/ToDoWork when represh hit Fixed formatting issues with forms/Customer/ToDoWork.php Fixed formatting issue in Windows with forms/MyWorkspace.php. Changes since 0.1.0 Beta 3: Newline/tab issues fixed with expertise field in MyWorkspace. MyWorkspace no longer depends on depricated $user_id constant. Added new permissions to the updatebeta3.pgsql script. Updated permissions for sequences in main schema to select only (for public)-- (pgsql only) Fixed password change failure with PostgreSQL. Changed db schema in-- changed crm_to_do.title from varchar(255) to text. Limit enforcement added to forms/Customers Added confirmation messages to added/saved records for Customers and Customers/ToDoWork forms/formscripts. Changes since 0.1.0 beta 2: Added GRANT ALL script (updatebeta.pgsql) for upgrading from previous betas. Added maxlength to all fields in forms/customers but these are not small enough to reflect the max in the database. This will be fixed in beta 4. Changed Customer/Query.php form to state Max records shown rather than records shown Set GRANT ALL on all sequences to PUBLIC pending the 0.3.0 work in pgsql Fixed broken HermesAddUserToGroup() in Admin/DBAL_pgsql-1.0.0 Removed globally registering cookies since this was causing some regression issues with admin tools. Fixed parse error in formscripts/Admin/User/NewData.php Updated documentation to include all stable api's. Fixed installer bug where installer does not disable itself when configuration file is not regenerated. Fixed bug in installer which created no symlinks if only one library was found. Fixed contact management classes' country handling. Fixed administrative user tracking in PostgreSQL. Fixed calendar library issues with accessing appointment information Fixed the callback script for Myworkplace/Appoint Added appointment title for MyWorkplace/Appoint Changes since 0.1.0 beta 1: Fixed todo action item tracking bug of linking to wrong customer Fixed login tracking issues. Fixed html injection vulnerabilitiy. Currently no html tags are allowed in any submissions Hermes now registers its own globals (GPCS). Change made to calendar control to allow it to work with php 4.1 pcal_db-1.0.0.php no longer supported and it is dropped Bug in retrieving customers from forms/Customer/ToDoWork fixed
Changes Made Since 0.3.2 * ADDED apps/objclass/web_reports which contains the web_report class. * ADDED root-level UI form Reports which manages the reports. * ADDED new labor reporting views in the olap schema. These include my_daily_labor, etc, total_daily_labor, etc, and emp_total_daily_labor. * Labor reporting views now report the number of hours worked as a double precision float rather than an interval. Changes Made Since 0.3.1 * ADDED human readible labor views named olap.emp_daily_labor, olap.emp_weekly_labor, olap.emp_monthly_labor, and emp_yearly_labor. * ADDED yearly and monthly views as well. * ADDED olap.weekly_labor view which does the same for weeks * ADDED olap.daily_labor view which lists labor by owner, type, and date * ADDED olap schema in database * ADDED group search interface * Performance Tuning on schema/shared_hosting/restrict_select * FIXED appointments not showing up. * UPDATED data-dump_pgsql.sh * ADDED interface for customerless action items * ADDED handling for queue templates in Intercom. * ADDED interface for dropping queues (must be empty). * ADDED popup interface to edit queue information/add new queues Changes Made since 0.3.0 * ADDED concept of AT's without customers. * FIXED javascript bug in forms/Customer/ToDoWork.php re: getting AT list. * FIXED State code MT pointing to Nebraska and Montana missing. * FIXED move_relation does not update pg_depend or move indexes. * ADDED admin module: QueueMgr * ADDED admin_group::GetByName now accepts an optional second argument as search mode. * FIXED SelectBox flawed comparison with default values for alphanumeric keys. * FIXED Datatype mismatch in foreign keys. * FIXED missing foreign key constraints. * ADDED new admin UI module, Queuemgr for managing queue memberships and templates. (incomplete) * ADDED new root-level UI module, Intercom for internal communications and technical support. * MOVED tables admin_groups and admin_gmember from admin module to core (necessary for group membership of queues). * ADDED function email_link for centralized management of email link behavior * ADDED function ui_header for automatically printing the headers and messages for the UI components. * ADDED DBAL_TS2Array function. Depricates ParseTimestamp() as it is easier to maintain. ParseTimestamp() is now a thin wrapper around DBAL_TS2Array(). * ADDED new UI sub-module MyWorkspace/MyQueues * ADDED css class Form_Header for use with form headers and messages * ADDED subscription code to action item model. This allows supplimental ownership. * ADDED action item queuing model code * ADDED UPGRADING doc. * MySQL is no longer supported due to reliance on subselects for subscriber model. Will reconsider when MySQL supports subselects. Changes Made since 0.3.0 Beta 3 * forms/Customer/ToDoWork now allows for time intered in 24 hr format Changes made since 0.3.0 Beta 2 * ADDED uninstall routine to the shared hosting layer. * ADDED security section to the shared hosting README. * Shared Hosting Layer now is beta-ready. * FIXED all install errors in restrict_select * ADDED pam_db_shared to authenticate when using the shared hosting layer. Changes made since 0.3.0 Beta 1 * ADDED bundled restrict_select plpgsql module for restricting selects in a shared hosting environment. This module is licensed under a more liberal BSD-style license. * ADDED hermes_shared_hosting schema for these the shared hosting layer's metatdata * ADDED installation/autoconfig routine for shared hosting layer (incomplete) Changes made since 0.3.0 Alpha 4 * REMOVED unnecessary EXECUTE statements from func.pgsql * FIXED numerous bugs relating to adding new or editing existing groups. * FIXED all parse errors in apps/scripts/admin/EditGroup.php * ADDED core API in base_api/base_func.php named hermes_if_scan() which scans for directory transversal attacks and kills the program if detected. * FIXED potential security hole allowing users to specify arbitrary scripts to be included. * FIXED numerous bugs relating to editing existing users. * UPDATED documentation in base_api/html_func * FIXED bug in hermesbase.pgsql that would fail if any diabled users exist in group when calling hermes_rebuild_group(). * FIXED parse error in func.pgsql * FIXED bug involving login screen being duplicated. * FIXED javascript bugs preventing editing or dropping of existing users. * ADDED new function in base_api/html_func named begin_form_js() (documented) * FIXED: Duplicate submissions now cut database access as advertised in Pgsql * FIXED multiple bugs regarding new user creation. * ADDED UI link to forms/Admin/UserConsole to create new group. Changes Made since 0.3.0 Alpha 3 * FIXED error-- script dying when creating calendar controls. * FIXED runaway variable construction in apps/scripts/CRM/user_search.php * FIXED javascript error on /forms/Admin/UserConsole.php * FIXED missing required file in apps/objclass/admin/user_group.obj.php * FIXED parse error in apps/objclass/admin/user_group.obj.php * FIXED missing include file error in formscripts/Admin/UserConsoleData.php * FIXED handling of hermes_make_symlinks.pl when libraries do not contain _ * FIXED numerous bugs in plt parser. * FIXED syntax error in installer when invoking the plt parser * the ical parameter attribute->class translation table has been completed Changes Made Since 0.3.0 Alpha 2 * Full skeletal classes for icalendar (RFC 2445) support (ongoing, not nearly ready for prime time) * The PLT parser is now a separate perl script in the installer. * Changed installer behavior regarding invalidly quoted inputs. * Installer now closes config.php before it starts adding the admin user. * Added 24 hr clock option to appointment forms. * FIXED serious bug: bill_amt not being saved when Action Item created. * Documentation added regarding used portions of the HERMES schemas and catalogs * Complete (untested) alpha support for shared hosting environments (not release delaying). Does NOT include a setup function. * HERMES now comes bundled with NuSOAP 0.6.4 (as lib/nusoap-0.6.4). * Updated PGSQL.README to document a common configuration issue with PostgreSQL Changes Made Since 0.3.0 Alpha 1 * Fixed all parse errors in lib/ical-0.0.1/core.php * Fixed parse error in lib/pcal_minphp-1.0.0 * Added experimental (and broken) support for PostgreSQL in shared hosting environments with a direct permissions enforcement layer. * Included a new shared hosting version of the PGSQL DLAPI. Changes since 0.2.1 * Added experimental classes for iCalendar functions in lib/ical * Rewritten User Management Tools! * Disabled return key blocking due to ease of use issues. * New User library for doing user searches etc. * Added hidden form for changing password (forms/.Password) * FIXED overwritten Admin/DBAL for MySQL. * Modified the SQLQuery in the PostgreSQL DBAL to ensure that only single statements are passed to it. * DBAL documentation updated * FAQ updated * Security Guide revised. * Inserted routines to automatically escape quotes within Get/Post/Cookie vars. * Updated PGSQL.README * Updated MYSQL.README * Revised roadmap * Updated interfaces in admin/DBAL to allow for manager fields in owners. * Updated documentation for lib/pcal * Added Documentation for Admin/DBAL * Added Documentation for the stored proceedures. * For PgSQL, moved all user management API's into stored proceedures. * PgSQL Sequences are now managed as part of the core Hermes admin module. * Administrative module class added (a_module). * Added manager column to owners table/view (reporting enhancement) * For MySQL, changed permissions on columns of user tables to provide added security. * For PgSQL added owners_user and owners_admin tables (now wrapped in updateable view). (Security change) * Added full user/group classes to wrap and extend Admin/DBAL calls. * Added module class to better support permissions access. Changes since 0.2.0 * Fixed database schema flaw which prevented user management from tools oob. * FIXED typo in error reporting in DBAL.php when connection to db fails. * lib/pcal now supports a cal_date_span object * lib/pcal cal_date now has plus(cal_date_span) and minus(cal_date_span) methods * lib/pcal cal_date now supports return_string() as the preferred alternative to ReturnString() (change for consistancy) * MAJOR DEV FEATURE: lib/pcal new function for calculating days between two cal_date objects. Changes since 0.1.3 * updated contrib/remake/remake.sh to use /etc/init.d/httpd to restart apache * Updated install.sh to provide GPL notice. * Updated PGSQL.README * Added documentation for apps/objclass/common/users.obj.php * Added documentation for apps/objclass/CRM_Appoint.obj.php * forms/MyWorkspace/Appoint now uses CRM_Appoint.obj.php classes * forms/MyWorkspace/Appoint now uses new UI model. * FIXED bug: Updating appointments causes ALL appointment information to be lost * FIXED bug: Appointment updates fail due to self-conflict. * Documented API: CRM_Action_Item::GetAppoints() * FIXED bug: Invitations not adding users to appointment. * FIXED bug: Action item association lost when date is changed using calendar * forms/Customer/AppointDetails now shows attendees' email addresses * forms/Customer/AppointDetails now uses CRM_Appoint_Attendee objects * Added api's for locating meeting attendees in database. * Added email address support for common_user class. * User invitations now use popup window (broken). Changes made since 0.1.2 * Changed default form to MyWorkspace. * FIXED forms/Customer/AppointDetails.php showing no invitees for meetings * Added feature: Now appointments can be attached to action items * Added new API's for action item/appointment integration (not yet documented) Changes made since 0.1.1p1 * FIXED trailing returns and tabs in MyWorkspace expertise field. * Changed formscripts/Customer/ToDoWorkData.php to treat a tlhour of '0' as authoritative * FIXED bugs regarding false negatives on appointment conflict detection * FIXED bugs regarding false positives on appointment conflict detection * Action Item Work form now resets time when entry is added. * Fixed errors with appointments not submitting * Moved all handling of todo item types and priorities to backend * added MySQL/PgSQL schema addition for backend priority and type tracking for action items. * Fixed bug regarding logging changed priorities in action items. Changes made since 0.1.1 * fixed bug with appointment object data type mismatch (time vs timestamp) * fixed bug with calendar control converting nonexistant hours to 24 hr format. * Fixed typo in MySQL upgrade script * Wrote mysql patch to correct mistake Changes made since 0.1.0 * Disabled allowing the return key to submit a form. Note this means you use the spacebar instead until a workaround can be found. * Appointment class now more or less formalized. * New action item type: Project container (unbilled). * index.php now includes files *after* registering its own variables * DBAL_pgsql ParseTimestamp() function now accepts timestamp without timezone * crm_appoint in pgsql now uses timestamp without timezone for timestamps Changes since 0.1.0 RC3 Fixed bug relating to country not displaying when customer added Fixed bug regarding lost search criteria on forms/Customer/Query (update button) Changes since 0.1.0 RC-2 updated INSTALL documentation Fixed stale username problem Changes since 0.1.0 RC-1 Extended installer to include the option of adding an administrative user. Fixed formatting issue with MyWorkspace/Appoint Updated FAQ regarding version number Set Customer tracking, Action Items and MyWorkspace to use Major Hyperlinks Added css support for major hyperlinks to make maintenance easier. Fixed pcal_minphp_db's cal_show_month_big() function so that the format is correct Fixed incorrectly adding zeros to minutes field in Customer/ToDoWork when represh hit Fixed formatting issues with forms/Customer/ToDoWork.php Fixed formatting issue in Windows with forms/MyWorkspace.php. Changes since 0.1.0 Beta 3: Newline/tab issues fixed with expertise field in MyWorkspace. MyWorkspace no longer depends on depricated $user_id constant. Added new permissions to the updatebeta3.pgsql script. Updated permissions for sequences in main schema to select only (for public)-- (pgsql only) Fixed password change failure with PostgreSQL. Changed db schema in-- changed crm_to_do.title from varchar(255) to text. Limit enforcement added to forms/Customers Added confirmation messages to added/saved records for Customers and Customers/ToDoWork forms/formscripts. Changes since 0.1.0 beta 2: Added GRANT ALL script (updatebeta.pgsql) for upgrading from previous betas. Added maxlength to all fields in forms/customers but these are not small enough to reflect the max in the database. This will be fixed in beta 4. Changed Customer/Query.php form to state Max records shown rather than records shown Set GRANT ALL on all sequences to PUBLIC pending the 0.3.0 work in pgsql Fixed broken HermesAddUserToGroup() in Admin/DBAL_pgsql-1.0.0 Removed globally registering cookies since this was causing some regression issues with admin tools. Fixed parse error in formscripts/Admin/User/NewData.php Updated documentation to include all stable api's. Fixed installer bug where installer does not disable itself when configuration file is not regenerated. Fixed bug in installer which created no symlinks if only one library was found. Fixed contact management classes' country handling. Fixed administrative user tracking in PostgreSQL. Fixed calendar library issues with accessing appointment information Fixed the callback script for Myworkplace/Appoint Added appointment title for MyWorkplace/Appoint Changes since 0.1.0 beta 1: Fixed todo action item tracking bug of linking to wrong customer Fixed login tracking issues. Fixed html injection vulnerabilitiy. Currently no html tags are allowed in any submissions Hermes now registers its own globals (GPCS). Change made to calendar control to allow it to work with php 4.1 pcal_db-1.0.0.php no longer supported and it is dropped Bug in retrieving customers from forms/Customer/ToDoWork fixed
Be the first person to add a text review.
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?