File "submenu"
Full Path: /var/www/lionsclub/core/app/Http/Controllers/Dashboard/submenu
File size: 791 bytes
MIME-type: text/x-php
Charset: utf-8
<?php
namespace App\Http\Controllers\Dashboard;
use App\Http\Controllers\Controller;
use App\models\Menu;
use DB;
class SubMenuController extends Controller
{
function showdb()
{
$subMenus = Menu::all();
return view('showdb',['subMenus'=>$subMenus]);
}
function highLights()
{
$count = Menu::all()->where('father_id',58 );
$hightlight = Menu::all()->where('father_id',58 );
$var = Menu::select('id','title_en',DB::raw('COUNT(father_id) as count '))->groupBy('father_id')->where('father_id','=',42)
->having('count', '>', 1)->get();
//where('father_id','=',42)->get()->toArray();
dd($var);
return view('showdb',['subMenus'=>$hightlight]);
}
}