Rev 14780 | Blame | Compare with Previous | Last modification | View Log | RSS feed
<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;}.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: 20px;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/snapdeal-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("border-highlight");$('input#minPosSp').removeClass("border-highlight");$('input#transferPrice').removeClass("border-highlight");$('input#serviceTax').removeClass("border-highlight");$('input#commission').removeClass("border-highlight");$('input#margin').removeClass();$('input#marginPer').removeClass();var itemWeight=$('#itemWeight').val();itemWeight = +itemWeight+.05;console.log(itemWeight);var packagingCost=$('#packagingCost').val();if (itemWeight==0){var courierCost =45;}else{var slabs = parseInt((parseFloat(itemWeight)-.001)/.5)var courierCost = 45;for (var i=0;i<slabs;i++){courierCost = courierCost + 35;}}console.log(courierCost);//courierCost = ((courierCost+0)*1.1236).toFixed(2);var courierCostSnapdeal=$('#courierCostMarketplace').val();var sellingPrice=$('#sellingPrice').val();var nlc=$('#maxNlc').val();var otherCost=$('#otherCost').val();var othCost=parseFloat(otherCost);var pc=parseFloat(packagingCost);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#').val('0.00');}else{var serviceTaxRate=$('#serviceTaxRate').val();console.log(serviceTaxRate)var stRate = serviceTaxRate/100;var com=$('#commissionRate').val();var comRate=(com/100);console.log(comRate);var pgVal=$('#pgFee').val();var pgFeeRate=pgVal/100;console.log(pgVal);var emiFeeRate=$('#emiFee').val();console.log(emiFeeRate);var emiFee=emiFeeRate/100;var closingFee=parseFloat($('#closingFee').val());var returnProvision=parseFloat($('#returnProvision').val());console.log(returnProvision);console.log(closingFee);console.log(pgFeeRate);var margin=$('#margin').val();var vatRate=$('#vat').val();if ( vatRate==null || vatRate=="" || isNaN(vatRate)){jAlert('Please enter VAT Rate for item','ERROR');$('input#sellingPrice').val('0.00');return false;}var vat=vatRate/100;if (pgFeeRate*parseFloat(sellingPrice)>=20){var commisionPrice=((comRate+pgFeeRate)*parseFloat(sellingPrice)).toFixed(2);}else{var commisionPrice=(comRate*parseFloat(sellingPrice)+20).toFixed(2);console.log("Default pg fee block");}console.log(+courierCostSnapdeal);var ourTp=(parseFloat(sellingPrice)-parseFloat(sellingPrice)*(1+stRate)*((comRate)+emiFee)-((+courierCostSnapdeal+closingFee)*(1+stRate))-(Math.max(20,pgFeeRate*parseFloat(sellingPrice))*(1+stRate)));var vatValue=(((sellingPrice/(1+vat))-(nlc/(1+vat)))*vat).toFixed(2);var inHouseCost=(+vatValue+pc+((returnProvision/100)*sellingPrice)+othCost);var lowestTp=(+nlc+inHouseCost).toFixed(2);if (pgFeeRate*parseFloat(sellingPrice)>=20){var lowestSp=(+nlc+(+courierCostSnapdeal+closingFee)*(1+stRate)*(1+vat)+(pc+othCost)*(1+vat))/(1-(comRate+emiFee+pgFeeRate)*(1+stRate)*(1+vat)-(returnProvision/100)*(1+vat));}else{var lowestSp=(+nlc+(+courierCostSnapdeal+closingFee+20)*(1+stRate)*(1+vat)+(pc+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+(+courierCostSnapdeal))).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");}}calculateStuffVOI();}</script><script type="text/javascript">function calculateStuffVOI(){$('input#minPosTpVoi').removeClass("border-highlight");$('input#minPosSpVoi').removeClass("border-highlight");$('input#transferPriceVOI').removeClass("border-highlight");$('input#serviceTaxVOI').removeClass("border-highlight");$('input#commissionVoi').removeClass("border-highlight");$('input#marginVOI').removeClass();$('input#marginPerVOI').removeClass();var itemWeight=$('#itemWeight').val();itemWeight = +itemWeight+.05;console.log(itemWeight);var packagingCost=$('#packagingCost').val();if (itemWeight==0){var courierCost =40;}else{var slabs = parseInt((parseFloat(itemWeight)-.001)/.5)var courierCost = 40;for (var i=0;i<slabs;i++){courierCost = courierCost + 30;}}console.log(courierCost);//courierCost = ((courierCost+0)*1.1236).toFixed(2);var voiSellingPrice=$('#voiSellingPrice').val();var courierCostSnapdeal=$('#courierCostMarketplaceVoi').val();var nlc=$('#maxNlc').val();var otherCost=$('#otherCost').val();var othCost=parseFloat(otherCost);var pc=parseFloat(packagingCost);if ( voiSellingPrice==null || voiSellingPrice=="" || isNaN(voiSellingPrice) || nlc==null || nlc=="" || isNaN(nlc)){$('input#courierCostVoi').val('0.00');$('input#serviceTaxVoi').val('0.00');$('input#commissionVoi').val('0.00');}else{var serviceTaxRate=$('#serviceTaxRate').val();console.log(serviceTaxRate)var stRate = serviceTaxRate/100;var com=$('#commissionRateVoi').val();var comRate=(com/100);console.log(comRate);var pgVal=$('#pgFee').val();var pgFeeRate=pgVal/100;console.log(pgVal);var emiFeeRate=$('#emiFee').val();console.log(emiFeeRate);var emiFee=emiFeeRate/100;var closingFee=parseFloat($('#closingFee').val());var returnProvision=parseFloat($('#returnProvision').val());console.log(returnProvision);console.log(closingFee);console.log(pgFeeRate);console.log(courierCostSnapdeal);var margin=$('#margin').val();var vatRate=$('#vat').val();if ( vatRate==null || vatRate=="" || isNaN(vatRate)){jAlert('Please enter VAT Rate for item','ERROR');$('input#voiSellingPrice').val('0.00');return false;}var vat=vatRate/100;if (pgFeeRate*parseFloat(voiSellingPrice)>=20){var commisionPrice=((comRate+pgFeeRate)*parseFloat(voiSellingPrice)).toFixed(2);}else{var commisionPrice=(comRate*parseFloat(voiSellingPrice)+20).toFixed(2);console.log("Default pg fee block");}console.log(+courierCost);var ourTp=(parseFloat(voiSellingPrice)-parseFloat(voiSellingPrice)*(1+stRate)*((comRate)+emiFee)-((+courierCostSnapdeal+closingFee)*(1+stRate))-(Math.max(20,pgFeeRate*parseFloat(voiSellingPrice))*(1+stRate)));var vatValue=(((voiSellingPrice/(1+vat))-(nlc/(1+vat)))*vat).toFixed(2);var inHouseCost=(+vatValue+pc+((returnProvision/100)*voiSellingPrice)+othCost);var lowestTp=(+nlc+inHouseCost).toFixed(2);if (pgFeeRate*parseFloat(voiSellingPrice)>=20){var lowestSp=(+nlc+(+courierCostSnapdeal+closingFee)*(1+stRate)*(1+vat)+(pc+othCost)*(1+vat))/(1-(comRate+emiFee+pgFeeRate)*(1+stRate)*(1+vat)-(returnProvision/100)*(1+vat));}else{var lowestSp=(+nlc+(+courierCostSnapdeal+closingFee+20)*(1+stRate)*(1+vat)+(pc+othCost)*(1+vat))/(1-(comRate+emiFee)*(1+stRate)*(1+vat)-(returnProvision/100)*(1+vat));}ourTp = (parseFloat(ourTp)).toFixed(2);$('input#minPosTpVoi').val(lowestTp);$('input#minPosSpVoi').val(parseFloat(lowestSp).toFixed(2));$('input#transferPriceVOI').val(ourTp);var serviceTax=(stRate*(+commisionPrice+(+courierCostSnapdeal))).toFixed(2);lowest_possible_tp=parseFloat(lowestTp);newMargin=(ourTp-lowest_possible_tp).toFixed(2);marginPercentage=(((ourTp-lowest_possible_tp)/voiSellingPrice)*100).toFixed(2);$('input#marginPerVOI').val(marginPercentage);$('input#marginVOI').val(newMargin);$('input#voiSellingPrice').val(voiSellingPrice);$('input#courierCostVoi').val(courierCost);$('input#commissionVoi').val(commisionPrice);$('input#serviceTaxVOI').val(serviceTax);$('input#minPosTpVoi').addClass("border-highlight");$('input#minPosSpVoi').addClass("border-highlight");$('input#transferPriceVOI').addClass("border-highlight");$('input#serviceTaxVOI').addClass("border-highlight");$('input#commissionVoi').addClass("border-highlight");$('input#marginVOI').addClass("border-highlight");$('input#marginPerVOI').addClass("border-highlight");if (ourTp-lowest_possible_tp < 0){$('input#marginVOI').removeClass().addClass("border-highlight-red");$('input#marginPerVOI').addClass("border-highlight-red");}}}</script><script type="text/javascript">$('#populateStuff').live('click', function(){var itemId=$('#itemId').val();var whId=$('#warehouseId').val();var sellingPrice=$('#sellingPrice').val();if ( whId==null || whId=="" || isNaN(whId)){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/snapdeal-list!getItemDetailsInJson?itemId="+itemId+"&warehouseId="+whId+"&sellingPrice="+sellingPrice,beforeSend: function(){$('#ajax-spinner').show();$('#add-new-item')[0].reset();},complete: function(){$('#ajax-spinner').hide();},success : function(json){var parsedData = JSON.parse(json);$('input#itemId').val(parsedData.ItemId);$('input#brand').val(parsedData.Brand);$('input#modelNumber').val(parsedData.ModelNumber);$('input#modelName').val(parsedData.ModelName);$('input#color').val(parsedData.Color);$('input#itemWeight').val(parsedData.Weight);$('input#risky').val(parsedData.Risky);$('input#status').val(parsedData.Status);$('input#webisteMrp').val(parsedData.MRP);$('input#webisteSellingPrice').val(parsedData.SellingPrice);$('input#maxSp').val(0);$('input#commissionRate').val(parsedData.CommissionRate);$('input#returnProvision').val(parsedData.ReturnProvision);$('input#emiFee').val(parsedData.EmiFee);$('input#closingFee').val(parsedData.ClosingFee);$('input#serviceTaxRate').val(parsedData.ServiceTaxRate);$('input#sellingPrice').val(sellingPrice);$('input#voiSellingPrice').val(sellingPrice);$('input#transferPrice').val('0.0');$('input#transferPriceVOI').val('0.0');$('input#exceptionPrice').val('0.0');$('input#commission').val('0.0');$('input#serviceTax').val('0.0');$('input#serviceTaxVOI').val('0.0');$('input#courierCost').val('0.0');$('input#courierCostVoi').val('0.0');$('input#maxNlc').val(parsedData.MaxNlc);$('input#warehouseId').val(whId);$('input#vat').val(parsedData.VatRate);$('input#pgFee').val(parsedData.PgFee);$('input#packagingCost').val(parsedData.PackagingCost);calculateStuff();},error : function() {alert("Either item id is already present in snapdeal item or not a valid item Id");},});return false;});</script><div class="top-header"><span style="float: left; padding-left: 10px; padding-top: 2px; font-size: 14px; font-weight: bolder; color: white;">ADD NEW PRODUCT</span></div><form id="add-new-item" action="/Support/snapdeal-list!addNewItem" 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=''type="text" style="width:25%;"><input type="button" id="populateStuff" value="Populate" style="width:25%;"></td></tr><tr><td class="detail">Brand</td><td class="value"><input id="brand" name="brand" value='' type="text" readonly/></td></tr><tr><td class="detail">Model Number</td><td class="value"><input id="modelNumber" name="modelNumber" value='' type="text" disabled/></td></tr><tr><td class="detail">Model Name</td><td class="value"><input id="modelName" name="modelName" value='' type="text" disabled/></td></tr><tr><td class="detail">Color</td><td class="value"><input id="color" name="color" value='' type="text" disabled/></td></tr><tr class="detail"></td><td class="detail">Weight</td><td class="value"><input id="itemWeight" name="itemWeight" value='0' type="text" disabled/></td></tr><tr><td class="detail">Risky</td><td class="value"><input id="risky" name="risky" value='' type="text" disabled style="text-transform: uppercase;"/></td></td></tr><tr><td class="detail">Status</td><td class="value"><input id="status" name="status" value='' type="text" disabled/></td></tr><tr><td class="detail">Warehouse Id</td><td class="value"><input id="warehouseId" name="warehouseId" value='' type="text"/></td></tr><tr><td class="detail">Max NLC</td><td class="value"><input id="maxNlc" name="maxNlc" value=''type="text" readonly/></td></tr><tr><td class="detail">Snapdeal Selling Price</td><td class="value"><input id="sellingPrice" name="sellingPrice" value='' type="text" onkeyup="calculateStuff()"></td></tr><tr><td class="detail">Snapdeal VOI Selling Price</td><td class="value"><input id="voiSellingPrice" name="voiSellingPrice" value='' type="text" onkeyup="calculateStuff()"></td></tr><tr><td class="detail">Transfer Price</td><td class="value"><input id="transferPrice" name="transferPrice" value='' type="text" readonly/></td></tr><tr><td class="detail">Transfer Price VOI</td><td class="value"><input id="transferPriceVOI" name="transferPriceVOI" value='' type="text" readonly/></td></tr><tr><td class="detail">Other Cost</td><td class="value"><input id="otherCost" name="otherCost" value='0.0' type="text" onkeyup="calculateStuff()" style="width:20%;" /><span style="font-weight:bold;color:black;">Packaging Cost</span><input id="packagingCost" name="packagingCost" value='0.0' type="text" style="width:20%;" readonly/></td></tr><tr><td class="detail">Minimum Possible SP (Calculated)</td><td class="value"><input id="minPosSp" name="minPosSp" value='' type="text" readonly/></td><!--Inventory details end--></tr><tr><td class="detail">Minimum Possible TP (Calculated)</td><td class="value"><input id="minPosTp" name="minPosTp" value='' type="text" readonly/></td></tr><tr><td class="detail">Minimum Possible SP VOI(Calculated)</td><td class="value"><input id="minPosSpVoi" name="minPosSpVoi" value='' type="text" readonly/></td><!--Inventory details end--></tr><tr><td class="detail">Minimum Possible TP VOI(Calculated)</td><td class="value"><input id="minPosTpVoi" name="minPosTpVoi" value='' type="text" readonly/></td></tr><tr><td class="detail">Website MRP</td><td class="value"><input id="webisteMrp" name="webisteMrp" value='' type="text" disabled/></td></tr><tr><td class="detail">Website Selling Price</td><td class="value"><input id="webisteSellingPrice" name="webisteSellingPrice" value='' type="text" disabled/></td></tr><tr><td class="detail">SUPC Code</td><td class="value"><input id="supc" name="supc" value='' type="text"></td></tr><tr><td class="detail">Item Id @ Snapdeal VOI</td><td class="value"><input id="sdVoiItemCode" name="sdVoiItemCode" value='' type="text"></td></tr><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">Margin</td><td class="value"><input id="margin" name="margin" value=''type="text" style="width:20%;" disabled/><span style="font-weight:bold;color:black;">Margin %</span><input id="marginPer" name="marginPer" value='' type="text" style="width:20%;" disabled/></td></td></tr><tr><td class="detail">Margin VOI</td><td class="value"><input id="marginVOI" name="marginVOI" value=''type="text" style="width:20%;" disabled/><span style="font-weight:bold;color:black;">Margin %</span><input id="marginPerVOI" name="marginPerVOI" value='' type="text" style="width:20%;" disabled/></td></td></tr><tr><td class="detail">Maximum Selling Price</td><td class="value"><input id="maxSp" name="maxSp" value='' type="text"></td></tr><tr><td class="detail">Suppress Inventory Feed</td><td class="value"><select name="isSuppressInventoryFeed" selectType="1"><option value="True">Active</option><option selected="selected" value="False">InActive</option></select></td></tr><tr><td class="detail">Suppress Price Feed</td><td class="value"><select name="isSuppressPriceFeed" selectType="1"><option selected="selected" value="True">Active</option><option selected="selected" value="False">InActive</option></select></td></tr><tr><td class="detail">Suppress VOI Pricing Feed</td><td class="value"><select name="isSuppressVoiPriceFeed" selectType="1" class="border-highlight-red"><option selected="selected" value="True">Active</option><option value="False">InActive</option></select></td></tr><tr><td class="detail">Snapdeal Listed</td><td class="value"><select name="isListedOnSnapdeal" selectType="2"><option selected="selected" value="True">Active</option><option value="False">InActive</option></select></td></tr><tr><td class="detail">Snapdeal VOI Listed</td><td class="value"><select name="isVoiListedOnSnapdeal" selectType="2"><option selected="selected" value="True">Active</option><option value="False">InActive</option></select></td></tr><tr><td class="detail">Manual Favourite</td><td class="value"><select name="isManualFavourite" selectType="3"><option value="True">Active</option><option selected="selected" value="False">InActive</option></select></td></tr><tr><td class="detail">Auto Increment</td><td class="value"><select name="isAutoIncrement" selectType="3"><option value="True">Active</option><option selected="selected" value="False">InActive</option></select></td></tr><tr><td class="detail">Auto Decrement</td><td class="value"><select name="isAutoDecrement" selectType="3"><option value="True">Active</option><option selected="selected" value="False">InActive</option></select></td></tr><tr><td class="detail">Exception Price</td><td class="value"><input id="exceptionPrice" name="exceptionPrice" value='' type="text"/></td></tr><tr><td class="detail">Commission %</td><td class="value"><input id="commissionRate" name="commissionRate" value=''type="text" disabled/></td></tr><tr><td class="detail">Commission VOI %</td><td class="value"><input id="commissionRateVoi" name="commissionRateVoi" value=''type="text" onkeyup="calculateStuff()" /></td></tr><tr><td class="detail">Commission</td><td class="value"><input id="commission" name="commission" value='' type="text" readonly/></td></tr><tr><td class="detail">Commission VOI</td><td class="value"><input id="commissionVoi" name="commissionVoi" value='' type="text" readonly/></td></tr><tr><td class="detail">VAT %</td><td class="value"><input id="vat" name="vat" value='' type="text" onkeyup="calculateStuff()"></td></tr><tr><td class="detail">Service Tax</td><td class="value"><input id="serviceTax" name="serviceTax" value='' type="text" readonly/></td></tr><tr><td class="detail">Service Tax VOI</td><td class="value"><input id="serviceTaxVOI" name="serviceTaxVOI" value='' type="text" readonly/></td></tr><tr><td class="detail">Courier Cost</td><td class="value"><input id="courierCost" name="courierCost" value='' type="text" style="width:20%;" readonly/><span style="font-weight:bold;color:black;">Snapdeal</span><input id="courierCostMarketplace" name="courierCostMarketplace" value='' type="text" style="width:20%;" onkeyup="calculateStuff()"></td></tr><tr><td class="detail">Courier Cost VOI</td><td class="value"><input id="courierCostVoi" name="courierCostVoi" value='' type="text" style="width:20%;" readonly/><span style="font-weight:bold;color:black;">Snapdeal VOI</span><input id="courierCostMarketplaceVoi" name="courierCostMarketplaceVoi" value=''type="text" style="width:20%;" onkeyup="calculateStuff()"></td></tr><tr><td class="detail">Item Id @ Snapdeal</td><td class="value"><input id="sdItemCode" name="sdItemCode" value='' type="text"></td></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="returnProvision" name="returnProvision" value='' type="text" disabled/></td></tr><tr class="detail" style="display:none;"></td><td><input id="emiFee" name="emiFee" value='' type="text" disabled/></td></tr><tr class="detail" style="display:none;"></td><td><input id="closingFee" name="closingFee" value='' type="text" disabled/></td></tr><tr class="detail" style="display:none;"></td><td><input id="serviceTaxRate" name="serviceTaxRate" value='' type="text" disabled/><input id="pgFee" name="pgFee" value='' type="text" disabled/></td></tr></tbody></table></div></form>