CN111400332A - Project progress monitoring method and device - Google Patents
Project progress monitoring method and device Download PDFInfo
- Publication number
- CN111400332A CN111400332A CN202010192445.XA CN202010192445A CN111400332A CN 111400332 A CN111400332 A CN 111400332A CN 202010192445 A CN202010192445 A CN 202010192445A CN 111400332 A CN111400332 A CN 111400332A
- Authority
- CN
- China
- Prior art keywords
- task list
- monitored
- project
- progress
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000012544 monitoring process Methods 0.000 title claims abstract description 83
- 238000000034 method Methods 0.000 title claims abstract description 55
- 238000012216 screening Methods 0.000 claims abstract description 95
- 238000009825 accumulation Methods 0.000 claims description 5
- 238000012545 processing Methods 0.000 claims description 5
- 238000005516 engineering process Methods 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 8
- 238000007726 management method Methods 0.000 description 8
- 238000012806 monitoring device Methods 0.000 description 7
- 238000004364 calculation method Methods 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 238000001914 filtration Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 230000002354 daily effect Effects 0.000 description 2
- 238000005034 decoration Methods 0.000 description 2
- 230000003203 everyday effect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 230000001960 triggered effect Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000009877 rendering Methods 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06311—Scheduling, planning or task assignment for a person or group
- G06Q10/063114—Status monitoring or status determination for a person or group
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06315—Needs-based resource requirements planning or analysis
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Quality & Reliability (AREA)
- Educational Administration (AREA)
- Computational Linguistics (AREA)
- Game Theory and Decision Science (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Mathematical Physics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a project progress monitoring method and device. Wherein, the method comprises the following steps: acquiring configuration information, wherein the configuration information is used for describing the screening condition of a task list to be monitored in a target project and a data field to be counted in the task list to be monitored; screening out the task list to be monitored which meets the screening condition from a preset storage area according to the configuration information, and determining index data of the task list to be monitored according to the data field to be counted; and updating the project progress of the target project according to the index data, and displaying the updated project progress. The method and the device solve the technical problem that the reliability of the progress of the milestone is low due to the fact that the operation process is complicated in a mode of managing the progress of the milestone in the project in the related technology.
Description
Technical Field
The invention relates to the technical field of project progress management, in particular to a project progress monitoring method and device.
Background
In actual project management, a project is usually divided into a plurality of milestones, each milestone corresponds to a definite project goal, and the completion of the goal under the milestone definition is significant to the project as a whole. Therefore, project management engineers often need to know the overall task progress status, completion rate and completion trend within the scope of milestones, so as to help the team adjust the demand and work strategy in time and ensure the completion of the staged milestone targets.
The progress condition of the milestone range depends on the completion degree of the task list, and the current completion state cannot be accurately reflected by the single task. At present, project management engineers use Excel to input task list data, count estimated workload and completion amount in the task list, and calculate in Excel to obtain the progress and rough state of multiple milestones in the current project.
Although the prior art can obtain the progress of the milestone, the operation process is very complicated and time-consuming, the manual intervention factors are too many, the miscalculation progress is easily caused, the instantaneity is not high, and the current trend of the milestone cannot be visually represented.
Aiming at the problem that the reliability of the progress of the obtained milestone is low due to the fact that the operation process of the mode of managing the progress of the milestone in the project is complex in the related technology, an effective solution is not provided at present.
Disclosure of Invention
The embodiment of the invention provides a project progress monitoring method and device, which at least solve the technical problem that the reliability of the obtained milestone progress is lower due to the fact that the operation process is relatively complicated in a mode of managing the progress of the milestone in a project in the related art.
According to an aspect of an embodiment of the present invention, a method for monitoring a project progress is provided, including: acquiring configuration information, wherein the configuration information is used for describing a screening condition of a task list to be monitored in a target project and a data field to be counted in the task list to be monitored; screening out the task list to be monitored which meets the screening condition from a preset storage area according to the configuration information, and determining index data of the task list to be monitored according to the data field to be counted; and updating the project progress of the target project according to the index data, and displaying the updated project progress.
Optionally, before the obtaining the configuration information, the method for monitoring the progress of the project further includes: creating the screening condition; wherein the creating the screening condition comprises: determining attribute information of a task list to be monitored in the target project, wherein the attribute information comprises: the tracking label of the task list to be monitored, the workload type information of the task list to be monitored and the completion degree information of the task list to be monitored; and creating the screening condition according to the attribute information.
Optionally, the target project is divided into a plurality of task phases, and the plurality of task phases respectively correspond to different time nodes.
Optionally, before the task list to be monitored meeting the screening condition is screened out from the predetermined storage area according to the configuration information, the method for monitoring the progress of the project further includes: and creating a sub-storage area in the predetermined storage area, wherein the sub-storage area is used for storing the configuration information.
Optionally, the screening out the to-be-monitored task list meeting the screening condition from the predetermined storage area according to the configuration information includes one of: acquiring a monitoring request, responding to the monitoring request, and screening out a historical task list in a preset time period before the generation time of the monitoring request according to the screening condition; and acquiring a monitoring request, and screening out a task list to be monitored which meets the condition from the new task list according to the screening condition when monitoring that the new task list is generated after the monitoring request is generated for the target project.
Optionally, the determining the index data of the task list to be monitored according to the data field to be counted includes: determining the workload of each task list in the task lists to be monitored, counting to obtain the sum of the workloads of each task list, and determining the completion degree data of the task lists to be monitored according to the sum of the workloads of each task list and the completion degree of each task list; and acquiring all the completed data of the to-be-monitored task list, and determining the completion trend data of the to-be-monitored task list according to all the completed data.
Optionally, the metric data includes: and target completion index data, accumulation completion index data and trend index data are completed.
Optionally, the updating the project progress of the target project according to the index data includes: determining a time period corresponding to the index data for generating the task list to be monitored; generating a completion line and a trend line in the time period according to the index data; and updating the completion line and the trend line into a progress monitoring graph of the target project.
According to another aspect of the embodiments of the present invention, there is provided a project progress monitoring apparatus, including: the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring configuration information, and the configuration information is used for describing the screening condition of a task list to be monitored in a target project and a data field to be counted in the task list to be monitored; the screening unit is used for screening the task list to be monitored which meets the screening condition from a preset storage area according to the configuration information and determining index data of the task list to be monitored according to the data field to be counted; and the updating unit is used for updating the project progress of the target project according to the index data and displaying the updated project progress.
Optionally, the monitoring device of project progress further includes: a first creating unit, configured to create the filtering condition before the configuration information is acquired; wherein the first creating unit includes: a first determining module, configured to determine attribute information of a task list to be monitored in the target project, where the attribute information includes: the tracking label of the task list to be monitored, the workload type information of the task list to be monitored and the completion degree information of the task list to be monitored; and the creating module is used for creating the screening condition according to the attribute information.
Optionally, the target project is divided into a plurality of task phases, and the plurality of task phases respectively correspond to different time nodes.
Optionally, the monitoring device of project progress further includes: and a second creating unit, configured to create a sub-storage area in a predetermined storage area before the task sheet to be monitored meeting the screening condition is screened out from the predetermined storage area according to the configuration information, where the sub-storage area is used to store the configuration information.
Optionally, the screening unit includes one of: the first screening module is used for acquiring a monitoring request, responding to the monitoring request, and screening out a historical task list in a preset time period before the generation time of the monitoring request according to the screening condition; and the second screening module is used for acquiring the monitoring request, and screening out the task list to be monitored according with the screening condition from the new task list when monitoring that the new task list is generated after the monitoring request is generated for the target project.
Optionally, the screening unit includes: the second determining module is used for determining the workload of each task list in the task lists to be monitored, counting to obtain the sum of the workloads of each task list, and determining the completion degree data of the task lists to be monitored according to the sum of the workloads of each task list and the completion degree of each task list; and the third determining module is used for acquiring all the completed data of the to-be-monitored task list and determining the completion trend data of the to-be-monitored task list according to all the completed data.
Optionally, the metric data includes: and target completion index data, accumulation completion index data and trend index data are completed.
Optionally, the update unit includes: the fourth determining module is used for determining a time period corresponding to the index data for generating the task list to be monitored; the generating module is used for generating a completion line and a trend line in the time period according to the index data; and the updating module is used for updating the completion line and the trend line into the progress monitoring graph of the target project.
According to another aspect of the embodiment of the present invention, there is provided a storage medium, where the storage medium is used to store a program, where the program, when executed by a processor, controls a device in which the storage medium is located to perform the method for monitoring a progress of a project according to any one of the above descriptions.
According to another aspect of the embodiment of the present invention, there is further provided a processor, where the processor is configured to execute a program, where the program executes the method for monitoring progress of a project according to any one of the above methods.
In the embodiment of the invention, the configuration information is acquired, wherein the configuration information is used for describing the screening condition of the task list to be monitored in the target project and the data field to be counted in the task list to be monitored; screening out the task list to be monitored which meets the screening condition from a preset storage area according to the configuration information, and determining index data of the task list to be monitored according to the data field to be counted; according to the project progress monitoring method, the project progress of the target project is updated according to the index data, the updated project progress is displayed, the purpose that the progress of the target project is updated based on the index data determined by the task list to be monitored and screened out according to the configuration information is achieved, the progress of the target project is obtained, the technical effect of simplifying progress monitoring of the target project is achieved, and the technical problem that the progress of the milestones in the project is low in reliability due to the fact that operation flows are complex in a mode of managing the progress of the milestones in the project in the related art is solved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
FIG. 1 is a flow diagram of a method of monitoring progress of a project in accordance with an embodiment of the present invention;
FIG. 2 is a schematic illustration of configuration information of a progress monitoring graph according to an embodiment of the invention;
FIG. 3 is a schematic diagram of a progress monitoring graph according to an embodiment of the invention;
FIG. 4 is an architecture diagram of a crontab timed task according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of a project progress monitoring apparatus according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
In accordance with an embodiment of the present invention, there is provided a method embodiment of a method of monitoring the progress of a project, it being noted that the steps illustrated in the flowchart of the drawings may be performed in a computer system such as a set of computer-executable instructions and that, although a logical order is illustrated in the flowchart, in some cases the steps illustrated or described may be performed in an order different than here.
Fig. 1 is a flowchart of a project progress monitoring method according to an embodiment of the present invention, and as shown in fig. 1, the project progress monitoring method includes the following steps:
step S102, configuration information is obtained, wherein the configuration information is used for describing the screening condition of the task list to be monitored in the target project and the data field to be counted in the task list to be monitored.
Optionally, the target project includes a task list to be monitored. The target project is monitored mainly based on the completion condition of the task list to be monitored.
The screening condition is mainly used for screening and obtaining the task list to be monitored based on a preset rule.
In an optional embodiment, before obtaining the configuration information, the method for monitoring the progress of the project may further include: creating a screening condition; wherein, creating the screening condition comprises: determining attribute information of a task list to be monitored in a target project, wherein the attribute information comprises: tracking labels of the task list to be monitored, workload type information of the task list to be monitored and completion degree information of the task list to be monitored; and creating a screening condition according to the attribute information.
It should be noted that, in the embodiment of the present invention, the configuration information needs to include a tracking tag of the task list to be monitored and a workload field for measuring the task list to be monitored.
And step S104, screening out the to-be-monitored task list meeting the screening condition from the preset storage area according to the configuration information, and determining index data of the to-be-monitored task list according to the to-be-counted data field.
Optionally, the data field to be counted is mainly used for indicating the completion degree of the task list to be monitored.
And step S106, updating the project progress of the target project according to the index data, and displaying the updated project progress.
As can be seen from the above, in the embodiment of the present invention, configuration information may be obtained, where the configuration information is used to describe the screening condition of the task list to be monitored in the target project and the data field to be counted in the task list to be monitored; then screening out the task list to be monitored which meets the screening condition from a preset storage area according to the configuration information, and determining index data of the task list to be monitored according to the data field to be counted; and the project progress of the target project is updated according to the index data, and the updated project progress is displayed, so that the purpose of updating the progress of the target project based on the index data determined by the to-be-monitored task list screened according to the configuration information to obtain the progress of the target project is achieved, and the technical effect of simplifying progress monitoring on the target project is achieved.
It should be noted that, because the to-be-monitored task list meeting the screening condition can be screened out from the predetermined storage area according to the preset screening condition for describing the to-be-monitored task list in the target project and the preset configuration information of the to-be-counted data field in the to-be-monitored task list, the index data of the to-be-monitored task list is determined according to the to-be-counted data field, the progress of the target project is updated according to the index data, and the updated project progress is displayed, compared with the prior art that the project progress monitoring is performed, the task list data needs to be manually input, the estimated workload and the completion amount in the task list are counted, the dependency on human factors is high, and the operation flow is very tedious and time-consuming. In the embodiment of the invention, the project management engineer can continuously observe the milestone progress of the target project in the computer in real time and the trend of the target project in a period of time in the future only by configuring the monitoring index, so that the complex operation in the prior art is avoided, the real-time performance and the intuition are high, and the working efficiency of the project management engineer is improved.
Therefore, the project progress monitoring method provided by the embodiment of the invention solves the technical problem that the reliability of the obtained milestone progress is lower due to the fact that the operation process is complicated in a mode of managing the progress of the milestone in the project in the related technology.
It should be noted that the target project is divided into a plurality of task phases, and the plurality of task phases correspond to different time nodes respectively. For example, the target item may be divided into a launch stage, a stable stage, and a target stage. Each time node corresponds to different expected completion numbers, and is used for counting the task completion degree at the stage so as to better monitor the target project.
In an optional embodiment, before screening out the task list to be monitored meeting the screening condition from the predetermined storage area according to the configuration information, the method for monitoring the progress of the project may further include: and creating a sub-storage area in the predetermined storage area, wherein the sub-storage area is used for storing the configuration information.
For example, tables may be newly created in the database for storing configuration information, i.e., configuration items of a progress monitoring graph for progress monitoring of the target project. The project management engineer enables this functionality before using the progress monitoring graph (i.e., the milestone progress monitoring graph), i.e., the tables may be created at any time based on the configuration information to reduce consumption of resources.
FIG. 2 is a schematic diagram of configuration information of a progress monitoring graph that may be used to turn on statistics of the progress monitoring graph (i.e., a milestone progress monitoring graph) by triggering an "enable" control, such as that shown in FIG. 2, in accordance with an embodiment of the present invention. Then, a 'statistical tracking label range' control can be triggered, and the tracking label of the task list needing to be counted can be configured; as shown in fig. 2, the "workload type" is provided with two fields, the "icon display name" indicates a legend name displayed on the progress monitoring chart, and the "corresponding workload field" indicates a workload field of the job ticket that needs to be counted. The completion degree of the background configuration task list can be jumped to by triggering the problem completion degree. In order to store the configuration items corresponding to the configuration information, several tables are required to be involved in the database to store the configuration information:
① statistics _ milestone _ project _ routers table (many-to-many table), records the target items to be counted and the corresponding tracking tags, as shown in table 1 below specifically:
TABLE 1
Wherein, the identifier of the target item project is recorded in table 1: project _ id, tracking tag identification that needs to be counted: tracker _ id.
The SQ L statement corresponding to the above information is as follows:
CREATE TABLE IF NOT EXISTS statistics_milestone_project_trackers(
id int NOT NULL AUTO_INCREMENT,
project_id int NOT NULL,
tracker_id int NOT NULL,
PRIMARY KEY(id),
KEY'index_project_id'(project_id),
KEY'index_tracker_id'(tracker_id)
);)
② statistics _ milestone _ jobs table, records workload types, as shown in table 2 specifically:
TABLE 2
Wherein, table 2 records the workload type name: name, identification of the target item where the workload type is located: project _ id, when associating with custom attribute, recording the id of custom attribute when recording the identifier of custom attribute, and when associating with fixed attribute, recording the name or identity of attribute.
Its corresponding SQ L statement is as follows:
CREATE TABLE IF NOT EXISTS statistics_milestone_workloads(
id int NOT NULL AUTO_INCREMENT,
name varchar(30)NOT NULL DEFAULT″,
project_id int NOT NULL,
custom _ field _ id varchar (30) NOT NU LL COMMENT 'record id or identity',
PRIMARY KEY(id),
KEY'index_project_id'(project_id),
KEY'index_custom_field_id'(custom_field_id)
)。
the corresponding program comprises the specific steps of reading all tracking labels and workload fields of a current project from a database by an ① server, serializing the data into json and returning the json to a browser end, analyzing the json data by a ② browser, rendering a configuration page (namely, displaying the configuration page), configuring the tracking labels and the workload types by a ③ user, clicking a [ save ] button shown in fig. 2, transmitting the data to the server end by the browser end, and storing the configuration data into a table of the database by a ④ server end.
Among them, the tracking tag in the embodiment of the present invention may include: planning requirements, requiring functions, developing bugs, operating bugs, autonomous tasks and the like, wherein the tracking tags are associated with the projects and have the tracking tags corresponding to the projects.
According to the above embodiment of the present invention, in step S104, the task list to be monitored that meets the screening condition is screened out from the predetermined storage area according to the configuration information, where the screening condition includes one of the following: acquiring a monitoring request, responding to the monitoring request, and screening out a historical task list in a preset time period before the generation time of the monitoring request according to a screening condition; and acquiring a monitoring request, and screening out the task list to be monitored according with the screening condition from the new task list when monitoring that the new task list is generated after the monitoring request is generated for the target project.
For example, at 00:10 points of each day, the program directly screens qualified task lists in the database according to the configuration, and then calculates the statistics of the previous day and stores the statistics in the database. If the progress monitoring graph is viewed in the daytime, the task list can be screened in real time.
According to the above embodiment of the present invention, in step S104, determining the index data of the task list to be monitored according to the data field to be counted includes: determining the workload of each task list in the task lists to be monitored, counting to obtain the sum of the workloads of each task list, and determining the completion degree data of the task lists to be monitored according to the sum of the workloads of each task list and the completion degree of each task list; and acquiring all the completed data of the task list to be monitored, and determining the completion trend data of the task list to be monitored according to all the completed data.
It should be noted here that the workload of each of the above-mentioned task lists is a preset target workload, that is, a total amount of tasks that need to be completed in the task list. In addition, the completion degree of each task list is obtained based on the ratio of the current completion amount of each task list to the workload of each task list; the completion degree data of the task list to be monitored is determined based on the sum of the workload of each task list and the completion degree of each task list.
In an alternative embodiment, the metric data includes: and target completion index data, accumulation completion index data and trend index data are completed.
According to the above embodiment of the present invention, in step S106, updating the project progress of the target project according to the index data includes: determining a time period corresponding to index data for generating a task list to be monitored; generating a completion line and a trend line within a time period according to the index data; and updating the completion line and the trend line into a progress monitoring graph of the target project.
Fig. 3 is a schematic diagram of a progress monitoring chart according to an embodiment of the present invention, as shown in fig. 3, data of different milestones can be selected and viewed through a drop-down selection box at the lower left corner of a page, and the same milestone may have multiple workload indicators according to configuration, as shown in fig. 3, there are two indicators: client end requirement and server end requirement, each index divide into three lines: look ahead, finish and trend lines. When the milestone progress monitoring graph is used, the task list is filled in with a field of 'required milestone' and a field of workload to be counted.
Since the daily progress of the milestone needs to be monitored, the abscissa of the progress chart is the date, and several tables are also involved in the database to store snapshot data of daily statistics, which is specifically designed as follows:
① statistics _ milestone _ history _ data table, recording milestone statistics history as shown in table 3:
TABLE 3
The item identifiers, namely project _ id, milestone identifiers, miletone _ id, and statistical dates, namely static _ date, are recorded in table 3, and the corresponding SQ L statements are as follows:
CREATE TABLE IF NOT EXISTS statistics_milestone_history(
id int NOT NULL AUTO_INCREMENT,
project_id int NOT NULL,
milestone_id int NOT NULL,
statistics_date date NOT NULL,
KEY'index_project_id'(project_id),
KEY'index_milestone_id'(milestone_id),PRIMARY KEY(id)
)。
② statistics _ milestone _ history _ data table, record statistical history data, as shown in Table 4:
TABLE 4
Table 4 records whether the self-defined attribute or the fixed attribute is property, the identifier of the self-defined attribute or the fixed attribute is prop _ key, the name of the self-defined attribute, the data is value, the identifier of the milestone statistical history is SQ L statement corresponding to static _ milestone _ history _ id. as follows:
CREATE TABLE IF NOT EXISTS statistics_milestone_history_datas(
id int NOT NULL AUTO_INCREMENT,
property varchar(30)NOT NULL DEFAULT″,
prop_key varchar(30)NOT NULL DEFAULT″,
name varchar(30)NOT NULL DEFAULT″,
value varchar(60),
statistics_milestone_history_id int NOT NULL,
PRIMARY KEY(id),
KEY
'index_statistics_milestone_history_id'(statistics_milestone_history_id)
since the snapshot data is recorded, a timing task is required to trigger the calculation process and write the calculation result into the database. Fig. 4 is an architecture diagram of a crontab timing task according to an embodiment of the present invention, as shown in fig. 4, the specific implementation process is as follows: crontab is used as a timed task core and sends out an http request at 00:10 every day, and each server (for example, the servers H39 and G37 for screening the task list in FIG. 4) receives the http request. And the server screens out the matched task list according to the configured project, milestone and tracking label. Then, according to the workload field configured by the administrator, the specific indexes of the task lists are calculated, and finally, the result is stored in a database (statistics _ history _ data table). Namely, the contib is used as a timing task core, a server for screening the obtained task list is triggered at a timing mode, and then the server is used for counting and screening the task list meeting the requirements.
Screening out the task lists meeting the conditions according to the configuration, and adding the workloads of the task lists to obtain the estimated workload, namely using the estimated workload as a vertical coordinate of an estimated line; the workload of the task list is multiplied by the completion degree and then the sum is added to obtain the completion quantity which is taken as a vertical coordinate of the completion line; the trend line is calculated by a specific method according to all the completion quantities of the history.
Since project management engineers may create a milestone-wide order on the current day, real-time statistics of the current day's order are needed. The statistical method and the calculation process are the same as those described above, but the statistical result is not stored in the database, because the trigger time of the timing task is not reached when the data is viewed in real time, the data of the current day cannot be stored in the database as a snapshot.
Then, the snapshot data stored in the database is queried, and by combining the obtained current-day progress data, a line data of a certain field in fig. 3 can be obtained: a series of statistics _ date in the statistics _ milestone _ history _ data table is spliced with the date of the day to obtain a time sequence of an estimated line as an abscissa, and a series of related values in the statistics _ milestone _ history _ data table is spliced with the numerical value of the day to obtain a finished quantity sequence as an ordinate. The trend line is calculated by the least square method, and the coordinates (x, y) of the historical data are taken as the sample points) The specific calculation method is as follows: (x) ax + b, where the slope a and intercept b of the straight line can be obtained by the following equations:specifically, the abscissa of the sample point is time, the ordinate is a value of the completion amount, and the slope and the intercept of the trend line can be calculated by substituting the sequence, and are shown in the figure later. And returning the data to the browser, and drawing a curve graph by using an Echarts frame after the browser receives the data to show the progress and the trend of the milestones.
By the project progress monitoring method provided by the embodiment of the invention, historical snapshot data are quickly calculated and stored without human intervention, and if the historical snapshot data are manually calculated on a task list everywhere every day, the process is very complicated. And the timing task time is selected to be 00:10, the number of people is few, the server has more spare resources, and the data can be accurately calculated and snapshot is generated when the previous day passes. By the aid of the method, historical data and data of the current day can be read to draw a monitoring graph, progress of milestones can be clearly shown in the graph, progress can be known for a period of time in the future by observing the trend lines, and whether the current working strategy is reasonable or not can be determined.
According to another aspect of the embodiment of the present invention, there is also provided a project progress monitoring apparatus, and fig. 5 is a schematic diagram of the project progress monitoring apparatus according to the embodiment of the present invention, as shown in fig. 5. The project progress monitoring device comprises: an acquisition unit 51, a filtering unit 53 and an updating unit 55. The monitoring device for the progress of the project will be described in detail below.
The obtaining unit 51 is configured to obtain configuration information, where the configuration information is used to describe a screening condition of a task list to be monitored in a target project and a data field to be counted in the task list to be monitored.
And the screening unit 53 is configured to screen out the to-be-monitored task list meeting the screening condition from the predetermined storage area according to the configuration information, and determine index data of the to-be-monitored task list according to the to-be-counted data field.
And the updating unit 55 is configured to update the project progress of the target project according to the index data, and display the updated project progress.
It should be noted here that the acquiring unit 51, the screening unit 53, and the updating unit 55 correspond to steps S102 to S106 in embodiment 1, and the units are the same as the examples and application scenarios realized by the corresponding steps, but are not limited to the disclosure in embodiment 1. It should be noted that the above-described elements as part of an apparatus may be implemented in a computer system, such as a set of computer-executable instructions.
As can be seen from the above, in the above embodiment of the present application, the obtaining unit may be used to obtain the configuration information, where the configuration information is used to describe the screening condition of the task list to be monitored in the target project and the data field to be counted in the task list to be monitored; then, screening the to-be-monitored task list meeting the screening condition from the preset storage area by using a screening unit according to the configuration information, and determining index data of the to-be-monitored task list according to the to-be-counted data field; and updating the project progress of the target project according to the index data by using the updating unit, and displaying the updated project progress. The project progress monitoring device provided by the embodiment of the invention realizes the purpose of updating the progress of the target project based on the index data determined by the task list to be monitored screened out according to the configuration information so as to obtain the progress of the target project, achieves the technical effect of simplifying progress monitoring of the target project, and further solves the technical problem that the progress of the milestones in the project is relatively complicated in operation flow in a mode of managing the progress of the milestones in the related art, so that the obtained progress of the milestones is relatively low in reliability.
In an alternative embodiment, the monitoring device of project progress further comprises: a first creating unit configured to create a filtering condition before acquiring the configuration information; wherein, the first creating unit includes: the first determining module is used for determining attribute information of a task list to be monitored in a target project, wherein the attribute information comprises: tracking labels of the task list to be monitored, workload type information of the task list to be monitored and completion degree information of the task list to be monitored; and the creating module is used for creating the screening condition according to the attribute information.
In an optional embodiment, the target project is divided into a plurality of task phases, and the plurality of task phases respectively correspond to different time nodes.
In an alternative embodiment, the monitoring device of project progress further comprises: and the second creating unit is used for creating a sub-storage area in the preset storage area before screening out the to-be-monitored task list meeting the screening condition from the preset storage area according to the configuration information, wherein the sub-storage area is used for storing the configuration information.
In an alternative embodiment, the screening unit comprises one of: the first screening module is used for acquiring the monitoring request, responding to the monitoring request, and screening the historical task list in a preset time period before the generation time of the monitoring request according to screening conditions; and the second screening module is used for acquiring the monitoring request, and screening out the task list to be monitored according with the screening condition from the new task list when monitoring that the new task list is generated after the monitoring request is generated for the target project.
In an alternative embodiment, the screening unit comprises: the second determining module is used for determining the workload of each task list in the task lists to be monitored, counting to obtain the sum of the workloads of each task list, and determining the completion degree data of the task lists to be monitored according to the sum of the workloads of each task list and the completion degree of each task list; and the third determining module is used for acquiring all the completed data of the task list to be monitored and determining the completion trend data of the task list to be monitored according to all the completed data.
In an alternative embodiment, the metric data includes: and target completion index data, accumulation completion index data and trend index data are completed.
In an alternative embodiment, the update unit includes: the fourth determining module is used for determining a time period corresponding to the index data for generating the task list to be monitored; the generating module is used for generating a completion line and a trend line in a time period according to the index data; and the updating module is used for updating the completion line and the trend line into the progress monitoring graph of the target project.
According to another aspect of the embodiment of the present invention, there is provided a storage medium for storing a program, where the program, when executed by a processor, controls a device in which the storage medium is located to perform the method for monitoring the progress of the project.
According to another aspect of the embodiment of the present invention, there is provided a processor, configured to execute a program, where the program executes a method for monitoring progress of a project according to any one of the above methods.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed technology can be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units may be a logical division, and in actual implementation, there may be another division, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.
The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.
Claims (11)
1. A project progress monitoring method is characterized by comprising the following steps:
acquiring configuration information, wherein the configuration information is used for describing a screening condition of a task list to be monitored in a target project and a data field to be counted in the task list to be monitored;
screening out the task list to be monitored which meets the screening condition from a preset storage area according to the configuration information, and determining index data of the task list to be monitored according to the data field to be counted;
and updating the project progress of the target project according to the index data, and displaying the updated project progress.
2. The method of claim 1, wherein prior to said obtaining configuration information, the method further comprises: creating the screening condition;
wherein the creating the screening condition comprises:
determining attribute information of a task list to be monitored in the target project, wherein the attribute information comprises: the tracking label of the task list to be monitored, the workload type information of the task list to be monitored and the completion degree information of the task list to be monitored;
and creating the screening condition according to the attribute information.
3. The method of claim 2, wherein the target project is divided into a plurality of task phases, and the plurality of task phases correspond to different time nodes respectively.
4. The method according to claim 3, wherein before the screening out the task list to be monitored meeting the screening condition from the predetermined storage area according to the configuration information, the method further comprises:
and creating a sub-storage area in the predetermined storage area, wherein the sub-storage area is used for storing the configuration information.
5. The method according to claim 1, wherein the screening out the task list to be monitored meeting the screening condition from the predetermined storage area according to the configuration information comprises one of the following steps:
acquiring a monitoring request, responding to the monitoring request, and screening out a historical task list in a preset time period before the generation time of the monitoring request according to the screening condition;
and acquiring a monitoring request, and screening out a task list to be monitored which meets the condition from the new task list according to the screening condition when monitoring that the new task list is generated after the monitoring request is generated for the target project.
6. The method according to claim 1, wherein the determining the index data of the task list to be monitored according to the data field to be counted comprises:
determining the workload of each task list in the task lists to be monitored, counting to obtain the sum of the workloads of each task list, and determining the completion degree data of the task lists to be monitored according to the sum of the workloads of each task list and the completion degree of each task list;
and acquiring all the completed data of the to-be-monitored task list, and determining the completion trend data of the to-be-monitored task list according to all the completed data.
7. The method of claim 6, wherein the metric data comprises: and target completion index data, accumulation completion index data and trend index data are completed.
8. The method of claim 7, wherein the updating the project progress of the target project according to the metric data comprises:
determining a time period corresponding to the index data for generating the task list to be monitored;
generating a completion line and a trend line in the time period according to the index data;
and updating the completion line and the trend line into a progress monitoring graph of the target project.
9. An apparatus for monitoring progress of a project, comprising:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring configuration information, and the configuration information is used for describing the screening condition of a task list to be monitored in a target project and a data field to be counted in the task list to be monitored;
the screening unit is used for screening the task list to be monitored which meets the screening condition from a preset storage area according to the configuration information and determining index data of the task list to be monitored according to the data field to be counted;
and the updating unit is used for updating the project progress of the target project according to the index data and displaying the updated project progress.
10. A storage medium storing a program, wherein the program, when executed by a processor, controls an apparatus in which the storage medium is located to perform the project progress monitoring method according to any one of claims 1 to 8.
11. A processor adapted to run a program, wherein the program when running performs the method of monitoring progress of a project according to any one of claims 1 to 8.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010192445.XA CN111400332B (en) | 2020-03-18 | 2020-03-18 | Project progress monitoring method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010192445.XA CN111400332B (en) | 2020-03-18 | 2020-03-18 | Project progress monitoring method and device |
Publications (2)
Publication Number | Publication Date |
---|---|
CN111400332A true CN111400332A (en) | 2020-07-10 |
CN111400332B CN111400332B (en) | 2023-10-31 |
Family
ID=71436489
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202010192445.XA Active CN111400332B (en) | 2020-03-18 | 2020-03-18 | Project progress monitoring method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111400332B (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113535353A (en) * | 2021-06-29 | 2021-10-22 | 未鲲(上海)科技服务有限公司 | Timing task scheduling method and device and computer equipment |
CN116502877A (en) * | 2023-06-29 | 2023-07-28 | 北京康特瑞科统计科技有限责任公司 | Project progress monitoring method and device, electronic equipment and readable storage medium |
CN116560948A (en) * | 2023-07-07 | 2023-08-08 | 建信金融科技有限责任公司 | Data processing method and device |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104636485A (en) * | 2015-02-16 | 2015-05-20 | 广东省公安厅 | Multi-data-source data association method and device based on data monitoring |
CN104881289A (en) * | 2015-06-02 | 2015-09-02 | 华北计算技术研究所 | GJB5000A-based software development process monitoring method and system |
CN106878064A (en) * | 2017-01-16 | 2017-06-20 | 腾讯科技(深圳)有限公司 | Data monitoring method and device |
CN106931596A (en) * | 2017-03-13 | 2017-07-07 | 珠海格力电器股份有限公司 | Project monitor and control method and system |
US20180114178A1 (en) * | 2016-10-24 | 2018-04-26 | Oracle International Corporation | Display control system and method for controlling a display of project management objects |
CN108428114A (en) * | 2018-03-20 | 2018-08-21 | 网易(杭州)网络有限公司 | Information processing method and device, storage medium, the electronic device of project |
CN109634805A (en) * | 2018-11-19 | 2019-04-16 | 平安科技(深圳)有限公司 | Monitoring data processing method, device, electronic equipment and storage medium |
-
2020
- 2020-03-18 CN CN202010192445.XA patent/CN111400332B/en active Active
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104636485A (en) * | 2015-02-16 | 2015-05-20 | 广东省公安厅 | Multi-data-source data association method and device based on data monitoring |
CN104881289A (en) * | 2015-06-02 | 2015-09-02 | 华北计算技术研究所 | GJB5000A-based software development process monitoring method and system |
US20180114178A1 (en) * | 2016-10-24 | 2018-04-26 | Oracle International Corporation | Display control system and method for controlling a display of project management objects |
CN106878064A (en) * | 2017-01-16 | 2017-06-20 | 腾讯科技(深圳)有限公司 | Data monitoring method and device |
CN106931596A (en) * | 2017-03-13 | 2017-07-07 | 珠海格力电器股份有限公司 | Project monitor and control method and system |
CN108428114A (en) * | 2018-03-20 | 2018-08-21 | 网易(杭州)网络有限公司 | Information processing method and device, storage medium, the electronic device of project |
CN109634805A (en) * | 2018-11-19 | 2019-04-16 | 平安科技(深圳)有限公司 | Monitoring data processing method, device, electronic equipment and storage medium |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113535353A (en) * | 2021-06-29 | 2021-10-22 | 未鲲(上海)科技服务有限公司 | Timing task scheduling method and device and computer equipment |
CN113535353B (en) * | 2021-06-29 | 2022-05-20 | 未鲲(上海)科技服务有限公司 | Timing task scheduling method and device and computer equipment |
CN116502877A (en) * | 2023-06-29 | 2023-07-28 | 北京康特瑞科统计科技有限责任公司 | Project progress monitoring method and device, electronic equipment and readable storage medium |
CN116560948A (en) * | 2023-07-07 | 2023-08-08 | 建信金融科技有限责任公司 | Data processing method and device |
Also Published As
Publication number | Publication date |
---|---|
CN111400332B (en) | 2023-10-31 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
Ahmed et al. | Multi-dimensional building performance data management for continuous commissioning | |
CN107391538B (en) | Click data acquisition, processing and display method, device, equipment and storage medium | |
US6360188B1 (en) | Time-based modeling | |
US8719066B2 (en) | Systems and methods for capturing, managing, sharing, and visualising asset information of an organization | |
CN111400332A (en) | Project progress monitoring method and device | |
US9727836B2 (en) | Systems and methods for generating data visualization dashboards | |
US10452625B2 (en) | Data lineage analysis | |
US11455590B2 (en) | Service monitoring adaptation for maintenance downtime | |
US10380528B2 (en) | Interactive approach for managing risk and transparency | |
US20060112109A1 (en) | Adaptive data warehouse meta model | |
WO2015065366A1 (en) | Process model catalog | |
CN114730313B (en) | Method and user interface for visual analysis of data visualization with multiple line calculations | |
US20180365608A1 (en) | Quantitive time estimation systems and methods of project management systems | |
JP2010146306A (en) | Configuration monitoring system and configuration monitoring method | |
US9727663B2 (en) | Data store query prediction | |
US8707262B2 (en) | Code scoring | |
US20140279333A1 (en) | Contract automation apparatus, method, and computer program product | |
US20110264487A1 (en) | Embedding Planning Components In Transactional Applications | |
CN108228462A (en) | A kind of parameter test method and device of OLTP systems | |
CN113835965B (en) | Parameter track mark-keeping method and device | |
CN111158827A (en) | Method and device for graphic configuration tool correlation calculation value information | |
CN116302867A (en) | Behavior data analysis method, apparatus, computer device, medium, and program product | |
CN114997813A (en) | Flow chart generation method, device, equipment and storage medium | |
EP1624403A1 (en) | System for querying databases | |
US9824400B2 (en) | Cost item life cycle viewer with configurable document traversal options |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |