Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
31860 tejbeer 1
<!doctype html>
2
<html lang="en">
3
 
4
<head>
5
    <!-- Required meta tags -->
6
    <meta charset="utf-8">
7
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
35064 aman 8
    <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.9.4/Chart.js"></script>
31860 tejbeer 9
 
10
 
11
    <!-- Bootstrap CSS -->
12
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.1.3/dist/css/bootstrap.min.css"
35064 aman 13
          integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
34590 ranu 14
 
15
 
35064 aman 16
    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"
17
            integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo"
18
            crossorigin="anonymous"></script>
19
 
20
    <script src="https://cdn.jsdelivr.net/npm/popper.js@1.14.3/dist/umd/popper.min.js"
21
            integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49"
22
            crossorigin="anonymous"></script>
23
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@4.1.3/dist/js/bootstrap.min.js"
24
            integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy"
25
            crossorigin="anonymous"></script>
26
 
27
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
28
    <script type="text/javascript" src="resources/js/common.js?v=${version}"></script>
29
 
30
    <script type="text/javascript" src="resources/js/retailer.js?v=${version}"></script>
31
 
32
    <script type="text/javascript">
33
        function numberToComma(x) {
34
 
35
            x = x.toString();
36
            x = x.split('.');
37
            var x1 = x[0];
38
            var x2 = x.length > 1 && x[1] != '0' ? '.' + x[1] : '';
39
            var lastThree = x1.substring(x1.length - 3);
40
            var otherNumbers = x1.substring(0, x1.length - 3);
41
            if (x1.charAt(x1.length - 4) == ',' || x1.charAt(x1.length - 4) == '-') {
42
                console.log(lastThree)
43
            } else {
44
                if (otherNumbers != '')
45
                    lastThree = ',' + lastThree;
46
            }
47
            return otherNumbers.replace(/\B(?=(\d{2})+(?!\d))/g, ",") + (lastThree)
48
                    + x2;
49
 
50
        }
51
 
52
        $(document).ready(function () {
53
            $('.currency').each(function (index, ele) {
54
                if (!isNaN(parseInt($(ele).html()))) {
55
                    $(ele).html(numberToComma($(ele).html()));
56
                }
57
            });
58
 
59
            $(document).on('click', '.new-dashboard', function () {
60
                console.log('click11111')
61
                var fofoId = $(this).data('fofoid');
62
 
63
                window.open("/analysisDashboard?fofoId=" + fofoId, '_blank');
64
            });
65
        })
66
    </script>
67
 
31860 tejbeer 68
    <style>
35064 aman 69
        .ms-10 {
70
            margin-left: 100px !important;
71
        }
31860 tejbeer 72
        .yellow {
73
            background-color: #fdfd96;
74
        }
75
 
76
        .orange {
77
            background-color: #FAC898;
78
        }
79
 
80
        .green {
81
            background-color: #77dd77;
82
        }
83
 
84
        .red {
85
            background-color: #FAA0A0;
86
        }
87
 
88
        .details {
89
            color: #A3A3A5;
90
            font-weight: 400;
91
        }
35064 aman 92
 
93
 
31860 tejbeer 94
        .normal {
95
            color: #0000ff;
96
            font-weight: 400;
97
        }
98
 
99
        .subtitle {
100
            color: #B46060;
101
            font-weight: 400;
102
        }
103
 
104
        .light-red {
105
            background-color: #FBE4D5;
106
        }
35064 aman 107
 
108
        .raised th {
109
            width: 30%
110
        }
111
 
31860 tejbeer 112
    </style>
113
 
114
</head>
115
 
116
<body>
117
 
118
 
35064 aman 119
<div class="container-fluid mt-2 mb-5">
120
    <div class="row mt-5">
121
        <div class="col bg-dark text-left px-3 py-2 border-bottom">
122
            <h5 class="text-light mb-0">Raised Flags
123
                <button class="new-dashboard btn btn-info btn-sm" data-fofoid="$fofoId">Dashboard Info</button>
124
                <a id="mobileAppId" href="${rc.contextPath}/mobileapp?emailId=$customRetailer.getEmail()"
125
                   class="btn btn-danger btn-sm" target="_blank">Franchise App
126
                </a>
34590 ranu 127
 
35064 aman 128
            </h5>
31860 tejbeer 129
        </div>
35064 aman 130
    </div>
131
    <div class="row mt-5">
132
        <div class="col">
133
            <div>
134
                <h6 class=" yellow p-1 m-0">Working status</h6>
135
                <table class="table  table-sm raised">
136
                    <tbody>
31956 tejbeer 137
                    <tr>
35064 aman 138
                        <th class="details">Partner Status</th>
139
                        #if($fofoStore.isActive())
140
                            <td>ACTIVE</td>
141
                        #else
142
                            <td class="text-danger">INACTIVE</td>
143
                        #end
144
                    </tr>
145
                    </tbody>
146
                </table>
147
            </div>
148
            <div>
149
                <h6 class=" yellow p-1 m-0">Partner Investment Level</h6>
150
                <table class="table  table-sm raised">
151
                    <tbody>
152
                    <tr>
153
                        <th class="details">Investment</th>
154
                        #if($investment.getShortPercentage() <= 0)
155
                            <td class="text-success"> OK:>100%</td>
156
                        #elseif($investment.getShortPercentage() > 20)
31860 tejbeer 157
 
35064 aman 158
                            <td class="text-danger">Low:<80%</td>
159
                        #else
160
                            <td class="normal">Below Normal:(80% -100%)</td>
161
                        #end
162
                    </tr>
163
                    </tbody>
164
                </table>
31860 tejbeer 165
            </div>
35064 aman 166
            <div>
167
                <h6 class=" yellow p-1 m-0">Regularity of Buisness</h6>
168
                <table class="table  table-sm raised">
169
                    <tbody>
170
                    <tr>
171
                        <th class="details">Last Secondary</th>
172
                        #if($lastPurchaseDays < 5)
173
 
174
                            <td class="text-success">$lastPurchaseDays days back</td>
175
 
176
                        #else
177
 
178
                            <td class="text-danger">$lastPurchaseDays days back</td>
179
 
180
                        #end
181
                    </tr>
182
                    <tr>
183
                        <th class="details">Last Tertiary</th>
184
                        #if($lastTertiaryDays)
185
                            #if($lastTertiaryDays < 5)
186
 
187
                                <td class="text-success">$lastTertiaryDays days back</td>
188
 
189
                            #else
190
 
191
                                <td class="text-danger">$lastTertiaryDays days back</td>
192
 
193
                            #end
194
                        #end
195
                    </tr>
196
                    <tr>
197
                        <th class="details">Unbilled Activated Stock</th>
198
                        #if($lastUnbilledActivated > 0)
199
                            <td class="text-danger">$investment.getUnbilledAmount()</td>
200
 
201
 
202
                        #else
203
 
204
                            <td class="text-success"> -</td>
205
 
206
                        #end
207
 
208
                    </tr>
209
                    </tbody>
210
                </table>
211
            </div>
212
 
213
            #if(!$loans.isEmpty())
31860 tejbeer 214
                <div>
35064 aman 215
                    <h6 class=" yellow p-1 m-0">Active Loans</h6>
31947 tejbeer 216
                    <table class="table  table-sm raised">
31860 tejbeer 217
                        <tbody>
35064 aman 218
                        <tr>
36885 amit 219
                            <th>#</th>
35064 aman 220
                            <th>Loan Id</th>
221
                            <th>Interest Rate(%)</th>
36885 amit 222
                            <th>Principal Amount</th>
223
                            <th>Pending Principal</th>
224
                            <th>Pending Interest</th>
225
                            <th>Total Pending</th>
35064 aman 226
                            <th>Opening Date</th>
227
                            <th>Due Date</th>
228
                        </tr>
229
 
230
                            #foreach($ls in $loans)
231
 
31860 tejbeer 232
                            <tr>
35064 aman 233
 
36885 amit 234
                                <td>$foreach.count</td>
35064 aman 235
                                <td>$ls.getId()</td>
236
                                <td>$ls.getInterestRate().setScale(2,$ru)</td>
237
                                <td>$ls.getIntialAmount().setScale(2,$ru)</td>
238
                                <td>$ls.getPendingAmount().setScale(2,$ru)</td>
36885 amit 239
                                <td>$ls.getInterestAccrued().subtract($ls.getInterestPaid()).setScale(2,$ru)</td>
240
                                <td>$ls.getPendingAmount().add($ls.getInterestAccrued()).subtract($ls.getInterestPaid()).setScale(2,$ru)</td>
35064 aman 241
                                <td>$ls.getCreatedOn().format($dateTimeFormatter)</td>
242
                                <td>$ls.getDueDate().format($dateTimeFormatter)</td>
31860 tejbeer 243
                            </tr>
35064 aman 244
                            #end
245
                        <tr>
246
                            <td colspan="2" style="text-align: right;">Total</td>
36885 amit 247
                            <td>-</td>
35064 aman 248
                            <td>$totalInitialAmount.setScale(2,$ru)</td>
249
                            <td>$totalPendingAmount.setScale(2,$ru)</td>
36885 amit 250
                            <td>$totalInterestAccured.subtract($totalInterestPaid).setScale(2,$ru)</td>
251
                            <td>$totalPendingAmount.add($totalInterestAccured).subtract($totalInterestPaid).setScale(2,$ru)</td>
35064 aman 252
                            <td>-</td>
253
                            <td>-</td>
254
                        </tr>
32149 amit.gupta 255
 
256
 
31860 tejbeer 257
                        </tbody>
258
                    </table>
259
                </div>
35064 aman 260
            #end
31860 tejbeer 261
 
35064 aman 262
            <div>
263
                <button class="btn btn-primary agingDataAfterNintyDays" data-fofoid="$fofoId" data-brand="$brand"
264
                        data-toggle="modal" data-target="#agingItemWiseBrandStock">AgingDataGt90Days
265
                </button>
31860 tejbeer 266
 
267
            </div>
35064 aman 268
            <div id="agingItemWiseBrandStock" class="modal" role="dialog">
269
                <div class="modal-dialog">
270
                    <div class="modal-content" style="width:140%">
31860 tejbeer 271
 
35064 aman 272
                    </div>
273
                </div>
31860 tejbeer 274
            </div>
275
        </div>
35064 aman 276
        <div class="col">
277
            <div>
278
                <h6 class=" yellow p-1 m-0">Logistics</h6>
279
                <table class="table  table-sm raised">
31860 tejbeer 280
                    <tbody>
35064 aman 281
                    <tr>
282
                        <th class="details">Order to Billing time</th>
283
                        #if($createdToBillingAverage)
284
                            #if($createdToBillingAverage < 1)
285
                                <td class="text-success"> Normal < 1 ($decimalFormatter.format($createdToBillingAverage)
286
                                    days)
287
                                </td>
31860 tejbeer 288
                            #else
35064 aman 289
                                <td class="text-danger"> High >= 1
290
                                    ($decimalFormatter.format($createdToBillingAverage) days)
291
                                </td>
31860 tejbeer 292
                            #end
35064 aman 293
                        #else
294
                            <td>-</td>
295
                        #end
296
 
297
                    </tr>
298
                    <tr>
299
                        <th class="details">Billing to Delivery time</th>
300
                        #if($billingToDeliverAverage)
301
 
302
                            #if($billingToDeliverAverage < 2)
303
                                <td class="text-success"> Normal < 2
304
                                    ($decimalFormatter.format($billingToDeliverAverage) days)
305
                                </td>
31860 tejbeer 306
                            #else
35064 aman 307
                                <td class="text-danger"> High >= 2
308
                                    ($decimalFormatter.format($billingToDeliverAverage) days)
309
                                </td>
31860 tejbeer 310
                            #end
35064 aman 311
                        #else
312
                            <td>-</td>
313
 
314
                        #end
315
                    </tr>
31860 tejbeer 316
                    </tbody>
317
                </table>
318
            </div>
35064 aman 319
            <div>
320
                <h6 class=" yellow p-1 m-0">Stocking</h6>
321
                <table class="table  table-sm raised">
31860 tejbeer 322
                    <tbody>
35064 aman 323
                    <tr>
324
                        <th class="details">Stock Level</th>
325
                        #if($oneFourthOfTertiary > $totalStock)
326
                            <td class="text-danger">Low</td>
327
                        #else
328
                            <td class="text-success"> High</td>
329
                        #end
31860 tejbeer 330
 
35064 aman 331
                    </tr>
332
                    <tr>
333
                        <th class="details">Sufficient Stock</th>
334
                        <td class="text-success">  #foreach($suffientModel in $suffientModels)
335
                            $suffientModel.getBrand(),
336
                        #end
337
 
338
                        </td>
339
                    </tr>
340
                    <tr>
341
                        <th class="details">Low Stock</th>
342
                        <td class="text-danger">
343
                            #foreach($lowModel in $lowModels)
344
                                $lowModel.getBrand(),
31860 tejbeer 345
                            #end
35064 aman 346
                        </td>
347
                    </tr>
31860 tejbeer 348
                    </tbody>
349
                </table>
350
            </div>
351
 
35064 aman 352
 
353
            <div>
354
                <h6 class=" yellow p-1 m-0">Brands</h6>
355
                <table class="table  table-sm raised">
31860 tejbeer 356
                    <tbody>
35064 aman 357
                    <tr>
358
                        <th class="details">Working Brands</th>
359
 
360
 
361
                        <td class="text-success">
362
                            #foreach($brandsDisplay in $brandsDisplays)
363
                                #set($brand = $brandsDisplay.getName())
364
                                #if(!$retailerBlockBrands.get($brand))
365
                                    $brand ,
366
                                #end
31860 tejbeer 367
                            #end
35064 aman 368
                        </td>
369
 
370
 
371
                    </tr>
372
                    <tr>
373
                        <th class="details">Blocked Brands</th>
374
                        <td class="text-danger">
375
                            #foreach($brandsDisplay in $brandsDisplays)
376
                                #set($brand = $brandsDisplay.getName())
377
                                #if($retailerBlockBrands.get($brand))
378
                                    $brand ,
379
                                #end
31860 tejbeer 380
                            #end
35064 aman 381
                        </td>
382
                    </tr>
383
 
31860 tejbeer 384
                </table>
385
            </div>
386
        </div>
387
 
35064 aman 388
    </div>
389
 
390
    <div class="row mt-2">
391
        <div class="col bg-dark text-left px-3 py-2 border-bottom">
392
            <h5 class="text-light mb-0">Partner Basic Details</h5>
31860 tejbeer 393
        </div>
35064 aman 394
    </div>
395
    <div class="row mt-2">
396
        <div class="col">
397
            <table class="table table-sm">
398
                <tbody>
399
                <tr>
400
                    <th class="details">Partner Code</th>
401
                    <td class="">$customRetailer.getCode()</td>
402
                </tr>
403
                <tr>
404
                    <th class="details">Partner Name</th>
405
                    <td>$customRetailer.getBusinessName()</td>
406
                </tr>
407
                <tr>
408
                    <th class="details">City</th>
409
                    <td>$customRetailer.getAddress().getCity()</td>
410
                </tr>
411
                <tr>
412
                    <th class="details">State</th>
413
                    <td>$customRetailer.getAddress().getState()</td>
414
                </tr>
415
                <tr>
416
                    <th class="details">Current Category</th>
417
                    <td>$partnerType.getValue()</td>
418
                </tr>
419
 
420
                </tbody>
421
            </table>
31860 tejbeer 422
        </div>
423
 
35064 aman 424
        <div class="col">
425
            <table class="table table-sm">
426
                <tbody>
427
 
428
                <tr>
429
                    <th class="details">Contact Person</th>
430
                    <td>#if($customRetailer.getFirstName())$customRetailer.getFirstName() #end #if($customRetailer.getLastName()) $customRetailer.getLastName() #end</td>
431
                </tr>
432
                <tr>
433
                    <th class="details">Partner DOB</th>
434
 
435
                    #if($partnerOnboardingPanel.getDob())
436
                        <td>$partnerOnboardingPanel.getDob().format($dateFormatter)</td>
437
                    #else
438
                        <td> -</td>
439
                    #end
440
                </tr>
441
                <tr>
442
                    <th class="details">Partner Anniv</th>
443
 
444
                    #if($partnerOnboardingPanel.getAnniversaryDate())
445
                        <td>$partnerOnboardingPanel.getAnniversaryDate().format($dateFormatter)</td>
446
                    #else
447
                        <td> -</td>
448
                    #end
449
                </tr>
450
                <tr>
451
                    <th class="details">Latitude</th>
452
                    <td>$fofoStore.getLatitude()</td>
453
                </tr>
454
                <tr>
455
                    <th class="details">Longitude</th>
456
                    <td>$fofoStore.getLongitude()</td>
457
                </tr>
458
 
459
                </tbody>
460
            </table>
461
        </div>
462
 
463
 
464
        <div class="col">
465
            <table class="table table-sm">
466
                <tbody>
467
 
468
 
469
                <tr>
470
                    <th class="details">Outlet Potential</th>
471
                    <td class="currency">$fofoStore.getCounterPotential()</td>
472
                </tr>
473
                </tbody>
474
            </table>
475
        </div>
476
    </div>
477
 
478
    <div class="row mt-2">
479
        <div class="col bg-dark text-left px-3 py-2 border-bottom">
480
            <h5 class="text-light mb-0">Logistics</h5>
481
        </div>
482
    </div>
483
    <div class="row mt-2">
484
        <div class="col">
485
            <table class="table table-sm">
486
                <tbody>
487
                <tr>
488
                    <th class="details">Last courier sent</th>
489
                    #if($lastCourierSent)
490
                        <td class="">$lastCourierSent.format($dateFormatter)</td>
491
                    #else
492
                        <td>-</td>
493
                    #end
494
                </tr>
495
                <tr>
496
                    <th class="details">Last courier partner</th>
497
                    #if($lastCourierPartner)
498
                        <td>$lastCourierPartner</td>
499
                    #else
500
                        <td>-</td>
501
                    #end
502
                </tr>
503
                </tbody>
504
            </table>
505
        </div>
506
 
507
        <div class="col">
508
            <table class="table table-sm">
509
                <tbody>
510
                <tr>
511
                    <th class="details">Order to billing</th>
512
                    #if($createdToBillingAverage)
513
                        <td>$decimalFormatter.format($createdToBillingAverage) days</td>
514
                    #else
515
                        <td>-</td>
516
                    #end
517
                </tr>
518
                <tr>
519
                    <th class="details">Billing to delivery</th>
520
                    #if($billingToDeliverAverage)
521
                        <td>$decimalFormatter.format($billingToDeliverAverage) days</td>
522
                    #else
523
                        <td> -</td>
524
                    #end
525
                </tr>
526
                </tbody>
527
            </table>
528
        </div>
529
    </div>
530
 
531
    <div class="row mt-2">
532
        <div class="col bg-dark text-left px-3 py-2 border-bottom">
533
            <h5 class="text-light mb-0">Investment Trend</h5>
534
        </div>
535
    </div>
536
    <div class="row mt-2">
537
        <div class="col">
538
            <h6 class=" yellow p-1 text-center">Investment</h6>
539
        </div>
540
    </div>
541
 
542
    <div class="row">
543
        <div class="col">
544
            <table class="table table-bordered table-sm">
545
                <tbody>
546
                <tr>
547
                    <th class="details">Wallet Value</th>
548
                    <td class="currency">$investment.getWalletAmount()</td>
549
                </tr>
550
 
551
                <tr>
552
                    <th class="details">Agreed Investment</th>
553
                    <td class="currency">$investment.getMinInvestment()</td>
554
                </tr>
555
                <tr>
556
                    <th class="details">Current investment</th>
557
                    <td class="light-red currency">$investment.getTotalInvestment() &nbsp; &nbsp;<span
558
                            class="font-weight-bold ">$nf.format($investment.getShortPercentage()) %</span></td>
559
                </tr>
560
                <tr>
561
                    <th class="details">Short / Excess</th>
562
                    <td class="light-red currency">$investment.getShortInvestment() &nbsp; &nbsp;
563
 
564
 
565
 
566
                        #if($investment.getShortPercentage() <= 0)
567
                            <span
568
                                    class="text-success font-weight-bold">OK</span>
569
 
570
 
571
                        #else
572
                            <span
573
                                    class="text-danger font-weight-bold">Short</span>
574
 
575
                        #end
576
 
577
                    </td>
578
                </tr>
579
                </tbody>
580
            </table>
581
        </div>
582
        <div class="col">
583
            <table class="table table-bordered table-sm">
584
                <thead>
585
                <tr class="orange">
586
                    <th scope="col">Month</th>
587
                    <th scope="col">Days</th>
588
                </tr>
589
                </thead>
590
                <tbody>
591
                    #foreach($label in $labels)
592
                    <tr>
593
                        <td class="details">$label</td>
594
                        #if($monthOkDaysInvestmentMap.get($label))
32044 tejbeer 595
                            #if($monthOkDaysInvestmentMap.get($label) > 15)
35064 aman 596
                                <td class="text-success">$monthOkDaysInvestmentMap.get($label)</td>
31860 tejbeer 597
                            #else
35064 aman 598
                                <td class="text-danger">$monthOkDaysInvestmentMap.get($label)</td>
31860 tejbeer 599
                            #end
35064 aman 600
                        #else
31860 tejbeer 601
                            <td>-</td>
602
                        #end
35064 aman 603
                    </tr>
604
                    #end
605
                </tbody>
606
            </table>
31860 tejbeer 607
        </div>
35064 aman 608
        <div class="col-4 mt-2">
31860 tejbeer 609
 
35064 aman 610
            <canvas id="chartInvestmentJSContainer" width="auto" height="auto"></canvas>
611
 
31860 tejbeer 612
        </div>
35064 aman 613
    </div>
614
 
615
    <div class="row mt-2">
616
        <div class="col">
617
            <h6 class=" yellow p-1 text-center">Current Stock</h6>
618
        </div>
619
    </div>
620
    <div class="row">
621
        <div class="col">
622
            <table class="table table-bordered table-sm">
623
                <thead>
624
                <th scope="row"></th>
625
                <td colspan="2" class="text-center">Current</td>
626
                <td></td>
627
                <td colspan="2" class="text-center">GRN Pending</td>
628
                <td colspan="2" class="text-center">Pending Indent</td>
629
                </thead>
630
                <thead>
631
                <tr class="orange">
632
                    <th scope="col">Brand</th>
633
                    <th scope="col">Value</th>
634
                    <th scope="col">Units</th>
635
                    <th scope="col">Brand status</th>
636
                    <th scope="col">Value</th>
637
                    <th scope="col">Units</th>
638
                    <th scope="col">Value</th>
639
                    <th scope="col">Units</th>
640
 
641
                </tr>
642
                </thead>
643
                <tbody>
644
 
645
                    #foreach($brandsDisplay in $brandsDisplays)
646
                        #set($brand = $brandsDisplay.getName())
647
                    <tr>
648
                        <td class="details">$brand</td>
649
                        #if($brandStockMap.get($brand))
31952 tejbeer 650
                            <td class="currency $brandStockMap.get($brand).getColor()">$brandStockMap.get($brand).getTotalValue()</td>
31860 tejbeer 651
                            <td>$brandStockMap.get($brand).getTotalQty()</td>
35064 aman 652
                        #else
31884 tejbeer 653
                            <td class="$brandStockMap.get($brand).getColor()">0</td>
31860 tejbeer 654
                            <td>0</td>
35064 aman 655
 
656
                        #end
657
                        #if($retailerBlockBrands.get($brand))
31860 tejbeer 658
                            <td>Blocked</td>
35064 aman 659
                        #else
31860 tejbeer 660
                            <td>ACTIVE</td>
35064 aman 661
                        #end
662
                        #if($grnPendingValue.get($brand))
663
                            <td class="currency">$grnPendingValue.get($brand)</td>
31860 tejbeer 664
                            <td>$grnPendingQty.get($brand)</td>
35064 aman 665
                        #else
31860 tejbeer 666
                            <td>0</td>
667
                            <td>0</td>
668
 
35064 aman 669
                        #end
670
                        #if($processingOrderMap.get($brand))
671
                            <td class="currency">$processingOrderMap.get($brand).get("val")</td>
672
                            <td class="currency">$processingOrderMap.get($brand).get("qty")</td>
673
 
674
                        #else
675
                            <td>0</td>
676
                            <td>0</td>
677
                        #end
678
 
679
                    </tr>
680
 
681
                    #end
682
 
683
                <tr>
684
                    <td> Total</td>
685
                    <td class="currency"> $totalStock</td>
686
                    <td>$totalQty </td>
687
                    <td></td>
688
 
689
                    #if($totalGrnPendingStock)
690
                        <td class="currency"> $totalGrnPendingStock</td>
691
                    #else
692
                        <td></td>
693
                    #end
694
 
695
                    #if($totalGrnPendingQty)
696
                        <td> $totalGrnPendingQty</td>
697
                    #else
698
                        <td></td>
699
                    #end
700
                    #if($totalGrnPendingQty)
701
                        <td class="currency"> $totalPIValue</td>
702
                        <td> $totalPIQty</td>
703
                    #else
704
                        <td></td>
705
                        <td></td>
706
                    #end
707
 
708
                </tr>
709
 
710
                </tbody>
711
            </table>
31860 tejbeer 712
        </div>
35064 aman 713
    </div>
31860 tejbeer 714
 
35064 aman 715
    <div class="row">
716
        <div class="col bg-dark text-left px-3 py-2 border-bottom">
717
            <h5 class="text-light mb-0">Sales & Income Trend</h5>
31860 tejbeer 718
        </div>
35064 aman 719
    </div>
31860 tejbeer 720
 
35064 aman 721
    <div class="row mt-2">
722
        <div class="col">
723
            <ul class="nav nav-tabs" role="tablist">
724
                <li class="nav-item">
725
                    <a class="nav-link active" data-toggle="tab" href="#secondary">Secondary</a>
726
                </li>
727
                <li class="nav-item">
728
                    <a class="nav-link" data-toggle="tab" href="#tertiary">Tertiary</a>
729
                </li>
730
                <li class="nav-item">
731
                    <a class="nav-link" data-toggle="tab" href="#earning">Earning</a>
732
                </li>
733
            </ul>
31860 tejbeer 734
 
35064 aman 735
            <!-- Tab panes -->
736
            <div class="tab-content">
31860 tejbeer 737
 
35064 aman 738
                <div id="secondary" class="container-fluid tab-pane active"><br>
739
                    <div class="row">
740
                        <div class="col-6">
741
                            <div class="p-2 text-center">#if($lastPurchaseDays < 5)
742
                                <span class="text-success">Last Secondary:  $lastPurchaseDays days back </span>
743
                            #else
744
                                <span class="text-danger">Last Secondary: $lastPurchaseDays days back </span>
745
                            #end
746
                            </div>
747
 
748
                            <table id="partnerSecondary" class="table table-bordered table-sm">
749
                                <thead>
750
                                <tr class="orange">
751
                                    <th scope="col">Month</th>
752
                                    #foreach($label in $labels)
753
                                        <th scope="col">$label</th>
754
                                    #end
755
                                </tr>
756
                                </thead>
757
                                <tbody>
758
                                    #foreach($allBrand in $allBrands)
759
                                        #set($brand = $allBrand.getName())
760
                                        #set($purchase = $purchaseMap.get($brand))
761
                                    <tr>
762
                                        <td class="details brandFocusedStock" data-fofoid="$fofoId" data-brand="$brand"
763
                                            data-toggle="modal" data-target="#itemWiseBrandStock">$brand</td>
764
                                        #foreach($label in $labels)
35310 aman 765
                                            #set($revIndex = $labels.size() - 1 - $foreach.index)
35064 aman 766
                                            #if($brand.equals("Samsung"))
31887 tejbeer 767
                                                #if($purchase.get($label))
35064 aman 768
                                                    #if($purchase.get($label) >= 150000)
769
                                                        <td class="currency green " data-brand="$brand"
35310 aman 770
                                                            data-index="$revIndex"
35064 aman 771
                                                            data-month="$label">$purchase.get($label)</td>
772
                                                    #else
773
                                                        <td class="currency red " data-brand="$brand"
35310 aman 774
                                                            data-index="$revIndex"
35064 aman 775
                                                            data-month="$label">$purchase.get($label)</td>
776
                                                    #end
31887 tejbeer 777
                                                #else
35064 aman 778
                                                    <td data-brand="$brand"
35310 aman 779
                                                        data-index="$revIndex"
35064 aman 780
                                                        data-month="$label">0
781
                                                    </td>
31887 tejbeer 782
                                                #end
35064 aman 783
                                            #end
784
 
785
                                            #if($brand.equals("Xiaomi"))
31887 tejbeer 786
                                                #if($purchase.get($label))
35064 aman 787
                                                    #if($purchase.get($label) >= 100000)
788
                                                        <td class="currency green " data-brand="$brand"
35310 aman 789
                                                            data-index="$revIndex"
35064 aman 790
                                                            data-month="$label">$purchase.get($label)</td>
791
                                                    #else
792
                                                        <td class="currency red " data-brand="$brand"
35310 aman 793
                                                            data-index="$revIndex"
35064 aman 794
                                                            data-month="$label">$purchase.get($label)</td>
795
                                                    #end
31887 tejbeer 796
                                                #else
35064 aman 797
                                                    <td data-brand="$brand"
35310 aman 798
                                                        data-index="$revIndex"
35064 aman 799
                                                        data-month="$label">0
800
                                                    </td>
31887 tejbeer 801
                                                #end
35064 aman 802
                                            #end
803
 
804
                                            #if($brand.equals("Oppo") || $brand.equals("Vivo"))
31887 tejbeer 805
                                                #if($purchase.get($label))
35064 aman 806
                                                    #if($purchase.get($label) >= 200000)
807
                                                        <td class="currency green " data-brand="$brand"
35310 aman 808
                                                            data-index="$revIndex"
35064 aman 809
                                                            data-month="$label">$purchase.get($label)</td>
810
                                                    #else
811
                                                        <td class="currency red " data-brand="$brand"
35310 aman 812
                                                            data-index="$revIndex"
35064 aman 813
                                                            data-month="$label">$purchase.get($label)</td>
814
                                                    #end
31887 tejbeer 815
                                                #else
35064 aman 816
                                                    <td data-brand="$brand"
35310 aman 817
                                                        data-index="$revIndex"
35064 aman 818
                                                        data-month="$label">0
819
                                                    </td>
31887 tejbeer 820
                                                #end
35064 aman 821
                                            #end
822
 
823
                                            #if(!$brand.equals("Oppo") && !$brand.equals("Vivo") && !$brand.equals(
