JP6263046B2 - Information processing apparatus and program - Google Patents

Description

  Embodiments described herein relate generally to an information processing apparatus and a program.

Conventionally, a store server is arranged in a store or the like, and a plurality of POS terminals can be centrally managed by the store server.
As one function of this store server, there is a function that schedules a sale period and prints out a product list for a store clerk to replace a POP advertisement (Point of purchase advertising) before and after the sale.
The store clerk performs a replacement work for the POP advertisement of the product while looking at this list.

However, since this list displays all products that start or end sale, the list also includes products that do not change in price before and after the sale starts and before and after the sale ends. It will be.
For products that do not change in price, there is no need for a POP advertisement replacement work, so if the product is included in the list, the store clerk mistakes it for a product that needs replacement.

  The problem to be solved by the present invention is to provide an information processing apparatus and program capable of outputting a list of products for which a POP advertisement is to be replaced.

The information processing apparatus according to the embodiment includes an input unit that inputs a date indicating a scheduled date of attachment / detachment of an advertisement indicating product price information, a start date and an end date of a planning period for each product, and within the planning period and Storage means for storing the price information of the product on the day before the start date of the planning period, and the storage means stores a product having the date input by the input means as the start date or end date of the planning period. and it searches the product, as the search conditions and the price of the goods on the day before the price and the date are different in the date of the product, in the date, generates a detachable previous list Kihiro WARNING detachable A list generation unit; and an output unit that outputs the attachment / detachment list.

FIG. 1 is a schematic configuration diagram of a POS system. FIG. 2 is a hardware configuration diagram of the store server according to the first embodiment. FIG. 3 is a configuration diagram of the reservation table and the standard unit price table. FIG. 4 is a configuration diagram of the work table. FIG. 5 is an example of a search screen. FIG. 6 is a flowchart of the form output program. FIG. 7 is an explanatory diagram of stored data in the work table. FIG. 8 is an explanatory diagram of data stored in the work table after execution of the program. FIG. 9 shows a form output example. FIG. 10 is a flowchart of the form processing program in the second embodiment. FIG. 11 is an explanatory diagram of stored data in the work table. FIG. 12 is a configuration diagram of a reservation table in the third embodiment. FIG. 13 is a flowchart of the form output program. FIG. 14 is a form output example of each of the display device and the printer in the fourth embodiment. FIG. 15 is a form output example of each of the display device and the printer in the fifth embodiment.

  Below, the case where the information processing apparatus of this embodiment is applied to the store server arrange | positioned in stores, such as a supermarket, is demonstrated.

(First embodiment)
FIG. 1 is a schematic configuration diagram of a POS (Point of Sales) system.
As shown in FIG. 1, a POS system 1 includes a plurality of (two in the figure) POS terminals 2 as product data processing apparatuses, and communication such as a LAN (Local Area Network) 3 to these POS terminals 2. The store server 4 is connected via a network and centrally manages the POS terminal 2.

  The store server 4 is responsible for overall control of the POS system 1. In addition, the display 40-1 and the printer 40-2 are provided, and a function for creating and outputting an instruction sheet (POP attachment / detachment list) for instructing a store clerk to change or create a POP advertisement (Point of purchase advertising). It is what has. With this function, a POP attachment / detachment list (hereinafter referred to as a form) can be displayed on the display unit 40-1 or printed out by the printer 40-2.

FIG. 2 is a hardware configuration diagram of the store server 4. The store server 4 includes a control unit 41 including a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), a communication I / F 43, and an I / O device control unit 44. It is configured to be connected via a bus 42.
The CPU is a central processing unit that executes various programs and controls each unit.
The ROM is a rewritable nonvolatile memory such as an EEPROM or a Flash ROM.

A BIOS is stored in the EEPROM. The Flash ROM stores data such as a form output program P for outputting a POP advertisement attachment / detachment list, a search screen T, and the like. The form output program P and the search screen T will be described later.
The RAM is a volatile memory such as SRAM or DRAM. The RAM is used as a work area for programs executed by the CPU.

The I / O device control unit 44 is connected to a keyboard 45, a display 46, a printer 47, and an HDD (Hard Disk Drive) 48, and controls communication between the CPU and each unit.
The keyboard 45 includes a plurality of types of input keys, and transmits an input signal corresponding to the pressed input key to the CPU through the I / O device control unit 44.

The display 46 includes a display screen such as a liquid crystal display, converts character information and image information transmitted from the CPU into display data, and outputs the display data.
The printer 47 converts the character information and image information transmitted from the CPU into print data and prints it on a print sheet.

  An HDD (Hard Disk Drive) 48 stores an OS (Operating System), application programs, and the like. The HDD 48 has various databases, and is used in the reservation table Tb1 for reserving special sales, the standard unit price table Tb2 for registering the standard unit price of the product, and the form output program P, respectively. A primary table for work (hereinafter referred to as a work table) Tb3 and, for example, a product master table is stored as a reference table.

The communication I / F 43 is connected to the LAN 3 (see FIG. 1), and performs network communication between the store server 4 and the plurality of POS terminals 2.
Next, processing of the form output program P stored in the FlashROM of the control unit 41 will be described.

