.PHP - need some simple mods done to online app

jetski

Hi all,

Have a CRM system that was built into my site, but needs some mods made,

some simple changes , summary as below....

* - modify view - new entries are listed on top of the page not the bottom.
* - Date - remove both S DATE and E DATE fields and replace with single start date that's auto populated with time and date.
* - new customer form - option to print out form as attached to this email, that will have been auto populated as per information recorded in the CRM system.
* - Change ref number - simply add to beginning of actual customer ref number 11Z9
* - colour for status. - new drop down box with 6 options - each option changes the background colour of customers record and updates status field on CRM accordingly

any one interested?

witnessmenow

There is no question in your post?

Graham

OP, you started your post with the phrase that will cause most experienced developers to run a mile:

"some simple changes"

I'll pull out one of your simple changes as an example:

The S Date and E Date fields, replaced with a single auto populated time and date.

Are these dates being used anywhere else
views
forms
SQL
functions
calculations
Do you want these fields deleting from earlier records?
If these fields are being removed from earlier records how are you going to populate the new empty field on the earlier records?
Do you have a development environment
Can your system be taken offline while the changes are applied, out of hours required? Is this public facing or internal only?
Will these changes also require an accompanying roll-back plan?

jetski

Graham wrote: »

OP, you started your post with the phrase that will cause most experienced developers to run a mile:

"some simple changes"

I'll pull out one of your simple changes as an example:

The S Date and E Date fields, replaced with a single auto populated time and date.

Are these dates being used anywhere else
yes but only on some records as it never really worked right.
views
forms
SQL
functions
calculations
don't know what this means...
Do you want these fields deleting from earlier records?
nope
If these fields are being removed from earlier records how are you going to populate the new empty field on the earlier records?
n/a
Do you have a development environment
no
Can your system be taken offline while the changes are applied, out of hours required? Is this public facing or internal only?
yes can be taken offline
Will these changes also require an accompanying roll-back plan?

no

Hi Graham, thanks for your reply! ive answered in red under ur questions. cheers

TonyStark

jetski wrote: »

no

Hi Graham, thanks for your reply! ive answered in red under ur questions. cheers

Was this the one you had created form this thread?

http://www.boards.ie/vbulletin/showthread.php?p=74949693