Freelancer is expected to write a cron job php to run every day after midnight. Table affected is given attached:
- for each seller (s_id), it will check from date_product table if any product (product_id) exists for today+7th day (if today is 1 September Tuesday, then it will check for next week Tuesday 8 September)
- If no entry exists for that s_id for 8 September, then cron job will copy all product ids for that seller (s_id) in the table with 1 September to 8 September. If nothing exists for 1 September too, it will not copy anything.
- Cron Job will also delete all entries from date_product table which dates are older than 15 days
- Cron Job will also email a report in plain text body as below reporting sellers to admin using Prestashop email function:
S_ID – Has active menu (means it found product and did not copy)
S_ID – Nothing to copy (means it didnt find product but also nothing to copy)
S_ID – Copied from 01 Sept to 08 Sept…………
Multi-talented graphic designer is at your disposal. I have 6 years’ experience in graphic design. I am expert in graphic designing & ready to help you out. I will professionally design A+ quality eye catching amazing cron job for your business, in keeping with your requirements/expectations. I have gone through your project description. I have a deep passion in graphic design and guarantee that all of my design is 100% original. I am a professional graphic designer with creative multiple designing skills and upon your request. I’ll provide you 2 to 3 options with different concepts and will provide you unlimited revisions till your satisfaction. I can show you references of my work. I highly value professionalism and hold myself strictly accountable to represent my client’s brand.
I aim to form a long-term working relationship. I'll give infinite modifications till your complete satisfaction. Kindly discuss for more details. I assure you, I can be the person you are looking for!
Thanks.