CN115706946A - Intelligent SIM card bill control method and system based on power service - Google Patents
Intelligent SIM card bill control method and system based on power service Download PDFInfo
- Publication number
- CN115706946A CN115706946A CN202110817645.4A CN202110817645A CN115706946A CN 115706946 A CN115706946 A CN 115706946A CN 202110817645 A CN202110817645 A CN 202110817645A CN 115706946 A CN115706946 A CN 115706946A
- Authority
- CN
- China
- Prior art keywords
- bill
- information
- sim card
- card
- list
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Abstract
The invention discloses an intelligent SIM card bill control method based on power business, which comprises the following steps: s1, acquiring initial bill information of an SIM card bound with the identity information of the power user from an internet communication interface of a telecom operator according to an identity authentication protocol of the power user, and importing the bill information into a business bill database; s2, the bill standard format generating module acquires bill information from the business bill database to obtain standard bill information in a unified format; s3, the bill checking module removes the abnormal information of the standard bill to obtain an effective information list of the SIM card; and S4, displaying the effective information list of the SIM card through a bill display module. Data formats are unified and abnormal information is eliminated through the steps of importing, accounting and exporting the bill data, checking efficiency of the SIM card bill is greatly improved, and satisfaction of a user is further improved.
Description
Technical Field
The invention relates to the technical field of power marketing, in particular to an intelligent SIM card bill control method and system based on power business.
Background
The terminal of the electric power service is provided with an SIM card which is used for identifying and authenticating the terminal of the electric power service, and can communicate with a remote management center to know the use information of the terminal of the electric power service. The construction and application of strong smart power grids and ubiquitous power internet of things are closely related to the management and control of the SIM card; the functions of remote meter reading, power quality monitoring, big data mining and utilization, metering abnormity analysis, remote power failure and recovery, power demand prediction and the like are realized by depending on the information exchange function of the SIM card.
Currently, the SIM cards in use are all provided by three operators (mobile, unicom and telecom), various lists and bills are also provided by the operators, and SIM card bills cannot be directly obtained inside a company system; the electric power department lacks the quick and powerful checking means, three operators do not belong to each other and are responsible for each other, and bills provided by the operators are eight-sidedly, so that the financial staff are difficult to input, compare and screen various bills.
At present, the checking and counting of the SIM card bill of the power system for the power service face the following difficulties:
(1) The operation time for changing the state of the SIM card by the operator is long: to complete the change of the state of the SIM card, an application needs to be proposed to an operator in advance, and then the operation can be completed only by approval of an operator layer, so that the whole process consumes long time and the accuracy of providing the list content cannot be ensured;
(2) The abnormal SIM card is slow in query feedback: after receiving the inquiry application of the abnormal SIM card information of the power department, an operator needs to examine and approve the abnormal SIM card information layer by layer through the operator, so that the operator can feed back a list, and the time for acquiring the abnormal SIM card list is longer;
(3) The bill checking time consumption is as follows: there are three steps to finish the bill check, first, check all kinds of SIM card bills; secondly, checking whether SIM cards which should be sold but are not sold exist in the bill; checking whether a continuous multi-month zero-flow SIM card exists in a bill or not; finally, providing the repeated charging card, the zero-flow card meeting the conditions and the list of the sales card to an operator; due to the large bill quantity and the long feedback time, the SIM card bill checking difficulty is high, and the time span is long.
The current marketing system only has the asset management function of the SIM card, important information such as card opening time, card selling time, package category, tariff details and the like of the SIM card cannot be directly imported into the marketing system, and the marketing system cannot utilize a computer algorithm to screen SIM card big data, not to mention the inquiry and the export of abnormal SIM card information.
Disclosure of Invention
The invention aims to solve the problem of low checking efficiency of an SIM card bill of an electric power service, and provides an SIM card bill intelligent control method and system based on the electric power service.
In order to achieve the technical purpose, the invention provides a technical scheme that an intelligent SIM card bill control method based on electric power service comprises the following steps:
s1, acquiring initial bill information of an SIM card bound with identity information of an electric power user from an internet communication interface of a telecommunication operator according to an identity authentication protocol of the electric power user, and importing the bill information into a business bill database;
s2, a bill standard format generating module acquires bill information from a business bill database to obtain standard bill information in a unified format;
s3, the bill checking module removes the abnormal information of the standard bill to obtain an effective information list of the SIM card;
and S4, displaying the effective information list of the SIM card through a bill display module.
In the scheme, the data formats are unified and abnormal information is eliminated through the steps of importing, accounting and exporting account form data, so that the checking efficiency of the SIM card bill is greatly improved.
Preferably, the source of the initial billing information comprises a telecommunication SIM card bill, a mobile SIM card bill and a Unicom SIM card bill in different billing formats; because the initial formats of the telecom SIM card bill, the mobile SIM card bill and the Unicom SIM card bill are not unified, the SIM card bill intelligent management and control system needs to unify the initial formats of the SIM card bills after acquiring the information, and the reading of bill data is facilitated.
Preferably, the format of the standard billing information includes data information: the method comprises the following steps of (1) unifying flow unit as MB, operator name, card number, package cost, actual cost, application type, card starting time, standard flow, actual flow and card state information; in the definition state type, "0" is off, "1" is in use, "2" is in stock of new cards, "1" is low voltage collection, "2" is high voltage special change, "3" is public change assessment, "4" is on-line monitoring, "5" is PDA, "6" is fault report repair, "7" is video monitoring.
Preferably, the bill checking module for removing the abnormal information of the standard bill comprises the following steps:
SIM card information of the repeated charging card is removed through a duplicate checking mechanism; in order to avoid that the repeatedly charged SIM card information is repeatedly imported into an SIM card bill intelligent control system, a bill is automatically checked and duplicated in the importing operation process (the specific mode is to check and duplicate the unique card number information of the SIM card, and ensure that the information of each card is only read once), if the repeated SIM card information appears, the specific repeated card information can be prompted, and the repeated cards are removed;
the SIM card monthly bills are compared month by month to obtain an actual card selling list;
comparing the actual card selling list with the card selling application information to obtain a list of the cards which should be sold but are not sold;
exporting a multi-month zero-flow card list, and screening out an SIM card list with actual flow being zero for 6 months or more continuously according to the monthly actual flow data of each SIM card;
screening non-abnormal information in the monthly zero flow card list information through a white list module; the screened non-abnormal card information is used as normal card information to be led into the effective information list of the SIM card again;
and sending the list of the un-sold cards to be sold and the list of the screened monthly zero-traffic cards to a telecom operator for SIM card logout operation.
Preferably, the white list module is used for screening non-abnormal information in the list information of the monthly zero flow card, wherein the non-abnormal information comprises the following conditions:
the first situation is as follows: a mobile operation terminal which is not started by card holding;
case two: the success rate of information acquisition of the SIM card caused by the fault inspection equipment is reduced;
case three: the terminal equipment of the dual-power customer is just switched to the other power supply metering device in the same month;
case four: a suspended client in the marketing operation state, wherein the user just resumes power utilization in the current month of card stopping;
in order to avoid misoperation during SIM removal, the conditions from the first condition to the fourth condition are used as a screening mechanism and added into a white list module for screening non-abnormal information in the monthly zero-flow card list information.
In the scheme, before the exported monthly zero-flow card list is submitted to an operator for shutdown processing, customer complaints are caused because some non-abnormal conditions in the monthly zero-flow card list are not considered, the using satisfaction of customers is reduced, the non-abnormal conditions are taken as the basis for auxiliary discrimination according to the customer telephone complaint feedback, and the non-abnormal conditions are divided into four conditions; in the first situation, the acquisition success rate is reduced due to the fact that an SIM card is stopped; through investigation and analysis, most of SIM cards which are found to alarm come from mobile operation terminals which are not started by the card holding; in the second situation, the success rate of information acquisition of the SIM card caused by the fault of the fault inspection equipment is reduced; the situation three is that the terminal equipment of the dual-power customer is just switched to another power supply metering device in the same month; the fourth situation is that from the suspended client in the marketing running state, the user just resumes the power utilization in the current month of card stopping; in order to prevent the misoperation from happening again, a white bill module is added in the SIM card bill intelligent management and control system and used for assisting the bill checking module to screen non-abnormal information in the monthly flow card list information.
An SIM card bill intelligent management and control system based on electric power service comprises: the system comprises a PC and an internet communication interface connected with a service layer of a telecom operator, wherein the PC imports an SIM (subscriber identity module) consumption data bill of a power user into a service bill database through the internet communication interface, and a bill standard format generating module, a bill checking module and a bill display module are further arranged at the PC end; the bill standard format generating module is used for standardizing bill information acquired from different telecom operators into a uniform format; the bill checking module is used for eliminating abnormal information in the account information of the SIM card, generating a list of the cards which are not sold and should be sold and a list of the screened monthly zero-flow cards, and sending the list of the cards to a telecom operator for SIM card logout operation;
and the bill display module is used for displaying the effective information list information of the SIM card.
Preferably, the system further comprises a white list module which is coordinated with the bill checking module and is used for screening the non-abnormal information in the monthly zero-flow card list generated in the bill checking module.
Preferably, the white list module discriminates the non-abnormal information in the monthly zero-traffic card list according to the following conditions:
the first situation is as follows: a mobile operation terminal which is not started to hold the card;
the second situation: production fault inspection equipment;
case three: the terminal equipment of the dual-power customer is just switched to the other power supply metering device in the same month;
case four: and (4) a suspended client of the marketing running state, wherein the user just recovers the power utilization in the current month of card stopping.
The invention has the beneficial effects that: the SIM card bill intelligent control method and system based on the electric power service unify the whole SIM card process control, ensure the consistency of SIM card bills and real objects, strengthen the SIM card control of asset management personnel and financial personnel, greatly reduce the phenomenon of SIM card stockpiling in power supply, optimize inventory configuration and reduce the burden of management personnel in each link. The method has the advantages of realizing data sharing, promoting service fusion, providing comprehensive support for services of all links managed by the SIM card, realizing the communication of processes and data of links such as production, marketing and the like, practically realizing accurate analysis of abnormal conditions, innovating a new mode of power marketing management, making positive contributions to objective measurement of enterprise operation development performance and promotion of lean management level, and becoming a new engine for quality improvement and efficiency improvement of power supply enterprises.
Drawings
Fig. 1 is a flowchart of an intelligent SIM card bill management and control method based on power services according to the present invention.
Detailed Description
For the purpose of better understanding the objects, technical solutions and advantages of the present invention, the following detailed description of the present invention with reference to the accompanying drawings and examples should be understood that the specific embodiment described herein is only a preferred embodiment of the present invention, and is only used for explaining the present invention, and not for limiting the scope of the present invention, and all other embodiments obtained by a person of ordinary skill in the art without making creative efforts shall fall within the scope of the present invention.
The embodiment is as follows: as shown in fig. 1, a flowchart of an intelligent SIM card bill management and control method based on power services includes the following steps:
s1, acquiring initial bill information of an SIM card bound with the identity information of the power user from an internet communication interface of a telecom operator according to an identity authentication protocol of the power user, and importing the bill information into a business bill database;
s2, the bill standard format generating module acquires bill information from the business bill database to obtain standard bill information in a unified format;
s2, the bill checking module eliminates the abnormal information of the standard bill to obtain an effective information list of the SIM card;
and S4, displaying the effective information list of the SIM card through a bill display module.
The sources of the initial bill information include telecommunication SIM card bills of different bill formats, mobile SIM card bills, and universal SIM card bills.
As shown in table 1, the format of the standard billing information includes data information: the method comprises the following steps of (1) unifying flow unit as MB, operator name, card number, package cost, actual cost, application type, card starting time, standard flow, actual flow and card state information; defining that 0 is used off, 1 is used in use, 2 is a new card stock in the state types, 1 is low-voltage acquisition, 2 is high-voltage special transformer, 3 is common transformer check, 4 is on-line monitoring, 5 is PDA, 6 is fault report and repair, and 7 is video monitoring in the application types;
TABLE 1 Standard Bill information
The bill checking module for eliminating the abnormal information of the standard bill comprises the following steps:
SIM card information of the repeated charging card is removed through a duplicate checking mechanism;
the SIM card monthly bills are compared month by month to obtain an actual card selling list;
comparing the actual card selling list with the card selling application information to obtain a list of the cards which should be sold but are not sold;
exporting a monthly zero flow card list, and screening out SIM cards with actual flow being zero for 6 months or more continuously according to monthly actual flow data of each SIM card;
screening non-abnormal information in the monthly zero flow card list information through a white list module; the screened non-abnormal card information is imported into an effective information list of the SIM card as normal card information again;
and sending the list of the un-sold cards to be sold and the list of the screened monthly zero-traffic cards to a telecom operator for SIM card logout operation.
Screening non-abnormal information in the list information of the monthly zero flow card through a white list module, wherein the non-abnormal information comprises the following conditions:
the first situation is as follows: a mobile operation terminal which is not started by card holding;
case two: production fault inspection equipment;
case three: the terminal equipment of the dual-power customer is just switched to the other power supply metering device in the same month;
case four: and (4) marketing the suspended client in the running state, wherein the client just recovers the power utilization in the current month of card stopping.
In the embodiment, the exported monthly zero-flow card list is submitted to an operator for shutdown processing, customer complaints are caused due to the fact that some non-abnormal conditions in the monthly zero-flow card list are not considered, the using satisfaction of customers is reduced, the non-abnormal conditions are used as the basis for auxiliary screening according to the customer telephone complaint feedback, and the non-abnormal conditions are divided into four conditions; in the first situation, the acquisition success rate is reduced due to the fact that an SIM card is stopped; through investigation and analysis, most of SIM cards which are found to alarm come from mobile operation terminals which are not started by the card holding; in the second situation, the success rate of information acquisition of the SIM card caused by the fault of the fault patrol equipment is reduced; the situation three is that the terminal equipment of the dual-power customer is just switched to another power supply metering device in the same month; the fourth situation is that from the suspended client in the marketing running state, the user just resumes the power utilization in the current month of card stopping; in order to prevent the misoperation from happening again, a white bill module is added in the SIM card bill intelligent management and control system and used for assisting the bill checking module to screen non-abnormal information in the monthly flow card list information.
An intelligent SIM card bill management and control system based on power services comprises: the system comprises a PC and an internet communication interface connected with a service layer of a telecom operator, wherein the PC imports an SIM (subscriber identity module) consumption data bill of a power user into a service bill database through the internet communication interface, and a bill standard format generating module, a bill checking module, a bill display module and a white list module which performs coordination with the bill checking module are further arranged at the PC;
the bill standard format generating module is used for standardizing bill information acquired from different telecom operators into a uniform format;
the bill checking module is used for eliminating abnormal information in the account information of the SIM card, generating a list of the cards which are not sold in due sale and a list of the monthly zero-flow cards after being discriminated, and sending the list of the monthly zero-flow cards to a telecom operator for SIM card logout operation;
the bill display module is used for displaying effective information list information of the SIM card;
and the white list module is used for screening non-abnormal information in the multi-month zero-flow card list generated in the bill checking module.
The white list module is used for screening the following conditions according to the non-abnormal information in the monthly zero-flow card list:
the first situation is as follows: a mobile operation terminal which is not started to hold the card;
case two: production fault inspection equipment;
a third situation: the terminal equipment of the dual-power customer is just switched to the other power supply metering device in the current month;
situation four: and (4) marketing the suspended client in the running state, wherein the client just recovers the power utilization in the current month of card stopping.
By the method and the system for intelligently managing and controlling the SIM card bill based on the power service, the bill data of the SIM card of the power service in Jinhua area of Zhejiang are checked, 10296 abnormal SIM cards are checked out from 8 months to 11 months in 2019, and a fund 30004.2 yuan is recovered, as shown in Table 2, the bill data checking result of the SIM card is as follows:
TABLE 2 SIM card Bill data examination results
The above-mentioned embodiments are preferred embodiments of the SIM card bill intelligent management and control method and system based on power services, and the scope of the present invention is not limited thereto, and all equivalent changes made according to the shape and structure of the present invention are within the protection scope of the present invention.
Claims (8)
1. An intelligent SIM card bill management and control method based on power services is characterized in that: the method comprises the following steps:
s1, acquiring initial bill information of an SIM card bound with identity information of an electric power user from an internet communication interface of a telecommunication operator according to an identity authentication protocol of the electric power user, and importing the bill information into a business bill database;
s2, the bill standard format generating module acquires bill information from the business bill database to obtain standard bill information in a unified format;
s3, the bill checking module removes the abnormal information of the standard bill to obtain an effective information list of the SIM card;
and S4, displaying the effective information list of the SIM card through a bill display module.
2. The method for intelligently managing and controlling the SIM card bill based on the electric power service as claimed in claim 1, wherein:
the sources of the initial billing information include telecom SIM card bills, mobile SIM card bills, and unicom SIM card bills in different billing formats.
3. The method for intelligently managing and controlling the SIM card bill based on the electric power service according to claim 3, wherein:
the format of the standard bill information comprises the following data information: the method comprises the following steps of (1) unifying flow unit as MB, operator name, card number, package cost, actual cost, application type, card starting time, standard flow, actual flow and card state information; in the definition state type, "0" is off, "1" is in use, "2" is in stock of new cards, "1" is low voltage collection, "2" is high voltage special change, "3" is public change assessment, "4" is on-line monitoring, "5" is PDA, "6" is fault report repair, "7" is video monitoring.
4. The intelligent management and control method for the SIM card bill based on the electric power service as claimed in claim 1, 2 or 3, wherein: the bill checking module for eliminating the abnormal information of the standard bill comprises the following steps:
SIM card information of repeated charging cards is eliminated through a duplicate checking mechanism;
the SIM card monthly bills are compared month by month to obtain an actual card selling list;
comparing the actual card sales list with the card sales application information to obtain a list of cards which should be sold but are not sold;
exporting a monthly zero flow card list, and screening out SIM cards with actual flow being zero for 6 months or more continuously according to monthly actual flow data of each SIM card;
screening non-abnormal information in the monthly zero flow card list information through a white list module; the screened non-abnormal card information is used as normal card information to be led into the effective information list of the SIM card again;
and sending the list of the un-sold cards to be sold and the list of the screened monthly zero-traffic cards to a telecom operator for SIM card logout operation.
5. The intelligent management and control method for the SIM card bill based on the electric power service as claimed in claim 4, wherein: screening non-abnormal information in the monthly zero flow card list information through a white list module, comprising the following steps of:
the first situation is as follows: a mobile operation terminal which is not started to hold the card;
the second situation: the success rate of information acquisition of the SIM card caused by the fault inspection equipment is reduced;
a third situation: the terminal equipment of the dual-power customer is just switched to the other power supply metering device in the same month;
case four: a suspended client in the marketing operation state, wherein the user just resumes power utilization in the current month of card stopping;
in order to avoid misoperation during SIM removal, the conditions from the first condition to the fourth condition are used as a screening mechanism and added into a white list module for screening non-abnormal information in the monthly traffic card list information.
6. The utility model provides a SIM card bill intelligence management and control system based on electric power business which characterized in that: comprises the following steps: the system comprises a PC and an internet communication interface connected with a service layer of a telecom operator, wherein the PC imports an SIM consumption data bill of a power user into a service bill database through the internet communication interface, and a bill standard format generation module, a bill checking module and a bill display module are further arranged at the PC end;
the bill standard format generating module is used for standardizing bill information acquired from different telecom operators into a uniform format;
the bill checking module is used for eliminating abnormal information in the account information of the SIM card, generating a list of the cards which are not sold and should be sold and a list of the screened monthly zero-flow cards, and sending the list of the cards to a telecom operator for SIM card logout operation;
and the bill display module is used for displaying the effective information list information of the SIM card.
7. The system according to claim 6, wherein the system comprises: the system also comprises a white list module which is coordinated with the bill checking module and is used for screening the non-abnormal information in the monthly zero-flow card list generated in the bill checking module.
8. The system according to claim 7, wherein the system comprises: the white list module is used for screening the following conditions according to the non-abnormal information in the monthly zero flow card list:
the first situation is as follows: a mobile operation terminal which is not started to hold the card;
case two: production fault inspection equipment;
a third situation: the terminal equipment of the dual-power customer is just switched to the other power supply metering device in the same month;
case four: and (4) a suspended client of the marketing running state, wherein the user just recovers the power utilization in the current month of card stopping.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110817645.4A CN115706946A (en) | 2021-07-20 | 2021-07-20 | Intelligent SIM card bill control method and system based on power service |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110817645.4A CN115706946A (en) | 2021-07-20 | 2021-07-20 | Intelligent SIM card bill control method and system based on power service |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115706946A true CN115706946A (en) | 2023-02-17 |
Family
ID=85178374
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110817645.4A Pending CN115706946A (en) | 2021-07-20 | 2021-07-20 | Intelligent SIM card bill control method and system based on power service |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115706946A (en) |
-
2021
- 2021-07-20 CN CN202110817645.4A patent/CN115706946A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109800250B (en) | System architecture for no longer configuring enterprise central server | |
| CN114257636A (en) | Unified message publishing system | |
| CN112767005A (en) | Member reasonable distribution rights and interests management system based on database | |
| CN202632430U (en) | Electric power self-service system | |
| CN112150164A (en) | Customer service communication management system | |
| CN113435721A (en) | Method for constructing secondary data center of intelligent substation | |
| CN115706946A (en) | Intelligent SIM card bill control method and system based on power service | |
| CN115016902B (en) | Industrial flow digital management system and method | |
| CN112149977A (en) | Post-loan risk monitoring and early warning method and system, computer equipment and storage medium | |
| CN203689621U (en) | Intelligent community self-service toll collection system | |
| CN115859377A (en) | Block chain carbon neutralization and evidence storage system | |
| CN110223132A (en) | Order processing method, apparatus, terminal and storage medium based on more authorization roles | |
| CN115762010A (en) | Novel filling station's wisdom supervision service platform | |
| CN115330404A (en) | System and method for electric power marketing inspection | |
| CN112215560A (en) | Intelligent shift arrangement system and implementation method thereof | |
| CN115471244A (en) | Data interaction method and device for multi-power-selling system and multi-transaction center | |
| CN117560154A (en) | Electric energy meter monitoring method, system, storage medium and terminal based on multipoint mutual trust | |
| CN112633663A (en) | Electricity charge meter reading accounting analysis system based on big data platform | |
| CN112396426A (en) | Cross-bank payment limit monitoring method, system and computer storage medium | |
| CN117541277A (en) | Intelligent electric power marketing platform | |
| CN112649664A (en) | Power consumption collection device and system | |
| CN116523614A (en) | Bank reconciliation method, equipment and medium based on RPA robot | |
| Luo et al. | Research on Power Market Data Asset Management Framework | |
| Lin et al. | Design and Application of Customer Services Business Middle Platform for Opening Service Capabilities of Electric Power Marketing | |
| CN112785356A (en) | Data checking method and system for improving financial electronic bill making success rate |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |