sirdiego / importr

Classes/Service/Targets/InsertUpdateTable.php

Doc Comments +1 added lines

@@ -136,6 +136,7 @@
      *
      * Fetch all records from the target table, where the PID equals the PID specified in the target section of the strategy 
      *
+     * @param string $selectFields
      * @return void
      */
     public function getRecords($selectFields)

Unused Use Statements -2 removed lines

@@ -2,8 +2,6 @@
 namespace HDNET\Importr\Service\Targets;
 
 use HDNET\Importr\Domain\Model\Strategy;
-use TYPO3\CMS\Extbase\DomainObject\AbstractEntity;
-use HDNET\Importr\Utility;
 
   /**
   * Imports records from a .CSV file into the target table which you can specify on the target section in your strategy.

Indentation +59 added lines, -59 removed lines

@@ -5,49 +5,49 @@ 
 use TYPO3\CMS\Extbase\DomainObject\AbstractEntity;
 use HDNET\Importr\Utility;
 
-  /**
-  * Imports records from a .CSV file into the target table which you
-  * can specify on the target section in your strategy.
-  * If a record does not exist in the table, it will be inserted,
-  * otherwise it will be just updated. No duplicates are created.
-  *
-  * complete example (strategy target):
-  *
-  * HDNET\Importr\Service\Targets\InsertUpdateTable:
-  *   model: TYPO3\CMS\Extbase\Domain\Model\FrontendUser
-  *   repository: TYPO3\CMS\Extbase\Domain\Repository\FrontendUserRepository
-  *   target_table: fe_users
-  *   exclude_from_update:
-  *     0: password
-  *     1: first_name
-  *     2: zip
-  *   pid: 324
-  *   mapping:
-  *     0: username
-  *     1: password
-  *     2: usergroup
-  *     3: name
-  *     4: first_name
-  *     5: address
-  *     6: telephone
-  *     7: email
-  *     8: zip
-  *     9: city
-  *     10: company
-  *
-  * Example CSV:
-  *
-  * username;password;usergroup;name;first_name;address;telephone;email;zip;city;company
-  * EduardFekete;PW123;3;Fekete;Eduard; Example 21; +049123456789;eduard.fekete@mbconnectline.de;91550;Feuchtwangen;MB Connect Line GmbH
-  * HansVader;PW1234;3;Vader;Hans; Example 22; +049123456710;hans_vader@universe.com;99900;Universe;Hollywood Studios
-  *
-  * ------------------------------------------------------------------------------------------------
-  *
-  *   exclude_from_update:    the elements specified in this array, are never being updated
-  *
-  * ------------------------------------------------------------------------------------------------
-  * @author Eduard Fekete
-  */
+    /**
+     * Imports records from a .CSV file into the target table which you
+     * can specify on the target section in your strategy.
+     * If a record does not exist in the table, it will be inserted,
+     * otherwise it will be just updated. No duplicates are created.
+     *
+     * complete example (strategy target):
+     *
+     * HDNET\Importr\Service\Targets\InsertUpdateTable:
+     *   model: TYPO3\CMS\Extbase\Domain\Model\FrontendUser
+     *   repository: TYPO3\CMS\Extbase\Domain\Repository\FrontendUserRepository
+     *   target_table: fe_users
+     *   exclude_from_update:
+     *     0: password
+     *     1: first_name
+     *     2: zip
+     *   pid: 324
+     *   mapping:
+     *     0: username
+     *     1: password
+     *     2: usergroup
+     *     3: name
+     *     4: first_name
+     *     5: address
+     *     6: telephone
+     *     7: email
+     *     8: zip
+     *     9: city
+     *     10: company
+     *
+     * Example CSV:
+     *
+     * username;password;usergroup;name;first_name;address;telephone;email;zip;city;company
+     * EduardFekete;PW123;3;Fekete;Eduard; Example 21; +049123456789;eduard.fekete@mbconnectline.de;91550;Feuchtwangen;MB Connect Line GmbH
+     * HansVader;PW1234;3;Vader;Hans; Example 22; +049123456710;hans_vader@universe.com;99900;Universe;Hollywood Studios
+     *
+     * ------------------------------------------------------------------------------------------------
+     *
+     *   exclude_from_update:    the elements specified in this array, are never being updated
+     *
+     * ------------------------------------------------------------------------------------------------
+     * @author Eduard Fekete
+     */
 
 class InsertUpdateTable extends AbstractTarget implements TargetInterface
 {
@@ -178,14 +178,14 @@ 
         $GLOBALS['TYPO3_DB']->sql_insert_id();
     }
 
-     /**
-     * Update a record in the target table which you have specified in the
-     * target section of the strategy (don't update the password)
-     *
-     * @param array $entry
-     *
-     * @return void
-     */
+        /**
+         * Update a record in the target table which you have specified in the
+         * target section of the strategy (don't update the password)
+         *
+         * @param array $entry
+         *
+         * @return void
+         */
     public function updateRecord(array $entry)
     {
         $into_table       = $this->configuration['target_table'];
@@ -206,14 +206,14 @@ 
     }
 
     /**
-    * This function creates a duplicate of a associative array and optionally removes
-    * any entries which are also elements of a second array
-    *
-    * @param array $arr
-    * @param array $exclude_arr
-    *
-    * @return array
-    */
+     * This function creates a duplicate of a associative array and optionally removes
+     * any entries which are also elements of a second array
+     *
+     * @param array $arr
+     * @param array $exclude_arr
+     *
+     * @return array
+     */
     public function duplicateArray(array $arr, array $exclude_arr = null)
     {
         $exclude = false;

Spacing +3 added lines, -3 removed lines

@@ -106,7 +106,7 @@ 
         $record_exists    = false;
         $entry_username   = $entry['0'];
 
-        $this->configuration    = $this->getConfiguration();
+        $this->configuration = $this->getConfiguration();
 
         if ($this->firstTime == "1") {
             $this->firstTime = 0;
@@ -143,7 +143,7 @@ 
     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;
 
@@ -189,7 +189,7 @@ 
     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();