Admin Scheduled Messages

$stats = [
    'active' => ScheduledMessage::where('status', 'pending')->count(),
    'paused' => ScheduledMessage::where('status', 'paused')->count(),
    'completed' => ScheduledMessage::where('status', 'completed')->count(),
    'failed' => ScheduledMessage::where('status', 'failed')->count(),
];

// From AdminScheduledMessageController.php:21-23
if ($request->filled('user_id') && $request->user_id !== 'all') {
    $query->where('user_id', $request->user_id);
}

// From AdminScheduledMessageController.php:26-28
if ($request->filled('status') && $request->status !== 'all') {
    $query->where('status', $request->status);
}

// From AdminScheduledMessageController.php:31-33
if ($request->filled('type') && $request->type !== 'all') {
    $query->where('schedule_type', $request->type);
}

// From AdminScheduledMessageController.php:36-38
if ($request->filled('webhook_id') && $request->webhook_id !== 'all') {
    $query->where('webhook_id', $request->webhook_id);
}

// From AdminScheduledMessageController.php:41-47
if ($request->filled('date_from')) {
    $query->where('next_send_at', '>=', $request->date_from);
}

if ($request->filled('date_to')) {
    $query->where('next_send_at', '<=', $request->date_to);
}

// From AdminScheduledMessageController.php:81-88
public function show(ScheduledMessage $scheduled)
{
    $scheduled->load(['user', 'webhook', 'template', 'files']);

    return Inertia::render('admin/scheduled-messages/show', [
        'message' => $scheduled,
    ]);
}

// From AdminScheduledMessageController.php:90-98
public function pause(ScheduledMessage $scheduled)
{
    if ($scheduled->schedule_type === 'recurring' && 
        $scheduled->status === 'pending') {
        $scheduled->update(['status' => 'paused']);
        return back()->with('success', 'Message paused successfully!');
    }

    return back()->withErrors(['error' => 'Cannot pause this message']);
}

// From AdminScheduledMessageController.php:100-112
public function resume(ScheduledMessage $scheduled)
{
    if ($scheduled->status === 'paused') {
        $nextSendTime = $scheduled->calculateNextSendTime();
        $scheduled->update([
            'status' => 'pending',
            'next_send_at' => $nextSendTime,
        ]);
        return back()->with('success', 'Message resumed successfully!');
    }

    return back()->withErrors(['error' => 'Cannot resume this message']);
}

// From AdminScheduledMessageController.php:114-125
public function destroy(ScheduledMessage $scheduled)
{
    // Delete files associated with the message
    foreach ($scheduled->files as $file) {
        $file->delete();
    }

    $scheduled->delete();

    return redirect()->route('admin.scheduled.index')
        ->with('success', 'Scheduled message deleted successfully!');
}

public function calculateNextSendTime(): ?Carbon
{
    if ($this->schedule_type === 'once') {
        return null;
    }

    $pattern = $this->recurrence_pattern;
    $timezone = $this->timezone ?? 'UTC';
    $now = Carbon::now($timezone);

    // Calculate based on frequency (daily, weekly, monthly)
    // Returns next send time in UTC
}

// From ScheduledMessage.php:171-177
public function markAsFailed(string $error): void
{
    $this->update([
        'status' => 'failed',
        'error_message' => $error,
    ]);
}

// List all scheduled messages with filters
GET /admin/scheduled-messages

// View single message details
GET /admin/scheduled-messages/{id}

// Pause a recurring message
POST /admin/scheduled-messages/{id}/pause

// Resume a paused message
POST /admin/scheduled-messages/{id}/resume

// Delete a scheduled message
DELETE /admin/scheduled-messages/{id}