Custom form multi-printing template processing method and system and medium

Abstract

The invention discloses a self-defined form multi-printing template processing method and system and a medium, mainly relates to the technical field of template processing, and is used for solving the problems that front and rear ends of an existing scheme are seriously coupled, dynamic field binding capability is lacked, and diversified printing requirements of the same form are difficult to support. Comprising the steps of presetting a custom style component based on configuration of a configuration interface, and obtaining a specific custom style of a table template; displaying a preset table containing content fields, static characters and specific custom styles on a printing template list; after printing is triggered, a preset printing template list selection interface is entered, and then a specific printing template is determined; obtaining a content field corresponding to the printing template, a specific self-defined style and preset template configuration data of the printing template; replacing the placeholder characters in the cells of the printing template with the content fields, and after replacement is completed, rendering the printing template into the page.

Description

Technical Field

[0001] The present application relates to the field of custom form technology, and in particular to a method, system, and medium for processing multiple print templates for a custom form. Background Art

[0002] Current mainstream content template printing technologies are primarily based on backend services, utilizing a server-side rendering model. Typical solutions involve using backend languages ​​like Java and PHP in conjunction with libraries like Apache POI and iText to generate PDF / Excel templates, achieving data and style binding. While Luckysheet, a front-end spreadsheet component, offers rich spreadsheet functionality, its design focuses more on collaborative editing and has limited support for dynamic form printing scenarios. This architecture results in a system that is highly dependent on backend processing, requiring a complete server-side rendering process for each print request.

[0003] The main shortcomings of existing technologies include: 1) severe front-end and back-end coupling, requiring server-side involvement for any template adjustments, resulting in response delays; 2) Luckysheet lacks dynamic field binding capabilities, unable to intelligently handle placeholder replacement and conditional styles; and 3) managing multiple templates is difficult, making it difficult for existing solutions to support diverse printing requirements for the same form. These issues directly impact system flexibility and performance. Summary of the Invention

[0004] The present application provides a method, system and medium for processing multiple printing templates for a custom form to solve the problems of existing solutions such as severe front-end and back-end coupling, lack of dynamic field binding capabilities, and difficulty in supporting diverse printing requirements of the same form.

[0005] In a first aspect, the present application provides a method for processing multiple print templates for a custom form, the method comprising: Get all the content fields of the custom form configuration and display them in the preset configuration field display area of ​​the configuration interface; call the Luckysheet component to generate an online form and display it in the preset form template configuration area of ​​the configuration interface; Set up paired trigger operation components in the preset configuration field display area and the preset table template configuration area to configure the content fields and preset tables; In the preset table template configuration area, preset trigger input program is set. Then, after receiving the preset trigger operation, the static text corresponding to the dynamic field in the table template is obtained through the preset input box; based on the configuration preset custom style component of the configuration interface, the specific custom style of the table template is obtained; the preset table containing content fields, static text, and specific custom style is displayed in the print template list; After printing is triggered, enter the preset printing template list selection interface to determine the specific printing template; Get the content field, specific custom style, and preset template configuration data corresponding to the print template; replace the placeholder characters in the print template cell with the content field. After the replacement is completed, render the print template to the page; print when a print trigger operation is received.

[0006] In one implementation of the present application, a pairing trigger operation component is set in the preset configuration field display area and the preset table template configuration area to configure the content field and the preset table, specifically including: Use the third-party plug-in sortablejs to create the content field as a draggable object; Drag the content field to the template area corresponding to the preset table to automatically generate a binding relationship.

[0007] In one implementation of the present application, before replacing the placeholder characters in the print template cell with the content field, the method further includes: Get the number of actual subform data items involved in the content field and the number of placeholder configuration items involved in the print template cell; When the actual number of subform data items exceeds the number of placeholder configuration items, the template expansion mechanism is triggered.

[0008] In one implementation of the present application, the content field replaces the placeholder characters in the print template cell, specifically including: When the content field is image data, create a <img src=""” / "> The tag is used to carry the image content. Put the content field in the src attribute of the tag and replace the entire img tag with placeholder characters.

