WO2020199599A1 - Information presentation method and apparatus for work queue, and computer device and storage medium - Google Patents

Information presentation method and apparatus for work queue, and computer device and storage medium Download PDF

Info

Publication number
WO2020199599A1
WO2020199599A1 PCT/CN2019/118382 CN2019118382W WO2020199599A1 WO 2020199599 A1 WO2020199599 A1 WO 2020199599A1 CN 2019118382 W CN2019118382 W CN 2019118382W WO 2020199599 A1 WO2020199599 A1 WO 2020199599A1
Authority
WO
WIPO (PCT)
Prior art keywords
field
specific
work queue
information
fixed
Prior art date
Application number
PCT/CN2019/118382
Other languages
French (fr)
Chinese (zh)
Inventor
王旭
李泽超
Original Assignee
平安科技(深圳)有限公司
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 平安科技(深圳)有限公司 filed Critical 平安科技(深圳)有限公司
Publication of WO2020199599A1 publication Critical patent/WO2020199599A1/en

Links

Classifications

    • 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/24Querying
    • G06F16/248Presentation of query results

Definitions

  • This application relates to the technical field of function optimization, and in particular to a method, device, computer equipment, and storage medium for displaying information on a work queue.
  • the business data of work queues are fixed display field values.
  • editing operations such as addition, deletion, or modification cannot be performed according to user needs, and it is difficult to meet the needs of users for dynamic configuration.
  • the purpose of this application is to at least solve one of the above technical defects, especially the technical defect that the work queue field in the prior art cannot be dynamically configured according to customer needs.
  • This application provides a method for displaying work queue information, including the following steps:
  • the configuration page is a pre-configured page for configuring the specific field
  • the step of extracting the corresponding specific field from the database according to the user's editing operation to edit the fixed field of the work queue on the configuration page includes:
  • the step of using the specific field to edit the fixed field of the work queue on the configuration page includes:
  • the specific field is displayed on the configuration page; and the fixed field of the work queue is edited by using the displayed specific field; wherein, the editing includes at least one of adding, deleting, or modifying.
  • the step of using the specific field to edit the fixed field of the work queue includes:
  • the field information is compared with the specific field, and the field information is edited according to the comparison result.
  • the step of obtaining field information corresponding to the position of the specific field in the fixed field includes:
  • the first characteristic information is matched with the second characteristic information, and the field information is obtained according to the matching result.
  • the step of querying the field value corresponding to the specific field in the database includes:
  • the SQL sentence is dynamically spliced according to the field information, and the field value of the dynamically spliced SQL sentence is queried from the database.
  • the method before returning the field value to the configuration page, the method further includes:
  • This application also provides a work queue information display device, which includes:
  • the first obtaining module is configured to obtain the registration information of each customer, generate a plurality of specific fields according to the registration information, and pre-store the specific fields in the database of the work queue;
  • the second obtaining module is configured to obtain fixed fields of the work queue and synchronize the fixed fields to a configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field;
  • the editing processing module is configured to extract corresponding specific fields from the database according to the user's editing operation to edit the fixed fields of the work queue on the configuration page;
  • a query module configured to query the field value corresponding to the specific field in the database, and return the field value to the configuration page;
  • the display module is used to place the field value in the corresponding position of the edited work queue for display.
  • the present application also provides a computer device, including a memory and a processor, and computer-readable instructions are stored in the memory.
  • the processor executes The steps of the information display method of the work queue described in any one of the above embodiments.
  • This application also provides a computer storage medium.
  • the computer-readable instructions are executed by one or more processors, the one or more processors execute the information of the work queue described in any of the above embodiments. Show the steps of the method.
  • the work queue information display method device, computer equipment and storage medium, first obtain the registration information of each customer, generate a plurality of specific fields according to the registration information, and pre-store the specific fields in the database of the work queue; Then obtain the fixed field of the work queue, and synchronize the fixed field to the configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field; and then according to the user's editing operation from the database Extract the corresponding specific field from the configuration page to edit the fixed field of the work queue on the configuration page; then query the field value corresponding to the specific field in the database, and return the field value to the configuration page ; Finally, the field value is placed in the corresponding position of the edited work queue for display.
  • This solution generates multiple specific fields from the customer’s registration information, extracts the corresponding specific fields according to the user’s editing operations, edits the original fixed fields in the work queue, and queries the field values that need to be displayed and then places the field values in the work The corresponding position in the queue is displayed.
  • the original work queue field display can be re-edited according to customer needs to meet the requirements of dynamic configuration of the work queue.
  • Figure 1 is an application environment diagram of an embodiment of the present application
  • Fig. 2 is a flowchart of a method for displaying information of a work queue in an embodiment
  • FIG. 3 is a flowchart of comparing a fixed field with a specific field according to an embodiment
  • FIG. 4 is a schematic structural diagram of an information display device for a work queue according to an embodiment
  • Figure 5 is a schematic diagram of the internal structure of a computer device in an embodiment.
  • Fig. 1 is an application environment diagram of an embodiment of the present application; in this embodiment, the technical solution of the present application can be implemented based on a server 120.
  • the server 120 and the user terminal 110 are connected through a network. Data interaction.
  • the user terminal 110 accesses the server 120 through the network, retrieves the database in the server 120, and displays and edits the acquired specific fields and the original fixed fields in the work queue through the configuration page in the database.
  • the server 120 referred to here refers to a device that implements various background functions; in particular, the database referred to here refers to a device that stores customer registration information, and the configuration page referred to here refers to a display that can implement editing processing operations page.
  • FIG. 2 is a flowchart of an information display method for a work queue in an embodiment.
  • an information display method for a work queue is proposed, which may specifically include the following steps:
  • S110 Obtain registration information of each customer, generate a plurality of specific fields according to the registration information, and pre-store the specific fields in the database of the work queue.
  • the stored registration information of the customer is obtained through the database, and the obtained registration information of the customer is generated into multiple specific fields to match the original fixed fields in the work queue of the database.
  • the customer's registration information contains business order information
  • specific fields such as order number, order date, and amount owed are generated based on the customer's business order information.
  • the specific fields are pre-stored in the database of the work queue, which is convenient for saving information, and the saved specific fields can be retrieved and used at any time.
  • S120 Obtain a fixed field of the work queue, and synchronize the fixed field to a configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field.
  • the existing fixed fields in the work queue can be extracted, and the configuration page can be preset before the fixed fields are extracted, so that the extracted fixed fields can be synchronized to the configuration page.
  • the original work queue can only display the values of certain fields, and because of the nature of the work queue, it is impossible to directly modify and edit the existing fixed fields in the work queue. Therefore, it is necessary to extract the original fixed fields in the work queue into a preset configuration page, and re-edit the fixed fields in the configuration page through operation instructions input by the user, so as to meet the needs of dynamic configuration of the work queue.
  • the database After the database receives the user's editing operation instruction, it extracts the specific fields originally stored in the work queue to the configuration page for display, in order to match the original fixed fields extracted from the configuration page .
  • the fixed field corresponds to the specific field for editing processing, which can not only improve the editing efficiency, but also avoid errors caused by directly editing the fixed field.
  • S140 Query the field value corresponding to the specific field in the database, and return the field value to the configuration page.
  • the stored procedure is saved and then searched through the database.
  • the field value After querying the field value corresponding to a specific field, the field value is returned to the configuration page, and the field value is processed correspondingly through the configuration page for subsequent collection officers to view.
  • the field value of the specific field after the query is returned to the configuration page through step S140.
  • the configuration page currently displays the field of the edited work queue, and the field value after the query is placed in the corresponding position of the work queue. Then, the field value of this work queue can be displayed, so that the field value configured by the collection staff is used by the front work queue.
  • the information display method of the work queue described above first obtains the registration information of each customer, generates a plurality of specific fields according to the registration information, and prestores the specific fields in the database of the work queue; then obtains the fixed fields of the work queue , And synchronize the fixed field to the configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field; and then according to the user's editing operation, the corresponding specific field is extracted from the database for the configuration
  • the fixed field of the work queue on the page is edited; then the field value corresponding to the specific field is queried in the database, and the field value is returned to the configuration page; finally the field value is placed in The corresponding position of the edited work queue is displayed.
  • This solution generates multiple specific fields from the customer’s registration information, extracts the corresponding specific fields according to the user’s editing operations, edits the original fixed fields in the work queue, and queries the field values that need to be displayed and then places the field values in the work The corresponding position in the queue is displayed.
  • the original work queue field display can be re-edited according to customer needs to meet the requirements of dynamic configuration of the work queue.
  • Fig. 3 is a flow chart of fixed field editing preprocessing of an embodiment.
  • Step S130 extracts the corresponding specific field from the database according to the user’s editing operation.
  • the steps for editing the fixed fields of the work queue can include:
  • the user can input related editing operations according to his own needs, and the database reads the editing operation instructions input by the user and executes the operation.
  • the corresponding specific field is extracted from the database according to the editing operation.
  • the editing operation is executed, and the executed steps include extracting the corresponding specific field from the database.
  • step S110 the registration information of each customer is obtained, a plurality of specific fields are generated according to the registration information, and the specific fields are pre-stored in the database of the work queue. It can be seen that the specific fields have been stored in the database of the work queue. The specified path of, the corresponding specific field can be extracted.
  • the acquired specific fields are placed in a predefined configuration page, and the configuration page has obtained the fixed fields of the work queue through step S120, and the fixed fields are synchronized to the configuration page to put the work queue in The existing fixed fields are displayed on the configuration page.
  • the configuration page contains both fixed fields and corresponding specific fields, and the user input editing operation can be performed after the fixed fields are matched with the corresponding specific fields.
  • the above-mentioned work queue information display method firstly obtains the editing operation input according to the user demand information, and then extracts the corresponding specific field from the database according to the editing operation, and uses the specific field to compare the information on the configuration page
  • the fixed fields of the work queue are edited; through the implementation method of this solution, the corresponding fixed fields and specific fields can be edited in the configuration page according to the editing operations entered by the user to meet the requirements of the dynamic configuration of the work queue fields.
  • FIG. 4 is a flow chart of an embodiment of a fixed field operation processing flow chart, using the specific field to edit the fixed field of the work queue on the configuration page , Can include:
  • the specific field is displayed on the configuration page.
  • the corresponding specific field is extracted from the database according to the editing operation in step S132, and the extracted specific field is displayed in the configuration page.
  • the fixed field can be visually edited in the configuration page through the displayed specific field, and the fixed field can be effectively mapped to the specific field for easy processing.
  • the editing includes at least one of adding, deleting, or modifying.
  • step through the steps: use the specific field to edit the fixed field of the work queue on the configuration page, display the specific field in the configuration page, and use the displayed specific field to fix Edit the field.
  • the editing operation can be to add or delete some fields in the fixed field, or to re-modify some field values in the fixed field.
  • a specific field displays the amount owed. You can search for the content of the corresponding fixed field according to the specific field, and modify the original display content of the fixed field to the field display corresponding to the specific field.
  • the customer's registered account number in the customer's registration information can be extracted as a specific field, and accordingly, the customer's registered account number corresponding to the specific field in the fixed field is found, the registered account number is modified to the registered account number corresponding to the specific field, and At the same time, the information of other specific fields corresponding to the customer is compared with the fixed field, and the field information corresponding to the user in the fixed field is modified, and finally the information is synthesized to generate the business data of the customer.
  • the user can edit the original fixed fields in the registration information of each customer according to the editing operation, so as to obtain a new field display that conforms to the customer registration information.
  • FIG. 5 is a flow chart of comparing fixed fields with specific fields in an embodiment.
  • the steps of editing the fixed fields of the work queue by using the displayed specific fields are also Can include:
  • a1 Acquire the first characteristic information in the specific field and the second characteristic information in the fixed field.
  • the search method includes: obtaining the first characteristic information in the specific field and the second characteristic information in the fixed field.
  • the second characteristic information corresponding to or related to the amount of the first characteristic information is searched in the fixed field.
  • the above search method can generate a mapping set between the concept of a specific field and a fixed field.
  • the mapping set includes instance, subset, inclusion, etc. mapping methods, and the mapping set is used to search for the first feature information in the specific field.
  • the second feature information is used to search for the first feature information in the specific field.
  • the first feature information of a specific field is 1000 yuan, and its corresponding instance in the mapping set is the amount.
  • the amount includes the amount of arrears, so the second feature found in the fixed field through the mapping set The information is displayed.
  • a2 Match the first characteristic information with the second characteristic information, and obtain the field information according to the matching result.
  • the first feature information in the specific field and the second feature information in the fixed field are acquired through the above step a1, and the second feature information of the fixed field corresponding to the first feature information in the specific field is found. Feature information, and match the first feature information with the second feature information
  • the purpose of this embodiment is to match the difference field information between the second feature information and the first feature information, so as to subsequently edit the fixed field.
  • the first feature information and the second feature information are matched by the above a2, and the field information is obtained according to the matching result, and the field information is compared with a specific field again, so that,
  • the displayed information is the field information corresponding to the specific field and the fixed field, and the editing operation of the field information can be performed according to the specific field.
  • a4 Edit the field information according to the comparison result.
  • the incomplete field information is obtained, and the incomplete field information is structured to readjust the word order, etc., so that the incomplete field information becomes complete and smooth, which conforms to the specific field.
  • the first feature information of the data is in line with the language standard of business data.
  • the first feature information in the specific field and the second feature information in the fixed field are first acquired, and then the first feature information is matched with the second feature information, and according to The matching result obtains the field information, the field information is compared with the specific field, and finally the field information is edited according to the comparison result.
  • This method obtains field information that meets the requirements of a specific field.
  • the step S140 of querying the field value corresponding to the specific field in the database includes:
  • the SQL sentence is dynamically spliced according to the field information, and the field value of the dynamically spliced SQL sentence is queried from the database.
  • the basic information of the SQL statement corresponding table may include: the type of the table (global table or temporary table), all the columns corresponding to the table, the name of the database where the table is located, the name of the table and the alias of the table, and the name of the table by other SQL Statements are modified and referenced by other SQL statements (query operations), etc.
  • the types of the tables include predefined global tables, unpredefined global tables, temporary tables, etc.
  • the modification operations performed by other SQL statements include create (create) operations, delete (drop) operations, and update ( update) operations, etc., are referenced by other SQL statements, including query operations.
  • other basic information of the SQL statement corresponding table that is currently or may appear in the future should also be included in this application if it can be applied to this application.
  • the basic information of the column of the table corresponding to the SQL statement may include: which table it belongs to, the index in the table, which SQL statement is referenced, the alias of the column, and the reference information of the column, for example (Egudf(a,b,c) as id) etc.
  • the reference information of the column for example (Egudf(a,b,c) as id) etc.
  • other basic information of the columns in the table that is currently or may appear in the future should also be included in this application if it is applicable to this application.
  • SQL statements are dynamically spliced according to the field information to obtain a new SQL statement after re-splicing, and the field value of the SQL statement is queried from the database to obtain the field value of the field information.
  • step S140 before returning the field value to the configuration page, step S140 further includes:
  • the field value of the field information is obtained by querying the field value of the SQL statement from the database.
  • the query result is an error code, it means that there is an error in the dynamic splicing process.
  • the page displays the error node of the error code, and returns this At the error node, query the code of the upper and lower segments of the error node, and after excluding logic errors or other errors, perform the query again until the field value is queried.
  • FIG. 6 is a schematic structural diagram of an information display device for a work queue in an embodiment.
  • an information display device for a work queue is provided, which includes: first acquisition The module 210, the second module 220, the editing processing module 230, the query module 240, and the display module 250, wherein:
  • the first obtaining module 210 is configured to obtain registration information of each customer, generate a plurality of specific fields according to the registration information, and pre-store the specific fields in the database of the work queue.
  • the second acquisition module 220 is configured to acquire the fixed fields of the work queue and synchronize the fixed fields to a configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field.
  • the editing processing module 230 is configured to extract corresponding specific fields from the database according to the user's editing operations to perform editing processing on the fixed fields of the work queue on the configuration page.
  • the query module 240 is configured to query the field value corresponding to the specific field in the database, and return the field value to the configuration page.
  • the display module 250 is used to place the field value in the corresponding position of the edited work queue for display.
  • the field value of the specific field after the query is returned to the configuration page through the above query module.
  • the configuration page currently displays the field of the work queue after the editing process, and the field value after the query is placed in the corresponding work queue After the position, the field value of this work queue can be displayed, so that the field value configured by the collection staff is used by the front work queue.
  • the various modules in the above-mentioned information display device for the work queue can be implemented in whole or in part by software, hardware and a combination thereof.
  • the foregoing modules may be embedded in the form of hardware or independent of the processor in the computer device, or may be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the foregoing modules.
  • FIG. 7 is a schematic diagram of the internal structure of a computer device in an embodiment.
  • the computer device 10 includes a processor 40 and a memory 20 connected through a bus 50 and a network port 30 connected to the processor 40.
  • the memory 20 of the computer device 10 stores a first acquisition module 210, a second acquisition module 220, an editing processing module 230, a query module 240, and a display module 250.
  • the computer readable instruction is executed by the processor, it can make
  • the processor 40 implements a method for displaying information of the work queue.
  • the processor 40 of the computer device 10 is used to provide calculation and control capabilities, and support the operation of the entire computer device.
  • the network port 30 of the computer device 10 is used to implement data exchange between the server 120 and the processor 40 via the network.
  • FIG. 7 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied.
  • the specific computer device 10 It may include more or fewer components than shown in the figures, or combine certain components, or have a different component arrangement.
  • a computer device in one embodiment, includes a memory, a processor, and computer-readable instructions stored in the memory and running on the processor.
  • the processor implements any of the above when the computer-readable instructions are executed. The steps of the information display method of the work queue of the embodiment.
  • a computer storage medium is provided, and the computer storage medium may be a non-volatile readable storage medium.
  • the one or more processors execute the steps of the information display method of the work queue in any of the foregoing embodiments.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Disclosed are an information presentation method and apparatus for a work queue, and a computer device and a storage medium, relating to the technical field of function optimization. The method comprises: acquiring registration information of each client, generating a plurality of specific fields according to the registration information, and pre-storing the specific fields in a database of a work queue (S110); acquiring a fixed field of the work queue, and synchronizing the fixed field onto a configuration page, wherein the configuration page is a pre-configured page for configuring the specific fields (S120); extracting, according to an editing operation of a user, a corresponding specific field from the database to edit the fixed field of the work queue on the configuration page (S130); querying field values corresponding to the specific fields in the database, and returning the field values to the configuration page (S140); and placing the field values at corresponding positions of the edited work queue for presentation (S150). The field presentation dynamic configuration requirement of a work queue is satisfied.

