CN109242449B

CN109242449B - B/S-based government bidding platform

Info

Publication number: CN109242449B
Application number: CN201811448683.1A
Authority: CN
Inventors: 林洁丽; 邝伟铜
Original assignee: Foshan University
Current assignee: Foshan University
Priority date: 2018-11-28
Filing date: 2018-11-28
Publication date: 2022-02-01
Anticipated expiration: 2038-11-28
Also published as: CN109242449A

Abstract

The invention discloses a B/S-based government bidding platform which comprises a government bulletin module, a my declaration module, a project management module and a conclusion auditing module. Compared with the prior art, the B/S architecture-based government bidding platform introduces the information technology into the traditional government bidding work, so that the government bidding work is changed into two directions of automation and electronization. The novel bidding information management tool can make the government bidding work more transparent and efficient, and deepens the competitive principles of fairness, fairness and openness into the bidding process; the invention has the functions of information publishing, information archiving and storage and the like, and realizes the informatization and the electronization of bidding.

Description

B/S-based government bidding platform

Technical Field

The invention relates to the technical field of online bidding management systems, in particular to a B/S-based government bidding platform.

Background

Since 1978, the Chinese economy has revolutionized open spring breeze and has experienced a period of rapid development. Particularly, since 2001 was added to the world trade organization, the Chinese economy has been in the gold development period of decades. As Chinese economy develops rapidly, the public resource transaction quantity of the government is increased, and the transaction scale is a step-up, which leads to fair, just and open attention of all social groups to government bidding. Therefore, the construction of a government bidding system and the informatization transformation of the traditional bidding work can not only provide assistance for economic development, but also improve the efficiency of the government bidding work, and further meet the transparency requirement of the masses on the relevant information of the government bidding. Therefore, it is an extremely important issue to design and implement a bidding system by using proper tools and methods, so that the competitiveness, fairness and openness in the bidding process can be fully reflected.

With the advent of the information age, many developed countries are aware of the benefits of taking advantage of the information high-speed channel, and under the control and promotion of governments, some developed countries and regions in europe and the united states have been in dispute to transition and transform traditional bidding work to electronization and informatization. Not only can improve the working efficiency, but also can establish a transparent and fair bidding system. For example, electronic bidding begins to be adopted in canada in 1991, and a government purchasing network is invested and used in 1997, is the only official website for issuing bidding information in canada, and successfully saves a great deal of purchasing cost for the government; from 2006 to 1 month, germany requires the federal primary government to unify the procurement of general goods and services with an electronic procurement platform developed by the government; the united states, which places great importance on the use of information technology in government procurement, has all of its contractual procurement projects procured through an online procurement platform.

Compared with foreign countries, the traditional bidding mode, namely on-site bid opening and bid evaluation, is mainly adopted for national bidding. However, with the increasing number of bids, there are contradictions between fairness, justice, disclosure, and quality, efficiency, and preference. Because the traditional bidding mode is difficult to keep pace with the era, the market development and social progress are in all aspects.

Disclosure of Invention

The invention aims to solve the defects in the prior art and provide a B/S-based government bidding platform.

In order to achieve the purpose, the invention is implemented according to the following technical scheme:

a B/S-based government bidding platform comprises a government notice module, a my declaration module, a project management module and an item settlement auditing module; the government announcement module comprises a project announcement module, a bid winning announcement module and a waste announcement module, the project announcement module comprises a preview module, a search module and an announcement module, the bid winning announcement module comprises a preview module and a search module, and the waste announcement module comprises a preview module and a search module; the my declaration module comprises a searching module and a viewing module; the project management module comprises a newly-built project module, a draft box module, a sent project module and a filed module, wherein the newly-built project module comprises an issuing module, a draft storing module and a closing module, the draft box module comprises a deleting module, an editing module and a previewing module, and the sent project module comprises a classified viewing module, a previewing module, a name inquiring module and a streaming standard module; the filed module comprises a preview module, a composite query module and a condition resetting module; the result auditing module comprises a to-be-processed module and a processed module, the to-be-processed module comprises a checking module and an auditing judging module, and the processed module comprises a checking reason module and a filing module; wherein

