How can I convert many statement mysql to laravel eloquent?

by

It’s mostly raw queries:

DB::table('item_details')->selectRaw('GROUP_CONCAT(...) INTO @sql')->get();
DB::statement('SET @sql = CONCAT(...)');
DB::statement('PREPARE stmt FROM @sql');
DB::statement('EXECUTE stmt');
DB::statement('DEALLOCATE PREPARE stmt');

Try this:

DB::table('item_details')->selectRaw('GROUP_CONCAT(...) INTO @sql')->get();
$sql = DB::selectOne('select @sql')->{'@sql'};
ItemDetails::select('item_number', DB::raw('SUM(quantity) as total_quantity'))
    ->selectRaw($sql)
    ->groupBy('item_number')
    ->get();

More Related Contents:

  1. Laravel Check If Related Model Exists
  2. Laravel Model with Two Primary Keys update [duplicate]
  3. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  4. Laravel Checking If a Record Exists
  5. Laravel 5 hasMany relationship on two columns
  6. Difference between Eloquent\Model::get() and all()
  7. Eloquent Parent-Child relationship on same model
  8. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  9. Merge ‘with’ and ‘whereHas’ in Laravel 5
  10. Laravel one to many relation with a one to one relation
  11. Laravel 5 – Remove Public from URL
  12. Bulk Insertion in Laravel using eloquent ORM
  13. Laravel 5 PDOException Could Not Find Driver
  14. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  15. Handling expired token in Laravel
  16. Laravel 5 not finding css files
  17. Ajax post request in laravel 5 return error 500 (Internal Server Error)
  18. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  19. How to alias the name of a column in Eloquent
  20. How can I paginate a merged collection in Laravel 5?
  21. Laravel 5.4 – Validation with Regex [duplicate]
  22. ReflectionException: Class ClassName does not exist – Laravel
  23. Laravel 5.1: keep uploaded file as old input
  24. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  25. How to Make Laravel Eloquent “IN” Query?
  26. laravel collection to array
  27. Laravel Eloquent sort by relation table column
  28. My Laravel 5.2.10 Sessions wont persist
  29. Laravel Middleware return variable to controller
  30. Laravel Eloquent update just if changes have been made

Leave a Comment