User Tools

Site Tools


custom_checkin

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
custom_checkin [2017/09/22 20:44]
kristof
— (current)
Line 1: Line 1:
-===== Configuration ===== 
  
-Je kan de uitslag van de check-in customisen over zelf volledig overrulen. Vul daarvoor een SQL Server functienaam in de tabel General.StClientDisplay op het checkin punt waar je dit op wil. 
- 
-  * Veld: **checkin_function** 
-  * Waarde (bvb): **dbo.F_DOORACCESS** 
- 
-Vb van functie: 
-// 
-CREATE FUNCTION [dbo].[F_DOORACCESS](@member_id int) 
-RETURNS nvarchar(50) 
-AS 
-BEGIN 
- return 'Geen toegang' 
-END// 
- 
- 
-===== Return types ===== 
-Er zijn 5 verschillende returns: 
- 
-  * "1":  standard way of checking in or "Don't change a thing" 
-  * "2":  overrule standard checkin procedure and always access = OK 
-  * "3":  custom function NOT OK: overrule standard checkin procedure and access = FALSE 
-  * "4":  overrule standard checkin procedure and always access = OK but deduct CREDIT (see column checkin_deduct_credit) 
-  * plain tekst:  Custom function NOT OK: overrule standard checkin procedure and access = FALSE + Show returncode as checkin-message on screen 
custom_checkin.1506105855.txt.gz ยท Last modified: 2017/09/22 20:44 (external edit)