@extends('layouts.main')
@section('title')
    Procurement Purchase Orders
@stop
@section('navigation')
    <ul class="breadcrumb">
        <li><a href="{{route('home')}}">Dashboard</a> <span class="divider">/</span></li>
        <li><a href="">Procurement Management</a> <span class="divider">/</span></li>
        <li class="active">Purchase Orders</li>
    </ul>
@stop

@section('msghead_menu')
    <li class="right btn-group">
        <button class="btn " style="margin-right: 2px" onclick="openAdvancedSearch('local_purchase_order_filters')">
            <span class="icon-search"></span> &nbsp; FILTER
        </button>

        @if(auth()->user()->can('RECEIVE GOODS'))
            <button class="btn" style="margin-right: 2px" id="receive_goods"> RECEIVE GOODS</button>
        @endif
        @if(auth()->user()->can('CLOSE PURCHASE ORDERS'))
            <button class="btn" style="margin-right: 2px" id="close_this_order"> CLOSE ORDER</button>
            </button>
        @endif
        @if(auth()->user()->can('SEND PURCHASE ORDERS'))
            {{--<button class="btn" style="margin-right: 2px"> SEND LPO</button>--}}
        @endif
        {{--        @if(auth()->user()->can('CREATE PURCHASE ORDERS'))--}}
        {{--            <button class="btn" style="margin-right: 2px" onclick="create('{{route('procurement.purchase_orders.create')}}')"><span--}}
        {{--                        class="icon icon-list"></span>CREATE PURCHASE ORDER--}}
        {{--            </button>--}}
        {{--        @endif--}}
    </li>
@stop

