<?php $__env->startSection('title', 'Jobs List'); ?>

<?php $__env->startSection('content'); ?>
	<div class="panel panel-default">	
		<div class="panel-heading">
			<h3 class="panel-title"><i class="fa fa-briefcase"></i> Jobs</h3>
		</div>
		
		<div class="panel-body">
			<?php if(Session::has('message')): ?>
				<div class="alert alert-success alert-dismissable" role="alert">
					<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>
					<i class="fa fa-check"></i> <?php echo Session::get('message'); ?>

				</div>
			<?php endif; ?>
		
			<div class="row">
				<div class="col-md-9">
					<p>Here you can add, view, edit and delete any jobs created in the past 28 days.</p>
					<p>You can delete a job on its 'view' or 'edit' page.</p>
				</div>
				<div class="col-md-3">
					<a href="/jobs/create" class="btn btn-primary btn-block"><i class="fa fa-plus"></i> Add A Job</a>
				</div>
			</div>
		</div>
		
		<table id="jobs-list" class="table table-hover table-sortable display">
			<thead>
				<tr>
					<th>Job Number</th>
					<th>Account Code</th>
					<th>Company</th>
					<th>Customer</th>
					<th>Administrator</th>
					<th>Status</th>
					<th>View</th>
					<th>Edit</th>
				</tr>
			</thead>
			<tbody>
				<?php foreach($jobs as $job): ?>
					<?php
						$query = '
							SELECT group_concat(status SEPARATOR "") as job_status
							FROM artworks a
							WHERE NOT EXISTS (
								SELECT *
								FROM artworks aa
								WHERE a.product=aa.product AND a.revision < aa.revision
							)
							AND deleted_at IS NULL
							AND job_id = ' . $job->id;
							
						$current_artworks = DB::select($query);
						$jobstatus = $current_artworks[0]->job_status;
						
						if(empty($jobstatus)) { $rowclass = 'bg-warning'; $jobstatus_display = '<i class="fa fa-fw fa-exclamation-triangle"></i> No artwork'; }
						elseif(strpos($jobstatus, 'P') !== false) { $rowclass = 'pending'; $jobstatus_display = '<i class="fa fa-fw fa-clock-o"></i> Pending'; }
						elseif(strpos($jobstatus, 'R') !== false) { $rowclass = 'bg-danger'; $jobstatus_display = '<i class="fa fa-fw fa-times"></i> Rejected'; }					
						elseif(strpos($jobstatus, 'A') !== false) { $rowclass = 'bg-success'; $jobstatus_display = '<i class="fa fa-fw fa-check"></i> Approved'; }
					?>
					<tr class="<?php echo $rowclass; ?>">
						<td><?php echo $job->jobnumber; ?></td>
						<td><?php echo $job->contact->company->accountcode; ?></td>
						<td><?php echo $job->contact->company->name; ?></td>
						<td><?php echo $job->contact->name; ?></td>
						<td><?php echo $job->administrator->name; ?></td>
						<td><?php echo $jobstatus_display; ?></td>
						<td><a href="jobs/<?php echo $job->id ?>" class="btn btn-sm btn-default"><i class="fa fa-eye"></i> View</a></td>
						<td><a href="jobs/<?php echo $job->id ?>/edit" class="btn btn-sm btn-default"><i class="fa fa-pencil-square-o"></i> Edit</a></td>
					</tr>	
				<?php endforeach; ?>
			</tbody>
		</table>
	</div>	
<?php $__env->stopSection(); ?>

<?php echo $__env->make('layout', array_except(get_defined_vars(), array('__data', '__path')))->render(); ?>