@using System.Data;
@using System.Data.SqlClient;
@using An_Auto.Models;
@{
    ViewBag.Title = "UserDashboard";
    //Layout = "~/Views/Shared/_Layout.cshtml";
    Layout = "~/Views/Shared/_LayoutServer.cshtml";
    AN_AUTO_2023Entities db = new AN_AUTO_2023Entities();

}


<script type="text/ecmascript" src="../../../js/jquery.min.js"></script>
<!-- This is the Javascript file of jqGrid -->
<script type="text/ecmascript" src="../../../js/trirand/src/jquery.jqGrid.js"></script>
<!-- This is the localization file of the grid controlling messages, labels, etc.
<!-- We support more than 40 localizations -->
<script type="text/ecmascript" src="../../../js/trirand/i18n/grid.locale-en.js"></script>

<script type="text/javascript" language="javascript" src="//cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
<!-- A link to a jQuery UI ThemeRoller theme, more than 22 built-in and many more custom -->
<link rel="stylesheet" type="text/css" media="screen" href="../../../css/jquery-ui.css" />
<!-- The link to the CSS that the grid needs -->
<link rel="stylesheet" type="text/css" media="screen" href="../../../css/trirand/ui.jqgrid.css" />

@*<h2>UserDashboard</h2>*@
@*///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////*@
<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 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>



<style type="text/css">
    .rowClass {
        /*color: blue;*/
        background-image: none;
    }
</style>

<style>
        .ui-th-ltr
        /*// .ui-jqgrid .ui-jqgrid-htable th div {*/ {
            /*height: 25px !important;*/
            font-size: 15px !important;
            font-weight: bold !important;
        }

        .ui-search-toolbar th div {
            padding-right: -0.7em !important;
        }

        .ui-jqgrid tr.jqgrow td {
            font-size: 1rem;
            background-color: white;
        }

        .ui-jqgrid .ui-jqgrid-htable th div {
            height: 29px !important;
            background-color: white;
            color: black;
            font-size: 18px;
        }

        .ui-jqgrid .ui-paging-info {
            font-weight: bold;
            height: 25px;
            margin-top: 3px;
            margin-right: 4px;
        }

        .ui-paging-info {
            /*background-color: #6d7677;*/
            /*text-align: center !important;*/
            color: red;
            font-size: medium;
        }




        .bnstygo {
            font-size: large;
            text-align: center;
            font-weight: 500;
            height: 40px;
            background-color: #e0085a !important;
            border-radius: 22px;
            border: unset;
            width: 170px;
            margin: -5px 0px 0px 30px;
            color: white;
        }

        .streturn {
            background-color: #c9c539;
            font-weight: 500;
        }

        .stontheway {
            background-color: #64a13a;
            font-weight: 500;
        }

        .stpacked {
            background-color: #417db1;
            font-weight: 500;
        }

        .stcompleted {
            background-color: green;
            font-weight: 500;
        }

        .ui-jqgrid tr.jqgrow tr {
            background-image: none !important;
        }

        .ui-jqgrid tr.jqgrow td {
            background-color: unset !important;
            background-image: none !important;
        }
        /*.ui-jqgrid .ui-jqgrid-pager .ui-pg-div {
        padding: 3px 8px 4px 5px;
        float: left;
        position: relative;
        background-color: steelblue;
        color: white;
        font-size: medium;
    }*/


        /*.ui-state-highlight, .ui-widget-content .ui-state-highlight, .ui-widget-header .ui-state-highlight {
        border: 1px solid #fcefa1;
        background: #fbf9ee url(images/ui-bg_glass_55_fbf9ee_1x400.png) 50% 50% repeat-x;
        color: #363636;
    }*/


        .ui-jqgrid .loading {
            font-weight: bold;
            font-size: medium;
            color: #049ea4;
        }

        /*.ui-jqgrid .loading
    {
        background:#fff url('http://www.jqueryin.com/demo/spinner/spinner.gif') no-repeat 50% 50%;
        display: none;
        height: 16px;
        width: 16px;
    }*/
        /*.ui-jqgrid .loading {
    opacity:0.45;
    -moz-opacity:0.45;
    filter:alpha(opacity=45);
    width: 950px;
    background-attachment: fixed;
    background-image: url(../images/loading.gif);
    background-repeat: no-repeat;
    background-position: center center;
    }*/
</style>

<script>
    //var newimgsrc = $('.loading').css("background-image");
    //$('.loading').css({ "background-image": newimgsrc });
    //$('.loading').css({ "display": "block" });
</script>




@*////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////*@

<input type="text" style="display:none" id="EditStatusBillNo" value="0" />
<input type="text" style="display:none" id="Location" value="o" />
<input type="text" style="display:none" id="StatusOld" value="o" />
<input type="text" style="display:none" id="rowId" value="0" />
<input type="text" style="display:none" id="StatusNew" value="0" />

<div class="myData" data-x="M54" />

<div id="Entry" style="margin-top:-20px;">

    <section class="grid-row-label">
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header" style="border-bottom:2px solid #e6e6e6">
                        <h3 class="card-title mb-0" style="float:left">WMS Dashboard</h3>

                        <h3 class="col-md-3 text-right" id="gndtotal" style="float:right;color:red;font-weight:500"> </h3>

                        <h3 class="text-md-right" id="fc" style="float:right;opacity:0;color:red;font-weight:500"> </h3>

                    </div>
                    <div class="card-content collapse show">
                        <div class="card-body" style="margin-top:-60px">

                            <form action="#">
                                <div class="form-body">
                                    <hr style="margin-top:30px" />

                                    <div class="row" style="background-color:#000000;margin-left:0px;width:100%;height:200px;margin-top:-23px;">

                                        <div class="col-md-12" style="margin-top:-5px;">
                                            <br />
                                            <div class="form-group">

                                                <div class="row" id="slnorow">

                                                    <label class="col-lg-1" style="margin-top:5px;color:white;">Date From:</label>
                                                    <div class="col-lg-11">
                                                        <div class="row">
                                                          
                                                              <div class="col-md-3 input-group"> @*height:85%;background-color:white*@
                                                                <input type="text" id="DateFrom" class="form-control" style="border-radius: 5px; border: 1px solid #BABFC7;height:85%;background-color:white;" />

                                                            
                                                            </div>
															<label class="col-lg-1 text-lg-right" style="margin-top:5px;color:white;display:none">Location:</label>

                                                            <div class="col-md-3 input-group" style="display:none">
                                                                <select type="text" class="form-control" id="Dept" style="border-radius: 5px; border: 1px solid #BABFC7;height:85%;background-color:white;"></select>

                                                            </div>
          
                                                            <label class="col-lg-1 text-lg-right" style="margin-top:5px;color:white;display:none">Delivery Type:</label>
                                                            <div class="col-md-3 input-group" style="display:none;>
                                                                <select id="select_place" name="priority" class="form-control" style="border-radius: 5px;display:none; border: 1px solid #BABFC7;height:85%;background-color:white;"></select>

                                                            </div>


                                                            <label class="col-lg-1 text-lg-right" style="margin-top:5px;color:white;display:none">Salesman:</label>

                                                            <div class="col-md-2 input-group" style="display:none">
                                                                <select id="salesman" name="priority" class="form-control" style="border-radius: 5px; border: 1px solid #BABFC7;height:85%;background-color:white;"></select>

                                                            </div>

                                                            
                                                            @*<div class="col-md-2 input-group">*@
                                                                @*<img src="~/app-assets/img/ico/eumi_icon_new.ico" style="height: 45px;width: 130px;margin: 0px 0px 0px 55px;"  />*@
                                                                @*<img src="~/app-assets/img/text.png" style="height: 45px;width: 130px;margin: 0px 0px 0px 55px;background-color: white;padding: 5px 5px 5px 5px;" />*@
                                                                @*<div  id="divsummary" class="d-inline-block custom-control custom-radio mr-1">
                                                                    <input type="radio" name="sd" style="color:white;" class="custom-control-input" checked="" id="btnsummary" value="normal" onchange="GetList('##')">
                                                                    <label class="custom-control-label" for="btnsummary" style="color:white;">Summary </label>
                                                                </div>
                                                                <div style="margin-left:2%" id="divdetail" class="d-inline-block custom-control custom-radio mr-1">
                                                                    <input type="radio" name="sd" style="color:white;" class="custom-control-input" id="btndetail" onchange="GetList('##$$')" value="normal">
                                                                    <label class="custom-control-label" for="btndetail" style="color:white;">Detailed </label>
                                                                </div>*@
                                                            @*</div>*@

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


                                                <div class="row" style="margin-top:-5px">
                                                    <label class="col-lg-1" style="margin-top:5px;color:white;">Date To:</label>
                          
                                                    <div class="col-lg-11">
                                                        <div class="row">
                                                            <div class="col-md-3 input-group">
                                                                <input type="text" id="DateTo" class="form-control" style="border-radius: 5px; border: 1px solid #BABFC7;height:85%;background-color:white;" />

                                                            </div>
                                                           

                                                            @*<label class="col-lg-1 text-lg-right" style="margin-top:5px;color:white;">Delivery Type</label>
                                                            <div class="col-md-3 input-group">
                                                                <select id="select_place" name="priority" class="form-control" style="border-radius: 5px; border: 1px solid #BABFC7;height:85%;background-color:white;"></select>

                                                            </div>*@


                                                            

                                                            <label class="col-lg-1 text-lg-right" style="margin-top:5px;color:white;">Status:</label>

                                                            <div class="col-md-2 input-group">
                                                                <select id="select_status" name="priority" class="form-control" style="border-radius: 5px; border: 1px solid #BABFC7;height:85%;background-color:white;">
                                                                    <option value="0">--Select--</option>
                                                                    <option>CREATED</option>
                                                                    <option>On the way</option>
                                                                    <option>Loaded</option>
                                                                    <option>Delivered with Pending</option>
                                                                    <option>Delivered</option>
                                                                    <option>Hold</option>
                                                                    <option>RTD A</option>
                                                                    <option>RTD B</option>
                                                                    <option>RTD C</option>
                                                                    <option>RTD D</option>
                                                                    <option>RTD E</option>
                                                                    <option>PACKING</option>
                                                                    <option>PICKING</option>


                                                                </select>
                                                            </div>


                                                            @*<label class="col-lg-1 text-lg-right" style="margin-top:5px;color:white;">Refresh Time:</label>

                                                            <div >

                                                                <select id="sel_timeref" name="priority" class="form-control" style="border-radius: 5px; border: 1px solid #BABFC7;height:65%;background-color:white;" onchange="changetimeref()">

                                                                    <option value="15000">15 Sec</option>
                                                                    <option value="30000">30 Sec</option>
                                                                    <option value="60000">60 Sec</option>

                                                                </select>

                                                            </div>*@


                                                            <div class="col-md-2 input-group">
                                                            @*<img src="~/app-assets/img/text.png" style="height: 55px;width: 155px;margin: -35px 0px 0px 55px;background-color: white;padding: 5px 5px 5px 5px;" />*@
                                                                <img src="~/app-assets/img/text.png" style="height: 55px;width :145px;margin: -15px 0px 0px 560px;background-color :white;padding :5px 5px 5px 5px;" />
                                                            </div>






                                                               



                                                            </div>
                                                    </div>

                                                </div>


                                                <div class="row">

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


                                                        <div class="row" style="margin-top:-10px">
                                                            <label class="col-lg-1" style="margin-top:5px;color:white;">Invoice No:</label>

                                                            <div class="col-lg-11">
                                                                <div class="row">
                                                                    <div class="col-md-3 input-group">
                                                                        <input type="text" id="Invoiceno" class="form-control" style="border-radius: 5px; border: 1px solid #BABFC7;height:85%;background-color:white;" />
                                                                    </div>

                                                   

                                                                    <label class="col-lg-1 text-lg-right" style="margin-top:5px;color:white;display:none">Delivery Area:</label>

                                                                    <div class="col-md-3 input-group" style="display:none;>
                                                                        <select id="select_terms" name="priority" class="form-control" style="display:none;border-radius: 5px; border: 1px solid #BABFC7;height:85%;background-color:white;"></select>

                                                                    </div>

                                                                    

                                                                    <div class="col-md-2 input-group">
                                                                        <div @*style="margin-left:2%"*@ id="divsummary" class="d-inline-block custom-control custom-radio mr-1" style="display:none !important;" @*style="margin-top:3px;margin-left: 38px;"*@>
                                                                            <input type="radio" name="sd" style="color:white;" class="custom-control-input" checked="" id="btnsummary" value="normal" onchange="GetList('##')">
                                                                            <label class="custom-control-label" for="btnsummary" style="color:white;">Summary </label>
                                                                        </div>
                                                                        <div @*style="margin-left:2%;margin-top:3px;"*@ id="divdetail" class="d-inline-block custom-control custom-radio mr-1" style="display:none !important;" >
                                                                            <input type="radio" name="sd" style="color:white;" class="custom-control-input" id="btndetail" onchange="GetList('##$$')" value="normal">
                                                                            <label class="custom-control-label" for="btndetail" style="color:white;">Detailed </label>
                                                                        </div>
                                                                    </div>

                                                             <div class="col-md-1 input-group">
                                                            <select id="sel_timeref" name="priority" class="form-control" style="border-radius: 5px; border: 1px solid #BABFC7;height:85%;background-color:white;" onchange="changetimeref()">

                                                                <option value="15000">15 Sec</option>
                                                                <option value="30000">30 Sec</option>
                                                                <option value="60000">60 Sec</option>

                                                             </select>

                                                              </div>


                                                                    <div class="col-md-2 input-group" style="margin:0px 0px 0px 510px;">

                                                                        <button type="button" id="btngosubmit"  class="bnstygo"  @*onclick="GetList('##');$('#btnsummary').prop('checked', true)"*@ autocomplete="off">REFRESH @*<i class="fa fa-check-square-o"></i>*@</button>


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


                                                    </div>

                                                </div>


                                              


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



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


                  
                    
                    
                     <div class="card-body" style="margin-top:3px; height:auto; overflow:auto;width:100%;">


                        <div>
                            <table id="grid"></table>
                            <div id="pager"></div>
                        </div>

                         @*<a class="btn btn-white exlbtn" href="/WMSDashdoardToExcel" style="color:#000;"><i class="fa fa-file-excel"></i> Export To Excel</a>*@
                    </div>


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

    </section>

</div>


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

<div id="LoadingBar" class="overlay" style="display:block;">
    <div style="position: absolute;top: 45%;left: 45%; width: auto;z-index: 101;padding: 6px;margin: 5px;text-align: center;font-weight: bold;border-width: 2px!important;">
        <img src="~/app-assets/img/Loading_1.gif" />
    </div>
</div>



@*//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////*@



@*//////otp//////////*@

<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="password" id="txtotp" 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="btnotpcancel" onclick="$('#OTPDiv').hide(), $('#txtotp,#otpremarks').val('')" class="btn btn-outline-secondary">Cancel</button>
                <button type="button" style="width:100px" id="btnotpsave" onclick="CheckEdit()" class="btn btn-outline-warning">Continue</button>
            </div>


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

<div id="StatusDiv" 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="$('#StatusDiv').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">Change Status:</label>
                        <div class="col-md-7">



                            <select id="statusedit" class="form-control" >
                                <option value="" disabled>--Select--</option>
                                @{

// List<String> ls1 = db.WMSStatus.Select(t => t.SNAME).Distinct().ToList();
   
                                    List<An_Auto.Controllers.HomeController.WMSStatus> ListStatus = db.Database.SqlQuery<An_Auto.Controllers.HomeController.WMSStatus>("exec ListWmsStatus").ToList();

                                    if (ListStatus.Count > 0)
                                    {

                                        foreach (var item in ListStatus)
                                        {
                                            <option value="@item.SNAME">@item.SNAME</option>
                                        }
                                    }
                                }
                               
                                @*<option value="CREATED">CREATED</option>
                                <optCREATEDion value="DELIVERED">LOADED</optCREATEDion>
                                <option value="PACKED">PACKED</option>
                                <option value="PICKED">PICKED</option>
                                <option value="RETURN">RETURN</option>
                                <option value="ON THE WAY">ON THE WAY</option>                                
                                <option value="COMPLETED">COMPLETED</option>                            
                                <option value="DELIVERED">DELIVERED</option>*@
                              


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

                </div>

            </div>
            <div class="modal-footer">
                <button type="button" style="width:100px;" id="btnstatuseditcancel" onclick="$('#StatusDiv').hide(), $('#statusedit').val('')" class="btn btn-outline-secondary">Cancel</button>
                <button type="button" style="width:100px" id="btnstatussave" onclick="UpdateStatus()" class="btn btn-outline-warning">Update</button>
            </div>


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






