Subversion Repositories SmartDukaan

Rev

Rev 37704 | Rev 37711 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
32352 amit.gupta 1
$(function () {
2
    $(document).on('click', ".warehouse-create-purchase-order", function () {
3
        loadCreatePurchase("main-content");
4
    });
32145 tejbeer 5
 
32352 amit.gupta 6
    $(document).on('click', ".warehouse-receive-new-invoice", function () {
7
        loadNewReceiveInvoice("main-content");
8
    });
32145 tejbeer 9
 
32192 tejbeer 10
 
32352 amit.gupta 11
    $(document).on('click', ".warehouse-grn-request", function () {
12
        loadGrnRequest("main-content");
13
    });
32192 tejbeer 14
 
32300 tejbeer 15
 
32352 amit.gupta 16
    $(document).on('click', ".warehouse-debit-note", function () {
17
        loadDebitNote("main-content");
18
    });
32192 tejbeer 19
 
20
 
32352 amit.gupta 21
    $(document).on('click', ".warehouse-invoices", function () {
22
        loadWarehouseInvoices("main-content");
23
    });
32256 tejbeer 24
 
32300 tejbeer 25
 
32352 amit.gupta 26
    $(document).on('click', '.dateWiseInvoices', function () {
32300 tejbeer 27
 
32352 amit.gupta 28
        var startDate = getDatesFromPicker('input[name="invoice-duration"]').startDate;
29
        var endDate = getDatesFromPicker('input[name="invoice-duration"]').endDate
32300 tejbeer 30
 
32352 amit.gupta 31
        var vendorId = $('#vendorId').val();
32300 tejbeer 32
 
34047 tejus.loha 33
        // doGetAjaxRequestHandler(context + "/getWarehouseInvoicesByVendor?vendorId=" + vendorId + "&startDate=" + startDate + "&endDate=" + endDate, function (response) {
34
        // $('.invoicesviewcontainer').html(response);
35
        doGetAjaxRequestHandler(context + "/getWarehouseInvoicesBydateWise?dateWiseInvoices=" + "&startDate=" + startDate + "&endDate=" + endDate, function (response) {
36
            $('.invoicesviewcontainer').html(response);
37
        });
32300 tejbeer 38
 
33737 ranu 39
    });
32300 tejbeer 40
 
33737 ranu 41
    $(document).on('click', '.generateInvoicesExcel', function () {
32300 tejbeer 42
 
33737 ranu 43
        var startDate = getDatesFromPicker('input[name="invoice-duration"]').startDate;
44
        var endDate = getDatesFromPicker('input[name="invoice-duration"]').endDate;
45
        doAjaxGetDownload(context + "/generateDatewiseInvoiceExcel?startDate=" + startDate + "&endDate=" + endDate, "PurchaseInvoicesReport.xlsx");
32352 amit.gupta 46
    });
32300 tejbeer 47
 
48
 
32352 amit.gupta 49
    $(document)
50
        .on(
51
            'input',
52
            '#invoice',
53
            function () {
54
                if (confirm('Document has been selected, Do you want to upload ?')) {
55
                    var fileSelector = $('#invoice')[0];
56
                    if (fileSelector != undefined
57
                        && fileSelector.files[0] != undefined) {
58
                        var url = context + '/document-upload';
32300 tejbeer 59
 
32352 amit.gupta 60
                        console.log(url);
61
                        var file = this.files[0];
62
                        doAjaxUploadRequestHandler(
63
                            url,
64
                            'POST',
65
                            file,
66
                            function (response) {
67
                                console.log(response);
68
                                var documentId = response.response.document_id;
69
                                console.log("documentId : "
70
                                    + documentId);
71
                                localStorage.setItem("invoiceDocument",
72
                                    documentId);
32192 tejbeer 73
 
32295 tejbeer 74
 
32352 amit.gupta 75
                            });
32300 tejbeer 76
 
32352 amit.gupta 77
                    }
78
                } else {
79
                    // Do nothing!
80
                }
81
            });
32192 tejbeer 82
 
32352 amit.gupta 83
    $(document).on('click', ".createReceiveInvoice", function () {
32192 tejbeer 84
 
32352 amit.gupta 85
        var invoiceDate = $('#actualDate').val();
32192 tejbeer 86
 
32352 amit.gupta 87
        var warehouseId = $('#warehouseMap').val();
32192 tejbeer 88
 
32352 amit.gupta 89
        var numItems = $('#numberofItems').val();
32192 tejbeer 90
 
32352 amit.gupta 91
        var supplierId = $('#vendorId').val();
32192 tejbeer 92
 
32352 amit.gupta 93
        var totalValue = $('#totalValue').val();
32192 tejbeer 94
 
32352 amit.gupta 95
        var invoiceNumber = $('#invoiceNumber').val();
32642 raveendra. 96
        //var invoiceDoc  =  $('#invoiceDoc').val();
32192 tejbeer 97
 
34047 tejus.loha 98
        var invoice = $('#invoice').val();
32642 raveendra. 99
        var invoiceDoc = localStorage
100
            .getItem("invoiceDocument");
34047 tejus.loha 101
        console.log(invoiceDoc)
32192 tejbeer 102
 
32629 amit.gupta 103
        if (invoiceDate === "" && warehouseId === "" && numItems === "" && supplierId === "" && totalValue === "" && invoiceNumber === "" && invoiceDoc === "") {
32352 amit.gupta 104
            alert("Field can't be empty");
105
            return false;
106
        }
32192 tejbeer 107
 
32629 amit.gupta 108
        if (invoiceDate === "") {
32638 raveendra. 109
            alert("Please select date");
32629 amit.gupta 110
            return false;
111
        }
34047 tejus.loha 112
        if (supplierId === "") {
113
            alert("Please choose supplier/Vendor");
114
            return false;
115
        }
32638 raveendra. 116
 
117
        if (invoiceNumber === "") {
118
            alert("Please fill Invoice Number.");
119
            return false;
120
        }
32629 amit.gupta 121
        if (warehouseId === "") {
32638 raveendra. 122
            alert("Please choose warehouse");
32629 amit.gupta 123
            return false;
124
        }
125
 
126
        if (numItems === "") {
32638 raveendra. 127
            alert("Please fill number of items.");
32629 amit.gupta 128
            return false;
129
        }
130
        if (totalValue === "") {
32638 raveendra. 131
            alert("Please fill Total Value.");
32629 amit.gupta 132
            return false;
133
        }
32638 raveendra. 134
        console.log('invoice doc', invoiceDoc);
34047 tejus.loha 135
        if (invoiceDoc === "") {
32638 raveendra. 136
            alert("Please upload invoice.");
32629 amit.gupta 137
            return false;
138
        }
32352 amit.gupta 139
        var newReceiveInvoice = {};
32192 tejbeer 140
 
32352 amit.gupta 141
        newReceiveInvoice['invoiceDate'] = invoiceDate;
32629 amit.gupta 142
        newReceiveInvoice['warehouseId'] = warehouseId;
143
        newReceiveInvoice['numItems'] = numItems;
144
        newReceiveInvoice['supplierId'] = supplierId;
145
        newReceiveInvoice['totalValue'] = totalValue;
146
        newReceiveInvoice['invoiceNumber'] = invoiceNumber;
147
        newReceiveInvoice['invoiceDoc'] = invoiceDoc;
32192 tejbeer 148
 
32629 amit.gupta 149
        if (confirm("Are you sure you want to add new Invoice")) {
32192 tejbeer 150
 
32390 amit.gupta 151
            doPostAjaxRequestWithJsonHandler(`${context}/newReceiveInvoice`, JSON
32352 amit.gupta 152
                .stringify(newReceiveInvoice), function (response) {
153
                if (response == 'true') {
32638 raveendra. 154
                    alert("Successfully added");
32352 amit.gupta 155
                    localStorage.removeItem("invoiceDocument");
156
                    loadNewReceiveInvoice("main-content");
157
                }
158
            });
159
        }
32295 tejbeer 160
 
32192 tejbeer 161
 
32352 amit.gupta 162
    });
32192 tejbeer 163
 
164
 
32352 amit.gupta 165
    var purchaseItemIds;
166
    $(document).on('click', ".purchaseorderitemview", function () {
167
        purchaseItemIds = [];
168
        var vendorId = $('#vendorId').val();
169
        var warehouseId = $('#warehouseMap').val();
32390 amit.gupta 170
        var poDate = $('#poDate').val();
32192 tejbeer 171
 
32352 amit.gupta 172
        console.log(warehouseId);
32192 tejbeer 173
 
32352 amit.gupta 174
        if (warehouseId === null && vendorId === "") {
175
            alert("Field can't be empty");
176
            return;
177
        }
32192 tejbeer 178
 
32390 amit.gupta 179
        if (poDate === '') {
180
            alert("PO Date is required");
181
            return;
182
        }
183
 
184
        if (warehouseId === null && vendorId === "") {
185
            alert("Field can't be empty");
186
            return;
187
        }
188
 
32352 amit.gupta 189
        if (warehouseId === null) {
190
            alert("please select warehouse");
191
            return;
192
        }
193
        if (vendorId === "") {
194
            alert("please select vendor");
195
            return;
196
        }
197
        doGetAjaxRequestHandler(context + "/addPurchaseItemView?warehouseId=" + warehouseId + "&vendorId=" + vendorId, function (response) {
198
            $(".createpurchaseordercontainer").html(response);
199
        });
200
    });
32192 tejbeer 201
 
32145 tejbeer 202
 
36532 amit 203
    $(document).on('change', '#poItemsFile', function () {
204
        var file = this.files[0];
205
        if (!file) return;
206
 
207
        var vendorId = $('#vendorId').val();
208
        var poDate = $('#poDate').val();
209
 
210
        var formData = new FormData();
211
        formData.append("file", file);
212
 
213
        $.ajax({
214
            url: context + '/uploadPurchaseOrderItems?vendorId=' + vendorId + '&poDate=' + poDate,
215
            type: 'POST',
216
            data: formData,
217
            dataType: 'json',
218
            cache: false,
219
            contentType: false,
220
            processData: false,
221
            success: function (items) {
222
                // Clear existing rows
223
                $('#purchase-order-table tbody').empty();
224
                purchaseItemIds = [];
225
 
226
                for (var i = 0; i < items.length; i++) {
227
                    var item = items[i];
228
                    var $row = $('<tr>' +
229
                        '<td><input type="text" class="form-control typeaheaditem" autocomplete="off" value="' + item.modelName + '" readonly/></td>' +
230
                        '<td><input type="number" class="form-control qty" name="qty" value="' + item.amendedQty + '"/></td>' +
231
                        '<td><input type="number" class="form-control transferPrice" readonly tabindex="-1" value="' + item.transferPrice + '" data-itemid="' + item.itemId + '"/></td>' +
232
                        '<td><input type="number" class="form-control totalValue" tabindex="-1" readonly value="' + item.totalValue + '"/></td>' +
233
                        '<td><input class="form-control btn btn-primary removeInPurchaseOrder" tabindex="-1" type="button" value="Remove"></td>' +
234
                        '</tr>');
235
                    $('#purchase-order-table tbody').append($row);
236
                    purchaseItemIds.push(item.itemId);
237
                }
238
                updateTotalValue();
239
                alert("Uploaded " + items.length + " items successfully");
240
            },
241
            error: function (xhr) {
242
                var msg = "Upload failed";
243
                try {
244
                    var err = JSON.parse(xhr.responseText);
245
                    if (err.message) msg = err.message;
246
                    if (err.code) msg = err.code;
247
                } catch (e) {}
248
                alert(msg);
249
            }
250
        });
251
 
252
        // Reset file input so same file can be re-uploaded
253
        $(this).val('');
254
    });
255
 
32352 amit.gupta 256
    $(document).on('click', ".addRowInPurchaseOrder", function () {
257
        var totalQty = 0;
33727 ranu 258
        var totalValue = 0;
32145 tejbeer 259
 
32358 amit.gupta 260
        $("table > tbody > tr").each(function () {
32352 amit.gupta 261
            var itemId = $(this).find(".transferPrice").data('itemid');
262
            var qty = $(this).find(".qty").val();
33727 ranu 263
            var transferPrice = $(this).find(".transferPrice").val();
32145 tejbeer 264
 
33727 ranu 265
            if (qty !== undefined && qty !== "") {
266
                qty = parseInt(qty);
267
                totalQty += qty;
268
                if (transferPrice !== undefined && transferPrice !== "") {
269
                    transferPrice = parseFloat(transferPrice);
270
                    totalValue += qty * transferPrice;
271
                }
32352 amit.gupta 272
            }
32358 amit.gupta 273
        });
32145 tejbeer 274
 
32603 raveendra. 275
        var $html = $(`<tr>
33727 ranu 276
        <td><input type="text" class="form-control typeaheaditem" autocomplete="off" placeholder="Search Model"/></td>
37697 amit 277
        <td><div class="mv-qty-cell"><input type="number" class="form-control qty" name="qty" placeholder="Quantity"/><span class="mv-avail-icon" style="display:none;" tabindex="0">i</span></div><div class="mv-qty-warn" style="display:none;"></div></td>
33727 ranu 278
        <td><input type="number" class="form-control transferPrice" readonly tabindex="-1" placeholder="Transfer Price"/></td>
279
        <td><input type="number" class="form-control totalValue" tabindex="-1" readonly placeholder="Total Value"/></td>
280
        <td><input class="form-control btn btn-primary removeInPurchaseOrder" tabindex="-1" type="button" value="Remove"></td>
281
    </tr>`);
32192 tejbeer 282
 
32352 amit.gupta 283
        var vendorId = $('#vendorId').val();
32192 tejbeer 284
 
32352 amit.gupta 285
        $('tbody').append($html);
33727 ranu 286
        getVendorItemAheadOptions($html.find('.typeaheaditem'), vendorId, function (selectedItem) {
32488 amit.gupta 287
            let poDate = $('#poDate').val();
32352 amit.gupta 288
            var itemId = selectedItem.itemId;
34047 tejus.loha 289
            var description = selectedItem.itemDescription;
290
            if (itemId) {
32488 amit.gupta 291
                doGetAjaxRequestHandler(`${context}/getPricing?vendorId=${vendorId}&itemId=${itemId}&onDate=${poDate}`, function (response) {
32360 amit.gupta 292
                    if (response !== "null") {
34047 tejus.loha 293
                        if (response !== 'false') {
294
                            var jsonObj = JSON.parse(response);
295
                            $html.find('.transferPrice').val(jsonObj.transferPrice);
37697 amit 296
                            renderMovementAvailability($html, jsonObj);
34047 tejus.loha 297
                            $html.find('input.qty').focus();
33727 ranu 298
 
34047 tejus.loha 299
                            // Update the total value for this row
300
                            let qty = $html.find('.qty').val();
301
                            let transferPrice = jsonObj.transferPrice;
302
                            if (qty && transferPrice) {
303
                                let total = qty * transferPrice;
304
                                $html.find('.totalValue').val(total);
305
                                updateTotalValue();
306
                            }
307
                            addItem($html, itemId);
308
                        } else {
309
                            $html.find('.typeaheaditem').val('');
310
                            alert(`Category not Define(eg- HID, SLOW MOVING, FAST MOVING),First define the category of ${description} and Try again`);
33727 ranu 311
                        }
34047 tejus.loha 312
 
32360 amit.gupta 313
                    } else {
34047 tejus.loha 314
                        $html.find('.typeaheaditem').val('');
37072 amit 315
                        alert(`No approved price for ${description} on ${poDate}. Get the vendor pricing approved first, then try again.`);
32360 amit.gupta 316
                    }
317
                });
318
            } else {
32352 amit.gupta 319
                return false;
320
            }
321
        });
33727 ranu 322
    });
32145 tejbeer 323
 
33727 ranu 324
    $(document).on('input', '.qty', function () {
325
        var $row = $(this).closest('tr');
326
        var qty = parseInt($(this).val());
37697 amit 327
        checkMovableQty($row, qty);
33727 ranu 328
        var transferPrice = parseFloat($row.find('.transferPrice').val());
329
        if (!isNaN(qty) && !isNaN(transferPrice)) {
330
            let total = qty * transferPrice;
331
            $row.find('.totalValue').val(total);
332
        }
333
        updateTotalValue();
32352 amit.gupta 334
    });
32145 tejbeer 335
 
33727 ranu 336
    function updateTotalValue() {
337
        var grandTotal = 0;
36520 amit 338
        var totalQty = 0;
33727 ranu 339
        $('tbody > tr').each(function () {
340
            var rowTotal = parseFloat($(this).find('.totalValue').val());
36520 amit 341
            var rowQty = parseInt($(this).find('.qty').val());
33727 ranu 342
            if (!isNaN(rowTotal)) {
343
                grandTotal += rowTotal;
344
            }
36520 amit 345
            if (!isNaN(rowQty)) {
346
                totalQty += rowQty;
347
            }
33727 ranu 348
        });
36520 amit 349
        $('#totalQuantity').text(totalQty);
33727 ranu 350
        $('#grandTotal').text(grandTotal.toFixed(2));
351
    }
352
 
32355 amit.gupta 353
    function addItem(container, itemId) {
32361 amit.gupta 354
        oldItemId = container.find('.transferPrice').data('itemid');
32360 amit.gupta 355
        if (typeof (oldItemId) === "undefined") {
356
            let itemIndex = purchaseItemIds.indexOf(itemId);
357
            if (itemIndex >= 0) {
358
                alert("Item already added");
32376 amit.gupta 359
                container.find('.typeaheaditem').val("");
32360 amit.gupta 360
                return false;
361
            } else {
362
                purchaseItemIds.push(itemId);
32361 amit.gupta 363
                container.find('.transferPrice').data('itemid', itemId);
32360 amit.gupta 364
                $('.addRowInPurchaseOrder').click();
365
            }
32352 amit.gupta 366
        } else {
32360 amit.gupta 367
            if (oldItemId !== itemId) {
368
                let oldIndex = purchaseItemIds.indexOf(oldItemId);
369
                if (oldIndex > -1) {
370
                    purchaseItemIds.splice(oldIndex, 1);
371
                }
372
                purchaseItemIds.push(itemId);
32361 amit.gupta 373
                container.find('.transferPrice').data('itemid', itemId);
32358 amit.gupta 374
            } else {
32360 amit.gupta 375
                return false;
32352 amit.gupta 376
            }
377
        }
32360 amit.gupta 378
        return true;
32352 amit.gupta 379
    }
32145 tejbeer 380
 
33727 ranu 381
 
32352 amit.gupta 382
    $(document).on('click', '.createSendPurchaseOrder', function () {
32145 tejbeer 383
 
32390 amit.gupta 384
        createPO(true);
32145 tejbeer 385
 
32352 amit.gupta 386
    });
32145 tejbeer 387
 
388
 
32352 amit.gupta 389
    $(document).on('click', '.createPurchaseOrder', function () {
32145 tejbeer 390
 
391
 
32390 amit.gupta 392
        createPO(false);
32352 amit.gupta 393
    });
32145 tejbeer 394
 
395
 
32352 amit.gupta 396
    $(document).on('change', '.qty', function () {
32145 tejbeer 397
 
398
 
32352 amit.gupta 399
        var row = $(this).closest("tr");
400
        var qty = $(row).find(".qty").val();
401
        var transferPrice = $(row).find(".transferPrice").val();
32145 tejbeer 402
 
32352 amit.gupta 403
        var totalVal = transferPrice * qty;
32145 tejbeer 404
 
32352 amit.gupta 405
        var totalValue = $(row).find(".totalValue").val(totalVal);
32145 tejbeer 406
 
32352 amit.gupta 407
        var purchaseOrderValue = 0;
32145 tejbeer 408
 
32352 amit.gupta 409
        $("table > tbody > tr").each(function () {
32145 tejbeer 410
 
32352 amit.gupta 411
            var totalValue = $(this).find(".totalValue").val();
32358 amit.gupta 412
            purchaseOrderValue += totalValue;
32145 tejbeer 413
 
32352 amit.gupta 414
        });
32145 tejbeer 415
 
32352 amit.gupta 416
    });
32145 tejbeer 417
 
418
 
32352 amit.gupta 419
    $(document).on('click', '.warehouse-open-purchase-order', function () {
420
        loadOpenPurchase("main-content");
421
    });
32145 tejbeer 422
 
423
 
32352 amit.gupta 424
    $(document).on('click', '.editViewPurchaseOrder', function () {
425
        var purchaseOrderId = $(this).data('poid');
426
        doGetAjaxRequestHandler(context + "/getEditPOByPurchaseId?purchaseId=" + purchaseOrderId, function (response) {
427
            $('#warehouseEditPurchaseContainer .modal-content').html(response);
428
        });
32145 tejbeer 429
 
32352 amit.gupta 430
    });
32145 tejbeer 431
 
32352 amit.gupta 432
    $(document).on('click', '.editPurchaseOrder', function () {
433
        var purchaseOrderId = $(this).data('poid');
32145 tejbeer 434
 
32352 amit.gupta 435
        editPurchase(false, purchaseOrderId);
32145 tejbeer 436
 
32352 amit.gupta 437
    });
32145 tejbeer 438
 
439
 
32352 amit.gupta 440
    $(document).on('click', '.editSendPurchaseOrder', function () {
441
        var purchaseOrderId = $(this).data('poid');
32145 tejbeer 442
 
443
 
32352 amit.gupta 444
        editPurchase(true, purchaseOrderId);
445
    });
32145 tejbeer 446
 
37704 amit 447
    // A movement closed before its stock arrived can be reopened, which restarts its auto-close window.
448
    $(document).on('click', '.reopenPurchaseOrder', function () {
449
        var $button = $(this);
450
        var poId = $button.data('poid');
451
        if (!confirm('Reopen this purchase order so the delayed stock can still be received?')) {
452
            return;
453
        }
454
        doPostAjaxRequestHandler(context + '/reopenPurchaseOrder?purchaseId=' + poId, function (response) {
455
            if (response == 'true') {
456
                alert('Purchase order reopened. It can receive stock again.');
457
                $button.closest('tr').find('td').eq(7).text('READY');
458
                $button.remove();
459
            }
460
        });
461
    });
462
 
32352 amit.gupta 463
    $(document).on('click', '.closePurchaseOrder', function () {
464
        var purchaseOrderId = $(this).data('poid');
465
        if (confirm("Are you sure you want to close the PO") == true) {
466
            doPostAjaxRequestHandler(context + "/closePuchaseOrder?purchaseId=" + purchaseOrderId,
467
                function (response) {
32145 tejbeer 468
 
32352 amit.gupta 469
                    console.log(response);
470
                    if (response == 'true') {
471
                        alert("successfully closed");
472
                        loadOpenPurchase("main-content")
473
                    }
474
                });
475
        }
476
    });
32145 tejbeer 477
 
478
 
32352 amit.gupta 479
    $(document).on('click', '.warehouse-view-purchase-order', function () {
480
        doGetAjaxRequestHandler(context + "/viewPurchaseOrder", function (response) {
481
            $('#' + 'main-content').html(response);
482
        });
483
    });
32145 tejbeer 484
 
485
 
32352 amit.gupta 486
    $(document).on('click', '.dateWisePo', function () {
32145 tejbeer 487
 
32352 amit.gupta 488
        var startDate = getDatesFromPicker('input[name="duration"]').startDate;
33729 ranu 489
        var endDate = getDatesFromPicker('input[name="duration"]').endDate;
32145 tejbeer 490
 
491
 
32352 amit.gupta 492
        doGetAjaxRequestHandler(context + "/getPurchaseOrders?startDate=" + startDate + "&endDate=" + endDate, function (response) {
493
            $('.purchaseorderviewcontainer').html(response);
32145 tejbeer 494
 
32352 amit.gupta 495
        });
32145 tejbeer 496
 
497
 
32352 amit.gupta 498
    });
32145 tejbeer 499
 
500
 
32352 amit.gupta 501
    $(document).on('click', '.viewPurchaseOrderlineItem', function () {
502
        var purchaseOrderId = $(this).data('poid');
32145 tejbeer 503
 
32352 amit.gupta 504
        doGetAjaxRequestHandler(context + "/getWarehouseLineItemByPurchaseId?purchaseId=" + purchaseOrderId, function (response) {
505
            $('#warehouseLineItem .modal-content').html(response);
32145 tejbeer 506
 
32352 amit.gupta 507
        });
508
    });
32145 tejbeer 509
 
510
 
32352 amit.gupta 511
    $(document).on("click", '.removeInPurchaseOrder', function () {
512
        var row = $(this).closest("tr");
32361 amit.gupta 513
        let itemId = row.find('.transferPrice').data('itemid');
32360 amit.gupta 514
        let itemIndex = purchaseItemIds.indexOf(itemId);
32352 amit.gupta 515
        if (itemIndex > -1) { // only splice array when item is found
516
            purchaseItemIds.splice(itemIndex, 1); // 2nd parameter means remove one item only
517
        }
518
        row.remove();
519
    });
32192 tejbeer 520
 
521
 
32352 amit.gupta 522
    $(document).on('click', ".addRowForInvoiceItem", function () {
32145 tejbeer 523
 
32352 amit.gupta 524
        var numitems = $(this).data("numitems");
525
        var invoiceId = $(this).data("invoiceid");
526
        var invoiceItemIds = [];
32360 amit.gupta 527
        var totalQty = 0;
32145 tejbeer 528
 
32352 amit.gupta 529
        $("#invoice-order-table > tbody > tr").each(function () {
530
            var itemId = $(this).find(".rate").data('itemid');
531
            var qty = $(this).find(".qty").val();
32145 tejbeer 532
 
32360 amit.gupta 533
            if (qty !== undefined) {
534
                totalQty += qty;
32352 amit.gupta 535
            }
32145 tejbeer 536
 
32360 amit.gupta 537
            if (itemId !== undefined) {
538
                invoiceItemIds.push(itemId);
32352 amit.gupta 539
            }
540
        });
32145 tejbeer 541
 
32352 amit.gupta 542
        var $html = $('<tr>  <td>  <input type="text" class="form-control typeaheaditem"   autocomplete="off"  placeholder="Search Model"/> </td>' +
543
            '<td>  <input type="number" class="form-control qty"  name = "qty" placeholder="Quantity"/> </td>' +
32364 amit.gupta 544
            '<td>  <input type="number" class="form-control rate" placeholder="Rate"/> </td>' +
32352 amit.gupta 545
            '<td> <input class="form-control btn btn-primary removeInInvoiceItem" type="button" value="Remove"></td>  </tr> ');
32145 tejbeer 546
 
547
 
32352 amit.gupta 548
        getItemAheadOptions($html.find('.typeaheaditem'), true, function (
549
            selectedItem) {
550
            var itemId = selectedItem.itemId;
551
            if (invoiceItemIds.indexOf(itemId) > -1) {
552
                alert("Item already added");
553
                $html.find('.typeaheaditem').val("")
32145 tejbeer 554
 
32352 amit.gupta 555
                return false;
556
            }
557
            $html.find('.rate').data('itemid', itemId)
32145 tejbeer 558
 
32352 amit.gupta 559
            $html.find('.removeInInvoiceItem').data('invoiceid', invoiceId)
560
            $html.find('.removeInInvoiceItem').data('itemid', itemId)
32145 tejbeer 561
 
37564 amit 562
        }, true);
32145 tejbeer 563
 
32192 tejbeer 564
 
32352 amit.gupta 565
        if (totalQty < numitems) {
32192 tejbeer 566
 
32352 amit.gupta 567
            $('#invoice-order-table tbody').append($html);
568
        }
32192 tejbeer 569
 
32352 amit.gupta 570
    });
32256 tejbeer 571
 
32192 tejbeer 572
 
32352 amit.gupta 573
    $(document).on('click', '.saveInvoiceDetail', function () {
32192 tejbeer 574
 
32352 amit.gupta 575
        var numItems = $(this).data("numitems");
576
        var invoiceId = $(this).data("invoiceid");
577
        var warehouseId = $(this).data("warehouseid");
578
        var supplierId = $(this).data("supplierid");
579
        getInvoiceItemData(numItems, invoiceId, warehouseId, supplierId, false);
32192 tejbeer 580
 
32352 amit.gupta 581
    });
32192 tejbeer 582
 
583
 
32352 amit.gupta 584
    $(document).on('click', '.validateInvoiceDetail', function () {
585
        var numItems = $(this).data("numitems");
586
        var invoiceId = $(this).data("invoiceid");
587
        var warehouseId = $(this).data("warehouseid");
588
        var supplierId = $(this).data("supplierid");
32192 tejbeer 589
 
32352 amit.gupta 590
        getInvoiceItemData(numItems, invoiceId, warehouseId, supplierId, true);
32192 tejbeer 591
 
32352 amit.gupta 592
    });
32192 tejbeer 593
 
594
 
32352 amit.gupta 595
    $(document).on("click", '.removeInInvoiceItem', function () {
32192 tejbeer 596
 
32352 amit.gupta 597
        var row = $(this).closest("tr");
598
        var invoiceId = $(this).data("invoiceid");
599
        var itemId = $(this).data("itemid");
600
        if (invoiceId != undefined && itemId != undefined) {
601
            doDeleteAjaxRequestHandler(context + "/removeInvoiceItem?invoiceId="
602
                + invoiceId + "&itemId=" + itemId, function (response) {
603
                if (response == "true") {
604
                    alert("Item removed successfully");
32192 tejbeer 605
 
32352 amit.gupta 606
                }
607
            });
608
        }
32192 tejbeer 609
 
32352 amit.gupta 610
        row.remove();
32192 tejbeer 611
 
32352 amit.gupta 612
    });
32192 tejbeer 613
 
614
 
32352 amit.gupta 615
    $(document).on('click', '.purchaseGrn', function () {
32192 tejbeer 616
 
32352 amit.gupta 617
        var grnItemArray = [];
32192 tejbeer 618
 
32352 amit.gupta 619
        var invoiceId = $(this).data("invoiceid");
32192 tejbeer 620
 
32352 amit.gupta 621
        $("#invoice-purchase-validate > tbody > tr").each(function () {
622
            var grnItemJson = {};
32192 tejbeer 623
 
32352 amit.gupta 624
            var itemId = $(this).find(".itemId").text();
625
            var qty = $(this).find(".qty").text();
626
            var poId = $(this).find(".purchaseId").text();
627
            var excessQty = $(this).find(".excessQty").text();
628
            var itemType = $(this).find(".itemType").text();
32192 tejbeer 629
 
32352 amit.gupta 630
            console.log(itemType);
32192 tejbeer 631
 
32352 amit.gupta 632
            if (itemType == "Serialized") {
633
                var serialNumbers = $(this).find(".imeis-to-grn").tagsinput('items');
32366 amit.gupta 634
                grnItemJson['serialNumbers'] = serialNumbers;
32192 tejbeer 635
 
32352 amit.gupta 636
                if (excessQty > 0) {
637
                    var returnSerialNumbers = $(this).find(".imeis-to-grn-return").tagsinput('items');
638
                    grnItemJson['returnSerialNumbers'] = returnSerialNumbers
639
                }
640
            }
32366 amit.gupta 641
            console.log(serialNumbers);
32352 amit.gupta 642
            grnItemJson['itemId'] = itemId;
643
            grnItemJson['serialNumbers'] = serialNumbers
644
            grnItemJson['qty'] = qty
645
            grnItemJson['poId'] = poId
646
            grnItemJson['invoiceId'] = invoiceId
647
            grnItemJson['itemType'] = itemType
648
            grnItemJson['excessQty'] = excessQty
32192 tejbeer 649
 
32352 amit.gupta 650
            grnItemJson['returnSerialNumbers'] = returnSerialNumbers
32192 tejbeer 651
 
32352 amit.gupta 652
            grnItemArray.push(grnItemJson)
32192 tejbeer 653
 
32352 amit.gupta 654
            console.log(grnItemArray)
32192 tejbeer 655
 
32352 amit.gupta 656
        });
32192 tejbeer 657
 
32352 amit.gupta 658
        for (var i = 0; i < grnItemArray.length; i++) {
32366 amit.gupta 659
            var itemType = grnItemArray[i].itemType;
32192 tejbeer 660
 
32352 amit.gupta 661
            if (itemType == "Serialized") {
662
                var excessQty = grnItemArray[i].excessQty
32192 tejbeer 663
 
664
 
32352 amit.gupta 665
                var serialNumbers = grnItemArray[i].serialNumbers.length
666
                var qty = grnItemArray[i].qty
32192 tejbeer 667
 
32352 amit.gupta 668
                if (serialNumbers != qty) {
669
                    alert("serial number is not matched with qty")
670
                    return false;
671
                }
32192 tejbeer 672
 
32352 amit.gupta 673
                if (excessQty > 0) {
32192 tejbeer 674
 
32352 amit.gupta 675
                    var returnSerialNumbers = grnItemArray[i].returnSerialNumbers.length
32192 tejbeer 676
 
32352 amit.gupta 677
                    if (returnSerialNumbers != excessQty) {
678
                        alert("Return serial number is not matched with excess qty")
679
                        return false;
680
                    }
32192 tejbeer 681
 
32352 amit.gupta 682
                }
683
            }
32192 tejbeer 684
 
32352 amit.gupta 685
        }
32192 tejbeer 686
 
687
 
32352 amit.gupta 688
        console.log(JSON.stringify(grnItemArray))
689
        if (confirm("Are you sure you want to grn purchase order") == true) {
32192 tejbeer 690
 
32352 amit.gupta 691
            doPostAjaxRequestWithJsonHandler(context
692
                + "/createGrn", JSON
693
                .stringify(grnItemArray), function (response) {
694
                if (response == 'true') {
695
                    alert("successfully done");
696
                    loadNewReceiveInvoice("main-content");
697
                }
698
            });
699
        }
32192 tejbeer 700
 
701
 
32352 amit.gupta 702
    });
32256 tejbeer 703
 
704
 
32352 amit.gupta 705
    $(document).on('click', '.grnRequest', function () {
32192 tejbeer 706
 
32352 amit.gupta 707
        var grnRequestJson = {};
708
        var grnRequestItemArray = [];
32192 tejbeer 709
 
32352 amit.gupta 710
        var invoiceId = $(this).data("invoiceid");
32192 tejbeer 711
 
712
 
32352 amit.gupta 713
        $("#invoice-purchase-validate > tbody > tr").each(function () {
714
            var grnItemJson = {};
32192 tejbeer 715
 
32352 amit.gupta 716
            var itemId = $.trim($(this).find(".itemId").text());
717
            var poId = $.trim($(this).find(".purchaseId").text());
32192 tejbeer 718
 
32352 amit.gupta 719
            var qty = parseInt($(this).find(".qty").text());
32256 tejbeer 720
 
32352 amit.gupta 721
            var excessQty = parseInt($(this).find(".excessQty").text());
32256 tejbeer 722
 
32352 amit.gupta 723
            var priceMismatch = $.trim($(this).find(".priceMismatch").text());
724
            console.log(priceMismatch)
32256 tejbeer 725
 
726
 
32354 amit.gupta 727
            if (priceMismatch !== "" || excessQty > 0) {
32352 amit.gupta 728
                console.log(typeof priceMismatch)
729
                console.log(excessQty)
730
                grnItemJson['itemId'] = itemId;
731
                grnItemJson['qty'] = qty;
732
                grnItemJson['excessQty'] = excessQty
32376 amit.gupta 733
                if (priceMismatch === '') {
734
                    grnItemJson['mismatch'] = 'QtyMismatch';
735
                } else {
736
                    grnItemJson['mismatch'] = priceMismatch
737
                }
32352 amit.gupta 738
                grnItemJson['poId'] = poId
32192 tejbeer 739
 
32352 amit.gupta 740
                grnRequestItemArray.push(grnItemJson)
741
            }
742
        });
32256 tejbeer 743
 
32352 amit.gupta 744
        console.log(grnRequestItemArray)
32256 tejbeer 745
 
746
 
32352 amit.gupta 747
        grnRequestJson['invoiceId'] = invoiceId;
748
        grnRequestJson['warehousePurchaseModel'] = grnRequestItemArray
32256 tejbeer 749
 
32366 amit.gupta 750
        if (confirm("Are you sure you want to raise grn request")) {
32192 tejbeer 751
 
32352 amit.gupta 752
            doPostAjaxRequestWithJsonHandler(context
753
                + "/grnRequest", JSON
754
                .stringify(grnRequestJson), function (response) {
755
                if (response == 'true') {
756
                    alert("successfully done");
757
                    loadNewReceiveInvoice("main-content");
758
                }
759
            });
760
        }
32192 tejbeer 761
 
762
 
32352 amit.gupta 763
    });
32192 tejbeer 764
 
32256 tejbeer 765
 
32352 amit.gupta 766
    $(document).on('click', '.resolvedPriceMismatchRequest', function () {
767
        var id = $(this).data("id");
32256 tejbeer 768
 
32352 amit.gupta 769
        var invoiceId = $(this).data("invoiceid");
32256 tejbeer 770
 
32352 amit.gupta 771
        var requestId = $(this).data("requestid");
32256 tejbeer 772
 
32352 amit.gupta 773
        var mismatch = $(this).data("mismatch");
32256 tejbeer 774
 
32352 amit.gupta 775
        if (mismatch == "InvoiceMismatch") {
32485 amit.gupta 776
            if (confirm("Are you sure you want to resolve invoice mismatch")) {
32352 amit.gupta 777
                doGetAjaxRequestHandler(context + "/resolvedMismatchRequest?id=" + id, function (response) {
778
                    if (response == 'true') {
779
                        getGrnRequestItems(requestId, invoiceId)
780
                    }
781
                });
32256 tejbeer 782
 
32352 amit.gupta 783
            }
784
        } else if (mismatch == "PoMismatch") {
37707 amit 785
            // Say what the replacement PO is for and what to do if it closes before the stock lands, rather than
786
            // leaving someone to discover that a GRN has quietly stopped matching.
787
            if (confirm("Resolve this price mismatch?\n\nThe current PO line is discarded and a replacement "
788
                    + "purchase order is raised on the invoice date at the corrected price. This invoice is then "
789
                    + "received against that PO.\n\nIt closes automatically after 4 days for a warehouse movement, "
790
                    + "6 for a vendor order. A movement that closes before its stock arrives can be reopened from "
791
                    + "Purchase Orders; a vendor order cannot, and needs a fresh PO.") == true) {
32256 tejbeer 792
 
32352 amit.gupta 793
                doGetAjaxRequestHandler(context + "/resolvedMismatchRequest?id=" + id, function (response) {
794
                    if (response == 'true') {
795
                        getGrnRequestItems(requestId, invoiceId)
796
                    }
797
                });
32256 tejbeer 798
 
32352 amit.gupta 799
            }
800
        }
32256 tejbeer 801
 
32352 amit.gupta 802
    });
32256 tejbeer 803
 
804
 
32352 amit.gupta 805
    $(document).on('click', '.resolvedQtyMismatchRequest', function () {
806
        var id = $(this).data("id");
807
        var invoiceId = $(this).data("invoiceid");
808
        var requestId = $(this).data("requestid");
32256 tejbeer 809
 
810
 
32352 amit.gupta 811
        var mismatch = $(this).data("mismatch");
32256 tejbeer 812
 
32352 amit.gupta 813
        var $row = $(this).closest("tr");
814
        var requiredQty = $row.find(".requiredQty").val();
32256 tejbeer 815
 
32352 amit.gupta 816
        console.log(requiredQty);
32256 tejbeer 817
 
32352 amit.gupta 818
        if (mismatch == "QtyMismatch") {
819
            if (confirm("Are you sure you want to resolve qty mismatch") == true) {
32256 tejbeer 820
 
32352 amit.gupta 821
                doGetAjaxRequestHandler(context + "/resolvedMismatchRequest?id=" + id + "&requiredQty=" + requiredQty, function (response) {
822
                    if (response == 'true') {
823
                        getGrnRequestItems(requestId, invoiceId)
824
                    }
825
                });
32256 tejbeer 826
 
32352 amit.gupta 827
            }
828
        }
32256 tejbeer 829
 
32352 amit.gupta 830
    });
32256 tejbeer 831
 
32192 tejbeer 832
 
32145 tejbeer 833
});
834
 
835
function loadCreatePurchase(domId) {
32352 amit.gupta 836
    doGetAjaxRequestHandler(context + "/warehousePurchaseOrder", function (response) {
837
        $('#' + domId).html(response);
838
    });
32145 tejbeer 839
}
840
 
32192 tejbeer 841
 
32145 tejbeer 842
function loadOpenPurchase(domId) {
843
 
32352 amit.gupta 844
    doGetAjaxRequestHandler(context + "/getOpenPurchaseOrder", function (response) {
845
        $('#' + domId).html(response);
846
    });
32145 tejbeer 847
}
848
 
32192 tejbeer 849
function loadNewReceiveInvoice(domId) {
32352 amit.gupta 850
    doGetAjaxRequestHandler(context + "/newReceiveInvoice", function (response) {
851
        $('#' + domId).html(response);
852
    });
32192 tejbeer 853
}
854
 
32256 tejbeer 855
 
856
function loadGrnRequest(domId) {
32352 amit.gupta 857
    doGetAjaxRequestHandler(context + "/grnRequest", function (response) {
858
        $('#' + domId).html(response);
859
    });
32256 tejbeer 860
}
861
 
862
function loadDebitNote(domId) {
32352 amit.gupta 863
    doGetAjaxRequestHandler(context + "/getDebitNote", function (response) {
864
        $('#' + domId).html(response);
865
    });
32256 tejbeer 866
}
867
 
