Business expansion work order processing method, system and device based on RPA technology and medium

Abstract

The embodiment of the invention discloses a business expansion work order processing method, system and device based on an RPA technology and a medium, and the method comprises the steps: screening the power transmission time in a power transmission time data column, and automatically storing a second business expansion work order with the power transmission time being empty as a business expansion work order detail list without conditions; therefore, the business expansion work orders without conditional archiving are automatically screened, and the influence of the business expansion work orders on subsequent operation is avoided. The method comprises the steps that when an operation instruction of a user is received, a business expansion work order query interface in a marketing management system configured based on the RPA technology is displayed; when a query instruction is received, querying and displaying a first business expansion work order meeting a query condition; when an instruction of selecting an export control is received, exporting the first business expansion work order to form a business expansion archiving work order business table; processing the business expansion archiving work order business table; and forming the second business expansion work order with empty power transmission time in the power transmission time data column into a business expansion work order detail table without conditional archiving.

Description

Technical Field

[0001] The present application relates to the technical field of work order processing, and in particular to a method, system, device and medium for processing business expansion work orders based on RPA technology. Background Art

[0002] The full name of the business expansion work order is business expansion work order, which involves the process management of power users applying for new installation, capacity increase or change in electricity demand.

[0003] In related technologies, business expansion work orders are archived, but the archived business expansion work orders often have problems, and the problematic business expansion work orders may be processed accordingly later, resulting in data processing errors.

[0004] Therefore, how to determine whether there is a problem with the archived business expansion work order has become a technical problem that needs to be solved urgently by technical personnel in this field. Summary of the Invention

[0005] The present application provides a business expansion work order processing method, system, equipment and medium based on RPA technology. In this method, the power supply time in the power supply time data column is filtered, and the second business expansion work order with an empty power supply time is automatically stored as a detailed list of business expansion work orders that do not meet the conditions for archiving. In this way, the business expansion work orders that do not meet the conditions for archiving are automatically filtered to avoid affecting subsequent operations.

[0006] First, a method for processing business expansion work orders based on RPA technology is provided, including:

[0007] When receiving the user's operation instruction, the business expansion work order query interface in the marketing management system configured based on RPA technology is displayed;

[0008] On the business expansion work order query interface, when a query instruction sent by a user is received, a first business expansion work order that meets the query conditions is searched and displayed, and an export control is also displayed on the interface displaying the first business expansion work order, wherein the query conditions include an archiving time range;

[0009] When receiving an instruction from the user to select the export control, exporting the first business expansion work order to form a business expansion archive work order business table;

[0010] Processing the business expansion archived work order business table so that the processed business expansion archived work order business table includes a second business expansion work order, wherein the second business expansion work order includes a preset data column, wherein the preset data column includes a power supply time data column;

[0011] The second business expansion work order with a blank power supply time in the power supply time data column is used to form a detailed list of business expansion work orders that do not meet the conditions for archiving.

[0012] In some embodiments, the method further comprises:

[0013] In the detailed list of work orders that do not meet the conditions for archiving, add a data column for archiving type and a data column for initial verification;

[0014] The filing type data column is filled with the filing type, and the preliminary check determination data column is filled with the preliminary check determination result, wherein the preliminary check determination result is determined according to the filing type.

[0015] In some embodiments, the preset data column further includes a formal acceptance date data column; the method further includes:

[0016] The second business expansion work orders whose power supply time is not empty in the power supply time data column are used to form a detailed list of archived business expansion work orders;

[0017] In the detailed list of archived business expansion work orders, add a data column on the duration of the fire connection;

[0018] According to the second business expansion work order in the archived business expansion work order details table, the power supply time in the power supply time data column and the formal acceptance time in the formal acceptance date data column, the fire connection time is calculated and the fire connection time is filled in the fire connection time data column.

[0019] In some embodiments, the preset data column further includes a user ID data column; and the method further includes:

[0020] Get the preset user ID;

[0021] Determine whether there is an abnormality in the second business work order corresponding to the user number that is the same as the preset user number in the user number data column;

[0022] If there is an exception, the second business work order with the exception will be sent to the auditor's end.

[0023] In some embodiments, before the step of determining whether there is an abnormality in the second service work order corresponding to the user number in the user number data column that is the same as the preset user number, the method further includes:

