I want to add custom text box in prescrption?

morevishal · June 15, 2017, 11:42am

how can i add text field in priscription database aswell as UI

brady.miller · June 17, 2017, 5:09am

Recommend mimicking what is done for the note field in the prescription:

openemr/openemr/blob/master/templates/prescription/general_edit.html#L234


  <select class="input-sm" name="form" id="form">{html_options options=$prescription->form_array selected=$prescription->form}</select>
  <select class="input-sm" name="route" id="route">{html_options options=$prescription->route_array selected=$prescription->route}</select>
  <select class="input-sm" name="interval" id="interval">{html_options options=$prescription->interval_array selected=$prescription->interval}</select>
{/if}
</td>
</tr>
<tr>
<td COLSPAN="1" class="text" ALIGN="right" VALIGN="MIDDLE" >{xl t='Refills'|escape:'html'}</td>
<td COLSPAN="2" class="text" ALIGN="LEFT" VALIGN="MIDDLE" >
  {html_options name="refills" options=$prescription->refills_array selected=$prescription->refills}
{if $SIMPLIFIED_PRESCRIPTIONS}
  <input TYPE="hidden" ID="per_refill" NAME="per_refill" VALUE="{$prescription->per_refill|escape:'html'}" />
{else}
  &nbsp; &nbsp; # {xl t='of tablets'}:
  <input class="input-sm" TYPE="TEXT" ID="per_refill" NAME="per_refill" SIZE="2" MAXLENGTH="10" VALUE="{$prescription->per_refill|escape:'html'}" />
{/if}
</td>
</tr>
<tr>
<td COLSPAN="1" class="text" ALIGN="right" VALIGN="MIDDLE" >{xl t='Notes'|escape:'html'}</td>
<td COLSPAN="2" class="text" ALIGN="LEFT" VALIGN="MIDDLE" >

github.com

openemr/openemr/blob/master/controllers/C_Prescription.class.php#L535-L538




function get_prescription_body_text($p)
{
    $body = '<b>' . xlt('Rx') . ': ' . text($p->get_drug()) . ' ' . text($p->get_size()) . ' ' . text($p->get_unit_display());

github.com

openemr/openemr/blob/master/sql/database.sql#L5754


`pid` INT(11),
`portal_username` VARCHAR(100) ,
`portal_pwd` VARCHAR(100) ,
`portal_pwd_status` TINYINT DEFAULT '1' COMMENT '0=>Password Created Through Demographics by The provider or staff. Patient Should Change it at first time it.1=>Pwd updated or created by patient itself',
`portal_salt` VARCHAR(100) ,
PRIMARY KEY (`id`)
)ENGINE=InnoDB AUTO_INCREMENT=1;


-----------------------------------------------------------


--
-- Table structure for table `patient_data`
--


DROP TABLE IF EXISTS `patient_data`;
CREATE TABLE `patient_data` (
`id` bigint(20) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`language` varchar(255) NOT NULL default '',
`financial` varchar(255) NOT NULL default '',
`fname` varchar(255) NOT NULL default '',

also search for ‘note’ here:

github.com

openemr/openemr/blob/master/library/classes/Prescription.class.php

<?php
require_once(dirname(__FILE__) . "/../lists.inc");
//below is required for the set_medication() function

// Below list of terms are deprecated, but we keep this list
//   to keep track of the official openemr drugs terms and
//   corresponding ID's for reference. Official is referring
//   to the default settings after installing OpenEMR.
//
// define('UNIT_BLANK',0);
// define('UNIT_MG',1);
// define('UNIT_MG_1CC',2);
// define('UNIT_MG_2CC',3);
// define('UNIT_MG_3CC',4);
// define('UNIT_MG_4CC',5);
// define('UNIT_MG_5CC',6);
// define('UNIT_MCG',7);
// define('UNIT_GRAMS',8);
//
// define('INTERVAL_BLANK',0);

This file has been truncated. show original

-brady

morevishal · June 21, 2017, 12:00pm

Thank you brady