@{
    ViewBag.Title = "PurchaseEnquiryNew";
}


<script type="text/javascript" src="../Projectscript/PurchaseEnquiryNew.js"></script>




<link rel="stylesheet" type="text/css" href="../../../app-assets/vendors/css/tables/jsgrid/jsgrid-theme.min.css">
<link rel="stylesheet" type="text/css" href="../../../app-assets/vendors/css/tables/jsgrid/jsgrid.min.css">
<link rel="stylesheet" type="text/css" href="../app-assets/vendors/css/hopscotch.css">
<script src="~/ProjectScript/Windowsprint.js"></script>
<script type="text/javascript" src="~/Scripts/Excelmport/xlsx.full.min.js"></script>
<script type="text/javascript" src="~/Scripts/Excelmport/excelimport.js"></script>

<script src="~/app-assets/data/table2excel.js" type="text/javascript"></script>
<script>
    function PrintthisBill() {
                PrintthisBillWindows('PurchaseEnquiry', i)
    }
</script>
<style>
    #fixed {
        width: 100%;
        position: fixed;
        top: 0px;
    }

    #customView {
        border: 1px solid #CCD6E6;
    }

    #OtherCostView {
        border: 1px solid #CCD6E6;
    }

    #Cell1 {
        width: 80%;
    }

    #Cell2 {
        width: 20%;
        text-align: right;
    }

    #panel1 {
        display: none;
    }

    .modal-xl {
        max-width: 90%;
        margin-left: 7%;
        margin-right: 3%;
    }

    .modal-llg {
        max-width: 80%;
        margin-left: 13%;
        margin-right: 7%;
    }
        .modal-lgl {
        max-width: 70%;
        margin-left: 16%;
        margin-right: 14%;
    }
</style>

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

<div class="myData" data-x="M238" />
<div id="Entry" style="margin-top:-20px;">

    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header" style="background-color:#009da0;height:80px">
                    <div class="row">
                        <h4 class="card-title mb-0 col-md-5" style="float:left;color:white;font-size:xx-large;">Purchase Enquiry</h4>

                        <div class="row form-group col-md-7">
                            <i class="ft-calendar" style="font-weight:normal;font-size:xx-large;color:white"></i>
                            <input type="text" id="enquirydate" style="width:150%;background-color:#009da0;border:none;color:white;font-size:xx-large" class="form-control editds input-lg col-md-7">
                            </div>

                        
                    </div>
                </div>
                <div class="card-body" style="margin-top:0px">
                    <div class="card-content collapse show">
                        <div class="card-body">
                            <form action="#">
                                <div class="form-body">
                                    <hr style="margin-top:0px" />
                                    <div class="row" style="background-color:#E0F3F4;margin-left:1px;width:100%;margin-top:-20px;height:130px">

                                        <div class="col-md-12">
                                            <br />
                                            <div class="form-group">

                                                <div class="hopscotch-bubble animated tour-demo-tour" id="tour1" style="position: absolute; top: 65px; left:12%;display:none">

                                                    <div class="hopscotch-bubble-container" style="width: 280px; padding: 10px;">
                                                        <div class="hopscotch-bubble-content">
                                                            <h3 class="hopscotch-title">Search Enquiry Number Here.</h3>
                                                            <div class="hopscotch-content"></div>
                                                        </div>
                                                    </div>
                                                    <div class="hopscotch-bubble-arrow-container hopscotch-arrow up">
                                                        <div class="hopscotch-bubble-arrow-border"></div>
                                                        <div class="hopscotch-bubble-arrow"></div>
                                                    </div>
                                                </div>


                                                <div class="row" style="margin-top:-8px">
                                                    <label class="col-lg-1" style="font-weight:bold">PE #<span class="danger">*</span></label>
                                                    <div class="col-lg-11">
                                                        <div class="row">
                                                            @*============Default Entry No Div====================*@
                                                            <div class="col-md-2 input-group" id="EntryNoDiv">
                                                                <input type="text" class="form-control" id="Enquiryno" style="height:38px;" disabled>
                                                                <div class="input-group-append">
                                                                    <span class="input-group-btn">
                                                                        <button type="button" id="btnlist" onclick="GetRows()" class="btn btn-outline-primary"><i class="ft-search"></i></button>
                                                                    </span>
                                                                </div>
                                                               
                                                            </div>
                                                            @*===================================================*@

                                                            @*============Copy Entry No Div======================*@
                                                            <div id="CopyEntryNoDiv" class="col-md-2 input-group" style="display:none">
                                                                <div class="input-group-prepend" id="prependdiv">
                                                                    <span class="input-group-btn" title="Previous">
                                                                        <button type="button" id="btnprvs" onclick="GetPurchaseEntryPrevousornext(-1)" class="btn btn-outline-primary" style="height:90%"><i class="ft-chevron-left"></i></button>
                                                                    </span>
                                                                </div>
                                                                <input type="text" class="form-control" id="CopyEnquiryno" onkeypress="isNumberInt(event,this)" placeholder="Search Enquiry" style="height:90%">
                                                                <div class="input-group-append" id="appenddiv">
                                                                    <span class="input-group-btn" title="Next">
                                                                        <button type="button" id="btnnxt" onclick="GetPurchaseEntryPrevousornext(1)" class="btn btn-outline-primary" style="height:90%"> <i class="ft-chevron-right"></i></button>
                                                                    </span>
                                                                </div>
                                                            </div>
                                                            @*===================================================*@

                                                            
                                                           

                                                            <label style="font-weight:bold" class="col-lg-1 text-lg-right">Location</label>
                                                            <div class="col-md-2 form-group">
                                                                <select id="location" style="" class="form-control editds"></select>
                                                               
                                                            </div>
                                                            <label class="col-lg-1 text-lg-right" style="font-weight:bold">Transfer</label>
                                                            <div class="col-md-2 input-group">
                                                                <select id="transfer" class="form-control" style="height:90%">
                                                                    <option value="0">--Select--</option>
                                                                    <option value="1">Recall Old</option>
                                                                    <option value="2">Recall Purchase Order</option>
                                                                    <option value="3">Recall Purchase Entry</option>
                                                                </select>
                                                                <div class="input-group-append" id="addtransfer">
                                                                    <button type="button" id="btntransfer" class="btn btn-outline-primary butndis" style="height:90%" onclick="GetList(0)">⇆</button>
                                                                </div>
                                                            </div>
                                                            <div class="col-md-4">
                                                                <h2 class="text-center" id="fc" style="opacity:0;color:red;font-weight:500">fc </h2>
                                                            </div>
                                                            

                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="row">
                                                    <label class="col-lg-1" style="font-weight:bold">Supplier<span class="danger">*</span></label>
                                                    <div class="col-lg-11">
                                                        <div class="row">
                                                            <div class="col-md-2 form-group">
                                                                <input type="text" id="suppliername" class="form-control editds" style="height:90%">
                                                            </div>
                                                            <input type="hidden" id="supplierId" class="form-control">
                                                            <label class="col-lg-1 text-lg-right" style="font-weight:bold">FX<span class="danger">*</span></label>
                                                            <div class="col-md-2 input-group">
                                                                <select id="currency" style="height:80%" class="form-control editds"></select>
                                                                <input type="text" id="rate" style="height:80%" class="form-control editds" onkeypress="isNumber(event,this)" onkeyup="CalcAmt()" />

                                                            </div>
                                                                                                                      
                                                            <label class="col-lg-1 text-lg-right"></label>
                                                            <div class="col-md-2">
                                                                <button type="button" style="width:100%" id="btnallow" class="btn btn-outline-primary btn-min-width mr-1 mb-1 butndis">Purchase Analysis <i class="ft-align-justify"></i></button>

                                                                @*<input type="text" id="rate" class="form-control" onkeypress="isNumber(event,this)" onkeyup="CalcAmt()" />*@
                                                            </div>
                                                           
                                                            <div class="col-md-4">
                                                                <h2 class="text-center" id="gndtotal" style="color:red;font-weight:500">0.00</h2>

                                                            </div>
                                                                <input type="hidden" id="fcamount" class="form-control">
                                                                <input type="hidden" id="fctaxable" class="form-control">
                                                                <input type="hidden" id="fctax" class="form-control">
                                                                <input type="hidden" id="fcdiscount" class="form-control">
                                                            </div>
                                                    </div>

                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <hr style="margin-top:3px" />
                                    <div class="px-2"  style="margin-top:-15px">
                                        <div class="row">
                                            <div class="col-md-12">
                                                <div class="row" style="height:26px;">

                                                    <div class="col-md-3">
                                                        <div class="form-group">
                                                            <label>Product<span class="danger">*</span></label>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-2">
                                                        <div class="form-group">
                                                            <label>Location</label>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1" style="display:none">
                                                        <div class="form-group">
                                                            <label>Unit<span class="danger">*</span></label>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1">
                                                        <div class="form-group">
                                                            <label>Quantity<span class="danger">*</span></label>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1">
                                                        <div class="form-group">
                                                            <label>Rate</label>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1">
                                                        <div class="form-group">
                                                            <label>Discount</label>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1">
                                                        <div class="form-group">
                                                            <label>Tax Group<span class="danger">*</span></label>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1">
                                                        <div class="form-group">
                                                            <label>Tax %</label>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1">
                                                        <div class="form-group">
                                                            <label>Amount</label>
                                                        </div>
                                                    </div>
                                                </div>

                                                <div class="row">
                                                    <div id="prodappdiv" class="col-md-3 form-group">

                                                        <input type="text" id="product_0" class="form-control editds" style="height:65%;margin-left:1px" onkeypress="LoadProduct()" onkeyup="checkproduct()">
                                                      

                                                    </div>
                                                    <input type="hidden" id="productId_0" class="form-control" />
                                                    <input type="hidden" id="ProductLength" class="form-control" />
                                                    <input type="hidden" id="productdesc_0" class="form-control" />
                                                    <div class="col-md-2">
                                                        <div class="form-group">
                                                            <select id="locn_0" style="height:34px" class="form-control editds"></select>
                                                            <input type="hidden" id="txtlocn" class="form-control" />

                                                        </div>
                                                    </div>


                                                    <div class="col-md-1" style="display:none">
                                                        <div class="form-group">

                                                            <select id="unit_0" style="height:34px" class="form-control editds"></select>
                                                            <input type="hidden" id="txtunit_0" class="form-control" />
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1">
                                                        <div class="form-group">

                                                            <input type="text" style="height:34px" id="quantity_0" onclick="$('#quantity_0').select()" class="form-control  editds" onkeyup="CalcAmount(0)" onkeypress="isNumberInt(event,this)">
                                                        </div>
                                                    </div>


                                                    <div class="col-md-1">
                                                        <div class="form-group">

                                                            <input type="text" style="height:34px" id="txtrate_0" onclick="$('#txtrate_0').select()" class="form-control editds" onkeyup="CalcAmount(0)" onkeypress="isNumber(event, this)">
                                                            <input type="hidden" id="txtsubtotal" class="form-control" />
                                                            <input type="hidden" id="baserate_0" class="form-control" />
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1">
                                                        <div class="form-group">
                                                            <input type="text" style="height:34px" id="discount_0" class="form-control editds" onclick="$('#discount_0').select()" onkeyup="CalcAmount(0)" onkeypress="isNumber(event,this)">
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1">
                                                        <div class="form-group">

                                                            <select id="tax_0" style="height:34px" class="form-control editds" onchange="ChangeTax(0,this)"></select>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1">
                                                        <div class="form-group">

                                                            <input type="text" style="height:34px" id="taxpercentage_0" class="form-control" disabled>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1">
                                                        <div class="form-group">

                                                            <input type="text" style="height:34px" id="amount_0" class="form-control" disabled>
                                                            <input type="hidden" id="txttaxable_0" class="form-control" />
                                                            <input type="hidden" id="txttax_0" class="form-control" />
                                                            <input type="hidden" id="txtsubtotal_0" class="form-control" />
                                                            <input type="hidden" id="baseamount_0" class="form-control" />
                                                            <input type="hidden" id="basetaxableamount_0" class="form-control" />
                                                            <input type="hidden" id="basetaxamount_0" class="form-control" />
                                                            <input type="hidden" id="basediscount_0" class="form-control" />
                                                        </div>
                                                    </div>
                                                    <div class="col-md-1">
                                                        <div class="form-group">
                                                            <button type="button" id="btnadd" onclick="ProductAdd()" class="btn btn-outline-primary butndis" style="width:100%;height:34px">&nbsp;&nbsp;+Add&nbsp;&nbsp;</button>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <div class="px-2">
                                    <div id="customView" class="jsgrid" style="position: relative; height: 300px; width: 100%; margin-top:-15px;overflow-x: auto;overflow-y: hidden; ">
                                        <div class="jsgrid-grid-header jsgrid-header-scrollbar" style="width: 100%;">
                                            <table class="jsgrid-table">
                                                <tr class="jsgrid-header-row">
                                                    <th class="jsgrid-header-cell jsgrid-control-field jsgrid-align-center" style="width:3%"><i class="icon-pencil"></i>&nbsp;<i class="icon-trash"></i></th>
                                                    <th class="jsgrid-header-cell jsgrid-align-right jsgrid-header-sortable" style="width:3%">SL#</th>
                                                    <th class="jsgrid-header-cell jsgrid-align-right jsgrid-header-sortable" style="width:10%">Code#</th>
                                                    <th class="jsgrid-header-cell jsgrid-align-right jsgrid-header-sortable" style="width:20%">Description</th>
                                                    <th class="jsgrid-header-cell jsgrid-align-right jsgrid-header-sortable" style="width:6%;display:none">Unit</th>
                                                    <th class="jsgrid-header-cell jsgrid-align-center jsgrid-header-sortable" style="width:5%">Quantity</th>
                                                    <th class="jsgrid-header-cell jsgrid-align-center jsgrid-header-sortable" style="width:6%">Rate</th>
                                                    <th class="jsgrid-header-cell jsgrid-align-center" style="width:6%;display:none">Discount</th>
                                                    <th class="jsgrid-header-cell jsgrid-align-center" style="width:6%">Taxable</th>
                                                    <th class="jsgrid-header-cell jsgrid-align-center" style="width:6%;display:none">Tax Group</th>
                                                    <th class="jsgrid-header-cell jsgrid-align-center" style="width:6%;display:none;">Tax %</th>
                                                    <th class="jsgrid-header-cell jsgrid-align-center" style="width:6%">Tax Amt.</th>
                                                    <th class="jsgrid-header-cell jsgrid-align-center" style="width:6%">Amount</th>
                                                    <th class="jsgrid-header-cell jsgrid-align-center" style="width:6%;">Location</th>

                                                </tr>

                                            </table>
                                        </div>
                                        <div id="proddiv" class="" style="position: relative;  overflow-x: auto;overflow-y: scroll; height: 246px;width: 100%;">
                                            <table class="jsgrid-table" id="tblpurchase_enquiry"></table>
                                        </div>
                                    </div>
                                    <br />
                                    <table style="width:100%;">
                                        <tr>
                                            <td id="Cell1" style="width:50%">
                                                <div class="row" style="margin-top:-10px;">

                                                    <div class="form-group row col-md-12 text-md-center">

                                                        <div class="col-md-9">
                                                            <table border="1" width="100%">
                                                                <tr>

                                                                    <td class="text-center" >
                                                                        <label style="margin-top:8px;height:20px">Total Discount</label>
                                                                    </td>
                                                                    <td class="text-center" >
                                                                        <label style="margin-top:8px;height:20px">Total Taxable</label>
                                                                    </td>
                                                                    <td class="text-center" >
                                                                        <label style="margin-top:8px;height:20px">Total Tax</label>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td class="text-center" > 
                                                                        <input type="text" id="totdisc" value="0.00" class="form-control text-center" style="background-color:white;border:none;font-weight:bold;height:30px" disabled>
                                                                    </td>
                                                                    <td class="text-center" >
                                                                        <input type="text" id="tottaxable" value="0.00" class="form-control text-center" style="background-color:white;border:none;font-weight:bold;height:30px" disabled>
                                                                    </td>
                                                                    <td class="text-center" >
                                                                        <input type="text" id="tottax" value="0.00" class="form-control text-center" style="background-color:white;border:none;font-weight:bold;height:30px" disabled>
                                                                        <input type="hidden" id="GrandTotal" class="form-control" style="background-color:white;width:100px;border:none;font-weight:bold" disabled>
                                                                        <input type="hidden" id="basedisc" /> 
                                                                    </td> 
                                                                </tr>
                                                                <tr>
                                                                    <td colspan="3">
                                                                        <textarea placeholder="Remarks" id="txtnotes" style="width:100%;resize:none;overflow:hidden;border:none;font-weight:bold;" rows="3" class="form-control editds" name="notes"></textarea>
                                                                    </td>
                                                                </tr>
                                                            </table>
                                                        </div>
                                                        <div class="col-md-3">

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

                                            </td>
                                            <td valign="top" id="Cell2">
                                                <div class="text-right">
                                                    <button type="button" style="width:25%" id="btnsubmit" class="btn btn-primary mr-1 mb-1 btn-sm"><u>S</u>ave <i class="fa fa-check-square-o"></i></button>
                                                    
                                                    <button type="button" style="width:25%" id="btnlistpurchase" onclick="GetPurchaseListDefault()" class="btn btn-primary mr-1 mb-1 btn-sm">View <i class="ft-eye"></i></button>
                                                    <button type="button" style="width:25%" id="btnnew" onclick="createnew()" class="btn btn-primary mr-1 mb-1 btn-sm">New <i class="ft-refresh-cw position-right"></i></button>
                                                    <button type="button" style="width:25%;display:none" id="btnprint" onclick="PrintthisBill()" class="btn btn-primary mr-1 mb-1 btn-sm">Print <i class="ft-printer"></i></button>
                                                    @*<button style="display:none" type="button" id="btnsaveedit" onclick="UpdatePurchaseEnquiry()" class="btn btn-warning white btn-min-width mr-1 mb-1">Update<i class="fa fa-check-square-o"></i></button>
                                                        <button style="display:none" type="button" id="btnedit" onclick="EditInvoice(0)" class="btn btn-secondary white btn-min-width mr-1 mb-1">Edit<i class="fa ft-edit"></i></button>*@
                                                    <input type="button" id="btnExporttoExcel" style="width:25%;display:none" value="Export To Excel" class="btn gradient-back-to-earth  mr-1 mb-1 white btn-sm" />
                                                    <button style="width:25%;display:none" type="button" id="btndelete" onclick="DeletePurchaseEnquiry()" class="btn btn-danger mr-1 mb-1 btn-sm">Delete <i class="fa fa-times"></i></button>
                                                
                                                    <input type="file" id="fileUpload" style="width:270px;display:none" onchange="Upload()" class="btn gradient-back-to-earth mr-1 mb-1 btn-sm white" />
                                                    <button type="button" id="upload" class="btn gradient-back-to-earth mr-1 mb-1 btn-sm white" style="display:none" onclick="Upload()"><i class="fa fa-upload"></i></button>

                                                </div>
                                            </td>
                                        </tr>
                                    </table>
                                    @*<div id="panel1">
                                        <div class="form-group">
                                            <textarea id="txtnotes" rows="3" class="form-control editds" name="notes"></textarea>
                                        </div>
                                    </div>*@
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<div class="modal fade text-left show" id="purchaseViewForm" tabindex="-1" role="dialog" aria-labelledby="purchaseviewheader" style="padding-right: 17px; display: none;display: none;background:rgba(0,0,0,0.5);">
    <div class="modal-dialog modal-lgl" role="document" style="top:0%;">
        <div class="modal-content">
            <div class="modal-header bg-primary white">
                <h4 class="modal-title" id="purchaseviewheader"></h4>
                <button type="button" class="close" data-dismiss="modal" onclick="$('#purchaseViewForm').hide()" aria-label="Close">
                    <span aria-hidden="true">×</span>
                </button>
            </div>
            <div id="">
                <div class="modal-body">
                    <div class="table-responsive">
                        <div class="col-md-12">
                            <div class="row" style="background-color:#E0F3F4;">

                                <div class="col-md-1" style="margin-top:17px;text-align:left;">
                                    <label for="ViewFromDate">From Date</label>
                                </div>
                                <div class="col-md-2" style="margin-top:10px;margin-left:-2%;">

                                    <input type="text" id="ViewFromDate" class="form-control" placeholder="From Date" style="height:35px;font-weight:200;">

                                </div>
                                <div class="col-md-1" style="margin-top:17px;text-align:left;">
                                    <label for="ViewToDate">To Date</label>
                                </div>
                                <div class="col-md-2" style="margin-top:10px;margin-left:-3%;">
                                    <div class="form-group">
                                        <input type="text" id="ViewToDate" class="form-control" placeholder="To Date" style="height:35px;font-weight:200;">
                                    </div>
                                </div>
                                <div class="col-md-1" style="margin-top:10px;">                           
                                        <button type="button" id="" onclick="GetPurchaseList()" class="btn btn-primary btn-min-width mr-1 mb-1 " style="position:absolute;width:100px;font-weight:400;">Search <i class="fa fa-search position-right"></i>  </button>                                
                                </div>
                                <button type="button" style="margin-left:5%;display:none;margin-top:1%" id="btnpereport" onclick="window.open('../Purchaseandsalesreports/PurchaseEnquiryMain')" class="btn btn-warning btn-min-width mr-1 mb-1">PE Report&nbsp;<i class="fa fa-list position-right"></i></button>
                                <button type="button" style="display:none;margin-top:1%" id="btnpeitemwise" onclick="window.open('../Purchaseandsalesreports/PurchaseEnquirySub')" class="btn btn-warning btn-min-width mr-1 mb-1">PE-Itemwise Report&nbsp;<i class="fa fa-list position-right"></i></button>
                                <button type="button" style="display:none;margin-top:1%" id="btnpepending" onclick="window.open('../PendingReport/PendingPurchaseEnquiry')" class="btn btn-warning btn-min-width mr-1 mb-1">PE-Pending Report&nbsp;<i class="fa fa-list position-right"></i></button>
                            </div>
                        </div>
                        <div class="" style="height:525px;width:100%; ">
                            <table id="tbl_PIViewList" class="table table-striped table-bordered zero-configuration dataTable" style="width:inherit;"></table>
                        </div>

                    </div>

                </div>


            </div>

        </div>
    </div>
</div>
<div id="OTPDiv" class="modal fade text-left show" tabindex="-1" role="dialog" aria-labelledby="myheader" style="background:rgba(0,0,0,0.5); display: block;margin-top:0%;display: none;">
    <div class="modal-dialog modal-dialog-centered" role="document" style="top:-25%">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" onclick="$('#OTPDiv').hide()" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                </button>
            </div>

            <div class="modal-body">
                <div class="col-md-12">
                    <div class="row" id="panel" style="margin-top:2%;">

                        <label class="col-md-5" style="text-align:left" id="reason">Enter the OTP:</label>
                        <div class="col-md-7">
                            <input type="text" id="otp" class="form-control" autocomplete="off">
                        </div>
                    </div>
                    <div class="row" id="panel" style="margin-top:2%;">

                        <label class="col-md-5" style="text-align:left" id="reason">Remarks:</label>
                        <div class="col-md-7">
                            <input type="text" id="otpremarks" class="form-control" autocomplete="off">
                        </div>
                    </div>
                </div>

            </div>
            <div class="modal-footer">
                <button type="button" style="width:100px;" id="btndivdelete" onclick="$('#OTPDiv').hide()" class="btn btn-outline-secondary">Cancel</button>
                <button type="button" style="width:100px" id="btncnclsave" onclick="CheckEditInvoce(1)" class="btn btn-outline-warning">Continue</button>
            </div>


        </div>
    </div>
</div>
<div id="popupdiv" class="modal fade text-left show" tabindex="-1" role="dialog" aria-labelledby="myheader" style="padding-right: 17px; background:rgba(0,0,0,0.5); display: block; display:none">
    <div class="modal-dialog" role="document" style="top:10%">
        <div class="modal-content"  style="width:90%">
            <div class="modal-header bg-primary white">
                <h4 class="modal-title" id="myheader" style="height:25px"></h4>
                <button type="button" class="close" onclick="popuprefresh()" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                </button>
            </div>
            <form id="currencydiv" style="display:none">
                <div class="modal-body" style="overflow:auto;height:250px;">
                    <fieldset class="form-group floating-label-form-group">
                        <label for="txt_code">Code<span class="danger">*</span></label>
                        <input type="text" id="txt_code" onkeyup="changetoupper(this.id),$('#txt_cname').val($('#txt_code').val())" class="form-control editds">
                    </fieldset>
                    <br>
                    <fieldset class="form-group floating-label-form-group">
                        <label for="unitdesc">Name</label>
                        <input type="text" id="txt_cname" maxlength="100" class="form-control editds">
                    </fieldset>
                    <br />
                    <fieldset class="form-group floating-label-form-group">
                        <label for="unitname">Rate<span class="danger">*</span></label>
                        <input type="text" id="txt_rate" maxlength="8" onkeypress="isNumber(event,this)" class="form-control editds">
                    </fieldset>
                    <br>
                    <fieldset class="form-group floating-label-form-group">
                        <label for="unitname">Remarks</label>
                        <input type="text" id="txt_remark" class="form-control editds">
                    </fieldset>
                    <br>
                </div>
                <div class="modal-footer">
                    <input type="reset" class="btn btn-outline-secondary" onclick="popuprefresh()" data-dismiss="modal" value="Close">
                    <input type="button" class="btn btn-outline-primary" value="Save" id="btncrncysave" onclick="SaveCurrency(1)">
                </div>
            </form>

            <form id="locationdiv" style="display:none">
                <div class="modal-body" style="overflow:auto;height:200px;">
                    @*<fieldset class="form-group floating-label-form-group">
                        <label for="grp">Code<span class="danger">*</span></label>
                        <input type="text" onkeyup="changetoupper(this.id),$('#LocationName').val($('#LocationCode').val())" id="LocationCode" class="form-control editds" name="Code">

                    </fieldset>
                    <br>
                    <fieldset class="form-group floating-label-form-group">
                        <label for="sbgroupname">Name<span class="danger">*</span></label>
                        <input type="text" id="LocationName" class="form-control editds" name="Name">
                    </fieldset>
                    <br>
                    <fieldset class="form-group floating-label-form-group">
                        <label for="sbgroupdesc">Description</label>
                        <input type="text" id="LocationDescription" class="form-control editds" name="Description">
                    </fieldset>*@

                    <div class="row">
                        <label style="font-weight:bold;margin-left:13%">Code<span class="danger">*</span></label>
                        <div class="col-md-5" style="margin-left:11.5%">
                            <input type="text" onkeyup="changetoupper(this.id),$('#LocationName').val($('#LocationCode').val())" id="LocationCode" class="form-control editds" name="Code">
                        </div>
                    </div>
                    <div class="row" style="margin-top:3%">
                        <label style="font-weight:bold;margin-left:13%">Name<span class="danger">*</span></label>
                        <div class="col-md-5" style="margin-left:10.5%">
                            <input type="text" id="LocationName" class="form-control editds" name="Name">
                        </div>
                    </div>
                    <div class="row" style="margin-top:3%">
                        <label style="font-weight:bold;margin-left:13%">Description</label>
                        <div class="col-md-5" style="margin-left:1.5%">
                            <input type="text" id="LocationDescription" class="form-control editds" name="Description">
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <input type="reset" style="margin-right:2%"  class="btn btn-outline-secondary" onclick="popuprefresh()" data-dismiss="modal" value="Close">
                    <input type="button" style="margin-right:35%" class="btn btn-outline-primary" value="Save" id="btnlocnsave" onclick="SaveLocation(1)">
                </div>
            </form>
        </div>
    </div>
</div>
<div id="PurchaseTransactionPopup" class="modal fade text-left show" tabindex="-1" role="dialog" aria-labelledby="PurchaseTransactionheader" style="padding-right: 17px; background:rgba(0,0,0,0.5); display: block; display:none">
    <div class="modal-dialog modal-xl" role="document" style="top:5%;">
        <div class="modal-content">
            <div class="modal-header bg-primary white">
                <h4 class="modal-title col-md-10" id="PurchaseTransactionheader"></h4>


                <div id="alltranscheckboxdiv" class="custom-control custom-checkbox col-md-1" style="display:none">
                    <input type="checkbox" class="custom-control-input" id="select_status" onchange="LastPurchaseTransactions()">
                    <label class="custom-control-label" for="select_status">All</label>
                </div>
                <div id="alltranscheckboxdivsales" class="custom-control custom-checkbox col-md-1" style="display:none">
                    <input type="checkbox" class="custom-control-input" id="select_status_sales" onchange="LastSalesTransactions()">
                    <label class="custom-control-label" for="select_status_sales">All</label>
                </div>
                <div id="alltranscheckboxdivPREV" class="custom-control custom-checkbox col-md-1" style="display:none">
                    <input type="checkbox" class="custom-control-input" id="select_status_PREV" onchange="lastalltrans()">
                    <label class="custom-control-label" for="select_status_PREV">Previous</label>
                </div>
                <button type="button" class="close" onclick="ClosePurTransPopup()" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                </button>
            </div>
            <section id="purchasetrans" style="display:none">
                <div class="row">
                    <div class="col-sm-12">
                        <div class="card-body">
                            <div class="card-block" style="overflow:scroll;width:100%;overflow:auto">
                                <div id="purchasetransdiv" class="" style="position: relative;overflow-y:scroll;width:100%;height:530px">
                                    <input type="hidden" id="transid" style="font-size:medium" />
                                    <table class="table table-responsive-md-md jsgrid-table compact table-bordered table-striped" id="tblpurchasetrans" style="width:100%;overflow-x:scroll;overflow-y:scroll;font-size:small"></table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </section>
            <section id="salestrans" style="display:none">
                <div class="row">
                    <div class="col-sm-12">

                        <div class="card-body">
                            <div class="card-block" style="overflow:scroll;width:100%;overflow:auto">
                                <div id="" class="" style="position: relative;overflow-y:scroll;overflow-x:auto;width:100%;height:530px;">
                                    <table class="table table-responsive-md-md jsgrid-table compact table-bordered table-striped" id="tblsalestrans" style="width:100%;overflow-y:scroll;font-size:small"></table>
                                </div>
                            </div>
                        </div>

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

            <section id="alltrans" style="display:none">
                <div class="row">
                    <div class="col-sm-12">
                        <div class="card-body">
                            <div class="card-block" style="overflow:scroll;width:100%;overflow:auto">
                                <div id="alltransdiv" class="jsgrid" style="position:relative;overflow-y:scroll;overflow-x:auto;width:100%;height:530px">
                                    <input type="hidden" id="alltransid" />
                                    <table class="table table-responsive-md-md jsgrid-table compact table-bordered table-striped" id="tblalltrans" style="width:100%;font-size:small"></table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </section>
        </div>
    </div>
</div>
<div id="productpdiv" style="display:none;border-radius: 25px;">
    <div id="toast-containerinfo" class="toast-container toast-top-half-width" style="position:absolute; top:0; right:0%;opacity:100">

        <div class="toast-primary" style="height:180px;margin-top:70px;font-weight:500;text-align:center;opacity:100;width:100%" id="infomessage">
            @*<h5 class="modal-title" id="prodheader"></h5>*@
            <button type="button" class="close" onclick="ProductPopuprefresh()" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">×</span>
            </button>
            <section id="productdiv" style="display:none;height:25%;">
                <div class="row">
                    <div class="col-sm-12">
                        <div class="card-body">
                            <input type="hidden" id="LPCost" value="0" />
                            <input type="hidden" id="AvgCost" value="0" />
                            <input type="hidden" id="Sumtotqty" value="0" />
                            <input type="hidden" id="LastSellingPrice" value="0" />
                            <div class="card-block" style="height:115px;width:100%;">
                                <table class="table table-responsive-md-md text-center" id="tblproductdetails"></table>
                            </div>
                        </div>
                    </div>
                </div>
            </section>



        </div>

    </div>
</div>
@*<div id="productpdiv" class="modal fade text-left show" tabindex="-1" role="dialog" aria-labelledby="jobheader" style="display:none;height:25%;">
        <div id="productpopupdiv" class="modal-dialog modal-llg" role="document" style="top:0%">
            <div class="modal-content">
                <div class="modal-header" style="background-color:#E0F3F4;">
                    <h5 class="modal-title" id="prodheader"></h5>
                    <button type="button" class="close" onclick="ProductPopuprefresh()" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">×</span>
                    </button>
                </div>
                <section id="productdiv" style="display:none;height:25%;">
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="card-body">
                                <input type="hidden" id="LPCost" value="0" />
                                <input type="hidden" id="AvgCost" value="0" />
                                <input type="hidden" id="Sumtotqty" value="0" />
                                <input type="hidden" id="LastSellingPrice" value="0" />
                                <div class="card-block" style="overflow:scroll;height:100px;width:100%;overflow:auto;">
                                    <table class="table table-responsive-md-md text-center" id="tblproductdetails"></table>
                                </div>
                            </div>
                        </div>
                    </div>
                </section>
            </div>
        </div>

    </div>*@
