17 Commits

Author	SHA1	Message	Date
Jonathan Miller	8c82b39747	feat(tickets): add status/priority admin CRUD (#206) ... New 'ticketsettings' view with inline CRUD for ticket statuses and priorities: - Table display with color preview, default/closed flags, ordering - Inline add/edit form with all fields - Delete with in-use protection (can't delete if tickets reference it) - Auto-generates alias from title - Controller actions: saveStatus, deleteStatus, savePriority, deletePriority - Gated by core.admin ACL	2026-06-11 21:53:01 -05:00
Jonathan Miller	945fe0de93	fix(tickets): wire contact, assignees through controller + fix status type bug ... - Pass contact_id, assign_users, assign_groups, custom_fields from controller to model on ticket creation - Fix updateTicketStatus: getString→getInt (was passing string to int param) - Add getBackendUsers() and getUserGroups() to TicketsModel - Add assign users/groups multi-select fields to creation modal	2026-06-11 21:53:00 -05:00
Jonathan Miller	d26b980f43	fix(catalog+modules): rename MokoJoomBackup to MokoSuiteBackup, enforce module first-position ordering ... Update catalog entry to point to the correct MokoSuiteBackup repo with updated description and article URL. Add per-session ordering enforcement so MokoSuite admin modules are always first in their position slot.	2026-06-09 23:32:21 -05:00
Jonathan Miller	8b9fff7282	fix: remove DEFAULT on TEXT columns for MySQL strict mode ... MySQL strict mode rejects DEFAULT values on TEXT/BLOB columns. Remove DEFAULT '[]' from conditions and actions in automation table.	2026-06-09 11:45:37 -05:00
Jonathan Miller	d59939a89c	feat(helpdesk): IMAP email-to-ticket polling + auto-close (#136) ... IMAP polling scheduled task: - Connects via php-imap, reads UNSEEN messages - Creates tickets from new emails, matches sender to Joomla user - Detects replies via [#123] in subject line - Marks processed emails as seen, optionally moves to folder - IMAP config fields in component options Auto-close scheduled task: - Closes resolved tickets after configurable days - Uses autoclose_days from component params Both registered as Joomla scheduled task types in plg_task_mokosuite_tickets alongside existing automation task.	2026-06-09 11:21:22 -05:00
Jonathan Miller	4349b20e34	feat(helpdesk): automation engine with Joomla event triggers (#151) ... - AutomationEngine service: fire/evaluate/execute pattern - Condition evaluation: eq, neq, gt, lt, in, not_in operators - Actions: set_status, set_priority, assign, add_note, send_email, send_ntfy, close, create_ticket - Behavior column: append (to existing), always_new, skip_if_open - New Joomla event triggers: user_login, user_register, content_save, extension_install, user_login_failed - System plugin hooks: onUserAfterSave, onContentAfterSave, onExtensionAfterInstall, onUserAfterLogin (also fires automation) - Visual builder updated with new triggers and behavior dropdown	2026-06-09 11:15:57 -05:00
Jonathan Miller	b0ea119b55	feat(helpdesk): visual automation rule builder with edit + reorder (#137) ... - Visual condition builder: field/operator/value dropdowns per row - Visual action builder: type/value dropdowns per row - Add/remove rows dynamically, no raw JSON editing - Click existing rule card to edit in modal - Drag-and-drop reorder with reorderAutomation task - Added send_ntfy and ticket_assigned trigger types - Fixed XSS: replaced innerHTML with safe DOM methods for builder rows	2026-06-09 10:51:12 -05:00
Jonathan Miller	3047327d2e	feat(config): complete component options UI (#149) ... - General: brand name, support email - Notifications: ntfy push settings (server, topic, security topic, token) with showon conditional display when ntfy is enabled - Helpdesk: satisfaction ratings toggle, max attachment size - All ntfy fields map to NotificationService config keys	2026-06-09 10:47:35 -05:00
Jonathan Miller	fbb467a832	feat(helpdesk): satisfaction ratings on resolved tickets (#140) ... - satisfaction_rating (1-5), satisfaction_feedback, satisfaction_rated_at columns - Star rating widget in ticket sidebar (appears when resolved/closed) - Hover highlight + click to select rating - Optional feedback textarea - rateTicket controller task persists rating via AJAX - Displays existing rating with stars + feedback when already rated	2026-06-09 10:42:39 -05:00
Jonathan Miller	57534eec9c	feat(helpdesk): file attachments on tickets and replies (#141) ... - #__mokosuite_ticket_attachments table - AttachmentService: upload, download, delete with type/size validation - Allowed: jpg,png,gif,webp,pdf,doc,docx,xls,xlsx,csv,txt,zip (10MB max) - Secure storage in /media/com_mokosuite/attachments/{ticket_id}/ - Upload field in reply form, auto-uploads after reply creation - Download links on ticket and reply cards - Controller tasks: uploadAttachment, downloadAttachment, deleteAttachment	2026-06-09 10:34:49 -05:00
Jonathan Miller	cc3d0df2c2	feat(helpdesk): add drag-and-drop reorder to categories (#139) ... - Drag handle column with icon-menu grip - HTML5 native drag-and-drop on table rows - reorderCategory controller task persists ordering via AJAX	2026-06-09 10:25:44 -05:00
Jonathan Miller	510d3f1f7d	feat(helpdesk): complete canned responses admin UI (#138) ... - Edit existing responses via modal (click card to edit) - Category filter dropdown in list view - Drag-and-drop reorder with AJAX persistence - reorderCanned controller task for ordering - Category badges on response cards	2026-06-09 10:21:43 -05:00
Jonathan Miller	05be465f96	feat(notifications): add ntfy push for ticket and security events (#205) ... Adds pushNtfy() alongside existing email notifications in NotificationService. Sends push via ntfy HTTP API for ticket_created, ticket_replied, status_changed, ticket_assigned events with emoji tags, priority levels, and click-through URLs. Security alerts also pushed via ntfy at priority 5 (urgent). Configurable via component params: ntfy_enabled, ntfy_server, ntfy_topic, ntfy_security_topic, ntfy_token.	2026-06-08 05:22:30 -05:00
Jonathan Miller	a00b1647d4	fix: resolve PR review critical issues — status ID-based updates, SLA checks, counts ... - updateStatus() now accepts status ID, validates against lookup table, writes both status and status_id columns, uses is_closed flag - Added automation recursion guard to prevent infinite loops - getStatusCounts() now joins on statuses table (dynamic, not hardcoded) - getOverdueTickets() uses is_closed instead of ENUM string comparison - Template SLA checks use status_is_closed instead of in_array() - Status summary cards rendered dynamically from lookup table	2026-06-07 11:19:14 -05:00
Jonathan Miller	b2b9ab4344	feat: customizable statuses/priorities, custom fields, and field groups per category ... Replace hardcoded ENUM status/priority with lookup tables (#__mokosuite_ticket_statuses, #__mokosuite_ticket_priorities) so admins can add custom values with colors and ordering. Integrate Joomla's native custom fields (com_mokosuite.ticket context) with a junction table linking field groups to ticket categories. Includes migration SQL to populate new columns from existing ENUM data.	2026-06-07 10:18:33 -05:00
Jonathan Miller	6fedd0e993	feat: ticket contact linking, multi-assignee, and push-based pre-release ... Tickets can now link to Joomla contact records (optional contact_id FK). Replaces single assigned_to with junction table for multi-assignee support — tickets can be assigned to multiple users and/or user groups. Updates pre-release workflow to trigger on push to dev/alpha/beta/rc.	2026-06-07 10:05:06 -05:00
Jonathan Miller	00d44256b4	refactor: rename MokoWaaS to MokoSuite across entire codebase ... Rebrand all 17 sub-extensions from mokowaas to mokosuite naming, including component, plugins, modules, task plugins, and webservices. Updates package manifest, workflows, docs, wiki, and issue templates. Adds new plg_system_mokosuite_license extension.	2026-06-07 09:25:45 -05:00