Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
28474 tejbeer 1 
 
2 
<script src="https://cdn.datatables.net/plug-ins/1.10.19/api/sum().js"></script>
3 
 
4 
 
5 
 
28005 tejbeer 6 
<div class="row">
7 
 
8 
 
28474 tejbeer 9 
	#if(!$inStocksMap.isEmpty())
28523 tejbeer 10 
	<div class="col-lg-12">
28005 tejbeer 11 
		<table
12 
			class="table table-striped table-advance table-hover partner-planning-details">
13 
			<thead>
28474 tejbeer 14 
 
28005 tejbeer 15 
				<tr>
28474 tejbeer 16 
					<th rowspan="3">Warehouse</th>
17 
					<th rowspan="3">Category</th>
18 
					<th rowspan="3">Partner Name</th> #foreach($catalog in
19 
					$catalogItemMap.entrySet())
28477 tejbeer 20 
					<th colspan="3">WOD : <span class="wod"></span>, TS:<span
28807 tejbeer 21 
						class="ts"></span>/<span
22 
						class="tp"></span>, WOS: <span class="wos"></span>, TSale: <span class="sts"> </span>
28474 tejbeer 23 
					</th> #end
24 
					<th rowspan="3">PO</th>
25 
					<th rowspan="3">last Po Entry</th>
26 
 
27 
				</tr>
28 
 
29 
				<tr>
30 
					#foreach($catalog in $catalogItemMap.entrySet())
31 
					<th colspan="3">$catalog.getValue().get(0).getBrand()
32 
						$catalog.getValue().get(0).getModelName()
33 
						$catalog.getValue().get(0).getModelNumber()</th> #end
34 
 
35 
 
36 
				</tr>
37 
				<tr>
38 
					#foreach($catalog in $catalogItemMap.entrySet())
28005 tejbeer 39 
					<th>Stock</th>
40 
					<th>Sale</th>
28474 tejbeer 41 
					<th>SD Stock</th> #end
28005 tejbeer 42 
 
43 
				</tr>
28474 tejbeer 44 
 
45 
 
46 
 
28005 tejbeer 47 
			</thead>
48 
			<tbody>
28474 tejbeer 49 
				#foreach($keyvalue in $customRetailers.entrySet())
28005 tejbeer 50 
				<tr>
28020 tejbeer 51 
					<td>$warehouseMap.get($keyvalue.getValue().getWarehouseId())</td>
28053 tejbeer 52 
					<td>$fofoIdPartnerTypeMap.get($keyvalue.getKey())</td>
53 
 
28005 tejbeer 54 
					<td>$customRetailers.get($keyvalue.getKey()).getBusinessName()</td>
28474 tejbeer 55 
 
56 
					#foreach($catalog in $catalogItemMap.entrySet())
57 
					#if($inStocksMap.get($keyvalue.getKey()).get($catalog.getKey()))
58 
					<td class="instockItem" data-fofoid="$keyvalue.getKey()"
28486 tejbeer 59 
						data-catalogid="$catalog.getKey()" data-toggle="modal"
28807 tejbeer 60 
						data-target="#inStockQtyModel">$inStocksMap.get($keyvalue.getKey()).get($catalog.getKey())/#if($pendingIndentMap.get($keyvalue.getKey()).get($catalog.getKey())) $pendingIndentMap.get($keyvalue.getKey()).get($catalog.getKey()) #else 0 #end</td>
28474 tejbeer 61 
					#else
28807 tejbeer 62 
					<td>0/#if($pendingIndentMap.get($keyvalue.getKey()).get($catalog.getKey())) $pendingIndentMap.get($keyvalue.getKey()).get($catalog.getKey()) #else 0 #end</td> #end
28474 tejbeer 63 
					#if($fofoSalesMap.get($keyvalue.getKey()).get($catalog.getKey()))
64 
 
28032 tejbeer 65 
					<td class="inSaleItem"
66 
						data-fofoid="$keyvalue.getValue().getFofoId()" data-toggle="modal"
28474 tejbeer 67 
						data-target="#inSaleItemModel">$fofoSalesMap.get($keyvalue.getKey()).get($catalog.getKey())</td>
28032 tejbeer 68 
					#else
28005 tejbeer 69 
					<td>0</td> #end
28474 tejbeer 70 
					#if($warehouseStockMap.get($keyvalue.getValue().getWarehouseId()).get($catalog.getKey()))
71 
 
28053 tejbeer 72 
					<td class="warehouseStockItem"
73 
						data-warehouseid="$keyvalue.getValue().getWarehouseId()"
74 
						data-catalogid="$keyvalue.getValue().getWarehouseId()"
28474 tejbeer 75 
						data-toggle="modal" data-target="#warehouseStockItemModel">$warehouseStockMap.get($keyvalue.getValue().getWarehouseId()).get($catalog.getKey())</td>
28053 tejbeer 76 
					#else
28474 tejbeer 77 
					<td>0</td> #end #end
28085 tejbeer 78 
					<td><a class="selctItemQty" data-toggle="modal"
28474 tejbeer 79 
						data-fofoid="$keyvalue.getKey()" data-target="#selectModelItems">
80 
							Add to po </a></td> #if($suggestedPoEntry.get($keyvalue))
28053 tejbeer 81 
 
28474 tejbeer 82 
					<td><a class="podetails" data-fofoid="$keyvalue.getKey()"
83 
						data-datetime="$suggestedPoEntry.get($keyvalue.getKey())"
84 
						data-toggle="modal" data-target="#ItemsPo">$suggestedPoEntry.get($keyvalue.getKey()).format($dateTimeFormatter)</a></td>
28085 tejbeer 85 
					#else
86 
					<td></td> #end
28053 tejbeer 87 
 
28005 tejbeer 88 
				</tr>
89 
				#end
90 
 
91 
			</tbody>
92 
		</table>
93 
	</div>
94 
	#else
95 
 
96 
	<div class="col-lg-6">
97 
		<table
98 
			class="table table-striped table-advance table-hover partner-planning-details">
99 
			<thead>
100 
				<tr>
28020 tejbeer 101 
					<th>Warehouse</th>
28053 tejbeer 102 
					<th>Category</th>
28005 tejbeer 103 
					<th>Partner Name</th>
104 
					<th>Item</th>
105 
					<th>Stock</th>
106 
					<th>Sale</th>
28053 tejbeer 107 
					<th>Warehouse Stock</th>
28085 tejbeer 108 
					<th>PO</th>
109 
					<th>last Po Entry</th>
28005 tejbeer 110 
 
28085 tejbeer 111 
 
112 
 
28005 tejbeer 113 
				</tr>
114 
			</thead>
115 
			<tbody>
116 
				#foreach($keyvalue in $inStockItemMap.entrySet())
117 
				<tr>
28020 tejbeer 118 
					<td>$warehouseMap.get($keyvalue.getValue().getWarehouseId())</td>
28053 tejbeer 119 
					<td>$fofoIdPartnerTypeMap.get($keyvalue.getKey().getFofoId())</td>
28020 tejbeer 120 
 
28005 tejbeer 121 
					<td>$customRetailers.get($keyvalue.getKey().getFofoId()).getBusinessName()</td>
122 
					<td>$keyvalue.getValue().getBrand()
123 
						$keyvalue.getValue().getModelName()
124 
						$keyvalue.getValue().getModelNumber()</td>
125 
					<td>$keyvalue.getValue().getQty()</td>
126 
					#if($fofoSaleItem.get($keyvalue.getKey()))
127 
					<td>$fofoSaleItem.get($keyvalue.getKey()).getQty()</td> #else
128 
					<td>0</td> #end
28053 tejbeer 129 
 
130 
 
131 
					<td>$keyvalue.getValue().getWarehouseQty()</td>
28085 tejbeer 132 
					<td><a class="selctItemQty" data-toggle="modal"
133 
						data-fofoid="$keyvalue.getValue().getFofoId()"
134 
						data-target="#selectModelItems"> Add to po </a></td>
135 
					#if($suggestedPoEntry.get($keyvalue.getKey().getFofoId()))
28053 tejbeer 136 
 
28085 tejbeer 137 
					<td><a class="podetails"
138 
						data-fofoid="$keyvalue.getKey().getFofoId()" data-toggle="modal"
139 
						data-target="#ItemsPo"
140 
						data-datetime="$suggestedPoEntry.get($keyvalue.getValue().getFofoId())">
141 
							$suggestedPoEntry.get($keyvalue.getKey().getFofoId()).format($dateTimeFormatter)
142 
					</a></td> #else
143 
					<td></td> #end
144 
 
28005 tejbeer 145 
				</tr>
146 
				#end
147 
 
148 
			</tbody>
149 
		</table>
150 
	</div>
151 
 
152 
	#end
153 
</div>
154 
 
155 
 
28032 tejbeer 156 
<div id="inStockItemModel" class="modal" role="dialog">
157 
	<div class="modal-dialog">
158 
		<div class="modal-content"></div>
159 
	</div>
160 
</div>
161 
 
28486 tejbeer 162 
<div id="inStockQtyModel" class="modal" role="dialog">
163 
	<div class="modal-dialog">
164 
		<div class="modal-content"></div>
165 
	</div>
166 
</div>
28032 tejbeer 167 
 
168 
<div id="inSaleItemModel" class="modal" role="dialog">
169 
	<div class="modal-dialog">
170 
		<div class="modal-content"></div>
171 
	</div>
172 
</div>
28053 tejbeer 173 
 
174 
<div id="warehouseStockItemModel" class="modal" role="dialog">
175 
	<div class="modal-dialog">
176 
		<div class="modal-content"></div>
177 
	</div>
178 
</div>
28085 tejbeer 179 
 
180 
 
181 
<div id="selectModelItems" class="modal" role="dialog">
182 
	<div class="modal-dialog">
183 
		<div class="modal-content"></div>
184 
	</div>
185 
</div>
186 
 
187 
<div id="ItemsPo" class="modal" role="dialog">
188 
	<div class="modal-dialog">
189 
		<div class="modal-content"></div>
190 
	</div>
191 
</div>
28005 tejbeer 192 
<script type="text/javascript">
28474 tejbeer 193 
	var table
28020 tejbeer 194 
 
28474 tejbeer 195 
	$(document).ready(function() {
28020 tejbeer 196 
 
28474 tejbeer 197 
		table = $('.partner-planning-details').DataTable({
28020 tejbeer 198 
 
28474 tejbeer 199 
			"lengthMenu" : [ 10, 25, 50, 75, 100, 250 ],
28523 tejbeer 200 
			"scrollX" : true,
28474 tejbeer 201 
			"pageLength" : 250,
202 
			"orderCellsTop" : true,
28523 tejbeer 203 
			"fixedHeader" : true,
204 
			"fixedColumns" : {
205 
				leftColumns : 3
206 
 
207 
			}
208 
 
28474 tejbeer 209 
		});
28032 tejbeer 210 
 
28474 tejbeer 211 
		datatableSum()
212 
 
213 
		table.on('search.dt', function() {
214 
			console.log('Currently applied global search: ' + table.search());
215 
 
216 
			datatableSum();
217 
 
218 
		});
219 
	});
220 
 
