A project tracking Gantt chart generation method, system, product, and medium

Abstract

The present invention discloses a project tracking Gantt chart generation method and system, product, and medium, which relate to the field of big data technology, in order to solve the problem that a periodic report file cannot be converted into a Gantt chart. The method includes obtaining project management data corresponding to a target project number; extracting keywords of each file in a periodic report file; configuring a project category and a project label for each file based on the keywords to obtain a first file set, extracting files in the first file set with a project label number greater than 1 to obtain a first target file; determining a second target file and a third target file in sequence; reconfiguring the first project label based on the first project label, the second project label, and the third project label to obtain a fourth target file; and generating a target project tracking Gantt chart based on the fourth target file. The project tracking Gantt chart generation method provided by the present invention can classify keywords containing two project categories in a file to generate a Gantt chart.

Description

Technical Field

[0001] The present invention relates to the field of big data technology, and in particular to a project tracking Gantt chart generation method, system, product and medium. Background Art

[0002] Monitoring projects is a key part of project management. It involves continuous tracking, evaluation and adjustment of the project implementation process to ensure that the project plan is carried out and the expected goals are achieved. The main means of monitoring projects is regular reporting, such as weekly and monthly reports. Converting data into a Gantt chart can more intuitively display the progress and arrangement of the project, which is more conducive to project monitoring. However, since periodic report files such as weekly and monthly reports are manually written, keywords corresponding to two project categories may appear in one file, making it impossible to convert such periodic report files into Gantt charts.

[0003] Therefore, there is an urgent need for a project tracking Gantt chart generation method, system, product, and medium. Summary of the invention

[0004] The purpose of the present invention is to provide a project tracking Gantt chart generation method and system, product, and medium, which are used to solve the problem that the project category of the file cannot be determined because the file contains keywords corresponding to two project categories, resulting in the inability to convert a periodic report file into a Gantt chart.

[0005] In order to achieve the above object, the present invention provides the following technical solutions:

[0006] In a first aspect, the present invention provides a method for generating a project tracking Gantt chart, comprising:

[0007] Acquire project management data corresponding to the target project number; the project management data includes a periodic report file set and a submission time corresponding to each file in the periodic report file set; the periodic report file set is a file set sorted in ascending order of submission time;

[0008] Extracting keywords from each file in the periodic report file set;

[0009] Based on the keyword, configure a project category and a project label for each file in the periodic report file set to obtain a first file set, wherein the project category and the project label correspond one to one;

[0010] Extract the files in the first file set whose number of project tags is greater than 1 to obtain a first target file;

[0011] Determine in sequence the second target file and the third target file corresponding to each of the first target files; the second target file is a file adjacent to the first target file, and the third target file is a file within a preset range from the first target file;

[0012] reconfiguring the first project tag based on the first project tag of the first target file, the second project tag of the second target file, and the third project tag of the third target file, and determining the first target file with the reconfigured first project tag as the fourth target file;

[0013] A target project tracking Gantt chart is generated based on the fourth target file and the files in the first file set except the first target file.

[0014] Optionally, the reconfiguring the first project tag based on the first project tag of the first target file, the second project tag of the second target file, and the third project tag of the third target file, and determining the first target file with the reconfigured first project tag as the fourth target file comprises:

[0015] Determining whether the second item tag contains the same tag as the first item tag;

[0016] If the second project tag includes the same tag as the first project tag, configuring the same project tag as the first project tag in the second project tag as a new first project tag, and determining the first target file with the reconfigured first project tag as the fourth target file;

[0017] If the second project tag does not include the same tag as the first project tag, determining whether the third project tag includes the same tag as the first project tag;

[0018] If the third project tag includes a tag identical to the first project tag, the tag identical to the first project tag in the third project tag is configured as a new first project tag, and the first target file with the reconfigured first project tag is determined as a fourth target file;

[0019] If the third project tag does not contain the same tag as the first project tag, the first project tag is removed, and the first target file without the first project tag is determined as the fourth target file.

[0020] Optionally, if the second project tag includes a tag identical to the first project tag, configuring the second project tag and the project tag identical to the first project tag as a new first project tag, and determining the first target file of the reconfigured first project tag as the fourth target file includes:

[0021] Determine whether the first project tag is completely identical to the second project tag; if at least one of the second project tags is completely identical to the first project tag, the first project tag remains unchanged, and the first target file is determined as the fourth target file;

[0022] If there are different tags between the first project tag and the second project tag, determining whether each of the second project tags has a tag that is the same as the first project tag;

[0023] If not, determining the tag in the second project tag that is identical to the first project tag as the first identical tag, configuring the first identical tag as a new first project tag, and determining the first target file with the reconfigured first project tag as the fourth target file;

[0024] If yes, determine whether the second identical tag and the third identical tag are identical; the second identical tag is a tag that is identical to the first item tag and the second item tag, and the third identical tag is another tag that is identical to the first item tag and the second item tag;

[0025] If the second identical tag is different from the third identical tag;

[0026] Then determine a first interval time between the submission time corresponding to the second identical tag and the submission time corresponding to the first project tag; determine a second interval time between the submission time corresponding to the third identical tag and the submission time corresponding to the first project tag;

[0027] The label corresponding to the smaller interval between the first interval and the second interval is configured as a new first project label, and the first target file with the reconfigured first project label is determined as a fourth target file.

[0028] Optionally, generating a target project tracking Gantt chart based on the fourth target file and files in the first file set other than the first target file includes:

[0029] Arrange the fourth target file and the files in the first file set except the first target file in ascending order of submission time to generate a second file set;

[0030] Merging files with the same project tag in the second file set to obtain a plurality of fifth target files;

[0031] Determine the start time, end time, fifth item label and fifth item category of the fifth target file;

[0032] Determine the target area corresponding to the fifth project category described in the initial project tracking Gantt chart;

[0033] Marking a time block corresponding to the start time to the end time in the target area as a fourth item label;

[0034] Complete the marking of the target areas corresponding to all fifth target files to obtain the initial project tracking Gantt chart;

[0035] The initial project tracking Gantt chart is optimized to obtain a target project tracking Gantt chart.

[0036] Optionally, the target project tracking Gantt chart includes a plurality of progress bars, wherein the progress bars are bar-shaped graphics composed of continuous time blocks; the time blocks are small squares marked with the project label per unit time; and the optimizing process of the initial project tracking Gantt chart to obtain the target project tracking Gantt chart includes:

[0037] Delete the progress bar whose time length is less than the first time threshold in the target project tracking Gantt chart;

[0038] Determine the third interval time between adjacent progress bars in each project category;

[0039] Determine the first progress bar, the second progress bar and the target time block whose third interval time is less than the preset interval time threshold; the target time block is the blank time block between the first progress bar and the second progress bar;

[0040] The project labels of the first progress bar and the second progress bar are marked in the target time block to obtain a target project tracking Gantt chart.

[0041] Optionally, the number of the initial project tracking Gantt charts is greater than 1; and the optimizing the initial project tracking Gantt charts to obtain the target project tracking Gantt charts includes:

[0042] Arrange the total project time of multiple initial project tracking Gantt charts in ascending order to obtain a time sorting group;

[0043] Divide the total time of two adjacent items in the time sorting group whose difference is greater than a preset amplitude threshold into two different intervals, divide the total time of two adjacent items whose difference is less than the preset amplitude threshold into the same interval, and determine all the intervals obtained by the division as multiple fault intervals;

[0044] Determine whether a first time range of a first fault interval is within a preset time range; the first fault interval is a fault interval with the largest number of total project time among the multiple fault intervals;

[0045] If the first time range is within the preset time range, then determining the average value of the total project time in the first fault interval as the target project total time of the target project tracking Gantt chart;

[0046] If the first time range is not within the preset time range, determining whether the second time range of the second fault interval is within the preset time range; the second fault interval is the fault interval with the largest number of total project time among the multiple fault intervals except the first fault interval;

