JP2016076077A - Schedule management system, method, and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To present accurate operation availability data indicating the availability of work teams in a designated work block, even when a plurality of work teams separately take charge of a plurality of work blocks.SOLUTION: A data acquisition unit 16 confirms a work team that takes charge of a designated work block with the in-charge block data of an in-charge block setting database 11, acquires operation possibility data pertaining to these work teams in charge from an operation possibility setting database 12, and acquires schedule data pertaining to these work teams in charge from a schedule management book database 13. An availability presentation unit 17 totals operation availability pertaining to each work team in charge of the work block on the basis of the acquired operation possibility data and schedule data, generates an approximate work calendar indicating daily operation availability on the basis of the obtained totalization result, and presents the generated approximate work calendar as operation availability data pertaining to the work block.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a schedule management technique, and in particular, when each service occurring at a plurality of different service providing locations is handled by a plurality of service providers, each service providing is in charge of the service providing location for each service providing location. The present invention relates to a schedule management technique for managing a person's availability.

In recent years, with the spread of the Internet, a schedule management technique in which a user reserves a service provided by a service provider via the Internet is being widely used.
Conventionally, as one of such schedule management techniques, a reservation acceptance system that accepts service use reservations from users via the Internet has been proposed (see, for example, Patent Document 1).

  In this reservation reception system, when there is an access from a user terminal via the Internet, the server presents operating availability data indicating whether the service can be used or not to the user terminal and displays it on the screen. The server accepts a reservation for a service on the available reservation date according to a selection operation on the available reservation date on the terminal. This makes it possible to accept service reservations accurately and without error as compared to telephone reception, and to greatly reduce the work burden required for reservation reception.

JP 2001-216349 A JP 2014-092896 A

  When installing special equipment such as a business phone, a construction team with specialized knowledge and technology will perform equipment construction to install the equipment. At this time, if there is a request for equipment construction from the user, it is necessary to check the schedule of the construction team to see if there is a construction team that can handle the designated construction date and to accept the construction day reservation. . Therefore, if facility construction is regarded as a type of service provision, it is considered to apply the above-mentioned conventional reservation reception system to facility construction schedule management work and present operational availability data indicating the availability of facility construction. The

  Here, the service provision form assumed in the schedule management technique according to the prior art is a form in which service is provided at a predetermined fixed service provision place, as represented by massage, doctor, beauty salon, etc. The service providing place and the service provider have a relationship of 1: N (N is an integer of 1 or more). For this reason, in the prior art, if there is a vacancy in the service provider, it is basically assumed that the service can be provided to the user without restriction.

On the other hand, when accepting facility construction, in order to perform the facility construction efficiently, the construction work is performed in charge by a plurality of construction teams. At this time, the construction blocks that each construction team can handle are limited according to the geographical relationship between the construction team base and the facility construction, that is, the construction block. This is because the time taken from the base to the construction site affects the efficiency of the construction work. In addition, in each construction block, facility construction occurs irregularly rather than periodically.
Therefore, in order to efficiently perform the facility construction, it is appropriate that a plurality of construction teams divide and take charge of a plurality of construction blocks, and the relationship between the construction blocks and the construction team is M: N (M, N Is an integer of 2 or more.

  Therefore, when accepting equipment construction, not only confirm the construction schedule for the construction block that includes the construction location of the equipment construction, but also other construction departments in charge of each construction team responsible for the construction block. It is also necessary to check the schedule in the construction block.

  However, in the schedule management technique according to the prior art, it is not considered that the service provider provides the service at another service providing place. For this reason, even if the schedule management technology according to the prior art is used, accurate operating availability data indicating the availability of the construction team in the designated construction block is presented in correspondence with the schedule management related to such equipment construction. I can't.

  Therefore, since the schedule management technology according to the prior art based on 1: 1 or 1: N cannot be used in the schedule management work for facility construction, the administrator manages the schedule for each construction team separately in a form. In response to telephone inquiries from sales representatives, these forms were manually matched to determine whether construction was possible in the designated construction block. For this reason, communication between the sales staff and the manager over the telephone often takes a long time, and the same is true even when the manager is absent. As a result, inquiries from sales representatives are delayed, and as a result, there is a problem in that user (customer) negotiations cannot proceed smoothly.

  The present invention is for solving such a problem. Even when a plurality of construction teams (service providers) separately handle a plurality of construction blocks (service provision locations), the present invention is applied to the designated construction blocks. The purpose is to provide a schedule management technology that can present accurate operational availability data indicating the availability of a construction team.

  In order to achieve such an object, a schedule management system according to the present invention is a schedule management system for managing a schedule of a service provider in charge of providing a service for each service providing place that provides the service. A responsible block setting DB that stores responsible block data indicating the service providing location that the service provider is responsible for, an operational availability setting DB that stores operational availability data indicating the date and time when the service provider can operate, and A schedule management list DB for storing schedule data indicating a schedule of a service for which the service provider is responsible at the service providing location, and a responsible service provider in charge of the designated service providing location for the responsible block setting DB Check with these responsible services The operation availability data regarding the provider is acquired from the operation availability setting DB, and the schedule data regarding these service providers is acquired from the schedule management DB, and the acquired operation availability data and the schedule data are included in the acquired data. Based on the service availability for each service provider in the service provision location, and based on the obtained summary results, generate a summary service calendar showing the daily availability of the service. And a vacancy status presenting section that presents the vacancy status data relating to the service providing location.

  Further, in one configuration example of the schedule management system according to the present invention, the availability data includes an operation man-hour indicating a work scale that can be handled by the service provider for each date and time. Based on the obtained operation availability data and the schedule data, the registered registered man-hours or vacant man-hours for each service provider in charge at the service providing location are totaled for each service provider in charge, and based on the obtained total result A detailed service calendar indicating the availability of operating man-hours per day is generated for each service provider concerned, and the generated detailed service calendar is presented as the operating availability status data.

  Also, in one configuration example of the schedule management system according to the present invention, when the availability presenting unit receives a availability confirmation request from a person-in-charge terminal of a salesperson who orders a service, the general service calendar Is generated and presented to the person-in-charge terminal as operating availability data relating to the service providing location, and an availability confirmation request is received from the administrator terminal of the administrator who adjusts the schedule of the service for which the service provider is responsible In this case, the detailed service calendar is generated and presented to the manager terminal as operating availability data relating to the service providing location.

  In addition, according to the configuration example of the schedule management system according to the present invention, in response to a service adjustment request from a person-in-charge terminal of a salesperson who receives an order for a service, the description content of the form form of the service adjustment request is adjusted to the adjustment request data. A service management unit that captures the input form from the copy source Web page indicating the form form based on the copy definition data registered in advance at the time of the capture. The item data of the item object corresponding to the identification information of the copy source item object defined in the definition data is acquired, and these item data are stored in the copy definition data in the copy destination Web page indicating the input form. Item object corresponding to the identification information of the defined copy destination item object It is obtained so as to replicate as item data.

  Also, one configuration example of the schedule management system according to the present invention is such that the service includes construction work, the service providing place includes a construction block set in advance as a range for managing the construction work, and the service provider Each construction block is in charge of a construction block, and the schedule of each construction group in charge of the construction block is managed for each construction block.

  A schedule management method according to the present invention is a schedule management method for managing a schedule of a service provider in charge of providing a service for each service providing place that provides the service, and the service provider is in charge of the schedule management method. Storing the responsible block data indicating the service providing location in the responsible block setting DB; storing the availability data indicating the date and time when the service provider can operate in the availability setting DB; and the service providing location. A step of storing schedule data indicating a schedule of a service for which the service provider is in charge in the schedule management book DB; and a data acquisition unit that designates a service provider in charge of the designated service providing location in the block setting DB Check with the responsible block data, and these A data acquisition step for acquiring operation availability data relating to the service provider from the operation availability setting DB, and acquiring schedule data relating to the service provider in charge from the schedule management book DB, and the availability presenting unit acquired the data Based on the availability data and the schedule data, the operational availability for each responsible service provider at the service provision location is aggregated, and based on the obtained aggregated result, a rough service calendar showing the daily operational availability is generated. And a vacancy status presentation step of presenting the generated general service calendar as operating vacancy status data relating to the service providing location.

  Moreover, the program concerning this invention is a program for functioning a computer as each part which comprises the said schedule management system.

  According to the present invention, when the construction team (service provider) is also in charge of another construction block other than the construction block (service provision location) designated in the availability check request, the schedule acquired by the data acquisition unit The operation schedule for other construction blocks is included in the data. For this reason, when the availability status presentation unit aggregates the schedule data, the operation schedules related to other construction blocks are also counted together, so the operation schedules in other construction blocks are registered for any construction team in charge. The operation date and time for the construction group in charge is counted as having no operation vacancy even if the operation schedule in the construction block designated in the availability check request is not registered.

  Therefore, even if a plurality of construction teams are in charge of a plurality of construction blocks, and the relationship between the construction blocks and the construction team is M: N (M, N is an integer of 2 or more), it is designated. It is possible to present accurate operating availability data indicating the availability of the construction team in the construction block.

  In particular, since the schedule management technology according to the above-described conventional technology based on the relationship of 1: 1 or 1: N cannot be used, the business is in a situation where the manager manually determines whether or not construction is possible in the construction block. There was a problem that user (customer) negotiations could not be proceeded smoothly because of inquiries from the person in charge. According to the present embodiment, the sales representative can check the operating availability of the construction team very easily and quickly on the person-in-charge terminal before officially applying for the construction. It can also lead to service improvement for users.

It is a block diagram which shows the structure of a schedule management system. It is explanatory drawing which shows the example of a service provision form. It is a structural example of a charge block setting DB. It is a structural example of operation availability setting DB. It is an example of composition of schedule management book DB. It is a sequence diagram which shows the outline of a schedule registration operation | movement. It is a flowchart which shows an outline empty condition presentation operation | movement. It is a structural example of a general construction calendar. It is a flowchart which shows detailed empty condition presentation operation | movement. It is a structural example of a detailed construction calendar. It is an example of a detailed display screen of a general construction calendar. It is an example of a detailed display screen of a detailed construction calendar. It is a structural example of replication definition data. It is an example of a screen display which shows the import screen of a construction adjustment request.

Next, embodiments of the present invention will be described with reference to the drawings.
[First Embodiment]
First, a schedule management system 10 according to the first exemplary embodiment of the present invention will be described with reference to FIG. FIG. 1 is a block diagram showing the configuration of the schedule management system.

  This schedule management system 10 is based on the assumption that N (N is an integer greater than or equal to 2) construction teams will be responsible for each facility work that occurs in M (M is an integer greater than or equal to 2) construction blocks. The system presents schedule data indicating the availability of a construction team in a designated construction block. The system configuration can be configured with a single server device, but the processing and database may be distributed to a plurality of server devices.

  The schedule management system 10 is connected via a communication line L and a communication network 20 to a person-in-charge terminal 21 of a salesperson who receives an order for construction and an administrator terminal 22 of an administrator who adjusts the schedule of each construction team. In response to a schedule confirmation request from the person-in-charge terminal 21 or the manager terminal 22, schedule data indicating the availability status of the designated construction block or construction group is sent via the communication network 20 to the person-in-charge terminal 21 serving as a request source. And a function of delivering to the manager terminal 22 and presenting it to the sales staff and manager.

In the present embodiment, an example will be described in which the schedule management system 10 manages the schedule of each construction team in charge of a construction block for each construction block set in advance as a range for managing the construction work.
At this time, the application destination of the schedule management system 10 is not limited to the schedule management of the construction team, but the service providing place and the service provider have a relationship of M: N (M and N are integers of 2 or more). If it is a certain service provision form, for example, it can be applied to schedule management in a service provision form other than the schedule management of a construction team, in which a plurality of stores are handled by a plurality of employees.

  Further, when the schedule management system 10 described in the present embodiment is applied to the schedule management of the construction team, the construction work, the construction block, the construction team, the general construction calendar, and the detailed construction calendar are described in the claims. This corresponds to a service, a service providing place, a service provider, a general service calendar, and a detailed service calendar when applied to general service provision schedule management.

[Service provision form]
Next, with reference to FIG. 2, the service provision form of the facility construction service to be managed by the schedule management system 10 according to the present embodiment will be described. FIG. 2 is an explanatory diagram illustrating an example of a service provision form.

As shown in FIG. 2, the service providing form of the schedule management system 10 is a form in which a plurality of construction teams handle a plurality of construction blocks separately. In the present embodiment, such a service providing form will be described as an example, but the present invention is not limited thereto.
FIG. 2 shows that the schedule management system 10 accepts equipment received at five sales offices including “East Sales Office”, “South Sales Office”, “Central Sales Office”, “West Sales Office”, and “North Sales Office”. An example of managing the construction schedule collectively is shown.

Of these, “East Sales Office” and “South Sales Office” belong to the construction area “Wangan Area”, and “Central Sales Office”, “West Sales Office”, and “North Sales Office” It belongs to a construction area called “Area”. For each sales office, a construction time zone is set in advance, which is a combination of day of the week and time for receiving facility construction.
For example, “East Sales Office” has a construction time zone of “All Day”, and facilities can be constructed on all weekday mornings and afternoons.

  In addition, a construction time zone of “Wednesday PM, Friday PM” is set at the “South Business Office”, and facilities can be constructed on Wednesday and Friday afternoons. Similarly, the “Central Sales Office” and “West Sales Office” have a construction time zone of “Monday / Thursday”, and facilities can be constructed on Wednesday and Friday mornings and afternoons. Similarly, a construction time zone of “Tuesday AM, Friday AM” is set at “North Sales Office”, and facilities can be constructed on Tuesday and Friday mornings.

In addition, the construction hours of each sales office are managed as construction blocks. If the same construction hours are set between sales offices belonging to the same construction area, the same construction blocks are allocated to these sales offices. It has been.
For example, construction blocks X1, X2, and Y2 are assigned to “East Sales Office”, “South Sales Office”, and “North Sales Office”, respectively, and “Central Sales Office” and “West Sales Office” are the same. The construction block Y1 is assigned.

The relationship between the construction blocks and the construction teams is assigned so that a plurality of construction blocks are assigned to one or more construction teams.
For example, for the blocks X1 and X2 in the “Wangan Area”, the two construction teams “Team A” and “Team B” are assigned to be in charge. Therefore, in the blocks X1 and X2, the construction block and the construction team have a 1: 2 relationship. However, when viewed in the “gulf area”, the construction block and the construction team have a 2: 2 relationship. ing.

  In addition, in the “urban area”, the block Y1 is assigned so that the three construction teams “team C”, “team D”, and “team E” are in charge, and the block Y2 is Three construction teams, “Group D”, “Group E”, and “Group F”, are assigned to be in charge. Therefore, in the blocks Y1 and Y2, the construction block and the construction team have a 1: 3 relationship, but the combination is different in the blocks Y1 and Y2, and the construction block when viewed in the “urban area” And the construction team have a 2: 4 relationship.

[Schedule management system]
Next, the configuration of the schedule management system 10 will be described in detail with reference to FIGS. 1 and 2.
The schedule management system 10 includes a responsible block setting DB 11, an operation availability setting DB 12, a schedule management list DB 13, a setting management unit 14, a construction management unit 15, a data acquisition unit 16, and a vacancy status presentation unit 17 as main functional units. Is provided.

  Among these functional units, the assigned block setting DB 11, the operation availability setting DB 12, and the schedule management book DB 13 are composed of storage devices such as a hard disk and a semiconductor memory. Each may be realized by an individual storage device, or any two or all of them may be realized by one storage device. The setting management unit 14, the construction management unit 15, and the vacancy status presentation unit 17 may be realized by an arithmetic processing unit that includes a CPU and its peripheral circuits and realizes various processing units by executing a program.

The assigned block setting DB 11 is a database that stores assigned block data indicating the construction blocks handled by the construction group.
FIG. 3 is a configuration example of the assigned block setting DB. Here, for each group ID for identifying the construction group, a group of data such as the name of the construction group, the contact information of the construction group, and the responsible block indicating the construction block in charge of the construction group is in charge as the responsible block data. Registered in the block setting DB 11. The responsible block data is set in advance in the responsible block setting DB 11 by the administrator in response to an application from the construction team.

The operation availability setting DB 12 is a database that stores operation availability data indicating the date and time when the construction team can operate.
FIG. 4 is a configuration example of the operation availability setting DB. Here, for each group ID for identifying a construction group, a responsible block that indicates a construction block that the construction group is responsible for, a date and time zone that indicates a specific date and time when the construction team can operate the block, and these A set of data such as operation man-hours that the construction team can operate for each date and time is registered in the operation availability setting DB 12 as operation availability data. These operational availability data are set in advance in the operational availability setting DB 12 by the administrator in response to an application from the construction team. The operating man-hour is a number indicating the work scale that can be handled by the construction team, and the reference work work scale is counted as the operating man-hour “1”.

The schedule management book DB 13 is a database that stores schedule data indicating an operation schedule of a work determined to be handled by a work group in a work block.
FIG. 5 is a configuration example of the schedule management book DB. Here, for each schedule ID for identifying a construction schedule, a construction block in which equipment construction is performed, a date and time of equipment construction, a team ID indicating a construction team in charge of equipment construction, a required man-hour required for equipment construction, etc. Is registered in the schedule management book DB 13 as schedule data. These schedule data are set in advance in the schedule management book DB 13 by the administrator according to the application from the sales staff.

  The setting management unit 14 sets the responsible block data notified from the administrator terminal 22 via the communication network 20 according to the administrator operation to the responsible block setting DB 11 and the administrator terminal 22 according to the administrator operation. The operation availability data notified from the communication network 20 via the communication network 20 is set in the operation availability setting DB 12.

  The construction management unit 15 receives a construction adjustment request notified from the person-in-charge terminal 21 via the communication network 20 based on the operation of the sales person, and registers adjustment request data including the contents of the request in the schedule management book DB 13. Function, a function for notifying the administrator terminal 22 of the work adjustment request via the communication network 20, and schedule data notified from the administrator terminal 22 via the communication network 20 according to the administrator operation. And a function to set in the DB 13.

  The data acquisition unit 16 sends a free status confirmation request notified from the person-in-charge terminal 21 via the communication network 20 based on the operation of the sales person, or a notification from the administrator terminal 22 via the communication network 20 based on the administrator operation. In response to the requested availability check request, a function for checking the assigned work group in charge of the construction block specified in the available status check request with the assigned block data in the assigned block setting DB, and operation availability data regarding these assigned work groups Is obtained from the operation availability setting DB 12 and the function is obtained from the schedule management book DB 13 for schedule data relating to these assigned construction groups.

  In response to the availability check request notified from the person-in-charge terminal 21 via the communication network 20 based on the operation of the sales representative, the availability status presenting section 17 displays the availability data and schedule data acquired by the data acquisition section 16. Based on the function of totaling the operating availability for each construction team in charge of the construction block, the function of generating a rough construction calendar showing the daily working availability based on the obtained counting results, and the generated rough construction calendar It has a function of delivering and presenting to the person-in-charge terminal 21 via the communication network 20 as operational availability data relating to the construction block.

  Also, the vacancy status presenting unit 17 adds the availability data and schedule data acquired by the data acquisition unit 16 in response to the vacancy status confirmation request notified from the administrator terminal 22 via the communication network 20 based on the administrator operation. Based on the function that counts the number of registered man-hours or vacant man-hours for each work group in charge of the construction block based on the work block and the detailed work calendar that shows the daily work-hours availability status based on the results obtained It has a function of generating for each construction group, and distributing and presenting the generated detailed construction calendar as operating availability data to the person-in-charge terminal 21 via the communication network 20.

  A general Web page providing function may be used for accepting the availability check request from the person-in-charge terminal 21 or the administrator terminal 22 and distributing the operating availability data in the schedule management system 10. For example, a reception page for an availability check request and a presentation page for operating availability data may be created so as to be viewable from the person-in-charge terminal 21 or the administrator terminal 22 via the communication network 20.

[Operation of First Embodiment]
Next, an outline of the schedule registration operation of the schedule management system 10 according to the present exemplary embodiment will be described with reference to FIG. FIG. 6 is a sequence diagram showing an outline of the schedule registration operation. It is assumed that the assigned block data, the availability data, and the schedule data are already registered in the assigned block setting DB 11, the operation availability setting DB 12, and the schedule management book DB 13, respectively, at the start of the schedule registration operation.

[Schedule registration operation overview]
First, when a construction request is made by telephone from the user (customer) to the sales person (step 100), the sales person confirms the construction content from the user and then operates the person in charge terminal 21. Then, the schedule management system 10 is accessed via the communication network 20, and a request for checking availability of the construction block corresponding to the construction location is notified to the schedule management system 10 (step 101).

  The schedule management system 10 generates a rough construction calendar for the designated construction block in response to the availability check request from the person-in-charge terminal 21 (step 102), and the person-in-charge terminal 21 as the request source via the communication network 20 Is distributed as operation availability data (step 103). As a result, a rough construction calendar related to the designated construction block is displayed on the screen of the person-in-charge terminal 21 (step 104), and operational availability data of the rough construction block designated by the sales person is presented.

The sales representative notifies the user of the date and time when the construction can be carried out by using this general construction calendar (step 105), determines the construction date and time with the user, and operates the person in charge terminal 21 to perform the construction. A work adjustment request specifying the date and time is notified to the schedule management system 10 via the communication network 20 (step 106).
In response to the construction adjustment request from the person-in-charge terminal 21, the schedule management system 10 once accepts the construction adjustment request (step 107), and generates an adjustment request indicating that the adjustment request has been made via the communication network 20. The administrator terminal 22 is notified (step 108). Thereby, the construction content of the accepted construction is displayed on the screen of the manager terminal 22 (step 109).

  The administrator confirms the construction contents on the screen of the administrator terminal 22, operates the administrator terminal 22, and sends a free space confirmation request specifying the construction block corresponding to the construction place via the communication network 20 to the schedule management system. 10 is notified (step 110).

  The schedule management system 10 generates a detailed construction calendar for each construction team in charge of the designated construction block in response to the availability check request from the administrator terminal 22 (step 111), and via the communication network 20 The operating availability data is distributed to the requesting administrator terminal 22 (step 112). As a result, for each construction team in charge of the designated construction block, a detailed construction calendar covering a plurality of construction blocks is displayed on the screen of the administrator terminal 22 (step 113), and the administrator has an available operating space for each construction team. Status data is presented.

  The administrator confirms the detailed construction calendar of each construction team in charge of the designated construction block on the screen of the manager terminal 22 and can be operated on the construction day on which the application is made. An appropriate construction team that can perform the construction is selected, and a schedule registration request for officially registering the schedule of the construction team by operating the administrator terminal 22 is notified to the schedule management system 10 via the communication network 20. (Step 114).

  In response to the schedule registration request from the administrator terminal 22, the schedule management system 10 registers the schedule data based on the designated date and time and the construction team (step 115), and ends the series of schedule registration operations.

[Summary availability operation]
Next, with reference to FIG. 7, an outline empty state presenting operation in the schedule management system 10 according to the present exemplary embodiment will be described. FIG. 7 is a flowchart showing an outline empty state presentation operation.

  The schedule management system 10 executes the general availability state presenting operation of FIG. 7 in response to the availability status confirmation request notified from the person in charge terminal 21 via the communication network 20 based on the operation of the salesperson. It should be noted that, at the time of starting the general availability presenting operation, the assigned block data, the availability data, and the schedule data are already registered in the assigned block setting DB 11, the operation availability setting DB 12, and the schedule management book DB 13, respectively. To do.

First, the data acquisition unit 16 acquires from the responsible block setting DB 11 the responsible block data of the responsible construction group responsible for the construction block based on the construction block specified in the availability check request from the responsible person terminal 21. The responsible construction group is confirmed (step 120).
Subsequently, the data acquisition unit 16 acquires operation availability data relating to these assigned construction groups from the operation availability setting DB 12 (step 121), and acquires schedule data relating to these assigned construction groups from the schedule management book DB 13 (step 122). .

Next, the vacancy status presenting unit 17 indicates the vacancy status of the operation for each work team in charge of the construction block based on the availability data and schedule data acquired by the data acquisition unit 16 for each date, and for the date and time zone. The total is calculated for each combination (step 123).
At this time, for example, as shown in FIG. 2, since the construction time zone is set in relation to the sales office corresponding to the construction block, the operation availability data shown in FIG. 4 is used for time zones other than these construction time zones. Will not accept construction work. For this reason, even if the construction schedule is not registered in the schedule data, the time zones other than these construction time zones are counted as having no operating space.

In addition, the schedule data acquired by the data acquisition unit 16 indicates the operation schedule of each construction team in charge of the construction block designated in the availability check request. If other construction blocks other than the construction blocks specified in the above are also in charge, the operation schedule for other construction blocks is included.
Therefore, when schedule data is aggregated, construction schedules related to other construction blocks are also aggregated, so the date and time when construction schedules in other construction blocks are registered for any construction team in charge Even if the operation schedule in the construction block specified in the availability check request is not registered for the work group in charge, it is counted as no operation available.

Subsequently, the vacancy status presenting unit 17 generates a schematic construction calendar indicating an approximate operational vacancy status for each day based on the obtained counting results (step 124).
FIG. 8 is a configuration example of a schematic construction calendar. Here, the operating availability of each construction team in charge of the construction block “X2” specified in the availability check request is aggregated for each date, and the operating availability is indicated by characters such as “○” and “×” It is schematically displayed with symbols.

  In the example of FIG. 8, it is determined that there is no operation vacancy for the dates for which operation schedules are set for all of the construction teams in charge, and “X” is displayed on the general construction calendar. On the other hand, if there is no operation schedule set for any of the construction teams in charge, it is determined that there is an operation vacancy, and “O” is displayed on the general construction calendar. If the number of construction teams with operating vacancy is less than or equal to a preset threshold and the number of construction teams with operating vacancy is small, “Δ” may be displayed on the general construction calendar.

Thereafter, the vacancy status presentation unit 17 distributes and presents the generated general construction calendar to the person-in-charge terminal 21 via the communication network 20 as operating vacancy status data relating to the construction block (step 125).
As a result, the general construction calendar of the construction block is displayed on the screen of the person-in-charge terminal 21, and the operation availability data in the construction block designated by the availability confirmation request is presented.

[Detailed availability presentation]
Next, with reference to FIG. 9, the detailed availability state presenting operation in the schedule management system 10 according to the present exemplary embodiment will be described. FIG. 9 is a flowchart showing the detailed availability state presenting operation.

  The schedule management system 10 executes the detailed availability state presenting operation of FIG. 9 in response to the availability status confirmation request notified from the person in charge terminal 21 via the communication network 20 based on the operation of the sales person in charge. It should be noted that at the time of starting the detailed availability state presentation operation, the assigned block data, the availability data, and the schedule data are already registered in the assigned block setting DB 11, the operation availability setting DB 12, and the schedule management book DB 13, respectively. To do.

First, the data acquisition unit 16 acquires from the responsible block setting DB 11 the responsible block data of the responsible construction group responsible for the construction block based on the construction block specified in the availability check request from the responsible person terminal 21. The responsible construction group is confirmed (step 130).
Subsequently, the data acquisition unit 16 acquires operation availability data regarding these assigned construction teams from the operation availability setting DB 12 (step 131), and acquires schedule data regarding these assigned construction groups from the schedule management book DB 13 (step 132). .

Next, the vacancy status presentation unit 17 calculates the operation man-hours related to each work team in charge of the construction block based on the operation availability data and schedule data acquired by the data acquisition unit 16, that is, the registered man-hours or the man-hours for each date. For each combination of date and time zone and for each construction team in charge (step 133).
At this time, for example, as shown in FIG. 2, since the construction time zone is set in relation to the sales office corresponding to the construction block, the operation availability data shown in FIG. 4 is used for time zones other than these construction time zones. Will not accept construction work. For this reason, even if the construction schedule is not registered in the schedule data, the vacant man-hours in the construction block in each responsible construction group are counted as 0 for the time zones other than these construction time zones.

In addition, the schedule data acquired by the data acquisition unit 16 indicates the operation schedule of each construction team in charge of the construction block designated in the availability check request. If other construction blocks other than the construction blocks specified in the above are also in charge, the operation schedule for other construction blocks is included.
Therefore, when the schedule data is aggregated, the registered man-hours related to other construction blocks are also aggregated together. The registered man-hours will be totaled even if the working man-hours are not registered in the construction block specified in the availability check request for the responsible construction group.

Subsequently, the empty status presenting unit 17 generates a detailed construction calendar indicating the detailed operating man-hour availability status for each day based on the obtained counting result for each construction team in charge (step 134).
FIG. 10 is a configuration example of a detailed construction calendar. Here, the registered man-hours and the total man-hours of the construction team “A” in charge of the construction block “X2” designated in the availability check request are aggregated for each date and displayed as the operating man-hour availability status. .
In the example of FIG. 10, the registered man-hours and the total man-hours of the assigned construction team “A” are displayed for each date. Therefore, the administrator determines the remaining man-hours that can be registered from the difference between these registered man-hours and the total man-hours. Can be confirmed.

Thereafter, the vacancy status presentation unit 17 distributes the generated detailed work calendar as operation vacancy status data related to the work block to the manager terminal 22 through the communication network 20 and presents it (step 135).
As a result, the detailed construction calendar of the construction block is displayed on the screen of the manager terminal 22, and the operation availability data in the construction block designated by the availability confirmation request is presented.

  The general construction calendar and the detailed construction calendar are not limited to the configuration examples shown in FIGS. 8 and 10, and may be configured in other formats. For example, instead of “◯”, “×”, “Δ” in FIG. 8, color-coded display may be performed, and instead of the registered man-hours and the total man-hours in FIG. May be.

Further, according to a mouse selection operation on an arbitrary date column in the general construction calendar or the detailed construction calendar, the operating availability on the date may be displayed in detail on a pop-up screen for each time zone.
FIG. 11 is an example of a detailed display screen of the general construction calendar. Here, for each time zone “AM1”, “AM2”, “PM1”, “PM2” provided in the morning and in the afternoon, the operating availability on the selected date is displayed in detail on a pop-up screen. Yes.

FIG. 12 is an example of a detailed display screen of the detailed construction calendar. Here, for each time zone “AM1”, “AM2”, “PM1”, “PM2” provided in the morning and in the afternoon, the registered man-hours and the total man-hours on the selected date are displayed in detail on the pop-up screen. It is displayed.
Further, in the detailed display screen of FIG. 12, instead of the registered man-hours and the total man-hours, schedule data corresponding to the date, time zone, and construction team is acquired from the schedule management book DB 13 and displayed in detail on a pop-up screen. You may make it do.

[Effect of the first embodiment]
As described above, in this embodiment, the data acquisition unit 16 confirms the assigned work group in charge of the designated work block with the assigned block data in the assigned block setting DB 11 and operates the availability data on these assigned work groups. Acquired from the availability setting DB 12 and also acquired schedule data related to these assigned construction groups from the schedule management book DB 13, and the vacancy status presentation unit 17, based on the obtained availability data and schedule data, each assigned construction group for the construction block. To calculate the construction availability calendar showing the daily availability of operation based on the obtained counting results, and present the generated construction calendar as operation availability data for the construction block It is a thing.

  As a result, when the construction team in charge is in charge of other construction blocks other than the construction block specified in the availability check request, the schedule data acquired by the data acquisition unit 16 includes the operation schedule related to other construction blocks. Will be. For this reason, when the availability state presentation unit 17 aggregates the schedule data, the operation schedules related to other construction blocks are also aggregated together. Therefore, the operation schedules in other construction blocks are registered for any construction team in charge. The operation date is counted as no operation available even if the operation schedule in the construction block designated in the availability confirmation request is not registered for the construction group in charge.

  Therefore, even if a plurality of construction teams are in charge of a plurality of construction blocks, and the relationship between the construction blocks and the construction team is M: N (M, N is an integer of 2 or more), it is designated. It is possible to present accurate operating availability data indicating the availability of the construction team in the construction block.

  In particular, since the schedule management technology according to the above-described conventional technology based on the relationship of 1: 1 or 1: N cannot be used, the business is in a situation where the manager manually determines whether or not construction is possible in the construction block. There was a problem that user (customer) negotiations could not be proceeded smoothly because of inquiries from the person in charge. According to the present embodiment, before a formal application for construction is made, the sales representative can check the availability of the construction team on the person-in-charge terminal 21 very easily and quickly. Can lead to improved service to users.

Further, in the present embodiment, the operation availability data includes the operation man-hour indicating the work scale that the construction team can handle for each date and time, and the vacancy status presentation unit 17 is based on the acquired operation availability data and schedule data. Total number of registered or vacant man-hours for operation for each work group in charge of the construction block is counted for each work group in charge, and a detailed work calendar showing the daily availability of work hours based on the obtained count results Each of these detailed work calendars is generated and presented as operational availability data.
Therefore, since the availability of each construction group in the designated construction block is presented in terms of the number of operating man-hours, it is possible to grasp the availability of each construction group in very detail.

Further, according to the present embodiment, when the availability check request is received from the sales representative, that is, the person in charge terminal 21, a general construction calendar not including the individual operation availability for each construction team is generated and the person in charge terminal is created. 21. When a vacancy status confirmation request is received from the administrator, that is, the manager terminal 22, a detailed construction calendar including individual operating vacancy status for each construction team is generated and presented to the manager terminal 22. It is a thing.
As a result, the sales staff can be provided with only the minimum operating availability data necessary for user (customer) negotiations. Therefore, it is possible to suppress an increase in the burden on the operation setting and the construction team, which may occur when detailed operating availability data is presented to the sales staff. In addition, the manager can appropriately adjust the operation schedule according to the priority and urgency of each construction.

[Second Embodiment]
Next, the schedule management system 10 according to the second exemplary embodiment of the present invention will be described.
In step 106 of FIG. 6 described above, when the sales representative requests the manager to adjust the schedule by a construction adjustment request, it may be requested by telephone or e-mail. However, for such a request, it is necessary to explain the details of the construction work to the administrator, so that communication takes a long time by telephone and the work efficiency is poor. In addition, e-mail takes time to create an explanatory document, and it is difficult to automate importing, and manual input is inefficient.

In the present embodiment, details will be described in the case where the sales person operates the person-in-charge terminal 21 to make a construction adjustment request to the schedule management system 10 and the adjustment request is made using an electronic form.
As described above, the construction management unit 15 receives the construction adjustment request notified from the person-in-charge terminal 21 via the communication network 20 based on the operation of the sales person, and schedules the adjustment request data including the contents of the adjustment request. It has a function of registering in the management book DB 13.

  For a construction adjustment request using an electronic form, a technique for creating a form form from a spreadsheet file (see, for example, Patent Document 2) may be used. However, in order to link the content described in the form form with the schedule management system 10, the construction management unit 15 needs to fetch each item data of the form form as each item data of the adjustment request data.

  At this time, if a dedicated linkage program is created, each item data of the form form can be imported into each item data of the adjustment request data, but the details of the import process differ depending on the schedule management work such as the type of facility construction. For this reason, it is necessary to change a cooperation program according to the work environment where the schedule management system 10 is utilized, which leads to an increase in development cost.

Here, a form used when displaying an electronic form on a screen is generally described in a markup language such as HTML, and these forms are displayed on the screen as a Web page by a browser function.
In addition, various objects of the Web page generated by the rendering process of the browser function can be accessed from a script program described in the Web page using DOM (Document Object Model) technology.

  In this embodiment, from this point of view, the corresponding items are defined in advance in the copy definition data between the Web page indicating the work adjustment request form and the Web page indicating the adjustment request data input form. In addition, each item data is copied between the item objects of these Web pages displayed on the screen by the browser function based on the copy definition data.

  Each item data displayed on the Web page is described using tags, and identification information such as “name” and “id” can be given to these tags. These tags can also be specified as identification objects consisting of the description order (position information) from the top of the Web page as child objects of the Web page.

  FIG. 13 is a configuration example of copy definition data. Here, in addition to the identification information (for example, page title) of the copy source Web page indicating the form form of the construction adjustment request and the identification information (for example, page title) of the copy destination Web page indicating the input form of the adjustment request data, copying is performed. For each item ID unique to the item data pair to be copied, identification information of the copy source item object corresponding to the item data on the copy source Web page and the copy destination item object corresponding to the item data on the copy destination Web page Identification information is registered.

Such a construction adjustment request is taken in by the construction management unit 15 in accordance with an operation performed by the manager on the manager terminal 22.
FIG. 14 is a screen display example showing a construction adjustment request fetch screen. Here, an input form for adjustment request data serving as a copy destination is displayed on the left side of the capture screen, and a form form for construction adjustment requests is displayed on the right side of the capture screen.

  In response to the operation of the administrator, the construction management unit 15 displays this capture screen on the administrator terminal 22, and in response to the capture start operation on this capture screen, the construction management unit 15 first starts from the copy source Web page. The item data of the item object corresponding to the identification information of the copy source item object defined in the copy definition data is acquired, and then the item data is defined in the copy definition data in the copy destination Web page. It is copied as item data of the item object corresponding to the identification information of the copy destination item object.

  Thus, for example, in FIG. 14, the desired construction date and desired time zone described in the work adjustment request form are copied to the construction date and time zone fields of the adjustment request data input form, respectively. Similarly, the customer name and installation address described in the work adjustment request form are copied to the customer name and customer address fields of the adjustment request data input form.

[Effect of the second embodiment]
As described above, in the present embodiment, the construction management unit 15 responds to the construction adjustment request from the person-in-charge terminal 21 of the salesperson who receives an order for the construction, and describes the description content of the form form of the construction adjustment request as the adjustment request data. It is intended to import into the input form. More specifically, the copy source item defined by the copy definition data from the copy source Web page showing the form form based on the copy definition data registered in advance by the construction management unit 15 Each item data of the item object corresponding to the object identification information is acquired, and the item data is identified from the copy destination item object defined in the copy definition data in the copy destination Web page indicating the input form. Are copied as item data of the corresponding item object.

  Thereby, the content of the construction adjustment request notified from the person in charge terminal 21 via the communication network 20 based on the operation of the sales person in charge can be linked with the schedule management system 10. At this time, it is possible to cope with the work environment in which the schedule management system 10 is used only by editing the copy definition data, and the development cost can be greatly reduced as compared with the case of creating a dedicated linkage program.

[Extended embodiment]
The present invention has been described above with reference to the embodiments, but the present invention is not limited to the above embodiments. Various changes that can be understood by those skilled in the art can be made to the configuration and details of the present invention within the scope of the present invention. In addition, each embodiment can be implemented in any combination within a consistent range.

  DESCRIPTION OF SYMBOLS 10 ... Schedule management system, 11 ... Responsible block setting DB, 12 ... Operation availability setting DB, 13 ... Schedule management book DB, 14 ... Setting management part, 15 ... Construction management part, 16 ... Data acquisition part, 17 ... Space availability presentation , 20 ... communication network, 21 ... responsible person terminal, 22 ... administrator terminal, L ... communication line.

Claims (7)

A schedule management system for managing a schedule of a service provider in charge of providing the service for each service providing place that provides the service,
A responsible block setting DB for storing responsible block data indicating the service providing location that the service provider is in charge of;
An operation availability setting DB for storing operation availability data indicating the date and time when the service provider can operate;
A schedule management book DB for storing schedule data indicating a schedule of services handled by the service provider at the service providing location;
The responsible service provider in charge of the designated service providing location is confirmed by the responsible block data in the responsible block setting DB, and the availability data regarding these responsible service providers is acquired from the availability setting DB, and these responsible services A data acquisition unit for acquiring schedule data related to the provider from the schedule management book DB;
Based on the acquired availability data and the schedule data, an outline service calendar that summarizes the availability of operation for each service provider at the service provision location and indicates the availability of operation every day based on the obtained aggregation result And a vacancy status presentation unit that presents the generated general service calendar as operational vacancy status data related to the service providing location. In the schedule management system according to claim 1,
The operation availability data includes an operation man-hour indicating a work scale that can be handled by the service provider for each date and time,
The availability state presenting unit, based on the acquired availability data and the schedule data, totals the registered man-hours or vacant man-hours for each service provider in charge for each service provider, A detailed service calendar showing the availability of operating man-hours per day based on the obtained counting results is generated for each service provider concerned, and the generated detailed service calendar is presented as the operating availability data. Schedule management system. In the schedule management system according to claim 2,
When the availability presenting unit receives an availability confirmation request from a person in charge of a salesperson who receives an order for service, the availability presenting unit generates the general service calendar and operates as the availability data on the service providing location. When the availability check request is received from the administrator terminal of the administrator who presents to the user terminal and adjusts the schedule of the service for which the service provider is responsible, the detailed service calendar is generated to relate to the service providing location. A schedule management system characterized in that it is presented to the manager terminal as operating availability data. In the schedule management system according to any one of claims 1 to 3,
In response to a service adjustment request from the person in charge of a salesperson who receives an order for a service, the service management unit further incorporates the description content of the form form of the service adjustment request into the input form of the adjustment request data.
The service management unit, based on the copy definition data registered in advance at the time of the import, identifies the copy source item object defined by the copy definition data from the copy source Web page indicating the form form. And item data corresponding to the item object corresponding to the copy destination item object defined in the copy definition data in the copy destination Web page indicating the input form. A schedule management system characterized by copying as item data of an item object. In the schedule management system according to any one of claims 1 to 4,
The service is composed of construction work, the service providing place is composed of construction blocks set in advance as a range for managing the construction work, and the service provider is composed of respective construction teams in charge of the construction block. A schedule management system that manages the schedule of each construction group in charge of construction blocks. A schedule management method for managing a schedule of a service provider in charge of providing the service for each service providing place that provides the service,
Storing responsible block data indicating the service providing location that the service provider is responsible for in the responsible block setting DB;
Storing operation availability data indicating the date and time when the service provider can operate in an operation availability setting DB;
Storing schedule data indicating a schedule of services handled by the service provider at the service providing place in a schedule management book DB;
The data acquisition unit confirms the responsible service provider in charge of the designated service providing location with the responsible block data in the responsible block setting DB, and acquires the availability data on these responsible service providers from the availability setting DB. And a data acquisition step of acquiring schedule data related to these responsible service providers from the schedule management book DB;
Based on the obtained availability data and the schedule data, the availability status presenting unit aggregates the availability status of each service provider at the service providing location, and the daily availability based on the obtained count result A schedule management method comprising: generating an outline service calendar indicating a situation, and presenting the generated outline service calendar as operational availability data relating to the service providing location.   The program for functioning a computer as each part which comprises the schedule management system as described in any one of Claims 1-5.

Images