@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">

        @component('components.filters', ['title' => __('report.filters')])
        {!! Form::open(['url' => action([\App\Http\Controllers\ReportController::class, 'getProductDiscountDownload']), 'method' => 'post', 'files' => true ]) !!}
        <div class="col-md-4">
            <div class="form-group">
                {!! Form::label('category_id', __('product.category') . ':') !!}
                {!! Form::select('category_id[]', $categories, [], ['multiple' => 'multiple', 'class' => 'form-control select2', 'style' => 'width:100%', 'id' => 'product_list_filter_category_id']); !!}
            </div>
        </div>

        <div class="col-md-4">
            <div class="form-group">
                {!! Form::label('brand_id', __('product.brand') . ':') !!}
                {!! Form::select('brand_id[]', $brands, 0, ['multiple' => 'multiple','class' => 'form-control select2', 'style' => 'width:100%', 'id' => 'product_list_filter_brand_id', 'placeholder' => 'select brands']); !!}
            </div>
        </div>

        {{--<div class="col-md-2 ">
            <div class="form-group">
                <label>&nbsp;</label>
                <button type='button' class="btn btn-primary" data-toggle="modal" data-target="#addLeadModel"> Add Lead</button>
            </div>
        </div> --}}
        {{-- <div class="col-md-2 ">
            <div class="form-group">
                <label class="text text-danger">*Clik to Print</label>
                <input type="submit" name="printPdf" value="Print Price List" class="btn btn-primary" id="generatePdf">
            </div>
        </div>--}}
        <div class="clearfix"></div>
        <div class="row col-md-2">
            <input type="checkbox" class="btn-check" id="chk_product" checked autocomplete="off">
            <strong>Product</strong>
        </div>
        <div class="row col-md-2">
            <input type="checkbox" class="btn-check" id="chk_brand" checked autocomplete="off">
            <strong>Brand</strong>
        </div>
        <div class="row col-md-2">
            <input type="checkbox" class="btn-check" id="chk_category" checked autocomplete="off">
            <strong>Category</strong>
        </div>
        <div class="row col-md-2">
            <input type="checkbox" class="btn-check" id="chk_sub_category" checked autocomplete="off">
            <strong>
                Sub Category
            </strong>
        </div>
        <div class="row col-md-2">
            <input type="checkbox" class="btn-check" id="chk_bascic_cost" checked autocomplete="off">
            <strong>Basic Cost</strong>
        </div>
        <div class="row col-md-2">
            <input type="checkbox" class="btn-check" id="chk_mrp" checked autocomplete="off">
            <strong>MRP</strong>
        </div>
        <div class="row col-md-2">
            <input type="checkbox" class="btn-check" id="chk_depo_dis" checked autocomplete="off">
            <strong>Depo Discount</strong>
        </div>
        <div class="row col-md-2">
            <input type="checkbox" class="btn-check" id="chk_depo_profit_per" checked autocomplete="off">
            <strong>Depo Profit%</strong>
        </div>

        <div class="row col-md-2">
            <input type="checkbox" class="btn-check" id="chk_canteen_dis" checked autocomplete="off">
            <strong>Canteen Discount</strong>
        </div>
        <div class="row col-md-2">
            <input type="checkbox" class="btn-check" id="chk_canteen_profit_per" checked autocomplete="off">
            <strong>Canteen Profit%</strong>
        </div>
        <div class="row col-md-2">
            <input type="checkbox" class="btn-check" id="chk_retail_dis" checked autocomplete="off">
            <strong>Retail Discount</strong>
        </div>
        <div class="row col-md-2">
            <input type="checkbox" class="btn-check" id="chk_retail_profit_per" checked autocomplete="off">
            <strong>Retail Profit%</strong>
        </div>
        {!! Form::close() !!}
        @endcomponent
    </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_price_list_header')
                    </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": "/depo-management/final-pricelist",
                "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 '<input type="checkbox" checked class="hide_row" onclick="remove_row(this);"/> ';
                    }
                },
                {
                    data: 'name',
                    name: 'name',
                    searchable: false
                },
                {
                    data: 'product_brand',
                    name: 'product_brand',
                    searchable: false
                },
                {
                    data: 'product_category',
                    name: 'product_category',
                    searchable: false
                },
                {
                    data: 'product_sub_category',
                    name: 'product_sub_category',
                    searchable: false
                },
                {
                    data: 'wholesale_selling_price',
                    name: 'wholesale_selling_price',
                    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: 'wholesale_discount',
                    name: 'wholesale_discount',
                    searchable: false,
                    render: function(data, type, row, meta) {
                        //  console.log(row, 'canteen_discount');
                        return '<div class=""> <span class="edit" >' + data + '</span></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>';
                //     }
                // },

                {
                    data: 'canteen_discount',
                    name: 'canteen_discount',
                    searchable: false,
                    render: function(data, type, row, meta) {
                        return '<div class=""> <span class="edit" >' + data + '</span></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: 'dis',
                    name: 'dis',
                    searchable: false,
                    class: 'update_record',
                    render: function(data, type, row, meta) {
                        //console.log(row.product_id, 'canteen_discount');
                        return '<div class=""><span class="edit" >' + data + '</span> </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>' ;
                // }},

            ],

            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;
        }
        const $table = $('table');
        //prudct colomn hide functionality
        const $checkboxProduct = $('#chk_product');
        $checkboxProduct.on('click', function() {
            const product_status = !$checkboxProduct.is(':checked');
            if (product_status == true) {
                $table.find('th:nth-child(2), td:nth-child(2)').hide();
            } else if (product_status == false) {
                $table.find('th:nth-child(2), td:nth-child(2)').show();

            }
        });
        //brand colomn hide functionality
        const $checkboxBrand = $('#chk_brand');
        $checkboxBrand.on('click', function() {
            const brand_status = !$checkboxBrand.is(':checked');
            if (brand_status == true) {
                $table.find('th:nth-child(3), td:nth-child(3)').hide();
            } else if (brand_status == false) {
                $table.find('th:nth-child(3), td:nth-child(3)').show();

            }
        });
        //category colomn hide functionality
        const $checkboxCategory = $('#chk_category');
        $checkboxCategory.on('click', function() {
            const category_status = !$checkboxCategory.is(':checked');
            if (category_status == true) {
                $table.find('th:nth-child(4), td:nth-child(4)').hide();
            } else if (category_status == false) {
                $table.find('th:nth-child(4), td:nth-child(4)').show();

            }
        });
        //category colomn hide functionality
        const $checkboxSubCategory = $('#chk_sub_category');
        $checkboxSubCategory.on('click', function() {
            const sub_category_status = !$checkboxSubCategory.is(':checked');
            if (sub_category_status == true) {
                $table.find('th:nth-child(5), td:nth-child(5)').hide();
            } else if (sub_category_status == false) {
                $table.find('th:nth-child(5), td:nth-child(5)').show();

            }
        });
        const $checkboxBasiCost = $('#chk_bascic_cost');
        $checkboxBasiCost.on('click', function() {
            const purchase_price_status = !$checkboxBasiCost.is(':checked');
            console.log(purchase_price_status);
            if (purchase_price_status == true) {
                $table.find('th:nth-child(6), td:nth-child(6)').hide();
            } else if (purchase_price_status == false) {
                $table.find('th:nth-child(6), td:nth-child(6)').show();

            }
        });
        //hide Mrp Colomn
        const $checkboxMrp = $('#chk_mrp');
        $checkboxMrp.on('click', function() {
            const mrp_status = !$checkboxMrp.is(':checked');

            if (mrp_status == true) {
                $table.find('th:nth-child(7), td:nth-child(7)').hide();
            } else if (mrp_status == false) {
                $table.find('th:nth-child(7), td:nth-child(7)').show();

            }
        });
        //hide depot discount col
        const $checkboxDepoDiscount = $('#chk_depo_dis');
        $checkboxDepoDiscount.on('click', function() {
            const depo_discount_status = !$checkboxDepoDiscount.is(':checked');

            if (depo_discount_status == true) {
                $table.find('th:nth-child(8), td:nth-child(8)').hide();
            } else if (depo_discount_status == false) {
                $table.find('th:nth-child(8), td:nth-child(8)').show();

            }
        });
        //hide Depot profit% col
        const $checkboxDepoPer = $('#chk_depo_profit_per');
        $checkboxDepoPer.on('click', function() {
            const depo_profit_per_status = !$checkboxDepoPer.is(':checked');

            if (depo_profit_per_status == true) {
                $table.find('th:nth-child(9), td:nth-child(9)').hide();
            } else if (depo_profit_per_status == false) {
                $table.find('th:nth-child(9), td:nth-child(9)').show();

            }
        });
        //hide Depot profit% col
        const $checkboxCanteenDis = $('#chk_canteen_dis');
        $checkboxCanteenDis.on('click', function() {
            const canteen_dis_status = !$checkboxCanteenDis.is(':checked');

            if (canteen_dis_status == true) {
                $table.find('th:nth-child(10), td:nth-child(10)').hide();
            } else if (canteen_dis_status == false) {
                $table.find('th:nth-child(10), td:nth-child(10)').show();

            }
        });

        //hide depo profit% col
        const $checkboxCanteenProfitPer = $('#chk_canteen_profit_per');
        $checkboxCanteenProfitPer.on('click', function() {
            const canteen_profit_per_status = !$checkboxCanteenProfitPer.is(':checked');

            if (canteen_profit_per_status == true) {
                $table.find('th:nth-child(11), td:nth-child(11)').hide();
            } else if (canteen_profit_per_status == false) {
                $table.find('th:nth-child(11), td:nth-child(11)').show();

            }
        });

        //hide Retail discount col
        const $checkboxRetailDis = $('#chk_retail_dis');
        $checkboxRetailDis.on('click', function() {
            const retail_dis_status = !$checkboxRetailDis.is(':checked');

            if (retail_dis_status == true) {
                $table.find('th:nth-child(12), td:nth-child(12)').hide();
            } else if (retail_dis_status == false) {
                $table.find('th:nth-child(12), td:nth-child(12)').show();

            }
        });
        //hide Retail profit% col
        const $checkboxRetailProfitPer = $('#chk_retail_profit_per');
        $checkboxRetailProfitPer.on('click', function() {
            const retail_profit_per_status = !$checkboxRetailProfitPer.is(':checked');

            if (retail_profit_per_status == true) {
                $table.find('th:nth-child(13), td:nth-child(13)').hide();
            } else if (retail_profit_per_status == false) {
                $table.find('th:nth-child(13), td:nth-child(13)').show();

            }
        });
        // print on dom functionality

        $('#generatePdf').click(function(e) {

            e.preventDefault();
            var cateGoryId = $('#product_list_filter_category_id').val();
            var brandId = $('#product_list_filter_brand_id').val();
            $.ajax({
                type: 'GET',
                "url": "/depo-management/get-depo-discount",
                data: {
                    'printPdf': "data",
                    category_id: cateGoryId,
                    brand_id: brandId
                },

                success: function(resultData) {
                    var link = document.createElement('a');
                    link.href = resultData;
                    link.download = resultData;
                    link.click();
                    link.remove();
                }
            });
        });

    });
    //hide rows
    function remove_row(v) {
        $(v).parent().parent().hide();
    }

    function show_all_row(row_var) {
        var thisTableRows = $("#product_table").rows();
        for (var i = 0; i < thisTableRows.length; i++) {
            thisTableRows[i].show();
        }
    }
</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