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 🙂
