Customer visiting control on same day with SQL code

Call us now! +44 (0) 2037347158

Post published:09/12/2019
Post category:Settings

With the following SQL code you can check if the customer has visited the store this day.

SELECT 
'The selected customer has returned today!' "im_messagw"  
from "pvlhseis" where "Kvdikospelath"=:cl
AND cast('Now' as date)=cast("Hmeromhnia" as date)

and "pvlhseis"."Hmeromhnia"<dateadd (second, -2,timestamp 'now')   
and "pvlhseis"."Kvdikospelath">1

SELECT

'The selected customer has returned today!' "im_messagw"

from "pvlhseis" where "Kvdikospelath"=:cl

AND cast('Now' as date)=cast("Hmeromhnia" as date)

and "pvlhseis"."Hmeromhnia"<dateadd (second, -2,timestamp 'now')

and "pvlhseis"."Kvdikospelath">1

It should be installed using the instructions here.