Broadband service order withdrawal processing method and computer program product

Abstract

The invention provides a broadband service withdrawal processing method and a computer program product, and the method comprises the steps: displaying an auditing visual interface based on a to-be-audited work order acceptance instruction when an auditor accepts a to-be-audited work order; through auditing the broadband network information displayed based on the satellite map in the visual interface, auditing personnel can clearly judge whether the position of the work order to be audited is in the uncovered / thin-covered area of the broadband network. And if the audit is passed, the computing device can update the uncovered / thinly-covered area data of the broadband network based on the position of the audit work order, so that the uncovered / thinly-covered area data of the broadband network can be effectively recorded, and the order withdrawal position can be accurately reflected.

Description

Technical Field

[0001] This disclosure relates to the field of passive optical network technology, and in particular to a broadband service cancellation processing method and a computer program product. Background Technology

[0002] In the daily operation of broadband services, order cancellations occur frequently. For example, some areas may have insufficient network coverage, and upon arrival at the site, installers may find that the area has not actually achieved network coverage. Another example is that the fiber optic cable is too far from the user's end, exceeding the effective signal transmission range. Order cancellations typically require review by an auditor based on the actual situation. Generally, the person canceling the order manually fills in the reason and the location of the uncovered area on the work order, and then the management reviews and completes the work order.

[0003] However, the text information in the work order cannot fully reflect the cancellation location, broadband resource coverage, and the location of areas with little or no coverage. This makes it easy for broadband cancellation reviews based on work orders to be inaccurate due to coverage issues, resulting in the loss of market business. Summary of the Invention

[0004] This disclosure provides a method and computer program product for processing broadband service cancellations. It receives and accepts pending work orders and displays a visual review interface. The broadband network information displayed in the visual interface assists reviewers in the review process. After the cancellation work order is approved, it updates the uncovered / thinly covered areas of the broadband network in real time to facilitate subsequent reuse.

[0005] In one aspect, this embodiment provides a method for processing broadband service cancellations. The method includes: receiving an instruction to accept a pending work order, wherein the pending work order is determined at least based on the cancellation instruction; displaying a review visualization interface, wherein the review visualization interface includes at least broadband network information displayed based on a satellite map, wherein the broadband network information includes at least the location information of the person canceling the order, a broadband network uncovered / thin coverage area, and the location information of the pending work order, wherein the broadband network information is at least used by the reviewer to determine whether to approve the pending work order; and upon receiving an instruction to approve the pending work order, updating the broadband network uncovered / thin coverage area based on the location information of the pending work order.

[0006] In the embodiments of this disclosure, the broadband network information also includes broadband network coverage cell information and broadband network coverage fiber distribution box information. The audit visualization interface also includes a remote video control, which is at least used to initiate a remote video request to the first terminal device of the person canceling the order when the auditer triggers the remote video control.

[0007] In embodiments of this disclosure, the method further includes: acquiring broadband network coverage data, cancellation order data, and location information of the person canceling the order; the broadband network coverage data includes at least broadband network coverage cell information and broadband network coverage fiber distribution box information; the cancellation order data includes at least the location information of the cancellation order, the customer information of the cancellation order, and the fiber distribution box information of the cancellation order; and the pending work order is a cancellation order; and constructing a full broadband resource database based on the broadband network coverage data, constructing a broadband cancellation order information database based on the cancellation order data and the location information of the person canceling the order, and constructing an uncovered resource storage database based on the data information of the broadband network uncovered / thin coverage areas, the data information including at least the location information and customer information of the broadband network uncovered / thin coverage areas.

[0008] In the embodiments disclosed herein, the method further includes: based on the full broadband resource database, the broadband order cancellation work order information database, and the uncovered resource storage database, setting broadband network coverage cell information icons, broadband network coverage fiber distribution box information icons, location information icons of order cancellation personnel, broadband network uncovered / thin coverage area icons, and location information icons of work orders pending review, in order to construct broadband network information based on satellite map display.

[0009] In embodiments of this disclosure, the method further includes: receiving a cancellation order instruction, which is generated at least when the person canceling the order triggers the cancellation order control through a first terminal device; and generating a pending review order based on the cancellation order instruction, the full broadband resource library, the broadband cancellation order information library, and the uncovered resource storage database, wherein the pending review order includes at least location information and customer information, and the pending review order instruction is generated at least when the reviewer triggers the acceptance control through a second terminal device.

[0010] In embodiments of this disclosure, the method further includes: obtaining click coordinate information, which is generated when the reviewer clicks on the broadband network coverage cell information icon, the broadband network coverage fiber distribution box information icon, the location information icon of the person canceling the order, the broadband network uncovered / thin coverage area icon, or the location information icon of the work order to be reviewed; generating a broadband information query request, which includes at least the click coordinate information; and obtaining and displaying broadband network coverage data, cancellation work order data, location information of the person canceling the order, and / or data information of the broadband network uncovered / thin coverage area that match the click coordinate information from the full broadband resource database, the broadband cancellation work order information database, and / or the uncovered resource storage database.

[0011] In the embodiments of this disclosure, upon receiving an instruction to approve a work order pending review, the broadband network coverage area (not covered / thin coverage area) is updated based on the location information of the work order pending review. This includes displaying a cancellation confirmation interface, which at least includes an icon for the broadband network coverage area (not covered / thin coverage area), an icon for the location information of the work order pending review, a selection area coordinate control, a selection point coordinate control, and a multiple cancellation mark coordinate control. The selection area coordinate control and the selection point coordinate control are used at least when the location information of the work order pending review does not belong to the broadband network coverage area (not covered / thin coverage area); the multiple cancellation mark coordinate control is used at least when the location information of the work order pending review does belong to the broadband network coverage area (not covered / thin coverage area).

[0012] In embodiments of this disclosure, the method further includes: when the reviewer triggers the cancellation mark coordinate control multiple times, matching the broadband network uncovered / thin coverage area in the uncovered resource storage database based on the location information of the work order to be reviewed; and modifying the number of cancellations and the contact information of the canceling customer in the data information of the broadband network uncovered / thin coverage area based on the customer information of the work order to be reviewed.

[0013] In embodiments of this disclosure, the method further includes: when the reviewer triggers the point coordinate control or the surface coordinate control, locating the work order to be reviewed on a satellite map based on the location information of the work order to be reviewed; obtaining the location coordinates, which are generated when the reviewer clicks on the satellite map; and storing the location coordinates and the customer information of the work order to be reviewed in an uncovered resource storage database.

[0014] In another aspect, embodiments of this disclosure provide a computer program product, including a computer program that, when executed by a processor, implements the aforementioned broadband service cancellation processing method. Attached Figure Description

[0015] The above and other objects, features, and advantages of this disclosure will become more apparent from the more detailed description of the embodiments thereof in conjunction with the accompanying drawings. The drawings are provided to further illustrate the embodiments of this disclosure and form part of the specification. They are used together with the embodiments of this disclosure to explain the disclosure and do not constitute a limitation thereof. In the drawings, the same reference numerals generally represent the same components or steps.

[0016] Figure 1 The schematic diagram illustrates an environmental application according to an embodiment of the present disclosure.

[0017] Figure 2 The flowchart illustrating a broadband service cancellation processing method according to an embodiment of the present disclosure is shown in the illustration.

[0018] Figure 3 The flowchart illustrates another broadband service cancellation processing method according to an embodiment of the present disclosure.

[0019] Figure 4 The flowchart illustrates another broadband service cancellation processing method according to an embodiment of the present disclosure.

[0020] Figure 5 The flowchart illustrates another broadband service cancellation processing method according to an embodiment of the present disclosure.

[0021] Figure 6 The flowchart illustrating the process of updating a broadband network with thin coverage areas based on the location information of a work order to be reviewed, according to an embodiment of the present disclosure, is shown in the diagram.

[0022] Figure 7 A block diagram illustrating a computer program product according to an embodiment of the present disclosure is shown schematically. Detailed Implementation

[0023] To make the objectives, technical solutions, and advantages of this disclosure more apparent, exemplary embodiments according to this disclosure will now be described in detail with reference to the accompanying drawings. Obviously, the described embodiments are merely some embodiments of this disclosure, and not all embodiments of this disclosure. It should be understood that this disclosure is not limited to the exemplary embodiments described herein.

[0024] Figure 1 The schematic diagram illustrates an environmental application according to an embodiment of the present disclosure.

[0025] like Figure 1 As shown, it includes a first terminal device 101, a computing device 102, and a second terminal device 103. The first terminal device 101, the computing device 102, and the second terminal device 103 can perform real-time data transmission.

[0026] The first terminal device 101 and the second terminal device 103 can include any type of electronic device, such as smartphones, tablets, laptops, etc. Frontline cancellation personnel can access the broadband installation system on the computing device 102 through the browser of the first terminal device 101 and initiate a cancellation work order. The computing device 102 can receive the cancellation work order instruction and generate pending review work orders based on it. The computing device 102 can send multiple pending review work orders to the second terminal device 103. Reviewers select pending review work orders through the second terminal device 103 according to rules such as the time the request was initiated or the customer level. If the "Accept" button is clicked, an "Accept Pending Review Work Order" instruction is sent to the computing device 102. The computing device 102 can display a visual review interface based on the "Accept Pending Review Work Order" instruction, showing broadband network coverage information via satellite map to facilitate accurate review by the reviewers.

[0027] The computing device 102 may have data processing, logical operation, and storage functions. For example, the computing device 102 may include computing devices such as servers, tablet computers, desktop computers, laptop computers, notebook computers, computing nodes, or netbooks. Among them, the server may be different types of servers such as rack servers, blade servers, or tower servers.

[0028] Next, this article will combine Figures 2-6 This document provides a detailed explanation of how computing device 102 displays a visual interface for reviewing pending work orders, enabling reviewers to conduct accurate reviews.

[0029] Figure 2 The flowchart illustrating a broadband service cancellation processing method according to an embodiment of the present disclosure is shown in the illustration.

[0030] S201. Receive and accept work order instructions pending review. Work orders pending review are determined at least based on cancellation work order instructions.

[0031] In this embodiment, the cancellation personnel can process cancellations based on the on-site broadband situation. For example, the cancellation personnel can interact with the computing device through an installation and maintenance APP installed on a first terminal device, triggering the cancellation process on the APP to send a cancellation work order instruction to the computing device. The computing device can generate a work order to be reviewed based on the cancellation work order instruction and display it to the reviewer. For example, the computing device can send the work order to be reviewed to a second terminal device used by the reviewer, who can then review the work order through the second terminal device; or, for example, the computing device can display the work order to be reviewed through its built-in display device, allowing the reviewer to browse the work order.

[0032] In some embodiments, the installation and maintenance app can be a mobile application platform that integrates various business processes, data management, and operation guidelines during broadband installation using mobile internet technology. Its purpose is to improve broadband installation efficiency, standardize installation processes, and enhance service quality and management. Installers (and those handling order cancellations) can receive work order information in real time through the app, including detailed information such as customer address, broadband package, and installation time requirements, avoiding delays and errors associated with paper work order delivery. Simultaneously, the app serves as a communication tool, enabling remote communication between installers and backend reviewers, facilitating requests for assistance and order cancellation reviews. Reviewers can track the progress of each work order in real time through the backend system (computing device), understand the installers' work status, promptly identify problems, and coordinate and schedule operations to ensure the smooth progress of the entire installation process.

[0033] In this embodiment of the disclosure, reviewers can browse pending work orders through a second terminal device and choose to accept or reject them. If the reviewer chooses to accept the pending work order, the computing device can receive the acceptance instruction. For example, the reviewer can click on a pending work order displayed on the second terminal device. When the reviewer triggers the acceptance control, an acceptance instruction is generated and sent to the computing device.

[0034] S202. Display the review visualization interface. The review visualization interface shall include at least broadband network information based on satellite map display. The broadband network information shall include at least the location information of the person canceling the order, the broadband network coverage area (not covered / thin coverage area), and the location information of the work order to be reviewed. The broadband network information shall be used by the reviewer to determine whether to approve the work order to be reviewed.

[0035] In this embodiment of the disclosure, when the reviewer triggers the acceptance control, a review visualization interface can be displayed. For example, a computing device can display the review visualization interface through its built-in display device, or the computing device can display the review visualization interface through a second terminal device. The reviewer can browse the displayed review visualization interface to complete the review of the work order to be reviewed.

[0036] In some embodiments, the visual interface for review may include broadband network information displayed based on satellite maps. For example, based on high-resolution satellite map images and display layers, different icons or symbols may be used to display broadband network coverage cell information, broadband network coverage fiber distribution box information, location information of the person canceling the order, areas with no or thin broadband network coverage, and location information of the work order to be reviewed.

[0037] The location information of the person canceling the order can be displayed using a location icon to indicate their position on the satellite map. Areas with no or weak broadband network coverage can be displayed as closed polygons. The polygon icon indicates that the area covered by the polygon has no or weak broadband network coverage; broadband installations performed in these areas are likely to be canceled. The location information of pending work orders can also be displayed using a location icon to indicate the target installation location on the satellite map.

[0038] By utilizing broadband network information displayed on satellite maps, reviewers can clearly and intuitively determine the location of the person canceling the order and the location of the work order awaiting review. This allows them to determine whether the cancellation was genuine and prevents a fake work order from being initiated at location B while the person canceling the order is at location A. Furthermore, by comparing the location of the work order awaiting review with areas of broadband coverage (outside or with weak coverage), reviewers can clearly and intuitively determine whether the location is in an area with no or weak broadband coverage, thus deciding whether to approve the review.

[0039] In this embodiment of the disclosure, the broadband network information also includes broadband network coverage cell information and broadband network coverage fiber distribution box information. The review visualization interface also includes a remote video control, which is at least used to initiate a remote video request to the first terminal device of the person canceling the order when the reviewer triggers the remote video control.

[0040] In some embodiments, broadband network coverage cell information can also be displayed as a closed polygon graphic, such as covering the area within a cell that is actually covered by the broadband network. In this case, the polygon graphic can represent the actual broadband network coverage within the cell. Broadband network coverage cell information can be displayed in a color that distinguishes it from areas without broadband network coverage / thin coverage. Broadband network coverage fiber optic box information can be displayed through fiber optic box controls, such as displaying at least one fiber optic box control on a building in a cell, which can be used to indicate that the building in that cell provides broadband network service through that fiber optic box. Through broadband network coverage cell information and broadband network coverage fiber optic box information, auditors can gain a deeper understanding of the broadband network coverage around the location of the work order to be audited, thereby facilitating a more detailed and comprehensive assessment.

[0041] In some embodiments, the audit visualization interface may further include a remote video control. When the auditor triggers the remote video control, the computing device can send a remote video request to the first terminal device used by the person canceling the order. For example, a remote video request can be sent through an installation and maintenance app, and the person canceling the order can receive the remote video request through the installation and maintenance app, thereby allowing the auditor to have a remote video conversation with the person canceling the order.

[0042] Furthermore, auditors can remotely view the on-site installation status in real time via video, such as checking the customer's actual installation location and the coverage of buildings within the customer's building or area. Auditors can also use satellite map data to determine whether the broadband information displayed on the visual interface matches the actual broadband situation, thus facilitating the review of work orders. For example, auditors can use remote video to determine whether the real-time location on the map of the person canceling the order matches their actual location, whether the target installation location on the satellite map matches its actual location in the video, or whether the location of the fiber distribution box on the satellite map matches its actual location in the video, and so on.

[0043] According to embodiments of this disclosure, remote video allows auditors to directly view the environment of the person canceling the order (such as customer community signs, corridor lines, and the actual location of the fiber distribution box), thus preventing fraudulent cancellations and improving audit efficiency while shortening process time.

[0044] S203. Upon receiving the approval instruction for the pending work order, update the areas of broadband network coverage that are not covered or have thin coverage based on the location information of the pending work order.

[0045] In embodiments of this disclosure, the reviewer determines whether a work order to be reviewed passes or fails the review. In some embodiments, the reviewer can trigger an approval or rejection control. For example, the reviewer can click the approval control via a second terminal device. When the reviewer triggers the approval control, an approval instruction for the work order to be reviewed can be generated and sent to the computing device. The computing device can receive the approval instruction for the work order to be reviewed and update the broadband network coverage areas (uncovered / thin coverage areas).

[0046] It is understandable that when a work order pending review is approved, it indicates that the location of the work order is in an area with no or weak broadband network coverage. In this case, the location information of the work order pending review can be used to update the coverage area in real time, so as to achieve accurate recording and efficient reuse of data on areas with no or weak broadband network coverage.

[0047] In some cases, based on broadband network information displayed via remote video and satellite maps, it is possible to locate the nearest fiber distribution box and its internal optical splitter and other broadband coverage equipment in the customer's home, thus completing broadband line laying, equipment installation, and service activation. After the review is completed, the review results can be fed back to the person canceling the order, the customer, etc. When the reviewer triggers the review failure control, the review result can be directly fed back to the person canceling the order, the customer, etc. The review result can include information such as pass / fail and the reason for the review.

[0048] According to embodiments of this disclosure, when an auditor accepts a work order to be reviewed, a review visualization interface is displayed based on the work order acceptance instruction. Through the broadband network information displayed on the satellite map in the review visualization interface, the auditor can clearly determine whether the location of the work order to be reviewed is in an area without broadband network coverage / with thin coverage. If the review is approved, the computing device can update the broadband network coverage / thin coverage area data based on the location of the work order, thereby effectively recording the broadband network coverage / thin coverage area data and accurately reflecting the cancellation location.

[0049] Figure 3 The flowchart illustrates another broadband service cancellation processing method according to an embodiment of the present disclosure.

[0050] S301. Obtain broadband network coverage data, cancellation order data, and location information of the person canceling the order. Broadband network coverage data includes at least broadband network coverage cell information and broadband network coverage fiber distribution box information. Cancellation order data includes at least the location information of the cancellation order, the customer information of the cancellation order, and the fiber distribution box information of the cancellation order. The work order to be reviewed is a cancellation order.

[0051] In the embodiments of this disclosure, data such as broadband network coverage data, cancellation order data, and location information of cancellation personnel can be stored in the data warehouse of the computing device. The data warehouse can receive and return various data required such as broadband network coverage data, cancellation order data, cancellation review applications, result feedback, and no-coverage records via file interfaces and real-time interfaces. The data warehouse of the computing device can receive broadband network coverage data transmitted from the resource management system via a file transfer protocol (FTP) file interface, and receive cancellation order data and location information of cancellation personnel transmitted from the installation and maintenance APP via a real-time interface, while simultaneously returning the review results through the real-time interface.

