<?php

include ("../../../inc/includes.php");
include ("../../../inc/config.php");

global $DB;

Session::checkLoginUser();

# entity in index
$sql_e = "SELECT value FROM glpi_plugin_dashboard_config WHERE name = 'entity' AND users_id = ".$_SESSION['glpiID']."";
$result_e = $DB->query($sql_e);
$sel_ent = $DB->result($result_e,0,'value');
	

if($sel_ent == '' OR $sel_ent == -1) {
	//$sel_ent = 0;
	$ent_name = __('Tickets Statistics','dashboard');	
}

else {
	$query = "SELECT name FROM glpi_entities WHERE id IN (".$sel_ent.")";
	$result = $DB->query($query);
	$ent_name1 = $DB->result($result,0,'name');
	$ent_name = __('Tickets Statistics','dashboard')." :  ". $ent_name1 ;	
}	

if($sel_ent != '') {			
	$entidade = "AND glpi_tickets.entities_id IN (".$sel_ent.")";
	$entidade_u = "AND glpi_profiles_users.entities_id IN (".$sel_ent.")";	
}

else {	
	$entities = $_SESSION['glpiactiveentities'];	
	$ent = implode(",",$entities);	
	$entidade = "AND glpi_tickets.entities_id IN (".$ent.")";
	$entidade_u = "AND glpi_profiles_users.entities_id IN (".$ent.")";				
}


# years in index
$sql_y = "SELECT value FROM glpi_plugin_dashboard_config WHERE name = 'num_years' AND users_id = ".$_SESSION['glpiID']."";
$result_y = $DB->query($sql_y);
$num_years = $DB->result($result_y,0,'value');

if($num_years == '') {
	$num_years = 0;
}

# color theme
$sql_theme = "SELECT value FROM glpi_plugin_dashboard_config WHERE name = 'theme' AND users_id = ".$_SESSION['glpiID']."";
$result_theme = $DB->query($sql_theme);
$theme = $DB->result($result_theme,0,'value');
$style = $theme;

if($theme == '' || substr($theme,0,5) == 'skin-' ) {
	$theme = 'material.css';
	$style = 'material.css';
}
$_SESSION['theme'] = $theme;
$_SESSION['style'] = $theme;


# background
$sql_back = "SELECT value FROM glpi_plugin_dashboard_config WHERE name = 'back' AND users_id = ".$_SESSION['glpiID']."";
$result_back = $DB->query($sql_back);
$back = $DB->result($result_back,0,'value');

if($back == '') {
	$back = 'bg1.jpg';	
}
$_SESSION['back'] = $back;

     switch (date("m")) {
    case "01": $mes = __('January','dashboard'); break;
    case "02": $mes = __('February','dashboard'); break;
    case "03": $mes = __('March','dashboard'); break;
    case "04": $mes = __('April','dashboard'); break;
    case "05": $mes = __('May','dashboard'); break;
    case "06": $mes = __('June','dashboard'); break;
    case "07": $mes = __('July','dashboard'); break;
    case "08": $mes = __('August','dashboard'); break;
    case "09": $mes = __('September','dashboard'); break;
    case "10": $mes = __('October','dashboard'); break;
    case "11": $mes = __('November','dashboard'); break;
    case "12": $mes = __('December','dashboard'); break;
    }

   switch (date("w")) {
    case "0": $dia = __('Sunday','dashboard'); break;    
    case "1": $dia = __('Monday','dashboard'); break;
    case "2": $dia = __('Tuesday','dashboard'); break;
    case "3": $dia = __('Wednesday','dashboard'); break;
    case "4": $dia = __('Thursday','dashboard'); break;
    case "5": $dia = __('Friday','dashboard'); break;
    case "6": $dia = __('Saturday','dashboard'); break;  
    }

	$sql_photo = "SELECT picture 
					FROM glpi_users
					WHERE id = ".$_SESSION["glpiID"]." ";
	
	$res_photo = $DB->query($sql_photo);
	$pic = $DB->result($res_photo,0,'picture');
	
	$photo_url = User::getURLForPicture($pic);  
?>

