CN115578146A - Tray rental data management method and system, intelligent device and storage medium - Google Patents

Tray rental data management method and system, intelligent device and storage medium Download PDF

Info

Publication number
CN115578146A
CN115578146A CN202211151758.6A CN202211151758A CN115578146A CN 115578146 A CN115578146 A CN 115578146A CN 202211151758 A CN202211151758 A CN 202211151758A CN 115578146 A CN115578146 A CN 115578146A
Authority
CN
China
Prior art keywords
user
view
rental
data
character string
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202211151758.6A
Other languages
Chinese (zh)
Inventor
陈焕瑾
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Pallet Sharing Technology Co ltd
Original Assignee
Shenzhen Pallet Sharing Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shenzhen Pallet Sharing Technology Co ltd filed Critical Shenzhen Pallet Sharing Technology Co ltd
Priority to CN202211151758.6A priority Critical patent/CN115578146A/en
Publication of CN115578146A publication Critical patent/CN115578146A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/06—Buying, selling or leasing transactions
    • G06Q30/0645—Rental transactions; Leasing transactions
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G06F16/24558—Binary matching operations
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60—Protecting data
    • G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/083—Shipping
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Economics (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Development Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • General Business, Economics & Management (AREA)
  • Operations Research (AREA)
  • Human Resources & Organizations (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Engineering & Computer Science (AREA)
  • General Health & Medical Sciences (AREA)
  • Bioethics (AREA)
  • Computer Hardware Design (AREA)
  • Computer Security & Cryptography (AREA)
  • Software Systems (AREA)
  • Health & Medical Sciences (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The embodiment of the invention discloses a method, a system, intelligent equipment and a storage medium for managing tray rental data, wherein the method comprises the following steps: acquiring a user identifier of a current user and a database identifier of a currently accessed database, acquiring a client number list character string according to the user identifier and the database identifier, and storing the client number list character string to a session variable; establishing a custom function to obtain a client number list character string, cutting the client number list character string into a list view in a row form, establishing a data view aiming at a related data table in a current access database, associating the list view with the data view to obtain an associated view, and setting the related data table to be write-only and not read; acquiring the reference information input by the current user, acquiring result data from the associated view according to the reference information, and feeding back the result data to the current user. The invention can ensure effective isolation of data of the shared tray leasing system and ensure the confidentiality of data of users.

Description

Tray rental data management method and system, intelligent device and storage medium
Technical Field
The invention belongs to the technical field of environmental protection, and particularly relates to a method and a system for managing tray rental data, intelligent equipment and a storage medium.
Background
Often need use the tray in logistics company's work, put the commodity circulation goods on the tray, conveniently insert the tray with fork truck and transport the goods. Pallets are often transported with the logistics of goods. Therefore, the pallets rented by the upstream leasing users can be transported to the downstream leasing users along with the logistics goods, and the upstream leasing users and the downstream leasing users need to check the data of the pallets. However, in general, the SaaS system can only perform data isolation on a tray belonging to a certain rental user (for example, an upstream rental user), so that the downstream rental user cannot view the data of the tray, which causes great inconvenience to the rental and use of the tray of the downstream rental user.
Disclosure of Invention
In view of the above, it is necessary to provide a method, a system, an intelligent device and a storage medium for managing tray rental data, which enable all rental users associated with the tray to refer to the tray-related data and ensure the confidentiality of the tray-related data.
A method for managing tray rental data is applied to a shared tray rental system, wherein at least one rental user is registered in the shared tray rental system;
acquiring a user identifier of a current user and a database identifier of a currently accessed database, acquiring a client number list character string according to the user identifier and the database identifier, and storing the client number list character string to a session variable;
establishing a custom function to obtain the client number list character string, cutting the client number list character string into a list view in a row form, establishing a data view aiming at a related data table in the current access database, associating the list view with the data view to obtain an associated view, and setting the related data table to be write-only and read-not;
and acquiring the consulting information input by the current user, acquiring result data from the associated view according to the consulting information, and feeding back the result data to the current user.
When the current user is a downstream rental user with an upstream rental user, the step of establishing a data view for the relevant data table in the current access database and associating the list view with the data view comprises:
and acquiring authorization information of the upstream leasing user and the downstream leasing user, establishing a transfer-in side view based on the authorization information, limiting the transfer-in side view in a recording range of the local leasing user as a transfer-in side, and associating the list view with the transfer-in side view.
When the current user is an upstream rental user with a downstream rental user, the step of establishing a data view for a related data table in the currently accessed database and associating the list view with the data view includes:
and establishing a transferring party view based on the authorization information, wherein the transferring party view is limited in a recording range of the transferring party as a transferring party, and the list view is associated with the transferring party view.
Wherein the step of obtaining authorization information of the upstream rental user and the downstream rental user comprises:
acquiring roll-out information initiated by the upstream leasing user, wherein the roll-out information comprises at least one item of tray type, quantity, customer number information of the downstream leasing user, delivery contact way and transportation order number;
generating a user transfer record according to the transfer-out information, and marking the user transfer record as a record to be signed;
acquiring query information of the downstream leasing user, feeding back the transfer record to the downstream leasing client based on the query information, acquiring a confirmation sign-in message input by the downstream leasing user, and marking the transfer record as signed-in based on the confirmation sign-in message.
When the current user is a partner client, the step of obtaining the client number list character string according to the user identification and the database identification comprises the following steps:
acquiring the client number of the leasing user corresponding to the partner client, and generating the client number list character string based on the client number of the leasing user corresponding to the partner client;
when the current user is a tenant user of a partner client, the step of obtaining a client number list character string according to the user identifier and the database identifier includes:
and acquiring the client number of the tenant user, and generating the client number list character string based on the client number of the tenant user.
When the current user is a group headquarter user with a plurality of sub-warehouses, the step of obtaining the client number list character string according to the user identification and the database identification comprises the following steps:
acquiring the client number of each warehouse of the group headquarters user, and generating the client number list character string based on the client number of each warehouse;
when the current user is a sub-warehouse user of the group headquarters, the step of obtaining the client number list character string according to the user identification and the database identification comprises:
and acquiring the client number of the warehouse dividing user, and generating the client number list character string based on the client number of the warehouse dividing user.
When the current user is an authorized user of other rental users, the step of obtaining the client number list character string according to the user identifier and the database identifier includes:
and acquiring the authorization information of the other leasing users, wherein the authorization information comprises an authorization range, acquiring the client numbers of the other leasing users based on the authorization information, and generating the client number list character string based on the client numbers of the other leasing users.
A tray rental data management system is applied to a shared tray rental system, wherein at least one rental user is registered in the shared tray rental system;
the acquisition module is used for acquiring a user identifier of a current user and a database identifier of a currently accessed database, acquiring a client number list character string according to the user identifier and the database identifier, and storing the client number list character string to a session variable;
the view module is used for establishing a custom function to obtain the client number list character string, cutting the client number list character string into a list view in a row form, establishing a data view aiming at a related data table in the current access database, associating the list view with the data view to obtain an associated view, and setting the related data table to be write-only and not read-only;
and the feedback module is used for acquiring the consulting information input by the current user, acquiring result data from the associated view according to the consulting information and feeding back the result data to the current user.
A computer device comprising a memory and a processor, the memory storing a computer program which, when executed by the processor, causes the processor to carry out the steps as described above.
A computer-readable storage medium storing a computer program which, when executed by a processor, causes the processor to perform the steps as described above.
The embodiment of the invention has the following beneficial effects:
the method comprises the steps of obtaining a customer number list character string according to a user identifier and a database identifier, cutting the customer number list character string into a list view in a row form, establishing a data view aiming at a related data table in a currently accessed database, associating the list view with the data view, obtaining an associated view, and setting the related data table to be write-only and read-not, so that a user can only obtain related data of a renter who can be consulted in the database, but cannot consult other data, data isolation is effectively achieved, and the safety and confidentiality of renter data are ensured.
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, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Wherein:
FIG. 1 is a flowchart illustrating an embodiment of a method for managing rental data of a tray provided by the present invention;
FIG. 2 is a schematic structural diagram of an embodiment of a tray rental data management system provided by the present invention;
FIG. 3 is a block diagram of a computer device in one embodiment.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, fig. 1 is a flowchart illustrating a method for managing rental data of a tray according to an embodiment of the present invention. The method for managing the tray leasing data is applied to a shared tray leasing system, the shared tray leasing system comprises at least one leasing user, and an upstream-downstream relationship, a headquarter-bin relationship, a partner-tenant relationship and a one-way or two-way authorization permission relationship can exist among the at least one leasing user. According to the relationship between at least one rental user. And generating a tray leasing data isolation strategy of each leasing user based on the relation between at least one leasing user, and establishing a global isolation strategy manager. Different isolation policies can be established for each rental user for different databases of the shared tray rental system.
The tray rental data management method provided by the invention comprises the following steps:
s101: the method comprises the steps of obtaining a user identification of a current user and a database identification of a currently accessed database, obtaining a client number list character string according to the user identification and the database identification, and storing the client number list character string to a session variable.
In a specific implementation scenario, a user identifier of a current user and a database identifier of a currently accessed database are obtained, where the user identifier may be obtained when the current user logs in a shared tray rental system, and the currently accessed database may be obtained according to a user operation of the current user, for example, according to an instruction queried by the user. In this implementation scenario, the currently accessed database may be a pallet rental order database. The method comprises the steps of obtaining an isolation strategy of a current user in a currently accessed database according to a user identifier and a database identifier, obtaining a client number of at least one leasing user with access data authority of the current user based on the isolation strategy, generating a client number list character string according to the at least one client number, and storing the client number list character string into a session variable. After the user query is finished, the database session is finished, the session variable disappears, the client number list character string also disappears, and the safety and the confidentiality of user information are ensured.
S102: establishing a custom function to obtain a client number list character string, cutting the client number list character string into a list view in a row form, establishing a data view aiming at a related data table in a current access database, associating the list view with the data view, obtaining an associated view, and setting the related data table to be write-only and read-not.
In a specific implementation scenario, a custom function is established in a currently accessed database to obtain a client number list character string, and the client number list character string is cut into a list view in a row form according to each client number. And acquiring a related data table stored in a current access database, establishing a data view aiming at the related data table, associating the data view with the list view to acquire a related view, and screening out data corresponding to the list view in the data view, namely the related data of each client number corresponding to the client number list character string. And setting the relevant data table as write-only and read-not, so that the current user can not read the content of the relevant data table in the current access database and can only access the content in the associated view, and the current user can only read the relevant data of the renter user which can be accessed and is screened out through the steps and can not access the rest data in the current access database. The data in the shared tray rental system is effectively isolated, and the confidentiality and the safety of the data of each rental user are ensured.
S103: and acquiring the reference information input by the current user, acquiring result data from the associated view according to the reference information, and feeding back the result data to the current user.
In a specific implementation scenario, the reference information input by the current user is obtained, and the reference information may include a customer number of the rental user to be referred, a customer number of the reference information itself, customer numbers of other rental users, and at least one of a date, a tray model, and a region to be referred. And retrieving corresponding result data from the associated view according to the reference information, and feeding back the result data to the current user.
In other implementation scenarios, it is possible that the review information input by the current user does not have corresponding data in the associated view, for example, if the reviewed client number does not have corresponding content in the associated view, no review right is fed back to the current user, or the review content does not exist.
In this embodiment, the data ranges that the current user can access include: the related data of the user, the data managed by other leasing users by the current user, and the related data of the lessee under the name accessed by the current user as a partner are used as the related data of the transferring party or the transferring party of the transferring party.
In an implementation scenario, when a current user is a downstream rental user with an upstream rental user or when the current user is an upstream rental user with a downstream rental user, the upstream rental user and the downstream rental user both have reference rights to relevant data of the pallet, specifically, the upstream rental pallet loads the goods and hands over to a downstream rental behavior, the rental behavior of the upstream rental user is terminated when the user changes, the downstream rental user initiates a new rental behavior, the upstream rental user and the downstream rental user need to access part of data of the other party, the downstream rental user needs to inquire information of transfer time, place and the like of the upstream resistance user, and the upstream rental user also needs to inquire sign-in conditions of the downstream rental user. The transfer of the user can be divided into two types of transfer with agreement and transfer without agreement, a special transfer agreement is signed between the upstream leasing user and the downstream leasing user, and common contents comprise that when the transfer of the user is completed, the upstream leasing user helps the downstream leasing user to pay rent for a certain number of days in the future and the like. If there is no agreement, the transfer of the user only takes place the delivery of the subject matter, and the rent of both parties is settled with the platform according to their respective agreements.
In the implementation scenario, user transferring information of an upstream renting user and a downstream renting user needs to be obtained first, specifically, user transferring information initiated by the upstream renting user is obtained, and the user transferring information comprises at least one item of tray type, number, customer number information of the downstream renting user, delivery contact information and transport order number; generating a user transfer record according to the transfer-out information, and marking the user transfer record as a record to be signed; acquiring query information of a downstream leasing user, feeding back a transfer record to the downstream leasing user based on the query information, acquiring a confirmation sign-in message input by the downstream leasing user, and marking the transfer record as signed-in based on the confirmation sign-in message. And determining the identities of the upstream and downstream renters according to the roll-out information of the upstream renter and the confirmation sign-in information of the downstream renter.
When the current user is used as a downstream leasing user with an upstream leasing user, a transfer-in side view is established, the transfer-in side view is limited in the recording range of the user as a transfer-in side, and the list view is associated with the transfer-in side view, so that the downstream leasing user can only refer to data related to the transfer-in side and cannot refer to all data of the upstream leasing user. And when the current user is used as an upstream leasing user with a downstream leasing user, establishing a roll-out side view, limiting the roll-in side view within the record range of the user as the roll-out side, and associating the list view with the roll-in side view. Thus, the upstream rental user can only refer to the data associated with the forwarding party, and can refer to all data of the downstream rental user that cannot be referred to.
In one implementation scenario, partner customers may join their own trays to a common tray circulation pool while allowing partner customers to develop their own lessees and earn rent earnings. The partner client needs to check the lease, rent and other data of the lessee under the name, and the lessee under the name can only access the data of the lessee. When the current user is used as a partner client, the client number of the leasing user corresponding to the partner client is obtained, and the client number list character string is generated based on the client number of the leasing user corresponding to the partner client, so that the partner client can refer to the relevant data of the leasing user. When the current user is used as a lessee user of a partner client, the client number of the lessee user is obtained, and a client number list character string is generated based on the client number of the lessee user. The lessee user can only look up his own data.
In one implementation scenario, for large group customers, a common lease mode is to settle lease fees by taking a headquarters of a group as a settlement subject, but trays are transferred inside the group, and sub-warehouses have storage responsibility for the trays. When the current user is used as a group headquarter user with a plurality of bins, the client number of each bin of the group headquarter user is obtained, and the client number list character string is generated based on the client number of each bin. When the current user is used as a warehouse-dividing user of the group headquarter, the client number of the warehouse-dividing user is obtained, and the client number list character string is generated based on the client number of the warehouse-dividing user.
In one implementation scenario, a rental user with inconvenient operation authorizes the associated rental user to perform operation instead, when the current user is an authorized user of other rental users, authorization information of the other rental users is obtained, the authorization information comprises an authorization range, customer numbers of the other rental users are obtained based on the authorization information, and a customer number list character string is generated based on the customer numbers of the other rental users.
As can be seen from the above description, in this embodiment, the customer number list character string is obtained according to the user identifier and the database identifier, the customer number list character string is cut into a list view in a row form, a data view is established for a related data table in the currently accessed database, the list view is associated with the data view, an associated view is obtained, and the related data table is set to be write-only and read-not, so that the user can only obtain related data of a rental user that can be referred to in the database, but cannot refer to other data, data isolation is effectively achieved, and security and confidentiality of rental user data are ensured.
Referring to fig. 2, fig. 2 is a schematic structural diagram of a tray rental data management system according to an embodiment of the present invention. The tray rental data management system 10 is applied to a shared tray rental system, at least one rental user is registered in the shared tray rental system, and the method shown in fig. 1 can be implemented, and comprises the following steps: an acquisition module 11, a view module 12 and a feedback module 13.
The obtaining module 11 is configured to obtain a user identifier of a current user and a database identifier of a currently accessed database, obtain a client number list character string according to the user identifier and the database identifier, and store the client number list character string to a session variable; the view module 12 is configured to establish a custom function to obtain a client number list character string, cut the client number list character string into a list view in a row form, establish a data view for a related data table in a currently accessed database, associate the list view with the data view to obtain an associated view, and set the related data table to be write-only and read-not; the feedback module 13 is configured to obtain reference information input by the current user, obtain result data from the associated view according to the reference information, and feed back the result data to the current user.
FIG. 3 is a diagram that illustrates an internal structure of the computer device in one embodiment. The computer device may specifically be a terminal, and may also be a server. As shown in fig. 3, the computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the memory includes a non-volatile storage medium and an internal memory. The non-volatile storage medium of the computer device stores an operating system and may also store a computer program that, when executed by the processor, causes the processor to implement the age identification method. The internal memory may also have a computer program stored thereon that, when executed by the processor, causes the processor to perform the age identification method. Those skilled in the art will appreciate that the architecture shown in fig. 3 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is proposed, comprising a memory and a processor, the memory storing a computer program which, when executed by the processor, causes the processor to perform the steps as shown in fig. 1:
in an embodiment, a computer-readable storage medium is proposed, in which a computer program is stored which, when being executed by a processor, causes the processor to carry out the steps as shown in fig. 1.
Different from the prior art, the method and the device have the advantages that the client number list character string is obtained according to the user identification and the database identification, the client number list character string is cut into the list view in a row form, the data view is established aiming at the related data table in the current access database, the list view is associated with the data view, the related data of the renting user which can be consulted by the current user can be screened out, the related data table is set to be write-only and not read, the current user cannot consult other data in the database, data isolation is effectively realized, and the data security and confidentiality of the renting user are ensured.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a non-volatile computer-readable storage medium, and can include the processes of the embodiments of the methods described above when the program is executed. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. 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 a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), rambus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present application. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, and these are all within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.

Claims (10)

1. The method is characterized in that the method is applied to a shared tray rental system, and at least one rental user is registered in the shared tray rental system;
acquiring a user identifier of a current user and a database identifier of a currently accessed database, acquiring a client number list character string according to the user identifier and the database identifier, and storing the client number list character string to a session variable;
establishing a custom function to obtain the client number list character string, cutting the client number list character string into a list view in a row form, establishing a data view aiming at a related data table in the current access database, associating the list view with the data view to obtain an associated view, and setting the related data table to be write-only and read-not;
acquiring the consulting information input by the current user, acquiring result data from the associated view according to the consulting information, and feeding back the result data to the current user.
2. The method for managing the rental data on pallets of claim 1, wherein when the current user is a downstream rental user with an upstream rental user, the step of establishing a data view for the relevant data table in the currently accessed database, and associating the inventory view with the data view, comprises:
and acquiring the account transfer information of the upstream rental user and the downstream rental user, establishing a transfer-in side view based on the authorization information, limiting the transfer-in side view in the recording range of the party as a transfer-in party, and associating the list view with the transfer-in side view.
3. The method for managing the rental data on pallets of claim 2, wherein when the current user is an upstream rental user having a downstream rental user, the step of establishing a data view for the relevant data table in the currently accessed database, and associating the inventory view with the data view includes:
and establishing a transferring party view based on the authorization information, wherein the transferring party view is limited in a recording range of the transferring party as a transferring party, and the list view is associated with the transferring party view.
4. The method for managing the rental data of the pallets of claim 2, wherein the step of obtaining the authorization information of the upstream rental user and the downstream rental user comprises:
acquiring roll-out information initiated by the upstream rental user, wherein the roll-out information comprises at least one of tray type, number, customer number information of the downstream rental user, delivery contact information and transportation order number;
generating a user transfer record according to the transfer-out information, and marking the user transfer record as a record to be signed;
acquiring query information of the downstream leasing user, feeding back the transfer record to the downstream leasing client based on the query information, acquiring a confirmation sign-in message input by the downstream leasing user, and marking the transfer record as signed-in based on the confirmation sign-in message.
5. The method for managing tray rental data of claim 1, wherein the step of obtaining a customer number list string based on the user identification and the database identification when the current user is a partner customer comprises:
acquiring the client number of the leasing user corresponding to the partner client, and generating the client number list character string based on the client number of the leasing user corresponding to the partner client;
when the current user is a tenant user of a partner client, the step of obtaining the client number list character string according to the user identifier and the database identifier includes:
and acquiring the client number of the tenant user, and generating the client number list character string based on the client number of the tenant user.
6. The method for managing the tray rental data of claim 1, wherein the step of obtaining the customer number list character string according to the user identification and the database identification when the current user is a corporate headquarters user with a plurality of bins comprises:
acquiring the client number of each warehouse of the group headquarters user, and generating the client number list character string based on the client number of each warehouse;
when the current user is used as a sub-warehouse user of the group headquarter, the step of obtaining the client number list character string according to the user identification and the database identification comprises the following steps:
and acquiring the client number of the warehouse dividing user, and generating the client number list character string based on the client number of the warehouse dividing user.
7. The method for managing the data of the tray rental of claim 1, wherein when the current user is an authorized user of other rental users, the step of obtaining the character string of the customer number list according to the user identification and the database identification comprises:
and acquiring the authorization information of the other leasing users, wherein the authorization information comprises an authorization range, acquiring the client numbers of the other leasing users based on the authorization information, and generating the client number list character string based on the client numbers of the other leasing users.
8. A tray rental data management system is characterized by being applied to a shared tray rental system, wherein at least one rental user is registered in the shared tray rental system;
the acquisition module is used for acquiring a user identifier of a current user and a database identifier of a currently accessed database, acquiring a client number list character string according to the user identifier and the database identifier, and storing the client number list character string to a session variable;
the view module is used for establishing a custom function to obtain the client number list character string, cutting the client number list character string into a list view in a row form, establishing a data view aiming at a related data table in the current access database, associating the list view with the data view to obtain an associated view, and setting the related data table to be write-only and not read-only;
and the feedback module is used for acquiring the reference information input by the current user, acquiring result data from the associated view according to the reference information, and feeding back the result data to the current user.
9. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, causes the processor to carry out the steps of the method according to any one of claims 1 to 7.
10. An intelligent device, comprising a memory and a processor, the memory storing a computer program that, when executed by the processor, causes the processor to perform the steps of the method of any one of claims 1 to 7.
CN202211151758.6A 2022-09-21 2022-09-21 Tray rental data management method and system, intelligent device and storage medium Pending CN115578146A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211151758.6A CN115578146A (en) 2022-09-21 2022-09-21 Tray rental data management method and system, intelligent device and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211151758.6A CN115578146A (en) 2022-09-21 2022-09-21 Tray rental data management method and system, intelligent device and storage medium

Publications (1)

Publication Number Publication Date
CN115578146A true CN115578146A (en) 2023-01-06

Family

ID=84582117

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211151758.6A Pending CN115578146A (en) 2022-09-21 2022-09-21 Tray rental data management method and system, intelligent device and storage medium

Country Status (1)

Country Link
CN (1) CN115578146A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115796387A (en) * 2023-01-29 2023-03-14 深圳市普拉托科技有限公司 Tray scheduling optimization method, device, equipment and storage medium

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115796387A (en) * 2023-01-29 2023-03-14 深圳市普拉托科技有限公司 Tray scheduling optimization method, device, equipment and storage medium

Similar Documents

Publication Publication Date Title
US11328347B2 (en) Rental asset processing for blockchain
US20200019923A1 (en) Perishable asset tracking for blockchain
US8200709B2 (en) Data model and applications
US8348160B2 (en) Enhancing discovery services in an EPC network
CN115578146A (en) Tray rental data management method and system, intelligent device and storage medium
BR102013007990A2 (en) System and method for providing immediate confirmation for shipping services
CN111260285A (en) Nuclear power station material receiving method and system and storage medium
Müller et al. HIDALS: A hybrid IoT-based decentralized application for logistics and supply chain management
Tsiulin et al. The role of port authority in new blockchain scenarios for maritime port management: the case of Denmark
CN117408592B (en) Block chain-based multi-mode intermodal one-system logistics tracing method and system
US20140101059A1 (en) Leasing method for lessees to exchange their shipping containers
Girrbach Corporate responsibility in the context of digitalization
CN112070590A (en) Supermarket tray sharing system
US7730046B2 (en) Nomination locking system and method
CN111967820A (en) Pallet management method and system based on block chain
Saldanha et al. Coping strategies for overcoming constrained supply chain technology: an exploratory study
Yuvraj et al. Implementation of Blockchain Technology in Supply Chain Management
Cron et al. Sales force strategy
JP2004178152A (en) Reservation managing method, device, system and program and recording medium with its program recorded and reservation work supporting method and system
CN115147126B (en) Freight customer service method and system
Cui et al. Design and implementation of logistics management system based on SSH technology
US20230401526A1 (en) Systems and methods for controlled data sharing in supply chains
Di Francesco et al. The forwarder planning problem in a two‐echelon network
WO2002008935A2 (en) Method, computer system and computer system network
CN110502904B (en) Authorization method and device for traceability data entry permission

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination