CN109739847A - A kind of examination & approval input method and system based on internal and external line resource - Google Patents
A kind of examination & approval input method and system based on internal and external line resource Download PDFInfo
- Publication number
- CN109739847A CN109739847A CN201811620026.0A CN201811620026A CN109739847A CN 109739847 A CN109739847 A CN 109739847A CN 201811620026 A CN201811620026 A CN 201811620026A CN 109739847 A CN109739847 A CN 109739847A
- Authority
- CN
- China
- Prior art keywords
- data
- approval
- examination
- internal
- external line
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 34
- 238000012550 audit Methods 0.000 claims abstract description 8
- 238000012986 modification Methods 0.000 claims description 15
- 230000004048 modification Effects 0.000 claims description 15
- 238000012795 verification Methods 0.000 claims description 11
- 238000012545 processing Methods 0.000 claims description 4
- 239000003550 marker Substances 0.000 claims description 3
- 238000012360 testing method Methods 0.000 claims 1
- 239000002699 waste material Substances 0.000 abstract description 2
- 239000000463 material Substances 0.000 description 5
- 230000008859 change Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 3
- 238000012937 correction Methods 0.000 description 2
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 235000013399 edible fruits Nutrition 0.000 description 2
- 230000008439 repair process Effects 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 238000007792 addition Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000010606 normalization Methods 0.000 description 1
- 238000012552 review Methods 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention is more particularly directed to a kind of examination & approval input methods and system based on internal and external line resource.The examination & approval input method based on internal and external line resource, the increase carried out to IM system interior lines resource and OSP system outside line resource, the operation being deleted or modified have to pass through approver's audit；Approver verifies the reasonability of data, executes operation if operating through audit, and corresponding operation data enters original database, rejects operation if not passing through, and respective operations data do not allow to be put in storage, and directly abandons.The examination & approval input method and system based on internal and external line resource, substantially increase the accuracy and reasonability of data, while can also effectively prevent the generation of junk data, to reduce the waste of resource.
Description
Technical field
The present invention relates to technical field of data administration, in particular to a kind of examination & approval input method based on internal and external line resource and
System.
Background technique
For the typing mechanism of authority data, needs the increase to resource, modification and delete reasonably to be managed, refuse
Junk data enters resource database.
Resource data is directly entered former resources bank in data access layer by existing Java Web technology, and system is difficult to distinguish
The reasonability and normalization of data, thus a large amount of unreasonable junk datas will be will cause and be full of source material libraries.Simultaneously as
The stock control system is used by many people users, the resource data that these users create, modify or delete all can directly into
Enter resources bank, this, which will will cause a large amount of unreasonable these users of junk data and possesses increase to resource, modification and delete, weighs
Limit.But since the professional standards of different user are limited, the resource created is simultaneously unreasonable, over time, resources bank and space
Library will generate a large amount of junk data
In view of the above-mentioned problems, the invention proposes a kind of examination & approval input methods and system based on internal and external line resource.
Summary of the invention
In order to compensate for the shortcomings of the prior art, the present invention provides a kind of examination & approval based on internal and external line resource being simple and efficient
Input method and system.
The present invention is achieved through the following technical solutions:
A kind of examination & approval input method based on internal and external line resource, it is characterised in that: to IM (Instant Messager, i.e.,
Shi Tongxin) system interior lines resource and OSP (open settlement protocol, open settlement protocol) system outside line resource into
Capable increase, the operation being deleted or modified have to pass through approver's audit；Approver verifies the reasonability of data, if operation passes through
Audit then executes operation, and corresponding operation data enters original database, rejects operation if not passing through, respective operations data do not permit
Perhaps it is put in storage, directly abandons.
Operator, which initiates increase, modification or delete operation to data on foreground, from the background asks operation after submitting operation requests
Data are asked to be handled；It include from the background parsing to the processing of operation requests data, verification, is put into approval form and return executes knot
Fruit, if the reason of executing the data and data operation failure of unsuccessfully wanting marking operation failure.
Since system is associated with ID, the parsing refers to that the information provided according to every operation requests data is looked for
To the corresponding ID of each associated data.
The verification refers to the verifications that full dose data are carried out with all rules, can once verify out whole wrong data and
Whole error reasons of every data modify data for operator and provide convenience.
It is described be put into approval form and refer to carry out being put into examination & approval table handling, people waiting for approval after total data all verifies successfully
It is examined.
When newly-increased data, data are temporarily stored in approval form corresponding to former table, and add note in main approval form
The approver that takes down a confession or testimony during an interrogation checks；Approver's examination & approval pass through, and increase data loading, main approval form record examination & approval time and suggestions made after examination newly.
When modifying data, data are temporarily stored in approval form corresponding to former table, and add and repair in main approval form
Change mark, approver is transferred to examine；It can be seen that the field value of modification and former table data do the displaying compared when approver examines
Mode.
When deleting data, the record of deleted marker is directly done in main approval form, is not put into corresponding approval form；Once
Approver's examination & approval pass through, then system directly goes in original database table to delete former data according to ID, otherwise do not delete former data, reject
The removal request of submitter.
The present invention is based on the systems of the examination & approval input method of internal and external line resource, it is characterised in that: including examination & approval unit and holds
Row unit is equipped with functional switch before the examination & approval unit and locks, the examination & approval unit module parsing module, correction verification module, approval form
Module and mark module；Close functional switch lock can automatic shield examination & approval unit, operation requests data are directly sent to hold
Row unit.
The beneficial effects of the present invention are: being somebody's turn to do examination & approval input method and system based on internal and external line resource, number is substantially increased
According to accuracy and reasonability, while the generation of junk data can also be effectively prevent, to reduce the waste of resource.
Detailed description of the invention
Attached drawing 1 is that the present invention is based on the examination & approval input method schematic diagrames of internal and external line resource.
Specific embodiment
In order to which technical problems, technical solutions and advantages to be solved are more clearly understood, tie below
Drawings and examples are closed, the present invention will be described in detail.It should be noted that specific embodiment described herein is only used
To explain the present invention, it is not intended to limit the present invention.
The examination & approval input method based on internal and external line resource, in IM (Instant Messager, instant messaging) system
The increase of line resource and the progress of OSP (open settlement protocol, open settlement protocol) system outside line resource is deleted
Or the operation of modification has to pass through approver's audit；Approver verifies the reasonability of data, executes behaviour if operating through audit
Make, corresponding operation data enters original database, rejects operation if not passing through, respective operations data do not allow to be put in storage, directly
It abandons.
Operator, which initiates increase, modification or delete operation to data on foreground, from the background asks operation after submitting operation requests
Data are asked to be handled；It include from the background parsing to the processing of operation requests data, verification, is put into approval form and return executes knot
Fruit, if the reason of executing the data and data operation failure of unsuccessfully wanting marking operation failure.
Since system is associated with ID, the parsing refers to that the information provided according to every operation requests data is looked for
To the corresponding ID of each associated data.
The verification refers to the verifications that full dose data are carried out with all rules, can once verify out whole wrong data and
Whole error reasons of every data modify data for operator and provide convenience.
It is described be put into approval form and refer to carry out being put into examination & approval table handling, people waiting for approval after total data all verifies successfully
It is examined.
When newly-increased data, data are temporarily stored in approval form corresponding to former table, and add note in main approval form
The approver that takes down a confession or testimony during an interrogation checks；Approver's examination & approval pass through, and increase data loading, main approval form record examination & approval time and suggestions made after examination newly；
When modifying data, data are temporarily stored in approval form corresponding to former table, and add and repair in main approval form
Change mark, approver is transferred to examine；It can be seen that the field value of modification and former table data do the displaying compared when approver examines
Mode；
When deleting data, the record of deleted marker is directly done in main approval form, is not put into corresponding approval form；Once
Approver's examination & approval pass through, then system directly goes in original database table to delete former data according to ID, otherwise do not delete former data, reject
The removal request of submitter.
The system of the examination & approval input method based on internal and external line resource, including examination & approval unit and execution unit, the examination & approval
It is equipped with functional switch before unit to lock, the examination & approval unit module parsing module, correction verification module, approval form module and mark module；
Close functional switch lock can automatic shield examination & approval unit, operation requests data are directly sent to execution unit.
The resource of the equipment needed for open FTTH business carries out expansion for being increased, modified and being deleted and says below
It is bright.
Step 1, the examination & approval subtabulation for the former table that creation needs to examine, including resource associated in IM system and OSP system
Table.Such as need to create corresponding examination & approval subtabulation IM_RACK_APPROVAL to former Table I M_RACK.Increase field in examination & approval subtabulation
object_id.When carrying out newly-increased operation, object_id can be sky, when user's examination & approval toward source material table by inserting
UUID is regenerated when entering.When carrying out edit operation, object_id can not be for sky.For a plurality of editor's data
It is compared with initial data.
1 IM_RACK_APPROVAL table structure of table
| Field | Attribute paraphrase | Data type | Constraint |
| uuid | Unique identification | String(64) | Major key |
| object_id | Data ID in former table | String(255) | Simple index |
| name | String(64) | ||
| rack_type | Enum | ||
| ……… | Other attributes |
Change operation if it is additions and deletions are carried out to resource based on outside line, also to create subtabulation corresponding in the library of space.Such as
RACK resource then creates outside the corresponding subtabulation of corresponding resource table, it is also necessary to create spatial table if it is what is created on OSP
Subtabulation ALL_DEVICE_APPROVAL corresponding to ALL_DEVICE, it is waiting for approval for data operated by deposit operation people
People examines.
Also need to create a trial batch Table I M_APPROVAL simultaneously.Approver initially enters in main approval form, trial batch
Each record in table corresponds to the respective record in subtabulation.Approver is checked by clicking details.
The trial batch of table 2 Table I M_APPROVAL
Step 2, foreground show function:
After the user with the power of examination and approval logs in, it can be seen that To-do List (pending batch data work order),
Reject List (the data work order of rejection) and Archived List (the data work order examined).Use with the power of examination and approval
Family can also submit data work order and examine.
User without operating right can only see My WO file.It can only check the data work order oneself submitted, and
Check data work order that is copending, rejecting and pass through.
Approver, which clicks Detail, can enter the details page of data work order.
What deletion detail page and newly-increased detail page were shown is all the specifying information of resource.
Editor's detail page will show the data after initial data and editor, be red by the field mark for needing to modify.
Details page also is used to fill in the text box of the suggestions made after examination of approver, is recorded in main approval form
In approval_record field, checked for submitter.
Step 3, data submit process:
Delete: user's examination & approval pass through, and background program can be according to the rejection number recorded in main approval form (im_approval table)
It directly goes to delete data in resource table according to object_id.
Update: user's examination & approval pass through, and background program can remove resource approval table by object_id in im_approval table
(im_xxx_approval) data is found in table, and according to object_id (the source material table in resource approval table
In uuid) go in source material table to update (renewal process only change the field modified).
Newly-increased: user's examination & approval pass through, and background program can remove resource approval table by object_id in im_approval table
In find the data, the data is then inserted into source material table and generates uuid at this moment.
Step 4, permission control process:
Function is shown for data work order, judges the permission for logging in people from the background.If logging in people only has modification authority, journey
Sequence can match modification people (operator) in main approval form (im_approval table) and work order state goes to screen all data works
It is single.
If logging in the existing modification authority of people also has the power of examination and approval, pending batch data work order To-do List can match trial
All data work orders that do not examine of table are criticized, it is to step on that the data work order Reject List of rejection, which can match approver in main approval form,
It records people and is in the work order of rejection state, the data work order Archived List examined can be matched to be examined in main approval form
People is the work order for logging in people and being in filing state.
Step 5, logic are realized:
Into the data access layer of data loading, scene locating for the system is first determined whether.If it is the field of Saudi Arabia's electric power
Scape will then increase examination & approval function in the operation of data loading.The name of database table is changed to corresponding examination & approval subtabulation.If it is
Newly-increased operation.Then the object_id in subtabulation is set as empty, operates if it is modification, then object_id stores the former number modified
According to uuid.Newly-increased and modification operation is required to insert record into main approval form.If it is delete operation, then master is directly entered
In approval form, the uuid for the former data that the object_id storage of main approval form needs to delete.
Examination & approval function is realized on backstage.Method including obtaining the data information of all main approval forms
The method that queryApprovalList, the method queryApprovalDetail for obtaining details page, processing are examined
HandleApproval, calls different methods according to different situations respectively, including addObject, modifyObject,
Tri- methods of deleteObject.
If data source is OSP, examination & approval need to be added the number in corresponding examination & approval subtabulation into former spatial table after passing through
According to.Main four spatial tables in the library of space include ALL_DEVICE, ALL_STRUCT_P, ALL_STRUCT_L, ALL_
CABLESEG。
Foreground includes two jsp pages.Including two pages of approvalList.jsp and approvalDetail.jsp
With corresponding js file.Foreground Data presentation uses jqGrid plug-in unit, easyui frame.
Data displaying is carried out using jqGrid plug-in unit in approvalList.jsp, the page is accessed and is gone back after access first
Controller layers of platform of queryApprovalList method, and then using foreground bring parameter value as Service layers of access
Parameter access service layer.Major parameter includes that approver still modifies people, copending to do or reject or archived
Mark.Show different approval lists respectively according to these parameters.
The page further includes inquiry button, and querying condition input field, refresh button and batch examination & approval pass through and batch is examined
The button of rejection.
The detail column of every a line record increase a Detail button, by clicking the button, by the row record must
It wants field value such as to examine corresponding uuid of subtabulation etc. as Controller layers of parameter access backstage, is able to enter the record
The details page that data are shown in corresponding examination & approval subtabulation.
In the approvalDetail.jsp page, approver can carry out review operation, it can be seen that by and reject
Button and suggestions made after examination Text Entry.Operator, that is, submitter of data cannot see that examination & approval button and suggestions made after examination
Input frame, that is, can only carry out checking approval status and suggestions made after examination.
Claims (9)
1. a kind of examination & approval input method based on internal and external line resource, it is characterised in that: outside to IM system interior lines resource and OSP system
The increase of line resource progress, the operation being deleted or modified have to pass through approver's audit；Approver verifies the reasonability of data, if
Operation then executes operation by audit, and corresponding operation data enters original database, rejects operation, respective operations if not passing through
Data do not allow to be put in storage, and directly abandon.
2. the examination & approval input method according to claim 1 based on internal and external line resource, it is characterised in that: operator is on foreground
Increase, modification or delete operation is initiated to data from the background to handle operation requests data after submitting operation requests；From the background
Processing to operation requests data includes parsing, and verification is put into approval form and returns to implementing result, if executing will unsuccessfully mark
The reason of data and data operation failure of operation failure.
3. the examination & approval input method according to claim 2 based on internal and external line resource, it is characterised in that: since system is to use
What ID was associated, it is corresponding that the parsing refers to that the information provided according to every operation requests data finds each associated data
ID。
4. the examination & approval input method according to claim 2 based on internal and external line resource, it is characterised in that: the verification refers to
The verification that full dose data are carried out with all rules, all mistakes that can once verify out whole wrong data and every data are former
Cause modifies data for operator and provides convenience.
5. the examination & approval input method according to claim 2 based on internal and external line resource, it is characterised in that: described to be put into examination & approval
Table, which refers to, carries out being put into after total data all verifies successfully examination & approval table handling, and people waiting for approval examines.
6. the examination & approval input method according to claim 2 based on internal and external line resource, it is characterised in that: when newly-increased data,
Data are temporarily stored in approval form corresponding to former table, and addition record is checked for approver in main approval form；Examination & approval
People's examination & approval pass through, and increase data loading, main approval form record examination & approval time and suggestions made after examination newly.
7. the examination & approval input method according to claim 2 based on internal and external line resource, it is characterised in that: when modification data,
Data are temporarily stored in approval form corresponding to former table, and add modified logo in main approval form, approver is transferred to examine
Batch；It can be seen that the field value of modification and former table data do the exhibition method compared when approver examines.
8. the examination & approval input method according to claim 2 based on internal and external line resource, it is characterised in that: when deleting data,
The record that deleted marker is directly done in main approval form, is not put into corresponding approval form；Once approver's examination & approval pass through, then it is
System directly goes in original database table to delete former data according to ID, does not otherwise delete former data, rejects the removal request of submitter.
9. the system of the examination & approval input method according to claims 1 to 8 based on internal and external line resource, it is characterised in that: packet
Examination & approval unit and execution unit are included, functional switch is equipped with before the examination & approval unit and locks, the examination & approval unit module parsing module, school
Test module, approval form module and mark module；Close functional switch lock can automatic shield examination & approval unit, operation requests number
According to being directly sent to execution unit.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811620026.0A CN109739847A (en) | 2018-12-28 | 2018-12-28 | A kind of examination & approval input method and system based on internal and external line resource |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811620026.0A CN109739847A (en) | 2018-12-28 | 2018-12-28 | A kind of examination & approval input method and system based on internal and external line resource |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109739847A true CN109739847A (en) | 2019-05-10 |
Family
ID=66361710
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811620026.0A Pending CN109739847A (en) | 2018-12-28 | 2018-12-28 | A kind of examination & approval input method and system based on internal and external line resource |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109739847A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111191961A (en) * | 2020-01-10 | 2020-05-22 | 山东浪潮商用***有限公司 | Method and system for changing process |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101309177A (en) * | 2008-07-11 | 2008-11-19 | ***通信集团云南有限公司 | Network resource data management method and system |
| CN108876074A (en) * | 2017-05-09 | 2018-11-23 | 国网辽宁省电力有限公司信息通信分公司 | A kind of general-purpose scheduler method suitable for multiclass resource bid examination & approval |
| US20180341671A1 (en) * | 2017-05-24 | 2018-11-29 | Babu Mathalikunnel Sebastian | Auditing enterprise resource planning (erp) systems |
-
2018
- 2018-12-28 CN CN201811620026.0A patent/CN109739847A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101309177A (en) * | 2008-07-11 | 2008-11-19 | ***通信集团云南有限公司 | Network resource data management method and system |
| CN108876074A (en) * | 2017-05-09 | 2018-11-23 | 国网辽宁省电力有限公司信息通信分公司 | A kind of general-purpose scheduler method suitable for multiclass resource bid examination & approval |
| US20180341671A1 (en) * | 2017-05-24 | 2018-11-29 | Babu Mathalikunnel Sebastian | Auditing enterprise resource planning (erp) systems |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111191961A (en) * | 2020-01-10 | 2020-05-22 | 山东浪潮商用***有限公司 | Method and system for changing process |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110442851B (en) | Document automatic modularization and multi-terminal independent right-limiting editing method based on Office Word | |
| KR100738603B1 (en) | System, method, and computer readable medium for electronically managing privileged and non-privileged documents | |
| DE69316631T2 (en) | SCREENPLAY BASED SYSTEM FOR TESTING A MULTI-USER COMPUTER SYSTEM | |
| US7043714B2 (en) | Method, system, and program for using objects in data stores during execution of a workflow | |
| DE69329869T2 (en) | Procedure for signing migrating programs | |
| US7600182B2 (en) | Electronic data capture and verification | |
| CN108600148B (en) | Transaction message processing method and device | |
| US7401085B2 (en) | System and method for controlling the release of updates to a database configuration | |
| CN107862049B (en) | Data additional recording method and device | |
| EP0633538A2 (en) | Relational database management system | |
| JPH04289920A (en) | Method and device for controlling data object version affected by engineering change | |
| JPH11296544A (en) | Structured data management system and computer-readable recording medium where structured data management program is recorded | |
| CN106952073A (en) | Assessment for cleaner production digitized information system | |
| JPH05197734A (en) | Data processing system | |
| CN113849492B (en) | System for providing standardized data quality check for multi-scene service | |
| JP2008123432A (en) | Software asset management system | |
| CN109739847A (en) | A kind of examination & approval input method and system based on internal and external line resource | |
| JP2006268661A (en) | Data import method and data import device | |
| US8521698B2 (en) | Method for safeguarding the integrity of a relational database in case of structural transaction execution | |
| US7100126B2 (en) | Electrical form design and management method, and recording medium | |
| CN114911773B (en) | Universal meta-model design method | |
| US11256557B1 (en) | Efficient processing of rule-based computing workflows | |
| US20230195792A1 (en) | Database management methods and associated apparatus | |
| US7539554B2 (en) | Tape out template system and method | |
| JP2008052347A (en) | Document processor and document processing program |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190510 |
|
| RJ01 | Rejection of invention patent application after publication |