221 
	function datatableSum() {
222 
		let wod = [];
223 
		let wos = [];
28589 tejbeer 224 
		let sos = [];
28807 tejbeer 225 
		let pos = [];
28589 tejbeer 226 
		let sts = [];
28474 tejbeer 227 
		table.rows({
228 
			"search" : "applied"
229 
		}).every(function() {
230 
			var data = this.data();
28807 tejbeer 231 
 
28474 tejbeer 232 
			for (let i = 3; i < data.length - 2; i = i + 3) {
233 
				j = i / 3
234 
				if (wod[j] == undefined) {
235 
					wod[j] = 0;
236 
				}
237 
				if (parseInt(data[i]) > 0) {
238 
					wod[j]++;
239 
				}
28477 tejbeer 240 
 
28807 tejbeer 241 
	         var fields = data[i].split('/');
242 
 
243 
			console.log(fields)
244 
				console.log(fields[0])
245 
					console.log(fields[1])
28477 tejbeer 246 
				if (sos[j] == undefined) {
28807 tejbeer 247 
					sos[j] = parseInt(fields[0]);
28477 tejbeer 248 
				} else {
28807 tejbeer 249 
					sos[j] += parseInt(fields[0]);
250 
 
28477 tejbeer 251 
				}
28807 tejbeer 252 
 
253 
				if (pos[j] == undefined) {
254 
					pos[j] = parseInt(fields[1]);
255 
				} else {
256 
				var fields = data[i].split('/');
257 
					pos[j]+= parseInt(fields[1]);
258 
 
259 
				}
28474 tejbeer 260 
			}
261 
 
28476 tejbeer 262 
			for (let h = 4; h < data.length - 2; h = h + 3) {
263 
				g = Math.floor(h / 3)
28486 tejbeer 264 
 
28474 tejbeer 265 
				if (wos[g] == undefined) {
28486 tejbeer 266 
					wos[g] = 0;
28474 tejbeer 267 
				}
28486 tejbeer 268 
				if (parseInt(data[h]) > 0) {
269 
					wos[g]++;
270 
				}
28589 tejbeer 271 
 
272 
				if (sts[g] == undefined) {
273 
					sts[g] = parseInt(data[h]);
274 
				} else {
275 
					sts[g] += parseInt(data[h]);
276 
				}
28486 tejbeer 277 
 
28474 tejbeer 278 
			}
279 
 
280 
		});
281 
 
282 
		console.log(wod);
283 
		console.log(wos);
28477 tejbeer 284 
		console.log(sos);
28589 tejbeer 285 
		console.log(sts);
28807 tejbeer 286 
		console.log(pos)
28474 tejbeer 287 
		for (let m = 3; m < wod.length + 2; m++) {
288 
			let indexNum = m + 1;
289 
			var stockHeader = $(`.partner-planning-details thead tr th:nth-child(${indexNum})`)
290 
			stockHeader.find('.wod').html(wod[m - 2])
28477 tejbeer 291 
			stockHeader.find('.ts').html(sos[m - 2])
28807 tejbeer 292 
			stockHeader.find('.tp').html(pos[m - 2])
28474 tejbeer 293 
		}
294 
 
295 
		for (let l = 3; l < wos.length + 2; l++) {
296 
			let indexNum = l + 1;
297 
			console.log(indexNum)
298 
			var stockHeader = $(`.partner-planning-details thead tr th:nth-child(${indexNum})`)
299 
			stockHeader.find('.wos').html(wos[l - 2])
28589 tejbeer 300 
			stockHeader.find('.sts').html(sts[l - 2])
28474 tejbeer 301 
		}
302 
 
303 
	}
304 
 
28486 tejbeer 305 
	/*$('.partner-planning-details').on(
28032 tejbeer 306 
			'click',
307 
			'.instockItem',
308 
			function() {
309 
				var fofoId = $(this).data('fofoid');
310 
				var catalogIds = $('.criteria-item-catalogids').val();
311 
				console.log(catalogIds);
312 
 
313 
				doGetAjaxRequestHandler(context
314 
						+ "/getInStockItembyFofoId?fofoId=" + fofoId
315 
						+ "&catalogItemIds=" + catalogIds, function(response) {
316 
					console.log(response)
317 
					$('#inStockItemModel .modal-content').html(response);
318 
 
319 
				});
28486 tejbeer 320 
			});*/
321 
 
322 
	$('.partner-planning-details').on(
323 
			'click',
324 
			'.instockItem',
325 
			function() {
326 
				var fofoId = $(this).data('fofoid');
327 
				var catalogId = $(this).data('catalogid');
328 
				console.log(catalogId);
329 
 
330 
				doGetAjaxRequestHandler(context + "/getInStockItemQty?fofoId="
331 
						+ fofoId + "&catalogItemId=" + catalogId, function(
332 
						response) {
333 
					console.log(response)
334 
					$('#inStockQtyModel .modal-content').html(response);
335 
 
336 
				});
28032 tejbeer 337 
			});
338 
 
339 
	$('.partner-planning-details').on(
340 
			'click',
341 
			'.inSaleItem',
342 
			function() {
28057 tejbeer 343 
				var fofoId = $(this).data('fofoid');
28032 tejbeer 344 
				var catalogIds = $('.criteria-item-catalogids').val();
345 
				console.log(catalogIds);
346 
 
347 
				doGetAjaxRequestHandler(context
348 
						+ "/getSaleItembyCatalogFofoId?fofoId=" + fofoId
349 
						+ "&catalogItemIds=" + catalogIds + "&date="
350 
						+ startDate, function(response) {
351 
					console.log(response)
352 
					$('#inSaleItemModel .modal-content').html(response);
353 
 
354 
				});
355 
			});
