Subversion Repositories SmartDukaan

Rev

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