Intelligent lens data management method and system, computer device and storage medium

Abstract

The application belongs to the technical field of computers and relates to an intelligent lens data management method, which comprises the following steps: obtaining the unique identification, the degree step unit and the degree range information of a lens to be managed; configuring a two-dimensional rectangular coordinate system with spherical power and cylindrical power as coordinate axes according to preset coordinate axis configuration information; generating a target visualized graph corresponding to the lens to be managed in the two-dimensional rectangular coordinate system according to the degree range information; determining effective degree information corresponding to the lens to be managed according to the degree step unit and the vertex coordinate set of the target visualized graph; and storing the target visualized graph and the effective degree information in association with each other according to the unique identification. The application also relates to an intelligent lens data management system, a computer device and a storage medium. The application defines the available degree combination range of a lens through a coordinate system and a visualized graph, thereby effectively improving the management efficiency of lens data.

Description

Technical Field

[0001] This application relates to the field of computer technology, and in particular to a smart lens data management method, system, computer device, and storage medium. Background Technology

[0002] In the production, sales, and management of lenses, each lens has a specific range of available power combinations. These power combinations typically involve parameters such as spherical power (SPH) and cylindrical power (CYL). Therefore, accurately and efficiently managing these power ranges is crucial for lens production planning, inventory management, order processing, and customer service.

[0003] Currently, the industry primarily relies on two traditional methods for managing lens prescription ranges: tabular recording and numerical range limitation. Tabular recording involves using Excel or ERP system spreadsheets to record the "SPH-CYL" prescription combination for each lens line by line, or storing separate lists of SPH and CYL values. Numerical range limitation only stores the "minimum-maximum" range for SPH and CYL, without considering their combined constraints. Neither of these traditional methods provides a clear visual representation of the prescription range, requiring managers to expend significant time and effort understanding and verifying settings when configuring or querying prescription ranges, resulting in low efficiency in lens data management.

[0004] In view of the above, this application is hereby submitted. Summary of the Invention

[0005] The purpose of this application is to provide an intelligent lens data management method, system, computer device, and storage medium to solve the technical problem of low management efficiency of lens data.

[0006] To address the aforementioned technical problems, this application provides a smart lens data management method, which employs the following technical solution:

[0007] A smart lens data management method includes the following steps:

[0008] Obtain the unique identifier, power increment unit, and power range information of the lens to be managed;

[0009] Based on the preset coordinate axis configuration information, a two-dimensional rectangular coordinate system is configured with spherical power and cylindrical power as the coordinate axes respectively;

[0010] Based on the diopter range information, a target visualization graphic corresponding to the lens to be managed is generated in the two-dimensional rectangular coordinate system;

[0011] Based on the diopter step unit and the vertex coordinate set of the target visualization graphic, determine the effective diopter information corresponding to the lens to be managed;

[0012] Based on the unique identifier, the target visualization graphic and the validity score information are associated and stored.

[0013] Furthermore, the step of determining the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic:

[0014] Based on the degree step unit, generate step unit grid lines in the two-dimensional rectangular coordinate system;

[0015] Based on the step unit grid line and the vertex coordinate set, determine the grid point information corresponding to the target visualization graphic;

[0016] The effective degree information is determined based on the grid point information.

[0017] Furthermore, the step of determining the effective degree information based on the grid point information specifically includes:

[0018] Based on the set of vertex coordinates, determine the boundary information of the target visualization graphic;

[0019] The grid point information is filtered based on the boundary information to obtain the coordinates of the target grid points located inside the target visualization graphic;

[0020] The effective degree information is generated based on the coordinates of the target grid points.

[0021] Furthermore, after the step of determining the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic, the method further includes:

[0022] Generate a visual image corresponding to the two-dimensional rectangular coordinate system and display it in a preset interface;

[0023] The target visualization graphic is entered into the visual image, and the step unit grid lines and the coordinates of the target grid points are labeled.

[0024] Furthermore, prior to the step of associating and storing the target visualization graphic and the validity degree information based on the unique identifier, the method further includes:

[0025] The validity degree information is verified to determine whether there is any abnormal data;

[0026] If the abnormal data is found, the preset administrator client will issue an early warning.

[0027] Furthermore, before the step of determining the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic, the method further includes:

[0028] A preset function is invoked to verify the set of vertex coordinates to determine whether the target visualization graphic is invalid;

[0029] If the target visualization graphic is invalid, the diopter range information of the lens to be managed is reacquired, and the process of generating the target visualization graphic corresponding to the lens to be managed in the two-dimensional rectangular coordinate system based on the diopter range information is returned.

[0030] Furthermore, after the step of associating and storing the target visualization graphic and the validity score information based on the unique identifier, the method further includes:

[0031] Based on the preset table configuration information, the initial table template is obtained;

[0032] Based on a preset automatic maintenance incremental sequence, the graphic identifier and spatial index corresponding to the target visualization graphic are generated in the initial table template to obtain the table to be filled.

[0033] The table to be filled is filled according to the power step unit, the vertex coordinate set and the effective power information to obtain the lens data table corresponding to the lens to be managed;

[0034] The lens data table is associated with and stored based on the unique identifier.

[0035] To address the aforementioned technical problems, this application also provides an intelligent lens data management system, which employs the following technical solution:

[0036] A smart lens data management system, comprising:

[0037] The acquisition module is used to acquire the unique identifier, power step unit, and power range information of the lens to be managed;

[0038] The configuration module is used to configure a two-dimensional rectangular coordinate system based on preset coordinate axis configuration information, using spherical power and cylindrical power as coordinate axes respectively;

[0039] The generation module is used to generate a target visualization graphic corresponding to the lens to be managed in the two-dimensional rectangular coordinate system based on the diopter range information.

[0040] The determination module is used to determine the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic;

[0041] The storage module is used to associate and store the target visualization graphic and the validity score information based on the unique identifier.

[0042] To address the aforementioned technical problems, this application also provides a computer device that employs the following technical solution:

[0043] A computer device includes a memory and a processor, wherein the memory stores computer-readable instructions, and the processor executes the computer-readable instructions to implement the steps of the smart lens data management method described above.

[0044] To address the aforementioned technical problems, this application also provides a computer-readable storage medium, employing the technical solution described below:

[0045] A computer-readable storage medium storing computer-readable instructions, which, when executed by a processor, implement the steps of the smart lens data management method described above.

[0046] Compared with the prior art, the embodiments of this application have the following main advantages:

[0047] The intelligent lens data management method disclosed in this application obtains the unique identifier, power step unit, and power range information of the lens to be managed; then, according to preset coordinate axis configuration information, a two-dimensional rectangular coordinate system is configured with spherical power and cylindrical power as coordinate axes respectively; subsequently, based on the power range information, a target visualization graphic corresponding to the lens to be managed is generated in the two-dimensional rectangular coordinate system; then, based on the power step unit and the vertex coordinate set of the target visualization graphic, the effective power information corresponding to the lens to be managed is determined; and finally, based on the unique identifier, the target visualization graphic and the effective power information are associated and stored. This application defines the range of available power combinations for lenses by constructing a visual coordinate system and graphic, which facilitates faster storage and enhances the visualization of lens data during subsequent retrieval, thereby greatly improving the management efficiency of lens data. Attached Figure Description

[0048] To more clearly illustrate the solutions in this application, the accompanying drawings used in the description of the embodiments of this application will be briefly introduced below. Obviously, the accompanying drawings described below are some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0049] Figure 1 This is an exemplary system architecture diagram to which this application can be applied;

[0050] Figure 2 This is a flowchart of an embodiment of the smart lens data management method according to this application;

[0051] Figure 3 This is a schematic diagram of a structure of an embodiment of the intelligent lens data management system according to this application;

[0052] Figure 4 This is a schematic diagram of the structure of one embodiment of the computer device according to this application. Detailed Implementation

[0053] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application pertains; the terminology used herein in the specification of the application is for the purpose of describing particular embodiments only and is not intended to be limiting of the application; the terms "comprising" and "having," and any variations thereof, in the specification, claims, and foregoing drawings of this application, are intended to cover non-exclusive inclusion. The terms "first," "second," etc., in the specification, claims, or foregoing drawings of this application are used to distinguish different objects, not to describe a particular order.

[0054] In this document, the term "embodiment" means that a particular feature, structure, or characteristic described in connection with an embodiment may be included in at least one embodiment of this application. The appearance of this phrase in various places throughout the specification does not necessarily refer to the same embodiment, nor is it a separate or alternative embodiment mutually exclusive with other embodiments. It will be explicitly and implicitly understood by those skilled in the art that the embodiments described herein can be combined with other embodiments.

[0055] To enable those skilled in the art to better understand the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings.

[0056] like Figure 1 As shown, system architecture 100 may include terminal devices 101, 102, and 103, a network 104, and a server 105. Network 104 serves as the medium for providing communication links between terminal devices 101, 102, and 103 and server 105. Network 104 may include various connection types, such as wired or wireless communication links, or fiber optic cables, etc.

[0057] Users can use terminal devices 101, 102, and 103 to interact with server 105 via network 104 to receive or send messages, etc. Various communication client applications can be installed on terminal devices 101, 102, and 103, such as web browser applications, shopping applications, search applications, instant messaging tools, email clients, social media platform software, etc.

[0058] Terminal devices 101, 102, and 103 can be various electronic devices with displays and web browsing capabilities, including but not limited to smartphones, tablets, e-book readers, MP3 (Moving Picture Experts Group Audio Layer III) players, MP4 (Moving Picture Experts Group Audio Layer IV) players, laptops, and desktop computers, etc.

[0059] Server 105 can be a server that provides various services, such as a backend server that supports the pages displayed on terminal devices 101, 102, and 103.

[0060] It should be noted that the intelligent lens data management method provided in this application embodiment is generally executed by a terminal device, and correspondingly, the intelligent lens data management system is generally set in the terminal device.

[0061] It should be understood that Figure 1 The number of terminal devices, networks, and servers shown is merely illustrative. Depending on implementation needs, any number of terminal devices, networks, and servers can be included.

[0062] Continue to refer to Figure 2 The diagram illustrates a flowchart of an embodiment of the smart lens data management method according to this application. The smart lens data management method includes the following steps:

[0063] Step S201: Obtain the unique identifier, power step unit, and power range information of the lens to be managed.

