Improve the search of Inspection

[Francois-Werbrouck]

Context:

Based on ai-cfia/fertiscan-frontend#407 the search of Inspection will now be improved and better.

We limit the results to the information extracted on the label, since also incorporating the pictures would increase the search efficiency. If a picture is needed, the BE has the necessary info to perform a second request to download the picture.

Acceptance criteria

Currently we only have a search option between the verified inspections of a user and would like to expand to take theses parameters as inputs:

• fertilizerName: string;
• registrationNumber: string;
• lotNumber: string;
• inspectorName: string;
• lower_bound_date: Date;
• upper_bound_date: Date;
• organizationName: string;
• organizationAddress: string;
• organizationPhoneNumber: string;

We will return a list of results of a resume of all the inspections that have been verified

• inspection_id,
• inspection.upload_date
• inspection.updated_at
• inspection.picture_set_id (the folder_id),
• inspection.container_id
• label_info.id
• label_info.product_name (Fertilizer Name)
• label_info.main_organization_id
• label_info.main_organization_name
• label_info.main_organization_address
• label_info.main_organization_phone

We do not display the full label that has been extracted since it would cost too much to perform.
We do not limit the results based on the user_id, since we want a user to be able to search for any label. Therefor, we do not limit based on the access control polices for the results.

TODO

• Add High level search function for fertiscan with all parameters
• Add Queries in relevant modules to perform a search
• Add tests for all modules and functions (Check the functionality of the functions/modules)
• Add search tests suite (Check and assure the results are as expected)

[Francois-Werbrouck]

After discussion, we are changing dateOfInspection: Date; into lower_bound_date:Date and upper_bound_date:Date to allow Inspection to be search from a timeframe instead of a single date.