CN113947389B - Digitization method and digitization system for balance sheet of ceramic supply chain system - Google Patents
Digitization method and digitization system for balance sheet of ceramic supply chain system Download PDFInfo
- Publication number
- CN113947389B CN113947389B CN202111557889.XA CN202111557889A CN113947389B CN 113947389 B CN113947389 B CN 113947389B CN 202111557889 A CN202111557889 A CN 202111557889A CN 113947389 B CN113947389 B CN 113947389B
- Authority
- CN
- China
- Prior art keywords
- pound
- picture
- service
- data table
- record
- 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 36
- 239000000919 ceramic Substances 0.000 title claims abstract description 26
- 238000007781 pre-processing Methods 0.000 claims abstract description 30
- 230000008676 import Effects 0.000 claims abstract description 28
- 230000001360 synchronised effect Effects 0.000 claims description 24
- 238000012856 packing Methods 0.000 claims description 6
- 238000004806 packaging method and process Methods 0.000 claims description 3
- 230000008569 process Effects 0.000 abstract description 15
- 230000000875 corresponding effect Effects 0.000 description 36
- 230000004048 modification Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 239000000463 material Substances 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 239000003086 colorant Substances 0.000 description 1
- 230000006835 compression Effects 0.000 description 1
- 238000007906 compression Methods 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000005286 illumination Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Tourism & Hospitality (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Manufacturing & Machinery (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Software Systems (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Human Computer Interaction (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a digitization method and a digitization system of a ceramic supply chain system pound sheet, belonging to the technical field of the ceramic industry supply chain, wherein the digitization method comprises a business data table presetting step, a pound sheet picture preprocessing step, a pound sheet data table preprocessing step, a pound sheet import analysis step and a picture data correlation step; the system comprises a business data table presetting module, a pound single picture preprocessing module, a pound single data table preprocessing module, a pound single import analysis module and a picture data correlation module. The invention processes the pound single picture and the pound single data sheet separately, and processes the pound single picture and a plurality of pound single pictures separately, thereby effectively utilizing the resources of the server, solving the problem that the user depends on the waiting time of the imported page in the operation, reducing the queuing condition when a plurality of users operate simultaneously, and improving the efficiency.
Description
Technical Field
The invention relates to the technical field of supply chains in the ceramic industry, in particular to a digitization method and a digitization system for a balance sheet of a ceramic supply chain system.
Background
In the transaction of the supply chain of the ceramic industry, the pound order is an indispensable evidence material for reflecting the transaction compliance and authenticity; the pound single types in the ceramic industry are different and have more quantity, the templates of each factory are different, and the pound single picture and pound single information need to be correlated in offline transaction online datamation.
The existing OCR character recognition function can only effectively recognize a standard electronic template, the pound list picture has abundant styles, often faces the problems of low brightness, low contrast, uneven illumination, perspective deformation, incomplete shielding and the like, the layout of a text may have the problems of distortion, folds, reversing and the like, characters in the pound list may have the problems of various fonts and different heavy colors of characters of the numbers and numbers, and cannot be effectively and accurately recognized, and in addition, the identification numbers also need to be checked one by one, the accurate and digital efficiency of the pound list cannot be effectively improved, and therefore the pound list cannot be completely and accurately recognized through a single OCR character recognition technology. At present, data of the pound order in the ceramic industry can only be manually input to upload the pound order one by one and input pound order information one by one to realize the correlation between pound order pictures and pound order information, and the efficiency is low.
Disclosure of Invention
In view of the above-mentioned drawbacks, the present invention provides a method for digitizing pound sign sheets of a ceramic supply chain system, which solves the problem of low data processing efficiency of the pound sign sheets in the ceramic industry.
In view of the above drawbacks, another objective of the present invention is to provide a digitizer system for a ceramic supply chain system, which solves the problem of low data processing efficiency of the existing balance sheet in the ceramic industry.
In order to achieve the purpose, the invention adopts the following technical scheme: a method of digitizing a ceramic supply chain system pound order, comprising the steps of:
presetting a service data table: presetting a service data table, wherein the service data table comprises service records, service batches, picture sequence numbers, service types, service numbers and service numerical values;
b, single picture pretreatment: renaming the file names of the pound single pictures in batches according to a first format, wherein the first format comprises a first type and a first number;
when a plurality of pound single pictures are preprocessed by the same user, packaging and compressing the pound single pictures; when the pound single picture preprocessed by the same user is a single picture, the pound single picture is not packed and compressed;
and b, preprocessing a pound list data table: entering the content in the pound sign picture in a pound sign data sheet according to a second format, wherein the second format comprises a second type, a second number and a second numerical value;
and b, pound sheet introduction and analysis step: selecting a processing mode according to the format of the pound single picture in the pound single picture preprocessing step, importing the pound single picture subjected to the pound single picture preprocessing step, analyzing the filename of the pound single picture, extracting a first type and a first number in the filename of the pound single picture, and generating a batch id, a first record id and a picture id corresponding to the pound single picture; the batch id records the import batch of the pound single pictures, and each pound single picture corresponds to a unique first record id and a unique picture id; when the imported and analyzed pound single pictures are in a compressed packet format, selecting an asynchronous processing mode, and unpacking the pound single pictures in the compressed packet format; when the imported and analyzed pound single pictures are in a non-compressed packet format, selecting a synchronous processing mode;
analyzing and importing the contents in the pound order data table subjected to the pound order data table preprocessing step in a synchronous processing mode, and extracting a second type, a second number and a second numerical value in the pound order data table;
picture data association step: associating the first type, the first number, the batch id, the first record id and the picture id of the same pound single picture and then respectively storing the first type, the first number, the batch id, the first record id and the picture id in the service type, the service number, the service batch, the service record and the picture serial number of the service data table; the first type is stored in the service type, the first number is stored in a service number, the batch id is stored in the service batch, the first record id is stored in the service record, and the picture id is stored in the picture serial number;
querying a pound single picture matched with the pound single data table, wherein in the matched pound single data table and the pound single picture, the second type is equal to the first type, and the second number is equal to the first number; and then, storing the second numerical value of the pound list data table in the service numerical value of the service data table after associating the second numerical value with the first record id of the pound list picture.
It should be noted that the processing manner of the synchronization processing in the pound-sheet import analysis step is specifically as follows:
after receiving requests of one or more users, the server imports the pound single picture in real time through a multithreading mode and analyzes the file name of the pound single picture;
after the pound single picture of the corresponding user is processed, immediately feeding back a result to the corresponding user;
the asynchronous processing mode in the pound single import analysis step is specifically as follows:
the server receives the asynchronous processing request and returns the result and the serial number of the request;
processing pound single pictures in a compressed packet format in the order of time of asynchronous processing requests;
and returning the result or unprocessed state after the processing is finished to the corresponding user.
Optionally, in the picture data association step, after associating the first type, the first number, the batch id, the first record id and the picture id of the same pound single picture, querying the first type and the first number of the pound single picture of the same batch id;
when the same first type and the same first number cannot be found in the same batch id, creating a new record in the service data table, and respectively storing the first type, the first number, the batch id, the first record id and the picture id of the pound single picture in the service type, the service number, the service batch, the service record and the picture serial number corresponding to the new record in the service data table;
when the same first type and first number are found in the same batch id, updating the data of the first record id and the picture id of the entered pound single picture.
Specifically, in the picture data association step, when a pound note picture matched with the pound note data table is not inquired, a new record is created in the business data table, the second type, the second number and the second numerical value of the pound note data table are respectively stored in the business type, the business number and the business numerical value corresponding to the new record of the business data table, and a second record id is generated in the business record of the new record of the pound note data table;
when the pound order picture matched with the pound order data table is inquired and the corresponding business numerical value in the business data table stores data, the data in the pound order numerical value is updated to be the second numerical value of the pound order data table.
Preferably, after the step of associating the picture data, a step of recording and merging is further included, where the step of recording and merging specifically includes:
and searching and comparing the data of the service types and the service numbers in the service data table, and combining the records with the same service types and service numbers into one record when the data of the service types and the service numbers of two or more records are the same.
It is worth to be noted that the digitalized system of the ceramic supply chain system pound list comprises a business data table presetting module, a pound list picture preprocessing module, a pound list data table preprocessing module, a pound list import analysis module and a picture data correlation module;
the service data table presetting module is used for presetting a service data table, and the service data table comprises service records, service batches, picture sequence numbers, service types, service numbers and service numerical values;
the pound single picture preprocessing module is used for renaming the file names of pound single pictures in batches according to a first format, wherein the first format comprises a first type and a first number; the system is also used for packing and compressing a plurality of pound single pictures when the pound single pictures preprocessed by the same user are a plurality of pound single pictures; the system is also used for not packing and compressing the pound single picture when the pound single picture preprocessed by the same user is a single picture;
the pound order data sheet preprocessing module is used for inputting the content in the pound order picture in a pound order data sheet according to a second format, wherein the second format comprises a second type, a second number and a second numerical value;
the pound order import analysis module is used for selecting a processing mode according to the format of the pound order picture, importing the pound order picture and analyzing the file name of the pound order picture, extracting a first type and a first number in the file name of the pound order picture, and generating a batch id, a first record id and a picture id corresponding to the pound order picture; the batch id records the import batch of the pound single pictures, and each pound single picture corresponds to a unique first record id and a unique picture id; when the imported and analyzed pound single pictures are in a compressed packet format, selecting an asynchronous processing mode, and unpacking the pound single pictures in the compressed packet format; when the imported and analyzed pound single pictures are in a non-compressed packet format, selecting a synchronous processing mode; the system is also used for analyzing and importing the contents in the pound order data table in a synchronous processing mode, and extracting a second type, a second number and a second numerical value in the pound order data table;
the picture data association module is used for associating the first type, the first number, the batch id, the first record id and the picture id of the same pound single picture and then respectively storing the first type, the first number, the batch id, the first record id and the picture id in the service type, the service number, the service batch, the service record and the picture sequence number of the service data table; the first type is stored in the service type, the first number is stored in a service number, the batch id is stored in the service batch, the first record id is stored in the service record, and the picture id is stored in the picture serial number; the system is also used for inquiring a pound single picture matched with the pound single data table, wherein in the matched pound single data table and the pound single picture, the second type is equal to the first type, and the second number is equal to the first number; and the system is also used for storing a second numerical value of the pound list data table in a business numerical value of the business data table after the second numerical value is associated with the first record id of the pound list picture.
Optionally, the processing mode of the synchronous processing is specifically configured to, after receiving a request from a single user or multiple users, import the pound single picture and parse the file name of the pound single picture in real time by using a server in a multithreading mode; the system is also used for feeding back the result to the corresponding user after the pound single picture of the corresponding user is processed;
the processing mode of the asynchronous processing is specifically used for receiving an asynchronous processing request by using a server and returning a request result and a serial number; the system is also used for distributing the received request to the processing queue with the least resource occupation according to the occupation condition of the current processing queue; and also for processing pound single pictures in compressed packet format in order of time of asynchronous processing of requests.
Specifically, the picture data association module is further configured to query the first type and the first number of the pound single picture of the same batch id after associating the first type, the first number, the batch id, the first record id and the picture id of the same pound single picture;
the system is further used for creating a new record in the business data table when the same first type and the same first number cannot be found in the same batch id, and respectively storing the first type, the first number, the batch id, the first record id and the picture id of the pound single picture in the business type, the business number, the business batch, the business record and the picture sequence number corresponding to the new record in the business data table;
and the data of the first record id and the picture id of the entered pound single picture are updated when the same first type and the same first label are found in the same batch id.
Preferably, the picture data association module is further configured to create a new record in the service data table when the pound single picture matched with the pound single data table is not queried, store the second type, the second number and the second numerical value of the pound single data table in the service type, the service number and the service numerical value corresponding to the new record of the service data table, and generate a second record id in the service record of the new record of the pound single data table;
and when the pound list picture matched with the pound list data table is inquired and the corresponding business numerical value in the business data table stores data, updating the data in the pound list numerical value into a second numerical value of the pound list data table.
It should be noted that the system further includes a record merging module, where the record merging module is configured to retrieve and compare data of the service type and the service number in the service data table, and is further configured to merge records with the same service type and the same service number into one record when data of the service type and the service number of two or more records are the same.
One of the above technical solutions has the following beneficial effects: in the digitization method of the pound sign of the ceramic supply chain system, the pound sign picture is digitized by matching according to the content of the pound sign picture and the pound sign data table. In the process of processing the pound single pictures, an asynchronous processing mode or a synchronous processing mode is automatically selected, when the pound single pictures are in a compressed packet format, because a plurality of pound single pictures are processed, the pressure on a server is high, the waiting time for processing is extremely long, and the real-time requirement is not high, the asynchronous processing mode is selected to execute the pound single pictures processed asynchronously in sequence through a single-thread message queue mode, and the task of the next user is continuously executed after the task of the previous user finishes processing a feedback result. Therefore, the influence on the processing efficiency caused by the excessive occupation of the server is avoided; when the format of the pound single picture is the non-compressed packet format, if the processing mode of asynchronous processing is adopted, when the server has 1000 pound single pictures in line for processing, the efficiency is reduced when the user only needs to process one pound single picture but needs to queue, in addition, because the pressure on the server is small when the single pound single picture is processed, the waiting processing time is short, the real-time requirement is high, the synchronous processing mode is selected, the system can feed back the result in real time in a multi-thread mode, the processing tasks of the single pound single pictures among each user are relatively independent, and the server can process the pictures simultaneously. In the process of processing the pound single data tables, each pound single data table is an independent table, so the pound single data table is processed independently, a synchronous processing mode is adopted, the pressure on the server is low when a single pound single data table is processed, the synchronous processing mode is selected, the system can feed back results in real time in a multi-thread mode, the processing tasks of the single pound single data table among each user are relatively independent, and the server can process the pound single data table simultaneously. The pound single picture and the pound single data table are processed separately, and the pound single picture and the pound single pictures are processed separately, so that the resource of the server is effectively utilized, the dependence of a user on the waiting time of the imported page in the operation is solved, the queuing phenomenon of a plurality of users in the simultaneous operation is reduced, and the efficiency is improved.
Drawings
FIG. 1 is a flow chart of a method for digitizing a ceramic supply chain system pound sign of an embodiment of the present invention;
FIG. 2 is a flow diagram of synchronous and asynchronous processing of one embodiment of the invention;
FIG. 3 is a flow diagram of import and parse of one embodiment of the invention.
Detailed Description
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the accompanying drawings are illustrative only for the purpose of explaining the present invention, and are not to be construed as limiting the present invention.
In the description of the embodiments of the present invention, the terms "first" and "second" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implying any number of technical features indicated. Thus, features defined as "first", "second", may explicitly or implicitly include one or more of the described features. In the description of the embodiments of the present invention, "a plurality" means two or more unless specifically limited otherwise.
The following disclosure provides many different embodiments or examples for implementing different configurations of embodiments of the invention. In order to simplify the disclosure of embodiments of the invention, the components and arrangements of specific examples are described below. Of course, they are merely examples and are not intended to limit the present invention. Furthermore, embodiments of the invention may repeat reference numerals and/or reference letters in the various examples, which have been repeated for purposes of simplicity and clarity and do not in themselves dictate a relationship between the various embodiments and/or arrangements discussed.
As shown in fig. 1-3, a method for digitizing a pound sign of a ceramic supply chain system includes the steps of:
presetting a service data table: presetting a service data table, wherein the service data table comprises service records, service batches, picture sequence numbers, service types, service numbers and service numerical values;
b, single picture pretreatment: renaming the file names of the pound single pictures in batches according to a first format, wherein the first format comprises a first type and a first number; when a plurality of pound single pictures are preprocessed by the same user, packaging and compressing the pound single pictures; when the pound single picture preprocessed by the same user is a single picture, the pound single picture is not packed and compressed; and b, preprocessing a pound list data table: entering the content in the pound sign picture in a pound sign data sheet according to a second format, wherein the second format comprises a second type, a second number and a second numerical value;
and b, pound sheet introduction and analysis step: selecting a processing mode according to the format of the pound single picture in the pound single picture preprocessing step, importing the pound single picture subjected to the pound single picture preprocessing step, analyzing the filename of the pound single picture, extracting a first type and a first number in the filename of the pound single picture, and generating a batch id, a first record id and a picture id corresponding to the pound single picture; the batch id records the import batch of the pound single pictures, and each pound single picture corresponds to a unique first record id and a unique picture id; when the imported and analyzed pound single pictures are in a compressed packet format, selecting an asynchronous processing mode, and unpacking the pound single pictures in the compressed packet format; when the imported and analyzed pound single pictures are in a non-compressed packet format, selecting a synchronous processing mode; specifically, the pound single picture in the compressed package format is a compressed package of a plurality of pound single pictures, and the compressed package format includes zip and rar. The pound single picture in the non-compressed bag format is a single pound single picture, and the format of the single pound single picture is jpg and pmg, and the like. And the first record id and the picture id are randomly generated and are primary key identifiers. And the batch id is generated according to the currently set batch and is a main key identifier. The first type and the first number are extracted according to the file name of the pound single picture. Analyzing and importing the contents in the pound order data table subjected to the pound order data table preprocessing step in a synchronous processing mode, and extracting a second type, a second number and a second numerical value in the pound order data table; preferably, the pound sign data table is an excel table recording a second type, a second number and a second numerical value of the pound sign. When the file name of the pound single picture after the pound single picture preprocessing step is analyzed, if the first type and the first number of the pound single picture cannot be extracted, an error is reported and modification is prompted. When the content in the pound order data table after the pound order data table preprocessing step is analyzed, if the second type, the second number and the second numerical value in the pound order data table cannot be extracted, an error is reported and modification is prompted.
Picture data association step: associating the first type, the first number, the batch id, the first record id and the picture id of the same pound single picture and then respectively storing the first type, the first number, the batch id, the first record id and the picture id in the service type, the service number, the service batch, the service record and the picture serial number of the service data table; the first type is stored in the service type, the first number is stored in a service number, the batch id is stored in the service batch, the first record id is stored in the service record, and the picture id is stored in the picture serial number; querying a pound single picture matched with the pound single data table, wherein in the matched pound single data table and the pound single picture, the second type is equal to the first type, and the second number is equal to the first number; and then, storing the second numerical value of the pound list data table in the service numerical value of the service data table after associating the second numerical value with the first record id of the pound list picture. At this time, the second value of the pound sheet data is associated with the first type, the first number, the lot id, the first record id and the picture id of the pound sheet picture matched therewith.
In the digitization method of the pound sign of the ceramic supply chain system, the pound sign picture is digitized by matching according to the content of the pound sign picture and the pound sign data table. In the process of processing the pound single pictures, an asynchronous processing mode or a synchronous processing mode is automatically selected, when the pound single pictures are in a compressed packet format, because a plurality of pound single pictures are processed, the pressure on a server is high, and the requirement on real-time performance is not high, the asynchronous processing mode is selected to execute the pound single pictures processed asynchronously in sequence through a single-thread message queue mode, and the task of the next user is continuously executed after the task of the previous user finishes processing a feedback result. Therefore, the influence on the processing efficiency caused by the excessive occupation of the server is avoided; when the format of the pound single picture is the non-compressed packet format, if the processing mode of asynchronous processing is adopted, when the server has 1000 pound single pictures waiting to be processed in line, the efficiency is reduced when the user only needs to process one pound single picture but needs to queue, in addition, because the pressure on the server is small when the single pound single picture is processed, the processing mode of synchronous processing is selected, the system can feed back the result in real time in a multithreading mode, and at the moment, the processing tasks of the single pound single picture between each user are relatively independent, and the server can process the single pound single picture simultaneously. In the process of processing the pound single data tables, each pound single data table is an independent table, so that the processing is independently carried out at any time, a synchronous processing mode is adopted, the pressure on the server is low when a single pound single data table is processed, the synchronous processing mode is selected, the system can feed back results in real time in a multi-thread mode, the processing tasks of the single pound single data table among each user are relatively independent, and the server can simultaneously carry out the processing. The pound single picture and the pound single data table are processed separately, and the pound single picture and the pound single pictures are processed separately, so that the resource of the server is effectively utilized, the dependence of a user on the waiting time of the imported page in the operation is solved, the queuing phenomenon of a plurality of users in the simultaneous operation is reduced, and the efficiency is improved.
In some embodiments, the processing manner of the synchronization processing in the pound-sheet import parsing step is specifically: after receiving requests of one or more users, the server imports the pound single picture in real time through a multithreading mode and analyzes the file name of the pound single picture; after the pound single picture of the corresponding user is processed, immediately feeding back a result to the corresponding user; specifically, after receiving a single user request or a plurality of user requests, the service client waits on a page, and the server processes the analysis and data import of the pound single picture in real time through a multithreading mode; after the task of the corresponding user is processed, feeding back a result to the user corresponding to the single request, wherein the task processing between each user is relatively independent;
the asynchronous processing mode in the pound single import analysis step is specifically as follows: the server receives the asynchronous processing request and returns the result and the serial number of the request; processing pound single pictures in a compressed packet format in the order of time of asynchronous processing requests; and returning the result or unprocessed state after the processing is finished to the corresponding user. When the imported file is in a zip, rar and other compressed packet formats, the system regards as a task needing to import the pound single pictures in batches, because the file size of the pound single pictures is generally in a range of several megabytes, if the picture files are too many, the file size of a single compressed packet is large, the corresponding time waiting for writing in a page is relatively long, the system calls an interface of an asynchronous processing mode, after the server receives a request, the flow is returned, and the service client is displayed as processing. The method specifically comprises the following steps: the server for asynchronously importing the pictures receives the asynchronous processing request and returns a result and a serial number of the request success, and the user can leave the current operation page to wait for the processing result; the server for asynchronously importing the pictures is arranged and executed according to the time sequence of the asynchronous processing request; if the server has the request tasks of the user A, the user B and the user C, the task of the user A is executed firstly, after the task processing is finished, the user A is informed of the execution result, and the picture server is asynchronously led in and then the task of the user B is carried out.
It should be noted that in the picture data association step, after associating the first type, the first number, the batch id, the first record id and the picture id of the same pound single picture, the first type and the first number of the pound single picture of the same batch id are inquired; when the same first type and the same first number cannot be found in the same batch id, creating a new record in the service data table, and respectively storing the first type, the first number, the batch id, the first record id and the picture id of the pound single picture in the service type, the service number, the service batch, the service record and the picture serial number corresponding to the new record in the service data table; when the same first type and first number are found in the same batch id, updating the data of the first record id and the picture id of the entered pound single picture. Specifically, if the same pound single picture cannot be found in the batch id, the system automatically creates a new record in the service data table, and generates data of the corresponding service type, service number, service batch, service record and picture sequence number. If the same pound single picture is found in the batch id, if the data of the picture serial number of the corresponding record in the business data table is empty at the moment, filling the picture id in the picture serial number, and if the data of the picture serial number of the corresponding record in the business data table is not empty at the moment, covering the picture id with the data of the picture serial number.
Optionally, in the picture data association step, when no pound sheet picture matching the pound sheet data table is queried, creating a new record in the business data table, storing the second type, the second number and the second numerical value of the pound sheet data table in the business type, the business number and the business numerical value corresponding to the new record of the business data table, and generating a second record id in the business record of the new record of the pound sheet data table; specifically, the second record id is used to distinguish data within each pound sign data table. When the pound order picture matched with the pound order data table is inquired and the corresponding business numerical value in the business data table stores data, the data in the pound order numerical value is updated to be the second numerical value of the pound order data table. It should be noted that, when the pound sheet picture matching with the pound sheet data table is searched, the pound sheet data table is a modification table of the old pound sheet data table, and the pound sheet data table only modifies the second value in the table, so that the new second value does not need to be inserted to form a new record, but the old second value in the service value of the service data table is updated to the new second value, thereby improving the processing efficiency. Specifically, if the data of the same pound order data table cannot be found in the same batch, the system automatically creates a new record in the business data table to generate the corresponding business type, business number, business value and data of the business record. If the data of the same pound order data table can be found in the same batch, if the service numerical value of the corresponding record of the service data table is empty, filling a second numerical value of the pound order data table to the service numerical value, and if the service numerical value of the corresponding record of the service data table is not empty, covering the second numerical value of the pound order data table with the data of the service numerical value.
Preferably, after the step of associating the picture data, a step of recording and merging is further included, where the step of recording and merging specifically includes: and searching and comparing the data of the service types and the service numbers in the service data table, and combining the records with the same service types and service numbers into one record when the data of the service types and the service numbers of two or more records are the same. In the process of simultaneously importing the pound single data table, the compression packet of the pound single picture and the single pound single picture, the server can create records simultaneously due to the fact that the same associated record cannot be found at the same time with very low probability, therefore, a record merging step is added after the picture data association step, records with the same service type and service number are merged, the situation that two records with the same service type and service number are avoided, a record missing picture and a record missing numerical value are caused, and the precision of the pound single digitalization is improved.
A digitalized system of a ceramic supply chain system pound list comprises a business data table presetting module, a pound list picture preprocessing module, a pound list data table preprocessing module, a pound list import analysis module and a picture data correlation module; the service data table presetting module is used for presetting a service data table, and the service data table comprises service records, service batches, picture sequence numbers, service types, service numbers and service numerical values;
the pound single picture preprocessing module is used for renaming the file names of pound single pictures in batches according to a first format, wherein the first format comprises a first type and a first number; the system is also used for packing and compressing a plurality of pound single pictures when the pound single pictures preprocessed by the same user are a plurality of pound single pictures; the system is also used for not packing and compressing the pound single picture when the pound single picture preprocessed by the same user is a single picture;
the pound order data sheet preprocessing module is used for inputting the content in the pound order picture in a pound order data sheet according to a second format, wherein the second format comprises a second type, a second number and a second numerical value;
the pound order import analysis module is used for selecting a processing mode according to the format of the pound order picture, importing the pound order picture and analyzing the file name of the pound order picture, extracting a first type and a first number in the file name of the pound order picture, and generating a batch id, a first record id and a picture id corresponding to the pound order picture; the batch id records the import batch of the pound single pictures, and each pound single picture corresponds to a unique first record id and a unique picture id; when the imported and analyzed pound single pictures are in a compressed packet format, selecting an asynchronous processing mode, and unpacking the pound single pictures in the compressed packet format; when the imported and analyzed pound single pictures are in a non-compressed packet format, selecting a synchronous processing mode; the system is also used for analyzing and importing the contents in the pound order data table in a synchronous processing mode, and extracting a second type, a second number and a second numerical value in the pound order data table;
the picture data association module is used for associating the first type, the first number, the batch id, the first record id and the picture id of the same pound single picture and then respectively storing the first type, the first number, the batch id, the first record id and the picture id in the service type, the service number, the service batch, the service record and the picture sequence number of the service data table; the first type is stored in the service type, the first number is stored in a service number, the batch id is stored in the service batch, the first record id is stored in the service record, and the picture id is stored in the picture serial number; the system is also used for inquiring a pound single picture matched with the pound single data table, wherein in the matched pound single data table and the pound single picture, the second type is equal to the first type, and the second number is equal to the first number; and the system is also used for storing a second numerical value of the pound list data table in a business numerical value of the business data table after the second numerical value is associated with the first record id of the pound list picture.
In some embodiments, the processing mode of the synchronization processing is specifically configured to, after receiving a request from a single user or multiple users, import the pound single picture and parse a file name of the pound single picture in real time by using a server in a multithreading mode; the system is also used for feeding back the result to the corresponding user in real time after the pound single picture of the corresponding user is processed;
the processing mode of the asynchronous processing is specifically used for receiving an asynchronous processing request by using a server and returning a request result and a serial number; the system is also used for processing pound single pictures in a compressed packet format according to the sequence of the time of asynchronous processing requests; and the method is also used for returning the result or unprocessed state after the processing is finished to the corresponding user.
It should be noted that the picture data association module is further configured to query the first type and the first number of the pound single picture of the same batch id after associating the first type, the first number, the batch id, the first record id and the picture id of the same pound single picture;
the system is further used for creating a new record in the business data table when the same first type and the same first number cannot be found in the same batch id, and respectively storing the first type, the first number, the batch id, the first record id and the picture id of the pound single picture in the business type, the business number, the business batch, the business record and the picture sequence number corresponding to the new record in the business data table;
and the data of the first record id and the picture id of the entered pound single picture are updated when the same first type and the same first label are found in the same batch id.
Optionally, the image data association module is further configured to create a new record in the service data table when no pound sheet image matched with the pound sheet data table is queried, store the second type, the second number, and the second numerical value of the pound sheet data table in the service type, the service number, and the service numerical value corresponding to the new record of the service data table, and generate a second record id in the service record of the new record of the pound sheet data table; and when the pound list picture matched with the pound list data table is inquired and the corresponding business numerical value in the business data table stores data, updating the data in the pound list numerical value into a second numerical value of the pound list data table.
The system comprises a service data table, a record merging module and a recording and merging module, wherein the service data table comprises a plurality of records, the record merging module is used for searching and comparing data of service types and service numbers in the service data table, and is also used for merging the records with the same service types and service numbers into one record when the data of the service types and the service numbers of two or more records are the same.
In the description herein, references to the description of the terms "one embodiment," "some embodiments," "an illustrative embodiment," "an example," "a specific example" or "some examples" or the like mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, schematic representations of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps of the process, and alternate implementations are included within the scope of the preferred embodiment of the present invention in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present invention.
In addition, functional units in the embodiments of the present invention may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may also be stored in a computer readable storage medium.
Although embodiments of the present invention have been shown and described above, it is understood that the above embodiments are exemplary and not to be construed as limiting the present invention, and that variations, modifications, substitutions and alterations can be made in the above embodiments by those of ordinary skill in the art within the scope of the present invention.
Claims (8)
1. A digitization method of a ceramic supply chain system balance sheet is characterized in that: the method comprises the following steps:
presetting a service data table: presetting a service data table, wherein the service data table comprises service records, service batches, picture sequence numbers, service types, service numbers and service numerical values;
b, single picture pretreatment: renaming the file names of the pound single pictures in batches according to a first format, wherein the first format comprises a first type and a first number;
when a plurality of pound single pictures are preprocessed by the same user, packaging and compressing the pound single pictures; when the pound single picture preprocessed by the same user is a single picture, the pound single picture is not packed and compressed;
and b, preprocessing a pound list data table: entering the content in the pound sign picture in a pound sign data sheet according to a second format, wherein the second format comprises a second type, a second number and a second numerical value;
and b, pound sheet introduction and analysis step: selecting a processing mode according to the format of the pound single picture in the pound single picture preprocessing step, importing the pound single picture subjected to the pound single picture preprocessing step, analyzing the filename of the pound single picture, extracting a first type and a first number in the filename of the pound single picture, and generating a batch id, a first record id and a picture id corresponding to the pound single picture; the batch id records the import batch of the pound single pictures, and each pound single picture corresponds to a unique first record id and a unique picture id; when the imported and analyzed pound single pictures are in a compressed packet format, selecting an asynchronous processing mode, and unpacking the pound single pictures in the compressed packet format; when the imported and analyzed pound single pictures are in a non-compressed packet format, selecting a synchronous processing mode;
analyzing and importing the contents in the pound order data table subjected to the pound order data table preprocessing step in a synchronous processing mode, and extracting a second type, a second number and a second numerical value in the pound order data table;
picture data association step: associating the first type, the first number, the batch id, the first record id and the picture id of the same pound single picture and then respectively storing the first type, the first number, the batch id, the first record id and the picture id in the service type, the service number, the service batch, the service record and the picture serial number of the service data table; the first type is stored in the service type, the first number is stored in a service number, the batch id is stored in the service batch, the first record id is stored in the service record, and the picture id is stored in the picture serial number;
querying a pound single picture matched with the pound single data table, wherein in the matched pound single data table and the pound single picture, the second type is equal to the first type, and the second number is equal to the first number; then, the second numerical value of the pound list data table is associated with the first record id of the pound list picture and then is stored in the service numerical value of the service data table;
the processing mode of synchronous processing in the pound sheet import analysis step is specifically as follows:
after receiving requests of one or more users, the server imports the pound single picture in real time through a multithreading mode and analyzes the file name of the pound single picture;
after the pound single picture of the corresponding user is processed, immediately feeding back a result to the corresponding user;
the asynchronous processing mode in the pound single import analysis step is specifically as follows:
the server receives the asynchronous processing request and returns the result and the serial number of the request;
processing pound single pictures in a compressed packet format in the order of time of asynchronous processing requests;
and returning the result or unprocessed state after the processing is finished to the corresponding user.
2. The method of claim 1, wherein the method further comprises: in the picture data association step, after associating the first type, the first number, the batch id, the first record id and the picture id of the same pound single picture, inquiring the first type and the first number of the pound single picture of the same batch id;
when the same first type and the same first number cannot be found in the same batch id, creating a new record in the service data table, and respectively storing the first type, the first number, the batch id, the first record id and the picture id of the pound single picture in the service type, the service number, the service batch, the service record and the picture serial number corresponding to the new record in the service data table;
when the same first type and first number are found in the same batch id, updating the data of the first record id and the picture id of the entered pound single picture.
3. The method of claim 2, wherein the step of digitizing the pound sign of the ceramic supply chain system comprises: in the picture data association step, when a pound note picture matched with the pound note data table is not inquired, creating a new record in the business data table, respectively storing a second type, a second number and a second numerical value of the pound note data table in a business type, a business number and a business numerical value corresponding to the new record of the business data table, and generating a second record id in the business record of the new record of the pound note data table;
when the pound order picture matched with the pound order data table is inquired and the corresponding business numerical value in the business data table stores data, the data in the pound order numerical value is updated to be the second numerical value of the pound order data table.
4. The method of claim 3, wherein the step of digitizing the pound sign of the ceramic supply chain system comprises: after the picture data association step, a record merging step is further included, wherein the record merging step specifically comprises the following steps:
and searching and comparing the data of the service types and the service numbers in the service data table, and combining the records with the same service types and service numbers into one record when the data of the service types and the service numbers of two or more records are the same.
5. A digitizer system for a ceramic supply chain system pound order, comprising: the system comprises a business data table presetting module, a pound single picture preprocessing module, a pound single data table preprocessing module, a pound single import analysis module and a picture data correlation module;
the service data table presetting module is used for presetting a service data table, and the service data table comprises service records, service batches, picture sequence numbers, service types, service numbers and service numerical values;
the pound single picture preprocessing module is used for renaming the file names of pound single pictures in batches according to a first format, wherein the first format comprises a first type and a first number; the system is also used for packing and compressing a plurality of pound single pictures when the pound single pictures preprocessed by the same user are a plurality of pound single pictures; the system is also used for not packing and compressing the pound single picture when the pound single picture preprocessed by the same user is a single picture;
the pound order data sheet preprocessing module is used for inputting the content in the pound order picture in a pound order data sheet according to a second format, wherein the second format comprises a second type, a second number and a second numerical value;
the pound order import analysis module is used for selecting a processing mode according to the format of the pound order picture, importing the pound order picture and analyzing the file name of the pound order picture, extracting a first type and a first number in the file name of the pound order picture, and generating a batch id, a first record id and a picture id corresponding to the pound order picture; the batch id records the import batch of the pound single pictures, and each pound single picture corresponds to a unique first record id and a unique picture id; when the imported and analyzed pound single pictures are in a compressed packet format, selecting an asynchronous processing mode, and unpacking the pound single pictures in the compressed packet format; when the imported and analyzed pound single pictures are in a non-compressed packet format, selecting a synchronous processing mode; the system is also used for analyzing and importing the contents in the pound order data table in a synchronous processing mode, and extracting a second type, a second number and a second numerical value in the pound order data table;
the picture data association module is used for associating the first type, the first number, the batch id, the first record id and the picture id of the same pound single picture and then respectively storing the first type, the first number, the batch id, the first record id and the picture id in the service type, the service number, the service batch, the service record and the picture sequence number of the service data table; the first type is stored in the service type, the first number is stored in a service number, the batch id is stored in the service batch, the first record id is stored in the service record, and the picture id is stored in the picture serial number; the system is also used for inquiring a pound single picture matched with the pound single data table, wherein in the matched pound single data table and the pound single picture, the second type is equal to the first type, and the second number is equal to the first number; the system is also used for associating the second numerical value of the pound list data table with the first record id of the pound list picture and then storing the second numerical value in the service numerical value of the service data table;
the processing mode of the synchronous processing is specifically used for importing the pound single picture and analyzing the file name of the pound single picture in real time by using a server through a multithreading mode after receiving the request of a single user or a plurality of users; the system is also used for feeding back the result to the corresponding user in real time after the pound single picture of the corresponding user is processed;
the processing mode of the asynchronous processing is specifically used for receiving an asynchronous processing request by using a server and returning a request result and a serial number; the system is also used for processing pound single pictures in a compressed packet format according to the sequence of the time of asynchronous processing requests; and the method is also used for returning the result or unprocessed state after the processing is finished to the corresponding user.
6. The digitizer system for a ceramic supply chain system pound sign according to claim 5, wherein: the image data association module is further used for inquiring the first type and the first number of the pound single image of the same batch id after associating the first type, the first number, the batch id, the first record id and the image id of the same pound single image;
the system is further used for creating a new record in the business data table when the same first type and the same first number cannot be found in the same batch id, and respectively storing the first type, the first number, the batch id, the first record id and the picture id of the pound single picture in the business type, the business number, the business batch, the business record and the picture sequence number corresponding to the new record in the business data table;
and the data of the first record id and the picture id of the entered pound single picture are updated when the same first type and the same first number are found in the same batch id.
7. The digitizer system for a ceramic supply chain system pound sign according to claim 6, wherein: the image data association module is further used for creating a new record in the business data table when the pound single image matched with the pound single data table is not inquired, respectively storing the second type, the second number and the second numerical value of the pound single data table in the business type, the business number and the business numerical value corresponding to the new record of the business data table, and generating a second record id in the business record of the new record of the pound single data table;
and when the pound list picture matched with the pound list data table is inquired and the corresponding business numerical value in the business data table stores data, updating the data in the pound list numerical value into a second numerical value of the pound list data table.
8. The digitizer system according to claim 7, wherein: the system also comprises a record merging module, wherein the record merging module is used for retrieving and comparing the data of the service types and the service numbers in the service data table, and is also used for merging the records with the same service types and the same service numbers into one record when the data of the service types and the service numbers of two or more records are the same.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111557889.XA CN113947389B (en) | 2021-12-20 | 2021-12-20 | Digitization method and digitization system for balance sheet of ceramic supply chain system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111557889.XA CN113947389B (en) | 2021-12-20 | 2021-12-20 | Digitization method and digitization system for balance sheet of ceramic supply chain system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113947389A CN113947389A (en) | 2022-01-18 |
| CN113947389B true CN113947389B (en) | 2022-04-22 |
Family
ID=79339250
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111557889.XA Active CN113947389B (en) | 2021-12-20 | 2021-12-20 | Digitization method and digitization system for balance sheet of ceramic supply chain system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113947389B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111984607A (en) * | 2020-08-18 | 2020-11-24 | 中国建设银行股份有限公司 | Distributed picture processing and storing method and device |
| CN112668571A (en) * | 2020-12-08 | 2021-04-16 | 安徽经邦软件技术有限公司 | Financial statement recognition system based on artificial intelligence OCR technology |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103870826B (en) * | 2014-03-31 | 2017-10-13 | 深圳市远行科技股份有限公司 | The method and system that a kind of electronic record scanning recognition is filed |
| CN104166671A (en) * | 2014-06-17 | 2014-11-26 | 京东方科技集团股份有限公司 | File management method and file management device |
| CN104391938B (en) * | 2014-11-24 | 2017-10-10 | 武汉海川云谷软件技术有限公司 | A kind of picture batch in physical assets management imports the method and system of database |
| CN107403140A (en) * | 2017-07-04 | 2017-11-28 | 南京律智诚专利技术开发有限公司 | A kind of card information identification and business card image matching management method |
| CN110059688B (en) * | 2019-03-19 | 2024-05-28 | 平安科技（深圳）有限公司 | Picture information identification method, device, computer equipment and storage medium |
-
2021
- 2021-12-20 CN CN202111557889.XA patent/CN113947389B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111984607A (en) * | 2020-08-18 | 2020-11-24 | 中国建设银行股份有限公司 | Distributed picture processing and storing method and device |
| CN112668571A (en) * | 2020-12-08 | 2021-04-16 | 安徽经邦软件技术有限公司 | Financial statement recognition system based on artificial intelligence OCR technology |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113947389A (en) | 2022-01-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111767254B (en) | Multi-file reading device and method based on format data stream file technology | |
| US7343385B2 (en) | System for processing objects for storage in a document or other storage system | |
| JP3703157B2 (en) | Form processing method and apparatus | |
| US20040049738A1 (en) | Computer implemented system and method of transforming a source file into a transfprmed file using a set of trigger instructions | |
| US9251212B2 (en) | Profiling in a massive parallel processing environment | |
| JPH0683879A (en) | Method and device for labelling document for preservation, handling and introduction | |
| US20080077862A1 (en) | Techniques for rendering media as layers | |
| US20070257908A1 (en) | System and method for parsing point-cloud data | |
| CN110737630A (en) | Method and device for processing electronic archive file, computer equipment and storage medium | |
| CN105335453B (en) | Image file dividing method | |
| CN106227575B (en) | Method for generating and analyzing text file | |
| US11468107B2 (en) | Enhance a mail application to format a long email conversation for easy consumption | |
| TW201506652A (en) | Method for naming image file | |
| CN116612484A (en) | File digital processing system | |
| CN113947389B (en) | Digitization method and digitization system for balance sheet of ceramic supply chain system | |
| US9146905B2 (en) | Generating page-oriented data for printing dynamic documents | |
| CN113806368A (en) | System and method for identifying document and automatically establishing database | |
| CN106209605A (en) | The processing method of adnexa and equipment in a kind of network information | |
| CN113157642A (en) | Method for realizing electronic material digital process automation | |
| CN111368178A (en) | Information processing method and device and readable storage medium | |
| US20160041802A1 (en) | Data transfer system, method of transferring data, and system | |
| JP2000020640A (en) | Classification system, retrieval system, classification method and recording medium | |
| CN112861473A (en) | Directory examination result summarizing system and method based on openpyxl | |
| CN110706309B (en) | Method and device for generating fishbone map | |
| Kwok et al. | A web services integration to manage invoice identification, metadata extraction, storage and retrieval in a multi-tenancy SaaS application |
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 |