Đang Thực Hiện

294597 PHP/MySQL Enhancements

IDS/REG Fix List 05/03/09

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

below is a list of mostly very small fixes or enhancements to two related PHP apps on [url removed, login to view]

there is also a screen shot with annonations for most fixes. some shoudl be attached.

(note some screen shots in zip files are old and have doen already.)

/ids-dev & /reg-dev are dev versions of these apps

there is a test account where you can see & test & see source code of the sales module workling, and a 'light' version of the Admin module (for resellers)

test a/c is 999999 p/w is test123

the successful coder will have full FTP access to dev versions, plus full admin access to teh app admin

any additional fixes or enhancement added will be subject to Bonus payment.

a local version of the list below will be used by us and coders

to track progress (and any changes)

we use email and MSN to communicate. we want communications & updates on an almost daily basis

our time zone is GMT+10. and we are available 9am-7pm local time.

*** i do not want to work with anyone who just subs out work. i only want to work with whoever is doing coding. ***

*** these are important apps. no amateurs please. ***

kind regards

don card

IDS SYSTEM FIXES

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

URGENT. VERY SMALL.

1. PLEASE ADVISE PARAMETER STRING/SYNTAX FOR [url removed, login to view] AND [url removed, login to view] TO USE ASAP

see ids-dev/sales/..

- page [url removed, login to view] link with rid= value > [url removed, login to view] page

saves rid value locally

- xxx page [url removed, login to view] link gets rid value then goes to [url removed, login to view] with rid value and logs on same as [url removed, login to view]

need to confirm link parameter for [url removed, login to view] only = ?rid=xxxxxx

need to know what link parameters for [url removed, login to view] in

====

URGENT. SMALL.

2. IDS-DEV/[url removed, login to view]

COPY existing automatic ids reseller email (when reseller created) text/code (see /_resellers/[url removed, login to view] & rs-app-form), and change to suit TESTDRIVE, EXCEPT modify to suit ie will only have test id and password, and send new email to email address entered

get test a/c password dynamically in case it has been changed

====

NON-CRITICAL. SMALL

3. please make product category buttons look more like buttons.

../sales/[url removed, login to view]

../sales/[url removed, login to view]

../sales/[url removed, login to view]

../sales/[url removed, login to view]

they are NOT very pretty. and they have a bt blue border with a greenish button!

i want more 3D button effect using shadow/borders

and i DON'T want a bt blue border

change border colour so it is like shadow and change border style to create 3d effect

====

CRITICAL. BIGGEST.

4. National Warranty Service: AD HOC WARRANTIES

warranty category is the SAME thing as product category.

But In the new NWS form layout, Product Specification, Product Size, warranty type, warranty period and warranty option are depend on product category and wholesaler add the product brand name, model no., serial no. and product cost.

warr type.

existing field. change to display only after ...

warr period field.

existing field. change to display. 3 only.

warr options field ...

prod spec.

new field. drop down will vary with prod cat

prod spec is different drop-down list for each warr/prod cat.

currently envisaged as one selection only.

database fields

brand name. new

brand model. new

prod spec. new.

serial no=equip id. type=equip s/n.

prod cost=price range

====

*** I HAVE TO PROVIDE EXACT FORMULA AND VALUES FOR VARIABLES FOR EACH CATEGORY

===

CRITICAL. BIGGEST.

5. when warranty selected, pop-up offering u/g option/s

*** when options selected, added to order or new warranty selected

*** i have to specify detail

====

CRITICAL. VERY SMALL.

6. MANAGE BONUS PAGES

manage bonus page/s function in nws & reseller admin

*** if active in NWS Admin, the reseller reset function should override ie set to inactive

*** if inactive in NWS Admin, the reseller reset function should not override ie not set active

*** in nws & reseller admin, you can turn bonus pages on and off ... then as per logic above!

====

NON-CRITICAL.

7. IDS APP SHOULD NOT 'TIME OUT'

this was meant to be fixed, but still seems to time out.

===

NON-CRITICAL. BIGGER.

8. summary report x sales person

as previously explained, this is a report similar to the other summary reports already there, but for sales person/s

the only 'trick is that there can be two 'fred's at different resellers

so you need to create a temporary or permanent variable - sales [url removed, login to view] id

and then sort & select on that

this doesn't solve all the problems with data matching but at least the obvious/biggest one

at same time can delete search by trans id, pc id, warranty id as not relevant (for THIS report)

====

NON-CRITICAL. BIGGER.

9. SHIP ORDER report

*** should show status - pending/fulfilled/cancelled for ship orders

*** a list of all ship orders, both ids & manual. with status

and a date range select and search same as for other edit trans and sales screens

====

NON-CRITICAL. BIGGER.

10. lock col headings in edit trans & sales reports/lists

*** see function under NWS admin edit trans, reports & reseller admin reports

*** stop col headings scrolling OFF SCREEN

ALL WE WANT IS FOR THE LIST COLUMN HEADINGS TO STAY ON SCREEN!!! WHILE LIST SCROLLS

*** not critical if too hard

====

NON-CRITICAL. VERY SMALL.

11. can we stop the form reset of [url removed, login to view] forms just before gwarranty_final runs ?

*** see function under reseller sales

*** when click "purchase" it resets confirm form before going to final

*** not critical

====

CRITICAL. SMALL.

12. NWS ADMIN. USER RIGHTS.

A. NOT WORKING. EG 'VOID' USER DOESN'T WORK.

doesn't display Admin screen/form

*** i mean that now if you log on with 'void' rights you get no access and funny screen

ditto all others except admin

this used to work

B. add 'edit reseller' rights to SALES users

*** ie SALES RIGHTS should also include 'edit reseller' rights

add 'edit trans' rights to EDIT & VOID users

*** ie EDIT RIGHTS should also include 'edit transactions' rights

*** ie VOID RIGHTS should also include 'edit transactions' rights

====

CRITICAL. SMALL.

13. UPDATE. certificate & bonus printing

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

see ../sales/[url removed, login to view] and ../sales/[url removed, login to view]

- pdf using css, but screen printing ignoring css. why?

- please make screen & pdf the same and fit each of above pages on one page (each)

====

CRITICAL. SMALL.

14. RESELLER NAME BEING SAVED AS TEXT IN WARR RECORD.

should NOT.

should be dynamic. and linked to record id. so should look up name.

otherwise if name changes, all sales reports etc stuffed up.

if there is a unique fixed system record id, both reseller id and name could be dynamic

====

NON-CRITICAL. SMALL.

15. RESELLER CREATE/EDIT

see \_resellers\[url removed, login to view]

*** ADD MANDATORY FIELDS - TOWN/STATE/POSTCODE/PHONE

*** ANY MISSING FIELDS SHOULD DISPLAY AS A LIST - NOT ONE AT A TIME

*** add price list & service fee attachments to automatic email

*** add question "Do you do on-site service? (Y/N)" above "on-site service areas" question

====

NON-CRITICAL. VERY SMALL.

16. SHORTEN BOTTOM BUTTONS IN ALL CONFIRM FORMS.

so that they fit on screen width better!

../sales/[url removed, login to view]

../sales/[url removed, login to view]

../sales/[url removed, login to view]

../sales/[url removed, login to view]

*** DELETE THE SPARE SPACE IN BUTTONS AS INDICATED in screen

====

NON-CRITICAL. SMALL.

17. REPRINT WARRANTY CERT FUNCTION

please add a 'save as PDF' function

use existing code in [url removed, login to view] and/or [url removed, login to view] to create PDF

*** in NWS & RS Admin tegher is REPRINT CERT function

*** admin/includes/inc/[url removed, login to view]!

*** on form where you do reprint, add tickbox "Save as PDF?" and function

====

CRITICAL. SMALL.

18. EDIT WARR TRANS

should only accept valid prod codes. and should NOT allow save w/o valid code, only cancel

at moment allows (apparent) save with invalid code BUT resets back to original when saved.

====

NON-CRITICAL. BIGGER.

19. IN EDIT PRODUCTS, ADD SORT & SELECT FUNCTION TO RESELLER LIST

see attached screen

*** add sorts by - reseller name, state/postcode/town (as one)

*** add selects by - reseller name, state, postcode, town

====

CRITICAL. SMALL.

21. ADD INVOICE DATE FIELD TO WARRANTY CERTIFICATE

(and to email form if not already)

====

IMPORTANT. SMALL.

22. STOP SALES/TRANS/RESELLER/PRODUCTS SORTS RESETTING & CLEARING AFTER EDIT RECORD

ie after record edit should return to same sort as previous and not reset

====

IMPORTANT. SMALL.

23. ADD RESELLER ADDRESS & PHONE FIELDS TO SALES IDS SHIP ORDER EMAIL

see screen

====

NON-CRITICAL. SMALL.

24. SALES REPORTS BY SALES PERSON WRONG

as per sales summary fix above, need to create a combined field reseller [url removed, login to view] person name and then sort

also sort should not be case sensitive ie DAVE=dave

====

CRITICAL. SMALL.

26. NWS. js not running on root \[url removed, login to view] on LHS images

[url removed, login to view]\[url removed, login to view]

====

REG SYSTEM FIXES

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

*** see /reg-dev

CRITICAL. VERY SMALL.

1. 'Other equipment' type add text box (and save)

====

CRITICAL. VERY SMALL.

2. make sure all 'select one' fields have option selected

====

IMPORTANT. SMALL.

3. add a 'export to csv option with 'select warr id range'

====

CRITICAL. SMALL.

4. STATUS FIELD NOT UPDATING

particularly 'inactive' > 'active'

status should be recalculated when record opened

====

CRITICAL. VERY SMALL.

5. MAKE SURE CAN'T ALLOW INVALID WARR PROD CODES TO BE SAVED.

====

NON-CRITICAL. VERY SMALL.

6. AUTO EMAIL FROM REG NOT PUTTING 'reg at nws' in from address BUT in message!

from & sender should be 'reg at nws'

====

CRITICAL. VERY SMALL.

7. ADD COMMENTS FIELD

====

IMPORTANT. SMALL.

8. SHOULDN'T RESET SEARCH RESULTS AFTER RECORD EDIT

====

CRITICAL. VERY SMALL.

9. NOT SAVING VOID STATUS

====

Kĩ năng: Bất kì công việc gì, Javascript, MySQL, PHP

Xem nhiều hơn: x com 3d model, wrong invoice, why do you want to work in sales, why do we sort data, where to look for app coders, where can you look for coders, what is string matching, what is meant by email address, what is a search string, want to create new brand name, use case module, use case includes, type of button in php with code, this account is inactive, the drop 3d model, text 3d model, test and turn up, suit 3d model, subject php, string system 3d model

Về Bên Thuê:
( 21 nhận xét ) Brisbane,

ID dự án: #2040906