Changeset 2556290

Timestamp:

06/30/2021 10:18:17 AM (5 years ago)

Author:

phcwordpress

Message:

20210630

Location:

drivefx-woocommerce/trunk

Files:

• PHCLibrary/classes/invoice.php (modified) (2 diffs)
• PHCLibrary/classes/settings.php (modified) (1 diff)
• PHCLibrary/classes/shipping.php (modified) (1 diff)
• PHCLibrary/customers.php (modified) (1 diff)
• PHCLibrary/invoices.php (modified) (8 diffs)
• PHCLibrary/orders.php (modified) (12 diffs)
• PHCLibrary/utils.php (modified) (6 diffs)
• class.DriveFxWoocommerce.php (modified) (22 diffs)
• settings/backend.php (modified) (1 diff)
• settings/syncro_gate.php (modified) (10 diffs)

drivefx-woocommerce/trunk/PHCLibrary/classes/invoice.php

@@ -2 +2 @@
 class Invoice {
     public $country;
-    public $shipping_country;
     public $cart;
-    public $shipping_name;
-    public $shipping_value;
-    public $fees;
     public $billing_name;
     public $billing_email;
@@ -14 +10 @@
     public $billing_postcode;
     public $billing_nif;
+    public $shipping_name;
+    public $shipping_value;
+    public $shipping_country;
+    public $shipping_taxValue;
+    public $shipping_tax;
+    public $fees;
 }

drivefx-woocommerce/trunk/PHCLibrary/classes/settings.php

@@ -3 +3 @@
     public $createInvoice;
     public $typeOfInvoice;
+    public $typeOf_EU_Invoice;
     public $toSignInvoice;
     public $fieldNif;

drivefx-woocommerce/trunk/PHCLibrary/classes/shipping.php

@@ -1 +1 @@
 <?php
 class Shipping {
+    public $cl_name;
+    public $ncont;
     public $paisto;
     public $moradato;

drivefx-woocommerce/trunk/PHCLibrary/customers.php

@@ -90 +90 @@
                 #If have Generic Customer
                 if(is_array($response['result'][0])){
+                    //reset NIF
+                    //$response['result'][0]['ncont'] = "";
+
                     //Return object
                     return (object) $response['result'][0];

drivefx-woocommerce/trunk/PHCLibrary/invoices.php

@@ -19 +19 @@
     }
 
+    public function getInvoiceSerieToUse($ch, $credentials, $dataPack){
+
+        //Obtain the shop country abbreviation acording to PHC
+        $response = $this->utils_services->filterItem_Query($ch, $credentials, 'Countries', 'nome', $dataPack->shop->country);
+
+        if (curl_error($ch)) {
+            $this->logs->writeFileLog('getInvoiceSerieToUse', $ch);
+        } else if(empty($response)){
+            $this->logs->writeFileLog('getInvoiceSerieToUse', 'EMPTY RESPONSE');
+        } else if(isset($response['messages'][0]['messageCodeLocale'])){
+            $this->logs->writeFileLog('getInvoiceSerieToUse', $response['messages'][0]['messageCodeLocale']);
+        } else {
+            // The shop country abbreviation
+            $companyCountry = $response['result'][0]['nomeabrv'];
+            // the order tax country
+            $taxCountry = $dataPack->shop->taxCountry;
+
+            if(!empty($companyCountry && $taxCountry)){
+                if($companyCountry == $taxCountry){
+                    //use the normal invoice serie
+                    $invoiceSerie = $dataPack->settings->typeOfInvoice;
+                } else {
+                    if(!empty($dataPack->settings->typeOf_EU_Invoice)){
+                        //use the invoice serie with with foreign VAT
+                        $invoiceSerie = $dataPack->settings->typeOf_EU_Invoice;
+                    } else {
+                        //use the normal invoice serie
+                        $invoiceSerie = $dataPack->settings->typeOfInvoice;
+                        $this->logs->writeFileLog('notice:', 'The invoice series by default is used, because the series for foreign VAT was not detected.');
+                    }
+                }
+            } else {
+                //use the normal invoice serie
+                $invoiceSerie = $dataPack->settings->typeOfInvoice;
+                $this->logs->writeFileLog('getInvoiceSerieToUse1.1', 'Can not obtain Country Tax or Company Tax, so we use the default doc. serie: ' .$invoiceSerie.'');
+            }
+        }
+        return $invoiceSerie;
+    }
+
     public function addSimpleInvoice($ch, $credentials, $dataPack){
         ###
@@ -25 +65 @@
         $shipping = $dataPack->shipping;
 
-        if(empty($settings->typeOfInvoice) || $settings->typeOfInvoice == 0){
+        # get the invoice serie to use
+        $invoiceSerie = $this->getInvoiceSerieToUse($ch, $credentials, $dataPack);
+
+        //$this->logs->writeFileLog('invoiceSerie1 response:', $invoiceSerie);
+
+        if(empty($invoiceSerie) || $invoiceSerie == 0){
             $this->logs->writeFileLog('addSimpleFT', 'Empty type of invoice');
         } else {
+
             ###
             $_billing_country = $ft->country;
@@ -67 +113 @@
             }
 
+            #Get taxes from Phc
+            $responseTaxes = $this->utils_services->getTaxes($ch, $credentials);
+
+           //$this->logs->writeFileLog('Get Taxes:', $responseTaxes['result']);
+
+            if (curl_error($ch)) {
+                $this->logs->writeFileLog('addSimpleFT3.1.1', $ch);
+            } else if(empty($responseTaxes)){
+                $this->logs->writeFileLog('addSimpleFT3.1.1', 'EMPTY RESPONSE');
+            } else if(isset($responseTaxes['messages'][0]['messageCodeLocale'])){
+                $this->logs->writeFileLog('addSimpleFT3.1.1', $responseTaxes['messages'][0]['messageCodeLocale']);
+            }
+
             # get current customer data
             $newCustomer = $this->customers_services->processCustomer($ch, $credentials, $dataPack, $tip_button);
@@ -85 +144 @@
             if($createClientSuccess == 1){
                 //Obtain new instance of invoice
-                $response = $this->utils_services->paramsNewInstance($ch, $credentials, 'FtWS', $settings->typeOfInvoice);
+                $response = $this->utils_services->paramsNewInstance($ch, $credentials, 'FtWS', $invoiceSerie);
 
                 //Clear the product lines
@@ -170 +229 @@
                                 $fi->qtt = 1;
 
-                                // IVA
                                 if($settings->includeTaxonSendCost == "true") {
                                     $fi->ivaincl=true;
                                 }
+
+                                ### [Query] - Obtain type of IVA
+                                $responseTax = $this->utils_services->doubleFilter($ch, $credentials, 'taxasiva', 'taxa', $ft->shipping_tax, 'regiao', $ft->shipping_country);
+                                //$this->logs->writeFileLog('OrderType response:', $response);
+
+                                if (curl_error($ch)) {
+                                    $this->logs->writeFileLog('responseTax', $ch);
+                                } else if(empty($response)){
+                                    $this->logs->writeFileLog('responseTax', 'EMPTY RESPONSE');
+                                } else if(isset($response['messages'][0]['messageCodeLocale'])){
+                                    $this->logs->writeFileLog('responseTax', $response['messages'][0]['messageCodeLocale']);
+                                } else {
+                                    //set IVA for Shipping
+                                    $fi->iva = $responseTax['result'][0]['taxa'];
+                                    $fi->tabiva = $responseTax['result'][0]['codigo'];
+                                }
+
                                 if($fi->etiliquido == 0){
                                     $fi->qtt = 0;
@@ -182 +257 @@
                             //actEntity
                             $response2 = $this->utils_services->actEntity($ch, $credentials, 'FtWS', $response);
+
+                            //$this->logs->writeFileLog('response2:', $response2['result'][0]['fis']);
 
                             // shipping value
@@ -246 +323 @@
                                 }
 
+                                #Obtain taxes
+                                if (is_array($cart)){
+                                    //get tax rate & tax rate country
+                                    foreach ($cart as $key => $value){
+                                        if( $value['qtt']*$value['epv']!=0){
+                                            $taxCountry = $value['tax_country'];
+                                            $taxRate = $value['tax_rate'];
+                                            $refProd = $value['ref'];
+
+                                            //obtain tax from Phc
+                                            foreach ($responseTaxes['result'] as $tax) {
+
+                                                if($taxRate == $tax['taxa'] && $taxCountry == $tax['regiao'] && $refProd == $response['result'][0]['fis'][$key]['ref']) {
+
+                                                $response['result'][0]['fis'][$key]['iva'] = $tax['taxa'];
+                                                $response['result'][0]['fis'][$key]['tabiva'] = $tax['codigo'];
+                                                if($settings->includeTaxonSendCost == "true") {
+                                                    $response['result'][0]['fis'][$key]['ivaincl'] = true;
+                                                    }
+                                                break;
+                                                }
+                                            }
+                                        }
+                                    }
+                                }
+
                                 #actEntity
                                 $response = $this->utils_services->actEntity($ch, $credentials, 'FtWS', $response);
@@ -314 +417 @@
         $settings =  $dataPack->settings;
 
-        if(empty($settings->typeOfInvoice) || $settings->typeOfInvoice == 0){
+        # get the invoice serie to use
+        $invoiceSerie = $this->getInvoiceSerieToUse($ch, $credentials, $dataPack);
+
+        //$this->logs->writeFileLog('invoiceSerie response:', $invoiceSerie);
+
+        if(empty($invoiceSerie) || $invoiceSerie == 0){
             $this->logs->writeFileLog('addInternalDocumentInvoice', 'Empty type of invoice');
         } else {
+
             //Obtain new instance of FT based in Bo(bostamp)
-            $response = $this->utils_services->paramsNewInstanceFromReference($ch, $credentials, $response['bostamp']);
+            $response = $this->utils_services->paramsNewInstanceFromReference($ch, $credentials, $response['bostamp'], $invoiceSerie);
 
             //$this->logs->writeFileLog('instanceFromReference:', $response);

drivefx-woocommerce/trunk/PHCLibrary/orders.php

@@ -147 +147 @@
                                     $response = $this->utils_services->filterItem_Query($ch, $credentials, 'Bo', $filterItem, $valueItem);
 
-                                    //$this->logs->writeFileLog('Response', $response);
+                                    //$this->logs->writeFileLog('Responses', $response);
 
                                     if (curl_error($ch)) {
@@ -360 +360 @@
         $response = $this->utils_services->paramsNewInstance($ch, $credentials, 'BoWS', $settings->typeOfOrder);
 
+        //$this->logs->writeFileLog('BoWs NewInstance', $response);
+
         //Clear the product lines
         $response['result'][0]['bis'] = [];
-
-        //$this->logs->writeFileLog('BoWs Response', $response);
 
         if (curl_error($ch)) {
@@ -375 +375 @@
             //Obtain number of customer
             $response['result'][0]['no'] = $newCustomer->no;
+
+            //$this->logs->writeFileLog('newCustomer:', $newCustomer);
+
             #actEntity
             $response = $this->utils_services->actEntity($ch, $credentials, 'BoWS', $response);
@@ -387 +390 @@
                 $this->logs->writeFileLog('addNewOrder13.1', $response['messages'][0]['messageCodeLocale']);
             } else {
+                $response['result'][0]['no'] = $newCustomer->no;
+                $response['result'][0]['nome'] = $newCustomer->nome;
+                $response['result'][0]['ncont'] = $newCustomer->ncont;
 
                 #Put the same number of order in PHC
@@ -404 +410 @@
                 $responseTaxes = $this->utils_services->getTaxes($ch, $credentials);
 
-                //$this->logs->writeFileLog('Get Taxes:', $responseTaxes);
+                //$this->logs->writeFileLog('Get Taxes:', $responseTaxes['result']);
 
                 if (curl_error($ch)) {
@@ -445 +451 @@
                     //IVA for shipping
                     foreach ($responseTaxes['result'] as $tax) {
+
                         if ($shipping->shipping_tax == $tax['taxa'] &&
                             $shipping->shipping_country == $tax['regiao']) {
@@ -453 +460 @@
                         }
                     }
+
                     if($bi->edebito == 0){
                         $bi->qtt = 0;
@@ -462 +470 @@
                 $response2 = $this->utils_services->actEntity($ch, $credentials, 'BoWS', $response);
 
-                //$this->logs->writeFileLog('actEntity.0.1:', $response2);
+                //$this->logs->writeFileLog('actEntity.0.1:', $response2['result'][0]['bis']);
 
                 // Update shipping value
@@ -477 +485 @@
                 $response = $this->utils_services->actEntity($ch, $credentials, 'BoWS', $response2);
 
-              // $this->logs->writeFileLog('actEntity1:', $response);
+                //$this->logs->writeFileLog('actEntity1:', $response['result']);
 
                 if (curl_error($ch)) {
@@ -566 +574 @@
                         $response['result'][0]['ncont'] = $bill->ncont;
 
+
                         #Obtain taxes
                         if (is_array($order->cart)){
@@ -574 +583 @@
                                     $taxRate = $value['tax_rate'];
                                     $refProd = $value['ref'];
+
                                     //obtain tax from Phc
                                     foreach ($responseTaxes['result'] as $tax) {
-                                        if($taxRate == $tax['taxa'] && $taxCountry == $tax['regiao'] && $refProd == $response['result'][0]['ref']) {
+
+                                        if($taxRate == $tax['taxa'] && $taxCountry == $tax['regiao'] && $refProd == $response['result'][0]['bis'][$key]['ref']) {
+
                                            $response['result'][0]['bis'][$key]['iva'] = $tax['taxa'];
                                            $response['result'][0]['bis'][$key]['tabiva'] = $tax['codigo'];
@@ -588 +600 @@
                             }
                         }
-                       //$this->logs->writeFileLog('Obtain taxes:', $response['result'][0]);
+                        //$this->logs->writeFileLog('Obtain taxes:', $response['result'][0]['bis']);
                         ###
                         $fees = $order->fees;

drivefx-woocommerce/trunk/PHCLibrary/utils.php

@@ -108 +108 @@
         //Build Http query using params
         $this->query = http_build_query ($this->params);
-
-        //Called webservice that make a request
-        $response=$this->doPhcRequest($ch, $this->url, $this->params, $credentials);
-
+        //Called webservice that make a request
+        $response=$this->doPhcRequest($ch, $this->url, $this->params, $credentials);
         return $response;
     }
@@ -334 +332 @@
     ********************************************************************/
     /** Header to create Query of webservice called  **/
-    public function paramsQuery5($ch, $credentials, $entityName, $comparison, $filterItem = null, $valueItem = null, $comparisonTwo, $filterItemTwo = null, $valueItemTwo = null ){
+    public function paramsQuery5($ch, $credentials, $entityName, $comparison = null, $filterItem = null, $valueItem = null, $comparisonTwo = null, $filterItemTwo = null, $valueItemTwo = null){
         $this->url = $credentials->backendUrl."/REST/SearchWS/QueryAsEntities";
         //Create map with request parameters
@@ -368 +366 @@
         //Called webservice that make a request
         $response=$this->doPhcRequest($ch, $this->url, $this->params, $credentials);
-
         return $response;
     }
@@ -472 +469 @@
     ********************************************************************/
     //Header to create a new instance from reference of webservice called
-    public function paramsNewInstanceFromReference($ch, $credentials, $boStamp){
+    public function paramsNewInstanceFromReference($ch, $credentials, $boStamp, $invoiceType){
         $this->url = $credentials->backendUrl."/REST/FtWS/getNewInstanceFromReference";
         // Create map with request parameters
@@ -482 +479 @@
                                                     },
                                                     {"key":"docid",
-                                                    "value":"'.$credentials->invoiceType.'"
+                                                    "value":"'.$invoiceType.'"
                                                     }
                                                 ]'
@@ -757 +754 @@
     }
 
-
-
-
 }
 ?>

drivefx-woocommerce/trunk/class.DriveFxWoocommerce.php

@@ -33 +33 @@
                 'sendInvoice'       => array('label' => 'Send Invoice',                               'type' => 'checkbox',      'required' => false, 'checkboxDescription' => 'Send the client an e-mail with the order invoice attached', 'notice' => ''),
                 'emailBody'         => array('label' => 'E-mail body content',                        'type' => 'text',          'required' => false, 'descr' => 'Enter the text to be attached to the e-mails sent to the client.', 'notice' => ''),
-                'typeOfInvoice'     => array('label' => 'Type of Invoice Document',                   'type' => 'select',        'required' => false, 'checkboxDescription' => 'Choose the type of invoice document', 'notice' => ''),
+                'typeOfInvoice'     => array('label' => 'Type of Invoice Document (PT)',              'type' => 'select',        'required' => false, 'checkboxDescription' => 'Choose the type of invoice document', 'notice' => ''),
+                'typeOf_EU_Invoice' => array('label' => 'Type of Invoice Document (EU)',              'type' => 'select',        'required' => false, 'checkboxDescription' => 'Choose the type of invoice document', 'notice' => ''),
                 'toSignInvoice'     => array('label' => 'Sign Invoice',                               'type' => 'checkbox',      'required' => false, 'checkboxDescription' => 'Sign Invoice document after its creation.', 'notice' => ''),
                 'fieldNif'          => array('label' => 'NIF Field in Woocommerce',                   'type' => 'select',        'required' => false, 'checkboxDescription' => 'Choose the nif field of woocommerce', 'notice' => ''),
@@ -655 +656 @@
             // send response as JSON
             $response = json_decode($response, true);
-            // get the temporary token and insert in credentials object
+            // get the new token and insert in credentials object
             $credentials->token = $response['result'][0]['token'];
 
@@ -678 +679 @@
                 $selected_dropdown = '';
                 $_SESSION['fieldNif'] = '';
-
-
                 $_SESSION['includeTaxonSendCost']="<option value='true'";
+
                 if($settings['backend']['includeTaxonSendCost'] == 'true')
-                        $_SESSION['includeTaxonSendCost'].=" selected ";
-                $_SESSION['includeTaxonSendCost'].=">Yes</option>";
-                $_SESSION['includeTaxonSendCost'].="<option value='false'";
+                    $_SESSION['includeTaxonSendCost'].=" selected ";
+                    $_SESSION['includeTaxonSendCost'].=">Yes</option>";
+                    $_SESSION['includeTaxonSendCost'].="<option value='false'";
                 if($settings['backend']['includeTaxonSendCost'] == 'false')
-                        $_SESSION['includeTaxonSendCost'].=" selected ";
-                $_SESSION['includeTaxonSendCost'].=">No</option>";
-
-
+                    $_SESSION['includeTaxonSendCost'].=" selected ";
+                    $_SESSION['includeTaxonSendCost'].=">No</option>";
 
                 if($settings['backend']['fieldNif'] == "company"){
-                  $_SESSION['fieldNif'] .= "<option value='company' selected >Company</option><br>";
-                  $_SESSION['fieldNif'] .= "<option value='address_2'>Address 2</option><br>";
-                  $_SESSION['fieldNif'] .= "<option value='state'>State</option><br>";
-                   $_SESSION['fieldNif'] .= "<option value='nif'>Billing Nif (Plugin)</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='company' selected >Company</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='address_2'>Address 2</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='state'>State</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='nif'>Billing Nif (Plugin)</option><br>";
                 } else if($settings['backend']['fieldNif'] == "address_2"){
-                  $_SESSION['fieldNif'] .= "<option value='company'>Company</option><br>";
-                  $_SESSION['fieldNif'] .= "<option value='address_2' selected >Address 2</option><br>";
-                  $_SESSION['fieldNif'] .= "<option value='state'>State</option><br>";
-                   $_SESSION['fieldNif'] .= "<option value='nif'>Billing Nif (Plugin)</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='company'>Company</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='address_2' selected >Address 2</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='state'>State</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='nif'>Billing Nif (Plugin)</option><br>";
                 } else if($settings['backend']['fieldNif'] == "state") {
-                  $_SESSION['fieldNif'] .= "<option value='company'>Company</option><br>";
-                  $_SESSION['fieldNif'] .= "<option value='address_2'>Address 2</option><br>";
-                  $_SESSION['fieldNif'] .= "<option value='state' selected >State</option><br>";
-                   $_SESSION['fieldNif'] .= "<option value='nif'>Billing Nif (Plugin)</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='company'>Company</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='address_2'>Address 2</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='state' selected >State</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='nif'>Billing Nif (Plugin)</option><br>";
                 }else{
-                 $_SESSION['fieldNif'] .= "<option value='company'>Company</option><br>";
-                  $_SESSION['fieldNif'] .= "<option value='address_2'>Address 2</option><br>";
-                  $_SESSION['fieldNif'] .= "<option value='state'  >State</option><br>";
-                   $_SESSION['fieldNif'] .= "<option value='nif' selected >Billing Nif (Plugin)</option><br>";
-                }
-
-                //Obtain gama of PHC
+                    $_SESSION['fieldNif'] .= "<option value='company'>Company</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='address_2'>Address 2</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='state'  >State</option><br>";
+                    $_SESSION['fieldNif'] .= "<option value='nif' selected >Billing Nif (Plugin)</option><br>";
+                }
+
+                ### [Query] - Obtain gama of PHC
                 $response = $this->utils_services->paramsGetBackEndInfo($ch, $credentials);
-
                 //$this->logs->writeFileLog('BackEnd response:', $response);
 
@@ -728 +725 @@
                 }
 
-                //Obtain parameter of manage stock
+                ### [Query] - Obtain parameter of manage stock
                 $response = $this->utils_services->paramsGetFrontendInfo($ch, $credentials);
-
                 //$this->logs->writeFileLog('FrontEnd response:', $response);
 
@@ -747 +743 @@
                 }
 
-                //Obtain type invoices
-                $response = $this->utils_services->filterItem_Query($ch, $credentials, 'Td', 'inactivo', 0);
-
-                //$this->logs->writeFileLog('TypeInvoice response:', $response);
+                ### [Query] - Obtain type invoices for PT
+                $response = $this->utils_services->paramsQuery5($ch, $credentials, 'Td', '0','inactivo', 0, '0','isNotTaxRegionPT', 0);
+                //$this->logs->writeFileLog('TypeInvoicePT response:', $response);
 
                 if (curl_error($ch)) {
@@ -759 +754 @@
                 } else if(isset($response['messages'][0]['messageCodeLocale'])){
                     $this->logs->writeFileLog('setCommunicationFx3', $response['messages'][0]['messageCodeLocale']);
-                    $this->messagesError(" obtain dropdown with type of invoices! Message from Backend: " . $response['messages'][0]['messageCodeLocale']);
+                    $this->messagesError("Error getting dropdown with type of invoices! Message from Backend: " . $response['messages'][0]['messageCodeLocale']);
                 } else {
-                    //Create options of dropdownlist invoices
+
+                    #1.1 - Create options of dropdownlist invoices for PT
                     $i = 0;
                     $typeInvoice = array();
-                    $_SESSION['typeOfInvoice'] = '';
+                    $_SESSION['typeOfInvoice'] = ' ';
 
                     foreach ($response['result'] as $key => $value){
@@ -773 +769 @@
                                 $selected_dropdown = '';
                             }
-
                             $_SESSION['typeOfInvoice'] .= "<option value=" . $value['ndoc'] . " " . $selected_dropdown . ">" . $value['nmdoc'] ."</option><br>";
                             ++$i;
                         }
                     }
-                    #Obtain tax free reason list (for outside of PT)
+
+                    ### [Query] - Obtain type invoices for EU
+                    $responseEu = $this->utils_services->paramsQuery5($ch, $credentials, 'Td', '0','inactivo', 0, '0','isNotTaxRegionPT', 1);
+                    //$this->logs->writeFileLog('TypeInvoiceEU response:', $responseEu);
+
+                    if (curl_error($ch)) {
+                        $this->logs->writeFileLog('setCommunicationFx3.1', $ch);
+                    } else if(empty($response)){
+                        $this->logs->writeFileLog('setCommunicationFx3.1', 'EMPTY RESPONSE');
+                        $this->messagesError("Can't connect to webservice!! There's an empty response for EU series of invoice");
+                    } else if(isset($response['messages'][0]['messageCodeLocale'])){
+                        $this->logs->writeFileLog('setCommunicationFx3.1', $response['messages'][0]['messageCodeLocale']);
+                        $this->messagesError("Error getting dropdown with type of invoices for EU! Message from Backend: " . $response['messages'][0]['messageCodeLocale']);
+                    } else {
+
+                        #1.2 - Create options of dropdownlist invoices for EU
+                        $i = 0;
+                        $_SESSION['typeOf_EU_Invoice'] = ' ';
+
+                        foreach ($responseEu['result'] as $key => $value){
+                            if($value['tiposaft'] == 'FT' || $value['tiposaft'] == 'FS' || $value['tiposaft'] == 'FR'){
+                                if($settings['backend']['typeOf_EU_Invoice'] == $value['ndoc']){
+                                    $selected_dropdown = 'selected';
+                                } else {
+                                    $selected_dropdown = '';
+                                }
+                                $_SESSION['typeOf_EU_Invoice'] .= "<option value=" . $value['ndoc'] . " " . $selected_dropdown . ">" . $value['nmdoc'] ."</option><br>";
+                                ++$i;
+                            }
+                        }
+                    }
+
+                    ### [Query] - Obtain tax free reason list
                     $response = $this->utils_services->entityName_Query($ch, $credentials, 'Miseimp');
-
                     //$this->logs->writeFileLog('Miseimp response:', $response);
 
@@ -792 +818 @@
                         $this->messagesError(" obtain dropdown with tax free reason list! Message from Backend: " . $response['messages'][0]['messageCodeLocale']);
                     } else {
-                        //Create options of dropdownlist reasons list
+
+                        #2.1 - Create options of dropdownlist reasons list (for outside of PT)
                         $i = 0;
                         $typeInvoice = array();
@@ -803 +830 @@
                                 $selected_dropdown = '';
                             }
-
                             $_SESSION['typeOfReason'] .= "<option value=" . $value['codigo'] . " " . $selected_dropdown . ">" . $value['descricao'] ."</option><br>";
                             ++$i;
                         }
-                    }
-                    #Obtain tax free reason list (for outside of EU)
-                    $response = $this->utils_services->entityName_Query($ch, $credentials, 'Miseimp');
-
-                    //$this->logs->writeFileLog('Miseimp response:', $response);
-
-                    if (curl_error($ch)) {
-                        $this->logs->writeFileLog('setCommunication3.2.1', $ch);
-                    } else if(empty($response)){
-                        $this->logs->writeFileLog('setCommunication3.2.1', 'EMPTY RESPONSE');
-                        $this->messagesError("Can't connect to webservice!! There's an empty response");
-                    } else if(isset($response['messages'][0]['messageCodeLocale'])){
-                        $this->logs->writeFileLog('setCommunication3.2.1', $response['messages'][0]['messageCodeLocale']);
-                        $this->messagesError(" obtain dropdown with tax free reason list! Message from Backend: " . $response['messages'][0]['messageCodeLocale']);
-                    } else {
-                        //Create options of dropdownlist reasons list
+
+                        #2.2 - Create options of dropdownlist reasons list (for outside of EU)
                         $i = 0;
                         $typeInvoice = array();
@@ -833 +845 @@
                                 $selected_dropdown = '';
                             }
-
                             $_SESSION['typeOfReasonEU'] .= "<option value=" . $value['codigo'] . " " . $selected_dropdown . ">" . $value['descricao'] ."</option><br>";
                             ++$i;
                         }
-                    }
-                    #Obtain tax free reason list (for EU Companies)
-                    $response = $this->utils_services->entityName_Query($ch, $credentials, 'Miseimp');
-
-                    //$this->logs->writeFileLog('Miseimp response:', $response);
-
-                    if (curl_error($ch)) {
-                        $this->logs->writeFileLog('setCommunication3.2.2', $ch);
-                    } else if(empty($response)){
-                        $this->logs->writeFileLog('setCommunication3.2.2', 'EMPTY RESPONSE');
-                        $this->messagesError("Can't connect to webservice!! There's an empty response");
-                    } else if(isset($response['messages'][0]['messageCodeLocale'])){
-                        $this->logs->writeFileLog('setCommunication3.2.2', $response['messages'][0]['messageCodeLocale']);
-                        $this->messagesError(" obtain dropdown with tax free reason list! Message from Backend: " . $response['messages'][0]['messageCodeLocale']);
-                    } else {
-                        //Create options of dropdownlist reasons list
+
+                        #2.3 - Create options of dropdownlist reasons list (for EU Companies)
                         $i = 0;
                         $typeInvoice = array();
@@ -863 +860 @@
                                 $selected_dropdown = '';
                             }
-
                             $_SESSION['typeOfReasonCO'] .= "<option value=" . $value['codigo'] . " " . $selected_dropdown . ">" . $value['descricao'] ."</option><br>";
                             ++$i;
                         }
                     }
-                    #Obtain services name list
+
+                    ### [Query] - Obtain services name list
                     $response = $this->utils_services->filterItem_compare($ch, $credentials, 'St', '0', 'stns', '1');
+                    //$this->logs->writeFileLog('Services response:', $response);
 
                     if (curl_error($ch)) {
@@ -880 +878 @@
                         $this->messagesError(" obtain dropdown with tax free reason list! Message from Backend: " . $response['messages'][0]['messageCodeLocale']);
                     } else {
-                        //Create options of dropdownlist services list for shipping reference
+
+                        #3.1 - Create options of dropdownlist services list for shipping reference
                         $i = 0;
                         $_SESSION['shippingName'] = '';
@@ -894 +893 @@
                             ++$i;
                         }
-                        //Create options of dropdownlist services list for fees reference
+
+                        #3.2 - Create options of dropdownlist services list for fees reference
                         $i = 0;
                         $_SESSION['feesName'] = '';
@@ -910 +910 @@
                     }
 
-                    #If gama is equal or higher of STAR
+                    //If gama is equal or higher of STAR
                     if($_SESSION['gamaDRIVEFX'] >= 9){
-                        //Obtain type orders
+
+                        ### [Query] - Obtain type orders
                         $response = $this->utils_services->doubleFilter($ch, $credentials, 'Ts', 'bdempresas', 'CL', 'trfa', '0');
-
                         //$this->logs->writeFileLog('OrderType response:', $response);
 
@@ -941 +941 @@
                                         }
                                     } else if ($key == "nmdos"){
-                                        //Obtain type orders
+
+                                        ### [Query] - Obtain type orders
                                         $response2 = $this->utils_services->getInternalDoc($ch, $credentials, 'Bo', 'nmdos', $value);
-
                                        // $this->logs->writeFileLog('InternalDoc response:', $response2);
 
@@ -958 +958 @@
                                             global $wpdb;
                                             $table_name = $wpdb->prefix."postmeta";
-                                            //Obtain next post_id of order in MySQL
+
+                                            ### [Query] - Obtain next post_id of order in MySQL
                                             $query = "SELECT MAX(post_id)+1 as nextPostId FROM %s";
                                             $docid = $wpdb->get_row(str_replace("'", "", $wpdb->prepare($query, $table_name)));
@@ -982 +983 @@
                         }
 
-                        //Obtain warehouses
+                        ### [Query] - Obtain warehouses
                         $response = $this->utils_services->entityName_Query($ch, $credentials, 'Sa');
-
                         //$this->logs->writeFileLog('Warehouses response:', $response);
 
@@ -1033 +1033 @@
                     //Verify if are selected type of internal document and send invoice checkbox
                     if(isset($settings['backend']['typeOfInvoice']) && $settings['backend']['createInvoice'] == 'on' && $settings['backend']['typeOfInvoice'] > 0 && isset($settings['backend']['sendInvoice'])){
-                        //Obtain type invoices
+
+                        ### [Query] - Obtain type invoices
                         $response = $this->utils_services->paramsGetReportForPrint($ch, $credentials);
-
                         //$this->logs->writeFileLog('ReportPrint response:', $response);
 
@@ -1069 +1069 @@
                 }
 
-                //Obtain currency coin of company
+                ### [Query] - Obtain currency coin of company
                 $response = $this->utils_services->filterItem_Query($ch, $credentials, 'E1', 'estab', 0);
-
                 //$this->logs->writeFileLog('E1 response:', $response);
 
@@ -1816 +1815 @@
 
                     // Products with VAT included in price
