Terminé

Fetch members payment reports in mysql

There is a community that requires that its members pay membership dues according to a schedule as listed below:

- the first fee type is a one-off non-recurring fee. it is mandatory for every member.

- the second fee type is an annual and recurring fee. it is mandatory.

- the third fee type is for voluntary and non-recurring contributions.

Using mysql, you are required to:

1. Create the following tables:

- feesType,

- members and

- fees table with the correct relationships.

2. Fetch data from the three tables, feetype, members and fees.

3. Fetch date by memberID that shows a given member all or any outstanding/pending payment obligations, the he must make.

4. Fetch data list by feetype of only those members who have not made payments based on fee type.

5. Return the count by fee type of only members who have not made payments based on fee type.

6. Fetch data that shows total income for the current year.

7. Fetch data that shows total income by fee type for the current year.

8. Fetch data and return income for the current year based on the year a member joined the community. e.g. 2019, 2018, 2017 etc

Find attached sample table shema to guide design.

Please use [login to view URL] or any tool to host the solution for review.

Compétences : MySQL, Programmation de bases de données, SQL

en voir plus : create reports mysql database, mysql statement count day today send email, wordpress members payment paypal, making excel reports mysql, payment reports clone, php session handling mysql adding count, wordpress plugin create reports mysql, emoney payment php mysql, vb6 mysql table count, cacti mysql query count, pull reports mysql excel, create excel reports mysql, mysql record count joomla, php mysql duplicate count, pulling reports mysql, mysql loop count average

Concernant l'employeur :
( 2 commentaires ) Lagos, Nigeria

Nº du projet : #20435473

Décerné à:

ZhangXH

Hi I am very interested in your project. As for me, I am a full-stack developer with 6+ years in the web development. If you hire me, I will devote my full time only for you and guarantee high quality and deadline Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(18 Commentaires)
5.0

4 freelance font une offre moyenne de $23 pour ce travail

dreammate0621

Hello! I am a web developer. I have checked your project description. If you hire me, I am gonna do my best. I guarantee the good result. I will wait for your reply. Thank you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(7 Commentaires)
4.4
romancoder204

Hello Dear. How are you? Nice to meet you. After reading your job description in details I am very interesting in your job. The best quality, accurate timeline are what I guarantee to my clients. I am a full stack Web Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
2.4
kritikkathakur1

I AM READY TO START RIGHT AWAY AND DELIVER THE JOB AS PER YOUR REQUIREMENTS IN A TIMELY MANNER. I HAVE MY OWN VPS @[login to view URL] RUNNING ON CENTOS 7 64 Bit WITH PHP 7.2 VERSION AND THEREFORE YOU CAN TRACK THE PROGRES Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0