Activity for AGENCY Software

  • Ken Tanzer committed [c94d08] on Code

    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.

  • Ken Tanzer committed [d9595a] on Code

    Tweak sql_lookup_description(). Makes field name of result immaterial, so that e.g., COALESCE(description_short,description) will work for $d_field.

  • Ken Tanzer committed [3a721d] on Code

    Try to detect selector fields better (e.g., involved_client_ids configs for client selector)

  • Ken Tanzer committed [5152b9] on Code

    Add convenience function is_engine_object()

  • Ken Tanzer committed [a81fd9] on Code

    Add convenience/education link on staff page to staff_employment record where "not active, but no ending date on file"

  • Ken Tanzer committed [4e4541] on Code

    Fix typo in date_range->set_end()

  • Ken Tanzer committed [be7e4f] on Code

    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.

  • Ken Tanzer committed [ee78a7] on Code

    Tweak to make canned/list_report work with advanced search page.

  • Ken Tanzer committed [f0ef7f] on Code

    Small tweak to try to better handle array links in generic SQL

  • Ken Tanzer committed [d6301c] on Code

    Adjust password reset by email so that 2 distinct usernames can share an email address.

  • Ken Tanzer committed [abc70e]

    Update all the copyright notices to 2022

  • Kenneth Tanzer Kenneth Tanzer committed [66c0b6]

    Fix staff_links() --> my_staff_links() for donor flavor.

  • Ken Tanzer committed [a987b8]

    Add comment_assemble() convenience function to show all comments in a record

  • Ken Tanzer committed [066016]

    Add object label for disability

  • Ken Tanzer committed [75a325]

    Read very simple array defaults from database. This could be much better. FIXME

  • Ken Tanzer committed [580089]

    Make call_engine() respect NO_TITLE flag for sub_title (eliminates some duplicate links)

  • Ken Tanzer committed [b5a718]

    Add "Add Staff" link to home page

  • Ken Tanzer committed [3122e3]

    Fix missing label for selector in forms

  • Ken Tanzer committed [7ad7e9]

    Fix filter in get_active_generic()

  • Ken Tanzer committed [1e9892]

    Update client_age function to respect dob perms & wrap in toggle

  • Ken Tanzer committed [77a298]

    Lengthen service_code to 30, little cleanup of obsolete service fields though not all.

  • Ken Tanzer committed [25fc73]

    Add address_summary to address views. I didn't actually make a db_mod, but this would do the change:

  • Ken Tanzer committed [fee9dd]

    Change disability in client summary to use generic_f instead of multi_objects_f.

  • Ken Tanzer committed [6353c4]

    Change ethnicity in client summary to use generic_f instead of multi_objects_f.

  • Ken Tanzer committed [20db70]

    Add simple object_label for ethnicity

  • Ken Tanzer committed [278189]

    Remove multi_objects_f function

  • Ken Tanzer committed [6a09d0]

    Update demographic_f field (virtual, in client) to use generic_f instead of multi_objects_f

  • Ken Tanzer committed [79aeae]

    Changes to create files for facility/program/project/position/staff_employment. Lengething codes to 30 chars, and some minor cleanups.

  • Ken Tanzer committed [b262a3]

    Lengthen facility_code to 30 chars, cleanup on create.l_facility.sql

  • Ken Tanzer committed [1a3d8e]

    Add Questioning to gender options.

  • Ken Tanzer committed [5e3ad5]

    Hack to allow row_before/after to specify a bare string of letters and numbers, and applies a default style of "bigger(bold())"

  • Ken Tanzer committed [77165d]

    For read_filter, make ARRAY_CONTAINS work for single (non-array) value

  • Ken Tanzer committed [d3f810]

    Better handling in get_active_generic.

  • Ken Tanzer committed [c23a2f]

    Fix (db) lookup_value() function. db_mod.103

  • Ken Tanzer committed [35b1c4]

    Rename newsLink class to whatsNewLink.

  • Ken Tanzer committed [540093]

    Change read_filter so that if FIELD: is specified, the column (left) expression is not quoted as an identifier.

  • Ken Tanzer committed [f81591]

    Make list boxes respect system_log_field permission (instead of super_user), for including in "advanced" column selection.

  • Kenneth Tanzer Kenneth Tanzer committed [795c57]

    Fix duplication view. (Wasn't filtering deletes.) db_mod.99

  • Kenneth Tanzer Kenneth Tanzer committed [14a5c2]

    Tighten some SQL escaping

  • Kenneth Tanzer Kenneth Tanzer committed [17a39e]

    Fill in report defaults when needed, so a link to generate a report can work without having to supply lots of defaults.

  • Kenneth Tanzer Kenneth Tanzer committed [0e44d5]

    Hackfix to make child records with array fields display correctly on parent pages

  • Kenneth Tanzer Kenneth Tanzer committed [ddfd15]

    Add only_x() php function for validity checking

  • Kenneth Tanzer Kenneth Tanzer committed [57b4ec]

    Add option show_object_references.

  • Kenneth Tanzer Kenneth Tanzer committed [322f36]

    For on-screen reports, move block titles outside of collapsible content sections

  • Kenneth Tanzer Kenneth Tanzer committed [42aa3d]

    For call_sql_function, convert returned array to PHP array

  • Kenneth Tanzer Kenneth Tanzer committed [c6b212]

    Another fix for attachment link permissions

  • Kenneth Tanzer Kenneth Tanzer committed [d3320a]

    For checkbox sets, don't output big blank line for group with no header

  • Kenneth Tanzer Kenneth Tanzer committed [088dac]

    Fix quicksearch to properly escape partial (parenthesized preg) matches

  • Kenneth Tanzer Kenneth Tanzer committed [1f1752]

    Allow option to specify label to attachment_link()

  • Kenneth Tanzer Kenneth Tanzer committed [341b05]

    Add "formatted values" option to reports, for generic spreadsheet export. Will apply value_generic to result set.

  • Kenneth Tanzer Kenneth Tanzer committed [38db42]

    Adds 'title_definition' option (field) to lookup config array, allowing for hovering of definitions and such on select lists

  • Ken Tanzer committed [0d70ac]

    Fix so display_page is used only for view, not for editing.

  • Ken Tanzer committed [069b43]

    Use DOB/SSN perms in list view of clients (demographic_f field)

  • Ken Tanzer committed [609bd5]

    A little missed piece/bugfix for list_use_offset

  • Ken Tanzer committed [dfee68]

    For pick_staff_to, include default value even if limited to active staff and default is inactive.

  • Ken Tanzer committed [dc7812]

    Add more info to alert_notify_basis. db_mod.101

  • Ken Tanzer committed [85578a]

    Bugfixes for template merges

  • Ken Tanzer committed [02f190]

    Add perm types for DOB & SSN. Fix test override in previous commit. db_mod.102

  • Ken Tanzer committed [da1447]

    Fix for multiple photos where, e.g., Client 75 was showing photos for 755, 756, etc.

  • Ken Tanzer committed [52b0fb]

    Updates for link_housing_unit from SPC. These still may need to be tweaked some.

  • Ken Tanzer committed [abe696]

    DOB & SSN don't reveal actual value unless you click them, and then only temporarily

  • Kenneth Tanzer Kenneth Tanzer committed [396a08]

    Bugfix for using options in list_filter_links()

  • Kenneth Tanzer Kenneth Tanzer committed [18880c]

    Fixes to make case-insensitive passwords actually work.

  • Kenneth Tanzer Kenneth Tanzer committed [86e355]

    Tweaks to entry_browse to show when client is not matched, as opposed to silently doing nothing

  • Kenneth Tanzer Kenneth Tanzer committed [cc6d78]

    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.

  • Kenneth Tanzer Kenneth Tanzer committed [e361d6]

    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

  • Kenneth Tanzer Kenneth Tanzer committed [c6342e]

    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. )

  • Kenneth Tanzer Kenneth Tanzer committed [65c1ca]

    For lookup lists, if multiple other fields at bottom, make plain "other" (by code or description) be last

  • Kenneth Tanzer Kenneth Tanzer committed [d26fcf]

    Tweaks for successful update destination. Adds view/edit/clone links to client_display.php

  • Kenneth Tanzer Kenneth Tanzer committed [cd8f89]

    Adds field_key and record_name to field def. Tracks name of field & parent record (object)

  • Ken Tanzer committed [496854]

    Install script fix

  • Ken Tanzer committed [8f73e8]

    Fix typo in create.tbl_client_export_id.sql

  • Ken Tanzer committed [9903f7]

    Switch out old "sexual_minority_status" (a King County term) for "sexual orientation"

  • Ken Tanzer committed [88bd31]

    Add more languages to list, and move list to separate populate file

  • Ken Tanzer committed [a75035]

    Updates to ethnicity. db_mod.99

  • Ken Tanzer committed [abb4b5]

    Remove stray perms from client_death

  • Ken Tanzer committed [5138b2]

    Move create.l_export_organization to agency_core, and install by default

  • Ken Tanzer committed [375424]

    Rough cut of improved unduplication system. Still work & cleanup to do, but hopefully functional for client undup

  • Ken Tanzer committed [2dc034]

    Change initial pg super_user install to create and install in agency schema.

  • Ken Tanzer committed [b789e1]

    More selector and reference stuff. Adds config_option "selector_method", Search or Pick

  • Ken Tanzer committed [7194d7]

    Performance improvements for per-client references. (NOTE: db_mod.73, which we're way past, so don't overlook this!)

  • Ken Tanzer committed [6504c5]

    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

  • Ken Tanzer committed [d060ef]

    In link_report(), only parse variables if any are set for the link. (Performance)

  • Ken Tanzer committed [0c6d6a]

    Some adjustments to log_browse.php to work with list_use_offset

  • Ken Tanzer committed [b60237]

    Cache reports (get_report_from_db) and variables (report_parse_var_text) to reduce querying. (Performance)

  • Ken Tanzer committed [45c646]

    Get rid of some old commented-out code in log_browse.php

  • Ken Tanzer committed [b82a9b]

    Extend demo mode to obfuscate staff names

  • Ken Tanzer committed [088c2a]

    Fix long list logs to work with list_use_offset

  • Ken Tanzer committed [a6a56f]

    For hot links, strip tags out of object_label (avoid nested links).

  • Ken Tanzer committed [20094c]

    Fix add reference (from view) was posting to the wrong (last viewed) record

  • Ken Tanzer committed [edb09f]

    For single_active_record, make auto_close form respect active_date_field

  • Kenneth Tanzer Kenneth Tanzer committed [cb628a]

    Allow generic_f to take an object label (passed in as label_exec)

  • Ken Tanzer committed [329faf]

    Remove some long-aged custom code for assessments

  • Ken Tanzer committed [476d4d]

    Small fix for configging lookup tables

  • Ken Tanzer committed [463a44]

    For staff and clients, make object_links display ID numbers after link.

  • Ken Tanzer committed [2ef7b0]

    For grouping lookup lists, sort Other to bottom.

  • Ken Tanzer committed [1b9ddc]

    Fix mangled report_variables section

  • Ken Tanzer committed [d73f6b]

    Make comments show when choosing options for a report.

  • Ken Tanzer committed [5c1d5b]

    Fix file_exchange to enforce permissions

  • Ken Tanzer committed [a7c12e]

    Make grouping work with checkboxes (do_checkbox_sql()).

1 >