I have multiple tables with millions of records, and I'm facing performance challenges with my current Eloquent queries. I have three tables = 'sales', 'expenses', and 'profits' Each table has columns such as 'amount', 'date', and 'category_id' I need to…
I have tables called event and eventinfo. Where the event hasMany eventinfo. I am trying to get the event that has eventinfo with active=1, but it get all the eventinfo whether active is 0 or 1. $eventsInfo = Event::find($eventId) ->whereHas('EventInfo',…
I have a model named Document, Document has a status field where the possible values are, let's say dummy_data ['done', 'failed', 'sent', ....]. I want to get all documents where status='done' if they are present in DB OR all documents…
I'm trying to archive month date 1 to month end date with. below code now get this year month complete date 1 to 31 by below code. but it only gives current year month I want to pass dynamic year…
After retrieving the first article number, I can only obtain the data for all products from the query. Each product has a "type_id" that determines in which junction table the product options can be found. My question is how can…
I need to get data of default_item_name relationship by using command php artisan schedule: run. but I am not getting default_item_name relationship data is empty because event_id not passed from controller. My code is Below. CronController public function sendFoodMenuPdfEmailOrTelegram() {…
I make a controller function to insert new records on the quizzes table. To do that, I used Laravel mass assignment, and after that, I got this error message. "message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field…
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 =…