[0064] In this embodiment, the smart lens data management method runs on an electronic device (e.g., Figure 1 The terminal device shown can send or receive data via wired or wireless connection. It should be noted that the aforementioned wireless connection methods may include, but are not limited to, 3G / 4G / 5G connections, WiFi connections, Bluetooth connections, WiMAX connections, Zigbee connections, UWB (ultra wideband) connections, and other currently known or future known wireless connection methods.

[0065] Among them, lenses to be managed refer to any lens product that requires configuration and management of its power range, including but not limited to myopia lenses, hyperopia lenses, astigmatism lenses, etc.

[0066] A unique identifier is a code used to uniquely distinguish the lens. It is usually an industry-standard SKU (StockKeeping Unit), such as "XRE160-HARD-VG-001". It contains key attributes such as the lens's refractive index (1.60) and coating type (HARD-VG) to ensure that the lens can be accurately located in subsequent data management.

[0067] The power increment unit refers to the fixed interval between adjacent values ​​of lens power (spherical power, cylindrical power), and the unit is diopter (D). This embodiment supports two mainstream increment units in the industry: 0.25D (suitable for regular lenses, such as everyday lenses with a refractive index of 1.56 / 1.60) and 0.50D (suitable for customized lenses, such as thick lenses with a high refractive index of 1.67 or higher). For example, when the power increment unit is 0.25D, the spherical power values ​​are -6.00D, -5.75D, -5.50D, and so on.

[0068] The power range information refers to the valid range of spherical power (SPH) and cylindrical power (CYL) supported by the lens, as well as the constraints between the two. For example, the power range information of a lens can be described as: spherical power -6.00D to 10.00D, cylindrical power -4.00D to 0.00D, and when the spherical power is ≤ -6.00D, the cylindrical power must not exceed -4.00D.

[0069] Step S202: Based on the preset coordinate axis configuration information, configure a two-dimensional rectangular coordinate system with spherical power and cylindrical power as coordinate axes respectively.

[0070] The preset coordinate axis configuration information includes the pre-defined coordinate axis scale. Spherical power (SPH) refers to the lens power used to correct myopia or hyperopia (negative values ​​for myopia and positive values ​​for hyperopia), while cylindrical power (CYL) refers to the lens power used to correct astigmatism (usually negative values).

[0071] In one embodiment, the constructed two-dimensional rectangular coordinate system is specifically configured as follows: the spherical power (SPH) is used as the Y-axis, and the cylindrical power (CYL) is used as the X-axis. The two-dimensional rectangular coordinate system is configured according to the pre-set coordinate axis scale. The value range of the Y-axis covers -12.00D to 12.00D corresponding to the spherical power (SPH) in the industry's conventional requirements (it can be dynamically adjusted according to the lens type, such as custom lenses, which can be extended to -15.00D to 15.00D); the value range of the X-axis covers -6.00D to 6.00D corresponding to the cylindrical power (CYL) in the industry's conventional requirements (it also supports dynamic expansion).

[0072] It is important to note that the pre-set coordinate axis scales must follow the principle of matching step units. For example, if the power step unit is 0.25D, then each small division on the coordinate axis corresponds to 0.25D (e.g., on the Y-axis, one division is from -6.00D to -5.75D); if the step unit is 0.50D, then each small division corresponds to 0.50D. Specifically, for lenses with a 0.25D step, the Y-axis of the coordinate system from bottom to top is -12.00D, -11.75D, -11.50D, ..., 12.00D, and the X-axis from left to right is -6.00D, -5.75D, ..., 6.00D.

[0073] Step S203: Based on the diopter range information, generate a target visualization graphic corresponding to the lens to be managed in the two-dimensional rectangular coordinate system.

[0074] Step S203: Based on the degree range information, determine the closed polygon corresponding to the lens to be managed in the two-dimensional rectangular coordinate system, and obtain the vertex coordinate set of the closed polygon.

[0075] Among them, the target visualization graphic refers to the line segment or closed polygon used in a two-dimensional rectangular coordinate system to intuitively represent all valid "spherical power - cylindrical power" combination ranges of the lens, and its boundary is determined by the combination constraint relationship in the power range information.

[0076] In one embodiment, determining the target visualization graphic corresponding to the lens to be managed in a two-dimensional rectangular coordinate system can be achieved through two specific methods: manually entering vertex coordinates and plotting points in a graphical interface. When manually entering vertex coordinates, the administrator directly inputs the vertex coordinates of the target visualization graphic based on the diopter range information. For example, for lenses with a spherical power of -6.00D to 10.00D, a cylindrical power of -4.00D to 0.00D, and a cylindrical power of ≤-4.00D when the spherical power is ≤-6.00D, the set of vertex coordinates that can be entered is [(-4...]. [0.00,10.00),(0.00,10.00),(0.00,-6.00),(-4.00,-6.00),(-4.00,10.00)] (The first and last coordinates are consistent to ensure closure); When plotting points using a graphical interface, the position of the vertex is determined by clicking the mouse on the coordinate system canvas of the visualization interface. The system automatically records the coordinate values ​​and generates a set of vertex coordinates. For example, if you click on positions such as (-4.00,10.00) and (0.00,10.00) in sequence on the canvas, the system automatically recognizes the coordinates and organizes them into a set in order.

[0077] Step S204: Determine the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic.

[0078] The vertex coordinate set refers to the set of coordinate values ​​of each vertex of the target visualization graphic in the coordinate system. The format of each vertex coordinate is (cylindrical power, spherical power), i.e., (CYL, SPH), and they must be entered in clockwise or counterclockwise order to ensure the target visualization graphic is closed. Valid power information refers to the set of all "spherical power - cylindrical power" combinations within the target visualization graphic that conform to the power step unit; that is, the power combinations that the lens can actually produce or stock. For example, if the step unit is 0.25D, combinations such as (-3.00D, 6.00D) and (-2.75D, 6.00D) within the target graphic are all valid power information.

[0079] In one implementation, the core logic of determining valid degree information is as follows: generate all candidate degree points in the coordinate system based on degree step units, then filter out the points located inside the target visualization graphic, and form valid degree information based on the coordinate values ​​of these points.

[0080] Step S205: Based on the unique identifier, associate and store the target visualization graphic and the validity degree information.

[0081] In one implementation, the associated storage process involves binding the spatial data of the target visualization graphic (such as polygon data transformed from a set of vertex coordinates) and the effective power information (such as all combinations of effective powers) through the lens's unique identifier (SKU) and storing it in a pre-defined database (such as a MySQL database). The purpose is to achieve unified data management, facilitating subsequent queries (such as quickly matching the corresponding lens based on the prescription) and analysis (such as statistically analyzing the types of lenses within a certain power range).

[0082] This application defines the range of available lens power combinations by constructing a visual coordinate system and graphics, which facilitates faster storage and enhances the visualization of lens data during subsequent retrieval, thereby greatly improving the management efficiency of lens data.

[0083] In some optional implementations of this embodiment, the step of determining the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic includes:

[0084] Based on the degree step unit, generate step unit grid lines in the two-dimensional rectangular coordinate system;

[0085] Based on the step unit grid line and the vertex coordinate set, determine the grid point information corresponding to the target visualization graphic;

[0086] The effective degree information is determined based on the grid point information.

[0087] In this context, the step unit grid line refers to auxiliary lines drawn in degree increments within a two-dimensional Cartesian coordinate system, used to visually represent the intervals and distribution of degrees. For example, if the degree step unit is 0.25D, the grid lines are dashed lines parallel to the X and Y axes, with one vertical line drawn every 0.25D in the X direction and one horizontal line drawn every 0.25D in the Y direction; if the step unit is 0.50D, then one grid line is drawn every 0.50D. The grid point information corresponding to the target visualization graphic refers to the set of coordinates of all intersections of the step unit grid lines that correspond to the target visualization graphic. Generally, this includes intersections on the boundary of the target visualization graphic and intersections within it. The effective degree information refers to the degree combination corresponding to the grid points actually located inside the target visualization graphic.

[0088] In one implementation, the process of determining the grid point information corresponding to the target visualization graphic includes: the system automatically calculates all intersections of the step unit grid lines, then filters out the intersections located on the boundary of the target visualization graphic and the intersections inside (preliminarily filtering points beyond the graphic boundary), forming the grid point information corresponding to the target visualization graphic. The logic for determining the effective degree information includes: using spatial data algorithms (such as ray casting) to determine whether each grid point is inside the target visualization graphic, retaining the internal points and converting them into degree combinations. For example, if the grid point (-3.00D, 6.00D) is located inside the graphic, its corresponding "CYL=-3.00D, SPH=6.00D" belongs to the effective degree information.

[0089] Optionally, the grid lines are generated automatically by the system without manual intervention, and the color (such as light gray) and style (such as dashed lines) of the grid lines can be adjusted through preset parameters to avoid confusion with the target visualization graphics.

[0090] This application generates step unit grid lines in a two-dimensional rectangular coordinate system, which can quickly determine the grid points inside the visualization graphics corresponding to lens data and convert them into the available power combinations of the lenses, making lens data processing more efficient and thus greatly improving the management efficiency of lens data.

[0091] In some optional implementations of this embodiment, the step of determining the effective degree information based on the grid point information includes:

[0092] Based on the set of vertex coordinates, determine the boundary information of the target visualization graphic;

[0093] The grid point information is filtered based on the boundary information to obtain the coordinates of the target grid points located inside the target visualization graphic;

[0094] The effective degree information is generated based on the coordinates of the target grid points.

[0095] Boundary information refers to the edge range and shape features of the target visualization graphic, including extreme value information and edge segments. Extreme value information is the minimum / maximum value (min_x / max_x) of the graphic in the X-axis (CYL) direction and the minimum / maximum value (min_y / max_y) in the Y-axis (SPH) direction. Edge segments are all the line segments that constitute the boundary of the graphic (determined by the coordinates of adjacent vertices), such as the line segment formed by vertices (-3.00, 6.00) and (0.00, 6.00).

[0096] In one implementation, the process of filtering grid point information based on boundary information can be divided into two steps: The first step is range filtering, which excludes grid points whose CYL is not in [min_x, max_x] or whose SPH is not in [min_y, max_y] (quickly filtering points that are obviously outside the graphic). For example, grid points with CYL=-3.25D (less than min_x=-3.00) or SPH=7.00D (greater than max_y=6.00) are directly excluded. The second step is internal judgment. For the grid points after range filtering, the ray method (emitting rays from the point to the positive X-axis and counting the number of intersections with the edge of the graphic; if the number is odd, the point is inside) is used to determine whether they are inside the graphic. The internal points are retained as the target grid point coordinates. For example, the grid point (-2.50D, -7.00D) is determined to be inside the graphic and is retained as the target grid point coordinates. Finally, the coordinates of the target grid points located inside the target visualization graphic are converted into numerical pairs of "cylindrical power - spherical power" to obtain the effective power information. The effective power information is then stored in a list or table format for easy subsequent related queries.

[0097] This application obtains effective power information more accurately by directionally filtering grid point information in a two-dimensional rectangular coordinate system and converting it into a combination of available power for lenses, thereby making lens data processing more efficient and greatly improving the management efficiency of lens data.

[0098] In some optional implementations of this embodiment, after the step of determining the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic, the method further includes:

[0099] Generate a visual image corresponding to the two-dimensional rectangular coordinate system and display it in a preset interface;

[0100] The target visualization graphic is entered into the visual image, and the step unit grid lines and the coordinates of the target grid points are labeled.

[0101] Among them, a visual image refers to an image that presents a two-dimensional rectangular coordinate system graphically, including elements such as coordinate axes, scales, and grid lines. A default interface refers to the system's management backend interface (such as a web interface or client software interface), which can be viewed and operated by administrators.

[0102] For example, the size of the visual image is 1000×800 pixels, the background is white, the coordinate axes are black solid lines (2px wide), the scale text is black Song typeface, size 12, and the step unit grid lines are light gray dashed lines (1px wide). After generation, it can be displayed on the lens data management page in the management backend.

[0103] In one implementation, the target visualization graphic is entered through both automatic and manual input. Automatic input involves the system automatically drawing the generated target visualization graphic (e.g., a pentagon) onto the visualization image, with the graphic's edges outlined as solid blue lines (2px wide). Manual input allows administrators to drag and drop the vertices of the graphic within the visualization image to adjust its shape, with the system updating the vertex coordinate set of the target visualization graphic in real time. After the target visualization graphic is entered, step unit grid lines can be displayed in the visualization image, and target grid points can be marked with green dots, displaying their coordinates (e.g., "CYL=-3.00D, SPH=6.00D") when the mouse hovers over them.

[0104] This application uses visual images to display a two-dimensional rectangular coordinate system and a target visualization graphic, and clearly marks the effective power information. This allows managers to intuitively check the range of the target visualization graphic and the distribution of effective power points through visual images, ensuring the accuracy of lens data and greatly improving the management efficiency of lens data.

[0105] In some optional implementations of this embodiment, before the step of associating and storing the target visualization graphic and the validity degree information based on the unique identifier, the method further includes:

[0106] The validity degree information is verified to determine whether there is any abnormal data;

[0107] If the abnormal data is found, the preset administrator client will issue an early warning.

[0108] Abnormal data, which is equivalent to invalid data, refers to diopters that do not conform to the industry's standard diopter range or the physical characteristics of the lens, such as values ​​that may exceed the upper limit of the standard lens manufacturing process or the upper limit of the standard astigmatism correction requirement.

[0109] In one implementation, the system pre-sets rules for judging abnormal data and checks whether the degrees in the valid degree information conform to the rules. For example, it is pre-set that |SPH| must be less than or equal to 12.00. If |SPH| is greater than 12.00, it is abnormal data. At this time, the system issues a pre-set warning prompt, including but not limited to an interface pop-up window, such as a red warning box, displaying "Invalid degree detected: SPH=12.50D, outside the normal range", to remind the administrator to adjust the closed polygon range or correct the degree range information. At the same time, it is automatically written to the system log for subsequent traceability.

[0110] This application detects the effective power information in the target visualization graphic to determine whether there is abnormal data. If so, it issues an early warning to avoid errors and omissions, thereby making the management of lens data more accurate.

[0111] In some optional implementations of this embodiment, before the step of determining the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic, the method further includes:

[0112] A preset function is invoked to verify the set of vertex coordinates to determine whether the target visualization graphic is invalid;

[0113] If the target visualization graphic is invalid, the diopter range information of the lens to be managed is reacquired, and the process of generating the target visualization graphic corresponding to the lens to be managed in the two-dimensional rectangular coordinate system based on the diopter range information is returned.

[0114] The default function refers to MySQL's ST_IsValid(polygon), a spatial data validation function used to determine whether a target visualization is a valid graphic that is non-intersecting and closed at both ends. For example, if the vertex coordinates are out of order, causing polygon edges to intersect, ST_IsValid will return FALSE, meaning the target visualization is invalid.

[0115] In one implementation, when the target visualization graphic is determined to be invalid, the system can re-acquire the diopter range information of the lens to be managed and return to the step of generating the target visualization graphic corresponding to the lens to be managed in a two-dimensional Cartesian coordinate system based on the diopter range information. For example, the administrator can re-enter or modify the vertex coordinate set according to the system prompts until ST_IsValid returns TRUE, indicating that the target visualization graphic is valid, thus completing the supplementary entry.

[0116] This application uses MySQL's spatial data verification function to verify the vertex coordinates of the target visualization graphic in a two-dimensional rectangular coordinate system to determine its validity. If invalid, the data is supplemented, thereby ensuring the accuracy of the data table and making the management of lens data more accurate.

[0117] In some optional implementations of this embodiment, after the step of associating and storing the target visualization graphic and the validity degree information based on the unique identifier, the method further includes:

[0118] Based on the preset table configuration information, the initial table template is obtained;

[0119] Based on a preset automatic maintenance incremental sequence, the graphic identifier and spatial index corresponding to the target visualization graphic are generated in the initial table template to obtain the table to be filled.

[0120] The table to be filled is filled according to the power step unit, the vertex coordinate set and the effective power information to obtain the lens data table corresponding to the lens to be managed;

[0121] The lens data table is associated with and stored based on the unique identifier.

[0122] The lens data table is a structured table used to store data related to lens prescription ranges. Its design must meet the requirements of fast querying and correlation analysis. The default lens database uses a MySQL database (supporting spatial data types and indexes) to ensure data storage stability and query efficiency.

[0123] The preset table configuration information refers to predefined table structure rules, including field names, data types, constraints, etc., used to standardize the format of data tables. The preset automatic maintenance incrementing sequence refers to the AUTO_INCREMENT attribute in the MySQL database, which automatically generates unique and incrementing values ​​for specified fields (initially 1, incrementing by 1 each time). Examples of preset table configuration information include the following fields: polygon_id (target visualization graphic identifier), product_sku_id (unique lens identifier, associated with product information), min_unit (power increment unit), polygon (spatial data of the target visualization graphic, type MySQL Geometry), point_id (effective power point identifier), cyl (cylindrical power), sph (spherical power), and point_geom (spatial data of effective power points, type MySQL Point).

[0124] In one implementation, based on the above configuration information, the system can automatically generate an initial table template, i.e., an empty table structure containing no data but with defined field types and constraints, as the table to be filled. Then, the table is filled using a unique identifier, diopter step unit, and vertex coordinate set, allowing the above content to be written to the corresponding positions in the table. The vertex coordinate set is converted to a spatial data format supported by MySQL and written to the polygon field. The system then automatically generates a polygon_id using AUTO_INCREMENT, and after filling, the final lens data table is obtained.

[0125] This application generates and stores lens data tables by using a visual representation of the target based on the lens data in a coordinate system, thereby enabling lens data management, increasing the visualization of lens data, and improving the management efficiency of lens data.

[0126] The embodiments of this application can acquire and process relevant data based on artificial intelligence technology. Artificial intelligence (AI) refers to the theories, methods, technologies, and application systems that use digital computers or machines controlled by digital computers to simulate, extend, and expand human intelligence, perceive the environment, acquire knowledge, and use that knowledge to obtain optimal results.

[0127] Foundational technologies for artificial intelligence generally include sensors, dedicated AI chips, cloud computing, distributed storage, big data processing, operating / interactive systems, and mechatronics. AI software technologies mainly encompass computer vision, robotics, biometrics, speech processing, natural language processing, and machine learning / deep learning.

[0128] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by instructing related hardware through computer-readable instructions. These computer-readable instructions can be stored in a computer-readable storage medium. When the program is executed, it can include the processes of the embodiments of the above methods. The aforementioned storage medium can be a non-volatile storage medium such as a magnetic disk, optical disk, or read-only memory (ROM), or random access memory (RAM).

[0129] It should be understood that although the steps in the flowcharts of the accompanying figures are shown sequentially as indicated by the arrows, these steps are not necessarily executed in the order indicated by the arrows. Unless explicitly stated herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least some steps in the flowcharts of the accompanying figures may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily completed at the same time, but can be executed at different times, and their execution order is not necessarily sequential, but can be performed alternately or in turn with other steps or at least some of the sub-steps or stages of other steps.

[0130] Further reference Figure 3 As a response to the above Figure 2 The implementation of the method shown in this application provides an embodiment of an intelligent lens data management system, which is similar to... Figure 2 Corresponding to the method embodiments shown, the system can be specifically applied to various electronic devices.

[0131] like Figure 3As shown, the intelligent lens data management system 300 described in this embodiment includes: an acquisition module 301, a configuration module 302, a generation module 303, a determination module 304, and a storage module 305. Wherein:

[0132] The acquisition module 301 is used to acquire the unique identifier, power step unit, and power range information of the lens to be managed.

[0133] The configuration module 302 is used to configure a two-dimensional rectangular coordinate system with spherical power and cylindrical power as coordinate axes according to the preset coordinate axis configuration information.

[0134] The generation module 303 is used to generate a target visualization graphic corresponding to the lens to be managed in the two-dimensional rectangular coordinate system based on the diopter range information.

[0135] The determination module 304 is used to determine the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic;

[0136] The storage module 305 is used to associate and store the target visualization graphic and the validity score information based on the unique identifier.

[0137] The intelligent lens data management system provided in this application defines the range of available lens power combinations by constructing a visual coordinate system and graphics, which facilitates faster storage and enhances the visualization of lens data during subsequent retrieval, thereby greatly improving the management efficiency of lens data.

[0138] In some optional implementations of this embodiment, the determining module 304 is further configured to:

[0139] Based on the degree step unit, generate step unit grid lines in the two-dimensional rectangular coordinate system;

[0140] Based on the step unit grid line and the vertex coordinate set, determine the grid point information corresponding to the target visualization graphic;

[0141] The effective degree information is determined based on the grid point information.

[0142] The intelligent lens data management system provided in this application can quickly determine the grid points inside the visualization graphics corresponding to the lens data by generating step unit grid lines in a two-dimensional rectangular coordinate system, and convert them into the available power combinations of the lens, making the lens data processing more efficient and thus greatly improving the management efficiency of lens data.

[0143] In some optional implementations of this embodiment, the determining module 304 is further configured to:

[0144] Based on the set of vertex coordinates, determine the boundary information of the target visualization graphic;

[0145] The grid point information is filtered based on the boundary information to obtain the coordinates of the target grid points located inside the target visualization graphic;

[0146] The effective degree information is generated based on the coordinates of the target grid points.

[0147] The intelligent lens data management system provided in this application obtains effective power information more accurately by directionally filtering grid point information in a two-dimensional rectangular coordinate system and converting it into a combination of usable power for the lens, thereby making lens data processing more efficient and greatly improving the management efficiency of lens data.

[0148] In some optional implementations of this embodiment, the intelligent lens data management system 300 is further used for:

[0149] Generate a visual image corresponding to the two-dimensional rectangular coordinate system and display it in a preset interface;

[0150] The target visualization graphic is entered into the visual image, and the step unit grid lines and the coordinates of the target grid points are labeled.

[0151] The intelligent lens data management system provided in this application displays a two-dimensional rectangular coordinate system and a target visualization graphic through visual images, and clearly marks the effective power information. This allows managers to intuitively check the range of the target visualization graphic and the distribution of effective power points through visual images, ensuring the accuracy of lens data and greatly improving the management efficiency of lens data.

[0152] In some optional implementations of this embodiment, the intelligent lens data management system 300 is further used for:

[0153] The validity degree information is verified to determine whether there is any abnormal data;

[0154] If the abnormal data is found, the preset administrator client will issue an early warning.

[0155] The intelligent lens data management system provided in this application detects the effective power information in the target visualization graphic to determine whether there is abnormal data. If so, it issues an early warning to avoid errors and omissions, thereby making the management of lens data more accurate.

[0156] In some optional implementations of this embodiment, the intelligent lens data management system 300 is further used for:

[0157] A preset function is invoked to verify the set of vertex coordinates to determine whether the target visualization graphic is invalid;

[0158] If the target visualization graphic is invalid, the diopter range information of the lens to be managed is reacquired, and the process of generating the target visualization graphic corresponding to the lens to be managed in the two-dimensional rectangular coordinate system based on the diopter range information is returned.

[0159] The intelligent lens data management system provided in this application uses MySQL's spatial data verification function to verify the vertex coordinates of the target visualization graphic in a two-dimensional rectangular coordinate system to determine its validity. If invalid, the data is supplemented, thereby ensuring the accuracy of the data table and making the management of lens data more accurate.

[0160] In some optional implementations of this embodiment, the intelligent lens data management system 300 is further used for:

[0161] Based on the preset table configuration information, the initial table template is obtained;

[0162] Based on a preset automatic maintenance incremental sequence, the graphic identifier and spatial index corresponding to the target visualization graphic are generated in the initial table template to obtain the table to be filled.

[0163] The table to be filled is filled according to the power step unit, the vertex coordinate set and the effective power information to obtain the lens data table corresponding to the lens to be managed;

[0164] The lens data table is associated with and stored based on the unique identifier.

[0165] The intelligent lens data management system provided in this application generates and stores lens data tables by using the target visualization graphics corresponding to lens data in a coordinate system, thereby realizing the management of lens data, increasing the visualization of lens data, and improving the management efficiency of lens data.

[0166] To address the aforementioned technical problems, embodiments of this application also provide a computer device. Please refer to [link / reference needed]. Figure 4 , Figure 4 This is a basic structural block diagram of the computer device in this embodiment.

[0167] The computer device 4 includes a memory 41, a processor 42, and a network interface 43 that are interconnected via a system bus. It should be noted that only the computer device 4 with components 41-43 is shown in the figure; however, it should be understood that it is not required to implement all the shown components, and more or fewer components can be implemented alternatively. Those skilled in the art will understand that the computer device described here is a device capable of automatically performing numerical calculations and / or information processing according to pre-set or stored instructions, and its hardware includes, but is not limited to, microprocessors, application-specific integrated circuits (ASICs), field-programmable gate arrays (FPGAs), digital signal processors (DSPs), embedded devices, etc.

[0168] The computer device can be a desktop computer, laptop, handheld computer, or cloud server, etc. The computer device can interact with the user via a keyboard, mouse, remote control, touchpad, or voice control.

[0169] The memory 41 includes at least one type of readable storage medium, including flash memory, hard disk, multimedia card, card-type memory (e.g., SD or DX memory), random access memory (RAM), static random access memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic memory, magnetic disk, optical disk, etc. In some embodiments, the memory 41 may be an internal storage unit of the computer device 4, such as the hard disk or memory of the computer device 4. In other embodiments, the memory 41 may also be an external storage device of the computer device 4, such as a plug-in hard disk, smart media card (SMC), secure digital (SD) card, flash card, etc., equipped on the computer device 4. Of course, the memory 41 may include both the internal storage unit and its external storage device of the computer device 4. In this embodiment, the memory 41 is typically used to store the operating system and various application software installed on the computer device 4, such as computer-readable instructions for intelligent lens data management methods. In addition, the memory 41 can also be used to temporarily store various types of data that have been output or will be output.

[0170] In some embodiments, the processor 42 may be a central processing unit (CPU), a controller, a microcontroller, a microprocessor, or other data processing chip. The processor 42 is typically used to control the overall operation of the computer device 4. In this embodiment, the processor 42 is used to execute computer-readable instructions stored in the memory 41 or to process data, for example, to execute computer-readable instructions for the smart lens data management method.

[0171] The network interface 43 may include a wireless network interface or a wired network interface, which is typically used to establish communication connections between the computer device 4 and other electronic devices.

[0172] The computer equipment provided in this application defines the range of available lens power combinations by constructing a visual coordinate system and graphics, which facilitates faster storage and enhances the visualization of lens data during subsequent retrieval, thereby greatly improving the management efficiency of lens data.

[0173] This application also provides another embodiment, namely, providing a computer-readable storage medium storing computer-readable instructions that can be executed by at least one processor to cause the at least one processor to perform the steps of the smart lens data management method described above.

[0174] The computer-readable storage medium provided in this application defines the range of available lens power combinations by constructing a visual coordinate system and graphics, which facilitates faster storage and enhances the visualization of lens data during subsequent retrieval, thereby greatly improving the management efficiency of lens data.

[0175] Through the above description of the embodiments, those skilled in the art can clearly understand that the methods of the above embodiments can be implemented by means of software plus necessary general-purpose hardware platforms. Of course, they can also be implemented by hardware, but in many cases the former is a better implementation method. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, can be embodied in the form of a software product. This computer software product is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk) and includes several instructions to cause a terminal device (which may be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the methods described in the various embodiments of this application.

[0176] Obviously, the embodiments described above are only some embodiments of this application, not all embodiments. The accompanying drawings show preferred embodiments of this application, but do not limit the patent scope of this application. This application can be implemented in many different forms; rather, the purpose of providing these embodiments is to provide a more thorough and comprehensive understanding of the disclosure of this application. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art can still modify the technical solutions described in the foregoing specific embodiments, or make equivalent substitutions for some of the technical features. Any equivalent structures made using the content of this application's specification and drawings, directly or indirectly applied to other related technical fields, are similarly within the scope of patent protection of this application.

Claims

1. A smart lens data management method, characterized in that, Includes the following steps: Obtain the unique identifier, power step unit, and power range information of the lens to be managed. The power range information is the valid range of spherical and cylindrical power values ​​supported by the lens to be managed, as well as the combination constraint relationship between the spherical and cylindrical power values. Based on the preset coordinate axis configuration information, a two-dimensional rectangular coordinate system is configured with spherical power and cylindrical power as the coordinate axes respectively; Based on the diopter range information, a target visualization graphic corresponding to the lens to be managed is generated in the two-dimensional rectangular coordinate system; Based on the power step unit and the vertex coordinate set of the target visualization graphic, the effective power information corresponding to the lens to be managed is determined. The effective power information is the set of all spherical and cylindrical power combinations that conform to the power step unit within the target visualization graphic. Based on the unique identifier, the target visualization graphic and the validity score information are associated and stored. The step of determining the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic specifically includes: Based on the degree step unit, generate step unit grid lines in the two-dimensional rectangular coordinate system; Based on the step unit grid line and the vertex coordinate set, determine the grid point information corresponding to the target visualization graphic; The effective degree information is determined based on the grid point information.

2. The intelligent lens data management method according to claim 1, characterized in that, The step of determining the effective degree information based on the grid point information specifically includes: Based on the set of vertex coordinates, determine the boundary information of the target visualization graphic; The grid point information is filtered based on the boundary information to obtain the coordinates of the target grid points located inside the target visualization graphic; The effective degree information is generated based on the coordinates of the target grid points.

3. The intelligent lens data management method according to claim 2, characterized in that, After the step of determining the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic, the method further includes: Generate a visual image corresponding to the two-dimensional rectangular coordinate system and display it in a preset interface; The target visualization graphic is entered into the visual image, and the step unit grid lines and the coordinates of the target grid points are labeled.

4. The intelligent lens data management method according to claim 1, characterized in that, Before the step of associating and storing the target visualization graphic and the validity score information based on the unique identifier, the method further includes: The validity degree information is verified to determine whether there is any abnormal data; If the abnormal data is found, the preset administrator client will issue an early warning.

5. The intelligent lens data management method according to claim 1, characterized in that, Before the step of determining the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic, the method further includes: A preset function is invoked to verify the set of vertex coordinates to determine whether the target visualization graphic is invalid; If the target visualization graphic is invalid, the diopter range information of the lens to be managed is reacquired, and the process of generating the target visualization graphic corresponding to the lens to be managed in the two-dimensional rectangular coordinate system based on the diopter range information is returned.

6. The intelligent lens data management method according to any one of claims 1 to 5, characterized in that, After the step of associating and storing the target visualization graphic and the validity score information based on the unique identifier, the method further includes: Based on the preset table configuration information, the initial table template is obtained; Based on a preset automatic maintenance incremental sequence, the graphic identifier and spatial index corresponding to the target visualization graphic are generated in the initial table template to obtain the table to be filled. The table to be filled is filled according to the power step unit, the vertex coordinate set and the effective power information to obtain the lens data table corresponding to the lens to be managed; The lens data table is associated with and stored based on the unique identifier.

7. An intelligent lens data management system, characterized in that, include: The acquisition module is used to acquire the unique identifier, power step unit, and power range information of the lens to be managed. The power range information is the valid range of spherical and cylindrical power supported by the lens to be managed, as well as the combination constraint relationship of the spherical and cylindrical power. The configuration module is used to configure a two-dimensional rectangular coordinate system based on preset coordinate axis configuration information, using spherical power and cylindrical power as coordinate axes respectively; The generation module is used to generate a target visualization graphic corresponding to the lens to be managed in the two-dimensional rectangular coordinate system based on the diopter range information. The determination module is used to determine the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic. The effective power information is the set of all spherical and cylindrical power combinations that conform to the power step unit within the target visualization graphic. The storage module is used to associate and store the target visualization graphic and the validity score information based on the unique identifier; The step of determining the effective power information corresponding to the lens to be managed based on the power step unit and the vertex coordinate set of the target visualization graphic specifically includes: Based on the degree step unit, generate step unit grid lines in the two-dimensional rectangular coordinate system; Based on the step unit grid line and the vertex coordinate set, determine the grid point information corresponding to the target visualization graphic; The effective degree information is determined based on the grid point information.

8. A computer device, characterized in that, The system includes a memory and a processor, wherein the memory stores computer-readable instructions, and the processor executes the computer-readable instructions to implement the steps of the smart lens data management method as described in any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-readable instructions, which, when executed by a processor, implement the steps of the smart lens data management method as described in any one of claims 1 to 6.

Images