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
หมายเลขโปรเจค: #18175590
เกี่ยวกับโปรเจกต์
มอบให้กับ:
Hi, i have the right expertise in laravel, eloquent orm and mysql query, contact me if you need my help, Best regards.
freelancer 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 เพิ่มเติม