The government announcement module is used for displaying project announcement, bid winning announcement and bid discarding announcement information to the user;

the My declaration module is used for searching and viewing items declared by the user;

the project management module is used for a government administrator to build a project, release the project of the built project or draft box and check the published and filed project;

the result auditing module is used for allowing a government administrator to enter the result auditing module, and can audit the items to be audited and check the audited items in the module;

the new project module is used for releasing the edited project by the user, and the project is released to the project bulletin through the platform;

the draft box module is used for temporarily storing incomplete items, and carrying out operations such as deleting, clearing by one key, editing and the like on the draft;

the classification viewing module is used for selecting a corresponding state from the drop-down box and displaying corresponding data;

the name query module is used for inputting the name of the item and searching related items in a fuzzy mode;

the viewing module is used for viewing detailed information of the project and downloading the attachment;

the flow mark module is used for eliminating the project and issuing a waste mark announcement;

the compound query module is used for carrying out multi-condition compound query on the filing items;

the condition resetting module is used for resetting all query conditions and restoring the original state.

Compared with the prior art, the B/S architecture-based government bidding platform introduces the information technology into the traditional government bidding work, so that the government bidding work is changed into two directions of automation and electronization. The novel bidding information management tool can make the government bidding work more transparent and efficient, and deepens the competitive principles of fairness, fairness and openness into the bidding process; the invention has the functions of information publishing, information archiving and storage and the like, and realizes the informatization and the electronization of bidding.

Drawings

FIG. 1 is a functional block diagram of a government bidding platform of the present invention.

FIG. 2 is a flow chart of a release project in the government bidding process of the present invention.

Fig. 3 is a flow chart of a claim project in a government bidding process of the present invention.

FIG. 4 is a diagram of user administration E-R of the government bidding platform of the present invention.

FIG. 5 is a user management logic structure design of the government bidding platform of the present invention.

FIG. 6 is a diagram of a government tender platform E-R of the government tender platform of the present invention.

Fig. 7 is a diagram of the government tender platform logic structure design for the government tender platform of the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is further described in detail with reference to the following embodiments. The specific embodiments described herein are merely illustrative of the invention and do not limit the invention.

As shown in fig. 1, the B/S-based government bidding platform of the present embodiment includes a government announcement module, a my declaration module, a project management module, and an outcome auditing module; the government announcement module comprises a project announcement module, a bid winning announcement module and a waste announcement module, the project announcement module comprises a preview module, a search module and an announcement module, the bid winning announcement module comprises a preview module and a search module, and the waste announcement module comprises a preview module and a search module; the my declaration module comprises a searching module and a viewing module; the project management module comprises a newly-built project module, a draft box module, a sent project module and a filed module, wherein the newly-built project module comprises an issuing module, a draft storing module and a closing module, the draft box module comprises a deleting module, an editing module and a previewing module, and the sent project module comprises a classified viewing module, a previewing module, a name inquiring module and a streaming standard module; the filed module comprises a preview module, a composite query module and a condition resetting module; the result auditing module comprises a to-be-processed module and a processed module, the to-be-processed module comprises a checking module and an auditing judging module, and the processed module comprises a checking reason module and a filing module; wherein

The government bidding platform is a government enterprise-oriented bidding platform for bidding. And (4) newly building a project on the platform by government workers, issuing project bulletins, and checking proper projects by enterprise workers in the project bulletins to declare. And after the bid selection is finished, government workers select the bid and issue bid-winning notices after the bid deadline time, and enterprise workers can check the bid-winning condition in the bid-winning notices and can check whether the enterprise wins the bid in my reports. And submitting the closing information on the platform when closing the closing of the winning bid by the unit of winning bid, and auditing by a government administrator. And after the reason is filled in by a government administrator, the enterprise staff is returned after the audit is passed, and the enterprise staff submits the audit again after the enterprise staff completes the modification, and then the government administrator performs the audit.

