PHP num_extras Examples

Example #1

File: extra_grafica_cantidad.php Project: santii810/ExtraWeb

<?php

require './vista/menu.php';
$conexion = abrir_conexion();
session_start();
$usuID = usuario_a_usuID($_SESSION["user"]);
echo "<br>";
for ($ano = 2014; $ano > 2000; $ano--) {
    if (num_extras($ano, $usuID, $conexion) > 0) {
        $num_extras = numero_extras_local($ano, $usuID, $conexion);
        $total = num_extras($ano, $usuID, $conexion);
        echo "<br>";
        ?>
<table border="0" id="grafica1">
    <tr><th id="tabla_historico_ano"><?php 
        echo "{$ano}";
        ?>
</th>
        <td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
        <td>Extras realizadas</td>
    </tr>
<?php 
        foreach ($num_extras as $value) {
            $porcentaje = 100 * $value["numero"] / $total;
            ?>
  <tr>
	<td><b><?php 
            echo $value["local"];
            ?>
</b></td>
	<td width="10" <?php 

Example #2

File: extra_grafica_ingresos.php Project: santii810/ExtraWeb

<?php

require './vista/menu.php';
$conexion = abrir_conexion();
session_start();
$usuID = usuario_a_usuID($_SESSION["user"]);
echo "<br>";
for ($ano = 2014; $ano > 2000; $ano--) {
    if (num_extras($ano, $usuID, $conexion) > 0) {
        $ingresos_local = ingresos_local($ano, $usuID, $conexion);
        $total = devolver_consulta($ano, $usuID, $conexion, "SELECT SUM(precio) as dato FROM extras WHERE usuario = '{$usuID}' and YEAR(fecha)='{$ano}'");
        echo "<br>";
        ?>
<table border="0" id="grafica1">
    <tr><th id="tabla_historico_ano"><?php 
        echo "{$ano}";
        ?>
</th>
        <td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
        <td>Ingresos</td>
    </tr>
<?php 
        foreach ($ingresos_local as $value) {
            $porcentaje = 100 * $value["ingresos"] / $total;
            ?>
  <tr>
	<td><b><?php 
            echo $value["local"];
            ?>
</b></td>
	<td width="10" <?php 

Example #3

File: extra_historial.php Project: santii810/ExtraWeb

for ($ano = 2014; $ano > 2000; $ano--) {
    ?>
    <?php 
    if (num_extras($ano, $usuID, $conexion) > 0) {
        ?>
        <table border="1" id="tabla_historico">
            <tr>
                <th id="tabla_historico_ano"><?php 
        echo $ano;
        ?>
</th>
            </tr>
            <tr>
                <td>Numero de Extras:</td>
                <td><?php 
        echo num_extras($ano, $usuID, $conexion);
        ?>
</td>
            </tr>
            <tr>
                <td>Cobro total:</td>
                <td><?php 
        $sql = "SELECT SUM(precio) as dato FROM extras WHERE usuario = '{$usuID}' and YEAR(fecha)='{$ano}'";
        echo devolver_consulta($ano, $usuID, $conexion, $sql) . ' €';
        ?>
</td>
            </tr>
            <tr>
                <td>Propinas ganadas</td>
                <td><?php 
        $sql = "SELECT SUM(propina) as dato FROM extras WHERE usuario = '{$usuID}' and YEAR(fecha)='{$ano}'";