sirdiego / importr

Classes/Service/Targets/InsertUpdateTable.php

Spacing +15 added lines, -16 removed lines

@@ -106,16 +106,16 @@ 
         $record_exists    = false;
         $entry_username   = $entry['0'];
 
-        $this->configuration    = $this->getConfiguration();
+        $this->configuration = $this->getConfiguration();
 
         if ($this->firstTime == "1") {
             $this->firstTime = 0;
             $this->getRecords("*");
         }
 
-        foreach ($this->table_records as $record){
-            if ($record['deleted'] == 0){
-                if ($record['username'] == $entry_username){
+        foreach ($this->table_records as $record) {
+            if ($record['deleted'] == 0) {
+                if ($record['username'] == $entry_username) {
                     $record_exists = true;
                     break;
                 }
@@ -125,7 +125,7 @@ 
             }
         }
 
-        if ($record_exists){
+        if ($record_exists) {
             $this->updateRecord($entry);
             return TargetInterface::RESULT_UPDATE;
         }
@@ -144,12 +144,11 @@ 
     public function getRecords($selectFields)
     {
         $fromTable        = $this->configuration['target_table'];
-        $whereStatement   = "pid = '".$this->configuration['pid']."'";
+        $whereStatement   = "pid = '" . $this->configuration['pid'] . "'";
 
         $GLOBALS['TYPO3_DB']->store_lastBuiltQuery = 1;
 
-        $this->table_records = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows
-        (
+        $this->table_records = $GLOBALS['TYPO3_DB']->exec_SELECTgetRows(
             $selectFields,
             $fromTable,
             $whereStatement
@@ -168,7 +167,7 @@ 
         $field_values       = array();
         $into_table         = $this->configuration['target_table'];
 
-        foreach ($this->configuration["mapping"] as $key => $value){
+        foreach ($this->configuration["mapping"] as $key => $value) {
             $field_values[$value] = $entry[$key];
         }
 
@@ -176,7 +175,7 @@ 
         $field_values['tstamp']   = time();
         $field_values['crdate']   = time();
               
-        $GLOBALS['TYPO3_DB']->exec_INSERTquery( $into_table, $field_values);
+        $GLOBALS['TYPO3_DB']->exec_INSERTquery($into_table, $field_values);
         $GLOBALS['TYPO3_DB']->sql_insert_id();
     }
 
@@ -190,19 +189,19 @@ 
     public function updateRecord(array $entry)
     {
         $into_table       = $this->configuration['target_table'];
-        $whereStatement   = "pid = '".$this->configuration['pid']."' AND username = '".$entry[0]."'";
+        $whereStatement   = "pid = '" . $this->configuration['pid'] . "' AND username = '" . $entry[0] . "'";
                            
         $field_values     = array();
         $tmp_arr          = array();
 
-        foreach ($this->configuration["mapping"] as $key => $value){
+        foreach ($this->configuration["mapping"] as $key => $value) {
             $tmp_arr[$value] = $entry[$key];
         }
 
-        $field_values = $this->duplicateArray($tmp_arr,$this->configuration['exclude_from_update']);
+        $field_values = $this->duplicateArray($tmp_arr, $this->configuration['exclude_from_update']);
         $field_values['tstamp'] = time();
         
-        $res = $GLOBALS['TYPO3_DB']->exec_UPDATEquery( $into_table , $whereStatement , $field_values );
+        $res = $GLOBALS['TYPO3_DB']->exec_UPDATEquery($into_table, $whereStatement, $field_values);
         $cnt = $GLOBALS['TYPO3_DB']->sql_affected_rows();
     }
 
@@ -221,7 +220,7 @@ 
 
         if ($exclude_arr != null) {
             $exclude_max = count($exclude_arr);
-            if (count($exclude_arr) > 0){
+            if (count($exclude_arr) > 0) {
                 $exclude = true;
             }
 
@@ -231,7 +230,7 @@ 
 
                 if ($exclude) {
                     foreach ($exclude_arr as $key => $value) {
-                        if ($value == $parentkey){
+                        if ($value == $parentkey) {
                             unset($arr[$parentkey]);
                         }
                     }