@extends('backpack::layout')

@section('header')
    <section class="content-header">
        <h1>
            Funded Projects
        </h1>
        <ol class="breadcrumb">
            <li><a href="{{ url(config('backpack.base.route_prefix', 'admin')) }}">{{ config('backpack.base.project_name') }}</a></li>
        </ol>
    </section>
@endsection

@section('content')
    <style type="text/css">
        .margin-top-10px{
            margin-top: 10px;
        }
        .margin-bottom-10px{
            margin-bottom: 10px;
        }
        .desc{
            width: 300px;
        }
    </style>
    <link rel="stylesheet" href="{{ asset('designed/css/pages/admin-table-1.css') }}">

    @include('admin.projects.filter-form', ['skills' => $skills])

    <div class="row">
        <div class="col-md-12">
            <div class="box box-default">
                <table class="table table-bordered">
                    <thead>
                        <tr>
                            <th class="row-number">#</th>
                            <th>Project reference number</th>
                            <th>Project Title</th>
                            <th>Description</th>
                            <th>Client id</th>
                            <th>Client Name</th>
                            <th>Freelancer id</th>
                            <th>Freelancer Name</th>
                            <th>Skills</th>
                            <th>Start Date</th>
                            <th>Project Deadline</th>
                            <th>Project completion Date</th>
                            <th>Cost USD</th>
                            <th>Cost SAR</th>
                        </tr>

                    </thead>
                    <tbody>
                    @foreach($projects as $row_number => $project)
                        <tr>
                            <td class="row-number">{{$row_number + $projects->from_number}}</td>
                            <td>{{$project->id}}</td>
                            <td>{{$project->title}}</td>
                            <td class="desc">{{$project->description}}</td>
                            @if($project->client)
                                <td>
                                    {{ $project->client->id}}
                                </td>
                                <td>
                                    {{ $project->client->user->firstLastName() }}
                                </td>
                            @else
                                <td>-</td>
                                <td>-</td>
                            @endif
                            @if($project->currentFreelancer)
                                <td> {{ $project->currentFreelancer->id }}</td>
                                <td>
                                    {{ $project->currentFreelancer->user->firstLastName() }}
                                </td>
                            @else
                                <td>-</td>
                                <td>-</td>
                            @endif
                            <td>
                                {{ implode(', ', $project->skills->pluck('name')->toArray()) }}
                            </td>
                            <td>{{$project->start_date ? date('d.m.y', strtotime($project->start_date)) : ''}}</td>
                            <td>{{$project->deadline_date ? date('d.m.y', strtotime($project->deadline_date)) : ''}}</td>
                            <td>{{$project->project_completion_date ? date('d.m.y', strtotime($project->project_completion_date)) : ''}}</td>
                            <td>{{$project->rate_per_hour}}</td>
                            <td>{{$project->rate_per_hour * 3.75}}</td>
                        </tr>
                    @endforeach
                    </tbody>

                </table>

            </div>
        </div>
    </div>
    <a href="{{ URL::to('/admin/excel/generate/awarded_project') }}"><button class="btn btn-success">Download Excel</button></a>
@endsection