[0052] In the embodiments of this disclosure, the data warehouse of the computing device can acquire broadband network coverage data at a certain time granularity. For example, broadband network coverage data can be acquired via an FTP file interface at an hourly time granularity, and the broadband network coverage data can be transmitted in two files: broadband network coverage cell information and broadband network coverage fiber distribution box information. The broadband network coverage cell information file includes at least the cell asset management ID, the city / county, the township / town, the street, the cell name, the latitude and longitude coordinates of the cell center, and the cell surface coordinates. This information describes the cell's geographical location, coverage area, boundary information, etc. The broadband network coverage fiber distribution box information file includes at least the fiber distribution box asset management ID, the city / county, the cell, and the latitude and longitude coordinates of the box center. This information describes the fiber distribution box's geographical location, coverage area, broadband data, etc.

[0053] In the embodiments of this disclosure, when the cancellation personnel initiate a cancellation review application through the installation and maintenance APP, the installation and maintenance APP can transmit the cancellation work order data corresponding to the cancellation to the data warehouse of the computing device through a real-time interface. The cancellation work order data may include at least the installation work order ID, broadband account, location information of the cancellation work order, customer information of the cancellation work order, and fiber distribution box information of the cancellation work order. The location information of the cancellation work order can be described by the city, district / county, community, and 11 levels of detailed installation address, such as XX City XX County XX District XX Street XX Community XX Building XX Unit XX Floor XX Room. The customer information of the cancellation work order may include the customer's contact information, etc. The fiber distribution box information of the cancellation work order may include the name of the coverage splitter, the name of the coverage fiber distribution box, and the latitude and longitude of the coverage fiber distribution box, etc.

[0054] In the embodiments of this disclosure, when a cancellation request is initiated by the person cancelling the order, the installation and maintenance APP can continuously send the real-time location latitude and longitude of the person cancelling the order to the data warehouse of the computing device through a real-time interface until the cancellation review receives feedback. By sending the location information of the person cancelling the order in real time, it is convenient for the reviewers to understand the location information of the person cancelling the order in real time.

[0055] S302. Construct a full broadband resource database based on broadband network coverage data, construct a broadband cancellation work order information database based on cancellation work order data and location information of cancellation personnel, and construct an uncovered resource storage database based on data information of broadband network uncovered / thin coverage areas. The data information includes at least location information and customer information of broadband network uncovered / thin coverage areas.

[0056] The embodiments disclosed herein employ an OpenLayers service architecture, dividing the data in the data warehouse into three modules for storage: a full broadband resource database, a broadband cancellation ticket information database, and an uncovered resource storage database. The full broadband resource database stores broadband network coverage data (including broadband network coverage cell information and broadband network coverage fiber distribution box information), and this module uses a Postgres database for storage management. The broadband cancellation ticket information database stores the location information of cancellation tickets transmitted by the installation and maintenance APP, the customer information of the cancellation ticket, the fiber distribution box information of the cancellation ticket, and the location information of the cancellation personnel. Based on the scale and real-time requirements of the broadband cancellation ticket information database, this module uses an Oracle database for storage management. The uncovered resource storage database is used to accurately store records of the thin, uncovered points or areas that led to cancellations; based on the scale and real-time requirements of the uncovered resource storage database, this module also uses an Oracle database for storage management.

[0057] In some embodiments, the uncovered resource storage database can use the following fields to store information about thin uncovered points / areas in a structured and accurate manner, as shown in Table 1.

[0058] Table 1. Uncovered resource storage database fields

[0059] In some embodiments, abnormal data identification rules can be set for non-standard, incomplete, redundant, or missing data in the collected data, and abnormal data can be automatically filtered and removed when the data is collected and stored.

[0060] According to embodiments of this disclosure, the computing device packages data at a certain time granularity via an FTP data interface and collects it into a data warehouse in file form. It then collects installation and maintenance work orders and real-time location latitude and longitude data of installation and maintenance work into the data warehouse via an HTTP real-time query interface. Through an internal real-time interface, data information from areas not covered or with thin broadband network coverage is exchanged, recorded, and stored in real time. Therefore, storing data in different databases not only adapts to the data nature but also reduces query complexity, improves access speed, facilitates maintenance and expansion, and reduces the impact of failures.

[0061] S303. Based on the full broadband resource database, broadband order cancellation information database, and uncovered resource storage database, set up broadband network coverage cell information icons, broadband network coverage fiber distribution box information icons, order cancellation personnel location information icons, broadband network uncovered / thin coverage area icons, and pending work order location information icons to construct broadband network information based on satellite map display.

[0062] In the embodiments disclosed herein, the OpenLayers service architecture can be adopted to support PC-based network applications. By employing the Kettle tool and GeoServer service, model services such as data query matching, real-time location layer rendering for broadband network coverage, cancellation personnel locations, and broadband work order target locations are implemented, improving data loading and rendering speed. High-resolution satellite maps from other manufacturers are introduced, and the core library for the map application is built using the OpenLayers service architecture according to the manufacturers' API interface specifications. Map instances are created using OpenLayers, and the initial view and scale are set. Model data from the full broadband resource database, broadband cancellation work order information database, and uncovered resource storage database in the data warehouse are converted into layer data and projected onto the map's projection coordinate system. The OpenLayers renderer is then used to render the layer data onto the map. Layer Style attributes are set. Personalized settings are provided for icons indicating broadband network coverage areas, fiber distribution boxes, locations of canceled orders, areas with no or thin broadband coverage, and locations of pending work orders. By setting the ZIndex property of the layers, the stacking order of the layers and the transparency of each layer can be controlled, ensuring that the layers remain visible even after being overlaid and switched. This enables the visualization and location of broadband network coverage areas, fiber distribution boxes, target installation locations, and locations in areas with thin or no coverage on high-definition satellite maps.

[0063] In some embodiments, a real-time location layer for cancellation personnel can also be constructed. Considering the accuracy of the battery level and latitude / longitude reporting of the installation and maintenance APP, the real-time location of cancellation personnel can be obtained at certain intervals. For example, the installation and maintenance APP can collect and report mobile phone latitude / longitude data to the broadband cancellation work order information database every 5 seconds (the interval can be adjusted as needed), and use a personalized icon layer to mark the real-time location of cancellation personnel. At the same time, the location layer is refreshed every 5 seconds (the interval can be adjusted as needed).

