@extends('layouts.page')

@section('title', 'Reports')

@section('content')
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css">
    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <div class="content-header ">
            <div class="container-fluid">
                <div class="row mb-2">
                    <div class="col-sm-6">
                        <h1 class="m-0">All Report</h1>
                    </div><!-- /.col -->
                    <!-- <div class="col-sm-6">
                                                                <ol class="breadcrumb float-sm-right">
                                                                  <li class="breadcrumb-item"><a href="#">Home</a></li>
                                                                  <li class="breadcrumb-item active">Dashboard</li>
                                                                </ol>
                                                              </div> -->
                    <!-- /.col -->
                </div><!-- /.row -->
            </div><!-- /.container-fluid -->
        </div>
        <!-- /.content-header -->

        <!-- Main content -->
        <section class="content mt-1">
            @php
                $loginUser = Auth::user();
            @endphp
            <div class="container-fluid">
                <div class="row">
                    <div class="col-md-12">
                        <form action="{{ route('reports.general') }}" method="post">
                            @csrf
                            <div class="row justify-content-center report_card">
                                <div class="col-lg-12 card px-3">
                                    <div class="row justify-content-center py-2">
                                        @if (empty($loginUser))
                                            <div class="col-lg-3 col-md-6">
                                                <div class="form-group mb-0">
                                                    <label class="col-sm-12 control-label">SM<b
                                                            style="color: red;">*</b></label>
                                                    <div class="col-sm-12">
                                                        <select class="form-control js-user-type" name="smUser"
                                                            type="rbm" id="sm_user_drop">
                                                            <option value=""> Select SM </option>
                                                            @if (!empty($smUsers))
                                                                @foreach (@$smUsers as $row)
                                                                    <option value="{{ $row->user_id }}">
                                                                        {{ $row->user_name }}</option>
                                                                @endforeach
                                                            @endif
                                                        </select>
                                                    </div>
                                                </div>
                                            </div>
                                        @endif

                                        @if (@$loginUser->user_type == '1' || empty($loginUser))
                                            <div class="col-lg-3 col-md-6">
                                                <div class="form-group mb-0">
                                                    <label class="col-sm-12 control-label">RBM<b
                                                            style="color: red;">*</b></label>
                                                    <div class="col-sm-12">
                                                        <select class="form-control js-user-type" name="rbmUser"
                                                            type="abm" id="rbm_user_drop">
                                                            <option value=""> Select RBM </option>
                                                            @if (!empty($rbmUsers))
                                                                @foreach (@$rbmUsers as $row)
                                                                    <option value="{{ $row->user_id }}">
                                                                        {{ $row->user_name }}</option>
                                                                @endforeach
                                                            @endif
                                                        </select>
                                                    </div>
                                                </div>
                                            </div>
                                        @endif

                                        @if (@$loginUser->user_type == '1' || @$loginUser->user_type == '2' || empty($loginUser))
                                            <div class="col-lg-3 col-md-6">
                                                <div class="form-group mb-0">
                                                    <label class="col-sm-12 control-label">ABM<b
                                                            style="color: red;">*</b></label>
                                                    <div class="col-sm-12">
                                                        <select class="form-control js-user-type" name="abmUser"
                                                            type="be" id="abm_user_drop">
                                                            <option value=""> Select ABM </option>
                                                            @if (!empty($abmUsers))
                                                                @foreach (@$abmUsers as $row)
                                                                    <option value="{{ $row->user_id }}">
                                                                        {{ $row->user_name }}</option>
                                                                @endforeach
                                                            @endif
                                                        </select>
                                                    </div>
                                                </div>
                                            </div>
                                        @endif

                                        @if (@$loginUser->user_type != '4' || empty($loginUser))
                                            <div class="col-lg-3 col-md-6">
                                                <div class="form-group  mb-0">
                                                    <label class="col-sm-12 control-label">BE<b
                                                            style="color: red;">*</b></label>
                                                    <div class="col-sm-12">
                                                        <select class="form-control" name="beUser" id="be_user_drop">
                                                            <option value=""> Select BE </option>
                                                            @if (!empty($beUsers))
                                                                @foreach (@$beUsers as $row)
                                                                    <option value="{{ $row->user_id }}">
                                                                        {{ $row->user_name }}</option>
                                                                @endforeach
                                                            @endif
                                                        </select>
                                                    </div>
                                                </div>
                                            </div>
                                        @endif

                                        @if (empty($loginUser))
                                            <div class="col-lg-3 col-md-6">
                                                <div class="form-group  mb-0">
                                                    <label class="col-sm-12 control-label">Campaigns<b
                                                            style="color: red;">*</b></label>
                                                    <div class="col-sm-12">
                                                        <select class="form-control js-example-basic-multiple"
                                                            name="campaigns[]" id="campaigns" multiple="multiple">
                                                            <option value=""> Select Campaigns </option>
                                                            @if (!empty($campaigns))
                                                                @foreach (@$campaigns as $row)
                                                                    <option value="{{ $row->master_campaign_name }}">
                                                                        {{ $row->master_campaign_front_name }}</option>
                                                                @endforeach
                                                            @endif
                                                        </select>
                                                    </div>
                                                </div>
                                            </div>
                                        @endif
                                    </div>

                                    <div class="row">
                                        <div class="col-lg-3 col-md-6">
                                            <button type="submit" name="customer_wise_detail_report"
                                                class="info-box my-3 bg-warning text-center b-0" value="yes">
                                                <div class="info-box-icon" style="width:auto !important;font-size: 20px;">
                                                    <i class="fas fa-download"></i>
                                                </div>
                                                <div class="info-box-content">
                                                    <span class="info-box-text text-uppercase"
                                                        style="font-size: 14px;">Customer Wise Details Download</span>
                                                </div>
                                            </button>
                                        </div>

                                        <div class="col-lg-3 col-md-6">
                                            <button type="submit" name="docotor_wise_rx"
                                                class="info-box my-3 bg-success text-center b-0" value="yes">
                                                <span class="info-box-icon"
                                                    style="width:auto !important;font-size: 20px;"><i
                                                        class="fas fa-download"></i></span>
                                                <div class="info-box-content">
                                                    <span class="info-box-text text-uppercase"
                                                        style="font-size: 14px;">Doctor Wise Rx Upload</span>
                                                </div>
                                            </button>
                                        </div>

                                        <div class="col-lg-3 col-md-6">
                                            <button type="submit" name="brand_speciality"
                                                class="info-box my-3 bg-danger text-center b-0" value="yes">
                                                <span class="info-box-icon"
                                                    style="width:auto !important;font-size: 20px;"><i
                                                        class="fas fa-download"></i></span>
                                                <div class="info-box-content">
                                                    <span class="info-box-text text-uppercase"
                                                        style="font-size: 14px;">Doctor Brand Speciality Wise Report</span>
                                                </div>
                                            </button>
                                        </div>

                                        <div class="col-lg-3 col-md-6">
                                            <button type="submit" name="multi_brand"
                                                class="info-box my-3 bg-info text-center b-0" value="yes">
                                                <span class="info-box-icon"
                                                    style="width:auto !important;font-size: 20px;"><i
                                                        class="fas fa-download"></i></span>
                                                <div class="info-box-content">
                                                    <span class="info-box-text text-uppercase"
                                                        style="font-size: 14px;">Multi-brand RXbr Report</span>
                                                </div>
                                            </button>
                                        </div>

                                        <div class="col-lg-3 col-md-6">
                                            <button type="submit" name="customer_wise_detail_report_lipicure"
                                                class="info-box my-3 bg-primary text-center b-0" value="yes">
                                                <span class="info-box-icon"
                                                    style="width:auto !important;font-size: 20px;"><i
                                                        class="fas fa-download"></i></span>
                                                <div class="info-box-content">
                                                    <span class="info-box-text text-uppercase"
                                                        style="font-size: 14px;">SKU Wise Report</span>
                                                </div>
                                            </button>
                                        </div>

                                        <div class="col-lg-3 col-md-6" style="display: none;">
                                            <button type="submit" name="Potential_Wise_Detail"
                                                class="info-box my-3 bg-warning text-center b-0" value="yes">
                                                <div class="info-box-icon" style="width:auto !important;font-size: 20px;">
                                                    <i class="fas fa-download"></i>
                                                </div>
                                                <div class="info-box-content">
                                                    <span class="info-box-text text-uppercase"
                                                        style="font-size: 14px;">Potential Wise Detail Download</span>
                                                </div>
                                            </button>
                                        </div>


                                    </div>
                                </div>
                            </div>

                            <div class="row report_card">
                                <div class="col-md-6 mt-1 py-2">
                                    <div class="card p-3">
                                        <h5 class="my-2">Select Brand (>=3 RXN and >=12 RXN)</h5>
                                        <div class="row justify-content-center">
                                            <div class="col-lg-6 col-md-6">
                                                <div class="form-group mb-0">
                                                    <label class="col-sm-12 control-label">Brand<b
                                                            style="color: red;">*</b></label>
                                                    <div class="col-sm-12">
                                                        <select class="form-control" name="product" required="">
                                                            @foreach ($products as $r)
                                                                <option value="{{ $r->medicine_tablet_id }}">
                                                                    {{ $r->medicine_tablet_name }}</option>
                                                            @endforeach
                                                        </select>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="row justify-content-center">
                                            <div class="col-lg-6 col-md-6">
                                                <button type="submit" name="cords_dr_3"
                                                    class="info-box my-3 bg-danger text-center b-0" value="yes">
                                                    <span class="info-box-icon"
                                                        style="width:auto !important;font-size: 20px;"><i
                                                            class="fas fa-download"></i></span>
                                                    <div class="info-box-content">
                                                        <span class="info-box-text text-uppercase"
                                                            style="font-size: 14px;">CORE Drs (>=3 RXN)</span>
                                                    </div>
                                                </button>
                                            </div>

                                            <div class="col-lg-6 col-md-6">
                                                <button type="submit" name="cords_dr_12"
                                                    class="info-box my-3 bg-info text-center b-0" value="yes">
                                                    <span class="info-box-icon"
                                                        style="width:auto !important;font-size: 20px;"><i
                                                            class="fas fa-download"></i></span>
                                                    <div class="info-box-content">
                                                        <span class="info-box-text text-uppercase"
                                                            style="font-size: 14px;">CORE Drs (>=12 RXN)</span>
                                                    </div>
                                                </button>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="col-md-6 mt-1 py-2">
                                    <div class="card p-3">
                                        <h5 class="my-2">Brand wise report:</h5>
                                        <div class="row justify-content-center">
                                            <div class="col-lg-6 col-md-6">
                                                <div class="form-group mb-0">
                                                    <label class="col-sm-12 control-label">Brand<b
                                                            style="color: red;">*</b></label>
                                                    <div class="col-sm-12">
                                                        <select class="form-control" name="brand" required="">
                                                            @foreach ($brandGroup as $r)
                                                                <option value="{{ $r->group_name }}">{{ $r->group_name }}
                                                                </option>
                                                            @endforeach
                                                        </select>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="row justify-content-center">
                                            <div class="col-lg-6 col-md-6">
                                                <button type="submit" name="brand_wise_report"
                                                    class="info-box my-3 bg-danger text-center b-0" value="yes">
                                                    <span class="info-box-icon"
                                                        style="width:auto !important;font-size: 20px;"><i
                                                            class="fas fa-download"></i></span>
                                                    <div class="info-box-content">
                                                        <span class="info-box-text text-uppercase"
                                                            style="font-size: 14px;">Download</span>
                                                    </div>
                                                </button>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

                            <table id="datatable" class="table table-striped">
                                <thead>
                                    <tr>
                                        <th>Sr. No.</th>
                                        <th>Report Type</th>
                                        <th>Campaign Name</th>
                                        <th>SM</th>
                                        <th>RBM</th>
                                        <th>ABM</th>
                                        <th>BE</th>
                                        <th>Report</th>
                                        <th>Date & Time</th>
                                        <th>Status</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @if (!$results->isEmpty())
                                        @foreach ($results as $key => $row)
                                            <tr>
                                                {{-- <td>{{ $key + 1 }}</td> --}}
                                                <td>{{ ($results->currentPage() - 1) * $results->perPage() + $key + 1 }}</td>
                                                @if ($row->eExportType == 'CustomerWiseDetailReportFromTableExport')
                                                    <td>Customer Wise Detail Report</td>
                                                @elseif($row->eExportType == 'SkuWiseReportExport')
                                                    <td>SKU Wise Report</td>
                                                @elseif($row->eExportType == 'DoctorWiseRxREportExport')
                                                    <td>Doctor Wise Rx REport</td>
                                                @elseif($row->eExportType == 'BrandSpecilityWiseReportExport')
                                                    <td>Brand Specility Wise Report</td>
                                                @elseif($row->eExportType == 'MonthBrandRxbrReportExport')
                                                    <td>MULTI-BRAND RXBR REPORT</td>
                                                @elseif($row->eExportType == 'CoreDoctorReportExport_dr_3')
                                                    <td>CORE DRS (>=3 RXN)
                                                        {{ $row->brand ? ' Brand- ' . $row->brand : '' }}
                                                    </td>
                                                @elseif($row->eExportType == 'CoreDoctorReportExport_dr_12')
                                                    <td>CORE DRS (>=12 RXN)
                                                        {{ $row->brand ? ' Brand- ' . $row->brand : '' }}
                                                    </td>
                                                @elseif($row->eExportType == 'IndividualBrandReport')
                                                    <td>Individual Brand Report</td>
                                                @endif

                                                {{-- <td>
                                                    @php
                                                        $temp = json_decode($row->jData);
                                                    @endphp
                                                    {{ isset($temp->campaigns) ? $temp->campaigns : '-' }}
                                                </td> --}}
                                                <td>
                                                    @php
                                                        $temp = json_decode($row->jData);
                                                        $campaigns = isset($temp->campaigns) ? $temp->campaigns : '-';
                                                    @endphp
                                                    {{ is_array($campaigns) ? implode(', ', $campaigns) : $campaigns }}
                                                </td>


                                                <td>{{ $row->smname ? $row->smname : '-' }}</td>
                                                <td>{{ $row->rbmname ? $row->rbmname : '-' }}</td>
                                                <td>{{ $row->abmname ? $row->abmname : '-' }}</td>
                                                <td>{{ $row->bename ? $row->bename : '-' }}</td>


                                                @if ($row->eStatus != 'Pending' && $row->eStatus != 'InProcess')