?php
#
#
// Conectando y seleccionado la base de datos
$dbconn = pg_connect("host=192.168.3.2 dbname=damo user=postgres password=grafimundo") or die('No se ha podido conectar: ' . pg_last_error());
$CodProd = $_POST["codigo"];
$query1 ="SELECT stock_ingreso('013','" . $CodProd . "')";
$query2 ="SELECT stock_salido('013','" . $CodProd . "')";
$stockingreso = pg_query($query1) or die('La consulta fallo: ' . pg_last_error());
$stocksalida  = pg_query($query2) or die('La consulta fallo: ' . pg_last_error());

if (!$stockingreso) {
    echo "An error occured.\n";
    exit;
    }
    $row = pg_fetch_row ($stockingreso, 0);
    $ingresos = floatval(trim($row[0],"( )"));
//

if (!$stocksalida) {
    echo "An error occured.\n";
    exit;
    }
    $row = pg_fetch_row ($stocksalida, 0);
    $salidas = floatval(trim($row[0],"( )"));

$stockactual = $ingresos - $salidas;

// Liberando el conjunto de resultados
pg_free_result($stockingreso);
pg_free_result($stocksalida);

// Cerrando la conexión
pg_close($dbconn);

echo "Stock de Producto : ".$stockactual;
return json_encode($stockactual);
?>