Subversion Repositories SmartDukaan

Rev

Rev 29847 | Rev 29889 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
28102 tejbeer 1 
 
28117 tejbeer 2 
<style>
28134 tejbeer 3 
.table {
4 
	background-image:
28136 tejbeer 5 
		url("data:image/svg+xml;utf8,<svg xmlns='http://www.w3.org/2000/svg' version='1.1' height='100px' width='100px'><text transform='translate(20, 100) rotate(-45)' fill='rgb(211,211,211)' font-size='20'>$partnerCode</text></svg>");
28117 tejbeer 6 
}
29845 amit.gupta 7 
.highlight-br {
8 
 border-right:1px solid #aaa !important;
9 
}
28117 tejbeer 10 
</style>
28134 tejbeer 11 
 
12 
<script type="text/javascript">
13 
	$(document).ready(function() {
28139 tejbeer 14 
 
15 
		$('body').bind('cut copy paste', function(e) {
16 
			return false;
17 
		});
28134 tejbeer 18 
		$('#circular-table').contextmenu(function() {
19 
			return false;
20 
		});
21 
	});
22 
</script>
28109 tejbeer 23 
 
28139 tejbeer 24 
<body>
25 
	<div class="col-lg-12">
26 
		<h4>Note</h4>
27 
		<b>Hygiene Payout</b> - Hygiene Payout calculation is subject to sales
28 
		hygiene including customer & other details entered in the system, pl
29 
		refer to hygiene meter in your Dashboard.<br> <b>Tertiary
30 
			Payout</b> - Tertiary Payout calculation is subject to activation of the
31 
		handset against the sales entered in system. <br> <b>Investment
32 
			Payout</b> - Investment Payout calculation is subject to maintenance of
33 
		90% of minimum Investments for minimum 12 days in a month as per below
34 
		slabs
35 
		<ul>
36 
			<li>a) 2% in case minimum investment is 90% or above for 12 days
37 
				or more in a month</li>
38 
			<li>b) 1% in case of minimum investment is 90% or above for 8-11
39 
				days in a month</li>
40 
			<li>c) No payout in case of minimum investment is less than 8
41 
				days in a month to change at the discretion of SmartDukaan.</li>
42 
		</ul>
43 
		<b>Below Price Structure is subject to change at the discretion of
44 
			SmartDukaan.</b>
28102 tejbeer 45 
 
28139 tejbeer 46 
	</div>
28102 tejbeer 47 
 
28139 tejbeer 48 
	<div class="col-lg-12">
49 
		<table class="table table-border table-condensed table-bordered"
50 
			id="circular-table">
28102 tejbeer 51 
 
28139 tejbeer 52 
			<thead>
53 
				<tr>
28102 tejbeer 54 
 
28139 tejbeer 55 
					<th rowspan=2>Item Id</th>
56 
					<th rowspan=2>Model</th>
57 
					<th rowspan=2>Type</th>
58 
					<th rowspan=2>MRP</th>
59 
					<th rowspan=2>MOP</th>
60 
					<th rowspan=2>DP</th>
29653 tejbeer 61 
					<th colspan=3 style="text-align: center">Sell In Margin</th>
28139 tejbeer 62 
					<th colspan=4 style="text-align: center">Sell Out Margin</th>
63 
					<th rowspan=2>Activation Payout</th>
29846 amit.gupta 64 
					#set($add=0)
29845 amit.gupta 65 
					#if($upgradeOffer)
66 
					<th rowspan=2>Upgrade Offer</th>
29846 amit.gupta 67 
					#set($add=1)
29845 amit.gupta 68 
					#end
29785 amit.gupta 69 
					#foreach($offer in $offers)
29846 amit.gupta 70 
						#set($fieldIndex=$velocityCount*2 + (12 + $add))
29845 amit.gupta 71 
						<th data-idx="$fieldIndex" colspan=2 data-offerid="$offer.getId()"><a href="javascript:void(0)" class="mk_partner_view">$offer.getName()</a></th>
29785 amit.gupta 72 
					#end
28139 tejbeer 73 
					<th rowspan=2>Total Margin</th>
74 
					<th rowspan=2>Net Landing Price</th>
75 
					<th rowspan=2>MOP-DP</th>
76 
					<th rowspan=2>Total Profit</th>
77 
					<th rowspan=2>Net % Margin</th>
28102 tejbeer 78 
 
28139 tejbeer 79 
				</tr>
28102 tejbeer 80 
 
28139 tejbeer 81 
				<tr>
28102 tejbeer 82 
 
83 
 
28139 tejbeer 84 
					<th>Base Payout</th>
85 
					<th>Cash Discount</th>
29653 tejbeer 86 
					<th>Upfront Margin</th>
28139 tejbeer 87 
					<th>Tertiary Payout</th>
88 
					<th>Hygiene Payout</th>
89 
					<th>Category Payout</th>
90 
					<th>Investment Payout</th>
29785 amit.gupta 91 
					#foreach($offer in $offers)
92 
						<th>Target</th>
93 
						<th>Margin</th>
94 
					#end
28102 tejbeer 95 
 
96 
 
97 
 
28139 tejbeer 98 
				</tr>
28102 tejbeer 99 
 
100 
 
101 
 
28139 tejbeer 102 
			</thead>
