Therough this system to plan system to orgnize the work of Shoppiing Mall contain many stores belong to the same company of this promenade.
Through this system we can pull off the work of all stores in this promenade and supervise all activities in all stores.
In this system we have tow subdivisions, the first is “ Management ” , and the 2nd is “ Shops ” , Each subdivision hase different characteristics.
we have in this system tow degree of privilleges, decision maker or director, and the employee of stores.
The director or decision maker can add new decision maker for this system, add new employee dor stores, add new store, and see study of all stores in this promenade.
The normal user of employee of store has the privillege to execute sale operation, add new goods to the shop of this shope, update the balance of exicting goods in the shop of this shope, monitore the day-to-day gross revenues operation done, onitore the monthly gross revenues operations done, and monitore the balance of goods in the sotre of this shope.
1.2 Purposes Of The Undertaking
Through this system we work to achive the undermentioned aims:
Form the Registration of new shope: in this aim we orgnize the registeration of new shope and enter the comparative information about this shope.
Form the enrollment of gross revenues operation: in this aim we orgnize the registeration of sale operation ‘s informtion and seek to make it in less clip with less attempt.
Orgnize the registeration of new good ‘s information: in this aim we allow the normal user to come in the information of new good in the shop of his shope.
Allow the user to add excess measure of an excting nutrient in his shope ‘s shop.
Enable the user to acquire information about gross revenues operations done through this system ( day-to-day and monthly ) printable format.
Enable the user to acquire information about goods ‘s balance in his shope in printable format.
Enable the administratore to acquire information about all shopes in the promenade.
1.3 System Tools
To plan this system we use Ocular Basic 6.0 as programming linguistic communication to plan the GUI ( Graphical User Interface ) , and we used Microsoft Access to construct the database of this system.
We selected Ocular Basic because it is easyto usage. We can make signifiers ( interfaces ) utilizing drag-and-drop techniques. A tool is used to put controls on the signifier ( window ) . We can come in the default value for the property of any control we add to the signifier ( interface ) . Many attribute values can be modified during tally clip based on user actions or alterations in the environmentFor examplewe can cange the day of the month of sale ever to the current day of the month even if we run it after 2 old ages after finish design
Microsoft Access database direction system was besides used in planing the database of the system. It is used to make simple database solutions. Access tables back up a assortment of standard field types, indices, and referential unity. The system besides includes a question interface, signifiers to expose and come in informations, and studies for printing. The underlying Jet database, which contains these objects, is multiuser-aware and handles record-locking and referential unity including cascading, updates and deletes.
Microsoft Access besides offers the ability for coders to make solutions utilizing the scheduling linguistic communication Visual Basic for Applications ( VBA ) , which is similar to Visual Basic 6.0 ( VB6 ) and used throughout the Microsoft Office plans such as Excel, Word, Outlook and PowerPoint. Most VB6 codification including the usage of Windows API calls, can be used in VBA. Power users and developers can widen basic end-user solutions to a professional solution with advanced mechanization, informations proof, mistake caparison, and multi-user support.
Applications that merely view informations or have simple informations entry can back up well more users.
2.1 Structure of the system:
In this system we have tow chief subdivisions foremost for managemetn and second for shopes.
2.1.1 direction subdivision:
In direction subdivision we have four featurs
Add new decision maker: in this characteristic we allow the decision maker to add anothor decision maker ( administrator = director ) , in this characteristic the asministrator enter the user name and watchword for new decision maker.
Add new user: in this characteristic the admin can add new usage ( we mention here in user to the employee of the shope ) , to add new user the admin need to come in the user name and watchword and the shope which this user will belong ( or works for ) , here we mention that we can non add new user to a shope non at that place in the promenade.
Add new shope: in this characteristic we allow the admin to add new shope to the promenade, to add new shope to the promenade the admin demand to come in the name of this new shope and the type of it ( e.g optics ) .
Report of all shopes in this mal: in this characteristic we allow the admin to acquire information about all shopes in this promenade in printable formate.
2.1.2 shope subdivision:
This subdivision available to the emmployee of shopes in the promenade, we have to advert that the decision maker of this system must add this user so he can login to this section.in this subdivision we have six characteristics
New sale: in this characteristic the user can come in the information of new sale operation, these information includes the client name, client Mobile figure, saled good, ordered auantity, unit monetary value, and price reduction if there is any price reduction.
Add new goods: in this characteristic we allow the user to add new goods to the shop of this shope, the information needed to make this undertaking includes Good name, Purchae monetary value, sale monetary value, Quantity, andmeasure.
Update goods: in this characteristic the user can update the measure of any exeicting goods in the shop of his shope, the comparative information requested here is good name, added measure, purchase monetary value, sale monetary value.
Goods study: in this characteristic the user can acquire study of all goods and its balance in his shope.
Daily sale: in this characteristic the user can acquire study of all sale operation done through this system in current twenty-four hours.
Monthly sale: in this characteristic the user can acquire study of all sale operation done through this system in selected month.
2.2 System ‘s Tables:
In the old subdivision we explained the chief construction of this system, now we have to demo the edifice of the system ‘s database ( the database of this system was designed utilizing Microsoft Office Access as mentioned before ) The undermentioned tabular arraies are designed in the database of this system:
ADMIN: this tabular array created to salvage the information of decision maker login informations ( Table 2.2.1 )
Users: this tabular array is for salvaging the information of users of this system. ( Table 2.2.2 )
Shop: this tabular array is for salvaging the information for stores in this promenade. ( Table2.2.3 ) .
Good: this tabular array designed to salvage the information of goods. Table ( 2.3 )
5-SALE_INFO: this tabular array desgined to salvage the inormation of sale opertation. Table ( 2.2.5 )
2.3 Connecting between system ‘s database and user ‘s Interface:
There are many ways to link between ocular BASIC and MS Access but in our system we depend on the connexion by the codification and linking the object straight to database non by adding object on the signifier at design clip.
It depends on the connexion twine for ADO library, at foremost a new ADO Connection and ADO recordset points is created so specify the connexion way ( way of database in this system ) as connexion twine
After that the recordset is opened by directing a question for specified table name.
Dim R As ADODB.Recordset
Dim con As ADODB.ConnectionThe following shows an illustration about the connexion manner in this system
Then compose the undermentioned codification where connexion to database is wanted to recover, direct or see informations
Set R = New ADODB.Recordset
Set con = New ADODB.Connection
rs.CursorLocation = adUseClient
Constring = “ Provider=Microsoft.Jet.OLEDB.4.0 ; Data Source= ” & amp ; App.Path & A ; “ MMS.mdb ”
con.Open ( Constring )
Implimntation of the system
3.1 Main Features Of The System:
The purpose of this system is to accomplish a figure of aims. These aims are:
Registration of new stores: in this characteristic, the decision maker demand to register the iformation of new store, this information include the name of store and the type of this store ( store ‘s activity ) .
Orgnize the operation of create new user: this characteristic allowed for decision maker merely, in this characteristic the decision maker can make new user, this new user works in selected store while the decision maker create this user.
Orgnizing the registeration of sale operation: in this characteristic the user must register the information of sale operation, this information include the store name, goods name, order measure, the price reduction, client name, client Mobile, and some information will be automatically loaded when the user choose the good name like available qantity, and unit monetary value.
Orgnizeing the registeration of new goods:
This characteristic let the user to add new goods to the store where he is working, this information include the name of goods, purchase monetary value, sale monetary value, and the purchased measure.
Orgnize the operation of updating the measure of goods: in this feture the user can add measure of any goods in his store.
Preparation of elaborate studies: theadministrator and user can acquire these types of Reports:
All stores: this study shows the information of all stores in the Mall.
Daily gross revenues: this study displays the information of all gross revenues operation done in selected day of the month.
monthly gross revenues: this study displays the information of all gross revenues operation done in selected month.
Goods study: this study demo the information of all goods in the store.
We have to advert that the first study allowed for the decision maker merely, while the other studies allowed to the normal user
3.2 Execution Of The System:
In presvious subdivision of this study we explaineed the construction of this system and speak about the aims of this system, now we will speak about how t usage this system, or how this system works.
First there is debut window, in this window the user select the subdivision heshe wants to utilize “ Management ” or “ Shops ” as shown in figure 3.1
Figure 3.1 Introduction window
3.2.1 Management Section:
If the user select “ Management “ from the debut window heshe will acquire the login window where heshe must compose the user name and watchword of decision maker in this system, as shown in figure 3.2
Figure 3.2 Administrator Login window
After fill the sorrcet username and passowrd of decision maker, heshe will acquire the chief window of adminstrator ‘s undertaking, as shown in figure 3.3
Figure 3.3 Administrator ‘s undertaking windw
If heshe wants to accomplish th characteristic of “ New decision maker ” , heshe must snap on “ New Administrator ” button, so heshe will acquire the undermentioned windw, as shown in figure 3.4
Figure 3.4 New Administrator window
After fill the requested Fieldss, the system will link to the databse and travel into the tabular array “ Admin ” and salvage new record with the information of new decision maker.
If the decision maker wants to accomplish the characteristic “ New User ” , heshe must snap on “ New User ” button on the Administrator ‘s undertaking windw, so will acquire the undermentioned window, as shown in figure 3.5
Figure 3.5 New User window
In this window will necessitate the username and apssword for new user, besides we need to choose the store where this new user will work, the list of stores will automatically loaded to the window by traveling through the database and travel to “ Shops ” tabular array and convey the name of all stores in this promenade.
When the user fill all rewuested Fieldss heshe must snap on “ Save ” button to salvage the informations of new user, in this operation the system will link to the database and travel to “ USERS ” table and make new record conatin the information of the new user and give him an autonumber as ID, the decision maker can call off the operation or shut this window by chink on “ Close ” button.
In instance the administratore wants to accomplish the characteristic “ Add New Shop ” , hezshe must snap on “ New store ” button on Administrator ‘s undertaking windw to acquire the undermentioned window, as shown in figure 3.6
Figure 3.6 New Shop Window
In this window we can see that we have merely tow Fieldss about new store, these Fieldss are shop name and store type, after the decision maker fill thee Fieldss, heshe must snap on “ Save ” button to travel through the database and make new record in table “ Shops ” and give this store an autonumber as ShopID.
The decision maker can call off the operation or shut this window by chink on “ Close ” button.
Finally, if the administrtor wants to acquire describe about all stores in this promenade, hese can snap on “ All Shops ” button on Administrator ‘s undertaking windw, the get the study as shown in figure 3.7
Figure 3.7 All Shops study window
3.2.1 Shop Section:
This subdivision specified for the normal user ( the employee of the store ) , the user can travel into this subdivision by snaping on “ Shop ” button in Introduction window, so heshe acquire the folloing window, figure 3.8
Figure 3.8 user Main window
As we see, in this window there are six buttons, each one for different characteristic.
If the user want to execute sale operation, heshe must snap on “ New Sale ” button, so will acquire the undermentioned window, as shown in figure 3.9
Figure 3.9 Sale window
In this window the user will happen list of all goods available in this store and the balance of this goodsand the unist monetary value besides, ths information brought by the system when burden this window, the system will travel to the database and travel to goods table and convey the name of all goods which belong to that store, after that when the user select the goods name and its balance nd the unit monetary value.
After the user fill the requested Fieldss so click on calculate button to cacuate the entire monetary value, so the user chinks on “ Save ” button to salvage the information of sale so he can snap on “ Bill ” button to acquire the measure of this sale.
If the user wants to add new goods heshe must snap on “ New Goods ” button so heshe acquire the undermentioned window, as shown in figure 3.10
Using this system we organize the work in the Hall, besides we cut down the clip and attempt spend to accomplish the undermentioned undertaking:
Register client ‘s information in this system.
Register the comparative information of reserve in this system.
Form the operation of updating the information of reserve.
Form the confirming and caneling reserve in this system.
Geting the studies of all reserve done through this system.
Geting the studies of all reserve done through this system accoring to selected month.
Geting the studies of all reserve done through this system accoring to selected month and twelvemonth.
After utilizing the system we can state that work of Hall reserve can be organized through this system.
As we explain in the organic structure of this study the usage of this system is easy and any one with simple cognition of computing machine use can utilize this system and complete the undertaking without any error.
there is no perfect system and each system contain some notices either the analyzing or the scenario of work, but in this system we try to cover the most of import undertaking or characteristics of shop section work.
Before we build the system we have to analyse the system and observe the work flow of working and see what are the regulations that control work in Hall reserve operation to get down constructing the tabular arraies and see what windows we need and how any windows we must hold in our system
after that we search for tools enable us to plan the system in best manner, we find that the easiest tools to make that is VISUAL BASIC ( VB ) for plan the user interface and Microsoft Office Access ( MSACCESS ) as database direction system, these tools are easy to utilize and easy to be used in developing the system in future.
When start to construct new system the interior decorator face tow types of job proficient and official.
The proficient jobs was to happen the suited and utile tools ( programming and database direction system ) enable the interior decorator to construct efficient system and enable the user to hive away many records in database able to be retrieved in few seconds without any jobs.
After we choose the scheduling linguistic communication and database direction system and link them together and get down construct the database and tabular array and get down composing the codification that will be executed while system running in order to accomplish the undertakings of this system.