CN113435169A - Electronic seal data configuration method, device, equipment and storage medium - Google Patents

Electronic seal data configuration method, device, equipment and storage medium Download PDF

Info

Publication number
CN113435169A
CN113435169A CN202110706565.1A CN202110706565A CN113435169A CN 113435169 A CN113435169 A CN 113435169A CN 202110706565 A CN202110706565 A CN 202110706565A CN 113435169 A CN113435169 A CN 113435169A
Authority
CN
China
Prior art keywords
seal
data
information
electronic
target
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202110706565.1A
Other languages
Chinese (zh)
Inventor
王秀虎
白云中
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An International Smart City Technology Co Ltd
Original Assignee
Ping An International Smart City Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ping An International Smart City Technology Co Ltd filed Critical Ping An International Smart City Technology Co Ltd
Priority to CN202110706565.1A priority Critical patent/CN113435169A/en
Publication of CN113435169A publication Critical patent/CN113435169A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/174Form filling; Merging
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Artificial Intelligence (AREA)
  • Health & Medical Sciences (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Software Systems (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention relates to the field of big data, and discloses an electronic seal data configuration method, which comprises the following steps: acquiring electronic seal data to be processed, and splitting the electronic seal data to be processed into seal information data and seal service configuration data; reading target seal information corresponding to the seal ID from a preset database table based on the seal ID in the seal information data; comparing the seal information data with the target seal information, and determining effective data in the electronic seal data to be processed according to a comparison result and the seal service configuration data; and configuring the effective data to a database table where the target seal information is located. The invention can improve the efficiency and accuracy of the data configuration of the electronic seal.

Description

Electronic seal data configuration method, device, equipment and storage medium
Technical Field
The invention relates to the technical field of big data processing, in particular to a method and a device for configuring electronic seal data, electronic equipment and a computer readable storage medium.
Background
At present, in the using process of an electronic seal, a corresponding company is required to provide corresponding configuration information of the electronic seal, the configuration information is matched with related business functions in a system, and a remote interface of the electronic seal can be called in the specific using process to realize successful signature. It can be known that, in the configuration process of the existing electronic signature data, the electronic seal information and the specific service information ID need to be paired and stored in the same data table, and usually, the same electronic seal will be configured with a plurality of functions or services, and all the functions or services are configured with data in the same table, which may cause data redundancy of the electronic seal and too strong coupling with the function service.
In addition, the configuration of the electronic seal may have new addition, change or invalidation, and the like, and the configuration generally needs to be manually modified item by item to modify the configuration information of the database table, and is prone to errors under the condition of a large data volume, for example, the change operation needs to be performed first and then compared with the original data, the manual operation is time-consuming and labor-consuming, and the error rate is high. In addition, after the electronic seal is subjected to invalidation or change processing, occasionally, the requirements of cancelling the invalidation and withdrawing the change exist, and the existing electronic seal configuration method lacks the function of version management and has poor flexibility.
Disclosure of Invention
The invention provides an electronic seal data configuration method, an electronic seal data configuration device, electronic equipment and a computer readable storage medium, and mainly aims to improve the efficiency of electronic seal data configuration.
In order to achieve the above object, the present invention provides a method for configuring electronic seal data, comprising:
acquiring electronic seal data to be processed, and splitting the electronic seal data to be processed into seal information data and seal service configuration data;
reading target seal information corresponding to the seal ID from a preset database table based on the seal ID in the seal information data;
comparing the seal information data with the target seal information, and determining effective data in the electronic seal data to be processed according to a comparison result and the seal service configuration data;
and configuring the effective data to a database table where the target seal information is located.
In addition, an optional technical solution is that the acquiring the to-be-processed electronic seal data and splitting the to-be-processed electronic seal data into seal information data and seal service configuration data includes:
reading the electronic seal data to be processed from the target excel table;
splitting the electronic seal data to be processed to form the seal information data and the seal service configuration data;
the seal information data comprises a seal ID, a seal function, a seal description and a seal name, and the seal service configuration data comprises the seal ID, a service ID, an effective identifier and an operation field.
In addition, an optional technical solution is that the reading the electronic seal data to be processed from the target excel form includes:
acquiring image data of the target excel table;
scanning the image data, deleting interference item information in the image data, and determining a target data area;
extracting the characteristics of the target data area, and inputting the extracted characteristic information into a pre-trained classifier;
determining a character feature template corresponding to the feature information according to the classifier, and segmenting characters to be recognized in the target data area to obtain a sub-picture only containing a single character;
and matching the sub-picture with the character characteristic template to realize content identification of the target data area, and acquiring corresponding to-be-processed electronic seal data based on an identification result.
In addition, an optional technical solution is that the preset database table is stored in a block chain, and the reading of the target seal information corresponding to the seal ID from the preset database table based on the seal ID in the seal information data includes:
an electronic seal table is configured in the preset database table in advance;
reading preset seal information consistent with the seal ID in the electronic seal table based on the seal ID;
and extracting a preset seal function, a preset seal name and preset seal description information from the preset seal information as the target seal information.
In addition, an optional technical solution is that the comparing the stamp information data with the target stamp information, and determining valid data in the electronic stamp data to be processed according to a comparison result and the stamp service configuration data includes:
comparing the seal information data with the target seal information, and directly determining the seal information data as effective data when the seal information data is inconsistent with the target seal information; and the number of the first and second groups,
determining data in a seal service relation configuration table corresponding to the operation field as valid data according to the operation field in the seal service configuration data; wherein the content of the first and second substances,
the seal information data is inconsistent with the target seal information, and comprises that the seal name in the seal information data is inconsistent with the preset seal name in the target seal information, and/or the seal function in the seal information data is inconsistent with the preset seal function in the target seal information, and/or; the seal description in the seal information data is inconsistent with the preset seal description in the target seal information.
In addition, an optional technical solution is that the operation fields in the seal service configuration data include addition, modification, deletion and recovery;
when the operation field in the seal service configuration data is newly added, a piece of data corresponding to the seal service configuration data is directly and newly added in the seal service relationship configuration table, the version number is set as v1, and whether the valid identifier is set to be valid or not is set;
when the operation field in the seal service configuration data is modified, calling a corresponding seal service relationship configuration table based on the seal ID in the seal service configuration data, setting whether the valid identifier of the last version of the historical data in the seal service relationship configuration table is invalid, adding a piece of data corresponding to the seal service configuration data, adding 1 to the corresponding version number on the basis of the original version number, and setting whether the valid identifier is valid;
when the operation field in the seal service configuration data is deleted, calling a corresponding seal service relation configuration table based on the seal ID in the seal service configuration data, and setting the valid or invalid identifier of the last version of the historical data to be invalid;
and when the operation field in the seal service configuration data is recovery, calling a corresponding seal service relation configuration table based on the seal ID in the seal service configuration data, and modifying the invalidity of the valid identifier of the last version of the historical data into validity.
In addition, according to an optional technical scheme, after the valid data is configured in the database table where the target seal information is located, electronic seal signing is further performed based on the configured database table, where the electronic seal signing includes:
searching a seal ID corresponding to the service ID in the database table based on the service ID of the service to be signed;
acquiring a key parameter, an application ID and an identification code verification parameter corresponding to the seal ID from a seal information table of the database table based on the seal ID;
calling an authentication interface corresponding to the seal ID, and verifying the verification parameters through a preset public key;
and when the verification parameters are verified successfully, acquiring the electronic signature date and the signature result signature information corresponding to the seal ID, and completing the signature at the appointed position according to the signature position information in the seal table.
In order to solve the above problem, the present invention further provides an electronic seal data configuration apparatus, including:
the electronic seal data acquisition and splitting unit is used for acquiring electronic seal data to be processed and splitting the electronic seal data to be processed into seal information data and seal service configuration data;
the target seal information reading unit is used for reading target seal information corresponding to the seal ID from a preset database table based on the seal ID in the seal information data;
the effective data determining unit is used for comparing the seal information data with the target seal information and determining effective data in the electronic seal data to be processed according to a comparison result and the seal service configuration data;
and the data configuration unit is used for configuring the effective data into a database table where the target seal information is located.
In order to solve the above problem, the present invention also provides an electronic device, including:
a memory storing at least one instruction; and
and the processor executes the instructions stored in the memory to realize the electronic seal data configuration method.
In order to solve the above problem, the present invention further provides a computer-readable storage medium, where at least one instruction is stored in the computer-readable storage medium, and the at least one instruction is executed by a processor in an electronic device to implement the above electronic seal data configuration method.
The embodiment of the invention divides the electronic seal data to be processed into seal information data and seal service configuration data by acquiring the electronic seal data to be processed; reading target seal information corresponding to the seal ID from a preset database table based on the seal ID in the seal information data; comparing the seal information data with the target seal information, and determining effective data in the electronic seal data to be processed according to the comparison result and the seal service configuration data; the effective data is configured in the database table where the target seal information is located, so that the workload of workers from comparison and judgment of the electronic seal configuration information to input of the configuration information can be reduced, and the working quality and efficiency of data configuration are greatly improved.
Drawings
Fig. 1 is a schematic flow chart of a method for configuring electronic seal data according to an embodiment of the present invention;
FIG. 2 is a detailed flowchart of an electronic seal data configuration apparatus according to an embodiment of the present invention;
FIG. 3 is a block diagram of an electronic seal data configuration apparatus according to an embodiment of the present invention;
fig. 4 is a schematic internal structural diagram of an electronic device for implementing a method for configuring electronic seal data according to an embodiment of the present invention;
the implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The invention provides an electronic seal data configuration method. Referring to fig. 1, a flow chart of an electronic seal data configuration method according to an embodiment of the present invention is shown. The method may be performed by an apparatus, which may be implemented by software and/or hardware.
In this embodiment, the electronic seal data configuration method includes:
s100: the method comprises the steps of obtaining electronic seal data to be processed, and splitting the electronic seal data to be processed into seal information data and seal service configuration data.
The acquiring of the to-be-processed electronic seal data and the splitting of the to-be-processed electronic seal data into seal information data and seal service configuration data comprise:
s110: reading the electronic seal data to be processed from the target excel table;
specifically, the step S110 may further include:
s111: acquiring image data of the target excel table;
s112: scanning the image data, deleting interference item information in the image data, and determining a target data area;
s113: extracting the characteristics of the target data area, and inputting the extracted characteristic information into a pre-trained classifier;
s114: determining a character feature template corresponding to the feature information according to the classifier, segmenting characters to be recognized in a target data area, and acquiring a sub-picture only containing a single character;
s115: and matching the sub-picture with the character characteristic template to realize content identification of the target data area, and acquiring corresponding to-be-processed electronic seal data based on an identification result.
Besides the above identification method, other technical means capable of directly identifying the required electronic seal data to be processed from the excel form can be adopted, wherein the electronic seal data to be processed includes information such as a seal ID, a seal name, a seal description, a seal function, a service ID, an effective identifier, an operation field and the like.
In a specific application process, as the related data needing to be configured are generally embodied by an excel form in an xlsx format, an excel form template can be created in advance according to an operation habit, after the related data needing to be configured are obtained, appropriate modification can be carried out or key information identification can be directly carried out through the identification mode, automatic entry of data can be realized, simultaneous configuration of a large amount of data is realized, and errors caused by manual entry can be avoided. For example, before the image data of the target excel form is acquired, a fixed excel form template may be set, and the electronic stamp data to be processed may be input into the excel form template.
S120: splitting the electronic seal data to be processed to form the seal information data and the seal service configuration data;
s130: the seal information data comprises a seal ID, a seal function, seal description and a seal name, and the seal service configuration data comprises the seal ID, a service ID, an effective identifier and an operation field.
In a specific embodiment of the present invention, the stamp information data includes a stamp ID, a stamp function, a stamp description, and a stamp name; the seal service configuration data comprises a seal ID, a service ID, an effective identifier, an operation field and the like, wherein the seal ID in the seal information data and the seal service configuration data is the same, and the seal ID can be directly used for calling the relevant information of the corresponding seal in a preset database table so as to perform relevant operations such as data comparison, data configuration and the like.
Therefore, through splitting the electronic seal data to be processed, the seal information data and the seal service data can be decoupled, the corresponding data function has cohesiveness, data redundancy is avoided, and flexibility and efficiency of data configuration are improved.
It should be emphasized that, in order to further ensure the privacy and security of the preset database table, the preset database table may also be stored in a node of a block chain.
S200: and reading target seal information corresponding to the seal ID from a preset database table based on the seal ID in the seal information data.
Wherein, based on the seal ID in the seal information data, reading the target seal information corresponding to the seal ID from a preset database table, and the method comprises the following steps:
s210: and pre-configuring an electronic seal table in the preset database table.
S220: and reading preset seal information consistent with the seal ID in the electronic seal table based on the seal ID.
S230: and extracting a preset seal function, a preset seal name and preset seal description information from the preset seal information as the target seal information.
The electronic seal table comprises a seal information table and a seal service relation configuration table; the seal information table comprises a seal ID, a seal function, a seal description, a seal name and the like, the seal service relation configuration table comprises information such as the seal ID, a service ID, a valid identifier, a version number and the like, the seal service relation configuration table is used for matching the incidence relation between the electronic seal and a specific application service, and the electronic seal can be matched with a plurality of specific application services.
It should be noted that, in order to conveniently distinguish the relevant information of the preconfigured electronic seal table in the database table from the data in the electronic seal data to be processed, each parameter in the preconfigured electronic seal table may be understood as a preset parameter, for example, a preset seal function, a preset seal description, and the like.
S300: and comparing the seal information data with the target seal information, and determining effective data in the electronic seal data to be processed according to a comparison result and the seal service configuration data.
The step may further comprise: comparing the seal information data with the target seal information, and directly determining the seal information data as effective data when the seal information data is inconsistent with the target seal information; and determining the data in the seal service relation configuration table corresponding to the operation field as valid data according to the operation field in the seal service configuration data.
Specifically, the seal information data is inconsistent with the target seal information, and includes that a seal name in the seal information data is inconsistent with a preset seal name in the target seal information, and/or a seal function in the seal information data is inconsistent with a preset seal function in the target seal information, and/or; the seal description in the seal information data is inconsistent with the preset seal description in the target seal information.
In addition, the operation fields in the seal service configuration data comprise a newly added field, an updated field, a deleted field and a recovered field, and the seal service configuration data are reconfigured according to the requirements of the corresponding operation fields. Firstly, acquiring an operation field in the seal service configuration data; and then directly configuring the data in the seal service relation configuration table in the preset database table based on the operation field.
S400: and configuring the effective data to a database table where the target seal information is located.
Because the seal service relation configuration table comprises information such as a seal ID, a service ID, a valid identifier, a version number and the like, and operation fields in the seal service configuration data comprise addition, modification, deletion and recovery;
when the operation field in the seal service configuration data is newly added, directly adding a piece of data corresponding to the seal service configuration data in the seal service relationship configuration table, setting the version number as v1, and setting whether the valid identifier is valid;
when the operation field in the seal service configuration data is modified, calling a corresponding seal service relationship configuration table based on the seal ID in the seal service configuration data, setting whether the valid identifier of the last version of the historical data in the seal service relationship configuration table is invalid, adding a piece of data corresponding to the seal service configuration data, adding 1 to the corresponding version number on the basis of the original version number, and setting whether the valid identifier is valid;
when the operation field in the seal service configuration data is deleted, calling a corresponding seal service relation configuration table based on the seal ID in the seal service configuration data, and setting the valid or invalid identifier of the last version of the historical data to be invalid;
and when the operation field in the seal service configuration data is recovery, calling a corresponding seal service relation configuration table based on the seal ID in the seal service configuration data, and modifying the invalidity of the valid identifier of the last version of the historical data into validity.
Specifically, the electronic seal data to be processed may be as shown in table 1 below, and in a field with special requirements or application fields, it may be considered to set various parameters in the electronic seal data, for example, various information such as the use position and the use state of the seal may be added.
Figure BDA0003131513420000081
Figure BDA0003131513420000091
TABLE 1
The electronic seal data configuration method of the present invention, after configuring the electronic seal data to be processed into the preset database table, may further include:
s500: and performing electronic seal signing based on the configured database table.
The step S500 may further include:
s510: searching a seal ID corresponding to the service ID in the database table based on the service ID of the service to be signed;
s520: acquiring verification parameters such as a key parameter, an application ID, an identification code and the like corresponding to the seal ID from a seal information table of the database table based on the seal ID;
s530: calling an authentication interface corresponding to the seal ID, and verifying the verification parameters through a preset public key;
s540: when the verification parameters are verified successfully, the signature information such as the electronic signature date and the signature result corresponding to the seal ID is obtained, and the signature can be completed at the appointed position according to the signature position information in the seal table.
As a specific example, fig. 2 shows a schematic flow of an electronic seal data configuration method according to the present invention, and as can be seen from fig. 2, when the present invention configures electronic seal data, excel form data is identified first, then the data is split and then judged whether the data belongs to configuration data (seal service configuration data) or seal data (seal information data), when the data is configuration data, related operations are further performed on the corresponding configuration data according to operation fields, when the data is seal data, whether the data is consistent with old data in a database or not is judged, if so, no processing is performed, otherwise, the data is directly added to a database table corresponding to the database.
The method and the device can automatically identify the data in the excel table, complete automatic updating and configuration of the electronic seal data according to the comparison of new and old data and the corresponding operation field, are simple and convenient to operate, can simultaneously carry out unified management and configuration on a large amount of electronic seal data, and are high in speed and accuracy.
FIG. 3 is a functional block diagram of the electronic seal data configuration device according to the present invention.
The electronic seal data configuration device 200 of the present invention can be installed in an electronic device. According to the realized functions, the electronic seal data configuration device may include an electronic seal data acquisition and splitting unit 210, a target seal information reading unit 220, an effective data determining unit 230, and a data configuration unit 240. The unit of the invention, which may also be referred to as a dongle, refers to a series of computer program segments that can be executed by a processor of an electronic device and that can perform a fixed function, and that are stored in a memory of the electronic device.
In the present embodiment, the functions regarding the respective modules/units are as follows:
the electronic seal data acquiring and splitting unit 210 is configured to acquire electronic seal data to be processed, and split the electronic seal data to be processed into seal information data and seal service configuration data.
The acquiring the to-be-processed electronic seal data and splitting the to-be-processed electronic seal data into seal information data and seal service configuration data may further include:
s110: reading the electronic seal data to be processed from the target excel table;
specifically, the step S110 may further include:
s111: acquiring image data of the target excel table;
s112: scanning the image data, deleting interference item information in the image data, and determining a target data area;
s113: extracting the characteristics of the target data area, and inputting the extracted characteristic information into a pre-trained classifier;
s114: determining a character feature template corresponding to the feature information according to the classifier, segmenting characters to be recognized in a target data area, and acquiring a sub-picture only containing a single character;
s115: and matching the sub-picture with the character characteristic template to realize content identification of the target data area, and acquiring corresponding to-be-processed electronic seal data based on an identification result.
Besides the above identification method, other technical means capable of directly identifying the required electronic seal data to be processed from the excel form can be adopted, wherein the electronic seal data to be processed includes information such as a seal ID, a seal name, a seal description, a seal function, a service ID, an effective identifier, an operation field and the like.
In a specific application process, as the related data needing to be configured are generally embodied by an excel form in an xlsx format, an excel form template can be created in advance according to an operation habit, after the related data needing to be configured are obtained, appropriate modification can be carried out or key information identification can be directly carried out through the identification mode, automatic entry of data can be realized, simultaneous configuration of a large amount of data is realized, and errors caused by manual entry can be avoided. For example, before the image data of the target excel form is acquired, a fixed excel form template may be set, and the electronic stamp data to be processed may be input into the excel form template.
S120: splitting the electronic seal data to be processed to form the seal information data and the seal service configuration data;
s130: the seal information data comprises a seal ID, a seal function, seal description and a seal name, and the seal service configuration data comprises the seal ID, a service ID, an effective identifier and an operation field.
In a specific embodiment of the present invention, the stamp information data includes a stamp ID, a stamp function, a stamp description, and a stamp name; the seal service configuration data comprises a seal ID, a service ID, an effective identifier, an operation field and the like, wherein the seal ID in the seal information data and the seal service configuration data is the same, and the seal ID can be directly used for calling the relevant information of the corresponding seal in a preset database table so as to perform relevant operations such as data comparison, data configuration and the like.
Therefore, through splitting the electronic seal data to be processed, the seal information data and the seal service data can be decoupled, the corresponding data function has cohesiveness, data redundancy is avoided, and flexibility and efficiency of data configuration are improved.
And a target stamp information reading unit 220, configured to read, based on the stamp ID in the stamp information data, target stamp information corresponding to the stamp ID from a preset database table.
Wherein, based on the seal ID in the seal information data, reading the target seal information corresponding to the seal ID from a preset database table, and the method comprises the following steps:
s210: and pre-configuring an electronic seal table in the preset database table.
S220: and reading preset seal information consistent with the seal ID in the electronic seal table based on the seal ID.
S230: and extracting a preset seal function, a preset seal name and preset seal description information from the preset seal information as the target seal information.
The electronic seal table comprises a seal information table and a seal service relation configuration table; the seal information table comprises a seal ID, a seal function, a seal description, a seal name and the like, the seal service relation configuration table comprises information such as the seal ID, a service ID, a valid identifier, a version number and the like, the seal service relation configuration table is used for matching the incidence relation between the electronic seal and a specific application service, and the electronic seal can be matched with a plurality of specific application services.
It should be noted that, in order to conveniently distinguish the relevant information of the preconfigured electronic seal table in the database table from the data in the electronic seal data to be processed, each parameter in the preconfigured electronic seal table may be understood as a preset parameter, for example, a preset seal function, a preset seal description, and the like.
And the valid data determining unit 230 is configured to compare the stamp information data with the target stamp information, and determine valid data in the to-be-processed electronic stamp data according to a comparison result and the stamp service configuration data.
Comparing the seal information data with the target seal information, and directly determining the seal information data as effective data when the seal information data is inconsistent with the target seal information; and determining the data in the seal service relation configuration table corresponding to the operation field as valid data according to the operation field in the seal service configuration data.
Specifically, the seal information data is inconsistent with the target seal information, and includes that a seal name in the seal information data is inconsistent with a preset seal name in the target seal information, and/or a seal function in the seal information data is inconsistent with a preset seal function in the target seal information, and/or; the seal description in the seal information data is inconsistent with the preset seal description in the target seal information.
In addition, the operation fields in the seal service configuration data comprise a newly added field, an updated field, a deleted field and a recovered field, and the seal service configuration data are reconfigured according to the requirements of the corresponding operation fields. Firstly, acquiring an operation field in the seal service configuration data; and then directly configuring the data in the seal service relation configuration table in the preset database table based on the operation field.
And a data configuration unit 240, configured to configure the valid data to a database table in which the target seal information is located.
Because the seal service relation configuration table comprises information such as a seal ID, a service ID, a valid identifier, a version number and the like, and operation fields in the seal service configuration data comprise addition, modification, deletion and recovery;
when the operation field in the seal service configuration data is newly added, directly adding a piece of data corresponding to the seal service configuration data in the seal service relationship configuration table, setting the version number as v1, and setting whether the valid identifier is valid;
when the operation field in the seal service configuration data is modified, calling a corresponding seal service relationship configuration table based on the seal ID in the seal service configuration data, setting whether the valid identifier of the last version of the historical data in the seal service relationship configuration table is invalid, adding a piece of data corresponding to the seal service configuration data, adding 1 to the corresponding version number on the basis of the original version number, and setting whether the valid identifier is valid;
when the operation field in the seal service configuration data is deleted, calling a corresponding seal service relation configuration table based on the seal ID in the seal service configuration data, and setting the valid or invalid identifier of the last version of the historical data to be invalid;
and when the operation field in the seal service configuration data is recovery, calling a corresponding seal service relation configuration table based on the seal ID in the seal service configuration data, and modifying the invalidity of the valid identifier of the last version of the historical data into validity.
It should be noted that, after the electronic seal data configuration device of the present invention configures the electronic seal data to be processed into the preset database table, the electronic seal data configuration device may further include: and performing electronic seal signing based on the configured database table.
The above electronic seal signing based on the configured database table may further include:
1. searching a seal ID corresponding to the service ID in the database table based on the service ID of the service to be signed;
2. acquiring verification parameters such as a key parameter, an application ID, an identification code and the like corresponding to the seal ID from a seal information table of the database table based on the seal ID;
3. calling an authentication interface corresponding to the seal ID, and verifying the verification parameters through a preset public key;
4. when the verification parameters are verified successfully, the signature information such as the electronic signature date and the signature result corresponding to the seal ID is obtained, and the signature can be completed at the appointed position according to the signature position information in the seal table.
Fig. 4 only shows an electronic device with components, and it will be understood by those skilled in the art that the structure shown in fig. 4 does not constitute a limitation of the electronic device 1, and may comprise fewer or more components than those shown, or some components may be combined, or a different arrangement of components.
For example, although not shown, the electronic device 1 may further include a power supply (such as a battery) for supplying power to each component, and preferably, the power supply may be logically connected to the at least one processor 10 through a power management device, so as to implement functions of charge management, discharge management, power consumption management, and the like through the power management device. The power supply may also include any component of one or more dc or ac power sources, recharging devices, power failure detection circuitry, power converters or inverters, power status indicators, and the like. The electronic device 1 may further include various sensors, a bluetooth module, a Wi-Fi module, and the like, which are not described herein again.
Further, the electronic device 1 may further include a network interface, and optionally, the network interface may include a wired interface and/or a wireless interface (such as a WI-FI interface, a bluetooth interface, etc.), which are generally used for establishing a communication connection between the electronic device 1 and other electronic devices.
Optionally, the electronic device 1 may further comprise a user interface, which may be a Display (Display), an input unit (such as a Keyboard), and optionally a standard wired interface, a wireless interface. Alternatively, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode) touch device, or the like. The display, which may also be referred to as a display screen or display unit, is suitable for displaying information processed in the electronic device 1 and for displaying a visualized user interface, among other things.
It is to be understood that the described embodiments are for purposes of illustration only and that the scope of the appended claims is not limited to such structures.
The electronic seal data configuration program 12 stored in the memory 11 of the electronic device 1 is a combination of a plurality of instructions, and when running in the processor 10, can implement:
acquiring electronic seal data to be processed, and splitting the electronic seal data to be processed into seal information data and seal service configuration data;
reading target seal information corresponding to the seal ID from a preset database table based on the seal ID in the seal information data;
comparing the seal information data with the target seal information, and determining effective data in the electronic seal data to be processed according to a comparison result and the seal service configuration data;
and configuring the effective data to a database table where the target seal information is located.
In addition, an optional technical solution is that the acquiring the to-be-processed electronic seal data and splitting the to-be-processed electronic seal data into seal information data and seal service configuration data includes:
reading the electronic seal data to be processed from the target excel table;
splitting the electronic seal data to be processed to form the seal information data and the seal service configuration data;
the seal information data comprises a seal ID, a seal function, seal description and a seal name, and the seal service configuration data comprises the seal ID, a service ID, an effective identifier and an operation field.
In addition, an optional technical solution is that the reading the electronic seal data to be processed from the target excel form includes:
acquiring image data of the target excel table;
scanning the image data, deleting interference item information in the image data, and determining a target data area;
extracting the characteristics of the target data area, and inputting the extracted characteristic information into a pre-trained classifier;
determining a character feature template corresponding to the feature information according to the classifier, and segmenting characters to be recognized in the target data area to obtain a sub-picture only containing a single character;
and matching the sub-picture with the character characteristic template to realize content identification of the target data area, and acquiring corresponding to-be-processed electronic seal data based on an identification result.
In addition, an optional technical solution is that, based on the seal ID in the seal information data, reading target seal information corresponding to the seal ID from a preset database table, including:
an electronic seal table is configured in the preset database table in advance;
reading preset seal information consistent with the seal ID in the electronic seal table based on the seal ID;
and extracting a preset seal function, a preset seal name and preset seal description information from the preset seal information as the target seal information.
In addition, an optional technical solution is that the comparing the stamp information data with the target stamp information, and determining valid data in the electronic stamp data to be processed according to a comparison result and the stamp service configuration data includes:
comparing the seal information data with the target seal information, and directly determining the seal information data as effective data when the seal information data is inconsistent with the target seal information; and the number of the first and second groups,
determining data in a seal service relation configuration table corresponding to the operation field as valid data according to the operation field in the seal service configuration data; wherein the content of the first and second substances,
the seal information data is inconsistent with the target seal information, and comprises that the seal name in the seal information data is inconsistent with the preset seal name in the target seal information, and/or the seal function in the seal information data is inconsistent with the preset seal function in the target seal information, and/or; the seal description in the seal information data is inconsistent with the preset seal description in the target seal information.
In addition, an optional technical solution is that the operation fields in the seal service configuration data include addition, modification, deletion and recovery;
when the operation field in the seal service configuration data is newly added, directly adding a piece of data corresponding to the seal service configuration data in the seal service relationship configuration table, setting the version number as v1, and setting whether the valid identifier is valid;
when the operation field in the seal service configuration data is modified, calling a corresponding seal service relationship configuration table based on the seal ID in the seal service configuration data, setting whether the valid identifier of the last version of the historical data in the seal service relationship configuration table is invalid, adding a piece of data corresponding to the seal service configuration data, adding 1 to the corresponding version number on the basis of the original version number, and setting whether the valid identifier is valid;
when the operation field in the seal service configuration data is deleted, calling a corresponding seal service relation configuration table based on the seal ID in the seal service configuration data, and setting the valid or invalid identifier of the last version of the historical data to be invalid;
and when the operation field in the seal service configuration data is recovery, calling a corresponding seal service relation configuration table based on the seal ID in the seal service configuration data, and modifying the invalidity of the valid identifier of the last version of the historical data into validity.
In addition, according to an optional technical scheme, after the valid data is configured in the database table where the target seal information is located, electronic seal signing is further performed based on the configured database table, where the electronic seal signing includes:
searching a seal ID corresponding to the service ID in the database table based on the service ID of the service to be signed;
acquiring verification parameters such as a key parameter, an application ID, an identification code and the like corresponding to the seal ID from a seal information table of the database table based on the seal ID;
calling an authentication interface corresponding to the seal ID, and verifying the verification parameters through a preset public key;
when the verification parameters are verified successfully, the signature information such as the electronic signature date and the signature result corresponding to the seal ID is obtained, and the signature can be completed at the appointed position according to the signature position information in the seal table.
Specifically, the specific implementation method of the processor 10 for the instruction may refer to the description of the relevant steps in the embodiment corresponding to fig. 1, which is not described herein again.
Further, the integrated modules/units of the electronic device 1, if implemented in the form of software functional units and sold or used as separate products, may be stored in a computer readable storage medium. The computer-readable medium may include: any entity or device capable of carrying said computer program code, recording medium, U-disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM).
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus, device and method can be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the modules is only one logical functional division, and other divisions may be realized in practice.
The modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
In addition, functional modules in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional module.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential attributes thereof.
The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference signs in the claims shall not be construed as limiting the claim concerned.
The block chain is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, a consensus mechanism, an encryption algorithm and the like. A block chain (Blockchain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
Furthermore, it is obvious that the word "comprising" does not exclude other elements or steps, and the singular does not exclude the plural. A plurality of units or means recited in the system claims may also be implemented by one unit or means in software or hardware. The terms second, etc. are used to denote names, but not any particular order.
Finally, it should be noted that the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting, and although the present invention is described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications or equivalent substitutions may be made on the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention.

Claims (10)

1. A method for configuring data of an electronic seal is characterized by comprising the following steps:
acquiring electronic seal data to be processed, and splitting the electronic seal data to be processed into seal information data and seal service configuration data;
reading target seal information corresponding to the seal ID from a preset database table based on the seal ID in the seal information data;
comparing the seal information data with the target seal information, and determining effective data in the electronic seal data to be processed according to a comparison result and the seal service configuration data;
and configuring the effective data to a database table where the target seal information is located.
2. The electronic seal data configuration method according to claim 1, wherein said obtaining electronic seal data to be processed and splitting said electronic seal data to be processed into seal information data and seal service configuration data comprises:
reading the electronic seal data to be processed from the target excel table;
splitting the electronic seal data to be processed to form the seal information data and the seal service configuration data;
the seal information data comprises a seal ID, a seal function, a seal description and a seal name, and the seal service configuration data comprises the seal ID, a service ID, an effective identifier and an operation field.
3. The electronic seal data configuration method according to claim 2, wherein said reading said electronic seal data to be processed from a target excel form includes:
acquiring image data of the target excel table;
scanning the image data, deleting interference item information in the image data, and determining a target data area;
extracting the characteristics of the target data area, and inputting the extracted characteristic information into a pre-trained classifier;
determining a character feature template corresponding to the feature information according to the classifier, and segmenting characters to be recognized in the target data area to obtain a sub-picture only containing a single character;
and matching the sub-picture with the character characteristic template to realize content identification of the target data area, and acquiring corresponding to-be-processed electronic seal data based on an identification result.
4. The electronic seal data configuration method according to claim 1, wherein the preset database table is stored in a block chain, and the reading of the target seal information corresponding to the seal ID from the preset database table based on the seal ID in the seal information data includes:
an electronic seal table is configured in the preset database table in advance;
reading preset seal information consistent with the seal ID in the electronic seal table based on the seal ID;
and extracting a preset seal function, a preset seal name and preset seal description information from the preset seal information as the target seal information.
5. The electronic seal data configuration method according to claim 1, wherein said comparing said seal information data with said target seal information and determining valid data in said electronic seal data to be processed according to a comparison result and said seal service configuration data comprises:
comparing the seal information data with the target seal information, and directly determining the seal information data as effective data when the seal information data is inconsistent with the target seal information; and the number of the first and second groups,
determining data in a seal service relation configuration table corresponding to the operation field as valid data according to the operation field in the seal service configuration data;
the seal information data is inconsistent with the target seal information, and the seal information data comprises a seal name in the seal information data and a preset seal name in the target seal information, and/or a seal function in the seal information data and a preset seal function in the target seal information, and/or; the seal description in the seal information data is inconsistent with the preset seal description in the target seal information.
6. The electronic seal data configuration method according to claim 5,
the operation fields in the seal service configuration data comprise addition, modification, deletion and recovery;
wherein the content of the first and second substances,
when the operation field in the seal service configuration data is newly added, directly adding a piece of data corresponding to the seal service configuration data in the seal service relationship configuration table, setting the version number as v1, and setting whether the valid identifier is valid;
when the operation field in the seal service configuration data is modified, calling a corresponding seal service relationship configuration table based on the seal ID in the seal service configuration data, setting whether the valid identifier of the last version of the historical data in the seal service relationship configuration table is invalid, adding a piece of data corresponding to the seal service configuration data, adding 1 to the corresponding version number on the basis of the original version number, and setting whether the valid identifier is valid;
when the operation field in the seal service configuration data is deleted, calling a corresponding seal service relation configuration table based on the seal ID in the seal service configuration data, and setting the valid or invalid identifier of the last version of the historical data to be invalid;
and when the operation field in the seal service configuration data is recovery, calling a corresponding seal service relation configuration table based on the seal ID in the seal service configuration data, and modifying the invalidity of the valid identifier of the last version of the historical data into validity.
7. The method according to claim 1, further comprising signing an electronic seal based on the configured database table after configuring the valid data into the database table in which the target seal information is located, wherein the signing an electronic seal comprises:
searching a seal ID corresponding to the service ID in the database table based on the service ID of the service to be signed;
acquiring a key parameter, an application ID and an identification code verification parameter corresponding to the seal ID from a seal information table of the database table based on the seal ID;
calling an authentication interface corresponding to the seal ID, and verifying the verification parameters through a preset public key;
and when the verification parameters are verified successfully, acquiring the electronic signature date and the signature result signature information corresponding to the seal ID, and completing the signature at the appointed position according to the signature position information in the seal table.
8. An electronic seal data configuration device, the device comprising:
the electronic seal data acquisition and splitting unit is used for acquiring electronic seal data to be processed and splitting the electronic seal data to be processed into seal information data and seal service configuration data;
the target seal information reading unit is used for reading target seal information corresponding to the seal ID from a preset database table based on the seal ID in the seal information data;
the effective data determining unit is used for comparing the seal information data with the target seal information and determining effective data in the electronic seal data to be processed according to a comparison result and the seal service configuration data;
and the data configuration unit is used for configuring the effective data into a database table where the target seal information is located.
9. An electronic device, characterized in that the electronic device comprises:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
the memory stores instructions executable by the at least one processor to enable the at least one processor to perform the steps of the method of configuring electronic seal data according to any one of claims 1 to 7.
10. A computer-readable storage medium, storing a computer program, characterized in that the computer program, when being executed by a processor, implements the steps in the method for configuring electronic stamp data according to any one of claims 1 to 7.
CN202110706565.1A 2021-06-24 2021-06-24 Electronic seal data configuration method, device, equipment and storage medium Pending CN113435169A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110706565.1A CN113435169A (en) 2021-06-24 2021-06-24 Electronic seal data configuration method, device, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110706565.1A CN113435169A (en) 2021-06-24 2021-06-24 Electronic seal data configuration method, device, equipment and storage medium

Publications (1)

Publication Number Publication Date
CN113435169A true CN113435169A (en) 2021-09-24

Family

ID=77754081

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110706565.1A Pending CN113435169A (en) 2021-06-24 2021-06-24 Electronic seal data configuration method, device, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN113435169A (en)

Similar Documents

Publication Publication Date Title
WO2019051946A1 (en) Node task data display method and apparatus, storage medium and computer equipment
CN104484790A (en) Address match method and device of logistics business
CN112115145A (en) Data acquisition method and device, electronic equipment and storage medium
CN104272327B (en) Job management method and management system
CN113434674A (en) Data analysis method and device, electronic equipment and readable storage medium
CN110704524A (en) House source recording method, device and equipment and computer readable storage medium
CN111090803A (en) Data processing method and device, electronic equipment and storage medium
CN112579055A (en) Interface parameter checking method and device and computer readable storage medium
JP2009003549A (en) Data management device, data management method, data management program, and data management program storage medium
CN114240344A (en) Enterprise personnel data processing method and device, computer equipment and storage medium
CN112671614B (en) Method, system, device and storage medium for testing connectivity of association system
CN114049089A (en) Method and system for constructing government affair big data platform
CN113434542A (en) Data relation identification method and device, electronic equipment and storage medium
CN112486957A (en) Database migration detection method, device, equipment and storage medium
CN112685384A (en) Data migration method and device, electronic equipment and storage medium
CN113435169A (en) Electronic seal data configuration method, device, equipment and storage medium
CN111680483A (en) Document template updating method and device, electronic equipment and medium
JP2003186529A (en) Managing device for field equipment
CN113254446B (en) Data fusion method, device, electronic equipment and medium
CN113723813A (en) Performance ranking method and device, electronic equipment and readable storage medium
CN113515265B (en) Site configuration method, device, equipment and computer readable storage medium
CN113434585B (en) Resource preservation method and equipment
CN115102770A (en) Resource access method, device and equipment based on user permission and storage medium
CN112749401A (en) Supervision work management method, system, computer device and storage medium
CN112308440A (en) Work order processing method and device, computer equipment and computer readable storage medium

Legal Events

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