CN110990457A - Production report management system - Google Patents
Production report management system Download PDFInfo
- Publication number
- CN110990457A CN110990457A CN201911208083.2A CN201911208083A CN110990457A CN 110990457 A CN110990457 A CN 110990457A CN 201911208083 A CN201911208083 A CN 201911208083A CN 110990457 A CN110990457 A CN 110990457A
- Authority
- CN
- China
- Prior art keywords
- production
- production line
- information
- report
- station
- 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.)
- Withdrawn
Links
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 189
- 230000002354 daily effect Effects 0.000 claims description 23
- 230000003203 everyday effect Effects 0.000 claims description 4
- 238000012797 qualification Methods 0.000 claims 2
- 230000015572 biosynthetic process Effects 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000000034 method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000003908 quality control method Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- 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
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Probability & Statistics with Applications (AREA)
- Business, Economics & Management (AREA)
- General Health & Medical Sciences (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Manufacturing & Machinery (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- General Factory Administration (AREA)
Abstract
A production report management system belongs to the technical field of production and manufacturing management. Aiming at the problems of incomplete statistics and poor authenticity of the existing production line raw data statistics report forms due to manual statistics, all stations of the production line respectively send production information of the stations and real-time states of equipment corresponding to the stations to a main server through an operation host; the database stores production information of each station of the production line and real-time state information of equipment corresponding to each station, the daily production report module calls the production information of each station on the daily production line and the real-time state of equipment corresponding to each station of the production line in the input time interval from the production line SQL database, the production information of the production line is counted, the monthly production report module obtains the production information of the production line from the daily production report module by taking a natural month as a unit, the monthly production information of the production line equipment is counted, and the daily production report or the monthly production report is exported by the report exporting module. The invention is suitable for making production reports.
Description
Technical Field
The invention relates to a production report management system, and belongs to the technical field of production and manufacturing management.
Background
At present, most of production manufacturing enterprises still stop in traditional production mode, and production statement needs personnel to make statistics of, compile and analyze, and the timeliness of its mode is relatively poor, and statistics personnel's work load is great, and data statistics is not comprehensive enough and the authenticity of statistics data is not strong simultaneously, and the incomplete problem of data statistics appears easily, and these problems derive the timeliness of product quality management and control and the increase scheduling problem of personnel's input cost.
Disclosure of Invention
Aiming at the problems of incomplete statistics and poor authenticity of the existing production line production data statistical report adopting manual statistics, the production report management system is provided.
The invention relates to a production report management system, which comprises a main server 3 and an operation host 2 connected with each station 1 of a production line;
each station 1 of the production line respectively sends the production information of the station 1 and the real-time state of the equipment corresponding to the station 1 to a main server 3 through an operation host 2;
the host server comprises a production line SQL database 34, wherein the database is used for storing production information of each station 1 of the production line and real-time state information of equipment corresponding to each station 1;
the main server 3 further comprises a daily production report module 31, a monthly production report module 32 and a report exporting module 33;
the daily production report module 31 is used for providing an input port of a retrieval interval for an operator, calling the production information of each station 1 on the production line and the real-time state of the equipment corresponding to each station 1 of the production line every day in the input time interval from the SQL database of the production line, counting the production information of the production line and displaying the production information;
the month production report module 32 is used for acquiring production information of the production line from the daily production report module 31, counting by taking a natural month as a unit, and acquiring month production state information of the production line; and counting and displaying;
the report export module 33 is used for providing export time input ports for operators, and exporting daily production reports or monthly production reports according to the time input by the export time input ports.
Further, the production information of each station 1 comprises the type, model, production date, production order number, qualified product quantity and unqualified product quantity of the product produced by each station 1;
the production information of the production line comprises production line starting time, production line stopping time, production starting time, production ending time, completion quantity, qualified quantity and qualified rate information.
Further, the daily production report module 31 is further configured to retrieve the number of unqualified products generated at each station 1 from the SQL database of the production line, calculate the product failure rate of each station, and display the number of unqualified products and the product failure rate.
Further, the daily production report module 31 is further configured to retrieve the name of the unqualified item of the unqualified product and the number of the unqualified product of each item from the SQL database of the production line.
Further, the monthly production status information of the production line includes production days, usage rate, number of types of products produced, number of products, qualified number of products, and qualified rate information of products of the production line per month.
Further, the monthly production report module 32 is further configured to retrieve the product failure rate and the product failure number of each station from the daily production report module 31 in a unit of natural months, and display the number of failed products and the product failure rate.
The invention adopts a mode of directly calling data from the SQL database of the main server production line to extract the tabular data, thereby effectively avoiding the problem of missing statistics in the data statistics process, effectively improving the authenticity of the data, and simultaneously adopting a daily production report module to directly carry out the statistical display of the report data, and effectively improving the accuracy of the report.
Drawings
FIG. 1 is a schematic block diagram of an intelligent management system for a production line according to the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the embodiments and features of the embodiments may be combined with each other without conflict.
The invention is further described with reference to the following drawings and specific examples, which are not intended to be limiting.
The first embodiment is as follows: the present embodiment is described below with reference to fig. 1, and the system for managing production reports in the present embodiment includes a main server 3 and an operation host 2 connected to each station 1 of a production line;
each station 1 of the production line respectively sends the production information of the station 1 and the real-time state of the equipment corresponding to the station 1 to a main server 3 through an operation host 2;
the host server comprises a production line SQL database (34) which is used for storing production information of each station 1 of the production line and real-time state information of equipment corresponding to each station 1;
the main server 3 further comprises a daily production report module 31, a monthly production report module 32 and a report exporting module 33;
the daily production report module 31 is used for providing an input port of a retrieval interval for an operator, calling the production information of each station 1 on the production line and the real-time state of the equipment corresponding to each station 1 of the production line every day in the input time interval from the SQL database of the production line, counting the production information of the production line and displaying the production information; the search interval input port provided by the operator according to the present embodiment is used to input a time interval in which a report needs to be searched, for example, … … from 1 month 3 to 1 month 6, and from 2 month 12 to 2 month 25.
The month production report module 32 is used for acquiring production information of the production line from the daily production report module 31, counting by taking a natural month as a unit, and acquiring month production state information of the production line; and counting and displaying;
the report export module 33 is used for providing export time input ports for operators, and exporting daily production reports or monthly production reports according to the time input by the export time input ports. The export time input port is used for inputting a time interval or a monthly report of a month in which the report needs to be exported.
Further, the production information of each station 1 comprises the type, model, production date, production order number, qualified product quantity and unqualified product quantity of the product produced by each station 1;
the production information of the production line comprises production line starting time, production line stopping time, production starting time, production ending time, completion quantity, qualified quantity and qualified rate information.
Further, the production state information of the production line includes production line startup time, production line shutdown time, production start time, production end time, completion number, qualified number, and qualified rate information.
Further, the daily production report module 31 is further configured to retrieve the number of unqualified products generated by each station 1 from the SQL database of the production line, calculate the product failure rate of each station, and display the number of unqualified products and the product failure rate.
Further, the daily production report module 31 is further configured to retrieve the name of the unqualified item of the unqualified product and the number of the unqualified product of each item from the SQL database of the production line.
Further, the monthly production status information of the production line also includes production days, usage rate, types of products, quantity of products, qualified quantity of products, and qualified rate information of the products of the production equipment of the production line per month.
The monthly production status information of the production line in this embodiment is obtained by counting the number of types, the number of products, the qualified number of products, and the qualified rate of products of each station of the production line produced every day, which are extracted from the daily production report module 31.
Further, the monthly production report module 32 is further configured to retrieve the product failure rate and the product failure number of each station from the daily production report module 31 in a unit of natural months, and display the number of failed products and the product failure rate.
The principle of the table formation of the report is that different production information displayed at different positions of the table is realized in a java statement mode, for example, if a certain position in the table is required to display production quantity, data in a database is called through the java statement, and a result is displayed in the table after statistics. Therefore, the workload and the personnel cost of production statistical personnel are reduced, the comprehensiveness, the objectivity, the authenticity and the effectiveness of statistical data are enhanced, and the basic guarantee is provided for the product quality control.
Although the invention herein has been described with reference to particular embodiments, it is to be understood that these embodiments are merely illustrative of the principles and applications of the present invention. It is therefore to be understood that numerous modifications may be made to the illustrative embodiments and that other arrangements may be devised without departing from the spirit and scope of the present invention as defined by the appended claims. It should be understood that features described in different dependent claims and herein may be combined in ways different from those described in the original claims. It is also to be understood that features described in connection with individual embodiments may be used in other described embodiments.
Claims (7)
1. A production report management system is characterized by comprising a main server (3) and an operation host (2) connected with each station (1) of a production line;
each station (1) of the production line respectively sends the production information of the station (1) and the real-time state of the equipment corresponding to the station (1) to a main server (3) through an operation host (2);
the host server comprises a production line SQL database (34), wherein the production line SQL database (34) is used for storing production information of each station (1) of the production line and real-time state information of equipment corresponding to each station (1);
the main server (3) also comprises a daily production report module (31), a monthly production report module (32) and a report export module (33);
the daily production report module (31) is used for providing an input port of a retrieval interval for operators, calling the production information of each station (1) on the production line and the real-time state of equipment corresponding to each station (1) of the production line every day in the input time interval from the SQL database of the production line, counting the production information of the production line and displaying the production information;
the monthly production report module (32) is used for acquiring the production information of the production line from the daily production report module (31), counting by taking a natural month as a unit and acquiring monthly production state information of the production line; and counting and displaying;
the report exporting module (33) is used for providing an export time input port for operators and exporting daily production reports or monthly production reports according to the time input by the export time input port.
2. A production report management system according to claim 1, characterized in that the production information of each workstation (1) comprises the type, model, production date, production order number, qualified product number and unqualified product number of the product produced by each workstation (1).
3. The system according to claim 1 or 2, wherein the production status information of the production line includes line start time, line stop time, production start time, production end time, completion quantity, qualification quantity, and qualification rate information.
4. The production report management system according to claim 1 or 2, wherein the daily production report module (31) is further configured to retrieve the number of unqualified products produced by each workstation (1) from the SQL database of the production line, calculate the product failure rate of each workstation, and display the number of unqualified products and the product failure rate.
5. A production report management system according to claim 1 or 2, characterized in that the daily production report module (31) is further configured to retrieve the names of the unqualified items of the unqualified products and the number of the unqualified products in each item from the SQL database of the production line.
6. The system according to claim 1 or 2, wherein the monthly production status information of the production line further includes production days, usage rate, type of products produced, quantity of products, quantity of qualified products, and product qualified rate information of the production equipment per monthly production line.
7. The production report management system according to claim 4, wherein the monthly production report module (32) is further configured to retrieve the product failure rate and the product failure rate of each workstation from the daily production report module (31) in units of natural months, and display the number of failed products and the product failure rate.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911208083.2A CN110990457A (en) | 2019-11-30 | 2019-11-30 | Production report management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911208083.2A CN110990457A (en) | 2019-11-30 | 2019-11-30 | Production report management system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110990457A true CN110990457A (en) | 2020-04-10 |
Family
ID=70088979
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911208083.2A Withdrawn CN110990457A (en) | 2019-11-30 | 2019-11-30 | Production report management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110990457A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102081809A (en) * | 2010-12-17 | 2011-06-01 | 武汉钢铁(集团)公司 | Method for automatically recording production line dispatching management information |
| CN103513178A (en) * | 2013-06-28 | 2014-01-15 | 上海工程技术大学 | Breaker detecting and assembly line production management system |
| CN104008201A (en) * | 2014-06-16 | 2014-08-27 | 安徽工业大学 | Numerical control machine tool production information obtaining method |
| CN104793595A (en) * | 2015-04-09 | 2015-07-22 | 江南大学 | Real-time data acquisition system of wheat processing factory |
| CN105550829A (en) * | 2016-01-31 | 2016-05-04 | 谢飞 | Intelligent enterprise process management system |
-
2019
- 2019-11-30 CN CN201911208083.2A patent/CN110990457A/en not_active Withdrawn
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102081809A (en) * | 2010-12-17 | 2011-06-01 | 武汉钢铁(集团)公司 | Method for automatically recording production line dispatching management information |
| CN103513178A (en) * | 2013-06-28 | 2014-01-15 | 上海工程技术大学 | Breaker detecting and assembly line production management system |
| CN104008201A (en) * | 2014-06-16 | 2014-08-27 | 安徽工业大学 | Numerical control machine tool production information obtaining method |
| CN104793595A (en) * | 2015-04-09 | 2015-07-22 | 江南大学 | Real-time data acquisition system of wheat processing factory |
| CN105550829A (en) * | 2016-01-31 | 2016-05-04 | 谢飞 | Intelligent enterprise process management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109284312A (en) | A kind of heterogeneous database change real-time informing method | |
| CN109446246A (en) | A kind of real time data reporting system and generation method | |
| CN105573892A (en) | Business data batch processing method and system | |
| CN112231362A (en) | Visual monitoring application system based on power grid main data service log | |
| CN113642299A (en) | One-key generation method based on power grid statistical form | |
| CN111352982A (en) | Manpower extraction analysis system based on big data | |
| CN111241055A (en) | Processing system of iron and steel enterprise data center heterogeneous data | |
| CN110990457A (en) | Production report management system | |
| CN109508793A (en) | A kind of textile machine equipment operational system | |
| CN107943835A (en) | It is a kind of to report and submit data analysis and taxis system for electric system | |
| CN102306349A (en) | System for analysis on terminal operation on customer site | |
| CN111580462A (en) | Cutter consumption management system and method | |
| CN114428812A (en) | Report data monitoring method, device, equipment and storage medium | |
| CN107247715A (en) | The synchronous method of WMS systems and ERP system | |
| CN111768177B (en) | County-level power supply company operation analysis system and county-level power supply company operation analysis method | |
| CN114676201A (en) | Data mart framework | |
| CN112329956B (en) | Power distribution cabinet comprehensive monitoring system based on network | |
| CN101393443A (en) | Intelligently counting and network monitoring management device for producing medicament | |
| CN102890795A (en) | System and method for accounting production working hours of workshop | |
| CN112258151A (en) | Reconciliation method and device based on pandas, computer equipment and storage medium | |
| CN113852196A (en) | Power supply system data management system | |
| CN112329410A (en) | Graphical report batch generation tool | |
| CN112258175A (en) | Cloud platform-based electric power market electric charge settlement data supervision platform and use method thereof | |
| CN112003369A (en) | Cloud platform based power grid automation equipment operation monitoring and statistical analysis method | |
| CN110568828A (en) | flexible production line control system based on PLC (programmable logic controller) product tracing and statistics |
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 | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20200410 |
|
| WW01 | Invention patent application withdrawn after publication |