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">Party Aging Report</li>
			</ul>
		</div>
		<div class="page-content">
			<h3 class="header smaller lighter blue">Party Aging Report</h3>

<div class="col-md-3">
								<div class="form-group">
									<label for="master_rake_id">Dealers</label>
									<select class="form-control select2" name="dealer_id" id="dealer_id">
										<option value="">Select Dealers</option>
										<?php $__currentLoopData = $dealers; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $dealer): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
										<option value="<?php echo e($dealer->id); ?>" <?php echo e(isset($dealer_id) && $dealer_id==$dealer->id ? "selected":""); ?>><?php echo e($dealer->name); ?></option>
										<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
									</select>
									<?php if($errors->has('dealer_id')): ?>
									<span class="label label-danger"><?php echo e($errors->first('dealer_id')); ?></span>
									<?php endif; ?>
								</div>
							</div>
							<div class="col-md-3">
								<div class="form-group">
									<button type="submit" class="btn btn-primary">Submit</button>
								</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; ?>

<?php $__currentLoopData = $dealers; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $dealer): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
					<?php if(isset($dealerdata) && $dealer->id == $dealerdata): ?>

<div class="table-header">
						<?php echo e($dealer->name); ?> (<?php echo e($dealer->address1); ?>)
					</div>

<div class="table-responsive">
						<div class="dataTables_borderWrap">
							<table id="dynamic-table" class="table table-striped table-bordered table-hover">
								<thead>
									<tr>
										<th colspan="2">Debitors Total</th>
										<th>15 Days</th>
										<th>30 Days</th>
										<th>45 Days</th>
										<th>60 Days</th>
										<th>75 Days</th>
										<th>90 Days</th>
										<th>Over 90 Days</th>
										<th></th>

</tr>
									<tr>
										<th></th>
										<th>Total Amount</th>
										<th>Pending Amount</th>
										<th>Pending Amount</th>
										<th>Pending Amount</th>
										<th>Pending Amount</th>
										<th>Pending Amount</th>
										<th>Pending Amount</th>
										<th>Pending Amount</th>
										<th>Total Pending Amount</th>
									</tr>
								</thead>

<tbody>
									<?php $__currentLoopData = $product_categories; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $product_category): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
									<tr>
										<td> <?php echo e($product_category->category); ?></td>
										<td>
											<?php
											$loading_slip_invoices = \App\LoadingSlipInvoice::where('dealer_id',$dealer->id)
											->whereIn('product_id',$product_category->products->pluck('id'))
											->whereDate('created_at','<=',date('Y-m-d'))
											->get();
											$total_amount = 0;
											foreach($loading_slip_invoices as $loading_slip_invoice){
											$total_amount = $total_amount + ($loading_slip_invoice->total);
										}
										?>
										<?php if($total_amount): ?>
										<a target="_blank" href='<?php echo e(URL("/user/outstating-total-amount-details/$dealer->id/$product_category->id")); ?>'><?php echo e($total_amount); ?></a>
										<?php else: ?>
										<?php echo e($total_amount); ?>

<?php endif; ?>
									</td>
									<td>
										<?php
										$total_pending_amount = 0;
										$current_date = date('Y-m-d');
										$last_15_date = date('Y-m-d',strtotime('-15 days'));
										$loading_slip_invoices = \App\LoadingSlipInvoice::where('dealer_id',$dealer->id)
										->whereIn('product_id',$product_category->products->pluck('id'))
										->whereBetween('created_at',array($last_15_date,$current_date))
										->get();
										$total_amount = 0;
										foreach($loading_slip_invoices as $loading_slip_invoice){
										$total_amount = $total_amount + ($loading_slip_invoice->remaining_amount);

}
									?>
									<?php if($total_amount): ?>
									<a target="_blank" href='<?php echo e(URL("/user/outstating-remaining-amount-details/$dealer->id/$product_category->id/$current_date/$last_15_date")); ?>'><?php echo e($total_amount); ?></a>
									<?php else: ?>
									<?php echo e($total_amount); ?>

<?php endif; ?>
								</td>
								<td>
									<?php
									$last_30_date = date('Y-m-d',strtotime(' -30 days',strtotime($last_15_date)));
									$loading_slip_invoices = \App\LoadingSlipInvoice::where('dealer_id',$dealer->id)
									->whereIn('product_id',$product_category->products->pluck('id'))
									->whereBetween('created_at',array($last_15_date,$last_30_date))
									->get();
									$total_amount = 0;
									foreach($loading_slip_invoices as $loading_slip_invoice){
									$total_amount = $total_amount + ($loading_slip_invoice->remaining_amount);

}
								?>
								<?php if($total_amount): ?>
								<a target="_blank" href='<?php echo e(URL("/user/outstating-remaining-amount-details/$dealer->id/$product_category->id/$last_15_date/$last_30_date")); ?>'><?php echo e($total_amount); ?></a>
								<?php else: ?>
								<?php echo e($total_amount); ?>

