View GitHub Repository zoho-crm-copy-db

Schedule Inspection
Subscribe
Completed
Push — 3.1.1 ( a3e855...47adc0 )
by
unknown
01:26
created
Status
Category
Toggle Patches
src/ZohoDatabaseModelSync.php 2 patches
Switch Indentation   +86 added lines, -86 removed lines patch added patch discarded remove patch 
@@ -110,75 +110,75 @@  discard block
 
 block discarded – undo
110 110 
             $options = [];
111 111 
             // Note: full list of types available here: https://www.zoho.com/crm/help/customization/custom-fields.html
112 112 
             switch ($field->getType()) {
113 
-            case 'lookup':
114 
-                $type = 'string';
115 
-                $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 100;
116 
-                $index = true;
117 
-                break;
118 
-            case 'userlookup':
119 
-            case 'ownerlookup':
120 
-                $type = 'string';
121 
-                $index = true;
122 
-                $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 25;
123 
-                break;
124 
-            case 'formula':
125 
-                // Note: a Formula can return any type, but we have no way to know which type it returns...
126 
-                $type = 'string';
127 
-                $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 100;
128 
-                break;
129 
-            case 'datetime':
130 
-                $type = 'datetime';
131 
-                break;
132 
-            case 'date':
133 
-                $type = 'date';
134 
-                break;
135 
-            case 'boolean':
136 
-                $type = 'boolean';
137 
-                break;
138 
-            case 'bigint':
139 
-                $type = 'bigint';
140 
-                break;
141 
-            case 'fileupload':
142 
-            case 'phone':
143 
-            case 'text':
144 
-            case 'url':
145 
-            case 'email':
146 
-            case 'picklist':
147 
-            case 'website':
148 
-                $type = 'string';
149 
-                $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 255;
150 
-                break;
151 
-            case 'textarea':
152 
-            case 'multiselectlookup':
153 
-            case 'multiuserlookup':
154 
-            case 'multiselectpicklist':
155 
-                $type = 'text';
156 
-                break;
157 
-            case 'percent':
158 
-                $type = 'integer';
159 
-                break;
160 
-            case 'double':
161 
-                $type = 'float';
162 
-                break;
163 
-            case 'autonumber':
164 
-            case 'integer':
165 
-                $type = 'integer';
166 
-                $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 255;
167 
-                break;
168 
-            case 'currency':
169 
-            case 'decimal':
170 
-                $type = 'decimal';
171 
-                $options['scale'] = 2;
172 
-                break;
173 
-            case 'consent_lookup':
174 
-            case 'profileimage':
175 
-            case 'ALARM':
176 
-            case 'RRULE':
177 
-            case 'event_reminder':
178 
-                continue 2;
113 
+                case 'lookup':
114 
+                    $type = 'string';
115 
+                    $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 100;
116 
+                    $index = true;
117 
+                    break;
118 
+                case 'userlookup':
119 
+                case 'ownerlookup':
120 
+                    $type = 'string';
121 
+                    $index = true;
122 
+                    $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 25;
123 
+                    break;
124 
+                case 'formula':
125 
+                    // Note: a Formula can return any type, but we have no way to know which type it returns...
126 
+                    $type = 'string';
127 
+                    $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 100;
128 
+                    break;
129 
+                case 'datetime':
130 
+                    $type = 'datetime';
131 
+                    break;
132 
+                case 'date':
133 
+                    $type = 'date';
134 
+                    break;
135 
+                case 'boolean':
136 
+                    $type = 'boolean';
137 
+                    break;
138 
+                case 'bigint':
139 
+                    $type = 'bigint';
140 
+                    break;
141 
+                case 'fileupload':
142 
+                case 'phone':
143 
+                case 'text':
144 
+                case 'url':
145 
+                case 'email':
146 
+                case 'picklist':
147 
+                case 'website':
148 
+                    $type = 'string';
149 
+                    $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 255;
150 
+                    break;
151 
+                case 'textarea':
152 
+                case 'multiselectlookup':
153 
+                case 'multiuserlookup':
154 
+                case 'multiselectpicklist':
155 
+                    $type = 'text';
179 156 
                     break;
180 
-            default:
181 
-                throw new \RuntimeException('Unknown type "'.$field->getType().'"');
157 
+                case 'percent':
158 
+                    $type = 'integer';
159 
+                    break;
160 
+                case 'double':
161 
+                    $type = 'float';
162 
+                    break;
163 
+                case 'autonumber':
164 
+                case 'integer':
165 
+                    $type = 'integer';
166 
+                    $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 255;
167 
+                    break;
168 
+                case 'currency':
169 
+                case 'decimal':
170 
+                    $type = 'decimal';
171 
+                    $options['scale'] = 2;
172 
+                    break;
173 
+                case 'consent_lookup':
174 
+                case 'profileimage':
175 
+                case 'ALARM':
176 
+                case 'RRULE':
177 
+                case 'event_reminder':
178 
+                    continue 2;
179 
+                        break;
180 
+                default:
181 
+                    throw new \RuntimeException('Unknown type "'.$field->getType().'"');
182 182 
             }
