@extends('layouts.app')

@section('content')
<div class="page-title">
        <div class="row">
            <div class="col-12 col-md-6 order-md-1 order-last">
                <h3>Data Payroll</h3>
                
            </div>
            <div class="col-12 col-md-6 order-md-2 order-first">
                <nav aria-label="breadcrumb" class="breadcrumb-header float-start float-lg-end">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="index.html">Dashboard</a></li>
                        <li class="breadcrumb-item active" aria-current="page">Payroll</li>
                    </ol>
                </nav>
            </div>
        </div>
    </div>
    <section class="section" x-data="main" @reload-table.window="table.draw()">
		<div class="card">
            <div class="card-header">
                DATA PAYROLL
                <div class="float-end">
                    <button class="btn btn-info" @click="doImport" data-id="0"><span class="bi bi-file">IMPORT</span></button>
                    <button class="btn btn-success" @click="doExport" data-id="0"><span class="bi bi-file">EXPORT</span></button>
                    <button class="btn btn-info" @click="prosesCetakSlip" ><span class="bi bi-file">CETAK SLIP</span></button>
                </div>
                <div class="clearfix"></div>
            </div>
            <div class="card-body">
                <div class="form-group row">
                    
                        <div class="col-md-2">
                            <label>Bulan</label>
                            <select class="form-select" x-model="attr.month">
                                @foreach(getAllMonths() as $k=>$v)
                                <option value="{{ $k }}">{{ $v }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label>Tahun</label>
                            <select class="form-select" x-model="attr.year">
                                @for($year=date('Y');$year >= date('Y',strtotime('-2 years'));$year--)
                                <option>{{ $year }}</option>
                                @endfor
                            </select>
                        </div>
                        <div class="col-md-3">
                            <label>Manager Area</label>
                            <select class="form-select" x-model="attr.area" @change="onAreaChange">
                                <option value="">-- All Area --</option>
                                @foreach($area as $row)
                                <option value="{{ $row->id }}">{{ $row->nama }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-3">
                            <label>Cabang</label>
                            <select class="form-select" x-model="attr.lokasi" >
                                <option value="">-- All Cabang --</option>
                                <template x-for="(row,index) in attr.listLokasi" :key="row.id">
                                <option :value="row.id" x-text="row.nama"></option>
                                </template>
                            </select>
                        </div>
                        <div class="col-2">
                            <label class="d-block">&nbsp;</label>
                            <button class="btn btn-primary" @click="table.draw()">FILTER</button>
                        </div>
                    
                </div>	
               
                <div class="col-12 col-lg-12">
                    <table class="table table-striped table-bordered" id="datatables" width="2500px">
                        <thead>
                            <tr>
                                <th rowspan="2">Aksi</th>
                                <th rowspan="2">Nik</th>
                                <th rowspan="2">Nama</th>
                                <th rowspan="2">Jabatan</th>
                                <th rowspan="2">Cabang</th>
                                <th rowspan="2">Bulan Gaji</th>
                                <th rowspan="2">Jumlah Hari</th>
                                <th rowspan="2">Jumlah Absen</th>
                                <th rowspan="2">Jumlah Sakit</th>
                                <th rowspan="2">Jumlah Cuti</th>
                                <th rowspan="2">Jumlah Libur</th>
                                <th colspan="8"><center>Pendapatan(Bruto)</center></th>
                                <th colspan="4"><center>Pemotongan</center></th>
                                <th rowspan="2">Total Gaji</th>
                            </tr>
                            <tr>
                                <th>Gaji Pokok</th>
                                <th>Uang makan</th>
                                <th>Lembur</th>
                                <th>Lembur Libur</th>
                                <th>Bonus</th>
                                <th>Bonus Plus</th>
                                <th>Bonus Loyalitas</th>
                                <th>Tunjangan Jabatan</th>
                                <th>Tabungan</th>
                                <th>Kasbon Bayar</th>
                                <th>Kasbon Kue</th>
                                <th>Lain-lain</th>
                            </tr>
                        </thead>
                    </table>
                </div>
			</div>
		</div>

        @include("pages.payroll.export")
        @include("pages.payroll.import")
        @include("pages.payroll.edit")
        
	</section>
    
@endsection


@push('scripts')
<script src="{{ asset('template/assets/js/form-binding.min.js') }}"></script>
	<script>
		document.addEventListener("alpine:init",() => {
			Alpine.data("main",() => ({
                table:null,
                attr: {
                    year:"{{ date('Y') }}",
                    month:"{{ date('m') }}",
                    area:"",
                    lokasi:"",
                    listLokasi:[]
                },
                init() {
                    this.table = $('#datatables').DataTable({
                        serverSide:true,
                        processing:true,
                        scrollY: (screen.height * 0.6),
                        scrollX: true,
                        ajax:{
                            method:"POST",
                            url:"{{ url('payroll/data') }}",
                            data: (d) => {
                                d.bulan = this.attr.month;
                                d.tahun = this.attr.year;
                                d.area = this.attr.area;
                                d.lokasi = this.attr.lokasi;
                            }
                        },
                        columns:[
                            {data:"aksi",render:(data,type,row) => {
                                var button = "";
                                    button += `<li><a class="dropdown-item" href="#" @click="viewSlip" data-nik="${row.nik}" data-bulan="${row.bulan_gaji}">SLIP GAJI</a></li>`;
                                    button += `<li><a class="dropdown-item" href="#" @click="editData" data-id="${row.id}">EDIT</a></li>`;
                                    button += `<li><a class="dropdown-item" href="#" @click="delData" data-id="${row.id}">DELETE</a></li>`;
                                return `<div class="dropdown">
                                      <button class="btn btn-primary btn-sm dropdown-toggle" type="button" id="dropdownMenuButton1" data-bs-toggle="dropdown" aria-expanded="false">
                                        AKSI
                                      </button>
                                      <ul class="dropdown-menu dropdown-menu-dark" aria-labelledby="dropdownMenuButton1">
                                        ${button}
                                      </ul>
                                    </div>`
                            },searchable:false,orderable:false},
                            {data:"nik"},
                            {data:"nama"},
                            {data:"karyawan.jabatan.nama",render:(data,type,row) => {
                               
                                if (row.karyawan.jabatan != null) {
                                    return data;
                                }
                                
                                
                                return "";
                            }},
                            {data:"lokasi"},
                            {data:"bulan_gaji"},
                            {data:"jumlah_hari_bulan"},
                            {data:"jumlah_hari"},
                            {data:"jumlah_sakit"},
                            {data:"jumlah_cuti"},
                            {data:"jumlah_libur"},
                            {data:"gaji_pokok",render:(data) => {
                                return formatNumber(data)
                            }},
                            {data:"uang_makan",render:(data) => {
                                return formatNumber(data)
                            }},
                            {data:"lembur",render:(data) => {
                                return formatNumber(data)
                            }},
                            {data:"lembur_libur",render:(data) => {
                                return formatNumber(data)
                            }},
                            {data:"bonus",render:(data) => {
                                return formatNumber(data)
                            }},
                            {data:"bonus_plus",render:(data) => {
                                return formatNumber(data)
                            }},
                            {data:"bonus_loyalitas",render:(data) => {
                                return formatNumber(data)
                            }},
                            {data:"tunjangan_jabatan",render:(data) => {
                                return formatNumber(data)
                            }},
                            {data:"tabungan",render:(data) => {
                                return formatNumber(data)
                            }},
                            {data:"kasbon_bayar",render:(data) => {
                                return formatNumber(data)
                            }},
                            {data:"kasbon_kue",render:(data) => {
                                return formatNumber(data)
                            }},
                            {data:"tabungan_lain",render:(data) => {
                                return formatNumber(data)
                            }},
                            {data:"total",render:(data,type,row) => {
                                var total = parseFloat(row.gaji_pokok) + parseFloat(row.uang_makan) + parseFloat(row.lembur) + parseFloat(row.lembur_libur) + parseFloat(row.bonus) + parseFloat(row.bonus_plus);
                                    total += parseFloat(row.bonus_loyalitas) + parseFloat(row.tunjangan_jabatan);
                                    total = Math.ceil(total/50000)*50000;
                                    total -= (parseFloat(row.tabungan) + parseFloat(row.kasbon_bayar) + parseFloat(row.kasbon_kue) + parseFloat(row.tabungan_lain));
                                return formatNumber(total);
                            }}
                        ],
                        order:[[2,"desc"]]
                    });
                },
                doExport() {
                    let params = new URLSearchParams(this.params()).toString();
                    window.open(`{{ url('payroll/export-new') }}?${params}`);
                },
                doImport() {
                    $('#modal-form-import').modal('show')
                },
                prosesExport() {
                    window.open(`{{ url('payroll/export') }}?bulan=${this.attr.year}${this.attr.month}&area=${this.attr.area}&lokasi=${this.attr.lokasi}`);
                },

                prosesImport() {
                    var formData = new FormData($('#fm-import')[0]);
                    var self = this;
                    Notiflix.Block.pulse('body'); 
                    $('#button-import').prop('disabled',true);
                    fetch("{{ url('payroll/import-new') }}",{
                            method:"POST",
                            body:formData
                    }).then(response => response.json())
                    .then(data => {
                            Notiflix.Block.remove('body');
                            $('#button-import').prop('disabled',false); 
                            if (data.error == false) {
                                Notiflix.Notify.success("Data Berhasil diimport");
                                $('#modal-form-import').modal('hide');
                                self.table.draw();
                            }
                    }).catch(error =>{
                            $('#button-import').prop('disabled',false);
                            Notiflix.Block.remove('body');
                            console.log(error)
                    })
                },
                editData() {
                    var id = this.$_data('id');
                    $.get(`{{ url('payroll/row') }}/${id}`).done(resp => {
                        $('#fm-edit').jsonToForm(resp);
                    })
                    $('#modal-form-edit').modal('show')
                },
                prosesEditGaji() {
                    Notiflix.Block.hourglass('body')
                    var self = this;
                    $.post("{{ url('payroll/save') }}",$('#fm-edit').serialize()).done(resp => {
                        Notiflix.Block.remove('body')
                        if (resp.error == false) {
							Notiflix.Notify.success("Data Berhasil Disimpan");
							self.table.draw();
							$('#modal-form-edit').modal('hide');
							
						} else {
							Notiflix.Notify.failure(resp.message);
						}
                    }).fail(err => {
                        Notiflix.Block.remove('body')
                        Notiflix.Notify.failure(err.responseText.message);
                    })
                },
                delData() {
                    var id = this.$_data("id");
                    Notiflix.Confirm.show("KONFIRMASI","Apakah yakin akan menghapus data ini?","YA","TIDAK",() => {
                        $.post("{{ url('payroll/delete') }}",{id,id}).done(resp => {
                            if (resp.error == false) {
                                Notiflix.Notify.success("Data Berhasil dihapus");
                                this.table.draw();
                            } else {
                                Notiflix.Notify.failure(resp.message);
                            }
                        }).fail(err => {
                            Notiflix.Notify.failure(err.responseText);
                        })
                    })
                },
                onAreaChange() {
                    let id = this.$event.target.value;
                    this.attr.listLokasi = [];
                    $.get("{{ url('payroll/list-lokasi') }}",{area_id:id}).done(resp => {
                        this.attr.listLokasi = resp;
                    })
                },
                params() {
                    let d = new Object()
                        d.bulan = this.attr.month;
                        d.tahun = this.attr.year;
                        d.area = this.attr.area;
                        d.lokasi = this.attr.lokasi;
                    return d;
                },
                viewSlip() {
                    window.open(`{{ url('api/v1/slip') }}?nik=${this.$_data('nik')}&bulan=${this.$_data('bulan')}`);
                },
                prosesCetakSlip() {
                    if (this.attr.lokasi == "") {
                        Notiflix.Notify.failure("Cabang Belum dipilih");
                        return;
                    }
                    window.open(`{{ url('payroll/cetak-slip') }}?${new URLSearchParams(this.params())}`);
                }
            }));
        });
    </script>
@endpush