@extends("layout")
@section("content")

<div class="row">
	<div class="col-lg-2 col-xs-3">
		<div class="small-box bg-blue">
			<div class="inner">
				<p>You Have</p>
				<h3>{{ $count = Inhouse::where('user_id', '=', Auth::user()->id)->orWhere('incharge_mail', '=', Auth::user()->email)->count()}}</h3>
				<p> Requests</p>
			</div>
			<div class="icon">
				<i class="ion-social-dropbox	"></i>
			</div>
			<a href="{{URL::route('inhouserequest.index')}}" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
		</div>
	</div>
	<div class="col-lg-2 col-xs-3">
		<div class="small-box bg-orange">
			<div class="inner">
				<h3>{{ $count = Inhouse::where('request_status_id', '=', '0')->count()}}</h3>

				<p>Pending Requests</p>
			</div>
			<div class="icon">
				<i class="fa fa-circle-o-notch fa-spin fa-1x fa-fw"></i>
			</div>
			<a href="{{URL::route('inhouserequest.approved')}}" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
		</div>
	</div>

	<div class="col-lg-2 col-xs-3">
		<div class="small-box bg-gray">
			<div class="inner">

				<h3>{{ $count = Inhouse::where('request_status_id', '=', '1')->count()}}</h3>
				<p>APPROVED REQUESTS</p>
			</div>
			<div class="icon">
				<i class="ion-android-checkmark-circle"></i>
			</div>

		</div>
	</div>

	<div class="col-lg-2 col-xs-3">
		<div class="small-box bg-green">
			<div class="inner">
				<h3>{{ $count = Inhouse::where('request_status_id', '=', '1')->count()}}<sup style="font-size: 20px">%</sup></h3>

				<p>Requests Approved By Stores</p>
			</div>
			<div class="icon">
				<i class="ion-android-checkmark-circle"></i>
			</div>
			<a href="{{URL::route('inhouserequest.approved')}}" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
		</div>
	</div>

	<div class="col-lg-2 col-xs-3">
		<div class="small-box bg-aqua">
			<div class="inner">
				<h3>{{ $count = Inhouse::where('request_status_id', '=', '3')->count()}}</h3>

				<p>ISSUED REQUESTS</p>
			</div>
			<div class="icon">
				<i class="ion-ios-cart"></i>
			</div>
			<a href="#" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
		</div>
	</div>

	<div class="col-lg-2 col-xs-3">
		<!-- small box -->
		<div class="small-box bg-red">
			<div class="inner">
				<h3>{{ $count = Inhouse::where('request_status_id', '=', '2')->count()}}</h3>

				<p>REJECTED REQUESTS</p>
			</div>
			<div class="icon">
				<i class="ion-android-close"></i>
			</div>
			<a href="#" class="small-box-footer">More info <i class="fa fa-arrow-circle-right"></i></a>
		</div>
	</div>
</div>

<div class="row">
	<div class="col-md-12">
		<div class="box">
			<div class="box box-info">
				<div class="box-header with-border">
					<h3 class="box-title">Approved Dept Requests</h3><br><br>
					<a href="{{ URL::route('inhouserequest.inhousecreate') }}" class="btn btn-sm btn-info btn-flat pull-left">Place New Order</a>

					<div class="box-tools pull-right">
						<button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i>
						</button>
						<button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button>
					</div>
				</div>
				<div class="box-body">
					<div class="table-responsive">
						<table id='example1' class="table table-striped table-hover table-bordered search-table">
							<thead>
								<tr>
									<th class="text-center">#</th>
									<th class="text-center">Voucher Number</th>
									<th class="text-center">Item</th>
									<th class="text-center">Quantity</th>
									<th class="text-center">Requested By</th>
									<th class="text-center">Department</th>
									<th class="text-center">Request Date</th>
									<th class="text-center">Status</th>
									<th class="text-center"></th>
								</tr>
							</thead>

							<tbody>

																@foreach($approved as $value)
								<tr>
									<td class="text-center">{{ $row}}</td>
									<td class="text-center">{{$value->folio_number}}</td>

									@if($value->commodity_id == 0)
									<td class="text-center" style="color:red"><i>no commodity selected</i></td>
									@else
									<td>{{ $value->commodity->name}}</td>
									@endif

									<td class="text-center">{{ $value->quantity }} <i>({{$value->commodity->metric->name}})</i></td>
									<td>{{ $value->user->name}}</td>
									@if($value->department == '')
									<td class="text-center" style="color:red"><i>no dept selected</i></td>
									@else
									<td>{{ $department[$value->department] }}</td>
									@endif
									<td class="text-center">{{ $value->created_at }}</td>

									<td>
										<span class='label label-warning'>Pending</span>
									</td>
									<td>
										@if(Auth::user()->id == $value->user_id && $value->isPending())
										<!-- Delete or edit only what you have initiated -->
										<button class="btn btn-sm btn-danger delete-item-link" data-toggle="modal" data-target=".confirm-delete-modal"
										data-id="{{ URL::route('inhouserequest.delete', array($value->id)) }}">
										<span class="glyphicon glyphicon-trash"></span>
										{{trans('messages.delete')}}
									</button>
									<a class="btn btn-sm btn-info" href="{{ URL::route('inhouserequest.edit', array($value->id)) }}" >
										<span class="glyphicon glyphicon-edit"></span>{{trans('messages.edit')}}</a>

										@elseif(Entrust::can('approve_dept_request') && $value->request_status_id =='0' && Auth::user()->id != $value->user_id &&  $value->incharge_mail == Auth::user()->email)
										<a class="btn btn-sm btn-danger" href="{{ URL::route('inhouserequest.reject', array($value->id)) }}"title="Reject request">
											<span class="glyphicon glyphicon-thumbs-down"></span>	Reject</a>
											<a class="btn btn-sm btn-success" href="{{ URL::route('inhouserequest.approve', array($value->id)) }}"title="Approve Requisition">
												<span class="glyphicon glyphicon-thumbs-up"></span>	Approve	</a>
												@endif
											</td>
										</tr>
																				@endforeach
									</tbody>

								</table>