I Want to Send My Query Result to ApexCharts, but the results is not what i am intended this is my query $queryPengadaanNonTender = DB::table('siapel_dokumen') ->where([['id_jenis_dokumen', '=','1'],['progres','=','100']]) ->join('siapel_pengadaan', 'siapel_dokumen.id_jenis_pengadaan', '=', 'siapel_pengadaan.id') ->select( DB::raw('COUNT(DISTINCT nama_paket) AS jml'), DB::raw('jenis_pengadaan as pengadaan'), DB::raw('tahun…
I'm building a tool that has the following hierarchy: Client > Projects > Stages Each stage has a 'price' value. The project has a 'value' attribute, which is just the dynamic sum of its stages. Now, I also want the…
I want to make a result from query after distinct and groupby This is My Code $results = DB::table('dokumen') ->join('pengadaan', 'dokumen.id_jenis_pengadaan', '=', 'pengadaan.id') ->select( DB::raw('COUNT(nama_paket) AS jml'), DB::raw('jenis_pengadaan as jenis_pengadaan'), DB::raw('tahun as tahun') ) ->groupBy('jenis_pengadaan', 'tahun') ->orderBy('tahun') ->get(); $hasil =…
I have a Blade file accessed through a URL with a variable parameter. I want to check whether the input is blank with input validation and return to the same URL with a success/error message. My blade file: URL: http://localhost:8000/mypage?view=3…
I have these tables: questions, participants, choices, and choice_participant (pivot table). I displayed the questions with their choices on the user's page (I used the radio box to select an option) and saved it to the table choice_participant. Sample table…
I want to develop a Mess Manager Application. Where users(members) comes and goes in every month. Here is my Eloquent Query in my Controller which I tried: where session('dates') like- Nov-2023, Dec-2023, Jan-2024 $sessionDate = Carbon::createFromFormat('M-Y', session('dates')); $currentDate = now();…
I'm using Laravel to build an online shop. I have a table named 'products' and another table named 'prices'. each product can have numerous amounts for price (which means there could be numerous records for one product_id in prices table).…
I am currently working on a Laravel project and encountering an issue with Eloquent relationships. I have two models, User and Post, and I'm trying to establish a one-to-many relationship between them. However, I'm facing issues when trying to retrieve…
I have a Laravel model Product and Vouchers defined as follows: class Product extends Model { public function vouchers(): HasMany { return $this->hasMany(Voucher::class); } } and class Voucher extends Model { public function product(): BelongsTo { return $this->belongsTo(Product::class); } }…
I have two models: User and Tier. In my management rules, A user is associated with one or more Third Parties, and a Tier is associated with a single User. Here is what I wrote in my template: User Model…