183 183
184 184 
             // For MySQL, the maximum row size is 65535 bytes.
 
@@ -237,24 +237,24 @@  discard block
 
 block discarded – undo
237 237 
             $length = null;
238 238 
             $index = false;
239 239 
             switch ($field) {
240 
-            case 'zuid':
241 
-                $type = 'string';
242 
-                $length = 100;
243 
-                $index = true;
244 
-                break;
245 
-            case 'name':
246 
-            case 'email':
247 
-                $type = 'string';
248 
-                $length = 255;
249 
-                $index = true;
250 
-                break;
251 
-            case 'phone':
252 
-            case 'website':
253 
-                $type = 'text';
254 
-                break;
255 
-            default:
256 
-                $type = 'string';
257 
-                $length = 100;
240 
+                case 'zuid':
241 
+                    $type = 'string';
242 
+                    $length = 100;
243 
+                    $index = true;
244 
+                    break;
245 
+                case 'name':
246 
+                case 'email':
247 
+                    $type = 'string';
248 
+                    $length = 255;
249 
+                    $index = true;
250 
+                    break;
251 
+                case 'phone':
252 
+                case 'website':
253 
+                    $type = 'text';
254 
+                    break;
255 
+                default:
256 
+                    $type = 'string';
257 
+                    $length = 100;
258 258 
             }
259 259
260 260 
             $options = [];
Please login to merge, or discard this patch.
Spacing   +9 added lines, -9 removed lines patch added patch discarded remove patch 
@@ -93,15 +93,15 @@  discard block
 
 block discarded – undo
93 93 
         $table = $schema->createTable($tableName);
94 94
95 95 
         //@Temporary fix to use Mysql5.7 not strict
96 
-        $table->addColumn('uid', 'string', ['length' => 36,'notnull'=>false]);
97 
-        $table->addColumn('id', 'string', ['length' => 100,'notnull'=>false]);
96 
+        $table->addColumn('uid', 'string', ['length' => 36, 'notnull'=>false]);
97 
+        $table->addColumn('id', 'string', ['length' => 100, 'notnull'=>false]);
98 98 
         $table->addUniqueIndex(['id']);
99 99 
         $table->setPrimaryKey(['uid']);
100 100
101 101 
         foreach ($dao->getFields() as $field) {
102 102 
             $columnName = $field->getName();
103 103 
             //It seems sometime we can have the same field twice in the list of fields from the API.
104 
-            if($table->hasColumn($columnName)) {
104 
+            if ($table->hasColumn($columnName)) {
105 105 
                 continue;
106 106 
             }
107 107 
 
@@ -112,19 +112,19 @@  discard block
 
 block discarded – undo
112 112 
             switch ($field->getType()) {
113 113 
             case 'lookup':
114 114 
                 $type = 'string';
115 
-                $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 100;
115 
+                $length = $field->getMaxlength() && $field->getMaxlength() > 0 ? $field->getMaxlength() : 100;
116 116 
                 $index = true;
117 117 
                 break;
118 118 
             case 'userlookup':
119 119 
             case 'ownerlookup':
120 120 
                 $type = 'string';
121 121 
                 $index = true;
122 
-                $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 25;
122 
+                $length = $field->getMaxlength() && $field->getMaxlength() > 0 ? $field->getMaxlength() : 25;
123 123 
                 break;
124 124 
             case 'formula':
125 125 
                 // Note: a Formula can return any type, but we have no way to know which type it returns...
126 126 
                 $type = 'string';
127 
-                $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 100;
127 
+                $length = $field->getMaxlength() && $field->getMaxlength() > 0 ? $field->getMaxlength() : 100;
128 128 
                 break;
129 129 
             case 'datetime':
130 130 
                 $type = 'datetime';
 
@@ -146,7 +146,7 @@  discard block
 
 block discarded – undo
146 146 
             case 'picklist':
147 147 
             case 'website':
148 148 
                 $type = 'string';
149 
-                $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 255;
149 
+                $length = $field->getMaxlength() && $field->getMaxlength() > 0 ? $field->getMaxlength() : 255;
150 150 
                 break;
151 151 
             case 'textarea':
152 152 
             case 'multiselectlookup':
 
@@ -163,7 +163,7 @@  discard block
 
 block discarded – undo
163 163 
             case 'autonumber':
164 164 
             case 'integer':
165 165 
                 $type = 'integer';
166 
-                $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 255;
166 
+                $length = $field->getMaxlength() && $field->getMaxlength() > 0 ? $field->getMaxlength() : 255;
167 167 
                 break;
168 168 
             case 'currency':
169 169 
             case 'decimal':
 
@@ -227,7 +227,7 @@  discard block
 
 block discarded – undo
227 227 
         $schema = new Schema();
228 228 
         $table = $schema->createTable($tableName);
229 229
230 
-        $table->addColumn('id', 'string', ['length' => 100,'notnull'=>false]);
230 
+        $table->addColumn('id', 'string', ['length' => 100, 'notnull'=>false]);
231 231 
         $table->setPrimaryKey(['id']);
232 232 
         foreach (ZCRMUser::$defaultKeys as $field) {
233 233 
             if ($field === 'id') {
Please login to merge, or discard this patch.
src/LocalChangesTracker.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch 
@@ -49,7 +49,7 @@  discard block
 
 block discarded – undo
49 49 
         $localDelete = $schema->createTable('local_delete');
50 50 
         $localDelete->addColumn('table_name', 'string', ['length' => 100]);
51 51 
         $localDelete->addColumn('uid', 'string', ['length' => 36]);
52 
-        $localDelete->addColumn('id', 'string', ['length' => 100,'notnull'=>false]);
52 
+        $localDelete->addColumn('id', 'string', ['length' => 100, 'notnull'=>false]);
53 53 
         $localDelete->setPrimaryKey(array('table_name', 'uid'));
54 54 
         $localDelete->addUniqueIndex(['id', 'table_name']);
55 55 
 
@@ -89,7 +89,7 @@  discard block
 
 block discarded – undo
89 89 
     public function createUuidInsertTrigger(Table $table)
90 90 
     {
91 91 
         $triggerName = sprintf('TRG_%s_SETUUIDBEFOREINSERT', $table->getName());
92 
-        $this->logger->info('Creating ' . $triggerName . ' trigger for table ' . $table->getName() . '...');
92 
+        $this->logger->info('Creating '.$triggerName.' trigger for table '.$table->getName().'...');
93 93
94 94 
         //Fix - temporary MySQL 5.7 strict mode
95 95 
         $sql = sprintf(
 
@@ -118,7 +118,7 @@  discard block
 
 block discarded – undo
118 118 
     public function createInsertTrigger(Table $table)
119 119 
     {
120 120 
         $triggerName = sprintf('TRG_%s_ONINSERT', $table->getName());
121 
-        $this->logger->info('Creating ' . $triggerName . ' trigger for table ' . $table->getName() . '...');
121 
+        $this->logger->info('Creating '.$triggerName.' trigger for table '.$table->getName().'...');
122 122
123 123 
         $tableNameQuoted = $this->connection->quote($table->getName());
124 124 
 
@@ -145,7 +145,7 @@  discard block
 
 block discarded – undo
145 145 
     public function createDeleteTrigger(Table $table)
146 146 
     {
147 147 
         $triggerName = sprintf('TRG_%s_ONDELETE', $table->getName());
148 
-        $this->logger->info('Creating ' . $triggerName . ' trigger for table ' . $table->getName() . '...');
148 
+        $this->logger->info('Creating '.$triggerName.' trigger for table '.$table->getName().'...');
149 149
150 150 
         $tableNameQuoted = $this->connection->quote($table->getName());
151 151 
 
@@ -172,7 +172,7 @@  discard block
 
 block discarded – undo
172 172 
     public function createUpdateTrigger(Table $table)
173 173 
     {
174 174 
         $triggerName = sprintf('TRG_%s_ONUPDATE', $table->getName());
175 
-        $this->logger->info('Creating ' . $triggerName . ' trigger for table ' . $table->getName() . '...');
175 
+        $this->logger->info('Creating '.$triggerName.' trigger for table '.$table->getName().'...');
176 176
177 177 
         $innerCode = '';
178 178
Please login to merge, or discard this patch.