阅读说明：本技术 一种生成二维表格的方法、装置、设备及可读介质 (Method, device and equipment for generating two-dimensional table and readable medium ) 是由 张悦 徐基法 于 2021-07-23 设计创作，主要内容包括：本发明提供了一种生成二维表格的方法、装置、设备及可读介质,该方法包括：创建表格,为表格的表头设置属性值并将表格中计算需要的固定值填入表格中；定义map,将表格外的需要参与表格计算的参数值存储到map中并将表格中计算需要的固定值存储到map中；为表格中的单元格定义计算公式,计算公式使用map中存储的参数作为入参进行计算。通过使用本发明的方案,能够使用表格外的数据参与运算,能够支持三目运算等较复杂的公式规则。(The invention provides a method, a device, equipment and a readable medium for generating a two-dimensional table, wherein the method comprises the following steps: creating a form, setting an attribute value for a header of the form and filling a fixed value required by calculation in the form into the form; defining a map, storing parameter values needing to participate in table calculation outside the table into the map, and storing fixed values needed by calculation in the table into the map; a calculation formula is defined for the cells in the table, the calculation formula being calculated using the parameters stored in the map as entries. By using the scheme of the invention, data outside the table can be used for participating in operation, and more complex formula rules such as trinocular operation can be supported.)

1. A method of generating a two-dimensional table, comprising the steps of:

creating a form, setting an attribute value for a header of the form, and filling a fixed value required by calculation in the form into the form;

defining a map, storing parameter values needing to participate in table calculation out of the tables into the map, and storing fixed values needed by calculation in the tables into the map;

defining a calculation formula for the cells in the table, the calculation formula being calculated using the parameters stored in the map as entries.

2. The method of claim 1, wherein creating a table, setting attribute values for a header of the table, and filling fixed values required for calculation in the table into the table comprises:

judging whether the attribute value of the header is a fixed value or a calculated value;

in response to that the attribute value of the header is a fixed value, writing the fixed value into a specified position of the header;

in response to the attribute value of the header being the calculation value, a calculation formula is defined at the set position of the header using the JS script.

3. The method of claim 1, wherein defining a calculation formula for a cell in the table, the calculation formula being calculated using a parameter stored in the map as an entry parameter comprises:

and acquiring the positions of the cells needing to participate in calculation in the table, and defining a calculation formula by using a JS script in a background corresponding to the acquired positions of the cells.

4. The method of claim 3, further comprising:

the JS engine ScriptEngine is used to execute the JS script defined calculation formula.

5. The method of claim 1, wherein the form is in HTML format.

6. An apparatus for generating a two-dimensional table, the apparatus comprising:

the creating module is configured to create a form, set an attribute value for a header of the form and fill a fixed value required by calculation in the form into the form;

the defining module is configured to define a map, store parameter values, which are out of the tables and need to participate in table calculation, in the map, and store fixed values, which are needed in the table and need to be calculated, in the map;

a calculation module configured to define a calculation formula for a cell in the table, the calculation formula being calculated using a parameter stored in the map as an entry parameter.

7. The apparatus of claim 6, wherein the creation module is further configured to:

judging whether the attribute value of the header is a fixed value or a calculated value;

in response to that the attribute value of the header is a fixed value, writing the fixed value into a specified position of the header;

in response to the attribute value of the header being the calculation value, a calculation formula is defined at the set position of the header using the JS script.

8. The apparatus of claim 6, wherein the computing module is further configured to:

and acquiring the positions of the cells needing to participate in calculation in the table, and defining a calculation formula by using a JS script in a background corresponding to the acquired positions of the cells.

9. A computer device, comprising:

at least one processor; and

a memory storing computer instructions executable on the processor, the instructions when executed by the processor implementing the steps of the method of any one of claims 1 to 5.

10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of the method according to any one of claims 1 to 5.

Technical Field

The field relates to the field of computers, and more particularly to a method, apparatus, device and readable medium for generating a two-dimensional table.

Background

In the field of formula calculation for spreadsheets, the calculation and filling of cell values is often involved. Some values are dynamically populated, some are constants, and some are calculated according to defined formulas. This involves the definition of cell attributes, the definition of formulas and the resolution of formulas. When the parameters in the calculation formula exceed the existing data range of the table, the traditional calculation mode similar to Excel is not applicable any more. In addition, in the java language, the calculation is generally performed by means of Math class, and the symbolized formula cannot be directly operated.

The existing spreadsheet calculation method is an Excel method, and a calculation value of a certain cell is filled by defining a calculation formula between cells. Another improved approach is to define cells in batches by defining formulas that relate a row or column to other cells. The calculation of the cell values by adopting the two schemes is limited in the range of the table, and the values outside the table cannot be dynamically acquired to participate in the calculation of the cells.

Disclosure of Invention

In view of this, embodiments of the present invention provide a method, an apparatus, a device, and a readable medium for generating a two-dimensional table, which can use data outside the table to participate in operations and support more complex formula rules such as a trinocular operation.

In view of the above object, an aspect of embodiments of the present invention provides a method of generating a two-dimensional table, including the steps of:

creating a form, setting an attribute value for a header of the form and filling a fixed value required by calculation in the form into the form;

defining a map, storing parameter values needing to participate in table calculation outside the table into the map, and storing fixed values needed by calculation in the table into the map;

a calculation formula is defined for the cells in the table, the calculation formula being calculated using the parameters stored in the map as entries.

According to an embodiment of the present invention, creating a table, setting an attribute value for a header of the table, and filling a fixed value required for calculation in the table into the table includes:

judging whether the attribute value of the header is a fixed value or a calculated value;

in response to that the attribute value of the header is a fixed value, writing the fixed value into a specified position of the header;

in response to the attribute value of the header being a calculation value, a calculation formula is defined at a set position of the header using JS (which is a lightweight, interpreted, or just-in-time programming language with function priority) script.

According to one embodiment of the present invention, defining a calculation formula for a cell in a table, the calculation formula being calculated using parameters stored in a map as arguments, comprises:

and obtaining the positions of the cells needing to participate in the calculation in the table, and defining a calculation formula by using a JS script in a background corresponding to the obtained positions of the cells.

According to an embodiment of the present invention, further comprising:

the JS engine script (an engine class in Java that executes JS statements) is used to execute the calculation formula defined by the JS script.

According to one embodiment of the invention, the format of the table is in HTML format.

In another aspect of the embodiments of the present invention, there is also provided an apparatus for generating a two-dimensional table, the apparatus including:

the creating module is configured to create a table, set an attribute value for a table header of the table and fill a fixed value required by calculation in the table into the table;

the defining module is configured to define a map, store parameter values needing to participate in table calculation outside the table into the map, and store fixed values needed by calculation in the table into the map;

and the calculation module is configured to define a calculation formula for the cells in the table, and the calculation formula uses the parameters stored in the map as the parameters for calculation.

According to one embodiment of the invention, the creation module is further configured to:

judging whether the attribute value of the header is a fixed value or a calculated value;

in response to that the attribute value of the header is a fixed value, writing the fixed value into a specified position of the header;

in response to the attribute value of the header being the calculation value, a calculation formula is defined at the set position of the header using the JS script.

According to one embodiment of the invention, the computing module is further configured to:

and obtaining the positions of the cells needing to participate in the calculation in the table, and defining a calculation formula by using a JS script in a background corresponding to the obtained positions of the cells.

According to one embodiment of the invention, the computing module is further configured to:

the JS engine ScriptEngine is used to execute the JS script defined calculation formula.

According to one embodiment of the invention, the format of the table is in HTML format.

In another aspect of an embodiment of the present invention, there is also provided a computer apparatus including:

at least one processor; and

a memory storing computer instructions executable on the processor, the instructions when executed by the processor implementing the steps of any one of the methods described above, comprising:

creating a form, setting an attribute value for a header of the form and filling a fixed value required by calculation in the form into the form;

defining a map, storing parameter values needing to participate in table calculation outside the table into the map, and storing fixed values needed by calculation in the table into the map;

a calculation formula is defined for the cells in the table, the calculation formula being calculated using the parameters stored in the map as entries.

According to an embodiment of the present invention, creating a table, setting an attribute value for a header of the table, and filling a fixed value required for calculation in the table into the table includes:

judging whether the attribute value of the header is a fixed value or a calculated value;

in response to that the attribute value of the header is a fixed value, writing the fixed value into a specified position of the header;

in response to the attribute value of the header being a calculation value, a calculation formula is defined at a set position of the header using JS (which is a lightweight, interpreted, or just-in-time programming language with function priority) script.

According to one embodiment of the present invention, defining a calculation formula for a cell in a table, the calculation formula being calculated using parameters stored in a map as arguments, comprises:

and obtaining the positions of the cells needing to participate in the calculation in the table, and defining a calculation formula by using a JS script in a background corresponding to the obtained positions of the cells.

According to an embodiment of the present invention, further comprising:

the JS engine script (an engine class in Java that executes JS statements) is used to execute the calculation formula defined by the JS script.

According to one embodiment of the invention, the format of the table is in HTML format.

In another aspect of the embodiments of the present invention, there is also provided a computer-readable storage medium storing a computer program, which when executed by a processor implements the steps of any one of the above methods, including:

creating a form, setting an attribute value for a header of the form and filling a fixed value required by calculation in the form into the form;

defining a map, storing parameter values needing to participate in table calculation outside the table into the map, and storing fixed values needed by calculation in the table into the map;

a calculation formula is defined for the cells in the table, the calculation formula being calculated using the parameters stored in the map as entries.

According to an embodiment of the present invention, creating a table, setting an attribute value for a header of the table, and filling a fixed value required for calculation in the table into the table includes:

judging whether the attribute value of the header is a fixed value or a calculated value;

in response to that the attribute value of the header is a fixed value, writing the fixed value into a specified position of the header;

in response to the attribute value of the header being a calculation value, a calculation formula is defined at a set position of the header using JS (which is a lightweight, interpreted, or just-in-time programming language with function priority) script.

According to one embodiment of the present invention, defining a calculation formula for a cell in a table, the calculation formula being calculated using parameters stored in a map as arguments, comprises:

and obtaining the positions of the cells needing to participate in the calculation in the table, and defining a calculation formula by using a JS script in a background corresponding to the obtained positions of the cells.

According to an embodiment of the present invention, further comprising:

the JS engine script (an engine class in Java that executes JS statements) is used to execute the calculation formula defined by the JS script.

According to one embodiment of the invention, the format of the table is in HTML format.

The invention has the following beneficial technical effects: according to the method for generating the two-dimensional table, the table is created, the attribute value is set for the header of the table, and the fixed value required by calculation in the table is filled in the table; defining a map, storing parameter values needing to participate in table calculation outside the table into the map, and storing fixed values needed by calculation in the table into the map; the technical scheme that the calculation formula is defined for the cells in the table, the calculation formula uses the parameters stored in the map as the parameters for calculation, extra-table data can be used for operation, and more complex formula rules such as trinocular operation can be supported.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other embodiments can be obtained by using the drawings without creative efforts.

FIG. 1 is a schematic flow chart diagram of a method of generating a two-dimensional table in accordance with one embodiment of the present invention;

FIG. 2 is a schematic diagram of an apparatus for generating a two-dimensional table according to one embodiment of the invention;

FIG. 3 is a schematic diagram of a computer device according to one embodiment of the present invention;

fig. 4 is a schematic diagram of a computer-readable storage medium according to an embodiment of the present invention.

Detailed Description

In order to make the objects, technical solutions and advantages of the present invention more apparent, the following embodiments of the present invention are described in further detail with reference to the accompanying drawings.

In view of the above objects, a first aspect of embodiments of the present invention proposes an embodiment of a method of generating a two-dimensional table. Fig. 1 shows a schematic flow diagram of the method.

As shown in fig. 1, the method may include the steps of:

s1 creates a table, sets the attribute values for the header of the table, and fills the fixed values needed for calculation in the table.

The form is in an HTML format and can be displayed on a web interface, cells needing to be calculated in the form cannot be changed in a display interface, parameters participating in calculation comprise attribute values in a header, attribute values need to be set for the header of the form in a background interface, the attribute values can be modified by a user in the background according to needs, firstly, whether the attribute values of the header are fixed values or calculated values is judged, if the attribute values of the header are fixed values, the fixed values are written into a background corresponding to the specified position of the header, and if the attribute values of the header are calculated values, a calculation formula is defined in the background corresponding to the set position of the header by using a JS script.

S2 defines a map (a container for storing elements according to keys, in which a key can be any type of object, there cannot be repeated keys in the map, and each key has a corresponding value), stores parameter values out of the table that need to participate in table calculation into the map, and stores fixed values in the table that need to be calculated into the map.

The map is used for storing values used for calculating all formulas, the values comprise fixed values in a header, values in a table and participation values needing to participate in calculation outside the table, all the calculation formulas in the table need to be defined by the JS script, the calculation formulas defined by the JS script are executed by using the JS engine script Engine, and the values stored in the map are transmitted to the JS for calculation as the participation values.

S3 defines a calculation formula for the cell in the table, the calculation formula being calculated using the parameter stored in the map as an entry.

The technical scheme of the invention is simple to realize, can use java programs to calculate the formula of the cell, uses JS scripts to define the type of data, supports more complex formula rules such as trinocular operation and the like, and simultaneously supports the data except read tables to participate in calculation.

In a preferred embodiment of the present invention, creating a table, setting an attribute value for a header of the table, and filling a fixed value required for calculation in the table into the table includes:

judging whether the attribute value of the header is a fixed value or a calculated value;

in response to that the attribute value of the header is a fixed value, writing the fixed value into a specified position of the header;

in response to the attribute value of the header being the calculation value, a calculation formula is defined at the set position of the header using the JS script. The form is in an HTML format and can be displayed on a web interface, cells needing to be calculated in the form cannot be changed in a display interface, parameters participating in calculation comprise attribute values in a header, attribute values need to be set for the header of the form in a background interface, the attribute values can be modified by a user in the background according to needs, firstly, whether the attribute values of the header are fixed values or calculated values is judged, if the attribute values of the header are fixed values, the fixed values are written into a background corresponding to the specified position of the header, and if the attribute values of the header are calculated values, a calculation formula is defined in the background corresponding to the set position of the header by using a JS script.

In a preferred embodiment of the present invention, a calculation formula is defined for a cell in a table, the calculation formula using a parameter stored in a map as an entry parameter includes:

and obtaining the positions of the cells needing to participate in the calculation in the table, and defining a calculation formula by using a JS script in a background corresponding to the obtained positions of the cells. The map is used for storing values used for calculating all formulas, the values comprise fixed values in a header, values in a table and participation values needing to participate in calculation outside the table, all the calculation formulas in the table need to be defined by the JS script, the calculation formulas defined by the JS script are executed by using the JS engine script Engine, and the values stored in the map are transmitted to the JS for calculation as the participation values.

In a preferred embodiment of the present invention, the method further comprises:

the JS engine ScriptEngine is used to execute the JS script defined calculation formula.

In a preferred embodiment of the invention, the format of the table is in HTML format.

Examples

A user needs to self-define and display a table in a two-dimensional HTML format, wherein the head of the table has two types, one type is a fixed value, the other type is a calculated value, and the cell calculation needs to use parameter values outside the table. In addition, some rows of the table are values that are manually filled by the user, some rows are determined by calculation based on values of other rows and parameter values outside the table, and the calculation formula involves a trinocular operation.

The parameter values outside the table are a-1, b-2, c-4, and d-5, and these parameter values are stored in map, and the table has the cell numbering as in table 1 below:

TABLE 1 Table cell numbering scheme

	1	2	3
				A	A1	A2	A3
B	B1	B2	B3
				C	C1	C2	C3

Where, the headers 1, 2, and A, B are fixed values, i.e., header 1 is 10, header 2 is 20, header a is 0.1, and header 2 is 0.2, and these fixed values are filled in the cell background position, and these values are displayed in the table and stored in map, and the headers 3 and C are calculated values, and the header 3 is 0.5 a, then the JS formula is defined as return 0.5 a, the header C is 0.5 b, and then the JS formula is defined as return 0.5 b. The first row a1-A3 of the table is filled with values manually, a 1-12, a 2-4, and A3-8 are filled into the corresponding positions in the background of the table, and the fixed values are stored in map. B1-B3 is a calculated value, the calculation formula is run (An + c)/c, the cycle is 3 times, and the values of A1-A3 are respectively assigned to An, so that the value of Bn can be obtained. C1-C3 are calculated values, the calculation formula is return Bn-An +5>0true: false, the cycle is 3 times, the values of A1-A3 are respectively assigned to An, the values of B1-B3 are respectively assigned to Bn, and the value of Cn can be obtained. Then the final table is shown in table 2 below:

table 2 table is finally generated

According to the technical scheme, the data outside the table can be used for participating in operation, and more complex formula rules such as trinocular operation can be supported.

It should be noted that, as will be understood by those skilled in the art, all or part of the processes in the methods of the above embodiments may be implemented by instructing relevant hardware through a computer program, and the above programs may be stored in a computer-readable storage medium, and when executed, the programs may include the processes of the embodiments of the methods as described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), or the like. The embodiments of the computer program may achieve the same or similar effects as any of the above-described method embodiments.

Furthermore, the method disclosed according to an embodiment of the present invention may also be implemented as a computer program executed by a CPU, and the computer program may be stored in a computer-readable storage medium. The computer program, when executed by the CPU, performs the above-described functions defined in the method disclosed in the embodiments of the present invention.

In view of the above object, according to a second aspect of the embodiments of the present invention, there is provided an apparatus for generating a two-dimensional table, as shown in fig. 2, the apparatus 200 includes:

the creating module 201, the creating module 201 is configured to create a table, set an attribute value for a header of the table, and fill a fixed value required by calculation in the table into the table;

the defining module 202, the defining module 202 is configured to define a map, store parameter values required to participate in table calculation outside the table into the map, and store fixed values required by calculation in the table into the map;

and the calculation module 203, wherein the calculation module 203 is configured to define a calculation formula for the cells in the table, and the calculation formula is calculated by using the parameters stored in the map as the entries.

In a preferred embodiment of the present invention, the creation module is further configured to:

judging whether the attribute value of the header is a fixed value or a calculated value;

in response to that the attribute value of the header is a fixed value, writing the fixed value into a specified position of the header;

in response to the attribute value of the header being the calculation value, a calculation formula is defined at the set position of the header using the JS script.

In a preferred embodiment of the invention, the calculation module is further configured to:

and obtaining the positions of the cells needing to participate in the calculation in the table, and defining a calculation formula by using a JS script in a background corresponding to the obtained positions of the cells.

In a preferred embodiment of the invention, the calculation module is further configured to:

the JS engine ScriptEngine is used to execute the JS script defined calculation formula.

In a preferred embodiment of the invention, the format of the table is in HTML format.

In view of the above object, a third aspect of the embodiments of the present invention provides a computer device. Fig. 3 is a schematic diagram of an embodiment of a computer device provided by the present invention. As shown in fig. 3, an embodiment of the present invention includes the following means: at least one processor S21; and a memory S22, the memory S22 storing computer instructions S23 executable on the processor, the instructions when executed by the processor implementing the method of:

creating a table, setting attribute values for a header of the table and filling fixed values required by calculation in the table into the table.

The form is in an HTML format and can be displayed on a web interface, cells needing to be calculated in the form cannot be changed in a display interface, parameters participating in calculation comprise attribute values in a header, attribute values need to be set for the header of the form in a background interface, the attribute values can be modified by a user in the background according to needs, firstly, whether the attribute values of the header are fixed values or calculated values is judged, if the attribute values of the header are fixed values, the fixed values are written into a background corresponding to the specified position of the header, and if the attribute values of the header are calculated values, a calculation formula is defined in the background corresponding to the set position of the header by using a JS script.

Defining a map, storing parameter values needing to participate in table calculation outside the table into the map, and storing fixed values needed by calculation in the table into the map.

The map is used for storing values used for calculating all formulas, the values comprise fixed values in a header, values in a table and participation values needing to participate in calculation outside the table, all the calculation formulas in the table need to be defined by the JS script, the calculation formulas defined by the JS script are executed by using the JS engine script Engine, and the values stored in the map are transmitted to the JS for calculation as the participation values.

A calculation formula is defined for the cells in the table, the calculation formula being calculated using the parameters stored in the map as entries.

In a preferred embodiment of the present invention, creating a table, setting an attribute value for a header of the table, and filling a fixed value required for calculation in the table into the table includes:

judging whether the attribute value of the header is a fixed value or a calculated value;

in response to that the attribute value of the header is a fixed value, writing the fixed value into a specified position of the header;

in response to the attribute value of the header being the calculation value, a calculation formula is defined at the set position of the header using the JS script.

In a preferred embodiment of the present invention, a calculation formula is defined for a cell in a table, the calculation formula using a parameter stored in a map as an entry parameter includes:

and obtaining the positions of the cells needing to participate in the calculation in the table, and defining a calculation formula by using a JS script in a background corresponding to the obtained positions of the cells.

In a preferred embodiment of the present invention, the method further comprises:

the JS engine ScriptEngine is used to execute the JS script defined calculation formula.

In a preferred embodiment of the invention, the format of the table is in HTML format.

In view of the above object, a fourth aspect of the embodiments of the present invention proposes a computer-readable storage medium. FIG. 4 is a schematic diagram illustrating an embodiment of a computer-readable storage medium provided by the present invention. As shown in fig. 4, the computer readable storage medium stores S31 a computer program that, when executed by a processor, performs the method S32:

creating a table, setting attribute values for a header of the table and filling fixed values required by calculation in the table into the table.

The form is in an HTML format and can be displayed on a web interface, cells needing to be calculated in the form cannot be changed in a display interface, parameters participating in calculation comprise attribute values in a header, attribute values need to be set for the header of the form in a background interface, the attribute values can be modified by a user in the background according to needs, firstly, whether the attribute values of the header are fixed values or calculated values is judged, if the attribute values of the header are fixed values, the fixed values are written into a background corresponding to the specified position of the header, and if the attribute values of the header are calculated values, a calculation formula is defined in the background corresponding to the set position of the header by using a JS script.

Defining a map, storing parameter values needing to participate in table calculation outside the table into the map, and storing fixed values needed by calculation in the table into the map.

The map is used for storing values used for calculating all formulas, the values comprise fixed values in a header, values in a table and participation values needing to participate in calculation outside the table, all the calculation formulas in the table need to be defined by the JS script, the calculation formulas defined by the JS script are executed by using the JS engine script Engine, and the values stored in the map are transmitted to the JS for calculation as the participation values.

A calculation formula is defined for the cells in the table, the calculation formula being calculated using the parameters stored in the map as entries.

In a preferred embodiment of the present invention, creating a table, setting an attribute value for a header of the table, and filling a fixed value required for calculation in the table into the table includes:

judging whether the attribute value of the header is a fixed value or a calculated value;

in response to that the attribute value of the header is a fixed value, writing the fixed value into a specified position of the header;

in response to the attribute value of the header being the calculation value, a calculation formula is defined at the set position of the header using the JS script.

In a preferred embodiment of the present invention, a calculation formula is defined for a cell in a table, the calculation formula using a parameter stored in a map as an entry parameter includes:

and obtaining the positions of the cells needing to participate in the calculation in the table, and defining a calculation formula by using a JS script in a background corresponding to the obtained positions of the cells.

In a preferred embodiment of the present invention, the method further comprises:

the JS engine ScriptEngine is used to execute the JS script defined calculation formula.

In a preferred embodiment of the invention, the format of the table is in HTML format.

Furthermore, the methods disclosed according to embodiments of the present invention may also be implemented as a computer program executed by a processor, which may be stored in a computer-readable storage medium. Which when executed by a processor performs the above-described functions defined in the methods disclosed in embodiments of the invention.

Further, the above method steps and system elements may also be implemented using a controller and a computer readable storage medium for storing a computer program for causing the controller to implement the functions of the above steps or elements.

Those of skill would further appreciate that the various illustrative logical blocks, modules, circuits, and algorithm steps described in connection with the disclosure herein may be implemented as electronic hardware, computer software, or combinations of both. To clearly illustrate this interchangeability of hardware and software, various illustrative components, blocks, modules, circuits, and steps have been described above generally in terms of their functionality. Whether such functionality is implemented as software or hardware depends upon the particular application and design constraints imposed on the overall system. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the disclosed embodiments of the present invention.

In one or more exemplary designs, the functions may be implemented in hardware, software, firmware, or any combination thereof. If implemented in software, the functions may be stored on or transmitted over as one or more instructions or code on a computer-readable medium. Computer-readable media includes both computer storage media and communication media including any medium that facilitates transfer of a computer program from one place to another. A storage media may be any available media that can be accessed by a general purpose or special purpose computer. By way of example, and not limitation, such computer-readable media can comprise RAM, ROM, EEPROM, CD-ROM or other optical disk storage, magnetic disk storage or other magnetic storage devices, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a general-purpose or special-purpose computer, or a general-purpose or special-purpose processor. Also, any connection is properly termed a computer-readable medium. For example, if the software is transmitted from a website, server, or other remote source using a coaxial cable, fiber optic cable, twisted pair, Digital Subscriber Line (DSL), or wireless technologies such as infrared, radio, and microwave, then the coaxial cable, fiber optic cable, twisted pair, DSL, or wireless technologies such as infrared, radio, and microwave are included in the definition of medium. Disk and disc, as used herein, includes Compact Disc (CD), laser disc, optical disc, Digital Versatile Disc (DVD), floppy disk, blu-ray disc where disks usually reproduce data magnetically, while discs reproduce data optically with lasers. Combinations of the above should also be included within the scope of computer-readable media.

The foregoing is an exemplary embodiment of the present disclosure, but it should be noted that various changes and modifications could be made herein without departing from the scope of the present disclosure as defined by the appended claims. The functions, steps and/or actions of the method claims in accordance with the disclosed embodiments described herein need not be performed in any particular order. Furthermore, although elements of the disclosed embodiments of the invention may be described or claimed in the singular, the plural is contemplated unless limitation to the singular is explicitly stated.

It should be understood that, as used herein, the singular forms "a", "an" and "the" are intended to include the plural forms as well, unless the context clearly supports the exception. It should also be understood that "and/or" as used herein is meant to include any and all possible combinations of one or more of the associated listed items.

The numbers of the embodiments disclosed in the embodiments of the present invention are merely for description, and do not represent the merits of the embodiments.

It will be understood by those skilled in the art that all or part of the steps for implementing the above embodiments may be implemented by hardware, or may be implemented by a program instructing relevant hardware, and the program may be stored in a computer-readable storage medium, and the above-mentioned storage medium may be a read-only memory, a magnetic disk or an optical disk, etc.

Those of ordinary skill in the art will understand that: the discussion of any embodiment above is meant to be exemplary only, and is not intended to intimate that the scope of the disclosure, including the claims, of embodiments of the invention is limited to these examples; within the idea of an embodiment of the invention, also technical features in the above embodiment or in different embodiments may be combined and there are many other variations of the different aspects of the embodiments of the invention as described above, which are not provided in detail for the sake of brevity. Therefore, any omissions, modifications, substitutions, improvements, and the like that may be made without departing from the spirit and principles of the embodiments of the present invention are intended to be included within the scope of the embodiments of the present invention.