School roll photo inspection method, system, equipment and medium

Abstract

The invention discloses a school roll photo inspection method, system and device and a medium, belongs to the technical field of image processing, and aims to solve the technical problem of how to correct or eliminate school roll photos which do not meet requirements and ensure the accuracy of school roll system data. Determining an inspection school roll photo data range, limiting a data range of an acquisition set according to user requirements or other requirements, and putting the acquired data into a List set; the student roll photos of each student are analyzed through a for cycle, and photo attributes are obtained through ImageIO and stored in a data table; wherein the school roll photo attributes comprise pixel width, pixel height, pixel size, updating time and whether abnormity exists or not; and analyzing the attribute of each school roll photo according to a self-defined specification or related requirements, and respectively recording the number of school roll photo pixel nonstandard people, the number of school roll photo size nonstandard people, the number of school roll photo updating time nonstandard people and the number of school roll photo abnormal people.

Description

Technical Field

[0001] The present invention relates to the field of image processing technology, and in particular to a method, system, equipment and medium for inspecting student photos. Background Art

[0002] In the field of student academic record management, academic photos are important basic information of students, which are related to the printing of student academic record certificates, student ID cards, graduation certificates, academic performance certificates and examination registration. Accurate student academic data is the basis of student academic record management, so it is particularly important to ensure that the photos are standardized.

[0003] The standardization of photos particularly affects various scenarios that require face recognition functions. According to custom requirements, the photo size must not exceed 2M, the pixel requirement is that the photo width must not be less than 480, and the height must not be less than 640. If there are any abnormalities, the photos that meet the conditions are pushed to the dedicated service disk of the intermediate environment.

[0004] The main reasons for producing student photos that do not meet the requirements are: students continue to use photos maintained long ago, resulting in the time not meeting the requirements; due to network abnormalities or other environmental factors, after the photo data is transmitted, only the database photo records are lost and the disk data is lost, and it is counted as an abnormal photo; the photo data obtained from a third party through early data docking may have irregular size or pixels.

[0005] Therefore, how to correct or eliminate student photos that do not meet the requirements and ensure the accuracy of student registration system data is a technical problem that needs to be solved urgently. Summary of the invention

[0006] The technical task of the present invention is to provide a student photo inspection method, system, equipment and medium to solve the problem of how to correct or eliminate student photos that do not meet the requirements and ensure the accuracy of student system data.

[0007] The technical task of the present invention is achieved in the following way: a method for inspecting student photos, which is specifically as follows:

[0008] Summarize the student photo data through SQL query, determine the inspection student photo data range, and limit the data range of the collection according to user requirements or other requirements, and put the obtained data into the List collection;

[0009] The school photo of each student is parsed through a for loop, and the photo attributes are obtained through ImageIO and stored in the data table; the attributes of the school photo include pixel width and height, size, update time, and whether there is an abnormality;

[0010] Analyze the attributes of each student photo according to custom specifications or relevant requirements, and record the number of students with irregular student photo pixels, irregular student photo sizes, irregular student photo update times, and abnormal student photo numbers;

[0011] According to the areas where the inspected students are located, statistics are collected according to the first-level range, second-level range, third-level range and school range, and query list data and abnormal data table exports are provided, that is, list data and abnormal export are reflected, offline confirmation is supported, and the adjustment is supervised;

[0012] According to the records in the list data and the abnormal data table, photos that do not meet the pixel specifications, size specifications, time specifications or data anomalies are filtered out through SQL, and photos that meet the conditions are pushed to the target server through file streams.

[0013] Preferably, when determining the data range of the student photo for inspection, the data range is limited for full inspection according to user requirements or other needs, and the data range for inspection is obtained periodically according to timestamp increments at a later time.

[0014] As a preferred method, the student photo of each student is parsed through a for loop, and the photo attributes are obtained through ImageIO and stored in the data table as follows:

[0015] Get each student's photo stream;

[0016] Analyze the photo pixels, size, update time, and whether there are other anomalies; other anomalies include no photo data and parsing error data;

[0017] Store all photos of all students.

[0018] Preferably, the method processes the student photo in the following manner:

[0019] Set up scheduled tasks, obtain incremental data on changes in student photo data based on the timestamp of successful scheduled task processing, and perform statistical analysis on a regular basis. It also provides statistical analysis of student photo attributes at different levels of schools, and provides data export function for offline confirmation. School administrators maintain new student photo data through abnormal data lists.

[0020] A student photo inspection system, the system comprising:

[0021] The aggregation module is used to aggregate the student photo data through SQL query, determine the scope of the student photo data to be inspected, and limit the data range of the acquired collection according to user requirements or other requirements, and put the acquired data into the List collection;

[0022] The photo parsing module is used to parse the school photo of each student through a for loop, obtain the photo attributes through ImageIO and store them in the data table; the attributes of the school photo include pixel width and height, size, update time, and whether there is an abnormality;

[0023] The attribute parsing module is used to parse the attributes of each student photo according to custom specifications or relevant requirements, and record the number of students with irregular student photo pixels, irregular student photo sizes, irregular student photo update times, and abnormal student photo numbers;

[0024] The statistics module is used to divide the inspected students according to their regions, and to collect statistics by primary, secondary, tertiary and school scopes, and to provide query list data and abnormal data table exports, that is, to reflect list data and provide abnormal exports, and to support offline confirmation to urge adjustments;

[0025] The push module is used to filter out photos that do not meet pixel specifications, size specifications, time specifications or data anomalies through SQL according to the records in the list data and abnormal data table, and push the qualified photos to the target server through the file stream.

[0026] Preferably, when determining the data range of the student photo for inspection, the data range is limited for full inspection according to user requirements or other needs, and the data range for inspection is obtained periodically according to timestamp increments at a later time.

[0027] Preferably, the working process of the photo parsing module is as follows:

[0028] ①Get each student's photo stream;

[0029] ②Analyze the photo pixels, size, update time, and whether there are other anomalies; other anomalies include no photo data and parsing error data;

[0030] ③Store all photos of all students.

[0031] Preferably, the system also includes a setting module, which is used to set scheduled tasks, obtain incremental data of changes in student photo data based on the timestamp of successful processing of the recorded scheduled tasks, perform statistical analysis regularly, and provide statistical analysis of student photo attributes at different levels of schools. It also provides a data export function to achieve offline confirmation, and school administrators maintain new student photo data through a list of abnormal data.

[0032] An electronic device comprising: a memory and at least one processor;

[0033] Wherein, the memory stores a computer program;

[0034] The at least one processor executes the computer program stored in the memory, so that the at least one processor performs the student photo inspection method as described above.

[0035] A computer-readable storage medium having a computer program stored therein, wherein the computer program can be executed by a processor to implement the student photo inspection method as described above.

[0036] The student photo inspection method, system, device and medium of the present invention have the following advantages:

[0037] (1) The present invention is aimed at all personnel information that have uploaded photos, and customizes the photo specification range according to relevant specifications, such as requiring the size to be no more than 2 megabytes, the width to be no less than 480, and the height to be no less than 640. The photo entry time must not be earlier than September 1st of each year. Check whether the photos are damaged or lost, correct or eliminate the problem of non-standard student photos, and provide data support for the follow-up work of the student registration system and other examination registration systems in need;

[0038] (ii) The present invention can provide a fast and standardized method for collecting and correcting student student photo data for various student student status business systems, thereby ensuring the accuracy of system data and ensuring that subsequent photo-related work proceeds normally;

[0039] (III) The present invention clearly integrates a statistical analysis interface according to different levels and types, showing the number of people with normal and various abnormal photos and personal photo details within the province, city, county and school scope, and provides a data export function to facilitate users to confirm offline and supervise the rectification of photos. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] The present invention is further described below in conjunction with the accompanying drawings.

[0041] Attached Figure 1 This is a flowchart of the student photo inspection method. DETAILED DESCRIPTION

[0042] The student photo inspection method, system, equipment and medium of the present invention are described in detail below with reference to the accompanying drawings and specific embodiments of the specification.

[0043] Embodiment 1:

[0044] As attached Figure 1 As shown, this embodiment provides a method for inspecting student photos, and the method is specifically as follows:

[0045] S1. Summarize the student photo data through SQL query, determine the inspection student photo data range, and limit the data range of the acquired set according to user requirements or other requirements, and put the acquired data into the List collection;

[0046] S2. Parse the school photo of each student through a for loop, obtain the photo attributes through ImageIO and store them in the data table; the attributes of the school photo include pixel width and height, size, update time, and whether there is an abnormality;

[0047] S3. Analyze the attributes of each student photo according to custom specifications or relevant requirements, and record the number of students with irregular student photo pixels, irregular student photo sizes, irregular student photo update times, and abnormal student photo numbers;

[0048] S4. According to the areas where the inspected students are located, statistics are collected according to the first-level range, second-level range, third-level range and school range, and query list data and abnormal data table export are provided, that is, list data and abnormal data export are reflected, offline confirmation is supported, and the adjustment is supervised;

[0049] S5. According to the records in the list data and the abnormal data table, photos that do not meet the pixel specification, size specification, time specification or data abnormality are filtered out through SQL, and the photos that meet the conditions are pushed to the target server through the file stream.

[0050] When determining the inspection student photo data range in step S1 of this embodiment, the data range is limited for full inspection according to user requirements or other needs, and the inspection student photo data range is obtained periodically according to timestamp increments at a later time.

[0051] In step S2 of this embodiment, the school photo of each student is parsed through a for loop, and the photo attributes are obtained through ImageIO and stored in the data table as follows:

[0052] S201, obtaining the photo stream of each student;

[0053] S202, analyzing the photo pixels, size, update time, and whether there are other anomalies; wherein other anomalies include no photo data and parsing error data;

[0054] S203. Store all photos of all students.

[0055] In this embodiment, the method processes the student photo in the following manner:

[0056] Set up scheduled tasks, obtain incremental data on changes in student photo data based on the timestamp of successful scheduled task processing, and perform statistical analysis on a regular basis. It also provides statistical analysis of student photo attributes at different levels of schools, and provides data export function for offline confirmation. School administrators maintain new student photo data through abnormal data lists.

[0057] Embodiment 2:

[0058] This embodiment provides a student photo inspection system, which includes:

[0059] The aggregation module is used to aggregate the student photo data through SQL query, determine the scope of the student photo data to be inspected, and limit the data range of the acquired collection according to user requirements or other requirements, and put the acquired data into the List collection;

[0060] The photo parsing module is used to parse the school photo of each student through a for loop, obtain the photo attributes through ImageIO and store them in the data table; the attributes of the school photo include pixel width and height, size, update time, and whether there is an abnormality;

[0061] The attribute parsing module is used to parse the attributes of each student photo according to custom specifications or relevant requirements, and record the number of students with irregular student photo pixels, irregular student photo sizes, irregular student photo update times, and abnormal student photo numbers;

[0062] The statistics module is used to divide the inspected students according to their regions, and to collect statistics by primary, secondary, tertiary and school scopes, and to provide query list data and abnormal data table exports, that is, to reflect list data and provide abnormal exports, and to support offline confirmation to urge adjustments;

[0063] The push module is used to filter out photos that do not meet pixel specifications, size specifications, time specifications or data anomalies through SQL according to the records in the list data and abnormal data table, and push the qualified photos to the target server through the file stream.

[0064] In this embodiment, when determining the data range of the student photo for inspection, the data range is limited for full inspection according to user requirements or other needs, and the data range of the student photo for inspection is obtained periodically according to the timestamp increment at a later time.

[0065] The working process of the photo parsing module in this embodiment is as follows:

[0066] ①Get each student's photo stream;

[0067] ②Analyze the photo pixels, size, update time, and whether there are other anomalies; other anomalies include no photo data and parsing error data;

[0068] ③Store all photos of all students.

[0069] In this embodiment, the system also includes a setting module, which is used to set scheduled tasks, obtain incremental data of changes in student photo data based on the timestamp of successful processing of the recorded scheduled tasks, perform statistical analysis regularly, and provide statistical analysis of student photo attributes at different levels of schools. At the same time, it provides a data export function to achieve offline confirmation, and school administrators maintain new student photo data through an abnormal data list.

[0070] Embodiment 3:

[0071] This embodiment also provides an electronic device, including: a memory and at least one processor;

[0072] Wherein, the memory stores computer-executable instructions;

[0073] The at least one processor executes the computer-executable instructions stored in the memory, so that the at least one processor executes the student photo inspection method in any embodiment of the present invention.

[0074] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The processor may be a microprocessor or any conventional processor, etc.

[0075] The memory can be used to store computer programs and / or modules. The processor realizes various functions of the electronic device by running or executing the computer programs and / or modules stored in the memory, and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application required for a function, etc.; the data storage area can store data created according to the use of the terminal, etc. In addition, the memory can also include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (SMC), a secure digital (SD) card, a flash memory card, at least one disk storage period, a flash memory device, or other volatile solid-state storage devices.

[0076] Embodiment 4:

[0077] This embodiment also provides a computer-readable storage medium, in which a plurality of instructions are stored, and the instructions are loaded by a processor, so that the processor executes the student photo inspection method in any embodiment of the present invention. Specifically, a system or device equipped with a storage medium can be provided, on which a software program code that implements the functions of any of the above embodiments is stored, and a computer (or CPU or MPU) of the system or device reads and executes the program code stored in the storage medium.

[0078] In this case, the program code itself read from the storage medium can realize the function of any one of the above-mentioned embodiments, and thus the program code and the storage medium storing the program code constitute a part of the present invention.

[0079] The storage medium embodiments for providing the program code include a floppy disk, a hard disk, a magneto-optical disk, an optical disk (such as CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RYM, DVD-RW, DVD+RW), a magnetic tape, a non-volatile memory card, and a ROM. Alternatively, the program code can be downloaded from a server computer via a communication network.

