CN114154967A - Project cost and labor hour management method and system - Google Patents
Project cost and labor hour management method and system Download PDFInfo
- Publication number
- CN114154967A CN114154967A CN202210099015.2A CN202210099015A CN114154967A CN 114154967 A CN114154967 A CN 114154967A CN 202210099015 A CN202210099015 A CN 202210099015A CN 114154967 A CN114154967 A CN 114154967A
- Authority
- CN
- China
- Prior art keywords
- project
- working
- attendance
- data
- work
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000007726 management method Methods 0.000 title claims abstract description 70
- 238000012795 verification Methods 0.000 claims abstract description 23
- 238000000034 method Methods 0.000 claims abstract description 5
- 238000012544 monitoring process Methods 0.000 claims description 15
- 238000012550 audit Methods 0.000 claims description 14
- 238000012986 modification Methods 0.000 claims description 8
- 230000004048 modification Effects 0.000 claims description 8
- 238000013479 data entry Methods 0.000 claims description 6
- 238000000354 decomposition reaction Methods 0.000 claims description 3
- 238000007405 data analysis Methods 0.000 claims 1
- 238000007728 cost analysis Methods 0.000 abstract description 2
- 230000002354 daily effect Effects 0.000 abstract 6
- 230000003203 everyday effect Effects 0.000 abstract 2
- 230000002159 abnormal effect Effects 0.000 description 5
- 230000006870 function Effects 0.000 description 5
- 238000004458 analytical method Methods 0.000 description 4
- 238000004364 calculation method Methods 0.000 description 3
- 238000007619 statistical method Methods 0.000 description 3
- 230000005856 abnormality Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000004080 punching Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 238000013468 resource allocation Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06311—Scheduling, planning or task assignment for a person or group
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0637—Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Educational Administration (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Game Theory and Decision Science (AREA)
- Development Economics (AREA)
- General Engineering & Computer Science (AREA)
- Computing Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a project cost and working hour management method and a system, wherein the method comprises the steps of recording project working hours in a project management system and recording attendance working hours in an attendance system; acquiring project working hours, attendance working hours and working saturation coefficients which are filled in on a specified date, and filling data in a working daily report auditing system according to a working daily report template; checking the filling data by a working daily report checking system; generating a working daily report based on the final filling data after the verification; and the management terminal checks the working daily report. According to the invention, the staff are recorded every day for attendance checking and project working hours, and are integrated, verified and submitted through every day working daily reports, so that the real-time acquisition of attendance checking data and project working hour data is ensured, a manager is helped to carry out management work more efficiently, the accuracy of working hour data is improved, the repeated work of common staff is reduced, and a reliable data basis is provided for project cost management, staff cost analysis, staff management and company decision making of a company.
Description
Technical Field
The invention belongs to the technical field of labor cost management, and particularly relates to a project cost and labor hour management method and system.
Background
Aiming at the requirements of accurately managing the contents and the time spent by various work tasks of employees on projects and non-projects in high labor cost industries such as IT companies, design companies, accounting/law firms and the like, the system is used for counting project standard working hours, accounting the labor cost of the projects, evaluating the performance of the employees and scheduling resources by combining company strategies. However, in actual management, there are often problems of multiple system entries, disassociation of various types of data, inability to share resources, hysteresis in filling of project man-hour data, low accuracy of project man-hour data, and repetitive work in filling of project man-hour and submitting of work daily reports. By integrating the problems, the problems that time and labor are consumed for working hour verification, the staff repeatedly work, the financial wage calculation pressure is high, and reliable data are not available for company resource allocation decision making and staff performance assessment to serve as a support and the like can be caused.
Therefore, the project cost and working hour management method provided by the invention integrates project working hour input verification and daily work daily newspaper submission, ensures real-time acquisition of project working hour data and attendance data, automatically performs verification by combining a certain rule, more efficiently helps a manager to perform task working hour verification of project members and work management of staff, greatly reduces the time spent on project working hour management by the staff, improves the accuracy of working hour data, and also reduces the repeated work of common staff.
Disclosure of Invention
The technical problem to be solved by the invention is as follows: a project cost and labor hour management method and system are provided to solve at least some of the above technical problems.
In order to achieve the purpose, the technical scheme adopted by the invention is as follows:
a project cost man-hour management method, comprising:
step S1, recording project working hours in the project management system and recording work hours in the attendance system;
step S2, acquiring project working hours, attendance working hours and working saturation coefficients which are filled in on a specified date, and filling data in a working daily report auditing system according to a working daily report template;
step S3, the working diary audit system checks whether the work attendance working hours on the same day are recorded, if not, the staff is prompted to update the work attendance working hours and the step S2 is returned; if the attendance time is not less than the project working hours, updating the attendance working hours or the project working hours and returning to the step S2; if the attendance checking time is greater than or equal to the project working time, judging whether the working saturation coefficient K is greater than the saturation coefficient KS, and if the working saturation coefficient K is greater than the saturation coefficient KS, passing the verification;
step S4, generating a working daily report based on the final filling data after verification;
step S5, the management end checks the daily work report for auditing; if the audit is passed, adding the audited label to the project working hours of the employee; if the verification is not passed, the modification suggestion of the management end is sent to the employee end, the step S1 is returned, and the project working hours or the attendance working hours are modified according to the suggestion.
Further, the work daily report template comprises a task working hour list and a summary list, wherein the task working hour list comprises time, names, projects, tasks, task working hours and task monitoring links, the summary list comprises project working hours and attendance working hours, and the project working hours comprise at least one task working hour.
Further, the task work hour recording process comprises the following steps: carrying out WBS task decomposition on the project, and selecting the decomposed task to start a task monitoring function; starting and timing work, if screen recording and screenshot are needed, the system randomly captures and stores a screen picture of a monitoring computer, and records and stores a computer video; and if screen recording and screen capturing are not needed, selecting task ending and automatically generating task working hours.
Further, the monitoring computer screen picture and the computer video are stored in the project management system in a task monitoring link mode.
Further, the work saturation coefficient K = project man-hour/attendance man-hour.
Further, the saturation coefficient KS = K1 a1+ K2 a2+ K3 a3, where K1 is an average value of the work saturation coefficient K of the company in the last three months, K2 is an average value of the work saturation coefficient K of the same department in the last three months, K3 is an average value of the work saturation coefficient K of the same post in the last three months, and a1, a2, and a3 are weight coefficients, respectively.
Further, in step S2, obtaining Binary log logs from the database of the project management system and the database of the attendance system, respectively, and obtaining attendance time data and project time data by using Binary log logs of Canal subscription MySQL; sending the attendance working hour data and the project working hour data to the middleware Kafka; and the data is resynchronized to a Redis database through the middleware Kafka, and the work daily report auditing system acquires the work-hour data and the attendance data of the current-day project in real time through the Redis database.
And further, periodically synchronizing the project working hours with the checked tags into a project working hour data warehouse, and performing data statistical analysis based on the project working hour data warehouse.
Further, the middleware Kafka synchronizes data timing offline into the project man-hour data warehouse.
The invention also discloses a project cost and working hour management system, which comprises:
the data entry unit is used for entering project working hours in the project management system and recording attendance working hours in the attendance system;
the data acquisition unit is used for acquiring project working hours, attendance working hours and work saturation coefficients which are filled in on a specified date, and filling data in the work daily report auditing system according to a work daily report template;
the checking unit is used for checking whether the work daily report checking system checks the work attendance working hours on the same day, and if not, prompting the staff to update the work attendance working hours; if the attendance time is less than the project working hours, updating the attendance working hours or the project working hours; if the attendance checking time is greater than or equal to the project working time, judging whether the working saturation coefficient K is greater than the saturation coefficient KS, and if the working saturation coefficient K is greater than the saturation coefficient KS, passing the verification;
the data generation unit generates a working daily report based on the final filling data after verification;
the auditing unit is used for examining and auditing the working daily newspaper by the management end; if the audit is passed, adding the audited label to the project working hours of the employee; if the audit is not passed, the modification suggestion of the management end is sent to the staff end, and the data entry unit modifies the project working hours or attendance working hours according to the suggestion.
Compared with the prior art, the invention has the following beneficial effects:
the invention records the daily attendance of the staff and the project working hours, and integrates, checks and submits the daily work report. The invention not only ensures the real-time acquisition of attendance data and project working hour data, but also more efficiently helps managers to carry out management work, improves the accuracy of the working hour data, reduces the repeated work of common staff, and provides a reliable data basis for project cost management, staff cost analysis, staff management and company decision making of companies.
Drawings
FIG. 1 is a flow chart of the method of the present invention.
FIG. 2 is a flowchart illustrating the calculation of the recommended saturation coefficient KS according to the present invention.
FIG. 3 is a graph of data real-time and offline acquisition according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is further described in detail below with reference to the accompanying drawings. It is to be understood that the described embodiments are merely exemplary of the invention, and not restrictive of the full scope of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
As shown in fig. 1, the project cost and labor hour management method provided by the present invention includes:
step S1, recording project working hours in the project management system and recording work hours in the attendance system;
step S2, acquiring project working hours, attendance working hours and working saturation coefficients which are filled in on a specified date, and filling data in a working daily report auditing system according to a working daily report template;
step S3, the working diary audit system checks whether the work attendance working hours on the same day are recorded, if not, the staff is prompted to update the work attendance working hours and the step S2 is returned; if the attendance time is not less than the project working hours, updating the attendance working hours or the project working hours and returning to the step S2; if the attendance checking time is greater than or equal to the project working time, judging whether the working saturation coefficient K is greater than the saturation coefficient KS, and if the working saturation coefficient K is greater than the saturation coefficient KS, passing the verification; step S4, generating a working daily report based on the final filling data after verification;
step S5, the management end checks the daily work report for auditing; if the audit is passed, adding the audited label to the project working hours of the employee; if the verification is not passed, the modification suggestion of the management end is sent to the employee end, the step S1 is returned, and the project working hours or the attendance working hours are modified according to the suggestion.
The work hour of attendance checking is the time length of attendance checking on the same day, namely the time length between the off-duty time of checking and the on-duty time of checking. The attendance system can automatically calculate the attendance working hours of the employee on the same day according to the attendance card punching time and the attendance card punching time of the employee. The project man-hour is man-hour of putting into the project on the same day, each project can be divided into a plurality of tasks, the project man-hour comprises at least one task man-hour, namely the project man-hour is the total man-hour of the plurality of task man-hours on the same day. The project management system can identify projects and split tasks, and finally, the task working hours are summarized into project working hours.
The work daily report template comprises a task work hour list and a summary list. The task man-hour list is shown in table 1 and comprises time, name, project, task man-hour and task monitoring link; the summary table is shown in table 2, and includes project hours and attendance hours. The work daily report template can reduce the workload of the staff, improve the work efficiency, ensure the data quality and facilitate the management of the staff by managers.
TABLE 1 task hour list
TABLE 2 summary of the invention
The task working hour input flow comprises the following steps: carrying out WBS task decomposition on the project, and selecting the decomposed task to start a task monitoring function; starting and timing work, if screen recording and screenshot are needed, the system randomly captures and stores a screen picture of a monitoring computer, and records and stores a computer video; and if screen recording and screen capturing are not needed, selecting task ending and automatically generating task working hours. And the monitoring computer screen picture and the computer video are stored in the project management system in a task monitoring link mode. The screen recording and screenshot specifically comprises the following operations: selecting screen recording start and screen capture as 'yes', and sequentially carrying out random computer screen picture capturing and computer screen video recording by the project management system; and if the screen recording is started and the screenshot is 'no', closing the screen recording and the screenshot. The task working hour input method has the functions of tool automatic statistics and timing, and random screen capture and screen recording of a computer screen, reserves working evidence, and is convenient for a manager to manage the staff.
The work daily report auditing system has a checking function, checks whether the work daily attendance is abnormal or not and whether the work daily item is abnormal or not in sequence, and can avoid errors caused by manual operation. If the attendance is abnormal on the same day, for example, the attendance is forgotten to be checked, and the attendance is requested to be left for leave, the attendance is fed back to the staff end, and related staff are notified to deal with the abnormality in time, such as the completion of the check-in or the filling of leave-asking instructions. If the project on the same day is abnormal, for example, the work hour on the same day is wrongly filled, the abnormal data is also fed back to the staff end and the related staff is informed to handle the abnormality in time, for example, the work hour for correctly filling the project is modified. In addition, as shown in the recommended saturation coefficient KS calculation flowchart shown in fig. 2, the present invention also automatically generates a saturation coefficient KS based on company, department, and employee historical data, and compares the work saturation coefficient K with the generated saturation coefficient KS. And according to different departments and posts, different saturation coefficients KS are given, and the different conditions of different departments and posts in actual management are met. The saturation coefficient KS can be dynamically adjusted along with the development of a company, meets the requirements of the company at different stages, and is convenient for the management of the work saturation condition of the staff.
The work saturation coefficient K = project man-hour/attendance man-hour. The saturation coefficient KS = K1 a1+ K2 a2+ K3 a3, where K1 is an average value of the operating saturation coefficient K of the whole company in the last three months, K2 is an average value of the operating saturation coefficient K of the same department in the last three months, K3 is an average value of the operating saturation coefficient K of the same staff in the last three months, a1, a2, and a3 are weight coefficients, respectively, where the weight coefficient a1 is 0.1, the weight coefficient a2 is 0.5, and the weight coefficient a3 is 0.4. And if the saturation coefficient KS is less than or = the work saturation coefficient K or =1, the work daily report auditing system passes the auditing, and otherwise, the attendance checking working hours or project working hours are returned to be updated.
The work daily newspaper auditing system is characterized in that automatic verification is combined with auditing of a management terminal. And the data which passes the automatic verification of the system generates a final working daily report, and the final working daily report is audited by a management terminal. The management end is used for checking manually, the manual checking can set related checking standards for various data of the working daily reports according to requirements of various companies or departments, and if the data do not accord with the checking standards, a checking proposal is provided and returned to the employee end for modification. And when the project passes the audit by the management terminal, the audited tag is added. The automatic verification of the work daily report auditing system can assist the management terminal, reduce the auditing work of the management terminal and improve the auditing rate and accuracy.
The project management system, the attendance system and the work daily report auditing system are independent systems, and have the functions of acquiring data from the system and inquiring the data in real time. As shown in the data real-time and offline acquisition diagram of fig. 3, Binary log logs are respectively acquired from the databases of the project management system and the attendance system, and the Binary log logs of the Canal subscription MySQL are utilized to acquire attendance working hour data and project working hour data, so that the pressure of the service database is reduced; sending the attendance working hour data and the project working hour data to the middleware Kafka; and the data is resynchronized to a Redis database through the middleware Kafka, and the work daily report auditing system acquires the work-hour data and the attendance data of the current-day project in real time through the Redis database. The invention utilizes the characteristic of high query speed of the memory Redis database to ensure that the daily work report auditing system can acquire the working hour data and attendance data in the same day in real time, thereby realizing the requirement of the daily work report auditing system for querying the data in real time.
The invention also comprises the steps of periodically synchronizing the project working hours with the checked labels to the project working hour data warehouse and carrying out data statistical analysis based on the project working hour data warehouse. The middleware Kafka synchronizes the data timing offline into the project man-hour data warehouse. The statistical analysis of the data includes, but is not limited to, company cost management analysis, project cost management analysis, department employee man-hour analysis or resource scheduling analysis, and the like, and can provide data support for company resource configuration and development.
The invention also discloses a project cost and time management system corresponding to the project cost and time management method, which comprises the following steps:
the data entry unit is used for entering project working hours in the project management system and recording attendance working hours in the attendance system;
the data acquisition unit is used for acquiring project working hours, attendance working hours and work saturation coefficients which are filled in on a specified date, and filling data in the work daily report auditing system according to a work daily report template;
the checking unit is used for checking whether the work daily report checking system checks the work attendance working hours on the same day, and if not, prompting the staff to update the work attendance working hours; if the attendance time is less than the project working hours, updating the attendance working hours or the project working hours; if the attendance checking time is greater than or equal to the project working time, judging whether the working saturation coefficient K is greater than the saturation coefficient KS, and if the working saturation coefficient K is greater than the saturation coefficient KS, passing the verification;
the data generation unit generates a working daily report based on the final filling data after verification;
the auditing unit is used for examining and auditing the working daily newspaper by the management end; if the audit is passed, adding the audited label to the project working hours of the employee; if the audit is not passed, the modification suggestion of the management end is sent to the staff end, and the data entry unit modifies the project working hours or attendance working hours according to the suggestion.
Finally, it should be noted that: the above embodiments are only preferred embodiments of the present invention to illustrate the technical solutions of the present invention, but not to limit the technical solutions, and certainly not to limit the patent scope of the present invention; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention; that is, the technical problems to be solved by the present invention, which are not substantially changed or supplemented by the spirit and the concept of the main body of the present invention, are still consistent with the present invention and shall be included in the scope of the present invention; in addition, the technical scheme of the invention is directly or indirectly applied to other related technical fields, and the technical scheme is included in the patent protection scope of the invention.
Claims (10)
1. A project cost labor hour management method is characterized by comprising the following steps:
step S1, recording project working hours in the project management system and recording work hours in the attendance system;
step S2, acquiring project working hours, attendance working hours and working saturation coefficients which are filled in on a specified date, and filling data in a working daily report auditing system according to a working daily report template;
step S3, the working diary audit system checks whether the work attendance working hours on the same day are recorded, if not, the staff is prompted to update the work attendance working hours and the step S2 is returned; if the attendance time is not less than the project working hours, updating the attendance working hours or the project working hours and returning to the step S2; if the attendance checking time is greater than or equal to the project working time, judging whether the working saturation coefficient K is greater than the saturation coefficient KS, and if the working saturation coefficient K is greater than the saturation coefficient KS, passing the verification;
step S4, generating a working daily report based on the final filling data after verification;
step S5, the management end checks the daily work report for auditing; if the audit is passed, adding the audited label to the project working hours of the employee; if the verification is not passed, the modification suggestion of the management end is sent to the employee end, the step S1 is returned, and the project working hours or the attendance working hours are modified according to the suggestion.
2. The project cost labor hour management method according to claim 1, wherein the work daily report template comprises a task labor hour list and a summary list, the task labor hour list comprises time, name, project, task labor hour and task monitoring link, the summary list comprises project labor hour and attendance labor hour, and the project labor hour comprises at least one task labor hour.
3. The project cost labor hour management method according to claim 2, wherein the task labor hour recording flow comprises: carrying out WBS task decomposition on the project, and selecting the decomposed task to start a task monitoring function; starting and timing work, if screen recording and screenshot are needed, the system randomly captures and stores a screen picture of a monitoring computer, and records and stores a computer video; and if screen recording and screen capturing are not needed, selecting task ending and automatically generating task working hours.
4. The project cost labor hour management method according to claim 3, wherein the monitoring computer screen picture and the computer video are stored in the project management system in a task monitoring link mode.
5. The project cost and labor hour management method according to claim 1, wherein the work saturation coefficient K = project labor hour/work attendance labor hour.
6. The project cost and labor hour management method according to claim 5, wherein said saturation coefficient KS = K1 a1+ K2 a2+ K3 a3, wherein K1 is an average value of the work saturation coefficient K of the whole company in last three months, K2 is an average value of the work saturation coefficient K of the same department in last three months, K3 is an average value of the work saturation coefficient K of the same post employee in last three months, and a1, a2 and a3 are weight coefficients respectively.
7. The project cost and labor hour management method according to claim 1, wherein in step S2, Binary log logs are obtained from project management system and attendance system databases, respectively, and the Binary log logs of MySQL are subscribed by Canal to obtain attendance and labor hour data and project labor hour data; sending the attendance working hour data and the project working hour data to the middleware Kafka; and the data is resynchronized to a Redis database through the middleware Kafka, and the work daily report auditing system acquires the work-hour data and the attendance data of the current-day project in real time through the Redis database.
8. The method of claim 7, further comprising periodically synchronizing project labor hours with audit tags to a project labor hour data warehouse, and performing statistical data analysis based on the project labor hour data warehouse.
9. The project cost labor hour management method according to claim 8, wherein said middleware Kafka synchronizes data timing offline into a project labor hour data warehouse.
10. A project cost labor hour management system, comprising:
the data entry unit is used for entering project working hours in the project management system and recording attendance working hours in the attendance system;
the data acquisition unit is used for acquiring project working hours, attendance working hours and work saturation coefficients which are filled in on a specified date, and filling data in the work daily report auditing system according to a work daily report template;
the checking unit is used for checking whether the work daily report checking system checks the work attendance working hours on the same day, and if not, prompting the staff to update the work attendance working hours; if the attendance time is less than the project working hours, updating the attendance working hours or the project working hours; if the attendance checking time is greater than or equal to the project working time, judging whether the working saturation coefficient K is greater than the saturation coefficient KS, and if the working saturation coefficient K is greater than the saturation coefficient KS, passing the verification;
the data generation unit generates a working daily report based on the final filling data after verification;
the auditing unit is used for examining and auditing the working daily newspaper by the management end; if the audit is passed, adding the audited label to the project working hours of the employee; if the audit is not passed, the modification suggestion of the management end is sent to the staff end, and the data entry unit modifies the project working hours or attendance working hours according to the suggestion.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210099015.2A CN114154967A (en) | 2022-01-27 | 2022-01-27 | Project cost and labor hour management method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210099015.2A CN114154967A (en) | 2022-01-27 | 2022-01-27 | Project cost and labor hour management method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114154967A true CN114154967A (en) | 2022-03-08 |
Family
ID=80449970
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210099015.2A Pending CN114154967A (en) | 2022-01-27 | 2022-01-27 | Project cost and labor hour management method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114154967A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116187775A (en) * | 2022-12-16 | 2023-05-30 | 深圳市华科成长软件有限公司 | Production working hour management system and method |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103377425A (en) * | 2012-04-26 | 2013-10-30 | 腾讯科技（深圳）有限公司 | Method and device for acquiring assessment result |
| WO2015157792A1 (en) * | 2014-04-17 | 2015-10-22 | Viewpro Pty Ltd | Project management system and method |
| CN105574673A (en) * | 2015-12-22 | 2016-05-11 | 中煤科工集团武汉设计研究院有限公司 | System and method for man-hour management of design company |
| CN109886601A (en) * | 2019-03-06 | 2019-06-14 | 四川长虹电器股份有限公司 | A kind of enterprise collaborative management system |
| CN110689235A (en) * | 2019-09-05 | 2020-01-14 | 广东牵引信息科技有限公司 | Enterprise human cost accounting system and method |
| CN111563703A (en) * | 2020-07-16 | 2020-08-21 | 普源精电科技股份有限公司 | Project management system, project management method, computer device, and computer-readable storage medium |
| CN111815424A (en) * | 2020-07-09 | 2020-10-23 | 北京中百信信息技术股份有限公司 | Information system engineering supervision project cost accounting management system |
| JP2020194397A (en) * | 2019-05-29 | 2020-12-03 | 株式会社オービック | Journal approval work support device, journal approval work support method and journal approval work support program |
| CN112991570A (en) * | 2021-05-21 | 2021-06-18 | 中建电子商务有限责任公司 | Work attendance working hour and night shift algorithm supporting out-of-order uploading |
| CN113610488A (en) * | 2021-07-06 | 2021-11-05 | 江苏金小满信息科技有限公司 | Engineering project attendance management system and project cost accounting method |
-
2022
- 2022-01-27 CN CN202210099015.2A patent/CN114154967A/en active Pending
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103377425A (en) * | 2012-04-26 | 2013-10-30 | 腾讯科技（深圳）有限公司 | Method and device for acquiring assessment result |
| WO2015157792A1 (en) * | 2014-04-17 | 2015-10-22 | Viewpro Pty Ltd | Project management system and method |
| CN105574673A (en) * | 2015-12-22 | 2016-05-11 | 中煤科工集团武汉设计研究院有限公司 | System and method for man-hour management of design company |
| CN109886601A (en) * | 2019-03-06 | 2019-06-14 | 四川长虹电器股份有限公司 | A kind of enterprise collaborative management system |
| JP2020194397A (en) * | 2019-05-29 | 2020-12-03 | 株式会社オービック | Journal approval work support device, journal approval work support method and journal approval work support program |
| CN110689235A (en) * | 2019-09-05 | 2020-01-14 | 广东牵引信息科技有限公司 | Enterprise human cost accounting system and method |
| CN111815424A (en) * | 2020-07-09 | 2020-10-23 | 北京中百信信息技术股份有限公司 | Information system engineering supervision project cost accounting management system |
| CN111563703A (en) * | 2020-07-16 | 2020-08-21 | 普源精电科技股份有限公司 | Project management system, project management method, computer device, and computer-readable storage medium |
| CN112991570A (en) * | 2021-05-21 | 2021-06-18 | 中建电子商务有限责任公司 | Work attendance working hour and night shift algorithm supporting out-of-order uploading |
| CN113610488A (en) * | 2021-07-06 | 2021-11-05 | 江苏金小满信息科技有限公司 | Engineering project attendance management system and project cost accounting method |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116187775A (en) * | 2022-12-16 | 2023-05-30 | 深圳市华科成长软件有限公司 | Production working hour management system and method |
| CN116187775B (en) * | 2022-12-16 | 2023-09-05 | 深圳市华科成长软件有限公司 | Production working hour management system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109408337B (en) | Interface operation and maintenance method and device | |
| US8234145B2 (en) | Automatic computation of validation metrics for global logistics processes | |
| US8489530B2 (en) | System and method for root cause analysis of the failure of a manufactured product | |
| US7367491B2 (en) | System and method for dynamically controlling attendance of a group of employees | |
| CN110852699A (en) | Electronic intelligent management system and method for files | |
| US8275739B2 (en) | User interface display for monitoring a database load engine | |
| CN112396397A (en) | Operation and maintenance affair collection and management system | |
| CN111259648A (en) | Multi-data-source-based policy data intelligent analysis method and system | |
| CN114154967A (en) | Project cost and labor hour management method and system | |
| CN115689334A (en) | Efficiency analysis method and system of warehouse management system and computer equipment | |
| CN113095647B (en) | Vehicle inspection system | |
| CN117036062A (en) | Accounting resource calculation method and device | |
| CN116010380A (en) | Data warehouse automatic management method based on visual modeling | |
| US20130041712A1 (en) | Emerging risk identification process and tool | |
| CN115660475A (en) | System and method for managing work efficiency of function department of smart card manufacturing enterprise | |
| CN112965793B (en) | Identification analysis data-oriented data warehouse task scheduling method and system | |
| CN112559641B (en) | Pull chain table processing method and device, readable storage medium and electronic equipment | |
| CN113657754A (en) | Enterprise performance assessment method based on cloud platform | |
| CN1479230A (en) | Salary computing method and system | |
| CN109032578B (en) | Database SQL (structured query language) -based code generation method and system | |
| CN112232686A (en) | Intelligent secretary system | |
| CN112215560A (en) | Intelligent shift arrangement system and implementation method thereof | |
| CN112668986A (en) | Intelligent performance assessment system and method | |
| CN112561368B (en) | Visual performance calculation method and device for OA approval system | |
| CN111353751A (en) | Batch card supplementing recovery method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20220308 |