CN117539870A - An entertainment venue data table management method and system - Google Patents

Abstract

The present invention provides an entertainment venue data table management method and system in the technical field of entertainment venue data table management. The method includes: step S10, setting data source parameters; step S20, creating several data models based on the data source parameters; step S30 , combine each data model to create several data sets; step S40, add the fields in each data set to the editing area, automatically typeset and generate a data table, edit the generated data table, and save the edited data table; Step S50: Query the data table based on the filter field, elimination field, time period or operator, generate and save it as a new data table; Step S60: Encrypt the new data table, and generate an access link to the encrypted new data table. Share new tables of data based on access links. The invention has the advantage that it greatly improves the flexibility and convenience of data table management in entertainment venues.

Description

An entertainment venue data table management method and system

Technical field

The invention relates to the technical field of entertainment venue data table management, and in particular to an entertainment venue data table management method and system.

Background technique

During the operation of entertainment venues, a large number of data tables need to be used for operation and management, such as purchase tables, order tables, salary tables, performance tables, stored wine access records, stored wine inventory summary tables, and loan and return wine inventory details. , product quantity detail table, product account detail table, warehouse-in order consolidated item freight, warehouse inventory profit and loss detailed list, warehouse-in order freight table, etc. Through these data tables, the operation status of entertainment venues can be understood. However, traditional data tables are isolated from each other and only support simple query, display, hiding and other functions, and cannot interact between data tables. For example, it is impossible to integrate and display the relevant data of an employee in the salary table and performance table. , and the data table cannot be shared, resulting in poor user experience; in addition, when a new data table needs to be added, it is traditionally necessary to rewrite the code for development to define each table parameter of the data table, and there is a certain threshold. , which is not only inefficient but also costly to develop.

Therefore, how to provide an entertainment venue data table management method and system to improve the flexibility and convenience of entertainment venue data table management has become an urgent technical problem to be solved.

Contents of the invention

The technical problem to be solved by the present invention is to provide an entertainment venue data table management method and system to improve the flexibility and convenience of entertainment venue data table management.

In a first aspect, the present invention provides an entertainment venue data table management method, which includes the following steps:

Step S10: Set data source parameters for obtaining entertainment venue operation data;

Step S20: Create several data models based on the data source parameters;

Step S30: Combine each of the data models to create several data sets;

Step S40: Add the data set fields in each of the data sets to the editing area through drag-and-drop interaction, automatically type and generate a data table, edit the generated data table, and save the edited data table. ;

Step S50: Query the data table based on filter fields, elimination fields, time periods or operators, generate and save it as a new data table;

Step S60: Encrypt the new data table, generate an access link to the encrypted new data table, and share the new data table based on the access link.

Further, in step S10, the data source parameters at least include source name, database type, database IP, database port, database name, database user name and database password.

Further, the step S20 is specifically:

Configure model information, model fields and model relationships through the visual interface, and then create several data models;

The model information at least includes data source parameters, classification, table names, labels, visible identifiers, sorting and update time; the modular model relationship is a mapping relationship between different data models.

Further, the step S30 is specifically:

Configure data set information, data set fields and data set relationships through the visual interface, and then create several data sets;

The data set information at least includes title, status, homepage information, data set classification, data set type, data model, data model combination conditions, data model grouping, and data model grouping conditions; the data set relationship is different data mapping relationship between sets.

Further, the step S40 is specifically:

Through drag-and-drop interaction, the data set fields in each of the data sets are added to the editing area, and the data set fields of each of the data sets that have a mapping relationship are automatically merged and typed into a data table, and those that do not have a mapping relationship are automatically merged and typed into one data table. For the data set fields of each of the data sets, a data table is generated by grouping the data sets;

Create columns, modify columns, delete columns, freeze, group subtotals, summarize statistics, hide this column, or cancel all hidden edits on the generated data table, and save the edited data table based on the received save instruction.

In a second aspect, the present invention provides an entertainment venue data table management system, including the following modules:

The data source parameter setting module is used to set the data source parameters used to obtain entertainment venue operation data;

A data model creation module, used to create several data models based on the data source parameters;

A data set creation module, used to combine each of the data models to create several data sets;

The data table generation module is used to add the data set fields in each data set to the editing area through drag-and-drop interaction, and automatically typeset and generate a data table, edit the generated data table, and save the edited results. the data table;

