Expected duration: 1 - 2 weeks This project is for an existing crowdfunding platform. Artists can create profiles and raise money towards their goals by selling products, memberships or taking donations - in return supporters receives products, services and experiences as rewards.
The website is built using custom PHP, MySQL, jQuery, SCSS and Smarty templates.
The project is tracked in a Git repository. We use Gulp to compile Javascript and SCSS. NPM and Composer are used to manage dependencies. We currently use Neat grid in the SCSS though are slowly phasing it out in favour of flexbox solutions.
The project is custom procedural PHP, it is not OO and does not run on a framework such as Laravel (and we aren’t looking to change that right now) but it is relatively well organised and the original developer is available to answer any questions.
The tasks required
Artists can log in to the backend dashboard for their profile. This area includes a number of management tools such as being able to add/edit/remove products, profile information, membership tiers, etc, as well as reports on supporters, orders and payments.
We’d like to add some new reporting options to this area.
1) Sales report We want a Sales report adding.
This should load a page with… A table of all sales made to the selected artist including… Membership subscription payments Donation payments Product purchases This data should be filterable by a date range, and paginated
You may be able to repurpose the existing Payments Report for this.
2) Orders Report Similarly, we want to add a Reports Order under the Super Powers menu. This should not be for artist use, but only accessible to Super Users and it should show data for all artists combined. This should feature… A table of all orders with Order ID, Customer Name, Artist Name, Total Amount, Order Date and Status. Ability to search orders by name, email, address, postal order or order number Pagination You should be able to click an order to see page with full details of that specific order. Again you may be able to reuse existing Orders Report for this, repurpose and upgrade that and then add a separate view that only super admins can view.
3) Supporters Report
As above add a Supporters Report. This should be artist-specific.
Here artists should see… See a table of all their supporters with name, status, support start date and tier where applicable along with type of supporter The table should include anyone who has either signed up as a member, purchased a product or donated (the type of supporter should reference this e.g. Purchaser, Member, Donater) The table should be paginated You should be able to search for supporters by name or email You should be able to click into a specific user opening up a page with their full information Customer details (name, address, etc) Their order history Their membership details Donations Total spent