Changeset 1999880

Timestamp:

12/21/2018 04:37:09 PM (7 years ago)

Author:

phcwordpress

Message:

4.5.8 - Fixed issue product's tax rate

Location:

drivefx-woocommerce/trunk

Files:

• class.DriveFxWoocommerce.php (modified) (2 diffs)
• readme.txt (modified) (1 diff)

drivefx-woocommerce/trunk/class.DriveFxWoocommerce.php

@@ -1726 +1726 @@
                     }
                     
+                    if($billing_country=="GB" ){
+                        $this->paramsQuery('Countries', 'nomeabrv', "UK");
+                    }else if($billing_country_=="GB"){
+                        $this->paramsQuery('Countries', 'nomeabrv', "UK");
+                    }
                     
                     curl_setopt($ch, CURLOPT_URL, $this->url);
@@ -2517 +2522 @@
                                                                 }
                                                                 
-                                                        
+                                                                
+                                                                //get taxes from drive fx
+                                                                $url = $settings['backend']['url'] . $this->extraurl . "/REST/SearchWS/QueryAsEntities";
+                                                                
+                                                                
+                                                                $params =  array('itemQuery' => '{"distinct": true,
+                                                                                        "groupByItems": [],
+                                                                                        "orderByItems": [
+                                                                                            {
+                                                                                              "OrderItem": "dataini",
+                                                                                              "OrderType": 1
+                                                                                            }
+                                                                                          ],
+                                                                                        "SelectItems": [],
+                                                                                        "entityName": "TaxasIVA",
+                                                                                        "filterItems": [],
+                                                                                        "joinEntities": []
+                                                                                    }'
+                                                                            );
+                                                                
+                                                                $queryActEntity = http_build_query($params);
+                                                                curl_setopt($ch, CURLOPT_URL, $url);
+                                                                curl_setopt($ch, CURLOPT_POST, false);
+                                                                curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
+                                                                curl_setopt($ch, CURLOPT_POSTFIELDS, $queryActEntity);
+                                                                curl_setopt($ch, CURLOPT_ENCODING, 'UTF-8');
+                                                                $responseQueryAsEntities = curl_exec($ch);
+
+                                                                
+                                                                $responseQueryAsEntities = json_decode($responseQueryAsEntities, true);
+
+                                                                
+                                                                if (is_array($_SESSION['listOfSku'])){
+                                                                    foreach ($_SESSION['listOfSku'] as $key => $value){
+                                                                         if( $_SESSION['listOfQuantity'][$key]*$_SESSION['listOfValueItem'][$key]!=0){
+                                                                            //get product id from sku 
+                                                                            $getProductId = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_sku' AND meta_value='%s' LIMIT 1", $value ) ); 
+                                                                            
+                                                                            //get product From id
+                                                                            $getProduct = wc_get_product($getProductId);
+                                                                            
+                                                                            //get product tax rate  
+                                                                            $getProductTax = $wpdb->get_var( $wpdb->prepare( "SELECT tax_rate FROM ".$wpdb->prefix."woocommerce_tax_rates WHERE tax_rate_class='%s' LIMIT 1", $getProduct->get_tax_class() ) );
+                                                                            //get 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() ) );
+                                                                        
+                                                                            foreach ($responseQueryAsEntities['result'] as $tax) {
+                                                                                
+                                                                                 If ($getProductTax == $tax['taxa'] && $getTaxCountry == $tax['regiao'] ) {
+                                                                                    $response['result'][0]['bis'][$key]['iva'] = $tax['taxa'];
+                                                                                    $response['result'][0]['bis'][$key]['tabiva'] = $tax['codigo'];
+                                                                                    
+                                                                                    break;
+                                                                                 }
+                                                                            }
+                                                                            
+                                                                        }
+                                                                    }
+                                                                }
+                                                                
                                                                 
                                                                 $urlActEntity = $settings['backend']['url'] . $this->extraurl . "/REST/BoWS/actEntity";

drivefx-woocommerce/trunk/readme.txt

@@ -4 +4 @@
 Requires at least: 4.5
 Tested up to: 4.8
-Stable tag: 4.5.7
+Stable tag: 4.5.8
 License: GPLv2 or later