1. Имеем url на файл https://r7.office.ru/doc.html?id=22346

1.1. Найдите имя файла

select * from public."Documents" Where "Id"=22346;

Где:

• 22346 — id из URL.

Вывод:

-[ RECORD 1 ]--+-----------------------------------------
Id             | 22346
FileId         | 57175
Name           | Горячие пирожки и соусы.xlsx
Hash           | 137111EC7B0CC7B4265FHDA4FAA2A17313B8
DirectoryId    | 27617
Timestamp      | 2023-09-22 19:41:33.782926
Date           | 2023-09-22 19:41:14.818
Description    | Создано
Status         | 0
Type           | 0
OriginalFileId | 56942
PreviewFileId  |
IsDeleted      | f
OfflineFileId  |
OwnerId        | 168

1.2. Найдите владельца файла

select * from "Users" where "Id" = '168';

Где:

• 168 — OwnerId из вывода п.1.1.

Вывод

-[ RECORD 1 ]+-----------------------------------------------------------------------------------------
Id           | 168
CustomerId   | 1
ContactId    | 168
Status       | 1
Login        | stepan.r7movich@office.ru
PasswordHash | E8joZvHLrvGJsvQN45gHpZ3OWKUZ4637ckA8aGNfjvenBxjbsbQkz765J7CiVVAw
Name         | Р7мович Степан
Type         | 0
PhotoId      |
Modified     |
Gender       | 0
Timestamp    | 2023-09-22 18:21:38.890528

1.3. Найдите каталог, в котором лежит файл

select * from public."DocumentDirectories" Where "Id"=27617;

Где:

• 27617 — DirectoryId из вывода п.1.1.

Вывод

-[ RECORD 1 ]----+-----------------------------------------
Id               | 27617
ParentId         | 27003
OwnerId          | 131
Hash             | BC0BE4BFFC6C193806909C01E6095D90AEBBE0B7
Name             | Пышечная
CustomerId       | 1
Description      | Пышечная
Order            | 0
Type             | 0
IconId           |
PatternId        |
SendNotification | f
IsDeleted        | f
Timestamp        | 2023-09-22 19:06:17.444366
HasRights        | t
Size             |
SourceParentId   | 27003

1.4. Находим дерево каталогов

select * from public."DocumentDirectories" Where "Id" IN (select "ParentId" from public."DirectoryHierarchies" WHERE "DirectoryId" IN (select "DirectoryId" from public."Documents" Where "Id"=22346));

Где:

• 22346 — id из URL.

Вывод

-[ RECORD 1 ]----+-----------------------------------------
Id               | 5
ParentId         |
OwnerId          | -1
Hash             | FDD547417D17B86465HGJKS5GH3B0AF0B1A50D389B199
Name             | Общие
CustomerId       | 1
Description      | Общие
Order            | 40
Type             | 4
IconId           |
PatternId        | 5
SendNotification | f
IsDeleted        | f
Timestamp        | 2023-09-22 15:07:12.344397
HasRights        | f
Size             |
SourceParentId   |
-[ RECORD 2 ]----+-----------------------------------------
Id               | 27003
ParentId         | 27001
OwnerId          | 131
Hash             | 7B705A8D47E8761E38GSGFR666A4F2DABE7E68
Name             | Рабочие печки пышечной
CustomerId       | 1
Description      | Рабочие печки пышечной
Order            | 0
Type             | 0
IconId           |
PatternId        |
SendNotification | f
IsDeleted        | f
Timestamp        | 2023-09-22 18:58:04.792563
HasRights        | t
Size             |
SourceParentId   | 27001
-[ RECORD 3 ]----+-----------------------------------------
Id               | 27001
ParentId         | 5
OwnerId          | 131
Hash             | 60F2E2637BHT5V4KYTV3B1A20DB9B0E39B672F68674C59FD
Name             | Пекари
CustomerId       | 1
Description      | Пекари
Order            | 0
Type             | 0
IconId           |
PatternId        |
SendNotification | f
IsDeleted        | f
Timestamp        | 2023-09-22 18:58:04.758143
HasRights        | t
Size             |
SourceParentId   | 5