Saturday, 20 October 2012

Customer Support for Internal IT

This application is useful for the job holders of a company where they can raise the IT support tickets and check their status. The software I used is EXO PHP DESK(using softaculous) where each user will have there user name and password. They can login and raise a ticket for the department they want and check the status for the same. the login for the member is http://arunkota.x10.bz/epdesk/member.php and the admin or the support person will receive the tickets for their respective department.

Thursday, 20 September 2012

Requirements for ZOHO App


This Requirements are for Siddharth Himakar (12BM60061) given by Arun Kumar Kota (12BM60061). Please go through for the exact requirements.


Requirements :

Course Enrollment application for Zoho Imperia Advanced Learning Centre

This Course Enrollment application should serve the working professionals who are willing to pursue their management education in the weekends. The programs offered are Executive Management Program, Specialized Management Program and Customized Management Program. The mentioned programs are available as 3 months, 6 months, 1 year part time and 2 year full time programs from which the professionals can choose from.

The following functionalities should be available to the user:

         Home Page:
·         The Home Page should be named as “Home”.
·         The page should contain information about Zoho Imperia Advanced Learning Centre on the top left.
·         The page should contain our noted alumni with photographs on the right hand side under the title “Noted Alumni:”
·         The page should contain the awards achieved by our organization just below our organization information on the bottom left.
         Course Structure Page:
·         The page should be displayed next to the ‘Home’ tab.
·         The page should contain the programs offered by us, corresponding credits for different time periods for different courses and the course highlights within a tabular column.
·         The page should contain the courses offered in different managerial fields in our company from the professionals can choose from.
·         The Course Structure Page should be named as “Course Structure”.
      User Enrollment Page:
·         Should be displayed next to the Course Structure tab.
·         This page should allow the user to enroll in our program.
·         The page should contain the following fields on the left hand side of the page in the mentioned order:
o   Roll Number: <Number Field><Should Not be displayed><A counter like feature which should have its value increased from 500 in the background on clicking the “Proceed to Enrollment” button.>
o   Name: <Text Field><Default: Blank>
o   Sex: <Radio Button with Male and Female options and Male being first choice><<Default: Blank>
o   Date of Birth: <A date field in format 15-Aug-1947><Default: Blank>
o   Blood Type: <Should accept any character><Default: Blank>
o   Organization: <Should accept any character><Default: Blank>
o   Work Experience (in months): <Should be a number field><Default: Blank>
o   Designation: <Should accept any character><Default: Blank>
o   Email: <should accept only proper email formats><Default: Blank>
o   Address: <Should accept any character><Default: Blank>
o   Mobile: <Should accept only numeric values><Default: Blank>
o   Verification: <Should allow the user to enter only the image><Default: Blank>
o   Two buttons: Proceed to Enrollment <On clicking should display “Thank you. An Email with your details will be sent to you shortly” and should transfer the user to Course Enrollment page.>, Reset <On clicking should reset the values in page to default values>
·         The page should be given the name as “User Enrollment”.
·         The Email is sent to the value entered in the Email field and this email should contain all the form details except the Roll Number whose value should be displayed as ‘null’.

Course Enrollment Page:

·         The page should be given the name as “Course Enrollment”.
·         The page should be displayed next to the User Enrollment tab.
·         The page should contain the following fields on the left hand side of the page in the mentioned order:
·         Roll Number: <Number Field><Should be display the value from User Enrollment page Roll Number & protected>
·         Name of Candidate: <Text Field><Should display the value from User Enrollment page Name: & protected>
·         Email: <Should display the value from the User Enrollment page Email: & enabled>
·         Zoho Imperia Centre: <Should be a dropdown field><Default value” Zoho- Agartala Learning Centre”>
·         Course Code: <Should be a dropdown field><Default: Executive Management Program>
·         Course Duration: <Should be a dropdown field><Default: 3 Months Program>
·         Date of Joining: <A date field in format 15-Aug-1947><Default: Blank>
·         Amount: <Should be a currency field><Value should be calculated depending on the Course Code and Course Duration><The field should accept USD only & protected>
·         Payment Options: <Radio Button with Credit Card, Debit Card and Demand Draft options and Credit Card being first choice><Default: Blank>
·         Credit Card Type:<Should be a dropdown><The field should be displayed only if Credit Card is selected in Payment Options><Default: Blank>
·         Credit Card Number: <Should be a 16 digit numeric field><The field should be displayed only if Credit Card is selected in Payment Options><Default: Blank>
·         Expiry Month on the Credit Card: <Should be a dropdown><The field should be displayed only if Credit Card is selected in Payment Options><Default: Blank>
·         Expiry Year on the Credit Card: <Should be a dropdown><The field should be displayed only if Credit Card is selected in Payment Options><Default: Blank>
·         CCV Number on the Credit Card: :<Should be a 3 digit numeric field><The field should be displayed only if Credit Card is selected in Payment Options><Default: Blank>
·         Debit Card Type:<Should be a dropdown><The field should be displayed only if Debit Card is selected in Payment Options><Default: Blank>
·         Debit Card Number: <Should be a 16 digit numeric field><The field should be displayed only if Debit Card is selected in Payment Options><Default: Blank>
·         Expiry Month on the Debit Card: <Should be a dropdown><The field should be displayed only if Debit Card is selected in Payment Options><Default: Blank>
·         Expiry Year on the Debit Card: <Should be a dropdown><The field should be displayed only if Debit Card is selected in Payment Options><Default: Blank>
·         CCV Number on the Debit Card: :<Should be a 3 digit numeric field><The field should be displayed only if Debit Card is selected in Payment Options><Default: Blank>
·         Demand Draft Number:<Should be a numeric field><Should be displayed only if Demand Draft was selected in Payment Options><Default: Blank>
·         Two buttons: Enroll <On clicking should display “Congratulations! You have been enrolled” and should send a mail with the Invoice containing all the details in the page except the Payment Details> , Reset <On clicking should reset the values in page to default values>

Contact Us Page:

·         The page should be displayed after the Course Enrollment page.
·         Should contain the Contact details of the organization.
·         The page should be displayed as “Contact Details”
·         The page should contain our North, South, East and West zone address in any order.

Additional Notes:
·         All the fields are mandatory except the disabled fields and Blood Group field.
·         The width of the fields can be adjusted as needed.
·         Loading time should be comparatively less.
·         Relevant pictures can be used at the top of each page.
·         General rules of Credit and Debit cards should be followed

Saturday, 4 August 2012

System Architecture !!

This conversation is between two friends...


Bade : hey chote.. what doing ??


Chote
 




 Nothing yaar just watching Olympics and feeling sad about Saina… she should   have won gold


Bade: don’t worry next Olympics she will make us proud




















Chote: yeah she should?


Bade: What else??


Chote: Do you know there is some weird tower at the Olympics?

Bade: Arey pagal it’s not weird tower it’s a radical advance in the architectural field…which was not possible without computer systems and its architecture. :D


Chote: Oh! Is it !! That’s great


Bade: Yes man.


Chote: Can you please tell me about the architecture and its importance.


Bade: Sure man …First tell me what do you know about system architecture


Chote:  
 


I heard there is something related to IRCTC and 3-tier, 2-tier AC...



Bade: OMG *He will kill me with his intelligence* …Arey chote I thought you are smart!!















Chote:   Yup I am smart.


 









Bade: Yeah I can see that by the way you related IRCTC and architecture, don’t worry I will make you little better by explaining it.


Chote:  Oh


Bade: There are different kinds of architecture as you said 1 Tier, 2 Tier, and 3 Tier


Chote: Tell me about 1 tier.


Bade: Here you go, It’s very simple look all the processing is done on only one machine & number of clients attached to this machine


Mainframe systems is a perfect example


Chote: Now I will explain 2- tier …there will be 1 system on 2 tyres like our scooter 




Bade


  

 No no no Please don’t use your brains, its more advanced version of 1 tier
Client & Database is on different system, Processing is done at client side and Application layer is at client side
.
Chote: Thanks for making me intelligent


Bade: Good that you’re able to understand. Now I will tell you about 3- Tier
Apart from Application & database layer there is one more layer present at client side.
(eg Browser).





First Tier= presentation Tier Second Tier=Application Tier (Business Logic)
Third Tier=Data Tier (Database Server)
Chote: So much knowledge in 10 mins great


.
 
 Thanks Bade


Bade:Not a problem chote now you can stop worrying about that weird tower