First, a table and the like referred to by the form output program P will be described.
FIG. 3 is a configuration diagram of fields of the reservation table Tb1 and the standard unit price table Tb2.
As shown in FIG. 3, the fields of the reservation table Tb1 are “product code” F11, “plan code” F12, “plan period (start date and time)” F13, “plan period (end date and time)” F14, and “ It consists of items such as “set unit price” F15. Other items are omitted in the figure.

The “product code” F11 stores a unique identification code of the product.
In the “plan code” F12, a unique identification code of the plan is stored.
In the “planning period (start date and time)” F13, the start date and time of the period in which the planning is performed is stored.
The “planning period (end date and time)” F14 stores the end date and time of the period in which the planning is performed.

The “set unit price” F15 stores the sale unit price during the planning period. This special sale unit price is constant throughout the planning period.
The “plan” described in this specification mainly refers to special sales.
The other field of the standard unit price table Tb2 includes items of “product code” F11 and “standard unit price” F22.

The “standard unit price” F22 stores a normal product unit price.
In each item of the reservation table Tb1 and the standard unit price table Tb2, related data acquired from a reference table such as a manual input by a user or a product master table is registered. Detailed description of this registration is omitted.

In the following description, it is assumed that data for a plurality of records has already been registered in the reservation table Tb1 and the standard unit price table Tb2.
Next, the configuration of the work table Tb3 for temporarily storing data in the processing of the form output program P will be described.

FIG. 4 is a configuration diagram of the work table Tb3.
As shown in FIG. 4, the fields of the work table Tb3 include “section” F31, “store code” F41, “store name” F42, “department” F43, “product code” F11, “product name” F44, “plan code”. F12, “plan name” F45, “plan period (start date and time)” F13, “plan period (end date and time)” F14, “set unit price” F15, “unoutput flag” F32, and the like Is done.

  When the form output program P is executed, the data extracted from the reservation table Tb1 and the standard unit price table Tb2, the intermediate generated data, and the like are registered in each field of the work table Tb3. Information that is acquired from the reference table as appropriate is registered for information not included in the reservation table Tb1 or the standard unit price table Tb2.

Next, a search screen that is an initial screen of the form output program P will be described.
FIG. 5 is an example of the search screen.
The search screen T shown in the figure is provided with “category” T1 and “designated date” T2 as selection items. A form output button T3 is provided as an execution button.
The “classification” T1 is an item for selecting “return” for removing the POP advertisement and “setting” for pasting the POP advertisement.

“Designated date / time” T2 is an item for designating the date and time of the output form (scheduled date / time of POP advertisement).
When the user inputs search information in the input fields T10 and T20 of each item and presses the form output button T3, the CPU performs predetermined processing described in the form output program P using the search information as a key.
In this example, “category” T1 and “designated date” T2 are provided as search items, but “plan name”, “product name”, “store name”, “department”, etc. are added as search items. May be.

Here, the processing flow of the form output program P will be described.
FIG. 6 is a flowchart of the form output program P.
The form output program P starts processing when the first instruction code of the form output program P is read into the CPU manually or automatically.

If it is manual, the form output program P is read by the CPU when the user presses the execution key on the keyboard 45, and the process is started.
If it is automatic, the user sets the activation timing in advance, and when the activation timing is reached, the form output program P starts up and the processing is started. For example, the business end time is set as the start timing at the time measured by the system clock. In this case, when the business end time is reached, the form output program P is automatically read by the CPU and the processing is started. If logon is set as the activation timing, the form output program P is automatically read into the CPU when the user logs on, and the process is started.

First, when the form output program P is activated, a search screen T is displayed on the screen of the display 46 (S1).
Next, it is determined whether or not the form output button T3 on the search screen T in FIG. 5 has been pressed (S2).
If “NO” is determined in step S2, the process waits until pressing of the form output button T3 is detected.

Here, it is assumed that the user inputs “return / setting” in the input field T20 of the search screen T in FIG. 5 and presses the form output button T3.
Then, “YES” determination is made in step S2, and information on the product corresponding to “return” is extracted from the reservation table Tb1 and registered in the work table Tb3 (S3). Information that is not in the reservation table Tb1 is appropriately acquired from the reference table and registered.
More specifically, the process of step S3 is as follows.

In the search table T (see FIG. 5), an input field for “designated date”, with the date and time information stored in the “planning period (end date and time)” F14 of the reservation table Tb1 (see FIG. 3) as a search target. A record that matches the designated date and time the day before the date and time input at T20 is extracted.
The extracted records are sequentially stored in the work table Tb3 (see FIG. 4). At this time, “return” is set in the “classification” F31 of each record. Information that is missing in the record is appropriately acquired from a reference table such as a master table and stored in the corresponding item.

Accordingly, immediately after the process of step S3, only the “unoutput flag” F32 becomes “NULL”.
Subsequent to step S3, information on the product corresponding to “setting” is extracted from the reservation table Tb1 and registered in the work table Tb3 (S4).
The information extracted in step S4 is also registered in each item of the work table Tb3 as in step S3. Information that is not in the reservation table Tb1 is appropriately acquired from the reference table and registered.

More specifically, the process of step S4 is as follows.
In the search table T (see FIG. 5), an input field for “designated date”, with the date and time information stored in the “planning period (start date and time)” F13 of the reservation table Tb1 (see FIG. 3) as a search target. A record that matches the date and time input at T20 is extracted.

The extracted records are stored sequentially in the work table. At this time, “setting” is set in the “classification” F31 of each record. Information that is missing in the record is appropriately acquired from a reference table such as a master table and stored in the corresponding item.
Therefore, immediately after the process of step S4, only the “unoutput flag” F32 becomes “NULL”.

Here, the contents of the stored data in the work table Tb3 (see FIG. 4) will be described.
FIG. 7 is an explanatory diagram showing the contents of the stored data in the work table Tb3 after the process of step S4.
In the figure, the “return” product list (“return” list A) is arranged on the left side, and the “return” product list (“setting”) is associated with each “return” product code on the right side of FIG. "List B) was placed. Needless to say, records corresponding to “setting” are actually stored sequentially from the row following the last row of “return”.

The figure shows that when “February 3” is entered in the “designated date” input field T20 on the search screen T (see FIG. 5) and “return / setting” is entered in “category”, The contents of stored data in the work table Tb3 (see FIG. 4) are shown.
In this example, when the process of step S3 in FIG. 6 is executed, “February 3” is targeted for the information stored in the “planning period (end date and time)” F14 of the reservation table Tb1 (see FIG. 3). ", The record having the day before" February 2 "is extracted. Then, “return” is added as “category” F31 to the extracted record and stored in the work table Tb3.

  In the “return” list A in FIG. 7, it is assumed that the reservation information of the product codes 1 to 4 corresponding to the plan code 1 and the reservation information of the product codes 5 to 10 corresponding to the plan code 2 correspond to “return”. Registered as a record. At this stage, the “unoutput flag” F32 is “NULL”.

  When the process of step S4 in FIG. 6 is executed, a record having “February 3” is extracted for the storage information of the “planning period (start date and time)” item F13 in the reservation table Tb1. Will be. Then, “set” is added as “category” F31 to the extracted record and stored in the work table Tb3.

In the “setting” list B in FIG. 7, the reservation information of the product codes 1 to 7 and 11 to 15 corresponding to the plan code 3 is registered as records corresponding to “setting”. Also in the “setting” list B, the “unoutput flag” F32 is “NULL” at this stage.
Returning to the processing of FIG. 6, the processing from step S5 to step S9 will be described with reference to FIGS. 7 and 8 as appropriate. The processing from step S5 to step S9 corresponds to an attach / detach list generating means for generating a form by deleting a record of a product having no unit price fluctuation.

  First, in step S5, a “NULL” record is searched for the “unoutput flag” F32 of the work table Tb3 (see FIG. 4), and the record hit by this search is further searched for in the “product code” F11. Search for records with duplicate product codes. Then, the presence or absence of the corresponding record is determined based on the search result. In the example shown in FIG. 7, all records with the “unoutput flag” F32 of “NULL” are all records. As is clear from the comparison between the “return” list A and the “setting” list B, the records having the same product code among all the records are the product codes 1 to 7.

  If “YES” is determined in step S5, a pair of records having a lower number in the product code is extracted from the corresponding records (S6). In the example of FIG. 7, the record of the product code 1 in the “return” list A and the record of the product code 1 in the “setting” list B first correspond to each other. Thereafter, similarly, the product codes 2 and 3 are sequentially followed, and the record of the product code 7 in the “return” list A and the record of the product code 7 in the “setting” list B correspond to each other.

  Subsequently, the information of each “set unit price” F15 included in the pair of records extracted in step S6 is compared to determine whether the information matches, that is, whether the set unit price is the same (S7). In the example of FIG. 7, since the first corresponding record is the product code 1, the set unit price “100 yen” in the “return” list A and the set unit price “100 yen” in the “set” list B are to be compared. Thereafter, the set unit price “50 yen” of the product code 2 in the “return” list A and the set unit price “50 yen” of the product code 2 in the “setting” list B are sequentially compared, and the set unit price of the product code 3 is similarly compared. Finally, the set unit price “50 yen” of the product code 7 in the “return” list A and the set unit price “80 yen” of the product code 7 in the “setting” list B are to be compared.

  If “NO” is determined in step S7, “0” indicating that the set unit price fluctuates is input to the “unoutput flag” F32 of the work table Tb3 (S8), and the process is repeatedly executed from the process of step S5. In the example of FIG. 7, the set unit prices of the product codes 5 to 7 in the “return” list A and the set unit prices of the product codes 5 to 7 in the “setting” list B are inconsistent at “50 yen” and “80 yen”, respectively. Therefore, “0” is registered in the “unoutput flag” F32 of the product codes 5 to 7 in the “return” list A and the “setting” list B, respectively.

  On the other hand, if “YES” is determined in step S7, “1” indicating that the set unit price does not fluctuate is input to the “unoutput flag” F32 of the work table Tb3 (S9), and the processing from step S5 is repeated. In the example of FIG. 7, the set unit prices of the product codes 1 to 4 in the “return” list A and the set unit prices of the product codes 1 to 4 in the “setting” list B are “100 yen” and “100 yen” or “50 yen”. Therefore, “1” is registered in the “unoutput flag” F32 of the product codes 1 to 4 of the “return” list A and the “setting” list B. In FIG. 7, the record in which “1” is registered in the “unoutput flag” F32 is shown by shading. It should be noted that records in which “1” is registered in the “unoutput flag” F32 in the processing described later are also shaded.