[0009] When the content field is attachment data, create a <a src=""”"> Tag, put the content field address into the src attribute in the tag, and replace the placeholder with the entire a tag; When the content field is Boolean data, convert the data into the display format of √× and then replace the placeholder; When the content field contains alias data, the relationship between the alias and the display data is converted based on the mapping relationship between the alias and the display data, and the converted display data replaces the placeholder; When the content field is time data, convert the time data into a preset time format; When the content field contains annotated data, the placeholder is replaced by the annotated content and the content field.

[0010] In one implementation of the present application, upon receiving a print trigger operation, printing is performed, specifically including: Use the print html mode provided by the pringjs plug-in for printing.

[0011] In a second aspect, the present application provides a custom form multi-print template processing system, the system comprising: Configure the printing module to obtain all content fields of the custom form configuration and display them in the preset configuration field display area of ​​the configuration interface; call the Luckysheet component to generate an online form and display it in the preset form template configuration area of ​​the configuration interface; set the paired trigger operation component in the preset configuration field display area and the preset form template configuration area to configure the content fields and the preset form; in the preset form template configuration area, preset the trigger input program, and then after receiving the preset trigger operation, obtain the static text corresponding to the dynamic field in the form template through the preset input box; based on the configuration preset custom style component of the configuration interface, obtain the specific custom style of the form template; display the preset form containing content fields, static text, and specific custom style in the print template list; The custom template module is used to enter the preset printing template list selection interface after printing is triggered, and then determine the specific printing template; The rendering and printing module is used to obtain the content field, specific custom style, and preset template configuration data corresponding to the printing template; replace the placeholder characters in the printing template cell with the content field, and after completing the replacement, render the printing template to the page; and print when a print trigger operation is received.

[0012] In one implementation of the present application, the configuration printing module includes a configuration unit, Use the third-party plug-in sortablejs to create the content field as a draggable object; Drag the content field to the template area corresponding to the preset table to automatically generate a binding relationship.

[0013] In one implementation of the present application, the number of actual subform data items involved in the content field and the number of placeholder configuration items involved in the print template cell are obtained; When the actual number of subform data items exceeds the number of placeholder configuration items, the template expansion mechanism is triggered.

[0014] In one implementation of the present application, the rendering and printing module includes a replacement unit, Used to create a <img src=""” / "> The tag is used to carry the image content. Put the content field in the src attribute of the tag and replace the entire img tag with placeholder characters.

[0015] When the content field is attachment data, create a <a src=""”"> Tag, put the content field address into the src attribute in the tag, and replace the placeholder with the entire a tag; When the content field is Boolean data, convert the data into the display format of √× and then replace the placeholder; When the content field contains alias data, the relationship between the alias and the display data is converted based on the mapping relationship between the alias and the display data, and the converted display data replaces the placeholder; When the content field is time data, the time data is converted into a preset time format; When the content field contains annotated data, the placeholder is replaced by the annotated content and the content field.

[0016] In a third aspect, the present application provides a non-volatile computer storage medium having computer instructions stored thereon, which, when executed, implement a method for processing multiple custom form print templates as described above.

[0017] It can be seen from the above technical solutions that this application has the following advantages: First, through front-end visual configuration and dynamic binding mechanisms, front-end and back-end decoupling is achieved. Users can complete template configuration and style adjustments directly on the browser without relying on server-side processing, significantly improving response speed and reducing server load.

[0018] Secondly, the functionality of the Luckysheet component has been expanded. By pre-setting trigger input programs and pairing trigger operation components, the system now enables intelligent binding of dynamic fields to cells. This system can automatically replace placeholders and adapt conditional styles, solving the problems of heavy manual coding and lack of flexibility in existing technologies.

[0019] Finally, through print template list management and pre-set template configuration data storage, multiple templates for the same form are supported. Users can easily configure print templates for different purposes (such as simplified and detailed versions) and flexibly select them when printing, meeting the diverse needs of business scenarios. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] In order to more clearly illustrate the technical solution of the present invention, the following is a brief introduction to the drawings required for the description. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0021] Figure 1 This is a flow chart of a method for processing multiple print templates for a custom form provided in an embodiment of the present application.

[0022] Figure 2 This is a schematic diagram of the internal structure of a custom form multi-print template processing system provided in an embodiment of the present application. DETAILED DESCRIPTION

[0023] The following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts are within the scope of protection of the present invention.

[0024] It should be understood by those skilled in the art that the embodiments described below are merely preferred embodiments of the present disclosure and do not imply that the present disclosure can only be implemented through these preferred embodiments. These preferred embodiments are merely intended to explain the technical principles of the present disclosure and are not intended to limit the scope of protection of the present disclosure. Based on the preferred embodiments provided by the present disclosure, all other embodiments obtained by those skilled in the art without creative effort should still fall within the scope of protection of the present disclosure.

[0025] It should also be noted that the terms "comprises," "includes," or any other variations thereof are intended to encompass non-exclusive inclusion, such that a process, method, commodity, or apparatus that includes a series of elements includes not only those elements but also other elements not explicitly listed, or includes elements inherent to such process, method, commodity, or apparatus. In the absence of further limitations, an element defined by the phrase "comprises a ..." does not exclude the presence of other identical elements in the process, method, commodity, or apparatus that includes the element.

[0026] The technical solutions proposed in the embodiments of the present application are described in detail below with reference to the accompanying drawings.

[0027] The embodiment provides a method for processing multiple print templates of a custom form, such as Figure 1 As shown, the method provided in the embodiment of the present application mainly includes the following steps: Step 110: Get all the content fields configured in the custom form and display them in the preset configuration field display area of ​​the configuration interface; call the Luckysheet component to generate an online form and display it in the preset form template configuration area of ​​the configuration interface; set a pairing trigger operation component in the preset configuration field display area and the preset form template configuration area to configure the content fields and the preset form.

[0028] In the preset configuration field display area and the preset table template configuration area, set the paired trigger operation component to configure the content field and the preset table, including: Use the third-party plug-in sortablejs to create content fields as draggable objects; Drag the content field to the template area corresponding to the preset table to automatically generate a binding relationship.

[0029] Based on the above description, this step retrieves all content fields of the custom form and displays them in the preset area of ​​the configuration interface. Simultaneously, the Luckysheet component is called to generate an online form, which is displayed in another dedicated form template configuration area. These two areas together constitute the main workspace of the configuration interface. A special pairing trigger action component is set between the two areas. The core function of this component is to establish an association between content fields and form templates. Through this component, users can intuitively configure the form fields and forms accordingly.

[0030] This is achieved by using the third-party plugin, sortablejs, to transform content fields into draggable elements. Users simply drag fields to the corresponding locations in the table, and the system automatically establishes the binding. This approach simplifies the configuration process, making it easy for even non-technical users to set up complex form-table associations.

[0031] Step 120. In the preset table template configuration area, preset a trigger input program, and then after receiving the preset trigger operation, obtain the static text corresponding to the dynamic field in the table template through the preset input box; obtain the specific custom style of the table template based on the preset custom style component configured in the configuration interface; display the preset table containing content fields, static text, and specific custom style in the print template list.

[0032] Based on the above description, this step achieves a perfect combination of dynamic data and static presentation. The system first presets a trigger mechanism in the table template area. When the user performs a specific action, the system automatically identifies the dynamic fields in the table and allows the user to add static description text for these fields through a pre-set input box. For example, in a sales report template, the dynamic field "Sales" can be associated with a static title such as "Sales Results for the First Quarter of 2025." Rich style customization is also provided. Users can freely adjust visual elements such as the table's font, color, and borders using style components within the interface. For example, important data can be bolded in red or a background color can be added to the table header. This WYSIWYG configuration method greatly enhances the user experience. The resulting template integrates dynamic fields, static text, and custom styles, and is displayed uniformly in the print template list. This design ensures dynamic data updates while ensuring aesthetically pleasing printouts, making it suitable for business scenarios that require the regular generation of standardized reports. The entire process requires no coding; professional-level table template configuration can be completed through visual operations.

