JP6561438B2 - Information processing apparatus, control method thereof, and program - Google Patents

Description

  The present invention relates to an information processing apparatus capable of generating document data without including the program using template data including a program for generating document data, a control method thereof, and a program.

  2. Description of the Related Art Conventionally, a seller who sells a product to a retailer or the like has created a flyer for the product to promote the sale of the product. This flyer is created by a merchant inserting a product image or price using a document creation application or the like.

  Since a dealer must create such a flyer every time a new product is sold, a mechanism for creating a flyer has been conventionally considered.

  In Patent Document 1 below, when a seller selects a product for which a flyer is to be created, a mechanism for obtaining product information of the product from a database of a server and creating promotional leaflet data for printing based on the acquired product information. It is disclosed.

JP 2003-216865 A

  By using the mechanism disclosed in the above-mentioned Patent Document 1, it is possible to reduce the effort of the dealer to create a flyer, but it takes a large amount of money to construct such a system. There's a problem.

  Therefore, a mechanism for creating a flyer by incorporating a macro into document data, reading the document data with a document creation application, and operating the macro is considered. In particular, when changing the price of a product for each retailer that distributes a flyer, the price displayed in the document data is often changed to create a flyer. Therefore, the price is changed by a macro incorporated in the document data and distributed to retailers.

  In the case of such a mechanism, the document data whose price is changed by operating the macro is distributed as a flyer. However, the document data includes the macro described above. Since the macro is packed with the know-how of the seller, there is a problem that the data cannot be passed to the retailer as it is.

An object of this invention is to provide the structure which can calculate the sales price of goods easily with appropriate price conditions .

To achieve the above object, the information processing apparatus of the present invention includes a storage unit for storing the reference price as a reference of selling prices of goods, the template document data including the category corresponding to the goods, sales By applying the price condition corresponding to the category of the product for which the price is calculated to the reference price of the product, the calculation means for calculating the sales price of the product, and the template document data stored in the storage means based, a document data including the price calculated by the calculation means, characterized in that it comprises a generation means for generating said document data which does not include the reference price.

According to the present invention, it is possible to easily calculate the selling price of a product under an appropriate price condition .

2 is a diagram illustrating a hardware configuration of the information processing apparatus 100. FIG. 2 is a diagram illustrating a functional configuration of the information processing apparatus 100. FIG. It is a flowchart which shows the flow of a series of processes in embodiment of this invention. It is a figure which shows the outline | summary of the template data 400 and the document data 410 produced | generated from the template data 400. FIG. 6 is a diagram showing an example of the content of the first page of template data 400. FIG. It is a figure which shows the table structure of the object table 600, the price condition table 610, and the page setting table 620. FIG. It is a figure which shows an example of a screen structure of the price condition setting screen. It is a flowchart which shows the flow of a price substitution process. It is a figure which shows an example of the content of the 1st page of the document data 410 after a price substitution process.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.

  FIG. 1 is a diagram illustrating a hardware configuration of an information processing apparatus 100 according to an embodiment of the present invention. The information processing apparatus 100 is a general-purpose device equipped with an operating system. In the present embodiment, description will be made assuming a personal computer, but it may be a server device or a mobile terminal (mobile phone, smartphone, tablet terminal).

  The CPU 101 comprehensively controls each device and controller connected to the system bus 104.

  In addition, the ROM 102 or the external memory 111 stores a BIOS (Basic Input / Output System) that is a control program of the CPU 101, an operating system, various programs described below that are necessary for realizing the functions executed by the information processing apparatus 100, and the like. Has been. The RAM 103 functions as a main memory, work area, and the like for the CPU 101.

  The CPU 101 implements various operations by loading a program or the like necessary for execution of processing into the RAM 103 and executing the program.

  The input controller 105 controls input from a pointing device (input device 109) such as a keyboard and a mouse.

  The video controller 106 controls display on a display device such as the display 110. The display device may be a CRT or a liquid crystal display.

  The memory controller 107 is a card type memory connected via an adapter to a hard disk, a flexible disk, or a PCMCIA card slot that stores a boot program, browser software, various applications, font data, user files, editing files, various data, and the like. The access to the external memory 111 is controlled.

  The communication I / F controller 108 is connected to and communicates with an external device via a network, and executes communication control processing on the network. For example, Internet communication using TCP / IP is possible.

  For example, the CPU 101 can perform display on the display 110 by executing outline font rasterization processing on a display information area in the RAM 103. Further, the CPU 101 enables a user instruction with a mouse cursor (not shown) on the display 110.

  Various programs and the like used by the information processing apparatus 100 of the present invention to execute various processes described later are recorded in the external memory 111 and are executed by the CPU 101 by being loaded into the RAM 103 as necessary. is there. Furthermore, definition files and various information tables used by the program according to the present invention are stored in the external memory 111.

  Next, an example of a functional configuration of the information processing apparatus 100 will be described with reference to FIG.

  The information processing apparatus 100 includes a storage unit 201 and a display unit 202 as functional units. The storage unit 201 is a functional unit for storing and managing various programs and data for operating the information processing apparatus 100. In particular, in the present embodiment, template data 400, an object table 600, a price condition table 610, a page setting table 620, and the like described later are stored (storage means). Also, the document data 410 generated from the template data 400 is stored in a folder designated by the user.

  The display unit 202 is a functional unit for displaying various screens on the display 110 of the information processing apparatus 100.

  Further, the information processing apparatus 100 has a document creation application 210 installed therein. The document creation application 210 includes a macro control unit 211, a document data generation unit 212, a page pasting unit 213, an object control unit 214, and a page setting unit 215 as functional units.

  The macro control unit 211 is a functional unit for controlling execution of a macro included in template data 400 described later. The macro in the present embodiment is a program written in a language that can be executed by the macro control unit 211.

  The document data generation unit 212 is a functional unit for generating document data that can be processed by the document creation application 210. Here, “processable” means reading, displaying, editing, saving, etc. of document data. It suffices if it can be handled by the document creation application 210.

  The page pasting unit 213 is a functional unit for pasting a page of certain document data to other document data. That is, a page of certain document data is duplicated as a page in other document data. However, even if pasting is performed, a macro 402 and a page setting table 620 described later cannot be pasted. This is because these are not information corresponding to pages but information corresponding to document data. On the other hand, an object table 600 described later, which is information corresponding to a page, is pasted.

  The object control unit 214 is a functional unit for adding / changing / deleting an object character string and the object table 600 included in the document data. An object in the present embodiment is information displayed in document data such as a character string, a figure, or an image.

  The page setting unit 215 is a functional unit that sets a page constituting document data in a page setting table 620 described later. In the present embodiment, the setting of pages constituting the document data is set for each document data. Note that page setting may be possible for each page.

  In addition, the function part with which the information processing apparatus 100 is provided may be other than this. The functional unit is not limited to the above-described functional unit.

  Next, a flow of a series of processes according to the present embodiment will be described using the flowchart shown in FIG. Each step of FIG. 3 to be described later is an operation executed by the CPU 101 of the information processing apparatus 100.

  First, in step S301, the document creation application 210 installed in the information processing apparatus 100 is read from the external memory 111, loaded into the RAM 103, and the document creation application 210 is activated.

  In step S302, the document creation application 210 is caused to read the template data 400. In the present embodiment, the template data 400 is document data serving as a template for creating a flyer (that is, document data).

  Here, the data structure of the template data 400 is shown in FIG. The template data 400 includes a page 401, an object table 600, a page setting table 620, and a macro 402. The template data 400 is, for example, document data for presentation, and a page corresponds to a so-called slide. The page 401 is composed of one or a plurality of pages, and products to be placed on the flyer are laid out on each page. A layout example of the page 401 is shown in FIG. FIG. 5 is a layout example of the first page of the template data 400. Three products are arranged, and an object for displaying a delivery price (hereinafter, price) is arranged.

  Each price object is associated with information as shown in the dialog 500 as attribute information. Information of “cost = 47800” and “category = notebook PC” is associated with the price object of the product “PC-AAA” as attribute information. A table for managing this attribute information is an object table 600 shown in FIG. It is also included in the template data 400 of FIG. 4 described above.

  The object table 600 includes an object ID 601, a page number 602, attribute information 603, and a character string 604. The object ID 601 is object-specific identification information that is allocated by the object control unit 214 of the document creation application 210 every time an object is placed in the document data. Since the object table 600 is provided for each document data, the object ID 601 is identification information unique to the document data. That is, the same identification information can exist for other document data. The page number 602 indicates the number of the page on which the object indicated by the object ID 601 is arranged. The attribute information 603 indicates the content of attribute information associated with the object indicated by the object ID 601. For example, the attribute information shown in the dialog 500 of FIG. 5 is attribute information 603 of a record in which the object ID 601 of the object table 600 of FIG. 6 is “OBJ005”. A character string 604 indicates a character string displayed on the object indicated by the object ID 601.

  The template data 400 includes a page setting table 620. The table configuration of the page setting table 620 is shown in FIG. The page setting table 620 includes a width 621 and a height 622. The width 621 and the height 622 are setting values indicating the width and height of the pages constituting the document data. In the present embodiment, the unit of values stored in the width 621 and the height 622 is centimeters, but is not limited to this. In the present embodiment, only the setting items of the width 621 and the height 622 are specified, but there may be setting items other than this.

  Further, the template data 400 includes a macro 402. This is a program for executing steps S303 to S314 described later. Programming is performed such that when the template data 400 is read, the macro 402 of the template data 400 is automatically executed. The present invention is a mechanism for preventing the macro 402 from being included in the leaflet document data.

  Such template data 400 is prepared in advance and is read in step S302.

  Returning to FIG. In step S303, the macro 402 included in the template data 400 read in step S302 is executed using the macro control unit 211 of the document creation application 210. As a result, the processing from step S304 to step S314, which will be described later, described in the macro 402 is sequentially executed. Therefore, the processing from step S304 to step S314 is executed using the macro control unit 211 of the document creation application 210.

  In step S <b> 304, the price condition setting screen 700 is displayed on the display 110 using the display unit 202. A screen configuration example of the price condition setting screen 700 is shown in FIG. The price condition setting screen 700 is a screen for setting conditions for calculating the price of a product. The basic setting 701 is provided with an input form for setting a price multiplication rate and an additional amount. Further, in the category-specific setting 702, it is possible to set a price multiplication rate and an additional amount for each category of products. In order to set this, when the record of the category desired to be set is selected and the pressing of the change button 703 is detected, a dialog 710 shown in FIG. 7 is displayed. By accepting the input of the price increase rate and the additional amount for the category selected here, the price increase rate and the additional amount for each category can be set.

  In step S305, it is determined whether or not pressing of the execution button 704 included in the price condition setting screen 700 is detected in a state where the price multiplication rate and the additional amount are set on the price condition setting screen 700. If it is determined that the execution button 704 has been pressed, the process proceeds to step S306. If it is determined that pressing of the execution button 704 has not been detected, the process waits until the execution button 704 is pressed.

  In step S <b> 306, the price condition (price multiplication rate, additional amount, etc.) accepted on the price condition setting screen 700 is acquired and stored in the price condition table 610. The table configuration of the price condition table 610 is shown in FIG. The price condition table 610 includes a target category 611, a price multiplication rate 612, and an additional amount 613. A target category 611 indicates a category of a product to which the price condition is applied. The price charge rate 612 indicates the price charge rate of the product indicated by the target category 611, and the additional amount 613 indicates the additional amount 613 of the product indicated by the target category 611. In the present embodiment, the price multiplication rate indicates the proportion of the cost in the price. That is, when the price multiplication rate is “0.9”, the cost is 90% and the remaining 10% is the profit.

  Returning to FIG. In step S307, new document data is generated using the document data generation unit 212 of the document creation application 210 (document data generation means). That is, the document data generated in step S307 means that empty document data that does not include the object included in the template data 400 is generated.

  In step S308, the page setting unit 215 of the document creation application 210 is used to apply the page setting of the template data 400 read in step S302 to the document data generated in step S307. More specifically, the width 621 and height 622 of the page setting table 620 of the template data 400 are copied to the width 621 and height 622 of the page setting table 620 of document data. Since the default values set by the document creation application 210 for the new document data are set to the width 621 and the height 622, this is changed to the page setting of the template data 400 in step S308.

  In step S309, using the page pasting unit 213 of the document creation application 210, all the pages 401 constituting the template data 400 are pasted on the document data generated in step S307 (page pasting means). In response to the pasting, the object table 600 is also copied from the template data 400 to the document data.

  The result of executing the processing so far is the document data 410 of FIG. The document data 410 is the document data generated in step S307. Since the document data 410 is newly generated document data, the document data 410 does not include the macro 402 included in the template data 400 (other pages 401, the object table 600, and the page setting table 620 are templates. The same as data 400). That is, since necessary information is duplicated from the template data 400 for newly created document data, the macro 402 that is not shown to the retailer is not duplicated to prevent information leakage.

  In step S310, the price to be displayed in the document data 410 generated in step S307 is calculated, and processing for substituting the calculated price into the character string 604 of the object in the document data 410 is executed. Details of the price substitution process are shown in FIG.

  In step S311, designation of the storage destination of the document data 410 with the price substituted is accepted. The designation of the save destination folder is accepted through a dialog (not shown) and the designation of the file name of the document data 410 is accepted.

  In step S312, the storage unit 201 is used to store the price-assigned document data 410 in the storage destination received in step S311 (document data storage unit).

  In step S313, the template data 400 read in step S302 is closed, and in step S314, the document creation application 210 started in step S301 is terminated. The above is the description of the flow of a series of processes in FIG.

  Next, the flow of the price substitution process will be described using the flowchart of FIG. Each step in FIG. 8 described later is an operation executed by the CPU 101 of the information processing apparatus 100.

  First, in step S801, a variable N is prepared using the macro control unit 211 of the document creation application 210, and “1” is substituted as an initial value of the variable N. A variable N is a counter variable for changing the page number of a page to be referred to in processing to be described later.

  In step S802, the Nth page is referred to among the pages 401 constituting the document data 410 generated in step S307. That is, if the value stored in the variable N is “1”, the first page is referred to, and if the value stored in the variable N is “2”, the second page is referred to. is there. Note that the processing in steps S802 to S809 may be performed using information in the template data 400. Since the template data 400 and the document data 410 hold the same information, the price calculated in step S809 is the same regardless of which information is used. Therefore, either information may be used until the price is calculated. In the present embodiment, the description will be made assuming that the price is calculated using the information of the document data 410.

  In step S803, among the objects included in the page being referred to, an unprocessed object is referred to in steps S804 to S812 described later. The order of the objects referred to here is not particularly limited.

  In step S804, it is determined whether or not the attribute information 603 exists in the object being referred to. The presence of the attribute information 603 is an object whose price is to be calculated. If it is determined that the attribute information 603 exists in the referenced object, the process proceeds to step S805. If it is determined that the attribute information 603 does not exist in the object being referred to, the process proceeds to step S813.

  In step S805, the attribute information 603 of the object being referred to is acquired. More specifically, the object ID 601 of the object being referred to is specified, and the attribute information 603 of the record including the object ID 601 among the records in the object table 600 is acquired.

  In step S806, it is determined whether the price condition of the category indicated by the attribute information 603 acquired in step S805 exists in the price condition table 610. For example, since an object whose object ID 601 is “OBJ005” includes “category = note PC” in the attribute information 603, it can be understood that the category of the product indicated by the object is “note PC”. Then, when it is searched whether or not the price condition unique to “notebook PC” is set in the price condition table 610, a record in which the target category 611 is “notebook PC” in the second record in the price condition table 610 of FIG. It can be seen that exists. That is, since the price condition unique to the “notebook PC” is set different from the default price condition, the price is calculated by applying this price condition. If it is determined that the price condition of the category indicated by the attribute information 603 acquired in step S805 exists in the price condition table 610, the process proceeds to step S807. If it is determined that the price condition of the category indicated by the attribute information 603 acquired in step S805 does not exist in the price condition table 610, the process proceeds to step S808.

  In step S807, the category-specific price condition indicated by the attribute information 603 acquired in step S805 is acquired from the price condition table 610. For example, when the attribute information 603 includes “category = note PC”, the price multiplying rate 612 and the additional amount 613 of the record whose target category 611 is “note PC” are acquired.

  In step S808, since the category-specific price condition indicated by the attribute information 603 acquired in step S805 does not exist in the price condition table 610, the price multiplication rate 612 and the additional amount 613 of the record whose target category 611 is “default” are displayed. get.

  In step S809, the price of the product of the object being referred to is calculated using the price condition acquired in step S807 or step S808 (price calculation means). More specifically, the cost is acquired from the attribute information 603 of the object being referred to. For example, the attribute information 603 whose object ID 601 is “OBJ005” is “cost = 47800”, so the cost is “47,800 yen”. Then, the price is calculated using the price multiplication rate 612 and the additional amount 613 acquired in step S807 or step S808. The price is calculated by “cost ÷ price multiplication rate + additional amount”. In this embodiment, since the price multiplication rate and the additional amount are used as the price condition, the price is calculated by the above-described calculation formula. However, when other price conditions (for example, including tax) are used, the price condition is suitable. The following formula is used.

  In step S810, the price calculated in step S809 is substituted into the character string 604 of the object being referred to in the document data 410 (content updating unit). FIG. 9 is a diagram showing the first page of document data 410 after price substitution. As shown in FIG. 9, since the first page of the document data 410 is copied from the first page of the template data 400, the same objects as the first page of the template data 400 (see FIG. 5) are arranged in the same layout. . Since the object ID 601 of the object indicating the price of “PC-AAA” is “OBJ005”, the price is calculated as “53,111 yen” as described above. This price is substituted into the character string 604 of the object whose object ID 601 is “OBJ005”. Originally, since the character string 604 “[delivery price]” is stored in the object, it is updated to “53,111 yen”. When the price is calculated using the template data 400, the object of the document data 410 corresponding to the object being referred to in the template data 400 is specified, and the calculated price is substituted for the object of the specified document data 410. You just have to do it.

  In step S811, the attribute information 603 of the object to which the price is assigned in step S810 is deleted (attribute information deleting unit). That is, since the object currently referred to is the document data 410 of the flyer to be distributed to the retailer, if the object attribute information 603 of the document data 410 includes the cost of the product, this is the retailer. May be known. In step S811, the attribute information 603 is deleted from the document data 410 to solve such a problem. When the attribute information 603 is deleted, “NULL” is stored in the attribute information 603. Then, as shown in FIG. 9, nothing is input in the dialog 500 of the object from which the attribute information 603 has been deleted.

  In step S812, it is determined whether there are any unprocessed objects in steps S803 to S811 among the objects included in the page being referred to. If it is determined that there is no unprocessed object, the process proceeds to step S813. If it is determined that there is an unprocessed object, the process returns to step S803. Then, the processes in steps S803 to S812 are repeated until the processes in steps S803 to S811 are completed for all the objects included in the page being referred to.

  In step S813, it is determined whether the page being referred to is the last page. If it is determined that the current page is the last page, the price substitution process is terminated and the process is returned to the caller of the price substitution process. If it is determined that the page is not the last page, the process proceeds to step S814.

  In step S814, the value assigned to the variable N is incremented. That is, the value is increased by “1” so that the next page can be referred to. When the process of step S814 is completed, the process returns to step S802 to refer to the next page. The above is the description of the price substitution process.

  As described above, according to the present embodiment, it is possible to generate document data updated according to the program without including the program for updating the document data.

  The present invention can be implemented as a system, apparatus, method, program, storage medium, or the like, and can be applied to a system including a plurality of devices. You may apply to the apparatus which consists of one apparatus.

  Note that the present invention includes a software program that implements the functions of the above-described embodiments directly or remotely from a system or apparatus. The present invention also includes a case where the system or the computer of the apparatus is achieved by reading and executing the supplied program code.

  Accordingly, since the functions of the present invention are implemented by computer, the program code installed in the computer also implements the present invention. In other words, the present invention includes a computer program itself for realizing the functional processing of the present invention.

  In that case, as long as it has the function of a program, it may be in the form of object code, a program executed by an interpreter, script data supplied to the OS, and the like.

  Examples of the recording medium for supplying the program include a flexible disk, hard disk, optical disk, magneto-optical disk, MO, CD-ROM, CD-R, and CD-RW. In addition, there are magnetic tape, nonvolatile memory card, ROM, DVD (DVD-ROM, DVD-R), and the like.

  As another program supply method, a browser on a client computer is used to connect to an Internet home page. The computer program itself of the present invention or a compressed file including an automatic installation function can be downloaded from the homepage by downloading it to a recording medium such as a hard disk.

  It can also be realized by dividing the program code constituting the program of the present invention into a plurality of files and downloading each file from a different homepage. That is, a WWW server that allows a plurality of users to download a program file for realizing the functional processing of the present invention on a computer is also included in the present invention.

  In addition, the program of the present invention is encrypted, stored in a storage medium such as a CD-ROM, distributed to users, and key information for decryption is downloaded from a homepage via the Internet to users who have cleared predetermined conditions. Let me. It is also possible to execute the encrypted program by using the downloaded key information and install the program on a computer.

  Further, the functions of the above-described embodiments are realized by the computer executing the read program. In addition, based on the instructions of the program, an OS or the like running on the computer performs part or all of the actual processing, and the functions of the above-described embodiments can also be realized by the processing.

  Further, the program read from the recording medium is written in a memory provided in a function expansion board inserted into the computer or a function expansion unit connected to the computer. Thereafter, the CPU of the function expansion board or function expansion unit performs part or all of the actual processing based on the instructions of the program, and the functions of the above-described embodiments are realized by the processing.

  The above-described embodiments are merely examples of implementation in carrying out the present invention, and the technical scope of the present invention should not be construed as being limited thereto. That is, the present invention can be implemented in various forms without departing from the technical idea or the main features thereof.

100 Information processing apparatus 101 CPU
102 ROM
103 RAM
104 System Bus 105 Input Controller 106 Video Controller 107 Memory Controller 108 Communication I / F Controller 109 Input Device 110 Display 111 External Memory

Claims (8)

Storage means for storing template document data including a reference price that serves as a reference for the sales price of the product and a category corresponding to the product ;
The price conditions corresponding to the category of goods to calculate the sales price, by applying to the reference price of the commodity, and calculating means for calculating the selling price of the commodity,
Generation means for generating the document data that includes the sales price calculated by the calculation means based on the template document data stored in the storage means and does not include the reference price ;
An information processing apparatus comprising: The template document data includes an object corresponding to the reference price,
The generation unit does not include the reference price, and generates the document data including the object containing the selling price calculated by the calculation means, the information processing apparatus according to claim 1. Further comprising: a setting means for setting a price condition corresponding to the category information processing apparatus according to claim 1 or 2. The setting means can set a predetermined price condition that does not correspond to the category,
The calculation means, when the price condition corresponding to the category of the product is set by the setting means, calculates the sales price by applying the price condition to the reference price of the product, When the price condition corresponding to the product category is not set by the setting means, the selling price is calculated by applying the predetermined price condition set by the setting means to the reference price of the product. characterized by information processing apparatus according to claim 3. The price conditions are characterized by a sum of plus to the reference price, the information processing apparatus according to any one of claims 1 to 4. The price conditions are characterized by a multiplying factor to multiply with respect to the reference price, the information processing apparatus according to any one of claims 1 to 4. A control method for an information processing apparatus comprising storage means for storing template document data including a reference price as a reference for a sales price of a product and a category corresponding to the product ,
Price condition corresponding to the category of the product being calculated selling price by applying the reference price of the commodity, a calculating step of calculating a selling price of the product,
Generating the document data including the sales price calculated in the calculation step based on the template document data stored in the storage unit and not including the reference price. A method for controlling an information processing apparatus. A program that can be executed by an information processing apparatus including a storage unit that stores template document data including a reference price that is a reference for a sales price of a product and a category corresponding to the product ,
Computer
Price condition corresponding to the category of the product being calculated selling price by applying the reference price of the commodity, a calculating step of calculating a selling price of the product,
To generate document data that includes the sales price calculated in the calculation step based on the template document data stored in the storage unit and does not include the reference price. Program.

Images