Manufacturing method and equipment of handheld network medical insurance medicine selling process supervision device

Abstract

According to the handheld network medical insurance medicine selling process fine supervision device manufacturing method and equipment, a power module, a single-chip microcomputer system, a key switch, an embedded bar code two-dimensional code decoder, a network module, a TTS text-to-voice module and a loudspeaker are installed in a handheld shell, a computer, a displayer and a keyboard are not needed, and the handheld network medical insurance medicine selling process fine supervision device is convenient to use. The commodity codes and the traceability codes of the medicines are collected and submitted to the server, and meanwhile, real-time interception of repeated medicine selling is realized, so that the common problems of medicine replacement, false medicine selling, repeated medicine selling and reselling of medical insurance medicines in the field of medical insurance are solved.

Description

Technical Field

[0001] The present invention relates to a manufacturing method and equipment of a handheld network medical insurance drug sales process monitoring device that does not require a computer or a display and can directly cooperate with a server. The device effectively solves the problems of drug substitution, false drug sales, repeated drug sales, and reselling of medical insurance drugs by collecting and monitoring drug commodity codes and traceability codes. The device belongs to the field of medical insurance fund supervision and the field of electronic information. Background Art

[0002] In the field of medical insurance fund supervision, currently, supervision is mainly carried out through surprise inspections, checking of purchase and sales databases, video review and other technical methods. It is difficult to effectively discover and solve the problems of drug substitution, false drug sales, repeated drug sales, and reselling of medical insurance drugs. The device described in the present invention is a convenient handheld all-in-one device that can collect drug commodity codes and traceability codes and submit them directly to the server. No additional computer, keyboard, or display is required to achieve refined supervision of the sales process of medical insurance drugs. Compared with the existing technical means, its typical feature is that it supervises every box of drugs and intercepts repeated drug sales. It can also achieve comparison with the purchase and sales database, which has obvious novelty, creativity and practicality; the drug commodity code refers to a certain representative symbol to represent a certain (type) of medical commodity, with the characteristics of one product and one code, and one code for one product. Each code can only correspond to one coding object. This one-to-one correspondence must be followed in compiling any medical commodity catalog; the drug traceability code is also called a drug traceability code, which refers to the unique electronic identity number of a drug packaging unit, which is used to uniquely identify the drug sales packaging unit. Summary of the invention

[0003] The device of the present invention is composed of a single-chip microcomputer system, a key switch, an embedded barcode and two-dimensional code scanner, a WIFI network module, a TTS text-to-speech module, and a speaker. The above-mentioned electronic component module is installed in a handheld housing, and the key is exposed for the operator to press the key to scan the code. The operation result or submission, deletion and other operations can also be queried through the mobile phone APP host program or the computer host program. The single-chip microcomputer system refers to a basic application system in which a single-chip microcontroller chip is externally connected to a power module, a clock circuit, a reset circuit, a program download circuit, a power module, a capacitor, a resistor, and an EEPROM; the program download circuit is a circuit that can write the program download to the single-chip microcomputer, the barcode and two-dimensional code scanner refers to an electronic module that can scan and decode barcodes and two-dimensional codes of EAN-13 and CODE-128 protocols; the TTS text-to-speech module is an electronic module that can convert text into audio.

[0004] The equipment is manufactured, set up and the drug sales process of the medical institution is supervised according to the steps described below

[0005] -

[0023] .

[0005] The single-chip microcomputer system, key switch, embedded barcode and QR code scanner, network module, TTS text-to-speech module, and speaker are connected according to the interface specifications and installed in the handheld housing.

[0006] When the machine is turned on, it automatically initializes and starts the WIFI module, TTS text-to-speech module, and embedded barcode and QR code scanner.

[0007] Develop or provide a host computer setting program that can set the WIFI AP hotspot name, password, server IP address, server port, and code scanning method. The host computer setting program can be a web page, WeChat applet, Alipay applet, or mobile phone APP. The host computer program also supports logging in to the server to view the content and history of the orders being operated, and also supports deletion and submission actions for the orders being operated.

[0008] The upper computer setting program completes the configuration of the device according to the following steps: select or enter the WIFI AP hotspot name, password, server IP address, server port, and scanning method, and automatically generate a QR code containing this information. The device scans and identifies the QR code, sends instructions to the WIFI module according to the instruction format of the WIFI module, saves the WIFI AP hotspot name, password, server IP address, and server port information to the WIFI module, sends instructions to the embedded bar code QR code scanner according to the instruction format of the embedded bar code QR code scanner, and saves the scanning method to the embedded bar code QR code scanner. The scanning method includes key-triggered scanning, induction scanning, and continuous scanning. The key-triggered scanning refers to starting scanning when the operator presses a button, the induction scanning refers to automatic scanning when an obstacle is sensed in front, and the continuous scanning refers to continuous scanning of multiple bar codes or QR codes.

[0009] Restart the device, apply the parameters set by the host computer setting program, the WIFI module automatically connects to the set WIFI hotspot network, and the embedded barcode and QR code scanner module takes effect of the set scanning method.

[0010] The device is connected to the target server according to the configured server IP address and server port.

[0011] The device sends the unique ID of the microcontroller system MCU to the server. The server records the ID and queries the database for the drug sales agency information corresponding to the ID. If the ID does not exist in the database, a new device ID information is recorded to remind the management personnel to bind the specific drug sales agency with the ID. The management personnel can bind the specific drug sales agency with the device ID to realize the correspondence between the device ID and the drug sales agency. Each time the device submits information to the server, the device ID is automatically attached to the submitted information.

[0012] The product code side of the drug is facing the embedded barcode QR code scanner, and the single-chip computer system drives the embedded barcode QR code scanner to scan and identify the product code of the drug. When the first product code is scanned, an order is automatically created. The scanning method is to scan and decode according to the scanning mode set by the host computer setting program.

[0013] The collected product codes are automatically submitted and cached to the server. The server returns the result of whether the operation is successful and the number of product codes included in the current order. If the collection is wrong or repeated, scan the deletion code to delete the content collected this time. The deletion code includes either barcode or QR code. The product code can also be deleted in the host computer program.

[0014] The single chip microcomputer system drives the TTS text-to-speech module and the speaker to play the prompt submission result and the total number of product codes in this order.

[0015] The drug product traceability code is placed facing the embedded barcode and two-dimensional code scanner, and the single-chip microcomputer system drives the embedded barcode and two-dimensional code scanner to scan and identify the drug traceability code.

[0016] The collected traceability code information is automatically submitted and cached to the server. The server returns the submission result and the total number of traceability codes in the current order to the device. The server verifies whether the traceability code has been sold. If there is no return record after the sale, it returns to the device that the traceability code drug is not allowed to be sold. If the drug is not available for sale or the collection is wrong or repeated, you can scan the deletion code to delete the most recently collected content. The deletion code can be a barcode or a QR code. You can also view the content being operated in the host computer program. The product code and traceability code of a specific drug can also be deleted from the host computer program.

[0017] The single-chip computer system drives the TTS text-to-speech module and the speaker to play the submission result and the total number of traceability codes in the order. If the traceability code does not allow sales, it will remind you that the traceability code cannot be sold. There is no strict order for collecting product codes and traceability codes. Because some drugs do not have traceability codes, steps

[0015] ,

[0016] and

[0017] are not necessary.

[0018] Repeat the process from

[0012] to

[0017] until the product codes and traceability codes of all the drugs in the current order are collected.

[0019] Operation ends the order. There are many ways to end the order, including scanning to end, delayed end, and host computer end. The scanning to end refers to scanning and identifying a barcode or QR code that identifies an end command. The delayed end refers to ending the order after a certain period of delay after scanning the last drug product code or traceability code without any operation. The host computer end refers to ending the order in the host computer program. Ending an order includes normal end, drug return end, and invalid end. Normal end means that the current order is a normal sales behavior, drug return end means that this order is a drug return registration order, and invalid end means that all collected content of this order is invalidated.

