Tower detailed statement generation method and device and computer program product

Abstract

The invention discloses a tower detailed statement generation method and device and a computer program product, a tower detailed statement template is formed through a protocol placeholder configured in a user-defined mode, and a tower detailed statement is generated based on the tower detailed statement template, so that when data except the protocol placeholder need to be counted, the data except for the protocol placeholder needs to be counted, and the data except for the protocol placeholder needs to be counted. Only the newly added field needs to be supplemented into the protocol placeholder and is associated with the data field; then, corresponding placeholders are added into the tower detailed list template file, and statistics and filling of newly-added data can be achieved; on the basis, the newly-added fields do not need to be matched by modifying codes, so that the workload of personnel can be reduced; meanwhile, a user can configure the protocol placeholders by himself, so that the protocol placeholders can be assembled by himself according to a use scene, and different tower detailed statement templates can be formed; therefore, the method can adapt to different use scenes, so that the use flexibility is greatly improved; therefore, the method is very suitable for large-scale application and popularization.

Description

Technical Field

[0001] The invention belongs to the technical field of data processing, and in particular relates to a method and device for generating a tower list and a computer program product. Background Art

[0002] As a highly refined and concentrated form of information expression, tables are widely used in various industries, especially in the field of distribution networks. There are a large number of poles and towers in the distribution network. How to quickly organize the pole and tower information on each line into a pole and tower list plays an important role in helping staff to conduct information statistics.

[0003] At present, the technology of automatically generating Excel files without template codes is mostly used to generate pole tower detail tables to improve the generation efficiency of pole tower detail tables. Among them, the aforementioned technology of automatically generating Excel files without template codes refers to creating cells in each row and column of the statistical table through codes, and filling in statistical data; however, the aforementioned method has the following shortcomings: when it comes to changes in statistical fields, statistical fields can only be added or reduced by modifying the code, which not only increases the workload, but also cannot adapt to the usage needs of multiple users in multiple scenarios, and is extremely inflexible to use; based on this, how to provide a method for generating pole tower detail tables with low workload and flexible use has become a problem to be solved urgently. Summary of the invention

[0004] The purpose of the present invention is to provide a method, device and computer program product for generating a tower list, so as to solve the problems of heavy workload and extremely inflexible use in the prior art.

[0005] In order to achieve the above object, the present invention adopts the following technical solutions: In a first aspect, a method for generating a tower list is provided, comprising: Acquire a pole tower list template, wherein the pole tower list template includes a template page, each cell in the template page is filled with a first protocol placeholder for cell filling, and the first protocol placeholder includes a protocol field; For any cell in the template page, extract the corresponding protocol field from the first protocol placeholder in the any cell, and determine the tower field information corresponding to the protocol field in the first protocol placeholder in the any cell from the tower information database based on the extracted protocol field; Generate filling information corresponding to any cell according to the determined tower field information; The filling information corresponding to any cell is filled into the any cell, and after filling, the filling information of the next cell of the any cell is determined, until all cells in the template page are polled, and the tower detail list is obtained.

[0006] Based on the above disclosed content, the present invention pre-sets a pole tower list template, wherein the pole tower list template includes a template page, each cell in the template page is filled with a first protocol placeholder for cell filling, and the first protocol placeholder includes a protocol field; in this way, the present invention is equivalent to configuring different first protocol placeholders to fill different cells; based on this, in actual use, it is only necessary to extract the protocol field in the corresponding first protocol placeholder from any cell; then, based on the extracted protocol field, match the pole tower field information corresponding to the aforementioned protocol field in the pole tower information database; then, generate the filling information of any cell according to the matched pole tower field information; then, fill the generated filling information into any of the aforementioned cells, and then complete the filling of any of the cells; finally, according to the aforementioned principle, fill the next cell, until all cells are filled, and then a pole tower list can be obtained.

[0007] Through the above design, the present invention forms a pole tower list template through a custom-configured protocol placeholder, and generates a pole tower list based on this. In this way, when there is data other than the protocol placeholder that needs to be counted, it is only necessary to add the newly added field to the protocol placeholder and associate it with the data field; then, the corresponding placeholder is added to the pole tower list template file to realize the statistics and filling of the newly added data; based on this, there is no need to modify the code to match the newly added field, thereby reducing the workload of personnel; at the same time, users can configure the protocol placeholder by themselves, so they can assemble it by themselves according to the usage scenario, so as to form different pole tower list templates; in this way, it can adapt to different usage scenarios, thereby greatly improving the flexibility of use; therefore, the present invention is very suitable for large-scale application and promotion.

