PROJECT

1. PROJECT GOOGLE SUMMER OF CODE

2. GOOGLE SUMMER OF CODE MINOR PROJECT (WEB APPLICATION DEVELOPMENT) 1.> Public Work Department Tender Management System (PWDTMS) (government).& Private Tender Contract Management System.

3. PROJECT BY

4. This Indian Government Tenders Information System is the Central Source for Government and Public Sector Procurement / Tenders/ Notifications issued by the Central and State Governments and other public bodies across India for goods, services and works

5. Introduction • Public Work Department Tender Management System (PWDTMS) (government).

6. ADDITIONAL FEATURE • Private Tender or Contract Management System.

7. Electrical Air Conditioners Alternators Boiler and Heater Conductors and Inductors Fan Generators Insulator Lift Light and Bulbs Meters Other Electrical Products Pumps and Motor and Compressors Refrigerator Storages Batteries and Dry Cells Sub-station works Transformers and Capacitors Valve And Gauge Welding Electrodes Wires and Cables Electronics Computer Hardwares and Consumables Computer Softwares Electronics Office Automation Panel/distribution Board/connector Scientific Instruments Switchgear/switching Apparatus Telecommunication Services / Equipments Financial Services Banking and Mutual Funds and Leasings Business Consultancy Insurance Services Other Services Non-financial Services Health Services/Equipments Hotels and Restaurants Labour And Manpower Real Estate Services Recreational Services Security Services Storage and Warehousing Tourism Few sector for contracts or tenders Non-metallic Mineral Product Abrasives Cement Cement and Asbestos Products Ceramic tiles and Articles Gems and Jewellery Glass and Glassware Other Non Metallic Mineral Refractories Stones - Granite - Earth Plastic Plastic Product and Granules Plastic Tubes and Pipes Power Plant Non Conventional Energy Power Plant Rubber Products Rubber and Rubber Products Textiles Textiles Product Transport Equipments Automobiles Ancillaries Commercial Vehicles Other Transport Equipments Passenger Cars and Jeeps Railway Ancillaries Shipping Two and Three Wheelers Tyres and Tubes Transport Services Air Transport Railways Transport Services Road Transport Services Wood Paper and Paper Products Paper and Paper Products Printing Woods and Furniture Fabrication Fabrication Food Products Agro Products Animal and Animal Feeds Beer / Soft Drinks / Liquors Dairy Products Food Grains Food Processing Forest Departments Sugar Tobacco Products Vegetable / Fruit / Flower / Plants Vegetable Oils and Starches Iron and Steel Casting/Structurals/Fabrications Fasteners Iron Metal Tubes and Pipes Other Metal Products Stainless Steel Lab Equipments Lab Equipments Leather Products Footwear and Leather Products Magnetic Equipments Magnetic Equipments Material Handling Material Handling Mining and Quarrying Coal and Lignite Crude Oil / Natural Gas / Mineral Fuels Minerals Mining Equipments Petroleum Products Non Classified Non Classified Non-electrical Machinery Ball Bearings Chemical Machinery Machine Tools Other Machinery Pharma machinery Prime Movers Textile Machinery • Aviation Equipment • Aviation Equipment • Chemicals • Chemicals • Drugs and Pharmaceuticals • Fertilizers and pesticides • Industrial Gases • Paints and Varnishes • Communications Services • Courier Services • Construction • Architect / Interior Designer • Ballast • Bridges • Building Material • Canal/Irrigation Work • Ceiling/Flooring/Plaster • Civil Works • Dam Work • Desilting • Drainage • Drilling • Enviromental Work • Excavation • Fencing/Wall Work • House / Building • Painting • Pipeline Project • Platform/Jetty/RCC Work • Plumbing/Sanitary Work • Roads • Safety Equipment\Explosives • Shed Construction • Soil Survey • Trenching and Dredging • Water Purification • Water Storage and Supply • Zone Contract • Non-Ferrous Metals • Aluminium • Other Non-Ferrous Metals • Misclaneous • Diversified • Misc. Manufactured Articles

8. TENDER SYSTEM Tender Management System is to manage tenders of all the Government Departments and Heads of Department, Boards, Corporations of the State Government, Nigams and Societies under the administrative control of the State Government and which are funded by the Government. Software Feature : Tender management as per company wise, Tender wise BOQ Management, Auto calculation for Tender below or high, Various Type of Remainder, Tender wise bill generation as per Tender norms, Various Type of Reports. Remainder Point: Tender Opening, Tender download, Tender submission, Negotiation, EMD, SD return after cancel tender Various latters list: Release of S.D.R.A., Release of withheld amount, Extention Time limit. Proposal of Excess, Proposal of Extra Item, Submission of Bill, Progress of Work, Completion of work, Represatiotion, Negotiation, Submission of Tender, Submission of Security Deposit, Payment of Final Bill, Refund of Earnest Mony Deposit, Star Rate/Price escalation Bill, Extatantion of Bank Guarantee, Submission of FDR/P.B./B.G., Bank Gurantee Renewal, Conversin of Security Deposit, Conversion of S.D. – Reminder, Extending validity of Tender, Intimatin for RMS Activities, Submission of work progremme. Reports: Conform Tender Wise, Cancel Tender Wise, EMD Refund Tender wise, SD Refund Tender Wise

