Bruce Gust
asked on
What does $statementData mean?
Here's my function:
Line 49 you see ".( $statementData ? ". Is that an IF statement? I'm trying to determine if the fact that it's defined as True at the beginning of the function, it simply means to include this as part of the SELECT. Bottom line: What is it?
protected function getSQL($where, $statementData = true, $templateid = 4) {
$sql = "
OPEN SYMMETRIC KEY PCAR_Key
DECRYPTION BY CERTIFICATE PCAR_Certificate
SELECT
ac.AccountID,
clt.ClientName,
clt.ClientTetrisID,
clt.ClientID,
cast(dbo.ufn_ClientPreference(clt.ClientID, 'StatementRollUp') as int) as StatementRollUp,
prt.PracticeID,
prt.PracticeName,
prt.twiliophone,
prt.showphysician,
pat.patientfname,
pat.patientlname,
pat.patientinitial,
pat.patientdob,
pat.patientdod,
CONVERT(varchar(100), DecryptByKey(pat.eSSN)) as patientssn,
coalesce(ac.mobilephone, ac.homephone, ac.workphone, null) as phonenumber,
ac.maddress1,
ac.maddress2,
ac.maddress3,
ac.mcity,
ac.mstate,
ac.mzip,
dbo.ufn_StatementWorkingCharges(prt.PracticeCode,ac.practiceaccountid) as TotalCharges,
dbo.ufn_StatementWorkingAdjustments(prt.PracticeCode,ac.practiceaccountid) * -1 as TotalAdjustments,
dbo.ufn_StatementWorkingPayments2(prt.PracticeCode,ac.practiceaccountid) * -1 as TotalPayments,
CASE WHEN ISNULL(pp.pmtplanamount, 0) <
(dbo.ufn_StatementWorkingCharges(prt.PracticeCode,ac.practiceaccountid) +
(dbo.ufn_StatementWorkingAdjustments(prt.PracticeCode,ac.practiceaccountid) * -1) +
(dbo.ufn_StatementWorkingPayments2(prt.PracticeCode,ac.practiceaccountid) * -1))
THEN
isnull(pp.pmtplanamount, 0)
ELSE dbo.ufn_StatementWorkingCharges(prt.PracticeCode,ac.practiceaccountid) +
(dbo.ufn_StatementWorkingAdjustments(prt.PracticeCode,ac.practiceaccountid) * -1) +
(dbo.ufn_StatementWorkingPayments2(prt.PracticeCode,ac.practiceaccountid) * -1)
END AS AmountDue,
isnull(pp.pmtplanday,0) as duedate,
isnull(pp.startingplanbalance, 0) as planbalance,
ac.PracticeAccountID,
clt.lockboxAddress1,
clt.lockboxAddress2,
clt.lockboxCity,
clt.lockboxState,
clt.lockboxZip,"
.( $statementData ? "
st.templateid,
st.statementid,
null as lastclaimdate,
/* Temporary option to disinguish if the account has an encounter in placementgroup 1353 for the URMC lockbox move */
(select top 1 id from chargegroup cg where cg.accountid = ac.accountid and placementgroupid = 1353) as [1353]
from Statement st with (nolock)
Join Account ac with (nolock) on st.Accountid = ac.AccountID
" : "
'$templateid' as templateid,
'' as statementid,
null as lastclaimdate,
/* Temporary option to disinguish if the account has an encounter in placementgroup 1353 for the URMC lockbox move */
(select top 1 id from chargegroup cg where cg.accountid = ac.accountid and placementgroupid = 1353) as [1353]
from Account ac with (nolock)
" )."
join Patient pat with (nolock) on pat.AccountID = ac.AccountID
join Practice prt with (nolock) on ac.PracticeID = prt.PracticeID
join Client clt with (nolock) on prt.ClientID = clt.ClientID
left join
(select pmtplanamount, pmtplanday, primarypatientid, startingplanbalance from PaymentPlan
where planendeddate is null
and iscurrentplan = 1) pp
on pp.primarypatientid = pat.patientid
$where
";
Line 49 you see ".( $statementData ? ". Is that an IF statement? I'm trying to determine if the fact that it's defined as True at the beginning of the function, it simply means to include this as part of the SELECT. Bottom line: What is it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
exactly
ASKER
Thank you!
ASKER
clt.loclkboxState,
clt.lockboxZip,
st.templateid
st.statementid
null as lastclaimdate,
from Statement st with (nolock)
etc...
In other words, everything between the parenthesis is a part of the SQL statement, unless the "$statementData" value is specified as false, correct?