webdevask.com

Menu

  • Home
  • New
  • Add question

php - How to make multiple subquery in Laravel 6?

View Original

one text

Solution:

You could make use of the function

$query = trim($request->get('searchText'));

$titulos = DB::table('titulo as t')

    ->select('t.nombre','t.anio')

    ->selectSub(function ($query) {
        $query->from('Valor')
            ->whereColumn('Valor.id', 'titulo.tipo')
            ->select('Valor.value')
            ->latest()
            ->take(1);
    }, 'tipo')

    ->selectSub(function ($query) {
        $query->from('Valor')
            ->whereColumn('Valor.id', 'titulo.centro')
            ->select('Valor.value')
            ->latest()
            ->take(1);
    }, 'centro')

    ->paginate(7);

Source

See also:

  • php สร้าง Google ชีตจากบัญชีบริการ

  • php - Laravel 8.0 Installation Failed

  • javascript - How to include HTML data (tags) as value in "arrayToDataTable" of Google Pie Chart?

  • how to Grouping array in php

  • php - vender folder from my laravel project has more 1k error

© 2021
E-mail: contact@webdevask.com
Back to top