[0047] If the second time range is not within the preset time range, lowering the preset range until the second time range of the second fault interval is within the preset time range;

[0048] If the second time range is within the preset time range, determining whether the total time of the project in the first fault interval is greater than the total time of the project in the second fault interval by a preset percentage;

[0049] If not, the average value of the total project time in the second fault interval is determined as the target total project time of the target project tracking Gantt chart;

[0050] If so, the average of the total project time in the first fault interval is determined as the target project total time of the target project tracking Gantt chart;

[0051] Based on the total time of the target project, a target project tracking Gantt chart is generated.

[0052] Optionally, the optimizing the initial project tracking Gantt chart further includes:

[0053] Determine whether the initial project tracking Gantt chart includes a target progress bar with a time length less than a second time threshold; the second time threshold is greater than the first time threshold;

[0054] If included, determining whether the project tag of the target adjacent file of the sixth target file is removed; the sixth target file is the file corresponding to each time point of the target progress bar;

[0055] If yes, the project tag of the sixth target file is determined as the target project tag of the target adjacent file, and the initial project tracking Gantt chart is regenerated.

[0056] Compared with the prior art, the project tracking Gantt chart generation method provided by the present invention has the following beneficial effects: by acquiring the project management data corresponding to the target project number; extracting the keywords of each file in the periodic report file set; configuring the project category and project label for each file in the periodic report file set based on the keywords to obtain a first file set, extracting the files in the first file set whose project label quantity is greater than 1 to obtain a first target file; sequentially determining the second target file and the third target file corresponding to each first target file; reconfiguring the first project label based on the first project label of the first target file, the second project label of the second target file, and the third project label of the third target file, and determining the first target file with the reconfigured first project label as the fourth target file; and generating a target project tracking Gantt chart based on the fourth target file and the files in the first file set except the first target file. Through the above method, periodic report files such as weekly reports and monthly reports can be automatically converted into Gantt charts. Periodic report files can be used to regularly understand the progress of the project. Converting periodic report files into Gantt charts can intuitively and clearly display the project progress, making it easier to understand the progress of the project over time. In addition, by reconfiguring the first project label based on the project labels of files adjacent to the first target file and separated by a preset range, the project category classification of the first target files corresponding to the two project categories can be made more accurate.

[0057] In a second aspect, the present invention further provides a project tracking Gantt chart generation system, comprising:

[0058] A project management data acquisition module, used to acquire project management data corresponding to a target project number; the project management data includes a periodic report file set and a submission time corresponding to each file in the periodic report file set; the periodic report file set is a file set sorted in ascending order of submission time;

[0059] A keyword extraction module, used to extract keywords from each file in the periodic report file set;

[0060] A project category and project label configuration module, configured to configure a project category and a project label for each file in the periodic report file set based on the keyword to obtain a first file set, wherein the project category and the project label correspond one to one;

[0061] A first target file determination module, used for extracting files in the first file set whose number of project tags is greater than 1, to obtain a first target file;

[0062] A second target file determination module, used to sequentially determine a second target file and a third target file corresponding to each of the first target files; the second target file is a file adjacent to the first target file, and the third target file is a file within a preset range from the first target file;

[0063] A first project label updating module, configured to reconfigure the first project label based on the first project label of the first target file, the second project label of the second target file, and the third project label of the third target file, and determine the first target file with the reconfigured first project label as the fourth target file;

[0064] A project tracking Gantt chart generating module is used to generate a target project tracking Gantt chart based on the fourth target file and the files in the first file set except the first target file.

[0065] In a third aspect, the present invention further provides a project tracking Gantt chart generation product, comprising:

[0066] A communication unit / communication interface, used to obtain project management data corresponding to the target project number; the project management data includes a periodic report file set and a submission time corresponding to each file in the periodic report file set; the periodic report file set is a file set sorted in ascending order of submission time;

[0067] A processing unit / processor, configured to extract keywords from each file in the periodic report file set;

[0068] Based on the keyword, configure a project category and a project label for each file in the periodic report file set to obtain a first file set, wherein the project category and the project label correspond one to one;

[0069] Extract the files in the first file set whose number of project tags is greater than 1 to obtain a first target file;

[0070] Determine in sequence the second target file and the third target file corresponding to each of the first target files; the second target file is a file adjacent to the first target file, and the third target file is a file within a preset range from the first target file;

[0071] reconfiguring the first project tag based on the first project tag of the first target file, the second project tag of the second target file, and the third project tag of the third target file, and determining the first target file with the reconfigured first project tag as the fourth target file;

[0072] A target project tracking Gantt chart is generated based on the fourth target file and the files in the first file set except the first target file.

[0073] In a fourth aspect, the present invention further provides a computer-readable storage medium, characterized in that instructions are stored in the computer-readable storage medium, and when the instructions are executed, the method for generating a project tracking Gantt chart is implemented.

[0074] The technical effects achieved by the system-type solutions provided in the second aspect, the product-type solutions provided in the third aspect, and the computer-readable storage medium solutions provided in the fourth aspect are the same as those of the method-type solutions provided in the first aspect, and will not be repeated here. BRIEF DESCRIPTION OF THE DRAWINGS

[0075] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of the present invention. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings:

[0076] Figure 1 A flowchart of a project tracking Gantt chart generation method provided by the present invention;

[0077] Figure 2 A schematic diagram of a Gantt chart of a project plan provided by the present invention;

[0078] Figure 3 A schematic diagram of a project tracking Gantt chart provided by the present invention;

[0079] Figure 4 A schematic diagram of the Gantt chart of the combined project schedule provided by the present invention;

[0080] Figure 5 A structural schematic diagram of a project tracking Gantt chart generation system provided by the present invention;

[0081] Figure 6 A structural schematic diagram of a project tracking Gantt chart generation product provided by the present invention. DETAILED DESCRIPTION

[0082] In order to clearly describe the technical solutions of the embodiments of the present invention, in the embodiments of the present invention, words such as "first" and "second" are used to distinguish the same items or similar items with basically the same functions and effects. For example, the first threshold and the second threshold are only used to distinguish different thresholds, and their order is not limited. Those skilled in the art can understand that words such as "first" and "second" do not limit the quantity and execution order, and words such as "first" and "second" do not necessarily limit them to be different.

[0083] It should be noted that, in the present invention, words such as "exemplary" or "for example" are used to indicate examples, illustrations or descriptions. Any embodiment or design described as "exemplary" or "for example" in the present invention should not be interpreted as being more preferred or more advantageous than other embodiments or designs. Specifically, the use of words such as "exemplary" or "for example" is intended to present related concepts in a specific way.

[0084] In the present invention, "at least one" means one or more, and "plurality" means two or more. "And / or" describes the association relationship of associated objects, indicating that three relationships may exist. For example, A and / or B can mean: A exists alone, A and B exist at the same time, and B exists alone, where A and B can be singular or plural. The character " / " generally indicates that the objects associated before and after are in an "or" relationship. "At least one of the following" or similar expressions refers to any combination of these items, including any combination of single or plural items. For example, at least one of a, b or c can mean: a, b, c, the combination of a and b, the combination of a and c, the combination of b and c, or the combination of a, b and c, where a, b, c can be single or multiple.

[0085] When monitoring a project, the most important means is regular reporting, such as weekly reports, monthly reports, etc. The current Gantt chart cannot be generated directly from these reports.

[0086] To solve the above problems, the present invention provides a project tracking Gantt chart generation method and system, product, and medium, which can generate a Gantt chart based on weekly and monthly reports, and correct a file when it is configured with two or more keywords for project classification. The following is an explanation with reference to the accompanying drawings.

[0087] Figure 1 A flowchart of a project tracking Gantt chart generation method provided by the present invention, such as Figure 1 As shown, a project tracking Gantt chart generation method includes the following steps:

[0088] Step 110: Obtain project management data corresponding to the target project number;

