Completed

Build a Laravel Eloquent / MySQL query

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

Skills: Database Programming, Laravel, MySQL, PHP, SQL

See more: laravel latest() eloquent, laravel query cache, laravel chunk query example, laravel dynamic query builder, laravel eloquent transaction, laravel 4.2 query builder, laravel complex queries, laravel model with, build cms php mysql, edit csv mysql query, asp mysql query, 2013 lost connection mysql query, mysql query report, php mysql query table, mysql query record bash, mysql query csv file, php mysql dropdown selected, write mysql query, optimize mysql query software, mysql query php table css

About the Employer:
( 2 reviews ) Dunstable, United Kingdom

Project ID: #18175590

Awarded to:

MoadKey

Hi, i have the right expertise in laravel, eloquent orm and mysql query, contact me if you need my help, Best regards.

£20 GBP in 1 day
(0 Reviews)
0.0

15 freelancers are bidding on average £23 for this job

BigCityInstitute

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 More

£20 GBP in 1 day
(44 Reviews)
7.3
softcarve

hi, i would like to create the query based on the criteria. get in touch to discuss more details of it.

£18 GBP in 1 day
(93 Reviews)
5.9
bdeinexture

I am excited to apply to the full stack developer, for a full-time role. My background as a Web Developer, along with - full-stack experience building software at scale PHP7, Laravel 5.4, OOP, Elastic search, MySQL, More

£111 GBP in 1 day
(9 Reviews)
5.6
brightstar928

⭐⭐⭐⭐Hi ⭐⭐⭐⭐ I read your job description carefully and I can do your job perfectly. I have developed many websites So I can know what you mean and I am ready for you now. If you hire me, I will finish your job A More

£18 GBP in 1 day
(19 Reviews)
4.0
ksab

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

£18 GBP in 3 days
(11 Reviews)
3.2
raiadapranav

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 More

£16 GBP in 1 day
(5 Reviews)
2.7
mbstech1987

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 More

£13 GBP in 2 days
(2 Reviews)
2.8
gezginci

i am a senior javascript/php/laravel developer. Also i have experience api integrations [login to view URL]

£28 GBP in 1 day
(2 Reviews)
2.0
MohsinBaig101

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.

£10 GBP in 1 day
(0 Reviews)
0.0
Shildra

Thank you for giving me the opportunity to work. I am a full stack web developer and built several sites with Laravel. I can satisfy your requirement. Please don' More

£18 GBP in 1 day
(0 Reviews)
0.0
mohamedtarekisma

this problem is easy to solve but i want to discuss with you some details about this problem to help me to fast solve this problem

£18 GBP in 3 days
(0 Reviews)
0.0
IgniterPro

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 More

£18 GBP in 1 day
(0 Reviews)
0.0
akka2991

Hi, Thank you for this job post. I'm sure that I will be able to complete this project on time and with high quality, as I have a very strong knowledge background of Laravel Framework and the latest 3 years I work e More

£13 GBP in 1 day
(0 Reviews)
0.0
alisaberimov

We are great team professional in Laravel and Vuejs. Your project will be completed and done in best form.

£10 GBP in 1 day
(0 Reviews)
0.0