Method for realizing automatic polling and early warning of validity period of supplier qualification based on timestamp superposition

Abstract

The application discloses a timestamp superposition-based supplier qualification validity period automatic polling early warning implementation method, and belongs to the technical field of data monitoring and early warning; the method comprises the following steps: constructing a supplier qualification information database; extracting the expiration date of each certificate and converting it into a timestamp; superimposing all expiration timestamps into a time axis sequence according to the supplier dimension and establishing an index; designing a day, week and month three-level time window; polling and scanning the certificates falling within the current window according to a preset frequency and calculating the remaining valid days; according to a configurable early warning rule engine, automatically matching red, yellow and green three-level early warnings according to the remaining days and differentiating and pushing the notifications, while containing a duplicate prevention mechanism; generating early warning history records and supporting processing state flow transfer and overtime follow-up, so as to realize a management closed loop from early warning triggering to processing confirmation. The application has high automation degree, greatly improves the scanning efficiency and early warning accuracy, and effectively reduces the business interruption risk caused by expired qualification.

Description

Technical Field

[0001] This invention relates to the field of data monitoring and early warning technology, specifically to a method for implementing automatic polling and early warning of supplier qualification validity period based on timestamp overlay. Background Technology

[0002] In supplier lifecycle management, the purchaser requires suppliers to provide various qualification certificates, such as business licenses, quality system certification certificates, confidentiality qualification certificates, special equipment manufacturing licenses, and safety production licenses. These certificates have different validity periods and are scattered across different business processes and storage media.

[0003] Currently, the management of supplier qualification validity periods mainly relies on the following methods: Manual ledger management: Enterprises record basic information of supplier qualification certificates (certificate name, number, issuance date, validity period, etc.) through Excel spreadsheets or paper files, and a designated person reviews and checks them regularly. The disadvantages of this method are: low efficiency of manual operation; easy to miss when there are many suppliers and types of certificates; and management may be interrupted due to personnel changes.

[0004] Traditional information system recording methods: Some companies record supplier qualification information through information systems such as ERP and SRM (supplier relationship management system), and the system provides a simple expiration reminder function; however, these systems usually only provide reminders for a fixed number of days in advance (such as 30 days in advance), and cannot provide differentiated warnings based on the characteristics of different types of certificates; the warning rules are fixed and lack flexibility.

[0005] Single warning triggering method: Existing technologies have related solutions for automatic warning of supplier expiration, which only realize the warning triggering at a single time node, and have the following defects: lack of multi-level warning mechanism, unable to provide differentiated reminders based on the remaining time; not involving the superimposed management and unified scanning of multiple certificate timestamps; and not realizing the tracking and closed-loop management of the warning processing status.

[0006] General early warning system: Recently, a safety information early warning system based on a large model has emerged, which can automatically manage enterprise qualification certificates, equipment monitoring reports and hidden danger investigation records, and notify relevant personnel through SMS and other means; however, this type of solution is only for general certificate management scenarios and lacks customized design for complex procurement scenarios with multiple qualifications for a single supplier and a large number of suppliers. It also has obvious deficiencies in the unified modeling and efficient scanning mechanism for the expiration time of multi-source heterogeneous qualification certificates.

[0007] In summary, existing technologies mainly suffer from drawbacks such as a single early warning mechanism, insufficient unified management capabilities for multiple certificates, low scanning efficiency under massive data, lack of closed-loop management, and insufficient flexibility in early warning rules. Summary of the Invention

[0008] To address these issues, this invention provides an automatic polling and early warning method for supplier qualification validity periods based on timestamp overlay, in order to solve the problems in existing supplier qualification management such as scattered validity periods of multiple certificates, easy omissions in manual monitoring, delayed early warnings, lack of differentiated hierarchical early warnings, low scanning efficiency, and inability to form a management closed loop.

[0009] To achieve the above objectives, the present invention provides the following technical solution: The method for implementing automatic polling and early warning of supplier qualification validity period based on timestamp overlay includes the following steps: S1. Collect supplier qualification certificate information and build a supplier qualification information database, in which each qualification certificate record is associated with the corresponding supplier number; S2. Extract the expiration date of each qualification certificate and convert it into a uniform timestamp format; S3. For each supplier, arrange the expiration timestamps of all its qualification certificates in ascending order to construct a timeline sequence for that supplier, and create an index for that timeline sequence; S4. According to the preset hierarchical time window, poll and scan the qualification certificates that are about to expire. The hierarchical time window includes daily window, weekly window and monthly window. Each scan only queries the certificate records whose expiration timestamp falls within the current time window interval and calculates the remaining valid days of the hit certificate. S5. Based on the remaining valid days and the pre-configured early warning rules, match and trigger the corresponding level of early warning notification; S6. Generate early warning history records and track the status of early warning processing until a management closed loop is formed.

