@extends('admin.layout.master')
@section('title','COSTING SHEET')
@section('custom_style')
<style>
    input[type=text],
    input[type=file],
    input[type=number] {
        height: 35px !important;
        max-width: 75px;
    }
    .table thead th,.table tbody td,.table tfoot th 
    {
        border: 1px solid black !important;
        /* max-width: 30px; */
        text-align: center;
        vertical-align: middle;
    }
    .table tbody td
    {
        padding:1px 2px;
    }
    .table thead th
    {
        padding:2px 3px;
    }

</style>
@endsection
@section ('content')
<div class="card sina-card">
    <div class="card-header card-header-s d-flex flex-wrap align-items-center">
        <div class="col-md-6 col-12 pl-0">
            <h4 >COSTING SHEET</h4>
        </div>
        <div class="col-6 d-flex justify-content-end">
            <button id="myButtonControlID" class="btn-sina-title-add d-flex align-items-center" type="button" name="button">
                <div class=""> Excel </div>
                <div class="col pl-2 pr-0">
                    <i class="fa fa-download"></i>
                </div>
            </button>
            &nbsp;
            <button class="btn-sina-title-add d-flex align-items-center" type="button" name="button" onclick="PrintDiv()">
                <div class=""> Print </div>
                <div class="col pl-2 pr-0">
                    <i class="fa fa-print"></i>
                </div>
            </button>
        </div>
        {{-- <div class="pl-0 pl-md-4 mt-md-0 mt-2 col-md-4 col-12 d-flex justify-content-md-end justify-content-start text-white pr-0">
            <label for="report_type">Currency</label>
        </div>
        <div  class="pl-0 pl-md-3 col-md-2 col-12 d-flex">
            <select class="form-control select_2" onchange="currencyChange(-1)" style="width: 100%" name="currency" id="currency">
                @forelse ($currency as $item)
                    <option value="{{$item->id}}" {{$item->id == $quotation->currency_id ? 'selected' : ''}} roe="{{$item->roe}}">{{$item->name}}</option>
                @empty
                    
                @endforelse
            </select>
        </div> --}}
    </div>
    <div class="card-body" id="divTableDataHolder">
        <div class="">
                <div class="tab-content">
                </div>
            </div> 
            {{-- end --}}
            <hr>
            <div class="table">
                
                <table class="table table-bordered">
                    <thead>
                        <tr class="bg-dark text-light">
                            <th colspan="6" class="text-left">Customer : {{$quotation->party->name_eng}}</th>
                            <th colspan="5" class="text-center">|| Order NO : {{$quotation->quotation_no}} ||</th>
                            <th colspan="6" class="text-right">Currency : {{$quotation->currency->name}}</th>
                        </tr>
                        <tr>
                            <th rowspan="2">#</th>
                            <th rowspan="2">PRODUCT</th>
                            <th rowspan="2">Packing Size</th>
                            <th colspan="2">F. Rate</th>
                            <th colspan="2">Costing</th>
                            <th rowspan="2">Comm<br>(CTN)</th>
                            <th rowspan="2">FOB</th>
                            <th rowspan="2">CBM</th>
                            <th rowspan="2">QTY</th>
                            <th rowspan="2">T.CBM</th>
                            <th rowspan="2">OFFER</th>
                            <th colspan="2">Profit</th>
                            <th rowspan="2">T.FOB</th>
                            <th rowspan="2">GP</th>
                        </tr>
                        <tr>
                            {{-- size --}}
                            {{-- <th>carton</th>
                            <th>piece</th> --}}
                            {{-- rate --}}
                            <th>PCS</th>
                            <th>Carton</th>
                            {{-- costing --}}
                            <th>O. Cost</th>
                            <th>Comm.(%)</th>
                            {{-- Profit --}}
                            <th>Carton</th>
                            <th>Total</th>
                        </tr>
                    </thead>
                    <tbody id="tbl_body">
                        @php
                            $total_qty=0;
                            $total_tcbm=0;
                            $total_gprofit=0;
                            $total_fob_offer_g=0;
                            $i=0;
                            $roe=$quotation->roe;
                        @endphp
                        @forelse ($quotation->details as $k=>$item)
                        @php
                            $unit_price=($item->unit_price);
                            $ctn_price=($item->unit_size*$unit_price);
                            $other_cost=($item->other_cost);
                            $commission_total=($item->commission_rate*$ctn_price);
                            $fob=((($ctn_price+$other_cost)-$commission_total)/$roe);
                            $tcbm=($item->cbm_unit*$item->qty);
                            $offer_fob_unit=($item->offer_fob_unit);
                            $profit_unit=($offer_fob_unit-$fob);
                            $profit_total=($profit_unit*$item->qty);
                            $total_fob_offer=($offer_fob_unit*$item->qty);
                        @endphp
                        <tr id="tr-`+index+`">
                            <td>{{++$i}}</td>
                            <td>
                                <div class="d-flex text-left">
                                    {{$item->product->name_eng}}
                                </div>
                            </td>
                            <td class="text-right">{{$item->unit_size}}</td>
                            <td class="text-right">{{ number_format($unit_price,2) }}</td>
                            <td class="text-right">{{ number_format($ctn_price,2) }}</td>
                            <td class="text-right">{{ number_format($other_cost,2) }}</td>
                            <td class="text-right">{{ number_format(($item->commission_rate*100),2) }}</td>
                            <td class="text-right">{{ number_format($commission_total,2)}}</td>
                            <td><div style="width:100%;display:flex;"><div style="text-align: left;width:15%">$</div><div style="text-align: right;width:80%"> {{ number_format($fob,2)}}</div></td>
                            <td class="text-right">{{ number_format($item->cbm_unit,2)}}</td>
                            <td class="text-right">{{ number_format($item->qty,2)}}</td>
                            <td class="text-right">{{ number_format($tcbm,2)}}</td>
                            <td class="{{$item->fob_type==1?'bg-light text-bold':''}}"><div style="width:100%;display:flex;"><div style="text-align: left;width:15%">$</div><div style="text-align: right;width:80%"> {{ number_format($offer_fob_unit,2)}}</div></td>
                            <td><div style="width:100%;display:flex;"><div style="text-align: left;width:15%">$</div><div style="text-align: right;width:80%"> {{ number_format($profit_unit,2)}}</div></td>
                            <td><div style="width:100%;display:flex;"><div style="text-align: left;width:15%">$</div><div style="text-align: right;width:80%"> {{ number_format($profit_total,2)}}</div></td>
                            <td><div style="width:100%;display:flex;"><div style="text-align: left;width:15%">$</div><div style="text-align: right;width:80%"> {{ number_format($total_fob_offer,2)}}</div></td>
                            <td class="text-right">{{ number_format((($profit_total/$total_fob_offer)*100),2)}}</td>
                        </tr>
                        @php
                            $total_qty+=$item->qty;
                            $total_tcbm+=$tcbm;
                            $total_gprofit+=$profit_total;
                            $total_fob_offer_g+=$total_fob_offer;
                        @endphp
                        @empty
                            
                        @endforelse
                    </tbody>
                    <tfoot>
                        <tr>
                            <th colspan="10" class="text-right"><span id="water_mark" style="position:absolute; top:20%; right:50%; opacity:0.3; z-index:99;font-size:45px; color:black;transform:rotate(0deg);font-weight:normal ">{{$quotation->status==1?'':'DRAFT'}}</span>Total</th>
                            <th class="text-right">{{ number_format($total_qty,2)}}</th>
                            <th class="text-right">{{ number_format($total_tcbm,2)}}</th>
                            <th colspan="2"></th>
                            <th class="text-right">{{ number_format($total_gprofit,2)}}</th>
                            <th class="text-right">{{ number_format($total_fob_offer_g,2)}}</th>
                            <th class="text-right">{{ number_format((($total_gprofit/$total_fob_offer_g)*100),2)}}</th>
                        </tr>
                        <tr>
                            <th colspan="15" class="text-right">Add, Other Charge</th>
                            @php
                                $invoice_charge=($quotation->invoice_charge/$roe);
                            @endphp
                            <th class="text-right">{{number_format($invoice_charge,2)}}</th>
                            <th></th>
                        </tr>
                        <tr>
                            <th colspan="15" class="text-right">Net Amount</th><th class="text-right">{{number_format(($total_fob_offer_g+$invoice_charge),2)}}</th>
                            <th></th>
                        </tr>
                    </tfoot>
                </table>
            </div>
            <hr>
            
            <div class="row pb-0  modal-footer">
                {{-- <input class="btn-sina-submit" type="button" id="save" value="Print"> --}}
            </div>
    </div>
</div>

@endsection