000

<?php $__env->startSection('title','Stock Report'); ?>
<?php $__env->startSection('content'); ?>
<div class="main-content">
	<div class="main-content-inner">
		<div class="breadcrumbs ace-save-state" id="breadcrumbs">
			<ul class="breadcrumb">
				<li>
					<i class="ace-icon fa fa-home home-icon"></i>
					<a href="#"><?php echo e(__('messages.Home')); ?></a>
				</li>
				<li class="active">Destination Sale Report</li>
			</ul>
		</div>
		<div class="page-content">
			<h3 class="header smaller lighter blue">Destination Sale Report</h3>

<form action="<?php echo e(url('/destination/sale-report2')); ?>" method="POST" role="form"> 
						<div class="row">
							<?php echo e(csrf_field()); ?>

<div class="col-md-3">
								<div class="form-group">
									<label for="master_rake_id">Destination</label>
									<select class="form-control select2" name="destination_id[]" id="destination_id" multiple>
										<option value="">Select Destination</option>
										<?php $__currentLoopData = $destinations; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $destination): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
										<option value="<?php echo e($destination->location_id); ?>" <?php echo e(isset($destination_id) && $destination_id==$destination->id ? "selected":""); ?>><?php echo e($destination->name); ?> [<?php echo e($destination->location_id); ?>]</option>
										<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
										
									</select>
								
									<span class="label label-danger" style="display: none;"></span>
									
								</div>
							</div>
							<div class="col-md-3">
								<div class="form-group input-daterange">
									<label for="master_rake_id">From Date</label>
									 <input type="text" name="from_date" id="from_date" class="form-control" placeholder="From Date"  readonly />
								
									<span class="label label-danger" style="display: none;"></span>
									
								</div>
							</div>
							<div class="col-md-3">
								<div class="form-group input-daterange">
									<label for="master_rake_id">To Date</label>
									 <input type="text" name="to_date" id="to_date" class="form-control" placeholder="To Date" readonly />
								
									<span class="label label-danger" style="display: none;"></span>
									
								</div>
							</div>
							<div class="col-md-3">
								<div class="form-group">
									 <input type="submit" name="filter" id="filter"  class="btn btn-sm btn-primary" value="Filter">
										<input type="button" name="refresh" id="refresh" class="btn btn-sm btn-warning" value="Clear">
								</div>
							</div>
						</div>
					 </form>

<?php if(session('success')): ?>
					<div class="alert alert-success">
						<?php echo e(session('success')); ?>

</div>
					<?php endif; ?>
					<?php if(session('error')): ?>
					<div class="alert alert-danger">
						<?php echo e(session('error')); ?>

</div>
					<?php endif; ?>

<div class="table-header">
						Destination Wise Sale Total (<b><span style="color: orange;" id="grand_total"></span></b>)

</div>

<th>#</th>
										
										
										<th>Dealer</th>
										<th>Retailer</th>
										<th>Destination</th>
										
										<th><?php echo e(__('messages.Product')); ?></th>
										<th>Date</th>
										 <th>Qty</th> 
										
										
										
										
										
									</tr>
								</thead>
								<tbody>
								    <?php if(!empty($orders)): ?>
								    <?php $__currentLoopData = $orders; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $order): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
								    <tr id="tr_<?php echo e($order->id); ?>">
								    <td><?php echo e($loop->index+1); ?></td>
									<td><?php echo e($order->dealer_name); ?></td>
									<td><?php echo e($order->retailer_name); ?></td>
										<td><b><?php echo e(getModelByCode('Location','location_id',$order->destination_code)->name); ?> (<?php echo e(getModelByCode('Location','location_id',$order->destination_code)->district); ?>)</b></td>
								
									<td><?php echo e(getModelById('Product',$order->product_id)->name); ?></td>
									<td><b><i><?php echo e($order->date); ?></i></b></td>
									<td><b class="text text-success"><?php echo e($order->qty); ?></b></td>
								    </tr>
								     <?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
								     <?php endif; ?>
								</tbody>
							
					</table>
					
					
				</div>
			</div>

</div>
</div>

</div>
</div>
</div>

<?php $__env->startSection('script'); ?>
<?php echo e(Html::script("assets/js/jquery.dataTables.min.js")); ?>

<?php echo e(Html::script("assets/js/jquery.dataTables.bootstrap.min.js")); ?>

<?php echo e(Html::script("assets/js/dataTables.buttons.min.js")); ?>

<?php echo e(Html::script("assets/js/buttons.flash.min.js")); ?>

<?php echo e(Html::script("assets/js/buttons.html5.min.js")); ?>

<?php echo e(Html::script("assets/js/buttons.print.min.js")); ?>

<?php echo e(Html::script("assets/js/buttons.colVis.min.js")); ?>

<?php echo e(Html::script("assets/js/dataTables.select.min.js")); ?>

<?php echo e(Html::script("assets/js/ace-elements.min.js")); ?>

<?php echo e(Html::script("assets/js/ace.min.js")); ?>

<?php echo e(Html::script("assets/js/bootstrap-datepicker.min.js")); ?>

// 		$('#filter').click(function(){
// 				var from_date = $('#from_date').val();
// 				var to_date = $('#to_date').val();
// 				var destination_id = $('#destination_id').val();

// 				if(destination_id !='' && from_date != '' &&  to_date != '')
// 				{
					
// 				$('#dynamic-table').DataTable().destroy();
// 				display(destination_id,from_date, to_date);
// 				}else{
// 					alert('destination , from date, to date is required');
// 				}

// 		});

// 		$('#refresh').click(function(){
// 				$('#from_date').val('');
// 				$('#to_date').val('');
// 				$('#dynamic-table').DataTable().destroy();
// 				display();;
// 			});

$('.input-daterange').datepicker({
		
						format:'yyyy-mm-dd',
						autoclose:true
				});

// 	})

// 	function display(destination_id='',from_date = '', to_date = ''){
// 				 let total_bag =0;
// 					var myTable=$('#dynamic-table').DataTable({
// 							"processing": true,
// 							"serverSide": true,
// 							stateSave: true,
// 							 colReorder: true,
// 							bAutoWidth: false,
// 							"aaSorting": [],
// 							"ajax":{
// 								"url": "<?php echo e(route('destination.sale-reports')); ?>",
// 								"data":{destination_id:destination_id,from_date:from_date, to_date:to_date},
// 							},
							
// 							 "footerCallback": function ( row, data, start, end, display ) {
// 					            var api = this.api(), data;
// 					            let total_bag=0;
// 					              $('#grand_total').html('');
// 					            var json = api.ajax.json();
// 					             $.each(json.data, function(key,val) {
//                       console.log(key+val.qty);
//                       total_bag=total_bag+parseFloat(val.qty);
//                       });
// 					             $('#grand_total').html(total_bag);
					            
//       						 },

// 							"columns":[
// 								{ data:"DT_RowIndex" },
								
// 								{ "data": "delear_name" },
// 								{ "data": "retailer_name" },
// 								{ "data": "product_name" },
// 								{ "data": "date" },
// 								{ "data": "qty" }
								
// 							]
// 				});

// 				$.fn.dataTable.Buttons.defaults.dom.container.className = 'dt-buttons btn-overlap btn-group btn-overlap';
						
// 						new $.fn.dataTable.Buttons( myTable, {
// 							buttons: [
// 							{
// 								"extend": "colvis",
// 								"text": "<i class='fa fa-search bigger-110 blue'></i> <span class='hidden'>Show/hide columns</span>",
// 								"className": "btn btn-white btn-primary btn-bold",
// 								columns: ':not(:first):not(:last)'
// 							},
// 							{
// 								"extend": "copy",
// 								"text": "<i class='fa fa-copy bigger-110 pink'></i> <span class='hidden'>Copy to clipboard</span>",
// 								"className": "btn btn-white btn-primary btn-bold"
// 							},
// 							{
// 								"extend": "csv",
// 								"text": "<i class='fa fa-database bigger-110 orange'></i> <span class='hidden'>Export to CSV</span>",
// 								"className": "btn btn-white btn-primary btn-bold"
// 							},
// 							{
// 								"extend": "excel",
// 								"text": "<i class='fa fa-file-excel-o bigger-110 green'></i> <span class='hidden'>Export to Excel</span>",
// 								"className": "btn btn-white btn-primary btn-bold"
// 							},
// 							{
// 								"extend": "pdf",
// 								"text": "<i class='fa fa-file-pdf-o bigger-110 red'></i> <span class='hidden'>Export to PDF</span>",
// 								"className": "btn btn-white btn-primary btn-bold"
// 							},
// 							{
// 								"extend": "print",
// 								"text": "<i class='fa fa-print bigger-110 grey'></i> <span class='hidden'>Print</span>",
// 								"className": "btn btn-white btn-primary btn-bold",
// 								autoPrint: false,
// 								message: 'This print was produced using the Print button for DataTables'
// 							}		  
// 							]
// 						} );
// 						myTable.buttons().container().appendTo( $('.tableTools-container') );
						
// 						//style the message box
// 						var defaultCopyAction = myTable.button(1).action();
// 						myTable.button(1).action(function (e, dt, button, config) {
// 							defaultCopyAction(e, dt, button, config);
// 							$('.dt-button-info').addClass('gritter-item-wrapper gritter-info gritter-center white');
// 						});
						
						
// 						var defaultColvisAction = myTable.button(0).action();
// 						myTable.button(0).action(function (e, dt, button, config) {
							
// 							defaultColvisAction(e, dt, button, config);
							
							
// 							if($('.dt-button-collection > .dropdown-menu').length == 0) {
// 								$('.dt-button-collection')
// 								.wrapInner('<ul class="dropdown-menu dropdown-light dropdown-caret dropdown-caret" />')
// 								.find('a').attr('href', '#').wrap("<li />")
// 							}
// 							$('.dt-button-collection').appendTo('.tableTools-container .dt-buttons')
// 						});
				
// }
</script>

<?php $__env->stopSection(); ?>
<?php $__env->stopSection(); ?>
<?php echo $__env->make('dashboard.layouts.app', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?><?php /**PATH /home/sjslayjy/public_html/devlok/resources/views/dashboard/report/destination-sale-report2.blade.php ENDPATH**/ ?>