33729 ranu 868
$(document).on('click', '.dateWiseDebitNote', function () {
869
 
870
    var startDate = getDatesFromPicker('input[name="date-duration"]').startDate;
871
    var endDate = getDatesFromPicker('input[name="date-duration"]').endDate;
872
 
873
 
874
    doGetAjaxRequestHandler(context + "/getDateWiseDebitNote?startDate=" + startDate + "&endDate=" + endDate, function (response) {
875
        $('#warehouse-datewise-debitnote-container').html(response);
876
 
877
    });
878
});
879
 
880
$(document).on('click', '.generateVendorDebitNoteExcel', function () {
881
    var startDate = getDatesFromPicker('input[name="date-duration"]').startDate;
882
    var endDate = getDatesFromPicker('input[name="date-duration"]').endDate;
33809 ranu 883
    doAjaxGetDownload(context + "/generateVendorDebitNoteExcel?startDate=" + startDate + "&endDate=" + endDate, "VendorDebitNoteReport.csv");
33729 ranu 884
});
885
 
32300 tejbeer 886
function loadWarehouseInvoices(domId) {
32352 amit.gupta 887
    doGetAjaxRequestHandler(context + "/getWarehouseInvoices", function (response) {
888
        $('#' + domId).html(response);
889
    });
32300 tejbeer 890
}
891
 
32390 amit.gupta 892
function createPO(sendPo) {
32352 amit.gupta 893
    var purchaseOrder = {};
32145 tejbeer 894
 
32352 amit.gupta 895
    var vendorId = $('#vendorId').val();
32145 tejbeer 896
 
32352 amit.gupta 897
    var warehouseId = $('#warehouseMap').val();
32145 tejbeer 898
 
32390 amit.gupta 899
    var poDate = $('#poDate').val();
32145 tejbeer 900
 
32390 amit.gupta 901
 
32352 amit.gupta 902
    var items = []
903
    $("table > tbody > tr").each(function () {
904
        var purchaseOrderJson = {};
32145 tejbeer 905
 
32352 amit.gupta 906
        var itemId = $(this).find(".transferPrice").data('itemid');
907
        var qty = $(this).find(".qty").val();
908
        var transferPrice = $(this).find(".transferPrice").val();
909
        var totalValue = $(this).find(".totalValue").val();
32145 tejbeer 910
 
911
 
32352 amit.gupta 912
        purchaseOrderJson['itemId'] = itemId;
913
        purchaseOrderJson['amendedQty'] = qty
914
        purchaseOrderJson['totalValue'] = totalValue
915
        purchaseOrderJson['transferPrice'] = transferPrice
32145 tejbeer 916
 
32352 amit.gupta 917
        items.push(purchaseOrderJson)
918
    });
32145 tejbeer 919
 
920
 
32352 amit.gupta 921
    for (var i = 0; i < items.length; i++) {
922
        console.log(items[i])
32145 tejbeer 923
 
32352 amit.gupta 924
        var itemId = items[i].itemId
925
        var qty = items[i].amendedQty
926
        var transferPrice = items[i].transferPrice
927
        var totalValue = items[i].totalValue
32145 tejbeer 928
 
32352 amit.gupta 929
        if (itemId === "" && qty === "" && transferPrice === "" && totalValue === "") {
930
            alert("Field can't be empty");
931
            return false;
932
        }
32145 tejbeer 933
 
934
 
32352 amit.gupta 935
        if (itemId === "") {
936
            alert("please select item");
937
            return false;
938
        }
939
        if (qty === "") {
940
            alert("please choose qty");
941
            return false;
942
        }
32145 tejbeer 943
 
32352 amit.gupta 944
        if (transferPrice === "") {
945
            alert("Transfer Price can't be empty");
946
            return false;
947
        }
948
        if (totalValue === "") {
949
            alert("Total value can't be empty");
950
            return false;
951
        }
32145 tejbeer 952
 
32352 amit.gupta 953
        if (qty <= 0) {
954
            alert("Please fill Qty");
955
            return false;
956
        }
32145 tejbeer 957
 
958
 
32352 amit.gupta 959
    }
32261 tejbeer 960
 
32352 amit.gupta 961
    purchaseOrder['vendorId'] = vendorId;
962
    purchaseOrder['warehouseId'] = warehouseId
963
    purchaseOrder['sendPo'] = sendPo
32390 amit.gupta 964
    purchaseOrder['poDate'] = poDate;
32352 amit.gupta 965
    purchaseOrder['items'] = items
32145 tejbeer 966
 
32352 amit.gupta 967
    console.log(purchaseOrder)
32145 tejbeer 968
 
969
 
32352 amit.gupta 970
    if (confirm("Are you sure you want to create purchase order") == true) {
32145 tejbeer 971
 
32352 amit.gupta 972
        doPostAjaxRequestWithJsonHandler(context
973
            + "/createPurchaseOrder", JSON
974
            .stringify(purchaseOrder), function (response) {
975
            if (response == 'true') {
976
                alert("successfully created");
977
                loadCreatePurchase("main-content");
978
            }
979
        });
980
    }
32145 tejbeer 981
 
982
}
983
 
984
 
985
function editPurchase(sendPo, poid) {
32352 amit.gupta 986
    var editpurchaseOrder = {}
987
    var items = []
988
    $("#purchase-edit-lineitem > tbody > tr").each(function () {
989
        var purchaseOrderJson = {};
990
        var itemId = $(this).find("td:eq(0)").text();
32145 tejbeer 991
 
32352 amit.gupta 992
        var qty = $(this).find("td:eq(2)").text();
32145 tejbeer 993
 
32352 amit.gupta 994
        var amendedQty = $(this).find(".editqty").val();
32256 tejbeer 995
 
32352 amit.gupta 996
        var transferPrice = $.trim($(this).find(".transferPrice").html());
32256 tejbeer 997
 
998
 
32352 amit.gupta 999
        purchaseOrderJson['itemId'] = itemId;
1000
        purchaseOrderJson['amendedQty'] = parseInt(amendedQty)
1001
        purchaseOrderJson['qty'] = parseInt(qty)
1002
        purchaseOrderJson['transferPrice'] = transferPrice
32145 tejbeer 1003
 
32352 amit.gupta 1004
        items.push(purchaseOrderJson)
1005
    });
32145 tejbeer 1006
 
1007
 
32352 amit.gupta 1008
    for (var i = 0; i < items.length; i++) {
1009
        console.log(items[i])
32145 tejbeer 1010
 
32352 amit.gupta 1011
        var amendedQty = items[i].amendedQty
1012
        var qty = items[i].qty
32145 tejbeer 1013
 
32256 tejbeer 1014
 
32352 amit.gupta 1015
        if (amendedQty === "") {
1016
            alert("please choose qty");
1017
            return false;
1018
        }
32145 tejbeer 1019
 
32352 amit.gupta 1020
        if (amendedQty < qty) {
1021
            alert("Quantity should be greater than existing qty");
1022
            return false;
1023
        }
32145 tejbeer 1024
 
1025
 
32352 amit.gupta 1026
    }
32145 tejbeer 1027
 
32352 amit.gupta 1028
    editpurchaseOrder['purchaseOrderId'] = poid;
1029
    editpurchaseOrder['sendPo'] = sendPo
1030
    editpurchaseOrder['items'] = items
32145 tejbeer 1031
 
1032
 
32352 amit.gupta 1033
    if (confirm("Are you sure you want to edit purchase order") == true) {
32145 tejbeer 1034
 
32352 amit.gupta 1035
        doPostAjaxRequestWithJsonHandler(context
1036
            + "/editPurchaseOrder", JSON
1037
            .stringify(editpurchaseOrder), function (response) {
1038
            if (response == 'true') {
1039
                alert("successfully created");
1040
                $('#warehouseEditPurchaseContainer').modal('hide');
1041
                $('.modal-backdrop').remove();
32295 tejbeer 1042
 
32352 amit.gupta 1043
                loadOpenPurchase("main-content")
1044
            }
1045
        });
1046
    }
32145 tejbeer 1047
 
1048
}
1049
 
1050
 
32192 tejbeer 1051
function getInvoiceItemData(numItems, invoiceId, warehouseId, supplierId, validate) {
1052
 
32352 amit.gupta 1053
    var invoiceJson = {};
1054
    console.log(numItems)
1055
    var totalQty = 0;
1056
    var invoiceItems = []
1057
    $("#invoice-order-table > tbody > tr").each(function () {
1058
        var invoiceItemJson = {};
1059
        var itemId = $(this).find(".rate").data('itemid');
1060
        var qty = $(this).find(".qty").val();
32192 tejbeer 1061
 
32352 amit.gupta 1062
        if (qty != undefined) {
1063
            totalQty += parseInt(qty)
1064
        }
1065
        var rate = $(this).find(".rate").val();
1066
        invoiceItemJson['itemId'] = itemId;
1067
        invoiceItemJson['qty'] = qty
1068
        invoiceItemJson['rate'] = rate
1069
        invoiceItems.push(invoiceItemJson)
1070
    });
32192 tejbeer 1071
 
1072
 
32352 amit.gupta 1073
    for (var i = 0; i < invoiceItems.length; i++) {
32192 tejbeer 1074
 
32352 amit.gupta 1075
        var itemId = invoiceItems[i].itemId
1076
        var qty = invoiceItems[i].qty
1077
        var rate = invoiceItems[i].rate
1078
        if (itemId === "" && qty === "" && rate === "") {
1079
            alert("Field can't be empty");
1080
            return false;
1081
        }
32192 tejbeer 1082
 
32352 amit.gupta 1083
        if (itemId === "") {
1084
            alert("please select item");
1085
            return false;
1086
        }
1087
        if (qty === "") {
1088
            alert("please choose qty");
1089
            return false;
1090
        }
32192 tejbeer 1091
 
32352 amit.gupta 1092
        if (rate === "") {
1093
            alert("Rate can't be empty");
1094
            return false;
1095
        }
32192 tejbeer 1096
 
32352 amit.gupta 1097
    }
32192 tejbeer 1098
 
32352 amit.gupta 1099
    console.log(totalQty)
32192 tejbeer 1100
 
32352 amit.gupta 1101
    if (totalQty > numItems) {
1102
        alert("Qty Should not be more than  Invoice items");
1103
        return false;
1104
    }
32192 tejbeer 1105
 
32352 amit.gupta 1106
    if (validate) {
32192 tejbeer 1107
 
32352 amit.gupta 1108
        if (totalQty != numItems) {
1109
            alert("Qty Should not match with Invoice items");
1110
            return false;
1111
        }
1112
    }
32192 tejbeer 1113
 
1114
 
32352 amit.gupta 1115
    invoiceJson['invoiceId'] = invoiceId;
1116
    invoiceJson['warehouseId'] = warehouseId;
1117
    invoiceJson['supplierId'] = supplierId;
1118
    invoiceJson['invoiceItems'] = invoiceItems
1119
    if (validate) {
1120
        validateInvoiceItems(invoiceJson);
1121
    } else {
1122
        saveInvoiceItems(invoiceJson)
1123
    }
32192 tejbeer 1124
}
1125
 
