Method and system for generating project progress report

Abstract

The invention discloses a method and system for generating a project progress report, and relates to the technical field of data management.The method comprises the steps that a database table structure containing project progress data is created on a server side; a JavaScript function is used for automatically calculating the date of the last day of the week where the current date is located when the project progress report is generated, and a calculation result is stored in a specific field of the report; creating a project progress report layout associated with the database, and configuring a column for displaying the date of the last day of each week on a front-end report interface; and after the project progress data is input, writing the data in the front-end report into a database through a saving button, and updating the data content displayed on the page in real time. According to the method for generating the project progress report, the standardized database table structure is established at the server side, the trigger is arranged to achieve serial number formatting, errors possibly generated when EXCEL tables are manually summarized are avoided, and therefore the possibility of data errors is remarkably reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of data management, and in particular to a method and system for generating a project progress report. Background Art

[0002] The current project progress management mainly relies on the manual summary and reporting of Excel spreadsheets between multiple levels of departments. Generally, each grassroots unit reports the project progress data in the form of an Excel report to the upper level department, and the upper level department manually summarizes the received Excel spreadsheet and then reports it to the higher level management department. Finally, the summary table of the project progress will be generated after multiple levels of summary for review and decision-making by leaders at all levels.

[0003] This multi-level reporting method of EXCEL tables has significant defects in data management. First, since data needs to be filled in and summarized manually, it is easy to make operational errors and data loss. Second, the EXCEL table formats of different departments may not be unified, resulting in inconsistent data, difficult data standardization and low management efficiency. In addition, the manual table summary method is time-consuming, not convenient for real-time query, and difficult to automatically export and count according to weeks or other time periods, which cannot effectively meet the decision makers' needs for timeliness and accuracy of data.

[0004] It can be seen that in the process of realizing project progress data management and statistics of multi-level departments, the existing technology has problems such as easy information errors, inconsistent data formats, low management efficiency, and high risk of data loss. Therefore, the existing technology has obvious technical defects in the aggregation and query of real-time project progress data of multiple departments, and cannot meet the needs of efficient, accurate and unified project management. Summary of the invention

[0005] In view of the above-mentioned problems, the present invention is proposed.

[0006] Therefore, the technical problem solved by the present invention is to solve the problems of inconsistent data formats, difficulty in real-time updating, information loss, scattered display, inconvenience in weekly statistics, etc. in multi-department project progress management. Through standardized storage of database table structure, automatic date calculation and real-time storage and display of data, unified management and efficient query statistics of project progress are achieved.

[0007] In order to solve the above technical problems, the present invention provides the following technical solutions: a method for generating a project progress report, comprising:

[0008] Create a database table structure containing project progress data on the server side;

[0009] Use JavaScript functions to automatically calculate the last day of the week in which the current date falls when the project progress report is generated, and store the calculation results in a specific field of the report;

[0010] Create a project progress report layout associated with the database, and configure a column on the front-end report interface to display the last day of each week;

[0011] When the project progress data is entered, the data in the front-end report is written into the database through the Save button and the data content displayed on the page is updated in real time.

[0012] As a preferred solution of the method for generating a project progress report according to the present invention, the step of creating a database table structure containing project progress data includes creating a database table for storing project progress on the server side by using structured query language.

[0013] Configure a data trigger. When new data is inserted into the serial number field, the trigger is automatically triggered and the field format is adjusted.

[0014] Triggers are set up to implement automatic data processing so that each record is given a uniformly formatted serial number and a weekly time basis during database storage.

[0015] As a preferred solution of the method for generating a project progress report described in the present invention, the database table structure includes a project progress data field, a sequence number field and a last day of the week field.

[0016] As a preferred solution of the method for generating a project progress report according to the present invention, the method comprises: using a JavaScript function includes writing a function for date calculation, which is automatically called during the process of generating the project progress report, and calculates the last day of the week in which the current date is located according to the time offset of the current date;

[0017] In the function, the last day of the current week is calculated by getting the current date and offsetting it to Monday;

[0018] After the calculation is completed, the last day of the current week is written into the control field used to display the date;

[0019] Use the weekly time base value in the control field to provide date data support for the project progress report generation process.

[0020] As a preferred solution of the method for generating a project progress report according to the present invention, wherein: the creation of a project progress report layout associated with a database includes connecting to a project progress database through a report development tool, and setting a project progress report layout synchronized with the database in a front-end report interface;

[0021] Add a column at the end of each record in the report to display the last day of each week, set the column to be associated with the content of the control field used to display the date, extract the latest project progress and weekend date data from the database and load it to the page;

[0022] Set up an automatic report loading mechanism so that when the report is generated, it will automatically extract the latest project progress and weekend date data from the database and display it on the page;

[0023] After the page is loaded, each record displays the corresponding week time information in the week date column.

[0024] As a preferred solution of the method for generating a project progress report according to the present invention, the step of writing the data in the front-end report into the database through the save button includes that after the project progress data is entered, the user triggers the save operation through the save button on the front-end page, and writes the project progress data and weekly time information into the database;

[0025] During the saving process, traverse each record and write the weekly time information in the control field into the last day of each week date field in the database;

[0026] After saving, the page will automatically refresh, reload the project progress report with the updated data in the database, and display all the latest saved project progress information and week dates on the page;

[0027] After the page is refreshed, the data export operation based on the weekly time base is performed.

[0028] Another object of the present invention is to provide a system for generating project progress reports, which can solve the problems of low data accuracy, low management efficiency and inconvenient query and statistics in existing project progress management by constructing a system for generating project progress reports.

[0029] In order to solve the above technical problems, the present invention provides the following technical solutions: a system for generating a project progress report, comprising: a data storage module, a date calculation module, a report generation module and a data update module; the data storage module is used to create a database table structure containing project progress data on the server side; the date calculation module is used to use a JavaScript function to automatically calculate the last day of the week in which the current date is located when the project progress report is generated, and the calculation result is stored in a specific field of the report; the report generation module is used to create a project progress report layout associated with the database, and configure a column for displaying the last day of each week on the front-end report interface; the data update module is used to write the data in the front-end report into the database through a save button after the project progress data is input and to update the data content displayed on the page in real time.

[0030] A computer device includes a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of the method for generating a project progress report as described above when executing the computer program.

[0031] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the steps of the method for generating a project progress report as described above.

[0032] A computer program product includes computer instructions stored in a computer-readable storage medium. A processor of a computer device reads the computer instructions from the computer-readable storage medium, and when the processor executes the computer instructions, the steps of the method for generating a project progress report are implemented.

[0033] Beneficial effects of the present invention: The method for generating a project progress report provided by the present invention establishes a standardized database table structure on the server side and sets triggers to implement serial number formatting, thereby avoiding errors that may occur when manually summarizing EXCEL tables, thereby significantly reducing the possibility of data errors.

[0034] The structured storage and automatic sorting mechanism of the database ensures that the format of project progress data is unified, avoiding management difficulties caused by inconsistent data source formats.

[0035] Project progress data can be directly entered into the system, which will automatically summarize and display it, reducing the time for manual summary and reporting by each department, and improving the operational efficiency of project progress management.

[0036] The data is stored in the server-side database, which can avoid data loss caused by manual operations and improve data security and storage stability.

[0037] It supports export by weekly date and statistics by demand, and can automatically calculate the weekend date of the project progress based on the current date, making it easy to query and export data by time period to meet the statistical needs of management. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the accompanying drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other accompanying drawings can be obtained based on these accompanying drawings without paying creative work.

[0039] Figure 1 An overall flow chart of a method for generating a project progress report provided by an embodiment of the present invention.

[0040] Figure 2 An overall structural diagram of a system for generating a project progress report provided in accordance with a second embodiment of the present invention. DETAILED DESCRIPTION

[0041] In order to make the above-mentioned purposes, features and advantages of the present invention more obvious and easy to understand, the specific implementation methods of the present invention are described in detail below in conjunction with the drawings of the specification. Obviously, the described embodiments are part of the embodiments of the present invention, but not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary persons in the art without creative work should fall within the scope of protection of the present invention.

