/**
* Get the query object to be processed by dataTables.
*
* @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection
*/
public function query()
{
if (Auth::User()->can('peminjaman.approve')) {
$query = Peminjaman::with('detailPeminjaman', 'lokasi', 'detailPeminjaman.subKelompok')->select('*');
} else {
$query = Peminjaman::with('detailPeminjaman', 'lokasi', 'detailPeminjaman.subKelompok')->where('id_lokasi', '=', Auth::User()->id_lokasi)->select('*');
}
return $this->applyScopes($query);
}
public function getSubBarang($id_lokasi)
{
$data = [];
$peminjamans = Peminjaman::with(['detailPeminjaman.subKelompok', 'detailPeminjaman' => function ($query) {
$query->groupBy('id_sub');
}])->where('id_lokasi', '=', $id_lokasi)->selectRaw(['sum(detailpeminjaman.jumlah as jum'])->get();
foreach ($peminjamans as $peminjaman) {
foreach ($peminjaman->detailPeminjaman as $detailpeminjaman) {
// $detailpeminjaman;
}
}
return $peminjamans;
}
public function getlaporan(Request $request)
{
$tgl1 = $request->input('start');
$tgl2 = $request->input('end');
// $tabel='jual';
$datas['datas'] = Peminjaman::with('lokasi', 'detailPeminjaman.subKelompok')->whereBetween('created_at', [$tgl1, $tgl2])->get();
$datas['tgl1'] = $tgl1;
$datas['tgl2'] = $tgl2;
$pdf = PDF::loadView('penjualan.datalaporan', $datas);
return $pdf->download('laporan.pdf');
}