[0010] Furthermore, the construction of the timeline sequence for the supplier and the establishment of an index specifically includes: establishing an independent timestamp sequence for each supplier, recording the sequence length, minimum timestamp, and maximum timestamp; and automatically triggering the recalculation of the timestamp sequence and index update when the certificate information changes.

[0011] Furthermore: within the tiered time windows, the daily window scans the next day and is executed daily; the weekly window scans the next 7 days and is executed weekly; and the monthly window scans the next 30 days and is executed monthly; the scanning range precisely corresponds to the timestamp interval.

[0012] Furthermore, the aforementioned warning grading triggering mechanism divides the warning level into three levels: a red emergency warning is triggered when the remaining valid days are between 0 and 7 days, a yellow warning warning is triggered when the remaining valid days are between 7 and 30 days, and a green alert warning is triggered when the remaining valid days are between 30 and 90 days; it also supports customizing the number of days thresholds for each level according to the certificate type.

[0013] Furthermore, the method of the present invention also includes a step to prevent duplicate warnings: notifications are not sent repeatedly for the same certificate and the same level within a preset time window, and new notifications are triggered only when the level is increased to a higher warning level.

[0014] Furthermore, the closed-loop management includes: automatically generating warning records containing complete fields, with warning status supporting at least pending, processing, processed, and ignored, and allowing status transitions; automatically escalating and expediting warnings that have not been processed within the time limit, and notifying higher-level management personnel.

[0015] Furthermore, early warning notifications are pushed through multiple channels such as in-app messages, emails, SMS, WeChat Work, and DingTalk. The messages contain a processing link, allowing recipients to directly update their certificates via the link, and the system automatically updates the early warning status.

[0016] The present invention also provides an automatic polling and early warning system for supplier qualification validity period that implements the above method.

[0017] The present invention has the following advantages: The present invention realizes full-process automation from data collection, timestamp modeling, polling scanning to early warning triggering, and can complete the continuous monitoring of the validity period of all supplier qualification certificates without manual intervention, which greatly reduces labor costs; By using timestamp overlay technology to model the expiration times of multiple certificates into a unified timeline sequence, and combined with precise scanning of tiered time windows, it is possible to accurately identify each certificate that is about to expire, effectively avoiding missed and false alarms. The hierarchical time window polling scanning algorithm adopts an incremental scanning strategy, scanning only the certificate records within the current time window each time, rather than a full scan, which greatly reduces the computational overhead and can run efficiently even with a large number of suppliers and certificates.

[0018] The rule engine-based early warning tiered triggering mechanism supports custom early warning thresholds based on certificate type. Different certificates can be configured with different early warning lead times to meet diverse business needs. The early warning history database fully records the entire process from early warning triggering to processing completion, supports status tracking, timeout reminders, and statistical analysis, and realizes a closed loop for supplier qualification management; By establishing an early warning mechanism and real-time status monitoring, warnings are triggered and actions are urged before qualifications expire, effectively avoiding business problems such as procurement interruptions and compliance risks caused by expired qualifications.

[0019] Other features and advantages of the present invention will be set forth in the following description. Attached Figure Description

[0020] To more intuitively illustrate the prior art and this application, exemplary drawings are provided below. It should be understood that the specific shapes and structures shown in the drawings should not generally be regarded as limiting conditions for implementing this application; for example, based on the technical concept disclosed in this application and the exemplary drawings, those skilled in the art are able to easily make conventional adjustments or further optimizations to the addition / reduction / classification, specific shapes, positional relationships, connection methods, size ratios, etc. of certain units (components).

[0021] Figure 1 A flowchart illustrating the automatic polling and early warning method for supplier qualification validity period based on timestamp overlay provided in this application embodiment.

[0022] Figure 2 This is a schematic diagram illustrating the construction of a timestamp overlay monitoring model in an embodiment of the present invention.

[0023] Figure 3 This is a flowchart of the hierarchical time window polling scanning algorithm in an embodiment of the present invention.

[0024] Figure 4 This is a schematic diagram of the early warning grading triggering mechanism in an embodiment of the present invention.

[0025] Figure 5 This is a flowchart of the early warning history record and closed-loop management process in an embodiment of the present invention.

[0026] Figure 6 To achieve Figure 1 The system module architecture diagram of the method. Detailed Implementation