[0024] Obtain the total forward active power, data time and comprehensive rate corresponding to the preset user number;

[0025] The electric quantity is determined by utilizing the total forward active power and the comprehensive rate.

[0026] In some embodiments, the step of determining whether there is an abnormality in the second business work order corresponding to the user number in the user number data column that is the same as the preset user number includes:

[0027] Determine whether any preset abnormal condition in the preset abnormal condition set is met;

[0028] If any one of the preset abnormal conditions is met, it is determined that the second business expansion work order is abnormal;

[0029] If all preset abnormal conditions are not met, it is determined that there is no abnormality in the second business expansion work order.

[0030] In some embodiments, the preset data columns further include a business subcategory data column, an electricity usage category data column, a formal acceptance date data column, and a filing date data column;

[0031] The preset abnormal conditions in the preset abnormal condition set include that the difference between the data time and the power transmission time in the power transmission time data column is within a first preset difference range and the power quantity is greater than a first preset power quantity;

[0032] The difference between the data time and the power supply time is within a second preset difference range, and the amount of electricity consumed for residential use in the electricity consumption category data column is greater than a second preset amount of electricity consumed;

[0033] The difference between the data time and the power transmission time is within a second preset difference range, and the amount of electricity consumed for non-residential use in the electricity consumption category data column is greater than a third preset amount of electricity;

[0034] The difference between the data time and the power supply time is within a third preset difference range, and the amount of electricity consumed by the electricity consumption category of residential life in the electricity consumption category data column is greater than a fourth preset amount of electricity;

[0035] The difference between the data time and the power transmission time is within a third preset difference range, and the amount of electricity consumed for non-residential use in the electricity consumption category data column is greater than a fifth preset amount of electricity consumed;

[0036] The difference between the power supply time and the formal acceptance date in the formal acceptance date data column is within a fourth preset difference range, the difference between the filing date in the filing date data column and the formal acceptance date is within a fifth preset difference range, and the power amount is greater than a sixth preset power amount;

[0037] The difference between the filing date and the power supply time is within a sixth preset difference range, and the power quantity is greater than a seventh preset power quantity;

[0038] The business subcategory in the business subcategory data column is a new customer, and the power amount is greater than an eighth preset power amount.

[0039] Secondly, a business expansion work order processing system based on RPA technology is provided, including:

[0040] A display unit is configured to display a business expansion work order query interface in the marketing management system configured based on RPA technology when receiving a user's operation instruction;

[0041] a query unit configured to query and display, on the business expansion work order query interface, a first business expansion work order that meets the query criteria upon receiving a query instruction sent by a user, and further display an export control on the interface displaying the first business expansion work order, wherein the query criteria include an archiving time range;

[0042] An export unit, configured to export the first business expansion work order to form a business expansion archive work order business table when receiving an instruction from a user to select the export control;

[0043] a processing unit, configured to process the business expansion archived work order business table so that the processed business expansion archived work order business table includes a second business expansion work order, wherein the second business expansion work order includes a preset data column, wherein the preset data column includes a power supply time data column;

[0044] A forming unit is used to form a detailed list of business expansion work orders that do not meet the conditions for archiving for the second business expansion work order with a blank power supply time in the power supply time data column.

[0045] According to a third aspect, an electronic device is provided, comprising: at least one processor; and a memory communicatively connected to the at least one processor;

[0046] The memory stores instructions that can be executed by the at least one processor, and the instructions are configured to execute the above method.

[0047] According to a fourth aspect, a computer-readable storage medium is provided, storing computer-executable instructions for executing the method.

[0048] In the above-mentioned embodiment, a business expansion work order processing method, system, equipment and medium based on RPA technology are provided. In this method, the power supply time in the power supply time data column is filtered, and the second business expansion work order with a blank power supply time is automatically stored as a detailed list of business expansion work orders that do not meet the conditions for archiving. In this way, the business expansion work orders that do not meet the conditions for archiving are automatically filtered to avoid affecting subsequent operations. BRIEF DESCRIPTION OF THE DRAWINGS

[0049] Figure 1 A flowchart of a method for processing business expansion work orders based on RPA technology is exemplarily shown according to some embodiments;

[0050] Figure 2 An exemplary diagram of an interface of a marketing management system provided according to some embodiments is shown;

[0051] Figure 3 A structural diagram of a business expansion work order processing system based on RPA technology is exemplarily shown according to some embodiments. DETAILED DESCRIPTION

[0052] In order to make the purpose and implementation of this application clearer, the exemplary implementation of this application will be clearly and completely described below in conjunction with the drawings in the exemplary embodiments of this application. Obviously, the described exemplary embodiments are only part of the embodiments of this application, not all of the embodiments.

[0053] It should be noted that the brief descriptions of terms in this application are only for the purpose of facilitating the understanding of the embodiments described below, and are not intended to limit the embodiments of this application. Unless otherwise specified, these terms should be understood according to their ordinary and usual meanings.

[0054] In the specification and claims of this application and the accompanying drawings, the terms "first," "second," "third," etc. are used to distinguish similar or similar objects or entities, and are not necessarily intended to limit a particular order or sequence, unless otherwise noted. It should be understood that the terms used in this manner are interchangeable under appropriate circumstances.

[0055] The terms "comprise," "include," and "have," and any variations thereof, are intended to cover but not exclude inclusion; for example, a product or device comprising a list of components is not necessarily limited to all the components expressly listed but may include other components not expressly listed or inherent to such product or device.

[0056] Business expansion work orders (BDOs) are the full name for business expansion work orders, and they involve the management process for power users applying for new installations, capacity increases, or changes to their electricity needs. Related technologies archive BDOs, but these archived BDOs often contain issues. Subsequent processing of these problematic BDOs can lead to data processing errors. Therefore, determining whether archived BDOs contain issues has become a pressing technical challenge for those skilled in the art.

[0057] In order to solve the above technical problems, an embodiment of the present application provides a business expansion work order processing method based on RPA technology. In this method, the power supply time in the power supply time data column is filtered, and the second business expansion work order with an empty power supply time is automatically stored as a detailed list of business expansion work orders that do not meet the conditions for archiving. In this way, business expansion work orders that do not meet the conditions for archiving are automatically filtered to avoid affecting subsequent operations.

[0058] Figure 1 A flowchart of a method for processing business expansion work orders based on RPA technology according to some embodiments is exemplarily shown, and the method includes S100-S500.

[0059] S100. When an operation instruction from the user is received, a business expansion work order query interface in a marketing management system configured based on RPA technology (Robotic process automation) is displayed.

[0060] Figure 2 The following is an example of an interface diagram of a marketing management system provided according to some embodiments. In the embodiment of the present application, the process of generating an operation instruction may include: the user may first log in to the marketing management system, then select the business expansion control in the first-level menu, then select the query function control in the second-level menu, continue to select the work order query control in the third-level menu, and finally select the business expansion work order query control in the fourth-level menu, at which time the operation instruction is generated. It should be noted that Figure 2 The blurred part is intentionally blurred.

[0061] S200. On the business expansion work order query interface, when a query instruction sent by a user is received, the first business expansion work order that meets the query conditions is queried and displayed, and an export control is also displayed on the interface displaying the first business expansion work order. The query conditions include the archiving time range.

[0062] Specifically, the process of generating a query instruction including query conditions may include: selecting an advanced options control on a business expansion work order query interface, which then displays an interface corresponding to the advanced options control. This interface displays a filing time control, which is used to select a filing time range. After selecting the filing time range, selecting the query control generates a query instruction including query conditions. The query conditions include the filing time range.

[0063] In some embodiments, a work order status control is also displayed on the interface corresponding to the advanced option control. When the work order status control is selected, the status control corresponding to the work order status control is displayed, specifically including a low-voltage non-residential new installation, capacity increase and decrease control, a low-voltage residential new installation, capacity increase and decrease control, a high-voltage new installation, capacity increase and decrease control, and a large customer new installation, capacity increase control. After selecting the status control, the query control is selected, and a query instruction including query conditions is generated. The query conditions also include the work order status, and the work order status includes low-voltage non-residential new installation, capacity increase and decrease, low-voltage residential new installation, capacity increase and decrease, high-voltage new installation, capacity increase and decrease, and large customer new installation and capacity increase.

[0064] S300. When receiving an instruction from the user to select the export control, export the first business expansion work order to form a business expansion archived work order service table.

[0065] In an embodiment of the present application, the file format of the business expansion archived work order business table can be .xls.

[0066] In some embodiments, there may be multiple first business expansion work orders that meet the query conditions, and multiple first business expansion work orders that meet the query conditions are exported to form a business expansion archived work order business table.

[0067] In some embodiments, the method further includes setting the name of the business expansion archived work order business table to include the time of the day. For example, the business expansion archived work order business table is named business expansion archived work order business table + the time of the day (such as May 1, 2024).

[0068] S400. Process the business expansion archived work order business table so that the processed business expansion archived work order business table includes a second business expansion work order, and the second business expansion work order includes a preset data column, wherein the preset data column includes a power supply time data column.

[0069] In order to ensure that the content in the subsequent saved business expansion work order details table that does not meet the conditions for archiving is clearer, the business expansion archived work order business table is processed and only the preset data columns are retained.

[0070] In some embodiments, the step of processing the business expansion archived work order service table includes deleting other data columns in the business expansion archived work order service table except for preset data columns.

[0071] In some embodiments, the preset data columns include, in addition to the power supply time data column, a work order number data column, a user number data column, a power supply unit data column, a power supply bureau data column, a business category data column, a business subcategory data column, a work order source data column, a user name data column, a power usage address data column, a contact data column, a contact mobile phone data column, a power usage category data column, a formal acceptance date data column, a power supply time data column, and an archiving date data column.

[0072] S500. The second business expansion work orders with empty power supply time in the power supply time data column are converted into a detailed list of business expansion work orders that do not meet the conditions for archiving.

[0073] In this embodiment, the detailed list of business expansion work orders that are not eligible for archiving only includes the second business expansion work order with a blank power supply time. A blank power supply time indicates that power has not yet been delivered, indicating that there are some issues with this second business expansion work order. Further investigation can be conducted to understand the reasons for the power failure and improve the execution of the business expansion work order.

[0074] In some embodiments, the method further includes setting the name of the work order list that does not meet the conditions for archiving business expansion orders to include the time of the day. For example, the work order list that does not meet the conditions for archiving business expansion orders is named "work order list that does not meet the conditions for archiving business expansion orders" + the time of the day (for example, May 1, 2024).

[0075] In this embodiment, since business expansion work orders are continuously issued, the detailed list of business expansion work orders that do not meet the conditions for archiving counted every day may be different. In order to avoid the inability to distinguish the detailed list of business expansion work orders that do not meet the conditions for archiving counted at different times, the name of the detailed list of business expansion work orders that do not meet the conditions for archiving is set to include the time of the day.

[0076] In some embodiments, the method further comprises:

[0077] In the detailed list of work orders that do not meet the conditions for archiving, add an archiving type data column and an initial review judgment data column.

[0078] In this embodiment, in order to clearly describe the specific situation of the second business expansion work order in the business expansion work order details table that does not meet the conditions for archiving, an archiving type data column and an initial verification determination data column are added.

[0079] Filling the filing type into the filing type data column, and filling the preliminary check determination result into the preliminary check determination data column, wherein the preliminary check determination result is determined according to the filing type;

[0080] The archive type data column may correspond to archive types such as incomplete data, limited business expansion, on-site power already used, insufficient building conditions, no capacity expansion conditions, duplicate orders, wrong orders, weather reasons, customer unavailable, unreachable customer, temporary power outage, and test work orders. Specifically, this archive type is generated based on the operator's actual survey opinions.

[0081] The preliminary review and determination results corresponding to the preliminary review and determination data column include reasonable, unreasonable, and pending review.

[0082] In some embodiments, the process of determining the preliminary verification result according to the filing type includes: determining whether the filing type is any one or more of incomplete data, limited business expansion, on-site electricity consumption, insufficient building conditions, and no capacity expansion conditions, and if so, determining that the preliminary verification result is reasonable;

[0083] If not, determine whether the archive type is any one or more of duplicate order, wrong order, weather reason, customer unavailable, uncontactable customer, temporary power outage and test work order. If so, determine that the initial review result is unreasonable; if not, determine that the initial review result is pending review.

[0084] In an embodiment of the present application, the second business expansion work order in the business expansion work order details table that does not meet the conditions for archiving is further analyzed to facilitate subsequent analysis of the specific circumstances of the business expansion work order.

[0085] In some embodiments, the preset data column further includes a formal acceptance date data column; the formal acceptance date in the formal acceptance date data column refers to the acceptance date of the business expansion work order. The method further includes:

[0086] The second business expansion work order whose power supply time in the power supply time data column is not empty is used to form a detailed list of archived business expansion work orders.

[0087] In this embodiment, since business expansion work orders are continuously issued, the detailed list of archived business expansion work orders counted every day may be different. In order to avoid the inability to distinguish the detailed list of archived business expansion work orders counted at different times, the name of the detailed list of archived business expansion work orders is set to include the time of the day.

[0088] For example, the archived business expansion work order details list is named as the new installation and capacity increase archived business expansion work order details list + the time of the day (for example, May 1, 2024).

[0089] In the detailed list of archived business expansion work orders, add a data column on the duration of the fire.

[0090] According to the second business expansion work order in the archived business expansion work order details table, the power supply time in the power supply time data column and the formal acceptance time in the formal acceptance date data column, the fire connection time is calculated and the fire connection time is filled in the fire connection time data column.

[0091] In the embodiment of the present application, the time taken for the business expansion work order to be accepted and powered on can be understood through the time taken for the business expansion work order to be accepted and powered on, which can help to subsequently improve the processing flow of the business expansion work order.

[0092] In some embodiments, the preset data column further includes a user ID data column; and the method further includes:

[0093] Obtaining a preset user number. In this embodiment, the preset user number may be manually set, and specifically, the user number corresponding to the user to be audited may be set as the preset user number.

[0094] Determine whether there is an abnormality in the second business work order corresponding to the user number that is the same as the preset user number in the user number data column.

[0095] In this embodiment, an abnormality judgment is performed on whether there is an abnormality in the second service work order corresponding to the user number that is the same as the preset user number.

[0096] If there is an exception, the second business work order with the exception will be sent to the auditor's end.

[0097] In this embodiment, the auditor's terminal can be understood as the auditor's terminal, and the auditor can view the second business work order with abnormalities through the terminal.

[0098] In some embodiments, before the step of determining whether there is an abnormality in the second service work order corresponding to the user number in the user number data column that is the same as the preset user number, the method further includes:

[0099] Obtain the total forward active power, data time and comprehensive rate corresponding to the preset user number;

[0100] Among them, the total forward active power is the difference between the starting and ending codes on the meter during the time period corresponding to the data time, that is, how much electricity was used. For example, the data time can be April 20, 2025. The total forward active power can be the difference between the code number (starting code) displayed on the meter at 00:00 on April 20, 2025 and the code number (ending code) displayed on the meter at 24:00. The comprehensive multiplier refers to a comprehensive coefficient calculated by the transformation ratio of the current transformer (CT) and the voltage transformer (PT), which is used to convert the measured value of the meter into actual power consumption. It is the product of the transformation ratio of the current transformer and the transformation ratio of the voltage transformer, and reflects the actual multiplier relationship when the meter is connected to the circuit.

[0101] The electric quantity is determined by utilizing the total forward active power and the comprehensive rate.

[0102] In some embodiments, the amount of electricity is equal to the product of the total forward active power and the comprehensive multiplication factor.

[0103] In some embodiments, the step of determining whether there is an abnormality in the second business work order corresponding to the user number in the user number data column that is the same as the preset user number includes:

[0104] Determine whether any one of the preset abnormal conditions in the preset abnormal condition set is met.

[0105] In some embodiments, the preset data columns further include a business subcategory data column, an electricity usage category data column, a formal acceptance date data column, and an archiving date data column.

[0106] The business subcategories in the business subcategory data column include low-voltage residential capacity expansion, low-voltage residential new installation, low-voltage non-residential capacity expansion, low-voltage non-residential new installation, high-voltage new installation, high-voltage capacity expansion, large-customer new installation, large-customer capacity expansion, reclassification, name change and transfer, account cancellation, table transfer and suspension.

[0107] The electricity consumption categories corresponding to the electricity consumption category data column include residential life and non-residential life.

[0108] The filing date in the filing date data column refers to the filing time of the business expansion work order.

[0109] In some embodiments, the preset abnormal conditions in the preset abnormal condition set include:

[0110] The difference between the data time and the power transmission time in the power transmission time data column is within a first preset difference range and the power quantity is greater than a first preset power quantity; exemplarily, the first preset difference range is less than or equal to 0, and the first preset power quantity is 0 kWh.

[0111] The difference between the data time and the power supply time is within a second preset difference range, and the electricity consumption category in the electricity consumption category data column is residential electricity consumption, which is greater than the second preset electricity consumption; exemplarily, the second preset difference range is greater than 0 and less than or equal to 1 day, and the second preset electricity consumption is 50 kWh.

[0112] The difference between the data time and the power supply time is within a second preset difference range, and the electricity consumption category in the electricity consumption category data column is non-residential life and the amount of electricity is greater than a third preset amount of electricity; exemplarily, the second preset difference range is greater than 0 and less than or equal to 1 day, and the third preset amount of electricity is 80 kWh.

[0113] The difference between the data time and the power supply time is within a third preset difference range, and the electricity consumption category in the electricity consumption category data column is greater than the fourth preset electricity consumption; exemplarily, the third preset difference range is greater than 1 and less than or equal to 2 days, and the fourth preset electricity consumption is 100 kWh.

[0114] The difference between the data time and the power supply time is within a third preset difference range, and the electricity consumption category in the electricity consumption category data column is greater than the fifth preset electricity consumption for non-residential life; exemplarily, the third preset difference range is greater than 1 and less than or equal to 2 days, and the fifth preset electricity consumption is 160 kWh.

[0115] The difference between the power supply time and the formal acceptance date in the formal acceptance date data column is within a fourth preset difference range, the difference between the archiving date in the archiving date data column and the formal acceptance date is within a fifth preset difference range, and the power amount is greater than a sixth preset power amount; exemplarily, the fourth preset difference range is less than 0.2 days, the fifth preset difference range is less than 1 day, and the sixth preset power amount is 10 kWh.

[0116] The difference between the filing date and the power supply time is within a sixth preset difference range, and the power consumption is greater than a seventh preset power consumption; illustratively, the sixth preset difference range is 0. The seventh preset power consumption is 10 kWh.

[0117] The business subcategory in the business subcategory data column is a new customer, and the power consumption is greater than an eighth preset power consumption. For example, the eighth preset power consumption is 500 kWh.

[0118] In this embodiment, new installation customers include low-voltage residential new installations, low-voltage non-residential new installations, high-voltage new installations, and large customer new installations.

[0119] If any one of the preset abnormal conditions is met, it is determined that the second business expansion work order is abnormal;

[0120] If all preset abnormal conditions are not met, it is determined that there is no abnormality in the second business expansion work order.

[0121] In the above embodiment, a business expansion work order processing method, system, equipment and medium based on RPA technology are provided. In this method, the power supply time in the power supply time data column is filtered, and the second business expansion work order with an empty power supply time is automatically stored as a detailed list of business expansion work orders that do not meet the conditions for archiving. In this way, business expansion work orders that do not meet the conditions for archiving are automatically filtered to avoid affecting subsequent operations.

[0122] Further, as Figure 1 The specific implementation of the method, the embodiment of the present application provides a structural diagram of a business expansion work order processing system based on RPA technology, such as Figure 3 As shown, the system includes:

[0123] The display unit 301 is configured to display a business expansion work order query interface in the marketing management system configured based on RPA technology when receiving a user's operation instruction;

[0124] A query unit 302 is configured to, upon receiving a query instruction from a user on the business expansion work order query interface, query and display a first business expansion work order that meets the query criteria, further displaying an export control on the interface displaying the first business expansion work order, wherein the query criteria include an archiving time range;

[0125] The export unit 303 is configured to export the first business expansion work order to form a business expansion archive work order business table when receiving an instruction from the user to select the export control;

[0126] A processing unit 304 is configured to process the business expansion archived work order business table so that the processed business expansion archived work order business table includes a second business expansion work order, wherein the second business expansion work order includes a preset data column, wherein the preset data column includes a power supply time data column;

[0127] The forming unit 305 is used to form a detailed list of business expansion work orders that do not meet the conditions for archiving, for the second business expansion work orders with empty power supply time in the power supply time data column.

[0128] It should be noted that for other corresponding descriptions of the functional units involved in the business expansion work order processing system based on RPA technology provided in this embodiment, please refer to Figure 1 The corresponding description in will not be repeated here.

[0129] Based on the above Figure 1The method shown in FIG. 1 is a method for performing the above-mentioned operation. Accordingly, the embodiment of the present application further provides a storage medium on which a computer program is stored. When the program is executed by a processor, the above-mentioned operation is performed. Figure 1 The following figure shows a business expansion work order processing method based on RPA technology.

[0130] Based on this understanding, the technical solution of the present application can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, USB flash drive, mobile hard disk, etc.), including a number of instructions for enabling an electronic device (which can be a personal computer, server, or network device, etc.) to execute the methods described in each implementation scenario of the present application.

[0131] Based on the above Figure 1 The method shown, and Figure 2 In order to achieve the above-mentioned purpose, the embodiment of the present application further provides a physical device for business expansion work order processing based on RPA technology, which can be a computer, a smart phone, a tablet computer, a smart watch, a server, or a network device, etc. The physical device includes a storage medium and a processor; the storage medium is used to store computer programs; the processor is used to execute computer programs to achieve the above-mentioned Figure 1 The following figure shows a business expansion work order processing method based on RPA technology.

[0132] Optionally, the physical device may further include a user interface, a network interface, a camera, a radio frequency (RF) circuit, a sensor, an audio circuit, a Wi-Fi module, etc. The user interface may include a display, an input unit such as a keyboard, etc., and the optional user interface may also include a USB interface, a card reader interface, etc. The network interface may optionally include a standard wired interface, a wireless interface (such as a Wi-Fi interface), etc.

[0133] Those skilled in the art will understand that the electronic device structure provided in this embodiment does not limit the electronic device, and may include more or fewer components, or combine certain components, or arrange the components differently.

[0134] The storage medium may also include an operating device and a network communication module. The operating device is a program that manages and stores the hardware and software resources of the electronic device, supporting the operation of information processing programs and other software and / or programs. The network communication module is used to enable communication between the various controls within the storage medium and with other hardware and software in the physical device.

[0135] Through the description of the above implementation methods, those skilled in the art can clearly understand that the present application can be implemented by means of software plus a necessary general hardware platform, or by hardware.

[0136] Those skilled in the art will understand that the accompanying drawings are only schematic diagrams of a preferred implementation scenario, and the units or processes in the accompanying drawings are not necessarily required to implement the present application. Those skilled in the art will understand that the units in the devices in the implementation scenario can be distributed in the devices of the implementation scenario according to the implementation scenario description, or can be changed accordingly and located in one or more devices different from the implementation scenario. The units of the above-mentioned implementation scenario can be combined into one unit, or can be further split into multiple sub-units.

[0137] The serial numbers of the above application are for descriptive purposes only and do not represent the advantages or disadvantages of the implementation scenarios. The above disclosure only discloses several specific implementation scenarios of the present application, but the present application is not limited thereto. Any changes that can be conceived by those skilled in the art should fall within the scope of protection of the present application.

Claims

1. A business expansion work order processing method based on RPA technology, characterized in that: include: When receiving the user's operation instruction, the business expansion work order query interface in the marketing management system configured based on RPA technology is displayed; On the business expansion work order query interface, when a query instruction sent by a user is received, a first business expansion work order that meets the query conditions is searched and displayed, and an export control is also displayed on the interface displaying the first business expansion work order, wherein the query conditions include an archiving time range; When receiving an instruction from the user to select the export control, exporting the first business expansion work order to form a business expansion archive work order business table; Processing the business expansion archived work order business table so that the processed business expansion archived work order business table includes a second business expansion work order, wherein the second business expansion work order includes a preset data column, wherein the preset data column includes a power supply time data column; The second business expansion work order with a blank power supply time in the power supply time data column is used to form a detailed list of business expansion work orders that do not meet the conditions for archiving.

2. The method according to claim 1, characterized in that Also includes: In the detailed list of work orders that do not meet the conditions for archiving, add a data column for archiving type and a data column for preliminary verification; The filing type data column is filled with the filing type, and the preliminary check determination data column is filled with the preliminary check determination result, wherein the preliminary check determination result is determined according to the filing type.