<div id="Enquirypopup" class="modal fade text-left show" tabindex="-1" role="dialog" aria-labelledby="OtherCostheader" style="padding-right: 17px; background:rgba(0,0,0,0.5); display: block; display:none">
    <div class="modal-dialog modal-llg" role="document" style="top:5%;">
        <div class="modal-content">
            <div class="modal-header bg-primary white">
                <h4 class="modal-title" id="Enquiryheader"></h4>
                <button type="button" class="close" onclick="CloseEnquiry(); ClearAll();" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                </button>
            </div>
            <form id="Enquirydiv" style="display:none;">
                <div class="modal-body">
                    <div class="table-responsive">
                        <div class="col-md-12">
                            <div class="row" style="background-color:#E0F3F4;">

                                <div class="col-md-1" style="margin-top:17px;text-align:left;">
                                    <label for="EnqFromDate">From Date</label>
                                </div>
                                <div class="col-md-2" style="margin-top:17px;">

                                    <input type="text" id="EnqFromDate" class="form-control" placeholder="From Date" style="height:35px;font-weight:200;">

                                </div>
                                <div class="col-md-1" style="margin-top:17px;text-align:right;">
                                    <label for="EnqToDate">To Date</label>
                                </div>
                                <div class="col-md-2" style="margin-top:17px;">
                                    <div class="form-group">
                                        <input type="text" id="EnqToDate" class="form-control" placeholder="To Date" style="height:35px;font-weight:200;">
                                    </div>
                                </div>
                                <div class="col-md-1" style="margin-top:17px;text-align:right;">
                                    <label for="EnqSupplier">Supplier</label>
                                </div>
                                <div class="col-md-3" style="margin-top:17px;">
                                    <div class="form-group">
                                        <input type="text" id="EnqSupplier" class="form-control" placeholder="Search Supplier" onkeypress="LoadSupplier('EnqSupplier')" onkeyup="$('#EnqSupplierId').val(0)" style="height:35px;font-weight:200;">
                                        <input type="hidden" id="EnqSupplierId" value="0" />
                                    </div>
                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="bb" onclick="SearchEnq()" class="btn btn-primary btn-min-width mr-1 mb-1 " style="position:absolute;width:100px;font-weight:400;">Search <i class="fa fa-search position-right"></i>  </button>
                                    </div>

                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="bc" onclick="ClearEnq()" class="btn btn-primary btn-min-width mr-1 mb-1" style="width:100px;font-weight:400;">Clear <i class="ft-refresh-cw position-right"> </i></button>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="overflow-auto" style="height:525px; ">
                            <table id="tblEnquiry" class="table table-striped table-bordered zero-configuration dataTable"></table>
                        </div>

                    </div>
                </div>
                <div class="modal-footer">

                    <input type="button" class="btn btn-outline-secondary" onclick="CloseEnquiry();ClearAll();" data-dismiss="modal" value="Close">
                </div>
            </form>
            <form id="Enquirydivsup" style="display:none;">
                <div class="modal-body">
                    <div class="table-responsive">
                        <div class="col-md-12">
                            <div class="row" style="background-color:#E0F3F4;">

                                <div class="col-md-1" style="margin-top:17px;text-align:left;">
                                    <label for="EnqFromDate1">From Date</label>
                                </div>
                                <div class="col-md-2" style="margin-top:17px;">

                                    <input type="text" id="EnqFromDate1" class="form-control" placeholder="From Date" style="height:35px;font-weight:200;">

                                </div>
                                <div class="col-md-1" style="margin-top:17px;text-align:right;">
                                    <label for="EnqToDate1">To Date</label>
                                </div>
                                <div class="col-md-2" style="margin-top:17px;">
                                    <div class="form-group">
                                        <input type="text" id="EnqToDate1" class="form-control" placeholder="To Date" style="height:35px;font-weight:200;">
                                    </div>
                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="bb1" onclick="SearchEnqSup()" class="btn btn-primary btn-min-width mr-1 mb-1 " style="position:absolute;width:100px;font-weight:400;">Search <i class="fa fa-search position-right"></i>  </button>
                                    </div>

                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="bc1" onclick="ClearEnqSup()" class="btn btn-primary btn-min-width mr-1 mb-1" style="width:100px;font-weight:400;">Clear <i class="ft-refresh-cw position-right"> </i></button>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="overflow-auto" style="height:525px; ">
                            <table id="tblEnquirysup" class="table table-striped table-bordered zero-configuration dataTable"></table>
                        </div>
                        <input type="hidden" id="RowGetEnquiry" />
                    </div>
                </div>
                <div class="modal-footer">

                    <input type="button" class="btn btn-outline-secondary" onclick="CloseEnquiry(); ClearAll();" data-dismiss="modal" value="Close">
                    <input type="button" class="btn btn-outline-primary" value="View" id="btnview" onclick="ViewEnquiryWithSupplier()">
                </div>
            </form>
            <form id="Enquirydivsub" style="display:none;">
                <div class="modal-body">
                    <div class="table-responsive">
                        <div class="col-md-12">
                            <div class="row" style="background-color:#E0F3F4;">

                                <div class="col-md-1" style="margin-top:17px;text-align:center;">
                                    <label for="ProductPopUp1">Product</label>
                                </div>
                                <div class="col-md-3" style="margin-top:17px;">
                                    <div class="form-group">
                                        <input type="text" id="ProductPopUp1" class="form-control" style="height:35px;font-weight:200;" onkeypress="ProductLoad('ProductPopUp1')" onkeydown="$('#ProductPopUp1Id').val(0)">
                                        <input type="hidden" id="ProductPopUp1Id" class="form-control" value="0">
                                    </div>
                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="bb2" onclick="SearchEnqSub(1)" class="btn btn-primary btn-min-width mr-1 mb-1 " style="position:absolute;width:100px;font-weight:400;">Search <i class="fa fa-search position-right"></i>  </button>
                                    </div>

                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="bc2" onclick="SearchEnqSub(0)" class="btn btn-primary btn-min-width mr-1 mb-1" style="width:100px;font-weight:400;">Clear <i class="ft-refresh-cw position-right"> </i></button>
                                    </div>
                                </div>
                            </div>
                        </div>

                        <div class="overflow-auto" style="height:525px; ">
                            <table id="tblEnquirypsub" class="table table-striped table-bordered zero-configuration dataTable"></table>
                        </div>
                        <input type="hidden" id="RowGetEnquiry1" />
                    </div>
                </div>
                <div class="modal-footer">

                    <input type="button" class="btn btn-outline-secondary" onclick="EnquiryBack();" data-dismiss="modal" value="Back">
                    <input type="button" class="btn btn-outline-primary" value="Add" id="btnprdtadd" onclick="EnquiryProductAdd()">
                </div>
            </form>
            <form id="OrderdivSup" style="display:none;">
                <div class="modal-body">
                    <div class="table-responsive">
                        <div class="col-md-12">
                            <div class="row" style="background-color:#E0F3F4;">

                                <div class="col-md-1" style="margin-top:17px;text-align:left;">
                                    <label for="OrderFromDate">From Date</label>
                                </div>
                                <div class="col-md-2" style="margin-top:17px;">

                                    <input type="text" id="OrderFromDate" class="form-control" placeholder="From Date" style="height:35px;font-weight:200;">

                                </div>
                                <div class="col-md-1" style="margin-top:17px;text-align:right;">
                                    <label for="OrderToDate">To Date</label>
                                </div>
                                <div class="col-md-2" style="margin-top:17px;">
                                    <div class="form-group">
                                        <input type="text" id="OrderToDate" class="form-control" placeholder="To Date" style="height:35px;font-weight:200;">
                                    </div>
                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="po1" onclick="SearchOrderSup()" class="btn btn-primary btn-min-width mr-1 mb-1 " style="position:absolute;width:100px;font-weight:400;">Search <i class="fa fa-search position-right"></i>  </button>
                                    </div>

                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="po2" onclick="ClearOrderSup()" class="btn btn-primary btn-min-width mr-1 mb-1" style="width:100px;font-weight:400;">Clear <i class="ft-refresh-cw position-right"> </i></button>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="overflow-auto" style="height:525px; ">
                            <table id="tblOrderSup" class="table table-striped table-bordered zero-configuration dataTable"></table>
                        </div>
                        <input type="hidden" id="RowGetOrder" />
                    </div>
                </div>
                <div class="modal-footer">

                    <input type="button" class="btn btn-outline-secondary" onclick="CloseEnquiry(); ClearAll();" data-dismiss="modal" value="Close">
                    <input type="button" class="btn btn-outline-primary" value="View" id="btnvieworder" onclick="ViewOrderWithSupplier()">
                </div>
            </form>
            <form id="OrderdivSub" style="display:none;">
                <div class="modal-body">
                    <div class="table-responsive">
                        <div class="col-md-12">
                            <div class="row" style="background-color:#E0F3F4;">

                                <div class="col-md-1" style="margin-top:17px;text-align:center;">
                                    <label for="ProductPopUp2">Product</label>
                                </div>
                                <div class="col-md-3" style="margin-top:17px;">
                                    <div class="form-group">
                                        <input type="text" id="ProductPopUp2" class="form-control" style="height:35px;font-weight:200;" onkeypress="ProductLoad('ProductPopUp2')" onkeydown="$('#ProductPopUp2Id').val(0)">
                                        <input type="hidden" id="ProductPopUp2Id" class="form-control" value="0">
                                    </div>
                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="bb3" onclick="SearchOrderSub(1)" class="btn btn-primary btn-min-width mr-1 mb-1 " style="position:absolute;width:100px;font-weight:400;">Search <i class="fa fa-search position-right"></i>  </button>
                                    </div>

                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="bc3" onclick="SearchOrderSub(0)" class="btn btn-primary btn-min-width mr-1 mb-1" style="width:100px;font-weight:400;">Clear <i class="ft-refresh-cw position-right"> </i></button>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="overflow-auto" style="height:525px; ">
                            <table id="tblOrderSub" class="table table-striped table-bordered zero-configuration dataTable"></table>
                        </div>
                        <input type="hidden" id="RowGetOrder1" />
                    </div>
                </div>
                <div class="modal-footer">

                    <input type="button" class="btn btn-outline-secondary" onclick="OrderBack();" data-dismiss="modal" value="Back">
                    <input type="button" class="btn btn-outline-primary" value="Add" id="btnPrdctaddPO" onclick="OrderProductAdd()">
                </div>
            </form>
            <form id="InvoicedivSup" style="display:none;">
                <div class="modal-body">
                    <div class="table-responsive">
                        <div class="col-md-12">
                            <div class="row" style="background-color:#E0F3F4;">

                                <div class="col-md-1" style="margin-top:17px;text-align:left;">
                                    <label for="InvoiceFromDate">From Date</label>
                                </div>
                                <div class="col-md-2" style="margin-top:17px;">

                                    <input type="text" id="InvoiceFromDate" class="form-control" placeholder="From Date" style="height:35px;font-weight:200;">

                                </div>
                                <div class="col-md-1" style="margin-top:17px;text-align:right;">
                                    <label for="InvoiceToDate">To Date</label>
                                </div>
                                <div class="col-md-2" style="margin-top:17px;">
                                    <div class="form-group">
                                        <input type="text" id="InvoiceToDate" class="form-control" placeholder="To Date" style="height:35px;font-weight:200;">
                                    </div>
                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="in1" onclick="SearchInvoiceSup()" class="btn btn-primary btn-min-width mr-1 mb-1 " style="position:absolute;width:100px;font-weight:400;">Search <i class="fa fa-search position-right"></i>  </button>
                                    </div>

                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="in2" onclick="ClearInvoiceSup()" class="btn btn-primary btn-min-width mr-1 mb-1" style="width:100px;font-weight:400;">Clear <i class="ft-refresh-cw position-right"> </i></button>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="overflow-auto" style="height:525px; ">
                            <table id="tblInvoiceSup" class="table table-striped table-bordered zero-configuration dataTable"></table>
                        </div>
                        <input type="hidden" id="RowGetInvoice" />
                    </div>
                </div>
                <div class="modal-footer">

                    <input type="button" class="btn btn-outline-secondary" onclick="CloseEnquiry(); ClearAll();" data-dismiss="modal" value="Close">
                    <input type="button" class="btn btn-outline-primary" value="View" id="btnviewinvoice" onclick="ViewInvoiceWithSupplier()">
                </div>
            </form>
            <form id="InvoicedivSub" style="display:none;">
                <div class="modal-body">
                    <div class="table-responsive">
                        <div class="col-md-12">
                            <div class="row" style="background-color:#E0F3F4;">

                                <div class="col-md-1" style="margin-top:17px;text-align:center;">
                                    <label for="ProductPopUp3">Product</label>
                                </div>
                                <div class="col-md-3" style="margin-top:17px;">
                                    <div class="form-group">
                                        <input type="text" id="ProductPopUp3" class="form-control" style="height:35px;font-weight:200;" onkeypress="ProductLoad('ProductPopUp3')" onkeydown="$('#ProductPopUp3Id').val(0)">
                                        <input type="hidden" id="ProductPopUp3Id" class="form-control" value="0">
                                    </div>
                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="bb4" onclick="SearchInvoiceSub(1)" class="btn btn-primary btn-min-width mr-1 mb-1 " style="position:absolute;width:100px;font-weight:400;">Search <i class="fa fa-search position-right"></i>  </button>
                                    </div>

                                </div>
                                <div class="col-md-1" style="margin-top:16px;">
                                    <div class="form-group">
                                        <button type="button" id="bc4" onclick="SearchInvoiceSub(0)" class="btn btn-primary btn-min-width mr-1 mb-1" style="width:100px;font-weight:400;">Clear <i class="ft-refresh-cw position-right"> </i></button>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="overflow-auto" style="height:525px; ">
                            <table id="tblInvoiceSub" class="table table-striped table-bordered zero-configuration dataTable"></table>
                        </div>
                        <input type="hidden" id="RowGetInvoice1" />
                    </div>
                </div>
                <div class="modal-footer">

                    <input type="button" class="btn btn-outline-secondary" onclick="InvoiceBack();" data-dismiss="modal" value="Back">
                    <input type="button" class="btn btn-outline-primary" value="Add" id="btnPrdctInvoice" onclick="InvoiceProductAdd()">
                </div>
            </form>


        </div>
    </div>

</div>

<div id="confirmff" class="overlay" style="display:none;">
    <div class="modal fade text-left show" id="keyboardff" tabindex="-1" role="dialog" aria-labelledby="myModalLabel3" style="display:none;padding-right: 17px; top:28%;">
        <div class="modal-dialog" role="document">
            <div class="modal-content">

                <div class="modal-body" style="text-align:center">
                    <h3 style="color:red"><B>ADD ENQUIRY NUMBER !!!</B></h3>
                </div>

            </div>

        </div>

    </div>
</div>

<div style="display:none">
    <input type="text" value="0" id="EnquiryNo" />
    <input type="text" value="0" id="PurchaseEnquirySubId" />
</div>


<div style="margin-bottom:0%" class="row col-md-12">
    <h6 class="col-md-1" style="font-size:medium;color:white;text-align:left;font-weight:500">Save : Alt+S</h6>
    <h6 class="col-md-1" style="font-size:medium;color:white;text-align:left;font-weight:500">Copy : Alt+C</h6>
    <h6 class="col-md-1" style="font-size:medium;color:white;text-align:left;font-weight:500">New  : Alt+N</h6>
    <h6 class="col-md-2" style="font-size:medium;color:white;text-align:left;font-weight:500">Close Popups  : Esc</h6>
    <h6 class="col-md-2" style="font-size:medium;color:white;text-align:left;font-weight:500;margin-left:-4%">Last Sales Transactions : F7</h6>
    <h6 class="col-md-3" style="font-size:medium;color:white;text-align:left;font-weight:500;">Last Purchase Transactions : F8</h6>
    <h6 class="col-md-2" style="font-size:medium;color:white;text-align:left;font-weight:500;margin-left:-4%">All Transactions : F9</h6>

</div>


<div class="modal fade text-left show" id="iconForm" tabindex="-1" role="dialog" aria-labelledby="headiddetialls" style="padding-right: 17px; display: none;background:rgba(0,0,0,0.5);height:1800px;">
    <div class="modal-dialog modal-lg" role="document">
        <div class="modal-content" style="width:180%; margin-left:-270px;">
            <div class="modal-header bg-primary white">
                <h4 class="modal-title" id="headiddetialls">Purchase Analysis</h4>
                <div style="float:right;margin-left:70%" id="allPA"   class="custom-control custom-checkbox col-md-1">
                    <input type="checkbox" class="custom-control-input" id="status_type" onchange="CheckPA()">
                    <label class="custom-control-label" for="status_type" id="idforlabeltype">All</label>
                </div>
                <button type="button" class="close" data-dismiss="modal" onclick="$('#iconForm').hide();" aria-label="Close">
                    <span aria-hidden="true">×</span>
                </button>
            </div>
            <div id="View">
                <div class="modal-body">

                    <div id="div1" style="height:500px;overflow:auto;">
                        <table id="Stocklist" class="table table-striped table-bordered zero-configuration dataTable"></table>
                    </div>
                </div>
                <div class="modal-footer">
                    <input type="hidden" id="RowGet" />
                    <input type="button" id="btnaddtogrid" class="btn btn-outline-primary btn-lg" style="height:45px;width:75px" onclick="Addtogrid()" value="Add">
                    <input type="button" id="btn1" class="btn btn-outline-secondary btn-lg" style="height:45px;width:75px" onclick="$('#iconForm').hide();" value="close">
                </div>
            </div>

        </div>
    </div>

</div>
<div id="alertpopup" class="modal fade text-left show" tabindex="-1" role="dialog" aria-labelledby="myheader" style="padding-right: 17px; background:rgba(0,0,0,0.5); display: block; display:none">
    <div class="modal-dialog" role="document" style="top:25%">
        <div class="modal-content" style="width:600px">
            <form id="alertdiv" style="">
                <div class="modal-body">
                    <div class="row">
                        <div class="placeholder"></div>
                        <div class="col-md-12" style="overflow:scroll;height:auto;width:100%;overflow:auto;">
                            <div class="swal2-icon swal2-success animate" style="display: block;"><span class="line tip animate-success-tip"></span> <span class="line long animate-success-long"></span><div class="placeholder"></div> <div class="fix"></div></div>
                            <br />
                            <h2 id="savealert" class="text-center"></h2>

                            <hr />
                        </div>
                    </div>
                    <div class="text-right">
                        <input type="button" class="btn btn-primary btn-sizebig" value="Print" id="btnok">
                        <input type="button" class="btn btn-outline-primary btn-sizebig" value="Cancel" id="btncnclalrt">
                    </div>

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



<div id='modal_dialog' class="overlay" style="display: none;">
    <div class="modal fade text-left show" id="keyboard" tabindex="-1" role="dialog" aria-labelledby="myModalLabel3" style="display: block; padding-right: 17px; top:25%">
        <div class="modal-dialog" role="document">
            <div class="modal-content">

                <div class="modal-body">
                    <div class="swal-icon swal-icon--warning">
                        <span class="swal-icon--warning__body">
                            <span class="swal-icon--warning__dot"></span>
                        </span>
                    </div>
                    <div id="soldmessage" class="swal-title" style="">Product already added.Do you want to continue?</div>
                </div>
                <div class="modal-footer">
                    <button type="button" id="btnNo" class="btn btn-outline-primary btn-sizebig" autofocus="" autocomplete="off">Cancel</button>
                    <button type="button" onclick="" id="btnYes" class="btn btn-outline-primary btn-sizebig" autocomplete="off">Ok</button>
                </div>
            </div>
        </div>
    </div>
</div>

<div id="anoproductpopuo" class="modal fade text-left show" tabindex="-1" role="dialog" aria-labelledby="myheader" style="padding-right: 17px; background:rgba(0,0,0,0.5); display: block; display:none">
    <div class="modal-dialog" role="document" style="top:20%">
        <div class="modal-content" style="width:600px">
            <form id="" style="">
                <div class="modal-body">
                    <div class="row">
                        <div class="col-md-12" style="overflow:scroll;height:auto;width:100%;overflow:auto;">
                            <table class="table table-responsive-md-md text-center" id="tblAlert"></table>
                        </div>
                    </div>
                    <div class="text-right">
                        <input type="button" class="btn btn-outline-primary" value="Ok" id="btnokalert" onclick="alertpopuprefresh()">
                    </div>

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


<div id="PendingPurchaseTransactionPopup" class="modal fade text-left show" tabindex="-1" role="dialog" aria-labelledby="PurchaseTransactionheader" style="padding-right: 17px;background:rgba(0,0,0,0.5); display: block;margin-top:0%;display: none;">
    <div class="modal-dialog modal-lg" role="document" style="margin-top:100px;margin-left:250px">
        <div class="modal-content" style="width:180%;">
            <div class="modal-header bg-primary white">
                <h4 class="modal-title col-md-10" id="PendingPurchaseTransactionheader"></h4>

                <div id="allpendingcheckboxdiv" class="custom-control custom-checkbox col-md-1" style="display:none">
                    <input type="checkbox" class="custom-control-input" id="select_statuspending" onchange="PendingPurchasespopup($('#productId_0').val())">
                    <label class="custom-control-label" for="select_statuspending">All</label>
                </div>

                <button type="button" class="close" onclick="ClosePendingPurTransPopup()" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                </button>
            </div>
            <section id="pendingpurchasetrans" style="display:none">
                <div class="row">
                    <div class="col-sm-12">
                        <div class="card-body">
                            <div class="row">
                                <div class="col-md-1"></div>
                                <div class="col-md-3">
                                    <label style="font-weight:bold">Total Pending :</label>
                                    <label style="font-weight:bold" id="totalpending"></label>
                                </div>
                                <div class="col-md-4"></div>
                                <div class="col-md-3">
                                    <label style="font-weight:bold">Total In transit Qty. :</label>
                                    <label style="font-weight:bold" id="totalintransit"></label>
                                </div>
                                <div class="col-md-1"></div>


                            </div>
                            <div class="card-block" style="overflow:scroll;width:100%;overflow:auto">
                                <div id="" class="jsgrid" style="position: relative;overflow-y:scroll;width:100%;height:530px">
                                    <input type="hidden" id="pendingtransid" />
                                    <table class="table table-responsive-md-md jsgrid-table compact table-bordered table-striped" id="tblpendingpurchasetrans" style="width:100%;overflow-x:scroll;overflow-y:scroll;font-size:small"></table>
                                </div>
                            </div>


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


<table id="tbExport" style="display:none"></table>