[0089] The project management data includes a periodic report file set and the submission time corresponding to each file in the periodic report file set; the periodic report file set is a collection of periodic report files sorted from small to large according to submission time, and the periodic report files are files for fixed-time reporting such as weekly and monthly reports.

[0090] As an optional method, the database pre-stores project plan Gantt charts corresponding to each project number, and the project management data can also include a project plan Gantt chart corresponding to the target project number. The project category of the project tracking Gantt chart to be generated is the same as the project category of the project plan Gantt chart.

[0091] For example, Figure 2 and Figure 3As shown, the project categories of the project plan Gantt chart include project start-up, project planning, project implementation and project completion. When extracting keywords of each file in the periodic report file set, keywords corresponding to the project categories of the project plan Gantt chart are extracted. The project category of each file is configured to be the same as the project category of the project plan Gantt chart, that is, the project categories of the finally generated project tracking Gantt chart also include project start-up, project planning, project implementation and project completion.

[0092] Specifically, step 110 may include: first obtaining a collection of all weekly reports within a year and a target project number;

[0093] Extract the files with the target project number from the above collection to obtain a periodic report file set.

[0094] Step 120: extracting keywords from each file in the periodic report file set;

[0095] For example, the keywords corresponding to project launch may be: project objectives, project launch authorization, project scope, project participants and feasibility analysis; the keywords corresponding to project plan may be: scope of work, work breakdown, schedule, personnel arrangement and estimated project costs, etc.; the keywords corresponding to project implementation may be: preparation of materials, design drawings, process route, production arrangement and process testing, etc.; the keywords corresponding to project completion may be: sample self-testing, third-party testing, executed budget, sales statistics, intellectual property achievements, project evaluation and results handover, etc.

[0096] Step 130: configuring a project category and a project label for each file in the periodic report file set based on the keyword to obtain a first file set;

[0097] The project categories and the project labels correspond one to one; the project categories in the periodic report file set are the same as the project categories in the project plan Gantt chart.

[0098] Exemplarily, the item label may be the color of the mark, such as Figure 3 As shown, the project categories correspond to the project labels one by one, that is, different project categories correspond to different project labels, so the progress bar of the project category is marked with different colors; the progress bar of each project category has a different color. The above is just an example, and the project label is not specifically limited. The project label can also be letters, numbers and other symbols.

[0099] The first file set obtained above can be divided into two cases: the first case is that the number of project tags of all files in the first file set is 1, in which case a project tracking Gantt chart is directly generated based on the first file set; the second case is that the first file set contains files with a number of project tags greater than 1, in which case step 140 is executed.

[0100] Step 140: extracting files in the first file set where the number of project tags is greater than 1, to obtain a first target file;

[0101] Because daily and weekly reports are written manually, there may be cases where the file content involves keywords from two project categories, but in fact only one project category of tasks was performed on that day. When the number of project tags is greater than 1, it means that the project classification of this file is unclear, so it is necessary to analyze the file in this case to determine the actual corresponding project category.

[0102] Step 150: sequentially determine a second target file and a third target file corresponding to each of the first target files; the second target file is a file adjacent to the first target file in the first file set, and the third target file is a file within a preset range from the first target file;

[0103] Since the periodic report file set is arranged in ascending order according to the submission time, the files in the first file set are also arranged in ascending order according to the submission time. For example, if the first target file is the Nth file in the first file set, the second target file adjacent to the first target file is the N-1th file and the N+1th file in the first file set. The preset range is (2-X), and the third target file is all files within the range of 2 files to X files from the first target file, that is, the third target file includes: the N-2th file, the NXth file and the files between the two, the N+2th file, the N+Xth file and the files between the two.

[0104] Step 160: reconfiguring the first project tag based on the first project tag of the first target file, the second project tag of the second target file, and the third project tag of the third target file, and determining the first target file with the reconfigured first project tag as the fourth target file;

[0105] Among them, the number of the second project tags of the second target file is 1 or more, the number of the third project tags of the third target file is 1; and the project category of the fourth target file is the project category corresponding to the reconfigured first project tag.

[0106] Step 170: Generate a target project tracking Gantt chart based on the fourth target file and the files in the first file set except the first target file.

[0107] like Figure 3As shown, the horizontal axis of the project tracking Gantt chart is the project time, each small square is a time block of unit time, and the vertical axis is the project category. The color of each time block in the figure is the project label. The project category and the project label correspond one to one, that is, different project categories correspond to project labels of different colors, and the progress bar in each project category is marked with different colors.

[0108] Through the above method, periodic report files such as weekly reports and monthly reports can be automatically converted into Gantt charts. Periodic report files can be used to regularly understand the progress of the project. Converting periodic report files into Gantt charts can intuitively and clearly display the project progress, making it easy to understand the progress of the project over time. In addition, by reconfiguring the first project label through files adjacent to the first target file and files within a preset range of intervals, the project category classification of the first target file can be made more accurate, and at the same time, files with collection errors or files with problematic contents can be excluded, and the time of the final Gantt chart is relatively continuous.

[0109] based on Figure 1 The present invention provides some specific implementation methods, which are described below.

[0110] Wherein, step 160 can be implemented based on the following steps:

[0111] Step 161: Determine whether the second project tag contains the same tag as the first project tag;

[0112] If the second project tag includes the same tag as the first project tag, configuring the same project tag as the first project tag in the second project tag as a new first project tag, and determining the first target file with the reconfigured first project tag as the fourth target file;

[0113] Step 162: If the second project tag does not include the same tag as the first project tag, determine whether the third project tag includes the same tag as the first project tag;

[0114] If the third project tag includes a tag identical to the first project tag, the tag identical to the first project tag in the third project tag is configured as a new first project tag, and the first target file with the reconfigured first project tag is determined as a fourth target file;

[0115] Specifically, determine whether the third project label and the first project label contain the same label in order from an interval of 2 files to an interval of X files; if the third project label only contains a label that is the same as one label in the first project label, configure the label as a new first project label; if the third project label contains two labels that are the same as the first project label, configure the same label corresponding to the file with a smaller time interval with the first target file as the new first project label; if the time intervals are the same, determine which same label corresponds to a larger number of files, and determine the same label corresponding to the larger number of files as the new first project label.

[0116] Step 163: If there is no label identical to the first project label in the third project label, the first project label is removed, and the first target file without the first project label is determined as the fourth target file.

[0117] If neither the second project tag nor the third project tag has the same tag as the first project tag, then the first target file is a file with incorrect collection or incorrect content and should be deleted. Since the subsequent generation of the project tracking Gantt chart marks the project tags into the Gantt chart to display the progress, deleting the first project tag of the first target file eliminates the possibility of generating a Gantt chart based on the erroneous file.

[0118] When the number of the second item tag is 1, step 161 can be implemented based on the following steps:

[0119] Determine whether both of the two second project tags contain the same tag as the first project tag. If not, it means that only one of the second project tags contains the same tag as the first project tag. Then, the same tag is configured as a new first project tag, and the first target file with the reconfigured first project tag is determined as the fourth target file, and the project tag of the fourth target file is the tag.

[0120] Exemplary: among the N-1th file and the N+1th file, if only the second item tag of the N-1th file is the same as one of the first item tags of the Nth file, then the second item tag of the N-1th file is configured as the new first item tag, and the item tag of the fourth target file is the second item tag of the N-1th file.

[0121] If both second project tags contain the same tag as the first project tag, determine whether the two second project tags are the same. If the two second project tags are the same, configure the second project tag as a new first project tag, and determine the first target file with the reconfigured first project tag as the fourth target file, and the project tag of the fourth target file is the second project tag.

[0122] Exemplary; if the second project tags of the N-1th file and the N+1th file are both A, then the project tag A is configured as the new first project tag, and the project tag of the fourth target file obtained is A.

[0123] If the two second project labels are different, the second project label corresponding to the file with a smaller submission time interval than the first target file is configured as a new first project label, and the first target file with the reconfigured first project label is determined as the fourth target file;

[0124] For example: the submission time interval between the N-1th file and the Nth file is 3 days, and the submission time interval between the N+1th file and the Nth file is 2 days, then the second project tag of the N+1th file is configured as the new first project tag, the project tag of the fourth target file is the second project tag of the N+2th file, and the project category is the project category corresponding to the second project tag of the N+2th file.

[0125] When the number of the second item tags is greater than 1, step 161 can be specifically implemented based on the following steps:

[0126] Step 1611: determining whether the first project tag is completely identical to the second project tag; if at least one of the second project tags is completely identical to the first project tag, the first project tag remains unchanged, and the first target file is determined as the fourth target file;

[0127] When the project label of any one of the N-1th file and the N+1th file is exactly the same as the project label of the Nth file, it means that tasks of two project categories are indeed executed at the current time point. Therefore, the first project label of the first target file does not need to be changed.

[0128] For example, if the project label of the Nth file is AB, the project label of the N-1th file is AB, and the project label of the N+1th file is AB, then the project label of the first target file remains unchanged and is still AB. Therefore, the project labels of the fourth target file are project label A and project label B, and the project category of the fourth target file is the project category corresponding to project label A and project label B.

[0129] Step 1612: If there are different tags between the first project tag and the second project tag, determine whether each of the second project tags has a tag that is the same as the first project tag;

[0130] If not, determining the tag in the second project tag that is identical to the first project tag as the first identical tag, configuring the first identical tag as a new first project tag, and determining the first target file with the reconfigured first project tag as the fourth target file;

[0131] Exemplarily, the second project label of the N-1th file is AB, the first project label of the Nth file is BC, the second project label of the N+1th file is DE, and only the second project label of the N-1th file contains the same first identical label B as the first project label, then the first project label B is configured as the new first project label of the first target file, the project label of the fourth target file is B, and the project category of the fourth target file is the project category corresponding to project label B.

[0132] Step 1613: If yes, determine whether the second identical tag and the third identical tag are identical;

[0133] The second identical tag is a tag that is identical to the first item tag in the second project tag, and the third identical tag is another tag that is identical to the first item tag in the second project tag; the number of the second identical tags and the third identical tags are both 1.

[0134] If the second identical tag and the third identical tag are identical, the tags represented by the second identical tag and the third identical tag are configured as new first project tags, and the first target file with the reconfigured first project tag is determined as the fourth target file.

[0135] For example, the project label of the N-1th file is AB, the project label of the Nth file is BC, and the project label of the N+1th file is BD. The second identical label is B, and the third identical label is B. The two are the same. Project label B is configured as the new first project label. At this time, the project label of the fourth target file is B, and the project category is the project category corresponding to project label B.

[0136] Step 1614: If the second identical tag is different from the third identical tag; then determine the first interval time between the submission time corresponding to the second identical tag and the submission time corresponding to the first project tag; determine the second interval time between the submission time corresponding to the third identical tag and the submission time corresponding to the first project tag; configure the tag corresponding to the smaller interval time between the first interval time and the second interval time as a new first project tag, and determine the first target file of the reconfigured first project tag as the fourth target file.

[0137] Exemplarily, the second identical label is the same project label between the N-1th file and the Nth file, the third identical label is the same project label between the Nth file and the N+1th file, the second identical label is A, the third identical label is B, the submission time of the N-1th file is October 1st, the submission time of the Nth file is October 5th, the submission time of the N+1th file is October 10th, the first interval time between the N-1th file and the Nth file is 4 days, and the second interval time between the N+1th file and the Nth file is 5 days, then the second identical label A is used as the new first project label. The first target file with the reconfigured first project label is determined as the fourth target file, and the project label of the fourth target file obtained at this time is A, and the project category is the project category corresponding to the project label A.

[0138] Step 1615: If the first interval time and the second interval time are the same, jump to step 162 to determine whether the third project tag contains the same tag as the first project tag.

[0139] It can be known from the above specific description of step 160 that when the project category of a file is determined based on keywords, when the number of project categories of a file is greater than 1, it does not mean that the determination of the project category of the file is wrong. It is very likely that tasks corresponding to two project categories are performed on the same day. Therefore, based on the adjacent second target file and the third target file with a preset range of files as intervals, it is determined which situation it belongs to, and based on different situations, a new first project label of the first target file is determined, so that the determined new first project label is more accurate and the project category classification of the first target file is also more accurate.

[0140] The above step 170 can be implemented based on the following steps:

[0141] Step 1701: Arrange the fourth target file and the files in the first file set except the first target file in ascending order of submission time to generate a second file set;

[0142] The project tag of the second file set includes the project tag of the fourth target file and the project tags of the files in the first file set except the first target file; the project category of the second file set includes the project category of the fourth target file and the project category of the files in the first file set except the first target file; the submission time of the second file set includes the submission time of the fourth target file and the submission time of the files in the first file set except the first target file.

[0143] Since the project labels of the files in the first file set other than the first target file are all less than or equal to 1, it means that the classification is clear and there is no need to reconfirm the project labels.

[0144] The item tags in the second file set may include the first identical tag and / or the second identical tag and / or the third identical tag.

[0145] Step 1702: merge the files with the same project tag in the second file set to obtain a plurality of fifth target files; the fifth target file is a set of files with the same project tag;

[0146] Step 1703: Determine the start time, end time, fifth item tag and fifth item category of the fifth target file;

[0147] Step 1704: Determine the target area corresponding to the fifth project category in the initial project tracking Gantt chart;

[0148] Step 1705: Mark the time block corresponding to the start time to the end time in the target area as a fifth item label;

[0149] Step 1706: Complete the project label marking of the target areas corresponding to all fifth target files to obtain an initial project tracking Gantt chart;

[0150] Step 1707: Optimize the initial project tracking Gantt chart to obtain a target project tracking Gantt chart.

[0151] It should be noted that the above steps are for illustration only and do not limit the order of the steps. In specific implementation, after determining a fourth target file, if the adjacent files have the same project label as the fourth target file, they will be merged into one file, and the project labels of the files adjacent to the merged file will continue to be determined. If they are the same, the files will be merged until there are no labels in the adjacent files that are the same as the project labels of the merged file, and the merged project labels will be marked to the time blocks corresponding to the project categories and project times in the Gantt chart. The corresponding project category is the project category corresponding to the merged file, and the corresponding project time is the minimum time to the maximum time of the merged file. Then the next fourth target file is determined.

[0152] As an optional method, step 176 can be implemented based on the following steps:

[0153] The target project tracking Gantt chart includes a plurality of progress bars, wherein the progress bars are bar-shaped graphics composed of continuous time blocks; the time blocks are small squares marked with the project labels per unit time; the optimization processing of the initial project tracking Gantt chart to obtain the target project tracking Gantt chart includes:

[0154] Step 1761: Delete the progress bar in the target project tracking Gantt chart whose time length is less than the first time threshold;

[0155] If the length of the progress bar is too short, the progress bar is a noise point, so that the relatively short and incorrectly drawn points in the project tracking Gantt chart can be removed. Exclude the situation where the wrong periodic report file is collected. Exemplarily, the first time threshold can be set to 1% to 10% of the total length of the project time of the project plan Gantt chart, preferably 5%.

[0156] Step 1762: Determine a third interval time between adjacent progress bars in each project category;

[0157] Step 1763: Determine the first progress bar, the second progress bar and the target time block whose third interval time is less than the preset interval time threshold; the target time block is the blank time block between the first progress bar and the second progress bar; that is, the target time block is the blank time block corresponding to the third interval time.

[0158] Step 1764: Mark the project labels of the first progress bar and the second progress bar into the target time block to obtain a target project tracking Gantt chart.

[0159] For example, in the Gantt chart, days 1 to 3 are project plans, day 4 is blank or project implementation, and days 4 to 6 are project plans. Then mark day 4 as the project label corresponding to the project plan, and obtain a Gantt chart in which days 1 to 6 are all project plans.