3. The method according to claim 1, characterized in that The preset data column also includes a formal acceptance date data column; the method further includes: The second business expansion work orders whose power supply time is not empty in the power supply time data column are used to form a detailed list of archived business expansion work orders; In the detailed list of archived business expansion work orders, add a data column on the duration of the fire connection; According to the second business expansion work order in the archived business expansion work order details table, the power supply time in the power supply time data column and the formal acceptance time in the formal acceptance date data column, the fire connection time is calculated and the fire connection time is filled in the fire connection time data column.

4. The method according to claim 3, characterized in that The preset data column also includes a user number data column; the method further includes: Get the preset user ID; Determine whether there is an abnormality in the second business work order corresponding to the user number that is the same as the preset user number in the user number data column; If there is an exception, the second business work order with the exception will be sent to the auditor's end.

5. The method according to claim 4, characterized in that Before the step of determining whether there is an abnormality in the second business work order corresponding to the user number in the user number data column that is the same as the preset user number, the method further includes: Obtain the total forward active power, data time and comprehensive rate corresponding to the preset user number; The electric quantity is determined by utilizing the total forward active power and the comprehensive rate.

6. The method according to claim 5, characterized in that The step of determining whether there is an abnormality in the second business work order corresponding to the user number in the user number data column that is the same as the preset user number includes: Determine whether any preset abnormal condition in the preset abnormal condition set is met; If any one of the preset abnormal conditions is met, it is determined that the second business expansion work order is abnormal; If all preset abnormal conditions are not met, it is determined that there is no abnormality in the second business expansion work order.

7. The method according to claim 6, characterized in that The preset data columns also include a business subcategory data column, an electricity usage category data column, a formal acceptance date data column, and a filing date data column; The preset abnormal conditions in the preset abnormal condition set include that the difference between the data time and the power transmission time in the power transmission time data column is within a first preset difference range and the power quantity is greater than a first preset power quantity; The difference between the data time and the power supply time is within a second preset difference range, and the amount of electricity consumed for residential use in the electricity consumption category data column is greater than a second preset amount of electricity consumed; The difference between the data time and the power transmission time is within a second preset difference range, and the amount of electricity consumed for non-residential use in the electricity consumption category data column is greater than a third preset amount of electricity; The difference between the data time and the power supply time is within a third preset difference range, and the amount of electricity consumed by the electricity consumption category of residential life in the electricity consumption category data column is greater than a fourth preset amount of electricity; The difference between the data time and the power transmission time is within a third preset difference range, and the amount of electricity consumed for non-residential use in the electricity consumption category data column is greater than a fifth preset amount of electricity consumed; The difference between the power supply time and the formal acceptance date in the formal acceptance date data column is within a fourth preset difference range, the difference between the filing date in the filing date data column and the formal acceptance date is within a fifth preset difference range, and the power amount is greater than a sixth preset power amount; The difference between the filing date and the power supply time is within a sixth preset difference range, and the power quantity is greater than a seventh preset power quantity; The business subcategory in the business subcategory data column is a new customer, and the power amount is greater than an eighth preset power amount.

8. A business expansion work order processing system based on RPA technology, characterized by: include: A display unit is configured to display a business expansion work order query interface in the marketing management system configured based on RPA technology when receiving a user's operation instruction; a query unit configured to query and display, on the business expansion work order query interface, a first business expansion work order that meets the query criteria upon receiving a query instruction sent by a user, and further display an export control on the interface displaying the first business expansion work order, wherein the query criteria include an archiving time range; An export unit, configured to export the first business expansion work order to form a business expansion archive work order business table when receiving an instruction from a user to select the export control; a processing unit, configured to process the business expansion archived work order business table so that the processed business expansion archived work order business table includes a second business expansion work order, wherein the second business expansion work order includes a preset data column, wherein the preset data column includes a power supply time data column; A forming unit is used to form a detailed list of business expansion work orders that do not meet the conditions for archiving for the second business expansion work order with a blank power supply time in the power supply time data column.

9. An electronic device, characterized in that: include: at least one processor; and, a memory communicatively coupled to the at least one processor; The memory stores instructions that can be executed by the at least one processor, and the instructions are configured to execute the method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that Computer-executable instructions are stored, and the computer-executable instructions are used to execute the method according to any one of claims 1 to 7.

Images