RU23113U1 - SOFTWARE AND HARDWARE COMPLEX OF INFORMATION SUPPORT AND MAINTENANCE OF THE PROCESS OF COMPLETING LIBRARIES ACCORDING TO THE UNIFIED THEMATIC PLAN OF PUBLISHING BOOKS - Google Patents

Abstract

A hardware-software complex of information support and support for the process of completing libraries according to the consolidated thematic plan for the publication of books, containing a database of the availability of goods in the warehouse, a processing unit for applications, an accounting unit and a forwarding unit, characterized in that a database of a consolidated thematic publication plan is introduced books, an address database of customers, a database of applications and a database of publishers, which together with a database of the availability of goods in a warehouse, a database of the complex, as well as ok consolidated thematic plan, customer unit, first and second communication units with a telecommunication network, application processing unit, customer identification unit, unit for checking compliance with the integrated thematic plan and duplicate applications, customer notification unit, new customer registration unit, customer details request unit , the unit for charging the application, the unit for generating an invoice to the customer, the unit for postal communication, the unit for electronic settlement systems, the communication channel, the unit for checking the availability of books in the warehouse, the unit for generating an order payment to the publishing house, communication unit with publishing houses, unit for forming a warehouse order order, warehouse unit, accounting unit for warehousing, acquisition unit, unit for generating supporting documents for the customer, forwarding unit, data entry unit for received books and claims unit, first and second inputs of the customer unit connected to the outputs of the first communication unit with the telecommunications network and the customer notification unit, respectively, and the output is connected to the input of the application processing unit, the first output of which is connected to the first input of the unit

Description

The utility model relates to automated control systems for the process of production and sale of goods and can be used, in particular, in the distribution of books for vocational education institutions across the regions and the country as a whole.

Widely known distribution systems for various products in catalogs. The systems can be implemented both on the Internet with the order of goods according to the catalogs available on the websites of the virtual store, and according to traditional paper catalogs, money transfers through the bank and delivery of goods by mail, used for the past half century. Calculation can be carried out both by automated remote payment systems for selected goods through electronic wallets (see, for example, US Pat. No. 5,970,469, Scroggie et al., G06F 16/60, 10/19/1999) 1, and directly through a courier. In the latter case, the technology of such sale provides for the availability of a constantly updated catalog and delivery of this catalog to the consumer (in 1 this is done electronically), the consumer choosing the catalog of interest, placing an order, paying for this order and receiving the goods by mail or courier.

A known system for the formation and regular delivery to users of information publications (application RU 99119985 A, Sommers, G06F 17/30, 08/07/2001) 2. The system provides for a subscription to a personalized information publication, the selection of subject headings, forwarding to the publisher’s server, the formation of an updated topic profile, the generation of the issue and its delivery to the user. Collateral may be provided through the publisher’s website. The system allows the generation of headings and annotations, the calculation of fees, the interactive interaction of the subscriber with the publisher. For these purposes, there are routine elements of information MPK7: G06F 17/60, 153: 00

systems: user interfaces, publisher servers, databases, search server, information transfer channels. The system is intended only for electronic publications and does not allow working with traditional book products.

Systems 1,2 cannot be directly applied for staffing organizations and their libraries with educational and scientific literature.

