a reply to:
and14263
Let me attempt to sketch this out for folks.... from a pseudocode perspective....
The ability to add notes associated with a user ( the avatar in this case is not what matters, as it is simply a representation for the user, but
would likely act as a hyperlink so that when clicked on, it would take you to a page/pagelet that shows comments about the user) means that you need
to do a few things.
First, you need to be able to create a form that you could type your comment into
Second, that comment needs to be assigned to the user who has that avatar. This requires at least one new table within the database behind this
website, and a SQL insert to take the information entered from your computer into the the new table on the web host's server. This likely also
requires a JSON message to send the data to the database where the SQL insert statement is made.
Third, any time someone clicks on a given users avatar, a request to retrieve that information is sent from your computer over the web that triggers a
SQL statement to look for any comments associated with that user via the association between the user and the avatar that was clicked on.
Fourth, searching for specific comments... will this be searching X user's profile for a certain keyword in comments made about that user. If you
wish to search for keywords across all users, that is a different SQL select statement against the database. Results (including a notification if
there was no results in the search) will need to be sent to the website from the database to show the SQL select statement results. This would likely
be an additional page/pagelet on the website.
So, a few lines of code? No. Also, it would take a bit of research to look at the overall structure of both the website and the database to
determine if any special precautions need to be taken (you don't want your newly working code breaking existing code in production) as well as to make
your code flow with existing production logic and coding.
So, how much time might this take? Well, I know nothing about the site's guts or the database behind the scenes. But, I can make a few
estimations.
Meetings with website owners / stakeholders - 1 - 3 hours
This is to go over their functional requirements to make certain they are thoroughly understood before starting on the other tasks. Primary reason
for this is that while a hallway ambush meeting may be sufficient to convey the idea of what is wanted to the developer, it often is not all
encompassing of precisely what is wanted. The purpose here is to try to measure twice and cut once, as carpenters will tell you.
Researching existing system (website and database) - 12-16 hours
Documentation of technical specifications for the effort - 3-5 hours
Coding and unit testing - 24 hours
(unit testing is where the developer is running their own tests to see if their code works, before full blown testing takes place of a much more
granular level of detail) of new web page design, database table structure design, and SQL insert and select statements.
Quality assurance and user acceptance testing - 8 - 16 hours
Were all possible scenarios thought out of how the new functionality might not work, or how the new functionality might break existing functionality?
That is the purpose of this effort.
Documentation of changes made - 3-5 hours
All total, at the far end of my estimations, we're looking at approximately 69 (almost 1.5 weeks of work) hours of work. And that is only accurate
*if* everything goes well. What if the users at the end realize there were additional requirements? Or requirements that were forgotten (by users
and or developer)?
Now, honestly, I have the skills to do all of this. However, not everyone does. So you might have to bring in multiple people with varied skillsets
to do this.
My rate? Well, let's just say that at a bare low end, $10 would get you about 10 to 15 minutes of work from me.
Everything being said, this is my final estimate.
Time to create and deploy - 69 hours.
Approximate Cost? - $4K