nextcloud /
server
| @@ 585-624 (lines=40) @@ | ||
| 582 | } |
|
| 583 | ||
| 584 | ||
| 585 | public function getSharesInFolder($userId, Folder $node, $reshares) { |
|
| 586 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 587 | $qb->select('*') |
|
| 588 | ->from('share', 's') |
|
| 589 | ->andWhere($qb->expr()->orX( |
|
| 590 | $qb->expr()->eq('item_type', $qb->createNamedParameter('file')), |
|
| 591 | $qb->expr()->eq('item_type', $qb->createNamedParameter('folder')) |
|
| 592 | )) |
|
| 593 | ->andWhere( |
|
| 594 | $qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_REMOTE)) |
|
| 595 | ); |
|
| 596 | ||
| 597 | /** |
|
| 598 | * Reshares for this user are shares where they are the owner. |
|
| 599 | */ |
|
| 600 | if ($reshares === false) { |
|
| 601 | $qb->andWhere($qb->expr()->eq('uid_initiator', $qb->createNamedParameter($userId))); |
|
| 602 | } else { |
|
| 603 | $qb->andWhere( |
|
| 604 | $qb->expr()->orX( |
|
| 605 | $qb->expr()->eq('uid_owner', $qb->createNamedParameter($userId)), |
|
| 606 | $qb->expr()->eq('uid_initiator', $qb->createNamedParameter($userId)) |
|
| 607 | ) |
|
| 608 | ); |
|
| 609 | } |
|
| 610 | ||
| 611 | $qb->innerJoin('s', 'filecache' ,'f', 's.file_source = f.fileid'); |
|
| 612 | $qb->andWhere($qb->expr()->eq('f.parent', $qb->createNamedParameter($node->getId()))); |
|
| 613 | ||
| 614 | $qb->orderBy('id'); |
|
| 615 | ||
| 616 | $cursor = $qb->execute(); |
|
| 617 | $shares = []; |
|
| 618 | while ($data = $cursor->fetch()) { |
|
| 619 | $shares[$data['fileid']][] = $this->createShareObject($data); |
|
| 620 | } |
|
| 621 | $cursor->closeCursor(); |
|
| 622 | ||
| 623 | return $shares; |
|
| 624 | } |
|
| 625 | ||
| 626 | /** |
|
| 627 | * @inheritdoc |
|
| @@ 816-855 (lines=40) @@ | ||
| 813 | return $data; |
|
| 814 | } |
|
| 815 | ||
| 816 | public function getSharesInFolder($userId, Folder $node, $reshares) { |
|
| 817 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 818 | $qb->select('*') |
|
| 819 | ->from('share', 's') |
|
| 820 | ->andWhere($qb->expr()->orX( |
|
| 821 | $qb->expr()->eq('item_type', $qb->createNamedParameter('file')), |
|
| 822 | $qb->expr()->eq('item_type', $qb->createNamedParameter('folder')) |
|
| 823 | )) |
|
| 824 | ->andWhere( |
|
| 825 | $qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL)) |
|
| 826 | ); |
|
| 827 | ||
| 828 | /** |
|
| 829 | * Reshares for this user are shares where they are the owner. |
|
| 830 | */ |
|
| 831 | if ($reshares === false) { |
|
| 832 | $qb->andWhere($qb->expr()->eq('uid_initiator', $qb->createNamedParameter($userId))); |
|
| 833 | } else { |
|
| 834 | $qb->andWhere( |
|
| 835 | $qb->expr()->orX( |
|
| 836 | $qb->expr()->eq('uid_owner', $qb->createNamedParameter($userId)), |
|
| 837 | $qb->expr()->eq('uid_initiator', $qb->createNamedParameter($userId)) |
|
| 838 | ) |
|
| 839 | ); |
|
| 840 | } |
|
| 841 | ||
| 842 | $qb->innerJoin('s', 'filecache' ,'f', 's.file_source = f.fileid'); |
|
| 843 | $qb->andWhere($qb->expr()->eq('f.parent', $qb->createNamedParameter($node->getId()))); |
|
| 844 | ||
| 845 | $qb->orderBy('id'); |
|
| 846 | ||
| 847 | $cursor = $qb->execute(); |
|
| 848 | $shares = []; |
|
| 849 | while ($data = $cursor->fetch()) { |
|
| 850 | $shares[$data['fileid']][] = $this->createShareObject($data); |
|
| 851 | } |
|
| 852 | $cursor->closeCursor(); |
|
| 853 | ||
| 854 | return $shares; |
|
| 855 | } |
|
| 856 | ||
| 857 | } |
|
| 858 | ||