The closest in technical essence is the automated trading system (see, for example, RU 2168761 C1, Kudryakov, G06F 17/60 // G06F 153: 00, 06/10/2001) 3. The customer’s request is generated in electronic form as an individual order form, while a certain number of individual order forms are generated, after which a summary sheet is generated in electronic form. Upon receipt of individual order forms and a summary sheet to the warehouse, the ordered goods are packaged in accordance with individual order forms and transported to the buyer. When delivering goods, they make cash settlements with the buyer and enter data on the receipt of funds and on goods delivered by the buyer on individual order forms in the control unit for the delivery of ordered goods and settlements with customers. Then these data are read into the accounting unit, designed to process information about profit and the required amount of replenishment of goods, send the processed information to the buffer memory, and a signal is generated for printing information on the paper about the consumed goods, the required quantity and assortment of goods for replenishment. System 3 is intended for the implementation of the trade project “home delivery service and the technical result is the delivery of already known brands of goods directly to the consumer through a courier with cash settlement, which can significantly reduce the cost of goods and speed up the process of customer service. However, the system does not make it possible to supply a specific product - book products in the collection of library funds.

The objective of the patented utility model is to create a software and hardware complex for information support and support of the process of completing libraries according to the consolidated thematic plan for publishing books.

The technical result of the utility model consists in improving the quality of the organization of wholesale trade in book literature according to the consolidated catalog of book publishing, reducing the time for meeting needs and ensuring timely financial settlements.

 Ley fj

The technical result is ensured by the fact that the hardware-software complex of information support and support of the process of completing libraries according to the consolidated thematic plan for the publication of books contains a database of the availability of goods in the warehouse, a processing unit for applications, an accounting unit, and a shipping unit. The complex includes a database of a comprehensive thematic plan for publishing books, an address database of customers, a database of applications and a database of publishers, which, together with a database of stock availability, a database of the complex, as well as a block of a thematic plan, a customer unit, the first and a second communication unit with a telecommunication network, an application processing unit, a customer identification unit, a unit for checking compliance with the consolidated thematic plan and identifying duplicate applications, a customer notification unit, a registration unit and a new customer, a requesting unit for customer details, a request charging unit, an invoice forming unit for a customer, a postal service unit, an electronic settlement system unit, a communication channel, a unit for checking the availability of books in a warehouse, an order form for a publisher, a unit for communicating with publishers, a unit the formation of a warehouse order-order, warehouse unit, accounting unit for warehousing, acquisition unit, unit for generating accompanying documents to the customer, forwarding unit, data entry unit for received books and claims unit.

The first and second inputs of the customer unit are connected to the outputs of the first communication unit with the telecommunications network and the customer notification unit, respectively, and the output is connected to the input of the application processing unit, the first output of which is connected to the first input of the unit for checking compliance with the consolidated thematic plan and identifying duplicate applications and the second output - with the input of the customer identification unit, the input-output of which is connected to the first output-input of the address database of customers.

The first output-input of the database of the consolidated thematic plan for the publication of books connected by its second output-input to the telecommunications network is connected through the unit of the thematic plan to the third input of the customer unit and to the second input-output of the unit for checking compliance with the consolidated thematic plan and to identify duplicate applications .

The first output of the customer identification unit is connected to the input of the registration unit of the new customer, and the second output is connected to the first input of the accounting unit and the second input of the application charging unit.

The first output of the unit for checking compliance with the consolidated thematic plan and the inclusion of duplicate applications is connected to the first input of the application charging unit, the second output to the first input of the customer notification unit, and the input-output to the first output-input of the application database, the second and third outputs the inputs of which are connected with the first input-output of the unit for checking the availability of books in the warehouse and, accordingly, the input-output of the customer notification unit, the second input of which is connected to the output of the postal service unit.

The third input of the application tariffing unit is connected to the first control output of the unit for checking the availability of books in the warehouse, and the output through the account generation unit to the customer is connected to the input of the postal service unit, the second input of the accounting unit and the input of the electronic payment system unit, the output of which is connected to the third input of the unit bz haulter accounting, the first input-output of which is connected to the communication channel, the second input-output - with the second output-input of the database of books in stock, the third input-output - with the second output-input of the form block order order to the publisher, and the fourth input-output - with the second output-input of the unit for forming the warehouse order-order, the first input-output of which is connected to the third output-input of the database of the availability of goods in the warehouse, and the output to the first input of the warehouse unit .

The first output-input of the database of the availability of goods in the warehouse is connected to the second input-output of the unit for checking the availability of books in the warehouse, the second control output of which is connected to the input of the unit forming the order-order to the publisher, connected by its first output to the input of the communication unit with the publishers, and the first input-output - to the output-input of the publishers database.

The first output of the warehouse unit through the storage accounting unit is connected to the input of the database of the availability of goods in the warehouse, and the second output of the warehouse unit is connected through the sequentially connected picking unit and the unit for generating supporting documents to the customer with the input of the forwarding unit, the output of which is connected to the corresponding input of the customer unit.

The output of the communication unit with the publishers, connected by its input-output to the second communication unit with the telecommunications network, is connected through the data entry unit for incoming books to the second input of the warehouse unit, the input-output of the new customer registration unit is connected to the second output-input of the address database of customers , and the output-input through the requesting details unit of the customer is connected with the first communication unit with a telecommunication network, the first and second inputs-outputs of the unit

.jC

claims are connected respectively to the output-input of the customer unit and to the fourth output-input of the application database.

The figure shows a structural diagram of the system.

The system contains a database (DB) 1 of the Consolidated thematic plan for the publication of books (STP), presented in electronic form on Web site 2 on the Internet, as well as on paper. DB 1 is connected via bus 3 with block 4 STP. Block 4 STP via bus 5 is connected to block 10 of the customer, which is connected to the telecommunication network 11 through block 12 for communication with the telecommunication network. Position 8 indicates the database of the complex.

The customer unit 10 is connected by a bus 13 to the application processing unit 14. The output 16 of block 14 is connected to the customer identification block 18, and its output via bus 20 is connected to one input of the STP compliance check unit 22 and to identify duplicate applications, and the other input of the block 22 via the 23 bus is connected to the STP block 4. One of the outputs of block 22 via bus 24 is connected to customer notification block 26, whose output via bus 28 is connected to customer block 10.

The customer identification unit 18 is connected via bus 30 to the address base of 34 customers. Block 18 is also connected via bus 35 to block 36 for introducing a new customer, also connected by bus 37 to address base 34. In addition, block 36 is connected by two-way communication with block 38 for requesting details of a customer with inputs / outputs for connecting to network 11. A corresponding bus 40, the address database 34 is connected to the customer notification unit 26.

On bus 42, block 22 checking for compliance with STP and identifying duplicate applications is connected to block 50 tariffication of the application and on bus 52 to the database 54 of these applications. Block 50 is also connected via a bus 56 to the output of block 18. The output of block 50 by bus 58 is connected to a customer billing unit 60, connected by bus 62 to a postal communication unit 64, an electronic settlement system unit 66, and an accounting unit 68. Block 68 has a communication channel 70 for interacting with bank 72. On the bus 74, the output of block 18 is also connected to block 68.

The complex includes a unit 76 for checking the availability of books in the warehouse, connected via bus 78 to the database of 54 applications and via bus 80 to the database 82 of the warehouse. Block 76 on bus 82 is also connected to one of the inputs of tariffication block 50, and on the other output on Ш1ше 84 - to the input of order-forming unit 86 to publishers. Block 86 is connected to the block 90 of the publisher, via bus 92 it is connected to the database 94 of the publisher, and on bus 96 it is connected to block 68 accountant 0,, (0 Г

sky accounting. The warehouse database 82 via bus 98 is connected to accounting unit 68. In addition, the OBD 82 is connected via bus 100 to the order-forming unit 102, one output of which is connected to block 68 via bus 104 and the other through bus 106 to automated storage unit 108.

Block 108 is connected via a bus 110 to a storage accounting block 112 connected by a warehouse OBD bus 114c and a bus 116 to a picking block 118.

One output of acquisition block 118 is connected via bus 120 to block 122 for generating accompanying documents to a customer. Block 90 is connected via bus 127 to block 128 for entering data on incoming books, connected via bus 130 to block 108. Block 90 is connected by two-way communication 91 through block 93 to telecommunications network 11.

Block 122 is connected via bus 124 to forwarding block 126. The output of block 126 is connected via bus 129 to block 10 of the customer, and the other through bus 130 to the database 54 applications. In addition, the complex has a claim block 132 connected to the bus 131 connected to a database of 54 applications, the input-output of which is connected with the customer block 10.

Dashed lines 150 show the flow of goods moving books.

The complex operates as follows.

Pre-formed STP 1 edition of books. It can be presented, for example, in the form of a “Consolidated annotated thematic plan for the publication of educational literature for institutions of higher, secondary and primary vocational education and have a format that meets OST 29.131-98“ Publishing and bookselling bibliographic information. General specifications based on the international standard MARK. STP is presented in the form of paper, electronic forms, as well as in the form of a publicly accessible Web site 2 on the Internet.

Block 4 STP carries out the distribution of STP through block 10 of the customer by post and electronic communications, for example, by e-mail, and also accepts applications. Next, the applications are transferred to block 14 processing applications. Regardless of the type of application medium (postal, telephone applications, applications by e-mail or through a website on the Internet), they are processed and recorded. In the customer identification unit 18, the presence of the customer details in the address database 34 is checked. If the details are present, then these data are read in block 18 from the address database 34. If the application was received from

of the new customer, the unit 38 for registering a new customer is connected, having communication with the block 39 for requesting details of the new customer, if there are not enough of them in the received application. These details include the address of the consignee, legal address, TIN, OKPO, OKONKH, bank details, etc.

At the same time, in block 22 of the STP compliance check and the identification of duplicate applications, the availability of the ordered literature in the STP DB 1 is compared. In the presence of the ordered literature in the STP through block 26, a notification of the customer about the receipt of the order is formed. At the same time, a duplication of the application is checked. This situation can be observed when receiving the same application through different communication channels (for example, by e-mail and regular mail). To avoid a situation in which such an application can be interpreted as two different applications, an analysis is carried out: dates, item numbers and other order parameters are compared. The analysis avoids the introduction of a duplicate order.

Next, in block 50, tariffing of applications is carried out. Forwarding services are calculated taking into account the markup for each individual book, the determination of the postal rate or the cost of other types of delivery, as well as the calculation of the total cost of the order. Further, information about the total cost of the order is sent to block 60 of the formation of the advance invoice to the customer. In block 50, differentiation is carried out for domestic and foreign customers. For foreign customers, customs and other documentation is additionally generated.

The formed advance accounts are transferred to the postal communication unit 64, the electronic settlement system block 66 and the accounting unit 68 for sending to the customer and accounting the funds received from the customer.

Further, several options for the functioning of the system are possible:

A. Books are available at warehouse 108, as evidenced by the information in the database 82 of the warehouse after checking by block 76 and their quantity is sufficient to satisfy the application. In block 68 there is information about the balances from the previous order.

In this case, block 68 gives permission to block 102 to create an order for block 108 of the automated warehouse for completing work on completing books by block 118, generating an invoice to the consumer, product report, payment register, invoice, and also internal documentation in block 122.

on the invoice and the corresponding consumer invoice. After completion of the paperwork and their printing, the packages are pre-packaged, invoices are inserted into them, the packages are transferred to the forwarding unit 126 by mail for delivery to the customer.

In block 68, funds are debited from the customer’s account card. The order is deemed completed.

If the books are self-delivered, the customer is informed by block 122 about the readiness of the order and the terms of self-delivery are specified. Here, the power of attorney is accepted from the customer, books are issued and the power of attorney is subsequently transferred to block 68 and information on the implementation of the order in the database of 54 applications.

B. Books not available from or not enough to complete the order. This information is checked by block 76 for checking the availability of books in the database 82 of the warehouse. In this case, the unit 86 of the formation of the order-order to the publisher (s) is included in the work, information about which is contained in the publisher's database 94.

In this case, the order form generated in block 86 is transmitted to the publisher in block 90 of the publisher, followed by transmission to the publishers electronically or by mail. Information about this is entered into the publisher’s database 94, and in block 68 of the accounting, accounting and control over the implementation of these order-orders are carried out according to the assigned serial numbers and dates.

Fulfillment of order-orders provides for the conclusion of contracts with publishers for the execution of applications for STP, the determination of pricing conditions with publishers (discounts) and book prices, with subsequent monitoring of the timing of the technological scheme.

When books are received from publishers through block 90 of the publisher, in block 128 for entering data on received books, information is entered on the assortment, quantity, price, weight, dimensions of books. The register of capitalized books is being formed and relevant data is being entered. These data are entered into the warehouse database 82 through the automated control system of the automated warehouse 108 and the storage accounting unit 112. In block 68 of the accounting are sent a commodity report and registers of capitalized books, publishing invoices and invoices.

Further, the technology does not differ from the final stage according to option A. Block 68 gives permission to block 102 to create an order-order to block 108 of the automated warehouse for picking books with block 118, generating an invoice to the consumer, product report, payment register, invoice, and also internal documentation in block 122.

Similarly, the books are prepared for sending books to the customer: their receipt from warehouse 108, the actual picking of parcels, printing of the invoice to the customer, checking the coincidence of the amounts on the invoice and the corresponding consumer invoice. After completion of the paperwork and their printing, the packages are pre-packaged, invoices are inserted into them, the packages are transferred to the forwarding unit 126 by mail for delivery to the customer.

In block 68, funds are debited from the customer’s account card and at that moment the order is deemed completed.

In that case, if the terms of the agreements with the publishers are not satisfied, they determine the names and number of books for return, prepare a return invoice, complete the parcel and transmit it as intended. This work is carried out in blocks 118, 122, 126.

For claim work use block 132, associated with the database of 54 applications. Upon receipt of the claim, block 132 records the substance of the claim in DB 54, and a decision is made to introduce a correction in the relationship with the customer. If the claim concerns the failure to satisfy the application in any part of it, then it is introduced as a new application in the part that concerns, for example, short delivery of books on the ordered assortment.

Industrial applicability. The hardware-software complex can be implemented using modern computer technology. The work of the complex can be organized in the form of a set of automated workplaces: “Workstation of manager of STP,“ Workstation of warehouse and others equipped with personal computers connected to the network. The system of accounting accounting can be organized using commercially available similar systems and aggregated into a patented complex. Databases can be run on professional servers, for example, a SUN server.

Claims (1)

A hardware-software complex of information support and support for the process of completing libraries according to the consolidated thematic plan for the publication of books, containing a database of the availability of goods in the warehouse, a processing unit for applications, an accounting unit and a forwarding unit, characterized in that a database of a consolidated thematic publication plan is introduced books, an address database of customers, a database of applications and a database of publishers, which together with a database of the availability of goods in a warehouse, a database of the complex, as well as ok consolidated thematic plan, customer unit, first and second communication units with a telecommunication network, application processing unit, customer identification unit, unit for checking compliance with the integrated thematic plan and duplicate applications, customer notification unit, new customer registration unit, customer details request unit , the unit for charging the application, the unit for generating an invoice to the customer, the unit for postal communications, the unit for electronic settlement systems, the communication channel, the unit for checking the availability of books in the warehouse, the unit for generating orders payment to the publishing house, communication unit with publishing houses, the unit for the formation of the warehouse order order, the warehouse unit, the accounting unit for warehousing, the picking unit, the unit for generating supporting documents for the customer, the forwarding unit, the data entry unit for incoming books and the claims unit, the first and second inputs of the customer unit connected to the outputs of the first communication unit with the telecommunications network and the customer notification unit, respectively, and the output is connected to the input of the application processing unit, the first output of which is connected to the first input of the unit check the compliance with the consolidated thematic plan and identify duplicate applications, and the second output is with the input of the customer identification unit, the input-output of which is connected to the first output-input of the address database of customers, the first output is the database of the consolidated thematic plan for publishing books connected through its second output-input with a telecommunication network, through the unit of the thematic summary plan is connected to the third input of the customer’s unit and with the second input-output of the unit for checking compliance with the consolidated thematic the plan and identify duplicate applications, the first output of the customer identification unit is connected to the input of the new customer registration unit, and the second output is connected to the first input of the accounting unit and the second input of the application charging unit, the first output of the unit for checking compliance with the consolidated thematic plan and the identification of duplicate applications is connected to the first input of the application charging unit, the second output to the first input of the customer notification unit, and the input-output to the first output-input of the application database, the second and third outputs-inputs of the cat swarm are connected with the first input-output of the unit for checking the availability of books in the warehouse and, accordingly, the input-output of the unit for notifying the customer, the second input of which is connected to the output of the postal unit, the third input of the charging unit of the application is connected to the first control output of the unit for checking the availability of books in the warehouse and the output through the invoice generation unit to the customer is connected with the input of the postal service unit, the second input of the accounting unit and the input of the electronic settlement system unit, the output of which is connected to the third input of the accounting unit tersky accounting, the first input-output of which is connected to the communication channel, the second input-output - with the second output-input of the database of books in stock, the third input-output - with the second output-input of the order-formation unit of the publishing house, and the fourth input -exit - with the second output-input of the unit for forming the warehouse order-order, the first input-output of which is connected to the third output-input of the warehouse stock database, and the output to the first input of the warehouse block, the first output is the stock database in stock connected to WTO the input-output of the unit for checking the availability of books in the warehouse, the second control output of which is connected to the input of the unit for creating an order-order to the publisher, connected with its first output to the input of the communication unit with the publishers, and the first input-output to the output-input of the publishers database, the first output of the warehouse unit through the storage accounting unit is connected to the database input of the availability of goods in the warehouse, and the second output of the warehouse unit is connected through the sequentially connected picking unit and the unit for generating supporting documents to the counter - with the input of the forwarding unit, the output of which is connected to the corresponding input of the customer unit, the output of the communication unit with publishers, connected with its input-output to the second unit of communication with the telecommunication network, through the data entry unit about incoming books is connected to the second input of the warehouse unit, the input - the output of the registration unit of the new customer is connected to the second output-input of the address database of customers, and the output-input through the requesting details block of the customer is connected to the first communication unit with telecommunication network, the first and second inputs-outputs of the claims block are connected respectively to the output-input of the customer’s block and to the fourth output-input of the claims database.