@*//////////////*@








<script type="text/javascript">
    //Get Currennt Date

    $(document).ready(function () {

        var cat = (localStorage.getItem('nanana'));
        if (cat != null) {

        }
        else {
           // window.location = '../Home/Index';

        }


        GetDepartment(0);
        GetSalesMan(0);
        placeload(0);
        Terms(0);

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

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


        });

        var interval = 15000;
        var intervalId;
        //startInterval(interval);
        // store in a function so we can call it again
        function startInterval(_interval) {
            // Store the id of the interval so we can clear it later
            intervalId = setInterval(function () {
                var var2 = ""
              //  if ($('#btnsummary').prop('checked') == true) {
                    var2 = '##'
              //  }
                //else {
                //    var2 = '##$$'
                //}
                GetList(var2);
            }, _interval);
        }
        function getInterval() {
            return interval;
        }
        $('#sel_timeref').on('change', function () {
            interval = $('#sel_timeref').val();
            // clear the existing interval
            clearInterval(intervalId);
            // just start a new one
            startInterval(interval);
        })


     

        ////////////////////////////////////////////////
      //  GetList('');
        GetList('##');

   

        $("#btngosubmit").click(function (e) {
    
            //e.preventDefault();
            //myGrid.trigger('reloadGrid');

            $("#grid").GridUnload();
            GetList("##");
            $('#btnsummary').prop('checked', true)
        });


      
        

    });


    // end of doc



    function GetDepartment(id) {

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


            }
        });
    }

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


    function GetSalesMan(id) {
        var data = {};
        data.UserId = ERPUserId;
        $.ajax({
            type: "POST",
            url: "../Home/UserSalesmanGetandGets",
            data: data,
            success: function (result) {
                SalesManLoad(result, id);
            }
        });
    }

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

    function placeload(id) {
        var data = {};
        data.AreaId = 0;
        $.ajax({
            type: "POST",
            url: "../Home/AreaGetandGets",
            data: data,
            success: function (result) {
                //  AreaLoad(result.oList, id);
                AreaLoad(result, id);

            }
        });
    }
    var DefaultArea = 0;
    function AreaLoad(result, a) {
        $("#select_place").empty();
        $("#select_place").append("<option value='0'>Place Of Supply</option>");
        for (var i = 0; i < result.length; i++) {
            if (result[i].DefaultArea != 0) {
                DefaultArea = result[i].DefaultArea;
            }
            $("#select_place").append("<option value='" + result[i].AreaId + "'>" + result[i].AreaName + "</option>");
        }

        $("#select_place").append("<option value='EXPORT'>EXPORT</option>");
        if (a == 0) {
            $('#select_place').val(0);
        }
        else {
            $('#select_place').val(0);
        }
    }

    function Terms(id) {
        var data = {};
        data.TermsId = -1;
        $.ajax({
            type: "POST",
            url: "../Home/TermsGetandGets",
            data: data,
            success: function (result) {
                TermsLoad(result, id);
            }
        });

    }
    function TermsLoad(result, a) {
        $("#select_terms").empty();
        $("#select_terms").append("<option value='0'>--Select--</option>");
        for (var i = 0; i < result.length; i++) {
            $("#select_terms").append("<option value='" + result[i].TermsId + "' name='" + result[i].Terms + "'>" + result[i].TermDescription + "</option>");
        }
        if (a == 0) {
            $('#select_terms').val(0);
        }
        else {
            $('#select_terms').val(a);

        }
    }


    function GetList(var2) {

        //if (usermenu1.indexOf("M225") != -1) {
        //    var Flag = 0;               //ALL WORK ITEM VIEW RIGHT
        //}
        //else {
        //    var Flag = 4;               //NOT ALL WORK ITEM VIEW RIGHT
        //}
        $('#LoadingBar').show();

        var var1 = '1=1 ';
        if (var2 == '##') {
            if ($('#Dept').val() != '0' && $('#Dept').val() != null) {
                var1 += "and locationcode='" + $('#Dept option:selected').text() + "' ";
            }
            if ($('#select_place').val() != '0' && $('#select_place').val() != 'EXPORT' && $('#select_place').val() != null) {
                var1 += "and deliverytype='" + $('#select_place option:selected').text() + "' ";
            }
            if ($('#select_place').val() == 'EXPORT' && $('#select_place').val() != null) {
                var1 += "and Exporttype='" + $('#select_place option:selected').text() + "' ";
            }
            if ($('#Invoiceno').val() != '') {
                var1 += "and billno like '" + $('#Invoiceno').val() + "%' ";
            }
            if ($('#salesman').val() != '0' && $('#salesman').val() != null) {
                var1 += "and SALESMANID='" + $('#salesman option:selected').val() + "' ";
            }
            if ($('#select_terms').val() != '0' && $('#select_terms').val() != null) {
                var1 += "and area='" + $('#select_terms option:selected').text() + "' ";
            }
            if ($('#select_status').val() != '0' && $('#select_status').val() != null) {
                var1 += "and status='" + $('#select_status option:selected').text() + "' ";
            }
            else {
                var1 += "and status!='DELIVERED' ";
            }

        }
        else {
            if ($('#Dept').val() != '0' && $('#Dept').val() != null) {
                var1 += "and Dept='" + $('#Dept option:selected').text() + "' ";
            }

            if ($('#salesman').val() != '0' && $('#salesman').val() != null) {
                var1 += "and ASSignedTOUser='" + $('#salesman option:selected').text() + "' ";
            }
            if ($('#Invoiceno').val() != '') {
                var1 += "and WorkItemId = convert(varchar, '" + $('#Invoiceno').val() + "' ) ";
            }


            if ($('#select_place').val() != '0' && $('#select_place').val() != 'EXPORT' && $('#select_place').val() != null) {
                var1 += "and slno='" + $('#select_place option:selected').val() + "' ";
            }
            if ($('#select_place').val() == 'EXPORT' && $('#select_place').val() != null) {
                var1 += "and ORDERNO='" + $('#select_place option:selected').text() + "' ";
            }
            if ($('#select_terms').val() != '0' && $('#select_terms').val() != null) {
                var1 += "and AssignedOn='" + $('#select_terms option:selected').val() + "' ";
            }

            if ($('#select_status').val() != '0' && $('#select_status').val() != null) {
                var1 += "and Status='" + $('#select_status option:selected').text() + "' ";
            }
            else {
                var1 += "and status!='DELIVERED' ";
            }
        }
    
        var ERPUserId ;
        var ERPDeptId ;
        if (window.localStorage != null) {
            var cat = (localStorage.getItem('nanana'));
            if (cat == null) {
                UserLogout();
                //window.location = '../Home/Login';
                //localStorage.clear();

            }
            else {

                var PrevDepartment = '';
                PrevDepartment = localStorage.getItem('nanana');
                var res = cat.split(":");
                window.LoggedInUserArray = res;
                window.LoggedInUser = window.LoggedInUserArray[1];
            }

        }
            var UserLocationId = parseInt(window.LoggedInUserArray[2]);         
            ERPUserId =parseInt(window.LoggedInUserArray[0]);
            ERPDeptId =parseInt(window.LoggedInUserArray[1]);

        var Flag = 0;
      //  var var1 = "1=1";
        // var2 = "##";

        var Type = Flag;
        var UserId = ERPUserId;
        var DepartmentId = ERPDeptId;
        var FromDate = $('#DateFrom').val();
        var ToDate = $('#DateTo').val();
        var Variable1 = var1;
        var Variable2 = var2;

        $("#grid").GridUnload();
		console.log("/Home/GetValues?Type=" + Type + "&UserId=" + UserId + "&DepartmentId=" + DepartmentId + "&FromDate=" + FromDate + "&ToDate=" + ToDate + "&Variable1=" + Variable1 + "&Variable2=" + var2);

        if (var2 == "##") {
            var2 = "hash";
            var myGrid = $("#grid").jqGrid({
                // $("#grid").jqGrid
                // ({
                //  url: "/Home/GetValues?Type=" + Type + "&UserId=" + UserId + "&DepartmentId=" + DepartmentId + "&FromDate='" + FromDate + "'&ToDate='" + ToDate + "'&Variable1='" + Variable1 + "'&Variable2='" + Variable2 + "'",
                url: "/Home/GetValues?Type=" + Type + "&UserId=" + UserId + "&DepartmentId=" + DepartmentId + "&FromDate=" + FromDate + "&ToDate=" + ToDate + "&Variable1=" + Variable1 + "&Variable2=" + var2,
                datatype: 'json',
                mtype: 'Get',
                 colNames: ['NewWorkRemarks', 'Dept', 'Salesman', 'OrderType', 'Locn', 'BillNo', 'Date/Time', 'Customer', 'Branch', 'Status', 'Remarks', 'Driver', 'Time'],

               // colNames: ['NewWorkRemarks', 'Dept', 'Salesman', 'OrderType', 'Locn', 'BillNo', 'Date/Time', 'Customer', 'DeliveryArea', 'Status', 'Remarks', 'LPO', 'Time'],
                colModel: [
               //{
               //    key: true,
               //    name: 'slno',
               //    hidden:true,
               //    index: 'slno',//sl
               //    editable: true,
               //    search: true,
               //    searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               //},
                 {
                     key: false,
                     name: 'NewWorkRemarks',
                     hidden: true,
                     index: 'NewWorkRemarks',
                 },
               {
                   key: false,
                   name: 'DEPT',//Dept
                   index: 'DEPT',//dep  //Title
                   //name: 'Title',//Dept
                   //index: 'Title',//dep  //Title
                   editable: true,
                   search: true,
                   sortable: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'SALESMAN',//AssignedByUser
                   index: 'SALESMAN',//salesman
                   //name: 'DriverName',//AssignedByUser
                   //index: 'DriverName',//salesman
                   editable: true,
                   search: true,
                   sortable: true,
                 //  align: 'left',
                 //  stype: "text",
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                 //  searchoptions: { "sopt": ["bw", "cn", "eq"] }
               }
               , {
                   key: false,
                   name: 'Div',
                   //  index: 'DriverName',//ordertype    //deliverytype
                   editable: true,
                   formatter: getordertype,
                   search: true,
                   sortable: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,

                   name: 'LOCATION',
                   index: 'LOCATION',
                 //  name: 'AssignedOnDate',                 
                  // // index: 'DriverName',//loc   //AssignedOnDate.split('##')[1]
                   editable: true,
                  // formatter: getlocation,
                   search: true,
                   sortable: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'BILLNO',
                   index: 'BILLNO',
                 //  name: 'WorkItemId',
                  // //  index: 'BillNumber',//billno
                   editable: true,
                   search: true,
                   sortable: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'AssignedOnDate',
                   // index: 'AssignedOnDate',//date/time
                   editable: true,
                   formatter: getdatetime,

                   search: true,
                   sortable: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                   //  formatter: "date",
                   //  formatoptions: { srcformat: "ISO8601Long", newformat: "m/d/Y h:i A" },
               },
                {
                    key: false,
                    name: 'CUSTOMER',
                    index: 'CUSTOMER',//customer
                    //name: 'Description',
                    ////   index: 'Description',//customer
                    editable: true,
                    search: true,
                    searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }

                },
               {
                   key: false,
                   name: 'BRANCH',
                   index: 'BRANCH',
                   //name: 'DepartmentName',     // 'StoreKeeper',
                   ////  index: 'StoreKeeper',//deliveryarea
                   editable: true,
                   search: true,
                   sortable: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               }, {
                   key: false,
                   name: 'Status',//status
                    index: 'Status',//result[i].Status.split('##')[0]
                   editable: true,
                   search: true,
                 //  sortable: true,
                   formatter: getstatus,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                  },
                  //  {
               //    key: false,
               //    name: 'Status',
               //    //  index: 'Status',//pendingstatus
               //    editable: true, // var pendingstatus = result[i].Status.split('##')[1];
               //    search: true,
               //    formatter: getpendingstatus,
               //    searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               //},
               {
                   key: false,
                   name: 'AssignedOnDate',   // 'WorkRemarks',
                   //  index: 'WorkRemarks',//remarks
                   editable: true,
                   search: true,
                   formatter: getremarks,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               }, {
                   key: false,
                   
                   name: 'DRIVER',
                   index: 'DRIVER',//lpo
                       // name: 'AssignedOnDate',
                   // index: 'AssignedOnDate',//lpo
                   editable: true,
                   search: true,
                  // formatter: getlpo,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               }, {
                   key: false,
                   name: 'AssignedOnDate',
                   //  index: 'AssignedOnDate',//time
                   editable: true,
                   // formatter: "date",
                   // formatoptions: { srcformat: "ISO8601Long", newformat: "h:i A" },
                   search: true,
                   formatter: gettime,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
                ],

                pager: jQuery('#pager'),
                // pager: '#grid',
             //   rowNum: 50,
                 rowList: [20,30,40,50, 60, 70, 80, 90, 100],
                rownumbers: true,
                viewrecords: true,
                caption: 'Details',
                emptyrecords: 'No records to display',
                //   page:1,
                // rowNum: 20,
                // rowList: [50, 60, 70, 80, 90],
                rowNum: 99999,
                height: '100%',
                autowidth: true,
                ignoreCase: true,
                loadonce: true,
                gridview: true,
                // width:'100%',
                // loadonce: true,
                //  gridview: true,
                sortable: true,
                sortorder: 'desc',
                pageable: true,

              //  multiselect: true,

                jsonReader:
                {
                    root: "rows",
                    page: "page",
                    total: "total",
                    records: "records",
                    repeatitems: false,
                    Id: "0"
                },
                autowidth: true,
                excel: true,
                rowattr: function (rd) {                    
                    return { "class": "rowClass" };
                    //alert("hi");


                },
                loadComplete: function ()
                {
                   
                    var rows = $("#grid").getDataIDs();

                    for (var i = 0; i < rows.length; i++)
                    {
                      
                        var status = $("#grid").getCell(rows[i], "Status");
                    //    var data = status.split('##')[0];

                        var data1 = status.split('##')[0];
                       
                        var data = data1.split('.')[0];

                
                        data = jQuery.trim(data);

                        if (data == "PACKED") {
                          //  $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', weightfont: 'bold', background: 'blue' });
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#c9c539' });                   
                        }
                        else if (data == "PICKED") {
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#f78e32' });
                        }

                        else if(data == "RETURN")
                        {
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: 'red' });
                        }
                        else if (data == "ON THE WAY") {
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#64a13a' });
                        }
                        else if (data == "COMPLETED") {
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#417db1' });
                        }
                        else if (data == "DELIVERED") {
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#0c554e' });
                        }
                        else if (data == "CREATED") {

                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'black', background: 'white' });

                        }
                        else if (data == "LOADED") {

                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#45b0de' });

                        }
                        else
                            
                        {
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: '#621012', background: 'white' }); //#f8dd8c

                        }


                    }


                    $('#LoadingBar').hide();



                },
             
            
            }).navGrid('#pager',
            {
                search: true,
                edit: false,
                add: false,
                del: false,
                refresh: true,
                searchtext: "Search",

            }

          );
        }
        else if (var2 == "##$$") {
            var myGrid = $("#grid").jqGrid({
                // $("#grid").jqGrid
                // ({
                //  url: "/Home/GetValues?Type=" + Type + "&UserId=" + UserId + "&DepartmentId=" + DepartmentId + "&FromDate='" + FromDate + "'&ToDate='" + ToDate + "'&Variable1='" + Variable1 + "'&Variable2='" + Variable2 + "'",
                url: "/Home/GetValues?Type=" + Type + "&UserId=" + UserId + "&DepartmentId=" + DepartmentId + "&FromDate=" + FromDate + "&ToDate=" + ToDate + "&Variable1=" + Variable1 + "&Variable2=" + var2,
                datatype: 'json',
                mtype: 'Get',
                colNames: ['Sl#', 'BRANCH', 'SALESMAN', 'Order Type', 'Bill No', 'Date/Time', 'Location', 'ItemCode', 'Item Description', 'Inv Qty', 'PICKED QTY', 'PACKED QTY', 'RETURNED QTY', 'PICK BALANCE', 'PACK BALANCE', 'PACKAGE NO', 'Delivery Area', 'STATUS', 'STATUS DATETIME', 'TRIP NO', 'TRUCK NO', 'DRIVER', 'PICKED BY', 'PACKED BY', 'LOADED BY', 'PICKED DATE', 'PACKED DATE', 'LOADED DATE','INV PHOTO','Remarks Sales','Remarks Driver' ,'Assigned (L)' ],
                colModel: [
          
          
                         
                 {
                     key: false,
                     name: 'Title',
                     index: 'Title',
                     editable: true,
                     search: true,
                     formatter: getbranch,//BRANCH
                     searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                 },
               {
                   key: false,
                   name: 'ExceededTime',
                   index: 'ExceededTime',//SALESMAN
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'Title',
                   index: 'Title',//ordertype
                   editable: true,
                   search: true,
                   formatter: getordertype3,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               }
               , {
                   key: false,
                   name: 'WorkItemId',
                   index: 'WorkItemId',//billno
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'AssignedOnDate',
                   index: 'AssignedOnDate',//date/time
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'DepartmentName',
                   index: 'DepartmentName',//location
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },             
                {
                    key: false,
                    name: 'Description',
                    index: 'Description',//itemcode
                    editable: true,
                    search: true,
                    searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }

                },
               {
                   key: false,
                   name: 'DriverName',    
                   index: 'DriverName',//itemdescription
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'StoreKeeper',//inv qty
                   index: 'StoreKeeper', //parseInt(result[i].StoreKeeper||0)
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
              
               {
                   key: false,
                   name: 'DivisionName',
                   index: 'DivisionName',//pickedqty
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'TurnAroundTimes',
                   index: 'TurnAroundTimes',//packedqty
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'NewWorkRemarks',
                   index: 'NewWorkRemarks',//returnedqty
                   editable: true,
                   search: true,
                   formatter: getreturnedqty,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'BillNo',   // pickbalance
                   index: 'BillNo',
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },

               {
                   key: false,
                   name: 'AssignedByUser',
                   index: 'AssignedByUser',//packbalance
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'BillDeptId',
                   index: 'BillDeptId',//packege no
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
                {
                    key: false,
                    name: 'Title',
                    index: 'Title',//deliveryarea
                    editable: true,
                    search: true,
                    formatter: getdeliveryarea,
                    searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                },

                {
                    key: false,
                    name: 'Status',
                    index: 'Status',//status
                    editable: true,
                    search: true,
                    searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                },
                 {
                     key: false,
                     name: 'NewWorkRemarks',
                     index: 'NewWorkRemarks',//statusdatetime
                     editable: true,
                     search: true,
                     formatter: getstatusdatetime,
                     searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                 }, {
                     key: false,
                     name: 'NewWorkRemarks',
                     index: 'NewWorkRemarks',//tripno
                     editable: true,
                     search: true,
                     formatter: gettripno,
                     searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                 },
                 {
                     key: false,
                     name: 'NewWorkRemarks',
                     index: 'NewWorkRemarks',//truckno
                     editable: true,
                     search: true,
                     formatter: gettruckno,
                     searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                 }, {
                     key: false,
                     name: 'Driver',
                     index: 'Driver',//driver
                     editable: true,
                     search: true,
                     searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                 },
                 {
                     key: false,
                     name: 'StoreKeeperId',
                     index: 'StoreKeeperId',//pickedby
                     editable: true,
                     search: true,
                     searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                 },
                  {
                      key: false,
                      name: 'UpdatedOn',
                      index: 'UpdatedOn',//packed by
                      editable: true,
                      search: true,
                      searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                  },//  'DRIVER', 'PICKED BY', 'PACKED BY', 'LOADED BY', 'PICKED DATE', 'PACKED DATE', 'LOADED DATE'
                  {
                      key: false,
                      name: 'Reference',
                      index: 'Reference',//loaded by
                      editable: true,
                      search: true,
                      searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                  }, {
                      key: false,
                      name: 'BillSlNo',
                      index: 'BillSlNo',//pickeddate
                      editable: true,
                      search: true,
                      searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                  },

                   {
                       key: false,
                       name: 'Remarks',
                       index: 'Remarks',//packeddate
                       editable: true,
                       search: true,
                       searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                   },
                  {
                      key: false,
                      name: 'MinuteDiff',
                      index: 'MinuteDiff',//loadeddate
                      editable: true,
                      search: true,
                      searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                  },

                   {
                       key: false,
                       name: 'NewWorkRemarks',
                       index: 'NewWorkRemarks',//invphoto
                       editable: true,
                       search: true,
                       formatter: getinvphoto,
                       searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                   },
                    {
                        key: false,
                        name: 'Title',
                        index: 'Title',//Remarks Sales
                        editable: true,
                        search: true,
                        formatter: getremarkssales,
                        searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                    },
                     {
                         key: false,
                         name: 'Title',
                         index: 'Title',//RemarksDriver 
                         editable: true,
                         search: true,
                         formatter: getremarksdriver ,
                         searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                     },
                       {
                     key: false,
                     name: 'NewWorkRemarks',
                     index: 'NewWorkRemarks',//Assigned (L) 
                     editable: true,
                     search: true,
                     formatter: getassignedL,
                     searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
                 },
                ],

                pager: jQuery('#pager'),
                // pager: '#grid',
                //   rowNum: 50,
                rowList: [20, 30, 40, 50, 60, 70, 80, 90, 100],
                rownumbers: true,
                viewrecords: true,
                caption: 'Details',
                emptyrecords: 'No records to display',
                //   page:1,
                // rowNum: 20,
                // rowList: [50, 60, 70, 80, 90],
                rowNum: 99999,
                height: '100%',
                autowidth: true,
                ignoreCase: true,
                loadonce: true,
                gridview: true,
                // width:'100%',
                // loadonce: true,
                //  gridview: true,
                sortable: true,
                sortorder: 'desc',
                pageable: true,

                //  multiselect: true,

                jsonReader:
                {
                    root: "rows",
                    page: "page",
                    total: "total",
                    records: "records",
                    repeatitems: false,
                    Id: "0"
                },
                autowidth: true,
                excel: true,
                rowattr: function (rd) {
                    return { "class": "rowClass" };
                    //alert("hi");


                },
                loadComplete: function () {

                    var rows = $("#grid").getDataIDs();

                    for (var i = 0; i < rows.length; i++) {
                     
                        var status = $("#grid").getCell(rows[i], "Status");
                        var data = status.split('##')[0];
                        // $(rowObject).removeClass('active');
                        // $(a).addClass('streturn');
                        data = jQuery.trim(data);

                        if (data == "PACKED") {
                            //  $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', weightfont: 'bold', background: 'blue' });
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#c9c539' });
                        }
                        else if (data == "PICKED") {
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#f78e32' });
                        }

                        else if (data == "RETURN") {
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: 'red' });
                        }
                        else if (data == "ON THE WAY") {
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#64a13a' });
                        }
                        else if (data == "COMPLETED") {
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#417db1' });
                        }
                        else if (data == "DELIVERED") {
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#0c554e' });
                        }
                        else if (data == "CREATED") {

                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'black', background: 'white' });

                        }
                        else if (data == "LOADED") {

                            $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#45b0de' });

                        }
                        else {
                            $("#grid").jqGrid('setRowData', rows[i], false, { color: '#621012', background: 'white' }); //#f8dd8c

                        }


                    }
                },


            }).navGrid('#pager',
           {
               search: true,
               edit: false,
               add: false,
               del: false,
               refresh: true,
               searchtext: "Search",

           }

         );


        }
        else {
            $("#grid").jqGrid("clearGridData", true).trigger("reloadGrid");

            var myGrid = $("#grid").jqGrid({
                // $("#grid").jqGrid
                // ({
                //   url: "/Home/GetValues?Type=" + Type + "&UserId=" + UserId + "&DepartmentId=" + DepartmentId + "&FromDate='" + FromDate + "'&ToDate='" + ToDate + "'&Variable1='" + Variable1 + "'&Variable2=" + Variable2,
                url: "/Home/GetValues?Type=" + Type + "&UserId=" + UserId + "&DepartmentId=" + DepartmentId + "&FromDate=" + FromDate + "&ToDate=" + ToDate + "&Variable1=" + Variable1 + "&Variable2=" + Variable2,
                datatype: 'json',
                mtype: 'GET',
                colNames: ['slno', 'Dept', 'Salesman', 'OrderType', 'Locn', 'BillNo', 'Date/Time', 'Customer', 'DeliveryArea', 'Status', 'Remarks', 'Driver', 'Time'],//'PendingStatus',
                colModel: [
               {
                   key: true,
                   name: 'slno',
                   hidden: true,
                   index: 'slno',//sl
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'Dept',//Dept
                   index: 'Dept',//dep  //Title
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'AssignedByUser',//AssignedByUser
                   index: 'AssignedByUser',//salesman
                   editable: true,
                   search: true,
                   searchoptions: { "sopt": ["bw", "cn", "eq"] }
               }
               , {
                   key: false,
                   name: 'DriverName',
                   //  index: 'DriverName',//ordertype    //deliverytype
                   editable: true,
                   formatter: getordertype1,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'DriverName',
                   // index: 'DriverName',//loc   //AssignedOnDate.split('##')[1]
                   editable: true,
                   formatter: getlocation1,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'BillNumber',
                   //  index: 'BillNumber',//billno
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               {
                   key: false,
                   name: 'AssignedOnDate',
                   // index: 'AssignedOnDate',//date/time
                   editable: true,
                   //  formatter: getdatetime,
                   formatter: "date",
                   formatoptions: { srcformat: "ISO8601Long", newformat: "m/d/Y h:i A" },
               },
                {
                    key: false,
                    name: 'Description',
                    //   index: 'Description',//customer
                    editable: true,
                    search: true,
                    searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }

                },
               {
                   key: false,
                   name: 'StoreKeeper',     // 'StoreKeeper',
                   //  index: 'StoreKeeper',//deliveryarea
                   editable: true,
                   search: true,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               }, {
                   key: false,
                   name: 'Status',//status
                   //   index: 'Status',//result[i].Status.split('##')[0]
                   editable: true,
                   search: true,
                   // formatter: getstatus,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
               //{
               //    key: false,
               //    name: 'Status',
               //    //  index: 'Status',//pendingstatus
               //    editable: true, // var pendingstatus = result[i].Status.split('##')[1];
               //    search: true,
               //    // formatter: getpendingstatus,
               //    searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               //},
               {
                   key: false,
                   name: 'WorkRemarks',   // 'WorkRemarks',
                   //  index: 'WorkRemarks',//remarks
                   editable: true,
                   search: true,
                   // formatter: getremarks,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               }, {
                   key: false,
                   name: 'AssignedOnDate',
                   // index: 'AssignedOnDate',//lpo
                   editable: true,
                   search: true,
                   //  formatter: getlpo,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               }, {
                   key: false,
                   name: 'AssignedOnDate',
                   //  index: 'AssignedOnDate',//time
                   editable: true,
                   formatter: "date",
                   formatoptions: { srcformat: "ISO8601Long", newformat: "h:i A" },
                   search: true,
                   // formatter: gettime,
                   searchoptions: { sopt: ['cn', 'eq', 'ne', 'lt', 'le', 'gt', 'ge'] }
               },
                ],

                pager: jQuery('#pager'),
                // pager: '#pager',
                // pager: '#grid',
                rownumbers: true,
                viewrecords: true,
                caption: 'Details',
                emptyrecords: 'No records to display',
                //   page:1,
                // rowNum: 20,
                // rowList: [50, 60, 70, 80, 90],
                rowNum: 99999,
                height: '100%',
                autowidth: true,
                ignoreCase: true,
                loadonce: true,
                gridview: true,
                // width:'100%',
                // loadonce: true,
                //  gridview: true,
                sortable: true,
                //  ignoreCase: true,
                //   pageable: true,
                //  autoheight: true,

                //  toppager: true,
                // autowidth: false,
                excel: true,
                jsonReader:
                {
                    root: "rows",
                    page: "page",
                    total: "total",
                    records: "records",
                    repeatitems: false,
                    Id: "0"
                },

                //  multiselect: false
                //pager-you have to choose here what icons should appear at the bottom
                //like edit,create,delete icons
            }).navGrid('#pager',
            {
                search: true,
                edit: false,
                add: false,
                del: false,
                refresh: true,
                searchtext: "Search",

            }

     );
        }


       

        //$('#grid').on('reloadGrid', function () {
        //    var userData =  $('#grid').jqgrid('getGridParam', 'userData');
        //})
       // $('#grid').jqGrid('filterToolbar', { searchOnEnter: false,enableClear:false});

       $('#grid').jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: "cn", searchOperators: true, autosearch: true });

        $("#grid").jqGrid("setLabel", "rn", "SL#");
     
        jQuery("#grid").setGridParam({ rowNum: 15 }).trigger("reloadGrid");


        ///////////////////excel////////////////////
       
        //jQuery("#grid").jqGrid("navButtonAdd", '#pager', {
        //    caption: "Export to Excel",
        //    title: "Export to Excel(.XLSX)",
        //    onClickButton: function () {


        //        $("#grid").jqGrid("exportToExcel", {
        //            includeLabels: true,
        //            includeGroupHeader: true,
        //            includeFooter: true,
        //            fileName: "jqGridExport.xlsx",
        //            maxlength: 40 // maxlength for visible string data 
        //        })

        //    }
        //});


         jQuery("#grid").jqGrid('navButtonAdd', '#pager', {
             caption: "Export to Excel",
             onClickButton: function () {

                 exportExcel();

                 
             }
         });

      

    }

    @*<a class="btn btn-white exlbtn" href="/WMSDashdoardToExcel?Type=@Type&UserId=@UserId&DepartmentId=@DepartmentId&FromDate=@FromDate&ToDate=@ToDate&Variable1=@Variable1&Variable2=@Variable2" style="color:#000;"><i class="fa fa-file-excel"></i> Export To Excel</a>*@

    /////////export to excel

    //$("#export").on("click", function () {
    //    $("#grid").jqGrid("exportToExcel", {
    //        includeLabels: true,
    //        includeGroupHeader: true,
    //        includeFooter: true,
    //        fileName: "jqGridExport.xlsx",
    //        maxlength: 40 // maxlength for visible string data 
    //    })
    //})
    function exportExcel()
    {
        var FromDate = $('#DateFrom').val();
        var ToDate = $('#DateTo').val();
        var fname ="WMS_"+ FromDate +"-"+ ToDate;
       // $("#btnExporttoExcel").click(function () {
        if ($('#grid tr').length > 0) {
             exporttotable();

                $("#tbExport").table2excel({
                    filename: fname + ".xls"
                });
            }
            else {
                warningshow("No Data!");
            }
      //  });
    }

   function exportExcel() {
        var allData = $("#grid").jqGrid('getGridParam', 'data');
        if (!allData || allData.length === 0) { alert("No Data!"); return; }

        var rows = '<tr>' +
            '<td>SL</td><td>Dept</td><td>Salesman</td><td>Order Type</td>' +
            '<td>Location</td><td>Bill No</td><td>Date/Time</td><td>Customer</td>' +
            '<td>Branch</td><td>Status</td><td>Remarks</td><td>LPO</td>' +
            '<td>Driver</td><td>Time</td>' +
            '</tr>';

        for (var i = 0; i < allData.length; i++) {
            var d  = allData[i];               // ← index into the array each iteration
            var dt = d.AssignedOnDate || '';

            var datetime  = dt.split('##')[0] || '';
            var location  = dt.split('##')[1] || '';
            var remarks   = dt.split('##')[2] || '';
            var lpo       = dt.split('##')[3] || '';
            var time      = dt.split('##')[4] || '';
            var status    = (d.Status || '').split('##')[0];
            var ordertype = d.Div || d.NewWorkRemarks || '';

            rows += '<tr>' +
                '<td>' + (i + 1)                          + '</td>' +
                '<td>' + (d.DEPT      || '')               + '</td>' +
                '<td>' + (d.SALESMAN  || '')               + '</td>' +
                '<td>' + ordertype                         + '</td>' +
                '<td>' + (d.LOCATION  || location || '')   + '</td>' +
                '<td>' + (d.BILLNO    || '')               + '</td>' +
                '<td>' + datetime                          + '</td>' +
                '<td>' + (d.CUSTOMER  || '')               + '</td>' +
                '<td>' + (d.BRANCH    || '')               + '</td>' +
                '<td>' + status                            + '</td>' +
                '<td>' + remarks                           + '</td>' +
                '<td>' + lpo                               + '</td>' +
                '<td>' + (d.DRIVER    || '')               + '</td>' +
                '<td>' + time                              + '</td>' +
                '</tr>';
        }

        $('#tbExport').html(rows);
        var fname = "WMS_" + ($('#DateFrom').val() || 'All') + "-" + ($('#DateTo').val() || 'All');
        $("#tbExport").table2excel({ filename: fname + ".xls" });
    }
    //function exportExcel($id)
    //{
  
    //    var Flag = 0;
    //    var   ERPUserId = parseInt(window.LoggedInUserArray[0]);
    //    var   ERPDeptId = parseInt(window.LoggedInUserArray[1]);

    //    var UserId = ERPUserId;
    //    var DepartmentId = ERPDeptId;
    //    var FromDate = $('#DateFrom').val();
    //    var ToDate = $('#DateTo').val();
    //    var Variable1 = "1=1";
    //    var Variable2 = "##";


    //    var data = {};
    //    data.Type = Flag;
    //    data.UserId = UserId;
    //    data.DepartmentId = DepartmentId;
    //    data.FromDate = FromDate;
    //    data.ToDate = ToDate;
    //    data.Variable1 = Variable1;
    //    data.Variable2 = Variable2;
    //    $.ajax({
    //        type: "POST",
    //        url: "../Home/WMSDashdoardToExcel",
    //        data: data,
    //        success: function (result) {
    //          //  TermsLoad(result, id);
    //        }
    //    });
    //}
    //function exportExcel($id) {
    //   // alert('excelExport');
    //    var keys = [], ii = 0, rows = "";
    //    var ids = $id.getRowData();  // Get All IDs
    //    var row = $id.getRowData(ids[0]);     // Get First row to get the labels
    //    for (var k in row) {
    //        keys[ii++] = k;    // capture col names
    //        rows = rows + k + "\t";     // output each Column as tab delimited
    //    }
    //    rows = rows + "\n";   // Output header with end of line
    //    for (i = 0; i < ids.length; i++) {
    //        row = $id.getRowData(ids[i]); // get each row
    //        for (j = 0; j < keys.length; j++) rows = rows + row[keys[j]] + "\t"; // output each Row as tab delimited
    //        rows = rows + "\n";  // output each row with end of line
    //    }
    //    rows = rows + "\n";  // end of line at the end
    //    var form = "<form name='csvexportform' action='WMSDashdoardToExcel' method='post'>";
    //    form = form + "<input type='hidden' name='csvBuffer' value='" + rows + "'>";
    //    form = form + "</form><script>document.csvexportform.submit();</sc" + "ript>";
    //    OpenWindow = window.open('', '');
    //    OpenWindow.document.write(form);
    //    OpenWindow.document.close();
    //}
    //////////////




    function getordertype(cellValue, opts, rowObject) {

  
        var deliverytype = '';
        if (cellValue == '' || cellValue == null) {
            // deliverytype = cellValue.NewWorkRemarks;

            deliverytype = rowObject.NewWorkRemarks;
            // $("#" + rowObject.id).hide();



        }
        else {
            deliverytype = cellValue;
        }




        //if (cellValue == null || cellValue == 1451520000) {
        //    return '';
        //} else {
        //  var data = cellValue.split('#')[1];
        return deliverytype;
        // }

    }
    function getlocation(cellValue, opts, rowObject) {
        //AssignedOnDate.split('##')[1]
        if (cellValue == null || cellValue == 1451520000) {
            return '';
        } else {

            //   var data = cellValue.split('#')[2];
            var data = cellValue.split('##')[1];

            return data;
        }
    }

    function getdatetime(cellValue, opts, rowObject) {
        if (cellValue == null || cellValue == 1451520000) {
            return '';
        } else {
            var data = cellValue.split('##')[0];
            return data;
        }
    }
    function getstatus(cellValue, options, rowObject) {
        if (cellValue == null || cellValue == 1451520000) {
            return '';
        } else {
            var data = cellValue.split('##')[0];
 

         
           // $(rowObject).removeClass('active');

           // $(a).addClass('streturn');
            data = jQuery.trim(data);
         
            var billno = rowObject.BILLNO;
            var location = rowObject.LOCATION;
            var oldstatus = data;

            var ERPUserId;
            var ERPDeptId;
            if (window.localStorage != null) {
                var cat = (localStorage.getItem('nanana'));
                if (cat == null) {
                    UserLogout();
                    //window.location = '../Home/Login';
                    //localStorage.clear();

                }
                else {

                    var PrevDepartment = '';
                    PrevDepartment = localStorage.getItem('nanana');
                    var res = cat.split(":");
                    window.LoggedInUserArray = res;
                    window.LoggedInUser = window.LoggedInUserArray[1];
                }

            }
            var UserLocationId = parseInt(window.LoggedInUserArray[2]);
            ERPUserId = parseInt(window.LoggedInUserArray[0]);
            ERPDeptId = parseInt(window.LoggedInUserArray[1]);

            var button = '';
            if (ERPDeptId == 1)
            {
              
              //  var rowId = options.pos;
                var rowId = options.rowId;
                button = "<button id='btnEditStatus' style='background-color: unset;border: unset;float: right;' onclick='EditStatus(" + billno + ",this)' data-rowid='" + rowId + "' data-loc='" + location + "' data-oldstatus='" + oldstatus + "' ><img src='../ImagesUploaded/editbgnull.png' style='height:20px;width:25px' /></button> ";

            }
                      return data+"."+button;
        }
    }


    ////////////////////////////////
    function EditStatus(billno,element)
    {
        $('#EditStatusBillNo').val('');
        $('#Location').val('');
        $('#StatusOld').val('');
        
        $('#StatusNew').val('');

        $('#rowId').val('');

        

        $('#OTPDiv').show();

        var Location = $(element).data("loc");
        var OldStatus = $(element).data("oldstatus");

        var rowId = $(element).data("rowid");


        $('#EditStatusBillNo').val(billno);
        $('#Location').val(Location);
        $('#StatusOld').val(OldStatus);
       
        $('#rowId').val(rowId);

    }
   

    function CheckEdit() {
        var BillNo = $('#EditStatusBillNo').val();
       


        if ($.trim($('#txtotp').val()) == '') {
            alert('Enter OTP');
        }
        else if ($.trim($('#otpremarks').val()) == '') {
            alert('Enter Remarks');
        }
        else {

            var ERPUserId;
            var ERPDeptId;
            if (window.localStorage != null) {
                var cat = (localStorage.getItem('nanana'));
                if (cat == null) {
                    UserLogout();
                    //window.location = '../Home/Login';
                    //localStorage.clear();

                }
                else {

                    var PrevDepartment = '';
                    PrevDepartment = localStorage.getItem('nanana');
                    var res = cat.split(":");
                    window.LoggedInUserArray = res;
                    window.LoggedInUser = window.LoggedInUserArray[1];
                }

            }
            var UserLocationId = parseInt(window.LoggedInUserArray[2]);
            ERPUserId = parseInt(window.LoggedInUserArray[0]);
            ERPDeptId = parseInt(window.LoggedInUserArray[1]);


            var data = {};
            data.UserId = 214;
            data.OTP = $("#txtotp").val();
            data.Remarks = $('#otpremarks').val();
            data.Operation = 'OTP - Edit Status , Bill No : ' + BillNo;
            data.DeptId = ERPDeptId;
            $.ajax({
                type: "POST",
                url: "../Home/OTPCheckforUser",
                data: data,
                success: function (Status) {
                    //for (var i = 0; i < result.oList.length; i++) {
                    //    var status = result.oList[i].Status;
                    OTPCheck(Status)
                    //}
                }
            });
        }
    }

    function OTPCheck(Status) {
        if (Status == 1) {
            EditInvoice();
        }
        else {
          //  warningshow('Invalid OTP', 'txtotp');
            alert('Invalid OTP');
            $("#txtotp").select();
        }
    }

    function EditInvoice() {
        $('#OTPDiv').hide();
        $('#txtotp').val('')

        $('#StatusDiv').show();


    }
    
    $("#btnstatussave").click(function (e) {
        var statusnew = $('#statusedit').find(":selected").val();

        //e.preventDefault();
        var data = {};
        data.Status = $('#statusedit').find(":selected").val();
        data.BillNo = $('#EditStatusBillNo').val();
        data.Location = $('#Location').val();
        data.StatusOld = $('#StatusOld').val();

        $.ajax({
            type: "POST",
            url: "../Home/UpdateStatus",
            data: data,
            success: function (result) {
                alert('success');
                $('#StatusDiv').hide();
                $('#statusedit').val('');
                //  location.reload();


                ////////////////



                $('#StatusNew').val(statusnew);

                var data = data = jQuery.trim(statusnew);
                var rows = $("#grid").getDataIDs();


                var i = parseInt($("#rowId").val() - 1);

                //   for (var i = 0; i < rows.length; i++) {

                if (data == "PACKED") {
                    $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#c9c539' });
                }
                else if (data == "PICKED") {
                    $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#f78e32' });
                }

                else if (data == "RETURN") {
                    $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: 'red' });
                }
                else if (data == "ON THE WAY") {
                    $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#64a13a' });
                }
                else if (data == "COMPLETED") {
                    $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#417db1' });
                }
                else if (data == "DELIVERED") {
                    $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#0c554e' });
                }
                else if (data == "CREATED") {

                    $("#grid").jqGrid('setRowData', rows[i], false, { color: 'black', background: 'white' });

                }
                else if (data == "LOADED") {

                    $("#grid").jqGrid('setRowData', rows[i], false, { color: 'white', background: '#45b0de' });

                }
                else {
                    $("#grid").jqGrid('setRowData', rows[i], false, { color: '#621012', background: 'white' }); //#f8dd8c

                }


     


              //  $("#grid").jqGrid('setCell', i, statusnew, '', 'Status');

                $("#grid").jqGrid('setCell', $("#rowId").val(), 'Status', statusnew);
                //var cm = $("#grid").jqGrid('getGridParam', 'colModel');
                //     if (cm[i].name === 'Status') {
                //        return statusnew; 
                //         //  $(searchText)[0].innerText
                        
                //}

                //  $("#grid").jqGrid('setRowData', rows[i], statusnew);
                //  $("#grid").getCell(rows[i], "Status") = statusnew;
                //}



                /////////////



            }
        });
    });




    function getpendingstatus(cellValue, opts, rowObject) {
        if (cellValue == null || cellValue == 1451520000) {
            return '';
        } else {
            var data = cellValue.split('##')[1];
            return data;
        }
    }

    function getremarks(cellValue, opts, rowObject) {
        if (cellValue == null || cellValue == 1451520000) {
            return '';
        } else {
            var data = cellValue.split('##')[2];
            return data;
        }
    }
    function getlpo(cellValue, opts, rowObject) {
        if (cellValue == null || cellValue == 1451520000) {
            return '';
        } else {
            var data = cellValue.split('##')[3];
            return data;
        }
    }
    function gettime(cellValue, opts, rowObject) {
        if (cellValue == null || cellValue == 1451520000) {
            return '';
        } else {
            var data = cellValue.split('##')[4];
            return data;
        }
    }

    function getordertype1(cellValue, opts, rowObject) {


        if (cellValue == null || cellValue == 1451520000) {
            return '';
        }
        else {
            var data = cellValue.split('#')[1];
            return data;
        }

    }

    function getlocation1(cellValue, opts, rowObject) {

        if (cellValue == null || cellValue == 1451520000) {
            return '';
        } else {

            var data = cellValue.split('#')[2];

            return data;
        }
    }
    /////////////////##$$/////////
    function getbranch(cellValue, opts, rowObject) {


        if (cellValue == null || cellValue == 1451520000) {
            return '';
        }
        else {
            var data = cellValue.split('##')[0];
            return data;
        }

    }
    function getordertype3(cellValue, opts, rowObject) {


        if (cellValue == null || cellValue == 1451520000) {
            return '';
        }
        else {
            var data = cellValue.split('##')[1];
            return data;
        }

    }

    function getreturnedqty(cellValue, opts, rowObject) {


        if (cellValue == null || cellValue == 1451520000) {
            return '';
        }
        else {
            var data = cellValue.split('##')[4];
            return data;
        }

    }
    function getdeliveryarea(cellValue, opts, rowObject) {


        if (cellValue == null || cellValue == 1451520000) {
            return '';
        }
        else {
            var data = cellValue.split('##')[2];
            return data;
        }

    }
    function getstatusdatetime(cellValue, opts, rowObject) {


        if (cellValue == null || cellValue == 1451520000) {
            return '';
        }
        else {
            var data = cellValue.split('##')[3];
            return data;
        }

    }
    function gettripno(cellValue, opts, rowObject) {


        if (cellValue == null || cellValue == 1451520000) {
            return '';
        }
        else {
            var data = cellValue.split('##')[0];
            return data;
        }

    }
    function gettruckno(cellValue, opts, rowObject) {


        if (cellValue == null || cellValue == 1451520000) {
            return '';
        }
        else {
            var data = cellValue.split('##')[1];
            return data;
        }

    }
    function getinvphoto(cellValue, opts, rowObject) {


        if (cellValue == null || cellValue == 1451520000) {
            return '';
        }
        else {
          //  var pathnew = result[i].NewWorkRemarks.split('##')[2] == '' ? '../app-assets/img/NoImage.png' : result[i].NewWorkRemarks.split('##')[2]
          //  var pathnew1 = result[i].NewWorkRemarks.split('##')[2] == '' ? '../app-assets/img/NoImage.png' : result[i].NewWorkRemarks.split('##')[2].split(',')[0]
            //<a onclick='"+'imageslider('+'"'+pathnew+'"'+')'+"'><img src='../../"+pathnew1+"'  height='50px' width='80px'/></a>
            var data = cellValue;
            return data;
        }

    }
    function getremarkssales(cellValue, opts, rowObject) {


        if (cellValue == null || cellValue == 1451520000) {
            return '';
        }
        else {
            var data = cellValue.split('##')[3];
            return data;
        }

    }
    function getremarksdriver(cellValue, opts, rowObject) {


        if (cellValue == null || cellValue == 1451520000) {
            return '';
        }
        else {
            var data = cellValue.split('##')[4];
            return data;
        }

    }
    function getassignedL(cellValue, opts, rowObject) {


        if (cellValue == null || cellValue == 1451520000) {
            return '';
        }
        else {
            var data = cellValue.split('##')[5];
            return data;
        }

    }

  
</script>



<style>
    #pager{
        height:50px;
    }
    #pg_pager{
        height:50px;

    }
    #pager_center{
        font-size: 20px;
    }
    .ui-jqgrid .ui-pg-input {
        height: 25px !important;
    }
    .ui-jqgrid .ui-pg-selbox {
        height: 25px !important;
    }

    .ui-icon {
        width: 20px !important;
        height: 20px !important;
    }

    .ui-jqgrid .ui-pg-button span {
        margin: 5px !important;
    }
</style>






<link href="~/Content/themes/base/jquery-ui.css" rel="stylesheet" />
<link href="~/Content/jquery.jqGrid/ui.jqgrid.css" rel="stylesheet" />
@*<script src="~/Scripts/jquery-1.9.1.min.js"></script>
<script src="~/Scripts/jquery-ui-1.10.4.min.js"></script>*@
<script src="~/Scripts/i18n/grid.locale-en.js"></script>
<script src="~/Scripts/jquery.jqGrid.min.js"></script>