/*
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
*/
?>
Galopin v1.0
include ("conectar.php");
if ($ini=="")
{
$consulta2="select max(articulo) from tempartpro";
$query2=mysql_query($consulta2);
$fila=mysql_fetch_row($query2);
$maximo=$fila[0];
if ($maximo=="")
{
$maximo=1;
}
else
{
$maximo=$maximo+1;
};
$articulo=$maximo;
$insercion="insert into tempartpro(articulo,proveedor,precio) values ($maximo,0,0);";
$query=mysql_query($insercion);
};
if (($proveedor<>"") and ($accion=="anadir"))
{
$precio = str_replace(",",".",$precio);
//
//controlar no letras
//ahora mismo si no es correcto no se inserta en la temporal ni en la base de datos
//
//comprobamos si existe ya ese proveedor con ese articulo y un precio
$consultaexiste="select * from tempartpro where proveedor=$proveedor and articulo=$articulo";
$queryexiste=mysql_query($consultaexiste);
$existe=mysql_num_rows($queryexiste);
if ($existe==0)
{
$consulta="insert into tempartpro(articulo,proveedor,precio) values($articulo,$proveedor,$precio)";
$query = mysql_query($consulta);
}
else
{
$errorexiste="Ya tiene insertado el proveedor. Borreló antes si quiere modificar algun dato.";
};
};
if ($accion=="eliminar")
{
$consulta2="delete from tempartpro where id=$id";
$query = mysql_query($consulta2);
};
?>
=$errorexiste?>
Listado Temporal de Proveedores:
$consulta="Select * from tempartpro where proveedor<>0 and articulo=$articulo";
$query = mysql_query($consulta);
while ($row=mysql_fetch_row($query))
{
$consulta2 = "select * from proveedores where codproveedor=$row[2]";
$query2 = mysql_query($consulta2);
$fila=mysql_fetch_row($query2);
print("