Gallery in php mysql

It is necessary to make a gallery of images in php mysql (backend frontend from html template)

1. Saving images to the database:
At the input get request comes a link to the image and other information for the database
1.1. Overlay watermark from png file
1.2. A resize is made in 2 sizes: a large image and a preview. Images can be either vertical or horizontal. It is necessary to provide that the previews of vertical photos are the same size as the horizontal one (add a white background around the edges).
1.3 - files are saved in object storage on the cloud.yandex.ru
1.4 - take the url to the uploaded images on the cloud.yandex.ru
1.5 - an entry is created in the table in the database that you create with:
- id
- date of addition
- category (first set to process)
- * 6 test fields *
- link to a large image on cloud.yandex
- Link to preview at cloud.yandex
- number of views
- number of votes
1.6. I will need a link template to send GET requests to it in the form of : link/?date={}&author={} and so on

2. Make a simple admin. panel for editing images in the database:
- Easiest authorization by .htpasswd
- Menu by category a separate item for raw images
- Image editing: editing all text fields, selecting a category for the image, when selecting a child category, the image will be available both in the selected category section and in the parent category. deleting an image
- Create a bd table for categories: id, title, title, description, keywords, url, h1, text, parent_id
- Ability to add a new category
- Category editing: edit text fields, selecting this main category or nested within another. there will be no nested in the child.

3. Front
- Output from the database list of the main sections of categories, when you click on the category, the category page opens, the information from the database (title, description, keywords) is put in. If there are nested ones in this category, display them also on the page as links. Below is a gallery with all the images in the category (from all nested).
- the html template already has a gallery page template
- from the existing html template gallery make a php file, which, depending on the id category passed in the GET request, displays all the images in the corresponding category
- page pagination
- a large image opens by clicking (js script prettyPhoto), in the modal window at the bottom of the photo text information about the author of the image is displayed (from text fields in the database) the number of views of the Like button and the number of likes

Advise on how best to implement the counter of image and voice views so that there is not a large load on the database.

Please offer your budget and the time required for development. TK is complete, before we start, minor edits/additions are possible.

Ill see the responses in a day. Thanks in advance