CN112365360A - Cigarette production line material consumption statistical calculation method - Google Patents
Cigarette production line material consumption statistical calculation method Download PDFInfo
- Publication number
- CN112365360A CN112365360A CN202011157452.2A CN202011157452A CN112365360A CN 112365360 A CN112365360 A CN 112365360A CN 202011157452 A CN202011157452 A CN 202011157452A CN 112365360 A CN112365360 A CN 112365360A
- Authority
- CN
- China
- Prior art keywords
- server
- client
- program
- material consumption
- data
- 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.)
- Granted
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
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- 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
-
- 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)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Primary Health Care (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- General Health & Medical Sciences (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Economics (AREA)
- Human Resources & Organizations (AREA)
- Health & Medical Sciences (AREA)
- Manufacturing & Machinery (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a material consumption statistical calculation method for a cigarette production line, which comprises the following steps: establishing communication connection between a server and a plurality of clients; starting at least one client; importing first material consumption data filled in at least one client into a server, or manually inputting second material consumption data corresponding to the client into the server; and the server calculates the first material consumption data and/or the second material consumption data corresponding to each client to obtain a material consumption statistical calculation result. According to the cigarette production line material consumption statistical calculation method, the server side which is in communication connection with the plurality of client sides is utilized to calculate the material consumption data corresponding to each client side to obtain the material consumption statistical calculation result, and the cigarette production line material consumption statistical calculation can be automatically carried out, so that the cigarette production line material consumption statistical calculation process can be simplified, the data entry efficiency, the data calculation accuracy and the data analysis convenience are improved, and the working efficiency is greatly improved.
Description
Technical Field
The invention relates to the technical field of material consumption statistical analysis in the cigarette production process, in particular to a material consumption statistical calculation method for a cigarette production line.
Background
The main materials used by the cigarette production line comprise tobacco shreds, cigarette paper, tipping paper, lining paper, paperboard, trademark paper and the like, the material consumption of a single box is often used as a comparison basis when the using condition of the unit materials of the cigarette production line is checked, and the calculation method is that the ratio of the number of single materials actually used to the output is calculated. The data needed to be used when calculating the actually used non-tobacco material are as follows: the data needed when the actual consumption of the tobacco shreds is calculated comprise the following data: the amount of tobacco shreds of unqualified products rejected in the class, the amount of residual tobacco shreds caused by the starting, stopping or abnormity of the cigarette making machine in the class, the amount of tobacco powder produced by equipment in the class, the amount of tobacco shreds in oil-stained cigarettes in the class, the amount of tobacco stems rejected in the class, the amount of residual tobacco shreds rejected by a packing machine in the class, the amount of tobacco shreds in products with quality problems discovered in the class and the yield in the class. The method for acquiring the related data of the non-tobacco shred materials comprises the steps that a material list is filled by a crew member when the production is finished; the method for acquiring the non-tobacco stem related data in the tobacco shreds comprises the steps that designated workers actually weigh the removed products in different removing barrels, the tobacco stem amount is acquired by measuring the tobacco stem amount through fixed production, and the result is calculated according to the ratio.
For the processing of the above data, at present, a statistics clerk usually makes a function table according to a calculation formula, and then performs calculation after inputting data. Because the brands are various, the calculation process needs conversion of many numerical units and calculation of intermediate values, different brands correspond to different tables, and a large number of tables need to be made by a statist, which undoubtedly increases the calculation error probability. In addition, as the number of units is large, the workload of data entry of a counter is also large, and the probability of data entry errors is increased. Moreover, since the tables are numerous, there are also inconveniences when analyzing the data of the calculated results. Therefore, the traditional cigarette production line has the disadvantages of complicated material consumption calculation process, low efficiency and high error rate.
Therefore, a material consumption statistical calculation method for a cigarette production line is needed.
Disclosure of Invention
The invention aims to provide a material consumption statistical calculation method for a cigarette production line, which aims to solve the problems in the prior art, simplify the material consumption statistical calculation process, improve the data accuracy and improve the convenience of data analysis.
The invention provides a material consumption statistical calculation method for a cigarette production line, which comprises the following steps:
establishing communication connection between a server and a plurality of clients;
starting at least one client;
importing first consumable data filled in at least one client to the server, or manually inputting second consumable data corresponding to at least one client in the server;
and the server calculates the first material consumption data and/or the second material consumption data corresponding to each client to obtain a material consumption statistical calculation result.
The method for calculating the material consumption statistics of the cigarette production line preferably establishes communication connection between a server and a plurality of clients, and specifically comprises the following steps:
installing a server program on a server computer corresponding to the server, and installing a client program on a client industrial computer corresponding to the client;
configuring a server address in a client communication module corresponding to the client program, and configuring a client address in a server communication module corresponding to the server;
and connecting the server with each client by using a network cable.
The method for calculating material consumption statistics of a cigarette production line as described above, wherein preferably, the starting at least one of the clients includes:
starting the client program;
the client program judges whether the client communication configuration file is empty;
if the client communication configuration file is not empty, the client program reads the client communication configuration file;
if the client communication configuration file is empty, the client program prompts information of communication unconfiguration to a user so as to prompt the user to carry out communication configuration;
if the user confirms that the communication configuration is not carried out, closing the client program;
and if the user carries out communication configuration, the client program opens a client communication configuration module corresponding to the client program to carry out communication configuration.
The method for calculating material consumption statistics of a cigarette production line as described above, wherein preferably, the starting at least one of the clients further includes:
after the client program successfully reads the client communication configuration file, sending information containing the client address to the server program;
after receiving the information containing the client address, the server program sends feedback information to the client program;
after receiving the feedback information, the client program enters an operating state;
if the client program does not receive the feedback information, the client program can send out an information prompt that communication with the server is not established, and enters a standby state;
when the client program is in a standby state, the information containing the client address is sent to the server program at intervals of preset time;
and after receiving the feedback information from the server program, the client program enters an operating state.
The method for calculating material consumption statistics of a cigarette production line as described above, wherein preferably, the importing the first material consumption data filled in on at least one of the clients into the server, or manually entering the second material consumption data corresponding to at least one of the clients into the server, specifically includes:
under the condition that the server program starts a manual mode, the server program is opened to manually input second consumption data;
under the condition that the server program starts an automatic mode, filling first material consumption data in at least one client;
judging whether the communication configuration file of the server side is empty or not;
if the server communication configuration file is empty, the server program prompts the information of communication unconfiguration to a statistician so as to prompt the statistician to carry out communication configuration;
if the statistics personnel confirm that the communication configuration is not carried out, the server program is closed;
if the statistics staff carries out communication configuration, the server program opens a server communication configuration module corresponding to the server program to carry out communication configuration;
if the server-side communication configuration file is not empty, the server-side program reads the server-side communication configuration file, and after the server-side program successfully reads the server-side communication configuration file, the server-side program receives the first material consumption data sent from the client-side program, and if the server-side program does not receive the first material consumption data, the server-side program is in a waiting state.
The method for calculating material consumption statistics of a cigarette production line as described above, wherein preferably, the receiving, by the server program, the first material consumption data sent from the client program specifically includes:
filling the first material consumption data in the client program, wherein the first material consumption data at least comprises the material quantity;
after the first material consumption data is filled, summarizing the currently filled information, and judging whether the currently filled information has information needing to be modified;
if the information needing to be modified exists in the currently filled information, the client program returns to a material quantity filling interface;
if the information needing to be modified does not exist in the current filled information, the client program sends the first material consumption data to the server program;
and under the condition that the client program sends the first material consumption data to the server program, the client program receives sending result feedback information sent by the server.
The method for calculating material consumption statistics of a cigarette production line as described above, wherein preferably, if there is no information to be modified in the currently filled information, the client program sends the first material consumption data to the server program, and specifically includes:
under the condition that information needing to be modified does not exist in the current filled information, the client program sends the first material consumption data to the server program, and in the data sending process, the client program judges whether the data information of the first material consumption data is empty or not;
if the data information is empty, the client program prompts the user of information that the data cannot be empty, and the client program stops sending the information;
and if the data information is not empty, the client program allows the first material consumption data to be sent.
The method for calculating the material consumption statistics of the cigarette production line preferably includes that the client program receives feedback information of the sending result sent by the server, and specifically includes:
after the client program transmits the first material consumption data to the server program, waiting for sending result feedback information after the data sent by the server program is sent;
if the client program receives the sending result feedback information within the preset time, the client program prompts information to a user to send information successfully;
and if the waiting time exceeds the preset time, the client program prompts the user of information sending failure information.
The method for calculating the material consumption statistics of the cigarette production line preferably includes the following steps that the server calculates the first material consumption data and/or the second material consumption data corresponding to each client to obtain a material consumption statistics calculation result:
after receiving the first material consumption data, the server program sends feedback information of successful information sending to the client program, and simultaneously generates a data receiving record in a history record file;
the server program preprocesses the first material consumption data and/or the second material consumption data to determine current material data of a current date of a current machine number calculated by the server program;
the server program judges whether all the currently acquired data meet the calculation requirements;
if all the currently acquired data meet the calculation requirements, the server program calculates a final result and stores the final result and the acquired data into a database;
and if all the currently acquired data do not meet the calculation requirements, the server program stores the currently acquired data into the database.
The method for calculating the material consumption statistics of the cigarette production line preferably includes the following steps that the server calculates the first material consumption data and/or the second material consumption data corresponding to each client to obtain a material consumption statistical calculation result:
before storing the final result and the acquired data or the currently acquired data into a database, the server program reads the database to judge whether a data record of the current material of the current machine with the current date exists in the database;
if the data record exists, the server program carries out data modification operation on the database;
and if the data record does not exist, the server program performs addition operation of new data record on the database.
The invention provides a material consumption statistical calculation method for a cigarette production line, which is characterized in that a server side which is in communication connection with a plurality of client sides is utilized to calculate material consumption data corresponding to each client side to obtain a material consumption statistical calculation result, and the material consumption statistical calculation of the cigarette production line can be automatically carried out, so that the material consumption statistical calculation process of the cigarette production line can be simplified, the data entry efficiency, the data calculation accuracy and the data analysis convenience are improved, and the working efficiency is greatly improved.
Drawings
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be further described with reference to the accompanying drawings, in which:
FIG. 1 is a flow chart of an embodiment of a material consumption statistical calculation method for a cigarette production line according to the present invention;
FIG. 2 is a flowchart of an algorithm of a client program according to an embodiment of the method for calculating the material consumption statistics of the cigarette production line provided by the invention
Fig. 3 is an algorithm flowchart of a server program according to an embodiment of the method for calculating the material consumption statistics of the cigarette production line provided by the invention.
Detailed Description
Various exemplary embodiments of the present disclosure will now be described in detail with reference to the accompanying drawings. The description of the exemplary embodiments is merely illustrative and is in no way intended to limit the disclosure, its application, or uses. The present disclosure may be embodied in many different forms and is not limited to the embodiments described herein. These embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art. It should be noted that: the relative arrangement of parts and steps, the composition of materials, numerical expressions and numerical values set forth in these embodiments are to be construed as merely illustrative, and not as limitative, unless specifically stated otherwise.
As used in this disclosure, "first", "second": and the like, do not denote any order, quantity, or importance, but rather are used to distinguish one element from another. The word "comprising" or "comprises", and the like, means that the element preceding the word covers the element listed after the word, and does not exclude the possibility that other elements are also covered. "upper", "lower", and the like are used merely to indicate relative positional relationships, and when the absolute position of the object being described is changed, the relative positional relationships may also be changed accordingly.
In the present disclosure, when a specific component is described as being located between a first component and a second component, there may or may not be intervening components between the specific component and the first component or the second component. When it is described that a specific component is connected to other components, the specific component may be directly connected to the other components without having an intervening component, or may be directly connected to the other components without having an intervening component.
All terms (including technical or scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this disclosure belongs unless specifically defined otherwise. It will be further understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the relevant art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein.
Techniques, methods, and apparatus known to those of ordinary skill in the relevant art may not be discussed in detail, but are intended to be part of the specification where appropriate.
As shown in fig. 1 to fig. 3, the method for calculating the material consumption statistics of the cigarette production line provided by this embodiment specifically includes the following steps in an actual execution process:
and step S1, establishing communication connection between one server and a plurality of clients.
Wherein, the user of the server is a statistics person, and the user of the client is an operator of the cigarette production line. It should be noted that the number of clients connected to one server is not specifically limited in the present invention. In an embodiment of the method for calculating material consumption statistics in a cigarette production line of the present invention, the step S1 may specifically include:
and step S11, installing a server program on the server computer corresponding to the server, and installing a client program on the client industrial computer corresponding to the client.
Step S12, configuring a server address in the client communication module corresponding to the client program, and configuring a client address in the server communication module corresponding to the server.
And step S13, connecting the server with each client by using a network cable.
And step S2, starting at least one client.
In an embodiment of the method for calculating material consumption statistics in a cigarette production line of the present invention, the step S2 may specifically include:
and step S21, starting the client program.
Step S22, the client program determines whether the client communication profile is empty.
Step S23, if the client communication configuration file is not empty, the client program reads the client communication configuration file.
And step S24, if the client communication configuration file is empty, the client program prompts the user of information that the communication is not configured so as to prompt the user to carry out communication configuration.
And step S25, if the user confirms that the communication configuration is not carried out, closing the client program.
Step S26, if the user performs communication configuration, the client opens a client communication configuration module corresponding to the client to perform communication configuration.
After the client program is started, the client program firstly judges whether the communication configuration file is empty, and if the communication configuration file is empty, the client program prompts a user to' not configure communication! If the user confirms that the configuration is not performed, the client program is closed, and if the user needs the configuration, the client program communication configuration module is opened by the program.
Further, in an embodiment of the method for calculating the material consumption statistics in the cigarette production line of the present invention, the step S2 may further include:
step S27, after the client program successfully reads the client communication configuration file, sending information containing the client address to the server program;
step S28, after receiving the information containing the client address, the server program sends feedback information to the client program;
step S29, the client program enters into the running state after receiving the feedback information;
step S210, if the client program does not receive the feedback information, the client program sends out an information prompt that communication with a server is not established yet, and enters a standby state;
step S211, when the client program is in a standby state, sending the information including the client address to the server program at preset time intervals;
step S212, after receiving the feedback information from the server program, the client program enters an operating state.
After the client program successfully reads the communication configuration file, the client program firstly reports the information containing the address of the client to the server program, the server program feeds back the fact that the starting information is received to the client program after receiving the information, the client program enters an operating state after receiving the feedback information, and if the feedback information is not received, the client program sends out a message prompt that the communication with the server is not established, and enters a standby state. And when the client program is in a standby state, the client program sends information to the server program at intervals, and once feedback from the server program is received, the client program enters an operating state.
Step S3, importing the first consumable data filled in on at least one of the clients into the server, or manually entering second consumable data corresponding to at least one of the clients into the server;
in an embodiment of the method for calculating material consumption statistics in a cigarette production line of the present invention, the step S3 may specifically include: the method specifically comprises the following steps:
step S31, under the condition that the server program starts a manual mode, the server program is opened to manually input second consumption data;
after the administrator correctly inputs the account password, the administrator can enter a page for manually inputting data by selecting the material consumption data input module.
Step S32, filling first material consumption data on at least one client under the condition that the server program starts an automatic mode;
step S33, judging whether the server communication configuration file is empty;
step S34, if the server communication configuration file is empty, the server program prompts the information that the communication is not configured to the statistician so as to prompt the statistician to carry out communication configuration;
step S35, if the statistics personnel confirm that the communication configuration is not carried out, the server program is closed;
step S36, if the statistics personnel carry out communication configuration, the server program opens a server communication configuration module corresponding to the server program for communication configuration;
step S37, if the server communication configuration file is not empty, the server program reads the server communication configuration file, and after the server program successfully reads the server communication configuration file, the server program receives the first material consumption data sent from the client program, and if the server program does not receive the first material consumption data, the server program is in a waiting state.
The server program has a manual mode and an automatic mode, and data can be directly input after the server program is opened in the manual mode. After the automatic mode is started, the server program firstly judges whether the communication configuration file is empty, if the communication configuration file is empty, the user is prompted to carry out configuration, if the user does not carry out configuration at present, the program is closed, and if the user configures, the program opens a communication configuration module of the server program to carry out communication configuration. After the server program successfully reads the communication configuration file, if the data is not received, the server program is in a waiting state.
In an embodiment of the method for calculating material consumption statistics in a cigarette production line, the step S37 of receiving, by the server program, the first material consumption data sent from the client program may specifically include:
step S37-1, filling the first material consumption data in the client program, wherein the first material consumption data at least comprises the material quantity;
wherein the filling of the first material consumption data in the client program specifically includes:
step S37-1-1, selecting the type of equipment;
step S37-1-2, filling corresponding material quantity;
and S37-1-3, selecting the date of the data to be reported.
And clicking the client program on the client industrial computing to select the equipment type on the cigarette production line, filling the corresponding material quantity, and selecting the date of the data to be reported, wherein the date default value is the current day.
And step S37-2, after the first consumable data is completely filled, summarizing the currently filled information, and determining whether there is information to be modified in the currently filled information.
And step S37-3, if the information needing to be modified exists in the currently filled information, returning the client program to a material quantity filling interface.
Step S37-4, if there is no information to be modified in the currently filled information, the client program sends the first material consumption data to the server program.
After the data is filled in, clicking the data to report, popping up an overview dialog box of the currently filled information by the program, and if the information needs to be modified, clicking to cancel, returning the program to a material quantity filling interface; if no modification of the information is needed, the click is determined to send.
In an embodiment of the method for calculating material consumption statistics in a cigarette production line of the present invention, the step S37-4 may specifically include:
step S37-4-1, in a case that there is no information that needs to be modified in the currently filled information, the client program sends the first consumable consumption data to the server program, and in a data sending process, the client program determines whether data information of the first consumable consumption data is empty.
And step S37-4-2, if the data information is empty, the client program prompts the user of information that the data cannot be empty, and the client program stops sending the information.
And step S37-4-3, if the data information is not all empty, allowing the client program to send the first consumption data.
In the data sending process, the client program can judge whether the data information is empty, if so, the client program can pop up a prompt box that the data cannot be empty, and stop sending the information; if not, the client program will allow the data to be sent, and the data information will be transmitted to the server program.
Step S37-5, when the client program sends the first material consumption data to the server program, the client program receives the sending result feedback information sent by the server.
In an embodiment of the method for calculating material consumption statistics in a cigarette production line of the present invention, the step S37-5 may specifically include:
step S37-5-1, after the client program transmits the first material consumption data to the server program, waiting for feedback information of a transmission result after data transmitted by the server program is transmitted;
step S37-5-2, if the client program receives the feedback information of the sending result in the preset time, the client program prompts the user to send the information successfully;
and step S37-5-3, if the waiting time exceeds the preset time, the client program prompts the user to send the information failure information.
After the client program transmits the first material consumption data to the server program, waiting for the feedback of a transmission result after the data is transmitted; if the wait time is out, the client displays "information sending failed! "is the result of; if the information sending success from the server-side program is received! "information feedback, client program feedback information status display" information sent successfully! ".
And step S4, the server calculates the first material consumption data and/or the second material consumption data corresponding to the clients to obtain material consumption statistical calculation results.
In an embodiment of the method for calculating material consumption statistics in a cigarette production line of the present invention, the step S4 may specifically include:
step S41, after receiving the first material consumption data, the server program sends feedback information of successful information sending to the client program, and simultaneously generates a data receiving record in a history record file;
step S42, the server program preprocesses the first material consumption data and/or the second material consumption data to determine current material data of the current date of the current machine station number calculated by the server program;
step S43, the server program judges whether all the currently acquired data meet the calculation requirements;
the judgment standard for judging whether the data meet the calculation requirements is whether the data required in a calculation formula for calculating certain material consumption statistics are comprehensive. Taking the material consumption statistics of the non-tobacco material actually used as an example, the data needed in the calculation formula is as follows: the rest materials of the previous team, the coming materials of the team, the returning materials of the team, the rest materials of the team and the yield of the team. Therefore, as long as the currently acquired data contains the data, the server program calculates the calculation result of the material consumption statistics of the non-tobacco material. In operation, the server program refreshes data all the time, and performs circular scanning calculation, and as long as the server program obtains all the data required for calculating a certain material consumption statistic, the calculation result of the material consumption statistic is obtained through calculation. Therefore, calculation is not needed one by one, an intermediate flow is omitted, the calculation time can be greatly saved, the material consumption statistical calculation flow of the cigarette production line is simplified, the data entry efficiency is improved, the data calculation is accurate, the data analysis is convenient and fast, and the working efficiency is greatly improved.
Step S44, if all the currently acquired data meet the calculation requirements, the server program calculates the final result and stores the final result and the acquired data into a database;
and step S45, if all the currently acquired data do not meet the calculation requirements, the server program stores the currently acquired data into a database.
After receiving the information, the server side firstly sends the information to the client side, wherein the information is successfully sent! The text information of the' is simultaneously used for generating a data receiving record in a history record file, then the information is processed, the number of a computer which is started by a server side is determined according to the number of a machine corresponding to a production line in the information, the date of the computer number to be calculated by the server side is determined according to the date in the information, the current material data of the current date of the current computer number to be calculated by the server side is determined according to the material data in the information, finally the server side judges whether all the currently acquired data meet the calculation requirement, if so, the server side calculates the final result and stores the result and the acquired data into a database file; if the calculation requirements are not met, the server program only stores the currently acquired data into the database file.
Further, in an embodiment of the method for calculating the material consumption statistics in the cigarette production line of the present invention, the step S4 may further include:
step S46, before the server program stores the final result and the acquired data or the currently acquired data in a database, the server program performs a reading operation on the database to determine whether a data record of the current material of the current machine with the current date exists in the database;
step S47, if there is data record, the server program carries out data modification operation to the database;
and step S48, if no data record exists, the server program performs an adding operation of new data record on the database.
Before the server accesses data, reading a database in a server computer, judging whether a data record of a current material of a current machine with a current date exists in the database, and if so, modifying the data of the database by a server program; if the record does not exist, the server program can perform addition operation of new data record on the database. When the server program manually inputs data, after an administrator correctly inputs an account password, the administrator selects the material consumption data input module, and then a page for manually inputting the data can be entered, the default date of the page is the current day, the default unit is number 1, if the data under the current screening condition is stored in the database, the material data corresponding to the current page can be directly displayed, and the administrator can add and modify the data.
Further, in an embodiment of the method for calculating the material consumption statistics in the cigarette production line of the present invention, the step S4 may further include:
and step S49, counting the data in the database.
The server program comprises a data statistics module, and after the data statistics module enters the server program, all data records entering the database are displayed in a list form, a curve graph, a line graph, a table and the like, and the display form is visual and is convenient for data comparison. The data records of the database comprise recorded specific data of each material used by each unit to produce different brands of products on different dates; for records that have completed calculations, the server program will display the calculated values in a list.
And S410, screening the data in the database.
The server program data statistics module also has a data screening function, data of a certain day or continuous days can be selected to be independently checked, the screening condition can also be a certain unit or a certain brand, when the screening condition is set, the data can be changed in real time according to the screening condition, the histogram button in the server program data statistics module is clicked, the data histogram display effect after data conversion can be displayed, the copy button on the upper portion of the page is clicked, the current histogram page can be subjected to screenshot and stored in a clipboard of a server computer, and the clipboard content can be directly pasted to picture processing software or office software.
And step S411, exporting the data in the database.
The data statistics module in the server program also has a data export function, when a data export button is clicked, the system can generate a table file named by synthesizing all the data statistics module screening conditions according to the screening conditions set in the server program data statistics module when the data export operation is executed, and after the data export is finished, the table file pops up! "prompt box. And the data in the database is exported, so that a report can be generated under the condition of given screening conditions, and the report is convenient to view.
And step S412, importing the data into the database.
And the data statistics module in the server program also has a data import function, and when a data import button is clicked, the data import page can be accessed, the preview is clicked, the data in the data table can be previewed, and after the data is confirmed to be correct, the click is confirmed, and the system can import the data to the correct position in the database according to the date, the unit, the brand and the material. When equipment fails, the data can be imported into the database, and the data can be supplemented quickly.
According to the cigarette production line material consumption statistical calculation method provided by the embodiment of the invention, the server side which is in communication connection with the plurality of client sides is utilized to calculate the material consumption data corresponding to each client side to obtain the material consumption statistical calculation result, and the material consumption statistical calculation of the cigarette production line can be automatically carried out, so that the material consumption statistical calculation process of the cigarette production line can be simplified, the data entry efficiency, the data calculation accuracy and the data analysis convenience are improved, and the working efficiency is greatly improved.
Thus, various embodiments of the present disclosure have been described in detail. Some details that are well known in the art have not been described in order to avoid obscuring the concepts of the present disclosure. It will be fully apparent to those skilled in the art from the foregoing description how to practice the presently disclosed embodiments.
Although some specific embodiments of the present disclosure have been described in detail by way of example, it should be understood by those skilled in the art that the foregoing examples are for purposes of illustration only and are not intended to limit the scope of the present disclosure. It will be understood by those skilled in the art that various changes may be made in the above embodiments or equivalents may be substituted for elements thereof without departing from the scope and spirit of the present disclosure. The scope of the present disclosure is defined by the appended claims.
Claims (10)
1. A cigarette production line material consumption statistical calculation method is characterized by comprising the following steps:
establishing communication connection between a server and a plurality of clients;
starting at least one client;
importing first consumable data filled in at least one client to the server, or manually inputting second consumable data corresponding to at least one client in the server;
and the server calculates the first material consumption data and/or the second material consumption data corresponding to each client to obtain a material consumption statistical calculation result.
2. The method for calculating the material consumption statistics of the cigarette production line according to claim 1, wherein the establishing of the communication connection between the server and the plurality of clients specifically comprises:
installing a server program on a server computer corresponding to the server, and installing a client program on a client industrial computer corresponding to the client;
configuring a server address in a client communication module corresponding to the client program, and configuring a client address in a server communication module corresponding to the server;
and connecting the server with each client by using a network cable.
3. The cigarette production line material consumption statistical calculation method according to claim 2, wherein the starting at least one of the clients comprises:
starting the client program;
the client program judges whether the client communication configuration file is empty;
if the client communication configuration file is not empty, the client program reads the client communication configuration file;
if the client communication configuration file is empty, the client program prompts information of communication unconfiguration to a user so as to prompt the user to carry out communication configuration;
if the user confirms that the communication configuration is not carried out, closing the client program;
and if the user carries out communication configuration, the client program opens a client communication configuration module corresponding to the client program to carry out communication configuration.
4. The cigarette production line material consumption statistical calculation method according to claim 3, wherein the starting at least one of the clients further comprises:
after the client program successfully reads the client communication configuration file, sending information containing the client address to the server program;
after receiving the information containing the client address, the server program sends feedback information to the client program;
after receiving the feedback information, the client program enters an operating state;
if the client program does not receive the feedback information, the client program can send out an information prompt that communication with the server is not established, and enters a standby state;
when the client program is in a standby state, the information containing the client address is sent to the server program at intervals of preset time;
and after receiving the feedback information from the server program, the client program enters an operating state.
5. The cigarette production line material consumption statistical calculation method according to claim 4, wherein the importing the first material consumption data filled in on at least one of the clients into the server or manually entering the second material consumption data corresponding to at least one of the clients into the server specifically comprises:
under the condition that the server program starts a manual mode, the server program is opened to manually input second consumption data;
under the condition that the server program starts an automatic mode, filling first material consumption data in at least one client;
judging whether the communication configuration file of the server side is empty or not;
if the server communication configuration file is empty, the server program prompts the information of communication unconfiguration to a statistician so as to prompt the statistician to carry out communication configuration;
if the statistics personnel confirm that the communication configuration is not carried out, the server program is closed;
if the statistics staff carries out communication configuration, the server program opens a server communication configuration module corresponding to the server program to carry out communication configuration;
if the server-side communication configuration file is not empty, the server-side program reads the server-side communication configuration file, and after the server-side program successfully reads the server-side communication configuration file, the server-side program receives the first material consumption data sent from the client-side program, and if the server-side program does not receive the first material consumption data, the server-side program is in a waiting state.
6. The material consumption statistical calculation method for the cigarette production line according to claim 5, wherein the server program receives the first material consumption data sent from the client program, and specifically comprises:
filling the first material consumption data in the client program, wherein the first material consumption data at least comprises the material quantity;
after the first material consumption data is filled, summarizing the currently filled information, and judging whether the currently filled information has information needing to be modified;
if the information needing to be modified exists in the currently filled information, the client program returns to a material quantity filling interface;
if the information needing to be modified does not exist in the current filled information, the client program sends the first material consumption data to the server program;
and under the condition that the client program sends the first material consumption data to the server program, the client program receives sending result feedback information sent by the server.
7. The cigarette production line material consumption statistical calculation method according to claim 6, wherein if there is no information to be modified in the currently filled information, the client program sends the first material consumption data to the server program, specifically including:
under the condition that information needing to be modified does not exist in the current filled information, the client program sends the first material consumption data to the server program, and in the data sending process, the client program judges whether the data information of the first material consumption data is empty or not;
if the data information is empty, the client program prompts the user of information that the data cannot be empty, and the client program stops sending the information;
and if the data information is not empty, the client program allows the first material consumption data to be sent.
8. The cigarette production line material consumption statistical calculation method according to claim 6, wherein the client program receives the transmission result feedback information sent by the server, specifically comprising:
after the client program transmits the first material consumption data to the server program, waiting for sending result feedback information after the data sent by the server program is sent;
if the client program receives the sending result feedback information within the preset time, the client program prompts information to a user to send information successfully;
and if the waiting time exceeds the preset time, the client program prompts the user of information sending failure information.
9. The cigarette production line material consumption statistical calculation method according to claim 8, wherein the server calculates the first material consumption data and/or the second material consumption data corresponding to each client to obtain a material consumption statistical calculation result, and specifically comprises:
after receiving the first material consumption data, the server program sends feedback information of successful information sending to the client program, and simultaneously generates a data receiving record in a history record file;
the server program preprocesses the first material consumption data and/or the second material consumption data to determine current material data of a current date of a current machine number calculated by the server program;
the server program judges whether all the currently acquired data meet the calculation requirements;
if all the currently acquired data meet the calculation requirements, the server program calculates a final result and stores the final result and the acquired data into a database;
and if all the currently acquired data do not meet the calculation requirements, the server program stores the currently acquired data into the database.
10. The cigarette production line material consumption statistical calculation method according to claim 9, wherein the server calculates the first material consumption data and/or the second material consumption data corresponding to each client to obtain a material consumption statistical calculation result, further comprising:
before storing the final result and the acquired data or the currently acquired data into a database, the server program reads the database to judge whether a data record of the current material of the current machine with the current date exists in the database;
if the data record exists, the server program carries out data modification operation on the database;
and if the data record does not exist, the server program performs addition operation of new data record on the database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011157452.2A CN112365360B (en) | 2020-10-26 | 2020-10-26 | Material consumption statistical calculation method for cigarette production line |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011157452.2A CN112365360B (en) | 2020-10-26 | 2020-10-26 | Material consumption statistical calculation method for cigarette production line |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112365360A true CN112365360A (en) | 2021-02-12 |
| CN112365360B CN112365360B (en) | 2023-04-28 |
Family
ID=74510474
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011157452.2A Active CN112365360B (en) | 2020-10-26 | 2020-10-26 | Material consumption statistical calculation method for cigarette production line |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112365360B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113220224A (en) * | 2021-04-01 | 2021-08-06 | 海天塑机集团有限公司 | Statistical system and method for production data of injection molding machine |
| CN113421031A (en) * | 2021-07-21 | 2021-09-21 | 红云红河烟草(集团)有限责任公司 | Warning method and system for additional device of cigarette production line |
| CN113955185A (en) * | 2021-10-26 | 2022-01-21 | 浙江中烟工业有限责任公司 | Method for representing tobacco shred loss in rolling procedure through equipment operation parameters |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102255895A (en) * | 2011-06-29 | 2011-11-23 | 北京思创银联科技股份有限公司 | Method and system for data communication between client and server |
| CN103793749A (en) * | 2014-02-27 | 2014-05-14 | 四川物联恒安安全技术研究有限公司 | Safety production comprehensive supervisory platform data transmission method |
| CN108111589A (en) * | 2017-12-15 | 2018-06-01 | 广东工业大学 | Collecting method, device, equipment and computer readable storage medium |
| WO2018109742A1 (en) * | 2016-12-16 | 2018-06-21 | Bsg Wireless Limited | Systems and methods for building and updating a wireless node database service |
| JP2019040507A (en) * | 2017-08-28 | 2019-03-14 | キッコーマン株式会社 | Wine generation system and wine information providing system |
| US20200081720A1 (en) * | 2018-09-12 | 2020-03-12 | Hitachi, Ltd. | Parallel distributed processing control system, program, and parallel distributed processing control method |
-
2020
- 2020-10-26 CN CN202011157452.2A patent/CN112365360B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102255895A (en) * | 2011-06-29 | 2011-11-23 | 北京思创银联科技股份有限公司 | Method and system for data communication between client and server |
| CN103793749A (en) * | 2014-02-27 | 2014-05-14 | 四川物联恒安安全技术研究有限公司 | Safety production comprehensive supervisory platform data transmission method |
| WO2018109742A1 (en) * | 2016-12-16 | 2018-06-21 | Bsg Wireless Limited | Systems and methods for building and updating a wireless node database service |
| JP2019040507A (en) * | 2017-08-28 | 2019-03-14 | キッコーマン株式会社 | Wine generation system and wine information providing system |
| CN108111589A (en) * | 2017-12-15 | 2018-06-01 | 广东工业大学 | Collecting method, device, equipment and computer readable storage medium |
| US20200081720A1 (en) * | 2018-09-12 | 2020-03-12 | Hitachi, Ltd. | Parallel distributed processing control system, program, and parallel distributed processing control method |
Non-Patent Citations (3)
| Title |
|---|
| 孔胜: "多维度卷烟产耗数据分析平台搭建", 《中国科技信息》 * |
| 宋国辉: "卷烟企业MES系统与卷包数采系统接口研究", 《机械工程师》 * |
| 段青娜: "基于RPC框架的辅料配盘信息管理系统", 《微机处理》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113220224A (en) * | 2021-04-01 | 2021-08-06 | 海天塑机集团有限公司 | Statistical system and method for production data of injection molding machine |
| CN113421031A (en) * | 2021-07-21 | 2021-09-21 | 红云红河烟草(集团)有限责任公司 | Warning method and system for additional device of cigarette production line |
| CN113955185A (en) * | 2021-10-26 | 2022-01-21 | 浙江中烟工业有限责任公司 | Method for representing tobacco shred loss in rolling procedure through equipment operation parameters |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112365360B (en) | 2023-04-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112365360A (en) | Cigarette production line material consumption statistical calculation method | |
| US20120117036A1 (en) | Smart address book | |
| US20080320445A1 (en) | Systems and methods for gathering and processing user feedback | |
| CN104484730A (en) | Batching monitoring and tracing method and system | |
| CN111538731B (en) | Automatic report generation system for industrial data | |
| CN108475268A (en) | intellectual property document management system | |
| EP3403199A1 (en) | Multi-technology visual integrated data management and analytics development and deployment environment | |
| US11748662B2 (en) | Contextual modeling using application metadata | |
| CN111026394A (en) | Method for carrying out flow docking by utilizing self-service docking platform | |
| US20050096774A1 (en) | System and method for integrating transactional and real-time manufacturing data | |
| CN111782117A (en) | Interface display method and device, storage medium and electronic device | |
| US20100070893A1 (en) | Data quality administration framework | |
| CN114971693A (en) | Engineering cost consultation management system based on BIM | |
| US10885013B2 (en) | Automated application lifecycle tracking using batch processing | |
| CN111459460B (en) | Service data processing method and system | |
| US20190138921A1 (en) | Interactive guidance system for selecting thermodynamics methods in process simulations | |
| US20140344127A1 (en) | Network-based electronic invoicing system with reverse invoicing | |
| CN111506594A (en) | Big data query platform, management method thereof and data query method | |
| CN114118037A (en) | Intelligent report tool of data management platform | |
| US20220051109A1 (en) | System of intelligence learning agents leveraging expertise capture for work heuristics management | |
| EP3828735A1 (en) | Method, device and system for forming fusion model, medium, processor and terminal | |
| JP5299898B2 (en) | Database generation apparatus, database generation method, and computer program | |
| JP2019095958A (en) | Market condition comment generation assisting device and market condition comment generation assisting method | |
| CN117591487B (en) | Financial document sharing method and related device | |
| US20230351305A1 (en) | Data analysis and reporting systems and methods |
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 |