Purchase list generation method and device, electronic equipment and storage medium

Abstract

The invention discloses a purchase list generation method and device, electronic equipment and a storage medium, and is applied to an auxiliary system of a Tiptop system.The method comprises the steps that purchase manuscript detail data are obtained, and the purchase manuscript detail data are integrated based on a parameter format suitable for calling a purchase list generation interface; constructing a purchase list generation request based on the integrated purchase manuscript detail data, and sending the purchase list generation request to a purchase list generation interface; the purchase list generation interface inserts the integrated purchase manuscript detail data into a database, a purchase list generation program of the Tiptop system is called, and the purchase list generation program generates a purchase list based on the data in the database; and receiving a purchase list returned by the purchase list generation interface. According to the method, the purchase list can be generated only by calling the Tiptop system for one time, so that the frequency of directly accessing the database is reduced, the occupation of Tiptop system resources is reduced, and the generation efficiency of the purchase list is improved.

Description

Technical Field

[0001] The present application relates to the field of industrial production technology, and more specifically, to a method and device for generating a purchase list, an electronic device, and a storage medium. Background Art

[0002] In the related art, the database of the Tiptop system (an Internet-based production management system) is frequently accessed through JDBC (Java Database Connectivity) to insert or obtain data and generate a purchase list. However, since the database of the Tiptop system does not support connection pooling, such frequent access results in a long time consumption, low operating efficiency, and cannot be consistent with the Tiptop system transactions, which is prone to errors.

[0003] Therefore, how to improve the efficiency of generating a purchase list is a technical problem that needs to be solved by those skilled in the art. Summary of the invention

[0004] The purpose of the present application is to provide a method and device for generating a purchase list, an electronic device and a computer-readable storage medium, so as to improve the efficiency of generating a purchase list.

[0005] To achieve the above purpose, the present application provides a method for generating a purchase list, which is applied to an auxiliary system of the Tiptop system, and the method includes:

[0006] Acquire purchase draft detailed data, and integrate the purchase draft detailed data based on a parameter format suitable for calling a purchase list generation interface;

[0007] Constructing a purchase list generation request based on the integrated purchase draft detail data, and sending the purchase list generation request to the purchase list generation interface;

[0008] The purchase list generation interface inserts the integrated purchase draft detail data into a database, and the purchase list generation interface calls the purchase list generation program of the Tiptop system so that the purchase list generation program generates a purchase list based on the data in the database;

[0009] Receive the purchase list returned by the purchase list generation interface.

[0010] The step of constructing a purchase list generation request based on the integrated purchase manuscript detail data includes:

[0011] The hutool framework is used to construct an HTTPS request, the integrated purchase draft detail data is converted into JSON format and then encoded in Base64 format, and the encoded data is placed in the request body of the HTTPS request to obtain a purchase list generation request.

[0012] The purchase list generation interface inserts the integrated purchase draft detail data into the database, including:

[0013] The purchase list generation interface determines the corresponding address information according to the factory name in the integrated purchase draft detail data, and inserts the integrated purchase draft detail data and the identification information corresponding to the purchase list generation request into a database corresponding to the address information.

[0014] Before the purchase list generation interface inserts the integrated purchase manuscript detail data into the database, the purchase list generation interface further includes:

[0015] The purchase list generation interface verifies whether the integrated purchase draft detail data is empty;

[0016] If so, return an error;

[0017] If not, the step of entering the purchase list generation interface to determine the corresponding address information according to the factory name in the integrated purchase manuscript detail data.

[0018] The purchase list generation interface calls the purchase list generation program of the Tiptop system, including:

[0019] The purchase list generation interface determines the corresponding address information and login information according to the factory name in the integrated purchase draft detail data, establishes an SSH connection with the Tiptop system based on the address information, logs in to the Tiptop system using the login information based on the SSH connection, and calls the purchase list generation program of the Tiptop system based on the SSH connection.

[0020] Among them, the purchase list generation program queries the purchase detail data in the database according to the identification information, verifies whether the purchase detail data conforms to the preset purchase list generation logic and confirmation logic, and if so, generates a purchase list based on the purchase detail data, and updates the target field information in the database according to the execution result of the purchase list generation program.

[0021] Wherein, after the purchase list generation interface calls the purchase list generation program of the Tiptop system, it also includes:

[0022] After the purchase list generation program is executed, the purchase list generation interface queries the target column information in the database and returns the queried data to the auxiliary system;

[0023] Update the target field information in the purchase draft detail data according to the data returned by the purchase list generation interface.

[0024] To achieve the above purpose, the present application provides a purchase list generation device, which is applied to the auxiliary system of the Tiptop system, and the device includes:

[0025] An integration module, used for acquiring purchase draft detailed data, and integrating the purchase draft detailed data based on a parameter format suitable for calling a purchase list generation interface;

[0026] A construction module, used to construct a purchase list generation request based on the integrated purchase manuscript detail data, and send the purchase list generation request to the purchase list generation interface;

[0027] A calling module, used to insert the integrated purchase draft detail data into a database through the purchase list generation interface, and call the purchase list generation program of the Tiptop system through the purchase list generation interface, so that the purchase list generation program generates a purchase list based on the data in the database;

[0028] A receiving module is used to receive the purchase list returned by the purchase list generation interface.

[0029] To achieve the above objectives, the present application provides an electronic device, including:

[0030] Memory for storing computer programs;

[0031] A processor is used to implement the steps of the above-mentioned method for generating a purchase list when executing the computer program.

[0032] To achieve the above objectives, the present application provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of the above-mentioned method for generating a purchase list are implemented.

[0033] It can be seen from the above scheme that a purchase list generation method provided by the present application is applied to the auxiliary system of the Tiptop system, and the method includes: obtaining purchase draft detail data, integrating the purchase draft detail data based on a parameter format suitable for calling a purchase list generation interface; constructing a purchase list generation request based on the integrated purchase draft detail data, and sending the purchase list generation request to the purchase list generation interface; the purchase list generation interface inserts the integrated purchase draft detail data into a database, and the purchase list generation interface calls the purchase list generation program of the Tiptop system so that the purchase list generation program generates a purchase list based on the data in the database; and receiving the purchase list returned by the purchase list generation interface.

[0034] The purchase list generation method provided in this application adopts a modular design, and divides the interaction between the auxiliary system, the purchase list generation interface and the Tiptop system into independent modules, which significantly improves the flexibility and scalability of the system, so that each module can be upgraded, replaced and expanded independently. In addition, by calling the purchase list generation interface through the auxiliary system, and the purchase list generation interface then calling the purchase list generation program of the Tiptop system to generate the purchase list, it is realized that the purchase list can be generated by calling the Tiptop system only once, which greatly reduces the frequency of direct access to the database, thereby reducing the occupation of Tiptop system resources, improving the overall performance and stability of the system, and improving the generation efficiency of the purchase list. At the same time, the purchase list generation logic is concentrated on the Tiptop system, and the same purchase list generation program is called to ensure that the purchase list generated by the auxiliary system is highly consistent with the transaction of the Tiptop system, effectively avoiding errors and conflicts caused by inconsistent data. Finally, the purchase draft detailed data is integrated according to the parameter format of the purchase list generation interface, ensuring that the integrated data can be correctly understood and processed by the purchase list generation interface, further optimizing the generation process of the entire purchase list. The present application also discloses a purchase list generating device, an electronic device and a computer-readable storage medium, which can also achieve the above-mentioned technical effects.

[0035] It should be understood that the foregoing general description and the following detailed description are exemplary only and are not restrictive of the present application. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following is a brief introduction to the drawings required for use in the embodiments or the prior art descriptions. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work. The drawings are used to provide a further understanding of the present disclosure and constitute a part of the specification. Together with the following specific implementation methods, they are used to explain the present disclosure, but do not constitute a limitation to the present disclosure. In the drawings:

[0037] Figure 1 The present invention is a flowchart of a method for generating a purchase list according to an exemplary embodiment;

[0038] Figure 2 The present invention is a flowchart of another method for generating a purchase list according to an exemplary embodiment;

[0039] Figure 3 A schematic diagram of purchase manuscript detailed data according to an exemplary embodiment;

[0040] Figure 4 This is a schematic diagram showing a parameter format suitable for calling a purchase list generation interface according to an exemplary embodiment;

[0041] Figure 5 is a schematic diagram of an HTTPS request according to an exemplary embodiment;

[0042] Figure 6 is a schematic diagram of a generated purchase list according to an exemplary embodiment;

[0043] Figure 7 It is a structural diagram of a purchase list generating device according to an exemplary embodiment;

[0044] Figure 8 The figure is a structural diagram of an electronic device according to an exemplary embodiment. DETAILED DESCRIPTION

[0045] The technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in the field without making creative work are within the scope of protection of the present application. In addition, in the embodiments of the present application, "first", "second", etc. are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence.

[0046] The embodiment of the present application discloses a method for generating a purchase list, which can generate a purchase list by calling the Tiptop system only once, reducing the frequency of direct access to the database, thereby reducing the occupation of Tiptop system resources and improving the efficiency of generating the purchase list.

[0047] See also Figure 1 , according to an exemplary embodiment, a flowchart of a method for generating a purchase list is shown, such as Figure 1 As shown, including:

[0048] S101: Acquire purchase draft detailed data, and integrate the purchase draft detailed data based on a parameter format suitable for calling a purchase list generation interface;

[0049] The execution subject of this embodiment is the auxiliary system of the Tiptop system, which is an Internet-based production management system.

[0050] In this step, the auxiliary system can collect purchase draft detailed data through the input interface or other data sources. The purchase draft detailed data may include material number, supplier, quantity, price, etc. Then, the purchase draft detailed data is integrated according to the parameter format of the purchase list generation interface. The parameter format is the format set when the purchase list generation interface is developed. This process involves data integration and formatting to ensure that the integrated purchase draft detailed data can be correctly understood and processed by the purchase list generation interface.

[0051] S102: constructing a purchase list generation request based on the integrated purchase draft detail data, and sending the purchase list generation request to the purchase list generation interface;

[0052] In this step, the auxiliary system constructs a purchase list generation request based on the integrated purchase draft detailed data. The purchase list generation request complies with the specifications of the purchase list generation interface and contains the necessary information required to generate the purchase list, such as the integrated purchase draft detailed data. Then, the auxiliary system sends the purchase list generation request to the purchase list generation interface through a secure communication protocol, such as HTTPS (HyperText Transfer Protocol Secure).

[0053] As a feasible implementation method, the construction of a purchase list generation request based on the integrated purchase draft detail data includes: using the hutool framework to construct an HTTPS request, converting the integrated purchase draft detail data into JSON format and then encoding it in Base64 format, placing the encoded data in the request body of the HTTPS request, and obtaining a purchase list generation request.

[0054] In the specific implementation, the auxiliary system converts the integrated purchase draft detailed data into JSON (JavaScript Object Notation) format and encodes it in Base64. Then the auxiliary system uses the hutool framework to build an HTTPS request and uses the encoded data as the request body of the purchase list generation request.

[0055] S103: the purchase list generation interface inserts the integrated purchase draft detail data into a database, and the purchase list generation interface calls the purchase list generation program of the Tiptop system so that the purchase list generation program generates a purchase list based on the data in the database;

[0056] In this step, after receiving the purchase list generation request, the purchase list generation interface will insert the integrated purchase draft detail data into the database. Subsequently, the purchase list generation interface will call the purchase list generation program of the Tiptop system, which is used to generate the final purchase list using the data in the database.

[0057] As a preferred implementation, before the purchase list generation interface inserts the integrated purchase draft detail data into the database, it also includes: the purchase list generation interface verifies whether the integrated purchase draft detail data is empty; if so, returns an error; if not, enters the step of the purchase list generation interface determining the corresponding address information according to the factory name in the integrated purchase draft detail data.

[0058] In the specific implementation, after receiving the purchase list generation request, the purchase list generation interface will first check whether the data in the request body is empty. If the data is empty, the purchase list generation interface will return an error message to the auxiliary system to avoid further processing; if the data is not empty, the purchase list generation interface will continue to execute the subsequent steps, that is, determine the corresponding address information according to the factory name in the data, and insert the data into the corresponding database. This pre-verification step ensures that only valid data is processed and stored, improving the accuracy and efficiency of data processing.

[0059] As a feasible implementation method, the purchase list generation interface inserts the integrated purchase draft detail data into a database, including: the purchase list generation interface determines the corresponding address information based on the factory name in the integrated purchase draft detail data, and inserts the integrated purchase draft detail data and the identification information corresponding to the purchase list generation request into the database corresponding to the address information.

[0060] In a specific implementation, when the purchase list generation interface verifies that the integrated purchase draft detail data is not empty, it identifies the corresponding address information based on the factory name provided in the received data, and then inserts the integrated purchase draft detail data together with the unique identification information of the purchase list generation request into the database corresponding to the corresponding address information, thereby achieving effective data management and storage.

[0061] The purchase list generation interface will call the purchase list generation program only after receiving the data (including unique identification information) provided by the auxiliary system and putting it into the database. In order to ensure that the correct data is obtained when the purchase list generation program is executed, it is necessary to pass in the unique identifier when calling the purchase list generation program to ensure data accuracy.

[0062] As a feasible implementation method, the purchase list generation interface calls the purchase list generation program of the Tiptop system, including: the purchase list generation interface determines the corresponding address information and login information according to the factory name in the integrated purchase draft detail data, establishes an SSH connection with the Tiptop system based on the address information, logs in to the Tiptop system using the login information based on the SSH connection, and calls the purchase list generation program of the Tiptop system based on the SSH connection.

[0063] In the specific implementation, the purchase list generation interface first determines the corresponding address information and login information of the Tiptop system based on the factory name in the integrated purchase draft detail data. The login information may include the account and password of the Tiptop system. Then, the address information is used to establish an SSH (Secure Shell) connection with the Tiptop system, and the login information is used to log in to the Tiptop system. Finally, the purchase list generation program in the Tiptop system is called through this SSH connection to automatically generate a purchase list.

[0064] As a feasible implementation method, the purchase list generation program queries the purchase detail data in the database according to the identification information, verifies whether the purchase detail data conforms to the preset purchase list generation logic and confirmation logic, and if so, generates a purchase list based on the purchase detail data, and updates the target field information in the database according to the execution result of the purchase list generation program.

[0065] In the specific implementation, the purchase list generation program uses the identification information to retrieve the purchase detail data in the database and check whether the data meets the established generation and confirmation logic. If the data verification passes, the purchase list generation program will create a purchase list based on the queried purchase detail data, and update the relevant target column information in the database according to the results of the purchase list generation program execution. The target column information may include status, purchase order number, purchase item, remarks, etc., so as to ensure that the data in the database is synchronized with the latest purchase list status.

[0066] The purchase list generation and confirmation logic of the Tiptop system refers to a series of business rules and steps followed within the system when creating and confirming a purchase order. These logics ensure that the creation of purchase orders complies with the company's operating specifications and requirements, and involve the verification and processing of purchase data. Specifically, these logics include but are not limited to the following:

[0067] Part Number Verification: Checks whether the part number exists and is valid to ensure that the purchased items can be correctly identified and purchased.

[0068] Supplier verification: Confirm that the supplier exists and is valid to ensure that the purchase order can be correctly allocated and executed.

[0069] Time verification: Check whether the current time allows the generation of a purchase order.

[0070] Procurement model verification: According to different procurement models, verify different processes and conditions to ensure that the generation of purchase orders meets specific business needs.

[0071] Database query: Since the purchase order generation program of the Tiptop system is developed using 4GL (Fourth-Generation Language), which is adapted to the Informix database, the database query data can be directly called to verify the above logic.

[0072] Verifying whether the data conforms to this logic is mainly done by performing query and comparison operations in the database through 4GL programs. For example, check whether a specific material number or supplier exists in the database, or whether the current time is within the permitted purchasing time range. These checks ensure that only data that complies with corporate rules and requirements can be used to generate purchase orders, thereby maintaining data accuracy and the integrity of business processes. In this way, the Tiptop system can automatically process the generation and confirmation of purchase orders while ensuring the compliance and efficiency of business operations.

[0073] S104: Receive the purchase list returned by the purchase list generation interface.

[0074] In this step, after the purchase list generation program generates the purchase list, the generated purchase list is fed back to the auxiliary system through the purchase list generation interface.

[0075] As a preferred implementation, after the purchase list generation interface calls the purchase list generation program of the Tiptop system, it also includes: after the purchase list generation program is executed, the purchase list generation interface queries the target field information in the database and returns the queried data to the auxiliary system; and updates the target field information in the purchase draft detail data according to the data returned by the purchase list generation interface.

[0076] In the specific implementation, when the purchase list generation program of the Tiptop system is completed, the purchase list generation interface will query the target column information in the database, which may include key data such as the status of the purchase order, purchase order number, purchase item, etc. The queried data is then returned to the auxiliary system, which updates the target column information in the purchase draft detailed data based on the returned data to ensure the accuracy and latest status of the draft detailed data. This process not only improves the efficiency of data processing, but also enhances the consistency and accuracy of the data.

