CN112581014B - Statistical method, device, equipment and storage medium for material readiness - Google Patents
Statistical method, device, equipment and storage medium for material readiness Download PDFInfo
- Publication number
- CN112581014B CN112581014B CN202011574075.2A CN202011574075A CN112581014B CN 112581014 B CN112581014 B CN 112581014B CN 202011574075 A CN202011574075 A CN 202011574075A CN 112581014 B CN112581014 B CN 112581014B
- Authority
- CN
- China
- Prior art keywords
- commodity
- bar codes
- materials
- brand
- uploading
- 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
- 239000000463 material Substances 0.000 title claims abstract description 237
- 238000007619 statistical method Methods 0.000 title claims abstract description 20
- 238000000034 method Methods 0.000 claims abstract description 27
- 238000007781 pre-processing Methods 0.000 claims abstract description 11
- 238000002360 preparation method Methods 0.000 claims description 23
- 238000012545 processing Methods 0.000 claims description 12
- 238000004590 computer program Methods 0.000 claims description 6
- 238000005516 engineering process Methods 0.000 abstract description 5
- 239000002699 waste material Substances 0.000 abstract description 3
- 230000006870 function Effects 0.000 description 11
- 238000010586 diagram Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000007599 discharging Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000012552 review Methods 0.000 description 1
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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K17/00—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
- G06K17/0022—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device
- G06K17/0025—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisious for transferring data to distant stations, e.g. from a sensing device the arrangement consisting of a wireless interrogation device in combination with a device for optically marking the record carrier
-
- 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
Abstract
The application discloses a statistical method, device, equipment and storage medium for material readiness. The method comprises the steps of obtaining a target statistical table, wherein the target statistical table comprises commodity categories, commodity brands, bar codes and commodity names, and a plurality of bar codes are respectively associated with a plurality of materials; preprocessing a target statistical table to obtain a table chart; counting the number of the materials respectively associated with the plurality of bar codes corresponding to each commodity brand according to the table chart and the plurality of materials respectively associated with the plurality of bar codes; and determining uploading identifiers of the bar codes according to the number of the materials, and determining the material readiness of the commodity brands according to the uploading identifiers. The application has high intelligent degree, does not depend on manual auditing any more, and improves the statistical accuracy and the statistical efficiency. The application solves the technical problems of time and labor waste and easy error when manually checking whether the material is ready or not in the related technology.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a statistical method, apparatus, device, and storage medium for material readiness.
Background
In recent years, the degree of commercialization of the market has been increasing, and the marketing department of suppliers has been required to check monthly whether or not goods are ready for listing in sales channels to ensure normal market supply. The checked up-shelf materials are basically uploaded by brand construction departments and digital creative departments, staff of a marketing department need to manually check whether the materials checked in the month are uploaded on a digital asset management platform in the company, and after all the materials are uploaded, the marketing department can search commodities and download relevant data on the digital asset management platform according to bar codes.
Since the number of commodity barcodes audited by marketing departments per month is numerous, and each barcode also needs to be audited by different auditing logics according to different scenes, for example, in some scenes, whether the number of white background picture materials under each barcode is more than or equal to 5, whether the number of detail page materials is more than or equal to 1, whether the number of main picture videos is more than or equal to 1, whether experimental videos are more than or equal to 1, and only when the above 4 indexes meet the requirements, the commodity corresponding to the barcode is calculated to be ready; in other situations, the short video material amount in the asset management platform needs to be counted according to the bar code, the counted material amount is compared with the check number, and the material completion degree is calculated to determine whether the system is ready.
When the manual auditing is carried out, each material detail page is required to be entered for checking related basic data, and then all basic data are manually counted, so that the problems of time and labor waste and easy error exist.
Aiming at the problems that time and labor are wasted and mistakes are easy to occur when manually checking whether materials are ready in the related technology, no effective solution is proposed at present.
Disclosure of Invention
The application mainly aims to provide a statistical method, device, equipment and storage medium for material readiness, so as to solve the problems of time and labor waste and easy error when manually checking whether the material is ready in the related technology.
In order to achieve the above object, in a first aspect, the present application provides a statistical method for material readiness.
The method according to the application comprises the following steps:
obtaining a target statistical table, wherein the target statistical table comprises a plurality of commodity categories, a plurality of commodity brands corresponding to each commodity category, a plurality of bar codes corresponding to each commodity brand respectively and commodity names corresponding to the plurality of bar codes respectively, and the plurality of bar codes are respectively associated with a plurality of materials;
preprocessing a target statistical table to obtain a table chart;
counting the number of the materials respectively associated with the plurality of bar codes corresponding to each commodity brand under a preset scene according to the table chart and the plurality of materials respectively associated with the plurality of bar codes;
and determining uploading identifiers of the bar codes according to the number of the materials and a preset number threshold value, and determining the material readiness of the corresponding commodity brands according to the uploading identifiers of the bar codes.
In one possible implementation manner of the present application, preprocessing is performed on a target statistical table to obtain a table chart, including:
for the same commodity category, unifying the category names of the commodity categories;
for the same commodity brand, unifying the brand names of the commodity brands;
the plurality of bar codes are deleted or combined according to the commodity channel of each bar code.
In one possible implementation of the present application, deleting or merging the plurality of barcodes according to the commodity channel of each barcode includes:
if each bar code has a corresponding commodity channel, deleting the bar codes, the commodity names and the bar codes with the same commodity channel;
combining bar codes with the same commodity name and different commodity channels;
if each bar code does not have a corresponding commodity channel, the bar codes with the same names as the commodity are deleted.
In one possible implementation of the present application, after the plurality of barcodes are combined, each of the combined barcodes is separated according to a preset separator.
In one possible implementation manner of the present application, the uploading identifier includes a first identifier and a second identifier, where the first identifier is used to identify that the number of materials associated with the barcode reaches a number threshold, the second identifier is used to identify that the number of materials associated with the barcode does not reach the number threshold, and determining the uploading identifier of the barcode according to the number of materials and a preset number threshold includes:
comparing the number of the bar code associated material with a number threshold;
if the number of the materials is greater than or equal to a number threshold, configuring a first identifier for the bar code;
if the number of the materials is smaller than the number threshold, configuring a second mark for the bar code.
In one possible implementation manner of the present application, determining a material preparation degree of a corresponding commercial brand according to uploading identifiers of a plurality of bar codes includes:
counting the number of bar codes carrying the first mark to obtain the uploading quantity of the corresponding commodity brand materials;
comparing the uploading quantity of the material with a preset brand material checking quantity;
if the uploading quantity of the materials is larger than or equal to the brand material checking quantity, the material preparation degree is not smaller than 1;
if the uploading amount of the material is smaller than the brand material checking amount, the material preparation degree is smaller than 1.
In a second aspect, the present application further provides a statistical apparatus for material readiness, where the apparatus includes:
the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring a target statistical table, the target statistical table comprises a plurality of commodity categories, a plurality of commodity brands corresponding to each commodity category, a plurality of bar codes corresponding to each commodity brand and commodity names corresponding to the plurality of bar codes, and the plurality of bar codes are respectively associated with a plurality of materials;
the processing module is used for preprocessing the target statistical table to obtain a table chart;
counting the number of the materials respectively associated with the plurality of bar codes corresponding to each commodity brand under a preset scene according to the table chart and the plurality of materials respectively associated with the plurality of bar codes;
and the output module is used for determining uploading identifiers of the bar codes according to the number of the materials and a preset number threshold value, and determining the material readiness of the corresponding commodity brands according to the uploading identifiers of the bar codes.
In one possible implementation manner of the present application, the processing module is specifically configured to:
for the same commodity category, unifying the category names of the commodity categories;
for the same commodity brand, unifying the brand names of the commodity brands;
the plurality of bar codes are deleted or combined according to the commodity channel of each bar code.
In a possible implementation manner of the present application, the processing module is specifically further configured to:
if each bar code has a corresponding commodity channel, deleting the bar codes, the commodity names and the bar codes with the same commodity channel;
combining bar codes with the same commodity name and different commodity channels;
if each bar code does not have a corresponding commodity channel, the bar codes with the same names as the commodity are deleted.
In one possible implementation manner of the present application, the uploading identifier includes a first identifier and a second identifier, where the first identifier is used to identify that the number of the materials associated with the bar code reaches a number threshold, the second identifier is used to identify that the number of the materials associated with the bar code does not reach the number threshold, and the output module is specifically configured to:
comparing the number of the bar code associated material with a number threshold;
if the number of the materials is greater than or equal to a number threshold, configuring a first identifier for the bar code;
if the number of the materials is smaller than the number threshold, configuring a second mark for the bar code.
In one possible implementation manner of the present application, the output module is specifically further configured to:
counting the number of bar codes carrying the first mark to obtain the uploading quantity of the corresponding commodity brand materials;
comparing the uploading quantity of the material with a preset brand material checking quantity;
if the uploading quantity of the materials is larger than or equal to the brand material checking quantity, the material preparation degree is not smaller than 1;
if the uploading amount of the material is smaller than the brand material checking amount, the material preparation degree is smaller than 1.
In a third aspect, the present application also provides a statistical electronic device for preparing a material, where the electronic device includes:
one or more processors;
a memory; and
one or more applications, wherein the one or more applications are stored in memory and configured to be executed by a processor to implement the statistical method of material readiness of any of the first aspects.
In a fourth aspect, the present application also provides a computer readable storage medium having stored thereon a computer program for loading by a processor to perform the steps of the statistical method of material readiness of any of the first aspects.
In the embodiment of the application, a statistical method of material readiness is provided, the number of the materials respectively associated with the plurality of bar codes corresponding to each commodity brand is counted through a plurality of materials respectively associated with a table chart and the plurality of bar codes, then the material readiness of the commodity brand is determined through comparing the number of the materials with a preset number threshold value, the intelligent degree is high, manual auditing is not relied, and the statistical accuracy and the statistical efficiency are improved; and further solves the technical problems that time and labor are wasted and mistakes are easy to occur when the materials are manually checked to be ready in the related technology.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application, are incorporated in and constitute a part of this specification. The drawings and their description are illustrative of the application and are not to be construed as unduly limiting the application. In the drawings:
FIG. 1 is a flow chart of an embodiment of a statistical method for material readiness according to an embodiment of the present application;
FIG. 2 is a flow chart of an embodiment of generating a readiness for material according to an embodiment of the present application;
FIG. 3 is a schematic structural diagram of an embodiment of a statistics device for material readiness according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of an embodiment of a statistical electronic device for material preparation according to an embodiment of the present application.
Detailed Description
In order that those skilled in the art will better understand the present application, a technical solution in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present application without making any inventive effort, shall fall within the scope of the present application.
It should be noted that the terms "first," "second," and the like in the description and the claims of the present application and the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate in order to describe the embodiments of the application herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
In the present application, the terms "upper", "lower", "left", "right", "front", "rear", "top", "bottom", "inner", "outer", "middle", "vertical", "horizontal", "lateral", "longitudinal" and the like indicate an azimuth or a positional relationship based on that shown in the drawings. These terms are only used to better describe the present application and its embodiments and are not intended to limit the scope of the indicated devices, elements or components to the particular orientations or to configure and operate in the particular orientations.
Also, some of the terms described above may be used to indicate other meanings in addition to orientation or positional relationships, for example, the term "upper" may also be used to indicate some sort of attachment or connection in some cases. The specific meaning of these terms in the present application will be understood by those of ordinary skill in the art according to the specific circumstances.
In addition, the term "plurality" shall mean two as well as more than two.
It should be noted that, without conflict, the embodiments of the present application and features of the embodiments may be combined with each other. The application will be described in detail below with reference to the drawings in connection with embodiments.
Firstly, an embodiment of the present application provides a method for counting material readiness, an execution subject of the method for counting material readiness is a device for counting material readiness, the device for counting material readiness is applied to a processor, and the method for counting material readiness includes: obtaining a target statistical table, wherein the target statistical table comprises a plurality of commodity categories, a plurality of commodity brands corresponding to each commodity category, a plurality of bar codes corresponding to each commodity brand respectively and commodity names corresponding to the plurality of bar codes respectively, and the plurality of bar codes are respectively associated with a plurality of materials; preprocessing a target statistical table to obtain a table chart; counting the number of the materials respectively associated with the plurality of bar codes corresponding to each commodity brand under a preset scene according to the table chart and the plurality of materials respectively associated with the plurality of bar codes; and determining uploading identifiers of the bar codes according to the number of the materials and a preset number threshold value, and determining the material readiness of the corresponding commodity brands according to the uploading identifiers of the bar codes.
Referring to fig. 1, fig. 1 is a flowchart of an embodiment of a method for counting material readiness according to an embodiment of the present application, where the method for counting material readiness includes:
101. and obtaining a target statistical table, wherein the target statistical table comprises a plurality of commodity categories, a plurality of commodity brands corresponding to each commodity category, a plurality of bar codes corresponding to each commodity brand and commodity names corresponding to the plurality of bar codes, and the plurality of bar codes are respectively associated with a plurality of materials.
In the embodiment of the present application, the mode of acquiring the target statistics form by the processor may be passive, for example, the user uploads the target statistics form through the terminal, and the terminal uploads the target statistics form to the processor, so that the processor acquires the target statistics form; the method can also be active acquisition, for example, the terminal or other storage devices with storage function stores the target statistical table, the processor accesses the terminal or other storage devices with storage function at regular intervals, and when a new target statistical table exists, the processor actively acquires the new target statistical table from the terminal or other storage devices with storage function.
In the embodiment of the application, the materials can be white background image materials, detail page materials, main image videos, experimental videos, short video materials and the like which are uploaded by related departments and are related to the bar codes; the target statistics may include data related to the bar code requiring statistical review, such as merchandise category, merchandise brand, merchandise name, merchandise channel, etc., which may include, for example, "merchandise category a-merchandise brand a-bar code 690205-merchandise name XX".
102. And preprocessing the target statistical table to obtain a table chart.
In the embodiment of the application, because the obtained object statistics table stores commodity categories, commodity brands and the like which possibly have different names in the same category or the same brand, in order to ensure the accuracy of subsequent statistics results, the category names of the same commodity category and the brand names of the same commodity brand need to be unified, for example, in the object statistics table, two pieces of data respectively including a commodity category A-commodity brand a-bar code 1-commodity name XX and a commodity category AA-commodity brand AA-bar code 3-commodity name ZZ are present, and in fact, the commodity category A and the commodity category AA represent the same commodity category, the commodity category AA can be modified into the commodity category A, or the commodity category A can be modified into the commodity category AA, or the commodity category A can be modified into the commodity category A'; similarly, for the brand, if the "brand a" and the "brand aa" represent the same brand, the "brand aa" may be modified to the "brand a", the "brand a" may be modified to the "brand aa", or the "brand a" and the "brand aa" may be uniformly modified to the "category a'", which is not limited herein. In addition, if some commodity brands in the target statistics table are sub-level brands belonging to other commodity brands, the brand names of the sub-brands can be uniformly modified into the brand names of the parent level brands
Meanwhile, in the embodiment of the application, a plurality of bar codes can be deleted or combined according to the commodity channel of each bar code to reduce the target statistics table, specifically, if each bar code has a corresponding commodity channel, the bar codes with the same bar code, commodity name and commodity channel, the combined bar codes with the same commodity name and different commodity channels can be deleted, if each bar code has no corresponding commodity channel, the bar codes with the same bar code and commodity name can be deleted, the combined bar codes can be separated according to a preset separator, the form of the separator can be "/", "-", and the like, for example, the data of the bar codes obtained after the combination can be "bar code 1/bar code 3/bar code 8".
It should be noted that, because the category names or brand names may be longer, which is inconvenient for statistical recognition, in the embodiment of the present application, category codes (such as "category a" - "category code 001") may be configured for different product categories, and brand codes (such as "product brand a" - "brand code 00101") may be configured for different product brands, where one category code corresponds to one product category and one brand code corresponds to one product brand, so that the table chart can be more clear and intuitive.
103. And counting the number of the materials respectively associated with the plurality of bar codes corresponding to each commodity brand under a preset scene according to the table chart and the plurality of materials respectively associated with the plurality of bar codes.
In the embodiment of the application, different preset scenes can be correspondingly provided with different statistical objects and statistical methods, and the statistical methods can be specifically selected according to practical application conditions, for example, the method is not limited herein, for short video tracking scenes, the main statistics is the number of materials related to videos, for other application scenes, the statistics can be the number of materials of other categories related to bar codes, and the like.
In the application, the related data of the bar code to be checked can be stored in the table chart, firstly, the bar code identical to the bar code can be searched according to the bar code in the table chart, and then, the quantity of materials related to the bar code is counted.
If one bar code of the "commodity brand a" in the table chart is "bar code 01", and there is "bar code 01" associated with "material 1", "bar code 01" associated with "material 5", and "bar code 01" associated with "material 11", 3 materials (such as "material 1", "material 5", and "material 11") associated with "bar code 01" can be statistically obtained after the system is queried according to "bar code 01".
104. And determining uploading identifiers of the bar codes according to the number of the materials and a preset number threshold value, and determining the material readiness of the corresponding commodity brands according to the uploading identifiers of the bar codes.
In the embodiment of the present application, the uploading identifier may be a first identifier and a second identifier, which represent different states, where the first identifier may be used to identify that the number of materials associated with the barcode reaches a number threshold, and the second identifier is used to identify that the number of materials associated with the barcode does not reach a number threshold, for example, the first identifier is 1, the second identifier is 0, if the number 3 of materials associated with the barcode 1 is equal to the number threshold 3, the first identifier "1" may be configured for the barcode 1, and if the number 1 of materials associated with the barcode 1 is smaller than the number threshold 3, the first identifier "0" may be configured for the barcode 1 ". The uploading identification of each bar code can be counted because one commodity brand can correspond to a plurality of bar codes, so that the material readiness of the commodity brand is obtained, and further, the readiness of the commodity brand can be further obtained according to the material accuracy of the commodity brand because one commodity brand can correspond to a plurality of commodity brands.
In the embodiment of the application, the statistics method of the material preparation degree is provided, the number of the materials respectively associated with the plurality of bar codes corresponding to each commodity brand is counted through the plurality of materials respectively associated with the table chart and the plurality of bar codes, and then the material preparation degree of the commodity brand is determined through comparing the number of the materials with the preset number threshold value, so that the intelligent degree is high, the manual examination is not relied, and the statistics accuracy and the statistics efficiency are improved.
As shown in fig. 2, a flow chart of an embodiment of generating a material readiness according to the embodiment of the present application is shown, in some embodiments of the present application, determining the material readiness of a corresponding commercial brand according to uploading identifiers of a plurality of bar codes may further include:
201. and counting the number of the bar codes carrying the first identification to obtain the uploading quantity of the corresponding commodity brand materials.
In step 104, different uploading identifiers are configured for the bar codes according to the number of the materials and a preset number threshold, and because the first identifier identifies that the number of the materials related to the bar codes reaches the number threshold, that is, the number of the materials of the bar codes reaches the number threshold, in the embodiment of the application, the number of the bar codes carrying the first identifier under the same commodity brand is counted first, wherein the counting mode can be an accumulating mode, for example, the number of the bar codes carrying the first identifier corresponds to 2 bar codes, namely, the number of the bar codes corresponding to the commodity brand a is respectively the number of the bar codes 1 and the number of the bar codes 3, and the number of the bar codes corresponding to the commodity brand a is 2.
202. And comparing the uploading quantity of the material with a preset brand material checking quantity.
203. If the uploading quantity of the materials is larger than or equal to the brand material checking quantity, the material preparation degree is not smaller than 1; if the uploading amount of the material is smaller than the brand material checking amount, the material preparation degree is smaller than 1.
In the embodiment of the application, the preset brand material assessment amount can be set manually, can be obtained by analyzing historical data of the commodity brands, and can be obtained by perspective according to an excel table data perspective method. In the embodiment of the present application, if the brand material assessment amount 2 of the "commercial brand a" is also 2, the material preparation degree may be a ratio between the material upload amount and the brand material assessment amount, that is, the material preparation degree=the material upload amount/the brand material assessment amount is 100% =2/2×100% =1; if the brand material check amount of the "commercial brand a" is 2 and the material upload amount obtained in step 201 is 1, the corresponding material preparation degree is 1/2×100% =50%, and in this case, the material missing amount, that is, the difference between the material upload amount and the brand material check amount may also be calculated.
In addition, the preparation degree of the commodity category may be determined according to the uploading amount of the commodity brand, for example, for the "commodity category a", the uploading amount of the commodity brand a "and the" commodity brand b "corresponding to the commodity category a" is 2, the uploading amount of the commodity brand b "corresponding to the commodity brand b is 3, the total uploading amount of the commodity category a corresponding to the commodity category a is 5, the preset checking amount of the commodity category a 'category material is 8, the preparation degree of the commodity category a' is 5/8×100% =62.5%, and the corresponding material missing amount is 3.
In order to better implement the method for counting the material readiness according to the embodiment of the present application, on the basis of the method for counting the material readiness, the embodiment of the present application further provides a device for counting the material readiness, as shown in fig. 3, the device 300 for counting the material readiness includes:
the obtaining module 301 is configured to obtain a target statistics table, where the target statistics table includes a plurality of commodity categories, a plurality of commodity brands corresponding to each commodity category, a plurality of bar codes corresponding to each commodity brand, and commodity names corresponding to the plurality of bar codes, and the plurality of bar codes are respectively associated with a plurality of materials;
the processing module 302 is configured to pre-process the target statistics table to obtain a table chart;
counting the number of the materials respectively associated with the plurality of bar codes corresponding to each commodity brand under a preset scene according to the table chart and the plurality of materials respectively associated with the plurality of bar codes;
and the output module 303 is configured to determine an uploading identifier of the barcode according to the number of the materials and a preset number threshold, and determine the material readiness of the corresponding commodity brand according to the uploading identifiers of the plurality of barcodes.
In some embodiments of the present application, the processing module 301 may be specifically configured to:
for the same commodity category, unifying the category names of the commodity categories;
for the same commodity brand, unifying the brand names of the commodity brands;
the plurality of bar codes are deleted or combined according to the commodity channel of each bar code.
In some embodiments of the present application, the processing module 301 may be further specifically configured to:
if each bar code has a corresponding commodity channel, deleting the bar codes, the commodity names and the bar codes with the same commodity channel;
combining bar codes with the same commodity name and different commodity channels;
if each bar code does not have a corresponding commodity channel, the bar codes with the same names as the commodity are deleted.
In some embodiments of the present application, the uploading identifier includes a first identifier and a second identifier, where the first identifier is used to identify that the number of materials associated with the barcode reaches the number threshold, and the second identifier is used to identify that the number of materials associated with the barcode does not reach the number threshold, and the output module 303 may specifically be configured to:
comparing the number of the bar code associated material with a number threshold;
if the number of the materials is greater than or equal to a number threshold, configuring a first identifier for the bar code;
if the number of the materials is smaller than the number threshold, configuring a second mark for the bar code.
In some embodiments of the present application, the output module 303 may be further specifically configured to:
counting the number of bar codes carrying the first mark to obtain the uploading quantity of the corresponding commodity brand materials;
comparing the uploading quantity of the material with a preset brand material checking quantity;
if the uploading quantity of the materials is larger than or equal to the brand material checking quantity, the material preparation degree is not smaller than 1;
if the uploading amount of the material is smaller than the brand material checking amount, the material preparation degree is smaller than 1.
Specifically, the specific process of implementing the functions of each module in the apparatus of the embodiment of the present application may refer to the description of the statistical method of the material readiness in any embodiment corresponding to fig. 1 to 2, and detailed description thereof is omitted herein.
The embodiment of the application also provides a statistical electronic device of the material preparation degree, which integrates any statistical device of the material preparation degree provided by the embodiment of the application, and the electronic device comprises:
one or more processors;
a memory; and
one or more applications, wherein the one or more applications are stored in the memory and configured to be executed by the processor to perform the steps in the statistical method of material readiness in any of the statistical method embodiments of material readiness described above.
The statistical electronic equipment for the material preparation degree integrates any statistical device for the material preparation degree provided by the embodiment of the application. As shown in fig. 4, a schematic structural diagram of an electronic device according to an embodiment of the present application is shown, specifically:
the electronic device may include one or more processing cores 'processors 401, one or more computer-readable storage media's memory 402, power supply 403, and input unit 404, among other components. Those skilled in the art will appreciate that the electronic device structure shown in fig. 4 is not limiting of the electronic device and may include more or fewer components than shown, or may combine certain components, or may be arranged in different components. Wherein:
the processor 401 is a control center of the electronic device, connects various parts of the entire electronic device using various interfaces and lines, and performs various functions of the electronic device and processes data by running or executing software programs and/or modules stored in the memory 402, and calling data stored in the memory 402, thereby performing overall monitoring of the electronic device. Optionally, processor 401 may include one or more processing cores; the processor 401 may be a central processing unit (Central Processing Unit, CPU), but may also be other general purpose processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), off-the-shelf programmable gate arrays (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like, and preferably, the processor 401 may integrate an application processor, which primarily handles operating systems, user interfaces, application programs, and the like, with a modem processor, which primarily handles wireless communications. It will be appreciated that the modem processor described above may not be integrated into the processor 401.
The memory 402 may be used to store software programs and modules, and the processor 401 executes various functional applications and data processing by executing the software programs and modules stored in the memory 402. The memory 402 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program (such as a sound playing function, an image playing function, etc.) required for at least one function, and the like; the storage data area may store data created according to the use of the server, etc. In addition, memory 402 may include high-speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid-state storage device. Accordingly, the memory 402 may also include a memory controller to provide the processor 401 with access to the memory 402.
The electronic device further comprises a power supply 403 for supplying power to the various components, preferably the power supply 403 may be logically connected to the processor 401 by a power management system, so that functions of managing charging, discharging, and power consumption are achieved by the power management system. The power supply 403 may also include one or more of any of a direct current or alternating current power supply, a recharging system, a power failure detection circuit, a power converter or inverter, a power status indicator, and the like.
The electronic device may further comprise an input unit 404, which input unit 404 may be used for receiving input digital or character information and generating keyboard, mouse, joystick, optical or trackball signal inputs in connection with user settings and function control.
Although not shown, the server may further include a display unit or the like, which is not described herein. In particular, in this embodiment, the processor 401 in the electronic device loads executable files corresponding to the processes of one or more application programs into the memory 402 according to the following instructions, and the processor 401 executes the application programs stored in the memory 402, so as to implement various functions as follows:
obtaining a target statistical table, wherein the target statistical table comprises a plurality of commodity categories, a plurality of commodity brands corresponding to each commodity category, a plurality of bar codes corresponding to each commodity brand respectively and commodity names corresponding to the plurality of bar codes respectively, and the plurality of bar codes are respectively associated with a plurality of materials;
preprocessing a target statistical table to obtain a table chart;
counting the number of the materials respectively associated with the plurality of bar codes corresponding to each commodity brand under a preset scene according to the table chart and the plurality of materials respectively associated with the plurality of bar codes;
and determining uploading identifiers of the bar codes according to the number of the materials and a preset number threshold value, and determining the material readiness of the corresponding commodity brands according to the uploading identifiers of the bar codes.
It will be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the statistical device for material readiness, the electronic device and the corresponding units of the above-described statistical device for material readiness may refer to the description of the statistical method for material readiness in any embodiment, such as fig. 1 to 2, and detailed descriptions thereof are omitted herein.
Those of ordinary skill in the art will appreciate that all or a portion of the steps of the various methods of the above embodiments may be performed by instructions, or by instructions controlling associated hardware, which may be stored in a computer-readable storage medium and loaded and executed by the processor 401.
To this end, an embodiment of the present application provides a computer-readable storage medium, which may include: read Only Memory (ROM), random access Memory (Random Access Memory, RAM), magnetic or optical disk, and the like. The method comprises the steps of storing a computer program, wherein the computer program is loaded by a processor to execute any of the statistical methods of material readiness provided by the embodiment of the application. For example, the loading of the computer program by the processor may perform the steps of:
obtaining a target statistical table, wherein the target statistical table comprises a plurality of commodity categories, a plurality of commodity brands corresponding to each commodity category, a plurality of bar codes corresponding to each commodity brand respectively and commodity names corresponding to the plurality of bar codes respectively, and the plurality of bar codes are respectively associated with a plurality of materials;
preprocessing a target statistical table to obtain a table chart;
counting the number of the materials respectively associated with the plurality of bar codes corresponding to each commodity brand under a preset scene according to the table chart and the plurality of materials respectively associated with the plurality of bar codes;
and determining uploading identifiers of the bar codes according to the number of the materials and a preset number threshold value, and determining the material readiness of the corresponding commodity brands according to the uploading identifiers of the bar codes.
The above is only a preferred embodiment of the present application, and is not intended to limit the present application, but various modifications and variations can be made to the present application by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the protection scope of the present application.
Claims (7)
1. A statistical method for material readiness, comprising:
obtaining a target statistical table, wherein the target statistical table comprises a plurality of commodity categories, a plurality of commodity brands corresponding to each commodity category, a plurality of bar codes corresponding to each commodity brand respectively and commodity names corresponding to the bar codes respectively, and the bar codes are respectively associated with a plurality of materials;
preprocessing the target statistical table to obtain a table chart;
counting the number of the materials respectively associated with the bar codes corresponding to each commodity brand under a preset scene according to the table chart and the materials respectively associated with the bar codes;
determining uploading identifiers of the bar codes according to the number of the materials and a preset number threshold value, and determining the corresponding material readiness of the commodity brands according to the uploading identifiers of the bar codes;
the uploading identification comprises a first identification and a second identification, wherein the first identification is used for identifying that the quantity of the materials related to the bar code reaches the quantity threshold, the second identification is used for identifying that the quantity of the materials related to the bar code does not reach the quantity threshold, and the determining the uploading identification of the bar code according to the quantity of the materials and a preset quantity threshold comprises the following steps:
comparing the number of the material associated with the bar code to the number threshold;
if the number of the materials is greater than or equal to the number threshold, configuring a first mark for the bar code;
if the number of the materials is smaller than the number threshold, configuring a second mark for the bar code;
the determining the material readiness of the corresponding commodity brand according to the uploading identifiers of the bar codes comprises the following steps:
counting the number of the bar codes carrying the first mark to obtain the corresponding uploading quantity of the material of the commodity brand;
comparing the uploading quantity of the material with a preset brand material checking quantity;
if the uploading quantity of the materials is larger than or equal to the brand material checking quantity, the material readiness is not smaller than 1;
and if the material uploading quantity is smaller than the brand material checking quantity, the material readiness is smaller than 1.
2. The method of claim 1, wherein preprocessing the target statistics table to obtain a table chart comprises:
for the same commodity category, unifying the category names of the commodity categories;
unifying brand names of the commodity brands for the same commodity brand;
and deleting or combining a plurality of bar codes according to commodity channels of each bar code.
3. The method of claim 2, wherein said deleting or merging a plurality of said barcodes according to each said barcode's commodity channel comprises:
if each bar code has the corresponding commodity channel, deleting the bar code, the commodity name and the bar code with the same commodity channel;
combining the bar codes with the same names of the commodities and different commodity channels;
and if each bar code does not have the corresponding commodity channel, deleting the bar codes with the same names as the commodity.
4. A method according to claim 3, wherein after combining a plurality of said bar codes, each of said bar codes after combining is separated according to a predetermined separator.
5. A statistical apparatus for material readiness, comprising:
the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring a target statistical table, wherein the target statistical table comprises a plurality of commodity categories, a plurality of commodity brands corresponding to each commodity category, a plurality of bar codes corresponding to each commodity brand respectively and commodity names corresponding to the bar codes respectively, and the bar codes are respectively associated with a plurality of materials;
the processing module is used for preprocessing the target statistical table to obtain a table chart;
counting the number of the materials respectively associated with the bar codes corresponding to each commodity brand under a preset scene according to the table chart and the materials respectively associated with the bar codes;
the output module is used for determining uploading identifiers of the bar codes according to the number of the materials and a preset number threshold value, and determining the corresponding material readiness of the commodity brands according to the uploading identifiers of the bar codes;
the uploading identifier comprises a first identifier and a second identifier, wherein the first identifier is used for identifying that the number of the materials associated with the bar code reaches the number threshold, the second identifier is used for identifying that the number of the materials associated with the bar code does not reach the number threshold, and the output module is used for:
comparing the number of the material associated with the bar code to the number threshold;
if the number of the materials is greater than or equal to the number threshold, configuring a first mark for the bar code;
if the number of the materials is smaller than the number threshold, configuring a second mark for the bar code;
the output module is further configured to:
counting the number of bar codes carrying the first mark to obtain the uploading quantity of the corresponding commodity brand materials;
comparing the uploading quantity of the material with a preset brand material checking quantity;
if the uploading quantity of the materials is larger than or equal to the brand material checking quantity, the material preparation degree is not smaller than 1;
if the uploading amount of the material is smaller than the brand material checking amount, the material preparation degree is smaller than 1.
6. A statistical electronic device for material readiness, comprising:
one or more processors;
a memory; and
one or more applications, wherein the one or more applications are stored in the memory and configured to be executed by the processor to implement the statistical method of material readiness of any one of claims 1-4.
7. A computer readable storage medium, having stored thereon a computer program, the computer program being loaded by a processor to perform the steps of the statistical method of material readiness according to any one of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011574075.2A CN112581014B (en) | 2020-12-25 | 2020-12-25 | Statistical method, device, equipment and storage medium for material readiness |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011574075.2A CN112581014B (en) | 2020-12-25 | 2020-12-25 | Statistical method, device, equipment and storage medium for material readiness |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112581014A CN112581014A (en) | 2021-03-30 |
| CN112581014B true CN112581014B (en) | 2023-12-08 |
Family
ID=75140349
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011574075.2A Active CN112581014B (en) | 2020-12-25 | 2020-12-25 | Statistical method, device, equipment and storage medium for material readiness |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112581014B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113837641A (en) * | 2021-09-30 | 2021-12-24 | 商派软件有限公司 | Commodity material management method, server, and computer-readable medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2909957A1 (en) * | 2014-10-22 | 2016-04-22 | Staples, Inc. | Large-scale customer-product relationship mapping and contact scheduling |
| CN108416403A (en) * | 2018-03-08 | 2018-08-17 | 上海扩博智能技术有限公司 | The automatic correlation method of commodity and label, system, equipment and storage medium |
| CN109710663A (en) * | 2018-12-29 | 2019-05-03 | 北京神舟航天软件技术有限公司 | A kind of data statistics chart generation method |
| CN110110982A (en) * | 2019-04-26 | 2019-08-09 | 特赞（上海）信息科技有限公司 | The checking method and device of intention material |
| CN111861208A (en) * | 2020-07-20 | 2020-10-30 | 精效新软新技术（北京）有限公司 | Method, system and medium for automatically calculating MRP material demand in production management |
| CN111931774A (en) * | 2020-09-27 | 2020-11-13 | 耀方信息技术(上海)有限公司 | Method and system for warehousing medicine data |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7991639B2 (en) * | 2006-12-22 | 2011-08-02 | International Business Machines Corporation | Determining readiness of an organization to utilize an information technology asset |
| US8898121B2 (en) * | 2012-05-29 | 2014-11-25 | International Business Machines Corporation | Merging entries in a deduplication index |
| US10789601B2 (en) * | 2014-11-19 | 2020-09-29 | TESI S.p.A. | System and method for guaranteeing authenticity of branded goods |
-
2020
- 2020-12-25 CN CN202011574075.2A patent/CN112581014B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2909957A1 (en) * | 2014-10-22 | 2016-04-22 | Staples, Inc. | Large-scale customer-product relationship mapping and contact scheduling |
| CN108416403A (en) * | 2018-03-08 | 2018-08-17 | 上海扩博智能技术有限公司 | The automatic correlation method of commodity and label, system, equipment and storage medium |
| CN109710663A (en) * | 2018-12-29 | 2019-05-03 | 北京神舟航天软件技术有限公司 | A kind of data statistics chart generation method |
| CN110110982A (en) * | 2019-04-26 | 2019-08-09 | 特赞（上海）信息科技有限公司 | The checking method and device of intention material |
| CN111861208A (en) * | 2020-07-20 | 2020-10-30 | 精效新软新技术（北京）有限公司 | Method, system and medium for automatically calculating MRP material demand in production management |
| CN111931774A (en) * | 2020-09-27 | 2020-11-13 | 耀方信息技术(上海)有限公司 | Method and system for warehousing medicine data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112581014A (en) | 2021-03-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP3550485A1 (en) | Ex-warehousing method and device | |
| US10872312B2 (en) | Customer order picking by delivery container | |
| CN107291745B (en) | Data index management method and device | |
| US20150363732A1 (en) | Device for assisting determination of supply group and program for assisting determination of supply group | |
| CN112581014B (en) | Statistical method, device, equipment and storage medium for material readiness | |
| CN112699008A (en) | Method and engine for automatically processing alarm by matching multi-dimensional rules | |
| CN111414410A (en) | Data processing method, device, equipment and storage medium | |
| KR101550587B1 (en) | Server and method for managing quality of wastepaper for recycling | |
| CN115641061A (en) | Material management method and device | |
| CN113177766B (en) | Method and device for storing materials and terminal equipment | |
| KR101974104B1 (en) | Method of providing logistics information using application integration system | |
| CN111026705B (en) | Building engineering file management method, system and terminal equipment | |
| CN115496567A (en) | Delivery filing method, device, equipment and storage medium | |
| CN114386902A (en) | Book supply method and device, electronic equipment and storage medium | |
| CN116569118A (en) | Information management method and device | |
| CN114650167A (en) | Abnormity detection method, device, equipment and computer readable storage medium | |
| CN113457990A (en) | Goods sorting method, device, electronic equipment and medium | |
| CN111709678A (en) | Commodity distribution method and device for express cabinet and terminal equipment | |
| CN111143377A (en) | Automatic driving simulation data collection method, device and system | |
| CN117194484A (en) | Data management method and system for homeland planning map | |
| CN116341581B (en) | Integrated management method and system for Internet of things code scanning equipment | |
| CN115936573A (en) | Method and device for warehousing selected products, storage medium and computer equipment | |
| CN112950120A (en) | Management system of intelligent intermediate cabinet | |
| CN113609069A (en) | Document management method, system, terminal device and storage medium | |
| CN113537874A (en) | Storage management method, system, terminal equipment and computer storage medium |
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 |