@extends('layouts.app')
@section('title', __('Product Sell Details'))
@section('content')
<!-- Content Header (Page header) -->
<section class="content-header">
    <h1>{{$product->name}} - {{$product->sku}}</h1>
</section>
<style>
    select,
    .select2-container {
        width: 100% !important;
    }

    .mt-10px {
        margin-top: 10px;
    }

    .margin-right-10 {
        margin-right: 10px;
    }
</style>
<!-- Main content -->
<section class="content">

    <div class="row">
        <div class="col-md-12">
            <!-- Custom Tabs -->
            <div class="nav-tabs-custom">
                <div class="row">
                    <div class="col-md-5">
                        <ul class="nav nav-tabs">
                            <li class="active">
                            </li>

                        </ul>
                    </div>
                    <div class="col-md-7 mt-10px">

                    </div>
                </div>

                <div class="tab-content">

                    <div class="tab-pane active" id="output_tax_tab">
                        <table class="table table-bordered table-striped ajax_view" id="Sell_details_table" style="width: 100%;">
                            <thead>
                                <tr>
                                    <th>@lang('SNo')</th>

                                    <th>Date</th>
                                    <th>Invoice#</th>
                                    <th>Type</th>
                                    <th>@lang('Sale Quantity')</th>
                                    <th>@lang('Return Quantity')</th>
                                    <th>@lang('Cost Price')</th>
                                    <th>@lang('product.product_mrp')</th>
                                    <th>@lang('Selling Price')</th>
                                    <th>@lang('lang_v1.potential_profit')</th>
                                    <th>@lang('Profit Margin %')</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                $x = 0;
                                @endphp

                                @foreach($sellReportDetails as $sell_line)
                                @php
                                $x++;
                                $totalQty = $sell_line->sold_qty - $sell_line->r_qty; // Calculate total quantity first

                                // Assign location type before use
                                $locationType = $businessType ? $businessType->location_type : '';

                                // Determine cost price based on location type
                                if ($locationType == 'warehouse') {
                                $costPrice = $sell_line->dpp_inc_tax * $totalQty;
                                } else {
                                $costPrice = $sell_line->priceListCost * $totalQty;
                                }

                                // Calculate profit and total selling
                                $totalSelling = $sell_line->selling_price * $totalQty;
                                $profit = $totalSelling - $costPrice;

                                // Calculate profit margin
                                $profit_margin = $totalSelling > 0 ? ($profit / $totalSelling) * 100 : 0;
                                @endphp
                                <tr>
                                    <td>{{ $x }}</td>
                                    <td>{{ $sell_line->created_at }}</td>
                                    <td>{{ $sell_line->invoice_no }}</td>
                                    <td>{{ $sell_line->transaction_type }}</td>
                                    <td>{{ number_format($sell_line->sold_qty,2) }}</td>
                                    <td>{{ number_format($sell_line->r_qty,2) }}</td>
                                    <td>{{ number_format($costPrice,2) }}</td>
                                    <td>{{ number_format($sell_line->product_mrp * $totalQty,2) }}</td>
                                    <td>{{ number_format($sell_line->selling_price * $totalQty ,2) }}</td>
                                    <td>{{ number_format($profit,2) }}</td>
                                    <td>{{ number_format($profit_margin,2) }}</td>
                                </tr>
                                @endforeach


                            </tbody>
                        </table>
                    </div>

                </div>
            </div>
        </div>
    </div>
</section>
@stop
@section('javascript')

@endsection