9. FUNCTIONAL REQUIREMENTS • Enlistment of new contractors. It will contain all the contractor details , including attachments of the documents required. • New registration approvals by Government PWD, validated by email and SMS. • Creating a tender for public constructions with options of selecting Construction Type, budget, place, timeline etc. • All the project details will be visible to the users, this details must have a link to tender corresponding. • Builder/ Contractors should be able to submit a tender which should include his past projects, Overall bid cost, Material used, Timeline, etc. • PWD users should be able to compare the tenders depending on various criteria’s such as L1, prior project experience, etc. • 2 layers of approval of contract will be followed. Contract will be approved first by PWD users and then by Government senior officers. • After a Tender is approved for a contractor he must be informed via a mail. • Contractors should be able to view status of his bid online. • History of all the tenders submitted by all the contractors will be maintained and visible to PWD users and admin • A page with all the circulars and downloading the pdf’s of circulars and tenders. • Home page of the application must display the number of Current tenders, Number of works going on, number oftender with last date as today. A link that will open the details. • All the resent tenders will be visible to everyone depending on the priority of submission date.

10. NON FUNCTIONAL REQUIREMENTS • Secure access of confidential data (user’s details).   • 24 X 7 availability.

11. Technology Used: • JAVAEE • AJAX • TOMCAT • ORACLE • JQUERY • SERVLETS • JSP • JAVA SCRIPT

12. CONTRACTORS SIGNUP PROCESS NEW REGISTRATION SIGNUP APPROVAL VIA EMAIL OR SMS OR ANY AUTHENTICATION PROVIDED FROM GOVT OFFICERS OR PWD USERS LOGIN

13. FOR CONTRACTOR SIGNUP DETAILS 1. EMAILID 2. PASSWORD 3. HINTQUESTION 4. HINTANSWER 5. ALTERNATIVEEMAILID 6. OMPANYDETAILS 7. COMPANYNAME 8. FNAME 9. LNAME 10. SEX 11. DESIGNATION 12 .ADDRESS 13. CITY 14. STATE 15. COUNTRY 16, PINCODE 17. WEBURL 18. PHONENO 19. FAXNO 20. MOBILENO 21, TENDERSINTERESTIN • PANCARDNO. • CID TABLE NAME CONTACTORDETAILS EACH NEW ENTRY WILL BE ALLOTED AN INDIVIDUAL ID NAMED CID GENERATED BY SEQUENCE IN ORACLE WHICH WILL ACT AS PRIMARY AND FOREIGN KEY

14. CONTRACTORS HOME PAGE TOTAL NO OF NEW TENDERS VIEW SEARCH BY 1 sector road Tender value 3324 crore location Rajasthan Refno. 7611881 Next page Closing date 17-may-2013 Link fill or view more details Construction type ex road,transport,pipelining Budget space ex 1 lakh,2 lakh,3 lakh Timeline ex 3 months,6 months,1 year Location ex Rajasthan, bihar,bhopal,indore Refno Product Industry On scroll the list will increase use of javaScript and ajax

15. Fill or view more details about tender SUBMIT OPTION WILL BE PROVIDED TO FILL THE TENDER.AND HIS PREVIOUS WORK DETAILS WILL ALSO BE SEND AND WILL BE VISIBLE TO THE PWD USER WHO WILL EVALUATE TENDER • Details • Tenderrefno • Sector • Location • Opening date • Submission date • Tendervalue • Bid • Constructiontype • Budgetspace • Timelinelimit • Refno • State • Area • Details • Submittedon • Estimatedtimeline • Otherdetails • Pid • CID TABLENAME TENDERDETAILS SAVED TO TABLE SUBMITTEDTENDERDETAILS

16. AFTER CONTRACTOR’S LOGIN FUNCTIONS PERFORMED • UPDATE PROFILE • CHANGE PASSWORD • DOCUMENTS UPLOAD/UPDATE • PROFILE IMAGE • CIRCULARS • PREVIOUS WORKDONE • PREVIOUS TENDERS ALLOTED BY GOVT. • CURRENT GOVT. TENDERS WORKING ON/UPDATE WORK PROGRESS • CHAT WITH GOVT. OFFICERS/PWD USERS • REPORTS • TENDERS ALREADY FILLED WAITING FOR APPROVAL IF TIME LEFT THEN ONLY

17. A. UPDATE PROFILE OPTION FOR CHANGING HIS DETAILS UPDATING 1. EMAILID 2. PASSWORD (FOR CHANGING PASSWORD SEPERATE OPTION WILL BE GIVEN) 3. HINTQUESTION 4. HINTANSWER 5. ALTERNATIVEEMAILID 6. OMPANYDETAILS 7. COMPANYNAME 8. FNAME 9. LNAME 10. SEX 11. DESIGNATION 12 .ADDRESS 13. CITY 14. STATE 15. COUNTRY 16, PINCODE 17. WEBURL 18. PHONENO 19. FAXNO 20. MOBILENO 21, TENDERSINTERESTIN • PANCARDNO. • CID (PRIMARY KEY WILL NOT BE CHANGED) TABLE NAME CONTRACTORDETAILS

18. B. CHANGE PASSWORD CHANGING OF PASSWORD BY ENTERING HIS PREVIOUS PASSWORD AND GETTING CID AND MATCHING IT FROM TABLE CONTRACTORDETAILS AND THEN ASKING FOR NEW PASSWORD TWO TIMES AND FINALLY CHANGING THE PASSWORD IN THE TABLE CONTRACTORDETAILS WITH CID IN TABLE PASSWORD ENTRY IS IN 2 nd POSITION

19. D. PROFILE IMAGE BY DEFAULT IMAGE IN DATABASE BROWSE AND UPLOAD OPTION THEN IMAGE WILL BE INTECHANGED IN DATABASE TABLE TABLE NAME CONTRACTORIMAGE CID IMGNAME IMG

20. E. CIRCULARS TABLE NAME CIRCULARS AND PREVIOUSCIRCULARS Attributes (snosendbysenedersid circular sendto) • OPTIONS 1 VIEW CIRCULARS 2 SEND CIRCULARS 3.PREVIOUS CIRCULARS THEIR WILL BE A CIRCULAR TABLE AND ALL THE CIRCULARS DISPATCHED BY PWD OR GGOVT. OFFICERS WILL BE SHOWN TO CONTRACTORS WHEN CLICKED ON VIEW CIRCULARS & CIRCULARS WILL BE OPEN & IF ATTACHMENT OF DOCUMENS REQUIRED THEN FILLED AND ATTACHED AFTER THAT THEIR WILL BE A DONE BUTTON THIS CIRCULAR WILL VANISH FROM CIRCULARS TABLE AND WILL BE SHOWN IN PREVIOUSCIRCULARS TABLE

21. F. PREVIOUS WORKDONE • OPTIONS • 1. NEW ENTRY • 2. UPDATE PREVIOUS FOR NEW ENTRY DETAILS REQUIRED • PASTPROJECTDETAILS • OVERALLBID • OVERALLCOST • LOCATION • MATERIALUSED • PROJECTBY • TIMELINEGIVEN • DONEINTIME • STARTINGDATE • COMPLETIONDATE • IMGCERTIFICATES • SECTOR • TENDERREFNO • OTHERDETAILS TABLENAME PASTPROJECTDETAILS A.CHOOSE FROM DOCS SAVED OR B. UPLOAD NEW FROM SYSTEM BROWSE AND UPLOAD

22. G. PREVIOUS TENDERS ALLOTED BY GOVT. Tender ref no. Click here for details location time • Linkfordetailsbhopal 45 days • 22 Linkfordetailsindore 55 days List to be shown after tender work is completed Tablename previoustenderallotedbygovt

23. H. CURRENT GOVT. TENDERS WORKING ON/UPDATE WORK PROGRESS STATUS REFNO COMPLETED &CLOSE LINK TO BE CLICKED FOR DETAILS LOCATION TIME UPDATE WORK PROGRASS MESSAGE SEND TO (PWD USER ADMIN OF THE PROJECT ) ABOUT WORK COMPLETION AND SAVED ALSO TO TABLE GOVTRECORDCOMPLETIONOFPROJECT TABLENAME COMPLETIONDETAILS ATTRIBUTES 1. CID 2. REFNO 3. MESSAGE 4. DATE BASED ON PREVIOUS MESSAGE IN DATABASE DETAIL TO BE REMOVED FROM TABLE CURRENTRUNNINGTENDERS AND ADDED TO TABLE PREVIOUSTENDERALLOTEDBYGOVT

24. I. CHAT WITH GOVT. OFFICERS/PWD USERS • THESE FUNCTION WILL WORK ON CHECKING CURRENT SESSION ID ACTIVE AND WILL SHOW ALL ONLINE USERS NAME AND CHATING WITH DATABASE MESSAGING WILL BE DONE WITH INDIVIDUAL ID JAVA SCRIPT AND AJAX WILL BE USED AND AUTOMATICALLY AFTER 2 OR 3 SEC MESSAGE WILL BE RELODED

25. J. REPORTS • VIEW REPORTS HAVING REPLY OPTION • SEND REPORTS • COMPOSE REPORTS • SAVE REPORTS TABLENAME REPORTS HAVING ATTRIBUTES REPORTS SENDBY DATE SENDTO

26. K. TENDERS ALREADY FILLED WAITING FOR APPROVAL • HERE FILLED TENDER STATUS WILL BE VISIBLE • TENDER REFNO • TOTAL SUBMISSION FOR TENDER • TENDER DETAILS (LINK) • LAST DATE FOR BID • BID DONE • RESULT OPENING DATE • RESULT STATUS

27. PWD USERS

28. PWD USERS SIGNP AND LOGIN • FORMAL SIGNUP • EMAILID • PASSWORD • HINTQUESTION • HINTANSWER • ALTERNATIVEEMAILID • DEPARTMENTDETAILS • SECTORNAME • FNAME • LNAME • SEX • DESIGNATION • ADDRESS • CITY • COUNTRY • PINNCODE • WEBURL • PHONENO • FAXNO • MOBILENO • IDALLOTED • PANCARDNO • PID ----------------------(PRIMARY KEY GENERATED BY SEQUENCE IN ORACLE) TABLENAME PWDUSERDETAILS APPROVAL VIA EMAIL FROM GOVT. OFFICERS SIGNUP LOGIN

29. FUNCTION PERFORMED BY THE PWD USER AFTER LOGIN • OPEN A TENDER • EVALUATE A TENDER • CURRENT TENDERS ALLOTED & THEIR WORKING • PREVIOUS TENDERS WORK • REPORTS • CIRCULARS • PROFILE UPDATE • PROFILE IMAGE • DOCUMENTS UPLOAD/UPDATE • CHATTING OPTION • LOGOUT

30. 1. OPEN A TENDER TAKEN FROM TABLE TENGDERDETAILSBYGOVTOFFICERS • Details • Tenderrefno • Sector • Location • Openingdate • Submissiondate • Tendervalue • Bid • Constructiontype • Budgetspace • Timelinelimit • Refno • State • Area • Details • Submittedon • Estimatedtimeline • Otherdetails • Pid • CID TABLENAME TENDERDETAILS

31. 2. EVALUATE A TENDER • TENDER REF NO • DETAILS VALUBYE TOTAL SUBMISSION • SORTBY TIMELINE OR BID • SHORTLIST FOR APPROVAL SEND TO GOVT. OFFICERS TABLENAME SHORTLISTEDTENDER --- TENDERREFNO ,CID TABLE NAME –APPROVAL TABLE– REFNO,CID, (BY GOVT OFFICERS) GOVT OFFICERS WILL ONLY SEE THESE TENDERS WHOSE REFNO IS NOT IN APPROVAL TABLE OR AFTER APPROVAL SHORTLISTTENDERS ENTRIES FOR REFNO WILL BE DELETED AND ADDED IN CURRENTRUNNINGTENDERS CONTRACTORS DETAILS EVALUATE ON BASIC OF PREVIOUS WORK DONE SORT BY TIMELINE ,BID, APPROVAL

32. 3. CURRENT TENDERS ALLOTED & THEIR WORKING • FROM APPROVAL TABLE • CID RID DETAILS LINK MESSAGE RECEIVED • Get details of tenders from completiondetails table after company has clicked on completed tender option then it will be removed from currentrunningtenders table

33. 4. PREVIOUS TENDERS WORK • Details shown from table previoustendersallotedbygovt

34. GOVT. OFFICERS

35. GOVT OFFICERS LOGIN/SIGNUP • LOGIN DETAILS SET BY ADMIN • SIGNUP WITH THE SAME ID/PASSWORD ALLOTED BY ADMIN

36. TASK • REFNO TENDERDETAILS TOTAL NO OF SHORTLISTED • REFNO • CD1 DETAILS SORT BY BID/TIMELINE APPROVE • CD2 DETAILS SORT BY BID/TIMELINE APPROVE AFTER CLICKING ON APPROVE IT WILL BE REMOVED FROM REFNO FROM SHORTLISTEDTENDERS TABLE & ADDED DETAILS TO CURRENTRUNNINGTENDERS & ADDED TO APPROVAL TABLE HAVING REFID,CID,PWDUSERID

37. OPENING A TENDER • REFNO IN TABLE TENDERDETAILSBY GOVTOFFICERS • GIVE ORDER FOR TENDER OPENING TO SPECIFIC PWDUSER THEN TENDER WILL BE HAVING PWDUSERID WITH TENDERREFNO AS PRIMARY KEY

38. PROFILE UPDATE VIEW • PROFILE IMAGE UPLOAD

39. THANK YOU