nextcloud /
server
| @@ 471-488 (lines=18) @@ | ||
| 468 | * @param IShare $parent |
|
| 469 | * @return IShare[] |
|
| 470 | */ |
|
| 471 | public function getChildren(IShare $parent) { |
|
| 472 | $children = []; |
|
| 473 | ||
| 474 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 475 | $qb->select('*') |
|
| 476 | ->from('share') |
|
| 477 | ->where($qb->expr()->eq('parent', $qb->createNamedParameter($parent->getId()))) |
|
| 478 | ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(self::SHARE_TYPE_REMOTE))) |
|
| 479 | ->orderBy('id'); |
|
| 480 | ||
| 481 | $cursor = $qb->execute(); |
|
| 482 | while($data = $cursor->fetch()) { |
|
| 483 | $children[] = $this->createShareObject($data); |
|
| 484 | } |
|
| 485 | $cursor->closeCursor(); |
|
| 486 | ||
| 487 | return $children; |
|
| 488 | } |
|
| 489 | ||
| 490 | /** |
|
| 491 | * Delete a share (owner unShares the file) |
|
| @@ 716-732 (lines=17) @@ | ||
| 713 | * @param \OCP\Files\Node $path |
|
| 714 | * @return IShare[] |
|
| 715 | */ |
|
| 716 | public function getSharesByPath(Node $path) { |
|
| 717 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 718 | ||
| 719 | $cursor = $qb->select('*') |
|
| 720 | ->from('share') |
|
| 721 | ->andWhere($qb->expr()->eq('file_source', $qb->createNamedParameter($path->getId()))) |
|
| 722 | ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(self::SHARE_TYPE_REMOTE))) |
|
| 723 | ->execute(); |
|
| 724 | ||
| 725 | $shares = []; |
|
| 726 | while($data = $cursor->fetch()) { |
|
| 727 | $shares[] = $this->createShareObject($data); |
|
| 728 | } |
|
| 729 | $cursor->closeCursor(); |
|
| 730 | ||
| 731 | return $shares; |
|
| 732 | } |
|
| 733 | ||
| 734 | /** |
|
| 735 | * @inheritdoc |
|
| @@ 372-389 (lines=18) @@ | ||
| 369 | * @param IShare $parent |
|
| 370 | * @return IShare[] |
|
| 371 | */ |
|
| 372 | public function getChildren(IShare $parent) { |
|
| 373 | $children = []; |
|
| 374 | ||
| 375 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 376 | $qb->select('*') |
|
| 377 | ->from('share') |
|
| 378 | ->where($qb->expr()->eq('parent', $qb->createNamedParameter($parent->getId()))) |
|
| 379 | ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))) |
|
| 380 | ->orderBy('id'); |
|
| 381 | ||
| 382 | $cursor = $qb->execute(); |
|
| 383 | while($data = $cursor->fetch()) { |
|
| 384 | $children[] = $this->createShareObject($data); |
|
| 385 | } |
|
| 386 | $cursor->closeCursor(); |
|
| 387 | ||
| 388 | return $children; |
|
| 389 | } |
|
| 390 | ||
| 391 | /** |
|
| 392 | * add share to the database and return the ID |
|
| @@ 579-595 (lines=17) @@ | ||
| 576 | * @param \OCP\Files\Node $path |
|
| 577 | * @return IShare[] |
|
| 578 | */ |
|
| 579 | public function getSharesByPath(Node $path) { |
|
| 580 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 581 | ||
| 582 | $cursor = $qb->select('*') |
|
| 583 | ->from('share') |
|
| 584 | ->andWhere($qb->expr()->eq('file_source', $qb->createNamedParameter($path->getId()))) |
|
| 585 | ->andWhere($qb->expr()->eq('share_type', $qb->createNamedParameter(\OCP\Share::SHARE_TYPE_EMAIL))) |
|
| 586 | ->execute(); |
|
| 587 | ||
| 588 | $shares = []; |
|
| 589 | while($data = $cursor->fetch()) { |
|
| 590 | $shares[] = $this->createShareObject($data); |
|
| 591 | } |
|
| 592 | $cursor->closeCursor(); |
|
| 593 | ||
| 594 | return $shares; |
|
| 595 | } |
|
| 596 | ||
| 597 | /** |
|
| 598 | * @inheritdoc |
|
