<?php

    namespace App\Http\Controllers\Customer;

    use App\Http\Controllers\Controller;
    use App\Http\Requests\Reports\DashboardRequest;
    use App\Library\SMSCounter;
    use App\Library\Tool;
    use App\Models\Campaigns;
    use App\Models\CampaignsList;
    use App\Models\CampaignsSenderid;
    use App\Models\ContactGroups;
    use App\Models\Contacts;
    use App\Models\Country;
    use App\Models\CustomerBasedPricingPlan;
    use App\Models\CustomerBasedSendingServer;
    use App\Models\PhoneNumbers;
    use App\Models\PlansCoverageCountries;
    use App\Models\Reports;
    use App\Models\Senderid;
    use App\Models\Templates;
    use App\Models\TemplateTags;
    use ArielMejiaDev\LarapexCharts\LarapexChart;
    use Carbon\Carbon;
    use Exception;
    use Generator;
    use Illuminate\Auth\Access\AuthorizationException;
    use Illuminate\Contracts\Foundation\Application;
    use Illuminate\Contracts\View\Factory;
    use Illuminate\Contracts\View\View;
    use Illuminate\Http\JsonResponse;
    use Illuminate\Http\RedirectResponse;
    use Illuminate\Http\Request;
    use Illuminate\Support\Facades\Auth;
    use Illuminate\Support\Facades\DB;
    use JetBrains\PhpStorm\NoReturn;
    use libphonenumber\NumberParseException;
    use libphonenumber\PhoneNumberUtil;
    use OpenSpout\Common\Exception\InvalidArgumentException;
    use OpenSpout\Common\Exception\IOException;
    use OpenSpout\Common\Exception\UnsupportedTypeException;
    use OpenSpout\Writer\Exception\WriterNotOpenedException;
    use Rap2hpoutre\FastExcel\FastExcel;
    use Symfony\Component\HttpFoundation\BinaryFileResponse;

    class ReportsController extends Controller
    {
        /**
         * sms reports
         *
         *
         * @throws AuthorizationException
         */
        public function reports(Request $request): View|Factory|Application
        {
            $this->authorize('view_reports');
            $recipient = $request->input('recipient');
            if ($recipient) {
                $title = __('locale.contacts.conversion_with', ['recipient' => $recipient]);
                $name  = __('locale.contacts.view_conversion');
            } else {
                $title = __('locale.menu.All Messages');
                $name  = __('locale.menu.All Messages');
            }

            $breadcrumbs = [
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Dashboard')],
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Reports')],
                ['name' => $name],
            ];


            $reportStatusCounts = Reports::where('user_id', Auth::user()->id)->selectRaw('
        COUNT(CASE WHEN customer_status = "Enroute" THEN 1 END) as enroute_count,
        COUNT(CASE WHEN customer_status = "Delivered" THEN 1 END) as delivered_count,
        COUNT(CASE WHEN customer_status = "Expired" THEN 1 END) as expired_count,
        COUNT(CASE WHEN customer_status = "Undelivered" THEN 1 END) as undelivered_count,
        COUNT(CASE WHEN customer_status = "Rejected" THEN 1 END) as rejected_count,
        COUNT(CASE WHEN customer_status = "Accepted" THEN 1 END) as accepted_count,
        COUNT(CASE WHEN customer_status = "Skipped" THEN 1 END) as skipped_count,
        COUNT(CASE WHEN customer_status NOT IN ("Enroute", "Delivered", "Expired", "Undelivered", "Rejected", "Accepted", "Skipped") THEN 1 END) as failed_count
    ')
                ->first();

            return view('customer.Reports.all_messages', compact('breadcrumbs', 'recipient', 'title', 'reportStatusCounts'));
        }

        /**
         * get all message reports
         *
         *
         * @throws AuthorizationException
         */
        #[NoReturn]
        public function searchAllMessages(Request $request)
        {
            $this->authorize('view_reports');

            $columns = [
                0  => 'responsive_id',
                1  => 'uid',
                2  => 'uid',
                3  => 'created_at',
                4  => 'direction',
                5  => 'sms_type',
                6  => 'from',
                7  => 'to',
                8  => 'sms_count',
                9  => 'cost',
                10 => 'customer_status',
            ];

            $limit            = $request->input('length');
            $start            = $request->input('start');
            $orderColumnIndex = $request->input('order.0.column');
            $orderColumnName  = $columns[$orderColumnIndex];
            $orderDirection   = $request->input('order.0.dir');

            $totalData = Reports::where('user_id', Auth::user()->id)->count();

            $reports = Reports::where('user_id', Auth::user()->id)
                ->filterByDirection($request->input('direction'))
                ->filterByType($request->input('type'))
                ->filterByStatus($request->input('customer_status'))
                ->filterByFrom($request->input('from'))
                ->filterByTo($request->input('to'))
                ->filterByInputDateRange($request->input('dateRange'));

            $totalFiltered = $reports->count();

            $sms_reports = $reports
                ->orderBy($orderColumnName, $orderDirection)
                ->skip($start)
                ->take($limit)
                ->get();

            $data = [];

            $nestedData['can_delete'] = Auth::user()->customer->getOption('delete_sms_history') == 'yes';

            if ( ! empty($sms_reports)) {
                foreach ($sms_reports as $report) {
                    if ($report->created_at == null) {
                        $created_at = null;
                    } else {
                        $created_at = Tool::customerDateTime($report->created_at);
                    }

                    $nestedData['responsive_id']   = '';
                    $nestedData['uid']             = $report->uid;
                    $nestedData['created_at']      = $created_at;
                    $nestedData['direction']       = $report->getDirection();
                    $nestedData['sms_type']        = $report->getSMSType();
                    $nestedData['from']            = $report->from;
                    $nestedData['to']              = $report->to;
                    $nestedData['sms_count']       = $report->sms_count;
                    $nestedData['cost']            = $report->cost;
                    $nestedData['customer_status'] = $report->customer_status;
                    $data[]                        = $nestedData;

                }
            }

            $json_data = [
                'draw'            => intval($request->input('draw')),
                'recordsTotal'    => $totalData,
                'recordsFiltered' => $totalFiltered,
                'data'            => $data,
            ];

            echo json_encode($json_data);
            exit();

        }

        /**
         * view single reports
         */
        public function viewReports(Reports $uid): JsonResponse
        {
            return response()->json([
                'status' => 'success',
                'data'   => $uid,
            ]);
        }

        /**
         * @throws Exception
         */
        public function destroy(Reports $uid): JsonResponse
        {
            if (config('app.stage') == 'demo') {
                return response()->json([
                    'status'  => 'error',
                    'message' => 'Sorry! This option is not available in demo mode',
                ]);
            }

            if ( ! $uid->delete()) {
                return response()->json([
                    'status'  => 'error',
                    'message' => __('locale.exceptions.something_went_wrong'),
                ]);
            }

            return response()->json([
                'status'  => 'success',
                'message' => __('locale.campaigns.sms_was_successfully_deleted'),
            ]);

        }

        /**
         * bulk sms delete
         */
        public function batchAction(Request $request): JsonResponse
        {
            if (config('app.stage') == 'demo') {
                return response()->json([
                    'status'  => 'error',
                    'message' => 'Sorry! This option is not available in demo mode',
                ]);
            }

            $ids = $request->get('ids');

            if (Reports::whereIn('uid', $ids)->where('user_id', auth()->user()->id)->delete()) {
                return response()->json([
                    'status'  => 'success',
                    'message' => __('locale.campaigns.sms_was_successfully_deleted'),
                ]);
            }

            return response()->json([
                'status'  => 'error',
                'message' => __('locale.exceptions.something_went_wrong'),
            ]);
        }

        /**
         * sms received
         *
         * @throws AuthorizationException
         */
        public function received(): View|Factory|Application
        {
            $this->authorize('view_reports');

            $breadcrumbs = [
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Dashboard')],
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Reports')],
                ['name' => __('locale.menu.Received Messages')],
            ];

            return view('customer.Reports.received_messages', compact('breadcrumbs'));
        }

        /**
         * get all received reports
         *
         *
         * @throws AuthorizationException
         */
        #[NoReturn]
        public function searchReceivedMessage(Request $request)
        {
            $this->authorize('view_reports');

            $columns = [
                0  => 'responsive_id',
                1  => 'uid',
                2  => 'uid',
                3  => 'created_at',
                5  => 'sms_type',
                6  => 'from',
                7  => 'to',
                8  => 'sms_count',
                9  => 'cost',
                10 => 'status',
            ];

            $totalData = Reports::where('user_id', auth()->user()->id)->where('direction', Reports::DIRECTION_INCOMING)->count();

            $totalFiltered = $totalData;

            $limit = $request->input('length');
            $start = $request->input('start');
            $order = $columns[$request->input('order.0.column')];
            $dir   = $request->input('order.0.dir');

            if (empty($request->input('search.value'))) {
                $sms_reports = Reports::where('user_id', auth()->user()->id)->where('direction', Reports::DIRECTION_INCOMING)->offset($start)
                    ->limit($limit)
                    ->orderBy($order, $dir)
                    ->get();
            } else {
                $search = $request->input('search.value');

                $sms_reports = Reports::where('user_id', auth()->user()->id)->where('direction', Reports::DIRECTION_INCOMING)->whereLike(['uid', 'sms_type', 'from', 'to', 'cost', 'status', 'created_at'], $search)
                    ->offset($start)
                    ->limit($limit)
                    ->orderBy($order, $dir)
                    ->get();

                $totalFiltered = Reports::where('user_id', auth()->user()->id)->where('direction', Reports::DIRECTION_INCOMING)->whereLike(['uid', 'sms_type', 'from', 'to', 'cost', 'status', 'created_at'], $search)->count();
            }

            $data = [];
            if ( ! empty($sms_reports)) {

                $nestedData['can_delete'] = Auth::user()->customer->getOption('delete_sms_history') == 'yes';

                foreach ($sms_reports as $report) {
                    if ($report->created_at == null) {
                        $created_at = null;
                    } else {
                        $created_at = Tool::customerDateTime($report->created_at);
                    }

                    $nestedData['responsive_id'] = '';
                    $nestedData['uid']           = $report->uid;
                    $nestedData['created_at']    = $created_at;
                    $nestedData['sms_type']      = $report->getSMSType();
                    $nestedData['from']          = $report->from;
                    $nestedData['to']            = $report->to;
                    $nestedData['cost']          = $report->cost;
                    $nestedData['sms_count']     = $report->sms_count;
                    $nestedData['status']        = str_limit($report->status, 20);
                    $data[]                      = $nestedData;

                }
            }

            $json_data = [
                'draw'            => intval($request->input('draw')),
                'recordsTotal'    => $totalData,
                'recordsFiltered' => $totalFiltered,
                'data'            => $data,
            ];

            echo json_encode($json_data);
            exit();

        }

        /**
         * sms sent
         *
         * @throws AuthorizationException
         */
        public function sent(): View|Factory|Application
        {
            $this->authorize('view_reports');

            $breadcrumbs = [
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Dashboard')],
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Reports')],
                ['name' => __('locale.menu.Sent Messages')],
            ];

            return view('customer.Reports.sent_messages', compact('breadcrumbs'));
        }

        /**
         * get all sent reports
         *
         *
         * @throws AuthorizationException
         */
        #[NoReturn]
        public function searchSentMessage(Request $request)
        {
            $this->authorize('view_reports');

            $columns = [
                0  => 'responsive_id',
                1  => 'uid',
                2  => 'uid',
                3  => 'created_at',
                5  => 'sms_type',
                6  => 'from',
                7  => 'to',
                8  => 'sms_count',
                9  => 'cost',
                10 => 'status',
            ];

            $totalData = Reports::where('user_id', auth()->user()->id)->where('direction', Reports::DIRECTION_OUTGOING)->count();

            $totalFiltered = $totalData;

            $limit = $request->input('length');
            $start = $request->input('start');
            $order = $columns[$request->input('order.0.column')];
            $dir   = $request->input('order.0.dir');

            if (empty($request->input('search.value'))) {
                $sms_reports = Reports::where('user_id', auth()->user()->id)->where('direction', Reports::DIRECTION_OUTGOING)->offset($start)
                    ->limit($limit)
                    ->orderBy($order, $dir)
                    ->get();
            } else {
                $search = $request->input('search.value');

                $sms_reports = Reports::where('user_id', auth()->user()->id)->where('direction', Reports::DIRECTION_OUTGOING)->whereLike(['uid', 'sms_type', 'from', 'to', 'cost', 'status', 'created_at'], $search)
                    ->offset($start)
                    ->limit($limit)
                    ->orderBy($order, $dir)
                    ->get();

                $totalFiltered = Reports::where('user_id', auth()->user()->id)->where('direction', Reports::DIRECTION_OUTGOING)->whereLike(['uid', 'sms_type', 'from', 'to', 'cost', 'status', 'created_at'], $search)->count();
            }

            $data = [];
            if ( ! empty($sms_reports)) {

                $nestedData['can_delete'] = Auth::user()->customer->getOption('delete_sms_history') == 'yes';

                foreach ($sms_reports as $report) {
                    if ($report->created_at == null) {
                        $created_at = null;
                    } else {
                        $created_at = Tool::customerDateTime($report->created_at);
                    }

                    $nestedData['responsive_id'] = '';
                    $nestedData['uid']           = $report->uid;
                    $nestedData['created_at']    = $created_at;
                    $nestedData['sms_type']      = $report->getSMSType();
                    $nestedData['from']          = $report->from;
                    $nestedData['to']            = $report->to;
                    $nestedData['cost']          = $report->cost;
                    $nestedData['sms_count']     = $report->sms_count;
                    $nestedData['status']        = str_limit($report->status, 20);
                    $data[]                      = $nestedData;

                }
            }

            $json_data = [
                'draw'            => intval($request->input('draw')),
                'recordsTotal'    => $totalData,
                'recordsFiltered' => $totalFiltered,
                'data'            => $data,
            ];

            echo json_encode($json_data);
            exit();

        }

        /**
         * get campaign details
         *
         * @throws AuthorizationException
         */
        public function campaigns(): View|Factory|Application
        {
            $this->authorize('view_reports');

            $breadcrumbs = [
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Dashboard')],
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Reports')],
                ['name' => __('locale.menu.Campaigns')],
            ];

            return view('customer.Reports.campaigns', compact('breadcrumbs'));
        }

        /**
         * search campaign data
         *
         *
         * @throws AuthorizationException
         */
        #[NoReturn]
        public function searchCampaigns(Request $request)
        {

            $this->authorize('view_reports');

            $columns = [
                0 => 'responsive_id',
                1 => 'uid',
                2 => 'uid',
                3 => 'campaign_name',
                4 => 'contacts',
                5 => 'sms_type',
                6 => 'schedule_type',
                7 => 'status',
                8 => 'uid',
            ];

            $totalData = Campaigns::where('user_id', auth()->user()->id)->count();

            $totalFiltered = $totalData;

            $limit = $request->input('length');
            $start = $request->input('start');
            $order = $columns[$request->input('order.0.column')];
            $dir   = $request->input('order.0.dir');

            if (empty($request->input('search.value'))) {
                $campaigns = Campaigns::where('user_id', auth()->user()->id)->offset($start)
                    ->limit($limit)
                    ->orderBy('created_at', $dir)
                    ->get();
            } else {
                $search = $request->input('search.value');

                $campaigns = Campaigns::where('user_id', auth()->user()->id)->whereLike(['uid', 'campaign_name', 'sms_type', 'schedule_type', 'created_at', 'status'], $search)
                    ->offset($start)
                    ->limit($limit)
                    ->orderBy($order, $dir)
                    ->get();

                $totalFiltered = Campaigns::where('user_id', auth()->user()->id)->whereLike(['uid', 'campaign_name', 'sms_type', 'schedule_type', 'created_at', 'status'], $search)->count();
            }

            $nestedData['can_delete'] = Auth::user()->customer->getOption('delete_sms_history') == 'yes';

            $data = [];
            if ( ! empty($campaigns)) {
                foreach ($campaigns as $campaign) {

                    $nestedData['responsive_id'] = '';
                    $nestedData['uid']           = $campaign->uid;
                    $nestedData['campaign_name'] = "<div>
                                                        <p class='text-bold-600'> $campaign->campaign_name </p>
                                                        <p class='text-muted'>" . __('locale.labels.created_at') . ': ' . Tool::formatHumanTime($campaign->created_at) . '</p>
                                                   </div>';
                    $nestedData['contacts']      = Tool::number_with_delimiter($campaign->contactCount($campaign->cache));
                    $nestedData['sms_type']      = $campaign->getSMSType();
                    $nestedData['schedule_type'] = $campaign->getCampaignType();
                    $nestedData['status']        = $campaign->getStatus();
                    $nestedData['camp_status']   = str_limit($campaign->status, 30);
                    $nestedData['camp_name']     = $campaign->campaign_name;
                    $nestedData['upload_type']   = $campaign->upload_type;
                    $nestedData['is_recurring']  = $campaign->schedule_type == 'recurring';

                    $nestedData['show']       = route('customer.reports.campaign.edit', $campaign->uid);
                    $nestedData['show_label'] = __('locale.buttons.edit');

                    $nestedData['overview']       = route('customer.reports.campaign.overview', $campaign->uid);
                    $nestedData['overview_label'] = __('locale.menu.Overview');

                    $nestedData['pause']          = __('locale.labels.pause');
                    $nestedData['resend']         = __('locale.labels.resend');
                    $nestedData['restart']        = __('locale.labels.restart');
                    $nestedData['copy']           = __('locale.labels.copy');
                    $nestedData['stop_recurring'] = __('locale.campaigns.stop_recurring');

                    $nestedData['delete'] = __('locale.buttons.delete');
                    $data[]               = $nestedData;

                }
            }

            $json_data = [
                'draw'            => intval($request->input('draw')),
                'recordsTotal'    => $totalData,
                'recordsFiltered' => $totalFiltered,
                'data'            => $data,
            ];

            echo json_encode($json_data);
            exit();

        }

        public function editCampaign(Campaigns $campaign): Factory|\Illuminate\Foundation\Application|View|Application|RedirectResponse
        {

            if ($campaign->upload_type == 'file') {
                return redirect()->route('customer.reports.campaigns')->with([
                    'status'  => 'info',
                    'message' => __('locale.campaigns.you_are_not_able_to_update_file_import_campaign'),
                ]);
            }

            $breadcrumbs = [
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Dashboard')],
                ['link' => url('/reports/campaigns'), 'name' => __('locale.menu.Reports')],
                ['name' => __('locale.menu.Campaign Builder')],
            ];

            if (Auth::user()->customer->getOption('sender_id_verification') == 'yes') {
                $sender_ids = Senderid::where('user_id', auth()->user()->id)->where('status', 'active')->cursor();
            } else {
                $sender_ids = null;
            }

            $phone_numbers       = PhoneNumbers::where('user_id', auth()->user()->id)->where('status', 'assigned')->cursor();
            $template_tags       = TemplateTags::cursor();
            $contact_groups      = ContactGroups::where('status', 1)->where('customer_id', auth()->user()->id)->cursor();
            $templates           = Templates::where('user_id', auth()->user()->id)->where('status', 1)->cursor();
            $campaign_sender_ids = CampaignsSenderid::where('campaign_id', $campaign->id)->cursor();

            $exist_sender_id     = null;
            $exist_phone_numbers = [];
            $originator          = 'sender_id';

            foreach ($campaign_sender_ids as $sender_id) {
                if ($sender_id->originator == 'sender_id') {
                    $exist_sender_id = $sender_id->sender_id;
                } else {
                    $originator            = 'phone_number';
                    $exist_phone_numbers[] = $sender_id->sender_id;
                }
            }

            $exist_groups   = CampaignsList::where('campaign_id', $campaign->id)->select('contact_list_id')->get()->pluck('contact_list_id')->toArray();
            $plan_id        = Auth::user()->customer->activeSubscription()->plan_id;
            $sendingServers = CustomerBasedSendingServer::where('user_id', auth()->user()->id)->where('status', 1)->get();

            return view('customer.Campaigns.updateCampaignBuilder', compact('breadcrumbs', 'sender_ids', 'phone_numbers', 'template_tags', 'contact_groups', 'templates', 'campaign', 'exist_sender_id', 'originator', 'exist_phone_numbers', 'exist_groups', 'plan_id', 'sendingServers'));
        }

        /**
         * @throws Exception
         */
        public function postEditCampaign(Campaigns $campaign, Request $request): RedirectResponse
        {
            if (config('app.stage') == 'demo') {
                return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                    'status'  => 'error',
                    'message' => 'Sorry! This option is not available in demo mode',
                ]);
            }

            $input     = $request->except('_token');
            $sms_type  = $input['sms_type'];
            $user      = Auth::user();
            $sender_id = null;

            if (isset($input['sending_server'])) {
                $campaign->sending_server_id = $input['sending_server'];
            }

            if (Auth::user()->customer->getOption('sender_id_verification') == 'yes') {
                if (isset($input['originator'])) {
                    if ($input['originator'] == 'sender_id') {

                        if ( ! isset($input['sender_id'])) {
                            return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                                'status'  => 'error',
                                'message' => __('locale.sender_id.sender_id_required'),
                            ]);
                        }

                        $sender_id = $input['sender_id'];

                        if (is_array($sender_id) && count($sender_id) > 0) {
                            $invalid   = [];
                            $senderids = Senderid::where('user_id', Auth::user()->id)
                                ->where('status', 'active')
                                ->select('sender_id')
                                ->cursor()
                                ->pluck('sender_id')
                                ->all();

                            foreach ($sender_id as $sender) {
                                if ( ! in_array($sender, $senderids)) {
                                    $invalid[] = $sender;
                                }
                            }

                            if (count($invalid)) {

                                return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                                    'status'  => 'error',
                                    'message' => __('locale.sender_id.sender_id_invalid', ['sender_id' => $invalid[0]]),
                                ]);
                            }
                        } else {

                            return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                                'status'  => 'error',
                                'message' => __('locale.sender_id.sender_id_required'),
                            ]);
                        }
                    } else {

                        if ( ! isset($input['phone_number'])) {
                            $sender_id = CampaignsSenderid::where('campaign_id', $campaign->id)->pluck('sender_id')->toArray();
                        } else {
                            $sender_id = $input['phone_number'];
                        }

                        if (isset($sender_id) && is_array($sender_id) && count($sender_id) > 0) {
                            $type_supported = [];
                            PhoneNumbers::where('user_id', Auth::user()->id)
                                ->where('status', 'assigned')
                                ->cursor()
                                ->reject(function ($number) use ($sender_id, &$type_supported, &$invalid) {
                                    if (in_array($number->number, $sender_id) && ! str_contains($number->capabilities, 'sms')) {
                                        return $type_supported[] = $number->number;
                                    }

                                    return $sender_id;
                                })->all();

                            if (count($type_supported)) {

                                return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                                    'status'  => 'error',
                                    'message' => __('locale.sender_id.sender_id_sms_capabilities', ['sender_id' => $type_supported[0]]),
                                ]);
                            }
                        } else {

                            return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                                'status'  => 'error',
                                'message' => __('locale.sender_id.sender_id_required'),
                            ]);
                        }
                    }
                } else {

                    return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                        'status'  => 'error',
                        'message' => __('locale.sender_id.sender_id_required'),
                    ]);
                }
            } else if (Auth::user()->can('view_numbers') && isset($input['originator']) && $input['originator'] == 'phone_number') {
                $sender_id = $input['phone_number'];

                if (isset($sender_id) && is_array($sender_id) && count($sender_id) > 0) {
                    $type_supported = [];
                    PhoneNumbers::where('user_id', Auth::user()->id)
                        ->where('status', 'assigned')
                        ->cursor()
                        ->reject(function ($number) use ($sender_id, &$type_supported, &$invalid) {
                            if (in_array($number->number, $sender_id) && ! str_contains($number->capabilities, 'sms')) {
                                return $type_supported[] = $number->number;
                            }

                            return $sender_id;
                        })->all();

                    if (count($type_supported)) {

                        return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                            'status'  => 'error',
                            'message' => __('locale.sender_id.sender_id_sms_capabilities', ['sender_id' => $type_supported[0]]),
                        ]);
                    }
                } else {

                    return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                        'status'  => 'error',
                        'message' => __('locale.sender_id.sender_id_required'),
                    ]);
                }
            } else {
                if (isset($input['originator'])) {
                    if ($input['originator'] == 'sender_id') {
                        if ( ! isset($input['sender_id'])) {

                            return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                                'status'  => 'error',
                                'message' => __('locale.sender_id.sender_id_required'),
                            ]);
                        }

                        $sender_id = $input['sender_id'];
                    } else {

                        if ( ! isset($input['phone_number'])) {

                            return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                                'status'  => 'error',
                                'message' => __('locale.sender_id.phone_numbers_required'),
                            ]);
                        }

                        $sender_id = $input['phone_number'];
                    }

                    if ( ! is_array($sender_id) || count($sender_id) <= 0) {

                        return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                            'status'  => 'error',
                            'message' => __('locale.sender_id.sender_id_required'),
                        ]);
                    }
                }
                if (isset($input['sender_id'])) {
                    $sender_id           = $input['sender_id'];
                    $input['originator'] = 'sender_id';
                }
            }

            $total           = 0;
            $campaign_groups = [];

            // update contact groups details
            if (isset($input['contact_groups']) && is_array($input['contact_groups']) && count($input['contact_groups']) > 0) {

                $contact_groups = ContactGroups::whereIn('id', $input['contact_groups'])->where('status', true)->where('customer_id', $user->id)->get();
                foreach ($contact_groups as $group) {
                    $campaign_groups[] = [
                        'campaign_id'     => $campaign->id,
                        'contact_list_id' => $group->id,
                        'created_at'      => Carbon::now(),
                        'updated_at'      => Carbon::now(),
                    ];
                }

                $getContacts = Contacts::whereIn('group_id', $input['contact_groups'])->where('status', 'subscribe');
                $total       = $getContacts->count();


                if ($total == 0) {
                    return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                        'status'  => 'error',
                        'message' => __('locale.campaigns.contact_not_found'),
                    ]);
                }

                $subscriber = $getContacts->first();

                if ($user->sms_unit != '-1') {
                    $coverage = CustomerBasedPricingPlan::where('user_id', $user->id)
                        ->pluck('options', 'country_id')
                        ->toArray();

                    if (count($coverage) < 1) {
                        $coverage = PlansCoverageCountries::where('plan_id', $input['plan_id'])
                            ->pluck('options', 'country_id')
                            ->toArray();
                    }

                    if (empty($coverage)) {
                        return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                            'status'  => 'error',
                            'message' => 'Please add coverage on your plan.',
                        ]);
                    }


                    try {
                        $phoneUtil         = PhoneNumberUtil::getInstance();
                        $phoneNumberObject = $phoneUtil->parse('+' . $subscriber->phone);
                        $country_code      = $phoneNumberObject->getCountryCode();
                        $iso_code          = $phoneUtil->getRegionCodeForNumber($phoneNumberObject);

                        $country = Country::where('country_code', $country_code)
                            ->where('iso_code', $iso_code)
                            ->where('status', 1)
                            ->first();


                        if (empty($country) || array_key_exists($country->id, $coverage) === false) {
                            return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                                'status'  => 'error',
                                'message' => "Permission to send an SMS has not been enabled for the region indicated by the 'To' number: " . $subscriber->phone,
                            ]);
                        }

                        if (isset($coverage[$country->id])) {
                            $priceOption = json_decode($coverage[$country->id], true);
                            $sms_count   = 1;

                            if (isset($input['message'])) {
                                $sms_counter  = new SMSCounter();
                                $message_data = $sms_counter->count($input['message'], $sms_type == 'whatsapp' ? 'WHATSAPP' : null);
                                $sms_count    = $message_data->messages;
                            }

                            $sms_type_prices = [
                                'plain'    => 'plain_sms',
                                'unicode'  => 'plain_sms',
                                'voice'    => 'voice_sms',
                                'mms'      => 'mms_sms',
                                'whatsapp' => 'whatsapp_sms',
                                'viber'    => 'viber_sms',
                                'otp'      => 'otp_sms',
                            ];

                            if (isset($sms_type_prices[$sms_type])) {
                                $unit_price = $priceOption[$sms_type_prices[$sms_type]];
                                $price      = $total * $unit_price;
                                $price      *= $sms_count;

                                $balance = $user->sms_unit;

                                if ($price > $balance) {

                                    return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                                        'status'  => 'error',
                                        'message' => __('locale.campaigns.not_enough_balance', [
                                            'current_balance' => $balance,
                                            'campaign_price'  => $price,
                                        ]),
                                    ]);

                                }
                            } else {
                                return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                                    'status'  => 'error',
                                    'message' => 'Invalid SMS type: ' . $sms_type,
                                ]);
                            }
                        } else {
                            return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                                'status'  => 'error',
                                'message' => "Permission to send an SMS has not been enabled for the region indicated by the 'To' number: " . $subscriber->phone,
                            ]);
                        }
                    } catch (NumberParseException $exception) {
                        return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                            'status'  => 'error',
                            'message' => $exception->getMessage(),
                        ]);
                    }

                }

            }


            CampaignsSenderid::where('campaign_id', $campaign->id)->delete();

            foreach ($sender_id as $id) {

                $data = [
                    'campaign_id' => $campaign->id,
                    'sender_id'   => $id,
                ];

                if (isset($input['originator'])) {
                    $data['originator'] = $input['originator'];
                }

                CampaignsSenderid::create($data);
            }

            CampaignsList::where('campaign_id', $campaign->id)->delete();

            CampaignsList::insert($campaign_groups);

            // if schedule is available then check date, time and timezone
            if (isset($input['schedule']) && $input['schedule'] == 'true') {

                $schedule_date = $input['schedule_date'] . ' ' . $input['schedule_time'];
                $schedule_time = Tool::systemTimeFromString($schedule_date, $input['timezone']);

                $campaign->timezone      = $input['timezone'];
                $campaign->status        = Campaigns::STATUS_SCHEDULED;
                $campaign->schedule_time = $schedule_time;

                if ($input['frequency_cycle'] == 'onetime') {
                    // working with onetime schedule
                    $campaign->schedule_type = Campaigns::TYPE_ONETIME;
                } else {
                    // working with recurring schedule
                    //if schedule time frequency is not one time then check frequency details
                    $recurring_date = $input['recurring_date'] . ' ' . $input['recurring_time'];
                    $recurring_end  = Tool::systemTimeFromString($recurring_date, $input['timezone']);

                    $campaign->schedule_type = Campaigns::TYPE_RECURRING;
                    $campaign->recurring_end = $recurring_end;

                    if (isset($input['frequency_cycle'])) {
                        if ($input['frequency_cycle'] != 'custom') {
                            $schedule_cycle             = $campaign::scheduleCycleValues();
                            $limits                     = $schedule_cycle[$input['frequency_cycle']];
                            $campaign->frequency_cycle  = $input['frequency_cycle'];
                            $campaign->frequency_amount = $limits['frequency_amount'];
                            $campaign->frequency_unit   = $limits['frequency_unit'];
                        } else {
                            $campaign->frequency_cycle  = $input['frequency_cycle'];
                            $campaign->frequency_amount = $input['frequency_amount'];
                            $campaign->frequency_unit   = $input['frequency_unit'];
                        }
                    }
                }
            } else {
                $campaign->status = Campaigns::STATUS_QUEUED;
            }
            //update cache
            $campaign->cache = json_encode([
                'ContactCount'         => $total,
                'DeliveredCount'       => 0,
                'FailedDeliveredCount' => 0,
                'NotDeliveredCount'    => 0,
            ]);

            $campaign->message = $input['message'];

            if ($sms_type == 'voice') {
                $campaign->language = $input['language'];
                $campaign->gender   = $input['gender'];
            }

            if ($sms_type == 'mms') {
                $campaign->media_url = Tool::uploadImage($input['mms_file']);
            }

            $camp = $campaign->save();

            if ($camp) {
                return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                    'status'  => 'success',
                    'message' => __('locale.campaigns.campaign_successfully_updated'),
                ]);
            }

            return redirect()->route('customer.reports.campaign.edit', $campaign->uid)->with([
                'status'  => 'error',
                'message' => __('locale.exceptions.something_went_wrong'),
            ]);
        }

        public function campaignOverview(Campaigns $campaign): Factory|\Illuminate\Foundation\Application|View|Application|RedirectResponse
        {
            $breadcrumbs = [
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Dashboard')],
                ['link' => url('/reports/campaigns'), 'name' => __('locale.menu.Reports')],
                ['name' => __('locale.menu.Overview')],
            ];

            $campaign = Campaigns::where('user_id', Auth::user()->id)->where('uid', $campaign->uid)->first();

            if ( ! $campaign) {
                return redirect()->route('customer.reports.campaigns')->with([
                    'status'  => 'error',
                    'message' => __('locale.exceptions.invalid_action'),
                ]);
            }

            $reportStatusCounts = Reports::where('user_id', Auth::user()->id)->where('campaign_id', $campaign->id)->selectRaw('
        COUNT(CASE WHEN customer_status = "Enroute" THEN 1 END) as enroute_count,
        COUNT(CASE WHEN customer_status = "Delivered" THEN 1 END) as delivered_count,
        COUNT(CASE WHEN customer_status = "Expired" THEN 1 END) as expired_count,
        COUNT(CASE WHEN customer_status = "Undelivered" THEN 1 END) as undelivered_count,
        COUNT(CASE WHEN customer_status = "Rejected" THEN 1 END) as rejected_count,
        COUNT(CASE WHEN customer_status = "Accepted" THEN 1 END) as accepted_count,
        COUNT(CASE WHEN customer_status = "Skipped" THEN 1 END) as skipped_count,
        COUNT(CASE WHEN customer_status NOT IN ("Enroute", "Delivered", "Expired", "Undelivered", "Rejected", "Accepted", "Skipped") THEN 1 END) as failed_count
    ')
                ->first();


            $totalCount = $campaign->contactCount($campaign->cache);

// Calculate the percentages for each status
            $reportStatusPercentages = [
                'enroute_percentage'     => $totalCount > 0 ? ($reportStatusCounts->enroute_count / $totalCount) * 100 : 0,
                'delivered_percentage'   => $totalCount > 0 ? ($reportStatusCounts->delivered_count / $totalCount) * 100 : 0,
                'expired_percentage'     => $totalCount > 0 ? ($reportStatusCounts->expired_count / $totalCount) * 100 : 0,
                'undelivered_percentage' => $totalCount > 0 ? ($reportStatusCounts->undelivered_count / $totalCount) * 100 : 0,
                'rejected_percentage'    => $totalCount > 0 ? ($reportStatusCounts->rejected_count / $totalCount) * 100 : 0,
                'accepted_percentage'    => $totalCount > 0 ? ($reportStatusCounts->accepted_count / $totalCount) * 100 : 0,
                'skipped_percentage'     => $totalCount > 0 ? ($reportStatusCounts->skipped_count / $totalCount) * 100 : 0,
                'failed_percentage'      => $totalCount > 0 ? ($reportStatusCounts->failed_count / $totalCount) * 100 : 0,
            ];


            return view('customer.Campaigns.overview', compact('campaign', 'breadcrumbs', 'reportStatusCounts', 'reportStatusPercentages'));
        }

        /**
         * view campaign reports
         *
         *
         * @throws AuthorizationException
         */
        #[NoReturn]
        public function campaignReports(Campaigns $campaign, Request $request)
        {

            $this->authorize('view_reports');

            $columns = [
                0  => 'responsive_id',
                1  => 'uid',
                2  => 'uid',
                3  => 'created_at',
                6  => 'from',
                7  => 'to',
                8  => 'sms_count',
                9  => 'cost',
                10 => 'customer_status',
            ];

            $totalData = Reports::where('user_id', auth()->user()->id)->where('campaign_id', $campaign->id)->count();

            $totalFiltered = $totalData;

            $limit = $request->input('length');
            $start = $request->input('start');
            $order = $columns[$request->input('order.0.column')];
            $dir   = $request->input('order.0.dir');

            if (empty($request->input('search.value'))) {
                $sms_reports = Reports::where('user_id', auth()->user()->id)->where('campaign_id', $campaign->id)->offset($start)
                    ->limit($limit)
                    ->orderBy('created_at', $dir)
                    ->get();
            } else {
                $search = $request->input('search.value');

                $sms_reports = Reports::where('user_id', auth()->user()->id)->where('campaign_id', $campaign->id)->whereLike(['uid', 'from', 'to', 'cost', 'sms_count', 'customer_status', 'created_at'], $search)
                    ->offset($start)
                    ->limit($limit)
                    ->orderBy($order, $dir)
                    ->get();

                $totalFiltered = Reports::where('user_id', auth()->user()->id)->where('campaign_id', $campaign->id)->whereLike(['uid', 'from', 'to', 'cost', 'sms_count', 'customer_status', 'created_at'], $search)->count();
            }

            $data = [];
            if ( ! empty($sms_reports)) {

                $nestedData['can_delete'] = Auth::user()->customer->getOption('delete_sms_history') == 'yes';

                foreach ($sms_reports as $report) {
                    if ($report->created_at == null) {
                        $created_at = null;
                    } else {
                        $created_at = Tool::customerDateTime($report->created_at);
                    }

                    $nestedData['responsive_id']   = '';
                    $nestedData['uid']             = $report->uid;
                    $nestedData['created_at']      = $created_at;
                    $nestedData['from']            = $report->from;
                    $nestedData['to']              = $report->to;
                    $nestedData['cost']            = $report->cost;
                    $nestedData['sms_count']       = $report->sms_count;
                    $nestedData['customer_status'] = $report->customer_status;
                    $data[]                        = $nestedData;

                }
            }

            $json_data = [
                'draw'            => intval($request->input('draw')),
                'recordsTotal'    => $totalData,
                'recordsFiltered' => $totalFiltered,
                'data'            => $data,
            ];

            echo json_encode($json_data);
            exit();
        }

        public function reportsGenerator($type): Generator
        {
            if ($type == 'all') {
                foreach (Reports::where('user_id', Auth::user()->id)->cursor() as $report) {
                    yield $report;
                }
            } else {
                foreach (Reports::where('user_id', Auth::user()->id)->where('direction', $type)->cursor() as $report) {
                    yield $report;
                }
            }

        }

        public function campaignReportsGenerator($campaign_id): Generator
        {
            $reports = Reports::where('user_id', Auth::user()->id)->where('campaign_id', $campaign_id)->get();

            yield from $reports->map(function ($report) {

                return [
                    'created_at'      => Tool::customerDateTime($report->created_at),
                    'from'            => $report->from,
                    'to'              => $report->to,
                    'message'         => $report->message,
                    'cost'            => $report->cost,
                    'media_url'       => $report->media_url,
                    'sms_type'        => $report->sms_type,
                    'customer_status' => $report->customer_status,
                    'direction'       => $report->direction,
                ];
            });
        }

        /**
         * @throws AuthorizationException
         */
        public function export(Request $request): BinaryFileResponse|RedirectResponse
        {
            if (config('app.stage') == 'demo') {
                return redirect()->route('customer.reports.all')->with([
                    'status'  => 'error',
                    'message' => 'Sorry! This option is not available in demo mode',
                ]);
            }

            $this->authorize('view_reports');

            Tool::resetMaxExecutionTime();

            try {
                $file_name = (new FastExcel($this->exportData($request)))->export(storage_path('Reports_' . time() . '.xlsx'));

                return response()->download($file_name);
            } catch (IOException|InvalidArgumentException|UnsupportedTypeException|WriterNotOpenedException $e) {
                return redirect()->route('customer.reports.all')->with([
                    'status'  => 'error',
                    'message' => $e->getMessage(),
                ]);
            }

        }

        public function exportData($request): Generator
        {

            $reports = Reports::where('user_id', Auth::user()->id)
                ->filterByDirection($request->input('direction'))
                ->filterByType($request->input('type'))
                ->filterByStatus($request->input('status'))
                ->filterByFrom($request->input('from'))
                ->filterByTo($request->input('to'))
                ->filterByDateRange($request->input('start_date'), $request->input('start_time'), $request->input('end_date'), $request->input('end_time'))
                ->get();

            yield from $reports->map(function ($report) {

                if ($report->direction == Reports::DIRECTION_API) {
                    $direction = __('locale.labels.api');
                } else if ($report->direction == Reports::DIRECTION_INCOMING) {
                    $direction = __('locale.labels.incoming');
                } else {
                    $direction = __('locale.labels.outgoing');
                }

                return [
                    'created_at'      => Tool::customerDateTime($report->created_at),
                    'from'            => $report->from,
                    'to'              => $report->to,
                    'message'         => $report->message,
                    'cost'            => $report->cost,
                    'media_url'       => $report->media_url,
                    'sms_type'        => $report->sms_type,
                    'customer_status' => $report->customer_status,
                    'direction'       => $direction,
                ];
            });

        }

        /**
         * @throws AuthorizationException
         */
        public function exportSent(): BinaryFileResponse|RedirectResponse
        {
            if (config('app.stage') == 'demo') {
                return redirect()->route('customer.reports.all')->with([
                    'status'  => 'error',
                    'message' => 'Sorry! This option is not available in demo mode',
                ]);
            }

            $this->authorize('view_reports');

            try {
                $file_name = (new FastExcel($this->reportsGenerator('from')))->export(storage_path('Reports_' . time() . '.xlsx'));

                return response()->download($file_name);
            } catch (IOException|InvalidArgumentException|UnsupportedTypeException|WriterNotOpenedException $e) {
                return redirect()->route('customer.reports.all')->with([
                    'status'  => 'error',
                    'message' => $e->getMessage(),
                ]);
            }

        }

        /**
         * @throws AuthorizationException
         */
        public function exportReceive(): BinaryFileResponse|RedirectResponse
        {
            if (config('app.stage') == 'demo') {
                return redirect()->route('customer.reports.all')->with([
                    'status'  => 'error',
                    'message' => 'Sorry! This option is not available in demo mode',
                ]);
            }

            $this->authorize('view_reports');

            try {
                $file_name = (new FastExcel($this->reportsGenerator('to')))->export(storage_path('Reports_' . time() . '.xlsx'));

                return response()->download($file_name);

            } catch (IOException|InvalidArgumentException|UnsupportedTypeException|WriterNotOpenedException $e) {
                return redirect()->route('customer.reports.all')->with([
                    'status'  => 'error',
                    'message' => $e->getMessage(),
                ]);
            }

        }

        /**
         * @throws AuthorizationException
         */
        public function exportCampaign(Campaigns $campaign): BinaryFileResponse|RedirectResponse
        {
            if (config('app.stage') == 'demo') {
                return redirect()->route('customer.reports.all')->with([
                    'status'  => 'error',
                    'message' => 'Sorry! This option is not available in demo mode',
                ]);
            }

            $this->authorize('view_reports');

            try {
                $file_name = (new FastExcel($this->campaignReportsGenerator($campaign->id)))->export(storage_path('Reports_' . time() . '.xlsx'));

                return response()->download($file_name);
            } catch (IOException|InvalidArgumentException|UnsupportedTypeException|WriterNotOpenedException $e) {
                return redirect()->route('customer.reports.all')->with([
                    'status'  => 'error',
                    'message' => $e->getMessage(),
                ]);
            }

        }

        public function campaignGenerator(): Generator
        {
            foreach (Campaigns::where('user_id', Auth::user()->id)->cursor() as $report) {
                yield $report;
            }
        }

        /**
         * @throws AuthorizationException
         */
        public function campaignExport(): BinaryFileResponse|RedirectResponse
        {
            if (config('app.stage') == 'demo') {
                return redirect()->route('customer.reports.all')->with([
                    'status'  => 'error',
                    'message' => 'Sorry! This option is not available in demo mode',
                ]);
            }

            $this->authorize('view_reports');

            try {
                $file_name = (new FastExcel($this->campaignGenerator()))->export(storage_path('Campaign_' . time() . '.xlsx'));

                return response()->download($file_name);
            } catch (IOException|InvalidArgumentException|UnsupportedTypeException|WriterNotOpenedException $e) {
                return redirect()->route('customer.reports.all')->with([
                    'status'  => 'error',
                    'message' => $e->getMessage(),
                ]);
            }

        }

        /**
         * delete campaign
         *
         *
         * @throws Exception
         */
        public function campaignDelete(Campaigns $campaign): JsonResponse
        {
            if (config('app.stage') == 'demo') {

                return response()->json([
                    'status'  => 'error',
                    'message' => 'Sorry! This option is not available in demo mode',
                ]);
            }

            if ( ! $campaign->delete()) {
                return response()->json([
                    'status'  => 'error',
                    'message' => __('locale.exceptions.something_went_wrong'),
                ]);
            }

            return response()->json([
                'status'  => 'success',
                'message' => __('locale.campaigns.campaign_was_successfully_deleted'),
            ]);

        }

        /**
         * bulk campaign delete
         */
        public function campaignBatchAction(Request $request): JsonResponse
        {

            if (config('app.stage') == 'demo') {

                return response()->json([
                    'status'  => 'error',
                    'message' => 'Sorry! This option is not available in demo mode',
                ]);
            }

            $ids = $request->get('ids');

            if (Campaigns::whereIn('uid', $ids)->where('user_id', auth()->user()->id)->delete()) {
                return response()->json([
                    'status'  => 'success',
                    'message' => __('locale.campaigns.campaign_was_successfully_deleted'),
                ]);
            }

            return response()->json([
                'status'  => 'error',
                'message' => __('locale.exceptions.something_went_wrong'),
            ]);
        }

        public function viewCharts(): View|\Illuminate\Foundation\Application|Factory|Application
        {
            $breadcrumbs = [
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Dashboard')],
                ['name' => __('locale.menu.View Charts')],
            ];

            $sms_outgoing = Reports::currentMonth()
                ->where('user_id', Auth::user()->id)
                ->selectRaw('Day(created_at) as day, count(direction) as outgoing,direction')
                ->where('direction', Reports::DIRECTION_OUTGOING)
                ->groupBy('day')->pluck('day', 'outgoing')->flip()->sortKeys();

            $sms_incoming = Reports::currentMonth()
                ->where('user_id', Auth::user()->id)
                ->selectRaw('Day(created_at) as day, count(direction) as incoming,direction')
                ->where('direction', Reports::DIRECTION_INCOMING)
                ->groupBy('day')->pluck('day', 'incoming')->flip()->sortKeys();

            $outgoing = (new LarapexChart)->lineChart()
                ->addData(__('locale.labels.outgoing'), $sms_outgoing->values()->toArray())
                ->setXAxis($sms_outgoing->keys()->toArray());

            $incoming = (new LarapexChart)->lineChart()
                ->addData(__('locale.labels.incoming'), $sms_incoming->values()->toArray())
                ->setXAxis($sms_incoming->keys()->toArray());

            return view('customer.Reports.charts', compact('breadcrumbs', 'sms_incoming', 'sms_outgoing', 'outgoing', 'incoming'));
        }

        /*
        |--------------------------------------------------------------------------
        | Version 3.7
        |--------------------------------------------------------------------------
        |
        | Reports Module
        |
        */

        /**
         * Reports Dashboard
         *
         * @return Application|Factory|View|\Illuminate\Foundation\Application
         *
         * @throws AuthorizationException
         */
        public function analyze()
        {

            $this->authorize('view_reports');

            $breadcrumbs = [
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Dashboard')],
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Reports')],
                ['name' => __('locale.menu.Analyze')],
            ];

            $reportQuery = Reports::where('user_id', Auth::user()->id)->select(
                'sms_type',
                DB::raw('SUM(CASE WHEN customer_status LIKE "%Delivered%" THEN cost ELSE 0 END) as total_cost'),
                DB::raw('SUM(sms_count) as total_sms'),
                DB::raw('SUM(CASE WHEN customer_status LIKE "%Delivered%" THEN 1 ELSE 0 END) as delivered_sms'),
                DB::raw('SUM(CASE WHEN customer_status NOT LIKE "%Delivered%" THEN 1 ELSE 0 END) as not_delivered_sms')
            )->groupBy('sms_type')->whereDate('created_at', today());

            $reports = $reportQuery->get();

            $smsTypes = $reportQuery->pluck('sms_type')->unique();

            $chart = (new LarapexChart)->areaChart();

            foreach ($smsTypes as $smsType) {
                $data = $reports->where('sms_type', $smsType)->pluck('total_sms');
                $chart->addData(strtoupper($smsType), $data->toArray());
            }

            $chart->setXAxis([today()->format('j/n')]);

            if (empty($chart->dataset())) {
                $chart->setDataset([]);
            }

            return view('customer.Reports.analyze', compact('breadcrumbs', 'reports', 'chart'));

        }

        public function parseDates(string $dateRange): array
        {
            $dates     = array_map('trim', explode(' to ', $dateRange));
            $startDate = date('Y-m-d', strtotime($dates[0]));
            $endDate   = isset($dates[1]) ? date('Y-m-d', strtotime($dates[1])) : $startDate;

            return [$startDate, $endDate];
        }

        public function getReportsData(string $type, array $dates, int $user_id)
        {
            [$startDate, $endDate] = $dates;

            return Reports::select(DB::raw('DATE(created_at) as date'), DB::raw('SUM(sms_count) as total_sms'))
                ->where('sms_type', $type)
                ->whereBetween('created_at', [$startDate, $endDate])
                ->where('user_id', $user_id)
                ->groupBy('date')
                ->get();
        }

        public function postAnalyze(DashboardRequest $request)
        {
            $breadcrumbs = [
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Dashboard')],
                ['link' => url('/dashboard'), 'name' => __('locale.menu.Reports')],
                ['name' => __('locale.menu.Analyze')],
            ];

            $dateRange = $request->input('dateRange');
            if ( ! $dateRange) {
                return back()->withInput('dateRange')->with([
                    'status'  => 'error',
                    'message' => 'Please select a valid date',
                ]);
            }

            $dates   = $this->parseDates($dateRange);
            $user_id = Auth::user()->id;
            $reports = Reports::select('sms_type',
                DB::raw('SUM(CASE WHEN status LIKE "%Delivered%" THEN cost ELSE 0 END) as total_cost'),
                DB::raw('COUNT(sms_count) as total_sms'),
                DB::raw('SUM(CASE WHEN status LIKE "%Delivered%" THEN 1 ELSE 0 END) as delivered_sms'),
                DB::raw('SUM(CASE WHEN status NOT LIKE "%Delivered%" THEN 1 ELSE 0 END) as not_delivered_sms'))
                ->whereBetween('created_at', $dates)
                ->where('user_id', $user_id)
                ->groupBy('sms_type')
                ->get();

            $getData  = [];
            $smsTypes = ['plain', 'voice', 'mms', 'whatsapp', 'unicode', 'viber', 'otp'];
            array_map(function ($type) use ($dates, $user_id, &$getData) {
                $getData[$type] = $this->getReportsData($type, $dates, $user_id);

                return $getData;
            }, $smsTypes);

            $chart = (new LarapexChart)->areaChart();
            $chart->setTitle('SMS Cost by Type');
            $chart->setXAxis($getData['plain']->pluck('date')->toArray());
            $chart->setLabels($smsTypes);

            foreach ($smsTypes as $type) {
                $chart->addData(strtoupper($type), $getData[$type]->pluck('total_sms')->toArray());
            }

            return view('customer.Reports.analyze', compact('breadcrumbs', 'reports', 'request', 'chart'));
        }

    }