[0064] Figure 4 The flowchart illustrates another broadband service cancellation processing method according to an embodiment of the present disclosure.

[0065] S401. Receive cancellation order instruction. The cancellation order instruction is generated at least when the person canceling the order triggers the cancellation order control through the first terminal device.

[0066] Based on the real-time data interaction interface between the installation and maintenance APP and the order cancellation review system based on high-definition satellite maps, the installation and maintenance APP supports one-click triggering of the order cancellation review process. For example, the person canceling the order can click the order cancellation control on the installation and maintenance APP to send an order cancellation command to the computing device. The computing device can receive the order cancellation command. At the same time, throughout the entire order cancellation review process, the installation and maintenance APP can also continuously collect real-time data and upload it to the data warehouse.

[0067] S402. Based on the cancellation order instruction, the full broadband resource library, the broadband cancellation order information library, and the uncovered resource storage database, generate a pending work order. The pending work order includes at least location information and customer information. The instruction to accept the pending work order is generated at least when the reviewer triggers the acceptance control through the second terminal device.

[0068] Based on real-time received cancellation order instructions, the computing device can use the location information in the cancellation order to generate a work order awaiting review. For example, the location information can be matched against information in the full broadband resource database, the broadband cancellation order information database, and the under-coverage resource storage database. Specifically, it can match the fiber distribution box information corresponding to the location information from these databases and integrate this information into a work order awaiting review. The work order awaiting review can include key information such as the work order ID, the location where the cancellation order occurred, the customer address, the customer contact information, the reason for cancellation, the preliminary coverage matching, and the location of the installation and maintenance personnel. After generating the work order awaiting review, it can also be displayed on the reviewer's workbench (such as a computer system interface) for easy acceptance.

[0069] When an auditor clicks the acceptance control on a second terminal device, an acceptance order instruction for pending review can be generated and sent to the computing device. The computing device can then receive this acceptance order instruction.

[0070] Figure 5 The flowchart illustrates another broadband service cancellation processing method according to an embodiment of the present disclosure.

[0071] S501. Obtain click coordinate information. Click coordinate information is generated when the reviewer clicks the broadband network coverage cell information icon, the broadband network coverage fiber distribution box information icon, the location information icon of the person canceling the order, the broadband network uncovered / thin coverage area icon, or the location information icon of the work order to be reviewed.

[0072] In the embodiments of this disclosure, the auditor can browse the audit visualization interface through a second terminal device (such as a backend computer), and then click any icon on the audit visualization interface, such as clicking the fiber distribution box icon in a certain community. When the auditor triggers the icon, the computing device can obtain the coordinate information of the corresponding clicked location, such as the latitude and longitude of the location (e.g., 123.458°E, 45.672°N).

[0073] S502. Generate a broadband information query request. The broadband information query request shall include at least the click coordinate information.

[0074] Furthermore, the computing device can generate a broadband information query request based on the click coordinate information. This request can be used to retrieve broadband data corresponding to the click coordinate information from data stored in the full broadband resource database, broadband cancellation work order information database, and uncovered resource storage database. Examples include fiber distribution box IDs and coverage cell IDs. For instance, a click event listener can be added to the satellite map on the review visualization interface. Clicking the map layer icon will trigger this event listener. In the callback function of the event listener, the coordinates at the time of the click can be obtained. Then, based on these coordinates, a web map service (WMS) request can be constructed to retrieve relevant geospatial latitude and longitude data from the Geoserver service, including broadband network coverage cells, covered fiber distribution boxes, installation work order target installation locations, and thin-coverage / uncovered area locations.

[0075] S503. Obtain and display broadband network coverage data, cancellation order data, location information of the person canceling the order, and / or data information of the broadband network uncovered / thin coverage area from the full broadband resource database, broadband cancellation work order information database, and / or the uncovered resource storage database that match the click coordinate information.

[0076] Broadband network coverage data matching the click coordinates can refer to: if the clicked icon is a community icon, then the coordinates of that community, broadband coverage status (which buildings are covered), and the location of the fiber distribution boxes in each building. Cancellation order data could include historical cancellation information for that building, such as the time, reason for cancellation, specific location of the cancellation, and location information of the person making the cancellation. Broadband network coverage area (not covered / thin coverage area) can refer to whether the clicked location is within an area with no or thin broadband network coverage.

[0077] Furthermore, after obtaining relevant information, it can be presented to reviewers. For example, a details window can pop up on a satellite map, visually displaying information such as fiber distribution boxes, covered areas, and work order locations. The entire process can be completed by clicking icons. By sending broadband information query requests and matching corresponding broadband data, a drill-down function can be implemented to automatically match and extract model data such as corresponding broadband network covered areas, covered fiber distribution boxes, target installation locations for installation work orders, and locations in thin-coverage or uncovered areas based on clicked icons.

[0078] Figure 6 The flowchart illustrating the process of updating a broadband network with thin coverage areas based on the location information of a work order to be reviewed, according to an embodiment of the present disclosure, is shown in the diagram.

[0079] S601. Display the cancellation confirmation interface. The cancellation confirmation interface shall include at least an icon for areas not covered / thinly covered by broadband network, an icon for the location information of the work order to be reviewed, a selection area coordinate control, a selection point coordinate control, and a multiple cancellation mark coordinate control. Among them, the selection area coordinate control and the selection point coordinate control are used at least when the location information of the work order to be reviewed does not belong to an area not covered / thinly covered by broadband network; the multiple cancellation mark coordinate control is used at least when the location information of the work order to be reviewed belongs to an area not covered / thinly covered by broadband network.

[0080] Upon receiving the approval instruction for a pending work order, the system can redirect to the cancellation confirmation interface, or display it within the review visualization interface. This could be as a floating pop-up or as a toolbar within a bounding window. The cancellation confirmation interface is implemented by retrieving broadband thin-coverage data from the uncovered resource storage database, loading a thin-coverage layer based on a high-definition map, and simultaneously displaying controls for area coordinates, point coordinates, multiple cancellation marker coordinates, confirmation, and cancellation.