FIG. 8 is an explanatory diagram showing the contents of the stored data in the work table Tb3 after the execution process of the program P is finished.
In FIG. 7, the product list in the “return” list A and the product list in the “setting” list B in FIG. 7 are shown in a normal arrangement.

  When the process of step S9 is performed, as shown in a range 80 of FIG. 8, each of the product codes 1 to 4 having “return” “classification” F31 and the product codes 1 to 4 having “setting” F31 is “set”. In the record, “1” is set in the field of “unoutput flag” F32. Further, as shown in the range 81 of FIG. 8, “0” is set in the “unoutput flag” F32 column for each record of the product codes 5 to 7 of “return” and “setting”.

When a value is set in the “unoutput flag” F32 field of all corresponding records as described above, a “NO” determination is made in step S5, and the process proceeds to the subsequent step S10.
In the process of step S10, a comparison process between the set unit price and the standard unit price is executed.

  In the process of step S10, a record in which the product code does not overlap is searched for the “product code” F11 of the work table Tb3 (see FIG. 4), and “return” is further selected for the “classification” F31 in the record. Search the set record and extract the corresponding record. In the example of FIG. 7, the product codes 8 to 10 are in the “return” list A and not in the “setting” list B. Therefore, the records of the product codes 8 to 10 are applicable.

Subsequently, the standard unit price table Tb2 (see FIG. 3) is searched using the product code of the extracted record as a search key, and the standard unit price is extracted from the “standard unit price” F22 of the corresponding record.
Then, for each product code, the set unit price of the previously extracted record is compared with the standard unit price of the product extracted later.

  When the comparison result is coincident, “1” indicating that the set unit price does not fluctuate is input to the “unoutput flag” F32 of the work table Tb3. When the comparison results do not match, “0” indicating that the set unit price fluctuates is input to the “unoutput flag” F32 of the work table Tb3. In the example of FIG. 7, if the record of the product code 8 is used as a search key, the standard unit price of the product code 8 is extracted from the standard unit price table Tb2, and the set price and the extracted standard unit price of the record of the product code 8 are extracted. And compare. Further, information on the standard unit price corresponding to the product codes 9 and 10 is extracted and compared with each set unit price. In this example, for convenience, all the standard unit prices of the product codes 8 to 10 are set to 100 yen, and this standard unit price is arranged in the list B for comparison with the set unit price. Accordingly, since the product codes 8 and 9 have the set unit price “100 yen” and match the standard unit price “100 yen”, “1” is stored in the “unoutput flag” F32 of the work table Tb3. Since the product code 10 has a set unit price “50 yen” and is different from the standard unit price “100 yen”, “0” is stored in the “unoutput flag” F32 of the work table Tb3.

In FIG. 8, as shown in a range 82, “1” is set in the “unoutput flag” F 32 column of the product codes 8 and 9 whose “category” F 31 is “return”. Further, as shown in the range 83, “0” is set in the “unoutput flag” F32 field of the product code 10 whose “classification” F31 is “return”.
Subsequently, in step S11, the set unit price and the standard unit price are compared.
In this process, a record in which the product code does not overlap is searched for the “product code” F11 in the work table Tb3 (see FIG. 4), and “setting” is set for the “classification” F31 among the records. Search the record and extract the corresponding record.
Next, the standard unit price table Tb2 (see FIG. 3) is searched using the product code of the extracted record as a search key, and the standard unit price is extracted from the “standard unit price” F22 of the corresponding record.
Then, for each product code, the set unit price of the previously extracted record is compared with the standard unit price of the product extracted later.

  When the comparison result is coincident, “1” indicating that the set unit price does not fluctuate is input to the “unoutput flag” F32 of the work table Tb3. When the comparison results do not match, “0” indicating that the set unit price fluctuates is input to the “unoutput flag” F32 of the work table Tb3.

  In the example of FIG. 7, if the product code 11 is used as a search key, the standard unit price of the product code 11 is extracted from the standard unit price table Tb2, and the set price of the record of the product code 11 is compared with the extracted standard unit price. To do. Further, information on the standard unit price corresponding to the product codes 12 to 15 is extracted and compared with each set unit price. In this example, all the standard unit prices of the product codes 11 to 15 are set to 50 yen for convenience, and this standard unit price is arranged in the list A for comparison with the set unit price. Accordingly, since the product code 15 has a set unit price “50 yen” and matches the standard unit price “50 yen”, “1” is stored in the “unoutput flag” F32 of the work table Tb3. Since the product codes 11 to 14 have a set unit price “100 yen” and are different from the standard unit price “50 yen”, “0” is stored in the “unoutput flag” F32 of the work table Tb3.

  In FIG. 8, as shown in a range 85, “1” is set in the “unoutput flag” F 32 column of the product code 15 whose “classification” F 31 is “set”. Further, as shown in the range 84, “0” is set in the “unoutput flag” F32 column of the product code 10 whose “classification” F31 is “set”.

As described above, the program P sets a value, that is, a determination value of a product having no price fluctuation, in the “unoutput flag” F32 of all the records of the work table Tb3.
When values are set in the “unoutput flag” F32 of all records in the work table Tb3, a form of a predetermined form corresponding to the output form is generated based on the information set in the work table, and the form is generated. Is output (S12), and this process ends. A form output device is a display 46 or a printer 47. The display unit 46 displays the form on the display screen, or the printer 47 prints the form on the printing paper and outputs it, and the process is terminated.

In this way, this process functions as a detachment list generation unit that generates a form by deleting a record of a product with no unit price fluctuation.
FIG. 9 shows an output example of the form (also referred to as attachment / detachment list) in step S12.
In this example, a product for which “1” is set in the “unoutput flag” F32 is deleted, and only products for which “0” is set in the “unoutput flag” F32 are output in a form. . In addition, here, the category is “set”, that is, only products for which a POP advertisement needs to be pasted are output as a form.

  The form 90 shown in the figure is a case in which other information such as “business days”, “weather”, and “in-house code” is added in addition to the items in the work table shown in FIG.

  The “new unit price” F91 of the form 90 corresponds to the “set unit price” F15. “Special sale NO” F92 corresponds to “plan code” F12. “JAN (Japan Article Number) code” F93 corresponds to “product code” F11. The “name” F94 corresponds to the “product name” F44. The “start date and time” F95 and the “end date and time” F96 correspond to a “planning period (starting date and time)” F13 and a “planning period (end date and time)” F14, respectively. In this example, the time is displayed, but these are the business start time of the store added when the start date is set in the “plan period (start date and time)” F13 and the “plan period (end)”. Date and time) ”is the business end time of the store added when the end date is set in F14.

  When the values set in the “new unit price” F91 and the “standard unit price” F22 are confirmed, the value of the first product “product A” R1 is different between the standard unit price “219 yen” and the new unit price “180 yen”. It can be seen that this is a product that requires a POP to be attached. All other products are different from the new unit price and the standard unit price, and require a POP to be pasted on the new unit price. Therefore, products that do not change in price in this list, that is, products that do not require POP pasting, are not output.

(Second Embodiment)
In the first embodiment, the configuration of the store server that outputs a form in units of dates has been described.
In the second embodiment, a configuration of a store server that outputs a form in units of time will be described.
Here, a time service will be described as an example of time unit planning.

  Since the time service is a plan in which the sale period is divided in units of time, the start time is divided in time in the “plan period (start date and time)” F13 and the “plan period (end date and time)” F14 in the reservation table Tb1. It is necessary to set an end time in advance. In the first embodiment, the business start time is set as the start time and the business end time is set as the end time in the project divided in units of one day. For this reason, in the second embodiment, it is assumed that the store business start time and business end time are not used in the time service.

  For example, if the store's business hours are from 9:00 to 21:00, it is not used at 9:00 and 21:00. When the time service is implemented from 16:00 to 18:00, the date and start time “16:00” are set in the “planning period (start date and time)” F13, and the date is set in the “planning period (end date and time)” F14. And end time “18:00”.

FIG. 10 is a flowchart of the form processing program P in the second embodiment.
In the description of this process, the same step number is assigned to the same part as that in the flowchart (FIG. 6) of the first embodiment, and the description of the common process is omitted as necessary.

First, when a date and time are entered in the input field T20 for the specified date on the search screen T shown in FIG. 5, the processing in FIG. 10 is performed as follows.
It is determined whether or not the time entered in the designated date input field T20 is a time excluding the business start time and the business end time (S101).
If “NO” is determined in the step S101, the process after the step S3 in the process flow of FIG. 6 is executed.

If “YES” is determined in step S101 , it is determined that the service is a time service, and the date and time information stored in the “planning period (start date and time)” F13 of the reservation table Tb1 (see FIG. 3) is set as a search target. Then, a record that matches the date and time designated on the search screen T (see FIG. 5) is extracted (S102).

  The extracted records are sequentially stored in the work table Tb3 (see FIG. 4). At this time, “setting” is set in the “classification” F31 of each record. Information that is missing in the record is appropriately acquired from the master table and stored in the corresponding item.

  Subsequent to step S102, the date and time information stored in the "planning period (start date and time)" F13 of the reservation table Tb1 (see FIG. 3) is designated on the search screen T (see FIG. 5). A record that matches the start time of the previous day of the specified date is extracted (S103).

The extracted records are stored sequentially in the work table. At this time, “setting” is similarly set in the “classification” F31 of each record. Information that is missing in the record is appropriately acquired from the master table and stored in the corresponding item.
Therefore, immediately after the process of step S103, only the “unoutput flag” F32 becomes “NULL”.

FIG. 11 is an explanatory diagram showing the contents of the stored data in the work table Tb3 after the process of step S103.
For convenience, the product list C for the designated date is arranged on the left side, and the product list D for the day before the designated date is arranged on the right side of the figure.

  This figure is executed by inputting “February 6 16:00” in the input field T20 of “specified date” on the search screen T (see FIG. 5) and inputting “return / setting” in “category”. The contents of the stored data in the work table Tb3 (see FIG. 4) are shown.

  When the process of step S102 of FIG. 10 is executed, a search is executed for information stored in the “planning period (start date and time)” F13 of the reservation table Tb1 (see FIG. 3), and “2 A record having “Monday 6th 16:00” is extracted. Then, “setting” is added to the extracted record as “classification” F31 and stored in the work table Tb3.

  FIG. 11 shows a state when the reservation information of the product codes 1 to 4 corresponding to the plan code 5 is hit and registered in the work table Tb3. At this stage, the “unoutput flag” F32 is “NULL”.

  When the process of step S103 in FIG. 11 is executed, a search is executed for information stored in the “planning period (start date and time)” F13 of the reservation table Tb1, as in step S102. In this process, a record corresponding to “16:00” of “February 5” the day before “February 6” is extracted. Then, “set” is added as “category” F31 to the extracted record and stored in the work table Tb3.

  FIG. 11 shows a state when the reservation information of the product codes 1 to 3 corresponding to the plan code 5 is hit and registered in the work table Tb3. At this stage, the “unoutput flag” F32 is “NULL”.

Returning to the processing of FIG. 11, the subsequent processing will be described.
The processing following step S103 is the same as the processing from step S5 to step S9 in FIG. That is, a designation process for deleting a record of a product with no unit price fluctuation is executed.

  First, a “NULL” record is searched for the “unoutput flag” F32 of the work table Tb3 (see FIG. 4), and a pair of records is sorted in ascending order of the product code for the record hit by this search. Extract (S6). In the example of FIG. 11, two records having the product code 1 correspond first. If product code 1 does not correspond, record pairs are extracted in the order of product codes 2 and 3.

  Subsequently, the information of each “set unit price” F15 included in the pair of records extracted in step S6 is compared to determine whether the information matches, that is, whether the set unit price is the same (S7). In the example of FIG. 11, since the first corresponding record is the product code 1, the set unit price “80 yen” at the specified date and time and the set unit price “80 yen” at the same time on the previous day are to be compared.

  If “NO” is determined in the step S7, “0” is input to the “unoutput flag” F32 of the work table Tb3 (S8), and the process is repeatedly executed from the process of the step S5. In the example of FIG. 11, the set unit price of the product code 3 at the specified date and the set unit price of the product code 3 at the same time on the previous day do not match, so “0” is registered in the “unoutput flag” F32 of the product code 3. .

  On the other hand, if “YES” is determined in step S7, “1” indicating that the set unit price does not fluctuate is input to the “unoutput flag” F32 of the work table Tb3 (S9), and the processing from step S5 is repeated. In the example of FIG. 11, the set unit prices of the product code 1 and the product code 2 at the specified date and the set unit price of the product code 1 and the product code 2 at the same time on the previous day are the same. “1” is registered in the “unoutput flag” F32.

  As described above, when a value is set in the “unoutput flag” F32 field of all corresponding records, a “NO” determination is made in step S5, and the process proceeds to the subsequent step S104.

  In the process of step S104, a “NULL” record is searched for the “unoutput flag” F32 of the work table Tb3 (see FIG. 4), and “0” is set in the “unoutput flag” F32 of the record hit by this search. ". In the example of FIG. 11, the product code 4 corresponds, and “0” is registered in the “unoutput flag” F32 of the product code 4.

  When the input of the flag to the “unoutput flag” F32 of the extracted record is completed, the record for which the specified date and time is set in the “planning period (start date and time)” F13 of the work table Tb3 is displayed as the “unoutput flag” F32. A form is output based on the registered contents (S12), and this process is terminated. For example, the registered contents of the “non-output flag” F32 “1” are deleted, only the registered contents “0” are output, and the process is terminated.

(Third embodiment)
In the third embodiment, a description will be given of an arrangement in which the means for re-outputting a form is further provided in the configuration of the store server of the embodiment.
In addition, the description which overlaps with the description of the store server of embodiment is abbreviate | omitted suitably.

  FIG. 12 is a configuration diagram of fields of a reservation table stored in the store server according to the third embodiment.

  As shown in the figure, the fields of the reservation table Tb10 are “product code” F11, “plan code” F12, “plan period (start date and time)” F13, “plan period (end date and time) of the reservation table Tb1. ) ”F14 and“ set unit price ”F15, two“ flag areas ”F120 and F121 are further provided. Other items are omitted in the figure.

  “Flag areas” F120 and F121 are provided for storing the flags registered in the “unoutput flag” F32 of the work table Tb3 by the execution of the form output program P. The “flag area” F120 corresponds to the “plan period (start date and time)” F13, and the “flag area” F121 corresponds to the “plan period (end date and time)” F14.

  When the form output program P is executed and the processing in step S12 in FIG. 6 is completed, all the flags registered in the “unoutput flag” F32 of the work table Tb3 are displayed in the corresponding “flag areas” F120 and F121 of the reservation table Tb10. To finish the process.

