@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, ['class' => 'form-control select2 bussines_type']); !!}
                    </div>
                </div>
                <div class="col-sm-3"  id="location_input">
                    <div class="form-group">
                        {!! Form::label('location_id', __('sale.location') . ':*') !!}
                        {!! Form::select('location_id', $locations, null, ['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;">
              
                  
                </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(V)</th>
                <th>Profit(%)</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_value"></td>
                <td class="footer_total_profit_percent"></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/user-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;
  
//    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 = parseFloat(row.cost_price);
    return cost_price.toFixed(2);
}
},
{
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_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 
}
},
{
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 
}
},
],
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