[0081] The order cancellation confirmation interface can include an icon for areas with no or thin broadband network coverage and an icon displaying the location information of the pending work order. By using these icons, reviewers can determine whether a currently approved pending work order is located within an area with no or thin broadband network coverage. For example, the icon might show that cell A is in an area with no or thin broadband network coverage, while the location information icon for the pending work order might indicate that the work order is not located within cell A. Reviewers can thus update the areas with no or thin broadband network coverage using different controls.

[0082] In the embodiments of this disclosure, the cancellation confirmation interface includes a surface coordinate control, a point coordinate control, and a multiple cancellation mark coordinate control. When an auditor clicks the surface coordinate control, point coordinate control, or multiple cancellation mark coordinate control, a drawing workbench is triggered. The workbench may include a polygon drawing tool or a point picking tool. For example, when an auditor clicks the surface coordinate control, the drawing workbench may include a polygon drawing tool, which can be used to draw closed polygons. The auditor can draw a broadband network coverage area with multiple clicks and describe the drawn broadband network coverage area information by integrating the coordinate information from multiple clicks. As another example, when an auditor clicks the point coordinate control or the multiple cancellation mark coordinate control, the drawing workbench may include a point picking tool, which can be used to pick the coordinate information of a specific point. The auditor can bind the coordinates of that point to a broadband network coverage area by clicking a single location.

[0083] In some embodiments, since the location corresponding to the approved work order is in a broadband network coverage area with thin or no coverage, after approval, it can be determined whether to add or update the broadband network coverage area based on the location of the broadband network coverage area and the work order. This can be achieved by using the aforementioned surface coordinate control, point coordinate control, and multiple cancellation marker coordinate control. When the location information of the work order to be approved does not belong to a broadband network coverage area, it indicates that the location corresponding to the currently approved work order is the area where the first cancellation occurred, and thus the corresponding location can be added to the broadband network coverage area. When the location information of the work order to be approved belongs to a broadband network coverage area, it indicates that the location corresponding to the currently approved work order is the area where a cancellation occurred previously, and thus the broadband coverage information of that location can be updated, for example, by incrementing the historical cancellation count of that location by 1.

[0084] In the embodiments of this disclosure, both the pick-up area coordinate control and the pick-up point coordinate control can be used to obtain the coordinate information of the area where the first cancellation occurred. The multiple cancellation mark coordinate control can be used for areas where historical cancellations have occurred. For example, after the reviewer clicks the multiple cancellation mark coordinate control, it triggers the display of the uncovered layer's highlight icon. The reviewer can move the uncovered layer to highlight the icon, and the layer of the broadband network thin uncovered area where the highlighted icon is located will be highlighted. According to the location of the work order to be reviewed, the reviewer can click the corresponding highlighted broadband network thin uncovered area. After the reviewer clicks, the computing device can update the broadband information of the highlighted broadband network thin uncovered area.

[0085] S602a. When the reviewer triggers the cancellation mark coordinate control multiple times, based on the location information of the work order to be reviewed, the broadband network uncovered / thin coverage area is matched in the never-covered resource storage database.

[0086] In the embodiments of this disclosure, when the reviewer determines that the location of the work order to be reviewed does not belong to an area with no or thin broadband network coverage, the multiple cancellation mark coordinate control on the cancellation confirmation interface can be triggered. By triggering the multiple cancellation mark coordinate control, areas with no or thin broadband network coverage near the location of the work order to be reviewed can be displayed based on a satellite map. For example, broadband coverage areas can be displayed using color A, and areas with no or thin broadband network coverage can be displayed using color B. The reviewer can click on any location within a certain area on the satellite map using a second terminal device, and the computing device can retrieve the corresponding area with no or thin broadband network coverage from the undercoverage resource storage database based on the coordinate information of that location.

[0087] For example, based on the location of the work order to be reviewed, the reviewer determines that it is near point A. The reviewer can then click on point A on the satellite map. Point A belongs to cell A, which is displayed in color B and is located in an area with no or weak broadband network coverage. When the reviewer clicks on point A, the computing device can match the broadband information of cell A in the uncovered resource storage database, such as the number of order cancellations, the reasons for cancellations, broadband coverage, and contact information of the canceling customers.

[0088] S603a. Based on the customer information of the work order to be reviewed, modify the number of cancellations and the contact information of the customers who cancelled the order in the data information of the broadband network in areas that are not covered / have thin coverage.

[0089] In the embodiments of this disclosure, after the reviewer determines that the location of the work order to be reviewed belongs to a broadband network coverage area (not covered / with thin coverage), the data information of the broadband network coverage area can be updated based on the data information of the work order to be reviewed. For example, based on the customer information of the work order to be reviewed, the customer information such as contact information and name of the canceled customer in the corresponding broadband network coverage area can be updated. Simultaneously, the cancellation count can also be updated, such as increasing the cancellation count by one. Furthermore, the corresponding cancellation reason, cancellation time, and other information can be stored for reuse in subsequent work.

[0090] In some embodiments, the latitude and longitude of the customer's location in the work order to be reviewed can be matched with the uncovered resource storage database to find the existing broadband network coverage / thin coverage area corresponding to the customer's location latitude and longitude. Then, the fields as shown in Table 1 are modified by incrementing the value of the "Number of Cancellations" field by 1, and the contact phone number of the canceling customer is simultaneously updated to the "Contact Phone Number of Cancelling Customer" field.

[0091] S602b: When the reviewer triggers the point coordinate control or the surface coordinate control, the location is determined on the satellite map based on the location information of the work order to be reviewed.

[0092] In the embodiments of this disclosure, if the reviewer determines that the location of the work order to be reviewed does not belong to a broadband network coverage area (not covered / thinly covered), the reviewer can trigger the pickup point coordinate control or pickup area coordinate control on the cancellation pickup confirmation interface. In some embodiments, the reviewer can determine whether the location of the work order to be reviewed belongs to a broadband network coverage area or a broadband network thin coverage area. A broadband network thin coverage area can be understood as: an area where the surrounding area has broadband coverage as a whole, but there are local single points without coverage. For example, unit 501 in building 3 of community A has no coverage (all other buildings in the community have coverage), or a shop has no coverage (the whole street has coverage). A broadband network coverage area can be understood as: an area without any broadband coverage equipment (fiber distribution box, optical distribution box), and no broadband network is planned in the whole area. For example: the entire area of ​​village B has no fiber distribution box, or the urban village area C has no fiber optic cable laid. By using the broadband network coverage / thin coverage area icons displayed on the satellite map, reviewers can determine whether the work order to be reviewed is located in a broadband network coverage area or a broadband network thin coverage area, and thus trigger the corresponding surface coordinate control or point coordinate control.

[0093] In the embodiments of this disclosure, if the pick-point coordinate control is triggered, the location of the customer's order cancellation corresponding to the work order to be reviewed can be located based on the satellite map. For example, when the reviewer clicks the pick-point coordinate control, the satellite map screen on the order cancellation confirmation interface can be positioned and displayed at the customer's order cancellation location corresponding to the work order to be reviewed. Based on this, the reviewer can click to select the corresponding satellite image building location and confirm. For example, the reviewer clicks on Building 3 of Community A in the satellite map screen and clicks the confirmation control.

[0094] In the embodiments of this disclosure, if the area coordinate picker control is triggered, the uncovered area or cell corresponding to the work order to be reviewed can be located based on the satellite map. For example, when the reviewer clicks the area coordinate picker control, the satellite map on the cancellation confirmation interface can be displayed to a certain area or cell corresponding to the work order to be reviewed. Based on this, the reviewer can click multiple times to draw a closed polygon. This polygon can be determined by the outer edge of the uncovered area or cell. For example, the reviewer can click multiple points sequentially based on the outer edge of cell A in the satellite map to form a closed polygon and then click the confirmation control.

[0095] S603b. Obtain location coordinates, which are generated when the reviewer clicks on the satellite map.

[0096] In the embodiments of this disclosure, after an auditor clicks on multiple points on a satellite map, the computing device can obtain the location coordinates corresponding to each point, such as latitude and longitude coordinates. When the point coordinate picker control is triggered, the location coordinates of a single point are obtained; when the surface coordinate picker control is triggered, the location coordinates of multiple points are obtained.

[0097] S604b: Store the location coordinates and customer information for the work orders to be reviewed in the uncovered resource storage database.

[0098] In the embodiments of this disclosure, the acquired location coordinates can be associated and stored with the customer information of the work order to be reviewed, combined to generate a new broadband network coverage data, and stored in the coverage resource storage database. Alternatively, the location coordinates and the customer information of the work order to be reviewed can be segmented and stored according to the fields described in Table 1 above, forming a new broadband network coverage data.

[0099] In some embodiments, according to the manufacturer's API interface specifications, a reverse geocoding service for high-resolution satellite maps can be introduced. The obtained location coordinates of the canceled customer are used as parameters to construct a Uniform Resource Locator (URL) for the reverse geocoding request. Standard address data corresponding to the canceled customer's location coordinates is then obtained through the reverse geocoding internet service. The standard address data is then decomposed based on the fields described in Table 1 above, and combined with data such as the customer's contact number, the latitude and longitude coordinates of the canceled customer's location, and the number of cancellations (=1), to generate a new broadband network coverage data entry. In some embodiments, when the area coordinate picker control is triggered, URLs for reverse geocoding requests can be constructed based on the location coordinates of multiple points, and standard address data corresponding to each point can be obtained separately.

[0100] Figure 7 A block diagram illustrating a computer program product according to an embodiment of the present disclosure is shown schematically. like Figure 7 As shown, a computer program product 700 according to an embodiment of this disclosure includes a computer program 701. When the computer program 701 is executed by a processor, it implements the broadband service cancellation processing method described above.

[0101] The above description, with reference to the accompanying drawings, illustrates a broadband service cancellation processing method and computer program product according to embodiments of this disclosure. By presenting the location information of the cancellation personnel, the broadband network coverage area (not covered / thin coverage area), and the location information of the work order to be reviewed in real time as a personalized layer, it facilitates the reviewers' intuitive and accurate review of the work orders. Furthermore, real-time imagery from remote video is used for positioning and verification, thereby achieving the location of the broadband network coverage area (not covered / thin coverage area) and the verification of the authenticity of the cancellation. Further, for the work orders to be reviewed that have passed the review, the coordinate information of the broadband network coverage area (not covered / thin coverage area) is picked up by displaying the pickup surface coordinate control, pickup point coordinate control, and multiple cancellation mark coordinates in the cancellation pickup confirmation interface. Standard address information is obtained using the coordinate information, and information such as the thin coverage point or area, latitude and longitude, number of cancellations, and associated broadband cancellation services are recorded and stored in the coverage resource storage database according to a unified field format. This not only improves the review efficiency and accuracy of the reviewers but also accurately records the broadband network coverage area (not covered / thin coverage area) for subsequent review.

[0102] The basic principles of this disclosure have been described above with reference to specific embodiments. However, it should be noted that the advantages, benefits, and effects mentioned in this disclosure are merely examples and not limitations, and should not be considered as essential features of each embodiment of this disclosure. Furthermore, the specific details disclosed above are for illustrative and facilitative purposes only, and are not limitations. These details do not limit the scope of this disclosure to the necessity of employing the aforementioned specific details for implementation.

[0103] The block diagrams of devices, apparatuses, devices, and systems disclosed herein are merely illustrative examples and are not intended to require or imply that they must be connected, arranged, or configured in the manner shown in the block diagrams. As those skilled in the art will recognize, these devices, apparatuses, devices, and systems can be connected, arranged, and configured in any manner. Words such as “comprising,” “including,” “having,” etc., are open-ended terms meaning “including but not limited to,” and are used interchangeably with them. The terms “or” and “and” as used herein refer to the terms “and / or,” and are used interchangeably with them unless the context clearly indicates otherwise. The term “such as” as used herein refers to the phrase “such as but not limited to,” and is used interchangeably with it.

[0104] Additionally, as used herein, the "or" used in a list of items beginning with "at least one" indicates a separate list, such that a list of, for example, "at least one of A, B, or C" means A or B or C, or AB or AC or BC, or ABC (i.e., A and B and C). Furthermore, the word "exemplary" does not imply that the described example is preferred or better than other examples.

[0105] It should also be noted that in the systems and methods of this disclosure, the components or steps can be decomposed and / or recombined. These decompositions and / or recombinations should be considered as equivalent solutions to this disclosure.