This will be specifically described with reference to FIG.
When the “product code” F11 is “10”, the “plan code” F12 is “2”, the “end date” F14 is “February 2”, and the “unoutput flag” F32 is “0”. Therefore, the records corresponding to the three keys “product code” F11 “10”, “plan code” F12 “2”, and “end date” F14 “February 2” are extracted from the reservation table Tb10. The value “0” of the “unoutput flag” F32 is embedded at the position corresponding to the “flag area” F121 of the “planning period (end date and time)” F14. Then, the data in which the value “0” is embedded is returned to the reservation table Tb10 to update the record.

FIG. 13 is a flowchart of the form output program P in the store server of the third embodiment.
The processing of step S1 and step S2 is omitted because it is a repetition of the description of FIG. 6 of the embodiment.

  In step S130, a record is extracted from the reservation table Tb10 in which the “plan end date and time” F14 column is the day before the specified date and the “flag area” F121 is “0”, and “return” is set in the “category” F31. Then, “0” of the “flag area” F121 is set in the “unoutput flag” F32 and stored in the work table Tb3.

  In subsequent step S140, a record in which the “plan start date and time” F13 column is the specified date and the “flag area” F120 is “0” is extracted from the reservation table Tb10, and “setting” is set in the “category” F31. , “0” of the “flag area” F120 is set in the “unoutput flag” F32 and stored in the work table Tb3.

Thereafter, a form is output in the same manner as in FIG. 6 of the embodiment (S12), and the process is terminated.
As described above, in the third embodiment, the flag area is provided in the reservation table. As a result, product data that does not require form output calculated in the first form output can be stored in the reservation table. For this reason, even if the data in the work table is deleted after the session is output after specifying the date and time, the product that does not need to be output can be obtained It becomes possible to output a form excluding.

(Fourth embodiment)
In the store server of the embodiment, the products having no price fluctuation are deleted from both the display 46 and the printer 47, and only the products having the price fluctuation are output.
In the fourth embodiment, a store server of an output method different between the display 46 and the printer 47 will be described.

  In the embodiment, a value of “1” or “0” is set in the “unoutput flag” F32 of the work table Tb3 (see FIG. 4) by the processing up to step S11 of the form output program P (see FIG. 6).

In the fourth embodiment, in the output process of step S12 following step S11, different processes are performed for the form output to the display unit 46 and the form output to the printer 47.
First, in the form output to the printer 47, the CPU extracts all the records of the value “0” of the “unoutput flag” F32 in the work table Tb3, and forms the form data formed by arranging them in a predetermined layout. Send to. The printer 47 prints the data received from the CPU on print paper and outputs it as a form.

  On the other hand, in the form output to the display unit 46, the CPU extracts all records registered in the work table Tb3. A color that can be visually distinguished from other data is set in the display range of the record of the value “1” of the “unoutput flag” F32 in the extracted records. Then, both the product with price fluctuation and the product without price fluctuation are output to the display unit 46, and each of them is displayed by being color-coded according to the set color. For example, if the basic color is black and white and the set color is semi-transparent red, a red band is displayed on the stage of the product with no price fluctuation.

FIG. 14 is a form output example of each of the display 46 and the printer 47.
FIG. 14A shows an example of a form output to the display unit 46, and FIG. 14B shows an example of a form output to the printer 47.

As shown in FIG. 14 (a), the form output to the display unit 46 is left without deleting products without price fluctuation, and in the same figure, semi-transparent red bands 140 to 142 indicated by shading are applied. .
Because it is translucent, it is possible to know which products have been excluded as having no price fluctuation.

  As shown in FIG. 14 (b), the form output to the printer 47 is a product that completely deletes a product with no price fluctuation shown in shaded in FIG. 14 (a), and has a price fluctuation, that is, a product that requires replacement of a POP advertisement. Only to display.

  In the example of the form output to the display unit 46, the color is set for the product having no price fluctuation, but this is not the case. In addition to this, the target area is shaded, or a predetermined symbol is given to a part of the target area, so that it is visually distinguishable between products with no price fluctuation and those with price fluctuation. What is necessary is just to provide the marking means.

(Fifth embodiment)
In the fourth embodiment, an example in which the display 46 and the printer 47 adopt different output methods for the form is shown.
The fifth embodiment shows an example in which both the display 46 and the printer 47 adopt an output method for marking a product having no price fluctuation without deleting it.

  In the output process of step S12 of FIG. 6, in the form output to the display unit 46, the CPU extracts all records registered in the work table Tb3. A color that can be visually distinguished from other data is set in the display range of the record of the value “1” of the “unoutput flag” F32 in the extracted records. Then, both the product with price fluctuation and the product without price fluctuation are output to the display unit 46, and each of them is displayed by being color-coded according to the set color.

  In the form output to the printer 47, the form data is transmitted to the printer 47 using the data displayed on the display unit 46. The printer 47 prints the data received from the CPU on print paper and outputs it as a form.

