Changeset 2624007

Timestamp:

11/03/2021 12:37:00 PM (4 years ago)

Author:

phcwordpress

Message:

upd 20211103

Location:

drivefx-woocommerce/trunk

Files:

• PHCLibrary/utils.php (modified) (1 diff)
• class.DriveFxWoocommerce.php (modified) (2 diffs)

drivefx-woocommerce/trunk/PHCLibrary/utils.php

@@ -204 +204 @@
                                                 "entityName":"'.$entityName.'",
                                                 "filterItems":[]
+                                                }'
+                                );
+        //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);
+
+        return $response;
+    }
+
+    public function entityName_Query1($ch, $credentials, $armazem){
+        $this->url = $credentials->backendUrl."/REST/SearchWS/QueryAsEntities";
+        //Create map with request parameters
+        $this->params =  array ('itemQuery' => '{"distinct": true,
+                                                "groupByItems": [],
+                                                "lazyLoaded": false,
+                                                "offset": 0,
+                                                "orderByItems":[],
+                                                "SelectItems": [
+                                                "st.ref",
+                                                "st.design",
+                                                "st.familia",
+                                                "sa.stock"
+                                                ],
+                                                "entityName": "st",
+                                                "filterItems": [],
+                                                "joinEntities": [{
+                                                "tableName": "sa",
+                                                "joinType": 1,
+                                                "joinExp": [{                                                  
+                                                    "filterItem": "sa.ref",
+                                                    "comparison": 0,
+                                                    "valueItem": "<#var>st.ref",                                                 
+                                                    "groupItem": 1
+                                                    },
+                                                    {
+                                                    "filterItem": "sa.armazem",
+                                                    "comparison": 0,
+                                                    "valueItem": "'.$armazem.'",
+                                                    "groupItem": 0
+                                                    }]
+                                                }]
                                                 }'
                                 );

drivefx-woocommerce/trunk/class.DriveFxWoocommerce.php

@@ -1857 +1857 @@
                     }
                 } else {
-                    $response = $this->utils_services->entityName_Query($ch, $credentials, 'St');
+                    //$response = $this->utils_services->entityName_Query($ch, $credentials, 'St');
+                    $response = $this->utils_services->entityName_Query1($ch, $credentials, $settings['backend']['warehouse']);
+
+                    //$this->logs->writeFileLog('response_with_armazem:', $response);
+                
                 }
 
@@ -2178 +2182 @@
                         //$this->logs->writeFileLog('st:', $response);
                     } else {
-                        $response = $this->utils_services->filterItem_Query($ch, $credentials, 'Sa', 'armazem', $settings['backend']['warehouse']);
+                        //$response = $this->utils_services->filterItem_Query($ch, $credentials, 'Sa', 'armazem', $settings['backend']['warehouse']);
+                        $response = $this->utils_services->entityName_Query1($ch, $credentials, $settings['backend']['warehouse']);
                     }