From bc955a3763c415ffc27afd9e07430c7979ab6c1a Mon Sep 17 00:00:00 2001
From: sunsetsystems <sunsetsystems>
Date: Mon, 28 Jan 2008 18:06:15 +0000
Subject: [PATCH] added visit category to encounters

---
 interface/forms/newpatient/new.php  | 21 ++++++++++++++++++++-
 interface/forms/newpatient/save.php |  3 +++
 interface/forms/newpatient/view.php | 21 ++++++++++++++++++++-
 sql/2_8_3-to-2_8_4_upgrade.sql      |  3 +++
 sql/database.sql                    |  1 +
 5 files changed, 47 insertions(+), 2 deletions(-)

diff --git a/interface/forms/newpatient/new.php b/interface/forms/newpatient/new.php
index c9fa5f4b3..9b46633c0 100644
--- a/interface/forms/newpatient/new.php
+++ b/interface/forms/newpatient/new.php
@@ -93,7 +93,7 @@
    <textarea name='reason' cols='40' rows='4' wrap='virtual' style='width:96%'
     ><?php echo $GLOBALS['default_chief_complaint'] ?></textarea>
   </td>
-  <td rowspan='5' valign='top'>
+  <td rowspan='6' valign='top'>
    <select multiple name='issues[]' size='10' style='width:100%'
     title='<?php xl('Hold down [Ctrl] for multiple selections or to unselect','e'); ?>'>
 <?
@@ -109,6 +109,25 @@
  </tr>
 
  <tr>
+  <td class='text' width='1%' nowrap><?php xl('Visit Category:','e'); ?></td>
+  <td>
+   <select name='pc_catid'>
+<?php
+ $cres = sqlStatement("SELECT pc_catid, pc_catname " .
+  "FROM openemr_postcalendar_categories ORDER BY pc_catname");
+ while ($crow = sqlFetchArray($cres)) {
+  $catid = $crow['pc_catid'];
+  if ($catid < 9 && $catid != 5) continue;
+  echo "    <option value='$catid'";
+  // if ($crow['pc_catid'] == $result['pc_catid']) echo " selected";
+  echo ">" . $crow['pc_catname'] . "</option>\n";
+ }
+?>
+   </select>
+  </td>
+ </tr>
+
+ <tr>
   <td class='text' width='1%' nowrap><?php xl('Facility:','e'); ?></td>
   <td>
    <select name='facility_id'>
diff --git a/interface/forms/newpatient/save.php b/interface/forms/newpatient/save.php
index 66f000850..5bbcf4b3a 100644
--- a/interface/forms/newpatient/save.php
+++ b/interface/forms/newpatient/save.php
@@ -18,6 +18,7 @@ $conn = $GLOBALS['adodb']['db'];
 $date        = $_POST['form_date'];
 $onset_date  = $_POST['form_onset_date'];
 $sensitivity = $_POST['form_sensitivity'];
+$pc_catid    = $_POST['pc_catid'];
 $facility_id = $_POST['facility_id'];
 $reason      = $_POST['reason'];
 $mode        = $_POST['mode'];
@@ -37,6 +38,7 @@ if ($mode == 'new')
       "date = '$date', " .
       "onset_date = '$onset_date', " .
       "reason = '$reason', " .
+      "pc_catid = '$pc_catid', " .
       "facility_id = '$facility_id', " .
       "sensitivity = '$sensitivity', " .
       "pid = '$pid', " .
@@ -58,6 +60,7 @@ else if ($mode == 'update')
     $datepart .
     "onset_date = '$onset_date', " .
     "reason = '$reason', " .
+    "pc_catid = '$pc_catid', " .
     "facility_id = '$facility_id', " .
     "sensitivity = '$sensitivity' " .
     "WHERE id = '$id'");
diff --git a/interface/forms/newpatient/view.php b/interface/forms/newpatient/view.php
index 90b3bfab2..db12a4731 100644
--- a/interface/forms/newpatient/view.php
+++ b/interface/forms/newpatient/view.php
@@ -96,7 +96,7 @@
   <td colspan='2'>
    <textarea name='reason' cols='40' rows='4' wrap='virtual' style='width:96%'><? echo htmlspecialchars($result['reason']) ?></textarea>
   </td>
-  <td rowspan='5' valign='top'>
+  <td rowspan='6' valign='top'>
    <select multiple name='issues[]' size='10' style='width:100%'
     title='<?php xl('Hold down [Ctrl] for multiple selections or to unselect','e'); ?>'>
 <?
@@ -118,6 +118,25 @@
  </tr>
 
  <tr>
+  <td class='text' width='1%' nowrap><?php xl('Visit Category:','e'); ?></td>
+  <td>
+   <select name='pc_catid'>
+<?php
+ $cres = sqlStatement("SELECT pc_catid, pc_catname " .
+  "FROM openemr_postcalendar_categories ORDER BY pc_catname");
+ while ($crow = sqlFetchArray($cres)) {
+  $catid = $crow['pc_catid'];
+  if ($catid < 9 && $catid != 5) continue;
+  echo "    <option value='$catid'";
+  if ($crow['pc_catid'] == $result['pc_catid']) echo " selected";
+  echo ">" . $crow['pc_catname'] . "</option>\n";
+ }
+?>
+   </select>
+  </td>
+ </tr>
+
+ <tr>
   <td class='text' width='1%' nowrap><?php xl('Facility:','e'); ?></td>
   <td>
    <select name='facility_id'>
diff --git a/sql/2_8_3-to-2_8_4_upgrade.sql b/sql/2_8_3-to-2_8_4_upgrade.sql
index 3a9ddac82..b9f948585 100644
--- a/sql/2_8_3-to-2_8_4_upgrade.sql
+++ b/sql/2_8_3-to-2_8_4_upgrade.sql
@@ -204,3 +204,6 @@ ALTER TABLE drug_sales
   ADD billed tinyint(1) NOT NULL DEFAULT 0 COMMENT 'indicates if the sale is posted to accounting';
 UPDATE drug_sales
   SET billed = 1 WHERE encounter > 0;
+
+ALTER TABLE form_encounter
+  ADD pc_catid int(11) NOT NULL DEFAULT 5 COMMENT 'event category from openemr_postcalendar_categories';
diff --git a/sql/database.sql b/sql/database.sql
index e15a4ceb7..4e3635866 100644
--- a/sql/database.sql
+++ b/sql/database.sql
@@ -276,6 +276,7 @@ CREATE TABLE `form_encounter` (
   `onset_date` datetime default NULL,
   `sensitivity` varchar(30) NOT NULL default '',
   `billing_note` text NOT NULL DEFAULT '',
+  `pc_catid` int(11) NOT NULL DEFAULT 5 COMMENT 'event category from openemr_postcalendar_categories',
   PRIMARY KEY  (`id`)
 ) ;
 
-- 
2.11.4.GIT