CN109377184B - Work order opening method, device, storage medium and terminal - Google Patents
Work order opening method, device, storage medium and terminal Download PDFInfo
- Publication number
- CN109377184B CN109377184B CN201811341255.9A CN201811341255A CN109377184B CN 109377184 B CN109377184 B CN 109377184B CN 201811341255 A CN201811341255 A CN 201811341255A CN 109377184 B CN109377184 B CN 109377184B
- Authority
- CN
- China
- Prior art keywords
- work order
- data
- target
- work
- plan
- 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
- 238000000034 method Methods 0.000 title claims abstract description 53
- 239000000463 material Substances 0.000 claims abstract description 56
- 230000008520 organization Effects 0.000 claims abstract description 47
- 230000001960 triggered effect Effects 0.000 claims abstract description 20
- 238000004519 manufacturing process Methods 0.000 claims description 70
- 238000004590 computer program Methods 0.000 claims description 11
- 238000013075 data extraction Methods 0.000 claims description 4
- 238000013479 data entry Methods 0.000 claims description 3
- 238000012216 screening Methods 0.000 claims description 3
- 238000007726 management method Methods 0.000 description 18
- 239000002609 medium Substances 0.000 description 12
- 230000002093 peripheral effect Effects 0.000 description 9
- 238000013439 planning Methods 0.000 description 8
- 230000008901 benefit Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 6
- 239000000284 extract Substances 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 230000006870 function Effects 0.000 description 5
- 230000004048 modification Effects 0.000 description 5
- 238000012986 modification Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 230000008676 import Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000000926 separation method Methods 0.000 description 2
- 230000000007 visual effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000004069 differentiation Effects 0.000 description 1
- 239000012120 mounting media Substances 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008707 rearrangement Effects 0.000 description 1
- 238000013468 resource allocation Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- 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
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Theoretical Computer Science (AREA)
- Economics (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Manufacturing & Machinery (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- General Factory Administration (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the application discloses a worksheet cubing method, a worksheet cubing device, a storage medium and a terminal. The method comprises the following steps: the method comprises the steps of obtaining plan sheet files corresponding to at least two organizations, extracting corresponding work sheet data from the plan sheet files according to work sheet header items contained in a work sheet starting interface, and inputting the corresponding work sheet data in a data area of the work sheet header items in the work sheet starting interface in a row unit mode, wherein each data row corresponds to one material of one organization, and when a work sheet starting event is detected to be triggered, starting the corresponding work sheet according to the selected data row in the data area. By adopting the technical scheme, the work order opening operation can be carried out on the materials aiming at a plurality of organizations on the same work order opening interface, and the work order opening efficiency can be effectively improved.
Description
Technical Field
The embodiment of the application relates to the technical field of computers, in particular to a work order cubing method, a work order cubing device, a storage medium and a terminal.
Background
In the manufacturing industry, a work order is generally needed to facilitate effective management of a manufacturing plan. A work order is understood to be a work document, a manufacturing plan consisting of one or more jobs, which is the basis for the assignment of tasks by higher-level departments and the acceptance of tasks by lower-level departments.
At present, enterprises generally adopt a work order system (also called a work order management system) to realize the functions of setting up and managing work orders, and the work order system can perform targeted management according to the requirements of different organizations, departments or customers. The header in the work order typically contains the organization, i.e., the company to which the work order belongs. An enterprise involving a plurality of manufacturing companies involves a plurality of organizations, and how to efficiently create work orders for the plurality of organizations in a work order system is a problem that needs to be solved.
Disclosure of Invention
The embodiment of the application provides a work order cubing method, a work order cubing device, a storage medium and a terminal, and can optimize a work order cubing scheme.
In a first aspect, an embodiment of the present application provides a work order cubing method, including:
acquiring plan list files corresponding to at least two organizations;
extracting corresponding work order data from the plan order file according to a work order header project contained in a work order opening interface;
inputting corresponding work order data in a data area of the work order header project in a work order opening interface in a row unit, wherein each data row corresponds to one material of one organization;
and when a work order opening event is triggered, opening a corresponding work order according to the selected data row in the data area.
In a second aspect, an embodiment of the present application provides a work order opening device, including:
the plan list file acquisition module is used for acquiring plan list files corresponding to at least two organizations;
the work order data extraction module is used for extracting corresponding work order data from the plan order file according to a work order header project contained in a work order setting interface;
the work order data entry module is used for entering corresponding work order data in a data area of the work order header project in a work order opening interface in a row unit, wherein each data row corresponds to one material of an organization;
and the work order opening module is used for opening a corresponding work order according to the selected data row in the data area when the work order opening event is triggered.
In a third aspect, an embodiment of the present application provides a computer-readable storage medium, on which a computer program is stored, and the computer program, when executed by a processor, implements a single-tool cubic method as described in an embodiment of the present application.
In a fourth aspect, an embodiment of the present application provides a terminal, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor executes the computer program to implement the single-person cubic method according to the embodiment of the present application.
According to the work order setting scheme provided by the embodiment of the application, at least two plan order files corresponding to organizations are obtained, corresponding work order data are extracted from the plan order files according to a work order header project contained in a work order setting interface, and the corresponding work order data are recorded in a data area of the work order header project in the work order setting interface in a row unit mode, wherein each data row corresponds to one material of one organization, and when a work order setting event is detected to be triggered, the corresponding work orders are set according to the selected data row in the data area. By adopting the technical scheme, the work order can be opened on the materials aiming at a plurality of organizations on the same work order opening interface, and the work order opening efficiency can be effectively improved.
Drawings
Fig. 1 is a schematic flow chart of a work order cubing method according to an embodiment of the present disclosure;
FIG. 2 is a schematic flow chart of another single-tool cubic opening method provided in the embodiments of the present application;
FIG. 3 is a schematic flow chart of another work order cubing method provided by an embodiment of the present application;
fig. 4 is a block diagram of a work order setup apparatus according to an embodiment of the present disclosure;
fig. 5 is a schematic structural diagram of a terminal according to an embodiment of the present application;
fig. 6 is a schematic structural diagram of another terminal provided in the embodiment of the present application.
Detailed Description
The technical scheme of the application is further explained by the specific implementation mode in combination with the attached drawings. It is to be understood that the specific embodiments described herein are merely illustrative of the application and are not limiting of the application. It should be further noted that, for the convenience of description, only some of the structures related to the present application are shown in the drawings, not all of the structures.
Before discussing exemplary embodiments in more detail, it should be noted that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although a flowchart may describe the steps as a sequential process, many of the steps can be performed in parallel, concurrently or simultaneously. In addition, the order of the steps may be rearranged. The process may be terminated when its operations are completed, but may have additional steps not included in the figure. The processes may correspond to methods, functions, procedures, subroutines, and the like.
Fig. 1 is a schematic flowchart of a work order cubing method provided in an embodiment of the present application, where the method may be performed by a work order cubing device, where the device may be implemented by software and/or hardware, and may be generally integrated in a terminal. As shown in fig. 1, the method includes:
For example, the terminal in the embodiment of the present application may include a mobile phone, a tablet computer, a notebook computer, a computer, and the like.
Generally, with the rapid expansion of business scale of enterprises, it is often necessary to establish a plurality of manufacturing companies, manufacturing departments, and the like. In the related art, a worker generally performs production management, including work order opening and management, on each manufacturing company by using a software system in a computer or other device, where the software system may be, for example, an Enterprise Resource Planning (EPR) system. At present, when a work order needs to be set up by a plurality of manufacturing companies, namely a plurality of organizations, a worker (namely a user of a system) needs to enter the functional module corresponding to each organization respectively, the setting up of the work order is operated in the interface of each functional module in sequence, and repeated operation needs to take a lot of time, so that the efficiency is low and mistakes are easy to make.
In the embodiment of the application, the work order setting function is integrated into a unified platform interface, the work order setting of a plurality of organizations is completed in the platform interface, and the work order setting efficiency can be effectively improved.
In this step, at least two plan sheet files corresponding to the organization are obtained first for obtaining the work sheet data. The plan form file may be a file in a certain format (e.g., an excel format) that can be recognized by the terminal, and data in the plan form file may be generally edited by a worker of an organization according to an actual production situation, and then the plan form file is generated and handed to an operator (i.e., a user) of the terminal in the embodiment of the present application. The user can import the collected plan sheet files corresponding to at least two organizations into the terminal, so that the acquisition of the plan sheet files is realized. In the embodiment of the present application, the number of the plan sheet files of each organization is not limited, and may be one or more.
Optionally, after the plan sheet file is obtained, the plan sheet file may be further screened, and the plan sheet file meeting the requirement is used for work sheet data extraction in the next step. Illustratively, the schedule files may be extracted for a period of time, such as the schedule files that expire within 2 months.
And 102, extracting corresponding work order data from the plan order file according to the work order header project contained in the work order opening interface.
For example, when designing the work order opening interface, the header may be set according to the specific content related to the work order, and there are multiple items in the header. The data content in the plan sheet file can be identified, and then the data corresponding to the work sheet header project is extracted as the work sheet data.
For example, in the embodiment of the present application, the work order header items include an organization name, a material code, a number of planning orders, a number of orders that can be placed, a number of work orders, a margin of orders that can be placed, and the like. Wherein the number of schedule sheets comprises a total number of planned productions for a single material code by the organization to which the schedule sheet belongs; the order-placing quantity comprises a planned production quantity of an organization corresponding to a single material code within a preset time period; the work order quantity comprises the planned production quantity of the work order to be created of the single material code of the organization; the drop allowance includes a difference between the drop amount and the work order amount. The embodiment of the present application is not limited to a specific type of material, and may be, for example, a manufactured part, an assembly part, or an assembly part.
For example, for manufacturing company a, planning to produce a total of 10000 pieces for a material with a material code of a123, the amount of the single piece of the plan may be 10000 pieces; for the material, according to the manufacturing lead period or within a certain time period (such as one week) from the current date to the future, 2000 pieces are planned to be produced, and the amount of the orders which can be placed can be 2000 pieces; for the material, the work order quantity may refer to the number of planning orders allocated to the work order to be created, and the quantity may be filled or modified by the user, and may not exceed the maximum number of orders that can be placed, so the default number of orders that can be placed may be 2000, which is to create a work order, and if the user considers that modification is needed, modification may be performed on the work order setting interface, such as 800; for the material, the allowance can be added, namely the difference between the allowance and the work order amount, and if the allowance is equal to the work order amount, the allowance can be added to be 0.
In addition, in order to make the content of the work order more comprehensive, the work order header items may further include an organization identifier, a Material description, a work order type, a work center, a work order status, a Bill of Material (BOM) substitute, a process route substitute, a plan start date, a plan completion date, a work order number, and the like.
Optionally, the work order data extracted in this step may include data corresponding to an organization name, a material code, a planning singular number, and a place-able number. Manufacturing company a, a123, 10000 pieces and 2000 pieces as in the previous examples.
103, inputting corresponding work order data in a data area of the work order header project in the work order opening interface in a row unit, wherein each data row corresponds to one material of an organization.
In the embodiment of the application, the system can automatically extract the work order data after the user finishes importing the plan order file, and automatically enter a work order opening interface; of course, the user can also enter the work order opening interface first under the operation of the user and complete the import of the plan order file on the work order opening interface. After the system extracts the work order data, the work order data is automatically displayed in a work order opening interface. In order to distinguish different work orders, different organizations and different materials in the same organization can be distinguished by using a row unit, so that each data row in a data area in a work order opening interface corresponds to one material of one organization.
The related data of a plurality of organizations and a plurality of materials are simultaneously displayed in the same work order opening interface, so that the user can conveniently and globally master the whole manufacturing plan of the subordinate manufacturing company of the enterprise.
And 104, when the work order opening event is triggered, opening the corresponding work order according to the selected data row in the data area.
For example, a work order opening option or button may be provided in the work order opening interface, and when the work order opening option or button is triggered in a set manner (e.g., clicking, etc.), it may be considered that the work order opening event is detected to be triggered.
The user can check the data row which needs to be opened in the work order opening interface, and when the system detects that the work order opening event is triggered, the corresponding work order is automatically generated according to the selected data row in the data area, so that the work order is opened.
In the same work order setting interface, the work orders of various materials of a plurality of organizations can be set in batches, a user does not need to go to interfaces corresponding to different organizations respectively to carry out a large amount of repeated operations, frequent switching among the interfaces is avoided, the operation steps of the user can be effectively reduced, the operation time is shortened, and the work order setting efficiency is further improved.
The work order cubing method provided in the embodiment of the application obtains plan order files corresponding to at least two organizations, extracts corresponding work order data from the plan order files according to a work order header project contained in a work order setting interface, and inputs the corresponding work order data in a data area of the work order header project in the work order setting interface in a row unit, wherein each data row corresponds to a material of one organization, and when a work order setting event is detected to be triggered, the corresponding work order is set according to a selected data row in the data area. By adopting the technical scheme, the work order can be opened on the materials aiming at a plurality of organizations on the same work order opening interface, and the work order opening efficiency can be effectively improved.
In some embodiments, after the corresponding work order data is entered in a data area of the work order header item in a work order opening interface in a unit of a row, the method further includes: receiving splitting operation input by a user aiming at a target data line; and splitting the target data line into at least two sub data lines according to the splitting operation. The method has the advantages that the user can be allowed to rapidly divide the work order data in a data line splitting mode, operations such as copying and pasting are reduced, and the work order opening efficiency is further improved.
In some embodiments, the receiving a splitting operation input by a user for a target data line includes: receiving a first numerical value modified by a user aiming at a target data cell in a target data line, wherein the target data cell comprises data cells corresponding to the number of available orders or the number of work orders. Splitting the target data line into at least two sub-data lines according to the splitting operation, including: generating a first subdata row according to the first numerical value; calculating the difference value between the original value before the target data cell is modified and the first value; generating a second sub data line according to the difference value; and the data content in the data cells except the target data cell in the first sub data row and the second sub data row is unchanged. The advantage that sets up like this lies in, can be automatically to the quantity of can ordering or work order quantity split, need not the user and calculates the quantity after the split by oneself, avoids appearing calculation error.
In some embodiments, before detecting that the work order opening event is triggered, the method further comprises: and updating and displaying the selected state of each data line in the data area according to the selection operation of a user, wherein the selection operation comprises single-line selection, multi-line selection and full selection. The method has the advantages that the data line of the work order to be set up can be freely selected in the same interface, the operation of a user is facilitated, and the flexibility of setting up the work order is improved.
In some embodiments, before detecting that the work order opening event is triggered, the method further comprises: binding manufacturing resources for selected data rows in the data area, the manufacturing resources including production areas and/or production lines. Correspondingly, the step of issuing a corresponding work order according to the selected data row in the data area includes: and establishing a corresponding work order according to the selected data line in the data area and the bound manufacturing resources. The advantage of setting up like this lies in, can dispose manufacturing resource before the work order is opened to confirm the target of transferring of work order before the work order is opened, improve work order and transfer efficiency. Optionally, after the corresponding work order is opened according to the selected data line in the data area, the method may further include: and lowering the opened work order to a corresponding target according to the manufacturing resources contained in the work order. The target may include a device, such as a computer, in a production area or line for receiving work orders.
In some embodiments, after generating the corresponding work order according to the selected data row in the data area, the method further includes: and entering a work order management interface, and managing the opened work orders corresponding to the at least two organizations in the work order management interface according to the operation of a user. The advantage of this arrangement is that after the work order is opened, the opened work orders of different organizations can be managed uniformly in the same work order management interface, which may include, for example, query, modification, cancellation, closing and other management operations.
Fig. 2 is a schematic flow chart of another single-tool cubic opening method provided in an embodiment of the present application, where the method includes the following steps:
Illustratively, the plan sheet file can be screened according to an organization name, a plan due time or a material name, etc., to obtain a plan sheet file which is to generate a work order, and the obtained plan sheet file is marked as a target plan sheet file.
And 203, extracting corresponding work order data from the target plan order file according to the work order header project contained in the work order opening interface.
The work order header items comprise organization names, material codes, planning order quantity, order-placing quantity, work order quantity and order-placing allowance. Wherein the number of schedule sheets comprises a total number of planned productions for a single material code by the organization to which the schedule sheet belongs; the order-placing quantity comprises a planned production quantity of an organization corresponding to a single material code within a preset time period; the work order quantity comprises the planned production quantity of the work order to be created of the single material code of the organization; the drop allowance includes a difference between the drop amount and the work order amount.
And 204, entering a work order opening interface, and inputting corresponding work order data in a data area of a work order header project in the work order opening interface in a row unit, wherein each data row corresponds to one material of an organization.
For example, taking the orderable quantity as an example, if the default value of the orderable quantity cell in the target data row is 9000, when the user clicks the orderable quantity cell, the value of the orderable quantity cell can be modified, for example, inputting 4000, and then the first value is 4000.
And step 206, generating a first sub-data line according to the first numerical value, and calculating a difference value between the original numerical value before modification in the target data cell and the first numerical value.
And the data contents in the data cells except the target data cell in the first sub data row are unchanged.
As described above, the first sub data line is generated according to the first numerical value 4000, and the data contents in the other cells are not changed except for the number of cells which can be singled, that is, the 9000 is changed to 4000, and the other cells are not changed. Subsequently, the system automatically calculates the difference as 9000-.
And step 207, generating a second sub data line according to the difference value.
And the data contents in the other data cells except the target data cell in the second sub data row are unchanged.
As an example, the record of one row 5000 is automatically added, that is, 5000 of the available data cells in the newly added second sub data row is 5000, and the data contents in other cells are not changed. Therefore, the target data line is automatically split into two subdata lines aiming at the data cell capable of being placed in order.
Optionally, the splitting operation may also continue. For example, when 3000 is input into the data cell in which 5000 is located, the data can be automatically split into sub data lines corresponding to 3000 and 2000.
The splitting times are not limited in the embodiments of the present application.
And 208, updating and displaying the selected state of each data row in the data area according to the check operation of the user.
The checking operation comprises single-row checking, multi-row checking and full-selection.
For example, a check box may be provided at the beginning of each data line, and default to an unselected state, and when a user clicks a certain check box, the check box is checked, and the corresponding data line is also checked. Optionally, the background color of the selected data lines may be changed to facilitate differentiation.
And 209, when detecting that the work order opening button is clicked, opening the corresponding work order according to the selected data line in the data area.
The worksheet opening and closing method provided by the embodiment of the application screens the plan sheet files after acquiring the plan sheet files corresponding to a plurality of organizations, extracts corresponding worksheet data from the screened plan sheet files, enters a worksheet opening interface, and inputs the corresponding worksheet data in a data area in a row unit manner, so that a plurality of organization plan sheets are led out to the same interface, the separation of the worksheets or the worksheets can be automatically performed according to the data line separation operation of a user, when the worksheet opening button is detected to be clicked, the corresponding worksheets are opened in batches according to the selected data line, the worksheet opening operation for the materials of the plurality of organizations can be performed on the same worksheet opening interface quickly and accurately, the worksheet opening efficiency is further improved, and the accuracy of the worksheet data is ensured.
Fig. 3 is a schematic flow chart of another single-tool cubic opening method provided in the embodiment of the present application, where the method includes:
And 302, extracting corresponding work order data from the plan order file according to the work order header project contained in the work order opening interface.
The work order header items comprise organization names, material codes, planning order quantity, order-placing quantity, work order quantity and order-placing allowance. Wherein the number of schedule sheets comprises a total number of planned productions for a single material code by the organization to which the schedule sheet belongs; the order-placing quantity comprises a planned production quantity of an organization corresponding to a single material code within a preset time period; the work order quantity comprises the planned production quantity of the work order to be created of the single material code of the organization; the drop allowance includes a difference between the drop amount and the work order amount.
In addition, in order to make the content of the work order more comprehensive, the work order header items may further include an organization identifier, a material description, a work order type, a work center, a work order status, a BOM substitute, a process route substitute, a plan start date, a plan completion date, a work order number, and the like.
And 305, generating a first sub-data line according to the first numerical value, and calculating a difference value between the original numerical value before modification in the target data unit cell and the first numerical value.
And the data contents in the data cells except the target data cell in the first sub data row are unchanged.
And step 306, generating a second sub data line according to the difference value.
And the data contents in the other data cells except the target data cell in the second sub data row are unchanged.
And 307, updating and displaying the selected state of each data row in the data area according to the check operation of the user.
The checking operation comprises single-row checking, multi-row checking and full-selection.
And 310, entering a work order management interface, and managing the opened work orders corresponding to the at least two organizations in the work order management interface according to the operation of a user.
Exemplary, management operations may include querying, modifying, canceling, and closing.
The work order opening and establishing method provided by the embodiment of the application obtains plan order files corresponding to a plurality of organizations and extracts corresponding work order data after entering a unified work order opening interface, the work order data are input into corresponding data areas in a row unit, splitting aiming at the number of orders which can be issued or the number of work orders is automatically carried out according to the splitting operation of a data line of a user, the data line of the work order to be generated is selected and manufacturing resources are bound, after the work order is successfully opened, the work order can be automatically released according to the manufacturing resources, and the opened work order is managed in the unified work order management interface. Therefore, batch work order opening operation can be quickly and accurately carried out on the same work order opening interface aiming at materials of a plurality of organizations, work orders can be automatically transferred and tracked and managed in the same interface, the function of a work order system is further perfected, and the work efficiency and the work quality of users are improved. In addition, the user can grab the logic according to the set time period, conveniently derive the planned sheet number by the system, split the planned sheet number and bind the pull line (production line) or the production area to issue the work order instruction according to the production resource allocation.
Fig. 4 is a block diagram of a work order opening apparatus provided in an embodiment of the present application, where the apparatus may be implemented by software and/or hardware, and is generally integrated in a terminal, and the work order opening apparatus may perform a work order opening method. As shown in fig. 4, the apparatus includes:
a schedule file obtaining module 401, configured to obtain at least two schedule files corresponding to an organization;
a work order data extraction module 402, configured to extract corresponding work order data from the plan order file according to a work order header project included in a work order setting interface;
a work order data entry module 403, configured to enter corresponding work order data in a data area of the work order header item in a work order opening interface in a row unit, where each data row corresponds to one material of an organization;
and a work order opening module 404, configured to open a corresponding work order according to the selected data row in the data area when it is detected that the work order opening event is triggered.
The work order setting device provided in the embodiment of the application obtains plan order files corresponding to at least two organizations, extracts corresponding work order data from the plan order files according to a work order header project contained in a work order setting interface, and inputs the corresponding work order data in a data area of the work order header project in the work order setting interface in a row unit, wherein each data row corresponds to one material of one organization, and when a work order setting event is detected to be triggered, the corresponding work order is set according to a selected data row in the data area. By adopting the technical scheme, the work order can be opened on the materials aiming at a plurality of organizations on the same work order opening interface, and the work order opening efficiency can be effectively improved.
Optionally, the work order header items include an organization name, a material code, a planning order quantity, a scheduling order quantity, a work order quantity, and a scheduling order margin. Wherein the number of schedule sheets comprises a total number of planned productions for a single material code by the organization to which the schedule sheet belongs; the order-placing quantity comprises a planned production quantity of an organization corresponding to a single material code within a preset time period; the work order quantity comprises the planned production quantity of the work order to be created of the single material code of the organization; the drop allowance includes a difference between the drop amount and the work order amount.
Optionally, the apparatus may further comprise:
the splitting operation receiving module is used for receiving splitting operation input by a user aiming at a target data line after corresponding work order data is input in a data area of a work order header project in a work order opening interface in a row unit;
and the splitting module is used for splitting the target data line into at least two subdata lines according to the splitting operation.
Optionally, the receiving a splitting operation input by a user for a target data line includes:
receiving a first numerical value modified by a user aiming at a target data cell in a target data line, wherein the target data cell comprises data cells corresponding to the number of available orders or the number of work orders;
splitting the target data line into at least two sub-data lines according to the splitting operation, including:
generating a first subdata row according to the first numerical value;
calculating the difference value between the original value before the target data cell is modified and the first value;
generating a second sub data line according to the difference value;
and the data content in the data cells except the target data cell in the first sub data row and the second sub data row is unchanged.
Optionally, the device may further include a checking module, configured to update and display the selected state of each data line in the data area according to a checking operation of a user before the work order opening event is detected to be triggered, where the checking operation includes single-line checking, multi-line checking, and full-selection.
Optionally, the apparatus may further comprise:
the resource binding module is used for binding manufacturing resources for the selected data rows in the data area before the fact that the work order opening event is triggered is detected, wherein the manufacturing resources comprise a production area and/or a production line;
correspondingly, the step of issuing a corresponding work order according to the selected data row in the data area includes:
and establishing a corresponding work order according to the selected data line in the data area and the bound manufacturing resources.
Optionally, the apparatus may further comprise:
and the work order management module is used for entering a work order management interface after generating a corresponding work order according to the selected data row in the data area, and managing the set-up work orders corresponding to the at least two organizations in the work order management interface according to the operation of a user.
Embodiments of the present application also provide a storage medium containing computer-executable instructions, which when executed by a computer processor, perform a single-tap cubic method, the method comprising:
acquiring plan list files corresponding to at least two organizations;
extracting corresponding work order data from the plan order file according to a work order header project contained in a work order opening interface;
inputting corresponding work order data in a data area of the work order header project in a work order opening interface in a row unit, wherein each data row corresponds to one material of one organization;
and when a work order opening event is triggered, opening a corresponding work order according to the selected data row in the data area.
Storage medium-any of various types of memory devices or storage devices. The term "storage medium" is intended to include: mounting media such as CD-ROM, floppy disk, or tape devices; computer system memory or random access memory such as DRAM, DDRRAM, SRAM, EDORAM, Lanbas (Rambus) RAM, etc.; non-volatile memory such as flash memory, magnetic media (e.g., hard disk or optical storage); registers or other similar types of memory elements, etc. The storage medium may also include other types of memory or combinations thereof. In addition, the storage medium may be located in a first computer system in which the program is executed, or may be located in a different second computer system connected to the first computer system through a network (such as the internet). The second computer system may provide program instructions to the first computer for execution. The term "storage medium" may include two or more storage media that may reside in different locations, such as in different computer systems that are connected by a network. The storage medium may store program instructions (e.g., embodied as a computer program) that are executable by one or more processors.
Of course, the storage medium provided in the embodiments of the present application contains computer-executable instructions, and the computer-executable instructions are not limited to the above-mentioned work order opening operation, and may also perform related operations in the work order opening method provided in any embodiments of the present application.
The embodiment of the application provides a terminal, and the work order setting device provided by the embodiment of the application can be integrated in the terminal. Fig. 5 is a schematic structural diagram of a terminal according to an embodiment of the present application. The terminal 600 may include: the apparatus comprises a memory 501, a processor 502 and a computer program stored on the memory 501 and executable on the processor, wherein the processor 502 implements the single-person cubic method according to the embodiment of the present application when executing the computer program.
The terminal provided by the embodiment of the application can be used for carrying out work order setting operation on materials aiming at a plurality of organizations on the same work order setting interface, and the work order setting efficiency can be effectively improved.
Fig. 6 is a schematic structural diagram of another terminal provided in the embodiment of the present application, where the terminal may include: a housing (not shown), a memory 601, a Central Processing Unit (CPU) 602 (also called a processor, hereinafter referred to as CPU), a circuit board (not shown), and a power circuit (not shown). The circuit board is arranged in a space enclosed by the shell; the CPU602 and the memory 601 are disposed on the circuit board; the power supply circuit is used for supplying power to each circuit or device of the terminal; the memory 601 is used for storing executable program codes; the CPU602 executes a computer program corresponding to the executable program code by reading the executable program code stored in the memory 601 to implement the steps of:
acquiring plan list files corresponding to at least two organizations;
extracting corresponding work order data from the plan order file according to a work order header project contained in a work order opening interface;
inputting corresponding work order data in a data area of the work order header project in a work order opening interface in a row unit, wherein each data row corresponds to one material of one organization;
and when a work order opening event is triggered, opening a corresponding work order according to the selected data row in the data area.
The terminal further comprises: peripheral interface 603, RF (Radio Frequency) circuitry 605, audio circuitry 606, speakers 611, power management chip 608, input/output (I/O) subsystem 609, other input/control devices 610, touch screen 612, other input/control devices 610, and external port 604, which communicate via one or more communication buses or signal lines 607.
It should be understood that the illustrated terminal 600 is merely one example of a terminal and that the terminal 600 may have more or fewer components than shown in the figures, may combine two or more components, or may have a different configuration of components. The various components shown in the figures may be implemented in hardware, software, or a combination of hardware and software, including one or more signal processing and/or application specific integrated circuits.
The following describes in detail the terminal opened by the work order provided in this embodiment, and the terminal is a mobile phone as an example. The mobile phone has the advantages that the mobile terminals such as the mobile phone have the characteristic of portability, and a user can conveniently open the work order at any time and any place.
A memory 601, the memory 601 being accessible by the CPU602, the peripheral interface 603, and the like, the memory 601 may include high speed random access memory, and may also include non-volatile memory, such as one or more magnetic disk storage devices, flash memory devices, or other volatile solid state storage devices.
A peripheral interface 603, said peripheral interface 603 may connect input and output peripherals of the device to the CPU602 and the memory 601.
An I/O subsystem 609, the I/O subsystem 609 may connect input and output peripherals on the device, such as a touch screen 612 and other input/control devices 610, to the peripheral interface 603. The I/O subsystem 609 may include a display controller 6091 and one or more input controllers 6092 for controlling other input/control devices 610. Where one or more input controllers 6092 receive electrical signals from or transmit electrical signals to other input/control devices 610, the other input/control devices 610 may include physical buttons (push buttons, rocker buttons, etc.), dials, slide switches, joysticks, click wheels. It is noted that the input controller 6092 may be connected to any one of: a keyboard, an infrared port, a USB interface, and a pointing device such as a mouse.
A touch screen 612, which touch screen 612 is an input interface and an output interface between the user terminal and the user, displays visual output to the user, which may include graphics, text, icons, video, and the like.
The display controller 6091 in the I/O subsystem 609 receives electrical signals from the touch screen 612 or transmits electrical signals to the touch screen 612. The touch screen 612 detects a contact on the touch screen, and the display controller 6091 converts the detected contact into an interaction with a user interface object displayed on the touch screen 612, that is, to implement a human-computer interaction, where the user interface object displayed on the touch screen 612 may be an icon for running a game, an icon networked to a corresponding network, or the like. It is worth mentioning that the device may also comprise a light mouse, which is a touch sensitive surface that does not show visual output, or an extension of the touch sensitive surface formed by the touch screen.
The RF circuit 605 is mainly used to establish communication between the mobile phone and the wireless network (i.e., network side), and implement data reception and transmission between the mobile phone and the wireless network. Such as sending and receiving short messages, e-mails, etc. In particular, RF circuitry 605 receives and transmits RF signals, also referred to as electromagnetic signals, through which RF circuitry 605 converts electrical signals to or from electromagnetic signals and communicates with a communication network and other devices. RF circuitry 605 may include known circuitry for performing these functions including, but not limited to, an antenna system, an RF transceiver, one or more amplifiers, a tuner, one or more oscillators, a digital signal processor, a CODEC (CODEC) chipset, a Subscriber Identity Module (SIM), and so forth.
The audio circuit 606 is mainly used to receive audio data from the peripheral interface 603, convert the audio data into an electric signal, and transmit the electric signal to the speaker 611.
The speaker 611 is used to convert the voice signal received by the handset from the wireless network through the RF circuit 605 into sound and play the sound to the user.
And a power management chip 608 for supplying power and managing power to the hardware connected to the CPU602, the I/O subsystem, and the peripheral interface.
The work order development device, the storage medium and the terminal provided in the above embodiments may execute the work order development method provided in any embodiment of the present application, and have corresponding functional modules and beneficial effects for executing the method. For technical details not described in detail in the above embodiments, reference may be made to the single-person cubic opening method provided in any of the embodiments of the present application.
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present application and the technical principles employed. It will be understood by those skilled in the art that the present application is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the application. Therefore, although the present application has been described in more detail with reference to the above embodiments, the present application is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present application, and the scope of the present application is determined by the scope of the appended claims.
Claims (7)
1. A work order cubing method, comprising:
acquiring plan list files corresponding to at least two organizations;
screening the plan list file to obtain a target plan list file;
extracting corresponding work order data from the target plan order file according to a work order header project contained in a work order opening interface;
inputting corresponding work order data in a data area of the work order header project in a work order opening interface in a row unit, wherein each data row corresponds to one material of one organization;
receiving a splitting operation input by a user aiming at a target data line, wherein the splitting operation comprises the following steps: receiving a first numerical value modified by a user aiming at a target data cell in a target data line, wherein the target data cell comprises data cells corresponding to the number of available orders or the number of work orders;
splitting the target data line into at least two sub-data lines according to the splitting operation, including: generating a first subdata row according to the first numerical value; calculating the difference value between the original value before the target data cell is modified and the first value; generating a second sub data line according to the difference value; the data content in the data cells except the target data cell in the first sub data row and the second sub data row is unchanged;
binding manufacturing resources for selected data rows in the data area, the manufacturing resources including production areas and/or production lines;
when a work order opening event is triggered, opening a corresponding work order according to the selected data line and the bound manufacturing resources in the data area, and putting the opened work order to a corresponding target according to the manufacturing resources contained in the work order, wherein the target comprises the production area or equipment used for receiving the work order in the production line.
2. The method of claim 1, wherein the work order header items include an organization name, a material code, a number of orders that can be placed, a number of work orders, and a margin to which orders can be placed;
wherein the number of schedule sheets comprises a total number of planned productions for a single material code by the organization to which the schedule sheet belongs; the order-placing quantity comprises a planned production quantity of an organization corresponding to a single material code within a preset time period; the work order quantity comprises the planned production quantity of the work order to be created of the single material code of the organization; the drop allowance includes a difference between the drop amount and the work order amount.
3. The method of claim 1, further comprising, prior to detecting that a work order opening event is triggered:
and updating and displaying the selected state of each data line in the data area according to the selection operation of a user, wherein the selection operation comprises single-line selection, multi-line selection and full selection.
4. The method of claim 1, further comprising, after generating a corresponding work order from the selected data rows in the data region:
and entering a work order management interface, and managing the opened work orders corresponding to the at least two organizations in the work order management interface according to the operation of a user.
5. A work order erecting device, comprising:
the system comprises a plan sheet file acquisition module, a target plan sheet file acquisition module and a plan sheet file selection module, wherein the plan sheet file acquisition module is used for acquiring plan sheet files corresponding to at least two organizations and screening the plan sheet files to obtain the target plan sheet file;
the work order data extraction module is used for extracting corresponding work order data from the target plan order file according to a work order header project contained in a work order setting interface;
the work order data entry module is used for entering corresponding work order data in a data area of the work order header project in a work order opening interface in a row unit, wherein each data row corresponds to one material of an organization;
a splitting operation receiving module, configured to receive a splitting operation input by a user for a target data line, where the splitting operation includes: receiving a first numerical value modified by a user aiming at a target data cell in a target data line, wherein the target data cell comprises data cells corresponding to the number of available orders or the number of work orders;
the splitting module is configured to split the target data line into at least two sub data lines according to the splitting operation, and includes: generating a first subdata row according to the first numerical value; calculating the difference value between the original value before the target data cell is modified and the first value; generating a second sub data line according to the difference value; the data content in the data cells except the target data cell in the first sub data row and the second sub data row is unchanged;
the resource binding module is used for binding manufacturing resources for the selected data rows in the data area, and the manufacturing resources comprise production areas and/or production lines;
and the work order opening module is used for opening a corresponding work order according to the selected data line and the bound manufacturing resources in the data area when detecting that a work order opening event is triggered, and putting the opened work order down to a corresponding target according to the manufacturing resources contained in the work order, wherein the target comprises the production area or equipment used for receiving the work order in the production line.
6. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the single-handed cubic method as claimed in any one of claims 1 to 4.
7. A terminal comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor when executing the computer program implementing the single-handed cubic method as claimed in any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811341255.9A CN109377184B (en) | 2018-11-12 | 2018-11-12 | Work order opening method, device, storage medium and terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811341255.9A CN109377184B (en) | 2018-11-12 | 2018-11-12 | Work order opening method, device, storage medium and terminal |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109377184A CN109377184A (en) | 2019-02-22 |
| CN109377184B true CN109377184B (en) | 2021-05-04 |
Family
ID=65384299
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811341255.9A Active CN109377184B (en) | 2018-11-12 | 2018-11-12 | Work order opening method, device, storage medium and terminal |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109377184B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109978369A (en) * | 2019-03-22 | 2019-07-05 | Oppo（重庆）智能科技有限公司 | Work order generation method, device, electronic equipment and storage medium |
| CN110930120A (en) * | 2019-11-28 | 2020-03-27 | 深圳市智微智能软件开发有限公司 | MES test method and system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101046859A (en) * | 2006-03-29 | 2007-10-03 | 鸿富锦精密工业（深圳）有限公司 | Job cards made system and method |
| CN103745311A (en) * | 2013-12-25 | 2014-04-23 | 天通精电新科技有限公司 | Production data management information system |
| CN106408170A (en) * | 2016-08-30 | 2017-02-15 | 北京北信源软件股份有限公司 | Electronic worksheet processing method, workflow engine and electronic worksheet system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8341089B2 (en) * | 2007-11-29 | 2012-12-25 | Ross Stores, Inc. | Real estate management system and method |
-
2018
- 2018-11-12 CN CN201811341255.9A patent/CN109377184B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101046859A (en) * | 2006-03-29 | 2007-10-03 | 鸿富锦精密工业（深圳）有限公司 | Job cards made system and method |
| CN103745311A (en) * | 2013-12-25 | 2014-04-23 | 天通精电新科技有限公司 | Production data management information system |
| CN106408170A (en) * | 2016-08-30 | 2017-02-15 | 北京北信源软件股份有限公司 | Electronic worksheet processing method, workflow engine and electronic worksheet system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109377184A (en) | 2019-02-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6031535B2 (en) | Site management method and system for supporting site production using various types of cards | |
| EP3020017A1 (en) | Method and system for creating tax configuration templates | |
| CN103119589A (en) | Method and apparatus for binding mobile device functionality to an application definition | |
| CN109377184B (en) | Work order opening method, device, storage medium and terminal | |
| CN108628944A (en) | Online assignment input method, client, server, computer equipment and medium | |
| CN109981303B (en) | Conference information pushing method and device, storage medium and terminal equipment | |
| CN102411540A (en) | Automatic management system of workflow-based common software testing process | |
| CN114500570B (en) | Task processing method, device, electronic equipment and computer readable storage medium | |
| CN113557517A (en) | Automatic generation device and method of electrical design drawing | |
| CN110688236A (en) | Information touch method, system and terminal equipment | |
| CN102097015A (en) | Operation instruction processing system and method | |
| CN104574044A (en) | Task originating method in office automation and office automation system | |
| US20220113847A1 (en) | Online collaborative document processing method and device | |
| CN111178017A (en) | Method and device for generating flow chart, storage medium and electronic equipment | |
| CN111401733A (en) | Production line auxiliary display system, method and device | |
| CN110533396A (en) | Material binding method, material binding device and terminal device | |
| CN104462631B (en) | Circuit diagram generating device and circuit diagram generating method | |
| CN107391361A (en) | A kind of POS terminal automatic test approach and device | |
| CN110930120A (en) | MES test method and system | |
| CN116051061A (en) | Information processing method, information processing device, electronic equipment and readable storage medium | |
| CN101504640A (en) | Data sheet editing method and apparatus | |
| CN108549695A (en) | Data interactive method, device, terminal device and storage medium | |
| CN108984508A (en) | Bidding documents generation method and device | |
| CN114064786A (en) | Data display method, data display device and server | |
| US20210263641A1 (en) | Context-driven group pill in a user interface |
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 |