<!DOCTYPE html>
<html>
<head>
    <title>GLPI - Dashboard - Home </title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
	 <meta http-equiv="Pragma" content="public">
    
    <?php     		 
    	$redir = '<meta http-equiv="refresh" content= "120"/>'; 
    	echo $redir;
    ?>        
    
    <link rel="icon" href="img/dash.ico" type="image/x-icon" />
	 <link rel="shortcut icon" href="img/dash.ico" type="image/x-icon" />    
    <link href="css/bootstrap.css" rel="stylesheet"> 

    <!-- Styles -->   
    <!-- Color theme -->       		   
    <link rel="stylesheet" type="text/css" href="css/layout.css">
    
     <!-- this page specific styles -->
    <link rel="stylesheet" href="css/compiled/index.css" type="text/css" media="screen" />    

    <!--[if lt IE 9]>
      <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
    <![endif]-->
    <link href="css/styles.css" rel="stylesheet" type="text/css" />
    <link href="css/style-dash.css" rel="stylesheet" type="text/css" />
    <link href="css/dashboard.css" rel="stylesheet" type="text/css" /> 
    
    <!-- odometer -->
	<link href="css/odometer.css" rel="stylesheet">
	<script src="js/odometer.js"></script>	
    
   <!-- <link href="less/style.less" rel="stylesheet"  title="lessCss" id="lessCss"> -->

    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
     <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
     <script src="https://oss.maxcdn.com/libs/respond.js/1.3.0/respond.min.js"></script>
     <![endif]-->         
     <!-- <link href="fonts/fonts.css" rel="stylesheet" type="text/css" /> -->

 	 <script src="js/jquery.js"></script> 
     
  	 <?php 
 	 	echo '<link rel="stylesheet" type="text/css" href="./css/skin-'.$theme.'">'; 
	 	echo '<link rel="stylesheet" type="text/css" href="./css/index-style-'.$style.'">';
 	 ?>  	
 	
 	<!-- gauge -->
	<script src="js/raphael.2.1.0.min.js"></script>
	<script src="js/justgage.1.0.1.min.js"></script>	
</head>

	<?php
	if($theme == 'trans.css') {		
   	echo "<body style=\"background: url('./img/".$back."') no-repeat top center fixed; \">";
   }
   else {
   	echo "<body style='background-color:#E5E5E5;'>";
   }	 
   ?>
                                               
<?php     
$ano = date("Y");
$month = date("Y-m");
$hoje = date("Y-m-d");

//selecionar anos 
if($num_years == 0) {
	
	$query_y = "SELECT DISTINCT DATE_FORMAT( date, '%Y' ) AS year
	FROM glpi_tickets
	WHERE glpi_tickets.is_deleted = '0'
	AND date IS NOT NULL	
	ORDER BY year ASC ";
}

if($num_years == 1) {
	
	$query_y = "SELECT DISTINCT DATE_FORMAT( date, '%Y' ) AS year
	FROM glpi_tickets
	WHERE glpi_tickets.is_deleted = '0'
	AND date IS NOT NULL
	ORDER BY year DESC
	LIMIT ".$num_years."";
}

if($num_years > 1) {
	
	$query_y = "SELECT DISTINCT DATE_FORMAT( date, '%Y' ) AS year
	FROM glpi_tickets
	WHERE glpi_tickets.is_deleted = '0'
	AND date IS NOT NULL
	ORDER BY year DESC
	LIMIT ".$num_years."";
	
}

$result_y = $DB->query($query_y);

//numero de anos para eixos Y
$conta_y = $DB->numrows($result_y);

$arr_years = array();

while ($row_y = $DB->fetch_assoc($result_y))		
	{ 
		$arr_years[] = $row_y['year'];			
	} 


if($num_years > 1) {
	$arr_years = array_reverse($arr_years);
	$years = implode(",", $arr_years);
}
else {
	$years = implode(",", $arr_years);
}


//chamados ano
$sql_ano =	"SELECT COUNT(glpi_tickets.id) as total        
      FROM glpi_tickets
      LEFT JOIN glpi_entities ON glpi_tickets.entities_id = glpi_entities.id
      WHERE glpi_tickets.is_deleted = '0' 
      AND DATE_FORMAT( glpi_tickets.date, '%Y' ) IN (".$years.") 
      ".$entidade." ";

$result_ano = $DB->query($sql_ano);
$total_ano = $DB->fetch_assoc($result_ano);
      
