Wabel /
zoho-crm-copy-db
@@ -110,80 +110,80 @@ 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 'fileupload': |
|
| 114 | - $type = 'string'; |
|
| 115 | - $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 255; |
|
| 116 | - break; |
|
| 117 | - case 'lookup': |
|
| 118 | - $type = 'string'; |
|
| 119 | - $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 100; |
|
| 120 | - $index = true; |
|
| 121 | - break; |
|
| 122 | - case 'userlookup': |
|
| 123 | - case 'ownerlookup': |
|
| 124 | - $type = 'string'; |
|
| 125 | - $index = true; |
|
| 126 | - $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 25; |
|
| 127 | - break; |
|
| 128 | - case 'formula': |
|
| 129 | - // Note: a Formula can return any type, but we have no way to know which type it returns... |
|
| 130 | - $type = 'string'; |
|
| 131 | - $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 100; |
|
| 132 | - break; |
|
| 133 | - case 'datetime': |
|
| 134 | - $type = 'datetime'; |
|
| 135 | - break; |
|
| 136 | - case 'date': |
|
| 137 | - $type = 'date'; |
|
| 138 | - break; |
|
| 139 | - case 'boolean': |
|
| 140 | - $type = 'boolean'; |
|
| 141 | - break; |
|
| 142 | - case 'textarea': |
|
| 143 | - $type = 'text'; |
|
| 144 | - break; |
|
| 145 | - case 'bigint': |
|
| 146 | - $type = 'bigint'; |
|
| 147 | - break; |
|
| 148 | - case 'phone': |
|
| 149 | - case 'text': |
|
| 150 | - case 'url': |
|
| 151 | - case 'email': |
|
| 152 | - case 'picklist': |
|
| 153 | - case 'website': |
|
| 154 | - $type = 'string'; |
|
| 155 | - $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 255; |
|
| 156 | - break; |
|
| 157 | - case 'multiselectlookup': |
|
| 158 | - case 'multiuserlookup': |
|
| 159 | - case 'multiselectpicklist': |
|
| 160 | - $type = 'text'; |
|
| 161 | - break; |
|
| 162 | - case 'percent': |
|
| 163 | - $type = 'integer'; |
|
| 164 | - break; |
|
| 165 | - case 'double': |
|
| 166 | - $type = 'float'; |
|
| 167 | - break; |
|
| 168 | - case 'autonumber': |
|
| 169 | - case 'integer': |
|
| 170 | - $type = 'integer'; |
|
| 171 | - $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 255; |
|
| 172 | - break; |
|
| 173 | - case 'currency': |
|
| 174 | - case 'decimal': |
|
| 175 | - $type = 'decimal'; |
|
| 176 | - $options['scale'] = 2; |
|
| 177 | - break; |
|
| 178 | - case 'consent_lookup': |
|
| 179 | - case 'profileimage': |
|
| 180 | - case 'ALARM': |
|
| 181 | - case 'RRULE': |
|
| 182 | - case 'event_reminder': |
|
| 183 | - continue 2; |
|
| 113 | + case 'fileupload': |
|
| 114 | + $type = 'string'; |
|
| 115 | + $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 255; |
|
| 184 | 116 | break; |
| 185 | - default: |
|
| 186 | - throw new \RuntimeException('Unknown type "'.$field->getType().'"'); |
|
| 117 | + case 'lookup': |
|
| 118 | + $type = 'string'; |
|
| 119 | + $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 100; |
|
| 120 | + $index = true; |
|
| 121 | + break; |
|
| 122 | + case 'userlookup': |
|
| 123 | + case 'ownerlookup': |
|
| 124 | + $type = 'string'; |
|
| 125 | + $index = true; |
|
| 126 | + $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 25; |
|
| 127 | + break; |
|
| 128 | + case 'formula': |
|
| 129 | + // Note: a Formula can return any type, but we have no way to know which type it returns... |
|
| 130 | + $type = 'string'; |
|
| 131 | + $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 100; |
|
| 132 | + break; |
|
| 133 | + case 'datetime': |
|
| 134 | + $type = 'datetime'; |
|
| 135 | + break; |
|
| 136 | + case 'date': |
|
| 137 | + $type = 'date'; |
|
| 138 | + break; |
|
| 139 | + case 'boolean': |
|
| 140 | + $type = 'boolean'; |
|
| 141 | + break; |
|
| 142 | + case 'textarea': |
|
| 143 | + $type = 'text'; |
|
| 144 | + break; |
|
| 145 | + case 'bigint': |
|
| 146 | + $type = 'bigint'; |
|
| 147 | + break; |
|
| 148 | + case 'phone': |
|
| 149 | + case 'text': |
|
| 150 | + case 'url': |
|
| 151 | + case 'email': |
|
| 152 | + case 'picklist': |
|
| 153 | + case 'website': |
|
| 154 | + $type = 'string'; |
|
| 155 | + $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 255; |
|
| 156 | + break; |
|
| 157 | + case 'multiselectlookup': |
|
| 158 | + case 'multiuserlookup': |
|
| 159 | + case 'multiselectpicklist': |
|
| 160 | + $type = 'text'; |
|
| 161 | + break; |
|
| 162 | + case 'percent': |
|
| 163 | + $type = 'integer'; |
|
| 164 | + break; |
|
| 165 | + case 'double': |
|
| 166 | + $type = 'float'; |
|
| 167 | + break; |
|
| 168 | + case 'autonumber': |
|
| 169 | + case 'integer': |
|
| 170 | + $type = 'integer'; |
|
| 171 | + $length = $field->getMaxlength() && $field->getMaxlength() > 0?$field->getMaxlength() : 255; |
|
| 172 | + break; |
|
| 173 | + case 'currency': |
|
| 174 | + case 'decimal': |
|
| 175 | + $type = 'decimal'; |
|
| 176 | + $options['scale'] = 2; |
|
| 177 | + break; |
|
| 178 | + case 'consent_lookup': |
|
| 179 | + case 'profileimage': |
|
| 180 | + case 'ALARM': |
|
| 181 | + case 'RRULE': |
|
| 182 | + case 'event_reminder': |
|
| 183 | + continue 2; |
|
| 184 | + break; |
|
| 185 | + default: |
|
| 186 | + throw new \RuntimeException('Unknown type "'.$field->getType().'"'); |
|
| 187 | 187 | } |
| 188 | 188 | |
| 189 | 189 | if ($length) { |
@@ -228,24 +228,24 @@ discard block |
||
| 228 | 228 | $length = null; |
| 229 | 229 | $index = false; |
| 230 | 230 | switch ($field) { |
| 231 | - case 'zuid': |
|
| 232 | - $type = 'string'; |
|
| 233 | - $length = 100; |
|
| 234 | - $index = true; |
|
| 235 | - break; |
|
| 236 | - case 'name': |
|
| 237 | - case 'email': |
|
| 238 | - $type = 'string'; |
|
| 239 | - $length = 255; |
|
| 240 | - $index = true; |
|
| 241 | - break; |
|
| 242 | - case 'phone': |
|
| 243 | - case 'website': |
|
| 244 | - $type = 'text'; |
|
| 245 | - break; |
|
| 246 | - default: |
|
| 247 | - $type = 'string'; |
|
| 248 | - $length = 100; |
|
| 231 | + case 'zuid': |
|
| 232 | + $type = 'string'; |
|
| 233 | + $length = 100; |
|
| 234 | + $index = true; |
|
| 235 | + break; |
|
| 236 | + case 'name': |
|
| 237 | + case 'email': |
|
| 238 | + $type = 'string'; |
|
| 239 | + $length = 255; |
|
| 240 | + $index = true; |
|
| 241 | + break; |
|
| 242 | + case 'phone': |
|
| 243 | + case 'website': |
|
| 244 | + $type = 'text'; |
|
| 245 | + break; |
|
| 246 | + default: |
|
| 247 | + $type = 'string'; |
|
| 248 | + $length = 100; |
|
| 249 | 249 | } |
| 250 | 250 | |
| 251 | 251 | $options = []; |