[0027] The following specific embodiments illustrate the implementation of the present invention. Those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. Obviously, the described embodiments are only some embodiments of the present invention, not all embodiments. It should be understood that these embodiments are only for further illustration of the present invention and should not be construed as limiting the scope of protection of the present invention. Those skilled in the art can make some non-essential improvements and adjustments to the present invention based on the above-described content.

[0028] Terminology Explanation: Supplier qualifications: refers to the various legal qualifications and professional capabilities that suppliers must possess before participating in procurement cooperation, including but not limited to business licenses, quality system certification certificates, confidentiality qualification certification certificates, special equipment manufacturing licenses, safety production licenses, etc. A timestamp is a data marker used to identify the time when an event occurs. In this invention, timestamps are used to record the expiration dates of various qualification certificates. Timestamp overlay: refers to the process of merging and arranging the expiration timestamps of multiple qualification certificates according to the supplier dimension, forming a timeline sequence with multiple time points arranged sequentially along the time axis; Polling scan: refers to the calculation process of iterating through and checking all the expiration time data of qualification certificates stored in the system according to a preset time period; Tiered time window: This refers to dividing the warning triggering conditions into different time intervals (such as daily, weekly, and monthly) based on the remaining validity period of the qualification certificate. Each interval corresponds to a different scanning frequency and warning level. Early warning grading triggering mechanism: refers to a rule system that automatically matches a preset early warning level (such as green, yellow, and red) based on the remaining validity days of the qualification certificate and triggers a notification of the corresponding urgency level.

[0029] See Figure 6 The system for implementing the automatic polling and early warning method for supplier qualification validity period based on timestamp overlay described in this invention adopts a modular architecture. The system includes: a data management module, a timestamp modeling module, a polling and scanning engine, a rule engine module, an early warning management module, a notification push module, and a statistical analysis module. Each module can be deployed on an application server, and the underlying database adopts a relational database. Example 1

[0030] Please see Figures 1-5 The method for automatically polling and issuing early warnings about the validity period of supplier qualifications based on timestamp overlay includes the following steps: S1: Establish a database of supplier qualification information; Administrators can create basic supplier information and qualification certificate information through the system interface or batch import; the specific content is as follows: (1) Supplier basic information management: Enter the supplier's unified social credit code, name, registered address, contact person, contact information and other basic information, and assign a unique supplier number to each supplier; (2) Qualification certificate information management: For each type of qualification certificate (including but not limited to business license, quality system certification certificate, confidentiality qualification certification certificate, special equipment manufacturing license, safety production license, etc.), enter detailed information such as certificate name, certificate number, issuing agency, issuance date, expiration date, and storage path of certificate scan; each qualification certificate record is associated with the corresponding supplier number.

[0031] (3) Certificate type configuration: The system has pre-set templates for commonly used qualification certificate types, supports administrators to customize certificate types, and configures default early warning parameters for each certificate type (such as 90 days, 60 days, 30 days in advance, etc.).

[0032] S2: Construct a qualification validity period monitoring model based on timestamp overlay; The qualification validity period monitoring model is used to merge and arrange the expiration dates of multiple qualification certificates held by a supplier according to the supplier dimension; the system builds a timestamp overlay monitoring model for each supplier through database operations or background services; the specific content is as follows: (1) Timestamp extraction: Extract the expiration dates of all qualification certificates held by each supplier from the supplier qualification information database, convert each expiration date into Unix timestamp format (number of seconds since January 1, 1970), and use it as the expiration timestamp of the certificate; (2) Timestamp stacking: For the same supplier, the expiration timestamps of all its qualification certificates are arranged in ascending order to form a timestamp sequence with time as the axis. ,in, Let represent the expiration timestamp of the i-th certificate, and n is the total number of certificates; this timestamp sequence is the "qualification validity period timeline" for the supplier. (3) Time axis index construction: an index is built for each supplier's timestamp sequence, recording metadata such as sequence length (total number of certificates), minimum timestamp (most recently expired certificate), maximum timestamp (latest expired certificate), etc., to facilitate subsequent fast query and scanning; (4) Dynamic update mechanism: When a supplier qualification certificate is added, updated or deleted, the recalculation and index update of the supplier timestamp sequence is automatically triggered to ensure that the monitoring model is always synchronized with the actual data; For example, if a supplier obtains a new business license valid until December 31, 2027, its timeline sequence will be reordered and expanded.

[0033] S3: Design a polling scanning algorithm based on hierarchical time windows; A tiered time window polling scanning algorithm is used to automatically scan for expiring qualification certificates at different time granularities; the specific steps are as follows: (1) Definition of tiered time windows: Based on the actual business needs of qualification certificate expiration warning, the time windows are divided into three levels: daily window, weekly window and monthly window; The daily window (Level D) scans certificates expiring from the current time to the next day; the scan frequency is once a day (e.g., executed at 00:00 every day); this daily window is used to handle urgently expiring certificates and triggers the highest level of alert. Weekly window (W level): The scanning scope is certificates expiring from the current time to the next 7 days; the scanning frequency is once a week (e.g., executed every Monday at 00:00); this weekly window is used to process certificates that are about to expire, triggering a medium-level warning; Monthly window (M level): The scanning scope is certificates expiring from the current time to the next 30 days; the scanning frequency is once a month (e.g., executed at 00:00 on the 1st of each month); this monthly window is used to process certificates that are about to expire and triggers a low-level warning.

[0034] (2) Incremental scanning strategy: During each polling scan, the system only checks certificates that have expired within the current time window, instead of scanning all certificates; the details are as follows: Daily scan: Query certificate records whose expiration timestamps are in the range of [current timestamp, current timestamp + 86400]; Weekly scan: Query certificate records whose expiration timestamps fall within the range of [current timestamp, current timestamp + 604800]; Monthly scan: Query certificate records whose expiration timestamps are within the range of [current timestamp, current timestamp + 2592000]; By limiting the scanning range through a time window, the computational cost of each scan is significantly reduced.

[0035] (3) Calculation of remaining days: For each certificate record scanned, calculate the difference between the current time and the expiration time to obtain the remaining valid days. : ; in, This is the certificate expiration timestamp; The result is the current system timestamp, rounded up.

[0036] (4) Scan result caching: The results of each polling scan (a list of certificates that are about to expire and their remaining days) are stored in the cache for subsequent warning triggering steps to avoid duplicate calculations.

[0037] S4: Construct a tiered early warning triggering mechanism based on a rule engine; The early warning grading triggering mechanism is used to automatically match the early warning level and trigger the corresponding notification based on the remaining number of valid days of the certificate; (1) Definition of warning level: based on the remaining valid days The warnings are divided into three levels, and the default thresholds are shown in Table 1 below: Table 1

[0038] (2) Warning rule configuration. The system provides a visual configuration interface for warning rules, allowing administrators to customize the remaining days threshold for each level of warning based on different qualification certificate types; For example: Quality system certification certificate (renewal requires a large amount of material to be prepared in advance): can be configured with green for 90 days, yellow for 60 days, and red for 30 days; Business license (renewal process is relatively simple): can be configured with green for 60 days, yellow for 30 days, or red for 7 days; (3) Early warning triggering logic. After the polling scan is completed, the scan results are matched with the early warning rules: like >Green threshold, no warning triggered; If the green threshold is ≥ > Yellow threshold triggers Level 3 (green) alert; If the yellow threshold is ≥ > Red threshold triggers Level 2 (yellow) alert; If the red threshold is ≥ >0 triggers a Level 1 (red) alert; like If the value is ≤0, an "expired" alarm will be triggered.

[0039] (4) Anti-duplicate warning mechanism: For the same certificate and the same warning level, the same warning notification will not be sent repeatedly within the preset time window after the warning is triggered (e.g., 7 days) to avoid information bombardment; however, when the remaining days of the certificate cross the higher warning level (e.g., from green to yellow), the new level warning notification will be triggered. For example, if the certificate "Special Equipment Manufacturing License" triggers a yellow alert when there are 45 days remaining; if it is still in the yellow zone after 6 days and 39 days remaining, the system will suppress repeated notifications when it scans again; if it enters the red zone when there are 30 days remaining, a red alert will be triggered immediately.

[0040] S5: Establish a historical early warning record database and implement closed-loop management; The early warning history database records complete information on all early warning events, supporting the tracking and closed-loop management of early warning processing status; specific contents are as follows: (1) Warning record generation: Each time a warning is triggered, the system automatically generates a warning record. The warning record includes the following fields: warning ID, supplier number, supplier name, certificate name, certificate number, expiration time, remaining days, warning level, trigger time, warning status (pending / processing / processed / ignored), handler, processing time, processing remarks, etc. (2) Warning status transition: The warning record status supports the following transition paths: Pending processing → In processing → Processed (closed loop); Pending processing → Ignored (confirmed no processing required); (3) Upgrading and urging of unprocessed warnings: For warning records that have not been processed after a preset time (e.g., 3 days), the system will automatically upgrade the warning level by one level and send a notification again; for warnings that have not been processed after a preset time (e.g., 7 days), the system will automatically notify higher-level management personnel. (4) Statistical analysis dashboard: Based on the warning history database, the system provides multi-dimensional statistical analysis functions, including: total number of warnings for each supplier, distribution of warnings for each type of certificate, warning processing rate, average processing time, etc., to provide data support for management decisions.

[0041] S6: Multi-channel push, processing and tracking of early warning information; Specifically, (1) Multi-channel push: The system supports pushing warning notifications to relevant personnel through various channels such as in-site messages, emails, SMS, and WeChat / DingTalk messages; the push content includes key information such as supplier name, certificate name, expiration time, remaining days and handling suggestions; (2) Recipient configuration: Supports configuring alert recipients by supplier dimension (such as supplier administrator, purchasing manager, etc.), and also supports configuring different recipients by certificate type dimension; (3) Processing and tracking: The recipient can directly jump to the system processing page through the link in the push message to perform operations such as certificate renewal, update or confirmation; after the operation is completed, the system automatically updates the status of the warning record to complete the management loop. Example 2

[0042] The method for implementing automatic polling and early warning of supplier qualification validity period based on timestamp overlay includes the following steps: S1: Establish a database of supplier qualification information; The administrator enters the supplier's basic information (unified social credit code, name, contact person, etc.) into the system and assigns a unique number to each supplier; For each supplier, enter all the qualification certificate information they hold, including certificate name, certificate number, issuing authority, issuance date, and expiration date; Suppose a supplier holds three certificates: a business license (valid until 2027-12-31), ISO9001 quality system certification (valid until 2026-06-30), and a confidentiality qualification certification (valid until 2026-03-31). The system also supports pre-configuration of certificate types, allowing you to set default warning parameters for each certificate type.

[0043] S2: Construct a qualification validity period monitoring model based on timestamp overlay; The system extracts the expiration dates of the three certificates entered in S1 from the database and converts them into Unix timestamps. The three timestamps are then sorted in ascending order to form the timestamp sequence T={Security Qualification Certificate Expiration Date, ISO9001 Expiration Date, Business License Expiration Date} for the supplier. The system creates an index for this sequence, recording metadata such as the total number of certificates (3) and the minimum timestamp (most recent expiration). When certificate information changes, the system automatically triggers the recalculation of the supplier's timestamp sequence.

[0044] S3: Design a polling scanning algorithm based on hierarchical time windows; The system performs polling scans at a preset frequency; taking a daily scan as an example, at 00:00 every day, the system queries all certificate records whose expiration timestamps fall within the range of [current timestamp, current timestamp + 86400]; Assuming the current date is March 30, 2026, and the confidentiality certification expires on March 31, 2026, with 1 day remaining, the certificate is detected by the daily scan; the system calculates the remaining valid days. The scan results are stored in the cache.

[0045] S4: Construct a tiered early warning triggering mechanism based on a rule engine; The system matches the scan results from step S3 with the warning rules; the warning thresholds for the confidentiality qualification authentication configuration are: green for 90 days, yellow for 30 days, and red for 7 days. The current remaining days Δd = 1 ≤ 7 days, triggering a Level 1 (red) emergency warning; the system generates a warning record, which includes supplier information, certificate information, remaining days 1 day, warning level red, etc.; the anti-duplicate warning mechanism checks and confirms that the certificate has not sent a red warning within 7 days, and then allows it to send.

[0046] S5: Establish a warning history database and implement closed-loop management; the system automatically generates a warning record with a status of "pending processing"; the warning record is stored in the warning history database; the system starts timeout monitoring: if the warning is not processed within 3 days, the system automatically escalates and notifies again; if it is still not processed within 7 days, it notifies higher-level management personnel.

[0047] S6: Multi-channel push and processing tracking of early warning information: The system simultaneously sends alert notifications to supplier administrators and purchasing managers via WeChat, email, and in-system messages. The notification reads: "[Urgent Alert] Supplier XXX's confidentiality certification will expire in one day (March 31, 2026). Please handle this immediately." The recipient clicks the message link to be redirected to the processing page. After updating the certificate renewal information, the system automatically updates the alert record status to "Processed," completing the management loop. Example 3

[0048] The automatic polling and early warning method for supplier qualification validity period based on timestamp overlay includes the following steps: S1: Establish a database of supplier qualification information; Administrators can create basic supplier information and qualification certificate information through the system interface or batch import; details are as follows: First, enter the following information into the supplier basic information table (supplier_info): supplier number (supplier_id), unified social credit code, supplier name, contact person, contact number, registered address, etc. Each supplier is assigned a unique number. Secondly, enter detailed information for each certificate in the certificate information table (certificate_info), including fields such as: certificate number (cert_id), associated supplier number, certificate name, certificate type (e.g., business license, ISO9001, confidentiality qualification, etc.), issuing authority, issuance date, expiry date (expiry_date), and storage path for the scanned certificate; and associate suppliers with supplier_id. In addition, the system has a pre-configured certificate type table (cert_type_config), which allows you to configure default warning parameters for each certificate type; For example: type_id='QMS', type_name='Quality System Certification'; default_green_days=90, default_yellow_days=60, default_red_days=30; Administrators can add custom certificate types and set default values; individual certificates can also inherit default values ​​or be customized.

[0049] S2: Construct a qualification validity period monitoring model based on timestamp overlay; The system builds a timestamp overlay monitoring model for each supplier through database jobs or background services; the details are as follows: Timestamp extraction: Group by supplier_id from the certificate_info table, extract all expiry dates (expiry_date), convert them to Unix timestamps (number of seconds since 1970-01-01) using database functions, and store them as expiry_timestamp; Timestamp stacking: For all expiry_timestamps under the same supplier_id, sort them in ascending order of value to form a timestamp sequence; this sequence represents the timeline of the expiry times of all certificates of this supplier. Index Construction: To facilitate fast querying and scanning, a timeline index table `supplier_timeline(supplier_id, cert_count, min_timestamp, max_timestamp, timeline_json)` can be maintained. `timeline_json` stores the complete sequence, recording the sequence length, the minimum timestamp corresponding to the most recently expired certificate, and the maximum timestamp of the latest expiration. Dynamic updates: When an insert, update, or delete operation occurs in the certificate_info table, the timestamp sequence of the corresponding supplier is automatically recalculated and the index table is updated through database triggers or application layer events to ensure that the monitoring model is synchronized with the actual data in real time. For example, if a supplier adds a business license with an expiration date of 2027-12-31, its timeline sequence will be reordered and expanded.

[0050] S3: Design a polling scanning algorithm based on hierarchical time windows; The polling scanning engine contains three independently scheduled time tasks, each corresponding to a three-level time window; specifically: (1) Window definition and scheduling: DailyScanJob: Executes daily at 00:00, scanning from the current time to one day in the future. The timestamp range is [now_ts, now_ts+86400]. Weekly window task (WeeklyScanJob): Executed every Monday at 00:00, scanning interval [now_ts,now_ts+604800]; MonthlyScanJob: Executed at 00:00 on the 1st of each month, scanning the interval [now_ts, now_ts+2592000].

[0051] (2) Incremental scan strategy: When each task is executed, instead of a full table scan, the expire_timestamp index built on the certificate_info table is used to perform a range query as shown in Table 2 below: Table 2

[0052] This approach only hits certificates within the current time window, significantly reducing I / O and computational overhead.

[0053] (3) Calculation of remaining days: For each record retrieved, calculate the remaining valid days. The result is rounded up to ensure timely warning.

[0054] (4) Scan result caching: Store the cert_id, supplier_id, remaining_days, etc. of the hit certificate into the scan result cache table (scan_result) for use by the rule engine in the future to avoid duplicate calculation.

[0055] S4: Construct a tiered early warning triggering mechanism based on a rule engine; See Figure 4 The specific details are as follows: (1) Definition of warning level: The system has a built-in three-level warning system with the following default thresholds: Level 1 (Red - Emergency): 0 days < ≤7 days; Level 2 (Yellow Warning): 7 days < ≤30 days; Level 3 (Green Warning): 30 days < ≤90 days; (2) Warning rule configuration: The rule engine reads the thresholds (green_days, yellow_days, red_days) from the certificate type configuration or certificate personalization configuration. If the certificate is configured separately, the default value is used; otherwise, the default value is used. For example: an ISO9001 certificate is set to green=90, yellow=60, red=30; a business license is set to green=60, yellow=30, red=7.

[0056] (3) Trigger matching logic: The engine iterates through the records in scan_result, obtains the corresponding threshold for each record, and makes a judgment: like >green_days, no alerts will be triggered; If green_days ≥ > yellow_days, triggering a level 3 green alert; If yellow_days ≥ >red_days, triggering a level 2 yellow alert; If red_days ≥ >0 triggers a Level 1 Red Alert; like If the value is ≤ 0, an "expired" alarm will be triggered.

[0057] Anti-duplicate warning mechanism: Before generating a warning record, the engine queries the warning history table alert_record to see if there is a record with the same cert_id, the same warning level, and the warning status is "pending" or "processing", and the trigger time is within a preset suppression window (such as 7 days). If it exists, the warning is skipped to avoid information bombardment. However, when the remaining days decrease further and the warning level is increased (such as from green to yellow), the anti-duplicate restriction is not applied and the new warning level is still triggered.

[0058] S5: Early Warning Historical Record Database and Closed-Loop Management; See Figure 5 The early warning management module is responsible for generating early warning records and tracking their status; Warning record generation: Each time a warning is triggered, a record is inserted into the alert_record table. The fields include: warning ID, supplier number, supplier name, certificate number, certificate name, expiration time, remaining days, warning level (RED / YELLOW / GREEN), warning trigger time, warning status (initially "pending"), handler, processing time, and processing remarks.

[0059] Escalation and follow-up of unprocessed alerts: The system sets up a scheduled follow-up task; it scans records in alert_record that are in a "pending" or "processing" state and have exceeded the preset time limit: if they are not processed for more than 3 days, the original alert level is upgraded by one level (yellow to red, green to yellow), a new upgraded alert record is generated, and it is pushed again through the notification module, while also notifying the current person in charge; if they are still not processed for more than 7 days, a follow-up notification is automatically sent to a higher-level manager (such as the department director) to ensure that the problem is not left unresolved.

[0060] Statistical Analysis Dashboard: Based on the alert_record table, it provides multi-dimensional statistics: total number and processing rate of alerts for each supplier, alert distribution for each certificate type, average processing time, list of overdue and unprocessed alerts, etc., providing data support for management decisions.

[0061] S6: Multi-channel push, processing and tracking of early warning information; The notification push module integrates email SMTP service, SMS gateway, and open API interfaces of WeChat Work and DingTalk to enable automatic push of early warning notifications through multiple channels.

[0062] The pushed message content is dynamically generated using a configurable message template; the template contains fixed text and variable placeholders, and the system automatically replaces the placeholders with the actual data of this warning when sending the message; the variable placeholders include at least: warning level name, supplier name, certificate name, expiration date, remaining days and processing link identifier; For example: "[Red Emergency Warning] Supplier XX Technology Co., Ltd.'s Special Equipment Manufacturing License will expire on August 20, 2026, with 3 days remaining. Please handle this as soon as possible; processing link:" "Unique identifier for early warning records".

[0063] Recipient Configuration: The system allows for maintaining a pre-warning recipient configuration table, specifying recipients by supplier or certificate type; it also supports sending the same pre-warning notification to multiple people.

[0064] Processing Tracking: The recipient clicks the processing link in the message and is redirected to the system processing page. This page displays the alert details and provides an "Update Certificate" entry. Operators can upload a new scanned copy of the certificate, fill in the new validity period, and submit it. After submission, the system updates the certificate_info table and automatically sets the alert_record status to "Processed," recording the processor and processing time. For certificates that are confirmed to require no processing, the "Ignore" option can be selected, changing the status to "Ignored" and recording the reason. At this point, a complete alert processing loop is completed. Example 4

[0065] Complex scenarios with multiple certificates: Assume a supplier holds 5 certificates with expiration dates ranging from 2 days to 200 days in the future. Timestamps are superimposed to form a sequence. Daily scans capture certificates within the next day, triggering a red alert; weekly scans capture another certificate within the next 7 days, triggering a yellow alert; monthly scans may capture certificates within the next 30 days, triggering a green alert. These three scan tasks run independently without interference. When a certificate's expiration date decreases from 32 days to 28 days, the monthly green alert is upgraded to a weekly yellow alert, thus achieving smooth, tiered alert notifications.

[0066] The number of days in the aforementioned time window, the warning threshold, and the scanning frequency can all be adjusted in the configuration center according to actual business needs. For example, a quarterly window (90 days) can be added, all without departing from the scope of protection of this invention. Similarly, the warning level can be expanded to more levels, and other high-precision time representations can be used for the timestamp format. Any simple modifications within the technical concept of this invention should fall within the scope of protection of this invention.

[0067] The method of this invention is used for automated monitoring and early warning of the validity period of various qualification certificates in the whole life cycle management of suppliers. The method of this invention combines timestamp overlay technology, hierarchical time window polling scanning algorithm and rule engine, which effectively solves the pain points of supplier qualification management such as the scattered validity periods of multiple certificates, easy omissions in manual monitoring, and delayed early warning.

