Catatan Mahasiswa : import export data into excel

Aturannya :

Saya Menggunakan :
Php Versi (7.2.6)
Laravel Versi (5.5)

1. Masukan kedalam composer.json=> "maatwebsite/excel": "~2.1.0"

2. Buka config/app.php

kemudian ketikan di terminal=> composer update

3. Buat Controller dengan file DataKaryawanController.php

<?php
namespace App\Http\Controllers\admin;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Redirect;
use App\Product;
use App\DataKaryawan;

class ExcelController extends Controller
{
 /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function importExportView(){
        return view('import_export');
    }
    /**
     * Create a new controller instance.
     *
     * @return void
     */
    public function importFile(Request $request){
        if($request->hasFile('sample_file')){
            $path = $request->file('sample_file')->getRealPath();
            $data = \Excel::load($path)->get();
            if($data->count()){
                foreach ($data as $key => $value) {
                    $arr[] = ['title' => $value->title, 'body' => $value->body];
                }
                if(!empty($arr)){
                    DB::table('products')->insert($arr);
                    dd('Insert Recorded successfully.');
                }
            }
        }
        dd('Request data does not have any files to import.');      
    } 
    /**
     * Create a new controller instance.
     *
     * @return void
     */

public function exportFile($type){
        $products = Product::get()->toArray();
        return \Excel::create('hdtuto_demo', function($excel) use ($products) {
            $excel->sheet('sheet name', function($sheet) use ($products)
            {
                $sheet->fromArray($products);
            });

})->download($type);
    }      
}

4.Tambahkan pada routes=>web.php

5. Buat File didalam folder views simpan dengan perhitungangaji.blade.php

@extends('layouts.admin')

@section('content')
<section class="content-header">
 <h1>
    Data Karyawan
 </h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i>Home</a></li>
<li class="active"><a href="{{URL::to('datakaryawan/index')}}">List Data Karyawan</a></li>
</ol>
</section>

<section class="content">
   <div class="row">
     <div class="col-md-12">
      <div class="pull-left">
    {!! Form::open(['method'=>'GET','url'=>'/searchdatakaryawan','role'=>'search'])  !!}
     <div class='form-group clearfix'>
      <div class='col-md-10'>
                   <div class="input-group custom-search-form">
                     <input type="text" class="form-control" name="search" placeholder="Search...">
                       <span class="input-group-btn">
                        <span class="input-group-btn">
                <button class="btn btn-default" type="submit"><i class="fa fa-search"></i> Search</button>
             </span>
                       </span>
                   </div>
</div>
</div>
{!! Form::close() !!}
   </div>
<div class="row">
      <div class="col-xs-12 col-sm-12 col-md-12">
        
      </div>
</div>
<div class='pull-right'>
    <button type="button" class="btn btn-default btn-sm">
             <a href="{{ route('export.file_karyawan',['type'=>'xls']) }}"> <span class="glyphicon glyphicon-save-file"></span> Save File </a>
          </button>
   </div>
<br>
    
   <table class="table table-striped table-hover">
    <thead>
<tr>
      <th>No.</th>
            <th><b>Nama</b></th>
            <th><b>NIP/NIDN</b></th>
            <th><b>Gaji</b></th>
            <th><b>Tunjangan</b></th>
            <th><b>Total Gaji</b></th>
     </tr>
</thead>

<status>
       @foreach($data_karyawan as $i=>$data_karyawans)
<tr>
           <td>{{$i+1}}</td>
             <td> {{ $data_karyawans->nama_lengkap }} </td>
             <td> {{ $data_karyawans->nip }} </td>
             <td> {{ $data_karyawans->gaji }} </td>
             <td> {{ $data_karyawans->gaji*0.01 }} </td>
             <td> {{ $data_karyawans->gaji*0.01 + $data_karyawans->gaji+400000 }} </td>
          </tr>
@endforeach
    </tstatus>
   </table>
</div>
</div>
</section>
@endsection

Catatan Mahasiswa

Selasa, 26 Juni 2018

import export data into excel

Tidak ada komentar:

Posting Komentar