A pallet rental data management method, system, intelligent device, and storage medium

Abstract

This invention discloses a pallet rental data management method, system, intelligent device, and storage medium. The method includes: obtaining the user identifier of the current user and the database identifier of the currently accessed database; obtaining a customer number list string based on the user identifier and database identifier; saving the customer number list string to a session variable; establishing a custom function to obtain the customer number list string; splitting the customer number list string into a row-based list view; establishing a data view for the relevant data tables in the currently accessed database; associating the list view with the data view to obtain the associated view; setting the relevant data tables to write-only; obtaining the query information input by the current user; retrieving result data from the associated view based on the query information; and providing the result data back to the current user. This invention ensures effective isolation of data in the shared pallet rental system and guarantees the confidentiality of user data.

Description

TECHNICAL FIELD

[0001] The application belongs to the technical field of environmental protection, and particularly relates to a tray rental data management method and system, intelligent equipment and a storage medium. BACKGROUND

[0002] When working in a logistics company, trays are often used to place logistics goods on the tray for easy lifting of the tray by a forklift to transport the goods. The tray is often transported together with the logistics goods. Therefore, the tray rented by the upstream rental user will be transported to the downstream rental user along with the logistics goods, and both the upstream and downstream rental users need to view the data of the tray. However, the general SaaS system can only isolate the data of the tray to a certain rental user (for example, the upstream rental user), so the downstream rental user cannot view the data of the tray, which will greatly inconvenience the tray rental and use of the downstream rental user. SUMMARY

[0003] Therefore, it is necessary to propose a tray rental data management method and system, intelligent equipment and a storage medium to enable rental users related to the tray to view the data related to the tray and ensure the confidentiality of the data related to the tray.

[0004] A tray rental data management method is applied to a shared tray rental system, and at least one rental user is registered in the shared tray rental system;

[0005] Obtain the user identifier of the current user and the database identifier of the currently accessed database, obtain the customer number list string according to the user identifier and the database identifier, and save the customer number list string to a session variable;

[0006] Establish a custom function to obtain the customer number list string, cut the customer number list string into a list view in a row form, establish a data view for the related data table in the currently accessed database, associate the list view with the data view, obtain an associated view, and set the related data table as writable but not readable;

[0007] Obtain the viewing information input by the current user, obtain the result data from the associated view according to the viewing information, and feed back the result data to the current user.

[0008] When the current user is a downstream rental user with an upstream rental user, the step of establishing a data view for the related data table in the currently accessed database and associating the list view with the data view includes:

[0009] obtaining authorization information of the upstream leasing user and the downstream leasing user, establishing an incoming party view based on the authorization information, the incoming party view being limited to a record range in which the current party is an incoming party, and associating the list view with the incoming party view.

[0010] When the current user is an upstream leasing user having a downstream leasing user, the step of establishing a data view for a related data table in the current access database and associating the list view with the data view comprises:

[0011] establishing an outgoing party view based on the authorization information, the incoming party view being limited to a record range in which the current party is an outgoing party, and associating the list view with the outgoing party view.

[0012] The step of obtaining the authorization information of the upstream leasing user and the downstream leasing user comprises:

[0013] obtaining outgoing information initiated by the upstream leasing user, the outgoing information comprising at least one of a pallet type, a quantity, customer number information of the downstream leasing user, a delivery contact method, and a transportation number;

[0014] generating a transfer record according to the outgoing information, and marking the transfer record as pending receipt;

[0015] obtaining query information of the downstream leasing user, feeding back the transfer record to the downstream leasing client based on the query information, obtaining a confirmation receipt message input by the downstream leasing user, and marking the transfer record as received based on the confirmation receipt message.

[0016] When the current user is a partner client, the step of obtaining a customer number list string based on the user identifier and the database identifier comprises:

[0017] obtaining a customer number of a leasing user corresponding to the partner client, and generating the customer number list string based on the customer number of the leasing user corresponding to the partner client;

[0018] When the current user is a tenant user of a partner client, the step of obtaining a customer number list string based on the user identifier and the database identifier comprises:

[0019] obtaining a customer number of the tenant user itself, and generating the customer number list string based on the customer number of the tenant user itself.

[0020] When the current user is a group headquarters user having multiple sub-warehouses, the step of obtaining a customer number list string based on the user identifier and the database identifier comprises:

[0021] Obtain the customer ID of each of the branch warehouses of the group headquarters user, and generate a list string of customer IDs based on the customer IDs of each branch warehouse;

[0022] When the current user is a branch warehouse user of the group headquarters, the step of obtaining the customer number list string based on the user identifier and the database identifier includes:

[0023] Obtain the customer ID of the sub-warehouse user and generate a list string of customer IDs based on the customer ID of the sub-warehouse user.

[0024] Wherein, when the current user is an authorized user of another rental user, the step of obtaining the customer number list string based on the user identifier and the database identifier includes:

[0025] Obtain the authorization information of the other rental users, the authorization information including the scope of authorization, obtain the customer number of the other rental users based on the authorization information, and generate the customer number list string based on the customer number of the other rental users.

[0026] A pallet rental data management system is applied to a shared pallet rental system, wherein at least one rental user is registered in the shared pallet rental system;

[0027] The acquisition module is used to acquire the user identifier of the current user and the database identifier of the currently accessed database, acquire a customer number list string based on the user identifier and the database identifier, and save the customer number list string to a session variable;

[0028] The view module is used to create a custom function to obtain the customer number list string, split the customer number list string into a list view in row format, create a data view for the relevant data table in the currently accessed database, associate the list view with the data view to obtain the associated view, and set the relevant data table to write-only.

[0029] The feedback module is used to obtain the search information input by the current user, retrieve result data from the associated view based on the search information, and provide the result data back to the current user.

[0030] A computer device includes a memory and a processor, the memory storing a computer program that, when executed by the processor, causes the processor to perform the steps described above.

[0031] A computer-readable storage medium storing a computer program that, when executed by a processor, causes the processor to perform the steps described above.

[0032] The embodiments of the present invention have the following beneficial effects:

[0033] The customer number list string is obtained based on the user identifier and the database identifier. The customer number list string is then split into a list view in row format. A data view is created for the relevant data table in the currently accessed database. The list view is associated with the data view to obtain the associated view. The relevant data table is set to write-only and not read-only. As a result, the user can only access the relevant data of the rental user that he / she can view in the database, and cannot view other data. This effectively achieves data isolation and ensures the security and confidentiality of the rental user data. Attached Figure Description

[0034] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0035] in:

[0036] Figure 1 This is a flowchart illustrating an embodiment of the pallet rental data management method provided by the present invention;

[0037] Figure 2 This is a schematic diagram of an embodiment of the pallet rental data management system provided by the present invention;

[0038] Figure 3 This is a structural block diagram of a computer device in one embodiment. Detailed Implementation

[0039] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0040] Please see Figure 1 , Figure 1This is a flowchart illustrating an embodiment of the pallet rental data management method provided by the present invention. The pallet rental data management method provided by the present invention is applied to a shared pallet rental system, which includes at least one rental user. These users may have upstream / downstream relationships, headquarters / branch warehouse relationships, partner / lessee relationships, and one-way or two-way authorization / license relationships. Based on the relationships between the at least one rental user, a pallet rental data isolation strategy is generated for each rental user, and a global isolation strategy manager is established. Different isolation strategies can be established for each rental user for different databases within the shared pallet rental system.

[0041] The pallet rental data management method provided by this invention includes the following steps:

[0042] S101: Obtain the user ID of the current user and the database ID of the currently accessed database. Based on the user ID and the database ID, obtain the customer number list string and save the customer number list string to the session variable.

[0043] In a specific implementation scenario, the system obtains the user identifier of the current user and the database identifier of the currently accessed database. The user identifier can be obtained when the current user logs into the shared pallet rental system, and the currently accessed database can be obtained based on the current user's actions, such as a query command. In this implementation scenario, the currently accessed database could be the pallet rental order database. Based on the user identifier and database identifier, the system obtains the isolation policy for the current user in the currently accessed database. Based on the isolation policy, it obtains the customer IDs of at least one rental user with access permissions to the data. A customer ID list string is generated based on at least one customer ID and saved to a session variable. After the user's query ends, the database session terminates, the session variable disappears, and the customer ID list string also disappears, ensuring the security and confidentiality of user information.

[0044] S102: Create a custom function to obtain the customer number list string, split the customer number list string into a list view in row format, create a data view for the relevant data table in the currently accessed database, associate the list view with the data view, obtain the associated view, and set the relevant data table to write-only.

[0045] In a specific implementation scenario, a custom function is used to retrieve a list of customer IDs from the currently accessed database. This list is then split into rows for each customer ID. The relevant data tables stored in the database are retrieved, and data views are created for these tables. These data views are then linked to the list view to create a related view. This view allows filtering of the data in the data view to identify the data corresponding to the list view—that is, the data for each customer ID corresponding to the list string. The relevant data tables are set to write-only, preventing the current user from reading the contents of these tables in the currently accessed database. The user can only access the content in the related view, thus limiting their access to the data of the rental users they are authorized to access, as filtered through the above steps. This effectively isolates the data in the shared pallet rental system, ensuring the confidentiality and security of each rental user's data.

[0046] S103: Obtain the query information entered by the current user, retrieve the result data from the related view based on the query information, and return the result data to the current user.

[0047] In a specific implementation scenario, the system retrieves the query information input by the current user. This information may include the customer ID of the leasing user to be queried (which could be the user's own customer ID or that of another leasing user), and at least one of the following: the date to be queried, the pallet model, and the region. Based on the query information, the system retrieves the corresponding result data from the associated view and displays the result data back to the current user.

[0048] In other implementation scenarios, the information entered by the current user may not have corresponding data in the associated view. For example, if the customer number being searched does not have corresponding content in the associated view, then the current user will be notified that they do not have the right to search or that the search content does not exist.

[0049] In this embodiment, the data that the current user can access includes: their own data, data entrusted to them by other leasing users, data of the current user as a partner accessing the lessees under their name, and data of the transferor or transferee as the transferee.

[0050] In one implementation scenario, when the current user is a downstream leasing user with an upstream leasing user, or vice versa, both the upstream and downstream leasing users have access to the relevant data of the pallet. Specifically, when the upstream leasing user loads goods onto a pallet and transfers them to the downstream leasing user, the upstream leasing user's leasing activity is terminated upon the transfer, and the downstream leasing user initiates a new leasing activity. Upstream and downstream leasing users need to access some of each other's data. For example, the downstream leasing user needs to query the transfer time and location information of the upstream leasing user, and the upstream leasing user also needs to query the downstream leasing user's receipt status. Transfers can be divided into two types: those with an agreement and those without. Upstream and downstream leasing users may sign a special transfer agreement, which commonly includes provisions such as the upstream leasing user paying the rent for a certain number of future days on behalf of the downstream leasing user upon completion of the transfer. Transfers without an agreement only involve the delivery of the goods, and the rent for both parties is settled separately with the platform according to their respective agreements.

[0051] In this implementation scenario, it is necessary to first obtain the transfer information of upstream and downstream leasing users. Specifically, this involves obtaining the transfer information initiated by the upstream leasing user, which includes at least one of the following: pallet type, quantity, downstream leasing user's customer number, delivery contact information, and transit order number. A transfer record is generated based on the transfer information and marked as pending receipt. The system then obtains the query information from the downstream leasing user, sends the transfer record back to the downstream leasing customer based on the query information, obtains the confirmation message from the downstream leasing user, and marks the transfer record as received based on the confirmation message. Finally, the identities of the upstream and downstream leasing users are determined based on the transfer information from the upstream leasing user and the confirmation message from the downstream leasing user.

[0052] When the current user is a downstream leasing user with upstream leasing users, a transfer-in view is created. This view is limited to the records where the user is a transfer-in. The list view is linked to the transfer-in view, so the downstream leasing user can only view data related to the transfer-in and cannot view all data of the upstream leasing user. When the current user is an upstream leasing user with downstream leasing users, a transfer-out view is created. This view is limited to the records where the user is a transfer-out and is linked to the transfer-in view. Therefore, the upstream leasing user can only view data related to the transfer-out and can view data of downstream leasing users, but cannot view all data of the downstream leasing user.

[0053] In one implementation scenario, partner clients can add their own pallets to a shared pallet circulation pool, while also developing their own tenants and earning rental income. Therefore, partner clients need to view rental and rent data for their tenants, while their tenants can only access their own data. When the current user is a partner client, the client obtains the customer ID of the corresponding rental user, and generates a list of customer IDs based on this ID, allowing the partner client to view the rental user's data. When the current user is a tenant user of a partner client, the tenant obtains their own customer ID, and generates a list of customer IDs based on this ID. Tenants can only view their own data.

[0054] In one implementation scenario, for large corporate clients, the common leasing method involves the group's headquarters settling leasing fees. However, within the group, pallets may be transferred, with branch warehouses responsible for their safekeeping. In this case, the group headquarters user needs to view the receipt and safekeeping status of the branch warehouse users, while branch warehouse users can only view their own data and cannot view the data of the group headquarters user or other branch warehouse users. When the current user is a group headquarters user with multiple branch warehouses, the system retrieves the customer ID of each branch warehouse and generates a customer ID list string based on each branch warehouse's customer ID. When the current user is a branch warehouse user of the group headquarters, the system retrieves the branch warehouse user's own customer ID and generates a customer ID list string based on the branch warehouse user's own customer ID.

[0055] In one implementation scenario, some leasing users who have difficulty performing certain operations authorize their associated leasing users to perform operations on their behalf. When the current user is an authorized user of another leasing user, the authorization information of the other leasing user is obtained. The authorization information includes the scope of authorization. Based on the authorization information, the customer number of the other leasing user is obtained, and a list string of customer numbers is generated based on the customer number of the other leasing user.

[0056] As described above, in this embodiment, the customer number list string is obtained based on the user identifier and the database identifier. The customer number list string is then cut into a list view in row format. A data view is established for the relevant data table in the currently accessed database. The list view is associated with the data view to obtain the associated view. The relevant data table is set to write-only and not read-only. Thus, the user can only access the relevant data of the rental user that he / she can view in the database, and cannot view other data. This effectively achieves data isolation and ensures the security and confidentiality of the rental user data.

[0057] Please see Figure 2 , Figure 2This is a schematic diagram of an embodiment of the pallet rental data management system provided by the present invention. The pallet rental data management system 10 includes components applied to a shared pallet rental system, in which at least one rental user is registered, and is capable of achieving… Figure 1 The method shown includes: an acquisition module 11, a view module 12, and a feedback module 13.

[0058] The acquisition module 11 is used to acquire the user identifier of the current user and the database identifier of the currently accessed database, retrieve the customer number list string based on the user identifier and the database identifier, and save the customer number list string to a session variable; the view module 12 is used to create a custom function to retrieve the customer number list string, split the customer number list string into a list view in row format, create a data view for the relevant data table in the currently accessed database, associate the list view with the data view to obtain the associated view, and set the relevant data table to write-only; the feedback module 13 is used to acquire the query information entered by the current user, retrieve the result data from the associated view based on the query information, and provide the result data back to the current user.

[0059] Figure 3 An internal structural diagram of a computer device in one embodiment is shown. This computer device can specifically be a terminal or a server. Figure 3 As shown, the computer device includes a processor, memory, and a network interface connected via a system bus. The memory includes a non-volatile storage medium and internal memory. The non-volatile storage medium stores an operating system and may also store a computer program that, when executed by the processor, enables the processor to implement an age recognition method. The internal memory may also store a computer program that, when executed by the processor, enables the processor to implement the age recognition method. Those skilled in the art will understand that... Figure 3 The structure shown is merely a block diagram of a portion of the structure related to the present application and does not constitute a limitation on the computer device to which the present application is applied. Specific computer devices may include more or fewer components than those shown in the figure, or combine certain components, or have different component arrangements.

[0060] In one embodiment, a computer device is provided, including a memory and a processor, the memory storing a computer program that, when executed by the processor, causes the processor to perform actions such as... Figure 1 The steps shown are as follows:

[0061] In one embodiment, a computer-readable storage medium is provided storing a computer program that, when executed by a processor, causes the processor to perform the following actions: Figure 1 The steps are shown.

[0062] Unlike existing technologies, this invention obtains a customer number list string based on the user identifier and the database identifier, segments the customer number list string into a list view in row format, establishes a data view for the relevant data table in the currently accessed database, and associates the list view with the data view. This allows filtering out the relevant data of the rental users that the current user can view. By setting the relevant data table to write-only and not read-only, the current user cannot view other data in the database, effectively achieving data isolation and ensuring the data security and confidentiality of rental users.

[0063] Those skilled in the art will understand that all or part of the processes in the above embodiments can be implemented by a computer program instructing related hardware. The program can be stored in a non-volatile computer-readable storage medium, and when executed, it can include the processes of the embodiments described above. Any references to memory, storage, databases, or other media used in the embodiments provided in this application can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in various forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), dual data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link DRAM (SLDRAM), RAMbus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and RAMbus dynamic RAM (RDRAM), etc.

[0064] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0065] The embodiments described above are merely illustrative of several implementation methods of this application, and while the descriptions are specific and detailed, they should not be construed as limiting the scope of this patent application. It should be noted that those skilled in the art can make various modifications and improvements without departing from the concept of this application, and these all fall within the protection scope of this application. Therefore, the protection scope of this patent application should be determined by the appended claims.

Claims

1. A pallet lease data management method characterized by comprising: The application is applied to a shared pallet leasing system, at least one leasing user is registered in the shared pallet leasing system, and different isolation strategies are established for each leasing user; Obtaining a user identifier of a current user and a database identifier of a currently accessed database, obtaining an isolation strategy of the current user in the currently accessed database according to the user identifier and the database identifier, obtaining at least one customer number of a leasing user who has data access authority of the current user based on the isolation strategy, generating a customer number list string according to the at least one customer number, and saving the customer number list string to a session variable; Establishing a custom function to obtain the customer number list string, cutting the customer number list string into a list view in a row form, establishing a data view for a related data table in the currently accessed database, associating the list view with the data view, obtaining an associated view, and setting the related data table as writable but not readable; Obtaining review information input by the current user, obtaining result data from the associated view according to the review information, and feeding back the result data to the current user.

2. The tray lease data management method according to claim 1, characterized by, When the current user is a downstream leasing user with an upstream leasing user, the steps of establishing a data view for a related data table in the currently accessed database and associating the list view with the data view include: Obtaining transfer information of the upstream leasing user and the downstream leasing user, establishing a transfer-in party view based on authorization information, the transfer-in party view being limited to the record range of the party as the transfer-in party, and associating the list view with the transfer-in party view.

