List of Payments by Check & Waiver/Release Still Needed
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and pa.pa_id = en.pa_id
and en_ttl_paid > 0
and
en.en_id not in
(
' at line 13
Select
concat( concat(pa_lname, ', '), pa_fname) as Name
, en_chkNbr as CKnbr
, sum(en_ttl_paid) as CKamt
, sum(en_ttl_fees) as Fees
, en_pay_status as Status
, en.pa_id as IDx
, en.pa_id as Id
from pa_participant pa, en_summary en
where en.ev_id =
and pa.pa_id = en.pa_id
and en_ttl_paid > 0
and
en.en_id not in
(
select e2.en_id from en_summary e2
where e2.ev_id =
and (
upper(en_chkNbr) like ('%PAY%') -- paypal
or upper(en_chkNbr) like ('%POP%') -- PopMoney
or upper(en_chkNbr) like ('%ZEL%') -- Zelle
or upper(en_chkNbr) like ('%VEN%') -- Venmo
or upper(en_chkNbr) like ('%CAS%') -- CashApp
or upper(en_chkNbr) like ('%SQU%') -- Square
or upper(en_chkNbr) like ('%APL%') -- ApplePay
or upper(en_chkNbr) like ('%SAM%') -- SamsungPay
)
)
group by en_chkNbr, en.pa_id, en.pa_id, en.pa_id, en_pay_status , Name
union all
Select
concat( concat(pa_lname, ', '), pa_fname) as Name
, cs_chkNbr as CKnbr
, sum(cs_ttl_paid) as CKamt
, sum(cs_ttl_fees) as Fees
, cs_pay_status as Status
, cs.pa_id as IDx
, cs.pa_id as Id -- used by report facility, not displayed
from pa_participant pa, cs_summary cs
where cs.ev_id =
and pa.pa_id = cs.pa_id
and cs_ttl_paid > 0
and upper(cs_chkNbr) not like ('%PAY%') -- paypal
and upper(cs_chkNbr) not like ('%POP%') -- PopMoney
and upper(cs_chkNbr) not like ('%ZEL%') -- Zelle
and upper(cs_chkNbr) not like ('%VEN%') -- Venmo
and upper(cs_chkNbr) not like ('%CAS%') -- CashApp
and upper(cs_chkNbr) not like ('%SQU%') -- Square
and upper(cs_chkNbr) not like ('%APL%') -- ApplePay
and upper(cs_chkNbr) not like ('%SAM%') -- SamsungPay
group by cs_chkNbr, cs.pa_id, cs.pa_id, cs.pa_id, cs_pay_status, Name
order by Name, CKnbr
Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in /homepages/34/d93125787/htdocs/jason205/dte_functions.php on line 1128
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /homepages/34/d93125787/htdocs/jason205/dte_functions.php on line 1158
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and pa.pa_id = en.pa_id
and en.en_id in
(
select e2.en_id fr' at line 15
Select
concat( concat(pa_lname, ', '), pa_fname) as Name
, en_pay_status as Status
, en_chkNbr as PayType
, en_ttl_fees as Fee
, en_ttl_paid as FeePd
, en_epay_amt as e_PaidAmt
, en_epay_chg as e_NoRefund
, en.pa_id as ID
, en.pa_id as Id -- used by report facility, not displayed
from pa_participant pa, en_summary en
where en.ev_id =
and pa.pa_id = en.pa_id
and en.en_id in
(
select e2.en_id from en_summary e2
where e2.ev_id =
and (
upper(e2.en_chkNbr) like ('%PAY%') -- paypal
or upper(e2.en_chkNbr) like ('%POP%') -- PopMoney
or upper(e2.en_chkNbr) like ('%ZEL%') -- Zelle
or upper(e2.en_chkNbr) like ('%VEN%') -- Venmo
or upper(e2.en_chkNbr) like ('%CAS%') -- CashApp
or upper(e2.en_chkNbr) like ('%SQU%') -- Square
or upper(e2.en_chkNbr) like ('%APL%') -- ApplePay
or upper(e2.en_chkNbr) like ('%SAM%') -- SamsungPay
)
)
union all
Select
concat( concat(pa_lname, ', '), pa_fname) as Name
, cs_pay_status as Status
, cs_chkNbr as PayType
, cs_ttl_fees as Fee
, cs_ttl_paid as FeePd
, ' ' as e_PaidAmt -- cs_epay_amt (future enhancement)
, ' ' as e_NoRefund -- cs_epay_chg (future enhancement)
, cs.pa_id as ID
, cs.pa_id as Id -- used by report facility, not displayed
from pa_participant pa, cs_summary cs
where cs.ev_id =
and pa.pa_id = cs.pa_id
and cs.cs_id in
(
select c2.cs_id from cs_summary c2
where c2.ev_id =
and (
upper(c2.cs_chkNbr) like ('%PAY%') -- paypal
or upper(c2.cs_chkNbr) like ('%POP%') -- PopMoney
or upper(c2.cs_chkNbr) like ('%ZEL%') -- Zelle
or upper(c2.cs_chkNbr) like ('%VEN%') -- Venmo
or upper(c2.cs_chkNbr) like ('%CAS%') -- CashApp
or upper(c2.cs_chkNbr) like ('%SQU%') -- Square
or upper(c2.cs_chkNbr) like ('%APL%') -- ApplePay
or upper(c2.cs_chkNbr) like ('%SAM%') -- SamsungPay
)
)
order by Name, PayType
Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in /homepages/34/d93125787/htdocs/jason205/dte_functions.php on line 1128
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /homepages/34/d93125787/htdocs/jason205/dte_functions.php on line 1158
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and pa.pa_id = en.pa_id
and (
pa.pa_id not in
( Select e2.pa_id fr' at line 7
Select concat( concat(pa_lname, ', '), pa_fname) as Name
, ' ' as 'Waiver Check Off'
, en.pa_id as Id -- used by report facility, not displayed
from pa_participant pa, en_summary en
where en.ev_id =
and pa.pa_id = en.pa_id
and (
pa.pa_id not in
( Select e2.pa_id from en_summary e2
where e2.ev_id =
and ( (upper(e2.en_chknbr) like 'W-%' ) or (upper(e2.en_chknbr) like 'X-%') )
)
)
group by Name, 'Waiver Check Off', Id
order by Name
Warning: mysql_num_fields() expects parameter 1 to be resource, boolean given in /homepages/34/d93125787/htdocs/jason205/dte_functions.php on line 1128
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /homepages/34/d93125787/htdocs/jason205/dte_functions.php on line 1158