@extends('layouts.app')

@section('content')

<!-- start page title -->
<div class="row">
    <div class="col-12">
        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
            <h4 class="mb-sm-0 font-size-18">Sales P & L Report</h4> 

            <div class="page-title-right">
                <ol class="breadcrumb m-0">
                    <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboards</a></li> 
                    <li class="breadcrumb-item">Reports</li>
                    <li class="breadcrumb-item active">Sales P & L </li>
                </ol>
            </div>

        </div>
    </div>
</div>
<!-- end page title -->
@include('validate')
<div class="row">

    <div class="col-md-12">

        <div class="card">
            <div class="card-body">
                <h4 class="card-title mb-4">Sales P & L Report</h4>


                <form method="POST" action="{{ route('report.salespandl') }}">
                    <div class="row mb-4 mt-4"> 
    
                        <div class="col-md-4">
                            <div class="mb-3">
                                 <div class="input-group" id="from_date">
                                    <input type="text" name="from_date" class="form-control" data-date-format="{{ js_app_date_format() }}" data-date-container='#from_date' data-provide="datepicker" placeholder="From Date" autocomplete="off" value="{{ $req_data['from_date'] ?? date(app_date_format(),strtotime($startDate)) }}" required>
                                    <span class="input-group-text"><i class="mdi mdi-calendar"></i></span>
                                </div><!-- input-group --> 
                            </div>
                        </div> 

                        <div class="col-md-4">
                            <div class="mb-3">
                                 <div class="input-group" id="to_date">
                                    <input type="text" name="to_date" class="form-control" data-date-format="{{ js_app_date_format() }}" data-date-container='#to_date' data-provide="datepicker" placeholder="To Date" autocomplete="off" value="{{ $req_data['to_date'] ?? date(app_date_format(),strtotime($endDate)) }}" required>
                                    <span class="input-group-text"><i class="mdi mdi-calendar"></i></span>
                                </div><!-- input-group --> 
                            </div>
                        </div> 

                        <div class="col-md-4">
                            <div class="mb-3">
                            <select class="form-control" name="is_estimate" id="is_estimate">
                                <option value="">Type</option>
                                <option value="no" @if(isset($req_data['is_estimate']) && $req_data['is_estimate'] == 'no') @selected(true) @endif >Invoice</option>
                                <option value="yes" @if(isset($req_data['is_estimate']) && $req_data['is_estimate'] == 'yes') @selected(true) @endif>Estimate</option>
                            </select>
                            </div>
                          </div>

                          <div class="col-md-4">
                            <div class="mb-3">
                            <select class="form-control select2" name="branch_id" id="branch_id" data-width="100%">
                                <option value="">Branch</option>
                                @foreach ($branchData as $branch)
                                <option value="{{ $branch->id }}" @if(isset($req_data['branch_id']) && $req_data['branch_id'] == $branch->id) @selected(true) @endif>{{ $branch->branch_name }}</option>
                                @endforeach
                            </select>
                            </div>
                          </div> 
    
                          <div class="col-md-4">
                            @csrf
                            <button class="btn btn-info" type="submit">SEARCH</button>
                          </div>
    
    
                    </div>
                </form>


                <div class="table-responsive">

                    <table class="table table-striped">
                       <thead>
                        <tr>
                          <th>Branch</th> 
                          <th>Type</th>
                          <th>Ref. No.</th> 
                          <th>Date</th> 
                          <th>Customer</th>  
                          <th>Total</th>  
                          <th>P & L </th>   
                          <th>P & L %</th>
                        </tr>
                       </thead>
                       <tbody>
                         @forelse ($invoiceList as $invoice)
                             <tr>
                                <td>{{ $invoice->branch->branch_name ?? '' }}</td>
                                <td>
                                    @if($invoice->is_estimate == 'yes')
                                        <span class="badge badge-pill badge-soft-warning font-size-12">Estimate</span>
                                        @elseif($invoice->is_estimate == 'no')
                                        <span class="badge badge-pill badge-soft-success font-size-12">Invoice</span>
                                        @endif
                                </td>
                                <td>{{ $invoice->reference_no }}</td>
                               <td>{{ $invoice->invoice_date->format(app_date_format()) }}</td>
                               <td>{{ $invoice->customer->customer_name ?? '' }}</td>  
                               <td align="right">{{ number_format($invoice->grand_total,2) }}</td>
                               <td align="right">
                               @if($invoice->profit_amount < 0)
                               <span class="text-danger">{{ number_format($invoice->profit_amount,2) }}</span>
                               @else 
                               <span class="text-success">{{ number_format($invoice->profit_amount,2) }}</span>
                               @endif
                               </td> 
                               <td> {{ $invoice->plpercentage() }} % </td>
                             </tr>
                         @empty
                             <tr>
                               <td colspan="8">@lang('general.no_details_found')</td>
                             </tr>
                         @endforelse  
                       </tbody>

                    </table>


                </div>


                <div class="row"> 
                    <div class="col-md-12">
                        <form method="POST" action="{{ route('report.salespandl.export') }}">
                            @csrf
                            <input type="hidden" name="export_data" id="export_data" value="{{ json_encode($req_data) }}">
                           <button type="submit" class="btn btn-warning float-end">Export</button>
                        </form>
                    </div> 
                </div>

                
            </div>
            <!-- end card body -->
        </div>

    </div>

</div>


@endsection