[0077] The purchase list generation method provided in the embodiment of the present application adopts a modular design, and divides the interaction between the auxiliary system, the purchase list generation interface and the Tiptop system into independent modules, which significantly improves the flexibility and scalability of the system, so that each module can be upgraded, replaced and expanded independently. In addition, by calling the purchase list generation interface through the auxiliary system, and the purchase list generation interface then calling the purchase list generation program of the Tiptop system to generate the purchase list, it is realized that the purchase list can be generated by calling the Tiptop system only once, which greatly reduces the frequency of direct access to the database, thereby reducing the occupation of Tiptop system resources, improving the overall performance and stability of the system, and improving the generation efficiency of the purchase list. At the same time, the purchase list generation logic is concentrated on the Tiptop system, and the same purchase list generation program is called to ensure that the purchase list generated by the auxiliary system is highly consistent with the transaction of the Tiptop system, effectively avoiding errors and conflicts caused by inconsistent data. Finally, the purchase draft detailed data is integrated according to the parameter format of the purchase list generation interface, ensuring that the integrated data can be correctly understood and processed by the purchase list generation interface, further optimizing the generation process of the entire purchase list.

[0078] The embodiment of the present application discloses a method for generating a purchase list. Compared with the previous embodiment, this embodiment further explains and optimizes the technical solution. Specifically:

[0079] See also Figure 2, a flowchart of another method for generating a purchase list according to an exemplary embodiment is shown, such as Figure 2 As shown, including:

[0080] S201: The auxiliary system obtains the purchase draft detailed data and integrates the purchase draft detailed data based on the parameter format suitable for calling the purchase list generation interface;

[0081] In this step, the auxiliary system collects detailed data of the purchase manuscript, which may include material number, supplier, quantity, price, etc. Figure 3 Then, the purchase draft details data is integrated according to the parameter format of the purchase list generation interface. The parameter format is the format set when the purchase list generation interface is developed. For example, Figure 4 shown.

[0082] S202: The auxiliary system constructs a purchase list generation request based on the integrated purchase document detail data, and sends the purchase list generation request to the purchase list generation interface;

[0083] In the specific implementation, the auxiliary system converts the integrated purchase draft detailed data into JSON format and encodes it in Base64. Then the auxiliary system uses the hutool framework to build an HTTPS request and uses the encoded data as the request body of the purchase list generation request. For example, an HTTPS request such as Figure 5 As shown, it includes serverID, plantName and dataInfo, serverID is the identification information of the purchase list generation interface, plantName is the name of the database of the Tiptop system, and dataInfo is the encoded data.

[0084] S203: The purchase list generation interface inserts the integrated purchase manuscript detail data and the identification information corresponding to the purchase list generation request into the database corresponding to the address information;

[0085] S204: The purchase list generation interface determines the corresponding address information and login information according to the factory name in the integrated purchase manuscript detail data, establishes an SSH connection with the Tiptop system based on the address information, logs in to the Tiptop system using the login information based on the SSH connection, and calls the purchase list generation program of the Tiptop system based on the SSH connection;

[0086] In this step, the purchase list generation interface first determines the corresponding address information and login information of the Tiptop system according to the factory name in the integrated purchase draft detail data. The login information may include the account and password of the Tiptop system. Then, the address information is used to establish an SSH connection with the Tiptop system, and the login information is used to log in to the Tiptop system:

[0087] LinuxShell lshell=new LinuxShell(tiptop,osuser,ospwd);

[0088] Among them, tiptop is the corresponding address information of the Tiptop system, osuser is the account of the Tiptop system, and ospwd is the password of the Tiptop system.

[0089] Call the purchase list generation program in the Tiptop system through SSH connection:

[0090] result= lshell.execute(cmd+“ ”+templant+“ ”+mapHead.get(“posmy”) +“ ”+billheadid);

[0091] Among them, cmd is the execution command of the purchase list generation program, template is the factory name, mapHead.get("posmy") is the type of the purchase list, and billheadid is the unique identification information.

[0092] S205: the purchase list generation program searches for purchase detail data in the database according to the identification information, verifies whether the purchase detail data conforms to the preset purchase list generation logic and confirmation logic, and if so, generates a purchase list based on the purchase detail data, and updates the target column information in the database according to the execution result of the purchase list generation program;

[0093] In this step, the purchase list generation program generates a purchase list, e.g. Figure 6 shown.

[0094] S206: The purchase list generation program returns the purchase list to the purchase list generation interface;

[0095] S207: The purchase list generation interface sends the purchase list to the auxiliary system;

[0096] S208: The purchase list generation interface queries the target column information in the database and returns the queried data to the auxiliary system;

[0097] S209: The auxiliary system updates the target column information in the purchase draft detailed data according to the data returned by the purchase list generation interface.

[0098] In the specific implementation, when the purchase list generation program of the Tiptop system is completed, the purchase list generation interface will query the target column information in the database and return it to the auxiliary system. The auxiliary system updates the target column information in the purchase draft detail data according to the data returned by the purchase list generation interface. The data returned by the purchase list generation interface is as follows:

[0099] {

[0100] "state":1,

[0101] "message": "ok",

[0102] "total":1,

[0103] "data":{

[0104] “pono”: “PNO=O00001”

[0105] }

[0106] }

[0107] A purchase list generating device provided in an embodiment of the present application is introduced below. The purchase list generating device described below and the purchase list generating method described above can be referenced to each other.

[0108] See also Figure 7 , according to an exemplary embodiment, a structural diagram of a purchase list generating device is shown, such as Figure 7 As shown, including:

[0109] An integration module 100 is used to obtain purchase draft detailed data and integrate the purchase draft detailed data based on a parameter format suitable for calling a purchase list generation interface;

[0110] A construction module 200 is used to construct a purchase list generation request based on the integrated purchase manuscript detail data, and send the purchase list generation request to the purchase list generation interface;

[0111] A calling module 300 is used to insert the integrated purchase draft detail data into the database through the purchase list generation interface, and call the purchase list generation program of the Tiptop system through the purchase list generation interface, so that the purchase list generation program generates a purchase list based on the data in the database;

[0112] The receiving module 400 is used to receive the purchase list returned by the purchase list generation interface.

[0113] The purchase list generation device provided by the present application adopts a modular design, and divides the interaction between the auxiliary system, the purchase list generation interface and the Tiptop system into independent modules, which significantly improves the flexibility and scalability of the system, so that each module can be upgraded, replaced and expanded independently. In addition, by calling the purchase list generation interface through the auxiliary system, and the purchase list generation interface then calling the purchase list generation program of the Tiptop system to generate the purchase list, it is realized that the purchase list can be generated by calling the Tiptop system only once, which greatly reduces the frequency of direct access to the database, thereby reducing the occupation of Tiptop system resources, improving the overall performance and stability of the system, and improving the generation efficiency of the purchase list. At the same time, the purchase list generation logic is concentrated on the Tiptop system, and the same purchase list generation program is called to ensure that the purchase list generated by the auxiliary system is highly consistent with the transaction of the Tiptop system, effectively avoiding errors and conflicts caused by inconsistent data. Finally, the purchase draft detailed data is integrated according to the parameter format of the purchase list generation interface, ensuring that the integrated data can be correctly understood and processed by the purchase list generation interface, further optimizing the generation process of the entire purchase list.

[0114] Based on the above embodiments, as a preferred implementation mode, the construction module 200 is specifically used to: use the hutool framework to build an HTTPS request, convert the integrated procurement draft detail data into JSON format and then encode it in Base64 format, and place the encoded data in the request body of the HTTPS request to obtain a procurement list generation request.

[0115] On the basis of the above embodiment, as a preferred implementation mode, the calling module 300 is specifically used to: determine the corresponding address information according to the factory name in the integrated purchase draft detail data through the purchase list generation interface, and insert the integrated purchase draft detail data and the identification information corresponding to the purchase list generation request into the database corresponding to the address information.

[0116] Based on the above embodiment, as a preferred implementation, it also includes:

[0117] The verification module is used to verify whether the integrated purchase draft detail data is empty through the purchase list generation interface; if so, an error is returned; if not, the workflow of the calling module 300 is executed.

[0118] On the basis of the above embodiments, as a preferred implementation mode, the calling module 300 is specifically used to: determine the corresponding address information and login information according to the factory name in the integrated procurement draft detail data through the procurement list generation interface, establish an SSH connection with the Tiptop system based on the address information, and log in to the Tiptop system using the login information based on the SSH connection, and call the procurement list generation program of the Tiptop system based on the SSH connection.

[0119] On the basis of the above embodiment, as a preferred implementation mode, the purchase list generation program queries the purchase detail data in the database according to the identification information, verifies whether the purchase detail data conforms to the preset purchase list generation logic and confirmation logic, and if so, generates a purchase list based on the purchase detail data, and updates the target field information in the database according to the execution result of the purchase list generation program.

[0120] Based on the above embodiment, as a preferred implementation, it also includes:

[0121] An update module is used to query the target field information in the database through the purchase list generation interface after the purchase list generation program is executed, and return the queried data to the auxiliary system; and update the target field information in the purchase draft detail data according to the data returned by the purchase list generation interface.