[0042] In the following description, many specific details are set forth to facilitate a full understanding of the present invention, but the present invention may also be implemented in other ways different from those described herein, and those skilled in the art may make similar generalizations without violating the connotation of the present invention. Therefore, the present invention is not limited to the specific embodiments disclosed below.

[0043] Example 1

[0044] Reference Figure 1 , as an embodiment of the present invention, provides a method for generating a project progress report, comprising:

[0045] Create a database table structure containing project progress data on the server side;

[0046] Use JavaScript functions to automatically calculate the last day of the week in which the current date falls when the project progress report is generated, and store the calculation results in a specific field of the report;

[0047] Create a project progress report layout associated with the database, and configure a column on the front-end report interface to display the last day of each week;

[0048] When the project progress data is entered, the data in the front-end report is written into the database through the Save button and the data content displayed on the page is updated in real time.

[0049] The step of creating a database table structure containing project progress data includes creating a database table for storing project progress on the server side using structured query language.

[0050] Configure a data trigger. When new data is inserted into the serial number field, the trigger is automatically triggered and the format of the field is adjusted. The symbol "." in the serial number field is replaced with "00" to ensure that the serial number format is consistent.

[0051] Set up triggers to implement automatic data processing so that each record gets a uniformly formatted serial number and weekly time basis during database storage. It is triggered when new data is inserted into the serial number field, which is used for data sorting and query preparation.

[0052] The database table structure includes a project progress data field: recording the current status of the project, key milestones and other progress information;

[0053] Sequence number field: used to record the order of data for subsequent sorting;

[0054] Last day of the week field: records the weekly time base of the project progress to support weekly query and data display.

[0055] The use of the JavaScript function includes writing a function for date calculation, which is automatically called during the generation of the project progress report and calculates the last day of the week in which the current date is located based on the time offset of the current date;

[0056] In the function, the consistency of the weekly time base data is ensured by obtaining the current date and offsetting it to Monday, and then calculating the last day of the current week.

[0057] After the calculation is completed, the last day of the current week is written into the control field used to display the date, and the content of this field is provided when the report is generated to ensure the synchronization of the time base data.

[0058] The weekly time base value in the control field is used to provide date data support for the project progress report generation process, so that the project progress record is automatically accompanied by the corresponding weekly time information when it is displayed, providing a basis for subsequent data display and query.

[0059] The creating of the project progress report layout associated with the database includes connecting to the project progress database through a report development tool, and setting the project progress report layout synchronized with the database in the front-end report interface;

[0060] Add a column at the end of each record in the report to display the last day of each week, set the column to be associated with the content of the control field used to display the date, extract the latest project progress and weekend date data from the database and load it to the page;

[0061] Set up an automatic report loading mechanism so that when the report is generated, it will automatically extract the latest project progress and weekend date data from the database and display it on the page;

[0062] After the page is loaded, each record displays the corresponding week time information in the week date column.

[0063] Writing the data in the front-end report into the database through the save button includes that after the project progress data is entered, the user triggers the save operation through the save button on the front-end page, and writes the project progress data and weekly time information into the database;

[0064] During the saving process, traverse each record and write the weekly time information in the control field into the last day of each week date field in the database;

[0065] After saving, the page will automatically refresh, reload the project progress report with the updated data in the database, and display all the latest saved project progress information and week dates on the page;

[0066] After the page is refreshed, the data export operation based on the weekly time base is performed.

[0067] Example 2

[0068] Reference Figure 2 , as an embodiment of the present invention, provides a system for generating a project progress report, including:

[0069] Data storage module 100, date calculation module 200, report generation module 300 and data update module 400;

[0070] The data storage module 100 is used to create a database table structure containing project progress data on the server side;

[0071] The date calculation module 200 is used to automatically calculate the last day of the week in which the current date is located when the project progress report is generated using a JavaScript function, and the calculation result is stored in a specific field of the report;

[0072] The report generation module 300 is used to create a project progress report layout associated with the database, and configure a column for displaying the last day of each week on the front-end report interface;

[0073] The data update module 400 is used to write the data in the front-end report into the database and update the data content displayed on the page in real time through the save button after the project progress data is input.

[0074] Example 3

[0075] An embodiment of the present invention is different from the first two embodiments in that:

[0076] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc., which can store program codes.

[0077] The logic and / or steps represented in the flowchart or otherwise described herein, for example, can be considered as an ordered list of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by an instruction execution system, device or apparatus (such as a computer-based system, a system including a processor, or other system that can fetch instructions from an instruction execution system, device or apparatus and execute instructions), or in conjunction with such instruction execution systems, devices or apparatuses. For the purposes of this specification, "computer-readable medium" can be any device that can contain, store, communicate, propagate or transmit a program for use by an instruction execution system, device or apparatus, or in conjunction with such instruction execution systems, devices or apparatuses.

[0078] More specific examples of computer-readable media (a non-exhaustive list) include the following: an electrical connection with one or more wires (electronic device), a portable computer disk case (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable and programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disk read-only memory (CDROM). In addition, the computer-readable medium may even be a paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium, followed by editing, deciphering or, if necessary, processing in another suitable manner, and then stored in a computer memory.

[0079] It should be understood that the various parts of the present invention can be implemented by hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, a plurality of steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, it can be implemented by any one of the following technologies known in the art or their combination: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0080] Example 4

[0081] As an embodiment of the present invention, a method for generating a project progress report is provided. In order to verify the beneficial effects of the present invention, a scientific demonstration is carried out through simulation experiments.

[0082] The project progress report includes four parts: key project progress report, special fund project progress report, science and technology project progress report, cost project engineering, and service project progress report.

[0083] Use the SQL statement CREATE TABLE to create a schedule in the database. The fields include the last day of the week field (WeekLastDayTime) and the field used for sorting (sortField).

[0084] Create a data trigger that is triggered when new data is inserted into the serial number (serialNumber) field, and replace the "." in the serial number (serialNumber) field with "00".

[0085] Trigger function name: sortFieldArrange.

[0086] Trigger function body: BEGIN

[0087] declare str VARCHAR(50)default";

[0088] declare strS VARCHAR(50)default";

[0089] declare strT VARCHAR(50)default";

[0090] declare cnt int default 0;

[0091] declare iint default 0;

[0092] declare strLenght int default 0;

[0093] set cnt=1+ROUND((CHAR_LENGTH(str_characters))-CHAR_LENGTH(REPLACE(str_characters,str_delimiter,”)) / CHAR_LENGTH(str_delimiter),0);

[0094] while i<cnt

[0095] do

[0096] set i=i+1;

[0097] set str=

[0098] reverse(substring_index(reverse(substring_index(str_characters,str_delimiter,i)),str_delimiter,1));

[0099] set strLenght=CHAR_LENGTH(str);

[0100] CASE strLenght

[0101] WHEN 1THEN set strT=CONCAT('00',str,'.');

[0102] WHEN 2THEN set strT=CONCAT('0',str,'.');

[0103] ELSE set strT=CONCAT(str,'.');

[0104] END CASE;

[0105] set strs=CONCAT(strS,strT);

[0106] end while;

[0107] set strs=SUBSTRING(strs,1,LENGTH(strs)-1);

[0108] return strs;

[0109] END

[0110] Use the Fanruan report development tool to connect to the backend database to provide data support for the frontend.

[0111] Use the Fanruan report development tool to layout the front-end according to the original report format. Add a column for the weekend date of the week at the end of the row.

[0112] Use JAVASCRIPT language to process logical relationships. First, calculate the last day of the current week based on the current date, and record the last day of the week in the text control (submissionWeekLastDayTime) for future use. The following function is used to calculate the last day of the week:

[0113]

[0114] Secondly, use a loop statement to set the content of the last column "Weekend Date of This Week" of the newly added row to the content of the text control (submissionWeekLastDayTime).

[0115] Loop statement:

[0116]

[0117] if(_value27==null||_value27==""||_value27==undefined){

[0118] _g().setCellValue(0,27,i,submissionWeekLastDayTime);

[0119] }

[0120] if(lastWeekFlaglabel==1){

[0121] submissionWeekLastDayTime=

[0122] getCurrentWeekLastDay(submissionTime);

[0123] _g().setCellValue(0,27,i,submissionWeekLastDayTime);}

