link has been copied
Membalas post anditsung dengan query yg gw ada sih ga pengaruh. soalnya pagination tetap dipake. gw cuman ubah groupby jadi goods_code aja trus di select goods_code trus selebihnya pake db raw. mungkin bermasalah kalo groupBynya terlalu banyak x yah tp ga tau kenapa hasilnya beda yg 1 25rb record yg 2 16rb record
[Comunity] Laravel A Framework For Web Artisans :: Belajar, Diskusi, Tanya, dll.
Membalas post anditsung setelah test sana sini return $query->select() ->where(, , ]) ->groupBy('goods_code',) ->orderBy('goods_code', 'asc'); dengan query seperti ini tidak ada error sama sekali groupby hanya dengan goods_code dan yang lain p
[Comunity] Laravel A Framework For Web Artisans :: Belajar, Diskusi, Tanya, dll.
Membalas post anditsung hape99 sepertinya gw udah tau masalahnya gan. DB::raw("MIN(beginning_balance) as beginning_balance"), DB::raw('SUM(entering) AS entering'), DB::raw('SUM(spending) AS spending'), DB::raw('SUM(compliance) AS compliance'), DB::raw('MAX(final_balance) as final_balance'), DB::raw('SUM(stock...
[Comunity] Laravel A Framework For Web Artisans :: Belajar, Diskusi, Tanya, dll.
Membalas post anditsung gw coba pake sequel pro select `goods_code`, `goods_name`, `unit`, MIN(beginning_balance) as beginning_balance, SUM(entering) AS entering, SUM(spending) AS spending, SUM(compliance) AS compliance, MAX(final_balance) as final_balance, SUM(stock_opname) AS stock_opname, MAX(difference) as differenc
[Comunity] Laravel A Framework For Web Artisans :: Belajar, Diskusi, Tanya, dll.
Membalas thread aa_pratomo gan gw ada scope ini di model public function scopeSummary($query, $begin_date, $end_date) { return $query->select() ->where(, , ]) ->groupBy() ->orderBy('goods_code', 'asc'); } trus di controller $models::summary($data, $data)->paginate(20); saat jalankan di local sih ga a...
[Comunity] Laravel A Framework For Web Artisans :: Belajar, Diskusi, Tanya, dll.
Membalas post nvidiator nvidiator kemarin ni pernah liat harga segitu di toko ijo. tp barusan search udah ga ada lagi... berarti seperti prediksi gw tulis diskon gede tp ga ada barang. yg ada barang pada jual diatas semua
[Original Lounge] PS4 | PS4 PRO - This is for Original Players - Faqs in page 1 - Part 2
Copyright © 2025, Kaskus Networks, PT Darta Media Indonesia