Mapping method and device for associating different organizations
By automatically setting mapping attributes when creating a department and forcibly specifying the mapping target, the problem of difficult department mapping relationships in the existing technology is solved, and the system is highly compatibility and flexibility in complex business scenarios are achieved.
Patent Information
- Application Number
- CN202510066617.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-01-16
- Publication Date
- 2025-04-29
AI Technical Summary
The prior art is difficult to effectively establish mapping relationships between departments in complex business scenarios, resulting in poor compatibility of the system when handling multi-department businesses.
By automatically setting the mapping attribute to true when creating a department and forcing the mapping target to specify the mapping target, the department that establishes the mapping relationship cannot be empty. Verification logic determines whether the mapping target is a manually created department, and whether the department code is valid and both belong to the same superior department. If the conditions are met, it will be saved to the database.
It realizes that new departments can establish relationships between mapping departments in complex business scenarios, and improves system compatibility and flexibility.
Smart Images
Figure CN119903061A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of information data technology, and in particular to a mapping method and device for associating different organizations. Background Art
[0002] With the development of the Internet, various operating systems have emerged to facilitate people's daily lives. However, in response to complex needs and business scenarios, the way a system is displayed and used in different scenarios will vary depending on the deployment environment.
[0003] In many management systems, departments are an indispensable part. However, there may be a situation where the departments used need to be personalized and these departments need to be connected with specific departments, which is equivalent to a one-to-many relationship. In this special case, it is necessary to establish a mapping relationship between departments.
[0004] The so-called department mapping relationship is to establish a connection between different department organizations, so that when one of the departments is used to handle business, the business can be linked to its department according to its mapping relationship, which facilitates the next step of business processing and greatly improves the system's compatibility with complex business systems.
[0005] Currently, most relationships between multiple departments are established through direct maintenance between departments. The processing logic only establishes relationships for departments, and the established mapping relationships are not applied to the business scenarios of the instances.
[0006] In order to solve the problem of establishing association relationships between departments in complex business scenarios, the present invention proposes a mapping method and device for associating different organizational structures. Summary of the invention
[0007] In order to make up for the defects of the prior art, the present invention provides a simple and efficient mapping method and device for associating different organizational structures.
[0008] The present invention is achieved through the following technical solutions:
[0009] A mapping method for associating different organizations includes the following steps:
[0010] Step S1, when creating a department, automatically set the mapping attribute to true, and forcibly specify the mapping target. The department to establish the mapping relationship cannot be empty to avoid the situation of null value;
[0011] Step S2: perform verification logic to determine whether the mapping target is a manually created department, and whether the department code is valid and both belong to the same superior department;
[0012] If the mapping target is a manually created department, the department code is valid and both belong to the same parent department, then it is saved to the database.
[0013] In step S2, the newly created department and the associated table are regarded as one transaction. After the newly created department is entered into the warehouse, the code of the newly created department and the code of the mapped department are entered into the intermediate table of the associated relationship. After the entry is successful, the transaction is terminated and a success response is returned.
[0014] The present invention is used for the mapping method of associating different organizations. After each successful operation, log information is recorded, including the department code and operator of the operation.
[0015] After the new department and related tables are successfully stored in the database, the log information will be stored in the log table.
[0016] In step S2, a MySQL relational database is used to add a field named 'mapping' in the organizational department table, whose value is true or false to mark whether the department participates in the mapping. The initial default value is false to be compatible with historical data;
[0017] Create an intermediate table in the MySQL relational database to store the mapping relationship, including the primary key information of the two departments, so as to maintain accurate records of the mapping.
[0018] A mapping device for associating different organizations, including a department creation module, a mapping management module and a database management module;
[0019] The department creation module is responsible for providing a department creation interface on the front end. When a department is manually created, a mapping list option is displayed on the creation page. The list option only displays other departments that share the same parent department and are at the same level as the created department, so as to reduce the complexity of the mapping configuration.
[0020] The mapping management module is responsible for displaying the relationship list of established mapping relationships, allowing managers to view and manage all established mapping relationships; it is also responsible for automatically setting the mapping attribute to true when creating a department, and forcing the specification of the mapping target. The department for establishing the mapping relationship cannot be empty to avoid the situation of null values; it performs verification logic to determine whether the mapping target is a manually created department, and whether the department code is valid and both belong to the same superior department; if the mapping target is not a manually created department, the department code is valid and both belong to the same superior department, it is saved to the database;
[0021] The database management module is responsible for treating the newly created department and the associated table as a transaction. After the newly created department is entered into the warehouse, the code of the newly created department and the code of the mapped department are entered into the intermediate table of the associated relationship. After the entry is successful, the transaction is ended and a success response is returned.
[0022] It also includes a log recording module, which is responsible for recording log information after each successful operation, including the department code and operator of the operation; and after the new department and related table are successfully stored in the database, the log information is stored in the log table.
[0023] The database management module adds a field named 'mapping' in the organizational department table of the MySQL relational database, whose value is true or false to mark whether the department participates in the mapping, and the initial default value is false to be compatible with historical data;
[0024] Create an intermediate table in the MySQL relational database to store the mapping relationship, including the primary key information of the two departments, so as to maintain accurate records of the mapping.
[0025] A mapping device for associating different organizations, characterized by comprising a memory and a processor; the memory is used to store a computer program, and the processor is used to implement the above method steps when executing the computer program.
[0026] A readable storage medium, characterized in that: a computer program is stored on the readable storage medium, and the computer program implements the above method steps when executed by a processor.
[0027] The beneficial effect of the present invention is that the mapping method and device for associating different organizational structures use the values of the fields based on the department source and whether to map to manage the mapping relationship between the newly created organization and the existing organization, so that the newly created department in the business scenario can also establish a mapping department relationship, greatly improving the convenience and flexibility of the system. BRIEF DESCRIPTION OF THE DRAWINGS
[0028] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0029] Attached Figure 1 It is a schematic diagram of a mapping method for associating different organizations according to the present invention. DETAILED DESCRIPTION
[0030] In order to enable those skilled in the art to better understand the technical solutions in the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.
[0031] The mapping method for associating different organizations includes the following steps:
[0032] Step S1, when creating a department, automatically set the mapping attribute to true, and forcibly specify the mapping target. The department to establish the mapping relationship cannot be empty to avoid the situation of null value;
[0033] Step S2: perform verification logic to determine whether the mapping target is a manually created department, and whether the department code is valid and both belong to the same superior department;
[0034] If the mapping target is a manually created department, the department code is valid and both belong to the same parent department, then it is saved to the database.
[0035] The storage of mapping relationships is handled as a transaction to ensure data consistency. That is, the transaction is completed only when the department and the mapping relationship are successfully stored in the database, otherwise the operation is rolled back.
[0036] In step S2, the newly created department and the associated table are regarded as one transaction. After the newly created department is entered into the warehouse, the code of the newly created department and the code of the mapped department are entered into the intermediate table of the associated relationship. After the entry is successful, the transaction is terminated and a success response is returned.
[0037] This mapping method used to associate different organizations records log information after each successful operation, including the department code and operator of the operation, providing valuable basis for subsequent auditing and troubleshooting;
[0038] After the new department and related tables are successfully stored in the database, the log information will be stored in the log table.
[0039] In step S2, a MySQL relational database is used to add a field named 'mapping' in the organizational department table, whose value is true or false to mark whether the department participates in the mapping. The initial default value is false to be compatible with historical data;
[0040] Create an intermediate table in the MySQL relational database to store the mapping relationship, including the primary key information of the two departments, so as to maintain accurate records of the mapping.
[0041] The mapping device for associating different organizations includes a department creation module, a mapping management module and a database management module;
[0042] The department creation module is responsible for providing a department creation interface on the front end. When a department is manually created, a mapping list option is displayed on the creation page, and the list content is accurately matched. Only other departments that share the same parent department and are at the same level as the created department are displayed in the list options to reduce the complexity of the mapping configuration.
[0043] The mapping management module is responsible for displaying the relationship list of established mapping relationships, allowing managers to view and manage all established mapping relationships; it is also responsible for automatically setting the mapping attribute to true when creating a department, and forcing the specification of the mapping target. The department for establishing the mapping relationship cannot be empty to avoid the situation of null values; it performs verification logic to determine whether the mapping target is a manually created department, and whether the department code is valid and both belong to the same superior department; if the mapping target is not a manually created department, the department code is valid and both belong to the same superior department, it is saved to the database;
[0044] The database management module is responsible for treating the newly created department and the associated table as a transaction. After the newly created department is entered into the warehouse, the code of the newly created department and the code of the mapped department are entered into the intermediate table of the associated relationship. After the entry is successful, the transaction is ended and a success response is returned.
[0045] It also includes a log recording module, which is responsible for recording log information after each successful operation, including the department code and operator of the operation; and after the new department and related table are successfully stored in the database, the log information is stored in the log table.
[0046] The database management module adds a field named 'mapping' in the organizational department table of the MySQL relational database, whose value is true or false to mark whether the department participates in the mapping, and the initial default value is false to be compatible with historical data;
[0047] Create an intermediate table in the MySQL relational database to store the mapping relationship, including the primary key information of the two departments, so as to maintain accurate records of the mapping.
[0048] The mapping device for associating different organizations includes a memory and a processor; the memory is used to store a computer program, and the processor is used to implement the above method steps when executing the computer program.
[0049] The readable storage medium stores a computer program, and when the computer program is executed by a processor, the above method steps are implemented.
[0050] The mapping method and device for associating different organizations adds a key attribute in the department information, which plays the role of a "switch". When it is set to true, it indicates that the department has the ability to establish a mapping relationship, otherwise it cannot be established. This design cleverly gives the mapping capability to the department. Especially when manually creating a department, the user can specify other departments associated with it through the newly added mapping relationship selection box. This step only appears in the manual creation process, ensuring the targeted operation.
[0051] The embodiment described above is only one specific implementation of the present invention. Common changes and substitutions made by those skilled in the art within the scope of the technical solution of the present invention should be included in the protection scope of the present invention.
Claims
1. A mapping method for associating different organizations, characterized in that: The following steps are involved: Step S1, when creating a department, automatically set the mapping attribute to true, and forcibly specify the mapping target. The department to establish the mapping relationship cannot be empty to avoid the situation of null value; Step S2: perform verification logic to determine whether the mapping target is a manually created department, and whether the department code is valid and both belong to the same superior department; If the mapping target is a manually created department, the department code is valid and both belong to the same parent department, then it is saved to the database.
2. The mapping method for associating different organizations according to claim 1, characterized in that: In step S2, the newly created department and the associated table are regarded as one transaction. After the newly created department is entered into the warehouse, the code of the newly created department and the code of the mapped department are entered into the intermediate table of the associated relationship. After the entry is successful, the transaction is terminated and a success response is returned.
3. The mapping method for associating different organizations according to claim 1 or 2, characterized in that: After each successful operation, log information is recorded, including the department code and operator of the operation; After the new department and related tables are successfully stored in the database, the log information will be stored in the log table.
4. The mapping method for associating different organizations according to claim 2, characterized in that: In step S2, a MySQL relational database is used to add a field named 'mapping' to the organizational department table. Its value is true or false, which marks whether the department participates in the mapping. The initial default value is false to be compatible with historical data. Create an intermediate table in the MySQL relational database to store the mapping relationship, including the primary key information of the two departments, so as to maintain accurate records of the mapping.
5. A mapping device for associating different organizations, characterized in that: Including department creation module, mapping management module and database management module; The department creation module is responsible for providing a department creation interface on the front end. When a department is manually created, a mapping list option is displayed on the creation page. The list option only displays other departments that share the same parent department and are at the same level as the created department, so as to reduce the complexity of the mapping configuration. The mapping management module is responsible for displaying the relationship list of established mapping relationships, allowing managers to view and manage all established mapping relationships; it is also responsible for automatically setting the mapping attribute to true when creating a department, and forcing the specification of the mapping target. The department for establishing the mapping relationship cannot be empty to avoid the situation of null values; it performs verification logic to determine whether the mapping target is a manually created department, and whether the department code is valid and both belong to the same superior department; if the mapping target is not a manually created department, the department code is valid and both belong to the same superior department, it is saved to the database; The database management module is responsible for treating the newly created department and the associated table as a transaction. After the newly created department is entered into the warehouse, the code of the newly created department and the code of the mapped department are entered into the intermediate table of the associated relationship. After the entry is successful, the transaction is ended and a success response is returned.
6. The mapping device for associating different organizations according to claim 5, characterized in that: It also includes a log recording module, which is responsible for recording log information after each successful operation, including the department code and operator of the operation; and after the new department and related table are successfully stored in the database, the log information is stored in the log table.
7. The mapping device for associating different organizations according to claim 5, characterized in that: The database management module adds a field named 'mapping' in the organizational department table of the MySQL relational database, whose value is true or false to mark whether the department participates in the mapping, and the initial default value is false to be compatible with historical data; Create an intermediate table in the MySQL relational database to store the mapping relationship, including the primary key information of the two departments, so as to maintain accurate records of the mapping.
8. A mapping device for associating different organizations, characterized in that: The method comprises a memory and a processor; the memory is used to store a computer program, and the processor is used to implement the method according to any one of claims 1 to 4 when executing the computer program.
9. A readable storage medium, characterized in that: The readable storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 4 is implemented.