[0020] When the server receives a normal order end request, it automatically checks whether the traceability codes of the current order have been sold. If there is no drug return record after the sale, the order is not allowed to be submitted to the database, and the user is prompted. After receiving the prompt that submission is not allowed, the user can choose to cancel the order, or scan the deletion code to delete the specific product code and traceability code, or query the order in the host computer program, choose to delete the specific traceability code and the product code corresponding to the traceability code, and then submit it again. The re-submission can be submitted by scanning the order end code of the device described in the present invention or in the host computer program; when the server receives the drug return end command, it registers the content collected for this order as drug return, and sets the approval link according to the management regulations of the medical insurance fund management agency. When encountering drugs that need to be approved, the drug return record can be formed after approval; when the server receives the cancellation end command, it cancels all collected content of this order and returns the result of the operation to the device.

[0021] After the server verifies the normal end or drug return end command, it queries the organization corresponding to the device through the device ID contained in the command code, adds the organization information to the normal drug sales order or drug return order information, saves it to the database, and returns to the device whether the save is successful and the number of product codes and traceability codes contained in the current order, and clears the cache records of the current order.

[0022] The single chip microcomputer system drives the TTS text-to-speech module and the speaker to play a prompt indicating whether the order is saved successfully and the total number of commodity codes and traceability codes included.

[0023] Users can use the host computer program to query drug sales records, including orders that have been saved to the database on the server side and orders that have been cached but not yet saved to the database. The working mechanism diagram of a complete drug sales process supervision is shown in the attached figure. Figure 2 shown.

[0024] As an improvement, the results of each code scanning and decoding can also be temporarily stored in EEPROM, and the order can be submitted to the server at one time. After successful submission, the order content stored in EEPROM is cleared, and the order record is saved in the database, connected to the purchase and sales, and medical prescription databases to realize the number of transactions, number of boxes, sales and purchase patterns, and difference analysis to find abnormal clues. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] For ease of understanding, the present invention is attached with the following drawings, which are described as follows: Figure 1 is the device setup process; Figure 2 It is a schematic diagram of the working mechanism for realizing a complete supervision of the drug sales process; Figure 3 It is the schematic diagram of the key switch circuit; Figure 4 This is the pin diagram of the serial port WIFI module; Figure 5 This is the WIFI module wiring diagram; Figure 6 It is an embedded barcode and QR code scanner scanning trigger circuit. Implementation

[0026] The single-chip computer system of the present invention uses an STM32F103C8T6 single-chip computer system, and the MCU chip of the STM32F103C8T6 is connected to an external power supply module, an 8M main crystal oscillator, an RTC crystal oscillator, a reset circuit, an SWD program download and debug circuit, a voltage stabilizing module, a capacitor, a resistor, and an EEPROM; the power supply module selects a power supply module that converts 3V-15V to 3.3V with a peak value of not less than 700mA, and the key switch selects a light touch inching button, and the circuit principle of the button is as shown in the attached figure. Figure 3 As shown; the network module selects ESP-01S TTL serial port WIFI module, and the interface pin diagram is as shown in the attached Figure 4 As shown; the embedded barcode and QR code scanner uses the TTL serial port M803D embedded code scanning and decoding module, the interface is 3.3 volt VCC, RX, TX, GND four-wire, and includes a code scanning trigger circuit, the code scanning trigger circuit is as shown in the attached Figure 6 As shown; the TTS text-to-speech module uses a TTL serial port TTS module, and the interface is a 3.3-5 volt VCC, RX, TX, GND four-wire interface; the speaker uses an 8 ohm 2-wire speaker with a resistance of not less than 0.5 watts. All the electronic modules are easily available in the market, and the electronic modules are connected and installed in the handheld housing according to the specifications.

[0027] Connect the power input interface of the STM32F103C8T6 MCU system to the 5V output terminal of the power module, connect the VCC and GND of the WIFI module to the 3.3V VCC and GND interfaces of the power module, and connect the TX and RX of the WIFI module to the PA10 and PA9 pins of the STM32F103C8T6 MCU system. The wiring diagram is as attached. Figure 5 As shown; connect the VCC and GND of the M803D embedded code scanning and decoding module to the 3.3 volt VCC and GND interfaces of the power module, connect TX and RX to the PA3 and PA2 pins of the STM32F103C8T6 single-chip microcomputer system; connect the VCC and GND of the serial port TTS module to the 5 volt VCC and GND interfaces of the power module, connect TX and RX to the PB11 and PB10 pins of the STM32F103C8T6 single-chip microcomputer system, and connect the speaker to the TTS audio output port; install the code scanning button and connect the VCC and OUT of the code scanning button to the A and B ends of the scanning trigger circuit of the embedded bar code and QR code scanner, where there is no strict order between the A and B ends.

[0028] Follow the steps

[0029] -

[0046] below to complete the equipment setup and supervise the drug sales process of the medical institution.

[0029] When the machine is turned on, it automatically initializes and starts the WIFI module, TTS text-to-speech module, and embedded barcode and QR code scanner.

[0030] Develop or provide a mobile phone APP host computer setting program, which can set the WIFI AP hotspot name, password, server IP address, server port, and code scanning method. The host computer program also supports logging into the server to view the content and history of the orders being operated, and also supports deletion, submission and other actions for the orders being operated.

[0031] The upper computer setting program completes the configuration of the device according to the following steps: select or enter the WIFI AP hotspot name, password, server IP address, server port, and scanning method, and automatically generate a QR code containing this information, the device scans and identifies the QR code, sends instructions to the WIFI module according to the instruction format of the WIFI module, saves the WIFI AP hotspot name, password, server IP address, and server port information to the WIFI module, sends instructions to the embedded barcode QR code scanner according to the embedded barcode QR code scanner instruction format, and saves the scanning method of the code to the embedded barcode QR code scanner.

[0032] Restart the device, apply the parameters set by the host computer setting program, the WIFI module automatically connects to the set WIFI hotspot network, and the embedded barcode and QR code scanner module takes effect of the set scanning method.

[0033] The device drives the WIFI module to connect to the target server according to the configured server IP address and server port. Taking UDP as an example, the command format is: AT+CIPSTART="UDP","IP address",target port,local port,0.

[0034] The device sends the unique ID of the microcontroller system MCU to the server. The server records the ID and queries the database for the drug sales agency information corresponding to the ID. If the ID does not exist in the database, a new device ID information is recorded to remind the management personnel to bind the specific drug sales agency with the ID. The management personnel can bind the specific drug sales agency with the device ID to realize the correspondence between the device ID and the drug sales agency. Each time the device submits information to the server, the device ID is automatically attached to the submitted information.

[0035] The product code side of the drug is facing the embedded barcode QR code scanner, and the single-chip computer system drives the embedded barcode QR code scanner to scan and identify the product code of the drug. When the first product code is scanned, an order is automatically created. The scanning method is to scan and decode according to the scanning mode set by the host computer setting program.

[0036] The collected product codes are automatically submitted and cached to the server. If the collection is wrong or repeated, scan the deletion code to delete the content collected this time. The deletion code includes either barcode or QR code. The product code can also be deleted in the host computer program.

[0037] The single chip microcomputer system drives the TTS text-to-speech module and the loudspeaker to play the total quantity of the product codes in the order.

[0038] The drug product traceability code is placed facing the embedded barcode QR code scanner, and the single-chip microcomputer system drives the embedded barcode QR code scanner to scan and identify the drug's traceability code. Because some drugs do not have traceability codes, this step is not necessary.

[0039] The collected traceability code information is automatically submitted and cached to the server. The server returns the submission result and the total number of traceability codes in the current order to the device. The server verifies whether the traceability code has been sold. If there is no return record after the sale, it returns to the device that the traceability code drug is not allowed to be sold. If the drug is not available for sale or the collection is wrong or repeated, you can scan the deletion code to delete the most recently collected content. The deletion code can be a barcode or a QR code. You can also view the content being operated in the host computer program. The product code and traceability code of a specific drug can also be deleted from the host computer program.

[0040] The single-chip computer system drives the TTS text-to-speech module and the speaker to play the prompt submission result and the total number of traceability codes in this order. If the traceability code is not allowed to be sold, it will remind you that the traceability code cannot be sold; there is no strict order for collecting product codes and traceability codes.

[0041] Repeat the process from

[0035] to

[0040] until the product codes and traceability codes of all the drugs in this order are collected.

