Skip to content

Instantly share code, notes, and snippets.

@alpha0293
Last active January 12, 2021 09:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alpha0293/1702c7e3b2d2afe9598a7862113ca1c2 to your computer and use it in GitHub Desktop.
Save alpha0293/1702c7e3b2d2afe9598a7862113ca1c2 to your computer and use it in GitHub Desktop.
public function exportview() //export EXCELL
{
return Excel::download(new DutuExportView, 'users-view.xlsx');
}
<?php
namespace App\Exports;
use App\Dutu;
use Illuminate\Contracts\View\View;
use Maatwebsite\Excel\Concerns\FromView;
class DutuExportView implements FromView
{
public function view(): View
{
return view('admin.dutu.lenlop', [
'lstlenlop' => Dutu::all()->where('idstatus',1)->where('idyear','<>',4),
'index' => 1,
]);
}
}
@extends('admin.layout.layout')
@section('content')
<style type="text/css">
label:not(.form-check-label):not(.custom-file-label) {
float: right;
}
table {
font-family: arial, sans-serif;
border-collapse: collapse;
width: 100%;
}
td, th {
border: 1px solid #dddddd;
text-align: center;
padding: 8px;
}
tr:nth-child(even) {
background-color: #dddddd;
}
</style>
<!-- /.row -->
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<h3 class="card-title" style="color: #0d83c5cc;margin-top: 15px; margin-bottom: 15px;" id="addnhom_title">Danh sách những dự tu đủ điều kiện lên lớp </h3>
<div class="card-header">
<button class="btn btn-primary" onclick="lenlopall()">Cho lên lớp tất cả</button>
</div>
<!-- /.card-header -->
<div class="card-body table-responsive p-0">
<table id="table-post" class="table table-bordered table-hover">
<thead>
<tr>
<th>STT</th>
<th>Tên thánh</th>
<th>Tên thành viên(s)</th>
<th>Ngày sinh</th>
<th>Trường học</th>
<th>Ngành học</th>
<th>Giáo xứ</th>
<th>Năm dự tu</th>
<th>Nhóm</th>
</tr>
</thead>
<tbody>
<tr>
@foreach ($lstlenlop as $i)
<tr>
<input type="hidden" id="iddutu" name="iddutu" value="{{$i->id}}">
<td id="stt">{{$index++}}</td>
<td id="holyname">{{$i->holyname}}</td>
<td id="ten">{{$i->name}}</td>
<td id="ns">{{$i->dob}}</td>
<td id="truong">{{$i->school}}</td>
<td id="nganh">{{$i->majors}}</td>
<td id="xu">{{$i->parish}}</td>
<td id="nam">{{$i->nameyear->name}}</td>
<td id="nhom">{{$i->namezone->name}}</td>
</tr>
@endforeach
</tr>
</tbody>
</table>
</div>
<!-- /.card-body -->
<!-- /.card -->
</div>
</div>
<!-- /.row -->
</div>
</section>
<!-- Bootstrap Switch -->
<script src="{{asset('admin_asset/plugins/bootstrap-switch/js/bootstrap-switch.min.js')}}"></script>
<script type="text/javascript">
function lenlop(id, value) {
console.log(value);
$.post('{{ route('lenlop') }}',
{'_token': "{{ csrf_token() }}",
'id': id,
'value': value }
,function(data){
console.log(data);
// toastr.success('Thành công!!!','THÔNG BÁO');
// console.log(JSON.stringify(data));
});
}
function lenlopall(){
// console.log(value);
$.post('{{ route('lenlopall') }}',
{'_token': "{{ csrf_token() }}",
}
,function(data){
console.log(data);
// toastr.success('Thành công!!!','THÔNG BÁO');
// console.log(JSON.stringify(data));
});
}
</script>
@endsection
@J2TeamNNL
Copy link

Bạn cho mình xem file View cũng như hiển thị file View rồi chụp lại xem nó trông thế nào đã

Cái kia là lỗi do HTML đang không hợp lệ để xuất ra Excel (thường là do không có thẻ table - do nó cốt để lấy table trong View để xuất)

@alpha0293
Copy link
Author

Fixed...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment