@@ -110,75 +110,75 @@ discard block |
||
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 |
||
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 = []; |
@@ -93,15 +93,15 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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') { |
@@ -49,7 +49,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |