<?php
function updateIdVehicle($bd, $idVehicle, $cod_car)
{
	$sql =  "   UPDATE VEHICULOS
                SET ID_COCHESNET = ?
                WHERE CODIGO = ?";
    $base = $bd->prepare($sql);
    $idVehicle = mysqli_real_escape_string($bd, $idVehicle);
    $cod_car = mysqli_real_escape_string($bd, $cod_car);
    $base->bind_param('si', $idVehicle, $cod_car);
    $base->execute();
    return mysqli_affected_rows($bd);
}
function curlDelete($url,$headers) {
    $curl = curl_init();
    curl_setopt_array($curl, array(
        CURLOPT_URL => $url,
        CURLOPT_RETURNTRANSFER => true,
        CURLOPT_ENCODING => '',
        CURLOPT_MAXREDIRS => 10,
        CURLOPT_TIMEOUT => 0,
        CURLOPT_FOLLOWLOCATION => true,
        CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
        CURLOPT_CUSTOMREQUEST => 'DELETE',
        CURLOPT_HTTPHEADER => $headers
      ));
      $response = curl_exec($curl);
    curl_close($curl);
    return json_decode($response);
}
function curlPost($url,$post_fields,$headers) {
    $curl = curl_init();
    curl_setopt_array($curl, array(
      CURLOPT_URL => $url,
      CURLOPT_RETURNTRANSFER => true,
      CURLOPT_ENCODING => '',
      CURLOPT_MAXREDIRS => 10,
      CURLOPT_TIMEOUT => 0,
      CURLOPT_FOLLOWLOCATION => true,
      CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
      CURLOPT_CUSTOMREQUEST => 'POST',
      CURLOPT_POSTFIELDS =>$post_fields,
      CURLOPT_HTTPHEADER => $headers
    ));
    $response = curl_exec($curl);
    $info = curl_getinfo($curl);
    //print_r($info);
    curl_close($curl);
    return json_decode($response);
}
function consultoDatosVehicle($bd, $cod_vehicle){
    $sql = "SELECT M.DESCRIPCION AS MARCA, V.COMBUSTIBLE, V.ANO_FAB, MD.DESCRIPCION AS MODELO, V.VERSION, V.MATRICULA, V.TIPO, V.KM, V.CAJACAMBIOS, V.GARANTIA, V.BASTIDOR, V.COLOR, V.VENTA_TOTAL, V.DISTINTIVO_AMB, V.ID_COCHESNET
            FROM VEHICULOS V
            INNER JOIN VEHICULOS_MARCAS M ON M.CODIGO = V.MARCA
            INNER JOIN VEHICULOS_MODELOS MD ON MD.CODIGO = V.MODELO
            WHERE V.CODIGO = ?";
    $base = $bd->prepare($sql);
    $cod_vehicle = mysqli_real_escape_string($bd, $cod_vehicle);
    $base->bind_param('i', $cod_vehicle);
    $base->execute();
    $result = mysqli_fetch_array($base->get_result());
    $base->close();
    return $result;
}
function curlGetData($url,$headers) {

    $ch = curl_init();
    $timeout = 30;
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_HTTPGET,true);
    curl_setopt($ch, CURLOPT_HTTPHEADER,$headers);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);

    $result = curl_exec($ch);
    curl_close($ch);
    return json_decode($result);
}
?>