@extends('layouts.app')
@section('title', __('Profit-Margin Report'))
@section('content')
<!-- Content Header (Page header) -->
<section class="content-header">
    <h1>Profit Margin Report</h1>
</section>
<style>
    select,
    .select2-container {
        width: 100% !important;
    }

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

    .margin-right-10 {
        margin-right: 10px;
    }
    .ml-3{
        margin-left: 30px;
    }
    .pr-5px{
        margin-right: 5px;
    }
</style>
<!-- Main content -->
<section class="content">
    <div class="box">
        {!! Form::open(['url' => action([\App\Http\Controllers\ChannelPartnerDiscountController::class, 'ProfitMarginexport']), 'method' => 'post', 'id' => 'add_discount_mangement_form', 'files' => true ]) !!}

        <div class="box-body">
            @can('brand.view')
            <div class="row">

                <div class="col-md-3">
                    <div class="form-group">
                        {!! Form::label('list_filter_date_range', __('report.date_range') . ':') !!}
                        {!! Form::text('list_filter_date_range', null, ['placeholder' => __('lang_v1.select_a_date_range'), 'class' => 'form-control', 'readonly']); !!}
                    </div>

                </div>
                <div class="col-sm-3">
                    <div class="form-group">
                        {!! Form::label('bussines_type', 'Report For:*') !!}
                        {!! Form::select('bussines_type', $bussines_type, null, ['placeholder' => __('All'), 'class' => 'form-control select2 bussines_type']); !!}
                    </div>
                </div>
                <div class="col-sm-3"  id="location_input" style="display:none;">
                    <div class="form-group">
                        {!! Form::label('location_id', __('sale.location') . ':*') !!}
                        {!! Form::select('location_id', $locations, null, ['placeholder' => __('Select Location'), 'class' => 'form-control select2 location_id']); !!}
                    </div>
                </div>

                <div class="col-sm-3">
                    <div class="form-group">
                        {!! Form::label('location_id', 'Discount On:*') !!}
                        {!! Form::select('discount_on', $discount_on, null, ['placeholder' => __('messages.please_select'), 'class' => 'form-control discount_on select2']); !!}
                    </div>
                </div>

               
                <div class="col-sm-3" id="category_input" style="display: none">
                    <div class="form-group">
                        {!! Form::label('category_id', __('product.category') . ':') !!}
                        {!! Form::select('category_id', $categories, null, ['placeholder' => __('messages.please_select'), 'class' => 'form-control category_id select2']); !!}
                    </div>
                </div>

                <div class="col-sm-3" id="brand_input">
                    <div class="form-group">
                        {!! Form::label('brand_id', __('product.brand') . ':') !!}
                        {!! Form::select('brand_id', $brands, null, ['placeholder' => __('messages.please_select'), 'class' => 'form-control brand_id select2']); !!}
                    </div>
                </div>
                <div class="col-sm-3" id="supplier_input" style="display: none">
                    <div class="form-group">
                        {!! Form::label('supplier_id', 'Supplier:') !!}
                        {!! Form::select('supplier_id', $suppliers, null, ['placeholder' => __('messages.please_select'), 'class' => 'form-control supplier_id select2']); !!}
                    </div>
                </div>
                <div class="col-sm-6" style="margin-top: 25px;">
                <label class="btn-outline-success" for="reportType1">
                  <input type="radio" class="btn-check pr-5px" name="reportType" id="reportType1" autocomplete="off" value="company" checked>
                   For Company</label>

                    <label class="btn-outline-success ml-3" for="reportType">
                    <input type="radio" class="btn-check pr-5px" name="reportType" id="reportType" autocomplete="off" value="individual">
                    Individual</label>
                  
                </div>


            </div>
            @endcan
            <div class="clearfix"></div>

        </div>
    </div>
    <div class="row">
        <div class="col-md-12">
            <!-- Custom Tabs -->
            <div class="nav-tabs-custom">
                <div class="row">
                    <div class="col-md-8">
                        <ul class="nav nav-tabs">
                            <li class="active">
                                <a href="#output_tax_tab" data-toggle="tab" aria-expanded="true"><i class="fa fas fa-arrow-circle-up" aria-hidden="true"></i> Profit-Margin </a>
                            </li>

                        </ul>
                    </div>


                    <div class="col-md-2 mt-10px">
                        <input type="hidden" name="download_type" id="download_type">
                        {{-- <a class="btn btn-success pull-right margin-right-10 float-right margin-bottom-12" href="{{action([\App\Http\Controllers\ChannelPartnerDiscountController::class, 'downloadChannelPartnerDiscountExcel'])}}"><i class="fa fa-download"></i> @lang('lang_v1.download_excel')</a> -->
                        <button class="btn btn-success pull-right margin-right-10 float-right margin-bottom-12" id="downloadExcelBtn"><i class="fa fa-download"></i> @lang('lang_v1.download_excel')</button>---}}
                        <button type="button" class="btn btn-success pull-right float-right margin-bottom-12" id="downloadExcel"><i class="fa fa-download"></i>Download Excel</button>

                        {!! Form::close() !!}
                    </div>
                    <div class="col-md-2 mt-10px">

                        <!-- <a class="btn btn-info pull-right float-right margin-bottom-12" href="{{ url('/channel-partner-discounts/export-pdf') }}"> <i class="fa fa-download"></i>Download PDF</a> -->
                        <button type="button" class="btn btn-info pull-right float-right margin-bottom-12" id="downloadpdf"><i class="fa fa-download"></i>Download PDF</button>


                    </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="channel_partner_discount_table" style="width: 100%;">
                            <thead>
                                <tr>
                                    <th>SNO</th>

                                    <th>@lang('product.sku')</th>
                                    <th width="300">@lang('sale.product')</th>
                                    <th>Cost Price</th>
                                    <th>MRP</th>
                                    <th>Disc(%)</th>
                                    <th>Disc(V)</th>
                                    <th>@lang('lang_v1.selling_price')</th>
                                    
                                    <th>Profit(%)</th>
                                    <th>Profit(V)</th>
                                </tr>
                            </thead>
                            <tfoot>
                                <tr class="bg-gray font-17 text-center footer-total">
                                    <td colspan="3"><strong>@lang('sale.total'):</strong></td>
                                    <td class="footer_total_cost_price"></td>
                                    <td class="footer_total_product_mrp"></td>
                                    <td class="footer_total_discount_amount"></td>
                                    <td class="footer_total_discount_value"></td>
                                    <td class="footer_total_selling_price"></td>
                                    <td class="footer_total_profit_percent"></td>
                                    <td class="footer_total_profit_value"></td>
                                   

                                </tr>
                            </tfoot>
                        </table>
                    </div>

                </div>
            </div>
        </div>
    </div>
    @include('channel-partner-discount.email-modal')