[0124] Save the page content through the Save button. Write the data to the database. Restore the text control (submissionWeekLastDayTime) to the original value "0". Refresh the page, call the database data again, and display the latest saved data. The code is as follows:

[0125] _g().verifyAndWriteReport();

[0126] this.options.form.getWidgetByName('lastWeekFlaglabel').setValue(0);

[0127] _g().refreshAllSheets();

[0128] Call the page through the browser to display the page content. You can also export the report through the export button.

[0129] It should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical solutions of the present invention can be modified or replaced by equivalents without departing from the spirit and scope of the technical solutions of the present invention, which should be included in the scope of the claims of the present invention.

Claims

1. A method for generating a project progress report, characterized in that: include: Create a database table structure containing project progress data on the server side; Use JavaScript functions to automatically calculate the last day of the week in which the current date falls when the project progress report is generated, and store the calculation results in a specific field of the report; Create a project progress report layout associated with the database, and configure a column on the front-end report interface to display the last day of each week; When the project progress data is entered, the data in the front-end report is written into the database through the Save button and the data content displayed on the page is updated in real time.

2. The method for generating a project progress report according to claim 1, characterized in that: The step of creating a database table structure containing project progress data includes creating a database table for storing project progress on the server side using structured query language. Configure a data trigger. When new data is inserted into the serial number field, the trigger is automatically triggered and the field format is adjusted. Triggers are set up to implement automatic data processing so that each record is given a uniformly formatted serial number and a weekly time basis during database storage.

3. The method for generating a project progress report according to claim 2, characterized in that: The database table structure includes a project progress data field, a sequence number field and a last day of the week field.

4. The method for generating a project progress report according to claim 3, characterized in that: The use of the JavaScript function includes writing a function for date calculation, which is automatically called during the generation of the project progress report and calculates the last day of the week in which the current date is located based on the time offset of the current date; In the function, the last day of the current week is calculated by getting the current date and offsetting it to Monday; After the calculation is completed, the last day of the current week is written into the control field used to display the date; Use the weekly time base value in the control field to provide date data support for the project progress report generation process.

5. The method for generating a project progress report according to claim 4, characterized in that: The creating of the project progress report layout associated with the database includes connecting to the project progress database through a report development tool, and setting the project progress report layout synchronized with the database in the front-end report interface; Add a column at the end of each record in the report to display the last day of each week, set the column to be associated with the content of the control field used to display the date, extract the latest project progress and weekend date data from the database and load it to the page; Set up an automatic report loading mechanism so that when the report is generated, it will automatically extract the latest project progress and weekend date data from the database and display it on the page; After the page is loaded, each record displays the corresponding week time information in the week date column.

6. The method for generating a project progress report according to claim 5, characterized in that: Writing the data in the front-end report into the database through the save button includes that after the project progress data is entered, the user triggers the save operation through the save button on the front-end page, and writes the project progress data and weekly time information into the database; During the saving process, traverse each record and write the weekly time information in the control field into the last day of each week date field in the database; After saving, the page will automatically refresh, reload the project progress report with the updated data in the database, and display all the latest saved project progress information and week dates on the page; After the page is refreshed, the data export operation based on the weekly time base is performed.

7. A system for implementing the method for generating a project progress report according to any one of claims 1 to 6, characterized in that: include: A data storage module (100), a date calculation module (200), a report generation module (300) and a data update module (400); The data storage module (100) is used to create a database table structure containing project progress data on the server side; The date calculation module (200) is used to automatically calculate the last day of the week in which the current date is located when the project progress report is generated using a JavaScript function, and the calculation result is stored in a specific field of the report; The report generation module (300) is used to create a project progress report layout associated with the database, and configure a column for displaying the last day of each week on the front-end report interface; The data updating module (400) is used to write the data in the front-end report into the database and update the data content displayed on the page in real time through a save button after the project progress data is input.

8. An ecological data monitoring device, comprising a memory, a processor, and a computer program stored in the memory, characterized in that: The processor executes the computer program to implement the steps of the method for generating a project progress report according to any one of claims 1 to 6.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method for generating a project progress report described in any one of claims 1 to 6 are implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method for generating a project progress report described in any one of claims 1 to 6 are implemented.

Images