@php
	$appSidebarClass = (!empty($appSidebarTransparent)) ? 'app-sidebar-transparent' : '';
@endphp
<!-- BEGIN #sidebar -->
<div id="sidebar" class="app-sidebar {{ $appSidebarClass }}">

	<!-- BEGIN scrollbar -->
	<div class="app-sidebar-content" data-scrollbar="true" data-height="100%">

		<div class="menu">

                    <div class="menu-search mb-n3">
      <input type="text" class="form-control" placeholder="Sidebar menu filter..." data-sidebar-search="true">
    </div>


	@if(auth()->user())
			@if (!$appSidebarSearch)
			<!-- <div class="menu-profile">
				<a href="javascript:;" class="menu-profile-link" data-toggle="app-sidebar-profile" data-target="#appSidebarProfileMenu">
					<div class="menu-profile-cover with-shadow"></div>
					<div class="menu-profile-image menu-profile-image-icon bg-gray-900 text-gray-600">
						<i class="fa fa-user"></i>
					</div>
					<div class="menu-profile-info">
						<div class="d-flex align-items-center">
							<div class="flex-grow-1">
								Sean Ngu
							</div>
							<div class="menu-caret ms-auto"></div>
						</div>
						<small>Front end developer</small>
					</div>
				</a>
			</div> -->
			<div id="appSidebarProfileMenu" class="collapse">
				<div class="menu-item pt-5px">
					<a href="javascript:;" class="menu-link">
						<div class="menu-icon"><i class="fa fa-cog"></i></div>
						<div class="menu-text">Settings</div>
					</a>
				</div>
				<div class="menu-item">
					<a href="javascript:;" class="menu-link">
						<div class="menu-icon"><i class="fa fa-pencil-alt"></i></div>
						<div class="menu-text"> Send Feedback</div>
					</a>
				</div>
				<div class="menu-item pb-5px">
					<a href="javascript:;" class="menu-link">
						<div class="menu-icon"><i class="fa fa-question-circle"></i></div>
						<div class="menu-text"> Helps</div>
					</a>
				</div>
				<div class="menu-divider m-0"></div>
			</div>
			@endif
			
			@if ($appSidebarSearch)
			<div class="menu-search mb-n3">
        <input type="text" class="form-control" placeholder="Sidebar menu filter..." data-sidebar-search="true" />
			</div>
			@endif
			
			<div class="menu-header">Navigation</div>
			
			@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'])) ? '<div class="menu-caret"></div>' : '';
						$hasHighlight = (!empty($menu['highlight'])) ? '<i class="fa fa-paper-plane text-theme ms-1"></i>' : '';
						$hasTitle = (!empty($menu['title'])) ? '<div class="menu-text">'. $menu['title'] . $hasHighlight .'</div>' : '';
						
						if (!empty($menu['sub_menu'])) {
							$subSubMenu .= '<div class="menu-submenu">';
							$subSubMenu .= renderSubMenu($menu['sub_menu'], $currentUrl);
							$subSubMenu .= '</div>';
						}
						
						$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 .= '
							<div class="menu-item '. $hasSub .' '. $active .'">
								<a href="'. $menu['url'] .'" class="menu-link">' . $hasTitle . $hasCaret .'</a>
								'. $subSubMenu .'
							</div>
						';
					}
					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'])) ? '<div class="menu-caret"></div>' : '';
					$hasIcon = (!empty($menu['icon'])) ? '<div class="menu-icon"><i class="'. $menu['icon'] .'"></i></div>' : '';
					$hasImg = (!empty($menu['img'])) ? '<div class="menu-icon-img"><img src="'. $menu['img'] .'" /></div>' : '';
					$hasLabel = (!empty($menu['label'])) ? '<span class="menu-label">'. $menu['label'] .'</span>' : '';
					$hasTitle = (!empty($menu['title'])) ? '<div class="menu-text">'. $menu['title'] . $hasLabel .'</div>' : '';
					$hasBadge = (!empty($menu['badge'])) ? '<div class="menu-badge">'. $menu['badge'] .'</div>' : '';
					
					$subMenu = '';
					
					if (!empty($menu['sub_menu'])) {
						$GLOBALS['sub_level'] = 0;
						$subMenu .= '<div class="menu-submenu">';
						$subMenu .= renderSubMenu($menu['sub_menu'], $currentUrl);
						$subMenu .= '</div>';
					}
					$active = (!empty($menu['route-name']) && (Route::currentRouteName() == $menu['route-name'])) ? 'active' : '';
					$active = (empty($active) && !empty($GLOBALS['parent_active'])) ? 'active' : $active;
					echo '
						<div class="menu-item '. $hasSub .' '. $active .'">
							<a href="'. $menu['url'] .'" class="menu-link">
								'. $hasImg .'
								'. $hasIcon .'
								'. $hasTitle .'
								'. $hasBadge .'
								'. $hasCaret .'
							</a>
							'. $subMenu .'
						</div>
					';
				}
			}
			else {
						@endphp
                        <div class="menu-item">
                        <a href="/advocate/dashboard" class="menu-link"><div class="menu-text">Dashboard</div></a>
                        <a href="/MyPending" class="menu-link"><div class="menu-text">Case Diary</div></a>
                        <a href="/add_clerk" class="menu-link"><div class="menu-text">Clerk Registration</div></a>
                        <a href="/myclerk" class="menu-link"><div class="menu-text">My Registered Clerk</div></a>
                        <a href="/advocate/hccopying" class="menu-link"><div class="menu-text">Copying Request</div></a>
                        <a href="/ecauselist-advocate" class="menu-link"><div class="menu-text">eCauselist Advocate</div></a>
            </div>
						<!-- <div class="menu-item has-sub ">
                 
                <a href="javascript:;" class="menu-link">
                    <div class="menu-icon"><i class="fa fa-align-left"></i></div>
                    <div class="menu-text">Advocate</div>
                    <div class="menu-caret"></div>
                </a>
                <div class="menu-submenu">
                    <div class="menu-item  ">
                        <a href="/advocate/dashboard" class="menu-link"><div class="menu-text">Dashboard</div></a>
                        
                    </div> 
                     <div class="menu-item  ">
                        <a href="/MyPending" class="menu-link"><div class="menu-text">Case Diary</div></a>
                        
                    </div> 
					 <div class="menu-item  ">
                       <a href="/add_clerk" class="menu-link"><div class="menu-text">Clerk Registration</div></a>
                        
                    </div>
                    <div class="menu-item  ">
                       <a href="/advocate/hccopying" class="menu-link"><div class="menu-text">Copying Request</div></a>
                        
                    </div> 
                     <div class="menu-item  ">
                       <a href="/ecauselist-advocate" class="menu-link"><div class="menu-text">eCauselist Advocate</div></a>
                        
                    </div>
					
                </div>
            </div>  -->
						@php
			}
			@endphp
			@else 
			<div class="menu-item has-sub ">
                <a href="javascript:;" class="menu-link">
                    <div class="menu-icon"><i class="fa fa-align-left"></i></div>
                    <div class="menu-text">RTI</div>
                    <div class="menu-caret"></div>
                </a>
                <div class="menu-submenu">
                    <div class="menu-item  ">
                        <a href="/online_rti/online" class="menu-link"><div class="menu-text">New Application</div></a>
                    </div>
                   
                </div>
            </div> 
			@endif
			<!-- BEGIN minify-button -->
			<div class="menu-item d-flex">
				<a href="javascript:;" class="app-sidebar-minify-btn ms-auto" data-toggle="app-sidebar-minify"><i class="fa fa-angle-double-left"></i></a>
			</div>
			<!-- END minify-button -->
		
		</div>
		<!-- END menu -->
	</div>
	<!-- END scrollbar -->
</div>
<div class="app-sidebar-bg"></div>
<div class="app-sidebar-mobile-backdrop"><a href="#" data-dismiss="app-sidebar-mobile" class="stretched-link"></a></div>
<!-- END #sidebar -->