diff options
Diffstat (limited to 'apps/sharebymail/lib/ShareByMailProvider.php')
| -rw-r--r-- | apps/sharebymail/lib/ShareByMailProvider.php | 1063 |
1 files changed, 768 insertions, 295 deletions
diff --git a/apps/sharebymail/lib/ShareByMailProvider.php b/apps/sharebymail/lib/ShareByMailProvider.php index cb013acd4de..d28f7c51327 100644 --- a/apps/sharebymail/lib/ShareByMailProvider.php +++ b/apps/sharebymail/lib/ShareByMailProvider.php @@ -1,195 +1,209 @@ <?php + /** - * @copyright Copyright (c) 2016 Bjoern Schiessle <bjoern@schiessle.org> - * - * @license GNU AGPL version 3 or any later version - * - * This program is free software: you can redistribute it and/or modify - * it under the terms of the GNU Affero General Public License as - * published by the Free Software Foundation, either version 3 of the - * License, or (at your option) any later version. - * - * This program is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the - * GNU Affero General Public License for more details. - * - * You should have received a copy of the GNU Affero General Public License - * along with this program. If not, see <http://www.gnu.org/licenses/>. - * + * SPDX-FileCopyrightText: 2016 Nextcloud GmbH and Nextcloud contributors + * SPDX-License-Identifier: AGPL-3.0-or-later */ - namespace OCA\ShareByMail; -use OC\HintException; +use OC\Share20\DefaultShareProvider; use OC\Share20\Exception\InvalidShare; +use OC\Share20\Share; +use OC\User\NoUserException; +use OCA\ShareByMail\Settings\SettingsManager; use OCP\Activity\IManager; +use OCP\DB\QueryBuilder\IQueryBuilder; +use OCP\Defaults; +use OCP\EventDispatcher\IEventDispatcher; use OCP\Files\Folder; use OCP\Files\IRootFolder; use OCP\Files\Node; +use OCP\HintException; +use OCP\IConfig; use OCP\IDBConnection; use OCP\IL10N; -use OCP\ILogger; use OCP\IURLGenerator; +use OCP\IUser; use OCP\IUserManager; use OCP\Mail\IMailer; +use OCP\Security\Events\GenerateSecurePasswordEvent; +use OCP\Security\IHasher; use OCP\Security\ISecureRandom; -use OC\Share20\Share; +use OCP\Security\PasswordContext; +use OCP\Share\Exceptions\GenericShareException; use OCP\Share\Exceptions\ShareNotFound; +use OCP\Share\IAttributes; +use OCP\Share\IManager as IShareManager; use OCP\Share\IShare; -use OCP\Share\IShareProvider; -use OCP\Template; +use OCP\Share\IShareProviderWithNotification; +use OCP\Util; +use Psr\Log\LoggerInterface; /** * Class ShareByMail * * @package OCA\ShareByMail */ -class ShareByMailProvider implements IShareProvider { - - /** @var IDBConnection */ - private $dbConnection; - - /** @var ILogger */ - private $logger; - - /** @var ISecureRandom */ - private $secureRandom; - - /** @var IUserManager */ - private $userManager; - - /** @var IRootFolder */ - private $rootFolder; - - /** @var IL10N */ - private $l; - - /** @var IMailer */ - private $mailer; - - /** @var IURLGenerator */ - private $urlGenerator; - - /** @var IManager */ - private $activityManager; - +class ShareByMailProvider extends DefaultShareProvider implements IShareProviderWithNotification { /** * Return the identifier of this provider. * * @return string Containing only [a-zA-Z0-9] */ - public function identifier() { - return 'ocShareByMail'; + public function identifier(): string { + return 'ocMailShare'; } - /** - * DefaultShareProvider constructor. - * - * @param IDBConnection $connection - * @param ISecureRandom $secureRandom - * @param IUserManager $userManager - * @param IRootFolder $rootFolder - * @param IL10N $l - * @param ILogger $logger - * @param IMailer $mailer - * @param IURLGenerator $urlGenerator - * @param IManager $activityManager - */ public function __construct( - IDBConnection $connection, - ISecureRandom $secureRandom, - IUserManager $userManager, - IRootFolder $rootFolder, - IL10N $l, - ILogger $logger, - IMailer $mailer, - IURLGenerator $urlGenerator, - IManager $activityManager + private IConfig $config, + private IDBConnection $dbConnection, + private ISecureRandom $secureRandom, + private IUserManager $userManager, + private IRootFolder $rootFolder, + private IL10N $l, + private LoggerInterface $logger, + private IMailer $mailer, + private IURLGenerator $urlGenerator, + private IManager $activityManager, + private SettingsManager $settingsManager, + private Defaults $defaults, + private IHasher $hasher, + private IEventDispatcher $eventDispatcher, + private IShareManager $shareManager, ) { - $this->dbConnection = $connection; - $this->secureRandom = $secureRandom; - $this->userManager = $userManager; - $this->rootFolder = $rootFolder; - $this->l = $l; - $this->logger = $logger; - $this->mailer = $mailer; - $this->urlGenerator = $urlGenerator; - $this->activityManager = $activityManager; } /** * Share a path * - * @param IShare $share - * @return IShare The share object * @throws ShareNotFound * @throws \Exception */ - public function create(IShare $share) { - + public function create(IShare $share): IShare { $shareWith = $share->getSharedWith(); - /* - * Check if file is not already shared with the remote user - */ - $alreadyShared = $this->getSharedWith($shareWith, \OCP\Share::SHARE_TYPE_EMAIL, $share->getNode(), 1, 0); - if (!empty($alreadyShared)) { - $message = 'Sharing %s failed, this item is already shared with %s'; - $message_t = $this->l->t('Sharing %s failed, this item is already shared with %s', array($share->getNode()->getName(), $shareWith)); + // Check if file is not already shared with the given email, + // if we have an email at all. + $alreadyShared = $this->getSharedWith($shareWith, IShare::TYPE_EMAIL, $share->getNode(), 1, 0); + if ($shareWith !== '' && !empty($alreadyShared)) { + $message = 'Sharing %1$s failed, because this item is already shared with the account %2$s'; + $message_t = $this->l->t('Sharing %1$s failed, because this item is already shared with the account %2$s', [$share->getNode()->getName(), $shareWith]); $this->logger->debug(sprintf($message, $share->getNode()->getName(), $shareWith), ['app' => 'Federated File Sharing']); throw new \Exception($message_t); } + // if the admin enforces a password for all mail shares we create a + // random password and send it to the recipient + $password = $share->getPassword() ?: ''; + $passwordEnforced = $this->shareManager->shareApiLinkEnforcePassword(); + if ($passwordEnforced && empty($password)) { + $password = $this->autoGeneratePassword($share); + } + + if (!empty($password)) { + $share->setPassword($this->hasher->hash($password)); + } + $shareId = $this->createMailShare($share); - $this->createActivity($share); + + $this->createShareActivity($share); $data = $this->getRawShare($shareId); - return $this->createShareObject($data); + // Temporary set the clear password again to send it by mail + // This need to be done after the share was created in the database + // as the password is hashed in between. + if (!empty($password)) { + $data['password'] = $password; + } + + return $this->createShareObject($data); } /** - * create activity if a file/folder was shared by mail + * auto generate password in case of password enforcement on mail shares * - * @param IShare $share + * @throws \Exception */ - protected function createActivity(IShare $share) { + protected function autoGeneratePassword(IShare $share): string { + $initiatorUser = $this->userManager->get($share->getSharedBy()); + $initiatorEMailAddress = ($initiatorUser instanceof IUser) ? $initiatorUser->getEMailAddress() : null; + $allowPasswordByMail = $this->settingsManager->sendPasswordByMail(); + + if ($initiatorEMailAddress === null && !$allowPasswordByMail) { + throw new \Exception( + $this->l->t('We cannot send you the auto-generated password. Please set a valid email address in your personal settings and try again.') + ); + } + + $passwordEvent = new GenerateSecurePasswordEvent(PasswordContext::SHARING); + $this->eventDispatcher->dispatchTyped($passwordEvent); + + $password = $passwordEvent->getPassword(); + if ($password === null) { + $password = $this->secureRandom->generate(8, ISecureRandom::CHAR_HUMAN_READABLE); + } + + return $password; + } + /** + * create activity if a file/folder was shared by mail + */ + protected function createShareActivity(IShare $share, string $type = 'share'): void { $userFolder = $this->rootFolder->getUserFolder($share->getSharedBy()); $this->publishActivity( - Activity::SUBJECT_SHARED_EMAIL_SELF, + $type === 'share' ? Activity::SUBJECT_SHARED_EMAIL_SELF : Activity::SUBJECT_UNSHARED_EMAIL_SELF, [$userFolder->getRelativePath($share->getNode()->getPath()), $share->getSharedWith()], $share->getSharedBy(), $share->getNode()->getId(), - $userFolder->getRelativePath($share->getNode()->getPath()) + (string)$userFolder->getRelativePath($share->getNode()->getPath()) ); if ($share->getShareOwner() !== $share->getSharedBy()) { $ownerFolder = $this->rootFolder->getUserFolder($share->getShareOwner()); $fileId = $share->getNode()->getId(); - $node = $ownerFolder->getById($fileId); - $ownerPath = $node[0]->getPath(); + $nodes = $ownerFolder->getById($fileId); + $ownerPath = $nodes[0]->getPath(); $this->publishActivity( - Activity::SUBJECT_SHARED_EMAIL_BY, + $type === 'share' ? Activity::SUBJECT_SHARED_EMAIL_BY : Activity::SUBJECT_UNSHARED_EMAIL_BY, [$ownerFolder->getRelativePath($ownerPath), $share->getSharedWith(), $share->getSharedBy()], $share->getShareOwner(), $fileId, - $userFolder->getRelativePath($ownerPath) + (string)$ownerFolder->getRelativePath($ownerPath) ); } + } + + /** + * create activity if a file/folder was shared by mail + */ + protected function createPasswordSendActivity(IShare $share, string $sharedWith, bool $sendToSelf): void { + $userFolder = $this->rootFolder->getUserFolder($share->getSharedBy()); + if ($sendToSelf) { + $this->publishActivity( + Activity::SUBJECT_SHARED_EMAIL_PASSWORD_SEND_SELF, + [$userFolder->getRelativePath($share->getNode()->getPath())], + $share->getSharedBy(), + $share->getNode()->getId(), + (string)$userFolder->getRelativePath($share->getNode()->getPath()) + ); + } else { + $this->publishActivity( + Activity::SUBJECT_SHARED_EMAIL_PASSWORD_SEND, + [$userFolder->getRelativePath($share->getNode()->getPath()), $sharedWith], + $share->getSharedBy(), + $share->getNode()->getId(), + (string)$userFolder->getRelativePath($share->getNode()->getPath()) + ); + } } + /** * publish activity if a file/folder was shared by mail - * - * @param $subject - * @param $parameters - * @param $affectedUser - * @param $fileId - * @param $filePath */ - protected function publishActivity($subject, $parameters, $affectedUser, $fileId, $filePath) { + protected function publishActivity(string $subject, array $parameters, string $affectedUser, int $fileId, string $filePath): void { $event = $this->activityManager->generateEvent(); $event->setApp('sharebymail') ->setType('shared') @@ -197,123 +211,444 @@ class ShareByMailProvider implements IShareProvider { ->setAffectedUser($affectedUser) ->setObject('files', $fileId, $filePath); $this->activityManager->publish($event); - } /** - * @param IShare $share - * @return int * @throws \Exception */ - protected function createMailShare(IShare $share) { + protected function createMailShare(IShare $share): int { $share->setToken($this->generateToken()); - $shareId = $this->addShareToDB( + return $this->addShareToDB( $share->getNodeId(), $share->getNodeType(), $share->getSharedWith(), $share->getSharedBy(), $share->getShareOwner(), $share->getPermissions(), - $share->getToken() + $share->getToken(), + $share->getPassword(), + $share->getPasswordExpirationTime(), + $share->getSendPasswordByTalk(), + $share->getHideDownload(), + $share->getLabel(), + $share->getExpirationDate(), + $share->getNote(), + $share->getAttributes(), + $share->getMailSend(), ); + } + + /** + * @inheritDoc + */ + public function sendMailNotification(IShare $share): bool { + $shareId = $share->getId(); + + $emails = $this->getSharedWithEmails($share); + $validEmails = array_filter($emails, function (string $email) { + return $this->mailer->validateMailAddress($email); + }); + + if (count($validEmails) === 0) { + $this->removeShareFromTable((int)$shareId); + $e = new HintException('Failed to send share by mail. Could not find a valid email address: ' . join(', ', $emails), + $this->l->t('Failed to send share by email. Got an invalid email address')); + $this->logger->error('Failed to send share by mail. Could not find a valid email address ' . join(', ', $emails), [ + 'app' => 'sharebymail', + 'exception' => $e, + ]); + } try { - $link = $this->urlGenerator->linkToRouteAbsolute('files_sharing.sharecontroller.showShare', - ['token' => $share->getToken()]); - $this->sendMailNotification($share->getNode()->getName(), - $link, - $share->getShareOwner(), - $share->getSharedBy(), $share->getSharedWith()); + $this->sendEmail($share, $validEmails); + + // If we have a password set, we send it to the recipient + if ($share->getPassword() !== null) { + // If share-by-talk password is enabled, we do not send the notification + // to the recipient. They will have to request it to the owner after opening the link. + // Secondly, if the password expiration is disabled, we send the notification to the recipient + // Lastly, if the mail to recipient failed, we send the password to the owner as a fallback. + // If a password expires, the recipient will still be able to request a new one via talk. + $passwordExpire = $this->config->getSystemValue('sharing.enable_mail_link_password_expiration', false); + $passwordEnforced = $this->shareManager->shareApiLinkEnforcePassword(); + if ($passwordExpire === false || $share->getSendPasswordByTalk()) { + $send = $this->sendPassword($share, $share->getPassword(), $validEmails); + if ($passwordEnforced && $send === false) { + $this->sendPasswordToOwner($share, $share->getPassword()); + } + } + } + + return true; } catch (HintException $hintException) { - $this->logger->error('Failed to send share by mail: ' . $hintException->getMessage()); - $this->removeShareFromTable($shareId); + $this->logger->error('Failed to send share by mail.', [ + 'app' => 'sharebymail', + 'exception' => $hintException, + ]); + $this->removeShareFromTable((int)$shareId); throw $hintException; } catch (\Exception $e) { - $this->logger->error('Failed to send share by mail: ' . $e->getMessage()); - $this->removeShareFromTable($shareId); - throw new HintException('Failed to send share by mail', - $this->l->t('Failed to send share by E-mail')); + $this->logger->error('Failed to send share by mail.', [ + 'app' => 'sharebymail', + 'exception' => $e, + ]); + $this->removeShareFromTable((int)$shareId); + throw new HintException( + 'Failed to send share by mail', + $this->l->t('Failed to send share by email'), + 0, + $e, + ); + } + return false; + } + + /** + * @param IShare $share The share to send the email for + * @param array $emails The email addresses to send the email to + */ + protected function sendEmail(IShare $share, array $emails): void { + $link = $this->urlGenerator->linkToRouteAbsolute('files_sharing.sharecontroller.showShare', [ + 'token' => $share->getToken() + ]); + + $expiration = $share->getExpirationDate(); + $filename = $share->getNode()->getName(); + $initiator = $share->getSharedBy(); + $note = $share->getNote(); + $shareWith = $share->getSharedWith(); + + $initiatorUser = $this->userManager->get($initiator); + $initiatorDisplayName = ($initiatorUser instanceof IUser) ? $initiatorUser->getDisplayName() : $initiator; + $message = $this->mailer->createMessage(); + + $emailTemplate = $this->mailer->createEMailTemplate('sharebymail.RecipientNotification', [ + 'filename' => $filename, + 'link' => $link, + 'initiator' => $initiatorDisplayName, + 'expiration' => $expiration, + 'shareWith' => $shareWith, + 'note' => $note + ]); + + $emailTemplate->setSubject($this->l->t('%1$s shared %2$s with you', [$initiatorDisplayName, $filename])); + $emailTemplate->addHeader(); + $emailTemplate->addHeading($this->l->t('%1$s shared %2$s with you', [$initiatorDisplayName, $filename]), false); + + if ($note !== '') { + $emailTemplate->addBodyListItem( + htmlspecialchars($note), + $this->l->t('Note:'), + $this->getAbsoluteImagePath('caldav/description.png'), + $note + ); } - return $shareId; + if ($expiration !== null) { + $dateString = (string)$this->l->l('date', $expiration, ['width' => 'medium']); + $emailTemplate->addBodyListItem( + $this->l->t('This share is valid until %s at midnight', [$dateString]), + $this->l->t('Expiration:'), + $this->getAbsoluteImagePath('caldav/time.png'), + ); + } + + $emailTemplate->addBodyButton( + $this->l->t('Open %s', [$filename]), + $link + ); + // If multiple recipients are given, we send the mail to all of them + if (count($emails) > 1) { + // We do not want to expose the email addresses of the other recipients + $message->setBcc($emails); + } else { + $message->setTo($emails); + } + + // The "From" contains the sharers name + $instanceName = $this->defaults->getName(); + $senderName = $instanceName; + if ($this->settingsManager->replyToInitiator()) { + $senderName = $this->l->t( + '%1$s via %2$s', + [ + $initiatorDisplayName, + $instanceName + ] + ); + } + $message->setFrom([Util::getDefaultEmailAddress($instanceName) => $senderName]); + + // The "Reply-To" is set to the sharer if an mail address is configured + // also the default footer contains a "Do not reply" which needs to be adjusted. + if ($initiatorUser && $this->settingsManager->replyToInitiator()) { + $initiatorEmail = $initiatorUser->getEMailAddress(); + if ($initiatorEmail !== null) { + $message->setReplyTo([$initiatorEmail => $initiatorDisplayName]); + $emailTemplate->addFooter($instanceName . ($this->defaults->getSlogan() !== '' ? ' - ' . $this->defaults->getSlogan() : '')); + } else { + $emailTemplate->addFooter(); + } + } else { + $emailTemplate->addFooter(); + } + + $message->useTemplate($emailTemplate); + $failedRecipients = $this->mailer->send($message); + if (!empty($failedRecipients)) { + $this->logger->error('Share notification mail could not be sent to: ' . implode(', ', $failedRecipients)); + return; + } } - protected function sendMailNotification($filename, $link, $owner, $initiator, $shareWith) { - if ($owner === $initiator) { - $subject = (string)$this->l->t('%s shared »%s« with you', array($owner, $filename)); + /** + * Send password to recipient of a mail share + * Will return false if + * 1. the password is empty + * 2. the setting to send the password by mail is disabled + * 3. the share is set to send the password by talk + * + * @param IShare $share + * @param string $password + * @param array $emails + * @return bool + */ + protected function sendPassword(IShare $share, string $password, array $emails): bool { + $filename = $share->getNode()->getName(); + $initiator = $share->getSharedBy(); + $shareWith = $share->getSharedWith(); + + if ($password === '' || $this->settingsManager->sendPasswordByMail() === false || $share->getSendPasswordByTalk()) { + return false; + } + + $initiatorUser = $this->userManager->get($initiator); + $initiatorDisplayName = ($initiatorUser instanceof IUser) ? $initiatorUser->getDisplayName() : $initiator; + $initiatorEmailAddress = ($initiatorUser instanceof IUser) ? $initiatorUser->getEMailAddress() : null; + + $plainBodyPart = $this->l->t('%1$s shared %2$s with you. You should have already received a separate mail with a link to access it.', [$initiatorDisplayName, $filename]); + $htmlBodyPart = $this->l->t('%1$s shared %2$s with you. You should have already received a separate mail with a link to access it.', [$initiatorDisplayName, $filename]); + + $message = $this->mailer->createMessage(); + + $emailTemplate = $this->mailer->createEMailTemplate('sharebymail.RecipientPasswordNotification', [ + 'filename' => $filename, + 'password' => $password, + 'initiator' => $initiatorDisplayName, + 'initiatorEmail' => $initiatorEmailAddress, + 'shareWith' => $shareWith, + ]); + + $emailTemplate->setSubject($this->l->t('Password to access %1$s shared to you by %2$s', [$filename, $initiatorDisplayName])); + $emailTemplate->addHeader(); + $emailTemplate->addHeading($this->l->t('Password to access %s', [$filename]), false); + $emailTemplate->addBodyText(htmlspecialchars($htmlBodyPart), $plainBodyPart); + $emailTemplate->addBodyText($this->l->t('It is protected with the following password:')); + $emailTemplate->addBodyText($password); + + if ($this->config->getSystemValue('sharing.enable_mail_link_password_expiration', false) === true) { + $expirationTime = new \DateTime(); + $expirationInterval = $this->config->getSystemValue('sharing.mail_link_password_expiration_interval', 3600); + $expirationTime = $expirationTime->add(new \DateInterval('PT' . $expirationInterval . 'S')); + $emailTemplate->addBodyText($this->l->t('This password will expire at %s', [$expirationTime->format('r')])); + } + + // If multiple recipients are given, we send the mail to all of them + if (count($emails) > 1) { + // We do not want to expose the email addresses of the other recipients + $message->setBcc($emails); + } else { + $message->setTo($emails); + } + + // The "From" contains the sharers name + $instanceName = $this->defaults->getName(); + $senderName = $instanceName; + if ($this->settingsManager->replyToInitiator()) { + $senderName = $this->l->t( + '%1$s via %2$s', + [ + $initiatorDisplayName, + $instanceName + ] + ); + } + $message->setFrom([Util::getDefaultEmailAddress($instanceName) => $senderName]); + + // The "Reply-To" is set to the sharer if an mail address is configured + // also the default footer contains a "Do not reply" which needs to be adjusted. + if ($initiatorUser && $this->settingsManager->replyToInitiator()) { + $initiatorEmail = $initiatorUser->getEMailAddress(); + if ($initiatorEmail !== null) { + $message->setReplyTo([$initiatorEmail => $initiatorDisplayName]); + $emailTemplate->addFooter($instanceName . ($this->defaults->getSlogan() !== '' ? ' - ' . $this->defaults->getSlogan() : '')); + } else { + $emailTemplate->addFooter(); + } } else { - $subject = (string)$this->l->t('%s shared »%s« with you on behalf of %s', array($owner, $filename, $initiator)); + $emailTemplate->addFooter(); + } + + $message->useTemplate($emailTemplate); + $failedRecipients = $this->mailer->send($message); + if (!empty($failedRecipients)) { + $this->logger->error('Share password mail could not be sent to: ' . implode(', ', $failedRecipients)); + return false; } + $this->createPasswordSendActivity($share, $shareWith, false); + return true; + } + + protected function sendNote(IShare $share): void { + $recipient = $share->getSharedWith(); + + + $filename = $share->getNode()->getName(); + $initiator = $share->getSharedBy(); + $note = $share->getNote(); + + $initiatorUser = $this->userManager->get($initiator); + $initiatorDisplayName = ($initiatorUser instanceof IUser) ? $initiatorUser->getDisplayName() : $initiator; + $initiatorEmailAddress = ($initiatorUser instanceof IUser) ? $initiatorUser->getEMailAddress() : null; + + $plainHeading = $this->l->t('%1$s shared %2$s with you and wants to add:', [$initiatorDisplayName, $filename]); + $htmlHeading = $this->l->t('%1$s shared %2$s with you and wants to add', [$initiatorDisplayName, $filename]); + $message = $this->mailer->createMessage(); - $htmlBody = $this->createMailBody('mail', $filename, $link, $owner, $initiator); - $textBody = $this->createMailBody('altmail', $filename, $link, $owner, $initiator); - $message->setTo([$shareWith]); - $message->setSubject($subject); - $message->setBody($textBody, 'text/plain'); - $message->setHtmlBody($htmlBody); - $this->mailer->send($message); + $emailTemplate = $this->mailer->createEMailTemplate('shareByMail.sendNote'); + + $emailTemplate->setSubject($this->l->t('%s added a note to a file shared with you', [$initiatorDisplayName])); + $emailTemplate->addHeader(); + $emailTemplate->addHeading(htmlspecialchars($htmlHeading), $plainHeading); + $emailTemplate->addBodyText(htmlspecialchars($note), $note); + + $link = $this->urlGenerator->linkToRouteAbsolute('files_sharing.sharecontroller.showShare', + ['token' => $share->getToken()]); + $emailTemplate->addBodyButton( + $this->l->t('Open %s', [$filename]), + $link + ); + + // The "From" contains the sharers name + $instanceName = $this->defaults->getName(); + $senderName = $instanceName; + if ($this->settingsManager->replyToInitiator()) { + $senderName = $this->l->t( + '%1$s via %2$s', + [ + $initiatorDisplayName, + $instanceName + ] + ); + } + $message->setFrom([Util::getDefaultEmailAddress($instanceName) => $senderName]); + if ($this->settingsManager->replyToInitiator() && $initiatorEmailAddress !== null) { + $message->setReplyTo([$initiatorEmailAddress => $initiatorDisplayName]); + $emailTemplate->addFooter($instanceName . ' - ' . $this->defaults->getSlogan()); + } else { + $emailTemplate->addFooter(); + } + + $message->setTo([$recipient]); + $message->useTemplate($emailTemplate); + $this->mailer->send($message); } /** - * create mail body + * send auto generated password to the owner. This happens if the admin enforces + * a password for mail shares and forbid to send the password by mail to the recipient * - * @param $filename - * @param $link - * @param $owner - * @param $initiator - * @return string plain text mail - * @throws HintException + * @throws \Exception */ - protected function createMailBody($template, $filename, $link, $owner, $initiator) { + protected function sendPasswordToOwner(IShare $share, string $password): bool { + $filename = $share->getNode()->getName(); + $initiator = $this->userManager->get($share->getSharedBy()); + $initiatorEMailAddress = ($initiator instanceof IUser) ? $initiator->getEMailAddress() : null; + $initiatorDisplayName = ($initiator instanceof IUser) ? $initiator->getDisplayName() : $share->getSharedBy(); + $shareWith = implode(', ', $this->getSharedWithEmails($share)); + + if ($initiatorEMailAddress === null) { + throw new \Exception( + $this->l->t('We cannot send you the auto-generated password. Please set a valid email address in your personal settings and try again.') + ); + } - $mailBodyTemplate = new Template('sharebymail', $template, ''); - $mailBodyTemplate->assign ('filename', $filename); - $mailBodyTemplate->assign ('link', $link); - $mailBodyTemplate->assign ('owner', $owner); - $mailBodyTemplate->assign ('initiator', $initiator); - $mailBodyTemplate->assign ('onBehalfOf', $initiator !== $owner); - $mailBody = $mailBodyTemplate->fetchPage(); + $bodyPart = $this->l->t('You just shared %1$s with %2$s. The share was already sent to the recipient. Due to the security policies defined by the administrator of %3$s each share needs to be protected by password and it is not allowed to send the password directly to the recipient. Therefore you need to forward the password manually to the recipient.', [$filename, $shareWith, $this->defaults->getName()]); - if (is_string($mailBody)) { - return $mailBody; + $message = $this->mailer->createMessage(); + $emailTemplate = $this->mailer->createEMailTemplate('sharebymail.OwnerPasswordNotification', [ + 'filename' => $filename, + 'password' => $password, + 'initiator' => $initiatorDisplayName, + 'initiatorEmail' => $initiatorEMailAddress, + 'shareWith' => $shareWith, + ]); + + $emailTemplate->setSubject($this->l->t('Password to access %1$s shared by you with %2$s', [$filename, $shareWith])); + $emailTemplate->addHeader(); + $emailTemplate->addHeading($this->l->t('Password to access %s', [$filename]), false); + $emailTemplate->addBodyText($bodyPart); + $emailTemplate->addBodyText($this->l->t('This is the password:')); + $emailTemplate->addBodyText($password); + + if ($this->config->getSystemValue('sharing.enable_mail_link_password_expiration', false) === true) { + $expirationTime = new \DateTime(); + $expirationInterval = $this->config->getSystemValue('sharing.mail_link_password_expiration_interval', 3600); + $expirationTime = $expirationTime->add(new \DateInterval('PT' . $expirationInterval . 'S')); + $emailTemplate->addBodyText($this->l->t('This password will expire at %s', [$expirationTime->format('r')])); } - throw new HintException('Failed to create the E-mail', - $this->l->t('Failed to create the E-mail')); + $emailTemplate->addBodyText($this->l->t('You can choose a different password at any time in the share dialog.')); + + $emailTemplate->addFooter(); + + $instanceName = $this->defaults->getName(); + $senderName = $this->l->t( + '%1$s via %2$s', + [ + $initiatorDisplayName, + $instanceName + ] + ); + $message->setFrom([Util::getDefaultEmailAddress($instanceName) => $senderName]); + $message->setTo([$initiatorEMailAddress => $initiatorDisplayName]); + $message->useTemplate($emailTemplate); + $this->mailer->send($message); + + $this->createPasswordSendActivity($share, $shareWith, true); + + return true; + } + + private function getAbsoluteImagePath(string $path):string { + return $this->urlGenerator->getAbsoluteURL( + $this->urlGenerator->imagePath('core', $path) + ); } /** * generate share token - * - * @return string */ - protected function generateToken() { - $token = $this->secureRandom->generate( - 15, ISecureRandom::CHAR_LOWER . ISecureRandom::CHAR_UPPER . ISecureRandom::CHAR_DIGITS); + protected function generateToken(int $size = 15): string { + $token = $this->secureRandom->generate($size, ISecureRandom::CHAR_HUMAN_READABLE); return $token; } - /** - * Get all children of this share - * - * @param IShare $parent - * @return IShare[] - */ - public function getChildren(IShare $parent) { + public function getChildren(IShare $parent): array { $children = []; $qb = $this->dbConnection->getQueryBuilder(); $qb->select('*') ->from('share') ->where($qb->expr()->eq('parent', $qb->createNamedParameter($parent->getId()))) - ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))) + ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(IShare::TYPE_EMAIL))) ->orderBy('id'); - $cursor = $qb->execute(); - while($data = $cursor->fetch()) { + $cursor = $qb->executeQuery(); + while ($data = $cursor->fetch()) { $children[] = $this->createShareObject($data); } $cursor->closeCursor(); @@ -322,21 +657,29 @@ class ShareByMailProvider implements IShareProvider { } /** - * add share to the database and return the ID - * - * @param int $itemSource - * @param string $itemType - * @param string $shareWith - * @param string $sharedBy - * @param string $uidOwner - * @param int $permissions - * @param string $token - * @return int - */ - protected function addShareToDB($itemSource, $itemType, $shareWith, $sharedBy, $uidOwner, $permissions, $token) { + * Add share to the database and return the ID + */ + protected function addShareToDB( + ?int $itemSource, + ?string $itemType, + ?string $shareWith, + ?string $sharedBy, + ?string $uidOwner, + ?int $permissions, + ?string $token, + ?string $password, + ?\DateTimeInterface $passwordExpirationTime, + ?bool $sendPasswordByTalk, + ?bool $hideDownload, + ?string $label, + ?\DateTimeInterface $expirationTime, + ?string $note = '', + ?IAttributes $attributes = null, + ?bool $mailSend = true, + ): int { $qb = $this->dbConnection->getQueryBuilder(); $qb->insert('share') - ->setValue('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL)) + ->setValue('share_type', $qb->createNamedParameter(IShare::TYPE_EMAIL)) ->setValue('item_type', $qb->createNamedParameter($itemType)) ->setValue('item_source', $qb->createNamedParameter($itemSource)) ->setValue('file_source', $qb->createNamedParameter($itemSource)) @@ -345,37 +688,74 @@ class ShareByMailProvider implements IShareProvider { ->setValue('uid_initiator', $qb->createNamedParameter($sharedBy)) ->setValue('permissions', $qb->createNamedParameter($permissions)) ->setValue('token', $qb->createNamedParameter($token)) - ->setValue('stime', $qb->createNamedParameter(time())); - - /* - * Added to fix https://github.com/owncloud/core/issues/22215 - * Can be removed once we get rid of ajax/share.php - */ - $qb->setValue('file_target', $qb->createNamedParameter('')); - - $qb->execute(); - $id = $qb->getLastInsertId(); + ->setValue('password', $qb->createNamedParameter($password)) + ->setValue('password_expiration_time', $qb->createNamedParameter($passwordExpirationTime, IQueryBuilder::PARAM_DATETIME_MUTABLE)) + ->setValue('password_by_talk', $qb->createNamedParameter($sendPasswordByTalk, IQueryBuilder::PARAM_BOOL)) + ->setValue('stime', $qb->createNamedParameter(time())) + ->setValue('hide_download', $qb->createNamedParameter((int)$hideDownload, IQueryBuilder::PARAM_INT)) + ->setValue('label', $qb->createNamedParameter($label)) + ->setValue('note', $qb->createNamedParameter($note)) + ->setValue('mail_send', $qb->createNamedParameter((int)$mailSend, IQueryBuilder::PARAM_INT)); + + // set share attributes + $shareAttributes = $this->formatShareAttributes($attributes); + + $qb->setValue('attributes', $qb->createNamedParameter($shareAttributes)); + if ($expirationTime !== null) { + $qb->setValue('expiration', $qb->createNamedParameter($expirationTime, IQueryBuilder::PARAM_DATETIME_MUTABLE)); + } - return (int)$id; + $qb->executeStatement(); + return $qb->getLastInsertId(); } /** * Update a share - * - * @param IShare $share - * @return IShare The share object */ - public function update(IShare $share) { + public function update(IShare $share, ?string $plainTextPassword = null): IShare { + $originalShare = $this->getShareById($share->getId()); + + // a real password was given + $validPassword = $plainTextPassword !== null && $plainTextPassword !== ''; + + if ($validPassword && ($originalShare->getPassword() !== $share->getPassword() + || ($originalShare->getSendPasswordByTalk() && !$share->getSendPasswordByTalk()))) { + $emails = $this->getSharedWithEmails($share); + $validEmails = array_filter($emails, function ($email) { + return $this->mailer->validateMailAddress($email); + }); + $this->sendPassword($share, $plainTextPassword, $validEmails); + } + + $shareAttributes = $this->formatShareAttributes($share->getAttributes()); + /* - * We allow updating the permissions of mail shares + * We allow updating mail shares */ $qb = $this->dbConnection->getQueryBuilder(); - $qb->update('share') - ->where($qb->expr()->eq('id', $qb->createNamedParameter($share->getId()))) - ->set('permissions', $qb->createNamedParameter($share->getPermissions())) - ->set('uid_owner', $qb->createNamedParameter($share->getShareOwner())) - ->set('uid_initiator', $qb->createNamedParameter($share->getSharedBy())) - ->execute(); + $qb->update('share') + ->where($qb->expr()->eq('id', $qb->createNamedParameter($share->getId()))) + ->set('item_source', $qb->createNamedParameter($share->getNodeId())) + ->set('file_source', $qb->createNamedParameter($share->getNodeId())) + ->set('share_with', $qb->createNamedParameter($share->getSharedWith())) + ->set('permissions', $qb->createNamedParameter($share->getPermissions())) + ->set('uid_owner', $qb->createNamedParameter($share->getShareOwner())) + ->set('uid_initiator', $qb->createNamedParameter($share->getSharedBy())) + ->set('password', $qb->createNamedParameter($share->getPassword())) + ->set('password_expiration_time', $qb->createNamedParameter($share->getPasswordExpirationTime(), IQueryBuilder::PARAM_DATETIME_MUTABLE)) + ->set('label', $qb->createNamedParameter($share->getLabel())) + ->set('password_by_talk', $qb->createNamedParameter($share->getSendPasswordByTalk(), IQueryBuilder::PARAM_BOOL)) + ->set('expiration', $qb->createNamedParameter($share->getExpirationDate(), IQueryBuilder::PARAM_DATETIME_MUTABLE)) + ->set('note', $qb->createNamedParameter($share->getNote())) + ->set('hide_download', $qb->createNamedParameter((int)$share->getHideDownload(), IQueryBuilder::PARAM_INT)) + ->set('attributes', $qb->createNamedParameter($shareAttributes)) + ->set('mail_send', $qb->createNamedParameter((int)$share->getMailSend(), IQueryBuilder::PARAM_INT)) + ->set('reminder_sent', $qb->createNamedParameter($share->getReminderSent(), IQueryBuilder::PARAM_BOOL)) + ->executeStatement(); + + if ($originalShare->getNote() !== $share->getNote() && $share->getNote() !== '') { + $this->sendNote($share); + } return $share; } @@ -383,7 +763,7 @@ class ShareByMailProvider implements IShareProvider { /** * @inheritdoc */ - public function move(IShare $share, $recipient) { + public function move(IShare $share, $recipient): IShare { /** * nothing to do here, mail shares are only outgoing shares */ @@ -395,27 +775,35 @@ class ShareByMailProvider implements IShareProvider { * * @param IShare $share */ - public function delete(IShare $share) { - $this->removeShareFromTable($share->getId()); + public function delete(IShare $share): void { + try { + $this->createShareActivity($share, 'unshare'); + } catch (\Exception $e) { + } + + $this->removeShareFromTable((int)$share->getId()); } /** * @inheritdoc */ - public function deleteFromSelf(IShare $share, $recipient) { + public function deleteFromSelf(IShare $share, $recipient): void { // nothing to do here, mail shares are only outgoing shares - return; + } + + public function restore(IShare $share, string $recipient): IShare { + throw new GenericShareException('not implemented'); } /** * @inheritdoc */ - public function getSharesBy($userId, $shareType, $node, $reshares, $limit, $offset) { + public function getSharesBy($userId, $shareType, $node, $reshares, $limit, $offset): array { $qb = $this->dbConnection->getQueryBuilder(); $qb->select('*') ->from('share'); - $qb->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))); + $qb->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(IShare::TYPE_EMAIL))); /** * Reshares for this user are shares where they are the owner. @@ -433,7 +821,7 @@ class ShareByMailProvider implements IShareProvider { $or1 ) ); - } else { + } elseif ($node === null) { $qb->andWhere( $qb->expr()->orX( $qb->expr()->eq('uid_owner', $qb->createNamedParameter($userId)), @@ -453,9 +841,9 @@ class ShareByMailProvider implements IShareProvider { $qb->setFirstResult($offset); $qb->orderBy('id'); - $cursor = $qb->execute(); + $cursor = $qb->executeQuery(); $shares = []; - while($data = $cursor->fetch()) { + while ($data = $cursor->fetch()) { $shares[] = $this->createShareObject($data); } $cursor->closeCursor(); @@ -466,15 +854,15 @@ class ShareByMailProvider implements IShareProvider { /** * @inheritdoc */ - public function getShareById($id, $recipientId = null) { + public function getShareById($id, $recipientId = null): IShare { $qb = $this->dbConnection->getQueryBuilder(); $qb->select('*') ->from('share') ->where($qb->expr()->eq('id', $qb->createNamedParameter($id))) - ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))); + ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(IShare::TYPE_EMAIL))); - $cursor = $qb->execute(); + $cursor = $qb->executeQuery(); $data = $cursor->fetch(); $cursor->closeCursor(); @@ -494,20 +882,19 @@ class ShareByMailProvider implements IShareProvider { /** * Get shares for a given path * - * @param \OCP\Files\Node $path * @return IShare[] */ - public function getSharesByPath(Node $path) { + public function getSharesByPath(Node $path): array { $qb = $this->dbConnection->getQueryBuilder(); $cursor = $qb->select('*') ->from('share') ->andWhere($qb->expr()->eq('file_source', $qb->createNamedParameter($path->getId()))) - ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))) - ->execute(); + ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(IShare::TYPE_EMAIL))) + ->executeQuery(); $shares = []; - while($data = $cursor->fetch()) { + while ($data = $cursor->fetch()) { $shares[] = $this->createShareObject($data); } $cursor->closeCursor(); @@ -518,7 +905,7 @@ class ShareByMailProvider implements IShareProvider { /** * @inheritdoc */ - public function getSharedWith($userId, $shareType, $node, $limit, $offset) { + public function getSharedWith($userId, $shareType, $node, $limit, $offset): array { /** @var IShare[] $shares */ $shares = []; @@ -536,7 +923,7 @@ class ShareByMailProvider implements IShareProvider { } $qb->setFirstResult($offset); - $qb->where($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))); + $qb->where($qb->expr()->eq('share_type', $qb->createNamedParameter(IShare::TYPE_EMAIL))); $qb->andWhere($qb->expr()->eq('share_with', $qb->createNamedParameter($userId))); // Filter by node if provided @@ -544,9 +931,9 @@ class ShareByMailProvider implements IShareProvider { $qb->andWhere($qb->expr()->eq('file_source', $qb->createNamedParameter($node->getId()))); } - $cursor = $qb->execute(); + $cursor = $qb->executeQuery(); - while($data = $cursor->fetch()) { + while ($data = $cursor->fetch()) { $shares[] = $this->createShareObject($data); } $cursor->closeCursor(); @@ -558,18 +945,16 @@ class ShareByMailProvider implements IShareProvider { /** * Get a share by token * - * @param string $token - * @return IShare * @throws ShareNotFound */ - public function getShareByToken($token) { + public function getShareByToken($token): IShare { $qb = $this->dbConnection->getQueryBuilder(); $cursor = $qb->select('*') ->from('share') - ->where($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))) + ->where($qb->expr()->eq('share_type', $qb->createNamedParameter(IShare::TYPE_EMAIL))) ->andWhere($qb->expr()->eq('token', $qb->createNamedParameter($token))) - ->execute(); + ->executeQuery(); $data = $cursor->fetch(); @@ -588,38 +973,41 @@ class ShareByMailProvider implements IShareProvider { /** * remove share from table - * - * @param string $shareId */ - protected function removeShareFromTable($shareId) { + protected function removeShareFromTable(int $shareId): void { $qb = $this->dbConnection->getQueryBuilder(); $qb->delete('share') ->where($qb->expr()->eq('id', $qb->createNamedParameter($shareId))); - $qb->execute(); + $qb->executeStatement(); } /** - * Create a share object from an database row + * Create a share object from a database row * - * @param array $data - * @return IShare * @throws InvalidShare * @throws ShareNotFound */ - protected function createShareObject($data) { - + protected function createShareObject(array $data): IShare { $share = new Share($this->rootFolder, $this->userManager); $share->setId((int)$data['id']) ->setShareType((int)$data['share_type']) ->setPermissions((int)$data['permissions']) ->setTarget($data['file_target']) ->setMailSend((bool)$data['mail_send']) + ->setNote($data['note']) ->setToken($data['token']); $shareTime = new \DateTime(); $shareTime->setTimestamp((int)$data['stime']); $share->setShareTime($shareTime); - $share->setSharedWith($data['share_with']); + $share->setSharedWith($data['share_with'] ?? ''); + $share->setPassword($data['password']); + $passwordExpirationTime = \DateTime::createFromFormat('Y-m-d H:i:s', $data['password_expiration_time'] ?? ''); + $share->setPasswordExpirationTime($passwordExpirationTime !== false ? $passwordExpirationTime : null); + $share->setLabel($data['label'] ?? ''); + $share->setSendPasswordByTalk((bool)$data['password_by_talk']); + $share->setHideDownload((bool)$data['hide_download']); + $share->setReminderSent((bool)$data['reminder_sent']); if ($data['uid_initiator'] !== null) { $share->setShareOwner($data['uid_owner']); @@ -633,6 +1021,15 @@ class ShareByMailProvider implements IShareProvider { $share->setShareOwner($owner->getUID()); } + if ($data['expiration'] !== null) { + $expiration = \DateTime::createFromFormat('Y-m-d H:i:s', $data['expiration']); + if ($expiration !== false) { + $share->setExpirationDate($expiration); + } + } + + $share = $this->updateShareAttributes($share, $data['attributes']); + $share->setNodeId((int)$data['file_source']); $share->setNodeType($data['item_type']); @@ -644,15 +1041,12 @@ class ShareByMailProvider implements IShareProvider { /** * Get the node with file $id for $user * - * @param string $userId - * @param int $id - * @return \OCP\Files\File|\OCP\Files\Folder * @throws InvalidShare */ - private function getNode($userId, $id) { + private function getNode(string $userId, int $id): Node { try { $userFolder = $this->rootFolder->getUserFolder($userId); - } catch (NotFoundException $e) { + } catch (NoUserException $e) { throw new InvalidShare(); } @@ -668,54 +1062,41 @@ class ShareByMailProvider implements IShareProvider { /** * A user is deleted from the system * So clean up the relevant shares. - * - * @param string $uid - * @param int $shareType */ - public function userDeleted($uid, $shareType) { + public function userDeleted($uid, $shareType): void { $qb = $this->dbConnection->getQueryBuilder(); $qb->delete('share') - ->where($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))) + ->where($qb->expr()->eq('share_type', $qb->createNamedParameter(IShare::TYPE_EMAIL))) ->andWhere($qb->expr()->eq('uid_owner', $qb->createNamedParameter($uid))) - ->execute(); + ->executeStatement(); } /** * This provider does not support group shares - * - * @param string $gid */ - public function groupDeleted($gid) { - return; + public function groupDeleted($gid): void { } /** * This provider does not support group shares - * - * @param string $uid - * @param string $gid */ - public function userDeletedFromGroup($uid, $gid) { - return; + public function userDeletedFromGroup($uid, $gid): void { } /** * get database row of a give share * - * @param $id - * @return array * @throws ShareNotFound */ - protected function getRawShare($id) { - + protected function getRawShare(int $id): array { // Now fetch the inserted share and create a complete share object $qb = $this->dbConnection->getQueryBuilder(); $qb->select('*') ->from('share') ->where($qb->expr()->eq('id', $qb->createNamedParameter($id))); - $cursor = $qb->execute(); + $cursor = $qb->executeQuery(); $data = $cursor->fetch(); $cursor->closeCursor(); @@ -726,38 +1107,49 @@ class ShareByMailProvider implements IShareProvider { return $data; } - public function getSharesInFolder($userId, Folder $node, $reshares) { + public function getSharesInFolder($userId, Folder $node, $reshares, $shallow = true): array { + return $this->getSharesInFolderInternal($userId, $node, $reshares); + } + + public function getAllSharesInFolder(Folder $node): array { + return $this->getSharesInFolderInternal(null, $node, null); + } + + /** + * @return array<int, list<IShare>> + */ + private function getSharesInFolderInternal(?string $userId, Folder $node, ?bool $reshares): array { $qb = $this->dbConnection->getQueryBuilder(); $qb->select('*') ->from('share', 's') - ->andWhere($qb->expr()->orX( - $qb->expr()->eq('item_type', $qb->createNamedParameter('file')), - $qb->expr()->eq('item_type', $qb->createNamedParameter('folder')) - )) + ->andWhere($qb->expr()->in('item_type', $qb->createNamedParameter(['file', 'folder'], IQueryBuilder::PARAM_STR_ARRAY))) ->andWhere( - $qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL)) + $qb->expr()->eq('share_type', $qb->createNamedParameter(IShare::TYPE_EMAIL)) ); - /** - * Reshares for this user are shares where they are the owner. - */ - if ($reshares === false) { - $qb->andWhere($qb->expr()->eq('uid_initiator', $qb->createNamedParameter($userId))); - } else { - $qb->andWhere( - $qb->expr()->orX( - $qb->expr()->eq('uid_owner', $qb->createNamedParameter($userId)), - $qb->expr()->eq('uid_initiator', $qb->createNamedParameter($userId)) - ) - ); + if ($userId !== null) { + /** + * Reshares for this user are shares where they are the owner. + */ + if ($reshares !== true) { + $qb->andWhere($qb->expr()->eq('uid_initiator', $qb->createNamedParameter($userId))); + } else { + $qb->andWhere( + $qb->expr()->orX( + $qb->expr()->eq('uid_owner', $qb->createNamedParameter($userId)), + $qb->expr()->eq('uid_initiator', $qb->createNamedParameter($userId)) + ) + ); + } } - $qb->innerJoin('s', 'filecache' ,'f', 's.file_source = f.fileid'); + $qb->innerJoin('s', 'filecache', 'f', $qb->expr()->eq('s.file_source', 'f.fileid')); + $qb->andWhere($qb->expr()->eq('f.parent', $qb->createNamedParameter($node->getId()))); $qb->orderBy('id'); - $cursor = $qb->execute(); + $cursor = $qb->executeQuery(); $shares = []; while ($data = $cursor->fetch()) { $shares[$data['fileid']][] = $this->createShareObject($data); @@ -767,4 +1159,85 @@ class ShareByMailProvider implements IShareProvider { return $shares; } + /** + * @inheritdoc + */ + public function getAccessList($nodes, $currentAccess): array { + $ids = []; + foreach ($nodes as $node) { + $ids[] = $node->getId(); + } + + $qb = $this->dbConnection->getQueryBuilder(); + $qb->select('share_with', 'file_source', 'token') + ->from('share') + ->where($qb->expr()->eq('share_type', $qb->createNamedParameter(IShare::TYPE_EMAIL))) + ->andWhere($qb->expr()->in('file_source', $qb->createNamedParameter($ids, IQueryBuilder::PARAM_INT_ARRAY))) + ->andWhere($qb->expr()->in('item_type', $qb->createNamedParameter(['file', 'folder'], IQueryBuilder::PARAM_STR_ARRAY))); + $cursor = $qb->executeQuery(); + + $public = false; + $mail = []; + while ($row = $cursor->fetch()) { + $public = true; + if ($currentAccess === false) { + $mail[] = $row['share_with']; + } else { + $mail[$row['share_with']] = [ + 'node_id' => $row['file_source'], + 'token' => $row['token'] + ]; + } + } + $cursor->closeCursor(); + + return ['public' => $public, 'mail' => $mail]; + } + + public function getAllShares(): iterable { + $qb = $this->dbConnection->getQueryBuilder(); + + $qb->select('*') + ->from('share') + ->where( + $qb->expr()->orX( + $qb->expr()->eq('share_type', $qb->createNamedParameter(IShare::TYPE_EMAIL)) + ) + ); + + $cursor = $qb->executeQuery(); + while ($data = $cursor->fetch()) { + try { + $share = $this->createShareObject($data); + } catch (InvalidShare $e) { + continue; + } catch (ShareNotFound $e) { + continue; + } + + yield $share; + } + $cursor->closeCursor(); + } + + /** + * Extract the emails from the share + * It can be a single email, from the share_with field + * or a list of emails from the emails attributes field. + * @param IShare $share + * @return string[] + */ + protected function getSharedWithEmails(IShare $share): array { + $attributes = $share->getAttributes(); + + if ($attributes === null) { + return [$share->getSharedWith()]; + } + + $emails = $attributes->getAttribute('shareWith', 'emails'); + if (isset($emails) && is_array($emails) && !empty($emails)) { + return $emails; + } + return [$share->getSharedWith()]; + } } |