<?php
function validUniqPedido($bd, $quotation_id)
{
    $sql = "SELECT COUNT(P.CLAVE) AS TOTAL
            FROM INTER_DAPDA_PEDIDOS P
            WHERE P.QUOTATION_ID = '$quotation_id'";
    $base = $bd->query($sql);
    $row = mysqli_fetch_array($base);
    $resultIdent = $row['TOTAL'];
    return $resultIdent;
}
function getServiceKey($bd, $servicio)
{
    $sql = "SELECT SERV_KEY FROM API_ACCESS WHERE SERVICIO = '$servicio' LIMIT 1";
    $base = $bd->query($sql);
    $row = mysqli_fetch_array($base);
    $resultIdent = $row['SERV_KEY'];
    return $resultIdent;
}
function curlPost($url,$data,$headers) {
    $ch = curl_init();
    $timeout = 30;
    curl_setopt($ch, CURLOPT_URL,$url);
    curl_setopt($ch, CURLOPT_POST, TRUE);
    curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($data));
    curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
    $response = curl_exec ($ch);
    if (curl_errno($ch)) {
        echo 'Error:' . curl_error($ch);
    }
    curl_close ($ch);
    return $response;
}
function getToken($response){
    $result = json_decode($response);
    $token = $result->servToken->client_token;
    if(isset($token)){
        return true;
    }else{
        return false;
    }
}
function checkExistPedido ($bd, $quotation_id){
    $sql = " SELECT COUNT( QUOTATION_ID) AS EXIST_PED FROM INTER_DAPDA_PEDIDOS WHERE QUOTATION_ID = '$quotation_id' ";
    $base = $bd->query($sql);
    $row = mysqli_fetch_array($base);
    $resultIdent = $row['EXIST_PED'];
    return $resultIdent;
}
function deletePedido ($bd, $quotation_id){
    $sql = " DELETE FROM INTER_DAPDA_PEDIDOS WHERE CLAVE = '$quotation_id'";
    mysqli_multi_query($bd, $sql);
    $sql = " DELETE FROM INTER_DAPDA_PEDIDOS_OPCIONES WHERE CLAVE = '$quotation_id'";
    mysqli_multi_query($bd, $sql);
    $sql = " DELETE FROM INTER_DAPDA_PEDIDOS_DESCUENTOS WHERE CLAVE = '$quotation_id'";
    mysqli_multi_query($bd, $sql);
    $sql = " DELETE FROM INTER_DAPDA_PEDIDOS_LIN_SINIMP WHERE CLAVE = '$quotation_id'";
    mysqli_multi_query($bd, $sql);
    $sql = " DELETE FROM INTER_DAPDA_PEDIDOS_LIN_CONIMP WHERE CLAVE = '$quotation_id'";
    mysqli_multi_query($bd, $sql);
    if (!mysqli_query($bd, $sql)) {
    echo "Error: " . $sql . "<br>" . mysqli_error($bd);
    }
}




?>