</section>
@stop
@section('javascript')
<script>
    $(document).ready(function() {

        $('.bulk_discount_date').datetimepicker({
            format: moment_date_format + ' ' + moment_time_format,
            ignoreReadonly: true,
        });
        $('.discount_on').on("select2:select", function(e) {
            var discount_on = $(this).val();
            if (discount_on == 1) {
                $("#brand_input").show();
                $("#category_input").hide();
                $("#supplier_input").hide();
                $(".category_id").val('').trigger('change');
                $(".supplier_id").val('').trigger('change');
            } else if (discount_on == 2) {
                $("#category_input").show();
                $("#brand_input").hide();
                $("#supplier_input").hide();
                $(".brand_id").val('').trigger('change');
                $(".supplier_id").val('').trigger('change');
            } else if (discount_on == 3) {
                $("#supplier_input").show();
                $("#category_input").hide();
                $("#brand_input").hide();
                $(".brand_id").val('').trigger('change');
                $(".category_id").val('').trigger('change');
            } else {
                $("#brand_input").show();
                $("#supplier_input").hide();
                $("#category_input").hide();
                $(".category_id").val('').trigger('change');
                $(".supplier_id").val('').trigger('change');
            }
        });

    });

    function advanceDiscount(discount) {
        if (discount <= 100) {
            discount = 1 + discount * 0.01;
        } else if (discount > 100 && discount <= 200) {
            discount = 2 + (discount - 100) * 0.01;
        } else if (discount > 200 && discount <= 300) {
            discount = 3 + (discount - 200) * 0.01;
        } else if (discount > 300 && discount <= 400) {
            discount = 4 + (discount - 300) * 0.01;
        } else if (discount > 400 && discount <= 500) {
            discount = 5 + (discount - 400) * 0.01;
        } else if (discount > 500 && discount <= 600) {
            discount = 6 + (discount - 500) * 0.01;
        } else if (discount > 600 && discount <= 700) {
            discount = 7 + (discount - 600) * 0.01;
        } else if (discount > 700 && discount <= 800) {
            discount = 8 + (discount - 700) * 0.01;
        } else if (discount > 800 && discount <= 900) {
            discount = 9 + (discount - 800) * 0.01;
        }
        return discount;
    }


    //     function listofchannel() {

    //         // console.log(bussines_type);
    //         var startDate = $("#starts_at").val();
    //         var endDate = $("#ends_at").val();
    //         var bussiness_type = $('#bussines_type').val();
    //         var location_id = $('#location_id').val();
    //         var discount_on = $('.discount_on').val();
    //         var from_date = moment(startDate).format('YYYY-MM-DD'); // Using moment.js for date formatting
    //         var to_date = moment(endDate).format('YYYY-MM-DD');
    //         $.ajax({
    //             url: '/channel-partner-discounts/show',
    //             type: 'GET',
    //             data: {
    //                 bussiness_type: bussiness_type,
    //                 location_id: location_id,
    //                 discount_on: discount_on,
    //                 // from_date:from_date,
    //                 //   to_date:to_date
    //             },
    //             success: function(data) {
    //                 console.log(data);

    //             }
    //         });
    //  }

    $('#list_filter_date_range').daterangepicker(
        dateRangeSettings,
        function(start, end) {
            $('#list_filter_date_range').val(start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format));
            channel_partner_discount_table.ajax.reload();
        }
    );
    $('#list_filter_date_range').on('cancel.daterangepicker', function(ev, picker) {
        $('#list_filter_date_range').val('');
        channel_partner_discount_table.ajax.reload();
    });

    $('#list_filter_date_range,#bussines_type ,#location_id, .discount_on, #brand_id, #category_id, #supplier_id').change(function() {
        channel_partner_discount_table.ajax.reload();

    });
    $(document).ready(function() {

        $('input[name="daterange"]').daterangepicker({
            // startDate: moment().subtract(1, 'M'),
            startDate: moment().startOf('month'),
            endDate: moment(),

        });
        var datetime = $("#list_filter_date_range").val();
        $("#pdf_datetime").val(datetime);
        channel_partner_discount_table = $('#channel_partner_discount_table').DataTable({
            "scrollX": true,
            processing: true,
            serverSide: true,
            aaSorting: [
                [0, 'desc']
            ],
            ajax: {
                url: '/reports/profit-margin',
                "data": function(d) {
                    d.bussiness_type = $('#bussines_type').val();
                    d.location_id = $('#location_id').val();
                    d.discount_on = $('.discount_on').val();
                    d.brand_id = $("#brand_id").val();
                    d.category_id = $("#category_id").val();
                    d.supplier_id = $("#supplier_id").val();
                    if ($('#list_filter_date_range').val()) {
                        var start = $('input#list_filter_date_range')
                            .data('daterangepicker')
                            .startDate.format('YYYY-MM-DD');
                        var end = $('input#list_filter_date_range')
                            .data('daterangepicker')
                            .endDate.format('YYYY-MM-DD');
                        d.start_date = start;
                        d.end_date = end;
                        d.reportType=$('input[name="reportType"]:checked').val();
                    //    console.log($('input[name="reportType"]:checked').val());
                    }
                    return __datatable_ajax_callback(d);

                }
            },
            columns: [{
                    data: 'DT_Row_Index',
                    name: 'DT_Row_Index',
                    orderable: false,
                    searchable: false
                },

                {
                    data: 'sub_sku',
                    name: 'sub_sku',
                },
                {
                    data: 'product',
                    name: 'product',
                },
                {
                    data: 'cost_price',
                    name: 'cost_price',
                    render: function(data, type, row) {
                        var cost_price = row.cost_price;
                        return cost_price;
                    }
                },
                {
                    data: 'product_mrp',
                    name: 'product_mrp',
                    render: function(data, type, row) {
                        var product_mrp = parseFloat(row.product_mrp);
                        return product_mrp.toFixed(2);
                    }
                },

                {
                    data: 'discount_amount',
                    name: 'discount_amount',
                    render: function(data, type, row) {
                        var discount_amount =parseFloat(row.discount_amount);
                        return discount_amount.toFixed(2); // Fix to 
                    }
                },
                {
                    data: 'discount_value',
                    name: 'discount_value',
                    render: function(data, type, row) {
                        var discount_value =parseFloat(row.discount_value);
                        return discount_value.toFixed(2); // Fix to 
                    }
                },
                {
                    data: 'sell_price_inc_tax',
                    name: 'sell_price_inc_tax',
                    render: function(data, type, row) {
                        var selling_price = parseFloat(row.product_mrp - row.discount_value);
                        return selling_price.toFixed(2); // Fix to 
                    }
                },
                {
                    data: 'profit_percent',
                    name: 'profit_percent',
                    render: function(data, type, row) {
                        var selling_price = parseFloat(row.product_mrp - row.discount_value);

                        var profit_percent = ((selling_price - row.cost_price) / selling_price) * 100;
                        return profit_percent.toFixed(2); // Fix to 
                    }
                },
                {
                    data: 'profit_value',
                    name: 'profit_value',
                    render: function(data, type, row) {
                        var selling_price = parseFloat(row.product_mrp - row.discount_value);

                        var profit_value = (selling_price - row.cost_price);
                        return profit_value.toFixed(2); // Fix to 
                    }
                },

            ],
            fnDrawCallback: function(oSettings) {
                __currency_convert_recursively($('#channel_partner_discount_table'));
            },
            "footerCallback": function(row, data, start, end, display) {
                var footer_total_cost_price = 0;
                var footer_total_product_mrp = 0;
                var footer_total_discount_amount = 0;
                var footer_total_discount_value = 0;
                var footer_total_selling_price = 0;
                var footer_total_profit_percent = 0;
                var footer_total_profit_value = 0;



                for (var i = 0; i < data.length; i++) {
                    footer_total_cost_price += parseFloat(data[i].cost_price) || 0;
                    footer_total_product_mrp += parseFloat(data[i].product_mrp) || 0;
                    footer_total_discount_amount += parseFloat(data[i].discount_amount) || 0;
                    footer_total_discount_value += parseFloat(data[i].discount_value) || 0;
                    var selling_price = data[i].sell_price_inc_tax - data[i].discount_value;
                    footer_total_selling_price += parseFloat(selling_price) || 0;
                    footer_total_profit_percent += parseFloat(data[i].profit_percent) || 0;
                    footer_total_profit_value += parseFloat(data[i].profit_value) || 0;
                }
              var total_profit_value=footer_total_selling_price-footer_total_cost_price;
              var total_profit_percent=(total_profit_value / footer_total_selling_price)*100;
               // var total_profit_value=(total_profit_value/)
                $('.footer_total_cost_price').html(__currency_trans_from_en(footer_total_cost_price, false));
                $('.footer_total_product_mrp').html(__currency_trans_from_en(footer_total_product_mrp, false));
                $('.footer_total_discount_amount').html((footer_total_discount_amount / data.length).toFixed(2) + '%');
                $('.footer_total_discount_value').html(__currency_trans_from_en(footer_total_discount_value, false));
                $('.footer_total_selling_price').html(__currency_trans_from_en(footer_total_selling_price, false));
                //   $('.footer_total_profit_percent').html(__currency_trans_from_en(footer_total_profit_percent, false));
                $('.footer_total_profit_percent').html((total_profit_percent).toFixed(2) + '%'); // Show profit value as a percentage

                $('.footer_total_profit_value').html(__currency_trans_from_en(total_profit_value, false));
            }
        });

    });



    $("#downloadExcel").click(function() {
        $("#download_type").val('excel');
        document.getElementById('add_discount_mangement_form').submit();
    });
    $("#downloadpdf").click(function() {
        $("#download_type").val('pdf');
        document.getElementById('add_discount_mangement_form').submit();
    });

    // jQuery

  $('input[name="reportType"]').on('change', function() {
    var selectedValue = $(this).val();
    if (selectedValue === 'company') {
      // code to execute when "For Company" is selected
      $("#location_input").hide();

    } else if (selectedValue === 'individual') {
      // code to execute when "Individual" is selected

      $("#location_input").show();
    }
    channel_partner_discount_table.ajax.reload();
  });

  $('#bussines_type').change(function() {
      var bussines_type = $(this).val();
      if(bussines_type==''){
     var   bussines_type='All'
      }
//   console.log(bussines_type);
      if(bussines_type=='prime_member'){
             $("#bulk_dis_label").text('Prime Discounts :'); 
             $("#savings_cal").text('Calculate Prime Savings');
      }else{
        $("#bulk_dis_label").text('Discounts :'); 
        $("#savings_cal").text('Calculate Savings');
      }
      if (bussines_type) {
        $.ajax({
          url: '{{ route("business-location-dropdown-by-location-type") }}',
          type: 'GET',
          data: {
            bussines_type: bussines_type
          },
          success: function(data) {
            // console.log(data);
            $('#location_id').empty();
            $('#location_id').append('<option value="">Select Location</option>');
            $.each(data, function(key, value) {
              $('#location_id').append('<option value="' + value.id + '">' + value.name + '( ' + value.location_id + ' ) </option>');
            });
          }
        });
      } else {
        $('#location_id').empty();
        $('#location_id').append('<option value="">Please Select</option>');
      }
    });

    // Excel Export
    // $("#downloadPdfBtn").click(function() {
    //     var bussiness_type = $('#bussines_type').val();

    //     var location_id = $('#location_id').val();
    //     var discount_on = $('.discount_on').val();
    //     var brand_id = $("#brand_id").val();
    //     var category_id = $("#category_id").val();
    //     var supplier_id = $("#supplier_id").val();

    //     var start, end;
    //     console.log('aAdsas');
    //     if ($('#list_filter_date_range').val()) {
    //         start = $('input#list_filter_date_range')
    //             .data('daterangepicker')
    //             .startDate.format('YYYY-MM-DD');
    //         end = $('input#list_filter_date_range')
    //             .data('daterangepicker')
    //             .endDate.format('YYYY-MM-DD');
    //     }

    //     $.ajax({
    //         url: '/channel-partner-discounts/export-pdf', // Replace with your server URL
    //         type: 'POST', // HTTP method (GET, POST, etc.)

    //         data: {
    //             bussiness_type: bussiness_type,
    //             location_id: location_id,
    //             discount_on: discount_on,
    //             brand_id: brand_id,
    //             category_id: category_id,
    //             supplier_id: supplier_id,
    //             start_date: start,
    //             end_date: end
    //         },
    //         success: function(response) {
    //             var blob=new Blob([response]);
    //             var link=document.createElement('a');
    //             link.setAttribute('target','_blank');
    //             link.href=window.URL.createObjectURL(blob);
    //             link.download="PreviewProposalAsPdf.pdf";
    //             link.click(); 
    //         },
    //         error: function(xhr, status, error) {
    //             // Handle error
    //             console.error("AJAX Error: ", status, error);
    //             $("#result").html("An error occurred: " + status + " " + error);
    //         }
    //     });
    //   });
</script>
@endsection