CN113537895A - Logistics operation report system - Google Patents
Logistics operation report system Download PDFInfo
- Publication number
- CN113537895A CN113537895A CN202110817222.2A CN202110817222A CN113537895A CN 113537895 A CN113537895 A CN 113537895A CN 202110817222 A CN202110817222 A CN 202110817222A CN 113537895 A CN113537895 A CN 113537895A
- Authority
- CN
- China
- Prior art keywords
- unit
- data
- module
- task
- management
- 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
- 238000007726 management method Methods 0.000 claims abstract description 106
- 238000007405 data analysis Methods 0.000 claims abstract description 15
- 238000013523 data management Methods 0.000 claims abstract description 14
- 238000012544 monitoring process Methods 0.000 claims abstract description 13
- 238000013461 design Methods 0.000 claims abstract description 11
- 230000002159 abnormal effect Effects 0.000 claims description 15
- 238000000034 method Methods 0.000 claims description 14
- 238000012384 transportation and delivery Methods 0.000 claims description 10
- 230000008676 import Effects 0.000 claims description 9
- 238000013507 mapping Methods 0.000 claims description 5
- 230000005540 biological transmission Effects 0.000 abstract 1
- 238000012216 screening Methods 0.000 description 5
- 238000004458 analytical method Methods 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- 230000007547 defect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 235000010627 Phaseolus vulgaris Nutrition 0.000 description 1
- 244000046052 Phaseolus vulgaris Species 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Artificial Intelligence (AREA)
- Accounting & Taxation (AREA)
- Health & Medical Sciences (AREA)
- Development Economics (AREA)
- General Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a logistics operation report system which comprises a basic configuration module, a data management module, a distribution tool module, a report design module, a system management module, a system monitoring module and a system homepage module, wherein the basic configuration module comprises a data source configuration unit for configuring and connecting a database server and a mail server unit for connecting a mail server, and the distribution tool module can receive data acquired by the data management module from the data source configuration unit and send the data through a specified mail server unit. The invention is a report system which is convenient for data analysis and arrangement, data monitoring and task data issuing and appointed transmission.
Description
Technical Field
The invention mainly relates to the technical field of information processing, in particular to a logistics operation report system.
Background
A large amount of service data is generated when a storage and transportation company operates, the workload of sorting, collecting and analyzing the service data is large and mechanical, and when the service data is not effectively monitored, a service problem occurs.
According to a report system provided in patent document CN201911283132.9, the report system includes a database unit for configuring database unit information for storing business data; then, by the self-defined report unit, uploading a user-defined template, and automatically acquiring corresponding data from the database unit by the self-defined template according to the types of different data in the template, and then generating a self-defined report; and finally, a report printing unit supports user-defined printing templates of printing scenes, and printing can be completed by uploading the printing templates and the script language, so that preview printing and silent printing are supported. The system simplifies the data acquisition and generation program, effectively improves the defect that the data codes need to be modified after the traditional data requirement format is changed, and improves the working efficiency.
The system in the patent simplifies the data acquisition and generation procedures, improves the defect of modifying data codes, is inconvenient for analyzing and sorting data, monitoring data and assigning and transmitting task data.
Disclosure of Invention
The invention mainly provides a logistics operation reporting system, which is used for solving the technical problems in the background technology.
The technical scheme adopted by the invention for solving the technical problems is as follows:
a logistics operation report system comprises a basic configuration module, a data management module, a distribution tool module, a report design module, a system management module, a system monitoring module and a system home page module, wherein the basic configuration module comprises a data source configuration unit for configuring and connecting a database server and a mail server unit for connecting a mail server, and the distribution tool module can receive data acquired by the data management module from the data source configuration unit and send the data through a specified mail server unit;
the distribution tool module comprises a recipient management unit, a message template unit, a distribution task unit, a distribution log unit and a distribution strategy unit, wherein the recipient management unit is used for setting receivable information of a recipient and receivable data of the recipient, the message management unit is used for setting a message subject, a distribution data source and a message template, the message template unit is used for editing a text template in a message, the distribution task unit is used for setting task execution time and a message to be sent, and the distribution log unit is used for inquiring task execution conditions and reissuing data release failure items;
the data management module comprises an online data unit and an offline data unit, the online data unit is used for being connected with the data source configuration unit to acquire required data, and the offline data unit is used for editing and modifying the acquired data.
Preferably, the recipient management unit is configured to edit a name, a mailbox, a telephone call, a received message, a data receiving rule, and a subject prefix of the recipient, where the subject prefix is used to distinguish distributed data. In the preferred embodiment, the recipient management unit is convenient to edit the name, the mailbox, the telephone and the received message of the recipient and can set the data receiving rule of the recipient.
Preferably, the message management unit may edit data and a data carrying manner, and use a data source, a name space, and a data carrying manner to import data. In the preferred embodiment, the message management unit is used for facilitating the import of data sources, the import of space names such as inventory reports of parts of a certain company, and the selection of data carrying modes such as pictures, tables and characters.
Preferably, the task distributing unit may edit a task name, a task description, an execution method, a Cron expression, a subtask ID, a message push, a push manner, and a mail server, so as to issue a task. In the preferred embodiment, the task name, the task description, the execution method, the Cron expression, the subtask ID, the message pushing mode and the pushing mode are conveniently edited by distributing the task unit, and the mail server is conveniently selected to send the mail.
Preferably, the distribution log unit is configured to display a sending task name, a task execution time, a distribution total number, a success number, a failure number, and a failure record, where the failure record includes a recipient, distributed data, a failure reason, and a creation time. In the preferred embodiment, the distribution log unit facilitates recording task release and failure recording of tasks that fail to be sent, so as to facilitate re-sending.
Preferably, the online data unit is used for editing a data source name, a query statement, a field mapping relationship, a limit number and a name space to obtain the required data through screening. In the preferred embodiment, the screening out of the required data from the data source configuration unit on demand is facilitated by the line data unit.
Preferably, the system management module comprises a user management unit, a role management unit, a menu management unit, a department management unit, a post management unit and a task scheduling unit, wherein the user management unit is used for searching and editing user information, the role management unit is used for searching and changing color information in the system, the menu management unit is used for editing a system menu, the department management unit is used for editing department information and supplier information, the post management unit is used for searching and editing post information in the system, and the task scheduling unit is used for searching and editing system tasks. In the preferred embodiment, the user management unit is used for searching and editing user information, the role management unit is used for searching and changing role information in the system, the menu management unit is used for editing a system menu, the department management unit is used for editing department information and supplier information, the post management unit is used for searching and editing post information in the system, and the task scheduling unit is used for searching and editing system tasks.
Preferably, the system monitoring module includes an online user unit for managing an online user, an operation log unit for viewing user operation contents, and an abnormal log unit for viewing abnormal operations of the user. In the preferred embodiment, the online user unit is used for managing online users, the operation log unit is used for checking user operation contents, and the abnormal log unit is used for checking abnormal operations of the users.
Preferably, the system homepage module includes a real-time inventory unit, an inventory data analysis unit and a delivery overtime early warning unit, the real-time inventory unit is used for checking inventory data of suppliers and management users, the inventory data analysis unit is used for displaying the receiving and sending amount of parts in a chart form and calculating an inventory safety value according to the receiving and sending amount of the parts, and the delivery overtime early warning unit is used for displaying order records with overtime risks and automatically distributing orders with overtime risks by mails. In the preferred embodiment, the real-time inventory unit is used for checking inventory data of suppliers and management users, the inventory data analysis unit is used for displaying the receiving and sending amount of parts in a chart form and calculating the inventory safety value according to the receiving and sending amount of the parts, and the delivery overtime early warning unit is used for displaying order records with overtime risks and automatically distributing orders with overtime risks by mails.
Preferably, the report design module comprises a billboard model unit and a data billboard unit, the billboard model unit is used for searching the billboard model, and the data billboard unit is used for generating the data billboard by combining the metadata and the billboard model. In the preferred embodiment, the kanban model unit is configured to find a kanban model, and the data kanban unit is configured to generate a data kanban by combining the metadata and the kanban model.
Compared with the prior art, the invention has the beneficial effects that:
the invention can edit the name, mailbox, telephone and received message of the receiver and set the data receiving rule of the receiver through the receiver management list, import the data source through the message management unit, import the space name such as a part inventory report of a certain company, select the data bearing mode such as picture, table and character, edit the task name, task description, execution method, Cron expression, subtask ID, message push and push mode through the distribution task unit and select the mail server for mail sending, record the task issue and fail record the failed task through the distribution log unit so as to resend, screen and export the needed data from the data source configuration unit through the line data unit as required, the system comprises a system management module, a role management unit, a menu management unit, a task scheduling unit, an online user unit, an operation log unit, an abnormal log unit, a real-time inventory unit, an inventory data analysis unit, a part management unit, a task scheduling unit, an inventory data analysis unit and an inventory safety value calculation unit, wherein the user management unit is used for searching and editing user information in the system management module, the role management unit is used for searching and changing role information in the system, the menu management unit is used for editing a system menu, the department management unit is used for editing department information and supplier information, the role management unit is used for searching and editing the role information in the system, the task scheduling unit is used for searching and editing system tasks, the online user unit in the system monitoring module is used for managing online users, the operation log unit is used for checking user operation contents, the abnormal operation log unit is used for checking abnormal operation of users, the real-time inventory unit is used for checking inventory data of suppliers and management users in the system homepage module, the inventory data analysis unit is used for displaying the receiving and sending and receiving and sending the amount of parts in a chart form and calculating the inventory safety value according to the receiving and sending the quantity of the parts, the distribution overtime early warning unit is used for displaying order records with overtime risks and automatically distributing the orders with the overtime risks through mails, the billboard model unit in the report design module is used for searching the billboard model, and the data billboard unit is used for generating the data billboard by combining metadata and the billboard model.
The present invention will be explained in detail below with reference to the drawings and specific embodiments.
Drawings
Fig. 1 is a general structural frame diagram of the present invention.
Description of the drawings: 10. a base configuration module; 11. a data source configuration unit; 12. a mail server unit; 20. a data management module; 21. an online data unit; 22. an offline data unit; 30. a dispensing instrument module; 31. a recipient management unit; 32. a message management unit; 33. a message template unit; 34. distributing task units; 35. a log distributing unit; 36. a distribution policy unit; 40. a report design module; 41. a billboard model unit; 42. a data billboard unit; 50. a system management module; 51. a user management unit; 52. a role management unit; 53. a menu management unit; 54. a department management unit; 55. a post management unit; 56. a task scheduling unit; 60. a system monitoring module; 61. an online user unit; 62. an operation log unit; 63. an exception log unit; 70. a system home page module; 71. a real-time inventory unit; 72. an inventory data analysis unit; 73. and a delivery overtime early warning unit.
Detailed Description
In order to facilitate an understanding of the invention, the invention will now be described more fully hereinafter with reference to the accompanying drawings, in which several embodiments of the invention are shown, but which may be embodied in different forms and not limited to the embodiments described herein, but which are provided so as to provide a more thorough and complete disclosure of the invention.
It will be understood that when an element is referred to as being "secured to" another element, it can be directly on the other element or intervening elements may be present, and when an element is referred to as being "connected" to another element, it can be directly connected to the other element or intervening elements may also be present, as the terms "vertical", "horizontal", "left", "right" and the like are used herein for descriptive purposes only.
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs, and the knowledge of the terms used herein in the specification of the present invention is for the purpose of describing particular embodiments and is not intended to limit the present invention, and the term "and/or" as used herein includes any and all combinations of one or more of the associated listed items.
Please refer to fig. 1, in a preferred embodiment of the present invention, a logistics operation reporting system includes a basic configuration module 10, a data management module 20, a distribution tool module 30, a reporting design module 40, a system management module 50, a system monitoring module 60, and a system homepage module 70, where the basic configuration module 10 includes a data source configuration unit 11 configured to be connected to a database server and a mail server unit 12 configured to be connected to a mail server, and the distribution tool module 30 can receive data acquired by the data management module 20 from the data source configuration unit 11 and send the data through a designated mail server unit 12; the data management module 20 includes an online data unit 21 and an offline data unit 22, where the online data unit 21 is used to connect to the data source configuration unit 11 to obtain required data, the offline data unit 22 is used to edit and modify the obtained data, and the online data unit 21 is used to edit a data source name, an inquiry statement, a field mapping relationship, a limit number, and a name space to obtain the required data through screening.
It should be noted that, in the present embodiment, the distribution tool module 30 may receive the data acquired by the data management module 20 from the data source configuration unit 11 and send out the data through the designated mail server unit 12;
further, the data source configuration unit 11 is configured to configure and connect to a database server, and when data is newly added, the data source name is used for later selecting a data source by editing formats of the data source name, a database driver name, a URL, a user name, and a user password, where the database driver name is used by a user to connect to a driver used by the database, the URL represents a database connection address, the user name is a user used when logging in the database, and the user password is a login password;
further, the mail server unit 12 is configured to send a mail, and when a mail server is newly added, a sender, that is, a sender name seen by a recipient, a host name, that is, a host name of the mail server, a port number, that is, a port number of the mail server, a sender mailbox, that is, a sender mailbox address, and a mailbox password, that is, a sender mailbox password;
furthermore, the required data is obtained by screening through the data source name, the query statement, the field mapping relation, the limit number and the name space during online data query;
furthermore, the offline file can be added in a file import mode.
Please refer to fig. 1, in another preferred embodiment of the present invention, the distribution tool module 30 includes a recipient management unit 31, a message management unit 32, a message template unit 33, a distribution task unit 34, a distribution log unit 35, and a distribution policy unit 36, the recipient management unit 31 is configured to set receivable information of a recipient and receivable data of the recipient, the message management unit 32 is configured to set a message subject, a distribution data source, and a message template, the message template unit 33 is configured to edit a text template in a message, the distribution task unit 34 is configured to set a task execution time and a message to be sent, the distribution log unit 35 is configured to query a task execution condition and to re-publish a data publication failure item; the recipient management unit 31 is configured to edit names, mailboxes, phones, received messages, data receiving rules, and subject prefixes of recipients, where the subject prefixes are used to distinguish distributed data, the message management unit 32 may edit data and a data carrying manner, and use a data source, a name space, and a data carrying manner to import data, the distribution task unit 34 may edit a task name, a task description, an execution method, a Cron expression, a subtask ID, a message push, a push manner, and a mail server to issue a task, the distribution log unit 35 is configured to display a sending task name, a task execution time, a distribution total number, a success number, a failure number, and failure records, where the failure records include a recipient, distributed data, a failure reason, and creation time.
It should be noted that, in this embodiment, when the distribution tool module 30 performs task distribution, in the first step, the name, mailbox, telephone, received message, data receiving rule, and subject prefix of the recipient are edited by the recipient management unit 31; the second step, the message management unit 32 is used to select the message name, the subject name, the message content template, the data source and the data bearing mode, the third step, the message template unit 33 is used to edit the text content including adding the template name, the subject name, the message content template and the data attachment, the fourth step, the distribution strategy unit 36 is used to set the distribution, the fifth step, the task unit 34 is used to distribute the task, when the task is distributed, the task name, the task description, the execution method, the Cron expression, the subtask ID, the message push, the push mode and the mail server can be edited to distribute the task, the sixth step, the distribution log unit 35 is used to display the sending task name, the task execution time, the distribution total number, the success number, the failure number and the failure record, the failure record includes the receiver, the distributed data, Failure reason and creation time, at which point reissue may occur.
Please refer to fig. 1, in another preferred embodiment of the present invention, the system management module 50 includes a user management unit 51, a role management unit 52, a menu management unit 53, a department management unit 54, a post management unit 55, and a task scheduling unit 56, the user management unit 51 is used for searching and editing user information, the role management unit 52 is used for searching and changing role information in the system, the menu management unit 53 is used for editing system menus, the department management unit 54 is used for editing department information and supplier information, the post management unit 55 is used for searching and editing post information in the system, the task scheduling unit 56 is used for searching and editing system tasks, the system monitoring module 60 includes an online user unit 61 for managing online users, an operation log unit 62 for viewing user operation contents, and an abnormal log unit 63 for viewing user abnormal operations, the system home page module 70 includes a real-time inventory unit 71, an inventory data analysis unit 72, and a delivery timeout warning unit 73, where the real-time inventory unit 71 is used for checking inventory data of suppliers and management users, the inventory data analysis unit 72 is used for displaying the receiving and sending amount of parts in a graph form and calculating an inventory safety value according to the receiving and sending amount of the parts, the delivery timeout warning unit 73 is used for displaying order records with a timeout risk and automatically distributing an order with a timeout risk by mail, the report design module 40 includes a billboard model unit 41 and a data billboard unit 42, the billboard model unit 41 is used for searching a billboard model, and the data billboard unit 42 is used for generating a data billboard by combining metadata and the billboard model.
In this embodiment, in the system management module 50, the user management unit 51 is used to search and edit user information, the role management unit 52 is used to search and modify role information in the system, the menu management unit 53 is used to edit a system menu, the department management unit 54 is used to edit department information and supplier information, the post management unit 55 is used to search and edit post information in the system, and the task scheduling unit 56 is used to search and edit system tasks;
further, an online user unit 61 in the system monitoring module 60 is used for managing online users so as to facilitate authorized users to forcibly log off ordinary users, an operation log unit 62 is used for checking user operation contents, and an abnormal log unit 63 is used for checking abnormal operations of users;
further, the real-time inventory unit 71 in the system home page module 70 is used for a supplier to check own inventory data, a management user to check all inventory data and check inventory daily change analysis, the inventory data analysis unit 72 is used for displaying the receiving and sending quantity of parts in a chart form and calculating an inventory safety value according to the receiving and sending quantity of the parts, and the delivery overtime early warning unit 73 is used for displaying order records with overtime risks and automatically distributing orders with overtime risks by mails;
further, the bulletin board model unit 41 in the report design module 40 is configured to search the bulletin board model, and the data bulletin board unit 42 is configured to generate the data bulletin board by combining the metadata and the bulletin board model.
Referring to fig. 1, in another preferred embodiment of the present invention, the system can customize time, set a certain rule for a group of data, and distribute the data meeting the rule to the people meeting the rule. When distributing, a certain distribution mode can be selected for data distribution. And presents the distributed data to the user friendly.
The implementation process comprises the following steps: firstly, configuring a mail server, inputting a sender name, namely a sender name displayed when a mail is sent, into a mail server unit 12, wherein the host name is a used mail server host, a port number is a used mail server host port, a sender mailbox is a mailbox account, and a sender mailbox password is a mailbox password;
secondly, configuring a data source server, namely inputting a data source name, namely a name of a connection database, a data driving name, namely a driving used for connecting the database, in the data source configuration unit 11, wherein a Uniform Resource Locator (URL) is a database connection address, a user name, namely a user name used for connecting the database, and a user password, namely a user password used for connecting the database;
thirdly, configuring a data source, namely, inputting the data source into the online data unit 21, namely, the data source is a database server, informing a system of which database and name space are connected, starting a name of the inquired data, using a later period as a name of an excel file sheet, and inquiring a statement, namely, a written SQL statement;
fourthly, configuring a message template, namely inputting a template name, namely a name starting from the template, and a template text, namely text content of the mail in the message template unit 33;
fifthly, message management is configured, a message name, a subject name, namely a main body of the mail, is input into the message management unit 32, a message content template, namely a mail text template is selected, a data source, namely online data and offline data are selected, a namespace and a data source select online data, a list is a namespace of the online data, a data source select offline data, a list is a namespace of the offline data, and a data bearing mode, namely, what mode the data is finally presented to a receiving party, can be presented in a text mode, and can also be transmitted in an excel attachment mode;
sixthly, a distribution strategy is configured, in the distribution strategy unit 36, the mail to be sent is distributed to the receivers by using a matching rule, and the matching rule is that the field name is sent to the mailboxes with a certain value; such as the secondary supplier code FLM-CSTY # TRUB & parts code [ J52-3611061, J00-3611061, S18-3611061, S18-3611065 ]; # TRUE represents that in the namespace, the secondary vendor code field must be the value FLM-CSTY to send the details to this vendor; if the second-level supplier code is FLM-CSTY, the field value representing the second-level supplier is sent when the field value contains FLM-CSTY; & represents a plurality of conditions, meaning and, the data within [ ] represents a plurality of possibilities, as long as one of them is met, a plurality of possibilities being distinguished by commas;
seventhly, a distribution task is configured, a task name, a task description, a Bean name, an execution method, a timing expression, a subtask ID, namely a task executed immediately after the task is executed, a task principal, an alarm mailbox, namely a mailbox, is used for sending the reason of the failure to a corresponding mailbox when the task is failed to be executed due to some reasons, a pushing mode, a mail server, namely which mail server is used for pushing, and is paused after the failure, namely whether the timing task is paused if the pushing fails, and a task state are input into the distribution task unit 34.
Referring now to FIG. 1, in another preferred embodiment of the present invention, data is automatically exported from the system at eight points per day, and the naming convention for the archived data is archived, as well as the acquisition of the archived data.
The implementation process comprises the following steps: firstly, configuring a data source server, using the data source server when distributing online data, and telling a system which database server to connect with; secondly, configuring a data source, setting online data and offline data, using the online data when acquiring the online data, and telling a system which table data of which database is acquired and SQL sentences need to be written; the offline data refers to data imported by Excel or data of a certain time node generated by using online data; and thirdly, configuring a data storage task and storing the data at regular time.
Referring now to fig. 1, in another preferred embodiment of the present invention, a service library is extracted and cleaned. Forming an index, and storing the index in an index library. And subsequently, carrying out data analysis on the index data. And displaying visually.
The implementation process comprises the following steps: firstly, configuring a data source server, using the data source server when distributing online data, and telling a system which database server to connect with; secondly, configuring a data source, setting online data and offline data, using the online data when acquiring the online data, and telling a system which table data of which database is acquired and SQL sentences need to be written; the offline data refers to data imported by Excel or data of a certain time node generated by using online data; and thirdly, configuring a data storage task and storing the data at regular time.
The specific process of the invention is as follows:
the distribution tool module 30 can receive the data acquired by the data management module 20 from the data source configuration unit 11 and send the data through the designated mail server unit 12;
the data source configuration unit 11 is configured to connect to a database server, and when new data is added, the data source name, the database driver name, the URL, the user name, and the user password are edited to increase, where the data source name is used when a data source is selected in the later stage, the database driver name is used by a user to connect to a driver used by the database, the URL indicates a database connection address, the user name is a user used when logging in the database, and the user password is a login password;
the mail server unit 12 is configured to send a mail, and when a mail server is newly added, a sender is required to be edited, that is, a sender name seen by a recipient, a host name is the host name of the mail server, a port number is the port number of the mail server, a sender mailbox is a sender mailbox address, and a mailbox password is the sender mailbox password;
when online data is queried, the required data is obtained through screening according to the data source name, query statement, field mapping relation, limit number and name space;
offline files can be added in a file import mode;
when the distribution tool module 30 distributes tasks, in the first step, the name, mailbox, telephone, received message, data receiving rule and subject prefix of the recipient are edited through the recipient management unit 31; the second step, the message management unit 32 is used to select the message name, the subject name, the message content template, the data source and the data bearing mode, the third step, the message template unit 33 is used to edit the text content including adding the template name, the subject name, the message content template and the data attachment, the fourth step, the distribution strategy unit 36 is used to set the distribution, the fifth step, the task unit 34 is used to distribute the task, when the task is distributed, the task name, the task description, the execution method, the Cron expression, the subtask ID, the message push, the push mode and the mail server can be edited to distribute the task, the sixth step, the distribution log unit 35 is used to display the sending task name, the task execution time, the distribution total number, the success number, the failure number and the failure record, the failure record includes the receiver, the distributed data, Failure reason and creation time, at which point reissue can be performed;
in the system management module 50, a user management unit 51 is used for searching and editing user information, a role management unit 52 is used for searching and changing role information in the system, a menu management unit 53 is used for editing a system menu, a department management unit 54 is used for editing department information and supplier information, a post management unit 55 is used for searching and editing post information in the system, and a task scheduling unit 56 is used for searching and editing system tasks;
an online user unit 61 in the system monitoring module 60 is used for managing online users so as to facilitate authorized users to forcibly log off ordinary users, an operation log unit 62 is used for checking user operation contents, and an abnormal log unit 63 is used for checking abnormal operations of the users;
a real-time inventory unit 71 in the system home page module 70 is used for a supplier to check own inventory data, a management user to check all inventory data and check inventory daily change analysis, an inventory data analysis unit 72 is used for displaying the receiving and sending quantity of parts in a chart form and calculating an inventory safety value according to the receiving and sending quantity of the parts, and a delivery overtime early warning unit 73 is used for displaying order records with overtime risks and automatically distributing orders with overtime risks by mails;
the bulletin board model unit 41 in the report design module 40 is used for searching the bulletin board model, and the data bulletin board unit 42 is used for generating the data bulletin board by combining the metadata and the bulletin board model.
The invention is described above with reference to the accompanying drawings, it is obvious that the invention is not limited to the above-described embodiments, and it is within the scope of the invention to adopt such insubstantial modifications of the inventive method concept and solution, or to apply the inventive concept and solution directly to other applications without modification.
Claims (10)
1. The logistics operation reporting system is characterized by comprising a basic configuration module (10), a data management module (20), a distribution tool module (30), a report design module (40), a system management module (50), a system monitoring module (60) and a system homepage module (70), wherein the basic configuration module (10) comprises a data source configuration unit (11) for configuring and connecting a database server and a mail server unit (12) for connecting a mail server, and the distribution tool module (30) can receive data acquired by the data management module (20) from the data source configuration unit (11) and send the data through a specified mail server unit (12);
the distribution tool module (30) comprises a recipient management unit (31), a message management unit (32), a message template unit (33), a distribution task unit (34), a distribution log unit (35) and a distribution strategy unit (36), wherein the recipient management unit (31) is used for setting receivable information of a recipient and receivable data of the recipient, the message management unit (32) is used for setting a message subject, a distribution data source and a message template, the message template unit (33) is used for editing a text template in a message, the distribution task unit (34) is used for setting a task execution time and a message to be sent, and the distribution log unit (35) is used for inquiring the task execution condition and reissuing a data release failure item;
the data management module (20) comprises an online data unit (21) and an offline data unit (22), wherein the online data unit (21) is used for connecting the data source configuration unit (11) to acquire required data, and the offline data unit (22) is used for editing and modifying the acquired data.
2. The logistics operation reporting system of claim 1, wherein the recipient management unit (31) is configured to edit a recipient's name, mailbox, phone call, received message, data receiving rule, and subject prefix, and the subject prefix is configured to distinguish distributed data.
3. The logistics operation reporting system of claim 1, wherein the message management unit (32) is capable of editing data and a data carrying manner, and data import is performed by using a data source, a name space and a data carrying manner.
4. The logistics operation reporting system of claim 1, wherein the task distribution unit (34) can edit the task name, the task description, the execution method, the Cron expression, the subtask ID, the message pushing, the pushing mode and the mail server to issue the task.
5. The logistics operation reporting system of claim 1, wherein the distribution log unit (35) is configured to display a sending task name, a task execution time, a distribution total number, a success number, a failure number, and a failure record, wherein the failure record comprises a receiver, distributed data, a failure reason, and a creation time.
6. The logistics operation reporting system of claim 1, wherein the online data unit (21) is configured to edit a data source name, a query statement, a field mapping relationship, a limit number, and a name space to filter and obtain the required data.
7. The logistics operation reporting system of claim 1, wherein the system management module (50) comprises a user management unit (51), a role management unit (52), a menu management unit (53), a department management unit (54), a department management unit (55) and a task scheduling unit (56), the user management unit (51) is used for searching and editing user information, the role management unit (52) is used for searching and changing color information in the system, the menu management unit (53) is used for editing system menus, the department management unit (54) is used for editing department information and supplier information, the post management unit (55) is used for searching and editing post information in the system, and the task scheduling unit (56) is used for searching and editing system tasks.
8. The logistics operation reporting system of claim 1, wherein the system monitoring module (60) comprises an online user unit (61) for managing online users, an operation log unit (62) for viewing user operation contents, and an abnormal log unit (63) for viewing abnormal operations of users.
9. The logistics operation reporting system of claim 1, wherein the system homepage module (70) comprises a real-time inventory unit (71), an inventory data analysis unit (72) and a delivery timeout warning unit (73), the real-time inventory unit (71) is used for checking inventory data of suppliers and management users, the inventory data analysis unit (72) is used for displaying the receiving and sending amount of parts in a form of a chart and calculating an inventory safety value according to the receiving and sending amount of parts, and the delivery timeout warning unit (73) is used for displaying order records with a timeout risk and automatically distributing orders with a timeout risk by emails.
10. The logistics operation reporting system of claim 1, wherein the report design module (40) comprises a billboard model unit (41) and a data billboard unit (42), wherein the billboard model unit (41) is used for searching the billboard model, and the data billboard unit (42) is used for generating the data billboard by combining the metadata and the billboard model.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110817222.2A CN113537895A (en) | 2021-07-20 | 2021-07-20 | Logistics operation report system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110817222.2A CN113537895A (en) | 2021-07-20 | 2021-07-20 | Logistics operation report system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113537895A true CN113537895A (en) | 2021-10-22 |
Family
ID=78128889
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110817222.2A Pending CN113537895A (en) | 2021-07-20 | 2021-07-20 | Logistics operation report system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113537895A (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20030009574A (en) * | 2001-06-23 | 2003-02-05 | 김준태 | Internet shopping mall management method and system capable of managing sales and inventory |
| CN105868202A (en) * | 2015-01-21 | 2016-08-17 | 镇江雅迅软件有限责任公司 | Multi-platform access data management system |
| CN107180315A (en) * | 2017-06-06 | 2017-09-19 | 安徽赛福贝特信息技术有限公司 | A kind of management of enterprise operation service platform |
| WO2018064843A1 (en) * | 2016-10-09 | 2018-04-12 | 深圳中兴力维技术有限公司 | System and method for managing infrastructure of data center |
| CN111079398A (en) * | 2019-12-13 | 2020-04-28 | 蚁安居(天津)网络技术有限公司 | Report system |
| CN111447466A (en) * | 2020-04-25 | 2020-07-24 | 杨益 | Program workflow control system |
| CN111460772A (en) * | 2020-02-28 | 2020-07-28 | 上海维信荟智金融科技有限公司 | Automatic report processing method and system |
| CN112258162A (en) * | 2020-11-04 | 2021-01-22 | 广西电网有限责任公司 | One-stop information application system |
| CN112488487A (en) * | 2020-11-25 | 2021-03-12 | 国网河北省电力有限公司物资分公司 | Electric power material supply chain system based on intelligent operation center and construction and application thereof |
-
2021
- 2021-07-20 CN CN202110817222.2A patent/CN113537895A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20030009574A (en) * | 2001-06-23 | 2003-02-05 | 김준태 | Internet shopping mall management method and system capable of managing sales and inventory |
| CN105868202A (en) * | 2015-01-21 | 2016-08-17 | 镇江雅迅软件有限责任公司 | Multi-platform access data management system |
| WO2018064843A1 (en) * | 2016-10-09 | 2018-04-12 | 深圳中兴力维技术有限公司 | System and method for managing infrastructure of data center |
| CN107180315A (en) * | 2017-06-06 | 2017-09-19 | 安徽赛福贝特信息技术有限公司 | A kind of management of enterprise operation service platform |
| CN111079398A (en) * | 2019-12-13 | 2020-04-28 | 蚁安居(天津)网络技术有限公司 | Report system |
| CN111460772A (en) * | 2020-02-28 | 2020-07-28 | 上海维信荟智金融科技有限公司 | Automatic report processing method and system |
| CN111447466A (en) * | 2020-04-25 | 2020-07-24 | 杨益 | Program workflow control system |
| CN112258162A (en) * | 2020-11-04 | 2021-01-22 | 广西电网有限责任公司 | One-stop information application system |
| CN112488487A (en) * | 2020-11-25 | 2021-03-12 | 国网河北省电力有限公司物资分公司 | Electric power material supply chain system based on intelligent operation center and construction and application thereof |
Non-Patent Citations (1)
| Title |
|---|
| 马骠;: "智能报表平台的设计和应用", 电子制作, no. 2, pages 104 - 106 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109408337B (en) | Interface operation and maintenance method and device | |
| US6617969B2 (en) | Event notification system | |
| US8285580B2 (en) | System and method for filtering exceptions generated by forecasting and replenishment engine | |
| US8484662B2 (en) | Systems and/or methods for end-to-end business process management, business event management, and/or business activity monitoring | |
| US20080065451A1 (en) | System and method for converting electronic orders to work orders | |
| US20070208587A1 (en) | Systems, software, and methods for communication-based business process messaging | |
| US20030018643A1 (en) | VIGIP006 - collaborative resolution and tracking of detected events | |
| US20210334717A1 (en) | Electronic Message Management Program Coordinating Defined Activity And Controlled Recipient/Respondents Through A Unique Id | |
| US20020156601A1 (en) | Event monitoring and detection system | |
| CN112561494A (en) | Automatic flow system and method thereof | |
| US20140156763A1 (en) | Person centric feeds and direct messaging in business systems | |
| JP4782619B2 (en) | Management support apparatus, management support method, and computer program for managing correspondence with electronic mail | |
| CN101094203A (en) | Method and system for selecting receivers in instant communication tool in corporation | |
| CN113434742A (en) | Account screening method and device, storage medium and electronic device | |
| CN1971597A (en) | Method and system for displaying history of e-mail | |
| CN113537895A (en) | Logistics operation report system | |
| CN113114557B (en) | Message sending method and device, electronic equipment and storage medium | |
| CN112000870A (en) | Declaration scheme generation method and system based on user information | |
| CN108063788A (en) | Interactive file management system | |
| US20230328015A1 (en) | Technique for exchanging information between at least two communication entities | |
| JP2000082026A (en) | Matter management system | |
| CN113765773B (en) | Method and device for processing communication record | |
| CN115914160A (en) | Method and device for configuring e-mail sending parameters, electronic equipment and storage medium | |
| CN116385073A (en) | Information sending method and device | |
| CN115470875A (en) | Intelligent server checking system |
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 |