This php postgresql project is to share company’s advertisement revenue with its members who registered their demographic profile information and receive advertisement emails.

Advertisement sales will be conducted by independent sales agents.

The postgresql database contains the Membership details which has 3 tiers and 1st tier member can earn commission against 2nd tier and 3rd tier commission.

Of course, when this 3rd tier member invite own downline members, he/she will act as 1st tier on his network.

There are four types of users in this web project like

Administrator : The Company which shares email advertisement revenue with its members.

Members : Members will maintain profile up to date all the time, reply ad code when they receive ads email, reply survey emails.

Sponsors : The Client who buys the emails

Sales Agent :- They are Agent who sell the company’s ad space to sponsors.

Member will register themselves and fill a questionnaire which is used by the sponsors to search their target audience for their advertisement. This is handled using a web form. All the data are stored in the postgresql database.

The members will be notified through email whenever a survey is created. They can login into the system to answer it.

When a sponsor orders an advertisement for a set of target audience, each of this target audience (member) will be
notified through email.

php order system

There are two types of orders. One is without delivery confirmation and the other is with delivery confirmation. For
both the order types the member will get the commission based on the advertisement tier they belong to.

Administrator from his php control panel has to approve the order in order to proceed. Administrator can also reject the order. Once the order gets approved members will be given their commission.

For the orders that require delivery confirmation the member will get the commission only after they send a reply email along with the ad code sent in the notification email. If the order does not requires delivery confirmation member will get the commission immediately after the order gets approved by the administrator. They will get additional commission for replying the ad codes.

A global commission percentage for each tier member can be set from the administrator panel in this php postgresql project

A Commission percentage can be even set for each advertisement campaign individually.

This order price will be charged to the sponsor. The additional charge can be edited from the administrator panel.

They are video mail, picture mail, every additional 800 texts in the message, delivery confirmation.

We have created a detailed monthly and daily report for sales and payout for the company on the whole, each sponsor, each sales agent and members individually.

The php survey results are graphically displayed using php GD pie charts created by of software developer team. The graphical pie chart will show the percentage of replies present for each survey option.

The sales agent also gets commission for the orders of the sponsors who have been referred by them.

As usual our web developer team completed this php postgresql project with finesse and well within the project time and budget.