//chamados mes
$sql_mes =	"SELECT COUNT(glpi_tickets.id) as total        
      FROM glpi_tickets
      LEFT JOIN glpi_entities ON glpi_tickets.entities_id = glpi_entities.id
      WHERE glpi_tickets.date LIKE '$month%'      
      AND glpi_tickets.is_deleted = '0' 
      ".$entidade." ";

$result_mes = $DB->query($sql_mes);
$total_mes = $DB->fetch_assoc($result_mes);

//chamados dia
$sql_hoje =	"SELECT COUNT(glpi_tickets.id) as total        
      FROM glpi_tickets
      LEFT JOIN glpi_entities ON glpi_tickets.entities_id = glpi_entities.id
      WHERE glpi_tickets.date like '$hoje%'      
      AND glpi_tickets.is_deleted = '0'
      ".$entidade." ";

$result_hoje = $DB->query($sql_hoje);
$total_hoje = $DB->fetch_assoc($result_hoje);

// total users
$sql_users = " SELECT COUNT(DISTINCT `glpi_users`.id) AS total
               FROM glpi_profiles_users
               LEFT JOIN `glpi_users`
                  ON (`glpi_users`.`id` = `glpi_profiles_users`.`users_id`)
               WHERE `glpi_users`.`is_deleted` = '0'  
               AND is_active = 1 
     				".$entidade_u." ";
				
$result_users = $DB->query($sql_users);
$total_users = $DB->fetch_assoc($result_users);

?>

<div class="site-holder">
<!-- top -->
<!-- .box-holder -->
<!-- .content -->
<div class="content animated fadeInBig corpo col-md-12 col-sm-12 align" style="width: 100%; margin-left:0%;" >
    <!-- main-content 
   <div class="main-content masked-relative masked"> -->
      
						<div id="panels" class="row" style="margin-left: 0%;">
							<!-- COLUMN 1 -->															
								  <div class="col-sm-3 col-md-3 stat">
									 <div class="dashbox shad panel panel-default db-red">
										<div class="panel-body">
										   <div class="panel-left red redbg">
												<i class="fa fa-calendar-o fa-3x"></i>
										   </div>
										   <div class="panel-right right">
										     <div id="odometer1" class="odometer" style="font-size: 25px;">   </div><p></p>
                        				<span class="chamado"><?php echo __('Tickets','dashboard'); ?></span><br>
                        				<span class="date"><b><?php echo __('Today','dashboard'); ?></b></span>												
										   </div>
										</div>
									 </div>
								  </div>
								  
								  <div class="col-sm-3 col-md-3">
									 <div class="dashbox shad panel panel-default db-blue">
										<div class="panel-body">
										   <div class="panel-left blue bluebg">
												<i class="fa fa-calendar fa-3x fa-calendar-index"></i>
										   </div>
										   <div class="panel-right right">										 
											<div id="odometer2" class="odometer" style="font-size: 25px;">   </div><p></p>
                        				<span class="chamado"><?php echo __('Tickets','dashboard'); ?></span><br>
                        				<span class="date"><b><?php echo $mes ?></b></span>
										   </div>
										</div>
									 </div>
								  </div>																		
                     								
								  <div class="col-sm-3 col-md-3">
									 <div class="dashbox shad panel panel-default db-yellow">
										<div class="panel-body">
										   <div class="panel-left yellow yellowbg">
												<i class="fa fa-plus-square fa-3x"></i>
										   </div>
										   <div class="panel-right right">
												<div id="odometer3" class="odometer" style="font-size: 25px;">   </div><p></p>
                        				<span class="chamado"><?php echo __('Tickets','dashboard'); ?></span><br>
                        				<span class="date"><b><?php echo __('Total','dashboard'); ?></b></span>
										   </div>										   
										</div>
									 </div>
								  </div>
								  <div class="col-sm-3 col-md-3">
									 <div class="dashbox shad panel panel-default db-orange">
										<div class="panel-body">
										   <div class="panel-left green orangebg">
												<i class="fa fa-users fa-3x"></i>
										   </div>
								   		<div class="panel-right right">
												<div id="odometer4" class="odometer" style="font-size: 25px;">   </div><p></p>
                        				<span class="chamado"><?php echo __('users','dashboard'); ?></span><br>                        				
										   </div>
										</div>
									 </div>
								  </div>																	                          				                           							
						</div>        
                
<div class="container-fluid">  