824
                                                "Xiaomi") && !$brand.equals("Samsung"))
31887 tejbeer 825
                                                #if($purchase.get($label))
35064 aman 826
                                                    <td class="currency " data-brand="$brand"
35310 aman 827
                                                        data-index="$revIndex"
35064 aman 828
                                                        data-month="$label">$purchase.get($label)</td>
31887 tejbeer 829
                                                #else
35064 aman 830
                                                    <td data-brand="$brand"
35310 aman 831
                                                        data-index="$revIndex"
35064 aman 832
                                                        data-month="$label">0
833
                                                    </td>
834
                                                #end
31860 tejbeer 835
                                            #end
35064 aman 836
                                        #end
837
                                    </tr>
838
                                    #end
31860 tejbeer 839
 
36543 amit 840
                                <tr>
841
                                    <td class="details">Others</td>
842
                                    #foreach($label in $labels)
843
                                        #if($yearMonthPurchaseOthers.get($label))
844
                                            <td class="currency">$yearMonthPurchaseOthers.get($label)</td>
845
                                        #else
846
                                            <td>0</td>
847
                                        #end
848
                                    #end
849
                                </tr>
850
 
35064 aman 851
                                <tr class="font-weight-bold">
852
                                    <td class="details">Total</td>
853
                                    #foreach($label in $labels)
854
                                        #if($yearMonthPurchase.get($label))
855
                                            <td class="currency">$yearMonthPurchase.get($label)</td>
856
                                        #else
857
                                            <td>0</td>
858
                                        #end
859
                                    #end
860
                                </tr>
861
 
862
                                <tr>
863
                                    <td class="details">Target</td>
864
                                    #foreach($label in $labels)
865
                                        #if($monthlyTarget.get($label).getPurchaseTarget())
35119 aman 866
                                            <td class="currency">$decimalFormatter.format($monthlyTarget.get($label).getPurchaseTarget())</td>
35064 aman 867
                                        #else
868
                                            <td>0</td>
869
                                        #end
870
                                    #end
871
                                </tr>
872
 
873
                                <tr>
874
                                    <td class="details">% achvmt</td>
875
                                    #foreach($label in $labels)
876
                                        #if($yearMonthPurchase.get($label))
877
                                            #set($ymp = $yearMonthPurchase.get($label))
878
                                        #else
879
                                            #set($ymp = 0)
880
                                        #end
881
 
882
                                        #if($monthlyTarget.get($label).getPurchaseTarget())
883
                                            #set($mt = $monthlyTarget.get($label).getPurchaseTarget())
884
                                        #else
885
                                            #set($mt = 0)
886
                                        #end
887
 
888
                                        #set($div = ($ymp / $mt) * 100)
889
                                        #if($div)
890
                                            #if($div > 65)
891
                                                <td class="text-success">$math.roundTo(2, $div)%</td>
31860 tejbeer 892
                                            #else
35064 aman 893
                                                <td class="text-danger">$math.roundTo(2, $div)%</td>
31860 tejbeer 894
                                            #end
35064 aman 895
                                        #else
896
                                            <td class="text-danger">-</td>
897
                                        #end
898
                                    #end
899
                                </tr>
900
                                </tbody>
901
                            </table>
902
                        </div>
903
                        <div id="rightTable" style="display: none;">
904
                            <h3 class="ms-10">Item wise sale quantity</h3>
905
                            <table class="table table-bordered table-sm  ps-5 ms-10">
906
                                <thead>
907
                                <tr>
31860 tejbeer 908
 
35064 aman 909
                                    <th>Model</th>
910
                                    <th>Quantity</th>
911
                                </tr>
912
                                </thead>
913
                                <tbody id="rightTableBody">
914
                                </tbody>
915
                            </table>
916
                        </div>
917
                        <div class="col-6 mt-2">
31892 tejbeer 918
 
35064 aman 919
 
920
                            <canvas id="chartSecondaryJSContainer" width="auto" height="auto"></canvas>
921
 
31860 tejbeer 922
                        </div>
35064 aman 923
 
924
 
925
                        <div id="itemWiseBrandStock" class="modal" role="dialog">
926
                            <div class="modal-dialog">
927
                                <div class="modal-content" style="width:140%">
928
 
929
                                </div>
930
                            </div>
931
                        </div>
31860 tejbeer 932
                    </div>
933
 
35064 aman 934
                </div>
31860 tejbeer 935
 
936
 
35064 aman 937
                <div id="tertiary" class="container-fluid tab-pane fade"><br>
938
                    <div class="row">
939
                        <div class="col-6">
940
                            <div class="p-2  text-center">
31860 tejbeer 941
                                #if($lastTertiaryDays < 5)
35064 aman 942
                                    <span class="text-success">Last tertiary: $lastTertiaryDays days back </span>
943
                                #else
944
                                    <span class="text-danger">Last tertiary: $lastTertiaryDays days back </span>
31860 tejbeer 945
                                #end
35064 aman 946
 
947
                                #if($lastUnbilledActivated > 0)
948
                                    <td class="text-danger">Unbilled Activated : $investment.getUnbilledAmount()</td>
949
 
950
 
31887 tejbeer 951
                                #else
35064 aman 952
 
953
                                    <td class="text-success"> Unbilled Activated : 0</td>
31887 tejbeer 954
                                #end
35064 aman 955
                            </div>
956
                            <table class="table table-bordered table-sm">
957
                                <thead>
958
                                <tr class="orange">
959
                                    <th scope="col">Month</th>
960
                                    #foreach($label in $labels)
961
                                        <th scope="col">$label</th>
962
                                    #end
963
                                </tr>
964
                                </thead>
965
                                <tbody>
966
                                    #foreach($allBrand in $allBrands)
967
                                        #set($brand = $allBrand.getName())
968
                                        #set($tertiary= $tertiaryMap.get($brand))
969
                                    <tr>
970
 
971
                                        <td class="details">$brand</td>
972
                                        #foreach($label in $labels)
973
                                            #if($brand.equals("Samsung"))
31887 tejbeer 974
                                                #if($tertiary.get($label))
35064 aman 975
                                                    #if($tertiary.get($label) >= 150000)
976
                                                        <td class="currency green">$tertiary.get($label)</td>
977
                                                    #else
978
                                                        <td class="currency red">$tertiary.get($label)</td>