[0160] Merge the two adjacent progress bars whose third interval time is less than the preset interval time threshold and the blank time block between the two progress bars. This can avoid the situation where the user forgets to submit the daily report or does not write the keywords corresponding to the project category in the daily report, but the tasks of the project category are actually executed and not reflected in the Gantt chart. Based on this, the blank time blocks can be supplemented, and the timeline of the project tracking Gantt chart is relatively continuous.

[0161] As an optional method, the number of initial project tracking Gantt charts is greater than 1, and it is determined whether the order of project categories over time in the initial project tracking Gantt charts satisfies the existing relationship. If not, the initial project tracking Gantt charts that do not satisfy the relationship are deleted;

[0162] For example, the project launch, project plan, project implementation, and project completion mentioned above have a sequence, and it is impossible to implement the project first and then launch the project. If the user is writing a daily report, the daily report written a few days ago mentions the project implementation, and the daily report written a few days later mentions the project launch, and the order when generating the project tracking Gantt chart is project implementation first and then project launch, then the project tracking Gantt chart should be deleted, or the project categories with the wrong order should be deleted.

[0163] As an optional method, the number of initial project tracking Gantt charts is greater than 1; in actual applications, the number of project personnel is greater than 1, and each person needs to submit a daily report, and convert each person's daily report file set into an initial project tracking Gantt chart. In this case, step 186 can be implemented based on the following steps:

[0164] Arrange the total project time of multiple initial project tracking Gantt charts in ascending order to obtain a time sorting group; the total project time can be the time from the start of the project to the end of the project in the initial project tracking Gantt chart, or the time corresponding to each project category.

[0165] Divide the total time of two adjacent items in the time sorting group whose difference is greater than a preset amplitude threshold into two different intervals, divide the total time of two adjacent items whose difference is less than the preset amplitude threshold into the same interval, and determine all the intervals obtained by the division as multiple fault intervals;

[0166] Determine whether the first time range of the first fault interval is within a preset time range; the first fault interval is the fault interval with the largest number of total project time among the multiple fault intervals; the first time range is the range from the minimum value to the maximum value of the total project time in the first fault interval;

[0167] If the first time range is within the preset time range, then determining the average value of the total project time in the first fault interval as the target project total time of the target project tracking Gantt chart;

[0168] If the first time range is not within the preset time range, determining whether the second time range of the second fault interval is within the preset time range; the second fault interval is the fault interval with the largest number of total project time among the multiple fault intervals except the first fault interval;

[0169] If the second time range is not within the preset time range, the preset range is reduced, and the process goes to step 162 to redetermine the first project label of the first target file when no file adjacent to the first target file has the same label as the project label of the first target file, obtain a new fourth target file, and regenerate the initial project tracking Gantt chart based on the new fourth target file until the second time range of the second fault interval corresponding to the obtained multiple initial project tracking Gantt charts is within the preset time range;

[0170] If the second time range is within the preset time range, determining whether the total time of the project in the first fault interval is greater than the total time of the project in the second fault interval by a preset percentage;

[0171] If not, the average value of the total project time in the second fault interval is determined as the target total project time of the target project tracking Gantt chart;

[0172] If so, the average of the total project time in the first fault interval is determined as the target project total time of the target project tracking Gantt chart;

[0173] Based on the total time of the target project, a target project tracking Gantt chart is generated.

[0174] Exemplarily, the project time length of the project plan Gantt chart is the standard length, and the standard length is 10 months. The preset time range is 90% to 110% of the standard length, then the preset time range is 9 months to 11 months, and the preset amplitude threshold is 30% of the maximum change amplitude. As shown in Table 1, there are 5 project personnel, the project implementation time of the initial project tracking Gantt chart of project personnel 1 is 10 months, the project implementation time of the initial project tracking Gantt chart of project personnel 2 is 9.6 months, the project implementation time of the initial project tracking Gantt chart of project personnel 3 is 10.1 months, the project implementation time of the initial project tracking Gantt chart of project personnel 4 is 20 months, and the project implementation time of the initial project tracking Gantt chart of project personnel 5 is 2 months. The project implementation time is sorted in order to obtain a time sorting group of [2 months, 9.6 months, 10 months, 10.1 months, 20 months]. The maximum change amplitude of two adjacent values ​​in the time sorting group is 20 months-10.1 months=9.9 months, and the preset amplitude threshold is 30% of the maximum change amplitude. The value is 9.9×30%=2.97 months. The difference between 2 months and 9.6 months is greater than 2.97 months, so the project tracking Gantt charts of the project personnel corresponding to 2 months and 9.6 months are divided into two intervals. The difference between 9.6 months and 10 months is less than 2.97 months, so the project tracking Gantt charts of the project personnel corresponding to 9.6 months and 10 months are divided into the same interval. The difference between 10 months and 10.1 months is less than 2.97 months, so the project tracking Gantt charts of the project personnel corresponding to 10.1 months are divided into the same interval as the interval corresponding to 9.6 months. The difference between 10.1 months and 20 months is greater than 2.97 months, so the project tracking Gantt charts of the project personnel corresponding to 10.1 months and 20 months are divided into two intervals, that is, project personnel 5 is divided into the first interval, project personnel 1, project personnel 2, and project personnel 3 are divided into the second interval, and project personnel 4 is divided into the third interval. The first interval, the second interval, and the third interval are three fault intervals. Since the number of people in the second interval is the largest, the time range of the second interval is 9.6 months to 10.1 months, which is within the preset time range, and its average value is 10 months. Therefore, 10 months is determined as the total project time of the target project tracking Gantt chart.

[0175] Table 1 Initial project tracking Gantt chart statistics

[0176]

[0177] As an optional method, step 176 may also be:

[0178] Determine whether the initial project tracking Gantt chart includes a target progress bar with a time length less than a second time threshold; the second time threshold is greater than the first time threshold;

[0179] If not included, the initial project tracking Gantt chart will be confirmed as the target project tracking Gantt chart.

[0180] If included, determine whether the project label of the target adjacent file of the sixth target file is removed; the sixth target file is the file corresponding to each time point of the target progress bar; the target adjacent file is the file in the second file set that is adjacent to the submission time of the sixth target file.

[0181] If yes, the project tag of the sixth target file is determined as the target project tag of the target adjacent file, and the initial project tracking Gantt chart is regenerated.

[0182] If not, the initial project tracking Gantt chart is confirmed as the target project tracking Gantt chart.

[0183] Exemplarily, the second time threshold is the time corresponding to three time blocks. Determine whether the same project label in the project tracking Gantt chart exceeds three consecutive time points. If not, determine whether the previous or subsequent file of each time point of the project label of the Gantt chart that does not appear at the above three consecutive time points has been executed to remove the project label. If so, configure the file that has been executed to remove the project label with the project label of the file at the above three consecutive time points, and redraw the project tracking Gantt chart. In other words, the file that has been executed to remove the project label may be noise in the algorithm. After all labels are removed, it should be close to the more continuous project label to make the project label more continuous.

[0184] In practical applications, the existing Gantt chart cannot simultaneously display the project plan and progress in the Gantt chart.

[0185] To solve this problem, the present invention provides the following steps:

[0186] After optimizing the initial project tracking Gantt chart to obtain the target project tracking Gantt chart, the following further comprises:

[0187] The target project tracking Gantt chart is combined with the project plan Gantt chart to obtain a project progress Gantt chart; each project category in the project progress Gantt chart corresponds to the progress of both planning and tracking.

[0188] like Figure 4 As shown, the project progress in both planning and tracking can be seen from the project progress Gantt chart. From this chart, we can intuitively see the actual project progress and the planned project progress.

[0189] The embodiment of the present invention can divide the functional modules according to the above method example. For example, each functional module can be divided according to each function, or two or more functions can be integrated into one processing module. The above integrated module can be implemented in the form of hardware or in the form of software functional modules. It should be noted that the division of modules in the embodiment of the present invention is schematic and is only a logical function division. There may be other division methods in actual implementation.

