Davčne blagajne

DamijanD je 24. dec 2015 ob 23:21 izjavil:

mickey: a tebi na XPjih samo te testne strani ne delujejo ali ti tudi potrjevanje ne deluje?

mkrin je 28. dec 2015 ob 15:18 izjavil:

...pri oddaji poslovnega prostora pa mi sporoči napako "Cold not create SSL/TLS secure channel"...

PrimozHisof je 21. dec 2015 ob 17:05 izjavil:

SonjaP je 15. dec 2015 ob 14:52 izjavil:

inkanet je 13. dec 2015 ob 00:21 izjavil:

A kdo ve katera (zneskovna) polja se pošiljajo na FURS, če se gre za račun izdan s strani malega davčnega zavezanca (davčni zavezanec, ki je oproščen plačila DDV po 94. členu ZDDV-1) ? Ali je dovolj da se pošlje samo:

InvoiceAmount
PaymentnAmount
ExemptVATTaxableAmount
TaxesPerSeller/VAT pa se kompletno izpusti

Mislim, da tudi ExemptVATTaxableAmount ni potrebno vpisovati. Namreč to je oproščen promet: "Skupna vrednost dobav blaga ali storitev na računu, ki so v skladu z Zakonom o davku na dodano vrednost oproščene plačila DDV."
To vrednost bi torej pošiljal, če bi imel na računu blago ali storitve, ki bi bile oproščene DDV-ja, tudi če bi bil zavezanec za DDV.
Komplicirano.. vem...

ExemptVATTaxableAmount je potrebno vpisovati če je izdajatelj nezavezanec

marko35 je 25. dec 2015 ob 11:25 izjavil:

Kako naj oblikujem XML račun, če nisem davčni zavezanec?
Na računu je klavzula: DDV ni obračunan po 1. točki 94. člena ZDDV - ddv torej ni izkazan.

:ExemptVATTaxableAmount = vrednost oproščenih dobav
:NontaxableAmount = vrednost nobdavčljivih dobav
:SpecialTaxRulesAmount = to naj bi bilo za turistične agencije, prodaja starin...

Kaj mislite da tole zadnje - SpecialTaxRulesAmount miniblagajna za prodajalne starin in turistične agencije sploh upošteva?

LP,Mare

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "DigitalniPodpis" as 
import java.security.Key;
import java.security.MessageDigest;
import java.security.PrivateKey;
import java.security.Signature;
import java.util.Enumeration;
import java.io.*;
import java.lang.Integer;
import java.security.*;
import java.util.*;
import javax.xml.crypto.dsig.*;
import javax.xml.crypto.dsig.dom.DOMSignContext;
import javax.xml.crypto.dsig.keyinfo.*;
import javax.xml.crypto.dsig.spec.*;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.transform.*;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;
import org.w3c.dom.*;
import java.net.URL;
import java.security.KeyManagementException;

import java.security.KeyStore;
import java.security.KeyStoreException;
import java.security.NoSuchAlgorithmException;
import java.security.UnrecoverableKeyException;
import java.security.cert.Certificate;
import java.security.cert.CertificateException;
import java.security.cert.CertificateFactory;
import java.security.cert.X509Certificate;
import javax.net.ssl.HttpsURLConnection;
import javax.net.ssl.KeyManagerFactory;
import javax.net.ssl.SSLContext;
import javax.net.ssl.SSLSocketFactory;
import javax.net.ssl.TrustManager;
import javax.net.ssl.TrustManagerFactory;

/**
 * ********************************************************************************
 * Naredil Peter Valenčič Izdelava 09.09.2015 Namen metode za generiranje in
 * podpisovanje xml datotek za davčno blagajno Datum metoda Spremembe 10.11.2015
 * initCert Dodan še trustore, webservice url ter inicializacija HTTPS povezave
 *
 **********************************************************************************
 */
public class DigitalniPodpis {
    public static String t="";
    public static KeyStore p12 = null;
    public static String geslo;
    public static String vmesni_rezultat = "";
    public static String alias = null;
    public static Key privateKey = null;
    public static Signature podpis = null;
    public static MessageDigest md = null;
    public static StringBuilder sb = new StringBuilder();
    public static HttpsURLConnection httpsURLConnection; //SSL povezava
    public static URL url; //webservice endpoint
    public static StringBuffer response = new StringBuffer();
    public static String inputLine = "";
    //public static DocumentBuilderFactory dbFactory;


    static {
        try {
            podpis = Signature.getInstance("SHA256WithRSA");
            md = MessageDigest.getInstance("MD5");
            //DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
            //dbFactory.setNamespaceAware(true);

        } catch (Exception ex) {

        }

    }

    public static HttpsURLConnection getHttpsURLConnection(URL url, String truststore, String keystore,
            String keyStorePass, String keyPassword, String KeyStoreType, String KeyManagerAlgorithm, String SSLVersion)
            throws NoSuchAlgorithmException, KeyStoreException,
            CertificateException, FileNotFoundException, IOException,
            UnrecoverableKeyException, KeyManagementException {
        //System.setProperty("javax.net.debug", "ssl,handshake,record");

        SSLContext sslcontext = SSLContext.getInstance(SSLVersion);
        KeyManagerFactory kmf = KeyManagerFactory.getInstance(KeyManagerAlgorithm);
        KeyStore ks = KeyStore.getInstance(KeyStoreType);
        ks.load(new FileInputStream(keystore), keyStorePass.toCharArray());
        kmf.init(ks, keyPassword.toCharArray());

        CertificateFactory cf = CertificateFactory.getInstance("X.509");

        InputStream is = new FileInputStream(truststore); //"c:/cert/test-tls.cer");
        InputStream caInput = new BufferedInputStream(is);
        Certificate ca;
        try {
            ca = cf.generateCertificate(caInput);
            System.out.println("ca=" + ((X509Certificate) ca).getSubjectDN());
        } finally {
            caInput.close();
        }
        String keyStoreType = KeyStore.getDefaultType();
        KeyStore keyStore = KeyStore.getInstance(keyStoreType);
        keyStore.load(null, null);
        keyStore.setCertificateEntry("ca", ca);

        // Create a TrustManager that trusts the CAs in our KeyStore
        String tmfAlgorithm = TrustManagerFactory.getDefaultAlgorithm();
        TrustManagerFactory tmf = TrustManagerFactory.getInstance(tmfAlgorithm);
        tmf.init(keyStore);

        TrustManager[] tm = tmf.getTrustManagers();

        sslcontext.init(kmf.getKeyManagers(), tm, null);
        SSLSocketFactory sslSocketFactory = sslcontext.getSocketFactory();
        HttpsURLConnection.setDefaultSSLSocketFactory(sslSocketFactory);
        HttpsURLConnection httpsURLConnection = (HttpsURLConnection) url.openConnection();

        return httpsURLConnection;
    }

    public static String podpisiRacun(String vhodniXml) throws Exception {
        DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
        dbFactory.setNamespaceAware(true);
        Document doc = (Document) dbFactory.newDocumentBuilder().parse(new ByteArrayInputStream(vhodniXml.getBytes()));
        Node node = doc.getElementsByTagName("fu:InvoiceRequest").item(0);
        Enumeration e = p12.aliases();
        String alias = (String) e.nextElement();
        System.out.println("Alias certifikata:" + alias);
        Key privateKey = p12.getKey(alias, geslo.toCharArray());

        KeyStore.PrivateKeyEntry keyEntry
                = (KeyStore.PrivateKeyEntry) p12.getEntry(alias, new KeyStore.PasswordProtection(geslo.toCharArray()));

        X509Certificate cert = (X509Certificate) keyEntry.getCertificate();

        PublicKey publicKey = cert.getPublicKey();
        final XMLSignatureFactory sigFactory = XMLSignatureFactory.getInstance("DOM");
        // Create a Reference to the enveloped document
        Reference ref = sigFactory.newReference("#data",
                sigFactory.newDigestMethod(DigestMethod.SHA256, null),
                Collections.singletonList(sigFactory.newTransform(Transform.ENVELOPED, (TransformParameterSpec) null)),
                null,
                null);

        SignedInfo si = sigFactory.newSignedInfo(sigFactory.newCanonicalizationMethod(CanonicalizationMethod.INCLUSIVE, (C14NMethodParameterSpec) null), sigFactory.newSignatureMethod("http://www.w3.org/2001/04/xmldsig-more#rsa-sha256", null), Collections.singletonList(ref));

        // Create a KeyValue containing the RSA PublicKey
        KeyInfoFactory keyInfoFactory = sigFactory.getKeyInfoFactory();
        X509IssuerSerial x509IssuerSerial = keyInfoFactory.newX509IssuerSerial(cert.getSubjectX500Principal().getName(), cert.getSerialNumber());

        List x509Content = new ArrayList();

        x509Content.add(cert.getSubjectX500Principal().getName());
        x509Content.add(x509IssuerSerial);

        KeyValue keyValue = keyInfoFactory.newKeyValue(publicKey);
        X509Data xd = keyInfoFactory.newX509Data(x509Content);

        // Create a KeyInfo and add the KeyValue to it
        KeyInfo keyInfo = keyInfoFactory.newKeyInfo(Collections.singletonList(xd));

        // Create a DOMSignContext and specify the RSA PrivateKey and
        // location of the resulting XMLSignature's parent element
        DOMSignContext dsc = new DOMSignContext(
                privateKey,
                node
        );

        // Create the XMLSignature (but don't sign it yet)
        XMLSignature signature = sigFactory.newXMLSignature(si, keyInfo);

        // Marshal, generate (and sign) the enveloped signature
        signature.sign(dsc);

        ByteArrayOutputStream os = new ByteArrayOutputStream();
        Transformer trans = TransformerFactory.newInstance()
                .newTransformer();
        trans.transform(new DOMSource(doc), new StreamResult(os));
        byte[] podatki = os.toByteArray();
        os.close();
        return new String(podatki);
    }

