Completed
Push — master ( 1fef91...36506d )
by diego
9s
created
Classes/Service/Targets/InsertUpdateTable.php 4 patches
Doc Comments   +1 added lines patch added patch discarded remove patch
@@ -136,6 +136,7 @@
 block discarded – undo
136 136
      *
137 137
      * Fetch all records from the target table, where the PID equals the PID specified in the target section of the strategy 
138 138
      *
139
+     * @param string $selectFields
139 140
      * @return void
140 141
      */
141 142
     public function getRecords($selectFields)
Please login to merge, or discard this patch.
Unused Use Statements   -2 removed lines patch added patch discarded remove patch
@@ -2,8 +2,6 @@
 block discarded – undo
2 2
 namespace HDNET\Importr\Service\Targets;
3 3
 
4 4
 use HDNET\Importr\Domain\Model\Strategy;
5
-use TYPO3\CMS\Extbase\DomainObject\AbstractEntity;
6
-use HDNET\Importr\Utility;
7 5
 
8 6
   /**
9 7
   * Imports records from a .CSV file into the target table which you can specify on the target section in your strategy.
Please login to merge, or discard this patch.
Indentation   +59 added lines, -59 removed lines patch added patch discarded remove patch
@@ -5,49 +5,49 @@  discard block
 block discarded – undo
5 5
 use TYPO3\CMS\Extbase\DomainObject\AbstractEntity;
6 6
 use HDNET\Importr\Utility;
7 7
 
8
-  /**
9
-  * Imports records from a .CSV file into the target table which you
10
-  * can specify on the target section in your strategy.
11
-  * If a record does not exist in the table, it will be inserted,
12
-  * otherwise it will be just updated. No duplicates are created.
13
-  *
14
-  * complete example (strategy target):
15
-  *
16
-  * HDNET\Importr\Service\Targets\InsertUpdateTable:
17
-  *   model: TYPO3\CMS\Extbase\Domain\Model\FrontendUser
18
-  *   repository: TYPO3\CMS\Extbase\Domain\Repository\FrontendUserRepository
19
-  *   target_table: fe_users
20
-  *   exclude_from_update:
21
-  *     0: password
22
-  *     1: first_name
23
-  *     2: zip
24
-  *   pid: 324
25
-  *   mapping:
26
-  *     0: username
27
-  *     1: password
28
-  *     2: usergroup
29
-  *     3: name
30
-  *     4: first_name
31
-  *     5: address
32
-  *     6: telephone
33
-  *     7: email
34
-  *     8: zip
35
-  *     9: city
36
-  *     10: company
37
-  *
38
-  * Example CSV:
39
-  *
40
-  * username;password;usergroup;name;first_name;address;telephone;email;zip;city;company
41
-  * EduardFekete;PW123;3;Fekete;Eduard; Example 21; +049123456789;[email protected];91550;Feuchtwangen;MB Connect Line GmbH
42
-  * HansVader;PW1234;3;Vader;Hans; Example 22; +049123456710;[email protected];99900;Universe;Hollywood Studios
43
-  *
44
-  * ------------------------------------------------------------------------------------------------
45
-  *
46
-  *   exclude_from_update:    the elements specified in this array, are never being updated
47
-  *
48
-  * ------------------------------------------------------------------------------------------------
49
-  * @author Eduard Fekete
50
-  */
8
+    /**
9
+     * Imports records from a .CSV file into the target table which you
10
+     * can specify on the target section in your strategy.
11
+     * If a record does not exist in the table, it will be inserted,
12
+     * otherwise it will be just updated. No duplicates are created.
13
+     *
14
+     * complete example (strategy target):
15
+     *
16
+     * HDNET\Importr\Service\Targets\InsertUpdateTable:
17
+     *   model: TYPO3\CMS\Extbase\Domain\Model\FrontendUser
18
+     *   repository: TYPO3\CMS\Extbase\Domain\Repository\FrontendUserRepository
19
+     *   target_table: fe_users
20
+     *   exclude_from_update:
21
+     *     0: password
22
+     *     1: first_name
23
+     *     2: zip
24
+     *   pid: 324
25
+     *   mapping:
26
+     *     0: username
27
+     *     1: password
28
+     *     2: usergroup
29
+     *     3: name
30
+     *     4: first_name
31
+     *     5: address
32
+     *     6: telephone
33
+     *     7: email
34
+     *     8: zip
35
+     *     9: city
36
+     *     10: company
37
+     *
38
+     * Example CSV:
39
+     *
40
+     * username;password;usergroup;name;first_name;address;telephone;email;zip;city;company
41
+     * EduardFekete;PW123;3;Fekete;Eduard; Example 21; +049123456789;[email protected];91550;Feuchtwangen;MB Connect Line GmbH
42
+     * HansVader;PW1234;3;Vader;Hans; Example 22; +049123456710;[email protected];99900;Universe;Hollywood Studios
43
+     *
44
+     * ------------------------------------------------------------------------------------------------
45
+     *
46
+     *   exclude_from_update:    the elements specified in this array, are never being updated
47
+     *
48
+     * ------------------------------------------------------------------------------------------------
49
+     * @author Eduard Fekete
50
+     */
51 51
 
52 52
 class InsertUpdateTable extends AbstractTarget implements TargetInterface
53 53
 {
@@ -178,14 +178,14 @@  discard block
 block discarded – undo
178 178
         $GLOBALS['TYPO3_DB']->sql_insert_id();
179 179
     }
180 180
 
181
-     /**
182
-     * Update a record in the target table which you have specified in the
183
-     * target section of the strategy (don't update the password)
184
-     *
185
-     * @param array $entry
186
-     *
187
-     * @return void
188
-     */
181
+        /**
182
+         * Update a record in the target table which you have specified in the
183
+         * target section of the strategy (don't update the password)
184
+         *
185
+         * @param array $entry
186
+         *
187
+         * @return void
188
+         */
189 189
     public function updateRecord(array $entry)
190 190
     {
191 191
         $into_table       = $this->configuration['target_table'];
@@ -206,14 +206,14 @@  discard block
 block discarded – undo
206 206
     }
207 207
 
208 208
     /**
209
-    * This function creates a duplicate of a associative array and optionally removes
210
-    * any entries which are also elements of a second array
211
-    *
212
-    * @param array $arr
213
-    * @param array $exclude_arr
214
-    *
215
-    * @return array
216
-    */
209
+     * This function creates a duplicate of a associative array and optionally removes
210
+     * any entries which are also elements of a second array
211
+     *
212
+     * @param array $arr
213
+     * @param array $exclude_arr
214
+     *
215
+     * @return array
216
+     */
217 217
     public function duplicateArray(array $arr, array $exclude_arr = null)
218 218
     {
219 219
         $exclude = false;
Please login to merge, or discard this patch.
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -106,7 +106,7 @@  discard block
 block discarded – undo
106 106
         $record_exists    = false;
107 107
         $entry_username   = $entry['0'];
108 108
 
109
-        $this->configuration    = $this->getConfiguration();
109
+        $this->configuration = $this->getConfiguration();
110 110
 
111 111
         if ($this->firstTime == "1") {
112 112
             $this->firstTime = 0;
@@ -143,7 +143,7 @@  discard block
 block discarded – undo
143 143
     public function getRecords($selectFields)
144 144
     {
145 145
         $fromTable        = $this->configuration['target_table'];
146
-        $whereStatement   = "pid = '".$this->configuration['pid']."'";
146
+        $whereStatement   = "pid = '" . $this->configuration['pid'] . "'";
147 147
 
148 148
         $GLOBALS['TYPO3_DB']->store_lastBuiltQuery = 1;
149 149
 
@@ -189,7 +189,7 @@  discard block
 block discarded – undo
189 189
     public function updateRecord(array $entry)
190 190
     {
191 191
         $into_table       = $this->configuration['target_table'];
192
-        $whereStatement   = "pid = '".$this->configuration['pid']."' AND username = '".$entry[0]."'";
192
+        $whereStatement   = "pid = '" . $this->configuration['pid'] . "' AND username = '" . $entry[0] . "'";
193 193
                            
194 194
         $field_values     = array();
195 195
         $tmp_arr          = array();
Please login to merge, or discard this patch.