[0122] Regarding the device in the above embodiment, the specific manner in which each module performs operations has been described in detail in the embodiment of the method, and will not be elaborated here.

[0123] Based on the hardware implementation of the above program module, and in order to implement the method of the embodiment of the present application, the embodiment of the present application also provides an electronic device, Figure 8 FIG. 1 is a structural diagram of an electronic device according to an exemplary embodiment. Figure 8 As shown, the electronic equipment includes:

[0124] Communication interface 1, capable of exchanging information with other devices such as network devices;

[0125] The processor 2 is connected to the communication interface 1 to implement information exchange with other devices, and is used to execute the purchase list generation method provided by one or more technical solutions when running a computer program. The computer program is stored in the memory 3.

[0126] Of course, in actual application, the various components in the electronic device are coupled together through the bus system 4. It can be understood that the bus system 4 is used to realize the connection and communication between these components. In addition to the data bus, the bus system 4 also includes a power bus, a control bus and a status signal bus. However, for the sake of clarity, Figure 8 Various buses are labeled as bus system 4 .

[0127] The memory 3 in the embodiment of the present application is used to store various types of data to support the operation of the electronic device. Examples of such data include: any computer program used to operate on the electronic device.

[0128] It can be understood that the memory 3 can be a volatile memory or a non-volatile memory, and can also include both volatile and non-volatile memories. Among them, the non-volatile memory can be a read-only memory (ROM), a programmable read-only memory (PROM), an erasable programmable read-only memory (EPROM), an electrically erasable programmable read-only memory (EEPROM), a magnetic random access memory (FRAM), a flash memory, a magnetic surface memory, an optical disc, or a compact disc read-only memory (CD-ROM); the magnetic surface memory can be a disk memory or a tape memory. The volatile memory can be a random access memory (RAM), which is used as an external cache. By way of example and not limitation, many forms of RAM are available, such as static random access memory (SRAM), synchronous static random access memory (SSRAM), dynamic random access memory (DRAM), synchronous dynamic random access memory (SDRAM), double data rate synchronous dynamic random access memory (DDRSDRAM), enhanced synchronous dynamic random access memory (ESDRAM), synchronous link dynamic random access memory (SLDRAM, SyncLink Dynamic Random Access Memory), and direct RAMbus random access memory (DRRAM, Direct Rambus Random Access Memory).The memory 3 described in the embodiments of the present application is intended to include but is not limited to these and any other suitable types of memories.

[0129] The method disclosed in the above embodiment of the present application can be applied to the processor 2, or implemented by the processor 2. The processor 2 may be an integrated circuit chip with signal processing capabilities. In the implementation process, each step of the above method can be completed by the hardware integrated logic circuit in the processor 2 or the instruction in the form of software. The above processor 2 may be a general-purpose processor, a DSP, or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, etc. The processor 2 can implement or execute the methods, steps and logic block diagrams disclosed in the embodiments of the present application. The general-purpose processor may be a microprocessor or any conventional processor, etc. In combination with the steps of the method disclosed in the embodiment of the present application, it can be directly embodied as a hardware decoding processor to execute, or it can be executed by a combination of hardware and software modules in the decoding processor. The software module may be located in a storage medium, which is located in the memory 3, and the processor 2 reads the program in the memory 3 and completes the steps of the above method in combination with its hardware.

[0130] When the processor 2 executes the program, the corresponding processes in the various methods of the embodiments of the present application are implemented, which will not be repeated here for the sake of brevity.

[0131] In an exemplary embodiment, the present application also provides a storage medium, namely a computer storage medium, specifically a computer-readable storage medium, for example, a memory 3 storing a computer program, and the computer program can be executed by a processor 2 to complete the steps of the aforementioned method. The computer-readable storage medium can be a memory such as FRAM, ROM, PROM, EPROM, EEPROM, Flash Memory, magnetic surface storage, optical disk, CD-ROM, etc.

[0132] A person of ordinary skill in the art can understand that: all or part of the steps of implementing the above-mentioned method embodiment can be completed by hardware related to program instructions, and the aforementioned program can be stored in a computer-readable storage medium, which, when executed, executes the steps of the above-mentioned method embodiment; and the aforementioned storage medium includes: various media that can store program codes, such as mobile storage devices, ROM, RAM, disks or optical disks.

