<?php



function getLugaresDeEntrega()
{
$servername = "localhost";
$username = "delmundo_calc";
$password = "3s3cfWod(Oek";
$dbname = "delmundo_dmcourie_globa599_calculadora";


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT id,descripcion,costo FROM calculadora_lugar_entrega;";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $output = "[";
    while($row = $result->fetch_assoc()) {
        $output = $output.json_encode($row).",";
    }
    $output = rtrim($output,",");
    $output = $output."]";
    echo $output;
} else {
    echo "0 results";
}
$conn->close();
}

function getLugaresDeOrigen()
{
$servername = "localhost";
$username = "delmundo_calc";
$password = "3s3cfWod(Oek";
$dbname = "delmundo_dmcourie_globa599_calculadora";


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT id,descripcion,costo FROM calculadora_lugar_origen;";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $output = "[";
    while($row = $result->fetch_assoc()) {
        $output = $output.json_encode($row).",";
    }
    $output = rtrim($output,",");
    $output = $output."]";
    echo $output;
} else {
    echo "0 results";
}
$conn->close();
}

function getCategoriasProducto($tipo)
{
$servername = "localhost";
$username = "delmundo_calc";
$password = "3s3cfWod(Oek";
$dbname = "delmundo_dmcourie_globa599_calculadora";


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// tipo_normal por default
$sql = "SELECT id, clasificacion, derechos, iva, estadistica, imp_interno, manejo, costo_kg, costo_kg_pyme FROM calculadora_categoria_productos WHERE tipo_normal IS TRUE ORDER BY clasificacion;";
if ($tipo == "tipo_pyme") {
  $sql = "SELECT id, clasificacion, derechos, iva, estadistica, imp_interno, manejo, costo_kg, costo_kg_pyme FROM calculadora_categoria_productos WHERE tipo_pyme IS TRUE ORDER BY clasificacion;";
}

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $output = "[";
    while($row = $result->fetch_assoc()) {
        $output = $output.json_encode($row).",";
    }
    $output = rtrim($output,",");
    $output = $output."]";
    echo $output;
} else {
    echo "0 results";
}
$conn->close();
}

function getParametrosNegocio(){
$servername = "localhost";
$username = "delmundo_calc";
$password = "3s3cfWod(Oek";
$dbname = "delmundo_dmcourie_globa599_calculadora";


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT nombre,valor FROM calculadora_parametros_negocio;";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $output = "[";
    while($row = $result->fetch_assoc()) {
        $output = $output.json_encode($row).",";
    }
    $output = rtrim($output,",");
    $output = $output."]";
    echo $output;
} else {
    echo "0 results";
}
$conn->close();

}



?>
<?

if (isset($_GET['entidad']) && $_GET['entidad']=='lugar_entrega')
{
	header('Content-Type: application/json');
	getLugaresDeEntrega();
	exit();
}

if (isset($_GET['entidad']) && $_GET['entidad']=='lugar_origen')
{
    header('Content-Type: application/json');
    getLugaresDeOrigen();
    exit();
}

if (isset($_GET['entidad']) && $_GET['entidad']=='categoria_producto_tipo_normal')
{
    header('Content-Type: application/json');
    getCategoriasProducto("tipo_normal");
    exit();
}

if (isset($_GET['entidad']) && $_GET['entidad']=='categoria_producto_tipo_pyme')
{
    header('Content-Type: application/json');
    getCategoriasProducto("tipo_pyme");
    exit();
}

if (isset($_GET['parametros']) && $_GET['parametros']=='get_all')
{
    header('Content-Type: application/json');
    getParametrosNegocio();
    exit();
}
?>