{runquery 1} {runquery 2}

## {translatestatictext 'Arrivals in Queue'.{const language}} - {field 2.WGBS_DATEVALUE}

{translatestatictext 'Name'.{const language}} | {translatestatictext 'Time on Queue'.{const language}} | {translatestatictext 'Res. No.'.{const language}} | {translatestatictext 'No.Of rooms'.{const language}} | {translatestatictext 'No.of Adults'.{const language}} | {translatestatictext 'Departure'.{const language}} | {translatestatictext 'Room Type'.{const language}} | {translatestatictext 'Room No. / Status'.{const language}} |
--- | --- | --- | --- | --- | --- | --- | --- | ---
{forall 1}
{field 1.name} {dif '{field 1.vipcode}'=''}{/dif}{else} VIP {field 1.vipcode} {/else} | {field 1.yque_date} / {fshorttime}{field 1.yque_datetime}{/fshorttime} | {field 1.yres_id} | {field 1.ydet_noofrooms} | {field 1.ydet_adultno} | {field 1.yres_expdeptime} | {field 1.ycat_shortdesc} | {dif '{field 1.yrms_shortdesc}'<>''} {field 1.yrms_shortdesc} / {/dif}{else} {/else}{field 1.YHKS_SHORTDESC} | {if ({const Web})=(1)} {dif '{field 1.yrms_shortdesc}'=''}{runsubquery 3.1.YRES_ID} {dif '{field 3.yrms_shortdesc}'<>''} {translatestatictext 'Assign Room:'.{const language}} {/dif} {/dif} {dif '{field 1.yhks_clean}'='1'} {dif '{field 1.occupiedstatus}'='exparr'}{/dif} {dif '{field 1.occupiedstatus}'='departed'}{/dif} {/dif}{/if}{else}{/else}
{/forall}

{if ({const Web})=(1)}
{runquery 4}
{forall 4} {field 4.YHKS_LONGDESC}
{/forall}
{/if}