The data table query module is used to query the data table based on filter fields, elimination fields, time periods or operators, and generate and save it as a new data table;

A new data table sharing module is used to encrypt the new data table, generate an access link to the encrypted new data table, and share the new data table based on the access link.

Further, in the data source parameter setting module, the data source parameters at least include source name, database type, database IP, database port, database name, database user name and database password.

Further, the data model creation module is specifically used for:

Configure model information, model fields and model relationships through the visual interface, and then create several data models;

The model information at least includes data source parameters, classification, table names, labels, visible identifiers, sorting and update time; the modular model relationship is a mapping relationship between different data models.

Further, the data set creation module is specifically used for:

Configure data set information, data set fields and data set relationships through the visual interface, and then create several data sets;

The data set information at least includes title, status, homepage information, data set classification, data set type, data model, data model combination conditions, data model grouping, and data model grouping conditions; the data set relationship is different data mapping relationship between sets.

Further, the data table generation module is specifically used for:

Through drag-and-drop interaction, the data set fields in each of the data sets are added to the editing area, and the data set fields of each of the data sets that have a mapping relationship are automatically merged and typed into a data table, and those that do not have a mapping relationship are automatically merged and typed into one data table. For the data set fields of each of the data sets, a data table is generated by grouping the data sets;

Create columns, modify columns, delete columns, freeze, group subtotals, summarize statistics, hide this column, or cancel all hidden edits on the generated data table, and save the edited data table based on the received save instruction.

The advantages of the present invention are:

By setting data source parameters, several data models are created based on the data source parameters. During the creation process, the mapping relationships between different data models are set, and each data model is combined to create several data sets. During the creation process, different data models are set. Mapping relationships between data sets, and then adding the data set fields in each data set to the editing area through drag-and-drop interaction, automatically merging and formatting the data set fields of each data set with mapping relationships into a data table, and For the data set fields of each data set that do not have a mapping relationship, a data table is generated by grouping the data sets. Create columns, modify columns, delete columns, freeze, group subtotals, summary statistics, and hide the generated data tables. This column can either cancel all hidden edits and save the edited data table; then query the data table based on filter fields, deleted fields, time periods or operators, generate and save a new data table; and finally encrypt the new data table. , generate an access link to the encrypted new data table, and share the new data table based on the access link; that is, different data models and data sets are related to each other based on mapping relationships. Later, by dragging the data set fields of the data set, you can press It needs to be combined to generate a new data table. There is no need to rewrite the code for development like traditional methods. It supports creating columns, modifying columns, deleting columns, freezing, grouping subtotals, summary statistics, hiding this column and canceling all hidden data tables. Edit, and the new data table generated by the final query (filtering) can be safely shared based on the access link, which ultimately greatly improves the flexibility and convenience of entertainment venue data table management, and greatly reduces the complexity of entertainment venue data table management. cost.

Description of drawings

The present invention will be further described below with reference to the accompanying drawings and embodiments.

Figure 1 is a flow chart of an entertainment venue data table management method of the present invention.

Figure 2 is a schematic structural diagram of an entertainment venue data table management system of the present invention.

Figure 3 is a schematic diagram of the interface for setting data source parameters in the present invention.

Figure 4 is a schematic diagram of the interface created by the data model of the present invention.

Figure 5 is a schematic diagram of the interface for data set creation in the present invention.

Figure 6 is a schematic diagram of the interface for editing the data table of the present invention.

Figure 7 is a schematic interface diagram of the data table query according to the present invention.

Figure 8 is a schematic diagram of the interface for sharing a new data table according to the present invention.

Detailed ways

The general idea of the technical solution in the embodiment of this application is as follows: different data models and data sets are related to each other based on mapping relationships. Later, by dragging and dropping the data set fields of the data set, new data tables can be generated on demand, without the need for traditional The code is rewritten for development and supports multi-functional editing of the data table. The new data table generated by the final query can be safely shared based on access links to improve the flexibility and convenience of entertainment venue data table management.

Please refer to Figures 1 to 8, a preferred embodiment of an entertainment venue data table management method of the present invention includes the following steps:

Step S10: Set data source parameters for obtaining entertainment venue operation data;

Step S20: Create several data models based on the data source parameters;

Step S30: Combine each of the data models to create several data sets;

Step S40: Add the data set fields in each of the data sets to the editing area through drag-and-drop interaction, automatically type and generate a data table, edit the generated data table, and save the edited data table. ;

Step S50: Query the data table based on filter fields, elimination fields, time periods or operators, generate and save it as a new data table;

For example, the filtering field is set to employee ID, department ID, business date, bill number, dish ID, category ID, or room; the elimination field is set to employee ID, department ID, dish ID, category ID, or room ; During specific implementation, queries (filtering) can also be carried out based on characters, values, locations and other conditions;

During specific implementation, the query can be based on the following rules: (1) The condition with the word "removal" means that data that meets this condition is eliminated; (2) The input box is marked with ">, >=, <, AI!=, <> The query starting with ,~=" indicates the condition of the data behind the operation, such as: >100; (3) The operation of "=, !=, <>, ~=" supports the use of commas or tab symbols for multi-condition matching, such as: = Zhang San, Li Si, Wang Wu (4) The drop-down search box supports multi-condition matching, such as: Zhang San, Li Si, Wang Wu (5) Date filtering with "to" means date range query (6) Time and minute condition query, the hours and minutes in the 24-hour format are spliced and displayed numerically. The time range is from 0 o'clock to 9 o'clock and the sum of 2400 is added, such as: 2200~2600.

Step S60: Encrypt the new data table, generate an access link to the encrypted new data table, and share the new data table based on the access link. During specific implementation, the alias and validity period of the new data table to be shared can be set to limit access users.

In step S10, the data source parameters at least include source name, database type, database IP, database port, database name, database user name and database password.

The step S20 is specifically:

Configure model information, model fields and model relationships through the visual interface, and then create several data models;

The model information at least includes data source parameters, classification, table names, labels, visible identifiers, sorting, and update times; the modular model relationship is a mapping relationship between different data models. During specific implementation, it may include serial numbers, Fields such as source model, target model, source attribute relationship, relationship type, etc.

The step S30 is specifically:

Configure data set information, data set fields and data set relationships through the visual interface, and then create several data sets;

The data set information at least includes title, status, homepage information, data set classification, data set type, data model, data model combination conditions, data model grouping, and data model grouping conditions; the data set relationship is different data The mapping relationship between sets, when implemented, can include fields such as serial number, source data set, target data set, source attributes, relationship type, grouping label, etc.

During specific implementation, the data set fields may include serial number, employee ID, employee name, department ID, department name, bar turnover, nightclub revenue, actual receipts, sales amount, order amount, performance, sales quantity, Number of units sold, number of units opened, number of units booked, etc.

The step S40 is specifically:

Through drag-and-drop interaction, the data set fields in each of the data sets are added to the editing area, and the data set fields of each of the data sets that have a mapping relationship are automatically merged and typed into a data table, and those that do not have a mapping relationship are automatically merged and typed into one data table. For the data set fields of each of the data sets, a data table is generated by grouping the data sets;

Create columns, modify columns, delete columns, freeze, group subtotals, summarize statistics, hide this column, or cancel all hidden edits on the generated data table, and save the edited data table based on the received save instruction. The modified column can calculate the data of different columns based on the set calculation formula to generate a new column. When saving the data table, the report name, report classification and report sorting are simultaneously set.

A preferred embodiment of an entertainment venue data table management system of the present invention includes the following modules:

The data source parameter setting module is used to set the data source parameters used to obtain entertainment venue operation data;

A data model creation module, used to create several data models based on the data source parameters;

A data set creation module, used to combine each of the data models to create several data sets;

The data table generation module is used to add the data set fields in each data set to the editing area through drag-and-drop interaction, and automatically typeset and generate a data table, edit the generated data table, and save the edited results. the data table;

The data table query module is used to query the data table based on filter fields, elimination fields, time periods or operators, and generate and save it as a new data table;

For example, the filtering field is set to employee ID, department ID, business date, bill number, dish ID, category ID, or room; the elimination field is set to employee ID, department ID, dish ID, category ID, or room ; During specific implementation, queries (filtering) can also be carried out based on characters, values, locations and other conditions;

During specific implementation, the query can be based on the following rules: (1) The condition with the word "removal" means that data that meets this condition is eliminated; (2) The input box is marked with ">, >=, <, AI!=, <> The query starting with ,~=" indicates the condition of the data behind the operation, such as: >100; (3) The operation of "=, !=, <>, ~=" supports the use of commas or tab symbols for multi-condition matching, such as: = Zhang San, Li Si, Wang Wu (4) The drop-down search box supports multi-condition matching, such as: Zhang San, Li Si, Wang Wu (5) Date filtering with "to" means date range query (6) Time and minute condition query, the hours and minutes in the 24-hour format are spliced and displayed numerically. The time range is from 0 o'clock to 9 o'clock and the sum of 2400 is added, such as: 2200~2600.

The new data table sharing module is used to encrypt the new data table, generate an access link to the encrypted new data table, and share the new data table based on the access link. During specific implementation, the alias and validity period of the new data table to be shared can be set to limit access users.

In the data source parameter setting module, the data source parameters at least include source name, database type, database IP, database port, database name, database user name and database password.

The data model creation module is specifically used for:

Configure model information, model fields and model relationships through the visual interface, and then create several data models;

The model information at least includes data source parameters, classification, table names, labels, visible identifiers, sorting, and update times; the modular model relationship is a mapping relationship between different data models. During specific implementation, it may include serial numbers, Fields such as source model, target model, source attribute relationship, relationship type, etc.

The data set creation module is specifically used for:

Configure data set information, data set fields and data set relationships through the visual interface, and then create several data sets;

The data set information at least includes title, status, homepage information, data set classification, data set type, data model, data model combination conditions, data model grouping, and data model grouping conditions; the data set relationship is different data The mapping relationship between sets, when implemented, can include fields such as serial number, source data set, target data set, source attributes, relationship type, grouping label, etc.

During specific implementation, the data set fields may include serial number, employee ID, employee name, department ID, department name, bar turnover, nightclub revenue, actual receipts, sales amount, order amount, performance, sales quantity, Number of units sold, number of units opened, number of units booked, etc.

The data table generation module is specifically used for:

Through drag-and-drop interaction, the data set fields in each of the data sets are added to the editing area, and the data set fields of each of the data sets that have a mapping relationship are automatically merged and typed into a data table, and those that do not have a mapping relationship are automatically merged and typed into one data table. For the data set fields of each of the data sets, a data table is generated by grouping the data sets;

Create columns, modify columns, delete columns, freeze, group subtotals, summarize statistics, hide this column, or cancel all hidden edits on the generated data table, and save the edited data table based on the received save instruction. The modified column can calculate the data of different columns based on the set calculation formula to generate a new column. When saving the data table, the report name, report classification and report sorting are simultaneously set.

To sum up, the advantages of the present invention are:

By setting data source parameters, several data models are created based on the data source parameters. During the creation process, the mapping relationships between different data models are set, and each data model is combined to create several data sets. During the creation process, different data models are set. Mapping relationships between data sets, and then adding the data set fields in each data set to the editing area through drag-and-drop interaction, automatically merging and formatting the data set fields of each data set with mapping relationships into a data table, and For the data set fields of each data set that do not have a mapping relationship, a data table is generated by grouping the data sets. Create columns, modify columns, delete columns, freeze, group subtotals, summary statistics, and hide the generated data tables. This column can either cancel all hidden edits and save the edited data table; then query the data table based on filter fields, deleted fields, time periods or operators, generate and save a new data table; and finally encrypt the new data table. , generate an access link to the encrypted new data table, and share the new data table based on the access link; that is, different data models and data sets are related to each other based on mapping relationships. Later, by dragging the data set fields of the data set, you can press It needs to be combined to generate a new data table. There is no need to rewrite the code for development like traditional methods. It supports creating columns, modifying columns, deleting columns, freezing, grouping subtotals, summary statistics, hiding this column and canceling all hidden data tables. Edit, and the new data table generated by the final query (filtering) can be safely shared based on the access link, which ultimately greatly improves the flexibility and convenience of entertainment venue data table management, and greatly reduces the complexity of entertainment venue data table management. cost.

Although the specific embodiments of the present invention have been described above, those skilled in the art should understand that the specific embodiments we have described are only illustrative and are not used to limit the scope of the present invention. Those skilled in the art Equivalent modifications and changes made by skilled persons in accordance with the spirit of the present invention shall be covered by the scope of protection of the claims of the present invention.

Claims (10)

1. A method for managing a data table of an entertainment venue, comprising the steps of: the method comprises the following steps:

step S10, setting data source parameters for acquiring operation data of the entertainment place;

step S20, creating a plurality of data models based on the data source parameters;

step S30, combining the data models to create a plurality of data sets;

s40, adding the data set fields in each data set into an editing area through a drag-and-drop interaction mode, automatically typesetting to generate a data table, editing the generated data table, and storing the edited data table;

s50, inquiring the data table based on the screening field, the reject field, the time period or the operator, and generating and storing the data table as a new data table;

and step S60, encrypting the new data table, generating an access link of the encrypted new data table, and sharing the new data table based on the access link.

2. A method of casino data table management as claimed in claim 1, wherein: in the step S10, the data source parameter includes at least a source name, a database type, a database IP, a database port, a database name, a database user name, and a database password.

3. A method of casino data table management as claimed in claim 1, wherein: the step S20 specifically includes:

configuring model information, model fields and model relations through a visual interface, and further creating a plurality of data models;

the model information at least comprises data source parameters, classification, table names, labels, visible identifiers, ordering and updating time; the modulus model relation is a mapping relation between different data models.

4. A method of casino data table management as claimed in claim 1, wherein: the step S30 specifically includes:

configuring data set information, data set fields and data set relations through a visual interface, and further creating a plurality of data sets;

the data set information at least comprises a title, a state, first page information, data set classification, data set type, a data model, a combination condition of the data model, grouping of the data model and a grouping condition of the data model; the data set relation is a mapping relation between different data sets.

5. A method of casino data table management as claimed in claim 1, wherein: the step S40 specifically includes:

the method comprises the steps of adding data set fields in data sets into an editing area in a dragging interaction mode, automatically merging and typesetting the data set fields of the data sets with mapping relations into a data table, and respectively generating the data table by taking the data sets as groups for the data set fields of the data sets without mapping relations;

and creating columns, modifying columns, deleting columns, freezing, grouping subtotals, summarizing statistics, hiding the columns or canceling all hidden editing on the generated data table, and storing the edited data table based on a received storage instruction.

6. A casino data sheet management system, characterized by: the device comprises the following modules:

the data source parameter setting module is used for setting data source parameters for acquiring the operation data of the entertainment place;

the data model creation module is used for creating a plurality of data models based on the data source parameters;

a data set creation module for combining the data models to create a plurality of data sets;

the data table generation module is used for adding the data set fields in each data set into the editing area through a drag interaction mode, automatically typesetting and generating a data table, editing the generated data table and storing the edited data table;

the data table query module is used for querying the data table based on the screening field, the eliminating field, the time period or the operator, and generating and storing the data table as a new data table;

and the data new table sharing module is used for encrypting the data new table, generating an access link of the encrypted data new table, and sharing the data new table based on the access link.

7. The casino data sheet management system as recited in claim 6, wherein: in the data source parameter setting module, the data source parameter at least comprises a source name, a database type, a database IP, a database port, a database name, a database user name and a database password.

8. The casino data sheet management system as recited in claim 6, wherein: the data model creation module is specifically configured to:

configuring model information, model fields and model relations through a visual interface, and further creating a plurality of data models;

the model information at least comprises data source parameters, classification, table names, labels, visible identifiers, ordering and updating time; the modulus model relation is a mapping relation between different data models.

9. The casino data sheet management system as recited in claim 6, wherein: the data set creation module is specifically configured to:

configuring data set information, data set fields and data set relations through a visual interface, and further creating a plurality of data sets;

the data set information at least comprises a title, a state, first page information, data set classification, data set type, a data model, a combination condition of the data model, grouping of the data model and a grouping condition of the data model; the data set relation is a mapping relation between different data sets.

10. The casino data sheet management system as recited in claim 6, wherein: the data table generation module is specifically configured to:

the method comprises the steps of adding data set fields in data sets into an editing area in a dragging interaction mode, automatically merging and typesetting the data set fields of the data sets with mapping relations into a data table, and respectively generating the data table by taking the data sets as groups for the data set fields of the data sets without mapping relations;

and creating columns, modifying columns, deleting columns, freezing, grouping subtotals, summarizing statistics, hiding the columns or canceling all hidden editing on the generated data table, and storing the edited data table based on a received storage instruction.