<?php include("includes/header.php");

$qry_cat="SELECT COUNT(*) as num FROM tbl_ringtone where tbl_ringtone.status=1";
$total_radio= mysqli_fetch_array(mysqli_query($mysqli,$qry_cat));
$total_radio = $total_radio['num'];

$qry_views="SELECT SUM(total_views) as num FROM tbl_ringtone";
$total_views= mysqli_fetch_array(mysqli_query($mysqli,$qry_views));
$total_views = $total_views['num'];

$qry_cat="SELECT COUNT(*) as num FROM tbl_category";
$total_category= mysqli_fetch_array(mysqli_query($mysqli,$qry_cat));
$total_category = $total_category['num'];


$qry_dwn="SELECT SUM(total_download) as num FROM tbl_ringtone";
$total_download= mysqli_fetch_array(mysqli_query($mysqli,$qry_dwn));
$total_download = $total_download['num'];

// $qry_user="SELECT COUNT(*) as num FROM tbl_users";
// $total_user= mysqli_fetch_array(mysqli_query($mysqli,$qry_user));
// $total_user = $total_user['num'];


// $qry_approval="SELECT COUNT(*) as num FROM tbl_ringtone where tbl_ringtone.status=0";
// $total_approval= mysqli_fetch_array(mysqli_query($mysqli,$qry_approval));
// $total_approval = $total_approval['num'];





?>       


        <div class="btn-floating" id="help-actions">
      <div class="btn-bg"></div>
      
      
    </div>

    <div class="row">
        <Style>
           
           .rad-info-box{
	margin-bottom:16px;
	padding:20px;
	background: #fff;
	border: 1px solid #dadce0;
	border-radius: 10px;
}

.rad-info-box i{
	display:block;
	background-clip:padding-box;
	margin-right:15px;
	height:60px;
	width:60px;
	border-radius:100%;
	line-height:60px;
	text-align:center;
	font-size:4.4em;
	position:absolute;	
}

.rad-info-box .value,
.rad-info-box .heading{
	display:block;	
	position:relative;
	color: $text-color;
	text-align:right;
	z-index:10;
}

.rad-info-box .heading{
	font-size:1.2em;
	font-weight:300;
	text-transform:uppercase;
}

.rad-info-box .value{
	font-size:2.1em;
	font-weight:600;
	margin-top:5px;
}

.rad-list-group-item{
	margin:5px 10px 25px 5px;	
	
	&:after{
		content:"";
		display:table;
	}
}
.rad-txt-primary{
	color:#1C7EBB;
}
.rad-bg-primary{
	background:#1C7EBB;
}
.rad-txt-success{
	color:#23AE89;
}
.rad-bg-success{
	background:#23AE89;
}


.rad-txt-danger{
	color:#E94B3B;
}
.rad-bg-danger{
	background:#E94B3B;
}
.rad-txt-warning{
	color:#F98E33;
}
.rad-bg-warning{
	background:#F98E33;
}
.rad-txt-violet{
	color:#6A55C2;
}
.rad-bg-violet{
	background:#6A55C2;
}

.rad-txt-banner{
	color:#ffbc00;
}

.rad-txt-playlist{
	color:#ff00b1;
}

.rad-txt-suggestion{
	color:#00b83f;
}

.rad-txt-rating{
	color:#ff006a;
}
.rad-txt-reports{
	color:#8d9293;
}


        </Style>
        <div class="row">
					<div class="col-lg-4 col-xs-6">
						<div class="rad-info-box my rad-txt-success">
							<i class="icon fa fa-sitemap"></i>
							<span class="heading">Categories</span>
							<span class="value"><span data-purecounter-duration="1.0" data-purecounter-end="<?php echo $total_category;?>"class="purecounter">0</span></span>
   
						</div>
					</div>
					<div class="col-lg-4 col-xs-6">
						<div class="rad-info-box my rad-txt-primary">
							<i class="fa fa-music"></i>
							<span class="heading">Total Ringtone</span>
							<span class="value"><span data-purecounter-duration="1.0" data-purecounter-end="<?php echo $total_radio;?>"class="purecounter">0</span></span>
						
						</div>
					</div>
					<div class="col-lg-4 my col-xs-6">
						<div class="rad-info-box rad-txt-danger">
							<i class="icon fa fa-eye"></i>
							<span class="heading">Total Views</span>
							<span class="value"><span data-purecounter-duration="1.0" data-purecounter-end="<?php echo $total_views;?>"class="purecounter">0</span></span>
						
						</div>
					</div>
					
					
					
					<div class="col-lg-4 my col-xs-6">
						<div class="rad-info-box">
							<i class="icon fa fa-user-md"></i>
							<span class="heading">Admin</span>
							<span class="value"><span>1</span></span>
						</div>
					</div>
					
					
					
					
					
							
				<div class="col-lg-4 col-xs-6">
						<div class="rad-info-box my rad-txt-banner">
							<i class="icon fa fa-cloud-download"></i>
							<span class="heading">Total Download</span>
							<span class="value"><span data-purecounter-duration="1.0" data-purecounter-end="<?php echo $total_download;?>"class="purecounter">0</span></span>
   
						</div>
					</div>
					<!--	<div class="col-lg-3 my col-xs-6">-->
					<!--	<div class="rad-info-box">-->
					<!--		<i class="icon fa fa-user-md"></i>-->
					<!--		<span class="heading">User</span>-->
					<!--		<span class="value"><span data-purecounter-duration="1.0" data-purecounter-end="<?php echo $total_user;?>"class="purecounter">0</span></span>-->
					<!--	</div>-->
					<!--</div>-->
				
				
					<!--<div class="col-lg-3 col-xs-6">-->
					<!--	<div class="rad-info-box rad-txt-reports">-->
					<!--		<i class="fa fa-music"></i>-->
					<!--		<span class="heading">Ringtone Approval</span>-->
					<!--		<span class="value"><span data-purecounter-duration="1.0" data-purecounter-end="<?php echo $total_approval;?>"class="purecounter">0</span></span>-->
						
					<!--	</div>-->
					<!--</div>	-->

					
					
					
				</div>
				
    </div>

        <script async src="dist/purecounter.js"></script>
<?php include("includes/footer.php");?>       
