mikopbx /
Core
| Conditions | 18 |
| Paths | 117 |
| Total Lines | 128 |
| Code Lines | 107 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 0 | ||
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
| 1 | <?php |
||
| 173 | private function prepareConditionsForSearchPhrases(string &$searchPhrase, array &$parameters): void |
||
| 174 | { |
||
| 175 | $parameters['conditions'] = ''; |
||
| 176 | |||
| 177 | // Поищем линкдиды, и если они там есть, то игнориуем все предыдущие параметры запроса |
||
| 178 | if (preg_match_all("/mikopbx-\d+.\d+/", $searchPhrase, $matches) && count($matches[0]) === 1) { |
||
| 179 | $parameters['conditions'] = 'linkedid = :SearchPhrase:'; |
||
| 180 | $parameters['bind']['SearchPhrase'] = $matches[0][0]; |
||
| 181 | |||
| 182 | return; |
||
| 183 | } |
||
| 184 | |||
| 185 | // Поищем даты |
||
| 186 | if (preg_match_all("/\d{2}\/\d{2}\/\d{4}/", $searchPhrase, $matches)) { |
||
| 187 | if (count($matches[0]) === 1) { |
||
| 188 | $date = DateTime::createFromFormat('d/m/Y', $matches[0][0]); |
||
| 189 | $requestedDate = $date->format('Y-m-d'); |
||
| 190 | $tomorrowDate = $date->modify('+1 day')->format('Y-m-d'); |
||
| 191 | $parameters['conditions'] .= 'start BETWEEN :dateFromPhrase1: AND :dateFromPhrase2:'; |
||
| 192 | $parameters['bind']['dateFromPhrase1'] = $requestedDate; |
||
| 193 | $parameters['bind']['dateFromPhrase2'] = $tomorrowDate; |
||
| 194 | $searchPhrase = str_replace($matches[0][0], "", $searchPhrase); |
||
| 195 | } elseif (count($matches[0]) === 2) { |
||
| 196 | $parameters['conditions'] .= 'start BETWEEN :dateFromPhrase1: AND :dateFromPhrase2:'; |
||
| 197 | $date = DateTime::createFromFormat('d/m/Y', $matches[0][0]); |
||
| 198 | $requestedDate = $date->format('Y-m-d'); |
||
| 199 | $parameters['bind']['dateFromPhrase1'] = $requestedDate; |
||
| 200 | $date = DateTime::createFromFormat('d/m/Y', $matches[0][1]); |
||
| 201 | $tomorrowDate = $date->modify('+1 day')->format('Y-m-d'); |
||
| 202 | $parameters['bind']['dateFromPhrase2'] = $tomorrowDate; |
||
| 203 | $searchPhrase = str_replace( |
||
| 204 | [$matches[0][0], $matches[0][1]], |
||
| 205 | '', |
||
| 206 | $searchPhrase |
||
| 207 | ); |
||
| 208 | } |
||
| 209 | } |
||
| 210 | |||
| 211 | // Поищем номера телефонов |
||
| 212 | $searchPhrase = str_replace(['(', ')', '-', '+'], '', $searchPhrase); |
||
| 213 | |||
| 214 | if (preg_match_all("/\d+/", $searchPhrase, $matches)) { |
||
| 215 | $needCloseAnd = false; |
||
| 216 | $extensionsLength = PbxSettings::getValueByKey('PBXInternalExtensionLength'); |
||
| 217 | if ($parameters['conditions'] !== '') { |
||
| 218 | $parameters['conditions'] .= ' AND ('; |
||
| 219 | $needCloseAnd = true; |
||
| 220 | } |
||
| 221 | if (count($matches[0]) === 1) { |
||
| 222 | if ($extensionsLength === strlen($matches[0][0])) { |
||
| 223 | $parameters['conditions'] .= 'src_num = :SearchPhrase1: OR dst_num = :SearchPhrase2:'; |
||
| 224 | $parameters['bind']['SearchPhrase1'] = $matches[0][0]; |
||
| 225 | $parameters['bind']['SearchPhrase2'] = $matches[0][0]; |
||
| 226 | } else { |
||
| 227 | $seekNumber = substr($matches[0][0], -9); |
||
| 228 | $parameters['conditions'] .= 'src_num LIKE :SearchPhrase1: OR dst_num LIKE :SearchPhrase2: OR did LIKE :SearchPhrase3:'; |
||
| 229 | $parameters['bind']['SearchPhrase1'] = "%{$seekNumber}%"; |
||
| 230 | $parameters['bind']['SearchPhrase2'] = "%{$seekNumber}%"; |
||
| 231 | $parameters['bind']['SearchPhrase3'] = "%{$seekNumber}%"; |
||
| 232 | } |
||
| 233 | |||
| 234 | $searchPhrase = str_replace($matches[0][0], '', $searchPhrase); |
||
| 235 | } elseif (count($matches[0]) === 2) { |
||
| 236 | if ($extensionsLength === strlen($matches[0][0]) && $extensionsLength === strlen($matches[0][1])) { |
||
| 237 | $parameters['conditions'] .= '(src_num = :SearchPhrase1: AND dst_num = :SearchPhrase2:)'; |
||
| 238 | $parameters['conditions'] .= ' OR (src_num = :SearchPhrase3: AND dst_num = :SearchPhrase4:)'; |
||
| 239 | $parameters['conditions'] .= ' OR (src_num = :SearchPhrase5: AND did = :SearchPhrase6:)'; |
||
| 240 | $parameters['conditions'] .= ' OR (src_num = :SearchPhrase8: AND did = :SearchPhrase7:)'; |
||
| 241 | $parameters['bind']['SearchPhrase1'] = $matches[0][0]; |
||
| 242 | $parameters['bind']['SearchPhrase2'] = $matches[0][1]; |
||
| 243 | $parameters['bind']['SearchPhrase3'] = $matches[0][1]; |
||
| 244 | $parameters['bind']['SearchPhrase4'] = $matches[0][0]; |
||
| 245 | $parameters['bind']['SearchPhrase5'] = $matches[0][1]; |
||
| 246 | $parameters['bind']['SearchPhrase6'] = $matches[0][0]; |
||
| 247 | $parameters['bind']['SearchPhrase7'] = $matches[0][1]; |
||
| 248 | $parameters['bind']['SearchPhrase8'] = $matches[0][0]; |
||
| 249 | } elseif ($extensionsLength === strlen($matches[0][0]) && $extensionsLength !== strlen( |
||
| 250 | $matches[0][1] |
||
| 251 | )) { |
||
| 252 | $seekNumber = substr($matches[0][1], -9); |
||
| 253 | $parameters['conditions'] .= '(src_num = :SearchPhrase1: AND dst_num LIKE :SearchPhrase2:)'; |
||
| 254 | $parameters['conditions'] .= ' OR (src_num LIKE :SearchPhrase3: AND dst_num = :SearchPhrase4:)'; |
||
| 255 | $parameters['conditions'] .= ' OR (src_num LIKE :SearchPhrase5: AND did = :SearchPhrase6:)'; |
||
| 256 | $parameters['conditions'] .= ' OR (src_num = :SearchPhrase8: AND did LIKE :SearchPhrase7:)'; |
||
| 257 | $parameters['bind']['SearchPhrase1'] = $matches[0][0]; |
||
| 258 | $parameters['bind']['SearchPhrase2'] = "%{$seekNumber}%"; |
||
| 259 | $parameters['bind']['SearchPhrase3'] = "%{$seekNumber}%"; |
||
| 260 | $parameters['bind']['SearchPhrase4'] = $matches[0][0]; |
||
| 261 | $parameters['bind']['SearchPhrase5'] = "%{$seekNumber}%"; |
||
| 262 | $parameters['bind']['SearchPhrase6'] = $matches[0][0]; |
||
| 263 | $parameters['bind']['SearchPhrase7'] = "%{$seekNumber}%"; |
||
| 264 | $parameters['bind']['SearchPhrase8'] = $matches[0][0]; |
||
| 265 | } elseif ($extensionsLength !== strlen($matches[0][0]) && $extensionsLength === strlen( |
||
| 266 | $matches[0][1] |
||
| 267 | )) { |
||
| 268 | $seekNumber = substr($matches[0][0], -9); |
||
| 269 | $parameters['conditions'] .= '(src_num LIKE :SearchPhrase1: AND dst_num = :SearchPhrase2:)'; |
||
| 270 | $parameters['conditions'] .= ' OR (src_num = :SearchPhrase3: AND dst_num LIKE :SearchPhrase4:)'; |
||
| 271 | $parameters['conditions'] .= ' OR (src_num LIKE :SearchPhrase5: AND did = :SearchPhrase6:)'; |
||
| 272 | $parameters['conditions'] .= ' OR (src_num = :SearchPhrase8: AND did LIKE :SearchPhrase7:)'; |
||
| 273 | $parameters['bind']['SearchPhrase1'] = "%{$seekNumber}%"; |
||
| 274 | $parameters['bind']['SearchPhrase2'] = $matches[0][1]; |
||
| 275 | $parameters['bind']['SearchPhrase3'] = $matches[0][1]; |
||
| 276 | $parameters['bind']['SearchPhrase4'] = "%{$seekNumber}%"; |
||
| 277 | $parameters['bind']['SearchPhrase5'] = "%{$seekNumber}%"; |
||
| 278 | $parameters['bind']['SearchPhrase6'] = $matches[0][1]; |
||
| 279 | $parameters['bind']['SearchPhrase7'] = "%{$seekNumber}%"; |
||
| 280 | $parameters['bind']['SearchPhrase8'] = $matches[0][1]; |
||
| 281 | } else { |
||
| 282 | $seekNumber0 = substr($matches[0][0], -9); |
||
| 283 | $seekNumber1 = substr($matches[0][1], -9); |
||
| 284 | $parameters['conditions'] .= '(src_num LIKE :SearchPhrase1: AND dst_num LIKE :SearchPhrase2:)'; |
||
| 285 | $parameters['conditions'] .= ' OR (src_num LIKE :SearchPhrase3: AND dst_num LIKE :SearchPhrase4:)'; |
||
| 286 | $parameters['conditions'] .= ' OR (src_num LIKE :SearchPhrase5: AND did LIKE :SearchPhrase6:)'; |
||
| 287 | $parameters['conditions'] .= ' OR (src_num LIKE :SearchPhrase7: AND did LIKE :SearchPhrase8:)'; |
||
| 288 | $parameters['bind']['SearchPhrase1'] = "%{$seekNumber0}%"; |
||
| 289 | $parameters['bind']['SearchPhrase2'] = "%{$seekNumber1}%"; |
||
| 290 | $parameters['bind']['SearchPhrase3'] = "%{$seekNumber1}%"; |
||
| 291 | $parameters['bind']['SearchPhrase4'] = "%{$seekNumber0}%"; |
||
| 292 | $parameters['bind']['SearchPhrase5'] = "%{$seekNumber0}%"; |
||
| 293 | $parameters['bind']['SearchPhrase6'] = "%{$seekNumber1}%"; |
||
| 294 | $parameters['bind']['SearchPhrase7'] = "%{$seekNumber1}%"; |
||
| 295 | $parameters['bind']['SearchPhrase8'] = "%{$seekNumber0}%"; |
||
| 296 | } |
||
| 297 | $searchPhrase = str_replace([$matches[0][0], $matches[0][1]], '', $searchPhrase); |
||
| 298 | } |
||
| 299 | if ($needCloseAnd) { |
||
| 300 | $parameters['conditions'] .= ')'; |
||
| 301 | } |
||
| 304 | } |
