Change to yet another dumb query.
[openemr.git] / interface / forms / CAMOS / rx_print.php
blob118c10eea2e36ceb6a2b56930c706d6450b97fdf
1 <? include_once ('../../globals.php'); ?>
2 <? include_once ('../../../library/sql.inc'); ?>
3 <html>
4 <head>
5 <title>
6 Four Pane Prescription Printer
7 </title>
8 </head>
9 <body>
11 //practice data
12 $physician_name = '';
13 $practice_fname = '';
14 $practice_lname = '';
15 $practice_title = '';
16 $practice_address = '';
17 $practice_city = '';
18 $practice_state = '';
19 $practice_zip = '';
20 $practice_phone = '';
21 $practice_fax = '';
22 $practice_license = '';
23 $practice_dea = '';
24 //patient data
25 $patient_name = '';
26 $patient_address = '';
27 $patient_city = '';
28 $patient_state = '';
29 $patient_zip = '';
30 $patient_phone = '';
31 $patient_dob = '';
32 $query = sqlStatement("select fname,lname,street,city,state,postal_code,phone_home,DATE_FORMAT(DOB,'%m/%d/%y') as DOB from patient_data where pid =" . $_SESSION['pid']);
33 if ($result = mysql_fetch_array($query, MYSQL_ASSOC)) {
34 $patient_name = $result['fname'] . ' ' . $result['lname'];
35 $patient_address = $result['street'];
36 $patient_city = $result['city'];
37 $patient_state = $result['state'];
38 $patient_zip = $result['postal_code'];
39 $patient_phone = $result['phone_home'];
40 $patient_dob = $result['DOB'];
42 //update user information if selected from form
43 if ($_POST['update']) {
44 $query = "update users set " .
45 "fname = '" . $_POST['practice_fname'] . "', " .
46 "lname = '" . $_POST['practice_lname'] . "', " .
47 "title = '" . $_POST['practice_title'] . "', " .
48 "street = '" . $_POST['practice_address'] . "', " .
49 "city = '" . $_POST['practice_city'] . "', " .
50 "state = '" . $_POST['practice_state'] . "', " .
51 "zip = '" . $_POST['practice_zip'] . "', " .
52 "phone = '" . $_POST['practice_phone'] . "', " .
53 "fax = '" . $_POST['practice_fax'] . "', " .
54 "federaldrugid = '" . $_POST['practice_dea'] . "' " .
55 "where id =" . $_SESSION['authUserID'];
56 sqlInsert($query);
58 //get user information
59 $query = sqlStatement("select * from users where id =" . $_SESSION['authUserID']);
60 if ($result = mysql_fetch_array($query, MYSQL_ASSOC)) {
61 $physician_name = $result['fname'] . ' ' . $result['lname'] . ', ' . $result['title'];
62 $practice_fname = $result['fname'];
63 $practice_lname = $result['lname'];
64 $practice_title = $result['title'];
65 $practice_address = $result['street'];
66 $practice_city = $result['city'];
67 $practice_state = $result['state'];
68 $practice_zip = $result['zip'];
69 $practice_phone = $result['phone'];
70 $practice_fax = $result['fax'];
71 $practice_dea = $result['federaldrugid'];
73 if ($_POST['print']) {
74 $camos_content = array();
75 foreach ($_POST as $key => $val) {
76 if (substr($key,0,3) == 'ch_') {
77 $query = sqlStatement("select content from form_CAMOS where id =" .
78 substr($key,3));
79 if ($result = mysql_fetch_array($query, MYSQL_ASSOC)) {
80 $content = preg_replace('|\n|','<br/>', $result['content']);
81 $content = preg_replace('|<br/><br/>|','<br/>', $content);
82 array_push($camos_content,$content);
87 <link rel="stylesheet" type="text/css" href="./rx.css" />
88 </head>
89 <body>
90 <img src='./hline.jpg' id='hline'>
91 <img src='./vline.jpg' id='vline'>
93 if ($camos_content[0]) { //decide if we are printing this rx
95 <div id='rx1' class='rx' >
96 <div class='topheader'>
98 print $physician_name . "<br/>\n";
99 print $practice_address . "<br/>\n";
100 print $practice_city . ", ";
101 print $practice_state . " ";
102 print $practice_zip . "<br/>\n";
103 print $practice_phone . "<br/>\n";
104 print 'DEA: ' . $practice_dea;
106 </div>
107 <hr/>
108 <div class='bottomheader'>
110 print "<span class='mytagname'> Name:</span>\n";
111 print "<span class='mydata'> $patient_name </span>\n";
112 print "<span class='mytagname'> Address: </span>\n";
113 print "<span class='mydata'> $patient_address, $patient_city, " .
114 "$patient_state $patient_zip </span><br/>\n";
115 print "<span class='mytagname'>Phone:</span>\n";
116 print "<span class='mydata'>(954) 446 - 6958</span>\n";
117 print "<span class='mytagname'>DOB:</span>\n";
118 print "<span class='mydata'> $patient_dob </span>\n";
119 print "<span class='mytagname'>Date:</span>\n";
120 print "<span class='mydata'>" . date("F m, Y") . "</span><br/><br/>\n";
121 print "<div class='symbol'>Rx</div><br/>\n";
123 </div>
124 <div class='content'>
126 print $camos_content[0];
128 </div>
129 <div class='signature'>
130 ______________________________________________<br/>
131 Signature
132 </div>
133 </div> <!-- end of rx block -->
135 } // end of deciding if we are printing the above rx block
136 else {
137 print "<img src='./xout.jpg' id='rx1'>\n";
141 if ($camos_content[1]) { //decide if we are printing this rx
143 <div id='rx2' class='rx' >
144 <div class='topheader'>
146 print $physician_name . "<br/>\n";
147 print $practice_address . "<br/>\n";
148 print $practice_city . ", ";
149 print $practice_state . " ";
150 print $practice_zip . "<br/>\n";
151 print $practice_phone . "<br/>\n";
152 print 'DEA: ' . $practice_dea;
154 </div>
155 <hr/>
156 <div class='bottomheader'>
158 print "<span class='mytagname'> Name:</span>\n";
159 print "<span class='mydata'> $patient_name </span>\n";
160 print "<span class='mytagname'> Address: </span>\n";
161 print "<span class='mydata'> $patient_address, $patient_city, " .
162 "$patient_state $patient_zip </span><br/>\n";
163 print "<span class='mytagname'>Phone:</span>\n";
164 print "<span class='mydata'>(954) 446 - 6958</span>\n";
165 print "<span class='mytagname'>DOB:</span>\n";
166 print "<span class='mydata'> $patient_dob </span>\n";
167 print "<span class='mytagname'>Date:</span>\n";
168 print "<span class='mydata'>" . date("F m, Y") . "</span><br/><br/>\n";
169 print "<div class='symbol'>Rx</div><br/>\n";
171 </div>
172 <div class='content'>
174 print $camos_content[1];
176 </div>
177 <div class='signature'>
178 ______________________________________________<br/>
179 Signature
180 </div>
181 </div> <!-- end of rx block -->
183 } // end of deciding if we are printing the above rx block
184 else {
185 print "<img src='./xout.jpg' id='rx2'>\n";
189 if ($camos_content[2]) { //decide if we are printing this rx
191 <div id='rx3' class='rx' >
192 <div class='topheader'>
194 print $physician_name . "<br/>\n";
195 print $practice_address . "<br/>\n";
196 print $practice_city . ", ";
197 print $practice_state . " ";
198 print $practice_zip . "<br/>\n";
199 print $practice_phone . "<br/>\n";
200 print 'DEA: ' . $practice_dea;
202 </div>
203 <hr/>
204 <div class='bottomheader'>
206 print "<span class='mytagname'> Name:</span>\n";
207 print "<span class='mydata'> $patient_name </span>\n";
208 print "<span class='mytagname'> Address: </span>\n";
209 print "<span class='mydata'> $patient_address, $patient_city, " .
210 "$patient_state $patient_zip </span><br/>\n";
211 print "<span class='mytagname'>Phone:</span>\n";
212 print "<span class='mydata'>(954) 446 - 6958</span>\n";
213 print "<span class='mytagname'>DOB:</span>\n";
214 print "<span class='mydata'> $patient_dob </span>\n";
215 print "<span class='mytagname'>Date:</span>\n";
216 print "<span class='mydata'>" . date("F m, Y") . "</span><br/><br/>\n";
217 print "<div class='symbol'>Rx</div><br/>\n";
219 </div>
220 <div class='content'>
222 print $camos_content[2];
224 </div>
225 <div class='signature'>
226 ______________________________________________<br/>
227 Signature
228 </div>
229 </div> <!-- end of rx block -->
231 } // end of deciding if we are printing the above rx block
232 else {
233 print "<img src='./xout.jpg' id='rx3'>\n";
237 if ($camos_content[3]) { //decide if we are printing this rx
239 <div id='rx4' class='rx' >
240 <div class='topheader'>
242 print $physician_name . "<br/>\n";
243 print $practice_address . "<br/>\n";
244 print $practice_city . ", ";
245 print $practice_state . " ";
246 print $practice_zip . "<br/>\n";
247 print $practice_phone . "<br/>\n";
248 print 'DEA: ' . $practice_dea;
250 </div>
251 <hr/>
252 <div class='bottomheader'>
254 print "<span class='mytagname'> Name:</span>\n";
255 print "<span class='mydata'> $patient_name </span>\n";
256 print "<span class='mytagname'> Address: </span>\n";
257 print "<span class='mydata'> $patient_address, $patient_city, " .
258 "$patient_state $patient_zip </span><br/>\n";
259 print "<span class='mytagname'>Phone:</span>\n";
260 print "<span class='mydata'>(954) 446 - 6958</span>\n";
261 print "<span class='mytagname'>DOB:</span>\n";
262 print "<span class='mydata'> $patient_dob </span>\n";
263 print "<span class='mytagname'>Date:</span>\n";
264 print "<span class='mydata'>" . date("F m, Y") . "</span><br/><br/>\n";
265 print "<div class='symbol'>Rx</div><br/>\n";
267 </div>
268 <div class='content'>
270 print $camos_content[3];
272 </div>
273 <div class='signature'>
274 ______________________________________________<br/>
275 Signature
276 </div>
277 </div> <!-- end of rx block -->
279 } // end of deciding if we are printing the above rx block
280 else {
281 print "<img src='./xout.jpg' id='rx4'>\n";
284 </body>
285 </html>
288 else {//pick
290 <h1>Select CAMOS Entries for printing</h1>
291 <form method=POST name='pick_items'>
293 $query = sqlStatement("select x.id as id, x.category, x.subcategory, x.item from " .
294 "form_CAMOS as x join forms as y on (x.id = y.form_id) " .
295 "where y.encounter = " . $_SESSION['encounter'] .
296 " and x.pid = " . $_SESSION['pid'] . " and x.activity = 1");
297 $results = array();
298 while ($result = mysql_fetch_array($query, MYSQL_ASSOC)) {
299 echo "<input type=checkbox name='ch_" . $result['id'] . "'>" .
300 $result['category'] . ':' . $result['subcategory'] . ':' . $result['item'] . "<br/>\n";
303 <input type=submit name=print value=print>
304 </form>
305 <h1>Update User Information</h1>
306 <form method=POST name='pick_items'>
307 <table>
308 <tr>
309 <td> First Name: </td>
310 <td> <input type=text name=practice_fname value ='<? echo $practice_fname; ?>'> </td>
311 </tr>
312 <tr>
313 <td> Last Name: </td>
314 <td> <input type=text name=practice_lname value ='<? echo $practice_lname; ?>'> </td>
315 </tr>
316 <tr>
317 <td> Title: </td>
318 <td> <input type=text name=practice_title value ='<? echo $practice_title; ?>'> </td>
319 </tr>
320 <tr>
321 <td> Street Address: </td>
322 <td> <input type=text name=practice_address value ='<? echo $practice_address; ?>'> </td>
323 </tr>
324 <tr>
325 <td> City: </td>
326 <td> <input type=text name=practice_city value ='<? echo $practice_city; ?>'> </td>
327 </tr>
328 <tr>
329 <td> State: </td>
330 <td> <input type=text name=practice_state value ='<? echo $practice_state; ?>'> </td>
331 </tr>
332 <tr>
333 <td> Zip: </td>
334 <td> <input type=text name=practice_zip value ='<? echo $practice_zip; ?>'> </td>
335 </tr>
336 <tr>
337 <td> Phone: </td>
338 <td> <input type=text name=practice_phone value ='<? echo $practice_phone; ?>'> </td>
339 </tr>
340 <tr>
341 <td> Fax: </td>
342 <td> <input type=text name=practice_fax value ='<? echo $practice_fax; ?>'> </td>
343 </tr>
344 <tr>
345 <td> DEA: </td>
346 <td> <input type=text name=practice_dea value ='<? echo $practice_dea; ?>'> </td>
347 </tr>
348 </table>
349 <input type=submit name=update value=update>
350 </form>
354 } //end of else statement
355 //$query = sqlStatement("");
356 //while ($result = mysql_fetch_array($query, MYSQL_ASSOC)) {
359 </body>
360 </html>
363 //FUNCTIONS