SELECT
ac.AccountID,
clt.ClientName,
clt.ClientTetrisID,
clt.ClientID,
cast(dbo.ufn_ClientPreference(clt.ClientID, 'StatementRollUp') as int) as StatementRollUp
from Statement st with (nolock)
Join Account ac with (nolock) on st.Accountid = ac.AccountID
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 ac.accountid=10093227
<?php
date_default_timezone_set('America/Chicago');
$mssql_pdo=new PDO("");
$mssql_pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
if(!$mssql_pdo)
{
echo "no connection";
}
function test(){
global $mssql_pdo;
//$sql="select TOP 5 patientcode from txn where accountid=10001124";
$sql="
SELECT
ac.AccountID,
clt.ClientName,
clt.ClientTetrisID,
clt.ClientID,
cast(dbo.ufn_ClientPreference(clt.ClientID, 'StatementRollUp') as int) as StatementRollUp
from Statement st with (nolock)
Join Account ac with (nolock) on st.Accountid = ac.AccountID
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 ac.accountid=10093227";
//echo $sql;
$query=$mssql_pdo->query($sql);
if(!$query){
echo "nope";
}
$result_array=array();
while($row=$query->fetch(PDO::FETCH_ASSOC) )
{
$result_array[]=$row;
}
return $result_array;
}
//$test_sql=getOldTransactions();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Patient Focus | SQL Machine</title>
<script language="JavaScript"><!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
window.open(selObj.options[selObj.selectedIndex].value, "_blank");
if (restore) selObj.selectedIndex=0;
}
// -->
</script>
<script type="text/javascript">
<!--
function toggle_visibility(id) {
var e = document.getElementById(id);
if(e.style.display == 'none')
e.style.display = 'block';
else
e.style.display = 'none';
}
//-->
</script>
<style>
body {
font-family:Arial;
size:12pt;
color:#000000;
}
.content {
margin:auto;
width:900px;
height:auto;
border:1px solid #cccccc;
border-radius:10px;
}
.wysiwyg {
white-space: pre-line;
padding-left:10px;
padding-right:10px;
}
.code_container {
border:1px solid #000000;
width:807px;
height:250px;
overflow:auto;
background-color: #013c76;
font-family:Arial;
color:#ffffff;
font-size:10pt;
margin:auto;
white-space:pre;
}
ol {
white-space: normal;
word-wrap: break-word;
width:750px;
margin:auto;
background-color:#036; background-repeat:repeat-y;background-position:center;
font-family:Helevtica, Arial;
font-size:10pt;
color:#ffffff;
}
ol li {
padding:6px;
background-color:#ffc;
color:#ffffff;
}
ol li span{
color:#000000; }
.blue {
color:blue;
}
</style>
</head>
<body>
<br><br>
<div class="content">
<div class="wysiwyg">
<table border="1" cellspacing="5" cellpadding="5" width="100%">
<tr>
<td>Account ID</td>
<td>Client Name</td>
<td>Client Tetris ID</td>
<td>Client ID</td>
<td>Statement Roll Up</td>
</tr>
<?php
$test_stuff=test();
//echo $test_stuff;
if($test_stuff){
//echo "yes";
}
foreach($test_stuff as $row)
{
echo "<tr><td>";
echo $row['AccountID'];
echo "</td><td>";
echo $row['ClientName'];
echo "</td><td>";
echo $row['ClientTetrisID'];
echo "</td><td>";
echo $row['ClientID'];
echo "</td><td>";
echo $row['StatementRollUp'];
echo "</td></tr>";
}
?>
</table>
</div>
</div>
</body>
</html>
ASKER
PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.
TRUSTED BY
ASKER
I appreciate your time, friend! I'm up against a deadline so I'm glad you're at your desk! BTW: I'm in Nashville, so good to be talking to fellow Tennessean!
I should've provided the function. Here it is:
Open in new window
If you're like most, you're looking at this and wondering "Who wrote this?" I know. But be that as it may, I've got to understand what it's doing and how so I can determine conclusively whether or not it's posing a problem.
It works when I fire it in Studio, but it gives me a 0 when I run in PDO. Why the disparity?