<style>
    
    .navbar .brand {
    color: #333;
    font-weight: bold;
    font-size: 20px;
    margin-right: 16px;
    padding: 5px;
}

.module {
    box-shadow: 0 0 3px rgb(0 0 0 / 10%);
    border-color: #e9e9e9;
    margin-bottom: 20px;
    background-color: #fff;
    border-radius: 4px;
    -webkit-box-shadow: 0 1px 1px rgb(0 0 0 / 5%);
    box-shadow: 0 1px 1px rgb(0 0 0 / 5%);
    background-color: #FFF;
    color: rgba(58, 53, 65, 0.87);
    -webkit-transition: box-shadow 300ms cubic-bezier(0.4, 0, 0.2, 1) 0ms;
    transition: box-shadow 300ms cubic-bezier(0.4, 0, 0.2, 1) 0ms;
    border-radius: 6px;
    box-shadow: 0px 2px 1px -1px rgb(58 53 65 / 20%), 0px 1px 1px 0px rgb(58 53 65 / 14%), 0px 1px 3px 0px rgb(58 53 65 / 12%);
    background-image: none;
    overflow: hidden;
    box-shadow: 0px 2px 10px 0px rgb(58 53 65 / 10%);
    position: relative;
}
.navbar {
    position: static!important;
    margin: 0!important;
    box-shadow: 0 1px 2px rgb(0 0 0 / 10%);
}
.wrapper {
    background: url(../images/bg.png) #fffaf0;
    border-bottom: none;
    -webkit-box-shadow: none;
    -moz-box-shadow: none;
    box-shadow: none;
    padding: 30px 0;
}
.wrapper {
    background: url(../images/bg.png) #f4f2ed;
    border-bottom: none;
    -webkit-box-shadow: none;
    -moz-box-shadow: none;
    box-shadow: none;
    padding: 0px 0;
}
.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: 29PX;
}
</style>


<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/superadmin/notprocess-complaint.php">
											<i class="icon-tasks"></i>
											Open Complaints
											<?php
$rt = mysqli_query($conn,"SELECT * FROM tblcomplaints where status is null AND role IN('admin','civil','transport')");
$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/superadmin/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 role IN('admin','civil','transport')");
$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/superadmin/closed-complaint.php">
											<i class="icon-inbox"></i>
											Closed / Resolved
	     <?php 
$status="closed";                   
$rt = mysqli_query($conn,"SELECT * FROM tblcomplaints where (status='$status' OR status='Resolved') AND role IN('admin','civil','transport')");
$num1 = mysqli_num_rows($rt);
{?><b class="label green pull-right"><?php echo htmlentities($num1); ?></b>
<?php } ?>

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


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

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