28053 tejbeer 356 
 
357 
	$('.partner-planning-details').on(
358 
			'click',
359 
			'.warehouseStockItem',
360 
			function() {
361 
				var warehouseId = $(this).data('warehouseid');
362 
				var catalogIds = $('.criteria-item-catalogids').val();
363 
				console.log(catalogIds);
364 
 
365 
				doGetAjaxRequestHandler(context
366 
						+ "/getWarehouseStockItem?warehouseId=" + warehouseId
367 
						+ "&catalogItemIds=" + catalogIds,
368 
						function(response) {
369 
							console.log(response)
370 
							$('#warehouseStockItemModel .modal-content').html(
371 
									response);
372 
 
373 
						});
374 
			});
28085 tejbeer 375 
 
376 
	$('.partner-planning-details').on(
377 
			'click',
378 
			'.selctItemQty',
379 
			function() {
380 
				var catalogIds = $('.criteria-item-catalogids').val();
381 
				console.log(catalogIds);
382 
				var fofoId = $(this).data('fofoid');
383 
 
384 
				doGetAjaxRequestHandler(context
385 
						+ "/selectItemColorByCatalog?catalogIds=" + catalogIds
386 
 
387 
						+ "&fofoId=" + fofoId, function(response) {
388 
					console.log(response)
389 
					$('#selectModelItems .modal-content').html(response);
390 
 
391 
				});
392 
			});
393 
 
394 
	$(document).on(
395 
			"click",
396 
			".submit-item-po",
397 
			function(e) {
398 
				var seletedIds;
399 
				var jsonObject = {};
400 
				var seletedIdsJson = [];
401 
				var fofoId = $(this).data('fofoid');
402 
 
403 
				$('#select-item').find('tr').each(function() {
404 
					var row = $(this);
405 
 
406 
					console.log(row);
407 
					if (row.find('input[type="checkbox"]').is(':checked')) {
408 
						var currentRow = $(this).closest("tr");
409 
 
410 
						var itemId = currentRow.find("td:eq(1)").html();
411 
						var name = currentRow.find("td:eq(2)").html();
412 
						var quantity = currentRow.find("td:eq(3) input").val();
413 
						console.log(quantity)
414 
						if (quantity == "") {
415 
							alert("Select the Quantity");
416 
							return false;
417 
 
418 
						}
419 
 
420 
						seletedIds = {
421 
							"itemId" : itemId,
422 
							"qty" : quantity
423 
						}
424 
						seletedIdsJson.push(seletedIds)
425 
 
426 
					}
427 
 
428 
				});
429 
 
430 
				console.log(fofoId)
431 
				if (fofoId == null) {
432 
					alert("fofoId is required");
433 
					return false;
434 
				}
435 
				if (seletedIdsJson.length === 0) {
436 
					alert("Atleast one Item selected");
437 
					return false;
438 
				}
439 
				console.log(seletedIdsJson);
440 
 
441 
				jsonObject['poIds'] = seletedIdsJson;
442 
				jsonObject['fofoId'] = fofoId;
443 
				console.log(jsonObject)
444 
				if (confirm("Are you sure you want to create po") == true) {
445 
 
446 
					doPostAjaxRequestWithJsonHandler(context + "/createPo",
447 
							JSON.stringify(jsonObject), function(response) {
448 
								if (response == 'true') {
449 
									alert("successfully create");
450 
 
451 
									$("#selectModelItems").modal("hide");
452 
									$("button.search-partner-stock").click();
453 
								}
454 
							});
455 
				}
456 
 
457 
			});
458 
 
459 
	$('.partner-planning-details').on(
460 
			'click',
461 
			'.podetails',
462 
			function() {
463 
				var fofoId = $(this).data('fofoid');
464 
				var datetime = $(this).data('datetime');
465 
 
466 
				doGetAjaxRequestHandler(context
467 
						+ "/getSuggestedPoDetail?fofoId=" + fofoId
468 
						+ "&datetime=" + datetime, function(response) {
469 
					console.log(response)
470 
					$('#ItemsPo .modal-content').html(response);
471 
 
472 
				});
473 
			});
28005 tejbeer 474 
</script>