@extends('layouts.page')

@section('title','Reports')

@section('content')
<!-- 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">
                            <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
                                </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">
                            <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>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>
                                            @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>{{$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')