putrakuningan/Writeoff
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
master
Writeoff/DataTables/LaporanDataTable.php

103 lines
63 KiB
PHP
Raw Permalink Normal View History

update IUT
2023-12-19 11:00:24 +00:00
<?php
namespace Modules\Writeoff\DataTables;
use Illuminate\Database\Eloquent\Builder as QueryBuilder;
use Modules\Writeoff\Entities\Branch;
use Nwidart\Modules\Facades\Module;
use Yajra\DataTables\EloquentDataTable;
use Yajra\DataTables\Html\Builder as HtmlBuilder;
use Yajra\DataTables\Html\Column;
use Yajra\DataTables\Services\DataTable;
class LaporanDataTable extends DataTable
{
/**
* Build the DataTable class.
*
* @param QueryBuilder $query Results from query() method.
*/
public function dataTable()
{
$json = '[{"No":"1","Nomor Pinjaman":"5000072089","Tgl Hapus Buku":"31/12/2020","Cabang":"ID0010003/PURI INDAH - KCP","Debitur":"9702040/TAUFIQ MOHAMAD GAU","Jns Fasilitas":"6100/KPA/KPR/KPK","Nomor Fasilitas":"9702040.0006100.01","Jns Pinjaman":"3204/Housing Loan","Plafond Awal":"1.600.000.000,00","Suku Bunga":"13,00","Baki Debet":"1.555.689.782,00","Jumlah Bunga":"852.937.386,62","Kewajiban Lain":"1.998.329.398,65","Tot Kewajiban":"4.406.956.567,27","Bunga Intra":"608.404.345,57","Bunga Ekstra":"1.220.664.486,77","Kewajiban Lainnya":"10.673.760,44","Tot Semua Kewajiban":"6.236.025.399,61","Tgl Bayar":"&nbsp;","Nominal":"0,00","Sisa Kewajiban":"6.236.025.399,61"},{"No":"2","Nomor Pinjaman":"1076300131","Tgl Hapus Buku":"31/12/2020","Cabang":"ID0010008/KPO SUDIRMAN","Debitur":"1000084092/DIPOJAYA INDOTAMA","Jns Fasilitas":"6610/Revolving Loan - Non Revolving","Nomor Fasilitas":"1000084092.0006610.01","Jns Pinjaman":"3240/Revolving Loan-Menurun","Plafond Awal":"4.000.000.000,00","Suku Bunga":"13,50","Baki Debet":"3.530.000.000,00","Jumlah Bunga":"802.192.500,00","Kewajiban Lain":"754.393.358,33","Tot Kewajiban":"5.086.585.858,33","Bunga Intra":"1.433.621.250,00","Bunga Ekstra":"1.647.157.346,07","Kewajiban Lainnya":"25.151.250,00","Tot Semua Kewajiban":"8.167.364.454,40","Tgl Bayar":"&nbsp;","Nominal":"0,00","Sisa Kewajiban":"8.167.364.454,40"},{"No":"3","Nomor Pinjaman":"5000025501","Tgl Hapus Buku":"31/12/2020","Cabang":"ID0010008/KPO SUDIRMAN","Debitur":"616177/SUGANDA KUSUMA","Jns Fasilitas":"6100/KPA/KPR/KPK","Nomor Fasilitas":"616177.0006100.01","Jns Pinjaman":"3204/Housing Loan","Plafond Awal":"4.600.000.000,00","Suku Bunga":"13,00","Baki Debet":"4.058.561.906,13","Jumlah Bunga":"821.307.917,94","Kewajiban Lain":"639.009.348,78","Tot Kewajiban":"5.518.879.172,85","Bunga Intra":"1.587.235.918,78","Bunga Ekstra":"1.744.310.202,98","Kewajiban Lainnya":"27.846.244,18","Tot Semua Kewajiban":"8.850.425.294,61","Tgl Bayar":"&nbsp;","Nominal":"0,00","Sisa Kewajiban":"8.850.425.294,61"},{"No":"4","Nomor Pinjaman":"5000104223","Tgl Hapus Buku":"31/12/2020","Cabang":"ID0010008/KPO SUDIRMAN","Debitur":"813575/DAKA LINTAS SAMUDRA","Jns Fasilitas":"6310/Fixed Loan-Non Revolving","Nomor Fasilitas":"813575.0006310.01","Jns Pinjaman":"3223/Fixed Loan-Dgn Ccl Pok Commercial","Plafond Awal":"6.611.111.112,00","Suku Bunga":"14,00","Baki Debet":"6.611.111.112,00","Jumlah Bunga":"1,00","Kewajiban Lain":"0,00","Tot Kewajiban":"6.611.111.113,00","Bunga Intra":"2.784.379.630,00","Bunga Ekstra":"2.442.772.500,58","Kewajiban Lainnya":"48.848.765,43","Tot Semua Kewajiban":"11.838.263.243,58","Tgl Bayar":"&nbsp;","Nominal":"0,00","Sisa Kewajiban":"11.838.263.243,58"},{"No":"5","Nomor Pinjaman":"1074987326","Tgl Hapus Buku":"31/12/2020","Cabang":"ID0010009/MELAWAI - KC","Debitur":"901718/RAVKY JAYA ABADI","Jns Fasilitas":"6610/Revolving Loan - Non Revolving","Nomor Fasilitas":"901718.0006610.01","Jns Pinjaman":"3240/Revolving Loan-Menurun","Plafond Awal":"2.500.000.000,00","Suku Bunga":"13,50","Baki Debet":"2.433.434.863,77","Jumlah Bunga":"0,00","Kewajiban Lain":"2.934.511.434,00","Tot Kewajiban":"5.367.946.297,77","Bunga Intra":"988.278.734,04","Bunga Ekstra":"1.601.178.534,44","Kewajiban Lainnya":"17.338.223,40","Tot Semua Kewajiban":"7.957.403.566,25","Tgl Bayar":"&nbsp;","Nominal":"0,00","Sisa Kewajiban":"7.957.403.566,25"},{"No":"6","Nomor Pinjaman":"5000029256","Tgl Hapus Buku":"31/12/2020","Cabang":"ID0010009/MELAWAI - KC","Debitur":"901718/RAVKY JAYA ABADI","Jns Fasilitas":"6310/Fixed Loan-Non Revolving","Nomor Fasilitas":"901718.0006310.01","Jns Pinjaman":"3224/p&amp;bcomm","Plafond Awal":"1.900.000.000,00","Suku Bunga":"14,00","Baki Debet":"1.019.264.154,50","Jumlah Bunga":"195.026.084,99","Kewajiban Lain":"456.245.948,21","Tot Kewajiban":"1.670.536.187,70","Bunga Intra":"429.280.086,40","Bunga Ekstra":"545.581.195,96","Kewajiban Lainnya":"7.531.229,58","Tot Semua Kewajiban":"2.645.397.470,06","Tgl Bayar":"&nbsp;","Nominal":"0,00","Sisa Kewajiban":"2.645.397.470,06"},{"No":"7","Nomor Pinjaman":"5000076823","Tgl Hapus Buk
$data = collect($json)->toJson();
return $data;
}
/**
* Get the query source of dataTable.
*/
public function query()
{
$json = '[{"No":"1","Nomor Pinjaman":"5000072089","Tgl Hapus Buku":"31/12/2020","Cabang":"ID0010003/PURI INDAH - KCP","Debitur":"9702040/TAUFIQ MOHAMAD GAU","Jns Fasilitas":"6100/KPA/KPR/KPK","Nomor Fasilitas":"9702040.0006100.01","Jns Pinjaman":"3204/Housing Loan","Plafond Awal":"1.600.000.000,00","Suku Bunga":"13,00","Baki Debet":"1.555.689.782,00","Jumlah Bunga":"852.937.386,62","Kewajiban Lain":"1.998.329.398,65","Tot Kewajiban":"4.406.956.567,27","Bunga Intra":"608.404.345,57","Bunga Ekstra":"1.220.664.486,77","Kewajiban Lainnya":"10.673.760,44","Tot Semua Kewajiban":"6.236.025.399,61","Tgl Bayar":"&nbsp;","Nominal":"0,00","Sisa Kewajiban":"6.236.025.399,61"},{"No":"2","Nomor Pinjaman":"1076300131","Tgl Hapus Buku":"31/12/2020","Cabang":"ID0010008/KPO SUDIRMAN","Debitur":"1000084092/DIPOJAYA INDOTAMA","Jns Fasilitas":"6610/Revolving Loan - Non Revolving","Nomor Fasilitas":"1000084092.0006610.01","Jns Pinjaman":"3240/Revolving Loan-Menurun","Plafond Awal":"4.000.000.000,00","Suku Bunga":"13,50","Baki Debet":"3.530.000.000,00","Jumlah Bunga":"802.192.500,00","Kewajiban Lain":"754.393.358,33","Tot Kewajiban":"5.086.585.858,33","Bunga Intra":"1.433.621.250,00","Bunga Ekstra":"1.647.157.346,07","Kewajiban Lainnya":"25.151.250,00","Tot Semua Kewajiban":"8.167.364.454,40","Tgl Bayar":"&nbsp;","Nominal":"0,00","Sisa Kewajiban":"8.167.364.454,40"},{"No":"3","Nomor Pinjaman":"5000025501","Tgl Hapus Buku":"31/12/2020","Cabang":"ID0010008/KPO SUDIRMAN","Debitur":"616177/SUGANDA KUSUMA","Jns Fasilitas":"6100/KPA/KPR/KPK","Nomor Fasilitas":"616177.0006100.01","Jns Pinjaman":"3204/Housing Loan","Plafond Awal":"4.600.000.000,00","Suku Bunga":"13,00","Baki Debet":"4.058.561.906,13","Jumlah Bunga":"821.307.917,94","Kewajiban Lain":"639.009.348,78","Tot Kewajiban":"5.518.879.172,85","Bunga Intra":"1.587.235.918,78","Bunga Ekstra":"1.744.310.202,98","Kewajiban Lainnya":"27.846.244,18","Tot Semua Kewajiban":"8.850.425.294,61","Tgl Bayar":"&nbsp;","Nominal":"0,00","Sisa Kewajiban":"8.850.425.294,61"},{"No":"4","Nomor Pinjaman":"5000104223","Tgl Hapus Buku":"31/12/2020","Cabang":"ID0010008/KPO SUDIRMAN","Debitur":"813575/DAKA LINTAS SAMUDRA","Jns Fasilitas":"6310/Fixed Loan-Non Revolving","Nomor Fasilitas":"813575.0006310.01","Jns Pinjaman":"3223/Fixed Loan-Dgn Ccl Pok Commercial","Plafond Awal":"6.611.111.112,00","Suku Bunga":"14,00","Baki Debet":"6.611.111.112,00","Jumlah Bunga":"1,00","Kewajiban Lain":"0,00","Tot Kewajiban":"6.611.111.113,00","Bunga Intra":"2.784.379.630,00","Bunga Ekstra":"2.442.772.500,58","Kewajiban Lainnya":"48.848.765,43","Tot Semua Kewajiban":"11.838.263.243,58","Tgl Bayar":"&nbsp;","Nominal":"0,00","Sisa Kewajiban":"11.838.263.243,58"},{"No":"5","Nomor Pinjaman":"1074987326","Tgl Hapus Buku":"31/12/2020","Cabang":"ID0010009/MELAWAI - KC","Debitur":"901718/RAVKY JAYA ABADI","Jns Fasilitas":"6610/Revolving Loan - Non Revolving","Nomor Fasilitas":"901718.0006610.01","Jns Pinjaman":"3240/Revolving Loan-Menurun","Plafond Awal":"2.500.000.000,00","Suku Bunga":"13,50","Baki Debet":"2.433.434.863,77","Jumlah Bunga":"0,00","Kewajiban Lain":"2.934.511.434,00","Tot Kewajiban":"5.367.946.297,77","Bunga Intra":"988.278.734,04","Bunga Ekstra":"1.601.178.534,44","Kewajiban Lainnya":"17.338.223,40","Tot Semua Kewajiban":"7.957.403.566,25","Tgl Bayar":"&nbsp;","Nominal":"0,00","Sisa Kewajiban":"7.957.403.566,25"},{"No":"6","Nomor Pinjaman":"5000029256","Tgl Hapus Buku":"31/12/2020","Cabang":"ID0010009/MELAWAI - KC","Debitur":"901718/RAVKY JAYA ABADI","Jns Fasilitas":"6310/Fixed Loan-Non Revolving","Nomor Fasilitas":"901718.0006310.01","Jns Pinjaman":"3224/p&amp;bcomm","Plafond Awal":"1.900.000.000,00","Suku Bunga":"14,00","Baki Debet":"1.019.264.154,50","Jumlah Bunga":"195.026.084,99","Kewajiban Lain":"456.245.948,21","Tot Kewajiban":"1.670.536.187,70","Bunga Intra":"429.280.086,40","Bunga Ekstra":"545.581.195,96","Kewajiban Lainnya":"7.531.229,58","Tot Semua Kewajiban":"2.645.397.470,06","Tgl Bayar":"&nbsp;","Nominal":"0,00","Sisa Kewajiban":"2.645.397.470,06"},{"No":"7","Nomor Pinjaman":"5000076823","Tgl Hapus Buk
return collect($json);
}
/**
* Optional method if you want to use the html builder.
*/
public function html()
: HtmlBuilder
{
$json = '[{"No":"1","Nomor Pinjaman":"5000072089","Debitur":"9702040/TAUFIQ MOHAMAD GAU","Alamat":"&nbsp;","Cabang":"ID0010003/PURI INDAH - KCP","Jns Fasilitas":"6100/KPA/KPR/KPK","Nomor Fasilitas":"9702040.0006100.01","Jns Pinjaman":"3204/Housing Loan","Mata Uang":"IDR","Baki Debet":"1.555.689.782,00","Jumlah Bunga":"852.937.386,62","Kewajiban Lain":"1.998.329.398,65","Tot Semua Kewajiban":"4.406.956.567,27"," Tgl Bayar":"&nbsp;","Nominal Bayar":"0,00","Sisa Kewajiban":"6.236.025.399,61","Memo Persetujuan":"&nbsp;","Nomor Jaminan":"&nbsp;","Jns Jaminan":"&nbsp;","Nilai Jaminan":"0,00","Tgl Penagihan":"&nbsp;"," PIC Penagihan":"&nbsp;","Tindakan":"&nbsp;","Informasi LKU":"&nbsp;","Proses Hukum":"&nbsp;"},{"No":"2","Nomor Pinjaman":"1076300131","Debitur":"1000084092/DIPOJAYA INDOTAMA","Alamat":"&nbsp;","Cabang":"ID0010008/KPO SUDIRMAN","Jns Fasilitas":"6610/Revolving Loan - Non Revolving","Nomor Fasilitas":"1000084092.0006610.01","Jns Pinjaman":"3240/Revolving Loan-Menurun","Mata Uang":"IDR","Baki Debet":"3.530.000.000,00","Jumlah Bunga":"802.192.500,00","Kewajiban Lain":"754.393.358,33","Tot Semua Kewajiban":"5.086.585.858,33"," Tgl Bayar":"&nbsp;","Nominal Bayar":"0,00","Sisa Kewajiban":"8.167.364.454,40","Memo Persetujuan":"&nbsp;","Nomor Jaminan":"SHM NO 415/SUSUKAN","Jns Jaminan":"408/187-LAND","Nilai Jaminan":"2.079.000.000,00","Tgl Penagihan":"&nbsp;"," PIC Penagihan":"&nbsp;","Tindakan":"&nbsp;","Informasi LKU":"&nbsp;","Proses Hukum":"&nbsp;"},{"No":"3","Nomor Pinjaman":"5000025501","Debitur":"616177/SUGANDA KUSUMA","Alamat":"&nbsp;","Cabang":"ID0010008/KPO SUDIRMAN","Jns Fasilitas":"6100/KPA/KPR/KPK","Nomor Fasilitas":"616177.0006100.01","Jns Pinjaman":"3204/Housing Loan","Mata Uang":"IDR","Baki Debet":"4.058.561.906,13","Jumlah Bunga":"821.307.917,94","Kewajiban Lain":"639.009.348,78","Tot Semua Kewajiban":"5.518.879.172,85"," Tgl Bayar":"&nbsp;","Nominal Bayar":"0,00","Sisa Kewajiban":"8.850.425.294,61","Memo Persetujuan":"&nbsp;","Nomor Jaminan":"&nbsp;","Jns Jaminan":"&nbsp;","Nilai Jaminan":"0,00","Tgl Penagihan":"&nbsp;"," PIC Penagihan":"&nbsp;","Tindakan":"&nbsp;","Informasi LKU":"&nbsp;","Proses Hukum":"&nbsp;"},{"No":"4","Nomor Pinjaman":"5000104223","Debitur":"813575/DAKA LINTAS SAMUDRA","Alamat":"&nbsp;","Cabang":"ID0010008/KPO SUDIRMAN","Jns Fasilitas":"6310/Fixed Loan-Non Revolving","Nomor Fasilitas":"813575.0006310.01","Jns Pinjaman":"3223/Fixed Loan-Dgn Ccl Pok Commercial","Mata Uang":"IDR","Baki Debet":"6.611.111.112,00","Jumlah Bunga":"1,00","Kewajiban Lain":"0,00","Tot Semua Kewajiban":"6.611.111.113,00"," Tgl Bayar":"&nbsp;","Nominal Bayar":"0,00","Sisa Kewajiban":"11.838.263.243,58","Memo Persetujuan":"&nbsp;","Nomor Jaminan":"&nbsp;","Jns Jaminan":"&nbsp;","Nilai Jaminan":"0,00","Tgl Penagihan":"&nbsp;"," PIC Penagihan":"&nbsp;","Tindakan":"&nbsp;","Informasi LKU":"&nbsp;","Proses Hukum":"&nbsp;"},{"No":"5","Nomor Pinjaman":"1074987326","Debitur":"901718/RAVKY JAYA ABADI","Alamat":"&nbsp;","Cabang":"ID0010009/MELAWAI - KC","Jns Fasilitas":"6610/Revolving Loan - Non Revolving","Nomor Fasilitas":"901718.0006610.01","Jns Pinjaman":"3240/Revolving Loan-Menurun","Mata Uang":"IDR","Baki Debet":"2.433.434.863,77","Jumlah Bunga":"0,00","Kewajiban Lain":"2.934.511.434,00","Tot Semua Kewajiban":"5.367.946.297,77"," Tgl Bayar":"&nbsp;","Nominal Bayar":"0,00","Sisa Kewajiban":"7.957.403.566,25","Memo Persetujuan":"&nbsp;","Nomor Jaminan":"&nbsp;","Jns Jaminan":"&nbsp;","Nilai Jaminan":"0,00","Tgl Penagihan":"&nbsp;"," PIC Penagihan":"&nbsp;","Tindakan":"&nbsp;","Informasi LKU":"&nbsp;","Proses Hukum":"&nbsp;"},{"No":"6","Nomor Pinjaman":"5000029256","Debitur":"901718/RAVKY JAYA ABADI","Alamat":"&nbsp;","Cabang":"ID0010009/MELAWAI - KC","Jns Fasilitas":"6310/Fixed Loan-Non Revolving","Nomor Fasilitas":"901718.0006310.01","Jns Pinjaman":"3224/p&amp;bcomm","Mata Uang":"IDR","Baki Debet":"1.019.264.154,50","Jumlah Bunga":"195.026.084,99","Kewajiban Lain":"456.245.948,21","Tot Semua Kewajiban":"1.670.536.187,70"," Tgl Bayar":"&nbsp;","Nominal Bayar":"0,00","Sisa Kewajiban":"2.645.397.470,06","M
$data = json_decode($json);
return $this->builder()
->setTableId('branch-table')
->columns($this->getColumns())
->minifiedAjax()
->stateSave(false)
->responsive()
->autoWidth(true)
->orderBy(1)
->parameters([
'scrollX' => false,
'drawCallback' => 'function() { KTMenu.createInstances(); }',
])
->addTableClass('align-middle table-row-dashed fs-6 gy-5')
->drawCallback("function() {" . file_get_contents(Module::getModulePath('writeoff').'Resources/views/parameter/branches/_draw-scripts.js') . "}");
}
/**
* Get the dataTable columns definition.
*/
public function getColumns()
: array
{
return [
Column::make('DT_RowIndex')->title('No')->orderable(false)->searchable(false),
/*'Nomor Pinjaman'
'Tgl Hapus Buku'
'Cabang'
'Debitur'
'Jns Fasilitas'
'Nomor Fasilitas'
'Jns Pinjaman'
'Plafond Awal'
'Suku Bunga'
'Baki Debet'
'Jumlah Bunga'
'Kewajiban Lain'
'Tot Kewajiban'
'Bunga Intra'
'Bunga Ekstra'
'Kewajiban Lainnya'
'Tot Semua Kewajiban'
'Tgl Bayar'
'Nominal'
'Sisa Kewajiban'*/
Column::make('Nomor Pinjaman'),
Column::make('Tgl Hapus Buku')
];
}
/**
* Get the filename for export.
*/
protected function filename()
: string
{
return 'Branch_' . date('YmdHis');
}
}
Reference in New Issue Copy Permalink