Rescripting of our website (PHP)

We are looking for our existing website to be recoded. We would like the website to be in PHP. We would also require the winning bidder to help with exporting parts of the current database to work with the new site. ## Deliverables We are looking for our site OzRewardS ([[login to view URL]][1]) to be rescripted. The system works like this: 1. A member clicks a link. A unique (incremental) ID is assigned to that click. 2. The click is recorded in the members account. The member is transferred to the website. Please note: the URL of the website needs the unique ID incorporated in to it, and the location of the ID may differ depending on the advertiser. When a member makes a purchase, the following happens: 1. The advertisers supply us with a list of sales we have created. We then use a CSV (or similar ??" as long as it can be a bulk upload) to upload these details (the first column is the unique ID and the second column is the sale amount if applicable) 2. The system calculates the % to pay the member based on the sale amount and credits it to their account. Some transactions pay a percentage of the sale amount and others pay a flat rate. If the system pays a flat rate, the second column is ignored for that row. 3. The system sends an email to the user (**if they have selected the option in their account to receive the email**) to inform them of: 1. The retailer name 2. Their spend (if applicable) 3. The amount credited to their account 4. The uploaded file is no longer needed and is deleted. When a user makes a minimum threshold of credit in their account, they are able to withdraw the full amount of their funds. There will be a number of different methods for a user to withdraw their funds which are: * PayPal * Bank deposit * Cheque These payment methods may change from time to time. Different information will be required for each payment method. For example, a PayPal payment only requires the email address, so that information should be requested when the user redeems the money in their account. That information could be kept for future use. Bank deposit would require their BSB (in format 123-456) and account number (in format 1234567890). Because this information is secure, it should be securely removed after use. Cheque would require their name and address. This information can be kept. When a payment is requested, the money should be removed from the members account (so they cannot request another payout) and marked in their account as 'pending'. Once the payment has been confirmed by admin, the transaction should be marked as 'confirmed'. The admin should also be able to create a picking list for each transaction which can be posted to the member if required. Admin may choose to decline a payment, in which case the money should be returned to the members account and the transaction marked as declined. Members should have access to a transaction record in their account which should show details of clicks (whether pending or confirmed) and their payments (confirmed, pending or declined). Each advertiser has a category and can be assigned to one or more categories. The retailer has a name, description, cashback amount (either a fixed amount or a percentage) and URL. Some retailers may have an expiry date. They will also have a name and banner image. See the example on our test website at [[login to view URL]][2]. The advertisers are also able to have 'click' campaigns. This is where a user is credited (usually maximum once per day) simply for clicking on an ad. No further action is required, so the funds should be credited immediately. Users should be able to click the ad once per specified period (ie they can click the ad at 23:50 and then click the ad again at 00:01 ??" they should **not** be made to wait until 23:50 the next day.) Advertisers can be set as featured and therefore appear on top of other retailers in category and search. Advertisers that have been added within *x* days (set by admin) should be marked that they are new. We also have 'offer of the week' which is changed by admin and a new shops listing on the right hand side. We may need to credit/debit users accounts manually. A function should be provided in the admin for this. A reason may or may not be provided. The reason will be shown to users. Users are able to refer new members. They are paid *y* when the other user has earned *z*. (ie once new user's account balance is $10, the referring user is paid $5). Users should be paid for these referrals automatically when appropriate. We also need to be able to send out newsletters. Newsletters should be able to be targeted depending on the information provided by the user. E.g. we may need to send out an email to all males. We may need to send out another email to all females between the ages of 18 and 21 living in New South Wales. Users need to be able to perform standard account functions such as: * Editing their details * Resending the account validation email in case they haven't received it * Deleting their account (needs to have a verification page which warns them they will lose all of their money) * Password resetting When users join, they are given a free joining bonus. This can be changed by admin, even to 0. Admin also may hand out promotion codes where users can enter this code on the registration form in order to gain additional join bonus. Admin needs to be able to set an expiry date for promotion codes and also see how many times each promotion code has been used. The system should automatically send out reminder emails in 2 week periods for users who haven't yet confirmed their account. Admin needs to have access to a transaction record. This needs to be presented as a summary and as a full transaction record. Information in the summary may include amount members have been credited, amount members have redeemed and also needs to be searchable. Admin needs a user management page in order to add, edit and delete users. This includes a banning system where the account can be locked and the user isn't able to join using that email address or username again. Things to take note: * The system should always record the point information to the transaction and not refer back to the advertiser information, as the amount the advertiser pays may change from time to time. * We would like to use the template and logo we already have. The winning bidder will be responsible for incorporating our template in to the new website. * The winning bidder will also be responsible for helping export from the old database to the new one. This includes all users, their referrals and account balances. Individual transactions do not need to be exported. Advertisers need not be exported. * All bidders are welcome to use our test website at [[login to view URL]][3]. The username/password for the admin is *cybermindsmediaptyltd/password*. **PLEASE ALWAYS ENSURE YOU ARE USING THE TEST DOMAIN. If you have trouble logging in, please go to [[login to view URL]][4] instead of using the log in box on the homepage.**