1126
 
1127
function saveInvoiceItems(invoiceJson) {
1128
 
1129
 
32352 amit.gupta 1130
    if (confirm("Are you sure you want to save invoice item") == true) {
32192 tejbeer 1131
 
32352 amit.gupta 1132
        doPostAjaxRequestWithJsonHandler(context
1133
            + "/invoiceItemDetail", JSON
1134
            .stringify(invoiceJson), function (response) {
1135
            if (response == 'true') {
1136
                getInvoiceItems(invoiceJson.invoiceId);
1137
            }
1138
        });
1139
    }
32192 tejbeer 1140
 
1141
}
1142
 
1143
 
1144
function validateInvoiceItems(invoiceJson) {
1145
 
1146
 
32352 amit.gupta 1147
    if (confirm("Are you sure you want to validate invoice item") == true) {
32192 tejbeer 1148
 
32352 amit.gupta 1149
        doPostAjaxRequestWithJsonHandler(context
1150
            + "/validateInvoiceItemDetail", JSON
1151
            .stringify(invoiceJson), function (response) {
1152
            $('.invoiceadditemcontainer').html(response);
32192 tejbeer 1153
 
32352 amit.gupta 1154
        });
1155
    }
32192 tejbeer 1156
 
1157
}
1158
 
1159
function getOpenPOFromWarehouse() {
1160
 
32352 amit.gupta 1161
    var warehouseId = $('#warehouseMap').val();
1162
    doGetAjaxRequestHandler(context + "/getOpenPurchaseOrderByWarehouseId?warehouseId=" + warehouseId, function (response) {
1163
        $('#warehouseManagePuchaseContainer').html(response);
1164
    });
32192 tejbeer 1165
 
1166
 
1167
}
1168
 
1169
function getPurchaseLineitem(poId) {
1170
 
1171
 
32352 amit.gupta 1172
    doGetAjaxRequestHandler(context + "/getPurchaseOrderItemByPoId?poId=" + poId, function (response) {
1173
        $('#warehouseManagePuchaseItemContainer').html(response);
1174
        $('#warehousepurchaseitemgrn').hide()
1175
    });
32192 tejbeer 1176
 
1177
 
1178
}
1179
 
1180
 
1181
function getInvoiceItems(invoiceId) {
1182
 
32352 amit.gupta 1183
    doGetAjaxRequestHandler(context + "/getInvoiceItems?invoiceId=" + invoiceId, function (response) {
1184
        $('.invoiceadditemcontainer').html(response);
32192 tejbeer 1185
 
32352 amit.gupta 1186
    });
32192 tejbeer 1187
}
1188
 
1189
 
32256 tejbeer 1190
function getGrnRequestItems(requestId, invoiceId) {
32352 amit.gupta 1191
    doGetAjaxRequestHandler(context + "/grnRequestItem?requestId=" + requestId + "&invoiceId=" + invoiceId, function (response) {
1192
        $('.grnRequestItemContainer').html(response);
32256 tejbeer 1193
 
32352 amit.gupta 1194
    });
32256 tejbeer 1195
}
1196
 
32912 amit.gupta 1197
function removeInvoice(invoiceId) {
34047 tejus.loha 1198
    if (confirm(`Are your sure want to delete invoiceId ${invoiceId}`)) {
32912 amit.gupta 1199
        doGetAjaxRequestHandler(`${context}/removeInvoice?invoiceId=${invoiceId}`, function (response) {
34047 tejus.loha 1200
            $('#open-invoices').DataTable().row("#" + invoiceId).remove().draw();
32912 amit.gupta 1201
            alert("Invoice Removed");
1202
        });
1203
    }
1204
}
32256 tejbeer 1205
 
32912 amit.gupta 1206
function removeGrnRequest(invoiceId) {
34047 tejus.loha 1207
    if (confirm(`Are your sure want to remove grn request for invoiceId ${invoiceId}`)) {
32912 amit.gupta 1208
        doGetAjaxRequestHandler(`${context}/removeGrnRequest?invoiceId=${invoiceId}`, function (response) {
1209
            $('#' + domId).html(response);
1210
            alert("Grn Request Removed");
1211
        });
1212
    }
1213
}
1214
 
1215
 
35806 amit 1216
// ============ GRN Correction ============
1217
 
1218
$(document).on('click', '.warehouse-grn-correction', function () {
1219
    loadGrnCorrection("main-content");
1220
});
1221
 
1222
$(document).on('click', '.warehouse-grn-correction-approval', function () {
1223
    loadGrnCorrectionApproval("main-content");
1224
});
1225
 
1226
$(document).on('click', '.searchCorrectionInvoices', function () {
1227
    var startDate = getDatesFromPicker('input[name="correction-duration"]').startDate;
1228
    var endDate = getDatesFromPicker('input[name="correction-duration"]').endDate;
1229
    doGetAjaxRequestHandler(context + "/grnCorrection?startDate=" + startDate + "&endDate=" + endDate, function (response) {
1230
        $('#main-content').html(response);
1231
    });
1232
});
1233
 
1234
$(document).on('click', '.submitGrnCorrection', function () {
1235
    var invoiceId = $(this).data('invoiceid');
1236
    var remarks = $('#correctionRemarks').val();
1237
 
1238
    if (!remarks || remarks.trim() === '') {
1239
        alert("Please enter remarks explaining the reason for correction");
1240
        return false;
1241
    }
1242
 
1243
    // Collect serial number corrections (old → new)
1244
    var corrections = [];
1245
    $('#serial-corrections-table > tbody > tr').each(function () {
1246
        var oldSerial = $(this).find('.old-serial').val();
1247
        var newSerial = $(this).find('.new-serial').val();
1248
 
1249
        if (oldSerial && newSerial && oldSerial.trim() !== '' && newSerial.trim() !== '') {
1250
            corrections.push({
1251
                oldSerialNumber: oldSerial.trim(),
1252
                newSerialNumber: newSerial.trim()
1253
            });
1254
        }
1255
    });
1256
 
35884 amit 1257
    // Collect item corrections (serialized or non-serialized)
35806 amit 1258
    var qtyCorrections = [];
36206 amit 1259
    var imeiCountError = false;
35806 amit 1260
    $('#qty-corrections-table > tbody > tr').each(function () {
1261
        var oldItemId = $(this).find('.qty-old-itemid').val();
1262
        var newItemId = $(this).find('.qty-new-itemid').val();
35884 amit 1263
        var serial = $(this).find('.qty-serial').val();
35806 amit 1264
        var qty = parseInt($(this).find('.qty-correction-val').val());
1265
 
35884 amit 1266
        if (oldItemId && newItemId && serial && serial.trim() !== '') {
36206 amit 1267
            // Split IMEIs by space, comma, or newline
1268
            var imeis = serial.trim().split(/[\s,]+/).filter(function(s) { return s.length > 0; });
1269
            var imeiCount = imeis.length;
1270
 
1271
            // Auto-set qty from IMEI count, validate if qty was manually entered
1272
            if (qty > 0 && qty !== imeiCount) {
1273
                alert("Row error: Qty (" + qty + ") does not match IMEI count (" + imeiCount + ").\nIMEIs: " + imeis.join(", "));
1274
                imeiCountError = true;
1275
                return false;
1276
            }
1277
 
1278
            // Create one entry per IMEI (each with qty=1)
1279
            for (var i = 0; i < imeis.length; i++) {
1280
                qtyCorrections.push({
1281
                    oldItemId: parseInt(oldItemId),
1282
                    newItemId: parseInt(newItemId),
1283
                    qty: 1,
1284
                    serialNumber: imeis[i].trim()
1285
                });
1286
            }
35884 amit 1287
        } else if (oldItemId && newItemId && qty > 0) {
1288
            qtyCorrections.push({
1289
                oldItemId: parseInt(oldItemId),
1290
                newItemId: parseInt(newItemId),
35806 amit 1291
                qty: qty
1292
            });
1293
        }
1294
    });
1295
 
36206 amit 1296
    if (imeiCountError) return false;
1297
 
35806 amit 1298
    if (corrections.length === 0 && qtyCorrections.length === 0) {
1299
        alert("No corrections specified. Please enter serial number or quantity corrections.");
1300
        return false;
1301
    }
1302
 
1303
    var requestModel = {
1304
        invoiceId: invoiceId,
1305
        remarks: remarks,
1306
        corrections: corrections,
1307
        qtyCorrections: qtyCorrections
1308
    };
1309
 
1310
    if (confirm("Are you sure you want to raise this GRN correction request?")) {
1311
        doPostAjaxRequestWithJsonHandler(context + "/raiseGrnCorrection",
1312
            JSON.stringify(requestModel), function (response) {
36299 amit 1313
                var parsed;
1314
                try { parsed = typeof response === 'string' ? JSON.parse(response) : response; }
1315
                catch (e) { parsed = null; }
1316
                if (parsed && parsed.status === true) {
1317
                    if (parsed.autoApproved) {
1318
                        alert("Correction applied successfully (auto-approved: no model/qty change)");
1319
                    } else {
1320
                        alert("Correction request raised for approval");
1321
                    }
35806 amit 1322
                    loadGrnCorrection("main-content");
1323
                }
1324
            });
1325
    }
1326
});
1327
 
