{"id":516,"date":"2020-04-16T11:13:30","date_gmt":"2020-04-16T09:13:30","guid":{"rendered":"https:\/\/drinkits.optimisti.lv\/?p=516"},"modified":"2020-04-16T11:13:30","modified_gmt":"2020-04-16T09:13:30","slug":"simple-php-script-for-vies-vat-number-validation","status":"publish","type":"post","link":"https:\/\/www.drinkits.lv\/en\/2020\/04\/16\/simple-php-script-for-vies-vat-number-validation\/","title":{"rendered":"Simple PHP script for VIES VAT number validation"},"content":{"rendered":"

\"\"<\/a>I have created simple VIES VAT number validation script. Script allows to upload previously prepared CSV with countryCode<\/em> and\u00a0vatNumber\u00a0<\/em>and creates HTML table with validation results.<\/p>\n

<\/p>\n

 <\/p>\n

CSV example:<\/p>\n

countryCode;vatNumber\nAT;U20557305\nAT;U55343505\nAT;U63017835\nAT;U63091969\nAT;U67414700\nAT;U68575437\nAT;U73556289\nBE;0502674883\nBG;106030859\nBG;115100705<\/pre>\n
PHP script:<\/p>\n
<!-- \n  Author: Karlis Rozenbergs\n  Blog: drinkits.optimisti.lv\n  Based on http:\/\/stackoverflow.com\/a\/29955950\n-->\n<html>\n  <head>\n    <script type=\"text\/javascript\" src=\"https:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/1.4.4\/jquery.js\"><\/script>\n    <style>\n      html, body {\n        width: 100%;\n    }\n\n    \/* Tables *\/\n    table {\n        position: relative;\n        \/\/display: block;\n        margin: 10px auto;\n        padding: 0;\n        width: 100%;\n        height: auto;\n        border-collapse: collapse;\n        text-align: center;\n    }\n\n    table thead tr {\n        background-color: green;\n        font-weight: bold;\n    }\n\n    table tr {\n        margin: 0;\n        padding: 0;\n        border: 0;\n        border: 1px solid #999;\n        width: 100%;\n    }\n\n    table tr td {\n        margin: 0;\n        padding: 4px 8px;\n        border: 0;\n        border: 1px solid #999;\n        \n    }\n    <\/style>\n    <script type=\"text\/javascript\">\n\n    $(document).ready(function(){\n        $('#tableID td').each(function(){\n            if ($(this).text() == 'false') {\n                $(this).css('background-color','red');\n            }\n        });\n    });\n\n    <\/script>\n  <\/head>\n  <body>\n    <form action=\"\" method=\"post\" enctype=\"multipart\/form-data\">\n        <input type=\"file\" name=\"file\">\n        <button type=\"submit\" name=\"import\">Import<\/button>\n    <\/form>\n<?php\nDEFINE('VIES_URL', 'http:\/\/ec.europa.eu\/taxation_customs\/vies\/services\/checkVatService');\n\/**\n * VIES VAT number validation\n * Based on http:\/\/stackoverflow.com\/a\/29955950\n *\n * @author Eugen Mihailescu\n *\n * @param string $countryCode\n * @param string $vatNumber\n * @param int $timeout\n *\/\nfunction viesCheckVAT($countryCode, $vatNumber, $timeout = 30) {\n    $response = array();\n    $pattern = '\/<(%s).*?>([\\s\\S]*)<\\\/\\1\/';\n    $keys = array('countryCode', 'vatNumber', 'requestDate', 'valid', 'name', 'address');\n    $content = \"<s11:Envelope xmlns:s11='http:\/\/schemas.xmlsoap.org\/soap\/envelope\/'>\n  <s11:Body>\n    <tns1:checkVat xmlns:tns1='urn:ec.europa.eu:taxud:vies:services:checkVat:types'>\n      <tns1:countryCode>%s<\/tns1:countryCode>\n      <tns1:vatNumber>%s<\/tns1:vatNumber>\n    <\/tns1:checkVat>\n  <\/s11:Body>\n<\/s11:Envelope>\";\n    $opts = array('http' => array('method' => 'POST', 'header' => \"Content-Type: text\/xml; charset=utf-8; SOAPAction: checkVatService\", 'content' => sprintf($content, $countryCode, $vatNumber), 'timeout' => $timeout));\n    $ctx = stream_context_create($opts);\n    $result = file_get_contents(VIES_URL, false, $ctx);\n    if (preg_match(sprintf($pattern, 'checkVatResponse'), $result, $matches)) {\n        foreach ($keys as $key) preg_match(sprintf($pattern, $key), $matches[2], $value) && $response[$key] = $value[2];\n    }\n    return $response;\n}\n\nif (isset($_POST['import'])) {\n    if ((isset($_FILES['file']) && is_array($_FILES['file']))) {\n        $csv = $_FILES['file'];\n        if (isset($csv['tmp_name']) && !empty($csv['tmp_name'])) {\n            $finfo = finfo_open(FILEINFO_MIME_TYPE);\n            $mime = finfo_file($finfo, $csv['tmp_name']);\n            finfo_close($finfo);\n            $allowed_mime = array('text\/x-comma-separated-values', 'text\/comma-separated-values', 'application\/octet-stream', 'application\/vnd.ms-excel', 'application\/x-csv', 'text\/x-csv', 'text\/csv', 'application\/csv', 'application\/excel', 'application\/vnd.msexcel', 'text\/plain');\n            if (in_array($mime, $allowed_mime) && is_uploaded_file($csv['tmp_name'])) {\n                $f = fopen($csv['tmp_name'], 'r');\n                fgetcsv($f);\n                $data = array();\n                while (!feof($f)) {\n                    $data[] = fgetcsv($f, null, ';');\n                }\n                foreach ($data as $array) {\n                    $dati[] = viesCheckVAT($array[0], $array[1]);\n                }\n                if (count($dati) > 0):\n                    $it = 0; ?>\n                <table id=\"tableID\">\n                  <thead>\n                    <tr>\n                      <th>ID<\/th>\n                      <th><?php echo implode('<\/th><th>', array_keys(current($dati))); ?><\/th>\n                    <\/tr>\n                  <\/thead>\n                  <tbody>\n                <?php foreach ($dati as $row):\n                        array_map('htmlentities', $row); ?>\n                    <tr>\n                      <td><?php $it++;\n                        echo $it; ?><\/td>\n                      <td><?php echo implode('<\/td><td>', $row); ?><\/td>\n                    <\/tr>\n                <?php\n                    endforeach; ?>\n                  <\/tbody>\n                <\/table>\n                <?php\n                endif;\n                fclose($f);\n                die;\n            }\n        }\n    }\n}\n?>\n  <\/body>\n<\/html><\/pre>\n
\"Test<\/p>\n","protected":false},"excerpt":{"rendered":"
I have created simple VIES VAT number validation script. Script allows to upload previously prepared CSV with countryCode and\u00a0vatNumber\u00a0and creates HTML table with validation results.<\/p>\n<\/a>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[7,8],"tags":[31,74,90,95,97,98,99],"class_list":{"0":"post-516","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-noderigi","7":"category-skripti","8":"tag-csv","9":"tag-php","10":"tag-script","11":"tag-validation","12":"tag-vat-number","13":"tag-vies","14":"tag-vies-vat-number-validation","15":"h-entry","16":"hentry"},"_links":{"self":[{"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/posts\/516","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/comments?post=516"}],"version-history":[{"count":0,"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/posts\/516\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/media?parent=516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/categories?post=516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.drinkits.lv\/en\/wp-json\/wp\/v2\/tags?post=516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}