Thursday, 20 September 2012

User Manual for CROMA Complaint register



                                             CROMA COMPLAINT

CROMA  is  a Tata group electronic store.It stores all kind of  electronic goods.
This site is the customer complaint site of CROMA


Screen1

Croma_customer_complain(Tab:-Leads)
Instruction:-
Assumptions:-
1)The customer coming to submit his complain on this online portal is already a registered  user and have a unique Customer_id.
Customer:-Rashmi
Admin:-Mr Prithwis Mukerjee(prithwis@yantrajaal.com.)

Authorised user_ids
1)RA2202(this is connected to mail_id (rashmi.singh2202@yahoo.in)
Validations in the form:-
1)Customer_id  should be already  present in croma’s database(fig 1)



FIG1:-Error screen if the customer is not registered

2))Date of service should fall in current month and after the system date(fig 2).

FIG2:-Date of service error

3)Date of purchase should not be greater than system date(fig 3)

FIG3:-Date of Purchase error



Sample mail which the user will receive,we have Admin of the system also in CC



FIG4:-Mail to user from croma

Admin_mail_id is hardcoded   it is prithwis@yantrajaal.com.


Screen2:-



Admin_croma(Tab:-croma_cust2)
Assumption:-
1)Admin get the above mail and use the customer_id ,preffered_time,and date of_service mentioned in the mail to assign a mechanic to the  customer.

Steps:-
1)Go to the admin page input any of the valid customer_id ,tap and the customer_mail_id field  and automatically populates.




FIG5:Admin screen auto population functionality

2)Now fill the the form with required fields.
3)To sign-off the job card ,and send confirmation mail to the user admin need authorisation
Signature.
Authorisation signature:-zoho123(Its exclusively known to the Admin,its like digital signature)
4)Now the user again get a mail confirming the Mechanic name and code(see below mail)


FIG6:-Admin mail to user


Note:-This is a sample mail..Actual admin is prithwis@yantrajaal.com.

Saturday, 15 September 2012

Requirement doc

                                                 SHOPIEE------The online store
Requirement
Version:0.1
Date:-15/09/2012
Author:- Rashmi(ROLL NO:-12BM60069)

Shoppie is an online store which deals in FMCG products.This application has user and Admin roles.



Roles:
1)customer
2)Admin

customer:-
Steps of action:-
1)Login in the store website with his login id and password.Authenticate the login password and id.
2)If not authorised user display “Sorry not an authorised user”.
3)Correct login ,direct to  inventory page .
4)Go and select  from the available choice of merchandice, shipping address etc.
5) Name ,mail address,phone number,merchandise choice ,quantity  are mandatory fields.
6) Have datatype validations on the above mentioned attributes.
7) Satisfy all the validation ,submit the form .
8) Make neccessay updation in inventory table.
9)Onsubmit directed to payment page  ,make payment ,apply necessary validations   and submit.
10)On submittion the user gets a mail,regarding confirmation of his order.

Admin:-
1)Should have a authenticated user id and password.
2)Should have add or remove previlage.
3)Put the product name ,product id and quantity and add it to existing inventory.
4) Submit it ,on submit the details are added in the inventory table.
Tables:-
Inventory
Attributes:-
Product name(string 25)
Product id (string 10)(Primary key)
Quantity(Numeric 5)
User
Attributes:-
Customer id (string 15)(Primary key)
First Name(string 20)
Last name(string 20)
Address (string 50)
Mail_id (string 30)
Password (alphanumeric  20)
Phone number(numeric 10)
Product id(string 5)(Foreign key)


Fig :-1

Fig:-2

Fig:-3



Appendix 1:-
Hi,
First name:- xxxxxx
Second Name :-xxxxxxx
Phone number -667788xxx
Mail id:-xxxxxxxxx@xxxxxx
Merchandise choice:-xxxxxx
Quantity:xxxxx
Thanks for the purchase.
You will get your product within 4 buisness days.
Regards,
Shopify





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



                                                 SHOPIEE------The online store
Requirement
Version:0.2
Date:-15/09/2012
Author:- Rashmi



Accepted  following changes suggested from client side through mail channel:-










Note of acceptance:-

I hereby accept changes suggested by the Programmer.

Signature:-Rashmi
Place:-Kharagpur
Date:-19/09/2012