Show Bid Request
ASP/PHP Whiz required
Bid Request Id: 70350
|
|
|
|
Posted by: |
CBL (92 ratings)
(Software buyer rating 9.98 )
|
|
Non-action Ratio: |
Very Good - 14.00%
|
Buyer Security Verifications: |
Excellent
|
|
Approved on: |
Jun 26, 2003
5:36:50 PM EDT
|
|
Bidding Closes: |
Jun 29, 2003
5:35:50 PM EDT
|
|
Viewed (by coders): |
196 times
|
|
Deadline: |
7/4/2003
TIME EXPIRED
|
|
|
|
|
Description:
I need someone with excellent ASP/PHP skills, who is familiar with the concepts of subtotals/totals to fix the bugs in our simple ASP report generator script, and then translate it to PHP (mySQL).
It is a generic script that can be connected to any database, the user enters a SQL statement, selects the fields that they want to Subtotal by, and then it displays the results.
Changes we need are:
1. At present it only allows the user to "Subtotal" by fields in the Order By clause, via checkboxes. We would like this to be replaced by 3 dropdowns that list all fields, allowing the user to selecting between 0 and 3 subtotal fields. It should automatically add/move these to the start of the Order By clause.
2. Subtotalling currently works fine with 1 subtotal field selected, but doesn't work with more, this needs to be fixed.
3. I would like the results to be "paged" i.e. previous page / next page etc, with innapropiate options hidden.
Please only Bid if you are confident that you know how to do it. This is our 3rd attempt at finding a coder who can get it right - the original script was written in about 3 hours! :)
We need it pretty quickly, let us know how long it will take you.
Deliverables:
1) Complete and fully-functional working script.
2) Complete ownership and distribution copyrights to all work purchased.
Platform:
ASP / PHP
Must be 100% finished and received by buyer on:
Jul 4, 2003 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
|
This bid was accepted by the buyer!
|
$100 (USD)
|
Jun 27, 2003
12:12:42 AM EDT
|
10
(Excellent)
|
|
|
well... after loosing sometime replacing your include files that were not included in the zip file, i could test the script...
i published it at http://www.kepler.srv.br/lgui/rentacoder/handprod/genreport.asp with a default SQL code. I couldn't find what is wrong when using more than one subtotal, but non wanted zeroes.
open this page, execute the default query, select first three fields for subtotal (country, city and vendorname) and check 'handcost' as total field.
message me explainning what you see wrong in there, but the zero totals.
anyway, dont metter much what the error is, i think i can convert this to PHP before your deadline with the problem solved and your new features running, but i need the answer soon. if possible, this saturday, cause I gotta run with it.
there is only one problem I need to check. I'm not sure if I can page results with MySQL. I think it can't handle SQL page commands like TOP. maybe I will need to run the entire query and save it in a page variable and show only the wanted part without requering the database betwin pages. i'm just worried about huge queries that may not fit in a php variable. but its still no problem. need only to research a little more about the better way to do it.
hope to hear from you soon.
Best Regards,
Luiz Guilherme M. Kímel dos Santos
RJ - Brazil |
|
|
|
|
|
|