<script>
    function exportbilltotable() {
        var row = ""
        var EnqDate = $('#enquirydate').val();
        var EnqNo = $("#CopyEnquiryno").val(); var Supplier = $("#suppliername").val();

        row += '<tr><td><b>PE#</b></td><td><b>' + EnqNo + '</b></td><td><b>Enq.Date#<b></td><td><b>' + EnqDate + '</b></td></tr>';
        row += '<tr><td></td><td></td><td><b>Supplier</b></td><td><b>' + Supplier + '</b></td></tr>';
        row +='<tr></tr>'
        row += '<tr><td><b>Sl#</b></td><td><b>Item Code</b></td><td><b>Description</b></td><td><b>Quantity</b></td><td><b>Model</b></td></tr>'

        var Slno = 0;
        for (k = 1; k <= $('#tblpurchase_enquiry tr').length; k++) {
            Slno++;
            var ItemCode = $('#product_' + k).val();
            var Description = $('#productdesc_' + k).val();
            var Qunatity = $('#quantity_' + k).val();
            var Model = $('#Models_' + k).val();

         

            row += '<tr><td>' + Slno + '</td><td>' + ItemCode + '</td><td>' + Description + '</td><td>' + Qunatity + '</td><td>' + Model + '</td></tr>'
        }
        $('#tbExport').html('')
        $('#tbExport').append(row);
    }



    $(function () {
        $("#btnExporttoExcel").click(function () {

            if ($('#tblpurchase_enquiry tr').length > 0 && $("#CopyEnquiryno").val()!='') {
                exportbilltotable();
                var PENo = 'PE#-' + $('#CopyEnquiryno').val();
                $("#tbExport").table2excel({
                    filename: PENo + ".xls"
                });
            }
            else if ($('#tblpurchase_enquiry tr').length > 0 && $("#CopyEnquiryno").val() == '')
            {
                warningshow('Select a Valid Enquiry Number!', 'CopyEnquiryno');
                return false;
            }
            else {
                warningshow("No Transaction!");
            }
        });

    });



    $("#customView").on("scroll", function () {
        $("#proddiv").scrollLeft($(this).scrollLeft());
    });

    $("#btnadd").focus(function (e) {
        $("#btnadd").removeClass("btn btn-outline-primary");
        $("#btnadd").addClass("btn btn-primary");
    });

    $("#btnadd").focusout(function (e) {
        $("#btnadd").removeClass("btn btn-outline-primary");
        $("#btnadd").addClass("btn btn-outline-primary");
    });
    $("#btncnclsave").focus(function (e) {
        $("#btncnclsave").removeClass("btn btn-outline-warning");
        $("#btncnclsave").addClass("btn btn-warning");
    });

    $("#btncnclsave").focusout(function (e) {
        $("#btncnclsave").removeClass("btn btn-warning");
        $("#btncnclsave").addClass("btn btn-outline-warning");
    });
    //Supplier AutoComplete

    $("#suppliername").autocomplete({
        delay: 0,
        minLength: 0,
        source: function (request, response) {
            var data = {};
            data.CustName = $("#suppliername").val();
            data.CustType ='S';

            $.ajax({
                url: '../Master/CustomerOrSupplierSearch',
                type: "POST",
                data: data,
                dataType: "json",
                success: function (data) {

                    response($.map(data, function (item) {
                        return ({
                            ColCount: '-2ph',
                            label: item.CustName,
                            label1: item.CustAccount,
                            label2: item.PhoneNumber,
                            CustId: item.CustId,
                            CurncyId: item.CurrencyId,
                            headers: ["Supplier Name", "Account Code", "Phone Number"]
                        })
                    }));
                }

            })

        },
        autoFocus: true,
        select: function (event, ui) {
            $('#supplierId').val(ui.item.CustId);
            GetCurrency(ui.item.CurncyId)
        },

    });

    //Product AutoComplete

    function LoadProduct() {
        $("#product_0").autocomplete({
            delay: 0,
            minLength: 0,
            source: function (request, response) {
                var data = {};
                data.ItemCode = $("#product_0").val();

                $.ajax({
                    url: '../Purchase/ProductSearch',
                    type: "POST",
                    data: data,
                    dataType: "json",
                    success: function (data) {

                        response($.map(data, function (item) {
                            return ({
                                ColCount: '4',
                                label: item.ItemCode,
                                label1: item.Description,
                                label2: item.UnitName,
                                label3: item.SellingPrice.toFixed(Decimal),
                                label4: '0',
                                label5: '0',
                                ItemId: item.ItemId,
                                ItemCode:item.ItemCode,
                                Description: item.Description,
                                Unit: item.UnitId,
                                UnitName: item.UnitName,
                                Tax: item.VatId,
                                Taxper: item.VatPer,
                                Rate: (item.SellingPrice).toFixed(Decimal),
                                headers: ["Item Code", "Description", "Unit Name", "Average Cost"]
                            })
                        }));
                    }

                })

            },
            autoFocus: true,
            //response: function (event, ui) {
            //    if (ui.content.length == 1) {
            //        ui.item = ui.content[0];
            //        $(this).data('ui-autocomplete')._trigger('select', 'autocompleteselect', ui);
            //        $(this).autocomplete('close');
            //    }
            //},
            select: function (event, ui) {
                var ProdFlag = 0;
                var allow = 0;

                for (var p = 1; p <= i; p++) {
                    if (ui.item.ItemId == $('#productId_' + p).val()) {
                        ProdFlag = 1;
                    }
                }

                if (ProdFlag == 0) {
                    $("#product_0").val(ui.item.ItemCode);
                    $('#productId_0').val(ui.item.ItemId);
                    $('#ProductLength').val((ui.item.ItemCode).length);
                    $('#productdesc_0').val(ui.item.Description);
                    $('#unit_0').val(ui.item.Unit);
                    $('#txtunit_0').val(ui.item.UnitName);
                    if ($('#purchasetype').val() != 'Import') {
                        $('#tax_0').val(ui.item.Tax);
                        $('#taxpercentage_0').val(ui.item.Taxper);
                    }
                    $('#txtrate_0').val(ui.item.Rate);
                    $('#quantity_0').val(1);
                    $('#quantity_0').focus();
                    $('#quantity_0').select();
                    CalcAmount(0);

                    var data = {};
                    data.ProductId = ui.item.ItemId;
                    data.CustId = 0;
                    data.DeptId = DepId;
                    $.ajax({
                        type: "POST",
                        url: '../SalesInvoice/CustomerProductDetailsSearch',
                        data: data,
                        success: function (result) {
                            ProductPopuprefresh();
                            CustPrdctLoad(result.oList);
                        }
                    })
                }
                else if (ProdFlag == 1) {
                    //  $("#txtproduct0,#select_location0,#select_unit0,#txtquantity0,#txtrate0,#txtdiscount0,#select_tax0").blur();
                    $('#modal_dialog').show();
                    $('#btnNo').focus();

                    dialog(function () {        // Ok Button

                        $('#modal_dialog').hide();
                        $('#txtquantity0').focus();

                        //Select Begin
                        $("#product_0").val(ui.item.ItemCode);
                        $('#productId_0').val(ui.item.ItemId);
                        $('#ProductLength').val((ui.item.ItemCode).length);
                        $('#productdesc_0').val(ui.item.Description);
                        $('#unit_0').val(ui.item.Unit);
                        $('#txtunit_0').val(ui.item.UnitName);
                        if ($('#purchasetype').val() != 'Import') {
                            $('#tax_0').val(ui.item.Tax);
                            $('#taxpercentage_0').val(ui.item.Taxper);
                        }
                        $('#txtrate_0').val(ui.item.Rate);
                        $('#quantity_0').val(1);
                        $('#quantity_0').focus();
                        $('#quantity_0').select();
                        CalcAmount(0);

                        var data = {};
                        data.ProductId = ui.item.ItemId;
                        data.CustId = 0;
                        data.DeptId = DepId;
                        $.ajax({
                            type: "POST",
                            url: '../SalesInvoice/CustomerProductDetailsSearch',
                            data: data,
                            success: function (result) {
                                ProductPopuprefresh();
                                CustPrdctLoad(result.oList);
                            }
                        })

                        //Select end

                    },
                 function () {               // Cancel Button

                     $('#modal_dialog').hide();
                     ClearProductRow();
                     return false;
                 }
                );
                }
                document.getElementById("toast-containerinfo").style.zIndex = "2";
            },
        });
    }

    //Confirmbox Function work as browser confirm function
    function dialog(yesCallback, noCallback) {
        $('#btnYes').click(function () {
            yesCallback();
        });
        $('#btnNo').click(function () {
            noCallback();
        });
    }

   
    function CheckPA() {
   
        if ($('#status_type').prop("checked"))
            var flag = 1;
        else
            var flag = 0;
        var CustId = $('#supplierId').val();
        var data = {};
        data.SupplierId = CustId;
        data.DeptId = ERPDeptId;
        data.Flag = flag;
        $.ajax({
            type: "POST",
            url: "../MonthlyPurchaseAnalysis/PurchaseAnalysisListGet",
            data: data,
            success: function (result) {
                $('#iconForm').show();
                ItemLoad(result.oList);
            }
        });
    }

    //Copy or Purchase Invoice Autocomplete

    $("#CopyEnquiryno").autocomplete({
        delay: 0,
        minLength: 0,
        source: function (request, response) {
            var data = {};
            data.EnquiryNo = $("#CopyEnquiryno").val();
            data.LocnId = ULocId;
            data.DepartmentId = DepId;

            $.ajax({
                url: '../Purchase/EnquiryNoSearch',
                type: "POST",
                data: data,
                dataType: "json",
                success: function (data) {

                    response($.map(data, function (item) {
                        return ({
                            ColCount: '+3',
                            label: item.EnquiryNo,
                            label1: item.EnquiryDate,
                            label2: item.SupplierName,
                            EnquiryNo: item.EnquiryNo,
                            headers: ["Enquiry No", "Date", "Supplier"]

                        })
                    }));
                }
            })
        },
        autoFocus: true,
        select: function (event, ui) {
            var data = {};
            data.EnquiryNo = ui.item.EnquiryNo;
            data.DepartmentId = DepId;
            $.ajax({
                type: "POST",
                url: "../Purchase/PurchaseEnquiryGetandGets",
                data: data,
                success: function (result) {
                    formrefresh(1);
                    PurchaseEnquiryGets(result.oList);
                    $('#btnnew').focus();
                    $('.form-control').prop('disabled', true);
                    $('#CopyEnquiryno').prop("disabled", false);
                    $('.jsgrid-button').prop('disabled', true);
                    $('#btnsubmit').prop("disabled", true);
                    $('#btnlist').prop("disabled", true);
                    $('#btnadd').prop("disabled", true);



                    $("#btnnew").show();
                }
            });
        },

    });


    function LoadSupplier(Id) {
        $("#" + Id).autocomplete({
            delay: 0,
            minLength: 0,
            source: function (request, response) {
                var data = {};
                data.CustName = $("#" + Id).val();
                data.CustType = 'S';

                $.ajax({
                    url: '../Master/CustomerOrSupplierSearch',
                    type: "POST",
                    data: data,
                    dataType: "json",
                    success: function (data) {

                        response($.map(data, function (item) {
                            return ({
                                ColCount: '-2',
                                label: item.CustName,
                                label1: item.CustAccount,
                                CustId: item.CustId,
                                Address: item.CustStreet2 + '\n' + item.CustCity2 + '\n' + item.CustState2 + '\n' + item.CustCountry2,
                                CurncyId: item.CurrencyId,
                                CustTermsId: item.CustTermsId,
                                headers: ["Supplier Name", "Account Code"]
                            })
                        }));
                    }

                })

            },
            autoFocus: true,
            select: function (event, ui) {
                $('#' + Id + 'Id').val(ui.item.CustId);
                $('#bb').focus();

            },

        });
    }

    function ProductLoad(Id) {
        $("#" + Id).autocomplete({
            delay: 0,
            minLength: 0,
            source: function (request, response) {
                var data = {};
                data.ItemCode = $("#" + Id).val();

                $.ajax({
                    url: '../Purchase/ProductSearch',
                    type: "POST",
                    data: data,
                    dataType: "json",
                    success: function (data) {
                        response($.map(data, function (item) {
                            return ({
                                ColCount: 'TWO',
                                label: item.ItemCode,
                                label1: item.Description,
                                ItemId: item.ItemId,
                                headers: ["Item Code", "Description"]
                            })
                        }));
                    }

                })

            },
            autoFocus: true,
            select: function (event, ui) {
                $('#' + Id + 'Id').val(ui.item.ItemId);
                if (Id == 'ProductPopUp1') {
                    $('#bb2').focus();
                }
                else if (Id == 'ProductPopUp2') {
                    $('#bb3').focus();
                }
                else if (Id = 'ProductPopUp3') {
                    $('#bb4').focus();
                }

            },
        });
    }

    $(function () {


        $('#enquirydate,#EnqFromDate,#EnqToDate,#EnqFromDate1,#EnqToDate1,#OrderFromDate,#OrderToDate,#InvoiceFromDate,#InvoiceToDate,#ViewFromDate,#ViewToDate').daterangepicker({
            minDate: minDate,
            maxDate: new Date(new Date().getFullYear(), new Date().getMonth(), new Date().getDate()),
            singleDatePicker: true,
            showDropdowns: true,
            locale: {
                format: 'DD/MM/YYYY'
            }

        });
        $("#btnallow").click(function (e) {
            if ($('#status_type').prop("checked"))
                var flag = 1;
            else
                var flag = 0;

            if ($('#suppliername').val() != '') {
                var CustId = $('#supplierId').val();
                var data = {};
                data.SupplierId = CustId;
                data.DeptId = ERPDeptId;
                data.Flag = flag;
                $.ajax({
                    type: "POST",
                    url: "../MonthlyPurchaseAnalysis/PurchaseAnalysisListGet",
                    data: data,
                    success: function (result) {
                        $('#iconForm').show();
                        ItemLoad(result.oList);
                    }
                });
            }
            else
            {
                warningshow('Please Select Supplier', 'suppliername');
            }

        });

    });
    function ItemLoad(result) {
        disable_datatable('Stocklist');
        var responseText = "";
       // if (result.length != 0) {
            var responseText = "<thead><tr><th style='width:10%;'> <input type='checkbox'  checked  id= 'SlNoHeadCheckItem' onchange='selectall()' 'custom-control-input cz-bg-image-display'> Select</th>"+
                "<th>SlNo</th>" +
                 "<th style=display:none;></th><th>Item Code</th>" +
                "<th>Item Name</th><th style=display:none;></th><th>Unit</th>" +
                "<th>Quantity</th>" +
                 "<th>Purchase Cost</th><th style=display:none;></th><th>Location</th>"+
                 "<th style=display:none></th><th style=display:none;></th><th style=display:none;></th><th style=display:none;></th></tr>" +
                 "<tr><th style='width:10%;'> </th><th >Slno</th><th style=display:none;></th><th>ItemCode</th><th>Item Name</th><th style=display:none;></th><th>Unit</th><th>Quantity</th><th>Purchase Cost</th><th style=display:none;></th><th>Location</th><th style=display:none;></th><th style=display:none;></th><th style=display:none;></th><th style=display:none;></th></tr>" +
                "</thead><tbody>";
            for (var l = 0; l < result.length; l++) {
                var slno = parseInt(l + 1);
                responseText += '<tr><td style="width:10%;"><input type="checkbox"  checked  id= ' + 'SlNoCheckgrid' + slno + ' ></td><td style="width:5%;text-align:center">' + slno + '</td>'+
                     '<td style="display:none;" id= ' + 'ProductIdgrid' + slno + '>' + result[l].ItemId + '</td>' +
                    '<td id= ' + 'Product' + slno + '>' + result[l].ItemCode + '</td>' +
                    '<td id= ' + 'Des' + slno + '>' + result[l].Description + '</td>' +
                     '<td style="display:none;" id= ' + 'UnitIdgrid' + slno + '>' + result[l].UnitId + '</td>' +
                     '<td id= ' + 'UnitName' + slno + '>' + result[l].UnitName + '</td>' +
                    '<td id= ' + 'qty_' + slno + '>' + result[l].OrderQty + '</td>' +
                    '<td id= ' + 'rte_' + slno + '>' + (parseFloat(result[l].PurchaseCost).toFixed(Decimal)) + '</td>' +
                    '<td style="display:none;" id= ' + 'locnid' + slno + '>' + result[l].LocationId + '</td>' +
                    '<td id= ' + 'Loc' + slno + '>' + result[l].LocationName + '</td>' +
                '<td style="display:none;" id= ' + 'taxid' + slno + '>' + result[l].VatId + '</td><td style="display:none;" id= ' + 'taxrate' + slno + '>' + result[l].TaxRate + '</td>'+
                '<td style="display:none;" id= ' + 'purchaseanalysisid' + slno + '>' + result[l].PurchaseAnalysisId + '</td>'+
                '<td style="display:none;" id= ' + 'Model1' + slno + '>' + result[l].Model1 + '</td>' +
                 '</tr>';
            }
      //  }
        //else {
        //    var responseText = '<tr><td colspan=12 class="text-center"></br></br></br><b>NO DATA FOUND</b></br></br></br></br></td><tr>';
        //}
        $('#Stocklist').html(responseText + '</tbody>');
        datatablesearch('Stocklist', 'Multiple');
        $('#RowGet').val(result.length);
        $('#div1').animate({ scrollTop: 0 });
    }


    function datatablesearch(tablename, Type) {

        var a = '#' + tablename + ' tr:eq(1) th'

        $(a).each(function () {
            var title = $(this).text();
            if (title != ' ')
                if (title != 'SlNo' || title == 'Booking Number' || title == 'Lines' || title == 'Size' || title == 'Point Of Loading' || title == 'Port' || title == 'ExpectArrival Date' || title == 'Release Date') {
                    $(this).html('<input type="text" class="form-control"  style="width:120px"  placeholder="' + title + '"/>')
                }
                else {
                    $(this).html('<input type="text" class="form-control" style="font-weight:100"   placeholder="' + title + '"/>')
                }
        });
        var table = null;

        if (Type == 'Single') {

            table = $('#' + tablename).DataTable({
                dom: 'tipr',
                orderCellsTop: true,
                //"order": false,
            });
        }
        else if (Type == 'Multiple') {

            table = $('#' + tablename).DataTable({
                dom: 'tir',
                orderCellsTop: true,
                //"order": false,
                "pageLength": -1
            });
        }
        table.columns().every(function (index) {
            $('#' + tablename + ' thead tr:eq(1) th:eq(' + index + ') input').on('keyup change', function () {
                table.column($(this).parent().index() + ':visible')
                    .search(this.value)
                    .draw();
            });
        });
    }


    function selectall() {
        var rowCount = $('#RowGet').val();
        var flag = $("#SlNoHeadCheckItem").is(":checked")
        for (var i = 1; i <= rowCount; i++) {
            if (document.getElementById("SlNoCheckgrid" + i) != null) {
                document.getElementById("SlNoCheckgrid" + i).checked = flag;
            }
        }
    }


    function Addtogrid()
    {
        $('#iconForm').hide();
        var row = $('#RowGet').val();
        i = 1;
        $("#tblpurchase_enquiry tr").remove();

        for (m = 1; m <= row; m++) {
            if ($("#SlNoCheckgrid" + m).is(":checked")) {
                var productIdgrid = $('#ProductIdgrid' + m).text();
                var Product = $('#Product' + m).text();
                var Des = $('#Des' + m).text();
                var locnid = $('#locnid' + m).text();
                var unitIdgrid = $('#UnitIdgrid' + m).text();
                var unit = $('#UnitName' + m).text();
                var qty = parseInt($('#qty_' + m).text() || 0);
                var rate = parseFloat($('#rte_' + m).text() || 0).toFixed(Decimal);
                var discount = 0;
                var taxid = $('#taxid' + m).text();
                var taxrate = parseFloat($('#taxrate' + m).text() || 0);
                var taxableamt = 0;
                var taxamt = 0;
                var total = 0;
                var PurAnalysisId = $('#purchaseanalysisid' + m).text();
                var Model = $('#Model1' + m).text();

                var no = $('#tblpurchase_enquiry tr').length + 1;
                var id = parseInt(i);

                var ProdEditRow = "<tr class='jsgrid-row' id='row_" + id + "'>" +
                    "<td id='edit_" + id + "' class= 'jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:3%;' ><input class='jsgrid-button jsgrid-edit-button' type='button' title='Edit' onclick='Editrow(" + id + ")'><input class='jsgrid-button jsgrid-delete-button'  type= button onclick='DeleteRow(" + id + ")'  title= Delete ></td>" +
                    "<td id='update_" + id + "' class= 'jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:3%;display:none' ><input class='jsgrid-button jsgrid-update-button' type='button' title='Update' onclick='UpdateRow(" + id + ")'><input class='jsgrid-button jsgrid-cancel-edit-button' type='button' title='Cancel edit' onclick='CancelEdit(" + id + ")'></td>" +
                    "<td id='td_" + id + "' class='jsgrid-cell'  style= 'width:3%;text-align:center' >"
                    + no + "<input type='hidden' id='sl_" + id + "' value=" + id + "></td>" +
                    "<td id='col_2' class= 'jsgrid-cell jsgrid-align-left'  style= 'width:10%;' ><input type='hidden' id='productId_" + id + "' value='"
                    + productIdgrid + "'><input type='text' id='product_" + id + "' class='form-control' disabled style='height:30px;background-color:white' value='"
                    + Product + "'></td>" +
                    "<td id='col_x' class= 'jsgrid-cell jsgrid-align-left'  style= 'width:20%;' ><input type='text' id='productdesc_" + id + "' class='form-control' disabled style='height:30px;background-color:white' value='"
                    + Des + "'></td>" +
                    "<td id='col_4' class='jsgrid-cell'  style='width:6%;display:none;' > <select id='unit_" + id + "' class='form-control' disabled style='height:30px;background-color:white' >"
                    + UnitSelect + "</select><input type='hidden' id='txtunit_" + id + "' class='form-control' /></td>" +
                    "<td id='col_5' class= 'jsgrid-cell jsgrid-align-center'  style='width:5%;' ><input type='text' id='quantity_" + id + "' class='form-control' disabled style='height:30px;background-color:white' value='"
                    + qty + "' onkeyup='CalcAmount(" + id + ")' onkeypress='isNumberInt(event,this)' ></td>" +
                    "<td id='col_6' class= 'jsgrid-cell jsgrid-align-center'  style='width:6%;' ><input type='text' id='txtrate_" + id + "' class='form-control' disabled style='height:30px;background-color:white'  value='"
                    + rate + "' onkeyup='CalcAmount(" + id + ")' onkeypress='isNumber(event,this)'><input type='hidden' id='baserate_" + id + "' class='form-control' value='' ></td>" +
                    "<td id='col_7' class= 'jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:6%;display:none;' ><input type='text' id='discount_" + id + "' class='form-control' disabled style='height:30px;background-color:white'  value='"
                    + (parseFloat(discount).toFixed(Decimal)) + "' onkeyup='CalcAmount(" + id + ")' onkeypress='isNumber(event,this)'></td>" +
                    "<td id='col_8' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:6%;' ><input type='text' id='txttaxable_" + id + "' class='form-control' style='height:30px;background-color:white'  value='"
                    + taxableamt + "' disabled></td>" +
                    "<td id='col_9' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:6%;display:none;' > <select  class='form-control' disabled style='height:30px;background-color:white' id='tax_" + id + "' onchange='ChangeTax(" + id + ",this)' >"
                    + TaxSelect + "</select></td>" +
                    "<td id='col_y' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:6%;display:none' ><input type='text' id='taxpercentage_" + id + "' class='form-control' disabled style='height:30px;background-color:white' value="
                    + taxrate + "></td>" +
                    "<td id='col_10' class= 'jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:6%;' ><input type='text' id='txttax_" + id + "' class='form-control' style='height:30px;background-color:white' disabled value='"
                    + taxamt + "'></td>" +
                    "<td id='col_11' class= 'jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:6%;' ><input type='hidden' id='txtsubtotal_" + id + "' value=''><input type='text' id='amount_" + id + "' class='form-control' style='height:30px;background-color:white'  disabled value='"
                    + total + "'><input type='hidden' id='baseamount_" + id + "' class='form-control'   disabled value=''><input type='hidden' id='basetaxableamount_" + id + "' class='form-control'   disabled value=''><input type='hidden' id='basetaxamount_" + id + "' class='form-control'   disabled value=''><input type='hidden' id='basediscount_" + id + "' class='form-control'   disabled value=''></td>" +
                    "<td id='col_3' class= 'jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:6%;' > <select id='locn_" + id + "' class='form-control' disabled style='height:30px;background-color:white' >"
                    + LocationSelect + "</select></td>"+
                    "<td id='col_12' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:6%;display:none' ><input type='text' id='purAnalysis_" + id + "' class='form-control' disabled style='height:30px;background-color:white' value="
                    + PurAnalysisId + "></td>"+
                     "<td id='col_13' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:6%;display:none' ><input type='text' id='Models_" + id + "' class='form-control' disabled style='height:30px;background-color:white' value='"
                    + Model + "'></td></tr>";
               
                $('#tblpurchase_enquiry').append(ProdEditRow);
                $('#unit_' + id).val(unitIdgrid);
                $('#locn_' + id).val(locnid);
                $('#tax_' + id).val(taxid);
                i++;

            }

        }
        $('#proddiv').animate({ scrollTop: 5000 }, 900);
        i = parseInt($('#tblpurchase_enquiry tr').length) + 1;
        CalcAmt();
    }


    function DeletePurchaseEnquiry() {
        $('#Confirmflag').val('puchaseenquirydelete'), $('#ConfirmRowId').val(0)
        $('#confirmmessage').text('Do you want to Delete this Enquiry?')
        $('#confirm').show();
        $('#confirmOk').focus();
    }

    function EditInvoice(Flag) {
        $("#btncnclsave").attr("onclick", "CheckEditInvoce(" + Flag + ")");
        $('#otp,#otpremarks').prop("disabled", false);
        $('#OTPDiv').show();
        $("#otp,#otpremarks").val('');
        $("#otp").focus();

    }

    function CheckEditInvoce(Flag) {
        if ($.trim($('#otp').val()) == '') {
            warningshow('Enter OTP', 'otp');
        }
        else if ($.trim($('#otpremarks').val()) == '') {
            warningshow('Enter Remarks', 'otpremarks');
        }
        else {
            var Operation = '';
            if (Flag == 0)
                Operation = 'Purchase Enquiry Edit- OTP , Enquiry No : ' + $("#Enquiryno").val();
            else if (Flag == 1)
                Operation = 'Purchase Enquiry Delete- OTP , Enquiry No : ' + $("#Enquiryno").val();

            var data = {};
            data.UserId = UId;
            data.OTP = $("#otp").val();
            data.Remarks = $('#otpremarks').val();
            data.Operation = Operation;
            data.DeptId = DepId;
            $.ajax({
                type: "POST",
                url: "../Home/OTPCheckforUser",
                data: data,
                success: function (result) {
                    for (var i = 0; i < result.oList.length; i++) {
                        var status = result.oList[i].Status;
                        OTPCheck(status, Flag)
                    }
                }
            });
        }
    }


    function OTPCheck(status, Flag) {
        if (status == 1) {
            if (Flag == 0) {
                EditPurchase();
            }
            else if (Flag == 1) {
                DeleteThisEnquiry();
            }

        }
        else {
            warningshow('Invalid OTP', 'otp');
            $("#otp").select();
        }
    }
    function DeleteThisEnquiry() {

        $('#OTPDiv').hide();
        //$('#Loading').show();
        var data = {};
        data.EnquiryNo = $('#Enquiryno').val();
        data.DepartmentId = DepId;
        data.UserId = UId;
        $.ajax({
            type: "POST",
            url: "../Purchase/DeletePurchaseEnquiry",
            data: data,
            success: function (result) {

                var status = result.oList[0].Status;
                var slno = result.oList[0].EnquiryNo;
                //$('#Loading').hide();
                Showalerts(status, slno);
            }
        });

    }
    function CheckeDeleted() {
        var datax = {};
        datax.BillNo = 'PE';
        datax.SlNo = $('#CopyEnquiryno').val();
        datax.DepartmentId = DepId;
        datax.UserId = UId;
        $.ajax({
            type: "POST",
            url: "../Purchase/CheckDeletedPurchase",
            data: datax,
            success: function (result) {
                var status = result.oList[0].Status;
                var slno = result.oList[0].SlNo;
                if (status == 1) {
                    //$('#popupmessageInfo').text('Enquiry No: ' + slno + ' Cancelled!!!');
                    //$('#Infopopup').show();
                    //setTimeout(function () { $('#Infopopup').hide(); }, 3000);
                    swal('Enquiry No-' + slno + ' ', "Cancelled!!!", "error");
                    $('.swal-button swal-button--confirm').focus();
                }

            }
        });
    }
    function EditPurchase() {
        $('#btnprint').hide();
        $('.editds,.butndis').prop("disabled", false);
        $('#btntransfer,#btnallow').prop("disabled", true);
        $('#btnsaveedit,#EntryNoDiv').show();
        $('#btnedit,#btndelete,#btnExporttoExcel').hide();
        $('.jsgrid-button').prop('disabled', false);
        $('#OTPDiv,#CopyEntryNoDiv').hide();
    }
    function GetPurchaseListDefault() {
        $('#ViewFromDate').val(GetFirstDayMonth());
        $('#ViewToDate').val(CurDate);
        GetPurchaseList();

    }
    function GetFirstDayMonth() {
        var date = new Date();
        var firstDay = new Date(date.getFullYear(), date.getMonth(), 1);

        var month = firstDay.getMonth() + 1;
        var day = firstDay.getDate();
        var year = firstDay.getFullYear();

        if (day < 10)
            day = '0' + day
        if (month < 10)
            month = '0' + month

        return day + "/" + month + "/" + year;
    }
    function GetPurchaseList() {
        var dataPI = {};
        dataPI.FromDate = $('#ViewFromDate').val();
        dataPI.ToDate = $('#ViewToDate').val();
        dataPI.PurchaseDeptId = DepId;
        dataPI.DepartmentId = DepId;
        dataPI.UserId = UId;
        $.ajax({
            type: "POST",
            url: "../Purchase/PurchaseEnquiryList",
            data: dataPI,
            success: function (result) {
                GetPIListView(result.oList);


            }
        });
    }
    function GetPIListView(result) {
        $('#ViewFromDate,#ViewToDate').prop("disabled", false);
        disable_datatable('tbl_PIViewList');
        $('#purchaseViewForm').show();
        var responseText = "<thead><tr><th style='width:90px;'>Sl#</th><th>Enquiry#</th><th>Date</th><th>Supplier</th><th>Remarks</th><th>Grand Total</th><th>Print</th><th>Excel</th></tr>" +
            "<tr><th> </th><th>Enquiry#</th><th>Date</th><th>Supplier</th><th>Remarks</th><th>GrandTotal</th><th> </th><th> </th></tr></thead><tbody>";
        for (var l = 0; l < result.length; l++) {
            var slno = parseInt(l + 1);

            responseText += '<tr ondblclick="GetCopyofThisPurchase(' + result[l].EnquiryNo + ',' + result[l].DepartmentId + ',0)"><td style="width:90px;" >' + slno + '</td><td id=' + 'InvoView_' + slno + '>' +
                result[l].EnquiryNo + '</td><td>' +
                result[l].EnquiryDate + '</td><td>' +
                result[l].SupplierName + '</td><td>' +
                result[l].Remarks + '</td><td align="right">' +
                parseFloat(result[l].GrandTotal).toFixed(Decimal) + '</td>'+
                '<td><button class="btn white btn-round btn-xs" style="background-color:#009DA0;font-size:smaller;margin:0" onclick="GetCopyofThisPurchase(' + result[l].EnquiryNo + ',' + result[l].DepartmentId + ',1)" autocomplete="off">Print <i class="ft-printer"></i></button></td>'+
                '<td align=center><button class="btn gradient-back-to-earth  mr-1 mb-1 white btn-round btn-xs" style="background-color:#009DA0;font-size:smaller;margin:0" onclick="GetCopyofThisPurchase(' + result[l].EnquiryNo + ',' + result[l].DepartmentId + ',2)" autocomplete="off">Excel</button></td></tr>';
        }
        $('#tbl_PIViewList').html(responseText + '</tbody>');
        datatableWithsearch('tbl_PIViewList', 'Multiple');

    }


    function GetCopyofThisPurchase(slno, dept, Print) {
        var data = {};
        data.EnquiryNo = slno;
        data.DepartmentId = dept;
        $.ajax({
            type: "POST",
            url: "../Purchase/PurchaseEnquiryGetandGets",
            data: data,
            success: function (result) {
                formrefresh(1);
                PurchaseEnquiryGets(result.oList);
                $('#btnnew').focus();
                $('.form-control').prop('disabled', true);
                $('#CopyEnquiryno').prop("disabled", false);
                $('.jsgrid-button').prop('disabled', true);
                $('#btnsubmit').prop("disabled", true);
                $('#btnlist').prop("disabled", true);
                $('#btnadd').prop("disabled", true);
                $('#purchaseViewForm').hide();
                $('#btnsubmit,#btnlist,#EntryNoDiv').hide();
                $('#CopyEntryNoDiv').show();
                $("#btnnew").show();
                $('.butndis').prop("disabled", true);
                $('#btnsubmit,#btnlist').hide();

                CopyFlag = 1;
                if (Print == 1) {
                    $('#btnprint').click();
                }
                else  if (Print == 2) 
                {
                    $("#btnExporttoExcel").click();
                }
            }
        });

        
    }
