| Line 59... |
Line 59... |
| 59 |
|
59 |
|
| 60 |
</thead>
|
60 |
</thead>
|
| 61 |
<tbody>
|
61 |
<tbody>
|
| 62 |
|
62 |
|
| 63 |
#foreach($cr in $customRetailers.entrySet())
|
63 |
#foreach($cr in $customRetailers.entrySet())
|
| - |
|
64 |
#set($pdi = $partnerDailyInvestmentMap.get($cr.getKey()))
|
| 64 |
<tr>
|
65 |
<tr>
|
| 65 |
<td class="brandStock" data-fofoid="$cr.getKey()" data-toggle="modal"
|
66 |
<td class="brandStock" data-fofoid="$cr.getKey()" data-toggle="modal"
|
| 66 |
data-target="#itemWiseBrandStock">$cr.getValue().getBusinessName()</td>
|
67 |
data-target="#itemWiseBrandStock">$cr.getValue().getBusinessName()</td>
|
| 67 |
<td>$cr.getValue().getCode()</td>
|
68 |
<td>$cr.getValue().getCode()</td>
|
| 68 |
|
69 |
|
| 69 |
<td>$fofoIdPartnerTypeMap.get($cr.getKey())
|
70 |
<td>$fofoIdPartnerTypeMap.get($cr.getKey())
|
| - |
|
71 |
#if($pdi)
|
| 70 |
<input type="hidden" class="shortInvestment-mk"
|
72 |
<input type="hidden" class="shortInvestment-mk"
|
| 71 |
value="$partnerDailyInvestmentMap.get($cr.getKey()).getShortInvestment().longValue()">
|
73 |
value="$pdi.getShortInvestment().longValue()">
|
| - |
|
74 |
#else
|
| - |
|
75 |
<input type="hidden" class="shortInvestment-mk" value="0">
|
| - |
|
76 |
#end
|
| 72 |
#if($totalDueMap.get($cr.getKey()).longValue())
|
77 |
#if($totalDueMap.get($cr.getKey()).longValue())
|
| 73 |
<input type="hidden" class="totaldue-with-interest-mk"
|
78 |
<input type="hidden" class="totaldue-with-interest-mk"
|
| 74 |
value="$totalDueMap.get($cr.getKey()).longValue()">
|
79 |
value="$totalDueMap.get($cr.getKey()).longValue()">
|
| 75 |
#else
|
80 |
#else
|
| 76 |
<input type="hidden" class="totaldue-with-interest-mk" value="0">
|
81 |
<input type="hidden" class="totaldue-with-interest-mk" value="0">
|
| 77 |
#end
|
82 |
#end
|
| 78 |
|
83 |
|
| 79 |
</td>
|
84 |
</td>
|
| 80 |
<td>$partnerSalesHeadersMap.get($cr.getKey()).getTerritoryManager()</td>
|
85 |
<td>$partnerSalesHeadersMap.get($cr.getKey()).getTerritoryManager()</td>
|
| 81 |
|
86 |
|
| 82 |
<td class="currency">$partnerDailyInvestmentMap.get($cr.getKey()).getWalletAmount()</td>
|
87 |
#if($pdi)
|
| 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)
|
88 |
<td class="currency">$pdi.getWalletAmount()</td>
|
| 89 |
|
- |
|
| 90 |
|
89 |
|
| - |
|
90 |
#set($realInvestment = $pdi.getTotalInvestment() + $pdi.getShortInvestment())
|
| - |
|
91 |
#set($realpercent = ($pdi.getTotalInvestment() / $realInvestment)*100)
|
| 91 |
|
92 |
|
| 92 |
#if($realpercent < 75)
|
93 |
#if($realpercent < 75)
|
| - |
|
94 |
<td class="currency" style="color:red">$pdi.getShortInvestment()</td>
|
| 93 |
<td class="currency"
|
95 |
#else
|
| 94 |
style="color:red">$partnerDailyInvestmentMap.get($cr.getKey()).getShortInvestment()</td>
|
96 |
<td class="currency">$pdi.getShortInvestment()</td>
|
| - |
|
97 |
#end
|
| - |
|
98 |
<td class="currency">$pdi.getMinInvestment()</td>
|
| 95 |
#else
|
99 |
#else
|
| - |
|
100 |
<td class="currency">--</td>
|
| - |
|
101 |
<td class="currency">--</td>
|
| 96 |
<td class="currency">$partnerDailyInvestmentMap.get($cr.getKey()).getShortInvestment()</td>
|
102 |
<td class="currency">--</td>
|
| 97 |
#end
|
103 |
#end
|
| 98 |
<td class="currency">$partnerDailyInvestmentMap.get($cr.getKey()).getMinInvestment()</td>
|
- |
|
| 99 |
|
104 |
|
| 100 |
#if($totalDueMap.get($cr.getKey())>0)
|
105 |
#if($totalDueMap.get($cr.getKey())>0)
|
| 101 |
<td class="currency">$totalDueMap.get($cr.getKey()).setScale(0,$ru)</td>
|
106 |
<td class="currency">$totalDueMap.get($cr.getKey()).setScale(0,$ru)</td>
|
| 102 |
#else
|
107 |
#else
|
| 103 |
<td class="currency">--</td>
|
108 |
<td class="currency">--</td>
|
| 104 |
#end
|
109 |
#end
|
| 105 |
|
110 |
|
| 106 |
#if($fofoIdMonthlyTargetMap.get($cr.getKey()).getPurchaseTarget())
|
111 |
#if($fofoIdMonthlyTargetMap.get($cr.getKey()).getPurchaseTarget())
|
| 107 |
<td class="currency">$nf.format($fofoIdMonthlyTargetMap.get($cr.getKey()).getPurchaseTarget())</td>
|
112 |
<td class="currency">$fofoIdMonthlyTargetMap.get($cr.getKey()).getPurchaseTarget()</td>
|
| 108 |
#else
|
113 |
#else
|
| 109 |
<td class="currency">--</td>
|
114 |
<td class="currency">--</td>
|
| 110 |
#end
|
115 |
#end
|
| 111 |
|
116 |
|
| 112 |
#set($isOverSale = $fofoMTDSaleMap.get($cr.getKey())>$currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))
|
117 |
#set($isOverSale = $fofoMTDSaleMap.get($cr.getKey())>$currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))
|
| 113 |
#set($salePurchaseGap = $fofoMTDSaleMap.get($cr.getKey())-$currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))
|
118 |
#set($salePurchaseGap = $fofoMTDSaleMap.get($cr.getKey())-$currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))
|
| 114 |
|
119 |
|
| 115 |
#if($currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))
|
120 |
#if($currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))
|
| 116 |
#if($isOverSale)
|
121 |
#if($isOverSale)
|
| 117 |
#if($salePurchaseGap>50000)
|
122 |
#if($salePurchaseGap>50000)
|
| 118 |
<td class="currency">
|
123 |
<td class="currency"
|
| 119 |
<span style="color:red">$nf.format($currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))</span>
|
124 |
style="color:red">$currentMonthTillDateRetailerPOValueMap.get($cr.getKey())</td>
|
| 120 |
</td>
|
- |
|
| 121 |
#else
|
125 |
#else
|
| 122 |
<td class="currency">
|
126 |
<td class="currency"
|
| 123 |
<span style="color:darkorange">$nf.format($currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))</span>
|
127 |
style="color:darkorange">$currentMonthTillDateRetailerPOValueMap.get($cr.getKey())</td>
|
| 124 |
</td>
|
- |
|
| 125 |
#end
|
128 |
#end
|
| 126 |
#else
|
129 |
#else
|
| 127 |
<td>
|
- |
|
| 128 |
$nf.format($currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))
|
130 |
<td class="currency">$currentMonthTillDateRetailerPOValueMap.get($cr.getKey())</td>
|
| 129 |
</td>
|
- |
|
| 130 |
#end
|
131 |
#end
|
| 131 |
#else
|
132 |
#else
|
| 132 |
<td class="currency">--</td>
|
133 |
<td class="currency">--</td>
|
| 133 |
#end
|
134 |
#end
|
| 134 |
|
135 |
|
| 135 |
#if($fofoMTDSaleMap.get($cr.getKey()))
|
136 |
#if($fofoMTDSaleMap.get($cr.getKey()))
|
| 136 |
#if($isOverSale)
|
137 |
#if($isOverSale)
|
| 137 |
#if($salePurchaseGap>50000)
|
138 |
#if($salePurchaseGap>50000)
|
| 138 |
<td class="currency">
|
- |
|
| 139 |
<span style="color:red">$nf.format($fofoMTDSaleMap.get($cr.getKey()))</span>
|
139 |
<td class="currency" style="color:red">$fofoMTDSaleMap.get($cr.getKey())</td>
|
| 140 |
</td>
|
- |
|
| 141 |
#else
|
140 |
#else
|
| 142 |
<td class="currency">
|
- |
|
| 143 |
<span style="color:darkorange">$nf.format($fofoMTDSaleMap.get($cr.getKey()))</span>
|
141 |
<td class="currency" style="color:darkorange">$fofoMTDSaleMap.get($cr.getKey())</td>
|
| 144 |
</td>
|
- |
|
| 145 |
#end
|
142 |
#end
|
| 146 |
#else
|
143 |
#else
|
| 147 |
<td class="currency">
|
- |
|
| 148 |
$nf.format($fofoMTDSaleMap.get($cr.getKey()))
|
144 |
<td class="currency">$fofoMTDSaleMap.get($cr.getKey())</td>
|
| 149 |
</td>
|
- |
|
| 150 |
#end
|
145 |
#end
|
| 151 |
#else
|
146 |
#else
|
| 152 |
<td class="currency">--</td>
|
147 |
<td class="currency">--</td>
|
| 153 |
#end
|
148 |
#end
|
| 154 |
|
149 |
|
| 155 |
#foreach($brand in $brands)
|
150 |
#foreach($brand in $brands)
|
| 156 |
#set($totalStock = $fofoIdBrandAmountMap.get($cr.getKey()).get($brand))
|
151 |
#set($totalStock = $fofoIdBrandAmountMap.get($cr.getKey()).get($brand))
|
| 157 |
#set($totalStockQty = $fofoIdBrandQtyMap.get($cr.getKey()).get($brand))
|
152 |
#set($totalStockQty = $decimalFormatter.format($fofoIdBrandQtyMap.get($cr.getKey()).get($brand)))
|
| 158 |
#set($minBrandAmount = 0.0)
|
153 |
#set($minBrandAmount = 0.0)
|
| 159 |
#set($stockPercent = 100)
|
154 |
#set($stockPercent = 100)
|
| 160 |
|
155 |
|
| 161 |
#if($partnerBrandLimitMap.get($cr.getKey()))
|
156 |
#if($partnerBrandLimitMap.get($cr.getKey()))
|
| 162 |
#if($partnerBrandLimitMap.get($cr.getKey()).get($brand))
|
157 |
#if($partnerBrandLimitMap.get($cr.getKey()).get($brand))
|
| 163 |
#set($minBrandAmount = $partnerBrandLimitMap.get($cr.getKey()).get($brand))
|
158 |
#set($minBrandAmount = $partnerBrandLimitMap.get($cr.getKey()).get($brand))
|
| 164 |
#set($stockPercent = ($totalStock / $minBrandAmount)*100)
|
159 |
#set($stockPercent = ($totalStock / $minBrandAmount)*100)
|
| 165 |
#end
|
160 |
#end
|
| 166 |
#end
|
161 |
#end
|
| 167 |
|
162 |
|
| 168 |
#if($brand == "Nokia" || $brand == "Xiaomi" || $brand == "Realme")
|
163 |
#if($brand == "Nokia" || $brand == "Xiaomi" || $brand == "Realme")
|
| 169 |
<td class="currency brandStock" data-fofoid="$cr.getKey()" data-brand="$brand"
|
164 |
<td class="currency brandStock" data-fofoid="$cr.getKey()" data-brand="$brand"
|
| 170 |
data-toggle="modal" data-target="#itemWiseBrandStock">$totalStockQty <span
|
165 |
data-toggle="modal" data-target="#itemWiseBrandStock">$totalStockQty <span
|
| 171 |
class="tooltiptext">$minBrandAmount</span></td>
|
166 |
class="tooltiptext">$minBrandAmount</span></td>
|
| 172 |
#else
|
167 |
#else
|
| 173 |
#if($stockPercent > 90)
|
168 |
#if($stockPercent > 90)
|
| 174 |
<td class="currency brandStock" style="background-color:#52BE80"
|
169 |
<td class="currency brandStock" style="background-color:#52BE80"
|
| 175 |
data-stock="$inStockBrandModel.get($cr.getKey()).get($brand)"
|
170 |
data-stock="$inStockBrandModel.get($cr.getKey()).get($brand)"
|
| 176 |
data-pending="$pendingIndent.get($cr.getKey()).get($brand)"
|
171 |
data-pending="$pendingIndent.get($cr.getKey()).get($brand)"
|
| 177 |
data-grn="$grnPendingOrders.get($cr.getKey()).get($brand)"
|
172 |
data-grn="$grnPendingOrders.get($cr.getKey()).get($brand)"
|
| 178 |
data-fofoid="$cr.getKey()" data-brand="$brand" data-toggle="modal"
|
173 |
data-fofoid="$cr.getKey()" data-brand="$brand" data-toggle="modal"
|
| 179 |
data-target="#itemWiseBrandStock">$totalStockQty <span
|
174 |
data-target="#itemWiseBrandStock">$totalStockQty <span
|
| 180 |
class="tooltiptext">$minBrandAmount</span></td>
|
175 |
class="tooltiptext">$minBrandAmount</span></td>
|
| 181 |
#elseif($stockPercent < 80)
|
176 |
#elseif($stockPercent < 80)
|
| 182 |
<td class="currency brandStock" style="background-color:#EC7063 "
|
177 |
<td class="currency brandStock" style="background-color:#EC7063 "
|
| 183 |
data-stock="$inStockBrandModel.get($cr.getKey()).get($brand)"
|
178 |
data-stock="$inStockBrandModel.get($cr.getKey()).get($brand)"
|
| 184 |
data-pending="$pendingIndent.get($cr.getKey()).get($brand)"
|
179 |
data-pending="$pendingIndent.get($cr.getKey()).get($brand)"
|
| 185 |
data-grn="$grnPendingOrders.get($cr.getKey()).get($brand)"
|
180 |
data-grn="$grnPendingOrders.get($cr.getKey()).get($brand)"
|
| 186 |
data-fofoid="$cr.getKey()" data-brand="$brand" data-toggle="modal"
|
181 |
data-fofoid="$cr.getKey()" data-brand="$brand" data-toggle="modal"
|
| Line 259... |
Line 254... |
| 259 |
|
254 |
|
| 260 |
#set($totalTvStockQty = $inStockTvQty+ $pendingIndentTvQty + $grnPendingTvQty)
|
255 |
#set($totalTvStockQty = $inStockTvQty+ $pendingIndentTvQty + $grnPendingTvQty)
|
| 261 |
|
256 |
|
| 262 |
|
257 |
|
| 263 |
#if($brandAmountLimit.get("accessories") != 0)
|
258 |
#if($brandAmountLimit.get("accessories") != 0)
|
| 264 |
#set($stockAccPercent = ($totalAccStock / $brandAmountLimit.get("accessories"))*100)
|
259 |
#set($stockAccPercent = ($totalAccStock / $brandAmountLimit.get("accessories"))*100)
|
| 265 |
#else
|
260 |
#else
|
| 266 |
#set($stockAccPercent = 100)
|
261 |
#set($stockAccPercent = 100)
|
| 267 |
#end
|
262 |
#end
|
| 268 |
|
263 |
|
| 269 |
|
264 |
|
| 270 |
#if($stockAccPercent > 90)
|
265 |
#if($stockAccPercent > 90)
|
| 271 |
<td class="currency brandStock" style="background-color:#52BE80" data-fofoid="$cr.getKey()"
|
266 |
<td class="currency brandStock" style="background-color:#52BE80" data-fofoid="$cr.getKey()"
|
| 272 |
data-brand="accessories" data-toggle="modal"
|
267 |
data-brand="accessories" data-toggle="modal"
|
| 273 |
data-target="#itemWiseBrandStock">$totalAccStockQty</td>
|
268 |
data-target="#itemWiseBrandStock">$totalAccStockQty</td>
|
| 274 |
#elseif($stockAccPercent < 80)
|
269 |
#elseif($stockAccPercent < 80)
|
| 275 |
<td class="currency brandStock" style="background-color:#EC7063 " data-fofoid="$cr.getKey()"
|
270 |
<td class="currency brandStock" style="background-color:#EC7063 " data-fofoid="$cr.getKey()"
|
| 276 |
data-brand="accessories" data-toggle="modal"
|
271 |
data-brand="accessories" data-toggle="modal"
|
| 277 |
data-target="#itemWiseBrandStock"> $totalAccStockQty</td>
|
272 |
data-target="#itemWiseBrandStock"> $totalAccStockQty</td>
|
| 278 |
#else
|
273 |
#else
|
| 279 |
<td class="currency brandStock" style="background-color:#F7DC6F" data-fofoid="$cr.getKey()"
|
274 |
<td class="currency brandStock" style="background-color:#F7DC6F" data-fofoid="$cr.getKey()"
|
| Line 282... |
Line 277... |
| 282 |
#end
|
277 |
#end
|
| 283 |
|
278 |
|
| 284 |
|
279 |
|
| 285 |
|
280 |
|
| 286 |
#if($brandAmountLimit.get("TV") != 0)
|
281 |
#if($brandAmountLimit.get("TV") != 0)
|
| 287 |
#set($stockTVPercent = ($totalTvStock / $brandAmountLimit.get("TV"))*100)
|
282 |
#set($stockTVPercent = ($totalTvStock / $brandAmountLimit.get("TV"))*100)
|
| 288 |
#else
|
283 |
#else
|
| 289 |
#set($stockTVPercent = 100)
|
284 |
#set($stockTVPercent = 100)
|
| 290 |
#end
|
285 |
#end
|
| 291 |
|
286 |
|
| 292 |
|
287 |
|
| 293 |
#if($stockTVPercent > 90)
|
288 |
#if($stockTVPercent > 90)
|
| 294 |
<td class="currency brandStock" style="background-color:#52BE80" data-fofoid="$cr.getKey()"
|
289 |
<td class="currency brandStock" style="background-color:#52BE80" data-fofoid="$cr.getKey()"
|
| 295 |
data-brand="TV" data-toggle="modal"
|
290 |
data-brand="TV" data-toggle="modal"
|
| 296 |
data-target="#itemWiseBrandStock">$totalTvStockQty</td>
|
291 |
data-target="#itemWiseBrandStock">$totalTvStockQty</td>
|
| 297 |
#elseif($stockTVPercent < 80)
|
292 |
#elseif($stockTVPercent < 80)
|
| 298 |
<td class="currency brandStock" style="background-color:#EC7063 " data-fofoid="$cr.getKey()"
|
293 |
<td class="currency brandStock" style="background-color:#EC7063 " data-fofoid="$cr.getKey()"
|
| 299 |
data-brand="TV" data-toggle="modal"
|
294 |
data-brand="TV" data-toggle="modal"
|
| 300 |
data-target="#itemWiseBrandStock"> $totalTvStockQty</td>
|
295 |
data-target="#itemWiseBrandStock"> $totalTvStockQty</td>
|
| 301 |
#else
|
296 |
#else
|
| 302 |
<td class="currency brandStock" style="background-color:#F7DC6F" data-fofoid="$cr.getKey()"
|
297 |
<td class="currency brandStock" style="background-color:#F7DC6F" data-fofoid="$cr.getKey()"
|
| Line 369... |
Line 364... |
| 369 |
"bInfo": false,
|
364 |
"bInfo": false,
|
| 370 |
"bAutoWidth": false,
|
365 |
"bAutoWidth": false,
|
| 371 |
"scrollX": true,
|
366 |
"scrollX": true,
|
| 372 |
"lengthMenu": [[10, 25, 50, 100, 1000, -1], [10, 25, 50, 100, 1000, "All"]],
|
367 |
"lengthMenu": [[10, 25, 50, 100, 1000, -1], [10, 25, 50, 100, 1000, "All"]],
|
| 373 |
|
368 |
|
| 374 |
// This sets the default page length when the table first loads
|
369 |
// This sets the default page length when the table first loads
|
| 375 |
"pageLength": 100
|
370 |
"pageLength": 100
|
| 376 |
});
|
371 |
});
|
| 377 |
});
|
372 |
});
|
| 378 |
|
373 |
|
| 379 |
$('#partnerBrandWiseDetail').on('click', '.brandStock', function () {
|
374 |
$('#partnerBrandWiseDetail').on('click', '.brandStock', function () {
|
| Line 382... |
Line 377... |
| 382 |
|
377 |
|
| 383 |
var $row = $(this).closest('tr');
|
378 |
var $row = $(this).closest('tr');
|
| 384 |
|
379 |
|
| 385 |
var shortInvest = $row.find('.shortInvestment-mk').val().trim();
|
380 |
var shortInvest = $row.find('.shortInvestment-mk').val().trim();
|
| 386 |
var totalDueWithInterest = $row.find('.totaldue-with-interest-mk').val().trim();
|
381 |
var totalDueWithInterest = $row.find('.totaldue-with-interest-mk').val().trim();
|
| 387 |
// var shortInvest = 0;
|
382 |
// var shortInvest = 0;
|
| 388 |
|
383 |
|
| 389 |
console.log(shortInvest)
|
384 |
console.log(shortInvest)
|
| 390 |
|
385 |
|
| 391 |
doGetAjaxRequestHandler(context + "/getPartnerShortageStock?brand=" + brand + "&fofoId=" + fofoId + "&shortInvest=" + shortInvest + "&totalDueWithInterest=" + totalDueWithInterest, function (response) {
|
386 |
doGetAjaxRequestHandler(context + "/getPartnerShortageStock?brand=" + brand + "&fofoId=" + fofoId + "&shortInvest=" + shortInvest + "&totalDueWithInterest=" + totalDueWithInterest, function (response) {
|
| 392 |
|
387 |
|
| Line 408... |
Line 403... |
| 408 |
});
|
403 |
});
|
| 409 |
}
|
404 |
}
|
| 410 |
|
405 |
|
| 411 |
|
406 |
|
| 412 |
</script>
|
407 |
</script>
|
| 413 |
|
- |
|