@{
    ViewBag.Title = "DemoItemwise";
    Layout = "~/Views/Shared/_Layout.cshtml";
}

<h2>DemoItemwise</h2>

@{
    ViewBag.Title = "Itemwise";
}

<script type="text/javascript" src="~/ProjectScript/ReportPrint.js"></script>

<script src="~/Scripts/Autocomplete/jquery-ui.js"></script>

<style>
    .form-control {
        font-weight: bold;
    }
</style>
<input type="text" class="form-control" id="MaxRowNo" value="1" />

<input type="text" class="form-control" id="CurrentRowNo" value="0" />

<div id="Entry">

    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header" style="border-bottom:1px solid #e6e6e6">


                    <div>
                        <table width="100%">
                            <tr>
                                <td><h4 id="header"></h4></td>

                                <td width="30%"></td>
                                <td align="right"><button type="button" style="width:100px" onclick="$('#popupdiv').show(), $('#customer').focus()" id="btnback" class="btn btn-outline-primary">Back</button></td>
                                <td><button type="button" style="width:100px;margin-left:20px" id="btnprint" onclick="PrintthisReportWindows('ITEMWISEREPORT', $('#ResultLength').val())" class="btn btn-primary">Print <i class="ft-printer"></i></button></td>

                                <td align="right">

                                    <div class="btn-group" id="buttonPlace">




                                        <div align="right">
                                            <div class="heading-elements">
                                                <div class="btn-group" id="buttonPlace">

                                                </div>
                                            </div>
                                        </div>

                                    </div>
                                </td>

                            </tr>
                        </table>


                        <div align="right">

                            <div class="heading-elements">
                                <br /><hr style="margin-top:-1%" />
                                <div id="divreport" style="overflow:auto;display:none">
                                    <table id="Tblreport" class="table table-striped table-bordered base-style dataTable"></table><br />
                                </div>
                                <div style="display:none">
                                    <table id="Tblreportprint"></table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>




