I need a mysql database program that will do the following listed below. Member will access this database from within the Members Area in my Revenue Sharing Program. This database will not be connected to the other scripts database in no way.
This is a project that I need done right away, so if you accept it make sure you can devote the time to complete it right away.
It will most likely be an ongoing project and changes will need to be made as our program grows or needs change.
I have a revenue sharing site where Members purchase Ad Levels each week.
At the end of the week the total amount of Ad Levels they have is multiplied by a number the admin enters(Revenue Share).
This will give the Member their Revenue Share Earnings for the week.
The Members number of Ad Levels will decrease each week after the Revenue Share Earnings are posted. The amount the Ad Levels
decreased is determined by this formula. Previous number of Ad Levels – (Revenue Share Earnings divided by 2). This will be their
new Current Ad Level Balance.
Example
——-
Member buys a 10 Ad Levels on Tuesday and buys another 40 Ad Levels on Saturday.
This gives them a total of 50 Ad Levels.(10+40=50)
On Tuesday the Admin wants to pay each member .15 per Ad Level.
So this will give the Member 7.50 in Revenue Share Earnings. (50x.15=7.50)
Members new Ad Level balance will now decrease since they just got earnings.
(Previous number of Ad Levels – (Revenue Share Earnings divided by 2)), which will be (50 – (7.50/2))=46.25
This 46.25 will be the Members new Current Ad Level Balance.
Now, if the Member buys more Ad Levels they will be added to the new Current Ad Level Balance above. Example, if
they buy another 50 Ad Levels it will be (50+46.25=96.25).
The following week the process will repeat again but the calculations will be based on their new Current Ad Level Balance.
Which in the above example would be 96.25. The process will repeat over and over each week.
Commissions
———–
Everytime someone makes a purchase of Ad Levels, I need to give the person who referred them a commission. I will need a field
to enter the commission amount when I enter Members purchases in the database. Will also need an Affiliate ID field.
Withdrawl Feature
—————–
Would like Member to be able to withdrawal from their Revenue Share Earnings if they have at least $5 or more in earnings.
When they make withdrawal I will need the following info from them: Member ID, Payment Processor, and Payment Processor ID.
This amount would be subtracted from their Revenue Share Earnings right away.
Rollover Feature
—————-
Here is another feature I would like added. If Member does not make a withdraw request of Revenue Share Earnings. I want an
Admin Feature that I can click a button and anything in the Members Revenue Share Earnings will be added to their
new Current Ad Level Balance. Once this is added to their balance their Revenue Share Earnings should be cleared.
VERY IMPORTANT—- Before the Members Revenue Share Earnings are moved over to their new Current Ad Level Balance. I need
to give the person who referred this member a commission of 15% on these Revenue Share Earnings. So, we would take .15 and
multiply it times the Members Revenue Share Earnings and post this amount in the Affiliates profile as a commission. Once
this is done we can then move the Members Revenue Share Earnings to their new Current Ad Level Balance.
Admin Functions
—————
Admin enters purchase with the following info:
Members ID, Ad Levels purchased, Date, Payment Processor, Payment Processor ID, Affiliate ID
Admin enters a Revenue Share amount each week. This is multiplied by each Members Current number of Ad Levels they have at the time.
Admin should be able to pull up a Revenue Share Earnings Withdraw Report with all info entered from Member.
Admin should be able to pull up a Commissions Earnings Withdraw Report with all info entered from Member.
Admin should be able to mark withdraw requests as Paid when Admin pays them.
Admin should have report features like total of all new Current Ad Level Balances.
Admin should be able to pull up a member by ID and display all activity of Member.
Admin should be able to list all Ad Level purchased and be able to sort by Member ID or date.
Admin should be able to list all commissions and sort by Member ID.
I want the Admin Functions to be as powerfull and flexible as we can make it.
I do not want Members to be able to access Admin functions.
Member Functions
—————-
Member should be able to enter their Member ID and have it display all their Ad Levels purchased, earnings posted to their account,
withdrawals made, and their new Current Ad Level Balance.
Member should also be able to see any commissions they have and be able to withdraw them if they have at least $5 or more in earnings.
When they make withdrawal I will need the following info from them: Member ID, Payment Processor, and Payment Processor ID.
This amount would be subtracted from their Commission Earnings right away.
Members should see any pending withdraw requests and they should state if they are Pending or Paid.
I only want Member to see their information only.
Closing
——-
I know there is a lot going on with this database, but I’m sure good programmer can do this with ease. So, I need someone who is very good with making database programs. Contact me if you have more questions. I can give you the actual site it will be used on as well if you need to get a better feel of our program and what we do.