[0133] Alternatively, if the above-mentioned integrated unit of the present application is implemented in the form of a software function module and sold or used as an independent product, it can also be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the embodiment of the present application can essentially or in other words, the part that contributes to the prior art can be embodied in the form of a software product, which is stored in a storage medium and includes a number of instructions for an electronic device (which can be a personal computer, server, network device, etc.) to execute all or part of the methods described in each embodiment of the present application. The aforementioned storage medium includes: various media that can store program codes, such as mobile storage devices, ROM, RAM, magnetic disks or optical disks.

[0134] The above is only a specific implementation of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art who is familiar with the present technical field can easily think of changes or substitutions within the technical scope disclosed in the present application, which should be included in the protection scope of the present application. Therefore, the protection scope of the present application should be based on the protection scope of the claims.

Claims

1. A method for generating a purchase list, characterized in that: An auxiliary system applied to a Tiptop system, the method comprising: Acquire purchase draft detailed data, and integrate the purchase draft detailed data based on a parameter format suitable for calling a purchase list generation interface; Constructing a purchase list generation request based on the integrated purchase draft detail data, and sending the purchase list generation request to the purchase list generation interface; The purchase list generation interface inserts the integrated purchase draft detail data into a database, and the purchase list generation interface calls the purchase list generation program of the Tiptop system so that the purchase list generation program generates a purchase list based on the data in the database; Receive the purchase list returned by the purchase list generation interface.

2. The method for generating a purchase list according to claim 1, characterized in that: The step of constructing a purchase list generation request based on the integrated purchase manuscript detail data includes: The hutool framework is used to construct an HTTPS request, the integrated purchase draft detail data is converted into JSON format and then encoded in Base64 format, and the encoded data is placed in the request body of the HTTPS request to obtain a purchase list generation request.

3. The method for generating a purchase list according to claim 1, characterized in that: The purchase list generation interface inserts the integrated purchase manuscript detail data into the database, including: The purchase list generation interface determines the corresponding address information according to the factory name in the integrated purchase draft detail data, and inserts the integrated purchase draft detail data and the identification information corresponding to the purchase list generation request into a database corresponding to the address information.

4. The method for generating a purchase list according to claim 3, characterized in that: Before the purchase list generation interface inserts the integrated purchase manuscript detail data into the database, it also includes: The purchase list generation interface verifies whether the integrated purchase draft detail data is empty; If so, return an error; If not, the step of entering the purchase list generation interface to determine the corresponding address information according to the factory name in the integrated purchase manuscript detail data.

5. The method for generating a purchase list according to claim 1, characterized in that: The purchase list generation interface calls the purchase list generation program of the Tiptop system, including: The purchase list generation interface determines the corresponding address information and login information according to the factory name in the integrated purchase draft detail data, establishes an SSH connection with the Tiptop system based on the address information, logs in to the Tiptop system using the login information based on the SSH connection, and calls the purchase list generation program of the Tiptop system based on the SSH connection.

6. The method for generating a purchase list according to claim 3, characterized in that: The purchase list generation program queries the purchase detail data in the database according to the identification information, verifies whether the purchase detail data conforms to the preset purchase list generation logic and confirmation logic, and if so, generates a purchase list based on the purchase detail data, and updates the target field information in the database according to the execution result of the purchase list generation program.

7. The method for generating a purchase list according to claim 6, characterized in that: After the purchase list generation interface calls the purchase list generation program of the Tiptop system, it also includes: After the purchase list generation program is executed, the purchase list generation interface queries the target column information in the database and returns the queried data to the auxiliary system; Update the target field information in the purchase draft detail data according to the data returned by the purchase list generation interface.

8. A purchase list generating device, characterized in that: An auxiliary system applied to the Tiptop system, the device comprising: An integration module, used for acquiring purchase draft detailed data, and integrating the purchase draft detailed data based on a parameter format suitable for calling a purchase list generation interface; A construction module, used to construct a purchase list generation request based on the integrated purchase manuscript detail data, and send the purchase list generation request to the purchase list generation interface; A calling module, used to insert the integrated purchase draft detail data into a database through the purchase list generation interface, and call the purchase list generation program of the Tiptop system through the purchase list generation interface, so that the purchase list generation program generates a purchase list based on the data in the database; A receiving module is used to receive the purchase list returned by the purchase list generation interface.

9. An electronic device, characterized in that: include: Memory for storing computer programs; A processor, configured to implement the steps of the method for generating a purchase list as claimed in any one of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, which, when executed, implements the steps of the method for generating a purchase list according to any one of claims 1 to 7.

Images