<?php endif; ?>
							</td>
							<td>
								<?php
								$last_45_date = date('Y-m-d',strtotime(' -45 days',strtotime($last_30_date)));
								$loading_slip_invoices = \App\LoadingSlipInvoice::where('dealer_id',$dealer->id)
								->whereIn('product_id',$product_category->products->pluck('id'))
								->whereBetween('created_at',array($last_45_date,$last_30_date))
								->get();
								$total_amount = 0;
								foreach($loading_slip_invoices as $loading_slip_invoice){
								$total_amount = $total_amount + ($loading_slip_invoice->remaining_amount);

}
							?>
							<?php if($total_amount): ?>
							<a target="_blank" href='<?php echo e(URL("/user/outstating-remaining-amount-details/$dealer->id/$product_category->id/$last_30_date/$last_45_date")); ?>'><?php echo e($total_amount); ?></a>
							<?php else: ?>
							<?php echo e($total_amount); ?>

<?php endif; ?>
						</td>
						<td>
							<?php
							$last_60_date =date('Y-m-d',strtotime(' -60 days',strtotime($last_45_date)));

$loading_slip_invoices = \App\LoadingSlipInvoice::where('dealer_id',$dealer->id)
							->whereIn('product_id',$product_category->products->pluck('id'))
							->whereBetween('created_at',array($last_45_date,$last_60_date))
							->get();
							$total_amount = 0;
							foreach($loading_slip_invoices as $loading_slip_invoice){
							$total_amount = $total_amount + ($loading_slip_invoice->remaining_amount);

}
						?>
						<?php if($total_amount): ?>
						<a target="_blank" href='<?php echo e(URL("/user/outstating-remaining-amount-details/$dealer->id/$product_category->id/$last_45_date/$last_60_date")); ?>'><?php echo e($total_amount); ?></a>
						<?php else: ?>
						<?php echo e($total_amount); ?>

<?php endif; ?>
					</td>
					<td>
						<?php
						$last_75_date =date('Y-m-d',strtotime(' -75 days',strtotime($last_60_date)));

$loading_slip_invoices = \App\LoadingSlipInvoice::where('dealer_id',$dealer->id)
						->whereIn('product_id',$product_category->products->pluck('id'))
						->whereBetween('created_at',array($last_75_date,$last_60_date))
						->get();
						$total_amount = 0;
						foreach($loading_slip_invoices as $loading_slip_invoice){
						$total_amount = $total_amount + ($loading_slip_invoice->remaining_amount);

}
					?>
					<?php if($total_amount): ?>
					<a target="_blank" href='<?php echo e(URL("/user/outstating-remaining-amount-details/$dealer->id/$product_category->id/$last_60_date/$last_75_date")); ?>'><?php echo e($total_amount); ?></a>
					<?php else: ?>
					<?php echo e($total_amount); ?>

<?php endif; ?>
				</td>
				<td>
					<?php
					$last_90_date =date('Y-m-d',strtotime(' -90 days',strtotime($last_75_date)));

$loading_slip_invoices = \App\LoadingSlipInvoice::where('dealer_id',$dealer->id)
					->whereIn('product_id',$product_category->products->pluck('id'))
					->whereBetween('created_at',array($last_75_date,$last_90_date))
					->get();
					$total_amount = 0;
					foreach($loading_slip_invoices as $loading_slip_invoice){
					$total_amount = $total_amount + ($loading_slip_invoice->remaining_amount);

}
				?>
				<?php if($total_amount): ?>
				<a target="_blank" href='<?php echo e(URL("/user/outstating-remaining-amount-details/$dealer->id/$product_category->id/$last_75_date/$last_90_date")); ?>'><?php echo e($total_amount); ?></a>
				<?php else: ?>
				<?php echo e($total_amount); ?>

<?php endif; ?>
			</td>
			<td>
				<?php
				$last_365_date =date('Y-m-d',strtotime(' -365 days',strtotime($last_90_date)));

$loading_slip_invoices = \App\LoadingSlipInvoice::where('dealer_id',$dealer->id)
				->whereIn('product_id',$product_category->products->pluck('id'))
				->whereBetween('created_at',array($last_365_date,$last_90_date))
				->get();
				$total_amount = 0;
				foreach($loading_slip_invoices as $loading_slip_invoice){
				$total_amount = $total_amount + ($loading_slip_invoice->remaining_amount);

}
			?>
			<?php if($total_amount): ?>
			<a target="_blank" href='<?php echo e(URL("/user/outstating-remaining-amount-details/$dealer->id/$product_category->id/$last_90_date/$last_365_date")); ?>'><?php echo e($total_amount); ?></a>
			<?php else: ?>
			<?php echo e($total_amount); ?>

<?php endif; ?>
		</td>
		<td>
			<?php echo e($total_pending_amount); ?>

</td>
		</tr
		>
		<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
	</tbody>
</table>
</div>
</div>
<?php endif; ?>

<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
</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 $__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/pmmsanvp/public_html/srt/resources/views/dashboard/report/outstanding-report.blade.php ENDPATH**/ ?>