JP5001887B2 - Related process display device, related process display method, and related process display program - Google Patents

Description

  The present invention relates to a related process display device, a related process display method, and a related process display program.

In business process management, a method of displaying a plurality of activities constituting a business in time series is generally used to make it easy to visually understand the progress of the business. The process displayed in this way is called a “Gantt chart”, and usually a line segment or rectangular bar indicating the activity is arranged for each line on a plane with the horizontal axis as the time axis. A mark indicating the progress status is attached to or a related activity is connected with a line.
Patent Document 1 discloses a technique for displaying activities after a start time and an end time are expressed by a start point and an end point of a line segment and connected by a line indicating a progress state.
Japanese Patent Application Laid-Open No. 2004-228561 discloses a technique for indicating the relevance of an activity with an arrow and displaying a line indicating the progress of the activity and a progress rate.
JP-A-6-3332909 (paragraphs 0005 to 0007, FIG. 5) Japanese Patent Laid-Open No. 7-113323 (paragraphs 0005 to 0006, FIG. 5)

  However, the activities related to each other are not always displayed entirely on the screen. Further, when an operation such as enlarging a specific activity is performed by the user, it may frequently occur that a part of the related activity protrudes from the screen. In such a case, it is necessary for the user to perform operations such as further scrolling the screen and changing the scale in order to list all the activities related to each other. Patent Documents 1 and 2 do not disclose a technique for displaying the entire related activities without any user operation.

  Accordingly, an object of the present invention is to provide a related process display device, a related process display method, and a related process display program for displaying the entire related activity on the screen without any special operation by the user.

  The related process display device of the present invention is based on a given setting based on the earliest date, the latest date among the start dates of all activities belonging to the business, and the number of activities. The date and the maximum number of activities that can be displayed are acquired, stored as a display record, and a graphic indicating the activity is displayed based on the display record. This setting is performed so that all activities are not disconnected from the screen. When the figure is in a state such as being disconnected from the screen by the user's operation, it is corrected to a display state in which all activities are not disconnected from the screen in accordance with a given setting without any user's operation.

  According to the present invention, it is possible to provide a related process display device, a related process display method, and a related process display program for displaying an entire related activity on a screen without any special operation by a user.

  Hereinafter, the best mode for carrying out the present invention (hereinafter referred to as “the present embodiment”) will be described in detail with reference to the drawings.

(Hardware configuration)
FIG. 1 is a hardware configuration diagram according to the present embodiment.
The related process display device 1 includes a central control device (control unit) 13, an input device (input unit) 11, an output device (output unit) 12, a main storage device (storage unit) 14, and An auxiliary storage device (storage unit) 15 is included.
The auxiliary storage device 15 stores an activity information database 31, a progress situation database 32, and a related information database 33. A display state table 23 is stored in the main storage device 14.
The “first database”, “second database”, “third database”, and “fourth database” include an activity information database 31, a related information database 33, a display state table 23, and a progress information database. 32 corresponds to each.
The activity information management unit 21 and the Gantt chart display processing unit 22 are programs. Hereinafter, when the subject is described as “XX section”, the central control device 13 reads each program from the auxiliary storage device 15 as necessary and loads it into the main storage device 14 to load each function (described later). Shall be executed. The related process display device 1 may be a general server computer, personal computer, or the like.

(Activity information database 31)
FIG. 2 is a diagram illustrating an example of an activity information database according to the present embodiment. The activity information database 31 is a database indicating correspondence relationships such as activities, business names to which the activities belong, start dates of the activities, and end dates of the activities.
In association with the activity ID stored in the activity ID (Identification) column 201, the activity name column 202 has an activity name, the business ID column 203 has a business ID, the business name column 204 has a business name, and a start date column. 205 stores a start date, and an end date column 206 stores an end date.

The activity ID in the activity ID column 201 is an identifier that uniquely identifies the activity name.
The activity name in the activity name column 202 is a name given to the activity (element constituting the business).
The business ID in the business ID column 203 is an identifier that uniquely identifies a business.
The business name in the business name column 204 is a name given to the business to which the activity belongs.
The start date in the start date column 205 is a date on which work corresponding to the activity is scheduled to start.
The end date in the end date column 206 is a date on which work corresponding to the activity is scheduled to end.
The “identifier indicating activity” corresponds to an activity ID. A “business identifier” corresponds to a business ID. “Activity start date” and “activity end date” correspond to “start date” and “end date”, respectively.

  A record in the activity information database 31 is created for each activity name. By the way, the records in the 1st to 8th lines are 8 activities belonging to the business whose business name is “Inventory management system”, “Market research”, “Conditioning of conditions”, “Budget creation”, “Basic design” "," Execution design "," Cost calculation "," Mounted product selection "and" Customization ". Among them, for example, an activity whose activity name related to the record in the first row is “market research” is started at “20080402” and ended at “20080405”.

(Progress information database 32)
FIG. 3 is a diagram showing an example of the progress information database according to the present embodiment. The progress information database 32 is a database indicating the progress of activities.
Corresponding to the activity ID stored in the activity ID column 211, the activity name column 212 has an activity name, the progress confirmation date column 213 has a progress confirmation date, the progress rate column 214 has a progress rate, and the progress point column 215. Each of them stores a progress point.

The activity ID in the activity ID column 211 is the same as the activity ID in FIG.
The activity name in the activity name column 212 is the same as the activity name in FIG.
The progress confirmation date in the progress confirmation date column 213 is a date on which the progress rate of the activity is confirmed. The progress confirmation date can be arbitrarily selected by the user from the date after the input of activity information (detailed later) is completed. Further, the user can arbitrarily select which activity to confirm the progress rate on a specific progress confirmation date.
The progress rate in the progress rate column 214 is a ratio (percentage) of the business amount that has been completed as of the progress confirmation date among the business amount of the activity.
The progress point in the progress point column 215 is the date to which the time when the number of days (may be a decimal number) obtained by multiplying the number of days from the start date to the end date by the progress rate has elapsed. .
The “information indicating the progress time of the activity” corresponds to the progress point.

A record in the progress information database 32 is created for each combination of activity name and progress confirmation date. By the way, the records in the 1st to 15th lines confirm the progress of 5 activities whose activity names are “market research”, “arrangement of conditions”, “budget creation”, “basic design” and “implementation design”. It is shown that the progress rate is confirmed on the days “20080407”, “20080408”, and “20080409”.
Of these records, for example, the record on the first line indicates that the progress rate of the activity whose activity name is “market research” was “20%” on the progress confirmation date “20080407”, and the progress point as of this progress confirmation date. Indicates “20080402”. As shown in the record in the first line of FIG. 2, the start date is “20080402” and the end date is “20080405”. Therefore, the number of days from the start date to the end date is “4”. It is. Multiply “4” by the progress rate “20%” to obtain “0.8”. The time when the number of days “0.8” has elapsed from midnight of the start date “20080402” is “20080402”. Therefore, the progress point is “20080402”.

(Related information database 33)
FIG. 4 is a diagram showing an example of the related information database according to the present embodiment.
The related information database 33 is a database that stores relationships between activities.
In association with the activity ID stored in the activity ID column 221, the activity name column 222 stores an activity name, and the related group ID column 223 stores a related group ID.
The activity ID in the activity ID column 221 is the same as the activity ID in FIG.
The activity name in the activity name column 222 is the same as the activity name in FIG.
The related group ID in the related group ID column 223 is an identifier that uniquely identifies a related group consisting of mutually related activities among activities belonging to a certain business. For example, an activity arbitrarily selected by the user, such as an activity and a post-process activity started on the assumption that the activity ends, or a plurality of activities executed by the same organization or person in charge belong to a specific related group be able to. Not all activities belonging to a common task belong to the same related group. Furthermore, a specific activity can belong to a plurality of related groups.
Note that “information indicating a group to which a plurality of mutually related activities belong” corresponds to a related group ID.

  The records in the first to sixth lines in FIG. 4 are activities whose activity names are “market research”, “arrangement of conditions”, “basic design”, “implementation design”, “implemented product selection”, and “customization”. Indicates that it belongs to a related group whose related group ID is “C001” (one related group ID corresponds to one progress line 311 in FIG. 6). Although not directly known from FIG. 4, as shown in FIG. 2, these activities belong to a business whose business name is “inventory management system”. Of the activities belonging to the business whose business name is “inventory management system”, the activities whose activity names are “budget creation” and “cost calculation” do not belong to any related group. If an activity with activity names “budget creation” and “costing” is selected as belonging to another related group, for example, two records having the related group ID “C002” are added. It will be.

(Display state table 23)
FIG. 5 is a diagram illustrating an example of a display state table according to the present embodiment. The display state table 23 is a data table that stores the relationship between the range of information that should be displayed for each job and the range that is actually displayed on the screen (the output device 12 in FIG. 1). A Gantt chart is displayed on the screen. While being performed, it is stored in the main storage device 14 (FIG. 1).
In association with the display state ID stored in the display state ID column 231, the business name column 232 has a business name, the business start date column 233 has a business start date, and the business end date column 234 has a business end date. The activity number column 235 stores the number of activities, the display start date column 236 stores the display start date, the display end date column 237 stores the display end date, and the displayable activity number column 238 stores the number of displayable activities. Has been.

The display state ID in the display state ID column 231 is an identifier that uniquely identifies a record. One record corresponds to one display state.
The business name in the business name column 232 is the same as the business name in FIG.
The business start date in the business start date column 233 is the start date of all records in the activity information database 31 (FIG. 2) having the business name (limited to records whose activity names are stored in the related information database 33). Of these, it is the earliest date.
The business end date in the business end date column 234 is the latest among the end dates of all the records in the activity information database 31 having the business name (limited to records whose activity names are stored in the related information database 33). It is a date.
The activity number in the activity number column 235 is the number of activities belonging to the business having the business name.
The display start date in the display start date column 236 is the date (in the activity bar display column 256) displayed on the Gantt chart display screen 41 (the horizontal axis is the date. Details will be described later) displayed on the screen of the output device 12. It is the leftmost (temporally ahead) date among the columns included).
The display start date in the display end date column 237 is the date on the rightmost (after time) of the dates displayed on the screen of the output device 12 (corresponding to the column heading included in the activity bar display column 256). is there.
The displayable activity number in the displayable activity number column 238 is the number of activities that can be displayed in the vertical direction of the screen of the output device 12.
The period of information to be displayed for a certain business (business start date to business end date) and the actual display period (display start date to display end date) are different concepts. Furthermore, the number of activities to be displayed for a certain business and the number of displayable activities actually displayed are different concepts.
Note that the “business start date”, “business end date”, “number of activities belonging to the business”, and “maximum number of activities that can be displayed” are “business start date” and “business end date”, respectively. , “Number of activities” and “number of displayable activities” correspond to these.

  Each record (hereinafter referred to as “display record”) in the display state table 23 corresponds to an individual display state displayed on the screen. The left (reference numerals 231 to 235) from the double line of the record indicates the range of information to be displayed, and the right (reference numerals 236 to 238) indicates the actual display range. Hereinafter, the screen transition will be described along each display record of FIG. 5 and the corresponding Gantt chart display screen 41 (FIGS. 6 to 10).

  First, the record on the first line indicates the following. That is, the business start date of the business whose business name is “inventory management system” is “20080402” and the business end date is “20080423”, whereas the display start date is “20080401” and the display end Since the date is “20080424”, the period of “20080402 to 20080423” is completely included in the period of “20080401 to 20080424”, and the number of activities that can be displayed is “8”. Since it is “10”, all activities can be displayed. That is, in the display state (see FIG. 6) whose display state ID is “D001”, all activity bars (rectangles indicating the start date and end date of the activity are displayed. Corresponds to a figure indicating a period ”in both the horizontal and vertical directions and is not interrupted.

  In the display state where the display state ID of the second row is “D002”, the display end date is shortened to “2008421” compared to the display state of “D001”. Therefore, the part corresponding to “20080422 to 20080423” of the activity bar 288 is not displayed, and the right part is interrupted (see FIG. 7).

  In the display state where the display state ID of the third row is “D003”, the display end date is extended to “20080424” as compared to the display state of “D002” (returns to the display state of “D001”). Therefore, all activity bars are displayed without interruption (see FIG. 6).

  In the display state where the display state ID of the fourth row is “D004”, the display end date is extended to “20080518” as compared to the display state of “D003”. A small space is displayed in the columns 2008080402 to 20080423 ", and a large margin is generated on the right side (see FIG. 8).

  In the display state where the display state ID of the fifth row is “D005”, the display end date is shortened to “20080424” as compared to the display state of “D004” (returns to the display state of “D001”). Therefore, all activity bars are displayed without interruption (see FIG. 6).

  In the display state where the display state ID of the sixth line is “D006”, the number of activities is increased to “11” compared to the display state of “D005”, so one activity at the lower level of the Gantt chart (Row 271) is cut off from the screen (see FIG. 9).

  In the display state where the display state ID of the seventh row is “D007”, the number of activities is reduced to “9” as compared to the display state of “D006” (two activities “not belonging to the related group” Since “Budget creation” and “Cost calculation” are deleted from the objects to be displayed), the rows related to all activities are displayed without interruption (see FIG. 10).

The related process display device 1 of the present invention basically displays the activity bars related to all activities belonging to the related group on the screen without interruption as described above.
However, in actuality, for example, a certain period may be enlarged and displayed (for example, “D002”) or a large margin (for example, “D004”) may be displayed to confirm a future date by a user operation. . Further, when the user adds a new activity (for example, “D006”) during the display, the end date of an existing activity is extended and the operation of the display record is not shown in FIG. By extending the end date in conjunction with each other, as a result, a part of the activity bar related to a certain activity may protrude from the screen.

In the existing technology, when returning to the original display state (for example, “D001”), it is necessary for the user himself to perform fine and delicate operations such as scrolling the screen and changing the scale.
In the present embodiment, as an initial display state, all activity bars belonging to the business are displayed without interruption. If some of the related activity bars are not displayed due to an operation that changes the display state by the user or an operation that changes the number of activities or the start date / end date, it will be detailed and subtle to the user. It automatically transitions to a display state in which all related activity bars are displayed without requiring an operation.
Here, “automatically” means that the user does not perform any special operation after a given time, or (not a subtle operation that modifies the display range using a mouse). It means that it is triggered by a one-touch operation.

Since the display state table 23 in FIG. 5 also functions to store the display history, the display state can be gradually returned to the past display state by pressing a “return display” button (not shown) several times. it can. In addition, when a “view past display” button (not shown) is pressed, a display state table 23 as a display history is displayed on the screen. It is possible to return to an arbitrary display state.
In the above description, the display state table 23 is described as being stored in the main storage device 14, but may be stored in the auxiliary storage device 15. By doing so, it is possible to refer to the display history even when the related process display device 1 is turned off and then turned on again.

(Display range setting)
How much the display start date is before the business start date ("predetermined number of days"), how much the display end date is after the business end date ("predetermined days"), and the number of activities that can be displayed The user can arbitrarily set how much (“predetermined number”) is greater than the number in consideration of the visibility of the Gantt chart.

(Setting example 1)
For example, for the display start (end) date, a certain number of days is set before and after the business start date and the business end date, such as “previous day, post-day”. Incidentally, FIG. 6 is an example in which “1 day before and 1 day after” is set. Furthermore, a margin rate may be set for the number of days from the business start date to the business end date, such as “previous ○% later □%”, and the number of days such as “previous ○ day later □ day” may be calculated.
Similarly, for the number of activities that can be displayed, a certain number of lines to be added to the number of activities is set, such as “+ ◇ lines”. Incidentally, FIG. 6 shows an example in which “+2 rows” is set. Furthermore, a margin rate with respect to the number of activities such as “+ ○%” may be set, and the number of rows such as “+ ○ rows” may be calculated.

  When the display start (end) date is set to “0 days before and after 0”, the record in the first row of the display state table 23 in FIG. The Gantt chart display screen 41 transitions by automatically adjusting the width of the column with the date as a headline so as to maintain the width before and after (the 0th day) corresponding to the “business end date” (details will be described later). That is, for example, if the activity bar on the rightmost side (latest end date) is interrupted even for one day, it is corrected so that it is displayed until the end date of business. On the other hand, if a margin occurs even for one day on the right side of the rightmost activity bar, it is corrected so that only the business end date is displayed. The same applies to the left side of the leftmost activity bar.

  Similarly, when “3 days before and 4 days after” is set, the record in the first row of the display state table 23 in FIG. 5 has a display start date “business start date −3” and a display end date “business end”. Day +4 ", and the Gantt chart display screen 41 changes so as to maintain the width before and after that (3 days, 4 days). That is, for example, if the right margin of the rightmost (latest end date) activity bar is less than 4 days, it is corrected to display up to business end date + 4 days. Conversely, if the right margin of the rightmost activity bar is more than 4 days, it is corrected to display only the work end date + 4 days. The same applies to the left side of the leftmost activity bar.

  When “+2 lines” is set for the number of displayable activities, the record of the first line in the display state table 23 of FIG. As long as the number of activities does not exceed the number of activities that can be displayed due to the data change by the user, the number of activities equals the number of activities, or if not, the number of activities continues to be displayed while maintaining the ratio of the height of each line. . When the number of activities exceeds the number of activities that can be displayed due to the data change by the user, first, a row relating to an activity that does not belong to the related group is deleted (means 1). If the number of activities still exceeds the number of activities that can be displayed, the number of activities that can be displayed is changed based on the increased number of activities and settings (means 2). It is also possible to reverse the priorities of means 1 and means 2.

(Setting example 2)
For example, set a certain number of days and line widths, such as “before ○ to ● days after □ to ■ days” for the display start (end) date, and “+ ◇ to ◆ lines” for the number of displayable activities. It is also possible to simultaneously set arbitrary “reference values” included in the width (maximum values included in the width, etc.). In this way, when the related process display device 1 creates a display record by setting, the display start (end) date and the number of displayable activities are determined based on the “reference value”, and then displayed by the user operation. Even if the date etc. is changed slightly, as long as the displayed date after the change is within the range, the display state is continued. If the date is not within the range, the related process display device 1 displays again based on the “reference value”. A record will be created.

(Condition specification)
In the above description, the business start date and the business end date are acquired based on the start date and the end date of all the records in the activity information database 31 having a certain business name, and the display start date and the display end date of the display record are based on them. To get. However, the activities that require more attention are narrowed down ("Condition specification"), and the business start date and business end date are determined based on the business start date and business end date determined based only on the start date and end date of the record related to the narrowed activity. You can also get the day.

In this way, it is possible to display only the activity bar related to the activity whose progress is delayed, for example, on the entire screen without worrying about the display of other activity bars being interrupted.
Specifically, extract only those activities whose progress has been delayed (activities whose progress point on the latest progress confirmation date is earlier than the current date and whose progress point does not match the end date) The earliest date among the start dates related to activities is the “condition-designated task start date”, and the latest date is the “condition-designated task end date”. In addition to the display state table 23, a “condition table” (not shown) in which “condition specified work start date” and “condition specified work end date” are stored in association with the display state ID of the display state table 23 is temporarily stored. Remember me. Then, the display start date and the display end date of the display record are determined based on the “condition specified job start date” and “condition specified job end date” in the “condition table”.

(Gantt chart display screen 41)
6 to 10 are diagrams illustrating an example of a Gantt chart display screen according to the present embodiment.
Each column of the Gantt chart display screen 41 will be described with reference to FIG.
The Gantt chart display screen 41 is displayed for each task selected by the user. The task name column 251 displays a task name, and the task ID column 252 displays a task ID. The activity name column 254 displays all activity names belonging to the business, and the activity ID column 253 displays the activity ID.
In the progress rate column 255, the progress rate on the progress confirmation date closest to the current time is displayed.
The activity bar display field 256 is composed of a column having a date from the display start date to the display end date as a heading.
In the activity bar display column 256 of each row 261 to 268, activity bars 281 to 288 having thick line rectangles are displayed. The activity bars 281 to 288 are arranged across a column indicating the end date from a column indicating the start date of the activity.

On the activity bars 281 to 288, progress marks 291 to 298 “◯” indicating the progress points of the activity on the progress confirmation date closest to the current time are displayed.
A progress line 311 connecting progress marks on the activity bar related to activities belonging to the same related group is displayed. The progress line 311 has a different shape if the progress confirmation date is different. A progress line 311 in FIG. 6 is a progress line at the point of progress confirmation date “20080409” (“◯” is displayed in the column heading indicating “20080409”). The progress line corresponding to which progress confirmation date is displayed can be arbitrarily selected by the user.

If the current date is selected as the progress confirmation date, it is possible to visually know the progress of each activity (whether it is ahead of schedule) at the current time. Basically, an activity bar (“given” for an activity having a progress mark “◯” (292, 293) on the left side of the reference line 312 perpendicularly drawn in the column “20080409” with “○” in the heading. The progress of “conditional arrangement” 282 and “budget creation” 283) is delayed. Among these, “Budget creation” 283 is not connected by the progress line 311 (does not belong to the related group), so it is determined that it does not affect other activities.
For the activity “market research”, the progress mark “◯” 291 is on the left side of the reference line 312, but since the progress point coincides with the end date (“20080405”), there is no delay. If the progress mark “◯” 291 is on the left (before) the end date, the progress is delayed.

(Processing procedure)
Hereinafter, a processing procedure according to the present embodiment will be described with reference to a flowchart with reference to FIG. There are two processing procedures: an activity information input processing procedure and a Gantt chart display processing procedure. The Gantt chart display processing procedure is premised on the completion of the activity information input processing procedure.

(Activity information input processing procedure)
FIG. 11 is a flowchart of the activity information input processing procedure according to this embodiment.
In step S401, the activity information management unit 21 receives input of activity information.
Specifically, the activity information management unit 21 first displays an activity information input screen (not shown) on the output device 12 when the user receives an activation signal input via the input device 11. .
Second, it accepts that the user inputs an activity name, a business name, a start date, and an end date in association with the activity name.
Third, an activity ID and a business ID are issued for the activity name and the business name received in “Second”, respectively.
Fourth, the activity ID, activity name, business ID, business name, start date, and end date are stored in the activity information database 31 in association with the activity ID.

In step S402, the activity information management unit 21 receives input of progress information.
Specifically, the activity information management unit 21 first displays a progress information input screen (not shown) on the output device 12.
Second, the user receives an input of the progress rate for each activity ID stored in “fourth” in step S401.
Third, the activity information database 31 is searched using the activity ID in “second” as a search key, and the end date and start date of the corresponding record are acquired.
Fourth, calculate the number of days from the start date to the end date (including the days at both ends), and multiply the number of days by the progress rate. Get as.
Fifth, the activity ID, activity name, progress confirmation date (the processing date if not specified, the date if specified), progress rate and progress point are stored in the progress information database 32 in association with the activity ID. To do.

In step S403, the activity information management unit 21 receives input of related information.
Specifically, the activity information management unit 21 first displays a related information input screen (not shown) on the output device 12. It is assumed that the records of the activity information database 31 are sorted and displayed on the screen for each business ID.
Second, it accepts that the user selects a plurality of records as the first related group from the records having the same business ID displayed, and issues the first related group ID to all the selected records. . Furthermore, it accepts selection of a plurality of records as the next related group, and issues the next related group ID to all the selected records.
Third, after the selection in “second” is completed, the activity ID, activity name, and related group ID are stored in the related information database 33 in association with the activity ID. Delete the records that were not selected.
The “second” and “third” processing procedures are repeatedly executed for each business ID.
Here, the activity information input processing procedure is terminated.

  The order of steps S402 and S403 can be interchanged. In the above description, the processing procedure in the case where the initial input of information related to a plurality of activities is collectively executed has been described. However, the information once stored in each database can be changed. The change is executed by receiving a user operation such as displaying a record of each database and overwriting the contents of each column, deleting a record, or adding a record.

Furthermore, if there are the following operations by the user on the Gantt chart display screen 41 (FIG. 6), the activity information management unit 21 changes, deletes, and adds records in each database in conjunction with accepting those operations. Can be executed.
The operation is, for example, selecting the right end of the activity bar with the input device 11 such as a mouse and dragging it to the right (changing the end date to a later date), selecting the progress mark “O” with the mouse. To the right (to increase the progress rate), select the entire line with the mouse and press the delete button (not shown) (delete the record in the activity information database 31), insert the line The activity name is described, the activity bar is described (a record of the activity information database 31 is added), and the like.

(Gantt chart display processing procedure)
FIG. 12 is a flowchart of a Gantt chart display processing procedure according to the present embodiment.
The “information acquisition display procedure” corresponds to steps S413 to S414 described later and steps S419 to S420 in which the steps are repeated.
In step S411, the Gantt chart display processing unit 22 receives an input of a business ID. Specifically, the Gantt chart display processing unit 22 first displays a business name input screen (not shown) on the output device 12.
Second, the user accepts input of a business ID.

In step S412, the Gantt chart display processing unit 22 acquires an activity record.
Specifically, the Gantt chart display processing unit 22 first searches the activity information database 31 using the business ID received in “second” in step S411 as a search key, and acquires all corresponding records. To do.
Second, the related information database 33 is searched using the activity ID of the record acquired in “First” as a search key, and the corresponding record is acquired.
Third, from the record acquired at “first”, a record whose activity name of the record is present in the activity name of the record acquired at “second” is extracted and temporarily stored in the main storage device 14. To remember.

In step S413, the Gantt chart display processing unit 22 creates a display record based on the setting.
Specifically, first, the Gantt chart display processing unit 22 acquires the earliest start date among the start dates of all the records temporarily stored in “third” in step S412. In addition, the latest end date is acquired from the end dates of all the records acquired in “third” in step S412. In addition, get the number of all records. Here, the earliest start date and the latest end date may be acquired for only the activity specified by the condition. Furthermore, the earliest start date and the latest end date when the condition is not specified, and the earliest start date and the latest end date when the condition is specified may both be acquired.
Second, a display record of the display state table 23 is created (at this point, it is a blank record).
Thirdly, in the “second” of step S411, the business name column 232, the business start date column 233, the business end date column 234, and the activity number column 235 of the display record created in “second” are acquired. Business name, earliest start date acquired in “first” in step S413, latest end date acquired in “first” in step S413, number of records acquired in “first” in step S413 Remember each one.
Fourth, the display state ID is issued and stored in the display state ID column 231 of the display record created in “Second”.
Fifth, the display start date and the display end date are stored in the display start date column 236 and the display end date column 237 of the display record created in “second”, respectively.
At this time, as the display start date, a date before the business start date is selected according to the setting by the user. As the display end date, a date after the job end date is selected according to the setting.
Sixth, the number of displayable activities is stored in the displayable activity number column 238 of the display record created in “Second”. At this time, the number of activities that can be displayed stores a number equal to or greater than the number of activities according to the setting. This completes the display record field and completes the display record.
Seventh, the display record completed in “sixth” is temporarily stored in the main storage device 14.

In step S414, the Gantt chart display processing unit 22 displays a Gantt chart.
Specifically, the Gantt chart display processing unit 22 first sets a column (from the display start date to the display end date of the display record stored in “seventh” of step S413 in the output device 12 as a headline ( A blank column at this time) and a line (blank at this time) equal to the number of displayable activities stored in the “seventh” in step S413 are displayed. The column width is determined so that each column has a uniform width based on the size of the screen and the number of columns, or when the column width is not equal, the ratio of the width of each column is maintained. The row height is determined based on the size of the screen and the number of rows so that each row has a uniform height, or if not, the proportion of the height of each row is maintained. The activity information database 31 is searched using the business ID of the display record stored in “seventh” as a search key, and the activity ID, activity name, business ID, business name, start date, and end date of all applicable records are acquired. To do.
Third, the progress information database 32 is searched using the activity ID acquired in “Second” as a search key, and the progress rate and progress point are acquired.
Fourth, the related information database 33 is searched using the activity ID acquired in “Second” as a search key to acquire all corresponding records, and the records are sorted for each related group ID.
Fifth, the activity ID field (reference numeral 253 in FIG. 6), the activity name field (reference numeral 254 in FIG. 6), and the progress rate field (reference numeral 255 in FIG. 6) in the row indicated by “first” The activity ID and activity name acquired in “2” and the progress rate acquired in “third” are displayed. Further, the activity bar display field (reference numeral 256 in FIG. 6) displayed in “first” covers the column from the start date to the end date based on the start date and end date acquired in “second”. Displays a rectangular activity bar with a wide width.
Sixth, a mark “◯” indicating the progress point acquired in “third” is displayed on the activity bar displayed in “fifth”.
Seventh, a mark “◯” on the activity bar displayed in “fifth” is connected by a progress line (reference numeral 311 in FIG. 6) for each group of records sorted in “fourth”. Then, the business name and business ID acquired in “Second” are displayed in the business name column (reference numeral 251 in FIG. 6) and the business ID column (reference numeral 252 in FIG. 6), respectively. The display is maintained until the next operation by the user is accepted. If a user operation is accepted, the process proceeds to step S415.

In step S415, the Gantt chart display processing unit 22 determines whether or not the user operation is “end”.
Specifically, the Gantt chart display processing unit 22 stands by while maintaining the previous display state until accepting an operation by the user. Here, the operation by the user means an operation for changing the display state of the Gantt chart (including an operation for changing the contents of each database and an operation for terminating the display. It does not include a font change or a print instruction). To do.
When the “end” operation is received (step S415 “Yes”), the Gantt chart display processing procedure is ended. In other cases (step S415 “No”), the process proceeds to step S416.

In step S416, the Gantt chart display processing unit 22 additionally creates a display record based on the operation. This step is performed when an operation (other than “end”) by the user is accepted immediately before.
Specifically, when the display range on the screen is changed by an operation by the user, or when the target to be displayed is changed by changing the data in the activity information database 31 or the like (the end date is For example, when the end date of the latest activity is further postponed), the Gantt chart display processing unit 22 additionally creates a display record reflecting the operation content.
For example, in order for the user who is viewing the screen corresponding to the display state ID “D001” in FIG. 5 to enlarge and view the portion from “20080401” to “2008421”, the right end of the column “20080421” is displayed. Suppose you select and drag to the right edge of the screen. In response to this operation, the Gantt chart display processing unit 22 changes the display record in the first row of display data in FIG. 5 by changing the display end date to “20080421” and changing the display state ID to “D002”. It is additionally created and temporarily stored in the main storage device 14.

In step S417, the Gantt chart display processing unit 22 displays a Gantt chart.
The specific contents are almost the same as in step S414. In addition to replacing “S414” in step S414 with “S417”, the following difference is replaced with the description of step S417.
That is, “the display record stored in“ seventh ”in step S413” in step S414 is “the display record stored in step S416”.

Step S418 is omitted depending on the setting contents.
Step S418 determines whether or not the display state after the change by the operation by the user is within the range of “a certain number of days width and row width” in the case of the setting as in setting example 2 described above. It is a step to do. Therefore, in the case of the setting as in setting example 1 without the concept of “width” in the first place, the process directly proceeds from step S417 to step S419.

In step S418, the Gantt chart display processing unit 22 determines whether or not all activities can be appropriately displayed.
Specifically, the display start date of the display record newly created in step S416 is included in the day width based on the business start date, and the display end date is based on the business end date. It is determined whether it is included in the number of days (condition 1), or the number of activities that can be displayed is within the number obtained by adding the number of lines to the number of activities (condition 2). If condition 1 and condition 2 are satisfied at the same time (step S418 “Yes”), the process returns to step S415. In other cases (step S418 “No”), the process proceeds to step S419.

In step S419, the Gantt chart display processing unit 22 creates an additional display record based on the setting.
The specific contents are the same as in step S413. It replaces with description of step S419 by replacing "S413" in step S413 with "S419."

In step S420, the Gantt chart display processing unit 22 displays a Gantt chart.
The specific contents are almost the same as in step S414. In addition to replacing “S414” in step S414 with “S420”, the following differences are replaced with the description of step S420.
That is, “the display record stored in“ seventh ”in step S413” in step S414 is “the display record stored in step S419”.

It is a hardware block diagram concerning this embodiment. It is a figure which shows an example of the activity information database which concerns on this embodiment. It is a figure which shows an example of the progress information database which concerns on this embodiment. It is a figure which shows an example of the related information database which concerns on this embodiment. It is a figure which shows an example of the display state table which concerns on this embodiment. It is a figure which shows an example of the Gantt chart display screen which concerns on this embodiment. It is a figure which shows an example of the Gantt chart display screen which concerns on this embodiment. It is a figure which shows an example of the Gantt chart display screen which concerns on this embodiment. It is a figure which shows an example of the Gantt chart display screen which concerns on this embodiment. It is a figure which shows an example of the Gantt chart display screen which concerns on this embodiment. It is a flowchart of the activity information input processing procedure which concerns on this embodiment. It is a flowchart of the Gantt chart display processing procedure which concerns on this embodiment.

Explanation of symbols

1 Related process display device 11 Input device (input unit)
12 Output device (output unit)
13 Central control unit (control unit)
14 Main storage (storage unit)
15 Auxiliary storage device (storage unit)
23 Display status table (third database)
31 Activity information database (first database)
32 Progress information database (fourth database)
33 Related information database (second database)
41 Gantt chart display screen 201, 211, 221 Activity ID column 203 Business ID column 223 Related group ID column

Claims (12)

A related process display device that displays a plurality of activities belonging to a business in time series,
A first database that stores an identifier indicating the activity, an identifier indicating the business, a start date of the activity, and an end date of the activity;
A second database that stores an identifier indicating the activity and information indicating a group to which a plurality of mutually related activities belong;
An identifier indicating the business, a start date of the business, an end date of the business, the number of activities belonging to the business, a display start date that is a start date of a display period for displaying the activity on the output unit, A third database that stores the display end date that is the end date of the display period and the maximum number of activities that can be displayed in association with each other;
A storage unit comprising:
A record in which the identifier indicating the activity of the record is stored in the second database among the records corresponding to the first database searched using the identifier indicating the business received via the input unit as a search key. Extract
The date starting a predetermined number of days from the start date of the business that is the earliest start date among the activity start dates of the extracted record is acquired as the display start date, and the activity end date of the extracted record is the most The date after a predetermined number of days from the end date of the work, which is a late end date, is acquired as the display end date, and the number obtained by adding the predetermined number to the number of the corresponding records is acquired as the maximum number of activities that can be displayed. Further, in association with the identifier indicating the business, the business start date, the business end date, the number of activities belonging to the business, which is the number of the corresponding records, and the acquired display start date The acquired display end date and the maximum number of activities that can be acquired are created as display records in a third database, and And the activity of all records obtained as a result of searching the first database for the display period from the display start date of the display record to the display end date, from the start date of the activity. Displayed via the output unit as a graphic showing the period until the end date of the activity, and among the activities of all the records, the activities of the records that have been extracted are displayed with a line indicating their relevance Information acquisition and display procedures including
When an operation for changing the display period or the number of activities is received during the display, a new display record is created based on the operation and stored in the storage unit,
For the display period from the display start date of the new display record to the display end date, the activities of all the records acquired as a result of searching the first database are displayed from the start date of the activity to the end date of the activity. As a graphic showing the period of time, it is displayed via the output unit, and among the activities of all the records, the activity of the record that is the subject of the extraction is displayed with a line indicating the relevance of each other,
When the difference between the display start date and the business start date of the new display record or the difference between the display end date and the business end date is excessive or insufficient for a predetermined number of days, or the display of the new display record is A related process display characterized by having a control unit that repeats the information acquisition and display procedure again when the maximum number of possible activities is excessive or insufficient with respect to the number of activities belonging to the business plus a predetermined number apparatus. The controller is
As a result of the operation accepted during the display, if the number of activities belonging to the business of the display record exceeds the maximum number of activities that can be displayed,
The related process display device according to claim 1, wherein an activity related to a record not extracted in the extraction is not displayed. The created and stored display record is stored in the third database as a display history,
The related process display device according to claim 1, wherein the control unit is capable of displaying a display screen related to a display record belonging to the display history. The storage unit
A fourth database that stores an identifier indicating the activity and information indicating a progress time of the activity in association with each other;
The control unit indicates the activity of all the records acquired as a result of searching the first database, the information indicating the progress time of the fourth database is before a predetermined time, and indicates the progress time The related process display device according to claim 1, wherein the extraction is performed after narrowing down to activities whose information does not match an end date of the activity. A related process display method using a computer that displays a plurality of activities belonging to work in time series,
The storage unit of the computer
A first database that stores an identifier indicating the activity, an identifier indicating the business, a start date of the activity, and an end date of the activity;
A second database that stores an identifier indicating the activity and information indicating a group to which a plurality of mutually related activities belong;
An identifier indicating the business, a start date of the business, an end date of the business, the number of activities belonging to the business, a display start date that is a start date of a display period for displaying the activity on the output unit, A third database that stores the display end date that is the end date of the display period and the maximum number of activities that can be displayed in association with each other;
With
The control unit of the computer
A record in which the identifier indicating the activity of the record is stored in the second database among the records corresponding to the first database searched using the identifier indicating the business received via the input unit as a search key. Extract
The date starting a predetermined number of days from the start date of the business that is the earliest start date among the activity start dates of the extracted record is acquired as the display start date, and the activity end date of the extracted record is the most The date after a predetermined number of days from the end date of the work, which is a late end date, is acquired as the display end date, and the number obtained by adding the predetermined number to the number of the corresponding records is acquired as the maximum number of activities that can be displayed. Further, in association with the identifier indicating the business, the business start date, the business end date, the number of activities belonging to the business, which is the number of the corresponding records, and the acquired display start date The acquired display end date and the maximum number of activities that can be acquired are created as display records in a third database, and And the activity of all records obtained as a result of searching the first database for the display period from the display start date of the display record to the display end date, from the start date of the activity. Displayed via the output unit as a graphic showing the period until the end date of the activity, and among the activities of all the records, the activities of the records that have been extracted are displayed with a line indicating their relevance Information acquisition and display procedures including
When an operation for changing the display period or the number of activities is received during the display, a new display record is created based on the operation and stored in the storage unit,
For the display period from the display start date of the new display record to the display end date, the activities of all the records acquired as a result of searching the first database are displayed from the start date of the activity to the end date of the activity. As a graphic showing the period of time, it is displayed via the output unit, and among the activities of all the records, the activity of the record that is the subject of the extraction is displayed with a line indicating the relevance of each other,
When the difference between the display start date and the business start date of the new display record or the difference between the display end date and the business end date is excessive or insufficient for a predetermined number of days, or the display of the new display record is A related process display method characterized by repeating the information acquisition display procedure again when the maximum number of possible activities is excessive or insufficient with respect to the number of activities belonging to the business plus a predetermined number. The controller is
As a result of the operation accepted during the display, if the number of activities belonging to the business of the display record exceeds the maximum number of activities that can be displayed,
The related process display method according to claim 5, wherein the activity related to the record not extracted in the extraction is not displayed. The created and stored display record is stored in the third database as a display history,
The related process display method according to claim 5, wherein the control unit is capable of displaying a display screen related to a display record belonging to the display history. The storage unit
A fourth database that stores an identifier indicating the activity and information indicating a progress time of the activity in association with each other;
The control unit indicates the activity of all the records acquired as a result of searching the first database, the information indicating the progress time of the fourth database is before a predetermined time, and indicates the progress time The related process display method according to any one of claims 5 to 7, wherein the extraction is performed after narrowing down to activities whose information does not match an end date of the activity. A related process display program for causing a computer to display a plurality of activities belonging to a business in time series,
For the storage part of the computer,
A first database that stores an identifier indicating the activity, an identifier indicating the business, a start date of the activity, and an end date of the activity;
A second database that stores an identifier indicating the activity and information indicating a group to which a plurality of mutually related activities belong;
An identifier indicating the business, a start date of the business, an end date of the business, the number of activities belonging to the business, a display start date that is a start date of a display period for displaying the activity on the output unit, A third database that stores the display end date that is the end date of the display period and the maximum number of activities that can be displayed in association with each other;
Remember
For the control part of the computer,
A record in which the identifier indicating the activity of the record is stored in the second database among the records corresponding to the first database searched using the identifier indicating the business received via the input unit as a search key. Extract
The date starting a predetermined number of days from the start date of the business that is the earliest start date among the activity start dates of the extracted record is acquired as the display start date, and the activity end date of the extracted record is the most The date after a predetermined number of days from the end date of the work, which is a late end date, is acquired as the display end date, and the number obtained by adding the predetermined number to the number of the corresponding records is acquired as the maximum number of activities that can be displayed. Further, in association with the identifier indicating the business, the business start date, the business end date, the number of activities belonging to the business, which is the number of the corresponding records, and the acquired display start date The acquired display end date and the maximum number of activities that can be acquired are created as display records in a third database, and And the activity of all records obtained as a result of searching the first database for the display period from the display start date of the display record to the display end date, from the start date of the activity. Displayed via the output unit as a graphic showing the period until the end date of the activity, and among the activities of all the records, the activities of the records that have been extracted are displayed with a line indicating their relevance Information acquisition and display procedures including
When an operation for changing the display period or the number of activities is received during the display, a new display record is created based on the operation and stored in the storage unit,
For the display period from the display start date of the new display record to the display end date, the activities of all the records acquired as a result of searching the first database are displayed from the start date of the activity to the end date of the activity. As a graphic showing the period of time, it is displayed via the output unit, and among the activities of all the records, the activity of the record that is the subject of the extraction is displayed with a line indicating the relevance of each other,
When the difference between the display start date and the business start date of the new display record or the difference between the display end date and the business end date is excessive or insufficient for a predetermined number of days, or the display of the new display record is A related process display characterized by realizing a function of repeating the information acquisition and display procedure again when the maximum number of possible activities is excessive or insufficient with respect to the number of activities belonging to the business plus a predetermined number. program. For the control unit,
As a result of the operation accepted during the display, if the number of activities belonging to the business of the display record exceeds the maximum number of activities that can be displayed,
The related process display program according to claim 9, wherein the activity related to the record not extracted in the extraction is not displayed. The created and stored display record is stored in the third database as a display history,
The related process display program according to claim 9 or 10, wherein the control unit can display a display screen related to a display record belonging to the display history. For the storage unit,
A fourth database that stores an identifier indicating the activity and information indicating a progress time of the activity in association with each other;
For the control unit, the activity of all the records acquired as a result of searching the first database, the information indicating the progress time of the fourth database is before a predetermined time, and the progress time is The related process display program according to any one of claims 9 to 11, wherein the extraction is performed after narrowing down to an activity whose information does not match an end date of the activity.

Images