<?php

include ("../../../../inc/includes.php");
global $DB, $CFG_GLPI;

Session::checkLoginUser();
Session::checkRight("profile", READ);
?>

<html> 
<head>
<title> GLPI - <?php echo __('Metrics','dashboard'); ?> </title>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
  <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
  <meta http-equiv="content-language" content="en-us" />
  <link href="../css/styles.css" rel="stylesheet" type="text/css" />
  <link href="../css/bootstrap.css" rel="stylesheet" type="text/css" />
  <link href="../css/bootstrap-responsive.css" rel="stylesheet" type="text/css" />
  <link href="../css/font-awesome.css" type="text/css" rel="stylesheet" />
  
  <script src="../js/jquery.min.js" type="text/javascript" ></script>
  <script src="../js/jquery.jclock.js"></script>
  
	<link href="../inc/select2/select2.css" rel="stylesheet" type="text/css">
	<script src="../inc/select2/select2.js" type="text/javascript" language="javascript"></script>
	
	<?php echo '<link rel="stylesheet" type="text/css" href="../css/style-'.$_SESSION['style'].'">';  ?> 

</head>
<body style="background-color: #e5e5e5; margin-left:0%;">

<?php

$status = "('5','6')"	;

$sql = "SELECT COUNT( * ) AS total
FROM glpi_tickets
WHERE glpi_tickets.status NOT IN ".$status."
AND glpi_tickets.is_deleted = 0" ;

$result = $DB->query($sql);
$data = $DB->fetchAssoc($result);

$abertos = $data['total']; 

function dropdown( $name, array $options, $selected=null )
{
    /*** begin the select ***/
    $dropdown = '<select style="width: 300px; height: 27px;" autofocus onChange="javascript: document.form1.submit.focus()" name="'.$name.'" id="'.$name.'">'."\n";

    $selected = $selected;
    /*** loop over the options ***/
    foreach( $options as $key=>$option )
    {
        /*** assign a selected value ***/
        $select = $selected==$key ? ' selected' : null;

        /*** add each option to the dropdown ***/
        $dropdown .= '<option value="'.$key.'"'.$select.'>'.$option.'</option>'."\n";
    }

    /*** close the select ***/
    $dropdown .= '</select>'."\n";

    /*** and return the completed dropdown ***/
    return $dropdown;
}

//select user entities
										
$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 == '' || $sel_ent == -1) {
	
	$entities = $_SESSION['glpiactiveentities'];
	//$entities = Profile_User::getUserEntitiesForRight($_SESSION['glpiID'],Ticket::$rightname,Ticket::READALL);
	$ents = implode(",",$entities);

}
else {
	$ents = $sel_ent;
}

$sql_ent = "
SELECT id, name, completename AS cname
FROM `glpi_entities`
WHERE id IN (".$ents.")
ORDER BY `cname` ASC ";

$result_ent = $DB->query($sql_ent);
$ent = $DB->fetchAssoc($result_ent);

$res_ent = $DB->query($sql_ent);
$arr_ent = array();
$arr_ent[0] = "-- ". __('Select a entity', 'dashboard') . " --" ;

$DB->dataSeek($result_ent, 0) ;

while ($row_result = $DB->fetchAssoc($result_ent))		
	{ 
		$v_row_result = $row_result['id'];
		$arr_ent[$v_row_result] = $row_result['cname'] ;			
	} 
	
$name = 'sel_ent';
$options = $arr_ent;
$selected = "0";

?>

<div id='content' >
<div id='container-fluid' style="margin: 0px 5% 0px 5%;"> 
	<div id="charts" class="fluid chart"> 
		<div id="head" class="fluid">
		<a href="../index.php"><i class="fa fa-home" style="font-size:14pt; margin-left:25px;"></i><span></span></a>
			<div id="titulo_graf"> <?php echo __('Metrics', 'dashboard') .'  '. __('by Entity', 'dashboard') ?> </div>	
				<div id="datas-cham" class="col-md-12 fluid" >	
				<form id="form1" name="form1" class="form_rel" method="post" action="select_ent.php?sel=1">
					<table border="0" cellspacing="0" cellpadding="1" bgcolor="#efefef" width="300px">
						<tr>
							<td>
								<?php echo dropdown( $name, $options, $selected ); ?>
							</td>
						</tr>
						<tr style="height:12px;"><td>&nbsp;</td></tr>
						<tr>
							<td align="center" >
								<button class="btn btn-primary btn-sm" type="submit" name="submit" value="Atualizar" ><i class="fa fa-search"></i>&nbsp; <?php echo __('Consult', 'dashboard'); ?></button>
								<button class="btn btn-primary btn-sm" type="button" name="Limpar" value="Limpar" onclick="location.href='select_ent.php'" > <i class="fa fa-trash-o"></i>&nbsp; <?php echo __('Clean', 'dashboard'); ?> </button></td>
							</td>
						</tr>
					</table>
					<?php Html::closeForm(); ?>
					<!-- </form> -->
				</div>	
		</div>
	
	<script type="text/javascript" >
		$(document).ready(function() { $("#sel_ent").select2(); });
	</script>
	
	<?php
	if(isset($_REQUEST['sel'])){
		$sel = $_REQUEST['sel'];
	}
	else {$sel = '';}
	
	if($sel == "1") {
	 
	if(!isset($_POST["sel_ent"])) {
		$id_ent = $_REQUEST["ent"];	
	}
	
	else {
		$id_ent = $_POST["sel_ent"];
	}
	
	if($id_ent == " ") {
		echo '<script language="javascript"> alert(" ' . __('Select a entity', 'dashboard') . ' "); </script>';
		echo '<script language="javascript"> location.href="select_ent.php"; </script>';
	}	
	?>
	
	<script type="text/javascript" >
		location.href="index.php?ent=<?php echo $id_ent; ?>";
	</script>		
	
	</div>
</div>
</div>
</body>
</html>

<?php } ?>

