Fix forever bug in residence_own move_in_type, where transfer vs movein test wasn't excluding deleted records. This really should have a db_mod.
Tweak sql_lookup_description(). Makes field name of result immaterial, so that e.g., COALESCE(description_short,description) will work for $d_field.
Try to detect selector fields better (e.g., involved_client_ids configs for client selector)
Add convenience function is_engine_object()
Add convenience/education link on staff page to staff_employment record where "not active, but no ending date on file"
Fix typo in date_range->set_end()
For TEXT variables in report options, run string through sql_escape_literal before applying. And strip tags out for label option. This should make TEXT variables safe to use. TEXT_AREA variables still need to be addressed and/or used with extreme caution. FIXME.
Tweak to make canned/list_report work with advanced search page.
Small tweak to try to better handle array links in generic SQL
Adjust password reset by email so that 2 distinct usernames can share an email address.
Update all the copyright notices to 2022
Fix staff_links() --> my_staff_links() for donor flavor.
Add comment_assemble() convenience function to show all comments in a record
Add object label for disability
Read very simple array defaults from database. This could be much better. FIXME
Make call_engine() respect NO_TITLE flag for sub_title (eliminates some duplicate links)
Add "Add Staff" link to home page
Fix missing label for selector in forms
Fix filter in get_active_generic()
Update client_age function to respect dob perms & wrap in toggle
Lengthen service_code to 30, little cleanup of obsolete service fields though not all.
Add address_summary to address views. I didn't actually make a db_mod, but this would do the change:
Change disability in client summary to use generic_f instead of multi_objects_f.
Change ethnicity in client summary to use generic_f instead of multi_objects_f.
Add simple object_label for ethnicity
Remove multi_objects_f function
Update demographic_f field (virtual, in client) to use generic_f instead of multi_objects_f
Changes to create files for facility/program/project/position/staff_employment. Lengething codes to 30 chars, and some minor cleanups.
Lengthen facility_code to 30 chars, cleanup on create.l_facility.sql
Add Questioning to gender options.
Hack to allow row_before/after to specify a bare string of letters and numbers, and applies a default style of "bigger(bold())"
For read_filter, make ARRAY_CONTAINS work for single (non-array) value
Better handling in get_active_generic.
Fix (db) lookup_value() function. db_mod.103
Rename newsLink class to whatsNewLink.
Change read_filter so that if FIELD: is specified, the column (left) expression is not quoted as an identifier.
Make list boxes respect system_log_field permission (instead of super_user), for including in "advanced" column selection.
Fix duplication view. (Wasn't filtering deletes.) db_mod.99
Tighten some SQL escaping
Fill in report defaults when needed, so a link to generate a report can work without having to supply lots of defaults.
Hackfix to make child records with array fields display correctly on parent pages
Add only_x() php function for validity checking
Add option show_object_references.
For on-screen reports, move block titles outside of collapsible content sections
For call_sql_function, convert returned array to PHP array
Another fix for attachment link permissions
For checkbox sets, don't output big blank line for group with no header
Fix quicksearch to properly escape partial (parenthesized preg) matches
Allow option to specify label to attachment_link()
Add "formatted values" option to reports, for generic spreadsheet export. Will apply value_generic to result set.
Adds 'title_definition' option (field) to lookup config array, allowing for hovering of definitions and such on select lists
Fix so display_page is used only for view, not for editing.
Use DOB/SSN perms in list view of clients (demographic_f field)
A little missed piece/bugfix for list_use_offset
For pick_staff_to, include default value even if limited to active staff and default is inactive.
Add more info to alert_notify_basis. db_mod.101
Bugfixes for template merges
Add perm types for DOB & SSN. Fix test override in previous commit. db_mod.102
Fix for multiple photos where, e.g., Client 75 was showing photos for 755, 756, etc.
Updates for link_housing_unit from SPC. These still may need to be tweaked some.
DOB & SSN don't reveal actual value unless you click them, and then only temporarily
Bugfix for using options in list_filter_links()
Fixes to make case-insensitive passwords actually work.
Tweaks to entry_browse to show when client is not matched, as opposed to silently doing nothing
Adds files for consent (Consents/Documentation) table. Note, there's sample code in the table create for adding this to the face page summary box.
Add Quick Browse as separate permission (previously needed admin, which still works). db_mod.100 NB: I'm not sure there's any value to permission-controlling this, so it might become default blanket yes
When adding child records, option to return to parent page. (Adds 'successful_update_destination' option to child records. Also adds 'display_page' for (parent) records. FIXME: This is kinda redundant with the jump option in QS config. That jump option should probably at least default to the display_page setting. )
For lookup lists, if multiple other fields at bottom, make plain "other" (by code or description) be last
Tweaks for successful update destination. Adds view/edit/clone links to client_display.php
Adds field_key and record_name to field def. Tracks name of field & parent record (object)
Install script fix
Fix typo in create.tbl_client_export_id.sql
Switch out old "sexual_minority_status" (a King County term) for "sexual orientation"
Add more languages to list, and move list to separate populate file
Updates to ethnicity. db_mod.99
Remove stray perms from client_death
Move create.l_export_organization to agency_core, and install by default
Rough cut of improved unduplication system. Still work & cleanup to do, but hopefully functional for client undup
Change initial pg super_user install to create and install in agency schema.
More selector and reference stuff. Adds config_option "selector_method", Search or Pick
Performance improvements for per-client references. (NOTE: db_mod.73, which we're way past, so don't overlook this!)
Adds list_use_offset option, for object with lots of rows. Experimental, gets a page AS SELECT [*] FROM table LIMIT per_page OFFSET position Instead of SELECT * FROM table, and then seeking appropriate rows. This really should be superseded by index-based paging, e.g. SELECT... WHERE time_stamp > last timestamp from last page LIMIT per_page
In link_report(), only parse variables if any are set for the link. (Performance)
Some adjustments to log_browse.php to work with list_use_offset
Cache reports (get_report_from_db) and variables (report_parse_var_text) to reduce querying. (Performance)
Get rid of some old commented-out code in log_browse.php
Extend demo mode to obfuscate staff names
Fix long list logs to work with list_use_offset
For hot links, strip tags out of object_label (avoid nested links).
Fix add reference (from view) was posting to the wrong (last viewed) record
For single_active_record, make auto_close form respect active_date_field
Allow generic_f to take an object label (passed in as label_exec)
Remove some long-aged custom code for assessments
Small fix for configging lookup tables
For staff and clients, make object_links display ID numbers after link.
For grouping lookup lists, sort Other to bottom.
Fix mangled report_variables section
Make comments show when choosing options for a report.
Fix file_exchange to enforce permissions
Make grouping work with checkboxes (do_checkbox_sql()).