@extends('layouts.app')
@section('title') {{'Group/Sub Group Wise Stock'}} @endsection 
@section('content')

    <div class="col-md-12">
        <div class="panel panel-default">
            <div class="panel-heading">
                Group/Sub Group Wise Stock
                <a href="{{ url('/GroupWiseStock') }}" class="pull-right"> Back </a>
            </div>
            @if (Session::has('msg'))
                <div class="alert alert-info">{{ Session::get('msg') }}</div>
            @endif
            <div class="panel-body">
            <div class="form-group">
            <form action="" method="get" autocomplete="off">
                <div class="form-group">
                    <div class="col-md-2">
                        Search Group
                        <select name="group_id" id="group_id"data-live-search="true" class="form-control selectpicker" onchange="resetOption('sub_group_id')">
                            <option value="" selected="selected" > Search </option>
                            @if(isset($group_info))
                                @foreach($group_info as $val)
                                    <option value="{{ $val->id }}" @if(isset($_GET['group_id']) && ($_GET['group_id'] == $val->id)) selected="selected" @endif >{{ $val->id }} - {{ $val->values }}</option>
                                @endforeach
                            @endif
                        </select>
                    </div>
                    <div class="col-md-2">
                        Search Sub Group
                        <select name="sub_group_id" id="sub_group_id" data-live-search="true" class="form-control selectpicker" onchange="resetOption('group_id')">
                            <option value="" selected="selected" > Search </option>
                            @if(isset($sub_group_info))
                                @foreach($sub_group_info as $val)
                                    <option value="{{ $val->id }}"  @if(isset($_GET['sub_group_id']) && ($_GET['sub_group_id'] == $val->id)) selected="selected" @endif >{{ $val->id }} - {{ $val->department_name }}</option>
                                @endforeach
                            @endif
                        </select>
                    </div>
                    <div class="col-md-2">
                        Start Date
                        <input id="start_date" type="text" class="form-control" name="start_date" value="2026-06-15" autocomplete="off" required>
                    </div>
                    <div class="col-md-2">
                        End Date
                        <input id="end_date" type="text" class="form-control" name="end_date" value="2026-06-15" autocomplete="off" required>
                    </div>
                    <div class="col-md-2">
                        <br/> &nbsp;
                        <button type="submit" class="btn btn-success">Search</button>
                    </div>
                </div>
            </form>
          </div>
            <div class="clearfix">
                <p class="pull-right">
                    <span title="Print" class="btn btn-primary" onclick="printData('myTablePrint')"> <i class="glyphicon glyphicon-print"> </i> </span>
                    <span title="Download" class="btn btn-success" onclick="exportTableToExcel('myTablePrint')" > <i class="glyphicon glyphicon-download-alt"></i> </span>
                </p>
            </div>
            
            <div  id="myTablePrint" class="form-group mt-1" style="width:100%; overflow: scroll;" >
                <div class="col-sm-12 text-center">
                    @include('layouts.head')
                                        <h2><u>Group/Sub Group Wise Stock </u></h2>
                    <h5>{!! date('d-F-Y', strtotime($start_date)) !!} to {!! date('d-F-Y', strtotime($end_date)) !!} </h5>
                    <br>
                </div>

                
                @if (isset($product_list))
                    {{ $product_list->withPath('?'.$link) }} 
                @endif

               @if (isset($_GET['group_id']) && $_GET['group_id'] != "")
                                @php
                                    $selected_group = null;
                                    foreach ($group_info as $val) {
                                        if ($val->id == $_GET['group_id']) {
                                            $selected_group = $val;
                                            break;
                                        }
                                    }
                                @endphp
                                @if ($selected_group)
                                    <div style="float: left; height: 30px;"><b>Group Name: {{ $selected_group->values }} </b></div>
                                @endif
                            @elseif (isset($_GET['sub_group_id']) && $_GET['sub_group_id'] != "")
                                @php
                                    $selected_sub_group = null;
                                    foreach ($sub_group_info as $val) {
                                        if ($val->id == $_GET['sub_group_id']) {
                                            $selected_sub_group = $val;
                                            break;
                                        }
                                    }
                                @endphp
                                @if ($selected_sub_group)
                                    <div style="float: left; height: 30px;"><b>Sub Group Name : {{ $selected_sub_group->department_name }}</b></div>
                                @endif
                            @else
                                <div style="float: left; height: 30px;"><b>Group/Sub Group : All</b> </div>
                            @endif
                            <br>
                <table id="myTable" class="table table-striped table-hover mt-1">
                    <thead class="header" id="myHeader">
                    <tr>
                        <th> S.N.</th>
                        <th> ID </th>
                        <th> Item Name </th>
                        <th> Unit </th>
                        <th> Opening Qty</th>
                        <th> Purchase </th>
                        <th> Purchase Return </th>
                        <th> Sales </th>
                        <th> Sales Return</th>
                        <th> S.In </th>
                        <th> S.Out </th>
                        <th> Closing Qty</th>
                        @if (Auth::user()->parent_id == "0")
                        <th> Purchase Rate </th>
                        <th> Purchase Taka </th>
                        @endif
                        <th> Sales Rate </th>
                        <th> Sales Taka </th>
                    </tr>
                    </thead> 
                    <tbody>
                    @php $i=0; 

                        $TotalClosingOpeningTK = 0;
                        $TotalClosingReceivedTK = 0;
                        $TotalClosingPurReutrnTK = 0;
                        $TotalClosingSalesTK = 0;
                        $TotalClosingSinTK = 0;
                        $TotalClosingSoutTK = 0;
                        $TotalClosingReturnTK = 0;
                        $TotalClosingDpTK =0;
                        $TotalClosingTpTK =0;
                        $Purchase_Qty =0;
                        $Sales_Qty =0;
                    @endphp
                    @if(isset($product_list[0]))
                        @foreach($product_list as $row)
                            @php $i++;

                              $product_received = $row->product_received;
                              $purchase_return = $row->purchase_return;
                              $quantity = $row->product_sales;
                              $product_in = $row->product_in;
                              $product_out = $row->product_out;
                              $product_return = $row->product_return;

                              $Today_received = $row->today_received;
                              $Today_pur_return = $row->today_pur_return;
                              $Today_sales = $row->today_sales;
                              $Today_in = $row->today_in;
                              $Today_out = $row->today_out;
                              $Today_return = $row->today_return;

                              $Opening = ($product_received + $product_in + $product_return) - ($purchase_return + $quantity + $product_out);
                              
                              $Closing = ($Opening + $Today_received + $Today_in + $Today_return) - ($Today_pur_return + $Today_sales + $Today_out);
                              $ClosingPcs = $Closing * $row->pack_size;
                              //dd($row->pack_size);

                              $ClosingOpeningTK = $Opening * $row->dp_price;
                              $ClosingReceivedTK = $Today_received * $row->dp_price;
                              $ClosingPurReutrnTK = $Today_pur_return * $row->dp_price;
                              $ClosingSalesTK = $Today_sales * $row->tp_price;
                              $ClosingSinTK = $Today_in * $row->dp_price;
                              $ClosingSoutTK = $Today_out * $row->dp_price;
                              $ClosingReturnTK = $Today_return * $row->dp_price;

                              $Purchase_Qty = $row->Purchase_Qty;
                              $Sales_Qty = $row->Sales_Qty;

                               if($Purchase_Qty>0){
                                    $AvgPurchasePrice = $row->Purchase_Taka/$Purchase_Qty;
                                }else{
                                    $AvgPurchasePrice = $row->dp_price;
                                }
                                if($Sales_Qty>0){
                                    $AvgSalesPrice = $row->Sales_Taka/$Sales_Qty;
                                }else{
                                    $AvgSalesPrice = $row->tp_price;
                                }
                                //dd($ClosingPcs);
                                $ClosingPurchaseAvgTK = $Closing * $AvgPurchasePrice;
                                $ClosingSalesAvgTK = $Closing * $AvgSalesPrice;
                                //dd($ClosingPurchaseAvgTK);

                              $TotalClosingOpeningTK += $ClosingOpeningTK;
                              $TotalClosingReceivedTK += $ClosingReceivedTK;
                              $TotalClosingPurReutrnTK += $ClosingPurReutrnTK;
                              $TotalClosingSalesTK += $ClosingSalesTK;
                              $TotalClosingSinTK += $ClosingSinTK;
                              $TotalClosingSoutTK += $ClosingSoutTK;
                              $TotalClosingReturnTK += $ClosingReturnTK;

                              $TotalClosingDpTK += $ClosingPurchaseAvgTK;
                              $TotalClosingTpTK += $ClosingSalesAvgTK;

                            @endphp
                            <tr>
                                <td>{{$i}}</td>
                                <td>{{$row->id}}</td>
                                <td>{{$row->product_name}}</td>
                                <td>{{$row->pack_type}}</td>
                                <td>{{ number_format($Opening,2)}}</td>
                                <td>{{ number_format($Today_received,2)}}</td>
                                <td>{{ number_format($Today_pur_return,2)}}</td>
                                <td>{{ number_format($Today_sales,2)}}</td>
                                <td>{{ number_format($Today_return,2)}}</td>
                                <td>{{ number_format($Today_in,2)}}</td>
                                <td>{{ number_format($Today_out,2)}}</td>
                                <td>{{ number_format($Closing,2)}}</td>
                                @if (Auth::user()->parent_id == "0")
                                <td>{{ number_format($AvgPurchasePrice,2)}}</td>
                                <td>{{ number_format($ClosingPurchaseAvgTK,2)}}</td>
                                @endif
                                <td>{{ number_format($AvgSalesPrice,2)}}</td>
                                <td>{{ number_format($ClosingSalesAvgTK,2)}}</td>
                            </tr>
                        @endforeach
                        <tr>
                            <th colspan="4"> Total Taka = </th>
                            <th>{{ number_format($TotalClosingOpeningTK,2) }}</th>
                            <th>{{ number_format($TotalClosingReceivedTK,2) }}</th>
                            <th>{{ number_format($TotalClosingPurReutrnTK,2) }}</th>
                            <th>{{ number_format($TotalClosingSalesTK,2) }}</th>
                            <th>{{ number_format($TotalClosingReturnTK,2) }}</th>
                            <th>{{ number_format($TotalClosingSinTK,2) }}</th>
                            <th>{{ number_format($TotalClosingSoutTK,2) }}</th>
                            <th></th>
                            @if (Auth::user()->parent_id == "0")
                            <th></th>
                            <th>{{ number_format($TotalClosingDpTK,2) }}</th>
                            @endif
                            <th></th>
                            <th>{{ number_format($TotalClosingTpTK,2) }}</th>
                        </tr>
                    @endif
                    </tbody>
                </table>

                {{ $product_list->withPath('?'.$link) }}
              </div>
            </div>
        </div>
    </div>
