Summary of the invention
The invention aims to solve the deficiencies in the prior art, it is flat to provide a kind of Government bidding based on B/S
Platform.
In order to achieve the above objectives, the present invention is implemented according to following technical scheme:
A kind of Government bidding platform based on B/S, including government notice module, I declare module, project management module
With concluding a research item auditing module;The government notice module includes project bulletin module, acceptance of the bid bulletin module, abandoned tender bulletin module, item
Mesh bulletin module includes previewing module, search module, declares module, and acceptance of the bid bulletin module includes previewing module and search module,
It includes previewing module and search module that abandoned tender, which announces module,;My module of declaring includes search module, checks module;It is described
Project management module includes grassroot project module, rough draft tank module, has sent out projects module, profiling module, grassroot project module
Including release module, deposit rough draft module, closedown module, rough draft tank module includes removing module, editor module, previewing module,
Hair projects module includes that module, previewing module, name query module, module of failing to be sold at auction are checked in classification;Profiling module includes preview
Module, compound query module, Conditional reset module;The concluding a research item auditing module includes module to be processed and processed module, to
Processing module includes checking that module, audit judgment module, processed module include checking reason module, profiling module;Wherein
Government notice module is used to show project bulletin, acceptance of the bid bulletin and abandoned tender notice information to user;
My module of declaring searches for and checks the project that user declares for user;
Project management module carries out grassroot project for governability person, issues the project of newly-built project or draft
It goes out, check project sent out and filed;
Concluding a research item auditing module enters concluding a research item auditing module for governability person, can audit in a module pending
Project checks the project audited;
Grassroot project module issues the project of compiled completion for user, and project is published to item by platform
Mesh bulletin;
Rough draft tank module does not fill in complete project for temporarily saving, and is deleted rough draft, a key is emptied, edited
Operation;
Classification checks that module selects the corresponding corresponding data of status display for combobox;
Name query module can search for relevant project generally for cuit title;
Check module for checking the details of project, attachment downloading;
Module of failing to be sold at auction issues abandoned tender bulletin for abolishing project;
Compound query module is used to carry out many condition compound query for filing project;
Conditional reset module restores to the original state for resetting whole querying conditions.
Compared with prior art, the present invention is based on government's bidding platform of B/S framework, information technology is introduced into tradition
Government's bidding in, make government's bidding to automation, electronic the two directions transformation.Use completely new trick
Bid information management tool will can make government's bidding become more transparent and efficient, by the competing of fair, just and open
Striving property principle is deepened into bidding process;The present invention has the function of information publication and by information filing preservation etc., realizes bid
Informationization and electronization.
Specific embodiment
To make the objectives, technical solutions, and advantages of the present invention more comprehensible, with reference to embodiments, to the present invention into
Row is further to be described in detail.Described herein the specific embodiments are only for explaining the present invention, is not used to limit invention.
As shown in Figure 1, a kind of Government bidding platform based on B/S of the present embodiment, including government notice module, my Shen
Report module, project management module and concluding a research item auditing module;The government notice module includes project bulletin module, acceptance of the bid bulletin mould
Block, abandoned tender announce module, and project bulletin module includes previewing module, search module, declares module, and acceptance of the bid bulletin module includes pre-
Look at module and search module, it includes previewing module and search module that abandoned tender, which announces module,;It is described I declare module include search
Module checks module;The project management module includes grassroot project module, rough draft tank module, has sent out projects module, filed
Module, grassroot project module include release module, deposit rough draft module, closedown module, and rough draft tank module includes removing module, editor
Module, previewing module, having sent out projects module includes that module, previewing module, name query module, module of failing to be sold at auction are checked in classification;?
Profiling module includes previewing module, compound query module, Conditional reset module;The concluding a research item auditing module includes module to be processed
With processed module, module to be processed include check module, audit judgment module, processed module include check reason module,
Profiling module;Wherein
Government notice module is used to show project bulletin, acceptance of the bid bulletin and abandoned tender notice information to user;
My module of declaring searches for and checks the project that user declares for user;
Project management module carries out grassroot project for governability person, issues the project of newly-built project or draft
It goes out, check project sent out and filed;
Concluding a research item auditing module enters concluding a research item auditing module for governability person, can audit in a module pending
Project checks the project audited;
Grassroot project module issues the project of compiled completion for user, and project is published to item by platform
Mesh bulletin;
Rough draft tank module does not fill in complete project for temporarily saving, and is deleted rough draft, a key is emptied, edited
Operation;
Classification checks that module selects the corresponding corresponding data of status display for combobox;
Name query module can search for relevant project generally for cuit title;
Check module for checking the details of project, attachment downloading;
Module of failing to be sold at auction issues abandoned tender bulletin for abolishing project;
Compound query module is used to carry out many condition compound query for filing project;
Conditional reset module restores to the original state for resetting whole querying conditions.
Government bidding platform is the bid platform that a government calls for bid towards enterprise.Government staff are in platform
Upper grassroot project, and issue project bulletin, enterprise work personnel check that oneself suitable project is declared in project bulletin.With
Choosing mark and opening of bid afterwards lower online will carry out, and after choosing mark, government staff carry out choosing mark after having arrived deadline for submission of tenders
And issue acceptance of the bid bulletin, enterprise work personnel both can check acceptance of the bid situation in acceptance of the bid bulletin, can also in enterprise my Shen
Check whether oneself gets the bid in report.Middle target unit submits concluding a research item data in concluding a research item on platform, is carried out by governability person
Audit.Audit retracts enterprise work people by that can carry out filing processing after audit is not by filling in reason by governability person
Member is resubmited after the completion by enterprise work personnel modification, then is audited by governability person.
Therefore the function that this platform undertakes can be summarized as publication and show that the information of bid and filing save bid institute every time
The file being related to, such as need call for bid project information, bidding documents, various attachment files.
Bid process includes publication project, declares project, and publication project declares the flow chart of project respectively such as Fig. 2 and Fig. 3
It is shown.
Using it is noted that the access right of user, user is divided into two kinds when design when this platform: governability person and
Enterprise customer.The permission of two kinds of users is different, and only government customer could use " project management " and " concluding a research item audit " function
Can, only enterprise customer could use " mine declares " function.And government notice module is that two kinds of users can use.
The system database designing of this platform is divided into conception framework design, data dictionary design also Logic Structure Design.
The purpose of conception framework design is the demand of user to be converted into the process of abstract model, therefore it is entire database design
It is crucial.Wherein the data item of data dictionary have field name, data type, length, whether be empty, be primary key or outer code and remarks
Deng.
The design of user management database
User management conception framework design
User: user Id (major key), user name, user password, subscriber mailbox, user's head portrait, gender, true name, connection electricity
Whether words, ID card No., user can be used)
Role: role Id (major key), role's title, role father id, role hierarchy, Role delineation
Permission: authority module, authority credentials, authority name, permission description
User management E-R G- Design, as shown in figure 4, point three contents: user, role, permission.
User management module shares five data dictionaries, there is user's table, user-role's table, Jiao Sebiao, role-power respectively
Limit table and authority list.As shown in table 1, table 2, table 3, table 4 and table 5.
1 user's table of table
Field name |
Data type |
Length |
It whether is empty |
Primary key/outer code |
Remarks |
user_id |
Int |
10 |
No |
Primary key |
User id |
username |
Char |
20 |
No |
------ |
User name |
password |
Char |
32 |
No |
------ |
User password |
email |
Char |
40 |
No |
------ |
Subscriber mailbox |
imageName |
Char |
41 |
Yes |
------ |
User's head portrait |
gender |
Char |
5 |
No |
------ |
Gender |
realname |
Char |
8 |
No |
------ |
True name |
phone |
Char |
18 |
Yes |
------ |
User contact details |
id |
int |
20 |
Yes |
------ |
ID card No. |
visible |
bit |
0 |
No |
------ |
Whether user can be used |
2 users of table-role's table
Field name |
Data type |
Length |
It whether is empty |
Primary key/outer code |
Remarks |
user_id |
int |
10 |
No |
Primary key |
User id |
groupid |
int |
11 |
No |
Primary key |
Permission group id (uses UUID) |
3 role's table of table
Field name |
Data type |
Length |
It whether is empty |
Primary key/outer code |
Remarks |
role_id |
int |
10 |
No |
Primary key |
Role id |
name |
varchar |
60 |
No |
------ |
Role's title |
parent_id |
int |
10 |
No |
------ |
Role father id |
role_grade |
Int |
10 |
Yes |
------ |
Role hierarchy |
description |
varchar |
50 |
Yes |
------ |
Role delineation |
4 roles of table-authority list
Field name |
Data type |
Length |
It whether is empty |
Primary key/outer code |
Remarks |
role_id |
int |
20 |
No |
Primary key |
Role id |
module |
varchar |
40 |
No |
Primary key |
Authority module |
privilege |
varchar |
20 |
No |
Primary key |
Authority credentials |
5 authority list of table
Field name |
Data type |
Length |
It whether is empty |
Primary key/outer code |
Remarks |
model |
varchar |
20 |
No |
Primary key |
Authority module |
privilege |
varchar |
20 |
No |
Primary key |
Authority credentials |
name |
varchar |
60 |
No |
------ |
Authority name |
description |
varchar |
50 |
Yes |
------ |
Permission description |
The Logic Structure Design of user is as shown in Figure 5.
Government bidding platform data conception framework design is as follows:
Project table: project Id (major key), project name, issuing unit, issuing time, contact person, telephone number, electronics postal
Case, project demand, concluding a research item require, declare deadline, project status, Entry Details.
Declaration form: it declares Id (major key), item id, declare unit, declared value, contact person, telephone number, electronics postal
Case declares state, program profile.
File table: filing Id (major key), item id, project name, issuing unit, executable unit ID, executable unit, completion
Situation, issue date, target date, concluded price.
Attachment table: attachment Id (major key), User ID, ownership ID, attachment name, attachment size, attachment destination path, accessory class
Type.
Government bidding platform E-R G- Design, as shown in Figure 6.
Government bidding platform shares 4 data dictionaries, such as table 6 to project table, declaration form shown in table 9, filing table and attached
Part table.
6 project table of table
Field name |
Data type |
Length |
It whether is empty |
Primary key/outer code |
Remarks |
Id |
int |
11 |
No |
Primary key |
Project id |
audit_date |
datetime |
0 |
No |
Outer code |
Audit the date |
content |
text |
0 |
No |
------ |
Details |
email |
varchar |
255 |
No |
------ |
E-mail address |
end_date |
datetime |
8 |
No |
------ |
Deadline |
fail_reason |
varchar |
255 |
Yes |
------ |
It fails to be sold at auction reason |
item_require |
int |
11 |
No |
------ |
Project demand |
knot_date |
datetime |
0 |
No |
------ |
The concluding a research item date |
knot_require |
text |
0 |
No |
------ |
Concluding a research item requirement |
name |
varchar |
255 |
No |
------ |
Contact person |
phone |
varchar |
255 |
No |
------ |
Contact phone |
reason |
varchar |
255 |
No |
------ |
Reason/situation |
send_date |
datetime |
0 |
No |
------ |
Issuing time |
title |
varchar |
255 |
No |
------ |
Project name |
unit |
varchar |
255 |
No |
------ |
Issuing unit |
user_id |
bigint |
20 |
No |
------ |
User ID |
7 declaration form of table
Field name |
Data type |
Length |
It whether is empty |
Primary key/outer code |
Remarks |
Id |
int |
11 |
No |
Primary key |
Declare id |
item_id |
int |
11 |
No |
Outer code |
Project id |
unit_id |
int |
11 |
No |
Outer code |
Declare unit id |
bid_state |
int |
11 |
No |
------ |
Declare state |
email |
varchar |
255 |
No |
------ |
E-mail address |
introduction |
varchar |
255 |
No |
------ |
Program profile |
name |
varchar |
255 |
No |
------ |
Name |
notice_time |
datetime |
0 |
No |
------ |
The publication bulletin time |
phone |
varchar |
255 |
No |
------ |
Contact phone |
price |
int |
11 |
No |
------ |
Declared value |
send_unit |
varchar |
255 |
No |
------ |
Issue Project Unit |
title |
varchar |
255 |
No |
------ |
Project name |
unit |
varchar |
255 |
No |
------ |
Declare unit |
Table 8 files table
9 attachment table of table
Field name |
Data type |
Length |
It whether is empty |
Primary key/outer code |
Remarks |
Id |
int |
11 |
No |
Primary key |
Attachment id |
belong_id |
int |
11 |
No |
Outer code |
Affiliated id |
file_url |
varchar |
255 |
No |
------ |
Enclosure path |
name |
varchar |
255 |
No |
------ |
File name |
size |
varchar |
255 |
No |
------ |
File size |
type |
int |
11 |
No |
------ |
File type |
upload_date |
datetime |
0 |
No |
------ |
Uplink time |
user_id |
bigint |
20 |
No |
------ |
User id |
Government bidding platform logic structural design drawing is as shown in fig. 7, be broadly divided into four big structures: project, declare, file and
Attachment.
The specific operation process of this platform is as follows:
" government notice " is clicked in navigation bar after user's login, can join the civil service and announce functional module.The functional module
Effect be to user show project bulletin, acceptance of the bid bulletin and abandoned tender bulletin etc. information.
One of bulletin module in the navigation bar at top is clicked, is entered in relevant bulletin page.Such as click " item
Mesh bulletin ".The information that the module includes is by the title of project, the unit of publication, issue date and deadline.Can carry out
Operation has preview and search.Acceptance of the bid bulletin and abandoned tender bulletin are similar with the function that project is announced.
The detail page of bulletin can be entered by clicking preview.It is different according to the type of bulletin, announce the information shown in detail
Also different.It distinguishes as follows
(1) project bulletin detail page effect and show information include issuing unit essential information and bid it is detailed
Information, project demand and concluding a research item requirement.
(2) effect of the detail page of acceptance of the bid bulletin and displaying information include the essential information and bidding documents details of bidder.
(3) abandoned tender bulletin detail page effect and show information include the essential information of issuing unit, bid it is detailed
Information and the reason of failing to be sold at auction.
The key code of government notice is as follows.The effect of this section of code is that project status is " to have sent out public affairs in reading project table
The bulletin of announcement ", acceptance of the bid bulletin are similar with the code that abandoned tender is announced.Corresponding itemState (bulletin state) need to be only specified, i.e.,
It can.
Enterprise customer can declare project and check the project declared.
Enterprise customer wants the project of declaring, and still can click " Shen at the project bulletin detail page of the project of bidding period
Report ", which enters, declares project link.The data being automatically loaded has and (declares unit, contact person, telephone number and E-mail address), needs
The data of input has (quotation, program profile), it is also necessary to upload the attachment of bidding documents.
After enterprise customer has declared project, it can be clicked in navigation bar " mine declares ", find the project checked and declared
Entrance.
Into after " mine declares " module, it can be seen that my list page declared.It can be seen that the project declared.Column
The information that table is shown has project name, declared value, declares these important information of state, and item can be checked by clicking project name
Purpose details, " check and declare details " after click project can check the information filled in when declaring project.
It for middle target project, if project has been completed, can click " concluding a research item ", concluding a research item data is submitted to wait government's pipe
Reason person's audit.If audit is by can concluding a research item.If audit does not pass through, it can check that audit by reason, can not click " knot
", resubmit concluding a research item data.
Governability person can issue project, can check the project of hair and select acceptance of the bid user.It can file and look into
It sees filing project, concluding a research item audit can be carried out and checks the project of concluding a research item, and the project of concluding a research item can be filed.
Governability person clicks " project management " of navigation bar, can enter project management module.The module can be new
Project is built, the project of newly-built project or draft is released, checks project sent out and filed.
" grassroot project ", which is clicked, in the navigation bar of project management inputs corresponding information into the grassroot project page.It can
To create a new project, it can choose publication later or deposit draft.
The core code of grassroot project is as follows.This section of code is one section of JavaScript code, its effect need to
The project information to be filled in is packaged into a JSON object, this object is then passed to server end, calls the side saveItem
Method creates an item objects, and is saved in database.
" draft " can check the project for being stored to draft.It can continue the project that editor will send out herein,
And it can delete or preview project.
" having sent out project " module can check all projects issued.For being more than the project of deadline, government
Item setup can be state of failing to be sold at auction by administrator, then will cannot see that the project in project bulletin.
After governability person's publication project, after submitting a tender under line, selecting the processes such as mark, opening of bid, bid winner is obtained.So
Governability person can be in hair project, into the detail page of project, in the bottom of detail page.Select bid winner, confirmation
It is bid winner and issues acceptance of the bid bulletin.
" filing " module can view filed project.It can search for generally wanting checking by searching for side by side
Project may browse through the details of project.
Governability person clicks " the concluding a research item audit " of navigation bar, can enter concluding a research item auditing module.A module can be with
It audits pending project, check the project audited.
Governability person is responsible for auditing whether the data that enterprise customer submits meets bidding documents requirement, then decides whether to pass through
Audit.
Governability person can check processed project, and the project for having passed through audit can file, and not pass through audit
Project can check its difference audit the reason of.
The limitation that technical solution of the present invention is not limited to the above specific embodiments, it is all to do according to the technique and scheme of the present invention
Technology deformation out, falls within the scope of protection of the present invention.