Build a Laravel Eloquent / MySQL query

Dokončeno Zveřejněno před 5 lety K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

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

Programování databází Laravel MySQL PHP SQL

Identifikační číslo projektu: #18175590

O projektu

11 nabídek Projekt na dálku Aktivní před 5 lety

Uděleno uživateli:

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 za 1 den
(8 recenzí)
3.4

11 Freelnceři na tento projekt zveřejňují nabídky v průměru £26

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 Další

£20 GBP za 1 den
(61 Recenzí)
7.5
softcarve

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

£18 GBP za 1 den
(129 Recenzí)
6.3
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 za 3 dní
(20 Recenzí)
4.0
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 Další

£16 GBP za 1 den
(10 Recenzí)
3.5
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 Další

£13 GBP za 2 dní
(2 Recenzí)
2.8
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 za 1 den
(0 Recenzí)
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 Další

£18 GBP za 1 den
(0 Recenzí)
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 Další

£13 GBP za 1 den
(0 Recenzí)
0.0