CyberPlanet has the possibility to access the billing information in the database in real time. For this a group of Views configured on the MySql server are available.
Connection to MySql base
- CyberPlanet 220.127.116.11 or preview:
The password is that of the user "admin" of CyberPlanet.
- CyberPlanet 18.104.22.168 or later:
The password is configured in PC Menu Server, Configuration, Security, Administration/Operators, "Remote Access to Views"
Returns the tickets issued.
|TicketNo||INT(11)||Ticket number, auto-incremental.|
|CashNo||INT(11)||Box number on which the ticket was issued|
|DateTime_consumed||DATETIME||Date and time of consumption|
|DateTime_ticket||DATETIME||Date and time of ticket issuance|
|duration||TIME||Duration, in the case of meetings|
|pc||SMALLINT(6)||Number of PCs of consumption|
|PosNo||INT(11)||POS number. "0" is PC Server.|
A ticket can contain multiple records, so it must be grouped by 'TicketNo' field to know the total of each ticket.
1) Tickets with your cash amount 1
SELECT ticketNo , SUM(T.total) AS Importe from view_tickets T WHERE T.CashNo=1 GROUP BY ticketno
Table of categories of tickets
Returns the credit notes issued.
|TicketNo||INT(11)||Ticket linked to credit note|
|Cashier||VARCHAR(20)||Operator performing the NC|
|Details||VARCHAR(640)||Comments added to the NC|
|number||INT(11)||Credit note number|
|total||DECIMAL(18,4)||Amount of the CN|
|DateTime||DATETIME||Date and time of issue.|
Credit notes are always associated with a ticket.
Example: All credit notes in box 1
SELECT * FROM view_notascredito WHERE cashNo = 1
Situations to consider
- Tickets filtered by date may not be the same as tickets filtered by box number:
Example: If a box closes the day after it opens. Ex 2: If there is more than one box (turn) on the same day.
- Views are available only on Mysql databases installed on CyberPlanet server PC (Local base).
- Additional Income or Expenses that may be part of a shift are not accessible since integration.