@php if(auth()->user()->user_type!=3){ $currentUrl = (Request::path() != '/') ? '/'. Request::path() : '/'; function renderSubMenu($value, $currentUrl) { $subMenu = ''; $GLOBALS['sub_level'] += 1 ; $GLOBALS['active'][$GLOBALS['sub_level']] = ''; $currentLevel = $GLOBALS['sub_level']; foreach ($value as $key => $menu) { $GLOBALS['subparent_level'] = ''; $subSubMenu = ''; $hasSub = (!empty($menu['sub_menu'])) ? 'has-sub' : ''; $hasCaret = (!empty($menu['sub_menu'])) ? '' : ''; $hasHighlight = (!empty($menu['highlight'])) ? '' : ''; $hasTitle = (!empty($menu['title'])) ? '' : ''; if (!empty($menu['sub_menu'])) { $subSubMenu .= ''; } $active = (!empty($menu['route-name']) && (Route::currentRouteName() == $menu['route-name'])) ? 'active' : ''; if ($active) { $GLOBALS['parent_active'] = true; $GLOBALS['active'][$GLOBALS['sub_level'] - 1] = true; } if (!empty($GLOBALS['active'][$currentLevel])) { $active = 'active'; } $subMenu .= ' '; } return $subMenu; } function renderHeaderSubMenu($value, $currentUrl) { $subMenu = ''; $GLOBALS['sub_level'] += 1 ; $GLOBALS['active'][$GLOBALS['sub_level']] = ''; $currentLevel = $GLOBALS['sub_level']; foreach ($value as $key => $menu) { $GLOBALS['subparent_level'] = ''; $subSubMenu = ''; $hasSub = (!empty($menu['sub_menu'])) ? 'has-sub' : ''; $hasCaret = (!empty($menu['sub_menu'])) ? '' : ''; $hasHighlight = (!empty($menu['highlight'])) ? '' : ''; $hasTitle = (!empty($menu['title'])) ? '' : ''; if (!empty($menu['sub_menu'])) { $subSubMenu .= ''; } $active = (!empty($menu['route-name']) && (Route::currentRouteName() == $menu['route-name'])) ? 'active' : ''; if ($active) { $GLOBALS['parent_active'] = true; $GLOBALS['active'][$GLOBALS['sub_level'] - 1] = true; } if (!empty($GLOBALS['active'][$currentLevel])) { $active = 'active'; } $subMenu .= ' '; } return $subMenu; } //echo $currentUser; $currentUser11=auth()->user()->id; $currentUserProfileId=auth()->user()->user_profile_id; $currentEstb=auth()->user()->estb_code; $checkHideForDC=''; if(!($currentEstb==1 || $currentEstb==2 || $currentEstb==3)){ $checkHideForDC='Y'; } $sql=\DB::select("SELECT user_id as user_profile_id, concat('t_4_',menu4_id) as menuid,menu1_id, menu2_id, menu3_id, menu4_id FROM user_wise_menu_permission where menu4_id!=0 AND active_till IS null and user_id = $currentUserProfileId union SELECT user_id as user_profile_id, concat('t_3_',menu3_id) as menuid,menu1_id, menu2_id, menu3_id, menu4_id FROM user_wise_menu_permission where menu3_id!=0 and menu4_id=0 AND active_till IS null and user_id = $currentUserProfileId union SELECT user_id as user_profile_id, concat('t_2_',menu2_id) as menuid,menu1_id, menu2_id, menu3_id, menu4_id FROM user_wise_menu_permission where menu2_id!=0 and menu3_id=0 and menu4_id=0 AND active_till IS null and user_id = $currentUserProfileId union SELECT user_id as user_profile_id, concat('t_1_',menu1_id) as menuid,menu1_id, menu2_id, menu3_id, menu4_id FROM user_wise_menu_permission where menu1_id!=0 and menu2_id=0 and menu3_id=0 and menu4_id=0 AND active_till IS null and user_id = $currentUserProfileId union select d.user_profile_id,t.menuid,t.menu1_id, t.menu2_id, t.menu3_id, t.menu4_id from users d inner join user_roles a on d.id = a.user_id inner join hrms_post_assigned c on c.user_id = d.user_profile_id and c.display = 'Y' and c.releaving_date is null inner join role_wise_menu_permission b on b.role_id = a.role_id and b.post_id = c.post_code and b.section_id = sec_code and b.active_till is null and a.active_till is null inner join ( select role_id, post_id, section_id, concat('t_4_', menu4_id) as menuid, menu1_id, menu2_id, menu3_id, menu4_id from role_wise_menu_permission where menu4_id != 0 union select role_id, post_id, section_id, concat('t_3_', menu3_id) as menuid, menu1_id, menu2_id, menu3_id, 0 menu4_id from role_wise_menu_permission where menu3_id != 0 and menu4_id = 0 union select role_id, post_id, section_id, concat('t_2_', menu2_id) as menuid, menu1_id, menu2_id, 0 menu3_id, 0 menu4_id from role_wise_menu_permission where menu2_id != 0 and menu3_id = 0 and menu4_id = 0 union select role_id, post_id, section_id, concat('t_1_', menu1_id) as menuid, menu1_id, 0 menu2_id, 0 menu3_id, 0 menu4_id from role_wise_menu_permission where menu1_id != 0 and menu2_id = 0 and menu3_id = 0 and menu4_id = 0 ) t on t.role_id = b.role_id and t.post_id = b.post_id and t.section_id = b.section_id and t.menu1_id=b.menu1_id and t.menu2_id=b.menu2_id and t.menu3_id=b.menu3_id and t.menu4_id=b.menu4_id left join revoked_menu_permission rp on rp.user_id=d.user_profile_id and rp.active_till is null and rp.menu1_id= b.menu1_id and rp.menu2_id= b.menu2_id and rp.menu3_id= b.menu3_id and rp.menu4_id= b.menu4_id where d.user_profile_id = $currentUserProfileId and rp.id is null " ); $menuNew =[]; // $result= \DB::table('master_menu_level_1 as a')->where('a.display','=','Y')->orderBY('a.sorting_order','asc')->select('a.id','a.menu_name','a.menu_link','a.sorting_order','a.display','a.icon')->orderBy('a.id', 'asc')->distinct()->get(); $uniqueids_1 = array_unique(array_map(function ($i) { return $i->menu1_id; }, $sql)); $result= \DB::table('master_menu_level_1 as a')->where('a.display','=','Y')->when($checkHideForDC, function ($query) use ($checkHideForDC) { if ($checkHideForDC == 'Y') { return $query->whereNull('a.hide_for_dc');} })->orderBY('a.sorting_order','asc')->select('a.id','a.menu_name','a.menu_link','a.sorting_order','a.display','a.icon')->whereIn('a.id', $uniqueids_1)->orderBy('a.id', 'asc')->distinct()->get(); foreach($result as $value){ $filterBy = $value->id; $uniqueids_2_temp = collect($sql)->where('menu1_id', $filterBy)->all(); $uniqueids_2 = array_unique(array_map(function ($i) { return $i->menu2_id; }, $uniqueids_2_temp)); $result1= \DB::table('master_menu_level_2 as b')->where('b.display','=','Y')->where('b.menu_level_1_id','=',$value->id)->when($checkHideForDC, function ($query) use ($checkHideForDC) { if ($checkHideForDC == 'Y') { return $query->whereNull('b.hide_for_dc');} })->whereIn('b.id', $uniqueids_2)->orderBY('b.sorting_order','asc')->select('b.id','b.menu_name','b.menu_link','b.sorting_order','b.display','b.icon','b.menu_level_1_id')->orderBy('b.id', 'asc')->distinct()->get(); // $result1= \DB::table('master_menu_level_2 as b')->where('b.display','=','Y')->where('b.menu_level_1_id','=',$value->id)->orderBY('b.sorting_order','asc')->select('b.id','b.menu_name','b.menu_link','b.sorting_order','b.display','b.icon','b.menu_level_1_id')->orderBy('b.id', 'asc')->distinct()->get(); $menu1=[]; foreach($result1 as $value1){ $filterBy1 = $value1->id; $uniqueids_3_temp = collect($sql)->where('menu1_id', $filterBy)->where('menu2_id', $filterBy1)->all(); $uniqueids_3 = array_unique(array_map(function ($i) { return $i->menu3_id; }, $uniqueids_3_temp)); $result2= \DB::table('master_menu_level_3 as b')->where('b.display','=','Y')->where('b.menu_level_1_id','=',$value->id)->where('b.menu_level_2_id','=',$value1->id)->when($checkHideForDC, function ($query) use ($checkHideForDC) { if ($checkHideForDC == 'Y') { return $query->whereNull('b.hide_for_dc');} })->whereIn('b.id', $uniqueids_3)->orderBY('b.sorting_order','asc')->select('b.id','b.menu_name','b.menu_link','b.sorting_order','b.display','b.icon','b.menu_level_1_id','b.menu_level_2_id')->orderBy('b.id', 'asc')->distinct()->get(); // $result2= \DB::table('master_menu_level_3 as b')->where('b.display','=','Y')->where('b.menu_level_1_id','=',$value->id)->where('b.menu_level_2_id','=',$value1->id)->orderBY('b.sorting_order','asc')->select('b.id','b.menu_name','b.menu_link','b.sorting_order','b.display','b.icon','b.menu_level_1_id','b.menu_level_2_id')->orderBy('b.id', 'asc')->distinct()->get(); $menu2=[]; foreach($result2 as $value2){ $tmenu2=['icon' => ($value2->icon!='' ? $value2->icon : 'fa fa-sitemap'), 'title' => $value2->menu_name, 'url' => ($value2->menu_link!='' ? $value2->menu_link : 'javascript:;') ]; array_push($menu2,$tmenu2); } $tmenu1=['icon' => ($value1->icon!='' ? $value1->icon : 'fa fa-sitemap'), 'title' => $value1->menu_name, 'url' => ($value1->menu_link!='' ? $value1->menu_link : 'javascript:;'), 'caret' => (count($menu2)>0 ? true : false), 'sub_menu' => $menu2 ]; array_push($menu1,$tmenu1); } $tmenu=['icon' => ($value->icon!='' ? $value->icon : 'fa fa-sitemap'), 'title' => $value->menu_name, 'url' => ($value->menu_link!='' ? $value->menu_link : 'javascript:;'), 'caret' => (count($menu1)>0 ? true : false), 'sub_menu' => $menu1 ]; array_push($menuNew,$tmenu); } //foreach (config('sidebar.menu') as $key => $menu) { foreach ($menuNew as $key => $menu) { $GLOBALS['parent_active'] = ''; $hasSub = (!empty($menu['sub_menu'])) ? 'has-sub' : ''; $hasCaret = (!empty($menu['caret'])) ? '' : ''; $hasIcon = (!empty($menu['icon'])) ? '' : ''; $hasImg = (!empty($menu['img'])) ? '' : ''; $hasLabel = (!empty($menu['label'])) ? ''. $menu['label'] .'' : ''; $hasTitle = (!empty($menu['title'])) ? '' : ''; $hasBadge = (!empty($menu['badge'])) ? '' : ''; $subMenu = ''; if (!empty($menu['sub_menu'])) { $GLOBALS['sub_level'] = 0; $subMenu .= ''; } $active = (!empty($menu['route-name']) && (Route::currentRouteName() == $menu['route-name'])) ? 'active' : ''; $active = (empty($active) && !empty($GLOBALS['parent_active'])) ? 'active' : $active; echo ' '; } } else { @endphp @php } @endphp