<?php

namespace Fleetbase\Storefront\Http\Controllers;

use Fleetbase\FleetOps\Models\Contact;
use Fleetbase\FleetOps\Models\Order;
use Fleetbase\Http\Controllers\Controller;
use Fleetbase\Storefront\Models\Store;
use Illuminate\Http\Request;
use Illuminate\Support\Carbon;

class ActionController extends Controller
{
    /**
     * Get the number of storefronts created.
     *
     * @return \Illuminate\Http\Response
     */
    public function getStoreCount(Request $request)
    {
        $count = Store::where('company_uuid', session('company'))->count();

        return response()->json(['storeCount' => $count]);
    }

    /**
     * Get key metrics for storefront.
     *
     * @return \Illuminate\Http\Response
     */
    public function getMetrics(Request $request)
    {
        $store = $request->input('store');
        $start = $request->has('start') ? Carbon::fromString($request->input('start'))->toDateTimeString() : Carbon::now()->startOfMonth()->toDateTimeString();
        $end   = $request->has('end') ? Carbon::fromString($request->input('end'))->toDateTimeString() : Carbon::now()->toDateTimeString();

        // default metrics
        $metrics = [
            'orders_count'    => 0,
            'customers_count' => 0,
            'stores_count'    => 0,
            'earnings_sum'    => 0,
        ];

        // get the current active store
        if (!$store) {
            return response()->json($metrics);
        }

        $store = Store::where('uuid', $store)->first();
        if (!$store) {
            return response()->json($metrics);
        }

        // send back currency
        $metrics['currency'] = $store->currency;

        // - orders count
        $metrics['orders_count'] = Order::where([
            'company_uuid' => session('company'),
            'type'         => 'storefront',
        ])
            ->where('meta->storefront_id', $store->public_id)
            ->whereNotIn('status', ['canceled'])
            ->whereBetween('created_at', [$start, $end])->count();

        // - customers count -- change to where has orders where meta->storefront_id === store
        $metrics['customers_count'] = Contact::where([
            'company_uuid' => session('company'),
            'type'         => 'customer',
        ])->whereHas('customerOrders', function ($q) use ($start, $end, $store) {
            $q->whereBetween('created_at', [$start, $end]);
            $q->where('meta->storefront_id', $store->public_id);
            $q->whereNotIn('status', ['canceled']);
        })->count();

        // - stores count
        $metrics['stores_count'] = Store::where(['company_uuid' => session('company')])->count();

        // - earnings sum
        // $metrics['earnings_sum'] = Transaction::where(['company_uuid' => session('company'), 'type' => 'storefront', 'meta->storefront_id' => $store->public_id])->whereBetween('created_at', [$start, $end])->sum('amount');
        $metrics['earnings_sum'] = Order::where([
            'company_uuid' => session('company'),
            'type'         => 'storefront',
        ])
            ->whereBetween('created_at', [$start, $end])
            ->where('meta->storefront_id', $store->public_id)
            ->with(['transaction'])
            ->whereNotIn('status', ['canceled'])
            ->whereNull('deleted_at')
            ->get()
            ->sum(function ($order) {
                return data_get($order, 'meta.total');
            });

        return response()->json($metrics);
    }

    /**
     * Send promotional push notification to selected customers.
     *
     * @return \Illuminate\Http\Response
     */
    public function sendPushNotification(Request $request)
    {
        $title       = $request->input('title');
        $body        = $request->input('body');
        $customerIds = $request->input('customers', []);
        $storeId     = $request->input('store');
        $selectAll   = $request->boolean('select_all', false);

        // Validate inputs
        if (!$title || !$body) {
            return response()->json(['error' => 'Title and body are required'], 400);
        }

        if (!$selectAll && empty($customerIds)) {
            return response()->json(['error' => 'At least one customer must be selected'], 400);
        }

        // Get the store
        $store = Store::where('public_id', $storeId)->first();
        if (!$store) {
            return response()->json(['error' => 'Store not found'], 404);
        }

        // Get customers
        if ($selectAll) {
            // Get all customers for this store's company
            $customers = Contact::where('company_uuid', session('company'))
                ->where('type', 'customer')
                ->get();
        } else {
            // Get only selected customers
            $customers = Contact::whereIn('uuid', $customerIds)
                ->where('company_uuid', session('company'))
                ->where('type', 'customer')
                ->get();
        }

        // Send notifications
        $sentCount = 0;
        foreach ($customers as $customer) {
            try {
                $customer->notify(new \Fleetbase\Storefront\Notifications\PromotionalPushNotification($title, $body, $store));
                $sentCount++;
            } catch (\Exception $e) {
                // Log error but continue with other customers
                \Log::error('Failed to send push notification to customer: ' . $customer->uuid, ['error' => $e->getMessage()]);
            }
        }

        return response()->json([
            'status'     => 'OK',
            'sent_count' => $sentCount,
            'total'      => count($customers),
        ]);
    }
}