[0033] Step 130: After printing is triggered, enter the preset printing template list selection interface to determine the specific printing template.

[0034] Those skilled in the art will appreciate that the printing template list involved in this step includes several printing templates, which solves the printing problem in scenarios with complex custom form requirements, and by configuring multiple printing templates, realizes the requirement of printing multiple receipts for a custom form.

[0035] Step 140: Obtain the content field, specific custom style, and preset template configuration data corresponding to the print template; replace the placeholder characters in the print template cell with the content field. After the replacement is completed, render the print template to the page; and print when a print trigger operation is received.

[0036] In some embodiments, before replacing the placeholder characters in the print template cells with the content field, the method further includes: Get the actual number of subform data items involved in the content field and the number of placeholder configuration items involved in the print template cell; when the actual number of subform data items is greater than the number of placeholder configuration items, trigger the template expansion mechanism.

[0037] Among them, the content field replaces the placeholder characters in the print template cell, specifically including: When the content field is image data, create a <img src=""” / "> The tag is used to carry the image content. Put the content field in the src attribute of the tag and replace the entire img tag with placeholder characters.

[0038] When the content field is attachment data, create a <a src=""”"> Tag, put the content field address into the src attribute in the tag, and replace the placeholder with the entire a tag; When the content field is Boolean data, convert the data into the display format of √× and then replace the placeholder; When the content field contains alias data, the relationship between the alias and the display data is converted based on the mapping relationship between the alias and the display data, and the converted display data replaces the placeholder; When the content field is time data, the time data is converted into a preset time format; When the content field contains annotated data, the placeholder is replaced by the annotated content and the content field.

[0039] When a print trigger is received, printing is performed, including: Use the print html mode provided by the pringjs plug-in for printing.

[0040] Based on the above steps, we can see that this application can automatically detect the relationship between the amount of data and the number of template placeholders. When the actual amount of data exceeds the preset number of placeholders, the system triggers the template expansion mechanism and automatically adjusts the template structure to accommodate the additional data. For example, in an employee information table, if 5 rows are preset but there are actually 8 employee data, the system will automatically add 3 rows of templates.

[0041] Support for multiple data types: The system has designed special display solutions for different types of data: Image data will be converted into visual image elements; The attachment will generate a clickable download link; Boolean values ​​are visually displayed as √ or × symbols; Data with aliases will be automatically converted to human-readable display names; Time data will be formatted uniformly; Annotated data retains the annotation information.

[0042] In addition, this application uses a professional printing plug-in that can precisely control the printout effect, ensuring that the printed result is exactly the same as the on-screen preview. For example, when printing a sales contract, the system will retain all formatting and styles, including key elements such as the company logo and signature position.

[0043] Based on the foregoing description, it can be seen that in this embodiment, by visually associating the form content fields with the Luckysheet table component, the user can directly complete the field mapping through pairing operations such as dragging and dropping. For example: in the contract management system, the user can drag the "Party A Name" field directly to the specified cell of the table, and the system will automatically establish a binding relationship, which is more efficient than the traditional manual writing of field mapping code. A placeholder replacement mechanism is used to achieve intelligent rendering. Specific case: When printing a purchase order, the system automatically replaces the "${productName}" placeholder with the actual product name and maintains the preset bold red style. This processing method allows the same template to adapt to scenarios with different data volumes, such as 10 rows of products and 100 rows of products can be correctly paged and displayed. From template configuration to final printing, everything is completed on the browser side. Typical scenario: After the user adjusts the column width of the quotation, the effect can be previewed immediately without waiting for the server to respond.

[0044] In addition, this application Figure 2 A custom form multi-print template processing system is provided in the embodiment of the present application. Figure 2 As shown, the system provided in the embodiment of the present application mainly includes: Configuration printing module 210 is used to obtain all content fields of the custom form configuration and display them in the preset configuration field display area of ​​the configuration interface; call the Luckysheet component to generate an online form and display it in the preset form template configuration area of ​​the configuration interface; set a pairing trigger operation component in the preset configuration field display area and the preset form template configuration area to configure the content field and the preset form; in the preset form template configuration area, preset a trigger input program, and then after receiving the preset trigger operation, obtain the static text corresponding to the dynamic field in the form template through the preset input box; based on the configuration preset custom style component of the configuration interface, obtain the specific custom style of the form template; display the preset form containing content fields, static text, and specific custom style in the print template list.

[0045] The configuration printing module 210 includes a configuration unit, Use the third-party plug-in sortablejs to create content fields as draggable objects; Drag the content field to the template area corresponding to the preset table to automatically generate a binding relationship.

[0046] The custom template module 220 is used to enter the preset printing template list selection interface after printing is triggered, and then determine the specific printing template; The rendering and printing module 230 is used to obtain the content field, specific custom style, and preset template configuration data of the printing template corresponding to the printing template; replace the placeholder characters in the printing template cell with the content field, and after the replacement is completed, render the printing template to the page; and print when a print trigger operation is received.

[0047] The rendering and printing module 230 includes an expansion unit for obtaining the number of actual subform data items involved in the content field and the number of placeholder configuration items involved in the print template cell; When the actual number of subform data items exceeds the number of placeholder configuration items, the template expansion mechanism is triggered.

[0048] The rendering and printing module 230 includes a replacement unit, Used to create a <img src=""” / "> The tag is used to carry the image content. Put the content field in the src attribute of the tag and replace the entire img tag with placeholder characters.

[0049] When the content field is attachment data, create a <a src=""”"> Tag, put the content field address into the src attribute in the tag, and replace the placeholder with the entire a tag; When the content field is Boolean data, convert the data into the display format of √× and then replace the placeholder; When the content field contains alias data, the relationship between the alias and the display data is converted based on the mapping relationship between the alias and the display data, and the converted display data replaces the placeholder; When the content field is time data, the time data is converted into a preset time format; When the content field contains annotated data, the placeholder is replaced by the annotated content and the content field.

[0050] In addition, an embodiment of the present application further provides a non-volatile computer storage medium on which executable instructions are stored. When the executable instructions are executed, a method for processing multiple print templates of a customized form as described above is implemented.

[0051] The above description of the disclosed embodiments is intended to enable one skilled in the art to implement or use the present invention. Various modifications to these embodiments will be readily apparent to one skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention is not limited to the embodiments shown herein but is intended to conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for processing multiple print templates for a custom form, characterized in that: The method comprises: Get all the content fields configured in the custom form and display them in the preset configuration field display area of ​​the configuration interface; call the Luckysheet component to generate an online form and display it in the preset form template configuration area of ​​the configuration interface; set up a pairing trigger operation component in the preset configuration field display area and the preset form template configuration area to configure the content fields and the preset form; In the preset table template configuration area, preset trigger input program is set. Then, after receiving the preset trigger operation, the static text corresponding to the dynamic field in the table template is obtained through the preset input box; based on the configuration preset custom style component of the configuration interface, the specific custom style of the table template is obtained; the preset table containing content fields, static text, and specific custom style is displayed in the print template list; After printing is triggered, enter the preset printing template list selection interface to determine the specific printing template; Get the content field, specific custom style, and preset template configuration data corresponding to the print template; replace the placeholder characters in the print template cell with the content field. After the replacement is completed, render the print template to the page; print when a print trigger operation is received.

2. The method for processing multiple print templates of a custom form according to claim 1, characterized in that: In the Preset Configuration Field Display area and the Preset Table Template Configuration area, set up paired trigger action components to configure the content fields and the preset table, including: Use the third-party plug-in sortablejs to create content fields as draggable objects; Drag the content field to the template area corresponding to the preset table to automatically generate a binding relationship.

3. The method for processing multiple print templates of a custom form according to claim 1, characterized in that: Before replacing the placeholder characters in the print template cells with the content field, the method further includes: Get the number of actual subform data items involved in the content field and the number of placeholder configuration items involved in the print template cell; When the actual number of subform data items exceeds the number of placeholder configuration items, the template expansion mechanism is triggered.

4. The method for processing multiple print templates of a custom form according to claim 1, characterized in that: Replace the placeholder characters in the print template cells with the content field, including: When the content field is image data, create a <img src=""” / "> The tag is used to carry the image content. Put the content field in the src attribute of the tag and replace the entire img tag with placeholder characters. When the content field is attachment data, create a <a src=""”"> Tag, put the content field address into the src attribute in the tag, and replace the placeholder with the entire a tag; When the content field is Boolean data, convert the data into the display format of √× and then replace the placeholder; When the content field contains alias data, the relationship between the alias and the display data is converted based on the mapping relationship between the alias and the display data, and the converted display data replaces the placeholder; When the content field is time data, the time data is converted into a preset time format; When the content field contains annotated data, the placeholder is replaced by the annotated content and the content field.

5. The method for processing multiple print templates of a custom form according to claim 1, characterized in that: When a print trigger is received, printing is performed, including: Use the print html mode provided by the pringjs plug-in for printing.

6. A custom form multi-print template processing system, characterized by: The system comprises: Configure the printing module to obtain all content fields of the custom form configuration and display them in the preset configuration field display area of ​​the configuration interface; call the Luckysheet component to generate an online form and display it in the preset form template configuration area of ​​the configuration interface; set the paired trigger operation component in the preset configuration field display area and the preset form template configuration area to configure the content fields and the preset form; in the preset form template configuration area, preset the trigger input program, and then after receiving the preset trigger operation, obtain the static text corresponding to the dynamic field in the form template through the preset input box; based on the configuration preset custom style component of the configuration interface, obtain the specific custom style of the form template; display the preset form containing content fields, static text, and specific custom style in the print template list; The custom template module is used to enter the preset printing template list selection interface after printing is triggered, and then determine the specific printing template; The rendering and printing module is used to obtain the content field, specific custom style, and preset template configuration data corresponding to the printing template; replace the placeholder characters in the printing template cell with the content field, and after completing the replacement, render the printing template to the page; and print when a print trigger operation is received.

7. The custom form multi-print template processing system according to claim 6, characterized in that: The configuration printing module includes a configuration unit, Use the third-party plug-in sortablejs to create content fields as draggable objects; Drag the content field to the template area corresponding to the preset table to automatically generate a binding relationship.

8. The custom form multi-print template processing system according to claim 6, characterized in that: The rendering and printing module includes an extension unit for obtaining the number of actual subform data items involved in the content field and the number of placeholder configuration items involved in the print template cell; When the actual number of subform data items exceeds the number of placeholder configuration items, the template expansion mechanism is triggered.

9. The custom form multi-print template processing system according to claim 6, characterized in that: The rendering and printing module includes a replacement unit, Used to create a <img src=""” / "> The tag is used to carry the image content. Put the content field in the src attribute of the tag and replace the entire img tag with placeholder characters. When the content field is attachment data, create a <a src=""”"> Tag, put the content field address into the src attribute in the tag, and replace the placeholder with the entire a tag; When the content field is Boolean data, convert the data into the display format of √× and then replace the placeholder; When the content field contains alias data, the relationship between the alias and the display data is converted based on the mapping relationship between the alias and the display data, and the converted display data replaces the placeholder; When the content field is time data, the time data is converted into a preset time format; When the content field contains annotated data, the placeholder is replaced by the annotated content and the content field.

10. A non-volatile computer storage medium, characterized in that Computer instructions are stored thereon, and when the computer instructions are executed, the method for processing multiple printing templates of a customized form is implemented as described in any one of claims 1 to 5.

Images