@section('contentinner')
    <div id="local_purchase_order_filters" class="sidenav">
        <a href="javascript:void(0)" class="closebtn"
           onclick="closeAdvancedSearch('local_purchase_order_filters')">&times;</a>
        <form target="_blank" class="form-inline form-filter" method="get"
              action="#">

            <label class="control-label" for="Category"> Date from </label><br>
            <select id="start_month" name="start_month" class="searchable_select"
                    style="width: 60px">
                <option value="ALL">ALL</option>
                <option value="12" {{ date('m') == 12 ? 'selected' : '' }}>Dec</option>
                <option value="11" {{ date('m') == 11 ? 'selected' : '' }}>Nov</option>
                <option value="10" {{ date('m') == 10 ? 'selected' : '' }}>Oct</option>
                <option value="09" {{ date('m') == 9 ? 'selected' : '' }}>Sept</option>
                <option value="08" {{ date('m') == 8 ? 'selected' : '' }}>Aug</option>
                <option value="07" {{ date('m') == 7 ? 'selected' : '' }}>Jul</option>
                <option value="06" {{ date('m') == 6 ? 'selected' : '' }}>Jun</option>
                <option value="05" {{ date('m') == 5 ? 'selected' : '' }}>May</option>
                <option value="04" {{ date('m') == 4 ? 'selected' : '' }}>Apr</option>
                <option value="03" {{ date('m') == 3 ? 'selected' : '' }}>Mar</option>
                <option value="02" {{ date('m') == 2 ? 'selected' : '' }}>Febr</option>
                <option value="01" {{ date('m') == 1 ? 'selected' : '' }}>Jan</option>
            </select>
            <select id="start_day" name="start_day" class="searchable_select" style="width: 60px">
                <option value="ALL">D</option>
                @foreach($days as $day)
                    <option value="{{$day}}" {{ $day == 1 ? 'selected' : '' }}>{{$day}}</option>
                @endforeach
            </select>
            <select id="start_year" name="start_year" class="searchable_select" style="width: 80px">
                <option value="ALL">Y</option>
                @foreach($years as $year)
                    <option value="{{$year}}" {{ date('Y') == $year ? 'selected' : '' }}>{{$year}}</option>
                @endforeach
            </select>
            <label class="control-label" for="Category"> Date To </label><br/>
            <select id="end_month" name="end_month" class="searchable_select"
                    style="width: 60px">
                <option value="ALL">ALL</option>
                <option value="12" {{ date('m') == 12 ? 'selected' : '' }}>Dec</option>
                <option value="11" {{ date('m') == 11 ? 'selected' : '' }}>Nov</option>
                <option value="10" {{ date('m') == 10 ? 'selected' : '' }}>Oct</option>
                <option value="09" {{ date('m') == 9 ? 'selected' : '' }}>Sept</option>
                <option value="08" {{ date('m') == 8 ? 'selected' : '' }}>Aug</option>
                <option value="07" {{ date('m') == 7 ? 'selected' : '' }}>Jul</option>
                <option value="06" {{ date('m') == 6 ? 'selected' : '' }}>Jun</option>
                <option value="05" {{ date('m') == 5 ? 'selected' : '' }}>May</option>
                <option value="04" {{ date('m') == 4 ? 'selected' : '' }}>Apr</option>
                <option value="03" {{ date('m') == 3 ? 'selected' : '' }}>Mar</option>
                <option value="02" {{ date('m') == 2 ? 'selected' : '' }}>Febr</option>
                <option value="01" {{ date('m') == 1 ? 'selected' : '' }}>Jan</option>
            </select>
            <select id="end_day" name="end_day" class="searchable_select" style="width: 80px">
                <option value="ALL">D</option>
                @foreach($days as $day)
                    <option value="{{$day}}" {{ $day == date('d') ? 'selected' : '' }}>{{$day}}</option>
                @endforeach
            </select>
            <select id="end_year" name="end_year" class="searchable_select"
                    style="width: 80px">
                <option value="ALL">Y</option>
                @foreach($years as $year)
                    <option value="{{$year}}" {{ date('Y') == $year ? 'selected' : '' }}>{{$year}}</option>
                @endforeach
            </select><br/>
            <label class="control-label" for="this_purchase_order_id">LPO #</label>
            <input id="this_purchase_order_id" class="span12" value="">
            <label class="control-label" for="request_no">Req #</label>
            <input id="requisition_id" class="span12" value="">
            <label class="control-label" for="purchase_order_requisition_type">Type</label>
            <select name="select" width="100%" id="purchase_order_requisition_type" class="searchable">
                @if(auth()->user()->can('SEARCH ALL LPO'))
                    <option value="ALL">All</option>
                @endif
                @if(auth()->user()->can('SEARCH FUEL LPO'))
                    <option value="FUEL" {{ $type == 'FUEL' ? 'selected' : '' }}>FUEL LPO</option>
                @endif
                @if(auth()->user()->can('SEARCH FUEL LPO'))
                    <option value="TRIP" {{ $type == 'TRIP' ? 'selected' : '' }}>TRIP LPO</option>
                @endif
                @if(auth()->user()->can('SEARCH JOB CARD LPO'))
                    <option value="SPARE_PART" {{ $type == 'SPARE_PART' ? 'selected' : '' }}>SPARE PARTS LPO</option>
                @endif
                @if(auth()->user()->can('SEARCH GENERAL LPO'))
                    <option value="SERVICE" {{ $type == 'SERVICE' ? 'selected' : '' }}>SERVICE LPO</option>
                @endif
                @if(auth()->user()->can('SEARCH GENERAL LPO'))
                    <option value="GENERAL" {{ $type == 'GENERAL' ? 'selected' : '' }}>GENERAL LPO</option>
                @endif

            </select>
            <label class="control-label" for="cost_center_id">Cost Center</label>
            <select name="cost_center_id" width="100%" id="cost_center_id" class="searchable">
                <option value=""></option>
                @foreach(\App\Model\CostCenter::all() as $cost_center)
                    <option value="{{$cost_center->id}}">{{$cost_center->name}}</option>
                @endforeach
            </select>

            <label class="control-label" for="vendor_id">Supplier</label>
            <select name="vendor_id" width="100%" id="vendor_id" class="searchable">
                <option value=""></option>
                @foreach($vendors as $vendor)
                    <option value="{{$vendor->id}}">{{$vendor->name}}</option>
                @endforeach
            </select>
            <label class="control-label" for="vendor_id">Created By</label>
            <select name="employee_id" width="100%" id="employee_id" class="searchable">
                <option value=""></option>
                @foreach($employees as $employee)
                    <option value="{{$employee->employee_id}}">{{$employee->full_name}}</option>
                @endforeach
            </select>
            <label class="control-label" for="reference">Reference</label>
            <input id="reference" class="span12" value="">

            <label class="control-label" for="order_status">Status</label>
            <select name="order_status" width="100%" id="order_status" class="searchable">
                <option value="PENDING">PENDING</option>
                <option value="INCOMPLETE">INCOMPLETE</option>
                <option value="RECEIVED">RECEIVED</option>
                <option value="CANCELLED">CAANCELLED</option>
                <option value="CLOSED">CLOSED</option>
                <option value="">All</option>
            </select>
            <button class="btn" style="" id="filter_local_purchase_orders">FILTER</button>
            <input type="hidden" value="{{ $month }}" id="month">
            {{--<input class="btn" id="print_permits" type="submit" value="PRINT">--}}
        </form>
    </div>
    <style>
        .highlight-red {
            background-color: #db504b !important;
            color: #ffffff !important;
        }

        .maxl {
            margin: 25px;
        }

        .inline {
            display: inline-block;
        }

        .inline + .inline {
            margin-left: 10px;
        }

        .radio {
            color: #999;
            font-size: 15px;
            position: relative;
        }

        .radio span {
            position: relative;
            padding-left: 20px;
        }

        .radio span:after {
            content: '';
            width: 15px;
            height: 15px;
            border: 3px solid;
            position: absolute;
            left: 0;
            top: 1px;
            border-radius: 100%;
            -ms-border-radius: 100%;
            -moz-border-radius: 100%;
            -webkit-border-radius: 100%;
            box-sizing: border-box;
            -ms-box-sizing: border-box;
            -moz-box-sizing: border-box;
            -webkit-box-sizing: border-box;
        }

        .radio input[type="radio"] {
            cursor: pointer;
            position: absolute;
            width: 100%;
            height: 100%;
            z-index: 1;
            opacity: 0;
            filter: alpha(opacity=0);
            -ms-filter: "progid:DXImageTransform.Microsoft.Alpha(Opacity=0)"
        }

        .radio input[type="radio"]:checked + span {
            color: #bedaf6;
        }

        .radio input[type="radio"]:checked + span:before {
            content: '';
            width: 5px;
            height: 5px;
            position: absolute;
            background: #0B8;
            left: 5px;
            top: 6px;
            border-radius: 100%;
            -ms-border-radius: 100%;
            -moz-border-radius: 100%;
            -webkit-border-radius: 100%;
        }
    </style>
    <div class="row-fluid">
        <div class="span12">

            <table class="table table-bordered table-condensed logistics_table" width="100%" id="purchase_orders">
                <thead>
                <tr>
                    <th class="nosort" style="width: 10px;"><input type="checkbox" class="checkall"/></th>
                    <th style="width: 80px;">ORDER NO.</th>
                    <th style="width: 150px;">Date</th>
                    <th>Created By</th>
                    <th>Vendors</th>
                    <th>Quantity</th>
                    <th>Received</th>
                    <th>Status</th>
                    <th>Action</th>
                </tr>
                </thead>
            </table>
        </div><!--span12-->
    </div><!--row-fluid-->
    @include('stores.procurements.includes.purchase_order_modals')
    <form method="post" id="attachment_form" enctype="multipart/form-data" style="display:none">
        <input type="file" name="file">
    </form>
    <script>
        jQuery('.searchable').select2();

        var attachment_form = $('#attachment_form');
        var file_field = attachment_form.find('input:file');

        function uploadPurchaseOrderPrintout(url) {
            attachment_form.attr('action', url);
            file_field.trigger('click');
            file_field.change(function () {
                if (file_field.val()) {
                    $.ajax({
                        url: attachment_form.attr('action'),
                        data: new FormData($("#attachment_form")[0]),
                        dataType: 'json',
                        async: false,
                        type: 'post',
                        processData: false,
                        contentType: false,
                        beforeSend: function () {
                            startSpinner()
                        },
                        success: function (data) {
                            onAjaxSuccess(data);
                            if (data.state == 'Done') mainDataTable.draw();
                        },
                        error: function (xhr, textStatus, error) {
                            onAjaxError(xhr, textStatus, error)
                        },
                        complete: function () {
                            stopSpinner();
                            file_field.val(null)
                        }
                    });
                }
            });
        }

        var oTable = jQuery('#purchase_orders').on('error.dt', function (e, settings, techNote, message) {
            console.log(message);
            notify('Error Loading goods Issued Note List');
        })
            .DataTable({
                lengthMenu: [
                    [10, 50, 100],
                    ['10 Orders', '50 Orders', '100 Orders']
                ],
                "searching": false,
                "oLanguage": {
                    "sLoadingRecords": "Please wait - loading Purchase Orders Records...",
                    "sZeroRecords": "No Purchase Orders records to display.",
                    "sProcessing": "Please wait - loading records...",
                    "sInfoEmpty": "No entries to display.",
                    "sInfo": "Got a total of _TOTAL_ tire Orders to show (_START_ to _END_)",
                    "sInfoFiltered": " - filtering from _MAX_ records"
                },
                ajax: {
                    url: '{{route('procurement.purchase_orders.data-table')}}',
                    data: function (d) {
//                            d.route_number = jQuery('#route_number').val();
                        d.this_purchase_order_id = $('#this_purchase_order_id').val();
                        d.requisition_id = $('#requisition_id').val();
                        d.this_purchase_order_requisition_type = $('#purchase_order_requisition_type').val();
                        d.month = $('#month').val();
                        d.cost_center_id = $('#cost_center_id').val();
                        d.vendor_id = $('#vendor_id').val();
                        d.reference = $('#reference').val();
                        d.status = $('#order_status').val();
                        d.employee_id = $('#employee_id').val();
                        d.start_month =  $('#start_month').val();
                        d.start_day = $('#start_day').val();
                        d.start_year = $('#start_year').val();
                        d.end_month = $('#end_month').val();
                        d.end_day = $('#end_day').val();
                        d.end_year = $('#end_year').val();
                    },
                    error: function (xhr, textStatus, error) {
//                            alert(textStatus);
                        oTable.fnProcessingIndicator(false);
                    }
                },
                "order": [[2, "desc"]],
                scrollCollapse: true,
                "sPaginationType": "full_numbers",
                processing: true,
                serverSide: true,
                "columns": [
                    {data: 'checkbox'},
                    {"class": "link", data: 'order_number'},
                    {"class": "link", data: 'date'},
                    {"class": "link", data: 'creator'},
                    {"class": "link", data: 'vendors'},
                    {"class": "link", data: 'quantity'},
                    {"class": "link", data: 'received'},
                    {"class": "link", data: 'status'},
                    {"class": "link", data: 'action'}
                ],
                "fnDrawCallback": function () {
                    jQuery('.edit_purchase_order').on('click', function () {
                        var order_pr = jQuery(this).parents('tr');
                        var purchase_order_id = order_pr.find('.purchase_order_id').val();
                        var edit_url = "{{ route('procurement.purchase-orders.edit', [":id"]) }}";
                        var edit_url_ = edit_url.replace(':id', purchase_order_id);
                        jQuery.ajax({
                            url: edit_url_,
                            type: 'get',
                            data: {
                                purchase_order_id: purchase_order_id
                            },
                            success: function (data) {
                                jQuery('#edit_purchase_order_modal_body').empty().append(data);
                                jQuery('#edit_purchase_order_modal').appendTo("body").modal('toggle');
                            },
                            error: function (data) {
                                console.log('Error: ');
                                console.log(data);
                                jQuery.jGrowl('Error: Something went wrong');
                            }
                        });
                    });
                    jQuery('.delete_purchase_order').on('click', function (e) {
                        e.preventDefault();
                        var order_pr = jQuery(this).parents('tr');
                        var purchase_order_id = order_pr.find('.purchase_order_id').val();
                        var delete_url = "{{ route('procurement.purchase_order.destroy', [":id"]) }}";
                        var delete_url_ = delete_url.replace(':id', purchase_order_id);
                        jConfirm('ARE YOU SURE, YOU WANT TO DELETE ' + name, 'DELETE', function (r) {
                            if (r == true) {
                                jQuery.ajax({
                                    url: delete_url_,
                                    type: 'delete',
                                    data: {
                                        purchase_order_id: purchase_order_id
                                    },
                                    cache: false,
                                    success: function (data) {
                                        if (data == "DONE") {
                                            oTable.draw();
                                            jQuery.jGrowl('{!! HTML::image('img/truck.png') !!} PURCHASE ORDER IS DELETED SUCCESSFULLY ', {
                                                theme: 'contrastBorder',
                                                sticky: true
                                            });
                                        } else {
                                            jQuery.jGrowl('{!! HTML::image('img/truck.png') !!} THIS ORDER CAN NOT BE DELETED! ', {
                                                theme: 'contrastBorder',
                                                sticky: true
                                            });
                                        }

                                    }
                                });
                            }
                        });

                    });
                },
                "bStateSave": true
            });

        $('#filter_local_purchase_orders').on('click', function (e) {
            e.preventDefault();
            oTable.draw();
            // $('#this_purchase_order_id').val('').trigger('change');
        });


        jQuery('#receive_goods').click(function () {

            var purchase_order_id = checkRows('purchase_order_id');
            if (purchase_order_id.length != 1) {
                logistics_alert('PLEASE CHECK ONE ORDER TO CONTINUE', 'SELECTION DIALOG');
                /// jAlert("PLEASE CHECK ONE ORDER TO CONTINUE", 'SELECTION DIALOG');
                return false;
            }
            jQuery.ajax({
                url: "{{route('procurement.receive_purchase_order_create')}}",
                type: 'GET',
                data: {
                    purchase_order_id: purchase_order_id
                },
                beforeSend: function () {
                    startSpinner();
                },
                success: function (data) {
                    var modal = jQuery('#logistics_modal');
                    modal.empty().append(data);
                    modelShow('logistics_modal');
//                    onModalShown();
//
//                    var form = modal.find('form');
//                    form.on('submit', function (e) {
//                        e.preventDefault();
//                        storeOrUpdate(form, method);
//                    });
                },
                error: function (xhr, textStatus, error) {
                    onAjaxError(xhr, textStatus, error);
                },
                complete: function () {
                    stopSpinner();
                }
            });
            return false;
        });


        jQuery('#close_this_order').click(function () {

            var purchase_order_id = checkRows('purchase_order_id');
            if (purchase_order_id.length != 1) {
                logistics_alert('PLEASE CHECK ONE ORDER TO CONTINUE', 'SELECTION DIALOG');
                /// jAlert("PLEASE CHECK ONE ORDER TO CONTINUE", 'SELECTION DIALOG');
                return false;
            }
            jQuery.ajax({
                url: "{{route('procurement.purchase_orders.create_close_order_form')}}",
                type: 'get',
                data: {
                    purchase_order_id: purchase_order_id
                },
                beforeSend: function () {
                    startSpinner();
                },
                success: function (data) {
                    var modal = jQuery('#logistics_modal');
                    modal.empty().append(data);
                    modelShow('logistics_modal');
//                    onModalShown();
//
//                    var form = modal.find('form');
//                    form.on('submit', function (e) {
//                        e.preventDefault();
//                        storeOrUpdate(form, method);
//                    });
                },
                error: function (xhr, textStatus, error) {
                    onAjaxError(xhr, textStatus, error);
                },
                complete: function () {
                    stopSpinner();
                }
            });
            return false;
        });


        jQuery('#update_procurement_order_btn').on('click', function (e) {
            e.preventDefault();
            var url = "{{route('procurement.purchase-order.update')}}";
            var formData = jQuery('#edit_procurement_purchase_order_form').serialize();
            jQuery.ajax({
                url: url,
                type: 'post',
                data: formData,
                cache: false,
                success: function (data) {
                    oTable.draw();
                    if (data == 'DONE') {
                        jQuery.jGrowl('{!! HTML::image('img/truck.png') !!} PROCUREMENT PURCHASE ORDER IS UPDATED ', {
                            theme: 'contrastBorder',
                            sticky: true

                        });

                        jQuery('#edit_purchase_order_modal').modal('toggle');
                    } else {
                        jQuery.jGrowl('{!! HTML::image('img/truck.png') !!} THIS ORDER CAN\'T BE UPDATED ', {
                            theme: 'contrastBorder',
                            sticky: true

                        });
                    }
                    console.log(data);
                }
            });


        });
        jQuery('#close_procurement_purchase_order').click(function () {
            var checked_orders = checkedOrders();
            if (checked_orders.length == 0) {
                jAlert("Please Check  atleast Single Order to Continue", 'SELECTION DIALOG');
                return false;
            }
            jQuery.ajax({
                url: '{{route('procurement.purchase-orders.close')}}',
                type: 'post',
                data: {
                    purchase_order_id: checked_orders
                },
                success: function (html) {
                    oTable.draw();
                    if (html == 'DONE') {
                        jQuery.jGrowl('{!! HTML::image('img/truck.png') !!} PURCHASE ORDER CLOSED', {
                            theme: 'contrastBorder',
                            sticky: true
                        });
                        jQuery('#fuel-orders-lists').dataTable().fnFilter(this.value);
                    } else if (html == 'FAIL') {
                        alert("FAIL TO CLOSE ORDER.");
                    }
                }
            });
            return false;

        });
        jQuery('#receive_procurement_purchase_order_btn').on('click', function (e) {
            e.preventDefault();
            var url = "{{route('procurement.purchase_order_received.store')}}";
            var formData = jQuery('#receive_procurement_purchase_order_form').serialize();
            jQuery.ajax({
                url: url,
                type: 'post',
                data: formData,
                cache: false,
                success: function (data) {
                    oTable.draw();
                    if (data == "ERROR") {
                        jQuery.jGrowl('FILL ALL REQUIRED FIELD', {
                            theme: 'contrastBorder',
                            sticky: true

                        });
                    } else if (data == 'ORDER_IS_COMPLETE') {
                        jQuery.jGrowl('{!! HTML::image('img/truck.png') !!} THIS ORDER IS COMPLETE,IT CAN\'T BE RECEIVED ANY MORE!', {
                            theme: 'contrastBorder',
                            sticky: true
                        });
                    } else if (data == 'GREATER_THAN_AMOUNT_ORDERED') {
                        jQuery.jGrowl('{!! HTML::image('img/truck.png') !!} CAN\'T RECEIVED MORE THAN QUANTITY ORDERED!', {
                            theme: 'contrastBorder',
                            sticky: true
                        });
                    } else if (data == 'CANT_RECEIVE_ORDER') {
                        jQuery.jGrowl('{!! HTML::image('img/truck.png') !!} THIS ORDER IS CLOSED!', {
                            theme: 'contrastBorder',
                            sticky: true
                        });
                    } else {
                        jQuery.jGrowl('{!! HTML::image('img/truck.png') !!} PURCHASE ORDER IS  RECEIVED ', {
                            theme: 'contrastBorder',
                            sticky: true
                        });

                        jQuery('#receive_purchase_order_modal').modal('toggle');
                    }
                    console.log(data);
                }
            });

        });

        function multplyGRN() {
            jQuery('.grn_quantity').on('keyup', function () {
                var parent_tr = jQuery(this).parents('tr');
                var sub_total_amount = removeComma(parent_tr.find('.grn_price').val()) * removeComma(jQuery(this).val());
                parent_tr.find('.grn_sub_total').val(addCommas(sub_total_amount));
                calculateTaxGRN();
            });

            jQuery('.grn_price').on('keyup', function () {
                var parent_tr = jQuery(this).parents('tr');
                var sub_total_amount = removeComma(parent_tr.find('.grn_quantity').val()) * removeComma(jQuery(this).val());
                parent_tr.find('.grn_sub_total').val(addCommas(sub_total_amount));
                calculateTaxGRN();
            });
        }

        function calculateTaxGRN() {
            var basic_value_amount = jQuery('#grn_basic_value_amount');
            var grn_vat_selection = jQuery('#grn_vat_selection').val();
            if (grn_vat_selection == 'INCLUSIVE') {
                var b_v_a = calculateSumGRN() / 1.18;
                var v_a = (calculateSumGRN() / 1.18) * 0.18;
                var g_g_t = calculateSumGRN();
                basic_value_amount.val(b_v_a.toLocaleString());
                jQuery('#grn_grand_total').val(g_g_t.toLocaleString());
                jQuery('#grn_tax_amount').val(v_a.toLocaleString());
            } else if (grn_vat_selection == 'EXCLUSIVE') {
                basic_value_amount.val(calculateSumGRN());
                jQuery('#grn_tax_amount').val(0.18 * basic_value_amount.val());
                jQuery('#grn_grand_total').val(parseFloat(basic_value_amount.val())
                    + parseFloat((basic_value_amount.val() * 0.18)));
            } else {
                basic_value_amount.val(calculateSumGRN());
                jQuery('#grn_tax_amount').val(0);
                jQuery('#grn_grand_total').val(calculateSumGRN());
            }
        }

        function addCommas(nStr) {
            nStr += '';
            x = nStr.split('.');
            x1 = x[0];
            x2 = x.length > 1 ? '.' + x[1] : '';
            var rgx = /(\d+)(\d{3})/;
            while (rgx.test(x1)) {
                x1 = x1.replace(rgx, '$1' + ',' + '$2');
            }
            return x1 + x2;
        }

        function calculateSumGRN() {
            var sum = 0;
            jQuery(".grn_sub_total").each(function () {
                var value = removeComma(jQuery(this).val());
                if (!isNaN(value) && value.length != 0) {
                    sum += parseFloat(value);
                }
            });
            return sum;
        }


    </script>
@stop