[0190] In the case of dividing each functional module into corresponding functional modules, Figure 5 FIG. 1 shows a schematic diagram of the structure of a project data processing system provided by the present invention. Figure 5 As shown, the system includes:

[0191] The project management data acquisition module 501 is used to acquire the project management data corresponding to the target project number; the project management data includes a periodic report file set and the submission time corresponding to each file in the periodic report file set; the periodic report file set is a file set sorted in ascending order of submission time;

[0192] A keyword extraction module 502, used to extract keywords from each file in the periodic report file set;

[0193] A project category and project label configuration module 503, configured to configure a project category and a project label for each file in the periodic report file set based on the keyword to obtain a first file set, wherein the project category and the project label correspond one to one;

[0194] A first target file determination module 504 is used to extract files in the first file set whose item tag number is greater than 1 to obtain a first target file;

[0195] The second target file determination module 505 is used to sequentially determine the second target file and the third target file corresponding to each of the first target files; the second target file is a file adjacent to the first target file, and the third target file is a file within a preset range from the first target file;

[0196] A first project tag updating module 506, configured to reconfigure the first project tag based on the first project tag of the first target file, the second project tag of the second target file, and the third project tag of the third target file, and determine the first target file with the reconfigured first project tag as the fourth target file;

[0197] The project tracking Gantt chart generating module 507 is used to generate a target project tracking Gantt chart based on the fourth target file and the files in the first file set except the first target file.

[0198] Optionally, the first project tag updating module 506 may include:

[0199] A first judging unit, configured to judge whether the second project tag contains a tag identical to the first project tag;

[0200] If the second project tag includes the same tag as the first project tag, configuring the same project tag as the first project tag in the second project tag as a new first project tag, and determining the first target file with the reconfigured first project tag as the fourth target file;

[0201] a second judging unit, configured to judge whether the third project tag contains the same tag as the first project tag if the second project tag does not contain the same tag as the first project tag;

[0202] If the third project tag includes a tag identical to the first project tag, the tag identical to the first project tag in the third project tag is configured as a new first project tag, and the first target file with the reconfigured first project tag is determined as a fourth target file;

[0203] The label removal unit is used for removing the first project label if there is no label identical to the first project label in the third project label, and determining the first target file without the first project label as the fourth target file.

[0204] Optionally, the first determining unit may be configured to:

[0205] Determine whether the first project tag is completely identical to the second project tag; if at least one of the second project tags is completely identical to the first project tag, the first project tag remains unchanged, and the first target file is determined to be the fourth target file;

[0206] If there are different tags between the first project tag and the second project tag, determining whether each of the second project tags has a tag that is the same as the first project tag;

[0207] If not, determining the tag in the second project tag that is identical to the first project tag as the first identical tag, configuring the first identical tag as a new first project tag, and determining the first target file with the reconfigured first project tag as the fourth target file;

[0208] If yes, determine whether the second identical tag and the third identical tag are identical; the second identical tag is a tag that is identical to the first item tag and the second item tag, and the third identical tag is another tag that is identical to the first item tag and the second item tag;

[0209] If the second identical tag is different from the third identical tag;

[0210] Then determine a first interval time between the submission time corresponding to the second identical tag and the submission time corresponding to the first project tag; determine a second interval time between the submission time corresponding to the third identical tag and the submission time corresponding to the first project tag;

[0211] The label corresponding to the smaller interval between the first interval and the second interval is configured as a new first project label, and the first target file with the reconfigured first project label is determined as a fourth target file.

[0212] Optionally, the project tracking Gantt chart generating module 507 may include:

[0213] A sorting unit, configured to arrange the fourth target file and the files in the first file set except the first target file in ascending order of submission time, to generate a second file set;

[0214] A merging unit, configured to merge files with the same project tag in the second file set to obtain a plurality of fifth target files;

[0215] a fifth target file attribute determination unit, used to determine the start time, end time, fifth item label and fifth item category of the fifth target file;

[0216] A target area determination unit, used to determine a target area corresponding to the fifth project category in the initial project tracking Gantt chart;

[0217] An item label adding unit, configured to mark a time block corresponding to the start time to the end time in the target area as a fifth item label;

[0218] A loop unit, used to complete the marking of target areas corresponding to all fifth target files, and obtain an initial project tracking Gantt chart;

[0219] The optimization unit is used to optimize the initial project tracking Gantt chart to obtain a target project tracking Gantt chart.

[0220] Optionally, the target project tracking Gantt chart includes a plurality of progress bars, wherein the progress bar is a bar-shaped graphic composed of continuous time blocks; the time block is a small square marked with the project label per unit time; the optimization unit can be used for:

[0221] Delete the progress bar whose time length is less than the first time threshold in the target project tracking Gantt chart;

[0222] Determine the third interval time between adjacent progress bars in each project category;

[0223] Determine the first progress bar, the second progress bar and the target time block whose third interval time is less than the preset interval time threshold; the target time block is the blank time block between the first progress bar and the second progress bar;

[0224] The project labels of the first progress bar and the second progress bar are marked in the target time block to obtain a target project tracking Gantt chart.

[0225] Optionally, the number of the initial project tracking Gantt charts is greater than 1; and the optimization unit may also be used for:

[0226] Arrange the total project time of multiple initial project tracking Gantt charts in ascending order to obtain a time sorting group;

[0227] Divide the total time of two adjacent items in the time sorting group whose difference is greater than a preset amplitude threshold into two different intervals, divide the total time of two adjacent items whose difference is less than the preset amplitude threshold into the same interval, and determine all the intervals obtained by the division as multiple fault intervals;

[0228] Determine whether a first time range of a first fault interval is within a preset time range; the first fault interval is a fault interval with the largest number of total project time among the multiple fault intervals;

[0229] If the first time range is within the preset time range, then determining the average value of the total project time in the first fault interval as the target project total time of the target project tracking Gantt chart;

[0230] If the first time range is not within the preset time range, determining whether the second time range of the second fault interval is within the preset time range; the second fault interval is the fault interval with the largest number of total project time among the multiple fault intervals except the first fault interval;

[0231] If the second time range is not within the preset time range, lowering the preset range until the second time range of the second fault interval is within the preset time range;

[0232] If the second time range is within the preset time range, determining whether the total time of the project in the first fault interval is greater than the total time of the project in the second fault interval by a preset percentage;

[0233] If not, the average value of the total project time in the second fault interval is determined as the target total project time of the target project tracking Gantt chart;

[0234] If so, the average of the total project time in the first fault interval is determined as the target project total time of the target project tracking Gantt chart;

[0235] Based on the total time of the target project, a target project tracking Gantt chart is generated.

[0236] Optionally, the optimization unit may also be used for:

[0237] Determine whether the initial project tracking Gantt chart includes a target progress bar with a time length less than a second time threshold; the second time threshold is greater than the first time threshold;

[0238] If included, determining whether the project tag of the target adjacent file of the sixth target file is removed; the sixth target file is the file corresponding to each time point of the target progress bar;

[0239] If yes, the project tag of the sixth target file is determined as the target project tag of the target adjacent file, and the initial project tracking Gantt chart is regenerated.

[0240] Optionally, the device also includes a Gantt chart merging module, which is used to merge the target project tracking Gantt chart with the project planning Gantt chart to obtain a project progress Gantt chart; each project category in the project progress Gantt chart corresponds to the progress of both planning and tracking.

[0241] The above mainly introduces the solution provided by the embodiment of the present invention from the perspective of the interaction between various modules. It can be understood that in order to realize the above functions, it has a hardware structure and / or software module corresponding to the execution of each function. It should be easily appreciated by those skilled in the art that, in combination with the units and algorithm steps of each example described in the embodiments disclosed herein, the present invention can be implemented in the form of hardware or a combination of hardware and computer software. Whether a function is executed in the form of hardware or computer software driving hardware depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to exceed the scope of the present invention.