979
                                                    #end
31887 tejbeer 980
                                                #else
35064 aman 981
                                                    <td>0</td>
31887 tejbeer 982
                                                #end
35064 aman 983
 
984
                                            #end
985
 
986
                                            #if($brand.equals("Xiaomi"))
31887 tejbeer 987
                                                #if($tertiary.get($label))
35064 aman 988
                                                    #if($tertiary.get($label) >= 100000)
989
                                                        <td class="currency green">$tertiary.get($label)</td>
990
                                                    #else
991
                                                        <td class="currency red">$tertiary.get($label)</td>
992
                                                    #end
31887 tejbeer 993
                                                #else
35064 aman 994
                                                    <td>0</td>
31887 tejbeer 995
                                                #end
35064 aman 996
 
997
                                            #end
998
 
999
                                            #if($brand.equals("Oppo") || $brand.equals("Vivo") )
31887 tejbeer 1000
                                                #if($tertiary.get($label))
35064 aman 1001
                                                    #if($tertiary.get($label) >= 200000)
1002
                                                        <td class="currency green">$tertiary.get($label)</td>
1003
                                                    #else
1004
                                                        <td class="currency red">$tertiary.get($label)</td>
1005
                                                    #end
31887 tejbeer 1006
                                                #else
35064 aman 1007
                                                    <td>0</td>
31887 tejbeer 1008
                                                #end
35064 aman 1009
 
1010
                                            #end
1011
 
1012
                                            #if(!$brand.equals("Oppo") && !$brand.equals("Vivo") && !$brand.equals(
1013
                                                "Xiaomi") && !$brand.equals("Samsung") )
1014
 
31887 tejbeer 1015
                                                #if($tertiary.get($label))
35064 aman 1016
 
1017
                                                    <td class="currency">$tertiary.get($label) </td>
1018
 
31887 tejbeer 1019
                                                #else
35064 aman 1020
                                                    <td>0</td>
1021
                                                #end
1022
 
31860 tejbeer 1023
                                            #end
1024
 
35064 aman 1025
 
1026
                                        #end
1027
 
1028
                                    </tr>
1029
 
1030
                                    #end
1031
 
36543 amit 1032
                                <tr>
1033
                                    <td class="details">Others</td>
1034
                                    #foreach($label in $labels)
1035
                                        #if($yearMonthTertiaryOthers.get($label))
1036
                                            <td class="currency">$yearMonthTertiaryOthers.get($label)</td>
1037
                                        #else
1038
                                            <td>0</td>
1039
                                        #end
1040
                                    #end
1041
                                </tr>
1042
 
35064 aman 1043
                                <tr class="font-weight-bold">
1044
                                    <td class="details">Total</td>
1045
                                    #foreach($label in $labels)
1046
                                        #if($yearMonthTertiary.get($label))
1047
 
32002 tejbeer 1048
                                            <td class="currency">$yearMonthTertiary.get($label)</td>
35064 aman 1049
                                        #else
1050
                                            <td> 0</td>
1051
                                        #end
1052
                                    #end
31860 tejbeer 1053
 
35064 aman 1054
                                </tr>
1055
 
1056
 
1057
                                <tr class="font-weight-bold">
1058
                                    <td class="details"></td>
1059
                                    #foreach($label in $labels)
1060
                                        #if($yearMonthPartnerType.get($label))
1061
 
31967 tejbeer 1062
                                            <td>$yearMonthPartnerType.get($label).getValue()</td>
35064 aman 1063
                                        #else
1064
                                            <td> -</td>
1065
                                        #end
1066
                                    #end
31860 tejbeer 1067
 
35064 aman 1068
                                </tr>
1069
                                <tr>
1070
                                    <td class="details">Target</td>
1071
                                    #foreach($label in $labels)
1072
                                        #if($monthlyTarget.get($label).getSaleTarget())
32001 tejbeer 1073
                                            <td class="currency"> $monthlyTarget.get($label).getSaleTarget()</td>
35064 aman 1074
                                        #else
1075
                                            <td>0</td>
1076
                                        #end
1077
 
1078
                                    #end
1079
 
1080
                                </tr>
1081
                                <tr>
1082
                                    <td class="details">% achvmt</td>
1083
 
1084
 
1085
 
1086
                                    #foreach($label in $labels)
1087
                                        #if($yearMonthTertiary.get($label))
1088
                                            #set($ymt = $yearMonthTertiary.get($label))
1089
                                        #else
1090
                                            #set($ymt = 0)
1091
                                        #end
1092
 
1093
                                        #if($monthlyTarget.get($label).getSaleTarget())
1094
                                            #set($mst = $monthlyTarget.get($label).getSaleTarget())
1095
                                        #else
1096
                                            #set($mst= 0 )
1097
                                        #end
1098
                                        #set($dit=  ($ymt/ $mst)* 100)
1099
                                        #if($dit)
1100
                                            #if($dit >65)
1101
                                                <td class="text-success">$math.roundTo(2, $dit)%</td>
31860 tejbeer 1102
                                            #else
35064 aman 1103
                                                <td class="text-danger">$math.roundTo(2, $dit)%</td>
31860 tejbeer 1104
                                            #end
35064 aman 1105
                                        #else
1106
                                            <td class="text-danger">-</td>
1107
                                        #end
31860 tejbeer 1108
 
35064 aman 1109
                                    #end
1110
                                </tr>
1111
                                </tbody>
1112
                            </table>
31860 tejbeer 1113
 
1114
                        </div>
35064 aman 1115
                        <div class="col-6 mt-2">
1116
 
1117
                            <canvas id="chartTertiaryJSContainer" width="auto" height="auto"></canvas>
1118
 
1119
                        </div>
31860 tejbeer 1120
                    </div>
35064 aman 1121
 
1122
                </div>
1123
                <div id="earning" class="container-fluid tab-pane fade"><br>
1124
                    <div class="row">
1125
                        <div class="col-6">
1126
                            <table class="table table-bordered table-sm">
1127
                                <thead>
1128
                                <tr class="orange">
1129
                                    <th scope="col">Month</th>
1130
                                    #foreach($label in $labels)
1131
                                        <th scope="col">$label</th>
1132
                                    #end
1133
                                </tr>
1134
 
1135
 
1136
                                </thead>
1137
                                <tbody>
1138
 
1139
                                    #foreach($allBrand in $allBrands)
1140
                                        #set($brand = $allBrand.getName())
1141
 
1142
                                    <tr>
1143
 
1144
                                        <td class="details">$brand</td>
1145
                                        #foreach($label in $labels)
1146
                                            #set($earning= $earningMap.get($label))
1147
                                            #if($earning.get($brand))
1148
                                                <td class="currency">$earning.get($brand)</td>
31860 tejbeer 1149
                                            #else
35064 aman 1150
                                                <td>0</td>
31860 tejbeer 1151
                                            #end
35064 aman 1152
                                        #end
31860 tejbeer 1153
 
35064 aman 1154
                                    </tr>
1155
 
1156
 
1157
                                    #end
1158
 
36543 amit 1159
                                <tr>
1160
                                    <td class="details">Others</td>
1161
                                    #foreach($label in $labels)
1162
                                        #if($earningOthersPerMonth.get($label))
1163
                                            <td class="currency">$decimalFormatter.format($earningOthersPerMonth.get($label))</td>
1164
                                        #else
1165
                                            <td>0</td>
1166
                                        #end
1167
                                    #end
1168
                                </tr>
1169
 
35064 aman 1170
                                <tr class="font-weight-bold">
1171
                                    <td class="details">Total</td>
1172
                                    #foreach($label in $labels)
1173
                                        #if($totalEarningPerMonth.get($label))
1174
 
35119 aman 1175
                                            <td class="currency">$decimalFormatter.format($totalEarningPerMonth.get($label))</td>
35064 aman 1176
                                        #else
1177
                                            <td> -</td>
1178
                                        #end
1179
                                    #end
31860 tejbeer 1180
 
35064 aman 1181
                                </tr>
31860 tejbeer 1182
 
35064 aman 1183
                                </tbody>
1184
                            </table>
1185
 
31860 tejbeer 1186
                        </div>
35064 aman 1187
                        <div class="col-6 mt-2">
1188
 
1189
 
1190
                            <canvas id="chartEarningJSContainer" width="auto" height="auto"></canvas>
1191
 
1192
                        </div>
1193
 
1194
 
31860 tejbeer 1195
                    </div>
1196
                </div>
1197
            </div>
1198
        </div>
1199
    </div>
35064 aman 1200
</div>
31860 tejbeer 1201
 
1202
 
35064 aman 1203
</div>
31860 tejbeer 1204
 
1205
 
35064 aman 1206
<!-- Optional JavaScript -->
1207
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
31896 tejbeer 1208
 
31901 tejbeer 1209
 
35064 aman 1210
<script>
1211
    var op = $chartInvestment;
1212
    var px = document.getElementById('chartInvestmentJSContainer').getContext('2d');
1213
    var chart = new Chart1(px, op);
1214
    chart.update();
31860 tejbeer 1215
 
35064 aman 1216
 
1217
    var ops = $chartPurchase;
1218
    var pxs = document.getElementById('chartSecondaryJSContainer').getContext('2d');
1219
    var chartSec = new Chart1(pxs, ops);
1220
    chartSec.update();
1221
 
1222
    var opt = $chartTertiary;
1223
    var pxt = document.getElementById('chartTertiaryJSContainer').getContext('2d');
1224
    var chartTer = new Chart1(pxt, opt);
1225
    chartTer.update();
1226
 
1227
    var ope = $chartEarning;
1228
    var pxe = document.getElementById('chartEarningJSContainer').getContext('2d');
1229
    var chartEar = new Chart1(pxe, ope);
1230
    chartEar.update();
1231
</script>
1232
</body>
1233
 
31860 tejbeer 1234
</html>
35064 aman 1235
 
1236
<script>
1237
    document.querySelectorAll('#partnerSecondary tbody td.currency[data-brand][data-month]').forEach(function (cell) {
1238
        context = "${rc.contextPath}";
1239
        cell.addEventListener('click', function () {
1240
            const brandName = cell.getAttribute('data-brand');
1241
            const monthName = cell.getAttribute('data-month');
35310 aman 1242
            const index = cell.getAttribute('data-index');
35064 aman 1243
            const fofoId = "$!{request.getParameter('fofoId')}";
1244
            const rightTable = document.getElementById('rightTable');
1245
            if (rightTable) {
1246
                rightTable.style.display = 'block';
1247
            }
1248
 
1249
            const contextPath = window.location.pathname.substring(0, window.location.pathname.indexOf("/", 2));
1250
            doGetAjaxRequestHandler(
35310 aman 1251
                    `${context}/getBrandItemwisePartnerSecondarySale?month=${index}&brand=${brandName}&fofoId=${fofoId}`,
35064 aman 1252
                    function (response) {
1253
                        console.log("getting the api response", response)
1254
                        const rightTableBody = document.getElementById('rightTableBody');
1255
                        if (rightTableBody) {
1256
                            rightTableBody.innerHTML = '';
35119 aman 1257
                            let totalQuantity = 0;
35064 aman 1258
 
1259
                            response.forEach(function (item) {
35119 aman 1260
                                const qty = parseInt(item.quantity.toString().replace(/,/g, ''), 10) || 0; // remove commas, fallback to 0
35064 aman 1261
                                const row = document.createElement('tr');
1262
                                row.classList.add('clickable-brandrow');
1263
                                row.innerHTML =
1264
                                        '<td>' + item.brand + " " + item.modelNumber + '</td>' +
1265
                                        '<td>' + item.quantity + '</td>';
1266
 
1267
                                rightTableBody.appendChild(row);
35119 aman 1268
                                totalQuantity += qty;
35064 aman 1269
                            });
35119 aman 1270
 
1271
                            const totalRow = document.createElement('tr');
1272
                            totalRow.innerHTML =
1273
                                    '<td><strong>Total</strong></td>' +
1274
                                    '<td><strong>' + totalQuantity + '</strong></td>';
1275
                            rightTableBody.appendChild(totalRow);
35064 aman 1276
                        }
1277
 
35119 aman 1278
 
35064 aman 1279
                        const tableTitle = document.getElementById('tableTitle');
1280
                        if (tableTitle) {
1281
                            tableTitle.textContent = `${brandName} - ${monthName} Details`;
1282
                        }
1283
                    }
1284
            );
1285
        });
1286
    });
1287
</script>