Subversion Repositories SmartDukaan

Rev

Rev 35839 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
31665 amit.gupta 1
<style>
30003 tejbeer 2
 
31665 amit.gupta 3
    .brandStock .tooltiptext {
4
        visibility: hidden;
5
        width: 120px;
6
        background-color: black;
7
        color: #fff;
8
        text-align: center;
9
        border-radius: 6px;
10
        padding: 5px 0;
30003 tejbeer 11
 
31665 amit.gupta 12
        /* Position the tooltip */
13
        position: absolute;
14
        z-index: 1;
15
    }
30044 tejbeer 16
 
31665 amit.gupta 17
    .brandStock:hover .tooltiptext {
18
        visibility: visible;
19
    }
20
</style>
21
 
30003 tejbeer 22
<section class="wrapper">
31665 amit.gupta 23
    <div class="row">
24
        <div class="col-lg-12">
25
            <h3 class="page-header"><i class="icon_document_alt"></i>BRAND WISE PLACEMENT</h3>
26
            <ol class="breadcrumb">
27
                <li><i class="fa fa-home"></i><a href="${rc.contextPath}/dashboard">Home</a></li>
28
                <li><i class="icon_document_alt"></i>BrandWise Placement</li>
29
            </ol>
30
        </div>
31
    </div>
32
 
33
    <div class="row">
34
 
35
        <div class="col-lg-12">
36
            <table id="partnerBrandWiseDetail" class="table table-striped table-advance table-hover" style="width:100%">
37
                <thead>
38
                <tr>
39
                    <th>Partner Name</th>
40
                    <th>Code</th>
41
                    <th>Category</th>
42
                    <th>Manager</th>
43
                    <th>Wallet Amount</th>
44
                    <th>Short Invest</th>
45
                    <th>Min Invest</th>
33812 tejus.loha 46
                    <th>Total Due</th>
33806 tejus.loha 47
                    <th>Monthly target</th>
48
                    <th>MTD Purchase</th>
49
                    <th>MTD Sale</th>
31665 amit.gupta 50
 
51
                    #foreach($brand in $brands)
52
 
53
                        <th class="$brand.toLowerCase()"><p>$brand</p></th>
54
                    #end
55
                    <th>Accessories</th>
56
                    <th>TV</th>
33806 tejus.loha 57
                    <th>Activation Type</th>
31665 amit.gupta 58
                </tr>
59
 
60
                </thead>
61
                <tbody>
62
 
63
                    #foreach($cr in $customRetailers.entrySet())
36614 aman 64
                        #set($pdi = $partnerDailyInvestmentMap.get($cr.getKey()))
31665 amit.gupta 65
                    <tr>
66
                        <td class="brandStock" data-fofoid="$cr.getKey()" data-toggle="modal"
67
                            data-target="#itemWiseBrandStock">$cr.getValue().getBusinessName()</td>
68
                        <td>$cr.getValue().getCode()</td>
69
 
34397 ranu 70
                        <td>$fofoIdPartnerTypeMap.get($cr.getKey())
36614 aman 71
                            #if($pdi)
72
                                <input type="hidden" class="shortInvestment-mk"
73
                                       value="$pdi.getShortInvestment().longValue()">
74
                            #else
75
                                <input type="hidden" class="shortInvestment-mk" value="0">
76
                            #end
35015 ranu 77
                            #if($totalDueMap.get($cr.getKey()).longValue())
78
                                <input type="hidden" class="totaldue-with-interest-mk"
79
                                       value="$totalDueMap.get($cr.getKey()).longValue()">
80
                            #else
81
                                <input type="hidden" class="totaldue-with-interest-mk" value="0">
82
                            #end
34401 ranu 83
 
34397 ranu 84
                        </td>
31665 amit.gupta 85
                        <td>$partnerSalesHeadersMap.get($cr.getKey()).getTerritoryManager()</td>
86
 
36614 aman 87
                        #if($pdi)
88
                            <td class="currency">$pdi.getWalletAmount()</td>
31665 amit.gupta 89
 
36614 aman 90
                            #set($realInvestment = $pdi.getTotalInvestment() + $pdi.getShortInvestment())
91
                            #set($realpercent = ($pdi.getTotalInvestment() / $realInvestment)*100)
31665 amit.gupta 92
 
36614 aman 93
                            #if($realpercent < 75)
94
                                <td class="currency" style="color:red">$pdi.getShortInvestment()</td>
95
                            #else
96
                                <td class="currency">$pdi.getShortInvestment()</td>
97
                            #end
98
                            <td class="currency">$pdi.getMinInvestment()</td>
30003 tejbeer 99
                        #else
36614 aman 100
                            <td class="currency">--</td>
101
                            <td class="currency">--</td>
102
                            <td class="currency">--</td>
31665 amit.gupta 103
                        #end
33812 tejus.loha 104
 
105
                        #if($totalDueMap.get($cr.getKey())>0)
106
                            <td class="currency">$totalDueMap.get($cr.getKey()).setScale(0,$ru)</td>
33806 tejus.loha 107
                        #else
108
                            <td class="currency">--</td>
33812 tejus.loha 109
                        #end
31665 amit.gupta 110
 
33812 tejus.loha 111
                        #if($fofoIdMonthlyTargetMap.get($cr.getKey()).getPurchaseTarget())
36614 aman 112
                            <td class="currency">$fofoIdMonthlyTargetMap.get($cr.getKey()).getPurchaseTarget()</td>
33812 tejus.loha 113
                        #else
114
                            <td class="currency">--</td>
33806 tejus.loha 115
                        #end
33812 tejus.loha 116
 
36614 aman 117
                        #set($isOverSale = $fofoMTDSaleMap.get($cr.getKey())>$currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))
118
                        #set($salePurchaseGap = $fofoMTDSaleMap.get($cr.getKey())-$currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))
33813 tejus.loha 119
 
33806 tejus.loha 120
                        #if($currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))
33813 tejus.loha 121
                            #if($isOverSale)
122
                                #if($salePurchaseGap>50000)
36614 aman 123
                                    <td class="currency"
124
                                        style="color:red">$currentMonthTillDateRetailerPOValueMap.get($cr.getKey())</td>
33813 tejus.loha 125
                                #else
36614 aman 126
                                    <td class="currency"
127
                                        style="color:darkorange">$currentMonthTillDateRetailerPOValueMap.get($cr.getKey())</td>
33813 tejus.loha 128
                                #end
33812 tejus.loha 129
                            #else
36614 aman 130
                                <td class="currency">$currentMonthTillDateRetailerPOValueMap.get($cr.getKey())</td>
33812 tejus.loha 131
                            #end
33806 tejus.loha 132
                        #else
133
                            <td class="currency">--</td>
33812 tejus.loha 134
                        #end
31665 amit.gupta 135
 
33806 tejus.loha 136
                        #if($fofoMTDSaleMap.get($cr.getKey()))
33813 tejus.loha 137
                            #if($isOverSale)
138
                                #if($salePurchaseGap>50000)
36614 aman 139
                                    <td class="currency" style="color:red">$fofoMTDSaleMap.get($cr.getKey())</td>
33813 tejus.loha 140
                                #else
36614 aman 141
                                    <td class="currency" style="color:darkorange">$fofoMTDSaleMap.get($cr.getKey())</td>
33813 tejus.loha 142
                                #end
33812 tejus.loha 143
                            #else
36614 aman 144
                                <td class="currency">$fofoMTDSaleMap.get($cr.getKey())</td>
33812 tejus.loha 145
                            #end
33806 tejus.loha 146
                        #else
147
                            <td class="currency">--</td>
148
                        #end
149
 
31665 amit.gupta 150
                        #foreach($brand in $brands)
36614 aman 151
                            #set($totalStock = $fofoIdBrandAmountMap.get($cr.getKey()).get($brand))
152
                            #set($totalStockQty = $decimalFormatter.format($fofoIdBrandQtyMap.get($cr.getKey()).get($brand)))
31665 amit.gupta 153
                            #set($minBrandAmount = 0.0)
154
                            #set($stockPercent = 100)
155
 
156
                            #if($partnerBrandLimitMap.get($cr.getKey()))
157
                                #if($partnerBrandLimitMap.get($cr.getKey()).get($brand))
158
                                    #set($minBrandAmount = $partnerBrandLimitMap.get($cr.getKey()).get($brand))
36614 aman 159
                                    #set($stockPercent = ($totalStock / $minBrandAmount)*100)
31665 amit.gupta 160
                                #end
161
                            #end
162
 
163
                            #if($brand == "Nokia" || $brand == "Xiaomi" || $brand == "Realme")
164
                                <td class="currency brandStock" data-fofoid="$cr.getKey()" data-brand="$brand"
35484 ranu 165
                                    data-toggle="modal" data-target="#itemWiseBrandStock">$totalStockQty <span
31665 amit.gupta 166
                                        class="tooltiptext">$minBrandAmount</span></td>
167
                            #else
36614 aman 168
                                #if($stockPercent > 90)
31665 amit.gupta 169
                                    <td class="currency brandStock" style="background-color:#52BE80"
170
                                        data-stock="$inStockBrandModel.get($cr.getKey()).get($brand)"
171
                                        data-pending="$pendingIndent.get($cr.getKey()).get($brand)"
172
                                        data-grn="$grnPendingOrders.get($cr.getKey()).get($brand)"
173
                                        data-fofoid="$cr.getKey()" data-brand="$brand" data-toggle="modal"
35484 ranu 174
                                        data-target="#itemWiseBrandStock">$totalStockQty <span
31665 amit.gupta 175
                                            class="tooltiptext">$minBrandAmount</span></td>
36614 aman 176
                                #elseif($stockPercent < 80)
31665 amit.gupta 177
                                    <td class="currency brandStock" style="background-color:#EC7063 "
178
                                        data-stock="$inStockBrandModel.get($cr.getKey()).get($brand)"
179
                                        data-pending="$pendingIndent.get($cr.getKey()).get($brand)"
180
                                        data-grn="$grnPendingOrders.get($cr.getKey()).get($brand)"
181
                                        data-fofoid="$cr.getKey()" data-brand="$brand" data-toggle="modal"
35484 ranu 182
                                        data-target="#itemWiseBrandStock"> $totalStockQty <span
31665 amit.gupta 183
                                            class="tooltiptext">$minBrandAmount</span></td>
184
                                #else
185
                                    <td class="currency brandStock" style="background-color:#F7DC6F"
186
                                        data-stock="$inStockBrandModel.get($cr.getKey()).get($brand)"
187
                                        data-pending="$pendingIndent.get($cr.getKey()).get($brand)"
188
                                        data-grn="$grnPendingOrders.get($cr.getKey()).get($brand)"
189
                                        data-fofoid="$cr.getKey()" data-brand="$brand" data-toggle="modal"
35484 ranu 190
                                        data-target="#itemWiseBrandStock">$totalStockQty <span
31665 amit.gupta 191
                                            class="tooltiptext">$minBrandAmount</span></td>
192
                                #end
193
 
194
                            #end
195
 
196
                        #end
197
 
198
                        #if($inStockAccessTv.get($cr.getKey()))
199
                            #set($inStockAcc = $inStockAccessTv.get($cr.getKey()).getAccessoriesAmount())
200
                            #set($inStockTv = $inStockAccessTv.get($cr.getKey()).getTvAmount())
30003 tejbeer 201
                        #else
31665 amit.gupta 202
                            #set($inStockAcc = 0)
203
                            #set($inStockTv = 0)
204
                        #end
205
 
35490 ranu 206
                        #if($inStockQtyAccessTv.get($cr.getKey()))
207
                            #set($inStockAccQty = $inStockQtyAccessTv.get($cr.getKey()).getAccessoriesQty())
208
                            #set($inStockTvQty = $inStockQtyAccessTv.get($cr.getKey()).getTvQty())
209
                        #else
210
                            #set($inStockAccQty = 0)
211
                            #set($inStockTvQty = 0)
212
                        #end
31665 amit.gupta 213
 
35490 ranu 214
 
31665 amit.gupta 215
                        #if($pendingIndentAccessTv.get($cr.getKey()))
216
                            #set($pendingIndentAcc = $pendingIndentAccessTv.get($cr.getKey()).getAccessoriesAmount())
217
                            #set($pendingIndentTv = $pendingIndentAccessTv.get($cr.getKey()).getTvAmount())
30003 tejbeer 218
                        #else
31665 amit.gupta 219
                            #set($pendingIndentAcc = 0)
220
                            #set($pendingIndentTv = 0)
221
                        #end
30003 tejbeer 222
 
35490 ranu 223
                        #if($pendingIndentQtyAccessTv.get($cr.getKey()))
224
                            #set($pendingIndentAccQty = $pendingIndentQtyAccessTv.get($cr.getKey()).getAccessoriesQty())
225
                            #set($pendingIndentTvQty = $pendingIndentQtyAccessTv.get($cr.getKey()).getTvQty())
226
                        #else
227
                            #set($pendingIndentAccQty = 0)
228
                            #set($pendingIndentTvQty = 0)
229
                        #end
30003 tejbeer 230
 
35490 ranu 231
 
31665 amit.gupta 232
                        #if($grnPendingAccessTvOrders.get($cr.getKey()))