[0106] Various changes, substitutions, and modifications can be made to the technology described herein without departing from the teachings defined by the appended claims. Furthermore, the scope of the claims of this disclosure is not limited to the specific aspects of the processes, machines, manufactures, events, means, methods, and actions described above. Currently existing or later-developed processes, machines, manufactures, events, means, methods, or actions that perform substantially the same function or achieve substantially the same result as the corresponding aspects described above can be utilized. Therefore, the appended claims include such processes, machines, manufactures, events, means, methods, or actions within their scope.

[0107] The above description of the disclosed aspects is provided to enable any person skilled in the art to make or use this disclosure. Various modifications to these aspects will be readily apparent to those skilled in the art, and the general principles defined herein may be applied to other aspects without departing from the scope of this disclosure. Therefore, this disclosure is not intended to be limited to the aspects shown herein, but rather to be carried out within the widest scope consistent with the principles and novel features disclosed herein.

[0108] The above description has been given for purposes of illustration and description. Furthermore, this description is not intended to limit the embodiments of this disclosure to the forms disclosed herein. Although numerous exemplary aspects and embodiments have been discussed above, those skilled in the art will recognize certain variations, modifications, alterations, additions, and sub-combinations therein.

Claims

1. A method for processing broadband service cancellations, characterized in that, The method includes: Receive and accept work orders pending review instructions. Work orders pending review are determined at least based on cancellation work order instructions. The review visualization interface displays at least broadband network information based on a satellite map. This broadband network information includes at least the location information of the person canceling the order, areas with no or thin broadband coverage, and the location information of the work order awaiting review. This broadband network information is used by the reviewer to determine whether to approve the work order. Upon receiving an instruction to approve a pending work order, the broadband network coverage area (not covered / thinly covered) is updated based on the location information of the pending work order.

2. The broadband service cancellation processing method according to claim 1, characterized in that, The broadband network information also includes broadband network coverage cell information and broadband network coverage fiber distribution box information. The audit visualization interface also includes a remote video control. The remote video control is used at least to initiate a remote video request to the first terminal device of the person canceling the order when the auditer triggers the remote video control.

3. The broadband service cancellation processing method according to claim 2, characterized in that, Also includes: Acquire broadband network coverage data, order cancellation data, and the location information of the person canceling the order. The broadband network coverage data includes at least the broadband network coverage cell information and the broadband network coverage fiber distribution box information. The order cancellation data includes at least the location information of the order cancellation, the customer information of the order cancellation, and the fiber distribution box information of the order cancellation. The order pending review is one order cancellation. as well as A full broadband resource database is constructed based on the broadband network coverage data. A broadband cancellation work order information database is constructed based on the cancellation work order data and the location information of the cancellation personnel. An uncovered resource storage database is constructed based on the data information of broadband network uncovered / thin coverage areas. The data information includes at least the location information and customer information of broadband network uncovered / thin coverage areas.

4. The broadband service cancellation processing method according to claim 3, characterized in that, Also includes: Based on the full broadband resource database, the broadband order cancellation information database, and the uncovered resource storage database, icons for broadband network coverage cell information, broadband network coverage fiber distribution box information, location information of the person canceling the order, broadband network uncovered / thin coverage area icons, and location information of pending work orders are set to construct broadband network information based on satellite map display.

5. The broadband service cancellation processing method according to claim 3, characterized in that, Also includes: The cancellation order instruction is received, and the cancellation order instruction is generated at least when the person canceling the order triggers the cancellation order control through the first terminal device. as well as Based on the cancellation order instruction, the full broadband resource database, the broadband cancellation order information database, and the uncovered resource storage database, a pending review order is generated. The pending review order includes at least location information and customer information. The instruction to accept the pending review order is generated at least when the reviewer triggers the acceptance control through the second terminal device.

6. The broadband service cancellation processing method according to claim 4, characterized in that, Also includes: Get click coordinate information, which is generated when the reviewer clicks the broadband network coverage cell information icon, the broadband network coverage fiber distribution box information icon, the location information icon of the person canceling the order, the broadband network uncovered / thin coverage area icon, or the location information icon of the work order to be reviewed. Generate a broadband information query request, wherein the broadband information query request includes at least the click coordinate information; as well as From the full broadband resource database, the broadband cancellation work order information database, and / or the uncovered resource storage database, obtain and display broadband network coverage data, cancellation work order data, the location information of the person canceling the order, and / or data information of the broadband network uncovered / thin coverage areas that match the click coordinate information.

7. The broadband service cancellation processing method according to claim 4, characterized in that, Upon receiving an approval instruction for a pending work order, updating the broadband network's uncovered / thinly covered areas based on the location information of the pending work order includes: The cancellation confirmation interface includes at least the following: an icon for the broadband network's uncovered / thinly covered area, an icon for the location information of the work order to be reviewed, a selection area coordinate control, a selection point coordinate control, and a multiple cancellation mark coordinate control. The pick surface coordinate control and the pick point coordinate control are used at least when the location information of the work order to be reviewed does not belong to the broadband network's non-covered / thin coverage area; the multiple cancellation mark coordinate control is used at least when the location information of the work order to be reviewed belongs to the broadband network's non-covered / thin coverage area.

8. The broadband service cancellation processing method according to claim 7, characterized in that, Also includes: When the reviewer triggers the multiple cancellation marker coordinate control, the broadband network coverage / thin coverage area is matched from the uncovered resource storage database based on the location information of the work order to be reviewed; and Based on the customer information of the work orders pending review, modify the number of order cancellations and the contact information of the customers who cancelled orders in the data information of the broadband network's non-covered / thinly covered areas.

9. The broadband service cancellation processing method according to claim 7, characterized in that, Also includes: When the reviewer triggers the pick point coordinate control or the pick surface coordinate control, the location is determined on the satellite map based on the location information of the work order to be reviewed; Obtain location coordinates, which are generated when the reviewer clicks on the satellite map; as well as The location coordinates and the customer information of the work order to be reviewed are stored in the uncovered resource storage database.

10. A computer program product, comprising a computer program, characterized in that, When a computer program is executed by a processor, it implements the broadband service cancellation processing method as described in any one of claims 1 to 9.

Images