Blancer.com Tutorials and projects

Php Editing
Report Edits

1. Compare 2 reports (Activity Summary and Billing Summary) and fix so
that both reports return the same totals. They are run on the same data, and are currently showing about $1000-1500 difference in totals.

2. When the report page loads, add a multiple select box function on the right side of each row of data, so that for each row, the user can decide not to include some lines on the report by checking a box on the right side of that row. Checking this box should not delete the data from the database, but will instead only delete the rows from the output of the current report.

3. After selecting rows NOT to show on the report, refresh the report
page. Add a button which says “bill these services?” or print. If “bill

these services” is checked, do the following:
a. Update that record in tblacts.billed with a “1” for each row.

For example:
UPDATE `famsol01_avail`.`tblacts` SET `billed` = ‘1’ WHERE `tblacts`.`actid` =2147190620;

Note that each “row” in an Activity Summary or Billing
Summary report contains one “activity” (tblacts record, which are uniquely identified by an integer (tblacts.actid).

b. After the update, refresh the screen, and include a button allowing the user to download a .csv version of the report data. Allow the user to select the download location. Name the file with this kind of name:
date_time_activitysummary.csv or
date_time_billingsummary.csv

4. Edit the two screens for “Activity Summary” and “Billing Summary” to allow the user (in addition to the other choices available) to choose:
– Show all records, billed* and unbilled**
– Show only billed* records
– Show only unbilled** records

billed* = tblacts.billed has a “1” in it
unbilled** = tblacts.billed has a “0” in it

5. If a user selects to show “billed” items, give the user an option to change the status to “unbilled” by doing this kind of update:
UPDATE `famsol01_avail`.`tblacts` SET `billed` = ‘0’ WHERE `tblacts`.`actid` =2147190620;

6. Make sure that only the “admin” user or one designated as a “1” in
tbladmin.superadmin is allowed to run both the Billing Summary and
Activity Summary. Non-superadmin users (tbladmin.superadmin = 0) can only run the Activity Summary, with their staffname pre-selected. Their staff name should be unchangeable on the Activity Summary Form screen.

The forms are in forms.rar and the reports are in reports.rar. More detailed information can be given to the selected programmer. Thank you very much.

Php Database Development
I have a web site that I want to connect to a database

With three log-in choices…..Client Login, Candidate Login and Partner Login

Each Login link will be activated when an individual signs up with their pertinent information and also a ID and Passsword should be automatically assigned. I would like to Be able to review specific information that has been I entered in the database as it pertains to them.

Zen Cart-remove Small Changes
On my ZenCart site i want the category image removed from some pages.

Basically the only place the LARGE category image should be visible is on the “colection” page. For example when you are looking at a bedroom collection you would see all the items in that collection. But when you where looking at the category page and viewing All the thumb nails the LARGE category image would not be at the top of the page. Also on the individual products, the category image would not be at the top of the page.

The Skype icon needs to be removed from the navigation bar.

The main banner image needs to be swapped. I will provide the new image.

Only bed if you have excellent Zen Cart history and a fantastic feed back.

Matrix Script Modification
Programmer with MLM Matrix Programmer REQUIRED to modify and install script (DO NOT BID if you are not experience in MLM or Matrix Program)

I have a Affiliate Membership Program with a 3×2 matrix program written in PHP MySQL

1) I need you to ADD the Re-Cycle Bonus Entry in the program and make it a Re-Cycle Matrix system.

NOTE:
A) The Matrix position is not based on membership or person
Matrix Positions are based on Bonus Positions issue to Members
Example a Premier Member get One Token Matrix Bonus and a VIP Members get 3 Token Bonus Position in the Matrix
An the other Matrix Position in the program is that The Introducer gets a Referral Bonus Position in the Matrix
I have the Matrix Script and it is in working condition

B) The Bonus Positions are issued and placed in a LISTING (called qualifying List) before it is triggered into the 3×2 Matrix
(unlike all other matrix program that place or enter the member immediately into the matrix)
I have the Listing scrip and it is in working condition

2) I need you to issue the Re-Cycle Bonus Position (when the matrix is completed) in the LISTING just like all the other Bonus Positions and not directly into the matrix

3) I need you to issue Monthly Re-Entry Bonus in the LISTING for all existing Members
Premier Member 4 RE-Entry Bonus Position
VIP Member 5 RE-Entry Bonus Position
BP Member 6 RE-Entry Bonus Position

The entire program and the Bonus Position / GSR scripts are in working conditions
You need to help me modify the script for item (1) (2) and (3)

Note: You do not need to write a new script it can be done ADDED or MODIFIED for the current script

4) I need you to ADD a MONTHLY AUTO DEDUCT Subscription Fee on every member (Premier, VIP and BP Member)

Premier Member to auto debit monthly in the Members Account the amount of $45
VIP Member to auto debit monthly in the Members Account the
amount of $55
BP Member to auto debit monthly in the Members Account the
amount of $65

These amount of $ debited is for the Monthly Re-Entry issued item (3)
You Need to ADD or Write this script in payout.php

5) I need you to ADD a MONTHLY Unilevel Commission Plan (Unlimited Width) with these conditions
a) Sponsor 3 Direct Members earns 3 Levels of $1 on each Member
b) Sponsor 4 Direct Members earns 4 Levels of $1 on each Member
c) Sponsor 6 Direct Members earns 5 Levels of $1 on each Member
This is to payout out commissions for item (3)

You Need to ADD a new script for this in the payout.php

You do not need to figure out the above = What is it? or How it works?

Here’s what I need you to do before we attempt to do the above.
I have the current 3×2 program on a website “www.tea-biz.com”

6) I need this same program to be copied and install in another website “www.global1matrix.com”
Both these websites are in the same hosting company – this make it easy for you to work

It should be a like a copy and past job except that the web template is different

I need you do item (6) it can be a one or 2 days job if there is no communication problem

From working on item (6) you will be able to know and understand the program structure, the flow and the scripts for the above project items (1-5)

Need to setup or install global1matrix.com within the next few days and get in on live after which the rest of (1-5) project can be added on.

Regards,

tbiz

Zencart Website
General Description: We need a website with zencart shopping cart included. The artwork has already been defined, and will be handled to the programmer when chosen.

Specific requirements:
1. The website has to be written for PHP, using zencart v.1.3.8, mySQL 5
2. The website will include several links: news&events, contact us, our history, our store somewhere else, and Shop Online.
2. The shop online link will direct to a Zencart/OsCommerce (whatever the programmer wants to use) shopping cart. The shop layout has to be modified in order to match the exact artwork already designed.
3. Zencar/osCommerce shopping cart has to include a wishlist functionality (zencart does not include this feature out of the box). Only registered users will be able to add items to wishlist or to make an order, including several payments methods: google, credit cards, paypal.

Notes:
1. The artwork of the layout will be given to you. You will have to split and arrange images we will send you, and adapt the zencart shop to that design.
2. Zencart allows you to add custom pages. We will need pages like Contact Us, History and those kind of static pages. We also have the artwork for those pages. Just like in point 1, you need to adapt it to the artwork.
3. You need to implement the zencart template based on the artwork provided.

Remember, we have not an existing website. The idea of the project is creating one based on the artwork we will send you and using zencart so we can sell our products.