GRT Ticket

Description

Note on Minified JS: The public/js/supabase.js file is a minified build of the Supabase JS client. Source code available at: https://github.com/supabase/supabase-js

Features

• Webhooks & Integrations (New!): Send notifications to Slack, Discord, or Zapier when a new ticket is created.
• Supabase Integration: True real-time chat powered by Supabase Realtime DB (optional)
• Guest Access (New!): Guests can view and reply to their tickets immediately after submission via secure cookie (no login required).
• Create and manage tickets from WordPress admin and frontend
• Real-time chat between users and admins
• Custom Fields Builder: Create custom forms with Text, Textarea, Number, Email, URL, Select, and Date fields
• Advanced Search: Filter tickets by User Name or Ticket ID instantly
• Guest Ticket Submission: Users can submit tickets without an account (secure cookie access)
• User Profile: Users can manage their profile and upload avatars
• Auto-Assignment: Automatically assign tickets to agents based on category
• Agent Performance: View stats on agent performance and ticket resolution
• Email Piping: User replies via email are automatically added to ticket chat
• Email Notifications: Chat replies are sent to user email (with direct frontend links)
• IMAP/SMTP settings configurable via plugin settings
• Secure input handling and WordPress coding standards compliant
• Fully GPL-2.0 compatible

External Services

This plugin integrates with the following third-party services:

1. Twilio (Optional)

• Service: Twilio API (WhatsApp & SMS)
• Usage: Sends notifications to admins and users via WhatsApp or SMS.
• Data Sent: Message content, phone numbers.
• Privacy Policy: Twilio Privacy Policy

2. Supabase (Optional)

• Service: Supabase Realtime
• Usage: Provides real-time chat capabilities.
• Data Sent: Chat messages, user IDs (for authentication).
• Privacy Policy: Supabase Privacy Policy

3. Webhooks (Slack, Discord, Zapier)

• Usage: Sends ticket data to external services for notification/automation.
• Data Sent: Ticket details (title, ID, user email, message).

Supabase Configuration (Optional for Realtime)

1. Create a project at Supabase.
2. Get your Project URL, Anon Key, and Service Role Secret.
3. In WordPress, go to GRT Ticket > Settings and enter these credentials.
4. In Supabase SQL Editor, run this command to create the messages table:
   create table public.grt_messages ( id bigint not null, ticket_id bigint not null, sender_type text not null, sender_name text not null, message text null, attachment_url text null, is_internal integer null default 0, created_at timestamp with time zone null default now(), constraint grt_messages_pkey primary key (id) ) TABLESPACE pg_default;
5. IMPORTANT: Go to Supabase Dashboard > Database > Publications (or Replication) and enable “grt_messages” for Realtime. (Otherwise, no messages will be received!)
6. Enable “Realtime Chat” in plugin settings.