nextcloud /
server
| @@ 472-489 (lines=18) @@ | ||
| 469 | * @param IShare $parent |
|
| 470 | * @return IShare[] |
|
| 471 | */ |
|
| 472 | public function getChildren(IShare $parent) { |
|
| 473 | $children = []; |
|
| 474 | ||
| 475 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 476 | $qb->select('*') |
|
| 477 | ->from('share') |
|
| 478 | ->where($qb->expr()->eq('parent', $qb->createNamedParameter($parent->getId()))) |
|
| 479 | ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(self::SHARE_TYPE_REMOTE))) |
|
| 480 | ->orderBy('id'); |
|
| 481 | ||
| 482 | $cursor = $qb->execute(); |
|
| 483 | while($data = $cursor->fetch()) { |
|
| 484 | $children[] = $this->createShareObject($data); |
|
| 485 | } |
|
| 486 | $cursor->closeCursor(); |
|
| 487 | ||
| 488 | return $children; |
|
| 489 | } |
|
| 490 | ||
| 491 | /** |
|
| 492 | * Delete a share (owner unShares the file) |
|
| @@ 717-733 (lines=17) @@ | ||
| 714 | * @param \OCP\Files\Node $path |
|
| 715 | * @return IShare[] |
|
| 716 | */ |
|
| 717 | public function getSharesByPath(Node $path) { |
|
| 718 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 719 | ||
| 720 | $cursor = $qb->select('*') |
|
| 721 | ->from('share') |
|
| 722 | ->andWhere($qb->expr()->eq('file_source', $qb->createNamedParameter($path->getId()))) |
|
| 723 | ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(self::SHARE_TYPE_REMOTE))) |
|
| 724 | ->execute(); |
|
| 725 | ||
| 726 | $shares = []; |
|
| 727 | while($data = $cursor->fetch()) { |
|
| 728 | $shares[] = $this->createShareObject($data); |
|
| 729 | } |
|
| 730 | $cursor->closeCursor(); |
|
| 731 | ||
| 732 | return $shares; |
|
| 733 | } |
|
| 734 | ||
| 735 | /** |
|
| 736 | * @inheritdoc |
|
| @@ 394-411 (lines=18) @@ | ||
| 391 | * @param IShare $parent |
|
| 392 | * @return IShare[] |
|
| 393 | */ |
|
| 394 | public function getChildren(IShare $parent) { |
|
| 395 | $children = []; |
|
| 396 | ||
| 397 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 398 | $qb->select('*') |
|
| 399 | ->from('share') |
|
| 400 | ->where($qb->expr()->eq('parent', $qb->createNamedParameter($parent->getId()))) |
|
| 401 | ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))) |
|
| 402 | ->orderBy('id'); |
|
| 403 | ||
| 404 | $cursor = $qb->execute(); |
|
| 405 | while($data = $cursor->fetch()) { |
|
| 406 | $children[] = $this->createShareObject($data); |
|
| 407 | } |
|
| 408 | $cursor->closeCursor(); |
|
| 409 | ||
| 410 | return $children; |
|
| 411 | } |
|
| 412 | ||
| 413 | /** |
|
| 414 | * add share to the database and return the ID |
|
| @@ 601-617 (lines=17) @@ | ||
| 598 | * @param \OCP\Files\Node $path |
|
| 599 | * @return IShare[] |
|
| 600 | */ |
|
| 601 | public function getSharesByPath(Node $path) { |
|
| 602 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 603 | ||
| 604 | $cursor = $qb->select('*') |
|
| 605 | ->from('share') |
|
| 606 | ->andWhere($qb->expr()->eq('file_source', $qb->createNamedParameter($path->getId()))) |
|
| 607 | ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))) |
|
| 608 | ->execute(); |
|
| 609 | ||
| 610 | $shares = []; |
|
| 611 | while($data = $cursor->fetch()) { |
|
| 612 | $shares[] = $this->createShareObject($data); |
|
| 613 | } |
|
| 614 | $cursor->closeCursor(); |
|
| 615 | ||
| 616 | return $shares; |
|
| 617 | } |
|
| 618 | ||
| 619 | /** |
|
| 620 | * @inheritdoc |
|
