@extends('stisla.layouts.app-table')

@section('title')
  Ubuntu
@endsection

@section('content')
  <div class="section-header">
    <h1>{{ __('Ubuntu') }}</h1>
  </div>
  <div class="row">

    <div class="col-12">
      <div class="alert alert-info">
        Untuk menggunakan fitur ini pastikan sudah meng-setup supervisor, karena command2 yang dijalankan menggunakan supervisor.
      </div>
      <div class="card">
        <div class="card-header">
          <h4><i class="fa fa-folder"></i> {{ __($path) }}</h4>

          @if ($isGit)
            <div class="card-header-action">
              {{-- @include('stisla.includes.forms.buttons.btn-edit', ['link' => route('ubuntu.git-pull', [encrypt($path)]), 'icon' => 'fab fa-github', 'tooltip' => 'git pull origin']) --}}
              @include('stisla.includes.forms.buttons.btn-edit', [
                  'link' => route('ubuntu.set-laravel-permission', [encrypt($path)]),
                  'icon' => 'fab fa-laravel',
                  'tooltip' => 'set laravel permission',
              ])
            </div>
          @endif
        </div>
        <div class="card-body">

          <form action="{{ route('ubuntu.index') }}" method="GET">
            @csrf
            <div class="row">
              <div class="col-md-6">
                @include('stisla.includes.forms.inputs.input', ['required' => true, 'name' => 'redirect_folder', 'label' => 'Path', 'value' => $path])
              </div>
              <div class="col-md-12">
                @include('stisla.includes.forms.buttons.btn-save', ['label' => 'Let\'s Go'])
                <br>
                <br>
                <br>
                {{-- @if ($isLaravel)
                  <h5>Laravel Projek</h5>
                  <br>
                  <h6>Seeders</h6>
                  <a href="{{ route('ubuntu.laravelSeeder', ['seeder' => 'all', 'folder' => encrypt($path)]) }}" class="btn btn-primary mb-3 btn-sm">Seed All</a>
                  @foreach ($seeders as $seed)
                    <a href="{{ route('ubuntu.laravelSeeder', ['seeder' => $seed, 'folder' => encrypt($path)]) }}" class="btn btn-primary mb-3 btn-sm">{{ $seed }}</a>
                  @endforeach
                  <br>
                  <br>
                  <h6>Migrations</h6>
                  <a href="{{ route('ubuntu.laravelMigrate', ['folder' => encrypt($path)]) }}" class="btn btn-primary btn-sm">Migrate</a>
                  <a href="{{ route('ubuntu.laravelMigrateRefresh', ['folder' => encrypt($path)]) }}" class="btn btn-primary btn-sm">Migrate Refresh</a>
                  <br>
                  <br>
                @endif --}}
              </div>
            </div>
          </form>

          <div class="table-responsive">

            <table class="table table-striped table-hovered" id="datatable">
              <thead>
                <tr>
                  <th class="text-center">#</th>
                  <th class="text-center">{{ __('Name') }}</th>
                  <th class="text-center">{{ __('Path') }}</th>
                  <th class="text-center">{{ __('Type') }}</th>
                  <th class="text-center">{{ __('Aksi') }}</th>
                </tr>
              </thead>
              <tbody>
                @php
                  $i = 1;
                @endphp
                @if ($parentPath)
                  <tr>
                    <td>{{ $i++ }}</td>
                    <td>
                      <a href="?folder={{ encrypt($parentPath) }}">
                        ..
                      </a>
                    </td>
                    <td>
                      <a href="?folder={{ encrypt($parentPath) }}">
                        ..
                      </a>
                    </td>
                    <td>Dir</td>
                    <td></td>
                  </tr>
                @endif
                @foreach ($foldersWww as $item)
                  <tr>
                    <td>{{ $i++ }}</td>
                    <td>
                      <a href="?folder={{ encrypt($item) }}">
                        {{ basename($item) }}
                      </a>
                    </td>
                    <td>
                      <a href="?folder={{ encrypt($item) }}">
                        {{ $item }}
                      </a>
                    </td>
                    <td>Dir</td>
                    <td></td>
                  </tr>
                @endforeach
                @foreach ($filesWww as $item)
                  <tr>
                    <td>{{ $i++ }}</td>
                    <td>
                      <a target="_blank" href="?download={{ encrypt($item->getPathname()) }}">
                        {{ basename($item->getPathname()) }}
                      </a>
                    </td>
                    <td>
                      <a target="_blank" href="?download={{ encrypt($item->getPathname()) }}">
                        {{ $item->getPathname() }}
                      </a>
                    </td>
                    <td>File</td>
                    <td>
                      @include('stisla.includes.forms.buttons.btn-edit', ['link' => route('ubuntu.edit', [encrypt($item->getPathname())])])
                      @include('stisla.includes.forms.buttons.btn-edit', [
                          'link' => route('ubuntu.duplicate', [encrypt($item->getPathname())]),
                          'icon' => 'fa fa-copy',
                          'tooltip' => 'Duplikasi',
                      ])
                      @if (basename($item->getPathname()) === '.env.example' && $isEnvExists === false)
                        @include('stisla.includes.forms.buttons.btn-success', [
                            'link' => route('ubuntu.duplicate', [encrypt($item->getPathname()), 'as' => '.env']),
                            'icon' => 'fa fa-copy',
                            'tooltip' => 'Duplikasi sebagi .env',
                            'size' => 'sm',
                        ])
                      @endif
                      @include('stisla.includes.forms.buttons.btn-delete', ['link' => route('ubuntu.destroy', [encrypt($item->getPathname())])])
                    </td>
                  </tr>
                @endforeach
              </tbody>
            </table>
          </div>
        </div>
      </div>
    </div>

    {{-- supervisor --}}
    <div class="col-12">
      <div class="card">
        <div class="card-header">
          <h4><i class="fa fa-folder"></i> {{ __('Supervisor') }}</h4>
          <div class="card-header-action">
            @if (str_contains($supervisorStatus, 'running'))
              @include('stisla.includes.forms.buttons.btn-primary', ['link' => route('ubuntu.supervisor', ['action' => 'stop']), 'label' => 'Stop Supervisor'])
              @include('stisla.includes.forms.buttons.btn-primary', [
                  'link' => route('ubuntu.supervisor', ['action' => 'restart']),
                  'label' => 'Restart Supervisor',
              ])
            @else
              @include('stisla.includes.forms.buttons.btn-primary', ['link' => route('ubuntu.supervisor', ['action' => 'start']), 'label' => 'Start Supervisor'])
            @endif
          </div>
        </div>
        <div class="card-body">
          <pre>{{ $supervisorStatus }}</pre>
          <div class="table-responsive">

            <table class="table table-striped table-hovered" id="datatable">
              <thead>
                <tr>
                  <th class="text-center">#</th>
                  <th class="text-center">{{ __('Path') }}</th>
                  <th class="text-center">{{ __('Aksi') }}</th>
                </tr>
              </thead>
              <tbody>
                @php
                  $i = 1;
                @endphp
                @foreach ($supervisors as $item)
                  <tr>
                    <td>{{ $i++ }}</td>
                    <td>
                      <a href="?folder={{ encrypt($item) }}">
                        {{ $item }}
                      </a>
                    </td>
                    <td>
                      @include('stisla.includes.forms.buttons.btn-edit', ['link' => route('ubuntu.edit', [encrypt($item)])])
                      @include('stisla.includes.forms.buttons.btn-edit', [
                          'link' => route('ubuntu.duplicate', [encrypt($item)]),
                          'icon' => 'fa fa-copy',
                          'tooltip' => 'Duplikasi',
                      ])
                      @include('stisla.includes.forms.buttons.btn-delete', ['link' => route('ubuntu.destroy', [encrypt($item)])])
                    </td>
                  </tr>
                @endforeach
              </tbody>
            </table>
          </div>
        </div>
      </div>
    </div>

    @foreach ($phps as $php)
      <div class="col-12">
        <div class="card">
          <div class="card-header">
            <h4><i class="fa-brands fa-php"></i> {{ __($php['path']) }}</h4>
            <div class="card-header-action">
              @if (str_contains($php['status_fpm'], 'running'))
                @include('stisla.includes.forms.buttons.btn-primary', ['link' => route('ubuntu.php-fpm', ['version' => $php['version'], 'action' => 'stop']), 'label' => 'Stop FPM'])
                @include('stisla.includes.forms.buttons.btn-primary', [
                    'link' => route('ubuntu.php-fpm', ['version' => $php['version'], 'action' => 'restart']),
                    'label' => 'Restart FPM',
                ])
              @else
                @include('stisla.includes.forms.buttons.btn-primary', ['link' => route('ubuntu.php-fpm', ['version' => $php['version'], 'action' => 'start']), 'label' => 'Start FPM'])
              @endif
            </div>
          </div>
          <div class="card-body">
            <pre>{{ $php['status_fpm'] }}</pre>
            <div class="table-responsive">

              <table class="table table-striped table-hovered" id="datatable">
                <thead>
                  <tr>
                    <th class="text-center">#</th>
                    <th class="text-center">{{ __('Path') }}</th>
                    <th class="text-center">{{ __('Type') }}</th>
                    <th class="text-center">{{ __('Aksi') }}</th>
                  </tr>
                </thead>
                <tbody>
                  @php
                    $i = 1;
                  @endphp
                  @foreach ($php['directories'] as $item)
                    <tr>
                      <td>{{ $i++ }}</td>
                      <td>
                        <a href="?folder={{ encrypt($item) }}">
                          {{ $item }}
                        </a>
                      </td>
                      <td>Dir</td>
                      <td></td>
                    </tr>
                  @endforeach
                </tbody>
              </table>
            </div>
          </div>
        </div>
      </div>
    @endforeach

    <div class="col-12">
      <div class="card">
        <div class="card-header">
          <h4><i class="fa fa-server"></i> {{ __('Nginx Sites Available') }}</h4>
          <div class="card-header-action">
            @if (str_contains($nginxStatus, 'running'))
              @include('stisla.includes.forms.buttons.btn-primary', ['link' => route('ubuntu.nginx', ['nginx' => 'stop']), 'label' => 'Stop Nginx'])
              @include('stisla.includes.forms.buttons.btn-primary', ['link' => route('ubuntu.nginx', ['nginx' => 'restart']), 'label' => 'Restart Nginx'])
            @else
              @include('stisla.includes.forms.buttons.btn-primary', ['link' => route('ubuntu.nginx', ['nginx' => 'start']), 'label' => 'Start Nginx'])
            @endif
          </div>
        </div>
        <div class="card-body">
          <pre>{{ $nginxStatus }}</pre>
          <div class="table-responsive">

            <table class="table table-striped table-hovered" id="datatable">
              <thead>
                <tr>
                  <th class="text-center">#</th>
                  <th class="text-center">{{ __('Filename') }}</th>
                  <th class="text-center">{{ __('Domain') }}</th>
                  <th class="text-center">{{ __('Enabled') }}</th>
                  <th class="text-center">{{ __('SSL') }}</th>
                  <th class="text-center">{{ __('Aksi') }}</th>
                </tr>
              </thead>
              <tbody>
                @foreach ($files as $item)
                  <tr>
                    <td>{{ $loop->iteration }}</td>
                    <td>{{ $item->getFilename() }}</td>
                    <td>
                      <a href="http://{{ $item->domain }}" target="_blank">
                        {{ $item->domain }}
                      </a>
                    </td>
                    <td>
                      @if ($item->enabled)
                        <a href="{{ route('ubuntu.toggle-enabled', [encrypt($item->getPathname()), 'false']) }}" class="btn btn-sm btn-success">true</a>
                      @else
                        <a href="{{ route('ubuntu.toggle-enabled', [encrypt($item->getPathname()), 'true']) }}" class="btn btn-sm btn-danger">false</a>
                      @endif
                    </td>
                    <td>
                      @if ($item->is_ssl)
                        <a href="{{ route('ubuntu.toggle-ssl', [encrypt($item->getPathname()), 'false']) }}" class="btn btn-sm btn-success">true</a>
                      @else
                        <a href="{{ route('ubuntu.toggle-ssl', [encrypt($item->getPathname()), 'true']) }}" class="btn btn-sm btn-danger">false</a>
                      @endif
                    </td>
                    <td>
                      @include('stisla.includes.forms.buttons.btn-edit', ['link' => route('ubuntu.edit', [encrypt($item->getPathname())])])
                      @include('stisla.includes.forms.buttons.btn-edit', [
                          'link' => route('ubuntu.duplicate', [encrypt($item->getPathname())]),
                          'icon' => 'fa fa-copy',
                          'tooltip' => 'Duplikasi',
                      ])
                      @include('stisla.includes.forms.buttons.btn-delete', ['link' => route('ubuntu.destroy', [encrypt($item->getPathname())])])
                    </td>
                  </tr>
                @endforeach
              </tbody>
            </table>
          </div>
        </div>
      </div>
    </div>

    @if (request('database') && request('table'))
      <div class="col-12">

        <div class="section-header">
          <h1>MySQL Database</h1>
          <div class="section-header-breadcrumb">
            <div class="breadcrumb-item active">
              <a href="{{ route('ubuntu.index') }}">{{ __('MySQL') }}</a>
            </div>
            <div class="breadcrumb-item active">
              <a href="{{ route('ubuntu.index', ['database' => request('database')]) }}">{{ request('database') }}</a>
            </div>
            <div class="breadcrumb-item">{{ request('table') }}</div>
          </div>
        </div>

        <div class="card">
          <div class="card-header">
            <h4><i class="fa fa-database"></i> {{ __('MySql Database') }} > {{ request('database') }} > {{ request('table') }}</h4>
            @include('stisla.ubuntu.mysql-action')
          </div>
          <div class="card-body">
            <pre>{{ $mysqlStatus }}</pre>
            <div class="table-responsive">

              <table class="table table-striped table-hovered datatable">
                <thead>
                  <tr>
                    <th class="text-center">#</th>
                    @foreach ($structure as $item)
                      <th class="text-center">{{ $item->column }}</th>
                    @endforeach

                    <th class="text-center">{{ __('Aksi') }}</th>
                  </tr>
                </thead>
                <tbody>
                  @foreach ($rows as $item)
                    <tr>
                      <td>{{ $loop->iteration }}</td>
                      @foreach ($structure as $column)
                        <td>{{ $item->{$column->column} }}</td>
                      @endforeach
                      <td>
                        @include('stisla.includes.forms.buttons.btn-edit', [
                            'link' => route('ubuntu.edit-row', ['database' => request('database'), 'table' => request('table'), 'id' => $item->{$primary}, 'primary' => $primary]),
                        ])
                        @include('stisla.includes.forms.buttons.btn-edit', [
                            'link' => route('ubuntu.edit-row', [
                                'database' => request('database'),
                                'table' => request('table'),
                                'id' => $item->{$primary},
                                'primary' => $primary,
                                'json' => 'true',
                            ]),
                            'icon' => 'fa fa-code',
                            'tooltip' => 'Lihat Json',
                        ])
                        @include('stisla.includes.forms.buttons.btn-delete', [
                            'link' => route('ubuntu.delete-row', ['database' => request('database'), 'table' => request('table'), 'id' => $item->{$primary}]),
                            'primary' => $primary,
                        ])
                      </td>
                    </tr>
                  @endforeach
                </tbody>
              </table>
            </div>
          </div>
        </div>
      </div>
    @elseif (request('database'))
      <div class="col-12">
        <div class="section-header">
          <h1>MySQL Database</h1>
          <div class="section-header-breadcrumb">
            <div class="breadcrumb-item active">
              <a href="{{ route('ubuntu.index') }}">{{ __('MySQL') }}</a>
            </div>
            <div class="breadcrumb-item">{{ request('database') }}</div>
          </div>
        </div>

        <div class="card">
          <div class="card-header">
            <h4><i class="fa fa-database"></i> {{ __('MySql Database') }} > {{ request('database') }}</h4>
            @include('stisla.ubuntu.mysql-action')
          </div>
          <div class="card-body">
            <pre>{{ $mysqlStatus }}</pre>
            <div class="table-responsive">

              <table class="table table-striped table-hovered datatable">
                <thead>
                  <tr>
                    <th class="text-center">#</th>
                    <th class="text-center">{{ __('Tabel') }}</th>
                    <th class="text-center">{{ __('Size') }}</th>
                    <th class="text-center">{{ __('Rows') }}</th>
                    <th class="text-center">{{ __('Aksi') }}</th>
                  </tr>
                </thead>
                <tbody>
                  @foreach ($tables as $item)
                    <tr>
                      <td>{{ $loop->iteration }}</td>
                      <td>{{ $item->table }}</td>
                      <td>{{ $item->size_mb }} Mb</td>
                      <td>{{ $item->total_row }}</td>
                      <td>
                        @include('stisla.includes.forms.buttons.btn-edit', [
                            'link' => route('ubuntu.index', ['database' => request('database'), 'table' => $item->table]),
                            'icon' => 'fa fa-table',
                            'tooltip' => 'Lihat Data',
                        ])
                        @include('stisla.includes.forms.buttons.btn-edit', [
                            'link' => route('ubuntu.index', ['database' => request('database'), 'table' => $item->table, 'action' => 'json']),
                            'icon' => 'fa fa-code',
                            'tooltip' => 'Lihat JSON',
                        ])
                        @include('stisla.includes.forms.buttons.btn-success', [
                            'link' => route('ubuntu.index', ['database' => request('database'), 'table' => $item->table, 'action' => 'json-download']),
                            'icon' => 'fa fa-code',
                            'tooltip' => 'Download JSON',
                            'size' => 'sm',
                        ])
                        @include('stisla.includes.forms.buttons.btn-danger', [
                            'link' => route('ubuntu.mysql-paginate', ['database' => request('database'), 'table' => $item->table, 'action' => 'json-paginate']),
                            'icon' => 'fa fa-code',
                            'tooltip' => 'Paginate JSON',
                            'size' => 'sm',
                        ])
                      </td>
                    </tr>
                  @endforeach
                </tbody>
              </table>
            </div>
          </div>
        </div>
      </div>
    @else
      <div class="col-12">
        <div class="section-header">
          <h1>MySQL Database</h1>
          <div class="section-header-breadcrumb">
            <div class="breadcrumb-item active">
              <a href="{{ route('ubuntu.index') }}">{{ __('MySQL') }}</a>
            </div>
          </div>
        </div>
        <div class="card">
          <div class="card-header">
            <h4><i class="fa fa-database"></i> {{ __('MySql Database') }}</h4>
            @include('stisla.ubuntu.mysql-action')
          </div>
          <div class="card-body">
            <pre>{{ $mysqlStatus }}</pre>
            <form action="{{ route('ubuntu.create-db') }}" method="POST">
              @csrf
              <div class="row">
                <div class="col-md-6">
                  @include('stisla.includes.forms.inputs.input', ['required' => true, 'name' => 'database_name', 'label' => 'Nama Database'])
                </div>
                <div class="col-md-12">
                  @include('stisla.includes.forms.buttons.btn-save', ['label' => 'Buat Database Baru'])
                  <br>
                  <br>
                  <br>
                </div>
              </div>
            </form>

            <div class="table-responsive">

              <table class="table table-striped table-hovered datatable">
                <thead>
                  <tr>
                    <th class="text-center">#</th>
                    <th class="text-center">{{ __('Database') }}</th>
                    <th class="text-center">{{ __('Tabel') }}</th>
                    <th class="text-center">{{ __('Size') }}</th>
                    <th class="text-center">{{ __('Aksi') }}</th>
                  </tr>
                </thead>
                <tbody>
                  @foreach ($databases as $item)
                    <tr>
                      <td>{{ $loop->iteration }}</td>
                      <td>{{ $item->database }}</td>
                      <td>{{ $item->total_table }}</td>
                      <td>{{ $item->size_mb }} Mb</td>
                      <td>
                        @include('stisla.includes.forms.buttons.btn-edit', [
                            'link' => route('ubuntu.index', ['database' => $item->database]),
                            'icon' => 'fa fa-table',
                            'tooltip' => 'Lihat Tabel',
                        ])
                        @include('stisla.includes.forms.buttons.btn-danger', [
                            'link' => route('ubuntu.index', ['database' => $item->database, 'action' => 'delete_db']),
                            'icon' => 'fa fa-trash',
                            'tooltip' => 'Hapus',
                        ])
                      </td>
                    </tr>
                  @endforeach
                </tbody>
              </table>
            </div>
          </div>
        </div>
      </div>
    @endif


  </div>
@endsection