<!-- BEGIN Theme Setting -->
<div id="theme-setting" class="show-setting">
    <a href="#">
        <i class="fa fa-cog fa-2x"></i>
    </a>
    <ul style="display: none;"></ul>
</div>


<div id="theme-setting2"  class="hide-setting" >
    <a href="#">
        <i id="close-setting" class="fa fa-times fa-2x" style="margin-right:30px; color:#555; vertical-align:top;"></i>
    </a>
    <ul style="display: inline-block;">
        <li>
            <span id="close-all-widgets" style="cursor:pointer; font-weight:bold;"><?php echo __('Close all Widgets','dashboard');?></span>
            <span></span>
        </li>        
        <li>            
            <span id="open-all-widgets" style="cursor:pointer; font-weight:bold;"><?php echo __('Open all Widgets','dashboard');?></span>
            <span></span><br>
            <span><?php echo __('Closed Widgets','dashboard').":";?><div id="closed-widget-count1"></div> </span>             				
        </li>  
        <ul id="closed-widget-list"></ul>   
           
    </ul>
</div>

<!-- END Theme Setting  -->  
      
<script type="text/javascript" >
window.odometerOptions = {
   format: '( ddd).dd'
};

setTimeout(function(){
    odometer1.innerHTML = <?php echo $total_hoje['total']; ?>;
    odometer2.innerHTML = <?php echo $total_mes['total']; ?>;
    odometer3.innerHTML = <?php echo $total_ano['total']; ?>;
    odometer4.innerHTML = <?php echo $total_users['total']; ?>;
}, 1000);

</script> 

<div id='content-main' class="container-fluid1 align col-md-12 row" style="">  
<!-- <div id="pad-wrapper"> -->
	<?php 
	
		// server info
		$query_info = "SELECT value FROM glpi_plugin_dashboard_config WHERE name = 'info' AND users_id = ".$_SESSION['glpiID']." ";																
		$result_info = $DB->query($query_info);		
		$info = $DB->result($result_info,0,'value');
		
		//server OS
		if($info == 1 || $info == "") {
			if(file_exists('/etc/hosts')) { $width_os = '100%'; } 
			else { $width_os = '100%'; }
		}			
	?>

<div id="tickets_total" class="widget2 widget-table action-table striped" style="margin-top: 10px; ">
   <div class="widget-header2" style="width:100%;">                
   	<h3><i class="fa fa-area-chart" style="margin-left:7px;">&nbsp;&nbsp;&nbsp;</i><?php echo __('Tickets Evolution','dashboard'); ?></h3>      
   </div> 
      <!-- /widget-header -->
	<div id="grfrow" class="row-fluid col-sm-11 col-md-11 card" style="width:100%;">	
      <h4> <?php //echo __('Tickets Evolution','dashboard'); ?> </h4>
      <p id="choices" style=" margin-right: 20px; margin-top: 5px; text-align:right; width:<?php echo $width_os; ?>;"></p>	  	
		<div class="demo-container" style="margin-bottom:10px;">						
			<div id="graflinhas1" class="demo-placeholder" style="float:left; width: <?php echo $width_os; ?> ;"></div>
				
					
		</div>
	</div>
	   <?php 
			include ("graphs/inc/index/graflinhas_index_sel.inc.php");
		?>						

<div id="widgets" class="row" style="margin-top: 0px;">	
	
	<div class="col-sm-6 col-md-6 align2" style="margin-leftx:-15px;"> 	 				              
   <div id="tickets_status" class="widget widget-table action-table striped card1" >
      <div class="widget-header wred">                 
      	<h3><i class="fa fa-pie-chart" style="margin-left:7px;">&nbsp;&nbsp;&nbsp;</i><?php echo __('Opened Tickets by Status','dashboard'); ?></h3>
      	 <span  class="fa fa-times hide-widget"></span>               
      </div> 
      <!-- /widget-header -->      
      <div id="pie1">	 			
				<?php
					include ("graphs/inc/index/grafpie_index.inc.php");
				?> 	 						            
		</div> 
	</div>
</div>

	<div class="col-sm-6 col-md-6 align2" style="margin-rightx: -24px;"> 	 				              
   <div id="last_week" class="widget widget-table action-table striped card1" >
      <div class="widget-header wred">                
      	<h3><i class="fa fa-bar-chart-o" style="margin-left:7px;">&nbsp;&nbsp;&nbsp;</i><?php echo __('Tickets')." - ". __('Last 7 days','dashboard') ; ?></h3>
      	 <span  class="fa fa-times hide-widget"></span>             
      </div> 
      <!-- /widget-header -->      
			<div id="graf7"> 
				<?php
					include ("graphs/inc/index/grafcol_setedias.inc.php");
				?> 	 				              
			</div> 
  		</div>      
  </div>   
  	
<div class="col-sm-6 col-md-6" > 	 				              
   <div id="tickets_age" class="widget widget-table action-table striped card1" >
      <div class="widget-header wpurple">                
      	<h3><i class="fa fa-pie-chart" style="margin-left:7px;">&nbsp;&nbsp;&nbsp;</i><?php echo __('Ticket Solving Period','dashboard'); ?></h3>
      	 <span  class="fa fa-times hide-widget"></span>             
      </div> 
      <!-- /widget-header -->
			<div id="graf9"> 			
				<?php
					include ("graphs/inc/index/grafbar_age.inc.php");
				?> 	 						            
			</div> 
	</div>
</div>		


<div class="col-sm-6 col-md-6" > 	 				              
   <div id="tickets_time" class="widget widget-table action-table striped card1" >
      <div class="widget-header wpurple">                
      	<h3><i class="fa fa-bar-chart-o" style="margin-left:7px;">&nbsp;&nbsp;&nbsp;</i><?php echo __('Open Tickets Age','dashboard'); ?></h3>
      	 <span  class="fa fa-times hide-widget"></span>             
      </div> 
      <!-- /widget-header -->
		<div id="graf8"> 
			<?php
				include ("graphs/inc/index/grafpie_time.inc.php");
			?> 	 				              
		</div> 
  	</div>      
</div>

<div class="col-sm-6 col-md-6"> 	 				              
	<div id="tickets_time" class="widget widget-table action-table striped card1" >
   <div class="widget-header wpurple">                
   	<h3><i class="fa fa-bar-chart-o" style="margin-left:7px;">&nbsp;&nbsp;&nbsp;</i><?php echo __('Open Tickets Age','dashboard'); ?></h3>
   	 <span  class="fa fa-times hide-widget"></span>             
   </div> 
   <!-- /widget-header -->
		<div id="graf8"> 
			<?php
				include ("graphs/inc/index/grafpie_time.inc.php");
			?> 	 				              
		</div> 
  	</div>      
</div>

<div class="col-sm-12 col-md-12 align2" style="display:none;"> 	 				              
	<div id="tickets_status" class="widget widget-table action-table striped card1" >
	   <div class="widget-header wred">                 
	   	<h3><i class="fa fa-bar-chart-o" style="margin-left:7px;">&nbsp;&nbsp;&nbsp;</i><?php echo __('Tickets by Category','dashboard'); ?></h3>
	   	 <span  class="fa fa-times hide-widget"></span>               
	   </div> 
	   <!-- /widget-header -->      
	   <div id="grafcat">	 			
				<?php
					//include("graphs/inc/index/grafbar_cat_mes_index.inc.php");
				?> 	 						            
		</div> 
	</div>
</div>
  
	
<div class="col-sm-6 col-md-6" > 	 				              
      <div id="last_tickets" class="widget widget-table action-table striped card1">
      <div class="widget-header wyellow">                
      	<h3><i class="fa fa-list-alt" style="margin-left:7px;">&nbsp;&nbsp;&nbsp;</i><a href="../../../front/ticket.php" target="_blank" style="color: #525252;"><?php echo __('Last Tickets','dashboard'); ?></a></h3>
      	 <span  class="fa fa-times hide-widget"></span>             
      </div> 
      <!-- /widget-header -->
      <div class="widget-content" style="height:322px;">
      <?php
      
			// last tickets
			$status = "('5','6')";	         
	                  
	      $query_wid = "
	      SELECT glpi_tickets.id AS id, glpi_tickets.name AS name
			FROM glpi_tickets
			WHERE glpi_tickets.is_deleted = 0
			AND glpi_tickets.status NOT IN $status
			".$entidade."
			ORDER BY id DESC
			LIMIT 10 ";
	      
	      $result_wid = $DB->query($query_wid);			            	      
	      ?>    
	        <table id="last_tickets" class="table table-hover table-bordered table-condensed" >
		        <th style="text-align: center;"><?php echo __('Tickets','dashboard'); ?></th><th style="text-align: center;" ><?php echo __('Title','dashboard'); ?></th>	        
					<?php
						while($row = $DB->fetch_assoc($result_wid)) 
						{					
							echo "<tr><td style='text-align: center;'><a href=../../../front/ticket.form.php?id=".$row['id']." target=_blank style='color: #526273;'>".$row['id']."</a>
							</td><td>". substr($row['name'],0,60)."</td></tr>";											
						}				
					?>                                       
	        </table>        
      </div>
         <!-- /widget-content --> 
       </div>
	</div> 

