public function manageRecordUpdate($tableName, $recordData, $activityEntryMode = self::ACTIVITY_ENTRY_MODE_PARENT, &$childLogEntries = null, &$parentCollectionRelationshipsChanged = false, $parentData = array())
{
$log = $this->logger();
$schemaArray = TableSchema::getSchemaArray($tableName);
$currentUser = AuthProvider::getUserRecord();
$TableGateway = $this;
if ($tableName !== $this->table) {
$TableGateway = new RelationalTableGateway($this->acl, $tableName, $this->adapter);
}
// Upload file if necessary
$TableGateway->copyFiles($tableName, $recordData);
$recordIsNew = !array_key_exists($TableGateway->primaryKeyFieldName, $recordData);
//Dont do for directus users since id is pk
if ($recordIsNew && $tableName != 'directus_users') {
$cmsOwnerColumnName = $this->acl->getCmsOwnerColumnByTable($tableName);
if ($cmsOwnerColumnName) {
$recordData[$cmsOwnerColumnName] = $currentUser['id'];
}
}
//Dont let non-admins make admins
if ($tableName == 'directus_users' && $currentUser['group'] != 1) {
if (isset($recordData['group']) && $recordData['group']['id'] == 1) {
unset($recordData['group']);
}
}
$thisIsNested = $activityEntryMode == self::ACTIVITY_ENTRY_MODE_CHILD;
// Recursive functions will change this value (by reference) as necessary
// $nestedCollectionRelationshipsChanged = $thisIsNested ? $parentCollectionRelationshipsChanged : false;
$nestedCollectionRelationshipsChanged = false;
if ($thisIsNested) {
$nestedCollectionRelationshipsChanged =& $parentCollectionRelationshipsChanged;
}
// Recursive functions will append to this array by reference
// $nestedLogEntries = $thisIsNested ? $childLogEntries : array();
$nestedLogEntries = array();
if ($thisIsNested) {
$nestedLogEntries =& $childLogEntries;
}
// Update and/or Add Many-to-One Associations
$parentRecordWithForeignKeys = $TableGateway->addOrUpdateManyToOneRelationships($schemaArray, $recordData, $nestedLogEntries, $nestedCollectionRelationshipsChanged);
// Merge the M21 foreign keys into the recordData array
$recordData = array_merge($recordData, $parentRecordWithForeignKeys);
// If more than the record ID is present.
$newRecordObject = null;
$parentRecordChanged = $this->recordDataContainsNonPrimaryKeyData($parentRecordWithForeignKeys);
// || $recordIsNew;
if ($parentRecordChanged) {
// Update the parent row, w/ any new association fields replaced by their IDs
$newRecordObject = $TableGateway->addOrUpdateRecordByArray($parentRecordWithForeignKeys)->toArray();
}
// Do it this way, because & byref for outcome of ternary operator spells trouble
$draftRecord =& $parentRecordWithForeignKeys;
if ($recordIsNew) {
$draftRecord =& $newRecordObject;
}
// Restore X2M relationship / alias fields to the record representation & process these relationships.
$collectionColumns = TableSchema::getAllAliasTableColumns($tableName);
foreach ($collectionColumns as $collectionColumn) {
$colName = $collectionColumn['id'];
if (isset($recordData[$colName])) {
$draftRecord[$colName] = $recordData[$colName];
}
}
// parent
if ($activityEntryMode === self::ACTIVITY_ENTRY_MODE_PARENT) {
$parentData = array('id' => array_key_exists($this->primaryKeyFieldName, $recordData) ? $recordData[$this->primaryKeyFieldName] : null, 'table_name' => $tableName);
}
$draftRecord = $TableGateway->addOrUpdateToManyRelationships($schemaArray, $draftRecord, $nestedLogEntries, $nestedCollectionRelationshipsChanged, $parentData);
$rowId = $draftRecord[$this->primaryKeyFieldName];
$columnNames = TableSchema::getAllNonAliasTableColumnNames($tableName);
$TemporaryTableGateway = new TableGateway($tableName, $this->adapter);
$fullRecordData = $TemporaryTableGateway->select(function ($select) use($rowId, $columnNames) {
$select->where->equalTo($this->primaryKeyFieldName, $rowId);
$select->limit(1)->columns($columnNames);
})->current();
if (!$fullRecordData) {
$recordType = $recordIsNew ? "new" : "pre-existing";
throw new \RuntimeException("Attempted to load {$recordType} record post-insert with empty result. Lookup via row id: " . print_r($rowId, true));
}
$fullRecordData = (array) $fullRecordData;
$deltaRecordData = $recordIsNew ? array() : array_intersect_key((array) $parentRecordWithForeignKeys, (array) $fullRecordData);
switch ($activityEntryMode) {
// Activity logging is enabled, and I am a nested action
case self::ACTIVITY_ENTRY_MODE_CHILD:
$logEntryAction = $recordIsNew ? DirectusActivityTableGateway::ACTION_ADD : DirectusActivityTableGateway::ACTION_UPDATE;
$childLogEntries[] = array('type' => DirectusActivityTableGateway::makeLogTypeFromTableName($this->table), 'table_name' => $tableName, 'action' => $logEntryAction, 'user' => $currentUser['id'], 'datetime' => gmdate('Y-m-d H:i:s'), 'parent_id' => isset($parentData['id']) ? $parentData['id'] : null, 'parent_table' => isset($parentData['table_name']) ? $parentData['table_name'] : null, 'data' => json_encode($fullRecordData), 'delta' => json_encode($deltaRecordData), 'row_id' => $rowId, 'identifier' => $this->findRecordIdentifier($schemaArray, $fullRecordData), 'logged_ip' => $_SERVER['REMOTE_ADDR'], 'user_agent' => $_SERVER['HTTP_USER_AGENT']);
if ($recordIsNew) {
/**
* This is a nested call, creating a new record w/in a foreign collection.
* Indicate by reference that the top-level record's relationships have changed.
*/
$parentCollectionRelationshipsChanged = true;
}
break;
case self::ACTIVITY_ENTRY_MODE_PARENT:
// Does this act deserve a log?
$parentRecordNeedsLog = $nestedCollectionRelationshipsChanged || $parentRecordChanged;
/**
* NESTED QUESTIONS!
* @todo what do we do if the foreign record OF a foreign record changes?
* is that activity entry also directed towards this parent activity entry?
* @todo how should nested activity entries relate to the revision histories of foreign items?
* @todo one day: treat children as parents if this top-level record was not modified.
*/
$recordIdentifier = $this->findRecordIdentifier($schemaArray, $fullRecordData);
// Produce log if something changed.
if ($parentRecordChanged || $nestedCollectionRelationshipsChanged) {
$logEntryAction = $recordIsNew ? DirectusActivityTableGateway::ACTION_ADD : DirectusActivityTableGateway::ACTION_UPDATE;
//If we are updating and active is being set to 0 then we are deleting
if (!$recordIsNew && array_key_exists(STATUS_COLUMN_NAME, $deltaRecordData)) {
if ($deltaRecordData[STATUS_COLUMN_NAME] == STATUS_DELETED_NUM) {
$logEntryAction = DirectusActivityTableGateway::ACTION_DELETE;
}
}
// Save parent log entry
$parentLogEntry = AclAwareRowGateway::makeRowGatewayFromTableName($this->acl, "directus_activity", $this->adapter);
$logData = array('type' => DirectusActivityTableGateway::makeLogTypeFromTableName($this->table), 'table_name' => $tableName, 'action' => $logEntryAction, 'user' => $currentUser['id'], 'datetime' => gmdate('Y-m-d H:i:s'), 'parent_id' => null, 'data' => json_encode($fullRecordData), 'delta' => json_encode($deltaRecordData), 'parent_changed' => (int) $parentRecordChanged, 'identifier' => $recordIdentifier, 'row_id' => $rowId, 'logged_ip' => $_SERVER['REMOTE_ADDR'], 'user_agent' => $_SERVER['HTTP_USER_AGENT']);
$parentLogEntry->populate($logData, false);
$parentLogEntry->save();
// Update & insert nested activity entries
$ActivityGateway = new DirectusActivityTableGateway($this->acl, $this->adapter);
foreach ($nestedLogEntries as $entry) {
$entry['parent_id'] = $rowId;
// @todo ought to insert these in one batch
$ActivityGateway->insert($entry);
}
}
break;
}
// Yield record object
$recordGateway = new AclAwareRowGateway($this->acl, $TableGateway->primaryKeyFieldName, $tableName, $this->adapter);
$recordGateway->populate($fullRecordData, true);
return $recordGateway;
}
} else {
$groupRecipients[] = $typeAndId[1];
}
}
if (count($groupRecipients) > 0) {
$usersTableGateway = new DirectusUsersTableGateway($acl, $ZendDb);
$result = $usersTableGateway->findActiveUserIdsByGroupIds($groupRecipients);
foreach ($result as $item) {
$userRecipients[] = $item['id'];
}
}
$userRecipients[] = $currentUser['id'];
$messagesTableGateway = new DirectusMessagesTableGateway($acl, $ZendDb);
$id = $messagesTableGateway->sendMessage($requestPayload, array_unique($userRecipients), $currentUser['id']);
if ($id) {
$Activity = new DirectusActivityTableGateway($acl, $ZendDb);
$requestPayload['id'] = $id;
$Activity->recordMessage($requestPayload, $currentUser['id']);
}
$mail = new Directus\Mail\Mailer();
foreach ($userRecipients as $recipient) {
$usersTableGateway = new DirectusUsersTableGateway($acl, $ZendDb);
$user = $usersTableGateway->findOneBy('id', $recipient);
if (isset($user) && $user['email_messages'] == 1) {
$messageNotificationMail = new Directus\Mail\NotificationMail($user['email'], $requestPayload['subject'], $requestPayload['message']);
$mail->send($messageNotificationMail);
$mail->ClearAllRecipients();
}
}
$message = $messagesTableGateway->fetchMessageWithRecipients($id, $currentUser['id']);
JsonView::render($message);