[0068] The method of this invention includes steps such as constructing a timestamp overlay monitoring model, designing a hierarchical time window polling scanning algorithm, establishing a hierarchical early warning triggering mechanism, and constructing an early warning historical record database; it has higher monitoring accuracy, lower false negative rate, and better management closed-loop effect.

[0069] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of the present invention should be included within the protection scope of the present invention.

Claims

1. A method for automatic polling and early warning of supplier qualification validity period based on timestamp overlay, characterized in that, Includes the following steps: Step S1: Collect supplier qualification certificate information and build a supplier qualification information database, in which each qualification certificate record is associated with the corresponding supplier number; Step S2: Extract the expiration date of each qualification certificate and convert it into a uniform timestamp format; Step S3: For each supplier, arrange the expiration timestamps of all its qualification certificates in ascending order to construct a timeline sequence for each supplier, and create an index for this timeline sequence; Step S4: According to the preset hierarchical time window, poll and scan the qualification certificates that are about to expire; the hierarchical time window includes daily window, weekly window and monthly window. Each scan only queries the certificate records whose expiration timestamp falls within the current time window interval, and calculates the remaining valid days of the matched certificates. Step S5: Match and trigger the corresponding level of warning notification based on the remaining valid days and the pre-configured warning rules; Step S6: Generate early warning history records and track the early warning processing status until a management closed loop is formed.

2. The method for automatic polling and early warning of supplier qualification validity period based on timestamp overlay as described in claim 1, characterized in that, The specific content of constructing the timeline sequence for the supplier and creating an index for the timeline sequence in step S3 includes: (1) Establish an independent timestamp sequence for each supplier. ,in, Let represent the expiration timestamp of the i-th certificate, and where n is the total number of certificates; (2) Record the sequence length n, minimum timestamp t1, and maximum timestamp tn of the timestamp sequence; (3) When a supplier’s qualification certificate information is added, updated or deleted, the timestamp sequence of the supplier is automatically recalculated and the index is updated.

3. The method for automatic polling and early warning of supplier qualification validity period based on timestamp overlay as described in claim 1, characterized in that, The hierarchical time window: The scanning range of the daily window is certificates expiring from the current time to the next day, and the scanning frequency is once a day; The weekly window scans certificates expiring within the next 7 days from the current time, with a scanning frequency of once a week. The monthly window scans certificates expiring within the next 30 days from the current time, and the scanning frequency is once a month.

4. The method for automatic polling and early warning of supplier qualification validity period based on timestamp overlay as described in claim 1, characterized in that, The specific content of step S5 includes: (1) The warning level is divided into three levels; When 0 days ≤ Δd ≤ 7 days, a Level 1 red alert is triggered; When 7 days < Δd ≤ 30 days, a Level II yellow alert is triggered; When 30 days < Δd ≤ 90 days, a Level 3 green alert is triggered; Where Δd represents the remaining valid days; (2) Provide a visual configuration interface for early warning rules, and support customizing the remaining days threshold for each early warning level according to the qualification certificate type; (3) In step S5, after the polling scan is completed, the remaining valid days of the hit certificate are matched with the warning rules of the corresponding certificate type to determine the warning level and send a notification of the corresponding urgency level.

5. The method for automatic polling and early warning of supplier qualification validity period based on timestamp overlay as described in claim 4, characterized in that, For the same certificate and the same warning level, the same warning notification will not be sent repeatedly within the preset time window; When the remaining validity days of the certificate reach a higher warning level, a new warning notification at that level is allowed to be triggered.

6. The method for automatic polling and early warning of supplier qualification validity period based on timestamp overlay as described in claim 1, characterized in that, The specific content of step S6 includes: (1) Each time an alert is triggered, an alert record is automatically generated. The alert record includes the alert ID, supplier number, supplier name, certificate name, certificate number, expiration time, remaining days, alert level, trigger time, and alert status fields. (2) The warning status includes pending, processing, processed and ignored, and allows flow along a preset path; (3) For warning records that have not been processed after the first preset time, the warning level will be automatically upgraded and a notification will be sent again; for warning records that have not been processed after the second preset time, a higher-level manager will be automatically notified.

7. The method for automatic polling and early warning of supplier qualification validity period based on timestamp overlay as described in claim 1, characterized in that, The warning notification in step S5 is pushed through multiple channels. The push notification includes the supplier name, certificate name, expiration date, remaining days, and processing suggestions. A processing link is also embedded in the push notification message, allowing the recipient to directly access the processing page to complete the certificate update or confirmation operation. After the operation is completed, the status of the corresponding warning record is automatically updated.

Images