<!--  open tickets by tech-->
	<div class="col-sm-6 col-md-6" > 	
		<div id="open_tickets" class="widget widget-table action-table striped card1">
            <div class="widget-header wyellow">
           		<h3><i class="fa fa-list-alt" style="margin-left:7px;">&nbsp;&nbsp;&nbsp;</i><a href="../../../front/ticket.php" target="_blank" style="color: #525252;"><?php echo __('Open Tickets','dashboard'). " " .__('by Technician','dashboard') ?></a></h3>
           		 <span  class="fa fa-times hide-widget"></span>           
            </div>
            <!-- /widget-header -->
            
            <div class="widget-content" style="height:322px;">
	            <?php
	                                
	            $query_tec = "
	            SELECT DISTINCT glpi_users.id AS id, glpi_users.`firstname` AS name, glpi_users.`realname` AS sname, count(glpi_tickets_users.tickets_id) AS tick
					FROM `glpi_users` , glpi_tickets_users, glpi_tickets
					WHERE glpi_tickets_users.users_id = glpi_users.id
					AND glpi_tickets_users.type = 2
					AND glpi_tickets.is_deleted = 0
					AND glpi_tickets.id = glpi_tickets_users.tickets_id
					AND glpi_tickets.status NOT IN ".$status."
					".$entidade."
					GROUP BY `glpi_users`.`firstname` ASC
					ORDER BY tick DESC
					LIMIT 10 ";
	            
	            $result_tec = $DB->query($query_tec);			                        
	            ?>    
	           <table id="open_tickets" class="table table-hover table-bordered table-condensed" >
		           <th style="text-align: center;"><?php echo __('Technician','dashboard'); ?></th><th style="text-align: center;">
		          	<?php echo __('Open Tickets','dashboard'); ?>
		           </th>
		              
						<?php
							while($row = $DB->fetch_assoc($result_tec)) 
							{					
								echo "<tr><td><a href=./reports/rel_tecnico.php?con=1&tec=".$row['id']."&stat=open target=_blank style='color: #526273;'>
								".$row['name']." ".$row['sname']."</a></td><td style='text-align: center;' >".$row['tick']."</td></tr>";											
							}				
						?>                                       
	            </table>              
            </div>
            <!-- /widget-content --> 
          </div>
       </div>

<div class="col-sm-6 col-md-6" >  	 				              
		 <div id="events" class="widget widget-table action-table striped card1">
            <div class="widget-header wblue">
              <h3><i class="fa fa-list-alt" style="margin-left:7px;">&nbsp;&nbsp;&nbsp;</i><a href="../../../front/event.php" target="_blank" style="color: #525252;"><?php echo __('Last Events','dashboard'); ?></a></h3>
               <span  class="fa fa-times hide-widget"></span>
            </div>
            <!-- /widget-header -->
            <div class="widget-content">   
					<?php				
					$query_evt = "
					SELECT *
					FROM `glpi_events`
					ORDER BY `glpi_events`.id DESC
					LIMIT 10 ";   
						
					$result_evt = $DB->query($query_evt);
					$number = $DB->numrows($result_evt);
					
					function tipo($type) {
					
					    switch ($type) {
					    case "system": $type 	  = __('System'); break;
					    case "ticket": $type 	  = __('Ticket'); break;
					    case "devices": $type 	  = _sn('Component', 'Components', 2); break;
					    case "planning": $type 	  = __('Planning'); break;
					    case "reservation": $type = _sn('Reservation', 'Reservations', 2); break;
					    case "dropdown": $type 	  = _sn('Dropdown', 'Dropdowns', 2); break;
					    case "rules": $type 	  = _sn('Rule', 'Rules', 2); break;
					   };
						return $type;
						}
					
					
					function servico($service) {
					
					    switch ($service) {
					    case "inventory": $service 	  = __('Assets'); break;
					    case "tracking": $service 	  = __('Ticket'); break;
					    case "maintain": $service 	  = __('Assistance'); break;
					    case "planning": $service  	  = __('Planning'); break;
					    case "tools": $service 	  	  = __('Tools'); break;
					    case "financial": $service 	  = __('Management'); break;
					    case "login": $service 	         = __('Connection'); break;
					    case "setup": $service 	  	  = __('Setup'); break;
					    case "security": $service 	  = __('Security'); break;
					    case "reservation": $service     = _sn('Reservation', 'Reservations', 2); break;
					    case "cron": $service 	  	  = _sn('Automatic action', 'Automatic actions', 2); break;
					    case "document": $service 	  = _sn('Document', 'Documents', 2); break;
					    case "notification": $service    = _sn('Notification', 'Notifications', 2); break;
					    case "plugin": $service 	  = __('Plugin'); break;
					   }
					
						return $service;
						}
					    ?>    
		          <table id="lastevents" class="table table-hover table-bordered table-condensed" >
		            <th style="text-align: center;"><?php echo __('Type'); ?></th>
						<th style="text-align: center;"><?php echo __('Date'); ?></th>
						<!-- <th style="text-align: center;"><?php echo __('Service'); ?></th>  -->
						<th style="text-align: center;"><?php echo __('Message'); ?></th>                 
						<?php
						
							 switch ($_SESSION['glpidate_format']) {
						    case "0": $dataf = 'Y-m-d'; break;
						    case "1": $dataf = 'd-m-Y'; break;
						    case "2": $dataf = 'm-d-Y'; break;    
						    } 								
						
					   $i = 0;	
					   while ($i < $number) {
					   
						  $type     = $DB->result($result_evt, $i, "type");
	       			  $date     = date_create($DB->result($result_evt, $i, "date"));
				        // $service  = $DB->result($result_evt, $i, "service");         							        
				        $message  = $DB->result($result_evt, $i, "message");
						
						echo "<tr><td style='text-align: left;'>". tipo($type) ."</td>
								<td style='text-align: left;'>" . date_format($date, $dataf.' H:i:s') . "</td>					
								<td style='text-align: left;'>". substr($message,0,50) ."</td></tr>
						";
						++$i;													
						}												
						?>                                       
              		</table>  
              
            </div>
            <!-- /widget-content --> 
       </div>
	</div>

	<div class="col-sm-6 col-md-6" >  	 				              
		 <div id="logged_users" class="widget widget-table action-table">
            <div class="widget-header wblue">
				<?php
				//logged users				
				//$path = "../../../files/_sessions/";
				$path = GLPI_SESSION_DIR . '/' ;
				$diretorio = opendir($path);        
				
				$arr_arq = array();
				$arquivos = array();    
				       
				while($arquivo = readdir($diretorio)){   
				      
				     $arr_arq[] = $path.$arquivo;           
				 }				 
								
				foreach ($arr_arq as $listar) {
				// retira "./" e "../" para que retorne apenas pastas e arquivos
								  
				   if ( is_file($listar) && $listar != '.' && $listar != '..'){ 
							$arquivos[]=$listar;
				   }
				}
				
				$conta = count($arquivos);
				
				if($conta > 0) {
				
				for($i=0; $i < $conta; $i++) {
				
					$file = $arquivos[$i];
					
					$string = file_get_contents( $file ); 
					//poderia ser um string ao invés de file_get_contents().
					
					$list = preg_match( '/glpiID\|s:[0-9]:"(.+)/', $string, $matches );
					
					$arr = isset($matches[0]) ? $matches[0] : '';
					
					$posicao = strpos($arr, 'glpiID|s:');
					
					$string2 = substr($arr, $posicao, 25);
					
					$string3 = explode("\"", $string2);
					
					$arr_ids[] = isset($string3[1]) ? $string3[1] : '';
					
					}
				}
				
				$ids = array_values($arr_ids);
				$ids2 = implode("','",$ids);
				
				$query_name = 
				"SELECT firstname AS name, realname AS sname, id AS uid, name AS glpiname, picture 
				FROM glpi_users				
				WHERE id IN ('".$ids2."')
				ORDER BY name"; 
				
				$result_name = $DB->query($query_name); 
				$num_users = $DB->numrows($result_name);          
				            
				?>    
           <h3><i class="fa fa-group" style="margin-left:7px;">&nbsp;&nbsp;&nbsp;</i><?php echo __('Logged Users','dashboard')."  :  " .$num_users; ?></h3>
			   <span  class="fa fa-times hide-widget"></span>

            </div>
            <!-- /widget-header -->
            
				<?php
	          if($num_users <= 10) {
	          	echo '<div class="widget-content striped" style="min-height:318px;">'; }
	          else {
	          	echo '<div class="widget-content striped" style="min-height:318px;">'; }
	          	//echo '   <div class="widget-content striped ">'; }	          	
				?>        
              <table id="logged_users" class="table table-hover table-bordered table-condensed" >                         
				<?php
								
				while($row_name = $DB->fetch_assoc($result_name)) 
	  			   {
						echo "<tr>
									<td style='text-align: left;'><img src=". User::getURLForPicture($row_name['picture']) ." alt='user' width='30px' height='35px' />&nbsp; &nbsp;<a href=../../../front/user.form.php?id=".$row_name['uid']." target=_blank style='color: #526273;'>
										".$row_name['name']." ".$row_name['sname']." (".$row_name['uid'].")</a>	
									</td>									
								</tr>";												
					}	

				?>                                       
              </table>              
            </div>
            <!-- /widget-content --> 
          </div>
