Priority is claimed under 35 U.S.C. §119 to Japanese Application no. 2015-003096, filed on Jan. 9, 2015, the content of which is hereby incorporated by reference in its entirety.
1. Technical Field
The present disclosure relates to a control device, a control method of a control device, and a control system.
2. Related Art
Control devices (sales management servers) that receive sales information from devices in stores, store the received sales information, and execute processes based on the stored sales information are known from the literature. See, for example, JP-A-2014-160400.
There is a need for control devices (sales management servers) that receive sales information and other transaction information from Point-of-Sale (POS) terminals/stations/devices used in a business as described above to use characteristics of the received transaction information to provide useful information.
The present disclosure provides useful information using characteristics of transaction information.
A control device according to the disclosure includes: a storage unit configured to relationally store transaction information received from a recording device configured to produce receipts, and recording device identification information identifying the recording device, and to relationally store store identification information identifying a store, the recording device identification information of one or more recording devices in the store, and a sale counter attribute identifying an attribute of a sale counter where a recording device is located in the store; and a control unit configured to return, in response to a request from an external device, sales-related information based on transaction information related to the store identification information, transaction information related to the recording device identification information, or transaction information related to a combination of the store identification information and the sale counter attribute.
Thus comprised, the control device can provide valuable information using features of the transaction information.
In a control device according to another aspect of the disclosure, the control unit returns, in response to a request specifying the store identification information, the recording device identification information of the one or more recording devices in the store, and the sale counter attribute identifying an attribute of the sale counter where the recording device is located in the store.
Thus comprised, the control device can provide valuable information related to a store.
In a control device according to another aspect of the disclosure, the control unit returns, as sales-related information based on the transaction information related to the store identification information, total sales, sales by product, or the number of receipts printed in the store identified by the store identification information during a specific period of time.
Thus comprised, the control device can provide valuable information.
In a control device according to another aspect of the disclosure, the control unit returns, as sales-related information based on the transaction information related to the recording device identification information, total sales recorded on the receipts, sales byproducts recorded on the receipts, or the total number of receipts printed by the recording device of the recording device identification information in a specific period of time.
Thus comprised, the control device can provide valuable information.
In a control device according to another aspect of the disclosure, the control unit returns, as sales-related information based on the transaction information related to the store identification information and the sale counter attribute, total sales, sales by product, or the total number of receipts printed at the sale counter identified by a combination of store identification information and sale counter attribute in a specific period of time.
Thus comprised, the control device can provide valuable information.
In a control device according to another aspect of the disclosure, the control unit returns the sales-related information as text data written in a structured format in response to a request using a Web API.
Thus comprised, the control device can provide sales-related information as data with great utility.
Another aspect of the disclosure is a control method of a control device, the control method including: relationally storing transaction information received from a recording device configured to produce receipts, and recording device identification information identifying the recording device; relationally storing store identification information identifying a store, the recording device identification information of one or more recording devices in the store, and a sale counter attribute identifying an attribute of a sale counter where a recording device is located in the store; and returning, in response to a request from an external device, sales-related information based on transaction information related to the store identification information, transaction information related to the recording device identification information, or transaction information related to a combination of the store identification information and the sale counter attribute.
Objects of the invention also met in a control device having a memory store and a controller. The memory store is preferably configured to relationally store: (a) store identification information identifying a commercial establishment, the commercial establishment having at least one sales counter and at least one recording device configured produce receipts, (b) recording-device identification information uniquely identifying each of the at least one recording devices in the commercial establishment, (c) a sales-counter attribute identifying an attribute of each of the at least one sales counter wherein one of the at least one recording device is located; and (e) transaction information received from each of the at least one recording device and identifying the recording device from which the transaction information was received. The controller is preferably configured to return, in response to a request from an external device, at least one of the following: (i) sales-related information based on transaction information related to a specified store identification information, (ii) transaction information related to a specified recording-device identification information, and (iii) transaction information related to a combination of a specified store identification information and a specified sales-counter attribute.
Preferably, the request from the external device specifies at least one of the specified store identification information, specified recording-device identification information, and specified sales-counter attribute.
Further preferably, the controller returns, as sales-related information based on the transaction information related to the specified store identification information, total sales, sales by product, or the number of receipts printed in the store identified by the specified store identification information during a specific period of time.
Alternatively, the controller may return, as sales-related information based on the transaction information related to the specified recording-device identification information, total sales recorded on receipts produced by the recording device identified by the specified recording-device identification information, sales by product recorded on the receipts produced by the identified recording device, or the total number of receipts printed by the identified recording device in a specific period of time.
Optionally, the controller returns, as sales-related information based on the transaction information related to the specified store identification information and the specified sales-counter attribute, total sales, sales by product, or the total number of receipts printed at the sales counter identified by a combination of the specified store identification information and the specified sales-counter attribute in a specific period of time.
Additionally, the controller may return the sales-related information as text data written in a structured format. In this case, it is preferred that the request from the external device be made using a Web API.
Objects of the present invention are also met in a control method of a control device, having a storing step and a returning step. The storing step preferably relationally stores: (a) store identification information identifying a commercial establishment, the commercial establishment having at least one sales counter and at least one recording device configured produce receipts, (b) recording-device identification information uniquely identifying each of the at least one recording devices in the commercial establishment, (c) a sales-counter attribute identifying an attribute of each of the at least one sales counter wherein one of the at least one recording device is located; and (e) transaction information received from each of the at least one recording device and identifying the recording device from which the transaction information was received. The returning step preferably returns, in response to a request from an external device, at least one of the following: (i) sales-related information based on transaction information related to a specified store identification information, (ii) transaction information related to a specified recording-device identification information, and (iii) transaction information related to a combination of a specified store identification information and a specified sales-counter attribute.
In this method, the request from the external device specifies at least one of the specified store identification information, specified recording-device identification information, and specified sales-counter attribute.
Additionally, the return step returns, as sales-related information based on the transaction information related to the specified store identification information, total sales, sales by product, or the number of receipts printed in the store identified by the specified store identification information during a specific period of time.
The return step may also return, as sales-related information based on the transaction information related to the specified recording-device identification information, total sales recorded on receipts produced by the recording device identified by the specified recording-device identification information, sales by product recorded on the receipts produced by the identified recording device, or the total number of receipts printed by the identified recording device in a specific period of time.
Alternatively, the return step returns, as sales-related information based on the transaction information related to the specified store identification information and the specified sale counter attribute, total sales, sales by product, or the total number of receipts printed at the sales counter identified by a combination of the specified store identification information and the specified sales-counter attribute in a specific period of time.
Preferably in the returning step, the sales-related information is returned as text data written in a structured format. Also, the request from the external device is preferably made using a Web API.
Objects of the present invention are also met in a control system having: a commercial establishment having at least one sales counter and at least one recording device configured produce receipts and to transmit commercial transaction information related to the produced receipts; a control device; and a remote management device. The control device is in communication with each of the at least one recording device, and the control device has a memory store configured to relationally store: (a) store identification information identifying the commercial establishment; (b) recording-device identification information uniquely identifying each of the at least one recording devices in the commercial establishment, (c) a sales-counter attribute identifying an attribute of each of the at least one sales counter wherein one of the at least one recording device is located; and (e) transaction information received from each of the at least one recording device and identifying the recording device from which the transaction information was received. The remote management device is configured to submit, to the control device, an information request specifying at least one of the store identification information, recording-device identification information, and sales-counter attribute. Preferably, the control device, in response to receiving the information request, returns to the remote management device at least one of the following: (i) sales-related information based on transaction information related to the specified store identification information, (ii) transaction information related to the specified recording-device identification information, and (iii) transaction information related to a combination of the specified store identification information and the specified sales-counter attribute.
Other objects and attainments together with a fuller understanding of the disclosure will become apparent and appreciated by referring to the following description and claims taken in conjunction with the accompanying drawings.
A preferred embodiment of the present invention is described below with reference to the accompanying figures.
One or more checkout counters (or sales stations or POS stations) L where customer transactions are processed are located in the business where the store system 11 is deployed. Each checkout counter L preferably includes a sales (or commercial) transaction recording device 12 (e.g. a computer-controlled, or electronic, base station or a cash register or a multi-function printer) capable of recording sales transaction information on a recording medium (e.g. print a sales receipt). Each checkout counter L also preferably includes a tablet terminal 13 that connects and communicates wirelessly with the recording device, or printer, 12 and controls the recording device 12. Each checkout counter L also preferably includes a barcode reader BR, automatic change machine JT, and customer display CD (see
A local area network LN is deployed in each store system 11. The recording devices 12 within a store system 11 connect to their local area network LN using a communication protocol used on the LAN. Within each store system 11, a communication device (i.e. network interface) 14 is also connected to the local area network LN. The communication device 14 is an interface device that connects to the local area network LN and to a global network GN, such as the Internet. The communication device 14 (i.e. network interface) has the functions of (or may be implemented as) a modem (or Optical Network Unit, ONU), a router, a DHCP (Dynamic Host Configuration Protocol) server, and/or a NAT (Network Address Translation) unit/server. The communication device 14 passes data between electronic devices connected to the local area network LN and electronic devices connected to the global network GN so that they may communicate with each other. Note that the communication device 14 is represented by a single function block in
A control server 15 (control device or computer server) is connected to the global network GN. The control server 15 is preferably a cloud server in a cloud system in which the recording devices 12 and management devices 17, described below, are clients. More specifically, when triggered by a request from a client, for example, the control server 15 runs a specific computing process. The control server 15 also sends data based on the result of the computing process to a client as needed. The control server 15 is represented by a single function block in
A (computing) terminal 16 is a customer terminal connected to the global network GN. The customer terminal 16 in this example is the preferably a tablet-computer-style cell phone (e.g., a smartphone) of a customer that comes into the store and completes a commercial transaction. The customer terminal 16 may, however, be any customer-used, computing terminal device that can execute the processes described below. For example, a tablet computer may also be used as a customer terminal 16.
The management devices 17 are also connected to the global network GN. Each management device 17 in this embodiment is a (computing/computer) management terminal located, for example, in the headquarters of the company that manages the store where the store system 11 is deployed. A person with authority, such as the manager of the store, can use a management device 17 to receive specific services from control server 15. Examples of such specific services provided by the control server 15 are described below.
The tablet terminal 13 is a tablet computer with a touch panel 22 covering a large area on its front. When a commercial transaction is processed at a checkout counter L, the tablet terminal 13 functions as a host computer that runs transaction-related processes and controls its corresponding recording device 12. As shown in
The tablet terminal control unit 20 preferably includes a CPU (Central Processing Unit), ROM (Read Only Memory), RAM (Random Access Memory), and peripheral circuits, and controls the tablet terminal 13. A specific software application (“tablet terminal application TAP” below) that runs on the tablet terminal's system software is preinstalled on the tablet terminal 13. The tablet terminal control unit 20 functions as a tablet terminal application execution unit 201 by reading and running the tablet terminal application TAP and associated programs.
The tablet terminal communication unit 21 communicates with the recording device 12 according to a specific communication protocol (such as a wireless communication standard) as controlled by the tablet terminal control unit 20. The wireless communication standard used for wireless communication between the tablet terminal 13 and recording device 12 may be a wireless LAN standard compatible with an ad hoc mode, a wireless LAN standard compatible with an infrastructure mode, or a near-field communication standard such as Bluetooth (R), for example.
The touch panel 22 combines a display panel (such as an Liquid Crystal Display, LCD, panel) with a touch sensor overlaid on the display panel. The display panel displays information as controlled by the tablet terminal control unit 20. The touch sensor detects touch operations and outputs these detections to the tablet terminal control unit 20. The tablet terminal control unit 20 then executes processes appropriate to the detected touch operations.
The tablet terminal storage unit 23 stores data.
The recording device 12 is preferably a thermal line printer that holds roll paper and forms dots on the roll paper with a line thermal head to record images. As shown in
The recording device control unit 30 preferably includes a CPU, ROM, RAM, and other peripheral circuits, and controls the recording device 12.
The recording device recording unit 31 includes mechanisms related to recording on roll paper, such as a conveyance mechanism for conveying roll paper stored inside the cabinet of the recording device 12, a recording mechanism for forming dots and recording images on the roll paper with a thermal head, and a cutter mechanism for cutting the roll paper at a specific position. The recording device recording unit 31 records receipt-related images on the roll paper by use of the recording mechanism while conveying the roll paper with the conveyance mechanism, and then cuts the roll paper at a specific position with the cutter mechanism, producing a receipt.
The recording device storage unit 32 stores data.
The recording device communication unit 33 communicates with the tablet terminal 13 according to a specific communication protocol as controlled by the recording device control unit 30.
The recording device network communication unit 34 communicates (preferably through communication device 14) with electronics devices connected to the global network GN (including the control server 15) according to a specific communication protocol as controlled by the recording device control unit 30.
The periphery device communication unit 35 includes an interface board with one or more ports (i.e. connectors) such as a USB port, a serial communication port other than a USB port, or other type of port. A periphery device can connect to each port. The periphery device communication unit 35 communicates with the periphery devices connected to the recording device 12 through the ports as controlled by the recording device control unit 30. Note that the periphery device communication unit 35 may also be configured with a wireless communication capability for communicating wirelessly with periphery devices.
A barcode reader BR, a customer display CD, and an automatic change machine JT are examples of periphery devices that may be connected to the recording device 12 in this example. The barcode reader BR is used to read barcodes from products and product packaging, and to output data representing the read barcodes to the periphery device communication unit 35. The periphery device communication unit 35 then outputs the data input from the barcode reader BR to the recording device control unit 30. The customer display CD displays transaction-related information as controlled by the recording device control unit 30. The information presented on the customer display CD can be checked/viewed by the customer involved in the transaction at the checkout counter L. The automatic change machine JT has cash receiving openings for receiving cash and dispensing openings for dispensing change. When cash is input through the cash receiving openings, the change due is dispensed from the cash dispensing openings, as controlled by the recording device control unit 30.
The control server 15 is a cloud server to which the recording devices 12 and management devices 17 connect as clients. As shown in
The control server control unit 40 preferably includes a CPU, ROM, RAM, and other peripheral circuits, and controls the control server 15. One function block of the control server control unit 40 is a transaction information management unit 401. The transaction information management unit 401 is described further below.
The control server network communication unit 41 communicates with devices connected/coupled to the global network GN (including recording devices 12 and management devices 17) according to a specific communication protocol, as controlled by the control server control unit 40.
The control server storage unit 42 stores data.
The customer terminal 16 is preferably a tablet-computer-style cellular phone (e.g., smartphone) used by a customer of the business during the transaction. As shown in
The terminal control unit 50 preferably includes a CPU, ROM, RAM, and other peripheral circuits, and controls the terminal 16. A specific software application (referred to below as the terminal application AP) runs on its system software and is previously installed in the customer terminal 16. The terminal control unit 50 functions as a terminal application execution unit 501 that reads and executes the terminal application AP and other associated computer programs.
The touch panel 51 includes a display panel on the front of the customer terminal 16, and a touch sensor disposed over the display panel.
The terminal network communication unit 52 communicates through the global network GN with other electronic devices (including the control server 15) connected to the global network GN according to a specific communication protocol as controlled by the terminal control unit 50.
The terminal storage unit 53 stores data.
The camera 54 includes an imaging element such as a CCD (charge-coupled device) image sensor or a CMOS (complementary metal-oxide-semiconductor) image sensor, a photographic lens group, and a lens drive unit/mechanism that drives (i.e. moves) the photographic lens group to adjust the zoom or focus, for example, and is used to take pictures. The camera 54 generates picture image data from the captured image, and outputs to the terminal control unit 50.
The management device 17 is a device that is managed by the entity that manages the store in which the store system 11 is deployed. As shown in
The management device control unit 60 preferably includes a CPU, ROM, RAM, and other peripheral circuits, and controls the management device 17. A web browser is installed on the management device 17. The management device control unit 60 may function as a web browser execution unit 601 by reading and running the web browser and associated programs.
The management device network communication unit 61 (e.g. wired and/or wireless communication interface or network interface card/circuitry) communicates with devices connected to the global network GN (including the control server 15) according to a specific communication protocol as controlled by the management device control unit 60.
The management device storage unit 62 stores data.
The management device display unit 63 includes an LCD panel or other display panel, and displays information as controlled by the management device control unit 60.
Operation of the tablet terminal 13, recording device 12, and control server 15 when a customer transaction (i.e. commercial transaction with a customer) is processed at a checkout counter L is described next.
As shown in
After generating the print data in step SA1, the tablet terminal application execution unit 201 controls the tablet terminal communication unit 21 to send the generated print data to the recording device 12 (step SA2).
As shown in
Next, the recording device control unit 30 acquires a specific URL (Uniform Resource Locator) (i.e. network address) of the control server 15, and generates a control server URL adding uniform identification information of the recording device 12 as a URL query parameter to the acquired URL (step SB2).
The URL of the control server 15 the recording device control unit 30 acquires in step SB2 is previously registered by a specific method and recorded in a configuration file, not shown, within the recording device 12. In step SB2, the recording device control unit 30 references the configuration file to get the URL of the control server 15.
The uniform identification information contains a serial number uniquely identifying a specific recording device 12 (recording device identification information), and receipt identification information J3 (see the sample receipt R1 in
The uniform identification information enables identifying what receipts are produced by which recording devices 12 in plural store systems 11.
In step SB2, the recording device control unit 30 adds a parameter name identifying uniform identification information and the uniform identification information as the parameter value as a URL query parameter to the URL of the control server 15.
Next, the recording device control unit 30 generates image data for a two-dimensional (2D) code (e.g. a 2D barcode) representing the control server URL (step SB3). A program with a function for generating image data for a 2D code symbol representing specific information based on the specific information is previously installed on the recording device control unit 30. In step SB3, the recording device control unit 30 runs this program to generate the image data for the 2D code symbol representing the control server URL.
Next, based on the print data received in step SB1 and the image data for the 2D code symbol representing the control server URL generated in step SB3, the recording device control unit 30 controls the recording device recording unit 31 to produce a receipt (step SB4). The resulting receipt is then given to the customer.
Code information J9, which is the image data for the 2D code symbol representing the control server URL, is also recorded on the receipt R1. The recording device control unit 30 records the code information J9 based on the image data generated in step SB3.
Next, the recording device control unit 30 controls the recording device network communication unit 34 to send the print data received in step SB1 and the uniform identification information to the control server 15 (step SB5). Information related to the data destination (such as the address and protocol) and the format of the transmitted data are previously registered in the recording device 12.
As shown in
Next, the control server control unit 40 extracts the transaction information from the received print data (step SC2). The transaction information is a predefined subset of the receipt information recorded on the receipt. In the sample receipt R1 shown in
Next in step SC3, the control server control unit 40 accesses a transaction information manager database 421 stored on the control server storage unit 42, and creates a record in the database based on the transaction information extracted in step SC2.
In step SC3, the control server control unit 40 creates one record in the transaction information manager database 421 and fills the appropriate field in that record with the uniform identification information received in step SC1. The control server control unit 40 also stores the serial number in the appropriate field in that record. The control server control unit 40 acquires the serial number based on the uniform identification information, which as described above includes the serial number and the receipt identification information. The control server control unit 40 also stores the transaction information extracted in step SC2 in the appropriate field in that record. The control server control unit 40 stores a null value in the customer ID field in that record. Record RA1 in
As described above, a record storing the transaction information related to a specific transaction is created in the transaction information manager database 421 according to a transaction completed at any of the stores in which the store system 11 is deployed. The control server 15 can also provide specific services based on the transaction information manager database 421. An example of a service provided by the control server 15 is described further below.
The processes executed by the customer terminal 16 and the control server 15 when a customer that has completed a transaction uses the customer's own terminal 16 to read the code information J9 (see
The customer that received the receipt starts the terminal application AP on the customer terminal 16 and takes a picture of the 2D code information J9 printed on the receipt with the camera 54. As shown in
If image data for the 2D code symbol is contained in the picture image data (step SD1: YES), the terminal application execution unit 501 executes the next process (step SD2). Note that below the image data for the 2D code symbol contained in the picture image data is image data based on the code information J9 that was printed on the receipt. In step SD2, the terminal application execution unit 501 analyzes the image data for the 2D code symbol contained in the picture image data, and acquires the control server URL represented by the 2D code. As described above, this control server URL is the URL of the control server 15 to which uniform identification information was added as a URL query parameter.
Next, the terminal application execution unit 501 gets the customer ID (step SD3). The customer ID is identification information previously assigned to each customer that can receive an award point service from the control server 15, and is previously stored in a specific storage area in a format that can be accessed by the terminal application execution unit 501.
Next, the terminal application execution unit 501 adds the customer ID acquired in step SD3 as a URL query parameter to the control server URL acquired in step SD2 (step SD4). More specifically, the terminal application execution unit 501 adds the customer ID as the parameter value of a parameter name identifying the customer ID to the control server URL. The control server URL to which the customer ID was added as a URL query parameter is referred to below as a “server access URL.”
Next, the terminal application execution unit 501 accesses the server access URL (step SD5).
As shown in
Next in step SE2, the control server control unit 40 accesses the transaction information manager database 421 stored in the control server storage unit 42, and finds the record in the database identified by the uniform identification information acquired in step SE1.
Next, the control server control unit 40 stores the customer ID acquired in step SE1 to the customer ID field in the database record found in step SE2 (step SE3). As a result, the corresponding fields in the record found in step SE2 are filled with the uniform identification information, transaction information, and customer ID. The record RB1 in
Next, the control server control unit 40 provides a specific service to the customer owning the customer terminal 16 (step SE4).
An example of the specific service provided by the control server control unit 40 in step SE4 is an award points service.
An award points service in this example is a service that awards points based on the total amount paid by the customer in the transaction (which is the amount shown as the transaction total information J8 in the receipt of
Another example of a service provided by the control server control unit 40 in step SE4 is an electronic receipt service. An electronic receipt service is a service that displays an electronic receipt providing at least some of the information in the transaction information. The control server 15 may provide this electronic receipt service using a method such as described below. First, the control server control unit 40 acquires the transaction information from the record processed in step SE3. Next, based on the acquired transaction information, the control server control unit 40 generates drawing data in a specific format for displaying the transaction information in a specific layout on the touch panel 51 of the customer terminal 16. Next, the control server control unit 40 controls the control server network communication unit 41 to send the generated drawing data to the terminal 16. The terminal 16 then displays an electronic receipt based on the received drawing data.
Two examples of services the control server 15 provides to the customer possessing the customer terminal 16 when accessed from the customer terminal 16 based on reading the code information J9, but the services the control server 15 provides are not limited thereto. The control server 15 may provide many different services based on transaction information because transaction information based on individual transactions is stored in the transaction information manager database 421.
A transaction information retrieval service, which is an example of a service the control server 15 provides to someone with particular rights, such as the store manager, when the control server 15 is accessed from a management device 17 is described next.
To receive the transaction information retrieval service, the service receiver starts a browser on the management device 17, and enters a command to access a specific URL on the control server 15 that must be accessed to receive the transaction information retrieval service. This URL is previously given to the service receiver by a specific method. The browser execution unit 601 of the management device control unit 60 of the management device 17 then sends a corresponding HTTP request to the control server 15 based on this command from the service receiver.
In response to a request from the management device 17, the control server control unit 40 of the control server 15 sends an HTML file for displaying an authentication screen G1 (
The service receiver then inputs and confirms the user ID and password on the authentication screen G1. The user ID and password are previously made known to the service receiver by a specific method. Based on inputting and confirming the user ID and password on the authentication screen G1, the browser execution unit 601 sends the user ID and password to the control server 15 by a function of a script embedded in the HTML file. The user ID and password are sent securely using known technology.
The control server control unit 40 of the control server 15 receives the user ID and password, and performs an authentication process based on the user ID and password. If authentication is successful, the control server control unit 40 sends an HTML file for displaying a service request screen G2 (
Area A2 is used when the service receiver wants to retrieve information related to sales (“sales-related information” below) as described further below. As shown in
The processes executed by the management device 17 and control server 15 use area A1 in the service request screen G2 when the service receiver retrieves store-related information, and use area A2 when retrieving sales-related information.
To acquire store-related information, the service receiver inputs the store ID of the store for which store-related information is desired to the store ID input field NN in area A1 of the service request screen G2, and taps the OK button KK1 to confirm entry (step SX1). The store ID is identification information uniquely identifying a store where the store system 11 is deployed. Below, the store ID the service receiver inputs into the store ID input field NN is referred to as the “input store ID.”
As shown in
The transaction information management unit 401 of the control server control unit 40 of the control server 15 is the function block that executes this process by reading and running the above transaction information management program.
As shown in
As shown in
Each store data record also includes authorized user ID information related to the store ID. The authorized user ID information is information identifying the user ID of one or more service receivers permitted to receive store-related information and sales-related information for the store corresponding to the store data.
The store data also includes basic store information related to the store ID. The basic store information is basic information about the particular store, and in this embodiment of the disclosure includes the store's address, telephone number, and information indicating the scale of the store. The basic store information can obviously include different information.
The store data also includes one or more sale counter attributes related to the store ID. A sale counter attribute is information is information about the number of sales (i.e. one or more sales counters) in the store, and is defined for each sale counter. A sale counter attribute in this embodiment conceptually represents the type of sale counter, such as a sales counter for groceries, women's clothing, men's clothing, or toys.
The store data also includes the serial numbers of the one or more recording devices 12 related to a single sale counter attribute. The one or more serial numbers related to one sale counter attribute are the serial numbers of the one or more recording devices 12 installed at the sales counters related to that one sale counter attribute.
In step SG1, the transaction information management unit 401 references the store database 422 and finds the store data record in the database with a store ID matching the input store ID. Next, the transaction information management unit 401 compares the authorized user ID in the selected record with the user ID of the service receiver, and determines if the service receiver has authority to receive store-related information for the corresponding store.
If step SG1 determines that the service receiver does not have such authority, the transaction information management unit 401 executes an appropriate process. For example, the transaction information management unit 401 may generate and send to the management device 17 an HTML file for displaying information reporting that information cannot be provided because the service receiver does not have authority to acquire information about the store identified by the input store ID. If step SG1 determines that the service receiver has authority to receive the information, the transaction information management unit 401 proceeds to step SG2.
In step SG2, the transaction information management unit 401 retrieves the store data record with the input store ID from the store data records in the store database 422. Next, the transaction information management unit 401 retrieves the store ID, basic store information, sale counter attribute, and serial numbers in the retrieved store data record. The information acquired by the transaction information management unit 401 in step SG2 is referred to below as store-related information.
Next, based on the store-related information acquired in step SG2, the transaction information management unit 401 generates JSON format data containing the store-related information structured according to the level of information (step SG3).
Next, the transaction information management unit 401 returns the JSON format data generated in step SG3 as HTTP response (step SG4).
As shown in
Next, the browser execution unit 601 stores the JSON format data acquired in step SF2 in a specific storage area (step SF3). Note that because the JSON format data is text data, the service receiver can acquire the store-related information by reading the stored JSON format data.
Next, the browser execution unit 601 presents a store information display screen G3 based on the JSON format data (SF4).
In this example, the browser execution unit 601 displays the store information display screen G3 in a different browser window than the browser window containing the service request screen G2. As a result, the service receiver can input information to area A2 in the service request screen G2 while referring to the store-related information presented in the store information display screen G3. Note that if the browser has tabs for displaying different web pages, the store information display screen G3 and the service request screen G2 may be presented in different tabs within the same browser window.
Operation of the management device 17 and control server 15 when the service receiver acquires sales-related information is described next.
The service receiver can request and acquire first to third sales-related information as the sales-related information by inputting to area A2, as described below.
The first sales-related information is the gross sales, sales of a specific product, or the number of printed receipts during a specific period in one store. To acquire first sales-related information, the service receiver inputs the store ID of the one store in the store ID input field N1. The service receiver also inputs the specific period in the query period input field N4. The service receiver also selects radio button RR1 in the requested information input area N5 to request gross sales information. The service receiver may alternatively select radio button RR2 in the requested information input area N5 and input the product name in the product name input field SS to request sales information about a specific product. The service receiver may alternatively select radio button RR3 in the requested information input area N5 to request the total number of receipts printed.
The second sales-related information is the gross sales, sales of a specific product, or the number of printed receipts during a specific time period for one recording device 12. Note that the gross sales for one recording device 12 means the total of all transactions processed at a specific checkout counter L where the one recording device 12 is installed, that is, the grand total of the total transaction amount expressed by the transaction total information J8 that is recorded on receipts by the one recording device 12. Sales of a specific product for one recording device 12 means the grand total of the sales of a specific product that were purchased in transactions at the checkout counter L where the one recording device 12 is installed.
To acquire the second sales-related information, the service receiver inputs the serial number of the one recording device 12 in the serial number input field N2. The serial numbers of the recording devices 12 installed at the sales counters of a specific sale counter attribute in a specific store can be acquired by referring to the store information display screen G3 using the method described above. More specifically, by reading the store information display screen G3, the service receiver can input the serial number of the desired recording device 12 in the serial number input field N2 by knowing the store where the recording device 12 is installed and the sale counter attribute of the checkout counter L where the recording device 12 is installed. The service receiver also inputs the specific period in the query period input field N4. The service receiver also selects radio button RR1 in the requested information input area N5 to request gross sales information. The service receiver may alternatively select radio button RR2 in the requested information input area N5 and input the product name in the product name input field SS to request sales information about a specific product. The service receiver may alternatively select radio button RR3 in the requested information input area N5 to request the total number of receipts printed.
Third sales-related information is described next. The third sales-related information is the gross sales, sales of a specific product, or the number of printed receipts during a specific period at the sales counters of a specific sale counter attribute in one store.
To acquire the third sales-related information, the service receiver inputs the store ID of the one store in the store ID input field N1. The service receiver also inputs a specific sale counter attribute in the sales counter attribute input field N3. The sales counter attribute input field N3 in this example is a pull-down menu, and a specific sale counter attribute can be input by selecting one item from among the sale counter attributes presented in the menu. The service receiver also inputs the specific period in the query period input field N4. The service receiver also selects radio button RR1 in the requested information input area N5 to request gross sales information. The service receiver may alternatively select radio button RR2 in the requested information input area N5 and input the product name in the product name input field SS to request sales information about a specific product. The service receiver may alternatively select radio button RR3 in the requested information input area N5 to request the total number of receipts printed.
To acquire sales-related information, the service receiver inputs the necessary information by the method described above in area A2 of the service request screen G2 according to which if the first to third sales-related information is desired, and then taps the OK button KK2 to confirm input (step SX2).
As shown in
The transaction information management unit 401 of the control server control unit 40 of the control server 15 is the function block that executes this process by reading and running the above transaction information management program.
As shown in
In step SI2, the transaction information management unit 401 references the transaction information manager database 421 and the store database 422, and acquires the sales-related information (first to third sales-related information) requested by the service receiver.
For example, if the service receiver requested first sales-related information related to gross sales during a specific time period in one store, the transaction information management unit 401 acquires the first sales-related information by executing the following process. Specifically, the transaction information management unit 401 references the store database 422 to retrieve the store data record for the one store using the store ID as the search key. Next, the transaction information management unit 401 acquires the serial numbers of the recording devices 12 in that one store based on the acquired store data. Next, the transaction information management unit 401 searches the records of the transaction information manager database 421 to find the records for which the date stored in the receipt date information J4 is within the specific period and the serial number stored in the record matches the acquired serial numbers. Next, the transaction information management unit 401 retrieves the transaction total information J8 from each record and computes the sum of all transaction total information J8 values. This calculated amount is the first sales-related information requested by the user.
This example describes the process executed by the transaction information management unit 401 when acquiring first sales-related information related to gross sales during a specific period for one store. However, because the transaction information manager database 421 and store database 422 store all information required to acquire the first to third sales-related information, the transaction information management unit 401 can similarly acquire the first to third sales-related information from the databases.
Next, based on the sales-related information acquired in step SI2, the transaction information management unit 401 generates JSON format data containing the sales-related information structured according to the JSON format (step S13).
Next, the transaction information management unit 401 returns the JSON format data generated in step S13 as HTTP response (step SI4).
As shown in
Next, the browser execution unit 601 presents a sales information display screen G4 based on the JSON format data (step SH4).
As described above, the control server storage unit 42 (storage unit) of the control server 15 (control device) according to the disclosure relationally stores transaction information based on print data received from a recording device 12 that can print receipts, and a serial number (recording device identification information) identifying the recording device 12, in the transaction information manager database 421. In a store database 422, the control server storage unit 42 stores a store ID (store identification information) identifying a particular store, the serial numbers of one or more recording devices 12 used in the store, and a sale counter attribute identifying an attribute of a checkout counter in the store where the recording device 12 is located. In response to a request from a management device 17 as an example of an external device, the control server control unit 40 (control unit) returns sales-related information based on transaction information corresponding to a store ID, sales-related information based on transaction information corresponding to a serial number, or sales-related information based on transaction information corresponding to a combination of store ID and sale counter attribute. Thus comprised, the control server 15 can provide useful information based on the transaction information being information based on receipts produced by the recording device 12.
In response to a request specifying a store ID, the control server control unit 40 also returns the serial numbers of one or more recording devices 12 in a store, and a sale counter attribute identifying an attribute of a checkout counter where the recording device 12 is used in the store. Thus comprised, the control server 15 can provide useful information related to a store based on there being one or more sales counters in a store, and one or more recording devices 12 for printing receipts at each sales counter.
The control server control unit 40 in this embodiment of the disclosure returns sales by the store of the store ID, sales by product, or the number of receipts produced during a specific period as sales-related information based on transaction information related to the store ID. Thus comprised, the control server 15 can provide useful information based on transaction information in response to a query.
The control server control unit 40 in this embodiment can also return the grand total of all sales receipts, the total sales byproducts printed on the receipts, or the total number of receipts printed by the recording device 12 of the serial number within a specific period as the sales-related information based on transaction information related to a serial number. Thus comprised, the control server 15 can provide useful information based on transaction information in response to a query.
The control server control unit 40 in this embodiment can also return the grand total of all sales, the total sales by product, or the total number of receipts printed at a sales counter identified by a store ID and sale counter attribute within a specific period of time as the sales-related information based on transaction information for a specific combination of store ID and sale counter attribute. Thus comprised, the control server 15 can provide useful information based on transaction information in response to a query.
The control server control unit 40 in this embodiment can also return sales-related information in response to a request using a Web API as text data containing structured information. Thus comprised, the control server 15 can return sales-related information as highly useful text data written in a structured format.
The disclosure is described above with reference to a preferred embodiment thereof, but the disclosure is not limited thereto and can be modified and adapted in many ways without departing from the scope of the accompanying claims. For example, the recording device 12 sends print data based on a transaction to the control server 15, and the control server 15 extracts transaction information from the print data. However, the recording device 12 may extract the transaction information from the print data and send the transaction information to the control server 15. Specific examples of the information stored in the transaction information manager database 421 and store database 422 are described above, but the information stored in the databases is not so limited. Specific examples of the store-related information and sales-related information are also described above, but the content of this information is not so limited. The function blocks described above with reference to the figures can also be embodied as desired by hardware and software, and do not suggest a specific hardware configuration.
The disclosure being thus described, it will be obvious that it may be varied in many ways. Such variations are not to be regarded as a departure from the spirit and scope of the invention, and all such modifications as would be obvious to one skilled in the art are intended to be included within the scope of the following claims.
Number | Date | Country | Kind |
---|---|---|---|
2015-003096 | Jan 2015 | JP | national |