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: [