getpassinfo
Description
getpassinfo retrieves information about new pass/access records and modified pass/access records. getpassinfo offers the ability to query the SiriusSQL data in order to retrieve information regarding new pass sales/access records and modified pass/access records.
Note: Either <new>1</new> (for new pass/access info) or <mod>1</mod> (for modified pass/access info) must be specified in the function call.
Input fields
XML tag | Description |
<new> | Return new records since the indicated datetime. <new>1</new> (for new pass/access info) or <mod>1</mod> (for modified pass/access info) must be specified in the function call. Boolean. |
<mod> | Return modified records since the indicated datetime. <new>1</new> (for new pass/access info) or <mod>1</mod> (for modified pass/access info) must be specified in the function call. Boolean. |
<datetime> | Sets the datetime. |
<access> | Used to check the access table instead of the gst_pass table, default is to check gst_pass. Boolean. |
Return fields
Selected fields from records in either the gst_pass or access table.
Examples
Example invocation:
Returns all new passes purchased since 6/04/2007:
<func>getpassinfo</func><new>1</new><mod>0</mod><datetime>6/04
/2007</datetime><access>0</access>
Returns all new passes purchased since 6/06/2007:
<func>getpassinfo</func><new>1</new><mod>0</mod>
<datetime>6/06/2007</datetime><access>0</access>
Example return string:
OK :…recordset
<rs:data>
<z:row pass_no='5020001' guest_no='1020001' masterpass='5020001'
swipe_no='' addit_no='0' val_parent='False' valprnttyp='1'
printcount='0' start_date='2006-11-01T00:00:00' expires='2007-04-30T00:00:00'
validcount='0' dis_count='0' total_uses='1' usesw_left='0'
usest_left='0' points1='0' points2='0' money1='0' money2='0'
warnings='0' voided_for='' voided_by='' trans_no='37020001'
mastertran='37020001' department='PASSES ' category='LIMITED '
item='WEEKDAY ' amt_paid='200' account='BSCOUTS436'
operator='SUZY ' salespoint='RESERV' date_time='2007-09-30T14:25:26'
totalcomp='0' invoice_no='0' cc_tracks='' crlimit='0'
crlimit_dy='0' dw_active='False' splimit='0' splimit_dy='0'
last_mod='74' card_id='0' bl_reason=' ' importpass='SPAS5020001'
level_chg='0' purch_chg='0'/>
</rs:data>
See also