johnnyq
|
61488305cb
|
Admin: invite several agents at once with one role, try an email against the support mailbox to see what it would become without sending anything, and a weekly summary email to the owners with the week beside the week before and what needs a look (db 4.0.7)
|
2026-11-19 21:05:51 -05:00 |
|
johnnyq
|
5af76f5d8e
|
Time and calendar: a stopwatch timer started before there is a ticket that goes to a new ticket through Quick ticket or onto an open one, the time you logged today and this week in the timers panel, reminders for calendar events and for work booked on your tickets by notification and optional email (db 4.0.6, a new Reminders cron job), and a Timeline tab on projects with bookings in time, now, start and due, clashes and the open tickets not booked yet
|
2026-11-19 21:03:37 -05:00 |
|
johnnyq
|
c98fa4bc8a
|
Billing: pause a recurring invoice until a day it resumes by itself, copy a recurring invoice to another client, bulk pause, resume, next date and frequency on recurring invoices, the client's other unpaid invoices when adding a payment, one-off addresses when sending invoices and quotes, a notice before a sent quote runs out, Take a photo in the picture window, a client's overdue balance on their tickets, and drafts left more than a week singled out
|
2026-11-19 19:23:23 -05:00 |
|
johnnyq
|
90ba1b9c0b
|
Clients and contacts: offboard a client in one window, a client card on hovering a client name, contacts whose email bounces flagged (db 4.0.3), save a contact to a phone by QR code or vCard, new ticket from a contact row, add a contact, site or vendor from the window that needs it, and duplicate warnings for contact emails and asset serials and MACs
|
2026-11-19 18:40:40 -05:00 |
|
johnnyq
|
44773561cc
|
Tickets list: keeps itself up to date with a bar for tickets that came or went, bold for tickets the client wrote on since you last opened them with Mark as read (db 4.0.2), the last reply on hover over Activity, your open ticket count in the browser tab title, and desktop notifications for tickets assigned to you and client replies
|
2026-11-19 17:56:51 -05:00 |
|
johnnyq
|
533b801a70
|
Ticket page: server-side reply drafts with discard and nightly cleanup (db 4.0.1), drop files on the reply box, quick time buttons, no-time prompt on billable replies, split a client reply into a new ticket, copy a ticket, apply a template to an open ticket, keep and read the original email on emailed replies, click-to-zoom pictures
|
2026-11-19 17:37:25 -05:00 |
|
johnnyq
|
875998bbb2
|
Stripe: when Stripe no longer has a client's customer, deleted there or made under other keys, forget it and the cards saved on it so the client sets up again, let new-card payments go ahead, tell agents, and remove the unused autopay_setup_stripe.js
|
2026-11-19 01:34:48 -05:00 |
|
johnnyq
|
45f9f81c2c
|
Email replies to tickets: keep what a client writes below the reply line - after the quote their mail program puts it in, or the unquoted lines of a plain text reply - as well as anything above it, and when their words can't be told from the quote keep the whole email with a note rather than nothing; new emailReplyText and emailReplyHasText helpers replace the cuts in the email parser, and changelog entries
|
2026-11-18 19:01:08 -05:00 |
|
johnnyq
|
a31471eff3
|
Mail: Microsoft 365 sends email and reads the support mailbox through Microsoft Graph when the app on the OAuth tab has Mail.Send or Mail.ReadWrite, so the mailbox needs no SMTP AUTH, and SMTP or IMAP stay in use for whatever it lacks; new functions/mail_graph.php with mailGraphToken caching the Graph token and its scopes and keeping the rotated refresh token, mailGraphSend sending the finished MIME or a draft with uploaded attachments past 3 MB, and functions/mail_graph_mailbox.php standing in for ImapEngine in the email parser; the OAuth tab says which way email goes, Test IMAP and Test OAuth Token Refresh cover Graph, the Exchange token renewals now name their scope, database 3.9.2 adds three settings columns, 26.11.9 changelog entries
|
2026-11-17 23:49:02 -05:00 |
|
johnnyq
|
d69015e2c7
|
Recurring tickets and events can repeat on a weekday, such as the third Wednesday or the last Friday, instead of the same date: monthly, quarterly, twice-yearly and yearly recurring tickets and monthly and yearly events get Repeats on once a date is picked, moving the next run or an event's start keeps the same kind of weekday, the recurring tickets list, events and invitations say which, and subscribed calendars get it as an RRULE BYDAY; the API takes repeat_on and event_repeat_by_day; database 3.8.3 adds recurring_tickets.recurring_ticket_by_day and calendar_events.event_repeat_by_day; 26.11.9 changelog entries
|
2026-11-17 20:51:53 -05:00 |
|
johnnyq
|
ee5f7ff48a
|
Admin Backup restores a backup from its menu or an upload of up to 5 GB sent in pieces, checked in the Restore window and confirmed with the password and RESTORE, then queued for the Backup cron job, which takes a Before restore backup, restores, keeps both in the list, runs the database updates and ends the cycle while other dispatches wait; the page shows it waiting with Cancel, running and how it went; 26.11.9 changelog entries
|
2026-11-17 19:22:47 -05:00 |
|
johnnyq
|
71dab1cca7
|
Development mode for a test copy, set on Admin Backup and kept in config.php: every email goes to the test inbox with its recipient in the subject or is cancelled without one, texts wait, the ticket mailbox is not read, AI Triage, Stripe, autopay, RMM device actions, log forwarding, managed check-ins and telemetry are off, and a DEVELOPMENT badge shows in the top bar; 26.11.9 changelog entries
|
2026-11-17 19:22:10 -05:00 |
|
johnnyq
|
22f9315c81
|
Maintenance Cron: admins see a heartbeat in the top bar when cron is not running, is switched off, or a job failed, is stuck or has fallen behind; the new Cron Watch job emails the admins or set addresses when a problem starts, once a day while it lasts and when it is fixed; health.php answers OK or 503 for an uptime monitor given its key in the address or an X-Health-Key header; the Alerts card sets the emails, sends a test and makes a new key; database 3.7.9 adds the cron alert settings; 26.11.9 changelog entries
|
2026-11-17 18:43:26 -05:00 |
|
johnnyq
|
de9544ffc6
|
Recurring tickets book each ticket for its run day at a set time, remote or onsite, and can be raised a number of days ahead of the run or of the 1st of its month; recurring invoices can be made a number of days ahead, due on their date plus the client's terms or on their date; database 3.7.7 adds the columns; 26.11.9 changelog entries
|
2026-11-17 17:56:00 -05:00 |
|
johnnyq
|
707fdaedd4
|
Robustness: lists take page 1 at least and an open end date, portal sessions go to the portal from the main address, custom page forms no longer load a missing post/ai.php, cron jobs that stop with an error code show as Failed with the parser saying what the mail server answered, the mail queue keeps a refreshed OAuth token for the rest of the run, the update check keeps the newest 100 commits and counts them all, restore_cli works on a database with no settings yet, the API reads a non-JSON body as no fields and clamps limit and offset, API client delete removes the client's uploads, contact anonymizing redacts stored values longest first, the asset transfer log names the asset, the client duplicate check escapes wildcards, and Access Modules drops its dead buttons and sorts only on its own columns; 26.11.9 changelog entries
|
2026-11-17 16:15:23 -05:00 |
|
johnnyq
|
44c7155078
|
Payments: Charge Saved Card takes a per-window token used as the Stripe idempotency key and holds a per-invoice lock while it re-reads and charges the balance, so a double click or two agents make one charge; Add Payment and Batch Payment work the balance out on save in whole cents, refuse 0 or less, and Add Payment only takes sent invoices with something owed; autopay charges what is still owed on Partial invoices, re-read before the charge; the invoice link payment page allows balances under 1.00, follows the card limit and refuses non-billable invoices, answers errors as JSON and shows them, with a working spinner; guest receipts and quote notices go out with OAuth mail; Make Recurring keeps the discount; statuses set by updateInvoiceStatusFromPayments; 26.11.9 changelog entries
|
2026-11-17 16:14:53 -05:00 |
|
johnnyq
|
58cbce83cc
|
Tickets: every way out of Resolved into a working status (ticket reply, bulk reply, portal comment, API reply) clears the resolved time and restarts the resolution SLA; an emailed client reply on an open ticket keeps its SLA alerts; portal Resolve needs an unresolved ticket with its tasks done and Close needs a resolved one; API replies refuse closed tickets, New, Closed or unknown statuses and resolving with open tasks, and sync the SLA clock on a status change; API ticket update re-applies the SLA on a priority change; merging with replies moved takes their attachments and files along; 26.11.9 changelog entries
|
2026-11-17 16:14:18 -05:00 |
|
johnnyq
|
2ba1074e0e
|
Security and access fixes from MountaineerIT's build: security headers in .htaccess and script-free uploads, with restores writing the same uploads guard (no php_flag 500 on PHP-FPM); portal sessions end when the portal is off or the client or contact is archived, and Microsoft sign-in checks the same; saved-card setup takes only the checkout session this sign-in started for the client's own customer; portal uploads take their type from the file; bulk email to clients and contacts needs Modify; bulk archive leaves a primary contact's login; MFA can't be set up again over one that is on, and 000000 is a valid code; tasks waiting for approval stay open; the email parser keeps strangers' mail as an internal note without reopening or attachments, files agents' mail as their internal note, sends no closed-ticket reply to bounces, and cuts long subjects and attachment names; 26.11.9 changelog entries
|
2026-11-17 16:13:36 -05:00 |
|
johnnyq
|
6e313f0c7d
|
Ticket Schedule Cancelled emails send on Microsoft 365: sendQueueEmail puts a calendar file in its own text/calendar part only for a meeting with an organizer and attendees and attaches the rest as invite.ics, so a ticket's cancellation goes attached like its booking instead of as a meeting Exchange refuses; a failed send keeps the SMTP server's reply in email_error; 26.11.9 changelog entries
|
2026-11-16 22:31:59 -05:00 |
|
johnnyq
|
4faa0d91ca
|
Pasted pictures go with ticket emails as pictures attached inline: emailInlineImages takes each data image out of an email's HTML to uploads/tmp/mail_images, stored once by its hash, and points it at a cid that the mail queue attaches with addEmbeddedImage, so mail programs that show no data images show them and the queue keeps each picture once rather than in every email; Admin Mail Queue shows them back in the message and counts only files as attachments, a meeting request with pictures goes as an attached invite, and nightly removes pictures no queued email uses; 26.11.9 changelog entries
|
2026-11-16 19:36:00 -05:00 |
|
johnnyq
|
c2eb55c8dc
|
Mail queue keeps what a sent email said: only an email with a link or code that opens something - a shared login and its code, a portal or agent invite, a password link, a contract to sign or a task to approve - is cleared once sent, and a day after it was queued if it failed or was cancelled; emailQueue gains a sensitive option set by those senders, cron marks sent email with mailQueueSentSql, nightly runs mailQueueClearSensitive, and a cleared email can't be retried; database 3.7.1 adds email_queue.email_sensitive and marks email waiting at the update; 26.11.9 changelog entries
|
2026-11-16 18:48:57 -05:00 |
|
johnnyq
|
9f8676fe48
|
Quieter App Logs from cron: the email parser no longer logs a run summary every minute mail comes in or is left in the inbox, and echoes its counts and time instead; with no IMAP or SMTP provider set up the email parser and mail queue stop with a reason Maintenance Cron shows instead of an App Logs entry every minute; the mail queue, ticket SLA monitor, domain refresher and certificate refresher stop without an App Logs error while cron is switched off, as the email parser already did; 26.11.9 changelog entries
|
2026-11-16 17:38:51 -05:00 |
|
johnnyq
|
c76882f3d2
|
Add RMM alerts opening tickets: a provider's Edit picks which alerts open tickets (errors, errors and warnings, or every alert) and their ticket category, and the new RMM Alerts cron job looks every minute - a new alert on a device of a linked client opens a ticket on its client and asset with priority by severity, the same alert again goes on its open ticket and reopens it if resolved, and a cleared alert notes and resolves its ticket unless someone has written on it, it was moved to another status or another of its alerts is still open; the first look after turning alerts on, or the provider back on, takes open alerts as known, as does an alert raised before its device came into ITFlow; Tactical alerts read from PATCH /alerts/ and GET /alerts/id/ with no setup in Tactical; open alerts and their tickets on the asset's RMM card, an Alerts column on the providers list, the RMM ticket source on the ticket page and list, and the new-ticket address email; database 3.6.8 adds the alert columns to rmm_providers and the rmm_alerts table; 26.11.9 changelog entries
|
2026-11-13 18:33:38 -05:00 |
|
johnnyq
|
3fb0a3e2e0
|
Add RMM Providers under Admin > Integrations to bring devices in from an RMM as assets, with Tactical RMM as the first kind: a providers list (search, sort, add, edit, test, sync now, turn off and on, delete), a Clients page per provider to link its clients to ITFlow clients with same-name suggestions, devices matched to existing assets by serial or unique name or made as new ones, each asset field following the RMM until it is edited in ITFlow, removed devices marked and returned ones picked up, deleted assets left out until Bring back, a card per RMM device on the asset page with online state, last seen, signed-in user, reboot, patches and failing checks, Take Control and dashboard links, the state on the quick look, a status dot and RMM filter on the assets list, and the RMM Sync cron job every 15 minutes across every provider that is on; shared engine in functions/rmm.php and the Tactical adapter in functions/rmm_tactical.php so another RMM is one file and one registry line; database 3.6.7 adds rmm_providers, rmm_clients and rmm_devices; demo mode locks the new pages and handlers; 26.11.9 changelog entries
|
2026-11-13 18:13:58 -05:00 |
|
johnnyq
|
980f394ee2
|
Send mail again on installs first set up with Microsoft 365 or Google OAuth on 26.11: cast the SMTP host to a string at both sendQueueEmail call sites, since it is NULL until a host is saved and the typed argument threw a TypeError that ended the mail queue run before anything was sent; catch any Throwable around each send so one failing email is marked failed and the rest still go out, where only PHPMailer's own Exception was caught and an Error left the email as Sending; add the changelog entries. Fix reported by toto707 on the forum
|
2026-11-10 16:25:07 -05:00 |
|
johnnyq
|
2a36534583
|
Add demo mode for a public demo like demo.itflow.org - $config_demo_mode = true; in config.php puts one-click sign-in buttons for Admin, Technician, Accountant and a client portal contact on the sign-in page and a demo notice on every page, and the new Demo Reset cron job rebuilds the demo nightly at 2:00 AM from db.sql with all starter content, the demo clients and the demo accounts, empties uploads except the logo and signs everyone out, keeping the company details, timezone and cron schedules; visitors can try everything except users and roles, their own sign-in details, mail, payment, AI and texting settings, API keys, backups, updates, cron, log forwarding, company, module and portal settings, custom links, starter content and share links, Debug is closed, guest links open only for someone signed in, queued email is cancelled with the reason, no sign-in alert emails are sent, certificate checks reach only public addresses on port 443, and the domain and certificate refreshers are left out; new functions/demo.php and cron/demo_reset.php, no database change, changelog, CONTRIBUTING and README updated
|
2026-11-06 17:46:40 -05:00 |
|
johnnyq
|
79e616614a
|
Set up a hosted instance and connect it in one command - Add Instance takes the address it will have, and the instance page gives a ready setup_cli command with the connection code and the client's company name, address, phone, website, tax ID, currency and primary contact as the first admin; setup_cli gains --manager-code and --manager-required (connects after setup, writes the managed line to config.php, exits 3 if it set up but could not connect), --ask-missing, --generate-password, --json and ITFLOW_SETUP_ environment variables for any option, and shows the cron job as a crontab line and for a hosting panel with the full PHP path; Managed Instances shows a connected instance whose cron has never run as Waiting for its cron job with the command to add, and the Managed Instances job says so in its notification; new managedSetupCommand(), the cron command in the instance report and the waiting state in managedInstanceHealth(), changelog updated
|
2026-11-06 14:29:27 -05:00 |
|
johnnyq
|
b391e2ce6c
|
Add Skyetel text messaging with two-way ticket texting, text to ticket for contacts, Text reply on tickets, a Texts inbox for unmatched numbers, verification codes and spam (codes masked, limited to credential access, every reveal audited, wiped after a day), STOP/START/HELP handling, a text log with retry and cancel in Maintenance > Text Messages, the Text Messages cron job, and texts to clients about their tickets, visits, visit reminders and invoices with per-contact opt-in from the contact, by text or in the client portal, quiet hours, and new settings in Tickets and Notifications (database 3.6.0 and 3.6.1)
|
2026-11-06 00:08:10 -05:00 |
|
johnnyq
|
87cdf79b28
|
Make managed mode off by default and turned on per side in config.php - $config_enable_managed_instances = true; adds Admin > Managed Instances, the api/managed endpoints and the Managed Instances cron job, and $config_enable_managed_by = true; (or $config_manager_required = true;) adds Admin > Managed By, the Manager Check-in cron job and support sign-in; with a side off its menu entry, pages, modal, post handler and cron job are gone, the manager endpoints answer 503 so instances keep their connection and retry, a connected instance stops checking in and its locks, read-only and suspended lift while its connection is kept, any open support session is ended, and the support user still takes no seat; new managerEnabled(), managedEnabled() and managedConnected(), the cron registry and health check leave out the jobs of a side that is off, changelog updated
|
2026-11-05 20:17:42 -05:00 |
|
johnnyq
|
3b5c11c552
|
Add managed mode, so one ITFlow can manage others - Admin > Managed Instances adds an instance and gives a one-time connection code (a week) that the other ITFlow pastes into the new Admin > Managed By, after which it checks in every minute from the new Manager Check-in cron job with a health report (versions, update waiting and whether it has security fixes, cron, last backup, errors today, agents against the seat limit, clients, storage) and takes back what the manager sets; the manager lists each instance's version, health, seats and last check-in with a page per instance showing what needs a look, its requests and everything it reported, can update it by hand or automatically after a set number of days (security releases straight away, not retried for six hours after a failure), set its seat limit and white-label key (locked on the instance while set), make it read-only (look, export and download only, across agents, portal, guest links and the API) or suspended (a notice with the manager's message and contact, 503 for the API) with other cron jobs paused until it is active again, sign in to it as support through a signed one-time two-minute link into a two-hour session that takes no seat, can't open the vault and can't set passwords or make API keys, and remove it, while the new Managed Instances job notifies when one stops checking in and closes requests never answered; instances only call the manager, can disconnect unless config.php sets $config_manager_required, and the Update page and queue_update defer to the manager; database 3.5.8 adds managed_instances, managed_instance_commands, settings.config_manager_keys and settings.config_managed, the logic is in the new functions/managed.php with api/managed/enroll.php, api/managed/checkin.php, login_support.php and includes/managed_blocked.php, cronJobClaim() takes a paused reason that leaves a due job due, getAgentUserLimit() and getActiveAgentUserCount() honour the manager's limit and leave out the support user, the vault helpers read a missing session key as empty, the audit log knows the new types and actions, and the email parser no longer logs an App Logs error every minute while parsing is switched off; changelog updated
|
2026-11-05 15:22:41 -05:00 |
|
johnnyq
|
d7bc1bccf7
|
Make Maintenance > Update easier to follow - it opens with where the install stands (up to date, an update available, updating, the database still to finish, checking) and the one button for it, Update ITFlow in place of Queue Update, with what's new below it (the release notes between this install and the latest, read from the changelog by the update check, developer notes and commits folded away), what to do first including the ITFlow files changed on this install that updating would put back, the update shown running with the page refreshing itself and then when it finished or what stopped it, and this install's version, branch, database, commit, last check, last update, cron and the command to update from a shell alongside; database 3.5.7 adds settings.config_update_details, written by cron/update_check.php through the new updateCheckDetails(), updateChangelogSections() and updateChangelogHtml() render the release notes escaped, cron/app_update.php asks for a fresh check after an update, changelog updated
|
2026-11-05 14:25:19 -05:00 |
|
johnnyq
|
cf2c9c2d9b
|
Let clients pay the card fee - turn on Clients pay the card fee on Stripe in Admin > Payment Providers with Stripe's percent and fixed rate, and each card payment in the client portal, through an invoice's link, by autopay or from Charge Saved Card is grossed up so Stripe's fee comes out of it, with one fee per payment shared over its invoices; the fee is shown before paying (Pay invoices, checkout, the guest pay page, invoice pages, autopay and the Charge Saved Card window) and goes on each invoice as a Card Fee line with no tax when the payment is booked, carried in the PaymentIntent's itflow_fees metadata and checked against the amount received to the cent; a client can be let off it with No card fee on their Billing tab, refunding a card payment takes its Card Fee line back off, autopay and Charge Saved Card now compare cents instead of whole dollars, database 3.5.6 adds the provider and client columns, changelog updated
|
2026-11-05 12:47:06 -05:00 |
|
johnnyq
|
e472c95a11
|
Record Stripe fees every 15 minutes instead of once a night - a new Payment Provider Fees cron job runs the fee recorder that Nightly Tasks used to, Nightly Tasks no longer does, the recorder holds a lock so the job and Record fees now can't both record the same fee, and the payment provider screens no longer say fees are recorded each night
|
2026-11-04 14:38:32 -05:00 |
|
Wrongecho
|
16ee56c044
|
Add cron notification for expiring api keys
|
2026-11-03 14:42:26 +00:00 |
|
johnnyq
|
568a907ff9
|
Add agent invites: New User now emails an invite by default so the agent chooses their own password on the new join.php page, and Set a password now stays as the other option with the email that contained the password removed; database 3.5.1 adds user_invites with only a hash of the link's token kept and the vault master key locked under that token until it is accepted, cancelled or runs out; new functions/user_invite.php; adds the Invited view to Users with Send again, Get the link (shown once, also used when mail is not set up) and Cancel invite; waiting invites count toward the agent user limit and a role with waiting invites cannot be archived; the Get started team step invites when mail is set up; the quick look shows whose invite an agent joined from; replaces the new account email preview with the invite email; the nightly job clears invites cancelled or run out more than 90 days ago; adds userAvatarStore(); updates the changelog
|
2026-10-28 01:16:49 -04:00 |
|
johnnyq
|
9ba21cf352
|
Assets: add NAS, UPS, PDU, Modem/ONT and NVR/DVR types from a new registry in functions/asset_type.php that sets each type's icon, tone, group, fields and details; the asset form shows only the fields a type uses (fields that already hold a value stay shown) and adds a Details section per type (CPU/RAM/storage, VM host/vCPUs, switch ports/SFP/PoE/management, NAS drives/capacity/RAID, UPS capacity/output/runtime/outlets/battery dates, PDU kind/outlets/input, modem circuit ID/ISP account, printer, phone, mobile, display, camera and NVR details) stored in a new asset_specs table (database 3.4.9); new or changed port and SFP counts add the missing interfaces, continuing the asset's numbering, skipping Wi-Fi, VLAN and management ports and never deleting any; the asset page and quick look show the details, a server or NAS lists the VMs that run on it, and Assigned and Warranty show only on types that use them; the list gets Servers & NAS and Power tabs, an optional Details column, a UPS battery badge, an Assigned picker only on assigned types, and New buttons named for what they add; nightly UPS Battery Due notifications at 45, 7 and 1 days as a Support notification; copy leaves out per-unit details, Transfer to Client carries details and interface types, export adds per-detail columns, import reads detail columns after the standard twelve (VM hosts by name, resolved after every row is in) and reports values it could not keep, and the API reads and writes asset_specs; racks, client portal, client export, overview, document templates and AI lists group the new types; fix asset import carrying physical location and notes into the next row, saving 0000-00-00 for a missing purchase date and warning on an unknown contact or location, save API and import types in the list's spelling, and keep interface types on transfer; changelog updated
|
2026-10-27 15:59:03 -04:00 |
|
johnnyq
|
0e272910fb
|
Client portal: invite people by email from a client's Contacts (Invites tab with send again, cancel, search and sorting) or by the primary contact in the portal, several at once with optional names and roles, each joining from the emailed link with their own name, title, phone and password or Microsoft 365 and becoming a contact then, an existing contact with that address being given access instead; self sign-up from Create an account on the sign-in page for addresses at a client's Domains when it is on in Admin > Settings > Client portal and for that client, verified by an emailed link and joining as a plain contact with agents and the primary contact told; the same answer whatever address is entered, per address and per IP limits and a hidden field for bots; nightly clean-up of unused links; six new email previews; new functions/portal_invite.php, client/invite.php, client/join.php and client/signup.php, replacing the unused contact_invite modal; DB 3.4.6 adds portal_invites, client_portal_signup and config_client_portal_signup
|
2026-10-25 01:07:53 -04:00 |
|
johnnyq
|
77df925981
|
Contracts stage 4: a contract in force sets the client's SLA for new tickets, the hourly rate with an after-hours rate for tickets opened outside business hours, and net terms for new invoices, the one that started last first and the client's own where it is empty; Unbilled Time bills each ticket at its own rate with one line per rate, and the ticket invoice window, Add Tickets, quote from a ticket, Unbilled Work and Time Detail reports, New Invoice, copy, quote to invoice, the invoice page, client overview and client edit follow it; a recurring invoice made from or linked to a contract is paused while it is a draft, started when it is made active or renewed with missed runs skipped, and paused once when it ends or its cancellation takes effect; new functions/contract_billing.php; fixes agent names double-escaped in the prepaid hours history; DB 3.4.5 adds contract_recurring_invoice_id and contract_recurring_stopped_at and treats a 0.00 contract rate as empty
|
2026-10-25 01:06:59 -04:00 |
|
johnnyq
|
0f9038b1ed
|
Contracts stage 3: prepaid hours - hours included each month, and blocks bought with a price, expiry, note and an optional draft invoice; a nightly draw of billable ticket time, oldest ticket first from the hours that run out first, with Draw now and Put back, and a ticket the hours run out on staying in Unbilled Time at the usual rate; Prepaid hours card, a low hours email to the owner, and hours left on the contracts list, client overview, ticket, Unbilled Time and the client portal; [Monthly Hours] placeholder; new functions/contract_hours.php; DB 3.4.4 adds monthly hours and the alert level to contracts and templates, plus contract_blocks and contract_block_uses
|
2026-10-25 01:06:27 -04:00 |
|
johnnyq
|
0da515fff5
|
Contracts stage 1: new Contracts list and page under Billing and the client menu with type, term, start and end, auto renew, notice days, support hours, rates, net terms and an SLA per priority from Admin > SLAs (empty uses the client's own), stat tiles, Active, Due soon, Drafts, Ended and All tabs, search, type and client filters and sorting; New, Copy and Edit from a template with an owner and contact, Make active, Renew and Cancel; nightly renewal or ending and an owner reminder a month before the notice date; client overview attention items and the contract in the Financial row; Contract Templates rebuilt with Template, Cover and Terms tabs, copy, archive and restore; new functions/contract.php; fixes deleting a client that has a contract, a new template's after-hours rate not saving, rates cut to whole amounts, Net 30 saved as 0 and Edit blanking the rates; DB 3.4.2 turns the old response and resolution hours into SLAs and renewal frequency into term and auto renew, and normalises type, status and net terms
|
2026-10-25 01:05:09 -04:00 |
|
johnnyq
|
be374e9c2b
|
Rebuild Admin > Ticket Statuses: list on the standard pattern with In use and Switched off tabs, search, sortable headers, ticket counts linking to the tickets, SLA clock and client-reply columns and drag ordering for the pickers and board; one New/Edit window with badge preview, colour swatches and a description shown on hover across the app; per-status choice of whether a client reply by email or portal moves the ticket back to Open or leaves it; switch off and delete move a status's tickets to a chosen status with ticket history and SLA sync, and clear canned responses that set it; built-in statuses keep their names, stay on and have fixed SLA and reply behaviour enforced server-side; badges use readable text colour; the tickets filter keeps a switched-off status; database 3.4.0 adds ticket_status_description and ticket_status_client_reply; new functions/ticket_status.php
|
2026-10-24 15:14:10 -04:00 |
|
johnnyq
|
96076d295e
|
Ticket emails carry the conversation: the new message first, then earlier public replies newest first and the request, as short plain-text excerpts without pictures, cut when long, with the rest counted after four, never internal notes, archived replies or the portal's resolve, reopen and close lines; resolved, closed, work booked, watcher added, assigned to you, client replied and the SLA alerts all carry it, so resolving with the Resolve button or on the board no longer sends an empty Resolved email; the inbox preview line is the start of the message or what happened instead of the number and subject; the new ticket email to a client's colleagues shows what was asked for portal and agent tickets but never an emailed ticket's words, and the emailed-ticket confirmation still doesn't repeat them; the email parser cuts a plain-text reply at the reply line too; adds emailPlainText, ticketEmailHistory, ticketEmailExcerpt and ticketEmailPreview and a history block in emailHtml; changelog
|
2026-10-24 13:27:48 -04:00 |
|
johnnyq
|
808c27a0fc
|
AI stage 2: AI on tickets - Draft button in the ticket reply editor that writes the next reply from the ticket or from typed notes, for the reply type picked, leaving internal notes out of anything the client reads, with undo; richer ticket summary from the whole ticket with Save as a note, Copy and Again; Triage with AI suggesting a category and priority shown on the ticket to apply in part or dismiss, logged in the ticket history; automatic triage of new email, portal and API tickets with a Settings > Tickets mode of off, suggest or fill in and a new AI Triage cron job; Write up as a document drafting a knowledge base document from a ticket into the New Document form for the client or the company's own client record, linked to the ticket's asset, with passwords and keys left out as [removed]; new ticket features shown by name in AI Usage; database 3.3.9 adds config_ticket_ai_triage and ai_ticket_triage
|
2026-10-20 18:58:14 -04:00 |
|
johnnyq
|
80cdc4de41
|
AI stage 1: rebuild AI Providers and AI Models in the standard list pattern with ready-made provider kinds (OpenAI, Anthropic, Azure OpenAI, Gemini, Mistral, Groq, OpenRouter, Ollama, LM Studio, OpenAI-compatible), Test that lists a provider's models, Save anyway for a provider that doesn't answer, a first model offered when adding the first provider, the API key no longer shown, from-to audit lines, and delete confirms that say what goes and what stops; model window with suggested models, use case notes and Try it; new AI Usage page logging each request by feature, user, client, model, tokens, time and failure, with totals, views and filters, pruned with the audit log; passwords, keys, 2FA links and card numbers taken out before sending and put back in the answer, on by default per provider; new Use AI role permission; Reword shown only when set up and allowed, placed first in the toolbar, with its own instructions, undo in one step and a fixed endpoint on admin pages; ticket summary and template drafts purified; Settings overview warns while AI requests keep failing; database 3.3.8 adds provider kind and redact, ai_usage and module_ai
|
2026-10-20 17:45:00 -04:00 |
|
johnnyq
|
8d3fbcb2ab
|
Payment Providers stage 3: the providers list shows card payments in the last 30 days with their total and the last payment date, and fees recorded in 30 days with a count of payments whose fee is still to record, flagged once more than two days old; adds Check connection, which reports the Stripe account the saved key belongs to or why it is not connected, and Record fees now, which runs the nightly fee reconciliation on demand through the same shared function the nightly job now uses; Settings > Invoices and billing shows how card payments stand under Paid online, and the Settings overview flags test keys, card payments going into an archived account, and Stripe fees not being recorded, with the Invoices and billing tile showing whether cards are on; overview warnings keep their button beside the text where there is room
|
2026-10-20 16:17:32 -04:00 |
|
johnnyq
|
0618ecfdd0
|
Mail queue stage 2: keep why each email failed or who cancelled it in the new email_queue.email_error column (database 3.3.7), written by the worker on every failure path and cleared on send or retry, show and search it on the list, include it in failure alerts and alert when the last retry gives up, and rebuild the email view with its status, reason, recipients, tries, times, attachments, calendar file, Retry now, Cancel and Delete, showing the message in a sandboxed frame
|
2026-10-20 11:34:57 -04:00 |
|
johnnyq
|
7e2971b610
|
Mail queue stage 1: rebuild the mail queue list with Waiting, Sending, Retrying, Failed, Sent and Cancelled tabs and counts, a status line per email, a banner when sending is off, cron is off or not running, the job is disabled or mail is waiting too long, and Retry now, Cancel and Delete per email and in bulk applied only where possible, add a Cancelled status, record the failure time for bad addresses, share the retry limits between the page and the worker, and fix the theme favicon reset failing on its audit entry
|
2026-10-20 11:34:23 -04:00 |
|
johnnyq
|
dfc708145d
|
Vendor templates stage 1: Admin > Vendor Templates rebuilt on the standard list with Active and Archived tabs, support line, hours and SLA, how many clients have a vendor from each, last used and changed by, sortable and searchable including by support line; new template page with what a vendor starts with, the clients with it and their account numbers, the license templates that use it, made and changed by, and history; shared New/Edit window on the vendor window's tabs with per-field push to the vendors made from it, each logged on the vendor; copy, archive, restore and delete with vendors and license templates unlinked on delete; Make a template from a client's vendor, linking the vendor to it, and the vendor page linking its template for admins; Delete offered to every admin role, not only the built-in Administrator; the admin handler no longer includes the agent vendor handler; database 3.3.4 adds vendor_template_created_by and vendor_template_updated_by, backfilled from the audit log
|
2026-10-19 12:34:53 -04: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 |
|
johnnyq
|
ea23a2bad5
|
Audit logs stage 1: Admin > Audit Logs rebuilt on the standard list with search, sortable columns and paging, filters for date, who (agent, portal contact or ITFlow itself), client, type and action, and counted views for Changes, Deletions, Sign-ins, Security and Data out; each entry shows who with their avatar, the client, the type and action as a coloured label, the description without the name in front, the IP and device in words, and links to its record while it exists or says No longer here; a quick look with the full entry, the raw user agent, everything from that IP, the record's other entries and what the same person did 15 minutes either side; CSV/PDF export with the page's filters, view and picked columns, itself audited; new functions/audit_log.php, admin/modals/audit_log/audit_log.php and audit_log_export.php, admin/post/audit_log.php and audit_logs export columns; agent/files.php takes ?open= for a file's quick look; database 3.3.1 adds log_client_id and log_entity_id keys on logs, gives each action one name (Unarchive/Restored to Restore, Deleted, Merged, Closed, Reopened, Resolved and Sent to Delete, Merge, Close, Reopen, Resolve and Send, Client Access to Denied, saved card and payment provider Updates to Create or Delete, contract template Update to Edit, type client to Client) and repoints entries at the right record (reply edits and redactions to the ticket, API document edits to the document, reimbursements to the recording expense, API client restores to the client), guarded so it can run again; logAudit call sites in agent, admin, api, client, cron and functions use the same names and record ids
|
2026-10-18 22:36:25 -04:00 |
|