<style>
    table#myTable thead#myHeader { background: #D9E5D8; color: #006C32; }
    div#myTablePrint table#myTable tbody tr td {  border: 1px solid; border-collapse: collapse; text-align: left; height: 28px; font-size: 15px;}
    div#myTablePrint table#myTable thead#myHeader tr th {border-collapse: collapse; border: 1px solid #000000!important;}
    div#myTablePrint table#myTable tbody tr th{border-collapse: collapse; border: 1px solid #000000!important; }
    thead th {border-collapse: collapse; border-right: 1px solid #000000 !important; text-align: center;}
    .requisitionmas.alert.alert-info { margin-top: 35px; }
    table#myTable thead#myHeader{
            position: sticky;
            top: 0;
            /* width: 109%; */
            background: #D9E5D8;
        }
</style>

    <script>

        function resetOption(param1, param2){
            document.getElementById(param1).value = "";
            $('#' + param1).selectpicker('refresh');
            document.getElementById(param2).value = "";
            $('#' + param2).selectpicker('refresh');
        }
        function printData() {
            var print_ = document.getElementById("myTablePrint");
            win = window.open("");
            win.document.write(print_.outerHTML);

            win.document.write('<style type="text/css">');
            
            win.document.write('.col-sm-12.text-center h2, .col-sm-12.text-center h4, .col-sm-12.text-center h5 { text-align: center; margin: 0; }');
            win.document.write('.col-sm-12.text-center h2 { font-size: 24px; }');
            win.document.write('.col-sm-12.text-center h4 { font-size: 18px; }');
            win.document.write('.col-sm-12.text-center.printlogo { text-align: center; }');

            win.document.write('#myTablePrint table { width: 100%; border-collapse: collapse; font-family: Arial, sans-serif; }');
            win.document.write('#myTablePrint table#myTable thead tr th { font-weight: bold; border: 1px solid #000000!important; font-size: 14px; padding: 8px; text-align: center; }');
            win.document.write('#myTablePrint table#myTable tbody tr td { text-align: center; height: 20px; border: 1px solid #000000!important; font-size: 14px; font-weight: bold; padding: 5px; }');
            win.document.write('#myTablePrint table#myTable tbody tr th { text-align: center; height: 20px; border: 1px solid #000000!important; font-size: 14px; font-weight: bold; padding: 5px;}');
            win.document.write('#myTablePrint table tbody .leftsidenobox tr td { border: none; padding: 5px; }');

            win.document.write('#myTablePrint table tfoot tr th { font-weight: normal; text-align: center; font-size: 12px; padding: 5px; }');
            win.document.write('#myTablePrint table tfoot tr td { font-size: 12px; font-weight: normal; padding: 5px; text-align: left; }');
            win.document.write('#myTablePrint table tfoot tr th:last-child { font-size: 10px; font-style: italic; }');

            win.document.write('#myTablePrint table tfoot tr td { font-weight: bold; font-size: 14px; }');
            win.document.write('#myTablePrint table tfoot tr th, #myTablePrint table tfoot tr td { padding: 10px 5px; }');
            
            win.document.write('#myTablePrint table tfoot tr td b { font-size: 14px; font-weight: normal; }');
            win.document.write('#myTablePrint table tfoot tr td { font-size: 14px; padding-left: 5px; padding-right: 5px; text-align: left;}');

            win.document.write('body { margin: 20px; padding: 10px; font-family: Arial, sans-serif; }');
            win.document.write('table { border-collapse: collapse; }');

            win.document.write('.col-sm-12.text-center img { width: 15%; }');
            

            win.document.write('</style>');

            win.print();
            win.close();
        }


        function exportTableToExcel(tableID, filename = '',report_header='')
          {
              var downloadLink;
              var dataType = 'application/vnd.ms-excel';
              var tableSelect = document.getElementById(tableID);
              var tableHTML = '';

              if(report_header!='')
              {
                  tableHTML = $("#"+report_header).html();
              } else {
                  tableHTML = '';
              }

              tableHTML = tableHTML + tableSelect.outerHTML.replace(/ /g, '%20');

              // Specify file name
              filename = filename?filename+'.xls':'excel_data.xls';

              // Create download link element
              downloadLink = document.createElement("a");

              document.body.appendChild(downloadLink);

              if(navigator.msSaveOrOpenBlob){
                  var blob = new Blob(['\ufeff', tableHTML], {
                      type: dataType
                  });
                  navigator.msSaveOrOpenBlob( blob, filename);
              }else{
                  // Create a link to the file
                  downloadLink.href = 'data:' + dataType + ', ' + tableHTML;

                  // Setting the file name
                  downloadLink.download = filename;

                  //triggering the function
                  downloadLink.click();
              }
          }
        function valueReset() {
                location.href = "http://localhost/store/public/dailysummaryreport";
            }

            $(window).scroll(function() {
            var scroll = $(window).scrollTop();

            if (scroll >= 100) {
                $("table#myTable").addClass("fixedHeader");
            } else {
                $("table#myTable").removeClass("fixedHeader");
            }
        });
        jQuery( function($) {
            $( "#start_date" ).datepicker( { dateFormat: "yy-mm-dd" } );
            $( "#end_date" ).datepicker( { dateFormat: "yy-mm-dd" } );
        } );

        
    </script>
@endsection