@extends('layouts.admin.app')
@section('content')
<style>
.accordion {
  background-color: #eee;
  color: #444;
  cursor: pointer;
  padding: 18px;
  width: 100%;
  border: none;
  text-align: left;
  outline: none;
  font-size: 15px;
  transition: 0.4s;
}

.active, .accordion:hover {
  background-color: #ccc; 
}

.panel {
  padding: 0 18px;
  display: none;
  background-color: white;
  overflow: hidden;
}
.ui-accordion-content
{
height: 100%!important;
}
</style>
<link rel="stylesheet" href="//code.jquery.com/ui/1.13.2/themes/base/jquery-ui.css">
  <script src="https://code.jquery.com/jquery-3.6.0.js"></script>
  <script src="https://code.jquery.com/ui/1.13.2/jquery-ui.js"></script>
      <div class="pd-30">
        <h4 class="tx-gray-800 mg-b-5">Dashboard</h4>
        <p class="mg-b-0">Admin Dashboard of SSLR Portal</p>
      </div><!-- d-flex -->
      <div class="br-pagebody mg-t-5 pd-x-30">
        <div class="row row-sm">
        @if(Auth::user()->role_id == 1)
          <div class="col-sm-6 col-xl-3 mt-1 mb-1">
            <div class="bg-teal rounded overflow-hidden">
              <div class="pd-25 d-flex align-items-center">
                <i class="fa fa-user tx-60 lh-0 tx-white op-7"></i>
                <div class="mg-l-20">
                  <p class="tx-10 tx-spacing-1 tx-mont tx-medium tx-uppercase tx-white-8 mg-b-10">Total Users</p>
                  <p class="tx-24 tx-white tx-lato tx-bold mg-b-2 lh-1">
                    @php
                    if(session('region_id') != '' and session('region_id') != null)
                    {
                      $users = DB::table('users')->where([['status', 1], ['region_id', session('region_id')]])->count();
                      echo $users;
                    }
                    else
                    {
                      $users = DB::table('users')->where('status', 1)->count();
                      echo $users;
                    }
                    @endphp
                  </p>
                  <span class="tx-11 tx-roboto tx-white-6">Only Active Users showing</span>
                </div>
              </div>
            </div>
          </div><!-- col-3 -->
         
          <div class="col-sm-6 col-xl-3 mg-t-20 mg-xl-t-0 mt-1 mb-1">
            <div class="bg-primary rounded overflow-hidden">
              <div class="pd-25 d-flex align-items-center">
                <i class="fa fa-file tx-60 lh-0 tx-white op-7"></i>
                <div class="mg-l-20">
                  <p class="tx-10 tx-spacing-1 tx-mont tx-medium tx-uppercase tx-white-8 mg-b-10">Total JSF</p>
                  <p class="tx-24 tx-white tx-lato tx-bold mg-b-2 lh-1">
                    @php
                    if(session('region_id') != '' and session('region_id') != null)
                    {
                        $jsf_count = DB::table('jsf')->where([['status', 1], ['region_id', session('region_id')]])->count();
                        echo $jsf_count;
                    }
                    else{
                      $jsf_count = DB::table('jsf')->where('status', 1)->count();
                      echo $jsf_count;
                    }
                    @endphp 
                  </p>
                  <span class="tx-11 tx-roboto tx-white-6">Total JSF Submitted</span>
                </div>
              </div>
            </div>
          </div><!-- col-3 -->
          <div class="col-sm-6 col-xl-3 mg-t-20 mg-xl-t-0 mt-1 mb-1">
            <div class="bg-br-primary rounded overflow-hidden">
              <div class="pd-25 d-flex align-items-center">
                <i class="fa fa-file tx-60 lh-0 tx-white op-7"></i>
                <div class="mg-l-20">
                  <p class="tx-10 tx-spacing-1 tx-mont tx-medium tx-uppercase tx-white-8 mg-b-10">Total SIP</p>
                  <p class="tx-24 tx-white tx-lato tx-bold mg-b-2 lh-1">
                    @php
                    if(session('region_id') != '' and session('region_id') != null)
                    {
                      $sip_count = DB::table('sip')->where([['status', 1], ['region_id', session('region_id')]])->count();
                      echo $sip_count;
                    }
                    else{
                      $sip_count = DB::table('sip')->where('status', 1)->count();
                      echo $sip_count;
                    }
                    @endphp
                  </p>
                  <span class="tx-11 tx-roboto tx-white-6">Total SIP Submitted</span>
                </div>
              </div>
            </div>
          </div><!-- col-3 -->
          <div class="col-sm-6 col-xl-3 mg-t-20 mg-xl-t-0 mt-1 mb-1">
            <div class=" btn-warning rounded overflow-hidden">
              <div class="pd-25 d-flex align-items-center">
                <i class="fa fa-file tx-60 lh-0 tx-white op-7"></i>
                <div class="mg-l-20">
                  <p class="tx-10 tx-spacing-1 tx-mont tx-medium tx-uppercase tx-white-8 mg-b-10">Total Survey</p>
                  <p class="tx-24 tx-white tx-lato tx-bold mg-b-2 lh-1">
                    @php
                    if(session('region_id') != '' and session('region_id') != null)
                    {
                      
                      $survey = DB::table('sief_survey')->where([['region_id', session('region_id')],['status', 1]])->count();
                      echo $survey;
                    
                    }
                    else{
                      $survey = DB::table('sief_survey')->where('status', 1)->get()->pluck('id')->toArray();;
                      echo count(array_unique($survey));

                      
                    }
                    @endphp
                  </p>
                  <span class="tx-11 tx-roboto tx-white-6">Total Survey Submitted</span>
                </div>
              </div>
            </div>
          </div><!-- col-3 -->
          @endif
        </div><!-- row -->
      </div><!-- br-pagebody -->
      
      <div class="br-pagebody mg-t-5 pd-x-30">
        
        <div class="row row-sm">
          <div class="row">
            <div class="col-md-12">
              <form class="form" method="post" action="getdata">
                @csrf @method('post')
                  <hr><b>Search CAS Details(Estimated LOA cost, Associated companies, etc)</b>
                  <div class="form-group">
                    <div class="input-group">
                      <input type="text" class="form-control" placeholder="CAS No" id="casno" name="casno" value="{{$casno ??''}}" required="true" data-validate-field="casno" >
                      <select id="region" name="region" class="form-control" data-validate-field="region">
                        @foreach($regions as $n)
                        @if($region == $n->id)
                          <option value="{{$n->id}}" selected>{{$n->name}}</option>
                        @else
                          <option value="{{$n->id}}">{{$n->name}}</option>
                        @endif
                        @endforeach
                      
                        
                      </select>
                      <div class="input-group-append">
                      <input type="submit" class="btn btn1 btn-primary text-white">
                      </div>
                    </div>
                  </div>
              </form>    
            </div>
          </div>
        </div>
        <div id="accordion">
          <h3>Estimated Cost (In Euro)</h3>
          <div>
            <p>
           
              <ul>
                <li>1-10 tpa :
                  <span id="loa1">{{$returnArr['loa1']??'Not Available'}}</span>
                </li>
                <li>10-100 tpa : 
                  <span id="loa2">{{$returnArr['loa2']??'Not Available'}}</span>
                </li>
                <li>100-1000 tpa : 
                  <span id="loa3">{{$returnArr['loa3']??'Not Available'}}</span>
                </li>
                <li>Intermediate less than 1000 tpa :
                  @if($regionid == 1)
                    @if(count($mainsearchData) > 0)
                      @foreach($mainsearchData as $key => $n)
                        @if($n->member4 !='' && $n->member4 != '0')
                          {{$n->member4}}
                        @endif
                        @if($n->member4 == '0' || $n->member4 =='')
                            {{''}}
                        @endif
                      @endforeach
                    @else
                      {{''}}
                    @endif
                  @endif
                  @if($exist_in_turkey && $regionid == 2)
                    @if(count($mainsearchData) > 0)
                      @foreach($mainsearchData as $key => $n)
                        @if($n->member4 !='' && $n->member4 != '0')
                          {{$n->member4}}
                        @endif
                        @if($n->member4 == '0' || $n->member4 =='')
                            {{''}}
                        @endif
                      @endforeach
                    @else
                      {{''}}
                    @endif
                  @endif
                  @if($exist_in_korea && $regionid == 3)
                    @if(count($mainsearchData) > 0)
                      @foreach($mainsearchData as $key => $n)
                        @if($n->member4 !='' && $n->member4 != '0')
                          {{$n->member4}}
                        @endif
                        @if($n->member4 == '0' || $n->member4 =='')
                            {{''}}
                        @endif
                      @endforeach
                    @else
                      {{''}}
                    @endif
                  @endif
                  @if($regionid == 2)
                  {{$returnArr['loa4']??''}}
                  @endif
                </li>
                <li>Intermediate with 1000 +tpa : 
                  <span id="loa4">{{$returnArr['loa1']??'Not Available'}}</span>
                </li>
              </ul>

              @if($regionid == 2 && isset($query_cost_report))
                <p><strong>Note: &nbsp;The LOA cost is calculated based upon following table:   </strong></p>
                <table border="1" cellpadding="5">
                  <thead>
                    <tr>
                      <th>Annex</th>
                      <th>JS Member (accommodating potential number of JS members joining )</th>
                    </tr>
                  </thead>
                  <tbody>
                    <tr>
                      <td>VII</td>
                      <td>{{$query_cost_report->num_turkey_vii ?? '4'}}</td>
                    </tr>
                    <tr>
                      <td>VIII</td>
                      <td>{{$query_cost_report->num_turkey_viii ?? '4'}}</td>
                    </tr>
                    <tr>
                      <td>IX</td>
                      <td>{{$query_cost_report->num_turkey_ix ?? '4'}}</td>
                    </tr>
                  </tbody>
                </table>
              @endif
              @if($regionid == 3 && isset($query_cost_report))
                <p><strong>Note: &nbsp;The LOA cost is calculated based upon following table:   </strong></p>
                <table border="1" cellpadding="5">
                  <thead>
                    <tr>
                      <th>Annex</th>
                      <th>JS Member (accommodating potential number of JS members joining )</th>
                    </tr>
                  </thead>
                  <tbody>
                    <tr>
                      <td>VII</td>
                      <td>{{$query_cost_report->num_korea_vii ?? '3'}}</td>
                    </tr>
                    <tr>
                      <td>VIII</td>
                      <td>{{$query_cost_report->num_korea_viii ?? '3'}}</td>
                    </tr>
                    <tr>
                      <td>IX</td>
                      <td>{{$query_cost_report->num_korea_ix ?? '3'}}</td>
                    </tr>
                  </tbody>
                </table>
              @endif
              @if($regionid == 1 && isset($query_cost_report))
                <p><strong>Note: &nbsp;The LOA cost is calculated based upon following table:   </strong></p>
                <table border="1" cellpadding="5">
                  <thead>
                    <tr>
                      <th>Annex</th>
                      <th>JS Member (accommodating potential number of JS members joining )</th>
                    </tr>
                  </thead>
                  <tbody>
                    <tr>
                      <td>VII</td>
                      <td>{{$query_cost_report->num_vii ?? '4'}}</td>
                    </tr>
                    <tr>
                      <td>VIII</td>
                      <td>{{$query_cost_report->num_viii ?? '4'}}</td>
                    </tr>
                    <tr>
                      <td>IX</td>
                      <td>{{$query_cost_report->num_ix ?? '4'}}</td>
                    </tr>
                  </tbody>
                </table>
              @endif
              <br> <br><p>It may be noted that the above-mentioned LOA cost is estimated cost  and is based on current number of intentions. Thus, may subject to change at a  later date if number of actual registrants increase/decrease as compared to the  number of intents. It may also change because of purchase of new data from data  holders for the mentioned end points or the cost of the planned studies which  has been included after the studies have been finalized. </p>
              
              @if($evaluation != '' && $evaluation->is_in_evaluation == 'YES')

              @if($evaluation->remark=="")
              <font color="blue"><br><br>* 
              The substance is currently under evaluation by the authority (ECHA/MSCA). The progress of evaluation can be found at <a href="https://echa.europa.eu/information-on-chemicals/dossier-evaluation-status">Dossier Evaluation status - ECHA</a>. As your only representative, we are sending regular updates received from ECHA/lead registrant/consortium related to evaluation of your substance.<br><br>
              Once the final decision is issued by the authority, as a co-registrant of the substance, you are obliged to fulfil information requirements applicable to your registered tonnage band and you will need to share the costs incurred for additional testing and update of the registration dossier due to ongoing evaluation process.<br><br>
              If you do not intend to participate in the cost-sharing process, you can cease the registration of your substance after the draft decision but before the final decision is issued by the authority.
              </font>
              @else
              <font color="red"><br><br>* {{$evaluation->remark}}</font>
              @endif
              @endif
              
            </p>
           
          <br>
          </div>
          @if(Auth::user()->role_id == 1)
          <h3>SIP</h3>
          <div>
           
            <div class="table-responsive">
                @if(count($sip) > 0)
                <table id="example" class="table display responsive nowrap dataTable no-footer dtr-inline" role="grid"
                  aria-describedby="datatable1_info">
                  <thead class="thead-colored">
                    <tr>
                      <th>Sr No</th>
                      <th>Action</th>
                      <th>Date</th>
                      <th>Region</th>
                      <th>CAS NO</th>
                      <th>EC NO</th>
                      <th>CAS Name</th>
                      <th>UUID</th>
                      <th>Preregistration Number</th>
                    </tr>
                  </thead>
                  <tbody>
                    @php $i = 1; @endphp
                    @foreach($sip as $key => $n)

                    <tr>
                      <th scope="row">{{$i++}}</th>
                      <td style="display: flex;">
                        @if($n->type == 'pdf')
                        @php
                        $pdfdata = DB::table('sip_pdf')->where([['status', 1], ['cas_no', $n->cas_no], ['region_id',
                        $n->region_id]])->first();
                        @endphp
                        @if($pdfdata == NULL)
                        @php
                        $company = DB::table('company_uuid')->where([['cas_no', $n->cas_no], ['region_id', $n->region_id],
                        ['uuid', $n->uuid]])->first();
                        @endphp
                        @if($company != NULL)
                        <a target='_blank' href="{{asset('uploads/sip/'. $company->sip_pdf)}} " class="btn btn-primary">Pdf</a>
                        @endif
                        @else
                        <a target='_blank' href="{{asset('/uploads/'. $pdfdata->pdf)}}" class="btn btn-primary">Pdf</a>
                        @endif
                        @else
                        <a target='_blank' href="/gpclrmainportal/sip-view-pdf/{{base64_encode($n->id)}}"
                          class="btn btn-primary">Pdf</a>
                        @endif


                        <!-- <a class="btn btn-primary" target="_blank" href="sip-view-pdf/{{ base64_encode($n->id) }}" style="border-radius: 0px;color: white;border: 1px solid white;background: ">PDF</a> -->
                      </td>
                      <td>@if($n->created_at != "0000-00-00" && $n->created_at != "-0001-11-30 00:00:00")
                        {{ $n->created_at->format('d-m-Y')}}
                        @endif
                      </td>
                      <td>{{$n->Region->name}}</td>
                      <td>{{$n->cas_no}}</td>
                      <td>{{$n->ec_no}}</td>
                      <td>{{$n->cas_name}}</td>
                      <td>{{$n->uuid}}</td>
                      <td>{{$n->preregistration_no}}</td>
                      
                    </tr>
                    @endforeach
                  </tbody>
                </table>
                @else
                <h4 class="text-center">No SIP Found</h4>
                @endif
              </div>
             
          </div>
          <h3>JSF</h3>
          <div>
        
            <div class="table-responsive">
              @if(count($jsf) > 0)
                <table id="example1" class="table responsive nowrap dataTable no-footer dtr-inline" role="grid"
                  aria-describedby="datatable1_info">
                  <thead class="thead-colored">
                      <tr>
                          <th class="wd-10p">Sr No</th>
                          <th class="wd-10p">Date</th>
                          <th class="wd-35p">Region</th>
                          <th class="wd-35p">CAS NO</th>
                          <th class="wd-35p">EC NO</th>
                          <th class="wd-35p">CAS Name</th>
                          <th class="wd-35p">UUID</th>
                          <th class="wd-35p">Preregistration Number</th>
                          <th>Action</th>
                      </tr>
                  </thead>
                  <tbody>
                      @php $i = 1; @endphp
                      @foreach($jsf as $key => $n)
                      <tr>
                          <th scope="row">{{$i++}}</th>
                          <th>@if($n->created_at != "0000-00-00" && $n->created_at != "-0001-11-30 00:00:00")
                              {{ $n->created_at->format('d-m-Y')}}
                              @endif
                          </th>
                          <td>{{$n->Region->name}}</td>
                          <td>{{$n->cas_no}}</td>
                          <td>{{$n->ec_no}}</td>
                          <td>{{$n->cas_name}}</td>
                          <td>{{$n->uuid}}</td>
                          <td>{{$n->preregistration_no}}</td>
                          <td style="display: flex;">
                              <a class="btn btn-primary" target="_blank"
                                  href="/gpclrmainportal/jsf-view-pdf/{{ base64_encode($n->id) }}">PDF</a>
                          </td>
                      </tr>
                      @endforeach
                  </tbody>
              </table>
              @else
              <h4 class="text-center">No JSF Found</h4>
              @endif
              <br>
            </div>
         
          </div>
          <h3>SIEF Request</h3>
          <div>
        
            @if(count($siffs) > 0)
            <table id="example" class="table" role="grid" aria-describedby="datatable1_info">
              <thead class="thead-colored">
                <tr>
                  <th>Sr No</th>
                  <th>Region</th>
                  <th>Company Name</th>
                  <th>Email</th>
                  <th>CAS NO</th>
                  <th>EC NO</th>
                  <th>UUID</th>
                  <th>Date</th>
                  <th>Action</th>
                  <th>LOA Cost</th>
                  <th>Invoice</th>
                  <th>Creation Date</th>
                  <th>Invoice Sent</th>
                  <th>LOA</th>
                  <th>Is Payment Received</th>
                  <th>Is Token Sent</th>
                </tr>
              </thead>
              <tbody>
                @php $i = 1; @endphp
                @foreach($siffs as $key => $n)
                <tr>
                  <th scope="row">{{ $i++ }}</th>
                  <td>{{ $n->Region->name }}</td> 
                  <td>{{ $n->Company->company_name }}</td>
                  <td>{{ $n->Company->e_mail }}</td>
                  <td>{{ $n->cas_no }}</td>
                  <td>{{ $n->ec_no }}</td>
                  <td>{{ $n->uuid }}</td>
                  <td>{{ $n->created_at->format('d-m-Y') }}</td>
                  <td> 
                  @if($n->request_status_id == config('app.PENDING_REQUEST'))
                      <button id="siff_change_status" data-id="{{$n->id}}" data-status="{{config('app.COMPLETE_REQUEST')}}"  type="button"  class="btn btn-primary" style="border: none;border-radius: 0px;">
                        Allow
                      </button>
                  @endif
                  </td>
                  <td>{{$n->cost}}€</td>
                  <td>
                      @php
                       $company = DB::table('company_uuid')->where('id', $n->company_id)->first(); 
                      @endphp
                      <a id="download-sief-agreement" data-cas_no="{{base64_encode($n->cas_no)}}"
                data-company_id="{{base64_encode($n->company_id)}}" data-id="{{base64_encode($n->id)}}" data-pr_no="{{base64_encode($n->preregistration_no)}}" class="btn btn-success text-white" >View SIEF</a>
                      @if($company->invoice_pdf == '' || $company->invoice_pdf == NULL)
                          <a id="create-invoice" class="create-invoice btn btn-primary text-white" data-href="create-invoice/{{base64_encode($n->cas_no)}}/{{base64_encode($n->uuid)}}/{{base64_encode($n->region_id)}}" >Create Invoice</a>
                      @else
                      <a href="/uploads/invoice/{{$company->invoice_pdf}} " target="blank" class="btn btn-primary">Pdf</a>
                      @endif
                  </td>
                  <td>