    public static String podpisiPoslovniProstor(String vhodniXml) throws Exception {
        DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
        dbFactory.setNamespaceAware(true);
        Document doc = (Document) dbFactory.newDocumentBuilder().parse(new ByteArrayInputStream(vhodniXml.getBytes()));
        Node node = doc.getElementsByTagName("fu:BusinessPremiseRequest").item(0);
        Enumeration e = p12.aliases();
        String alias = (String) e.nextElement();
        System.out.println("Alias certifikata:" + alias);
        Key privateKey = p12.getKey(alias, geslo.toCharArray());

        KeyStore.PrivateKeyEntry keyEntry
                = (KeyStore.PrivateKeyEntry) p12.getEntry(alias, new KeyStore.PasswordProtection(geslo.toCharArray()));

        X509Certificate cert = (X509Certificate) keyEntry.getCertificate();

        PublicKey publicKey = cert.getPublicKey();
        final XMLSignatureFactory sigFactory = XMLSignatureFactory.getInstance("DOM");
        // Create a Reference to the enveloped document
        Reference ref = sigFactory.newReference("#data",
                sigFactory.newDigestMethod(DigestMethod.SHA256, null),
                Collections.singletonList(sigFactory.newTransform(Transform.ENVELOPED, (TransformParameterSpec) null)),
                null,
                null);

        SignedInfo si = sigFactory.newSignedInfo(sigFactory.newCanonicalizationMethod(CanonicalizationMethod.INCLUSIVE, (C14NMethodParameterSpec) null), sigFactory.newSignatureMethod("http://www.w3.org/2001/04/xmldsig-more#rsa-sha256", null), Collections.singletonList(ref));

        // Create a KeyValue containing the RSA PublicKey
        KeyInfoFactory keyInfoFactory = sigFactory.getKeyInfoFactory();
        X509IssuerSerial x509IssuerSerial = keyInfoFactory.newX509IssuerSerial(cert.getSubjectX500Principal().getName(), cert.getSerialNumber());

        List x509Content = new ArrayList();

        x509Content.add(cert.getSubjectX500Principal().getName());
        x509Content.add(x509IssuerSerial);

        KeyValue keyValue = keyInfoFactory.newKeyValue(publicKey);
        X509Data xd = keyInfoFactory.newX509Data(x509Content);

        // Create a KeyInfo and add the KeyValue to it
        KeyInfo keyInfo = keyInfoFactory.newKeyInfo(Collections.singletonList(xd));

        // Create a DOMSignContext and specify the RSA PrivateKey and
        // location of the resulting XMLSignature's parent element
        DOMSignContext dsc = new DOMSignContext(
                privateKey,
                node
        );

        // Create the XMLSignature (but don't sign it yet)
        XMLSignature signature = sigFactory.newXMLSignature(si, keyInfo);

        // Marshal, generate (and sign) the enveloped signature
        signature.sign(dsc);

        ByteArrayOutputStream os = new ByteArrayOutputStream();
        Transformer trans = TransformerFactory.newInstance()
                .newTransformer();
        trans.transform(new DOMSource(doc), new StreamResult(os));

        return new String(os.toByteArray());
    }

    private static String md5Java(byte[] message) throws Exception {
        byte[] hash = md.digest(message); //.getBytes("UTF-8"));
        //StringBuilder sb = new StringBuilder(2 * hash.length);
        sb.setLength(0);
        for (byte b : hash) {
            sb.append(String.format("%02x", b & 0xff));
        }

        return sb.toString();
    }

    /**
     * Metoda inicializira keystore in truststore za SSL povezavo ter podpis
     * dokumentov
     *
     * @param direktorij direktorij kjer se fizično nahajajo certifikati
     * @param certifikat naziv datoteke certifikata
     * @param gesloc Geslo certifikata
     * @param trustStoreCertifikat naziv trustStore certifikata
     * @throws Exception
     */
    public static void initCert(String direktorij, String certifikat, String gesloc, String trustStoreCertifikat, String urlWsEndpoint) throws Exception {
        if (certifikat == null) {
            throw new Exception("ime datoteke certifikata za podpis podatkov ni podano!");
        }
        if (gesloc == null) {
            throw new Exception("geslo certifikata ni podano!");
        }

        if (trustStoreCertifikat == null) {
            throw new Exception("ime datoteke certifikata za trustStore ni podano!");
        }

        File f = new File(direktorij+"/"+certifikat);
        if (f.exists() == false)
        {
            throw new Exception("Certifikat za podpis ne obstaja na:" + (direktorij+"/"+certifikat));
        }

        f = new File(direktorij+"/"+trustStoreCertifikat);
        if (f.exists() == false)
        {
            throw new Exception("Certifikat za dostop do https ne obstaja na:" + (direktorij+"/"+trustStoreCertifikat));
        }

        // določimo URL do webservisa
        url = new URL(urlWsEndpoint);

        geslo = gesloc;
        if (p12 == null) {
            p12 = KeyStore.getInstance("pkcs12");
            p12.load(new FileInputStream(direktorij + "/" + certifikat), geslo.toCharArray());
            Enumeration e = p12.aliases();
            alias = (String) e.nextElement();
            privateKey = p12.getKey(alias, geslo.toCharArray());
            podpis.initSign((PrivateKey) privateKey);
        }

        //parametri za SSL povezavo
        if (httpsURLConnection == null) {
            SSLContext sslcontext = SSLContext.getInstance("TLS");
            KeyManagerFactory kmf = KeyManagerFactory.getInstance("SunX509");
            KeyStore ks = KeyStore.getInstance("PKCS12");
            ks.load(new FileInputStream(direktorij + "/" + certifikat), geslo.toCharArray());
            kmf.init(ks, geslo.toCharArray());

            CertificateFactory cf = CertificateFactory.getInstance("X.509");

            InputStream is = new FileInputStream(direktorij + "/" + trustStoreCertifikat); //"c:/cert/test-tls.cer");
            InputStream caInput = new BufferedInputStream(is);
            Certificate ca;
            try {
                ca = cf.generateCertificate(caInput);
                System.out.println("ca=" + ((X509Certificate) ca).getSubjectDN());
            } finally {
                caInput.close();
            }
            String keyStoreType = KeyStore.getDefaultType();
            KeyStore keyStore = KeyStore.getInstance(keyStoreType);
            keyStore.load(null, null);
            keyStore.setCertificateEntry("ca", ca);

            // Create a TrustManager that trusts the CAs in our KeyStore
            String tmfAlgorithm = TrustManagerFactory.getDefaultAlgorithm();
            TrustManagerFactory tmf = TrustManagerFactory.getInstance(tmfAlgorithm);
            tmf.init(keyStore);

            TrustManager[] tm = tmf.getTrustManagers();

            sslcontext.init(kmf.getKeyManagers(), tm, null);
            SSLSocketFactory sslSocketFactory = sslcontext.getSocketFactory();
            HttpsURLConnection.setDefaultSSLSocketFactory(sslSocketFactory);
            //vrnemo https povezavo, ki je globalna in aktivna skozi celo sejo.
            //httpsURLConnection = (HttpsURLConnection) url.openConnection();

        }
    }



        public static String sendXML(String soapAction,String soapEnvelopeXML) throws Exception {

        //nastavimo timeout
        //httpsURLConnection.setConnectTimeout(Integer.valueOf(timeoutMsec).intValue());
        if (httpsURLConnection == null) {
            httpsURLConnection = (HttpsURLConnection) url.openConnection();
        }
        //nastavimo header-je
        httpsURLConnection.setRequestMethod("POST");
        httpsURLConnection.setRequestProperty("User-Agent", "Mozilla/5.0");
        httpsURLConnection.setRequestProperty("Accept-Language", "en-US,en;q=0.5");
        httpsURLConnection.setRequestProperty("Content-type", "text/xml; charset=utf-8");
        httpsURLConnection.setRequestProperty("SOAPAction", soapAction);
        httpsURLConnection.setDoOutput(true);

            OutputStream reqStream = httpsURLConnection.getOutputStream();

            reqStream.write(soapEnvelopeXML.getBytes());

            int responseCode = httpsURLConnection.getResponseCode();
            System.out.println("\nSending 'POST' request to URL : " + url);

            System.out.println("Response Code : " + responseCode);
            if (responseCode == 200) {
                BufferedReader in = new BufferedReader(
                        new InputStreamReader(httpsURLConnection.getInputStream()));
                String inputLine;
               // StringBuffer response = new StringBuffer();
                response.setLength(0);
                while ((inputLine = in.readLine()) != null) {
                    response.append(inputLine);
                }
                in.close();
                httpsURLConnection.disconnect();
                return response.toString();

            }
            else
            {
                httpsURLConnection.disconnect();
                throw new Exception("Napaka pri povezavi na strežnik "+ url + ". Koda napake: " + responseCode);
            }

    }

     public static String sendXMLT(int timeout,String soapAction,String soapEnvelopeXML) throws Exception {

        httpsURLConnection = (HttpsURLConnection) url.openConnection();

        //nastavimo timeout
        httpsURLConnection.setConnectTimeout(timeout);
        httpsURLConnection.setReadTimeout(timeout);

      //nastavimo header-je
        httpsURLConnection.setRequestMethod("POST");
        httpsURLConnection.setRequestProperty("User-Agent", "Mozilla/5.0");
        httpsURLConnection.setRequestProperty("Accept-Language", "en-US,en;q=0.5");
        httpsURLConnection.setRequestProperty("Content-type", "text/xml; charset=utf-8");
        httpsURLConnection.setRequestProperty("SOAPAction", soapAction);
        httpsURLConnection.setDoOutput(true);

            OutputStream reqStream = httpsURLConnection.getOutputStream();

            reqStream.write(soapEnvelopeXML.getBytes());

            int responseCode = httpsURLConnection.getResponseCode();
            //System.out.println("\nSending 'POST' request to URL : " + url);

            //System.out.println("Response Code : " + responseCode);
            if (responseCode == 200) {
                BufferedReader in = new BufferedReader(
                        new InputStreamReader(httpsURLConnection.getInputStream()));

                response.setLength(0);

                while ((inputLine = in.readLine()) != null) {
                    response.append(inputLine);
                }
                in.close();
                httpsURLConnection.disconnect();
                return response.toString();

            }
            else
            {
                httpsURLConnection.disconnect();
                throw new Exception("Napaka pri povezavi na strežnik "+ url + ". Koda napake: " + responseCode);
            }

    }

    public static String getZOI(
            String davcnaStevilka,
            String datumIzdaje,
            String stevilkaRacuna,
            String oznakaPoslovnegaProstora,
            String electronicDeviceId,
            String znesekRacuna) throws Exception {

        //sestavimo vrstico
        vmesni_rezultat = davcnaStevilka.concat(datumIzdaje).concat(stevilkaRacuna).concat(oznakaPoslovnegaProstora).concat(electronicDeviceId).concat(znesekRacuna);
        podpis.update(vmesni_rezultat.getBytes("UTF-8"));
        byte[] podpisano = podpis.sign();

        //MD5 hash
        return md5Java(podpisano);
    }

}
/

CREATE OR REPLACE PACKAGE body OZP_FURS_UTIL
  AS
/*******************************************************************************
Naredil        Peter Valencic
Datum nastanka 09.09.2015
Zgodovina sprememb (zadnja na vrhu)

Zst.  Kdaj        Kdo                  Programska enota
      Kaj
================================================================================
7.    23.12.2015  Peter Valenčič       p_prenesi_racun
      Dodano je polnjenje atributov kjer merimo čas
6.    21.12.2105  Petar Grula          p_prenesi_racun
      Dodal obravnavo za avansne račune in izhodne fakture
5.    04.12.2015  Peter Valenčič       p_prenesi_racun_zs
      Nova procedura za prenos računov zunanjih sistemov

4.    10.11.2015  Peter Valenčič       p_inicializiraj_certifikat
3.    05.11.2015  Peter Valenčič       p_prenesi_racun
2.    01.10.2015  Peter Valenčič       p_ws_prenesi_poslovni_prostor
      procedura prenese xml v furs za zapis iz tabele PFR_POSLOVNI_PROSTOR

1.    09.09.2015  Peter Valenčič       f_vrni_zoi           
      izdelava funkcije za vračanje ZOI številke
********************************************************************************/

function f_getQRcode(p_text in varchar2) return BLOB as LANGUAGE JAVA  NAME 'QRCodeGenerator.getQrCode(java.lang.String) return oracle.sql.BLOB';

function f_xml( p_xml in xmltype
              , p_xpath in varchar2
              , p_namespace in varchar2 default 'xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
   xmlns:fu="http://www.fu.gov.si/"'
               ) return varchar2 as
begin
   return case
               when p_xml.extract(p_xpath, p_namespace) is not null then
                  trim(p_xml.extract(p_xpath, p_namespace).getstringval())
               else
                  null
               end;
end;
procedure print(text in varchar2) as
begin
    put_xl_line(text);
end;

function isEmpty(p_tekst in varchar2) return boolean is
begin
    if (p_tekst is null or p_tekst ='' or trim(p_tekst)='') then
        return true;
    end if;
    return false;
end;

function isNotEmpty(p_tekst in varchar2) return boolean is
begin
    if isEmpty(p_tekst) = true then
        return false;
    end if;
    return true;
end;

function f_test return varchar2 is language java name 'DigitalniPodpis.test() return java.lang.String';

function   f_printSignature return varchar2 is language java name 'DigitalniPodpis.printSignature() return java.lang.String';



function   f_send_xml(p_soapAction      in varchar2,
                      p_soapEnvelopeXML in varchar2) return varchar2 is
           language java name 'DigitalniPodpis.sendXML(java.lang.String,java.lang.String) return java.lang.String';

function   f_send_xml_timeout(p_timeout         in number,
                              p_soapAction      in varchar2,
                              p_soapEnvelopeXML in varchar2) return varchar2 is
           language java name 'DigitalniPodpis.sendXMLT(int,java.lang.String,java.lang.String) return java.lang.String';
function   f_java_vrni_zoi(
                      p_davcna_stevilka         in varchar2, -- davčna številka
                      p_datum_izdaje_racuna     in varchar2, -- format dd.mm.yyyy hh:mm:ss
                      p_stevilka_racuna         in varchar2, -- zaporedna številka računa
                      p_oznaka_posl_prostora    in varchar2, -- oznaka poslovnega prostora (glej dokumentacijo FURS-a)
                      p_naziv_prodajnega_mesta  in varchar2, -- naziv prodajnega mesta recimo (blagajna1)
                      p_znesek_racuna           in varchar2  -- znesek mora biti v formatu 12345.00 (brez vejic samo decimalna pika!)
                      ) return varchar2 is language java name
                      'DigitalniPodpis.getZOI(
                                              java.lang.String,
                                              java.lang.String,
                                              java.lang.String,
                                              java.lang.String,
                                              java.lang.String,
                                              java.lang.String) return java.lang.String ';
procedure p_java_init_cert(p_lokacija_certifikata       in varchar2, -- naziv oracle direktorija kjer je certifikat recimo: 'certifikati'
                          p_naziv_certifikata           in varchar2, -- naziv datoteke recimo: test.p12
                          p_geslo_certifikata           in varchar2, -- geslo certifikata, ki ga dobimo poleg certifikata
                          p_naziv_trustore_certifikata  in varchar2, -- naziv do trustore certifikata
                          p_url_ws_endpoint             in varchar2  -- url
                          ) is language java name    'DigitalniPodpis.initCert(java.lang.String, java.lang.String,java.lang.String,java.lang.String,java.lang.String)';

function f_java_podpisi_posl_prostor(p_vhodni_xml    in varchar2
                                     ) return varchar2 is language java name    'DigitalniPodpis.podpisiPoslovniProstor(java.lang.String) return java.lang.String';

function f_java_podpisi_racun(p_vhodni_xml    in varchar2
                                     ) return varchar2 is language java name    'DigitalniPodpis.podpisiRacun(java.lang.String) return java.lang.String';

function p_java_podpisi_racun1(p_vhodni_xml_clob    in varchar2
                                     ) return varchar2
as
begin
    return f_java_podpisi_racun(p_vhodni_xml_clob);
end;

 procedure p_inicializiraj_certifikat(   p_lokacija_certifikata         in varchar2, -- naziv oracle direktorija kjer je certifikat recimo: 'certifikati'
                                         p_naziv_certifikata            in varchar2, -- naziv datoteke recimo: test.p12
                                         p_geslo_certifikata            in varchar2, -- geslo certifikata, ki ga dobimo poleg certifikata
                                         p_naziv_trustore_certifikata   in varchar2, -- naziv do trustore certifikata
                                         p_url_ws_endpoint              in varchar2  -- url do webservisa (webservice endpoint url)
                                      ) as
  l_direktorij varchar2(200);
begin
    -- kontrola podatkov
    if isEmpty(p_lokacija_certifikata) then
        raise_application_error(-20001,'Parameter p_lokacija_certifikata ne sme biti prazen');
    end if;

    if isEmpty(p_naziv_certifikata) then
        raise_application_error(-20001,'Parameter p_naziv_certifikata ne sme biti prazen');
    end if;

    if isEmpty(p_geslo_certifikata) then
        raise_application_error(-20001,'Parameter p_geslo_certifikata ne sme biti prazen');
    end if;

    if isEmpty(p_naziv_trustore_certifikata) then
        raise_application_error(-20001,'Parameter p_naziv_trustore_certifikata ne sme biti prazen');
    end if;

    if isEmpty(p_url_ws_endpoint) then
        raise_application_error(-20001,'p_url_ws_endpoint');
    end if;

    -- pridobimo fizični naslov na disku za podan "direktorij"
    begin
        select directory_path into l_direktorij
        from all_directories adc
        where upper(adc.directory_name) = upper(p_lokacija_certifikata);
        dbms_output.put_line(l_direktorij);
    exception when no_data_found then
        raise_application_error(-20001,'Za podani direktorij ne morem pridobiti fizični naslov na disku');
    end;

    -- inicializiramo certifikat
    p_java_init_cert(p_lokacija_certifikata         => l_direktorij, -- naziv oracle direktorija kjer je certifikat recimo: 'certifikati'
                     p_naziv_certifikata            => p_naziv_certifikata, -- naziv datoteke recimo: test.p12
                     p_geslo_certifikata            => p_geslo_certifikata,
                     p_naziv_trustore_certifikata   => p_naziv_trustore_certifikata, -- naziv do trustore certifikata
                     p_url_ws_endpoint              => p_url_ws_endpoint
                     );

exception
   when qms$errors.qms$exception then
      raise;
   when others then
      qms$errors.show_message(p_mesg=>'ZAV-00002'
         , p_param0=>sqlerrm
         , p_param1=>'ozp_furs_util.p_inicializiraj_certifikat');
end;


function   f_vrni_zoi(
                      p_davcna_stevilka         in varchar2, -- davčna številka
                      p_datum_izdaje_racuna     in varchar2, -- format dd.mm.yyyy hh:mm:ss
                      p_stevilka_racuna         in varchar2, -- zaporedna številka računa
                      p_oznaka_posl_prostora    in varchar2, -- oznaka poslovnega prostora (glej dokumentacijo FURS-a)
                      p_naziv_prodajnega_mesta  in varchar2, -- naziv prodajnega mesta recimo (blagajna1)
                      p_znesek_racuna           in varchar2  -- znesek mora biti v formatu 12345.00 (brez vejic samo decimalna pika!)
                      ) return varchar2 -- MD5 hash 32 mestna številka
as
   l_direktorij varchar2(200);