Therefore, the functions undertaken by the platform can be summarized as publishing and displaying the bidding information and filing and saving the files involved in each bidding, such as project information, bidding documents, various attachments and other files needing bidding.

The bidding process includes publishing items and declaring items, and the flowcharts of publishing items and declaring items are respectively shown in fig. 2 and fig. 3.

When the platform is used, the use authority of the user needs to be noticed, and the user is divided into two types during design: government administrators and enterprise users. The authority of the two users is different, only government users can use the functions of project management and result auditing, and only enterprise users can use the function of my declaration. And government announcement modules are available to both users.

The system database design of the platform comprises concept structure design, data dictionary design and logic structure design. The purpose of concept structure design is to translate the user's requirements into a process of abstract model, so it is the key to the overall database design. The data items of the data dictionary comprise field names, data types, lengths, whether the data items are empty, main codes or external codes, remarks and the like.

User management database design

User management concept structure design

The user: user Id (Primary Key), user name, user password, user mailbox, user avatar, gender, true name, contact number, identification number, user availability)

Role: role Id (primary key), role name, role parent Id, role level, role description

Permission: authority module, authority value, authority name and authority description

The user manages the E-R diagram design, as shown in FIG. 4, in three parts: user, role, authority.

The user management module has five data dictionaries, which are respectively provided with a user table, a user-role table, a role-authority table and an authority table. As shown in tables 1, 2, 3, 4 and 5.

TABLE 1 user table

Name of field	Data type	Length of	Whether or not it is empty	Main code/outer code	Remarks for note
						user_id	Int	10	No	Main code	User id
username	Char	20	No	------	User name
						password	Char	32	No	------	User password
email	Char	40	No	------	User mailbox
						imageName	Char	41	Yes	------	User head portrait
gender	Char	5	No	------	Sex
						realname	Char	8	No	------	True name
phone	Char	18	Yes	------	User contact
						id	int	20	Yes	------	Identity card number
visible	bit	0	No	------	Whether the user is available

TABLE 2 User-role table

Name of field	Data type	Length of	Whether or not it is empty	Main code/outer code	Remarks for note
						user_id	int	10	No	Main code	User id
groupid	int	11	No	Main code	Permission group id (UUID adopted)

TABLE 3 corner chart

Name of field	Data type	Length of	Whether or not it is empty	Main code/outer code	Remarks for note
						role_id	int	10	No	Main code	Role id
name	varchar	60	No	------	Role names
						parent_id	int	10	No	------	Role parent id
role_grade	Int	10	Yes	------	Role level
						description	varchar	50	Yes	------	Role description

Table 4 role-authority table

Name of field	Data type	Length of	Whether or not it is empty	Main code/outer code	Remarks for note
						role_id	int	20	No	Main code	Role id
module	varchar	40	No	Main code	Authority module
						privilege	varchar	20	No	Main code	Authority value

TABLE 5 Authority Table

Name of field	Data type	Length of	Whether or not it is empty	Main code/outer code	Remarks for note
						model	varchar	20	No	Main code	Authority module
privilege	varchar	20	No	Main code	Authority value
						name	varchar	60	No	------	Authority name
description	varchar	50	Yes	------	Rights description

The logical structure of the user is designed as shown in fig. 5.

The data concept structure of the government bidding platform is designed as follows:

item table: project Id (primary key), project name, issuing unit, issuing time, contact person, contact telephone, electronic mail box, project requirement, ending requirement, declaration deadline, project state and project detail information.

Reporting the form: declaration Id (primary key), project Id, declaration unit, declaration price, contact person, contact phone, email, declaration status, and scheme introduction.

Filing a table: archive Id (Primary Key), item ID, item name, issue Unit, execution Unit ID, execution Unit, completion, issue date, completion date, deal price.

Accessory table: attachment Id (primary key), user Id, home Id, attachment name, attachment size, attachment target path, attachment type.

Government tender platform E-R diagram design, as shown in fig. 6.

