credits: {
enabled: false
},
series: [{
type: 'pie',
name: 'Porcentaje de Actas',
data: [
<?php
$obj->conectar();
$sql = "SELECT DISTINCT sector_act FROM acta ORDER BY sector_act DESC";
$datos = $obj->consulta_query($sql);
while ($fila = mysqli_fetch_array($datos)) {
$sector = $fila['sector_act'];
$sql2 = "SELECT * FROM acta where sector_act='{$sector}'";
$total = $obj->cantidad($sql2);
?>
['<?php
echo $sector;
?>
',<?php
echo $total;
?>
],
<?php
}
?>
<script src="../Highcharts-4.1.5/js/highcharts.js"></script>
<br>
<div class="unico3 col-lg-12 col-md-12" id="unico3">
</div>
</div>
</div>
<?php
$obj->conectar();
$anio = $_POST['anio'];
$sql = "SELECT DISTINCT sector_act FROM acta WHERE EXTRACT(YEAR FROM fecha_act)='{$anio}' ORDER BY sector_act DESC";
$datos2 = $obj->cantidad($sql);
if ($datos2 < 1) {
echo "<script language='javascript'> alert('No hay Registro de Sectores en este Año!'); window.location.href='GraficasActasSector.php';</script>";
} else {
?>
<div class="row">
<div class="col-lg-12 col-md-12">
<form action="GraficasActasSegunSector2.php" method="POST">
<div class="login-wrap">
<table align="center">
<tr>
<td colspan="3">
<!-- Today status end -->
<!-- statics end -->
<br>
<?php
$obj->conectar();
$sector = $_POST['sector'];
$sql = "SELECT procedimiento.nombre_pro FROM procedimiento INNER JOIN acta ON acta.cod_pro=procedimiento.codigo_pro WHERE acta.sector_act='{$sector}'";
$datos = $obj->cantidad($sql);
if ($datos < 1) {
echo "<script language='javascript'> alert('No hay Procedimientos en este Sector!'); window.location.href='GraficasActasSector.php';</script>";
} else {
?>
<script type="text/javascript">
$(function () {
$('#unico3').highcharts({
chart: {
type: 'bar'
},
xAxis: {
categories: [
