PHP & MySQL req'd for scheduled tasks in SuiteCRM
- or -
Post a project like this1694
£21/hr(approx. $26/hr)
- Posted:
- Proposals: 14
- Remote
- #2500701
- Awarded
Full Stack Web Developer/ Designer / Mobile Apps / Wordpress / Magento / Shopify / Opencart / BigCommerce / APIs / PHP / Python /
Bay Minette
React, PHP, Laravel, WordPress, Logo design, App Developer, AWS expert, React Native, Flutter, Android, IOS
City of London
Ninja: WCFM | Paid Membership Pro | MemberPress | WooCommerce | Multivendor | Doken | LifterLMS | LearnDash | GummiPress | ACF
Indore
Wordpress|Webflow|Shopify|Wix|CRM|PHP|Android|iOS|Bespoke|App|Zoho|Laravel|SEO|PPC|Social|React|Node|Flutter|React Native|Magento|PWA|Plugin|Chrome Extention
Mohali
PHP | Laravel||Magento | BigCommerce| Shopify | WordPress Website | Web app Developer
Ahmedabad
180501818816242819002440406638412517387365751298731125181091719458885977386450
Description
Experience Level: Expert
Hi,
We have a SuiteCRM deployment and need someone with PHP/MySQL experience to edit the scheduled tasks PHP file to create the following scheduled tasks:
All pre-requisite fields have been created and filled, so all that's required is the PHP/MySQL skill to create the PHP/MySQL jobs below - these are all stored in one single PHP file.
Task Name: ScheduledEmail1
Conditions: In the leads db table, if the date created is equal to or older than 7 days, and the status of the lead is 'new'
Actions: Email the associated email of the owner, as well as another email address stored in the user's 'IM' field, create an alert for user that says 'SE1 - This lead has been open for 7 days', which links to the lead that meets the conditions above, and set the lead status to 'Follow-up 1'.
Task Name: ScheduledEmail2
Conditions: In the leads db table, if the date create is equal to or older than 14 days, and the status of the lead is 'follow-up 1'
Actions: Email the associated email of the owner, as well as another email address stored in the user's 'IM' field, create an alert for user that says 'SE2 - This lead has been open for 14 days', which links to the lead that meets the conditions above, and set the lead status to 'Follow-up 2'.
Task Name: ScheduledEmail3
Conditions: In the leads db table, if the date create is equal to or older than 21 days, and the status of the lead is 'follow-up 2'
Actions: Email the associated email of the owner, as well as another email address stored in the user's 'IM' field, create an alert for user that says 'SE3 - This lead has been open for 21 days', which links to the lead that meets the conditions above, and set the lead status to 'Follow-up 3'.
Task Name: SetNFA
Conditions: In the leads db table, if the date create is older than 28 days, and the status of the lead is 'follow-up 3'
Actions: Email the associated email of the owner, as well as another email address stored in the user's 'IM' field, create an alert for user that says 'SE4 - This lead has been set as NFA (28 days without resolve)', which links to the lead that meets the conditions above, and set the lead status to 'NFA'.
We have a SuiteCRM deployment and need someone with PHP/MySQL experience to edit the scheduled tasks PHP file to create the following scheduled tasks:
All pre-requisite fields have been created and filled, so all that's required is the PHP/MySQL skill to create the PHP/MySQL jobs below - these are all stored in one single PHP file.
Task Name: ScheduledEmail1
Conditions: In the leads db table, if the date created is equal to or older than 7 days, and the status of the lead is 'new'
Actions: Email the associated email of the owner, as well as another email address stored in the user's 'IM' field, create an alert for user that says 'SE1 - This lead has been open for 7 days', which links to the lead that meets the conditions above, and set the lead status to 'Follow-up 1'.
Task Name: ScheduledEmail2
Conditions: In the leads db table, if the date create is equal to or older than 14 days, and the status of the lead is 'follow-up 1'
Actions: Email the associated email of the owner, as well as another email address stored in the user's 'IM' field, create an alert for user that says 'SE2 - This lead has been open for 14 days', which links to the lead that meets the conditions above, and set the lead status to 'Follow-up 2'.
Task Name: ScheduledEmail3
Conditions: In the leads db table, if the date create is equal to or older than 21 days, and the status of the lead is 'follow-up 2'
Actions: Email the associated email of the owner, as well as another email address stored in the user's 'IM' field, create an alert for user that says 'SE3 - This lead has been open for 21 days', which links to the lead that meets the conditions above, and set the lead status to 'Follow-up 3'.
Task Name: SetNFA
Conditions: In the leads db table, if the date create is older than 28 days, and the status of the lead is 'follow-up 3'
Actions: Email the associated email of the owner, as well as another email address stored in the user's 'IM' field, create an alert for user that says 'SE4 - This lead has been set as NFA (28 days without resolve)', which links to the lead that meets the conditions above, and set the lead status to 'NFA'.
James W.
100% (4)Projects Completed
4
Freelancers worked with
2
Projects awarded
42%
Last project
20 Aug 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
James
Will you be able to provide access to the CRM aswell? -
would u share your site link?
837357837350
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies