We need an app for managing sponsors

[timlinux]

Need the following fields:

• [ ] Sponsor name
• [ ] URL
• [ ] Sponsor duration
• [ ] Logo
• [ ] Contact person
• [ ] Start date
• [ ] End date
• [ ] Sponsorship agreement (as attachment)
• [ ] Level gold, silver etc.
• [ ] Sponsor email

  Views:

• [ ] A Page of all active sponsors with icons by :Large Platinum, Medium: for gold etc.
• [ ] A page with all sponsors (past and present)

  Crons

• [ ] Check daily if any sponsorships have expired and send renewal reminder

[timlinux]

Sponsors should get added to the changeling entry for each release.

[timlinux]

(current sponsors at the time of the release should be added only to that release)

[pcav]

Of course also sponsor email should be added. A reminder (email to the sponsorship manager) sent automatically by email would be very useful. Thanks.

[timlinux]

Thanks Paolo - I added your suggestion to the original ticket description above.

[rischanlab]

Hi @timlinux Could you please check this PR #136 . This PR still on progress, but I need your comment whether my work is on right way or not.

In this PR, admin can input the sponsors via link in navbar. In this case, for example admin click QGIS project then want to input the sponsors for QGIS project.

After that, in the page of version. When admin want to release version, he can add sponsor to that version release.

• I am using dropdown which is select all of related sponsors. I am still not sure about this, I guess one version release can have more than one sponsors, so which way is better?. Hope you can give me a comment.

And also admin can see all of list sponsors in the page sponsor list. (my plan this page will show list of current and past sponsors)

Sponsor detail page

Blocker:

• I am still not able to solve migration so I have to make sql query when I add new model, the problem is when the table has relation with others.

[andreasneumann]

Should this be closes? For me, the sustaining memberships are fine as they are currently.