I want to get data plan by date, then I use carbon on laravel to get it. this my query on laravel controller $data = DB::table('visit_plan') ->join('outlets', 'outlets.id', '=', 'visit_plan.id_outlet') ->select('outlets.id', 'outlets.name') ->get() ->groupBy(function($date) { return $this->attributes['date'] = Carbon::parse($date->date)->format('Y-m-d'); });…
laravel query with fetch data I have below table in "ORDCOMPLETE" is duplicate with same order ID #11310, so I need to remove this duplicate id with the same prefix. #11309 ORDCOMPLETE7104671693208650 $30 #11310 ORDCOMPLETE4335631693207733 $30 #11310 ORDCOMPLETE4335631693207744 $30 #11310…
For example, this is my file structure: MyProject app bootstrap config database node_modules pdfjs-dist build pdf.js public upload documents solution_12.pdf resources So when i type http://127.0.0.1:8000/uploads/documents/solution_12.pdf (1) into my web browser, it works fine, the web brower shows the pdf…
I have tried several tutorials in the internet but it doesn't work or the language not changing, I already stored the translation into lang directory, and the session is already set Localization Session here is my source code: This is…
I want to access sessions in the AppServiceProvider file in Laravel. To achieve this, I've created a middleware file and defined it in the kernel.php file. However, even after doing this, when I use the Log function in the AppServiceProvider…
I have a student list table. In the table, there is a column to display study programs. This column retrieves data from the study program database. However, what is displayed in the table is the study program id. What I…
I have 2 routes, one for canceling subscription, and one for resuming, and unless I am missing something, both routes are identical except for the names/functions/urls. When I cancel resume the subscription, I click the /resume url, it performs the…
Im learning the MVC pattern using Laravel and the eloquent model is kinda overwhelming to me. The eloquent model returns a collection of collumns of a table, but i want to a collection of another table to be the attributes…
I am trying to send email in my Laravel project using AWS SES. The error messages are not being very helpful. In AWS SES, I verified the identity of both my domain and the email address I’m using as sender…
I have the following data in my table: Name | Age | Shirt Size | User Id ------------------------------------------------------------- Jon Doe | 12 | L | 3 ------------------------------------------------------------- Jonathan Doe | 13 | XL | 3 ------------------------------------------------------------- John Doe | 14…