CN109460399B - Digital management system and management method for excavation operation - Google Patents
Digital management system and management method for excavation operation Download PDFInfo
- Publication number
- CN109460399B CN109460399B CN201811282344.0A CN201811282344A CN109460399B CN 109460399 B CN109460399 B CN 109460399B CN 201811282344 A CN201811282344 A CN 201811282344A CN 109460399 B CN109460399 B CN 109460399B
- Authority
- CN
- China
- Prior art keywords
- driver
- excavator
- database
- server
- project
- 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.)
- Active
Links
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
Abstract
The invention discloses a digital management system for excavation operation, which comprises: the server side is used for information storage and data calculation; the administrator terminal is used for system management; and the driver terminal is used for inputting the information of the operation site. The server is deployed with the following databases: a digging machine database, a project database, a driver database and a flat plate transportation database. The invention can carry out digital management on the excavation engineering operation of enterprises, reduce the workload of an excavator administrator, improve the reconciliation speed and ensure the accuracy of accounts.
Description
Technical Field
The invention relates to an engineering operation management system, in particular to a digital management system for excavation operation.
Background
The excavator daily operation can meet different conditions, the charging mode is various, the charging amount is different, the flat transportation cost and the oiling cost are different, and for an excavator manager, the management of the actual operation account of the excavator every day is very complicated. In most cases, a manager may manage a plurality of excavators, the excavator driver reports the working time and other generated expense conditions, and the manager records on a paper account book. On one hand, the management mode is tedious, and on the other hand, the later-stage account arrangement is time-consuming when the profits are summed.
Disclosure of Invention
The invention aims to provide a digging operation digital management system, which can carry out digital management on digging engineering operation of enterprises, reduce the workload of a digging machine manager, improve the reconciliation speed and ensure the accuracy of accounts.
In order to solve the above technical problem, the digital management system for excavation work of the present invention comprises:
the server side is used for information storage and data calculation;
the administrator terminal is used for system management;
and the driver terminal is used for inputting the information of the operation site.
The server is deployed with the following databases: a digging machine database, a project database, a driver database and a flat plate transportation database.
The excavator database comprises an excavator basic information table, an excavator operation information table and an excavator refueling record table; the basic information table of the excavator is provided with the following fields: digging machine ID, digging machine name, delivery time, warehousing time and state information; the excavator operation information table is provided with the following fields: project ID, driver ID, excavator ID, operation date, on-time of day on-; the oil filling record table of the excavator is provided with the following fields: driver ID, excavator ID, fueling date, fueling cost, fueling amount.
The project database is provided with the following fields: project ID, project description, project start time, project projected total volume, current total volume completed, projected time completed. The driver database is provided with the following fields: driver ID, driver name, statistical month, total working hours in the month, total amount in the month, and compensation in the month. The flat panel transport database is provided with the following fields: date of transportation, starting location, arrival location, excavator ID, mileage of transportation, flat fee.
The server is deployed with the following modules:
the excavator management module is accessed by an administrator terminal and is used for inputting and maintaining excavator information; the project management module is accessed by the administrator terminal and is used for inputting and maintaining project information; the flat transportation management module is accessed by the driver terminal and is used for recording flat transportation information; the refueling record management module is accessed by a driver terminal and is used for recording the refueling information of the excavator; the operation management module is accessed by the driver terminal and the administrator terminal and is used for recording the operation information of the excavator; the driver management module is accessed by the administrator terminal and is used for inputting and maintaining driver information;
the server side is also provided with a statistical analysis module which is used for accessing the database and generating a statistical analysis report.
The statistical analysis module comprises:
a project statistical analysis module: the system is used for statistically analyzing the progress and the project gross profit of the specified project according to the server-side database;
the driver statistical analysis module: the system is used for statistically analyzing the total working hours and the total amount of the current month of the appointed driver according to the server-side database; estimating the salary of the appointed driver in the current month according to the set condition;
the oil charging fee statistical analysis module: the system is used for statistically analyzing the oiling condition of the appointed excavator according to the server-side database;
a flat plate statistical analysis module: for statistical analysis of flat panel transportation costs;
enterprise profit analysis module: for statistical analysis of gross profit for a given time period.
The invention also provides a digital management method for the excavation operation, which comprises the following steps:
A. system initialization
Logging in a server through a manager terminal, and recording and maintaining an excavator database, a project database and a driver database;
logging in a server terminal through a manager terminal, authorizing a specified driver ID, and establishing association of a project ID, the driver ID and a digging ID;
B. refueling management
A driver refuels the excavator, logs in a server terminal through a driver terminal, and records a driver ID, an excavator ID, a refueling date, refueling cost and refueling amount according to actual conditions; the data are written into a fuel filling recording table of the excavator;
C. transportation management
Logging in a server terminal through a driver terminal, and recording a transportation date, a starting place, an arrival place, an excavator ID, a transportation mileage and a flat plate cost; the data are written into a flat plate transportation database;
D. job management
B, the driver logs in the server end by using the driver ID, automatically obtains the project ID and the excavator ID according to the authorization of the manager in the step A, and obtains the operation date from the server;
a driver uses the handheld equipment to shoot a start dial picture and uploads the picture to the server, and the system automatically obtains a start time point on the same day by uploading time; when the operation is finished, the driver shoots a work receiving dial picture and uploads the picture to the server, the system automatically obtains the work receiving time point on the same day according to the uploading time, the driver inputs the work volume on the same day through the driver terminal, and the data are transmitted to the server and written into the excavator work information table;
the administrator terminal logs in the server side, and after confirming the operation information, the administrator signature is written into the excavator operation information table;
E. statistical analysis
And the server side performs statistical analysis and feeds back the statistical analysis to the administrator terminal.
The invention manages the excavator operation data by an informatization means, provides a real data entry and a data evidence and an efficient reporting and counting function, greatly reduces the workload of an excavator manager, improves the reconciliation speed and ensures the accuracy of accounts. The invention can provide the statistical analysis function based on a single machine, a single driver and a single project, and can also perform the statistical analysis by taking the whole enterprise as a unit.
Drawings
Fig. 1 is an architecture diagram of a digital management system for mining work according to the present invention.
Detailed Description
The invention is further described below with reference to the accompanying drawings.
As can be seen from fig. 1, the platform is implemented by using various technologies such as sqlserver database data storage, html + css + javascript + net development and the like.
The excavation operation digital management system of the invention comprises:
the server side is used for information storage and data calculation;
the administrator terminal is used for system management;
and the driver terminal is used for inputting the information of the operation site.
The server is deployed with the following databases: a digging machine database, a project database, a driver database and a flat plate transportation database.
The excavator database comprises an excavator basic information table, an excavator operation information table and an excavator refueling record table; the basic information table of the excavator is provided with the following fields: digging machine ID, digging machine name, delivery time, warehousing time and state information; the excavator operation information table is provided with the following fields: project ID, driver ID, excavator ID, operation date, on-time of day on-; the oil filling record table of the excavator is provided with the following fields: driver ID, excavator ID, fueling date, fueling cost, fueling amount.
The project database is provided with the following fields: project ID, project description, project start time, project projected total volume, current total volume completed, projected time completed. The driver database is provided with the following fields: driver ID, driver name, statistical month, total working hours in the month, total amount in the month, and compensation in the month. The flat panel transport database is provided with the following fields: date of transportation, starting location, arrival location, excavator ID, mileage of transportation, flat fee.
The server is deployed with the following modules:
the excavator management module is accessed by an administrator terminal and is used for inputting and maintaining excavator information; the project management module is accessed by the administrator terminal and is used for inputting and maintaining project information; the flat transportation management module is accessed by the driver terminal and is used for recording flat transportation information; the refueling record management module is accessed by a driver terminal and is used for recording the refueling information of the excavator; the operation management module is accessed by the driver terminal and the administrator terminal and is used for recording the operation information of the excavator; the driver management module is accessed by the administrator terminal and is used for inputting and maintaining driver information;
the server side is also provided with a statistical analysis module which is used for accessing the database and generating a statistical analysis report.
The statistical analysis module comprises:
a project statistical analysis module: the system is used for statistically analyzing the progress and the project gross profit of the specified project according to the server-side database;
the driver statistical analysis module: the system is used for statistically analyzing the total working hours and the total amount of the current month of the appointed driver according to the server-side database; estimating the salary of the appointed driver in the current month according to the set condition;
the oil charging fee statistical analysis module: the system is used for statistically analyzing the oiling condition of the appointed excavator according to the server-side database;
a flat plate statistical analysis module: for statistical analysis of flat panel transportation costs;
enterprise profit analysis module: for statistical analysis of gross profit for a given time period.
The invention also provides a digital management method for the excavation operation, which comprises the following steps:
A. system initialization
Logging in a server through a manager terminal, and recording and maintaining an excavator database, a project database and a driver database;
logging in a server terminal through a manager terminal, authorizing a specified driver ID, and establishing association of a project ID, the driver ID and a digging ID;
B. refueling management
A driver refuels the excavator, logs in a server terminal through a driver terminal, and records a driver ID, an excavator ID, a refueling date, refueling cost and refueling amount according to actual conditions; the data are written into a fuel filling recording table of the excavator;
C. transportation management
Logging in a server terminal through a driver terminal, and recording a transportation date, a starting place, an arrival place, an excavator ID, a transportation mileage and a flat plate cost; the data are written into a flat plate transportation database;
D. job management
B, the driver logs in the server end by using the driver ID, automatically obtains the project ID and the excavator ID according to the authorization of the manager in the step A, and obtains the operation date from the server;
a driver uses the handheld equipment to shoot a start dial picture and uploads the picture to the server, and the system automatically obtains a start time point on the same day by uploading time; when the operation is finished, the driver shoots a work receiving dial picture and uploads the picture to the server, the system automatically obtains the work receiving time point on the same day according to the uploading time, the driver inputs the work volume on the same day through the driver terminal, and the data are transmitted to the server and written into the excavator work information table;
the administrator terminal logs in the server side, and after confirming the operation information, the administrator signature is written into the excavator operation information table;
E. statistical analysis
And the server side performs statistical analysis and feeds back the statistical analysis to the administrator terminal.
The statistical analysis comprises: and (3) item statistical analysis: the system is used for statistically analyzing the progress and the project gross profit of the specified project according to the server-side database; and (3) statistical analysis of a driver: the system is used for statistically analyzing the total working hours and the total amount of the current month of the appointed driver according to the server-side database; estimating the salary of the appointed driver in the current month according to the set condition; statistical analysis of refueling charge: the system is used for statistically analyzing the oiling condition of the appointed excavator according to the server-side database; plate statistical analysis: for statistical analysis of flat panel transportation costs; enterprise profit analysis: for statistical analysis of gross profit for a given time period.
The embodiments of the present invention include, but are not limited to, the above-mentioned embodiments, and those skilled in the art can make various corresponding changes and modifications according to the present invention without departing from the spirit and the substance of the present invention, and still fall into the scope of the present invention.
Claims (2)
1. A digital management system for mining operation comprises:
the server side is used for information storage and data calculation;
the administrator terminal is used for system management;
the driver terminal is used for inputting operation site information;
the server is deployed with the following databases: the system comprises an excavator database, a project database, a driver database and a flat plate transportation database;
the excavator database comprises an excavator basic information table, an excavator operation information table and an excavator refueling record table; the basic information table of the excavator is provided with the following fields: digging machine ID, digging machine name, delivery time, warehousing time and state information; the excavator operation information table is provided with the following fields: project ID, driver ID, excavator ID, operation date, on-time of day on-; the oil filling record table of the excavator is provided with the following fields: driver ID, excavator ID, refueling date, refueling cost and refueling amount;
the project database is provided with the following fields: project ID, project description, project starting time, project estimated total amount, current completed total amount and estimated completed time;
the driver database is provided with the following fields: driver ID, driver name, statistical month, total working hours of the month, total amount of the prescription of the month, and compensation of the month;
the flat panel transport database is provided with the following fields: date of transportation, starting location, arrival location, excavator ID, mileage of transportation, flat fee;
the server is deployed with the following modules:
the excavator management module is accessed by an administrator terminal and is used for inputting and maintaining excavator information; the project management module is accessed by the administrator terminal and is used for inputting and maintaining project information; the flat transportation management module is accessed by the driver terminal and is used for recording flat transportation information; the refueling record management module is accessed by a driver terminal and is used for recording the refueling information of the excavator; the operation management module is accessed by the driver terminal and the administrator terminal and is used for recording the operation information of the excavator; the driver management module is accessed by the administrator terminal and is used for inputting and maintaining driver information;
the server side is also provided with a statistical analysis module for accessing the database and generating a statistical analysis report; the statistical analysis module comprises:
a project statistical analysis module: the system is used for statistically analyzing the progress and the project gross profit of the specified project according to the server-side database;
the driver statistical analysis module: the system is used for statistically analyzing the total working hours and the total amount of the current month of the appointed driver according to the server-side database; estimating the salary of the appointed driver in the current month according to the set condition;
the oil charging fee statistical analysis module: the system is used for statistically analyzing the oiling condition of the appointed excavator according to the server-side database;
a flat plate statistical analysis module: for statistical analysis of flat panel transportation costs;
enterprise profit analysis module: for statistical analysis of gross profit for a given time period.
2. A digital management method for mining operation comprises the following steps:
A. system initialization
Logging in a server through a manager terminal, and recording and maintaining an excavator database, a project database and a driver database;
logging in a server terminal through a manager terminal, authorizing a specified driver ID, and establishing association of a project ID, the driver ID and a digging ID;
B. refueling management
A driver refuels the excavator, logs in a server terminal through a driver terminal, and records a driver ID, an excavator ID, a refueling date, refueling cost and refueling amount according to actual conditions; the data are written into a fuel filling recording table of the excavator;
C. transportation management
Logging in a server terminal through a driver terminal, and recording a transportation date, a starting place, an arrival place, an excavator ID, a transportation mileage and a flat plate cost; the data are written into a flat plate transportation database;
D. job management
B, the driver logs in the server end by using the driver ID, automatically obtains the project ID and the excavator ID according to the authorization of the manager in the step A, and obtains the operation date from the server;
a driver uses the handheld equipment to shoot a start dial picture and uploads the picture to the server, and the system automatically obtains a start time point on the same day by uploading time; when the operation is finished, the driver shoots a work receiving dial picture and uploads the picture to the server, the system automatically obtains the work receiving time point on the same day according to the uploading time, the driver inputs the work volume on the same day through the driver terminal, and the data are transmitted to the server and written into the excavator work information table;
the administrator terminal logs in the server side, and after confirming the operation information, the administrator signature is written into the excavator operation information table;
E. statistical analysis
And the server side performs statistical analysis and feeds back the statistical analysis to the administrator terminal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811282344.0A CN109460399B (en) | 2018-10-31 | 2018-10-31 | Digital management system and management method for excavation operation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811282344.0A CN109460399B (en) | 2018-10-31 | 2018-10-31 | Digital management system and management method for excavation operation |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109460399A CN109460399A (en) | 2019-03-12 |
| CN109460399B true CN109460399B (en) | 2021-09-28 |
Family
ID=65609064
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811282344.0A Active CN109460399B (en) | 2018-10-31 | 2018-10-31 | Digital management system and management method for excavation operation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109460399B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102938712A (en) * | 2012-11-22 | 2013-02-20 | 邢台供电公司 | Digital operation field management and control system |
| CN203537417U (en) * | 2013-08-13 | 2014-04-09 | 东方浩联（北京）智能科技有限公司 | Intelligent management system of engineering machinery vehicles |
| CN104835029A (en) * | 2015-05-26 | 2015-08-12 | 丹阳飓风物流股份有限公司 | Comprehensive management system for logistics vehicles |
| CN107943823A (en) * | 2017-10-17 | 2018-04-20 | 杨勇 | The real-time big data processing platform of digitlization construction |
| CN108195423A (en) * | 2017-12-26 | 2018-06-22 | 上海岩土工程勘察设计研究院有限公司 | A kind of data integrated system and method for engineering monitoring |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1385806A (en) * | 2001-05-16 | 2002-12-18 | Pc网络大厦株式会社 | Method for managing various engineering of civil construction |
| JP4233932B2 (en) * | 2003-06-19 | 2009-03-04 | 日立建機株式会社 | Work support / management system for work machines |
| CN1648408A (en) * | 2004-09-20 | 2005-08-03 | 张复彦 | Petroleum and natural gas drilling operation monitoring and controlling managing system |
| US20070076228A1 (en) * | 2005-10-04 | 2007-04-05 | Jacob Apelbaum | System and method for providing data services via a network |
| WO2015029229A1 (en) * | 2013-08-30 | 2015-03-05 | 株式会社小松製作所 | Management system and management method for mining machinery |
| JP6419585B2 (en) * | 2015-01-13 | 2018-11-07 | 株式会社小松製作所 | Excavation machine, excavation machine control method and excavation system |
-
2018
- 2018-10-31 CN CN201811282344.0A patent/CN109460399B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102938712A (en) * | 2012-11-22 | 2013-02-20 | 邢台供电公司 | Digital operation field management and control system |
| CN203537417U (en) * | 2013-08-13 | 2014-04-09 | 东方浩联（北京）智能科技有限公司 | Intelligent management system of engineering machinery vehicles |
| CN104835029A (en) * | 2015-05-26 | 2015-08-12 | 丹阳飓风物流股份有限公司 | Comprehensive management system for logistics vehicles |
| CN107943823A (en) * | 2017-10-17 | 2018-04-20 | 杨勇 | The real-time big data processing platform of digitlization construction |
| CN108195423A (en) * | 2017-12-26 | 2018-06-22 | 上海岩土工程勘察设计研究院有限公司 | A kind of data integrated system and method for engineering monitoring |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109460399A (en) | 2019-03-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6144726A (en) | Telecommunications access cost management system | |
| US20010042032A1 (en) | System for capturing, processing, tracking and reporting time and expense data | |
| US20030144930A1 (en) | Methods and systems for managing tax audit information | |
| CN113094794B (en) | Automatic metering and accounting method and system based on BIM and GIS technology | |
| CN104299105A (en) | Credit data management system supporting complex enterprise environment and credit data management method | |
| US20130179315A1 (en) | Time and Attendance System and Method | |
| CN111274774A (en) | Industrial building engineering full-process automatic management system | |
| US20130024437A1 (en) | Activity recordal method and system | |
| CN112488693A (en) | Charging operation platform based on SAAS mode | |
| CN115600965A (en) | General contract project comprehensive management and control system and method based on cooperative management | |
| CN111652699A (en) | Data transmission method for tax receipt system | |
| CN111178843A (en) | Supervision and early warning method and device for worker wage distribution | |
| CN109460399B (en) | Digital management system and management method for excavation operation | |
| CN113902416A (en) | Method for managing whole process of building information assets and related equipment | |
| US20010047316A1 (en) | Module for the interconnectivity of independent software applications | |
| US20140089149A1 (en) | Mass reversal of documents based on reversal tasks and reversal triggers | |
| CN116128268A (en) | On-site digital management system applied to general industry | |
| CN113934406B (en) | Power engineering audit system and method for developing intelligent flow based on iteration increment mode | |
| US20130117167A1 (en) | Intellectual asset time and expense entry management | |
| binti Mohamad et al. | MyBI: A Business Intelligence application development framework for Malaysian public sector | |
| CN111950985A (en) | Cost control method and device, computer equipment and storage medium | |
| Nasir et al. | Automating a modified personal software process | |
| US8635095B2 (en) | Method and apparatus for tracking an intent | |
| CN102289746A (en) | Method and system for implementing plan, implementation and evaluation management planning and converting experiences | |
| CN112633523B (en) | Waste cleaning platform and service integration method thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |