Rev 35838 | Blame | Compare with Previous | Last modification | View Log | RSS feed
<style>.brandStock .tooltiptext {visibility: hidden;width: 120px;background-color: black;color: #fff;text-align: center;border-radius: 6px;padding: 5px 0;/* Position the tooltip */position: absolute;z-index: 1;}.brandStock:hover .tooltiptext {visibility: visible;}</style><section class="wrapper"><div class="row"><div class="col-lg-12"><h3 class="page-header"><i class="icon_document_alt"></i>BRAND WISE PLACEMENT</h3><ol class="breadcrumb"><li><i class="fa fa-home"></i><a href="${rc.contextPath}/dashboard">Home</a></li><li><i class="icon_document_alt"></i>BrandWise Placement</li></ol></div></div><div class="row"><div class="col-lg-12"><table id="partnerBrandWiseDetail" class="table table-striped table-advance table-hover" style="width:100%"><thead><tr><th>Partner Name</th><th>Code</th><th>Category</th><th>Manager</th><th>Wallet Amount</th><th>Short Invest</th><th>Min Invest</th><th>Total Due</th><th>Monthly target</th><th>MTD Purchase</th><th>MTD Sale</th>#foreach($brand in $brands)<th class="$brand.toLowerCase()"><p>$brand</p></th>#end<th>Accessories</th><th>TV</th><th>Activation Type</th></tr></thead><tbody>#foreach($cr in $customRetailers.entrySet())<tr><td class="brandStock" data-fofoid="$cr.getKey()" data-toggle="modal"data-target="#itemWiseBrandStock">$cr.getValue().getBusinessName()</td><td>$cr.getValue().getCode()</td><td>$fofoIdPartnerTypeMap.get($cr.getKey())<input type="hidden" class="shortInvestment-mk"value="$partnerDailyInvestmentMap.get($cr.getKey()).getShortInvestment().longValue()">#if($totalDueMap.get($cr.getKey()).longValue())<input type="hidden" class="totaldue-with-interest-mk"value="$totalDueMap.get($cr.getKey()).longValue()">#else<input type="hidden" class="totaldue-with-interest-mk" value="0">#end</td><td>$partnerSalesHeadersMap.get($cr.getKey()).getTerritoryManager()</td><td class="currency">$partnerDailyInvestmentMap.get($cr.getKey()).getWalletAmount()</td>#set($realInvestment = $partnerDailyInvestmentMap.get($cr.getKey()).getTotalInvestment() + $partnerDailyInvestmentMap.get($cr.getKey()).getShortInvestment() )#set($realpercent = ($partnerDailyInvestmentMap.get($cr.getKey()).getTotalInvestment() / $realInvestment)*100)#if($realpercent < 75)<td class="currency"style="color:red">$partnerDailyInvestmentMap.get($cr.getKey()).getShortInvestment()</td>#else<td class="currency">$partnerDailyInvestmentMap.get($cr.getKey()).getShortInvestment()</td>#end<td class="currency">$partnerDailyInvestmentMap.get($cr.getKey()).getMinInvestment()</td>#if($totalDueMap.get($cr.getKey())>0)<td class="currency">$totalDueMap.get($cr.getKey()).setScale(0,$ru)</td>#else<td class="currency">--</td>#end#if($fofoIdMonthlyTargetMap.get($cr.getKey()).getPurchaseTarget())<td class="currency">$nf.format($fofoIdMonthlyTargetMap.get($cr.getKey()).getPurchaseTarget())</td>#else<td class="currency">--</td>#end#set($isOverSale = $fofoMTDSaleMap.get($cr.getKey())>$currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))#set($salePurchaseGap = $fofoMTDSaleMap.get($cr.getKey())-$currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))#if($currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))#if($isOverSale)#if($salePurchaseGap>50000)<td class="currency"><span style="color:red">$nf.format($currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))</span></td>#else<td class="currency"><span style="color:darkorange">$nf.format($currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))</span></td>#end#else<td>$nf.format($currentMonthTillDateRetailerPOValueMap.get($cr.getKey()))</td>#end#else<td class="currency">--</td>#end#if($fofoMTDSaleMap.get($cr.getKey()))#if($isOverSale)#if($salePurchaseGap>50000)<td class="currency"><span style="color:red">$nf.format($fofoMTDSaleMap.get($cr.getKey()))</span></td>#else<td class="currency"><span style="color:darkorange">$nf.format($fofoMTDSaleMap.get($cr.getKey()))</span></td>#end#else<td class="currency">$nf.format($fofoMTDSaleMap.get($cr.getKey()))</td>#end#else<td class="currency">--</td>#end#foreach($brand in $brands)#set($totalStock = $fofoIdBrandAmountMap.get($cr.getKey()).get($brand))#set($totalStockQty = $fofoIdBrandQtyMap.get($cr.getKey()).get($brand))#set($minBrandAmount = 0.0)#set($stockPercent = 100)#if($partnerBrandLimitMap.get($cr.getKey()))#if($partnerBrandLimitMap.get($cr.getKey()).get($brand))#set($minBrandAmount = $partnerBrandLimitMap.get($cr.getKey()).get($brand))#set($stockPercent = ($totalStock / $minBrandAmount)*100)#end#end#if($brand == "Nokia" || $brand == "Xiaomi" || $brand == "Realme")<td class="currency brandStock" data-fofoid="$cr.getKey()" data-brand="$brand"data-toggle="modal" data-target="#itemWiseBrandStock">$totalStockQty <spanclass="tooltiptext">$minBrandAmount</span></td>#else#if($stockPercent > 90)<td class="currency brandStock" style="background-color:#52BE80"data-stock="$inStockBrandModel.get($cr.getKey()).get($brand)"data-pending="$pendingIndent.get($cr.getKey()).get($brand)"data-grn="$grnPendingOrders.get($cr.getKey()).get($brand)"data-fofoid="$cr.getKey()" data-brand="$brand" data-toggle="modal"data-target="#itemWiseBrandStock">$totalStockQty <spanclass="tooltiptext">$minBrandAmount</span></td>#elseif($stockPercent < 80)<td class="currency brandStock" style="background-color:#EC7063 "data-stock="$inStockBrandModel.get($cr.getKey()).get($brand)"data-pending="$pendingIndent.get($cr.getKey()).get($brand)"data-grn="$grnPendingOrders.get($cr.getKey()).get($brand)"data-fofoid="$cr.getKey()" data-brand="$brand" data-toggle="modal"data-target="#itemWiseBrandStock"> $totalStockQty <spanclass="tooltiptext">$minBrandAmount</span></td>#else<td class="currency brandStock" style="background-color:#F7DC6F"data-stock="$inStockBrandModel.get($cr.getKey()).get($brand)"data-pending="$pendingIndent.get($cr.getKey()).get($brand)"data-grn="$grnPendingOrders.get($cr.getKey()).get($brand)"data-fofoid="$cr.getKey()" data-brand="$brand" data-toggle="modal"data-target="#itemWiseBrandStock">$totalStockQty <spanclass="tooltiptext">$minBrandAmount</span></td>#end#end#end#if($inStockAccessTv.get($cr.getKey()))#set($inStockAcc = $inStockAccessTv.get($cr.getKey()).getAccessoriesAmount())#set($inStockTv = $inStockAccessTv.get($cr.getKey()).getTvAmount())#else#set($inStockAcc = 0)#set($inStockTv = 0)#end#if($inStockQtyAccessTv.get($cr.getKey()))#set($inStockAccQty = $inStockQtyAccessTv.get($cr.getKey()).getAccessoriesQty())#set($inStockTvQty = $inStockQtyAccessTv.get($cr.getKey()).getTvQty())#else#set($inStockAccQty = 0)#set($inStockTvQty = 0)#end#if($pendingIndentAccessTv.get($cr.getKey()))#set($pendingIndentAcc = $pendingIndentAccessTv.get($cr.getKey()).getAccessoriesAmount())#set($pendingIndentTv = $pendingIndentAccessTv.get($cr.getKey()).getTvAmount())#else#set($pendingIndentAcc = 0)#set($pendingIndentTv = 0)#end#if($pendingIndentQtyAccessTv.get($cr.getKey()))#set($pendingIndentAccQty = $pendingIndentQtyAccessTv.get($cr.getKey()).getAccessoriesQty())#set($pendingIndentTvQty = $pendingIndentQtyAccessTv.get($cr.getKey()).getTvQty())#else#set($pendingIndentAccQty = 0)#set($pendingIndentTvQty = 0)#end#if($grnPendingAccessTvOrders.get($cr.getKey()))#set($grnPendingAcc = $grnPendingAccessTvOrders.get($cr.getKey()).getAccessoriesAmount())#set($grnPendingTv = $grnPendingAccessTvOrders.get($cr.getKey()).getTvAmount())#else#set($grnPendingAcc = 0)#set($grnPendingTv = 0)#end#if($grnPendingQtyAccessTvOrders.get($cr.getKey()))#set($grnPendingAccQty = $grnPendingQtyAccessTvOrders.get($cr.getKey()).getAccessoriesQty())#set($grnPendingTvQty = $grnPendingQtyAccessTvOrders.get($cr.getKey()).getTvQty())#else#set($grnPendingAccQty = 0)#set($grnPendingTvQty = 0)#end#set($totalAccStock = $inStockAcc+ $pendingIndentAcc + $grnPendingAcc)#set($totalTvStock = $inStockTv+ $pendingIndentTv + $grnPendingTv)#set($totalAccStockQty = $inStockAccQty+ $pendingIndentAccQty + $grnPendingAccQty)#set($totalTvStockQty = $inStockTvQty+ $pendingIndentTvQty + $grnPendingTvQty)#if($brandAmountLimit.get("accessories") != 0)#set($stockAccPercent = ($totalAccStock / $brandAmountLimit.get("accessories"))*100)#else#set($stockAccPercent = 100)#end#if($stockAccPercent > 90)<td class="currency brandStock" style="background-color:#52BE80" data-fofoid="$cr.getKey()"data-brand="accessories" data-toggle="modal"data-target="#itemWiseBrandStock">$totalAccStockQty</td>#elseif($stockAccPercent < 80)<td class="currency brandStock" style="background-color:#EC7063 " data-fofoid="$cr.getKey()"data-brand="accessories" data-toggle="modal"data-target="#itemWiseBrandStock"> $totalAccStockQty</td>#else<td class="currency brandStock" style="background-color:#F7DC6F" data-fofoid="$cr.getKey()"data-brand="accessories" data-toggle="modal"data-target="#itemWiseBrandStock">$totalAccStockQty</td>#end#if($brandAmountLimit.get("TV") != 0)#set($stockTVPercent = ($totalTvStock / $brandAmountLimit.get("TV"))*100)#else#set($stockTVPercent = 100)#end#if($stockTVPercent > 90)<td class="currency brandStock" style="background-color:#52BE80" data-fofoid="$cr.getKey()"data-brand="TV" data-toggle="modal"data-target="#itemWiseBrandStock">$totalTvStockQty</td>#elseif($stockTVPercent < 80)<td class="currency brandStock" style="background-color:#EC7063 " data-fofoid="$cr.getKey()"data-brand="TV" data-toggle="modal"data-target="#itemWiseBrandStock"> $totalTvStockQty</td>#else<td class="currency brandStock" style="background-color:#F7DC6F" data-fofoid="$cr.getKey()"data-brand="TV" data-toggle="modal"data-target="#itemWiseBrandStock"> $totalTvStockQty</td>#end<td><div style="display:flex">#if($partnerActivationType.get($cr.getKey()) && $canChangeActivationType)<select class="form-control input-sm" id="activationType" name="activationType"placeholder="Activation Type">#foreach($activationType in $activationTypes)#if($activationType == $partnerActivationType.get($cr.getKey())))<option value="$partnerActivationType.get($cr.getKey())"selected>$partnerActivationType.get($cr.getKey())</option>#else<option value="$activationType">$activationType</option>#end#end#else$partnerActivationType.get($cr.getKey())#end</div></select></td></tr>#end</tbody></table><div id="itemWiseBrandStock" class="modal" role="dialog"><div class="modal-dialog modal-lg" style="min-width:95%;"><div class="modal-content"></div></div></div><div id="poItemsDetail" class="modal" role="dialog"><div class="modal-dialog modal-sm"><div class="modal-content" style="margin-top: 40%;"></div></div></div></section><script type="text/javascript">var editor;$(document).ready(function () {$('#partnerBrandWiseDetail').DataTable({"bPaginate": true,"bLengthChange": true,"bFilter": true,"bInfo": false,"bAutoWidth": false,"scrollX": true,"lengthMenu": [[10, 25, 50, 100, 1000, -1], [10, 25, 50, 100, 1000, "All"]],// This sets the default page length when the table first loads"pageLength": 100});});$('#partnerBrandWiseDetail').on('click', '.brandStock', function () {var fofoId = $(this).data('fofoid');var brand = $(this).data('brand');var $row = $(this).closest('tr');var shortInvest = $row.find('.shortInvestment-mk').val().trim();var totalDueWithInterest = $row.find('.totaldue-with-interest-mk').val().trim();// var shortInvest = 0;console.log(shortInvest)doGetAjaxRequestHandler(context + "/getPartnerShortageStock?brand=" + brand + "&fofoId=" + fofoId + "&shortInvest=" + shortInvest + "&totalDueWithInterest=" + totalDueWithInterest, function (response) {$('#itemWiseBrandStock .modal-content').html(response);getPartnerShortageStockDetail(fofoId, brand);});});function getPartnerShortageStockDetail(fofoId, brand) {console.log("fdwfdw");doGetAjaxRequestHandler(context + "/getPartnerShortageStockDetail?brand=" + brand + "&fofoId="+ fofoId, function (response) {$('#itemWiseBrandStockDetail').html(response);});}</script>