1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
<?
/*
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
Autores: Pedro Obregón Mejías
Rubén D. Mancera Morán
Versión: 1.0
Fecha Liberación del código: 13/07/2004
Galopín para gnuLinEx 2004 -- Extremadura
*/
?>
<html>
<head>
<title>Galopin v1.0</title>
<link href="estilo.css" rel="stylesheet" type="text/css">
</head>
<body>
<?
include ("conectar.php");
?>
<img src="images/nuevas/administraciontotalanual.jpg" alt="Administración Total Anual"><br>
<br>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#0066FF">
<tr>
<td class="primeralinea">
<br><br>
<?
$error="";
//comprobamos que no hay caracteres
if (!ereg("^[0-9]+[0-9]*$",$ejercicio)) $error = $error . "<center><font color=ffffff>El ejercicio contiene caracteres. Introdúzcalo correctamente.</center></font><br>";
if ($error=="")
{
//borro las líneas de las facturas del anyo seleccionado
$consulta = "select * from facturas where anyo=$ejercicio";
$query = mysql_query($consulta);
$importefacturas = 0;
$importearticulos=0;
while ($row=mysql_fetch_array($query))
{
$codigofactura=$row["codfactura"];
$consulta2 = "Select * from factulinea where codfactura=$codigofactura order by numlinea";
$query2 = mysql_query($consulta2);
while ($row2=mysql_fetch_array($query2))
{
$importelinea=$row2["importe"];
$importefacturas = $importefacturas + $importelinea;
}
}
$importefacturas=sprintf("%01.2f", $importefacturas);
$importefacturas2= number_format($importefacturas,2,",",".");
print("<center><font color=ffffff><b>Total de Facturación del año " . $ejercicio . " = " . $importefacturas2 . " Euros</b></font></center>");
}
else
{
print($error);
}
?>
<br><br>
</td>
</tr>
</table>
<center>
<br><br>
</body>
</html>
|