Description

工作队列的信息展示方法、装置、计算机设备和存储介质 Information display method, device, computer equipment and storage medium of work queue To
本申请要求于2019年04月04日提交中国专利局、申请号为201910270006.3、发明名称为“工作队列的信息展示方法、装置、计算机设备和存储介质”的中国专利申请的优先权,其全部内容通过引用结合在本申请中。This application claims the priority of a Chinese patent application filed with the Chinese Patent Office on April 4, 2019, the application number is 201910270006.3, and the invention title is "Work queue information display methods, devices, computer equipment and storage media", and its entire content Incorporated in this application by reference.
技术领域Technical field
本申请涉及功能优化技术领域,尤其涉及一种工作队列的信息展示方法、装置、计算机设备和存储介质。This application relates to the technical field of function optimization, and in particular to a method, device, computer equipment, and storage medium for displaying information on a work queue.
背景技术Background technique
随着不同业务场景的需求,在很多网络应用中,都需要针对原始数据进行预设处理后得到需要展示给用户的业务数据。比如银行常常使用的催收管理平台,需要对大量的原始数据进行处理,以得到最终展示给用户的催收业务数据。With the requirements of different business scenarios, in many network applications, it is necessary to perform preset processing on the original data to obtain the business data that needs to be displayed to the user. For example, the collection management platform often used by banks needs to process a large amount of original data to obtain the collection business data that is finally displayed to users.
一般工作队列的业务数据都是固定展示字段值,在实际应用中,无法根据用户需求进行新增、删减或修改等编辑操作,难以满足用户动态配置的需求。Generally, the business data of work queues are fixed display field values. In actual applications, editing operations such as addition, deletion, or modification cannot be performed according to user needs, and it is difficult to meet the needs of users for dynamic configuration.
发明内容Summary of the invention
本申请的目的旨在至少能解决上述的技术缺陷之一,特别是现有技术中的工作队列字段不能根据客户需求进行动态配置的技术缺陷。The purpose of this application is to at least solve one of the above technical defects, especially the technical defect that the work queue field in the prior art cannot be dynamically configured according to customer needs.
本申请提供一种工作队列的信息展示方法,包括如下步骤:This application provides a method for displaying work queue information, including the following steps:
获取各个客户的注册信息,根据所述注册信息生成多个特定字段,并将所述特定字段预存到工作队列的数据库中;Acquiring registration information of each customer, generating multiple specific fields according to the registration information, and pre-storing the specific fields in the database of the work queue;
获取所述工作队列的固定字段,并将所述固定字段同步至配置页面上;其中,所述配置页面为预先配置的页面,用于配置所述特定字段;Acquiring the fixed field of the work queue, and synchronizing the fixed field to a configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field;
根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理;Extract corresponding specific fields from the database according to the user's editing operation to edit the fixed fields of the work queue on the configuration page;
在所述数据库中查询所述特定字段对应的字段值,将所述字段值返回到所述配置页面;Query the field value corresponding to the specific field in the database, and return the field value to the configuration page;
将所述字段值放置在所述编辑处理后的工作队列的相应位置进行展示。Place the field value in the corresponding position of the edited work queue for display.
在其中一个实施例中,根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理的步骤,包括:In one of the embodiments, the step of extracting the corresponding specific field from the database according to the user's editing operation to edit the fixed field of the work queue on the configuration page includes:
获取根据用户需求信息输入的编辑操作;Obtain the editing operation input according to the user's demand information;
根据所述编辑操作从所述数据库中提取相应的特定字段;Extract corresponding specific fields from the database according to the editing operation;
利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑。Use the specific field to edit the fixed field of the work queue on the configuration page.
在其中一个实施例中,所述利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑的步骤,包括:In one of the embodiments, the step of using the specific field to edit the fixed field of the work queue on the configuration page includes:
将所述特定字段展示在所述配置页面中;并利用所述展示的特定字段对所述工作队列的固定字段进行编辑;其中,所述编辑包括新增、删减或修改至少一种。The specific field is displayed on the configuration page; and the fixed field of the work queue is edited by using the displayed specific field; wherein, the editing includes at least one of adding, deleting, or modifying.
在其中一个实施例中,所述利用所述特定字段对所述工作队列的固定字段进行编辑的步骤,包括:In one of the embodiments, the step of using the specific field to edit the fixed field of the work queue includes:
获取所述固定字段中与所述特定字段的位置相对应的字段信息;Acquiring field information corresponding to the position of the specific field in the fixed field;
将所述字段信息与所述特定字段进行比对,并根据比对结果对所述字段信息进行编辑。The field information is compared with the specific field, and the field information is edited according to the comparison result.
在其中一个实施例中,所述获取所述固定字段中与所述特定字段的位置相对应的字段信息的步骤,包括:In one of the embodiments, the step of obtaining field information corresponding to the position of the specific field in the fixed field includes:
获取所述特定字段中的第一特征信息,以及所述固定字段中的第二特征信息;Acquiring the first characteristic information in the specific field and the second characteristic information in the fixed field;
将所述第一特征信息与所述第二特征信息进行匹配,并根据所述匹配结果得到所述字段信息。The first characteristic information is matched with the second characteristic information, and the field information is obtained according to the matching result.
在其中一个实施例中,在所述数据库中查询所述特定字段对应的字段值的步骤,包括:In one of the embodiments, the step of querying the field value corresponding to the specific field in the database includes:
根据所述字段信息动态拼接SQL语句,并从所述数据库中查询所述动态拼接后的SQL语句的字段值。The SQL sentence is dynamically spliced according to the field information, and the field value of the dynamically spliced SQL sentence is queried from the database.
在其中一个实施例中,在将所述字段值返回到所述配置页面之前,还包括:In one of the embodiments, before returning the field value to the configuration page, the method further includes:
获取所述查询结果,当所述查询结果为错误代码时,通过所述错误代码查找错误节点,并将所述错误节点改正后重新查询。Obtain the query result, and when the query result is an error code, search for the error node through the error code, correct the error node and query again.
本申请还提供了一种工作队列的信息展示装置,其包括:This application also provides a work queue information display device, which includes:
第一获取模块,用于获取各个客户的注册信息,根据所述注册信息生成多个特定字段,并将所述特定字段预存到工作队列的数据库中;The first obtaining module is configured to obtain the registration information of each customer, generate a plurality of specific fields according to the registration information, and pre-store the specific fields in the database of the work queue;
第二获取模块,用于获取所述工作队列的固定字段,并将所述固定字段同步至配置页面上;其中,所述配置页面为预先配置的页面,用于配置所述特定字段;The second obtaining module is configured to obtain fixed fields of the work queue and synchronize the fixed fields to a configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field;
编辑处理模块,用于根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理;The editing processing module is configured to extract corresponding specific fields from the database according to the user's editing operation to edit the fixed fields of the work queue on the configuration page;
查询模块,用于在所述数据库中查询所述特定字段对应的字段值,将所述字段值返回到所述配置页面;A query module, configured to query the field value corresponding to the specific field in the database, and return the field value to the configuration page;
展示模块,用于将所述字段值放置在所述编辑处理后的工作队列的相应位置进行展示。The display module is used to place the field value in the corresponding position of the edited work queue for display.
本申请还提供了一种计算机设备,包括存储器和处理器,所述存储器中存储有计算机可读指令,其中,所述计算机可读指令被所述处理器执行时,使得所述处理器执行如上述实施例中任一项所述的工作队列的信息展示方法的步骤。The present application also provides a computer device, including a memory and a processor, and computer-readable instructions are stored in the memory. When the computer-readable instructions are executed by the processor, the processor executes The steps of the information display method of the work queue described in any one of the above embodiments.
本申请还提供了一种计算机存储介质,所述计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器执行如上述实施例中任一项所述的工作队列的信息展示方法的步骤。This application also provides a computer storage medium. When the computer-readable instructions are executed by one or more processors, the one or more processors execute the information of the work queue described in any of the above embodiments. Show the steps of the method.
上述的工作队列的信息展示方法、装置、计算机设备和存储介质,首先获取各个客户的注册信息,根据所述注册信息生成多个特定字段,并将所述特定字段预存到工作队列的数据库中;然后获取所述工作队列的固定字段,并将所述固定字段同步至配置页面上;其中,所述配置页面为预先配置的页面,用于配置所述特定字段;再根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理;随后在所述数据库中查询所述特定字段对应的字段值,将所述字段值返回到所述配置页面;最后将所述字段值放置在所述编辑处理后的工作队列的相应位置进行展示。In the above-mentioned work queue information display method, device, computer equipment and storage medium, first obtain the registration information of each customer, generate a plurality of specific fields according to the registration information, and pre-store the specific fields in the database of the work queue; Then obtain the fixed field of the work queue, and synchronize the fixed field to the configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field; and then according to the user's editing operation from the database Extract the corresponding specific field from the configuration page to edit the fixed field of the work queue on the configuration page; then query the field value corresponding to the specific field in the database, and return the field value to the configuration page ; Finally, the field value is placed in the corresponding position of the edited work queue for display.
该方案通过客户的注册信息生成多个特定字段,根据用户的编辑操作提取相应特定字段对工作队列中原有的固定字段进行编辑处理,并查询出需要展示的字段值后将该字段值放置在工作队列中的相应位置进行展示。这样便可以根据客户需求将原有的工作队列字段展示重新进行编辑处理,满足工作队列动态配置的要求。This solution generates multiple specific fields from the customer’s registration information, extracts the corresponding specific fields according to the user’s editing operations, edits the original fixed fields in the work queue, and queries the field values that need to be displayed and then places the field values in the work The corresponding position in the queue is displayed. In this way, the original work queue field display can be re-edited according to customer needs to meet the requirements of dynamic configuration of the work queue.
本申请附加的方面和优点将在下面的描述中部分给出,这些将从下面的描述中变得明显,或通过本申请的实践了解到。The additional aspects and advantages of this application will be partly given in the following description, which will become obvious from the following description, or be understood through the practice of this application.
附图说明Description of the drawings
本申请上述的和/或附加的方面和优点从下面结合附图对实施例的描述中将变得明显和容易理解,其中:The above and/or additional aspects and advantages of the present application will become obvious and easy to understand from the following description of the embodiments in conjunction with the accompanying drawings, in which:
图1是本申请实施例方案的应用环境图;Figure 1 is an application environment diagram of an embodiment of the present application;
图2是一个实施例中工作队列的信息展示方法流程图;Fig. 2 is a flowchart of a method for displaying information of a work queue in an embodiment;
图3是一个实施例的固定字段与特定字段比对流程图;FIG. 3 is a flowchart of comparing a fixed field with a specific field according to an embodiment;
图4是一个实施例的工作队列的信息展示装置结构示意图;FIG. 4 is a schematic structural diagram of an information display device for a work queue according to an embodiment;
图5是一个实施例中计算机设备的内部结构示意图。Figure 5 is a schematic diagram of the internal structure of a computer device in an embodiment.
具体实施方式detailed description
下面详细描述本申请的实施例,所述实施例的示例在附图中示出,其中自始至终相同或类似的标号表示相同或类似的元件或具有相同或类似功能的元件。下面通过参考附图描述的实施例是示例性的,仅用于解释本申请,而不能解释为对本申请的限制。The embodiments of the present application are described in detail below. Examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals indicate the same or similar elements or elements with the same or similar functions. The embodiments described below with reference to the drawings are exemplary, and are only used to explain the present application, and cannot be construed as a limitation to the present application.
本技术领域技术人员可以理解,除非特意声明,这里使用的单数形式“一”、“一个”、“所述”和“该”也可包括复数形式。应该进一步理解的是,本申请的说明书中使用的措辞“包括”是指存在所述特征、整数、步骤、操作、元件和/或组件,但是并不排除存在或添加一个或多个其他特征、整数、步骤、操作、元件、组件和/或它们的组。Those skilled in the art can understand that, unless specifically stated, the singular forms "a", "an", "said" and "the" used herein may also include plural forms. It should be further understood that the term "comprising" used in the specification of this application refers to the presence of the described features, integers, steps, operations, elements, and/or components, but does not exclude the presence or addition of one or more other features, Integers, steps, operations, elements, components, and/or groups thereof.
本技术领域技术人员可以理解,除非另外定义,这里使用的所有术语(包括技术术语和科学术语),具有与本申请所属领域中的普通技术人员的一般理解相同的意义。还应该理解的是,诸如通用字典中定义的那些术语,应该被理解为具有与现有技术的上下文中的意义一致的意义,并且除非像这里一样被特定定义,否则不会用理想化或过于正式的含义来解释。Those skilled in the art can understand that, unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meanings as those commonly understood by those of ordinary skill in the art to which this application belongs. It should also be understood that terms such as those defined in general dictionaries should be understood to have a meaning consistent with the meaning in the context of the prior art, and unless specifically defined as here, they will not be idealized or overly Explain the formal meaning.
参考图1所示,图1是本申请实施例的应用环境图;本实施例中,本申请的技术方案可以基于服务器120实现,如图1中,服务器120与用户终端110之间通过网络进行数据交互。在本申请实施例中,用户终端110通过网络访问服务器120,调取服务器120中的数据库,通过数据库中的配置页面将获取的特定字段以及工作队列中原有的固定字段进行展示和编辑处理等相关操作;这里所指的服务器120是指实现各种后台功能的设备;特别地,这里所指的数据库是指存储客户注册信息的设备,这里所指的配置页面是指能够实现编辑处理操作的展示页面。As shown in Fig. 1, Fig. 1 is an application environment diagram of an embodiment of the present application; in this embodiment, the technical solution of the present application can be implemented based on a server 120. In Fig. 1, the server 120 and the user terminal 110 are connected through a network. Data interaction. In the embodiment of the present application, the user terminal 110 accesses the server 120 through the network, retrieves the database in the server 120, and displays and edits the acquired specific fields and the original fixed fields in the work queue through the configuration page in the database. Operation; the server 120 referred to here refers to a device that implements various background functions; in particular, the database referred to here refers to a device that stores customer registration information, and the configuration page referred to here refers to a display that can implement editing processing operations page.
在一个实施例中,如图2所示,图2为一个实施例中工作队列的信息展示方法流程图,本实施例中提出了一种工作队列的信息展示方法,具体可以包括以下步骤:In an embodiment, as shown in FIG. 2, FIG. 2 is a flowchart of an information display method for a work queue in an embodiment. In this embodiment, an information display method for a work queue is proposed, which may specifically include the following steps:
S110:获取各个客户的注册信息,根据所述注册信息生成多个特定字段,并将所述特定字段预存到工作队列的数据库中。S110: Obtain registration information of each customer, generate a plurality of specific fields according to the registration information, and pre-store the specific fields in the database of the work queue.
在此步骤中,通过数据库获取已保存的客户的注册信息,并将获取到的客户的注册信息生成多个特定字段,以便与数据库的工作队列中原有的固定字段进行匹配。In this step, the stored registration information of the customer is obtained through the database, and the obtained registration information of the customer is generated into multiple specific fields to match the original fixed fields in the work queue of the database.
例如,客户的注册信息中包含有业务订单信息,则根据客户的业务订单信息生成订单号、订单日期、欠款金额等特定字段。For example, if the customer's registration information contains business order information, specific fields such as order number, order date, and amount owed are generated based on the customer's business order information.
本实例中,通过客户的注册信息生成多个特定字段后,将该特定字段预存到工作队列的数据库中,便于保存信息的同时,也可随时将保存的特定字段进行调取和使用。In this example, after multiple specific fields are generated from the customer's registration information, the specific fields are pre-stored in the database of the work queue, which is convenient for saving information, and the saved specific fields can be retrieved and used at any time.
S120:获取所述工作队列的固定字段,并将所述固定字段同步至配置页面上;其中,所述配置页面为预先配置的页面,用于配置所述特定字段。S120: Obtain a fixed field of the work queue, and synchronize the fixed field to a configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field.
在此步骤中,可以提取工作队列中已有的固定字段,并在提取固定字段之前预先设置配置页面,以便将提取到的固定字段同步到配置页面中。In this step, the existing fixed fields in the work queue can be extracted, and the configuration page can be preset before the fixed fields are extracted, so that the extracted fixed fields can be synchronized to the configuration page.
本实施例中,原有的工作队列只能固定展示某些字段的值,并且因为工作队列的性质,无法直接对工作队列中已有的固定字段进行修改编辑等操作。因此,需要将工作队列中原有的固定字段提取到预置的配置页面中,在配置页面中通过用户输入的操作指令等对固定字段重新进行编辑,进而能够满足工作队列动态配置的需求。In this embodiment, the original work queue can only display the values of certain fields, and because of the nature of the work queue, it is impossible to directly modify and edit the existing fixed fields in the work queue. Therefore, it is necessary to extract the original fixed fields in the work queue into a preset configuration page, and re-edit the fixed fields in the configuration page through operation instructions input by the user, so as to meet the needs of dynamic configuration of the work queue.
S130:根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理。S130: Extract the corresponding specific field from the database according to the user's editing operation to edit the fixed field of the work queue on the configuration page.
本步骤中,数据库接收到用户的编辑操作指令后,将原本保存在工作队列中的特定字段提取到配置页面中进行展示,目的是为了与配置页面中提取的原有的固定字段之间进行匹配。In this step, after the database receives the user's editing operation instruction, it extracts the specific fields originally stored in the work queue to the configuration page for display, in order to match the original fixed fields extracted from the configuration page .
通过用户的编辑操作,将固定字段对应于特定字段进行编辑处理,不仅能够提高编辑效率,还能够避免直接对固定字段进行编辑处理后造成的失误。Through the user's editing operation, the fixed field corresponds to the specific field for editing processing, which can not only improve the editing efficiency, but also avoid errors caused by directly editing the fixed field.
S140:在所述数据库中查询所述特定字段对应的字段值,将所述字段值返回到所述配置页面。S140: Query the field value corresponding to the specific field in the database, and return the field value to the configuration page.
本步骤中,通过上述步骤S130对固定字段进行编辑处理后,将该存储过程保存后通过数据库进行查询操作,用户通过点击菜单,输入相应的名字并给出参数,执行该存储过程,便可查看存储过程中的特定字段对应的字段值。In this step, after the fixed field is edited through the above step S130, the stored procedure is saved and then searched through the database. The user clicks on the menu, enters the corresponding name and gives the parameters, and executes the stored procedure to view The field value corresponding to the specific field in the stored procedure.
查询到特定字段对应的字段值后,将该字段值返回到配置页面中,通过配置页面将该字段值进行相应的处理,以便后续催收员进行查看。After querying the field value corresponding to a specific field, the field value is returned to the configuration page, and the field value is processed correspondingly through the configuration page for subsequent collection officers to view.
S150:将所述字段值放置在所述编辑处理后的工作队列的相应位置进行展示。S150: Place the field value in a corresponding position of the edited work queue for display.
本步骤中,通过步骤S140将查询后的特定字段的字段值返回到配置页面中,配置页面当前显示的是编辑处理后的工作队列的字段,将查询后的字段值放置在工作队列的相应位置后,便可将此工作队列的字段值进行展示,这样,前台工作队列用的就是催收人员配置的字段值。In this step, the field value of the specific field after the query is returned to the configuration page through step S140. The configuration page currently displays the field of the edited work queue, and the field value after the query is placed in the corresponding position of the work queue. Then, the field value of this work queue can be displayed, so that the field value configured by the collection staff is used by the front work queue.
上述工作队列的信息展示方法,首先获取各个客户的注册信息,根据所述注册信息生成多个特定字段,并将所述特定字段预存到工作队列的数据库中;然后获取所述工作队列的固定字段,并将所述固定字段同步至配置页面上;其中,所述配置页面为预先配置的页面,用于配置所述特定字段;再根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理;随后在所述数据库中查询所述特定字段对应的字段值,将所述字段值返回到所述配置页面;最后将所述字段值放置在所述编辑处理后的工作队列的相应位置进行展示。The information display method of the work queue described above first obtains the registration information of each customer, generates a plurality of specific fields according to the registration information, and prestores the specific fields in the database of the work queue; then obtains the fixed fields of the work queue , And synchronize the fixed field to the configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field; and then according to the user's editing operation, the corresponding specific field is extracted from the database for the configuration The fixed field of the work queue on the page is edited; then the field value corresponding to the specific field is queried in the database, and the field value is returned to the configuration page; finally the field value is placed in The corresponding position of the edited work queue is displayed.
该方案通过客户的注册信息生成多个特定字段,根据用户的编辑操作提取相应特定字段对工作队列中原有的固定字段进行编辑处理,并查询出需要展示的字段值后将该字段值放置在工作队列中的相应位置进行展示。这样便可以根据客户需求将原有的工作队列字段展示重新进行编辑处理,满足工作队列动态配置的要求。This solution generates multiple specific fields from the customer’s registration information, extracts the corresponding specific fields according to the user’s editing operations, edits the original fixed fields in the work queue, and queries the field values that need to be displayed and then places the field values in the work The corresponding position in the queue is displayed. In this way, the original work queue field display can be re-edited according to customer needs to meet the requirements of dynamic configuration of the work queue.
在一个实施例中,参考图3所示,图3是一个实施例的固定字段编辑预处理流程图,步骤S130根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理的步骤,可以包括:In one embodiment, referring to Fig. 3, Fig. 3 is a flow chart of fixed field editing preprocessing of an embodiment. Step S130 extracts the corresponding specific field from the database according to the user’s editing operation. The steps for editing the fixed fields of the work queue can include:
获取根据用户需求信息输入的编辑操作。Obtain the editing operation input according to the user's requirement information.
本步骤中,用户可以根据自身需求输入相关编辑操作,数据库读取用户输入的编辑操作指令后,执行该操作。In this step, the user can input related editing operations according to his own needs, and the database reads the editing operation instructions input by the user and executes the operation.
根据所述编辑操作从所述数据库中提取相应的特定字段。The corresponding specific field is extracted from the database according to the editing operation.
在此步骤中,读取用户输入的编辑操作后,执行该编辑操作,执行的步骤包括从数据库中提取相应的特定字段。In this step, after reading the editing operation input by the user, the editing operation is executed, and the executed steps include extracting the corresponding specific field from the database.
由上述步骤S110获取各个客户的注册信息,根据所述注册信息生成多个特定字段,并将所述特定字段预存到工作队列的数据库中可知,特定字段已保存于工作队列的数据库中,根据保存的指定路径,即可将相应的特定字段提取出来。According to the above step S110, the registration information of each customer is obtained, a plurality of specific fields are generated according to the registration information, and the specific fields are pre-stored in the database of the work queue. It can be seen that the specific fields have been stored in the database of the work queue. The specified path of, the corresponding specific field can be extracted.
利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑。Use the specific field to edit the fixed field of the work queue on the configuration page.
当步骤:根据所述编辑操作从所述数据库中提取相应的特定字段,执行完毕,获取相应的特定字段后,执行本步骤。本步骤中,将获取的特定字段放置在预定义的配置页面中,且配置页面已通过步骤S120获取所述工作队列的固定字段,并将所述固定字段同步至配置页面上,将工作队列中已有的固定字段展示在配置页面中。When the step: extract the corresponding specific field from the database according to the editing operation, after the execution is completed, and the corresponding specific field is obtained, execute this step. In this step, the acquired specific fields are placed in a predefined configuration page, and the configuration page has obtained the fixed fields of the work queue through step S120, and the fixed fields are synchronized to the configuration page to put the work queue in The existing fixed fields are displayed on the configuration page.
由此,配置页面中既有固定字段,也含有相应的特定字段,即可将固定字段与相应的特定字段匹配后进行用户输入的编辑操作。Therefore, the configuration page contains both fixed fields and corresponding specific fields, and the user input editing operation can be performed after the fixed fields are matched with the corresponding specific fields.
上述工作队列的信息展示方法,首先获取根据用户需求信息输入的编辑操作,然后根据所述编辑操作从所述数据库中提取相应的特定字段,利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑;通过本方案的实施方法,可根据用户输入的编辑操作在配置页面中对相应的固定字段和特定字段进行编辑处理,满足工作队列字段展示动态配置的要求。The above-mentioned work queue information display method firstly obtains the editing operation input according to the user demand information, and then extracts the corresponding specific field from the database according to the editing operation, and uses the specific field to compare the information on the configuration page The fixed fields of the work queue are edited; through the implementation method of this solution, the corresponding fixed fields and specific fields can be edited in the configuration page according to the editing operations entered by the user to meet the requirements of the dynamic configuration of the work queue fields.
在一个实施例中,参考图4所示,图4是一个实施例的对固定字段操作处理流程图,利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑的步骤,可以包括:In an embodiment, referring to FIG. 4, FIG. 4 is a flow chart of an embodiment of a fixed field operation processing flow chart, using the specific field to edit the fixed field of the work queue on the configuration page , Can include:
将所述特定字段展示在所述配置页面中。The specific field is displayed on the configuration page.
在本步骤中,通过步骤S132根据所述编辑操作从所述数据库中提取相应的特定字段,并将提取后的特定字段展示在配置页面中。In this step, the corresponding specific field is extracted from the database according to the editing operation in step S132, and the extracted specific field is displayed in the configuration page.
这样,可以通过展示的特定字段在配置页面中对固定字段进行可视化编辑操作,有效地将固定字段与特定字段进行对应,便于处理。In this way, the fixed field can be visually edited in the configuration page through the displayed specific field, and the fixed field can be effectively mapped to the specific field for easy processing.
并利用所述展示的特定字段对所述工作队列的固定字段进行编辑;其中,所述编辑包括新增、删减或修改至少一种。And use the displayed specific fields to edit the fixed fields of the work queue; wherein, the editing includes at least one of adding, deleting, or modifying.
在本步骤中,通过步骤:利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑,将所述特定字段展示在所述配置页面中,利用展示的特定字段对固定字段进行编辑,编辑操作可以是对固定字段中新增某些字段或删减某些字段,也可以是重新修改固定字段中的某些字段值。In this step, through the steps: use the specific field to edit the fixed field of the work queue on the configuration page, display the specific field in the configuration page, and use the displayed specific field to fix Edit the field. The editing operation can be to add or delete some fields in the fixed field, or to re-modify some field values in the fixed field.
例如:特定字段展示的是欠款金额,可以根据特定字段查找对应的固定字段的内容,将固定字段原有的展示内容修改为与特定字段相对应的字段展示。For example: a specific field displays the amount owed. You can search for the content of the corresponding fixed field according to the specific field, and modify the original display content of the fixed field to the field display corresponding to the specific field.
进一步地,可以提取客户的注册信息中客户的注册账号作为特定字段,相应地,找到固定字段中与特定字段对应的客户的注册账号,将该注册账号修改为与特定字段对应的注册账号,并同时将该客户对应的其他特定字段的信息一并同固定字段进行比对,并修改固定字段中该用户对应的字段信息,最后将该信息合成,生成该客户的业务数据。Further, the customer's registered account number in the customer's registration information can be extracted as a specific field, and accordingly, the customer's registered account number corresponding to the specific field in the fixed field is found, the registered account number is modified to the registered account number corresponding to the specific field, and At the same time, the information of other specific fields corresponding to the customer is compared with the fixed field, and the field information corresponding to the user in the fixed field is modified, and finally the information is synthesized to generate the business data of the customer.
通过上述实施例,用户可根据编辑操作对各个客户的注册信息中原有的固定字段进行编辑处理,以得到符合客户注册信息的新的字段展示。Through the foregoing embodiment, the user can edit the original fixed fields in the registration information of each customer according to the editing operation, so as to obtain a new field display that conforms to the customer registration information.
在一个实施例中,参考图5所示,图5是一个实施例的固定字段与特定字段比对流程图,利用所述展示的特定字段对所述工作队列的固定字段进行编辑的步骤,还可以包括:In an embodiment, referring to FIG. 5, FIG. 5 is a flow chart of comparing fixed fields with specific fields in an embodiment. The steps of editing the fixed fields of the work queue by using the displayed specific fields are also Can include:
a1:获取所述特定字段中的第一特征信息,以及所述固定字段中的第二特征信息。a1: Acquire the first characteristic information in the specific field and the second characteristic information in the fixed field.
本步骤中,在配置页面中执行用户输入的编辑操作,查找与特定字段相对应的固定字段,查找方式包括:获取特定字段中的第一特征信息和固定字段中的第二特征信息。In this step, the editing operation entered by the user is performed on the configuration page to find the fixed field corresponding to the specific field. The search method includes: obtaining the first characteristic information in the specific field and the second characteristic information in the fixed field.
例如:查找特定字段中的第一特征信息为金额,则在固定字段中查找与第一特征信息金额相应或相关的第二特征信息。For example, if the first characteristic information in a specific field is searched for an amount, then the second characteristic information corresponding to or related to the amount of the first characteristic information is searched in the fixed field.
进一步地,上述查找方式可以通过将特定字段与固定字段的概念之间生成映射集,映射集包括实例、子集、包含有等映射方式,通过该映射集查找与特定字段中第一特征信息对应的第二特征信息。Further, the above search method can generate a mapping set between the concept of a specific field and a fixed field. The mapping set includes instance, subset, inclusion, etc. mapping methods, and the mapping set is used to search for the first feature information in the specific field. The second feature information.
以催收业务为例,特定字段的第一特征信息为1000元,其在映射集中对应的实例为金额,所述金额包含有欠款金额,因而将固定字段中通过映射集查找到的第二特征信息显示出来。Taking the collection business as an example, the first feature information of a specific field is 1000 yuan, and its corresponding instance in the mapping set is the amount. The amount includes the amount of arrears, so the second feature found in the fixed field through the mapping set The information is displayed.
a2:将所述第一特征信息与所述第二特征信息进行匹配,并根据所述匹配结果得到所述字段信息。a2: Match the first characteristic information with the second characteristic information, and obtain the field information according to the matching result.
本步骤中,通过上述步骤a1获取所述特定字段中的第一特征信息,以及所述固定字段中的第二特征信息,查找到与特定字段中的第一特征信息对应的固定字段的第二特征信息,并将第一特征信息与第二特征信息进行匹配In this step, the first feature information in the specific field and the second feature information in the fixed field are acquired through the above step a1, and the second feature information of the fixed field corresponding to the first feature information in the specific field is found. Feature information, and match the first feature information with the second feature information
本实施例的目的是匹配第二特征信息与第一特征信息之间的差别字段信息,以便后续对固定字段进行编辑处理。The purpose of this embodiment is to match the difference field information between the second feature information and the first feature information, so as to subsequently edit the fixed field.
a3:将所述字段信息与所述特定字段进行比对。a3: Compare the field information with the specific field.
本步骤中,由上述a2将所述第一特征信息与所述第二特征信息进行匹配,并根据所述匹配结果得到所述字段信息,将该字段信息重新与特定字段进行比对,这样,展示信息即是特定字段与固定字段对应的字段信息,字段信息的编辑操作可根据该特定字段进行。In this step, the first feature information and the second feature information are matched by the above a2, and the field information is obtained according to the matching result, and the field information is compared with a specific field again, so that, The displayed information is the field information corresponding to the specific field and the fixed field, and the editing operation of the field information can be performed according to the specific field.
a4:根据比对结果对所述字段信息进行编辑。a4: Edit the field information according to the comparison result.
本步骤中,将字段信息与特定字段比对后,得到是不完整的字段信息,架构该不完整的字段信息重新调整语序等,使得不完整的字段信息变得完整通顺,既符合特定字段中的第一特征信息,又符合业务数据的语言标准。In this step, after comparing the field information with the specific field, the incomplete field information is obtained, and the incomplete field information is structured to readjust the word order, etc., so that the incomplete field information becomes complete and smooth, which conforms to the specific field. The first feature information of the data is in line with the language standard of business data.
并且,如果没有比对结果,则将上述字段信息与特定字段之间重新进行比对,防止比对过程错误。And, if there is no comparison result, the above field information and the specific field will be compared again to prevent errors in the comparison process.
本实施例中,首先获取所述特定字段中的第一特征信息,以及所述固定字段中的第二特征信息,然后将所述第一特征信息与所述第二特征信息进行匹配,并根据所述匹配结果得到所述字段信息,将所述字段信息与所述特定字段进行比对,最后根据比对结果对所述字段信息进行编辑。通过该方法得到符合特定字段要求的字段信息。In this embodiment, the first feature information in the specific field and the second feature information in the fixed field are first acquired, and then the first feature information is matched with the second feature information, and according to The matching result obtains the field information, the field information is compared with the specific field, and finally the field information is edited according to the comparison result. This method obtains field information that meets the requirements of a specific field.
在一个实施例中,步骤S140在所述数据库中查询所述特定字段对应的字段值的步骤,包括:In an embodiment, the step S140 of querying the field value corresponding to the specific field in the database includes:
根据所述字段信息动态拼接SQL语句,并从所述数据库中查询所述动态拼接后的SQL语句的字段值。The SQL sentence is dynamically spliced according to the field information, and the field value of the dynamically spliced SQL sentence is queried from the database.
本步骤中,首先需要得到原有的固定字段的SQL语句的基本信息,每一条SQL语句对应的表及其表的列的对应关系之后,再根据字段信息动态拼接SQL语句。In this step, it is first necessary to obtain the basic information of the original SQL statement of the fixed field, and after each SQL statement corresponds to the table and the corresponding relationship of the table column, the SQL statement is dynamically spliced according to the field information.
需要说明的是,所述SQL语句对应表的基本信息可以包括:表的类型(全局表或者临时表)、表对应的所有列、表所在的数据库名、表名及表的别名、被其他SQL语句进行修改操作以及被其他SQL语句引用(查询操作)等。其中,所述表的类型包括预定义的全局表、未预定义的全局表及临时表等,所述被其他SQL语句进行的修改操作包括创建(create)操作、删除(drop)操作以及更新(update)操作等,被其他SQL语句引用包括查询操作。当然,其他现有或者今后可能出现的所述SQL语句对应表的基本信息若能适用于本申请,也应包含在本申请内。It should be noted that the basic information of the SQL statement corresponding table may include: the type of the table (global table or temporary table), all the columns corresponding to the table, the name of the database where the table is located, the name of the table and the alias of the table, and the name of the table by other SQL Statements are modified and referenced by other SQL statements (query operations), etc. Wherein, the types of the tables include predefined global tables, unpredefined global tables, temporary tables, etc., and the modification operations performed by other SQL statements include create (create) operations, delete (drop) operations, and update ( update) operations, etc., are referenced by other SQL statements, including query operations. Of course, other basic information of the SQL statement corresponding table that is currently or may appear in the future should also be included in this application if it can be applied to this application.
需要说明的是,所述SQL语句对应的所述表的列的基本信息可以包括:属于哪个表、在表中的索引(index)、被哪个SQL语句引用、列的别名以及列的引用信息例如(e.g.udf(a,b,c)as id)等。当然,其他现有或者今后可能出现的所述表的列的基本信息若能适用于本申请,也应包含在本申请内。It should be noted that the basic information of the column of the table corresponding to the SQL statement may include: which table it belongs to, the index in the table, which SQL statement is referenced, the alias of the column, and the reference information of the column, for example (Egudf(a,b,c) as id) etc. Of course, other basic information of the columns in the table that is currently or may appear in the future should also be included in this application if it is applicable to this application.
接着本申请的实施例,根据字段信息动态拼接SQL语句,得到重新拼接后的新的SQL语句,从数据库中查询该SQL语句的字段值,即可得到字段信息的字段值。Following the embodiment of the present application, SQL statements are dynamically spliced according to the field information to obtain a new SQL statement after re-splicing, and the field value of the SQL statement is queried from the database to obtain the field value of the field information.
在一个实施例中,步骤S140在将所述字段值返回到所述配置页面之前,还包括:In an embodiment, before returning the field value to the configuration page, step S140 further includes:
获取所述查询结果,当所述查询结果为错误代码时,通过所述错误代码查找错误节点,并将所述错误节点改正后重新查询。Obtain the query result, and when the query result is an error code, search for the error node through the error code, correct the error node and query again.
上述过程中,通过从数据库中查询该SQL语句的字段值,得到字段信息的字段值,当查询结果为错误代码的时候,则表示动态拼接过程出现错误,页面显示错误代码的错误节点,返回此错误节点处,对该错误节点上下段的代码进行查询,排除逻辑错误或其他失误后,重新进行查询,直到查询到字段值为止。In the above process, the field value of the field information is obtained by querying the field value of the SQL statement from the database. When the query result is an error code, it means that there is an error in the dynamic splicing process. The page displays the error node of the error code, and returns this At the error node, query the code of the upper and lower segments of the error node, and after excluding logic errors or other errors, perform the query again until the field value is queried.
在一个实施例中,如图6所示,图6为一个实施例中的工作队列的信息展示装置结构示意图,本实施例中提供了一种工作队列的信息展示装置,其包括:第一获取模块210、第二模块220、编辑处理模块230、查询模块240、展示模块250,其中:In an embodiment, as shown in FIG. 6, FIG. 6 is a schematic structural diagram of an information display device for a work queue in an embodiment. In this embodiment, an information display device for a work queue is provided, which includes: first acquisition The module 210, the second module 220, the editing processing module 230, the query module 240, and the display module 250, wherein:
第一获取模块210:用于获取各个客户的注册信息,根据所述注册信息生成多个特定字段,并将所述特定字段预存到工作队列的数据库中。The first obtaining module 210 is configured to obtain registration information of each customer, generate a plurality of specific fields according to the registration information, and pre-store the specific fields in the database of the work queue.
第二获取模块220:用于获取所述工作队列的固定字段,并将所述固定字段同步至配置页面上;其中,所述配置页面为预先配置的页面,用于配置所述特定字段。The second acquisition module 220 is configured to acquire the fixed fields of the work queue and synchronize the fixed fields to a configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field.
编辑处理模块230:用于根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理。The editing processing module 230 is configured to extract corresponding specific fields from the database according to the user's editing operations to perform editing processing on the fixed fields of the work queue on the configuration page.
查询模块240:用于在所述数据库中查询所述特定字段对应的字段值,将所述字段值返回到所述配置页面。The query module 240 is configured to query the field value corresponding to the specific field in the database, and return the field value to the configuration page.
展示模块250:用于将所述字段值放置在所述编辑处理后的工作队列的相应位置进行展示。The display module 250 is used to place the field value in the corresponding position of the edited work queue for display.
本模块中,通过上述查询模块将查询后的特定字段的字段值返回到配置页面中,配置页面当前显示的是编辑处理后的工作队列的字段,将查询后的字段值放置在工作队列的相应位置后,便可将此工作队列的字段值进行展示,这样,前台工作队列用的就是催收人员配置的字段值。In this module, the field value of the specific field after the query is returned to the configuration page through the above query module. The configuration page currently displays the field of the work queue after the editing process, and the field value after the query is placed in the corresponding work queue After the position, the field value of this work queue can be displayed, so that the field value configured by the collection staff is used by the front work queue.
关于工作队列的信息展示装置的具体限定可以参见上文中对于工作队列的信息展示方法的限定,在此不再赘述。上述工作队列的信息展示装置中的各个模块可全部或部分通过软件、硬件及其组合来实现。上述各模块可以硬件形式内嵌于或独立于计算机设备中的处理器中,也可以以软件形式存储于计算机设备中的存储器中,以便于处理器调用执行以上各个模块对应的操作。For the specific limitation of the information display device of the work queue, please refer to the above limitation of the information display method of the work queue, which will not be repeated here. The various modules in the above-mentioned information display device for the work queue can be implemented in whole or in part by software, hardware and a combination thereof. The foregoing modules may be embedded in the form of hardware or independent of the processor in the computer device, or may be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the foregoing modules.
如图7所示,图7为一个实施例中计算机设备的内部结构示意图。该计算机设备10包括通过总线50连接的处理器40和存储器20以及和处理器40连接的网络端口30。其中,该计算机设备10的存储器20中存储有第一获取模块210、第二获取模块220、编辑处理模块230、查询模块240和展示模块250,该计算机可读指令被处理器执行时,可使得处理器40实现一种工作队列的信息展示方法。该计算机设备10的处理器40用于提供计算和控制能力,支撑整个计算机设备的运行。该计算机设备10的网络端口30用于通过网络实现服务器120与处理器40之间的数据交换。As shown in FIG. 7, FIG. 7 is a schematic diagram of the internal structure of a computer device in an embodiment. The computer device 10 includes a processor 40 and a memory 20 connected through a bus 50 and a network port 30 connected to the processor 40. The memory 20 of the computer device 10 stores a first acquisition module 210, a second acquisition module 220, an editing processing module 230, a query module 240, and a display module 250. When the computer readable instruction is executed by the processor, it can make The processor 40 implements a method for displaying information of the work queue. The processor 40 of the computer device 10 is used to provide calculation and control capabilities, and support the operation of the entire computer device. The network port 30 of the computer device 10 is used to implement data exchange between the server 120 and the processor 40 via the network.
本领域技术人员可以理解,图7中示出的结构,仅仅是与本申请方案相关的部分结构的框图,并不构成对本申请方案所应用于其上的计算机设备的限定,具体的计算机设备10可以包括比图中所示更多或更少的部件,或者组合某些部件,或者具有不同的部件布置。Those skilled in the art can understand that the structure shown in FIG. 7 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device 10 It may include more or fewer components than shown in the figures, or combine certain components, or have a different component arrangement.
在一个实施例中,提出了一种计算机设备,计算机设备包括存储器、处理器及存储在存储器上并可在处理器上运行的计算机可读指令,处理器执行计算机可读指令时实现上述任一实施例的工作队列的信息展示方法的步骤。In one embodiment, a computer device is provided. The computer device includes a memory, a processor, and computer-readable instructions stored in the memory and running on the processor. The processor implements any of the above when the computer-readable instructions are executed. The steps of the information display method of the work queue of the embodiment.
在一个实施例中,提出了一种计算机存储介质,计算机存储介质可以为非易失性可读存储介质。In one embodiment, a computer storage medium is provided, and the computer storage medium may be a non-volatile readable storage medium.
该计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器执行上述任一实施例的工作队列的信息展示方法的步骤。When the computer-readable instruction is executed by one or more processors, the one or more processors execute the steps of the information display method of the work queue in any of the foregoing embodiments.
应该理解的是,虽然附图的流程图中的各个步骤按照箭头的指示依次显示,但是这些步骤并不是必然按照箭头指示的顺序依次执行。除非本文中有明确的说明,这些步骤的执行并没有严格的顺序限制,其可以以其他的顺序执行。而且,附图的流程图中的至少一部分步骤可以包括多个子步骤或者多个阶段,这些子步骤或者阶段并不必然是在同一时刻执行完成,而是可以在不同的时刻执行,其执行顺序也不必然是依次进行,而是可以与其他步骤或者其他步骤的子步骤或者阶段的至少一部分轮流或者交替地执行。It should be understood that, although the various steps in the flowchart of the drawings are shown in sequence as indicated by the arrows, these steps are not necessarily executed in sequence in the order indicated by the arrows. Unless explicitly stated in this article, the execution of these steps is not strictly limited in order, and they can be executed in other orders. Moreover, at least part of the steps in the flowchart of the drawings may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily executed at the same time, but can be executed at different times, and the order of execution is also It is not necessarily performed sequentially, but may be performed alternately or alternately with other steps or at least a part of sub-steps or stages of other steps.
以上所述仅是本申请的部分实施方式,应当指出,对于本技术领域的普通技术人员来说,在不脱离本申请原理的前提下,还可以做出若干改进和润饰,这些改进和润饰也应视为本申请的保护范围。The above are only part of the implementation of this application. It should be pointed out that for those of ordinary skill in the art, without departing from the principle of this application, several improvements and modifications can be made, and these improvements and modifications are also Should be regarded as the scope of protection of this application.

Claims (20)

  1. 一种工作队列的信息展示方法,其中,包括如下步骤: A method for displaying work queue information, which includes the following steps:
    获取各个客户的注册信息,根据所述注册信息生成多个特定字段,并将所述特定字段预存到工作队列的数据库中;Acquiring registration information of each customer, generating multiple specific fields according to the registration information, and pre-storing the specific fields in the database of the work queue;
    获取所述工作队列的固定字段,并将所述固定字段同步至配置页面上;其中,所述配置页面为预先配置的页面,用于配置所述特定字段;Acquiring the fixed field of the work queue, and synchronizing the fixed field to a configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field;
    根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理;Extract corresponding specific fields from the database according to the user's editing operation to edit the fixed fields of the work queue on the configuration page;
    在所述数据库中查询所述特定字段对应的字段值,将所述字段值返回到所述配置页面;Query the field value corresponding to the specific field in the database, and return the field value to the configuration page;
    将所述字段值放置在所述编辑处理后的工作队列的相应位置进行展示;Placing the field value in a corresponding position of the edited work queue for display;
    其中,所述根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理的步骤,包括:Wherein, the step of extracting the corresponding specific field from the database according to the user's editing operation to edit the fixed field of the work queue on the configuration page includes:
    获取根据用户需求信息输入的编辑操作;Obtain the editing operation input according to the user's demand information;
    根据所述编辑操作从所述数据库中提取相应的特定字段;Extract corresponding specific fields from the database according to the editing operation;
    利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑;Use the specific field to edit the fixed field of the work queue on the configuration page;
    其中,所述利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑的步骤,包括:Wherein, the step of using the specific field to edit the fixed field of the work queue on the configuration page includes:
    将所述特定字段展示在所述配置页面中;并利用所述展示的特定字段对所述工作队列的固定字段进行编辑;其中,所述编辑包括新增、删减或修改至少一种。The specific field is displayed on the configuration page; and the fixed field of the work queue is edited by using the displayed specific field; wherein, the editing includes at least one of adding, deleting, or modifying.
  2. 根据权利要求1所述的方法,其中,所述利用所述特定字段对所述工作队列的固定字段进行编辑的步骤,包括:The method according to claim 1, wherein the step of using the specific field to edit the fixed field of the work queue comprises:
    获取所述固定字段中与所述特定字段的位置相对应的字段信息;Acquiring field information corresponding to the position of the specific field in the fixed field;
    将所述字段信息与所述特定字段进行比对,并根据比对结果对所述字段信息进行编辑。The field information is compared with the specific field, and the field information is edited according to the comparison result.
  3. 根据权利要求2所述的方法,其中,所述获取所述固定字段中与所述特定字段的位置相对应的字段信息的步骤,包括:The method according to claim 2, wherein the step of obtaining field information corresponding to the position of the specific field in the fixed field comprises:
    获取所述特定字段中的第一特征信息,以及所述固定字段中的第二特征信息;Acquiring the first characteristic information in the specific field and the second characteristic information in the fixed field;
    将所述第一特征信息与所述第二特征信息进行匹配,并根据所述匹配结果得到所述字段信息。The first characteristic information is matched with the second characteristic information, and the field information is obtained according to the matching result.
  4. 根据权利要求3所述的方法,其中,在所述数据库中查询所述特定字段对应的字段值的步骤,包括:The method according to claim 3, wherein the step of querying the field value corresponding to the specific field in the database comprises:
    根据所述字段信息动态拼接SQL语句,并从所述数据库中查询所述动态拼接后的SQL语句的字段值。The SQL sentence is dynamically spliced according to the field information, and the field value of the dynamically spliced SQL sentence is queried from the database.
  5. 根据权利要求4所述的方法,其中,在将所述字段值返回到所述配置页面之前,还包括:The method according to claim 4, wherein before returning the field value to the configuration page, further comprising:
    获取所述查询结果,当所述查询结果为错误代码时,通过所述错误代码查找错误节点,并将所述错误节点改正后重新查询。Obtain the query result, and when the query result is an error code, search for the error node through the error code, correct the error node and query again.
  6. 一种工作队列的信息展示装置,其中,包括:A work queue information display device, which includes:
    第一获取模块,用于获取各个客户的注册信息,根据所述注册信息生成多个特定字段,并将所述特定字段预存到工作队列的数据库中;The first obtaining module is configured to obtain the registration information of each customer, generate a plurality of specific fields according to the registration information, and pre-store the specific fields in the database of the work queue;
    第二获取模块,用于获取所述工作队列的固定字段,并将所述固定字段同步至配置页面上;其中,所述配置页面为预先配置的页面,用于配置所述特定字段;The second obtaining module is configured to obtain fixed fields of the work queue and synchronize the fixed fields to a configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field;
    编辑处理模块,用于根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理;The editing processing module is configured to extract corresponding specific fields from the database according to the user's editing operation to edit the fixed fields of the work queue on the configuration page;
    查询模块,用于在所述数据库中查询所述特定字段对应的字段值,将所述字段值返回到所述配置页面;A query module, configured to query the field value corresponding to the specific field in the database, and return the field value to the configuration page;
    展示模块,用于将所述字段值放置在所述编辑处理后的工作队列的相应位置进行展示;A display module, configured to place the field value in a corresponding position of the edited work queue for display;
    其中,所述编辑处理模块还用于:Wherein, the editing processing module is also used for:
    获取根据用户需求信息输入的编辑操作;Obtain the editing operation input according to the user's demand information;
    根据所述编辑操作从所述数据库中提取相应的特定字段;Extract corresponding specific fields from the database according to the editing operation;
    利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑;Use the specific field to edit the fixed field of the work queue on the configuration page;
    其中,所述编辑处理模块还用于:Wherein, the editing processing module is also used for:
    将所述特定字段展示在所述配置页面中;并利用所述展示的特定字段对所述工作队列的固定字段进行编辑;其中,所述编辑包括新增、删减或修改至少一种。The specific field is displayed on the configuration page; and the fixed field of the work queue is edited by using the displayed specific field; wherein, the editing includes at least one of adding, deleting, or modifying.
  7. 如权利要求6所述的工作队列的信息展示装置,其中,所述编辑处理模块还用于:7. The information display device of the work queue according to claim 6, wherein the editing processing module is further used for:
    获取所述固定字段中与所述特定字段的位置相对应的字段信息;Acquiring field information corresponding to the position of the specific field in the fixed field;
    将所述字段信息与所述特定字段进行比对,并根据比对结果对所述字段信息进行编辑。The field information is compared with the specific field, and the field information is edited according to the comparison result.
  8. 如权利要求7所述的工作队列的信息展示装置,其中,所述编辑处理模块还用于:8. The information display device of the work queue according to claim 7, wherein the editing processing module is further used for:
    获取所述特定字段中的第一特征信息,以及所述固定字段中的第二特征信息;Acquiring the first characteristic information in the specific field and the second characteristic information in the fixed field;
    将所述第一特征信息与所述第二特征信息进行匹配,并根据所述匹配结果得到所述字段信息。The first characteristic information is matched with the second characteristic information, and the field information is obtained according to the matching result.
  9. 如权利要求8所述的工作队列的信息展示装置,其中,所述查询模块还用于:8. The information display device of the work queue according to claim 8, wherein the query module is further used for:
    根据所述字段信息动态拼接SQL语句,并从所述数据库中查询所述动态拼接后的SQL语句的字段值。The SQL sentence is dynamically spliced according to the field information, and the field value of the dynamically spliced SQL sentence is queried from the database.
  10. 如权利要求9所述的工作队列的信息展示装置,其中,所述查询模块还用于:9. The information display device of the work queue according to claim 9, wherein the query module is further used for:
    获取所述查询结果,当所述查询结果为错误代码时,通过所述错误代码查找错误节点,并将所述错误节点改正后重新查询。Obtain the query result, and when the query result is an error code, search for the error node through the error code, correct the error node and query again.
  11. 一种计算机设备,其中:包括存储器和处理器,所述存储器中存储有计算机可读指令,其中,所述计算机可读指令被所述处理器执行时,使得所述处理器执行如下步骤:A computer device, which includes a memory and a processor, and computer-readable instructions are stored in the memory. When the computer-readable instructions are executed by the processor, the processor is caused to perform the following steps:
    获取各个客户的注册信息,根据所述注册信息生成多个特定字段,并将所述特定字段预存到工作队列的数据库中;Acquiring registration information of each customer, generating multiple specific fields according to the registration information, and pre-storing the specific fields in the database of the work queue;
    获取所述工作队列的固定字段,并将所述固定字段同步至配置页面上;其中,所述配置页面为预先配置的页面,用于配置所述特定字段;Acquiring the fixed field of the work queue, and synchronizing the fixed field to a configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field;
    根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理;Extract corresponding specific fields from the database according to the user's editing operation to edit the fixed fields of the work queue on the configuration page;
    在所述数据库中查询所述特定字段对应的字段值,将所述字段值返回到所述配置页面;Query the field value corresponding to the specific field in the database, and return the field value to the configuration page;
    将所述字段值放置在所述编辑处理后的工作队列的相应位置进行展示;Placing the field value in a corresponding position of the edited work queue for display;
    其中,所述根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理的步骤,包括:Wherein, the step of extracting the corresponding specific field from the database according to the user's editing operation to edit the fixed field of the work queue on the configuration page includes:
    获取根据用户需求信息输入的编辑操作;Obtain the editing operation input according to the user's demand information;
    根据所述编辑操作从所述数据库中提取相应的特定字段;Extract corresponding specific fields from the database according to the editing operation;
    利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑;Use the specific field to edit the fixed field of the work queue on the configuration page;
    其中,所述利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑的步骤,包括:Wherein, the step of using the specific field to edit the fixed field of the work queue on the configuration page includes:
    将所述特定字段展示在所述配置页面中;并利用所述展示的特定字段对所述工作队列的固定字段进行编辑;其中,所述编辑包括新增、删减或修改至少一种。The specific field is displayed on the configuration page; and the fixed field of the work queue is edited by using the displayed specific field; wherein, the editing includes at least one of adding, deleting, or modifying.
  12. 如权利要求11所述的计算机设备,其中:所述利用所述特定字段对所述工作队列的固定字段进行编辑的步骤,包括:11. The computer device according to claim 11, wherein: said step of using said specific field to edit a fixed field of said work queue comprises:
    获取所述固定字段中与所述特定字段的位置相对应的字段信息;Acquiring field information corresponding to the position of the specific field in the fixed field;
    将所述字段信息与所述特定字段进行比对,并根据比对结果对所述字段信息进行编辑。The field information is compared with the specific field, and the field information is edited according to the comparison result.
  13. 如权利要求12所述的计算机设备,其中:所述获取所述固定字段中与所述特定字段的位置相对应的字段信息的步骤,包括:The computer device according to claim 12, wherein: said step of obtaining field information corresponding to the position of said specific field in said fixed field comprises:
    获取所述特定字段中的第一特征信息,以及所述固定字段中的第二特征信息;Acquiring the first characteristic information in the specific field and the second characteristic information in the fixed field;
    将所述第一特征信息与所述第二特征信息进行匹配,并根据所述匹配结果得到所述字段信息。The first characteristic information is matched with the second characteristic information, and the field information is obtained according to the matching result.
  14. 如权利要求13所述的计算机设备,其中:在所述数据库中查询所述特定字段对应的字段值的步骤,包括:The computer device according to claim 13, wherein: the step of querying the field value corresponding to the specific field in the database comprises:
    根据所述字段信息动态拼接SQL语句,并从所述数据库中查询所述动态拼接后的SQL语句的字段值。The SQL sentence is dynamically spliced according to the field information, and the field value of the dynamically spliced SQL sentence is queried from the database.
  15. 如权利要求14所述的计算机设备,其中:在将所述字段值返回到所述配置页面之前,还包括:The computer device according to claim 14, wherein: before returning the field value to the configuration page, further comprising:
    获取所述查询结果,当所述查询结果为错误代码时,通过所述错误代码查找错误节点,并将所述错误节点改正后重新查询。Obtain the query result, and when the query result is an error code, search for the error node through the error code, correct the error node and query again.
  16. 一种计算机存储介质,其中:所述计算机可读指令被一个或多个处理器执行时,使得一个或多个处理器执行如下步骤:A computer storage medium, wherein when the computer-readable instructions are executed by one or more processors, the one or more processors execute the following steps:
    获取各个客户的注册信息,根据所述注册信息生成多个特定字段,并将所述特定字段预存到工作队列的数据库中;Acquiring registration information of each customer, generating multiple specific fields according to the registration information, and pre-storing the specific fields in the database of the work queue;
    获取所述工作队列的固定字段,并将所述固定字段同步至配置页面上;其中,所述配置页面为预先配置的页面,用于配置所述特定字段;Acquiring the fixed field of the work queue, and synchronizing the fixed field to a configuration page; wherein, the configuration page is a pre-configured page for configuring the specific field;
    根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理;Extract corresponding specific fields from the database according to the user's editing operation to edit the fixed fields of the work queue on the configuration page;
    在所述数据库中查询所述特定字段对应的字段值,将所述字段值返回到所述配置页面;Query the field value corresponding to the specific field in the database, and return the field value to the configuration page;
    将所述字段值放置在所述编辑处理后的工作队列的相应位置进行展示;Placing the field value in a corresponding position of the edited work queue for display;
    其中,所述根据用户的编辑操作从数据库中提取相应特定字段对所述配置页面上的所述工作队列的固定字段进行编辑处理的步骤,包括:Wherein, the step of extracting the corresponding specific field from the database according to the user's editing operation to edit the fixed field of the work queue on the configuration page includes:
    获取根据用户需求信息输入的编辑操作;Obtain the editing operation input according to the user's demand information;
    根据所述编辑操作从所述数据库中提取相应的特定字段;Extract corresponding specific fields from the database according to the editing operation;
    利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑;Use the specific field to edit the fixed field of the work queue on the configuration page;
    其中,所述利用所述特定字段对所述配置页面上的所述工作队列的固定字段进行编辑的步骤,包括:Wherein, the step of using the specific field to edit the fixed field of the work queue on the configuration page includes:
    将所述特定字段展示在所述配置页面中;并利用所述展示的特定字段对所述工作队列的固定字段进行编辑;其中,所述编辑包括新增、删减或修改至少一种。The specific field is displayed on the configuration page; and the fixed field of the work queue is edited by using the displayed specific field; wherein, the editing includes at least one of adding, deleting, or modifying.
  17. 如权利要求16所述的计算机存储介质,其中:所述利用所述特定字段对所述工作队列的固定字段进行编辑的步骤,包括:16. The computer storage medium of claim 16, wherein: said step of using said specific field to edit a fixed field of said work queue comprises:
    获取所述固定字段中与所述特定字段的位置相对应的字段信息;Acquiring field information corresponding to the position of the specific field in the fixed field;
    将所述字段信息与所述特定字段进行比对,并根据比对结果对所述字段信息进行编辑。The field information is compared with the specific field, and the field information is edited according to the comparison result.
  18. 如权利要求17所述的计算机存储介质,其中:所述获取所述固定字段中与所述特定字段的位置相对应的字段信息的步骤,包括:17. The computer storage medium of claim 17, wherein: said step of obtaining field information corresponding to the position of said specific field in said fixed field comprises:
    获取所述特定字段中的第一特征信息,以及所述固定字段中的第二特征信息;Acquiring the first characteristic information in the specific field and the second characteristic information in the fixed field;
    将所述第一特征信息与所述第二特征信息进行匹配,并根据所述匹配结果得到所述字段信息。The first characteristic information is matched with the second characteristic information, and the field information is obtained according to the matching result.
  19. 如权利要求18所述的计算机存储介质,其中:在所述数据库中查询所述特定字段对应的字段值的步骤,包括:18. The computer storage medium of claim 18, wherein: the step of querying the field value corresponding to the specific field in the database comprises:
    根据所述字段信息动态拼接SQL语句,并从所述数据库中查询所述动态拼接后的SQL语句的字段值。The SQL sentence is dynamically spliced according to the field information, and the field value of the dynamically spliced SQL sentence is queried from the database.
  20. 如权利要求19所述的计算机存储介质,其中:在将所述字段值返回到所述配置页面之前,还包括:19. The computer storage medium of claim 19, wherein: before returning the field value to the configuration page, further comprising:
    获取所述查询结果,当所述查询结果为错误代码时,通过所述错误代码查找错误节点,并将所述错误节点改正后重新查询。 Obtain the query result, and when the query result is an error code, search for the error node through the error code, correct the error node and query again. To
PCT/CN2019/118382 2019-04-04 2019-11-14 Information presentation method and apparatus for work queue, and computer device and storage medium WO2020199599A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201910270006.3A CN110109981B (en) 2019-04-04 2019-04-04 Information display method and device for work queue, computer equipment and storage medium
CN201910270006.3 2019-04-04

Publications (1)

Publication Number Publication Date
WO2020199599A1 true WO2020199599A1 (en) 2020-10-08

Family

ID=67485104

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2019/118382 WO2020199599A1 (en) 2019-04-04 2019-11-14 Information presentation method and apparatus for work queue, and computer device and storage medium

Country Status (2)

Country Link
CN (1) CN110109981B (en)
WO (1) WO2020199599A1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115438240A (en) * 2022-09-16 2022-12-06 中国建设银行股份有限公司 Data processing method and device, electronic equipment and storage medium

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110109981B (en) * 2019-04-04 2023-07-25 平安科技(深圳)有限公司 Information display method and device for work queue, computer equipment and storage medium
CN110795101B (en) * 2019-09-18 2024-01-30 平安科技(深圳)有限公司 SQL code information display method, device, computer device and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080319958A1 (en) * 2007-06-22 2008-12-25 Sutirtha Bhattacharya Dynamic Metadata based Query Formulation for Multiple Heterogeneous Database Systems
CN101739453A (en) * 2009-12-17 2010-06-16 中国电力科学研究院 Method and device for carrying out condition query on database table
CN109165266A (en) * 2018-09-03 2019-01-08 中国平安人寿保险股份有限公司 List generation method, device, computer equipment and storage medium
CN110109981A (en) * 2019-04-04 2019-08-09 平安科技(深圳)有限公司 Information displaying method, device, computer equipment and the storage medium of work queue

Family Cites Families (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
RU2595530C1 (en) * 2015-04-14 2016-08-27 Общество С Ограниченной Ответственностью "Аилайн Кэмьюникейшнс Снг" System and method for selection of content for displaying to user
CN106951430B (en) * 2016-12-28 2019-12-06 金蝶软件(中国)有限公司 Account table query method and device
US10650056B2 (en) * 2017-05-05 2020-05-12 Servicenow, Inc. Template-based faceted search experience
CN107391612B (en) * 2017-07-04 2020-06-12 石化盈科信息技术有限责任公司 Method and device for configuring field
CN108334534A (en) * 2017-10-27 2018-07-27 平安普惠企业管理有限公司 Operation system field configuration method, apparatus, server and readable storage medium storing program for executing
CN108446344A (en) * 2018-03-06 2018-08-24 政采云有限公司 Custom condition querying method and system
CN109522068A (en) * 2018-10-17 2019-03-26 大唐网络有限公司 The edit methods of the methods of exhibiting and system of the page, page data

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080319958A1 (en) * 2007-06-22 2008-12-25 Sutirtha Bhattacharya Dynamic Metadata based Query Formulation for Multiple Heterogeneous Database Systems
CN101739453A (en) * 2009-12-17 2010-06-16 中国电力科学研究院 Method and device for carrying out condition query on database table
CN109165266A (en) * 2018-09-03 2019-01-08 中国平安人寿保险股份有限公司 List generation method, device, computer equipment and storage medium
CN110109981A (en) * 2019-04-04 2019-08-09 平安科技(深圳)有限公司 Information displaying method, device, computer equipment and the storage medium of work queue

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115438240A (en) * 2022-09-16 2022-12-06 中国建设银行股份有限公司 Data processing method and device, electronic equipment and storage medium

Also Published As

Publication number Publication date
CN110109981A (en) 2019-08-09
CN110109981B (en) 2023-07-25

Similar Documents

Publication Publication Date Title
WO2020199599A1 (en) Information presentation method and apparatus for work queue, and computer device and storage medium
WO2020015067A1 (en) Data acquisition method, device, equipment and storage medium
WO2018058959A1 (en) Sql auditing method and apparatus, server and storage device
WO2018201773A1 (en) Cell page rendering method, apparatus, server, and readable storage medium
WO2020087981A1 (en) Method and apparatus for generating risk control audit model, device and readable storage medium
WO2020147385A1 (en) Data entry method and apparatus, terminal and computer-readable storage medium
WO2018214320A1 (en) Database service logic monitoring method and system, and storage medium
WO2020062640A1 (en) Method, server and storage medium for switching dynamic copywriting language of terminal application
WO2019174090A1 (en) Screenshot file sharing control method, apparatus and device, and computer storage medium
WO2021003956A1 (en) Product information management method, apparatus and device, and storage medium
WO2020258656A1 (en) Code segment generation method and apparatus, storage medium and computer device
WO2018076865A1 (en) Data sharing method, device, storage medium, and electronic device
WO2018120681A1 (en) Data synchronization method, device and system, data processing server, and storage medium
WO2010123168A1 (en) Database management method and system
WO2016101441A1 (en) File synchronization method and system
WO2012155709A1 (en) A method, system and storage medium for pushing user's personal label dynamically
WO2020233089A1 (en) Test case generating method and apparatus, terminal, and computer readable storage medium
WO2019019350A1 (en) Method, apparatus and device for generating account opening page and computer readable storage medium
WO2020177376A1 (en) Data extraction method and apparatus, terminal and computer-readable storage medium
WO2020119384A1 (en) Medical insurance abnormity detection method, apparatus and device based on big data analysis, and medium
WO2020119369A1 (en) Intelligent it operation and maintenance fault positioning method, apparatus and device, and readable storage medium
WO2020062658A1 (en) Contract generation method and apparatus, and device and storage medium
WO2020107591A1 (en) Double insurance limiting method, apparatus, device, and readable storage medium
WO2019024485A1 (en) Data sharing method and device and computer readable storage medium
WO2017206454A1 (en) Fingerprint-based photographing processing method and apparatus

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 19923543

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 19923543

Country of ref document: EP

Kind code of ref document: A1