dbupdate-dashboard.blade.php 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. @extends('layouts.master')
  2. @section('title', 'DBUpdate')
  3. @section('content')
  4. <div class="content py-0">
  5. <div class="mb-1 text-right d-flex justify-content-end">
  6. <div class="btn-group">
  7. <form action="{{ route('db-update.store') }}" method="POST">
  8. @csrf
  9. <input type="checkbox" name="is_run" id="is-run-check" value="1"><label for="is-run-check">실행</label>
  10. <button type="submit" class="btn btn-sm btn-primary ml-1" data-value="update">
  11. DBUpdate
  12. </button>
  13. </form>
  14. </div>
  15. </div>
  16. <div class="card">
  17. <div class="card-header header-elements-inline">
  18. <div class="header-elements">
  19. <div class="form-check form-check-right form-check-switchery form-check-switchery-sm">
  20. </div>
  21. </div>
  22. </div>
  23. <div class="card-body py-0">
  24. <div class="table-responsive" style="height: 570px">
  25. <table class="table-row" style="min-width: 1000px; table-layout: fixed;">
  26. <thead>
  27. <tr>
  28. <th style="width:5%;">번호</th>
  29. <th style="width:5%;">업데이트번호</th>
  30. <th style="width:5%;">구분</th>
  31. <th style="width:20%;">SQL명령어</th>
  32. <th style="width:5%;">실행승인</th>
  33. </tr>
  34. </thead>
  35. <tbody>
  36. @php $no = count($dbupdateProc['Page'] ?? []) @endphp
  37. @forelse($dbupdateProc['Page'] ?? [] as $dbupdate)
  38. <tr>
  39. <td>{{ $no-- }}</td>
  40. <td>{{ $dbupdate['DbupdateNo'] }}</td>
  41. <td>{{ DataConverter::execute($dbupdate['Sort'], "sort('dbupdate')") }}</td>
  42. <td>{{ $dbupdate['SqlCommand'] }}</td>
  43. <td>{{ DataConverter::execute($dbupdate['IsConfirmed'], 'check') }}</td>
  44. </tr>
  45. @empty
  46. <tr><td class="text-center" colspan="5">{{ _e('No data found') }}</td></tr>
  47. @endforelse
  48. </tbody>
  49. </table>
  50. </div>
  51. </div>
  52. </div>
  53. </div>
  54. @endsection