1328
$(document).on('click', '.approveGrnCorrectionBtn', function () {
1329
    var requestId = $(this).data('requestid');
1330
    var remarks = $('#approvalRemarks').val();
1331
 
1332
    if (confirm("Are you sure you want to APPROVE this correction request? This will apply the IMEI/qty changes.")) {
1333
        doPostAjaxRequestHandler(context + "/approveGrnCorrection?requestId=" + requestId + "&remarks=" + encodeURIComponent(remarks),
1334
            function (response) {
1335
                if (response == 'true') {
1336
                    alert("Correction approved and applied successfully");
1337
                    loadGrnCorrectionApproval("main-content");
1338
                }
1339
            });
1340
    }
1341
});
1342
 
1343
$(document).on('click', '.rejectGrnCorrectionBtn', function () {
1344
    var requestId = $(this).data('requestid');
1345
    var remarks = $('#approvalRemarks').val();
1346
 
1347
    if (!remarks || remarks.trim() === '') {
1348
        alert("Please enter remarks explaining the reason for rejection");
1349
        return false;
1350
    }
1351
 
1352
    if (confirm("Are you sure you want to REJECT this correction request?")) {
1353
        doPostAjaxRequestHandler(context + "/rejectGrnCorrection?requestId=" + requestId + "&remarks=" + encodeURIComponent(remarks),
1354
            function (response) {
1355
                if (response == 'true') {
1356
                    alert("Correction request rejected");
1357
                    loadGrnCorrectionApproval("main-content");
1358
                }
1359
            });
1360
    }
1361
});
1362
 
1363
function loadGrnCorrection(domId) {
1364
    doGetAjaxRequestHandler(context + "/grnCorrection", function (response) {
1365
        $('#' + domId).html(response);
1366
    });
1367
}
1368
 
1369
function loadGrnCorrectionApproval(domId) {
1370
    doGetAjaxRequestHandler(context + "/grnCorrectionApproval", function (response) {
1371
        $('#' + domId).html(response);
1372
    });
1373
}
1374
 
1375
function loadGrnCorrectionDetail(invoiceId) {
1376
    doGetAjaxRequestHandler(context + "/grnCorrectionDetail?invoiceId=" + invoiceId, function (response) {
1377
        $('.grnCorrectionDetailContainer').html(response);
1378
    });
1379
}
1380
 
1381
function loadGrnCorrectionRequestDetail(requestId) {
1382
    doGetAjaxRequestHandler(context + "/grnCorrectionRequestDetail?requestId=" + requestId, function (response) {
1383
        $('.grnCorrectionRequestDetailContainer').html(response);
1384
    });
1385
}
1386
 
1387
 
37697 amit 1388
 
1389
/**
1390
 * Shows what the sending warehouse can actually release of an item, on the row where a quantity is being typed.
1391
 *
1392
 * Only our own warehouses answer with this; an outside vendor's pricing response carries no availability, and its row
1393
 * is left exactly as it was. Stock that is entirely promised is shown as zero with the orders holding it named, which
1394
 * is what lets someone chase those orders instead of only seeing a smaller number.
1395
 */
1396
function renderMovementAvailability($row, pricing) {
1397
    var $icon = $row.find('.mv-avail-icon');
1398
    if (!pricing || typeof pricing.movableOnThisPo === 'undefined') {
1399
        $icon.hide();
1400
        $row.removeData('movableOnThisPo');
1401
        return;
1402
    }
1403
 
1404
    var cap = pricing.movableOnThisPo;
1405
    $row.data('movableOnThisPo', cap);
1406
 
37699 amit 1407
    var rows = mvAvailLine('In stock', pricing.inStock, '');
37697 amit 1408
    if (pricing.promisedTotal > 0) {
37699 amit 1409
        rows += mvAvailLine('Promised on open orders', pricing.promisedTotal, '');
37697 amit 1410
        $.each(pricing.promised || [], function (i, po) {
37699 amit 1411
            rows += mvAvailLine(mvEscape(po.poNumber) + ' &middot; ' + mvEscape(po.poDate)
1412
                + (po.destination ? ' &rarr; ' + mvEscape(po.destination) : ''), po.qty, ' mv-po');
37697 amit 1413
        });
1414
    }
1415
    if (pricing.inbound > 0) {
37701 amit 1416
        rows += mvAvailLine('Of these, still to arrive', pricing.inbound, ' mv-po');
37697 amit 1417
    }
37699 amit 1418
    rows += mvAvailLine('Can move on this PO', cap, ' mv-total');
37697 amit 1419
 
1420
    var note = '';
1421
    if (pricing.costSplit) {
1422
        note += '<div class="mv-note">' + (pricing.movableAltogether - cap)
1423
            + ' more came in at a different cost &mdash; raise a separate PO for those.</div>';
1424
    }
1425
    if (cap === 0) {
37699 amit 1426
        note += '<div class="mv-note">' + (pricing.promisedTotal > 0
1427
            ? 'Nothing can move until one of the orders above is completed or closed.'
1428
            : 'Nothing can move from here yet.') + '</div>';
37697 amit 1429
    }
1430
 
37699 amit 1431
    $icon.attr('data-mv-content', '<div class="mv-avail">' + rows + '</div>' + note);
37697 amit 1432
    $icon.removeClass('mv-none mv-part');
1433
    if (cap === 0) {
1434
        $icon.addClass('mv-none');
1435
    } else if (pricing.promisedTotal > 0) {
1436
        $icon.addClass('mv-part');
1437
    }
1438
    $icon.show();
1439
 
1440
    $icon.popover('destroy');
1441
    $icon.popover({
1442
        html: true,
1443
        container: 'body',
1444
        placement: 'left',
1445
        trigger: 'hover focus',
1446
        title: 'Stock at ' + mvEscape(pricing.sourceName),
1447
        content: function () {
1448
            return $(this).attr('data-mv-content');
1449
        }
1450
    });
1451
 
1452
    checkMovableQty($row, parseInt($row.find('.qty').val()));
1453
}
1454
 
1455
/** Flags a quantity that the order cannot take, while it is being typed rather than on submit. */
1456
function checkMovableQty($row, qty) {
1457
    var cap = $row.data('movableOnThisPo');
1458
    var $qty = $row.find('.qty');
1459
    var $warn = $row.find('.mv-qty-warn');
1460
 
1461
    if (typeof cap === 'undefined' || isNaN(qty)) {
1462
        $qty.removeClass('mv-over');
1463
        $warn.hide().empty();
1464
        return;
1465
    }
1466
 
1467
    if (qty > cap) {
1468
        $qty.addClass('mv-over');
1469
        $warn.text(cap === 0 ? 'None can move right now' : 'Only ' + cap + ' can move on this PO').show();
1470
    } else {
1471
        $qty.removeClass('mv-over');
1472
        $warn.hide().empty();
1473
    }
1474
}
1475
 
37699 amit 1476
/**
1477
 * One line of the breakdown.
1478
 *
1479
 * Built from divs and spans on purpose: Bootstrap's popover sanitizer whitelists neither tables nor their rows, and
1480
 * strips a non-whitelisted element together with everything inside it - a table here renders as nothing at all.
1481
 */
1482
function mvAvailLine(label, value, extraClass) {
1483
    return '<div class="mv-row' + extraClass + '"><span class="mv-label">' + label
1484
        + '</span><span class="mv-val">' + value + '</span></div>';
37697 amit 1485
}
1486
 
1487
/** Values here are warehouse and order names out of the database, so they are escaped before going into the popover. */
1488
function mvEscape(value) {
1489
    return $('<div/>').text(value === null || typeof value === 'undefined' ? '' : value).html();
1490
}