This is all done LAMP stack. Will want to review flow diagrams, database designs, and maybe review code. I am a programmer, but do not have time to take on this project. I'm seeking help for this client.
I need a program that will enable me to respond to posts made by users of [login to view URL]:
1. Log all posts made that fit user defined criteria. (RSS Feed filtering)
a. Positive Keywords
b. Negative keywords
c. Regions/Cities (craigslist subdomains)
d. Categories
2. For each post that passed filtering
a. Send email response. Rotate emails via different third party email providers to avoid limits. Store emails and passwords. Set emails limts per account per 24 hours.
b. Send email based on template with some customization - subject, body, etc. Subject should default with craigslist posting title.
c. The capability to send test email Messages
d. Be able to attach files to Plain-Text and HTML emails
e. Do not set emails to duplicate postings
f. Use RegEx to check for US phone number. 10 digits. If contains phone number, flag for separate reporting/follow up.
Reporting
For each post:
A reporting page/table that has list of posts
a. posted timestamp, URL, headline, email timestamp, email address used to send email, phone number if found, link to view content (or maybe just add to main table)
b. Export to Excel/CSV
c. Track emails sent. May sign up for email tracking service to view readership. (might need to pull this back into the main table too)