fbenoist68
/
hdpos
1
0
Fork 0
Code Issues 3 Pull Requests Packages Projects Releases 3 Wiki Activity

Revue de code API #2

New Issue
Closed
opened 2023-12-18 11:00:33 +01:00 by fbenoist68 · 4 comments
fbenoist68 commented 2023-12-18 11:00:33 +01:00
Owner
  • loc_state_journal > business date
  • ctl_device_registration => plutot prendre la version ici / adresse IP
  • VERIFIER TOUTES LES REQUETES avec organization_id !!!
  • Plutot passer en paramètre au minima la business date (voire avec rtl_loc_id)
- loc_state_journal > business date - ctl_device_registration => plutot prendre la version ici / adresse IP - VERIFIER TOUTES LES REQUETES avec organization_id !!! - Plutot passer en paramètre au minima la business date (voire avec rtl_loc_id)
fbenoist68 commented 2023-12-23 12:51:16 +01:00
Poster
Owner 
SELECT
    DISTINCT cel.LOGGER_CATEGORY

dtv.sysadmin.data.failover
dtv.sysadmin.data.repqueue.errors. / Xstore replication queue errors
dtv.sysadmin.data.repqueue.nofails. / Xstore replication backlog
dtv.sysadmin.data.repqueue.notempty
dtv.sysadmin.data.repqueue.readerror
dtv.xstore.app.preflight. / Pre-flight error
dtv.xstore.comm.paysys
dtv.xstore.hardware.init
dtv.xstore.helpdesk
dtv.xstore.helpdesk.memory
dtv.xstore.order.download.error
dtv.xstore.order.download.offline
dtv.xstore.OrderEvent
dtv.xstore.sensitive-data.logging
dtv.xstore.state.app.shutdown
dtv.xstore.state.app.startup
dtv.xstore.uncaught
dtv.xstore.version.conflict.env
dtv.xstore.version.conflict.xst

Je ne trouve pas les type : Xcenter replication failure

On peut retrouver pour une caisse les log (l'index principal est sur create_date)

SELECT
	cel.CREATE_DATE ,
	cel.RTL_LOC_ID ,
	cel.WKSTN_ID ,
	cel.BUSINESS_DATE, 
	cel.LOG_LEVEL ,
	cel.THREAD_NAME ,
	cel.LOG_LEVEL
FROM
	dtv.CTL_EVENT_LOG cel
WHERE
	cel.CREATE_DATE BETWEEN TO_DATE('21/12/2023', 'dd/mm/rrrr') AND TO_DATE('21/12/2023 23:59:59', 'dd/mm/rrrr hh24:mi:ss')
	AND cel.ORGANIZATION_ID = 1
	AND cel.RTL_LOC_ID = 5108
	AND cel.WKSTN_ID = 20
	AND cel.LOG_LEVEL = 'FATAL'
ORDER BY
	cel.CREATE_DATE;

SELECT
	COUNT(*)
FROM
	dtv.CTL_EVENT_LOG cel
WHERE
	cel.CREATE_DATE BETWEEN TO_DATE('21/12/2023', 'dd/mm/rrrr') AND TO_DATE('21/12/2023 23:59:59', 'dd/mm/rrrr hh24:mi:ss')
	AND cel.ORGANIZATION_ID = 1
	AND cel.RTL_LOC_ID = 5108
	AND cel.WKSTN_ID = 20
	AND cel.LOG_LEVEL = 'FATAL';

image

``` SELECT DISTINCT cel.LOGGER_CATEGORY ``` dtv.sysadmin.data.failover dtv.sysadmin.data.repqueue.errors. / Xstore replication queue errors dtv.sysadmin.data.repqueue.nofails. / Xstore replication backlog dtv.sysadmin.data.repqueue.notempty dtv.sysadmin.data.repqueue.readerror dtv.xstore.app.preflight. / Pre-flight error dtv.xstore.comm.paysys dtv.xstore.hardware.init dtv.xstore.helpdesk dtv.xstore.helpdesk.memory dtv.xstore.order.download.error dtv.xstore.order.download.offline dtv.xstore.OrderEvent dtv.xstore.sensitive-data.logging dtv.xstore.state.app.shutdown dtv.xstore.state.app.startup dtv.xstore.uncaught dtv.xstore.version.conflict.env dtv.xstore.version.conflict.xst Je ne trouve pas les type : Xcenter replication failure On peut retrouver pour une caisse les log (l'index principal est sur create_date) ``` SELECT cel.CREATE_DATE , cel.RTL_LOC_ID , cel.WKSTN_ID , cel.BUSINESS_DATE, cel.LOG_LEVEL , cel.THREAD_NAME , cel.LOG_LEVEL FROM dtv.CTL_EVENT_LOG cel WHERE cel.CREATE_DATE BETWEEN TO_DATE('21/12/2023', 'dd/mm/rrrr') AND TO_DATE('21/12/2023 23:59:59', 'dd/mm/rrrr hh24:mi:ss') AND cel.ORGANIZATION_ID = 1 AND cel.RTL_LOC_ID = 5108 AND cel.WKSTN_ID = 20 AND cel.LOG_LEVEL = 'FATAL' ORDER BY cel.CREATE_DATE; ``` ``` SELECT COUNT(*) FROM dtv.CTL_EVENT_LOG cel WHERE cel.CREATE_DATE BETWEEN TO_DATE('21/12/2023', 'dd/mm/rrrr') AND TO_DATE('21/12/2023 23:59:59', 'dd/mm/rrrr hh24:mi:ss') AND cel.ORGANIZATION_ID = 1 AND cel.RTL_LOC_ID = 5108 AND cel.WKSTN_ID = 20 AND cel.LOG_LEVEL = 'FATAL'; ``` ![image](/attachments/613fcb23-96e5-419c-bde7-e93a20264bc7)
image.png
46 KiB
fbenoist68 commented 2023-12-23 13:22:14 +01:00
Poster
Owner

On peut s'appuyer sur cette table pour la business date et si c'est une caisse primaire
Pour la version d'XSTORE il vaut mieux utiliser ctl_version_history car il y a la date d'install et c'est important.

SELECT
	cdr.IP_ADDRESS ,
	cdr.BUSINESS_DATE ,
	cdr.XSTORE_VERSION,
	cdr.PRIMARY_REGISTER_FLAG
FROM
	dtv.ctl_device_registration cdr
WHERE
	cdr.ORGANIZATION_ID = 1
	AND cdr.RTL_LOC_ID = 4
	AND cdr.WKSTN_ID = 20;

image

On peut s'appuyer sur cette table pour la business date et si c'est une caisse primaire Pour la version d'XSTORE il vaut mieux utiliser ctl_version_history car il y a la date d'install et c'est important. ``` SELECT cdr.IP_ADDRESS , cdr.BUSINESS_DATE , cdr.XSTORE_VERSION, cdr.PRIMARY_REGISTER_FLAG FROM dtv.ctl_device_registration cdr WHERE cdr.ORGANIZATION_ID = 1 AND cdr.RTL_LOC_ID = 4 AND cdr.WKSTN_ID = 20; ``` ![image](/attachments/b0138524-9bc6-4d56-be87-3020f8f73b36)
image.png
15 KiB
fbenoist68 commented 2023-12-23 13:47:29 +01:00
Poster
Owner

On peut récupérer les heures d'ouverture / fermeture sur une date

SELECT
	DISTINCT STATUS_TYPCODE,STRING_VALUE
FROM
	loc_state_journal lsj
WHERE
	lsj.ORGANIZATION_ID = 1
	AND lsj.RTL_LOC_ID = 4
	AND lsj.WKSTN_ID = 20
ORDER BY 1;

image

SELECT
	lsj.STATUS_TYPCODE ,
	lsj.STRING_VALUE ,
	lsj.TIME_STAMP
FROM
	loc_state_journal lsj
WHERE
	lsj.TIME_STAMP BETWEEN TO_TIMESTAMP('21/12/2023', 'dd/mm/rrrr') AND TO_TIMESTAMP('21/12/2023 23:59:59', 'dd/mm/rrrr hh24:mi:ss')
	AND lsj.ORGANIZATION_ID = 1
	AND lsj.RTL_LOC_ID = 4
	AND lsj.WKSTN_ID = 20
	AND lsj.STATUS_TYPCODE = 'WKSTN_STATE'
ORDER BY
	lsj.STATE_JOURNAL_ID;

image

On peut récupérer les heures d'ouverture / fermeture sur une date ``` SELECT DISTINCT STATUS_TYPCODE,STRING_VALUE FROM loc_state_journal lsj WHERE lsj.ORGANIZATION_ID = 1 AND lsj.RTL_LOC_ID = 4 AND lsj.WKSTN_ID = 20 ORDER BY 1; ``` ![image](/attachments/81b36ece-197c-435b-9243-8615df0fc58b) ``` SELECT lsj.STATUS_TYPCODE , lsj.STRING_VALUE , lsj.TIME_STAMP FROM loc_state_journal lsj WHERE lsj.TIME_STAMP BETWEEN TO_TIMESTAMP('21/12/2023', 'dd/mm/rrrr') AND TO_TIMESTAMP('21/12/2023 23:59:59', 'dd/mm/rrrr hh24:mi:ss') AND lsj.ORGANIZATION_ID = 1 AND lsj.RTL_LOC_ID = 4 AND lsj.WKSTN_ID = 20 AND lsj.STATUS_TYPCODE = 'WKSTN_STATE' ORDER BY lsj.STATE_JOURNAL_ID; ``` ![image](/attachments/e15b740c-aa4b-496f-81ef-0aa8d19e8d50)
image.png
18 KiB
image.png
17 KiB
fbenoist68 commented 2024-01-27 08:02:37 +01:00
Poster
Owner

Tout à été revu pour la version 1.0.1

Tout à été revu pour la version 1.0.1
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
main
dev
release/1.0.2
feature/issue-14/chatrct
feature/issue-4/bruno
release/1.0.1
feature/issue-7/obi
feature/issue-1/ws-read-store-detail
V1.0.2
V1.0.1
V1.0.0
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: fbenoist68/hdpos#2
There is no content yet.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?