Subversion Repositories SmartDukaan

Rev

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