@@ -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 |