[0242] In the case of using the corresponding integrated unit, Figure 6 A schematic diagram of the structure of a project tracking Gantt chart generation product provided by the present invention. Figure 6 As shown, the product includes:

[0243] A communication unit / communication interface, used to obtain project management data corresponding to the target project number; the project management data includes a periodic report file set and a submission time corresponding to each file in the periodic report file set; the periodic report file set is a file set sorted in ascending order of submission time;

[0244] A processing unit / processor, configured to extract keywords from each file in the periodic report file set;

[0245] Based on the keyword, configure a project category and a project label for each file in the periodic report file set to obtain a first file set, wherein the project category and the project label correspond one to one;

[0246] Extract the files in the first file set whose number of project tags is greater than 1 to obtain a first target file;

[0247] Determine in sequence the second target file and the third target file corresponding to each of the first target files; the second target file is a file adjacent to the first target file, and the third target file is a file within a preset range from the first target file;

[0248] reconfiguring the first project tag based on the first project tag of the first target file, the second project tag of the second target file, and the third project tag of the third target file, and determining the first target file with the reconfigured first project tag as the fourth target file;

[0249] A target project tracking Gantt chart is generated based on the fourth target file and the files in the first file set except the first target file.

[0250] like Figure 6 As shown, the processor may be a general-purpose central processing unit (CPU), a microprocessor, an application-specific integrated circuit (ASIC), or one or more integrated circuits for controlling the execution of the program of the present invention. The communication interface may be one or more. The communication interface may use any transceiver or other device for communicating with other devices or communication networks.

[0251] like Figure 6 As shown, the above product may further include a communication circuit. The communication circuit may include a path to transmit information between the above components.

[0252] Optional, such as Figure 6 As shown, the product may further include a memory. The memory is used to store computer-executable instructions for executing the solution of the present invention, and the execution is controlled by the processor. The processor is used to execute the computer-executable instructions stored in the memory, thereby realizing the method provided by the embodiment of the present invention.

[0253] like Figure 6 As shown, the memory may be a read-only memory (ROM) or other types of static storage devices that can store static information and instructions, a random access memory (RAM) or other types of dynamic storage devices that can store information and instructions, or an electrically erasable programmable read-only memory (EEPROM), a compact disc read-only memory (CD-ROM) or other optical disc storage, optical disc storage (including compressed optical disc, laser disc, optical disc, digital versatile disc, Blu-ray disc, etc.), a magnetic disk storage medium or other magnetic storage device, or any other medium that can be used to carry or store the desired program code in the form of instructions or data structures and can be accessed by a computer, but is not limited thereto. The memory may exist independently and be connected to the processor through a communication line. The memory may also be integrated with the processor.

[0254] Optionally, the computer-executable instructions in the embodiment of the present invention may also be referred to as application program codes, which is not specifically limited in the embodiment of the present invention.

[0255] In a specific implementation, as an example, Figure 6 As shown, the processor may include one or more CPUs, such as Figure 6 CPU0 and CPU1 in.

[0256] In a specific implementation, as an example, Figure 6 As shown, the product may include multiple processors, such as Figure 6 Each of these processors can be a single-core processor or a multi-core processor.

[0257] On the one hand, a computer-readable storage medium is provided, in which instructions are stored. When the instructions are executed, the above-mentioned project tracking Gantt chart generation method is implemented.

[0258] In the above embodiments, all or part of the embodiments may be implemented by software, hardware, firmware or any combination thereof. When implemented by software, all or part of the embodiments may be implemented in the form of a computer program product. The computer program product includes one or more computer programs or instructions. When the computer program or instruction is loaded and executed on a computer, the process or function described in the embodiment of the present invention is executed in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, a terminal, a user device or other programmable device. The computer program or instruction may be stored in a computer-readable storage medium or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer program or instruction may be transmitted from one website, computer, server or data center to another website, computer, server or data center by wired or wireless means. The computer-readable storage medium may be any available medium that a computer can access or a data storage device such as a server or data center that integrates one or more available media. The available medium may be a magnetic medium, such as a floppy disk, a hard disk, or a tape; it may also be an optical medium, such as a digital video disc (DVD); it may also be a semiconductor medium, such as a solid state drive (SSD).

[0259] Although the present invention is described herein in conjunction with various embodiments, in the process of implementing the claimed invention, those skilled in the art may understand and implement other variations of the disclosed embodiments by viewing the drawings, the disclosure, and the appended claims. In the claims, the word "comprising" does not exclude other components or steps, and "one" or "an" does not exclude multiple situations. A single processor or other unit may implement several functions listed in a claim. Certain measures are recorded in different dependent claims, but this does not mean that these measures cannot be combined to produce good results.

[0260] Although the present invention has been described in conjunction with specific features and embodiments thereof, it is apparent that various modifications and combinations may be made thereto without departing from the spirit and scope of the present invention. Accordingly, this specification and the accompanying drawings are merely exemplary illustrations of the present invention as defined by the appended claims and are deemed to cover any and all modifications, variations, combinations or equivalents within the scope of the present invention. Obviously, those skilled in the art may make various modifications and variations to the present invention without departing from the spirit and scope of the present invention. Thus, the present invention is intended to include such modifications and variations if they fall within the scope of the claims of the present invention and their equivalents.

Claims

1. A project tracking Gantt chart generation method, characterized in that: include: Obtain the project management data corresponding to the target project number; The project management data includes a periodic report file set and a submission time corresponding to each file in the periodic report file set; The periodic report file set is a file set sorted in ascending order according to submission time; Extracting keywords from each file in the periodic report file set; Based on the keyword, configure a project category and a project label for each file in the periodic report file set to obtain a first file set, wherein the project category and the project label correspond one to one; Extract the files in the first file set whose number of project tags is greater than 1 to obtain a first target file; Determine in sequence the second target file and the third target file corresponding to each of the first target files; the second target file is a file adjacent to the first target file, and the third target file is a file within a preset range from the first target file; reconfiguring the first project tag based on the first project tag of the first target file, the second project tag of the second target file, and the third project tag of the third target file, and determining the first target file with the reconfigured first project tag as the fourth target file; The reconfiguring of the first project tag based on the first project tag of the first target file, the second project tag of the second target file, and the third project tag of the third target file, and determining the first target file with the reconfigured first project tag as the fourth target file comprises: Determining whether the second item tag contains the same tag as the first item tag; If the second project tag includes the same tag as the first project tag, configuring the same project tag as the first project tag in the second project tag as a new first project tag, and determining the first target file with the reconfigured first project tag as the fourth target file; If the second project tag does not include the same tag as the first project tag, determining whether the third project tag includes the same tag as the first project tag; If the third project tag includes a tag identical to the first project tag, the tag identical to the first project tag in the third project tag is configured as a new first project tag, and the first target file with the reconfigured first project tag is determined as a fourth target file; If there is no label identical to the first project label in the third project label, the first project label is removed, and the first target file without the first project label is determined as the fourth target file; A target project tracking Gantt chart is generated based on the fourth target file and the files in the first file set except the first target file.

2. The project tracking Gantt chart generation method according to claim 1, characterized in that: If the second project tag includes a tag identical to the first project tag, configuring the second project tag and the same project tag in the first project tag as a new first project tag, and determining the first target file with the reconfigured first project tag as the fourth target file includes: Determine whether the first project tag is completely identical to the second project tag; if at least one of the second project tags is completely identical to the first project tag, the first project tag remains unchanged, and the first target file is determined as the fourth target file; If there are different tags between the first project tag and the second project tag, determining whether each of the second project tags has a tag that is the same as the first project tag; If not, determining the tag in the second project tag that is identical to the first project tag as the first identical tag, configuring the first identical tag as a new first project tag, and determining the first target file with the reconfigured first project tag as the fourth target file; If yes, determine whether the second identical tag and the third identical tag are identical; the second identical tag is a tag that is identical to the first item tag and the second item tag, and the third identical tag is another tag that is identical to the first item tag and the second item tag; If the second identical tag is different from the third identical tag; Then determine a first interval time between the submission time corresponding to the second identical tag and the submission time corresponding to the first project tag; determine a second interval time between the submission time corresponding to the third identical tag and the submission time corresponding to the first project tag; The label corresponding to the smaller interval between the first interval and the second interval is configured as a new first project label, and the first target file with the reconfigured first project label is determined as a fourth target file.

