Well for the past month or so I have been working on a Programming Competition project in AP Computer Science. Some may know I am quite fancy with graphics and HTML but yes, I do program too. But man, even though I am decent at it, it bores the crap out of me. Well being the project leader I do most all of the work and I just use the two other members for support and error testing.

We receive a packet with our project problem in it. Make a fully functional support site for a company. Of course with some other more little details but honestly since we are in the advanced section, they kinda leave us hanging with A LOT of stuff. So I take the point from the polygon and try to connect the dots and hope I got them connected in the right order at the end.

Well last year we went into the competition not knowing what the hell to expect and were finally forced to resign because of unreadiness. But we still went to the showfloor to see what everyone else had, my Bill Gates is showing! lol

Well this year I was damned and determined to get first place and by golly I think I may achieve that goal! I have busted my *bottom*, coming in after school and during lots of other class periods to get this thing done in the two - three month period I had to work in, that includes not taking a lunch period in school!

Well everything you will see on the site was made from scratch, everything is programmed with PHP, with minor bits and pieces with javascript (just for function calls). The HTML was made by me of course and so was the whole company idea and wording.

JoDaJo Support is the name of the site, a clever combination of my team member names (Jon + Damen + Josh).

The sole purpose behind the site is support tickets basically. And the work flow goes like this.

Customer calls in with problem, Customer service representative(employee) takes customer information and submits a "work order", this work order gets stored in the database and assigned to a Resolution Specialist(employee), the RS see he/she has a work order and goes to resolve it, RS submits solved work order. That is the main back bone of it.

Extra pages are, Admin(Creates new employee accounts and manages existing ones),news(view all work order status's), and contacts(look up employee information for work uses).

This may seem simple in theory but not so much in the programming side.

I am trusting enough of everyone here to let you see the final version before the competition panel, with access to an admin account. Please don't abuse this and try to exploit bugs with the site because I am sure if one wanted to could find them easily. Although I do not believe anyone here would.

Http://www.damen.trap17.com/jodajo/index.php
Username: Damendaman
Password: admin
This is an admin account to allow you to view all pages.


I am also trusting enough to hand over the raw files for anyone who might be curious to see what kind of coding all of this requires and see the insides of it.

Http://www.damen.trap17.com/jodajo/SHPC.zip

For a seventeen year old High School senior I believe I have outputted a nice little project here, wouldn't you agree?

-Damen

 

 

 

Reply

I just had a quick look and I would say not bad. First off you did it in tables wow LOL good job I don't know whether to laugh or congratulate you on a monolith task I think both is appropriate. As for the back end stuff I had a quick look it it seems OK but I didn't not test it all out for any bugs. I would say good job there if its all working as expected.

I had a quick look at the source files and noticed you didn't layout the site from a template. If you learn how to template your sites you'll build them quicker next time. it also keeps look consistent from each sections.

not sure about cookies


that was from your admin.php page, I'm not 100% sure as I never use cookies so can somone answer my question on it.

These are just suggestions I'm giving to try and help you out.
Again nice job overall.

oh by the way fix the links up they are not correct.

 

 

 

Reply

Thanks for the reply!

Yeah, it was quite a big task set for upon. And yes the whole site functions correctly, lots of debugging a full weeks worth I believe to get all major kinks out. The advantage is that I will be presenting this in front of the panel so if I am aware of something that won't work I can just go around it.

As for the cookies, my friend Jon(hippiman from the forums here) did the code for the cookies initially with javascript but I can answer your question on that.

When the person logs in it checks the database for what type of user it is that logged it(i.e. admin, rs, csr) then in turn creates a cookie with the value of the result. So what that code is doing is checking the value of the cookie, and if it doesn't equal(!=) admin then it redirects you to the security page where it states you don't have sufficient privileges. This is one every page in a similar way except the index. The work order pages makes sure only an admin and csr can access it and the same with the resolution page. If you go to the site and log in, (if using firefox not sure about ie.) go to tools>options>privacy>show cookies. Then find the name of my site(damen.trap17.com or you can search cookies for loggedIn) and you will see a cookie called loggedIn and the value of it will be Admin.

All of the functions work correctly so if you would like you can add a work order and resolve it to see how everything works also.

Hope I answered your question too.

Reply