Genesys Backend issueshttps://gitlab.croptrust.org/genesys-pgr/genesys-server/-/issues2021-02-15T09:56:52+01:00https://gitlab.croptrust.org/genesys-pgr/genesys-server/-/issues/420Spatial data2021-02-15T09:56:52+01:00Matija ObrezaSpatial dataWe'd like to make spatial (polygon) queries for accessions in Genesys.
## Use case
https://www.genesys-pgr.org/explore/map has the **Select area** that allows user to select a rectangle (`min&max` for accession collecting site `latitu...We'd like to make spatial (polygon) queries for accessions in Genesys.
## Use case
https://www.genesys-pgr.org/explore/map has the **Select area** that allows user to select a rectangle (`min&max` for accession collecting site `latitude&longitude`). If we allow user to select a polygon (https://leafletjs.com/reference-1.4.0.html#polygon), can the API make a query to the database to find accessions where `accessionGeo` is **inside** the selected polygon?
- https://mariadb.com/kb/en/library/geographic-geometric-features/
- https://www.baeldung.com/hibernate-spatial
## Other cases
- `FaoInstitute` location has `lat&long`2.5Maxym BorodenkoMaxym Borodenkohttps://gitlab.croptrust.org/genesys-pgr/genesys-server/-/issues/91The area of pressing on the "Choose File" button is too large.2018-12-21T17:36:05+01:00Aleksandr KirichenkoThe area of pressing on the "Choose File" button is too large.**Steps:**
1. Go to "https://sandbox.genesys-pgr.org/welcome";
2. Login as ADMINISTRATOR;
3. Click on the User name in the header
4. Click on the "Administration";
4. Click on the "Repository" menu item;
5. Click on the "Repository file...**Steps:**
1. Go to "https://sandbox.genesys-pgr.org/welcome";
2. Login as ADMINISTRATOR;
3. Click on the User name in the header
4. Click on the "Administration";
4. Click on the "Repository" menu item;
5. Click on the "Repository file manager" in the drop down menu;
6. Click on a space in the middle of the page right of the "Choose File" button;
**Exp.res.:** "Open File" window isn't opened.
**Act.res:** "Open File" window is opened. ![SCR_0008](/uploads/8fb8a23a48c683861caee16eaaaf7a53/SCR_0008.png)Andrey GarnitskiyAndrey Garnitskiyhttps://gitlab.croptrust.org/genesys-pgr/genesys-server/-/issues/22QueryDSL2020-11-20T10:03:22+01:00Matija ObrezaQueryDSLGenesys filtering currently uses the `DirectMysqlQuery` to generate SQL from `AppliedFilters` (JSON filters).
Bring in QueryDSL and generate the query from `AppliedFilters`.Genesys filtering currently uses the `DirectMysqlQuery` to generate SQL from `AppliedFilters` (JSON filters).
Bring in QueryDSL and generate the query from `AppliedFilters`.Maxym BorodenkoMaxym Borodenkohttps://gitlab.croptrust.org/genesys-pgr/genesys-server/-/issues/20FTP server2017-09-28T15:23:33+02:00Matija ObrezaFTP serverInclude latest file-repository with FTP support in Genesys Server project. This will allow users to upload and manage accession images using the well-established FTP protocol.
Example code for FTP server is in the unit tests of `file-re...Include latest file-repository with FTP support in Genesys Server project. This will allow users to upload and manage accession images using the well-established FTP protocol.
Example code for FTP server is in the unit tests of `file-repository`.
Related issues:
- #156 Matija ObrezaMatija Obreza