1
INTRODUCTION The project “Online Courier Management System” delivery status and notification system is being developed for the need of company running simultaneously courier & cargo service this is specially meant for their frontline user service information. This is one of the best efforts by us to prove that how Internet can be helpful in tire service industry where inquiries are always in queue. This system however is a snap shot of the whole scenario for the booming service industry.
This basically deals with the queries of user for a company simultaneously running its courier & cargo service where the users having booked some cargo or couriers or both for delivery can view the status online about where there booked courier or cargo. How much more time it will take to reach the place, and whether received it in original state. nd many other queries such as the reason of blockage, queries with the user care officers regarding handling etc. there is a user satisfaction guest book where user should put some notes about our service user complaint register.
s the domain in of the system is to a bigger area so the best and convenient way is internet as this is the best way to satisfy the user queries. website can prove the best interface between the user and the company. company.
!ith the advent of the Internet technologies wavered. "very year millions more people around are using internet interact in more ways than ever before to date the find old classmates check of medical elements and cures to react and e#press and interactive view of the news also gives live sales, H"$% nline and ma#imum hit mostly in the service industries. This is an instance to show that how internet can be the best deal with the fast growing network of optical fiber making micro broadband and economical to access the Internet whether in the modern or Information retrieval term. The e#tract of all these whether the data access retrieval and our goal is placed in a well ordered by using it's technologies on net. !e will not loose our data whether it is user or service provider. (o comp is now helpful in many other cases too)*
1
•
+ast retrieval of information around the globe by browsing the net.
•
"asy access by sitting home to most of the work places.
•
"asy database access with the invaluable functions of online entertainment and jobs and placements.
Through this portal we have tried to automate the process of an instance of user care industry service a web based support for a cargo and courier to provide automates service regarding their courier packets and parcels- delivery status.
1
OBJECTIVES OF THE PROJECT The The object objective ive of the project project nlin nlinee courie courierr delive delivery ry status status Informa Informatio tion n & notifi notificati cation on system/ Is to deal with the queries of manger. How much more time it will take to reach the place, and whether received in original state. 0ueries among the officers officer s regarding handling etc. user satisfaction guest book where user should put some notes about service and other suggestions. 1ser complaint registers to help us get a better feedback for our failures as a hospitable interface.
The major objectives of this project are as follows:
%roviding an interactive interface for the user query for online status of the packets booked. 2urrent (tatus- using the net technology under the framework .(.%.3"T with 24 .net. fter all interface has a lot to do when proper interaction and attraction is necessary.
Helping the user to search his specific booked packet & parcel as where it is5 !hich intermediate office, when it will move from here, reasons for delay, when it will reach the destination5
nlin nlinee updatin updating g of packet packet & parcel parcel status status throug through h interm intermedi ediate ate and end office office regarding truck no, status, reloading of cargo from one truck to another truck etc.
%roviding (ecured "nvironment for secured data access whatever necessary.
6etrieval of data from database using easy buttons links and interfaces in a very fast and efficient manner.
n*line updating of all type of data. 1pdating data using web based interfaces and with the help of buttons & links in an easy & convenient way.
7eveloping a viable candidate system that fulfills the following requirements
+aster and accurate information retrieval.
"asy registration.
$ogin dependent information updating.
2orrect and consistent maintenance of data and its quick retrieval.
8inimi9ing the page download time hence less investment.
1
Improving the switches button and hyperlink so that the candidate could find all the queries queries they need at the first sight.
8aintaining the fast download of the page by using the flavors of cookies.
(mooth transition and easy access to the pages not requiring much training to the end user.
The overall objective: (ystem helps to bring the company and its user round the globe more closely to each other so that one should have the perfect services.
1
PROJECT CATEGORY The software which is being developed comes under both %( and 67:8( category. The proposed project based on 2 (harp .3"T as a front end and (0$ (erver as a back end. !hile taking 24.3et it gives the strong support of bject riented %rogramming (ystem technology. n the other hand (0$ (erver gives the database consistency, reliability and strong 67:8( supports. bject riented %rogramming is a programming paradigm in its own right and on the other hand, it is a set of software engineering tools which can be used to build more reliable and reusable systems. t present, bject riented %rogramming is emerging from research laboratories and invading the field of industrial applications. bject riented %rogramming is at the core of 24 .3"T. In fact, all .3"T programs are to at least some e#tent object oriented. bject riented %rogramming is so integral to .3"T that it is best to understand its basic principles before we begin writing even simple .3"T %rogram. ;ust about everything we do in .3"T involves objects in some way*even simple variables are base on the 2 (harp object class. nd all our code hast to appear in a class of some sort, even if we are using a module or structure, which are also types of classes now, ll object oriented programming languages provide mechanisms that help us to implement the object*oriented model. It consists following supports) •
bstraction! The ability to create an abstract representation of a concept in code. The technique of creating new data types that are well suited to an application to be programmed is known as data abstraction. It provides ability to create user*defined data types, for modeling a real world object, having the properties of built in data types and a set of permitted operators.
•
"ncapsulation! "ncapsulation is all about the separation between implementation and interface. In other words, when you encapsulate and object, you make its code and data internal and no longer accessible to the outside e#cept through a well* defined interface. This is also called data hiding.
•
#olymorphism! This is all about creating procedure that can operate on object of different types. 2 (harp .3"T handles polymorphism with both late binding and multiple interfaces.
•
$nheritance! Inheritance allows us to derive new classes from other classes. The idea here is that if we were to create, for e#ample, a class for a specific c sharp form and then derive a new type of form from that class, thee derived class will inherit all the base class's functionality, even before we start adding code or customi9ing the new form.
1
S#%&"T (%.3"T is a programming framework built on the common language runtime that can be used on a server to build powerful !eb applications. (%.3"T offers several important advantages over previous !eb development models) •
"nhance' #erformance: (%.3"T is compiled common language runtime code running on the server. 1nlike its interpreted predecessors, (%.3"T can take advantage of early binding, just*in*time compilation, native optimi9ation, and caching services right out of the bo#. This amounts to dramatically better performance before you ever write a line of code.
•
•
•
•
•
•
(orl'!Class Tool Support: The (%.3"T framework is complemented by a rich toolbo# and designer in the
editing, drag*and*drop server controls, and automatic deployment are just a few of the features this powerful tool provides. #ower an' )le*ibility: :ecause (%.3"T is based on the common language runtime, the power and fle#ibility of that entire platform is available to !eb application developers. The .3"T +ramework class library, 8essaging, and 7ata ccess solutions are all seamlessly accessible from the !eb. (%.3"T is also language*independent, so you can choose the language that best applies to your application or partition your application across many languages. +urther, common language runtime interoperability guarantees that your e#isting investment in 28* based development is preserved when migrating to (%.3"T. Simplicity: (%.3"T makes it easy to perform common tasks, from simple form submission and client authentication to deployment and site configuration. +or e#ample, the (%.3"T page framework allows you to build user interfaces that cleanly separate application logic from presentation code and to handle events in a simple,
1
•
with your own custom*written component. Implementing custom authentication or state services has never been easier. Security: !ith built in !indows authentication and per*application configuration, you can be assured that your applications are secure.
C, 24 is 8icrosoft@s new programming language for the .3"T platform. It combines some of the best features of modern programming languages such as ;ava, 2AA or
C, 'vantages: •
•
C8$ documentation generated from source code comments. This is coming in <:.3"T with !hidbey the code name for the ne#t version of
1
•
• •
•
$anguage support for unsigned types you can use them from <:.3"T, but they aren@t in the language itself-. gain, support for these is coming to <:.3"T in !hidbey. The using statement, which makes unmanaged resource disposal simple. "#plicit interface implementation, where an interface which is already implemented in a base class can be reimplemented separately in a derived class. rguably this makes the class harder to understand, in the same way that member hiding normally does. 1nsafe code. This allows pointer arithmetic etc, and can improve performance in some situations. However, it is not to be used lightly, as a lot of the normal safety of 24 is lost as the name implies-. 3ote that unsafe code is still managed code, i.e. it is compiled to I$, ;ITted, and run within the 2$6.
S-. Server provides a suite of tools for managing all aspects of (0$ (erver development, querying, tuning, and administration. !hile designing a database, the database administrator creates database objects such as tables, columns, keys, indices, relationships, constraints, and views. To help create these objects, the (0$ (erver 8anagement (tudio provides access to visual database tools. These tools provide three mechanisms to aid in database design) the 7atabase 7esigner, the Table 7esigner, and the view designer
The integrated 0uery "ditor provides a simple graphical user interface for running (0$ queries and viewing the results. The 0uery "ditor also provides a graphical representation of show plan, the steps chosen by the optimi9er for query e#ecution. (0$ (erver supports the hosting of the .3"T 2ommon $anguage 6untime 2$6- inside the (0$ (erver process to enable database programmers to write business logic as functions, stored procedures, triggers, data types, and aggregates. The ability to run
pplication code inside the database adds fle#ibility to the design of application architectures that requires business logic to e#ecute close to the data and cannot afford the cost of shipping data to middle*tier process to perform computation outside the database. pplication code is deployed inside the database by using assemblies, which are the units of packaging, deployment, and versioning of application code in .3"T. 7eployment of application code inside the database provides uniform way to administer, :ack up, and restore complete database applications.
1
TOOLS/PLATFORM
)or the un'ergoing project/ following tools are use':
#latform Operating System
(in'ows (in'ows 0# professional with Service
)ramewor )ront!"n' Tool Scripting .anguage $nterface Server ;ac!"n' Tool Technology
#ac 2 %&et )3M"(O34 2%5 6isual Stu'io 7889 C,/ TM. TM./ 6isual Stu'io $nternet $nformation Server S-. Server 7885 S#%&"T
HARDWARE :
#rocessor Memory &etwor 'apter Mo'em Secon'ary Storage
$ntel #entium 7%< => 75? M%;%/ @%@%3% 3M "thernet 'apter 5?pbs 6oice )a* @ata SamsungASeagate ar' 'is B<8 =%;
1
Minimum System Requirements ar'ware reDuirement:
%rocessor ) %entium I< D.E >HF.
8emory
Hard 7isk ) J >:
Keyboard
8onitor
) DG 8: 68
Software reDuirement: The minimum requirement for the application to run is given below)
Front End : (%.3"T 24
Back End : (0$ (erver DJJJ
Operating System : !I37! C% with (%D, !I37! DJJJ
1
SYSTEM DESIGN
(ystem design phase starts after the software requirements have been analy9ed and specified. (ystem design is the first of the three technical activities) Design, code and test
that is
required to build and verify the software. design methodology is a systematic approach to create a design by application of a set techniques and guidelines. (ome desirable properties for a software system design are as follows) •
6erifiability
•
Completeness
•
Consistency
•
"fficiency
•
Traceability
•
SimplicityAEn'erstan'ability
The system 'esign consi'erations are:
The design objective that include practicality, efficiency, security etc.
The constraints, which include the hardware, software, budget, time, scale and the interface with all other systems.
The processing techniques, which include batch processing, real time processing and on*line processing.
There are three metho'ologies for 'esigning which are as follows: B$ Top F 'own: The top L down approach starts from the highest*level component of the hierarchy and proceeds through to lower levels.
It starts by identifying the major components of the
system, decomposing them into lower level components and iterating until desired level of details is achieved.
1
This approach of designing
the system might be
best if the designer has detail idea
about the whole “Courier Management System” project to be developed. In this methodology designer start with a front or top form, often called 8I3 %>", for the project and work branching off from there. The advantage of the top*down approach is that form can be changed to affect the look and feel of the whole project because all forms are designed according to the top form look and feel.
B$$ ;ottom!up: bottom*up approach starts from the lowest level of component hierarchy and proceeds through progressively higher levels to top levels components. This design approach starts with designing the most basic or primitive components and proceed to higher*level components that use this lower level components. This approach is adopted when the designer hasn't a good idea about the layout of final project, but know how specific forms look and work. It might be that working from these specific forms to the top forms is the way to proceed. This is particularly true if there are, already, e#isting forms as a result of development of some other project made by some one having the same concept. If there are no forms from which the designer has to start, then he can begin by designing leave forms that accomplish specific objectives and then linking them together through intermediate forms to the top forms. The advantage of this design is that the designer is not constrained by the style of top forms in the leaf form.
B$$$ $ncrementalA$n times: (imilar in ways to both the top*down and bottom*up approaches, the IncrementalM In time approach develops forms ?just in time? when they are needed. It may be the case that an initial top form is needed and specific leaf forms that implement particular objectives. These are created and linked together with understanding that later, intermediate forms may be needed. This works well if the client wants very quickly have a working project that will grow incrementally, rather than being developed all at once. The “Courier Management System” %roject has been designed by following the down approach as well as IncrementalMIn time approach. 7esign step produces a data design, an architectural design and a procedural design. In the data design phase information
1
domain model created during analysis phase is transformed into the data structure. In the architectural design the relationship among major structural components of the “Courier Management System” %roject are defined. In the procedural design major
structural components transformed into a procedural description of the software.
1
ANALYSIS
@)@ of the #roject t 9ero and one level the border scenario of the whole portal is considered and at second level an instance of this project is shown. "ach break*up has been numbered as per the rule of 7+7. Here we attempted to incorporate all the details of the system.
8 .evel @)@: This is the conte#t level 7+7 of the proposed system. The whole system has been depicted in the way so that the information flow continuity should not be lost in the ne#t level. The purposed system is shown as a whole process and the inputs and outputs are shown with incoming and outgoing arrow from the system.
1st .evel @)@: This 7+7 shows all the processes together with all the data stores tables-. It shows the true data flow i.e. how data is actually flowing in the system. 7ata is coming from which table and going into which table is clearly shown by this understanding the whole system. The application developer will fall back upon this 7+7 during the development phase.
1
8 .evel @)@
!eb %anel
!eb panel display
ffice 6egistration (ite 7ata 1pload
7isplay (uccessMfailure
6egistration display
6eg. 7ata 6eg. Information
(taff $ogin 1ser id & pwd
(tatus (earch 7elay
%rocess status search 2alculate distance &time %rocess query
$ogin 7isplay $ogin (uccessMfailure
nline courier & cargo booking delivery status information & notification system
7isplay (tatus (how delay %rocess 6esponse
%rocess 2omplaint
%rocess action
2ustomer query 2ustomer 2omplaints
ction display
1
(tatus display 7elay
6esponse display
."6". 1 @%)%@ The 2ompany 7atabase 7ata upload !eb %anel 1pdating 1pdate ffice 6eg.
2heck administor
!eb panel display %rocess ffice 6eg.
(taff $ogin 1ser id and pwd
(tatus search
6eg. 7isplay
2heck ffice status
Input :ooking Id %rocess (earch id
7elay
2heck 2andidate
%rocess user id & pwd
(tatus 7ata
%rocess current office
6oute 7ata
(tatus
%rocess 6oute 7istance & 7ate
%rocess 7istance & time 7elay reasons 7elay
2ustomer query
1pdate reasons
1pdating
7ata
1pdate new query 6esponse update
6esponse Handler 6esponse
6esponse display
2ustomer 2omplaints 1pdating
1pdate new query
0uery 1pdate 6esponse handler
6esponse
ction 7isplay
1
"!3 @iagram
dminNid
%assword
1serNid
%assword
dministrator
1ser
2reates
:ooke d 2ontainerNid
fficeNid
ffice
3ame
2ontainer
ddress
2ityNid 2ontainerNat
:aseNcit yNid tyNid 6outes
2ourier
2argo
7istance fficeN bearer
7etailsNofNc ourier
7elivery Nstatus
7estinationNc ityNid 7etailesNofNcargo
1
)low @iagram
(uggestion $oadingMunloading 2ontainer
2ourier :ooking 1ser
2ourier booking lot link
$oadingMunloading truck
dmin
ffice 6eg. ther 3etwork $ot 3etwork Transfer 6oute 7etail
6oute 8ap (tatus Information
2ity
(tate
Truck 6oute
Truck
Truck 6oute D
2ountry 2ontainer $ot
1
(ourceM7estination
COMPLETE STRUCTURE OF THE PROGRAM
Proect Modu!es The proposed website will have its main page and will be mainly divided into partially dependent and partially independent modules as*
. $ogin master D. 6egistration master O. 2ourier & cargo differentiation master E. 2ourier status notification marker G. The page design maker . 7elivery status notification system for courier P. 2ourier booking detail master Q. The site master control panelR. 2ustomer query handler master J. The validations master . The other network courier L handling master D. 2argo status notification marker O. 7elivery status notification system for cargo E. 2argo booking detail master G. The other network cargo* handling master
These modules with their sub modules are describe below*
1
1% .O=$& MST"3: $ogin master is the specific module, which only has to deal with the updating of the database. Two types of user can login administrator and the employee. It checks for a valid candidate when the user enters his user id password and link to the correct page and link to the registration page. It is divided into following functions.
Ba ES"3 $@ C"C4"3: s user id rules the system for updating control panel-. (o his uniqueness and type of his user id know a person whether he is master or one of the employee. s it is to provide the viable candidate system, so the user id is being validated with password in different cases to validate the genuinely of the candidate.
BbT" .O=$& STTES MST"3: This module keeps the status of who and when logged in and for which purpose and for how much time.
7% 3"=$ST3T$O& MST"3: s this module is only accessible through administrator password. (o this has not much to do directly. This modules deal with the different state of registration as*
a.
6egistration form display
b.
2lient's does validation being handles by validation master
c.
1nique user i d checker checks that the user id b eing entered by t he candidate is unique or no-
d.
uto user id generator user id field by taking the email id of the user if it is unique or suggest by combining it will some number-.
1
2% COE3$"3 &@ C3=O @$))"3"&T$T$O& MST"3: This module checks the booking id as of courier and cargo, and act according with that. This module differentiates the data as well as process the credential regarding to that, this module handles to and from data from the intermediate process.
<% COE3$"3 STTES &OT$)$CT$O& MST"3: This module handles the query of customer and displays the result according to that customer is asked to enter the booked id in the specified input area. n the basis of input the detail regarding where material e#actly is shown. This module contains the following sub modules*
Ba -E"3G &@."3: This module handles to and from the courier and cargo differentiation master searches the data in the database, which through different conversion through numbers of tables shows the result regarding where e#actly the cargo is. The booking id is first searched into the courier booked table. "ach booking id has a unique number associated with the different offices and also with the courier. n the basis of that booking id, matched with the lot id, and then with the medium and after that medium halted at which station. These statuses are shown.
5%
T" #=" @"S$=& MST"3: This module is specially meant for auto style sheet generator by using C8$. The document object modeling basically deals with the development of a common model for display to have a better interface and look. 7T7 the document type declarationhelps the generated page to be validated with tile 7T7 object and file inserted into, so that tile generated should follow the rules and regulation defined in the document type declaration. (imply one is validating the page so that strict entry should be made to avoid any failure and redundancy in the database. The style sheet generation through C($ has lot to do and much work is their when you defined and generali9e an instances of the tag defined to display in a common attractive and impulsive format.
1
Here in some pages 2(( is being used and for some common C($ will be used for the generation of fully formatted and fully validated web pages.
?%
@".$6"3G STTES &OT$)$CT$O& SGST"M )O3 COE3$"3: This module deals with the delivery status whether the following courier has been delivered to the destination or not, how much time it will take to reach the destination. It has following sub modules*
Ba
@$ST&C" C.CE.TO3: It takes the data from the route table that specifies distance between the current city the city through which tile courier is passing and the destination-.
Bb
T$M" C.CE.TO3: n average time is calculated on the basis of the average time taken to reach the two adjoining city subsequently to the destination.
Bc
@"."6"3"@ STTES: It checks the current status if the current status of the courier gives the destination address and after taking the received detail. It display whether the courier is on its way or delivered successfully.
H%
T" S$T" MST"3: The site maintenance master is the main and the biggest module handling the updating of all type of information regarding the courier & cargo system. It can only be accessed through user id and password, as it deals with the work related the date necessary to keep the site working. menu is displayed asking for to update the instance of the site a user wants, as the si9e of the module directly depend upon the table design and updating. special control panel is design to use for uploading of data in different table. This is done through a site master account and the employee account. It includes the following sub modules*
Ba COE&T3G S"36$C" "&T3G:
1
i-
2ountry in which true courier & cargo service is
availableonly administrator-
Bb
ii-
ther network collaboration for cargo
iii-
ther network collaboration for courier
iv-
ther network services country
STT" "&T3G: The state in which the courier service is available only administrator-
Bc C$TG "&T3G: The city in which the service is available only administrator-.
B'O))$C" "&T3G: ffices, their address and other credentials only administrator-.
Be 3OET" MST"3: 7istance and time taken between each city, shortest route between two destinations only administrator- and other entries to keep the site working.
9%
;OO4$&= @"T$.S )O3 COE3$"3 : 2ourier booked, source office, destination office, lot, container, truck details, date dispatched etc regarding booking of new courier with a unique id. It includes the following sub modules*
Ba
COE3$"3 STTES : This specially deals with the updating at intermediate office about the truck number that passed through office.
Bb.O@$&= E&.O@$&= @"T$." : This deals with the loading and unloading courier from one truck to another truck or one container to another container and other entries to keep the site working.
I%
;OO4$&= @"T$.S )O3 C3=O :
1
2argo booked, source office, destination office, container, truck detail, date dispatched etc regarding booking of new courier with a unique id. It includes the following sub modules*
Ba C3=O STTES : This specially deals with the updating at intermediate office about the truck number that passed through office .
Bb
.O@$&= E&.O@$&= @"T$." : This deals with the loading and unloading cargo from one truck to another truck or one container to another container and other entries to keep the site working.
18% CESTOM"3 -E"3G &@."3 MST"3 : This module specially deals with the handling of query of the customer. This module has following sub modules L
Ba
CESTOM"3 -E"3G &@.$&= : This module generates a input form through which customer can directly interact with tile intermediate office where there courier & cargo isS Through different function and tables.
Bb
CESTOM"3 COM#.$&T 3"=$ST"3 : 2ustomer can directly enter the complaint regarding end office, and the response is sending through the head office. This complaint is only viewable through administrator account.
11% T" 6.$@T$O& MST"3 : This basically deals with the validation of different entries done during form building process. This module specially uses the client side validation scripting from java script and server side scripting from vb.net to make the system robust reliable and error free. This module as specially integrated with the different page and forms checks all the discrepancies such as incorrect email, date of birth, address, etc to
1
finally deal with the any wrong entries being done by the user . it validates as well Is suggests for correct input. This module has the different sub modules depending upon the above modules find forms.
i% C3=O E#@T" 6.$@T$O& MST"3 :
7eal with the validation regarding the updating of product. ii% 3"=$ST3T$O& 6.$@T$O& MST"3 :
7eals with the discrepancies in registration process etc. iii% COE3$"3 E#@T" 6.$@T$O& MST"3 :
7eals with the validation regarding the updating of courier and its status.
17% T" OT"3 &"T(O34 COE3$"3 &@.$&= MST"3 : This module deals specifically with the handling of packet to other network for future delivery and their status mapping with their server to our server. This part of module simply tries to correct to their server automatically to retrieve the details with the no being mapped with the original booking id, this helps the customer to remember only one booking id but track the status of the courier while it travels through other network to.
12% C3=O STTES &OT$)$CT$O& M34"3 : This module handles the query of customer and display the result according to that customer is asked to enter the booked id in the specified input area. n the basis of input the detail regarding where there material e#actly is shown. This modules contains the following sub modules*
Ba -E"3G &@."3 : This module handles the query of the customer searches the data in the database, through number of tables shows the result regarding where e#actly the cargo is.
1
The booking id is first searched in to the cargo booked table. "ach booking id has unique number associated with the different offices and also with the cargo. n the basis that booking id, matched with the container, and then with the truck, and after that true halted at which station. The status is shown.
1<% @".$6"3G STTES &OT$)$CT$O& SGST"M )O3 C3=O: This system deals with the delivery status whether the following cargo has been delivered to the destination or not or how much time it will take to reach the destination. It has following sub modules*
Ba @$ST&C" C.CE.TO3: It takes the data from the route table that specifies distance between the places then calculates the distance between the current cargo the city through which the cargo is passing and the destination-.
Bb
T$M" C.CE.TO3: n average time is calculated on the basis of the average time taken to reach the two adjoining city subsequently to the destination average truck halt time and a time in day returned.
Bc
@"."6"3"@ STTES: It checks the current status if the current status of the cargo gives the destination address and after taking the received detail. It displays whether the cargo is delivered successfully or not.
15% T" OT"3 &"T(O34 C3=O &@.$&= MST"3 : This modules deal specifically with the handling of cargo or container to other network for future delivery and their status mapping with their server to our server. This part of module simply tries to connect to their server automatically to retrieve the details with the number being mapped with the original booking id. This helps the customer to remember only one booking id, but track the status of the courier while it travels through other network to.
1
DATA STRUCTURE The normali9ed form of the table with their structure is describe as under*
Table 1: .ogin )iel' &ame 1serNid fficeNid %assword
@ata Type
@escription 1seriduniquefficeid %assword
4ey Constraint %rimary key +oreign Key *
Table 7: 'ministration login )iel' &ame 1serNid %assword %assword
@ata Type
@escription 1seridunique%assword %assword
4ey Constraint %rimary key * *
Table 2: Office registration )iel' &ame
@ata Type
@escription
4ey Constraint
fficeNid 3ame ddress ddressD %hone %honeD 2ell e*mail 2ountryNid (tateNid 2ityNid 6egistration date Handles
Integer
ffice id 2andidate name %ermanent address Temporary address %honeresidence%honeoffice8obile e*mail id country to which belong (tate * 6egistration date 2ourier, cargo
%rimary key * * * * * * * +oreign key +oreign key +oreign key * *
Table <: Courier booe' 'etail )iel' &ame :ookedNbyNuserNid :ookingNno :ookedNitem :ookedNweight HandlingNdescription
$otNid :ookingNdate 6eceiveNdate 6eceiveNat !hether
@ata Type
@escription ffice :ooking no. unique Item name !eight bout handling the
cargo 2ontainer id
4ey Constraint +oreign key %rimary key * * *
Integer 7ate 7ate
6eceiving date 1serid of receiving
+oreign key * * +oreign key
office 2ourierMcargo
*
1
Table 5: .ot Status )iel' &ame fficeNid $otNid $otNstatus 6easonNofNstay !henNmoved
@ata Type Integer 3umeric
@escription :ooking office id :ooking no. unique fficeNif of office Through which passing *
4ey Constraint +oreign key %rimary key * * *
Table ? .ot 'etail )iel' &ame $otNid :ookingNid
fficeNid 7ispatchNdate
@ata Type 3umeric 3umeric
@escription 2ontainerNid :ooking id booked for
4ey Constraint +oreign key +oreign key
special lot ffice lot made 7ate of dispatch
* *
Table H: 3oute 'etail )iel' &ame :aseNcityNid 7istintionNcityNid 2urrentNdeliveryNstatus verageNspeed 7istance
@ata Type 3umeric 3umeric Integer Integer 3umeric
@escription * * Time take (peed 7istance in k.m.
4ey Constraint +oreign key +oreign key * * *
Table 9: 3oute Map )iel' &ame :aseNcityNid 7istintionNcityNid riginalN via 2urrentlyNvia 6easonNrouteNchange
@ata Type 3umeric 3umeric Integer Integer
@escription 2ityNid 2ityNid 2ities 2ities reason
4ey Constraint +oreign key +oreign key * * *
Table I: .oa'ing Enloa'ing #acet )iel' &ame fficeNid
:ookingNidNunloaded
@ata Type 3umeric
@escription :ooking id of lot
4ey Constraint +oreign key
3umeric
unloaded 3ew lot made with that
+oreign key
booked packet
1
$otidNloaded $otidNunloaded fficeNid 6eason
3umeric 3umeric 3umeric
+rom unloaded * * 1nloading reason
+oreign key +oreign key +oreign key *
Table 18: .ogin Status Master
)iel' &ame $oginNid $oginNtime $ogoutNtime
@ata Type
@escription 1ser id $ogin time $ogout time
4ey Constraint +oreign key +oreign key %rimary key
Table 11: Country Services
)iel' &ame 2ountryNid country
@ata Type 3umeric
@escription 2ountryNid 2ountry
4ey Constraint +oreign key *
Table 17: State Services )iel' &ame (tateNid 2ountryNid (tate
@ata Type 3umeric 3umeric
@escription 2ountry id * *
4ey Constraint +oreign key * *
Table 12: City Services )iel' &ame (tateNid 2ountryNid 2ityNid city
@ata Type 3umeric 3umeric Integer
@escription 2ountry id * * *
4ey Constraint +oreign key +oreign key %rimary key *
Table 1<: .ot .oa'ing Enloa'ing )iel' &ame $otNid 7estroyedNat 3ewNlotNid reason
@ata Type Integer Integer Integer
@escription * ffice Track load *
4ey Constraint +oreign key * +oreign key *
Table 15: Country Services )iel' &ame :ookingNno
@ata Type 3varchar
@escription :ooking 3umber
1
4ey Constraint +oreign key
2ustomerNname ddress 2omplaintNagainst 2omplaintNregarding 2omplaintNdetail 7ate ctionNtaken :y gainst ctionNdetails 7ateNaction
* * * * * * * dministrator id ffice id * *
* * * * * * * +oreign key +oreign key * *
Table 1?: Suggestion 3egister )iel' &ame :ookingNid (uggestion ToNofficeNid 6esponce 7ateNsuggest 7ateNresponded
@ata Type Integer
@escription :ooking id (uggestion * (uggestion * *
4ey Constraint +oreign key * +oreign key * * *
Table 1H: Other &etwor Collaboration )iel' &ame 3etworkNid 2ompanyNname 2ompanyNoffice !ebsite 2ustomerNcareNno !hetherNcollaborated 7ateNcollaboration !hetherNhandles
@ata Type Integer
@escription :ooking id (uggestion * (uggestion * * * 2ourierMcargo
4ey Constraint +oreign key * +oreign key * * * * *
Table 19: Other &etwor Courier Transfer )iel' &ame 3etworkNid fficeNid $otNid 3ewNnetworkNlotNid
7ateNtransfer fficeNidNreceived 7ateNreceived
@ata Type Integer 3umeric 3umeric
@escription :oking id (uggestion $ot 2ourier company
4ey Constraint +oreign key * * *
7ate 3umeric 7ate
transfer 7ate booked * *
* * *
1
Table 1I Truc @etails )iel' &ame fficeNid TruckNid TruckNno 7rivers TruckNstatus
6easonNofNstay !henNmoved
@ata Type Integer 3umeric
@escription 1ser id of office * * * ffice id of office at
4ey Constraint +oreign key %rimary key * * *
which staying * *
* *
Table 78: Container )iel' &ame 2ontainerNid fficeNbearer 2ontainerNat
@ata Type 3umeric Integer Integer
@escription 2ontainer id ffince id ffice id
4ey Constraint %rimary key +oreign key +oreign key
Table 71: Truc Container Mapping )iel' &ame TruckNid 2ontainerNid :ookingNdate :ookedNbaseNoffice !hetherNunloadNtruck 1nloadingNdate !hetherNunloadedNcontaine
@ata Type 3umeric 3umeric 7ate
@escription * * * ffice id =esM3o * =esM3o
4ey Constraint +oreign key +oreign key * +oreign key * * *
r 2date
7ate
1nloaded container date
*
Table 77: .oa'ing Enloa'ing Container )iel' &ame fficeNid 2ontainerNidNunloaded
2ontainerNidNloaded 6eason
@ata Type
@escription * 2ontainer id from
4ey Constraint +oreign key +oreign key
Integer
which cargo unloaded 2ontainer id from
*
which cargo loaded 1nloading reason
*
Table 72: Truc .oa'ing Enloa'ing )iel' &ame TruckNid 1nloadedNat $oadedNto reason
@ata Type Integer Integer Integer varchar
@escription * ffice Truck loaded *
1
4ey Constraint +oreign key * +oreign key *
Table 7<: Other &etwor Cargo Transfer )iel' &ame 3etworkNid fficeNid $otNid 3etNnetworkNlotNid
@ata Type Integer 3umeric 3umeric
@escription :ookingid (uggestion $ot 2ourier company
4ey Constraint +oreign key * * *
7ateNtransfer fficeNidNreceived 7ateNreceived
7ate 3umeric 7ate
Transferred 7ate booked * *
* * *
1
PROCESS LOGIC
Online Courier J Cargo System #rocesses in the following manner: This website contains information about user function such as :ooking the couriers and cargo, $oading the collection of lots in the selected truck or container in case of cargo-, $oading the containers- in the truck in case of cargo- etc. as well as administrator function such as ffice 6egistration, 2reating 1ser,
The project Online Courier J Cargo System delivery status and notification system is being developed for the need of company running simultaneously courier & cargo service this is specially meant for their frontline customer service information. This is one of the best efforts by us to prove that how Internet can be helpful in tire service industry.
1
REPORTS Eser:
(tatus of 2ourier & 2argo.
(tatus of $ot.
(tatus of Trucks.
'ministrator:
(earch the status of 2ourier & 2argo.
1
SECURITY
#hysical Security The 7ivisionalM2entral (ecurity dministrator shall be responsible for the physical security of the system Their responsibilities shall include
8aintenance of security of 7atabase (ervers by keeping it locked and prohibiting entry of any unauthori9ed person to prevent thefts and other untoward incidents
ccess to the database server shall be protected by password and only the (ystem dministrator shall be aware of the same.
8aintenance of multiple power supply connections for uninterrupted power supply.
@atabase Security
S-. Server uthentication ) In this case, (0$ (erver requires that a user specifies a
name and password at the time when connection is attempted. The login name and one*way hash of the password need to match one of entries in the sys login table for the login attempt to be successful.
(in'ows uthentication: !ith built in !indows authentication and per*
application configuration, you can be assured that your applications are secure.
1
SCREENSHOTS
ome #age
1
'ministrator .ogin )orm
1
'ministrator #age fter .ogin
1
Create &ew Office
1
Create Container
1
Create Truc
1
Create &etwor
1
Create 3oute )orm
1
Create 3oute Map )orm
1
Create City )orm
1
Search ;ooing Status )orm
1
Eser .ogin )orm
1
Eser #age fter .ogin
1
;ooing )orm
1
FUTURE SCOPE
It is highly likely that the scope will change as the web application moves forward the web process model should be incremental. This allows development team to free9e the scope for one increment so that an operation web application of the preceding increment but once the second increment commence, scope is again fro9en temporarily. This approach enables the web application team to work with having to accommodate continual stream of change be still recogni9ed. The continuous evolutions characteristics of most web application. :eside that the following basic quality in the software always safeguards the future scope of the software.
1
LIMITATIONS OF THE PROJECT
Though this project is very useful an' has several a'vantages over a manual system% Ese of this no 'oubt will result in faster processing an' a better service but has some limitations also% These limitations inclu'e
!e do not have online transactions.
This application can run on the !eb server and (0$ server.
"nd user cannot directly interact with the dynamic performance of this project.
1