[0042] Operation ends the order. There are many ways to end the order, including scanning to end, delayed end, and host computer end. The scanning to end refers to scanning and identifying a barcode or QR code that identifies an end command. The delayed end refers to ending the order after a certain period of delay after scanning the last drug product code or traceability code without any operation. The host computer end refers to ending the order in the host computer program. Ending an order includes normal end, drug return end, and invalid end. Normal end means that the current order is a normal sales behavior, drug return end means that this order is a drug return registration order, and invalid end means that all collected content of this order is invalidated.

[0043] When the server receives a normal order end request, it automatically checks whether the traceability codes of the current order have been sold. If there is no drug return record after the sale, the order is not allowed to be submitted to the database, and the user is prompted. After receiving the prompt that submission is not allowed, the user can choose to cancel the order, or scan the deletion code to delete the specific product code and traceability code, or query the order in the host computer program, choose to delete the specific traceability code and the product code corresponding to the traceability code, and then submit it again. The re-submission can be submitted by scanning the order end code of the device described in the present invention or in the host computer program; when the server receives the drug return end command, it registers the content collected for this order as drug return, and sets the approval link according to the management regulations of the medical insurance fund management agency. When encountering drugs that need to be approved, the drug return record can be formed after approval; when the server receives the cancellation end command, it cancels all collected content of this order and returns the result of the operation to the device.

[0044] After the server verifies the normal end or drug return end command, it queries the organization corresponding to the device through the device ID contained in the command code, adds the organization information to the normal drug sales order or drug return order information, saves it to the database, and returns to the device whether the save is successful and the number of product codes and traceability codes contained in the current order, and clears the cache records of the current order.

[0045] The single chip microcomputer system drives the TTS text-to-speech module and the speaker to play a prompt indicating whether the order is saved successfully and the total number of commodity codes and traceability codes included.

[0046] Users can use the host computer program to query drug sales records, including orders that have been saved to the database on the server side and orders that have been cached but not yet saved to the database.

[0047] As an improvement, the results of each scan and decoding can also be stored in EEPROM, and the order can be submitted to the server at one time. After successful submission, the order content stored in EEPROM is cleared, and the order record is saved in the database, connected to the purchase and sales and medical prescription database, to realize the number of transactions, number of boxes, sales and purchase patterns, and difference analysis to find abnormal clues.

Claims

1. A method for manufacturing a handheld network medical insurance drug sales process monitoring device, characterized in that The following steps are followed to implement refined supervision of the medical insurance drug sales process: S1: The device automatically connects to the set WIFI hotspot network according to the parameters set by the host computer setting program, and the embedded barcode and QR code scanner module takes effect in the set scanning method; S2: The device connects to the target server according to the configured server IP address and server port; S3: The device sends the unique ID of the single-chip microcomputer system MCU to the server, and the server records the ID and queries the database for the drug sales agency information corresponding to the ID. If the ID does not exist in the database, a new device ID information is recorded to remind the management personnel to bind the specific drug sales agency with the ID; S4: facing the embedded barcode QR code scanner with the drug product code facing the embedded barcode QR code scanner, the single-chip microcomputer system drives the embedded barcode QR code scanner to scan and identify the drug product code, and automatically creates an order when the first product code is scanned; S5: automatically submitting and caching the collected product code to the server; S6: the single-chip microcomputer system drives the TTS text-to-speech module and the speaker to play the product code submission result; S7: facing one side of the drug product traceability code to the embedded barcode and two-dimensional code scanner, and the single-chip computer system drives the embedded barcode and two-dimensional code scanner to scan and identify the drug traceability code; S8: Automatically submit and cache the collected traceability code information to the server; S9: The single-chip microcomputer system drives the TTS text-to-speech module and the speaker to play the prompt of the traceability code submission result. Steps S7, S8, and S9 are not necessary; S10: Repeat the process from S4 to S9 until the product codes and traceability codes of all the drugs in this order are collected; S11: The device sends an end order command; S12: The server processes the end order command; S13: The server returns the end order command processing result; S14: The TTS voice module of the device prompts the order end processing result.

2. According to claim 1, the setting process of the device is implemented according to the following steps: S1: select or input the WIFI AP hotspot name, password, server IP address, server port, and scanning method; S2: generate a QR code containing the information of step S1; S3: the device scans and identifies the QR code, sends instructions to the WIFI module according to the instruction format of the WIFI module, and saves the WIFI AP hotspot name, password, server IP address, and server port information to the WIFI module; S4: sends instructions to the embedded bar code QR code scanner according to the instruction format of the embedded bar code QR code scanner, and saves the scanning method to the embedded bar code QR code scanner; S5: restart the device and apply the parameters set by the upper computer setting program to take effect.

3. According to claim 1, the traceability code verification and processing are implemented according to the following steps: S1: Each time the traceability code is collected and submitted to the server, the server verifies whether the traceability code has been sold. If there is no drug return record after the sale, the device is returned that the drug with the traceability code is not allowed to be sold; S2: When the device prompts that the drug is not allowed to be sold, the device can scan the deletion code to delete the most recently collected record; S3: When the order is normally ended, the server automatically verifies whether each traceability code has been sold. If there is no drug return record after the sale, if there is no drug return record after the sale, the device is returned that the drug with the traceability code is not allowed to be sold; S4: When receiving feedback that the server does not allow the normal end of the order, the order can be invalidated or the problematic traceability code can be deleted; S5: When the server receives a drug return instruction, when the server receives a drug return end command, the content collected in this order is registered as drug return, and an approval link is set according to the management regulations of the medical insurance fund management agency. When encountering drugs that require approval, a formal and effective drug return record can be formed only after the drug is approved.

4. According to claim 1, each time the device submits information to the server, the device ID is included.

5. According to claim 1, when the device submits the product code to the server, the TTS voice module reminds the user of the operation result and the total number of product codes for this order; when the device submits the traceability code to the server, the TTS voice module reminds the user of the operation result and the total number of traceability codes for this order; when the order is ended, the TTS voice module reminds the user of the total number of product codes and the total number of traceability codes included.

6. According to claim 1 or claim 3, it is characterized in that The end of an order includes normal end, end with drug return, and end with cancellation. When the server receives a normal order end command, it will register all the product codes and traceability codes of the current order as drug sales and save them to the database after verification; when the server receives a drug return end command, it will register the collected content of this order as drug return and save it to the database after verification; when the server receives a cancellation end command, all collected content of this order will be cancelled.

7. According to claim 1, it is characterized in that Users can use the host computer program to query drug sales records, including orders that have been saved to the database on the server side and orders that have been cached but not yet saved to the database. Users can also delete the collection records of the current order and the orders that have been ended normally, returned, or invalidated in the host computer program.

8. According to claim 1, it is characterized in that As an improvement, the results of each code scanning and decoding can also be temporarily stored in EEPROM, and the order can be submitted to the server at one time. After successful submission, the order content stored in EEPROM is cleared, and the order record is saved in the database, connected to the purchase and sales, and medical prescription databases to realize the number of transactions, number of boxes, sales and purchase patterns, and difference analysis to find abnormal clues.

9. A handheld network medical insurance drug sales process monitoring device, characterized in that The single-chip microcomputer system, push-button switch, embedded barcode and QR code scanner, network module, TTS text-to-speech module and speaker are installed in a handheld housing. No computer, monitor or keyboard is required. The product code and traceability code of the drug can be collected and submitted to the server. At the same time, real-time interception of duplicate drug sales can be achieved, thereby solving the common problems of drug substitution, false drug sales, duplicate drug sales and reselling of medical insurance drugs in the medical insurance field.

10. According to claim 9, it is characterized in that The single-chip microcomputer system uses the STM32F103C8T6 single-chip microcomputer system, the power module selects a 3V-15V to 3.3V power module with a peak value of not less than 700mA, the key switch uses a light touch button, the network module selects the ESP-01S TTL serial port WIFI module, the barcode and QR code scanner uses the TTL serial port M803D embedded scanning and decoding module, the TTS text-to-speech module uses the TTL serial port TTS module, and the speaker uses an 8 ohm 2-wire speaker with a power of not less than 0.5 watt.

Images