@extends('layouts.app')
@section('title', 'Products Final Report')

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1>@lang('sale.products')
        <small>@lang('lang_v1.manage_products')</small>
    </h1>
    <!-- <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Level</a></li>
        <li class="active">Here</li>
    </ol> -->
</section>

<!-- Main content -->
<section class="content">
<div class="row">
    <div class="col-md-12">
    @component('components.filters', ['title' => __('report.filters')])
    {!! Form::open(['url' => action([\App\Http\Controllers\ReportController::class, 'getProductDiscountDownload']), 'method' => 'post', 'files' => true ]) !!}
        <div class="col-md-2">
            <div class="form-group">
                {!! Form::label('category_id', __('product.category') . ':') !!}
                {!! Form::select('category_id', $categories, null, ['class' => 'form-control select2', 'style' => 'width:100%', 'id' => 'product_list_filter_category_id', 'placeholder' => __('lang_v1.all')]); !!}
            </div>
        </div>
        <div class="col-md-2">
            <div class="form-group">
                {!! Form::label('brand_id', __('product.brand') . ':') !!}
                {!! Form::select('brand_id', $brands, null, ['class' => 'form-control select2', 'style' => 'width:100%', 'id' => 'product_list_filter_brand_id', 'placeholder' => __('lang_v1.all')]); !!}
            </div>
        </div>
       {{-- <div class="col-md-3">
            <div class="form-group">
                {!! Form::label('based_on', 'Based On') !!}
                @php
                    $basedOn = array(
                        '0' => 'Select All',
                        '1' => 'Customer Dis %',
                        '2' => 'Customer Profit %',
                        '3' => 'Customer Profit INR',
                        '4' => 'Canteen Dis %',
                        '5' => 'Canteen Profit %',
                        '6' => 'Canteen Profit INR',
                        '7' => 'Wholesale Dis %',
                        '8' => 'Wholesale Profit %',
                        '9' => 'Wholesale Profit INR',

                    );
                @endphp
                {!! Form::select('based_on', $basedOn, null, ['class' => 'form-control select2', 'id' => 'product_list_filter_based_id', 'style' => 'width:100%']); !!}
            </div>
        </div>--}}
        {{--  <div class="col-md-2">
            <div class="form-group">
                {!! Form::label('based_on_can', 'Based On Cant Offer') !!}
                {!! Form::select('based_on_can', ['0' => 'All', '1' => 'Net Margin', '2' => 'Profit Margin', '3' => 'Discount'], null, ['class' => 'form-control select2', 'id' => 'product_list_filter_based_can_id', 'style' => 'width:100%']); !!}
            </div>
        </div>  --}}
       {{--<div class="col-md-2">
            <div class="form-group">
                {!! Form::label('min_dis', 'Min:') !!}
                {!! Form::text('min_dis', null, ['class' => 'form-control', 'id' => 'product_list_min_id', 'placeholder' => 0]); !!}
            </div>
        </div>
        <div class="col-md-2">
            <div class="form-group">
                {!! Form::label('max_dis', 'Max:') !!}
                {!! Form::text('max_dis', null, ['class' => 'form-control', 'id' => 'product_list_max_id', 'placeholder' => 0]); !!}
            </div>
        </div>--}}
        {{--  <div class="col-md-2">
            <div class="form-group">
                <label class="text-white">h</label>
                {{ Form::button('<i class="fa fa-download" aria-hidden="true"></i> Download Excel', ['class' => 'btn btn-success pull-right', 'type' => 'submit']) }}
                {{--  {!! Form::submit('Download Excel', ['class' => 'form-control btn btn-success pull-right <i class="fa fa-download"></i> margin-left-10 ', '']) !!}  --}}
            {{--  </div>
        </div>  --}}
        {!! Form::close() !!}
    @endcomponent
    </div>
</div>
@can('product.view')
    <div class="row">
        <div class="col-md-12">
           <!-- Custom Tabs -->
            <div class="nav-tabs-custom">
                <ul class="nav nav-tabs">
                    <li class="active">
                        <a href="#product_list_tab" data-toggle="tab" aria-expanded="true"><i class="fa fa-cubes" aria-hidden="true"></i> @lang('lang_v1.all_products')</a>
                    </li>
                </ul>
                <div class="tab-content">
                    <div class="tab-pane active" id="product_list_tab">
                        @include('report.partials.product_final_list_report')
                    </div>
                </div>
            </div>
        </div>
    </div>
@endcan
</section>
<!-- /.content -->

@endsection

@section('javascript')
    {{--  <script src="{{ asset('js/product.js?v=' . $asset_v) }}"></script>  --}}
    <script type="text/javascript">
        $(document).ready( function(){
            product_table = $('#product_table').DataTable({
                processing: true,
                serverSide: true,
                aaSorting: [[3, 'asc']],
                scrollY:        "75vh",
                scrollX:        true,
                scrollCollapse: true,
                "ajax": {
                    "url": "/reports/final-report",
                    "data": function ( d ) {
                        d.type = $('#product_list_filter_type').val();
                        d.category_id = $('#product_list_filter_category_id').val();
                        d.brand_id = $('#product_list_filter_brand_id').val();
                        d.based_on = $('#product_list_filter_based_id').val();
                        d.min_dis = $('#product_list_min_id').val();
                        d.max_dis = $('#product_list_max_id').val();
                      //  console.log(d.min_dis)

                        d = __datatable_ajax_callback(d);
                    }
                },
                columnDefs: [ {
                    "targets": [1],
                    "orderable": false,
                    "searchable": false
                } ],
                columns: [
                    
                    { data: 'product_id', name: 'product_id', searchable: false,
                    render:function (data, type, row, meta) {
                        return '<div id="product_id" data-id="'+row.id+'" value="'+data+'">'+data+'</div><input type="hidden"  class="varid"  value="'+row.id+'"><input type="hidden"  class="business_id"  value="'+row.business_id+'"><input type="hidden"  class="location_id"  value="'+row.location_id+'"><input type="hidden"  class="discount_type"  value="'+row.discount_type+'"><input type="hidden"  class="starts_at"  value="'+row.starts_at+'"><input type="hidden"  class="ends_at"  value="'+row.ends_at+'">' ;
                    }},
                        { data: 'name', name: 'name', searchable: false},
                        { data: 'purchase_prices', name: 'purchase_prices', searchable: false,
                        render:function (data, type, row, meta) {
                          return '<div class=""><span class="edit" >'+data+'</span><input type="hidden" name="purchase_prices"  data-column="purchase_prices" class="form-control width-100 pull-left input-sm  update_row purchase_price" data-id="'+row.id+'" type="text"  value="'+data+'" ></div>' ;
                        }},
                        { data: 'product_mrp', name: 'product_mrp', searchable: false,
                        render:function (data, type, row, meta) {
                          return '<div class=""><span class="edit" >'+data+'</span><input type="hidden" data-name="'+row.product_mrp+'" name="product_mrp"  data-column="product_mrp" class="form-control width-100 pull-left input-sm product_mrp  update_row" data-id="'+row.id+'" type="text"  value="'+data+'" ></div>' ;
                        }},
                        { data: 'dis', name: 'dis', searchable: false, class: 'update_record',
                        render:function (data, type, row, meta) {
                            //console.log(row.product_id, 'canteen_discount');
                          return '<div class=""> <input name="dis"  data-column="dis" class="form-control width-100 pull-left input-sm dis  update_row" data-id="'+row.id+'" type="text"  value="'+data+'" ></div>' ;
                        }},
                        { data: 'new_selling', name: 'new_selling', searchable: false,
                        render:function (data, type, row, meta) {
                            return '<div class="new_selling"><input name="new_selling" value="'+data+'" class="form-control width-100 pull-left input-sm new_selling_price"> </div>' ;
                          }},
                        { data: 'profit_in_percentage', name:'profit_in_percentage', searchable:false,
                            render:function (data, type, row, meta) {
                              return '<div id="profit_in_percentage">'+data+' </div>' ;
                            }},
                        { data: 'profit_in_inr', name:'profit_in_inr', searchable:false,
                        render:function (data, type, row, meta) {
                        return '<div id="profit_in_inr">'+data+' </div>' ;
                        }},
                       
                        { data: 'canteen_discount', name: 'canteen_discount', searchable: false,
                        render:function (data, type, row, meta) {
                          return '<div class=""> <input name="canteen_discount" data-name="'+row.canteen_discount+'"  data-column="canteen_discount" class="form-control width-100 pull-left input-sm canteen_discount  update_row" data-id="'+row.id+'" type="text"  value="'+data+'" ></div>' ;
                        }},
                         // { data:  'canteen_transport', name: 'canteen_transport', searchable: false,
                         //    render:function (data, type, row, meta) {
                         //      return '<div class=""><input data-name="'+row.canteen_transport+'" name="canteen_transport"  data-column="canteen_transport" class="form-control width-100 pull-left input-sm canteen_transport  update_row" data-id="'+row.id+'" type="text"  value="'+data+'" ></div>' ;
                         //    }},
                            { data: 'canteen_profit_in_per', name:'canteen_profit_in_per', searchable: false,
                            render:function (data, type, row, meta) {
                             return '<div class="canteen_profit_in_per">'+data+' </div>' ;
                            }},
                            { data: 'canteen_profit_in_inr', name:'canteen_profit_in_inr', searchable: false,
                            render:function (data, type, row, meta) {
                               return '<div class="canteen_profit_in_inr">'+data+' </div>' ;
                            }},
                        { data: 'canteen_selling_price', name: 'canteen_selling_price', searchable: false,
                        render:function (data, type, row, meta) {
                           //  console.log(row, 'canteen_discount');
                          return '<div class="canteen_selling_price1"> <input type="text" name="canteen_selling_price"  data-column="canteen_selling_price" class="width-100 pull-left form-control  canteen_selling_price update_row" data-id="'+row.id+'" data-price="'+data+'" value="'+data+'" /></div>' ;
                        }},
                       

                        { data: 'wholesale_discount', name: 'wholesale_discount', searchable: false,
                        render:function (data, type, row, meta) {
                           //  console.log(row, 'canteen_discount');
                          return '<div class=""> <input name="wholesale_discount"  data-column="wholesale_discount" class="form-control width-100 pull-left input-sm wholesale_discount  update_row" data-id="'+row.id+'" type="text"  value="'+data+'" ></div>' ;
                        }},
                        // { data: 'wholesale_transport', name:'wholesale_transport',searchable:false,
                        //     render:function (data, type, row, meta) {
                        //        //  console.log(row, 'canteen_discount');
                        //       return '<div class=""> <input name="wholesale_transport"  data-column="wholesale_transport" class="form-control width-100 pull-left input-sm wholesale_transport  update_row" data-id="'+row.id+'" type="text"  value="'+data+'" ></div>' ;
                        //     }},
                    { data: 'wholesale_profit_in_per',name:'wholesale_profit_in_per', searchable:false,
                        render:function (data, type, row, meta) {
                           // 
                          return '<div class="wholesale_profit_in_per">'+data+' </div>' ;
                        }},
                    {  data: 'wholesale_profit_in_inr',name:'wholesale_profit_in_inr', searchable:false,
                    render:function (data, type, row, meta) {
                       // 
                      return '<div class="wholesale_profit_in_inr">'+data+' </div>' ;
                    }},
                    { data: 'wholesale_selling_price', name: 'wholesale_selling_price', searchable: false,
                        render:function (data, type, row, meta) {
                            return '<div class="wholesale_selling_price1"> <input type="text" name="wholesale_selling_price"  data-column="wholesale_selling_price" class="width-100 form-control pull-left  wholesale_selling_price update_row" data-id="'+row.id+'" data-price="'+data+'" value="'+data+'"/></div>';
                        }
                    },
                      
                    ],
                   
                    fnDrawCallback: function(oSettings) {
                        __currency_convert_recursively($('#product_table'));
                    },
            });
            // Array to track the ids of the details displayed rows
            var detailRows = [];

            $(document).on('change', '#product_list_filter_type, #product_list_filter_category_id, #product_list_filter_brand_id, #product_list_filter_based_id, #product_list_min_id, #product_list_max_id, #active_state, #repair_model_id', 
                function() {
                    if ($("#product_list_tab").hasClass('active')) {
                        product_table.ajax.reload();
                    }
            });
           
        
              // customer discount onchange of discount
            $(document).on('change', '.dis', function() {
                var id = $(this).attr('data-id'); 
                var currentRow = $(this).closest("tr");
                var product_id = currentRow.find("td:eq(0)").text();

                var variation_id = currentRow.find(".varid").val();
                var business_id = currentRow.find(".business_id").val();
                var location_id = currentRow.find(".location_id").val();
                var discount_type = currentRow.find(".discount_type").val();
                var starts_at = currentRow.find(".starts_at").val();
                var ends_at = currentRow.find(".ends_at").val();

                var discount_amount = currentRow.find(".dis").val();
                var mrp = __read_number(currentRow.find(".product_mrp"));
                // saving = __calculate_amount('percent', mrp, discount_amount);
                //ranvijay code sart here
                var discount = currentRow.find(".dis").val();
                var advance_discount = advanceDiscount(discount);
                var new_selling_price = mrp/advance_discount;
                saving = mrp - new_selling_price;
                __write_number(currentRow.find('input.new_selling_price'), new_selling_price);
                var basic_cost =  currentRow.find(".purchase_price").val();
                var margin = new_selling_price- basic_cost;
                var profit_percent = (margin/new_selling_price)*100;

                currentRow.find("td:eq(6)").text(parseFloat(profit_percent).toFixed(2));
                currentRow.find("td:eq(7)").text(parseFloat(margin).toFixed(2));
                //ranvijay code end here
                $.ajax({
                    url     : '/updateProductReportByDis',
                    method  : 'POST',
                    data    : {
                                product_id : product_id,
                                discount_amount:discount_amount,
                                variation_id:variation_id,
                                business_id:business_id,
                                location_id:location_id,
                                discount_type:discount_type,
                                starts_at:starts_at,
                                ends_at:ends_at,
                                saving: saving
                            },
                    success : function(data){
                        var jsonData = JSON.parse(data);
                        if (jsonData.success == '1') {
                            $('#alert_message').html('<div class="alert alert-success">'+jsonData.msg+'</div>');
                            $('#product_table').DataTable().ajax.reload();
                        } else {
                            $("#alert_message").removeClass('alert-success');
                        }
                    } 
                });   
            });
            // customer discount onchange of selling price
            $(document).on('change', '.new_selling_price', function() {
                var id = $(this).attr('data-id'); 
                var currentRow = $(this).closest("tr");
                var product_id = currentRow.find("td:eq(0)").text();

                var variation_id = currentRow.find(".varid").val();
                var business_id = currentRow.find(".business_id").val();
                var location_id = currentRow.find(".location_id").val();
                var discount_type = currentRow.find(".discount_type").val();
                var starts_at = currentRow.find(".starts_at").val();
                var ends_at = currentRow.find(".ends_at").val();
                var new_selling_price =  __read_number(currentRow.find(".new_selling_price"));
                var mrp = __read_number(currentRow.find(".product_mrp"));
                //ranvijay code sart here
                var advance_discount = (mrp / new_selling_price) * 100;
                var discount_amount = ((mrp / new_selling_price) * 100) - parseInt(advance_discount/100)*100;
                saving = mrp - new_selling_price;
                __write_number(currentRow.find('input.dis'), discount_amount);
                var basic_cost =  currentRow.find(".purchase_price").val();
                var margin = new_selling_price- basic_cost;
                var profit_percent = (margin/new_selling_price)*100;
                currentRow.find("td:eq(6)").text(parseFloat(profit_percent).toFixed(2));
                currentRow.find("td:eq(7)").text(parseFloat(margin).toFixed(2));
                //ranvijay code end here
                $.ajax({
                    url     : '/updateProductReportByDis',
                    method  : 'POST',
                    data    : {
                                product_id : product_id,
                                discount_amount:discount_amount,
                                variation_id:variation_id,
                                business_id:business_id,
                                location_id:location_id,
                                discount_type:discount_type,
                                starts_at:starts_at,
                                ends_at:ends_at,
                                saving: saving
                            },
                    success : function(data){
                        var jsonData = JSON.parse(data);
                        if (jsonData.success == '1') {
                            $('#alert_message').html('<div class="alert alert-success">'+jsonData.msg+'</div>');
                            $('#product_table').DataTable().ajax.reload();
                        } else {
                            $("#alert_message").removeClass('alert-success');
                        }
                    } 
                });   
            });

            //canteern functionality onchange of  canteen discount
            $(document).on('change', '.canteen_discount', function() {
                var id = $(this).attr('data-id');
                var currentRow = $(this).closest("tr");
                var product_mrp = __read_number(currentRow.find(".product_mrp"));
                var purchase_price = __read_number(currentRow.find(".purchase_price"));
                var canteen_sale_price = currentRow.find(".canteen_selling_price").text();
                var new_selling = currentRow.find(".new_selling").text();
                var canteen_transport = profit_percent = canteen_selling_price = 0;
                var canteen_discount = currentRow.find(".canteen_discount").val();                
                // canteen_transport = currentRow.find(".canteen_transport").val();
                var advance_canteen_discount = advanceDiscount(canteen_discount);
                var canteen_selling_price = product_mrp/advance_canteen_discount;
                
                currentRow.find(".canteen_selling_price").val(__currency_trans_from_en(Math.abs(canteen_selling_price), false, false));
                var canteen_margin = canteen_selling_price -purchase_price;
                profit_percent = (canteen_margin/canteen_selling_price)*100;
                currentRow.find(".canteen_profit_in_per").text(__currency_trans_from_en(profit_percent, false, false));
                currentRow.find(".canteen_profit_in_inr").text(__currency_trans_from_en(canteen_margin, false, false));

               $.ajax({
                    url     : '/updateProductReportByCanteenDiscount',
                    method  : 'POST',
                    data    : {
                            id : id,
                            canteen_transport:canteen_transport,
                            canteen_discount:canteen_discount,
                            profit_percent: profit_percent, 
                            canteen_selling_price: canteen_selling_price
                        },
                    success : function(data){
                        var jsonData = JSON.parse(data);
                        if (jsonData.success == '1') {
                            $('#alert_message').html('<div class="alert alert-success">'+jsonData.msg+'</div>');
                            $('#product_table').DataTable().ajax.reload();
                        } else {
                            $("#alert_message").removeClass('alert-success');
                        }
                    } 
                });
            });
            //canteern functionality onchange of  canteen selling price
            $(document).on('change', '.canteen_transport', function() {
                var id = $(this).attr('data-id');
                var currentRow = $(this).closest("tr");
                var product_mrp = __read_number(currentRow.find(".product_mrp"));
                var purchase_price = __read_number(currentRow.find(".purchase_price"));
                var canteen_sale_price = currentRow.find(".canteen_selling_price").text();
                var canteen_transport = canteen_discount = profit_percent = canteen_selling_price = 0;
                // var canteen_transport = currentRow.find(".canteen_transport").val();
                var new_selling = currentRow.find(".new_selling").text();
                canteen_discount = currentRow.find(".canteen_discount").val();            
                var advance_canteen_discount = advanceDiscount(canteen_discount);
                var canteen_selling_price = product_mrp/advance_canteen_discount;

                // canteen_selling_price = __substract_percent(__number_uf(product_mrp), parseFloat(canteen_discount) + parseFloat(canteen_transport));
                currentRow.find(".canteen_selling_price").val(__currency_trans_from_en(Math.abs(canteen_selling_price), false, false));
                var canteen_margin = canteen_selling_price -purchase_price;
                profit_percent = (canteen_margin/canteen_selling_price)*100;
                currentRow.find(".canteen_profit_in_per").text(__currency_trans_from_en(profit_percent, false, false));
                currentRow.find(".canteen_profit_in_inr").text(__currency_trans_from_en(canteen_margin, false, false));

                $.ajax({
                   url     : '/updateProductReportByCanteenDiscount',
                   method  : 'POST',
                   data    : {
                            id : id,
                            canteen_transport:canteen_transport,
                            canteen_discount:canteen_discount,
                            profit_percent: profit_percent, 
                            canteen_selling_price: canteen_selling_price
                    },
                    success : function(data){
                       var jsonData = JSON.parse(data);
                       if (jsonData.success == '1') {
                           $('#alert_message').html('<div class="alert alert-success">'+jsonData.msg+'</div>');
                           $('#product_table').DataTable().ajax.reload();
                       } else {
                           $("#alert_message").removeClass('alert-success');
                       }
                    } 
                });
   
            }); 
            //canteern functionality onchange of  canteen selling price
            $(document).on('change', '.canteen_selling_price', function() {
                var id = $(this).attr('data-id');
                var currentRow = $(this).closest("tr");
                var product_mrp = __read_number(currentRow.find(".product_mrp"));
                var purchase_price = __read_number(currentRow.find(".purchase_price"));
                var canteen_sale_price = currentRow.find(".canteen_selling_price").text();
                var canteen_transport = canteen_discount = profit_percent = canteen_selling_price = 0;
                // var canteen_transport = currentRow.find(".canteen_transport").val();
                
                canteen_selling_price = currentRow.find(".canteen_selling_price").val();  
                var advance_discount = (product_mrp / canteen_selling_price) * 100;
                canteen_discount = ((product_mrp / canteen_selling_price) * 100) - parseInt(advance_discount/100)*100;
                // canteen_selling_price = __substract_percent(__number_uf(product_mrp), parseFloat(canteen_discount) + parseFloat(canteen_transport));
                currentRow.find(".canteen_discount").val(__currency_trans_from_en(Math.abs(canteen_discount), false, false));
                var canteen_margin = canteen_selling_price -purchase_price;
                profit_percent = (canteen_margin/canteen_selling_price)*100;
                currentRow.find(".canteen_profit_in_per").text(__currency_trans_from_en(profit_percent, false, false));
                currentRow.find(".canteen_profit_in_inr").text(__currency_trans_from_en(canteen_margin, false, false));

                $.ajax({
                   url     : '/updateProductReportByCanteenDiscount',
                   method  : 'POST',
                   data    : {
                            id : id,
                            canteen_transport:canteen_transport,
                            canteen_discount:canteen_discount,
                            profit_percent: profit_percent, 
                            canteen_selling_price: canteen_selling_price
                    },
                    success : function(data){
                       var jsonData = JSON.parse(data);
                       if (jsonData.success == '1') {
                           $('#alert_message').html('<div class="alert alert-success">'+jsonData.msg+'</div>');
                           $('#product_table').DataTable().ajax.reload();
                       } else {
                           $("#alert_message").removeClass('alert-success');
                       }
                    } 
                });
   
            }); 

            //whole sale functionality onchange of  wholesale discount
            $(document).on('change', '.wholesale_discount', function() {
                var id = $(this).attr('data-id');
                var currentRow = $(this).closest("tr");
                var product_mrp = __read_number(currentRow.find(".product_mrp"));
                var purchase_price = __read_number(currentRow.find(".purchase_price"));
                var wholesale_selling_price = currentRow.find(".wholesale_selling_price").val();
                var wholesale_transport = profit_percent = wholesale_selling_price = 0;
                var wholesale_discount = currentRow.find(".wholesale_discount").val();
                
                // wholesale_transport = currentRow.find(".wholesale_transport").val();
                // wholesale_selling_price = __substract_percent(__number_uf(product_mrp), parseFloat(wholesale_discount) + parseFloat(wholesale_transport));
                var advance_wholesale_discount = advanceDiscount(wholesale_discount);
                wholesale_selling_price = product_mrp/advance_wholesale_discount;

                currentRow.find(".wholesale_selling_price").val(__currency_trans_from_en(Math.abs(wholesale_selling_price), false, false));

                // profit_percent = __get_rate(purchase_price,wholesale_selling_price);
                var wholesale_margin = wholesale_selling_price -purchase_price;
                profit_percent = (wholesale_margin/wholesale_selling_price)*100;
                currentRow.find(".wholesale_profit_in_per").text(__currency_trans_from_en(profit_percent, false, false))
                currentRow.find(".wholesale_profit_in_inr").text(__currency_trans_from_en(wholesale_margin, false, false))

                $.ajax({
                    url     : '/updateProductReportByWholesaleDiscount',
                    method  : 'POST',
                    data    : {
                            id : id,
                            wholesale_transport:wholesale_transport,
                            wholesale_discount:wholesale_discount,
                            profit_percent: profit_percent, 
                            wholesale_selling_price: wholesale_selling_price
                    },
                    success : function(data){
                        var jsonData = JSON.parse(data);
                        if (jsonData.success == '1') {
                            $('#alert_message').html('<div class="alert alert-success">'+jsonData.msg+'</div>');
                            $('#product_table').DataTable().ajax.reload();
                        } else {
                            $("#alert_message").removeClass('alert-success');
                        }
                        } 
                });
            });
            //whole sale functionality onchange of  wholesale transport
            $(document).on('change', '.wholesale_transport', function() {
           
                var id = $(this).attr('data-id');
                var currentRow = $(this).closest("tr");
                var product_mrp = __read_number(currentRow.find(".product_mrp"));
                var purchase_price = __read_number(currentRow.find(".purchase_price"));
                var wholesale_selling_price = currentRow.find(".wholesale_selling_price").val();
                var wholesale_transport = profit_percent = wholesale_selling_price = 0;
                // var wholesale_transport = currentRow.find(".wholesale_transport").val();
                wholesale_discount = currentRow.find(".wholesale_discount").val();
            
                // wholesale_selling_price = __substract_percent(__number_uf(product_mrp), parseFloat(wholesale_discount) + parseFloat(wholesale_transport));
                var advance_wholesale_discount = advanceDiscount(wholesale_discount);
                wholesale_selling_price = product_mrp/advance_wholesale_discount;

                currentRow.find(".wholesale_selling_price").val(__currency_trans_from_en(Math.abs(wholesale_selling_price), false, false));
                
                var wholesale_margin = wholesale_selling_price -purchase_price;
                profit_percent = (wholesale_margin/wholesale_selling_price)*100;
                currentRow.find(".wholesale_profit_in_per").text(__currency_trans_from_en(profit_percent, false, false));
                currentRow.find(".wholesale_profit_in_inr").text(__currency_trans_from_en(wholesale_margin, false, false));

                $.ajax({
                        url     : '/updateProductReportByWholesaleDiscount',
                        method  : 'POST',
                        data    : {
                                    id : id,
                                    wholesale_transport:wholesale_transport,
                                    wholesale_discount:wholesale_discount,
                                    profit_percent: profit_percent, 
                                    wholesale_selling_price: wholesale_selling_price
                        },
                        success : function(data){
                                        var jsonData = JSON.parse(data);
                                        if (jsonData.success == '1') {
                                            $('#alert_message').html('<div class="alert alert-success">'+jsonData.msg+'</div>');
                                            $('#product_table').DataTable().ajax.reload();
                                        } else {
                                            $("#alert_message").removeClass('alert-success');
                                        }
                        } 
                });      
            }); 

            $(document).on('change', '.wholesale_selling_price', function() {
                var data_price = $(this).attr('data-price');
                var id = $(this).attr('data-id');
                var currentRow = $(this).closest("tr");
                var wholesale_transport = profit_percent = wholesale_selling_price = 0;
                var product_mrp = __read_number(currentRow.find(".product_mrp"));
                var purchase_price = __read_number(currentRow.find(".purchase_price"));
                wholesale_selling_price = currentRow.find(".wholesale_selling_price").val();
                // wholesale_transport = currentRow.find(".wholesale_transport").val();            
                // wholesale_selling_price = __substract_percent(__number_uf(product_mrp), parseFloat(wholesale_discount) + parseFloat(wholesale_transport));
                var advance_discount = (product_mrp / wholesale_selling_price) * 100;
                wholesale_discount = ((product_mrp / wholesale_selling_price) * 100) - parseInt(advance_discount/100)*100;

                currentRow.find(".wholesale_discount").val(__currency_trans_from_en(Math.abs(wholesale_discount), false, false));
                
                var wholesale_margin = wholesale_selling_price -purchase_price;
                profit_percent = (wholesale_margin/wholesale_selling_price)*100;
                currentRow.find(".wholesale_profit_in_per").text(__currency_trans_from_en(profit_percent, false, false));
                currentRow.find(".wholesale_profit_in_inr").text(__currency_trans_from_en(wholesale_margin, false, false));

                $.ajax({
                        url     : '/updateProductReportByWholesaleDiscount',
                        method  : 'POST',
                        data    : {
                                    id : id,
                                    wholesale_transport:wholesale_transport,
                                    wholesale_discount:wholesale_discount,
                                    profit_percent: profit_percent, 
                                    wholesale_selling_price: wholesale_selling_price
                        },
                        success : function(data){
                                        var jsonData = JSON.parse(data);
                                        if (jsonData.success == '1') {
                                            $('#alert_message').html('<div class="alert alert-success">'+jsonData.msg+'</div>');
                                            $('#product_table').DataTable().ajax.reload();
                                        } else {
                                            $("#alert_message").removeClass('alert-success');
                                        }
                        } 
                });      
            }); 

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

        });
    </script>
    <style>
        table {
          
        }
        td{
            overflow:hidden;
            text-overflow: ellipsis;
            word-wrap: break-word;
            max-width: 400px;
        }
    
        .currencyinput {
            color: #7f7d7d;
            font-size: 10px;
        }
        .currencyinput input {
            border: 0;
        }


        </style>
@endsection