From 45c7306c050eb0ed703529986c32197010d7dc4e Mon Sep 17 00:00:00 2001
From: sunsetsystems <sunsetsystems>
Date: Tue, 12 Feb 2008 17:16:52 +0000
Subject: [PATCH] added dob, ssn, policy to the CSV export

---
 interface/reports/collections_report.php | 12 +++++++++---
 1 file changed, 9 insertions(+), 3 deletions(-)

diff --git a/interface/reports/collections_report.php b/interface/reports/collections_report.php
index eefb05c59..a5bc56c37 100644
--- a/interface/reports/collections_report.php
+++ b/interface/reports/collections_report.php
@@ -1,5 +1,5 @@
 <?php
-// Copyright (C) 2006-2007 Rod Roark <rod@sunsetsystems.com>
+// Copyright (C) 2006-2008 Rod Roark <rod@sunsetsystems.com>
 //
 // This program is free software; you can redistribute it and/or
 // modify it under the terms of the GNU General Public License
@@ -459,7 +459,7 @@ function checkAll(checked) {
       if ($pdrow['mname']) $ptname .= " " . substr($pdrow['mname'], 0, 1);
 
       // Look up insurance policy number if we need it.
-      if ($form_cb_policy) {
+      if ($form_cb_policy || $_POST['form_csvexport']) {
         $patient_id = $pdrow['pid'];
         $instype = ($insposition == 2) ? 'secondary' : (($insposition == 3) ? 'tertiary' : 'primary');
         $insrow = sqlQuery("SELECT policy_number FROM insurance_data WHERE " .
@@ -482,6 +482,9 @@ function checkAll(checked) {
       if (true) {
         echo '"Insurance",';
         echo '"Name",';
+        echo '"DOB",';
+        echo '"SSN",';
+        echo '"Policy",';
         echo '"Invoice",';
         echo '"DOS",';
         echo '"Referrer",';
@@ -697,6 +700,9 @@ function checkAll(checked) {
         // echo '"' . $insname                             . '",';
         echo '"' . $row['ins1']                         . '",';
         echo '"' . $ptname                              . '",';
+        echo '"' . $row['DOB']                          . '",';
+        echo '"' . $row['ss']                           . '",';
+        echo '"' . $row['policy']                       . '",';
         echo '"' . $row['invnumber']                    . '",';
         echo '"' . $row['dos']                          . '",';
         echo '"' . $row['referrer']                     . '",';
@@ -783,4 +789,4 @@ if (!$_POST['form_csvexport']) {
 </html>
 <?php
 } // end not form_csvexport
-?>
\ No newline at end of file
+?>
-- 
2.11.4.GIT