</div> <!-- end widgets -->                   		
          <!-- content row 2 --> 
	<!-- </div>                     
   </div>   totals   --> 
</div> 
 
<script>
	function scrollWin()
	{
		$('html, body').animate({ scrollTop: 0 }, 'slow');
	}
</script> 

	<div id="go-top" class="go-top" onclick="scrollWin()">
	   <i class="fa fa-chevron-up"></i>&nbsp; Top     							    
	</div> 
	 	
</div> <!-- end content -->   
 <!--</div>-->		
	<!-- end main-content 	
	</div>-->

<!-- </div>
 /.box-holder -->
	<!-- transparent them footer -->
	<style type="text/css">
		@media screen and (min-width: 1201px) and (max-width: 2200px) {
	  	#footer-bar {
	    margin-top: 5px;
	    height: 20px;
	  	 }
		}
	</style>
	<?php
	if($theme == 'trans.css') {		 
		echo '<div id="footer-bar" class="footer-bar row-fluid" style="overflow: hidden; height:70px; width:100%; background-color: #000; opacity:0.7; float:left; bottom:0px; margin-top: -70px; position:relative; clear: both; margin-left: 220px; " ></div>';
	}  
	?>
	
	
</div>
<!-- /.site-holder -->
 <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
 <!-- Include all compiled plugins (below), or include individual files as needed -->
<!-- <script src="js/jquery-ui-1.10.2.custom.min.js"></script> -->

<script src="js/jquery-ui.min.js" type="text/javascript"></script> 
<script src="js/jquery.accordion.js"></script>            
<script src="js/bootstrap-dropdown.js"></script>
<script src="js/jquery.easy-pie-chart.js"></script> 
<script src="js/jquery.address-1.6.min.js"></script>

<script src="js/bootstrap-switch.js"></script> 
<script src="js/highcharts.js" type="text/javascript" ></script>
<script src="js/highcharts-3d.js" type="text/javascript" ></script>
<script src="js/modules/exporting.js" type="text/javascript" ></script>
<script src="js/modules/no-data-to-display.js" type="text/javascript" ></script>
<script src="js/themes/<?php echo $_SESSION['charts_colors']; ?>"></script>

<!-- knob -->
<script src="js/jquery.knob.js"></script>

<!-- flot charts -->    
<script src="js/jquery.flot.js"></script>
<script src="js/jquery.flot.stack.js"></script>
<script src="js/jquery.flot.resize.js"></script>
<script src="js/jquery.flot.pie.min.js"></script>
<script src="js/jquery.flot.valuelabels.js"></script>
<script src="js/theme.js"></script>         
<script src="js/jquery.jclock.js"></script>

<script src="js/widgets.js"></script>

<!-- Highcharts export xls, csv -->
<script src="js/export-csv.js"></script>

<!-- Remove below two lines in production -->  
<script src="js/theme-options.js"></script>       
<script src="js/core.js"></script>
</body>
</html>