103 
			<tbody>
104 
				#foreach($pc in $priceCircular )
105 
				<tr>
28102 tejbeer 106 
 
28139 tejbeer 107 
					<td>$pc.getItemId()</td>
108 
					<td>$pc.getModelName() $pc.getModelNumber() ($pc.getColor())</td>
109 
					<td>$pc.getType()</td>
110 
					<td class="currency">$pc.getMrp()</td>
29848 amit.gupta 111 
					<td class="currency">$pc.getMop()</td>
112 
					<td class="currency dp" data-value="$pc.getSellingPrice()">$pc.getSellingPrice()</td>
28139 tejbeer 113 
					<td class="currency">$pc.getBasePayout()</td>
114 
					<td class="currency">$pc.getCashDiscount()</td>
29653 tejbeer 115 
					<td class="currency">$pc.getUpfrontMargin()</td>
28139 tejbeer 116 
					<td class="currency">$pc.getTertiaryPayout()</td>
117 
					<td class="currency">$pc.getHygienePayout()</td>
118 
					<td class="currency">$pc.getCategoryPayout()</td>
119 
					<td class="currency">$pc.getInvestmentPayout()</td>
120 
					<td class="currency">$pc.getModelSpecfic()</td>
29845 amit.gupta 121 
					#if($upgradeOffer)
122 
					<td class="currency">$pc.getUpgradeOffer()</td>
123 
					#end
29785 amit.gupta 124 
					#foreach($slabPayout in $pc.getSlabPayouts())
125 
					#if($slabPayout.size()>0)
126 
					<td>
29846 amit.gupta 127 
					<select class="mk_criteria_slab" data-value="$slabPayout.entrySet().iterator().next().getValue()">
29785 amit.gupta 128 
						#foreach($payout in $slabPayout.entrySet())
129 
							<option data-value="$payout.getValue()" value="$payout.getKey()">$payout.getKey() onwards</option>
130 
						#end
131 
					</select>
132 
					</td>
133 
					<td class="currency">$slabPayout.values().iterator().next()</td>
134 
					#else
135 
					<td> - </td>
136 
					<td> - </td>
137 
					#end
138 
					#end
29846 amit.gupta 139 
					<td class="currency totalmargin" data-value="$pc.getTotalScheme()">$pc.getTotalScheme()</td>
140 
					<td class="currency netprice" data-value="$pc.getNetPrice()">$pc.getNetPrice()</td>
28139 tejbeer 141 
					<td class="currency">$pc.getMopdp()</td>
29846 amit.gupta 142 
					<td class="currency totalprofit" data-value="$pc.getTotalProfit()">$pc.getTotalProfit()</td>
143 
					<td class="netmargin">$pc.getNetMargin()</td>
28102 tejbeer 144 
 
28139 tejbeer 145 
				</tr>
146 
				#end
147 
			</tbody>
148 
		</table>
149 
	</div>
29785 amit.gupta 150 
 
151 
			<div class="offer-margin-container">
152 
            <div class="modal  text-center" id="offerDescription">
153 
                <div class="modal-dialog modal-lg modal-dialog-scrollable">
154 
                    <div class="modal-content">
155 
                    </div>
156 
                </div>
157 
            </div>
158 
        </div>
28139 tejbeer 159 
</body>
28102 tejbeer 160 
<script type="text/javascript">
161 
	$(document).ready(function() {
29785 amit.gupta 162 
		priceCircularTable = $('#circular-table').DataTable({
163 
			"scrollX": true,
28102 tejbeer 164 
			"bPaginate" : true,
165 
			"bLengthChange" : true,
166 
			"bFilter" : true,
167 
			"bInfo" : false,
168 
			"bAutoWidth" : false,
169 
 
29785 amit.gupta 170 
		});
28102 tejbeer 171 
	});
29846 amit.gupta 172 
	$('select.mk_criteria_slab').change(function() {
173 
		debugger;
174 
		oldSelectedValue = $(this).data("value");
175 
		$(this).closest('td').next().html($(this).find("option:selected").data("value"));
176 
		let diff=oldSelectedValue - $(this).find("option:selected").data("value");
177 
		let $tr = $(this).closest('tr');
178 
		let totalMargin = numberToComma($tr.find('.totalmargin').data('value') - diff);
179 
		$tr.find('.totalmargin').html(totalMargin);
180 
		let netLanding =  $tr.find('.netprice').data('value') + diff;
181 
		let netLandingString = numberToComma(netLanding);
182 
		$tr.find('.netprice').html(netLandingString);
183 
 
184 
		let totalProfit =  $tr.find('.totalprofit').data('value') - diff;
185 
		let totalProfitString =  numberToComma(totalProfit);
29847 amit.gupta 186 
		$tr.find('.totalprofit').html(totalProfitString);
29846 amit.gupta 187 
 
188 
		##let rouoff = totalProfit / (netLanding / 1.18) * 100;
29847 amit.gupta 189 
		let rouoff = totalProfit / ($tr.find('.dp').data('value') / 1.18) * 100;
29846 amit.gupta 190 
		let roundOff = Math.round(rouoff * 100.0) / 100.0;
191 
		$tr.find('.netmargin').html(roundOff);
192 
	});
28102 tejbeer 193 
</script>