Build a Laravel Eloquent / MySQL query
£10-20 GBP
货到付款
I have a query in Laravel Eloquent and need someone to help create it.
The logic is follows, the user can create their own criteria to send mails to customers in the database.
The criteria they can set is:
Customer has { exactly / more / less} {X} visits DONE
Customer last visited {exact / more / less} {X} days ago
Customer first visited {more / less} {X} days ago
Customer logged in using {email / facebook / twitter}
Customer is {male / female / both} gender
The database looks something like the following:
| id | name | email | provider | created_at
---------------------------------------------------------------------------------------
| 1 | Mr Smith | [login to view URL]@[login to view URL] | facebook | 2018-11-01 09:00:00 |
| 2 | Mrs Smith | [login to view URL]@[login to view URL] | facebook | 2018-11-01 09:00:00 |
| 3 | Miss Smith | [login to view URL]@[login to view URL] | email | 2018-11-01 09:00:00 |
| 4 | Doctor Smith | [login to view URL]@[login to view URL] | email | 2018-11-01 09:00:00 |
| 5 | 'Lord Smith | [login to view URL]@[login to view URL] | twitter | 2018-11-01 09:00:00 |
| 6 | Lady Smith | [login to view URL]@[login to view URL] | email | 2018-11-01 09:00:00 |
| 7 | Mr Smith | [login to view URL]@[login to view URL] | facebook | 2018-11-02 09:00:00 |
| 8 | Mrs Smith | [login to view URL]@[login to view URL] | facebook | 2018-11-02 09:00:00 |
| 9 | Doctor Smith | [login to view URL]@[login to view URL] | email | 2018-11-02 09:00:00 |
| 10 | Lord Smith | [login to view URL]@[login to view URL] | twitter | 2018-11-02 09:00:00 |
| 11 | Lady Smith | [login to view URL]@[login to view URL] | email | 2018-11-02 09:00:00 |
| 12 | Mr Smith | [login to view URL]@[login to view URL] | facebook | 2018-11-03 09:00:00 |
| 13 | Mrs Smith | [login to view URL]@[login to view URL] | facebook | 2018-11-03 09:00:00 |
| 14 | Miss Smith | [login to view URL]@[login to view URL] | email | 2018-11-03 09:00:00 |
| 15 | Lord Smith | [login to view URL]@[login to view URL] | twitter | 2018-11-03 09:00:00 |
| 16 | Lady Smith | [login to view URL]@[login to view URL] | email | 2018-11-03 09:00:00 |
End result, I need to build a query based on the selected criteria
项目ID： #18175590
关于项目
授予：
Hi, i have the right expertise in laravel, eloquent orm and mysql query, contact me if you need my help, Best regards.
有11名威客正在参与此工作的竞标，均价£26/小时
Full Stack Developer (Laravel Expert) I am confident that you will be completely satisfied with the quality, timeliness, and professionalism of my work. - hourly rate: 20$ - Masters degree in Computer Science - mo 更多
hi, i would like to create the query based on the criteria. get in touch to discuss more details of it.
Separate eloquent queries can be made. The last query regarding gender cannot be done as it is not stored in the table . You may provide your files for me to code the eloquent queries. Thanks
Hello, I am in this IT field from last 9 years and worked up to ERP level. We are team of 7 developers, each having experience of 4 years and working in latest technology like PHP, Word press, Laravel, Codeignite 更多
Hello, I am Mangesh Shinde and I am a experienced web developer and have experience in laravel framework. I can help you build a query as mentioned in your project description to send emails to specific customers. I 更多
Hi I am full stack web developer.i have 2 year experience in development. Please give me the chance for your work. i will done your work in better way. I am waiting for your response Thanks.
Hello I read your description and understand your requirement and very keen to go with it. . I am a skilled full stack developer worked on different frameworks of PHP (laravel , magento, codeigniter, opencart, et 更多
