Rev 15435 | Blame | Compare with Previous | Last modification | View Log | RSS feed
#set ($itemDetail = $action.fetchItemDetail())#set ($mpDetail = $action.fetchMarketplaceDetail())<style>* { font-family: Verdana; font-size: 96%; }label {float: left;}#upload > table {color: #747474;width: 100%;}#upload tbody {background: url("/Support/images/center-bcg.png") repeat-y scroll right top #F6F6F6;font-weight: bold;}.mpUpload > table {color: #747474;width: 100%;}.mpUpload tbody {background: url("/Support/images/center-bcg.png") repeat-y scroll right top #F6F6F6;font-weight: bold;}.detail {background: url("/Support/images/center-blue.png") repeat-y scroll left top #E4EBF8;border-bottom: 1px solid #B3C1DB;border-right: 1px solid #CED9EC;color: #1F3D71;height: 25px;padding: 10px 0 0 24px;}.value {border-bottom: 1px solid #B3C1DB;border-right: 1px solid #CED9EC;height: 24px;text-align: center;color: #747474;}select {padding-top: 2px;vertical-align: middle;direction: ltr;font-weight: bold;width: 50%;height: 22px;}input {font-size: 12px;text-align: center;width: 50%;font-weight: bold;}.top-header {background-color: #2789C1;display: block;height: 27px;width: 100%;}input[type="text"][readonly] {background-color: #D1D1D1;}input[type="text"][disabled] {background-color: #D1D1D1;}.border-highlight{border : 3px solid #00BFFF;}.border-highlight-green{border : 3px solid green;}.border-highlight-red{border : 3px solid red;}</style><link href="/Support/css/jquery.alerts.css" type="text/css" rel="stylesheet"><script type="text/javascript" src="/Support/js/jquery-1.4.2.js"></script><script type="text/javascript" src="/Support/js/jquery.alerts.js"></script><script type="text/javascript">$(document).ready(function() {$('#cancelbutton').click(function(e) {window.location.href = '/Support/flipkart-list';});});</script><script type="text/javascript">$('select').change(function(){var optionValue = $(this).val();var selectType = parseInt($(this).attr('selectType'));switch(selectType){case 1:if (optionValue=='True'){$(this).removeClass().addClass('border-highlight-red');}else{$(this).removeClass();}break;case 2:if (optionValue=='False'){$(this).removeClass().addClass('border-highlight-red');}else{$(this).removeClass();}break;case 3:if (optionValue=='True'){$(this).removeClass().addClass('border-highlight-green');}else{$(this).removeClass();}break;}});</script><script type="text/javascript">function calculateStuff(){$('input#minPosTp').removeClass();$('input#minPosSp').removeClass();$('input#transferPrice').removeClass();$('input#serviceTax').removeClass();$('input#commission').removeClass();$('input#margin').removeClass();$('input#marginPer').removeClass();var itemWeight=$('#itemWeight').val();itemWeight = +itemWeight+.05;if (itemWeight==0){var courierCost =64;}else{var slabs = parseInt((parseFloat(itemWeight)-.001)/.5)var courierCost = 64;for (var i=0;i<slabs;i++){courierCost = courierCost + 34;}}var sellingPrice=$('#sellingPrice').val();var nlc=$('#maxNlc').val();var otherCost=$('#otherCost').val();var othCost=parseFloat(otherCost);if ( sellingPrice==null || sellingPrice=="" || isNaN(sellingPrice) || nlc==null || nlc=="" || isNaN(nlc)){$('input#courierCost').val('0.00');$('input#commission').val('0.00');$('input#serviceTax').val('0.00');$('input#transferPrice').val('0.00');$('input#minPosTp').val('0.00');$('input#minPosSp').val('0.00');}else{var com=$('#commissionRate').val();var comRate=com/100;var serviceTaxRate=$('#serviceTaxRate').val();var stRate = serviceTaxRate/100;var emiFeeRate=$('#emiFee').val();var emiFee=emiFeeRate/100;var closingFee=parseFloat($('#closingFee').val());var returnProvision=parseFloat($('#returnProvision').val());var margin=$('#margin').val();var vatRate=$('#vat').val();var vat=vatRate/100;var commisionPrice=((comRate)*sellingPrice).toFixed(2);var ourTp=(parseFloat(sellingPrice)-parseFloat(sellingPrice)*(1+stRate)*((comRate)+emiFee)-((courierCost+closingFee)*(1+stRate)));var vatValue=(((sellingPrice/(1+vat))-(nlc/(1+vat)))*vat).toFixed(2);var inHouseCost=(+vatValue+15+((returnProvision/100)*sellingPrice)+othCost);console.log(inHouseCost);var lowestTp=(+nlc+inHouseCost).toFixed(2);var lowestSp=(+nlc+(courierCost+closingFee)*(1+stRate)*(1+vat)+(15+othCost)*(1+vat))/(1-(comRate+emiFee)*(1+stRate)*(1+vat)-(returnProvision/100)*(1+vat));ourTp = (parseFloat(ourTp)).toFixed(2);$('input#minPosTp').val(lowestTp);$('input#minPosSp').val(parseFloat(lowestSp).toFixed(2));$('input#transferPrice').val(ourTp);var serviceTax=(stRate*(+commisionPrice+courierCost)).toFixed(2);lowest_possible_tp=parseFloat(lowestTp);newMargin=(ourTp-lowest_possible_tp).toFixed(2);marginPercentage=(((ourTp-lowest_possible_tp)/sellingPrice)*100).toFixed(2);$('input#marginPer').val(marginPercentage);$('input#margin').val(newMargin);$('input#sellingPrice').val(sellingPrice);$('input#courierCost').val(courierCost);$('input#commission').val(commisionPrice);$('input#serviceTax').val(serviceTax);$('input#minPosTp').addClass("border-highlight");$('input#minPosSp').addClass("border-highlight");$('input#transferPrice').addClass("border-highlight");$('input#serviceTax').addClass("border-highlight");$('input#commission').addClass("border-highlight");$('input#margin').addClass("border-highlight");$('input#marginPer').addClass("border-highlight");if (ourTp-lowest_possible_tp < 0){$('input#margin').removeClass().addClass("border-highlight-red");$('input#marginPer').addClass("border-highlight-red");}}}</script><script type="text/javascript">$('#getMxNlc').live('click', function(){var itemId=$('#itemId').val();var warehouseId=$('#warehouseId').val();var sellingPrice=$('#sellingPrice').val();if ( warehouseId==null || warehouseId=="" || isNaN(warehouseId)){jAlert('Please enter valid warehouse id', 'ERROR');return false;}if (sellingPrice==0 || sellingPrice=="" || isNaN(sellingPrice)){jAlert('Illegal Entry In Selling Price', 'ERROR');return false;}jQuery.ajax({type : "GET",url : "/Support/flipkart-list!ke$ha?itemId="+itemId+"&warehouseId="+warehouseId+"&sellingPrice="+sellingPrice,beforeSend: function(){$('#ajax-spinner').show();},complete: function(){$('#ajax-spinner').hide();},success : function(json){var parsedData = JSON.parse(json);$('input#maxNlc').val(parsedData.MaxNlc);$('input#vat').val(parsedData.VatRate);calculateStuff();},error : function() {$('input#warehouseId').val('');$('input#maxNlc').val('');alert("Unable to get max nlc possibly wrong warehouse");},});return false;});</script><script type="text/javascript">$(".top-header").click(function(){$(".product-detail").slideToggle("slow");});</script><script type="text/javascript">$(".top-header-inventory").click(function(){$(".inventory-details").slideToggle("slow");});</script><script type="text/javascript">$(".top-header-marketplace").click(function(){$(".mp-detail").slideToggle("slow");});</script><!--Product details--><div class="top-header"><h2 style="font-weight: bolder; font-size: 20px; border-top: 4px solid rgb(134, 163, 189); background-color: rgb(134, 163, 189);color:white;">Product Details</h2></div><div class="product-detail" style="display: block; min-height: 730px;"><form id="snapdeal-form" action="/Support/flipkart-list!update" enctype="multipart/form-data" method="post"><div class="left" style="float: left; width: 48%;"><table id="upload" style="text-align: center;width: 100%;height:200px;"><thead></thead><tbody><tr><td class="detail">Item Id</td><td class="value"><input id="itemId" name="itemId" value='$itemDetail.getItem_id()'type="text" readonly/></td></tr><tr><td class="detail">Warehouse Id</td><td class="value"><input id="warehouseId" name="warehouseId" value='$itemDetail.getWarehouseId()' style="width:25%; type="text" /><input type="button" id="getMxNlc" value="Get Max Nlc" style="width:25%;"></td></tr><tr><td class="detail">Max NLC</td><td class="value"><input id="maxNlc" name="maxNlc" value='$itemDetail.getMaxNlc()'type="text" readonly/></td></tr><tr><td class="detail">Weight</td><td class="value"><input id="weight" name="weight" value='$itemDetail.getWeight()' type="text" readonly/></td></tr><tr><td class="detail">Flipkart Selling Price</td><td class="value"><input id="sellingPrice" name="sellingPrice" value='$mpDetail.getCurrentSp()'type="text" onkeyup="calculateStuff()"></td></tr><tr><td class="detail">Transfer Price</td><td class="value"><input id="transferPrice" name="transferPrice" value='$mpDetail.getCurrentTp()'type="text" readonly/></td></tr><tr><td class="detail">Webiste MRP</td><td class="value"><input id="webisteMrp" name="webisteMrp" value='$itemDetail.getMrp()'type="text" disabled/></td></tr><tr><td class="detail">Webiste Selling Price</td><td class="value"><input id="webisteSellingPrice" name="webisteSellingPrice" value='$itemDetail.getWebsiteSellingPrice()'type="text" disabled/></td></tr><tr><td class="detail">Other Cost</td><td class="value"><input id="otherCost" name="otherCost" value='$mpDetail.getOtherCost()' type="text" onkeyup="calculateStuff()"</td></tr><tr><td class="detail">Minimum Possible SP (Calculated)</td><td class="value"><input id="minPosSp" name="minPosSp" value='$mpDetail.getMinimumPossibleSp()'type="text" readonly/></td></tr><tr><td class="detail">Minimum Possible TP (Calculated)</td><td class="value"><input id="minPosTp" name="minPosTp" value='$mpDetail.getMinimumPossibleTp()' type="text" readonly/></td></tr><tr><td class="detail">Last Updated SP</td><td class="value"><input id="currentSp" name="currentSp" value='$mpDetail.getCurrentSp()' type="text" readonly/></td></tr><tr><td class="detail">Last Updated TP</td><td class="value"><input id="currentTp" name="currentTp" value='$mpDetail.getCurrentTp()'type="text" readonly/></td></tr>#set ($margin = $mpDetail.getCurrentTp() - $mpDetail.getMinimumPossibleTp())#if ($margin < 0)#set ($cls = 'border-highlight-red')#else#set ($cls='')#end<tr><td class="detail">Margin</td><td class="value"><input id="margin" name="margin" class='$cls' value='$action.getRoundOfValue("$margin")'type="text" style="width:20%;" disabled/>#if($mpDetail.getCurrentSp()==0)#set ($marginPercentage = 0)#else#set ($marginPercentage = ($margin/$mpDetail.getCurrentSp()*100))#end#set($roundMarginPer = $action.getRoundOfValue("$marginPercentage"))<span style="font-weight:bold;color:black;">Margin %</span><input id="marginPer" class='$cls' name="marginPer" value='$roundMarginPer' type="text" style="width:20%;" disabled/></td></tr><tr><td class="detail">Last Updated Inventory</td><td class="value"><input id="lastUpdatedInventory" name="lastUpdatedInventory" value='$itemDetail.getLastUpdatedInventory()' type="text" disabled></td></tr><tr><td class="detail">Last Updated Inventory TimeStamp</td>#if ($itemDetail.getLastUpdatedInventoryTimestamp()==0)<td class="value"><input id="lastUpdatedInventoryTimestamp" name="lastUpdatedInventoryTimestamp" value='Not Available' type="text" disabled/></td>#else<td class="value"><input id="lastUpdatedInventoryTimestamp" name="lastUpdatedInventoryTimestamp" value='$action.getLastUpdatedInventoryTimestamp()' type="text" disabled/></td>#end</tr><tr><td class="detail">Last Updated Price Timestamp</td>#if ($mpDetail.getLastCheckedTimestamp()==0)<td class="value"><input id="lastCheckedPriceTimestamp" name="lastCheckedPriceTimestamp" value='Not Available' type="text" disabled/></td>#else<td class="value"><input id="lastCheckedPriceTimestamp" name="lastCheckedPriceTimestamp" value='$action.getLastCheckedTimestamp()' type="text" disabled/></td>#end</tr><tr><td class="detail">Maximum Selling Price</td><td class="value"><input id="maxSp" name="maxSp" value='$mpDetail.getMaximumSellingPrice()' type="text"></td></tr><tr><td class="detail">Last N Day Sale</td>#set($nDaySale=$action.getLastNDaySaleForItem("$itemDetail.getItem_id()","5"))<td class="value"><input id="lastNDaySale" name="lastNDaySale" value='$action.getnDaySale()' type="text" disabled/></td></tr></tbody></table></div><div class="left" style="float: right; width: 48%;"><table id="upload" style="text-align: center;width: 100%;height:200px;"><thead></thead><tbody><tr><td class="detail">Average Sale</td><td class="value"><input id="avgSale" name="avgSale" value='$action.getAvgSale()' type="text" disabled/></td></tr><tr><td class="detail">Suppress Pricing Feed</td><td class="value">#if ($itemDetail.isSuppressPriceFeed())<select name="isSuppressPriceFeed" selectType="1" class="border-highlight-red"><option selected="selected" value="True">Active</option><option value="False">InActive</option></select>#else<select name="isSuppressPriceFeed" selectType="1"><option selected="selected" value="False">InActive</option><option value="True">Active</option></select>#end</td></tr><tr><td class="detail">Suppress Inventory Feed</td><td class="value">#if ($itemDetail.isSuppressInventoryFeed())<select name="isSuppressInventoryFeed" selectType="1" class="border-highlight-red"><option selected="selected" value="True">Active</option><option value="False">InActive</option></select>#else<select name="isSuppressInventoryFeed" selectType="1"><option selected="selected" value="False">InActive</option><option value="True">Active</option></select>#end</td></tr><tr><td class="detail">Flipkart Listed</td><td class="value">#if ($itemDetail.isIsListedOnFlipkart())<select name="isListedOnFlipkart" selectType="2"><option selected="selected" value="True">Active</option><option value="False">InActive</option></select>#else<select name="isListedOnFlipkart" selectType="2" class="border-highlight-red"><option selected="selected" value="False">InActive</option><option value="True">Active</option></select>#end</td></tr><tr><td class="detail">Flipkart FA Listed</td><td class="value">#if ($itemDetail.isIsFaListed())<select name="isFaListedOnFlipkart" selectType="2"><option selected="selected" value="True">Active</option><option value="False">InActive</option></select>#else<select name="isFaListedOnFlipkart" selectType="2" class="border-highlight-red"><option selected="selected" value="False">InActive</option><option value="True">Active</option></select>#end</td></tr><tr><td class="detail">Auto Increment</td><td class="value">#if ($mpDetail.isAutoIncrement())<select name="isAutoIncrement" selectType="3" class="border-highlight-green"><option selected="selected" value="True">Active</option><option value="False">InActive</option></select>#else<select name="isAutoIncrement" selectType="3"><option selected="selected" value="False">InActive</option><option value="True">Active</option></select>#end</td></tr><tr><td class="detail">Auto Decrement</td><td class="value">#if ($mpDetail.isAutoDecrement())<select name="isAutoDecrement" selectType="3" class="border-highlight-green"><option selected="selected" value="True">Active</option><option value="False">InActive</option></select>#else<select name="isAutoDecrement" selectType="3"><option selected="selected" value="False">InActive</option><option value="True">Active</option></select>#end</td></tr><tr><td class="detail">Auto Favourite</td><td class="value">#if ($mpDetail.isAutoFavourite())<select name="isAutoFavourite" class="border-highlight-green"><option selected="selected" value="True">Active</option></select>#else<select name="isAutoFavourite"><option selected="selected" value="False">InActive</option></select>#end</td></tr><tr><td class="detail">Manual Favourite</td><td class="value">#if ($mpDetail.isManualFavourite())<select name="isManualFavourite" selectType="3" class="border-highlight-green"><option selected="selected" value="True">Active</option><option value="False">InActive</option></select>#else<select name="isManualFavourite" selectType="3"><option selected="selected" value="False">InActive</option><option value="True">Active</option></select>#end</td></tr><tr><td class="detail">Commission %</td><td class="value"><input id="commissionRate" name="commissionRate" value='$mpDetail.getCommission()'type="text" disabled/></td></tr><tr><td class="detail">Exception Price</td><td class="value"><input id="exceptionPrice" name="exceptionPrice" value='$itemDetail.getExceptionPrice()'type="text"/></td></tr><tr><td class="detail">Commission</td><td class="value"><input id="commission" name="commission" value='$itemDetail.getCommission()'type="text" readonly/></td></tr><tr><td class="detail">Return Provision</td><td class="value"><input id="returnProvision" name="returnProvision" value='$mpDetail.getReturnProvision()' type="text" disabled/></td></tr><tr><td class="detail">Service Tax</td><td class="value"><input id="serviceTax" name="serviceTax" value='$itemDetail.getServiceTax()'type="text" readonly/></td></tr><tr><td class="detail">Courier Cost</td><td class="value"><input id="courierCost" name="courierCost" value='$mpDetail.getCourierCost()'type="text" readonly/></td></tr><tr><td class="detail">VAT %</td><td class="value"><input id="vat" name="vat" value='$mpDetail.getVat()' type="text" onkeyup="calculateStuff()"></td></tr><tr><td class="detail">Item Id @ Flipkart</td>#if($itemDetail.getSkuAtFlipkart())<td class="value"><input id="fkItemCode" name="fkItemCode" value='$itemDetail.getSkuAtFlipkart()' type="text"></td>#else<td class="value"><input id="fkItemCode" name="fkItemCode" value='' type="text"></td>#end</tr><tr><td class="detail">Flipkart Serial Number</td>#if($itemDetail.getFlipkartSerialNumber())<td class="value"><input id="fkSerialNumber" name="fkSerialNumber" value='$itemDetail.getFlipkartSerialNumber()' type="text"></td>#else<td class="value"><input id="fkSerialNumber" name="fkSerialNumber" value='' type="text"></td>#end</tr><tr><td class="detail">Action</td><td class="value"><input type="submit" value="Update" name="upload" style="width: 25%;"><input type="button" style="padding-left: 5px; margin-left: 10px;width: 25%;" id="cancelbutton" name="cancel" value="Cancel"></td></tr><tr class="detail" style="display:none;"></td><td><input id="itemWeight" name="itemWeight" value='$itemDetail.getWeight()' type="text"/></td></tr><tr class="detail" style="display:none;"></td><td><input id="emiFee" name="emiFee" value='$mpDetail.getEmiFee()' type="text" disabled/></td></tr><tr class="detail" style="display:none;"></td><td><input id="closingFee" name="closingFee" value='$mpDetail.getClosingFee()' type="text" disabled/></td></tr><tr class="detail" style="display:none;"></td><td><input id="serviceTaxRate" name="serviceTaxRate" value='$mpDetail.getServiceTax()' type="text" disabled/></td></tr></tbody></table></div></form></div><!--product details end--><!--Inventory details --><div class="top-header-inventory"><h2 style="font-weight: bolder; font-size: 20px; border-top: 4px solid rgb(134, 163, 189); background-color: rgb(134, 163, 189);color:white;">Inventory Details</h2></div><div class="inventory-details"><table id="inventory-info" style="width: 100%"><thead><tr><th>Id</th><th>Warehouse Desc</th><th>Warehouse Location</th><th>Warehouse Type</th><th>Inventory Type</th><th>Availability</th><th>Reserved</th><th>Ebay Held</th><th>Snapdeal Held</th><th>Flipkart Held</th></tr></thead><tbody>#set($itemInventory = $action.getItemInventory("$itemDetail.getItem_id()"))#set($availability = $itemInventory.getAvailability())#set($reserved = $itemInventory.getReserved())#set($held = $itemInventory.getHeld())#foreach( $keyAvailable in $availability.keySet() )#if($keyAvailable!=16)<tr style="border: 1px">#set($whObj = $action.getWarehouse("$keyAvailable","$itemDetail.getItem_id()"))#set($holdInventoryMap = $action.getHoldInventoryMapForItem())#set($warehouseCheck="False")#if ($whObj.getWarehouseType()=="OURS" && $whObj.getInventoryType()=="GOOD")#set($warehouseCheck="True")#end#set($index = $whObj.getLocation().lastIndexOf(","))#set($index = $index+1)<td style="text-align:center;width:5%;">$keyAvailable</td><td style="text-align:center;width:10%;">$whObj.getDisplayName()</td><td style="text-align:center;width:10%;">$whObj.getLocation().substring($index)</td><td style="text-align:center;width:10%;">$whObj.getWarehouseType()</td><td style="text-align:center;width:8%;">$whObj.getInventoryType()</td><td style="text-align:center;width:8%;">$availability.get($keyAvailable)</td><td style="text-align:center;width:8%;">$reserved.get($keyAvailable)</td><td style="text-align:center;width:8%;">#if($$holdInventoryMap.get(6))$holdInventoryMap.get(6)#{else}0#end</td><td style="text-align:center;width:8%;">#if($$holdInventoryMap.get(7))$holdInventoryMap.get(7)#{else}0#end</td><td style="text-align:center;">#if ($warehouseCheck=="True")<input id="heldInventory_$keyAvailable" name="heldInventory" value='#if($holdInventoryMap.get(8))$holdInventoryMap.get(8)#{else}0#end' type="text" style="width:20%;"/><input type="button" class="changeHeld" value="Update" warehouse_id="$keyAvailable" item_id="$itemDetail.getItem_id()" style="width:20%;margin-left:10px;">#else<input id="heldInventory_$keyAvailable" name="heldInventory" value='#if($holdInventoryMap.get(8))$holdInventoryMap.get(8)#{else}0#end' type="text" style="width:20%;" readonly/><input type="button" value="Update" style="width:20%;margin-left:10px;" disabled/>#end</td></tr>#end#end</tbody></table></div>