<?php
function get_id_unico() {
    return date( "YmdHis" ) . sprintf( "%04d", rand( 0, 9999 ) );
}
function curlPOST($url_token, $post_fields, $headers) {
    $curl = curl_init();
    curl_setopt_array($curl, array(
    CURLOPT_URL => $url_token,
    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);
    curl_close($curl);
    return json_decode($response);
}
function curlGET($url_get, $headers) {
    $curl = curl_init();
    curl_setopt_array($curl, array(
    CURLOPT_URL => $url_get,
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_ENCODING => '',
    CURLOPT_MAXREDIRS => 10,
    CURLOPT_TIMEOUT => 0,
    CURLOPT_FOLLOWLOCATION => true,
    CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
    CURLOPT_CUSTOMREQUEST => 'GET',
    CURLOPT_POSTFIELDS => '',
    CURLOPT_HTTPHEADER => $headers,
    ));
    $response = curl_exec($curl);
    curl_close($curl);
    return json_decode($response);
}
function consultatipoVehiculo($bd, $id_exp, $alias_campo, $esquema) {
	$sql =  " 	SELECT ET.ALIAS
                FROM BIBLIOTECA_EXPEDIENTES BE
                INNER JOIN EXPEDIENTES_TIPOS ET ON ET.CODIGO = BE.TIPOEXP
                INNER JOIN ESQUEMAS_ESTRUCTURA EE ON EE.CODIGO = BE.GRUPOE
                INNER JOIN BIBLIOTECA_ELEMENTOS E ON E.EXPTE_CODIGO = BE.CLAVE
                WHERE E.CLAVE = '$id_exp' AND EE.ALIAS = '$alias_campo' AND EE.ESQUEMA = $esquema LIMIT 1";
  	$base = $bd->query($sql);
  	$row = mysqli_fetch_array($base);
  	$result = $row['ALIAS'];
  	return $result;
  	$base->close();
}
function consultaDescripcionEtiquetaExpediente($bd, $id_exp, $alias_campo, $esquema) {
	$sql =  " 	SELECT BE.DESCRIPCION
                FROM BIBLIOTECA_EXPEDIENTES BE
                INNER JOIN ESQUEMAS_ESTRUCTURA EE ON EE.CODIGO = BE.GRUPOE
                INNER JOIN BIBLIOTECA_ELEMENTOS E ON E.EXPTE_CODIGO = BE.CLAVE
                WHERE E.CLAVE = '$id_exp' AND EE.ALIAS = '$alias_campo' AND EE.ESQUEMA = $esquema LIMIT 1";
  	$base = $bd->query($sql);
  	$row = mysqli_fetch_array($base);
  	$result = $row['DESCRIPCION'];
  	return $result;
  	$base->close();
}
function consultaCodigoCampoEsquema($bd, $esquema, $alias) {
	$sql =  " 	SELECT E.CODIGO
                FROM ESQUEMAS_ESTRUCTURA E
                WHERE E.ESQUEMA = $esquema AND E.ALIAS = '$alias' LIMIT 1";
  	$base = $bd->query($sql);
  	$row = mysqli_fetch_array($base);
  	$result = $row['CODIGO'];
  	return $result;
  	$base->close();
}
function consultaDatosCliente($bd, $cod_campo_cliente, $id_exp) {
	$sql =  " 	SELECT EX.ETIQUETA, C.NOMBRE, C.NIF, C.APELLIDO1, C.APELLIDO2, C.EMAIL1, C.TLFNO1, C.TLFNO2, C.CP_PER, C.PROVINCIA_PER, C.POBLACION_PER
                FROM BIBLIOTECA_ELEMENTOS E
                INNER JOIN BIBLIOTECA_EXPEDIENTES EX ON EX.CLAVE = E.EXPTE_CODIGO AND EX.GRUPOE = $cod_campo_cliente
                INNER JOIN CONTACTOS C ON C.CODIGO = EX.ETIQUETA
                WHERE E.CLAVE = '$id_exp'";
  	$result = $bd->query($sql);
    $row = mysqli_fetch_array($result);
    return $row;
}
function consultaDatosVehiculo($bd, $cod_campo_vehiculo, $id_exp) {
	$sql =  " 	SELECT V.VERSION, V.MATRICULA, V.MATRICULACION, M.DESCRIPCION AS MARCA, MO.DESCRIPCION AS MODELO, V.TIPO
                FROM BIBLIOTECA_ELEMENTOS E
                INNER JOIN BIBLIOTECA_EXPEDIENTES EX ON EX.CLAVE = E.EXPTE_CODIGO AND EX.GRUPOE = $cod_campo_vehiculo
                INNER JOIN VEHICULOS V ON V.CODIGO = EX.ETIQUETA
                INNER JOIN VEHICULOS_MARCAS M ON V.MARCA = M.CODIGO
                INNER JOIN VEHICULOS_MODELOS MO ON V.MODELO = MO.CODIGO
                WHERE E.CLAVE = '$id_exp' LIMIT 1";
  	$result = $bd->query($sql);
    $row = mysqli_fetch_array($result);
    return $row;
}
function consultaParametroERSM($bd, $cod_parametro) {
	$sql =  " 	SELECT P.VALOR
                FROM INTER_ERSM_PARAMETROS P
                WHERE P.CODIGO = '$cod_parametro' LIMIT 1";
  	$base = $bd->query($sql);
  	$row = mysqli_fetch_array($base);
  	$result = $row['VALOR'];
  	return $result;
  	$base->close();
}
function registroERSM($bd, $codigo, $id_exp, $estado, $lead )
{
    $sql =  "   INSERT INTO INTER_ERSM_REGISTROS ( CODIGO, EXPEDIENTE, FECHA, ESTADO, LEADS )
                VALUES ( ?, ?, now(), ?, ? )";
    $base = $bd->prepare($sql);
    $codigo = mysqli_real_escape_string($bd, $codigo);
    $id_exp = mysqli_real_escape_string($bd, $id_exp);
    $estado = mysqli_real_escape_string($bd, $estado);
    $lead = mysqli_real_escape_string($bd, $lead);
    $base->bind_param('ssss', $codigo, $id_exp, $estado, $lead );
    $base->execute();
}
function consultaDatosConcesionario($bd, $cod_concesionario) {
	$sql =  " 	SELECT C.CODIGO, C.EMAIL, C.PWD
                FROM CFG_ERSM_CENTROS C
                WHERE C.CONCESIONARIO = '$cod_concesionario' LIMIT 1";
  	$base = $bd->query($sql);
  	$row = mysqli_fetch_array($base);
  	return $row;
  	$base->close();
}
?>