@extends('layouts.app')

@section('title')
{{__('Project Reports')}}
@endsection

@section('breadcrumb')
<div class="content-header">
  <div class="container-fluid">
    <div class="row mb-2">
      <div class="col-sm-6">
        <h1 class="m-0 text-dark">
        <i class="fas fa-file-archive"></i>
          {{__('Project Report')}}
        </h1>
      </div><!-- /.col -->
      <div class="col-sm-6">
        <ol class="breadcrumb float-sm-right">
          <li class="breadcrumb-item"><a href="{{route('admin.index')}}">{{__('Home')}}</a></li>
          <li class="breadcrumb-item active">{{__('Reports')}}</li>
        </ol>
      </div><!-- /.col -->
    </div><!-- /.row -->
  </div><!-- /.container-fluid -->
</div>
@endsection

@section('content')
<div class="card card-primary">
  <!-- card-header -->
  <div class="card-header">

  </div>
  <!-- /.card-header -->
  <!-- card-body -->
  <div class="card-body">

    <!-- Filtering Form -->
    <div id="accordion">
      <div class="card card-info">
          <a data-toggle="collapse" data-parent="#accordion" href="#collapseOne" class="btn btn-primary collapsed"
              aria-expanded="false">
              <i class="fas fa-filter"></i> {{__('Filters')}}
          </a>
          <form method="get" action="{{route('admin.reports.projects')}}">
            <div id="collapseOne" class="panel-collapse in collapse show">
                <div class="card-body">
                    <div class="row">

                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <label>{{__('Date range')}}:</label>
                            <div class="input-group">
                                <div class="input-group-prepend">
                                    <span class="input-group-text">
                                        <i class="far fa-calendar-alt"></i>
                                    </span>
                                </div>
                                
                                <input type="text" name="date" id="date" autocomplete="off" class="form-control float-right datepickerrange" @if(request()->has('date')) value="{{request()->get('date')}}" @else value="{{ date('F d, Y', strtotime('-1month')) . ' - ' . date('F d, Y') }}" @endif id="date"required>
                                <div class="input-group-append">
                                  <button class="btn btn-outline-secondary clear_date" type="button">Clear</button>
                                </div>
                            </div>
                        </div>

                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="form-group">
                                <label>{{__('Program')}}</label>
                                <select class="form-control" name="program[]" id="program" multiple>
                                    @if(isset($programs))
                                        @foreach($programs as $program)
                                            <option value="{{$program->id}}" selected>{{$program->program_name}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                    </div>

                    <div class="row">

                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="form-group">
                                <label>{{__('Identifiers')}}</label>
                                <select class="form-control" name="identifiers[]" id="identifiers" multiple>
                                    @if(isset($identifiers))
                                        @foreach($identifiers as $indentifier)
                                            <option value="{{$indentifier->id}}" selected>{{$indentifier->name}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="form-group">
                                <label>{{__('Type of Research')}}</label>
                                <select class="form-control" name="type_of_res[]" id="type_of_res" multiple>
                                    @if(isset($types_of_res))
                                        @foreach($types_of_res as $type_of_res)
                                            <option value="{{$type_of_res->id}}" selected>{{$type_of_res->name}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                    </div>

                    <div class="row">

                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="form-group">
                                <label>{{__('Project Leader')}}</label>
                                <select class="form-control" name="project_leader[]" id="project_leader" multiple>
                                    @if(isset($project_leaders))
                                        @foreach($project_leaders as $project_leader)
                                            <option value="{{$project_leader->id}}" selected>{{$project_leader->name}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="form-group">
                                <label>{{__('Requesting Individuals')}}</label>
                                <select class="form-control" name="req_individuals[]" id="req_individuals" multiple>
                                    @if(isset($req_individuals))
                                        @foreach($req_individuals as $individual)
                                            <option value="{{$individual->id}}" selected>{{$individual->name}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                    </div>

                    <div class="row">

                        <div class="col-lg-4 col-md-4 col-sm-4 col-xs-4">
                            <div class="form-group">
                                <label>{{__('Co-Investigators')}}</label>
                                <select class="form-control" name="co_investigators[]" id="co_investigators" multiple>
                                    @if(isset($co_investigators))
                                        @foreach($co_investigators as $inv)
                                            <option value="{{$inv->id}}" selected>{{$inv->name}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                        <div class="col-lg-4 col-md-4 col-sm-4 col-xs-4">
                            <div class="form-group">
                                <label>{{__('Project Staff')}}</label>
                                <select class="form-control" name="project_staff[]" id="project_staff" multiple>
                                    @if(isset($project_staff))
                                        @foreach($project_staff as $pro_staff)
                                            <option value="{{$pro_staff->id}}" selected>{{$pro_staff->name}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                        <div class="col-lg-4 col-md-4 col-sm-4 col-xs-4">
                            <div class="form-group">
                                <label>{{__('Research Staff')}}</label>
                                <select class="form-control" name="research_staff[]" id="research_staff" multiple>
                                    @if(isset($research_staff))
                                        @foreach($research_staff as $res_staff)
                                            <option value="{{$res_staff->id}}" selected>{{$res_staff->name}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                    </div>

                    <div class="row">

                        <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                            <div class="form-group">
                                <label>{{__('Other Researchers')}}</label>
                                <select class="form-control" name="other_res[]" id="other_res" multiple>
                                    @if(isset($other_res))
                                        @foreach($other_res as $o_res)
                                            <option value="{{$o_res['id']}}" selected>{{$o_res['name']}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                    </div>

                    <div class="row">

                        <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                            <div class="form-group">
                                <label>{{__('Institutional Partners')}}</label>
                                <select class="form-control" name="ins_partners[]" id="ins_partners" multiple>
                                    @if(isset($ins_partners))
                                        @foreach($ins_partners as $partner)
                                            <option value="{{$partner['id']}}" selected>{{$partner['name']}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                    </div>

                    <div class="row">

                        <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                            <div class="form-group">
                                <label>{{__('Test')}}</label>
                                <select class="form-control" name="tests[]" id="test" multiple>
                                    @if(isset($tests))
                                        @foreach($tests as $test)
                                            <option value="{{$test['id']}}" selected>{{$test['name']}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                    </div>

                    <div class="row">

                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="form-group">
                                <label>{{__('Contract')}}</label>
                                <select class="form-control" name="contracts[]" id="contract" multiple>
                                    @if(isset($contracts))
                                        @foreach($contracts as $contract)
                                            <option value="{{$contract->id}}" selected>{{$contract->title}}</option>
                                        @endforeach
                                    @endif
                                </select>
                            </div>
                        </div>

                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="form-group">
                                <label>{{__('Status')}}</label>
                                <select class="form-control" name="status[]" id="status" multiple>
                                    <option value="Proposal" @if(isset($status)) @if(in_array("Proposal", $status)) selected @endif @endif>Proposal</option>
                                    <option value="Ongoing" @if(isset($status)) @if(in_array("Ongoing", $status)) selected @endif @endif>Ongoing</option>
                                    <option value="For Completion" @if(isset($status)) @if(in_array("For Completion", $status)) selected @endif @endif>For Completion</option>
                                    <option value="Completed" @if(isset($status)) @if(in_array("Completed", $status)) selected @endif @endif>Completed</option>
                                </select>
                            </div>
                        </div>

                    </div>

                </div>

                <div class="card-footer">
                  <button type="submit" class="btn btn-primary">
                    <i class="fas fa-cog"></i>
                    {{__('Generate')}}
                  </button>
                </div>

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

    <!-- Filtering Form -->
    @if(request()->has('date'))
      <!-- Report Details -->
      <div class="card card-primary card-tabs">
        <div class="card-header p-0">
          <ul class="nav nav-tabs" id="custom-tabs-one-tab" role="tablist">
            <li class="nav-item">
              <a class="nav-link active" id="custom-tabs-one-projects-tab" data-toggle="pill" href="#custom-tabs-one-projects" role="tab" aria-controls="custom-tabs-one-projects" aria-selected="false">{{__('Projects')}}</a>
            </li>
            <li class="nav-item">
              <a class="nav-link" id="custom-tabs-one-payments-tab" data-toggle="pill" href="#custom-tabs-one-payments" role="tab" aria-controls="custom-tabs-one-payments" aria-selected="false">{{__('Payments')}}</a>
            </li>
            <li class="nav-item">
                <a class="nav-link" id="custom-tabs-one-order-of-payments-summary-tab" data-toggle="pill" href="#custom-tabs-one-order-of-payments-summary" role="tab" aria-controls="custom-tabs-one-order-of-payments-summary" aria-selected="false">{{__('Order of Payments Summary')}}</a>
            </li>
          </ul>
        </div>
        <div class="card-body">
          <div class="tab-content" id="custom-tabs-one-tabContent">
            <div class="tab-pane fade active show" id="custom-tabs-one-projects" role="tabpanel" aria-labelledby="custom-tabs-one-projects-tab">
             <div class="row">
              <div class="col-lg-12 table-responsive">
                <table class="table table-striped table-bordered datatable">
                  <thead>
                    <tr>
                      <th>#</th>
                      <th>{{__('Date')}}</th>
                      <th>{{__('Project Code')}}</th>
                      <th>{{__('Research Code')}}</th>
                      <th>{{__('Title')}}</th>
                      <th>{{__('Program')}}</th>
                      <th>{{__('Type of Research')}}</th>
                      <th>{{__('Identifiers')}}</th>
                      <th>{{__('Requesting Individuals')}}</th>
                      <th>{{__('Project Leader')}}</th>
                      <th>{{__('Co-Investigators')}}</th>
                      <th>{{__('Project Staff')}}</th>
                      <th>{{__('Research Staff')}}</th>
                      <th>{{__('Other Researchers')}}</th>
                      <th>{{__('General Objective')}}</th>
                      <th>{{__('Specific Objective')}}</th>
                      <th>{{__('Agency')}}</th>
                      <th>{{__('Management')}}</th>
                      <th>{{__('Proposed Budget')}}</th>
                      <th>{{__('Approved Budget')}}</th>
                      <th>{{__('Implementation Start Date')}}</th>
                      <th>{{__('Implementation End Date')}}</th>
                      <th>{{__('Ethics Review Committee')}}</th>
                      <th>{{__('NUHRA Classification')}}</th>
                      <th>{{__('Research Type')}}</th>
                      <th>{{__('Expected Output')}}</th>
                      <th>{{__('Sustainable Development Goals')}}</th>
                      <th>{{__('Institutional Partners')}}</th>
                      <th>{{__('Publications Based From the Research')}}</th>
                      <th>{{__('Date Published')}}</th>
                      <th>{{__('Project Repository')}}</th>
                      <th>{{__('Project Status')}}</th>
                      <th>{{__('Project Contract')}}</th>
                      <th>{{__('Tests')}}</th>
                      <th>{{__('Total')}}</th>
                      <th>{{__('Paid')}}</th>
                      <th>{{__('Due')}}</th>
                    </tr>
                  </thead>
                  <tbody>
                    @foreach($projects as $key => $project)
                    <tr>
                        <td>{{$key+1}}</td>
                        <td>{{date_format(date_create($project->created_at), 'M j, Y')}}</td>
                        <td>{{$project->code}}</td>
                        <td>{{$project->project_code}}</td>
                        <td>{{$project->project_title}}</td>
                        <td>{{(isset($project->program)) ? $project->program->program_name : "No Program Assigned"}}</td>
                        <td>{{(isset($project->research)) ? $project->research->name : "No Type Assigned"}}</td>
                        <td>
                            @if($project->get_identifiers())
                            @foreach($project->get_identifiers() as $iden)
                            <p class="m-0 p-0">{{$iden->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>
                            @if($project->get_requesting_individuals())
                            @foreach($project->get_requesting_individuals() as $indi)
                            <p class="m-0 p-0">{{$indi->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>
                            @if($project->get_project_leaders())
                            @foreach($project->get_project_leaders() as $lead)
                            <p class="m-0 p-0">{{$lead->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>
                            @if($project->get_co_investigators())
                            @foreach($project->get_co_investigators() as $cos)
                            <p class="m-0 p-0">{{$cos->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>
                            @if($project->get_staff())
                            @foreach($project->get_staff() as $staff)
                            <p class="m-0 p-0">{{$staff->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>
                            @if($project->get_res_staff())
                            @foreach($project->get_res_staff() as $staff)
                            <p class="m-0 p-0">{{$staff->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>
                            @if($project->get_other_researchers())
                            @foreach($project->get_other_researchers() as $staff)
                            <p class="m-0 p-0">{{$staff->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>{{$project->objective_general}}</td>
                        <td>{{$project->objective_specific}}</td>
                        <td>
                            @if($project->get_agencies())
                            @foreach($project->get_agencies() as $agency)
                            <p class="m-0 p-0">{{$agency->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>
                            @if($project->get_management())
                            @foreach($project->get_management() as $manage)
                            <p class="m-0 p-0">{{$manage->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>{{ formated_price($project->funds_proposed_budget) }}</td>
                        <td>{{ formated_price($project->funds_approved_budget) }}</td>
                        <td>{{ ($project->implementation_sdate != null) ? date_format(date_create($project->implementation_sdate), 'M j, Y') : "" }}</td>
                        <td>{{ ($project->implementation_edate != null) ? date_format(date_create($project->implementation_edate), 'M j, Y') : "" }}</td>
                        <td>
                            @if($project->get_ethics())
                            @foreach($project->get_ethics() as $erc)
                            <p class="m-0 p-0">{{$erc->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>
                            @if($project->get_nuhras())
                            @foreach($project->get_nuhras() as $nuhra)
                            <p class="m-0 p-0">{{$nuhra->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>{{$project->proj_det_research_type}}</td>
                        <td>{{($project->expected_output != null) ? $project->expected_output->name : ""}}</td>
                        <td>
                            @if($project->get_sdgs())
                            @foreach($project->get_sdgs() as $sdg)
                            <p class="m-0 p-0">{{$sdg->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>
                            @if($project->get_i_partners())
                            @foreach($project->get_i_partners() as $partner)
                            <p class="m-0 p-0">{{$partner->name}}</p>
                            @endforeach
                            @endif
                        </td>
                        <td>{{$project->proj_det_publications}}</td>
                        <td>{{ ($project->date_published != null) ? date_format(date_create($project->date_published), 'M j, Y') : "" }}</td>
                        <td>{{($project->repository != null) ? $project->repository : ""}}</td>
                        <td>{{($project->status != null) ? $project->status : ""}}</td>
                        <td>{{($project->contract != null) ? $project->contract->title : ""}}</td>
                        <td>
                          @foreach($project->all_tests as $test)
                            <p class="m-0 p-0">{{$test->test->name}}</p>
                          @endforeach
                        </td>
                        <td>{{formated_price($project->order_of_payments_total()['total'])}}</td>
                        <td>{{formated_price($project->order_of_payments_total()['paid'])}}</td>
                        <td>{{formated_price($project->order_of_payments_total()['due'])}}</td>
                    </tr>
                    @endforeach

                    </tbody>
                  </table>
                </div>
              </div>
            </div>
            <div class="tab-pane fade" id="custom-tabs-one-payments" role="tabpanel" aria-labelledby="custom-tabs-one-payments-tab">
              <div class="row">
                <div class="col-lg-12 table-responsive">
                  <table class="table table-striped  table-bordered datatable">
                    <thead>
                      <tr>
                          <th width="10px">#</th>
                          <th>{{__('Project Code')}}</th>
                          <th>{{__('Research Code')}}</th>
                          <th>{{__('Program')}}</th>
                          <th>{{__('Title')}}</th>
                          <th>{{__('Order of Payment')}}</th>
                          <th>{{__('Service Summary')}}</th>
                          <th>{{__('Date')}}</th>
                          <th>{{__('Amount')}}</th>
                          <th>{{__('Payment Method')}}</th>
                      </tr>
                    </thead>
                    <tbody>
                      @foreach($payments as $key => $payment)
                      <tr>
                        <td>{{$key+1}}</td>
                        <td>{{$payment->oop->project->code}}</td>
                        <td>{{$payment->oop->project->project_code}}</td>
                        <td>{{(isset($payment->oop->project->program)) ? $payment->oop->project->program->program_name : "No Program Assigned"}}</td>
                        <td>{{$payment->oop->project->project_title}}</td>
                        <td>{{$payment->oop->oop_no}}</td>
                        <td>
                          @if($payment->oop->get_service_sums())
                            @foreach($payment->oop->get_service_sums() as $ss)
                            <p class="m-0 p-0">{{$ss->ss_no}}</p>
                            @endforeach
                          @endif
                        </td>
                        <td>{{($payment->date != null) ? date_format(date_create($payment->date), 'M j, Y') : ""}}</td>
                        <td>{{formated_price($payment->amount)}}</td>
                        <td>{{$payment->method->name}}</td>
                      </tr>
                      @endforeach
                    </tbody>
                  </table>
                </div>
              </div>
            </div>
            <div class="tab-pane fade" id="custom-tabs-one-order-of-payments-summary" role="tabpanel" aria-labelledby="custom-tabs-one-order-of-payments-summary-tab">
              <div class="row">
                <div class="col-lg-12 table-responsive">
                  <table class="table table-striped  table-bordered datatable">
                    <thead>
                      <tr>
                          <th width="10px">#</th>
                          <th>{{__('Project Code')}}</th>
                          <th>{{__('Research Code')}}</th>
                          <th>{{__('Program')}}</th>
                          <th>{{__('Title')}}</th>
                          <th>{{__('Order of Payment')}}</th>
                          <th>{{__('Service Summary')}}</th>
                          <th>{{__('Total')}}</th>
                          <th>{{__('Paid')}}</th>
                          <th>{{__('Due')}}</th>
                      </tr>
                    </thead>
                    <tbody>
                      @foreach($oops as $key => $oop)
                      <tr>
                        <td>{{$key+1}}</td>
                        <td>{{$oop->project->code}}</td>
                        <td>{{$oop->project->project_code}}</td>
                        <td>{{(isset($oop->project->program)) ? $oop->project->program->program_name : "No Program Assigned"}}</td>
                        <td>{{$oop->project->project_title}}</td>
                        <td>{{$oop->oop_no}}</td>
                        <td>
                          @if($oop->get_service_sums())
                            @foreach($oop->get_service_sums() as $ss)
                            <p class="m-0 p-0">{{$ss->ss_no}}</p>
                            @endforeach
                          @endif
                        </td>
                        <td>{{formated_price($oop->total_price)}}</td>
                        <td>{{formated_price($oop->paid)}}</td>
                        <td>{{formated_price($oop->due)}}</td>
                      </tr>
                      @endforeach
                    </tbody>
                  </table>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>

    @endif
  </div>
  <!-- /.card-body -->

  <!-- card-footer -->
  @if(request()->has('date'))
    <div class="card-footer">
      <a href="{{request()->fullUrl()}}&excel=true" class="btn btn-success">
        <i class="fas fa-file-excel mr-1"></i> {{__('Excel')}}
      </a>
    </div>
  @endif
  <!-- /.card-footer -->
</div>

@endsection
@section('scripts')
{{-- <script src="{{url('plugins/daterangepicker/daterangepicker.js')}}"></script> --}}
<script src="{{url('plugins/print/jQuery.print.min.js')}}"></script>
<script src="{{url('js/admin/project_report.js')}}"></script>
@endsection