Schedule data table editing method and device, equipment and storage medium
By generating an editing interface and using Boolean identifiers to transfer scheduling data, the problem of low efficiency in updating traditional schedule data tables is solved, enabling direct editing and efficient updates, supporting multi-user interaction and enhancing user experience.
Patent Information
- Application Number
- CN202511600935.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-11-04
- Publication Date
- 2026-02-10
AI Technical Summary
In traditional calendar data editing methods, the format is fixed, and users need to return to the preset calendar component to re-edit when updating the schedule data, resulting in low update efficiency.
By generating an editing interface in response to user actions, Boolean identifiers are used to transfer scheduling data from the selected data frame to the unselected data frame, and corresponding data is deleted from the selected data frame, enabling direct editing and improving update efficiency.
It enables direct editing of schedule data tables, improves update efficiency, supports multiple modifications or deletions of schedule data, dynamically controls schedule data tables, avoids chaos caused by multiple editors, and enhances user experience.
Smart Images
Figure CN121503446A_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of computer technology, and in particular to a method, apparatus, device and storage medium for editing schedule data tables. Background Technology
[0002] A schedule spreadsheet is a tool for systematically recording and managing the schedules of individuals or teams. It is typically presented in tabular form and includes key fields such as date, time, and participants. It clearly displays plans for different time periods, helping users manage time efficiently and avoid conflicts, making it an important tool for improving scheduling efficiency.
[0003] In related technologies, the traditional method of editing schedule data tables mainly involves generating corresponding calendar cells, i.e., schedule data tables, through user editing operations on preset calendar components when schedule scheduling is required, in order to display the scheduling data.
[0004] However, in related technologies, the schedule data table generated by each user editing on the preset calendar component has a fixed format. When a user updates the schedule data, they need to return to the preset calendar component to re-edit it, which is a cumbersome process and makes the update efficiency of the schedule data table low. Summary of the Invention
[0005] This application provides a method, apparatus, device, and storage medium for editing a schedule data table, in order to solve the problem in the related art where the schedule data table generated by each user editing on a preset calendar component has a fixed format, and when the user updates the schedule data, they need to return to the preset calendar component to re-edit it, which is a cumbersome process and results in low update efficiency of the schedule data table.
[0006] In a first aspect, this application provides a method for editing a schedule data table, applied to a computer device, comprising:
[0007] In response to the user's selection of any one of the multiple schedule data tables pre-displayed on the display interface, the schedule data table is retrieved;
[0008] Obtain the user's user information and determine whether the user has editing permissions based on the user information;
[0009] If it is determined that the user has editing permissions, then an edit button corresponding to the schedule data table is generated;
[0010] In response to a click on the edit button, an editing interface corresponding to the schedule data table is generated, wherein the editing interface includes a selected data frame and an unselected data frame;
[0011] Determine whether a Boolean identifier exists in the editing interface; the Boolean identifier is used to mark multiple sets of scheduling data in the selected data frame.
[0012] If it is determined that the Boolean identifier exists in the editing interface, then in response to the selection operation of the multiple sets of first shift data in the selected data box, one or more sets of first shift data are transferred to the unselected data box;
[0013] After the transfer of one or more sets of first shift data is completed, delete one or more sets of shift data in the selected data box to complete the editing of multiple sets of first shift data in the selected data box and obtain the edited schedule data table.
[0014] In one possible design, the process of displaying the multiple schedule data tables includes: obtaining the first month data of the current month, and obtaining the second month data of the adjacent month based on the current month; integrating the first month data and the second month data into the final month data; extracting all shift schedule data from the final month data; generating one or more corresponding schedule data tables based on all shift schedule data, and outputting each schedule data table to the display interface according to a preset sorting rule.
[0015] In one possible design, each schedule data table includes multiple sets of shift data; correspondingly, after generating one or more schedule data tables based on all the shift data, the method further includes: obtaining the number of sets of shift data in each schedule data table; determining whether the number of sets exceeds a preset threshold; if the number of sets exceeds the preset threshold, displaying one or more sets of shift data that do not exceed the preset threshold in the schedule data table; hiding the remaining shift data in the multiple sets of shift data, and generating a "More" button on the schedule data table, the "More" button being used to display the hidden remaining shift data according to a preset display method.
[0016] In one possible design, generating the editing interface corresponding to the schedule data table in response to a click on the edit button includes: determining whether another user is editing the schedule data table in response to a click on the edit button; if it is determined that another user is editing the schedule data table, generating an editing prompt; if it is determined that no other user is editing the schedule data table, generating the editing interface corresponding to the schedule data table.
[0017] In one possible design, after the transfer of one or more sets of first shift data is completed, the one or more sets of shift data are deleted from the selected data box to complete the editing of the multiple sets of first shift data in the selected data box and obtain the edited schedule data table. The design further includes: if it is determined that the Boolean identifier does not exist in the editing interface, then in response to the selection operation of the multiple sets of second shift data in the unselected data box, the one or more sets of second shift data are transferred to the selected data box; after the transfer of one or more sets of second shift data is completed, the one or more sets of second shift data are deleted from the unselected data box to complete the editing of the multiple sets of first shift data in the selected data box and obtain the edited schedule data table.
[0018] In one possible design, after the transfer of one or more sets of second schedule data is completed, the one or more sets of second schedule data are deleted from the unselected data box to complete the editing of multiple sets of first schedule data in the selected data box. After obtaining the edited schedule data table, the design further includes: in response to the selection operation of the edited schedule data table, displaying the schedule data in the edited schedule data table, wherein the schedule data includes at least the user information; and in response to the click operation of the user information, displaying all the user's schedule data.
[0019] In one possible design, the schedule data table has a tree-shaped switch; correspondingly, after retrieving the schedule data table in response to the user's selection operation of any one of the multiple schedule data tables pre-displayed on the display interface, the method further includes: in response to the operation of turning on the tree-shaped switch on the schedule data table, converting the schedule data table from a non-tree-shaped display format to a tree-shaped display format; or, in response to the operation of turning off the tree-shaped switch on the schedule data table, converting the schedule data table from a tree-shaped display format to a non-tree-shaped display format.
[0020] Secondly, this application provides a schedule data table editing device, applied to a computer device, comprising:
[0021] The retrieval module is used to retrieve the schedule data table in response to the user's selection operation of any one of the multiple schedule data tables pre-displayed on the display interface.
[0022] The first judgment module is used to obtain the user's user information and determine whether the user has editing permissions based on the user information;
[0023] The first generation module is used to generate an edit button corresponding to the schedule data table if it is determined that the user has editing permissions.
[0024] The second generation module is used to generate an editing interface corresponding to the schedule data table in response to the click operation of the edit button, wherein the editing interface includes a selected data frame and an unselected data frame;
[0025] The second judgment module is used to determine whether there is a Boolean identifier in the editing interface, and the Boolean identifier is used to mark multiple sets of scheduling data in the selected data box;
[0026] The first transfer module is used to transfer one or more sets of first shift data to the unselected data box in response to a selection operation of the multiple sets of first shift data in the selected data box if the Boolean identifier is determined to exist in the editing interface.
[0027] The first deletion module is used to delete one or more sets of first shift schedule data from the selected data frame after the transfer of one or more sets of first shift schedule data is completed, thereby completing the editing of multiple sets of first shift schedule data in the selected data frame and obtaining an edited schedule data table.
[0028] Thirdly, this application provides a computer device, including: at least one processor and a memory;
[0029] The memory stores computer-executed instructions;
[0030] The at least one processor executes computer execution instructions stored in the memory, causing the at least one processor to perform the schedule data table editing method as described in the first aspect and various possible designs of the first aspect.
[0031] Fourthly, this application provides a computer storage medium storing computer execution instructions, which, when executed by a processor, implement the schedule data table editing method described in the first aspect and various possible designs of the first aspect.
[0032] The schedule data table editing method, apparatus, device, and storage medium provided in this application retrieve the schedule data table in response to a user's selection operation of any one of multiple schedule data tables pre-displayed on the display interface; obtain the user's user information, and if it is determined that the user has editing permissions, generate an edit button corresponding to the schedule data table; in response to the click operation of the edit button, generate an editing interface corresponding to the schedule data table; determine whether there is a Boolean identifier in the editing interface, and if it is determined that there is a Boolean identifier, in response to the selection operation of multiple sets of first shift data in the selected data box, transfer one or more sets of first shift data to the unselected data box; after the transfer of one or more sets of first shift data is completed, delete one or more sets of shift data in the selected data box to complete the editing of multiple sets of first shift data in the selected data box, and obtain the edited schedule data table. Through the collaboration of the edit button, Boolean identifier, selected data box, and unselected data box, the direct editing of the schedule data table is realized, thereby improving the update efficiency of the schedule data table. Attached Figure Description
[0033] To more clearly illustrate the technical solutions in the embodiments of this application or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.
[0034] Figure 1 This is a schematic diagram illustrating an application scenario of the schedule data table editing method provided in the embodiments of this application;
[0035] Figure 2 Flowchart of the schedule data table editing method provided in the embodiments of this application Figure 1 ;
[0036] Figure 3 Flowchart of the schedule data table editing method provided in the embodiments of this application Figure 2 ;
[0037] Figure 4 A schematic diagram of the structure of the schedule data table editing device provided in the embodiments of this application;
[0038] Figure 5 This is a schematic diagram of the hardware structure of a computer device provided in an embodiment of this application. Detailed Implementation
[0039] To make the objectives, technical solutions, and advantages of the embodiments of this application clearer, the technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of this application, not all embodiments. Based on the embodiments of this application, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of this application.
[0040] A schedule data table is a tool for systematically recording and managing the schedules of individuals or teams. It is typically presented in tabular form and includes key fields such as date, time, and participants. It clearly displays plans for different time periods, helping users manage time efficiently and avoid conflicts, making it an important tool for improving scheduling efficiency. In related technologies, traditional schedule data table editing methods primarily rely on user editing operations on preset calendar components to generate corresponding calendar cells, i.e., schedule data tables, to display scheduling data. However, in these technologies, the schedule data tables generated by users editing on preset calendar components have a fixed format. When users update scheduling data, they need to return to the preset calendar component to re-edit, a cumbersome process that results in low update efficiency for schedule data tables.
[0041] To address the aforementioned technical problems, this application proposes the following technical concept: Considering the retrieved schedule data table, the inventors generate an editing interface for the schedule data table based on the edit button on the schedule data table. Boolean identifiers are used to transfer one or more sets of first shift data from the selected data frame to the unselected data frame, and one or more sets of shift data are deleted from the selected data frame to complete the editing of multiple sets of first shift data in the selected data frame, thereby obtaining the edited schedule data table, which improves the update efficiency of the schedule data table.
[0042] Figure 1 This is a schematic diagram illustrating an application scenario of the schedule data table editing method provided in the embodiments of this application.
[0043] like Figure 1 As shown, the scenario includes a display terminal 101 and a computer device 102.
[0044] The display terminal 101 can be a display screen or a personal computer or other terminal.
[0045] Computer device 102 can be a standalone device or a cluster of multiple devices.
[0046] Computer device 102, in response to a user's selection operation of any one of the multiple schedule data tables displayed on the display interface of display terminal 101, retrieves the schedule data table; obtains the user's user information and determines whether the user has editing permissions based on the user information; if the user is determined to have editing permissions, an edit button corresponding to the schedule data table is generated; in response to the click operation of the edit button, an editing interface corresponding to the schedule data table is generated on display terminal 101, wherein the editing interface includes a selected data frame and an unselected data frame; it determines whether a Boolean identifier exists in the editing interface, the Boolean identifier is used to mark multiple sets of shift data in the selected data frame; if the Boolean identifier exists in the editing interface, in response to the selection operation of multiple sets of first shift data in the selected data frame, one or more sets of first shift data are transferred to the unselected data frame; after the transfer of one or more sets of first shift data is completed, one or more sets of shift data are deleted from the selected data frame to complete the editing of multiple sets of first shift data in the selected data frame, obtaining the edited schedule data table, and displaying the edited schedule data table on display terminal 101. The following detailed embodiments provide a further explanation.
[0047] Figure 2 Flowchart of the schedule data table editing method provided in the embodiments of this application Figure 1 The execution entity in this embodiment can be Figure 1 The computer equipment shown in the illustrated embodiment is not specifically limited in this embodiment. Figure 2 As shown, the method includes:
[0048] S201: In response to the user's selection of any one of the multiple schedule data tables pre-displayed on the display interface, retrieve the schedule data table.
[0049] In this embodiment, each schedule data table is a schedule form corresponding to each date.
[0050] The schedule data table includes one or more of the following structures: current date, edit button, query interface, tree toggle, multiple sets of shift data, and more buttons.
[0051] The edit button is a virtual button used to edit the schedule data table, and it will only be generated when the user has editing permissions.
[0052] The query interface is used to query the schedule of personnel.
[0053] The tree-shaped switch is a virtual switch used to switch the display style of multiple sets of scheduling data.
[0054] Each set of scheduling data includes the branch company name, department name, and scheduled personnel.
[0055] The "More" button is a virtual button used to expand multiple sets of scheduling data.
[0056] In this embodiment, the schedule data table has a tree-shaped switch; correspondingly, after step S201, steps a~b are also included:
[0057] Step a: In response to the toggle switch on the schedule data table, convert the schedule data table from a non-tree view format to a tree view format; or,
[0058] Specifically, step a is as follows: in response to the operation of turning on the tree view switch on the schedule data table, convert the multiple sets of scheduling data in the schedule data table from a non-tree view format to a tree view format.
[0059] For example, the non-tree-shaped display format of multiple sets of scheduling data is as follows: the header is the scheduling personnel, followed by the branch name, department name and personnel A, the branch name, department name and personnel B, the branch name, department name and personnel C, and the branch name, department name and personnel D, arranged from top to bottom.
[0060] In this embodiment, the tree-like display format of multiple sets of scheduling data adopts a parent-child structure, that is, the branch name is the parent level, and the department name and the scheduled personnel are the child level. The data can be expanded and collapsed by clicking the + and - symbols.
[0061] Furthermore, an example of a schedule data table displayed in a tree-like format is shown below:
[0062] Day: 2024-12-01 (Date); ID: 1 (Unique identifier for parent); name: Branch name (Parent name); ID: 1-1 (Unique identifier for child); name: Partial name (Child name); data: Scheduled personnel (Data contained in the child).
[0063] Step b: In response to the closing operation of the tree view switch on the schedule data table, convert the schedule data table from a tree view format to a non-tree view format.
[0064] Specifically, step b is as follows: in response to the closing operation of the tree view switch on the schedule data table, the multiple sets of scheduling data in the schedule data table are converted from a tree view format to a non-tree view format.
[0065] S202: Obtain the user's information and determine whether the user has editing permissions based on the user information.
[0066] Specifically, step S202 includes steps a~b:
[0067] Step a: Obtain the user ID corresponding to the user's user information, as well as the preset ID and permission association table.
[0068] For example, the ID and permission association table includes multiple user IDs and the edit permissions mapped to each user ID.
[0069] Step b: Determine whether the user has editing permissions based on the user ID and the ID-permission association table.
[0070] S203: If it is determined that the user has editing permissions, then generate the edit button corresponding to the schedule data table.
[0071] S204: In response to a click on the edit button, generate an editing interface for the schedule data table, wherein the editing interface includes selected data frames and unselected data frames.
[0072] The selected data frame and the unselected data frame each contain the corresponding shift schedule data.
[0073] Specifically, step S204 includes steps a~c:
[0074] Step a: In response to a click on the edit button, determine if another user is editing the schedule data table.
[0075] Step b: If it is determined that another user is editing the schedule data table, an editing prompt will be generated.
[0076] In this embodiment, the prompt during editing includes a prompt header, prompt content, and a response interface.
[0077] For example, the prompt header is: Prompt; the prompt content is: This date is being edited by staff, please try again later; the response interface is: OK.
[0078] Step c: If it is determined that the schedule data table is not edited by another user, then generate the editing interface corresponding to the schedule data table.
[0079] S205: Determine if a Boolean flag exists in the editing interface. The Boolean flag is used to mark multiple sets of scheduling data in the selected data frame.
[0080] In this embodiment, the Boolean identifier can be the isCheck identifier or other identifiers.
[0081] Here, isCheck is a boolean variable used to indicate whether a certain state needs to be checked or verified.
[0082] S206: If it is determined that there is a Boolean flag in the editing interface, then in response to the selection operation of multiple sets of first shift data in the selected data box, one or more sets of first shift data are transferred to the unselected data box.
[0083] S207: After one or more sets of first shift data have been transferred, delete one or more sets of shift data in the selected data box to complete the editing of multiple sets of first shift data in the selected data box and obtain the edited schedule data table.
[0084] In addition, after step S207, the method further includes: determining the first interface parameter of the preset interface based on the edited schedule data table, and marking the edited schedule data table as data import; updating the database table of the edited schedule data table through the preset interface and the first interface parameter, and refreshing the display interface.
[0085] The first interface parameter includes the current date and the first shift data to be transferred.
[0086] Furthermore, the edited schedule data table is confirmed and then saved.
[0087] In addition, after step S207, steps a~b are also included:
[0088] Step a: If it is determined that there is no Boolean flag in the editing interface, then in response to the selection operation of multiple sets of second shift data in the unselected data box, one or more sets of second shift data are transferred to the selected data box.
[0089] Step b: After one or more sets of second shift data have been transferred, delete one or more sets of second shift data in the unselected data box to complete the editing of multiple sets of first shift data in the selected data box, and obtain the edited schedule data table.
[0090] In addition, after step S207, the method further includes: determining the second interface parameters of the preset interface based on the edited schedule data table, and marking the edited schedule data table as data export; updating the database table of the edited schedule data table through the preset interface and the second interface parameters, and refreshing the display interface.
[0091] The second interface parameters include the current date and the transferred second shift data.
[0092] In addition, after step b, steps c to d are also included:
[0093] Step c: In response to the selection operation of the edited schedule data table, display the scheduling data in the edited schedule data table, which includes at least user information.
[0094] The user information is used to indicate that the user is a scheduler.
[0095] Step d: In response to a click on user information, display all of the user's schedule data.
[0096] In summary, the schedule data table editing method provided in this embodiment retrieves the schedule data table in response to a user's selection operation of any of the multiple schedule data tables pre-displayed on the display interface; obtains the user's user information, and if it is determined that the user has editing permissions, generates an edit button corresponding to the schedule data table; in response to the click operation of the edit button, generates an editing interface corresponding to the schedule data table; determines whether a Boolean identifier exists in the editing interface, and if it is determined that a Boolean identifier exists, in response to the selection operation of multiple sets of first shift data in the selected data box, transfers one or more sets of first shift data to the unselected data box; after the transfer of one or more sets of first shift data is completed, one or more sets of shift data are deleted from the selected data box to complete the editing of multiple sets of first shift data in the selected data box, resulting in an edited schedule data table. Through the collaboration of the edit button, Boolean identifier, selected data box, and unselected data box, direct editing of the schedule data table is realized, thereby improving the update efficiency of the schedule data table.
[0097] In addition, the schedule data table editing method provided in this embodiment allows for multiple modifications or deletions of the corresponding shift data through direct editing of the schedule data table, enabling dynamic control of the schedule data table.
[0098] In addition, the schedule data table editing method provided in this embodiment can retrieve the schedule data table in response to the user's selection operation of any schedule data table among the multiple schedule data tables pre-displayed on the display interface, so as to realize the control of editing the schedule data table corresponding to any date.
[0099] In addition, the schedule data table editing method provided in this embodiment determines whether another user is editing the schedule data table in response to the click operation of the edit button; if it is determined that another user is editing the schedule data table, an editing prompt is generated; if it is determined that no other user is editing the schedule data table, an editing interface corresponding to the schedule data table is generated. By supporting the operation restriction of multiple people interacting with the calendar, the problem of schedule data table confusion caused by multiple people editing the same schedule data table is avoided.
[0100] In addition, the schedule data table editing method provided in this embodiment displays the scheduling data in the edited schedule data table in response to the selection operation of the edited schedule data table. The scheduling data includes at least user information. In response to the click operation of the user information, all the user's schedule data is displayed, so that the user can clearly understand their own scheduling situation and improve the user experience.
[0101] Figure 3 Flowchart of the schedule data table editing method provided in the embodiments of this application Figure 2 In the embodiments of this application, in Figure 2 Based on the provided embodiments, a detailed explanation of the specific implementation method for displaying multiple schedule data tables in S201 is given. For example... Figure 3 As shown, the method includes:
[0102] S301: Get the first month data of the current month, and get the second month data of the adjacent month based on the current month.
[0103] In this embodiment, adjacent months are the month before and the month after the current month.
[0104] S302: Integrate the data from the first month and the second month into the final month's data.
[0105] S303: Extract all scheduling data from the final month's data.
[0106] S304: Generate one or more corresponding schedule data tables based on all scheduling data, and output each schedule data table to the display interface according to the preset sorting rules.
[0107] In this embodiment, each shift data corresponds to only one date, but each date may include multiple shift data.
[0108] In this embodiment, the preset sorting rule is to expand each schedule data table according to the date order of the previous month, the current month, and the next month.
[0109] In this embodiment, each schedule data table includes multiple sets of shift data; correspondingly, after generating one or more schedule data tables based on all shift data in step S304, steps a~d are also included:
[0110] Step a: Obtain the number of groups of multiple schedule data in each schedule data table.
[0111] Step b: Determine whether the number of groups exceeds the preset group number threshold.
[0112] In this embodiment, the preset group number threshold can be any one of 3, 4 or 5, or other thresholds.
[0113] Step c: If the number of groups exceeds the preset group number threshold, then display one or more groups of scheduling data that do not exceed the preset group number threshold in the schedule data table.
[0114] Step d: Hide the remaining scheduling data in multiple sets of scheduling data, and generate more buttons on the schedule data table. More buttons are used to display the hidden remaining scheduling data in a preset display mode.
[0115] In this embodiment, the preset display method can be a pop-up window or other display methods.
[0116] In summary, the schedule data table editing method provided in this embodiment obtains the first month's data of the current month and the second month's data of the adjacent month based on the current month; integrates the first month's data and the second month's data into the final month's data; extracts all scheduling data from the final month's data; generates one or more corresponding schedule data tables based on all scheduling data; and outputs each schedule data table to the display interface according to a preset sorting rule. By displaying schedule data tables for three months in total, the scope of schedule data display is increased, and the barrier that schedule data tables can only display data for the current month is broken.
[0117] In addition, the schedule data table editing method provided in this embodiment allows for the display of hidden remaining scheduling data by setting more buttons, thus enabling the display of the full amount of scheduling data.
[0118] It should be noted that this application also introduces the Ant Design Calendar component, sets the initialization mode to month switching: mode="month", sets the dateCellRender property, and adds a date cell renderer to obtain the corresponding schedule data based on the currently displayed month title (current month, previous month, or next month) and render the corresponding content. If the date is a future date, an "Add Schedule" button will be displayed; otherwise, the schedule information corresponding to that date will be displayed. The onChange callback method, i.e., the callback method for date changes, can also be set later.
[0119] Figure 4 This is a schematic diagram of the structure of a schedule data table editing device provided in an embodiment of this application. Figure 4 As shown, the schedule data table editing device includes: a retrieval module 401, a first judgment module 402, a first generation module 403, a second generation module 404, a second judgment module 405, a first transfer module 406, and a first deletion module 407.
[0120] The retrieval module 401 is used to retrieve the schedule data table in response to the user's selection operation of any schedule data table among the multiple schedule data tables pre-displayed on the display interface.
[0121] The first judgment module 402 is used to obtain the user's user information and determine whether the user has editing permissions based on the user information;
[0122] The first generation module 403 is used to generate an edit button corresponding to the schedule data table if it is determined that the user has editing permissions.
[0123] The second generation module 404 is used to generate an editing interface corresponding to the schedule data table in response to the click operation of the edit button, wherein the editing interface includes a selected data frame and an unselected data frame;
[0124] The second judgment module 405 is used to determine whether there is a Boolean identifier in the editing interface. The Boolean identifier is used to mark multiple sets of scheduling data in the selected data frame.
[0125] The first transfer module 406 is used to transfer one or more sets of first shift data to the unselected data box in response to the selection operation of multiple sets of first shift data in the selected data box if it is determined that there is a Boolean identifier in the editing interface.
[0126] The first deletion module 407 is used to delete one or more sets of schedule data in the selected data frame after the transfer of one or more sets of first schedule data is completed, so as to complete the editing of multiple sets of first schedule data in the selected data frame and obtain the edited schedule data table.
[0127] In one possible implementation, the device further includes:
[0128] The first acquisition module is used to acquire the first month's data for the current month, and to acquire the second month's data for the adjacent month based on the current month;
[0129] The integration module is used to combine the data from the first month and the second month into the final month's data;
[0130] The extraction module is used to extract all shift schedule data from the final month's data;
[0131] The third generation module is used to generate one or more corresponding schedule data tables based on all scheduling data, and output each schedule data table to the display interface according to the preset sorting rules.
[0132] In one possible implementation, the device further includes:
[0133] The second acquisition module is used to acquire the number of groups of multiple shift schedule data in each schedule data table;
[0134] The third judgment module is used to determine whether the number of groups exceeds the preset group number threshold.
[0135] The first display module is used to display one or more sets of scheduling data that do not exceed the preset number of groups to the schedule data table if the number of groups exceeds the preset number of groups threshold.
[0136] The fourth generation module is used to hide the remaining scheduling data in multiple sets of scheduling data and generate more buttons on the schedule data table. The more buttons are used to display the hidden remaining scheduling data according to the preset display method.
[0137] In one possible implementation, the second generation module 404 specifically includes:
[0138] The judgment unit is used to determine whether the schedule data table is being edited by another user in response to a click operation on the edit button;
[0139] The first generation unit is used to generate an editing prompt if it is determined that the schedule data table is being edited by another user.
[0140] The second generation unit is used to generate the editing interface corresponding to the schedule data table if it is determined that the schedule data table is not edited by another user.
[0141] In one possible implementation, the device further includes:
[0142] The second transfer module is used to transfer one or more sets of second shift data to the selected data frame in response to the selection operation of multiple sets of second shift data in the unselected data frame if it is determined that there is no Boolean identifier in the editing interface.
[0143] The second deletion module is used to delete one or more sets of second shift data in the unselected data box after the transfer of one or more sets of second shift data is completed, so as to complete the editing of multiple sets of first shift data in the selected data box and obtain the edited schedule data table.
[0144] In one possible implementation, the device further includes:
[0145] The second display module is used to respond to the selection operation of the edited schedule data table and display the scheduling data in the edited schedule data table, which includes at least user information;
[0146] The third display module is used to display all of the user's schedule data in response to clicks on user information.
[0147] In one possible implementation, the device further includes:
[0148] The first conversion module is used to convert the schedule data table from a non-tree-view format to a tree-view format in response to the on / off operation of the tree view switch on the schedule data table; or,
[0149] The second conversion module is used to convert the schedule data table from a tree-view format to a non-tree-view format in response to the operation of turning off the tree view switch on the schedule data table.
[0150] The apparatus provided in this embodiment can be used to execute the technical solutions of the above method embodiments. Its implementation principle and technical effects are similar, and will not be described again here.
[0151] Figure 5 This is a schematic diagram of the hardware structure of a computer device provided in an embodiment of this application. Figure 5 As shown, the computer device of this embodiment includes: a processor 501 and a memory 502; the memory stores computer execution instructions; at least one processor executes the computer execution instructions stored in the memory, causing at least one processor to execute the above-described schedule data table editing method.
[0152] Alternatively, the memory 502 can be either standalone or integrated with the processor 501.
[0153] When the memory 502 is set up independently, the computer device also includes a bus 503 for connecting the memory 502 and the processor 501.
[0154] This application also provides a computer storage medium storing computer execution instructions. When the processor executes the computer execution instructions, the above-mentioned schedule data table editing method is implemented.
[0155] This application also provides a computer program product, including a computer program that, when executed by a processor, implements the above-described method for editing a schedule data table.
[0156] In the several embodiments provided in this application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are merely illustrative; for instance, the division of modules is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple modules may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be indirect coupling or communication connection through some interfaces, devices, or modules, and may be electrical, mechanical, or other forms.
[0157] The modules described as separate components may or may not be physically separate. The components shown as modules may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to implement the solution of this embodiment according to actual needs.
[0158] Furthermore, the functional modules in the various embodiments of this application can be integrated into one processing unit, or each module can exist physically separately, or two or more modules can be integrated into one unit. The unit composed of the above modules can be implemented in hardware or in the form of hardware plus software functional units.
[0159] The integrated modules described above, implemented as software functional modules, can be stored in a computer-readable storage medium. These software functional modules, stored in a storage medium, include several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) or processor to execute some steps of the methods of the various embodiments of this application.
[0160] It should be understood that the aforementioned processor can be a Central Processing Unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), etc. A general-purpose processor can be a microprocessor or any conventional processor. The steps of the method disclosed in this invention can be directly manifested as execution by a hardware processor, or execution by a combination of hardware and software modules within the processor.
[0161] The memory may include high-speed RAM, and may also include non-volatile storage (NVM), such as at least one disk storage device, and may also be a USB flash drive, external hard drive, read-only memory, disk or optical disc, etc.
[0162] The bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. Buses can be categorized as address buses, data buses, control buses, etc. For ease of illustration, the buses shown in the accompanying drawings are not limited to a single bus or a single type of bus.
[0163] The aforementioned storage media can be implemented from any type of volatile or non-volatile storage device or a combination thereof, such as Static Random-Access Memory (SRAM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Erasable Programmable Read-Only Memory (EPROM), Programmable Read-Only Memory (PROM), Read-Only Memory (ROM), magnetic storage, flash memory, magnetic disk, or optical disk. The storage media can be any available medium accessible to general-purpose or special-purpose computers.
[0164] An exemplary storage medium is coupled to a processor, enabling the processor to read information from and write information to the storage medium. Alternatively, the storage medium can be an integral part of the processor. Both the processor and the storage medium can reside in an Application Specific Integrated Circuit (ASIC). Alternatively, the processor and storage medium can exist as discrete components in an electronic device or host device.
[0165] Those skilled in the art will understand that all or part of the steps of the above-described method embodiments can be implemented by hardware related to program instructions. The aforementioned program can be stored in a computer-readable storage medium. When executed, the program performs the steps of the above-described method embodiments; and the aforementioned storage medium includes various media capable of storing program code, such as ROM, RAM, magnetic disks, or optical disks.
[0166] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of this application, and are not intended to limit them. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some or all of the technical features therein. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of this application.
Claims
1. A method for editing a schedule data table, characterized in that, Applied to computer equipment, including: In response to the user's selection of any one of the multiple schedule data tables pre-displayed on the display interface, the schedule data table is retrieved; Obtain the user's user information and determine whether the user has editing permissions based on the user information; If it is determined that the user has editing permissions, then an edit button corresponding to the schedule data table is generated; In response to a click on the edit button, an editing interface corresponding to the schedule data table is generated, wherein the editing interface includes a selected data frame and an unselected data frame; Determine whether a Boolean identifier exists in the editing interface; the Boolean identifier is used to mark multiple sets of scheduling data in the selected data frame. If it is determined that the Boolean identifier exists in the editing interface, then in response to the selection operation of the multiple sets of first shift data in the selected data box, one or more sets of first shift data are transferred to the unselected data box; After the transfer of one or more sets of first shift data is completed, delete one or more sets of shift data in the selected data box to complete the editing of multiple sets of first shift data in the selected data box and obtain the edited schedule data table.
2. The method according to claim 1, characterized in that, The process of displaying the multiple schedule data tables includes: Obtain the data for the first month of the current month, and obtain the data for the second month of the adjacent month based on the current month; The data from the first month and the data from the second month are combined into the final monthly data. Extract all shift data from the final monthly data; Generate one or more corresponding schedule data tables based on all the scheduling data, and output each schedule data table to the display interface according to the preset sorting rules.
3. The method according to claim 2, characterized in that, Each schedule data table includes multiple sets of shift data; Accordingly, after generating one or more corresponding schedule data tables based on all the scheduling data, the method further includes: Retrieve the number of groups of multiple shift schedule data in each schedule data table; Determine whether the number of groups exceeds a preset group number threshold; If it is determined that the number of groups exceeds the preset group number threshold, then one or more groups of scheduling data that do not exceed the preset group number threshold will be displayed in the schedule data table. The remaining scheduling data in the multiple sets of scheduling data is hidden, and a "More" button is generated on the schedule data table. The "More" button is used to display the hidden remaining scheduling data in a preset display mode.
4. The method according to claim 1, characterized in that, The step of generating an editing interface corresponding to the schedule data table in response to a click on the edit button includes: In response to a click on the edit button, determine whether the schedule data table is being edited by another user; If it is determined that the schedule data table is being edited by another user, an editing prompt will be generated; If it is determined that the schedule data table is not edited by another user, then an editing interface corresponding to the schedule data table is generated.
5. The method according to claim 1, characterized in that, After the transfer of one or more sets of first shift data is completed, the one or more sets of shift data are deleted from the selected data box to complete the editing of multiple sets of first shift data in the selected data box. After obtaining the edited schedule data table, the following steps are also included: If it is determined that the Boolean identifier does not exist in the editing interface, then in response to the selection operation of the multiple sets of second shift data in the unselected data box, one or more sets of second shift data are transferred to the selected data box; After the transfer of one or more sets of second shift data is completed, delete one or more sets of second shift data in the unselected data box to complete the editing of multiple sets of first shift data in the selected data box, and obtain the edited schedule data table.
6. The method according to claim 5, characterized in that, After the transfer of one or more sets of second shift data is completed, the one or more sets of second shift data are deleted from the unselected data box to complete the editing of multiple sets of first shift data in the selected data box. After obtaining the edited schedule data table, the following steps are also included: In response to a selection operation on the edited schedule data table, the shift data in the edited schedule data table is displayed, and the shift data includes at least the user information; In response to a click on the user information, all of the user's schedule data is displayed.
7. The method according to any one of claims 1 to 6, characterized in that, The aforementioned schedule data table has a tree-like switch; Accordingly, after retrieving the schedule data table in response to the user's selection operation of any one of the multiple schedule data tables pre-displayed on the display interface, the method further includes: In response to the operation of turning on the tree view switch on the schedule data table, the schedule data table is converted from a non-tree view format to a tree view format; or, In response to the operation of turning off the tree view switch on the schedule data table, the schedule data table is converted from a tree view format to a non-tree view format.
8. A schedule data table editing device, characterized in that, Applied to computer equipment, including: The retrieval module is used to retrieve the schedule data table in response to the user's selection operation of any one of the multiple schedule data tables pre-displayed on the display interface. The first judgment module is used to obtain the user's user information and determine whether the user has editing permissions based on the user information; The first generation module is used to generate an edit button corresponding to the schedule data table if it is determined that the user has editing permissions. The second generation module is used to generate an editing interface corresponding to the schedule data table in response to the click operation of the edit button, wherein the editing interface includes a selected data frame and an unselected data frame; The second judgment module is used to determine whether there is a Boolean identifier in the editing interface, and the Boolean identifier is used to mark multiple sets of scheduling data in the selected data box; The first transfer module is used to transfer one or more sets of first shift data to the unselected data box in response to a selection operation of the multiple sets of first shift data in the selected data box if the Boolean identifier is determined to exist in the editing interface. The first deletion module is used to delete the one or more sets of first shift data in the selected data box after the transfer of the one or more sets of first shift data is completed, so as to complete the editing of the multiple sets of first shift data in the selected data box and obtain the edited schedule data table.
9. A computer device, characterized in that, include: At least one processor and memory; The memory stores computer-executed instructions; The at least one processor executes computer execution instructions stored in the memory, causing the at least one processor to perform the schedule data table editing method as described in any one of claims 1 to 7.
10. A computer storage medium, characterized in that, The computer storage medium stores computer execution instructions, and when the processor executes the computer execution instructions, it implements the schedule data table editing method as described in any one of claims 1 to 7.