@@ -276,7 +276,7 @@ discard block |
||
| 276 | 276 | $query->andWhere('[[o]].[[_deleted]] = 0'); |
| 277 | 277 | if ($inFull) { |
| 278 | 278 | $tableName = $this->getTableFromClassType($classType); |
| 279 | - $query->innerJoin('{{' . $tableName . '}} t', '[[o]].[[_uuid]]=[[t]].[[_uuid]]'); |
|
| 279 | + $query->innerJoin('{{'.$tableName.'}} t', '[[o]].[[_uuid]]=[[t]].[[_uuid]]'); |
|
| 280 | 280 | } |
| 281 | 281 | |
| 282 | 282 | if (is_array($order)) { |
@@ -319,7 +319,7 @@ discard block |
||
| 319 | 319 | $object->_created = $now; |
| 320 | 320 | $object->_updated = $now; |
| 321 | 321 | if (!$object->save()) |
| 322 | - throw new \RuntimeException("Couldn't create object: " . print_r($object->errors, true)); |
|
| 322 | + throw new \RuntimeException("Couldn't create object: ".print_r($object->errors, true)); |
|
| 323 | 323 | |
| 324 | 324 | // increment the class's object count |
| 325 | 325 | $class->count_total += 1; |
@@ -344,7 +344,7 @@ discard block |
||
| 344 | 344 | } |
| 345 | 345 | |
| 346 | 346 | if (count($fields)) |
| 347 | - $query = "INSERT INTO `$table` (`_uuid`, " . implode(', ', $fields) . ") VALUES ('{$object->_uuid}', " . implode(', ', $inserts) . ")"; |
|
| 347 | + $query = "INSERT INTO `$table` (`_uuid`, ".implode(', ', $fields).") VALUES ('{$object->_uuid}', ".implode(', ', $inserts).")"; |
|
| 348 | 348 | else |
| 349 | 349 | $query = "INSERT INTO `$table` (`_uuid`) VALUES ('{$object->_uuid}')"; |
| 350 | 350 | $command = neon()->db->createCommand($query); |
@@ -432,7 +432,7 @@ discard block |
||
| 432 | 432 | $table = $this->getTableFromClassType($object->_class_type); |
| 433 | 433 | $query = "SELECT `o`.*, `t`.* FROM `dds_object` `o` LEFT JOIN `$table` `t` ON `o`.`_uuid`=`t`.`_uuid` WHERE `o`.`_uuid`=:uuid LIMIT 1"; |
| 434 | 434 | $rows = neon()->db->createCommand($query)->bindValue(':uuid', $uuid)->queryAll(); |
| 435 | - $row = count($rows) > 0 ? $rows[0] : null; |
|
| 435 | + $row = count($rows) > 0 ? $rows[0] : null; |
|
| 436 | 436 | $this->convertFromDBToPHP($row, $this->getMemberLinks($uuid)); |
| 437 | 437 | return $row; |
| 438 | 438 | } |
@@ -490,7 +490,7 @@ discard block |
||
| 490 | 490 | if (count($updates) == 0) |
| 491 | 491 | return false; |
| 492 | 492 | |
| 493 | - $query = "UPDATE `$table` SET " . implode(', ', $updates) . " WHERE `_uuid`='$uuid' LIMIT 1"; |
|
| 493 | + $query = "UPDATE `$table` SET ".implode(', ', $updates)." WHERE `_uuid`='$uuid' LIMIT 1"; |
|
| 494 | 494 | neon()->db->createCommand($query)->bindValues($values)->execute(); |
| 495 | 495 | |
| 496 | 496 | // add or remove any links from the linking table |
@@ -529,7 +529,7 @@ discard block |
||
| 529 | 529 | $table = $this->getTableFromClassType($classType); |
| 530 | 530 | $memberStorage = $this->getMemberStorage($classType); |
| 531 | 531 | if (count($memberStorage) == 0) { |
| 532 | - throw new \InvalidArgumentException('Unknown or empty class type ' . $classType); |
|
| 532 | + throw new \InvalidArgumentException('Unknown or empty class type '.$classType); |
|
| 533 | 533 | } |
| 534 | 534 | |
| 535 | 535 | // see if we are recording changes into the change log |
@@ -572,14 +572,14 @@ discard block |
||
| 572 | 572 | $objectValues[$placeHolder] = $id; |
| 573 | 573 | $count++; |
| 574 | 574 | } |
| 575 | - $uuidClause = '(' . implode(',', $uuidClause) . ')'; |
|
| 575 | + $uuidClause = '('.implode(',', $uuidClause).')'; |
|
| 576 | 576 | |
| 577 | 577 | // update the latest changed |
| 578 | 578 | $db = neon()->db; |
| 579 | - $query = "UPDATE `dds_object` SET `_updated`=NOW() WHERE `_uuid` IN $uuidClause LIMIT " . count($uuids); |
|
| 579 | + $query = "UPDATE `dds_object` SET `_updated`=NOW() WHERE `_uuid` IN $uuidClause LIMIT ".count($uuids); |
|
| 580 | 580 | $db->createCommand($query)->bindValues($objectValues)->execute(); |
| 581 | 581 | // make the changes |
| 582 | - $query = "UPDATE `$table` SET " . implode(', ', $updates) . " WHERE `_uuid` IN $uuidClause LIMIT " . count($uuids); |
|
| 582 | + $query = "UPDATE `$table` SET ".implode(', ', $updates)." WHERE `_uuid` IN $uuidClause LIMIT ".count($uuids); |
|
| 583 | 583 | $db->createCommand($query)->bindValues($values)->execute(); |
| 584 | 584 | |
| 585 | 585 | // |
@@ -610,7 +610,7 @@ discard block |
||
| 610 | 610 | $object->_deleted = 1; |
| 611 | 611 | $object->_updated = date('Y-m-d H:i:s'); |
| 612 | 612 | if (!$object->save()) |
| 613 | - throw new \RuntimeException("Couldn't delete the object: " . print_r($object->errors, true)); |
|
| 613 | + throw new \RuntimeException("Couldn't delete the object: ".print_r($object->errors, true)); |
|
| 614 | 614 | // and update the class object deleted count |
| 615 | 615 | $class = null; |
| 616 | 616 | $this->findClass($object['_class_type'], $class); |
@@ -698,7 +698,7 @@ discard block |
||
| 698 | 698 | $object->_deleted = 0; |
| 699 | 699 | $object->_updated = date('Y-m-d H:i:s'); |
| 700 | 700 | if (!$object->save()) |
| 701 | - throw new \RuntimeException("Couldn't undelete the object: " . print_r($object->errors, true)); |
|
| 701 | + throw new \RuntimeException("Couldn't undelete the object: ".print_r($object->errors, true)); |
|
| 702 | 702 | |
| 703 | 703 | // and update the class object deleted count |
| 704 | 704 | $class = null; |
@@ -915,7 +915,7 @@ discard block |
||
| 915 | 915 | static $counter = 0; |
| 916 | 916 | $counter++; |
| 917 | 917 | // a randomly generated resultKey prevents db query chaching. |
| 918 | - $resultKey = $resultKey ? $resultKey : $request['requestKey'] . '_' . $counter; |
|
| 918 | + $resultKey = $resultKey ? $resultKey : $request['requestKey'].'_'.$counter; |
|
| 919 | 919 | $request['resultKey'] = $resultKey; |
| 920 | 920 | if (!array_key_exists($request['requestKey'], self::$_requestResultsCache)) |
| 921 | 921 | $this->convertRequestToSql($request); |
@@ -1091,7 +1091,7 @@ discard block |
||
| 1091 | 1091 | $clauseSql[] = $filter['filterSql']; |
| 1092 | 1092 | unset($filter['sql']); |
| 1093 | 1093 | } |
| 1094 | - $filters['sql'] = '(' . implode(') OR (', $clauseSql) . ')'; |
|
| 1094 | + $filters['sql'] = '('.implode(') OR (', $clauseSql).')'; |
|
| 1095 | 1095 | } |
| 1096 | 1096 | return; |
| 1097 | 1097 | } |
@@ -1103,7 +1103,7 @@ discard block |
||
| 1103 | 1103 | $filter = (in_array($filters[0], $links) ? "`link_{$filters[0]}`.`to_id`" : $this->quoteField($filters[0])); |
| 1104 | 1104 | $filterKeys[$filters[0]] = $filters[0]; |
| 1105 | 1105 | if ($this->operatorTakesObject($filters[1]) && isset($filters[2])) |
| 1106 | - $filters['itemSql'] = $filters['sql'] = "$filter " . $this->prepareForPDO($filters[1], $filters[2]); |
|
| 1106 | + $filters['itemSql'] = $filters['sql'] = "$filter ".$this->prepareForPDO($filters[1], $filters[2]); |
|
| 1107 | 1107 | else { |
| 1108 | 1108 | $filters['itemSql'] = $filters['sql'] = "$filter $filters[1]"; |
| 1109 | 1109 | } |
@@ -1117,7 +1117,7 @@ discard block |
||
| 1117 | 1117 | throw new \InvalidArgumentException("Daedalus: Cannot pass an *array* of values with an operator of $operator"); |
| 1118 | 1118 | foreach ($value as $v) { |
| 1119 | 1119 | if (is_array($v)) |
| 1120 | - throw new \InvalidArgumentException("Daedalus: Cannot pass an *array* of *array* of values as filters (silly billy). You passed " . print_r($value, true)); |
|
| 1120 | + throw new \InvalidArgumentException("Daedalus: Cannot pass an *array* of *array* of values as filters (silly billy). You passed ".print_r($value, true)); |
|
| 1121 | 1121 | $count = count($this->boundValues); |
| 1122 | 1122 | $variable = ":var{$count}end"; |
| 1123 | 1123 | $this->boundValues[$variable] = $v; |
@@ -1128,7 +1128,7 @@ discard block |
||
| 1128 | 1128 | $operator = 'IN'; |
| 1129 | 1129 | if ($operator == '!=') |
| 1130 | 1130 | $operator = 'NOT IN'; |
| 1131 | - return "$operator (" . implode(',', $pdoValues) . ')'; |
|
| 1131 | + return "$operator (".implode(',', $pdoValues).')'; |
|
| 1132 | 1132 | } else { |
| 1133 | 1133 | $count = count($this->boundValues); |
| 1134 | 1134 | $variable = ":var{$count}end"; |
@@ -1162,11 +1162,11 @@ discard block |
||
| 1162 | 1162 | } |
| 1163 | 1163 | // allow negative ordering in mysql for nulls last |
| 1164 | 1164 | if (strpos($o, '-') === 0) |
| 1165 | - $clause[] = '-' . substr($o, 1) . " $d"; |
|
| 1165 | + $clause[] = '-'.substr($o, 1)." $d"; |
|
| 1166 | 1166 | else |
| 1167 | 1167 | $clause[] = "$o $d"; |
| 1168 | 1168 | } |
| 1169 | - return 'ORDER BY ' . implode(', ', $clause); |
|
| 1169 | + return 'ORDER BY '.implode(', ', $clause); |
|
| 1170 | 1170 | } |
| 1171 | 1171 | |
| 1172 | 1172 | /** |
@@ -1205,7 +1205,7 @@ discard block |
||
| 1205 | 1205 | if (!is_array($toLinks)) |
| 1206 | 1206 | $toLinks = [$toLinks]; |
| 1207 | 1207 | if (!$this->areUUIDs($toLinks)) |
| 1208 | - throw new \InvalidArgumentException("The toMemberLinks should be UUID64s. You passed in " . print_r($toLinks, true)); |
|
| 1208 | + throw new \InvalidArgumentException("The toMemberLinks should be UUID64s. You passed in ".print_r($toLinks, true)); |
|
| 1209 | 1209 | $toLinks = array_unique($toLinks); |
| 1210 | 1210 | |
| 1211 | 1211 | // |
@@ -1330,7 +1330,7 @@ discard block |
||
| 1330 | 1330 | $objectValues[$placeHolder] = $id; |
| 1331 | 1331 | $count++; |
| 1332 | 1332 | } |
| 1333 | - $uuidClause = '(' . implode(',', $uuidClause) . ')'; |
|
| 1333 | + $uuidClause = '('.implode(',', $uuidClause).')'; |
|
| 1334 | 1334 | $query = "SELECT [[_uuid]] FROM [[dds_object]] WHERE [[_class_type]]='$classType' AND [[_uuid]] IN $uuidClause"; |
| 1335 | 1335 | $checkedUuidResults = $db->createCommand($query)->bindValues($objectValues)->queryAll(); |
| 1336 | 1336 | return array_column($checkedUuidResults, '_uuid'); |
@@ -107,8 +107,9 @@ discard block |
||
| 107 | 107 | // set null result information about the request |
| 108 | 108 | $newData[$k] = ['start' => $r['limit']['start'], 'length' => 0, 'total' => $r['total'], 'rows' => []]; |
| 109 | 109 | $sql[] = $r['sql']; |
| 110 | - if ($r['totalSql']) |
|
| 111 | - $sql[] = $r['totalSql']; |
|
| 110 | + if ($r['totalSql']) { |
|
| 111 | + $sql[] = $r['totalSql']; |
|
| 112 | + } |
|
| 112 | 113 | $resultKey2RequestKey[$r['resultKey']] = $r['requestKey']; |
| 113 | 114 | } |
| 114 | 115 | } |
@@ -169,8 +170,9 @@ discard block |
||
| 169 | 170 | */ |
| 170 | 171 | public function runSingleObjectRequest($classType, array $filters = [], array $order = [], array $limit = [], $includeDeleted = false) |
| 171 | 172 | { |
| 172 | - if (empty($classType)) |
|
| 173 | - throw new \InvalidArgumentException('ClassType must be specified'); |
|
| 173 | + if (empty($classType)) { |
|
| 174 | + throw new \InvalidArgumentException('ClassType must be specified'); |
|
| 175 | + } |
|
| 174 | 176 | |
| 175 | 177 | // make sure that any currently queued requests from elsewhere are saved off the queue |
| 176 | 178 | $currentRequests = $this->popRequests(); |
@@ -253,16 +255,18 @@ discard block |
||
| 253 | 255 | public function listObjects($classType, &$total = null, $includeDeleted = false, $inFull = true, $start = 0, $length = 100, $order = null) |
| 254 | 256 | { |
| 255 | 257 | $classType = $this->canonicaliseRef($classType); |
| 256 | - if (empty($order)) |
|
| 257 | - $order = ['_created' => 'DESC']; |
|
| 258 | + if (empty($order)) { |
|
| 259 | + $order = ['_created' => 'DESC']; |
|
| 260 | + } |
|
| 258 | 261 | $order = $this->canonicaliseOrder($order); |
| 259 | 262 | |
| 260 | 263 | // get the total first |
| 261 | 264 | $class = null; |
| 262 | 265 | $this->findClass($classType, $class, true); |
| 263 | 266 | $total = $class->count_total; |
| 264 | - if (!$includeDeleted) |
|
| 265 | - $total -= $class->count_deleted; |
|
| 267 | + if (!$includeDeleted) { |
|
| 268 | + $total -= $class->count_deleted; |
|
| 269 | + } |
|
| 266 | 270 | |
| 267 | 271 | // now get the objects |
| 268 | 272 | $query = (new \neon\core\db\Query) |
@@ -272,8 +276,9 @@ discard block |
||
| 272 | 276 | ->offset($start) |
| 273 | 277 | ->limit($length); |
| 274 | 278 | |
| 275 | - if (!$includeDeleted) |
|
| 276 | - $query->andWhere('[[o]].[[_deleted]] = 0'); |
|
| 279 | + if (!$includeDeleted) { |
|
| 280 | + $query->andWhere('[[o]].[[_deleted]] = 0'); |
|
| 281 | + } |
|
| 277 | 282 | if ($inFull) { |
| 278 | 283 | $tableName = $this->getTableFromClassType($classType); |
| 279 | 284 | $query->innerJoin('{{' . $tableName . '}} t', '[[o]].[[_uuid]]=[[t]].[[_uuid]]'); |
@@ -288,8 +293,9 @@ discard block |
||
| 288 | 293 | $orderBits[] = "[[t]].$k $d"; |
| 289 | 294 | } |
| 290 | 295 | } |
| 291 | - if ($orderBits) |
|
| 292 | - $orderClause = implode(', ', $orderBits); |
|
| 296 | + if ($orderBits) { |
|
| 297 | + $orderClause = implode(', ', $orderBits); |
|
| 298 | + } |
|
| 293 | 299 | $query->orderBy($orderClause); |
| 294 | 300 | } |
| 295 | 301 | |
@@ -306,8 +312,9 @@ discard block |
||
| 306 | 312 | $class = null; |
| 307 | 313 | $classType = $this->canonicaliseRef($classType); |
| 308 | 314 | $this->findClass($classType, $class, true); |
| 309 | - if ($class->hasChangeLog()) |
|
| 310 | - $newValues = $data; |
|
| 315 | + if ($class->hasChangeLog()) { |
|
| 316 | + $newValues = $data; |
|
| 317 | + } |
|
| 311 | 318 | $table = $this->getTableFromClassType($classType); |
| 312 | 319 | |
| 313 | 320 | // create the new object |
@@ -318,8 +325,9 @@ discard block |
||
| 318 | 325 | $object->_class_type = $classType; |
| 319 | 326 | $object->_created = $now; |
| 320 | 327 | $object->_updated = $now; |
| 321 | - if (!$object->save()) |
|
| 322 | - throw new \RuntimeException("Couldn't create object: " . print_r($object->errors, true)); |
|
| 328 | + if (!$object->save()) { |
|
| 329 | + throw new \RuntimeException("Couldn't create object: " . print_r($object->errors, true)); |
|
| 330 | + } |
|
| 323 | 331 | |
| 324 | 332 | // increment the class's object count |
| 325 | 333 | $class->count_total += 1; |
@@ -343,10 +351,11 @@ discard block |
||
| 343 | 351 | } |
| 344 | 352 | } |
| 345 | 353 | |
| 346 | - if (count($fields)) |
|
| 347 | - $query = "INSERT INTO `$table` (`_uuid`, " . implode(', ', $fields) . ") VALUES ('{$object->_uuid}', " . implode(', ', $inserts) . ")"; |
|
| 348 | - else |
|
| 349 | - $query = "INSERT INTO `$table` (`_uuid`) VALUES ('{$object->_uuid}')"; |
|
| 354 | + if (count($fields)) { |
|
| 355 | + $query = "INSERT INTO `$table` (`_uuid`, " . implode(', ', $fields) . ") VALUES ('{$object->_uuid}', " . implode(', ', $inserts) . ")"; |
|
| 356 | + } else { |
|
| 357 | + $query = "INSERT INTO `$table` (`_uuid`) VALUES ('{$object->_uuid}')"; |
|
| 358 | + } |
|
| 350 | 359 | $command = neon()->db->createCommand($query); |
| 351 | 360 | $command->bindValues($values); |
| 352 | 361 | $command->execute(); |
@@ -354,8 +363,9 @@ discard block |
||
| 354 | 363 | // if there are any links then add these to the link table |
| 355 | 364 | $this->setMemberLinks($object->_uuid, $links); |
| 356 | 365 | |
| 357 | - if ($class->hasChangeLog()) |
|
| 358 | - $changeLogUuid = $this->createChangeLogEntry($class, 'ADD', $object->_uuid, [], $newValues); |
|
| 366 | + if ($class->hasChangeLog()) { |
|
| 367 | + $changeLogUuid = $this->createChangeLogEntry($class, 'ADD', $object->_uuid, [], $newValues); |
|
| 368 | + } |
|
| 359 | 369 | } catch (\Exception $e) { |
| 360 | 370 | // execution failed so clean up the object |
| 361 | 371 | $object->delete(); |
@@ -399,8 +409,9 @@ discard block |
||
| 399 | 409 | $objectsLinks = []; |
| 400 | 410 | $now = date('Y-m-d H:i:s'); |
| 401 | 411 | foreach ($chunkData as $row) { |
| 402 | - if ($hasChangeLog) |
|
| 403 | - $newValues = $row; |
|
| 412 | + if ($hasChangeLog) { |
|
| 413 | + $newValues = $row; |
|
| 414 | + } |
|
| 404 | 415 | // ddt table value - format row data and append the uuid |
| 405 | 416 | $this->convertFromPHPToDB($classType, $row, $links); |
| 406 | 417 | $uuid = (!empty($row['_uuid']) && $this->isUUID($row['_uuid'])) ? $row['_uuid'] : $this->generateUUID(); |
@@ -410,8 +421,9 @@ discard block |
||
| 410 | 421 | // object table row value |
| 411 | 422 | $objectDbRows[] = [$row['_uuid'], $classType, $now, $now]; |
| 412 | 423 | $objectsLinks[$row['_uuid']] = $links; |
| 413 | - if ($hasChangeLog) |
|
| 414 | - $this->createChangeLogEntry($class, 'ADD', $uuid, [], $newValues); |
|
| 424 | + if ($hasChangeLog) { |
|
| 425 | + $this->createChangeLogEntry($class, 'ADD', $uuid, [], $newValues); |
|
| 426 | + } |
|
| 415 | 427 | } |
| 416 | 428 | neon()->db->createCommand()->batchInsert(DdsObject::tableName(), ['_uuid', '_class_type', '_created', '_updated'], $objectDbRows)->execute(); |
| 417 | 429 | neon()->db->createCommand()->batchInsert($table, $columns, $rows)->execute(); |
@@ -445,20 +457,23 @@ discard block |
||
| 445 | 457 | public function editObject($uuid, array $changes, &$changeLogUuid = null) |
| 446 | 458 | { |
| 447 | 459 | // check there are some changes to make |
| 448 | - if (count($changes) == 0) |
|
| 449 | - return false; |
|
| 460 | + if (count($changes) == 0) { |
|
| 461 | + return false; |
|
| 462 | + } |
|
| 450 | 463 | |
| 451 | 464 | // check that the object exists and find its class type |
| 452 | - if (!$this->getObjectFromId($uuid, $object)) |
|
| 453 | - throw new \InvalidArgumentException("Couldn't edit object with id $uuid as not found"); |
|
| 465 | + if (!$this->getObjectFromId($uuid, $object)) { |
|
| 466 | + throw new \InvalidArgumentException("Couldn't edit object with id $uuid as not found"); |
|
| 467 | + } |
|
| 454 | 468 | |
| 455 | 469 | // see if we need to store the change log |
| 456 | 470 | $class = null; |
| 457 | 471 | $this->findClass($object['_class_type'], $class); |
| 458 | 472 | |
| 459 | 473 | $object->_updated = date('Y-m-d H:i:s'); |
| 460 | - if (!$object->save()) |
|
| 461 | - return $object->errors; |
|
| 474 | + if (!$object->save()) { |
|
| 475 | + return $object->errors; |
|
| 476 | + } |
|
| 462 | 477 | |
| 463 | 478 | // now update any member changes |
| 464 | 479 | try { |
@@ -487,8 +502,9 @@ discard block |
||
| 487 | 502 | } |
| 488 | 503 | } |
| 489 | 504 | } |
| 490 | - if (count($updates) == 0) |
|
| 491 | - return false; |
|
| 505 | + if (count($updates) == 0) { |
|
| 506 | + return false; |
|
| 507 | + } |
|
| 492 | 508 | |
| 493 | 509 | $query = "UPDATE `$table` SET " . implode(', ', $updates) . " WHERE `_uuid`='$uuid' LIMIT 1"; |
| 494 | 510 | neon()->db->createCommand($query)->bindValues($values)->execute(); |
@@ -497,8 +513,9 @@ discard block |
||
| 497 | 513 | $this->setMemberLinks($object->_uuid, $links); |
| 498 | 514 | |
| 499 | 515 | // finally note the changes in the change log |
| 500 | - if ($class && $class->hasChangeLog()) |
|
| 501 | - $changeLogUuid = $this->createChangeLogEntry($class, 'EDIT', $uuid, $originalValues, $newValues); |
|
| 516 | + if ($class && $class->hasChangeLog()) { |
|
| 517 | + $changeLogUuid = $this->createChangeLogEntry($class, 'EDIT', $uuid, $originalValues, $newValues); |
|
| 518 | + } |
|
| 502 | 519 | } catch (\yii\db\exception $e) { |
| 503 | 520 | $this->clearCaches(); |
| 504 | 521 | return ['error' => $e->getMessage()]; |
@@ -520,12 +537,14 @@ discard block |
||
| 520 | 537 | */ |
| 521 | 538 | public function editObjects($classType, array $uuids, array $changes) |
| 522 | 539 | { |
| 523 | - if (count($uuids) == 0 || count($changes) == 0) |
|
| 524 | - return false; |
|
| 540 | + if (count($uuids) == 0 || count($changes) == 0) { |
|
| 541 | + return false; |
|
| 542 | + } |
|
| 525 | 543 | try { |
| 526 | 544 | $uuids = $this->checkUuidsAgainstClassType($uuids, $classType); |
| 527 | - if (count($uuids) == 0) |
|
| 528 | - return false; |
|
| 545 | + if (count($uuids) == 0) { |
|
| 546 | + return false; |
|
| 547 | + } |
|
| 529 | 548 | $table = $this->getTableFromClassType($classType); |
| 530 | 549 | $memberStorage = $this->getMemberStorage($classType); |
| 531 | 550 | if (count($memberStorage) == 0) { |
@@ -536,8 +555,9 @@ discard block |
||
| 536 | 555 | $class = null; |
| 537 | 556 | $this->findClass($classType, $class); |
| 538 | 557 | if ($class && $class->hasChangeLog()) { |
| 539 | - foreach ($uuids as $uuid) |
|
| 540 | - $beforeValues[$uuid] = array_intersect_key($this->getObject($uuid), $changes); |
|
| 558 | + foreach ($uuids as $uuid) { |
|
| 559 | + $beforeValues[$uuid] = array_intersect_key($this->getObject($uuid), $changes); |
|
| 560 | + } |
|
| 541 | 561 | $newValues = $changes; |
| 542 | 562 | } |
| 543 | 563 | |
@@ -559,8 +579,9 @@ discard block |
||
| 559 | 579 | } |
| 560 | 580 | } |
| 561 | 581 | } |
| 562 | - if (count($updates) == 0) |
|
| 563 | - return false; |
|
| 582 | + if (count($updates) == 0) { |
|
| 583 | + return false; |
|
| 584 | + } |
|
| 564 | 585 | |
| 565 | 586 | // sort out the uuid clause for both the update on the table and in the object table |
| 566 | 587 | $uuidClause = []; |
@@ -588,8 +609,9 @@ discard block |
||
| 588 | 609 | |
| 589 | 610 | // and save entries into a change log |
| 590 | 611 | if ($class && $class->hasChangeLog()) { |
| 591 | - foreach ($beforeValues as $uuid => $before) |
|
| 592 | - $this->createChangeLogEntry($class, 'EDIT', $uuid, $before, $newValues); |
|
| 612 | + foreach ($beforeValues as $uuid => $before) { |
|
| 613 | + $this->createChangeLogEntry($class, 'EDIT', $uuid, $before, $newValues); |
|
| 614 | + } |
|
| 593 | 615 | } |
| 594 | 616 | } catch (\yii\db\exception $e) { |
| 595 | 617 | $this->clearCaches(); |
@@ -609,8 +631,9 @@ discard block |
||
| 609 | 631 | if ($this->getObjectFromId($uuid, $object) && $object->_deleted == 0) { |
| 610 | 632 | $object->_deleted = 1; |
| 611 | 633 | $object->_updated = date('Y-m-d H:i:s'); |
| 612 | - if (!$object->save()) |
|
| 613 | - throw new \RuntimeException("Couldn't delete the object: " . print_r($object->errors, true)); |
|
| 634 | + if (!$object->save()) { |
|
| 635 | + throw new \RuntimeException("Couldn't delete the object: " . print_r($object->errors, true)); |
|
| 636 | + } |
|
| 614 | 637 | // and update the class object deleted count |
| 615 | 638 | $class = null; |
| 616 | 639 | $this->findClass($object['_class_type'], $class); |
@@ -618,8 +641,9 @@ discard block |
||
| 618 | 641 | $class->save(); |
| 619 | 642 | |
| 620 | 643 | // see if we need to store the change log |
| 621 | - if ($class && $class->hasChangeLog()) |
|
| 622 | - $changeLogUuid = $this->createChangeLogEntry($class, 'DELETE', $uuid); |
|
| 644 | + if ($class && $class->hasChangeLog()) { |
|
| 645 | + $changeLogUuid = $this->createChangeLogEntry($class, 'DELETE', $uuid); |
|
| 646 | + } |
|
| 623 | 647 | |
| 624 | 648 | /** ---- KEEP ME ---- |
| 625 | 649 | * don't delete the links so any that haven't been deleted between |
@@ -642,8 +666,9 @@ discard block |
||
| 642 | 666 | public function deleteObjects(array $uuids) |
| 643 | 667 | { |
| 644 | 668 | $objects = $this->getObjectRowsFromIds($uuids); |
| 645 | - if (count($objects) == 0) |
|
| 646 | - return; |
|
| 669 | + if (count($objects) == 0) { |
|
| 670 | + return; |
|
| 671 | + } |
|
| 647 | 672 | |
| 648 | 673 | $foundUuids = []; |
| 649 | 674 | $foundClasses = []; |
@@ -660,8 +685,9 @@ discard block |
||
| 660 | 685 | $deletedUuids[$classType][$obj['_uuid']] = $obj['_uuid']; |
| 661 | 686 | } |
| 662 | 687 | } |
| 663 | - if (count($foundUuids)) |
|
| 664 | - DdsObject::updateAll(['_deleted' => 1, '_updated' => date('Y-m-d H:i:s')], ['_uuid' => $foundUuids]); |
|
| 688 | + if (count($foundUuids)) { |
|
| 689 | + DdsObject::updateAll(['_deleted' => 1, '_updated' => date('Y-m-d H:i:s')], ['_uuid' => $foundUuids]); |
|
| 690 | + } |
|
| 665 | 691 | foreach ($foundClasses as $type => $count) { |
| 666 | 692 | $class = null; |
| 667 | 693 | if ($this->findClass($type, $class)) { |
@@ -669,8 +695,9 @@ discard block |
||
| 669 | 695 | $class->save(); |
| 670 | 696 | // TODO 20200107 Make a bulk call for change log entries |
| 671 | 697 | if ($class->hasChangeLog()) { |
| 672 | - foreach ($deletedUuids[$class->class_type] as $objUuid) |
|
| 673 | - $this->createChangeLogEntry($class, 'DELETE', $objUuid); |
|
| 698 | + foreach ($deletedUuids[$class->class_type] as $objUuid) { |
|
| 699 | + $this->createChangeLogEntry($class, 'DELETE', $objUuid); |
|
| 700 | + } |
|
| 674 | 701 | } |
| 675 | 702 | } |
| 676 | 703 | } |
@@ -697,8 +724,9 @@ discard block |
||
| 697 | 724 | if ($this->getObjectFromId($uuid, $object) && $object->_deleted == 1) { |
| 698 | 725 | $object->_deleted = 0; |
| 699 | 726 | $object->_updated = date('Y-m-d H:i:s'); |
| 700 | - if (!$object->save()) |
|
| 701 | - throw new \RuntimeException("Couldn't undelete the object: " . print_r($object->errors, true)); |
|
| 727 | + if (!$object->save()) { |
|
| 728 | + throw new \RuntimeException("Couldn't undelete the object: " . print_r($object->errors, true)); |
|
| 729 | + } |
|
| 702 | 730 | |
| 703 | 731 | // and update the class object deleted count |
| 704 | 732 | $class = null; |
@@ -707,8 +735,9 @@ discard block |
||
| 707 | 735 | $class->save(); |
| 708 | 736 | |
| 709 | 737 | // see if we need to store the change log |
| 710 | - if ($class->hasChangeLog()) |
|
| 711 | - $changeLogUuid = $this->createChangeLogEntry($class, 'UNDELETE', $uuid); |
|
| 738 | + if ($class->hasChangeLog()) { |
|
| 739 | + $changeLogUuid = $this->createChangeLogEntry($class, 'UNDELETE', $uuid); |
|
| 740 | + } |
|
| 712 | 741 | } |
| 713 | 742 | $this->clearCaches(); |
| 714 | 743 | } |
@@ -723,8 +752,9 @@ discard block |
||
| 723 | 752 | if ($this->getObjectFromId($uuid, $object)) { |
| 724 | 753 | $class = null; |
| 725 | 754 | $this->findClass($object['_class_type'], $class); |
| 726 | - if ($class && $class->hasChangeLog()) |
|
| 727 | - $originalValues = $this->getObject($uuid); |
|
| 755 | + if ($class && $class->hasChangeLog()) { |
|
| 756 | + $originalValues = $this->getObject($uuid); |
|
| 757 | + } |
|
| 728 | 758 | |
| 729 | 759 | // delete any object table data |
| 730 | 760 | $table = $this->getTableFromClassType($object['_class_type']); |
@@ -740,8 +770,9 @@ discard block |
||
| 740 | 770 | // then if ok, decrement the class's object counts |
| 741 | 771 | if ($class) { |
| 742 | 772 | $class->count_total = max(0, $class->count_total - 1); |
| 743 | - if ($object['_deleted'] == 1) |
|
| 744 | - $class->count_deleted = max(0, $class->count_deleted - 1); |
|
| 773 | + if ($object['_deleted'] == 1) { |
|
| 774 | + $class->count_deleted = max(0, $class->count_deleted - 1); |
|
| 775 | + } |
|
| 745 | 776 | $class->save(); |
| 746 | 777 | } |
| 747 | 778 | |
@@ -749,8 +780,9 @@ discard block |
||
| 749 | 780 | DdsLink::deleteAll(['or', ['from_id' => $uuid], ['to_id' => $uuid]]); |
| 750 | 781 | |
| 751 | 782 | // and note this is in the change log |
| 752 | - if ($class && $class->hasChangeLog()) |
|
| 753 | - $changeLogUuid = $this->createChangeLogEntry($class, 'DESTROY', $uuid, $originalValues); |
|
| 783 | + if ($class && $class->hasChangeLog()) { |
|
| 784 | + $changeLogUuid = $this->createChangeLogEntry($class, 'DESTROY', $uuid, $originalValues); |
|
| 785 | + } |
|
| 754 | 786 | |
| 755 | 787 | $this->clearCaches(); |
| 756 | 788 | } |
@@ -762,16 +794,18 @@ discard block |
||
| 762 | 794 | public function destroyObjects(array $uuids) |
| 763 | 795 | { |
| 764 | 796 | $objects = $this->getObjectRowsFromIds($uuids); |
| 765 | - if (count($objects) == 0) |
|
| 766 | - return; |
|
| 797 | + if (count($objects) == 0) { |
|
| 798 | + return; |
|
| 799 | + } |
|
| 767 | 800 | |
| 768 | 801 | $objectUuids = []; |
| 769 | 802 | $objectsDeleted = []; |
| 770 | 803 | $classUuids = []; |
| 771 | 804 | foreach ($objects as $obj) { |
| 772 | 805 | $objectUuids[$obj['_uuid']] = $obj['_uuid']; |
| 773 | - if ($obj['_deleted'] == 1) |
|
| 774 | - $objectsDeleted[$obj['_class_type']][$obj['_uuid']] = $obj['_uuid']; |
|
| 806 | + if ($obj['_deleted'] == 1) { |
|
| 807 | + $objectsDeleted[$obj['_class_type']][$obj['_uuid']] = $obj['_uuid']; |
|
| 808 | + } |
|
| 775 | 809 | $classUuids[$obj['_class_type']][] = $obj['_uuid']; |
| 776 | 810 | } |
| 777 | 811 | |
@@ -798,8 +832,9 @@ discard block |
||
| 798 | 832 | // decrement the class's object counts |
| 799 | 833 | if ($class) { |
| 800 | 834 | $class->count_total = max(0, $class->count_total - count($uuids)); |
| 801 | - if (isset($objectsDeleted[$classType])) |
|
| 802 | - $class->count_deleted = max(0, $class->count_deleted - count($objectsDeleted[$classType])); |
|
| 835 | + if (isset($objectsDeleted[$classType])) { |
|
| 836 | + $class->count_deleted = max(0, $class->count_deleted - count($objectsDeleted[$classType])); |
|
| 837 | + } |
|
| 803 | 838 | $class->save(); |
| 804 | 839 | } |
| 805 | 840 | } |
@@ -827,8 +862,9 @@ discard block |
||
| 827 | 862 | */ |
| 828 | 863 | private function getObjectMapManager() |
| 829 | 864 | { |
| 830 | - if (!$this->_objectMapManager) |
|
| 831 | - $this->_objectMapManager = new DdsObjectMapManager; |
|
| 865 | + if (!$this->_objectMapManager) { |
|
| 866 | + $this->_objectMapManager = new DdsObjectMapManager; |
|
| 867 | + } |
|
| 832 | 868 | return $this->_objectMapManager; |
| 833 | 869 | } |
| 834 | 870 | |
@@ -843,14 +879,16 @@ discard block |
||
| 843 | 879 | // then see if there are any multilinks to extract |
| 844 | 880 | if ($links === null) { |
| 845 | 881 | $objectIds = []; |
| 846 | - foreach ($dataSet as $row) |
|
| 847 | - $objectIds[] = $row['_uuid']; |
|
| 882 | + foreach ($dataSet as $row) { |
|
| 883 | + $objectIds[] = $row['_uuid']; |
|
| 884 | + } |
|
| 848 | 885 | $links = $this->getMembersLinks($objectIds); |
| 849 | 886 | } |
| 850 | 887 | foreach ($dataSet as &$data) { |
| 851 | 888 | // convert full rows to database. Totals are left untouched |
| 852 | - if (isset($data[$classTypeKey])) |
|
| 853 | - $this->convertFromDBToPHP($data, $links[$data['_uuid']], $classTypeKey); |
|
| 889 | + if (isset($data[$classTypeKey])) { |
|
| 890 | + $this->convertFromDBToPHP($data, $links[$data['_uuid']], $classTypeKey); |
|
| 891 | + } |
|
| 854 | 892 | } |
| 855 | 893 | } |
| 856 | 894 | |
@@ -917,8 +955,9 @@ discard block |
||
| 917 | 955 | // a randomly generated resultKey prevents db query chaching. |
| 918 | 956 | $resultKey = $resultKey ? $resultKey : $request['requestKey'] . '_' . $counter; |
| 919 | 957 | $request['resultKey'] = $resultKey; |
| 920 | - if (!array_key_exists($request['requestKey'], self::$_requestResultsCache)) |
|
| 921 | - $this->convertRequestToSql($request); |
|
| 958 | + if (!array_key_exists($request['requestKey'], self::$_requestResultsCache)) { |
|
| 959 | + $this->convertRequestToSql($request); |
|
| 960 | + } |
|
| 922 | 961 | // store the request |
| 923 | 962 | $this->objectRequests[$request['classType']][$resultKey] = $request; |
| 924 | 963 | return $resultKey; |
@@ -995,8 +1034,9 @@ discard block |
||
| 995 | 1034 | { |
| 996 | 1035 | $join = ['INNER JOIN dds_object `o` on `t`.`_uuid` = `o`.`_uuid`']; |
| 997 | 1036 | foreach ($links as $l) { |
| 998 | - if (in_array($l, $filterKeys)) |
|
| 999 | - $join[] = "LEFT JOIN dds_link `link_$l` ON (`link_$l`.`from_id`=`o`.`_uuid` AND `link_$l`.`from_member`='$l')"; |
|
| 1037 | + if (in_array($l, $filterKeys)) { |
|
| 1038 | + $join[] = "LEFT JOIN dds_link `link_$l` ON (`link_$l`.`from_id`=`o`.`_uuid` AND `link_$l`.`from_member`='$l')"; |
|
| 1039 | + } |
|
| 1000 | 1040 | } |
| 1001 | 1041 | return implode(' ', $join); |
| 1002 | 1042 | } |
@@ -1013,11 +1053,13 @@ discard block |
||
| 1013 | 1053 | { |
| 1014 | 1054 | $filterKeys = []; |
| 1015 | 1055 | $notDeleted = '`o`.`_deleted`=0'; |
| 1016 | - if (count($filters) == 0) |
|
| 1017 | - return $includeDeleted ? '' : "WHERE $notDeleted"; |
|
| 1056 | + if (count($filters) == 0) { |
|
| 1057 | + return $includeDeleted ? '' : "WHERE $notDeleted"; |
|
| 1058 | + } |
|
| 1018 | 1059 | $this->createFilterClause($filters, $links, $filterKeys); |
| 1019 | - if (!$includeDeleted) |
|
| 1020 | - return "WHERE $notDeleted AND ($filters[sql])"; |
|
| 1060 | + if (!$includeDeleted) { |
|
| 1061 | + return "WHERE $notDeleted AND ($filters[sql])"; |
|
| 1062 | + } |
|
| 1021 | 1063 | return "WHERE $filters[sql]"; |
| 1022 | 1064 | } |
| 1023 | 1065 | |
@@ -1035,8 +1077,9 @@ discard block |
||
| 1035 | 1077 | // filter down until we hit the actual filters |
| 1036 | 1078 | if (is_array($filters[0])) { |
| 1037 | 1079 | foreach ($filters as $k => &$filter) { |
| 1038 | - if ($k === 'logic') |
|
| 1039 | - continue; |
|
| 1080 | + if ($k === 'logic') { |
|
| 1081 | + continue; |
|
| 1082 | + } |
|
| 1040 | 1083 | $this->createFilterClause($filter, $links, $filterKeys); |
| 1041 | 1084 | } |
| 1042 | 1085 | |
@@ -1048,25 +1091,28 @@ discard block |
||
| 1048 | 1091 | // in which case we combine those with to get the filterSql |
| 1049 | 1092 | $filterSql = []; |
| 1050 | 1093 | foreach ($filters as $k => &$filter) { |
| 1051 | - if ($k === 'logic') |
|
| 1052 | - continue; |
|
| 1094 | + if ($k === 'logic') { |
|
| 1095 | + continue; |
|
| 1096 | + } |
|
| 1053 | 1097 | // use the logic keys if any for the items - these can be in position 3 |
| 1054 | 1098 | // for most operators and position 2 for operators that don't take a key |
| 1055 | 1099 | if ($this->operatorTakesObject($filter[1])) { |
| 1056 | - if (isset($filter[3])) |
|
| 1057 | - $filterSql[$filter[3]] = $filter['itemSql']; |
|
| 1058 | - else |
|
| 1059 | - $filterSql[] = $filter['itemSql']; |
|
| 1100 | + if (isset($filter[3])) { |
|
| 1101 | + $filterSql[$filter[3]] = $filter['itemSql']; |
|
| 1102 | + } else { |
|
| 1103 | + $filterSql[] = $filter['itemSql']; |
|
| 1104 | + } |
|
| 1060 | 1105 | } else { |
| 1061 | - if (isset($filter[2])) |
|
| 1062 | - $filterSql[$filter[2]] = $filter['itemSql']; |
|
| 1063 | - else |
|
| 1064 | - $filterSql[] = $filter['itemSql']; |
|
| 1106 | + if (isset($filter[2])) { |
|
| 1107 | + $filterSql[$filter[2]] = $filter['itemSql']; |
|
| 1108 | + } else { |
|
| 1109 | + $filterSql[] = $filter['itemSql']; |
|
| 1110 | + } |
|
| 1065 | 1111 | } |
| 1066 | 1112 | } |
| 1067 | - if (empty($filters['logic'])) |
|
| 1068 | - $filters['filterSql'] = $filters['sql'] = implode(' AND ', $filterSql); |
|
| 1069 | - else { |
|
| 1113 | + if (empty($filters['logic'])) { |
|
| 1114 | + $filters['filterSql'] = $filters['sql'] = implode(' AND ', $filterSql); |
|
| 1115 | + } else { |
|
| 1070 | 1116 | // make sure we test logic filters in order from longest key to shortest key |
| 1071 | 1117 | // otherwise we can end up with subkeys screwing things up |
| 1072 | 1118 | $orderedKeys = array_map('strlen', array_keys($filterSql)); |
@@ -1078,8 +1124,9 @@ discard block |
||
| 1078 | 1124 | // double conversion, |
| 1079 | 1125 | $keys = array_keys($filterSql); |
| 1080 | 1126 | $keys2hashed = array(); |
| 1081 | - foreach ($keys as $k) |
|
| 1082 | - $keys2hashed[$k] = md5($k); |
|
| 1127 | + foreach ($keys as $k) { |
|
| 1128 | + $keys2hashed[$k] = md5($k); |
|
| 1129 | + } |
|
| 1083 | 1130 | $logicPass1 = str_replace($keys, $keys2hashed, $filters['logic']); |
| 1084 | 1131 | $filters['filterSql'] = $filters['sql'] = str_replace($keys2hashed, array_values($filterSql), $logicPass1); |
| 1085 | 1132 | } |
@@ -1102,9 +1149,9 @@ discard block |
||
| 1102 | 1149 | // |
| 1103 | 1150 | $filter = (in_array($filters[0], $links) ? "`link_{$filters[0]}`.`to_id`" : $this->quoteField($filters[0])); |
| 1104 | 1151 | $filterKeys[$filters[0]] = $filters[0]; |
| 1105 | - if ($this->operatorTakesObject($filters[1]) && isset($filters[2])) |
|
| 1106 | - $filters['itemSql'] = $filters['sql'] = "$filter " . $this->prepareForPDO($filters[1], $filters[2]); |
|
| 1107 | - else { |
|
| 1152 | + if ($this->operatorTakesObject($filters[1]) && isset($filters[2])) { |
|
| 1153 | + $filters['itemSql'] = $filters['sql'] = "$filter " . $this->prepareForPDO($filters[1], $filters[2]); |
|
| 1154 | + } else { |
|
| 1108 | 1155 | $filters['itemSql'] = $filters['sql'] = "$filter $filters[1]"; |
| 1109 | 1156 | } |
| 1110 | 1157 | } |
@@ -1113,21 +1160,25 @@ discard block |
||
| 1113 | 1160 | { |
| 1114 | 1161 | if (is_array($value)) { |
| 1115 | 1162 | $pdoValues = []; |
| 1116 | - if (!in_array($operator, ['=', '!=', 'IN', 'NOT IN'])) |
|
| 1117 | - throw new \InvalidArgumentException("Daedalus: Cannot pass an *array* of values with an operator of $operator"); |
|
| 1163 | + if (!in_array($operator, ['=', '!=', 'IN', 'NOT IN'])) { |
|
| 1164 | + throw new \InvalidArgumentException("Daedalus: Cannot pass an *array* of values with an operator of $operator"); |
|
| 1165 | + } |
|
| 1118 | 1166 | foreach ($value as $v) { |
| 1119 | - if (is_array($v)) |
|
| 1120 | - throw new \InvalidArgumentException("Daedalus: Cannot pass an *array* of *array* of values as filters (silly billy). You passed " . print_r($value, true)); |
|
| 1167 | + if (is_array($v)) { |
|
| 1168 | + throw new \InvalidArgumentException("Daedalus: Cannot pass an *array* of *array* of values as filters (silly billy). You passed " . print_r($value, true)); |
|
| 1169 | + } |
|
| 1121 | 1170 | $count = count($this->boundValues); |
| 1122 | 1171 | $variable = ":var{$count}end"; |
| 1123 | 1172 | $this->boundValues[$variable] = $v; |
| 1124 | 1173 | $pdoValues[] = $variable; |
| 1125 | 1174 | } |
| 1126 | 1175 | // converts equals to ins and outs |
| 1127 | - if ($operator == '=') |
|
| 1128 | - $operator = 'IN'; |
|
| 1129 | - if ($operator == '!=') |
|
| 1130 | - $operator = 'NOT IN'; |
|
| 1176 | + if ($operator == '=') { |
|
| 1177 | + $operator = 'IN'; |
|
| 1178 | + } |
|
| 1179 | + if ($operator == '!=') { |
|
| 1180 | + $operator = 'NOT IN'; |
|
| 1181 | + } |
|
| 1131 | 1182 | return "$operator (" . implode(',', $pdoValues) . ')'; |
| 1132 | 1183 | } else { |
| 1133 | 1184 | $count = count($this->boundValues); |
@@ -1151,8 +1202,9 @@ discard block |
||
| 1151 | 1202 | */ |
| 1152 | 1203 | private function extractOrderClause($order) |
| 1153 | 1204 | { |
| 1154 | - if (count($order) == 0) |
|
| 1155 | - return ''; |
|
| 1205 | + if (count($order) == 0) { |
|
| 1206 | + return ''; |
|
| 1207 | + } |
|
| 1156 | 1208 | $clause = []; |
| 1157 | 1209 | foreach ($order as $o => $d) { |
| 1158 | 1210 | // if any of the order clauses are RAND then replace whole clause |
@@ -1161,10 +1213,11 @@ discard block |
||
| 1161 | 1213 | break; |
| 1162 | 1214 | } |
| 1163 | 1215 | // allow negative ordering in mysql for nulls last |
| 1164 | - if (strpos($o, '-') === 0) |
|
| 1165 | - $clause[] = '-' . substr($o, 1) . " $d"; |
|
| 1166 | - else |
|
| 1167 | - $clause[] = "$o $d"; |
|
| 1216 | + if (strpos($o, '-') === 0) { |
|
| 1217 | + $clause[] = '-' . substr($o, 1) . " $d"; |
|
| 1218 | + } else { |
|
| 1219 | + $clause[] = "$o $d"; |
|
| 1220 | + } |
|
| 1168 | 1221 | } |
| 1169 | 1222 | return 'ORDER BY ' . implode(', ', $clause); |
| 1170 | 1223 | } |
@@ -1176,8 +1229,9 @@ discard block |
||
| 1176 | 1229 | */ |
| 1177 | 1230 | private function extractLimitClause($limit) |
| 1178 | 1231 | { |
| 1179 | - if (count($limit) == 0) |
|
| 1180 | - return ''; |
|
| 1232 | + if (count($limit) == 0) { |
|
| 1233 | + return ''; |
|
| 1234 | + } |
|
| 1181 | 1235 | return "LIMIT $limit[start], $limit[length]"; |
| 1182 | 1236 | } |
| 1183 | 1237 | |
@@ -1188,8 +1242,9 @@ discard block |
||
| 1188 | 1242 | */ |
| 1189 | 1243 | private function setMembersLinks($objectsLinks, $chunkSize) |
| 1190 | 1244 | { |
| 1191 | - if (count($objectsLinks) === 0) |
|
| 1192 | - return 0; |
|
| 1245 | + if (count($objectsLinks) === 0) { |
|
| 1246 | + return 0; |
|
| 1247 | + } |
|
| 1193 | 1248 | $totalCount = 0; |
| 1194 | 1249 | $db = neon()->db; |
| 1195 | 1250 | $ddsLink = DdsLink::tableName(); |
@@ -1199,13 +1254,16 @@ discard block |
||
| 1199 | 1254 | $deleteLinkClauses = []; |
| 1200 | 1255 | foreach ($chunkData as $fromUuid => $toMemberLinks) { |
| 1201 | 1256 | // check you've been supplied with rinky dinky data |
| 1202 | - if (!$this->isUUID($fromUuid)) |
|
| 1203 | - throw new \InvalidArgumentException("The fromUuid should be a UUID64. You passed in $fromUuid"); |
|
| 1257 | + if (!$this->isUUID($fromUuid)) { |
|
| 1258 | + throw new \InvalidArgumentException("The fromUuid should be a UUID64. You passed in $fromUuid"); |
|
| 1259 | + } |
|
| 1204 | 1260 | foreach ($toMemberLinks as $member => $toLinks) { |
| 1205 | - if (!is_array($toLinks)) |
|
| 1206 | - $toLinks = [$toLinks]; |
|
| 1207 | - if (!$this->areUUIDs($toLinks)) |
|
| 1208 | - throw new \InvalidArgumentException("The toMemberLinks should be UUID64s. You passed in " . print_r($toLinks, true)); |
|
| 1261 | + if (!is_array($toLinks)) { |
|
| 1262 | + $toLinks = [$toLinks]; |
|
| 1263 | + } |
|
| 1264 | + if (!$this->areUUIDs($toLinks)) { |
|
| 1265 | + throw new \InvalidArgumentException("The toMemberLinks should be UUID64s. You passed in " . print_r($toLinks, true)); |
|
| 1266 | + } |
|
| 1209 | 1267 | $toLinks = array_unique($toLinks); |
| 1210 | 1268 | |
| 1211 | 1269 | // |
@@ -1220,8 +1278,9 @@ discard block |
||
| 1220 | 1278 | |
| 1221 | 1279 | // prepare the new links ready for bulk insert |
| 1222 | 1280 | $count += count($toLinks); |
| 1223 | - foreach ($toLinks as $toLink) |
|
| 1224 | - $batchInsert[] = ['from_id' => $fromUuid, 'from_member' => $member, 'to_id' => $toLink]; |
|
| 1281 | + foreach ($toLinks as $toLink) { |
|
| 1282 | + $batchInsert[] = ['from_id' => $fromUuid, 'from_member' => $member, 'to_id' => $toLink]; |
|
| 1283 | + } |
|
| 1225 | 1284 | } |
| 1226 | 1285 | } |
| 1227 | 1286 | if (count($deleteLinkClauses)) { |
@@ -1230,10 +1289,12 @@ discard block |
||
| 1230 | 1289 | } |
| 1231 | 1290 | |
| 1232 | 1291 | $insertedCount = 0; |
| 1233 | - if (count($batchInsert)) |
|
| 1234 | - $insertedCount = $db->createCommand()->batchInsert($ddsLink, ['from_id', 'from_member', 'to_id'], $batchInsert)->execute(); |
|
| 1235 | - if (YII_DEBUG && $insertedCount !== $count) |
|
| 1236 | - throw new \Exception("The link insertion failed - $count items should have been inserted vs $insertedCount actual"); |
|
| 1292 | + if (count($batchInsert)) { |
|
| 1293 | + $insertedCount = $db->createCommand()->batchInsert($ddsLink, ['from_id', 'from_member', 'to_id'], $batchInsert)->execute(); |
|
| 1294 | + } |
|
| 1295 | + if (YII_DEBUG && $insertedCount !== $count) { |
|
| 1296 | + throw new \Exception("The link insertion failed - $count items should have been inserted vs $insertedCount actual"); |
|
| 1297 | + } |
|
| 1237 | 1298 | $totalCount += $count; |
| 1238 | 1299 | } |
| 1239 | 1300 | return $totalCount; |
@@ -1274,8 +1335,9 @@ discard block |
||
| 1274 | 1335 | */ |
| 1275 | 1336 | protected function getMembersLinks(array $objectIds) |
| 1276 | 1337 | { |
| 1277 | - if (empty($objectIds)) |
|
| 1278 | - return []; |
|
| 1338 | + if (empty($objectIds)) { |
|
| 1339 | + return []; |
|
| 1340 | + } |
|
| 1279 | 1341 | $objectIds = array_unique($objectIds); |
| 1280 | 1342 | sort($objectIds, SORT_STRING); |
| 1281 | 1343 | $cacheKey = md5(serialize($objectIds)); |
@@ -1287,8 +1349,9 @@ discard block |
||
| 1287 | 1349 | ->asArray() |
| 1288 | 1350 | ->all(); |
| 1289 | 1351 | $multilinks = array_fill_keys($objectIds, []); |
| 1290 | - foreach ($rows as $row) |
|
| 1291 | - $multilinks[$row['from_id']][$row['from_member']][] = $row['to_id']; |
|
| 1352 | + foreach ($rows as $row) { |
|
| 1353 | + $multilinks[$row['from_id']][$row['from_member']][] = $row['to_id']; |
|
| 1354 | + } |
|
| 1292 | 1355 | self::$_linkResultsCache[$cacheKey] = $multilinks; |
| 1293 | 1356 | } |
| 1294 | 1357 | return self::$_linkResultsCache[$cacheKey]; |
@@ -1305,8 +1368,9 @@ discard block |
||
| 1305 | 1368 | private function createChangeLogEntry($class, $changeKey, $objectUuid, $originalValues = [], $newValues = []) |
| 1306 | 1369 | { |
| 1307 | 1370 | static $changeLog = null; |
| 1308 | - if (!$changeLog) |
|
| 1309 | - $changeLog = neon('dds')->IDdsChangeLogManagement; |
|
| 1371 | + if (!$changeLog) { |
|
| 1372 | + $changeLog = neon('dds')->IDdsChangeLogManagement; |
|
| 1373 | + } |
|
| 1310 | 1374 | return $changeLog->addLogEntry($objectUuid, $class->toArray(), $changeKey, $originalValues, $newValues); |
| 1311 | 1375 | } |
| 1312 | 1376 | |