Make a php script and set up a cron job (NO PLACEHOLDer BIDS)

Need a small script to automate work. You need to be able to write code. 1. Find new test reports made since last script run. (Last run should be stored in a file) Table: cars_services, column testreportDone Selection is all after last run We need carID 2. Send email with test report link So, from the result in step 1, we should only send to vendors wit email ending @[login to view URL] To get to this we take carID from table cars_services Go to table cars, and take customerID to look in table customers – customerID to see the email and name From table cars we also need regnumber To find the correct link to send in the email, go to cars_files use carID to search to get the filename Example: In table cars_service – coumn testreportDone we find carID 42101 We use 42101 in table cars to get regnumber: EK41338 and customerID 171 We use customerID 171 in table customers to get name: Petter Andersen and email something@ In cars_files we use 42101 to get filename: [login to view URL] Then we have this dataset CarID: 42101 Regnumber: EK41338 Name: Petter Andersen Email: something@ File: [login to view URL] First we validate the email is correct (ends with @[login to view URL]) We also need to have the first part of the url to show the file: (filename comes after this) [login to view URL] gives: [login to view URL] Then we send an email with the following: (Maybe the link should be the text “du kan se taksten her” instead of the full url) To: Name and e-mail: Petter Andersen (@[login to view URL]) Subject: Takst for registrationnumber Takst for EK41338 Body: EK 41338 er nå taksert og du kan se taksten her [login to view URL] Om det er noe du lurer på er det bare å ta kontakt Med vennlig hilsen Autoringen as Step 3 Log jobs done. Send email with result to admin