[0008] In one possible design, the first protocol placeholder includes a data replacement placeholder, an operation placeholder, or a position placeholder, wherein when the first protocol placeholder is a data replacement placeholder, the protocol field is a replacement field, and when the first protocol placeholder is an operation placeholder, the protocol field is an operation field; The extracting of the corresponding protocol field from the first protocol placeholder in any cell, and determining the tower field information corresponding to the protocol field in the first protocol placeholder in any cell from the tower information database based on the extracted protocol field, includes: Determine whether the first protocol placeholder in any cell is a data replacement placeholder; If yes, remove the placeholder identifier in the data replacement placeholder to obtain a replacement field in the data replacement placeholder; Based on the replacement field, filtering out the tower field information corresponding to the replacement field from the tower information database; Correspondingly, generating filling information corresponding to any cell according to the determined tower field information includes: The tower field information corresponding to the replacement field is used as the filling information corresponding to any cell.

[0009] In one possible design, determining whether the first protocol placeholder in any cell is a data replacement placeholder includes: If not, determining whether the first protocol placeholder in any cell is an operation placeholder; If yes, then read the operation placeholder in any cell in the form of a character string, and determine the protocol operator in the read operation placeholder; Extracting the character strings before and after the protocol operator from the read operation placeholder to obtain the operation field after extraction; Based on the operation field, filtering out the pole tower field information corresponding to the operation field from the pole tower information database; Correspondingly, generating filling information corresponding to any cell according to the determined tower field information includes: Based on the protocol operator, the pole tower field information corresponding to the operation field is processed to obtain the filling information of any cell after the operation, wherein the protocol operator is a concatenation operator, an addition operator, a multiplication operator, a division operator or a subtraction operator.

[0010] In one possible design, determining whether the first protocol placeholder in any cell is an operation placeholder includes: If not, jump to the next row of the row where any cell is located, and determine whether the first protocol placeholder in the first cell in the next row is a data replacement placeholder, until all cells in the template page are polled.

[0011] In a possible design, the template page further includes a page name, wherein before extracting the corresponding protocol field from the first protocol placeholder in any cell, the method further includes: According to the page name of the template page, the total number of towers to be filled is determined from the tower information database, and based on the total number of towers to be filled, the required number of template pages is determined; Determine whether the required number of template pages is greater than the total number of template pages in the tower list template; If yes, copy the template page in the tower list template to obtain n template pages, where n is the required number of template pages; For any template page among the n template pages, determining fill information of any cell in any template page according to the tower information database and the protocol field in the first protocol placeholder in any cell in any template page; Based on the filling information of any cell in any template page, any cell in any template page is filled, and after filling, the filling information of the next cell of any cell in any template page is determined, until all cells in any template page are polled, the tower detail page corresponding to the template page is obtained, and when all template pages are polled, the tower detail list of the tower to be filled is obtained.

[0012] In a possible design, the page name includes a second protocol placeholder, the second protocol placeholder includes a conditional filter, and the first protocol placeholder includes a placeholder for representing the end of a line; According to the page name of the template page, the total number of towers to be filled is determined from the tower information database, including: Extracting a second protocol placeholder from the page name, and extracting a conditional screening field from the second protocol placeholder; Determining a tower name field corresponding to the conditional screening field from the tower information database; Counting the total number of pole tower name fields corresponding to the conditional screening fields as the total number of pole towers to be filled; Accordingly, based on the total number of towers to be filled, the required number of template pages is determined, which includes: Counting the total number of placeholders in the template page; Determining the number of fillable rows in the template page based on the total number of placeholders; The required number of template pages is calculated based on the total number of the towers to be filled and the number of rows that can be filled.

[0013] In one possible design, copy the template pages in the Tower Schedule template to include: Determine the end row number and the end column number from the template page, and obtain the copy row number and the copy column number based on the end row number and the end column number; The template page is copied according to the number of copied rows, the number of copied columns and the required number of template pages to obtain n template pages.

[0014] In a second aspect, a device for generating a tower list is provided, comprising: An acquisition unit is used to acquire a pole tower list template, wherein the pole tower list template includes a template page, each cell in the template page is filled with a first protocol placeholder for cell filling, and the first protocol placeholder includes a protocol field; An information matching unit, configured to extract, for any cell in the template page, a corresponding protocol field from a first protocol placeholder in the any cell, and determine, based on the extracted protocol field, from a tower information database, tower field information corresponding to the protocol field in the first protocol placeholder in the any cell; A filling information generating unit, used for generating filling information corresponding to any cell according to the determined tower field information; The table filling unit is used to fill the filling information corresponding to any cell into the any cell, and after filling, determine the filling information of the next cell of the any cell, until all cells in the template page are polled to obtain the tower detail list.

[0015] In a third aspect, another device for generating a pole tower list is provided. Taking the device as an electronic device as an example, the device includes a memory, a processor and a transceiver which are communicatively connected in sequence, wherein the memory is used to store a computer program, the transceiver is used to send and receive messages, and the processor is used to read the computer program to execute the method for generating the pole tower list as in the first aspect or any possible design in the first aspect.

[0016] In a fourth aspect, a storage medium is provided, on which instructions are stored, and when the instructions are executed on a computer, a method for generating a tower list as in the first aspect or any possible design in the first aspect is executed.

[0017] In a fifth aspect, a computer program product comprising instructions is provided, which, when executed on a computer, causes the computer to execute a method for generating a tower list as in the first aspect or any possible design of the first aspect.

[0018] Beneficial effects: (1) The present invention forms a pole tower list template through a custom configured protocol placeholder, and generates a pole tower list based on this. In this way, when there is data other than the protocol placeholder that needs to be counted, it is only necessary to add the new field to the protocol placeholder and associate it with the data field; then, the corresponding placeholder is added to the pole tower list template file to realize the statistics and filling of the new data; based on this, there is no need to modify the code to match the new field, thereby reducing the workload of personnel; at the same time, the user can configure the protocol placeholder by himself, so that he can assemble it according to the usage scenario, so as to form different pole tower list templates; in this way, it can adapt to different usage scenarios, thereby greatly improving the flexibility of use; therefore, the present invention is very suitable for large-scale application and promotion. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] Figure 1 A schematic flow chart of the steps of a method for generating a tower list provided in an embodiment of the present invention; Figure 2 A schematic diagram of the structure of a device for generating a tower list according to an embodiment of the present invention; Figure 3 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0020] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the present invention will be briefly introduced below in combination with the drawings and the description of the embodiments or the prior art. Obviously, the following description of the structure of the drawings is only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work. It should be noted that the description of these embodiments is used to help understand the present invention, but does not constitute a limitation of the present invention.

[0021] It should be understood that although the terms first, second, etc. may be used herein to describe various units, these units should not be limited by these terms. These terms are only used to distinguish one unit from another unit. For example, a first unit can be referred to as a second unit, and similarly, a second unit can be referred to as a first unit without departing from the scope of the exemplary embodiments of the present invention.

[0022] It should be understood that the term "and / or" that may appear in this article is merely a description of the association relationship between associated objects, indicating that three relationships may exist. For example, A and / or B can represent three situations: A exists alone, B exists alone, and A and B exist at the same time. The term " / and" that may appear in this article describes another type of association object relationship, indicating that two relationships may exist. For example, A / and B can represent two situations: A exists alone, and A and B exist alone. In addition, the character " / " that may appear in this article generally indicates that the previous and next associated objects are in an "or" relationship.

[0023] Example: See also Figure 1 As shown, the method for generating a pole tower list provided in this embodiment is customized to configure different protocol placeholders, and then fill different protocol placeholders in each cell to form a pole tower list template; in this way, in actual use, data matching can be performed in the pole tower information database according to the protocol field in the protocol placeholder in any cell in the pole tower list template, so as to obtain the filling information of any cell; then, the filling information is filled into any of the aforementioned cells, and the filling of the pole tower information in any cell can be completed; finally, the next cell is filled according to the aforementioned principle, until all cells are filled, and the pole tower list can be obtained; thus, through the aforementioned design, when there is data other than the protocol placeholder that needs to be unified Timing, only the new fields need to be added to the protocol placeholders and associated with the data fields; then, the corresponding placeholders are added to the pole tower list template file to realize the statistics and filling of the new data; based on this, there is no need to modify the code to match the new fields, thereby reducing the workload of personnel; at the same time, users can configure the protocol placeholders by themselves, so they can assemble them according to the usage scenarios, so as to form different pole tower list templates; in this way, it can adapt to different usage scenarios, thereby greatly improving the flexibility of use; therefore, this method is very suitable for large-scale application and promotion; among them, for example, this method can be but not limited to running on the distribution network operation end side, optionally, the distribution network operation end can be but not limited to a personal computer (personal computer, PC), it can be understood that the aforementioned execution subject does not constitute a limitation on the embodiments of the present application, and accordingly, the operation steps of this method can be but not limited to the following steps S1 to S4.

[0024] S1. Obtain a pole tower detail list template, wherein the pole tower detail list template includes a template page, each cell in the template page is filled with a first protocol placeholder for cell filling, and the first protocol placeholder includes a protocol field; in this embodiment, the first protocol placeholder is pre-configured by the user, and different first protocol placeholders can be configured according to actual scenarios; after the configuration is completed, different first protocol placeholders can be filled in each cell in the blank template; then, different headers are set, and after the setting is completed, the pole tower detail list template can be obtained.

[0025] Optionally, the first protocol placeholder in any cell of the example in this embodiment may be, but is not limited to, a data replacement placeholder, an operation placeholder or a position placeholder, and when the first protocol placeholder is a data replacement placeholder, the protocol field is a replacement field, and when the first protocol placeholder is an operation placeholder, the protocol field is an operation field; and the position placeholder is used to ensure that any cell is at the end of the row for position identification.

[0026] Furthermore, the example data replacement placeholder can be expressed as but not limited to: $$+replacement field+$$, where $$ is a placeholder identifier symbol, and the operation placeholder can be expressed as but not limited to operation field+protocol operator+operation field, and the protocol operator is a concatenation operator (expressed as "&"), an addition operator (+), a multiplication operator (×), a division operator ( / ) or a subtraction operator (-); similarly, the position occupant is expressed as: $$end$$; of course, the protocol placeholder is not limited to the aforementioned examples, and can be specifically set according to actual use, which will not be described one by one here.

[0027] After obtaining the tower list template, the cells can be filled based on the first protocol placeholders in each cell of the template. The process can be but not limited to the following steps S2 to S4.

[0028] S2. For any cell in the template page, extract the corresponding protocol field from the first protocol placeholder in any cell, and based on the extracted protocol field, determine the tower field information corresponding to the protocol field in the first protocol placeholder in any cell from the tower information database; in specific applications, the tower information database contains relevant information of all towers that need to be counted this time, which may include but is not limited to a number of tower data strips, each of which contains: tower name (such as 10kV tower 1, 10kV tower 2, etc.), tower number, span, conductor status, tower model, Pole height, buried depth of pole, cement products (including ordinary concrete poles, chassis, chucks and wire drums), insulators (including column insulators, suspension insulators, wire insulators, etc.), line iron accessories (including double-circuit upper crossarms, double-circuit lower crossarms, double-circuit tension upper crossarms, double-circuit tension lower crossarms and chuck clamps), standard hardware (including straight hanging plates, ball head hanging rings, single-joint bowl heads, tension wire clamps, parallel groove wire clamps), wire pulling iron parts, steel strands, wire pulling hardware and other information (including identification plates, wire protection tubes and grounding hanging rings); of course, the information in the pole tower information database can be specifically set according to actual use, and is not limited to the aforementioned examples.

[0029] In this embodiment, as has been explained above, there are multiple types of first protocol placeholders. Therefore, it is necessary to take corresponding operation steps to determine the aforementioned tower field information according to the type of the first protocol placeholder in any cell; wherein, the matching process of the aforementioned tower field information may be but is not limited to as shown in the following steps S21 to S23.

[0030] S21. Determine whether the first protocol placeholder in any cell is a data replacement placeholder; in a specific application, if the first protocol placeholder in any cell is a data replacement placeholder, it is necessary to enter the following step S22; otherwise, it is necessary to determine the operation placeholder, and the process is described in detail below.

[0031] S22. If so, remove the placeholder identifier symbol in the data replacement placeholder to obtain the replacement field in the data replacement placeholder; in specific applications, the placeholder identifier symbol is $$; therefore, after removing the placeholder identifier symbol in the data replacement placeholder, the replacement field in the data replacement placeholder can be obtained; then, the corresponding information can be matched from the tower information database based on the replacement field, and the process can be but is not limited to the following step S23.

[0032] S23. Based on the replacement field, the tower field information corresponding to the replacement field is filtered out from the tower information database; in this embodiment, an example is used to illustrate, assuming that the replacement field is the tower pole number, then the information corresponding to the tower pole number is filtered out from the tower information database as the tower field information; of course, if the tower field information corresponding to the aforementioned replacement field is not matched in the tower information database, then it means that the fill information of any cell does not exist in the database, and at this time, any cell can be assigned a null value; in addition, when the replacement field is other information, the matching principle is the same as the aforementioned example, which will not be repeated here.

[0033] At the same time, in this embodiment, if in the aforementioned step S21, it is determined that the first protocol placeholder in any cell is not a data replacement placeholder, then it is necessary to judge the operation placeholder so as to extract the operation field according to the judgment result, and then match the tower information in the tower information database based on the operation field; wherein the aforementioned process can be but is not limited to as shown in the following steps S24 to S27.

[0034] S24. If not, determine whether the first protocol placeholder in any cell is an operation placeholder; in this embodiment, when it is determined that the first protocol placeholder in any cell is an operation placeholder, it is necessary to extract the operation field, and the process may be but is not limited to the following steps S25 and S26.

[0035] S25. If so, read the operation placeholder in any of the cells in the form of a string, and determine the protocol operator in the read operation placeholder; in specific implementation, for example, but not limited to, use the Contains method of the string in C# to determine whether there is a protocol operator in the aforementioned operation placeholder, thereby determining the protocol operator in the operation placeholder; wherein, the C#Contains() method is used to return a value indicating whether the specified substring appears in this string; if so, return true, otherwise, return false.

[0036] After the protocol operator in the operation placeholder is determined, the operation field in the operation placeholder can be extracted based on the protocol operator. The process can be but is not limited to the process shown in the following step S26.

[0037] S26. Extract the character strings before and after the protocol operator from the read operation placeholder to obtain the operation field after the extraction; in the specific implementation, for example, but not limited to, the Split method of the string in C# is used to intercept the character strings at both ends of the operation protocol symbol, thereby serving as the corresponding operation field; wherein, the split method is a method for splitting a character string into multiple substrings according to a specified delimiter, which is a commonly used method for character segmentation, and therefore, in this embodiment, its principle is not repeated.

[0038] After the operation field is obtained, information matching can be performed based on the operation field, and the process can be but is not limited to the process shown in the following step S27.

[0039] S27. Based on the operation field, the tower field information corresponding to the operation field is screened out from the tower information database; in this embodiment, the matching process of the operation field corresponding to the tower field information is the same as the aforementioned replacement field, which will not be repeated here.

[0040] Thus, based on the aforementioned steps S21 to S27, after obtaining the tower field information corresponding to the protocol field in the first protocol placeholder in any cell, the filling information corresponding to the any cell can be generated based on this, and the process can be but not limited to as shown in the following step S3.

[0041] S3. Generate fill information corresponding to any cell according to the determined tower field information; in this embodiment, when the first protocol placeholder in any cell is a data replacement placeholder, the tower field information corresponding to the replacement field can be directly used as the fill information corresponding to any cell; similarly, when the first protocol placeholder in any cell is an operation placeholder, the tower field information corresponding to the operation field is operated based on the protocol operator, so that after the operation, the fill information of any cell is obtained.

[0042] After the filling information corresponding to any cell is obtained, the filling process of any cell can be performed, and the process can be but not limited to the process shown in the following step S4.

[0043] S4. Fill the filling information corresponding to any cell into the any cell, and after filling, determine the filling information of the next cell of the any cell, until all cells in the template page are polled, and obtain the pole tower list; in this embodiment, fill the filling information of any cell into the any cell, then the filling of the pole tower information of the any cell can be completed; then, the same principle is used to fill the next cell, and the traversal is continued until all cells are traversed, and the pole tower list can be obtained.

[0044] In addition, in this embodiment, if in the aforementioned step S24, it is determined that the first protocol placeholder in any cell is not an operation placeholder; at this time, it is explained that the first protocol placeholder in any cell is a position placeholder, indicating that any cell is the last cell in the row in which it is located, and is a cell with a position identifier; at this time, it is possible to jump to the next row of the row in which any cell is located, and determine whether the first protocol placeholder in the first cell in the next row is a data replacement placeholder, and then re-execute the aforementioned steps S21 to S27 and S3 to obtain the fill information of the first cell in the aforementioned next row; in this way, the cells are continuously traversed according to this principle until all cells in the template page are polled, and then the tower detail list can be obtained.

[0045] Thus, through the method for generating the pole tower list described in detail in the aforementioned steps S1 to S4, the present invention forms a pole tower list template through a custom configured protocol placeholder, and generates a pole tower list based on this. In this way, when there is data other than the protocol placeholder that needs to be counted, it is only necessary to add the newly added field to the protocol placeholder and associate it with the data field; then, by adding the corresponding placeholder in the pole tower list template file, the statistics and filling of the newly added data can be realized; based on this, there is no need to modify the code to match the newly added field, thereby reducing the workload of personnel; at the same time, the user can configure the protocol placeholder by himself, so that he can assemble it by himself according to the usage scenario, so as to form different pole tower list templates; in this way, it can adapt to different usage scenarios, thereby greatly improving the flexibility of use; therefore, the present invention is very suitable for large-scale application and promotion.

[0046] In a possible design, the second aspect of this embodiment is further optimized on the basis of the first aspect of the embodiment, that is, before filling the cell, it is necessary to determine whether the number of template pages is sufficient to fill the tower data this time; wherein, in this embodiment, the template page also includes a page name, and the second aspect of this embodiment starts running before extracting the corresponding protocol field from the first protocol placeholder in any cell, and its running steps may be but are not limited to as shown in the following steps S02 to S06.

[0047] S02. According to the page name of the template page, the total number of pole towers to be filled is determined from the pole tower information database, and based on the total number of pole towers to be filled, the required number of template pages is determined; in this embodiment, the page name includes a second protocol placeholder, the second protocol placeholder includes a conditional filter, and the conditional filter can be, but is not limited to, represented as: @@+conditional filter field+@@; in this way, the total number of pole towers to be filled can be determined according to the conditional filter, and the process can be, but is not limited to, as shown in the following steps S021 to S023.

[0048] S021. Extract the second protocol placeholder from the page name, and extract the conditional filtering field from the second protocol placeholder; in this embodiment, the conditional filtering field is the tower name, such as 10kV tower, 0.4kV tower or 220V tower, etc.; of course, the above examples are illustrative, and are not limited to this in actual use.

[0049] After the condition screening field is obtained, the number of pole towers to be filled may be determined, and the process may be, but is not limited to, as shown in the following steps S022 and S023.

[0050] S022. Determine the tower name field corresponding to the conditional screening field from the tower information database; in this embodiment, an example is used to illustrate this step. Assuming that the conditional screening field is a 10kV tower, the tower name field corresponding to the 10kV tower is screened out from the tower information database, that is, the tower names corresponding to the 10kV towers contained in the database are all used as the tower name fields corresponding to the conditional screening field; then, the total number of towers to be filled can be obtained based on the total number of tower name fields determined, and the process can be but is not limited to the following step S023.

[0051] S023. Count the total number of tower name fields corresponding to the conditional screening field as the total number of towers to be filled; in this embodiment, assuming that the total number of tower name fields determined is 100, then the total number of towers to be filled is 100; of course, when the conditional screening field is other fields, the process of determining the total number of towers to be filled is the same as the above example and will not be repeated here.

[0052] After the total number of towers to be filled is calculated through the aforementioned steps S021 to S023, the required number of template pages needs to be determined based on the total number of towers to be filled. The process may be but is not limited to the following steps S024 to S026.

[0053] S024. Count the total number of placeholders in the template page; in this embodiment, start from the first row of the template page, traverse each cell in the first row in turn, count once when the first placeholder appears in a row, then jump to the next row, continue to look for the first placeholder, and count again; in this way, when traversing to the first blank row in the template page; at this time, the total number of placeholders in the template page can be obtained.

[0054] After the total number of placeholders in the template page is obtained, the number of fillable rows in the template page can be obtained based on the total number of placeholders in the template page. The process can be but is not limited to the process shown in the following step S025.

[0055] S025. Determine the number of fillable rows in the template page based on the total number of placeholders. In this embodiment, the total number of placeholders is directly used as the number of fillable rows. Then, the required number of template pages can be calculated based on the total number of towers to be filled. The calculation process can be, but is not limited to, as shown in the following step S026.

[0056] S026. Based on the total number of towers to be filled and the number of rows that can be filled, the required number of template pages is calculated; in this embodiment, the required number of template pages is obtained by dividing the total number of towers to be filled by the number of rows that can be filled.

[0057] After calculating the required number of template pages through the aforementioned steps S021 to S027, it is necessary to determine whether the number of template pages in the tower detail list template is less than the required number of template pages, so as to expand the template pages when it is less than the required number of template pages. The determination process may be, but is not limited to, as shown in the following step S03.

[0058] S03. Determine whether the required number of template pages is greater than the total number of template pages in the tower detail list template; in this embodiment, if the required number of template pages is less than or equal to the total number of template pages, there is no need to copy the template pages, and the aforementioned step S2 can be directly executed at this time; otherwise, the template pages need to be expanded, and the process can be but is not limited to as shown in the following step S04.

[0059] S04. If yes, then copy the template page in the pole tower detail list template to obtain n template pages, where n is the required number of template pages; in this embodiment, for example, it can be but not limited to first determining the end row number and the end column number from the template page, and based on the end row number and the end column number, deriving the copy row number and the copy column number; then, according to the copy row number, the copy column number and the required number of template pages, copy the template page to obtain n template pages.

[0060] Optionally, the process of determining the number of termination rows is: Step 1: For the kth column in the template page, read the information in the cell in the i-th row of the kth column.

[0061] Step 2: Determine whether the information in the cell in the i-th row is empty.

[0062] Step 3: If not, then increment i by 1 until the information in the cells in the i-th row is empty, and determine the ending row number based on the number of rows of cells with empty information, where the initial value of i is 1.

[0063] Similarly, the process of determining the number of termination columns is: Step 4: For the kth column in the template page, read the information in the cells in the first row of the kth column.

[0064] Step 5: Determine whether the information in the cell in the first row of the kth column is empty.

[0065] Step 6: Add 1 to k and reread the information in the cells in the first row of the kth column until the information in the cells in the first row of the kth column is empty, and determine the ending column number based on the column number of the cells in the first row where the information is empty, where the initial value of k is 1.

[0066] In this way, it is equivalent to starting from the first column and traversing the cells of the first column in sequence until traversing to an empty cell and stopping. At this time, it means that the row where the empty cell row is located is an empty row. Therefore, subtract 1 from the number of rows of empty cells to get the terminal row number; similarly, the same is true for the number of columns, then traverse the first cell of each column in sequence until traversing to the column where the first cell is empty, and stop traversing. At this time, the column before the column where the first cell is empty can be used as the terminal column number; then, the terminal row number can be used as the number of copied rows, and the terminal column number can be used as the number of copied columns, and then the template page can be copied according to the required number of template pages, that is: build a table based on the number of copied rows and columns, and then determine the number of copies according to the required number of template pages, so as to obtain n template pages.

[0067] After the template page is copied, the form can be filled in, and the process is shown in the following steps S05 and S06.

[0068] S05. For any template page among the n template pages, determine fill information of any cell in any template page according to the tower information database and the protocol field in the first protocol placeholder in any cell in any template page.

[0069] S06. Based on the filling information of any cell in any template page, fill in any cell in any template page, and after filling, determine the filling information of the next cell of any cell in any template page, until all cells in any template page are polled, and obtain the tower detail page corresponding to the template page, and when all template pages are polled, obtain the tower detail list of the tower to be filled.

[0070] In this embodiment, the table filling process of step S05 and step S06 can refer to the aforementioned steps S2 to S4, and the principles thereof will not be repeated here.

[0071] By following the above steps, the number of template pages can be guaranteed to meet the filling of the corresponding data of the tower to be filled, thereby generating a complete tower list for the tower to be filled; finally, the tower list is output to the specified location to end the tower list generation process.

[0072] like Figure 2 As shown, the third aspect of this embodiment provides a hardware device for implementing the method for generating a tower list described in the first aspect of the embodiment, including: The acquisition unit is used to acquire a pole tower list template, wherein the pole tower list template includes a template page, each cell in the template page is filled with a first protocol placeholder for cell filling, and the first protocol placeholder includes a protocol field.

[0073] An information matching unit is used to extract the corresponding protocol field from the first protocol placeholder in any cell in the template page, and based on the extracted protocol field, determine the tower field information corresponding to the protocol field in the first protocol placeholder in any cell from the tower information database.

[0074] The filling information generating unit is used to generate the filling information corresponding to any cell according to the determined tower field information.

[0075] The table filling unit is used to fill the filling information corresponding to any cell into the any cell, and after filling, determine the filling information of the next cell of the any cell, until all cells in the template page are polled to obtain the tower detail list.

[0076] The working process, working details and technical effects of the device provided in this embodiment can be found in the first and second aspects of the embodiments, and will not be described in detail here.

[0077] like Figure 3As shown, the fourth aspect of this embodiment provides another device for generating a pole tower list, taking the device as an electronic device as an example, comprising: a memory, a processor and a transceiver that are communicatively connected in sequence, wherein the memory is used to store computer programs, the transceiver is used to send and receive messages, and the processor is used to read the computer program to execute the method for generating a pole tower list as described in the first and second aspects of the embodiment.

[0078] For example, the memory may include, but is not limited to, random access memory (RAM), read only memory (ROM), flash memory, first input first output (FIFO) and / or first in last out (FILO), etc. Specifically, the processor may include one or more processing cores, such as a 4-core processor, an 8-core processor, etc. The processor may be implemented in at least one hardware form of DSP (Digital Signal Processing), FPGA (Field-Programmable Gate Array), and PLA (Programmable Logic Array). At the same time, the processor may also include a main processor and a coprocessor. The main processor is a processor for processing data in the awake state, also known as a CPU (Central Processing Unit); the coprocessor is a low-power processor for processing data in the standby state.

[0079] In some embodiments, the processor may be integrated with a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content to be displayed on the display screen. For example, the processor may not be limited to a microprocessor of the STM32F105 series, a reduced instruction set computer (RISC) microprocessor, an X86 architecture processor, or a processor with an integrated embedded neural network processing unit (NPU); the transceiver may be, but is not limited to, a wireless fidelity (WIFI) wireless transceiver, a Bluetooth wireless transceiver, a General Packet Radio Service (GPRS) wireless transceiver, a ZigBee protocol (a low-power LAN protocol based on the IEEE802.15.4 standard, ZigBee) wireless transceiver, a 3G transceiver, a 4G transceiver, and / or a 5G transceiver. In addition, the device may also include, but is not limited to, a power module, a display screen, and other necessary components.

[0080] The working process, working details and technical effects of the electronic device provided in this embodiment can be found in the first and second aspects of the embodiments, and will not be described in detail here.

[0081] The fifth aspect of this embodiment provides a storage medium storing instructions for the method for generating the pole tower list as described in the first and second aspects of the embodiment, that is, the storage medium stores instructions, and when the instructions are run on a computer, the method for generating the pole tower list as described in the first and second aspects of the embodiment is executed.

[0082] The storage medium refers to a carrier for storing data, which may include but is not limited to a floppy disk, a CD, a hard disk, a flash memory, a USB flash drive and / or a memory stick, and the computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices.

[0083] The working process, working details and technical effects of the storage medium provided in this embodiment can be found in the first and second aspects of the embodiments, and will not be described in detail here.

[0084] The sixth aspect of this embodiment provides a computer program product comprising instructions, which, when executed on a computer, causes the computer to execute the method for generating a tower list as described in the first and second aspects of the embodiment, wherein the computer may be a general-purpose computer, a special-purpose computer, a computer network, or other programmable devices.

[0085] Finally, it should be noted that the above description is only a preferred embodiment of the present invention and is not intended to limit the protection scope of the present invention. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A method for generating a tower list, It is characterized in that include: Acquire a pole tower list template, wherein the pole tower list template includes a template page, each cell in the template page is filled with a first protocol placeholder for cell filling, and the first protocol placeholder includes a protocol field; For any cell in the template page, extract the corresponding protocol field from the first protocol placeholder in the any cell, and determine the tower field information corresponding to the protocol field in the first protocol placeholder in the any cell from the tower information database based on the extracted protocol field; Generate filling information corresponding to any cell according to the determined tower field information; The filling information corresponding to any cell is filled into the any cell, and after filling, the filling information of the next cell of the any cell is determined, until all cells in the template page are polled, and the tower detail list is obtained.

2. The method according to claim 1, It is characterized in that The first protocol placeholder includes a data replacement placeholder, an operation placeholder or a position placeholder, wherein when the first protocol placeholder is a data replacement placeholder, the protocol field is a replacement field, and when the first protocol placeholder is an operation placeholder, the protocol field is an operation field; The extracting of the corresponding protocol field from the first protocol placeholder in any cell, and determining the tower field information corresponding to the protocol field in the first protocol placeholder in any cell from the tower information database based on the extracted protocol field, includes: Determine whether the first protocol placeholder in any cell is a data replacement placeholder; If yes, remove the placeholder identifier in the data replacement placeholder to obtain a replacement field in the data replacement placeholder; Based on the replacement field, filtering out the tower field information corresponding to the replacement field from the tower information database; Correspondingly, generating filling information corresponding to any cell according to the determined tower field information includes: The tower field information corresponding to the replacement field is used as the filling information corresponding to any cell.

3. The method according to claim 2, It is characterized in that Determining whether the first protocol placeholder in any cell is a data replacement placeholder includes: If not, determining whether the first protocol placeholder in any cell is an operation placeholder; If yes, then read the operation placeholder in any cell in the form of a character string, and determine the protocol operator in the read operation placeholder; Extracting the character strings before and after the protocol operator from the read operation placeholder to obtain the operation field after extraction; Based on the operation field, filtering out the pole tower field information corresponding to the operation field from the pole tower information database; Correspondingly, generating filling information corresponding to any cell according to the determined tower field information includes: Based on the protocol operator, the pole tower field information corresponding to the operation field is processed to obtain the filling information of any cell after the operation, wherein the protocol operator is a concatenation operator, an addition operator, a multiplication operator, a division operator or a subtraction operator.

4. The method according to claim 3, It is characterized in that Determining whether the first protocol placeholder in any cell is an operation placeholder includes: If not, jump to the next row of the row where any cell is located, and determine whether the first protocol placeholder in the first cell in the next row is a data replacement placeholder, until all cells in the template page are polled.

5. The method according to claim 1, It is characterized in that The template page also includes a page name, wherein before extracting the corresponding protocol field from the first protocol placeholder in any cell, the method further includes: According to the page name of the template page, the total number of towers to be filled is determined from the tower information database, and based on the total number of towers to be filled, the required number of template pages is determined; Determine whether the required number of template pages is greater than the total number of template pages in the tower list template; If yes, copy the template page in the tower list template to obtain n template pages, where n is the required number of template pages; For any template page among the n template pages, determining fill information of any cell in any template page according to the tower information database and the protocol field in the first protocol placeholder in any cell in any template page; Based on the filling information of any cell in any template page, any cell in any template page is filled, and after filling, the filling information of the next cell of any cell in any template page is determined, until all cells in any template page are polled, the tower detail page corresponding to the template page is obtained, and when all template pages are polled, the tower detail list of the tower to be filled is obtained.

6. The method according to claim 5, It is characterized in that The page name includes a second protocol placeholder, the second protocol placeholder includes a conditional filter, and the first protocol placeholder includes a placeholder for representing the end of a line; According to the page name of the template page, the total number of towers to be filled is determined from the tower information database, including: Extracting a second protocol placeholder from the page name, and extracting a conditional screening field from the second protocol placeholder; Determining a tower name field corresponding to the conditional screening field from the tower information database; Counting the total number of pole tower name fields corresponding to the conditional screening fields as the total number of pole towers to be filled; Accordingly, based on the total number of towers to be filled, the required number of template pages is determined, which includes: Counting the total number of placeholders in the template page; Determining the number of fillable rows in the template page based on the total number of placeholders; The required number of template pages is calculated based on the total number of the towers to be filled and the number of rows that can be filled.

7. The method according to claim 5, It is characterized in that Copy the template page in the tower schedule template, including: Determine the end row number and the end column number from the template page, and obtain the copy row number and the copy column number based on the end row number and the end column number; The template page is copied according to the number of copied rows, the number of copied columns and the required number of template pages to obtain n template pages.

8. A device for generating a tower list, It is characterized in that include: An acquisition unit is used to acquire a pole tower list template, wherein the pole tower list template includes a template page, each cell in the template page is filled with a first protocol placeholder for cell filling, and the first protocol placeholder includes a protocol field; An information matching unit, configured to extract, for any cell in the template page, a corresponding protocol field from a first protocol placeholder in the any cell, and determine, based on the extracted protocol field, from a tower information database, tower field information corresponding to the protocol field in the first protocol placeholder in the any cell; A filling information generating unit, used for generating filling information corresponding to any cell according to the determined tower field information; The table filling unit is used to fill the filling information corresponding to any cell into the any cell, and after filling, determine the filling information of the next cell of the any cell, until all cells in the template page are polled to obtain the tower detail list.

9. A device for generating a tower list, It is characterized in that include: A memory, a processor and a transceiver which are sequentially connected in communication, wherein the memory is used to store a computer program, the transceiver is used to send and receive messages, and the processor is used to read the computer program to execute the method for generating a tower list as described in any one of claims 1 to 7.

10. A computer program product comprising instructions, It is characterized in that When the instructions are executed on a computer, the computer is caused to execute the method for generating a tower list as claimed in any one of claims 1 to 7.

Images