<?php
error_reporting(E_ALL);
ini_set("display_errors",1);
    function stock($CodProd){
        #
        #
        // Conectando y seleccionado la base de datos
        $dbconn = pg_connect("host=192.168.10.2 dbname=pruebasico 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";
            $return =  "An error occured.\n";
            exit;
        }
        $row = pg_fetch_row ($stockingreso, 0);
        $ingresos = floatval(trim($row[0],"( )"));
        //

        if (!$stocksalida) {
            //echo "An error occured.\n";
            $return =  "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);
        return $return;
    }
?>