Wabel / zoho-crm-copy-db

src/ZohoDatabaseModelSync.php

Spacing +4 added lines, -4 removed lines

@@ -86,15 +86,15 @@ 
 
         $flatFields = ZohoDatabaseHelper::getFlatFields($dao->getFields());
         //@Temporary fix to use Mysql5.7 not strict
-        $table->addColumn('uid', 'string', ['length' => 36,'notnull'=>false]);
-        $table->addColumn('id', 'string', ['length' => 100,'notnull'=>false]);
+        $table->addColumn('uid', 'string', ['length' => 36, 'notnull'=>false]);
+        $table->addColumn('id', 'string', ['length' => 100, 'notnull'=>false]);
         $table->addUniqueIndex(['id']);
         $table->setPrimaryKey(['uid']);
 
         foreach ($flatFields as $field) {
             $columnName = $field['name'];
             //It seems sometime we can have the same field twice in the list of fields from the API.
-            if($table->hasColumn($columnName)){
+            if ($table->hasColumn($columnName)) {
                 continue;
             }
 
@@ -202,7 +202,7 @@ 
         $table = $schema->createTable($tableName);
 
         $flatFields = $users->getUserFields();
-        $table->addColumn('id', 'string', ['length' => 100,'notnull'=>false]);
+        $table->addColumn('id', 'string', ['length' => 100, 'notnull'=>false]);
         $table->setPrimaryKey(['id']);
         foreach ($flatFields as $field) {
             if (in_array($field, ['id'])) {

src/ZohoDatabasePusher.php

Spacing +5 added lines, -5 removed lines

@@ -126,8 +126,8 @@ 
         //To optimize your API usage, get maximum 200 records with each request and insert, update or delete maximum 100 records with each request.
         $offsetTodo = 0;
         $doneBeans = 0;
-        while($doneBeans < $countItems){
-            $zohoBeansToSend = array_slice($zohoBeans,$offsetTodo,$this->apiLimitInsertUpdateDelete,true);
+        while ($doneBeans < $countItems) {
+            $zohoBeansToSend = array_slice($zohoBeans, $offsetTodo, $this->apiLimitInsertUpdateDelete, true);
             $offsetTodo += $this->apiLimitInsertUpdateDelete;
             $doneBeans += count($zohoBeansToSend);
         }
@@ -140,13 +140,13 @@ 
                     // ID not exist we can update the new row with the Zoho ID
                     $this->connection->beginTransaction();
                     $this->connection->update($tableName, ['id' => $zohoBean->getZohoId()], ['uid' => $uid]);
-                    $this->connection->delete('local_insert', ['table_name'=>$tableName, 'uid' => $uid ]);
+                    $this->connection->delete('local_insert', ['table_name'=>$tableName, 'uid' => $uid]);
                     $this->connection->commit();
                 } else {
                     //ID already exist we need to delete the duplicate row.
                     $this->connection->beginTransaction();
-                    $this->connection->delete($tableName, ['uid' => $uid ]);
-                    $this->connection->delete('local_insert', ['table_name'=>$tableName, 'uid' => $uid ]);
+                    $this->connection->delete($tableName, ['uid' => $uid]);
+                    $this->connection->delete('local_insert', ['table_name'=>$tableName, 'uid' => $uid]);
                     $this->connection->commit();
                 }
             }

src/ZohoDatabaseCopier.php

Spacing +2 added lines, -2 removed lines

@@ -129,9 +129,9 @@
             // Let's get the last modification date:
             $tableDetail = $this->connection->getSchemaManager()->listTableDetails($tableName);
             //We use createdTime instead of lastActivityTime when the field doesn't exist in order to follow changes.
-            if($tableDetail->hasColumn('lastActivityTime')){
+            if ($tableDetail->hasColumn('lastActivityTime')) {
                 $lastActivityTime = $this->connection->fetchColumn('SELECT MAX(lastActivityTime) FROM '.$tableName);
-            } else{
+            } else {
                 $lastActivityTime = $this->connection->fetchColumn('SELECT MAX(createdTime) FROM '.$tableName);
             }
             if ($lastActivityTime !== null) {