Fashion-Store.pdf

Embed Size (px)

Citation preview

  • 1
  • 2mysql_query( "ROLLBACK", $cn );$msg = "El articulo $row[2] no tiene stock suficiente.";fnShowMsg( "ERROR", $msg );return;

    }$subtotal = $row[0] * $cant;$total += $subtotal;// Grabar detalle$sql = "insert into detalle( idpedido, idarticulo, cantidad, ";$sql .= "precio, subtotal ) values( $idped, '$item', $cant, ";$sql .= "$row[0], $subtotal ) ";mysql_query( $sql, $cn );// Actualizar stock$sql = "update articulo set stock = stock - $cant ";$sql .= "where idarticulo = '$item' ";mysql_query( $sql, $cn );

    }// Actualizar pedido$subtotal = $total / ( 1 + $igv );$impuesto = $total - $subtotal;$sql = "update pedido set subtotal = $subtotal, ";$sql .= "igv = $impuesto, total = $total, ";$sql .= "estado = 'P' where idpedido = $idped ";mysql_query( $sql, $cn );mysql_query( "COMMIT", $cn );$_SESSION["canasta"] = null;say( "Pedido Nro. $idped" );$msg = "Seor: " . $_SESSION["nombre"] . "";$msg .= "Su transaccin se proces con exito.";$msg .= "En 48 horas llegara su pedido.";$msg .= "Gracias por su confianza en nosotros.";fnShowMsg( "MENSAJE", $msg );?>

  • 3

  • 4
  • 5
  • 6}say("");say("Total");say("$total");say(" ");say("");say("");?>

  • 7

  • 8
  • 9?>

    FashionStore

  • 10

    break;}?>

    /* cerrar.php

  • 11

  • 12

    function fnSessionEnd(){session_unset();session_destroy();

    }

    /* * Funcin que muestra un mensaje.*/function fnShowMsg($title,$msg){ say(""); say(""); say("$title"); say(""); say("");

    say("$msg"); say(""); say("");}

    /* * Funcin que muestra una lnea de cabecera.*/function fnHeader(){

    $usuario = $_SESSION["nombre"];say("");

    say(""); say("Cliente: $usuario"); say("Fecha: ".fnNow().""); say(""); say("");}

    /* * Funcin que muestra un botn para regresar a la pgina anterior.*/function fnBack(){ return "";}

    function fnRedirect($pagina){ $cad = "Location: http://" . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']) . "/$pagina"; header( $cad, True );}

    /* * Funcin que retorna un link.*/function fnLink($link,$target,$mouseover,$msg){

    $cad = "";$cad .= "$msg";return $cad;

    }

  • 13

    /* * Funcin que retorna el men de la aplicacin.*/function fnMenu(){

    $cad = "";$cad .= "" ;if( $_SESSION["codigo"] ) {

    $cad .= fnLink("cerrar.php","","Terminar de Sesin","Terminar");} else {

    $cad .= fnLink("default.php?op=1","","Inicio de Sesin","Inicio");}$cad .= "";

    $cad .= "" ;$cad .= fnLink("default.php?op=2","","Mostrar Catalogo","Catalogo");$cad .= "";

    if( $_SESSION["codigo"] ) {$cad .= "" ;$cad .= fnLink("default.php?op=3","","Mostrar Canasta","Canasta");$cad .= "";

    $cad .= "" ;$cad .= fnLink("default.php?op=4","","Pagar","Pagar");$cad .= "";

    }

    $cad .= "" ;

    return $cad;}

    /* * Retorna un numero aleatorio entre $minimo y $maximo.*/function fnRnd($minimo, $maximo){ srand((double)microtime()*1000000); $randval = rand($minimo, $maximo); return $randval;}

    /* * Funcin que imprime las etiquetas de fin de pagina. * */function fnPageEnd(){ say(""); say("");}?>

  • 14

  • 15

    Cdigo Cliente

    Contrasea

  • 16

    require_once( "egcc.php" );fnSessionStart();if( !$_SESSION["codigo"] ) {

    fnRedirect( "default.php" );return;

    }$canasta = $_SESSION["canasta"];if( is_null( $canasta ) ) {

    fnShowMsg( "Mensaje", "Su canasta esta vaca." );return;

    }ksort( $canasta );$cn = fnConnect( $msg );if(!$cn){

    fnShowMsg( "ERROR", $msg );return;

    }say("Este es su Pedido");say("");say("");say("Cdigo");say("Nombre");say("Cantidad");say("Precio");say("Subtotal");say("");$total = 0;foreach ( $canasta as $item => $valor ) {

    $sql = "select idarticulo as art, nomarticulo as nom,";$sql .= "precio as precio ";$sql .= "from articulo as a ";$sql .= "where idarticulo = '$item' ";$rs = mysql_query( $sql, $cn );$row = mysql_fetch_assoc( $rs );$subtotal = $row["precio"] * $valor;$total += $subtotal;say("");say("".$row["art"]."");say("".$row["nom"]."");say("".$valor."");say("".$row["precio"]."");say("".$subtotal."");say("");

    }say("");say("Total");say("$total");say(" ");say("");say("");?>

  • 17

    /* error_php

    /* inicio.php

    Inicio de Sesin

    Email

    Contrasea

  • 18

  • 19