Joey Schulze [Wed, 6 Apr 2016 17:36:22 +0000 (19:36 +0200)]
Implement Hallinta.showMsg(text, opts) and use it
Joey Schulze [Tue, 5 Apr 2016 19:00:55 +0000 (21:00 +0200)]
Optimise secondary grid handling
Joey Schulze [Sat, 12 Dec 2015 17:14:01 +0000 (18:14 +0100)]
Update grid after removing a record
Joey Schulze [Sat, 12 Dec 2015 17:12:45 +0000 (18:12 +0100)]
Update masks to new framework
Joey Schulze [Sat, 14 Nov 2015 22:34:56 +0000 (23:34 +0100)]
Support exact matches for integer columns with PostgreSQL
Joey Schulze [Sat, 14 Nov 2015 22:29:59 +0000 (23:29 +0100)]
For even more completeness specifying t=6 for exact searches.
Joey Schulze [Sat, 14 Nov 2015 21:22:17 +0000 (22:22 +0100)]
Reapply part of
5e4a2d454a356671e7b5d53517293e921e0cecfb for rico3
Add support for programmer provided DISTINCT query
This query is required for TableColumn.lookup grid column controls.
The user provided query can use a different sort order which may
be more useful for humans since it can be sorted by the name instead
of the id.
The automatically calculated query would be something like
SELECT DISTINCT type FROM doc_files ORDER BY type
-- where type is an integer column connected with doc_types.id
The user provided query could add more useful sorting such as
SELECT DISTINCT type,name FROM doc_files JOIN doc_types ON type = doc_types.id ORDER BY name
The user provided query is read from the session
$_SESSION[$id.'_distinct_'.$distinct]
where $distinct is the column number.
Joey Schulze [Thu, 12 Nov 2015 16:49:08 +0000 (17:49 +0100)]
Move grid backend to new rico version 3
Joey Schulze [Thu, 12 Nov 2015 15:18:14 +0000 (16:18 +0100)]
Close dialog after saving a new item
Joey Schulze [Thu, 12 Nov 2015 13:27:10 +0000 (14:27 +0100)]
Improve error message
Joey Schulze [Thu, 12 Nov 2015 13:26:44 +0000 (14:26 +0100)]
Reenable and improve custom grid menus
Joey Schulze [Sun, 8 Nov 2015 22:30:39 +0000 (23:30 +0100)]
Switch grid booting to AJAX/Javascript, allow multiple secondary lists
Joey Schulze [Sun, 25 Oct 2015 21:18:07 +0000 (22:18 +0100)]
Position menu popup next to menu icon
Joey Schulze [Sun, 25 Oct 2015 21:17:49 +0000 (22:17 +0100)]
Add background for datepicker
Joey Schulze [Sat, 10 Oct 2015 14:53:45 +0000 (16:53 +0200)]
Move JS code to page bottom, move login code into files
Joey Schulze [Sat, 10 Oct 2015 14:52:03 +0000 (16:52 +0200)]
Switch to jQuery onLoad
Joey Schulze [Sat, 10 Oct 2015 14:51:32 +0000 (16:51 +0200)]
Return only associative array
Joey Schulze [Sat, 3 Oct 2015 09:36:24 +0000 (11:36 +0200)]
Split post_save and post_insert
Joey Schulze [Sat, 3 Oct 2015 09:15:05 +0000 (11:15 +0200)]
Support variable favicon.ico
Joey Schulze [Wed, 30 Sep 2015 17:31:19 +0000 (19:31 +0200)]
Fix wheel scrolling on LiveGrid content
In Rico3 this.tabs contains 3 elements, not 2 as in Rico2
Wheel scroll delta defaults to 0 but is not adjusted for Gecko,
thus use 1 as default value
Joey Schulze [Fri, 25 Sep 2015 16:02:32 +0000 (18:02 +0200)]
Improve JS code
Joey Schulze [Fri, 25 Sep 2015 15:24:27 +0000 (17:24 +0200)]
Adjust stylesheet
Joey Schulze [Fri, 25 Sep 2015 15:05:48 +0000 (17:05 +0200)]
Improve automatic logout with a popup
Joey Schulze [Tue, 22 Sep 2015 21:24:05 +0000 (23:24 +0200)]
Improve menu
Joey Schulze [Tue, 22 Sep 2015 21:15:56 +0000 (23:15 +0200)]
Finally remove dropdown and dragresize files
Joey Schulze [Tue, 22 Sep 2015 20:31:33 +0000 (22:31 +0200)]
Minimise JS and CSS files and prefer minimised version over extended
uses uglifyjs for JS files
uses CSS::Minifier for CSS files
Joey Schulze [Tue, 22 Sep 2015 20:16:40 +0000 (22:16 +0200)]
Remove ukrainian localization strings, file is broken somehow
Joey Schulze [Mon, 21 Sep 2015 14:46:43 +0000 (16:46 +0200)]
Remove details support, unused anyway
Joey Schulze [Mon, 21 Sep 2015 14:44:22 +0000 (16:44 +0200)]
Mask adjustments
Joey Schulze [Mon, 21 Sep 2015 14:23:39 +0000 (16:23 +0200)]
Finish integration and move edit facility into popup
Joey Schulze [Mon, 21 Sep 2015 14:03:55 +0000 (16:03 +0200)]
Remove dragresize library
Joey Schulze [Mon, 21 Sep 2015 13:53:12 +0000 (15:53 +0200)]
Improve class organiation
Joey Schulze [Mon, 21 Sep 2015 13:40:34 +0000 (15:40 +0200)]
jQuery and Rico 3.0 integration
Joey Schulze [Mon, 21 Sep 2015 11:01:57 +0000 (13:01 +0200)]
Convert filter value for type date
This fixes a problem when the date format is set to German.
Joey Schulze [Mon, 21 Sep 2015 10:47:02 +0000 (12:47 +0200)]
Special XML conversion code for Firefox >= 20.0
This patch is required due to changed behaviour of the XML parser
in XmlHttpRequest that parses XML responses from the AJAX/SQL
backend.
Firefox < 20.0 <foo> was parsed and returned as <bla>
Firefox >= 20.0 <foo> is parsed and returned as <bla>
This breaks Icons and other HTML code in Rico.LiveGrid cells
Addendum: Chrome alias WebKit seems to behave like Firefox >= 20.0 as well
Joey Schulze [Mon, 21 Sep 2015 10:26:56 +0000 (12:26 +0200)]
Apply filter after changing the filter input element
This improves usability when using the mouse for pasting
Joey Schulze [Mon, 21 Sep 2015 10:21:35 +0000 (12:21 +0200)]
Use converted value if colum uses a lookup table
This will improve filtering a lot since converted values make more
sense than the real values
Joey Schulze [Mon, 21 Sep 2015 10:16:37 +0000 (12:16 +0200)]
Add horizontal scroll to control position
Thus honor horizontal scroll and display control in visible area
Joey Schulze [Mon, 21 Sep 2015 09:39:40 +0000 (11:39 +0200)]
Automatically remove column select filter if unapplyable
When the filter value is stored in a cookie the filter is
automatically reapplied on page reload. If table values have changed
in the meantime so that the original filter value is not available
anymore the LiveGrid will display 0 rows and the select filter element
will display __ALL__ (since the value it is set to is not available).
The problem could be resolved by filtering for a different value and
then resetting the filter select element back to __ALL__. However,
since the filter already displays __ALL__ most users won't notice that
the grid is already filtered.
Joey Schulze [Mon, 21 Sep 2015 09:17:32 +0000 (11:17 +0200)]
Fix caret in filter specs
According to the documentation t^20 will search for a substring only
at the beginning of a string.
For completeness specifying t$20 for substring searches at the end
of a string is also supported.
Joey Schulze [Sat, 19 Sep 2015 10:49:42 +0000 (12:49 +0200)]
Import base files from rico3 branch of OpenRico
Joey Schulze [Fri, 18 Sep 2015 20:47:10 +0000 (22:47 +0200)]
Merge branches 'firefox39.0' and 'upload'
Joey Schulze [Fri, 18 Sep 2015 20:45:50 +0000 (22:45 +0200)]
Always use lowercase suffix when accepting uploaded files
Joey Schulze [Wed, 12 Aug 2015 10:04:36 +0000 (12:04 +0200)]
Stop double encoding during insert
Joey Schulze [Sun, 9 Aug 2015 22:16:25 +0000 (00:16 +0200)]
Prevent double encoding of uploaded files, use send function
Joey Schulze [Fri, 1 May 2015 12:53:58 +0000 (14:53 +0200)]
Allow filtering by date
Joey Schulze [Fri, 1 May 2015 12:51:30 +0000 (14:51 +0200)]
Allow integer and date columns to be filterable with text filters
PostgreSQL only patch
Joey Schulze [Fri, 1 May 2015 11:41:14 +0000 (13:41 +0200)]
Merge branches 'csv', 'buttons', 'edit-width', 'file-default', 'mail', 'modified' and 'sys-group'
Joey Schulze [Fri, 1 May 2015 11:33:05 +0000 (13:33 +0200)]
Improve handling of buttons without functions and disabled buttons
Joey Schulze [Fri, 1 May 2015 11:10:44 +0000 (13:10 +0200)]
Improve display of last modification message
Joey Schulze [Fri, 1 May 2015 11:04:44 +0000 (13:04 +0200)]
Adjust width of edit elements to maximum, inherit outer width
Joey Schulze [Fri, 1 May 2015 10:56:29 +0000 (12:56 +0200)]
Change default download icon for files
Joey Schulze [Fri, 1 May 2015 10:55:26 +0000 (12:55 +0200)]
Add CSV type with graphic
Joey Schulze [Fri, 1 May 2015 10:54:21 +0000 (12:54 +0200)]
Add column filters
Joey Schulze [Thu, 25 Sep 2014 20:36:07 +0000 (22:36 +0200)]
Merge branches 'mail', 'max-file-upload' and 'session'
Joey Schulze [Thu, 25 Sep 2014 20:34:47 +0000 (22:34 +0200)]
Display maximum file upload size
Joey Schulze [Thu, 25 Sep 2014 20:34:11 +0000 (22:34 +0200)]
Check for empty session
Joey Schulze [Thu, 25 Sep 2014 20:33:31 +0000 (22:33 +0200)]
Move CRLF into protected attribute
Joey Schulze [Thu, 25 Sep 2014 20:33:11 +0000 (22:33 +0200)]
Many improvements for mail class
Joey Schulze [Thu, 25 Sep 2014 19:22:01 +0000 (21:22 +0200)]
Move \r\n into protected attribute for easier change
Joey Schulze [Sat, 20 Sep 2014 16:49:22 +0000 (18:49 +0200)]
Improve empty set handling
Joey Schulze [Fri, 12 Sep 2014 20:47:39 +0000 (22:47 +0200)]
Merge branches 'ctlposition', 'dates', 'db-bugfix', 'dragresize', 'fix-filter', 'javascript', 'mail', 'max-file-upload' and 'session'
Joey Schulze [Fri, 12 Sep 2014 20:45:59 +0000 (22:45 +0200)]
Merge branches
Joey Schulze [Fri, 12 Sep 2014 20:10:22 +0000 (22:10 +0200)]
Switch to Styles object
Joey Schulze [Fri, 12 Sep 2014 19:48:02 +0000 (21:48 +0200)]
Revert "Declare JavaScript object global"
This reverts commit
372217195f6ea82076259d8681244499878f9308.
Joey Schulze [Fri, 12 Sep 2014 19:20:46 +0000 (21:20 +0200)]
Switch to JavaScript object
Joey Schulze [Fri, 12 Sep 2014 19:19:27 +0000 (21:19 +0200)]
Declare JavaScript object global
Joey Schulze [Fri, 12 Sep 2014 19:15:50 +0000 (21:15 +0200)]
Move JavaScript object to init file
Joey Schulze [Wed, 10 Sep 2014 17:02:30 +0000 (19:02 +0200)]
Fix ondragend function
Joey Schulze [Wed, 10 Sep 2014 16:59:08 +0000 (18:59 +0200)]
Adjust selector for edit form
Joey Schulze [Wed, 10 Sep 2014 16:58:32 +0000 (18:58 +0200)]
Allow moving elements back to original position and resize them
Joey Schulze [Wed, 10 Sep 2014 16:23:32 +0000 (18:23 +0200)]
Add background to movable div elements
Joey Schulze [Wed, 10 Sep 2014 16:07:42 +0000 (18:07 +0200)]
Support moving and resizing of form and grid
Joey Schulze [Wed, 10 Sep 2014 14:15:47 +0000 (16:15 +0200)]
Add all files from DragResize library
Joey Schulze [Wed, 10 Sep 2014 12:37:43 +0000 (14:37 +0200)]
Switch layout to absolute positioning
Position calculation via JavaScript
Joey Schulze [Wed, 10 Sep 2014 11:02:01 +0000 (13:02 +0200)]
Merge branch 'javascript' into dragresize
Joey Schulze [Wed, 10 Sep 2014 11:01:33 +0000 (13:01 +0200)]
Convert JavaScript stuff to class
Joey Schulze [Wed, 10 Sep 2014 09:07:03 +0000 (11:07 +0200)]
Allow login form to be moved around
Joey Schulze [Wed, 10 Sep 2014 09:05:58 +0000 (11:05 +0200)]
Import DragResize v1.0
From http://www.twinhelix.com/javascript/dragresize/dragresize.zip
Joey Schulze [Thu, 4 Sep 2014 12:55:46 +0000 (14:55 +0200)]
Support HTML mails without attachment
Joey Schulze [Thu, 4 Sep 2014 06:42:38 +0000 (08:42 +0200)]
Support attaching files
Samples:
$mail->attach($text, 'text/plain');
$mail->attach($file_content, 'application/octet-stream; name="foo.pdf"');
$mail->attach($path);
Joey Schulze [Mon, 1 Sep 2014 15:57:59 +0000 (17:57 +0200)]
Add horizontal scroll to control position
thus honor horizontal scroll and display control in visible area
Joey Schulze [Sat, 30 Aug 2014 19:14:33 +0000 (21:14 +0200)]
Display the maximum filesize for file uploads
Joey Schulze [Sat, 30 Aug 2014 18:54:03 +0000 (20:54 +0200)]
Bugfix
Joey Schulze [Sat, 30 Aug 2014 18:53:32 +0000 (20:53 +0200)]
Add check for empty session / expired session
Joey Schulze [Sat, 30 Aug 2014 18:51:43 +0000 (20:51 +0200)]
Add content-type function
Joey Schulze [Sat, 10 May 2014 16:54:29 +0000 (18:54 +0200)]
Filter empty select values
Joey Schulze [Wed, 26 Mar 2014 11:33:35 +0000 (12:33 +0100)]
Addition to commit
34d9dbfecd62b8e0f3b21bd14a7f2ff35c8556ab
Chromium/Chrome alias WebKit seems to behave the same way as Firefox >= 20.0
Joey Schulze [Fri, 14 Mar 2014 09:06:02 +0000 (10:06 +0100)]
Automatically remove column select filter if unapplyable
When the filter value is stored in a cookie the filter is
automatically reapplied on page reload. If table values have changed
in the meantime so that the original filter value is not available
anymore the LiveGrid will display 0 rows and the select filter element
will display __ALL__ (since the value it is set to is not available).
The problem could be resolved by filtering for a different value and
then resetting the filter select element back to __ALL__. However,
since the filter already displays __ALL__ most users won't notice that
the grid is already filtered.
Joey Schulze [Wed, 12 Mar 2014 12:41:04 +0000 (13:41 +0100)]
Add standalone program to send reminders via mail
Joey Schulze [Mon, 24 Feb 2014 18:54:32 +0000 (19:54 +0100)]
Merge branches 'input-check-clear', 'listedit', 'rico-bug' and 'rico-db'
Joey Schulze [Mon, 24 Feb 2014 18:53:16 +0000 (19:53 +0100)]
Add support for popup editing inside a live grid
Joey Schulze [Mon, 24 Feb 2014 18:52:29 +0000 (19:52 +0100)]
Clear error info after successful editing
Joey Schulze [Mon, 24 Feb 2014 18:51:46 +0000 (19:51 +0100)]
Add errorInfor function to database class
Joey Schulze [Mon, 24 Feb 2014 18:49:41 +0000 (19:49 +0100)]
Rico Bugfix: Prevent translation error
Joey Schulze [Sun, 22 Dec 2013 12:18:20 +0000 (13:18 +0100)]
Need to supply the sequence name and noth the schema name
Joey Schulze [Sat, 21 Dec 2013 22:09:36 +0000 (23:09 +0100)]
Merge branches 'ILIKE', 'brokensession', 'autologout', 'oop' and 'slave-table'
Joey Schulze [Sat, 21 Dec 2013 22:08:38 +0000 (23:08 +0100)]
Use EQ filter for text filters in columns with type number
Joey Schulze [Sat, 21 Dec 2013 21:05:48 +0000 (22:05 +0100)]
Support case insensitive query for substrings
Joey Schulze [Sat, 21 Dec 2013 20:59:01 +0000 (21:59 +0100)]
Add button background for custom buttons