3. The project tracking Gantt chart generation method according to claim 1, characterized in that: Generating a target project tracking Gantt chart based on the fourth target file and files in the first file set except the first target file includes: Arrange the fourth target file and the files in the first file set except the first target file in ascending order of submission time to generate a second file set; Merging files with the same project tag in the second file set to obtain a plurality of fifth target files; Determine the start time, end time, fifth item label and fifth item category of the fifth target file; Determine the target area corresponding to the fifth project category described in the initial project tracking Gantt chart; Marking a time block corresponding to the start time to the end time in the target area as a fifth item label; Complete the marking of the target areas corresponding to all fifth target files to obtain the initial project tracking Gantt chart; The initial project tracking Gantt chart is optimized to obtain a target project tracking Gantt chart.

4. The project tracking Gantt chart generation method according to claim 3 is characterized in that: The target project tracking Gantt chart includes a plurality of progress bars, each of which is a bar-shaped graphic composed of continuous time blocks; each time block is a small square marked with a project label per unit time; The optimizing the initial project tracking Gantt chart to obtain the target project tracking Gantt chart includes: Delete the progress bar whose time length is less than the first time threshold in the target project tracking Gantt chart; Determine the third interval time between adjacent progress bars in each project category; Determine the first progress bar, the second progress bar and the target time block whose third interval time is less than the preset interval time threshold; the target time block is the blank time block between the first progress bar and the second progress bar; The project labels of the first progress bar and the second progress bar are marked in the target time block to obtain a target project tracking Gantt chart.

5. The project tracking Gantt chart generation method according to claim 3 is characterized in that: The number of the initial project tracking Gantt charts is greater than 1; and the optimizing the initial project tracking Gantt charts to obtain the target project tracking Gantt charts includes: Arrange the total project time of multiple initial project tracking Gantt charts in ascending order to obtain a time sorting group; Divide the total time of two adjacent items in the time sorting group whose difference is greater than a preset amplitude threshold into two different intervals, divide the total time of two adjacent items whose difference is less than the preset amplitude threshold into the same interval, and determine all the intervals obtained by the division as multiple fault intervals; Determine whether a first time range of a first fault interval is within a preset time range; the first fault interval is a fault interval with the largest number of total project time among the multiple fault intervals; If the first time range is within the preset time range, then determining the average value of the total project time in the first fault interval as the target project total time of the target project tracking Gantt chart; If the first time range is not within the preset time range, determining whether the second time range of the second fault interval is within the preset time range; the second fault interval is the fault interval with the largest number of total project time among the multiple fault intervals except the first fault interval; If the second time range is not within the preset time range, lowering the preset range until the second time range of the second fault interval is within the preset time range; If the second time range is within the preset time range, determining whether the total time of the project in the first fault interval is greater than the total time of the project in the second fault interval by a preset percentage; If not, the average value of the total project time in the second fault interval is determined as the target total project time of the target project tracking Gantt chart; If so, the average of the total project time in the first fault interval is determined as the target project total time of the target project tracking Gantt chart; Based on the total time of the target project, a target project tracking Gantt chart is generated.

6. The project tracking Gantt chart generation method according to claim 3 is characterized in that: The optimizing process of the initial project tracking Gantt chart further includes: Determine whether the initial project tracking Gantt chart includes a target progress bar with a time length less than a second time threshold; the second time threshold is greater than the first time threshold; If included, determining whether the project tag of the target adjacent file of the sixth target file is removed; the sixth target file is the file corresponding to each time point of the target progress bar; If yes, the project tag of the sixth target file is determined as the target project tag of the target adjacent file, and the initial project tracking Gantt chart is regenerated.

7. A project tracking Gantt chart generation system, characterized in that: include: A project management data acquisition module is used to acquire the project management data corresponding to the target project number; The project management data includes a periodic report file set and a submission time corresponding to each file in the periodic report file set; The periodic report file set is a file set sorted in ascending order according to submission time; A keyword extraction module, used to extract keywords from each file in the periodic report file set; A project category and project label configuration module, configured to configure a project category and a project label for each file in the periodic report file set based on the keyword to obtain a first file set, wherein the project category and the project label correspond one to one; A first target file determination module, used for extracting files in the first file set whose number of project tags is greater than 1, to obtain a first target file; A second target file determination module, used to sequentially determine a second target file and a third target file corresponding to each of the first target files; the second target file is a file adjacent to the first target file, and the third target file is a file within a preset range from the first target file; A first project label updating module, configured to reconfigure the first project label based on the first project label of the first target file, the second project label of the second target file, and the third project label of the third target file, and determine the first target file with the reconfigured first project label as the fourth target file; The first project label update module includes: A first judging unit, configured to judge whether the second project tag contains a tag identical to the first project tag; If the second project tag includes the same tag as the first project tag, configuring the same project tag as the first project tag in the second project tag as a new first project tag, and determining the first target file with the reconfigured first project tag as the fourth target file; a second judging unit, configured to judge whether the third project tag contains the same tag as the first project tag if the second project tag does not contain the same tag as the first project tag; If the third project tag includes a tag identical to the first project tag, the tag identical to the first project tag in the third project tag is configured as a new first project tag, and the first target file with the reconfigured first project tag is determined as a fourth target file; a label removal unit, configured to remove the first project label if there is no label identical to the first project label in the third project label, and determine the first target file without the first project label as the fourth target file; A project tracking Gantt chart generating module is used to generate a target project tracking Gantt chart based on the fourth target file and the files in the first file set except the first target file.

8. A project tracking Gantt chart generation product, characterized in that: include: A communication unit / communication interface, used to obtain project management data corresponding to a target project number; The project management data includes a periodic report file set and a submission time corresponding to each file in the periodic report file set; The periodic report file set is a file set sorted in ascending order according to submission time; A processing unit / processor, configured to extract keywords from each file in the periodic report file set; Based on the keyword, configure a project category and a project label for each file in the periodic report file set to obtain a first file set, wherein the project category and the project label correspond one to one; Extract the files in the first file set whose number of project tags is greater than 1 to obtain a first target file; Determine in sequence the second target file and the third target file corresponding to each of the first target files; the second target file is a file adjacent to the first target file, and the third target file is a file within a preset range from the first target file; reconfiguring the first project tag based on the first project tag of the first target file, the second project tag of the second target file, and the third project tag of the third target file, and determining the first target file with the reconfigured first project tag as the fourth target file; The reconfiguring of the first project tag based on the first project tag of the first target file, the second project tag of the second target file, and the third project tag of the third target file, and determining the first target file with the reconfigured first project tag as the fourth target file comprises: Determining whether the second item tag contains the same tag as the first item tag; If the second project tag includes the same tag as the first project tag, configuring the same project tag as the first project tag in the second project tag as a new first project tag, and determining the first target file with the reconfigured first project tag as the fourth target file; If the second project tag does not include the same tag as the first project tag, determining whether the third project tag includes the same tag as the first project tag; If the third project tag includes a tag identical to the first project tag, the tag identical to the first project tag in the third project tag is configured as a new first project tag, and the first target file with the reconfigured first project tag is determined as a fourth target file; If there is no label identical to the first project label in the third project label, the first project label is removed, and the first target file without the first project label is determined as the fourth target file; A target project tracking Gantt chart is generated based on the fourth target file and the files in the first file set except the first target file.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores instructions, and when the instructions are executed, the project tracking Gantt chart generation method described in any one of claims 1 to 6 is implemented.

Images