begin


    return f_java_vrni_zoi(
                           P_DAVCNA_STEVILKA        => p_davcna_stevilka,
                           P_DATUM_IZDAJE_RACUNA    => p_datum_izdaje_racuna,
                           P_STEVILKA_RACUNA        => p_stevilka_racuna,
                           P_OZNAKA_POSL_PROSTORA   => p_oznaka_posl_prostora,
                           P_NAZIV_PRODAJNEGA_MESTA => p_naziv_prodajnega_mesta,
                           P_ZNESEK_RACUNA          => p_znesek_racuna);

exception
   when qms$errors.qms$exception then
      raise;
   when others then
      qms$errors.show_message(p_mesg=>'ZAV-00002'
         , p_param0=>sqlerrm
         , p_param1=>'ozp_furs_util.f_vrni_zoi');
end;

procedure p_ws_furs_echo(p_tekst               in varchar2,
                         p_echo_result         out clob,
                         p_napaka              out varchar2
                         ) as
   v_soap_request_text  clob;
   v_request            UTL_HTTP.REQ;
   v_response           UTL_HTTP.RESP;
   v_buffer             varchar2(32767);
   v_response_xml       clob;
   l_soap_env           xmltype;
   l_soap_body          xmltype;
   l_napaka_opis        varchar2(1000);
   l_napaka_koda        varchar2(200);
   l_tmp                varchar2(200);
   l_znesek             varchar2(1000);
   l_vsebina            clob;
   l_xmlns              clob;
   l_url                clob;
begin
  p_napaka := '';

   v_soap_request_text := '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:fu="http://www.fu.gov.si/">
   <soapenv:Header/>
   <soapenv:Body>
      <fu:EchoRequest>'|| utl_url.escape(p_tekst) ||'</fu:EchoRequest>
   </soapenv:Body>
</soapenv:Envelope>';

  put_xl_line('nastavimo timeout...');
  v_response_xml := f_send_xml_timeout( p_timeout => 2500, P_SOAPACTION =>'"/echo"', P_SOAPENVELOPEXML => v_soap_request_text);
  put_xl_line('response xml: ' || v_response_xml);
  -- variable za parsanje xml-a
  l_soap_env  := xmltype.createxml(v_response_xml);
  l_soap_body := l_soap_env.extract('/soapenv:Envelope/soapenv:Body/*','xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"');

  put_xl_line('body: ' || l_soap_body.getClobVal());
  p_echo_result := l_soap_body.extract('/fu:EchoResponse/text()','xmlns:fu="http://www.fu.gov.si/"').getstringval();

  -- sprostimo clob
  DBMS_LOB.freetemporary(v_response_xml);
exception
  when others then
    print('exception block');
    print( DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
    --utl_http.end_response(v_response);
    print(sqlerrm);
    p_napaka := sqlerrm;
end;
.
.
.
.

maticx46 je 30. dec 2015 ob 11:00 izjavil:

Pozdravljeni tisti, ki se še ukvarjate z blagajno.

Ali morda kdo ve, kako se ZOI številko konvertira v decimalno vrednost?
Sestaviti moram QR za na račun in ta je sestavljena iz ZOI + DŠ + DATUM.

Prosim za pomoč, da dobim string potem za QR kodo.

Hvala in LP

pubi1 je 30. dec 2015 ob 14:07 izjavil:

Živijo,

ima kdo XML primer naknadnega potrjevanja? vem, da je potrebno dodati oznako SubsequentSubmit, ampak ali je potrebno tudi navajati ostale tage, ki so obvezni pri spremembi računa? (ne vem, ali se naknadno potrjevanje smatra kot sprememba).

Vprašanje je tudi, kateri časi se pošiljajo? Ali se čas v XML-u popravi na čas ponovnega potrjevanja, al ostane čas računa?

PrimozHisof je 31. dec 2015 ob 09:44 izjavil:

racun s kao nepravilno kodo

PrimozHisof je 31. dec 2015 ob 09:44 izjavil:

racun s kao nepravilno kodo

kdo ve zakaj aplikacija PREVERI RAČUN javi napako:

Skeniranje računa ni bilo uspešno.
Koda ni pravilno sestavljena

podatke pa prebere pravilno

aplikacija PREVERI KODO pa ne javi napake!

srečno novo leto vsem