233
                            #set($grnPendingAcc = $grnPendingAccessTvOrders.get($cr.getKey()).getAccessoriesAmount())
234
                            #set($grnPendingTv = $grnPendingAccessTvOrders.get($cr.getKey()).getTvAmount())
235
                        #else
236
                            #set($grnPendingAcc = 0)
237
                            #set($grnPendingTv = 0)
238
                        #end
30003 tejbeer 239
 
35490 ranu 240
                        #if($grnPendingQtyAccessTvOrders.get($cr.getKey()))
241
                            #set($grnPendingAccQty = $grnPendingQtyAccessTvOrders.get($cr.getKey()).getAccessoriesQty())
242
                            #set($grnPendingTvQty = $grnPendingQtyAccessTvOrders.get($cr.getKey()).getTvQty())
243
                        #else
244
                            #set($grnPendingAccQty = 0)
245
                            #set($grnPendingTvQty = 0)
246
                        #end
30003 tejbeer 247
 
35490 ranu 248
 
31665 amit.gupta 249
                        #set($totalAccStock = $inStockAcc+ $pendingIndentAcc + $grnPendingAcc)
30003 tejbeer 250
 
31665 amit.gupta 251
                        #set($totalTvStock = $inStockTv+ $pendingIndentTv + $grnPendingTv)
252
 
35490 ranu 253
                        #set($totalAccStockQty = $inStockAccQty+ $pendingIndentAccQty + $grnPendingAccQty)
31665 amit.gupta 254
 
35490 ranu 255
                        #set($totalTvStockQty = $inStockTvQty+ $pendingIndentTvQty + $grnPendingTvQty)
256
 
257
 
31665 amit.gupta 258
                        #if($brandAmountLimit.get("accessories") != 0)
36614 aman 259
                            #set($stockAccPercent = ($totalAccStock / $brandAmountLimit.get("accessories"))*100)
31665 amit.gupta 260
                        #else
261
                            #set($stockAccPercent = 100)
262
                        #end
263
 
264
 
36614 aman 265
                        #if($stockAccPercent > 90)
31665 amit.gupta 266
                            <td class="currency brandStock" style="background-color:#52BE80" data-fofoid="$cr.getKey()"
267
                                data-brand="accessories" data-toggle="modal"
35490 ranu 268
                                data-target="#itemWiseBrandStock">$totalAccStockQty</td>
36614 aman 269
                        #elseif($stockAccPercent < 80)
31665 amit.gupta 270
                            <td class="currency brandStock" style="background-color:#EC7063 " data-fofoid="$cr.getKey()"
271
                                data-brand="accessories" data-toggle="modal"
35490 ranu 272
                                data-target="#itemWiseBrandStock"> $totalAccStockQty</td>
31665 amit.gupta 273
                        #else
274
                            <td class="currency brandStock" style="background-color:#F7DC6F" data-fofoid="$cr.getKey()"
275
                                data-brand="accessories" data-toggle="modal"
35490 ranu 276
                                data-target="#itemWiseBrandStock">$totalAccStockQty</td>
31665 amit.gupta 277
                        #end
278
 
279
 
280
 
281
                        #if($brandAmountLimit.get("TV") != 0)
36614 aman 282
                            #set($stockTVPercent = ($totalTvStock / $brandAmountLimit.get("TV"))*100)
31665 amit.gupta 283
                        #else
284
                            #set($stockTVPercent = 100)
285
                        #end
286
 
287
 
36614 aman 288
                        #if($stockTVPercent > 90)
31665 amit.gupta 289
                            <td class="currency brandStock" style="background-color:#52BE80" data-fofoid="$cr.getKey()"
35490 ranu 290
                                data-brand="TV" data-toggle="modal"
291
                                data-target="#itemWiseBrandStock">$totalTvStockQty</td>
36614 aman 292
                        #elseif($stockTVPercent < 80)
31665 amit.gupta 293
                            <td class="currency brandStock" style="background-color:#EC7063 " data-fofoid="$cr.getKey()"
294
                                data-brand="TV" data-toggle="modal"
35490 ranu 295
                                data-target="#itemWiseBrandStock"> $totalTvStockQty</td>
31665 amit.gupta 296
                        #else
297
                            <td class="currency brandStock" style="background-color:#F7DC6F" data-fofoid="$cr.getKey()"
298
                                data-brand="TV" data-toggle="modal"
35490 ranu 299
                                data-target="#itemWiseBrandStock"> $totalTvStockQty</td>
31665 amit.gupta 300
                        #end
301
 
33806 tejus.loha 302
                        <td>
31665 amit.gupta 303
 
33806 tejus.loha 304
 
305
                            <div style="display:flex">
306
                                #if($partnerActivationType.get($cr.getKey()) && $canChangeActivationType)
307
                                <select class="form-control input-sm" id="activationType" name="activationType"
308
                                        placeholder="Activation Type">
309
 
310
 
311
                                    #foreach($activationType in $activationTypes)
312
 
313
                                        #if($activationType == $partnerActivationType.get($cr.getKey())))
314
 
315
                                            <option value="$partnerActivationType.get($cr.getKey())"
316
                                                    selected>$partnerActivationType.get($cr.getKey())</option>
317
                                        #else
318
                                            <option value="$activationType">$activationType</option>
319
                                        #end
320
                                    #end
321
                                #else
322
                                    $partnerActivationType.get($cr.getKey())
323
                                #end
324
                            </div>
325
                            </select>
326
 
327
 
328
                        </td>
31665 amit.gupta 329
                    </tr>
330
                    #end
331
 
332
                </tbody>
333
            </table>
334
 
335
 
336
            <div id="itemWiseBrandStock" class="modal" role="dialog">
34437 ranu 337
                <div class="modal-dialog modal-lg" style="min-width:95%;">
31665 amit.gupta 338
                    <div class="modal-content">
339
 
340
                    </div>
341
                </div>
342
            </div>
343
 
34449 ranu 344
            <div id="poItemsDetail" class="modal" role="dialog">
345
                <div class="modal-dialog modal-sm">
346
                    <div class="modal-content" style="margin-top: 40%;">
347
 
348
                    </div>
349
                </div>
350
            </div>
351
 
31665 amit.gupta 352
</section>
353
 
354
 
30003 tejbeer 355
<script type="text/javascript">
31665 amit.gupta 356
    var editor;
30003 tejbeer 357
 
31665 amit.gupta 358
    $(document).ready(function () {
30003 tejbeer 359
 
31665 amit.gupta 360
        $('#partnerBrandWiseDetail').DataTable({
361
            "bPaginate": true,
362
            "bLengthChange": true,
363
            "bFilter": true,
364
            "bInfo": false,
365
            "bAutoWidth": false,
366
            "scrollX": true,
35490 ranu 367
            "lengthMenu": [[10, 25, 50, 100, 1000, -1], [10, 25, 50, 100, 1000, "All"]],
368
 
36614 aman 369
// This sets the default page length when the table first loads
35490 ranu 370
            "pageLength": 100
31665 amit.gupta 371
        });
372
    });
30003 tejbeer 373
 
31665 amit.gupta 374
    $('#partnerBrandWiseDetail').on('click', '.brandStock', function () {
375
        var fofoId = $(this).data('fofoid');
376
        var brand = $(this).data('brand');
30003 tejbeer 377
 
34397 ranu 378
        var $row = $(this).closest('tr');
30046 tejbeer 379
 
35839 ranu 380
        var shortInvest = $row.find('.shortInvestment-mk').val().trim();
35011 ranu 381
        var totalDueWithInterest = $row.find('.totaldue-with-interest-mk').val().trim();
36614 aman 382
// var shortInvest = 0;
34401 ranu 383
 
34397 ranu 384
        console.log(shortInvest)
30046 tejbeer 385
 
35014 ranu 386
        doGetAjaxRequestHandler(context + "/getPartnerShortageStock?brand=" + brand + "&fofoId=" + fofoId + "&shortInvest=" + shortInvest + "&totalDueWithInterest=" + totalDueWithInterest, function (response) {
34397 ranu 387
 
31665 amit.gupta 388
            $('#itemWiseBrandStock .modal-content').html(response);
34398 ranu 389
            getPartnerShortageStockDetail(fofoId, brand);
30046 tejbeer 390
 
31665 amit.gupta 391
        });
392
    });
393
 
394
 
34088 ranu 395
    function getPartnerShortageStockDetail(fofoId, brand) {
396
        console.log("fdwfdw");
397
        doGetAjaxRequestHandler(
398
                context + "/getPartnerShortageStockDetail?brand=" + brand + "&fofoId="
34398 ranu 399
                + fofoId, function (response) {
34088 ranu 400
 
401
                    $('#itemWiseBrandStockDetail').html(response);
402
 
403
                });
404
    }
405
 
406
 
34389 ranu 407
</script>