PHP Decode

<?php 
session_start(); 
require_once './config/config.php'; 
require_once 'includes/auth_validate.php'; 
 
//Get DB instance. function is defined in config.php 
$db = getDbInstance(); 
$db1 = getDbInstance(); 
$db2 = getDbInstance(); 
 
//Get Dashboard information 
 
   
 
// $numCustomers = $db->getValue ("AppInfo", "AppDownload"); 
// $rows = $db1->get('TemplateStatistics'); 
// $rows1 = $db2->get('HashTagStatistics'); 
 
 
 
include_once('includes/header.php'); 
?> 
<div id="page-wrapper"> 
    <div class="row"> 
        <div class="col-lg-12"> 
            <h1 class="page-header">Dashboard</h1> 
        </div> 
        <!-- /.col-lg-12 --> 
    </div> 
    <!-- /.row --> 
    <div class="row"> 
     
        <div class="col-lg-3 col-md-6"> 
            <div class=""> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-1"> 
                            <i class="fa fa-user fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"><?php echo $numCustomers; ?></div> 
                            <div>App Download</div> 
                        </div> 
                       
                        <style> 
.vl { 
  border-left: 6px solid green; 
  height: 150px; 
} 
</style> 
                    </div> 
                       
                </div> 
             
            </div> 
        </div> 
        <div "class="text-right"></div> 
        </div> 
         <div> 
            <h2  style=" margin-top: 0px; " > Today's Statistics</h2> 
        </div> 
        <div class="row" style=" 
    margin-top: 15px;"> 
             
        <div class="col-lg-3 col-md-6" > 
            <div class="panel panel-green"> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-3"> 
                            <i class="fa fa-tasks fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"> 
                                <?php $TotalDownload = 0; foreach ($rows as $row); ?> 
                                <td  style='text-align:center; vertical-align:middle'> 
   
   
 <?php 
$data = json_decode($row['Statistics'], TRUE); 
 
 
usort($data, function ($a, $b){ 
      return $b['date'] - $a['date'];}); 
 
foreach($data as $element) { 
     
    $timestamp = strtotime($element['date']); 
    $date = date("d-m-Y", $timestamp); //truncate hours:minutes:seconds 
    $date1 =date("d-m-Y", time()); 
    if($date1==$date) 
    { 
    $TotalDownload += $element['downloadCount']; 
    } 
}		 
 
 
 
?>	 
 
</td> 
         <?php endforeach; 
	echo $TotalDownload; 
	     ?> 
          
          
    
 
         </div> 
          
                            <div>Template Downaload!</div> 
                        </div> 
                    </div> 
                </div> 
                 
            </div> 
        </div> 
        <div class="col-lg-3 col-md-6"> 
            <div class="panel panel-green"> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-3"> 
                            <i class="fa fa-tasks fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"> 
                                 
                                <?php  $TotalShare = 0; foreach ($rows as $row): ?> 
                                <td  style='text-align:center; vertical-align:middle'> 
   
   
 <?php 
$sortedData = array(); 
$data = json_decode($row['Statistics'], TRUE); 
 
 
 usort($data, function ($a, $b){ 
      return $b['date'] - $a['date'];}); 
       
 
foreach($data as $element) { 
     
    $timestamp = strtotime($element['date']); 
    $date = date("d-m-Y", $timestamp); //truncate hours:minutes:seconds 
    $date1 =date("d-m-Y", time()); 
    if($date1==$date) 
    { 
 
    $TotalShare += $element['sharecount']; 
    } 
}		 
 
 
 
?>	 
 
</td> 
         <?php endforeach; 
	echo $TotalShare; 
	     ?> 
          
          
    
 
         </div> 
          
                            <div>Template Share!</div> 
                        </div> 
                    </div> 
                </div> 
                 
            </div> 
        </div> 
        <div class="col-lg-3 col-md-6"> 
            <div class="panel panel-green"> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-3"> 
                            <i class="fa fa-tasks fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"> 
                                 
                                <?php  $Count = 0; foreach ($rows1 as $row): ?> 
                                <td  style='text-align:center; vertical-align:middle'> 
   
   
 <?php 
$data = json_decode($row['Statistics'], TRUE); 
 
 
 usort($data, function ($a, $b){ 
      return $b['date'] - $a['date'];}); 
      
foreach($data as $element) { 
     
    $timestamp = strtotime($element['date']); 
    $date = date("d-m-Y", $timestamp); //truncate hours:minutes:seconds 
    $date1 =date("d-m-Y", time()); 
    if($date1==$date) 
    { 
 
    $Count += $element['count']; 
    } 
}		 
 
 
 
?>	 
 
</td> 
         <?php endforeach; 
	echo $Count; 
	     ?> 
          
          
    
 
         </div> 
          
                            <div>HashTag Count!</div> 
                        </div> 
                    </div> 
                </div> 
                 
            </div> 
        </div> 
        <div class="col-lg-3 col-md-6"> 
             
        </div> 
    </div> 
    <!-- /.row --> 
    <div class="row"> 
        <div class="col-lg-8"> 
 
 
            <!-- /.panel --> 
        </div> 
        <!-- /.col-lg-8 --> 
        <div class="col-lg-4"> 
 
            <!-- /.panel .chat-panel --> 
        </div> 
        <!-- /.col-lg-4 --> 
    </div> 
     
 <div> 
            <h2  style=" margin-top: 0px; " > This Weeks's Statistics</h2> 
        </div> 
        <div class="row" style=" 
    margin-top: 15px;"> 
             
        <div class="col-lg-3 col-md-6" > 
            <div class="panel panel-green"> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-3"> 
                            <i class="fa fa-tasks fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"> 
                                <?php $TotalDownload = 0; foreach ($rows as $row): ?> 
                                <td  style='text-align:center; vertical-align:middle'> 
   
   
 <?php 
$data = json_decode($row['Statistics'], TRUE); 
 
 
usort($data, function ($a, $b){ 
      return $b['date'] - $a['date'];}); 
 
$count=0; 
 
foreach($data as $element) { 
     
    $timestamp = strtotime($element['date']); 
    $date = date("d-m-Y", $timestamp); //truncate hours:minutes:seconds 
    $date1 =date("d-m-Y", time()); 
    if($count< 7) 
    { 
    $TotalDownload += $element['downloadCount']; 
    } 
    $count++; 
     
}		 
 
 
 
?>	 
 
</td> 
         <?php endforeach; 
	echo $TotalDownload; 
	     ?> 
          
          
    
 
         </div> 
          
                            <div>Template Downaload!</div> 
                        </div> 
                    </div> 
                </div> 
                 
            </div> 
        </div> 
        <div class="col-lg-3 col-md-6"> 
            <div class="panel panel-green"> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-3"> 
                            <i class="fa fa-tasks fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"> 
                                 
                                <?php  $TotalShare = 0; foreach ($rows as $row): ?> 
                                <td  style='text-align:center; vertical-align:middle'> 
   
   
 <?php 
$sortedData = array(); 
$data = json_decode($row['Statistics'], TRUE); 
 
 
 usort($data, function ($a, $b){ 
      return $b['date'] - $a['date'];}); 
      $count=0; 
 
 
foreach($data as $element) { 
     
    $timestamp = strtotime($element['date']); 
    $date = date("d-m-Y", $timestamp); //truncate hours:minutes:seconds 
    $date1 =date("d-m-Y", time()); 
    if($count < 7) 
    { 
    $TotalShare += $element['sharecount']; 
    } 
    $count++; 
}		 
 
 
 
?>	 
 
</td> 
         <?php endforeach; 
	echo $TotalShare; 
	     ?> 
          
          
    
 
         </div> 
          
                            <div>Template Share!</div> 
                        </div> 
                    </div> 
                </div> 
                 
            </div> 
        </div> 
        <div class="col-lg-3 col-md-6"> 
            <div class="panel panel-green"> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-3"> 
                            <i class="fa fa-tasks fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"> 
                                 
                                <?php  $Count = 0; foreach ($rows1 as $row): ?> 
                                <td  style='text-align:center; vertical-align:middle'> 
   
   
 <?php 
$data = json_decode($row['Statistics'], TRUE); 
 
 
 usort($data, function ($a, $b){ 
      return $b['date'] - $a['date'];}); 
       
$counter=0; 
foreach($data as $element) { 
     
    $timestamp = strtotime($element['date']); 
    $date = date("d-m-Y", $timestamp); //truncate hours:minutes:seconds 
    $date1 =date("d-m-Y", time()); 
    if($counter<7) 
    { 
    $Count += $element['count']; 
    } 
    $counter++; 
}		 
 
 
 
?>	 
 
</td> 
         <?php endforeach; 
	echo $Count; 
	     ?> 
          
          
    
 
         </div> 
          
                            <div>HashTag Count!</div> 
                        </div> 
                    </div> 
                </div> 
                 
            </div> 
        </div> 
        <div class="col-lg-3 col-md-6"> 
             
        </div> 
    </div> 
    <!-- /.row --> 
    <div class="row"> 
        <div class="col-lg-8"> 
 
 
            <!-- /.panel --> 
        </div> 
        <!-- /.col-lg-8 --> 
        <div class="col-lg-4"> 
 
            <!-- /.panel .chat-panel --> 
        </div> 
        <!-- /.col-lg-4 --> 
    </div> 
    <!-- /.row --> 
     
     
     
     <div> 
            <h2  style=" margin-top: 0px; " > This Month's Statistics</h2> 
        </div> 
        <div class="row" style=" 
    margin-top: 15px;"> 
             
        <div class="col-lg-3 col-md-6" > 
            <div class="panel panel-green"> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-3"> 
                            <i class="fa fa-tasks fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"> 
                                <?php $TotalDownload = 0; foreach ($rows as $row): ?> 
                                <td  style='text-align:center; vertical-align:middle'> 
   
   
 <?php 
$data = json_decode($row['Statistics'], TRUE); 
 
 
usort($data, function ($a, $b){ 
      return $b['date'] - $a['date'];}); 
 
$count=0; 
 
foreach($data as $element) { 
     
    $timestamp = strtotime($element['date']); 
    $date = date("d-m-Y", $timestamp); //truncate hours:minutes:seconds 
    $date1 =date("d-m-Y", time()); 
    if($count<30) 
    { 
    $TotalDownload += $element['downloadCount']; 
 
    } 
    $count++; 
     
}		 
 
 
 
?>	 
 
</td> 
         <?php endforeach; 
	echo $TotalDownload; 
	     ?> 
          
          
    
 
         </div> 
          
                            <div>Template Downaload!</div> 
                        </div> 
                    </div> 
                </div> 
                 
            </div> 
        </div> 
        <div class="col-lg-3 col-md-6"> 
            <div class="panel panel-green"> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-3"> 
                            <i class="fa fa-tasks fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"> 
                                 
                                <?php  $TotalShare = 0; foreach ($rows as $row): ?> 
                                <td  style='text-align:center; vertical-align:middle'> 
   
   
 <?php 
$sortedData = array(); 
$data = json_decode($row['Statistics'], TRUE); 
 
 
 usort($data, function ($a, $b){ 
      return $b['date'] - $a['date'];}); 
       
      $count=0; 
 
 
foreach($data as $element) { 
     
    $timestamp = strtotime($element['date']); 
    $date = date("d-m-Y", $timestamp); //truncate hours:minutes:seconds 
    $date1 =date("d-m-Y", time()); 
    if($count<30) 
    { 
    $TotalShare += $element['sharecount']; 
    } 
    $count++; 
}		 
 
 
 
?>	 
 
</td> 
         <?php endforeach; 
	echo $TotalShare; 
	     ?> 
          
          
    
 
         </div> 
          
                            <div>Template Share!</div> 
                        </div> 
                    </div> 
                </div> 
                 
            </div> 
        </div> 
        <div class="col-lg-3 col-md-6"> 
            <div class="panel panel-green"> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-3"> 
                            <i class="fa fa-tasks fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"> 
                                 
                                <?php  $Count = 0; foreach ($rows1 as $row): ?> 
                                <td  style='text-align:center; vertical-align:middle'> 
   
   
 <?php 
$data = json_decode($row['Statistics'], TRUE); 
 
 
 usort($data, function ($a, $b){ 
      return $b['date'] - $a['date'];}); 
       
$counter=0; 
foreach($data as $element) { 
     
    $timestamp = strtotime($element['date']); 
    $date = date("d-m-Y", $timestamp); //truncate hours:minutes:seconds 
    $date1 =date("d-m-Y", time()); 
    if($counter<30) 
    { 
    $Count += $element['count']; 
    } 
    $counter++; 
}		 
 
 
 
?>	 
 
</td> 
         <?php endforeach; 
	echo $Count; 
	     ?> 
          
          
    
 
         </div> 
          
                            <div>HashTag Count!</div> 
                        </div> 
                    </div> 
                </div> 
                 
            </div> 
        </div> 
        <div class="col-lg-3 col-md-6"> 
             
        </div> 
    </div> 
    <!-- /.row --> 
    <div class="row"> 
        <div class="col-lg-8"> 
 
 
            <!-- /.panel --> 
        </div> 
        <!-- /.col-lg-8 --> 
        <div class="col-lg-4"> 
 
            <!-- /.panel .chat-panel --> 
        </div> 
        <!-- /.col-lg-4 --> 
    </div> 
   <div> 
            <h2  style=" margin-top: 0px; " > This Year's Statistics</h2> 
        </div> 
        <div class="row" style=" 
    margin-top: 15px;"> 
             
        <div class="col-lg-3 col-md-6" > 
            <div class="panel panel-green"> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-3"> 
                            <i class="fa fa-tasks fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"> 
                                <?php $TotalDownload = 0; foreach ($rows as $row): ?> 
                                <td  style='text-align:center; vertical-align:middle'> 
   
   
 <?php 
$data = json_decode($row['Statistics'], TRUE); 
 
 
usort($data, function ($a, $b){ 
      return $b['date'] - $a['date'];}); 
 
 
foreach($data as $element) { 
     
    $timestamp = strtotime($element['date']); 
    $date = date("d-m-Y", $timestamp); //truncate hours:minutes:seconds 
    $date1 =date("d-m-Y", time()); 
    $TotalDownload += $element['downloadCount']; 
 
     
     
}		 
 
 
 
?>	 
 
</td> 
         <?php endforeach; 
	echo $TotalDownload; 
	     ?> 
          
          
    
 
         </div> 
          
                            <div>Template Downaload!</div> 
                        </div> 
                    </div> 
                </div> 
                 
            </div> 
        </div> 
        <div class="col-lg-3 col-md-6"> 
            <div class="panel panel-green"> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-3"> 
                            <i class="fa fa-tasks fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"> 
                                 
                                <?php  $TotalShare = 0; foreach ($rows as $row): ?> 
                                <td  style='text-align:center; vertical-align:middle'> 
   
   
 <?php 
$sortedData = array(); 
$data = json_decode($row['Statistics'], TRUE); 
 
 
 usort($data, function ($a, $b){ 
      return $b['date'] - $a['date'];}); 
     
 
foreach($data as $element) { 
     
    $timestamp = strtotime($element['date']); 
    $date = date("d-m-Y", $timestamp); //truncate hours:minutes:seconds 
    $TotalShare += $element['sharecount']; 
     
}		 
 
 
 
?>	 
 
</td> 
         <?php endforeach; 
	echo $TotalShare; 
	     ?> 
          
          
    
 
         </div> 
          
                            <div>Template Share!</div> 
                        </div> 
                    </div> 
                </div> 
                 
            </div> 
        </div> 
        <div class="col-lg-3 col-md-6"> 
            <div class="panel panel-green"> 
                <div class="panel-heading"> 
                    <div class="row"> 
                        <div class="col-xs-3"> 
                            <i class="fa fa-tasks fa-5x"></i> 
                        </div> 
                        <div class="col-xs-9 text-right"> 
                            <div class="huge"> 
                                 
                                <?php  $Count = 0; foreach ($rows1 as $row): ?> 
                                <td  style='text-align:center; vertical-align:middle'> 
   
   
 <?php 
$data = json_decode($row['Statistics'], TRUE); 
 
 
 usort($data, function ($a, $b){ 
      return $b['date'] - $a['date'];}); 
       
foreach($data as $element) { 
     
    $timestamp = strtotime($element['date']); 
    $date = date("d-m-Y", $timestamp); //truncate hours:minutes:seconds 
    $date1 =date("d-m-Y", time()); 
    $Count += $element['count']; 
}		 
 
 
 
?>	 
 
</td> 
         <?php endforeach; 
	echo $Count; 
	     ?> 
          
          
    
 
         </div> 
          
                            <div>HashTag Count!</div> 
                        </div> 
                    </div> 
                </div> 
                 
            </div> 
        </div> 
        <div class="col-lg-3 col-md-6"> 
             
        </div> 
    </div> 
    <!-- /.row --> 
    <div class="row"> 
        <div class="col-lg-8"> 
 
 
            <!-- /.panel --> 
        </div> 
        <!-- /.col-lg-8 --> 
        <div class="col-lg-4"> 
 
            <!-- /.panel .chat-panel --> 
        </div> 
        <!-- /.col-lg-4 --> 
    </div> 
 
</div> 
<!-- /#page-wrapper --> 
 
<?php include_once('includes/footer.php'); ?>