PRUEBA

REQUIREMENTS

Create a page for a WP website using the plugin WP Data Access. We aim to display rows of images based on a database query.

The database is existing (no data management). Nevertheless, it should be easy to replace the files with updated data.

The task consists into designing the query.

Finally, in Desktop view, the result should be exportable to PDF, possibly using an APP such as https://webtopdf.com/

Deadline: first half of 2022.

DATABASE STRUCTURE

We have two tables linked by the field ‘SPECIES’:

TABLE 1: ‘Species list’: SPECIES / HABITAT / PICTURE (URL image) / COMMON NAME / SCIENTIFIC NAME / STATUS / IDENTIFICATION / RED LIST

TABLE 2: ‘Species frequency’: SPECIES / SITE / MONTH / FREQUENCY / …

We want to display the result of a query in our WP site.

QUERY:

QUERY FIELD 1: ‘SITE’: ‘Doñana’/ …

QUERY FIELD 2: ‘MONTH’: ‘January’/ …

QUERY FIELD 3: Order: ‘Taxonomic order’/’Alphabetic order’/’Habitat’

RESULT – DESKTOP VIEW

BLOCK 1 ‘images’. Display all the species which ‘FREQUENCY’ is ‘Very Common’ or ‘Common’ in rows of 6 modules. For each modules:

• Main image = ‘PICTURE’.
• Background color is based on ‘HABITAT’ (10 types).
• Caption: A bullet which color is based on ‘IDENTIFICATION’ (4 types) followed by ‘COMMON NAME’ (in bold) and ‘SCIENTIFIC NAME‘ (in italic).
• Border is based on ‘RED LIST’ (5 types). If ‘FREQUENCY’ is ‘Common’, add a degree of opacity to the image (but not to the background).

BLOCK 2 ‘text’. For species which ‘FREQUENCY’ is ‘Unlikely’: display a text module with a list of ‘Common name’ (‘Scientific name‘) after the rows.

RESULT – SMARTPHONE VIEW

Similar but simpler. Rows of 3 modules.

• Main image (IDENTICAL)
• Background color (IDENTICAL)
• Caption: ‘COMMON NAME’ (in bold)
• Border (IDENTICAL)

BLOCK 2 ‘text’ (IDENTICAL)

ORDER: Taxonomic order