function claim_information($proc, $payrec = NULL)
{
$query = "SELECT " . "CONCAT(pt.ptlname, ', ', pt.ptfname, " . "' ', pt.ptmname) AS patient, " . "pt.ptdob AS patient_dob, " . "pt.id AS patient_id, " . "c.id AS curr_cov, " . "CONCAT(i.insconame, ' (', i.inscocity, ', ', " . "i.inscostate) AS payer_name, " . "i.inscodefoutput AS default_format, " . "d.icd9code AS diagnosis, " . "pt.ptssn AS ssn, " . "c.covrel AS rp_name, " . "IF(c.covrel != 'S', c.covdob, pt.ptdob ) AS rp_dob, " . "IF(c.covrel != 'S', c.covssn, pt.ptssn) AS rp_ssn, " . "p.proccov1 AS coverage_primary, " . "p.proccov2 AS coverage_secondary, " . "p.proccov3 AS coverage_tertiary, " . "f.psrname AS facility, " . "pc.cptcode AS cpt_code, " . "p.proccharges AS fee, " . "p.procamtpaid AS paid, " . "p.procbalcurrent AS balance, " . "p.procbilled AS billed, " . "p.procdt AS service_date, " . "p.procphysician AS provider, " . "p.procrefdoc AS referring_provider, " . "c1.covcopay AS prim_copay, " . "c1.covdeduct AS prim_deduct, " . "c2.covcopay AS sec_copay, " . "c2.covdeduct AS sec_deduct, " . "c3.covcopay AS ter_copay, " . "c3.covdeduct AS ter_deduct, " . "p.id AS proc " . "FROM " . "patient AS pt, " . ($payrec ? "payrec AS pa, " : "") . "procrec AS p " . "LEFT OUTER JOIN coverage c1 ON c1.id=p.proccov1 " . "LEFT OUTER JOIN coverage c2 ON c2.id=p.proccov2 " . "LEFT OUTER JOIN coverage c3 ON c3.id=p.proccov3 " . "LEFT OUTER JOIN coverage c ON c.id=p.proccurcovid " . "LEFT OUTER JOIN insco i ON i.id=c.covinsco " . "LEFT OUTER JOIN icd9 d ON p.procdiag1 = d.id " . "LEFT OUTER JOIN cpt pc ON p.proccpt = pc.id " . "LEFT OUTER JOIN facility f ON p.procpos = f.id " . "WHERE " . "p.procpatient = pt.id AND " . ($payrec ? "pa.payrecproc = p.id AND " : "") . ($payrec ? "pa.id = '" . addslashes($payrec) . "'" : "p.id = '" . addslashes($proc) . "'");
//print "query = \"$query\"<br/>\n";
$r = $GLOBALS['sql']->queryRow($query);
//return $query;
$pm = CreateObject('org.freemedsoftware.module.ProviderModule');
$r['provider_name'] = $pm->fullName($r['provider']);
$r['ref_provider_name'] = $pm->fullName($r['referring_provider']);
if ($r['coverage_primary'] != null && $r['coverage_primary'] != '0') {
$c_primary = CreateObject('org.freemedsoftware.core.Coverage', $r['coverage_primary']);
//return $c_primary->covinsco->get_name();
$r['prim_cov'] = $c_primary->covinsco->get_name() . ' (' . $c_primary->covpatinsno . ')';
} else {
$r['prim_cov'] = "";
}
if ($r['coverage_secondary'] != null && $r['coverage_secondary'] != '0') {
$c_sec = CreateObject('org.freemedsoftware.core.Coverage', $r['coverage_secondary']);
$r['sec_cov'] = $c_sec->covinsco->get_name() . ' (' . $c_sec->covpatinsno . ')';
} else {
$r['sec_cov'] = "";
}
if ($r['coverage_tertiary'] != null && $r['coverage_tertiary'] != '0') {
$c_ter = CreateObject('org.freemedsoftware.core.Coverage', $r['coverage_tertiary']);
$r['ter_cov'] = $c_ter->covinsco->get_name() . ' (' . $c_ter->covpatinsno . ')';
} else {
$r['ter_cov'] = "";
}
$hash = freemed::coverage_relationship_picklist();
$r['rp_name'] = $hash[$r['rp_name']];
//$c_sec = CreateObject('org.freemedsoftware.core.Coverage', $r['coverage_secondary']);
//$r['sec_cov']=$c_sec->covinsco->get_name().' ('.$c_sec->covpatinsno.')';
return $r;
}