-                    if(($woocommerce_calc_taxes == "no") || ($woocommerce_calc_taxes == "yes" && $woocommerce_prices_include_tax == "yes")) {
+                    if(($woocommerce_calc_taxes == "no") || ($woocommerce_calc_taxes == "yes" && $settings['backend']['includeTaxonSendCost'] == "true")) {
+                    //if(($woocommerce_calc_taxes == "no") || ($woocommerce_calc_taxes == "yes" && $woocommerce_prices_include_tax == "yes")) {
 
                         if ($settings['backend']['positiveStock'] == 'on'){
@@ -1824 +1824 @@
                         }
 
-                        //$this->logs->writeFileLog('StList response1:', $response);
+                        //$this->logs->writeFileLog('StList with tax:', $response);
 
                     }
                     // Products without VAT included in price
-                    else if($woocommerce_calc_taxes == "yes" && $woocommerce_prices_include_tax == 'no'){
+                    else if($woocommerce_calc_taxes == "yes" && $settings['backend']['includeTaxonSendCost'] == "false"){
+                    //else if($woocommerce_calc_taxes == "yes" && $woocommerce_prices_include_tax == 'no'){
 
                         if ($settings['backend']['positiveStock'] == 'on'){
@@ -1836 +1837 @@
                         }
 
-                        //$this->logs->writeFileLog('StList response2:', $response);
+                        //$this->logs->writeFileLog('StList without tax:', $response);
 
                     }

drivefx-woocommerce/trunk/settings/backend.php

@@ -180 +180 @@
           </tr>
           <?php } break;
-        // Type of Invoice
+        // Type of Invoice PT
         case 'typeOfInvoice':
+          if($_SESSION['username'] != '' && $settings['backend']['createInvoice'] != ''){ ?>
+          <tr>
+            <th scope="row">
+              <label for="<?php echo $id ?>"><?php echo $opts['label'] ?></label>
+            </th>
+            <td>
+              <select id="<?php echo $id ?>" name="<?php echo $name ?>">
+              <?php if(!empty($_SESSION[$id])){ ?>
+                <option value="0">Select one...</option>
+              <?php }
+              echo $_SESSION[$id]; ?>
+            </td>
+          </tr>
+          <?php } break;
+        case 'typeOf_EU_Invoice':
           if($_SESSION['username'] != '' && $settings['backend']['createInvoice'] != ''){ ?>
           <tr>

drivefx-woocommerce/trunk/settings/syncro_gate.php

@@ -1 +1 @@
 <?php
-
+require_once  __DIR__.'/../includes/class-wc-order-item-tax.php';
 require_once  __DIR__.'/../PHCLibrary/log.php';
 require_once  __DIR__.'/../PHCLibrary/utils.php';
@@ -22 +22 @@
     }
 
-    /*****************************************************************
-    *                      ---  CREDENTIALS ---                      *
+    /******************************************************************
+    *                      ---  CREDENTIALS ---                       *
     ******************************************************************/
-    public function fetchCredentials(){
-
-        $credentials = new stdClass();
-
-        $settings = get_option(DRIVEFXWOOCOMMERCE_PLUGIN_NAME);
-
-        // get token
-        global $wpdb;
-        $table_name = $wpdb->prefix."postmeta";
-        $query = "SELECT meta_value FROM %s WHERE meta_key = %s";
-        $resultDB = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, '_token')));
-
-        // build our web service full URL
-        $settings['backend']['url'] = rtrim($settings['backend']['url'], '/html/');
-        $settings['backend']['url'] = rtrim($settings['backend']['url'], '/html');
-        $settings['backend']['url'] = rtrim($settings['backend']['url'], '/');
-
-        // build credencials
-        $credentials->backendUrl = $settings['backend']['url'].$this->extraurl;
-        $credentials->userCode =  $settings['backend']['username'];
-        $credentials->password = $settings['backend']['password'];
-        $credentials->appId =   $resultDB->meta_value;
-        $credentials->company = $settings['backend']['dbname'];
-        $credentials->invoiceType = $settings['backend']['typeOfInvoice'];
-
-        return $credentials;
-
-    }
+        public function fetchCredentials(){
+
+            $credentials = new stdClass();
+
+            $settings = get_option(DRIVEFXWOOCOMMERCE_PLUGIN_NAME);
+
+            // get token
+            global $wpdb;
+            $table_name = $wpdb->prefix."postmeta";
+            $query = "SELECT meta_value FROM %s WHERE meta_key = %s";
+            $resultDB = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, '_token')));
+
+            // build our web service full URL
+            $settings['backend']['url'] = rtrim($settings['backend']['url'], '/html/');
+            $settings['backend']['url'] = rtrim($settings['backend']['url'], '/html');
+            $settings['backend']['url'] = rtrim($settings['backend']['url'], '/');
+
+            // build credencials
+            $credentials->backendUrl = $settings['backend']['url'].$this->extraurl;
+            $credentials->userCode =  $settings['backend']['username'];
+            $credentials->password = $settings['backend']['password'];
+            $credentials->appId =   $resultDB->meta_value;
+            $credentials->company = $settings['backend']['dbname'];
+            $credentials->invoiceType = $settings['backend']['typeOfInvoice'];
+            $credentials->invoiceType_EU = $settings['backend']['typeOf_EU_Invoice'];
+
+            return $credentials;
+
+        }
 
 
@@ -59 +60 @@
     *                     ---  Collect Data ---                       *
     *******************************************************************/
-    public function fetchOrderData($order_id) {
-        //get backendinfo from woocommerce
-        $settings = get_option(DRIVEFXWOOCOMMERCE_PLUGIN_NAME);
-
-        #Get billind data query
-        global $wpdb;
-        $table_name = $wpdb->prefix."postmeta";
-        $query = "SELECT meta_key, meta_value FROM %s where post_id = %d";
-        $raw_order = $wpdb->get_results(str_replace("'", "", $wpdb->prepare($query, $table_name, sanitize_text_field($order_id))));
-
-        //get NIF name field from backendinfo
-        $nifName = '_billing_'.$settings['backend']['fieldNif'];
-        //get price column field from backendinfo
-        $preco = intval(str_replace('epv', '', $settings['backend']['productPriceColumn']));
-
-        $syncroData = new stdClass();
-
-        /*******************************************************************
-        *                       --- billing data  ---                      *
-        ********************************************************************/
-
-            foreach ($raw_order as $key => $value) {
-                if($value->meta_key == '_billing_country'){
-                    $syncroData->billing_country = $value->meta_value;
-                }  else if($value->meta_key == '_billing_first_name') {
-                    $syncroData->billing_first_name = $value->meta_value;
-                } else if($value->meta_key == '_billing_last_name') {
-                    $syncroData->billing_last_name = $value->meta_value;
-                } else if($value->meta_key == '_billing_address_1') {
-                    $syncroData->billing_address_1 = $value->meta_value;
-                } else if($value->meta_key == '_billing_city') {
-                    $syncroData->billing_city = $value->meta_value;
-                } else if($value->meta_key == '_billing_postcode') {
-                    $syncroData->billing_postcode = $value->meta_value;
-                } else if($value->meta_key == $nifName) {
-                    $syncroData->$nifName = $value->meta_value;
-                } else if($value->meta_key == '_billing_email') {
-                    $syncroData->billing_email = $value->meta_value;
-                } else if($value->meta_key == '_billing_phone') {
-                    $syncroData->billing_phone = $value->meta_value;
-                } else if($value->meta_key == '_shipping_country') {
-                    $syncroData->shipping_country = $value->meta_value;
-                } else if($value->meta_key == '_shipping_address_1') {
-                    $syncroData->shipping_address_1 = $value->meta_value;
-                } else if($value->meta_key == '_shipping_city') {
-                    $syncroData->shipping_city = $value->meta_value;
-                } else if($value->meta_key == '_shipping_postcode') {
-                    $syncroData->shipping_postcode = $value->meta_value;
-                } else if($value->meta_key == '_customer_user') {
-                    $syncroData->customer_user = $value->meta_value;
-                }
-            }
-
-        /*******************************************************************
-        *                 --- settings backend Data  ---                   *
-        ********************************************************************/
-
-            if(isset($settings['backend']['createInvoice'])){
-                $createInvoice = $settings['backend']['createInvoice'];
-                if($createInvoice == 'on'){
-                    $syncroData->createInvoice = true;
-                }
-            }
-            if(isset($settings['backend']['typeOfInvoice'])) {
-                $syncroData->typeOfInvoice = $settings['backend']['typeOfInvoice'];
-            }
-            if(isset($settings['backend']['toSignInvoice'])) {
-                $toSignInvoice = $settings['backend']['toSignInvoice'];
-                if($toSignInvoice == 'on'){
-                    $syncroData->toSignInvoice = true;
-                }
-            }
-            if(isset($settings['backend']['fieldNif'])) {
-                $syncroData->fieldNif = $settings['backend']['fieldNif'];
-            }
-            if(isset($settings['backend']['includeTaxonSendCost'])) {
-                $syncroData->includeTaxonSendCost = $settings['backend']['includeTaxonSendCost'];
-            }
-            if(isset($settings['backend']['createExemptPT'])) {
-                $createExemptPT = $settings['backend']['createExemptPT'];
-                if($createExemptPT == 'on'){
-                    $syncroData->createExemptPT = true;
-                }
-            }
-            if(isset($settings['backend']['createExemptEU'])) {
-                $createExemptEU = $settings['backend']['createExemptEU'];
-                if($createExemptEU == 'on'){
-                    $syncroData->createExemptEU = true;
-                }
-            }
-            if(isset($settings['backend']['createExemptCO'])) {
-                $createExemptCO = $settings['backend']['createExemptCO'];
-                if($createExemptCO == 'on'){
-                    $syncroData->createExemptCO = true;
-                }
-            }
-            if(isset($settings['backend']['typeOfCountry'])) {
-                $syncroData->typeOfCountry = $settings['backend']['typeOfCountry'];
-            }
-            if(isset($settings['backend']['typeOfReason'])) {
-                $syncroData->typeOfReason = $settings['backend']['typeOfReason'];
-            }
-            if(isset($settings['backend']['typeOfReasonEU'])) {
-                $syncroData->typeOfReasonEU = $settings['backend']['typeOfReasonEU'];
-            }
-            if(isset($settings['backend']['typeOfReasonCO'])) {
-                $syncroData->typeOfReasonCO = $settings['backend']['typeOfReasonCO'];
-            }
-            if(isset($settings['backend']['warehouseOrder'])) {
-                $syncroData->warehouseOrder = $settings['backend']['warehouseOrder'];
-            }
-            if(isset($settings['backend']['typeOfOrder'])) {
-                $syncroData->typeOfOrder = $settings['backend']['typeOfOrder'];
-            }
-            if(isset($settings['backend']['toSignOrder'])) {
-                $toSignOrder = $settings['backend']['toSignOrder'];
-                if($toSignOrder == 'on'){
-                    $syncroData->toSignOrder = true;
-                }
-            }
-            if(isset($settings['backend']['numberOfOrder'])) {
-                $syncroData->numberOfOrder = $settings['backend']['numberOfOrder'];
-            }
-            if(isset($settings['backend']['statusOfOrder'])) {
-                $syncroData->statusOfOrder = $settings['backend']['statusOfOrder'];
-            }
-            if(isset($settings['backend']['shippingName'])) {
-                $syncroData->shippingName = $settings['backend']['shippingName'];
-            }
-            if(isset($settings['backend']['feesName'])) {
-                $syncroData->feesName = $settings['backend']['feesName'];
-            }
-            if(isset($settings['backend']['manageStock'])) {
-                $manageStock = $settings['backend']['manageStock'];
-                if($manageStock == 'on'){
-                    $syncroData->manageStock = true;
-                }
-            }
-            if(isset($settings['backend']['productPriceColumn'])) {
-                $syncroData->productPriceColumn = $preco;
-            }
-            if(isset($settings['backend']['warehouse'])) {
-                $syncroData->warehouse = $settings['backend']['warehouse'];
-            }
-            if(isset($settings['backend']['sendInvoice'])) {
-                $syncroData->sendInvoice = $settings['backend']['sendInvoice'];
-            }
-
-
-        /*******************************************************************
-        *                        --- Users Data  ---                       *
-        ********************************************************************/
-            #Get users data query
-            //Obtain customer ID to obtain email in Woocommerce Users
-            global $wpdb;
-            $table_name = $wpdb->prefix."users";
-            //Obtain next post_id of order in MySQL
-            $query = "SELECT user_email FROM %s WHERE id = %d";
-            $docid = $wpdb->get_results(str_replace("'", "", $wpdb->prepare($query, $table_name, sanitize_text_field($syncroData->customer_user))));
-            $syncroData->user_email  = $docid[0]->user_email;
-
-            #Get POST Id for current order
+        public function fetchOrderData($order_id) {
+            //get backendinfo from woocommerce
+            $settings = get_option(DRIVEFXWOOCOMMERCE_PLUGIN_NAME);
+
+            #Get billind data query
             global $wpdb;
             $table_name = $wpdb->prefix."postmeta";
-            //Obtain post_id of order in MySQL
-            $query = "SELECT MAX(post_id) as postId FROM %s";
-            $post_docid = $wpdb->get_row(str_replace("'", "", $wpdb->prepare($query, $table_name)));
-            //Post Id
-            $syncroData->post_ID = sanitize_text_field($post_docid->postId);
-
-            if($syncroData->post_ID == ''){
-                $post_ID = sanitize_text_field($order_id);
-            }
-
-                //Obtain doc ID based in order
-                $docid = get_post_meta($syncroData->post_ID);
-
-                $syncroData->docId = $docid['_docid'][0];
-                $syncroData->orderId = sanitize_text_field($order_id);
-
-            #Customer notes
-            $syncroData->obs = $_REQUEST['order_comments'];
-
-            #Get Currency from woocommerce
-            $syncroData->wooCurrency = get_option('woocommerce_currency');
-
-            #get order received endpoint from woocommerce
-            $syncroData->order_received = get_option('woocommerce_checkout_order_received_endpoint');
-
-
-            #nextPostId
-            global $wpdb;
-            $table_name = $wpdb->prefix."postmeta";
-            //Obtain next post_id of order in MySQL
-            $query = "SELECT MAX(post_id) as nextPostId FROM %s";
-            $packDocId = $wpdb->get_row(str_replace("'", "", $wpdb->prepare($query, $table_name)));
-
-            //Save nextPostId
-            $syncroData->nextPostId = $packDocId->nextPostId;
-
-        /*******************************************************************
-        *                  --- Order Shipping Data  ---                     *
-        ********************************************************************/
-
-            # shipping data (Queries)
-
-            $table_name = $wpdb->prefix."woocommerce_order_items";
-            $query = "SELECT * FROM %s WHERE order_id = %s and order_item_type = 'shipping'";
-            $resultShipping = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $packDocId->nextPostId)));
-            //get tax value for shipping
-            $table_name = $wpdb->prefix."woocommerce_order_itemmeta";
-            $query = "SELECT * FROM %s WHERE order_item_id = %s and meta_key = 'total_tax'";
-            $resultTax = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $resultShipping->order_item_id)));
-            //get shipping tax rate
-            $getShippingTax = $wpdb->get_var( $wpdb->prepare( "SELECT tax_rate FROM ".$wpdb->prefix."woocommerce_tax_rates WHERE tax_rate_shipping='1'" ) );
-            //get shipping tax rate country
-            //$getShippingCountry = $wpdb->get_var( $wpdb->prepare( "SELECT tax_rate_country FROM ".$wpdb->prefix."woocommerce_tax_rates WHERE tax_rate_shipping='1'" ) );
-            //get value
-            $table_name = $wpdb->prefix."woocommerce_order_itemmeta";
-            $query = "SELECT * FROM %s WHERE order_item_id = %s and meta_key = 'cost'";
-            $resultDB = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $resultShipping->order_item_id)));
-
-
-            # Fetch shipping data
-
-            if(isset($resultShipping)) {
-                $syncroData->shipping_name = $resultShipping->order_item_name;
-            }
-            if(isset($resultTax)) {
-                $syncroData->shipping_taxValue = $resultTax->meta_value;
-            }
-            if(isset($getShippingTax)) {
-                $syncroData->shipping_tax = $getShippingTax;
-            }
-           /*  if(isset($getShippingCountry)) {
-                $syncroData->shipping_country = $getShippingCountry;
-            } */
-            if(isset($resultDB)) {
-                $syncroData->shipping_value = $resultDB->meta_value;
-            }
-
-            #Find the type of shipment
-            $post = get_post( $_REQUEST['shipping_method'][0] );
-
-            $syncroData->post_title = isset( $post->post_title ) ? $post->post_title : '';
-            $syncroData->edescc = WC()->cart->coupon_discount_amounts['saco'];
-
-
-
-        /*******************************************************************
-        *                    --- Order Fees Data  ---                      *
-        ********************************************************************/
-            //build common object
-            $boFeesPack = new stdClass();
-            $bofees = [];
-
-            # fees data (Queries)
-
-            //get fee from mysql
-            $table_name = $wpdb->prefix."woocommerce_order_items";
-            $query = "SELECT * FROM %s WHERE order_id = %s and order_item_type = 'fee'";
-            $resultsFee_bo = $wpdb->get_results(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $packDocId->nextPostId)));
-            //get fee value from mysql
-            $table_name = $wpdb->prefix."woocommerce_order_itemmeta";
-            $query = "SELECT * FROM %s WHERE order_item_id = %s and meta_key = '_line_total'";
-
-             #Obtain name and price of fees
-             foreach ($resultsFee_bo as $resultFee_bo) {
-                $resulBoDB = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $resultFee_bo->order_item_id)));
-
-                    $boFee_name = $resultFee_bo->order_item_name;
-                    $boFee_value = $resulBoDB->meta_value;
-
-                array_push($bofees,[
-                'name' =>  $boFee_name,
-                'value' =>  $boFee_value
-            ]);
-
-            }
-            $boFeesPack = $bofees;
-            $syncroData->fees_bo = $boFeesPack;
-
-            # Fetch fees data
-
-            if(isset($resultFee)) {
-                $syncroData->fee_name = $resultFee->order_item_name;
-            }
-            if(isset($resultFeeValue)) {
-                $syncroData->fee_value = $resultFeeValue->meta_value;
-            }
-
-
-
-        /*******************************************************************
-        *                      --- Invoice Data  ---                       *
-        ********************************************************************/
-
-            #get country for Ft
-            $order_meta = get_post_meta($order_id);
-
-            $syncroData->$bill_country_ft = $order_meta['_billing_country'][0];
-
-            if($syncroData->billing_country != ''){
-                $syncroData->billing_country_ft = $syncroData->billing_country;
-            } else {
-                $syncroData->billing_country_ft = sanitize_text_field( $_REQUEST['_billing_country'] );
-            }
-
-            #get Billing data
-            $syncroData->billing_first_name_ft = $order_meta['_billing_first_name'][0];
-            $syncroData->billing_last_name_ft = $order_meta['_billing_last_name'][0];
-            $syncroData->billing_email_ft = $order_meta['_billing_email'][0];
-            $syncroData->billing_address_1_ft = $order_meta['_billing_address_1'][0];
-            $syncroData->billing_city_ft = $order_meta['_billing_city'][0];
-            $syncroData->billing_phone_ft = $order_meta['_billing_phone'][0];
-            $syncroData->billing_postcode_ft = $order_meta['_billing_postcode'][0];
-            $syncroData->billing_nif_ft = $order_meta['_billing_'.$settings['backend']['fieldNif']][0];
-
-
-        /*******************************************************************
-        *                 --- Invoice Shipping Data  ---                   *
-        ********************************************************************/
-            //Obtain id of order and products
-            $order = new WC_Order($orderid);
-            $syncroData->nOrder = $order->post->ID;
-
-            # shipping data (Queries)
-            global $wpdb;
-            $table_name = $wpdb->prefix."woocommerce_order_items";
-            $query = "SELECT * FROM %s WHERE order_id = %s and order_item_type = 'shipping'";
-            $resultsFtShipping = $wpdb->get_results(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $syncroData->nOrder)));
-
-            $table_name = $wpdb->prefix."woocommerce_order_itemmeta";
-            $query = "SELECT * FROM %s WHERE order_item_id = %s and meta_key = 'cost'";
-            //Obtain name and price of delivery
-            foreach ($resultsFtShipping as $resultFtShipping) {
-                $resultFtDB = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $resultFtShipping->order_item_id)));
-
-                $syncroData->ftShipping_name = $resultFtShipping->order_item_name;
-                $syncroData->ftShipping_value = $resultFtDB->meta_value;
-            }
-
-            #get shipping country for ft
-            if($syncroData->shipping_country != ''){
-                $syncroData->shipping_country_ft = $syncroData->shipping_country;
-            } else {
-                $syncroData->shipping_country_ft =  $order_meta['_shipping_country'][0];
-                if($syncroData->shipping_country_ft == ''){
-                    $syncroData->shipping_country_ft = $syncroData->$bill_country_ft;
-                }
-            }
-
-        /*******************************************************************
-        *            --- Invoice Addicional Fees Data  ---                 *
-        ********************************************************************/
-
-            //Obtain id of order and products
-            $order = new WC_Order($orderid);
-            $orderPostId = $order->post->ID;
-            //build common object
-            $addPack = new stdClass();
-            $fees = [];
-
-            # fees data (Queries)
-            global $wpdb;
-            $table_name = $wpdb->prefix."woocommerce_order_items";
-            $query = "SELECT * FROM %s WHERE order_id = %s and  order_item_type='fee'";
-            $resultsFees_ft = $wpdb->get_results(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $orderPostId)));
-
-            $table_name = $wpdb->prefix."woocommerce_order_itemmeta";
-            $query = "SELECT * FROM %s WHERE order_item_id = %s and (meta_key = 'cost' or meta_key='_line_total')";
-
-            #Obtain name and price of fees
-            foreach ($resultsFees_ft as $resultFees_ft) {
-                $resultFtDB = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $resultFees_ft->order_item_id)));
-
-                    $fee_name = $resultFees_ft->order_item_name;
-                    $fee_value = $resultFtDB->meta_value;
-
-                array_push($fees,[
-                'name' =>  $fee_name,
-                'value' =>  $fee_value
-            ]);
-
-            }
-
-            $addPack = $fees;
-            $syncroData->fees_ft = $addPack;
-
-        //$this->logs->writeFileLog('syncroData', $syncroData);
-
-        return $syncroData;
-    }
+            $query = "SELECT meta_key, meta_value FROM %s where post_id = %d";
+            $raw_order = $wpdb->get_results(str_replace("'", "", $wpdb->prepare($query, $table_name, sanitize_text_field($order_id))));
+
+            //$this->logs->writeFileLog('raw_order', $raw_order);
+
+            //get NIF name field (billing) from backendinfo
+            $ft_nifName = '_billing_'.$settings['backend']['fieldNif'];
+
+            //get NIF name field (shipping) from backendinfo
+            $ship_nifName = '_shipping_'.$settings['backend']['fieldNif'];
+
+            //get price column field from backendinfo
+            $preco = intval(str_replace('epv', '', $settings['backend']['productPriceColumn']));
+
+            $syncroData = new stdClass();
+
+            /*******************************************************************
+            *                       --- billing data  ---                      *
+            ********************************************************************/
+
+                foreach ($raw_order as $key => $value) {
+                    if($value->meta_key == '_billing_country'){
+                        $syncroData->billing_country = $value->meta_value;
+                    }  else if($value->meta_key == '_billing_first_name') {
+                        $syncroData->billing_first_name = $value->meta_value;
+                    } else if($value->meta_key == '_billing_last_name') {
+                        $syncroData->billing_last_name = $value->meta_value;
+                    } else if($value->meta_key == '_billing_address_1') {
+                        $syncroData->billing_address_1 = $value->meta_value;
+                    } else if($value->meta_key == '_billing_city') {
+                        $syncroData->billing_city = $value->meta_value;
+                    } else if($value->meta_key == '_billing_postcode') {
+                        $syncroData->billing_postcode = $value->meta_value;
+                    } else if($value->meta_key == $ft_nifName) {
+                        $syncroData->ft_nifName = $value->meta_value;
+                    } else if($value->meta_key == '_billing_email') {
+                        $syncroData->billing_email = $value->meta_value;
+                    } else if($value->meta_key == '_billing_phone') {
+                        $syncroData->billing_phone = $value->meta_value;
+                    } else if($value->meta_key == '_shipping_country') {
+                        $syncroData->shipping_country = $value->meta_value;
+                    }  else if($value->meta_key == '_shipping_first_name') {
+                        $syncroData->shipping_first_name = $value->meta_value;
+                    } else if($value->meta_key == '_shipping_last_name') {
+                        $syncroData->shipping_last_name = $value->meta_value;
+                    } else if($value->meta_key == $ship_nifName) {
+                        $syncroData->ship_nifName = $value->meta_value;
+                    } else if($value->meta_key == '_shipping_address_1') {
+                        $syncroData->shipping_address_1 = $value->meta_value;
+                    } else if($value->meta_key == '_shipping_city') {
+                        $syncroData->shipping_city = $value->meta_value;
+                    } else if($value->meta_key == '_shipping_postcode') {
+                        $syncroData->shipping_postcode = $value->meta_value;
+                    } else if($value->meta_key == '_customer_user') {
+                        $syncroData->customer_user = $value->meta_value;
+                    }
+                }
+
+            /*******************************************************************
+            *                 --- settings backend Data  ---                   *
+            ********************************************************************/
+
+                if(isset($settings['backend']['createInvoice'])){
+                    $createInvoice = $settings['backend']['createInvoice'];
+                    if($createInvoice == 'on'){
+                        $syncroData->createInvoice = true;
+                    }
+                }
+                if(isset($settings['backend']['typeOfInvoice'])) {
+                    $syncroData->typeOfInvoice = $settings['backend']['typeOfInvoice'];
+                }
+                if(isset($settings['backend']['typeOf_EU_Invoice'])) {
+                    $syncroData->typeOf_EU_Invoice = $settings['backend']['typeOf_EU_Invoice'];
+                }
+                if(isset($settings['backend']['toSignInvoice'])) {
+                    $toSignInvoice = $settings['backend']['toSignInvoice'];
+                    if($toSignInvoice == 'on'){
+                        $syncroData->toSignInvoice = true;
+                    }
+                }
+                if(isset($settings['backend']['fieldNif'])) {
+                    $syncroData->fieldNif = $settings['backend']['fieldNif'];
+                }
+                if(isset($settings['backend']['includeTaxonSendCost'])) {
+                    $syncroData->includeTaxonSendCost = $settings['backend']['includeTaxonSendCost'];
+                }
+                if(isset($settings['backend']['createExemptPT'])) {
+                    $createExemptPT = $settings['backend']['createExemptPT'];
+                    if($createExemptPT == 'on'){
+                        $syncroData->createExemptPT = true;
+                    }
+                }
+                if(isset($settings['backend']['createExemptEU'])) {
+                    $createExemptEU = $settings['backend']['createExemptEU'];
+                    if($createExemptEU == 'on'){
+                        $syncroData->createExemptEU = true;
+                    }
+                }
+                if(isset($settings['backend']['createExemptCO'])) {
+                    $createExemptCO = $settings['backend']['createExemptCO'];
+                    if($createExemptCO == 'on'){
+                        $syncroData->createExemptCO = true;
+                    }
+                }
+                if(isset($settings['backend']['typeOfCountry'])) {
+                    $syncroData->typeOfCountry = $settings['backend']['typeOfCountry'];
+                }
+                if(isset($settings['backend']['typeOfReason'])) {
+                    $syncroData->typeOfReason = $settings['backend']['typeOfReason'];
+                }
+                if(isset($settings['backend']['typeOfReasonEU'])) {
+                    $syncroData->typeOfReasonEU = $settings['backend']['typeOfReasonEU'];
+                }
+                if(isset($settings['backend']['typeOfReasonCO'])) {
+                    $syncroData->typeOfReasonCO = $settings['backend']['typeOfReasonCO'];
+                }
+                if(isset($settings['backend']['warehouseOrder'])) {
+                    $syncroData->warehouseOrder = $settings['backend']['warehouseOrder'];
+                }
+                if(isset($settings['backend']['typeOfOrder'])) {
+                    $syncroData->typeOfOrder = $settings['backend']['typeOfOrder'];
+                }
+                if(isset($settings['backend']['toSignOrder'])) {
+                    $toSignOrder = $settings['backend']['toSignOrder'];
+                    if($toSignOrder == 'on'){
+                        $syncroData->toSignOrder = true;
+                    }
+                }
+                if(isset($settings['backend']['numberOfOrder'])) {
+                    $syncroData->numberOfOrder = $settings['backend']['numberOfOrder'];
+                }
+                if(isset($settings['backend']['statusOfOrder'])) {
+                    $syncroData->statusOfOrder = $settings['backend']['statusOfOrder'];
+                }
+                if(isset($settings['backend']['shippingName'])) {
+                    $syncroData->shippingName = $settings['backend']['shippingName'];
+                }
+                if(isset($settings['backend']['feesName'])) {
+                    $syncroData->feesName = $settings['backend']['feesName'];
+                }
+                if(isset($settings['backend']['manageStock'])) {
+                    $manageStock = $settings['backend']['manageStock'];
+                    if($manageStock == 'on'){
+                        $syncroData->manageStock = true;
+                    }
+                }
+                if(isset($settings['backend']['productPriceColumn'])) {
+                    $syncroData->productPriceColumn = $preco;
+                }
+                if(isset($settings['backend']['warehouse'])) {
+                    $syncroData->warehouse = $settings['backend']['warehouse'];
+                }
+                if(isset($settings['backend']['sendInvoice'])) {
+                    $syncroData->sendInvoice = $settings['backend']['sendInvoice'];
+                }
+
+
+            /*******************************************************************
+            *                   --- Company/Users Data  ---                    *
+            ********************************************************************/
+                #Get users data query
+                //Obtain customer ID to obtain email in Woocommerce Users
+                global $wpdb;
+                $table_name = $wpdb->prefix."users";
+                //Obtain next post_id of order in MySQL
+                $query = "SELECT user_email FROM %s WHERE id = %d";
+                $docid = $wpdb->get_results(str_replace("'", "", $wpdb->prepare($query, $table_name, sanitize_text_field($syncroData->customer_user))));
+                $syncroData->user_email  = $docid[0]->user_email;
+
+                #Get POST Id for current order
+                global $wpdb;
+                $table_name = $wpdb->prefix."postmeta";
+                //Obtain post_id of order in MySQL
+                $query = "SELECT MAX(post_id) as postId FROM %s";
+                $post_docid = $wpdb->get_row(str_replace("'", "", $wpdb->prepare($query, $table_name)));
+                //Post Id
+                $syncroData->post_ID = sanitize_text_field($post_docid->postId);
+
+                if($syncroData->post_ID == ''){
+                    $post_ID = sanitize_text_field($order_id);
+                }
+
+                    //Obtain doc ID based in order
+                    $docid = get_post_meta($syncroData->post_ID);
+
+                    $syncroData->docId = $docid['_docid'][0];
+                    $syncroData->orderId = sanitize_text_field($order_id);
+
+                #Customer notes
+                $syncroData->obs = $_REQUEST['order_comments'];
+
+                #Get Currency from woocommerce
+                $syncroData->wooCurrency = get_option('woocommerce_currency');
+
+                #get order received endpoint from woocommerce
+                $syncroData->order_received = get_option('woocommerce_checkout_order_received_endpoint');
+
+                #get company country from woocommerce
+                $syncroData->companyCountry = WC()->countries->countries[WC()->countries->get_base_country()];
+
+                #get order tax rate country
+                $getTaxName = $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM ".$wpdb->prefix."woocommerce_order_itemmeta WHERE meta_key='label' ORDER BY order_item_id DESC " ) );
+                $syncroData->taxCountry = $wpdb->get_var( $wpdb->prepare( "SELECT tax_rate_country FROM ".$wpdb->prefix."woocommerce_tax_rates WHERE tax_rate_name='".$getTaxName."' LIMIT 1" ) );
+
+                #nextPostId
+                global $wpdb;
+                $table_name = $wpdb->prefix."postmeta";
+                //Obtain next post_id of order in MySQL
+                $query = "SELECT MAX(post_id) as nextPostId FROM %s";
+                $packDocId = $wpdb->get_row(str_replace("'", "", $wpdb->prepare($query, $table_name)));
+
+                //Save nextPostId
+                $syncroData->nextPostId = $packDocId->nextPostId;
+
+            /*******************************************************************
+            *                  --- Order Shipping Data  ---                     *
+            ********************************************************************/
+
+                # shipping data (Queries)
+
+                $table_name = $wpdb->prefix."woocommerce_order_items";
+                $query = "SELECT * FROM %s WHERE order_id = %s and order_item_type = 'shipping'";
+                $resultShipping = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $packDocId->nextPostId)));
+                //get tax value for shipping
+                $table_name = $wpdb->prefix."woocommerce_order_itemmeta";
+                $query = "SELECT * FROM %s WHERE order_item_id = %s and meta_key = 'total_tax'";
+                $resultTax = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $resultShipping->order_item_id)));
+                //get shipping tax value
+                $table_name = $wpdb->prefix."woocommerce_order_itemmeta";
+                $query = "SELECT * FROM %s WHERE order_item_id = %s and meta_key = 'cost'";
+                $resultDB = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $resultShipping->order_item_id)));
+
+                #Shipping Tax Rate
+                $shipping_tax_rate_id;
+                foreach ( WC()->shipping->get_packages() as $key => $package) {
+                    // Loop through Shipping rates
+                    foreach($package['rates'] as $rate_id => $rate ){
+                        // get shipping taxes array
+                        $shipping_taxes = $rate->get_taxes();
+
+                        foreach ($shipping_taxes as $key => $value){
+                            if(!empty($value)){
+                                // get shipping tax rate ID
+                                $shipping_tax_rate_id = $key;
+                            }
+                        }
+                    }
+                }
+
+                if(!empty($shipping_tax_rate_id)){
+                    // order shipping tax rate
+                    $getShippingTax = $wpdb->get_var( $wpdb->prepare( "SELECT tax_rate FROM ".$wpdb->prefix."woocommerce_tax_rates WHERE tax_rate_id='".$shipping_tax_rate_id."' LIMIT 1"));
+                } else {
+                    //$this->logs->writeFileLog('Warning', 'Can not obtain the tax rate ID for shipping, so we apply manual calculation');
+                }
+
+                # Fetch shipping data
+                if(isset($resultShipping)) {
+                    $syncroData->shipping_name = $resultShipping->order_item_name;
+                }
+                if(isset($resultTax)) {
+                    $syncroData->shipping_taxValue = $resultTax->meta_value;
+                }
+                if(isset($getShippingTax)) {
+                    $syncroData->shipping_tax = $getShippingTax;
+                } else {
+                    $syncroData->shipping_tax = $syncroData->shipping_taxValue / $resultDB->meta_value * 100;
+                }
+                if($settings['backend']['includeTaxonSendCost']=="true"){
+                    if(isset($resultDB)) {
+                        $syncroData->shipping_value = $resultDB->meta_value + $resultTax->meta_value;
+                    }
+                } else {
+                    if(isset($resultDB)) {
+                        $syncroData->shipping_value = $resultDB->meta_value;
+                    }
+                }
+
+
+                #Find the type of shipment
+                $post = get_post( $_REQUEST['shipping_method'][0] );
+
+                $syncroData->post_title = isset( $post->post_title ) ? $post->post_title : '';
+                $syncroData->edescc = WC()->cart->coupon_discount_amounts['saco'];
+
+
+            /*******************************************************************
+            *                    --- Order Fees Data  ---                      *
+            ********************************************************************/
+                //build common object
+                $boFeesPack = new stdClass();
+                $bofees = [];
+
+                # fees data (Queries)
+
+                //get fee from mysql
+                $table_name = $wpdb->prefix."woocommerce_order_items";
+                $query = "SELECT * FROM %s WHERE order_id = %s and order_item_type = 'fee'";
+                $resultsFee_bo = $wpdb->get_results(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $packDocId->nextPostId)));
+                //get fee value from mysql
+                $table_name = $wpdb->prefix."woocommerce_order_itemmeta";
+                $query = "SELECT * FROM %s WHERE order_item_id = %s and meta_key = '_line_total'";
+
+                #Obtain name and price of fees
+                foreach ($resultsFee_bo as $resultFee_bo) {
+                    $resulBoDB = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $resultFee_bo->order_item_id)));
+
+                        $boFee_name = $resultFee_bo->order_item_name;
+                        $boFee_value = $resulBoDB->meta_value;
+
+                    array_push($bofees,[
+                    'name' =>  $boFee_name,
+                    'value' =>  $boFee_value
+                ]);
+
+                }
+                $boFeesPack = $bofees;
+                $syncroData->fees_bo = $boFeesPack;
+
+                # Fetch fees data
+
+                if(isset($resultFee)) {
+                    $syncroData->fee_name = $resultFee->order_item_name;
+                }
+                if(isset($resultFeeValue)) {
+                    $syncroData->fee_value = $resultFeeValue->meta_value;
+                }
+
+
+
+            /*******************************************************************
+            *                      --- Invoice Data  ---                       *
+            ********************************************************************/
+
+                #get country for Ft
+                $order_meta = get_post_meta($order_id);
+
+                $syncroData->$bill_country_ft = $order_meta['_billing_country'][0];
+
+                if($syncroData->billing_country != ''){
+                    $syncroData->billing_country_ft = $syncroData->billing_country;
+                } else {
+                    $syncroData->billing_country_ft = sanitize_text_field( $_REQUEST['_billing_country'] );
+                }
+
+                #get Billing data
+                $syncroData->billing_first_name_ft = $order_meta['_billing_first_name'][0];
+                $syncroData->billing_last_name_ft = $order_meta['_billing_last_name'][0];
+                $syncroData->billing_email_ft = $order_meta['_billing_email'][0];
+                $syncroData->billing_address_1_ft = $order_meta['_billing_address_1'][0];
+                $syncroData->billing_city_ft = $order_meta['_billing_city'][0];
+                $syncroData->billing_phone_ft = $order_meta['_billing_phone'][0];
+                $syncroData->billing_postcode_ft = $order_meta['_billing_postcode'][0];
+                $syncroData->billing_nif_ft = $order_meta['_billing_'.$settings['backend']['fieldNif']][0];
+
+
+            /*******************************************************************
+            *                 --- Invoice Shipping Data  ---                   *
+            ********************************************************************/
+
+                /* To avoid repetitive code,
+                                   data is taken from "Order Shipping Data" */
+
+            /*******************************************************************
+            *            --- Invoice Addicional Fees Data  ---                 *
+            ********************************************************************/
+
+                //Obtain id of order and products
+                $order = new WC_Order($orderid);
+                $orderPostId = $order->post->ID;
+                //build common object
+                $addPack = new stdClass();
+                $fees = [];
+
+                # fees data (Queries)
+                global $wpdb;
+                $table_name = $wpdb->prefix."woocommerce_order_items";
+                $query = "SELECT * FROM %s WHERE order_id = %s and  order_item_type='fee'";
+                $resultsFees_ft = $wpdb->get_results(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $orderPostId)));
+
+                $table_name = $wpdb->prefix."woocommerce_order_itemmeta";
+                $query = "SELECT * FROM %s WHERE order_item_id = %s and (meta_key = 'cost' or meta_key='_line_total')";
+
+                #Obtain name and price of fees
+                foreach ($resultsFees_ft as $resultFees_ft) {
+                    $resultFtDB = $wpdb->get_row(str_replace("'".$table_name."'", $table_name, $wpdb->prepare($query, $table_name, $resultFees_ft->order_item_id)));
+
+                        $fee_name = $resultFees_ft->order_item_name;
+                        $fee_value = $resultFtDB->meta_value;
+
+                    array_push($fees,[
+                    'name' =>  $fee_name,
+                    'value' =>  $fee_value
+                ]);
+
+                }
+
+                $addPack = $fees;
+                $syncroData->fees_ft = $addPack;
+
+            //$this->logs->writeFileLog('syncroData', $syncroData);
+
+            return $syncroData;
+        }
 
     /*******************************************************************
@@ -546 +565 @@
                     $product['design'] = $wc_product->get_name();
 
-
-                    # get product tax rate country & order tax rate
-                    // product id
-                    $getProductId = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_sku' AND meta_value='%s' LIMIT 1", $product['ref'] ) );
-                    // product From id
-                    $getProduct = wc_get_product($getProductId);
-                    // product tax rate country
-                    $getTaxCountry = $wpdb->get_var( $wpdb->prepare( "SELECT tax_rate_country FROM ".$wpdb->prefix."woocommerce_tax_rates WHERE tax_rate_class='%s' LIMIT 1", $getProduct->get_tax_class() ) );
-                    // order tax rate
-                    $getTaxOrder = $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM ".$wpdb->prefix."woocommerce_order_itemmeta WHERE meta_key='rate_percent' ORDER BY order_item_id DESC " ) );
+                    // order tax rate country
+                    $getTaxID = $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM ".$wpdb->prefix."woocommerce_order_itemmeta WHERE meta_key='rate_id' ORDER BY order_item_id DESC  LIMIT 1" ) );
+                    $getTaxCountry = $wpdb->get_var( $wpdb->prepare( "SELECT tax_rate_country FROM ".$wpdb->prefix."woocommerce_tax_rates WHERE tax_rate_id='".$getTaxID."' LIMIT 1" ) );
+
+                    //order Item ID
+                    $getOrderItemID = $wpdb->get_var( $wpdb->prepare("SELECT order_item_id FROM ".$wpdb->prefix."woocommerce_order_items WHERE order_item_name ='".$product['design']."' and order_item_type = 'line_item' and order_id = '".$orderid."' LIMIT 1" ) );
+                    //order Item product by order Item ID
+                    $item = new WC_Order_Item_Product($getOrderItemID);
+
+                    //$this->logs->writeFileLog('item', $item);
+
+                    // The product name
+                    $item_name = $item->get_name();
+
+                    if($item_name == $product['design']){
+                        //get taxes array for item
+                        $taxes = $item->get_taxes();
+                        $taxes_total = $taxes['total'];
+
+                       foreach ($taxes_total as $key => $value){
+                            if(isset($value)){
+                                // get tax rate ID
+                                $tax_rate_id = $key;
+                            }
+                        }
+
+                        if(!empty($tax_rate_id)){
+                            // order item tax rate
+                            $getTaxOrder = $wpdb->get_var( $wpdb->prepare( "SELECT tax_rate FROM ".$wpdb->prefix."woocommerce_tax_rates WHERE tax_rate_id='".$tax_rate_id."' LIMIT 1"));
+                        } else {
+                            $this->logs->writeFileLog('Warning', 'check the way to obtain the tax rate for items');
+                        }
+                    } else {
+                        $this->logs->writeFileLog('Warning', 'problem to find the products for check tax rates');
+                    }
 
                     if (isset($getTaxCountry)){
                         $product['tax_country'] = $getTaxCountry;
                     }
-                    if (isset($getTaxCountry)){
+                      if (isset($getTaxOrder)){
                         $product['tax_rate'] = $getTaxOrder;
                     }
                 }
             }
-
 
             //fulfill "prodpack" with all data
@@ -627 +670 @@
                     'epv' => $valueItem,
                     'design' => '',
-                    'etiliquido' => ''
+                    'etiliquido' => '',
+                    'tax_country' => '',
+                    'tax_rate' => ''
                 ]);
             }
             //Save items of cart
             $this->setFtProductsSession($ftProducts);
-
 
             //FT from Backend if is clicked "button tip"
@@ -653 +697 @@
                         'design' => '',
                         'etiliquido' => '',
-
+                        'tax_country' => '',
+                        'tax_rate' => ''
                     ]);
                 }
@@ -663 +708 @@
             foreach ($ftProducts as &$product) {
                 if($product['qtt']*$product['epv'] != 0){
-                # get product ref & design
-                global $wpdb;
+                    # get product ref & design
+                    global $wpdb;
                     $product_id = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_sku' AND meta_value='%s' LIMIT 1", $product['ref']));
                     $getproducttype = wc_get_product($product_id);
@@ -676 +721 @@
 
                     $product['design'] = $wc_prod->get_name();
+
+                    global $wpdb;
+                    // order tax rate country
+                    $getTaxID = $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM ".$wpdb->prefix."woocommerce_order_itemmeta WHERE meta_key='rate_id' ORDER BY order_item_id DESC  LIMIT 1" ) );
+                    $getTaxCountry = $wpdb->get_var( $wpdb->prepare( "SELECT tax_rate_country FROM ".$wpdb->prefix."woocommerce_tax_rates WHERE tax_rate_id='".$getTaxID."' LIMIT 1" ) );
+
+                    //order Item ID
+                    $getOrderItemID = $wpdb->get_var( $wpdb->prepare("SELECT order_item_id FROM ".$wpdb->prefix."woocommerce_order_items WHERE order_item_name ='".$product['design']."' and order_item_type = 'line_item' and order_id = '".$orderid."' LIMIT 1" ) );
+                    //order Item product by order Item ID
+                    $item = new WC_Order_Item_Product($getOrderItemID);
+
+                    //$this->logs->writeFileLog('item', $item);
+
+                    // The product name
+                    $item_name = $item->get_name();
+
+                    if($item_name == $product['design']){
+                        //get taxes array for item
+                        $taxes = $item->get_taxes();
+                        $taxes_total = $taxes['total'];
+
+                       foreach ($taxes_total as $key => $value){
+                            if(is_numeric($value)){
+                                // get tax rate ID
+                                $tax_rate_id = $key;
+                            }
+                        }
+                        // order item tax rate
+                        $getTaxProduct = $wpdb->get_var( $wpdb->prepare( "SELECT tax_rate FROM ".$wpdb->prefix."woocommerce_tax_rates WHERE tax_rate_id='".$tax_rate_id."' LIMIT 1"));
+                    }
+
+                    if (isset($getTaxCountry)){
+                        $product['tax_country'] = $getTaxCountry;
+                    }
+                    if (isset($getTaxProduct)){
+                        $product['tax_rate'] = $getTaxProduct;
+                    }
                 }
             }
@@ -690 +772 @@
                     $key++;
             }
-
             //fulfill "prodpack" with all data
             $ftproductPack = $ftProducts;
@@ -716 +797 @@
 
     /*******************************************************************
-    *                     ---  Object PackData ---                     *
+    *                    ---  Object PackData ---                       *
     ********************************************************************/
-    public function transformWcToPhcData($wooOrder, $prodPack, $ftprodPack) {
-
-        $dataPack = new stdClass();
-
-        $settings = new Settings();
-        $shop = new stdClass();
-        $bill = new Bill();
-        $shipping = new Shipping();
-        $customer = new Customer();
-        $order = new Order();
-        $ft = new Invoice();
-
-        #settings data
-        $settings->createInvoice = $wooOrder->createInvoice;
-        $settings->typeOfInvoice = $wooOrder->typeOfInvoice;
-        $settings->toSignInvoice = $wooOrder->toSignInvoice;
-        $settings->fieldNif = $wooOrder->fieldNif;
-        $settings->includeTaxonSendCost = $wooOrder->includeTaxonSendCost;
-        $settings->createExemptPT = $wooOrder->createExemptPT;
-        $settings->typeOfReason = $wooOrder->typeOfReason;
-        $settings->createExemptEU = $wooOrder->createExemptEU;
-        $settings->typeOfReasonEU = $wooOrder->typeOfReasonEU;
-        $settings->createExemptCO = $wooOrder->createExemptCO;
-        $settings->typeOfReasonCO = $wooOrder->typeOfReasonCO;
-        $settings->warehouseOrder = $wooOrder->warehouseOrder;
-        $settings->typeOfOrder = $wooOrder->typeOfOrder;
-        $settings->toSignOrder = $wooOrder->toSignOrder;
-        $settings->numberOfOrder = $wooOrder->numberOfOrder;
-        $settings->statusOfOrder = $wooOrder->statusOfOrder;
-        $settings->shippingName = $wooOrder->shippingName;
-        $settings->feesName = $wooOrder->feesName;
-        $settings->manageStock = $wooOrder->manageStock;
-        $settings->productPriceColumn = $wooOrder->productPriceColumn;
-        $settings->warehouse = $wooOrder->warehouse;
-        $settings->sendInvoice = $wooOrder->sendInvoice;
-
-        #shop data
-        $shop->currency = $wooOrder->wooCurrency;
-
-        # bill data
-        $bill->country = $wooOrder->billing_country;
-        $bill->nome = $wooOrder->billing_first_name. " " .$wooOrder->billing_last_name;
-        $bill->email = $wooOrder->billing_email;
-        $bill->morada = $wooOrder->billing_address_1;
-        $bill->local = $wooOrder->billing_city;
-        $bill->provincia = $wooOrder->billing_city;
-        $bill->telefone = $wooOrder->billing_phone;
-        $bill->codpost = $wooOrder->billing_postcode;
-        $bill->ncont = $wooOrder->billing_nif_ft;
-
-        # shipping data
-        $shipping->paisto = $wooOrder->shipping_country;
-        $shipping->moradato = $wooOrder->shipping_address_1;
-        $shipping->localto = $wooOrder->shipping_city;
-        $shipping->codpostto = $wooOrder->shipping_postcode;
-        $shipping->shipping_name = $wooOrder->shipping_name;
-        $shipping->shipping_taxValue = $wooOrder->shipping_taxValue;
-        $shipping->shipping_tax = $wooOrder->shipping_tax;
-        $shipping->shipping_country = $wooOrder->shipping_country;
-        $shipping->shipping_value = $wooOrder->shipping_value;
-
-        # customer data
-        $customer->nome = $wooOrder->billing_first_name. " " .$wooOrder->billing_last_name;
-        $customer->email = $wooOrder->billing_email;
-        $customer->morada = !empty($wooOrder->shipping_address_1) ? $wooOrder->shipping_address_1 : $wooOrder->billing_address_1;
-        $customer->local = !empty($wooOrder->shipping_city) ? $wooOrder->shipping_city : $wooOrder->billing_city;
-        $customer->provincia = !empty($wooOrder->shipping_city) ? $wooOrder->shipping_city : $wooOrder->billing_city;
-        $customer->telefone = $wooOrder->billing_phone;
-        $customer->codpost = !empty($wooOrder->shipping_postcode) ? $wooOrder->shipping_postcode : $wooOrder->billing_postcode;
-        $customer->ncont = $wooOrder->billing_nif_ft;
-        $customer->preco = $wooOrder->productPriceColumn;
-        $customer->country = !empty($wooOrder->shipping_country) ? $wooOrder->shipping_country : $wooOrder->billing_country;
-        $customer->user_email = $wooOrder->user_email;
-
-       /*  $customer->nome = $wooOrder->billing_first_name. " " .$wooOrder->billing_last_name;
-        $customer->email = $wooOrder->billing_email;
-        $customer->morada = $wooOrder->billing_address_1;
-        $customer->local = $wooOrder->billing_city;
-        $customer->provincia = $wooOrder->billing_city;
-        $customer->telefone = $wooOrder->billing_phone;
-        $customer->codpost = $wooOrder->billing_postcode;
-        $customer->ncont = $wooOrder->billing_nif_ft;
-        $customer->preco = $wooOrder->productPriceColumn;
-        $customer->country = $wooOrder->billing_country;
-        $customer->user_email = $wooOrder->user_email; */
-
-        # order
-        $order->post_Id = $wooOrder->post_ID;
-        $order->doc_Id = $wooOrder->docId;
-        $order->order_Id = $wooOrder->orderId;
-        $order->cart = $prodPack;
-        $order->post_title = $wooOrder->post_title;
-        $order->edescc = $wooOrder->edescc;
-        $order->obs = $wooOrder->obs;
-        $order->order_received = $wooOrder->order_received;
-        $order->nextPostId = $wooOrder->nextPostId;
-        $order->fees = $wooOrder->fees_bo;
-
-        # invoice
-        $ft->country = $wooOrder->billing_country_ft;
-        $ft->shipping_country = $wooOrder->shipping_country_ft;
-        $ft->cart = $ftprodPack;
-        $ft->shipping_name = $wooOrder->ftShipping_name;
-        $ft->shipping_value = $wooOrder->ftShipping_value;
-        $ft->fees = $wooOrder->fees_ft;
-        $ft->billing_name = $wooOrder->billing_first_name_ft. " " .$wooOrder->billing_last_name_ft;
-        $ft->billing_email = $wooOrder->billing_email_ft;
-        $ft->billing_address_1 = $wooOrder->billing_address_1_ft;
-        $ft->billing_city = $wooOrder->billing_city_ft;
-        $ft->billing_phone = $wooOrder->billing_phone_ft;
-        $ft->billing_postcode = $wooOrder->billing_postcode_ft;
-        $ft->billing_nif = $wooOrder->billing_nif_ft;
-
-
-
-
-
-        /******************************************/
-
-        #build dataPack object
-        $dataPack->settings = $settings;
-        $dataPack->shop = $shop;
-        $dataPack->bill = $bill;
-        $dataPack->shipping = $shipping;
-        $dataPack->customer = $customer;
-        $dataPack->order = $order;
-        $dataPack->ft = $ft;
-
-
-        //$this->logs->writeFileLog('dataPack', $dataPack);
-
-        return $dataPack;
-    }
+        public function transformWcToPhcData($wooOrder, $prodPack, $ftprodPack) {
+
+            $dataPack = new stdClass();
+
+            $settings = new Settings();
+            $shop = new stdClass();
+            $bill = new Bill();
+            $shipping = new Shipping();
+            $customer = new Customer();
+            $order = new Order();
+            $ft = new Invoice();
+
+            #settings data
+            $settings->createInvoice = $wooOrder->createInvoice;
+            $settings->typeOfInvoice = $wooOrder->typeOfInvoice;
+            $settings->typeOf_EU_Invoice = $wooOrder->typeOf_EU_Invoice;
+            $settings->toSignInvoice = $wooOrder->toSignInvoice;
+            $settings->fieldNif = $wooOrder->fieldNif;
+            $settings->includeTaxonSendCost = $wooOrder->includeTaxonSendCost;
+            $settings->createExemptPT = $wooOrder->createExemptPT;
+            $settings->typeOfReason = $wooOrder->typeOfReason;
+            $settings->createExemptEU = $wooOrder->createExemptEU;
+            $settings->typeOfReasonEU = $wooOrder->typeOfReasonEU;
+            $settings->createExemptCO = $wooOrder->createExemptCO;
+            $settings->typeOfReasonCO = $wooOrder->typeOfReasonCO;
+            $settings->warehouseOrder = $wooOrder->warehouseOrder;
+            $settings->typeOfOrder = $wooOrder->typeOfOrder;
+            $settings->toSignOrder = $wooOrder->toSignOrder;
+            $settings->numberOfOrder = $wooOrder->numberOfOrder;
+            $settings->statusOfOrder = $wooOrder->statusOfOrder;
+            $settings->shippingName = $wooOrder->shippingName;
+            $settings->feesName = $wooOrder->feesName;
+            $settings->manageStock = $wooOrder->manageStock;
+            $settings->productPriceColumn = $wooOrder->productPriceColumn;
+            $settings->warehouse = $wooOrder->warehouse;
+            $settings->sendInvoice = $wooOrder->sendInvoice;
+
+            #shop data
+            $shop->currency = $wooOrder->wooCurrency;
+            $shop->country = $wooOrder->companyCountry;
+            $shop->taxCountry = $wooOrder->taxCountry;
+
+            # bill data
+            $bill->country = $wooOrder->billing_country;
+            $bill->nome = $wooOrder->billing_first_name. " " .$wooOrder->billing_last_name;
+            $bill->email = $wooOrder->billing_email;
+            $bill->morada = $wooOrder->billing_address_1;
+            $bill->local = $wooOrder->billing_city;
+            $bill->provincia = $wooOrder->billing_city;
+            $bill->telefone = $wooOrder->billing_phone;
+            $bill->codpost = $wooOrder->billing_postcode;
+            $bill->ncont = $wooOrder->billing_nif_ft;
+
+            # shipping data
+            $shipping->cl_name = $wooOrder->shipping_first_name. " " .$wooOrder->shipping_last_name;
+            $shipping->ncont = $wooOrder->ship_nifName;
+            $shipping->paisto = $wooOrder->shipping_country;
+            $shipping->moradato = $wooOrder->shipping_address_1;
+            $shipping->localto = $wooOrder->shipping_city;
+            $shipping->codpostto = $wooOrder->shipping_postcode;
+            $shipping->shipping_name = $wooOrder->shipping_name;
+            $shipping->shipping_taxValue = $wooOrder->shipping_taxValue;
+            $shipping->shipping_tax = $wooOrder->shipping_tax;
+            $shipping->shipping_country = $wooOrder->shipping_country;
+            $shipping->shipping_value = $wooOrder->shipping_value;
+
+            # customer data (billing data)
+            $customer->nome = $wooOrder->billing_first_name. " " .$wooOrder->billing_last_name;
+            $customer->email = $wooOrder->billing_email;
+            $customer->morada = $wooOrder->billing_address_1;
+            $customer->local = $wooOrder->billing_city;
+            $customer->provincia = $wooOrder->billing_city;
+            $customer->telefone = $wooOrder->billing_phone;
+            $customer->codpost = $wooOrder->billing_postcode;
+            $customer->ncont = $wooOrder->billing_nif_ft;
+            $customer->preco = $wooOrder->productPriceColumn;
+            $customer->country = $wooOrder->billing_country;
+            $customer->user_email = $wooOrder->user_email;
+
+            # order
+            $order->post_Id = $wooOrder->post_ID;
+            $order->doc_Id = $wooOrder->docId;
+            $order->order_Id = $wooOrder->orderId;
+            $order->cart = $prodPack;
+            $order->post_title = $wooOrder->post_title;
+            $order->edescc = $wooOrder->edescc;
+            $order->obs = $wooOrder->obs;
+            $order->order_received = $wooOrder->order_received;
+            $order->nextPostId = $wooOrder->nextPostId;
+            $order->fees = $wooOrder->fees_bo;
+
+            # invoice
+            $ft->country = $wooOrder->billing_country_ft;
+            $ft->cart = $ftprodPack;
+            $ft->billing_name = $wooOrder->billing_first_name_ft. " " .$wooOrder->billing_last_name_ft;
+            $ft->billing_email = $wooOrder->billing_email_ft;
+            $ft->billing_address_1 = $wooOrder->billing_address_1_ft;
+            $ft->billing_city = $wooOrder->billing_city_ft;
+            $ft->billing_phone = $wooOrder->billing_phone_ft;
+            $ft->billing_postcode = $wooOrder->billing_postcode_ft;
+            $ft->billing_nif = $wooOrder->billing_nif_ft;
+            $ft->shipping_name = $wooOrder->shipping_name;
+            $ft->shipping_value = $wooOrder->shipping_value;
+            $ft->shipping_country = $wooOrder->shipping_country;;
+            $ft->shipping_taxValue = $wooOrder->shipping_taxValue;
+            $ft->shipping_tax = $wooOrder->shipping_tax;
+            $ft->fees = $wooOrder->fees_ft;
+
+
+            /******************************************************/
+
+            #build dataPack object
+            $dataPack->settings = $settings;
+            $dataPack->shop = $shop;
+            $dataPack->bill = $bill;
+            $dataPack->shipping = $shipping;
+            $dataPack->customer = $customer;
+            $dataPack->order = $order;
+            $dataPack->ft = $ft;
+
+            //$this->logs->writeFileLog('dataPack', $dataPack);
+
+            return $dataPack;
+        }
 }