Make changes to reporting code

General information for the website: Below
Description of requirements/features: We have a script which has a query builder and currently includes some static filters (for example, where status = 1 or where date is between date 1 and date 2) which now needs some modifications made to it - namely the ability to have dynamic filters (i.e. based on lookup from MySQL rather than hard coded based on yes/no 1/0 etc), relative dates (last/next x days, weeks, months etc) and option to have more than one filter so for example something like where (colour = red or colour = blue) and status=1 etc

The script is written in PHP with no frameworks - these are modifications only and the core work is already done.

We need someone to add one of each of the above three requests to a source and then we will replicate this across the other data sources.

We appreciate it is hard to bid when you have not seen the code in question but, likewise, we cannot share code ad hoc so please bid on the basis that it will take 12 hours work and then once we narrow down we can refine this

There is ample repeat work for the successful applicant should they wish
Extra notes: