I have about 30+ migration files. When it gets to a migration which contains a column rename: Schema::table('table', function (Blueprint $table) { $table->renameColumn('old_field', 'new_field'); }); It only errors once it gets to this migration (let's say, number 15). It runs…
I'm trying to retrieve some data from my MySQL database, but It's not working using Eloquent (I'm getting 0 rows). I's a very simple query, but is driving me crazy. This is the query in PHP: $slideshowIdList = Media_slideshow::select('idSlideshow') ->whereIn('idMedia',$idList)…
Here my MySQL query (work in phpMyAdmin) : SELECT waktu_kerusakan, workcenter, COUNT(workcenter) AS jumlah_repair FROM repair WHERE year(waktu_kerusakan)='2019' GROUP BY workcenter , month(waktu_kerusakan) BETWEEN 1 and 6 Order By jumlah_repair Desc then, i try in Laravel Syntax like this below…
I have a simple form for adding pages information, the form looks like this as you can see above the prebid input, To add prebids we need to click plus button and pop up appear inside a popo up, I…
Here my MySQL query (work in phpMyAdmin) : SELECT workcenter, (SUM(w1+w2 +w3 +w4)/ (COUNT(DISTINCT(teknisi))*40*4) )*100 AS total FROM `team` GROUP by workcenter ORDER BY total then, i try in Laravel Sintax like this below (not work) : $sql = Team::groupBy('workcenter')->select('workcenter',…
I just re-structured my database to have a category table instead of using a category column on my main form. How can I pass the category_id to my form so my form POSTs properly? Right now i'm getting this error,…
So I have database with amount and created_at field on it and I want to the total amount per month of the current year and or every year. $sql = 'SELECT SUM(amount) as "Amount",MONTHNAME(created_at) as "Month" FROM transactions WHERE YEAR(created_at)…
Im having a hard time converting this raw MySQL query in phpmyadmin. I want to convert it to laravel's query builder or eloquent. I already configured the relationships in the model. Can someone convert my query to querybuilder and eloquent?…
With Laravel/Lumen eloquent I can get count relations like this: User::withCount('views')->get(); this will use SQL select `users`.*, (select count(*) from `views` where `users`.`id` = `views`.`user_id`) as `views_count` from `users` and return all models with views_count attribute, great. But I need…
I'm creating a small webshop where users can create orders and sellers can see the orders. I have defined relationships but the related functions are null. This is how my tables looks like in phpmyAdmin https://imgur.com/a/C2PSmFt This is how I…