8 Commits

Author SHA1 Message Date
johnnyq
c094f97eed QoL 63: counts in menus, tabs, list headers and the list footer have a thousands separator, as the dashboard, reports and audit log already did 2026-11-21 02:29:20 -05:00
johnnyq
a14b0fa9ca QoL 52: fw-bold for text-bold, text-body-secondary for text-muted and fas for the fa icon prefix everywhere, the user menu buttons as btn-light border, the dead AdminLTE 3 shims and small-box styles removed from itflow_custom.css, and the inert tooltip toggles on menu counts dropped 2026-11-21 01:10:23 -05:00
johnnyq
15aeab602d QoL 50: sortLink and sortFirstOrder in functions/format.php replace the 48 copied sort_link closures and 115 hand-written header links, the first click on a new column sorts names A-Z and dates, money and counts newest or largest first, with changelog lines 2026-11-21 00:59:32 -05:00
johnnyq
efcaedaa87 QoL 46: one More menu icon, one icon each for Delete Restore and Export, plain required stars, the incident response window in the standard header, itflowConfirm shared by confirm-link and script with the confirm button taking the link label, the app confirm and toast in place of browser confirm and alert, the timer reset no longer marking a running timer stopped on cancel, and list search boxes reading Search with field hints in the tooltip 2026-11-21 00:43:26 -05:00
johnnyq
df64d82f3a Archive clients, ticket replies, accounts and SLAs and restore anything without an Are you sure prompt, with Undo added for ticket replies and accounts, real plurals and bold counts in bulk messages, and flashAlert for asset and contact note messages 2026-11-20 23:46:36 -05:00
johnnyq
34fa126a35 Admin menu: Templates becomes one entry under Lists and Templates with ticket, project, contract, vendor, license and document templates and canned responses as tabs, Logs becomes one entry under Maintenance with audit logs, sign-ins and app logs as tabs, and Text Messaging holds its setup and its messages with the failed count on the entry; new adminNavGroups with adminNavGroupItemHtml and adminNavGroupTabsHtml, the on-screen paths to those pages say where they are now, 26.11.9 changelog entries 2026-11-18 01:52:00 -05:00
johnnyq
2311d1f9d8 Speed up Admin Audit Logs, Sign-ins and Users, Transactions, Income, Invoices, Projects and the invoice page on installs with years of history: database 3.6.6 adds logs (log_user_id, log_type, log_action), logs (log_type, log_action, log_user_id, log_ip, log_created_at) and tickets (ticket_invoice_id), each only where missing and in db.sql, leaving out one it cannot add with a warning in App Logs; Audit Logs drops SQL_CALC_FOUND_ROWS and counts its views with one GROUP BY log_type, log_action in the new auditLogViewCounts, which also hands back the types and actions in the view so auditLogKindsSql finds a sparse view or action on the index, and builds its who, client, type and action lists with auditLogDistinctSql in place of EXISTS and DISTINCT over the log, as the export window now does; Sign-ins reads only the new log_type index, counts unknown emails for the page's addresses in their own query and ends every sort on log_ip or log_user_id so tied rows keep one order; the new listNewestFirst in functions/app.php pages a newest-first list from the last month, year and four years back before the whole of it, used by Transactions without the running balance and by Income, which both take their count from their pill in place of SQL_CALC_FOUND_ROWS, with incomeUnionSql(false) leaving out the name joins for Income's counts when there is no search; Invoices replaces the LEFT JOIN of every payment grouped by invoice with a paid lookup for the page's invoices and the unpaid ones in the totals; the project lookups, through the new PROJECT_TICKETS_SQL, the client onboarding ticket counts and the expense refund lookups also say the column is > 0, so the database stays on the index where nearly every row has 0 and its statistics say a lookup finds every row, Projects having read 33.6 million rows with no ticket on a project; checked on an eight-year test install against the old code over 103 filter, sort and page combinations and a crawl of all 233 pages; add the changes to the 26.11.8 changelog section 2026-11-13 12:58:04 -05:00
johnnyq
a5a43e37ac Audit logs stage 3: failed sign-ins say why and are logged against the account they were for - wrong password, no account with that email, disabled, archived or invited account, client archived, portal turned off, a wrong MFA or two-step code after the right password - with failed Microsoft 365 portal sign-ins logged too and marked Their account in the audit log; the IP lockout counts portal failures as well; the first sign-in from an IP address is badged New IP in the audit lists and quick look; new Admin > Sign-ins under Access with People and IP addresses views, search, date filter, sortable columns and paging; admins get a notification and an email on a run of failed sign-ins or turned-away API calls from one address or against one account, set in Settings > Security (10 to start, 5, 20, 50 or never), each in the audit log Security view and in Mail > Previews; API calls counted per key, day and endpoint, with a 30-day calls column and last IP on API Keys and a usage window, expired-key calls logged against the key, and usage deleted with the key and after the log retention; database 3.3.2 drops the unused auth_logs table and adds settings.config_login_alert_failures and api_key_usage; new functions/sign_in.php, admin/sign_ins.php and admin/modals/api/api_key_usage.php; the license template page no longer warns when view is missing 2026-10-19 00:56:52 -04:00