@extends('layouts.master')
@section('styles')

@endsection
@section('content')
    <style>
    .topstats {
      margin-top: 10px;
      font-size: 13px;
      margin-bottom: -5px;
    }

    .topstats .gary-box {
      line-height: 1;
      background-color: #f9f9f9;
      border-bottom: solid 1px #d1d1d1;
      padding: 10px;
    }

    .no-wrap{
        white-space: nowrap !important;
    }
    .topstats .gary-box span {
      font-family: 'Rationale', sans-serif;
      color: #0038ba;
      font-size: 20px;
      float: right;
      margin-top: -4px;
    }



    .dis-slab-card{font-size: 13px; margin:0;}
    .dis-input{font-size: 13px; border: solid 1px #E8E8E8; width: 240px; height: 25px; padding-left:8px}
    .dis-input:focus{border: solid 1px #0038BA}
    .topsec{background-color: #F7F7F7; font-size: 14px; line-height: 25px; padding: 5px 0px; margin:0; border-bottom:solid 1px #0038BA; cursor: pointer}
    .topsec i{float:right; font-size:18px; line-height:25px; color:#a4a4a4}
    .bottomsec{background-color:#ededed;padding: 10px 15px;}
    .dis-slab-card .btn-primary{font-size: 13px; padding: 5px 12px; line-height:1; box-shadow: none;}
    .dis-slab-card .red-bg{border-color: #F12300; box-shadow: none;}
    .dis-slab-card .add-slab-btn{font-size: 14px; padding:5px 12px; height: 28px; letter-spacing: 1px; margin-left:10px;}
    .criteria-sh{padding-top: 10px; padding-bottom: 10px; border:solid 1px #F1F1F1; background-color: #F9F9F9 }
    .criteria-sh strong{padding-right: 10px;}

    .dt-buttons .dt-button {
        background: #003db6;
        border: none;
        color: #fff;
        outline: none;
        padding: 8px 14px;
        line-height: 1;
        font-size: 13px;
    }
  </style>
    <div class="row mt-2 mb-3">
        <div class="col-lg-6 col-md-6 col-sm-6">
            <h2 class="_head01">Report <span> Management</span></h2>
        </div>

        <div class="col-lg-6 col-md-6 col-sm-6">
            <ol class="breadcrumb">
                <li><a href="#"><span>Report</span></a></li>
                <li><span>List</span></li>
            </ol>
        </div>
    </div>

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

                <div class="header">
                    <h2>Distributor Wise Product Sales <span> Report</span></h2>
                </div>
                <div class="body body_table">
                    <div class="col-md-12 p-0">
                        <div class="table-wrap">
                            <table class="table table-hover display pb-30" style="width:100%;" id="data-table" style="">
                                <thead>
                                    <tr>
                                        <th>SKU</th>
                                        <th>Product</th>
                                        <th>Brand</th>
                                        <th>Jan</th>
                                        <th>Feb</th>
                                        <th>Mar</th>
                                        <th>Apr</th>
                                        <th>May</th>
                                        <th>Jun</th>
                                        <th>Jul</th>
                                        <th>Aug</th>
                                        <th>Sep</th>
                                        <th>Oct</th>
                                        <th>Nov</th>
                                        <th>Dec</th>
                                    </tr>
                                </thead>
                                <tbody>
                                @if (collect($data)->count()>0)
                                    @foreach (collect($data) as $item)
                                        <tr>
                                            <td>{{$item->item_sku}}</td>
                                            <td>{{$item->item_name}}</td>
                                            <td>{{$item->brand_name}}</td>
                                            <td>{{(isset($item->jan))? $item->jan:0}}</td>
                                            <td>{{(isset($item->feb))? $item->feb:0}}</td>
                                            <td>{{(isset($item->mar))? $item->mar:0}}</td>
                                            <td>{{(isset($item->apr))? $item->apr:0}}</td>
                                            <td>{{(isset($item->my))? $item->may:0}}</td>
                                            <td>{{(isset($item->jun))? $item->jun:0}}</td>
                                            <td>{{(isset($item->jul))? $item->jul:0}}</td>
                                            <td>{{(isset($item->aug))? $item->aug:0}}</td>
                                            <td>{{(isset($item->sep))? $item->sep:0}}</td>
                                            <td>{{(isset($item->oct))? $item->oct:0}}</td>
                                            <td>{{(isset($item->nov))? $item->nov:0}}</td>
                                            <td>{{(isset($item->dec))? $item->dec:0}}</td>

                                        </tr>
                                    @endforeach
                                @endif
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection

@section('scripts')
    <script>
        $("#table-th thead th").addClass("no-wrap");

        $('#data-table').DataTable({
            dom: 'Bfrtip',
            buttons: [
                {
                    extend: 'pdfHtml5',
                    title: 'Product Sales Report Distributor Wise',
                    orientation: 'landscape',

                    customize: function (doc) {
                        // doc.styles.tableBodyOdd.fillColor = "#FFA07A";
                        doc.styles.tableHeader.fillColor = "#F9F9F9";
                        doc.styles.tableFooter.fillColor = "#F9F9F9";
                        doc.styles.tableHeader.color = "black";
                        doc.styles.tableHeader.alignment = "left";
                        doc.styles.title.alignment = "left";
                        doc.content[1].table.widths = ['*', 'auto', '*', 'auto', 'auto', 'auto', 'auto', 'auto', 'auto', 'auto', 'auto', 'auto', 'auto', 'auto', 'auto'];
                        //cell border
                        var objLayout = {};
                        objLayout['hLineWidth'] = function (i) { return 0.5; };
                        objLayout['vLineWidth'] = function (i) { return 0.5; };
                        objLayout['hLineColor'] = function (i) { return '#F2F2F2'; };
                        objLayout['vLineColor'] = function (i) { return '#F2F2F2'; };
                        objLayout['paddingLeft'] = function (i) { return 4; };
                        objLayout['paddingRight'] = function (i) { return 4; };
                        objLayout['paddingTop'] = function (i) { return 4; };
                        objLayout['paddingBottom'] = function (i) { return 4; };
                        doc.content[1].layout = objLayout;
                        //cell border
                    }
                },
                {
                    extend: 'excel',
                    text: 'Excel',
                    title: 'Product Sales Report Distributor Wise',
                    customize: function (xlsx) {
                        var sheet = xlsx.xl.worksheets['sheet1.xml'];
                        $('column', sheet).attr('s', '55');
                    },
                    columnDefs: [
                        {
                            "targets": 0, // your case first column
                            "className": "text-left",
                            "width": "40%"
                        },
                        {
                            "targets": 1,
                            "className": "text-left",
                        }],
                },
                {
                    extend: 'print',
                    text: 'Print',
                    title: 'Product Sales Report Distributor Wise',

                },
                {
                    extend: 'copy',
                    text: 'Copy',
                    title: 'Product Sales Report Distributor Wise',

                }
            ]
        });
    </script>
@endsection