Devam Ediyor

514851 Simple PHP Report From Existing MySQL Database

This will be a simple project if you are good with PHP & MySQL...

I have an existing MySQL database full of data that I want you to create a custom report page that allows me to easily view and manage my data.

I realize I can view the data using MyPhpAdmin, but I want a dynamic report that I can view via my browser that shows me the data in an easier viewing format, filters, etc.

Let me explain in detail:

My database has 2 tables...I receive order details from PayPal's IPN that adds data to my database.

There are several fields added to my database for each order, but I am only interested in seeing certain fields.

So the Main report with the following Column/Field Names in order of Left to Right:

time

txn_type

receiver_email

first_name last_name

payer_email

item_name

mc_gross

payment_status

custom

Each order will be displayed on separate rows...with the NEWEST order on the top.

That's really it for the main report, but I would like to add the following features:

==============================

1.

I would like filters created so that I can click on a filter and just see the orders based on the selected filter.

Here are the filters wanted:

The below are in the following format:

Filter Name

Database Column/Field Name - data variable

-------------------

New Purchases

txn_type - web_accept

-------------------

New Subscriptions

txn_type - subscr_signup

-------------------

Recurring Subscription Payments

txn_type - subscr_payment

-------------------

Subscriptions Cancels

txn_type - subscr_cancel

-------------------

Subscriptions EOT

txn_type - subscr_eot

-------------------

Subscriptions Failed

txn_type - subscr_failed

-------------------

Refunds

payment status - Refunded

-------------------

==============================

2.

At the end of each row will be these options: View Del

View - Allows me to view ALL of the fields in the database for that particular order.

Del - Allows me to delete a complete order record from the database. Please add a popup warning to eliminate accidental deletes.

==============================

3.

Row Background Colors. I would like to make the cell background of each row color coded so at a glance I know what the status of the order is. These colors will be based on the the following:

-------------------

txn_type - web_accept --> #CEFFFF

-------------------

txn_type - subscr_signup --> #66FF66

-------------------

txn_type - subscr_payment --> #CCFFCC

-------------------

txn_type - subscr_cancel --> #FF8080

-------------------

txn_type - subscr_eot --> #FF3535

-------------------

txn_type - subscr_failed --> #C0C0C0

-------------------

payment status - Refunded --> #FFBA53

-------------------

everything else --> #FFFFFF

-------------------

==============================

ADDITIONAL REQUESTS:

- Del link pop up warning "Are You Sure You Want to Delete..."

- Newest Orders go to TOP row of report

- If adding Paging plz put 100 rows per page

- plz make it nice to look at...creating code is one thing...making it look professional makes me VERY happy :)

==============================

I think that is it! Hopefully that makes sense :)

Please let me know if you have any questions.

Once we agree and are ready to get started I will give you full FTP and Database access to my server so can build & test the scripts right on my server.

p.s. showing me an example of nice looking reports you have generated via PMB would be a good way to win the bid :)

Beceriler: Her şey Kabul, Veri Tabanı Yönetimi, MySQL, PHP

Daha fazlasını görün: simple pop server, php color code, php code to create report, paypal payment status pending, payment status pending paypal, payment status pending, mysql database server, go to top code, dynamic p, create mysql database using php, report example, database scripts with php and mysql, think-cell, mysql test, mysql report, glance, create report, report mysql php database, create reports php using mysql database, mysql add fields, certain report, failed receive data, access creating reports, mysql delete, cell names

İşveren Hakkında:
( 99 değerlendirme ) Ancaster, Canada

Proje NO: #2260783

Seçilen:

lifewishessl

Ready to do the work.

2 gün içinde 60$ USD
(0 Değerlendirme)
0.0