The government tender platform has 4 data dictionaries, such as project tables, declaration tables, archive tables and attachment tables shown in tables 6 to 9.

Table 6 item table

Name of field	Data type	Length of	Whether or not it is empty	Main code/outer code	Remarks for note
						Id	int	11	No	Main code	Item id
audit_date	datetime	0	No	Outer code	Date of audit
						content	text	0	No	------	Detailed information
email	varchar	255	No	------	Electronic mail box
						end_date	datetime	8	No	------	Cut-off time
fail_reason	varchar	255	Yes	------	Reason for drift
						item_require	int	11	No	------	Project requirement
knot_date	datetime	0	No	------	Date of tying
						knot_require	text	0	No	------	Meet the requirements of an item
name	varchar	255	No	------	Contact person
						phone	varchar	255	No	------	Contact telephone
reason	varchar	255	No	------	Reason/situation
						send_date	datetime	0	No	------	Time of release
title	varchar	255	No	------	Name of item
						unit	varchar	255	No	------	Issuing unit
user_id	bigint	20	No	------	User ID

TABLE 7 statement

Name of field	Data type	Length of	Whether or not it is empty	Main code/outer code	Remarks for note
						Id	int	11	No	Main code	Declaration id
item_id	int	11	No	Outer code	Item id
						unit_id	int	11	No	Outer code	Reporting unit id
bid_state	int	11	No	------	Declaring status
						email	varchar	255	No	------	Electronic mail box
introduction	varchar	255	No	------	Brief introduction to the scheme
						name	varchar	255	No	------	Name (I)
notice_time	datetime	0	No	------	Time of announcement
						phone	varchar	255	No	------	Contact telephone
price	int	11	No	------	Reporting price
						send_unit	varchar	255	No	------	Issuing item units
title	varchar	255	No	------	Name of item
						unit	varchar	255	No	------	Reporting unit

Table 8 filing table

Watch 9 attachment

Name of field	Data type	Length of	Whether or not it is empty	Main code/outer code	Remarks for note
						Id	int	11	No	Main code	Accessory id
belong_id	int	11	No	Outer code	Belonged id
						file_url	varchar	255	No	------	Accessory path
name	varchar	255	No	------	File name
						size	varchar	255	No	------	File size
type	int	11	No	------	File type
						upload_date	datetime	0	No	------	Upload time
user_id	bigint	20	No	------	User id

The government bidding platform logic structure design drawing is shown in fig. 7 and mainly comprises four structures: project, declaration, archive, and attachment.

The specific operation process of the platform is as follows:

after logging in, the user clicks 'government notice' on the navigation bar, and can enter the government notice function module. The function module is used for displaying information such as project bulletins, bid winning bulletins and bid discarding bulletins to users.

Clicking one of the bulletin modules in the navigation bar at the top to enter the related bulletin page. Such as clicking on "project bulletin". The module contains information consisting of the name of the item, the unit of release, the release date and the expiration date. Among the operations that can be performed are previewing and searching. The winning bid and denying bid announcements function similarly to the project announcements.

Clicking on the preview may enter the detailed page of the announcement. The detailed information presented by the bulletins is different according to the types of the bulletins. The differences are as follows

(1) The effect and display information of the detailed page of the project bulletin includes basic information of a publishing unit and detailed information of a bid, project requirements and ending requirements.

(2) The effect and display information of the detailed page of the winning bid notice comprises basic information and bidding details of the bidder.

(3) The effect of the detailed page of the trash announcement and the presentation information include basic information of a distribution unit, detailed information of a bid, and a reason for a tape-out.

The key codes for government announcements are as follows. The function of the code is to read the announcement of which the item status is 'announced' in the item table, and the codes of the winning bid announcement and the disused bid announcement are similar. Only the corresponding itemState (announcement status) needs to be specified.

Enterprise users can declare projects and view declared projects.

When the enterprise user wants to declare a project, the enterprise user can click to 'declare' to enter a project declaration link at a project bulletin detail page of the project in the bidding stage. The automatically loaded data includes declaration unit, contact person, contact telephone and electronic mail box, the data to be input includes quotation and brief introduction of scheme, and the attachment of label is uploaded.

After the enterprise user declares the project, the user can click 'my declaration' on the navigation bar to find an entrance for viewing the declared project.

After entering the My declaration module, the list page of My declaration can be seen. The declared items can be seen. The list display information comprises important information such as a project name, a declaration price and a declaration state, the details of the project can be checked by clicking the project name, and the information filled in the declaration project can be checked by checking the declaration details after clicking the project.

For a winning bid item, if the item has been completed, "closing" may be clicked on, and closing material submitted for review by a government administrator. And if the audit is passed, the item can be concluded. If the audit is not passed, the reason of the non-passing of the audit can be checked, and the 'result' can be clicked to resubmit the result data.

A government administrator may publish the project, may view the published project and select the winning user. Archived items may be archived and viewed, an ending audit and viewing of ended items may be performed, and ended items may be archived.

The government administrator clicks on "project management" of the navigation bar and may enter the project management module. At which a project may be created, published for the new project or draft box, and viewed for published and archived projects.

Clicking a new project on a navigation bar of project management, entering a new project page, and inputting corresponding information. A new project may be created and then the publish or draft save box may be selected.

The core code of the new project is as follows. The code is a JavaScript code, and the function of the code encapsulates project information to be filled into a JSON object, then the object is transmitted to a server, a saveItem method is called, a project object is created, and the project object is stored in a database.

The "draft box" may view the items that were saved to the draft box. The project to be sent out may continue to be edited and the project may be deleted or previewed.

The "sent items" module may view all published items. For items that exceed an expiration date, a government administrator may set the item to a streamer state, and the item will not be visible on the item bulletin.

After the government administrator releases the project, the bidding unit is obtained after the processes of off-line bidding, bid selection, bid opening and the like. The government administrator may enter a detailed page of the project in the sent project, at the bottom of the detailed page. And selecting a winning bid unit, confirming the winning bid unit as the winning bid unit and issuing a winning bid notice.

The "archived" module can view the archived items. Items desired to be viewed can be searched for by a side-by-side search fuzzy search, and detailed information of the items can be browsed.

The government administrator clicks the 'result auditing' of the navigation bar and can enter the result auditing module. The module can review the items to be reviewed and view the reviewed items.

The government administrator is responsible for checking whether the data submitted by the enterprise users meet the standard requirements and then deciding whether the data pass the checking.

Government administrators can view items that have been processed, items that have passed the audit can be archived, and items that have not passed the audit can view reasons for their different audits.

The technical solution of the present invention is not limited to the limitations of the above specific embodiments, and all technical modifications made according to the technical solution of the present invention fall within the protection scope of the present invention.

Claims

1. A B/S-based government bidding platform is characterized by comprising a government bulletin module, a my declaration module, a project management module and an ending auditing module; the government announcement module comprises a project announcement module, a bid winning announcement module and a waste announcement module, the project announcement module comprises a preview module, a search module and an announcement module, the bid winning announcement module comprises a preview module and a search module, and the waste announcement module comprises a preview module and a search module; the my declaration module comprises a searching module and a viewing module; the project management module comprises a newly-built project module, a draft box module, a sent project module and a filed module, wherein the newly-built project module comprises an issuing module, a draft storing module and a closing module, the draft box module comprises a deleting module, an editing module and a previewing module, and the sent project module comprises a classified viewing module, a previewing module, a name inquiring module and a streaming standard module; the filed module comprises a preview module, a composite query module and a condition resetting module; the result auditing module comprises a to-be-processed module and a processed module, the to-be-processed module comprises a checking module and an auditing judging module, and the processed module comprises a checking reason module and a filing module; wherein

the result auditing module is used for allowing a government administrator to enter the result auditing module, and can audit the items to be audited and check the audited items;

the draft box module is used for temporarily storing unfilled items, and carrying out deletion, one-key emptying and editing operation on the draft;