<div id="popupdiv" class="modal fade text-left show" tabindex="-1" role="dialog" style="padding-right: 17px;margin-top:-50px; background:rgba(0,0,0,0.5); display: block; display:none1;height:200%">
    <div class="modal-dialog" role="document" style="top:7.5%;max-width:35%">
        <div class="modal-content">
            <div class="modal-header bg-primary white">
                <h3 class="modal-title" id="myheader">Itemwise Report</h3>
                <button type="button" class="close" onclick="popuprefresh()" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                </button>
            </div>
            <form id="monthpopup" style="display:none1">

                <!-- Modal body -->
                <div class="modal-body">

                    <div class="row">
                        <div class="col-md-1"></div>
                        <div class="col-md-2 text-right">
                            <label style="font-weight:bold;">From</label>
                        </div>
                        <div class="col-md-3">
                            <input type="text" id="dateFrom" class="form-control" autocomplete="off">
                        </div>

                        <div class="col-md-2 text-right">
                            <label style="font-weight:bold;">To</label>
                        </div>
                        <div class="col-md-3">
                            <input type="text" id="dateTo" class="form-control" autocomplete="off">
                        </div>
                        <div class="col-md-1"></div>
                    </div>
                    <div class="row" style="border-bottom:1px solid #cfd8dc;margin-top:2.5%;"></div>

                    <div class="row">
                        <div class="col-md-1"></div>
                        <label class="col-md-2" style="margin-top:2%;font-weight:bold;">Customer</label>
                        <div class="col-md-8" style="margin-top:2%;">
                            <table width="100%">
                                <tr>
                                    <td width="30%">
                                        <input type="text" id="customer" class="form-control" onkeyup="$('#custnames').val('')" style="border-right:none;border-top-right-radius:0px;border-bottom-right-radius:0px;text-align:left">
                                        <input type="hidden" id="customerId" class="form-control" />
                                    </td>
                                    <td>
                                        <input type="text" id="custnames" class="form-control" onchange="" autocomplete="off" style="border-top-left-radius:0px;border-bottom-left-radius:0px;border-left:none;background-color:white" disabled>
                                    </td>
                                </tr>
                            </table>
                        </div>
                        <div class="col-md-1"></div>
                    </div>

                    <div class="row" style="margin-top:2%;">
                        <div class="col-md-1"></div>
                        <div class="col-md-2 text-right">
                            <label style="font-weight:bold;">Area </label>
                        </div>
                        <div class="col-md-3">
                            <select id="Area" name="priority" class="form-control">
                                <option value="0">-All-</option>
                            </select>
                        </div>
                        <div class="col-md-2 text-right">
                            <label style="margin-top:2%;font-weight:bold;">Pay Type</label>
                        </div>
                        <div class="col-md-3">
                            <select id="Paytype" class="form-control" name="priority">
                                <option value="0">-All-</option>
                                <option value="1">Cash</option>
                                <option value="2">Credit</option>
                                <option value="3">Card</option>
                            </select>
                        </div>
                        <div class="col-md-1"></div>
                    </div>
                    <div class="row" style="margin-top:2%;">
                        <div class="col-md-1"></div>
                        <div class="col-md-2 text-right">
                            <label style="font-weight:bold;">Salesman</label>
                        </div>
                        <div class="col-md-3">
                            <select id="Salesman" name="priority" class="form-control"></select>
                        </div>
                        <div class="col-md-2 text-right">
                            <label style="margin-top:2%;font-weight:bold;margin-left:9.7%">Dept.</label>
                        </div>
                        <div class="col-md-3">
                            <select id="Dept" name="priority" class="form-control"></select>
                        </div>
                        @*<div class="col-md-2 text-right">
                                <label style="margin-top:2%;font-weight:bold;">Customer </label>
                            </div>
                                <div class="col-md-3">
                                    <input type="text" id="customer" class="form-control">
                                    <input type="hidden" id="customerId" class="form-control" />
                                </div>*@
                        <div class="col-md-1"></div>
                    </div>
                    <div class="row" style="margin-top:2%;">
                        <div class="col-md-1"></div>
                        <div class="col-md-2 text-right">
                            <label style="font-weight:bold;">Group</label>
                        </div>
                        <div class="col-md-3">
                            <select id="Group" name="priority" class="form-control"></select>
                        </div>
                        <div class="col-md-2 text-right">
                            <label style="font-weight:bold;">Sub Grp.</label>
                        </div>
                        <div class="col-md-3">
                            <select id="SubGroup" name="priority" class="form-control"></select>
                        </div>
                        <div class="col-md-1"></div>
                    </div>
                    <div class="row" style="margin-top:2%;">
                        <div class="col-md-1"></div>
                        <div class="col-md-2 text-right">
                            <label style="font-weight:bold;">Category</label>
                        </div>
                        <div class="col-md-3">
                            <select id="Category" name="priority" class="form-control"></select>
                        </div>
                        <div class="col-md-2 text-right">
                            <label style="margin-top:2%;font-weight:bold;">Sub Cat.</label>
                        </div>
                        <div class="col-md-3">
                            <select id="SubCategory" name="priority" class="form-control"></select>
                        </div>
                        <div class="col-md-1"></div>
                    </div>



                    <div class="row" style="margin-top:2%;">
                        <div class="col-md-1"></div>

                        <input type="text" class="form-control" id="UserId" style="display:none">
                        <div class="col-md-2 text-right"></div>
                        <div class="col-md-1"></div>
                    </div>
                </div>

                <!-- Modal footer -->
                <div class="modal-footer">
                    <div class="col-md-3">
                        <fieldset class="form-group floating-label-form-group">
                            <div class="row">
                                <div class="custom-control custom-checkbox">
                                    <input type="checkbox" class="custom-control-input" name="customCheck" id="grpbySR">
                                    <label class="custom-control-label" for="grpbySR" style="font-weight:bold">Sales Return</label>
                                </div>
                            </div>

                        </fieldset>
                    </div>

                    <div class="col-md-5">

                        <div class="text-center">
                            <button type="button" id="btnsubmit" class="btn btn-primary" data-dismiss="modal">Apply</button>
                            <input type="hidden" id="Length" class="form-control" />
                            <input type="hidden" id="ResultLength" class="form-control" />


                            <button type="button" class="btn btn-primary" style="" data-dismiss="modal" onclick="popuprefresh()">Close</button>
                        </div>
                    </div>
                    <div class="col-md-3"></div>
                </div>
            </form>






        </div>
    </div>
</div>




<script>
        //Customername Autocomplete

        $("#customer").autocomplete({
            source: function (request, response) {
                var data = {};
                data.CustName = $("#customer").val();
                data.CustType = 'C';

                $.ajax({
                    url: '../Master/CustomerOrSupplierSearch',
                    type: "POST",
                    data: data,
                    dataType: "json",
                    success: function (data) {
                        response($.map(data, function (item) {
                            return ({
                                ColCount: 'TWOEnq',
                                label: item.CustAccount,
                                label1: item.CustName,
                                CustId: item.CustId,
                                CustName: item.CustName,
                                headers: ["Customer Code", "Customer Name"]
                            })
                        }));
                    }

                })

            },
            autoFocus: true,
            select: function (event, ui) {
                $('#customerId').val(ui.item.CustId)
                $('#customer').val(ui.item.CustName)
                $("#custnames").val(ui.item.CustName);
                $('#Area').focus();
            },

        });

        $(function () {

            $('#customer').focus();

            GetDepartment(0);
            GetArea(0);
            GetSalesMan(0);
            GroupPageLoad(0);
            CategoryPageLoad(0);


            $('#Area').keypress(function (e) {
                var key = e.charCode ? e.charCode : e.keyCode ? e.keyCode : 0;
                if (key == 13) {
                    $('#Paytype').focus();
                    e.preventDefault();
                }
            });

            $('#Paytype').keypress(function (e) {
                var key = e.charCode ? e.charCode : e.keyCode ? e.keyCode : 0;
                if (key == 13) {
                    $('#Salesman').focus();
                    e.preventDefault();
                }
            });

            $('#Salesman').keypress(function (e) {
                var key = e.charCode ? e.charCode : e.keyCode ? e.keyCode : 0;
                if (key == 13) {
                    $('#Dept').focus();
                    e.preventDefault();
                }
            });

            $('#Dept').keypress(function (e) {
                var key = e.charCode ? e.charCode : e.keyCode ? e.keyCode : 0;
                if (key == 13) {
                    $('#Group').focus();
                    e.preventDefault();
                }
            });
            $('#Group').keypress(function (e) {
                var key = e.charCode ? e.charCode : e.keyCode ? e.keyCode : 0;
                if (key == 13) {
                    $('#SubGroup').focus();
                    e.preventDefault();
                }
            });
            $('#SubGroup').keypress(function (e) {
                var key = e.charCode ? e.charCode : e.keyCode ? e.keyCode : 0;
                if (key == 13) {
                    $('#Category').focus();
                    e.preventDefault();
                }
            });
            $('#Category').keypress(function (e) {
                var key = e.charCode ? e.charCode : e.keyCode ? e.keyCode : 0;
                if (key == 13) {
                    $('#SubCategory').focus();
                    e.preventDefault();
                }
            });
            $('#SubCategory').keypress(function (e) {
                var key = e.charCode ? e.charCode : e.keyCode ? e.keyCode : 0;
                if (key == 13) {
                    $('#btnsubmit').focus();
                    e.preventDefault();
                }
            });

            $('#dateFrom').daterangepicker({
                minDate: minDate,
                maxDate: new Date(new Date().getFullYear(), new Date().getMonth(), new Date().getDate()),
                singleDatePicker: true,
                showDropdowns: true,
                locale: {
                    format: 'DD/MM/YYYY'
                }
            });

            $('#dateTo').daterangepicker({
                minDate: minDate,
                maxDate: new Date(new Date().getFullYear(), new Date().getMonth(), new Date().getDate()),
                singleDatePicker: true,
                showDropdowns: true,
                locale: {
                    format: 'DD/MM/YYYY'
                }
            });
        });
        //load Department

        function GetDepartment(id) {
            var data = {};
            data.UserId = ERPUserId;
            $.ajax({
                type: "POST",
                url: "../Master/UserDepartmentGetandGets",
                data: data,
                success: function (result) {
                    DepartmentLoad(result.oList, id);


                }
            });
        }

        function DepartmentLoad(result, a) {
            $("#Dept").empty();
            $("#Dept").append("<option value='0'>-All-</option>");
            for (var i = 0; i < result.length; i++) {
                $("#Dept").append("<option value='" + result[i].DepartmentId + "'>" + result[i].DepartmentName + "</option>");
            }
        }

        //Load Area
        function GetArea(id) {
            var data = {};
            data.Id = 0;
            $.ajax({
                type: "POST",
                url: "../Master/AreaGetandGets",
                data: data,
                success: function (result) {
                    $.each(result.oList, function (index, ele) {
                        $("#Area").append($("<option>").attr("value", ele.AreaId).text(ele.AreaCode));
                    });
                }
            });
        }

        //Load Salesman

        function GetSalesMan(id) {
            var data = {};
            data.Id = 0;
            $.ajax({
                type: "POST",
                url: "../Master/SalesmanGetandGets",
                data: data,
                success: function (result) {
                    SalesManLoad(result.oList, id);
                }
            });
        }

        function SalesManLoad(result, a) {
            $("#Salesman").empty();
            $("#Salesman").append("<option value='0'>-All-</option>")
            for (var i = 0; i < result.length; i++) {
                $("#Salesman").append("<option value='" + result[i].Id + "'>" + result[i].FirstName + "</option>");
            }
        }

        //Load Group
        function GroupPageLoad(id) {
            var data1 = {};
            data1.GrpId = 0;
            $.ajax({
                type: "POST",
                url: "../Master/GroupGetandGets",
                data: data1,
                success: function (result) {
                    GroupLoad(result.oList, id);
                }
            });
        }

        function GroupLoad(result) {
            $("#Group").empty();
            $("#Group").append("<option value='0'>-All-</option>");
            for (var i = 0; i < result.length; i++) {

                $("#Group").append("<option value='" + result[i].GrpId + "'>" + result[i].GrpName + "</option>");
            }
            SubGroupGets();
        }

        //Load SubGroup

        function SubGroupGets() {
            var data = {};
            data.GroupId = $("#Group").val();


            if (data.GroupId == 0) {
                data.SbgrpId = 0;
                $.ajax({
                    type: "POST",
                    url: "../Master/SubGroupGetandGets",
                    data: data,
                    success: function (result) {
                        SubGroupLoad(result.oList);
                    }
                });
            }
            else {
                data.SbgrpId = 0;
                $.ajax({
                    type: "POST",
                    url: "../Master/SubGroupGetForGroup",
                    data: data,
                    success: function (result) {
                        SubGroupLoad(result.oList);
                    }
                });
            }
        }

        function SubGroupLoad(result) {
            $("#SubGroup").empty();
            $("#SubGroup").append("<option value='0'>-All-</option>");
            for (var i = 0; i < result.length; i++) {
                $("#SubGroup").append("<option value='" + result[i].SbgrpId + "'>" + result[i].SbgrpName + "</option>");
            }
        }

        //Load Category

        function CategoryPageLoad(id) {
            var data2 = {};
            data2.CategoryId = 0;
            $.ajax({
                type: "POST",
                url: "../Master/CategoryGetandGets",
                data: data2,
                success: function (result) {
                    CategoryLoad(result.oList, id);
                }
            });
        }


        function CategoryLoad(result) {
            $("#Category").empty();
            $("#Category").append("<option value='0'>-All-</option>");
            for (var i = 0; i < result.length; i++) {
                $("#Category").append("<option value='" + result[i].CategoryId + "'>" + result[i].CategoryName + "</option>");
            }
            SubCategoryGets();
        }
        //Load SubCategory

        function SubCategoryGets() {

            var data = {};
            data.CategoryId = $("#Category").val();

            if (data.CategoryId == 0) {
                data.SubCategoryId = 0;
                $.ajax({
                    type: "POST",
                    url: "../Master/SubCategoryGetandGets",
                    data: data,
                    success: function (result) {
                        SubCategoryLoad(result.oList);

                    }
                });
            }

            else {
                data.SubCategoryId = 0;
                $.ajax({
                    type: "POST",
                    url: "../Master/SubCategoryGetforCategory",
                    data: data,
                    success: function (result) {
                        SubCategoryLoad(result.oList);
                    }
                });
            }
        }



        function SubCategoryLoad(result) {
            $("#SubCategory").empty();
            $("#SubCategory").append("<option value='0'>-All-</option>");
            for (var i = 0; i < result.length; i++) {
                $("#SubCategory").append("<option value='" + result[i].SubCategoryId + "'>" + result[i].SubCategoryName + "</option>");
            }
        }

        function popuprefresh() {
            $('#popupdiv').hide();
        }

        function Showreport(result) {

            console.log(result)

            //disable_datatable('Tblreport', 'buttonPlace');
            if ($("#CurrentRowNo").val() == 0)
                var responseText = "<thead><tr><th style='text-align:center'>Sl#</th><th width=10px>Type</th><th width=100px>Bill#</th><th style='text-align:center' width=10px>Date</th><th style='text-align:center' width=100px>Account#</th><th width=100px>Customer</th><th width=100px>Salesman</th><th width=400px>Item Code</th><th width=500px>Item Name</th><th width=10px>Unit</th><th style='text-align:center' width=10px>Qty.</th><th style='text-align:right' width=10px>Unit Price</th><th width=10px>Area</th><th width=10px>Terms</th><th width=10px>Pay Type</th><th width=10px>JobCode</th><th width=10px>LPO#</th><th style='text-align:right' width=10px>Taxable Amount</th><th style='text-align:right' width=10px>Tax Amount</th><th width=10px>Disc.</th><th style='text-align:right' width=10px>Amount</th><th style='text-align:center' width=10px>Fx.</th><th>FC Rate</th><th style='text-align:right' width=10px>FC Amount</th><th>Group</th><th width=10px>SubGroup</th><th width=10px>Category</th><th width=10px>SubCategory</th><th width=10px>Dept.Code</th></tr></thead><tbody>";
            else
                var responseText = "";

            for (var i = 0; i < result.length; i++) {
                var slno = Number($("#CurrentRowNo").val())+parseInt(i + 1);
                if (result[i].InvDate == 'Grand Total') {

                    var salesman = (result[i].FirstName);
                    salesman = salesman.substring(0, 10);

                    responseText += '<tr  style=background-color:#cfd8dc><td style=text-align:center>' + slno + '</td><td id="Col1_' + slno + '">' + result[i].SType + '</td><td></td><td id="Col3_' + slno + '" style=text-align:center><b>' + result[i].InvDate + '</b></td><td id="Col4_' + slno + '" style=text-align:center>' + result[i].AccCode + '</td><td id="Col5_' + slno + '">' + result[i].CustoName + '</td><td>' + salesman + '</td><td id="Col6_' + slno + '">' + result[i].ProductCode + '</td><td id="Col7_' + slno + '">' + result[i].ProductDescr + '</td><td>' + result[i].UnitName + '</td><td id="Col8_' + slno + '" style=text-align:center><b>' + ReplaceNumberWithCommas(result[i].ProdQty) + '</b></td><td id="Col10_' + slno + '" style=text-align:right>' + result[i].ProdRate + '</td><td>' + result[i].Name + '</td><td>' + result[i].TermDescription + '</td><td>' + result[i].Payterms + '</td><td>' + result[i].JobCode + '</td><td>' + result[i].LPO + '</td><td style=text-align:right><b>' + ReplaceNumberWithCommas(parseFloat(result[i].TaxableAmount || 0).toFixed(Decimal)) + '</b></td><td  style=text-align:right><b>' + ReplaceNumberWithCommas(parseFloat(result[i].TaxAmount || 0).toFixed(Decimal)) + '</b></td><td style=text-align:right><b>' + ReplaceNumberWithCommas(parseFloat(result[i].ProdDisc || 0).toFixed(Decimal)) + '</b></td><td id="Col9_' + slno + '" style=text-align:right><b>' + ReplaceNumberWithCommas(parseFloat(result[i].Amount || 0).toFixed(Decimal)) + '</b></td><td style=text-align:center>' + result[i].CurrencyName + '</td><td></td><td style=text-align:right><b>' + ReplaceNumberWithCommas(parseFloat(result[i].FCAmount || 0).toFixed(Decimal)) + '</b></td><td>' + result[i].GrpName + ' </td><td>' + result[i].SbgrpName + ' </td><td>' + result[i].CategoryName + ' </td><td>' + result[i].SubCategoryName + ' </td><td>' + result[i].DepartmentName + ' </td></tr>';
                }

                else {
                    var salesman = (result[i].FirstName);
                    salesman = salesman.substring(0, 10);

                    responseText += '<tr ondblclick=gotoInvoNo(' + result[i].BillSlNo + "," + result[i].BillSeriesId + ",'" + result[i].SType + "'," + result[i].DeptId + ')><td style=text-align:center>' + slno + '</td><td id="Col1_' + slno + '" style="text-align:center">' + result[i].SType + '</td><td id="Col2x_' + slno + '">' + result[i].BillDescription + '-' + result[i].BillSlNo + '</td><td id="Col3_' + slno + '" style=text-align:center>' + result[i].InvDate + '</td><td id="Col4_' + slno + '" style=text-align:center>' + result[i].AccCode + '</td><td id="Col5_' + slno + '">' + result[i].CustoName + '</td><td>' + salesman + '</td><td id="Col6_' + slno + '">' + result[i].ProductCode + '</td><td id="Col7_' + slno + '">' + result[i].ProductDescr + '</td><td>' + result[i].UnitName + '</td><td id="Col8_' + slno + '" style=text-align:center>' + result[i].ProdQty + '</td><td id="Col10_' + slno + '" style=text-align:right>' + result[i].ProdRate + '</td><td>' + result[i].Name + '</td><td>' + result[i].TermDescription + '</td><td>' + result[i].Payterms + '</td><td>' + result[i].JobCode + '</td><td>' + result[i].LPO + '</td><td style=text-align:right>' + parseFloat(result[i].TaxableAmount || 0).toFixed(Decimal) + '</td><td  style=text-align:right>' + parseFloat(result[i].TaxAmount || 0).toFixed(Decimal) + '</td><td style=text-align:right>' + parseFloat(result[i].ProdDisc || 0).toFixed(Decimal) + '</td><td id="Col9_' + slno + '" style=text-align:right>' + parseFloat(result[i].Amount || 0).toFixed(Decimal) + '</td><td style=text-align:center>' + result[i].CurrencyName + '</td><td style=text-align:right>' + parseFloat(result[i].CurncyRate || 0).toFixed(Decimal) + '</td><td style=text-align:right>' + parseFloat(result[i].FCAmount || 0).toFixed(Decimal) + '</td><td>' + result[i].GrpName + ' </td><td>' + result[i].SbgrpName + ' </td><td>' + result[i].CategoryName + ' </td><td>' + result[i].SubCategoryName + ' </td><td>' + result[i].DepartmentName + ' </td></tr>';
                }




                $("#CurrentRowNo").val(result[i].SlNo);
                $("#MaxRowNo").val(result[i].InvoNo);
                

            }

            //$('#Tblreport tr:last').after(responseText);
            $('#Tblreport').append(responseText);


            //$('#Tblreportprint').html(responseText)
            var title = "Itemwise SalesReport - from " + $("#dateFrom").val() + " to " + $("#dateTo").val() + "";
            //datatableWithsearch('Tblreport', true, title, 'buttonPlace');
            $('#header').text(title);
            $('#ResultLength').val(result.length);

         
            if (Number($("#CurrentRowNo").val()) < Number($("#MaxRowNo").val())) {
                loopReport();
            }

        }

        function gotoInvoNo(BillSlNo, BillSeriesId, SType, DeptId) {
            if (SType == 'SI') {
                if ((usermenu1.indexOf("M54") != -1)) {
                    window.open('../inventory/SalesInvoice?slno=' + BillSlNo + '&billseries=' + BillSeriesId + '&dept=' + DeptId);

                }
                else if ((usermenu1.indexOf("M227") != -1)) {
                    window.open('../inventory/SalesInvoiceNew?slno=' + BillSlNo + '&billseries=' + BillSeriesId + '&dept=' + DeptId);

                }
                else {
                    warningshow('Invalid User Rights');
                    return false;
                }
            }
            else {
                if ((usermenu1.indexOf("M56") != -1)) {
                    window.open('../SalesInvoice/SalesReturn?slno=' + BillSlNo + '&billseries=' + BillSeriesId + '&dept=' + DeptId);

                }
                else if ((usermenu1.indexOf("M241") != -1)) {
                    window.open('../SalesInvoice/SalesReturnNew?slno=' + BillSlNo + '&billseries=' + BillSeriesId + '&dept=' + DeptId);

                }
                else {
                    warningshow('Invalid User Rights');
                    return false;
                }

            }
        }

        function warningshow(message, Id) {
            $('#popupmessage').text(message);
            $('#Warningpopup').show();
            $('#' + Id).focus();
            window.setTimeout(function () {
                $('#Warningpopup').hide();
            }, 3000);
        }

        $("#btnsubmit").click(function (e) {
            $('#Loading').show();

            if ($("#CurrentRowNo").val() < $("#MaxRowNo").val()) {

                var data = {};
                data.SlNo = $("#CurrentRowNo").val();
                $.ajax({
                    type: "POST",
                    url: "../Itemwise/ItemwiseGetandGetsDemo",
                    data: data,
                    success: function (result) {

                        $('#Loading').hide();
                        $('#divreport').show();
                        $('#popupdiv').hide();
                        Showreport(result);
                    }
                });

            }
        });

        function loopReport() {
            if (Number($("#CurrentRowNo").val()) < Number($("#MaxRowNo").val())) {

                var data = {};
                data.SlNo = $("#CurrentRowNo").val();
                $.ajax({
                    type: "POST",
                    url: "../Itemwise/ItemwiseGetandGetsDemo",
                    data: data,
                    success: function (result) {

                        $('#Loading').hide();
                        $('#divreport').show();
                        $('#popupdiv').hide();
                        Showreport(result);
                    }
                });

            }
        }

        function datatableWithsearch(tablename, download, title, tableButtonContainerId) {

            var a = '#' + tablename + ' tfoot th'
            $(a).each(function () {
                var title = $(this).text();
                if (title != 'Edit' && title != 'Select' && title != 'Sl#' && title != 'Credit Limit' && title != 'Due Days' && title != 'O Balance' && title != ' ') {
                    $(this).html('<input type="text" placeholder="Search ' + title + '" style="width=100%" />');
                }
                if (title == 'Type' || title == 'FC Rate') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:60px" />');
                }
                if (title == 'Unit' || title == 'Account#') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:50px" />');
                }
                if (title == 'Salesman'||title == 'Location') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100px" />');
                }
                if (title == 'Item Name') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:250px" />');
                }
                if (title == 'Terms') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100%" />');
                }
                if (title == 'Date') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100px" />');
                }
                if (title == 'Category' || title == 'SubCategory' || title == 'Group' || title == 'SubGroup') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:150px" />');
                }
                if (title == 'Customer') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:120px" />');
                }
                if (title == 'Bill#') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:60px" />');
                }
                if (title == 'Qty.') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100%" />');
                }
                if (title == 'Item Code') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:150px" />');
                }
                if (title == 'Dept.Code') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100%" />');
                }
                if (title == 'Fx.') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100%" />');
                }
                if (title == 'Pay Type') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100%" />');
                }
                if (title == 'LPO#') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100%" />');
                }
                if (title == 'JobCode') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100%" />');
                }
                if (title == 'Area') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100%" />');
                }
                if (title == 'Group') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100%" />');
                }
                if (title == 'SubGroup') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100%" />');
                }
                if (title == 'Category') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100%" />');
                }
                if (title == 'SubCategory') {
                    $(this).html('<input type="text" placeholder="' + title + '" style="width:100%" />');
                }
            });
            var table = null;
            if (download) {
                if (!title || !tableButtonContainerId) { console.log("download table need title and button container"); }


                table = $('#' + tablename).DataTable({
                    dom: "<'row'<'col-sm-1'l><'col-sm-11'f>>" +
            "<'row'<'col-sm-12'tr>>" +
            "<'row'<'col-sm-1'i><'col-sm-11'p>>",
                    buttons: [],


                });
                new $.fn.dataTable.Buttons(table, {
                    buttons: [
                    {
                        extend: 'collection',
                        text: 'Export',
                        className: 'excelexport',
                        buttons: [
                            {
                                extend: 'excelHtml5',
                                title: title,
                                messageTop: 'EUMI ERP',
                                exportOptions: { columns: ":visible" }
                            },
                            {
                                extend: 'pdfHtml5',
                                title: title,
                                messageTop: 'EUMI ERP',
                                exportOptions: { columns: ":visible" }
                            },
                            {
                                extend: 'print',
                                title: title,
                                messageTop: 'EUMI ERP',
                                exportOptions: { columns: ":visible" }
                            }
                        ]
                    },
                    'colvis'
                    ]
                });
                table.buttons(0, null).container().appendTo($("#" + tableButtonContainerId));
                $("#" + tableButtonContainerId).find(".buttons-collection").addClass("btn-outline-primary mx-1").css("border-radius", "4px");

            } else {
                table = $('#' + tablename).DataTable();
            }
            table.columns().every(function () {
                var that = this;
                $('input', this.footer()).on('keyup change', function () {
                    if (that.search() !== this.value) {
                        that
                            .search(this.value)
                            .draw();

                    }
                });
            });
            if (ExcelExport == 0) {
                $('.excelexport').hide();
            }
        }



        function disable_datatable(tablename, tableButtonContainerId) {
            $('#Warningpopup').fadeOut();
            if ($.fn.DataTable.isDataTable('#' + tablename)) {
                var table = $('#' + tablename).DataTable();
                table.destroy();
                if (tableButtonContainerId) { $("#" + tableButtonContainerId).empty(); }
                return;
            }
        }
        $(document).ready(function () {
            $('#popup').show();
        });
</script>