3. The pallet lease data management method according to claim 2, characterized by, When the current user is an upstream leasing user with a downstream leasing user, the steps of establishing a data view for a related data table in the currently accessed database and associating the list view with the data view include: Establishing a transfer-out party view based on the authorization information, the transfer-in party view being limited to the record range of the party as the transfer-out party, and associating the list view with the transfer-in party view.

4. The pallet lease data management method according to claim 2, characterized by, The step of obtaining authorization information of the upstream leasing user and the downstream leasing user includes: Obtaining transfer-out information initiated by the upstream leasing user, the transfer-out information including at least one of a pallet type, a quantity, customer number information of the downstream leasing user, a delivery contact method, and a transportation number; Generating a transfer record according to the transfer-out information, and marking the transfer record as to be signed for; Obtaining query information of the downstream leasing user, feeding back the transfer record to the downstream leasing client based on the query information, obtaining a confirmation signature message input by the downstream leasing user, and marking the transfer record as signed for based on the confirmation signature message.

5. The pallet lease data management method of claim 1, wherein, When the current user is a partner client, the step of obtaining a customer number list string according to the user identifier and the database identifier includes: Obtaining a customer number of a leasing user corresponding to the partner client, and generating the customer number list string based on the customer number of the leasing user corresponding to the partner client; When the current user is a partner client's tenant user, the step of obtaining a client number list string according to the user identification and the database identification comprises: obtaining the client number of the tenant user itself, and generating the client number list string based on the client number of the tenant user itself.

6. The pallet lease data management method of claim 1, wherein, When the current user is a group headquarters user with multiple branches, the step of obtaining a client number list string according to the user identification and the database identification comprises: obtaining the client number of each branch of the group headquarters user, and generating the client number list string based on the client number of each branch; When the current user is a branch user of the group headquarters, the step of obtaining a client number list string according to the user identification and the database identification comprises: obtaining the client number of the branch user itself, and generating the client number list string based on the client number of the branch user itself.

7. The pallet lease data management method of claim 1, wherein, When the current user is an authorized user of other tenant users, the step of obtaining a client number list string according to the user identification and the database identification comprises: obtaining the authorization information of the other tenant users, the authorization information comprising an authorization range, obtaining the client number of the other tenant users based on the authorization information, and generating the client number list string based on the client number of the other tenant users.

8. A pallet lease data management system characterized by, The shared pallet leasing system comprises at least one tenant user, and different isolation strategies are established for each tenant user. An obtaining module is configured to obtain the user identification of a current user and the database identification of a currently accessed database, obtain the isolation strategy of the current user in the currently accessed database according to the user identification and the database identification, obtain the client number of at least one tenant user having data access authority of the current user based on the isolation strategy, generate a client number list string according to the at least one client number, and save the client number list string to a session variable. A view module is configured to establish a custom function to obtain the client number list string, cut the client number list string into a list view in a row form, establish a data view for a related data table in the currently accessed database, associate the list view and the data view to obtain an associated view, and set the related data table as writable but not readable. A feedback module is configured to obtain the review information input by the current user, obtain result data from the associated view according to the review information, and feed back the result data to the current user.

9. A computer-readable storage medium, characterized in that, A computer program is stored in a storage, and the computer program is executed by a processor to make the processor execute the steps of the method according to any one of claims 1 to 7.

10. A smart device, comprising: A device comprises a memory and a processor, and the memory stores a computer program, which is executed by the processor to make the processor execute the steps of the method according to any one of claims 1 to 7.

Images