FIG. 15 is a form output example of each of the display 46 and the printer 47.
FIG. 15A is an example of a form output to the display 46, and corresponds to FIG.
FIG. 15B shows a form output example for the printer 47.
As shown in FIG. 15 (b), the form output to the printer 47 is left as it is without deleting the commodity having no price fluctuation as in the case of the form output to the display unit 46. In FIG. -152.

  Since the red band is used as the background and the characters can be recognized, it is possible to know which products have been excluded as having no price fluctuation.

  In the example of the form output to the display unit 46 and the printer 47, the color is set for the product having no price fluctuation, but this is not the case. In addition to this, the target area is shaded, or a predetermined symbol is given to a part of the target area, so that it is visually distinguishable between products with no price fluctuation and those with price fluctuation. What is necessary is just to provide the marking means.

  As described above, in this embodiment, it is possible to automatically select a product that is a target of POP advertisement replacement and a product that is not a target of POP advertisement replacement. For this reason, the POP advertisement attachment / detachment list for instructing the store clerk to replace the POP advertisement can be output by deleting the product that is not the replacement object.

  Various programs used in the information processing apparatus of the present embodiment are files in an installable or executable format, such as a CD-ROM, a flexible disk (FD), a CD-R, and a DVD (Digital Versatile Disk). The program may be provided by being recorded on a readable recording medium, and may be read and executed by a flash ROM of an information processing apparatus.

  Further, the program may be provided by being stored on a computer connected to a network such as the Internet and downloaded via the network.

  In each of the above embodiments, several configurations of the information processing apparatus and its program have been described. However, these embodiments are presented as examples, and are not intended to limit the scope of the invention. These novel embodiments can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the scope of the invention. These embodiments and modifications thereof are included in the scope and gist of the invention, and are included in the invention described in the claims and the equivalents thereof.

1 POS system 2 POS terminal 3 LAN
4 Store Server 40-1 Display 40-2 Printer 41 Control Unit 42 Bus 43 Communication I / F
44 I / O device control unit 45 Keyboard 46 Display 47 Printer 48 HDD
P Form output program T Search screen Tb1 Reservation table Tb2 Standard unit price table Tb3 Work table

JP 2011-95956 A

Claims (6)

An input means for inputting a date indicating an estimated attachment date / time of the advertisement indicating the price information of the product ,
Storage means for storing the start date and end date of the planning period, and the price information of the product in the planning period and the day before the starting date of the planning period, for each product;
Search for a product having the date input by the input means as the start date or end date of the planning period from the products stored in the storage means, and the price of the searched product on the date and the previous day of the date as the condition price and have different items from, in the date, the detachable list generating means for generating a detachable previous list Kihiro WARNING,
An output means for outputting the attachment / detachment list;
An information processing apparatus comprising: The storage means stores product price information for each time zone,
The attachment / detachment list generating means is configured to store the product at the attachment / detachment time on the scheduled attachment / detachment date of the advertisement, which is input by the input means , out of the products, based on the price information stored by the storage unit. Excluding products whose price information and price information at the same time on the previous day of the scheduled date of attachment / detachment show the same price, generate a detachment list of the product,
The output means outputs the attachment / detachment list for each attachment / detachment time of the scheduled attachment / detachment date of the advertisement;
The information processing apparatus according to claim 1. The storage means includes a flag area for storing products that are excluded from the attachment / detachment list by the attachment / detachment list generation means in association with the scheduled attachment / detachment date,
The output means outputs an attachment / detachment list for each scheduled attachment / detachment date, except for products stored in association with the scheduled attachment / detachment date in the flag area.
The information processing apparatus according to claim 1. The output means includes
Display means for displaying an attachment / detachment list for each scheduled attachment / detachment date of the advertisement;
A printing means for printing a detachment list for each scheduled date of detaching the advertisement;
With
The attach / detach list generating means includes:
Generate a detachment list to be printed on the printing means, excluding products in which the price information on the day before the scheduled date of attachment and detachment and the price information on the scheduled date of attachment / detachment have the same price in one product And
In addition, among the products, the display is performed by visually distinguishing the product in which the price information on the day before the scheduled date of attachment / detachment and the price information on the scheduled date of attachment / detachment are the same price in the product. Create a detachable list to be displayed on the means,
The information processing apparatus according to claim 1. The detachable list generation unit may further among the products, one in the trade, goods and the previous day price information and 該日with price information of the date of the advertisement that shows the price information of the product indicates the same price There have been marked, to produce a detachable list of the advertisement in the date,
The information processing apparatus according to claim 1 . A computer that controls an information processing apparatus that creates an attachment / detachment list of advertisements indicating product price information,
Input means for inputting a date indicating a scheduled date and time for attaching and detaching the advertisement indicating the price information of the product ;
Storage means for storing the start date and end date of the planning period, and the price information of the product in the planning period and the day before the starting date of the planning period, for each product;
Search for a product having the date input by the input means as the start date or end date of the planning period from the products stored in the storage means, and the price of the searched product on the date and the previous day of the date as the condition price and have different items from, in the date, the detachable list generating means for generating a detachable previous list Kihiro WARNING,
An output means for outputting the attachment / detachment list for each scheduled attachment / detachment date of the advertisement;
Program to function as.

Images