</script>

<script>
    function Upload() {

            //Reference the FileUpload element.
            var fileUpload = document.getElementById("fileUpload");

            //Validate whether File is valid Excel file.
            var regex = /^([a-zA-Z0-9\s_\\.\-:])+(.xls|.xlsx)$/;
            if (regex.test(fileUpload.value.toLowerCase())) {
                if (typeof (FileReader) != "undefined") {
                    var reader = new FileReader();

                    //For Browsers other than IE.
                    if (reader.readAsBinaryString) {
                        reader.onload = function (e) {
                            ProcessExcel(e.target.result);
                        };
                        reader.readAsBinaryString(fileUpload.files[0]);
                    } else {
                        //For IE Browser.
                        reader.onload = function (e) {
                            var data = "";
                            var bytes = new Uint8Array(e.target.result);
                            for (var i = 0; i < bytes.byteLength; i++) {
                                data += String.fromCharCode(bytes[i]);
                            }
                            ProcessExcel(data);
                        };
                        reader.readAsArrayBuffer(fileUpload.files[0]);
                    }

                } else {
                    warningshow("This browser does not support HTML5.");
                }
            } else {
                warningshow("Please upload a valid Excel file.");
            }

    };




    function ProcessExcel(data) {
        var a = 0; b = 0; c = 0;
        //Read the Excel File data.
        var workbook = XLSX.read(data, {
            type: 'binary'
        });

        //Fetch the name of First Sheet.
        var firstSheet = workbook.SheetNames[0];

        //Read all rows from First Sheet into an JSON array.
        var excelRows = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[firstSheet]);



        for (var k = 0; k < excelRows.length; k++) {
            if (excelRows[k]["Product"] == '' || excelRows[k]["Product"] == undefined || excelRows[k]["Product"] == '')
                {
                    a = 1;
                    break;
                }
            if (excelRows[k]["Quantity"] == 0 || excelRows[k]["Quantity"] == undefined || excelRows[k]["Quantity"] == '') {
                    b = 1;
                    break;
                }
            if (excelRows[k]["Rate"] == 0 || excelRows[k]["Rate"] == undefined || excelRows[k]["Rate"] == '') {
                    c = 1;
                    break;
                }
              }




        if (a != 0) {
            warningshow("Please Enter Code of all Items");
        }
        else if (b != 0) {
            warningshow("Please Enter Quantity for all Items");
        }
        else if (c != 0) {
            warningshow("Please Enter Rate for all Items");
        }
        else {

            //Add the data rows from Excel file.

            var sl = 0;
            $('#tblAlert tr').remove();
            var Prod1 = "<tr class='jsgrid-row'><td colspan=4 style='border:none'><h2 style='color:#FF586B'>Create new Items Before Enquiry!</h2></td></tr>" +
                                "<tr class='jsgrid-row' style='color:#607D8B'><th class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>ProductCode</th><th class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>Description</th></tr>";
            $('#tblAlert').append(Prod1);


            var la = 1;
            var oArray = new Array();
            for (var j = 0; j <= excelRows.length; j++) {
              
                if (j < excelRows.length) {
                    var Product = ''; Description = ''; Unit = ''; Location = ''; Quantity = ''; Rate = ''; Discount = ''; Taxable = ''; Tax = ''; TaxAmount = ''; Amount = ''; AvgCost = '';
                    if (excelRows[j]["Product"] == undefined) { Product = '' } else { Product = excelRows[j]["Product"] }
                    if (excelRows[j]["Description"] == undefined) { Description = '' } else { Description = excelRows[j]["Description"] }
                    if (excelRows[j]["Unit"] == undefined) { Unit = '' } else { Unit = excelRows[j]["Unit"] }
                    if (excelRows[j]["Location"] == undefined) { Location = '' } else { Location = excelRows[j]["Location"] }
                    if (excelRows[j]["Quantity"] == undefined) { Quantity = '' } else { Quantity = excelRows[j]["Quantity"] }
                    if (excelRows[j]["Rate"] == undefined) { Rate = '' } else { Rate = excelRows[j]["Rate"] }
                    if (excelRows[j]["Discount"] == undefined) { Discount = '' } else { Discount = excelRows[j]["Discount"] }
                    if (excelRows[j]["Taxable"] == undefined) { Taxable = '' } else { Taxable = excelRows[j]["Taxable"] }
                    if (excelRows[j]["Tax"] == undefined) { Tax = '' } else { Tax = excelRows[j]["Tax"] }
                    if (excelRows[j]["TaxAmount"] == undefined) { TaxAmount = '' } else { TaxAmount = excelRows[j]["TaxAmount"] }
                    if (excelRows[j]["Amount"] == undefined) { Amount = '' } else { Amount = excelRows[j]["Amount"] }
                    if (excelRows[j]["AvgCost"] == undefined) { AvgCost = '' } else { AvgCost = excelRows[j]["AvgCost"] }

                    oArray.push({
                        'ItemCode': $.trim(excelRows[j]["Product"]),
                        'Description': $.trim(excelRows[j]["Description"]),
                        'MinQty': $.trim(excelRows[j]["Quantity"]),
                        'UnitPrice': $.trim(excelRows[j]["Rate"]),
                        'SlNumber': parseInt(j + 1),
                    })

                }
                else if (j == excelRows.length) {
                    var data = { 'ItemMasterModel': oArray };
                  
                    $.ajax(
                    {
                        type: "POST",
                        url: "../Master/ItemDetailsGetforExcelImport",
                        data: data,
                        success: function (result) {


                            for (var m = 0; m < result.oList.length; m++) {
                                if (result.oList[m].Status == 0) {

                                    var Prod =
                                        "<tr class='jsgrid-row' style='color:#607D8B'>" +
                                        "<td class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>" + result.oList[m].ItemCode + "</td>" +
                                        "<td class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>" + result.oList[m].Description + "</td></tr>";
                                    $('#tblAlert').append(Prod);

                                }
                                else {
                                    var Prod =
                                        "<tr  class='jsgrid-row' style='color:#607D8B'>" +
                                        "<td id='excode" + la + "' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>" + result.oList[m].ItemCode + "</td>" +
                                        "<td id='exdesc" + la + "' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>" + result.oList[m].Description + "</td>" +
                                        "<td id='exitemid" + la + "' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>" + result.oList[m].ItemId + "</td>" +
                                        "<td id='exunitid" + la + "' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>" + result.oList[m].UnitId + "</td>" +
                                        "<td id='exqty" + la + "' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>" + result.oList[m].MinQty + "</td>" +
                                        "<td id='exdisc" + la + "' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>0</td>" +
                                        "<td id='exvatid" + la + "' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>" + result.oList[m].VatId + "</td>" +
                                        "<td id='exprice" + la + "' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>" + result.oList[m].SellingPrice + "</td>" +
                                        "<td id='exotherdesc" + la + "' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>" + result.oList[m].Otherdescription + "</td>" +
                                        "<td id='exavgcost" + la + "' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'>" + result.oList[m].AvgCost + "</td>" +
                                        "</tr>";
                                    $('#tblAlert').append(Prod);
                                    la++;
                                }
                            }

                            if (result.oList[0].Status == 0)
                            {
                                $('#anoproductpopuo').show();
                                $("#btnokalert").focus();
                            }

                            else
                            {
                                $('.distxtbox').val(0);
                                BillDiscountFlag = 0;
                                $('#disc,#Discountpercent').val('0.00');
                                $('#tblpurchase_enquiry tr').remove();

                                for (var f = 1; f < sl; f++) {
                                    if ($('#tblPurchase_Order tr').length == 0)
                                        i = 1;
                                    var id = parseInt(i);


                                    var fcval = parseFloat($('#rate').val() || 0);

                                    if ($('#excode' + f).text())
                                    {

                                        var no = $('#tblpurchase_enquiry tr').length + 1;
                                        var id = parseInt(i)                                     


                                        var ProdEditRow = "<tr class='jsgrid-row' id='row_" + id + "'>" +
                                            "<td id='edit_" + id + "' class= 'jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:3%;' ><input class='jsgrid-button jsgrid-edit-button' type='button' title='Edit' onclick='Editrow(" + id + ")'><input class='jsgrid-button jsgrid-delete-button'  type= button onclick='DeleteRow(" + id + ")'  title= Delete ></td><td id='update_" + id + "' class= 'jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:3%;display:none' ><input class='jsgrid-button jsgrid-update-button' type='button' title='Update' onclick='UpdateRow(" + id + ")'><input class='jsgrid-button jsgrid-cancel-edit-button' type='button' title='Cancel edit' onclick='CancelEdit(" + id + ")'></td><td id='td_" + id + "' class='jsgrid-cell'  style= 'width:3%;text-align:center' >"
                                            + no + "<input type='hidden' id='sl_" + id + "' value=" + id + "></td>" +
                                            "<td id='col_2' class= 'jsgrid-cell jsgrid-align-left'  style= 'width:10%;' ><input type='hidden' id='productId_" + id + "' value='"
                                            + $('#exitemid' + f).text() + "'><input type='text' id='product_" + id + "' class='form-control' disabled style='height:30px;background-color:white' value='"
                                            + $('#excode' + f).text() + "'></td>" +
                                            "<td id='col_x' class= 'jsgrid-cell jsgrid-align-left'  style= 'width:20%;' ><input type='text' id='productdesc_" + id + "' class='form-control' disabled style='height:30px;background-color:white' value='"
                                            + $('#exdesc' + f).text() + "'></td>" +
                                            "<td id='col_4' class='jsgrid-cell'  style='width:6%;display:none;' > <select id='unit_" + id + "' class='form-control' disabled style='height:30px;background-color:white' >"
                                            + UnitSelect + "</select><input type='hidden' id='txtunit_" + id + "' class='form-control' /></td>" +
                                            "<td id='col_5' class= 'jsgrid-cell jsgrid-align-center'  style='width:5%;' ><input type='text' id='quantity_" + id + "' class='form-control' disabled style='height:30px;background-color:white' value='"
                                            + ($('#exqty' + f).text() || 1) + "' onkeyup='CalcAmount(" + id + ")' onkeypress='isNumberInt(event,this)' ></td>" +
                                            "<td id='col_6' class= 'jsgrid-cell jsgrid-align-center'  style='width:6%;' ><input type='text' id='txtrate_" + id + "' class='form-control' disabled style='height:30px;background-color:white'  value='"
                                            + parseFloat($('#exprice' + f).text()).toFixed(Decimal) + "' onkeyup='CalcAmount(" + id + ")' onkeypress='isNumber(event,this)'><input type='hidden' id='baserate_" + id + "' class='form-control' value='"
                                            + parseFloat(0).toFixed(Decimal) + "' ></td>" +
                                            "<td id='col_7' class= 'jsgrid-cell jsgrid-align-center'  style='width:6%;display:none;' ><input type='text' id='discount_" + id + "' class='form-control' disabled style='height:30px;background-color:white'  value='"
                                            + parseFloat(0).toFixed(Decimal) + "' onkeyup='CalcAmount(" + id + ")' onkeypress='isNumber(event,this)'></td>" +
                                            "<td id='col_8' class='jsgrid-cell jsgrid-control-field jsgrid-align-center'  style='width:6%;' ><input type='text' id='txttaxable_" + id + "' class='form-control' style='height:30px;background-color:white'  value='"
                                            + parseFloat(0).toFixed(Decimal) + "' disabled></td>" +
                                            "<td id='col_9' class='jsgrid-cell jsgrid-align-center'  style='width:6%;display:none;' > <select  class='form-control' disabled style='height:30px;background-color:white' id='tax_" + id + "' onchange='ChangeTax(" + id + ",this)' >"
                                            + TaxSelect + "</select></td>" +
                                            "<td id='col_y' class='jsgrid-cell jsgrid-align-center'  style='width:6%;display:none' ><input type='text' id='taxpercentage_" + id + "' class='form-control' disabled style='height:30px;background-color:white' value="
                                            + 0 + "></td>" +
                                            "<td id='col_10' class= 'jsgrid-cell jsgrid-align-center'  style='width:6%;' ><input type='text' id='txttax_" + id + "' class='form-control' style='height:30px;background-color:white' disabled value='"
                                            + parseFloat(0).toFixed(Decimal) + "'></td>" +
                                            "<td id='col_11' class= 'jsgrid-cell jsgrid-align-center'  style='width:6%;' ><input type='hidden' id='txtsubtotal_" + id + "' value='"
                                            + parseFloat(0).toFixed(Decimal) + "'><input type='text' id='amount_" + id + "' class='form-control' style='height:30px;background-color:white'  disabled value='"
                                            + parseFloat(0).toFixed(Decimal) + "'><input type='hidden' id='baseamount_" + id + "' class='form-control'   disabled value='"
                                            + parseFloat(0).toFixed(Decimal) + "'><input type='hidden' id='basetaxableamount_" + id + "' class='form-control'   disabled value='"
                                            + parseFloat(0).toFixed(Decimal) + "'><input type='hidden' id='basetaxamount_" + id + "' class='form-control'   disabled value='"
                                            + parseFloat(0).toFixed(Decimal) + "'><input type='hidden' id='basediscount_" + id + "' class='form-control'   disabled value='"
                                            + parseFloat(0).toFixed(Decimal) + "'></td>" +
                                            "<td id='col_3' class= 'jsgrid-cell jsgrid-align-center'  style='width:6%;' > <select id='locn_" + id + "' class='form-control' disabled style='height:30px;background-color:white' >"
                                            + LocationSelect + "</select></td></tr>";

                                        $('#tblpurchase_enquiry').append(ProdEditRow);

                                        $('#tax_' + id).val(parseInt($('#exvatid' + f).text()));
                                        $('#taxpercentage_' + id).val(($('#tax_' + id).find("option:selected").attr("name")));

                                        $('#unit_' + id).val(parseInt($('#exunitid' + f).text()));

                                       
                                        $('#locn_' + id).val($('#location').val());

                                        ClearProductRow();
                                        i++;
                                        ProductFlag = 0;
                                        Product = '';
                                        CalcAmt();
                                        $('#proddiv').animate({ scrollTop: 5000 }, 900);
                                       
                                        
                                    }

                                }

                            }

                        }
                    });
                }
                sl++;

            }


            i = excelRows.length + 1;

        }

    };

</script>