[0080] In addition, it should be clear that the functions of any of the above embodiments can be implemented not only by executing the program code read by the computer, but also by enabling an operating system operating on the computer to complete part or all of the actual operations based on instructions from the program code.

[0081] In addition, it can be understood that the program code read from the storage medium is written to a memory provided in an expansion board inserted into the computer or written to a memory provided in an expansion unit connected to the computer, and then based on the instructions of the program code, a CPU installed on the expansion board or the expansion unit is enabled to perform part or all of the actual operations, thereby realizing the functions of any of the above-mentioned embodiments.

[0082] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for inspecting student photos, characterized in that: The method is as follows: Summarize the student photo data through SQL query, determine the inspection student photo data range, and limit the data range of the collection according to user requirements or other requirements, and put the obtained data into the List collection; The school photo of each student is parsed through a for loop, and the photo attributes are obtained through ImageIO and stored in the data table; the attributes of the school photo include pixel width and height, size, update time, and whether there is an abnormality; Analyze the attributes of each student photo according to custom specifications or relevant requirements, and record the number of students with irregular student photo pixels, irregular student photo sizes, irregular student photo update times, and abnormal student photo numbers; Divide the inspected students into groups according to their regions, collect statistics by primary, secondary, tertiary and school scopes, and provide query list data and abnormal data table exports; According to the records in the list data and the abnormal data table, photos that do not meet the pixel specifications, size specifications, time specifications or data anomalies are filtered out through SQL, and photos that meet the conditions are pushed to the target server through file streams.

2. The student photo inspection method according to claim 1, characterized in that: When determining the data scope of the student photo inspection, limit the data scope for full inspection according to user requirements or other needs, and later obtain the data scope of the student photo inspection regularly according to the timestamp increment.

3. The student photo inspection method according to claim 1, characterized in that: The for loop is used to parse the student's academic photo, and the photo attributes are obtained through ImageIO and stored in the data table as follows: Get each student's photo stream; Analyze the photo pixels, size, update time, and whether there are other anomalies; other anomalies include no photo data and parsing error data; Store all photos of all students.

4. The student photo inspection method according to any one of claims 1 to 3, characterized in that: The method processes the student photo as follows: Set up scheduled tasks, obtain incremental data on changes in student photo data based on the timestamp of successful scheduled task processing, and perform statistical analysis on a regular basis. It also provides statistical analysis of student photo attributes at different levels of schools, and provides data export function for offline confirmation. School administrators maintain new student photo data through abnormal data lists.

5. A student photo inspection system, characterized in that: The system includes: The aggregation module is used to aggregate the student photo data through SQL query, determine the scope of the student photo data to be inspected, and limit the data range of the acquired collection according to user requirements or other requirements, and put the acquired data into the List collection; The photo parsing module is used to parse the school photo of each student through a for loop, obtain the photo attributes through ImageIO and store them in the data table; the attributes of the school photo include pixel width and height, size, update time, and whether there is an abnormality; The attribute parsing module is used to parse the attributes of each student photo according to custom specifications or relevant requirements, and record the number of students with irregular student photo pixels, irregular student photo sizes, irregular student photo update times, and abnormal student photo numbers; The statistical module is used to divide the inspected students according to their regions, and to collect statistics by primary range, secondary range, tertiary range and school range, and to provide query list data and abnormal data table export; The push module is used to filter out photos that do not meet pixel specifications, size specifications, time specifications or data anomalies through SQL according to the records in the list data and abnormal data table, and push the qualified photos to the target server through the file stream.

6. The student photo inspection system according to claim 5, characterized in that: When determining the data scope of the student photo inspection, limit the data scope for full inspection according to user requirements or other needs, and later obtain the data scope of the student photo inspection regularly according to the timestamp increment.

7. The student photo inspection system according to claim 5, characterized in that: The working process of the photo parsing module is as follows: ①Get each student's photo stream; ②Analyze the photo pixels, size, update time, and whether there are other anomalies; other anomalies include no photo data and parsing error data; ③Store all photos of all students.

8. The student photo inspection system according to any one of claims 5 to 7, characterized in that: The system also includes a settings module, which is used to set scheduled tasks, obtain incremental data on changes in student photo data based on the timestamp of successful processing of the recorded scheduled tasks, and perform statistical analysis on a regular basis. It also provides statistical analysis of student photo attributes at different levels of schools, and provides a data export function to achieve offline confirmation. School administrators maintain new student photo data through a list of abnormal data.

9. An electronic device, characterized in that: include: memory and at least one processor; Wherein, the memory stores a computer program; The at least one processor executes the computer program stored in the memory, so that the at least one processor executes the student photo inspection method as described in any one of claims 1 to 4.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, which can be executed by a processor to implement the student photo inspection method as described in any one of claims 1 to 4.

Images