nextcloud /
server
| @@ 478-495 (lines=18) @@ | ||
| 475 | * @param IShare $parent |
|
| 476 | * @return IShare[] |
|
| 477 | */ |
|
| 478 | public function getChildren(IShare $parent) { |
|
| 479 | $children = []; |
|
| 480 | ||
| 481 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 482 | $qb->select('*') |
|
| 483 | ->from('share') |
|
| 484 | ->where($qb->expr()->eq('parent', $qb->createNamedParameter($parent->getId()))) |
|
| 485 | ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(self::SHARE_TYPE_REMOTE))) |
|
| 486 | ->orderBy('id'); |
|
| 487 | ||
| 488 | $cursor = $qb->execute(); |
|
| 489 | while($data = $cursor->fetch()) { |
|
| 490 | $children[] = $this->createShareObject($data); |
|
| 491 | } |
|
| 492 | $cursor->closeCursor(); |
|
| 493 | ||
| 494 | return $children; |
|
| 495 | } |
|
| 496 | ||
| 497 | /** |
|
| 498 | * Delete a share (owner unShares the file) |
|
| @@ 723-739 (lines=17) @@ | ||
| 720 | * @param \OCP\Files\Node $path |
|
| 721 | * @return IShare[] |
|
| 722 | */ |
|
| 723 | public function getSharesByPath(Node $path) { |
|
| 724 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 725 | ||
| 726 | $cursor = $qb->select('*') |
|
| 727 | ->from('share') |
|
| 728 | ->andWhere($qb->expr()->eq('file_source', $qb->createNamedParameter($path->getId()))) |
|
| 729 | ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(self::SHARE_TYPE_REMOTE))) |
|
| 730 | ->execute(); |
|
| 731 | ||
| 732 | $shares = []; |
|
| 733 | while($data = $cursor->fetch()) { |
|
| 734 | $shares[] = $this->createShareObject($data); |
|
| 735 | } |
|
| 736 | $cursor->closeCursor(); |
|
| 737 | ||
| 738 | return $shares; |
|
| 739 | } |
|
| 740 | ||
| 741 | /** |
|
| 742 | * @inheritdoc |
|
| @@ 570-587 (lines=18) @@ | ||
| 567 | * @param IShare $parent |
|
| 568 | * @return IShare[] |
|
| 569 | */ |
|
| 570 | public function getChildren(IShare $parent) { |
|
| 571 | $children = []; |
|
| 572 | ||
| 573 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 574 | $qb->select('*') |
|
| 575 | ->from('share') |
|
| 576 | ->where($qb->expr()->eq('parent', $qb->createNamedParameter($parent->getId()))) |
|
| 577 | ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))) |
|
| 578 | ->orderBy('id'); |
|
| 579 | ||
| 580 | $cursor = $qb->execute(); |
|
| 581 | while($data = $cursor->fetch()) { |
|
| 582 | $children[] = $this->createShareObject($data); |
|
| 583 | } |
|
| 584 | $cursor->closeCursor(); |
|
| 585 | ||
| 586 | return $children; |
|
| 587 | } |
|
| 588 | ||
| 589 | /** |
|
| 590 | * add share to the database and return the ID |
|
| @@ 778-794 (lines=17) @@ | ||
| 775 | * @param \OCP\Files\Node $path |
|
| 776 | * @return IShare[] |
|
| 777 | */ |
|
| 778 | public function getSharesByPath(Node $path) { |
|
| 779 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 780 | ||
| 781 | $cursor = $qb->select('*') |
|
| 782 | ->from('share') |
|
| 783 | ->andWhere($qb->expr()->eq('file_source', $qb->createNamedParameter($path->getId()))) |
|
| 784 | ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))) |
|
| 785 | ->execute(); |
|
| 786 | ||
| 787 | $shares = []; |
|
| 788 | while($data = $cursor->fetch()) { |
|
| 789 | $shares[] = $this->createShareObject($data); |
|
| 790 | } |
|
| 791 | $cursor->closeCursor(); |
|
| 792 | ||
| 793 | return $shares; |
|
| 794 | } |
|
| 795 | ||
| 796 | /** |
|
| 797 | * @inheritdoc |
|
