<style>
    .widget-menu>li>a {
    background-color: #0b4376;
    color: #767676;
    -webkit-transition: all .2s ease-in-out;
    -moz-transition: all .2s ease-in-out;
    transition: all .2s ease-in-out;
}
.widget-menu>li>a {
    background-color: #0b4376;
    color: #ffffff;
    -webkit-transition: all .2s ease-in-out;
    -moz-transition: all .2s ease-in-out;
    transition: all .2s ease-in-out;
}
.widget-menu .menu-icon {
    margin-right: 10px;
    color: #dd8d31;
    -webkit-transition: all .2s ease-in-out;
    -moz-transition: all .2s ease-in-out;
    transition: all .2s ease-in-out;
}
.widget-menu>li ul li {
    background: #0e4d86;
    border-top: 1px solid #1970bf;
}
.widget-menu a {
    color: #fff;
    display: block;
    line-height: 20px;
    padding: 15px;
    text-decoration: none!important;
}
.widget-menu>li ul li a:hover {
    background: #063d6e;
    -webkit-box-shadow: 0 1px 0 #fafafa inset;
    -moz-box-shadow: 0 1px 0 #fafafa inset;
    box-shadow: 0 1px 0 #0b4376 inset;
    border-bottom: 1px solid #062a4a;
    border-top: 1px solid #13416c;
    padding: 9px 15px 9px 30px;
}
.footers {
    position: fixed;
    left: 0;
    bottom: 0;
    width: 100%;
    background-color: #083762;
    color: white !important;
    text-align: center;
    font-weight: bold;
    font-size: 11px;
    line-height: 32px;
}
.span9 {
    width: 74%;
    MARGIN-TOP: 20PX;
    padding-bottom: 50px;
}
.module-head {
    color: #767676;
    background-color: #c6dcf0;
    border-color: #c6dcf0;
    padding: 10px 15px;
    border-bottom: 1px solid transparent;
    border-top-right-radius: 0px;
    border-top-left-radius: 0px;
}
.dataTables_wrapper table th {
    background: #c6dcf0;
    cursor: pointer;
}
.dataTables_wrapper table tr:hover th.sorting_asc, .dataTables_wrapper table tr:hover th.sorting_desc {
    background: #c6dcf0;
}
.table th, .table td {
    padding: 8px;
    line-height: 20px;
    text-align: left;
    vertical-align: top;
    border-top: 1px solid #c6dcf0;
}
.table th, .table td {
    border-color: #c6dcf0!important;
}
.table-striped tbody>tr:nth-child(odd)>td, .table-striped tbody>tr:nth-child(odd)>th {
    background-color: #eff7ff;
}
.module-body.table .table th, .module-body.table .table td {
    padding-left: 15px;
    padding-right: 15px;
    font-size: 13px;
    font-family: inherit;
}
</style>


<div class="span3" style="width:20%;">
					<div class="sidebar" style="    padding-top: 20px;
    background: #0b4376;
    height: 670px;">


<ul class="widget widget-menu unstyled">
							<li>
								<a class="collapsed" data-toggle="collapse" href="#togglePages">
									<i class="menu-icon icon-cog"></i>
									<i class="icon-chevron-down pull-right"></i><i class="icon-chevron-up pull-right"></i>
									Manage Complaint
								</a>
								<ul id="togglePages" class=" unstyled">
									<li>
										<a href="https://vinayakamissions.com/vmcc-ticket/admin/notprocess-complaint.php">
											<i class="icon-tasks"></i>
											Open Complaints
											
											
											
											
											<?php
											
											
											
$rt = mysqli_query($conn,"select tblcomplaints.*,users.fullName as name from tblcomplaints join users on users.id=tblcomplaints.userId where tblcomplaints.status is null AND tblcomplaints.role='$login_role' ");
$num1 = mysqli_num_rows($rt);
{?>
		
		
		
		
		
											<b class="label orange pull-right"><?php echo htmlentities($num1); ?></b>
											<?php } ?>
										</a>
									</li>
									<li>
										<a href="https://vinayakamissions.com/vmcc-ticket/admin/inprocess-complaint.php">
											<i class="icon-tasks"></i>
											In Process Complaints
                   <?php 
$status="in process";                   
$rt = mysqli_query($conn,"SELECT * FROM tblcomplaints where status='$status' AND tblcomplaints.role='$login_role'");
$num1 = mysqli_num_rows($rt);
{?><b class="label orange pull-right"><?php echo htmlentities($num1); ?></b>
<?php } ?>
										</a>
									</li>
									<li>
										<a href="https://vinayakamissions.com/vmcc-ticket/admin/closed-complaint.php">
											<i class="icon-inbox"></i>
											Closed / Resolved
	     <?php 
$status="closed";                   
$rt = mysqli_query($conn,"SELECT * FROM tblcomplaints where role='$login_role' AND (status='$status' OR status='Resolved')");
$num1 = mysqli_num_rows($rt);
{?><b class="label green pull-right"><?php echo htmlentities($num1); ?></b>
<?php } ?>

										</a>
									</li>
									 <?php
				if($login_role=="admin"){
					?>
									<li>
										<a href="https://vinayakamissions.com/vmcc-ticket/admin/event-book.php"><i class="icon-inbox"></i>
											Event Hall Booking</a>
									</li>
									  <?php
                  }
                  ?>
                 		
								</ul>
							</li>
						</ul>
<ul class="widget widget-menu unstyled">
							<li>
								<a class="collapsed" data-toggle="collapse" href="#togglePages">
									<i class="menu-icon icon-cog"></i>
									<i class="icon-chevron-down pull-right"></i><i class="icon-chevron-up pull-right"></i>
									Wifi Registrations
								</a>
								<ul id="togglePages" class=" unstyled">
                 		   <?php
				if($login_role=="ict"){
					?>
								<li><a href="https://vinayakamissions.com/vmcc-ticket/admin/staff-register.php"><i class="menu-icon icon-signal"></i>Staff Registrations </a></li>
								  <li><a href="https://vinayakamissions.com/vmcc-ticket/admin/student-register.php"><i class="menu-icon icon-signal"></i>Student Registrations </a></li>
									  <?php
                  }
                  ?>

                 		
								</ul>
							</li>
						</ul>

						<ul class="widget widget-menu unstyled">
						  
							
						<li><a href="https://vinayakamissions.com/vmcc-ticket/admin/reports/reports.php"><i class="menu-icon icon-download"></i>Reports Download </a></li>
							<li>
								<a href="https://vinayakamissions.com/vmcc-ticket/admin/change-password.php">
									<i class="menu-icon icon-signout"></i>
									Change Password
								</a>
							</li>
							<li>
								<a href="https://vinayakamissions.com/vmcc-ticket/admin/logout.php">
									<i class="menu-icon icon-signout"></i>
									Logout
								</a>
							</li>
						</ul>

					</div><!--/.sidebar-->
				</div><!--/.span3-->
