LaporanStokController.php
function getLaporanStokAwal
FIKRI
php_laravel_blade
3 years ago
8.7 kB
9
Indexable
public function getLaporanStokAwal(Request $request)
{
$limit = 10;
$offset = $request->input('offset') ?? 0;
$product = Product::orderBy('nama_barang')->offset($offset)->limit($limit)->get();
$tgl = Carbon::today();
$data = [];
$total_barang = 0;
$ppn = 0;
$nonppn = 0;
$sb_awal = 0;
$sk_awal = 0;
$sb_masuk = 0;
$sk_masuk = 0;
$sb_keluar = 0;
$sk_keluar = 0;
$sb_akhir = 0;
$sk_akhir = 0;
$tb_nilai = 0;
$tk_nilai = 0;
foreach ($product as $key => $value) {
// ===================versi sblm bulan 8 =======================//
$pasok_awal = Supply::where('created_at', $tgl)->where('kode_barang',$value->kode_barang)
->where('status', 'lunas')->get();
if($value->status_pajak == 'ppn'){
$transaksi_awal = Transaction::where('created_at', $tgl)->where('kode_barang',$value->kode_barang)
->where('status', 'lunas')->get();
}
else{
$transaksi_awal = TransactionNonPPN::where('created_at', $tgl)->where('kode_barang',$value->kode_barang)
->where('status', 'lunas')->get();
}
$data_awal = $pasok_awal->concat($transaksi_awal);
$pasok_awal_besar = $pasok_awal->where('jenis_kemasan', '!=', 'pack')->sum('jumlah')/$value->pack;
$transaksi_awal_besar = $transaksi_awal->where('jenis_kemasan', '!=', 'Pack')->sum('jumlah')/$value->pack;
$pasok_awal_kecil = $pasok_awal->where('jenis_kemasan', 'pack')->sum('jumlah');
$transaksi_awal_kecil = $transaksi_awal->where('jenis_kemasan', 'Pack')->sum('jumlah');
$stok_pertama = DB::table('stok_awal')->where('kode_barang', $value->kode_barang)->first();
if (isset($stok_pertama)) {
$stok_awal_b = $stok_pertama->jumlah_besar + $pasok_awal_besar - $transaksi_awal_besar;
$stok_awal_k = $stok_pertama->jumlah_kecil + $pasok_awal_kecil - $transaksi_awal_kecil;
}else{
$stok_awal_b = $pasok_awal_besar - $transaksi_awal_besar;
$stok_awal_k = $pasok_awal_kecil - $transaksi_awal_kecil;
}
$sb_awal += $stok_awal_b;
$sk_awal += $stok_awal_k;
$harga_beli_besar = ($data_awal == null) ? 0 : $value->harga_modal_dos;
$harga_beli_kecil = ($data_awal == null) ? 0 : $value->harga_modal_pack;
$harga_jual_besar = ($data_awal == null) ? 0 : $value->harga_jual_dos;
$harga_jual_kecil = ($data_awal == null) ? 0 : $value->harga_jual_pack;
$summ_stok_besar = Supply::where('created_at', $tgl)
->where('kode_barang', $value->kode_barang)->where('status', 'lunas')->where('jenis_kemasan', '!=', 'pack')->sum('jumlah')/$value->pack;
$summ_stok_kecil = Supply::where('created_at', $tgl)
->where('kode_barang', $value->kode_barang)->where('status', 'lunas')->where('jenis_kemasan', 'pack')->sum('jumlah');
$summ_total_harga_besar = Supply::where('created_at', $tgl)
->where('kode_barang', $value->kode_barang)->where('status', 'lunas')->where('jenis_kemasan', '!=', 'pack')->sum('subtotal');
$summ_total_harga_kecil = Supply::where('created_at', $tgl)
->where('kode_barang', $value->kode_barang)->where('status', 'lunas')->where('jenis_kemasan', 'pack')->sum('subtotal');
if($value->status_pajak == 'ppn'){
$sum_stok_besar = Transaction::where('created_at', $tgl)
->where('kode_barang', $value->kode_barang)->where('jenis_kemasan', '!=', 'Pack')->where('status', 'lunas')->sum('jumlah')/$value->pack;
$sum_stok_kecil = Transaction::where('created_at', $tgl)
->where('kode_barang', $value->kode_barang)->where('jenis_kemasan', 'Pack')->where('status', 'lunas')->sum('jumlah');
$sum_total_harga_besar = Transaction::where('created_at', $tgl)
->where('kode_barang', $value->kode_barang)->where('jenis_kemasan', '!=' , 'Pack')->where('status', 'lunas')->sum('total_barang');
$sum_total_harga_kecil = Transaction::where('created_at', $tgl)
->where('kode_barang', $value->kode_barang)->where('jenis_kemasan', 'Pack')->where('status', 'lunas')->sum('total_barang');
}
else{
$sum_stok_besar = TransactionNonPPN::where('created_at', $tgl)
->where('kode_barang', $value->kode_barang)->where('jenis_kemasan', '!=', 'Pack')->where('status', 'lunas')->sum('jumlah')/$value->pack;
$sum_stok_kecil = TransactionNonPPN::where('created_at', $tgl)
->where('kode_barang', $value->kode_barang)->where('jenis_kemasan', 'Pack')->where('status', 'lunas')->sum('jumlah');
$sum_total_harga_besar = TransactionNonPPN::where('created_at', $tgl)
->where('kode_barang', $value->kode_barang)->where('jenis_kemasan', '!=', 'Pack')->where('status', 'lunas')->sum('total_barang');
$sum_total_harga_kecil = TransactionNonPPN::where('created_at', $tgl)
->where('kode_barang', $value->kode_barang)->where('jenis_kemasan', 'Pack')->where('status', 'lunas')->sum('total_barang');
}
$sb_masuk += $summ_stok_besar;
$sk_masuk += $summ_stok_kecil;
$sb_keluar += $sum_stok_besar;
$sk_keluar += $sum_stok_kecil;
$stok_akhir_b = $stok_awal_b + $summ_stok_besar - $sum_stok_besar;
$stok_akhir_k = $stok_awal_k + $summ_stok_kecil - $sum_stok_kecil;
$nn = $stok_akhir_b * $harga_beli_besar;
$tb_nilai += $nn;
$nk = $stok_akhir_k * $harga_beli_kecil;
$tk_nilai += $nk;
array_push($data, [
'kode_barang' => $value->kode_barang,
'nama_barang' => $value->nama_barang,
'stok_awal_besar' => $stok_awal_b.' '.$value->master_kemasan,
'stok_awal_kecil' => $stok_awal_k.' Pack',
'stok_masuk_besar' => $summ_stok_besar.' '.$value->master_kemasan,
'harga_beli_besar' => number_format($harga_beli_besar,2,',','.'),
'total_nilai_besar' => number_format($summ_total_harga_besar,2,',','.'),
'stok_masuk_kecil' => $summ_stok_kecil.' Pack',
'harga_beli_kecil' => number_format($harga_beli_kecil,2,',','.'),
'total_nilai_kecil' => number_format($summ_total_harga_kecil,2,',','.'),
'stok_keluar_besar' => $sum_stok_besar.' '.$value->master_kemasan,
'harga_jual_besar' => number_format($harga_jual_besar,2,',','.'),
'total_nilai_jual_besar' => number_format($sum_total_harga_besar,2,',','.'),
'stok_keluar_kecil' => $sum_stok_kecil.' Pack',
'harga_jual_kecil' => number_format($harga_jual_kecil,2,',','.'),
'total_nilai_jual_kecil' => number_format($sum_total_harga_kecil,2,',','.'),
'stok_akhir_besar' => $stok_akhir_b.' '.$value->master_kemasan,
'stok_akhir_kecil' => $stok_akhir_k.' Pack',
'stok_rupiah_besar' => number_format($nn,2,',','.'),
'stok_rupiah_kecil' => number_format($nk,2,',','.'),
'status_pajak' => ($value->status_pajak == 'ppn') ? 'PPN' : 'Non PPN',
]);
if($value->status_pajak == 'ppn'){
$ppn++;
}else{
$nonppn++;
}
$total_barang++;
}
return datatables()->of($data)
->make(true);
return request()->json(200,[
'tgl' => $tgl,
'data' => $data,
'ppn' => $ppn,
'nonppn' => $nonppn,
'stok_awal_besar' => $sb_awal,
'stok_awal_kecil' => $sk_awal,
'stok_masuk_besar' => $sb_masuk,
'stok_masuk_kecil' => $sk_masuk,
'stok_keluar_besar' => $sb_keluar,
'stok_keluar_kecil' => $sk_keluar,
'stok_akhir_besar' => $sb_akhir,
'stok_akhir_kecil' => $sk_akhir,
'nilai_akhir_besar' => number_format($tb_nilai,2,',','.'),
'nilai_akhir_kecil' => number_format($tk_nilai,2,',','.'),
'total_barang' => $total_barang
]);
}Editor is loading...