CN104461531B - A kind of implementation method of reporting system SQL - Google Patents
A kind of implementation method of reporting system SQL Download PDFInfo
- Publication number
- CN104461531B CN104461531B CN201410722935.0A CN201410722935A CN104461531B CN 104461531 B CN104461531 B CN 104461531B CN 201410722935 A CN201410722935 A CN 201410722935A CN 104461531 B CN104461531 B CN 104461531B
- Authority
- CN
- China
- Prior art keywords
- sql
- parameter
- associated storage
- storage process
- name
- 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.)
- Expired - Fee Related
Links
Landscapes
- Stored Programmes (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses reporting system SQL implementation method, comprise the following steps:Step 1):SQL and parameter registration;Step 2):SQL associated storage process is created;Step 3):SQL is used in form;Step 4):Recognize the SQL in form;Step 5):Identification variables are with replacing in SQL parameter list;Step 6):Prepare parameter and call SQL associated storage process;Step 7):Perform SQL associated storage process and returning result;Step 8):Receive SQL associated storage process returning result and be applied in form.The technical threshold that the present invention creates SQL is relatively low, the design that reports user only needs to be familiar with storing process can just create SQL, as long as registering the title and parameter information of SQL in designer and submitting and establishment and deployment that associated storage process just completes SQL are created in database.
Description
Technical field
The present invention relates to computer software application field, more particularly to a kind of realization side of reporting system SQL
Method.
Background technology
SQL function is one of critical function of business report system, and it allows Report Form Design person or reports user
Used when form transfer function and business processing logic are packaged as into the form of function for design form, realize code reuse and spy
Determine the characteristic demand of application field.
Form is the essential part of enterprise application software, the exploitation of form for convenience, all kinds of form development systems
In a number of system function is both provided to complete the function that some are general, such as Mathematical treatment, string processing, date lattice
Formula conversion etc..But in actual applications, according to the specific needs of application field, Report Form Design person also need to often use some be
The function that does not have in system function, the date format conversion or number format conversion of such as specific format, and with applied business logic
Related processing function, these functions are accomplished by Report Form Design person's designed, designed and supply its Reusability into SQL.
In the business report system of current main-stream, the method that design SQL is provided mostly.Microsoft
There is provided SQL in crystal report (Crystal Report) system in Visual Studio IDEs
Editing machine designs SQL for user, can be published in the warehouse of reporting system and be set with every other after the completion of design
Meter person is shared to be used.Crystal report SQL design and issue it is all fairly simple, but need to use VISUAL BASIC or
The special programming language of crystal report is write, and has many restrictions to code function, can not be used such as in SQL
Form or Database field, this greatly limits the application of SQL.
Profit universe reporting system, outstanding table reporting system and X5 forms platform are all the parsings that WEB forms are developed with JAVA language
Engine, therefore, they are required to SQL and developed using JAVA language, and it is configured using also will be according to certain regular right
Configuration file enters edlin.For example the flow of one SQL of addition is as follows in profit universe reporting system:
1st, the java classes of SQL are write, are inherited
This class of com.runqian.report4.model.expression.Function.
2nd, under the config catalogues of java class.path, customFunctions.properties files are found, and
The registration of SQL class and function name is carried out wherein.
3rd, at designer end, by customFunctions.properties files copy to designer web WEB-
INF classes under config, by class file copy to designer web WEB-INF under classes, have bag name, phase
The Jian Bao paths answered.
4th, in web terminal, by customFunctions.properties files copy to webapps demo WEB-
INF classes under config, by class file copy to webapps demo WEB-INF under classes, have bag name,
Corresponding Jian Bao paths.
5th, designer is restarted.
6th, SQL is used in designer.
Above-mentioned SQL implementation method advantage is powerful, the volume that JAVA programming languages can be made full use of to provide
Cheng Nengli, form translation function and business logic processing function to user are all easier to realize.
Also a kind of implementation of SQL simply can design and apply SQL【1】.It is square herein
In case, SQL four-tuple Fun={ SQL name, SQL query statement, input parameter number, output parameter
Number } define, the function of function is realized that reports user need to only write this SQL query statement by SQL query statement therein, without
Use other programming languages.After above-mentioned SQL four-tuple is all determined, so that it may be submitted to database, for other forms
Family is shared to be used.It can be embedded in when using as system function in expression formula.The SQL resolving of this scheme
It is as follows:
1st, the identification variables in the expression formula comprising SQL and replacement, all variables all replace with specific value,
Prepared for SQL evaluation.
2nd, the SQL in recognition expression formula.
3rd, by the User-Defined Functions function name stored in database, corresponding SQL query statement and parameter are found
Number information is compared with the variable number obtained, to verify whether variable-definition number is correct.
4th, the parametric variable in SQL query statement is replaced with the actual parameter value of the SQL in expression formula.
5th, SQL query statement of the previous step after variable replacement is performed, return value, i.e. asking as SQL is obtained
Value result replaces its appearance in expression formula.
For profit universe reporting system, the outstanding SQL realization side based on JAVA such as table reporting system and X5 form platforms
Method, its major defect is:
The technical threshold for creating SQL is higher.Various reporting systems require user when designing SQL
Using the programming language specified and by defined said shank, it is necessary to which the SQL of database manipulation also GPRS SQL is compiled
Journey.
The deployment of SQL is complicated, and when SQL is more, workload is big and error-prone.
For with four-tuple Fun={ SQL name, SQL query statement, input parameter number, output parameter number }
The SQL scheme of realization, its main deficiency is function limitation, and SQL is performed and result is obtained and all passed through
What SQL query statement was realized, it is difficult to realize the SQL function of including service logic rule.In addition it is also efficient low
Shortcoming, i.e., perform SQL query statement database server and be required for carrying out syntax check to it every time.
The SQL function of the current each main flow reporting system of comprehensive analysis is realized, it is found that there are the following problems:
The technical threshold for creating SQL is higher.Various reporting systems require user when designing SQL
Using the programming language specified and by defined said shank, it is necessary to which the SQL of database manipulation also GPRS SQL is compiled
Journey.This means common Report Form Design person and user may need one new programming language and its developing instrument of study to set
Count SQL.
The deployment of SQL is complicated.During the SQL deployment of various reporting systems, generally involve
The establishment of multiple files and editor, and to put it under specified file path, some reporting systems also need to restarting and set
Gauge is to allow SQL to come into force, and process is complicated, and when SQL is more, workload is big and error-prone.
The content of the invention
Present invention aims at provide it is a kind of with relatively low technical threshold and simple deployment way to solve background technology
The reporting system SQL implementation method of the technical problem referred to.
The technical scheme that the present invention is provided is:A kind of reporting system SQL implementation method, comprises the following steps:
Step 1):SQL and parameter registration.This step is completed on the function interface of Report Designer.Form is set
Meter person need to provide name, the parameter name of number of parameters and each parameter and its description of SQL, then be submitted to system
Database can complete enrollment process.Reporting system function is recognized with prefix $, and SQL is recognized with prefix $ $, such as one
If individual function shape such as $ FUNC (), are system functions, if shape such as $ $ FUNC (), are SQLs.This increase prefix
Function naming method is conducive to distinguishing common parenthesized expression, system function and SQL.
Step 2):SQL associated storage process is created.This step is completed in data base management system.It is all from
The function of defined function is all realized by its related storing process.The name of SQL associated storage process is self-defined letter
Several words remove prefix and obtained, such as the entitled myFunc () of SQL, then the entitled myFunc of its associated storage process
The related definition method of (), this function name and storing process name can be directly from making by oneself when ensure that parsing SQL
Adopted function name obtains its associated storage procedure name, without being retrieved from database.All SQL associated storage processes
Parameter list using unified form myFunc (inParams, outParam), no matter SQL includes how many parameters,
But its associated storage process only includes an input parameter and an output parameter, input parameter is used to transmit to storing process
Parameter value, if SQL has multiple parameters, this multiple parameters, which is grouped together, is transferred to input parameter, output parameter
For returning to storing process implementing result.Processing logic during SQL associated storage is comprised the following steps:A) connect
Input parameter is received, the multiple parameters combined are resolved into single parameter;B type conversion, conversion) are carried out to each parameter
Into the data type of needs;C the processing logic of SQL) is performed;D) implementing result is set to output parameter and returned.
Step 3):SQL is used in form.This step is completed in Report Designer.Used certainly in form
Defined function is fairly simple, and the form defined in step 1 according to it is used alone or in expression formula.
Step 4):Recognize the SQL in form.This step is parsed in form and completed with creating in engine.In form
In expression parsing evaluation process, the prefix naming rule named according to SQL recognizes SQL therein, carried
Take out preparation parsing.
Step 5):Identification variables are with replacing in SQL parameter list.This step is parsed with creating engine in form
It is middle to complete.In the parameter list for the SQL that step 4 is extracted, possible comprising variable, constant and other functions.This step
Including following sub-step:Variable therein and other functions are identified;The actual value of variable in parameter is asked for, in parameter
Function calculate and obtain end value;Its appearance in parameter list is replaced with the actual value of parametric variable, with parameter
The execution result value of function replaces its appearance in parameter list.By above-mentioned steps, in the parameter list of SQL
Only include constant.
Step 6):Prepare parameter and call SQL associated storage process.This step is drawn in form parsing with establishment
Hold up middle completion.Comprise the following steps:Prepare the input parameter of SQL associated storage process.By obtained in step 5
Parameter list containing constant removes front and rear bracket, is assigned to input parameter;The output of SQL associated storage process is set
Parameter;Remove the prefix $ $ of SQL name, be used as storing process name;Visited using storing process name and parameter setting data storehouse
Component is asked, submits storing process to be performed to database server.
Step 7):Perform SQL associated storage process and returning result.This step is in data base management system
Realize.
Step 8):Receive SQL associated storage process returning result and be applied in form.This step is in form
Parsing is completed with creating in engine.
The beneficial effects of the invention are as follows:
A kind of reporting system SQL processing scheme that the present invention is provided, its core concept is all self-defined letters
Number is realized by database store process.Various commercial database management systems both provide the mechanism of design storing process, its
In comprising various flow control mechanisms, a large amount of format analysis processing functions, mathematical function and date function etc., while can directly operate
SQL statement.After storing process is it is further an advantage that once compile, repeat later without compiling again, execution efficiency compared with
Height, and compilation operations will be performed by being submitted to other programming languages before the SQL query statement of Database Systems is performed every time.
Advantages of the present invention includes:(1) technical threshold for creating SQL is relatively low, and reports user only needs to be familiar with depositing
The design of storage process can just create SQL, and the method letter of storing process is created in various data base management systems
Single, grammer is approached.User is without using other programming tools and programming language.(2) SQL deployment is simple, as long as setting
The title and parameter information of SQL are registered in gauge and submits and associated storage process is created in database just
Complete the establishment and deployment of SQL.
Brief description of the drawings
When considered in conjunction with the accompanying drawings, by referring to following detailed description, can more completely more fully understand the present invention with
And the adjoint advantage of many of which is easily learnt, but accompanying drawing described herein is used for providing a further understanding of the present invention,
The part of the present invention is constituted, schematic description and description of the invention is used to explain the present invention, do not constituted to this hair
Bright improper restriction, wherein:
Fig. 1 is the overall procedure block diagram of the reporting system SQL implementation method of the present invention;
Fig. 2 is the FB(flow block) of SQL associated storage process internal handling process;
Fig. 3 is identification variables and the FB(flow block) of replacement in SQL parameter list;
Fig. 4 is the FB(flow block) for preparing parameter and calling SQL associated storage process.
Embodiment
In order to facilitate the understanding of the purposes, features and advantages of the present invention, it is below in conjunction with the accompanying drawings and specific real
Applying mode, the present invention is further detailed explanation.
Refer to the attached drawing, illustrates the technical side of the present invention with the detailed process of definition and the parsing of a SQL below
Case.
It is assumed that needing a SQL to give tacit consent to date format " 08/25/2014 " is converted to Chinese date format, such as
" 2014 on August 25, ", with reference to the accompanying drawings 1, following steps will be passed through:ChnDate (today (), ' YYYY MM
The DD days moon ') same day date format is turned into Chinese date format.
Step 1):SQL and parameter registration.Registration SQL be $ $ chnDate (oldDate,
Format), $ $ chnDate are SQL names, and oldDate is the date to be converted of default form, and format is to expect to turn
The form changed into.
Step 2):SQL associated storage process is created.A storing process is created in data base management system,
Shape such as chnDate (inParams, outParam), inParams are input parameters, and outParam is output parameter, is character
String type.The processing logic of accompanying drawing 2 is realized in storing process chnDate, the old date to using CSV in inParams
And two parameter values of desired format resolve into the parameter value of two character string types, and date type and structure class are converted into respectively
Type, is then handled it and is set implementing result to output parameter outParam returns.
Step 3):SQL is used in form.Using example such as
$ STRCAT (" date printeds:", $ $ chnDate ($ TDODAY (), ' YYYY MM months DD day ')), wherein system letter
Number $ STRCAT () are used for two string-concatenations into a character string, and system function $ TDODAY () are used to obtain acquiescence lattice
The current date of formula, if current date is " 08/25/2014 ", above-mentioned example will obtain character string " date printed:201
On August 25th, 4 ".The number of parameters of SQL should be identical with what is registered in step 1.
Step 4):Recognize the SQL in form., can be very according to SQL prefix and parenthesis matching relation
Readily recognize $ STRCAT (" date printeds:", $ $ chnDate ($ TDODAY (), ' YYYY MM months DD day ')) in make by oneself
Adopted function $ $ chnDate ($ TDODAY (), ' YYYY MM months DD day ').
Step 5):Identification variables are with replacing in SQL parameter list.$ $ chnDate ($ TDODAY (), ' YYYY
MM months DD day ') in, its parameter list is " $ TDODAY (), ' YYYY MM months DD day ' ", wherein $ TDODAY () are system letter
Number is, it is necessary to evaluation, it is assumed that evaluation obtains result:08/25/2014, $ TDODAY () are replaced in $ $ chnDate ($ TDODAY with it
(), ' YYYY MM months DD day ') in appearance, obtain $ $ chnDate (' 08/25/2014 ', ' YYYY MM months DD day ').Extremely
This, only includes constant in the parameter list of SQL.
Step 6):Prepare parameter and call SQL associated storage process.Comprise the following steps:1st, SQL
The input parameter value of associated storage process is " ' 08/25/2014 ', ' YYYY MM months DD day ' ".2nd, SQL is set to close
Join the output parameter of storing process;3rd, the name using chnDate as storing process;4th, using storing process name and parameter setting data
Storehouse accesses component, submits storing process to be performed to database server.
Step 7):Perform step 6) in set storing process and returning result, herein returning result be " in 2014
August 25 ".
Step 8):Receiving step 7) in storing process returning result and be applied in form expression formula, i.e., by step 7) return
Return result and replace SQL $ $ chnDate ($ TDODAY (), ' YYYY MM months DD day ') (" beaten in expression formula $ STRCAT
Print the date:", $ $ chnDate ($ TDODAY (), ' YYYY MM months DD day ')) in appearance, obtain $ STRCAT (" printing day
Phase:", " 2014 on August 25, "), so far, SQL parsing terminates.
The present invention can also have other alternate embodiments, such as:
In step 1) in, the name of SQL can also be without special prefix, then can when Report Engine is parsed
Obtain the name list of all system functions and SQL from system database with elder generation, then with the function used in form
It is compared.
In step 2) in, the storing process name of SQL association can also be saved in SQL in database
, then can be without derived relation between storing process name and its association SQL name in record, its incidence relation can be from
SQL is found in the register information in database.Then when calling associated storage process for SQL will first from
The storing process name of SQL association is obtained in database.In addition, the processing logic of SQL can also use number
Realized according to the User Defined SQL function in the system of storehouse, with being using storing process difference, the result in storing process
Returned by output parameter, and result is returned by function return value in User Defined SQL function.
The description of the above examples is only intended to facilitate the understand of the core idea of the present invention;Simultaneously for the general of this area
Technical staff, according to the thought of the present invention, will change in specific embodiments and applications, in summary,
This specification content should not be construed as limiting the invention.
Claims (2)
1. a kind of reporting system SQL implementation method, it is characterised in that comprise the following steps:
Step 1):SQL and parameter registration;On the function interface of Report Designer, Report Form Design person provides self-defined
Name, the parameter name of number of parameters and each parameter and its description of function, are then submitted to system database;SQL
Recognized with prefix $ $;
Step 2):SQL associated storage process is created;In data base management system, the function of all SQLs
All realized by its related storing process;The name of SQL associated storage process is that SQL name removes prefix
$ $ and obtain;The parameter list of all SQL associated storage processes is using unified form;Associated storage process is only wrapped
Containing an input parameter and an output parameter, input parameter is used for storing process Transfer Parameters value, if SQL has
Multiple parameters, then this multiple parameters, which is grouped together, is transferred to input parameter, and output parameter is used to return to storing process execution
As a result;
Step 3):SQL is used in form;In Report Designer, defined in step 1 according to SQL
Form be used alone or in expression formula;
Step 4):Recognize the SQL in form;In form expression parsing evaluation process, ordered according to SQL
The prefix naming rule of name, recognizes SQL therein, extracts preparation parsing;
Step 5):Identification variables are with replacing in SQL parameter list;Step 4) parameter of SQL that extracts
In list, variable therein and other functions are identified;The actual value of variable in parameter is asked for, the function in parameter is entered
Row calculating obtains end value;Replace its appearance in parameter list with the actual value of parametric variable, held with function in parameter
Row end value replaces its appearance in parameter list;Only included by above-mentioned steps, in the parameter list of SQL normal
Amount;
Step 6):Prepare parameter and call SQL associated storage process;Comprise the following steps:
Prepare the input parameter of SQL associated storage process, by step 5) in the obtained parameter list containing only constant remove
Front and rear bracket, is assigned to input parameter;
The output parameter of SQL associated storage process is set;
Remove the prefix $ $ of SQL name, be used as storing process name;
Component is accessed using storing process name and parameter setting data storehouse, submits storing process to be performed to database server;
Step 7):Perform SQL associated storage process and returning result;
Step 8):Receive SQL associated storage process returning result and be applied in form.
2. a kind of reporting system SQL implementation method according to claim 1, it is characterised in that step 2) in,
Processing logic during SQL associated storage is comprised the following steps:
A input parameter) is received, the multiple parameters combined are resolved into single parameter;
B type conversion) is carried out to each parameter, the data type needed is converted into;
C the processing logic of SQL) is performed;
D) implementing result is set to output parameter and returned.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410722935.0A CN104461531B (en) | 2014-12-02 | 2014-12-02 | A kind of implementation method of reporting system SQL |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410722935.0A CN104461531B (en) | 2014-12-02 | 2014-12-02 | A kind of implementation method of reporting system SQL |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104461531A CN104461531A (en) | 2015-03-25 |
CN104461531B true CN104461531B (en) | 2017-11-07 |
Family
ID=52907642
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410722935.0A Expired - Fee Related CN104461531B (en) | 2014-12-02 | 2014-12-02 | A kind of implementation method of reporting system SQL |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104461531B (en) |
Families Citing this family (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106227896A (en) * | 2016-08-28 | 2016-12-14 | 杭州合众数据技术有限公司 | A kind of big data visualization fractional analysis method |
CN108255967B (en) * | 2017-12-26 | 2021-03-02 | 平安科技(深圳)有限公司 | Method and device for calling storage process, storage medium and terminal |
CN108536400A (en) * | 2018-04-12 | 2018-09-14 | 珠海横琴盛达兆业科技投资有限公司 | A kind of pharmacy's receipt Method of printing based on jatoolsPrinter |
CN110083386B (en) * | 2019-04-04 | 2024-03-19 | 平安普惠企业管理有限公司 | Random number generation control method, device, computer equipment and storage medium |
CN109992259B (en) * | 2019-04-15 | 2020-10-30 | 成都四方伟业软件股份有限公司 | Function dynamic creating method and device and electronic equipment |
CN111708992B (en) * | 2020-05-06 | 2023-07-14 | 咪咕文化科技有限公司 | Report data access method and device, electronic equipment and storage medium |
CN112416322A (en) * | 2020-11-20 | 2021-02-26 | 城云科技(中国)有限公司 | Implementation method for acquiring previous data in data set according to self-circulation function |
CN115794043B (en) * | 2023-01-31 | 2023-06-09 | 帆软软件有限公司帆软南京分公司 | System and method for calculating table data aggregation processing of BI tool |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101710273A (en) * | 2009-10-28 | 2010-05-19 | 金蝶软件(中国)有限公司 | Method and device for analyzing multi-dimensional query sentence in online analysis processing server |
CN102096664A (en) * | 2009-12-09 | 2011-06-15 | 新奥特(北京)视频技术有限公司 | Report generating method |
CN102436498A (en) * | 2011-11-14 | 2012-05-02 | 深圳市华力特电气股份有限公司 | Report form generating method and relative device |
US8656367B1 (en) * | 2011-07-11 | 2014-02-18 | Wal-Mart Stores, Inc. | Profiling stored procedures |
-
2014
- 2014-12-02 CN CN201410722935.0A patent/CN104461531B/en not_active Expired - Fee Related
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101710273A (en) * | 2009-10-28 | 2010-05-19 | 金蝶软件(中国)有限公司 | Method and device for analyzing multi-dimensional query sentence in online analysis processing server |
CN102096664A (en) * | 2009-12-09 | 2011-06-15 | 新奥特(北京)视频技术有限公司 | Report generating method |
US8656367B1 (en) * | 2011-07-11 | 2014-02-18 | Wal-Mart Stores, Inc. | Profiling stored procedures |
CN102436498A (en) * | 2011-11-14 | 2012-05-02 | 深圳市华力特电气股份有限公司 | Report form generating method and relative device |
Also Published As
Publication number | Publication date |
---|---|
CN104461531A (en) | 2015-03-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104461531B (en) | A kind of implementation method of reporting system SQL | |
US7757220B2 (en) | Computer interchange of knowledge hierarchies | |
US7870221B2 (en) | Multiple bindings in web service data connection | |
US9588742B2 (en) | Rule-based automatic class generation from a JSON message | |
CN107273122A (en) | Based on decoupling mechanism can iteration set up operation system method and its terminal | |
CN108694214A (en) | Generation method, generating means, readable medium and the electronic equipment of data sheet | |
CN110276074B (en) | Distributed training method, device, equipment and storage medium for natural language processing | |
CN104901845B (en) | Domain name WHOIS automatizations of service test system and method | |
CN107506190A (en) | XML file amending method and device based on Spring frameworks | |
CN105005543A (en) | Interface generation apparatus and method | |
CN109299074A (en) | A kind of data verification method and system based on templating data base view | |
CN115017182A (en) | Visual data analysis method and equipment | |
CN114386853A (en) | Data auditing processing method, device and equipment based on universal auditing model | |
Bojinov | RESTful Web API Design with Node. js 10: Learn to create robust RESTful web services with Node. js, MongoDB, and Express. js | |
CN105302556A (en) | Calculation realization method and system and server apparatus | |
CN102567517A (en) | Device and method for issuing data of database | |
Shan et al. | Towards integrated service adaptation a new approach combining message and control flow adaptation | |
CN111008011A (en) | System builder for power platform application development | |
CN109614084A (en) | Web program and its Quick Development Framework, development approach and relevant device | |
CN103399746B (en) | Information management system convenient to develop secondarily and development method | |
CN102486731A (en) | Method, device and system for enhancing visualization of software call stack of software | |
CN102663614B (en) | Customer relation management is to the collocation method of service release and system | |
US20080022258A1 (en) | Custom database system and method of building and operating the same | |
US8631393B2 (en) | Custom database system and method of building and operating the same | |
CN110489109A (en) | The method and device of code reuse |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CF01 | Termination of patent right due to non-payment of annual fee | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20171107 Termination date: 20201202 |