nextcloud /
server
| @@ 592-631 (lines=40) @@ | ||
| 589 | } |
|
| 590 | ||
| 591 | ||
| 592 | public function getSharesInFolder($userId, Folder $node, $reshares) { |
|
| 593 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 594 | $qb->select('*') |
|
| 595 | ->from('share', 's') |
|
| 596 | ->andWhere($qb->expr()->orX( |
|
| 597 | $qb->expr()->eq('item_type', $qb->createNamedParameter('file')), |
|
| 598 | $qb->expr()->eq('item_type', $qb->createNamedParameter('folder')) |
|
| 599 | )) |
|
| 600 | ->andWhere( |
|
| 601 | $qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_REMOTE)) |
|
| 602 | ); |
|
| 603 | ||
| 604 | /** |
|
| 605 | * Reshares for this user are shares where they are the owner. |
|
| 606 | */ |
|
| 607 | if ($reshares === false) { |
|
| 608 | $qb->andWhere($qb->expr()->eq('uid_initiator', $qb->createNamedParameter($userId))); |
|
| 609 | } else { |
|
| 610 | $qb->andWhere( |
|
| 611 | $qb->expr()->orX( |
|
| 612 | $qb->expr()->eq('uid_owner', $qb->createNamedParameter($userId)), |
|
| 613 | $qb->expr()->eq('uid_initiator', $qb->createNamedParameter($userId)) |
|
| 614 | ) |
|
| 615 | ); |
|
| 616 | } |
|
| 617 | ||
| 618 | $qb->innerJoin('s', 'filecache' ,'f', $qb->expr()->eq('s.file_source', 'f.fileid')); |
|
| 619 | $qb->andWhere($qb->expr()->eq('f.parent', $qb->createNamedParameter($node->getId()))); |
|
| 620 | ||
| 621 | $qb->orderBy('id'); |
|
| 622 | ||
| 623 | $cursor = $qb->execute(); |
|
| 624 | $shares = []; |
|
| 625 | while ($data = $cursor->fetch()) { |
|
| 626 | $shares[$data['fileid']][] = $this->createShareObject($data); |
|
| 627 | } |
|
| 628 | $cursor->closeCursor(); |
|
| 629 | ||
| 630 | return $shares; |
|
| 631 | } |
|
| 632 | ||
| 633 | /** |
|
| 634 | * @inheritdoc |
|
| @@ 1015-1054 (lines=40) @@ | ||
| 1012 | return $data; |
|
| 1013 | } |
|
| 1014 | ||
| 1015 | public function getSharesInFolder($userId, Folder $node, $reshares) { |
|
| 1016 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 1017 | $qb->select('*') |
|
| 1018 | ->from('share', 's') |
|
| 1019 | ->andWhere($qb->expr()->orX( |
|
| 1020 | $qb->expr()->eq('item_type', $qb->createNamedParameter('file')), |
|
| 1021 | $qb->expr()->eq('item_type', $qb->createNamedParameter('folder')) |
|
| 1022 | )) |
|
| 1023 | ->andWhere( |
|
| 1024 | $qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL)) |
|
| 1025 | ); |
|
| 1026 | ||
| 1027 | /** |
|
| 1028 | * Reshares for this user are shares where they are the owner. |
|
| 1029 | */ |
|
| 1030 | if ($reshares === false) { |
|
| 1031 | $qb->andWhere($qb->expr()->eq('uid_initiator', $qb->createNamedParameter($userId))); |
|
| 1032 | } else { |
|
| 1033 | $qb->andWhere( |
|
| 1034 | $qb->expr()->orX( |
|
| 1035 | $qb->expr()->eq('uid_owner', $qb->createNamedParameter($userId)), |
|
| 1036 | $qb->expr()->eq('uid_initiator', $qb->createNamedParameter($userId)) |
|
| 1037 | ) |
|
| 1038 | ); |
|
| 1039 | } |
|
| 1040 | ||
| 1041 | $qb->innerJoin('s', 'filecache' ,'f', $qb->expr()->eq('s.file_source', 'f.fileid')); |
|
| 1042 | $qb->andWhere($qb->expr()->eq('f.parent', $qb->createNamedParameter($node->getId()))); |
|
| 1043 | ||
| 1044 | $qb->orderBy('id'); |
|
| 1045 | ||
| 1046 | $cursor = $qb->execute(); |
|
| 1047 | $shares = []; |
|
| 1048 | while ($data = $cursor->fetch()) { |
|
| 1049 | $shares[$data['fileid']][] = $this->createShareObject($data); |
|
| 1050 | } |
|
| 1051 | $cursor->closeCursor(); |
|
| 1052 | ||
| 1053 | return $shares; |
|
| 1054 | } |
|
| 1055 | ||
| 1056 | /** |
|
| 1057 | * @inheritdoc |
|
